Spreadsheet: 86659d1286583779-excel-2008-color-of-the-selecting-box-copy-of-test-pages
Sheet: cond for'ing & if(iserror

 |  |  |  |  |  |  | check for double ups in both |  |  |  | 2 | 2
 |  |  |  | 3 |  |  | first column and second column |  |  |  | 3
 |  |  | check for double up's in a column | 3
 |  |  |  | 4 |  |  |  |  |  |  | 3
 |  |  |  | 2 |  |  |  |  |  |  | INPUT | ANSWER
 |  |  |  | 2 |  |  |  |  |  |  | 7 | J
 |  |  |  | 3 |  |  |  |  |  |  |  | RTY
 |  |  |  |  |  | 3 | R | Y | RYU |  |  | RU
 |  |  |  |  |  | 4 | F | J | YU |  |  | 7
 |  |  |  | 0 |  | 5 | T | KJ | YHU |  |  | J
 |  |  |  |  |  | 6 | G | DY | YTJHUE |  |  | J
 |  |  |  |  |  | 4 | H | [NAME] | YUE |  |  | J
 |  |  |  |  |  | 7 | J | RTY | RU |  |  | J
Reference Cell | 998
 |  |  |  | OEM Pres | Xref | Xref | Xref | Xref | Xref |  | Cost
To first column | #N/A | #N/A |  | 312 | 313 | 314 | 315 | 316 | 317 |  | 45
 |  |  |  | 654 | 655 | 666 | 667 | 668 | 669 |  | 56
To second column | #N/A | #N/A |  | 756 | 757 | 758 | 759 | 760 | 761 |  | 72
 |  |  |  | 222 | 223 | 224 | 225 | 226 | 227 |  | 36
To third column | #N/A | #N/A |  | 333 | 334 | 335 | 336 | 337 | 338 |  | 71
 |  |  |  | 444 | 445 | 446 | 447 | 448 | 449 |  | 99
To fourth Column | #N/A | #N/A |  | 111 | 112 | 113 | 114 | 115 | 116 |  | 78
 |  |  |  | 994 | 995 | 996 | 997 | 998 | 999 |  | 97
 | 97 | 97
 |  |  |  | Pay | 100008
 | del |  |  | Single y/n | y
 |  |  |  |  | 1 | 0
 | check for del in g22 |  |  | Check for y in f30 and above 50000
 |  |  |  | Check for n in f30 and above 100000
Machine | Drifter | Date | Hours
 | Fitted | Fitted | Fitted
 |  |  | 1750 | 1950 | 1970 | 1990 | 2010 | 2030 | 2050 | 2070 | 2090 | 2110 | 2130 | 2150 | 2170 | 2190 | 2210 | 2230 | 2250 | 2270 | 2290 | 2310 | 2330 | 2350 | 2370 | 2390 | 2410 | 2430 | 2450 | 2470 | 2490 | 2510 | 2530 | 2550 | 2570 | 2590 | 2610 | 2630 | 2650 | 2670
 |  |  |  | If cost is ")" or has been left blank then highlight green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Approx | Based on | 1 | Mtr/Min
