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

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. 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 Purchases the Rugby World Cup Japan 2019 Sweepstakes/Office pools Excel file (Option "A" Master File)

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

screen 1

 screen 2 :

 

3. If the Master file (A) can be shared/placed on local drives,  ask users to enter their 48 games predictions directly on blank prediction slots (see screens 3+ 4) before the World Cup starts.
If not possible to share Master file (A),  Distribute the acompanying Distribution file (D1) to users and follow steps 3b below. 

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

    Screen 3

Screen 4:

     
3b. Using Distribution file (D1) to enter predictions. [File B5 can also be used in place of D1]

        3b.1. Users complete their predictions for all 48 games using the Distribution file (D1) and return the file to Admin or return just the "predictions serial" to Admin.

Screen 5:

            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 (screen 6) or via mass import/export sheet (screen 7). Or see YouTube video here.

 Screen 6:

Screen 7:

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.

*****