{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Proposal Details","2. Plan Macro Instructions","3. Plan","4. Reconciliation","5. Rate Calculation","6. Volume Projections","7. Rate List","8. Depreciation Schedule","9. Complete Content Checklist","2020-21 Forecast"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":21,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Proposal Details","index":0,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,4,4,10],[4,13,4,18],[19,21,22,22],[9,9,9,10],[10,9,10,10],[30,28,30,29],[17,27,22,29],[14,26,14,30],[9,15,9,17],[9,19,9,20],[17,18,18,20],[19,18,20,20],[21,18,22,20],[17,14,18,17],[21,14,22,17],[40,21,40,24],[43,21,43,24],[42,21,42,24],[38,3,38,15],[38,21,38,28],[40,11,40,15],[41,11,41,15],[43,13,43,15],[42,13,42,15],[40,27,40,28],[41,27,41,28],[41,3,41,8],[46,15,46,16],[10,4,10,5],[10,19,10,20],[14,12,14,20],[15,18,16,20],[40,3,40,8],[42,3,42,8],[43,3,43,8],[17,3,22,3],[10,15,10,17],[19,7,20,9],[0,1,0,31],[9,12,9,13],[10,12,10,13],[35,1,35,31],[26,2,26,29],[17,4,18,6],[19,4,20,6],[21,4,22,6],[17,1,22,1],[29,28,29,29],[27,1,27,31],[1,1,1,23],[7,4,7,10],[7,13,7,18],[9,4,9,5],[19,14,20,17],[46,24,46,26],[11,28,11,30],[19,12,20,13],[21,12,22,13],[21,7,22,9],[15,12,16,13],[13,1,13,31],[15,14,16,17],[17,21,18,22],[14,4,14,9],[15,7,16,9],[15,4,16,6],[17,12,18,13],[17,7,18,9],[14,21,16,22],[41,21,41,24]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"     1. GENERAL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     2. LOCATION OF RECHARGE ACTIVITY "]
[]
[null,"          Recharge ",null,null,null,null,null,null,null,null,null,null,"Recharge",null,null,null,null,null,null,"    Date",null,null,null,null,null,"          Choose the location of the recharge "]
[null,"          Activity Name:",null,null,null,null,null,null,null,null,null,null,"Manager:",null,null,null,null,null,null,"    Submitted:",null,null,null,null,null,null," activity from the list below:"]
[]
[null,"          Dept ",null,null,null,null,null,null,null,null,null,null,"Contact",null,null,null,null,null,null,"    Target",null,null,null,null,null,null,"   Parnassus"]
[null,"          Name: ",null,null,null,null,null,null,null,null,null,null,"Person:",null,null,null,null,null,null,"    Effective Date:",null,null,null,null,null,null,"   Laurel Heights"]
[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,"   Mt. Zion"]
[null,"          Chartstring:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Mission Bay"]
[null,null,null,null,"Dept ID",null,null,"Fund",null,"Function",null,null,"Parent Project",null,null,"Sub-Project",null,null,null,"Sub-Project",null,null,"Sub-Project",null,null,null,"   ZSFG"]
[null,"          If you have additional projects, please list them in an attached addendum.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Other (describe):"]
[]
[null,"     3. RISK LEVEL - 9-SQUARE ASSESSMENT"]
[null,null,null,null,"    Dollar Value                                          (Total Annual Expenses)",null,null,null,null,null,null,null,"Federal Participation (%)",null,null,null,null,null,null,null,null,"Recharge Risk Category",null,null,null,null,"Anticipated Federal Participation"]
[null,null,null,null,"Planned Expense \nRange",null,null,"Planned Expenses\nfrom Plan (page 3)",null,null,null,null,0,null,"> 0% to < 50%",null,null,null,"50% or higher"]
[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,"Annual Expenses ($)","< or = $100,000",null,null,{"$f":"IF(AND('3. Plan'!$J$45<100000.5,'3. Plan'!$J$45>0),'3. Plan'!$J$45,\"\")","v":""},null,null,null,null,"Low  ",null,"Low-Medium",null,null,null,"Medium",null,null,"CATEGORY 1",null,null,null,null,null,"Once the planned expense amount (far left column of this section) and anticipated percentage of federal participation (section above) are entered, both the appropriate risk level and category will be highlighted."]
[]
[null,null,null,null,"> $100,000 and                     < $500,000",null,null,{"$f":"IF(AND('3. Plan'!$J$45<500000,'3. Plan'!$J$45>100000.49),'3. Plan'!$J$45,\"\")","v":""},null,null,null,null,"Low-Medium",null,"Medium",null,null,null,"Medium-High",null,null,"CATEGORY 2"]
[]
[null,null,null,null,"> or = $500,000 ",null,null,{"$f":"IF(AND('3. Plan'!$J$45>499999.99),'3. Plan'!$J$45,\"\")","v":""},null,null,null,null,"Medium-High",null,"Medium-High",null,null,null,"High"]
[]
[]
[null,"     4. DESCRIPTION OF RECHARGE ACTIVITY (attach addendum, if necessary)"]
[]
[]
[null,"      5. USER COMMITTEE (required only if total expenses are at least $500,000 per year) - A USER COMMITTEE MUST BE FORMED TO ENDORSE APPROVAL OF RATES"]
[]
[null,"           List members and Chair of User Committee:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"        Enter date User Committee reviewed/endorsed "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"        approval of rates: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"        Attach documentation of User Committee review and endorsement of approval."]
[]
[]
[null,"      6. APPROVALS "]
[null,"           To the best of my knowledge, this recharge proposal complies with UCSF Recharge Policy and applicable Federal Costing Policies."]
[]
[null,null,null,"Department Administrative Officer/MSO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Point for Dean/Vice Chancellor"]
[]
[]
[null,null,null,"Signature",null,null,null,null,null,null,null,"Print",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,"Print"]
[]
[null,null,null,"Title",null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Date"]
[]
[null,"           Approval via email should include the following certification statement of approval:"]
[null,"           \" I certify that I reviewed and approve the attached proposal for ",null,null,null,null,null,null,null,null,null,null,null,"Dept ID ",null,{"$f":"IF($E$10=\"\",\"\",$E$10)","v":""},null,"-    Fund",null,null,{"$f":"IF($H$10=\"\",\"\",$H$10)","v":""}," -      Parent Project",null,null,{"$f":"IF($M$10=\"\",\"\",$M$10)","v":""},{"$f":"IF($H$10=\"\",\"\",$H$10)","v":""},""]
[null,"              and to the best of my knowledge, this recharge proposal complies with UCSF Recharge Policy and applicable Federal Costing Policies.\""]
[null,"           *Control Point signature or certification of approval via email required only for Category 2 proposals."]

{"sheet":"2. Plan Macro Instructions","index":1,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[3,2,3,4],[0,0,0,5]]}
["2021-22 RENEWAL RECHARGE PROPOSAL "]
["Macro instructions to quickly populate the 3. Plan tab with the budget, actual, and forecast columns"]
["Be sure that your workbook is macro-enabled when prompted upon opening this .xlsm file"]
[]
["2019-20 BUDGET AND ACTUALS MACRO"]
[null,"MyReports"]
[null,null,"1. Select Monthly Report in the Operational Reports tab"]
[null,null,"2. Choose Fiscal Year 2019-20 from the dropdown box"]
[null,null,"3. In the Chartstring Filters section, add Fund 5018"]
[null,null,"4. To capture all projects and sub-project, enter the Parent Project in the Project Award/Parent filter"]
[null,null,"If there is a Surplus Revenue Project, exclude it by entering all other Projects into the Project filter instead"]
[null,null,"5. In Report Specific Filters sections, select to Display Codes and Descriptions in the Display Codes and Descriptions dropdown"]
[null,null,"6. Select Excel in the Report Output Selection section"]
[null,null,"7. Click Run Report (keep this window open for later - Step 13)"]
[]
[null,"Excel"]
[null,null,"8. Open the resulting Excel file and click Enable Editing at the top"]
[null,null,"9. Right click on the Monthly Report tab to move a copy of the tab to the 2021-22 RENEWAL Proposal"]
[]
[null,null,"a. Select Move or Copy","b. Choose 2021-22 RENEWAL Proposal.xlsm ","c. Scroll down and select (move to end)"]
[null,null,null,"from the dropdown box of open Excel files","d. Click the Create a copy checkbox and click OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"10. Confirm the Monthly Report tab appears at the end of the 2021-22 RENEWAL Proposal"]
[null,null,"11. Click on this button to run the 2019-20 macro:"]
[]
[null,null,"12. Confirm the 2019-20 Budget and 6/30/20 Actuals columns are populated on the 3. Plan tab"]
[]
["2020-21 FORECAST MACRO"]
[null,"MyReports"]
[null,null,"13. Return to the open MyReports Monthly Report screen. "]
[null,null,"14. Choose Fiscal Year 2020-21 from the dropdown box and keep all of the same filters and settings"]
[null,null,"15. Click Run Report"]
[null,null,"16. Complete Excel Steps 8-10 of the instructions above to move the 2020-21 Monthly Report tab into the proposal file"]
[null,null,"17. Click on this button in order to run the 2020-21 macro:"]
[]
[null,null,"17. The 2020-21 forecast column should now be populated on the 3. Plan tab"]
[null,null,"18. Review the forecast and make any adjustments on the 2020-21 Forecast tab to most accurately project year-end totals"]
[]
["2021-22 PLAN"]
[null,null,"19. Link the Rate Calculation Tab revenue and expense category totals to the 2021-22 Plan column on the 3. Plan tab"]

{"sheet":"3. Plan","index":2,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":false,"merged":[[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[54,0,54,5],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[35,0,35,4],[36,0,36,4],[27,0,27,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[57,0,57,5],[37,0,37,4],[43,0,43,5],[44,0,44,5],[56,0,56,5],[46,0,46,5],[10,0,10,4],[2,5,2,7],[20,0,20,5],[22,0,22,9],[0,0,0,9],[1,0,1,9],[5,6,5,7],[8,0,8,9],[9,0,9,4]]}
["2021-22 RENEWAL RECHARGE PROPOSAL"]
["PLAN"]
[null,null,null,null,"Recharge Activity Name:",{"$f":"IF('1. Proposal Details'!$E$5=\"\",\"\",'1. Proposal Details'!$E$5)","v":""}]
[null,null,null,null,"Recharge Dept ID-Fund-Project:",{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""}]
[]
[null," ",null,null,null,null,"2019-20",null,"2020-21","2021-22"]
[null,null,null,null,null,"Level C","Budget","2020-06-30","Forecast","Plan"]
[null,null,null,null,null,"Accounts",null,"Actuals"]
["REVENUE:"]
["Sales and Service Revenue (External)",null,null,null,null,"4200C"]
["Recharge and Costed Central Act (Internal UCSF)",null,null,null,null,"4250C"]
["MC-Purchased Svcs Revenue",null,null,null,null,"4151C"]
["MC-Strategic Support",null,null,null,null,"4152C"]
["Other Clinical Revenue",null,null,null,null,"4153C"]
["Affiliation/Contract Revenue",null,null,null,null,"4154C"]
["Gift Revenue",null,null,null,null,"4351C"]
["Sponsored Project Rev Exc SFGH",null,null,null,null,"4500C"]
["Interest and Investment Income",null,null,null,null,"4550C"]
["Assessments ",null,null,null,null,"4600C"]
["Other Revenues",null,null,null,null,"4601C"]
["Misc Other Revenues (expand rows 12-20 if needed)",null,null,null,null,null,{"$f":"SUM(G12:G20)","v":0},{"$f":"SUM(H12:H20)","v":0},0,{"$f":"SUM(J12:J20)","v":0}]
["TOTAL REVENUE (lines 10 through 21)",null,null,null,null,null,{"$f":"SUM(G10+G11+G21)","v":0},{"$f":"SUM(H10+H11+H21)","v":0},0,{"$f":"SUM(J10+J11+J21)","v":0}]
["EXPENSE:"]
["Faculty Salaries",null,null,null,null,"5000C"]
["Faculty Benefits",null,null,null,null,"5030C"]
["Non-Faculty Academic Salaries",null,null,null,null,"5020C"]
["Non-Faculty Academic Benefits",null,null,null,null,"5040C"]
["Staff Salaries and Overtime",null,null,null,null,"5050C"]
["Staff Benefits",null,null,null,null,"5060C"]
["Sponsored Proj - F&A Recovery",null,null,null,null,"5202C"]
["Depreciation",null,null,null,null,"5500C"]
["Occupancy Expense",null,null,null,null,"5300C"]
["Utilities",null,null,null,null,"5320C"]
["Assessments Expense",null,null,null,null,"5510C"]
["Supplies and Materials",null,null,null,null,"5515C"]
["Services",null,null,null,null,"5550C"]
["Travel, Mtgs & Entertainment",null,null,null,null,"5578C"]
["Other Expenses",null,null,null,null,"5580C"]
["Faculty Bonuses & Incentives",null,null,null,null,"5010C"]
["Sponsored Projects - Subawards",null,null,null,null,"5200C"]
["Sponsored Proj - Capital Equip",null,null,null,null,"5201C"]
["FNDN Transfers to Campus",null,null,null,null,"5400C"]
["Scholarship/Fellowship",null,null,null,null,"5579C"]
["Misc Other Expenses (expand rows 39-43 if needed)",null,null,null,null,null,{"$f":"SUM(G39:G43)","v":0},{"$f":"SUM(H39:H43)","v":0},0,0]
["TOTAL EXPENSE (lines 24 through 44)",null,null,null,null,null,{"$f":"SUM(G24:G38)+G44","v":0},{"$f":"SUM(H24:H38)+H44","v":0},0,{"$f":"SUM(J24:J38)+J44","v":0}]
["OTHER CHANGES"]
["Working Capital Reserve"]
["Transfers - Deficit Support",null,null,null,null,"7801C",0,0,{"$error":"#VALUE!"}]
["Transfers - Dean's Support",null,null,null,null,"7802C",0,0,{"$f":"VLOOKUP(F49,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers - Chanc/VC Support",null,null,null,null,"7803C",0,0,{"$f":"VLOOKUP(F50,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers - Other Support",null,null,null,null,"7805C",0,0,{"$f":"VLOOKUP(F51,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers - Curr to/from Other Funds",null,null,null,null,"7806C",0,0,{"$f":"VLOOKUP(F52,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers - Curr/Plant Capital Outlay",null,null,null,null,"7808C",0,0,{"$f":"VLOOKUP(F53,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers -  STIP",null,null,null,null,"7809C",0,0,{"$f":"VLOOKUP(F54,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Transfers",null,null,null,null,null,{"$f":"SUM(G48:G54)","v":0},{"$f":"SUM(H48:H54)","v":0},{"$f":"SUM(I48:I54)","v":{"$error":"#VALUE!"}}]
["Capital Equip (Non-Spon Proj)",null,null,null,null,"5700C",0,0,{"$f":"VLOOKUP(F56,'2020-21 Forecast'!B:P,15,FALSE)","v":0}]
["Other Changes",null,null,null,null,null,{"$f":"SUM(G56)","v":0},{"$f":"SUM(H56)","v":0},0]
["Subsidies (attach details regarding method and Dept ID-Fund-Project)"]
["TOTAL OTHER CHANGES (line 47 through 58)",null,null,null,null,null,{"$f":"G47+G55+G57+G58","v":0},{"$f":"H55+H57","v":0},{"$f":"I55+I57","v":{"$error":"#VALUE!"}},{"$f":"J47+J58","v":0}]
["NET POSTION TO BE APPLIED TO 2021-22 (Enter in Column H Line 60)",null,null,null,null,null,null,null,null,{"$f":"I69","v":0}]
["ADJUSTED EXPENSE FOR RATE CALCULATION",null,null,null,null,null,null,null,null,{"$f":"J45+J59+J60","v":0}]
["NET POSITION (must balance to zero)",null,null,null,null,null,null,null,null,{"$f":"J22-J61","v":0}]
[]
["CHANGE IN NET POSITION ",null,null,null,null,null,{"$f":"G22-G45+G59","v":0},{"$f":"H22-H45+H59","v":0},{"$f":"I22-I45+I59","v":{"$error":"#VALUE!"}},{"$f":"J22-J45-J58","v":0}]
["NET POSITION - BEGINNING OF PERIOD (Column F = 6/30/20 net position) ",null,null,null,null,"NPBOP",null,null,{"$f":"H66","v":0},{"$f":"I66","v":{"$error":"#VALUE!"}}]
["NET POSITION - END OF PERIOD - Surplus / (Deficit)",null,null,null,null,null,{"$f":"G64+G65","v":0},{"$f":"H64+H65","v":0},{"$f":"I64+I65","v":{"$error":"#VALUE!"}},{"$f":"J64+J65","v":{"$error":"#VALUE!"}}]
["Surplus/(Deficit) as a % of total expense",null,null,null,null,null,null,{"$f":"IF(H66=0,0,H66/H45)","v":0},{"$f":"IF(I66=0,0,I66/I45)","v":{"$error":"#VALUE!"}},{"$f":"IF(J66=0,0,J66/J45)","v":{"$error":"#VALUE!"}}]
["TREATMENT OF NET POSITION:",null,null,null,null,null,null,"Net Position may be applied fully in the plan or amortized over 2 or 3 years"]
["Amount to be applied to 2021-22 (1st year amortization) in Cell H60",null,null,null,null,null,null,null,{"$f":"IF(I68>0,-I66/I68,0)","v":0}]
["Amount to be applied to 2022-23 (2nd year amortization)",null,null,null,null,null,null,null,{"$f":"IF(I68>1,-I66/I68)","v":false}]
["Amount to be applied to 2023-24 (3rd year amortization)",null,null,null,null,null,null,null,{"$f":"IF(I68>2,-I66/I68)","v":false}]
["PERSONNEL DETAIL 2021-22 Plan (insert additional lines as needed):"]
["Staff Name","Job Title","Title\nCode","Plan\nAccount","FTE % to\nRecharge\nActivity","Annual\nSalary","Salary on Recharge Activity","CBR %\nBenefits Rate","Benefits on\nRecharge\nActivity","Total Payroll on Recharge Activity"]
[null,null,null,null,null,null,{"$f":"E74*F74","v":0},null,{"$f":"G74*H74","v":0},{"$f":"G74+I74","v":0}]
[null,null,null,null,null,null,0,null,0,{"$f":"G75+I75","v":0}]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,0,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E74:E84)","v":0},null,{"$f":"SUM(G74:G84)","v":0},null,{"$f":"SUM(I74:I84)","v":0},{"$f":"SUM(J74:J84)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["5000C"]
["5020C"]
["5050C"]

{"sheet":"4. Reconciliation","index":3,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,25],[1,1,1,25]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"RECONCILIATION OF PRIOR YEAR NET POSITION"]
[null,null,"Recharge activities with more than one service line must calculate the prior year net position to apply to each service"]
[null,null,"by reconciling actual revenue and expense for each service from the last approval through 2020-21."]
[]
[null,null,"Fill in the corresponding grayed-out cells below to calculate the Net position to apply to 2021-22 plan for each service. "]
[null,null,"If you need to account for additional services, unhide the additional data input columns by clicking  on the        above the "]
[null,null,"total column (column Y)."]
[]
[null,null,"Fiscal Years Reconciled:",null,null,"through","2020-21"]
[]
[null,null,null,null,"Service 1","Service 2 ","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10","Service 11","Service 12","Service 13","Service 14","Service 15","Service 16","Service 17","Service 18","Service 19","Service 20","Total"]
[null,null,"Last Approved Rates"]
[null,null,"Volume"]
[null,null,"Revenue",null,{"$f":"E13*E14","v":0},{"$f":"F13*F14","v":0},0,0,0,0,{"$f":"K13*K14","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"V13*V14","v":0},0,0,{"$f":"SUM(E15:X15)","v":0}]
[]
[null,null,"Expenses"]
[null,null,"Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:X18)","v":0}]
[null,null,"Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:X21)","v":0}]
[null,null,"Other Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Expense",null,{"$f":"SUM(E18:E22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E23:X23)","v":0}]
[]
[null,null,"Other Changes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:X25)","v":0}]
[]
[null,null,"Change in Net Position",null,{"$f":"E15-E23-E25","v":0},{"$f":"F15-F23+F25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E27:X27)","v":0}]
[]
[null,null,"Net Position Beginning of Period",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:X29)","v":0}]
[null,null,"Net Position End of Period",null,{"$f":"E27+E29","v":0},{"$f":"F27+F29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E30:X30)","v":0}]
[]
[null,null,"% Over/(Under) Recovery",null,{"$f":"IFERROR((E30/$Y30),0)","v":0},{"$f":"IFERROR((F27/$Y27),0)","v":0},0,{"$f":"IFERROR((H27/$Y27),0)","v":0},{"$f":"IFERROR((I27/$Y27),0)","v":0},{"$f":"IFERROR((J27/$Y27),0)","v":0},{"$f":"IFERROR((K27/$Y27),0)","v":0},{"$f":"IFERROR((L27/$Y27),0)","v":0},{"$f":"IFERROR((M27/$Y27),0)","v":0},{"$f":"IFERROR((N27/$Y27),0)","v":0},{"$f":"IFERROR((O27/$Y27),0)","v":0},{"$f":"IFERROR((P27/$Y27),0)","v":0},{"$f":"IFERROR((Q27/$Y27),0)","v":0},{"$f":"IFERROR((R27/$Y27),0)","v":0},{"$f":"IFERROR((S27/$Y27),0)","v":0},{"$f":"IFERROR((T27/$Y27),0)","v":0},{"$f":"IFERROR((U27/$Y27),0)","v":0},{"$f":"IFERROR((V27/$Y27),0)","v":0},{"$f":"IFERROR((W27/$Y27),0)","v":0},{"$f":"IFERROR((X27/$Y27),0)","v":0},{"$f":"IFERROR(Y27/SUM($E27:$X27),0)","v":0}]
[]
[null,null,"Net Position to Apply to 2021-22 Rates:",null,{"$f":"$Y$34*E32","v":0},{"$f":"$Y$34*F32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"'3. Plan'!$J$60","v":0}]

{"sheet":"5. Rate Calculation","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,5,9,8],[0,1,0,12],[1,1,1,12]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"RECHARGE RATE CALCULATION "]
[null,null,"         Choose the applicable rate basis from the list below:"]
[]
[null,null,null,"   Square Footage: All costs divided by amount of space to be supported"]
[null,null,null,"   Unit: All costs divided by the number of items provided"]
[null,null,null,"   Per Hour: All costs divided by the number of billable hours (work hours less down time); link to template is below:"]
[null,null,null,"   https://brm.ucsf.edu/recharge-review-job-aids#How-to-calculate-billable-hours-for-an-hourly-rate"]
[null,null,null,"   Prorated Personnel: All salary costs divided by the devoted activity time   "]
[null,null,null,"   Other (describe):"]
[]
[null,null,"        Below insert a rate and revenue calculation that includes the detailed mathematical steps and computation(s) "]
[null,null,"        used to calculate each recharge rate and a narrative description of the rate methodology."]

{"sheet":"6. Volume Projections","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,2,4,5],[0,1,0,6],[1,1,1,6]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"ANNUAL VOLUME DATA FORECAST"]
[]
[null,null,"Below enter a description of the product or service and the actual recharged or forecasted number of units or hours for each service line."]
[]
[]
[null,null,"Service Description","2019-20\nActual \nVolume","2020-21\nVolume\nForecast","2021-22 Volume\nForecast"]
[null,null,"Service 1"]
[null,null,"Service 2"]
[null,null,"Service 3"]
[null,null,"Service 4"]
[null,null,"Service 5"]
[null,null,"Service 6"]
[null,null,"Service 7"]
[null,null,"Service 8"]
[null,null,"Service 9"]
[null,null,"Service 10"]
[null,null,"Service 11"]
[null,null,"Service 12"]

{"sheet":"7. Rate List","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"RATE LIST"]
[null,"Services:","Units:","Internal \nRates:","External*\nRates:"]
[null,"Service 1"]
[null,"Service 2"]
[null,"Service 3"]
[null,"Service 4"]
[null,"Service 5"]
[null,"Service 6"]
[null,"Service 7"]
[null,"Service 8"]
[null,"Service 9"]
[null,"Service 10"]
[null,"Service 11"]
[null,"Service 12"]
[]
[null,"* Includes 26% Facilities and Administration Rate"]

{"sheet":"8. Depreciation Schedule","index":7,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,4,27,13],[38,1,38,12],[0,1,0,16],[1,1,1,16],[11,4,11,5],[9,4,9,6]]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"EQUIPMENT DEPRECIATION SCHEDULE"]
[]
[null,null,null,null,"Notes:"]
[null,null,null,null,"Equipment purchased with Federal Funds cannot be depreciated on a recharge and should be deducted from the full cost."]
[null,null,null,null,"Equipment depreciation that is included in the Facilities and Administration (F&A) rate also may not be depreciated on a recharge. "]
[null,null,null,null,"Equipment purchased on or before December 31, 2019 that has not been previously depreciated on a recharge may not be included on the recharge."]
[null,null,null,null,"Schedules must be submitted using this format, and all fields must be completed."]
[null,null,null,null,"Proposals cannot be approved without a complete depreciation schedule."]
[null,null,null,null,"(insert additional worksheet(s) as needed)"]
[]
[null,null,null,null,"Recharge Activity Name:  ",null,null,{"$f":"IF('1. Proposal Details'!$E$5=\"\",\"\",'1. Proposal Details'!$E$5)","v":""}]
[]
[null,"(Insert additional lines as needed)",null,null,null,null,null,null,null,null,"(H - I)",null,"(J x K)",null,"(L / M)"]
[null,"Recharge \nDept ID","Recharge\nParent Project","Recharge\nFund","Description of Equipment","UC Equipment Tag Number","UCSF Asset ID","Acquisition Date","Full Cost                                                                                    ","Less: Fed Paid Amount","Net Cost","Percent of use by Recharge","Net Cost to Depreciate","Useful Life (Years)","Current Year Depreciation","Depreciation Start Date (MM/YY)","Depreciation End Date (MM/YY)"]
[null,"(A)","(B)","(C )","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)","(L)","(M)","(N)","(O)","(P)"]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",I17-J17)","v":""},null,{"$f":"IF(K17=\"\",\"\",K17*L17)","v":""},null,{"$f":"IF(N17=\"\", \"\",M17/N17)","v":""},null,{"$f":"IF(P17=\"\",\"\",(EDATE(P17,N17*12)-1))","v":""}]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,{"$f":"IF(I18=\"\",\"\",I18-J18)","v":""},null,{"$f":"IF(K18=\"\",\"\",K18*L18)","v":""},null,{"$f":"IF(N18=\"\", \"\",M18/N18)","v":""},null,{"$f":"IF(P18=\"\",\"\",(EDATE(P18,N18*12)-1))","v":""}]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,{"$f":"IF(P19=\"\",\"\",(EDATE(P19,N19*12)-1))","v":""}]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,{"$f":"IF('1. Proposal Details'!$E$10=\"\",\"\",'1. Proposal Details'!$E$10)","v":""},{"$f":"IF('1. Proposal Details'!$M$10=\"\",\"\",'1. Proposal Details'!$M$10)","v":""},{"$f":"IF('1. Proposal Details'!$H$10=\"\",\"\",'1. Proposal Details'!$H$10)","v":""},null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,null,null,null,"Total Amount to be Depreciated in 2021-22:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O17:O27)","v":0}]

{"sheet":"9. Complete Content Checklist","index":8,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"2021-22 RENEWAL RECHARGE PROPOSAL"]
[null,"CONTENT CHECKLIST FOR RENEWAL PROPOSALS"]
[]
[null,"               Category 2 proposals (proposals with planned expenses of $100,000 to $499,999 and federal participation greater than 50%, or with planned expenses greater than or equal"]
[null,"               to $500,000) must be submitted to Control Point for review and approval before submitting to Budget and Resource Management.  All other proposals should be submitted "]
[null,"               directly to recharge@ucsf.edu and copy to Control Point."]
[]
[null,"               Recharge service(s) are fully identified and described."]
[]
[null,"Recharge activities with more than one service line must calculate the prior year net position to apply to each service by reconciling actual revenue and expense for each "]
[null,"service from the last approval through 2020-21."]
[]
[null,"               Detailed mathematical steps for rate calculations are provided."]
[]
[null,"               Detailed actual and forecasted volume data is provided for each service. "]
[]
[null,"               Rate list including all internal and external rates is provided."]
[]
[null,"               Uniform Guidance unallowable expenditures are not included (i.e., equipment purchases greater than $5,000, mail stop, phone lines, ID badges, entertainment, gifts, "]
[null,"               memberships, furniture, STIP expense, advertising expense, any expense that was already paid by the federal government, etc.)."]
[]
[null,"               The proposed 2021-22 plan breaks even."]
[]
[null,"               The 2019-20 Net Position (on proposal page 3 in cell F66) matches the 6/30/20 MyReports Net Position Report, \"Net Position End of Period\". "]
[]
[null,"               If equipment depreciation expense was planned in 2019-20, it has been moved to the equipment reserve fund. "]
[]
[null,"               If equipment depreciation expense is planned, all equipment items are identified on the depreciation schedule form with 12-digit UC property ID numbers and 9-digit Tag "]
[null,"               numbers."]
[]
[null,"               If Working Capital is planned, it is not more than 16.6% of planned expense."]
[]
[null,"               If a subsidy is planned, the application, amount and Dept ID-Fund-Project are provided."]
[]
[null,"               If external revenue is planned:"]
[null,"               o      An external rate including 26% Facilities and Administration (F&A) rate has been calculated."]
[null,"               o      Facilities and Administration rate is not included in the plan."]
[]
[null,"               If the planned expenses are at least $500,000: the user committee has been identified, a member list has been provided, and a statement that the user committee has  "]
[null,"               endorsed approval of the rates is included. Such statements must be substantiated by department records."]
[]
[null,"               The proposal, with all supplements, is being submitted electronically in Excel file format."]
[]
[null,"          For School of Medicine and School of Dentistry Departments, the following are also attached for Category 2 proposals:"]
[]
[null,"               2019-20 MyReports Monthly Report"]
[]
[null,"               Copy of equipment depreciation transfer journals, if applicable"]
[]
[null,"               Copy of unallowable expense transfer journals, if applicable"]

{"sheet":"2020-21 Forecast","index":9,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,1,4],[0,5,1,10],[0,11,1,17],[4,0,7,1],[4,2,5,2],[4,3,4,14],[4,16,5,16],[4,17,5,17],[6,2,7,2],[6,3,7,3],[6,14,7,14],[6,8,7,8],[6,9,7,9],[54,0,54,1],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[20,0,20,1],[21,0,21,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[8,0,8,1],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[62,0,62,1],[65,0,65,17],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[60,0,60,1],[61,0,61,1]]}
[null,null,null,null,null,"2020-21 Forecast"]
[]
[]
[]
["Note: The gray columns contain Actuals and the clear columns contain the Forecast. Any necessary updates should only be made to the Forecast columns. The totals on this tab in column P will also be reflected in the Forecast column on tab 3. Plan.",null,"2020-21","2020-21"]
[null,null,null,"2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01"]
[null,null,"Plan","Actuals","Actuals","Actuals","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Total 2020-21","Plan / Forecast","Plan / Forecast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals & Forecast","Variance ($)","Variance (%)"]
["  REVENUES"]
["MC-Purchased Svcs Revenue","4151C",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:O10)","v":0},{"$f":"P10-C10","v":0},{"$f":"IFERROR(Q10/C10,\" \")","v":" "}]
["MC-Strategic Support","4152C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P11-C11","v":0}," "]
["Other Clinical Revenue","4153C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Affiliation/Contract Revenue","4154C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Sales and Service Revenue (External)","4200C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Recharge and Costed Central Act (Internal UCSF)","4250C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Other Revenues","4601C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Gift Revenue","4351C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Sponsored Project Rev Exc SFGH","4500C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Interest and Investment Income","4550C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Assessments ","4600C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["TOTAL REVENUES  ",null,{"$f":"SUM(C10:C20)","v":0},{"$f":"SUM(D10:D20)","v":0},{"$f":"SUM(E10:E20)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P10:P20)","v":0},0," "]
["  EXPENSES"]
["Faculty Salaries","5000C",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:O23)","v":0},{"$f":"C23-P23","v":0},{"$f":"IFERROR(Q23/C23,\" \")","v":" "}]
["Faculty Bonuses & Incentives","5010C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C24-P24","v":0}," "]
["Faculty Benefits","5030C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Non-Faculty Academic Salaries","5020C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Non-Faculty Academic Benefits","5040C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Staff Salaries and Overtime","5050C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Staff Benefits","5060C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Sponsored Projects - Subawards","5200C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Sponsored Proj - F&A Recovery","5202C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Depreciation","5500C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Sponsored Proj - Capital Equip","5201C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Occupancy Expense","5300C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Utilities","5320C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["FNDN Transfers to Campus","5400C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Assessments Expense","5510C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Supplies and Materials","5515C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Services","5550C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Travel, Mtgs & Entertainment","5578C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Scholarship/Fellowship","5579C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Other Expenses","5580C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["TOTAL EXPENSES  ",null,{"$f":"SUM(C23:C42)","v":0},{"$f":"SUM(D23:D42)","v":0},{"$f":"SUM(E23:E42)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P23:P42)","v":0},{"$f":"SUM(Q23:Q42)","v":0}," "]
["INCOME/(LOSS) FROM OPERATIONS  ",null,{"$f":"C21-C43","v":0},{"$f":"D21-D43","v":0},{"$f":"E21-E43","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P21-P43","v":0},{"$f":"Q21+Q43","v":0}]
["  OTHER CHANGES"]
["Capital Equip (Non-Spon Proj)","5700C",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:O46)","v":0},{"$f":"P46-C46","v":0},{"$f":"IFERROR(Q46/C46,\" \")","v":" "}]
["Transfers - Deficit Support","7801C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers - Dean's Support","7802C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers - Chanc/VC Support","7803C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers - Other Support","7805C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers - Curr to/from Other Funds","7806C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers - Curr/Plant Capital Outlay","7808C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Transfers -  STIP","7809C",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["Less Subsidies (attach details regarding method and Dept ID-Fund-Project)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0," "]
["TOTAL OTHER CHANGES  ",null,{"$f":"SUM(C46:C54)","v":0},{"$f":"SUM(D46:D54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0," "]
["  CHANGE IN NET POSITION"]
["Increase/(decrease) in unrestricted net position",null,{"$f":"C44+C55","v":0},{"$f":"D44+D55","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D57:O57)","v":0},{"$f":"Q44-Q55","v":0},{"$f":"IFERROR(Q57/C57,\" \")","v":" "}]
["INCREASE/(DECREASE) IN NET POSITION  ",null,{"$f":"C57","v":0},{"$f":"D57","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D58:O58)","v":0},0," "]
["  NET POSITION"]
[null,"Unrestricted - beginning of period",{"$f":"'3. Plan'!H66","v":0},{"$f":"C60","v":0},{"$f":"D61","v":0},{"$f":"E61","v":0},0,0,0,0,0,0,0,0,0,{"$f":"D60","v":0},{"$f":"Q56+Q59","v":0}," "]
["Unrestricted - end of period",null,{"$f":"C57+C60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0," "]
["TOTAL NET POSITION - BEGINNING OF PERIOD  ",null,{"$f":"C60","v":0},{"$f":"D60","v":0},{"$f":"E60","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"D62","v":0},{"$f":"C62-P62","v":0}," "]
["TOTAL NET POSITION - END OF PERIOD  ",null,{"$f":"C61","v":0},{"$f":"D61","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"O63","v":0},{"$f":"-C63+P63","v":0}," "]