Book of the River Nations Excel Spreadsheet?

[Jestem]

I have the .xls version of the sheet, but have noticed a pretty big issue.

Unrest is impossible to change, remaining constantly at 1 point, therefore I have to manually track it. I am however using the old version of the spreadsheet that does not as of yet track the magic items as I was unsure as to whether there had been an updated sheet made available

[Papa-DRB]

And he sent me a new one, with all his data removed.

-- david
Papa.DRB

Papa-DRB wrote:

The latest copy of NeoFax's Excel Kingdom Sheet with BotRN material will always be HERE. The link above is no longer valid.

-- david
Papa.DRB

ps. He just sent me an updated copy and I am running out of free storage, so I will be renaming any new one to the name in this link.

[Jestem]

Right, have downloaded this new version of the sheet, however, when this occurs, it comes out as being impossible to open within Excel because apparently the sheet is corrupt. Changing the file extension to .xls means that it can be opened, but then the formula are not there, and thus no changes actually auto update.

[PJ]

Jestem wrote:

Right, have downloaded this new version of the sheet, however, when this occurs, it comes out as being impossible to open within Excel because apparently the sheet is corrupt. Changing the file extension to .xls means that it can be opened, but then the formula are not there, and thus no changes actually auto update.

What happened?

[Jestem]

I attempt to load the sheet, it comes up as saying that excel cannot load the sheet as the sheet is corrupt. So I click ok and a blank workbook loads instead

[CalebTGordan]

I converted the file to .xls with a file converter and things come out fine on my end.

[Shieldknight]

I'm having issues finding information on the added buildings in the spreadsheet. They aren't in the latest version of the Book of the River Kingdoms. Are they in a messageboard?

[Dale McCoy Jr]

Some are from Wayfinder. I'm not sure if others are from elsewhere.

[Shieldknight]

Thanks Dale.

[NeoFax]

Jestem wrote:

I attempt to load the sheet, it comes up as saying that excel cannot load the sheet as the sheet is corrupt. So I click ok and a blank workbook loads instead

Try this version here. It works on my system using Excel 2007. I am working on a version that works in LibreOffice 3.4.

[Jestem]

Provisional only, as I haven't fully uploaded all the stats again, but it looks amazing. THANK YOU!!

Will most likely post in an hour or two once I have the spreadsheet totally uploaded

[Jestem]

Just finished the import I was speaking about in the previous post, and am absolutely loving the new spreadsheet. It makes everything so so much easier to find, and all the formula that I can see are working perfectly.

Only one question left Neofax.

How do I add more cities? I don't need to just yet, but 8 of the 10 city slots have already been used, so unless I start looking as a separate sheet for each half of the kingdom or something, I am gonna need more cities.

Thanks in advance.

Jestem

[NeoFax]

Jestem wrote:

How do I add more cities?

Right click one of the City sheets that is blank and select "Move or Copy". Then in the popup window select copy and select the sheet "Army 1". This way the City sheet will show up as the last city sheet. Then rename to City 11, 12,... This should work as I designed it this way(or at least I think I did). Let me know if it doesn't work so I can fix it.

[Talon Moonwalker]

The method works correctly, but then if you input values onto the new city, there is no update to the original sheet, the economy, loyalty and stability values don't tie up.

[NeoFax]

Talon Moonwalker wrote:

The method works correctly, but then if you input values onto the new city, there is no update to the original sheet, the economy, loyalty and stability values don't tie up.

OK, Thanks! I know exactly what is happening. I just need to expand the list on the hidden sheet to include like 50 cities. This way it will work.

[Blodox]

I don't know if it's user error or what. But, my leadership scores in the main equation all have a bad formula (#VALUE). Is anyone else having this problem?

[Talon Moonwalker]

I had it. You basically need to have all of the dropdown boxes that the spreadsheet refers to filled. Even if its a blank slot, just make an npc who has the requisite vacancy penalty for the kingdom and then it will recalculate things properly

[Inner Heru]

First thanks for ALL of this to all who have worked on it.

Now I feel a little silly because I know it's looking me in the face but. I can not seem to find where I would add things like having a Land or Water Boarder. I went through the thread a few times but no clue still.

Thanks for any help with this.

[Inner Heru]

Inner Heru wrote:

First thanks for ALL of this to all who have worked on it.

Now I feel a little silly because I know it's looking me in the face but. I can not seem to find where I would add things like having a Land or Water Boarder. I went through the thread a few times but no clue still.

Thanks for any help with this.

Hmm.. been too long since I looked at the rules it seems. Nevermind but thanks none the less.

[tribeof1]

Has anyone tried using the sheets referenced in this thread on a tablet? What app did you use and how did it work? I'm looking at buying an Android tablet for use in my Kingmaker game but want to make sure I'll be able to run either the Excel or OpenOffice spreadsheet.

[Christopher Woldridge]

Not sure what I am doing wrong here. Updating from 2.0 to 2.2 and making my tweeks to the sheet. I add my custom open spaces and buildings fine. When I go to change the tab name to the city it updates the name formula in the city summary tab but all of the calculations on the overall page error out? Version 2.0 did not have this issue. It works fine if I keep the tab names "City x". Is anyone else having this issue?

Edit:

Did some checking on the City Overview sheet (hidden). The name formula has changed from version 2.0. The whole sheet is more complex. This is where the issue is. When you change the tab name from "City x" that city line in the Overview tab gets the #REF! error.

Seems a bit big to muck with. Anyone know how to change it so you can change the tab names without killing the sheet?

[Christopher Woldridge]

Also both the Warden and Marshal are using STR and CON. The Warden should be DEX and WIS.

[Bobson]

Just found this sheet as I went looking for one that included even more open space developments than the one I had (which was called 3.2 and forked from this after 2.0)... Is the 2.2 version the most up-to-date version of this sheet?

[Tryn]

tribeof1 wrote:

Has anyone tried using the sheets referenced in this thread on a tablet? What app did you use and how did it work? I'm looking at buying an Android tablet for use in my Kingmaker game but want to make sure I'll be able to run either the Excel or OpenOffice spreadsheet.

I use my own one ( Link, based on a lot of the ones posted here^^ ) on my Andriod Tablet. I use the "Document to Go" App for it.

Works fine, except more complicated Excel functions (IF, Random, Runddown etc.) will not work.
But you can easily modify the sheet on the tablet whith this App.

[Vikingchris]

THIS EXCEL SHEET IS AWESOME!!! THANK YOU!

[Philip Knowsley]

Hiya all! :)

