Ultimate Campaign Kingdom Tracking Spreadsheet


Community Use

851 to 887 of 887 << first < prev | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | next > last >>

Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

5.8a is indeed the latest, and that tells me exactly why you're not seeing small and large towns and cities, too - Ultimate Rulership doesn't make that distinction (see p17 of URule), and since I'm making the sheet reflect URule before I figure out that merged and options for selecting specific rules, that's where it's at. If you want to, you can unprotect all of the city sheets and do a find/replace on references to $AP$6 and $AP$8 to replace them with $AN$6 and $AN$8, which should return the sheet to the UCam modifiers and settlement types.

Edit: I will point out that this does not mean I necessarily agree with how URule handles things - which is part of the reason for wanting to do a consolidated version once I'm finished with the overall version - to be able to pick and choose which rules the sheet uses.


Pathfinder Starfinder Adventure Path, Starfinder Roleplaying Game Subscriber

This is truly awesome, and the thread in general has lead me to buying some extra supplements for my Kingmaker campaign.

Chemlak did you ever decide if you were going to implement Ultimate Factions? Just curious as I have a player that wants to run a spy ring and Factions seemed perfect for it.

Thank you again for all your hard work!


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Thank you very much, dracklor.

I am definitely going to be implementing Ultimate Factions as part of the sheet (it might sneak up the priority list a bit, actually), but because of my amazing ability to procrastinate and another project I have on the go, it might take me a while to get it done.


Thank you very much for the reply! I hadn't gotten a hand on Ultimate Rulership before, although I did know that the sheet was based on it. Most of the stuff, like new Edicts and population could easily enough be deducted from the sheet.
I just thought it unlikely that Ultimate Rulership would in any way or form 'reduce' stuff, compared to UC, although now, that I had a look, I see that it was just moved to the terrain.

Anyways, thank you again for your amazing work!


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

My pleasure to help out. Every question I get here helps me make sure I know what I’ve done and why I’ve made the choices I’ve made (as well as help me with my understanding of the rules), so I love being able to help people out!

And the recent announcement of 2E means I really must get on with completing this so that we can start 2E with a clean slate.


Thank you for this spreadsheet. I am sure it took alot of time to put together. I have a question about the Overall page. I am filling in my new kingdom information and under Edicts I put in an Annual Holiday Edict. This is supposed to increase Consumption by 1 and Loyalty by 1. The BP cost under edicts and the Edict Cost under Consumption is correct, however the Holiday Edict is trying to apply a -1 Economy and -2 Loyalty on top of the 1 BP consumption rather than just a +1 Loyalty modifier. Is there a fix for this?


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

No fix or ability to amend that at this time: that’s the modifiers for an annual holiday edict from Ultimate Rulership. A future version of the sheet will allow you to select between UCam, URule and Custom modifiers for all edicts, but that’s a bit of a way off.

I’ll dig into the guts of the sheet and let you know how to put edicts back to the UCam versions a little later today, if that’s okay?


No need to alter the Holiday stuff. I see it now. I didn't realize it was using the Ultimate Rulership values instead of the basic values. The ultimate rules are alot more costly but I have it worked out now.
If your going to dig into the sheet the other thing I noticed is Fame. Fame is only supposed to be adjusted by Lore/Society for every 10 points. The sheet is rounding up. So when my starting city has -2 Lore and -1 Society its giving me a -1 to Fame instead of a 0 modifier.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Ooh, thanks, that’s a huge deal! Bet I used integer rather than a round function.

Fix ahoy!


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Okay, the above and another issue have been fixed, but site maintenance messed up my post with the links (should be the same as the last ones, though, for all 4 sheets). I’ll repost properly tomorrow if game night doesn’t interfere.

Thanks, all!


Hi Chemlak! We just started our Kingdombuilding and we really appreciate this spreadsheet. It would be insane to get it right without it! :)

One thing we were able to find right away - we play with Ultimate Rulership rules so Recruitment Edicts gives a modifier to Society. You actually included it in the Drop Down sheet, but it's not being counted anywhere. I was able to insert a next column in Edicts part and make it count in main part of Overall sheet, but just wanted to let you know :)


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Wow, forum downtime and a whole host of life problems have prevented me from noticing this post until today, I'm so sorry!

Thanks for the heads-up Geralt - I thought I'd finished all those bits, so while I'm surprised, I'm really pleased that you noticed!

