Sims 4 Legacy Challenge Scoresheets

When it rains it pours, we have not one but three different score sheets for the Sims 4 Legacy Challenge ready and waiting for you so you can pick whichever one you like.

Want a printable rulebook and scoresheet? Download NerdyBunny’s rulebook & scoresheet!

These should suit your Legacy Challenge point tracking needs.

285 comments

[…] Sims 4 Legacy Challenge Scoresheets […]

I downloaded Hilliee’s Legacy Score sheet and I love it!! I was wondering if there is going to be an updated version for the new Eco Lifestyle pack? also, I noticed that the Robotics Skill is missing from the Knowledge section and I’m hoping this can be fixed in the next update? As a huge fan of this score sheet, I will definitely comment if I find other issues, because this is a very streamlined and cohesive score sheet and works so for first-time legacy callengers like myself!

Hilliee has updated her sheet – yay!
It is the best one out there. I had updated it as much as needed along the way, thank you for allowing us to unlock it. However, I was never able to locate and update the lists, so I had to keep overriding formulas. I am very happy it is now up to date.
Thank you Hilliee!

I forgot to say, it is updated up until and including the Batuu-pack. So it is updated with everything released in 2020 or before.

I just opened up Hilliee’s Legacy sheet cuz I saw that hers was the best and the most updated. It looks amazing but I am wondering why I can’t track anything on it. It will not let me write. Do I have to request permission to use it? I do not want to change any formulas just want to use it as a tracking sheet

My last question is do you keep your siblings in the house with the founder and the next generations or do you at some point let them move out? I understand keeping them in the house until you get your next heir but I was just wondering what some peoples thoughts were.

Hillee’s isn’t working. There’s an error with the code that translates the spouses to other pages. I’m sad because I’ve spent so long on it and have entered so much, just to find out that it’s currently unusable.

Nevermind I fixed it, I’m dumb lol

How did you fix it because I am having that same issue, and it also doesn’t load so that if lists of names for potential heirs either it only lists off the first heir and not for any other generation when you click from the drop down list.

Thanks for these. Makes it a lot easier

I would like however, somewhere in the sheets that is not locked that I can add my own information to. For example, recording which events a sim has earned gold in. Or the traits of all my children. Or even the names of all the children. Doesn’t have to link to anywhere. Just a page for notes that isn’t locked.

This is exactly what the version I was working on would be for – a bit more thorough tracking. Most of the sheets are locked, but they have a little more info, like what you’ve mentioned.

I’ll make sure to add a blank Notes page to the end of the one I’m making because that’s an awesome idea!

These are great! I find pencil-and-paper easier than spreadsheets, so I created my own Legacy Challenge score sheet in a Word document. I’ve uploaded it in case others find it helpful too.

https://drive.google.com/file/d/0B1f9FKgH43o-SS1CRzZqaXNiY1U/view?usp=sharing

I wanted boxes to check off components of complex goals (like collecting each of the one-time-use aspiration reward potions) as well as itemizing them so what’s needed is clear. I also wanted space to write out the traits of Primary Spouses so I can see them all at a glance.

I also created a separate Word document for tracking the completion of collections. Figured I might as well share that too.

https://drive.google.com/file/d/0B1f9FKgH43o-QUxjaWdCbnl5dHc/view?usp=sharing

If anyone has any suggestions for improvements, please share!

Lavenderbird21

Thank you so much you’re a lifesaver! I was particularly looking for one that’d be easy to print off and use with a pen/pencil!

I want to keep a tracking sheet, and your one is perfect especially with the ease for printing. Although, I’m new to this and don’t know how to actually fill the sheet out 😛 So, I was hoping you’d be able to help me out with that? Thanks 😀

I gave Hilliee’s Legacy Scoresheet a huge thank you but I want to give you one too as I also like to use the pen and paper. In fact, I had it all written out until I went to search for scorecards :p lol. Anyway thank you!! ♥♥♥ Love it!

Kate Hamilton

Hi Sarah,

Thanks so much for this spreadsheet! This is my first time doing the legacy challenge and i’m so glad that i took time to look for the scoresheet. You’re suits me to a T! Just a couple of quick questions (because i’m exhausted and probably just not thinking clearly) in the knowledge and athletic areas, can your sim family repeat aspirations and max skills? And do you just write what these aspirations/skills are next to the numbers? And once you’ve complete one of each do you just tick them in the bottom area of that section?

Like I said, this is my very first time.
Kate

Oh my goodness! I have been working on a visual Excel version for the last couple weeks, tweaking here and there as I go. I’ll make sure to upload it whenever I get a chance, so others can use it if they want. It looks a little different than yours, though. :]

[…] are now three official scorekeepers on Pinstar’s legacy challenge website. However I had already spent some time creating my own. It was super fun to figure out how much to […]

Hi! Can I still start the challenge, it sounds great?! One question, do I just keep record for myself or do you have some place, where we can also see other players records? Thanks for answers 🙂

ImaginingMystic

You can start the challenge at any time! You can find scoresheets for it here: https://simslegacychallenge.com/sims-4-legacy-challenge-scoresheets/. You keep track of your own points. Feel free to let us know how you do 🙂

Pinstar Legacy

We don’t keep a “high score” table, so to speak. What you COULD do is post your finished family to the gallery tag it with #LegacyChallenge and put your score in the description.

Okay, I believe my version of a Tracking Assistant for TS4 Legacy Challenge is all finished. After a lot of work, I’ve put together a pretty extensive tracker that’s (I think) pretty easy to use. The web version looks silly, but if you have excel, it should show up properly after it’s downloaded.


And of course, I’ve credited everyone necessary. ;D

Pinstar Legacy

That is awesome! With your blessing we’ll put it up on the score sheet section!

I would be honored, of course! I actually found a couple of formula hiccups in the one I posted before, so I fixed them.
Here is the updated version:

Oops, I just realized that Dropbox automatically overrides the previous file, so you can ignore my previous reply. The link will still be the same. :]

Thanks!!

The new sheet fixed the #NAME error I was getting, yay! But it seems that it no longer fills in the primary spouse stats for some reason.

Shewolf: did you make sure on the Overview page that the “Relation to Family” column has the “Primary Spouse” option chosen? It will not add the unique traits unless they are the primary spouse of that generation. If you only choose “Spouse” it will not add the traits to the Love page. I checked, and I wasn’t having this issue on mine.

I had actually. I doublechecked that. I ended up having to download it again and that one worked XD So I’m not sure if it was just something I did, or if you made changes, I have no idea. But it’s working beautifully! Really love it!

Awesome!
If you have any other issues, make sure to let me know here. 🙂

Hey Drew, I’m running into an issue where I get the #NAME error for my legacy founder’s on the family tab. It’s not a huge deal, just curious if anyone else has this issue. It seems to work fine for the rest of it. It’s a wonderful sheet! I love the spaces for all the extra info ^^

I noticed it myself, and I have re-uploaded it with the fix! You can just re-download the file (unfortunately you’ll have to re-enter everything)

Like I said, I made it all by myself, so there may be a couple more issues. If you find them, please let me know!!

HI, about Drew!

your spreadsheet is awesome,but it was acting weird saying #NAME? instead of points, but then i noticed the founder is tagged as 1st generation and after changing that to 0 it started working right. i just thought i’d mention it.
thanks so much for making it cause it’s a great help!!

greetinzz willzzz

Glad you like it!

I believe I fixed the issue, and have re-uploaded the file to the same location, so if you download it again, you shouldn’t have the #NAME? issue on the Family tab. :]

Hi, thanx so much for these!! i was writing everything down till now, i downloaded all of them just to see which is best. this will most definately make it easier to keep track of things!!

greetings, Willzzz

currently in 5th generation

[…] Sims 4 Legacy Challenge Scoresheets […]

Drew, you’ve made an amazing spreadsheet. There are a couple things off about it though. There is no consumable aspiration rewards aka potion list under Nature. The clickable arrows under Penalty only change the number in the first box. There are two penalty electricity bill boxes and no social services box. Checking sections off under Nature does not add points. After checking off all of the career track rewards for the Nature Entertainer: Musician section, the “Entertainer: Musician” doesn’t turn green like the others do. The same issue occurs in the Nature Emotional Paintings section.

I’m looking forward to an updated version! By the way, ever considered adding little mouse-over descriptions of the sections? I thought that might be helpful for some. Thank you for sharing your scoresheet!

another thing is that it does not add the points from bronze medals to the total medals points.

other then that I found the spreadsheet amazing and I’m looking forward to an updated version. 🙂

