Spreadsheet: 36699d1234552419-using-list-function-with-hiding-irrelevant-outputs-monthly-models-3
Sheet: StaffNumberCalculation-MONTHLY

 | Select Year | Month by Month
Branch 26 | AS IS
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
A
B
C
 | 0
Output | Monthly volumes, just for NBVC's view | 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 (Jan 2008) | 855.69 | 73.81788583333335 | 111.1303758333333 | 92.47413083333333 | 0.8892381970586762 | 1.338718576519601 | 1.113978386789138
Total Staff Required (Feb 2008) | 600.1600000000001 | 50.25617250000001 | 75.75457416666666 | 63.00537333333334 | 0.605404878783316 | 0.9125682778697988 | 0.7589865783265574
Total Staff Required (Mar 2008) | 638.62 | 49.25533250000001 | 74.48714416666667 | 61.87123833333334 | 0.5933483812678815 | 0.8973003362947348 | 0.7453243587813082
Total Staff Required (Apr 2008) | 1147.51 | 79.59281416666667 | 121.0351908333333 | 100.3140025 | 0.9588051699041311 | 1.458035727551072 | 1.208420448727601
Total Staff Required (May 2008) | 1339.09 | 99.22093166666667 | 150.4973633333333 | 124.8591475 | 1.195252903679165 | 1.812948210610852 | 1.504100557145008
Total Staff Required (Jun 2008) | 1201.34 | 87.57541083333334 | 133.1197591666667 | 110.347585 | 1.054966551222206 | 1.603611012397731 | 1.329288781809969
Total Staff Required (Jul 2008) | 1237.59 | 87.21122333333334 | 132.6504883333333 | 109.9308558333333 | 1.050579410731316 | 1.59795799829343 | 1.324268704512373
Total Staff Required (Aug 2008) | 1062.75 | 75.1533125 | 114.2953125 | 94.7243125 | 0.9053252522210512 | 1.376844601716609 | 1.14108492696883
Total Staff Required (Sep 2008) | 1393.93 | 127.6804675 | 191.5509141666667 | 159.6156908333333 | 1.538087245896703 | 2.307494825076545 | 1.922791035486624
Total Staff Required (Oct 2008) | 1220.26 | 97.38506416666668 | 146.9565658333333 | 122.170815 | 1.173137348792853 | 1.770294423530593 | 1.471715886161723
Total Staff Required (Nov 2008) | 1081.75 | 98.18370833333334 | 147.28475 | 122.7342291666667 | 1.182758118757216 | 1.77424785423882 | 1.478502986498018
Total Staff Required (Dec 2008) | 994.08 | 94.09182583333335 | 140.9498808333333 | 117.5208533333333 | 1.133465753149626 | 1.69793562214526 | 1.415700687647443
Just for validation---------> | 12772.77 |  |  |  | 12.28036921146414 | 18.54795746624504 | 15.41416333885459
 |  | 138.3541666666667 |  | Averaged Per Month | 1.023364100955345 | 1.545663122187087 | 1.284513611571216
 |  | 0.6
 |  | 83.01249999999999 |  | Notes:
 |  |  |  | If Annualized Year option = [NAME] to '[NAME] '!B4, '[NAME] '!C4 & '[NAME] '!E4
 |  |  |  | If 1st Quarter  option = [NAME] to '[NAME] '!B9:D9, + '[NAME] '!B14:D14, + '[NAME] '!B19:[NAME]
For Calculation Purposes Only |  |  |  | If 2nd Quarter  option = '[NAME] '!B23:D23, + '[NAME] '!B28:D28, + '[NAME] '!B33:D33
Year | Number of Months |  |  | likewise 3rd and 4th Quarter
Month by Month | 1 |  |  | If monthly option selected = [NAME] to monthly totals in [NAME] worksheet e.g.,
First Quarter only | 3 |  |  | [NAME] to '[NAME] '!B9:D9, + Refer to '[NAME] '!B14:D14, + Refer to '[NAME] '!B19:[NAME] and so on
Second Quarter only | 3
Third Quarter only | 3
Fourth Quarter only | 3
Annualized Year | 12
Month | Numerically | Weeks |  | Numerically | Weeks
0 | 1 | 0 |  | 0 | 0
April | 4 | 17.14285714285714 |  | 1 | 4.428571428571429
August | 8 | 34.71428571428571 |  | 2 | 8.428571428571429
December | 12 | 52.14285714285714 |  | 3 | 12.85714285714286
February | 2 | 8.428571428571429 |  | 4 | 17.14285714285714
January | 1 | 4.428571428571429 |  | 5 | 21.57142857142857
July | 7 | 30.28571428571428 |  | 6 | 25.85714285714285
June | 6 | 25.85714285714285 |  | 7 | 30.28571428571428
March | 3 | 12.85714285714286 |  | 8 | 34.71428571428571
May | 5 | 21.57142857142857 |  | 9 | 39
November | 11 | 47.71428571428571 |  | 10 | 43.42857142857142
October | 10 | 43.42857142857142 |  | 11 | 47.71428571428571
September | 9 | 38.99999999999999 |  | 12 | 52.14285714285714