excel Domain manager including most of Anuire regents

[Nakraal]

One thing led to another and I ended up creating and excel file for managing Anuirean regents.

http://s000.tinyupload.com/?file_id=93745642422376073215

(updated 8th May)

Its big as it holds a separate sheet almost all regents from Dhoesone to Mieres and from Boeruine to Elinie.

Each sheet is interconnected with all other so to calculate rp & gb incomes from provinces and holdings. Also you can set each regent's attitude towards all other and affect the loyalty of their provinces should owned law holdings are present there. Seizures can be imposed with the same manner.

edit: Best you "freeze" calculations in the file and force them manually when you 'pass season' (formulas tab - change to manual calculations). I plan to make this with buttons when i finish debugging it.

Im still debugging it, any corrections and feedback appreciated.

[arpig2]

That is awesome work!!

[Invoker47]

I have been looking for something like this for years. Though bits of it I don't understand, but once you polish it and refine it, I would love to be given the up and up on how to use it.

[arpig2]

I find it interesting that you have gone regent by regent. I have always done mine province by province.

[Nakraal]

I find it interesting that you have gone regent by regent. I have always done mine province by province.

I find it much easier to navigate it with a regent by regent build up. Esp while in a session.

[Nakraal]

I have been looking for something like this for years. Though bits of it I don't understand, but once you polish it and refine it, I would love to be given the up and up on how to use it.

Last update, which is what u probably downloaded, is almost final code-wise. I just need to enter data for some regents that i havent already (like units, starting trade routes etc).

I have placed pop up msgs on some tables that are a bit tricky. I will try to make a sheet containing some short of tutorial tomorrow. Feel free to ask away for anything

[Invoker47]

Last update, which is what u probably downloaded, is almost final code-wise. I just need to enter data for some regents that i havent already (like units, starting trade routes etc).

I have placed pop up msgs on some tables that are a bit tricky. I will try to make a sheet containing some short of tutorial tomorrow. Feel free to ask away for anything

Given I only glanced at it for 3 minutes, but it is using 2nd edition rules right? The law and intrigue proficiencies and variable income seems to make me think that.

I assume tallage is taxation from the province, and law only makes money with seizures?

And yeah, just a quick this is how you use it would be great. Would let me tweak it, since it needs a section for building maintenance for what I use.

[Nakraal]

Given I only glanced at it for 3 minutes, but it is using 2nd edition rules right? The law and intrigue proficiencies and variable income seems to make me think that.

I assume tallage is taxation from the province, and law only makes money with seizures?

And yeah, just a quick this is how you use it would be great. Would let me tweak it, since it needs a section for building maintenance for what I use.


Yes its second edition. You can ignore all proficiencies except Administration (the only one which is coded). While the rest of them are just a reminder for the DM just in case he may need a quick reference of a regent's skill, administration is used to lower maintenance.

Yes tallage is taxation, law is used to affect loyalty in invested provinces and for seizures.

All rolls are 2nd edition based

Scrolling to the right u will first see tables with holdings of every type of other present
regents. Each holding type has a different table. The IDs of the regents (eg HD=Heirl Diem) are noted with pop ups on each table.

Further right is an area I have marked as "Automated section", where are all the rolling tables.

[arpig2]

I find it much easier to navigate it with a regent by regent build up. Esp while in a session.
I can see how it would be.

[Nakraal]

Uploaded an almost final version - all data has been entered with assumed trade routes, lieutenants (from campaign setting),units (from campaign setting for land armies, Seas of Cerilia for ships and assumed when not available). Scores for BR proficiencies are based on ability scores found in the wiki. When a regent most possibly has not taken the proficiency the score is his relative ability halved. Regents renowned for a certain proficiency score have increased level (eg Guilder Kalien's intrigue and Gavin Tael's Strategy)

There was a bug where same level holdings in the same realm always rolled the same number so code for collection rolls is corrected.

The file is uploaded with manual calculations on in order to not automatically reroll collections. Whenever a DM wants to have collections rolled press F9.

A small tutorial sheet is in the end of the sheet rows, where some aspects are explained and mostly displays which fields have code in them and which are for entering data.

[Invoker47]

Very nice, I may start using this sheet instead of the ones I use now for ease of use for certain things. Would require switching to random collections, but I'll see how that goes. Only thing I'd really need to add I think is a section for constructions and maintenance for those.

I've tried making sheets on my own, but I'm not very good with Excel or this sort of thing. Thanks for sharing, I think collaborations on these sorts of things are great, I just wish there was more activity here still for our BR campaigns we all are running.

[akalars]

Very nice work with this sheet.

Is there any way to track expenses for bridges, roads, ferry and so on?

It would be very nice to have a few blank sheets for use to track player characters that are not replacing one of the existing regents.

[Arius Vistoon]

seems very nice and big work.
thanks for that

[DarkApple]

Very sorry for necroing this thread. Would anyone still have the document available somewhere?

Having a long internal debate about starting a PBEM and looking around for pre-made groundwork :p

[AndrewTall]

I don't have that spreadsheet, but I have one based on Greenknight's Ruins of Empire ruleset if that would be of any use? PM me your email if you want me to send it over.

[DarkApple]

I don't have that spreadsheet, but I have one based on Greenknight's Ruins of Empire ruleset if that would be of any use? PM me your email if you want me to send it over.

Thanks Andrew - always happy to have some materials, however ROE's ruleset always overwhelmed me!

Still bleating for the original spreadsheet whilst PMing you :)

[AndrewTall]

Thanks Andrew - always happy to have some materials, however ROE's ruleset always overwhelmed me!

Still bleating for the original spreadsheet whilst PMing you :)

If you subsume all the vassals into the main ruler, ignore manor holdings, set all to average loyalty etc you should be fine, maybe a few formulae to tweak :rolleyes:

best of luck

[DarkApple]

If you subsume all the vassals into the main ruler, ignore manor holdings, set all to average loyalty etc you should be fine, maybe a few formulae to tweak :rolleyes:

best of luck

One can try, thank you again :D

[Midnight]

The link for download is dead. Is the excel sheet uploaded to the downloads? Can someone share?