Oh, thanks!!
I’ll fix these ASAP and upload it to the same location. If you find any more issues, you can tell me in the forum here.

I have a question about one point on drew’s Tracking Assistant (which is awesome btw). In the Creativity tab it offers the painting memorilisation as “painted a Masterpiece realism painting” but on the scoring page here it only mentions to paint a high-skill Realism painting. So do I need to get a realism Masterpiece or is my excellent realism painting enough to memorialise my 1st Gen primary spouse? Thanks!

ImaginingMystic

It doesn’t need to be a masterpiece. It just needs to be a realism painting that is painted by a Sim with a skill level of 8 or higher.

Ooh thanks guys! I completely overlooked that!

Thanks Drew for the spreadsheet, it’s fantastic 🙂
The version of the spreadsheet I am using is missing a few things….
-Death Toll
-Emotional paintings

I also can’t check off the insta fun in the consumables…

Just wanted to know if I am using the most recent version of the spreadsheet?

Thanks 🙂

Hi Imagine Mystic and Pinstar
I discovered an error in your spreadsheet in google docs.
You forgot the second part of the Love points. The thing with one sim completing both love aspirations.

/LenaLJ

Pinstar Legacy

Thank you! I’ll fix that soon!

I can’t access the Sims 4 Legacy Challenge Tracking Assistant by Drew. When I click the links all I get is:”The file you’re looking for has been moved or deleted.”

