{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Rate Application","REV","Description_Notes","Information","Equipment list","Expense Detail","Salary Operating and Deprec Exp","Rate Summary","Rate Sheet","Index Summary","Reviewer Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":1,"pivot_tables":1},"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":"Instructions","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,1],[39,0,39,1],[36,0,36,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[10,0,10,4],[35,0,35,4],[18,0,18,4],[25,0,26,0]]}
["Service Center Rate Development Worksheet"]
["University of Idaho"]
[]
["General Information:"]
[]
[]
[]
[]
[]
[]
["Sheets and purposes:"]
[]
[]
[]
[]
[]
[]
[]
["Rate Application:"]
[]
[]
[]
[]
[]
[]
["Example of ID* / J Doc (internal rev) & F Doc (external rev)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Service Center Team contact information:"]
["Please direct all email correspondence to:"]
["UI Service Center Team","osp-cost@uidaho.edu"]
["Team members and contact information:"]
["Shannon Shumard - Service Center Team Member",null,"sshumard@uidaho.edu","885-4013"]
["Catie Maas- Service Center Team Member",null,"catiem@uidaho.edu","885-5720"]

{"sheet":"Rate Application","index":1,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,24,14,34],[15,24,15,34],[13,19,13,21],[10,24,11,33],[19,10,19,11],[14,19,14,21],[15,19,15,21],[24,1,24,9],[20,10,20,11],[21,1,21,9],[16,24,16,34],[25,13,29,23],[16,19,16,21],[17,19,17,21],[40,2,40,6],[40,8,40,11],[36,6,36,7],[36,8,36,9],[36,10,36,11],[38,1,38,10],[39,1,39,2],[39,3,39,6],[39,8,39,11],[30,1,30,11],[32,3,32,4],[13,1,13,9],[14,1,14,9],[15,1,15,9],[32,1,32,2],[16,1,16,11],[15,10,15,11],[17,1,17,11],[22,1,22,11],[26,1,26,10],[27,1,27,10],[28,1,28,10],[25,1,25,8],[20,1,20,6],[19,1,19,6],[9,4,9,6],[9,7,9,9],[9,10,9,11],[1,7,1,8],[29,1,29,10],[11,1,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[1,1,1,2],[9,1,9,3],[8,1,8,3],[5,1,5,3],[10,1,10,3],[3,1,3,3],[4,1,4,3],[6,1,6,3],[6,4,6,11],[8,4,8,6],[8,7,8,9],[3,4,3,11],[4,4,4,11],[5,4,5,11],[10,4,10,6],[10,7,10,9],[10,10,10,11],[13,10,13,11],[14,10,14,11]]}
[null,"Service Center Rate Application",null,null,null,null,null,null,null,null,null,"FY2025"]
[null,"For rates effective:",null,null,"2024-10-01",null,null,"Application Type:",null,null," New","Renewal"]
[]
[null,"College/Division",null,null,"Office of Research and Economic Development  "]
[null,"Department",null,null,"Cost Accounting"]
[null,"Service Center Name",null,null,"University Vandal Service Center"]
[null,"Service Center Location & Room#",null,null,"Morrill Hall (017), Room 209D"]
[]
[null,"Contact Information:",null,null,"Name",null,null,"Email",null,null,"Phone #"]
[null,"Worksheet preparer",null,null,"Suzie Grant",null,null,"sgrant@uidaho",null,null,"208-885-4013"]
[null,"College Fiscal Contact",null,null,"Suzie Grant",null,null,"sgrant@uidaho",null,null,"208-885-4013",null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary - Banner screen FGIGLAC by FUND, Prior FISCAL YEAR, ACCOUNT: 90RC (Revenue Control) to review"]
[null,"Service Center Manager",null,null,"Joe Vandal",null,null,"jvandal@uidaho",null,null,"208-885-4013"]
[]
[null,"1) What % of total revenue is charged to internal UI Departments (including your own)?",null,null,null,null,null,null,null,null,{"$f":"X15","v":0.6470588235294118},null,null,null,null,null,null,null,"Index/ Fund #","Index Name",null,null,"Rev","Percent"]
[null,"1.a.) What % of the above internal revenue is charged to sponsored projects (22 funds)?",null,null,null,null,null,null,null,null,{"$f":"X16","v":0.36363636363636365},null,null,null,null,null,null,null,"79XXXX/150000","University Vandal Service Center - Operating Account",null,null,{"$f":"REV!N4","v":16500},{"$f":"W15/W18","v":0.6470588235294118},"Total for all Operating Acct OR if fund is not split out from external customers use the total for ID* revenue types / J Documents"]
[null,"2) What % of total revenue is charged to external (non-UI) customers? *",null,null,null,null,null,null,null,null,{"$f":"X17","v":0.35294117647058826},null,null,null,null,null,null,null,"79XXXX/150000","University Vandal Service Center - Operating Account (22 Funds)",null,null,{"$f":"REV!I22","v":6000},{"$f":"W16/W15","v":0.36363636363636365},"Total of all Funds starting with 22XXXX within the Operating Acct fund (From Service Centers billings)"]
[null,"3) Description of the product(s) or service(s) provided:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"79XXXX/151000","University Vandal Service Center - External Customers Account",null,null,{"$f":"REV!N5","v":9000},{"$f":"W17/W18","v":0.35294117647058826},"Total for External Acct OR if fund is not split into it's own index/fund for external customers only, then use the total revenue of all F Documents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W15,W17)","v":25500}]
[]
[null,"4) Do competitors exist outside of the UI?",null,null,null,null,null,null,"Yes","No","If yes, please answer 4.a below"]
[null,"4.a.) Has a market analysis been completed",null,null,null,null,null,null,"Yes","No","Please provide analysis and brief description in 4.b"]
[null,"           4.b.) If yes, briefly describe how the service center rates compare to market rates:"]
[null,"These should not be creating an unfair advantage. If the market analysis is too long to provide details here, please statement to \"See Attached Market Analysis\" - the full market analysis should be attached with each annual service center rate review"]
[]
[null,"5) Are services provided to certain users at discounted rates or free of charge?",null,null,null,null,null,null,null,null,"Yes "," No"]
[null,"if yes, please complete the section below for imputed revenue and 5.a",null,null,null,null,null,null,null,null,null,null,null,"•Imputed Revenue: It is important to note that when a customer is charged a rate lower than those approved and on file, the center is essentially committed to subsidizing the difference. This often occurs as a result of offering discounts and waivers to customers. Centers that anticipate using this methodology should coordinate with their associated department or college to ensure that the effect to center net income will not be an issue. The guarantee index is a subsidy funding source used to transfer funds for deficits (<15% of annual revenue) that may occur."]
[null,"Estimated units of discount",null,null,null,null,null,null,null,null,null,250]
[null,"Estimated discount rate",null,null,null,null,null,null,null,null,null,20]
[null,"Estimated Imputed Revenue",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L27*L28)","v":5000}]
[null,"5.a.) If different fees are charged, please elaborate (who do you charge more or less):"]
[null,"Internal customers shouldn't be charged more, only external customers. One reason for charging more to an external customer could be a specific delivery fee for this one customer or less (charging the internal rate instead of external) is that they are part of our consortium agreement. Please remember that charging lower rates (subsidizing) could cause a deficit and should be built into this rate sheet to be reviewed for approval."]
[]
[null,"Guarantee Index:",null,"79XXXX"]
[null,"(to be used if annual expenses create an index deficit > 15% of the Service Center's total annual revenue)"]
[]
[null,"New service center only:"]
[null,"Source of start-up (seed) money:",null,null,null,null,null,null,"Amount:"]
[]
[null,"Dean or Department Head Approval:"]
[null,"Name (please print):",null,null,null,null,null,"Title:"]
[null,"Signature:",null,null,null,null,null,"Date:"]

{"sheet":"REV","index":2,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Code","Acct Code","Trans Date","Rucl Code","Doc Code","Trans Desc","Trnas Amt","Dr Cr Ind","22 Fund"]
[{"$f":"LEFT(D:D,2)","v":"ID"},"90RC","6/11/24, 9:00:06 AM","IDG","J135XXXX","MAY 2024 XXXX CHARGES",7000,"Credit",2000,null,"ID",{"$f":"SUMIF(A:A,K2,G:G)","v":16500}]
["TM","90RC","6/10/24, 11:59:59 PM","TMIS","F024XXXX","GRT25XXXX",5000,"Credit",null,null,"CT",{"$f":"SUMIF(A:A,K3,G:G)","v":0}]
["ID","90RC","6/6/24, 9:19:11 AM","IDG","J135XXXX","FEES FOR FY 2024 - XX",3400,"Credit",725,null,"JE",{"$f":"SUMIF(A:A,K4,G:G)","v":0},"Internal",{"$f":"SUM(L2:L4)","v":16500}]
["ID","90RC","5/30/24, 7:07:31 AM","IDG","J135XXXX","2024 XXXX Charges for XXXX",1040,"Credit",600,null,"TM",{"$f":"SUMIF(A:A,K5,G:G)","v":9000},"External",{"$f":"L5","v":9000}]
["ID","90RC","5/7/24, 7:13:07 AM","IDG","J135XXXX","FY24 QTR 3 XXXX FEES",350,"Credit",100,null,null,{"$f":"SUM(L2:L5)","v":25500}]
["ID","90RC","5/6/24, 2:21:39 PM","IDG","J135XXXX","FEES FOR FY 2024 - XX",2210,"Credit",1075]
["TM","90RC","4/16/24, 11:59:59 PM","TMIS","F024XXXX","GRT25XXXX",4000,"Credit"]
["ID","90RC","7/11/24, 9:00:06 AM","IDG","J135XXXX","JUNE 2024 XXXX CHARGES",2500,"Credit",1500]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[]
[null,null,null,null,null,null,{"$f":"SUM(G2:G20)","v":25500},null,{"$f":"SUM(I2:I20)","v":6000}]

{"sheet":"Description_Notes","index":3,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,0,24,4],[28,0,42,4]]}
["Department Notes and Comments"]
[]
[]
[]
[]
[]
[]
[]
["Notes about your service center"," "," "]
["Documentation and justifications for subsidizing rate and/or if surplus /deficit over 15% allowable carry-over balance. Rate development spreadsheet will automatically adjust rates down if there is surplus or up to cover deficits, if needed the service center will work with OSP to get plan in place to rebalance service center (making it break-even and compliant)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments or suggestions to help us provide better service for you:"]

{"sheet":"Information","index":4,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,2,34,4],[35,2,35,4],[36,2,36,4],[23,2,23,4],[32,2,32,4],[11,1,11,2],[10,3,10,5],[11,3,11,5],[33,2,33,4],[21,2,21,4],[15,5,15,9],[14,5,14,9],[19,2,19,4],[20,2,20,4],[18,2,18,4],[17,2,17,4],[26,2,26,4],[9,1,9,2],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,1,10,2],[4,1,4,3],[2,4,2,5],[6,3,6,5],[7,1,7,2],[8,1,8,2]]}
["Index Information",null,null,null,null,null,null,null,null,{"$f":"'Rate Application'!L1","v":"FY2025"},{"$f":"SUM(RIGHT(J1,4)-1)","v":2024}]
[]
[null,"Service Center Name *",null,null,{"$f":"IF('Rate Application'!E6=0,\"Please fill in Cell E6 on Rate Application Page\",'Rate Application'!E6)","v":"University Vandal Service Center"}]
[null,"Fund # **",null,null,null,150000,null,null,null,null,null,{"$f":"SUM(G8*I8)","v":25000},{"$f":"SUM(20*250)","v":5000},null,{"$f":"L4-M4","v":20000}]
[null,"Operating Index Carry Forward ***",null,null,null,{"$f":"J25","v":1346.4868571428574},null,null,null,null,null,{"$f":"G9*I9","v":7975},null,null,{"$f":"O4+L5","v":27975}]
[]
[null,"Service Name (short)",null,"Brief description of service",null,null,"Current Rate\n(if applicable)","Unit †","Estimated # of annual units ‡","Proposed New Rate  "]
["1)","Data Analysis",null,"Analysis for service centers",null,null,50,"Hour",500,{"$f":"'Rate Summary'!D31","v":65}]
["2)","Meeting Setups",null,"Planning and setup of zoom (hour meeting)",null,null,145,"Fixed",55,{"$f":"'Rate Summary'!E31","v":185}]
["3)",null,null,null,null,null,null,null,null,{"$f":"'Rate Summary'!F31","v":0}]
["4)",null,null,null,null,null,null,null,null,{"$f":"'Rate Summary'!G31","v":0}]
["5)",null,null,null,null,null,null,null,null,{"$f":"'Rate Summary'!H31","v":0}]
[]
["FUND BALANCE AND SUBSIDY INDEX INFORMATION:"]
[]
["Operating index(s):",null,null,null,null,{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY24"}]
[null,"Index/ Fund Number","Index Name",null,null,"Carry Forward","Revenue","Expenditures","Transfers","Ending Balance",null,"15% Allowable Carry-Over","Percent of Surplus/Deficit","Percent Over/Under 15% allowable Carry-Over"]
[null,"79XXXX/150000","University Vandal Service Center - Operating Account",null,null,3000,16500,14900,null,{"$f":"F18+G18-H18-I18","v":4600},null,{"$f":"G18*0.15","v":2475},{"$f":"IFERROR(J18/G18,\"\")","v":0.27878787878787881},{"$f":"IFERROR(IF(J18<0,\"\",J18/SUM(L18-J18)),\"\")","v":-2.164705882352941}]
[null,"79XXXX/151000","University Vandal Service Center - External Customers Account",null,null,-1500,9000,8000,null,{"$f":"F19+G19-H19-I19","v":-500},null,{"$f":"G19*0.15","v":1350},{"$f":"IFERROR(J19/G19,\"\")","v":-5.5555555555555552E-2},{"$f":"IFERROR(IF(J19<0,\"\",J19/SUM(L19-J19)),\"\")","v":""}]
[null," ",null," ",null,0,0,0,0,0,null,0,{"$f":"IFERROR(J20/G20,\"\")","v":""}]
[null,null,null,null,null,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE(K1,\" \",\"Recovered Depreciation\")","v":"2024 Recovered Depreciation"},null,null,0,0,0,{"$f":"'Salary Operating and Deprec Exp'!AB254","v":2753.5131428571426},-2753.5131428571426]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,0,null,0,0]
[null,"TOTAL OPERATING INDEX",null,null,null,{"$f":"SUM(F18:F24)","v":1500},{"$f":"SUM(G18:G24)","v":25500},{"$f":"SUM(H18:H24)","v":22900},{"$f":"SUM(I18:I24)","v":2753.5131428571426},{"$f":"SUM(J18:J24)","v":1346.4868571428574},null,{"$f":"IFERROR(J25/G25,\"\")","v":5.2803406162464997E-2},"Total Percent of Surplus/Deficit (Combined Funds)"]
["Equipment replacement reserves ††"]
[null,"79XXXX/151001","University Vandal Service Center - Equip Reserve Account",null,null,5000,null,null,{"$f":"-I22","v":-2753.5131428571426},{"$f":"F27+G27-H27-I27","v":7753.5131428571422}]
[null,"FUND TOTAL",null,null,null,{"$f":"F27+F25","v":6500},{"$f":"G27+G25","v":25500},{"$f":"H27+H25","v":22900},{"$f":"I27+I25","v":0},{"$f":"J27+J25","v":9100}]
[]
[]
["SUBSIDY INDEX INFORMATION:"]
[null,"Index/ Fund Number","Index Name"]
[null,"79XXXX/1211XX","Department Funds Subsidy Account"]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]

