I decided that a sim's ideal family size would be dependent on their personality and aspiration. We all know that family sims love children while romance sims could do without them most of the time. Also, pleasure and popularity sims would want less children than knowledge and fortune sims, but to to a smaller degree of difference.
Since I assign aspirations based on personality, I had to look to see if any aspirations were based on high outgoing or nice score. Since popularity is mostly outgoing, I assigned it a higher Aspiration ACR rank, also since knowledge had to be shy (low outgoing), I gave it a smaller Aspiration ACR rank so that my knowledge sims would at least desire some children. As a result, I coded each Aspiration ACR rank as follows:
family= 1
knowledge= 2
fortune= 3
popularity= 4
pleasure= 5
romance= 6
Looking at personality, I decided that the more outgoing a sim was, then the more likely they would like to have more sims in their family. Also since niceness was a requirement for the family aspiration in my hood, I decided that the nicer a sim, the more children they would like to have. As a result I developed a personality dependent score as follows:
Outgoing + ( 0.5 * Nice )
And the final ideal family size formula as follows:
Outgoing + ( 0.5 * Nice ) / Aspiration ACR Rank = Ideal Family Size
This formula fits into my spreadsheet quite nicely without having to collect any additional information such as interests or making the formula complex by considering family background (would those sims from large families prefer large families as well since they enjoyed the experience, or would they prefer smaller families in an attempt to give each child more attention)
Based on primary aspirations only, the formula gave pretty ideal results of what I envision each sim as desiring for their ideal family size. There were a few surprises, such as Jesse (Carr) Kent wanting 14 children since he's a very nice, outgoing family sim. Which leads into the next topic, that just because they have that ideal family size doesn't mean that they will have that many children. Thanks to ACR try for baby based on aspiration and my own birth control rules, then some sims won't have their ideal family size-sorry Jesse. I also noticed that as of now, the average ideal family size for my hood is 3.6 which fits into what the size of most families. I have also included a chart of how the fertile sims (teen and older) in my hood view their ideal family size.
Of course, the actual size of the family is also regulated by finances (can the couple "afford" another child?) , age (older sims have lower fertility rates with ACR), unplanned pregnancies, medical issues (the "barren" trait), spousal preference (for those sims who want 2 children vs 7 children) and of course their wants (if they both roll wants for a child, then I remove birth control, if the partner with the lower child tolerance rolls a want for a baby, then I also remove birth control) .