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.
WYDC Scoring Sheet
WYDC Scoring Sheet
Last edited by Keika on January 15th, 2015, 1:48 pm, edited 4 times in total.
Completed: The White Legacy | Wynter Wonderland: a WYDC
- Anne
- Posts: 437
- Joined: January 3rd, 2009, 6:00 am
- 15
- Location: The Netherlands
- Contact:
-
Achievements / Awards
Post Counts
Re: WYDC Scoring Sheet
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...
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...
- Jenn
- House of Plumbob
- Posts: 3032
- Joined: December 21st, 2011, 7:36 am
- 12
- Steam ID: oxjennxo
- Origin ID: xoxjennxox
- Location: Arizona
- Contact:
-
Achievements / Awards
Completed Challenges
Seasonal Events
Winners Choice
Post Counts
Re: WYDC Scoring Sheet
This is probably the best thing I have seen in a long time.
May I link this thread on my blog?
May I link this thread on my blog?
ABC Legacy - Sims 2 * Time Marches On...Again - Sims 2 * Megahood Wants- Sims 2
Tart Genderbend - Sims 3
Wells NGC - Sims 4 * Mims 100 BC - Sims 4 * Build It Up - Sims 2, 3, 4
Re: WYDC Scoring Sheet
Absolutely! (a month late) Glad you guys like it.
Completed: The White Legacy | Wynter Wonderland: a WYDC
Re: WYDC Scoring Sheet
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.
Completed: The White Legacy | Wynter Wonderland: a WYDC
- Jenn
- House of Plumbob
- Posts: 3032
- Joined: December 21st, 2011, 7:36 am
- 12
- Steam ID: oxjennxo
- Origin ID: xoxjennxox
- Location: Arizona
- Contact:
-
Achievements / Awards
Completed Challenges
Seasonal Events
Winners Choice
Post Counts
Re: WYDC Scoring Sheet
Thank you!
ABC Legacy - Sims 2 * Time Marches On...Again - Sims 2 * Megahood Wants- Sims 2
Tart Genderbend - Sims 3
Wells NGC - Sims 4 * Mims 100 BC - Sims 4 * Build It Up - Sims 2, 3, 4
- Teresa
- Site Admin
- Posts: 5427
- Joined: October 5th, 2006, 6:00 pm
- 17
- Steam ID: tjsmetana
- Origin ID: tsmetana
- Location: Texas
- Contact:
-
Achievements / Awards
Post Counts
Re: WYDC Scoring Sheet
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.
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.
Completed: The White Legacy | Wynter Wonderland: a WYDC
- MichelleCYoung
- Posts: 1624
- Joined: August 15th, 2014, 6:12 am
- 9
-
Post Counts
Re: WYDC Scoring Sheet
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.
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!)
All of my other projects should be moved to the graveyard. But I have a new computer, at last! WOOOOT!
All of my other projects should be moved to the graveyard. But I have a new computer, at last! WOOOOT!