- Site Map >
- Community >
- Sims Discussion >
- Sims 2 >
- General - Share Your Spreadsheets!
- Site Map >
- Community >
- Sims Discussion >
- Sims 2 >
- General - Share Your Spreadsheets!
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 6,200
Thanks: 116 in 1 Posts
Until recently I was trying to earn a living as an Access database programmer/developer. But in last few years the work has really dried up, and my aging mother's deteriorating health has effectively made me her full time carer. I'm rather busy preparing for RL Christmas just now (and despite Simonut and Mr. Scrooge) I'll try to make sure my Sims (at least some of them) get a little bit of fun at Christmas too . But I'll try to make time in the New Year to get a proper look at your database, and see if I can suggest any improvements. Access 2010 is the version I use, so I should be able to open it ok. Don't expect too much of me though. My Access skills have got a bit rusty over the past few years, and your database looks very professional in your screenshots.
Although it was my job, I haven't made much use of Access for my Sims. The only database I use for them is a random name generator that I use when I can't think of a name for a new CAS Sim. Born-in-game Sims are about as rare as hens' teeth in my game, and I don't use the name generator for them -- I try think of a name for them in consultation with the parents. (i.e. I open the lot and look at the parents -- I may even talk to them -- and rack my brain trying to think what name they would give the child. The name generator database predates me starting to play the Sims. I originally wrote it to populate demo databases with dummy but realistic-looking data. It originally generated dummy street addresses and email addresses as well as people's names.
I've made little use of spreadsheets either. I think I only have one that I use for my Sims. A couple of my Sims run an OFB nightclub. The game was debiting them for the cost of wages and other expenses when other Sims visited the club. But it wasn't crediting them with the income from the "bandatron" machine and other payments for "adult" services. The nightclub was haemorrhaging money every time other Sims visited it. So I created an Excel spreadsheet to calculate roughly how much income they should receive for the visit, based on the entry price, the average number of visitors in the club, and what payments were made for these "adult" services. Whatever the spreadsheet calculates I then pay to the owners using FamilyFunds. I must say that having to do bookkeeping, or at least auditing, for every owned business, does rather put me off using OFB more.
Other than that I really just keep a note of what my Sims are up to by using the game's Storytelling feature, aided by some Microsoft Word tables, which are really a form of street directories.
Posts: 9,929
Thanks: 416 in 15 Posts
That name generator is pretty cool though. I often use Nameberry's Name Hunter because it generates ones with a similar feel.
I think that OFB not crediting business owners when playing a different household is a common glitch in the game. I've seen other threads about it.
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 1,180
Thanks: 95 in 2 Posts
The Mayflies Legacy- a Random Legacy Story
Posts: 3,765
Thanks: 9621 in 44 Posts
I'm almost postive Access does charts 'n graphs. However it's been YEARS since I've done anything with it and just lookin back at it with Bulbizarre's 2010 Access is makin my head spin... lol |
Well, if someone knows how to do them in OpenOffice's (or LibreOffice's) database, I'd be interested to know, but I've looked through the help and have not seen anything like that.
Posts: 6,200
Thanks: 116 in 1 Posts
@AndrewGloria - your neighbourhood is likely far smaller than mine, so definitely less of a need there. |
Veronaville
3 sub-hoods
- Downtown
- Bluewater
- Monopolis (Monopoly Game Town)
41 Families (excluding townies, Downtownies, NPCs and "Default")
420 Sims
- 115 Playables
- 99 Townies
- 93 NPCs
Most of the rest are the dead ancestors of the Maxis Sims from Veronaville, Downtown and Bluewater. No Sims have died on my watch. As a result of my aging-off playstyle, the population is remarkably stable. There have only been two babies born in Veronaville in the seven years I've been playing it. There's been one wedding, four birthdays, and no deaths at all. The population growth is almost entirely due to new families moving into the area (i.e. new Sims created in CAS). So I suppose I really don't need a database to keep track of my Sims in Veronaville: quite a bit of my knowledge of them is really just kept on my head.
That name generator is pretty cool though. I often use Nameberry's Name Hunter because it generates ones with a similar feel. |
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 715
Thanks: 472 in 14 Posts
I'm a database manager IRL and I honestly didn't want something as complicated as my job entails.
Posts: 6,237
Receptacle Refugee & Resident Polar Bear
"Get out of my way, young'un, I'm a ninja!"
Grave Matters: The funeral podium is available here: https://www.mediafire.com/file/e6tj...albits.zip/file
My other downloads are here: https://app.mediafire.com/myfiles
Posts: 3,765
Thanks: 9621 in 44 Posts
Alas, the program had some problems and it was too ambitious a project. If I had to go back to it, though, I'd strip it down to just the family browser, because that was a hoot.
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 3,765
Thanks: 9621 in 44 Posts
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 6,200
Thanks: 116 in 1 Posts
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 3,765
Thanks: 9621 in 44 Posts
Posts: 9,929
Thanks: 416 in 15 Posts
I added a dropdown to the top of the households subform to jump to specific households. (Unfortunately, I haven't figured out how to make it just show the households for the specified subhood just yet. I'm working on it.)
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 9,929
Thanks: 416 in 15 Posts
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 370
You know what I'd like? Someone to redo the "Sim Tracker" that Reba Lynn released. Since her death, it's been available but does not work properly and was never updated. |
Same! I still use it, but it's extremely slow on my laptop and the university/education tab can't be updated because it keeps copying over other sims' information.
Posts: 221
Thanks: 120 in 3 Posts
Posts: 9,929
Thanks: 416 in 15 Posts
Note that I use Sims Salary Bonus Scheme, thus take-home pay
Planning to add fields for genetic skintone + hair colour + eye colour, as well as yes/no for glasses and beards
This was working but I managed to break the query by mistake while trying to do something and haven't gotten around to fixing it.
I'm secretly a Bulbasaur. | Formerly known as ihatemandatoryregister
Looking for SimWardrobe's mods? | Or Dizzy's? | Faiuwle/rufio's too! | smorbie1's Chris Hatch archives
Posts: 221
Thanks: 120 in 3 Posts
I'm still cobbling it together. |
It looks awesome! I'm amazed by the detail, you've obviously put a lot of time into it.
Who Posted
|