Im having the same Issue, as Im unable to get into the one I downloaded. about drew your Tracker spreadsheet is AWESOME and now Im soo lost with out. ;(

I can’t open about drew challenge tracking assistant page 🙁

me too!!!

Sorry guys! I updated the tracker, and it’s in a new location now!

Please head over to the forums where I keep an updated version at all times!
https://simslegacychallenge.com/forums/viewtopic.php?f=24&t=60&p=187&sid=3a259774d4868f78056dfca1e3ee8553

Sorry, I can’t edit Pinstar’s post above, otherwise I would update the link. 🙁

ImaginingMystic

What do you need me to update? I could do it.

Sorry, I haven’t checked my e-mail for updates recently!!

You can just link to the help thread I put in that post above, and you won’t need to update any more (since I post the newest version in that thread)

ashleighanne90

I just want to point out two things regarding Sims Guy Steve’s score sheet:

1. Drowning needs to be added to the death types
2. There seems to be an error with the list of emotional paintings. It lists Focused, Confident, Flirty, Angry, Sad, and Energized as the six emotional paintings in the game but I believe the Energized category is actually supposed to be Playful instead. My Sims have collected all six emotional paintings but Energized isn’t one of them. I don’t even get the option to paint an Energized painting at all when my Sims are energized. The six emotional paintings my Sims have are Focused, Confident, Flirty, Angry, Sad and Playful.

Overall, I love Sims Guy Steve’s score sheet, though. So easy to keep track of my points when all I have to do is punch in the data and let it calculate everything for me. Genius idea!

Pinstar Legacy

Thank you for noting the errors, Energized is indeed supposed to be playful. I’ll be doing some updates today.

Will “Drew’s Legacy Challenge Tracking Assistant” be updated to include the new careers? If so, do you know when? Thanks

ImaginingMystic

I would assume so since he’s been updating his tracker regularly, but I have no idea when, sorry!

Thanks for the fast reply, I’ll keep up with the things for that career on a separate piece of paper for now. 🙂

Just a note, to get Drew’s tracker now, you have to be a member of the forums even to see his post. Would it be possible to make it so that people can at least see the post if all they want is to download that tracker?

ImaginingMystic

Yes, I can see if I can change the permissions on that. I actually never intended for all of the posts to be hidden like that anyway. Forums are not my forte, I need to fix the whole thing, LOL.

ImaginingMystic

Ok they SHOULD be viewable by all now. Let me know if you are still having problems downloading the chart!

hey! i wanted to let you know i made a printable scoresheet, in english and with a spanish version for people who always have to translate EVERYTHING like me

a link to my blog post

http://legacifails.tumblr.com/post/107608469085/since-im-not-going-to-accept-i-have-a-problem-for

if its any help to someone, here it is

Drew, I absolutely LOVE your tracker. it is by far my favorite. I wondered if you would be posting a revised version with the new careers (business, and athlete) as well as the new content for Outdoor Retreat. It would be greatly appreciated!!

Hello. Help me please – I downloaded all scoresheets, but everything is password protected, I can’t type anything, even choose anything from drop down menu… Am I missing something?

This realy made me wanna skrap my current family and start over going for the Legacy. They should include this scoring in game!

Sorry, this was not here

Will Drew be updating his spreadsheet to go along with the new rules for the GTW expansion?

Or any of the trackers, though I’ve been using Drew’s.

I’m also wondering if Drew’s scoresheet will be updated?

Okay, aside from the question about updating Drew’s tracker for GTW, I’ve noticed a few things:
– In the Sims panel though it says the exemplar trait is shown in green, it isn’t.
– The Creativity panel has formulas that don’t appear to be tracking anything, and those cells are protected.
– Formulas in the Family panel aren’t picking up information; I’m not sure if this is because the wrong cells are indicated in said formulas, or if it’s some other thing.
– In the Knowledge panel, the name cell is protected but it isn’t picking up family member names after the founder and first spouse. So I can’t count how many points I’ve gotten for various skills maxed.
– Again, formulas in the Love panel aren’t picking up data.

Is this because I’m using OpenOffice instead of Excel, or are these real problems?

Also, and this may be being a bit demanding, is it possible – if you update! – to add a cell for the childhood aspiration on the Sim panel?

Hi there! I also made a scoresheet if anyone is interested. It is meant to be printed out and filled in by hand. Here is a link for it.

https://www.dropbox.com/s/12ns52tbhyddsow/Legacy%20Scoresheet.xlsx?dl=0

It might look weird in excel because of the headers and footers but I promise it looks completely normal printed out.

Hi there,

It’s me again. I created a “statsheet” that I like to use with my scoresheet (and it could also work for other scoresheets/general legacy play). It’s designed to be filled out one per sim. It allows you to keep track of their traits, aspirations, careers, skills, parties, children, memorialization, death type, and miscellaneous milestones that each sim has completed while in the legacy scoring. I find it help’s me to keep track of the individual accomplishments while the scoresheet gives me an overall overview of the Legacy so far.

https://www.dropbox.com/s/h7kd7sm0q8bfoh3/Legacy%20Statsheet.xlsx?dl=0

Holly-Jayne

I have made myself a completely up to date scoresheet. It’s just a Word document (can’t work excel) and it’s EXTREMELY simple, but it’s there if anyone would like to use it 🙂

https://www.dropbox.com/s/hj96q7x82j5ibcd/The%20Sims%204%20Legacy%20Challenge%20Scoresheet%20%28Word%29.doc?dl=0

There doesn’t seem to be a “Squeamish” trait on the score sheet (for Drew’s sheet). Is this going to be updated? It would be great to have a column for Aspirations also. Easier than looking through my many legacy notes 😉

ImaginingMystic

Drew has a section on our forums where he posts updates to the scoresheet. If there is an update with the squeamish trait on it, it will be there 🙂

Hi everyone,

I couldn’t find an automatic score tracker that has been updated to include the content of the Game and Expansion packs so I decided to create my own. It automatically keeps track of the points you score and lets you enter the Games you own. It will adjust the scoring mechanics to the Games you own automatically. Feel free to try it out and let me know if you experience any problems.

https://www.dropbox.com/s/up3tmvw7kljac7h/Legacy%20Challenge%20Scoresheet.xlsx?dl=0

Thank you so much for this! I find this very useful since I’ve previously used Drew’s scoresheet. But yours is easy to use as well!

This sheet is awesome and up to date! Thanks for posting it! 🙂

I thank you so much for this sheet 🙂

This tracker is absolutely brilliant! I love that you can include and exclude certain packs. It makes things so much easier. That said, I did find an issue with it. On the Family tab, when you select a Gender Law, nothing appears under Explanation. The other Succession Law explanations worked though, so I looked and saw that the formula for the Gender Law is incorrect. It should be N6 instead of AF6. It was easy enough to fix, but I figured that I should let you know.

Hi Julie,

Thank you for pointing out the issue. I fixed the formula so it should now display the Gender Law explanation correctly.

HillieE

Thank you so much for this score sheet! I am using it for all my legacies now. So well thought out! And, as a bonus, updated with the new Jealousy trait already!

ImaginingMystic

Somehow I approved this comment but never added the tracker to the master list. Sorry about that! It’s up there now!

Hi everyone,

I just finished a big update on the sheet that adds some new functions. The link is still the same. Details about the update can be found in the instructions section.

HillieE

Hi Hillie – Thanks so much for the score sheet. Its so easy to use and well thought out. However, I can’t seem to get the Love tab to work. There are several #ref! errors in my formulas in the D column on that tab. I was able to get the 1st 2 traits to work by replacing the the #ref! error with “Genealogy!$A$33:$A$157” but for some reason this doesn’t work with the 3rd trait.

I was able fix the issue — your formula was pointing to column L on the Genealogy tab to find the 3rd (Adult) trait, but it should be pointing to the M column. After doing a search/replace of the #ref! errors with Genealogy!$A$33:$A$157 and changing all the L column references to M , the Love tab now works like a charm. Thank you so much for this awesome sheet! You did a really great job with this. I love how you have all the packs included and everything is up to date!

Hi JelliB,

Thank you pointing out the issue. I just noticed the issue with with Love tab myself yesterday. I accidentally forgot to update part of the formula. I changed the references in the formula so it should be working fine now.

HillieE

Hi everyone,

I just finished updating the sheet with the content of the Get Together Expansion Pack and the updated rules of the Legacy Challenge. The link is still the same. Please let me know if you experience any problems.

HillieE

Hi HillieE,
I have downloaded your score tracker and am love with how in depth it is! My issue though is after selecting my game packs, it is still including scoring features of packs I don’t have: Island Living and Vampires. Maybe selecting Seasons has done this? I’m not sure. Will this affect my score calculated with the algorithm?

HillieE I was checking out your Tracker and I can’t get the “love” section to update correctly. Can you check it out please? thanks

Hi Annadenise,

I just checked the “Love” section and it seems to be working fine when I try it. Can you give me some additional information about the problem so I can try to fix it? Are you experiencing problems with the names of the Primary Spouses showing up or with the marking of the goals/traits as complete, or is something else not working?

If you have a problem with the names not showing up it might be because you haven’t filled out all the required fields in the “Family”-section’s Sims table. To make the names of the Primary Spouses show up in the “Love” section, you need to correctly fill out the following fields in the “Family” section in to make the formula work.
– The generation of the Primary Spouse
– The name of the Primary Spouse
– The Legacy Status (choose Primary Spouse from the dropdown menu)
– The traits of the Primary Spouse

If you are experiencing problems with the names showing up can you check if you filled these fields out correctly?

I hope we can find out what the problem is and fix it as soon as possible.

HillieE

Everything is filled out correctly. But the “love” section has this in it. I hope it copies correctly. When I input the spouse info it does not change.

Love Points #VALUE! HELP

Trait Primary Spouse that has this trait Total number of unique traits Active #VALUE! #VALUE! Ambitious #VALUE! #VALUE! Goals #VALUE!
Art Lover #VALUE! #VALUE! Have 3 unique traits #VALUE!
Bookworm #VALUE! #VALUE! Have 6 unique traits #VALUE!
Bro #VALUE! #VALUE! Have 9 unique traits #VALUE!
Cheerful #VALUE! #VALUE! Have 12 unique traits #VALUE!
Childish #VALUE! #VALUE! Have 15 unique traits #VALUE!
Clumsy #VALUE! #VALUE! Have 18 unique traits #VALUE!
Creative #VALUE! #VALUE! Have 21 unique traits #VALUE!
Evil #VALUE! #VALUE! Have 24 unique traits #VALUE!
Family Oriented #VALUE! #VALUE! Have 27 unique traits #VALUE!
Foodie #VALUE! #VALUE! Have a Sim complete both Love aspirations in one lifetime 0
Geek #VALUE! #VALUE!
Genius #VALUE! #VALUE!
Gloomy #VALUE! #VALUE!
Glutton #VALUE! #VALUE!
Good #VALUE! #VALUE!
Goofball #VALUE! #VALUE!
Hates Children #VALUE! #VALUE!
Hotheaded #VALUE! #VALUE!
Insane #VALUE! #VALUE!
Lazy #VALUE! #VALUE!
Loner #VALUE! #VALUE!
Loves Outdoors #VALUE! #VALUE!
Materialistic #VALUE! #VALUE!
Mean #VALUE! #VALUE!
Music Lover #VALUE! #VALUE!
Neat #VALUE! #VALUE!
Non-Comittal #VALUE! #VALUE!
Outgoing #VALUE! #VALUE!
Perfectionist #VALUE! #VALUE!
Romantic #VALUE! #VALUE!
Self-Assured #VALUE! #VALUE!
Slob #VALUE! #VALUE!
Snob #VALUE! #VALUE!
Squeamisch #VALUE! #VALUE!

Hi Annadenise,

I made a small change which I believe might solve the problem (I turned the formula into an array formula). Can you redownload the sheet and check if this solves your problem?

HillieE

Sorry for the late reply HillieE, it’s been crazy around here. I just downloaded the newer version and I’m still getting the #value with love section.

In the Genealogy tab, the “potential heirs” is giving the #value. The “suggested Role” is giving the #value.

The Love Tab, has the #value where the sims name goes and the #### is where the red circle with x in it is suppose to be.

On the Overview Tab, the “total score” has the #### because the Love section is not doing correct.

What excel are you using? Mine is Microsoft Office 365 updated to the 2016 version. This might be the problem

Hi Annadenise,

I’m not quite sure what’s causing the value errors. The problem seems to occur in cells with the INDEX-function. This function is also used in the ‘memorialized sim’-row of creative tab, do you experience problems there too?
I find it very odd that you are recieving errors in the cells you mention because the formulas there contain the IFERROR function which should change any error messages into something else but somehow this doesn’t work for you.
I’m using the Dutch Microsoft Office 365 (2016) version of Excel and the formulas work fine on my computer. The issue might be related to the translation from Dutch to your language (English?). Could you copy one of the formulas on the love sheet that gives a value error and post it here? (to be able to do this you need to unprotect the sheet). That way I can see if there are translation issues.

HillieE

Disregard that last reply. I took a chance and reinstalled my 365 office and everything is fine now. sorry for the problem.

Hi Annadenise,

I’m glad everything is working now. Let me know if you come across any new problems.

HillieE

[…] The scoresheet I use is made by SimGuySteve and can be found at Pinstar’s Sims Legacy Challenge Website. […]

I made a new tracking sheet. It is very similar to Drew’s but I updated it with the new updates with the expansion and game packs. Check it out and let me know if there are problems.

https://www.dropbox.com/s/7jvtaxg7rdzro2s/Thesims4-legacypointtraker.xlsx?dl=0

Hi HillieE – I love your tracker and I just updated the new one from 7 days ago (so around valentines) and lines 33 and 36 both have stuck cells that won’t allow you to choose any traits. 33 is the founder’s line and it’s the child trait that’s stuck and line 36 it’s the teen trait. No big deal – can be worked around but thought you should know!

Hi Ricalynn,

I checked the cells you mentioned and I notice there was a non functioning arrow in the founder line that was not showing the trait list. When I clicked on the cell another arrow appeared on top of it that did show the list properly. It seems this was caused by a bug in Excel. I fixed it by deleting the cell the arrow was in and creating a new cell. It should be working properly again.

HillieE

Does anyone have a score-sheet that has the Random Heir for 10 children? I have been using Pinstar’s but it only has room for 6. By the way thanks Pinstar for all that you have done for the Challenges. I love the YouTubes that you do.

Hi Marie Dean,

The Random Heir Generator in my scoresheet had room for 9 children. I updated the sheet today and expanded the Generator. It now has room for 11 Sims. Hope you find this helpful.

HillieE

Hi HillieE

I totally love your spreadsheet for the Legacy Challenge! It has everything needed 🙂 I am having one problem: Some of the spouse traits aren’t transferring to the “Love” sheet, specifically Bookworm and Lazy. Slob is working but I haven’t tried any of the others yet. Thank you for a great spreadsheet!

In addition to Jude’s comment from yesterday I wanted to add, I had the same issue with some of the traits not showing. Then I noticed that it was telling me that my primary spouse had the trait of my first potential heir which he doesn’t. The only one that recorded was cell 3 and then cell 1 of the line underneath the primary spouse line. Hope this helps recreate the problem!

Hi Judessims,

I checked the sheet and the problem was caused by the formula in the love sheet not recognizing cells J34 and K34. I updated the formula today. It should be working again.

HillieE

Good morning HillieE, I was downloading your updated sheet and as always, the love section is not working. This time I got a snapshot of the errors. My Excel and Office 365 is up to date.

[IMG]http://i65.tinypic.com/2wrq3ux.jpg[/IMG]

[IMG]http://i63.tinypic.com/6tguic.jpg[/IMG]

Update: Now, none of the “Love” Traits Points seem to be transferring from the Genealogy page. I’ll just start writing them down to count points until it’s changed. I’ll never remember otherwise 😀

Hi everyone,

Just wanted to let you know I decided to rebuild the Love Sheet from the ground up on a new sheet after reading about all the issues. Could you let me know if this fixed the issues?

HillieE

The link to the Drew’s score sheet is not working 🙁

I’m having the same problem with LOVE section as some users did, and would like to try to re-dowload the file. But the link won’t work anymore for some reason.

xKindredxSoulsx

Noticed the same issue here. The whole thread Drew’s spreadsheet can be found in is just missing. Very frustrating, as I love his score sheet, though it needs updating and is glitching on the love page.

ImaginingMystic

Ah darnit, I didn’t realize his scoresheet was on the Forums. We had an error with the forums the other day that caused a significant portion of the content to disappear and I decided to take them down (since Pinstar and I weren’t using them anyway). I will do some digging to see if I can find where they are all stored. Sorry about that!

ImaginingMystic

I sent an email to Drew to see if there is another link for it somewhere. Was his scoresheet being updated? If not, HillieE has one that is being maintained and updated and that one is up on the scoresheet page as well.

ImaginingMystic

I am looking into getting a new download link for you guys. We had a massive issue with the forums the other day that resulted in a lot of the stuff on there getting deleted. I ended up taking the forums down completely. However, I forgot that Drew’s sheet was kept on there.

I will try to get a new link for you all soon. Sorry about that!

ImaginingMystic

I put an email out to Drew to see if I could get another link to the tracker to post on here. Was his tracker being updated? If not, HillieE has one up on the Scoresheet page that, as far as I can tell, is being maintained and updated. So it might be worth looking into that one if I can’t get a hold of Drew.

Hi! Love the HillieE scoresheet for my legacy data, but as of August 18th, I’m still having the LOVE issue where the Primary Spouse’s traits are not transferring from the Genealogy page.

Wondering if it might be due to a matter of no link to the Genealogy page in the formula? I’m not an expert at Excel, but I can’t see any space in the formula which references another sheet.

Hi ForeverCamp,

I checked the sheet and tested it for all generations of primary spouses and all traits and the Love sheet seems to be working properly. Could you redownload the scoresheet and see if you still have the problem in the latest version? I did do a small update yesterday but did not make any changes to the Love sheet or the Genealogy sheet.
Also make sure you fill out the generation, legacy role and traits for every primary spouse or the traits won’t transfer. If you still experience issues with the new version could you email me a filled in version that shows the problems (the adress is in the contact info in the document) or post a link to the file here so I can take a look?

HillieE

Hi, I tried the newest version and still no love (pun intended, LOL).

Just wondering if I’m typing in the Generation wrong (I’m just putting in the numeral, which hasn’t messed up anything else in the sheet, but stranger things have happened…) I’ll email you a copy of the filled-in version as well.

Hi Forevercamp,

The problem was caused by there not being a Primary Spouse in Generation 1 causing an error in the Love formula which caused it to be unable to look up the traits of Primary Spouses in later generations. I changed the formulas on the Love sheet which should fix the problem.

HillieE

I am getting the same thing with this sheet the primary spouse traits not entered in the love tab Err:508, also a couple of other things.

But first a question: is the founder and their mate the primary spouse, generation 0? And that is why their traits are not recognized? Also does it matter if it is written as 1 or One in the space provided?

So the other things I mention are: On the genealogy page my bloodline law is traditional. In the conflicts box it says Err:512 but further down the page at the general conflicts it says no conflicts detected.

Still on the genealogy tab, I have entered only my founder and my primary spouse. Next to my primary spouse in the suggested role box, we have Err:520.

On the family tab No generation 1 is filled out for heirs, primary spouse or Goals.

I use open office. org instead of excel in case this could be the problem.
Thanks

Hi Kasi,

The founder and their spouses are generation 1 and if you listed them as generation 0 or no generation at all it might be the cause of the problems you’re having. Could you try filling out the sheet with the Founder and his/her primary spouse as generation 1 and let me know if you still get the errors?

HillieE

Actually I tried it as generation 0 after I wrote this and you will be pleased to know it is not a valid number nor is writing One. So the errors are still the same as I listed them sorry.

Hi Kasi,

I tested my Excel version of the sheet and it works fine. I downloaded Open Office to see if the problems were caused by using that program instead of Excel and unfortunately I had all the errors you described when using OpenOffice. This is likely caused by there not being an iferror function in OpenOffice causing all the formulas that use this function to not work when using Open Office (which are the ones one the Genaelogy, Family and Love sheet). I could try to make a seperate version of the tracker compatible with Open Office but that will take quite some time as I am not familair with the controls in OpenOffice and I also have a holiday coming up. If you would like me to try and make one please let me know. As a workaround you could also unlock the sheets that have errors in them and override the formulas (meaning you just enter the names and Legacy Roles manually). I think the scoring should still work if you enter them manually. If not, you’ll have to calculate them yourself, unfortunately. I’m sorry for the inconvenience.

HillieE

Oh gosh no don’t go to the trouble. Enjoy your holiday! Thanks so much for the testing for me. I will use excel for the sheet.
Thanks so much for your time.
Cheers Kasi.

Dear HillieE,

I’ve really enjoyed using your scoresheet for my legacy challenge so far, which soon begins the reign of the Gen5 heir.
I wonder if you have plans to update your scoresheet to add the new traits (Vegetarian and Unflirty) as well as the new City Living careers, once Pinstar announces a ruling on the new careers.

Thank you for a wonderful scoresheet!
oshizu

Hi Oshizu,

I do intend to update the sheet with the new content. I will probably do it in two fases (traits, careers and skills first and rule updates and trait generator later). The first update will probably be coming this week.

HillieE

Hello HillieE

Thank you so much! I can’t imagine playing the Legacy Challenge with any scoresheet except yours!

Gratefully,
oshizu

Hi oshizu,

The updated version is available now. I’ve decided to update everything at once (including the Random Trait Generator). If the are any future rule changes or other updates to the challenge I will update the sheet again.

HillieE

For anyone who downloaded HillieE’s spreadsheet but is having errors because they are using Open Office: I had the same problems, so I downloaded LibreOffice (for free), opened the document with that and it works perfectly, no conversions required. All the macros, all the little checkbox images, all the layout, everything is great. Took me a good while and a lot of different methods to figure that out but I’m really glad I did because it is a really cool and easy to use scoresheet. Thanks HillieE 🙂

Hi everyone,

My scoresheet has now been updated with the content from the City Living Expansion Pack. To download the new version simply use the link provided on this page. Details about the update can be found in the update section of the Instructions Sheet. If Pinstar and Mystic make any rule changes or add new Handicaps I will update the sheet again. If you experience any problems with the new version let me know.

HillieE

Thank you so much! I really like your scoresheet 🙂
I’ve noticed some things, so I made a list, I hope this help you in some way 🙂
– Food: The “Reach the top of both food career branches” cell is not working with food career branches, but wih Critic career.
– Popularity: This happened in the previous scoresheet too, I have all parties with “Gold” and Dance Party with “Held”, but the “Have a single Sim Earn a Gold Medal for every type of Social Event” cell still appears with “X”. Maybe I’m missing something? :/
– Nature: With the last EP we have two more collectibles; “Snow Globe” and “City Posters”. Also, with the “Day of the dead” patch, we have the “Sugar Skulls” in the collectables section.

Again, thank you very much, your scoresheet is so useful! 😀

Hi YuuAnn,

Thank you for pointing these out, I’ve fixed them in the latest version.

HillieE

HillieE, your scoresheet is amazing! Thank you so much for doing this. I have one issue with the Geneology tab that I had before. In your notes you mentioned you fixed the suggested role column, but I’m still getting “non eligible child” for those Sims who actually are potential heirs. Maybe I’m missing something?

At any rate, thank you again so much for this, it makes the Legacy Challenge so much easier to do!!

Hi Annika,

The suggested role column has a complex formula so it’s quite possible it will sometimes show a wrong result under certain circumstances. I would like to fix any mistakes in the formula but I need your help for that. Could you tell me which specific mistake you have experienced? Please include the succesion laws you’re using, the details of the Sims who get the wrong result (gender, species, adoption status, traits, parents, etc) and the details of other Sims in the same generation who do get the right result. Alternatively you could send your filled out version of the sheet with the error in it to the emailadress provided in the Contact section of the Sheet so I can try and find the issue there.

HillieE

Hello HillieE,

Thank you for so quickly updating your scoresheet!
Although you have gone to the trouble of adding City Native to the Athletic Category tab, I intend to add a “1” to that category without actually completing the aspiration.

It’s impossible to complete City Native without living in a San Myshuno apartment. One goal requires your sim to share his/her apartment key with another sim; another requires the sim to live in an apartment worth $xxxxxx.
Any sims in my legacy household located in Windenberg, therefore, would never be able to complete it.

That is my own personal solution, anyway. I’m happy that your traits generator now includes Unflirty and Vegetarian!
I was surprised at how quickly you updated your scoresheet. It’s very much appreciated.
oshizu

Hi Oshizu,

I’ve now removed the City Native Aspiration as a requirement for the completed all aspirations goal in the latest version. I also fixed the issues YuuAnn mentioned. I did decide to leave the City Native Aspiration on the sheet because some people might decide to still try to complete the Aspiration by only cheating past the impossible goals. I’m thinking about creating a more flexible sheet in the future letting people decide if they want to include skills, aspiration, careers, parties etc. from specific Packs as a requirement for the ‘complete all …’-goals. But I think I will put that idea on hold until the official rules are updated and the new Handicaps are announced.

HillieE

Hello HillieE!

You work so quickly! You’ve already updated your recently updated scoresheet!
I’m in Gen6 now and have started the process of copying everything over to your new scoresheet.

A thousand thank you’s!
oshizu

Evening HillieE,

Sorry I’ve not posted this yet. But i’m having problems with the generator. When I roll for all “All Traits”, I only get the child trait. The other two come up with #N/A in them. Can you check this out?

Thanks
Shannon

Hi Shannon,

There was a small error in the formula of the generator that caused the problem. It should be fixed now.

HillieE

♥Hilliee’s Legacy Scoresheet♥ I just want to give you a HUGE thank you!! Wow your version is amazing and must have taken you a pretty decent amount of time to create. It’s very thorough, I LOVE it! ♥♥♥♥♥Thank you!♥♥♥♥♥

HillieE you scorecard is awesome! but i noticed the unflirty trait and vegetarian trait is not counting by traits from primary spouse in the Love section. I took another trait to count it as 1 but hope you can change it.
From the start i love your scoresheet and also love the pictures by overview. Thanks for reading this and hope you can take care of it! Thank you

Hi Debby,

I fixed the issue you mentioned. I also added the new toddler traits to the random trait generator and the genealogy sheet.

HillieE

Hi HillieE awesome thanks and sorry for the late reaction could not open the page for a while 🙂

Hi HillieE! I really love your tracker! I use it ALL THE TIME and I think you do such an amazing job keeping it updated! Cant wait to see how you update it for vampires! Additionally I just wanted to make you aware of a little something (however not major) that I noticed. If you select all the expansion packs and game packs and etc, one of them (Im not sure which) glitches the trait generator (however this is avoidable by not selecting expansion packs) But I was curious if that impacts whether or not the traits for those packs get randomized.

Hi Alex, I fixed the issue you mentioned. The updated version including the Vampire Game Pack should be available for download now.
HillieE

Hi everyone,

A new version of my scoresheet including the new Vampire content should be live now (I am experiencing some internet problems so it might not have updated on Dropbox). It also adds new options to customise which skills/aspirations/careers/death types are included/required in the scoring.

HillieE

thank you so much HillieE!!

On the Legacy score sheet created by Pinstar, not all traits are included under the exemplar drop down box. My exemplar trait is to be Kleptomaniac, but it is not there.

ImaginingMystic

We haven’t updated our scoresheet since the base game released. I would recommend using HillieE’s instead.

Hey!

I just started my first Legacy Challenge! Thanks so much for your scoresheet HillieE!
Two questions:
1. I just gave birth to my first heir (female from Founder & Primary spouse – strict matriachy, strict traditional, first born) but I got the suggestion “non-eligible child”. I’m not sure if it is something wrong with the formula or have I misunderstood something?
2. Regarding traits – i’m not really sure which ones I should fill in where. For example for my spouses and founder, which is the child/teen trait? Or should I just put one in each collumn?

Thanks again!

Hi Cait,

1. I tried testing the input you described and the result it gives in my case is “Heir”. Did you fill out the gender, adoption status and mother/father collumns correctly? If you leave one empty it will not recognize the child as eligible.
2. It does not matter which trait you put in which collumn for founders and spouses.

HillieE

Doing my first legacy challenge and just want to give a shout-out to whoever designed Hillie’s spreadsheet. Very nice work.

Also very nervous because my dry-run at this challenge got me triplets before the couple even had a roof over their heads – literally. Some long nights there! Also noted it’s very difficult to “speed up” the game when you have children. Gotta watch those demons every second!

https://www.dropbox.com/ow/msft/edit/home/Legacy%20Challenge%20Scoresheet%20-%20Editable.xlsx
I have a founder and his wife, they had a baby boy. The laws I chose are Strict Patriarchy, Strict Traditional, First Born, and Xenophobic. According to this, their son Harmon, should be eligible for heir yet the suggested role says “non eligible child”

Other than that, This is the best score sheet I have found!

Hi Kianna,

I can’t open the file you posted a link to (I get an error message from dropbox). When I test the input you described, the result I get for the son is “Heir”. Could you post another link or email the filled out sheet to the adres listed in the contact section of the Instructions Sheet so I can try to figure out the problem?

HillieE

Hillie, the scoresheet is great the only thing that I see that you might want to add is Vampire to the Family Species chart. You have Human and Alien, why not Vamps too?

I love your sheet and it has been an asset to me during my legacy challenge. Thaxs for all your hard work and the time that you put in doing this. I know it took awhile and it is hard.

Hi Marie Dean,

Vampires have already been added in an update on january 26. Please redownload the sheet to use the most recent version including Vampires.

HillieE

Hi HillieE
I’m a huge fan of your work!!
I think you’re amazing!!
I’d love it if you updated the list with the bowling skill?

Elisabeth

Hi Elisabeth,

The bowling has now been added to the Score Sheet.

HillieE

[…] the base challenge without the extra challenges. You can find the scoresheet for this challenge here. I have decided upon the following succession […]

Hi everyone,

Just wanted to let you know that my scoresheet has been updated to include the Super Parent Aspiration en Parenting Skill.

HillieE

HillieE I bloody love your scoresheet. <3 <3 Thank you so much

Hi HillieE!

I have a problem with suggested role section. It worked fine until the generation 2 became parents, all of their children gets #VALUE! error. I’m in my generation 4 now and yet it is still the same. My succesion law is Equality – Traditional – Exemplar (Music Lover) – Tolerant. [Microsoft Office 2010]

It turns out that whenever “heir” puts into the legacy role, all of their kids gets #VALUE! error in suggested role.

I am currently having the same issue with this. Anyone know the fix?

It seem like all the spread sheets I tried lack todler update? I have tried Steve’s and

Becca’s*. Ps when Im entering my comment the field for it does not show me my words as a Itype =o

I have been using HillieE’s version and for some reason nothing fills in. I don’t know if I’m doing something wrong or what the issue is but no names are carrying over it’s all #NAME? In every block.

I was wondering if there would be an update on these sheets for Toddler Stuff Pck and the Pets expansion (for its release). Anyone have an idea if they will be updating these?

Thanks for these. I used Hilliee’s sheet. I just wonder what i must put genealogy page cell to Given birth to by? Because thare was placed mother and father what that cell means? Thanks anyway 🙂

I’m trying to make a copy but every time I open it up through my drive it just shows the view only version.

Hi Everyone,

My tracker has now been updated to include the Cats and Dogs Expansion Content. It also includes any Stuff Packs and Rule Updates that have been added since my last update in May 2017.

HillieE

Just stopping by to thank you again for your fantastic scoresheet, HillieE.

Hello again HillieE!
I’m sorry to bother you (again) but will you be updating your scoresheet to include the Jungle Adventure skills and aspirations?
Just now, I took a peek at your formulas to see if I could update them for my personal use but they are too complex for my limited spreadsheet experience.

Hi oshizu,

I already updated it a few weeks ago. I forgot to mentoin that on this page. You can download the new version now.

HillieE

Dear HillieE,
Oh that is so fabulous! I used your scoresheet for my first legacy and now I can’t use any other.
Thank you so, so, so much! <3 <3 <3
oshizu

Thanks for this again i love your scoresheet. 🙂 really appreciated

Hello – For SimGuySteve’s score sheet, the Number of Skills Reaching 10 cell does not automatically populate the value based on the number of Yes cells you chose on the skill list. You can have the spreadsheet calculate the number for you by adding the following calculation in Cell D32 on the Knowledge tab: =COUNTIF(C7:C25:C27:C30,”Yes”)

[…] keep track of the collections, which led me back to the legacy.  Using my favorite legacy tracker, Hilliee’s Legacy Scoresheet, I went ahead and caught up the legacy spreadsheet.  I was still legacy legal and, without playing […]

Jessica Kirk

I’ve just downloaded Hillie’s tracker and it looks amazing!! I just started my Legacy Challenge. I am having a problem though with the tracker. How do I add all three of the adult traits to my sims on the tracker? In the sim box I see a column for the Toddler Trait, Child Trait, Teen Trait, and only one Adult Trait. Am I missing something?

Hi Jessica,

Just add one of your adult traits to each collumn. All traits are present in each drop down list.

HillieE

Jessica Kirk

Thanks!! I knew I was missing something simple lol.

Josefine Vedel Andersen

Hi HillieE,

I just want to say many thanks for your spread sheet! I am totally in love with it, and use it for my legacy familiy, which is in generation 2 nearly 3 now, it really keeps me moitvated to keep going when I have it, and it’s also just fun to look at!
A quick question, will you make an update when seasons comes out? 😀

Josefine

Hi Josefine,

I intend to update it for seasons. I hope to get it done this weekend. I do depend on guides a lot though so it might take a little longer.

HillieE

Josefine Vedel Andersen

Okay, great, I will look foreward to it! Thank you so much! And it does not matter that it takes more than a weekend! 😀

Hi everyone,

My tracker has been updated to include the new Seasons Expansion Pack content. You can now download the new version using the link on this page.

HillieE

THANK YOU THANK YOU THANK YOU!

HillieE
Will you update your spreadsheet to include the 3 new points you can get from Seasons too?

Yes, I just finished the update

Thank you!!! Much appreciated, thank you for the work you put into this.

Will the printable one by nerdy bunny be updated for seasons soon?

That I’m not sure about. I think she said she was working on it, but has also been busy IRL.

[…] are now three official scorekeepers on Pinstar’s legacy challenge website. However I had already spent some time creating my own. It was super fun to figure out how much to […]

Hi! I don’t know if it’s because of my computer, but the really handy sheet by NerdyBunny is not really readable… Should I print it for it to be? Thanks, love the challenge!

When will the Hilliee Scoresheet be updated for Get Famous. I want to continue my legacy and their scoresheet is the best!

Hi Roosmarijn,

I’ll probably start working on it tomorrow and hope to finish by monday. After monday I have to work so if it’s not done by monday it probably won’t be done before next Sunday.

HillieE

Hi everyone,

I’ve finished updating my tracker. It now includes the content from the Get Famous Pack and the November Patch.

HillieE

Whoops. I forgot to add the Positivity Challenge Collection and Aspiration and the Drama Club Career/Afterschool Activity. They have been added as well.

HillieE

Love it! Thank yooouuu!

Hi everyone,

I’ve finished updating my tracker. It now includes the content from the StrangerVille Pack and some missing content from the Get Famous Expansion (new social events)

HillieE

Hi Hillie,

I just downloaded your spreadsheet for my first (FIRST!!) attempt at a legacy challenge and when I look at the Athletics scoring chart all of the aspirations are hovering over where you click to select if an aspiration has been completed.

It doesn’t do it on your dropbox link, but it does on my Windows’ Excel, which seems to be up to date. Basically when I scroll that tab of Excel, the pictures stay stationary but I can see the section for inputting data scrolling underneath them.

If you have any insights on why this might be happening or how to fix it I would appreciate it! Obviously I won’t need this right away but I’d like to figure out how to fix it before I need it, haha!

Thanks,
Carrie 🙂

Hillie,

NEVERMIND, I figured out I could just reduce the magnification for that one tab and I could see it. LOL, I’ve never used Excel before and it probably shows. 😉

Hi everyone,

I’ve updated my tracker to include the latest Rule changes (mainly scoring requirements). I’ve also added the option to the Rules Sheet to play with the ‘old style’ scoring requirements.

HillieE

Thank you HillieE! That was fast!

BlackjackWidow

I’m trying to leave a comment here, but for some reason it keeps giving me an error. This is a test reply – maybe my message is too long?

I am a big fan of your tracker HillieE! It’s showing the March 4th update as the most recent for me, however. Am I missing something?

I forgot to open Dropbox to update the file, sorry… It’s up now.

Aimy Braithwaite

Thanks HillieE, you’re a lifesaver!

BlackjackWidow

Yep – it must be too long. Sorry for the multiple posts 🙂

Hillie –

I can’t thank you enough for your spreadsheet – it has truly saved my life while I work through my first Legacy Challenge. Thanks, too, for including the option to keep the “old style” scoring, since I’m only playing with base game, I really don’t want to change mid-stream.

I was just going through the last update for Strangerville and you uploaded this new one, so I’m not sure these have carried over, but wanted to drop you a note and let you know a couple of things that I noticed. I will be posting more than one comment, because it will not accept my full post for some reason.

BlackjackWidow

(I think I figured out the problem – I was putting the hashtag mark in front of the value error, and it’s screwing up the post for some reason)

1. The error in the formula for the suggested role column resurfaced for me. This is resulting in a “VALUE” error in the suggested role when calculating for my heirs. I am running Equality – Strict Traditional – Exemplar:Geek. Base game with RG pack. On the old sheet, there was an error starting at row 30, and copying the formula from row 29 fixed the error. Unfortunately, the new error seems to be in the whole column. It will correctly handle designating the primary spouse and cadet spouses and children if I mark the heir, but seems to be an error handling the exemplar trait rule.

To see the error, just use the exemplar trait rule, enter a Founder with the exemplar trait and a Primary Spouse, then enter a couple of children with or without the exemplar trait. The suggested role will throw the error.

If the heir is alive and in the household, and none of the children have the exemplar trait, they should all be marked Potential Heir. If one has the exemplar trait, should be marked Heir. If more than one has the exemplar trait, the oldest should be marked Heir. If the current heir is marked “dead”, AND there is no child with the exemplar trait, then the oldest child should be marked Heir and the siblings are then Spares.

2. Photography is available as a skill in the base game. I think the update patch for GF added it to the base game. So, Photography should be included in calculations in the Knowledge tab. It counts correctly if you use the custom rules to force photography.

3. Knowledge tab – Toddler skills are counted in the total number of skills, but are not added in the percentage completed calculations. Hard to explain – if you enter all available adult and child skills as having been completed at least once, the Percentage of Skills Maxed Out = 100%. If toddler skills are also all completed at least once, Percentage of Skills Maxed Out = 121%. I think this is because you are using 23 as the base number of skills. It should be 28 (29 if you add Photography to the base skills).

Again – I really appreciate the work you’ve done on this. I can’t imagine trying to figure out what I’m doing without it. 😀

Hi BlackjackWidow,

I’ll have to look into issue 1 and 2 sometime. My workplace is understaffed at the moment so I’m working about 6 days a week in the coming weeks so I don’t know when I will have time to do it (I’ll let you know when I have looked into it). Issue 3 was fixed in the last update (excluding Photography).

HillieE

BlackjackWidow

Hillie – Thank you! You do such wonderful work, your spreadsheet is the best. Try not to work too hard – which I know is easier said than done 🙂

Hi BlackJackWidow,

I finally got around to fixing these issues. Hope everything works correctly now.

HillieE

BlackjackWidow

Hi Hillie – So sorry to take so long to answer, I didn’t get notified there was a reply.

There are no more error messages, that is great! The exemplar trait works exactly like it should EXCEPT if it’s entered in the Teen trait column. It doesn’t show an error message any more, but it doesn’t change the role to Heir, either.

I’m so sorry to point it out – I know this had to be a lot of work. I really appreciate everything you do with this scoresheet – it really is the best one, and the only one I ever use. Thanks for everything you do.

BlackjackWidow

Good morning. I’m using Hilliee’s Scoresheet for my 2 Legacies (the first one was started in 2014 and I’m currently on Gen 3 still waiting for Gen 4 Heir; I’ve started the second one to use the new rules for Get Famous). The first Legacy’s scoresheet is working just fine, I’ve inserted all the data for my founder and spouse/2° gen heir and spouse/3° gen heir and spouse/4° gen kids and all the other spares/cadet spouses/cadet children. The problem is starting now that I’m inserting data for the 2° Legacy’s scoresheet. My founder’s first child is a non-eligible child (I’m playing with Strict Equality, Traditional, Exemplar – Vegetarian, Brood and the first child is a female – just like the founder). Now she’s expecting her second child, which is going to be a male (I use MC Command Center just to know the children’s sex before they are born) and – using the site’s trait generator – will be a vegetarian. But when I enter his data, in the suggested role section I get the Err: 502. I also tried to download the scoresheet again, but it doesn’t change.

BlackjackWidow

Yep – I’m experiencing the same thing, whenever the exemplar rule is in force it generates a “value” error on mine. Until Hillie gets some time to look at it, you can either just fill in the correct role for each person or if you’re familiar with excel, unprotect the sheet in both your old and new versions and copy the working code from that column to the new sheet. Then protect the sheets again so you don’t accidentally overwrite anything.

This worked for me, although my old copy was not from so far back. You could give it a try and see how it goes. There’s some new careers that I’m sure she will be adding to the worksheets when she can and hopefully she will correct the errors in the suggested role column, too.

I love Hillie’s spreadsheet – it keeps me sane. 🙂

Thanks for the advice. I’m not really familiar with excel, so I’ll only change the role to what it should be and will wait for an update.

Just an FYI:
Drew’s Legacy Challenge Tracking Assistant – is not there anymore
Hilliee’s Legacy Scoresheet – Is now updated for Get Famous

Does anyone know if there’s a way to copy over data from one excel scoresheet to another? I’m using an older version Hilliee’s Legacy Scoresheet and would like to start using the updated one. The prospect of having to type everything in by hand (again) is daunting. I’m in my 8th generation so if there’s a way it would be a life saver.

BlackjackWidow

stormcat – I usually just copy the user entry fields from one to the other. You don’t want to copy over the whole sheet, as it will get rid of the programming changes and such. But, for instance, you can use your mouse to highlight what you entered in the Genealogy tab, from Generation to Spouse, then copy, go to the new sheet and put your cursor in the first cell under Generation and paste. Then you’ll get the suggest roles to come up. https://support.office.com/en-us/article/move-or-copy-cells-and-cell-contents-803d65eb-6a3e-4534-8c6f-ff12d1c4139e

Hello, I loved the challenge, but I’m having problems with spreadsheets. I’m Brazilian and I have not found any of them in Portuguese, I’m desperate for it. I tried to translate the spreadsheets made available, but as the formulas are hidden, it is impossible to do it right. Is there any way to make a spreadsheet with the formulas available to me? Or I know it, I’m really desperate.

Hi! Pinstar and I didn’t create the spreadsheets currently being used (we just aren’t very spreadsheet savvy), so I’m not sure how to go about doing that. That might be something to ask the individual spreadsheet creators.

BlackjackWidow

Hi Ayrthwil – depending on the way the author did the spreadsheet protection, you should be able to go to the Review tab and click the button that says “Unprotect Sheet” (unlocks the current tab) or “Unprotect Workbook” (unlocks the whole spreadsheet). I would suggest you make a copy and work on the copy so you can go back if anything messes up.

Lindsey Schulte

So about Hillee’s Legacy Scoresheet. It seems so promising but whenever i go to open it it says that the file is corrupt. It’s by far the best looking one i’ve seen in a while but i cant use it. Is this my own issue or is it the actual spreadsheet. I’ve seen nobody else with this issue so im a bit confused is all.

Alexandra R

Hey, just curious if we could expect any updates to the rules regarding the addition of Island living as well as the free lancer career, cant wait for Hillee to update the sheet and Im sure its in the works but I know thats coordinated with you guys 🙂 Cant wait!

We aren’t planning on updating it for Island Living. We don’t own the pack and therefore it will be difficult to plan out the rules for it without being able to playtest it.

Hi! I would love to try HillieE’s scoresheet, but when I click the link the original version is opened in a new tab, and I cannot find that there is an option to copy it and make my own version. I do have Dropbox installed on my computer. Tips, anyone? Thankful for any help!

Hilliee’s Legacy Scoresheet – Updated to include Seasons! I love this scoresheet but I can not use the latest version in Microsoft Excel App as it is to large. The Get famouse version are 1,490 kB and this last one is 5,414 kB. Excel app can’t handle files bigger than 5 MB. I use the one for Get famouse for now and totally understand that I might not ever have the chance to use later updates coz of this “problem”. I guess it will be paper and pencil for the Island living scores for now. Thanks for all your hard work with this scoresheet, it’s really fab 😀

Hi everyone,

My scoresheet has been updated to include the Moschino Stuff Pack and Realm of Magic Game Pack content.

HillieE

Hi all,

I tried to use HillieE’s scoresheet but it seems there’s a problem in the love section, keeps saying “error 508” or “error 512”. I don’t know if it’s coming from the file or from the fact that I use OpenOffice calc instead of Excel. Any help would be appreciated 🙂

For HillieE’s Scoresheet, this isn’t a major issue, but in the ‘Packs’ section, Moschino Stuff is labelled My First Pet Stuff instead of, well, Moschino Stuff. It’s not too annoying, but it is a thing that is there.
🙂

Is there any idea of when there will be any sheet updates for Discover University? I’m really wanting to incorporate that pack into my legacy challenge!

yeah, any clue? i want to start my legacy but i dont want to mess it up or have to restart the tracking…

Cecilia Johansson

In HillieEs scoreshets in the Family section under trivia numbers for spelcaster in the family is not ther.

hey HillieEs your Scorsheet is absolutely genius! I have some issues though :
The spellcaster is not listed as race and for a reason all my childs are non-eligible. That only happens with the strict equality rule. Hope to get some help soon. Greetings, Nyela

@NyelaPheles

If your last heir was male and all your children are male, then all of your children will be ineligible. This also applies in the case of all sims being female. With strict equality, if your heir is male, then your next heir must be female, and then male again, and so on.

Hey, I’ve been wondering how I am suposed to check the last two boxes in “Popularity”

1)Have a single Sim Earn a Gold Medal for every type of Social Event

