Spreadsheet: 36719d1234576904-using-list-function-with-hiding-irrelevant-outputs-monthly-models-6-1-
Sheet: Staff Number Calculation

 | Select Time Period | First Quarter only
Branch 26
Work Items | Transactions Received to be Processed | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
AAA | 900 | 48.75 | 75 | 61.875 | 0.5872609546755008 | 0.9034783918084627 | 0.7453696732419818
AAB | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAC | 1047 | 322.9995 | 558.749 | 440.87425 | 3.890974250865834 | 6.73090197259449 | 5.310938111730162
AAD | 2362.5 | 97.15781249999999 | 227.8040625 | 162.4809375 | 1.170399789188375 | 2.744213973799127 | 1.957306881493751
AAE | 630 | 51.8482125 | 110.5432125 | 81.1957125 | 0.6245831953019125 | 1.331645384731215 | 0.9781142900165639
AAF | 31.5 | 2.244375 | 4.717125 | 3.48075 | 0.02703659087486825 | 0.05682427345279326 | 0.04193043216383076
AAG | 157.5 | 21.42328125 | 31.62796875 | 26.525625 | 0.2580729558801386 | 0.3810024845655775 | 0.3195377202228581
AAH | 3150 | 808.5 | 1900.5 | 1354.5 | 9.739497063695229 | 22.89414244842645 | 16.31681975606084
AAI | 312 | 20.8 | 39 | 29.9 | 0.2505646739948803 | 0.4698087637404006 | 0.3601867188676404
AAJ | 236 | 0 | 0 | 0 | 0 | 0 | 0
AAK | 190 | 24.7 | 36.51166666666666 | 30.60583333333333 | 0.2975455503689204 | 0.4398333584299554 | 0.3686894543994379
AAL | 1310.25 | 281.97671875 | 471.1440625 | 376.560390625 | 3.396798298449029 | 5.675579731968077 | 4.536189015208553
AAM | 349.4 | 73.59019125000002 | 109.40369125 | 91.49694125 | 0.8864953019123629 | 1.317918280379461 | 1.102206791145912
AAN | 17.47 | 1.324808333333333 | 2.664175 | 1.994491666666666 | 0.01595914269939266 | 0.03209366059328415 | 0.0240264016463384
AAO | 87.35000000000001 | 6.601752858333334 | 12.03155988333333 | 9.316656370833334 | 0.07952721407418563 | 0.1449367249912162 | 0.1122319695327009
AAP | 1776 | 279.42992 | 409.6699199999999 | 344.54992 | 3.366118596596898 | 4.935038939918686 | 4.150578768257794
AAQ | 369 | 12.530625 | 12.530625 | 12.530625 | 0.1509486523113989 | 0.1509486523113989 | 0.1509486523113989
AAR | 449 | 29.93333333333333 | 37.41666666666666 | 33.675 | 0.3605882648195554 | 0.4507353310244441 | 0.4056617979219997
AAS | 1007.25 | 68.18830687500001 | 234.58348875 | 151.3858978125 | 0.8214221578075593 | 2.825881508808915 | 1.823651833308237
AAT | 268.6 | 18.1835485 | 62.55559700000001 | 40.36957275 | 0.2190459087486825 | 0.7535684023490441 | 0.4863071555488632
AAU | 13.43 | 0.9091774250000003 | 3.127779850000001 | 2.0184786375 | 0.01095229543743413 | 0.0376784201174522 | 0.02431535777744316
AAV | 67.15 | 4.545887125000001 | 15.63889925 | 10.0923931875 | 0.05476147718717063 | 0.188392100587261 | 0.1215767888872158
AAW | 1343 | 0 | 0 | 0 | 0 | 0 | 0
AAX | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAY | 1338 | 53.52 | 156.1 | 104.81 | 0.6447221803945189 | 1.880439692817347 | 1.262580936605933
AAZ | 356.8000000000001 | 14.272 | 41.62666666666667 | 27.94933333333334 | 0.1719259147718717 | 0.5014505847512926 | 0.3366882497615822
AAZA | 17.84 | 0.7135999999999999 | 2.081333333333333 | 1.397466666666667 | 0.008596295738593586 | 0.02507252923756463 | 0.0168344124880791
AAZB | 89.20000000000002 | 0 | 0 | 0 | 0 | 0 | 0
AAZC | 1784 | 0 | 0 | 0 | 0 | 0 | 0
AAZD | 15 | 2.04375 | 2.4125 | 2.228125 | 0.02461978617678061 | 0.02906188826983888 | 0.02684083722330975
AAZE | 8 | 0 | 0 | 0 | 0 | 0 | 0
AAZF | 340 | 51 | 120.1333333333333 | 85.56666666666666 | 0.6143653064297546 | 1.4471716107012 | 1.030768458565477
AAZG | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAZH | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAZI | 0 | 0 | 0 | 0 | 0 | 0 | 0
Period | Monthly Volume | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
Total Staff Required (First Quarter only) |  | 749.4789335666666 | 389.797777825 | 290.6150056083333 | 9.028506954575114 | 4.695651592531245 | 3.500858372032325
 |  | 138.3541666666667
 |  | 0.6
 |  | 83.01249999999999
For Calculation Purposes Only
Year | Number of Months
Month by Month | 1
First Quarter only | 3
Second Quarter only | 3
Third Quarter only | 3
Fourth Quarter only | 3
Annualized Year | 12