W/O 10 UPL 330


Product Pass 1 Pass 2 Pass 3 Pass 4 Total W/O's
10 10 10 10 10 4
20 10 10 10 10 4
30 10 10 10 10 4
40 10 10 10 10 4
50 10 10 10 10 4
60 10 10 10 10 4
70 10 1
80 10 10 10 10 4
90 10 10 2
100 10 10 10 10 4
100 90 80 80


Hi all
I need some help with a spreadsheet.
I have data arranged in columns that will typically be values of ten. Based
on some other criteria the cell will or will not contain the value ten after
successive passes. What I want to do is tally up to a predetermined value
(UPL) and have an operator tell at a glance (maybe colored cells or
something) where to stop. So in the example included, the operator would
pull all work orders for the first three columns since the total is 260. I
would like to have a visual indicator that tell them to then work down the
Pass 4 column until 330 is reached €“ in this case the final three units of
ten would not need to be pulled.
The next day it may be all of the first three columns and the first three of
the fourth column. Any ideas for a quick fix on this?