Dear carine,
Thks for reply.
I’ll try and summarise the production –
(1) There are 10 ice machines. This sheet is for 1 shift and 1batch (= 1 colour raffia string) as produced in total from 10 ice machines and X human packers
(2) Any batch may contain a mixture of packaging weights somehow visually separatable / countable into grades / varieties denoted by 7, A, T, C, B (whatever these mean is unknown).
(3) A counting of the total packed bags generated per time interval for each weight variety is carried out when packing is temporarily stopped.
I hv filled in a possible set of data with some adjusted table formats based on above + some guesses.
test1 - Production Worksheet.doc 62KB
178 downloads
For example, hv assumed a short, 1step shift of varying times per machine.
I assume the output from each ice machine is separated to one group of packers so count/machine is controllable.
I assume the quantity entered in each cell of the “Quantity” column is the amount produced in time interval since previous packing stop. So total production is obtained by totalling all the individual values in Q column.
As per my understanding, there is no required calculation to show the amount packed from each machine ?
Errors will probably indicate my lack of understanding the operation.
I’m sure there will be errors. 
Re - My “general comments” .
2nd one is illustrated by my test-example format changes.
1st one relates to yr lower table, eg how often are samples taken for inspection of the seal ?
Rgds / Charles.C