Updated Excel Doc

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:

  1. 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.
  2. 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.
  3. 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

 

BachFantasy Score sheet- Season 20 – Ben v3

Advertisements

8 thoughts on “Updated Excel Doc

  1. RitaP says:

    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?

  2. TheBach says:

    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.

  3. Krista Krauss says:

    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” >

    • Jillian says:

      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!

  4. Jillian says:

    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.

  5. Shannon says:

    Was there an updated spread sheet? (a fix to the mid season draft one)

  6. Joslyn Inderbitzen says:

    Bach Fantasy Gods, Have you posted WTA Point Categories yet? My girls are getting antsy. Love you!

    Joslyn

    >

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: