Sale!

2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet

Original price was: $15.00.Current price is: $5.00.

Below some of the features of the sweepstakes spreadsheet for the upcoming 2019 African Cup of Nations in Egypt, including automatic update of the actual match results so that you don’t have to.

NEW: UEFA Champions League Qualifying Rounds

Our 2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet will allow groups of up to 50 people to run a sweepstakes or pool based on the outcomes of the group and knockout matches.

So

  • download the files,
  • send the input file to your friends and ask them to return it with their predictions,
  • update the master file and
  • that’s it.

We do the rest. See detailed instructions and video clips below

SKU: 2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet Category: Tags: ,

Description

Our 2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet (built in Excel) will allow you to:

Update: See all our latest fun office pool sweepstake spreadsheets for sporting events
  • Automatically update the actual scores when the tournament is on, direct to the spreadsheet (no need to capture them yourself!)
  • UEFA rankings included for countries you are not familiar with. This will assist you with the comparative rankings to make better predictions for the tournament
  • Input your predictions and compare them to what actually happens
  • See the likely group winners after adjusting your predictions for the actual results (including the more complex 3rd place finishers who progress).
  • Automatically addresses the tiebreaker rules for France 2019 where sides on equal points are split based on the matches between the tied teams .
  • Automatic update notification when new versions become available

Much like the other spreadsheets we have built for other sporting events, all this is done without any VBA macros!



The spreadsheet is built in Microsoft Excel 2013 but will work in all versions with some loss of functionality if you are using Excel 2003 and Excel for Mac.

Screenshots and instructions for use

For the Organiser- Initial Setup

The setup is exactly the same as for the Women’s World Cup 2019 in France so below watch these video clip or read the instructions below.

Once you purchase the spreadsheet, you will be able to download a zip file which contains 2 files as shown below.

France Women's World Cup 2019 Spreadsheet

The first file (‘2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet-v1-SweepstakesInput2003’) is what you need to send to the other players.

The second file (‘2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet-v1-Sweepstakes-upto-50_2003’) is for the organiser and is where all the predictions are saved, where the match scores are automatically updated, and the sweepstake points are compiled.

Before you send the files out, you will need to decide on the point scoring.

When you open up the ‘2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet-v1-Sweepstakes-upto-50_2003’ spreadsheet, and go to the instructions sheet, you will be able to decide how the points work.

France Women's World Cup 2019 Spreadsheet

As noted above you can decide on the points scored by each player for predicting certain aspects of the matches and tournament. We have inserted some defaults. Your options are:

Group Stages

  • Getting the right result irrelevant of the score (i.e. win, loss, draw)
  • Getting team 1’s correct number of goals (e.g. you predicted 1-1 and the score was 1-0)
  • Getting team 2’s correct number of goals (e.g. you predicted 3-2 and the score was 2-2)
  • Correctly guessing the net goals even if it is the wrong way (e.g. you predicted 2-0 i.e. a +2 margin and the result was 0-2 i.e. a -2 margin)- Depending on your feeling you may switch this off by making it zero. See more about this option
  • Correctly guessing the net goals and the correct way e.g. you choose 0-2 and the score is 2-4 you get points. See more about this option

Knockout Stages

  • Each correct team in the last 16
  • Each correct team in the Qtr Finals
  • Each correct team in the Semi Finals
  • Each correct team in the third place playoff
  • Each Correct Team in the Finals
  • Correct third Place
  • Correct Winner

Once you have decided this, you can inform the players of how it will work and send them the ‘2019 African Cup of Nations in Egypt Sweepstakes Spreadsheet-v1-SweepstakesInput2003’ spreadsheet.

 

Instructions for the Players

Watch the video clip or read the instructions below (the layout is the same as the Euro 2016 sweepstake spreadsheet we created)

When the players receive their spreadsheets they need to make their predictions. On the ‘Player’ sheet (shown below)

France Women's World Cup 2019 Spreadsheet

  • Enter your name (if the group has similarly named people use a unique name)
  • Enter your predictions of the scores in the blue cells (column G and I)
  • As you enter your scores the group standings in column O will be updated so that you can see who is going to progress to the next round (top 2 of each group and the 4 best 3rd placed teams).
  • Note: per the competition rules, teams on the same number of points will be separated by comparing their head to head results first, before net goals and goals scored. The spreadsheet will take this into account.
  • The spreadsheet will also work out the top 4 3rd placed teams and correctly place them in the knockout round.
  • Note: Because of the complex rules to decide who progresses, we suggest you look at the resultant knockout matches and make sure you are happy with the teams progressing. If it is not what you want, change some of the scores.
  • Once you have completed predicting the group stages, the knockout round will auto populate and you can predict the scores in these matches.
  • Note: at this stage you only get points for who progresses. Predict a winner in each match instead of a draw and penalties.

