WYDC Scoring Sheet

And I'm never going to quit until I face my challenge.
Forum rules
The Legacy & Challenge Story Update Threads have been revived! These are a fantastic group of threads where you can post every single one of your legacy or challenge story updates and shamelessly plug yourself! When you post your next legacy or challenge post, then feel free to post an update into the thread as well! And as if one plug isn't enough, at the end of the month someone will come along and post a big omnipost of all the updates that have been posted within the aforementioned month.
The (Un)Official Legacy & Challenge Story Update Thread: TS2

WYDC Scoring Sheet

Postby Keika » October 10th, 2014, 8:55 am

Hey all, I put together this scoring sheet to do the heavy lifting for me in scoring my WYDC. I've been using it and it's working like a dream, so I thought I'd share it with y'all.

WYDC Scoring Sheet

It's an Excel document, and is designed to automatically calculate your score wherever possible. It also has a formatted list to keep track of fathers, an option to track your completion percentage, and comes with extensive notes on how to use it. I hope it helps. :)

VERSION 2: I noticed on my own copy that there was an error in numbering boxes on the "Fathers" sheet. There were only 25 boxes; #21 was missing. Oops. I have uploaded a new version with this error corrected. I also changed the wording on a few things while I was at it, and I made provisions in the "Challenge-Defined NPCs" sheet for the founder's husband's alien baby, since you get a point for a kid with a different father, but not one for using the PT as an NPC.

VERSION 3: I learned some great stuff about writing formulas in Excel, and decided to apply it to this scoring sheet. I promise, this'll be the last new version. This one is a bit more cohesive than the last two. You don't need to worry about opening the sheet and having a "-1" in the "Each additional NPC" field on the "Scoring" sheet. The "Scoring" sheet will recognize if negative numbers (instead of the positive ones it needs for the formula) are entered into the "Penalties" box, and will react accordingly. The "Positive" and "Negative" columns on the "Scoring" sheet have been merged into just "Points"--I don't know why I thought I needed two separate columns in the first place. There is now a message box on the "Scoring" sheet which will display instructions for fixing negative number errors should they arise, and will also display the word "Congratulations" if you finish the challenge using the percent completion option. All formulas have been greatly truncated and simplified. And finally, the whole document (except for cells which have to be typed in) is write protected, so that it's harder to accidentally delete a necessary formula and then have to re-download it.
Last edited by Keika on January 15th, 2015, 1:48 pm, edited 4 times in total.
User avatar
Keika
Queen of the Fireflies
House of Motherlode
 
Posts: 503
Joined: July 20th, 2013, 5:27 am
Location: Not Found
Medals: 18
Tip-Top-Topic (1) Golden Plumbob (1) Golden Plumbob 2017 (1) Sims 2 Legacy (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2014 Screenshot Event (1) 2015 Holiday Events (1)
2015 Christmas Gift Exchange (1) 2016 Valentine Events (1) 2015 Birthday Toast (1) Happy Birthday (1) Artwork (1) Great Migration of 2014 (1) I Supported Boolprop! (1) The Legend of (1) United States (1)

Re: WYDC Scoring Sheet

Postby Anne » October 10th, 2014, 9:19 am

Oh, so useful! :) I'm thinking about starting a WYDC this evening on the computer I have at my parents' place (just to have something to play while I'm there), so this'll come in handy. Thanks!

Edit: turns out TS2 has stopped working altogether on this pc, so that won't be happening until I've installed the ultimate collection here too. Oh well...
User avatar
Anne
House of Smustle
House of Smustle
 
Posts: 292
Joined: January 3rd, 2009, 1:00 pm
Location: The Netherlands
Medals: 10
Apocalypse Challenge (1) Story of the Month (1) Completed a Challenge! (1) 2015 Holiday Events (1) 2015 Birthday Toast (1) 2015 Birthday Balloon (1) Happy Birthday (1) Great Migration of 2014 (1) Drinks on the House (1)
Netherlands (1)

Re: WYDC Scoring Sheet

Postby Jenn » October 14th, 2014, 6:22 pm

This is probably the best thing I have seen in a long time.

May I link this thread on my blog?
User avatar
Jenn
House of Plumbob
House of Plumbob
 
Posts: 757
Joined: December 21st, 2011, 2:36 pm
Location: Southwest Missouri
Medals: 29
Golden Plumbob (1) Boolprop EPIC Challenge (1) I'm Surrounded by Idiots (1) Queen Bee Challenge (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2017 Egg Hunt (1) 2017 Golden Egg (1)
Silver Writing Award 2016 (1) Gold Writing Award 2017 (1) Halloween 2016 (1) 2016 Holiday Events (1) 2017 Valentine Events (1) 2017 Halloween Events (1) 2017 Halloween Events - Cat (1) 2017 Pumpkin Hunt (1) 2017 Pumpkin Hunt - Gold (1)
2017 Snowman Hunt (1) 2017 Snowman Hunt - Gold (1) 2017 Xmas Events (1) 12th Birthday Event (1) Palmer Says ... (1) Scavenger Hunt (1) Pass the Parcel (1) Pin the Plumbob (1) Happy Birthday (1)
Great Migration of 2014 (1) USA - California (1)
Steam ID: oxjennxo
Origin ID: xoxjennxox

Re: WYDC Scoring Sheet

Postby Keika » November 11th, 2014, 11:01 am

Absolutely! (a month late) Glad you guys like it. :)
User avatar
Keika
Queen of the Fireflies
House of Motherlode
 
