Category Archives: Uncategorized

Updated Score Sheet

I thought this would be the season I produced a flawless scoring spreadsheet, guys. Three weeks ago, I added “update BachFantasy scoresheet” to my to-do list, with grand plans to take my time meticulously testing every last cell. Yet, I still ended up hastily updating it between mouthfuls of Kale Caesar salad (sup, Sweetgreen) the day we posted it, sending it off and hoping I’d be rewarded for my procrastination with a miracle of perfection.

 

giphy.gif

Anyway, I fixed it. If you’d prefer to just update your copy, it’s a very simple fix. On each of the Episode tabs, you just have to update the formulas in row 33 to sum rows 2 – 32. So, for example, the formula in B33 should be =SUM(B1:B32). Fix it in B33 and then just paste it all across row 33. Repeat on all the episode tabs.

ALSO, I updated Diggy’s name to be just Diggy (and re-alphabetized). Hard to tell which nicknames are going to stick. Who knew?

anigif_enhanced-10449-1440720583-5

Alright, if you’re still reading this unnecessarily long post, have a great MDW. Be safe and make good choices.

BachFantasy Scoresheet Rachel Season

Women Tell All Points Categories

We’re here! We didn’t forget about you or Women Tell All! ABC has really fucked with our internal Bachelor clocks this year, so we forgot that WTA is happening post-Fantasy Suites Pt. 2 tonight. We will score the below categories in addition to all the core categories we score every week.

Here are the bonus WTA points categories:

  • Entering a guess as to which woman will get the final rose (5 points)
  • Apologizing to another contestant (5 points)
  • Being featured on the Blooper Reel (5 points; available once per contestant)
  • Apologizing to Nick for her behavior on the show (10 points)
  • Speaking negatively about/toward Nick (10 points)
  • Mentioning a new romantic interest in her life (10 points)
  • Being accused of lying by another contestant (15 points)
  • Asking Nick why he got rid of her/what went wrong (15 points)
  • Admitting that feelings still remain for Nick (20 points)
  • Getting chosen for a one-on-one interview in the Hot Seat with Chris Harrison (25 points)
  • Getting chosen to go on Bachelor in Paradise (25 points)
    • Must be officially announced on the show 

Season 12: Men Tell All Points Categories

In keeping with the tradition of the past few seasons, we’re continuing to score the “Men Tell All” episode this year. Remember, these points will count in addition to all the regular categories during this episode. We’re hoping that this gives teams who aren’t doing as well a chance to catch up and make the finale even more exciting in your leagues.

Here are the bonus MTA points categories:

  • Entering a guess as to which man will get the final rose (5 points)
  • Apologizing to another contestant (5 points)
  • Being featured on the Blooper Reel (5 points; available once per contestant)
  • Saying the word “bromance” (5 points)
  • Apologizing to JoJo for his behavior on the show (10 points)
  • Speaking negatively about/toward JoJo (10 points)
  • Mentioning a new romantic interest in his life (10 points)
  • Being accused of lying by another contestant (15 points)
  • Asking JoJo why she got rid of him/what went wrong (15 points)
  • Admitting that feelings still remain for JoJo (20 points)
  • Getting chosen for a one-on-one interview in the Hot Seat with Chris Harrison (25 points)
  • Getting chosen to go on Bachelor in Paradise (25 points)
    • Must be officially announced on the show 

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

Revised Excel doc – Coming soon!

Hi Friends –

Sincere apologies on the delay with the revised Excel scoring template. To those of you who have generously offered solutions in the comments – thank you! I will post a revised doc that will allow for mid-season changes by tomorrow night. It’s been a busy few weeks, but we promise this has not fallen off our radar!

Thanks,

Jorie and Becca

Updated Scoresheet

Hi friends –

We apologize for all the confusion around the scoresheet. We had updated the file in our original post with the error-free version, but did not publicize that well enough. Super duper sorry about that.

Please use the attached scoresheet for the most up to date version. If you’ve already entered your league members teams and last night’s points in the original one, simply copy and paste those values into this new doc.

Again, so sorry about the confusion! We love you and never meant to cause you any Excel-based stress. That’s not what you come here for. Bless.

BachFantasy Score sheet- Season 20 – Ben v2

Becca and Jorie