Looking for help testing my Kingdom Spreadsheet


Kingmaker


2 people marked this as a favorite.

I really wanted an online sheet to help my group manage our kingdom, and I looked pretty closely at the various automated kingdom tracking sheets that I came across. Despite being extremely impressive, the fact that they weren't Google Sheets was a sticking point. That's my long-time PbP group's share method of choice.

Thinking about it, I think the reason that the automated sheets are too big for Google Sheets is because they're, well, automated. If you built a sheet that focused mostly on the calculations and less on features such as automatic city creation and really specific event results (leaving those scenarios to be handled manually), you might be able to keep the file size under the limit. So that's exactly what I did.

I can't say that I directly copied any of kingdom building sheets that I came across, but I was heavily influenced by some of them, and a while back I came up with a tool for my campaign that I'm pretty proud of. I also created a template to share with the community, but the only problem is that I ran out of steam before I could ask people to test it. I think it's good, but asking the community at large to try it out would be best.

So, if anyone feels like trying out Andostre's Kingdom Tracking Template (instructions for set up are on the first tab) by filling it out and plugging in their kingdom's nubers, I would really appreciate any feedback they might have.


Bumping my request for help. This is the last time I'll bump this.


Can't really help test the sheet, but if you're looking for feedback:

The layout and pop-up tool tips are great
I would suggest making the formula fields a different colour. This just helps prevent accidental spreadsheet explosions.


Grifta wrote:
Can't really help test the sheet, but if you're looking for feedback:

I'll take it.

Quote:
The layout and pop-up tool tips are great

Thanks!

Quote:
I would suggest making the formula fields a different colour. This just helps prevent accidental spreadsheet explosions.

Well, in the Instructions tab, I give directions for protecting cells from editing for just that reason. Color-coding the formula tabs will help with that, though.

Thanks for the feedback.


Content wise I like it. My biggest beef with it is more aesthetic than anything really. Nothing saying you can't use a full Excel doc in a Goggle Drive share, just might not be able to edit it directly from there.
My only concern content wise is how the sheet is going to scale as a kingdom grows and that the math is rolling up even if you have multiple cities going on.


Electric Cat wrote:
Content wise I like it.

Thanks.

Quote:
My biggest beef with it is more aesthetic than anything really.

Fair enough. This is one of those things that's never going to satisfy everyone.

Quote:
Nothing saying you can't use a full Excel doc in a Goggle Drive share, just might not be able to edit it directly from there.

True, but being able to have multiple people edit it is key, for me.

Quote:
My only concern content wise is how the sheet is going to scale as a kingdom grows and that the math is rolling up even if you have multiple cities going on.

A valid concern that will never go away without good testing, but I'm not sure how a high number of cities affect the math. Each city is going to add x to a particular attribute. That's not ever going to change to x+1 after 50 hexes or 10 cities; it will always add x. The only thing close to what you're saying is that certain attributes (Fame/Infamy and additional Leadership attributes for Ruler and Consort) will add a static value when a kingdom reaches a certain hex size.

Unless I'm missing something, which is one of the reasons I'm making this template available, of course.


The same kind of shared editing is available on other platforms, like OneDrive but it is all a matter of personal preference.

As for cities, I wouldn't think you would have too many either. Especially in the terms of Kingmaker. If you were trying to use a sheet to do like Brevoy you might run into issues, but for building it out looks awesome. I know it is a lot of work to build these things.

Community / Forums / Pathfinder / Pathfinder Adventure Path / Kingmaker / Looking for help testing my Kingdom Spreadsheet All Messageboards

Want to post a reply? Sign in.
Recent threads in Kingmaker