Spreadsheet: 63806d1264679421-vlookup-problem-getting-error-results-admin-0127
Sheet: (4) SPECIALITY OEE

 |  |  |  |  | SPECIALITY PRODUCTION
 |  | PRODUCTION DAY: |  | WEDNESDAY | 2010-01-27 00:00:00 |  | SALES DAY: |  | 2010-01-28 00:00:00 | 05
 |  |  |  | START | FINISH
 |  |  |  | 06:28:00 | 14:55:00
 | MIX CODE | PRODUCT | DOUGH CODE | START | FINISH | MIXES MADE | FLOUR USAGE | B/MILK USAGE | SINGLES PRODUCED | WASTE (21) | TARGET YIELD | ACTUAL YIELD
 |  |  | CODE | TIME | TIME
 | 3 | M&S COB | 8272 | 06:28:00 | 07:47:00 | 13 | 715 | 754 | 3260 |  | 263.1504166666666 | 250
 | 6 | ORMO COB | 8299
 | 83 | FARMHOUSE WHEATEN | 8269 | 07:47:00 | 08:19:00 | 5 | 305 | 300 | 1233.333333333333 |  | 272.195 | 246
 | 2 | M&S WHISKEY FRUIT LOAF | 8282 | 09:03:00 | 09:08:00 | 1 | 51 | 0 | 330 |  | 398.4026666666667 | 330
 | 4 | M&S SQ WHEATEN | 8277 | 09:10:00 | 09:58:00 | 7 | 112 | 392 | 2068 |  | 326.3808333333333 | 295
 | 83 | FARMHOUSE WHEATEN | 8269 | 10:01:00 | 10:32:00 | 4 | 244 | 240 | 986.6666666666666 |  | 272.195 | 246
 | 44 | ORMO WHOLEMEAL | 8268 | 10:32:00 | 11:42:00 | 6 | 96 | 360 | 1668 |  | 284.5327916666666 | 278
 | 6 | ORMO COB | 8299 | 11:46:00 | 12:21:00 | 6 | 330 | 348 | 1296 |  | 261.7825 | 216
 | 11 | MP SQ WHEATEN | 8221 | 12:24:00 | 14:29:00 | 15 | 915 | 900 | 3840 |  | 272.195 | 256
 | 13 | ORMO BARMBRACK | 8234 | 14:31:00 | 14:36:00 | 1 | 29 | 0 | 72 |  | 138.9809615384615 | 72
 | 50 | ORMO VEDA | 1163 | 14:38:00 | 14:55:00 | 3 | 90 | 0 | 468 |  | 177.8291666666667 | 156
 | 99 | FLOUR DROP | - |  |  | 11 | 990
 |  |  |  |  |  |  | FLOUR | B/MILK
 |  |  |  |  |  |  | 3877 | 3294
 |  |  |  | Total Mixes: |  | 61 |  |  | 15222 | 0
 |  |  |  |  |  |  |  |  | 15222
 |  | lost time: | 8:25 - 8:50
 |  |  | 11:00 - 11:30
 |  |  | 13:30 - 14:00
 | MIX |  | DOUGH | MIX WEIGHT (kg) | UNIT WEIGHT (g) | MIXES MADE | MIXES CONSUMED | MIX WASTE (kg) | UNIT WASTE |  | FLOUR | BUTTERMILK | YIELD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COPY S21 REPORT HERE
 | 2 | M&S WHISKEY FRUIT LOAF | 8282 | 182.94 | 450 |  |  |  |  |  | 51 | 0 | 398.4026666666667
 | 3 | M&S COB | 8272 | 128.89 | 480 |  |  |  |  |  | 55 | 58 | 263.1504166666666
 | 4 | M&S SQ WHEATEN | 8277 | 159.86 | 480 |  |  |  |  |  | 16 | 56 | 326.3808333333333
 | 5 | M&S SULTANA SODA | 8276 | 132.69 | 480 |  |  |  |  |  | 54 | 51 | 270.90875
 | 6 | ORMO COB | 8299 | 128.22 | 480 |  |  |  |  |  | 55 | 58 | 261.7825
 | 10 | SAMPLE | - |  |  |  |  |  |  |  | 8 | 29 | -
 | 11 | MP SQ WHEATEN | 8221 | 133.32 | 480 |  |  |  |  |  | 61 | 60 | 272.195
 | 12 | M&S BARMBRACK | 7311 | 113.22 | 520 |  |  |  |  |  | 33 | 0 | 213.3761538461538
 | 13 | ORMO BARMBRACK | 8234 | 73.745 | 520 |  |  |  |  |  | 29 | 0 | 138.9809615384615
 | 14 | ORMO FRUIT LOAF | 8284 | 144.51 | 500 |  |  |  |  |  | 45 | 0 | 283.2396
 | 84 | FRUIT LOAF | 8232 | 144.51 | 500 |  |  |  |  |  | 45 | 0 | 283.2396
 | 44 | ORMO WHOLEMEAL | 8268 | 139.363 | 480 |  |  |  |  |  | 16 | 60 | 284.5327916666666
 | 50 | ORMO VEDA | 1163 | 87.1 | 480 |  |  |  |  |  | 30 | 0 | 177.8291666666667
 | 83 | FARMHOUSE WHEATEN | 8269 | 133.32 | 480 |  |  |  |  |  | 61 | 60 | 272.195
 | 99 | FLOUR DROP | - |  |  |  |  |  |  |  | 90
 | Sunday |  | 02
 | Monday |  | 03
 | Tuesday |  | 04
 | Wednesday |  | 05
 | Thursday |  | 06
 | Friday |  | 07
 | Saturday |  | 01