software

Can anyone suggest a way of doing this ...

I have a file detailing the results of 10 Area Managers. Each AM has a
Sheet - column A lists weekdays throughout the year and C - J represent 8
product groups. On a daily basis the results for each AM are entered on
his/her Sheet.

I need a summary sheet that will show the results between any given periods
during the year. I can only think of doing this using SUMPRODUCT (and gt;=,
lt;= parameters) but that would seem to mean having to create 80 (ie; 10 x 8)
named ranges.

Is there a simpler way?

Many thanks.
Terry,
what are the data in columns C:J? If they are product quantities with
different prices then, yes, you would need a more complex formula. If
they are all monetary amounts then you have no problem summing over
more than one columns. E.g.:

=SUMPRODUCT(--(A2:A101gt;3)*--(A2:A101lt;10)*(C2:J101))

will include in the sum all columns from the pertinent rows.

Does this help?
Kostis VezeridesHi Terry

It needn't be that complicated.
Group the sheets 2 through 10 that refer to the individual AM's, by
selecting the tab of the first one, hold down shift and press the tab of
the last one (ensure that your summary sheet is not within this
grouping.

In cell L2 of any of the grouped sheets enter
=SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)

Change the range from 100 to 10,000 or as many rows as you are likely to
have on each sheet.
Drag the formula across through M2:S2

Click on your Summary sheet, this will ungroup the others.

In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in cell A13
In cell C3 enter your product titles as per C:J from the AMSheets.

In cell C3 enter =Sheet1!L2
In cell C4 enter =Sheet2!L2 and continue down through C5:C13 stepping
up the sheet number each time.
Copy C3:C13 and copy across through D3:J3

Now, when you enter a date in cell A1 on Summary, you will have the
monthly totals for each Manager for each product.

--
Regards

Roger Govierquot;Terry Bennettquot; gt; wrote in message
...
gt; Can anyone suggest a way of doing this ...
gt;
gt; I have a file detailing the results of 10 Area Managers. Each AM has
gt; a Sheet - column A lists weekdays throughout the year and C - J
gt; represent 8 product groups. On a daily basis the results for each AM
gt; are entered on his/her Sheet.
gt;
gt; I need a summary sheet that will show the results between any given
gt; periods during the year. I can only think of doing this using
gt; SUMPRODUCT (and gt;=, lt;= parameters) but that would seem to mean having
gt; to create 80 (ie; 10 x 8) named ranges.
gt;
gt; Is there a simpler way?
gt;
gt; Many thanks.
gt;
Thanks for the suggestions guys - I will have a play-around and see how I
get on!

Only thing I don't follow are the quot;--quot; symbols within the SUMPRODUCT
formula. What effect do these have?

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Terry
gt;
gt; It needn't be that complicated.
gt; Group the sheets 2 through 10 that refer to the individual AM's, by
gt; selecting the tab of the first one, hold down shift and press the tab of
gt; the last one (ensure that your summary sheet is not within this grouping.
gt;
gt; In cell L2 of any of the grouped sheets enter
gt; =SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)
gt;
gt; Change the range from 100 to 10,000 or as many rows as you are likely to
gt; have on each sheet.
gt; Drag the formula across through M2:S2
gt;
gt; Click on your Summary sheet, this will ungroup the others.
gt;
gt; In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in cell A13
gt; In cell C3 enter your product titles as per C:J from the AMSheets.
gt;
gt; In cell C3 enter =Sheet1!L2
gt; In cell C4 enter =Sheet2!L2 and continue down through C5:C13 stepping up
gt; the sheet number each time.
gt; Copy C3:C13 and copy across through D3:J3
gt;
gt; Now, when you enter a date in cell A1 on Summary, you will have the
gt; monthly totals for each Manager for each product.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Terry Bennettquot; gt; wrote in message
gt; ...
gt;gt; Can anyone suggest a way of doing this ...
gt;gt;
gt;gt; I have a file detailing the results of 10 Area Managers. Each AM has a
gt;gt; Sheet - column A lists weekdays throughout the year and C - J represent 8
gt;gt; product groups. On a daily basis the results for each AM are entered on
gt;gt; his/her Sheet.
gt;gt;
gt;gt; I need a summary sheet that will show the results between any given
gt;gt; periods during the year. I can only think of doing this using SUMPRODUCT
gt;gt; (and gt;=, lt;= parameters) but that would seem to mean having to create 80
gt;gt; (ie; 10 x 8) named ranges.
gt;gt;
gt;gt; Is there a simpler way?
gt;gt;
gt;gt; Many thanks.
gt;gt;
gt;
gt;
Hi Terry

