| A | B | |
|---|---|---|
1 | Single Bracket Instructions | |
2 | How to use this | |
3 | 1 | If you can not edit the other tabs you will need to make a copy of the document for yourself. File --> Make a Copy. |
4 | ||
5 | Filling out your bracket | |
6 | 1 | Once the brackets have been released, the "Your Bracket" tab will populate with the teams in the tournament. Each battle has a dropdown that will only show the teams for that battle. Use the dropdown to pick your winners. ONLY EDIT YELLOW FIELDS! |
7 | ||
8 | Keeping Score | |
9 | 1 | The 'Your Points' tab will automatically score your bracket against the actual results after the matches take place. |
10 | ||
11 | Viewing the Actual Results | |
12 | 1 | The 'Tournament Results' tab will show you the actual results of the tournament in near real time. Do not edit the Tournament Results tab. |
13 | ||
14 | How This Works | |
15 | 1 | The 'Tournament Results' tab uses the importrange() function to pull data in from a master spreadsheet. Jeff maintains the master spreadsheet and will update as quickly as possible. Make sure you don't edit anything on the 'Tournament Results' tab otherwise your bracket will stop working correctly. |
16 | 2 | The 'Your Bracket' tab uses the 'Helper' tab and data validation to allow you to pick the associated teams for the given games. |
17 | 3 | The 'Your Points' tab takes your choices and compares it against the 'Tournament Results' tab and assigns scores accordingly. |
18 | 4 | On the 'Your Bracket' tab, you'll see indicators about each battle once they have been played. If you picked correctly, you will see "Yes!" in green above the battle. If you picked incorrectly, you will see a red background with the actual winner of the battle. |
19 | ||
20 | Bracket Contest Manager [OPTIONAL] | |
21 | 1 | You can use this bracket template and the contest bracket manager template to run a contest that aggregates up to 40 brackets together. |
22 | 2 | Open the hidden tab called 'Contest Bracket Data [HIDDEN]' by clicking on View>Hidden Sheets. |
23 | 3 | Rename the tab '[Your Name] Bracket data'. For example "Trash Panda Bracket Data". On the 'Your Bracket" tab make sure [Your Name] is the same throughout. |
24 | 4 | Click on the grey box between A and 1 in the upper left of the spreadsheet to select all cells on that tab. |
25 | 5 | Right click on that box and choose copy, then right click and choose, Paste>Values only. |
26 | 6 | Share your bracket as "View only" with your Contest Manager to be added to the pool. |
27 | 7 | Your contest manager will take it from there! |
28 | Want to create a contest? Use the template below! | |
29 | March Mammal Madness Contest Manager (Up to 40 participiants) | |
30 | March Mammal Madness Large Contest Manager (More than 40 participants) | |