Hey guys, I have found a previous thread that gets pretty in depth with making a spreadsheet for an archery league. While I can make heads or tails of the spreadsheet, a friend of mine who runs the leagues (is not very computer literate), he basically told me I need to make it idiot proof. So does anyone have an idea of how I can take 709588-league-spreadsheet.xls and make it more user friendly. Basically all we need is the ability to rank teams based upon points. Figure a persons handicap and we would be typing in the points a team won manually, scratch score manually.

Should I just make a spreadsheet that the scratch score can be typed in, and it would: 1. auto figure handicap 2. figure scratch + handicap
THen based upon entry of how many points won, figures team standing.

The part that would get tricky is when were in weeks 7,8,9,10 and we are trying to figure the revolving averages for handicap. The formulas tend to get long, tricky and confusing.

Please let me know your thoughts.

Cheers