Spreadsheet: 274884d1383247578-complex-forecasting-formula-needed-forecasting-methods-in-excel
Sheet: Should look like

Raw Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecasted Months
Center | IB_Standarized | Jan-09 | Feb-09 | [NAME] | Apr-09 | May-09 | Jun-09 | Jul-09 | Aug-09 | Sep-09 | Oct-09 | Nov-09 | Dec-09 | Jan-10 | Feb-10 | Mar-10 | Apr-10 | May-10 | Jun-10 | Jul-10 | Aug-10 | Sep-10 | Oct-10 | Nov-10 | Dec-10 | Jan-11 | Feb-11 | Mar-11 | Apr-11 | May-11 | Jun-11 | Jul-11 | Aug-11 | Sep-11 | Oct-11 | Nov-11 | Dec-11 | Jan-12 | Feb-12 | Mar-12 | Apr-12 | May-12 | Jun-12 | Jul-12 | Aug-12 | Sep-12 | Oct-12 | Nov-12 | Dec-12 | [NAME] | Feb-13 | Mar-13 | Apr-13 | [NAME] | Jun-13 | Jul-13 | Aug-13 | 2013-09-13 00:00:00 | 2013-10-13 00:00:00 | 2013-11-13 00:00:00 | 2013-12-13 00:00:00 | 2013-01-14 00:00:00 | 2013-02-14 00:00:00 | 2013-03-14 00:00:00 | 2013-04-14 00:00:00 | 2013-05-14 00:00:00 | 2013-06-14 00:00:00 | 2013-07-14 00:00:00 | 2013-08-14 00:00:00 | Notes
363 | Squash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 460 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1. Exclude the first month of each center.
363 | Pickle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 8 | 0 | 3 | 1 | 2 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 5 | 4 | 15 | 16 | 2 | 3 | 9 | 10 | 13 | 6 | 26 | 3 | 9 | 0 | 0 | 8 | 0 | 1 | 6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2. If greater than 24 months output as shown in orange
363 | Cards | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 570 | 541 | 346 | 432 | 488 | 784 | 425 | 462 | 422 | 502 | 668 | 448 | 1080 | 434 | 261 | 424 | 907 | 582 | 755 | 667 | 558 | 433 | 483 | 480 | 677 | 565 | 358 | 392 | 576 | 401 | 835 | 567 | 630 | 360 | 367 |  |  |  |  |  |  |  |  |  |  |  |  | 3. If less than 24 months output as shown in blue
363 | Notebooks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 6 | 3 | 1 | 4 | 3 | 1 | 82 | 7 | 4 | 1 | 1 | 2 | 15 | 1 | 1 | 2 | 18 | 3 | 3 | 1 | 3 | 2 | 1 | 0 | 3 | 5 | 0 | 0 | 0 | 4 | 1 | 1 | 2
363 | Hangers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 | 216 | 125 | 172 | 177 | 298 | 161 | 162 | 161 | 121 | 258 | 141 | 273 | 179 | 138 | 420 | 243 | 192 | 292 | 234 | 244 | 291 | 279 | 219 | 322 | 324 | 174 | 469 | 253 | 231 | 284 | 253 | 221 | 308 | 230
363 | Tablet | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 11 | 14 | 20 | 22 | 70 | 66 | 31 | 107 | 22 | 43 | 28 | 39 | 54 | 30 | 29 | 76 | 55 | 48 | 12 | 49 | 55 | 40 | 101 | 60 | 76 | 68 | 53 | 126 | 89 | 72 | 39 | 69 | 52 | 82
363 | Pens | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 645 | 743 | 343 | 615 | 700 | 974 | 656 | 482 | 704 | 856 | 699 | 908 | 1029 | 722 | 563 | 880 | 730 | 959 | 745 | 932 | 738 | 808 | 914 | 849 | 941 | 937 | 533 | 1028 | 786 | 675 | 1062 | 705 | 1010 | 1090 | 817
363 | Pencils | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 22 | 5 | 32 | 14 | 41 | 39 | 27 | 30 | 40 | 84 | 93 | 66 | 33 | 22 | 68 | 62 | 34 | 50 | 131 | 147 | 208 | 140 | 117 | 114 | 145 | 193 | 163 | 134 | 68 | 124 | 168 | 196 | 159 | 95
5008 | Pickle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 9 | 3 | 1 | 8 | 1 | 6 | 1 | 2 | 6 | 5 | 0 | 0 | 1 | 4 | 3 | 3 | 3 | 3 | 2
5008 | Cards | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 209 | 342 | 227 | 790 | 639 | 911 | 840 | 727 | 518 | 453 | 338 | 470 | 593 | 501 | 165 | 647 | 621 | 770 | 845 | 735 | 360 | 554 | 254 |  |  |  |  |  |  |  |  |  |  |  |  | Less than 24 months will output the average of all centers greater than 24 months
5008 | Notebooks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 2 | 10 | 9 | 2 | 5 | 5 | 8 | 3 | 2 | 6 | 9 | 4 | 2 | 4 | 3 | 3 | 3 | 11 | 6 | 1 | 0
5008 | Hangers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 291 | 361 | 281 | 316 | 304 | 297 | 408 | 306 | 220 | 270 | 266 | 387 | 303 | 203 | 131 | 349 | 298 | 323 | 423 | 292 | 221 | 395 | 320
5008 | Box | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 8 | 10 | 10 | 17 | 5 | 2 | 8 | 0 | 8 | 5 | 0 | 6 | 6 | 5 | 1 | 3 | 8 | 8 | 16 | 9
5008 | Tablet | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 3 | 8 | 45 | 61 | 67 | 66 | 63 | 43 | 88 | 9 | 39 | 47 | 52 | 8 | 766 | 131 | 75 | 58 | 34 | 27 | 71 | 35
5008 | Pens | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 392 | 444 | 448 | 1045 | 1113 | 1179 | 925 | 891 | 586 | 695 | 555 | 1009 | 1008 | 673 | 266 | 677 | 930 | 1022 | 923 | 676 | 612 | 937 | 605
5008 | Pencils | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 28 | 53 | 49 | 92 | 68 | 76 | 73 | 58 | 88 | 21 | 85 | 83 | 29 | 28 | 86 | 75 | 74 | 53 | 60 | 123 | 197 | 101
5036 | Pickle | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 7 | 22 | 4 | 3 | 13 | 16 | 26 | 12 | 1 | 4 | 9 | 5.375 | 3.75 | 9 | 2.083333333333333 | 3.333333333333333 | 2.583333333333333 | 6.633333333333333 | 7.5 | 4.9 | 2.933333333333334 | 4.066666666666666 | 5.533333333333333
5036 | Cards | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 422 | 675 | 338 | 105 | 185 | 209 | 386 | 568 | 376 | 326 | 440 | 336 | 535.375 | 862 | 514.2916666666667 | 275.2083333333334 | 346 | 482.875 | 594.3 | 578.2333333333333 | 582.7666666666667 | 588.3333333333333 | 444.5333333333333 | 492.1
5036 | Notebooks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 3 | 2 | 3 | 1 | 2 | 5 | 1 | 7 | 17 | 2 | 1.5 | 1.125 | 4.75 | 1.875 | 0.7083333333333333 | 1.9 | 4.5 | 2.633333333333333 | 15.63333333333333 | 3.2 | 2
5036 | Hangers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 265 | 252 | 198 | 175 | 181 | 187 | 264 | 262 | 279 | 176 | 208 | 250 | 216.25 | 301.125 | 222.9583333333333 | 153.7083333333333 | 248.2083333333333 | 205.7916666666667 | 230.8666666666667 | 258.1333333333333 | 251.0666666666667 | 246.9333333333333 | 241.6 | 250.8333333333333
5036 | Tablet | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 192 | 239 | 163 | 117 | 245 | 136 | 190 | 144 | 167 | 130 | 243 | 111
5036 | Pens | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 720 | 806 | 466 | 273 | 451 | 456 | 495 | 846 | 656 | 768 | 789 | 573 | 82.25 | 79.875 | 84.375 | 51.91666666666667 | 71.25 | 87.20833333333334 | 91.46666666666667 | 80.8 | 84.06666666666668 | 96 | 81.8 | 86.2
5036 | Pencils | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 146 | 158 | 104 | 107 | 149 | 143 | 124 | 204 | 189 | 308 | 172 | 159 | 917.25 | 975.875 | 694.5833333333333 | 433.0833333333334 | 626.5 | 614.0833333333333 | 814.2666666666667 | 728.7 | 803.1666666666667 | 801.3666666666667 | 812.1 | 734.3
5036 | TRANSITION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 272 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 63.75 | 61.5 | 51.08333333333334 | 45.16666666666666 | 51.33333333333334 | 42 | 38.93333333333333 | 59.6 | 91.03333333333333 | 93.86666666666666 | 88.73333333333332 | 69.66666666666666
3637 | Squash | 0 | 29 | 3 | 1 | 2 | 1 | 1 | 0 | 2 | 9 | 15 | 6 | 27 | 13 | 36 | 14 | 12 | 18 | 27 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
3637 | Pickle | 0 | 6 | 4 | 7 | 2 | 8 | 4 | 4 | 6 | 1 | 0 | 0 | 0 | 2 | 12 | 16 | 12 | 2 | 3 | 24 | 1 | 9 | 8 | 7 | 3 | 3 | 9 | 4 | 5 | 0 | 1 | 3 | 3 | 2 | 6 | 3 | 1 | 0 | 5 | 2 | 20 | 7 | 5 | 3 | 5 | 4 | 10 | 0 | 0 | 9 | 8 | 6 | 5 | 4 | 1 | 3
3637 | Cards | 0 | 258 | 620 | 502 | 770 | 696 | 442 | 470 | 776 | 824 | 479 | 306 | 234 | 351 | 460 | 455 | 663 | 731 | 537 | 607 | 536 | 853 | 562 | 228 | 190 | 339 | 595 | 449 | 562 | 572 | 282 | 435 | 573 | 926 | 545 | 221 | 154 | 247 | 798 | 468 | 509 | 604 | 507 | 462 | 542 | 779 | 475 | 160 | 526 | 298 | 525 | 550 | 497 | 597 | 519 | 417 |  |  |  |  |  |  |  |  |  |  |  |  | Greater than 24 months will be average only for the center being forecasted.
3637 | Notebooks | 0 | 0 | 2 | 4 | 9 | 1 | 6 | 2 | 3 | 4 | 2 | 1 | 0 | 2 | 2 | 2 | 0 | 1 | 4 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 0 | 7 | 0 | 0 | 1 | 4 | 0 | 1 | 2 | 0 | 3 | 2 | 1 | 2 | 5 | 1 | 4 | 0 | 3 | 2 | 1 | 1 | 1 | 1 | 3 | 2 | 2 | 0
3637 | Hangers | 0 | 79 | 148 | 147 | 220 | 229 | 211 | 250 | 228 | 211 | 187 | 221 | 115 | 150 | 208 | 237 | 234 | 256 | 191 | 240 | 173 | 363 | 190 | 120 | 106 | 167 | 235 | 163 | 281 | 246 | 245 | 244 | 209 | 283 | 174 | 145 | 118 | 155 | 248 | 458 | 400 | 407 | 247 | 246 | 400 | 362 | 274 | 161 | 232 | 277 | 268 | 348 | 294 | 288 | 322 | 250
3637 | Box | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0
3637 | Tablet | 0 | 137 | 173 | 152 | 161 | 183 | 219 | 279 | 135 | 130 | 140 | 146 | 136 | 125 | 91 | 89 | 163 | 113 | 138 | 126 | 96 | 96 | 170 | 45 | 75 | 33 | 122 | 87 | 92 | 85 | 63 | 88 | 117 | 112 | 90 | 37 | 97 | 165 | 103 | 81 | 163 | 161 | 121 | 54 | 52 | 103 | 87 | 38 | 126 | 76 | 69 | 89 | 125 | 43 | 62 | 40
3637 | Pens | 0 | 443 | 760 | 736 | 1136 | 683 | 762 | 699 | 1108 | 944 | 488 | 585 | 377 | 575 | 688 | 615 | 894 | 924 | 966 | 725 | 951 | 870 | 615 | 349 | 384 | 457 | 1001 | 553 | 839 | 1046 | 569 | 640 | 936 | 1048 | 622 | 378 | 391 | 475 | 780 | 539 | 793 | 738 | 539 | 567 | 829 | 1005 | 629 | 234 | 496 | 451 | 567 | 739 | 838 | 536 | 695 | 662
3637 | Pencils | 0 | 25 | 27 | 38 | 35 | 18 | 50 | 40 | 15 | 14 | 44 | 25 | 16 | 11 | 28 | 24 | 18 | 26 | 25 | 28 | 20 | 18 | 16 | 10 | 27 | 23 | 18 | 18 | 16 | 23 | 24 | 29 | 37 | 31 | 46 | 14 | 9 | 13 | 28 | 35 | 62 | 50 | 36 | 27 | 18 | 69 | 36 | 19 | 8 | 9 | 50 | 126 | 236 | 200 | 74 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The ideal formula for the forecast will take into account the described methods above.  Also it would be nice to format all Greater than 24 months as a certain background. All less than 24 months as a different background. Just to show a difference in forecasting method being used.