08-29-2018, 11:45 AM
Can someone who is an expert at creating complex spreadsheets help me with the tabulation sheet?
The data input for each entry will be [username],[stanford score],[opponent score]. The sheet will have to apply the rules to calculate the prediction error, correct winner predicted, bonus points, and penalty points. The results will then need to be sorted according to the rules so the game points can be awarded.
The spreadsheet would need to be able to keep a running total of each user's score as the season progresses. I would like this to be done with an automated script, if possible.
Another issue is how to format the results so they can be posted and read on this board.
The data input for each entry will be [username],[stanford score],[opponent score]. The sheet will have to apply the rules to calculate the prediction error, correct winner predicted, bonus points, and penalty points. The results will then need to be sorted according to the rules so the game points can be awarded.
The spreadsheet would need to be able to keep a running total of each user's score as the season progresses. I would like this to be done with an automated script, if possible.
Another issue is how to format the results so they can be posted and read on this board.
Put a glide in your stride and a dip in your hip.