Option A: World Cup Russia 2018 Sweepstakes Excel Chart

Option A: Ultimate World Cup Russia 2018 Sweepstakes Microsoft Excel Chart!!

The Most Advanced  World Cup Russia 2018 Chart for Microsoft Excel 2010. Should also work on Excel 2007/2013/2016 (download the free demo to test on your system first). Will not work on excel 2003.

*Tournament Ended, File no longer available*

User Guide >Here<

For a quick demonstration of this 2018 Russia World Cup Template, see YouTube Video:

File Contains:

1. Printable and Interactive World Cup 2018 Russia Chart Template for you to fill in during the World Cup or just test out Scenarios and Predictions for your favourite teams! 
 
2. World Cup 2018 Stadium Calendar!

3. Contains 24 timezone times.

4. World Cup 2018 Tables Calendar!

5. Languages (35) : Afrikaans, Arabic (العربية), Bengali (বাঙ্গালী), Bulgarian (български), Chinese 中文 (Simplified), Chinese 中文 (Traditional), Croatia (Hrvatski), Czech (Čeština), Danish (Dansk), Dutch (Nederlands) , ENGLISH, French (Français), German (Deutsch), Greek (ελληνικά), Hebrew (עברית), Hindi (हिन्दी भाषा), Hungarian (Magyar), Indonesian, Icelandic, Italian (Italiano), Japanese (日本の), Korean (한국어), Malay, Norwegian (Norsk), Persian (فارسی), Poland (Polski), Portuguese, Romanian (Român), Russian (русский), Spanish (Español), Swedish (Svenska), Thai (ภาษาไทย), Turkish (Türkçe), Urdu (اردو), Vietnamese (Việt).

6. Contains Country Flags which move with the Team.

7. Option to highlight your favorite team.

8. Ability to add your own Translation, or change/swap team names with Peoples names.

9. Ability to Partially Customize Chart Titles/Name and Create your Own World Cup JPEG Posters! – Create your own interesting Titles now!! – see Guide Here

10. Contains Office pools / Sweepstakes Predictions templates. Create your own mini competitions with your office workers / college friends using the 20* predictions slots! Template also contains partially modifiable point system allowing you to reset prediction accuracy weights /scores or use recommended values. To setup an office predictions tournament, either send out a copy of this file (or the LITE version) or ask players to download from this website for them to fill in their predictions (prior to start of the World Cup) and return their “predictions serial” (rather than the full file) to you, which you load into your office pools/sweepstakes master file. 

* Maximum slots available are 20 and can not be increased due to level of processing resources required to run this file. This file works best with Excel 2010. If you need more predictions slots, suggest you;

- use two or more Master files and merge summary elsewhere, 

- or alternatively use Office Pools spreadsheets created by other people (do a search on the internet),

- or use on-line world cup fantasy leagues created by major organisations (do a  search on the internet nearer the World Cup).

***

More screen shots shown in guide here or see video here

***

Basic Guide to using the SmartCoder 247 Sweepstakes/office pools World Cup 2018 file

-----

Guide to using the SmartCoder 247 Sweepstakes/Office Pools World Cup file to Create a Mini Office Predictions competition (20 slots max**)

Alternatively see the quick video guide here:

Download Master World Cup Sweepstakes / Office Pools file here (Option A)

** Maximum slots available are 20 and can not be increased due to level of processing resources required to run this file. This file works best with Excel 2010. If you need more predictions slots, suggest you;

- use two or more Master files and merge summary elsewhere, 

- or alternatively use Office Pools spreadsheets created by other people (do a search on the internet),

- or use on-line world cup fantasy leagues created by major organisations (do a  search on the internet nearer the World Cup).

Actions Before the World Cup Starts: 

1. The Administrator Downloads the World Cup Russia 2018 Sweepstakes/Office pools Excel file (Option "A" Master File)

2. Within this file,  Go to Home> Predictions Menu> Points System ,  and modify predictions accuracy weights if needed (or just go with defaults):

3. If the Master file (A) can be shared/placed on local drives,  ask users to enter their 64 games predictions directly on blank prediction slots (see screen 1) before the World Cup starts.
If not possible to share Master file (A),  Download and Distribute the LITE Distribute file Option "B" to users and follow steps 3b below. 

    3a. Using Master file (A8) file to enter predictions Direct.

    3b. Using LITE file (B5) file to enter predictions.

        3b.1. Users complete their predictions for all 64 games using the LITE option B file and return just the "predictions serial" to Administrator.

            Example of prediction serial which needs to be returned to your Administrator here:

        3b.2. Administrator loads received predictions to Master file (A) using the load option within the Predictions sheet or via mass import/export sheet.

4. Once the Office/predictions group have completed their predictions and Admin has consolidated those predictions onto the Master file (A), Admin should send a copy of Master file to users to view groups predictions.

During the World Cup:

                  
5.1. Once the World cup starts , the Admin needs to maintain and update Actual scores sheet of the Master file.          

5.2. Admin should provide regular updates/copies of Master file/actual scores serial to user group so they can check their standings using the multiple dashboard included in the master file.

6. Dashboards

The Master file contains a number of dashboards for users to compare their predictions and check their standings within the group.
Actual scores need to be entered manually onto the Master file (chart 1).
(Note: This file does not contain any links to Live score Internet feeds and this file will never ask for internet connection nor send information across the Internet for security reasons).

Example of dashboard  

Note: scores shown in these screen shots are "made up" (i.e. not actual scores) to demonstrate dashboards and graphics capability of file.

 (click on pictures to zoom in)

 

*****