### Some Formulas for Production

Posted:

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

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.