Spreadsheet: 94966d1294696347-index-match-to-retreive-value-based-on-multiple-criteria-copy-of-2test
Sheet: KP

Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours Worked | #
2011-01-01 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-01 00:00:00 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours Worked | #
2011-01-02 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-02 00:00:00 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours | #
2011-01-03 00:00:00 | 1 | 3639.857142857143 | 727.9714285714285 | 25.42857142857143 | 35 | 0 | 7 | 0 |  | 178 | 25479 | 7 | 5
2011-01-03 00:00:00 | 2 | 3961.571428571428 | 792.3142857142857 | 27.42857142857143 | 35 | 0 | 7 | 0 |  | 192 | 27731 | 7 | 5
2011-01-03 00:00:00 | 3 | 3740.714285714286 | 748.1428571428571 | 26.14285714285714 | 35 | 0 | 7 | 2 |  | 183 | 26185 | 7 | 5
2011-01-03 00:00:00 | 4 | 4556 | 911.2 | 31.5 | 40 | 0 | 8 | 0 | 2 | 252 | 36448 | 8 | 5
2011-01-03 00:00:00 | 5 | 4230.857142857143 | 846.1714285714286 | 42 | 35 | 0 | 7 | 1 | 1 | 294 | 29616 | 7 | 5
2011-01-03 00:00:00 | 6 | 3384 | 676.8 | 32.57142857142857 | 35 | 0 | 7 | 2 |  | 228 | 23688 | 7 | 5
2011-01-03 00:00:00 | 7 | 4124.142857142857 | 824.8285714285714 | 41 | 35 | 0 | 7 | 0 |  | 287 | 28869 | 7 | 5
2011-01-03 00:00:00 | 8 | 3735.571428571428 | 747.1142857142856 | 35.71428571428572 | 35 | 0 | 7 | 1 |  | 250 | 26149 | 7 | 5
2011-01-03 00:00:00 | 9 | 3380.857142857143 | 676.1714285714286 | 34 | 35 | 0 | 7 | 2 |  | 238 | 23666 | 7 | 5
2011-01-03 00:00:00 | 10 | 3659.714285714286 | 731.9428571428572 | 37.14285714285715 | 35 | 0 | 7 | 0 |  | 260 | 25618 | 7 | 5
2011-01-03 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-03 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-03 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-03 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-03 00:00:00 | 15 | 503 | 503 | 27.8 | 5 | 0 | 5 | 0 |  | 139 | 2515 | 5 | 1
2011-01-03 00:00:00 | 16 | 2790.428571428572 | 697.6071428571429 | 24.42857142857143 | 28 | 0 | 7 | 2 |  | 171 | 19533 | 7 | 4
2011-01-03 00:00:00 | 17 | 3858.428571428572 | 771.6857142857143 | 27.28571428571428 | 35 | 0 | 7 | 0 |  | 191 | 27009 | 7 | 5
2011-01-03 00:00:00 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours | #
2011-01-04 00:00:00 | 1 | 3734.428571428572 | 746.8857142857144 | 25.57142857142857 | 35 | 0 | 7 | 0 |  | 179 | 26141 | 7 | 5
2011-01-04 00:00:00 | 2 | 4313.142857142857 | 862.6285714285714 | 29.28571428571428 | 35 | 0 | 7 | 0 | 1 | 205 | 30192 | 7 | 5
2011-01-04 00:00:00 | 3 | 3869.51724137931 | 773.903448275862 | 35.03448275862069 | 36.25 | 0 | 7.25 | 0 |  | 254 | 28054 | 7.25 | 5
2011-01-04 00:00:00 | 4 | 4519.466666666666 | 903.8933333333332 | 44.8 | 37.5 | 0 | 7.5 | 0 | 1 | 336 | 33896 | 7.5 | 5
2011-01-04 00:00:00 | 5 | 4245.066666666667 | 849.0133333333333 | 40.8 | 37.5 | 0 | 7.5 | 0 | 1 | 306 | 31838 | 7.5 | 5
2011-01-04 00:00:00 | 6 | 4002.266666666667 | 800.4533333333334 | 38.53333333333333 | 37.5 | 0 | 7.5 | 1 |  | 289 | 30017 | 7.5 | 5
2011-01-04 00:00:00 | 7 | 4461.866666666667 | 892.3733333333333 | 42.53333333333333 | 37.5 | 0 | 7.5 | 1 | 1 | 319 | 33464 | 7.5 | 5
2011-01-04 00:00:00 | 8 | 3965.866666666667 | 793.1733333333334 | 38.8 | 37.5 | 0 | 7.5 | 1 |  | 291 | 29744 | 7.5 | 5
2011-01-04 00:00:00 | 9 | 3746 | 749.2 | 35.83333333333334 | 30 | 0 | 6 | 4 |  | 215 | 22476 | 6 | 5
2011-01-04 00:00:00 | 10 | 3667.571428571428 | 733.5142857142857 | 38.14285714285715 | 35 | 0 | 7 | 0 |  | 267 | 25673 | 7 | 5
2011-01-04 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-04 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-04 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-04 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-04 00:00:00 | 15 | 588.2666666666667 | 588.2666666666667 | 29.73333333333333 | 7.5 | 0 | 7.5 | 0 |  | 223 | 4412 | 7.5 | 1
2011-01-04 00:00:00 | 16 | 2608.533333333333 | 652.1333333333333 | 25.46666666666667 | 30 | 0 | 7.5 | 3 |  | 191 | 19564 | 7.5 | 4
2011-01-04 00:00:00 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-04 00:00:00 | 18 | 3893.6 | 973.4 | 30.8 | 30 | 0 | 7.5 | 0 | 2 | 231 | 29202 | 7.5 | 4
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours | #
2011-01-05 00:00:00 | 1 | 4804.75 | 960.95 | 33 | 20 | 0 | 4 | 0 | 2 | 132 | 19219 | 4 | 5
2011-01-05 00:00:00 | 2 | 5126.75 | 1025.35 | 35 | 20 | 0 | 4 | 0 | 3 | 140 | 20507 | 4 | 5
2011-01-05 00:00:00 | 3 | 4456.75 | 891.35 | 31 | 20 | 0 | 4 | 0 | 1 | 124 | 17827 | 4 | 5
2011-01-05 00:00:00 | 4 | 3938.75 | 787.75 | 37 | 20 | 0 | 4 | 0 |  | 148 | 15755 | 4 | 5
2011-01-05 00:00:00 | 5 | 3922.75 | 784.55 | 35.25 | 20 | 0 | 4 | 0 |  | 141 | 15691 | 4 | 5
2011-01-05 00:00:00 | 6 | 3922.75 | 784.55 | 38 | 20 | 0 | 4 | 0 |  | 152 | 15691 | 4 | 5
2011-01-05 00:00:00 | 7 | 4208.25 | 841.65 | 41 | 20 | 0 | 4 | 0 | 1 | 164 | 16833 | 4 | 5
2011-01-05 00:00:00 | 8 | 4167.5 | 833.5 | 38.25 | 20 | 0 | 4 | 2 | 0 | 153 | 16670 | 4 | 5
2011-01-05 00:00:00 | 9 | 3923.733333333333 | 784.7466666666667 | 36 | 18.75 | 0 | 3.75 | 2 |  | 135 | 14714 | 3.75 | 5
2011-01-05 00:00:00 | 10 | 4034.133333333333 | 806.8266666666666 | 37.86666666666667 | 18.75 | 0 | 3.75 | 1 |  | 142 | 15128 | 3.75 | 5
2011-01-05 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 15 | 650.2857142857143 | 325.1428571428572 | 44.57142857142857 | 7 | 0 | 3.5 | 0 |  | 156 | 2276 | 3.5 | 2
2011-01-05 00:00:00 | 16 | 2280.25 | 570.0625 | 23.75 | 16 | 0 | 4 | 0 |  | 95 | 9121 | 4 | 4
2011-01-05 00:00:00 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 18 | 3686.25 | 921.5625 | 29.75 | 16 | 0 | 4 | 0 | 2 | 119 | 14745 | 4 | 4
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours | #
2011-01-06 00:00:00 | 1 | 3131.466666666667 | 626.2933333333333 | 24.53333333333333 | 18.75 | 0 | 3.75 | 0 |  | 92 | 11743 | 3.75 | 5
2011-01-06 00:00:00 | 2 | 4541.5 | 908.3 | 30.75 | 20 | 0 | 4 | 0 | 1 | 123 | 18166 | 4 | 5
2011-01-06 00:00:00 | 3 | 4542.933333333333 | 908.5866666666667 | 31.46666666666667 | 18.75 | 0 | 3.75 | 0 | 1 | 118 | 17036 | 3.75 | 5
2011-01-06 00:00:00 | 4 | 4043.25 | 808.65 | 35.25 | 20 | 0 | 4 | 0 |  | 141 | 16173 | 4 | 5
2011-01-06 00:00:00 | 5 | 4167.25 | 833.45 | 40.75 | 20 | 0 | 4 | 0 | 1 | 163 | 16669 | 4 | 5
2011-01-06 00:00:00 | 6 | 3705.75 | 741.15 | 37.25 | 20 | 0 | 4 | 1 |  | 149 | 14823 | 4 | 5
2011-01-06 00:00:00 | 7 | 4335.5 | 867.1 | 42.75 | 20 | 0 | 4 | 0 | 1 | 171 | 17342 | 4 | 5
2011-01-06 00:00:00 | 8 | 4066.588235294118 | 813.3176470588235 | 37.64705882352941 | 21.25 | 0 | 4.25 | 1 |  | 160 | 17283 | 4.25 | 5
2011-01-06 00:00:00 | 9 | 3817.866666666667 | 763.5733333333334 | 37.06666666666667 | 18.75 | 0 | 3.75 | 3 |  | 139 | 14317 | 3.75 | 5
2011-01-06 00:00:00 | 10 | 4098 | 819.6 | 40.5 | 20 | 0 | 4 | 1 |  | 162 | 16392 | 4 | 5
2011-01-06 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-06 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-06 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-06 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-06 00:00:00 | 15 | 557.3333333333334 | 557.3333333333334 | 42.4 | 3.75 | 0 | 3.75 | 0 |  | 159 | 2090 | 3.75 | 1
2011-01-06 00:00:00 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-06 00:00:00 | 17 | 3281.428571428572 | 820.3571428571429 | 26.57142857142857 | 14 | 0 | 3.5 | 0 |  | 93 | 11485 | 3.5 | 4
2011-01-06 00:00:00 | 18 | 39104.75 | 9776.1875 | 32.25 | 16 | 0 | 4 | 0 | 3 | 129 | 156419 | 4 | 4
Date | Line # | UPH | UPH/PP | Avg | Total Hours/Line | Down Time | Hours Minus  Down | Errors | Bonus | Orders | Total Units | Hours | #
2011-01-07 00:00:00 | 1 | 5144.526315789474 | 1028.905263157895 | 35.05263157894737 | 17.5 | 0.3333333333333333 | 3.166666666666667 | 0 | 3 | 111 | 16291 | 3.5 | 5
2011-01-07 00:00:00 | 2 | 4479.714285714285 | 895.9428571428571 | 30.28571428571428 | 17.5 | 0 | 3.5 | 0 | 1 | 106 | 15679 | 3.5 | 5
2011-01-07 00:00:00 | 3 | 3714 | 742.8 | 27 | 20 | 0.3333333333333333 | 3.666666666666667 | 0 |  | 99 | 13618 | 4 | 5
2011-01-07 00:00:00 | 4 | 5395.428571428572 | 1079.085714285714 | 36.28571428571428 | 20 | 0.5 | 3.5 | 0 | 3 | 127 | 18884 | 4 | 5
2011-01-07 00:00:00 | 5 | 3900.775862068966 | 780.1551724137931 | 36.98275862068966 | 20 | 0.1333333333333333 | 3.866666666666667 | 1 |  | 143 | 15083 | 4 | 5
2011-01-07 00:00:00 | 6 | 4034.857142857143 | 806.9714285714285 | 38.85714285714285 | 20 | 0.5 | 3.5 | 1 |  | 136 | 14122 | 4 | 5
2011-01-07 00:00:00 | 7 | 3805.04347826087 | 761.0086956521739 | 37.04347826086956 | 20 | 0.1666666666666667 | 3.833333333333333 | 0 |  | 142 | 14586 | 4 | 5
2011-01-07 00:00:00 | 8 | 4015.148936170213 | 803.0297872340426 | 36.51063829787234 | 20 | 0.08333333333333333 | 3.916666666666667 | 1 |  | 143 | 15726 | 4 | 5
2011-01-07 00:00:00 | 9 | 3532.75 | 706.55 | 33.5 | 20 | 0 | 4 | 1 |  | 134 | 14131 | 4 | 5
2011-01-07 00:00:00 | 10 | 3577 | 715.4 | 34.75 | 20 | 0 | 4 | 0 |  | 139 | 14308 | 4 | 5
2011-01-07 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-07 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-07 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-07 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-07 00:00:00 | 15 | 318 | 318 | 29.75 | 4 | 0 | 4 | 0 |  | 119 | 1272 | 4 | 1
2011-01-07 00:00:00 | 16 | 2988.837209302325 | 747.2093023255813 | 32.37209302325581 | 16 | 0.4166666666666667 | 3.583333333333333 | 0 |  | 116 | 10710 | 4 | 4
2011-01-07 00:00:00 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011-01-07 00:00:00 | 18 | 3924 | 981 | 33 | 16 | 0 | 4 | 0 | 2 | 132 | 15696 | 4 | 4