{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Year-end Performance Review"," Instructions","1 Volume Projections","2 Salary & Fringe","3 Other Direct Expenses","5 Equipment Depreciation","4 Admin Overhead Expenses","6 Expense Summary","7 Proposed Rate(s)","8 Revenue Summary","9 Five Year Projection"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":6,"defined_names":53,"comments":1,"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":"Year-end Performance Review","index":0,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,13],[3,0,3,13]]}
["The University of Kansas"]
["Year-end Rate Performance Review"]
[]
["Form Requirements:  Any department that is charging a fee for a good or service is required to complete the following form on annual basis and submit it to the Service Center Fee Evaluation Committee by December 31st.  Departments that do not complete this form by the required due date face the risk of having their fee approval revoked and will not be allowed to collect any future collections."]
[]
["Service Center:"]
["Dept/Cost Center:  "]
["Primary Contact:  "]
[null,"Name/Title"]
[null,"Direct Phone #"]
[null,"E-mail Address"]
[]
["DESCRIPTION OF GOOD/SERVICE PROVIDED BY SERVICE CENTER:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DATE OF APPROVED RATE STRUCTURE:"]
[]
["IS A RATE CHANGE REQUESTED FOR THE UPCOMING FISCAL YEAR:",null,null,null,null,null,null,null,null,null,null,"YES",null,"NO"]
["If YES, attach completed \"Service Center Request Form\""]
[]
["CASH FLOW SUMMARY: (Provide both Current Year and Prior Year)"]
[]
[null,null,null,null,null,null,null,"FY200Y",null,"FY200X"]
[null,"Revenues:"]
[null,"Internal Users"]
[null,null,"KU Departments",null,null,null,null,225000,null,210000]
[null,null,"Sponsored Projects",null,null,null,null,680000,null,675000]
[null,"External Users"]
[null,null,"Students",null,null,null,null,0,null,0]
[null,null,"Faculty/Staff",null,null,null,null,0,null,0]
[null,null,"Off Campus Entities:",null,null,null,null,0,null,0]
[null,null,null,"Other Kansas Universities",null,null,null,0,null,0]
[null,null,null,"Other Universities",null,null,null,0,null,0]
[null,null,null,"Kansas State Agencies",null,null,null,0,null,0]
[null,null,null,"Other State Agencies",null,null,null,0,null,0]
[null,null,null,"Other (Foundations, Corporations, etc.)",null,null,null,0,null,0]
[null,null,null,null,"Total Revenues",null,null,{"$f":"SUM(H33:H43)","v":905000},null,{"$f":"SUM(J33:J43)","v":885000}]
[]
[null,"Expenses:"]
[null,null,"Salaries",null,null,null,null,85000,null,80000]
[null,null,"Fringe Benefits",null,null,null,null,22880,null,20250]
[null,null,"Inventory",null,null,null,null,750000,null,770000]
[null,null,"Stockroom Supplies",null,null,null,null,22000,null,25000]
[null,null,"Other Expenses",null,null,null,null,1200,null,2500]
[null,null,null,null,"Total Recoverable Expenses",null,null,{"$f":"SUM(H47:H51)","v":881080},null,{"$f":"SUM(J47:J51)","v":897750}]
[]
[null,"Operating Gain/Loss",null,null,null,null,null,{"$f":"H44-H52","v":23920},null,{"$f":"J44-J52","v":-12750}]
[]
[null,"Percentage of Expenses",null,null,null,null,null,{"$f":"H54/H52","v":2.7148499568711126E-2},null,{"$f":"J54/J52","v":-1.4202172096908938E-2}]
[]
[null,"Excluded Expenses"]
[null,null,"Capitalized Equipment",null,null,null,null,0,null,0]
[]
[]
[]
[]
[]
["APPROVALS:"]
[]
["SERVICE CENTER PRIMARY CONTACT:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
["DEPT. CHAIR/DIRECTOR APPROVAL:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
["DEAN APPROVAL :",null,null,null,null,null,null,null,null,null,null,"DATE:"]
["(If Academic Department or Organized Research Unit)"]
[]
[]
["COMMITTEE ACTION:"]
[]
[null,null,null,null,null,"Accepted",null,null,"Not Accepted"]
[]
["COMMITTEE SIGNATURE:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[]
["VP, ADMIN & FINANCE APPROVAL:",null,null,null,null,null,null,null,null,null,null,"DATE:"]

{"sheet":" Instructions","index":1,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,3,16]]}
[null,"CELLS THAT HAVE THIS BLUE COLOR SHADING ARE AVAILABLE TO YOU TO INPUT YOUR NECESSARY DATA. THE DATA WITHIN THESE CELLS ARE PROGRAMMED TO CALCULATE VARIOUS FIGURES THAT WILL CALCULATE YOUR RATES"]
[]
[]
[]
[null,"Overview of  Service Center Budget Template "]
[null,"-Template tabs used for input are numbered from 1 to 9.  Please complete the analysis in numerical order (1-9) on the template. Tabs 6-9 are predominantly computed Summary results."]
[null,"-Tabs 1-9 containing cells highlighted in the BLUE color can be modified to input new values without disrupting the formulas linking the various sheets."]
[]
[null,"1 Volume Projections Tab Green Tab)"]
[null,"- Record your anticipated volume for each service"]
[null,"- Determine your unit of measure for each service (ex. per hour or per sample)"]
[null,"- Estimate the volume of services by users (both internal and external) so the appropriate rates can be applied to each type of user in future tabs."]
[]
[null,"2 Salaries & Fringe Tab (Red Tab)"]
[null,"- Please input the the following for each employee"]
[null,null,"(1) Full name, title, annual salary and fringe rate for each individual related to the service center"]
[null,null,"(2) Enter the percent effort it takes for each individual to complete each service"]
[null,null,"(3) Check to make sure you have allocated the total effort assigned to the service center for each individual"]
[]
[null,"3 Other Direct Expenses (Red Tabs)"]
[null,"- Enter service specific or fixed costs such as equipment leases, service contracts, kit costs, and consumable supplies for each service"]
[]
[null,"4 Admin & Overhead Expenses (Red Tabs)"]
[null,"- Enter non-service specific or overhead costs to operate the service center.  This includes one-time costs such as travel, membership fees, large one time part repairs, rent, and administrative personnel."]
[null,"- Enter Logevity pay for any facility staff members as a non-service specific or overhead costs to operate the service center.  "]
[]
[null,"5 Equipment Depreciation (Red Tab)"]
[null,"-Enter the detailed information (model, serial #, purchase price) for each piece of equipment with book value in your service center."]
[null,"-For each piece of equipment, allocate the percent of usage for each service"]
[]
[null,"6 Expense Summary (Red Tab)"]
[null,"-This is a calculated tab that displays results only and has no user input data cells other than a cell to enter any prior year surplus/deficit.  "]
[]
[null,"7 Proposed Rates  (Green Tab)"]
[null,"- Rates are calculated by the system"]
[null,"- In the event that you want to input rates different than the system calculated, please input into each corresponding service under \"Charge Per Unit\""]
[]
[null,"8 Revenue Summary (Green Tab)"]
[null,"-This is a calculated results-only tab that multiplies the rates from Proposed Rates tab times the anticipated demand for each service from the Volume Projections tab to arrive at the expected annual revenue."]
[null,"-The XLS sheet also breaks out the portion of expense into operations, equipment reserve, and F&A. "]
[]
[null,"9 Five Year Projection (Blue Tab)"]
[null,"-Enter the anticipated start date, the number of months your core will be in service, and any additional lag in revenue during the first year. Most service centers do not operate at 100% capacity in their first year."]
[null,"-The rest of the tab is a calculated based on aggregated results from information on previous tabs to display your 5-year annual operating surplus/deficit.  "]

{"sheet":"1 Volume Projections","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,0,3,8],[4,0,4,8],[5,0,5,8]]}
["Service Center Name: "]
["Core Director:"]
["Service Center Fund #:"]
[{"$f":"B1","v":"00:00:00"}]
["Volume Projections"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
[null,null,null,null,"Internal","UTSystem / In Network","External Non-Profit","External For-Profit"]
["Service #","Service Description","Metric","Total Estimated Annual Usage","All UTHealh Users","UTSystem Institutions","Non-Profit Universities & State Agencies","For-Profit Corporations, Pharma, etc."]
["Example:"]
["Service 1",null,"Machine Hours",{"$f":"SUM(E13:H13)","v":305},100,200,null,5]
["Service 2",null,"Completed Test",{"$f":"SUM(E14:H14)","v":30},15,null,15]
["Service 1",null,null,{"$f":"SUM(E15:H15)","v":0},0,0,0,0]
["Service 2",null,null,0,0,0,0,0]
["Service 3",null,null,0,0,0,0,0]
["Service 4",null,null,0,0,0,0,0]
["Service 5",null,null,0,0,0,0,0]
["Service 6",null,null,0,0,0,0,0]
["Service 7",null,null,0,0,0,0,0]
["Service 8",null,null,0,0,0,0,0]
["Service 9",null,null,0,0,0,0,0]
["Service 10",null,null,0,0,0,0,0]
["Service 11",null,null,0,0,0,0,0]
["Service 12",null,null,0,0,0,0,0]
["Service 13",null,null,0,0,0,0,0]
["Service 14",null,null,0,0,0,0,0]
["Service 15",null,null,{"$f":"SUM(E29:H29)","v":0},0,0,0,0]
["Service 16",null,null,0,0,0,0,0]
["Service 17",null,null,0,0,0,0,0]
["Service 18",null,null,0,0,0,0,0]
["Service 19",null,null,0,0,0,0,0]
["Service 20",null,null,0,0,0,0,0]
["Service 21",null,null,0,0,0,0,0]
["Service 22",null,null,0,0,0,0,0]
["Service 23",null,null,0,0,0,0,0]
["Service 24",null,null,0,0,0,0,0]
["Service 25",null,null,0,0,0,0,0]
[null,null,"Total By Users",{"$f":"SUM(D15:D39)","v":0},{"$f":"SUM(E15:E39)","v":0},{"$f":"SUM(F15:F39)","v":0},{"$f":"SUM(G15:G39)","v":0},{"$f":"SUM(H15:H39)","v":0}]

{"sheet":"2 Salary & Fringe","index":3,"n_rows":43,"n_cols":61,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,25],[1,0,1,25],[2,0,2,25],[9,60,10,60],[30,9,30,12],[7,15,7,16],[7,17,7,18],[7,21,7,22],[7,29,7,30],[7,19,7,20],[7,13,7,14],[7,31,7,32],[7,33,7,34],[7,35,7,36],[7,37,7,38],[6,9,6,30],[7,57,7,58],[36,0,36,1],[7,47,7,48],[7,49,7,50],[7,51,7,52],[7,53,7,54],[7,55,7,56],[7,11,7,12],[7,25,7,26],[7,9,7,10],[7,45,7,46],[7,27,7,28],[7,39,7,40],[7,41,7,42],[7,43,7,44],[7,23,7,24]]}
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Salary and Fringe "]
["Fiscal Year 2026"]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
[null,null,null,null,null,null,null,null,null,"Service Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Description"]
[null,null,null,null,null,null,null,null,null,{"$f":"'1 Volume Projections'!$B15","v":0},null,{"$f":"'1 Volume Projections'!B16","v":0},null,{"$f":"'1 Volume Projections'!B17","v":0},null,{"$f":"'1 Volume Projections'!B18","v":0},null,{"$f":"'1 Volume Projections'!B19","v":0},null,{"$f":"'1 Volume Projections'!B20","v":0},null,{"$f":"'1 Volume Projections'!B21","v":0},null,{"$f":"'1 Volume Projections'!B22","v":0},null,{"$f":"'1 Volume Projections'!B23","v":0},null,{"$f":"'1 Volume Projections'!B24","v":0},null,{"$f":"'1 Volume Projections'!B25","v":0},null,{"$f":"'1 Volume Projections'!B26","v":0},null,{"$f":"'1 Volume Projections'!B27","v":0},null,{"$f":"'1 Volume Projections'!B28","v":0},null,{"$f":"'1 Volume Projections'!B29","v":0},null,{"$f":"'1 Volume Projections'!B30","v":0},null,{"$f":"'1 Volume Projections'!B31","v":0},null,{"$f":"'1 Volume Projections'!B32","v":0},null,{"$f":"'1 Volume Projections'!B33","v":0},null,{"$f":"'1 Volume Projections'!B34","v":0},null,{"$f":"'1 Volume Projections'!B35","v":0},null,{"$f":"'1 Volume Projections'!B36","v":0},null,{"$f":"'1 Volume Projections'!B37","v":0},null,{"$f":"'1 Volume Projections'!B38","v":0},null,{"$f":"'1 Volume Projections'!B39","v":0}]
["Employee Name","Title","UUID #","Annual Salary $","Effort %","Effort Amount $","Fringe Benefit Rate %","Fringe Benefits Amount $","Total           Salary & FB $","Service #1 ","% of Time","Service #2 ","% of Time","Service #3 ","% of Time","Service #4 ","% of Time","Service #5 ","% of Time","Service #6","% of Time","Service #7","% of Time","Service #8","% of Time","Service #9","% of Time","Service #10","% of Time","Service #11","% of Time","Service #12","% of Time","Service #13","% of Time","Service #14","% of Time","Service #15","% of Time","Service #16","% of Time","Service #17","% of Time","Service #18","% of Time","Service #19","% of Time","Service #20","% of Time","Service #21","% of Time","Service #22","% of Time","Service #23","% of Time","Service #24","% of Time","Service #25","% of Time","Check Total","Comments"]
["Example:",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,null,null,null,null,null,null,null,null,null,null,null,null,"Check Total Must Equal 100% Effort"]
["Jane Doe","Technician",99999,48000,1,{"$f":"+D11*E11","v":48000},0.34,{"$f":"+F11*G11","v":16320.000000000002},{"$f":"+F11+H11","v":64320},{"$f":"I11*K11","v":32160},0.5,{"$f":"I11*M11","v":32160},0.5,{"$f":"I11*O11","v":0},0,{"$f":"I11*Q11","v":0},0,{"$f":"I11*S11","v":0},0,{"$f":"I11*U11","v":0},0,{"$f":"I11*W11","v":0},0,{"$f":"I11*Y11","v":0},0,{"$f":"I11*AA11","v":0},0,{"$f":"G11*AC11","v":0},0,{"$f":"I11*AE11","v":0},0,{"$f":"K11*AG11","v":0},0,{"$f":"M11*AI11","v":0},0,{"$f":"O11*AK11","v":0},0,{"$f":"Q11*AM11","v":0},0,{"$f":"S11*AO11","v":0},0,{"$f":"U11*AQ11","v":0},0,{"$f":"W11*AS11","v":0},0,{"$f":"Y11*AU11","v":0},0,{"$f":"AA11*AW11","v":0},0,{"$f":"AC11*AY11","v":0},0,{"$f":"AE11*BA11","v":0},0,{"$f":"AG11*BC11","v":0},0,{"$f":"AI11*BE11","v":0},0,{"$f":"AK11*BG11","v":0},0,{"$f":"+K11+M11+O11+Q11+S11+U11+W11+Y11+AA11+AC11+AE11+AG11+AI11+AK11+AM11+AO11+AQ11+AS11+AU11+AW11+AY11+BA11+BC11+BE11+BG11","v":1}]
[null,null,null,null,null,{"$f":"+D12*E12","v":0},null,{"$f":"+F12*G12","v":0},{"$f":"+F12+H12","v":0},{"$f":"$I12*K12","v":0},null,{"$f":"$I12*M12","v":0},null,{"$f":"$I12*O12","v":0},null,{"$f":"$I12*Q12","v":0},null,{"$f":"$I12*S12","v":0},null,{"$f":"$I12*U12","v":0},null,{"$f":"$I12*W12","v":0},null,{"$f":"$I12*Y12","v":0},null,{"$f":"$I12*AA12","v":0},null,{"$f":"$I12*AC12","v":0},null,{"$f":"$I12*AE12","v":0},null,{"$f":"$I12*AG12","v":0},null,{"$f":"$I12*AI12","v":0},null,{"$f":"$I12*AK12","v":0},null,{"$f":"$I12*AM12","v":0},null,{"$f":"$I12*AO12","v":0},null,{"$f":"$I12*AQ12","v":0},null,{"$f":"$I12*AS12","v":0},null,{"$f":"$I12*AU12","v":0},null,{"$f":"$I12*AW12","v":0},null,{"$f":"$I12*AY12","v":0},null,{"$f":"$I12*BA12","v":0},null,{"$f":"$I12*BC12","v":0},null,{"$f":"$I12*BE12","v":0},null,{"$f":"$I12*BG12","v":0},null,{"$f":"+K12+M12+O12+Q12+S12+U12+W12+Y12+AA12+AC12+AE12+AG12+AI12+AK12+AM12+AO12+AQ12+AS12+AU12+AW12+AY12+BA12+BC12+BE12+BG12","v":0}]
[null,null,null,null,null,{"$f":"+D13*E13","v":0},null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+K13+M13+O13+Q13+S13+U13+W13+Y13+AA13+AC13+AE13+AG13+AI13+AK13+AM13+AO13+AQ13+AS13+AU13+AW13+AY13+BA13+BC13+BE13+BG13","v":0}]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,{"$f":"+F16*G16","v":0},{"$f":"+F16+H16","v":0},{"$f":"$I16*K16","v":0},null,{"$f":"$I16*M16","v":0},null,{"$f":"$I16*O16","v":0},null,{"$f":"$I16*Q16","v":0},null,{"$f":"$I16*S16","v":0},null,{"$f":"$I16*U16","v":0},null,{"$f":"$I16*W16","v":0},null,{"$f":"$I16*Y16","v":0},null,{"$f":"$I16*AA16","v":0},null,{"$f":"$I16*AC16","v":0},null,{"$f":"$I16*AE16","v":0},null,{"$f":"$I16*AG16","v":0},null,{"$f":"$I16*AI16","v":0},null,{"$f":"$I16*AK16","v":0},null,{"$f":"$I16*AM16","v":0},null,{"$f":"$I16*AO16","v":0},null,{"$f":"$I16*AQ16","v":0},null,{"$f":"$I16*AS16","v":0},null,{"$f":"$I16*AU16","v":0},null,{"$f":"$I16*AW16","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,{"$f":"SUM(D12:D29)","v":0},null,{"$f":"SUM(F12:F29)","v":0},null,{"$f":"SUM(H12:H29)","v":0},{"$f":"SUM(I12:I29)","v":0},{"$f":"SUM(J12:J29)","v":0},null,{"$f":"SUM(L12:L29)","v":0},null,{"$f":"SUM(N12:N29)","v":0},null,{"$f":"SUM(P12:P29)","v":0},null,{"$f":"SUM(R12:R29)","v":0},null,{"$f":"SUM(T12:T29)","v":0},null,{"$f":"SUM(V12:V29)","v":0},null,{"$f":"SUM(X12:X29)","v":0},null,{"$f":"SUM(Z12:Z29)","v":0},null,{"$f":"SUM(AB12:AB29)","v":0},null,{"$f":"SUM(AD12:AD29)","v":0},null,{"$f":"SUM(AF12:AF29)","v":0},null,{"$f":"SUM(AH12:AH29)","v":0},null,{"$f":"SUM(AJ12:AJ29)","v":0},null,{"$f":"SUM(AL12:AL29)","v":0},null,{"$f":"SUM(AN12:AN29)","v":0},null,{"$f":"SUM(AP12:AP29)","v":0},null,{"$f":"SUM(AR12:AR29)","v":0},null,{"$f":"SUM(AT12:AT29)","v":0},null,{"$f":"SUM(AV12:AV29)","v":0},null,{"$f":"SUM(AX12:AX29)","v":0},null,{"$f":"SUM(AZ12:AZ29)","v":0},null,{"$f":"SUM(BB12:BB29)","v":0},null,{"$f":"SUM(BD12:BD29)","v":0},null,{"$f":"SUM(BF12:BF29)","v":0}]
[]
["Notes:"]
["Fringe Benefits are calculated based on the approved federal rate."]
["Input the rate % from the below listed federal rates if the rate is other than the one listed."]
["The approved Federal Fringe Benefit Rates are as follows:"]
[]
[" FY26 Fringe Rate/ Benefit Tiers"]
[0,0.46]
[40000,0.39]
[70000,0.31]
[150000,0.26]
[230000,0.2]
[500000,0.13]

{"sheet":"3 Other Direct Expenses","index":4,"n_rows":51,"n_cols":54,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,1,23],[2,0,2,23],[3,0,3,23],[8,24,8,25],[8,26,8,27],[7,24,7,51],[8,40,8,41],[8,42,8,43],[8,44,8,45],[8,46,8,47],[51,2,51,5],[8,2,8,3],[8,4,8,5],[7,2,7,23],[8,38,8,39],[8,28,8,29],[8,30,8,31],[8,32,8,33],[8,34,8,35],[8,36,8,37],[10,53,12,53],[8,6,8,7],[8,20,8,21],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[8,22,8,23],[8,18,8,19],[8,48,8,49],[8,50,8,51]]}
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Other Direct Expenses "]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
[null,null,"Service Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Description"]
[null,null,{"$f":"'1 Volume Projections'!B15","v":0},null,{"$f":"'1 Volume Projections'!B16","v":0},null,{"$f":"'1 Volume Projections'!B17","v":0},null,{"$f":"'1 Volume Projections'!B18","v":0},null,{"$f":"'1 Volume Projections'!B19","v":0},null,{"$f":"'1 Volume Projections'!B20","v":0},null,{"$f":"'1 Volume Projections'!B21","v":0},null,{"$f":"'1 Volume Projections'!B22","v":0},null,{"$f":"'1 Volume Projections'!B23","v":0},null,{"$f":"'1 Volume Projections'!B24","v":0},null,{"$f":"'1 Volume Projections'!B25","v":0},null,{"$f":"'1 Volume Projections'!B26","v":0},null,{"$f":"'1 Volume Projections'!B27","v":0},null,{"$f":"'1 Volume Projections'!B28","v":0},null,{"$f":"'1 Volume Projections'!B29","v":0},null,{"$f":"'1 Volume Projections'!B30","v":0},null,{"$f":"'1 Volume Projections'!B31","v":0},null,{"$f":"'1 Volume Projections'!B32","v":0},null,{"$f":"'1 Volume Projections'!B33","v":0},null,{"$f":"'1 Volume Projections'!B23","v":0},null,{"$f":"'1 Volume Projections'!B35","v":0},null,{"$f":"'1 Volume Projections'!B36","v":0},null,{"$f":"'1 Volume Projections'!B37","v":0},null,{"$f":"'1 Volume Projections'!B38","v":0},null,{"$f":"'1 Volume Projections'!B39","v":0}]
["Description of Service or Supply","Total","Service #1 ","% of Time","Service #2 ","% of Time","Service #3 ","% of Time","Service #4 ","% of Time","Service #5 ","% of Time","Service #6 ","% of Time","Service #7 ","% of Time","Service #8 ","% of Time","Service #9 ","% of Time","Service #10","% of Time","Service #11","% of Time","Service #12","% of Time","Service #13","% of Time","Service #14","% of Time","Service #15","% of Time","Service #16","% of Time","Service #17","% of Time","Service #18","% of Time","Service #19 ","% of Time","Service #20","% of Time","Service #21","% of Time","Service #22","% of Time","Service #23","% of Time","Service #24","% of Time","Service #25","% of Time","Check Total","Comments"]
["Example:",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,null,null,null,null,null,"Check Total Must Equal 100%"]
["Equipment Maintenance Agreement",5000,{"$f":"B12*D12","v":5000},1,{"$f":"B12*F12","v":0},0,{"$f":"B12*H12","v":0},0,{"$f":"B12*J12","v":0},0,{"$f":"B12*L12","v":0},0,{"$f":"B12*N12","v":0},0,{"$f":"B12*P12","v":0},0,{"$f":"B12*R12","v":0},0,{"$f":"B12*T12","v":0},0,{"$f":"B12*V12","v":0},0,{"$f":"B12*X12","v":0},0,{"$f":"B12*Z12","v":0},0,{"$f":"B12*AB12","v":0},0,{"$f":"B12*AD12","v":0},0,{"$f":"B12*AF12","v":0},0,{"$f":"B12*AH12","v":0},0,{"$f":"B12*AJ12","v":0},0,{"$f":"B12*AL12","v":0},0,{"$f":"B12*AN12","v":0},0,{"$f":"B12*AP12","v":0},0,{"$f":"B12*AR12","v":0},0,{"$f":"B12*AT12","v":0},0,{"$f":"B12*AV12","v":0},0,{"$f":"B12*AX12","v":0},0,{"$f":"B12*AZ12","v":0},0,{"$f":"+D12+F12+H12+J12+L12+N12+P12+R12+T12+V12+X12+Z12+AB12+AD12+AF12+AH12+AJ12+AL12+AN12+AP12+AR12+AT12+AV12+AX12+AZ12","v":1}]
["Supplies (e.g. equipment supplies)",1200,{"$f":"B13*D13","v":600},0.5,{"$f":"B13*F13","v":600},0.5,{"$f":"B13*H13","v":0},0,{"$f":"B13*J13","v":0},0,{"$f":"B13*L13","v":0},0,{"$f":"B13*N13","v":0},0,{"$f":"B13*P13","v":0},0,{"$f":"B13*R13","v":0},0,{"$f":"B13*T13","v":0},0,{"$f":"B13*V13","v":0},0,{"$f":"B13*X13","v":0},0,{"$f":"B13*Z13","v":0},0,{"$f":"B13*AB13","v":0},0,{"$f":"B13*AD13","v":0},0,{"$f":"B13*AF13","v":0},0,{"$f":"B13*AH13","v":0},0,{"$f":"B13*AJ13","v":0},0,{"$f":"B13*AL13","v":0},0,{"$f":"B13*AN13","v":0},0,{"$f":"B13*AP13","v":0},0,{"$f":"B13*AR13","v":0},0,{"$f":"B13*AT13","v":0},0,{"$f":"B13*AV13","v":0},0,{"$f":"B13*AX13","v":0},0,{"$f":"B13*AZ13","v":0},0,1]
["Materials & Supplies, (ex. Service 1)",null,{"$f":"B14*D14","v":0},null,{"$f":"$B14*F14","v":0},null,{"$f":"$B14*H14","v":0},null,{"$f":"$B14*J14","v":0},null,{"$f":"$B14*L14","v":0},null,{"$f":"$B14*N14","v":0},null,{"$f":"$B14*P14","v":0},null,{"$f":"$B14*R14","v":0},null,{"$f":"$B14*T14","v":0},null,{"$f":"$B14*V14","v":0},null,{"$f":"$B14*X14","v":0},null,{"$f":"$B14*Z14","v":0},null,{"$f":"$B14*AB14","v":0},null,{"$f":"$B14*AD14","v":0},null,{"$f":"$B14*AF14","v":0},null,{"$f":"$B14*AH14","v":0},null,{"$f":"$B14*AJ14","v":0},null,{"$f":"$B14*AL14","v":0},null,{"$f":"$B14*AN14","v":0},null,{"$f":"$B14*AP14","v":0},null,{"$f":"$B14*AR14","v":0},null,{"$f":"$B14*AT14","v":0},null,{"$f":"$B14*AV14","v":0},null,{"$f":"$B14*AX14","v":0},null,{"$f":"$B14*AZ14","v":0},null,{"$f":"+D14+F14+H14+J14+L14+N14+P14+R14+T14+V14+X14+Z14+AB14+AD14+AF14+AH14+AJ14+AL14+AN14+AP14+AR14+AT14+AV14+AX14+AZ14","v":0}]
["Materials & Supplies, (ex. Service 2)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$B15*X15","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+D15+F15+H15+J15+L15+N15+P15+R15+T15+V15+X15+Z15+AB15+AD15+AF15+AH15+AJ15+AL15+AN15+AP15+AR15+AT15+AV15+AX15+AZ15","v":0}]
["Materials & Supplies, (ex. Service 3)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Maintenance & Repair, (ex. Machine 1)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Maintenance & Repair, (ex. Machine 2)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Maintenance & Repair, (ex. Machine 3)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Operating Expenses, Other",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Other Contracted Services",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$B21*X21","v":0},null,{"$f":"$B21*Z21","v":0},null,0,null,{"$f":"$B21*AD21","v":0},null,0,null,0,null,{"$f":"$B21*AJ21","v":0},null,{"$f":"$B21*AL21","v":0},null,0,null,0,null,{"$f":"$B21*AR21","v":0},null,{"$f":"$B21*AT21","v":0},null,{"$f":"$B21*AV21","v":0},null,0,null,0,null,0]
["Travel Expenses",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$B22*X22","v":0},null,{"$f":"$B22*Z22","v":0},null,0,null,{"$f":"$B22*AD22","v":0},null,{"$f":"$B22*AF22","v":0},null,{"$f":"$B22*AH22","v":0},null,{"$f":"$B22*AJ22","v":0},null,{"$f":"$B22*AL22","v":0},null,0,null,{"$f":"$B22*AP22","v":0},null,{"$f":"$B22*AR22","v":0},null,{"$f":"$B22*AT22","v":0},null,{"$f":"$B22*AV22","v":0},null,{"$f":"$B22*AX22","v":0},null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$B23*X23","v":0},null,{"$f":"$B23*Z23","v":0},null,{"$f":"$B23*AB23","v":0},null,{"$f":"$B23*AD23","v":0},null,{"$f":"$B23*AF23","v":0},null,{"$f":"$B23*AH23","v":0},null,{"$f":"$B23*AJ23","v":0},null,{"$f":"$B23*AL23","v":0},null,{"$f":"$B23*AN23","v":0},null,{"$f":"$B23*AP23","v":0},null,{"$f":"$B23*AR23","v":0},null,{"$f":"$B23*AT23","v":0},null,{"$f":"$B23*AV23","v":0},null,{"$f":"$B23*AX23","v":0},null,{"$f":"$B23*AZ23","v":0},null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$B24*Z24","v":0},null,{"$f":"$B24*AB24","v":0},null,{"$f":"$B24*AD24","v":0},null,{"$f":"$B24*AF24","v":0},null,{"$f":"$B24*AH24","v":0},null,{"$f":"$B24*AJ24","v":0},null,{"$f":"$B24*AL24","v":0},null,{"$f":"$B24*AN24","v":0},null,{"$f":"$B24*AP24","v":0},null,{"$f":"$B24*AR24","v":0},null,{"$f":"$B24*AT24","v":0},null,{"$f":"$B24*AV24","v":0},null,{"$f":"$B24*AX24","v":0},null,{"$f":"$B24*AZ24","v":0},null,0]
[null,null,{"$f":"B25*D25","v":0},null,{"$f":"$B25*F25","v":0},null,{"$f":"$B25*H25","v":0},null,{"$f":"$B25*J25","v":0},null,{"$f":"$B25*L25","v":0},null,{"$f":"$B25*N25","v":0},null,{"$f":"$B25*P25","v":0},null,{"$f":"$B25*R25","v":0},null,{"$f":"$B25*T25","v":0},null,{"$f":"$B25*V25","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,{"$f":"B27*D27","v":0},null,{"$f":"$B27*F27","v":0},null,{"$f":"$B27*H27","v":0},null,{"$f":"$B27*J27","v":0},null,{"$f":"$B27*L27","v":0},null,{"$f":"$B27*N27","v":0},null,{"$f":"$B27*P27","v":0},null,{"$f":"$B27*R27","v":0},null,{"$f":"$B27*T27","v":0},null,{"$f":"$B27*V27","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,{"$f":"$B43*F43","v":0},null,{"$f":"$B43*H43","v":0},null,{"$f":"$B43*J43","v":0},null,{"$f":"$B43*L43","v":0},null,{"$f":"$B43*N43","v":0},null,{"$f":"$B43*P43","v":0},null,{"$f":"$B43*R43","v":0},null,{"$f":"$B43*T43","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,{"$f":"SUM(B14:B50)","v":0},{"$f":"SUM(C14:C50)","v":0},null,{"$f":"SUM(E14:E50)","v":0},null,{"$f":"SUM(G14:G50)","v":0},null,{"$f":"SUM(I14:I50)","v":0},null,{"$f":"SUM(K14:K50)","v":0},null,{"$f":"SUM(M14:M50)","v":0},null,{"$f":"SUM(O14:O50)","v":0},null,{"$f":"SUM(Q14:Q50)","v":0},null,{"$f":"SUM(S14:S50)","v":0},null,{"$f":"SUM(U14:U50)","v":0},null,{"$f":"SUM(W14:W50)","v":0},null,{"$f":"SUM(Y14:Y50)","v":0},null,{"$f":"SUM(AA14:AA50)","v":0},null,{"$f":"SUM(AC14:AC50)","v":0},null,{"$f":"SUM(AE14:AE50)","v":0},null,{"$f":"SUM(AG14:AG50)","v":0},null,{"$f":"SUM(AI14:AI50)","v":0},null,{"$f":"SUM(AK14:AK50)","v":0},null,{"$f":"SUM(AM14:AM50)","v":0},null,{"$f":"SUM(AO14:AO50)","v":0},null,{"$f":"SUM(AQ14:AQ50)","v":0},null,{"$f":"SUM(AS14:AS50)","v":0},null,{"$f":"SUM(AU14:AU50)","v":0},null,{"$f":"SUM(AW14:AW50)","v":0},null,{"$f":"SUM(AY14:AY50)","v":0}]

{"sheet":"5 Equipment Depreciation","index":5,"n_rows":22,"n_cols":62,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,31],[2,0,2,31],[3,0,3,31],[6,32,6,59],[7,26,7,27],[7,32,7,33],[7,34,7,35],[7,36,7,37],[7,38,7,39],[7,40,7,41],[7,42,7,43],[7,44,7,45],[7,24,7,25],[6,10,6,31],[6,0,7,9],[22,10,22,13],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,30,7,31],[7,16,7,17],[7,18,7,19],[7,20,7,21],[7,22,7,23],[7,28,7,29],[9,61,10,61],[7,56,7,57],[7,58,7,59],[7,46,7,47],[7,50,7,51],[7,48,7,49],[7,52,7,53],[7,54,7,55]]}
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Equipment Depreciation"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
["This tab is for purchased equpiment only. If you are leasing your equipment, please enter the expense on tab 3 Other Direct Expenses ",null,null,null,null,null,null,null,null,null,"Service Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Description"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'1 Volume Projections'!B15","v":0},null,{"$f":"'1 Volume Projections'!B16","v":0},null,{"$f":"'1 Volume Projections'!B17","v":0},null,{"$f":"'1 Volume Projections'!B18","v":0},null,{"$f":"'1 Volume Projections'!B19","v":0},null,{"$f":"'1 Volume Projections'!B20","v":0},null,{"$f":"'1 Volume Projections'!B21","v":0},null,{"$f":"'1 Volume Projections'!B22","v":0},null,{"$f":"'1 Volume Projections'!B23","v":0},null,{"$f":"'1 Volume Projections'!B24","v":0},null,{"$f":"'1 Volume Projections'!B25","v":0},null,{"$f":"'1 Volume Projections'!B26","v":0},null,{"$f":"'1 Volume Projections'!B27","v":0},null,{"$f":"'1 Volume Projections'!B28","v":0},null,{"$f":"'1 Volume Projections'!B29","v":0},null,{"$f":"'1 Volume Projections'!B30","v":0},null,{"$f":"'1 Volume Projections'!B31","v":0},null,{"$f":"'1 Volume Projections'!B32","v":0},null,{"$f":"'1 Volume Projections'!B33","v":0},null,{"$f":"'1 Volume Projections'!B34","v":0},null,{"$f":"'1 Volume Projections'!B35","v":0},null,{"$f":"'1 Volume Projections'!B36","v":0},null,{"$f":"'1 Volume Projections'!B37","v":0},null,{"$f":"'1 Volume Projections'!B38","v":0},null,{"$f":"'1 Volume Projections'!B39","v":0}]
["Equipment Description","Source of funds for Purchase","Serial #","Location","ID (Tag) #","Acquisition Date","Purchase Price","Accum. Depr.**","Useful Life","Annual Depr.**","Service #1 ","% of Usage","Service #2 ","% of Usage","Service #3 ","% of Usage","Service #4","% of Usage","Service #5","% of Usage","Service #6","% of Usage","Service #7","% of Usage","Service #8","% of Usage","Service #9","% of Usage","Service #10","% of Usage","Service #11","% of Usage","Service #12","% of Usage","Service #13","% of Usage","Service #14","% of Usage","Service #15","% of Usage","Service #16","% of Usage","Service #17","% of Usage","Service #18","% of Usage","Service #19","% of Usage","Service #20","% of Usage","Service #21","% of Usage","Service #22","% of Usage","Service #23","% of Usage","Service #24","% of Usage","Service #25","% of Usage","Check Total","Comments"]
["Example:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check Total Must Equal 100%"]
["Ultraviolet/Visible spectrophotometer",null,"ABC12345","00499999",888555,"2012-01-01",85000,15937.5,8,{"$f":"IF(G11-H11<G11/I11,G11-H11,G11/I11)","v":10625},{"$f":"J11*L11","v":10625},1,{"$f":"J11*N11","v":0},0,{"$f":"J11*P11","v":0},0,{"$f":"J11*R11","v":0},0,{"$f":"J11*T11","v":0},0,{"$f":"J11*V11","v":0},0,{"$f":"J11*X11","v":0},0,{"$f":"J11*Z11","v":0},0,{"$f":"J11*AB11","v":0},0,{"$f":"J11*AD11","v":0},0,{"$f":"J11*AF11","v":0},0,{"$f":"J11*AH11","v":0},0,{"$f":"J11*AJ11","v":0},0,{"$f":"J11*AL11","v":0},0,{"$f":"J11*AN11","v":0},0,{"$f":"J11*AP11","v":0},0,{"$f":"J11*AR11","v":0},0,{"$f":"J11*AT11","v":0},0,{"$f":"J11*AV11","v":0},0,{"$f":"J11*AX11","v":0},0,{"$f":"J11*AZ11","v":0},0,{"$f":"J11*BB11","v":0},0,{"$f":"J11*BD11","v":0},0,{"$f":"J11*BF11","v":0},0,{"$f":"J11*BH11","v":0},0,{"$f":"+L11+N11+P11+R11+T11+V11+X11+Z11+AB11+AD11+AF11+AH11+AJ11+AL11+AN11+AP11+AR11+AT11+AV11+AX11+AZ11+BB11+BD11+BF11+BH11","v":1}]
[null,null,null,null,null,null,null,null,1,0,{"$f":"$J12*L12","v":0},null,{"$f":"$J12*N12","v":0},null,{"$f":"$J12*P12","v":0},null,{"$f":"$J12*R12","v":0},null,{"$f":"$J12*T12","v":0},null,{"$f":"$J12*V12","v":0},null,{"$f":"$J12*X12","v":0},null,{"$f":"$J12*Z12","v":0},null,{"$f":"$J12*AB12","v":0},null,{"$f":"$J12*AD12","v":0},null,{"$f":"$J12*AF12","v":0},null,{"$f":"$J12*AH12","v":0},null,{"$f":"$J12*AJ12","v":0},null,{"$f":"$J12*AL12","v":0},null,{"$f":"$J12*AN12","v":0},null,{"$f":"$J12*AP12","v":0},null,{"$f":"$J12*AR12","v":0},null,{"$f":"$J12*AT12","v":0},null,{"$f":"$J12*AV12","v":0},null,{"$f":"$J12*AX12","v":0},null,{"$f":"$J12*AZ12","v":0},null,{"$f":"$J12*BB12","v":0},null,{"$f":"$J12*BD12","v":0},null,{"$f":"$J12*BF12","v":0},null,{"$f":"$J12*BH12","v":0},null,{"$f":"+L12+N12+P12+R12+T12+V12+X12+Z12+AB12+AD12+AF12+AH12+AJ12+AL12+AN12+AP12+AR12+AT12+AV12+AX12+AZ12+BB12+BD12+BF12+BH12","v":0}]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$J13*AJ13","v":0},null,{"$f":"$J13*AL13","v":0},null,{"$f":"$J13*AN13","v":0},null,{"$f":"$J13*AP13","v":0},null,{"$f":"$J13*AR13","v":0},null,{"$f":"$J13*AT13","v":0},null,{"$f":"$J13*AV13","v":0},null,{"$f":"$J13*AX13","v":0},null,{"$f":"$J13*AZ13","v":0},null,{"$f":"$J13*BB13","v":0},null,{"$f":"$J13*BD13","v":0},null,{"$f":"$J13*BF13","v":0},null,{"$f":"$J13*BH13","v":0},null,{"$f":"+L13+N13+P13+R13+T13+V13+X13+Z13+AB13+AD13+AF13+AH13+AJ13+AL13+AN13+AP13+AR13+AT13+AV13+AX13+AZ13+BB13+BD13+BF13+BH13","v":0}]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$J14*AJ14","v":0},null,{"$f":"$J14*AL14","v":0},null,{"$f":"$J14*AN14","v":0},null,{"$f":"$J14*AP14","v":0},null,{"$f":"$J14*AR14","v":0},null,{"$f":"$J14*AT14","v":0},null,{"$f":"$J14*AV14","v":0},null,{"$f":"$J14*AX14","v":0},null,{"$f":"$J14*AZ14","v":0},null,{"$f":"$J14*BB14","v":0},null,{"$f":"$J14*BD14","v":0},null,{"$f":"$J14*BF14","v":0},null,{"$f":"$J14*BH14","v":0},null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$J15*AJ15","v":0},null,{"$f":"$J15*AL15","v":0},null,{"$f":"$J15*AN15","v":0},null,{"$f":"$J15*AP15","v":0},null,{"$f":"$J15*AR15","v":0},null,{"$f":"$J15*AT15","v":0},null,{"$f":"$J15*AV15","v":0},null,{"$f":"$J15*AX15","v":0},null,{"$f":"$J15*AZ15","v":0},null,{"$f":"$J15*BB15","v":0},null,{"$f":"$J15*BD15","v":0},null,{"$f":"$J15*BF15","v":0},null,{"$f":"$J15*BH15","v":0},null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,1,0,{"$f":"$J20*L20","v":0},null,{"$f":"$J20*N20","v":0},null,0,null,{"$f":"$J20*R20","v":0},null,{"$f":"$J20*T20","v":0},null,{"$f":"$J20*V20","v":0},null,{"$f":"$J20*X20","v":0},null,{"$f":"$J20*Z20","v":0},null,{"$f":"$J20*AB20","v":0},null,{"$f":"$J20*AD20","v":0},null,{"$f":"$J20*AF20","v":0},null,{"$f":"$J20*AH20","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,1,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(J12:J21)","v":0},{"$f":"SUM(K12:K21)","v":0},null,{"$f":"SUM(M12:M21)","v":0},null,{"$f":"SUM(O12:O21)","v":0},null,{"$f":"SUM(Q12:Q21)","v":0},null,{"$f":"SUM(S12:S21)","v":0},null,{"$f":"SUM(U12:U21)","v":0},null,{"$f":"SUM(W12:W21)","v":0},null,{"$f":"SUM(Y12:Y21)","v":0},null,{"$f":"SUM(AA12:AA21)","v":0},null,{"$f":"SUM(AC12:AC21)","v":0},null,{"$f":"SUM(AE12:AE21)","v":0},null,{"$f":"SUM(AG12:AG21)","v":0},null,{"$f":"SUM(AI12:AI21)","v":0},null,{"$f":"SUM(AK12:AK21)","v":0},null,{"$f":"SUM(AM12:AM21)","v":0},null,{"$f":"SUM(AO12:AO21)","v":0},null,{"$f":"SUM(AQ12:AQ21)","v":0},null,{"$f":"SUM(AS12:AS21)","v":0},null,{"$f":"SUM(AU12:AU21)","v":0},null,{"$f":"SUM(AW12:AW21)","v":0},null,{"$f":"SUM(AY12:AY21)","v":0},null,{"$f":"SUM(BA12:BA21)","v":0},null,{"$f":"SUM(BC12:BC21)","v":0},null,{"$f":"SUM(BE12:BE21)","v":0},null,{"$f":"SUM(BG12:BG21)","v":0}]