Who | Quote | Purch | Model | DRILL | DRIFTER | FITTED |  | REMOVED |  | Hrs | Days | % | Hrs | Days | % | /24HR | Wk | Av | Total | Cost | Mtrs | $/Hr | $/Mtr
 |  |  |  | UD02 | UR05 | 3458 | 2007-09-14 00:00:00 | 3512 | 2007-10-05 00:00:00 | 54 | 21 | 0.108 | 446 | 146 | 0.892 | 2.571428571428572 | 18 | 3 | 167 | 10943.49 | 3240 | 202.6572222222222 | 3.37762037037037
 |  |  |  | UD12-R | UR20 | 1103 | 2007-07-17 00:00:00 | 1256 | 2007-10-15 00:00:00 | 153 | 90 | 0.306 | 347 | 35 | 0.694 | 1.7 | 11.9 | 4 | 125 | 8469 | 9180 | 55.35294117647059 | 0.9225490196078432
 | 60442 |  |  | UD09-R | UR16 | 0 | 2007-09-05 00:00:00 | 98 | 2007-10-24 00:00:00 | 122 | 49 | 0.196 | 402 | 76 | 0.804 | 2.5 | 17.5 | 4 | 125 | 10857.06 | 7320 | 88.99229508196721 | 1.483204918032787
 | 915578 |  |  | UD11 | UR30 | 1093 | 2007-08-15 00:00:00 | 1351 | 2007-10-24 00:00:00 | 258 | 70 | 0.516 | 242 | 30 | 0.484 | 3.685714285714285 | 25.8 | 5 | 100 | 30062.05 | 15480 | 116.5195736434109 | 1.941992894056848
 |  |  |  | UD12-R | UR06 | 1256 | 2007-10-15 00:00:00 | 1275 | 2007-10-26 00:00:00 | 19 | 11 | 0.038 | 481 | 114 | 0.962 | 1.727272727272727 | 12.09090909090909 | 4 | 125 | 0 | 1140 | 0 | Warranty
 |  |  |  | UD09-L | UR19 | 0 | 2007-07-25 00:00:00 | 58 | 2007-10-30 00:00:00 | 339 | 97 | 0.116 | 442 | 28 | 0.884 | 3.5 | 24.5 | 4 | 125 | 15421.95 | 20340 | 45.4924778761062 | 0.75820796460177
 |  |  |  | UD02 | UR04 | 3512 | 2007-10-05 00:00:00 | 3609 | 2007-11-16 00:00:00 | 97 | 42 | 0.194 | 403 | 154.6666666666667 | 0.806 | 2.309523809523809 | 16.16666666666666 | 3 | 166.6666666666667 | 5053.36 | 5820 | 52.09649484536082 | 0.868274914089347
 | 917767 |  |  | UD11 | UR31 | 1351 | 2007-10-24 00:00:00 | 1447 | 2007-11-27 00:00:00 | 96 | 34 | 0.192 | 404 | 108.8571428571429 | 0.808 | 2.823529411764706 | 19.76470588235294 | 3.5 | 142.8571428571429 | 38188.84 | 5760 | 397.8004166666666 | 6.630006944444444