France Women's World Cup 2019 Spreadsheet

  • You complete the knockout phase until you get to a winner.
  • Save the file and send it back to the organiser.

Organiser

Watch the video clip or read the instructions below (the layout is the same as the Euro 2016 sweepstake spreadsheet we created)

When the organiser receives back the spreadsheets, they need to capture the players predictions into the masterfile. This is very easy:

  • Open the masterfile and the player predictions spreadsheet
  • In the player predictions spreadsheet, copy from cell F9 to cell J84.

France Women's World Cup 2019 Spreadsheet

  • Go to the masterfile, choose one of the player sheets (e.g. player 1) and PASTE AS VALUES in cell T9.
  • In case it isn’t emphasized enough, PASTE AS VALUES.

France Women's World Cup 2019 Spreadsheet

  • Do this for all the players.
  • You can change the sheet names to reflect the player’s name.

Once you have done this you are all done!

 

During the Egypt 2019 tournament

During the tournament, all you have to do is open the master spreadsheet and let it connect to the internet. We will update the match scores periodically and these will be pulled through to the spreadsheet (to see how we do this, look at the video on Importing data from the web ).

As shown below, on the Masterfile sheet, as the real scores come through the cell colours will change to show that it is an actual score.

Euro-2016-spreadsheet-sweepstakes-6-automatic-update-of-scores

On the player’s sheets, as the real scores come in, you will see the matches that are finished (dotted cells), the total sweepstake points scored and a breakdown of how the points were earned.

Euro-2016-spreadsheet-sweepstakes-7-sweepstake-scoring

On the ‘Overall Pnts’ sheet you can see a table ranking all the players. There is also a graph sheet showing the player rankings as each match progresses.

France Women's World Cup 2019 Spreadsheet

There is also a chart sheet showing the player rankings as each match progresses (worm chart). As shown below with one from the men’s tournament in Russia in 2018, it is generally tight!

France Women's World Cup 2019 Spreadsheet

 

Feedback from previous sweepstakes spreadsheet

Our most recent sweepstake spreadsheet was for the rugby world cup.

Games were played all over the world. Some feedback from a pub in New Zealand

World-Cup-Rugby-2015-spreadsheet-sweepstake-winnerHi Adrian.

Well all finished and what a great result for us. [NEW ZEALAND WON 🙁 ]. The winner of our picks was April Barnett. We had 40 entries which was a good number.

Attached is a photo of her holding the cash in our rugby club rooms at Dunsandel. Thanks for all your help

Russell

 

FAQ

Q: Is there points awarded for actually predicting the scores of the knock out games or just the teams playing?

  • It is just for the teams playing. Getting the scores right does not add to the points

Q: Lastly, I put in some results just to see how it worked and I put a draw for some of the knock out games. It seemed to randomly select one of the teams to go though. How does this work?

  • For the knock out matches you need to have a winner.

Q: Can you use the spreadsheet on Google Docs

  • It wasn’t built with Google Docs in mind, but some users have tried it and say it works. As an idea get all the information via Excel and then upload the masterfile to Google Docs and allow the players to see what is happening. Only limitation is that it won’t automatically update so you will need update the scores

Q: Will you score points for correct team through to the finals (1/4, 1/2 and final) regardless of if the team advanced from a first or second place in the group stage? Or do you have to predict the correct placing in the group stage to score points?

  • You get points for your chosen teams getting to the next stage. How they got there is not important

Q: Can you confirm that for the knockout stages, we can enter decimal places and the master file will be able to recognise that because the actual scores are going to update themselves so will it be done in a the format to give points correctly etc

  • Yes, use a decimal if you want to indicate that there was a penalty shootout. See the note below about decimals though

Q: Hello. I’m having issues opening the spreadsheet on my Mac.
It gives me an error message and just opens as a “read-only” file.
How can I go about fixing this issue?

  • Try and expand it out of the zip files and save it in a separate location