{"sheet":"4 Admin Overhead Expenses","index":6,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,9],[43,0,43,1]]}
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Administrative Overhead Expenses"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
["Description of Service of Supply","Annual Salary","Effort %"," Effort Amount   ","Fringe Benefit Rate %","Fringe Benefits Amount","Less:  University Subsidy","Other/Non-Salary","Total","Comments"]
["Example:"]
["Administrative Staff",50000,1,{"$f":"+B10*C10","v":50000},0.28000000000000003,{"$f":"+D10*E10","v":14000.000000000002},-40000,null,{"$f":"SUM(D10:H10)","v":24000.28}]
["General Office Supplies",null,null,null,null,null,null,500,{"$f":"SUM(D11:H11)","v":500}]
[null,null,null,{"$f":"+B12*C12","v":0},null,{"$f":"+D12*E12","v":0},null,null,{"$f":"+D12+F12+G12+H12","v":0}]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,{"$f":"+B17*C17","v":0},null,{"$f":"+D17*E17","v":0},null,null,0]
[null,null,null,0,null,0,null,null,{"$f":"+D18+F18+G18+H18","v":0}]
[null,null,null,0,null,0,null,null,0]
[null,null,null,{"$f":"+B20*C20","v":0},null,0,null,null,0]
[null,null,null,{"$f":"+B21*C21","v":0},null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,null,null,0,null,0,null,null,0]
[null,{"$f":"SUM(B12:B35)","v":0},null,{"$f":"SUM(D12:D35)","v":0},null,{"$f":"SUM(F12:F35)","v":0},{"$f":"SUM(G12:G35)","v":0},{"$f":"SUM(H12:H35)","v":0},{"$f":"SUM(I12:I35)","v":0}]
[]
[]
["Notes:"]
["Fringe Benefits are calculated based on the approved federal rate."]
["Input the rate % from the below listed federal rates if the rate is other than the one listed."]
["The approved Federal Fringe Benefit Rates are as follows:"]
[]
["FY26 Fringe Rate/ Benefit Tiers"]
[0,0.46]
[40000,0.39]
[70000,0.31]
[150000,0.26]
[230000,0.2]
[500000,0.13]

