Spreadsheet: 66192d1266889964-hlookup-and-multi-culumn-data-retrieval-test-sheet
Sheet: Main Log

Form 10 |  | Form10 |  |  |  |  | Store: | 1 | Week Ending: |  |  | 2010-01-07 00:00:00 |  | Week# | 1
Sm Store V3.5
Dept | Whse | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-06 00:00:00 |  | 2010-01-07 00:00:00 |  | Total
301 | CPS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 14373 |  |  |  |  |  |  |  | Dept # | Firms | Firms $ | Retail Cost
dep1 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 2232 |  |  |  |  |  | 2276 |  | 301 |  | 3547 | 13478
 | 7 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  |  |  |  | 302 |  | 5672 | 21317
 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  |  |  |  |  |  | 60 |  | 303 |  | 241 | 3625
 | 29 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  |  |  |  |  | 305 |  | 157 | 525
 |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  |  |  |  |  |  | 76 |  | 307 |  | 325 | 325
 | 35 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 238184 |  | 238663 |  | 239239 |  |  |  | 308 |  | 1011 | 21675
 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 2584 |  | 1497 |  | 2840 |  | 7013 |  | 311 |  | 273 | 4636
 | 37 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  |  |  |  |  |  |  | 312 |  | 1464 | 20613
 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  |  |  |  |  | 108 |  | 313 |  | 848 | 4867
 | 39 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 159233 |  |  |  | 159802 |  |  |  | 314 |  | 197 | 17643
 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 101 |  |  |  | 17 |  | 242 |  | 317 |  | 3071 | 23508
 | Firms | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  |  | 238398 |  |  |  |  |  | 318 |  | 595 | 1355
 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  |  | 3407 |  |  |  | 3547 |  | 322 |  | 433 | 5924
 | Extra | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  |  |  |  |  |  |  |  | 323 |  | 1414 | 9739
 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  |  |  |  |  |  | 156 |  | 324 |  | 221 | 981
302 | CPS | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 14373 | 878627 |  |  |  |  |  |  | 325 |  | 237 | 9308
dept2 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 2964 | 48 |  |  |  |  | 3184 |  | 327 |  | 478 | 2595
 | 29 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  |  |  |  |  |  |  |  | 335 |  | 3198 | 13851
 |  | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  |  |  |  |  |  | 188 |  | 338 |  | 782 | 4161
 | 35 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 238184 |  | 238663 |  | 239239 |  |  |  |  |  |  | 321
 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 4790 |  | 2675 |  | 4132 |  | 11801 |  |  | Grand Totals: | 24164 | 180447
 | 37 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  |  |  |  |  | 220
 | Firms | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 14035 |  | 238398 | 238397
 |  | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 37 |  | 5351 | 48 |  |  | 5672
 | Extra | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34
 |  | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 |  |  |  |  |  |  | 252
313 | CPS | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
dept3 |  | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 |  |  |  |  |  |  | 268
 | 7 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38
 |  | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 |  |  |  |  |  |  | 284
 | 29 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 |  | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 |  |  |  |  |  |  | 300
 | 35 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 238184 |  | 238663 | 238397 | 239239
 |  | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 761 |  | 871 | 29 | 842 |  | 2819
 | Firms | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 237864 |  |  |  | 239981
 |  | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 14 |  |  |  | 502 |  | 848
 | Extra | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46
 |  | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 |  |  |  |  |  |  | 348
318 | 37 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
dep4 |  | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 |  |  |  |  |  |  | 364
 | Firms | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 35586
 |  | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 215 |  |  |  |  |  | 595
 | Extra | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 |  | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 |  |  |  |  |  |  | 396
327 | 35 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 238184 |  | 238663 |  | 239239
dept5 |  | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 745 |  | 152 |  | 341 |  | 1650
 | Firms | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 237864
 |  | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 50 |  |  |  |  |  | 478
 | Extra | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 14373
 |  | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 23 |  |  |  |  |  | 467
335 | 35 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 238184 |  | 238663 |  | 239239
dept6 |  | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 2889 |  | 2648 |  | 3582 |  | 9579
 | 39 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 |  |  |  |  | 159802
 |  | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 |  |  |  |  | 90 |  | 566
 | Firms | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 237864 |  | 238398 | 238397 | 239981
 |  | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 723 |  | 1926 | 16 | 41 |  | 3198
 | Extra | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66
 |  | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 |  |  |  |  |  |  | 508
338 | CPS | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 14373
[NAME] |  | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 445 |  |  |  |  |  | 969
 | 35 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 238184 |  | 238663 |  | 239239
 |  | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 747 |  | 191 |  | 360 |  | 1838
 | Firms | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 |  |  | 238398
 |  | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 |  |  | 226 |  |  |  | 782
 | Extra | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74
 |  | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 |  |  |  |  |  |  | 572
