I want to know if it is possible to calculate the Estimated Special Events on the far right column using the variables on the left. Essentially what is needed is to use the start and stop time to sum the "% of Total" and divide each hour inside that range by the Sum of % of Total in the range. In this example the total would be 34.48%. So the new adjusted % within the Day Hour range for 8am would be 3.6/34.48 = 10.45%. Then taking the Total Special Events and multiplying it by the % during hours (in this case 10%) to get the number to multiply times 10.45%. This means for 8am the calculation would now be 150*.10*.1045 = 1.568
| Variables | Hour of Day | Number of Events | % of Total | Adjusted % within range | Estimated Special Events | ||
|---|---|---|---|---|---|---|---|
| Day Start Hour | 8 | 0 | 86 | 7.04% | 10.75% | 14.5125 | |
| Day Stop Hour | 17 | 1 | 10 | 0.82% | 1.25% | 1.6875 | |
| % of special events after business hours | 90% | 2 | 63 | 5.16% | 7.88% | 10.63125 | |
| Total Special Events a Day | 150 | 3 | 50 | 4.10% | 6.25% | 8.4375 | |
4 | 5 | 0.41% | 0.63% | 0.84375 | |||
5 | 59 | 4.83% | 7.38% | 9.95625 | |||
6 | 80 | 6.55% | 10.00% | 13.5 | |||
7 | 43 | 3.52% | 5.38% | 7.25625 | |||
8 | 44 | 3.60% | 10.45% | 1.567695962 | |||
9 | 18 | 1.47% | 4.28% | 0.641330166 | |||
10 | 98 | 8.03% | 23.28% | 3.491686461 | |||
11 | 76 | 6.22% | 18.05% | 2.70783848 | |||
12 | 75 | 6.14% | 17.81% | 2.672209026 | |||
13 | 21 | 1.72% | 4.99% | 0.748218527 | |||
14 | 58 | 4.75% | 13.78% | 2.066508314 | |||
15 | 22 | 1.80% | 5.23% | 0.783847981 | |||
16 | 9 | 0.74% | 2.14% | 0.320665083 | |||
17 | 51 | 4.18% | 6.38% | 8.60625 | |||
18 | 74 | 6.06% | 9.25% | 12.4875 | |||
19 | 87 | 7.13% | 10.88% | 14.68125 | |||
20 | 91 | 7.45% | 11.38% | 15.35625 | |||
21 | 32 | 2.62% | 4.00% | 5.4 | |||
22 | 59 | 4.83% | 7.38% | 9.95625 | |||
23 | 10 | 0.82% | 1.25% | 1.6875 |