{"sheet":"Equipment list","index":5,"n_rows":1,"n_cols":28,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Identified","Otag","Ptag","Resp Location Code","Resp Location Title","Building Number","Xref","Room Number","Resp Orgn","Dept","Asset Type","Fund Level 1","Fund Title 1","FY Acquired","Total Cost","F Seq","Index","Fund","Orgn","Account","Program","Asset Name","Disposal Date","Accum Depr","Net Book Value","Dept Name","Useful Life","Remaining Life"]

{"sheet":"Expense Detail","index":6,"n_rows":7,"n_cols":50,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Fiscal Year","Fiscal Period","Activity Date","Chart","Document Code","Document Reference","Vendor Name","Encumbrance Number","Transaction Description","Transaction Date","Transaction Type","Grant Code","Fund Type","Fund Type Title","Fund Level 3","Fund Title 3","Fund Level 4","Fund Title 4","Fund Level 5","Fund Title 5","Fund Predecessor","Fund Predecessor Title","Fund","Fund Title","Level 3 Org","Level 3 Org Title","Index Code","Index Title","Organization","Organization Title","PE","PE Title","Account","Account Title","Program","Program Title","Activity","Activity Code Title","Location Code","Location Title","Dr Cr","Original Budget","Adjusted Budget","YTD","Encumbrance"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account","Account Title","Sum of YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank)","(blank)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]

{"sheet":"Salary Operating and Deprec Exp","index":7,"n_rows":259,"n_cols":28,"rows_kept":259,"cut":false,"hidden":false,"merged":[[0,9,1,9],[0,10,1,10],[136,22,136,23],[136,24,136,25],[136,26,136,27],[0,11,1,11],[0,12,1,12],[52,11,52,12],[135,26,135,27],[136,12,136,13],[136,14,136,15],[136,16,136,17],[136,18,136,19],[136,20,136,21],[135,22,135,23],[135,24,135,25],[129,0,129,6],[135,12,135,13],[135,14,135,15],[135,16,135,17],[135,18,135,19],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,13,53,14],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[7,8,7,9],[7,10,7,11],[8,8,8,9],[8,10,8,11],[135,20,135,21],[52,13,52,14],[52,15,52,16],[53,15,53,16],[7,22,7,23],[8,22,8,23],[7,12,7,13],[7,14,7,15],[8,12,8,13],[8,14,8,15],[7,18,7,19],[8,18,8,19],[7,20,7,21],[8,20,8,21],[7,16,7,17],[8,16,8,17],[262,5,262,10],[263,5,263,10],[258,5,258,10],[257,5,257,10],[259,5,259,10],[260,5,260,10],[261,5,261,10]]}
[{"$f":"'Rate Application'!L1","v":"FY2025"},null,null,null,null,null,{"$f":"RIGHT(A1,4)-1","v":2024},null,null,"** Employee Type:","Employee Class","Description:","Fringe Rate:"]
[{"$f":"IFERROR('Rate Application'!E7:L7,\"\")","v":""}]
[{"$f":"IFERROR('Rate Application'!E8:L8,\"\")","v":""},null,null,null,null,null,null,null,null,"Faculty \n","F1, F2, F3, F6, F7, F8, FC, SS","All faculty",0.317]
[null,null,null,null,null,null,null,null,null,"Staff\n","AC, C1, C2, C3, CM, E1, E2, E3, EC, P1, P2, P3, T1","Classified, Exempt & TH",0.40100000000000002]
["Salaries and Fringe Benefits",null,null,null,null,null,null,null,null,"Student\n","GA, SF, SI, ST","All other employee types",0.02]
["For instructions on obtaining salary information, please see additional instructions provided on the Instructions page of this workbook",null,null,null,null,null,null,null,null,"Temp/IH\n","E4, F4, F9, P4, T4, T5","Non-student: Temp/ Irregular Help",0.10100000000000001]
[]
["Additional are hidden (rows 16-41). Unhide them if additional rows are needed.",null,null,null,null,null,null,null,{"$f":"Information!B8","v":"Data Analysis"},null,{"$f":"Information!B9","v":"Meeting Setups"},null,{"$f":"Information!B10","v":0},null,{"$f":"Information!B11","v":0},null,{"$f":"Information!B12","v":0},null,"Subsidy",null,"Non-service center ",null,"Check totals *"]
[null,null,null,null,null,null," ",null,{"$f":"Information!D8","v":"Analysis for service centers"},null,{"$f":"Information!D9","v":"Planning and setup of zoom (hour meeting)"},null,{"$f":"Information!D10","v":0},null,{"$f":"Information!D11","v":0},null,{"$f":"Information!D12","v":0},null,"(service center expense paid on another index)",null,"(portion of employee's salary not related to the service center and paid elsewhere)",null,"(should be equal to annual amount column)"]
["Name","Employee V#","PCN","Employee Class **","Annual Salary","FTE","Fringe Benefits (estimate)","Total Cost","FTE %","Amount","FTE %","Amount","FTE %","Amount","FTE %","Amount","FTE %","Amount","FTE %","Amount","FTE %","Amount","%","Amount"]
["Joe Vandal","V12345678","P11111","Faculty",65000,1,{"$f":"IF(E11=0,0,IF(D11=\"Faculty\",((E11*F11)*$M$3),IF(D11=\"Staff\",((E11*F11)*$M$4),IF(D11=\"Student\",((F11*E11)*$M$5),IF(D11=\"Temp/IH\",((F11*E11)*$M$6),\"Need Type\")))))","v":20605},{"$f":"G11+E11","v":85605},0.25,{"$f":"I11*H11","v":21401.25},null,{"$f":"K11*H11","v":0},null,{"$f":"M11*H11","v":0},null,{"$f":"O11*H11","v":0},null,{"$f":"Q11*H11","v":0},0.5,{"$f":"S11*$H11","v":42802.5},{"$f":"1-SUMIF(I11:T11,\"<1.01\",I11:T11)","v":0.25},{"$f":"U11*$H11","v":21401.25},{"$f":"IFERROR(X11/H11,0)","v":1},{"$f":"SUMIF(I11:V11,\">1\",I11:V11)","v":85605},{"$f":"IF(X11<>H11,\"Check allocations\",\"\")","v":""}]
["Suzie Grant","V12345678","P2222","Staff",30000,0.5,6015,{"$f":"G12+E12","v":36015},null,{"$f":"I12*H12","v":0},null,0,null,0,null,{"$f":"O12*H12","v":0},null,{"$f":"Q12*H12","v":0},0.05,{"$f":"S12*$H12","v":1800.75},0.95,{"$f":"U12*$H12","v":34214.25},1,36015,""]
[" ",null," ","Faculty",null,null,0,{"$f":"G13+E13","v":0},null,{"$f":"I13*H13","v":0},null,0,null,0,null,{"$f":"O13*H13","v":0},null,{"$f":"Q13*H13","v":0},null,{"$f":"S13*$H13","v":0},1,0,0,0,""]
[" ",null," ","Faculty",null,null,0,{"$f":"G14+E14","v":0},null,{"$f":"I14*H14","v":0},null,0,null,0,null,{"$f":"O14*H14","v":0},null,{"$f":"Q14*H14","v":0},null,0,1,0,0,0,""]
[" ",null," ","Faculty",null,null,0,{"$f":"G15+E15","v":0},null,{"$f":"I15*H15","v":0},null,0,null,0,null,{"$f":"O15*H15","v":0},null,{"$f":"Q15*H15","v":0},null,{"$f":"S15*$H15","v":0},1,0,0,0,""]
[" ",null," ","Faculty",null,null,0,{"$f":"G16+E16","v":0},null,{"$f":"I16*H16","v":0},null,0,null,0,null,{"$f":"O16*H16","v":0},null,{"$f":"Q16*H16","v":0},null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G17+E17","v":0},null,{"$f":"I17*H17","v":0},null,0,null,0,null,{"$f":"O17*H17","v":0},null,{"$f":"Q17*H17","v":0},null,{"$f":"S17*$H17","v":0},1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G18+E18","v":0},null,{"$f":"I18*H18","v":0},null,0,null,0,null,{"$f":"O18*H18","v":0},null,{"$f":"Q18*H18","v":0},null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G19+E19","v":0},null,{"$f":"I19*H19","v":0},null,0,null,0,null,{"$f":"O19*H19","v":0},null,{"$f":"Q19*H19","v":0},null,{"$f":"S19*$H19","v":0},1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G20+E20","v":0},null,{"$f":"I20*H20","v":0},null,0,null,0,null,{"$f":"O20*H20","v":0},null,{"$f":"Q20*H20","v":0},null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G21+E21","v":0},null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G30+E30","v":0},null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,{"$f":"G32+E32","v":0},null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","staff",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[" ",null," ","student",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,1,0,0,0,""]
[]
["GRAND TOTAL SALARIES",null,null,null,{"$f":"SUM(E11:E42)","v":95000},{"$f":"SUM(F11:F42)","v":1.5},{"$f":"SUM(G11:G42)","v":26620},{"$f":"SUM(H11:H42)","v":121620},{"$f":"J44/$X$44","v":0.17596817957572769},{"$f":"SUM(J11:J42)","v":21401.25},{"$f":"L44/$X$44","v":0},{"$f":"SUM(L11:L42)","v":0},{"$f":"N44/$X$44","v":0},{"$f":"SUM(N11:N42)","v":0},{"$f":"P44/$X$44","v":0},{"$f":"SUM(P11:P42)","v":0},{"$f":"R44/$X$44","v":0},{"$f":"SUM(R11:R42)","v":0},{"$f":"T44/$X$44","v":0.3667427232363098},{"$f":"SUM(T11:T42)","v":44603.25},{"$f":"V44/$X$44","v":0.45728909718796251},{"$f":"SUM(V11:V42)","v":55615.5},{"$f":"X44/$X$44","v":1},{"$f":"SUM(X11:X42)","v":121620},{"$f":"IF(X44<>H44,\"Check allocations\",\"\")","v":""}]
[]
["Operating Expenses","(Travel, Other Operating and Equipment under $5,000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to UI customers",null,null,{"$f":"SUM(R44,P44,N44,L44,J44)","v":21401.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total subsidy ",null,null,{"$f":"T44","v":44603.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to external customers",null,null,{"$f":"SUM(X46:X47)","v":66004.5}]
[]
[]
[]
[]
[null,null,null,{"$f":"Information!B8","v":"Data Analysis"},null,{"$f":"Information!B9","v":"Meeting Setups"},null,{"$f":"Information!B10","v":0},null,{"$f":"Information!B11","v":0},null,{"$f":"Information!B12","v":0},null,{"$f":"S8","v":"Subsidy"},null,"Check totals"]
[null,null,null,{"$f":"Information!D8","v":"Analysis for service centers"},null,{"$f":"Information!D9","v":"Planning and setup of zoom (hour meeting)"},null,{"$f":"Information!D10","v":0},null,{"$f":"Information!D11","v":0},null,{"$f":"Information!D12","v":0},null,{"$f":"S9","v":"(service center expense paid on another index)"},null,"(this should be equal to annual amount column)"]
["Description (expense code title)","Ecode","Annual Amt","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount"]
["Supplies",null,3400,0.45,{"$f":"$C56*D56","v":1530},0.55000000000000004,{"$f":"$C56*F56","v":1870.0000000000002},null,{"$f":"$C56*H56","v":0},null,{"$f":"$C56*J56","v":0},null,{"$f":"$C56*L56","v":0},{"$f":"1-D56-F56-H56-J56-L56","v":0},{"$f":"$C56*N56","v":0},{"$f":"SUM(D56,F56,H56,J56,L56,N56)","v":1},{"$f":"SUM(E56,G56,I56,K56,M56,O56)","v":3400}]
["Subscription",null,2000,null,0,null,0,null,0,null,0,null,0,{"$f":"1-D57-F57-H57-J57-L57","v":1},2000,{"$f":"SUM(D57,F57,H57,J57,L57,N57)","v":1},{"$f":"SUM(E57,G57,I57,K57,M57,O57)","v":2000}]
["Other services",null,9500,0.2,1900,null,0,null,0,null,0,null,0,0.8,7600,1,9500]
["Supplies- External User",null,8000,0.5,4000,0.5,4000,null,0,null,0,null,0,0,0,1,8000]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
["Repairs",null,2500,0.1,250,0.9,2250,null,0,null,0,null,0,0,0,1,2500]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,{"$f":"$C88*D88","v":0},null,{"$f":"$C88*F88","v":0},null,{"$f":"$C88*H88","v":0},null,{"$f":"$C88*J88","v":0},null,{"$f":"$C88*L88","v":0},1,{"$f":"$C88*N88","v":0},1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,{"$f":"$C120*D120","v":0},null,{"$f":"$C120*F120","v":0},null,{"$f":"$C120*H120","v":0},null,{"$f":"$C120*J120","v":0},null,{"$f":"$C120*L120","v":0},1,{"$f":"$C120*N120","v":0},1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"1-D121-F121-H121-J121-L121","v":1},0,{"$f":"SUM(D121,F121,H121,J121,L121,N121)","v":1},{"$f":"SUM(E121,G121,I121,K121,M121,O121)","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[]
["GRAND TOTAL OPERATING EXPENSES:",null,{"$f":"SUM(C56:C123)","v":25400},{"$f":"E125/$Q$125","v":0.30236220472440944},{"$f":"SUM(E56:E123)","v":7680},{"$f":"G125/$Q$125","v":0.31968503937007875},{"$f":"SUM(G56:G123)","v":8120},{"$f":"I125/$Q$125","v":0},{"$f":"SUM(I56:I123)","v":0},{"$f":"K125/$Q$125","v":0},{"$f":"SUM(K56:K123)","v":0},{"$f":"M125/$Q$125","v":0},{"$f":"SUM(M56:M123)","v":0},{"$f":"O125/$Q$125","v":0.37795275590551181},{"$f":"SUM(O56:O123)","v":9600},{"$f":"Q125/$Q$125","v":1},{"$f":"SUM(Q56:Q123)","v":25400}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to UI customers",null,null,{"$f":"SUM(M125,K125,I125,G125,E125)","v":15800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total subsidy ",null,null,{"$f":"O125","v":9600}]
[null,null,null,null,null,null,null,{"$f":"ABS(RIGHT('Rate Application'!L136,4))","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Total charged to external customers",null,null,{"$f":"SUM(Q127:Q128)","v":25400}]
["Capital Equipment and Depreciation"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D53","v":"Data Analysis"},null,{"$f":"F53","v":"Meeting Setups"},null,{"$f":"H53","v":0},null,{"$f":"J53","v":0},null,{"$f":"L53","v":0},null,"Subsidy ",null,"Unallowable equipment *",null,"Depreciation Included in Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":"Analysis for service centers"},null,{"$f":"F54","v":"Planning and setup of zoom (hour meeting)"},null,{"$f":"H54","v":0},null,{"$f":"J54","v":0},null,{"$f":"L54","v":0},null,"Service center expense paid on another index",null,"Used in service center but unallowable in rates (e.g. purchased with Federal funds)",null,"Amount of depreciation charged to customers"]
["Description/Type of Equipment","Asset Type","Bld/Rm","Otag","UI Property Tag#","Acquisition Index/Fund No.","Fiscal Year Acquistion ","Depr Start Year","Depr End Year","Acquisition Cost","Useful Life (years)","Annual Depreciation","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount"]
["Picnic Table","FN","017/209D","T00472271",198673,151000,2017,{"$f":"G139","v":2017},{"$f":"IF(G139>0,G139+K139-1,\"\")","v":2026},6106.56,10,{"$f":"IFERROR(IF($G$1>I139,0,J139/K139),\"\")","v":610.65600000000006},1,{"$f":"IFERROR(($L139*M139),\"\")","v":610.65600000000006},null,0,null,0,null,0,null,0,{"$f":"1-Y139-M139-O139-Q139-S139-U139","v":0},0,null,0,{"$f":"SUM(M139,O139,Q139,S139,U139,Y139,W139)","v":1},{"$f":"SUM(N139,P139,R139,T139,V139,Z139,X139)","v":610.65600000000006}]
["Video Conference System","ME",null,"T00472461",198790,151000,2017,{"$f":"G140","v":2017},{"$f":"IF(G140>0,G140+K140-1,\"\")","v":2023},8000,7,{"$f":"IFERROR(IF($G$1>I140,0,J140/K140),\"\")","v":0},null,0,null,{"$f":"IFERROR(($L140*O140),\"\")","v":0},null,{"$f":"IFERROR(($L140*Q140),\"\")","v":0},null,{"$f":"IFERROR(($L140*S140),\"\")","v":0},null,{"$f":"IFERROR(($L140*U140),\"\")","v":0},{"$f":"1-Y140-M140-O140-Q140-S140-U140","v":1},{"$f":"IFERROR(($L140*W140),\"\")","v":0},null,{"$f":"IFERROR(($L140*Y140),\"\")","v":0},{"$f":"SUM(M140,O140,Q140,S140,U140,Y140,W140)","v":1},{"$f":"SUM(N140,P140,R140,T140,V140,Z140,X140)","v":0}]
["Microscope w/Camera","LE","017/209D","T00476515","406949",220000,2021,2021,2027,17554.95,7,2507.85,null,{"$f":"IFERROR(($L141*M141),\"\")","v":0},null,{"$f":"IFERROR(($L141*O141),\"\")","v":0},null,0,null,0,null,0,0,{"$f":"IFERROR(($L141*W141),\"\")","v":0},1,{"$f":"IFERROR(($L141*Y141),\"\")","v":2507.85},1,2507.85]
[null,null,null,null,null,null,null,0,"",null,null,"",null,{"$f":"IFERROR(($L142*M142),\"\")","v":""},null,{"$f":"IFERROR(($L142*O142),\"\")","v":""},null,"",null,"",null,"",1,{"$f":"IFERROR(($L142*W142),\"\")","v":""},null,{"$f":"IFERROR(($L142*Y142),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L143*W143),\"\")","v":""},null,{"$f":"IFERROR(($L143*Y143),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L144*W144),\"\")","v":""},null,{"$f":"IFERROR(($L144*Y144),\"\")","v":""},1,0]
["Video Projector","ME","017/209D",null,"XXXXXX","12XXXX",2023,2023,2029,15000,7,2142.8571428571427,0.15,321.42857142857139,0.85,1821.4285714285711,null,0,null,0,null,0,0,{"$f":"IFERROR(($L145*W145),\"\")","v":0},null,{"$f":"IFERROR(($L145*Y145),\"\")","v":0},1,2142.8571428571427]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L146*W146),\"\")","v":""},null,{"$f":"IFERROR(($L146*Y146),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L147*W147),\"\")","v":""},null,{"$f":"IFERROR(($L147*Y147),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L148*W148),\"\")","v":""},null,{"$f":"IFERROR(($L148*Y148),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L149*W149),\"\")","v":""},null,{"$f":"IFERROR(($L149*Y149),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L150*W150),\"\")","v":""},null,{"$f":"IFERROR(($L150*Y150),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L151*W151),\"\")","v":""},null,{"$f":"IFERROR(($L151*Y151),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L152*W152),\"\")","v":""},null,{"$f":"IFERROR(($L152*Y152),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L153*W153),\"\")","v":""},null,{"$f":"IFERROR(($L153*Y153),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L154*W154),\"\")","v":""},null,{"$f":"IFERROR(($L154*Y154),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L155*W155),\"\")","v":""},null,{"$f":"IFERROR(($L155*Y155),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L156*W156),\"\")","v":""},null,{"$f":"IFERROR(($L156*Y156),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L157*W157),\"\")","v":""},null,{"$f":"IFERROR(($L157*Y157),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L158*W158),\"\")","v":""},null,{"$f":"IFERROR(($L158*Y158),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L159*W159),\"\")","v":""},null,{"$f":"IFERROR(($L159*Y159),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L160*W160),\"\")","v":""},null,{"$f":"IFERROR(($L160*Y160),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L161*W161),\"\")","v":""},null,{"$f":"IFERROR(($L161*Y161),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L162*W162),\"\")","v":""},null,{"$f":"IFERROR(($L162*Y162),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L163*W163),\"\")","v":""},null,{"$f":"IFERROR(($L163*Y163),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L164*W164),\"\")","v":""},null,{"$f":"IFERROR(($L164*Y164),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L165*W165),\"\")","v":""},null,{"$f":"IFERROR(($L165*Y165),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L166*W166),\"\")","v":""},null,{"$f":"IFERROR(($L166*Y166),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L167*W167),\"\")","v":""},null,{"$f":"IFERROR(($L167*Y167),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L168*W168),\"\")","v":""},null,{"$f":"IFERROR(($L168*Y168),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L169*W169),\"\")","v":""},null,{"$f":"IFERROR(($L169*Y169),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L170*W170),\"\")","v":""},null,{"$f":"IFERROR(($L170*Y170),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L171*W171),\"\")","v":""},null,{"$f":"IFERROR(($L171*Y171),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L172*W172),\"\")","v":""},null,{"$f":"IFERROR(($L172*Y172),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L173*W173),\"\")","v":""},null,{"$f":"IFERROR(($L173*Y173),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L174*W174),\"\")","v":""},null,{"$f":"IFERROR(($L174*Y174),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L175*W175),\"\")","v":""},null,{"$f":"IFERROR(($L175*Y175),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L176*W176),\"\")","v":""},null,{"$f":"IFERROR(($L176*Y176),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L177*W177),\"\")","v":""},null,{"$f":"IFERROR(($L177*Y177),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L178*W178),\"\")","v":""},null,{"$f":"IFERROR(($L178*Y178),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L179*W179),\"\")","v":""},null,{"$f":"IFERROR(($L179*Y179),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L180*W180),\"\")","v":""},null,{"$f":"IFERROR(($L180*Y180),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L181*W181),\"\")","v":""},null,{"$f":"IFERROR(($L181*Y181),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L182*W182),\"\")","v":""},null,{"$f":"IFERROR(($L182*Y182),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L183*W183),\"\")","v":""},null,{"$f":"IFERROR(($L183*Y183),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L184*W184),\"\")","v":""},null,{"$f":"IFERROR(($L184*Y184),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L185*W185),\"\")","v":""},null,{"$f":"IFERROR(($L185*Y185),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L186*W186),\"\")","v":""},null,{"$f":"IFERROR(($L186*Y186),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L187*W187),\"\")","v":""},null,{"$f":"IFERROR(($L187*Y187),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L188*W188),\"\")","v":""},null,{"$f":"IFERROR(($L188*Y188),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L189*W189),\"\")","v":""},null,{"$f":"IFERROR(($L189*Y189),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L190*W190),\"\")","v":""},null,{"$f":"IFERROR(($L190*Y190),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L191*W191),\"\")","v":""},null,{"$f":"IFERROR(($L191*Y191),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L192*W192),\"\")","v":""},null,{"$f":"IFERROR(($L192*Y192),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L193*W193),\"\")","v":""},null,{"$f":"IFERROR(($L193*Y193),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L194*W194),\"\")","v":""},null,{"$f":"IFERROR(($L194*Y194),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L195*W195),\"\")","v":""},null,{"$f":"IFERROR(($L195*Y195),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L196*W196),\"\")","v":""},null,{"$f":"IFERROR(($L196*Y196),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L197*W197),\"\")","v":""},null,{"$f":"IFERROR(($L197*Y197),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L198*W198),\"\")","v":""},null,{"$f":"IFERROR(($L198*Y198),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L199*W199),\"\")","v":""},null,{"$f":"IFERROR(($L199*Y199),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L200*W200),\"\")","v":""},null,{"$f":"IFERROR(($L200*Y200),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L201*W201),\"\")","v":""},null,{"$f":"IFERROR(($L201*Y201),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L202*W202),\"\")","v":""},null,{"$f":"IFERROR(($L202*Y202),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L203*W203),\"\")","v":""},null,{"$f":"IFERROR(($L203*Y203),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,{"$f":"G204","v":0},{"$f":"IF(G204>0,G204+K204-1,\"\")","v":""},null,null,{"$f":"IFERROR(IF($G$1>I204,0,J204/K204),\"\")","v":""},null,"",null,"",null,{"$f":"IFERROR(($L204*Q204),\"\")","v":""},null,{"$f":"IFERROR(($L204*S204),\"\")","v":""},null,{"$f":"IFERROR(($L204*U204),\"\")","v":""},{"$f":"1-Y204-M204-O204-Q204-S204-U204","v":1},{"$f":"IFERROR(($L204*W204),\"\")","v":""},null,{"$f":"IFERROR(($L204*Y204),\"\")","v":""},{"$f":"SUM(M204,O204,Q204,S204,U204,Y204,W204)","v":1},{"$f":"SUM(N204,P204,R204,T204,V204,Z204,X204)","v":0}]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L205*W205),\"\")","v":""},null,{"$f":"IFERROR(($L205*Y205),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,{"$f":"IFERROR(($L206*M206),\"\")","v":""},null,{"$f":"IFERROR(($L206*O206),\"\")","v":""},null,"",null,"",null,"",1,{"$f":"IFERROR(($L206*W206),\"\")","v":""},null,{"$f":"IFERROR(($L206*Y206),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L207*W207),\"\")","v":""},null,{"$f":"IFERROR(($L207*Y207),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L208*W208),\"\")","v":""},null,{"$f":"IFERROR(($L208*Y208),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L209*W209),\"\")","v":""},null,{"$f":"IFERROR(($L209*Y209),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L210*W210),\"\")","v":""},null,{"$f":"IFERROR(($L210*Y210),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L211*W211),\"\")","v":""},null,{"$f":"IFERROR(($L211*Y211),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L212*W212),\"\")","v":""},null,{"$f":"IFERROR(($L212*Y212),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L213*W213),\"\")","v":""},null,{"$f":"IFERROR(($L213*Y213),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L214*W214),\"\")","v":""},null,{"$f":"IFERROR(($L214*Y214),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L215*W215),\"\")","v":""},null,{"$f":"IFERROR(($L215*Y215),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L216*W216),\"\")","v":""},null,{"$f":"IFERROR(($L216*Y216),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L217*W217),\"\")","v":""},null,{"$f":"IFERROR(($L217*Y217),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L218*W218),\"\")","v":""},null,{"$f":"IFERROR(($L218*Y218),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L219*W219),\"\")","v":""},null,{"$f":"IFERROR(($L219*Y219),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L220*W220),\"\")","v":""},null,{"$f":"IFERROR(($L220*Y220),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L221*W221),\"\")","v":""},null,{"$f":"IFERROR(($L221*Y221),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L222*W222),\"\")","v":""},null,{"$f":"IFERROR(($L222*Y222),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L223*W223),\"\")","v":""},null,{"$f":"IFERROR(($L223*Y223),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L224*W224),\"\")","v":""},null,{"$f":"IFERROR(($L224*Y224),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L225*W225),\"\")","v":""},null,{"$f":"IFERROR(($L225*Y225),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L226*W226),\"\")","v":""},null,{"$f":"IFERROR(($L226*Y226),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L227*W227),\"\")","v":""},null,{"$f":"IFERROR(($L227*Y227),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L228*W228),\"\")","v":""},null,{"$f":"IFERROR(($L228*Y228),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L229*W229),\"\")","v":""},null,{"$f":"IFERROR(($L229*Y229),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L230*W230),\"\")","v":""},null,{"$f":"IFERROR(($L230*Y230),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L231*W231),\"\")","v":""},null,{"$f":"IFERROR(($L231*Y231),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L232*W232),\"\")","v":""},null,{"$f":"IFERROR(($L232*Y232),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L233*W233),\"\")","v":""},null,{"$f":"IFERROR(($L233*Y233),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L234*W234),\"\")","v":""},null,{"$f":"IFERROR(($L234*Y234),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L235*W235),\"\")","v":""},null,{"$f":"IFERROR(($L235*Y235),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L236*W236),\"\")","v":""},null,{"$f":"IFERROR(($L236*Y236),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L237*W237),\"\")","v":""},null,{"$f":"IFERROR(($L237*Y237),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L238*W238),\"\")","v":""},null,{"$f":"IFERROR(($L238*Y238),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L239*W239),\"\")","v":""},null,{"$f":"IFERROR(($L239*Y239),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L240*W240),\"\")","v":""},null,{"$f":"IFERROR(($L240*Y240),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L241*W241),\"\")","v":""},null,{"$f":"IFERROR(($L241*Y241),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L242*W242),\"\")","v":""},null,{"$f":"IFERROR(($L242*Y242),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L243*W243),\"\")","v":""},null,{"$f":"IFERROR(($L243*Y243),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L244*W244),\"\")","v":""},null,{"$f":"IFERROR(($L244*Y244),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L245*W245),\"\")","v":""},null,{"$f":"IFERROR(($L245*Y245),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L246*W246),\"\")","v":""},null,{"$f":"IFERROR(($L246*Y246),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L247*W247),\"\")","v":""},null,{"$f":"IFERROR(($L247*Y247),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L248*W248),\"\")","v":""},null,{"$f":"IFERROR(($L248*Y248),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L249*W249),\"\")","v":""},null,{"$f":"IFERROR(($L249*Y249),\"\")","v":""},1,0]
[null,null,null,null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($L250*W250),\"\")","v":""},null,{"$f":"IFERROR(($L250*Y250),\"\")","v":""},1,0]
[]
["TOTAL ALLOWABLE DEPRECIATION",null,null,null,null,null,null,null,null,{"$f":"SUM(J139:J250)","v":46661.51},null,{"$f":"SUM(L139:L250)","v":5261.3631428571425},{"$f":"N252/$AB$252","v":0.17715647943707802},{"$f":"SUM(N139:N251)","v":932.08457142857151},{"$f":"P252/$AB$252","v":0.34618948017328044},{"$f":"SUM(P139:P251)","v":1821.4285714285711},{"$f":"R252/$AB$252","v":0},{"$f":"SUM(R139:R251)","v":0},{"$f":"T252/$AB$252","v":0},{"$f":"SUM(T139:T251)","v":0},{"$f":"V252/$AB$252","v":0},{"$f":"SUM(V139:V251)","v":0},{"$f":"X252/$AB$252","v":0},{"$f":"SUM(X139:X251)","v":0},{"$f":"Z252/$AB$252","v":0.47665404038964154},{"$f":"SUM(Z139:Z251)","v":2507.85},{"$f":"AB252/$AB$252","v":1},{"$f":"SUM(AB139:AB250)","v":5261.3631428571425}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to UI customers",null,null,{"$f":"SUM(V252,T252,R252,P252,N252)","v":2753.5131428571426}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total subsidy & unallowable",null,null,{"$f":"X252+Z252","v":2507.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to external customers",null,null,{"$f":"SUM(AB254:AB255)","v":5261.3631428571425}]
["Comments"]
["Equipment","Asset Type","Bld/Rm","Otag","UI Property Tag#","Comment"]
["Video Conference System","ME","017/209D","T00472461",198790,"Was supposed to move from 209C to 209D on 06/30/2024 - Not sure if that took place yet. SS 09/23/24"]

{"sheet":"Rate Summary","index":8,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,3,5,7]]}
[{"$f":"IFERROR('Rate Application'!E7:L7,\"\")","v":""}]
[{"$f":"Information!F4","v":150000}]
["Service Center Rate Summary Sheet"]
[{"$f":"'Rate Application'!L1","v":"FY2025"}]
[]
[null,null,null,null,null,null,null,null,"TOTAL"]
[null,"Y/N","%",{"$f":"Information!B8","v":"Data Analysis"},{"$f":"Information!B9","v":"Meeting Setups"},{"$f":"Information!B10","v":0},{"$f":"Information!B11","v":0},{"$f":"Information!B12","v":0},"All Services"]
["Current year rates",null,null,{"$f":"IF((ISBLANK(Information!G$8)=TRUE),\"N/A\",+Information!G$8)","v":50},{"$f":"IF((ISBLANK(Information!$G9)=TRUE),\"N/A\",+Information!$G9)","v":145},{"$f":"IF((ISBLANK(Information!$G10)=TRUE),\"N/A\",+Information!$G10)","v":"N/A"},{"$f":"IF((ISBLANK(Information!$G11)=TRUE),\"N/A\",+Information!$G11)","v":"N/A"},{"$f":"IF((ISBLANK(Information!$G12)=TRUE),\"N/A\",+Information!$G12)","v":"N/A"},"(not include subsidy)"]
["Prior Year Fund Balance (if applicable)",null,null,{"$f":"IFERROR((Information!$F$5*'Rate Summary'!D34),0)","v":1011.457892891667},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!E34),0)","v":335.02896425119036},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!F34),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!G34),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!H34),0)","v":0},{"$f":"SUM(D9:H9)","v":1346.4868571428574}]
[]
["ANNUAL COSTS"]
["Salaries and Fringe Benefits",null,null,{"$f":"'Salary Operating and Deprec Exp'!J44","v":21401.25},{"$f":"'Salary Operating and Deprec Exp'!L44","v":0},{"$f":"'Salary Operating and Deprec Exp'!N44","v":0},{"$f":"'Salary Operating and Deprec Exp'!P44","v":0},{"$f":"'Salary Operating and Deprec Exp'!R44","v":0},{"$f":"SUM(D12:H12)","v":21401.25}]
["Operating Costs",null,null,{"$f":"'Salary Operating and Deprec Exp'!E125","v":7680},{"$f":"'Salary Operating and Deprec Exp'!G125","v":8120},{"$f":"'Salary Operating and Deprec Exp'!I125","v":0},{"$f":"'Salary Operating and Deprec Exp'!K125","v":0},{"$f":"'Salary Operating and Deprec Exp'!M125","v":0},{"$f":"SUM(D13:H13)","v":15800}]
["Capital equipment depreciation",null,null,{"$f":"IFERROR('Salary Operating and Deprec Exp'!N252,0)","v":932.08457142857151},{"$f":"IFERROR('Salary Operating and Deprec Exp'!P252,0)","v":1821.4285714285711},{"$f":"IFERROR('Salary Operating and Deprec Exp'!R252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!T252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!V252,0)","v":0},{"$f":"SUM(D14:H14)","v":2753.5131428571426}]
[null,null,null,null,null,null,null,null,null,"Annual costs totals check"]
["SUBTOTAL ANNUAL SERVICE COSTS",null,null,{"$f":"SUM(D12:D15)","v":30013.334571428572},{"$f":"SUM(E12:E15)","v":9941.4285714285706},0,0,0,{"$f":"SUM(D16:H16)","v":39954.76314285714},{"$f":"ROUND((-$I$16+'Salary Operating and Deprec Exp'!AB254+'Salary Operating and Deprec Exp'!Q127+'Salary Operating and Deprec Exp'!X46),0)","v":0}]
[]
["Estimated 2 months working capital",null,null,{"$f":"D16/365*60","v":4933.6988336594914},{"$f":"E16*0.166","v":1650.2771428571427},0,0,0,{"$f":"SUM(D18:H18)","v":6583.9759765166345}]
[]
["TOTAL ANNUAL SERVICE COSTS (includes working capital)",null,null,{"$f":"D16+D18","v":34947.033405088063},{"$f":"E16+E18","v":11591.705714285714},0,0,0,{"$f":"SUM(D20:H20)","v":46538.739119373779}]
[null,null,null,null,null,null,null,null,null,"PY balance totals check"]
["Prior Year Balance (Add Deficit, Subtract Surplus)",null,null,{"$f":"-1*D9","v":-1011.457892891667},{"$f":"-1*E9","v":-335.02896425119036},{"$f":"-1*F9","v":0},{"$f":"-1*G9","v":0},{"$f":"-1*H9","v":0},{"$f":"SUM(D22:H22)","v":-1346.4868571428574},{"$f":"$I$22+Information!$F$5","v":0}]
[]
["TOTAL REVISED COSTS (includes PY balance)",null,null,{"$f":"D22+D20","v":33935.575512196396},{"$f":"E22+E20","v":11256.676750034523},0,0,0,{"$f":"SUM(D24:H24)","v":45192.252262230919}]
[]
["# of Annual Units",null,null,{"$f":"Information!I8","v":500},{"$f":"Information!I9","v":55},{"$f":"Information!I10","v":0},{"$f":"Information!I11","v":0},{"$f":"Information!I12","v":0}]
["Unit Base",null,null,{"$f":"Information!H8","v":"Hour"},{"$f":"Information!H9","v":"Fixed"},{"$f":"Information!H10","v":0},{"$f":"Information!H11","v":0},{"$f":"Information!H12","v":0}]
[]
["CALCULATED SUBSIDIZED RATE (per unit)",null,null,{"$f":"IF(D26<>0,D24/D26,0)","v":67.871151024392788},{"$f":"IF(E26<>0,E24/E26,0)","v":204.6668500006277},0,0,0]
[]
["UNIT RATE TO BE CHARGED TO UI DEPARTMENTS*",null,null,65,185]
[]
["% difference between cal rate and dept charged (capped at 15%)",null,null,{"$f":"IF(D31=0,0,D31/D29-1)","v":-4.2302966445359136E-2},{"$f":"IF(E31=0,0,E31/E29-1)","v":-9.6092014904061829E-2},0,0,0]
["% of Total Costs",null,null,{"$f":"IF(D16=0,0,D16/$I$16)","v":0.75118289311631581},{"$f":"IF(E16=0,0,E16/$I$16)","v":0.24881710688368419},{"$f":"IF(F16=0,0,F16/$I$16)","v":0},{"$f":"IF(G16=0,0,G16/$I$16)","v":0},{"$f":"IF(H16=0,0,H16/$I$16)","v":0},{"$f":"SUM(D34:H34)","v":1}]
[null,null,null,null,null,null,null,null,null,"Subsidy totals check"]
["Salary & Operating Exp Subsidies",null,null,{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$Q$128)*'Rate Summary'!D34","v":40716.554151306947},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$Q$128)*'Rate Summary'!E34","v":13486.695848693054},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$Q$128)*'Rate Summary'!F34","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$Q$128)*'Rate Summary'!G34","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$Q$128)*'Rate Summary'!H34","v":0},{"$f":"SUM(D36:H36)","v":54203.25},{"$f":"SUM($I$36+I37)-'Salary Operating and Deprec Exp'!X47-'Salary Operating and Deprec Exp'!Q128-'Salary Operating and Deprec Exp'!AB255","v":0}]
["Recoverable \"unallowable\" Depreciation",null,null,{"$f":"SUM('Salary Operating and Deprec Exp'!$AB$255)*'Rate Summary'!D34","v":1883.8540185017525},{"$f":"SUM('Salary Operating and Deprec Exp'!$AB$255)*'Rate Summary'!E34","v":623.99598149824737},{"$f":"SUM('Salary Operating and Deprec Exp'!$AB$255)*'Rate Summary'!F34","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$AB$255)*'Rate Summary'!G34","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$AB$255)*'Rate Summary'!H34","v":0},{"$f":"SUM(D37:H37)","v":2507.85}]
["Optional Equipment Replacement Fee (up to 10%)","N",0.1,{"$f":"IF($B$38=\"Y\",SUM(D37+D14)*$C$38,0)","v":0},{"$f":"IF($B$38=\"Y\",SUM(E37+E14)*$C$38,0)","v":0},0,0,{"$f":"IF($B$38=\"Y\",SUM(H37+H14)*$C$38,0)","v":0},{"$f":"SUM(D38:H38)","v":0}]
["Fee in excess of cost (G&A FY25 11%)","Y",0.11,{"$f":"IF($B$39=\"Y\",(SUM(Information!$G$19)*$C$39)*D34,0)","v":743.67106418515266},{"$f":"IF($B$39=\"Y\",(SUM(Information!$G$19)*$C$39)*E34,0)","v":246.32893581484734},{"$f":"IF($B$39=\"Y\",(SUM(Information!$G$19)*$C$39)*F34,0)","v":0},{"$f":"IF($B$39=\"Y\",(SUM(Information!$G$19)*$C$39)*G34,0)","v":0},{"$f":"IF($B$39=\"Y\",(SUM(Information!$G$19)*$C$39)*H34,0)","v":0},990]
[]
["TOTAL SERVICE COSTS (includes subsidy & unallowable depreciation)",null,null,{"$f":"D24+D36+D37+D38+D39","v":77279.654746190252},{"$f":"E24+E36+E37+E38+E39","v":25613.697516040669},0,0,0,{"$f":"SUM(D41:H41)","v":102893.35226223092},{"$f":"ROUND((I41-'Salary Operating and Deprec Exp'!AB256-'Salary Operating and Deprec Exp'!Q129-'Salary Operating and Deprec Exp'!X48-I18-I22),0)","v":990}]
[]
["UNSUBSIDIZED (FULL COST) RATES: EXTERNAL CUSTOMERS",null,null,{"$f":"IFERROR(D41/D26,0)","v":154.55930949238049},{"$f":"IFERROR(E41/E26,0)","v":465.70359120073942},{"$f":"IFERROR(F41/F26,0)","v":0},{"$f":"IFERROR(G41/G26,0)","v":0},{"$f":"IFERROR(H41/H26,0)","v":0}]
[]
["UNIT RATE TO BE CHARGED TO EXTERNAL CUSTOMERS*",null,null,150,500]

