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
If we did what you suggested earlier and added each person’s new team addition to the “League Member Team” page and just deleted their point values on Episodes 1-5, are we alright? Or will it not work correctly and should we just use this newer template?
In theory that makes sense to me, though I haven’t actually tested that approach.
The Updated Excel Doc needs to be updated again. You need to put a $ before G2 in cell B2 of sheet Ep #6, and so on.
Formulas messed up on the episode score sheets episode 6 on! Looks like when you copied over from column B to C etc it when to next sequential column letter rather than the appropriate one for the corresponding episode. Fixed mine myself but FYI to others!!! On Feb 22, 2016 11:55 AM, “Bach Fantasy” wrote:
> Bach Fantasy posted: “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 valu” >
How would I go about fixing the new template? I have moderate excel skills and have tried to play around with it but I am unsure of how to fix it. I have a temporary solution in place but, could you provide a step by step to fix the excel spreadsheet? After downloading the new excel spreadsheet I personally went in and added all of the contestant scores again and updated the midseason teams page. However, it will not calculate points passed the 6th episode. I would greatly appreciate it! Thank you!
Krista, my fear is that say a league player dropped a contestant, those points have simply gone away for them. Currently my solution does not have a way to account for those previously earned points.
Was there an updated spread sheet? (a fix to the mid season draft one)
Bach Fantasy Gods, Have you posted WTA Point Categories yet? My girls are getting antsy. Love you!
Joslyn
>