How can I total Preview Sheet in Little League Database

[BigBuck98]

I'm keeping the database for our local little league and we are having
previews this Saturday. I have a worksheet that has the players number,
name, age plus the areas that they will be tested on, hitting, throwing,
running, etc.
They will be graded on each one of these areas and will receive a score of 1
to 5, plus a total of the 5 areas that they will be tested on. There will be
5 Managers giving each player a score.
My questions is, what is the best way to enter the scores from each of these
Managers into a master worksheet and come up with a grand total for each
player?
I was thinking of having 6 rows for each player and entering the score from
each manager on each row and then have the 6th row to total everything, but
I thought that maybe there is an easier way to do this.
By the way I am using Excel 97.
Thanks for your help.
Gordon

 

[Dave R.]

I would use 6 COLUMNS per player, and one row-- not six rows. The columns
since they contain numbers will be compact enough to make it easy to read
and make your way around the data. Plus, there is a limit on the number of
columns you could use, which might be gobbled up quickly by using 6 rows per
player.

For example:

Name Age Team Score1 Score2 Score3 Score4 Score5 CombinedScore
Bill 15 NYY 5 5 4 5 3
22
Sam 46 UHK etc.


A layout like that would make it easy to use formulas to summarize the data,
where if data were laid out like:
Name Bill
Team NYY
Score1 5
Score2 5
...
CombinedScore 22

Name Sam
Team UHK
Score1 3
Score2 4
...
CombinedScore 20



... it would be tougher to summarize with formulas, and you would have a big
blank section of worksheet in front of you to the right of the actual data.
Good luck.

 

[leinad512]

I would suggest you have column headings
"Number","Name","Age","Hitting","Throwing",Running",etc, "Total"
You sound like you already have Number, Name and Age filled in, simply
put the scores for each skill on the row for that player in the
appropriate skill's column. Then if the Skill columns are D, E, F, G,
H, and I, to sum the second row you would put the formula
"=sum(D2:I2)" in cell J2. You can copy and paste this formula down the
rest of the Sum column and it will sum each row for you.