# Maybe a better way?

#### zendog1960

##### Active Member
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

The two sheets will be posted seperately following this post.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### zendog1960

##### Active Member
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

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

#### zendog1960

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

Replies
1
Views
129
Replies
4
Views
97
Replies
12
Views
173
Replies
2
Views
65
Replies
0
Views
257