{"sheet":"Rate Sheet","index":9,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,4,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
["Service Center Billing Rates"]
[{"$f":"'Rate Application'!L1","v":"FY2025"}]
[{"$f":"'Rate Application'!E6","v":"University Vandal Service Center"}]
[{"$f":"+Information!F4","v":150000}]
[]
["Service ","Description","Unit"," Internal Rate","External Rate"]
[{"$f":"Information!B8","v":"Data Analysis"},{"$f":"Information!D8","v":"Analysis for service centers"},{"$f":"Information!H8","v":"Hour"},{"$f":"Information!J8","v":65},{"$f":"IFERROR('Rate Summary'!D43,\"N/A\")","v":154.55930949238049}]
[{"$f":"Information!B9","v":"Meeting Setups"},{"$f":"Information!D9","v":"Planning and setup of zoom (hour meeting)"},{"$f":"Information!H9","v":"Fixed"},{"$f":"Information!J9","v":185},{"$f":"IFERROR('Rate Summary'!E43,\"N/A\")","v":465.70359120073942}]
[{"$f":"Information!B10","v":0},{"$f":"Information!D10","v":0},{"$f":"Information!H10","v":0},{"$f":"Information!J10","v":0},{"$f":"IFERROR('Rate Summary'!F43,\"N/A\")","v":0}]
[{"$f":"Information!B11","v":0},{"$f":"Information!D11","v":0},{"$f":"Information!H11","v":0},{"$f":"Information!J11","v":0},{"$f":"IFERROR('Rate Summary'!G43,\"N/A\")","v":0}]
[{"$f":"Information!B12","v":0},{"$f":"Information!D12","v":0},{"$f":"Information!H12","v":0},{"$f":"Information!J12","v":0},{"$f":"IFERROR('Rate Summary'!H43,\"N/A\")","v":0}]
[]
[]
[]
[]
["Approver's Signatures",null,null,"Date"]
[]
[]
[]
["Heather Clark, Assistant Director Sponsored Accounting"]
[]
[]
[]
["Amanda Bauer, University Controller"]

{"sheet":"Index Summary","index":10,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,0,2,3],[5,0,5,3],[5,5,5,8],[1,0,1,2]]}
[{"$f":"'Rate Application'!E7&\" Index Summary\"","v":"Morrill Hall (017), Room 209D Index Summary"}]
[{"$f":"IFERROR(Information!E3,\"\")","v":"University Vandal Service Center"}]
[{"$f":"'Rate Application'!L1","v":"FY2025"}]
[]
[]
[{"$f":"Information!B18&\" \"&Information!D18","v":"79XXXX/150000 "},null,null,null,null,{"$f":"Information!B27&\" \"&Information!C27","v":"79XXXX/151001 University Vandal Service Center - Equip Reserve Account"}]
["Projected Operating Index",null,null,null,null,"Projected Capital Equip Replacement Index"]
[]
["Revenue",null,null,null,null,"Depreciation"]
[null,{"$f":"+Information!B8","v":"Data Analysis"},{"$f":"IFERROR(('Rate Summary'!D31*'Rate Summary'!D26),0)","v":32500},null,null,null,"Transfer from operating index **",{"$f":"C20+C25","v":2753.5131428571426}]
[null,{"$f":"+Information!B9","v":"Meeting Setups"},{"$f":"IFERROR(('Rate Summary'!E31*'Rate Summary'!E26),0)","v":10175},null,null,null,"Prior year carryover",{"$f":"Information!J27","v":7753.5131428571422}]
[null,{"$f":"+Information!B10","v":0},{"$f":"IFERROR(('Rate Summary'!F$31*'Rate Summary'!F$26),0)","v":0}]
[null,{"$f":"+Information!B11","v":0},{"$f":"IFERROR(('Rate Summary'!G$31*'Rate Summary'!G$26),0)","v":0},null,null,"Total Accumulated Depreciation",null,{"$f":"SUM(H10:H12)","v":10507.026285714284}]
[null,{"$f":"+Information!B12","v":0},{"$f":"IFERROR(('Rate Summary'!H$31*'Rate Summary'!H$26),0)","v":0}]
["Total Revenue",null,{"$f":"SUM(C10:C14)","v":42675},null,null,"Expenditures"]
[null,null,null,null,null,null,"Capital Outlay > $5,000 *"]
["Expenditures"]
[null,"Salaries, Fringes, TH",{"$f":"'Salary Operating and Deprec Exp'!X46","v":21401.25}]
[null,"Operating Expenses",{"$f":"'Salary Operating and Deprec Exp'!Q127","v":15800}]
[null,"Capital Equipment depreciation transfer",{"$f":"IFERROR('Salary Operating and Deprec Exp'!AB254,0)","v":2753.5131428571426}]
[]
["Total Expenditures",null,{"$f":"SUM(C18:C21)","v":39954.76314285714}]
[null,null,null,null,null,"Total Expenditures",null,{"$f":"SUM(H16:H22)","v":0}]
["Net",null,{"$f":"C15-C22","v":2720.2368571428597}]
[null,"One time carryforward transfer (if applicable)*",null,null,null,"Net",null,{"$f":"H13-H23","v":10507.026285714284}]
["Grand total",null,{"$f":"C24-C25","v":2720.2368571428597}]