{"sheet":"6 Expense Summary","index":7,"n_rows":38,"n_cols":35,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,1,25],[2,0,2,25],[3,0,3,25],[8,30,9,30],[8,31,9,31],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,3,8,5],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,17,9,17],[8,16,9,16],[8,32,9,32],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,18,9,18],[8,19,9,19],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12]]}
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Summary of Expenses and Calculation of Rate"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
[null,null,null,null,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","Service 21","Service 22","Service 23","Service 24","Service 25"]
["Allowable Costs:",null,null,"EXAMPLE",null,null,null,null,{"$f":"'1 Volume Projections'!B15","v":0},{"$f":"'1 Volume Projections'!B16","v":0},{"$f":"'1 Volume Projections'!B17","v":0},{"$f":"'1 Volume Projections'!B18","v":0},{"$f":"'1 Volume Projections'!B19","v":0},{"$f":"'1 Volume Projections'!B20","v":0},{"$f":"'1 Volume Projections'!B21","v":0},{"$f":"'1 Volume Projections'!B22","v":0},{"$f":"'1 Volume Projections'!B23","v":0},{"$f":"'1 Volume Projections'!B24","v":0},{"$f":"'1 Volume Projections'!B25","v":0},{"$f":"'1 Volume Projections'!B26","v":0},{"$f":"'1 Volume Projections'!B27","v":0},{"$f":"'1 Volume Projections'!B28","v":0},{"$f":"'1 Volume Projections'!B29","v":0},{"$f":"'1 Volume Projections'!B30","v":0},{"$f":"'1 Volume Projections'!B31","v":0},{"$f":"'1 Volume Projections'!B32","v":0},{"$f":"'1 Volume Projections'!B33","v":0},{"$f":"'1 Volume Projections'!B34","v":0},{"$f":"'1 Volume Projections'!B35","v":0},{"$f":"'1 Volume Projections'!B36","v":0},{"$f":"'1 Volume Projections'!B37","v":0},{"$f":"'1 Volume Projections'!B38","v":0},{"$f":"'1 Volume Projections'!B39","v":0}]
[null,null,null,"Service #1","Service #2","Total",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,"Total"]
[]
["Salary and Wage Expenses (From Salary and Wage Worksheet)",null,null,{"$f":"SUM('2 Salary & Fringe'!J11)","v":32160},{"$f":"SUM('2 Salary & Fringe'!L11)","v":32160},{"$f":"SUM(D12:E12)","v":64320},"a",null,{"$f":"SUM('2 Salary & Fringe'!J30)","v":0},{"$f":"SUM('2 Salary & Fringe'!L30)","v":0},{"$f":"SUM('2 Salary & Fringe'!N30)","v":0},{"$f":"SUM('2 Salary & Fringe'!P30)","v":0},{"$f":"SUM('2 Salary & Fringe'!R30)","v":0},{"$f":"SUM('2 Salary & Fringe'!T30)","v":0},{"$f":"SUM('2 Salary & Fringe'!V30)","v":0},{"$f":"SUM('2 Salary & Fringe'!X30)","v":0},{"$f":"SUM('2 Salary & Fringe'!Z30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AB30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AD30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AF30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AH30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AJ30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AL30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AN30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AP30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AR30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AT30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AV30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AX30)","v":0},{"$f":"SUM('2 Salary & Fringe'!AZ30)","v":0},{"$f":"SUM('2 Salary & Fringe'!BB30)","v":0},{"$f":"SUM('2 Salary & Fringe'!BD30)","v":0},{"$f":"SUM('2 Salary & Fringe'!BF30)","v":0},null,{"$f":"SUM(I12:AG12)","v":0}]
[]
["Other Expenses (From Other Expenses Worksheet)",null,null,{"$f":"SUM('3 Other Direct Expenses'!C12:C13)","v":5600},{"$f":"SUM('3 Other Direct Expenses'!E12:E13)","v":600},{"$f":"SUM(D14:E14)","v":6200},"b",null,{"$f":"SUM('3 Other Direct Expenses'!C51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!E51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!G51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!I51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!K51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!M51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!O51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!Q51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!S51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!U51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!W51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!Y51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AA51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AC51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AE51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AG51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AI51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AK51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AM51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AO51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AQ51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AS51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AU51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AW51)","v":0},{"$f":"SUM('3 Other Direct Expenses'!AY51)","v":0},null,{"$f":"SUM(I14:AG14)","v":0}]
[]
["Depreciation* (From Equipment Depreciation Worksheet)",null,null,{"$f":"SUM('5 Equipment Depreciation'!K11)","v":10625},{"$f":"SUM('5 Equipment Depreciation'!M11)","v":0},{"$f":"SUM(D16:E16)","v":10625},"c",null,{"$f":"SUM('5 Equipment Depreciation'!K22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!M22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!O22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!Q22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!S22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!U22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!W22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!Y22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AA22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AC22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AE22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AG22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AI22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AK22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AM22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AO22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AQ22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AS22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AU22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AW22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!AY22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!BA22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!BC22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!BE22)","v":0},{"$f":"SUM('5 Equipment Depreciation'!BG22)","v":0},null,{"$f":"SUM(I16:AG16)","v":0}]
[]
["Total Direct Operating Costs",null,null,{"$f":"SUM(D12:D17)","v":48385},{"$f":"SUM(E12:E17)","v":32760},{"$f":"SUM(D18:E18)","v":81145},"d = a + b + c",null,{"$f":"SUM(I12:I16)","v":0},{"$f":"SUM(J12:J16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AI12:AI17)","v":0}]
["Total Direct Operating Costs / NO depreciation",null,null,null,null,null,"d2 = a + b",null,{"$f":"SUM(I12:I14)","v":0},{"$f":"SUM(J12:J14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AI12:AI14)","v":0}]
[]
["Admin Overhead Expenses (From Admin Overhead Exps Worksheet)",null,null,null,null,{"$f":"SUM('4 Admin Overhead Expenses'!I10:I11)","v":24500.28},"e",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,{"$f":"SUM('4 Admin Overhead Expenses'!I36)","v":0}]
["Prior Year Deficit (Surplus) Adjustment",null,null,null,null,1000,"f",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,0]
[]
["Total Allowable Overhead",null,null,null,null,{"$f":"SUM(F21:F22)","v":25500.28},"g = e + f",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,{"$f":"SUM(AI21:AI23)","v":0}]
["% of Allowable Overhead to Total Direct Operating Costs",null,null,null,null,{"$f":"F24/SUM(F18)","v":0.31425571507794686},"h = g / d",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,{"$f":"IF(AI24<>0,AI24/SUM(AI18),0)","v":0}]
["% of Allowable Overhead to Total Direct Operating Costs/ ND",null,null,null,null,{"$f":"F25/SUM(F19)","v":{"$error":"#DIV/0!"}},"h = g / d2",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,{"$f":"IF(AI24<>0,AI24/SUM(AI19),0)","v":0}]
[]
["Administrative Overhead Allocation",null,null,{"$f":"D18*$F$25","v":15205.26277404646},{"$f":"E18*$F$25","v":10295.017225953539},{"$f":"SUM(D28:E28)","v":25500.28},"i = d x h",null,{"$f":"I18*$AI$25","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"T18*$AI$25","v":0},0,0,0,0,{"$f":"Y18*$AI$25","v":0},0,0,0,0,{"$f":"AD18*$AI$25","v":0},0,0,0,null,{"$f":"SUM(I28:AG28)","v":0}]
["Administrative Overhead Allocation/ND",null,null,{"$f":"D19*$F$25","v":0},{"$f":"E19*$F$25","v":0},{"$f":"SUM(D29:E29)","v":0},"i2 = d2 x h2",null,{"$f":"I19*$AI$26","v":0},{"$f":"J19*$AI$26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(I29:AG29)","v":0}]
[]
["Total Allowable Costs",null,null,{"$f":"SUM(D18,D28)","v":63590.26277404646},43055.017225953539,106645.28,"j = d + i ",null,{"$f":"SUM(I18,I28)","v":0},{"$f":"SUM(J18,J28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(T18,T28)","v":0},0,0,0,0,{"$f":"SUM(Y18,Y28)","v":0},0,0,0,0,{"$f":"SUM(AD18,AD28)","v":0},0,0,0,null,{"$f":"SUM(AI18,AI28)","v":0}]
["Total Allowable Costs/ND",null,null,0,0,0,"j2 = d2 + i2 ",null,{"$f":"SUM(I19,I29)","v":0},{"$f":"SUM(J19,J29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Volume Projections of Good or Service:"]
["Total Number of Units Per Year (From Volume Projections Worksheet)",null,null,{"$f":"SUM('1 Volume Projections'!D13)","v":305},{"$f":"SUM('1 Volume Projections'!D14)","v":30},null,"k",null,{"$f":"+'1 Volume Projections'!D15","v":0},{"$f":"+'1 Volume Projections'!D16","v":0},{"$f":"+'1 Volume Projections'!D17","v":0},{"$f":"+'1 Volume Projections'!D18","v":0},{"$f":"+'1 Volume Projections'!D19","v":0},{"$f":"+'1 Volume Projections'!D20","v":0},{"$f":"+'1 Volume Projections'!D21","v":0},{"$f":"+'1 Volume Projections'!D22","v":0},{"$f":"+'1 Volume Projections'!D23","v":0},{"$f":"+'1 Volume Projections'!D24","v":0},{"$f":"+'1 Volume Projections'!D25","v":0},{"$f":"+'1 Volume Projections'!D26","v":0},{"$f":"+'1 Volume Projections'!D27","v":0},{"$f":"+'1 Volume Projections'!D28","v":0},{"$f":"+'1 Volume Projections'!D29","v":0},{"$f":"+'1 Volume Projections'!D30","v":0},{"$f":"+'1 Volume Projections'!D31","v":0},{"$f":"+'1 Volume Projections'!D32","v":0},{"$f":"+'1 Volume Projections'!D33","v":0},{"$f":"+'1 Volume Projections'!D34","v":0},{"$f":"+'1 Volume Projections'!D35","v":0},{"$f":"+'1 Volume Projections'!D36","v":0},{"$f":"+'1 Volume Projections'!D37","v":0},{"$f":"+'1 Volume Projections'!D38","v":0},{"$f":"+'1 Volume Projections'!D39","v":0}]
[]
["Cost Per Unit:",null,null,{"$f":"D31/D35","v":208.4926648329392},{"$f":"E31/E35","v":1435.1672408651179},null,"l = j / k",null,{"$f":"ROUND(IF(I31>0,I31/I35,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(IF(T31>0,T31/T35,0),0)","v":0},0,0,0,0,{"$f":"ROUND(IF(Y31>0,Y31/Y35,0),0)","v":0},0,0,0,0,{"$f":"ROUND(IF(AD31>0,AD31/AD35,0),0)","v":0},0,0,0]
["Cost Per Unit:/ No Depreciation",null,null,{"$f":"D32/D36","v":{"$error":"#DIV/0!"}},{"$f":"E32/E36","v":{"$error":"#DIV/0!"}},null,"l2 = j2 / k2",null,{"$f":"ROUND(IF(I32>0,I32/I35,0),0)","v":0},{"$f":"ROUND(IF(J32>0,J32/J35,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"7 Proposed Rate(s)","index":8,"n_rows":37,"n_cols":30,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,26,7,26],[6,27,7,27],[6,28,7,28],[6,29,7,29],[6,21,7,21],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,25,7,25],[6,16,7,16],[6,17,7,17],[6,18,7,18],[6,19,7,19],[6,20,7,20],[6,15,7,15],[1,0,1,14],[2,0,2,14],[3,0,3,14],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,14,7,14],[6,2,6,3],[6,5,7,5],[6,6,7,6],[6,13,7,13],[6,7,7,7],[6,8,7,8],[6,9,7,9]]}
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Summary of Proposed Rate(s)"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
[null,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","Service #21","Service #22","Service #23","Service #24","Service #25"]
[null,null,"EXAMPLE",null,null,{"$f":"'1 Volume Projections'!B15","v":0},{"$f":"'1 Volume Projections'!B16","v":0},{"$f":"'1 Volume Projections'!B17","v":0},{"$f":"'1 Volume Projections'!B18","v":0},{"$f":"'1 Volume Projections'!B19","v":0},{"$f":"'1 Volume Projections'!B20","v":0},{"$f":"'1 Volume Projections'!B21","v":0},{"$f":"'1 Volume Projections'!B22","v":0},{"$f":"'1 Volume Projections'!B23","v":0},{"$f":"'1 Volume Projections'!B24","v":0},{"$f":"'1 Volume Projections'!B25","v":0},{"$f":"'1 Volume Projections'!C25","v":0},{"$f":"'1 Volume Projections'!D25","v":0},{"$f":"'1 Volume Projections'!E25","v":0},{"$f":"'1 Volume Projections'!F25","v":0},{"$f":"'1 Volume Projections'!G25","v":0},{"$f":"'1 Volume Projections'!H25","v":0},{"$f":"'1 Volume Projections'!I25","v":0},{"$f":"'1 Volume Projections'!J25","v":0},{"$f":"'1 Volume Projections'!K25","v":0},{"$f":"'1 Volume Projections'!L25","v":0},{"$f":"'1 Volume Projections'!M25","v":0},{"$f":"'1 Volume Projections'!N25","v":0},{"$f":"'1 Volume Projections'!O25","v":0},{"$f":"'1 Volume Projections'!P25","v":0}]
[null,null,"Service #1","Service #2"]
[]
["Recommended/Calculated Cost Per Unit: (From Expense Summary)",null,{"$f":"SUM('6 Expense Summary'!D$37)","v":208.4926648329392},{"$f":"SUM('6 Expense Summary'!E$37)","v":1435.1672408651179},null,{"$f":"SUM('6 Expense Summary'!I$37)","v":0},{"$f":"SUM('6 Expense Summary'!J$37)","v":0},{"$f":"SUM('6 Expense Summary'!K$37)","v":0},{"$f":"SUM('6 Expense Summary'!L$37)","v":0},{"$f":"SUM('6 Expense Summary'!M$37)","v":0},{"$f":"SUM('6 Expense Summary'!N$37)","v":0},{"$f":"SUM('6 Expense Summary'!O$37)","v":0},{"$f":"SUM('6 Expense Summary'!P$37)","v":0},{"$f":"SUM('6 Expense Summary'!Q$37)","v":0},{"$f":"SUM('6 Expense Summary'!R$37)","v":0},{"$f":"SUM('6 Expense Summary'!S$37)","v":0},{"$f":"SUM('6 Expense Summary'!T$37)","v":0},{"$f":"SUM('6 Expense Summary'!U$37)","v":0},{"$f":"SUM('6 Expense Summary'!V$37)","v":0},{"$f":"SUM('6 Expense Summary'!W$37)","v":0},{"$f":"SUM('6 Expense Summary'!X$37)","v":0},{"$f":"SUM('6 Expense Summary'!Y$37)","v":0},{"$f":"SUM('6 Expense Summary'!Z$37)","v":0},{"$f":"SUM('6 Expense Summary'!AA$37)","v":0},{"$f":"SUM('6 Expense Summary'!AB$37)","v":0},{"$f":"SUM('6 Expense Summary'!AC$37)","v":0},{"$f":"SUM('6 Expense Summary'!AD$37)","v":0},{"$f":"SUM('6 Expense Summary'!AE$37)","v":0},{"$f":"SUM('6 Expense Summary'!AF$37)","v":0},{"$f":"SUM('6 Expense Summary'!AG$37)","v":0}]
["Calculated Cost per unit (minus equipment depreciation): ",null,null,null,null,{"$f":"SUM('6 Expense Summary'!I$38)","v":0},{"$f":"SUM('6 Expense Summary'!J$38)","v":0},{"$f":"SUM('6 Expense Summary'!K$38)","v":0},{"$f":"SUM('6 Expense Summary'!L$38)","v":0},{"$f":"SUM('6 Expense Summary'!M$38)","v":0},{"$f":"SUM('6 Expense Summary'!N$38)","v":0},{"$f":"SUM('6 Expense Summary'!O$38)","v":0},{"$f":"SUM('6 Expense Summary'!P$38)","v":0},{"$f":"SUM('6 Expense Summary'!Q$38)","v":0},{"$f":"SUM('6 Expense Summary'!R$38)","v":0},{"$f":"SUM('6 Expense Summary'!S$38)","v":0},{"$f":"SUM('6 Expense Summary'!T$38)","v":0},{"$f":"SUM('6 Expense Summary'!U$38)","v":0},{"$f":"SUM('6 Expense Summary'!V$38)","v":0},{"$f":"SUM('6 Expense Summary'!W$38)","v":0},{"$f":"SUM('6 Expense Summary'!X$38)","v":0},{"$f":"SUM('6 Expense Summary'!Y$38)","v":0},{"$f":"SUM('6 Expense Summary'!Z$38)","v":0},{"$f":"SUM('6 Expense Summary'!AA$38)","v":0},{"$f":"SUM('6 Expense Summary'!AB$38)","v":0},{"$f":"SUM('6 Expense Summary'!AC$38)","v":0},{"$f":"SUM('6 Expense Summary'!AD$38)","v":0},{"$f":"SUM('6 Expense Summary'!AE$38)","v":0},{"$f":"SUM('6 Expense Summary'!AF$38)","v":0},{"$f":"SUM('6 Expense Summary'!AG$38)","v":0}]
["Charge Per Unit: (Please enter unit price)"]
[]
[]
["Proposed Rate(s):"]
["Internal:",null,{"$f":"ROUND(C10,0)","v":208},{"$f":"ROUND(D10,0)","v":1435},null,{"$f":"ROUND(F12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["UT System/ In Network",null,{"$f":"ROUND(#REF!*1.625,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*1.625,0)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(F16*1,0)","v":0},{"$f":"ROUND(G16*1,0)","v":0},0,0,0,0,0,0,0,{"$f":"ROUND(O16*1,0)","v":0},{"$f":"ROUND(P16*1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["* internal rate per MOU"]
[]
["External - Non-Profit:",null,{"$f":"ROUND(C16*1.625,0)","v":338},{"$f":"ROUND(D16*1.625,0)","v":2332},null,{"$f":"F16+F24","v":0},{"$f":"G16+G24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["* recommended increase of 30% for non-profit exernal to help recover F&A"]
["F&A",0.3,{"$f":"C$16*0.625","v":130},{"$f":"D$16*0.625","v":896.875},null,{"$f":"IF(F$26>0,F$16*$B$24,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["External - For-Profit:",null,100,0,null,{"$f":"F16*(1+$B$28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["*internal rate plus applicable Indirect Cost rate up to market (see below)"]
["F&A",0.54,null,null,null,{"$f":"IF(F$26>0,F$16*$B$28,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C$26>0,C$16*0.625,0)","v":130},{"$f":"IF(D$26>0,D$16*0.625,0)","v":0}]
[]
[]
[]
[]
[]
[null,null,"07/01/11–06/30/15"]
[null,null,0.72]
[null,null,0.34]

{"sheet":"8 Revenue Summary","index":9,"n_rows":33,"n_cols":31,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,30],[7,1,7,3],[2,0,2,30],[3,0,3,30]]}
[]
[]
[{"$f":"'1 Volume Projections'!B1","v":"00:00:00"}]
["Summary of Projected Revenues"]
[{"$f":"'2 Salary & Fringe'!A3:BI3","v":"Fiscal Year 2026"}]
[]
[null,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","Service #21","Service #22","Service #23","Service #24","Service #25"]
[null,"EXAMPLE",null,null,null,{"$f":"'1 Volume Projections'!B15","v":0},{"$f":"'1 Volume Projections'!B16","v":0},{"$f":"'1 Volume Projections'!B17","v":0},{"$f":"'1 Volume Projections'!B18","v":0},{"$f":"'1 Volume Projections'!B19","v":0},{"$f":"'1 Volume Projections'!B20","v":0},{"$f":"'1 Volume Projections'!B21","v":0},{"$f":"'1 Volume Projections'!B22","v":0},{"$f":"'1 Volume Projections'!B23","v":0},{"$f":"'1 Volume Projections'!B24","v":0},{"$f":"'1 Volume Projections'!B25","v":0},{"$f":"'1 Volume Projections'!B26","v":0},{"$f":"'1 Volume Projections'!B27","v":0},{"$f":"'1 Volume Projections'!B28","v":0},{"$f":"'1 Volume Projections'!B29","v":0},{"$f":"'1 Volume Projections'!B30","v":0},{"$f":"'1 Volume Projections'!B31","v":0},{"$f":"'1 Volume Projections'!B32","v":0},{"$f":"'1 Volume Projections'!B33","v":0},{"$f":"'1 Volume Projections'!B34","v":0},{"$f":"'1 Volume Projections'!B35","v":0},{"$f":"'1 Volume Projections'!B36","v":0},{"$f":"'1 Volume Projections'!B37","v":0},{"$f":"'1 Volume Projections'!B38","v":0},{"$f":"'1 Volume Projections'!B39","v":0},"Totals"]
["Requested Rate(s)"]
["Internal (From Proposed Rate(s) Worksheet)",{"$f":"SUM('7 Proposed Rate(s)'!C$16)","v":208},{"$f":"SUM('7 Proposed Rate(s)'!D$16)","v":1435},null,null,{"$f":"SUM('7 Proposed Rate(s)'!F$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!G$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!H$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!I$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!J$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!K$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!L$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!M$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!N$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!O$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!P$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Q$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!R$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!S$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!T$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!U$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!V$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!W$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!X$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Y$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Z$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AA$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AB$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AC$16)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AD$16)","v":0},{"$f":"SUM(F10:AD10)","v":0}]
["UT System/ In Network (From Proposed Rate(s) Worksheet)",null,null,null,null,{"$f":"SUM('7 Proposed Rate(s)'!F$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!G$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!H$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!I$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!J$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!K$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!L$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!M$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!N$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!O$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!P$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Q$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!R$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!S$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!T$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!U$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!V$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!W$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!X$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Y$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Z$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AA$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AB$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AC$19)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AD$19)","v":0},{"$f":"SUM(F11:AD11)","v":0}]
["External - Non-Profit (From Proposed Rate(s) Worksheet)",{"$f":"SUM('7 Proposed Rate(s)'!C$22)","v":338},{"$f":"SUM('7 Proposed Rate(s)'!D$22)","v":2332},null,null,{"$f":"SUM('7 Proposed Rate(s)'!F$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!G$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!H$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!I$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!J$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!K$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!L$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!M$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!N$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!O$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!P$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Q$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!R$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!S$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!T$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!U$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!V$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!W$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!X$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Y$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Z$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AA$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AB$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AC$22)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AD$22)","v":0},0]
["External - For-Profit (From Proposed Rate(s) Worksheet)",{"$f":"SUM('7 Proposed Rate(s)'!C$26)","v":100},{"$f":"SUM('7 Proposed Rate(s)'!D$26)","v":0},null,null,{"$f":"SUM('7 Proposed Rate(s)'!F$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!G$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!H$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!I$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!J$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!K$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!L$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!M$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!N$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!O$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!P$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Q$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!R$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!S$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!T$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!U$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!V$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!W$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!X$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Y$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!Z$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AA$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AB$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AC$26)","v":0},{"$f":"SUM('7 Proposed Rate(s)'!AD$26)","v":0},0]
[]
["Projected Volume:"]
["Internal (From Volume Projections Worksheet)",{"$f":"SUM('1 Volume Projections'!E13:F13)","v":300},{"$f":"SUM('1 Volume Projections'!E14:F14)","v":15},null,null,{"$f":"SUM('1 Volume Projections'!E15)","v":0},{"$f":"SUM('1 Volume Projections'!E16)","v":0},{"$f":"SUM('1 Volume Projections'!E17)","v":0},{"$f":"SUM('1 Volume Projections'!E18)","v":0},{"$f":"SUM('1 Volume Projections'!E19)","v":0},{"$f":"SUM('1 Volume Projections'!E20)","v":0},{"$f":"SUM('1 Volume Projections'!E21)","v":0},{"$f":"SUM('1 Volume Projections'!E22)","v":0},{"$f":"SUM('1 Volume Projections'!E23)","v":0},{"$f":"SUM('1 Volume Projections'!E24)","v":0},{"$f":"SUM('1 Volume Projections'!E25)","v":0},{"$f":"SUM('1 Volume Projections'!E26)","v":0},{"$f":"SUM('1 Volume Projections'!E27)","v":0},{"$f":"SUM('1 Volume Projections'!E28)","v":0},{"$f":"SUM('1 Volume Projections'!E29)","v":0},{"$f":"SUM('1 Volume Projections'!E30)","v":0},{"$f":"SUM('1 Volume Projections'!E31)","v":0},{"$f":"SUM('1 Volume Projections'!E32)","v":0},{"$f":"SUM('1 Volume Projections'!E33)","v":0},{"$f":"SUM('1 Volume Projections'!E34)","v":0},{"$f":"SUM('1 Volume Projections'!E35)","v":0},{"$f":"SUM('1 Volume Projections'!E36)","v":0},{"$f":"SUM('1 Volume Projections'!E37)","v":0},{"$f":"SUM('1 Volume Projections'!E38)","v":0},{"$f":"SUM('1 Volume Projections'!E39)","v":0},{"$f":"SUM(F16:AD16)","v":0}]
["UT System/ In Network (From Volume Projections Worksheet)",null,null,null,null,{"$f":"SUM('1 Volume Projections'!$F15)","v":0},{"$f":"SUM('1 Volume Projections'!$F16)","v":0},{"$f":"SUM('1 Volume Projections'!$F17)","v":0},{"$f":"SUM('1 Volume Projections'!$F18)","v":0},{"$f":"SUM('1 Volume Projections'!$F19)","v":0},{"$f":"SUM('1 Volume Projections'!$F20)","v":0},{"$f":"SUM('1 Volume Projections'!$F21)","v":0},{"$f":"SUM('1 Volume Projections'!$F22)","v":0},{"$f":"SUM('1 Volume Projections'!$F23)","v":0},{"$f":"SUM('1 Volume Projections'!$F24)","v":0},{"$f":"SUM('1 Volume Projections'!$F25)","v":0},{"$f":"SUM('1 Volume Projections'!$F26)","v":0},{"$f":"SUM('1 Volume Projections'!$F27)","v":0},{"$f":"SUM('1 Volume Projections'!$F28)","v":0},{"$f":"SUM('1 Volume Projections'!$F29)","v":0},{"$f":"SUM('1 Volume Projections'!$F30)","v":0},{"$f":"SUM('1 Volume Projections'!$F31)","v":0},{"$f":"SUM('1 Volume Projections'!$F32)","v":0},{"$f":"SUM('1 Volume Projections'!$F33)","v":0},{"$f":"SUM('1 Volume Projections'!$F34)","v":0},{"$f":"SUM('1 Volume Projections'!$F35)","v":0},{"$f":"SUM('1 Volume Projections'!$F36)","v":0},{"$f":"SUM('1 Volume Projections'!$F37)","v":0},{"$f":"SUM('1 Volume Projections'!$F38)","v":0},{"$f":"SUM('1 Volume Projections'!$F39)","v":0},{"$f":"SUM(F17:AD17)","v":0}]
["External - Non-Profit (From Volume Projections Worksheet)",{"$f":"SUM('1 Volume Projections'!G13:G13)","v":0},{"$f":"SUM('1 Volume Projections'!G14:G14)","v":15},null,null,{"$f":"SUM('1 Volume Projections'!G15)","v":0},{"$f":"SUM('1 Volume Projections'!G16)","v":0},{"$f":"SUM('1 Volume Projections'!G17)","v":0},{"$f":"SUM('1 Volume Projections'!G18)","v":0},{"$f":"SUM('1 Volume Projections'!G19)","v":0},{"$f":"SUM('1 Volume Projections'!G20)","v":0},{"$f":"SUM('1 Volume Projections'!G21)","v":0},{"$f":"SUM('1 Volume Projections'!G22)","v":0},{"$f":"SUM('1 Volume Projections'!G23)","v":0},{"$f":"SUM('1 Volume Projections'!G24)","v":0},{"$f":"SUM('1 Volume Projections'!G25)","v":0},{"$f":"SUM('1 Volume Projections'!G26)","v":0},{"$f":"SUM('1 Volume Projections'!G27)","v":0},{"$f":"SUM('1 Volume Projections'!G28)","v":0},{"$f":"SUM('1 Volume Projections'!G29)","v":0},{"$f":"SUM('1 Volume Projections'!G30)","v":0},{"$f":"SUM('1 Volume Projections'!G31)","v":0},{"$f":"SUM('1 Volume Projections'!G32)","v":0},{"$f":"SUM('1 Volume Projections'!G33)","v":0},{"$f":"SUM('1 Volume Projections'!G34)","v":0},{"$f":"SUM('1 Volume Projections'!G35)","v":0},{"$f":"SUM('1 Volume Projections'!G36)","v":0},{"$f":"SUM('1 Volume Projections'!G37)","v":0},{"$f":"SUM('1 Volume Projections'!G38)","v":0},{"$f":"SUM('1 Volume Projections'!G39)","v":0},0]
["External - For-Profit (From Volume Projections Worksheet)",{"$f":"SUM('1 Volume Projections'!H13)","v":5},{"$f":"SUM('1 Volume Projections'!H14)","v":0},null,null,{"$f":"SUM('1 Volume Projections'!H15)","v":0},{"$f":"SUM('1 Volume Projections'!H16)","v":0},{"$f":"SUM('1 Volume Projections'!H17)","v":0},{"$f":"SUM('1 Volume Projections'!H18)","v":0},{"$f":"SUM('1 Volume Projections'!H19)","v":0},{"$f":"SUM('1 Volume Projections'!H20)","v":0},{"$f":"SUM('1 Volume Projections'!H21)","v":0},{"$f":"SUM('1 Volume Projections'!H22)","v":0},{"$f":"SUM('1 Volume Projections'!H23)","v":0},{"$f":"SUM('1 Volume Projections'!H24)","v":0},{"$f":"SUM('1 Volume Projections'!H25)","v":0},{"$f":"SUM('1 Volume Projections'!H26)","v":0},{"$f":"SUM('1 Volume Projections'!H27)","v":0},{"$f":"SUM('1 Volume Projections'!H28)","v":0},{"$f":"SUM('1 Volume Projections'!H29)","v":0},{"$f":"SUM('1 Volume Projections'!H30)","v":0},{"$f":"SUM('1 Volume Projections'!H31)","v":0},{"$f":"SUM('1 Volume Projections'!H32)","v":0},{"$f":"SUM('1 Volume Projections'!H33)","v":0},{"$f":"SUM('1 Volume Projections'!H34)","v":0},{"$f":"SUM('1 Volume Projections'!H35)","v":0},{"$f":"SUM('1 Volume Projections'!H36)","v":0},{"$f":"SUM('1 Volume Projections'!H37)","v":0},{"$f":"SUM('1 Volume Projections'!H38)","v":0},{"$f":"SUM('1 Volume Projections'!H39)","v":0},0]
[]
["Total Projected Volume",{"$f":"SUM(B14:B20)","v":305},{"$f":"SUM(C14:C20)","v":30},null,null,{"$f":"SUM(F16:F20)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q16:Q20)","v":0},0,0,0,0,{"$f":"SUM(V16:V20)","v":0},0,0,0,0,{"$f":"SUM(AA16:AA20)","v":0},0,0,0,{"$f":"SUM(F21:AD21)","v":0}]
[]
["Projected Revenue:"]
["Internal",{"$f":"B10*B16","v":62400},{"$f":"C10*C16","v":21525},null,null,{"$f":"F10*F16","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q10*Q16","v":0},0,0,0,0,{"$f":"V10*V16","v":0},0,0,0,0,{"$f":"AA10*AA16","v":0},0,0,0,{"$f":"SUM(F24:AD24)","v":0}]
["UT System/ In Network (From Proposed Rate(s) Worksheet)",null,null,null,null,{"$f":"F11*F17","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q11*Q17","v":0},0,0,0,0,{"$f":"V11*V17","v":0},0,0,0,0,{"$f":"AA11*AA17","v":0},0,0,0,{"$f":"SUM(F25:AD25)","v":0}]
["External - Non-Profit (From Proposed Rate(s) Worksheet)",{"$f":"B12*B18","v":0},{"$f":"C12*C18","v":34980},null,null,{"$f":"F12*F18","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q12*Q18","v":0},0,0,0,0,{"$f":"V12*V18","v":0},0,0,0,0,{"$f":"AA12*AA18","v":0},0,0,0,0]
["External - For-Profit (From Proposed Rate(s) Worksheet)",{"$f":"B13*B19","v":500},{"$f":"C13*C19","v":0},null,null,{"$f":"F13*F19","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q13*Q19","v":0},0,0,0,0,{"$f":"V13*V19","v":0},0,0,0,0,{"$f":"AA13*AA19","v":0},0,0,0,0]
[]
["Total Projected Revenue",{"$f":"SUM(B24:B28)","v":62900},{"$f":"SUM(C24:C28)","v":56505},{"$f":"SUM(B29:C29)","v":119405},null,{"$f":"SUM(F24:F28)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q24:Q28)","v":0},0,0,0,0,{"$f":"SUM(V24:V28)","v":0},0,0,0,0,{"$f":"SUM(AA24:AA28)","v":0},0,0,0,0]
[]
[]
["check total (service center operating & equipment revenue less operating expenses)",{"$f":"SUM(#REF!)-'6 Expense Summary'!D31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!E31","v":{"$error":"#REF!"}},{"$f":"SUM(B32:C32)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)-'6 Expense Summary'!I31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!J31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!K31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!L31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!M31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!N31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!O31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!P31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!Q31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!R31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AH31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AI31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AJ31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AK31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AL31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AM31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AN31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AO31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AP31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AQ31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AR31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AS31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AT31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AU31","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-'6 Expense Summary'!AV31","v":{"$error":"#REF!"}},{"$f":"SUM(F32:O32)","v":{"$error":"#REF!"}}]
["* goal is to be balanced to $0, however minimal differences allowed for rounding of fees"]

{"sheet":"9 Five Year Projection","index":10,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[2,0,2,6],[1,0,1,6],[0,0,0,6],[69,0,69,1]]}
["UTHealth"]
[" Service Center 5 Year Projection"]
[{"$f":"'1 Volume Projections'!B1","v":0}]
[]
["Please enter data in the blue highlighted cells"]
["Do not fill. These are automatically populated or protected."]
[]
["Start Date (MM/DD/YY):","2025-09-01"]
["Months In Service During Year 1:",12]
["Inflation Factor:",0.03]
["Start-Up Lag (% of total expected volume in Year 1):",1]
[]
["REVENUE","FY 2026 Total","FY 2026 Lagged","FY 2027","FY 2028","FY 2029","FY 2030"]
["Services:"]
[{"$f":"'8 Revenue Summary'!F8:F8","v":0},{"$f":"'8 Revenue Summary'!F29","v":0},{"$f":"(B15*$B$11)*$B$9/12","v":0},{"$f":"+B15*(1+$B$10)","v":0},{"$f":"+D15*(1+$B$10)","v":0},0,0]
[{"$f":"'8 Revenue Summary'!G8","v":0},{"$f":"'8 Revenue Summary'!G29","v":0},{"$f":"(B16*$B$11)*$B$9/12","v":0},0,0,0,0]
[{"$f":"'8 Revenue Summary'!H8","v":0},{"$f":"'8 Revenue Summary'!H29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!I8","v":0},{"$f":"'8 Revenue Summary'!I29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!J8","v":0},{"$f":"'8 Revenue Summary'!J29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!K8","v":0},{"$f":"'8 Revenue Summary'!K29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!L8","v":0},{"$f":"'8 Revenue Summary'!L29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!M8","v":0},{"$f":"'8 Revenue Summary'!M29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!N8","v":0},{"$f":"'8 Revenue Summary'!N29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!O8","v":0},{"$f":"'8 Revenue Summary'!O29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!P8","v":0},{"$f":"'8 Revenue Summary'!P29","v":0},{"$f":"(B25*$B$11)*$B$9/12","v":0},{"$f":"+B25*(1+$B$10)","v":0},{"$f":"+D25*(1+$B$10)","v":0},{"$f":"+E25*(1+$B$10)","v":0},{"$f":"+F25*(1+$B$10)","v":0}]
[{"$f":"'8 Revenue Summary'!Q8","v":0},{"$f":"'8 Revenue Summary'!Q29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!R8","v":0},{"$f":"'8 Revenue Summary'!R29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!S8","v":0},{"$f":"'8 Revenue Summary'!S29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!T8","v":0},{"$f":"'8 Revenue Summary'!T29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!U8","v":0},{"$f":"'8 Revenue Summary'!U29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!V8","v":0},{"$f":"'8 Revenue Summary'!V29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!W8","v":0},{"$f":"'8 Revenue Summary'!W29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!X8","v":0},{"$f":"'8 Revenue Summary'!X29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!Y8","v":0},{"$f":"'8 Revenue Summary'!Y29","v":0},{"$f":"(B34*$B$11)*$B$9/12","v":0},{"$f":"+B34*(1+$B$10)","v":0},{"$f":"+D34*(1+$B$10)","v":0},{"$f":"+E34*(1+$B$10)","v":0},{"$f":"+F34*(1+$B$10)","v":0}]
[{"$f":"'8 Revenue Summary'!Z8","v":0},{"$f":"'8 Revenue Summary'!Z29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!AA8","v":0},{"$f":"'8 Revenue Summary'!AA29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!AB8","v":0},{"$f":"'8 Revenue Summary'!AB29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!AC8","v":0},{"$f":"'8 Revenue Summary'!AC29","v":0},0,0,0,0,0]
[{"$f":"'8 Revenue Summary'!AD8","v":0},{"$f":"'8 Revenue Summary'!AD29","v":0},{"$f":"(B39*$B$11)*$B$9/12","v":0},{"$f":"+B39*(1+$B$10)","v":0},{"$f":"+D39*(1+$B$10)","v":0},{"$f":"+E39*(1+$B$10)","v":0},{"$f":"+F39*(1+$B$10)","v":0}]
["TOTAL REVENUE",{"$f":"SUM(B15:B39)","v":0},{"$f":"SUM(C15:C39)","v":0},0,0,0,0]
[]
["EXPENSES","FY 2026 Total","FY 2026 Lagged","FY 2027","FY 2028","FY 2029","FY 2030"]
["Salaries & Fringe:"]
[{"$f":"'2 Salary & Fringe'!A12","v":0},{"$f":"'2 Salary & Fringe'!I12","v":0},{"$f":"(B44)*$B$9/12","v":0},{"$f":"+B44*(1+$B$10)","v":0},{"$f":"+D44*(1+$B$10)","v":0},0,0]
[{"$f":"'2 Salary & Fringe'!A13","v":0},{"$f":"'2 Salary & Fringe'!I13","v":0},0,{"$f":"+B45*(1+$B$10)","v":0},0,0,0]
[{"$f":"'2 Salary & Fringe'!A14","v":0},{"$f":"'2 Salary & Fringe'!I14","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A15","v":0},{"$f":"'2 Salary & Fringe'!I15","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A16","v":0},{"$f":"'2 Salary & Fringe'!I16","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A17","v":0},{"$f":"'2 Salary & Fringe'!I17","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A18","v":0},{"$f":"'2 Salary & Fringe'!I18","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A19","v":0},{"$f":"'2 Salary & Fringe'!I19","v":0},0,0,0,0,0]
[{"$f":"'2 Salary & Fringe'!A20","v":0},{"$f":"'2 Salary & Fringe'!I20","v":0},0,0,0,0,0]
["Sub-Total Salaries & Fringe Benefits",{"$f":"SUM(B44:B52)","v":0},0,0,0,0,0]
[]
["Non-Salary Costs:"]
["Other Direct Costs",{"$f":"'3 Other Direct Expenses'!B51","v":0},{"$f":"(B56*$B$11)*$B$9/12","v":0},{"$f":"+B56*(1+$B$10)","v":0},{"$f":"+D56*(1+$B$10)","v":0},0,0]
["Admin Overhead Expense",{"$f":"'4 Admin Overhead Expenses'!I36","v":0},{"$f":"(B57*$B$11)*$B$9/12","v":0},{"$f":"+B57*(1+$B$10)","v":0},0,0,0]
[]
["Sub-Total Non-Salary Costs",{"$f":"SUM(B56:B58)","v":0},0,0,0,0,0]
[]
["TOTAL EXPENSES",{"$f":"B53+B59","v":0},0,0,0,0,0]
[]
["Projected Yearly Surplus/(Deficit)",{"$f":"B40-B61","v":0},0,0,0,0,0]
[]
["Subsidy If Any?: Please describe the source of the subsidy below.",null,{"$f":"-C63","v":0},{"$f":"-D63","v":0},0,0,0]
[]
["Accumulated Surplus/(Deficit)",{"$f":"'6 Expense Summary'!AI22","v":0},{"$f":"+C63+C65+B67","v":0},{"$f":"+D63+C67+D65","v":0},{"$f":"+E63+D67+E65","v":0},0,0]
[]
[]
["Subsidy Detail (Source, Amount, Duration)"]
["SOURCE: "]
["AMOUNT: "]
["DURATION:"]
["DESCRIPTION: "]