Robinson Legacy Challenge Scoresheet
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
General InformationLegend
3
This Excel-document helps you to keep track of the points you Legacy Family scores. It contains many formulas that will keep track of whether you have met certain goals or not. It will also adjust for whether you own certain expansion/game/accessory packs. Many cells in the sheet are protected to make sure you don't accidentally mess up the formulas in the cells. However, you can unlock all sheets without a password if you wish (just make sure you know what you are doing when making changes). The cells in this document are colored to help you identify which cells are calculated automatically and which require you to enter information (see legend). Each individual sheet also contains a HELP box that will explain how that sheet works. I hope you find this document useful. I wish you best of luck and a lot of fun playing your Legacy Challenge!A cell with a yellow background requires you to enter text
4
A cell with a blue background requires you to select an option from a drop down menu
5
0A cell with a cross and gray background will turn into a checkmark if you type a 1 in it. Type a 0 to uncheck the cell (you can only enter 1 or 0 in this cell type).
6
A cell with an orange background contains a formula and can not be edited
7
A cell with a white background contains text and can not be edited
8
HELPHIDEEach sheet contains an empty textbox and this pair of cells. If you select SHOW in the cell with the dropdown menu next to the HELP cell an explanation of the sheet will appear in the textbox.
9
10
11
12
1. Read the General Information and the Legend TableLegacy Challenge Introductionhttp://www.simslegacychallenge.com/the-sims-4-legacy-challenge-rules/
13
2. Go to the Packs sheet and fill out which games you ownLegacy Challenge Succesion Lawshttp://www.simslegacychallenge.com/sims-4-legacy-challenge-rules-succession-laws/
14
3. Go to the Rules sheet and select the Handicaps, Succession Laws and Difficulty Settings you're usingLegacy Challenge Ruleshttp://www.simslegacychallenge.com/sims-4-legacy-challenge-gameplay-rules/
15
4. Go to the Genealogy sheet and fill out the information about the Sims in your Legacy FamilyLegacy Challenge Scoring
http://www.simslegacychallenge.com/sims-4-legacy-challenge-rules-scoring-bulletpoint-format/
16
5. Fill out the remaining sheets and let the tracker calculate your scoreRandom Trait Generator
http://www.simslegacychallenge.com/sims-4-legacy-challenge-random-trait-generator/
17
Legacy Challenge F.A.Q.http://www.simslegacychallenge.com/the-sims-4-legacy-challenge-rules/faq/
18
Contact
19
Did you encounter a problem while using the sheet? Have you found a bug/error/typo? Do you have a suggestion for a new feature/improvement? Please let me know! There are several ways to contact me: Updates
20
DateDescription
21
1. By leaving a comment on the Scoresheet section of www.simslegacychallenge.com these comments do need to be moderated so it may take a few days before I can read your comment and post a reply. Website link:
May 31, 2017
Parenthood Update:
22
- Added the Sims 4 Parenthood Game Pack to the Packs Sheet
23
http://www.simslegacychallenge.com/sims-4-legacy-challenge-scoresheets/- Added the Parenting Skill and Super Parent Aspirations to the Rules Sheet
24
2. By sending an email to hillieelegacyscoresheet@gmail.com- Added the Parenting Skill to the Knowledge Sheet and adjusted the formulas
25
- Added the Super Parent Aspiration to the Athletic Sheet and adjusted the formulas
26
- Updated the Random Trait Generator to include the Vampire en Parenthood Pack aspirations
27
April 20, 2017
- Added the number of Vampires score to the Family Sheet
28
Bowling Night Stuff Update:
29
- Added the Bowling Night Stuff Pack to the Packs Sheet
30
- Added the Bowling Skill to the Knowledge Sheet and adjusted the formulas
31
January 26, 2017
General fixes:
32
- Fixed an issue with the Random Trait Generator which would cause an error when trying to roll all traits when owning the City Living Expansion
33
34
35
- Added a settings section to the Rules Sheet which allows you to select which skills/aspirations/careers/parties/deaths are counted and required in the scoring of the challenge
36
37
- Added the Vintage Glamour Stuff Pack to the Packs Sheet
38
- Added the Toddler Skills to the Knowledge Sheet
39
Vampire Update:
40
- Added the Vampire Game Pack to the Packs Sheet
41
- Added vampires to the dropdown menu for species on the Genealogy Sheet and updated the suggested role section
42
43
- Added the Vampire Lore Skill and Pipe Organ Skill to the Knowledge Sheet
44
- Added the new vampire Aspirations to the Atheletic Sheet
45
- Added the Death by Sunlight to the Nature Sheet
46
January 15, 2017General fixes:
47
- Fixed an issue with the Love Sheet nog counting the Unflirty and Vegetarian Traits in the Love score
48
Toddler Update:
49
- Added a Toddler Trait section to the Genealogy Sheet
50
- Added the Toddler Traits to the Random Trait Generator
51
December 1, 2016- Fixed an issue with the Random Trait Generator where it would not generate the Teen Trait and Adult Trait if the generate alle Traits option was chosen
52
53
November 7, 2016- Removed the City Native Aspiration as a requirement for 'the complete all aspirations at least once'-goal since it is impossible to complete this aspiration during a legacy challenge without cheating. I decided to leave the aspiration on the sheet because some people might want to complete it by cheating past the 'impossible' goals.
54
55
56
57
- Added the Snowglobes, City Posters and Sugar Skulls Collections to the Nature Sheet
58
- Fixed an issue with the 'reach the top of both food career branches' goal on the Food Sheet, where it recognized the Critic career branches instead of the Food career branches
59
60
- Fixed an issue with the Popularity Sheet where it would not complete the 'earn a gold medal for all party types'-goal if you owned the Get Together Expansion Pack
61
62
November 5, 2016
City Living Update:
63
- Added the City Living Expansion Pack to the Packs Sheet
64
- Added the Unflirty and Vegetarian Traits to the drop down menus, Love Sheet and Random Trait Generator
65
66
- Added the Singing Skill to the Knowledge Sheet and updated the formulas
67
- Added the City Native Aspiration to the Athletic Sheet and the Random Trait Generator and updated the formulas
68
69
- Added the Pufferfish Death Type to the Nature Sheet
70
- Added the Critic, Politician and Social Media Careers to the Nature Sheet and updated the formulas
71
August 19,2016- Fixed an issue with the Love Sheet not recognizing the traits of Primary Spouses in generations after a generation with no Primary Spouse
72
73
August 17, 2016
- Added the Backyard Stuff Pack to the Packs Sheet
74
- Updated the Contact Information since the Forums no longer exist
75
June 30, 2016
- Added the Kids Room Stuff Pack to the Packs Sheet
76
- Added the Voidcritters Collection to the Nature Sheet
77
June 25, 2016
- Fixed an issue with the 'Suggested Role' column on the Genealogy Sheet not working correctly when the Exemplar Law was chosen
78
79
- Added the Sims 4 Dine Out Game Pack to the Packs Sheet and added the Experimental Food Collection to the Nature Sheet
80
81
- Edited the Dance Party on the Popularity Sheet since no medals can be earned for this social event (removed it as a requirement for the 10th popularity point and changed the dropdown menu)
82
83
March 28, 2016
- Multiple people were having issues with the Love Sheet. I decided to build a new Love Sheet from the ground up hoping this will fix the issues. The new Sheet looks similar to the old one.
84
March 13, 2016
- Renamed the 'Handicaps' Sheet into the 'Rules' Sheet and moved the Succession Laws there to make the Genealogy Sheet less intimidating
85
- Added a 'Getting Started' Section and a 'Contact' Section to the Instructions Sheet
86
- Created a new Generators Sheet with a new Random Trait Generator
87
- Moved the Random Heir Generator to the Generators Sheet to make the Genealogy Sheet less intimidating
88
March 4, 2016
- Fixed an issue with the love sheet not recognizing the traits in cells J34 and K34 of the Genealogy sheet
89
90
- Added additional slots to the Potentials Heirs table and Random Heir Generator
91
- Added the Movie Hangout and Romantic Garden Stuff Packs to the Packs sheet
92
February 23, 2016
- Fixed an issue with dropdown arrows in the Genealogy sheet caused by an Excel bug.
93
- Updated the formula for percentage of completed aspirations on the Athletic Sheet.
94
February 15, 2016
Patch Update:
95
- Added the Grilled Cheese Aspiration to the Athletic Sheet
96
- Added the Kleptomaniac Trait to the dropdown menus and Love sheet
97
December 19, 2015
- The dynamic pictures in the overview section were making the sheet quite a large and slow file.
98
To optimize the sheet I turned them into pictures that are revealed as you score points. If you prefer to use the old sheet with the dynamic pictures you can download it here:
99
https://www.dropbox.com/s/jtluhgczspk0zni/Legacy%20Challenge%20Scoresheet%20%28old%29.2.xlsx?dl=0
100
December 11, 2015
Get Together Update: