I only changed the last one to 145 (4 districts). I didn't change the others because I thought they were good where they were.
Okay, that should definitely have done it.
I'll do a test later today, and if that doesn't work I'll need you to email me your file.
And then, after all this, I'll make it easy to change because it's less than awesome the way it is now.
Ooh, I'm thick.
Step 8: [...] Also, remove "IF(U8>1,'Drop Down'!Y17," from the beginning of the formula, and remove one ")" from the end.
I'll sort out the robust version next time I'm doing an update.
Wow, I've got lots of updates to do.
Hey guys, I'm going to be hopping into another Kingmaker game tomorrow afternoon and I intend to introduce this amazing tool to all of my friends. Thank you everyone for continuing to put so much effort into it. It's made such a huge difference for my past Kingmaker games.
Are there any bugs in the latest version, or anything else, that I maybe should be made aware of prior to telling them it's the best thing ever?
(FYI, we won't be using Ultimate Rulership, as they tend to distrust third party material.)
Hey RD.
If you're not using URule, then grab the UCam one (linkeh to OO version since I believe you'd prefer that one). I am not currently aware of any bugs in it (if you find any, let me know!), and is currently in a "finished" state.
As usual, I welcome any suggestions for improvements or tweaks to make it better for people, but real life keeps interfering with me doing updates.
Not that I'm giving up, I definitely want to see this through, but finding time for updates is proving hard.
hey Silver, could you post the link?
I'd absolutely need the one with the Ultimate Rulership rules included :)
| 2 people marked this as a favorite. |
Gah, forums eating my posts!
Excel file for Ultimate Rulership.
I wrote a big reply to Silver Hawknight over a week ago and it seems the forums ate it.
The basic point was: thanks for the support, no need to buy me anything, I do this for fun!
Thanks Ademon!
I'll take a look over the next couple of days at all those. I think I know why all of them exist/went wrong (copy/paste errors are us), and can easily fix the errors. As for #5, that one is tricky, since it looks like it might be wrong a couple of different ways, but I need to work through it in depth.
Regardless, I'm on the case!
FYI: Ademon is an absolute legend and has begun the process of fixing numerous issues with the sheet.
I'll be reviewing them when I get home from my Easter break, and will hopefully have a lovely big update at some point on Monday.
Ademon has been fantastic, so please find, for your pleasure:
5.8 Ultimate Rulership Update
Excel
Open Office
Numerous bugs squashed, references corrected, and some fantastic Quality of Life updates, I really can't thank Ademon enough for his work on this.
Also, is there a way on the City Map sheets to "check" the boarders to mark them appropriately? i.e. City Wall, Moat, Land, Water, etc.
Glad you were able to find the hidden city sheets!
In answer to the above question, not yet, but I'm aware of that, so it will become possible at some point.
Send me your sheet, please!
Chemlak at blueyonder dot co dot uk or a Dropbox link.
There are a LOT of reasons for the numbers to be a bit whacky, most of them user error, but diagnosing all of them is hard. If I look at the sheet I can figure it out.
Either email me the file (my email address is in the second line of my last post), or if you use a file sharing site (such as Dropbox), put it into your sharing folder and PM me a link to the share.
If you have any problems with that, let me know and I'll sort something else out.
In case anyone's wondering, Spiritstalker emailed me a copy of his sheet earlier today (well, probably yesterday to him!) and I checked it out. I'm pretty sure it was user error (an easy mistake to make involving hidden city sheets), fixed it all up for him, and sent it back.
I'm hoping I got it all right!
5.8 appears to be too large to open in Google Sheets.
Would removing the building pictures and associated pages reduce the file size noticeably?
Yes, they make up a huge chunk of the overall file.
Not sure if it's a file size issue, but if it is, try the Open Office version, which is about half the size of the Excel one.
I get people asking about a Google Sheets version fairly frequently, so if you do manage it, please let me know!
Version 2 of my Build Timer Ver.2
I finally used this with my players a couple of weeks ago and discovered I needed some modifications. One BIG mistake was not doing the build cost as an "over time" calculation. Not sure how I missed that the first time around as it was a huge point in doing this in the first place. Guess I was just being thick! Since I was using Ultimate Rulership with the optional rule of increased cost for duplicate buildings I added that data as well.
I found I needed to keep track of which hex and settlements were being improved so I added a column to put that information into. I also found I needed to be able to track when I put the data into the Kingdom spreadsheet so I put in a column to mark when I did so treating it as a check box. I also wanted to keep track of costs each round as well so added columns to record BP expenditure, consumption, and Income for each turn. It then will calculate the BP total.
I would love to hear any feedback anyone might have.
Kevin
It's been a long time since I've even looked at my kingdom's sheet. I got the city/metropolis thing squared away (thank you very much, Chemlak!) Now I want to tackle the army section. How would you go about adjusting the army size to match Ultimate Battle in that regard?
Also, how would I adjust the consumption for armies, if I were so inclined?
Nevermind! I figured it out. The hard part was finding exactly where all the formulas where hidden and how they related to each other
The new version, however, has issues with calculating the values for the cities. There is just a #NAME error for all of the formulae in each city.
Oooh, thanks MoJ.
Sorry for the hugely delayed response. I've been all over the place, lately.
Warped Savant found a bug that's been sitting in the UCam sheet for an indeterminate period of time - Armies couldn't be based on CR 6 creatures. Oops.
Fixed!
As might be apparent, I have a bit of time available, so I'm hoping to hit up the issues people have been raising.
So...
Minotaur of Justice, please send me your sheet by email to chemlak (at) blueyonder (dot) co (dot) uk, because I'm not seeing any issues in the city sheets at all at my end.
Random Players, if you've attempted to filter or reorder the Buildings sheet it (for some reason that I haven't investigated in full) completely messes up the whole spreadsheet. Table14 is VERY sensitive. It's recoverable, but a pain to do, so if you're comfortable doing that, go for it, if not send me your sheet to the email address above, and I'll sort it for you.
Kevinmcc, I haven't been able to look at it, so far, but a build timer is a huge deal to me and I really really want to include one in the URule sheet, so I'll be checking it out soon™. Do I have your permission to steal (aka take with full accreditation to you) it?
That's all I've got for now, hope to hear from people soon!
Okay, leave that with me, I'll see if I can figure it out. Error 509 seems to typically hit due to syntax errors in non-simple formulae. Should be nothing at all to do with your language settings.
Sometimes I hate table14.
Fair enough: no need for you to take any action, I'll try to figure it out from my own copies.
| 1 person marked this as a favorite. |
Bugfix 5.8a!
Random Players was spot-on noticing the problem with the OO sheet, and I needed to make a change on the Excel one to get it working properly when converted.
Love these sheets. I'm not really savvy with Excel. How do I add more city and/or army sheets to the latest update?
There are 25 city sheets and 9 army sheets already in the workbook, but most of them are hidden.
In Excel you're looking for the Format menu, Hide/Unhide, Unhide sheet. That will bring up a list of all the hidden sheets. Unhide any that you need (you have to do it one at a time). I'd recommend not messing with the Dropdown sheet.
Hope that helps. If not, just shoot me a PM (adding more cities and armies is technically feasible, but a bit of a pain to get right).
So I've been not checking the forum for a while. Yes Chemlak, you may make use of whatever I have. I have no secret formula to keep from anyone and would love to know what I have done is being used.
By the rules, each lot adds 250 people (instead of each building). A castle is 4 lots therefore it's 1,000 people.
(I thought the same thing when I first started too.)
Warped Savant is absolutely correct.
I think I spotted a bug in the Excel 5.8a version. The City Consumption sub-calculation on the Overview sheet uses "='City Overview'!G27+'City Overview'!F27". Column F on the City Overview sheet is for City Fame, according to the header, with F27 being the sum of the Fame scores for all 25 Cities. Column E is the number of Districts in each City, which is what affects a City's Consumption if I recall correctly.
| 1 person marked this as a favorite. |
Good spot! It’s actually me being decidedly cheeky and lazy and using a shortcut. In URule there’s a big table of buildings, and some of them have asterisks next to the name. All of those buildings have +1 Fame. No other buildings alter Fame. The rules say that all buildings in that table with an asterisk increase consumption by 1.
That’s exactly where it will appear, but since I don’t own the book it appears in and nobody mentioned it before now (as far as I know), I didn’t even know about it.
Excellent to know, and I’ll get it in as soon as I can, thanks!