Castle Empire Resource Calculator

[Wallstreet]

My suggestion for this problem is to use an Average Time that is in the middle of the 2 travel times. Say one time its 7min 32sec and another time its 10min 42sec
or 452sec and 642sec 642-452 = 190/2 = 95sec + 452sec = 547 sec or (9minutes and 11 seconds rounded) which is our median time and will result in a better calculation in my calculator.

lol, you could just add 452 and 642 then divide by 2 to get the median time. Anyways, just wanted to thank you for doing this and all your hard work Lordfef, it is appreciated and I have been patiently waiting for someone to do this.

[Lordfef]

Okay so you can edit the level and the equation at the end works but changing the level doesn't change the info in the consumes/creates per level. Also if you could put button to change the minute seconds into seconds and display it right below the input that would save me from having to bust out the calc when I change the position of my building. I would also suggest rounding off those numbers in the resource display part. 1,2, or even 3 decimal places is enough.

I have a building which I have paused and I was trying to put it into the database as 0 quantity but it won't let me drop below 1 and when I type 0 in the box it still puts it as quantity 1. I was able to edit the quantity to 0 and that gave me 0 production. This made me think of a possible option to pause buildings. Also I was thinking after looking at Aurorah's spread sheet that cutters could use a static amount of trees per level and foresters could produce a static amount. For example a cutter uses 1 tree per level and a forester plants 1 tree per level instead of basing it on production times. This would only work if they are close enough which I think most people do instinctively.

All sort tabs except building, creates, consumes generate and error message in the city overview.

I have thought about the minutes seconds thing further. If you could hide the column with the seconds information and put two columns one with minutes and one with seconds the functions could use the hidden seconds column and the player could change times when they move a building. Also like the link below you could make it so that when you put in minutes and seconds in the top it auto calculates it and outputs it to the right of the input sections. and then put an input for seconds below that and output minutes seconds. It works fine the way it is though. i am using my converter linked below.

https://spreadsheets.google.com/spre...hl=en_US#gid=0

1. Seems your not the only one who wants minutes and seconds fields so I will Fix this in the table.
2. The Errors are not from table sorting and I don't get any errors when sorting columns. I did notice tho that my import from REV 1 did not work out as expected. I forgot to remove the seconds string from the time values. Those are the cause of the errors.. Ill be fixing that. when i click the bar to sort up top all the fields move with the other fields so they do not become mismatched at all. There should be no error because of that.
3. Most People Won't Add a building of QTY of 0. If you really want to tho you can edit the QTY field in the table.
4. If you want static times for your trees plug in a round number like 60 for 1 tree a min or 120sec for 1 tree every other minute. You can be detailed if you want or round off to minutes to make everything neat. Although I like to see my raw numbers as I want exact production numbers personally.
5. I will cut off some of the decimal points it is a good point they are rather long but i must ensure they are only VIEWED shorter and do not actually affect the variable calculations.
6. I will look into fixing the consumes/creates fields with qty and level changes appropriately from within the table.
7. Also Adding Extension Association so saves associate with my program. I may or may not be able to make them auto load as well but I have hit a stone wall in finding the stored variable location of the file when the program is opened from a save file.... oddly microsoft sucks at explaining anything usefull or helpful in this area and all the examples i read and find are either wrong or dead ends. Ill keep looking though otherwise at least it will open the program *shrug*

I am really busy this week and a guild on another game is going to war with me so I have to manage that as well as work and see my fiance who is in the hospital this week due to a recent operation she had gotten. I will try to get this out asap tho.

[Afetogbo]

A few more thoughts.
Base settler creation is 4/hour or 1 every 15 minutes. It would be cool if there was a box next to some items such as bread or fir wood planks to check. this box would allow you to send your bread to settler production or fir wood to hard wood production.

perhaps a troops tab which will allow you to check the troops you want to make in what order and it will then calculate how many troops per hour you can make and if you are deficient in a resource like beer. I can probably make the equations if you want.

oh and I stopped using my spreadsheet yesterday cause yours is great thanks dude.

I have made a companion spreadsheet to your calc which is used to calculate how many tools you need per hour, how much beer you need per hour, seconds to min/min to sec, and if you used all bread to make settlers per hour.
https://spreadsheets.google.com/spre...N2dmc&hl=en_US

[Afetogbo]

Just found out it takes 80 level 3 bowmakers to make the same amount of longbows as 1 level 1 longbowmaker So i guess a check bow for turning bow-longbows and Bswords-Iswords isn't needed.

[Baulthar]

Neither of the download links work for me.

[EdHardy]

Megaupload is shut down now we can't get access to these anymore

[Pants3000]

Is there another place where i can get this calculator since megaupload has gone bye bye?