Spreadsheet: 99393d1298026569-request-to-help-convert-logic-into-excel-formula-request-for-help
Sheet: 2010 Sales Data

Homeworld Furniture 2010 Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Furniture 2011 Sales Forecast
2010 Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 Mo. |  | 2010 Ave. |  | 2011 Mo. GDP |  | 2011 New |  | 2010 & 2011 |  | Branch | Promo | 2011 Monthly Sales Forecast
Branch | January | February | March | April | May | June | July | August | September | October | November | December | Total |  | Forecast |  | Sales |  | Forecast (4%) |  | Promo (6%) |  | Promo (3%) |  |  | YES/NO | January | February | March | April | May | June | July | August | September | October | November | December | Total
Bicutan | 237314.75 | 390159.5 | 1073979.75 | 396774.5 | 797530.5 | 684968.5 | 593018.5 | 503293 | 828085.25 | 470425.25 | 344569.5 | 541023.75 | 6861142.75 |  | 400000 |  | 571761.8958333334 |  | 22870.47583333333 |  | 34305.71375 |  | 17152.856875 |  | Bicutan
Cebu | 211378.5 | 213430 | 615081.5 | 617998.5 | 696851.5 | 958623.5 | 241483 | 352748 | 86834.25 | 196420.5 | 284650 | 212786.5 | 4688285.75 |  | 400000 |  | 390690.4791666667 |  | 15627.61916666667 |  | 23441.42875 |  | 11720.714375 |  | Cebu
Cubao | 893442.75 | 640576 | 1461204.25 | 1255344.25 | 1002074.25 | 996002 | 822600.5 | 726874.25 | 1164637 | 496658 | 603354.5 | 723166.75 | 10785934.5 |  | 850000 |  | 898827.875 |  | 35953.115 |  | 53929.6725 |  | 26964.83625 |  | Cubao
Cw Sucat - Cebu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Cebu
Cw Sucat - Davao (Added to Davao) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Davao (Added to Davao)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME]
CW Sucat - Iloilo (Added to Iloilo) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | CW Sucat - Iloilo (Added to Iloilo)
[NAME] (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME] (Added to [NAME])
CW Sucat - Morong (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | CW Sucat - Morong (Added to [NAME])
CW Sucat 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | CW Sucat 1
Cw Sucat - Tanay (Added to Tanay) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Tanay (Added to Tanay)
CW Sucat - Savemore Tanay (Added to Tanay) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | CW Sucat - Savemore Tanay (Added to Tanay)
Davao | 365950 | 17577 | 476177 | 364903 | 395122 | 254473.75 | 400126.75 | 172792 | 279845.5 | 21198.5 | 671724.25 | 25985.5 | 3445875.25 |  | 300000 |  | 287156.2708333333 |  | 11486.25083333333 |  | 17229.37625 |  | 8614.688124999999 |  | Davao
Ilo-ilo | 41995 | 0 | 815309.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23760 | 881064.5 |  | 300000 |  | 73422.04166666667 |  | 2936.881666666667 |  | 4405.3225 |  | 2202.66125 |  | Ilo-ilo
[NAME] | 250941.5 | 412774 | 841357.5 | 403506.25 | 790394 | 283038.75 | 443399.5 | 638457.25 | 180981.75 | 227883.75 | 518957 | 430785.5 | 5422476.75 |  | 320000 |  | 451873.0625 |  | 18074.9225 |  | 27112.38375 |  | 13556.191875 |  | [NAME]
Makati | 1134847.5 | 691148 | 2099830.75 | 608451 | 1506238.25 | 1268497.75 | 1064465.75 | 1188632.25 | 1676288 | 1520515.75 | 917404.25 | 1225121.25 | 14901440.5 |  | 1200000 |  | 1241786.708333333 |  | 49671.46833333333 |  | 74507.2025 |  | 37253.60125 |  | Makati
Mall of Asia | 216577.25 | 367542.75 | 621455 | 948167.5 | 505447 | 708169.5 | 345213.25 | 419629 | 479252.75 | 616391.5 | 249530.75 | 573848.75 | 6051225 |  | 400000 |  | 504268.75 |  | 20170.75 |  | 30256.125 |  | 15128.0625 |  | Mall of Asia
Manila | 94391.75 | 557538 | 1314040 | 488801.5 | 899465.75 | 760855.25 | 759921.75 | 1006973.75 | 529993 | 434116.25 | 514568.5 | 584749 | 7945414.5 |  | 750000 |  | 662117.875 |  | 26484.715 |  | 39727.0725 |  | 19863.53625 |  | Manila
Marikina |  | 256051.5 | 724942 | 0 | 550022 | 499996.25 | 652241.5 | 679036 | 130189.5 | 302844 | 235525.5 | 246418.25 | 4277266.5 |  | 200000 |  | 388842.4090909091 |  | 15553.69636363637 |  | 23330.54454545455 |  | 11665.27227272727 |  | Marikina
Megamall | 1262144.5 | 1513882.5 | 1597688.25 | 1665828.75 | 1595003.753 | 1939643 | 1810813.75 | 2034988.25 | 1491893.75 | 2226215.25 | 1232669.003 | 1585093.25 | 19955864.006 |  | 1300000 |  | 1662988.667166666 |  | 66519.54668666665 |  | 99779.32002999997 |  | 49889.66001499999 |  | Megamall
[NAME] | 1795397.75 | 1411927 | 1730235 | 1499901.25 | 2295487.5 | 2318016.5 | 2335641.75 | 1595636 | 1513542.5 | 2254856.75 | 1502005.25 | 1379868.5 | 21632515.75 |  | 1350000 |  | 1802709.645833333 |  | 72108.38583333333 |  | 108162.57875 |  | 54081.28937499999 |  | [NAME]
Pampanga | 162096 | 576422 | 376867.75 | 595867.75 | 469613.5 | 692620.503 | 524311 | 809575.75 | 260021.75 | 486337.25 | 627100.25 | 754385.75 | 6335219.253 |  | 300000 |  | 527934.93775 |  | 21117.39751 |  | 31676.096265 |  | 15838.0481325 |  | Pampanga
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME]
Savemore Tanay | 115688 |  |  |  |  |  |  |  |  |  |  |  | 115688 |  |  |  | 115688 |  | 4627.52 |  | 6941.28 |  | 3470.64 |  | Savemore Tanay
Southmall | 1309537.75 | 615966 | 842218.5 | 949893.75 | 798282.25 | 1468704.25 | 931779.25 | 1039739.75 | 17499 | 374975 | 327175 | 460871 | 9136641.5 |  | 750000 |  | 761386.7916666666 |  | 30455.47166666666 |  | 45683.2075 |  | 22841.60375 |  | Southmall
Sta. Mesa (Linen) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Sta. Mesa (Linen)
Sucat (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Sucat (Added to [NAME])
 | 8091703 | 7664994.25 | 14590386.75 | 9795438 | 12301532.253 | 12833609.503 | 10925016.25 | 11168375.25 | 8639064 | 9628837.75 | 8029233.753 | 8767863.75 | 122436054.509 |  | 8820000 |  | 10341455.40984091 |  | 413658.2163936364 | 0 | 620487.3245904546 |  | 310243.6622952273
Homeworld Linen 2010 Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2011 Sales Forecast
2010 Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 Mo. |  | 2010 Ave. |  | 2011 Mo. GDP |  | 2011 New |  | 2010 & 2011 |  | Branch | Promo | 2011 Monthly Sales Forecast
Branch | January | February | March | April | May | June | July | August | September | October | November | December | Total |  | Forecast |  | Sales |  | Forecast (4%) |  | Promo (6%) |  | Promo (3%) |  |  | YES/NO | January | February | March | April | May | June | July | August | September | October | November | December | Total
Bacoor | 317015.75 | 393863.75 | 201275.75 | 952315.75 | 672754.25 | 1159359.5 | 1077480.25 | 1729711.5 | 1442017.75 | 227083 | 614726.5 | 712660.75 | 9500264.5 |  | 470000 |  | 791688.7083333334 |  | 31667.54833333334 |  | 47501.3225 |  | 23750.66125 |  | Bacoor
Baguio | 255282.25 | 315267.5 | 361754.75 | 644756 | 335961.25 | 512456.25 | 430278.25 | 206499.75 | 141862.25 | 320721.75 | 331996.5 | 305587.5 | 4162424 |  | 375000 |  | 346868.6666666667 |  | 13874.74666666667 |  | 20812.12 |  | 10406.06 |  | Baguio
[NAME] | 338363.75 | 0 | 89394.25 | 60784.75 | 242888.25 | 144267.25 | 183714 | 401406 | 241759 | 93699.5 | 0 | 139556.25 | 1935833 |  | 220000 |  | 161319.4166666667 |  | 6452.776666666667 |  | 9679.164999999999 |  | 4839.5825 |  | [NAME]
Batangas | 120108.5 | 275606 | 128584.75 | 339655.25 | 312742.25 | 217356.25 | 298750 | 213487 | 220471.25 | 322620.75 | 170638 | 79194.75 | 2699214.75 |  | 240000 |  | 224934.5625 |  | 8997.3825 |  | 13496.07375 |  | 6748.036875 |  | Batangas
Bicutan (Added to Bicutan Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Bicutan (Added to Bicutan Furn)
Calamba 2010 New Branch |  |  |  |  |  | 0 |  |  |  | 430193.5 | 153960.25 | 301439.5 | 885593.25 |  |  |  | 221398.3125 |  | 8855.9325 |  | 13283.89875 |  | 6641.949375 |  | Calamba 2010 New Branch
[NAME] | 385624.75 | 323600.25 | 427740.75 | 887528.25 | 197401.25 | 490321.5 | 430027.75 | 477405.25 | 309931.5 | 551973.25 | 233254 | 606660 | 5321468.5 |  | 375000 |  | 443455.7083333333 |  | 17738.22833333333 |  | 26607.3425 |  | 13303.67125 |  | [NAME]
Cw Sucat - Bacolod |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Bacolod
Cw Sucat - Baguio |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Baguio
Cw Sucat - Batangas (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Batangas (Added to [NAME])
Cw Sucat - Cagayan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Cagayan
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME]
Cw Sucat - Delgado (Iloilo) (Added to Delgado) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Delgado (Iloilo) (Added to Delgado)
[NAME]  (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME]  (Added to [NAME])
Cw Sucat - Iloilo (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Iloilo (Added to [NAME])
[NAME] (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME] (Added to [NAME])
Cw Sucat - Naga |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Naga
Cw Sucat - Rosales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Cw Sucat - Rosales
[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME]. [NAME]
Cw Sucat - Vizmin | 201880.5 | 172186.5 | 585969 | 887017.5 | 470572.5 | 1057022 | 1322510.75 | 655050.75 | 1809669.75 | 533781.75 | 0 | 0 | 7695661 |  |  |  | 641305.0833333334 |  | 25652.20333333333 |  | 38478.305 |  | 19239.1525 |  | Cw Sucat - Vizmin
Dasmarinas | 177710.5 | 448911 | 866973.75 | 773159 | 1178173.5 | 452697.25 | 667919 | 555124 | 933784 | 316516.25 | 180992.75 | 359230.25 | 6911191.25 |  | 330000 |  | 575932.6041666666 |  | 23037.30416666666 |  | 34555.95625 |  | 17277.978125 |  | Dasmarinas
Delgado (Iloilo) |  |  |  |  | 44294.25 |  |  |  |  |  |  | 129579 | 173873.25 |  | 200000 |  | 86936.625 |  | 3477.465 |  | 5216.1975 |  | 2608.09875 |  | Delgado (Iloilo)
Fairview | 242986 | 560700 | 542449 | 851843 | 1004039.5 | 100265.5 | 416678.75 | 1261033.5 | 376518.5 | 289067.25 | 315063.25 | 673179.5 | 6633823.75 |  | 630000 |  | 552818.6458333334 |  | 22112.74583333333 |  | 33169.11875 |  | 16584.559375 |  | Fairview
[NAME] | 0 | 533702.25 | 407767.5 | 121000 | 678099.25 | 553402.25 | 199474.5 | 322672.5 | 194643.25 | 513172.25 | 479023.5 | 95508 | 4098465.25 |  | 380000 |  | 341538.7708333333 |  | 13661.55083333333 |  | 20492.32625 |  | 10246.163125 |  | [NAME]
[NAME] | 32299 | 170465.5 | 282427 | 182920 | 286967 | 383085.25 | 420312.75 | 425604.75 | 253424.25 | 79436 | 34791 | 158207 | 2709939.5 |  | 200000 |  | 225828.2916666667 |  | 9033.131666666666 |  | 13549.6975 |  | 6774.848749999999 |  | [NAME]
Makati (Added to Makati Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Makati (Added to Makati Furn)
Mall of Asia (Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Mall of Asia (Furn)
Marilao | 487337.75 | 246930 | 424114.25 | 579001.5 | 400349.25 | 265175.5 | 629145.25 | 337900.5 | 554090.25 | 427434.5 | 383852.25 | 406749.5 | 5142080.5 |  | 250000 |  | 428506.7083333333 |  | 17140.26833333333 |  | 25710.4025 |  | 12855.20125 |  | Marilao
Megamall (Added to Megamall Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Megamall (Added to Megamall Furn)
Morong | 565782.75 |  |  |  |  |  |  |  |  |  |  |  | 565782.75 |  | 220000 |  | 565782.75 |  | 22631.31 |  | 33946.965 |  | 16973.4825 |  | Morong
Naga | 39617.5 | 201821 | 97904.5 | 417284.75 | 63592.5 | 181987.5 | 258560.75 | 155288.5 | 322058 | 123753.75 | 0 | 0 | 1861868.75 |  |  |  | 155155.7291666667 |  | 6206.229166666666 |  | 9309.343749999998 |  | 4654.671874999999 |  | Naga
[NAME] (Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | [NAME] (Furn)
Novaliches 2010 New Branch |  |  |  |  |  | 0 |  |  |  | 566749 | 5940 | 96609 | 669298 |  |  |  | 167324.5 |  | 6692.98 |  | 10039.47 |  | 5019.735 |  | Novaliches 2010 New Branch
Pampanga (Added to Pampanga Furn) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Pampanga (Added to Pampanga Furn)
Quiapo | 0 | 131074.5 | 140212.5 | 161047.5 | 190154.75 | 287512 | 308794.75 | 178414 | 220616.75 | 135257.75 | 190428 | 435974.75 | 2379487.25 |  | 240000 |  | 198290.6041666667 |  | 7931.624166666666 |  | 11897.43625 |  | 5948.718124999999 |  | Quiapo
Rosales | 25048.5 | 84092 | 0 | 205051.5 | 0 | 176978 | 262420.25 | 271141 | 219760.5 | 48073.5 | 126382.75 | 71068 | 1490016 |  |  |  | 124168 |  | 4966.72 |  | 7450.08 |  | 3725.04 |  | Rosales
Rosario | 372404.25 | 336116.25 | 130184.75 | 303376.5 | 0 | 338299 | 213838 | 652733.5 | 473230.25 | 334896.5 | 124994.75 | 59494 | 3339567.75 |  |  |  | 278297.3125 |  | 11131.8925 |  | 16697.83875 |  | 8348.919375 |  | Rosario
[NAME] | 615770.75 | 753537.25 | 854975.5 | 841657.5 | 855619 | 1074695.75 | 1547345.5 | 622064.75 | 823173 | 927042.25 | 413339.25 | 1055018.5 | 10384239 |  | 650000 |  | 865353.25 |  | 34614.13 |  | 51921.195 |  | 25960.5975 |  | [NAME]
San Pablo 2010 New Branch |  |  |  |  |  | 0 |  |  | 362686.5 | 43947.75 | 60193 | 93742 | 560569.25 |  |  |  | 112113.85 |  | 4484.554 |  | 6726.831 |  | 3363.4155 |  | San Pablo 2010 New Branch
Southmall (Added to [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Southmall (Added to [NAME])
Sta. Mesa | 534479.5 | 1328861 | 791128.25 | 1270009 | 1034067 | 1851491.25 | 1266284 | 1161565 | 935240.5 | 682044.75 | 88211 | 1600593.25 | 12543974.5 |  | 700000 |  | 1045331.208333333 |  | 41813.24833333334 |  | 62719.8725 |  | 31359.93625 |  | Sta. Mesa
Sta. [NAME] | 98679 | 767536.75 | 327436.5 | 672367 | 563923.5 | 978270 | 511379.5 | 581194.75 | 756063.5 | 307652 | 299872.25 | 271591.5 | 6135966.25 |  | 450000 |  | 511330.5208333333 |  | 20453.22083333333 |  | 30679.83125 |  | 15339.915625 |  | Sta. [NAME]
Sucat | 208476 |  | 277578 | 598090 | 639037.25 | 394302.25 | 232841.75 | 220696 | 276351.25 | 147908.5 | 159318 | 144086.75 | 3298685.75 |  | 320000 |  | 299880.5227272727 |  | 11995.22090909091 |  | 17992.83136363636 |  | 8996.41568181818 |  | Sucat
Tanay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Tanay
Tarlac 2010 New Branch |  |  |  | 293046 | 734044.25 | 929363.25 | 374300.5 | 367446.25 | 624015.25 | 104429.5 | 337087.5 | 491372.75 | 4255105.25 |  |  |  | 472789.4722222222 |  | 18911.57888888889 |  | 28367.36833333334 |  | 14183.68416666667 |  | Tarlac 2010 New Branch
Taytay | 122694 | 434232.75 | 1012156.5 | 0 | 181612.75 | 751995.25 | 461024.25 | 582417.25 | 370962.75 | 0 | 0 | 215110.25 | 4132205.75 |  | 250000 |  | 344350.4791666667 |  | 13774.01916666667 |  | 20661.02875 |  | 10330.514375 |  | Taytay
 | 5141561 | 7478504.25 | 7950027.25 | 11041910.75 | 10086293.5 | 12300302.75 | 11513080.5 | 11378856.5 | 11862330 | 7527455 | 4704064.5 | 8502212.75 | 109486598.75 |  | 6500000 |  | 10182700.30328283 |  | 407308.0121313131 |  | 610962.0181969696 |  | 305481.0090984848
OUR HOME 2010 SALES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Our Home 2011 Sales Forecast
2010 Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 Mo. |  | 2010 Ave. |  | 2011 Mo. GDP |  | 2011 New |  | 2010 & 2011 |  | Branch | Promo | 2011 Monthly Sales Forecast
Branch | January | February | March | April | May | June | July | August | September | October | November | December | Total |  | Forecast |  | Sales |  | Forecast (4%) |  | Promo (6%) |  | Promo (3%) |  |  | YES/NO | January | February | March | April | May | June | July | August | September | October | November | December | Total
Bacolod | 48834.1 | 120561.63 | 89704.56 | 100329.37 | 128205.5 | 129074.25 | 195555.5 | 236196.31 | 75539.25 | 105950.5 | 173818.86 | 225313.5 | 1629083.33 |  | 180000 |  | 135756.9441666667 |  | 5430.277766666667 |  | 8145.416650000001 |  | 4072.708325000001 |  | Bacolod
Bacoor | 213159.4 | 286919.75 | 432150 | 487340.09 | 584934.6 | 381478.5 | 453898.25 | 496739 | 302133.75 | 601136.05 | 408724.4 | 594695.8 | 5243309.59 |  | 260000 |  | 436942.4658333333 |  | 17477.69863333333 |  | 26216.54795 |  | 13108.273975 |  | Bacoor
Baguio | 269674 | 246923.5 | 214900.3 | 316008.03 | 340048.4 | 368417.5 | 321741.46 | 378586.74 | 169249.5 | 284564.4 | 462312.9 | 438899.3250000001 | 3811326.055 |  | 230000 |  | 317610.5045833333 |  | 12704.42018333333 |  | 19056.630275 |  | 9528.3151375 |  | Baguio
Batangas | 298067.55 | 137655 | 311196.06 | 458742.75 | 422500.94 | 421439 | 405567.03 | 389710.78 | 263989.75 | 492390 | 595622.12 | 532139.25 | 4729020.23 |  | 240000 |  | 394085.0191666667 |  | 15763.40076666667 |  | 23645.10115 |  | 11822.550575 |  | Batangas
Cagayan de Oro | 152098.4 | 154154 | 259007.99 | 234566 | 221656.05 | 148480 | 152738.25 | 210186.78 | 156365 | 114290.75 | 228886.55 | 127354.75 | 2159784.52 |  | 180000 |  | 179982.0433333333 |  | 7199.281733333333 |  | 10798.9226 |  | 5399.4613 |  | Cagayan de Oro
Cebu | 438913.75 | 201948.25 | 213994.37 | 316401.8 | 388369.35 | 320599.25 | 324081.13 | 482995.31 | 76789 | 91997.75 | 238224.7 | 170307.1 | 3264621.76 |  | 220000 |  | 272051.8133333334 |  | 10882.07253333333 |  | 16323.1088 |  | 8161.5544 |  | Cebu
[NAME] | 156143.05 | 236324.5 | 189386.67 | 458162.75 | 339150.34 | 537469.5 | 324070.81 | 357804.93 | 170645 | 523652.25 | 374497.15 | 413615.875 | 4080922.825 |  | 200000 |  | 340076.9020833333 |  | 13603.07608333333 |  | 20404.614125 |  | 10202.3070625 |  | [NAME]
[NAME] | 300694.55 | 323015 | 577330.05 | 362709.62 | 392314 | 478060 | 463400 | 353373.5 | 245748.75 | 522066.25 | 458665.75 | 395211.5 | 4872588.970000001 |  | 280000 |  | 406049.0808333334 |  | 16241.96323333334 |  | 24362.94485 |  | 12181.472425 |  | [NAME]
Fairview | 287251.6 | 446554.39 | 537746.74 | 571785 | 571890.35 | 532588.5 | 637426 | 664006.5 | 378570 | 353890 | 492497.25 | 722174.775 | 6196381.105 |  | 400000 |  | 516365.0920833334 |  | 20654.60368333333 |  | 30981.905525 |  | 15490.9527625 |  | Fairview
Iloilo | 149564.25 | 174089.75 | 217028.75 | 190739.75 | 441274.8 | 497857.75 | 128770.8 | 119040.06 | 200488 | 213069.75 | 160885.3 | 178976.55 | 2671785.51 |  | 180000 |  | 222648.7925 |  | 8905.9517 |  | 13358.92755 |  | 6679.463774999999 |  | Iloilo
[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 |  | 250000 |  | 417094.7541666667 |  | 16683.79016666667 |  | 25025.68525 |  | 12512.842625 |  | [NAME]
Mall of Asia | 269741.1 | 117985 | 461221.55 | 329647 | 261271.25 | 289129.75 | 248859 | 416751.5 | 346573.75 | 303870.53 | 335257.5 | 312117.75 | 3692425.68 |  | 200000 |  | 307702.14 |  | 12308.0856 |  | 18462.1284 |  | 9231.064199999999 |  | Mall of Asia
Marilao | 275951.8 | 264819.75 | 570427.93 | 333581.5 | 610862.14 | 354809.75 | 532490.53 | 401170.25 | 470474.25 | 653370.8 | 449100.78 | 479471 | 5396530.48 |  | 300000 |  | 449710.8733333334 |  | 17988.43493333333 |  | 26982.6524 |  | 13491.3262 |  | Marilao
Megamall | 418578.75 | 453869.5 | 699479.93 | 1077073.43 | 905545.85 | 745754.5 | 671605.85 | 647296 | 582735.5 | 1112538.25 | 661118.25 | 798457.025 | 8774052.835 |  | 400000 |  | 731171.0695833334 |  | 29246.84278333334 |  | 43870.264175 |  | 21935.1320875 |  | Megamall
[NAME] | 749315 | 298267.1 | 582148.1 | 582568.25 | 630359.11 | 702749.75 | 804169.41 | 502816.75 | 332357.85 | 416625.53 | 823356.6 | 636666.3 | 7061399.749999999 |  | 390000 |  | 588449.9791666666 |  | 23537.99916666666 |  | 35306.99875 |  | 17653.499375 |  | [NAME]
Pampanga | 215968.75 | 302576.25 | 347559.5 | 221500.28 | 316478.5 | 399469.5 | 263844 | 451818 | 185580 | 76946 | 163775.95 | 140767 | 3086283.73 |  | 210000 |  | 257190.3108333334 |  | 10287.61243333334 |  | 15431.41865 |  | 7715.709325000001 |  | Pampanga
[NAME] | 105144.8 | 137190 | 244412.87 | 244406.87 | 439159.4 | 610008.75 | 529720.9 | 242914.25 | 180419.5 | 452587.75 | 431716.25 | 371745.75 | 3989427.09 |  | 200000 |  | 332452.2575 |  | 13298.0903 |  | 19947.13545 |  | 9973.567724999999 |  | [NAME]
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 |  | 250000 |  | 259890.3375 |  | 10395.6135 |  | 15593.42025 |  | 7796.710125 |  | Southmall
Sta. [NAME] | 666076 | 557705.55 | 640918.99 | 780611.12 | 793405.5 | 832788.5 | 979836.5 | 722287.5 | 576679.5 | 737803.75 | 966913.75 | 1143002.75 | 9398029.41 |  | 400000 |  | 783169.1175 |  | 31326.7647 |  | 46990.14705 |  | 23495.073525 |  | Sta. [NAME]
Virramall | 231475.75 | 163069.75 | 564691 | 588259.75 | 514810.6 | 380863.5 | 601887.78 | 411783.5 | 335912.25 | 460117.5 | 386384.5 | 364729.55 | 5003985.43 |  | 260000 |  | 416998.7858333333 |  | 16679.95143333333 |  | 25019.92715 |  | 12509.963575 |  | Virramall
 | 5726480.600000001 | 5095380.67 | 7606157.29 | 8306038.920000001 | 9363259.479999999 | 8808477.75 | 8836513.91 | 8131541.94 | 5781953.699999999 | 8127519.590000001 | 8598419.7 | 8803035.850000001 | 93184779.4 |  | 5230000 |  | 7765398.283333334 |  | 310615.9313333334 |  | 465923.8970000001 |  | 232961.9485000001