{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Rate Application","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":0,"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":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,25,1],[24,0,24,1],[21,0,21,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[10,0,10,4],[20,0,20,4]]}
["Service Center Rate Development Worksheet"]
["University of Idaho"]
[]
["General Information:"]
[]
[]
[]
[]
[]
[]
["Sheets and purposes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["Bryon Cavolo- Service Center Team Member",null,"bcavolo@uidaho.edu","885-6605"]

{"sheet":"Rate Application","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[10,4,10,6],[10,7,10,9],[10,10,10,11],[13,10,13,11],[14,10,14,11],[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],[9,4,9,6],[9,7,9,9],[9,10,9,11],[1,7,1,8],[24,1,24,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],[25,1,25,11],[27,3,27,4],[13,1,13,9],[14,1,14,9],[15,1,15,9],[19,1,19,4],[27,1,27,2],[16,1,16,11],[20,1,20,11],[15,10,15,11],[17,1,17,11],[21,1,21,11],[35,2,35,6],[35,8,35,11],[31,6,31,7],[31,8,31,9],[31,10,31,11],[33,1,33,10],[34,1,34,2],[34,3,34,6],[34,8,34,11]]}
[null,"Service Center Rate Application",null,null,null,null,null,null,null,null,null,"FY2024"]
[null,"For rates effective:",null,null,null,null,null,"Application Type:",null,null," New","Renewal"]
[]
[null,"College/Division"]
[null,"Department"]
[null,"Service Center Name"]
[null,"Service Center Location"]
[]
[null,"Contact Information:",null,null,"Name",null,null,"Email",null,null,"Phone #"]
[null,"Worksheet preparer"]
[null,"College Fiscal Contact"]
[null,"Service Center Manager"]
[]
[null,"What % of total revenue is charged to internal UI Departments (including your own)?"]
[null,"What % of the above internal revenue is charged to sponsored projects (22 funds)?"]
[null,"What % of total revenue is charged to external (non-UI) customers? *"]
[null,"Description of the product(s) or service(s) provided:"]
[]
[]
[null,"Do competitors exist outside of the UI?",null,null,null,null,"Yes","No"]
[null,"If yes, briefly describe how the service center rates compare to market rates:"]
[]
[]
[null,"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 different fees are charged, please elaborate (who do you charge more or less):"]
[]
[]
[null,"Guarantee Index:"]
[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":"Description_Notes","index":2,"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"," "," "]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments or suggestions to help us provide better service for you:"]

{"sheet":"Information","index":3,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,1,4,3],[2,4,2,5],[6,3,6,5],[7,1,7,2],[8,1,8,2],[9,1,9,2],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,1,10,2],[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],[34,2,34,4],[35,2,35,4],[36,2,36,4],[23,2,23,4],[32,2,32,4]]}
["Index Information",null,null,null,null,null,null,null,null,{"$f":"'Rate Application'!L1","v":"FY2024"}]
[]
[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":"Please fill in Cell E6 on Rate Application Page"}]
[null,"Fund # **"]
[null,"Operating Index Carry Forward ***",null,null,null,{"$f":"J25","v":0}]
[]
[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)","Service 1",null,null,null,null,null,null,null,{"$f":"'Rate Summary'!B31","v":0}]
["2)","Service 2",null,null,null,null,null,null,null,{"$f":"'Rate Summary'!C31","v":0}]
["3)","Service 3",null,null,null,null,null,null,null,{"$f":"'Rate Summary'!D31","v":0}]
["4)","Service 4",null,null,null,null,null,null,null,{"$f":"'Rate Summary'!E31","v":0}]
["5)","Service 5",null,null,null,null,null,null,null,{"$f":"'Rate Summary'!F31","v":0}]
[]
["FUND BALANCE AND SUBSIDY INDEX INFORMATION:"]
[]
["Operating index(s):",null,null,null,null,{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY23"}]
[null,"Index Number","Index Name",null,null,"Carry Forward","Revenue","Expenditures","Transfers","Ending Balance"]
[null,null,null,null,null,null,null,null,null,{"$f":"F18+G18-H18-I18","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"F19+G19-H19-I19","v":0}]
[null," ",null," ",null,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE(J1,\" \",\"Recovered Depreciation\")","v":"FY2024 Recovered Depreciation"},null,null,0,0,0,{"$f":"'Salary Operating and Deprec Exp'!Y254","v":0},0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,"15% Allowable Balance",null,null,0,0,{"$f":"G18*0.15","v":0},0,0]
[null,"TOTAL OPERATING INDEX",null,null,null,{"$f":"SUM(F18:F24)","v":0},{"$f":"SUM(G18:G24)","v":0},{"$f":"SUM(H18:H24)","v":0},{"$f":"SUM(I18:I24)","v":0},{"$f":"SUM(J18:J24)","v":0}]
["Equipment replacement reserves ††"]
[null,null," ",null,null,0,null,null,0,{"$f":"F27+G27-H27-I27","v":0}]
[null,"FUND TOTAL",null,null,null,{"$f":"F27+F25","v":0},{"$f":"G27+G25","v":0},{"$f":"H27+H25","v":0},{"$f":"I27+I25","v":0},{"$f":"J27+J25","v":0}]
[]
[]
["SUBSIDY INDEX INFORMATION:"]
[null,"Index Number","Index Name"]
[]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]

{"sheet":"Equipment list","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Expense Detail","index":5,"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":6,"n_rows":256,"n_cols":25,"rows_kept":256,"cut":false,"hidden":false,"merged":[[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],[7,8,7,9],[7,10,7,11],[8,8,8,9],[8,10,8,11],[135,17,135,18],[52,12,52,13],[52,14,52,15],[53,14,53,15],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[53,12,53,13],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,11],[129,0,129,6],[135,9,135,10],[135,11,135,12],[135,13,135,14],[135,15,135,16],[0,9,1,9],[0,10,1,10],[136,19,136,20],[136,21,136,22],[136,23,136,24],[0,11,1,11],[0,12,1,12],[52,10,52,11],[135,23,135,24],[136,9,136,10],[136,11,136,12],[136,13,136,14],[136,15,136,16],[136,17,136,18],[135,19,135,20],[135,21,135,22]]}
[{"$f":"'Rate Application'!L1","v":"FY2024"},null,null,null,null,null,{"$f":"RIGHT(A1,4)-1","v":2023},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.31]
[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.41299999999999998]
["Salaries and Fringe Benefits",null,null,null,null,null,null,null,null,"Student\n","GA, SF, SI, ST","All other employee types",2.5000000000000001E-2]
["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",8.3000000000000004E-2]
[]
["Additional are hidden (rows 16-41). Unhide them if additional rows are needed.",null,null,null,null,null,null,null,{"$f":"Information!B8","v":"Service 1"},null,{"$f":"Information!B9","v":"Service 2"},null,{"$f":"Information!B10","v":"Service 3"},null,{"$f":"Information!B11","v":"Service 4"},null,{"$f":"Information!B12","v":"Service 5"},null,"Subsidy",null,"Non-service center ",null,"Check totals *"]
[null,null,null,null,null,null," ",null,{"$f":"Information!D8","v":0},null,{"$f":"Information!D9","v":0},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",null,null,{"$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":0},{"$f":"G11+E11","v":0},null,{"$f":"I11*H11","v":0},null,{"$f":"K11*H11","v":0},null,{"$f":"M11*H11","v":0},null,{"$f":"O11*H11","v":0},null,{"$f":"Q11*H11","v":0},null,{"$f":"S11*$H11","v":0},{"$f":"1-SUMIF(I11:T11,\"<1.01\",I11:T11)","v":1},{"$f":"U11*$H11","v":0},{"$f":"IFERROR(X11/H11,0)","v":0},{"$f":"SUMIF(I11:V11,\">1\",I11:V11)","v":0},{"$f":"IF(X11<>H11,\"Check allocations\",\"\")","v":""}]
[" ",null," ","faculty",null,null,0,{"$f":"G12+E12","v":0},null,{"$f":"I12*H12","v":0},null,0,null,0,null,{"$f":"O12*H12","v":0},null,{"$f":"Q12*H12","v":0},null,{"$f":"S12*$H12","v":0},1,{"$f":"U12*$H12","v":0},0,0,""]
[" ",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":0},{"$f":"SUM(F11:F42)","v":0},{"$f":"SUM(G11:G42)","v":0},{"$f":"SUM(H11:H42)","v":0},{"$f":"J44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J11:J42)","v":0},{"$f":"L44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L11:L42)","v":0},{"$f":"N44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N11:N42)","v":0},{"$f":"P44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P11:P42)","v":0},{"$f":"R44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R11:R42)","v":0},{"$f":"T44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(T11:T42)","v":0},{"$f":"V44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(V11:V42)","v":0},{"$f":"X44/$X$44","v":{"$error":"#DIV/0!"}},{"$f":"SUM(X11:X42)","v":0},{"$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":0}]
[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":0}]
[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":0}]
[]
[]
[]
[]
[null,null,{"$f":"Information!B8","v":"Service 1"},null,{"$f":"Information!B9","v":"Service 2"},null,{"$f":"Information!B10","v":"Service 3"},null,{"$f":"Information!B11","v":"Service 4"},null,{"$f":"Information!B12","v":"Service 5"},null,{"$f":"S8","v":"Subsidy"},null,"Check totals"]
[null,null,{"$f":"Information!D8","v":0},null,{"$f":"Information!D9","v":0},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)","Annual Amt","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","%","Amount"]
[null,null,null,{"$f":"$B56*C56","v":0},null,{"$f":"$B56*E56","v":0},null,{"$f":"$B56*G56","v":0},null,{"$f":"$B56*I56","v":0},null,{"$f":"$B56*K56","v":0},{"$f":"1-C56-E56-G56-I56-K56","v":1},{"$f":"$B56*M56","v":0},{"$f":"SUM(C56,E56,G56,I56,K56,M56)","v":1},{"$f":"SUM(D56,F56,H56,J56,L56,N56)","v":0}]
[null,null,null,0,null,{"$f":"$B57*E57","v":0},null,0,null,0,null,0,{"$f":"1-C57-E57-G57-I57-K57","v":1},{"$f":"$B57*M57","v":0},{"$f":"SUM(C57,E57,G57,I57,K57,M57)","v":1},{"$f":"SUM(D57,F57,H57,J57,L57,N57)","v":0}]
[null,null,null,0,null,{"$f":"$B58*E58","v":0},null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,{"$f":"$B66*E66","v":0},null,0,null,0,null,0,1,{"$f":"$B66*M66","v":0},1,0]
[null,null,null,0,null,{"$f":"$B67*E67","v":0},null,0,null,0,null,0,1,{"$f":"$B67*M67","v":0},1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,{"$f":"$B72*C72","v":0},null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,{"$f":"$B88*K88","v":0},1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,{"$f":"$B120*G120","v":0},null,{"$f":"$B120*I120","v":0},null,{"$f":"$B120*K120","v":0},1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"1-C121-E121-G121-I121-K121","v":1},0,{"$f":"SUM(C121,E121,G121,I121,K121,M121)","v":1},{"$f":"SUM(D121,F121,H121,J121,L121,N121)","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[null,null,null,0,null,0,null,0,null,0,null,0,1,0,1,0]
[]
["GRAND TOTAL OPERATING EXPENSES:",{"$f":"SUM(B56:B123)","v":0},{"$f":"D125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D56:D123)","v":0},{"$f":"F125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F56:F123)","v":0},{"$f":"H125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H56:H123)","v":0},{"$f":"J125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J56:J123)","v":0},{"$f":"L125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L56:L123)","v":0},{"$f":"N125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N56:N123)","v":0},{"$f":"P125/$P$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P56:P123)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total charged to UI customers",null,null,{"$f":"SUM(L125,J125,H125,F125,D125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total subsidy ",null,null,{"$f":"N125","v":0}]
["Capital Equipment and Depreciation",null,null,null,null,null,{"$f":"ABS(RIGHT('Rate Application'!L131,4))","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Total charged to external customers",null,null,{"$f":"SUM(P127:P128)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"C53","v":"Service 1"},null,{"$f":"E53","v":"Service 2"},null,{"$f":"G53","v":"Service 3"},null,{"$f":"I53","v":"Service 4"},null,{"$f":"K53","v":"Service 5"},null,"Subsidy ",null,"Unallowable equipment *",null,"Depreciation Included in Rate"]
[null,null,null,null,null,null,null,null,null,{"$f":"C54","v":0},null,{"$f":"Information!K68","v":0},null,{"$f":"Information!K69","v":0},null,{"$f":"Information!K70","v":0},null,{"$f":"Information!K71","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","UI Property Tag#","Acquisition Index 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"]
[null,null,null,null,{"$f":"D139","v":0},{"$f":"IF(D139>0,D139+H139-1,\"\")","v":""},null,null,{"$f":"IFERROR(IF($G$1>F139,0,G139/H139),\"\")","v":""},null,{"$f":"IFERROR(($I139*J139),\"\")","v":""},null,"",null,"",null,"",null,"",{"$f":"1-V139-J139-L139-N139-P139-R139","v":1},"",null,"",{"$f":"SUM(J139,L139,N139,P139,R139,V139,T139)","v":1},{"$f":"SUM(K139,M139,O139,Q139,S139,W139,U139)","v":0}]
[null,null,null,null,{"$f":"D140","v":0},{"$f":"IF(D140>0,D140+H140-1,\"\")","v":""},null,null,{"$f":"IFERROR(IF($G$1>F140,0,G140/H140),\"\")","v":""},null,"",null,{"$f":"IFERROR(($I140*L140),\"\")","v":""},null,{"$f":"IFERROR(($I140*N140),\"\")","v":""},null,{"$f":"IFERROR(($I140*P140),\"\")","v":""},null,{"$f":"IFERROR(($I140*R140),\"\")","v":""},{"$f":"1-V140-J140-L140-N140-P140-R140","v":1},{"$f":"IFERROR(($I140*T140),\"\")","v":""},null,{"$f":"IFERROR(($I140*V140),\"\")","v":""},{"$f":"SUM(J140,L140,N140,P140,R140,V140,T140)","v":1},{"$f":"SUM(K140,M140,O140,Q140,S140,W140,U140)","v":0}]
[null,null,null,null,0,"",null,null,"",null,{"$f":"IFERROR(($I141*J141),\"\")","v":""},null,{"$f":"IFERROR(($I141*L141),\"\")","v":""},null,"",null,"",null,"",1,{"$f":"IFERROR(($I141*T141),\"\")","v":""},null,{"$f":"IFERROR(($I141*V141),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,{"$f":"IFERROR(($I142*J142),\"\")","v":""},null,{"$f":"IFERROR(($I142*L142),\"\")","v":""},null,"",null,"",null,"",1,{"$f":"IFERROR(($I142*T142),\"\")","v":""},null,{"$f":"IFERROR(($I142*V142),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I143*T143),\"\")","v":""},null,{"$f":"IFERROR(($I143*V143),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I144*T144),\"\")","v":""},null,{"$f":"IFERROR(($I144*V144),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I145*T145),\"\")","v":""},null,{"$f":"IFERROR(($I145*V145),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I146*T146),\"\")","v":""},null,{"$f":"IFERROR(($I146*V146),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I147*T147),\"\")","v":""},null,{"$f":"IFERROR(($I147*V147),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I148*T148),\"\")","v":""},null,{"$f":"IFERROR(($I148*V148),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I149*T149),\"\")","v":""},null,{"$f":"IFERROR(($I149*V149),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I150*T150),\"\")","v":""},null,{"$f":"IFERROR(($I150*V150),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I151*T151),\"\")","v":""},null,{"$f":"IFERROR(($I151*V151),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I152*T152),\"\")","v":""},null,{"$f":"IFERROR(($I152*V152),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I153*T153),\"\")","v":""},null,{"$f":"IFERROR(($I153*V153),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I154*T154),\"\")","v":""},null,{"$f":"IFERROR(($I154*V154),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I155*T155),\"\")","v":""},null,{"$f":"IFERROR(($I155*V155),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I156*T156),\"\")","v":""},null,{"$f":"IFERROR(($I156*V156),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I157*T157),\"\")","v":""},null,{"$f":"IFERROR(($I157*V157),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I158*T158),\"\")","v":""},null,{"$f":"IFERROR(($I158*V158),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I159*T159),\"\")","v":""},null,{"$f":"IFERROR(($I159*V159),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I160*T160),\"\")","v":""},null,{"$f":"IFERROR(($I160*V160),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I161*T161),\"\")","v":""},null,{"$f":"IFERROR(($I161*V161),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I162*T162),\"\")","v":""},null,{"$f":"IFERROR(($I162*V162),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I163*T163),\"\")","v":""},null,{"$f":"IFERROR(($I163*V163),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I164*T164),\"\")","v":""},null,{"$f":"IFERROR(($I164*V164),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I165*T165),\"\")","v":""},null,{"$f":"IFERROR(($I165*V165),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I166*T166),\"\")","v":""},null,{"$f":"IFERROR(($I166*V166),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I167*T167),\"\")","v":""},null,{"$f":"IFERROR(($I167*V167),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I168*T168),\"\")","v":""},null,{"$f":"IFERROR(($I168*V168),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I169*T169),\"\")","v":""},null,{"$f":"IFERROR(($I169*V169),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I170*T170),\"\")","v":""},null,{"$f":"IFERROR(($I170*V170),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I171*T171),\"\")","v":""},null,{"$f":"IFERROR(($I171*V171),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I172*T172),\"\")","v":""},null,{"$f":"IFERROR(($I172*V172),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I173*T173),\"\")","v":""},null,{"$f":"IFERROR(($I173*V173),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I174*T174),\"\")","v":""},null,{"$f":"IFERROR(($I174*V174),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I175*T175),\"\")","v":""},null,{"$f":"IFERROR(($I175*V175),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I176*T176),\"\")","v":""},null,{"$f":"IFERROR(($I176*V176),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I177*T177),\"\")","v":""},null,{"$f":"IFERROR(($I177*V177),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I178*T178),\"\")","v":""},null,{"$f":"IFERROR(($I178*V178),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I179*T179),\"\")","v":""},null,{"$f":"IFERROR(($I179*V179),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I180*T180),\"\")","v":""},null,{"$f":"IFERROR(($I180*V180),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I181*T181),\"\")","v":""},null,{"$f":"IFERROR(($I181*V181),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I182*T182),\"\")","v":""},null,{"$f":"IFERROR(($I182*V182),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I183*T183),\"\")","v":""},null,{"$f":"IFERROR(($I183*V183),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I184*T184),\"\")","v":""},null,{"$f":"IFERROR(($I184*V184),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I185*T185),\"\")","v":""},null,{"$f":"IFERROR(($I185*V185),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I186*T186),\"\")","v":""},null,{"$f":"IFERROR(($I186*V186),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I187*T187),\"\")","v":""},null,{"$f":"IFERROR(($I187*V187),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I188*T188),\"\")","v":""},null,{"$f":"IFERROR(($I188*V188),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I189*T189),\"\")","v":""},null,{"$f":"IFERROR(($I189*V189),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I190*T190),\"\")","v":""},null,{"$f":"IFERROR(($I190*V190),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I191*T191),\"\")","v":""},null,{"$f":"IFERROR(($I191*V191),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I192*T192),\"\")","v":""},null,{"$f":"IFERROR(($I192*V192),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I193*T193),\"\")","v":""},null,{"$f":"IFERROR(($I193*V193),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I194*T194),\"\")","v":""},null,{"$f":"IFERROR(($I194*V194),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I195*T195),\"\")","v":""},null,{"$f":"IFERROR(($I195*V195),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I196*T196),\"\")","v":""},null,{"$f":"IFERROR(($I196*V196),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I197*T197),\"\")","v":""},null,{"$f":"IFERROR(($I197*V197),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I198*T198),\"\")","v":""},null,{"$f":"IFERROR(($I198*V198),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I199*T199),\"\")","v":""},null,{"$f":"IFERROR(($I199*V199),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I200*T200),\"\")","v":""},null,{"$f":"IFERROR(($I200*V200),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I201*T201),\"\")","v":""},null,{"$f":"IFERROR(($I201*V201),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I202*T202),\"\")","v":""},null,{"$f":"IFERROR(($I202*V202),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I203*T203),\"\")","v":""},null,{"$f":"IFERROR(($I203*V203),\"\")","v":""},1,0]
[null,null,null,null,{"$f":"D204","v":0},{"$f":"IF(D204>0,D204+H204-1,\"\")","v":""},null,null,{"$f":"IFERROR(IF($G$1>F204,0,G204/H204),\"\")","v":""},null,"",null,"",null,{"$f":"IFERROR(($I204*N204),\"\")","v":""},null,{"$f":"IFERROR(($I204*P204),\"\")","v":""},null,{"$f":"IFERROR(($I204*R204),\"\")","v":""},{"$f":"1-V204-J204-L204-N204-P204-R204","v":1},{"$f":"IFERROR(($I204*T204),\"\")","v":""},null,{"$f":"IFERROR(($I204*V204),\"\")","v":""},{"$f":"SUM(J204,L204,N204,P204,R204,V204,T204)","v":1},{"$f":"SUM(K204,M204,O204,Q204,S204,W204,U204)","v":0}]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I205*T205),\"\")","v":""},null,{"$f":"IFERROR(($I205*V205),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,{"$f":"IFERROR(($I206*J206),\"\")","v":""},null,{"$f":"IFERROR(($I206*L206),\"\")","v":""},null,"",null,"",null,"",1,{"$f":"IFERROR(($I206*T206),\"\")","v":""},null,{"$f":"IFERROR(($I206*V206),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I207*T207),\"\")","v":""},null,{"$f":"IFERROR(($I207*V207),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I208*T208),\"\")","v":""},null,{"$f":"IFERROR(($I208*V208),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I209*T209),\"\")","v":""},null,{"$f":"IFERROR(($I209*V209),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I210*T210),\"\")","v":""},null,{"$f":"IFERROR(($I210*V210),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I211*T211),\"\")","v":""},null,{"$f":"IFERROR(($I211*V211),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I212*T212),\"\")","v":""},null,{"$f":"IFERROR(($I212*V212),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I213*T213),\"\")","v":""},null,{"$f":"IFERROR(($I213*V213),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I214*T214),\"\")","v":""},null,{"$f":"IFERROR(($I214*V214),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I215*T215),\"\")","v":""},null,{"$f":"IFERROR(($I215*V215),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I216*T216),\"\")","v":""},null,{"$f":"IFERROR(($I216*V216),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I217*T217),\"\")","v":""},null,{"$f":"IFERROR(($I217*V217),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I218*T218),\"\")","v":""},null,{"$f":"IFERROR(($I218*V218),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I219*T219),\"\")","v":""},null,{"$f":"IFERROR(($I219*V219),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I220*T220),\"\")","v":""},null,{"$f":"IFERROR(($I220*V220),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I221*T221),\"\")","v":""},null,{"$f":"IFERROR(($I221*V221),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I222*T222),\"\")","v":""},null,{"$f":"IFERROR(($I222*V222),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I223*T223),\"\")","v":""},null,{"$f":"IFERROR(($I223*V223),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I224*T224),\"\")","v":""},null,{"$f":"IFERROR(($I224*V224),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I225*T225),\"\")","v":""},null,{"$f":"IFERROR(($I225*V225),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I226*T226),\"\")","v":""},null,{"$f":"IFERROR(($I226*V226),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I227*T227),\"\")","v":""},null,{"$f":"IFERROR(($I227*V227),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I228*T228),\"\")","v":""},null,{"$f":"IFERROR(($I228*V228),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I229*T229),\"\")","v":""},null,{"$f":"IFERROR(($I229*V229),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I230*T230),\"\")","v":""},null,{"$f":"IFERROR(($I230*V230),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I231*T231),\"\")","v":""},null,{"$f":"IFERROR(($I231*V231),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I232*T232),\"\")","v":""},null,{"$f":"IFERROR(($I232*V232),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I233*T233),\"\")","v":""},null,{"$f":"IFERROR(($I233*V233),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I234*T234),\"\")","v":""},null,{"$f":"IFERROR(($I234*V234),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I235*T235),\"\")","v":""},null,{"$f":"IFERROR(($I235*V235),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I236*T236),\"\")","v":""},null,{"$f":"IFERROR(($I236*V236),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I237*T237),\"\")","v":""},null,{"$f":"IFERROR(($I237*V237),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I238*T238),\"\")","v":""},null,{"$f":"IFERROR(($I238*V238),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I239*T239),\"\")","v":""},null,{"$f":"IFERROR(($I239*V239),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I240*T240),\"\")","v":""},null,{"$f":"IFERROR(($I240*V240),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I241*T241),\"\")","v":""},null,{"$f":"IFERROR(($I241*V241),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I242*T242),\"\")","v":""},null,{"$f":"IFERROR(($I242*V242),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I243*T243),\"\")","v":""},null,{"$f":"IFERROR(($I243*V243),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I244*T244),\"\")","v":""},null,{"$f":"IFERROR(($I244*V244),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I245*T245),\"\")","v":""},null,{"$f":"IFERROR(($I245*V245),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I246*T246),\"\")","v":""},null,{"$f":"IFERROR(($I246*V246),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I247*T247),\"\")","v":""},null,{"$f":"IFERROR(($I247*V247),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I248*T248),\"\")","v":""},null,{"$f":"IFERROR(($I248*V248),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I249*T249),\"\")","v":""},null,{"$f":"IFERROR(($I249*V249),\"\")","v":""},1,0]
[null,null,null,null,0,"",null,null,"",null,"",null,"",null,"",null,"",null,"",1,{"$f":"IFERROR(($I250*T250),\"\")","v":""},null,{"$f":"IFERROR(($I250*V250),\"\")","v":""},1,0]
[]
["TOTAL ALLOWABLE DEPRECIATION",null,null,null,null,null,{"$f":"SUM(G139:G250)","v":0},null,{"$f":"SUM(I139:I250)","v":0},{"$f":"K252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K139:K251)","v":0},{"$f":"M252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M139:M251)","v":0},{"$f":"O252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O139:O251)","v":0},{"$f":"Q252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q139:Q251)","v":0},{"$f":"S252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(S139:S251)","v":0},{"$f":"U252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(U139:U251)","v":0},{"$f":"W252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(W139:W251)","v":0},{"$f":"Y252/$Y$252","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Y139:Y250)","v":0}]
[]
[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(S252,Q252,O252,M252,K252)","v":0}]
[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":"U252+W252","v":0}]
[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(Y254:Y255)","v":0}]

{"sheet":"Rate Summary","index":7,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,1,5,5]]}
[{"$f":"IFERROR('Rate Application'!E7:L7,\"\")","v":""}]
[{"$f":"Information!F4","v":0}]
["Service Center Rate Summary Sheet"]
[{"$f":"'Rate Application'!L1","v":"FY2024"}]
[]
[null,null,null,null,null,null,"TOTAL"]
[null,{"$f":"Information!B8","v":"Service 1"},{"$f":"Information!B9","v":"Service 2"},{"$f":"Information!B10","v":"Service 3"},{"$f":"Information!B11","v":"Service 4"},{"$f":"Information!B12","v":"Service 5"},"All Services"]
["Current year rates",{"$f":"IF((ISBLANK(Information!G$8)=TRUE),\"N/A\",+Information!G$8)","v":"N/A"},{"$f":"IF((ISBLANK(Information!$G9)=TRUE),\"N/A\",+Information!$G9)","v":"N/A"},{"$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)",{"$f":"IFERROR((Information!$F$5*'Rate Summary'!B33),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!C33),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!D33),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!E33),0)","v":0},{"$f":"IFERROR((Information!$F$5*'Rate Summary'!F33),0)","v":0},{"$f":"SUM(B9:F9)","v":0}]
[]
["ANNUAL COSTS"]
["Salaries and Fringe Benefits",{"$f":"'Salary Operating and Deprec Exp'!J44","v":0},{"$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(B12:F12)","v":0}]
["Operating Costs",{"$f":"'Salary Operating and Deprec Exp'!D125","v":0},{"$f":"'Salary Operating and Deprec Exp'!F125","v":0},{"$f":"'Salary Operating and Deprec Exp'!H125","v":0},{"$f":"'Salary Operating and Deprec Exp'!J125","v":0},{"$f":"'Salary Operating and Deprec Exp'!L125","v":0},{"$f":"SUM(B13:F13)","v":0}]
["Capital equipment depreciation",{"$f":"IFERROR('Salary Operating and Deprec Exp'!K252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!M252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!O252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!Q252,0)","v":0},{"$f":"IFERROR('Salary Operating and Deprec Exp'!S252,0)","v":0},{"$f":"SUM(B14:F14)","v":0}]
[null,null,null,null,null,null,null,"Annual costs totals check"]
["SUBTOTAL ANNUAL SERVICE COSTS",{"$f":"SUM(B12:B15)","v":0},{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0},{"$f":"SUM(F12:F15)","v":0},{"$f":"SUM(B16:F16)","v":0},{"$f":"ROUND((-$G$16+'Salary Operating and Deprec Exp'!Y254+'Salary Operating and Deprec Exp'!P127+'Salary Operating and Deprec Exp'!X46),0)","v":0}]
[]
["Estimated 2 months working capital",{"$f":"B16*0.166","v":0},{"$f":"C16*0.166","v":0},0,0,0,{"$f":"SUM(B18:F18)","v":0}]
[]
["TOTAL ANNUAL SERVICE COSTS (includes working capital)",{"$f":"B16+B18","v":0},{"$f":"C16+C18","v":0},0,0,0,{"$f":"SUM(B20:F20)","v":0}]
[null,null,null,null,null,null,null,"PY balance totals check"]
["Prior Year Balance (Add Deficit, Subtract Surplus)",{"$f":"-1*B9","v":0},{"$f":"-1*C9","v":0},{"$f":"-1*D9","v":0},{"$f":"-1*E9","v":0},{"$f":"-1*F9","v":0},{"$f":"SUM(B22:F22)","v":0},{"$f":"$G$22+Information!$F$5","v":0}]
[]
["TOTAL REVISED COSTS (includes PY balance)",{"$f":"B22+B20","v":0},{"$f":"C22+C20","v":0},0,0,0,{"$f":"SUM(B24:F24)","v":0}]
[]
["# of Annual Units",{"$f":"Information!I8","v":0},{"$f":"Information!I9","v":0},{"$f":"Information!I10","v":0},{"$f":"Information!I11","v":0},{"$f":"Information!I12","v":0}]
["Unit Base",{"$f":"Information!H8","v":0},{"$f":"Information!H9","v":0},{"$f":"Information!H10","v":0},{"$f":"Information!H11","v":0},{"$f":"Information!H12","v":0}]
[]
["CALCULATED SUBSIDIZED RATE (per unit)",{"$f":"IF(B26<>0,B24/B26,0)","v":0},{"$f":"IF(C26<>0,C24/C26,0)","v":0},0,0,0]
[]
["UNIT RATE TO BE CHARGED TO UI DEPARTMENTS*"]
[]
["% of Total Costs",{"$f":"IF(B16=0,0,B16/$G$16)","v":0},{"$f":"IF(C16=0,0,C16/$G$16)","v":0},{"$f":"IF(D16=0,0,D16/$G$16)","v":0},{"$f":"IF(E16=0,0,E16/$G$16)","v":0},{"$f":"IF(F16=0,0,F16/$G$16)","v":0},{"$f":"SUM(B33:F33)","v":0}]
[null,null,null,null,null,null,null,"Subsidy totals check"]
["Subsidies (& unallowable depreciation)",{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$P$128,'Salary Operating and Deprec Exp'!$Y$255)*'Rate Summary'!B33","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$P$128,'Salary Operating and Deprec Exp'!$Y$255)*'Rate Summary'!C33","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$P$128,'Salary Operating and Deprec Exp'!$Y$255)*'Rate Summary'!D33","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$P$128,'Salary Operating and Deprec Exp'!$Y$255)*'Rate Summary'!E33","v":0},{"$f":"SUM('Salary Operating and Deprec Exp'!$X$47,'Salary Operating and Deprec Exp'!$P$128,'Salary Operating and Deprec Exp'!$Y$255)*'Rate Summary'!F33","v":0},{"$f":"SUM(B35:F35)","v":0},{"$f":"$G$35-'Salary Operating and Deprec Exp'!X47-'Salary Operating and Deprec Exp'!P128-'Salary Operating and Deprec Exp'!Y255","v":0}]
[null,null,null,null,null,null,null,"Total Costs check"]
["TOTAL SERVICE COSTS (includes subsidy & unallowable depreciation)",{"$f":"B24+B35","v":0},{"$f":"C24+C35","v":0},0,0,0,{"$f":"SUM(B37:F37)","v":0},{"$f":"ROUND((G37-'Salary Operating and Deprec Exp'!Y256-'Salary Operating and Deprec Exp'!P129-'Salary Operating and Deprec Exp'!X48-G18-G22),0)","v":0}]
[]
["UNSUBSIDIZED (FULL COST) RATES: EXTERNAL CUSTOMERS",{"$f":"IFERROR(B37/B26,0)","v":0},{"$f":"IFERROR(C37/C26,0)","v":0},{"$f":"IFERROR(D37/D26,0)","v":0},{"$f":"IFERROR(E37/E26,0)","v":0},{"$f":"IFERROR(F37/F26,0)","v":0}]

{"sheet":"Rate Sheet","index":8,"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":"FY2024"}]
[{"$f":"'Rate Application'!E6","v":0}]
[{"$f":"+Information!F4","v":0}]
[]
["Service ","Description","Unit"," Internal Rate","External Rate"]
[{"$f":"Information!B8","v":"Service 1"},{"$f":"Information!D8","v":0},{"$f":"Information!H8","v":0},{"$f":"Information!J8","v":0},{"$f":"IFERROR('Rate Summary'!B39,\"N/A\")","v":0}]
[{"$f":"Information!B9","v":"Service 2"},{"$f":"Information!D9","v":0},{"$f":"Information!H9","v":0},{"$f":"Information!J9","v":0},{"$f":"IFERROR('Rate Summary'!C39,\"N/A\")","v":0}]
[{"$f":"Information!B10","v":"Service 3"},{"$f":"Information!D10","v":0},{"$f":"Information!H10","v":0},{"$f":"Information!J10","v":0},{"$f":"IFERROR('Rate Summary'!D39,\"N/A\")","v":0}]
[{"$f":"Information!B11","v":"Service 4"},{"$f":"Information!D11","v":0},{"$f":"Information!H11","v":0},{"$f":"Information!J11","v":0},{"$f":"IFERROR('Rate Summary'!E39,\"N/A\")","v":0}]
[{"$f":"Information!B12","v":"Service 5"},{"$f":"Information!D12","v":0},{"$f":"Information!H12","v":0},{"$f":"Information!J12","v":0},{"$f":"IFERROR('Rate Summary'!F39,\"N/A\")","v":0}]
[]
[]
[]
[]
["Approver's Signatures",null,null,"Date"]
[]
[]
[]
["Heather Clark, Assistant Director Sponsored Accounting"]
[]
[]
[]
["Amanda Bauer, University Controller"]

{"sheet":"Index Summary","index":9,"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,1]]}
[{"$f":"'Rate Application'!E7&\" Index Summary\"","v":" Index Summary"}]
[{"$f":"IFERROR(Information!E3,\"\")","v":"Please fill in Cell E6 on Rate Application Page"}]
[{"$f":"'Rate Application'!L1","v":"FY2024"}]
[]
[]
[{"$f":"Information!B18&\" \"&Information!D18","v":" "},null,null,null,null,{"$f":"Information!B27&\" \"&Information!C27","v":"  "}]
["Projected Operating Index",null,null,null,null,"Projected Capital Equip Replacement Index"]
[]
["Revenue",null,null,null,null,"Depreciation"]
[null,{"$f":"+Information!B8","v":"Service 1"},{"$f":"IFERROR(('Rate Summary'!B31*'Rate Summary'!B26),0)","v":0},null,null,null,"Transfer from operating index **",{"$f":"C20+C25","v":0}]
[null,{"$f":"+Information!B9","v":"Service 2"},{"$f":"IFERROR(('Rate Summary'!C31*'Rate Summary'!C26),0)","v":0},null,null,null,"Prior year carryover",{"$f":"Information!J27","v":0}]
[null,{"$f":"+Information!B10","v":"Service 3"},{"$f":"IFERROR(('Rate Summary'!D$31*'Rate Summary'!D$26),0)","v":0}]
[null,{"$f":"+Information!B11","v":"Service 4"},{"$f":"IFERROR(('Rate Summary'!E$31*'Rate Summary'!E$26),0)","v":0},null,null,"Total Accumulated Depreciation",null,{"$f":"SUM(H10:H12)","v":0}]
[null,{"$f":"+Information!B12","v":"Service 5"},{"$f":"IFERROR(('Rate Summary'!F$31*'Rate Summary'!F$26),0)","v":0}]
["Total Revenue",null,{"$f":"SUM(C10:C14)","v":0},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":0}]
[null,"Operating Expenses",{"$f":"'Salary Operating and Deprec Exp'!P127","v":0}]
[null,"Capital Equipment depreciation transfer",{"$f":"IFERROR('Salary Operating and Deprec Exp'!Y254,0)","v":0}]
[]
["Total Expenditures",null,{"$f":"SUM(C18:C21)","v":0}]
[null,null,null,null,null,"Total Expenditures",null,{"$f":"SUM(H16:H22)","v":0}]
["Net",null,{"$f":"C15-C22","v":0}]
[null,"One time carryforward transfer (if applicable)*",null,null,null,"Net",null,{"$f":"H13-H23","v":0}]
["Grand total",null,{"$f":"C24-C25","v":0}]

{"sheet":"Reviewer Notes","index":10,"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":0},{"$f":"Information!C18","v":0}]
[]
[null,"Fund Balance",{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY23"},{"$f":"\"FY\"&ABS(RIGHT(C9,2)-1)","v":"FY22"},{"$f":"\"FY\"&ABS(RIGHT(D9,2)-1)","v":"FY21"}]
[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":0},{"$f":"Information!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Fund Balance",{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY23"},{"$f":"\"FY\"&ABS(RIGHT(C20,2)-1)","v":"FY22"},{"$f":"\"FY\"&ABS(RIGHT(D20,2)-1)","v":"FY21"}]
[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"]