|
I'm using your spreadsheet 3.1. I have 12 city districts, but the city consumption on the Overall page reads 10. The City Summary tab only shows the 1st 9 cities.
Any thoughts on what the problem might be?
Hmmm - can you provide a bit more info. Have you created 12 cities each of one district or one city with 12 districts? Have you made any mods to the calculations or copy-and-pasted the city tabs rather than using the existing ones (this will not then include them in the calcs, you have to use the unhide option to reveal the unused city tabs of which there are currently 25)?
I'll take a look in the meantime and see if I can figure out where the problem might be based on the info you've provided.
Addendum: I've just tried creating 13 cities and it seems to work fine like that, calculating correctly the City Summary and Overall tabs....
I'm using your spreadsheet 3.1. I have 12 city districts, but the city consumption on the Overall page reads 10. The City Summary tab only shows the 1st 9 cities.
Any thoughts on what the problem might be?
Hmmm - can you provide a bit more info. Have you created 12 cities each of one district or one city with 12 districts? Have you made any mods to the calculations or copy-and-pasted the city tabs rather than using the existing ones (this will not then include them in the calcs, you have to use the unhide option to reveal the unused city tabs of which there are currently 25)?
I'll take a look in the meantime and see if I can figure out where the problem might be based on the info you've provided.
Addendum: I've just tried creating 13 cities and it seems to work fine like that, calculating correctly the City Summary and Overall tabs....
Thanks; That's what I am doing wrong. I made new City Tabs using copy-paste. I'll look for the "Unhide" option instead and remake the last couple of cities.
So I used unhide to remake the cities I had made with copy-move and deleted the old cities tabs. But now my consumption is 1 too high. I show 13 cities in tabs and on the city summary tab, but my consumption is 14 on the overall page. The unhide option shows city 14 the next city to be used.
Does it automatically start consumption for a 2nd district for a city when it gets too full on the City Tab? We have 1 city that is full, +1 building as listed in the City Tab.
Edit- I tested it out, it does automatically add consumption for a 2nd district when the city gets too many buildings for 1 district in the city tab.
Isn't it middle of the page where it says, "Click here to start download from MediaFire.."?
PS; I'm not being sarcastic. Sometimes these sorts of pages are very busy and confusing.
Sorry, didn't mean to sound like a 102 year old stumbling around the internet.
The problem was, parts of the page were blocked at work, so there was essentially just a bunch of seemingly random text with no links.
At home, the link looks as you described.
Thanks!
How do you handle the buildings that can be built for a discount in the early stages of the game? For instance, I believe you can build a castle at the old Stag Lord's fort and it only costs half as much as a normal castle.
This program doesn't spend the BP automatically. You need to figure out how many BPs you are spending and then subtract it manually from the treasury.
This program doesn't spend the BP automatically. You need to figure out how many BPs you are spending and then subtract it manually from the treasury.
Thanks for the reply. One more question.
Can you turn off the automatic random event calculator? I think I would rather have a pull-down and select the event after an old-fashioned dice roll. That would also make it easier to handle the set event pieces.
|
|
Can you turn off the automatic random event calculator? I think I would rather have a pull-down and select the event after an old-fashioned dice roll. That would also make it easier to handle the set event pieces.
Unfortunately not. You could unlock the sheet and manually edit it, just by deleting the code in those boxes and replacing it with a drop-down list from the Event Generator tab (currently hidden), or add in your own list.
You can then roll a D146 to determine the event!! :)
Has anyone made or converted any of the existing ones to work more or less flawlessly on Googledocs?
Am trying to download the most recent version of the file from mediafire, but the whole download seems to be stuck at the processing file stage for the last hour or so. Have reloaded the page a couple of times and am slowly beginning to lose patience. Downloaded the very first file and thought it was great, but the fact I can't seem to download more recent versions is frustrating
|
|
Am trying to download the most recent version of the file from mediafire, but the whole download seems to be stuck at the processing file stage for the last hour or so. Have reloaded the page a couple of times and am slowly beginning to lose patience. Downloaded the very first file and thought it was great, but the fact I can't seem to download more recent versions is frustrating
Just checked it and it all worked fine for me, perhaps a temporary glitch?
|
|
Has anyone made or converted any of the existing ones to work more or less flawlessly on Googledocs?Or on an older format of Excel?
How old? You can get a Microsoft Compatability Pack for Excel here which may do the trick for you.
Saving out as a 97-2003 file highlights errors due to backwards incompatability issues, so there's no guarantee it's going to work! Give it a shot, though.
|
|
Glad the spreadsheet is proving helpful (certainly helps me)!
1: The weather modifier at the bottom of the overall page seems to always read as some variation of cold and stormy regardless of what the season is.
Thanks for pointing it out, you've spotted an error which I'll rectify in the next upload. It's just incorrectly selecting the season each time, simple to fix.
2. I can't seem to figure out how to get my first city (city1 sheet) to have more then one district. My group currently has 3 city districts. I've unhidden the city blocks on City Map one and filled 3 with the buildings they own but the city districts cell on city 1 still reads as having 1 district
The way the spreadsheet calculates how many districts there are is by summing up the number of blocks and dividing by 36. Therefore if you have created three districts, each with only 10 blocks, it calculates that as one block.
This needs a little bit of work so that it can correctly identify the number of districts, irrespective of how many blocks are in each district. I'll get on to it!
3. My team built an arena, its the only arena they have. When I try to put "1" in for number of arenas on the City 1 sheet, It tells me that a city is only allowed to have 1 arena and won't let me add it in.
Hmmm - not sure on this one. Works fine for me in MS Excel when I place a '1' in the box against Arena. I'll check there's not an error with the uploaded sheet versus my copy.
Thanks for pointing these out, I'll get straight onto fixing the problems. May take a couple of days, so please bear with me.
Cheers,
Z
|
|
Ok, I've updated the Kingmaker Kingdom Sheet with some tweaks and more major additions, as follows:
- Corrected an error in the weather calculator for the seasonal temperature variation.
- Added Random Personality Trait generator to Overall page.
- Added Character Data sheet to allow names and stats to be entered and then selected on the Overall sheet.
- Added 51 new optional building types gleaned from the Paizo messageboards and incorporated them into the calculations!
- Added Building Notes page to help determine which buildings offer what benefits.
- Made the Leadership role selection on the Overall sheet selectable from drop-down lists. The relevant bonuses are calculated automatically.
To fix the problem with Districts not accurately being calculated, you now have to manually enter the number of Districts in each City. It's the simplest solution to the problem without linking to the City Map tab which I am loathe to do. If anyone has any better suggestions, please let me know.
Version 3.2 of the spreadsheet can be downloaded from here. As usual, any problems/errors, let me know!
Cheers,
Z
Ok, I've updated the Kingmaker Kingdom Sheet with some tweaks and more major additions, as follows:
Zoetrope--Dang! Are you going for Ubber-Cool of the Year award or something?
Just downloaded. Might not get to fiddling till the weekend, but just from the additions I'm in awe.
You get many cookies. And milk. And a gold star to proudly wear upon the forehead.
All of which is to say: Thank you!! :)
|
Ok, I've updated the Kingmaker Kingdom Sheet with some tweaks and more major additions, as follows:
Zoetrope--Dang! Are you going for Ubber-Cool of the Year award or something?
Just downloaded. Might not get to fiddling till the weekend, but just from the additions I'm in awe.
You get many cookies. And milk. And a gold star to proudly wear upon the forehead.
All of which is to say: Thank you!! :)
Just in time running RRR on Sat.Thank you! Thank you! Thank you!
RPG Superstar 2014 Top 16
|
I've been using this sheet for almost a year now, and it works beautifully.
I'm wondering, has anyone tried this using Numbes on the iPad? I'd love to be able to just take the iPad to my sessions, rather than bringing a whole laptop to manage the Kingdom bookkeeping.
Thanks!
|
|
I've been using this sheet for almost a year now, and it works beautifully.
I'm wondering, has anyone tried this using Numbes on the iPad? I'd love to be able to just take the iPad to my sessions, rather than bringing a whole laptop to manage the Kingdom bookkeeping.
Thanks!
Not sure that Numbers has the functionality to handle the formulae within the spreadsheet, or perhaps some of the other complexity. If anyone has tried it in Numbers, I'd be keen to hear too!
Hi Zeotrope
I've been using the sheet for months now on Open office. I stuck with the version 2.0, army update was last patch. The weather version never really loaded right in Openoffice as it just took WAY to long to boot up, i think about 15-20 minutes.
I've made a lot of time consuming changes my players wanted and tried to keep a version close to the core AP except building errata and optional resources. Since i put a lot of time into it i figured there might be others who use open office that want a copy. Unfortunately openoffice will not convert back into Excel so its strictly an openoffice version, which isn't that big a deal cause it's a free program :D
some of the changes i've made are:
Layout changes and spelling corrections.
All sheets converted to full color with color identification of kingdom abilities. All yellow cells are fill in data.
Added more drop down info.
Added more comments sections.
Added PC/NPC sheet= all leaders are now selectable via drop down on overall sheet.
Kingdom sheet has additional optional resources with descriptions.
Added basic pathfinder calender to kingdom sheet.
Added awards section to kingdom sheets to track Story award permanent kingdom bonuses and coded data.
Added Building info sheet for easy reference of buildings.
Added city map sheets. Pathfinder building icons can be imported and pasted onto tiles if properly reduced in size. (not included for copyright reasons).
Buildings can still be selected via drop downs. Maps are not coded and can be copied and inserted for each city required. Map is 3x3 districts, 5x5 hidden.
City sheets now contain more magic item slots, most are hidden
Added Printable version Building info sheet for player handouts.
I was unaware of the City districts not counting correctly. This isn't a big issue as the cell can be unlocked and just made to be entered manually, which i think is what you did and anyone can do.
Anyway i have no way to host the sheet so if someone wants to host it give me an e-mail and i will send it over. Might give you some ideas for your version Zeotrope? My players love the smoothed out easy to read color charts if you want to take a peak.
Anyway i have no way to host the sheet so if someone wants to host it give me an e-mail and i will send it over. Might give you some ideas for your version Zeotrope? My players love the smoothed out easy to read color charts if you want to take a peak.
I can not host it (stupid Verizon) but I would like a copy please.
-- david
Papa.DRB
|
|
I've been using the sheet for months now on Open office. I stuck with the version 2.0, army update was last patch.
Sounds great! I'd certainly like to see a copy, as I'm sure other people would too. I can take a look what mods you've made and transfer relevant bits into the Excel sheet, no problem.
Anyway i have no way to host the sheet so if someone wants to host it give me an e-mail and i will send it over. Might give you some ideas for your version Zeotrope? My players love the smoothed out easy to read color charts if you want to take a peak.
I've just put my sheets up at Mediafire which seems to do the trick. Doesn't cost anything to set up an account or upload files, so give that a try.
Any problems, let me know and I'll give you my email so you can send me the sheet direct and I can upload it on your behalf.
Cheers,
Z
|
|
Added city map sheets. Pathfinder building icons can be imported and pasted onto tiles if properly reduced in size. (not included for copyright reasons).
Buildings can still be selected via drop downs. Maps are not coded and can be copied and inserted for each city required. Map is 3x3 districts, 5x5 hidden.
I would LOVE to know how you did this. I've modified the sheet - mostly added more buildings and a few new functions - but being able to add maps with graphics would be a crowning glory!!
If you can explain how easily here, that'd be awesome, or would you consider sending me a copy?? peacecorpsbrian at hotmail dot com
Thanks
|
|
I would LOVE to know how you did this. I've modified the sheet - mostly added more buildings and a few new functions - but being able to add maps with graphics would be a crowning glory!!
If you can explain how easily here, that'd be awesome, or would you consider sending me a copy?? peacecorpsbrian at hotmail dot com
Thanks
In Excel, you can just copy and paste images into the sheet - make sure you unlock the map sheets first to allow the pasting! Turn off maintaining aspect ratio in the images properties to scale them to fit. Not sure how to do it in Open Office though, sorry.
The building images you'll have to source from somewhere else, of course... :)
As an aside, what other functions have you added? I'm curious to know what other additions/improvements people are making to the sheet.
Would love a copy of the updated page too.
adam_cieslicki at hotmail dot com
Zoetrope,
Does your latest spreadsheet support the additions found in the "Book of the River Nations: Complete Player's Reference for Kingdom Building" guide found here:
http://paizo.com/store/byCompany/j/jonBrazerEnterprises/v5748btpy8kgrIt has additional buildings and such. I plan on using this supplement for my campaign but also wanted to use your wonderful spreadsheet. I was going to modify your spreadsheet to include the additions from this supplement but I didn't want divergent versions of the spreadsheet (having to re-add all my changes when you updated).
Thraug, the answer seems to be "yes." I'm using the Book of the River Nations too, and we took the pencil and paper work we did for the first few months and put them into the spreadsheet, and it was all there so far - everything that they built had a space in the spreadsheet (including a few things that I know for sure were part of BoRK's additions to the rules), so you should be safe.
One exception to this, and I was going to ask Zoetrope about it, is the Apiary Open Hex development. There seems to be an apiary in the city places, but not in the kingdom summary. Any chance of adding this in in a future development? (Of course, there'll have to be two versions, like for the mine, since it reduces consumption if built in the same hex as a farm.)
Thanks for the spreadsheet, all of those who worked on it. Super helpful.
was getting ready to e-mail out some copies to get some opinions on and test to varify and noticed some drop down information cells missing info. Should have it done next couple days, been hectic with new baby still in hospital. When i get some feedback and everything is ok'd i will try to post it on mediafire as Zeotrope suggested.
Added city map sheets. Pathfinder building icons can be imported and pasted onto tiles if properly reduced in size. (not included for copyright reasons).
Buildings can still be selected via drop downs. Maps are not coded and can be copied and inserted for each city required. Map is 3x3 districts, 5x5 hidden.I would LOVE to know how you did this. I've modified the sheet - mostly added more buildings and a few new functions - but being able to add maps with graphics would be a crowning glory!!
If you can explain how easily here, that'd be awesome, or would you consider sending me a copy?? peacecorpsbrian at hotmail dot com
Thanks
in openoffice you can create a "new theme" in your openoffice spreadsheet gallery. Once created you simply link the pictures you want from the appropriate file location and they will display in that theme. For instance mine is "Kingmaker buildings" and displays all the buildings i need. You can simple click hold and drag onto the map tiles. I made my map tiles and city districts as small as possible and still able to contain the longest building name, exotic craftsman was abbreviated to E craftsman in the drop down. If i made the district maps larger the sheet was huge as i made each map sheet 5x5 districts to a total of 25 districts!
Now zeotrope is correct in you can scale the images to fit on the map tiles, i found this too time consuming however in the long run. What i did was reduce all my building pics to the exact size i wanted them to be in the file folder so i only have to drag and place without resizing. In the case of single block buildings i think my size ratio is 50x50 pixels. You can use whatever pics you want for the buildings. my players actually prefer the green monopoly house symbol for houses lol.
The only bad thing is the theme folder must be created on each PC your using the document on. Not that big a deal to give players the picture file folder and upload it into there own kingmaker building theme however.
i sent copies to the two who requested. I want to see if they find any other issues before i post it on angelfire. Hopefully should have finished Doc up this week :D
I would love a copy of this expanded spreadsheet.
Email address is adamcieslicki@googlemail.com
I too, would love a copy of this expanded sheet:
Email is: IgnusFireSpirit at gmail dot com
Ok i sent out copies to everyone above. I'm not going to send out any more via e-mail so don't spam the thread asking lol. I'm going to work on polishing up the missing drop-downs tonight and hopefully have it up and available for all openoffice users in a few hours! For those 5 i sent out copies let me know if there is anything i missed or just let me know what you think of the Doc.
I was going to check it out at work, and will not open it with Excel. I guess I will have to get open office at home to open it.
This is the same problem that I faced, within excel proper, the file is considered corrupted and thus will not open. A version that works on excel would be very much appreciated.
This is the same problem that I faced, within excel proper, the file is considered corrupted and thus will not open. A version that works on excel would be very much appreciated.
Not that I want to rain on your parade, but please keep this an Open Office sheet. Many of the others get so complicated that they work only in Excel, and this is the last of the sheets that work in Open Office. Now that I am retired, and my work laptop is back to the company, I do not have access to Excel anymore and really don't want to spend $300.00 US just to have a spread sheet.
thanks,
-- david
Papa.DRB
|
|
Re. Book of the River Nations - I do have this and I am considering putting informaiton into the Excel sheet from the publication. There's probably some bits and pieces in there already, but plenty more still to be added! Can't offer a timeframe for doing so, unfortunately...
Once RunebladeX makes his Open Office spreadsheet generally available, I'll take a look and see about migrating some details into the Excel spreadsheet. I take the point that some people use Excel, some OpenOffice, but the only option is to have two divergent spreadsheets as they are developed/maintained by two different people! I doubt they'll every become identical.
Cheers,
Z
|
|
Re. Book of the River Nations - I do have this and I am considering putting informaiton into the Excel sheet from the publication. There's probably some bits and pieces in there already, but plenty more still to be added! Can't offer a timeframe for doing so, unfortunately...
Once RunebladeX makes his Open Office spreadsheet generally available, I'll take a look and see about migrating some details into the Excel spreadsheet. I take the point that some people use Excel, some OpenOffice, but the only option is to have two divergent spreadsheets as they are developed/maintained by two different people! I doubt they'll every become identical.
Cheers,
Z
Thanks Z!
Ok guys. i mentioned this above but maybe you missed it.
"Unfortunately openoffice will not convert back into Excel so its strictly an openoffice version, which isn't that big a deal cause it's a free program :D"
Excel CANNOT open and run an openoffice doc. Open office WILL open an excel document however. The reason is some of the coding Openoffice uses is not excel compatible. While some of the coding is the same between the two, openoffice converts some of the coding to openoffice coding once saved. SO again simply put again, Excel cannot open an openoffice document.
The reason i used Openoffice is because i do NOT actually have excel. I don't believe in buying a $300 program that i can use a free program to do. Since i myself have 2 desktops and 2 laptops that would have cost me $1200! I figured there was a lot of other users like me, and my players, who use all the money on paizo products and not everyone has has excel or the $ to buy it. While i understand not everyone has openoffice either at least it can be downloaded for free for EVERYONE to use! It doesn't take much space and i wanted a sheet EVERYONE could use without having to buy a really expensive program like Excel! Make sense?
The coding in the doc will have to be changed and entered into an excel doc, effectively rewriting the document to run on Excel. Something i can't do even if i wanted too. Maybe, once i get the doc up online,if zeotrope sees something he likes he he will incorporate some of the aspects into his original excel sheet.
I know some can't put programs on there work computers and only have Excel at work so they might want an excel copy. But, you really should be doing WORK at work shouldn't you?! lol.
I meant no offence by mentioning that the file did not work in excel. I have paid a good sum of money to get the full version of Microsoft Office that I have, and don't believe in getting more programs that will simply duplicate the functions of the programs I already have. I only have a certain amount of hard drive space, so why have two essentially identical programs on the same hard drive?
I look forward to the excel conversion, and until then will listen in to this discussion about the spreadsheets development with interest.
Well, that is new. It used to be just for Students and not Home. I know, because my daughter, a teacher, offered to buy the Student version for me a couple of years ago, but I turned it down since I wasn't a student.
That said, It is still $150 for a spread sheet. I'll stick with Open Office, thank you.
-- david
Papa.DRB
To be fair Excel by itself only retails at $140 and Office Home and Student 2010 (Excel, Word, PowerPoint, OneNote) retails at $150 (and licenses you for 3 computers: $50/computer). No, I am not affiliate with MS in any way but it is typical of MS bashers to exaggerate prices and ignore options so I wanted to inform you of the real price.
| 1 person marked this as a favorite. |
Ok been super busy with the new baby. The more info i added into the doc the more i noticed it could use for new players so it turned into quite the project. Document is now uploaded and free for all to use with Openoffice.org
RunebladeX's Kingdombuilder Document- Openoffice.org Version .
complete list of changes=
Layout changes and spelling corrections.
All sheets converted to full color with color identification of kingdom abilities. All yellow cells are fill in data.
Added more drop down info.
Added more comments sections.
Added PC/NPC sheet= all leaders are now selectable via drop down on overall sheet.
Kingdom sheet has the additional optional resources with descriptions such as rivers, lumber camp, lock, etc.
Added basic pathfinder calender to kingdom sheet.
Added awards section to kingdom sheets to track Story award permanent kingdom bonuses and coded data.
Added Building info sheet for easy reference of buildings.
Added city map sheets. Pathfinder building icons can be imported and pasted onto tiles if properly reduced in size. (not included for copyright reasons).
Buildings names can still be selected via drop downs. Maps are not coded and can be copied and inserted for each city required.
City sheets now contain more magic item slots, most are hidden
Added Printable version Building info sheet for player handouts. Sheet is hidden.
Added Rules sheet containing Kingdom Builder rules that were not displayed in cell drop downs.
Added Phase sheet for easy player reference of phases and made printable.
Added coding for Kingdom ruler(s) titles to automatically change with kingdom size.
Added enchanted forest to resources- optional custom resource
Added Rare enchanted forest to resources to cover forest hex with rare resource- optional custom resource
Added bridge, building, Ruin, and town resources to kingdom page for completeness.
Changed “resources” under special resources to "natural resources" to avoid confusion as resources is used a lot
Hopefully your players will enjoy the video game style appearance as much as my players have! This was player inspired. After a while, to my players, the numerous sheets all seemed to look the same and kingdom building became tedious and boring. With so many cells and sheets and all looking similar, my players quickly found it dulling there senses and hard to find what cells they actually had to enter data into. While the sheets did what they were designed to do, they had no visual appeal and became an eyesore. They asked me to change the layouts and add a splash of color.
While all the sheets/charts are cleaned up and colored it's not colored just for the sake of being colored. All Colors actually represent something for a quick reminder. Yellow for cells players can enter data into to build there kingdom. Color codes for economy, loyalty, and stability so players quickly recognize what's effecting each score. Leadership roles use the same economy, loyalty, stability colors to note what leaders effect which score. And Red to highlight warnings and cautions. There are a few other minor ones but those mentioned are mainly it. Other than that shades of greys are mainly used on most of the sheets to note cells that cannot be changed and to break up rows and/or columns for the eye to easily follow. I didn't want to make the document overwhelming so i tried to limit actual color use to a practical function.
Now, not only can your kingdom be fun to build up but a pleasure to look at as well! :D
Feel free to report any errors if any are found. I'm pretty confident everything has been found as the document is currently in use by my players and has been tested, but you never know when released to thousands of players. Feedback is also greatly appreciated!
Enjoy!
... The reason i used Openoffice is because i do NOT actually have excel. I don't believe in buying a $300 program that i can use a free program to do. Since i myself have 2 desktops and 2 laptops that would have cost me $1200! ...To be fair Excel by itself only retails at $140 and Office Home and Student 2010 (Excel, Word, PowerPoint, OneNote) retails at $150 (and licenses you for 3 computers: $50/computer). No, I am not affiliate with MS in any way but it is typical of MS bashers to exaggerate prices and ignore options so I wanted to inform you of the real price.
Yeah i did not mean it literally i was just trying to get my point across.
OK, i get it. I know many would like an excel version. I know I can't please everyone. I'm sorry that what makes sense for Excel users does not work for me. Like i said, i don't even own excel so i couldn't write a version for it even if i wanted to. If i did, i would have wrote it with excel and openoffice would have converted it just fine and i would have both versions. Like it did with Zeotropes original document.
I'm not even sure what codes work and what codes get converted between the two. I actually could not even write and code at all for openoffice at first. I was just another KM GM who wanted a kingdombuilder program like everyone else. Once i got it, me and my players wanted to refine it and make some changes so i learned how to code into it over the months all because of kingmaker! lol. With all the time learning how to do that and actually making the changes i figured i would share what i did with everyone here.
All the other versions are already excel format and fully functional so everyone still has a kingdombuilder sheet. I think a few of the changes i made, as i used version 2, Zeotrope or others have already implemented. Now that my version is up Zoetrope will be able to check it out and see what he likes or dislikes. Maybe he will tweak his or use some of my changes. Hopefully some users still provide some feedback so Zeotrope can see what people like or dont like IF he decides to make any changes to his.
I do know that if you have openoffice you should be able to import the City map sheets into the Excel version and save it as an excel version as those sheets don't use any complicated code if any at all.
I've made available what i have done for everyone. The kingdombuilder sheet seems to be a constantly evolving project. Anyone is free to pick apart my document and carry the torch onward if they wish. I've accomplished what i wanted to do to it and hopefully somebody finds it useful.
Cheers,