Hi! I MUST learn more about your spreadsheet! I saw you mentioned in another ask how you figure out your sim's OTH, Asperation, etc but how does the process work? :D
Hi! Thanks for your question. :)
Well, it's a bit too complicated to describe in any great detail, but essentially for each characteristic, I have devised an individual formula that determines the strength of that characteristic for each Sim, on a scale from -1 to 1, with -1 meaning that they absolutely don't have that characteristic and 1 meaning that they absolutely do; anything between -1 and 1 gives the relative strength of the characteristic, and zero is neutral.
For each characteristic, I sum the 3t2 Traits that count positively towards having that characteristic, subtract those that count negatively towards it, modify according to personality and interests, then normalise by the number of factors that I've taken into account.
So, to take just one example, the formula that determines whether a Sim has the OTH of Sport takes into account whether the Sim is Ambitious, Athletic, Equestrian, Party Animal, Social Butterfly or Vehicle Enthusiast (3t2 Traits that I count as 'positive' factors for a OTH of Sport - I see Sport as quite a gregarious hobby, for Sims who are obviously ambitious for their team to win!), or whether they are Brooding, Eccentric or Loner (3t2 Traits that I see as 'negative' factors for a OTH of Sport). It also considers how active they are, and of course how interested in sport they actually are!
Sport is the highest-scoring OTH for Bertram Bennet, with a score of 0.51. He's active (9) with a reasonably strong natural interest in sport (6.3), and while he doesn't have any of the 'positive' traits, he doesn't have any of the 'negative' ones either.
Of course, I have my own ideas of what makes a Sim more likely to have a particular Trait, OTH, Aspiration, Career or Turn-on/off, and they might differ from other people's, but it works for me.
I've recently installed @lamare-sims 50 New LTWs, and for completeness I should probably incorporate those into my spreadsheet, but that would mean adding 50+ more columns, and that seems a little daunting! For Sims created before I installed them, I've been using @lamare-sims LTW Chooser to select the most appropriate LTW from those available to them (based on their other characteristics), and for Sims born-in-game since then, I'll be letting the LTW Chooser select for me, and seeing how that goes.
I hope that helps to explain a bit?