{"sheet":"Reviewer Notes","index":11,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[35,1,35,4],[36,1,36,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4]]}
["Service Center Reviewer Notes"]
[null,null,null,"Recommend approval","Recommend        Rework"]
["Date"]
["Reviewer"]
[]
[]
[null,"Fund",{"$f":"Information!B18","v":"79XXXX/150000"},{"$f":"Information!C18","v":"University Vandal Service Center - Operating Account"}]
[]
[null,"Fund Balance",{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY24"},{"$f":"\"FY\"&ABS(RIGHT(C9,2)-1)","v":"FY23"},{"$f":"\"FY\"&ABS(RIGHT(D9,2)-1)","v":"FY22"}]
[null,"Beg Balance"]
[null,"Revenues"]
[null,"Expenditures"]
[null,"Encumbrances"]
[null,"Transfers Out"]
[]
[null,"Ending Balance",{"$f":"C10+C11-C12-C13-C14","v":0},{"$f":"D10+D11-D12-D13-D14","v":0},0]
[]
[null,"Fund",{"$f":"Information!B27","v":"79XXXX/151001"},{"$f":"Information!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Fund Balance",{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY24"},{"$f":"\"FY\"&ABS(RIGHT(C20,2)-1)","v":"FY23"},{"$f":"\"FY\"&ABS(RIGHT(D20,2)-1)","v":"FY22"}]
[null,"Beg Balance"]
[null,"Revenues"]
[null,"Expenditures"]
[null,"Encumbrances"]
[null,"Transfers Out"]
[]
[null,"Ending Balance",{"$f":"C21+C22-C23-C24-C25","v":0},{"$f":"D21+D22-D23-D24-D25","v":0},0]
[" "]
["Date","Comments",null,null,null,"Reviewer initials"]