Posts: 503
Joined: July 20th, 2013, 5:27 am
Location: Not Found
Medals: 18
Tip-Top-Topic (1) Golden Plumbob (1) Golden Plumbob 2017 (1) Sims 2 Legacy (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2014 Screenshot Event (1) 2015 Holiday Events (1)
2015 Christmas Gift Exchange (1) 2016 Valentine Events (1) 2015 Birthday Toast (1) Happy Birthday (1) Artwork (1) Great Migration of 2014 (1) I Supported Boolprop! (1) The Legend of (1) United States (1)

Re: WYDC Scoring Sheet

Postby Keika » January 9th, 2015, 9:59 am

Bump: There were a couple of errors on the original version of this scoring sheet that I just noticed today. I've uploaded a new version with those errors fixed. I wrote about everything I changed on the first post in this thread. The download goes through the same link I have provided here. Sorry for the inconvenience.
User avatar
Keika
Queen of the Fireflies
House of Motherlode
 
Posts: 503
Joined: July 20th, 2013, 5:27 am
Location: Not Found
Medals: 18
Tip-Top-Topic (1) Golden Plumbob (1) Golden Plumbob 2017 (1) Sims 2 Legacy (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2014 Screenshot Event (1) 2015 Holiday Events (1)
2015 Christmas Gift Exchange (1) 2016 Valentine Events (1) 2015 Birthday Toast (1) Happy Birthday (1) Artwork (1) Great Migration of 2014 (1) I Supported Boolprop! (1) The Legend of (1) United States (1)

Re: WYDC Scoring Sheet

Postby Jenn » January 10th, 2015, 12:35 pm

Thank you!
User avatar
Jenn
House of Plumbob
House of Plumbob
 
Posts: 757
Joined: December 21st, 2011, 2:36 pm
Location: Southwest Missouri
Medals: 29
Golden Plumbob (1) Boolprop EPIC Challenge (1) I'm Surrounded by Idiots (1) Queen Bee Challenge (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2017 Egg Hunt (1) 2017 Golden Egg (1)
Silver Writing Award 2016 (1) Gold Writing Award 2017 (1) Halloween 2016 (1) 2016 Holiday Events (1) 2017 Valentine Events (1) 2017 Halloween Events (1) 2017 Halloween Events - Cat (1) 2017 Pumpkin Hunt (1) 2017 Pumpkin Hunt - Gold (1)
2017 Snowman Hunt (1) 2017 Snowman Hunt - Gold (1) 2017 Xmas Events (1) 12th Birthday Event (1) Palmer Says ... (1) Scavenger Hunt (1) Pass the Parcel (1) Pin the Plumbob (1) Happy Birthday (1)
Great Migration of 2014 (1) USA - California (1)
Steam ID: oxjennxo
Origin ID: xoxjennxox

Re: WYDC Scoring Sheet

Postby Teresa » January 11th, 2015, 8:17 am

Wow, very nice. :clap:
Active Sims 4 Legacy | Tribbles: A Legacy

Image
Completing challenges and legacies since May 7, 2007 | All of my Completed Stories

Image
Image
User avatar
Teresa
Property of Boolprop
Site Admin
 
Posts: 2786
Joined: October 6th, 2006, 2:05 pm
Location: Texas
Medals: 29
Golden Plumbob (1) Golden Plumbob 2017 (1) Sims 2 Legacy (1) Sims 3 Legacy (1) Boolprop Wacky Challenge (1) Alphabet Legacy (1) Differences in the Family Tree (1) Who's Your Daddy? (1) Completed a Challenge! (1)
Boolprop NTM 11 Participant (1) 2014 Screenshot Event (1) Bronze Writing Award 2016 (1) Halloween Candy (1) Halloween Zombie (1) Thanksgiving Turkey (1) 2015 Holiday Events (1) 2015 Christmas Gift Exchange (1) 2016 Valentine Events (1)
2016 Easter Events (1) 2015 Birthday Toast (1) 2015 Birthday Party Hat (1) 2015 Birthday Balloon (1) Happy Birthday (1) Secret (1) Serious Admin Award (1) Great Migration of 2014 (1) Little Ball of Fur (1)
Drinks on the House (1) USA - Texas (1)

Re: WYDC Scoring Sheet

Postby Keika » January 15th, 2015, 1:46 pm

Thanks, Jenn and Teresa! :)

I'm sorry again for the inconvenience, but I've uploaded a third version of this sheet, which should be a lot easier to follow in certain areas and be a lot harder to accidentally break. If you want it, go ahead and download it, if not, version 1 or 2 will still work just fine. :)
User avatar
Keika
Queen of the Fireflies
House of Motherlode
 
