Page 1 of 1

Some Formulas for Production

Posted: Thu Aug 15, 2019 4:36 pm
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.

Re: Some Formulas for Production

Posted: Fri Aug 16, 2019 12:13 pm
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.

Re: Some Formulas for Production

Posted: Fri Aug 16, 2019 4:25 pm
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.