Hi all. This is my first post here. I was referred here by Mike at ExcelisFun on youtube. He suggested I ask you fine people to see if anyone can help me with my <strikethrough><del>quandary</del></strikethrough> labour of love .
Every 4 years when the World Cup is on my friends and I run a small world cup predictions competition between ourselves. We all put in $50 each and the top 3 win some ca$h.
It started back in the 2002 world cup, being the 'computer guy' in the group and at the time knowing a little bit about Excel, I decided to create a 'small' spreadsheet to keep track of everyone's progress during the event. As I also knew a bit of html I worked out how to save the excel file as html and uploaded it to my server for all to see their progress via the web. What started as a 5-6 person small comp back in 2002 (which we started 1 week into the event) has now turned into an elaborate spreadsheet which I've managed to automate the line up and scoreboard using Vlookups, Ranking and some conditional formatting.
By the next world cup next year, I'd like to finally automate the scoring process, so that when I enter the official score after each game, I'd like excel to automatically work out each persons score (I wish!). BUT... we have so many ways of scoring that I have no idea where to start this process and what formula or combination of formulae to use. I was thinking maybe nested ifs but I think it's going to be really complicated. There's a need for conditional formatting too as the scoring is also colour coded.
I was hoping someone could guide me on what the best way to tackle this would be. I'm not looking for someone to 'do it', just to look at it and suggest ways to go about it and what formulae you would use etc.
Anyway, if anyone is interested in looking at it, I've posted the html of the last comp we did back in 2010. It's just the html file. You can't see the excel formulae, but you can see all the different ways of scoring (the scoring is described in detail and found in the tab at the bottom named scoring description).
Seth Efrica 2010 World Cup Comp v3.0 - Results Page
If you want me to post the actual excel file (if I can here), so you can see further, let me know.
Also, if you like it and you're into the world cup, feel free to use it for your own comp next year. It's been a labour of love of mine for the past 10 years that I'm happy to pass on.
Anyway thanks for reading and if you can, let me know what you think, even if it's to say "no way, you're dreaming!".
Cheers
cRx45
Every 4 years when the World Cup is on my friends and I run a small world cup predictions competition between ourselves. We all put in $50 each and the top 3 win some ca$h.
It started back in the 2002 world cup, being the 'computer guy' in the group and at the time knowing a little bit about Excel, I decided to create a 'small' spreadsheet to keep track of everyone's progress during the event. As I also knew a bit of html I worked out how to save the excel file as html and uploaded it to my server for all to see their progress via the web. What started as a 5-6 person small comp back in 2002 (which we started 1 week into the event) has now turned into an elaborate spreadsheet which I've managed to automate the line up and scoreboard using Vlookups, Ranking and some conditional formatting.
By the next world cup next year, I'd like to finally automate the scoring process, so that when I enter the official score after each game, I'd like excel to automatically work out each persons score (I wish!). BUT... we have so many ways of scoring that I have no idea where to start this process and what formula or combination of formulae to use. I was thinking maybe nested ifs but I think it's going to be really complicated. There's a need for conditional formatting too as the scoring is also colour coded.
I was hoping someone could guide me on what the best way to tackle this would be. I'm not looking for someone to 'do it', just to look at it and suggest ways to go about it and what formulae you would use etc.
Anyway, if anyone is interested in looking at it, I've posted the html of the last comp we did back in 2010. It's just the html file. You can't see the excel formulae, but you can see all the different ways of scoring (the scoring is described in detail and found in the tab at the bottom named scoring description).
Seth Efrica 2010 World Cup Comp v3.0 - Results Page
If you want me to post the actual excel file (if I can here), so you can see further, let me know.
Also, if you like it and you're into the world cup, feel free to use it for your own comp next year. It's been a labour of love of mine for the past 10 years that I'm happy to pass on.
Anyway thanks for reading and if you can, let me know what you think, even if it's to say "no way, you're dreaming!".
Cheers
cRx45
