I need to create a new spreadsheet based on a rival club's results spreadsheet.
I'm looking at the other club's spreadsheet and I can see a formula, but I don't know where it is getting some of the data from or where it is defined.
So, as you can see G3 is the addition of F3 and E3. But E3 and F3 are numbers that are 1, 2, 3, 4 or 5, and what each value is worth must be defined somewhere else.
Eg: 1st place = 100 points, 2nd = 75 points, 3rd = 50 points, 4th = 25 points and 5th (or 6th/7th/8th etc.) are 10 points. Each heat judge is worth 10 additional points and so on, to give the final "round" score for the competition. These are all added at the end of the season and placings are awarded.
Where could the data values of E3 and F3 be defined? Is there any way to display all formulas or hidden worksheets or something?
Thanks in advance