{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Personal Services","Non-Personal Services","Summary with CPI"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Personal Services","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,"Total"]
[18323900,"TITLE 1 AIR TOOLS",-6.2527760746888816E-13,35135.15,33510.330000000016,null,55462.239999999998,95842.590000000011,{"$f":"78270.15+1814.28","v":80084.429999999993},95689.219999999972,146593.47999999998,144982.19,{"$f":"SUM(C2:L2)","v":687299.62999999989}]
[18325900,"TITLE V AIR TOOLS",130955.83000000012,86603.149999999863,117594.18,216316.31999999989,73350.75,94291.040000000052,84415.22,92180.92,143329.82000000007,138087.44,{"$f":"SUM(C3:L3)","v":1177124.67}]
[18335555,"TITLE V PERMIT ADMIN",979578.91999999911,898937.67999999912,956944.71999999962,1005261.8299999991,1248833.4700000479,1134277.9100000462,1466848.8100000008,1389657.0000000028,1237061.7900000028,1343189.7800000075,11660591.910000103]
[18335666,"TITLE I PERMIT ADMIN",633481.16,694995.64999999979,583164.54000000062,688078.8600000001,693420.36000001198,667646.6300000241,675129.00000000116,606861.83999999939,633257.29000000132,605323.11000000092,6481358.4400000405]
[18335777,"TITLE V EMISSION",1218909.22,1357022.4399999988,1467876.92,1682700.699999999,1600324.1600000006,1587073.7999999993,1520389.8,1536985.51,1687027.0199999998,831206.66999999993,14489516.239999996]
[18335888,"TITLE I EMISSION",463885.11999999976,410254.57000000036,445465.52000000031,539316.53000000038,596563.45000000042,508056.10000000027,653894.43999999994,506238.21999999986,562336.60000000009,1028716.85,5714727.4000000004]
[null,null,{"$f":"SUM(C2:C7)","v":3426810.2499999986},{"$f":"SUM(D2:D7)","v":3482948.6399999978},3604556.2100000004,4131674.2399999984,4267954.4300000612,4087188.0700000697,4480761.7000000011,4227612.7100000018,4409606.0000000037,4091506.0400000084,40210618.290000133]

{"sheet":"Non-Personal Services","index":1,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,"Total"]
[18323900,"TITLE 1 AIR TOOLS",null,null,578.46,0,null,null,null,null,null,null,{"$f":"SUM(C2:L2)","v":578.46}]
[18325900,"TITLE V AIR TOOLS",5160.04,5557.99,7083.93,1374.19,null,null,null,null,null,null,{"$f":"SUM(C3:L3)","v":19176.149999999998}]
[18335555,"TITLE V PERMIT ADMIN",595813.64000000036,388631.05000000016,310319.61000000004,249503.42999999993,158428.93999999977,107307.93999999997,105837.16999999993,87818.630000000034,51291.379999999968,65356.520000000033,2120308.31]
[18335666,"TITLE I PERMIT ADMIN",171893.00000000003,255007.29999999993,93537.65,150316.15000000008,133241.91999999993,26402.330000000005,83271.200000000012,12663.52,10440.090000000004,12382.49,949155.65]
[18335777,"TITLE V EMISSION",215923.65000000017,221421.43999999957,272317.12000000023,266865.18999999983,174733.32999999981,138075.86000000002,150413.26999999996,102572.77,120676.91,125241.94000000002,1788241.4799999995]
[18335888,"TITLE I EMISSION",63368.489999999983,68180.09,63878.119999999966,131639.57999999999,58785.80000000001,51403.439999999973,65066.94000000001,58071.94,74833.8,87350.760000000038,722578.96]
[null,null,{"$f":"SUM(C2:C7)","v":1052158.8200000005},938797.86999999965,747714.89000000025,799698.5399999998,525189.98999999953,323189.56999999995,404588.5799999999,261126.86000000004,257242.18,{"$f":"SUM(L2:L7)","v":290331.71000000008},{"$f":"SUM(M1:M7)","v":5600039.0099999988}]

{"sheet":"Summary with CPI","index":2,"n_rows":80,"n_cols":14,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Total Permit Costs",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,"Total"]
["Personal Services",{"$f":"'Personal Services'!C8","v":3426810.2499999986},{"$f":"'Personal Services'!D8","v":3482948.6399999978},{"$f":"'Personal Services'!E8","v":3604556.2100000004},{"$f":"'Personal Services'!F8","v":4131674.2399999984},{"$f":"'Personal Services'!G8","v":4267954.4300000612},{"$f":"'Personal Services'!H8","v":4087188.0700000697},{"$f":"'Personal Services'!I8","v":4480761.7000000011},{"$f":"'Personal Services'!J8","v":4227612.7100000018},{"$f":"'Personal Services'!K8","v":4409606.0000000037},{"$f":"'Personal Services'!L8","v":4091506.0400000084},{"$f":"SUM(B2:K2)","v":40210618.290000141}]
["Non Personal Services",{"$f":"'Non-Personal Services'!C8","v":1052158.8200000005},{"$f":"'Non-Personal Services'!D8","v":938797.86999999965},{"$f":"'Non-Personal Services'!E8","v":747714.89000000025},{"$f":"'Non-Personal Services'!F8","v":799698.5399999998},{"$f":"'Non-Personal Services'!G8","v":525189.98999999953},{"$f":"'Non-Personal Services'!H8","v":323189.56999999995},{"$f":"'Non-Personal Services'!I8","v":404588.5799999999},{"$f":"'Non-Personal Services'!J8","v":261126.86000000004},{"$f":"'Non-Personal Services'!K8","v":257242.18},{"$f":"'Non-Personal Services'!L8","v":290331.71000000008},{"$f":"SUM(B3:K3)","v":5600039.0099999998}]
[]
["CPI Factor",1.19,1.17,1.1399999999999999,1.1200000000000001,1.1000000000000001,1.1000000000000001,1.0900000000000001,1.06,1.04,1.02]
["FY 2020 Equivalent Personal Services",{"$f":"B2*B5","v":4077904.1974999984},{"$f":"C2*C5","v":4075049.9087999971},4109194.0794000002,4627475.1487999987,4694749.8730000677,4495906.8770000767,4884030.2530000014,4481269.4726000018,4585990.2400000039,4173336.1608000086,{"$f":"SUM(B6:K6)","v":44204906.21090015}]
["FY2020 Equivalent Non Personal Services",{"$f":"B3*B5","v":1252068.9958000006},{"$f":"C3*C5","v":1098393.5078999996},852394.97460000019,895662.36479999986,577708.98899999948,355508.52699999994,441001.55219999992,276794.47160000005,267531.86719999998,296138.34420000011,{"$f":"SUM(B7:K7)","v":6313203.5942999991}]
[null,{"$f":"SUM(B6:B7)","v":5329973.1932999995},{"$f":"SUM(C6:C7)","v":5173443.4166999962},4961589.0540000005,5523137.5135999983,5272458.8620000668,4851415.4040000765,5325031.8052000012,4758063.9442000017,4853522.1072000042,4469474.5050000083,50518109.805200152]
[]
[]
["Less: Costs Included in Permit Flat Fees and Time and Materials Charges at FY2020 Equivalent"]
["Personal Services Included in Fees and Charges",1601557.8899999994,1555165.0300000003,1436419.17,1512326.8899999997,1682003.0700000005,1591300.5,1860601.8700000003,1687400.5,1574599.9800000002,1623519.8199999996,{"$f":"SUM(B12:K12)","v":16124894.720000003}]
["Non Personal Services Included in Fees and Charges",848603.90999999968,518640.7699999999,447830.12000000005,447350.45,391492.04000000004,163799.02000000002,183357.65,113309.60999999999,65007.81,59362.729999999996,{"$f":"SUM(B13:K13)","v":3238754.11}]
["Total Costs Included in Flat Fees and Time and Materials Charges",{"$f":"SUM(B12:B13)","v":2450161.7999999989},2073805.8000000003,1884249.29,1959677.3399999996,2073495.1100000006,1755099.52,2043959.5200000003,1800710.1099999999,1639607.7900000003,1682882.5499999996,{"$f":"SUM(L12:L13)","v":19363648.830000002}]
[]
[]
["Equals Costs to Include in Emission's Fees",{"$f":"B8-B14","v":2879811.3933000006},3099637.6166999959,3077339.7640000004,3563460.1735999985,3198963.7520000665,3096315.8840000764,3281072.2852000007,2957353.8342000018,3213914.3172000041,2786591.9550000085,{"$f":"SUM(B17:K17)","v":31154460.975200158}]
[]
["Add: Administrative RDU Use of CAPF",null,null,null,null,null,null,null,null,null,null,493667.73]
[]
["Single Year Cost at FY2020 Levels",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L17/10)+L19","v":3609113.8275200156}]
[]
["Add: Monitoring",{"$f":"SUM(913436.19+65421.59)","v":978857.77999999991},{"$f":"SUM(605244.27+376404.64)","v":981648.91},776466.49,872356.45,{"$f":"1099519.39+5346.53","v":1104865.92},{"$f":"913726.36+1016.54","v":914742.9},1380851.6100000006,1388840.9699999997,1355115.3599999999,1474368.6499999994]
["FY2020 Cost Level",{"$f":"B23*B5","v":1164840.7581999998},1148529.2246999999,885171.79859999986,977039.22400000005,1215352.5120000001,1006217.1900000001,1505128.2549000008,1472171.4281999997,1409319.9743999999,1503856.0229999993,{"$f":"SUM(B24:K24)/10","v":1228762.6388000003},"Single Year Average"]
[]
["Add: Non-Point Personal Services (Broad definition, averaged FY18 and FY19 analysis)"]
["FY2020 Cost Level",{"$f":"B26*B6","v":0},0,0,0,0,0,{"$f":"H26*H3","v":0},{"$f":"I26*I3","v":0},{"$f":"J26*J5","v":0},{"$f":"K26*K5","v":0},{"$f":"SUM(H27:K27)/2","v":0},"Single Year Average"]
[]
["Add: Non-Point Non Personal Services (Contractual only)"]
["FY2020 Cost Level",{"$f":"B29*B8","v":0},0,0,0,0,0,{"$f":"H29*H5","v":0},{"$f":"I29*I5","v":0},{"$f":"J29*J5","v":0},{"$f":"K29*K5","v":0},{"$f":"SUM(H30:K30)/4","v":0},"Single Year Average"]
[]
["Add: Unsustainable Cuts",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(150000+24000)","v":174000}]
[]
["Add: Pension Liability Change",null,null,null,null,null,null,null,null,null,null,{"$f":"297700+14900","v":312600},"Pension Liability Change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B36:K36)/10","v":0}]
[]
["FY2020 Equivalent Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L21:L36)","v":5324476.4663200155}]
[]
["EMIS TV and TI - only",null,null,null,null,null,null,null,null,null,"FY2020 Actual Emiss",79534,{"$f":"L40-L47","v":75704}]
["Have to look at other EMIS separately - they were set back when original fees established, and never reset"]
[null,null,null,null,null,null,null,null,null,null,null,null,"With no additions"]
[null,null,null,null,null,null,null,null,null,null,"Title V Only Rate",{"$f":"SUM(L38/SUM((L47*N44+SUM(L50*N44)+L50)))","v":54.979853404280377},null,"Title I = (.21/.79)Title V"]
[null,null,null,null,null,null,null,{"$f":"3200000*I44","v":729406.286379511},{"$f":"SUM(9.79/42.95)","v":0.22793946449359717},null,"Title I Only Rate",{"$f":"L43*N44","v":14.613645034857724},null,{"$f":"ROUND(SUM(0.21/0.79),4)","v":0.26579999999999998}]
[null,null,null,null,null,null,null,null,null,null,"Combo Rate",{"$f":"SUM(L43+L44)","v":69.593498439138102}]
[]
[null,null,null,null,null,null,null,null,null,null,"FY20 Title I Only Units",3830,{"$f":"SUM(L47/L40)","v":4.8155505821409712E-2}]
[null,null,null,null,null,null,null,null,null,null,"FY20 Title I Only Collections",{"$f":"L44*L47","v":55970.260483505081}]
[]
[null,null,null,null,null,null,null,null,null,null,"FY20 Title V Units",75704]
[]
[null,null,null,null,null,null,null,null,null,null,"FY20 Title V Portion Combo",{"$f":"SUM(L43)*L50","v":4162194.8221176416}]
[null,null,null,null,null,null,null,null,null,null,"FY20 Title I Portion Combo",{"$f":"L44*L50","v":1106311.3837188692}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Title V Collections",{"$f":"SUM(L52)","v":4162194.8221176416},{"$f":"L56/L58","v":0.78170968515789518}]
[null,null,null,null,null,null,null,null,null,null,"Total Title I Collections",{"$f":"SUM(L53+L48)","v":1162281.6442023742},{"$f":"L57/L58","v":0.21829031484210487}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L56+L57)","v":5324476.4663200155}]
[]
["Forecast",2021,2022,2023,2024]
["Emissions (from Regression Analysis)",75560,72110,68661,61763]
["Cost (with annual CPI factor of 1.02)",{"$f":"L38*1.02","v":5430965.9956464162},{"$f":"B62*1.02","v":5539585.3155593444},{"$f":"C62*1.02","v":5650377.0218705311},5763384.5623079417]
[]
[]
["Title V Only Rate",{"$f":"SUM(B62/SUM((B69*$N$44+SUM(B72*$N$44)+B72)))","v":59.031048195880054},{"$f":"SUM(C62/SUM((C69*$N$44+SUM(C72*$N$44)+C72)))","v":63.092410507756348},{"$f":"SUM(D62/SUM((D69*$N$44+SUM(D72*$N$44)+D72)))","v":67.586921194689808},{"$f":"SUM(E62/SUM((E69*$N$44+SUM(E72*$N$44)+E72)))","v":76.63807308698685},"Average",{"$f":"SUM(B65:E65)/4","v":66.587113246328272}]
["Title I Only Rate",{"$f":"B65*$N$44","v":15.690452610464916},{"$f":"C65*$N$44","v":16.769962712961636},{"$f":"D65*$N$44","v":17.964603653548551},{"$f":"E65*$N$44","v":20.370399826521105},"Average",{"$f":"SUM(B66:E66)/4","v":17.698854700874051}]
["Combo Rate - Paid by Title V Facilities",{"$f":"SUM(B65+B66)","v":74.721500806344977},{"$f":"SUM(C65+C66)","v":79.862373220717984},{"$f":"SUM(D65+D66)","v":85.551524848238358},{"$f":"SUM(E65+E66)","v":97.008472913507958},"Average",84.285967947202323]
[]
["Annual Title I Only Units",{"$f":"B61*0.0482","v":3641.9920000000002},{"$f":"C61*0.0482","v":3475.7019999999998},3309.4602,2976.9766]
["Annual Title I Only Collections",{"$f":"B66*B69","v":57144.502883692345},{"$f":"C66*C69","v":58287.392941366183},{"$f":"D66*D69","v":59453.14080019352},{"$f":"E66*E69","v":60642.203616197388},null,{"$f":"SUM(B70:E70)/4","v":58881.810060362361}]
[]
["Annual Title V Only Units",{"$f":"B61-B69","v":71918.008000000002},{"$f":"C61-C69","v":68634.297999999995},{"$f":"D61-D69","v":65351.539799999999},{"$f":"E61-E69","v":58786.023399999998}]
[]
["Annual Title V Portion of Combo",{"$f":"SUM(B67)*B72","v":5373821.4927627249},{"$f":"SUM(C67)*C72","v":5481297.9226179775},5590923.8810703382,5702742.3586917445,null,{"$f":"SUM(B74:E74)/4","v":5537196.413785696}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G70:G74)","v":5596078.2238460584}]
[]
["Total Title V Collections",{"$f":"SUM(B74)","v":5373821.4927627249},{"$f":"SUM(C74)","v":5481297.9226179775},{"$f":"SUM(D74)","v":5590923.8810703382},{"$f":"SUM(E74)","v":5702742.3586917445},"Average",{"$f":"SUM(B78:E78)/4","v":5537196.413785696}]
["Total Title I Collections",{"$f":"SUM(B75+B70)","v":57144.502883692345},{"$f":"SUM(C75+C70)","v":58287.392941366183},{"$f":"SUM(D75+D70)","v":59453.14080019352},{"$f":"SUM(E75+E70)","v":60642.203616197388},"Average",{"$f":"SUM(B79:E79)/4","v":58881.810060362361}]
[null,{"$f":"SUM(B78+B79)","v":5430965.9956464171},{"$f":"SUM(C78+C79)","v":5539585.3155593434},{"$f":"SUM(D78+D79)","v":5650377.0218705321},{"$f":"SUM(E78+E79)","v":5763384.5623079417},"Average Total",{"$f":"SUM(G78+G79)","v":5596078.2238460584}]