2)Earn all possible Club Perks with your Legacy Club

Where do we register this information? I have not been able to find it.

I have an issue with genealogy in new HillieEs scoresheet . I use the same settings as always (strict patriarchy, strict traditional, first born, xenophobic), but my oldest males are always suggested as “non-eligible child” not “heir”. I thought the reason was copying genealogy from the sheet I use now, but i have the same trouble even if I do all the job manually. What did I do wrong?

Hey, just starting to use Hilliee’s scoresheet. I am super impressed, it’s so in-depth. Thank you so much for sharing.

I have a question, can you check off an obtained skill more then once in the knowledge category? For example, my founder completed level 10 of the cooking skill but one of my primary spouses completed level 10 cooking, gourmet cooking and mixology to gain the point in the food category. I am concerned that if I have the founder and spouse showing that they both obtained cooking skill level 10 then the calculator would add that as an additional independent skill.

Thank you for your help in advance 🙂

Hello! Thank you all so much for your time to do scoresheets, read and reply to comments too.

I may have found problem with hilliee legacy scoresheet in the knowledge and the athletic tab, the “Max out all skills at least once” and the “complete all of the aspirations at least once”, respectively, doesn’t ever get completed. The first one gets stuck at 96% while the other stays in 102%, interestingly.
By the way, I’m just testing the spreadsheet, I didn’t actually manage to do this ingame yet and update the scoresheet accordingly to the respective sims life. So therefore, some info about the sim coud be missing and that may be the reason for this effect.
This applies if one sim completes all of the skiils/aspirations or multiple sims do it.

