resource calculator with production overview!

[Calen]

ever wondered how much materials(or goods) you make an hour/day?

well now you can with this spreadsheet i found on the american game forums:

Spreadsheet, resource calculator with production overview (https://skydrive.live.com/redir.aspx?cid=b8519c456903be18&resid=B8519C456903BE18!2661)
right click on the spreadsheet(in new window) and click on use in excel

For the ones that dont have a hotmail account, click here (public.me.com/martinbuckler)
link for people who doesnt have a hotmail account can click here to grab the spreadsheet!


I am using it to see if i need to build more farms, woodcutters etc. its quite handy!


Grtzz Calen!

[Saree3]

What most of us are waiting for. Thanks to the makers and to Calen for this good news :)

[Rohab]

Great stuff Calen.

[SirJumpalot]

This one is almost a must if you want to stay on top of your building .. Highly recommend this one :D

Cheers.

[SpiroTris]

Wow, nice work, thanks a lot! :D

[Blackeye]

Wow. This looks really amazing. a must have for this game.

[Diablos]

still have to learn how to use this. Do you need to be ingame to copy the data from your buildings into your excell sheet?

[Calen]

you need to click a building then put in the total production time and the level of the building in the spreadsheet(you dont have to do the buff one, just keep that at no for now)

[Dude]

This is just awesome. I finally managed to equalize my huge bread production :)

[Zalid]

Thanks for the excellent work put into this.

Main part of the spreadsheet works in Open Office.
I take it that the Building Icons work off of macros ? Which is probably why they don't work in OO. Can live with that tbh.

One little feature I would really like is a quick lookup page which just shows any shortages. The Production Summary is excellent. But would like something that highlights any shortages.

Again. Many thanks for taking the time to make this.

[Darkstorm2k8]

Awsome!!!

Who took the time to enter all that data and formulas is a patience god.

Gratz and thx for ure work!

[KillerRaw]

nice calc, before now i didnt now i needed more foresters and stuff :P

[Aerys_TarGaryen]

great tool thanks for the share

[marlock]

epicness to the max... very very useful .. thanks

[Nirod_Ark]

Hey man, thank you so much! Really appreciated! You did a great job!

[Ghost_EmpiresNL]

Could someone send me that as attachment?

[LordSnow]

This is super awesome! Thanks!

[KingSeal]

Just found this and download it will key all the figures in and see what a mess I have made and what I have to do to streamline my production thanks Calen

Gary

[wipes]

says opened in read only mode

[Fenrisw0lf]

says opened in read only mode

You need to download it, not just open! If you open it without download, it just will opened in the temporary internetfiles ...

[G_O_L_D]

Holy C**p thats some guide AWSOME ! thanks very much that must of taken you ages to do

[BluMojO]

thanks calen, and to the makers, this is a great help, does anyone know if there is a version of calculator that factors in the silo, water mill and recycling manufacturer...?

cheers

[Faun]

thank you very much!

[Carebear]

I will try this out, thanks. :)

[Sharra]

thanks , will try out

[scott-wsm]

Hi thanks for the work put into this, it looks really great.

Only problem it opens in read only in Office 2003 :( have used the conversion tool but it dont like it any chance it can be resaved as .xls format?

[terghi]

There's also this you can use:

http://ceo-economy.appspot.com/#

Calen provided me that link when I raised the same question about not being able to open the spreadsheet.

[scott-wsm]

Thank you, that is a great help :)

[Elles0705]

I attempted to add wells to the "extra" blank rows that have the 'Area #' column grayed out. It does not calculate the total production for each extra row. It appears the formulas were not carried over (??). Since I don't know who created the spreadsheet, not sure who to ask on how to view/fix formulas on the Wells tab.

Anyone else had this happen?

UPDATED: I removed the data from the first 3 extra blank (Area) rows and copied them to rows which contained formulas, as a work-around.

UPDATED AGAIN: Doh. Just realized you can change the Area # of your Well manually. Thought it was a protected cell. <slapping forehead>

[JavaJoeUK]

What a great help this was got all my stuff sorted out

[Soulkime]

I can't open it due to me only having an office 2007. Could you make a version that is supported by older versions?

[Scandinavian]

wow, the time that has gone into making this is staggering.
Started to fill in the data, soon I'll see the mistakes I've made xD

[Thornapple]

it wont let me open it as it says its protected

[Thornapple]

never mind i downloaded it to my desktop and then opened it with excel and it works perfectly thank you very much :)

[pika94]

hey i am on realm 2 and i was wandering when can you put it on ? becouse when i put my cursor on it it says coming soon ? thanks any way :)

[WylieQuinn]

I just got it. I had to right click on it and download, because my Office version is older. Looks good!

[WizardofPos]

Brilliant find, but obviously someone has too much time on their hands :P

Thanks

Rob

[Forester684]

That's an amazing excel tool thanks for that, was wondering in make my one calculator but I'm really happy with your master piece.

[totalE]

anybody else have a problem where after you go over 51 wells it stops recording an increase in water production?