{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"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":"Sheet1","index":0,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[[66,14,66,16],[68,14,68,16],[84,1,85,11],[88,0,88,16],[95,0,95,16],[96,0,104,16],[63,14,63,16],[67,14,67,16],[69,14,69,16],[59,9,61,9],[18,14,48,16],[8,9,8,12],[9,9,9,12],[12,7,13,11],[14,14,16,16],[57,0,57,16],[59,2,61,2],[59,1,61,1],[59,0,61,0],[59,7,61,7],[62,14,62,16],[64,14,64,16],[18,0,20,2],[50,0,50,2],[21,0,21,2],[8,13,8,16],[9,13,9,16],[12,0,12,1],[12,3,12,4],[13,1,13,4],[11,1,11,4],[16,1,16,3],[18,11,20,11],[59,8,61,8],[0,0,0,16],[1,0,1,16],[4,0,4,1],[4,2,4,4],[22,0,22,2],[10,0,10,1],[10,3,10,4],[5,15,5,16],[4,13,4,14],[8,0,8,1],[8,2,8,4],[5,0,5,1],[5,2,5,4],[6,0,6,1],[6,2,6,4],[5,13,5,14],[2,0,2,16],[4,15,4,16],[5,9,5,12],[36,0,36,2],[35,0,35,2],[34,0,34,2],[33,0,33,2],[27,0,27,2],[24,0,24,2],[26,0,26,2],[18,7,20,7],[18,4,20,4],[32,0,32,2],[29,0,29,2],[30,0,30,2],[47,0,47,2],[46,0,46,2],[45,0,45,2],[44,0,44,2],[41,0,41,2],[43,0,43,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[65,14,65,16]]}
["Grant Setup Budget Form"]
["To be prepared by the Department for new Awards setups. Enter new obligation Budget for the Grant # in the Yellow Cells. Purple Cells are Formulas, and Blue Categories are excluded from MDTC. "]
["Budget Total should match the obligated award total. "]
[]
["PI:",null,null,null,null,null,null,null,null,null,null,null,null,"Start Date",null,"End Date"]
["Awarding Agency:",null,null,null,null,null,null,null,null,"Obligation Period:",null,null,null,"00:00:00",null,"1900-01-01"]
["RA Log#:"]
[]
["Sponsor Award #:",null,null,null,null,null,null,null,null,"Indirect Cost Rate:",null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,"Indirect Cost Basis: ",null,null,null,"MTDC"]
["Workday Award #:",null,"AWD"]
[null,"(Formerly G #)"]
["Workday Primary Grant #:",null,"GR",null,null,null,null,"Only fill out the Secondary and Tertiary Grant Sections if child accounts are required for Setup"]
[null,"(Formerly Fund/Index #; also called \"Award Lines\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If applicable, please add a justificaiton for the creation of mutilple Grant #s/Award Lines below: "]
[null,null,null,null,"Primary Grant",null,null,"Secondary Grant",null,null,null,"Tertiary Grant "]
[null,"Cost Center:",null,null,null,null,"CC: ",null,null,"CC:"]
[]
["Workday Object Codes",null,null,null,"Primary Grant #  Budget",null,null,"2nd Grant # Budget",null,null,null,"3rd Grant # Current Budget"]
[]
[]
["Salary",null,null,null,0,null,null,0,null,"Salary",null,0]
["Fringe ",null,null,null,0,null,null,0,null,"Fringe",null,0]
[]
["Fellowships & Stipends",null,null,null,0,null,null,0,null,"Fellowships & Stipends ",null,0]
[]
["Materials & Supplies",null,null,null,0,null,null,0,null,"Materials & Supploes ",null,0]
["Lab Recharge Fees",null,null,null,0,null,null,0,null,"Lab Recharge Fees",null,0]
[]
["Domestic Travel",null,null,null,0,null,null,0,null,"Domestic Travel ",null,0]
["Foreign Travel",null,null,null,0,null,null,0,null,"Foreign Travel",null,0]
[]
["Consultants",null,null,null,0,null,null,0,null,"Consultants",null,0]
["Subject Payments",null,null,null,0,null,null,0,null,"Subject Payments ",null,0]
["Animal Care Costs",null,null,null,0,null,null,0,null,"Animal Care Costs ",null,0]
["Tutition and Fees",null,null,null,0,null,null,0,null,"Tuition and Fees",null,0]
["Capital Equipment",null,null,null,0,null,null,0,null,"Capital Equipment",null,0]
[]
["Participant Support Costs",null,null,null,0,null,null,0,null,null,null,0]
["Participant Support Costs on Federal Grants require their own Child Account. If one already exists for this project, enter the Grant Number in the cell C37 above. "]
[]
["Other Direct Costs",null,null,null,null,null,null,0,null,"Other Direct Costs",null,0]
[]
["Infrequently-Used Object Codes",null,null,null,0,null,null,0,null,null,null,0]
["Capital Space Buildout & Renovations",null,null,null,null,null,null,0,null,"Cap. Space Buildout ",null,0]
["Space Rental",null,null,null,0,null,null,0,null,"Space Rental",null,0]
["Child Care",null,null,null,0,null,null,0,null,"Child Care",null,0]
["Other Institutional Costs",null,null,null,0,null,null,0,null,"Other Inst. Costs",null,0]
["Other Institutional Costs on a Grant Budget is primarily used for Deobligations and At-Risk Advance Accounts "]
[]
["F&A Costs",null,null,null,{"$f":"_xlfn.IFS($N$10=\"MTDC\",E55*N9,$N$10=\"DC\",E54*N9)","v":0},null,null,{"$f":"_xlfn.IFS($N$10=\"MTDC\",H55*Q9,$N$10=\"DC\",H54*Q9)","v":0},null,"F&A Costs",null,{"$f":"_xlfn.IFS($N$10=\"MTDC\",L55*U9,$N$10=\"DC\",L54*U9)","v":0}]
["Indirect Costs will calculate automatically based on what you have entered in the cells above labled Indirect Cost Rate and Indirect Cost Basis"]
[]
["Total Direct Cost",null,null,null,{"$f":"+E22+E23+E25+E27+E28+E30+E31+E33+E34+E35+E36+E37+E39+E42+E44+E45+E46+E47+E48","v":0},null,null,{"$f":"+H22+H23+H25+H27+H28+H30+H31+H33+H34+H35+H36+H37+H39+H42+H44+H45+H46+H47+H48","v":0},null,"Total Direct Cost",null,{"$f":"+L22+L23+L25+L27+L28+L30+L31+L33+L34+L35+L36+L37+L39+L42+L44+L45+L46+L47+L48","v":0}]
["Modified Total Direct Cost (MTDC)",null,null,null,{"$f":"E54-E48-E46-E45-E44-E39-E36-E37","v":0},null,null,{"$f":"H54-H48-H46-H45-H44-H39-H36-H37","v":0},null,"MTDC",null,{"$f":"L54-L48-L46-L45-L44-L39-L36-L37","v":0}]
["Total Cost",null,null,null,{"$f":"+E54+E51","v":0},null,null,{"$f":"+H54+H51","v":0},null,"Total Cost ",null,{"$f":"+L54+L51","v":0}]
[]
["Each subrecipient in Workday requires its own Child Account with the Indirect Costs that will be taken on the subreceipient expense. Under NU's current Indirect Cost Rate agreement, this will be on the first $25,000 of each subrecipient. The threshold will increase to $50,000 on new awards once the FY26 Indirect Cost Agreement has been fully executed.  Subrecipient MTDC portion formula below uses the $25k threshold. "]
[]
["#1 -10","Name of Subrecipient","GR#",null,null,null,null,"#11 -20","Name of Subrecipient","GR#"]
[]
[]
["Subrecipent",null,null,null,0,{"$f":"IF(E63>=25000,25000,E63)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L63>=25000,25000,L63)","v":0},null,"Total Subrecipient Expense"]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0,null,null,{"$f":"+E63+E65+E67+E69+E71+E73+E75+E77+E79+E81+L63+L65+L67+L69+L71+L73+L75+L77+L79+L81","v":0}]
["Subrecipent",null,null,null,0,{"$f":"IF(E65>=25000,25000,E65)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L65>=25000,25000,L65)","v":0},null,"Total Subrecipient MTDC Portion"]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0,null,null,{"$f":"+F63+F65+F67+F69+F71+F73+F75+F77+F79+F81+M63+M64+M65+M66+M67+M68+M69+M70+M71+M72+M73+M74+M75+M76+M77+M78+M79+M80+M81+M82","v":0}]
["Subrecipent",null,null,null,0,{"$f":"IF(E67>=25000,25000,E67)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L67>=25000,25000,L67)","v":0},null,"Total Subrecipient F&A"]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0,null,null,{"$f":"+E64+E66+E68+E70+E72+E74+E76+E78+E80+E82+L64+L66+L68+L70+L72+L74+L76+L78+L80+L82","v":0}]
["Subrecipent",null,null,null,0,{"$f":"IF(E69>=25000,25000,E69)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L69>=25000,25000,L69)","v":0},null,"Total Subrecipients & Subrecipient F&A"]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0,null,null,{"$f":"SUM(E63:E82,L63:L81)","v":0}]
["Subrecipent",null,null,null,0,{"$f":"IF(E71>=25000,25000,E71)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L71>=25000,25000,L71)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E73>=25000,25000,E73)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L73>=25000,25000,L73)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E75>=25000,25000,E75)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L75>=25000,25000,L75)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E77>=25000,25000,E77)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L77>=25000,25000,L77)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E79>=25000,25000,E79)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L79>=25000,25000,L79)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E81>=25000,25000,E81)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(L81>=25000,25000,L81)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
[]
[]
[null,"If the subrecipient is unable to have IDC charged against it (ex. we already awarded them over $25k in year 1), delete the formula in the cell to the right of the Subrecipient expenses, highlighted in in Plum. "]
[]
[]
[]
["Grand Totals "]
[]
[null,null,null,null,null,null,null,"Total of MTDC",{"$f":"D55+G55+K55+P66","v":0}]
[null,null,null,null,null,null,null,"Total of All Direct Costs",{"$f":"+P64+K54+G54+D54","v":0}]
[null,null,null,null,null,null,null,"Total of All Indirect (F&A) Costs",{"$f":"+P68+D51+G51+K51","v":0}]
[null,null,null,null,null,null,null,"Total of Award",{"$f":"+I93+I92","v":0}]
[]
["Notes/Comments "]

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