Using imbeded worksheet to calculate H dif. and L dif. for testing up to 10
units. in this example the 2nd, 3rd and 5th units fail because H dif. is
grater than 3. Max L dif. is 1. Is there some way for Excel to determine the
failed units and indicate them? (In order to paste a sample, I had to hide
most of the columns)
Date 05/28/03 #1
Safety Tach Production V2.1
Prep: Up to 10 units tested on elevator floor. Includes 1st run. 10 units
tested. 60 Second warm up time.
# 503-19 P00001
up HI LV HI LV H dif. L dif.
1 164 9 168 10 4 1
2 165 9 167 10 3 1
3 166 9 168 10 4 1
4 165 9 167 10 4 1
5 164 9 167 10 4 1
2 0 1 0
2 0 2 1

--
Thanks,
Kirk