Hey everyone –
Happy Monday! I finally updated the points tracking spreadsheet template to account for any changes your league may have made for the mid-season draft. Download the doc here and follow these steps below to use it:
- Copy and paste the values from the “League Member Teams” and “Contestant Scores” tabs of your original sheet. Don’t copy the entire tab into the new document, just copy the values you entered. Your points for episodes 1-5 will update automatically.
- In the new tab – “Teams – Post Mid-season Draft,” enter in your league members updated teams the same way you entered their original teams in “League Member Teams.” If someone kept their team in tact, and earned the bonus 50 points, enter “50” into the “50 Point Bonus?” row (row 30). You’ll continue to enter weekly contestant scores in the “Contestant Scores” tab.
- You’re done! The following tabs (Episodes 6 – 10) will pull info from the post mid-season draft tab and update your weekly points accordingly.
Leave us a comment if you have any questions!
Becca and Jorie