{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Use Rate Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Use Rate Calculation","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[59,4,61,8]]}
["Calculations for Use Rate - Use most recent five years of data (or as many years as possible)"]
[]
[]
["Index:",null,null,null,"FY or Date",null,"FY or Date",null,"FY or Date",null,"FY or Date",null,"FY or Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[]
[null,null,"Beginning Balance",null,null,null,{"$f":"IF(G5<>\"\",E43,\"\")","v":""},null,{"$f":"IF(I5<>\"\",G43,\"\")","v":""},null,{"$f":"IF(K5<>\"\",I43,\"\")","v":""},null,{"$f":"IF(M5<>\"\",K43,\"\")","v":""}]
[]
["R111",null,"Revenue",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:M9)","v":0}]
[]
["E200R",null,"Use Credits – Facilities/Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:M11)","v":0}]
[]
[null,null,"Total Revenue",null,{"$f":"SUM(E9:E11)","v":0},null,{"$f":"IF(G5<>\"\",SUM(G9:G11),\"\")","v":""},null,{"$f":"IF(I5<>\"\",SUM(I9:I11),\"\")","v":""},null,{"$f":"IF(K5<>\"\",SUM(K9:K11),\"\")","v":""},null,{"$f":"IF(M5<>\"\",SUM(M9:M11),\"\")","v":""},null,{"$f":"SUM(E13:M13)","v":0}]
[]
["TXXXX",null,"Transfers In",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:M15)","v":0}]
[]
["P006",null,"Administrative & Professional S&W",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:M17)","v":0}]
[]
["P007",null,"Technical S&W",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:M19)","v":0}]
[]
["P501",null,"Graduate Students S&W",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:M21)","v":0}]
[]
["P601",null,"Undergraduate Students S&W",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:M23)","v":0}]
[]
["P008",null,"AFSCME S&W",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:M25)","v":0}]
[]
["B000",null,"Fringe Benefits",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:M27)","v":0}]
[]
["E200",null,"Services",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:M29)","v":0}]
[]
["E300, E600",null,"Supplies",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:M31)","v":0}]
[]
["E700",null,"Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:M33)","v":0}]
[]
["XXXX",null,"Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:M35)","v":0}]
[]
[null,null,"Total Expenses",null,{"$f":"SUM(E17:E35)","v":0},null,{"$f":"IF(G5<>\"\",SUM(G17:G35),\"\")","v":""},null,{"$f":"IF(I5<>\"\",SUM(I17:I35),\"\")","v":""},null,{"$f":"IF(K5<>\"\",SUM(K17:K35),\"\")","v":""},null,{"$f":"IF(M5<>\"\",SUM(M17:M35),\"\")","v":""},null,{"$f":"SUM(E37:M37)","v":0}]
[]
[null,null,"Ending Balance",null,{"$f":"E7+E13+E15-E37","v":0},null,{"$f":"IF(G5<>\"\",G7+G13+G15-G37,\"\")","v":""},null,{"$f":"IF(I5<>\"\",I7+I13+I15-I37,\"\")","v":""},null,{"$f":"IF(K5<>\"\",K7+K13+K15-K37,\"\")","v":""},null,{"$f":"IF(M5<>\"\",M7+M13+M15-M37,\"\")","v":""}]
[]
[null,null,"Total Encumbrances",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E41:M41)","v":0}]
[]
[null,null,"Carryforward Balance",null,{"$f":"E39+E41","v":0},null,{"$f":"IF(G39=\"\",\"\",G39+G41)","v":""},null,{"$f":"IF(I39=\"\",\"\",I39+I41)","v":""},null,{"$f":"IF(K39=\"\",\"\",K39+K41)","v":""},null,{"$f":"IF(M39=\"\",\"\",M39+M41)","v":""}]
[]
[null,null,"Number of Units",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E45:M45)","v":0}]
[]
[null,null,"Unit of Measurement"]
[]
[null,"Carryforward Balance",{"$f":"IF(G43=\"\",E43,IF(I43=\"\",G43,IF(K43=\"\",I43,IF(M43=\"\",K43,M43))))","v":0},null,null,null,null,null,null,"Total Expenses Less Encumbrances",{"$f":"O37-O41","v":0}]
[]
[null,"60 days Expenses",{"$f":"IF(COUNTIF(E45:M45,\">0\")=0,\"\",ROUND((O37-O41)/COUNTIF(E45:M45,\">0\")*60/365,2))","v":""},null,null,null,null,null,null,"Excess of Allowable Balance",{"$f":"C53","v":""}]
[null,null,{"$f":"ROUND(H37/2*60/365,0)","v":0}]
[null,"Excess of Allowable Balance",{"$f":"IF(C51=\"\",\"\",IF(C49<0,C49,IF(C49=0,0,IF(C49-C51<0,0,C49-C51))))","v":""},null,null,null,null,null,null,"Net Expenses",{"$f":"IF(K51=\"\",\"\",K49-K51)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Total Units",{"$f":"O45","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Calculated Rate",{"$f":"IF(O45<=0,0,ROUND(K53/K55,2))","v":0}]
[null,"Current Rate"]
[]
[null,"Calculated Rate",{"$f":"K57","v":0},null,{"$f":"IF(C60<0,\"You may not have a use rate as long as the calculated rate is negative.\",\"\")","v":""}]
[]
[null,"Chosen Rate"]