ploesch
09-14-2006, 07:23 AM
OK, so I am considering making a DataBase to track Birthright Domains Provinces and Regents.
Really, I think the hard part will be finding a DB to use that can be freely distributed and installed easily on any computer.
before i start my search, I wanted to find out if anyone else has done something similar.
Now, why this came about....
I created a domain worksheet on a spreadsheet that figures out RP and GB maximum colection, I uploaded it here, but I don't think it's turned up in the downloads yet.
Anyway, we were using it, and the usual requests came in, most of which I expected. But then there were questions about who else is in what province, blah blah blah, and I was looking stuff up. The big one was from the leader of Elinie "Do I have holding in any other provinces?" I had to look through all the surrounding provinces to see if he did cause it doesn't say dirrectly in the book, and I realized it is this way for nearly all the realms in the atlas. In the end I realized I forgot how much paperwork BRCS is, and these guys were gona tax my accounting skills. So, I thought about creating a database to make my life easier.
I'm thinking about a relational DB, I'm thinking of having DB's for:
Realms: [name*][owner(list from Ruler DB)]
Province: [name*][realm(list from Realm DB)][rule level][source level]
Rulers: [initials*][Name][blood score][max RP][extra hp][gb treasury][rp treasury][max rp treasury][RP collection % - Province][RP collection % - Law][RP collection % - Guild][RP collection % - Temple][RP collection % - Source] - some of this can just be calculated, but will be there for reference.
Holdings: [type(list)][level][owner(list from Ruler DB)][province(list from Province DB)] - I don't know off hand how I will make sure that levels cannot exceed privince level, but should be easy once I get started.
-----
Then informational DB-this stuff can not be changed.
Assets: [type*][muster cost][seasonal maintenance-in 24ths] I may create a new measure that is 1/24th a GB. [requirement] - No idea how to implement this yet, but I want to make sure there is a seaport on each side of a sea trade route, roads for land ones(may be impossible), and the proper rule level for mustering troops.
The hard part will be the forms for entering/changing data and printed sheets.
* field that will be unique Key
Need to look up a certain leaders holdings, look them up and print it on a holdings sheet.
Need to know all the holdings, levels and who for a certain kindom (2E style), look the country up and print the sheet.
Want to know all the assets and owners in a particular province, look them up.
If anyone has anything similar they are using, let me know, if not I hope to have something for you to try in the next couple months.
Really, I think the hard part will be finding a DB to use that can be freely distributed and installed easily on any computer.
before i start my search, I wanted to find out if anyone else has done something similar.
Now, why this came about....
I created a domain worksheet on a spreadsheet that figures out RP and GB maximum colection, I uploaded it here, but I don't think it's turned up in the downloads yet.
Anyway, we were using it, and the usual requests came in, most of which I expected. But then there were questions about who else is in what province, blah blah blah, and I was looking stuff up. The big one was from the leader of Elinie "Do I have holding in any other provinces?" I had to look through all the surrounding provinces to see if he did cause it doesn't say dirrectly in the book, and I realized it is this way for nearly all the realms in the atlas. In the end I realized I forgot how much paperwork BRCS is, and these guys were gona tax my accounting skills. So, I thought about creating a database to make my life easier.
I'm thinking about a relational DB, I'm thinking of having DB's for:
Realms: [name*][owner(list from Ruler DB)]
Province: [name*][realm(list from Realm DB)][rule level][source level]
Rulers: [initials*][Name][blood score][max RP][extra hp][gb treasury][rp treasury][max rp treasury][RP collection % - Province][RP collection % - Law][RP collection % - Guild][RP collection % - Temple][RP collection % - Source] - some of this can just be calculated, but will be there for reference.
Holdings: [type(list)][level][owner(list from Ruler DB)][province(list from Province DB)] - I don't know off hand how I will make sure that levels cannot exceed privince level, but should be easy once I get started.
-----
Then informational DB-this stuff can not be changed.
Assets: [type*][muster cost][seasonal maintenance-in 24ths] I may create a new measure that is 1/24th a GB. [requirement] - No idea how to implement this yet, but I want to make sure there is a seaport on each side of a sea trade route, roads for land ones(may be impossible), and the proper rule level for mustering troops.
The hard part will be the forms for entering/changing data and printed sheets.
* field that will be unique Key
Need to look up a certain leaders holdings, look them up and print it on a holdings sheet.
Need to know all the holdings, levels and who for a certain kindom (2E style), look the country up and print the sheet.
Want to know all the assets and owners in a particular province, look them up.
If anyone has anything similar they are using, let me know, if not I hope to have something for you to try in the next couple months.