Excel template Average Weight Control
I am looking for an excel template to use for weight control at the line. The excel should give the Tu1 and Tu2 limits at a given gross weight. The operator fills the weights in the file and after the batch is ready the relevant information is calculated.
I know that software for this purpose exists but i want to use excel in this case.
Many thanks!
You can search for ,"How to make a control chart with upper limit, lower limit and mean in Excel" in YouTube. or watch this video. You can easily make it in Excel, follow step by step.
I am looking for an excel template to use for weight control at the line. The excel should give the Tu1 and Tu2 limits at a given gross weight. The operator fills the weights in the file and after the batch is ready the relevant information is calculated.
I know that software for this purpose exists but i want to use excel in this case.
Many thanks!
Hi olaf,
I assume this relates to EC Package Labelling Code mark ?
IIRC, the 2 "limits" are based (tabulated) on declared net weight ?
From memory the acceptability of the measured average net weight is technically based on a statistical t-distribution although one can always simply overpack to avoid such mathematical subtleties.
My guess is that the complete calculation is not exactly trivial.