The quot;--quot; signs are the double unary minus.
They are there to coerce the results of the comparisons (which would
return True or False) into 1's for True and 0's for False so that
Sumproduct has an array of numbers to deal with.

The same effect could be achieved by multiplying by 1, but the use of
the quot;--quot; is thought to be slightly more efficient in calculation terms.
If you want to read more about this, then Bob Phillips has an excellent
treatise on the whole Sumproduct function at
www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards

Roger Govierquot;Terry Bennettquot; gt; wrote in message
...
gt; Thanks for the suggestions guys - I will have a play-around and see
gt; how I get on!
gt;
gt; Only thing I don't follow are the quot;--quot; symbols within the SUMPRODUCT
gt; formula. What effect do these have?
gt;
gt; quot;Roger Govierquot; gt; wrote in message
gt; ...
gt;gt; Hi Terry
gt;gt;
gt;gt; It needn't be that complicated.
gt;gt; Group the sheets 2 through 10 that refer to the individual AM's, by
gt;gt; selecting the tab of the first one, hold down shift and press the tab
gt;gt; of the last one (ensure that your summary sheet is not within this
gt;gt; grouping.
gt;gt;
gt;gt; In cell L2 of any of the grouped sheets enter
gt;gt; =SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)
gt;gt;
gt;gt; Change the range from 100 to 10,000 or as many rows as you are likely
gt;gt; to have on each sheet.
gt;gt; Drag the formula across through M2:S2
gt;gt;
gt;gt; Click on your Summary sheet, this will ungroup the others.
gt;gt;
gt;gt; In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in cell
gt;gt; A13
gt;gt; In cell C3 enter your product titles as per C:J from the AMSheets.
gt;gt;
gt;gt; In cell C3 enter =Sheet1!L2
gt;gt; In cell C4 enter =Sheet2!L2 and continue down through C5:C13
gt;gt; stepping up the sheet number each time.
gt;gt; Copy C3:C13 and copy across through D3:J3
gt;gt;
gt;gt; Now, when you enter a date in cell A1 on Summary, you will have the
gt;gt; monthly totals for each Manager for each product.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Can anyone suggest a way of doing this ...
gt;gt;gt;
gt;gt;gt; I have a file detailing the results of 10 Area Managers. Each AM
gt;gt;gt; has a Sheet - column A lists weekdays throughout the year and C - J
gt;gt;gt; represent 8 product groups. On a daily basis the results for each
gt;gt;gt; AM are entered on his/her Sheet.
gt;gt;gt;
gt;gt;gt; I need a summary sheet that will show the results between any given
gt;gt;gt; periods during the year. I can only think of doing this using
gt;gt;gt; SUMPRODUCT (and gt;=, lt;= parameters) but that would seem to mean
gt;gt;gt; having to create 80 (ie; 10 x 8) named ranges.
gt;gt;gt;
gt;gt;gt; Is there a simpler way?
gt;gt;gt;
gt;gt;gt; Many thanks.
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Roger - your suggestions seemed to have worked-out well (even without the
quot;double unary minusesquot;!) - many thanks for your help.

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Terry
gt;
gt; The quot;--quot; signs are the double unary minus.
gt; They are there to coerce the results of the comparisons (which would
gt; return True or False) into 1's for True and 0's for False so that
gt; Sumproduct has an array of numbers to deal with.
gt;
gt; The same effect could be achieved by multiplying by 1, but the use of the
gt; quot;--quot; is thought to be slightly more efficient in calculation terms.
gt; If you want to read more about this, then Bob Phillips has an excellent
gt; treatise on the whole Sumproduct function at
gt; www.xldynamic.com/source/xld.SUMPRODUCT.html
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Terry Bennettquot; gt; wrote in message
gt; ...
gt;gt; Thanks for the suggestions guys - I will have a play-around and see how I
gt;gt; get on!
gt;gt;
gt;gt; Only thing I don't follow are the quot;--quot; symbols within the SUMPRODUCT
gt;gt; formula. What effect do these have?
gt;gt;
gt;gt; quot;Roger Govierquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi Terry
gt;gt;gt;
gt;gt;gt; It needn't be that complicated.
gt;gt;gt; Group the sheets 2 through 10 that refer to the individual AM's, by
gt;gt;gt; selecting the tab of the first one, hold down shift and press the tab of
gt;gt;gt; the last one (ensure that your summary sheet is not within this
gt;gt;gt; grouping.
gt;gt;gt;
gt;gt;gt; In cell L2 of any of the grouped sheets enter
gt;gt;gt; =SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)
gt;gt;gt;
gt;gt;gt; Change the range from 100 to 10,000 or as many rows as you are likely to
gt;gt;gt; have on each sheet.
gt;gt;gt; Drag the formula across through M2:S2
gt;gt;gt;
gt;gt;gt; Click on your Summary sheet, this will ungroup the others.
gt;gt;gt;
gt;gt;gt; In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in cell A13
gt;gt;gt; In cell C3 enter your product titles as per C:J from the AMSheets.
gt;gt;gt;
gt;gt;gt; In cell C3 enter =Sheet1!L2
gt;gt;gt; In cell C4 enter =Sheet2!L2 and continue down through C5:C13 stepping
gt;gt;gt; up the sheet number each time.
gt;gt;gt; Copy C3:C13 and copy across through D3:J3
gt;gt;gt;
gt;gt;gt; Now, when you enter a date in cell A1 on Summary, you will have the
gt;gt;gt; monthly totals for each Manager for each product.
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Regards
gt;gt;gt;
gt;gt;gt; Roger Govier
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Can anyone suggest a way of doing this ...
gt;gt;gt;gt;
gt;gt;gt;gt; I have a file detailing the results of 10 Area Managers. Each AM has a
gt;gt;gt;gt; Sheet - column A lists weekdays throughout the year and C - J represent
gt;gt;gt;gt; 8 product groups. On a daily basis the results for each AM are entered
gt;gt;gt;gt; on his/her Sheet.
gt;gt;gt;gt;
gt;gt;gt;gt; I need a summary sheet that will show the results between any given
gt;gt;gt;gt; periods during the year. I can only think of doing this using
gt;gt;gt;gt; SUMPRODUCT (and gt;=, lt;= parameters) but that would seem to mean having
gt;gt;gt;gt; to create 80 (ie; 10 x 8) named ranges.
gt;gt;gt;gt;
gt;gt;gt;gt; Is there a simpler way?
gt;gt;gt;gt;
gt;gt;gt;gt; Many thanks.
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Hi Terry