Hey Anon (and maybe HillieE),

I also appreciate the scoresheets and I really like HillieE’s.
As I wanted to know which skill refers to which Pack, I took the time to look into the formula for “Percentage of skills maxed out” in the knowledge tab of HillieE’s scoresheet.
I’ve found out that 28 columns were referenced for the base game (see sum for “Easy”-Rule for example), but the sum of these will be divided by 29. So, I guess one skill is missing for the base game. If that’s the case, it’s likely to be the “Piano”-skill (field AB18), because if one of your sims achieves the “piano”-skill, it’s not taken into account anywhere.
(The missing skill also affects the other rules e.g. “Hard” and therefore one can never achieve 100%. By adding “AB18” to the appropriate sums, this problem should be solved)

There’s another minor mistake affecting the “Jungle Adventure”-Pack (Packs!J10). Instead of the “archaelogy” skill (D18) an empty field (A18) and therefor 0 will be added to the skill count. By replacing A18 with D18 everything is fine. 🙂

And I don’t think that there’s a mistake in the athletic tab. By following the Legacy Challenge your sims can’t complete the aspiration “City Native” from the City Living Pack – at least that’s what I read here. The aspiration is shown in the list, but it won’t count into the divisor. Ignoring (not completing the aspiration) should be alright.

I hope the scoresheet stays/will be updated with future packs (I spotted the “discover university” bonus lately on this site) . It’s so much fun using the scoresheet. I’m on my first legacy challenge ever.
Thanks for all of you involved.

