The Sims 2 JRP Spreadsheet for keeping track of your Sims!
I was editing my personal spreadsheet today when it occured to me that maybe some of you would like to use something like this too, so here it is!
It started as something deeply inspired by PleasantSims spreadsheet but evolved many times over the years to what you see today.
HERE'S THE LINK !!!
It's based off the Pleasantview families as an empty template, but please, use it however you'd like!
There are notes for things that may be a little unclear, you can delete them by clicking the RMB on a cell with the note.
JUST MAKE A COPY FOR YOURSELF AND YOU'RE GOOD TO GO... BUT!
If you're not very familiar with Google spreadsheets and/or not going to read the whole post, I recommend reading this:
-> On your own copy you can edit anything you want, just make sure to unmerge the cells that are in your way.
-> There's no zodiac sign column - I don't feel the need to keep track of it, but if you do, just follow the first point (I recommend adding it after Orientation or Vibes, less unmerging :))
-> There's some conditional formatting (pics and more details below) but feel free to change the colors or even remove it altogether.
-> One column (D) has a function! More details below but if you're scared/don't want to be bothered with it you can just ignore/delete it.
-> It's designed to work with other sheets (not included), that's why you can see a hidden column at the end that just adds "1" to every cell. This allows you to (for example) create charts with your hood's overall genetics if you're crazy like me
Feel free to reach out to me if something's unclear or if you need any help!
Detailed description below ↓
GENERAL OVERVIEW AND HOW DOES IT WORK
In the first pic you can see the whole spreadsheet with some information filled in as an example.
First 3 rows are locked, meaning that you'll always see them no matter how far you may scroll!
There's a lot of drop-down lists so you don't have to type in stuff like Aspirations, Turn-Ons/Offs, Hobbies, etc. You can of course edit them yourself by clicking the edit button at the end of the list!
The yellow rows hold information about a whole household, below them are Sims that are currently in that household. Another yellow block means another family.
You can add/drag/remove the rows with Sims to your liking (well, almost! If you want to use that function I mentioned earlier see "Second & Third Row" section"!) and if you want to add another household just copy and paste the yellow template.
FIRST ROW
Here I keep track of general informations about the whole hood:
-> Day of the week
-> Season
-> Day - in connection to season (it used to mean an exact day of the season but I kept getting confused so now I just put there the number of days that are left of that season, a.k.a the information that the game directly gives me)
-> Family tree - I know some of you (me included!) use various sites for family trees so here you can link it!
-> Free space - for any notes you might have
SECOND & THIRD ROW
All the information I want to keep track of grouped into categories: Familial, Character, Romantic, Career, Hobby, Likes, Misc., Age and Genetics. I won't go over all of them, I think most of them speak for themselves. Here are some that may need additional info:
-> GEN - simply generation. How you use it is entirely up to you (as this whole spreadsheet!) but if you need an inspiration see the first pic.
-> Partner (F) - F means that there's a function involved! It's completely optional, you can just delete it along with the gray conditional formatting if you don't want it.
How it works? If your Sim doesn't have an aspiration (so a child or below, you have to choose "N/A" in the Aspiration column) the cells in this column will automatically display "N/A". If a Sim has an aspiration, the cell will become gray to indicate that they're single and ready to mingle. If you want to input a name of a partner, I recommend clicking on the cell and putting it in the empty "" string. If you type straight into the cell you will delete the function for that cell. Similar to manually created rows - the function won't appear. No worries, you can copy it from a row above, just ensure that it has a correct row number (so a row number that you're currently on!). Is it revolutionary? No, but it was fun to learn!
You can also change/delete the gray color by clicking the RMB on the column D and choosing Conditional Formating.
-> Personality & Vibes - the former I use to store one or more traits that the Sim has the most points in, the latter I use to additionally describe them as I see fit (examples in the first pic).
If you think Vibes are unnecessary but you want to add Zodiac signs, I think this is the best place to put them as you just need to change the name of this column and you're done!
-> Money & Notes - a place to keep track of your Sim's personal savings and notes
-> Days until... - your Sim ages to the next age stage. Different with elders! I just input the number of days lived.
-> Stage - here lies the other conditional formatting I made! Age stages are color-coded (pics are above), as with the other one, feel free to change/delete it.
HOUSEHOLD INFO - YELLOW ROWS
First yellow row (merged) is the household name. In the second one you can find:
-> Rotation - keep track of it however you like! I just use days played because I don't always play the same amount of days per round.
-> Money - household funds
-> Maid, Gardener, Nanny and Butler - do you also keep forgetting if your Sims have already hired the gardener or not? I do. I finally figured out a neat way to track it! Just tick/untick the box!
-> Business - undo strike-through if the family has a business on a home/community lot
-> Pets - nothing creative here, just some place to keep the information about the household's pets
-> Notes - a place for your household notes! (there's never to many places for notes)
Okay, at this point you know EVERYTHING!
*passes out*
To celebrate, please have a look at this list of every non-ancestral, non-townie premade - and their sexuality according to pre-set attraction (via SimPE).
As of the morning of the 2nd June, I have done PV, ST, VV, BwV, RbH, DV, BdC and the stealth hoods. I plan to add iconic Downtownies, the Tricous, and University playables when I get the time.
CW: I used "Super Straight" to indicate sims which have a positive heterosexual and negative homosexual attraction - but tell me now if you don't think Tank Grunt wouldn't identify as such.