In other news, I just last week finished my part of a book for a 3PP, and I don't have any firm plans for a follow-up, so the spreadsheet again comes to the top of my not-running-games priorities list!

Now if I can just do game prep for my Pathfinder game, my Mechwarrior game, and my Rifts game, I'll be all set...


Don't be too hard on yourself! First of all, this messageboard doesn't help with being notified about replies. Secondly - you're doing tons of awesome work with thia spreadsheet.

Also - I did take the ezcel version, put it on my GDrive and let the Google Spreadsheets do its magic. It created a Google Spreadsheet file and works perfectly in the cloud. I'm not able to find anything that doesn't work properly :D


So, I'm currently using what seems to be the last version of the UCAM sheet, 5.4m. Everything seems to work, except the taxation. No matter to what level I set it, it just stays at 1 loyalty.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Can I just check - do you have a character in the treasurer role?

If there's no character in the treasurer role, the Vacancy Penalty applies, which won't let you get the effect of any taxation level above None:

Quote:
Economy decreases by 4. The kingdom cannot collect taxes—during the Edict phase, when you would normally collect taxes, the kingdom does not collect taxes at all and the taxation level is considered “none.”

Sovereign Court

Hey, I'm just starting out and this spreadsheet is super helpful, but I noticed something and I don't think it is in your to do list. Some buildings, like Castles, have a negative effect on Unrest, but I don't see that getting applied? If I put in an event that generates Unrest, it doesn't look like that -4 is showing up. Am I doing something wrong?


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Sorry, thought I'd replied to this a couple of weeks ago. Oops.

Because Unrest is a dynamic number that can be affected by more things than just buildings and terrain enhancements, it's not possible to automate the calculation of it, so it must be adjusted manually in the Unrest box on the Overall worksheet.

I looked into automating some of it, but because it has a floor value of zero and because it's possible for multiple minor Unrest amendments to happen each turn (successful stability roll in the Upkeep Phase and the Royal Enforcer using their role benefit in the same phase, for example), you'd just be racking up huge numbers by the time the kingdom's been operating for a couple of years, which would vastly exceed the usefulness of the automation.

A similar argument exists for why the Treasury balance isn't automated as well.


This is a GREAT WORK- thank you many times over.

A number of the items on the pull down do not appear in their respective spreadsheets -or at least what I thought was the last version
(Brothel and Witches Hut are couple Examples)
Would be nice if you could edit names in Pull down or add more.
Is possible to get copy of an editable version?


Jahtalkintome wrote:

This is a GREAT WORK- thank you many times over.

Scratch previous comments.
This rocks! Easy to edit and have already added a number of new building types!


Any idea whether or not the spreadsheets will open properly and work in Google Sheets? (Or whatever the Google version is called.)


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

I've not tried for a long time, but the last I heard it opens fine in Google Docs, but I don't write it in there or test it either - however, if you try it and run into any trouble, please let me know.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber
Jahtalkintome wrote:
Jahtalkintome wrote:

This is a GREAT WORK- thank you many times over.

Scratch previous comments.
This rocks! Easy to edit and have already added a number of new building types!

I'm guessing you either found what you wanted somewhere, or discovered that the protection on the workbook isn't password protected at all, so anyone can customise the sheet however they want.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

If you've not seen it yet, Legendary Games are doing a Kickstarter for Ultimate Kingdoms, compiling the Ultimate Plug-ins line of books.

Here's a link to my personal input.

Legendary Games do the best work expanding the kingdom rules, and I have to give them every ounce of support I can muster for this. Please pledge and make this ultimate compilation truly legendary!

And in case anyone is wondering, yes, Legendary Games approached me a while ago about including the spreadsheet as part of the Kickstarter. I had to decline because I am not confident that doing so would keep this spreadsheet in line with the Community Use Policy, and I am 100% committed to keeping this spreadsheet free for everyone, as complete as I can make it, and compatible with the CUP.


Hey Chemlak,
I saw that you upgraded to the queen level...any thoughts on what you are submitting yet? I got some recent medical bills to sort before I can commit to the KS and maybe I might just be fishing for ideas and such...

Scarab Sages Contributor, RPG Superstar 2008 Top 4, Legendary Games

1 person marked this as a favorite.
Chemlak wrote:

If you've not seen it yet, Legendary Games are doing a Kickstarter for Ultimate Kingdoms, compiling the Ultimate Plug-ins line of books.