How do I edit the Sims Steve spreadsheet. When I try and input the information I get a message saying protected cells cannot be edited. I have no idea what I’m doing tbh.

Anyone else having a problem saving HillieE’s spreadsheet? It keeps telling me that the file needs to be repaired but it just saves a blank excel sheet.

My problem in that in her genealogy section their is no dropdown for choosing gender, bloodline, heir, and species laws and you can’t type it in either.

I have a question for Hilliee, on your genealogy spreadsheet the cell where you are to pick your gender laws their is no drop down menus for that section I am unable to pick. but a friend that downloaded it a while back has the drop downs curious to know why and if it’s fixable cause it will not let me type in that area…..

The Becky’s Legacy Scoresheet seem to be hosted on a Discord chat and can’t be downloaded as far as I can tell. Perhaps you need to be on whichever discord it is to be able to download? As this is the newest and the only one likely to be updated for the new expansion I would love to have this fixed 🙂

Hi,

I saw your comment.
It is indeed a link to the legacy challenge discord server, but this is the link to the document: https://docs.google.com/spreadsheets/d/1zXQFKHqj63Uo1YlQOvnbotPFGmSPtK8M091uImGFp_4/edit?usp=sharing

I fixed some bugs, so for anyone who already downloaded, it should be working correctly now.
I am indeed planning on updating it for the upcoming packs, but that might take about a week.
I’ll make sure to post it on my tumblr when it’s updated.

