Here we collect formulas and examples in order to be able to integrate and illustrate your work processes and production equipment optimally in the print shop:
A work process influences the preceding or following work process:
IF(CONTAINS(Directly preceding Tasks,"Digitalprinting"),1,Total processed goods*(3600/8000))
So here a time of 1 second is calculated (zero seconds are not allowed) if the preceding operation is "offset printing". If this is not the case, a normal execution time is calculated. This can also be specified for the setup & cleanup basic time:
IF(CONTAINS(Directly preceding Tasks, "offset printing"),300, basic clean-up time*60)
If a means of production influences the runtimes or quantity, you can use the following formula, for example:
(IF(machine="folding machine 123",value of folding machine 123,alternative value))
If the variable paper thickness is queried for a formula, this solution can be used to return a fixed alternative value if no thickness was specified in the print material.
IF(Paper thickness=0.0.150,Paper thickness)
If you want to cover several areas, you can use the rangeswitch function here. Here, for example
(RANGESWITCH(number of stations,1,10,1,11,15,1.5,15,20,2))
In the above example, a factor of 1 is calculated in the range of 1-10 workstations, a factor of 1.5 for 11-15 workstations and a factor of 2 for 15-20 workstations.
If it is important to get back the minimum or maximum value as a variable, it can be defined with MAX and MIN:
MAX(Paper width,Paper height)*Total processed goods/1000/cellophane wrapping per hour*3600
So here the maximum value of the variables paper width or paper height is used for the calculation.
We recommend the following formula for calculating the ink consumption:
IF(substrate coating,(((Total processed goods*(paper height*paper width/1000000)*Number of printed surfaces)*0.15)*1.6), (((Total processed goods*(paper height*paper width/1000000)*Number of printed surfaces)*0.15)*1.8))
If this is the case, we calculate the printed square meters and assume a standard area coverage of 15% (*0.15) with a consumption of 1.6g/sqm. For uncoated papers, we also assume 15% area coverage in this example, but then calculate with 1.8g/sqm. If the ink consumption of a product varies greatly, this formula can be used to quickly adjust the values.