Posts: 503
Joined: July 20th, 2013, 5:27 am
Location: Not Found
Medals: 18
Tip-Top-Topic (1) Golden Plumbob (1) Golden Plumbob 2017 (1) Sims 2 Legacy (1) Who's Your Daddy? (1) Story of the Month (1) Completed a Challenge! (1) 2014 Screenshot Event (1) 2015 Holiday Events (1)
2015 Christmas Gift Exchange (1) 2016 Valentine Events (1) 2015 Birthday Toast (1) Happy Birthday (1) Artwork (1) Great Migration of 2014 (1) I Supported Boolprop! (1) The Legend of (1) United States (1)

Re: WYDC Scoring Sheet

Postby Shortstop » January 18th, 2015, 12:58 pm

This is great! Thanks for sharing it!! :D
User avatar
Shortstop
 
Posts: 52
Joined: January 17th, 2015, 9:29 am
Location: Granite Falls
Medals: 2
Happy Birthday (1) Watermelon Bliss (1)

Re: WYDC Scoring Sheet

Postby MichelleCYoung » April 3rd, 2015, 5:50 pm

This is fantastic! As far as I can tell, you've listed everything! Keeping track of it all on paper would be maddening.

One thing - is it possible to get "Complete" for those of us who only have a the Mac version (only goes up to Bon Voyage)? I did just a quick skim, and already found that I can't possibly do mannequins, witches, hobby masters, genies, or break-dancer.
Badass Alphabetocalypse (Complete!)
Alphabetepic Apocalypse updated 4-1-16 - Adventure Complete
Parker Trailer Park Challenge updated Mar 27, 2017
Youngdale Build a Royal Queendom Challenge updated Sep 25, 2017
The NeenerNanner Apocalypse - October 31, 2016 A New Hope Apocalypse - October 9, 2016 - hiatus until I upgrade my computer
Simself version 1 Simself version 2
User avatar
MichelleCYoung
House of Llama
House of Llama
 
Posts: 1167
Joined: August 15th, 2014, 6:12 am
Medals: 13
Golden Plumbob (1) Golden Plumbob 2017 (1) Apocalypse Challenge (2) Completed a Challenge! (1) Gold Writing Award 2016 (1) Gold Writing Award 2017 (1) 2017 Halloween Events (1) Happy Birthday (1) Teresa's Troll (1)
Great Migration of 2014 (1) Watermelon Bliss (1) Netherlands (1)


Return to Sims 2 Challenge Chat

Who is online

Users browsing this forum: No registered users and 1 guest