Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Junior Member
    Join Date
    Dec 2011
    Posts
    17
    Downloads
    153
    Uploads
    0

    excel Domain manager including most of Anuire regents

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

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

    (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.
    Last edited by Nakraal; 05-08-2015 at 06:53 PM. Reason: updated file & link

  2. #2
    Senior Member arpig2's Avatar
    Join Date
    Feb 2006
    Location
    Ottawa, Ontario
    Posts
    218
    Downloads
    74
    Uploads
    6
    That is awesome work!!
    Call me Bob.
    My Zaidan-Tai site: http://bobsworlds.x10.mx/Zaidan/
    My Zaidan-Tai PBEM: http://nrggames.proboards.com/
    My Tollanar blog: https://bobsworlds.wordpress.com/

  3. #3
    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.

  4. #4
    Senior Member arpig2's Avatar
    Join Date
    Feb 2006
    Location
    Ottawa, Ontario
    Posts
    218
    Downloads
    74
    Uploads
    6
    I find it interesting that you have gone regent by regent. I have always done mine province by province.
    Call me Bob.
    My Zaidan-Tai site: http://bobsworlds.x10.mx/Zaidan/
    My Zaidan-Tai PBEM: http://nrggames.proboards.com/
    My Tollanar blog: https://bobsworlds.wordpress.com/

  5. #5
    Junior Member
    Join Date
    Dec 2011
    Posts
    17
    Downloads
    153
    Uploads
    0
    Quote Originally Posted by arpig2 View Post
    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.

  6. #6
    Junior Member
    Join Date
    Dec 2011
    Posts
    17
    Downloads
    153
    Uploads
    0
    Quote Originally Posted by Invoker47 View Post
    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

  7. #7
    Quote Originally Posted by Nakraal View Post
    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.

  8. #8
    Junior Member
    Join Date
    Dec 2011
    Posts
    17
    Downloads
    153
    Uploads
    0
    Quote Originally Posted by Invoker47 View Post
    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.

  9. #9
    Senior Member arpig2's Avatar
    Join Date
    Feb 2006
    Location
    Ottawa, Ontario
    Posts
    218
    Downloads
    74
    Uploads
    6
    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.
    Call me Bob.
    My Zaidan-Tai site: http://bobsworlds.x10.mx/Zaidan/
    My Zaidan-Tai PBEM: http://nrggames.proboards.com/
    My Tollanar blog: https://bobsworlds.wordpress.com/

  10. #10
    Junior Member
    Join Date
    Dec 2011
    Posts
    17
    Downloads
    153
    Uploads
    0
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Domain:Upper Anuire Traders
    By BRadmin in forum Category
    Replies: 0
    Last Post: 01-11-2009, 05:04 AM
  2. Improving domain interaction outside Anuire
    By Green Knight in forum The Royal Library
    Replies: 11
    Last Post: 11-07-2008, 11:40 PM
  3. Anuire CC2 Map and Excel sheet
    By greegan in forum The Royal Library
    Replies: 0
    Last Post: 05-08-2003, 04:19 AM
  4. Domain Turns: Regents and Lieu
    By Ryan B. Caveney in forum MPGN Mailinglist archive 1996-1999
    Replies: 12
    Last Post: 05-25-1998, 12:29 PM
  5. Domain Turns: Regents and Lieutena
    By KirbyRanma in forum MPGN Mailinglist archive 1996-1999
    Replies: 0
    Last Post: 05-21-1998, 04:41 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
BIRTHRIGHT, DUNGEONS & DRAGONS, D&D, the BIRTHRIGHT logo, and the D&D logo are trademarks owned by Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and are used by permission. ©2002-2010 Wizards of the Coast, Inc.