{"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":95,"n_cols":17,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[5,0,5,1],[5,2,5,4],[20,0,20,2],[94,0,94,15],[95,0,103,15],[37,0,37,15],[11,0,11,1],[11,3,11,4],[46,0,46,15],[50,0,50,2],[51,0,51,2],[52,0,52,2],[54,0,54,15],[34,0,34,2],[33,0,33,2],[32,0,32,2],[31,0,31,2],[25,0,25,2],[22,0,22,2],[24,0,24,2],[16,11,18,11],[16,13,18,13],[16,15,18,15],[16,4,18,4],[16,6,18,6],[16,8,18,8],[6,14,6,15],[5,12,5,13],[5,14,5,15],[8,12,8,15],[8,10,8,11],[13,0,13,1],[13,3,13,4],[14,1,14,4],[12,1,12,4],[9,0,9,1],[9,2,9,4],[6,0,6,1],[6,2,6,4],[7,0,7,1],[7,2,7,4],[78,12,78,13],[77,12,77,13],[76,12,76,13],[75,12,75,13],[74,12,74,13],[73,12,73,13],[84,0,84,2],[79,12,79,13],[6,10,6,11],[6,12,6,13],[27,0,27,2],[28,0,28,2],[30,0,30,2],[45,0,45,2],[44,0,44,2],[43,0,43,2],[42,0,42,2],[39,0,39,2],[41,0,41,2],[57,4,58,8],[55,0,55,15],[16,0,18,2],[48,0,48,2],[19,0,19,2],[89,5,89,7],[90,5,90,7],[3,0,3,15],[81,0,81,2],[83,0,83,2],[89,8,89,9],[60,12,60,13],[84,11,84,13],[57,2,59,2],[57,1,59,1],[57,0,59,0],[57,11,59,15],[66,12,66,13],[65,12,65,13],[64,12,64,13],[63,12,63,13],[62,12,62,13],[61,12,61,13],[72,12,72,13],[71,12,71,13],[70,12,70,13],[69,12,69,13],[68,12,68,13],[67,12,67,13],[92,6,92,9],[91,0,92,5],[9,10,9,11],[10,10,10,11],[9,12,9,15],[10,12,10,15],[90,12,90,13],[89,14,89,15],[90,14,90,15],[86,0,86,15],[91,14,91,15],[92,14,92,15],[91,12,91,13],[92,12,92,13],[91,8,91,9],[88,10,88,11],[82,1,82,2],[82,11,82,13],[88,12,88,15],[89,12,89,13],[88,2,90,4],[88,0,88,1],[88,5,88,9],[90,8,90,9]]}
["Grant Rebudget Form: New Child Account Request"]
["To be prepared by the Department and submitted alongside the Transaction Request Form via Workday Questionairre to request new child account[s] for existing active awards."]
["Enter Existing Cumulative Budget for the Grant # in the Yellow Cells and enter requested changes in the Pink Cells. Orange Cells are Formulas, and Blue Categories are excluded from MDTC. "]
["Current Budget should match what is entered in Workday as of the date prepared. "]
[]
["PI:",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,null,"Obligation Period:",null,"00:00:00",null,"00:00:00"]
["RA Log#:"]
[null,null,null,null,null,null,null,null,null,null,"Rebudget Request Date:",null,"1900-01-01"]
["Sponsor Award #:",null,null,null,null,null,null,null,null,null,"Indirect Cost Rate:",null,0.6]
[null,null,null,null,null,null,null,null,null,null,"Indirect Cost Basis: "]
["Workday Award #:",null,"AWD"]
[null,"(Formerly G #)",null,null,null,null,null,null,null,null,"Child Account PI:"]
["Workday Grant #:",null,"GR",null,null,null,null,null,null,null,"Child Account PI NUID:"]
[null,"(Formerly Fund/Index #; also called \"Award Lines\")",null,null,null,null,null,null,null,null,"Child Account Cost Center:"]
[]
["Workday Object Codes",null,null,null,"Parent Grant # Current Budget",null,"Parent Grant # Changes",null,"New Parent Grant # Budget",null,null,"New Child Account 1",null,"New Child Account 2",null,"New Child Account 3"]
[]
[]
["Salary",null,null,null,0,null,0,null,{"$f":"E20+G20","v":0},null,"Salary",0,null,0,null,0]
["Fringe ",null,null,null,0,null,0,null,{"$f":"E21+G21","v":0},null,"Fringe",0,null,0,null,0]
[]
["Fellowships & Stipends",null,null,null,0,null,0,null,{"$f":"E23+G23","v":0},null,"Fellowships & Stipends ",0,null,0,null,0]
[]
["Materials & Supplies",null,null,null,0,null,0,null,{"$f":"E25+G25","v":0},null,"Materials & Supploes ",0,null,0,null,0]
["Lab Recharge Fees",null,null,null,0,null,0,null,{"$f":"E26+G26","v":0},null,"Lab Recharge Fees",0,null,0,null,0]
[]
["Domestic Travel",null,null,null,0,null,0,null,{"$f":"E28+G28","v":0},null,"Domestic Travel ",0,null,0,null,0]
["Foreign Travel",null,null,null,0,null,0,null,{"$f":"E29+G29","v":0},null,"Foreign Travel",0,null,0,null,0]
[]
["Consultants",null,null,null,0,null,0,null,{"$f":"+E31+G31","v":0},null,"Consultants",0,null,0,null,0]
["Subject Payments",null,null,null,0,null,0,null,{"$f":"E32+G32","v":0},null,"Subject Payments ",0,null,0,null,0]
["Animal Care Costs",null,null,null,0,null,0,null,{"$f":"E33+G33","v":0},null,"Animal Care Costs ",0,null,0,null,0]
["Tutition and Fees",null,null,null,0,null,0,null,{"$f":"E34+G34","v":0},null,"Tuition and Fees",0,null,0,null,0]
["Capital Equipment",null,null,null,0,null,0,null,{"$f":"E35+G35","v":0},null,"Capital Equipment",0,null,0,null,0]
[]
["Participant Support Costs",null,null,null,0,null,0,null,{"$f":"E37+G37","v":0},null,"Participant Support Costs",0,null,0,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,0,null,0,null,{"$f":"E40+G40","v":0},null,"Other Direct Costs",0,null,0,null,0]
[]
["Infrequently-Used Object Codes",null,null,null,0,null,0,null,{"$f":"E42+G42","v":0},null,null,0,null,0,null,0]
["Capital Space Buildout & Renovations",null,null,null,0,null,0,null,{"$f":"E43+G43","v":0},null,"Cap. Space Buildout ",0,null,0,null,0]
["Space Rental",null,null,null,0,null,0,null,{"$f":"E44+G44","v":0},null,"Space Rental",0,null,0,null,0]
["Child Care",null,null,null,0,null,0,null,{"$f":"E45+G45","v":0},null,"Child Care",0,null,0,null,0]
["Other Institutional Costs",null,null,null,0,null,0,null,{"$f":"E46+G46","v":0},null,"Other Inst. Costs",0,null,0,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,0,null,0,null,{"$f":"E49+G49","v":0},null,"F&A Costs",0,null,0,null,0]
[]
["Total Direct Cost",null,null,null,{"$f":"+E20+E21+E23+E25+E26+E28+E29+E31+E32+E33+E34+E35+E37+E40+E42+E43+E44+E45+E46","v":0},null,{"$f":"+G20+G21+G23+G25+G26+G28+G29+G31+G32+G33+G34+G35+G37+G40+G42+G43+G44+G45+G46","v":0},null,{"$f":"+I20+I21+I23+I25+I26+I28+I29+I31+I32+I33+I34+I35+I37+I40+I42+I43+I44+I45+I46","v":0},null,"Total Direct Cost",{"$f":"+L20+L21+L23+L25+L26+L28+L29+L31+L32+L33+L34+L35+L37+L40+L42+L43+L44+L45+L46","v":0},null,{"$f":"+N20+N21+N23+N25+N26+N28+N29+N31+N32+N33+N34+N35+N37+N40+N42+N43+N44+N45+N46","v":0},null,{"$f":"+P20+P21+P23+P25+P26+P28+P29+P31+P32+P33+P34+P35+P37+P40+P42+P43+P44+P45+P46","v":0}]
["Modified Total Direct Cost (MTDC)",null,null,null,{"$f":"E51-E46-E44-E43-E42-E37-E34-E35","v":0},null,{"$f":"G51-G46-G44-G43-G42-G37-G34-G35","v":0},null,{"$f":"I51-I46-I44-I43-I42-I37-I34-I35","v":0},null,"MTDC",{"$f":"L51-L46-L44-L43-L42-L37-L34-L35","v":0},null,{"$f":"N51-N46-N44-N43-N42-N37-N34-N35","v":0},null,{"$f":"P51-P46-P44-P43-P42-P37-P34-P35","v":0}]
["Total Cost",null,null,null,{"$f":"+E51+E49","v":0},null,{"$f":"+G51+G49","v":0},null,{"$f":"+I51+I49","v":0},null,"Total Cost ",{"$f":"+L51+L49","v":0},null,{"$f":"+N51+N49","v":0},null,{"$f":"+P51+P49","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. "]
["If there are not enough rows for each of your Subrecipients, copy and paste additional Subrecipients and F&A Costs rows. "]
[]
[null,"Name of Subrecipient","GR#",null,"Use this section to update amounts on existing Subrecipient Grants",null,null,null,null,null,null,"Use this section for adding new Subrecipient Grants "]
[]
[null,null,null,null,"Current",null,"Changes",null,"New"]
["Subrecipent",null,null,null,0,{"$f":"IF(E61>=25000,25000,E61)","v":0},null,{"$f":"IF(G61>=25000,25000,G61)","v":0},{"$f":"E61+G61","v":0},{"$f":"IF(I61>=25000,25000,I61)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P61>=25000,25000,P61)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E63>=25000,25000,E63)","v":0},0,{"$f":"IF($G63>=25000,25000,$G63)","v":0},0,{"$f":"IF(I63>=25000,25000,I63)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P63>=25000,25000,P63)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E65>=25000,25000,E65)","v":0},0,{"$f":"IF($G65>=25000,25000,$G65)","v":0},0,{"$f":"IF(I65>=25000,25000,I65)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P65>=25000,25000,P65)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E67>=25000,25000,E67)","v":0},0,{"$f":"IF(G67>=25000,25000,G67)","v":0},0,{"$f":"IF(I67>=25000,25000,I67)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P67>=25000,25000,P67)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E69>=25000,25000,E69)","v":0},0,{"$f":"IF(G69>=25000,25000,G69)","v":0},0,{"$f":"IF(I69>=25000,25000,I69)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P69>=25000,25000,P69)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,0,{"$f":"IF(E71>=25000,25000,E71)","v":0},0,{"$f":"IF(G71>=25000,25000,G71)","v":0},0,{"$f":"IF(I71>=25000,25000,I71)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P71>=25000,25000,P71)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
["Subrecipent",null,null,null,null,{"$f":"IF(E73>=25000,25000,E73)","v":0},0,{"$f":"IF(G73>=25000,25000,G73)","v":0},0,{"$f":"IF(I73>=25000,25000,I73)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P73>=25000,25000,P73)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,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},0,{"$f":"IF(G75>=25000,25000,G75)","v":0},0,{"$f":"IF(I75>=25000,25000,I75)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P75>=25000,25000,P75)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,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},0,{"$f":"IF(G77>=25000,25000,G77)","v":0},0,{"$f":"IF(I77>=25000,25000,I77)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P77>=25000,25000,P77)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,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},0,{"$f":"IF(G79>=25000,25000,G79)","v":0},0,{"$f":"IF(I79>=25000,25000,I79)","v":0},null,"Subrecipent",null,null,null,0,{"$f":"IF(P79>=25000,25000,P79)","v":0}]
["F&A Costs","NU IDC on the above Sub",null,null,0,null,0,null,0,null,null,"F&A Costs","NU IDC on the above Sub",null,null,0]
[]
["Total Subrecipient Expense",null,null,null,{"$f":"+E61+E63+E65+E67+E69+E71+E73+E75+E77+E79","v":0},null,{"$f":"+G61+G63+G65+G67+G69+G71+G73+G75+G77+G79","v":0},null,{"$f":"+I61+I63+I65+I67+I69+I71+I73+I75+I77+I79","v":0},null,null,null,null,"Total New Subrecipient Expense",null,{"$f":"+P61+P63+P65+P67+P69+P71+P73+P75+P77+P79","v":0}]
[null,"Total Subrecipient MTDC Portion",null,null,{"$f":"+F61+F63+F65+F67+F69+F71+F73+F75+F77+F79","v":0},null,{"$f":"+H61+H63+H65+H67+H69+H71+H73+H75+H77+H79","v":0},null,{"$f":"+J61+J63+J65+J67+J69+J71+J73+J75+J77+J79","v":0},null,null,"Total Subrecipient MTDC Portion",null,null,null,{"$f":"+Q61+Q63+Q65+Q67+Q69+Q71+Q73+Q75+Q77+Q79","v":0}]
["Total Subrecipient F&A",null,null,null,{"$f":"+E62+E64+E66+E68+E70+E72+E74+E76+E78+E80","v":0},null,{"$f":"+G62+G64+G66+G68+G70+G72+G74+G76+G78+G80","v":0},null,{"$f":"+I62+I64+I66+I68+I70+I72+I74+I76+I78+I80","v":0},null,null,null,null,"Total New Subrecipient F&A",null,{"$f":"+P62+P64+P66+P68+P70+P72+P74+P76+P78+P80","v":0}]
["Total Subrecipients & Subrecipient F&A",null,null,null,{"$f":"SUM(E61:E80)","v":0},null,{"$f":"SUM(G61:G80)","v":0},null,{"$f":"SUM(I61:I80)","v":0},null,null,"Total New Subrecipients & Subrecipient F&A",null,null,null,{"$f":"SUM(P61:P80)","v":0}]
[]
["Grand Totals "]
[]
["Total Award Amount ",null,"The before and after of the Total Award Amount should match if there is no change in funding. ",null,null,"Total F&A on Grant & Subrecipient Grants ",null,null,null,null,"Total Direct Costs on Grant & Subrecipient Grants",null,"Total MTDC on Grant & Subrecipient Grants"]
["Current",{"$f":"+E85+E53","v":0},null,null,null,"Current",null,null,{"$f":"+E49+E84","v":0},null,"Current",{"$f":"E51+E82","v":0},"Current",null,{"$f":"E52+E83","v":0}]
["After New Child Changes ",{"$f":"+I85+I53+L53+N53+P53+P85","v":0},null,null,null,"After New Child Changes ",null,null,{"$f":"+I49+L49+N49+P49+I84+P84","v":0},null,"After New Child Changes ",{"$f":"+I51+L51+N51+P51+I82+P82","v":0},"After New Child Changes ",null,{"$f":"+I52+L52+N52+P52+I83+P83","v":0}]
["IDC Calculation Check: ",null,null,null,null,null,null,null,"Current",null,"IDC as % of DC",{"$f":"I90/L90","v":{"$error":"#DIV/0!"}},"IDC as % of MTDC",null,{"$f":"I90/O90","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"After New Child Changes",null,null,null,"IDC as % of DC",{"$f":"I91/L91","v":{"$error":"#DIV/0!"}},"IDC as % of MTDC",null,{"$f":"I91/O91","v":{"$error":"#DIV/0!"}}]
[]
["Justification for New Child Account Request and Additional Comments:"]

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