Spreadsheet: 213772d1360645905-show-data-based-from-selected-parameters-in-drop-down-dropdown
Sheet: SOURCE

JANUARY 2013 | Branch1 | Branch2 | Branch3 | Branch4 | Branch5 | Branch6 | Branch7 | Branch8 | Branch9 | Grand Total
Brand1 | 775.6969499999999 |  |  |  |  | 210.46095586 |  |  | 770
Brand2 |  |  |  |  |  |  | 258.2685
Brand3 |  |  |  |  |  |  | 467.343
Brand4 | 1809.592647 | 10223.2312 | 7789.74058 | 12851.538044688 |  | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999
Brand5 | 914.3999999999999 |  | 531.195915 | 691.561756368 |  | 1372.204881735 |  | 996 | 16245
Brand6 | 679.1096399999999 | 731.3199999999999 |  |  |  | 908.489415525 |  | 4673.76 | 18789
Brand7 |  |  | 878.81206 | 2034.254467728 |  |  |  | 5799 | 6882
Brand8 |  |  | 3299.218319 | 245.8536192 |  | 14960.84740449 |  | 1112 | 12596.56
Brand9 | 184.68975 | 554.5584 |  |  |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660
Brand10
Brand11 | 4865.356029999999 | 433.8128 | 1024.128 | 2989.37151072 | 653.4960768 | 8116.074787215 |  | 6836.929999999999 | 15656.52
Brand12 |  |  |  |  |  |  | 590.328 |  | 1710
Brand13
Grand Total
FEBRUARY 2013 | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Grand Total
Brand1 | 210.46095586 |  |  | 770
Brand2 |  | 258.2685
Brand3 |  | 467.343
Brand4 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 13757.760822
Brand5 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464
Brand6 | 908.489415525 |  | 4673.76 | 18789
Brand7 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002
Brand8 | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 563.914
Brand9 | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 2564.5828
Brand10
Brand11 | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 821.353
Brand12 |  | 590.328 |  | 1710
Brand13
Grand Total
MARCH 2013 | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Grand Total
Brand1 | 542.523793 | 210.46095586 |  |  | 770 |  |  |  |  | 3042.68169886
Brand2 |  |  | 258.2685 |  |  |  |  |  |  | 454.7021895
Brand3 | 263.0819825 |  | 467.343 |  |  |  |  |  |  | 1972.4249825
Brand4 | 10960.878976 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 433901.489903083
Brand5 | 1268.5940525 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464 | 35529.147932203
Brand6 |  | 908.489415525 |  | 4673.76 | 18789 |  |  |  |  | 33082.396055525
Brand7 | 309.8463965 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 | 44046.832519583
Brand8 | 5422.897136999999 | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 65406.74038268999
Brand9 |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 32591.369041805
Brand10 | 10022.092368 |  |  |  |  |  |  |  |  | 81497.687405104
Brand11 |  | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 42691.487894335
Brand12 |  |  | 590.328 |  | 1710 |  |  |  |  | 2300.328
Brand13 |  |  |  |  |  |  |  |  |  | 0
Grand Total
APRIL 2013 | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Grand Total
Brand1 | 770 |  | 210.46095586 |  |  | 770 |  |  |  | 3042.68169886
Brand2 |  |  |  | 258.2685 |  |  |  |  |  | 454.7021895
Brand3 |  |  |  | 467.343 |  |  |  |  |  | 1972.4249825
Brand4 | 84014.70999999999 | 302.0938396 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 433901.489903083
Brand5 | 16245 | 1894.4882712 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 35529.147932203
Brand6 | 18789 |  | 908.489415525 |  | 4673.76 | 18789 |  |  |  | 33082.396055525
Brand7 | 6882 | 388.1046147999999 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 44046.832519583
Brand8 | 12596.56 |  | 14960.84740449 |  | 1112 | 12596.56 |  |  |  | 65406.74038268999
Brand9 | 1660 |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 | 32591.369041805
Brand10 |  |  |  |  |  |  |  |  |  | 81497.687405104
Brand11 | 15656.52 |  | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 42691.487894335
Brand12 | 1710 |  |  | 590.328 |  | 1710 |  |  |  | 2300.328
Brand13 |  |  |  |  |  |  |  |  |  | 0
Grand Total