Spreadsheet: 36845d1234809356-using-list-function-with-hiding-irrelevant-outputs-monthly-models-6-1-rev
Sheet: Staff Number Calculation

 | Select Time Period | Annualized Year
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 | 13386 | 725.075 | 1115.5 | 920.2875 | 8.734527932540281 | 13.4377352808312 | 11.08613160668574
AAB | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAC | 12154 | 3749.509 | 6486.184666666667 | 5117.846833333333 | 45.16800481855143 | 78.13503588816947 | 61.65152035336044
AAD | 25770 | 1059.79125 | 2484.87225 | 1772.33175 | 12.76664658936907 | 29.93371179039302 | 21.35017918988105
AAE | 6872.000000000001 | 565.5570100000001 | 1205.798343333333 | 885.6776766666667 | 6.81291383827737 | 14.52550330773478 | 10.66920857300608
AAF | 343.6 | 24.4815 | 51.4541 | 37.9678 | 0.2949134166541185 | 0.619835566932691 | 0.4573744917934047
AAG | 1718 | 233.6837916666667 | 344.995875 | 289.3398333333334 | 2.815043417156052 | 4.15595091100738 | 3.485497164081716
AAH | 34360 | 8819.066666666668 | 20730.53333333333 | 14774.8 | 106.2378155900216 | 249.7278522310897 | 177.9828339105557
AAI | 3454 | 230.2666666666667 | 431.75 | 331.0083333333333 | 2.773879435827938 | 5.201023942177383 | 3.987451689002661
AAJ | 3480 | 0 | 0 | 0 | 0 | 0 | 0
AAK | 2248 | 292.24 | 431.9906666666666 | 362.1153333333333 | 3.520433669628068 | 5.203923103950209 | 4.362178386789139
AAL | 24615 | 5297.353125 | 8851.14375 | 7074.248437499999 | 63.81392109622045 | 106.6242282788737 | 85.21907468754706
AAM | 6564 | 1382.501475 | 2055.311475 | 1718.906475 | 16.65413612407771 | 24.75906008131306 | 20.70659810269538
AAN | 328.2 | 24.8885 | 50.05050000000001 | 37.4695 | 0.2998162927269991 | 0.6029272699894597 | 0.4513717813582293
AAO | 1641 | 124.0237715 | 226.030793 | 175.02728225 | 1.494037301611203 | 2.722852498117753 | 2.108444899864478
AAP | 33366 | 5249.69522 | 7696.535219999999 | 6473.115220000001 | 63.23981593133565 | 92.71537684083722 | 77.97759638608645
AAQ | 4566 | 155.05375 | 155.05375 | 155.05375 | 1.867836169251619 | 1.867836169251619 | 1.867836169251619
AAR | 4262 | 284.1333333333333 | 355.1666666666667 | 319.65 | 3.422777694122372 | 4.278472117652965 | 3.850624905887668
AAS | 13380 | 905.7925500000001 | 3116.1351 | 2010.963825 | 10.91151995181449 | 37.53814305074538 | 24.22483150127993
AAT | 3568 | 241.54468 | 830.9693600000002 | 536.25702 | 2.909738653817197 | 10.01017148019877 | 6.459955067007982
AAU | 178.4 | 12.077234 | 41.54846799999999 | 26.812851 | 0.1454869326908598 | 0.5005085740099382 | 0.322997753350399
AAV | 892 | 60.38617000000001 | 207.74234 | 134.064255 | 0.7274346634542992 | 2.502542870049692 | 1.614988766751996
AAW | 17840 | 0 | 0 | 0 | 0 | 0 | 0
AAX | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAY | 12625.5 | 505.0199999999999 | 1472.975 | 988.9975000000001 | 6.083662099081463 | 17.74401445565427 | 11.91383827736787
AAZ | 3366.8 | 134.672 | 392.7933333333334 | 263.7326666666667 | 1.622309893088391 | 4.731737188174472 | 3.177023540631431
AAZA | 168.34 | 6.7336 | 19.63966666666667 | 13.18663333333333 | 0.08111549465441953 | 0.2365868594087236 | 0.1588511770315716
AAZB | 841.7 | 0 | 0 | 0 | 0 | 0 | 0
AAZC | 16834 | 0 | 0 | 0 | 0 | 0 | 0
AAZD | 98 | 13.3525 | 15.76166666666667 | 14.55708333333333 | 0.1608492696883 | 0.1898710033629474 | 0.1753601365256237
AAZE | 180 | 0 | 0 | 0 | 0 | 0 | 0
AAZF | 2602 | 390.3 | 919.3733333333333 | 654.8366666666666 | 4.70170155097124 | 11.07511920895448 | 7.888410379962857
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 (Annualized Year) |  | 2480.176982819445 | 4974.109138138889 | 3757.354518812499 | 29.87715082450769 | 59.92000166407335 | 45.26251490814636
 |  | 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