Spreadsheet: 97919d1297021076-formula-help-for-staffing-issue-onestaff
Sheet: Sheet1

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | average
Time |  | Act Req |  | Act Req |  | Act Req |  | Act Req |  | Act Req |  | Act Req |  | Act Req |  | Actual
08:00:00 |  | 44.41466666666667 |  | 51.10357142857142 |  | 47.22461538461539 |  | 52.97999999999999 |  | 51.99769230769231 |  | 39.27076923076923 |  | 17.04384615384615 |  | 43.43359445316588
08:30:00 |  | 59.13999999999999 |  | 64.48 |  | 59.10076923076922 |  | 64.51692307692308 |  | 79.62384615384615 |  | 51.98615384615385 |  | 21.88538461538462 |  | 57.24758241758241
09:00:00 |  | 82.55199999999999 |  | 82.35142857142856 |  | 76.09615384615384 |  | 77.25692307692309 |  | 103.5576923076923 |  | 75.34384615384616 |  | 27.87 |  | 75.00400627943485
09:30:00 |  | 103.6633333333333 |  | 91.41357142857142 |  | 88.74076923076922 |  | 90.15 |  | 125.1607692307692 |  | 87.0776923076923 |  | 33.69615384615384 |  | 88.55746991104134
10:00:00 |  | 104.9646666666667 |  | 87.41785714285713 |  | 88.45846153846153 |  | 87.70692307692308 |  | 124.5838461538462 |  | 98.01769230769231 |  | 37.34615384615385 |  | 89.78508581894296
10:30:00 |  | 100.57 |  | 84.52214285714284 |  | 88.34538461538462 |  | 89.03846153846153 |  | 121.1384615384615 |  | 94.94923076923077 |  | 38.14307692307692 |  | 88.10096546310832
11:00:00 |  | 87.35666666666667 |  | 88.4207142857143 |  | 86.73153846153846 |  | 86.97846153846152 |  | 114.3076923076923 |  | 89.91538461538461 |  | 38.5223076923077 |  | 84.60468079539508
11:30:00 |  | 89.05266666666667 |  | 93.90499999999999 |  | 96.62307692307694 |  | 95.85538461538462 |  | 120.2415384615385 |  | 95.45076923076923 |  | 40.46076923076923 |  | 90.22702930402932
12:00:00 |  | 95.15333333333334 |  | 100.9814285714286 |  | 103.0192307692307 |  | 100.9892307692308 |  | 111.8253846153846 |  | 94.06076923076922 |  | 39.33307692307693 |  | 92.19463631606486
12:30:00 |  | 98.25266666666668 |  | 102.2571428571429 |  | 100.7030769230769 |  | 99.88230769230768 |  | 109.3223076923077 |  | 93.55384615384615 |  | 39.87923076923077 |  | 91.97865410779697
13:00:00 |  | 93.85666666666664 |  | 91.68285714285715 |  | 99.28076923076924 |  | 95.22923076923077 |  | 110.7023076923077 |  | 91.76692307692306 |  | 39.57153846153847 |  | 88.87004186289901
13:30:00 |  | 92.94333333333334 |  | 91.35142857142857 |  | 98.92923076923077 |  | 94.7069230769231 |  | 104.2715384615384 |  | 85.67153846153846 |  | 40.08230769230769 |  | 86.85090005232863
14:00:00 |  | 93.43733333333331 |  | 102.1364285714286 |  | 109.0569230769231 |  | 105.8130769230769 |  | 106.8138461538462 |  | 78.93153846153845 |  | 39.45846153846154 |  | 90.80680115122972
14:30:00 |  | 86.89466666666667 |  | 93.72785714285715 |  | 100.8430769230769 |  | 104.3330769230769 |  | 100.6861538461539 |  | 83.82461538461537 |  | 40.40538461538461 |  | 87.24497592883309
15:00:00 |  | 84.68333333333335 |  | 90.43500000000003 |  | 105.5423076923077 |  | 105.1438461538462 |  | 101.7030769230769 |  | 81.08230769230767 |  | 40.45846153846153 |  | 87.00690476190478
15:30:00 |  | 84.54866666666666 |  | 87.58642857142857 |  | 98.23923076923076 |  | 97.61692307692309 |  | 86.42769230769233 |  | 74.32846153846153 |  | 38.35615384615384 |  | 81.01479382522238
16:00:00 |  | 76.958 |  | 81.28999999999999 |  | 92.56307692307692 |  | 96.11076923076924 |  | 86.28384615384614 |  | 57.05153846153846 |  | 31.18153846153846 |  | 74.49125274725273
16:30:00 |  | 66.606 |  | 65.25071428571428 |  | 72.58384615384615 |  | 75.17615384615387 |  | 73.28230769230771 |  | 48.73307692307692 |  | 30.98615384615385 |  | 61.80260753532183
17:00:00 |  | 64.59666666666666 |  | 65.34857142857143 |  | 70.51076923076924 |  | 68.06538461538462 |  | 69.38 |  | 42.66153846153846 |  | 27.27 |  | 58.26184720041863
17:30:00 |  | 52.81333333333333 |  | 60.72071428571429 |  | 65.1046153846154 |  | 64.56538461538462 |  | 61.43461538461538 |  | 38.14384615384616 |  | 26.11230769230769 |  | 52.69925954997383
18:00:00 |  | 49.34333333333333 |  | 56.95571428571429 |  | 59.12384615384615 |  | 61.18538461538461 |  | 57.83384615384615 |  | 36.17615384615384 |  | 23.14538461538461 |  | 49.10909471480899
18:30:00 |  | 48.25466666666666 |  | 51.23000000000001 |  | 52.46692307692308 |  | 53.94538461538462 |  | 49.11846153846155 |  | 33.38461538461538 |  | 22 |  | 44.34286446886447
19:00:00 |  | 43.92333333333333 |  | 46.58857142857143 |  | 49.36923076923078 |  | 50.80538461538462 |  | 49.21 |  | 19.50153846153846 |  | 16.58923076923077 |  | 39.42675562532705
19:30:00 |  | 39.26266666666667 |  | 38.29000000000001 |  | 43.02923076923077 |  | 41.87230769230769 |  | 41.24538461538461 |  | 13.83461538461538 |  | 16.81538461538462 |  | 33.47851282051282
20:00:00 |  | 35.90266666666666 |  | 34.505 |  | 39.39692307692307 |  | 41.76923076923076 |  | 36.39999999999999 |  | 11.79153846153846 |  | 16.20615384615385 |  | 37.5947641025641
20:30:00 |  | 28.37733333333333 |  | 30.30857142857143 |  | 34.14 |  | 36.6 |  | 30.23 |  | 10.97230769230769 |  | 13.04 |  | 31.93118095238095
21:00:00 |  | 23.034 |  | 24.23714285714285 |  | 27.69076923076923 |  | 29.88461538461538 |  | 21.45307692307692 |  | 1.294615384615385 |  | 1.17 |  | 25.25992087912088 |  | people | 55
21:30:00 |  | 23.00933333333333 |  | 21.83642857142857 |  | 24.39307692307693 |  | 27.09461538461539 |  | 20.44923076923077 |  | 0 |  | 0 |  | 23.356536996337 |  | shifts | 275
22:00:00 |  | 18.40666666666666 |  | 17.62142857142857 |  | 20.38384615384615 |  | 22.26230769230769 |  | 17.88692307692308 |  | 0 |  | 0 |  | 19.31223443223443 |  | options | 385
22:30:00 |  | 15.45133333333333 |  | 14.91 |  | 18.49076923076923 |  | 18.10692307692307 |  | 14.83692307692308 |  | 0 |  | 0 |  | 16.35918974358975
23:00:00 |  | 9.097857142857142 |  | 7.180000000000001 |  | 9.521538461538462 |  | 10.02538461538462 |  | 7.733846153846154 |  | 0 |  | 0 |  | 8.711725274725277
23:30:00 |  | 8.321428571428571 |  | 7.335384615384616 |  | 8.743076923076924 |  | 9.532307692307693 |  | 7.316923076923077 |  | 0 |  | 0 |  | 8.249824175824177
daily average |  | 62.6513318452381 |  | 63.35565934065934 |  | 66.70144230769233 |  | 67.34997596153846 |  | 72.38935096153848 |  | 64.6604 |  | 31.31273846153845