Spreadsheet: 217714d1362157637-why-am-i-getting-two-different-reselts-when-i-use-two-different-methods-with-the-same-data-excel-febdaily-call-around
Sheet: FEB Dashboard Data II

 |  | Pottstown |  |  |  |  | Limerick |  |  | Oaks |  |  | King of Prussia |  |  | Exton
 |  | Comfort inn & Suites | Motel 6 | Quality Inn | Day Inn Pottstown |  | Holiday Inn Express | Staybridge Suites |  | [NAME] | [NAME] |  | Best Western | [NAME] |  | [NAME] | [NAME] | Holiday Inn
2013-02-01 00:00:00 | Occupancy Percent | 0.65 | 0.96 | 0.27 | 0.35 |  | 1 | 0.5 |  | 0.52 | 0.2 |  | 0.24 | 0.17 |  | 0.35 | 0.24 | 0.21
2013-02-01 00:00:00 | BAR | 109 | 79.99 | 69 | 69 |  | 109 | 154 |  | 109 | 99 |  | 99 | 109 |  | 100 | 109 | 109
2013-02-01 00:00:00 | Rooms Sold | 77 | 45.12 | 26.46 | 42.7 |  | 71 | 52.5 |  | 55.64 | 27 |  | 40.08 | 25.16 |  | 31.85 | 24.96 | 26.04
2013-02-02 00:00:00 | Occupancy Percent | 0.39 | 0.89 | 0.18 | 0.35 |  | 0.48 | 0.6 |  | 0.92 | 0.52 |  | 0.25 | 0.26 |  | 0.25 | 0.27 | 0.18
2013-02-02 00:00:00 | BAR | 109 | 79.99 | 69.99 | 69 |  | 119 | 134 |  | 109 | 99 |  | 99 | 109 |  | 90 | 109 | 138
2013-02-02 00:00:00 | Rooms Sold | 46.41 | 41.83 | 17.64 | 42.7 |  | 34.08 | 63 |  | 98.44 | 70.2 |  | 41.75 | 38.48 |  | 22.75 | 28.08 | 22.32
3013-02-03 00:00:00 | Occupancy Percent | 0.31 | 0.26 | 0.21 | 0.27 |  | 0.52 | 0.48 |  | 1 | 0.88 |  | 0.22 | 0.19 |  | 0.19 | 0.2 | 0.28
3013-02-03 00:00:00 | BAR | 99 | 69 | 69 | 69 |  | 129 | 154 |  | 119 | 159 |  | 139 | 119 |  | 100 | 119 | 139
3013-02-03 00:00:00 | Rooms Sold | 36.89 | 12.22 | 20.58 | 32.94 |  | 36.92 | 50.4 |  | 107 | 118.8 |  | 36.74 | 28.12 |  | 17.29 | 20.8 | 34.72000000000001
2013-02-04 00:00:00 | Occupancy Percent | 0.55 | 0.27 | 0.21 | 0.29 |  | 0.29 | 0.83 |  | 0.96 | 1 |  | 0.38 | 0.66 |  | 0.41 | 0.56 | 0.6
2013-02-04 00:00:00 | BAR | 109 | 69 | 69 | 89 |  | 89 | 154 |  | 149 | 179 |  | 149 | 139 |  | 100 | 129 | 139
2013-02-04 00:00:00 | Rooms Sold | 65.45 | 12.69 | 20.58 | 35.38 |  | 20.59 | 87.14999999999999 |  | 102.72 | 135 |  | 63.46 | 97.68 |  | 37.31 | 58.24000000000001 | 74.39999999999999
2013-02-05 00:00:00 | Occupancy Percent | 0.6 | 0.08 | 0.21 | 0.3 |  | 1 | 0.82 |  | 0.72 | 0.77 |  | 0.38 | 0.76 |  | 0.4 | 0.81 | 0.79
2013-02-05 00:00:00 | BAR | 109 | 69.99 | 69.99 | 89 |  | 129 | 154 |  | 149 | 179 |  | 149 | 149 |  | 100 | 139 | 149
2013-02-05 00:00:00 | Rooms Sold | 71.39999999999999 | 3.76 | 20.58 | 36.6 |  | 71 | 86.1 |  | 77.03999999999999 | 103.95 |  | 63.46 | 112.48 |  | 36.4 | 84.24000000000001 | 97.96000000000001
2013-02-06 00:00:00 | Occupancy Percent | 0.6 | 0.11 | 0.25 | 0.28 |  | 0.7 | 0.84 |  | 0.49 | 0.75 |  | 0.38 | 0.65 |  | 0.52 | 0.95 | 0.9
2013-02-06 00:00:00 | BAR | 109 | 70 | 70 | 89 |  | 129 | 154 |  | 149 | 179 |  | 149 | 149 |  | 100 | 139 | 149
2013-02-06 00:00:00 | Rooms Sold | 71.39999999999999 | 5.17 | 24.5 | 34.16 |  | 49.7 | 88.2 |  | 52.43 | 101.25 |  | 63.46 | 96.2 |  | 47.32 | 98.8 | 111.6
2013-02-07 00:00:00 | Occupancy Percent | 0.92 | 0.36 | 0.2 | 0.21 |  | 0.51 | 0.75 |  | 0.4 | 0.58 |  | 0.28 | 0.25 |  | 0.34 | 0.48 | 0.48
2013-02-07 00:00:00 | BAR | 109 | 70 | 70 | 89 |  | 129 | 154 |  | 139 | 169 |  | 139 | 139 |  | 100 | 119 | 139
2013-02-07 00:00:00 | Rooms Sold | 109.48 | 16.92 | 19.6 | 25.62 |  | 36.21 | 78.75 |  | 42.8 | 78.3 |  | 46.76000000000001 | 37 |  | 30.94 | 49.92 | 59.52
2013-02-08 00:00:00 | Occupancy Percent | 0.82 | 0.3 | 0.2 | 0.23 |  | 0.28 | 0.51 |  | 0.32 | 0.65 |  | 0.31 | 0.23 |  | 0.6 | 0.27 | 0.32
2013-02-08 00:00:00 | BAR | 109 | 80 | 70 | 69 |  | 109 | 129 |  | 96 | 129 |  | 91 | 109 |  | 100 | 149 | 139
2013-02-08 00:00:00 | Rooms Sold | 97.58 | 14.1 | 19.6 | 28.06 |  | 19.88 | 53.55 |  | 34.24 | 87.75 |  | 51.77 | 34.04 |  | 54.6 | 28.08 | 39.68
2012-02-09 00:00:00 | Occupancy Percent | 0.38 | 0.13 | 0.22 | 0.35 |  | 0.6 | 0.45 |  | 0.33 | 0.56 |  | 0.18 | 0.3 |  | 0.4 | 0.28 | 0.14
2012-02-09 00:00:00 | BAR | 99 | 80 | 70 | 69 |  | 109 | 129 |  | 109 | 119 |  | 99 | 109 |  | 100 | 119 | 133
2012-02-09 00:00:00 | Rooms Sold | 45.22 | 6.11 | 21.56 | 42.7 |  | 42.6 | 47.25 |  | 35.31 | 75.60000000000001 |  | 30.06 | 44.4 |  | 36.4 | 29.12 | 17.36
2013-02-10 00:00:00 | Occupancy Percent | 0.4 | 0.13 | 0.07 | 0.2 |  | 0.35 | 0.45 |  | 0.28 | 0.19 |  | 0.1 | 0.32 |  | 0.15 | 0.26 | 0.2
2013-02-10 00:00:00 | BAR | 99 | 70 | 70 | 70 |  | 129 | 134 |  | 129 | 159 |  | 139 | 139 |  | 110 | 119 | 133
2013-02-10 00:00:00 | Rooms Sold | 47.6 | 6.11 | 6.86 | 24.4 |  | 24.85 | 47.25 |  | 29.96 | 25.65 |  | 16.7 | 47.36 |  | 13.65 | 27.04 | 24.8
2013-02-11 00:00:00 | Occupancy Percent | 0.51 | 0.1 | 0.19 | 0.29 |  | 0.75 | 0.58 |  | 0.5 | 0.51 |  | 0.2 | 0.72 |  | 0.37 | 0.59 | 0.51
2013-02-11 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 129 | 154 |  | 149 | 159 |  | 149 | 159 |  | 100 | 129 | 134
2013-02-11 00:00:00 | Rooms Sold | 60.69 | 4.7 | 18.62 | 35.38 |  | 53.25 | 60.9 |  | 53.5 | 68.85 |  | 33.4 | 106.56 |  | 33.67 | 61.36 | 63.24
2013-02-12 00:00:00 | Occupancy Percent | 0.5 | 0.23 | 0.14 | 0.34 |  | 0.77 | 0.75 |  | 0.67 | 0.6 |  | 0.28 | 0.82 |  | 0.53 | 0.63 | 0.6
2013-02-12 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 119 | 154 |  | 149 | 169 |  | 149 | 169 |  | 100 | 129 | 113
2013-02-12 00:00:00 | Rooms Sold | 59.5 | 10.81 | 13.72 | 41.48 |  | 54.67 | 78.75 |  | 71.69 | 81 |  | 46.76000000000001 | 121.36 |  | 48.23 | 65.52 | 74.39999999999999
2013-02-13 00:00:00 | Occupancy Percent | 0.44 | 0.23 | 0.2 | 0.39 |  | 0.63 | 0.85 |  | 0.75 | 0.75 |  | 0.24 | 0.7 |  | 0.43 | 0.62 | 0.55
2013-02-13 00:00:00 | BAR | 99 | 69.99 | 69.99 | 79 |  | 119 | 154 |  | 149 | 169 |  | 139 | 169 |  | 100 | 129 | 144
2013-02-13 00:00:00 | Rooms Sold | 52.36 | 10.81 | 19.6 | 47.58 |  | 44.73 | 89.25 |  | 80.25 | 101.25 |  | 40.08 | 103.6 |  | 39.13 | 64.48 | 68.2
2013-02-14 00:00:00 | Occupancy Percent | 0.37 | 0.28 | 0.21 | 0.34 |  | 0.61 | 0.68 |  | 0.81 | 0.75 |  | 0.2 | 0.38 |  | 0.36 | 0.43 | 0.35
2013-02-14 00:00:00 | BAR | 99 | 69.99 | 70 | 79 |  | 119 | 134 |  | 109 | 169 |  | 139 | 139 |  | 100 | 119 | 134
2013-02-14 00:00:00 | Rooms Sold | 44.03 | 13.16 | 20.58 | 41.48 |  | 43.31 | 71.4 |  | 86.67 | 101.25 |  | 33.4 | 56.24 |  | 32.76 | 44.72 | 43.4
2013-02-15 00:00:00 | Occupancy Percent | 0.55 | 0.4 | 0.18 | 0.4 |  | 1 | 0.68 |  | 0.94 | 0.75 |  | 0.46 | 0.46 |  | 0.29 | 0.28 | 0.25
2013-02-15 00:00:00 | BAR | 109 | 80 | 65 | 79 |  | 119 | 149 |  | 109 | 119 |  | 109 | 109 |  | 90 | 119 | 135
2013-02-15 00:00:00 | Rooms Sold | 65.45 | 18.8 | 17.64 | 48.8 |  | 71 | 71.4 |  | 100.58 | 101.25 |  | 76.82000000000001 | 68.08 |  | 26.39 | 29.12 | 31
2013-02-16 00:00:00 | Occupancy Percent | 1 | 0.49 | 0.23 | 1 |  | 1 | 0.92 |  | 1 | 1 |  | 0.39 | 0.62 |  | 0.48 | 0.33 | 0.32
2013-02-16 00:00:00 | BAR | 109 | 80 | 68 | 79 |  | 109 | 149 |  | 119 | 119 |  | 99 | 109 |  | 90 | 109 | 109
2013-02-16 00:00:00 | Rooms Sold | 119 | 23.03 | 22.54 | 62.22 |  | 71 | 87.4 |  | 107 | 132 |  | 52.65 | 91.76 |  | 80.16 | 48.84 | 39.68
2013-02-17 00:00:00 | Occupancy Percent | 0.4 | 0.38 | 0.2 | 0.29 |  | 0.75 | 0.58 |  | 0.41 | 0.65 |  | 0.41 | 0.65 |  | 0.53 | 0.29 | 0.35
2013-02-17 00:00:00 | BAR | 99 | 70 | 70 | 69.99 |  | 119 | 159 |  | 119 | 159 |  | 129 | 139 |  | 120 | 129 | 134
2013-02-17 00:00:00 | Rooms Sold | 47.6 | 17.86 | 19.6 | 35.38 |  | 53.25 | 60.9 |  | 43.87 | 87.75 |  | 20.04 | 50.32 |  | 48.23 | 30.16 | 43.4
2013-02-18 00:00:00 | Occupancy Percent | 0.39 | 0.21 | 0.25 | 0.35 |  | 0.72 | 0.8 |  | 0.36 | 0.55 |  | 0.2 | 0.77 |  | 0.47 | 0.45 | 0.65
2013-02-18 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 119 | 154 |  | 149 | 169 |  | 139 | 159 |  | 120 | 139 | 144
2013-02-18 00:00:00 | Rooms Sold | 46.41 | 9.87 | 24.5 | 42.7 |  | 51.12 | 84 |  | 38.52 | 74.25 |  | 33.4 | 113.96 |  | 42.77 | 46.8 | 80.60000000000001
2013-02-19 00:00:00 | Occupancy Percent | 0.39 | 0.27 | 0.21 | 0.34 |  | 0.7 | 0.71 |  | 0.42 | 0.58 |  | 0.29 | 0.67 |  | 0.44 | 0.41 | 0.47
2013-02-19 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 119 | 154 |  | 149 | 169 |  | 139 | 159 |  | 120 | 139 | 144
2013-02-19 00:00:00 | Rooms Sold | 46.41 | 12.69 | 20.58 | 41.48 |  | 49.7 | 74.55 |  | 44.94 | 78.3 |  | 48.43 | 99.16000000000001 |  | 40.04 | 42.64 | 58.27999999999999
2013-02-20 00:00:00 | Occupancy Percent | 0.5 | 0.19 | 0.22 | 0.43 |  | 0.79 | 0.74 |  | 0.42 | 0.7 |  | 0.33 | 0.78 |  | 0.47 | 0.78 | 0.65
2013-02-20 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 119 | 154 |  | 149 | 169 |  | 139 | 179 |  | 110 | 139 | 95
2013-02-20 00:00:00 | Rooms Sold | 59.5 | 8.93 | 21.56 | 52.46 |  | 56.09 | 77.7 |  | 44.94 | 94.5 |  | 55.11 | 115.44 |  | 42.77 | 81.12 | 80.60000000000001
2013-02-21 00:00:00 | Occupancy Percent | 0.43 | 0.17 | 0.26 | 0.26 |  | 0.53 | 0.53 |  | 0.5 | 0.42 |  | 0.2 | 0.54 |  | 0.35 | 0.43 | 0.55
2013-02-21 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 119 | 134 |  | 109 | 169 |  | 129 | 139 |  | 110 | 139 | 114
2013-02-21 00:00:00 | Rooms Sold | 51.17 | 7.99 | 25.48 | 31.72 |  | 37.63 | 55.65000000000001 |  | 53.5 | 56.7 |  | 33.4 | 79.92 |  | 31.85 | 44.72 | 68.2
2013-02-22 00:00:00 | Occupancy Percent | 0.44 | 0.38 | 0.17 | 0.31 |  | 0.91 | 0.29 |  | 0.5 | 0.29 |  | 0.23 | 0.22 |  | 0.35 | 0.17 | 0.18
2013-02-22 00:00:00 | BAR | 99 | 80 | 70 | 79 |  | 109 | 119 |  | 109 | 119 |  | 99 | 99 |  | 90 | 109 | 99
2013-02-22 00:00:00 | Rooms Sold | 52.36 | 17.86 | 16.66 | 37.82 |  | 64.61 | 30.45 |  | 53.5 | 39.15 |  | 38.41 | 32.56 |  | 31.85 | 17.68 | 22.32
2013-02-23 00:00:00 | Occupancy Percent | 0.41 | 0.23 | 0.15 | 0.26 |  | 1 | 0.42 |  | 0.27 | 0.34 |  | 0.27 | 0.36 |  | 0.43 | 0.18 | 0.32
2013-02-23 00:00:00 | BAR | 99 | 80 | 70 | 80 |  | 129 | 134 |  | 109 | 119 |  | 89 | 99 |  | 90 | 109 | 99
2013-02-23 00:00:00 | Rooms Sold | 48.79 | 10.81 | 14.7 | 31.72 |  | 71 | 44.1 |  | 28.89 | 45.90000000000001 |  | 45.09 | 53.28 |  | 39.13 | 18.72 | 39.68
2013-02-24 00:00:00 | Occupancy Percent | 0.29 | 0.23 | 0.2 | 0.2 |  | 0.34 | 0.52 |  | 0.19 | 0.4 |  | 0.2 | 0.26 |  | 0.24 | 0.3 | 0.36
2013-02-24 00:00:00 | BAR | 99 | 80 | 70 | 80 |  | 129 | 134 |  | 109 | 119 |  | 89 | 99 |  | 90 | 109 | 99
2013-02-24 00:00:00 | Rooms Sold | 34.51 | 10.81 | 19.6 | 24.4 |  | 24.14 | 54.6 |  | 20.33 | 54 |  | 33.4 | 38.48 |  | 21.84 | 31.2 | 44.64
2013-02-25 00:00:00 | Occupancy Percent | 0.4 | 0.19 | 0.12 | 0.31 |  | 0.54 | 0.72 |  | 0.22 | 0.85 |  | 0.4 | 0.71 |  | 0.53 | 0.89 | 0.64
2013-02-25 00:00:00 | BAR | 99 | 70 | 70 | 89 |  | 129 | 154 |  | 149 | 169 |  | 139 | 169 |  | 130 | 134 | 139
2013-02-25 00:00:00 | Rooms Sold | 47.6 | 8.93 | 11.76 | 37.82 |  | 38.34 | 75.6 |  | 23.54 | 114.75 |  | 66.8 | 105.08 |  | 48.23 | 92.56 | 79.36
2013-02-26 00:00:00 | Occupancy Percent | 0.51 | 0.32 | 0.12 | 0.27 |  | 0.59 | 0.7 |  | 0.27 | 0.82 |  | 0.3 | 0.65 |  | 0.74 | 1 | 0.68
2013-02-26 00:00:00 | BAR | 99 | 70 | 70 | 79 |  | 129 | 159 |  | 149 | 189 |  | 139 | 179 |  | 120 | 134 | 149
2013-02-26 00:00:00 | Rooms Sold | 60.69 | 15.04 | 11.76 | 32.94 |  | 41.89 | 73.5 |  | 28.89 | 110.7 |  | 50.1 | 96.2 |  | 67.34 | 104 | 84.32000000000001
2013-02-27 00:00:00 | Occupancy Percent | 0.47 | 0.21 | 0.13 | 0.25 |  | 0.61 | 0.7 |  | 0.26 | 0.8 |  | 0.4 | 0.6 |  | 0.78 | 0.78 | 0.85
2013-02-27 00:00:00 | BAR | 99 | 70 | 70 | 69 |  | 129 | 154 |  | 149 | 189 |  | 139 | 179 |  | 120 | 110 | 149
2013-02-27 00:00:00 | Rooms Sold | 55.93 | 9.87 | 12.74 | 30.5 |  | 43.31 | 73.5 |  | 27.82 | 108 |  | 66.8 | 88.8 |  | 70.98 | 81.12 | 105.4
 | Occupancy Percent
 | BAR
 | Rooms Sold