[NAME] |  |  |  | UD08-L | AVO 04D 819C | 8 | 2007-09-26 00:00:00 | 115 | 2007-12-05 00:00:00 | 245 | 70 | #N/A | -245 | -7 | #N/A | 3.5 | 24.5 | 3.5 | 0 | 30501.1 | 14700 | 124.4942857142857 | 2.074904761904762
[NAME] |  |  |  | UD11 | UR30 | 1447 | 2007-11-27 00:00:00 | 1531 | 2008-01-04 00:00:00 | 84 | 38 | #N/A | -84 | -38 | #N/A | 2.210526315789474 | 15.47368421052632 | 2.5 | 0 | 0 | 5040 | 0 | Warranty
RDS | 60815 |  |  | UD14-L | F 035 361 | 16692 | 2007-12-03 00:00:00 | 16762 | 2008-01-10 00:00:00 | 70 | 39 | 0.14 | 430 | 127.6666666666667 | 0.86 | 1.794871794871795 | 12.56410256410256 | 3 | 166.6666666666667 | 15288 | 4200 | 218.4 | 3.64
RDS | 60819 |  |  | UD08-L | UR16 | 115 | 2007-12-05 00:00:00 | 217 | 2008-01-12 00:00:00 | 102 | 38 | #N/A | -102 | -7 | #N/A | 2.684210526315789 | 18.78947368421053 | 3 | 0 | 8455.69 | 6120 | 82.89892156862746 | 1.381648692810458
RDS | 60869 |  |  | UD14-R | F 035 360 | 10633 | 2007-12-03 00:00:00 | 10686 | 2008-01-18 00:00:00 | 53 | 46 | #N/A | -53 | -46 | #N/A | 1.152173913043478 | 8.065217391304348 | 2.5 | 0 | 26850.76 | 3180 | 506.6181132075471 | 8.443635220125786
[NAME] | 921532 |  |  | UD12-R | UR03 | 1275 | 2007-10-26 00:00:00 | 1456 | 2008-01-29 00:00:00 | 181 | 95 | #N/A | -181 | -95 | #N/A | 1.905263157894737 | 13.33684210526316 | 2 | 0 | 6955.3 | 10860 | 38.42707182320442 | 0.640451197053407
RDS | 61160 | 2201399 |  | UD02 | UR05 | 3609 | 2007-11-16 00:00:00 | 3794 | 2008-03-01 00:00:00 | 185 | 106 | 0.37 | 315 | 144 | 0.63 | 1.745283018867924 | 12.21698113207547 | 2 | 250 | 10670.85 | 11100 | 57.68027027027027 | 0.9613378378378379
RDS | 61319 | 2203046 |  | UD12-L | UR18 | 1633 | 2007-09-07 00:00:00 | 2267 | 2008-03-29 00:00:00 | 634 | 204 | 1.268 | -134 | -37.33333333333334 | -0.268 | 3.107843137254902 | 21.75490196078431 | 3 | 166.6666666666667 | 12714.24 | 38040 | 20.05400630914826 | 0.3342334384858044
RDS | 61323 |  |  | UD14-L | F 035 415 | 16762 | 2008-01-10 00:00:00 | 17050 | 2008-03-28 00:00:00 | 288 | 78 | 0.576 | 212 | 88.66666666666666 | 0.424 | 3.692307692307693 | 25.84615384615385 | 3 | 166.6666666666667 | 19103.6 | 17280 | 66.33194444444445 | 1.105532407407407
 | 61433 |  |  | UD02 | UR04 | 3794 | 2008-03-01 00:00:00 | 3914 | 2008-04-24 00:00:00 | 120 | 54 | 0.24 | 380 | 196 | 0.76 | 2.222222222222222 | 15.55555555555556 | 2 | 250 | 11742.76 | 7200 | 97.85633333333334 | 1.630938888888889
 | 61431 |  |  | UD12-R | UR06 | 1456 | 2008-01-29 00:00:00 | 1630 | 2008-04-21 00:00:00 | 174 | 83 | 0.348 | 326 | 167 | 0.652 | 2.096385542168675 | 14.67469879518072 | 2 | 250 | 6262.92 | 10440 | 35.99379310344828 | 0.5998965517241379
 | 61411 |  |  | UD08-R | UR17 | 8 | 2007-09-13 00:00:00 | 433 | 2008-05-20 00:00:00 | 425 | 250 | 0.85 | 75 | 0 | 0.15 | 1.7 | 11.9 | 2 | 250 | 6421.96 | 25500 | 15.11049411764706 | 0.251841568627451
 |  |  |  | UD02 | UR05 | 3914 | 2008-04-24 00:00:00 | 3964 | 2008-05-27 00:00:00 | 50 | 33 | 0.1 | 450 | 217 | 0.9 | 1.515151515151515 | 10.60606060606061 | 2 | 250 | 17959.65 | 3000 | 359.193 | 5.98655
 |  |  |  | UD11 | UR31 | 1531 | 2008-01-09 00:00:00 | 2032 | 2008-05-30 00:00:00 | 501 | 142 | 1.002 | -1 | 58 | -0.002 | 3.528169014084507 | 24.69718309859155 | 2.5 | 200 |  | 30060 |  | 0
 | 61685 |  |  | UD08-R | UR07 | 433 | 2008-05-20 00:00:00 | 472 | 2008-05-31 00:00:00 | 39 | 11 | 0.078 | 461 | 239 | 0.922 | 3.545454545454545 | 24.81818181818182 | 2 | 250 | 3918.65 | 2340 | 100.4782051282051 | 1.674636752136752
 | 61786 | 2206571 |  | UD08-L | UR20 | 217 | 2008-01-12 00:00:00 | 625 | 2008-06-06 00:00:00 | 408 | 146 | 0.816 | 92 | 20.66666666666666 | 0.184 | 2.794520547945206 | 19.56164383561644 | 3 | 166.6666666666667 | 20306.98 | 24480 | 49.77200980392157 | 0.8295334967320261
 |  |  |  | UD09-L | UR29 | 11 | 2008-04-30 00:00:00 | 117 | 2008-06-21 00:00:00 | 106 | 52 | 0.212 | 394 | 114.6666666666667 | 0.788 | 2.038461538461538 | 14.26923076923077 | 3 | 166.6666666666667 |  | 6360 |  | 0
 | 86328 |  |  | UD09-R | UR27 | 19 | 2008-04-30 00:00:00 | 135 | 2008-07-04 00:00:00 | 116 | 65 | 0.232 | 384 | 185 | 0.768 | 1.784615384615385 | 12.49230769230769 | 2 | 250 | 11550.69 | 6960 | 99.57491379310345 | 1.659581896551724