Thanks for the support 🙂

Whoops! Sorry about this. I’m not sure why it did that. I’ll fix it right now!

the link for Becky’s legacy scoresheet –that was updated in July 2020– just takes me to Discord? I cant find any servers either for it. Please help!

Edit: Sorry I just saw the comments above and found the link!

Sorry about that. I have no idea how that happened. I even checked the link before I posted it. It should be fixed now.

Becky’s spreadsheet has an error on the “knowledge” sheet in the list were the names populate.

Becky van Kleef

Hi, Thats fixed now! 🙂

Also on the overview sheet, the knowledge, athletic and total boxes are showing as “NO DATA”

Becky van Kleef

Hi, that’s fixed now too!

Are you having a problem with Biography, photo, and Comedy Routine showing up miss labeled with the pie chart? The other three are fine. But when I select photo, it comes up as Biography. Biography=Comedy Routine, Comedy Routine=Photo. On my copy, I can’t figure out how to fix this.

Hi Shannon,

Thanks for letting me know! It’s fixed now, please save a new copy through the link in order to see the changes.

Thank you so much. You’re the best

Hello Becky! Thank you for your amazing spreadsheet, it’s awesome! I just downloaded it and noticed a tiny error regarding the count of Sims “Alive, in legacy household” because the column you took is S, while it should be T ! I fixed it in my copy of course but it’s just in case someone misses it and doesn’t know how to do it 🙂 Thanks a lot for keeping it updated, the best to you!