Thanks for the feedback. Glad it worked out for you.
As it happens, in another thread in excel.misc, I have experienced a
problem for the first time using the -- notation, which returned a
#VALUE result, where using the 8 to multiply the matrices produced the
correct result.
I am going to have to re-visit this whole concept again and decide which
way I prefer to operate in the future.

--
Regards

Roger Govierquot;Terry Bennettquot; gt; wrote in message
...
gt; Roger - your suggestions seemed to have worked-out well (even without
gt; the quot;double unary minusesquot;!) - many thanks for your help.
gt;
gt; quot;Roger Govierquot; gt; wrote in message
gt; ...
gt;gt; Hi Terry
gt;gt;
gt;gt; The quot;--quot; signs are the double unary minus.
gt;gt; They are there to coerce the results of the comparisons (which would
gt;gt; return True or False) into 1's for True and 0's for False so that
gt;gt; Sumproduct has an array of numbers to deal with.
gt;gt;
gt;gt; The same effect could be achieved by multiplying by 1, but the use of
gt;gt; the quot;--quot; is thought to be slightly more efficient in calculation
gt;gt; terms.
gt;gt; If you want to read more about this, then Bob Phillips has an
gt;gt; excellent treatise on the whole Sumproduct function at
gt;gt; www.xldynamic.com/source/xld.SUMPRODUCT.html
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Thanks for the suggestions guys - I will have a play-around and see
gt;gt;gt; how I get on!
gt;gt;gt;
gt;gt;gt; Only thing I don't follow are the quot;--quot; symbols within the SUMPRODUCT
gt;gt;gt; formula. What effect do these have?
gt;gt;gt;
gt;gt;gt; quot;Roger Govierquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Hi Terry
gt;gt;gt;gt;
gt;gt;gt;gt; It needn't be that complicated.
gt;gt;gt;gt; Group the sheets 2 through 10 that refer to the individual AM's, by
gt;gt;gt;gt; selecting the tab of the first one, hold down shift and press the
gt;gt;gt;gt; tab of the last one (ensure that your summary sheet is not within
gt;gt;gt;gt; this grouping.
gt;gt;gt;gt;
gt;gt;gt;gt; In cell L2 of any of the grouped sheets enter
gt;gt;gt;gt; =SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)
gt;gt;gt;gt;
gt;gt;gt;gt; Change the range from 100 to 10,000 or as many rows as you are
gt;gt;gt;gt; likely to have on each sheet.
gt;gt;gt;gt; Drag the formula across through M2:S2
gt;gt;gt;gt;
gt;gt;gt;gt; Click on your Summary sheet, this will ungroup the others.
gt;gt;gt;gt;
gt;gt;gt;gt; In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in
gt;gt;gt;gt; cell A13
gt;gt;gt;gt; In cell C3 enter your product titles as per C:J from the AMSheets.
gt;gt;gt;gt;
gt;gt;gt;gt; In cell C3 enter =Sheet1!L2
gt;gt;gt;gt; In cell C4 enter =Sheet2!L2 and continue down through C5:C13
gt;gt;gt;gt; stepping up the sheet number each time.
gt;gt;gt;gt; Copy C3:C13 and copy across through D3:J3
gt;gt;gt;gt;
gt;gt;gt;gt; Now, when you enter a date in cell A1 on Summary, you will have the
gt;gt;gt;gt; monthly totals for each Manager for each product.
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; Regards
gt;gt;gt;gt;
gt;gt;gt;gt; Roger Govier
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Can anyone suggest a way of doing this ...
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I have a file detailing the results of 10 Area Managers. Each AM
gt;gt;gt;gt;gt; has a Sheet - column A lists weekdays throughout the year and C -
gt;gt;gt;gt;gt; J represent 8 product groups. On a daily basis the results for
gt;gt;gt;gt;gt; each AM are entered on his/her Sheet.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; I need a summary sheet that will show the results between any
gt;gt;gt;gt;gt; given periods during the year. I can only think of doing this
gt;gt;gt;gt;gt; using SUMPRODUCT (and gt;=, lt;= parameters) but that would seem to
gt;gt;gt;gt;gt; mean having to create 80 (ie; 10 x 8) named ranges.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Is there a simpler way?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Many thanks.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Typo
gt;using the 8 to multiply
should of course read
using the * to multiply

