Please help..... I am trying to develop a program that will accumulate and
report golf statistics for as many as 250 players who have played in 1 to 20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total score,
total money won, place in the tournament. From the raw data I perform simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments) for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand how
this is compounded by the time I get to the bottom of the summary report. My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple SUM
formula. Any suggestions would be greatly appreciated.

http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,


Peo Sjoblom



"duchem02" wrote in message
...
Please help..... I am trying to develop a program that will accumulate and
report golf statistics for as many as 250 players who have played in 1 to
20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total
score,
total money won, place in the tournament. From the raw data I perform
simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto
the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments)
for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows
perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand
how
this is compounded by the time I get to the bottom of the summary report.
My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple
SUM
formula. Any suggestions would be greatly appreciated.

Thanks for your suggestion. I have attempted the instructions in the link
but am not finding success. Perhaps, if I could send you or anyone else a
small sample of my project, it would make more sense.

"Peo Sjoblom" wrote:

http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,


Peo Sjoblom



"duchem02" wrote in message
...
Please help..... I am trying to develop a program that will accumulate and
report golf statistics for as many as 250 players who have played in 1 to
20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total
score,
total money won, place in the tournament. From the raw data I perform
simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto
the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments)
for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows
perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand
how
this is compounded by the time I get to the bottom of the summary report.
My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple
SUM
formula. Any suggestions would be greatly appreciated.

It appears that I have gotten it. I am using an INDIRECT equation which
appears to be on the right track. After I add in new data this weekend, I
will know for sure.

"duchem02" wrote:

Thanks for your suggestion. I have attempted the instructions in the link
but am not finding success. Perhaps, if I could send you or anyone else a
small sample of my project, it would make more sense.

"Peo Sjoblom" wrote:

http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,


Peo Sjoblom



"duchem02" wrote in message
...
Please help..... I am trying to develop a program that will accumulate and
report golf statistics for as many as 250 players who have played in 1 to
20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total
score,
total money won, place in the tournament. From the raw data I perform
simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto
the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments)
for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows
perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand
how
this is compounded by the time I get to the bottom of the summary report.
My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple
SUM
formula. Any suggestions would be greatly appreciated.