Thank you Naerys for letting me know. I fixed it.

I have a question for Hilliee, Is there going to be an update to include Eco lifestyle and the knitting stuffpack? Thank you!

Does the Re-Traiting Potion (Seasons) belong to the “consumable aspiration rewards”? Should it be stored on the lot with the other potions for 1 point in the nature category?

I couldn’t find an entry for it in the Scoresheets (Hilliee’s, Becky’s) on this site. They are normally good references. Pinstar’s Scoresheet is not that detailed to give a hint in this question.

I’ve found the answer in the comments from July 12, 2018 on the Scoring Side. The Re-Traiting Potion is part of the consumable aspiration rewards.
It’s only missing in the scoresheets I’ve looked at.

Hi everyone,

I’ve just finished a long overdue update for my scoresheet adding all the missing packs. I’m not really playing the Sims anymore and haven’t bought any of the recently released packs making it harder to keep doing updates. Special Thanks to ‘Sparks and Play’ for making this update possible by providing me with all the info and icons/pics I needed.

HillieE

Thanks to update Hillie. I just wonder can you someday add also those new Heir laws on your sheet? Magical Bloodline and Magical Strength.

erninification

Hi everyone,

Just wanted to share an editable PDF I made for the challenge which was inspired by NerdyBunny’s rulebook & scoresheet!

The link is below:
https://www.dropbox.com/s/zz5ez0dsxnimill/Legacy%20Challenge%20Scorekeeper%20V%201.2.pdf.pdf?dl=0

For the picture upload you need Adobe Acrobat

I tried using Hillie’s scoresheet and it wouldn’t let me edit it? Even on the colored cells where you have to type in an option or use a dropdown menu, it wouldn’t edit the sheet. Does anyone know how to fix this?

I’m going to try this challenge for the first time and will be using Hilliee’s Legacy Scoresheet. I’m just confused about the naming of the generations. Does gen 1 in the sheet refer to founders generation? I’m used to seeing gen 0 as the parents/ founders.

I need help with Becky’s Legacy Scoresheet. So I am trying to figure out how to add all the children to the scoresheet so I can keep track of who had who. But when I tried that tonight it messed up the formulas badly. So I redownloaded the excel sheet since I could not figure out what went wrong. My next issue is every time I open the excel sheet I get an error message saying something went wrong and some things are missing from the sheet and that Xcel can try to fix it. I say yes and then every time I open the sheet form then on I get the same error message anyone knows how to stop this as I have to create a new save every time for this file because of it.

Hi, the problem might be that you want to open it in Excel instead of in google spreadsheets. I’m not sure but I think the formulas might be different in Excel opposed to google spreadsheets. Please try opening it in Google spreadsheets. Also, I’m planning on updating the sheet this weekend. I might even make a totally new version but it depends on how much time I have.

I downloaded Hilliee’s sheet and it’s great, but I cannot scroll on the athletics page. Is there a way to fix this? I already started filling it out and would like to avoid redownloading the sheet.

I fixed it! If anyone else is having this problem, go to View at the top –> Freeze Panes –> Unfreeze Panes.

I downloaded Hilliee’s sheet and it’s great, but it’s not counting the “Beach Life” aspiration in the totals ( Athletic tab, cells L4 & L5).
I have the Island Living checked as “Yes” in the Packs tab.

Simply Whit’s Boutique

I downloaded Hilliee’s scoresheet and its wonderful, I was just wondering if it is going to be updated to include the new meteorite death, the new werewolf occult and the new aspirations that come with the werewolf game pack?

I was hoping the same. Also if they going to add the new social events like prom. Right now I’m adding it in the notes, since the medals can be counted.

I love hilliee score sheet and was wondering if it would get updated any time soon or if I needed to look elsewhere if they have it somewhere else to download. It would also be amazing if the gender had Non-binary in the mix so that we can acknowledge in the sheet when our sims have different pronouns.

I came here to find out this, too. It’s the best!

Hi everyone,

I made a long overdue update for my scoresheet. It include all missing content including Growing Together. I took a long break from the Sims but Growing Together got me motivated to play again. Hope everyone enjoys the update.

HillieE

I love you so much <3

Thanks for updating HillieE!!

I’m using HillieE’s scoresheet and have noticed that there are a lot of aspirations missing from the Rules tab of the spreadsheet. There are some missing from the Nature tab as well. Am I just missing or not understanding something?

Thanks so much, HillieE (´▽`ʃ♡ƪ)

I have been using Hillee’s spreadsheet for years and I love it. I’m nearing the end of my legacy and have noticed that there are problems with the Knowledge and Nature tabs. I have maxed all skills at least once, but it is still showing 98%. Similar issue with Percentage of Careers Maxed. Any help would be greatly appreciated!

I am lost as to how I put in my maxed skills and aspirations

Sorry, I should have been a little more detailed.

I have started using Hillee’s spreadsheet, very awesome, but I am lost as to how I put in my maxed skills and aspirations

Thank you.

Ok, after doing some back log reading I figured out the solution to my problem. Thanks Hillee for an awesome spreadsheet.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.