--
Regards

Roger Govierquot;Roger Govierquot; gt; wrote in message
...
gt; Hi Terry
gt;
gt; Thanks for the feedback. Glad it worked out for you.
gt; As it happens, in another thread in excel.misc, I have experienced a
gt; problem for the first time using the -- notation, which returned a
gt; #VALUE result, where using the 8 to multiply the matrices produced the
gt; correct result.
gt; I am going to have to re-visit this whole concept again and decide
gt; which way I prefer to operate in the future.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Terry Bennettquot; gt; wrote in message
gt; ...
gt;gt; Roger - your suggestions seemed to have worked-out well (even without
gt;gt; the quot;double unary minusesquot;!) - many thanks for your help.
gt;gt;
gt;gt; quot;Roger Govierquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi Terry
gt;gt;gt;
gt;gt;gt; The quot;--quot; signs are the double unary minus.
gt;gt;gt; They are there to coerce the results of the comparisons (which would
gt;gt;gt; return True or False) into 1's for True and 0's for False so that
gt;gt;gt; Sumproduct has an array of numbers to deal with.
gt;gt;gt;
gt;gt;gt; The same effect could be achieved by multiplying by 1, but the use
gt;gt;gt; of the quot;--quot; is thought to be slightly more efficient in calculation
gt;gt;gt; terms.
gt;gt;gt; If you want to read more about this, then Bob Phillips has an
gt;gt;gt; excellent treatise on the whole Sumproduct function at
gt;gt;gt; www.xldynamic.com/source/xld.SUMPRODUCT.html
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Regards
gt;gt;gt;
gt;gt;gt; Roger Govier
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Thanks for the suggestions guys - I will have a play-around and see
gt;gt;gt;gt; how I get on!
gt;gt;gt;gt;
gt;gt;gt;gt; Only thing I don't follow are the quot;--quot; symbols within the
gt;gt;gt;gt; SUMPRODUCT formula. What effect do these have?
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Roger Govierquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Hi Terry
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; It needn't be that complicated.
gt;gt;gt;gt;gt; Group the sheets 2 through 10 that refer to the individual AM's,
gt;gt;gt;gt;gt; by selecting the tab of the first one, hold down shift and press
gt;gt;gt;gt;gt; the tab of the last one (ensure that your summary sheet is not
gt;gt;gt;gt;gt; within this grouping.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; In cell L2 of any of the grouped sheets enter
gt;gt;gt;gt;gt; =SUMPRODUCT(--(TEXT($A$2:$A$100,quot;mm-yyquot;)=TEXT(Sheet1!$A$1,quot;mm-yyquot;)),B2:B100)
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Change the range from 100 to 10,000 or as many rows as you are
gt;gt;gt;gt;gt; likely to have on each sheet.
gt;gt;gt;gt;gt; Drag the formula across through M2:S2
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Click on your Summary sheet, this will ungroup the others.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; In cell A4 Enter Area Manager 1, etc down to Area Manager 10 in
gt;gt;gt;gt;gt; cell A13
gt;gt;gt;gt;gt; In cell C3 enter your product titles as per C:J from the AMSheets.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; In cell C3 enter =Sheet1!L2
gt;gt;gt;gt;gt; In cell C4 enter =Sheet2!L2 and continue down through C5:C13
gt;gt;gt;gt;gt; stepping up the sheet number each time.
gt;gt;gt;gt;gt; Copy C3:C13 and copy across through D3:J3
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Now, when you enter a date in cell A1 on Summary, you will have
gt;gt;gt;gt;gt; the monthly totals for each Manager for each product.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; --
gt;gt;gt;gt;gt; Regards
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; Roger Govier
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Terry Bennettquot; gt; wrote in message
gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt; Can anyone suggest a way of doing this ...
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; I have a file detailing the results of 10 Area Managers. Each AM
gt;gt;gt;gt;gt;gt; has a Sheet - column A lists weekdays throughout the year and C -
gt;gt;gt;gt;gt;gt; J represent 8 product groups. On a daily basis the results for
gt;gt;gt;gt;gt;gt; each AM are entered on his/her Sheet.
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; I need a summary sheet that will show the results between any
gt;gt;gt;gt;gt;gt; given periods during the year. I can only think of doing this
gt;gt;gt;gt;gt;gt; using SUMPRODUCT (and gt;=, lt;= parameters) but that would seem to
gt;gt;gt;gt;gt;gt; mean having to create 80 (ie; 10 x 8) named ranges.
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Is there a simpler way?
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Many thanks.
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;