Spreadsheet: 213636d1360599731-show-data-based-on-selected-parameters-table6
Sheet: DATA

JANUARY 2013
GHA BRAND | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Hotel10 | Hotel11 | Hotel12 | Hotel13 | Hotel14 | Hotel15 | Hotel16 | Hotel17 | Hotel18 | Hotel19 | Hotel20 | Hotel21 | Hotel22 | Hotel23 | Hotel24 | Grand Total
Brand1 | 775.6969499999999 |  |  |  |  | 210.46095586 |  |  | 770 |  |  |  |  |  |  | 542.523793 |  |  |  |  |  | 744
Brand2 |  |  |  |  |  |  | 258.2685 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196.4336895
Brand3 |  |  |  |  |  |  | 467.343 |  |  |  |  |  |  |  |  | 263.0819825 |  |  |  | 562 |  | 680
Brand4 | 1809.592647 | 10223.2312 | 7789.74058 | 12851.538044688 |  | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 13757.760822 | 23651.6820345 | 10960.878976 | 22536.7522965 | 4834.52090898 | 12586.46 | 35480.78 | 983.73315456 | 10452.96 | 46052.18271450001 | 12179.4417935
Brand5 | 914.3999999999999 |  | 531.195915 | 691.561756368 |  | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464 |  | 0 | 1268.5940525 |  | 745.569909 | 2507 | 3119.45 |  | 1792 | 390.9896
Brand6 | 679.1096399999999 | 731.3199999999999 |  |  |  | 908.489415525 |  | 4673.76 | 18789 |  |  |  |  |  | 234.117 |  |  |  | 4571.6 | 1125 |  | 1370
Brand7 |  |  | 878.81206 | 2034.254467728 |  |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 |  | 408.4938 | 309.8463965 |  | 360.782873355 | 7422.3 | 3445.47 |  | 741
Brand8 |  |  | 3299.218319 | 245.8536192 |  | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 563.914 | 3009.21075 | 5422.897136999999 | 2260.44 |  | 1635.8 | 1280.13 |  |  | 10095.119965 | 8924.749188
Brand9 | 184.68975 | 554.5584 |  |  |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 2564.5828 |  |  |  |  | 2044 | 2191.5 |  |  | 140.3061035 | 560.066879
Brand10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15730.8984495 | 10022.092368 | 10135.97442 | 701.864896104 | 18388.66 | 14058.24 |  | 6269.190000000001 | 4335.444450499999 | 1855.322821
Brand11 | 4865.356029999999 | 433.8128 | 1024.128 | 2989.37151072 | 653.4960768 | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 821.353
Brand12 |  |  |  |  |  |  | 590.328 |  | 1710
Brand13
Grand Total
FEBRUARY 2013
GHA BRAND | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Hotel10 | Hotel11 | Hotel12 | Hotel13 | Hotel14 | Hotel15 | Hotel16 | Hotel17 | Hotel18 | Hotel19 | Hotel20 | Hotel21 | Hotel22 | Hotel23 | Hotel24 | Grand Total
Brand1 | 210.46095586 |  |  | 770 |  |  |  |  |  |  | 542.523793 |  |  |  |  |  | 744 |  |  | 542.523793
Brand2 |  | 258.2685 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196.4336895
Brand3 |  | 467.343 |  |  |  |  |  |  |  |  | 263.0819825 |  |  |  | 562 |  | 680 |  |  | 263.0819825 |  |  |  | 562
Brand4 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 13757.760822 | 23651.6820345 | 10960.878976 | 22536.7522965 | 4834.52090898 | 12586.46 | 35480.78 | 983.73315456 | 10452.96 | 46052.18271450001 | 12179.4417935 | 10960.878976 | 22536.7522965 | 4834.52090898 | 12586.46 | 35480.78
Brand5 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464 |  | 0 | 1268.5940525 |  | 745.569909 | 2507 | 3119.45 |  | 1792 | 390.9896 |  | 1268.5940525 |  | 745.569909 | 2507 | 3119.45
Brand6 | 908.489415525 |  | 4673.76 | 18789 |  |  |  |  |  | 234.117 |  |  |  | 4571.6 | 1125 |  | 1370 |  |  |  |  |  | 4571.6 | 1125
Brand7 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 |  | 408.4938 | 309.8463965 |  | 360.782873355 | 7422.3 | 3445.47 |  | 741 |  |  | 309.8463965 |  | 360.782873355 | 7422.3 | 3445.47
Brand8 | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 563.914 | 3009.21075 | 5422.897136999999 | 2260.44 |  | 1635.8 | 1280.13 |  |  | 10095.119965 | 8924.749188 | 5422.897136999999 | 2260.44 |  | 1635.8 | 1280.13
Brand9 | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 2564.5828 |  |  |  |  | 2044 | 2191.5 |  |  | 140.3061035 | 560.066879 |  |  |  | 2044 | 2191.5
Brand10 |  |  |  |  |  |  |  |  |  | 15730.8984495 | 10022.092368 | 10135.97442 | 701.864896104 | 18388.66 | 14058.24 |  | 6269.190000000001 | 4335.444450499999 | 1855.322821 | 10022.092368 | 10135.97442 | 701.864896104 | 18388.66 | 14058.24
Brand11 | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 821.353
Brand12 |  | 590.328 |  | 1710
Brand13
Grand Total
MARCH 2013
GHA BRAND | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Hotel10 | Hotel11 | Hotel12 | Hotel13 | Hotel14 | Hotel15 | Hotel16 | Hotel17 | Hotel18 | Hotel19 | Hotel20 | Hotel21 | Hotel22 | Hotel23 | Hotel24 | Grand Total
Brand1 | 542.523793 | 210.46095586 |  |  | 770 |  |  |  |  |  |  | 542.523793 |  |  |  |  |  | 744 |  |  |  |  |  |  | 3042.68169886
Brand2 |  |  | 258.2685 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196.4336895 |  |  |  |  |  | 454.7021895
Brand3 | 263.0819825 |  | 467.343 |  |  |  |  |  |  |  |  | 263.0819825 |  |  |  | 562 |  | 680 |  |  |  |  |  |  | 1972.4249825
Brand4 | 10960.878976 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 13757.760822 | 23651.6820345 | 10960.878976 | 22536.7522965 | 4834.52090898 | 12586.46 | 35480.78 | 983.73315456 | 10452.96 | 46052.18271450001 | 12179.4417935 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 433901.489903083
Brand5 | 1268.5940525 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464 |  | 0 | 1268.5940525 |  | 745.569909 | 2507 | 3119.45 |  | 1792 | 390.9896 |  | 1894.4882712 | 1639.0283 |  | 1421.6652464 | 35529.147932203
Brand6 |  | 908.489415525 |  | 4673.76 | 18789 |  |  |  |  |  | 234.117 |  |  |  | 4571.6 | 1125 |  | 1370 |  |  |  |  |  |  | 33082.396055525
Brand7 | 309.8463965 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 |  | 408.4938 | 309.8463965 |  | 360.782873355 | 7422.3 | 3445.47 |  | 741 |  |  | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 | 44046.832519583
Brand8 | 5422.897136999999 | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 563.914 | 3009.21075 | 5422.897136999999 | 2260.44 |  | 1635.8 | 1280.13 |  |  | 10095.119965 | 8924.749188 |  |  |  |  | 65406.74038268999
Brand9 |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 2564.5828 |  |  |  |  | 2044 | 2191.5 |  |  | 140.3061035 | 560.066879 |  |  | 1267.5806 |  | 32591.369041805
Brand10 | 10022.092368 |  |  |  |  |  |  |  |  |  | 15730.8984495 | 10022.092368 | 10135.97442 | 701.864896104 | 18388.66 | 14058.24 |  | 6269.190000000001 | 4335.444450499999 | 1855.322821 |  |  |  |  | 81497.687405104
Brand11 |  | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 821.353 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1294.4456896 | 42691.487894335
Brand12 |  |  | 590.328 |  | 1710 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2300.328
Brand13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Grand Total
APRIL 2013
GHA BRAND | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Hotel10 | Hotel11 | Hotel12 | Hotel13 | Hotel14 | Hotel15 | Hotel16 | Hotel17 | Hotel18 | Hotel19 | Hotel20 | Hotel21 | Hotel22 | Hotel23 | Hotel24 | Grand Total
Brand1 | 770 |  | 210.46095586 |  |  | 770 |  |  |  |  |  |  | 542.523793 |  |  |  |  |  | 744 |  |  | 542.523793 |  |  | 3042.68169886
Brand2 |  |  |  | 258.2685 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 196.4336895 |  |  |  |  | 454.7021895
Brand3 |  |  |  | 467.343 |  |  |  |  |  |  |  |  | 263.0819825 |  |  |  | 562 |  | 680 |  |  | 263.0819825 |  |  | 1972.4249825
Brand4 | 84014.70999999999 | 302.0938396 | 42795.82287275499 | 13891.4632125 | 9183.68 | 84014.70999999999 | 302.0938396 | 27763.81543 | 27170.23465 | 2628.414726 | 13757.760822 | 23651.6820345 | 10960.878976 | 22536.7522965 | 4834.52090898 | 12586.46 | 35480.78 | 983.73315456 | 10452.96 | 46052.18271450001 | 12179.4417935 | 10960.878976 | 22536.7522965 | 4834.52090898 | 433901.489903083
Brand5 | 16245 | 1894.4882712 | 1372.204881735 |  | 996 | 16245 | 1894.4882712 | 1639.0283 |  | 1421.6652464 |  | 0 | 1268.5940525 |  | 745.569909 | 2507 | 3119.45 |  | 1792 | 390.9896 |  | 1268.5940525 |  | 745.569909 | 35529.147932203
Brand6 | 18789 |  | 908.489415525 |  | 4673.76 | 18789 |  |  |  |  |  | 234.117 |  |  |  | 4571.6 | 1125 |  | 1370 |  |  |  |  |  | 33082.396055525
Brand7 | 6882 | 388.1046147999999 |  |  | 5799 | 6882 | 388.1046147999999 | 5700.434999999999 |  | 9676.333307200002 |  | 408.4938 | 309.8463965 |  | 360.782873355 | 7422.3 | 3445.47 |  | 741 |  |  | 309.8463965 |  | 360.782873355 | 44046.832519583
Brand8 | 12596.56 |  | 14960.84740449 |  | 1112 | 12596.56 |  |  |  |  | 563.914 | 3009.21075 | 5422.897136999999 | 2260.44 |  | 1635.8 | 1280.13 |  |  | 10095.119965 | 8924.749188 | 5422.897136999999 | 2260.44 |  | 65406.74038268999
Brand9 | 1660 |  | 3773.680753805 | 12799.8237555 | 4850.58 | 1660 |  |  | 1267.5806 |  | 2564.5828 |  |  |  |  | 2044 | 2191.5 |  |  | 140.3061035 | 560.066879 |  |  |  | 32591.369041805
Brand10 |  |  |  |  |  |  |  |  |  |  |  | 15730.8984495 | 10022.092368 | 10135.97442 | 701.864896104 | 18388.66 | 14058.24 |  | 6269.190000000001 | 4335.444450499999 | 1855.322821 | 10022.092368 | 10135.97442 | 701.864896104 | 81497.687405104
Brand11 | 15656.52 |  | 8116.074787215 |  | 6836.929999999999 | 15656.52 |  |  |  | 1294.4456896 | 821.353 |  |  |  |  |  |  |  |  |  |  |  |  |  | 42691.487894335
Brand12 | 1710 |  |  | 590.328 |  | 1710 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2300.328
Brand13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Grand Total