{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Guidance","Basic Budget Revision 24.08.28","BR -Payroll Detail 2024.08.28"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Guidance","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Basic Budget Revision 24.08.28","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[46,1,46,7],[0,3,0,5],[1,2,1,7],[2,2,2,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[4,6,4,7],[5,2,5,3],[7,2,7,3],[7,6,7,7],[53,1,53,7],[54,1,54,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7],[52,1,52,7]]}
[null,null,null,"BUDGET REVISION",null,null,null,{"$f":"NOW()","v":"2025-05-02T06:58:42.110"}]
[null,"Sponsor:"]
[null,"Principal Investigator:"]
[null,"Department:",null,null,null,"College:"]
[null,"Prepared By:",null,null,null,"Email:"]
[null,"Worktag:"]
[]
[null,"Start Date:",null,null,null,"End Date:"]
[]
[null,null,null,"Current Budget",null,"Budget Change",null,"Proposed Budget"]
[null,"Budget Category",null,{"$f":"C6","v":0},null,"DIFFERENCE",null,{"$f":"IF(D11=\"CCN\",\"Same CCN\",D11)","v":0}]
[]
[null,"01_Personnel",null,0,null,0,null,{"$f":"SUM(D13,F13)","v":0}]
[null,"03_Fringe Benefits",null,0,null,0,null,0]
[null,"08_Domestic Travel",null,0,null,0,null,0]
[null,"07_Foreign Travel",null,0,null,0,null,0]
[null,"10_Materials and Supplies",null,0,null,0,null,0]
[null,"17_Other Direct Costs",null,0,null,0,null,0]
[null,"12_Publication Costs",null,0,null,0,null,0]
[null,"13_Professional Services",null,0,null,0,null,0]
[null,"16_Fees",null,0,null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$K$36\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$l$36\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$m$36\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$n$36\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$o$36\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$p$36\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$q$36\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$r$36\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
["Other:",null,null,0,null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$K$37\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$l$37\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$m$37\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$n$37\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$o$37\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$p$37\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$q$37\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$r$37\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
["Other:",null,null,0,null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$K$38\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$l$38\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$m$38\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$n$38\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$o$38\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$p$38\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$q$38\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$r$38\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
[]
[]
["F&A Base Current:",{"$f":"SUM($D$13:$D$25)","v":0}]
["F&A Base Proposed:",{"$f":"SUM($H$13:$H$25)","v":0}]
[]
[null,"06_Tuition",null,0,null,0,null,{"$f":"SUM(D29,F29)","v":0}]
[null,"02_Participant Stipend",null,0,null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$K$62:$K$65\"))-INDIRECT(\"'\"&$L$17&\"'!$K$53\"),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$l$62:$l$65\"))-INDIRECT(\"'\"&$L$17&\"'!$L$53\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$m$62:$m$65\"))-INDIRECT(\"'\"&$L$17&\"'!$m$53\"),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$n$62:$n$65\"))-INDIRECT(\"'\"&$L$17&\"'!$n$53\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$o$62:$o$65\"))-INDIRECT(\"'\"&$L$17&\"'!$o$53\"),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$p$62:$p$65\"))-INDIRECT(\"'\"&$L$17&\"'!$p$53\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$q$62:$q$65\"))-INDIRECT(\"'\"&$L$17&\"'!$q$53\"),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$r$62:$r$65\"))-INDIRECT(\"'\"&$L$17&\"'!$r$53\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
[null,"05_Participant Support",null,0,null,0,null,0]
[null,"09_Equipment",null,0,null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$K$58\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$l$58\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$m$58\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$n$58\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$o$58\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$p$58\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$q$58\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$r$58\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
[null,"14_Rent",null,{"$f":"IF(OR(ISBLANK($L$5),$L$9=\"Manual entry\"),0,\nIF($L$9=\"Award\",IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$5&\"'!d32\"),INDIRECT(\"'\"&$L$5&\"'!f32\")),\nIF($L$9=\"Carryforward: Destination\",INDIRECT(\"'\"&$L$5&\"'!r32\"),INDIRECT(\"'\"&$L$5&\"'!h32\"))))","v":0},null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$K$59\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$l$59\"),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$m$59\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$n$59\"),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$o$59\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$p$59\"),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$17&\"'!$q$59\"),IF($L$12=\"Cost-Share\",INDIRECT(\"'\"&$L$17&\"'!$r$59\"),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
["Other:",null,null,{"$f":"IF(OR(ISBLANK($L$5),$L$9=\"Manual entry\"),0,\nIF($L$9=\"Award\",IF($L$12=\"Sponsor\",INDIRECT(\"'\"&$L$5&\"'!d33\"),INDIRECT(\"'\"&$L$5&\"'!f33\")),\nIF($L$9=\"Carryforward: Destination\",INDIRECT(\"'\"&$L$5&\"'!r33\"),INDIRECT(\"'\"&$L$5&\"'!h33\"))))","v":0},null,{"$f":"IF(ISBLANK($L$17),0,\nIF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$K$60:$K$61\")),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$L$60:$L$61\")),0))*IF(OR($L$20=\"Year 2\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$M$60:$M$61\")),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$N$60:$N$61\")),0))*IF(OR($L$20=\"Year 3\",$L$20=\"Years 2+3\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$O$60:$O$61\")),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$P$60:$P$61\")),0))*IF(OR($L$20=\"Year 4\",$L$20=\"Years 2+3+4\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0)\n+IF($L$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$L$17&\"'!$Q$60:$Q$61\")),IF($L$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$L$17&\"'!$R$60:$R$61\")),0))*IF(OR($L$20=\"Year 5\",$L$20=\"Years 2+3+4+5\",$L$20=\"Years 3+4+5\",$L$20=\"Years 4+5\"),1,0))","v":0},null,0]
[]
[null,{"$f":"IF(OR(ISBLANK($L$5),$L$9=\"Manual entry\"),\"\",\nIF($L$9=\"Carryforward: Destination\",IF(INDIRECT(\"'\"&$L$5&\"'!L35\")=0,\"\",INDIRECT(\"'\"&$L$5&\"'!L35\")),\nIF(INDIRECT(\"'\"&$L$5&\"'!B35\")=0,\"\",INDIRECT(\"'\"&$L$5&\"'!B35\"))))","v":""}]
[]
[null,"Total Direct Costs Budget",null,{"$f":"SUM($D$13:$D$36)","v":0},null,{"$f":"SUM($F$13:$F$36)","v":0},null,{"$f":"SUM(D38,F38)","v":0}]
[]
["F&A Rate","F&A Rate x Base = Calculated F&A"]
[0,{"$f":"TRUNC(ROUND($A$41*$B$27,2),2)","v":0},null,{"$f":"B26*A41","v":0},null,{"$f":"H41-D41","v":0},null,{"$f":"B27*A41","v":0}]
[]
[null,"Total Budget",null,{"$f":"SUM($D$38:$D$41)","v":0},null,{"$f":"SUM($F$38:$F$41)","v":0},null,{"$f":"SUM(D43,F43)","v":0}]
[]
["Comments & Cost Sharing:"]
["Why is this proposed budget revision needed? Please provide justification."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Reviewed by:"]
[]
["OSP 08/28/2024",null,null,{"$f":"D1","v":"BUDGET REVISION"},null,null,null,"OSP Award Specialist"]

{"sheet":"BR -Payroll Detail 2024.08.28","index":2,"n_rows":58,"n_cols":28,"rows_kept":58,"cut":false,"hidden":false,"merged":[[52,1,52,7],[53,1,53,7],[54,1,54,7],[46,1,46,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7],[0,3,0,5],[1,2,1,7],[2,2,2,7],[3,2,3,3],[3,6,3,7],[8,10,8,11],[9,10,10,10],[9,11,10,11],[4,2,4,3],[4,6,4,7],[5,2,5,3],[7,2,7,3],[7,6,7,7],[0,16,0,20],[0,21,0,22],[2,21,3,21],[2,22,3,22],[1,21,1,22]]}
[null,null,null,"BUDGET REVISION",null,null,null,{"$f":"NOW()","v":"2025-05-02T06:58:42.110"},null,null,null,null,null,null,null,null,"PAYROLL DETAIL REVISION"]
[null,"Sponsor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Analysis"]
[null,"Principal Investigator:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Budget",null,"Budget Change",null,"Proposed Budget","Available Balance","Expenditures &\nEncumbrances"]
[null,"Department:",null,null,null,"College:",null,null,null,null,null,null,null,null,"Budget Category",null,null,null,"DIFFERENCE",null,null,null,null,null,null,"Salary Fringe Benefit Calculation (FY23 rates)"]
[null,"Prepared By:",null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Fringe Rate*","Fringe Needed"]
[null,"Worktag:",null,null,null,null,null,null,null,null,null,null,null,null,"Salaries: Non-Classified",null,0,null,0,null,{"$f":"Q6+S6","v":0},{"$f":"U6-W6","v":0},0,null,null,"SalNC",0.26600000000000001,{"$f":"V6*AA6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salaries: Summer AL",null,0,null,0,null,{"$f":"Q7+S7","v":0},{"$f":"U7-W7","v":0},0,null,null,"SalCL",0.26600000000000001,{"$f":"V8*AA7","v":0}]
[null,"Start Date:",null,null,null,"End Date:",null,null,null,null,null,null,null,null,"Salaries: Classified",null,0,null,0,null,0,0,0,null,null,"SalGA",7.0999999999999994E-2,{"$f":"V9*AA8","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Project Analysis",null,null,null,"Salaries: GA",null,0,null,0,null,0,0,0,null,null,"Wages: Regular",5.7000000000000002E-2,{"$f":"V11*AA9","v":0}]
[null,null,null,"Current Budget",null,"Budget Change",null,"Proposed Budget",null,null,"Available Fund Balance","Expenditures &\nEncumbrances",null,null,"Salaries: SumGA",null,0,null,0,null,0,0,0,null,null,"Wages Student",1E-3,{"$f":"V12*AA10","v":0}]
[null,"Budget Category",null,{"$f":"C6","v":0},null,"DIFFERENCE",null,{"$f":"IF(D11=\"CCN\",\"Same CCN\",D11)","v":0},null,null,null,null,null,null,"Wages: Regular",null,0,null,0,null,0,0,0,null,null,"Other Comp",5.7000000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wages: Student",null,0,null,0,null,0,0,0,null,null,"SalSumAL",0.16600000000000001,{"$f":"V7*AA12","v":0}]
[null,"01_Personnel",null,{"$f":"+Q13","v":0},null,{"$f":"S13","v":0},null,{"$f":"SUM(D13,F13)","v":0},null,null,{"$f":"H13-L13","v":0},null,null,null,"Total Personnel",null,{"$f":"SUM(Q6:Q12)","v":0},null,{"$f":"SUM(S6:S12)","v":0},null,0,{"$f":"SUM(V6:V12)","v":0},{"$f":"SUM(W6:W12)","v":0},null,null,"Sal:CLPB",0.26600000000000001]
[null,"03_Fringe Benefits",null,{"$f":"+Q15","v":0},null,{"$f":"S15","v":0},null,0,null,null,{"$f":"H14-L14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sal:NCPB",0.26600000000000001]
[null,"08_Domestic Travel",null,0,null,0,null,0,null,null,0,null,null,null,"Fringe Benefits",null,0,null,0,null,{"$f":"Q15+S15","v":0},{"$f":"U15-W15","v":0},0,null,null,"Sal:GA Summer",{"$f":"AA8","v":7.0999999999999994E-2},{"$f":"V10*AA15","v":0}]
[null,"07_Foreign Travel",null,0,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(ROUND(SUM(AB6:AB15),2),2)","v":0}]
[null,"10_Materials and Supplies",null,0,null,0,null,0,null,null,0]
[null,"17_Other Direct Costs",null,0,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Fringe AFB",{"$f":"-V15+AB16","v":0}]
[null,"12_Publication Costs",null,0,null,0,null,0,null,null,0]
[null,"13_Professional Services",null,0,null,0,null,0,null,null,0]
[null,"16_Fees",null,0,null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$K$36\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$l$36\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$m$36\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$n$36\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$o$36\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$p$36\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$q$36\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$r$36\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
["Other:",null,null,0,null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$K$37\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$l$37\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$m$37\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$n$37\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$o$37\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$p$37\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$q$37\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$r$37\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
["Other:",null,null,0,null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$K$38\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$l$38\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$m$38\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$n$38\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$o$38\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$p$38\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$q$38\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$r$38\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
[]
[]
["F&A Base Current:",{"$f":"SUM($D$13:$D$25)","v":0}]
["F&A Base Proposed:",{"$f":"SUM($H$13:$H$25)","v":0}]
[]
[null,"06_Tuition",null,0,null,0,null,{"$f":"SUM(D29,F29)","v":0},null,null,{"$f":"H29-L29","v":0}]
[null,"02_Participant Stipend",null,0,null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$K$62:$K$65\"))-INDIRECT(\"'\"&$M$17&\"'!$K$53\"),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$l$62:$l$65\"))-INDIRECT(\"'\"&$M$17&\"'!$L$53\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$m$62:$m$65\"))-INDIRECT(\"'\"&$M$17&\"'!$m$53\"),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$n$62:$n$65\"))-INDIRECT(\"'\"&$M$17&\"'!$n$53\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$o$62:$o$65\"))-INDIRECT(\"'\"&$M$17&\"'!$o$53\"),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$p$62:$p$65\"))-INDIRECT(\"'\"&$M$17&\"'!$p$53\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$q$62:$q$65\"))-INDIRECT(\"'\"&$M$17&\"'!$q$53\"),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$r$62:$r$65\"))-INDIRECT(\"'\"&$M$17&\"'!$r$53\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,{"$f":"H30-L30","v":0}]
[null,"05_Participant Support",null,0,null,0,null,0,null,null,0]
[null,"09_Equipment",null,0,null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$K$58\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$l$58\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$m$58\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$n$58\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$o$58\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$p$58\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$q$58\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$r$58\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
[null,"14_Rent",null,{"$f":"IF(OR(ISBLANK($M$5),$M$9=\"Manual entry\"),0,\nIF($M$9=\"Award\",IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$5&\"'!d32\"),INDIRECT(\"'\"&$M$5&\"'!f32\")),\nIF($M$9=\"Carryforward: Destination\",INDIRECT(\"'\"&$M$5&\"'!r32\"),INDIRECT(\"'\"&$M$5&\"'!h32\"))))","v":0},null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$K$59\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$l$59\"),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$m$59\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$n$59\"),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$o$59\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$p$59\"),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$17&\"'!$q$59\"),IF($M$12=\"Cost-Share\",INDIRECT(\"'\"&$M$17&\"'!$r$59\"),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
["Other:",null,null,{"$f":"IF(OR(ISBLANK($M$5),$M$9=\"Manual entry\"),0,\nIF($M$9=\"Award\",IF($M$12=\"Sponsor\",INDIRECT(\"'\"&$M$5&\"'!d33\"),INDIRECT(\"'\"&$M$5&\"'!f33\")),\nIF($M$9=\"Carryforward: Destination\",INDIRECT(\"'\"&$M$5&\"'!r33\"),INDIRECT(\"'\"&$M$5&\"'!h33\"))))","v":0},null,{"$f":"IF(ISBLANK($M$17),0,\nIF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$K$60:$K$61\")),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$L$60:$L$61\")),0))*IF(OR($M$20=\"Year 2\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$M$60:$M$61\")),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$N$60:$N$61\")),0))*IF(OR($M$20=\"Year 3\",$M$20=\"Years 2+3\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$O$60:$O$61\")),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$P$60:$P$61\")),0))*IF(OR($M$20=\"Year 4\",$M$20=\"Years 2+3+4\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0)\n+IF($M$12=\"Sponsor\",SUM(INDIRECT(\"'\"&$M$17&\"'!$Q$60:$Q$61\")),IF($M$12=\"Cost-Share\",SUM(INDIRECT(\"'\"&$M$17&\"'!$R$60:$R$61\")),0))*IF(OR($M$20=\"Year 5\",$M$20=\"Years 2+3+4+5\",$M$20=\"Years 3+4+5\",$M$20=\"Years 4+5\"),1,0))","v":0},null,0,null,null,0]
[]
[null,{"$f":"IF(OR(ISBLANK($M$5),$M$9=\"Manual entry\"),\"\",\nIF($M$9=\"Carryforward: Destination\",IF(INDIRECT(\"'\"&$M$5&\"'!L35\")=0,\"\",INDIRECT(\"'\"&$M$5&\"'!L35\")),\nIF(INDIRECT(\"'\"&$M$5&\"'!B35\")=0,\"\",INDIRECT(\"'\"&$M$5&\"'!B35\"))))","v":""}]
[]
[null,"Total Direct Costs Budget",null,{"$f":"SUM($D$13:$D$36)","v":0},null,{"$f":"SUM($F$13:$F$36)","v":0},null,{"$f":"SUM(D38,F38)","v":0},null,null,{"$f":"SUM(K13:K36)","v":0},{"$f":"SUM(L13:L36)","v":0}]
[]
["F&A Rate","F&A Rate x Base = Calculated F&A"]
[0,{"$f":"TRUNC(ROUND($A$41*$B$27,2),2)","v":0},null,{"$f":"B26*A41","v":0},null,{"$f":"H41-D41","v":0},null,{"$f":"B27*A41","v":0},null,null,{"$f":"H41-L41","v":0}]
[]
[null,"Total Budget",null,{"$f":"SUM($D$38:$D$41)","v":0},null,{"$f":"SUM($F$38:$F$41)","v":0},null,{"$f":"SUM(D43,F43)","v":0},null,null,{"$f":"SUM(K38:K41)","v":0},{"$f":"SUM(L38:L41)","v":0}]
[]
["Comments & Cost Sharing:"]
["Why is this proposed budget revision needed? Please provide justification."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Reviewed by:"]
[]
["OSP 08/28/2024",null,null,{"$f":"D1","v":"BUDGET REVISION"},null,null,null,"OSP Award Specialist"]