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.
Some Formulas for Production
- LightspeedLazer
- Burner Inserter
- Posts: 11
- Joined: Mon Jul 29, 2019 2:50 pm
- Contact:
Some Formulas for Production
Last edited by LightspeedLazer on Fri Aug 16, 2019 4:27 pm, edited 2 times in total.
LightspeedLazer, playing Factorio since 0.16
Steam
Steam
Re: Some Formulas for Production
I would like to know what are all the abreviations and variables stand for. I don't know what this formulas are for.
- LightspeedLazer
- Burner Inserter
- Posts: 11
- Joined: Mon Jul 29, 2019 2:50 pm
- Contact:
Re: Some Formulas for Production
Sorry about that, I updated it to include those.
LightspeedLazer, playing Factorio since 0.16
Steam
Steam