The formulas in the sheet
Every rate has a name, so formulas read like sentences:
Blank length = 2*(L+W)+GlueFlapBoard GSM = SUMPRODUCT(LayerGSM, LayerTakeUp)Paper cost = SUMPRODUCT(LayerGSM, LayerTakeUp, LayerRate) * BlankArea / 1000Price per box = MROUND(Cost / (1 - MarginPct), 0.05)
Plants differ on glue flap, flute take-up and wastage. The sheet shows each one as an input instead of hiding it, so you can match it to your own corrugator.