Form 10 |  | Daily Warehouse Record Log |  |  |  |  | Store: | 1 | Week Ending: |  |  | 2010-01-07 00:00:00 |  | Week# | 1
Dept | Whse | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  | 2010-01-01 00:00:00 |  | 2010-01-02 00:00:00 |  | 2010-01-03 00:00:00 |  | 2010-01-04 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-06 00:00:00 |  | 2010-01-07 00:00:00 |  | Total
303 | 29 | 69 | 70 |  |  | 760624 |  |  |  | 761171 |  |  |  | 761719
dept8 |  | 70 | 71 |  |  | 2070 |  |  |  | 596 |  |  |  | 428 |  | 3235
 | Firms | 71 | 72 |  |  | 760472
 |  | 72 | 73 |  |  | 96 |  |  |  |  |  |  |  |  |  | 241
 | Extra | 73 | 74
 |  | 74 | 75 |  |  |  |  |  |  |  |  |  |  |  |  | 149
305 | 29 | 75 | 76 |  |  | 760624
dept9 |  | 76 | 77 |  |  | 54 |  |  |  |  |  |  |  |  |  | 207
 | Firms | 77 | 78
 |  | 78 | 79 |  |  |  |  |  |  |  |  |  |  |  |  | 157
 | Extra | 79 | 80
 |  | 80 | 81 |  |  |  |  |  |  |  |  |  |  |  |  | 161
308 | 29 | 81 | 82 |  |  | 760624 |  |  |  | 761171 | 760901 |  |  | 761719
dept10 |  | 82 | 83 |  |  | 10128 |  |  |  | 3814 | 276 |  |  | 6108 |  | 20491
 | Firms | 83 | 84 |  |  | 760473 | 760472 |  |  | 760963 | 760962 |  |  | 761552
 |  | 84 | 85 |  |  | 42 | 24 |  |  | 36 | 693 |  |  | 47 |  | 1011
 | Extra | 85 | 86
 |  | 86 | 87 |  |  |  |  |  |  |  |  |  |  |  |  | 173
314 | 7 | 87 | 88 |  |  | 26540 |  | 28996 |  |  |  |  |  | 30420
dept11 |  | 88 | 89 |  |  | 2456 |  | 2835 |  |  |  |  |  | 2216 |  | 7684
 | 34 | 89 | 90 | 656142 |  | 656509 |  | 656817 |  | 657197 |  |  |  | 657791
 |  | 90 | 91 | 169 |  | 72 |  | 124 |  | 60 |  |  |  | 39 |  | 645
 | 44 | 91 | 92 | 459486 |  | 459790 |  | 460236 |  | 460723 |  | 461148 |  | 461468
 |  | 92 | 93 | 1945 |  | 1669 |  | 1362 |  | 1347 |  | 1175 |  | 1241 |  | 8924
 | Firms | 93 | 94 |  |  |  |  | 459938
 |  | 94 | 95 |  |  |  |  | 8 |  |  |  |  |  |  |  | 197
 | Extra | 95 | 96
 |  | 96 | 97 |  |  |  |  |  |  |  |  |  |  |  |  | 193
323 | 7 | 97 | 98 |  |  | 26540 |  | 28996 |  |  |  |  |  | 30420
[NAME] |  | 98 | 99 |  |  | 48 |  | 84 |  |  |  |  |  | 292 |  | 621
 | 34 | 99 | 100 | 656142 |  | 656509 |  | 656817 |  | 657197 |  | 657569 |  | 657791
 |  | 100 | 101 | 1398 |  | 1125 |  | 690 |  | 1040 |  | 1347 |  | 1485 |  | 7286
 | 44 | 101 | 102
 |  | 102 | 103 |  |  |  |  |  |  |  |  |  |  |  |  | 205
 | Firms | 103 | 104 |  |  | 656295
 |  | 104 | 105 |  |  | 1205 |  |  |  |  |  |  |  |  |  | 1414
 | Extra | 105 | 106
 |  | 106 | 107 |  |  |  |  |  |  |  |  |  |  |  |  | 213
324 | 34 | 107 | 108 |  |  | 656509 |  | 656817 |  | 657197 |  | 657569 |  | 657791
dept13 |  | 108 | 109 |  |  | 42 |  | 48 |  | 108 |  | 60 |  | 60 |  | 535
 | Firms | 109 | 110
 |  | 110 | 111 |  |  |  |  |  |  |  |  |  |  |  |  | 221
 | Extra | 111 | 112
 |  | 112 | 113 |  |  |  |  |  |  |  |  |  |  |  |  | 225
