Forum Discussion
Excel program help for a prediction league
I'll take a look at all you've done when I have some time--it's a busier weekend than normal around my home. Glad you've figured things out.
When it comes to ranking, you might find some of the colored conditional formatting methods helpful. Here's one example, as it only goes from dark green through yellow, to red, in graduated shades, illustrating in this case the number of times each person (the vertical column in each case is a person) has gotten, over the course of time, a given score for daily competition
What I mean is, instead of sorting the names--although that's doable--highlight the lowest/highest scores by means of colors, but keep the names all in alphabetical order. That way a person always knows where they are on this list alphabetically, and can tell quickly where they stand in the ranking based on the color.
Here's the portion of the Conditional Formatting dialog box that applies.
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.