Have had to re-download & fill out due to system problems.

This 'Kingdom Sheet with BotRN' is the best I've found previously, so mega-thanks to the creator.

Unfortunately, my players went with a Neutral Good kingdom, so the sheet
starts to go haywire almost immediately.

Reason - this version 3 sheet, the 1st dropdown lists the Alignments as:-
Lawful
True
Chaotic

All good - except that when I go to select Neutral, the only option
appears as 'True', and the 'True' part of that doesn't give a +2
modifier to Stability as it should.

Apart from manually enterring (I'll forget that I've done this after
a while) how can i fix this please? Anybody have any ideas?

Thanks a million.
Philip

[Philip Knowsley]

Philip Knowsley wrote:

Reason - this version 3 sheet, the 1st dropdown lists the Alignments as:-
Lawful
True
Chaotic

All good - except that when I go to select Neutral, the only option
appears as 'True', and the 'True' part of that doesn't give a +2
modifier to Stability as it should.

BUMP - anybody - please help...

I have no Excel skills at all - so am completely stumped.

Neofax - you out there still?

[Papa-DRB]

Philip Knowsley wrote:

BUMP - anybody - please help...
I have no Excel skills at all - so am completely stumped.

Neofax - you out there still?

Link to the .ods version HERE

Link to the .xls version: HERE

Both have the correct alignment drop downs.

-- david
papa.drb

[Philip Knowsley]

Papa-DRB wrote:

Philip Knowsley wrote:

BUMP - anybody - please help...
I have no Excel skills at all - so am completely stumped.

Neofax - you out there still?

Link to the .ods version HERE

Link to the .xls version: HERE

Both have the correct alignment drop downs.

-- david
papa.drb

Thanks heaps for those links - I do appreciate it!

I'm running that sheet already though, & was hoping to update to v.3...
:)
Nevermind - but thanks again.

[Bobson]

Philip Knowsley wrote:

I'm running that sheet already though, & was hoping to update to v.3...
:)

There's both a version 2.2 and a version 3.2 floating around, which are both branches from version 2.0 that went in different directions. I started with the latter, but I'm currently using the former, which I like better and has more functionality.

[Carbon D. Metric]

Raise!

RAISE!

RAISE!

Ok, necro over with. I am using this very AWESOME spreadsheet for kingdom management and have been for some time.

The time has come to start keeping track of our armies and I am looking at tracking it with the spreadsheet and not really by hand... if possible.

My question is, Is there a version of this somewhere not linked here that has a functional way of keeping track of the armies. Currently my copy seems to have some placeholder tabs for Kingdom Armies but nothing functional. Am I missing something?

[savior70]

anyway I can get this emailed to me?

Spoiler:

savior70@hotmail(dot)com

[Caraldur]

I would like a copy as well.

Spoiler:

caraldur at gmail.com

[BrutaleBent]

I would like having both 2.2 and 3.2 sent to me too - Or whatever is newest in both 'branches'. :)

Spoiler:

BrutaleBent(at)MSN(dot)com

[Jabberwonky]

I would like both 2.2 and 3.2, in both .ods and .xls versions if available. My group is looking at the best way to track this presently, and are getting tired of paper tracking.

spoiler:

jabberwonky23 (at) gmail (dot) com

[Jarazix]

If anyone would be willing to email me the newest version I would be thankfull

Email:

[e-mail]

[Rickmeister]

Will anyone adapt the excel sheets when Ultimate Campaign comes out?
If so, be sure to let me know :)

[T.A.U.]

I'm looking for a BotRN rules .ods file version (I use Open Office) but the dropbox link above is empty, if anyone could email me, the gods of mine campaign will bless him ;-)

email:

[e-mail]

[Skaeren]

Would it be possible for someone to upload an excel sheet or google doc that uses the building time and updated edicts, plus population and army stuff from Ultimate Rulership? It is a third party book that adds a little more complexity to the system.

[T.A.U.]

DragonLord2190 wrote:

Would it be possible for someone to upload an excel sheet or google doc that uses the building time and updated edicts, plus population and army stuff from Ultimate Rulership? It is a third party book that adds a little more complexity to the system.

There is the wonderful Chemlak's Ultimate Campaign version here, acording to his posts he will made an update the Ultimate Rulership (and Ultimate Battle?), but no ETA when it will be done.