Sports spreadsheet work out percentage?

Question

Hey All,

as the weeks go on in our sports football tipping comp, I want to work out a graph or calculation to work out, who has the best percentage of winning?

For instance, if each week a person can get a maximum of 16 points, if they get 8 each week.. but someone else gets 6 each week... can you do a sum or graph to represent that persons percentage chance of being the winner? data currently available is progressive score, week by week score and a few line graphs to resemble this.

Answer 1

Go to www.mrexcel.com and look for his free baseball team spreadsheet. It may help you solve your problem.