Factorio Forums

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.

I would like to know what are all the abreviations and variables stand for. I don't know what this formulas are for.

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.