{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Detail Budget Page","Budget for Entire Period","Indirect Cost Calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":16,"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":"1904"}

{"sheet":"Detail Budget Page","index":0,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,7,3,8],[47,4,47,5],[2,0,3,5],[16,0,17,0],[4,4,5,4]]}
["FOR INTERNAL UCSD USE ONLY!",null,"PI NAME:",null,null,null,null,"UCSD # "]
[]
["           DETAILED BUDGET FOR INITIAL BUDGET PERIOD - DIRECT COSTS ONLY        ",null,null,null,null,null,"FROM        ","   THROUGH               "]
[null,null,null,null,null,null,"mm/dd/yy","mm/dd/yy"]
["PERSONNEL (UCSD personnel only)",null,null,null,"#  Emp. Ben. Rate",null,"  DOLLAR AMOUNT REQUESTED (omit cents)"]
["NAME","TITLE",null,null,null,null,"SALARY   REQUESTED","FRINGE    BENEFITS","                                                                                                                                                              TOTALS"]
[" ","Principal   Investigator",0,0,0,0,{"$f":"ROUND((F7*D7),0)","v":0},{"$f":"ROUND((E7*G7),0)","v":0},{"$f":"SUM(G7:H7)","v":0}]
[" ",null,0,0,0,0,{"$f":"ROUND((F8*D8),0)","v":0},0,0]
[null,null,0,0,0,0,{"$f":"ROUND((F9*D9),0)","v":0},{"$f":"ROUND((E9*G9),0)","v":0},{"$f":"SUM(G9:H9)","v":0}]
[" ",null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[" ",null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,{"$f":"SUM(G13:H13)","v":0}]
[null,null,0,0,0,0,0,0,{"$f":"SUM(G14:H14)","v":0}]
[" ",null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["## GSR Tuition Remission:","Rate 1","# mos.","Rate 1","# mos.","# GSRs"]
[null,0,0,0,0,0," ",{"$f":"((B18*C18) + (D18*E18))*F18","v":0},{"$f":"H18","v":0}]
[null,"SUBTOTALS",null,null,null,null,{"$f":"SUM(G7:G15)","v":0},{"$f":"SUM(H7:H18)","v":0},{"$f":"SUM(I7:I18)","v":0}]
["CONSULTANT COSTS - includes both fees and travel expense (if applicable)"]
[null,null,null,null,null,null,null,0,{"$f":"ROUND((H21),0)","v":0}]
["EQUIPMENT (Items with a unit value of $1500 or greater - items under $1500 each belong in the supply category)"]
[null,null,0,null,null,null,null,0]
[null,null,0,null,null,null,null,0]
[null,null,0,null,null,null,null,0]
[null,null,0,null,null,null,null,0,{"$f":"ROUND((SUM(C23:C26)+SUM(H23:H26)),0)","v":0}]
["SUPPLIES (Itemize by category, include one time equipment items under $1500 each)"]
["Annual Supply Budget",null,null,0]
["One-Time purchases (including equipment under $1500 ea) ",null,null,0]
["Animal Purchases:  Species ","# animals","Cost/each","Extension"]
[null,0,0,{"$f":"ROUND((A31*B31*C31),0)","v":0}]
[null,0,0,{"$f":"ROUND((A32*B32*C32),0)","v":0}]
[null,0,0,{"$f":"ROUND((A33*B33*C33),0)","v":0},null,null,null,null,{"$f":"ROUND(SUM(D28:D33),0)","v":0}]
["TRAVEL"]
[null,null,null,null,null,null,null,0,{"$f":"ROUND((H35),0)","v":0}]
[null,"INPATIENT",null,null,null,null,null,0,{"$f":"ROUND((H36),0)","v":0}]
[null,"OUTPATIENT",null,null,null,null,null,0,{"$f":"ROUND((H37),0)","v":0}]
["ALTERATIONS AND RENOVATIONS (Itemize by category)"]
[null,null,null,null,null,null,null,0,{"$f":"ROUND((H39),0)","v":0}]
["OTHER EXPENSES (Itemize by category)"]
["Annual Other Expense Costs",null,null,null,0]
["One-Time Other Expense",null,null,null,0]
["Animal Care:    Species ","Cost/Day","# animals","# of Days","Extension"]
[null,0,0,0,{"$f":"ROUND((B44*C44*D44),0)","v":0}]
[null,0,0,0,{"$f":"ROUND((B45*C45*D45),0)","v":0}," "]
[null,0,0,0,{"$f":"ROUND((B46*C46*D46),0)","v":0}," "]
["Space Rental: calculate cost based            ","Rate","# Sq FT","# of Mos","Extension",null,null,null," "]
["on $ per square feet per month",0,0,0,{"$f":"ROUND((B48*C48*D48),0)","v":0},null,null,null,{"$f":"ROUND(SUM(E41:E48),0)","v":0}]
["CONSORTIUM/CONTRACTUAL","DIRECT COSTS",null,null,null,null,null,null,0]
["SUBTOTAL DIRECT COSTS FOR INITIAL BUDGET PERIOD",null,null,null,null,null,null,"$    ",{"$f":"SUM(I19:I49)","v":0}]
["CONSORTIUM/CONTRACTUAL","INDIRECT COSTS",null,null,null,null,null,null,0]
["TOTAL DIRECT COSTS FOR INITIAL BUDGET PERIOD ",null,null,null,null,null,null,"$    ",{"$f":"SUM(I50:I51)","v":0}]
["MODULAR DIRECT COST (less Consortium F&A) - ROUNDED UP - See Next Worksheet",null,null,null,null,null,null,"$    ",{"$f":"'Budget for Entire Period'!$B$21","v":0}]

{"sheet":"Budget for Entire Period","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,6],[24,0,24,3],[28,0,28,6],[39,0,39,6],[22,0,22,6],[26,0,26,6],[35,0,35,1],[36,0,36,1]]}
["Modular Budget Estimator for Entire Proposed Project Period - FOR INTERNAL UCSD USE ONLY!"]
[]
[null,"Year 1"]
["A. Subotal Actual (Not Modular) Direct Costs for Initial"]
["    Budget Period, (less consortium F&A costs):",{"$f":"'Detail Budget Page'!$I$50","v":0}]
["B. Less Actual One-Time Expense If It Is Being "]
["   Requested via Additional $25,000 Modules In Year 1:",0]
[null,null,"Year 2 (+3%)","Year 3 (+3%)","Year 4 (+3%)","Year 5 (+3%)","All Years"]
["C. Net Direct Recurring Cost Each Year:",{"$f":"SUM(B5-B7)","v":0},{"$f":"SUM(B9*1.03)","v":0},{"$f":"SUM(C9*1.03)","v":0},{"$f":"SUM(D9*1.03)","v":0},{"$f":"SUM(E9*1.03)","v":0}]
[]
["D. Total Net Direct Recurring Costs All Years:",{"$f":"SUM(B9:F9)","v":0}]
[]
["Number of budget years:",5]
[]
["E. Average Budget Per Year:",{"$f":"SUM(B11/B13)","v":0}]
[]
["F. Round up to Nearest 25K Module:",{"$f":"CEILING(B15,25000)","v":0},{"$f":"CEILING(B15,25000)","v":0},{"$f":"CEILING(B15,25000)","v":0},{"$f":"CEILING(B15,25000)","v":0},{"$f":"CEILING(B15,25000)","v":0}]
["G. Add Back Modular Amount to Cover Item B Above, "]
["and Insert Any Additional Modules Needed in Later Years:",{"$f":"CEILING(B7,25000)","v":0},0,0,0,0]
[]
["H. Total Modular Direct Cost (less Consortium F&A) Per Year:",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},{"$f":"SUM(F17:F19)","v":0},{"$f":"SUM(B21:F21)","v":0}]
[]
["These calculations work for most situations.  However, use common sense in some rounding situations.  For example, if your average expenses are actually $135,000 dollars, rounded up to a $150,000 modular amount, then $27,000 for equipment in year one should be rounded DOWN to one $25,000 module, not rounded UP to $50,000. THE BUDGET MUST BE REASONABLE AND REALISTIC!"]
[]
["For Line C:  If the proposal is for less than 5 years, replace the formulas for the unused years with zeros."]
[]
["For Line G:  Additional modules can be added only for extrordianary costs such as large equipment purchases or major changes in research expenses, not for the normal escalation of costs."]
[]
["Consortium Costs"]
[]
[null,"Initial Period","2nd","3rd","4th","5th","Sum Total"]
["Consortium Direct Costs",{"$f":"'Detail Budget Page'!$I$49","v":0},0,0,0,0,{"$f":"SUM(B32:F32)","v":0}]
["Consortium F&A Costs",{"$f":"'Detail Budget Page'!$I$51","v":0},0,0,0,0,{"$f":"SUM(B33:F33)","v":0}]
["Total Consortium Costs",{"$f":"SUM(B32:B33)","v":0},0,0,0,0,0]
[]
["Number of years for Consortium",null,null,null,null,null,5]
["Consortium Annual Total Costs Rounded to the Nearest $1000",null,null,null,null,null,{"$f":"ROUND(G34/G36,-3)","v":0}]
[]
[]
["Figures for PHS 398 Modular Budget Justification Page"]
[]
[null,"Initial Period","2nd","3rd","4th","5th","Sum Total"]
["DC less Consortium F&A",{"$f":"B21","v":0},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"SUM(B43:F43)","v":0}]
["Consortium F&A",{"$f":"B33","v":0},{"$f":"C33","v":0},{"$f":"D33","v":0},{"$f":"E33","v":0},{"$f":"F33","v":0},{"$f":"SUM(B44:F44)","v":0}]
["Total Direct Costs",{"$f":"SUM(B43:B44)","v":0},0,0,0,0,0]

{"sheet":"Indirect Cost Calculation","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,4,7],[0,0,0,7],[24,0,24,7],[1,0,1,7]]}
["CALCULATION OF FACILITIES AND ADMINISTRATIVE COSTS (INDIRECT COSTS) FOR PROJECT PERIOD"]
["FOR INTERNAL UCSD USE ONLY!"]
[null,"Year 1","Year 2","Year 3","YEAR 4","YEAR 5",null,"TOTALS"]
["Total Direct Costs (includes Consortium F&A)",{"$f":"'Budget for Entire Period'!$B$45","v":0},{"$f":"'Budget for Entire Period'!$C$45","v":0},{"$f":"'Budget for Entire Period'!$D$45","v":0},{"$f":"'Budget for Entire Period'!$E$45","v":0},{"$f":"'Budget for Entire Period'!$F$45","v":0},null,{"$f":"SUM(B4:F4)","v":0}]
["F&A (IDC) Exclusions:"]
["Tuition Remission",0,0,0,0,0,null,{"$f":"SUM(B6:F6)","v":0}]
["Equipment",0,0,0,0,0,null,0]
["Patient Care",0,0,0,0,0,null,0]
["Alterations & Renovations",0,0,0,0,0,null,0]
["Rental of Space",0,0,0,0,0,null,0]
["Consortiums In Excess of $25000 *",0,0,0,0,0,null,0]
["F&A (IDC) Base",{"$f":"B4-(SUM(B5:B11))","v":0},{"$f":"C4-(SUM(C5:C11))","v":0},{"$f":"D4-(SUM(D5:D11))","v":0},{"$f":"E4-(SUM(E5:E11))","v":0},{"$f":"F4-(SUM(F5:F11))","v":0},null,0]
[]
["IDC Rate 1",0.54500000000000004,0.54500000000000004,0.54500000000000004,0.54500000000000004,0.54500000000000004]
["# of months at Rate 1",12,12,12,12,12]
["IDC Rate 2",0.54500000000000004,0.54500000000000004,0.54500000000000004,0.54500000000000004,0.54500000000000004]
["# of months at Rate 2",{"$f":"12-B15","v":0},{"$f":"12-C15","v":0},{"$f":"12-D15","v":0},{"$f":"12-E15","v":0},{"$f":"12-F15","v":0}]
["Base 1",{"$f":"ROUND(((B12/12)*B15),0)","v":0},{"$f":"ROUND(((C12/12)*C15),0)","v":0},{"$f":"ROUND(((D12/12)*D15),0)","v":0},{"$f":"ROUND(((E12/12)*E15),0)","v":0},{"$f":"ROUND(((F12/12)*F15),0)","v":0}]
["Base 2",{"$f":"B12-B18","v":0},{"$f":"C12-C18","v":0},{"$f":"D12-D18","v":0},{"$f":"E12-E18","v":0},{"$f":"F12-F18","v":0}]
[]
["F&A (IDC) Amount",{"$f":"ROUND((B18*B14),0) +ROUND((B19*B16),0)","v":0},{"$f":"ROUND((C18*C14),0) +ROUND((C19*C16),0)","v":0},{"$f":"ROUND((D18*D14),0) +ROUND((D19*D16),0)","v":0},{"$f":"ROUND((E18*E14),0) +ROUND((E19*E16),0)","v":0},{"$f":"ROUND((F18*F14),0) +ROUND((F19*F16),0)","v":0},null,{"$f":"SUM(B21:F21)","v":0}]
[]
["TOTAL COSTS",{"$f":"B4+B21","v":0},{"$f":"C4+C21","v":0},{"$f":"D4+D21","v":0},{"$f":"E4+E21","v":0},{"$f":"F4+F21","v":0},null,{"$f":"SUM(B23:F23)","v":0}]
[]
["* Consortiums:  F&A (IDC) costs are assessed on the first $25,000 per subcontract site for the entire project period, except for other UC campuses where the entire amount is excluded from the IDC base. "]