Some Formulas for Production

Calculate optimal ratios for feeding recipes, search through the research-tree, specialized tools to view game-information.
User avatar
LightspeedLazer
Burner Inserter
Burner Inserter
Posts: 11
Joined: Mon Jul 29, 2019 2:50 pm
Contact:

Some Formulas for Production

Post by LightspeedLazer »

This is for all the people that want a formula instead of a spreadsheet.
The formula is the first listed, the second is the function for a spreadsheet (If placed in column F).

Desired I/S to Machines: When you want a specific IPS and want to know how many machines are needed
ceil((CT/CS)/(PC/100*(PE+100)*IPS)
=CEILING((A2/B2)/(C2/100*(D2+100))*E2)

CT = Crafting time
CS = Crafting Speed
PC = Products per Cycle
PE = Module Productivity Effect
IPS = Desired Items per Second

Machines to I/S: When you want to know how much your machines are producing
1/((CT/CS)/(PC/100*(PE+100))/M)
=(1/((A4/B4)/(C4/100*(D4+100))/E4))

CT = Crafting time
CS = Crafting Speed
PC = Products per Cycle
PE = Module Productivity Effect
M = Number of Machines working full time

I've had these formulas for a while and I wanted to get them out.
I will be updating this as I find more useful formulas.
Last edited by LightspeedLazer on Fri Aug 16, 2019 4:27 pm, edited 2 times in total.
LightspeedLazer, playing Factorio since 0.16
Steam
User avatar
Impatient
Filter Inserter
Filter Inserter
Posts: 883
Joined: Sun Mar 20, 2016 2:51 am
Contact:

Re: Some Formulas for Production

Post by Impatient »

I would like to know what are all the abreviations and variables stand for. I don't know what this formulas are for.
User avatar
LightspeedLazer
Burner Inserter
Burner Inserter
Posts: 11
Joined: Mon Jul 29, 2019 2:50 pm
Contact:

Re: Some Formulas for Production

Post by LightspeedLazer »

Impatient wrote: Fri Aug 16, 2019 12:13 pm I would like to know what are all the abreviations and variables stand for. I don't know what this formulas are for.
Sorry about that, I updated it to include those.
LightspeedLazer, playing Factorio since 0.16
Steam
Post Reply

Return to “Cheatsheets / Calculators / Viewers”