Here we collect formulas and examples to optimally integrate and map your work processes and production equipment in the print shop:
An operation influences the preceding or subsequent operation:
IF(CONTAINS(Directly preceding Tasks,"Offsetdruck"),1,Total processed goods*(3600/8000))
A time of 1 second is therefore calculated here (zero seconds are not permitted) if the preceding operation is “offset printing”. If this is not the case, a normal execution time is calculated.
If a means of production influences the transit times or quantity, the following formula can be used, for example:
(IF(Machine="Foldingmashine 123",value of folding machine 123,alternative value))
If the variable paper thickness is queried in a formula, this solution can also be used to access the grammage, for example, if no thickness was specified in the print material.
IF(Paper thickness=0,(Grammage/1000),Paper thickness)
If you want to cover several areas, you can use the range switch function. Here, for example:
(RANGESWITCH(Number of printing plates,1,10,1,11,15,1.5,15,20,2))
In the example above, a factor of 1 is used for 1-10 Number of printing lates, a factor of 1.5 for 11-15 workstations and a factor of 2 for 15-20 workstations.
If it is important to get the minimum or maximum value back as a variable, you can define this with MAX and MIN:
MAX(Paper width, Paper height)*Total processed goods/1000/cellophane_wrapping_per_hour*3600
This means that the maximum value of the paper width or paper height variables is used for the calculation.
The advantages of the switch function:
For example, an individual difficulty level can be set for each component, which can be used to influence runtimes or costs across all components. It is best to use a switch function here:
SWITCH(Technical difficulty, “very easy”, 1, “easy”, 2, “normal”, 3, ‘difficult’, 4, “very difficult”, 5, 6)
With “very easy” you get the value ‘1’ back with “very easy” the value “2” etc.
Finishings can also be created with a selection menu.
This can be helpful if, for example, you want to include auxiliary staff as an option.
It could look like this:
Then you simply take the complete formula from the implementation time and include it in the additional costs for the personal contribution.
Only the following is added to the formula for the costs:
/ 3600 * Stundensatz zusätzlicher Mitarbeiter Tischarbeiten in EUR * Anzahl der zusätzlichen Mitarbeiter * 100
Percentage minimizations or increases over time can also be mapped via a simple specification of further processing:
*IF(minimization in percent=0.1,(100-minimization effort in percent)/100)
or:
*(increase in expenditure in percent/100+1)
Both formulas can then be appended to existing formulas for the time calculation.
We recommend the following formula for calculating paint 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))
We ask whether the material contains a coating. 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 differs greatly, you can quickly adjust the values using this formula.