325 | 34 | 113 | 114 | 656142 |  | 656509 |  | 656817 |  | 657197 |  | 657569 |  | 657791
dept14 |  | 114 | 115 | 1101 |  | 1767 |  | 640 |  | 1451 |  | 1939 |  | 1374 |  | 8501
 | 35 | 115 | 116 |  |  | 237038 |  | 237617
 |  | 116 | 117 |  |  | 48 |  | 48 |  |  |  |  |  |  |  | 329
 | Firms | 117 | 118
 |  | 118 | 119 |  |  |  |  |  |  |  |  |  |  |  |  | 237
 | Extra | 119 | 120
 |  | 120 | 121 |  |  |  |  |  |  |  |  |  |  |  |  | 241
317 | 32 | 121 | 122 | 7590 |  |  |  | 8082 |  |  |  | 8473
dept15 |  | 122 | 123 | 107 |  |  |  | 172 |  |  |  | 101 |  |  |  | 625
 | 33 | 123 | 124 | 153887 |  |  |  | 154469 |  |  |  | 155078
 |  | 124 | 125 | 5369 |  |  |  | 6904 |  |  |  | 7033 |  |  |  | 19555
 | Firms | 125 | 126 | 153659 | 153658 |  |  |  |  |  |  | 154873
 |  | 126 | 127 | 56 | 2647 |  |  |  |  |  |  | 115 |  |  |  | 3071
 | Extra | 127 | 128
 |  | 128 | 129 |  |  |  |  |  |  |  |  |  |  |  |  | 257
Form 10 |  | Daily Warehouse Record Log |  |  |  |  | Store: | 1 | Week Ending: |  |  | 2010-01-07 00:00:00 |  | Week# | 1
Dept | Whse | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  | 2010-01-01 00:00:00 |  | 2010-01-02 00:00:00 |  | 2010-01-03 00:00:00 |  | 2010-01-04 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-06 00:00:00 |  | 2010-01-07 00:00:00 |  | Total
311 | CPS | 129 | 130
dept16 |  | 130 | 131 |  |  |  |  |  |  |  |  |  |  |  |  | 261
 | 37 | 131 | 132
 |  | 132 | 133 |  |  |  |  |  |  |  |  |  |  |  |  | 265
 | 39 | 133 | 134 |  |  | 158685 |  |  |  | 159233 |  |  |  | 159802 | si9-802
 |  | 134 | 135 |  |  | 649 |  |  |  | 1666 |  |  |  | 1117 | -141 | 3560
 | Firms | 135 | 136
 |  | 136 | 137 |  |  |  |  |  |  |  |  |  |  |  |  | 273
 | Extra | 137 | 138
 |  | 138 | 139 |  |  |  |  |  |  |  |  |  |  |  |  | 277
312 | CPS | 139 | 140 |  |  |  |  |  |  | 878627
dept17 |  | 140 | 141 |  |  |  |  |  |  | 1935 |  |  |  |  |  | 2216
 | 35 | 141 | 142 | 236485 |  | 237038 |  |  |  | 238184 |  | 238663 |  | 239239
 |  | 142 | 143 | 168 |  | 164 |  |  |  | 136 |  | 236 |  | 326 |  | 1315
 | 37 | 143 | 144 |  |  | 35228 |  |  |  | 35825
 |  | 144 | 145 |  |  | 459 |  |  |  | 23 |  |  |  |  |  | 771
 | 39 | 145 | 146 |  |  | 158685 |  |  |  | 159233 |  |  |  | 159802
 |  | 146 | 147 |  |  | 4853 |  |  |  | 4104 |  |  |  | 5296 |  | 14546
 | Firms | 147 | 148 |  | 35003 | 158477 | 158476 |  |  | 159016 |  |  |  | 159642
 |  | 148 | 149 |  | 122 | 82 | 525 |  |  | 252 |  |  |  | 186 |  | 1464
 | Extra | 149 | 150
 |  | 150 | 151 |  |  |  |  |  |  |  |  |  |  |  |  | 301
322 | 39 | 151 | 152 |  |  | 158685 |  |  |  | 159233 |  |  |  | 159802
dept18 |  | 152 | 153 |  |  | 1614 |  |  |  | 894 |  |  |  | 2019 |  | 4832
 | 38 | 153 | 154
 |  | 154 | 155 |  |  |  |  |  |  |  |  |  |  |  |  | 309
 | Firms | 155 | 156 |  |  | 158476
 |  | 156 | 157 |  |  | 120 |  |  |  |  |  |  |  |  |  | 433
 | Extra | 157 | 158 | 236485
 |  | 158 | 159 | 33 |  |  |  |  |  |  |  |  |  |  |  | 350
 |  | 159 | 160
 |  | 160 | 161 |  |  |  |  |  |  |  |  |  |  |  |  | 321
307 | tob | 161 | 162
 |  | 162 | 163 |  |  |  |  |  |  |  |  |  |  |  |  | 325