Spreadsheet: 103392d1301117672-perform-calculation-using-variable-percentage-based-on-other-cell-value-sample-2011-forecast
Sheet: OH

Our Home 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Our Home Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Our Home 2011 Sales Forecast
 | Our Home 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Our Home Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Our Home 2011 Sales Forecast
 | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Ave. Sales |  |  | No. | Branch | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New |  | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | 1 | Bacolod | 48834.1 | 120561.63 | 89704.56 | 100329.37 | 128205.5 | 129074.25 | 195555.5 | 236196.31 | 75539.25 | 105950.5 | 173818.86 | 215101.96 | 1618871.79 |  | 134905.9825 |  |  | 1 | Bacolod |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Bacolod |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2 | Bacoor | 213159.4 | 286919.75 | 432150 | 487340.09 | 584934.6 | 381478.5 | 453898.25 | 496739 | 302133.75 | 601136.05 | 408724.4 | 594695.81 | 5243309.6 |  | 436942.4666666666 |  |  | 2 | Bacoor |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Bacoor |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 3 | Baguio | 269674 | 246923.5 | 214900.3 | 316008.03 | 340048.4 | 368417.5 | 321741.46 | 378586.74 | 169249.5 | 284564.4 | 462312.9 | 438899.33 | 3811326.06 |  | 317610.5049999999 |  |  | 3 | Baguio |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Baguio |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 4 | Batangas | 298067.55 | 137655 | 311196.06 | 458742.75 | 422500.94 | 421439 | 405567.03 | 389710.78 | 263989.75 | 492390 | 595622.12 | 486337.86 | 4683218.840000001 |  | 390268.2366666668 |  |  | 4 | Batangas |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Batangas |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 5 | Cagayan de Oro | 152098.4 | 154154 | 259007.99 | 234566 | 221656.05 | 148480 | 152738.25 | 210186.78 | 156365 | 114290.75 | 228886.55 | 187699.05 | 2220128.82 |  | 185010.735 |  |  | 5 | Cagayan de Oro |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Cagayan de Oro |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 6 | Cebu | 438913.75 | 201948.25 | 213994.37 | 316401.8 | 388369.35 | 320599.25 | 324081.13 | 482995.31 | 76789 | 91997.75 | 238224.7 | 215389.25 | 3309703.91 |  | 275808.6591666667 |  |  | 6 | Cebu |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Cebu |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 7 | [NAME] | 156143.05 | 236324.5 | 189386.67 | 458162.75 | 339150.34 | 537469.5 | 324070.81 | 357804.93 | 170645 | 523652.25 | 374497.15 | 415510.88 | 4082817.83 |  | 340234.8191666667 |  |  | 7 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 8 | [NAME] | 300694.55 | 323015 | 577330.05 | 362709.62 | 392314 | 478060 | 463400 | 353373.5 | 245748.75 | 522066.25 | 458665.75 | 485997.25 | 4963374.720000001 |  | 413614.5600000001 |  |  | 8 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 9 | Fairview | 287251.6 | 446554.39 | 537746.74 | 571785 | 571890.35 | 532588.5 | 637426 | 664006.5 | 378570 | 353890 | 492497.25 | 722174.78 | 6196381.11 |  | 516365.0925 |  |  | 9 | Fairview |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Fairview |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 10 | Iloilo | 149564.25 | 174089.75 | 217028.75 | 190739.75 | 441274.8 | 497857.75 | 128770.8 | 119040.06 | 200488 | 213069.75 | 160885.3 | 178612.55 | 2671421.51 |  | 222618.4591666666 |  |  | 10 | Iloilo |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Iloilo |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 11 | [NAME] | 299672.25 | 257844.75 | 326720.68 | 482005.81 | 854616 | 408294.75 | 363711.71 | 330017.03 | 441750.05 | 332184.53 | 464948.59 | 443370.9 | 5005137.050000001 |  | 417094.7541666667 |  |  | 11 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 12 | Mall of Asia | 269741.1 | 117985 | 461221.55 | 329647 | 261271.25 | 289129.75 | 248859 | 416751.5 | 346573.75 | 303870.53 | 335257.5 | 312121.75 | 3692429.68 |  | 307702.4733333333 |  |  | 12 | Mall of Asia |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Mall of Asia |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 13 | Marilao | 275951.8 | 264819.75 | 570427.93 | 333581.5 | 610862.14 | 354809.75 | 532490.53 | 401170.25 | 470474.25 | 653370.8 | 449100.78 | 480461 | 5397520.48 |  | 449793.3733333334 |  |  | 13 | Marilao |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | Marilao |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 14 | Megamall | 418578.75 | 453869.5 | 699479.93 | 1077073.43 | 905545.85 | 745754.5 | 671605.85 | 647296 | 582735.5 | 1112538.25 | 661118.25 | 810117.78 | 8785713.59 |  | 732142.7991666667 |  |  | 14 | Megamall |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Megamall |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 15 | [NAME] | 749315 | 298267.1 | 582148.1 | 582568.25 | 630359.11 | 702749.75 | 804169.41 | 502816.75 | 332357.85 | 416625.53 | 823356.6 | 616706.28 | 7041439.73 |  | 586786.6441666667 |  |  | 15 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 16 | Pampanga | 215968.75 | 302576.25 | 347559.5 | 221500.28 | 316478.5 | 399469.5 | 263844 | 451818 | 185580 | 76946 | 163775.95 | 106597 | 3052113.73 |  | 254342.8108333334 |  |  | 16 | Pampanga |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Pampanga |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 17 | [NAME] | 105144.8 | 137190 | 244412.87 | 244406.87 | 439159.4 | 610008.75 | 529720.9 | 242914.25 | 180419.5 | 452587.75 | 431716.25 | 351960.8 | 3969642.14 |  | 330803.5116666667 |  |  | 17 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 18 | Southmall | 180155.75 | 213907.25 | 126131.25 | 169599.75 | 206406.8 | 269144.75 | 433139 | 316047.25 | 289953.05 | 278467.25 | 321712.55 | 314019.4 | 3118684.05 |  | 259890.3375 |  |  | 18 | Southmall |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Southmall |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 19 | Sta. [NAME] | 666076 | 557705.55 | 640918.99 | 780611.12 | 793405.5 | 832788.5 | 979836.5 | 722287.5 | 576679.5 | 737803.75 | 966913.75 | 1150396.75 | 9405423.41 |  | 783785.2841666667 |  |  | 19 | Sta. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | Sta. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 20 | Virramall | 231475.75 | 163069.75 | 564691 | 588259.75 | 514810.6 | 380863.5 | 601887.78 | 411783.5 | 335912.25 | 460117.5 | 386384.5 | 416654 | 5055909.88 |  | 421325.8233333333 |  |  | 20 | Virramall |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Virramall |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total | 5726480.600000001 | 5095380.67 | 7606157.29 | 8306038.920000001 | 9363259.479999999 | 8808477.75 | 8836513.91 | 8131541.94 | 5781953.699999999 | 8127519.590000001 | 8598419.7 | 8942824.38 | 93324567.92999999 |  | 7777047.3275 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Forecast Parameters
 | 1 | If marketing drive is blank grow 2011 forecast by 3%
 | 2 | If marketing drive is same grow 2011 forecast by 6%
 | 3 | If marketing drive is new grow 2011 forecast by 10%
 | 4 | If 2011 forecast is greater than 50% from average sales, get median of forecast (i.e. Jan 2011 forecast is 500,000 while average sales is at 134,905.98, then Jan 2011 forecast is equal to 250,000)
 | 5 | If 2011 forecast is lower than 200,000 then forecast should be based on minimum which is 200,000. (i.e Jan 2011 forecast is 100,000 then by default Jan 2011 will be convert to a forecast of 200,000)