Spreadsheet: 105389d1302761909-extracting-multiple-data-ranges-sample
Sheet: Data Summary

 |  |  |  |  |  |  |  |  |  |  | DATE RANGE
 |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | 2011-04-01 00:00:00
 |  |  |  | TOTAL GALLONS, BATCHING |  |  | TOTAL UNITS, FILLING |  |  | TOTAL LOSS
PRODUCT | PROD DATE | LOT # | EXP DATE | TARGET | BATCH | PROCESS | CASES | [NAME] | GALLONS | GALLONS | PERCENT | TOTAL $
Flavor 1 | 2011-03-28 00:00:00 | ASA11075 | 2011-08-03 00:00:00 | 12000 | 12126 | 12017 | 5763 | 138312 | 11345.90625 | 780.09375 | 0.0643323231073726 | -609.0742761875416
Flavor 2 | 2011-03-29 00:00:00 | ASA11076 | 2011-08-04 00:00:00 | 7000 | 7022 | 6774 | 13151 | 78906 | 6472.7578125 | 549.2421875 | 0.078217343705497 | -842.8119151411493
Flavor 3 | 2011-03-30 00:00:00 | ASA11076 | 2011-08-04 00:00:00 | 5400 | 5419 | 5436 | 10343 | 62058 | 5090.6953125 | 328.3046875 | 0.06058399843144491 | -226.8583099044796
Flavor 4 | 2011-03-31 00:00:00 | ASA11077 | 2011-08-05 00:00:00 | 2600 | 2673 | 2562 | 4694 | 28164 | 2310.328125 | 362.671875 | 0.1356797138047138 | -865.5355936724451
Flavor 5
Flavor 6
Flavor 7 | 2011-04-01 00:00:00 | ASA11077 | 2011-08-05 00:00:00 | 4000 | 4010 | 3909 | 7710 | 46260 | 3794.765625 | 215.234375 | 0.05367440773067331 | -57.936066869203
Flavor 8 | 2011-04-02 00:00:00 | ASA11077 | 2011-08-05 00:00:00 | 2600 | 2620 | 2493 | 4677 | 28062 | 2301.9609375 | 318.0390625 | 0.1213889551526718 | -914.6116225889433
Flavor 9
 | RUN #: | 54 | TOTAL: | 33600 | 33870 | 33191 | 46338 | 381762 | 31316.4140625 | 2553.5859375 | 0.0753937389282551 | -3516.827784363762
Flavor 1 | 2011-02-25 00:00:00 | ASA11047 | 2011-07-06 00:00:00 | 6500 | 6505 | 6213 | 11729 | 70374 | 5772.8671875 | 732.1328125 | 0.1125492409684858 | -1730.705039486567
Flavor 2 | 2011-02-25 00:00:00 | ASA11048 | 2011-07-07 00:00:00 | 5500 | 5497 | 5247 | 10192 | 61152 | 5016.375 | 480.625 | 0.08743405493905766 | -813.9137489083922
Flavor 3 | 2011-02-26 00:00:00 | ASA11048 | 2011-07-07 00:00:00 | 4700 | 4716 | 4566 | 9088 | 54528 | 4473 | 243 | 0.05152671755725191 | -27.21074689673903
Flavor 4 | 2011-02-27 00:00:00 | ASA11049 | 2011-07-08 00:00:00 | 2000 | 2006 | 1857 | 3577 | 21462 | 1760.5546875 | 245.4453125 | 0.1223555894815553 | -639.3625412648843
Flavor 5 | 2011-02-28 00:00:00 | ASA11048 | 2011-07-07 00:00:00 | 2000 | 2048 | 1941 | 3714 | 22284 | 1827.984375 | 220.015625 | 0.1074295043945312 | -452.7922565879979
Flavor 6 | 2011-03-01 00:00:00 | ASA11049 | 2011-07-08 00:00:00 | 2800 | 2810 | 2725 | 5467 | 32802 | 2690.7890625 | 119.2109375 | 0.04242382117437722 | 83.70932249129297
Flavor 7 | 2011-03-02 00:00:00 | ASA11049 | 2011-07-08 00:00:00 | 2200 | 2171 | 2139 | 4205 | 25230 | 2069.6484375 | 101.3515625 | 0.04668427567941041 | 35.1999978719959
Flavor 8
Flavor 9
 | RUN #: | 53 | TOTAL: | 25700 | 25753 | 24688 | 47972 | 287832 | 23611.21875 | 2141.78125 | 0.0831662815982604 | -3545.075012781292
Flavor 1 | 2011-01-13 00:00:00 | ASA11013 | 2011-06-02 00:00:00 | 6000 | 6014 | 5815 | 11245 | 67470 | 5534.6484375 | 479.3515625 | 0.0797059465414034 | -759.9071527035794
Flavor 2 | 2011-01-12 00:00:00 | ASA11012 | 2011-06-01 00:00:00 | 4500 | 4505 | 4332 | 8219 | 49314 | 4045.2890625 | 459.7109375 | 0.1020446032186459 | -927.3768952166262
Flavor 3 | 2011-01-13 00:00:00 | ASA11013 | 2011-06-02 00:00:00 | 5000 | 5011 | 4890 | 9666 | 57996 | 4757.484375 | 253.515625 | 0.05059182298942327 | -11.2078987868946
Flavor 4
Flavor 5
Flavor 6 | 2011-01-14 00:00:00 | ASA11014 | 2011-06-03 00:00:00 | 2100 | 2105 | 2091 | 3927 | 23562 | 1932.8203125 | 172.1796875 | 0.08179557600950119 | -263.1698223056536
Flavor 7 | 2011-01-14 00:00:00 | ASA11014 | 2011-06-03 00:00:00 | 2000 | 2008 | 1974 | 3779 | 22674 | 1859.9765625 | 148.0234375 | 0.07371685134462151 | -232.8762177426874
Flavor 8 | 2011-01-14 00:00:00 | ASA11014 | 2011-07-13 00:00:00 | 2600 | 2521 | 2439 | 4585 | 27510 | 2256.6796875 | 264.3203125 | 0.1048474067830226 | -636.5090878173248
Flavor 9 | 2011-01-14 00:00:00 | ASA11014 | 2011-07-13 00:00:00 | 2600 | 2630 | 2550 | 4490 | 26940 | 2209.921875 | 420.078125 | 0.1597255228136882 | -1297.564855973128
 | RUN #: | 52 | TOTAL: | 24800 | 24794 | 24091 | 45911 | 275466 | 22596.8203125 | 2197.1796875 | 0.08861739483342744 | -4128.611930545894
 |  |  |  |  |  |  |  |  |  | 6892.546875