Here's a link to my personal input.

Legendary Games do the best work expanding the kingdom rules, and I have to give them every ounce of support I can muster for this. Please pledge and make this ultimate compilation truly legendary!

And in case anyone is wondering, yes, Legendary Games approached me a while ago about including the spreadsheet as part of the Kickstarter. I had to decline because I am not confident that doing so would keep this spreadsheet in line with the Community Use Policy, and I am 100% committed to keeping this spreadsheet free for everyone, as complete as I can make it, and compatible with the CUP.

And we're 100% on board with this plan. It's a great community resource, and doing it this way allows it to stay available as it always has been and for Chemlak to keep building it out at his own pace without anything hanging over his head with the kind of fast-moving action a Kickstarter can involve.

But by all means please do come by and pledge to Ultimate Kingdoms!

I've been eyeballs-deep in the kingdom-building rules for a decade and wrote the official chapter in Ultimate Campaigns and will be designing the PF2 version for the just-completed Paizo Kingmaker 10th Anniversary project. This project includes additional material from current Paizo folks like Mark Seifter and Linda Zayas-Palmer, plus our very own Chemlak too! You're not gonna find anybody more dedicated to this area of the rules than Legendary Games, but don't take our word for it. Check the reviews and give the rules a try. Show your heroes how to become LEGENDS!


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber
Thedmstrikes wrote:

Hey Chemlak,

I saw that you upgraded to the queen level...any thoughts on what you are submitting yet? I got some recent medical bills to sort before I can commit to the KS and maybe I might just be fishing for ideas and such...

I have thoughts, for sure, but nothing solid, and there’s some bits I expect Jason will need to make a call on, so I’m not quite ready to reveal all.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber
Jason Nelson wrote:
... for Chemlak to keep building it out at his own pace ...

Which is code for “glacially slow”. ;)


1 person marked this as a favorite.

Awesome to see that this is still being updated and expanded! Although the (long time ago, basic....) sheet I created never got used much by myself, it is great to see it did form the basis of such an advanced and improved version of the sheet.


Pathfinder Maps, Pawns Subscriber; Pathfinder Roleplaying Game Superscriber; Starfinder Charter Superscriber

Chemlak, I just wanted to pop in and say that our gaming group is once again using this amazing tool (UC Excel v5.3m specifically) that Berhagen, you, and others have developed.

Thank you so much for your continued hard work on this stuff. It has helped to provide us with years of quality entertainment. I could not even imagine using the varied Kingmaker rules without such a tool to help us keep track of everything!


Hi there.

I have notice a glitch. When high Priest is vacant, his bonus is N/A, … which put N/A in the calculation of stability… which in turn become N/A.

It could be easily solve by adding a default value in your enbedded IF.

I didn't notice it for other leadership functions.

(didn't read the 18 pages. hope i am not the 23° to spot it).

Marvellous work, by the way.


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Ooh, that’s new.

I shall go digging!


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

I have dug, and I am unable to duplicate this issue.

Can I be sent a copy of a spreadsheet that's having this problem, either a link to a share, or emailed to me chemlak (at) blueyonder (dot) co (dot) uk ?

Thanks!


Curiously, the problem appear and disappear without visible Reason. i have checked the formula with no resulte. right now, all works well. weird.

could you relieve me from a doubt in my mind. when you click F9, something is supposed to happen, right ?
i found no macro. which is not surprising since the sheet saved in XLSX and not in XLSB.
What have I miss ? could the macro only work on the online version ?


1 person marked this as a favorite.
Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

Have I still not removed that instruction from the sheet?

F9 forces excel to recalculate the sheet, and should do absolutely nothing right now. The sheet purposefully has no macros in it to avoid security concerns from users.


OK good news.

Now, is there an user manual ? most cells contents are straight forward or easily linkable to UCam rules. but somes seems to imply a process that is not given.

for an example, there is a cell supposed to contain BP. but how will the sheet manage the upkeep or take account of a new sponsor?


Pathfinder Adventure Path, Rulebook, Starfinder Roleplaying Game Subscriber

That's a pretty big question - I'm not in a fit state to answer it right now (really tired), so I'll come back to that tomorrow.

851 to 887 of 887 << first < prev | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | next > last >>
Community / Forums / Paizo / Community Use / Ultimate Campaign Kingdom Tracking Spreadsheet All Messageboards

Want to post a reply? Sign in.
Recent threads in Community Use