Thanks: 896 in 3 Posts
I need a cigarette
I took a look at the file you uploaded in the very start. I was able to take a look at what you did and even got something to work with OpenOffice - except for one of the forms that has a subform in it. (Guess I need to learn that one. )
Anyway before I start to ramble, I was wondering if you would be willing to share you more updated file. (The screenshots are looking really juicy - from an overall point of view.) I would love to be able to test it out and maybe even work it into OpenOffice. (I can't promise anything, @kestrellyn, but I might be able to do it if I have something guiding me.)
@FranH - I was heavily beta testing with Reba with SimTracker 2. We had a lot going with it, but there were a lot of bugs. I never had the source code and I am not where even as good at programming as she was, so I don't even think I could get anything working even if I tried. (I don't even have the program because my gaming computer literally exploded, and I lost everything Sims related. I only now got a new computer, so I am trying to scrap as much I can to get back to where I was with Sims. Some things are just lost. )
Thanks: 6004 in 35 Posts
But as far as my recently rediscovered love for that old landmark MicroProse RPG, Darklands? Oh, yes...I keep handwritten spreadsheets up one side and down the other, just so I can keep track of all my party's quests in Darklands!
(Would you believe that this is the fifth sheet of paper that I've gone through with my new Darklands party? You can easily rack up dozens of quests in that game, and as wonderful a game as Darklands is, MicroProse didn't provide any in-game menu for keeping track of quests! What else could I do? )
That does count as a spreadsheet, right? :-/
Thanks: 343 in 13 Posts
Sorry I took so long to get back, but here's an empty version of my current database I sent to someone a while ago: https://simfil.es/1821337/
- Most of the stuff you'll be able to enter via form. But use the Neighbourhoods table to enter your main hood/subhood details instead.
- There's a few hidden objects, mostly subforms and queries used for sorting. They're unhidden if you want to poke about. If you want to re-hide them right-click somewhere on the left sidebar and use the checkbox in Navigation options.
- I forgot to change the header of the main form before uploading it. Just use design mode to change "Sims of Oakbrook" to whatever you prefer.
- There's some odd flickering when moving around the form because of the coding tricks I used for it. Wasn't really able to do much about it. Also the "Family" tab in the Sim section is empty because I didn't get around to finishing it.
- Double-click the big empty squares in the form to attach pictures. If you use Chris Hatch's version of SimPE, there's a neighbourhood export there to grab all the sim/family portraits.
- A few of the form details are specific to my own setup (e.g. bank accounts and college funds, take-home salary for the Sim Salary bonus scheme mod, etc).
You can make any changes you want, as it is open source. It's Bulbasaur's Excel template that I made lots of additions to. Some pages are huge and many of the ones where you enter records have freeze panes so you can navigate without losing your bearing. Everything's optional, and it's still a work-in-progress. Suggestions and critiques are welcome, and if anyone wants to turn it into an application, that would be cool.
For the Zodiacs, I've listed the attracted to and repelled by for easy reference. Might look a bit herky-jerky. I've made a few formulas and the like - especially for the pages where you unlock objects. The Hood Stats page is for recording numbers of various items, sims in certain high positions, etc. The Locked Items Settings page is where you can adjust the numbers required for unlocking items. I'm planning on making a few adjustments, like possibly making certain numbers equal the Locked Items settings numbers and make changing the settings more convenient.
Thanks: 47 in 4 Posts
The base is from Pleasantsims, the blank one she has on her website, modified to get rid of things I don't care to track.
And then I'll write little notes to remember down at the bottom or at the top. And it's on another page atm but I've got a sticky note reminding me what day/time to stop the family I'm on.
Since there's about 50 houses in my rotation now I keep in a checklist on my phone, so I can just check and uncheck at the end of each house so I don't forget the order. Am almost done with round 7.
Originally Posted by vampiresam9097
How do you guys plan out your spreadsheets? I recently grew my hood to the point where I absolutely need one in order to keep track of everything.
Snipped for focus.
I just keep a written journal for everything.
Doing the record keeping the hard way.
" Inama Nushif "
In this version, I squashed some bugs, made a few adjustments, and added dynamic labels to the "Locked Items" sheets. Except for the white fields, just enter any activity or changes to your hood in the "Hood Stats" sheet, while you can change the requirements and labels by changing the white fields in the "Locked Item Settings" sheet. Let me know if there are any other bugs or suggestions. Remember, this is an open-source project so you are welcome to change it to suit your playstyle. My style of aspiration-rolling and other restrictions may be *very* different from yours, so customize it as you please. Critiques and feedback are encouraged!
Thanks: 84 in 2 Posts
This was the last version of the Neanderthal spreadsheet before we moved onto roman
This is a list of all the sims in the neighbourhood, their parents, genetics, personality, aspiration, sexuality, birthday, death day and cause of death
And this is used for matchmaking purposes. A lot of colour coding going on
Thanks: 6004 in 35 Posts
Anyway, here is a read-only view of my sims setup now:
https://www.notion.so/bd54de1960c24...3ed4c2fd5195a2b (There are seven different views of this table, if you click on "Basics", and if you click "Open" next to the sim name, or on any of the sim links, it opens a page with that sim's information in it)
The links between sims, families, and households all keep themselves up to date on both tables - if I add a last name or a household to a sim, they appear in the list of members of the family or household on the other tabs. There are some hidden properties that don't appear in any of the views that make some of the calculations work.