Spreadsheet: 159336d1338582510-multi-tab-commands-sample-tables-tc0004-oeldere-
Sheet: Forecast

Code | Customer | Code | Item | RM | Code | [NAME] | Code | Month | Qty to 4/30/12 | Sales to 4/30/12 | Qty Jan 2012 | Sales Jan 2012 | Qty Feb 2012 | Sales Feb 2012 | [NAME] | [NAME] 2012 | Qty Apr 2012 | Sales Apr 2012 | Selling Price | Qty May | Qty June | Qty July | Qty Aug | [NAME] | Qty Oct | Qty Nov | Qty Dec | Forecast Qty Total | Forecast Sales Total | QTY YTD Sales + Forecast | Sales YTD Sales + Forecast | Q1 2012 $ | Q2 2012 $ | Q3 2012 $ | Q4 2012 $
11775 | 1st Class Service | 25340 | #N/A | [NAME] | 2 | Region Two | 4/2012 | 2012-04-20 00:00:00 | 110 | 1127.5 | 0 | 0 | 0 | 0 | 0 | 0 | 110 | 1127.5 | 10.25 | 50 |  |  |  |  |  |  |  | 50 | 512.5 | 160 | 1640 | 0 | 1640 | 0 | 0
11883 | 4 Seasons Landscape | 13240 | #N/A | [NAME] | 2 | Region Two | 2/2012 | 2012-02-20 00:00:00 | 5 | 62.5 | 0 | 0 | 5 | 62.5 | 0 | 0 | 0 | 0 | 12.5 |  |  |  |  |  |  |  |  | 0 | 0 | 5 | 62.5 | 62.5 | 0 | 0 | 0
11883 | 4 Seasons Landscape | 25340 | #N/A | [NAME] | 2 | Region Two | 3/2012 | 2012-03-20 00:00:00 | 15 | 187.5 | 0 | 0 | 0 | 0 | 15 | 187.5 | 0 | 0 | 12.5 | 100 |  |  |  |  |  |  |  | 100 | 1250 | 115 | 1437.5 | 187.5 | 1250 | 0 | 0
11883 | 4 Seasons Landscape | 31381 | #N/A | [NAME] | 2 | Region Two | 2/2012 | 2012-02-20 00:00:00 | 15 | 210 | 0 | 0 | 15 | 210 | 0 | 0 | 0 | 0 | 14 | 30 |  |  |  |  |  |  |  | 30 | 420 | 45 | 630 | 210 | 420 | 0 | 0
11883 | 4 Seasons Landscape | 25004 | #N/A | [NAME] | 2 | Region Two | 3/2012 | 2012-03-20 00:00:00 | 2.5 | 62.5 | 0 | 0 | 0 | 0 | 2.5 | 62.5 | 0 | 0 | 25 |  |  |  |  |  |  |  |  | 0 | 0 | 2.5 | 62.5 | 62.5 | 0 | 0 | 0
10811 | 4M WEED CONTROL | 19135 | #N/A | [NAME] | 8 | Region Eight | 2/2012 | 2012-02-20 00:00:00 | 15 | 450 | 0 | 0 | 15 | 450 | 0 | 0 | 0 | 0 | 30 |  |  |  |  |  |  |  |  | 0 | 0 | 15 | 450 | 450 | 0 | 0 | 0
10811 | 4M WEED CONTROL | 19135 | #N/A | [NAME] | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 25 | 750 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 750 | 30 | 75 |  |  |  |  |  |  |  | 75 | 2250 | 100 | 3000 | 0 | 3000 | 0 | 0
10811 | 4M WEED CONTROL | 19231 | #N/A | [NAME] | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 12 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 72 | 6 | 24 |  |  |  |  |  |  |  | 24 | 144 | 36 | 216 | 0 | 216 | 0 | 0
10811 | 4M WEED CONTROL | 31300 | #N/A | [NAME] | 8 | Region Eight | 2/2012 | 2012-02-20 00:00:00 | 240 | 1740 | 0 | 0 | 240 | 1740 | 0 | 0 | 0 | 0 | 7.25 | 48 |  |  |  |  |  |  |  | 48 | 348 | 288 | 2088 | 1740 | 348 | 0 | 0
10811 | 4M WEED CONTROL | 31304 | #N/A | [NAME] | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 350 | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 350 | 1400 | 4 | 50 |  |  |  |  |  |  |  | 50 | 200 | 400 | 1600 | 0 | 1600 | 0 | 0
10811 | 4M WEED CONTROL | 25340 | #N/A | [NAME] | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 30 | 345 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 345 | 11.5 | 75 |  |  |  |  |  |  |  | 75 | 862.5 | 105 | 1207.5 | 0 | 1207.5 | 0 | 0
10811 | 4M WEED CONTROL | 31307 | #N/A | [NAME] | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 25 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 3000 | 120 | 50 |  |  |  |  |  |  |  | 50 | 6000 | 75 | 9000 | 0 | 9000 | 0 | 0
10000 | Abate-A-Weed | 31303 | #N/A | [NAME] | 6 | Region Six | 1/2012 | 2012-01-20 00:00:00 | 2000 | 18000 | 2000 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 9 |  |  |  |  |  |  |  |  | 0 | 0 | 2000 | 18000 | 18000 | 0 | 0 | 0
10000 | Abate-A-Weed | 31303 | #N/A | [NAME] | 6 | Region Six | 2/2012 | 2012-02-20 00:00:00 | 1000 | 9000 | 0 | 0 | 1000 | 9000 | 0 | 0 | 0 | 0 | 9 |  |  |  |  |  |  |  |  | 0 | 0 | 1000 | 9000 | 9000 | 0 | 0 | 0
10000 | Abate-A-Weed | 31303 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 1000 | 9000 | 0 | 0 | 0 | 0 | 1000 | 9000 | 0 | 0 | 9 |  |  |  |  |  |  |  |  | 0 | 0 | 1000 | 9000 | 9000 | 0 | 0 | 0
10000 | Abate-A-Weed | 12025 | #N/A | [NAME] | 6 | Region Six | 4/2012 | 2012-04-20 00:00:00 | 270 | 5670 | 0 | 0 | 0 | 0 | 0 | 0 | 270 | 5670 | 21 |  |  |  |  |  |  |  |  | 0 | 0 | 270 | 5670 | 0 | 5670 | 0 | 0
10000 | Abate-A-Weed | 12023 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 150 | 2775 | 0 | 0 | 0 | 0 | 150 | 2775 | 0 | 0 | 18.5 |  |  |  |  |  |  |  |  | 0 | 0 | 150 | 2775 | 2775 | 0 | 0 | 0
10000 | Abate-A-Weed | 13242 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 265 | 2811.65 | 0 | 0 | 0 | 0 | 265 | 2811.65 | 0 | 0 | 10.61 |  |  |  |  |  |  |  |  | 0 | 0 | 265 | 2811.65 | 2811.65 | 0 | 0 | 0
10000 | Abate-A-Weed | 13241 | #N/A | [NAME] | 6 | Region Six | 1/2012 | 2012-01-20 00:00:00 | 120 | 1219.2 | 120 | 1219.2 | 0 | 0 | 0 | 0 | 0 | 0 | 10.16 |  |  |  |  |  |  |  |  | 0 | 0 | 120 | 1219.2 | 1219.2 | 0 | 0 | 0
10000 | Abate-A-Weed | 31313 | #N/A | [NAME] | 6 | Region Six | 2/2012 | 2012-02-20 00:00:00 | 48 | 1687.68 | 0 | 0 | 48 | 1687.68 | 0 | 0 | 0 | 0 | 35.16 |  |  |  |  |  |  |  |  | 0 | 0 | 48 | 1687.68 | 1687.68 | 0 | 0 | 0
10000 | Abate-A-Weed | 31313 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 24 | 843.84 | 0 | 0 | 0 | 0 | 24 | 843.84 | 0 | 0 | 35.16 |  |  |  |  |  |  |  |  | 0 | 0 | 24 | 843.84 | 843.84 | 0 | 0 | 0
10000 | Abate-A-Weed | 31313 | #N/A | [NAME] | 6 | Region Six | 4/2012 | 2012-04-20 00:00:00 | 24 | 843.84 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 843.84 | 35.16 |  |  |  |  |  |  |  |  | 0 | 0 | 24 | 843.84 | 0 | 843.84 | 0 | 0
10000 | Abate-A-Weed | 31331 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 1000 | 15850 | 0 | 0 | 0 | 0 | 1000 | 15850 | 0 | 0 | 15.85 |  |  |  |  |  |  |  |  | 0 | 0 | 1000 | 15850 | 15850 | 0 | 0 | 0
11970 | Advanced Spraying | 31300 | #N/A | [NAME] | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 96 | 768 | 0 | 0 | 0 | 0 | 96 | 768 | 0 | 0 | 8 |  |  |  |  |  |  |  |  | 0 | 0 | 96 | 768 | 768 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 26151 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 60 | 720 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 720 | 12 |  |  |  |  |  |  |  |  | 0 | 0 | 60 | 720 | 0 | 720 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13018 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 5 | 177.5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 177.5 | 35.5 |  |  |  |  |  |  |  |  | 0 | 0 | 5 | 177.5 | 0 | 177.5 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 31304 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 300 | 1245 | 0 | 0 | 0 | 0 | 300 | 1245 | 0 | 0 | 4.15 |  |  |  |  |  |  |  |  | 0 | 0 | 300 | 1245 | 1245 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13186 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 8 | 312 | 0 | 0 | 0 | 0 | 8 | 312 | 0 | 0 | 39 |  |  |  |  |  |  |  |  | 0 | 0 | 8 | 312 | 312 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13186 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 8 | 312 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 312 | 39 |  |  |  |  |  |  |  |  | 0 | 0 | 8 | 312 | 0 | 312 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 26159 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 4 | 1600 | 0 | 0 | 0 | 0 | 4 | 1600 | 0 | 0 | 400 |  |  |  |  |  |  |  |  | 0 | 0 | 4 | 1600 | 1600 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 26159 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 4 | 1600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1600 | 400 |  |  |  |  |  |  |  |  | 0 | 0 | 4 | 1600 | 0 | 1600 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13240 | #N/A | [NAME] | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 60 | 630 | 0 | 0 | 60 | 630 | 0 | 0 | 0 | 0 | 10.5 |  |  |  |  |  |  |  |  | 0 | 0 | 60 | 630 | 630 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 25340 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 720 | 8130.6 | 0 | 0 | 0 | 0 | 0 | 0 | 720 | 8130.6 | 11.2925 |  |  |  |  |  |  |  |  | 0 | 0 | 720 | 8130.6 | 0 | 8130.6 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 11050 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 6 | 138 | 0 | 0 | 0 | 0 | 6 | 138 | 0 | 0 | 23 |  |  |  |  |  |  |  |  | 0 | 0 | 6 | 138 | 138 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 11056 | #N/A | [NAME] | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 600 | 4800 | 0 | 0 | 600 | 4800 | 0 | 0 | 0 | 0 | 8 |  |  |  |  |  |  |  |  | 0 | 0 | 600 | 4800 | 4800 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 11056 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 700 | 5600 | 0 | 0 | 0 | 0 | 700 | 5600 | 0 | 0 | 8 |  |  |  |  |  |  |  |  | 0 | 0 | 700 | 5600 | 5600 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 31359 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 45 | 1800 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 1800 | 40 |  |  |  |  |  |  |  |  | 0 | 0 | 45 | 1800 | 0 | 1800 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 14068 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 24 | 1920 | 0 | 0 | 0 | 0 | 24 | 1920 | 0 | 0 | 80 |  |  |  |  |  |  |  |  | 0 | 0 | 24 | 1920 | 1920 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 14068 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 24 | 1920 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 1920 | 80 |  |  |  |  |  |  |  |  | 0 | 0 | 24 | 1920 | 0 | 1920 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13074 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 5 | 226.25 | 0 | 0 | 0 | 0 | 5 | 226.25 | 0 | 0 | 45.25 |  |  |  |  |  |  |  |  | 0 | 0 | 5 | 226.25 | 226.25 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 31313 | #N/A | [NAME] | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 24 | 732 | 0 | 0 | 24 | 732 | 0 | 0 | 0 | 0 | 30.5 |  |  |  |  |  |  |  |  | 0 | 0 | 24 | 732 | 732 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 31313 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 120 | 3660 | 0 | 0 | 0 | 0 | 120 | 3660 | 0 | 0 | 30.5 |  |  |  |  |  |  |  |  | 0 | 0 | 120 | 3660 | 3660 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13195 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 90 | 3510 | 0 | 0 | 0 | 0 | 90 | 3510 | 0 | 0 | 39 |  |  |  |  |  |  |  |  | 0 | 0 | 90 | 3510 | 3510 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13202 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 450 | 21150 | 0 | 0 | 0 | 0 | 450 | 21150 | 0 | 0 | 47 |  |  |  |  |  |  |  |  | 0 | 0 | 450 | 21150 | 21150 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13202 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 420 | 19740 | 0 | 0 | 0 | 0 | 0 | 0 | 420 | 19740 | 47 |  |  |  |  |  |  |  |  | 0 | 0 | 420 | 19740 | 0 | 19740 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13201 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 20 | 960 | 0 | 0 | 0 | 0 | 20 | 960 | 0 | 0 | 48 |  |  |  |  |  |  |  |  | 0 | 0 | 20 | 960 | 960 | 0 | 0 | 0
10002 | ADVANCED TURF SOLUTIONS | 13201 | #N/A | [NAME] | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 12 | 576 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 576 | 48 |  |  |  |  |  |  |  |  | 0 | 0 | 12 | 576 | 0 | 576 | 0 | 0
11679 | Agland Coop | 11050 | #N/A | [NAME] | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 6 | 143.1 | 0 | 0 | 0 | 0 | 6 | 143.1 | 0 | 0 | 23.85 |  |  |  |  |  |  |  |  | 0 | 0 | 6 | 143.1 | 143.1 | 0 | 0 | 0
11224 | AGPACK | 26150 | #N/A | Zane | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -4920 | 0 | 0 | 0 | 0 | 0 | -4920 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | -4920 | -4920 | 0 | 0 | 0
11224 | AGPACK | 13202 | #N/A | Zane | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -2358 | 0 | 0 | 0 | 0 | 0 | -2358 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | -2358 | -2358 | 0 | 0 | 0
11224 | AGPACK | 13198 | #N/A | Zane | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -1452 | 0 | 0 | 0 | 0 | 0 | -1452 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | -1452 | -1452 | 0 | 0 | 0