Spreadsheet for calculating theoretical production/need

[Chickenpants]

Hey everyone,

I was just waiting for my rockets to be made and decided to make a spreadsheet that calculates the theoretical production and need for all resources depending on the number of frames of a given type you have. It assumes you have all the technology unlocked although you can manually play around with the values if you want to adjust to your tech level. It also does not include prestige levels because I was lazy.

It is a very very crummy attempt at this as I made it in an evening with very lacking Excel knowledge. It is not quite perfect, especially when it comes to the power requirements for some reason, but when I tried it with my existing factory producing 4 rocket parts a second it was "close enough" for me to be happy to share!

I might try to make it better if/when I have more time but for now this is it.

Google Sheets link for anyone interested:
https://docs.google.com/spreadsheets/d/1MvAZfYsMjqYWtx_AyKJ3o35UN7E5kTx3IwT0WR2mn_w/edit?usp=sharing

[Dwane Dibbley]

Or simply put into game info about max productions... Current info that changes every second and "remember" like 30 seconds past is horrible for optimizing.

[Hazir]

Thank you for your hard work!

so basic usage is to update the Frames Owned field ?

since im only at T11 i'll probably need to reduce some of the bonuses too

[Chickenpants]

Originally posted by Hazir:

Thank you for your hard work!

so basic usage is to update the Frames Owned field ?

since im only at T11 i'll probably need to reduce some of the bonuses too

Yup that's about it! The "end game" of the spreadsheet is to set however many rocket parts per second you want (which you'd just input as frames owned under the "rocket" category) and then you go down the list and adjust the number of other frames you need to sustain that number of rocket parts (you need a lot of resources for the rockets).

[Hazir]

i've greatly enjoyed using the sheet
it has some quirks, like iron ore miners being hugely over-valued, which caused major slowdowns to my production chains trying to build 400!

but overall without this sheet i probably wouldn't have bothered to finish the game.

i've prestiged once, saved the game and will probably only come back if there's an update that gives us proper consumption\production per second stats

[Dwane Dibbley]

Originally posted by Hazir:

i've greatly enjoyed using the sheet
it has some quirks, like iron ore miners being hugely over-valued, which caused major slowdowns to my production chains trying to build 400!

but overall without this sheet i probably wouldn't have bothered to finish the game.

i've prestiged once, saved the game and will probably only come back if there's an update that gives us proper consumption\production per second stats

Its not that hard to build stuff you need, check inventory what goes down and build it from bottom up. And with proper placements, its easy to just copypaste bigger blocks. But it needs patch to be worth replaying after prestige...

[Hazir]

Originally posted by Dwane Dibbley:

Originally posted by Hazir:

i've greatly enjoyed using the sheet
it has some quirks, like iron ore miners being hugely over-valued, which caused major slowdowns to my production chains trying to build 400!

but overall without this sheet i probably wouldn't have bothered to finish the game.

i've prestiged once, saved the game and will probably only come back if there's an update that gives us proper consumption\production per second stats

Its not that hard to build stuff you need, check inventory what goes down and build it from bottom up. And with proper placements, its easy to just copypaste bigger blocks. But it needs patch to be worth replaying after prestige...

it being hard is not the issue
players of this genre often prefer taking a mathematical \ optimal approach to their factory building. and the game does not give you the tools to do that
using the inventory to gauge consumption fails the second you put the smallest pressure on your production chain

[Consume Product]

I disagree with your formula for production bonus.

Example for basic widget .

• there are 4 upgrades for 15% prod bonus
  
• there is 1 upgrade for 40% bonus.

You did a total prod bonus of

(15+15+15+15+40) % = +100%.

which means you double the prod for free.
I did

1.15*1.15*1.15*1.15*1.4 = 2,44860875 =~ 245% 

wich means 145% more. so i double the prod for free and add almost another free half.

My production checks out with my number.

• When i produce manually on a non upgrade basic widget frame i get 346 items (i'm prestige 2 with treee maxed).
  
• When i produce manually on a maxed basic widget frame with placement bonus, i get 847 items.

847/346 is close to 245%. 

There is always a doubt if a bonus is additive or multiplicative. Here it seems it was multiplicative.

[Chickenpants]

Originally posted by Consume Product:

I disagree with your formula for production bonus.

Example for basic widget .

• there are 4 upgrades for 15% prod bonus
  
• there is 1 upgrade for 40% bonus.

You did a total prod bonus of

(15+15+15+15+40) % = +100%.

which means you double the prod for free.
I did

1.15*1.15*1.15*1.15*1.4 = 2,44860875 =~ 245% 

wich means 145% more. so i double the prod for free and add almost another free half.

My production checks out with my number.

• When i produce manually on a non upgrade basic widget frame i get 346 items (i'm prestige 2 with treee maxed).
  
• When i produce manually on a maxed basic widget frame with placement bonus, i get 847 items.

847/346 is close to 245%. 

There is always a doubt if a bonus is additive or multiplicative. Here it seems it was multiplicative.

Thanks! I’ll get that changed. I’m not sure why I assumed productivity was additive while quadruple checking all the speed bonuses.

[Jenno]

Which cells can I change after I researched some bonuses from the tech tree? Eg. smelting speed by 100% and Increase productivity if placed in right biome.

Thanks for the spreadsheet!

[WingedLeo]

Tip for the author. Highlight cells in a different color where the user needs to enter data

[Theo Tausendfüßler]

hi two questions I dont understand how it works for Tier 3 it sais I only need to build one oil field but 151 oil power plants? is there a typo or do I misunderstand something? also how can i change/input things on the sheet? i cant enter anything

[Valley]

Originally posted by Dwane Dibbley:

Or simply put into game info about max productions... Current info that changes every second and "remember" like 30 seconds past is horrible for optimizing.

Agreed.

[Panurge]

Nice work, Has anyone already found the right balance for rocket production with all the techs unlocked?

[llama]

Originally posted by Theo Tausendfüßler:

hi two questions I dont understand how it works for Tier 3 it sais I only need to build one oil field but 151 oil power plants? is there a typo or do I misunderstand something? also how can i change/input things on the sheet? i cant enter anything

The OP did say that their calculations didn't work for the power requirements. I ended up ignoring it and just kept an eye out on the inventory screen to make sure that it was keeping up.

I also added some conditional formatting to highlight when I was below the required levels so that I can more easily identify what other frames I needed to build.

[llama]

Originally posted by Panurge:

Nice work, Has anyone already found the right balance for rocket production with all the techs unlocked?

Depending on what production rate you want, but the spreadsheet is pretty useful to work it out. You can plug the number into F134 cell and then work your way up the sheet. I found that I had to enter in the values even though I hadn't built that many frames. This is because the entered values then affect the rows above.

A few issues I did find was that the spreadsheet calculates the ratios really precisely but only displays the required frames to the nearest whole number. I ended modifying the formula for that column to round up to ensure that I built more than required. Of course this has flow on impacts to the upstream frames as you will need to build more of them to support the extra frames.

I ended up building extra frames than suggested to ensure that there were no bottlenecks. In the end, in order to generate 2 units / sec of rocket segment, I ended up needing north of 500 iron mines.