Forum Discussion
Excel program help for a prediction league
Hi All, I have been running a football prediction league for the past 15 years and I have had to check everyones weekly predictions manually and then inputting onto an excel spread sheet to then form...
Thank you, I have knowledge of conditional formatting although this is not what I am wanting to do with the table to be fair.
Thank you for your support it is much appreciated as it has inspired me to keep going lol.
Thank you for your support it is much appreciated as it has inspired me to keep going lol.
I just wanted to drop in here and reiterate John (mathetes)'s point about having an master database that follows a single table format. There are a number of options I see for you but just imagine the "input table" as John mentioned might be:
Date, UserID, Week#, Team Name, Score, W-L-T
so this isn't as 'pretty' as the example above for Arsenal v Tottenham 2 1 would be spread across 2 (possible non-adjacent) lines like:
2023-06-02, Player1, 1, Arsenal, 2, W
2023-06-02, Player1, 1, Tottenham, 1, L
and then you can in the same table OR separate table have the results and you can 'label' them as UserID = RESULTS
So I'm sure you wonder why the heck I would want to make it look like that. and the answer is that then all weeks and all players have the same format and you can then use excel functions to the the work. ALSO, I can imagine you can use your online Excel to create a FORM for data entry. You can have the users enter the data and the Form will automatically populate that table. YOU could also use that same form under the RESULTS ID and enter the results.
Using a Form has the added benefit of preventing everyone from peeking at or even worse changing other's picks on a shared form.
Date, UserID, Week#, Team Name, Score, W-L-T
so this isn't as 'pretty' as the example above for Arsenal v Tottenham 2 1 would be spread across 2 (possible non-adjacent) lines like:
2023-06-02, Player1, 1, Arsenal, 2, W
2023-06-02, Player1, 1, Tottenham, 1, L
and then you can in the same table OR separate table have the results and you can 'label' them as UserID = RESULTS
So I'm sure you wonder why the heck I would want to make it look like that. and the answer is that then all weeks and all players have the same format and you can then use excel functions to the the work. ALSO, I can imagine you can use your online Excel to create a FORM for data entry. You can have the users enter the data and the Form will automatically populate that table. YOU could also use that same form under the RESULTS ID and enter the results.
Using a Form has the added benefit of preventing everyone from peeking at or even worse changing other's picks on a shared form.