Maybe a better way?

[zendog1960]

I am working on a spreadsheet to track my bowling teams scores, averages, wins, losses,best average, high game, etc... I have it working but it seems the formulas is extraordinarily huge. I would like to see is there would be some things I can do to simplify the formulas.

I have about 11 Sheets. I am not going to expect anyone to look over the entire worrkbook but maybe just two sheets as they are the core of the entire woorkbook.

The first sheet is 'Weekly Scores' This is where I input the weeekly scores.
The Second sheet is just one of seven bowlers personal sheet keeping track of each game, and some other stats. This is where the formulas are starting to get crazy and I would like to see if I can cut them down to a more managable size.

Please post your comments and suggestions clearly so I don't end up F-ing up the whole workbook up! LOL

Thanks in advanced:

The two sheets will be posted seperately following this post.

 

[zendog1960]

Weekly Scores Sheet

Baddabing Bowling-5 Man.xls
	A	B	C	D	E	F	G	H
3	Player	Scratch Handicap	Game 1	Game 2	Game 3	Series	Hcp	Average
4	Phil	Scratch	125	168	172	465	52	155
5		Handicap	177	220	224	621		207
6	Brad	Scratch	177	182	172	531	34	177
7		Handicap	211	216	206	633		211
8	Guy	Scratch	160	178	183	521	36	174
9		Handicap	196	214	219	629		210
10	Dave	Scratch	156	184	168	508	40	169
11		Handicap	196	224	208	628		209
12	Jim	Scratch	169	174	201	544	31	181
13		Handicap	200	205	232	637		212
14	Scratch Totals		787	886	896	2569	579
15	Handicap Totals		980	1079	1089	3148
16	Wins			X	X	X	Total Pins
Weekly Scores

 

[zendog1960]

Team Members Personal Sheet

Baddabing Bowling-5 Man.xls
	A	B	C	D	E	F	G	H	I
1	Jim				Scratch Series	Hdcp Series	Scratch Average	Hdcp Average	Handicap
2	Week	Game 1	Game 2	Game 3
3	1	169	174	201	544		181	212	31
4	2	-	-	-
5	3	-	-	-
6	4	139	143	152	434		145	145
Jim

 

[zendog1960]

I knoticed the formulas are not showing completely so here is what is in the second table in call B3:

=IF(ISERROR(INDEX('Weekly Scores'!$A$3:$E$13, MATCH("Jim",'Weekly Scores'!$A$3:$A$13,), MATCH("Game 1",'Weekly Scores'!$A$3:$E$3,))),"-",(INDEX('Weekly Scores'!$A$3:$E$13, MATCH("Jim",'Weekly Scores'!$A$3:$A$13,), MATCH("Game 1",'Weekly Scores'!$A$3:$E$3,))))

What I was trying to do is first to check to see if this bowler bowled that week. If he did not, then a "-" was placed in B#, if he did bowl, then his game one score was placed in B3. This repeats for all 36 weeks, 3 games a week for this and each of the other 6 bowlers.

So you can see this is a huge amount of formulas that I perticularly do not want to input over and over again! LOL

 

[zendog1960]

Now that it is the work week, I am hoping someone can help with simplifying the formulas. any suggestions would greatly be appreciated!

 

[zendog1960]

Just wanted to get this up at the top of the list so it doesn't get missed by the gurus here!