| 21 people marked this as a favorite. |
Hi guys.
I run Kingmaker adventure path (online with TTopRPG virtual table), and a need arise for fillable kingdom sheet. I created kingdom automated fillable pdf sheet to help my players managing their kingdom. With a release of Ultimate Campaign, we decided to switch to rules presented in UC, so I've made another fillable kingdom sheet (automated) and fillable army sheet.
Unfortunately I can't share Kingdom sheet found in adventure path Kingmaker because of Community Use Policy terms, but I can share sheets from Ultimate Campaign.
I uploaded the files in my Dropbox account. Here is the folder link
UC Kingdom Sheet v1.0.pdf - fillable kingdom sheet based on sheet found in Ultimate Campaign
Sheet is completely automated.
UC Army Sheet v1.0.pdf - fillable army sheet based on sheet found in Ultimate Campaign.
City.xls - this is auxiliary file for managing cities. Also helps for filling out bonuses in kingdom sheet. File is created in Office 2007, so it's best to open in Office 2007 or 2010. It isn't tested in earlier Office versions, so I don't know how it'll behave. In my experience probably it'll look uglier and more messy.
If anyone found some odd behavior or bug, please report it, so I can make corrections.
P.S. I apologize for repost. I broke Community Use Policy terms with sharing sheet from Kingmaker AP and I had to remove the link and repost again.
You rock!
Thank you :)
Thanks for all the hard work on this. ^_^
You welcome :)
| 1 person marked this as a favorite. |
Hmmmm...
I just tried links and they are working fine for me. I tried it while I was logged off from dropbox just to be sure. Don't know why you are getting a error. Several of my friends also downloaded through this links and everything was ok.
If you want, PM me your mail address and I'll send you the sheets.
@Ggodrick
I'm not sure if I'll be able to reduce size, but surely I can try. Give me a couple of days and I'll see what can I do :)
UPDATE
Ggodrick thanks for pointing this issue. I managed to reduced file size for kingdom sheet to cca 225kb, and army sheet to cca 150kb. Just for reference, before they were 3.8mb and 1.3mb :)
I created sheets in Adobe Acrobat X, and now I see why everybody are running from Acrobat and instead getting Foxit. I's a piece of junk.
The longer you work on pdf, the more garbage acrobat puts in it, and you can't remove it. Even with optimize and reduce file options. And thus, file size grows to unbelievable number.
I should really get rid of Acrobat and get Foxit :)
I had to change fonts type for some field (i.e. kingdom name field, reset buttons...) to reduce file size. When I tried to keep the old font for kingdom name, file size jumps from 200kb to cca 1mb. So I decided it's not worth it :)
You can access new versions from folder link in first post or this links:
UC Army Sheet v1.01
UC Kingdom Sheet v1.01
Does somebody knows how can I edit first post ???
I know that you can edit for max one hour after posting, but is there some work around ?
I want to have updated links in first post to keep things more organized.
@Ggodrick
You welcome. Glad to help :)
If you find out another issue, just report it and I'll fix it as soon as I can.
I don't know what was your problem with calculations in acrobat but maybe this will help. I noticed that if you first create formula (code) in field and then do some changes in field(s) that are in before mentioned formula, formula will work but in an odd way. Acrobat will calculate correctly but will be one step behind. Don't know how to better explaine this.
Solution is to create formula or code in the end when all the fields are done or to delete formula (code), click OK or close, and then enter formula (code) again and it'll work.
Glad to help.
I learned about this issue and its solution on a hard way :)
UPDATE
Fortunately I noticed that what we discussed above happened in Kingdom sheet v1.01.
When I C/P all fields and formulas to new sheet to reduce file size, Acrobat went little crazy and miscalculate everything and unfortunately I didn't notice.
I corrected this and now sheet should work fine.
Here is link:
Changes:
Ver 1.02 (07.August.2013.)
- fixed miscalculations caused by Acrobat as a result of reducing file size.
Cathedral building entry in UCam says "Halves Consumption increase for Promotion edicts", Cathedral building entry in UCam says "Halves Loyalty penalty for Taxation edicts" and Arena building entry says "Halves Consumption increase penalty for festival edicts" (from Kingmaker AP).
It isn't mentioned if this halving is round down or what. I presumed that rounding down is correct so I included following changes:- when Cathedral is "on", BP consumption for Token promotion level equals 0 instead 1.
- when Waterfront is "on", Loyalty penalty for Light taxation level equals 0 instead -1.
- when Arena is "on", BP consumption for 1 Festival per year equals 0 instead 1.
YES!!
You welcome
You welcome
When I click on the link it says nothing here?
Use Folder link for all version of sheets.
When I created this topic I didn't know that "Edit post" is available for only one hour after posting. If I knew that, I would post links in another way.
Use Folder link for all version of sheets.
When I created this topic I didn't know that "Edit post" is available for only one hour after posting. If I knew that, I would post links in another way.
I am having trouble getting the city spreadsheet out of protected mode. Any advice?
I didn't put any protection. File was was created in excel 2010 and sometimes saving as 97-2003 format can do some crazy stuff. For me it's wokring fine.
I presume you get a message for protection like this http://officeimg.vo.msecnd.net/en-001/files/763/533/ZA010388955.jpg
Click on that message and then click on a large button "Edit anyway" and you are good. This is for excel 2010.
I uploaded again City.xls and I also uploaded .xlsx version in dropbox. You can access it through folder link in previous post.
I think both should work now for you without getting protection message. Please try it and report it.
Btw. thanks for reporting
Good Stuff
In for the dot
@Fletcher Bates
My friend (player in group) uses Foxit, but he never complained about this issue. I'll install Foxit and try for myself to see if this issue will reproduce.
@Fletcher Bates
Sorry I didn't manage to answer you sooner.
Based on my tests, only the latest version of Foxit Reader (6.1.2) reproduce this issue.
I tried to open sheet with Foxit Reader 6.0 and Foxit Phantom 2.2.4 and everything is working ok.
Those odd numbers occurs only in fields that have custom javascript, so I presume that latest version of Foxit Reader have some trouble with interpreting javascript.
Unfortunately I don't know how to resolve this.
I suggest you use previous version of Foxit reader or Acrobat reader.
Hope that helps
Np. Thank you for reporting issue.
Ucam kingdom sheet upgraded to 1.03 version
Ver 1.03 (12.March.2014.)
----------------------------- added Skill rank fields and implemented auto calculation for skill modifiers (Optional rule in Ultimate Campaign - For every
5 full ranks in a relevant skill, the leader may increase the leadership modifier by an additional 1)
Nice.
There is already a excel sheet like this you're trying to make.
Here
I don't use excel sheet because my group and I play online with TTop virtual tabletop and I created map with city disctrict and buildings, so there is no need for graphical sheet for me.
FYI Madbeard, your sheets continue to be amazing so many years later. This is our first playthrough of Kingmaker and these definitively rock.
I'm actually having issues editing certain fields, don't know if it's an issue with my computer/browser or what. Just thought I'd let you know.