Resource-Spreadsheet

[Cruel Device]

Howdy, fellow Mech commanders!

I've created a little spreadsheet for the basic resource buildings: Crystal field, Gas mine and Power plant.
It shows the costs for each level (taken from the guide) and some calculated values:

• The time required to produce the resources required to build a specific level.
  Example: Crystal mine lvl 15 requires 110,537 crystals to build, and it takes 98 hours (approx. 4 days) for that lvl 15 mine to produce this amount.(1,125 Crystals/hour)
• The time required to produce the resources required to build a specific level, but this time only the difference to the previous level is considered.
  Example: Crystal mine lvl 15 requires 110,537 crystals to build, and it takes 762 hours (approx. 32 days) for that lvl 15 mine to produce this amount. (Δ 145 Crystals/hour)

I've published the spreadsheet here.

Hope this is useful.

Regards,
Cruel Device

 

[blackhawksniper]

2 questions

1. Are the commas meant to be decimal points?

2. Whats the difference between Time (hours) till Prod. = Costs and Time (hours) to break-even
(Cost-Gas / Δ)??

Isnt the BEP when prod=cost?

 

[Cruel Device]

2 questions

1. Are the commas meant to be decimal points?

2. Whats the difference between Time (hours) till Prod. = Costs and Time (hours) to break-even
(Cost-Gas / Δ)??

Isnt the BEP when prod=cost?

@ 1.
Independent on language setup, googledocs only offers me the 1.000.000,00 notation. (I couldn't figure out how-to change it to US notation yet ...)
I honestly don't know how it's shown to you...

Anyway, the yellow and orange colums are meant to show 2 decimal places, the first three columns have 0 decimal places.

@ 2.
The Time (hours) till Prod. = Costs just lists the time required upon the whole production.

However, the benefit of a new lvl is only the increase in productivity. Therefore BEP would be calculated based upon the Delta.

Hence the BEP = Cost(crystals) / Delta production (for crystal fields)

EDIT: kind of busy now, I'll work on the spreadsheet later, to make it more obvious...

 

[AndyMaDas]

Nice work bud!