{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Budget-Year 1","Budget-Year 2","Budget-Year 3","Budget-Year 4","Budget-Year 5","Cumulative Budget","Indirect & Fringe Rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":7,"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":"Budget-Year 1","index":0,"n_rows":116,"n_cols":17,"rows_kept":116,"cut":false,"hidden":false,"merged":[[83,2,83,4],[85,2,85,4],[86,2,86,4],[84,2,84,4],[81,1,81,4],[80,1,80,4],[63,1,63,5],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[76,2,76,4],[68,1,68,4],[75,1,75,4],[78,1,78,4],[79,1,79,4],[44,0,44,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[50,1,50,4],[88,0,88,4],[89,0,89,5],[90,0,90,4],[92,0,92,5],[93,1,93,5],[87,2,87,4],[45,1,45,5],[49,1,49,5],[51,1,51,4],[52,1,52,4],[55,0,55,1],[60,0,60,4],[61,0,61,5],[62,0,62,4],[71,1,71,4],[72,1,72,4],[73,1,73,4],[74,1,74,4],[82,1,82,4],[70,1,70,5],[77,1,77,5],[33,0,33,4],[6,1,7,1],[4,0,4,5],[6,3,6,4],[6,5,7,5],[6,2,7,2],[5,0,5,5],[19,0,19,5],[6,0,7,0],[20,3,30,4],[3,2,3,5],[1,0,1,1],[3,0,3,1],[18,0,18,4],[32,0,32,5],[31,0,31,4],[0,0,0,5],[1,2,1,5],[111,0,111,5],[2,0,2,1],[2,2,2,5],[96,1,96,5],[97,3,97,4],[101,0,101,5],[93,0,100,0],[102,0,102,4],[35,0,35,5],[43,0,43,5],[53,0,53,4],[54,0,54,5],[34,0,34,5],[69,2,69,4],[112,0,112,4],[113,0,113,4],[114,0,114,5],[115,0,115,4],[91,0,91,5],[103,0,103,5],[104,0,104,5],[100,3,100,4],[95,1,95,5],[94,1,94,5],[42,0,42,4],[41,1,41,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2]]}
["Proposal Budget: Year 1"]
["Fiscal Year:"]
["Project Title:"]
["Principal Investigator(s):"]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",null,null,null,null,null,{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$3,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$4,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$5,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$6,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$7,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$8,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I$9,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Budget-Year 1'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0)))))","v":0}]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B9","v":0},{"$f":"C9","v":0},null,null,{"$f":"IF(C9='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F9*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C9='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F9*'Budget-Year 1'!$H$9),IF(C9='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F9*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C9='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F9*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C9='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F9*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C9='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F9*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C9='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F9*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["2.",{"$f":"B10","v":0},0,null,null,{"$f":"IF(C10='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F10*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C10='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F10*'Budget-Year 1'!$H$9),IF(C10='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F10*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C10='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F10*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C10='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F10*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C10='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F10*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C10='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F10*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["3.",0,0,null,null,{"$f":"IF(C11='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F11*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C11='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F11*'Budget-Year 1'!$H$9),IF(C11='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F11*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C11='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F11*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C11='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F11*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C11='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F11*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C11='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F11*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["4.",0,0,null,null,{"$f":"IF(C12='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F12*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C12='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F12*'Budget-Year 1'!$H$9),IF(C12='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F12*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C12='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F12*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C12='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F12*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C12='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F12*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C12='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F12*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["5.",0,0,null,null,{"$f":"IF(C13='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F13*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C13='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F13*'Budget-Year 1'!$H$9),IF(C13='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F13*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C13='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F13*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C13='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F13*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C13='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F13*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C13='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F13*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["6.",0,0,null,null,{"$f":"IF(C14='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F14*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C14='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F14*'Budget-Year 1'!$H$9),IF(C14='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F14*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C14='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F14*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C14='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F14*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C14='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F14*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C14='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F14*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["7.",0,0,null,null,{"$f":"IF(C15='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F15*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C15='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F15*'Budget-Year 1'!$H$9),IF(C15='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F15*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C15='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F15*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C15='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F15*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C15='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F15*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C15='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F15*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["8.",0,0,null,null,{"$f":"IF(C16='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F16*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C16='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F16*'Budget-Year 1'!$H$9),IF(C16='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F16*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C16='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F16*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C16='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F16*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C16='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F16*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C16='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F16*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["9.",0,0,null,null,{"$f":"IF(C17='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F17*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C17='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F17*'Budget-Year 1'!$H$9),IF(C17='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F17*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C17='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F17*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C17='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F17*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C17='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F17*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C17='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F17*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["10.",0,0,null,null,{"$f":"IF(C18='Indirect & Fringe Rates'!$H$3,('Budget-Year 1'!F18*'Budget-Year 1'!$G$9),IF('Budget-Year 1'!C18='Indirect & Fringe Rates'!$H$4,('Budget-Year 1'!F18*'Budget-Year 1'!$H$9),IF(C18='Indirect & Fringe Rates'!$H$5,('Budget-Year 1'!F18*'Budget-Year 1'!$I$9),IF('Budget-Year 1'!C18='Indirect & Fringe Rates'!$H$6,('Budget-Year 1'!F18*'Budget-Year 1'!$J$9),IF('Budget-Year 1'!C18='Indirect & Fringe Rates'!$H$7,('Budget-Year 1'!F18*'Budget-Year 1'!$K$9),IF('Budget-Year 1'!C18='Indirect & Fringe Rates'!$H$8,('Budget-Year 1'!F18*'Budget-Year 1'!$L$9),IF('Budget-Year 1'!C18='Indirect & Fringe Rates'!$H$9,('Budget-Year 1'!F18*'Budget-Year 1'!$M$9),0)))))))","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F22:F31)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"SUM(F19,F32)","v":0}]
[]
["C. Equipment"]
[null,"Description",null,"Price per Unit","Quantity","Funds Requested"]
["1.",null,null,null,null,{"$f":"D38*E38","v":0}]
["2.",null,null,null,null,{"$f":"D39*E39","v":0}]
["3.",null,null,null,null,0]
["4.",null,null,null,null,0]
["5.",null,null,null,null,0]
["Total equipment",null,null,null,null,{"$f":"SUM(F38:F42)","v":0}]
["D. Travel"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Domestic"]
["  a."]
["  b."]
["  c."]
["2.","Foreign"]
["  a."]
["  b."]
["  c."]
["Total travel",null,null,null,null,{"$f":"SUM(F47:F49,F51:F53)","v":0}]
["E. Participant Support Costs"]
[null,null,"Description","Price per Person","Number of People","Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"D57*E57","v":0}]
["2.","Travel",null,null,null,{"$f":"D58*E58","v":0}]
["3.","Subsistence",null,null,null,0]
["4.","Other",null,null,null,0]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F57:F60)","v":0}]
["F. Other Direct Costs"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Materials and supplies"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["2.","Publication and dissemination costs"]
["3.","Consultant services"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["4.","Computer services"]
["5.","Subawards"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e.",null,null,null,null,null,null,null,null,null,null,null,"subcontract total",{"$f":"SUM(F79:F83)","v":0}]
["6.","Tuition remission",null,null,null,null,null,null,null,null,null,null,"subcontract base",{"$f":"(IF(F79>25000,25000,IF(F79<=25000,F79,0)))+(IF(F80>25000,25000,IF(F80<=25000,F80,0)))+(IF(F81>25000,25000,IF(F81<=25000,F81,0)))+(IF(F82>25000,25000,IF(F82<=25000,F82,0)))+(IF(F83>25000,25000,IF(F83<=25000,F83,0)))","v":0}]
["7.","Scholarships (for students)"]
["8.","Facility renovation"]
["9.","Facility rental (off-campus only)"]
["10.","Other"]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F65:F70,F72:F77,F79:F88)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F34+F43+F54+F61+F89","v":0}]
[]
["G. Indirect/Overhead Costs"]
[null,"Is funding agency federal or non-federal?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"If the funding agency is federal, where will 50% or more of the project activities take place?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N95=1,IF(N97=2,'Indirect & Fringe Rates'!C4,IF('Budget-Year 1'!N95=1,IF('Budget-Year 1'!N97=3,'Indirect & Fringe Rates'!C5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N95=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND('Cumulative Budget'!F69>=20001,'Cumulative Budget'!F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>50000,'Indirect & Fringe Rates'!C11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)","v":false}]
[null,{"$f":"IF($N$95=1,((F91-F43-F61-F84-F85-F86-F87-N83)+(N84)),IF(AND($N$95=2,C101<0.35),$F$91,(IF(AND(N95=2,C101=0.35),(F91-F43-F61-F84-F85-F86-F87-N83+N84)))))","v":0},{"$f":"IF((OR(C99=0,C99=D99)),C100,IF(C100=D99,C99,0))","v":0.36},"Total indirect/overhead costs",null,{"$f":"B101*C101","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F91+F101","v":0}]
[]
["I. Cost Sharing"]
[null,"Description","Source","Cash","In-Kind","Value Committed",null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUMIF(O107:O111,Q107,F107:F111)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUMIF(P107:P111,Q107,F107:F111)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM(F107:F111)","v":0}]

{"sheet":"Budget-Year 2","index":1,"n_rows":116,"n_cols":17,"rows_kept":116,"cut":false,"hidden":false,"merged":[[113,0,113,4],[114,0,114,5],[115,0,115,4],[101,0,101,5],[102,0,102,4],[103,0,103,5],[104,0,104,5],[111,0,111,5],[112,0,112,4],[90,0,90,4],[91,0,91,5],[92,0,92,5],[93,0,100,0],[93,1,93,5],[94,1,94,5],[95,1,95,5],[96,1,96,5],[97,3,97,4],[100,3,100,4],[89,0,89,5],[74,1,74,4],[75,1,75,4],[76,2,76,4],[77,1,77,5],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[87,2,87,4],[88,0,88,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[73,1,73,4],[62,0,62,4],[63,1,63,5],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,2,69,4],[70,1,70,5],[71,1,71,4],[72,1,72,4],[61,0,61,5],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,5],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,0,53,4],[54,0,54,5],[55,0,55,1],[60,0,60,4],[45,1,45,5],[34,0,34,5],[35,0,35,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,0,42,4],[43,0,43,5],[44,0,44,4],[33,0,33,4],[4,0,4,5],[5,0,5,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[18,0,18,4],[19,0,19,5],[20,3,30,4],[31,0,31,4],[32,0,32,5],[3,0,3,1],[3,2,3,5],[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5]]}
["Proposal Budget: Year 2"]
["Fiscal Year:"]
["Project Title:",null,{"$f":"'Budget-Year 1'!C3:F3","v":0}]
["Principal Investigator(s):",null,{"$f":"'Budget-Year 1'!C4:F4","v":0}]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",{"$f":"'Budget-Year 1'!B9","v":0},{"$f":"'Budget-Year 1'!C9","v":0},null,null,null,{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I3,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I4,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I5,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0)))))","v":0},{"$f":"IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I6,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0)))))","v":0},{"$f":"IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I7,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0)))))","v":0},{"$f":"IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I8,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0)))))","v":0},{"$f":"IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I9,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Budget-Year 2'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0)))))","v":0}]
["2.",{"$f":"'Budget-Year 1'!B10","v":0},{"$f":"'Budget-Year 1'!C10","v":0}]
["3.",{"$f":"'Budget-Year 1'!B11","v":0},{"$f":"'Budget-Year 1'!C11","v":0}]
["4.",{"$f":"'Budget-Year 1'!B12","v":0},{"$f":"'Budget-Year 1'!C12","v":0}]
["5.",{"$f":"'Budget-Year 1'!B13","v":0},{"$f":"'Budget-Year 1'!C13","v":0}]
["6.",{"$f":"'Budget-Year 1'!B14","v":0},{"$f":"'Budget-Year 1'!C14","v":0}]
["7.",{"$f":"'Budget-Year 1'!B15","v":0},{"$f":"'Budget-Year 1'!C15","v":0}]
["8.",{"$f":"'Budget-Year 1'!B16","v":0},{"$f":"'Budget-Year 1'!C16","v":0}]
["9.",{"$f":"'Budget-Year 1'!B17","v":0},{"$f":"'Budget-Year 1'!C17","v":0}]
["10.",{"$f":"'Budget-Year 1'!B18","v":0},{"$f":"'Budget-Year 1'!C18","v":0}]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B9","v":0},{"$f":"C9","v":0},null,null,{"$f":"IF(C9='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F9*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C9='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F9*'Budget-Year 2'!$H$9),IF(C9='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F9*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C9='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F9*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C9='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F9*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C9='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F9*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C9='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F9*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["2.",{"$f":"B10","v":0},0,null,null,{"$f":"IF(C10='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F10*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C10='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F10*'Budget-Year 2'!$H$9),IF(C10='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F10*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C10='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F10*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C10='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F10*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C10='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F10*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C10='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F10*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["3.",0,0,null,null,{"$f":"IF(C11='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F11*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C11='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F11*'Budget-Year 2'!$H$9),IF(C11='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F11*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C11='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F11*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C11='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F11*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C11='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F11*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C11='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F11*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["4.",0,0,null,null,{"$f":"IF(C12='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F12*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C12='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F12*'Budget-Year 2'!$H$9),IF(C12='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F12*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C12='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F12*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C12='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F12*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C12='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F12*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C12='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F12*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["5.",0,0,null,null,{"$f":"IF(C13='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F13*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C13='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F13*'Budget-Year 2'!$H$9),IF(C13='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F13*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C13='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F13*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C13='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F13*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C13='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F13*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C13='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F13*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["6.",0,0,null,null,{"$f":"IF(C14='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F14*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C14='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F14*'Budget-Year 2'!$H$9),IF(C14='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F14*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C14='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F14*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C14='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F14*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C14='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F14*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C14='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F14*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["7.",0,0,null,null,{"$f":"IF(C15='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F15*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C15='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F15*'Budget-Year 2'!$H$9),IF(C15='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F15*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C15='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F15*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C15='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F15*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C15='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F15*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C15='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F15*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["8.",0,0,null,null,{"$f":"IF(C16='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F16*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C16='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F16*'Budget-Year 2'!$H$9),IF(C16='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F16*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C16='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F16*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C16='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F16*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C16='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F16*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C16='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F16*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["9.",0,0,null,null,{"$f":"IF(C17='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F17*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C17='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F17*'Budget-Year 2'!$H$9),IF(C17='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F17*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C17='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F17*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C17='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F17*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C17='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F17*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C17='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F17*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["10.",0,0,null,null,{"$f":"IF(C18='Indirect & Fringe Rates'!$H$3,('Budget-Year 2'!F18*'Budget-Year 2'!$G$9),IF('Budget-Year 2'!C18='Indirect & Fringe Rates'!$H$4,('Budget-Year 2'!F18*'Budget-Year 2'!$H$9),IF(C18='Indirect & Fringe Rates'!$H$5,('Budget-Year 2'!F18*'Budget-Year 2'!$I$9),IF('Budget-Year 2'!C18='Indirect & Fringe Rates'!$H$6,('Budget-Year 2'!F18*'Budget-Year 2'!$J$9),IF('Budget-Year 2'!C18='Indirect & Fringe Rates'!$H$7,('Budget-Year 2'!F18*'Budget-Year 2'!$K$9),IF('Budget-Year 2'!C18='Indirect & Fringe Rates'!$H$8,('Budget-Year 2'!F18*'Budget-Year 2'!$L$9),IF('Budget-Year 2'!C18='Indirect & Fringe Rates'!$H$9,('Budget-Year 2'!F18*'Budget-Year 2'!$M$9),0)))))))","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F22:F31)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"F19+F32","v":0}]
[]
["C. Equipment"]
[null,"Description",null,"Price per Unit","Quantity","Funds Requested"]
["1.",null,null,null,null,{"$f":"D38*E38","v":0}]
["2.",null,null,null,null,{"$f":"D39*E39","v":0}]
["3.",null,null,null,null,0]
["4.",null,null,null,null,0]
["5.",null,null,null,null,0]
["Total equipment",null,null,null,null,{"$f":"SUM(F38:F42)","v":0}]
["D. Travel"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Domestic"]
["  a."]
["  b."]
["  c."]
["2.","Foreign"]
["  a."]
["  b."]
["  c."]
["Total travel",null,null,null,null,{"$f":"SUM(F47:F49,F51:F53)","v":0}]
["E. Participant Support Costs"]
[null,null,"Description","Price per Person","Number of People","Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"D57*E57","v":0}]
["2.","Travel",null,null,null,{"$f":"D58*E58","v":0}]
["3.","Subsistence",null,null,null,0]
["4.","Other",null,null,null,0]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F57:F60)","v":0}]
["F. Other Direct Costs"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Materials and supplies"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["2.","Publication and dissemination costs"]
["3.","Consultant services"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["4.","Computer services",null,null,null,null,null,null,null,null,null,null,"subcontract >= $25k:"]
["5.","Subawards",null,null,null,null,null,null,null,null,null,null,"yr. 1","yr. 1+2","base amount"]
["  a.",{"$f":"'Budget-Year 1'!B79","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F79>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M79=\"no\",N79=\"no\"),F79,IF(AND(M79=\"no\",N79=\"yes\"),SUM(25000-'Budget-Year 1'!F79),IF('Budget-Year 2'!M79=\"yes\",0,\"formula fail\")))","v":0}]
["  b.",{"$f":"'Budget-Year 1'!B80","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F80>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M80=\"no\",N80=\"no\"),F80,IF(AND(M80=\"no\",N80=\"yes\"),SUM(25000-'Budget-Year 1'!F80),IF('Budget-Year 2'!M80=\"yes\",0,\"formula fail\")))","v":0}]
["  c.",{"$f":"'Budget-Year 1'!B81","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F81>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M81=\"no\",N81=\"no\"),F81,IF(AND(M81=\"no\",N81=\"yes\"),SUM(25000-'Budget-Year 1'!F81),IF('Budget-Year 2'!M81=\"yes\",0,\"formula fail\")))","v":0}]
["  d.",{"$f":"'Budget-Year 1'!B82","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F82>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M82=\"no\",N82=\"no\"),F82,IF(AND(M82=\"no\",N82=\"yes\"),SUM(25000-'Budget-Year 1'!F82),IF('Budget-Year 2'!M82=\"yes\",0,\"formula fail\")))","v":0}]
["  e.",{"$f":"'Budget-Year 1'!B83","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F83>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M83=\"no\",N83=\"no\"),F83,IF(AND(M83=\"no\",N83=\"yes\"),SUM(25000-'Budget-Year 1'!F83),IF('Budget-Year 2'!M83=\"yes\",0,\"formula fail\")))","v":0}]
["6.","Tuition remission",null,null,null,null,null,null,null,null,"subcontract sum",{"$f":"SUM(F79:F83)","v":0},null,null,{"$f":"SUM(O79:O83)","v":0}]
["7.","Scholarships (for students)"]
["8.","Facility renovation"]
["9.","Facility rental (off-campus only)"]
["10.","Other"]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F65:F70,F72:F77,F79:F88)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F34+F43+F54+F61+F89","v":0}]
[]
["G. Indirect/Overhead Costs"]
[null,"Is funding agency federal or non-federal?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"If the funding agency is federal, where will 50% or more of the project activities take place?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N95=1,IF(N97=2,'Indirect & Fringe Rates'!C4,IF('Budget-Year 2'!N95=1,IF('Budget-Year 2'!N97=3,'Indirect & Fringe Rates'!C5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N95=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND('Cumulative Budget'!F69>=20001,'Cumulative Budget'!F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>50000,'Indirect & Fringe Rates'!C11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)","v":false}]
[null,{"$f":"IF($N$95=1,((F91-F43-F61-F84-F85-F86-F87-L84+O84)),IF(AND($N$95=2,C101<0.35),$F$91,IF(AND(N95=2,C101=0.35),(F91-F43-F61-F84-F85-F86-F87-L84+O84))))","v":0},{"$f":"IF((OR(C99=0,C99=D99)),C100,IF(C100=D99,C99,0))","v":0.36},"Total indirect/overhead costs",null,{"$f":"B101*C101","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F91+F101","v":0}]
[]
["I. Cost Sharing"]
[null,"Description","Source","Cash","In-Kind","Value Committed",null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUMIF(O107:O111,Q107,F107:F111)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUMIF(P107:P111,Q107,F107:F111)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM(F107:F111)","v":0}]

{"sheet":"Budget-Year 3","index":2,"n_rows":116,"n_cols":17,"rows_kept":116,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,5],[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5],[33,0,33,4],[4,0,4,5],[5,0,5,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[18,0,18,4],[19,0,19,5],[20,3,30,4],[31,0,31,4],[32,0,32,5],[45,1,45,5],[34,0,34,5],[35,0,35,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,0,42,4],[43,0,43,5],[44,0,44,4],[61,0,61,5],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,5],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,0,53,4],[54,0,54,5],[55,0,55,1],[60,0,60,4],[73,1,73,4],[62,0,62,4],[63,1,63,5],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,2,69,4],[70,1,70,5],[71,1,71,4],[72,1,72,4],[89,0,89,5],[74,1,74,4],[75,1,75,4],[76,2,76,4],[77,1,77,5],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[87,2,87,4],[88,0,88,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[90,0,90,4],[91,0,91,5],[92,0,92,5],[93,0,100,0],[93,1,93,5],[94,1,94,5],[95,1,95,5],[96,1,96,5],[97,3,97,4],[100,3,100,4],[113,0,113,4],[114,0,114,5],[115,0,115,4],[101,0,101,5],[102,0,102,4],[103,0,103,5],[104,0,104,5],[111,0,111,5],[112,0,112,4]]}
["Proposal Budget: Year 3"]
["Fiscal Year:"]
["Project Title:",null,{"$f":"'Budget-Year 1'!C3:F3","v":0}]
["Principal Investigator(s):",null,{"$f":"'Budget-Year 1'!C4:F4","v":0}]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",{"$f":"'Budget-Year 1'!B9","v":0},{"$f":"'Budget-Year 1'!C9","v":0},null,null,null,{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I3,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I4,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I5,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0)))))","v":0},{"$f":"IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I6,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0)))))","v":0},{"$f":"IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I7,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0)))))","v":0},{"$f":"IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I8,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0)))))","v":0},{"$f":"IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I9,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Budget-Year 3'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0)))))","v":0}]
["2.",{"$f":"'Budget-Year 1'!B10","v":0},{"$f":"'Budget-Year 1'!C10","v":0}]
["3.",{"$f":"'Budget-Year 1'!B11","v":0},{"$f":"'Budget-Year 1'!C11","v":0}]
["4.",{"$f":"'Budget-Year 1'!B12","v":0},{"$f":"'Budget-Year 1'!C12","v":0}]
["5.",{"$f":"'Budget-Year 1'!B13","v":0},{"$f":"'Budget-Year 1'!C13","v":0}]
["6.",{"$f":"'Budget-Year 1'!B14","v":0},{"$f":"'Budget-Year 1'!C14","v":0}]
["7.",{"$f":"'Budget-Year 1'!B15","v":0},{"$f":"'Budget-Year 1'!C15","v":0}]
["8.",{"$f":"'Budget-Year 1'!B16","v":0},{"$f":"'Budget-Year 1'!C16","v":0}]
["9.",{"$f":"'Budget-Year 1'!B17","v":0},{"$f":"'Budget-Year 1'!C17","v":0}]
["10.",{"$f":"'Budget-Year 1'!B18","v":0},{"$f":"'Budget-Year 1'!C18","v":0}]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B9","v":0},{"$f":"C9","v":0},null,null,{"$f":"IF(C9='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F9*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C9='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F9*'Budget-Year 3'!$H$9),IF(C9='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F9*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C9='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F9*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C9='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F9*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C9='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F9*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C9='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F9*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["2.",{"$f":"B10","v":0},0,null,null,{"$f":"IF(C10='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F10*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C10='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F10*'Budget-Year 3'!$H$9),IF(C10='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F10*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C10='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F10*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C10='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F10*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C10='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F10*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C10='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F10*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["3.",0,0,null,null,{"$f":"IF(C11='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F11*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C11='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F11*'Budget-Year 3'!$H$9),IF(C11='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F11*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C11='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F11*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C11='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F11*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C11='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F11*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C11='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F11*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["4.",0,0,null,null,{"$f":"IF(C12='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F12*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C12='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F12*'Budget-Year 3'!$H$9),IF(C12='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F12*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C12='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F12*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C12='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F12*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C12='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F12*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C12='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F12*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["5.",0,0,null,null,{"$f":"IF(C13='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F13*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C13='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F13*'Budget-Year 3'!$H$9),IF(C13='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F13*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C13='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F13*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C13='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F13*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C13='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F13*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C13='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F13*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["6.",0,0,null,null,{"$f":"IF(C14='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F14*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C14='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F14*'Budget-Year 3'!$H$9),IF(C14='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F14*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C14='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F14*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C14='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F14*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C14='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F14*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C14='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F14*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["7.",0,0,null,null,{"$f":"IF(C15='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F15*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C15='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F15*'Budget-Year 3'!$H$9),IF(C15='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F15*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C15='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F15*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C15='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F15*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C15='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F15*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C15='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F15*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["8.",0,0,null,null,{"$f":"IF(C16='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F16*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C16='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F16*'Budget-Year 3'!$H$9),IF(C16='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F16*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C16='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F16*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C16='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F16*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C16='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F16*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C16='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F16*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["9.",0,0,null,null,{"$f":"IF(C17='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F17*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C17='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F17*'Budget-Year 3'!$H$9),IF(C17='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F17*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C17='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F17*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C17='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F17*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C17='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F17*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C17='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F17*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["10.",0,0,null,null,{"$f":"IF(C18='Indirect & Fringe Rates'!$H$3,('Budget-Year 3'!F18*'Budget-Year 3'!$G$9),IF('Budget-Year 3'!C18='Indirect & Fringe Rates'!$H$4,('Budget-Year 3'!F18*'Budget-Year 3'!$H$9),IF(C18='Indirect & Fringe Rates'!$H$5,('Budget-Year 3'!F18*'Budget-Year 3'!$I$9),IF('Budget-Year 3'!C18='Indirect & Fringe Rates'!$H$6,('Budget-Year 3'!F18*'Budget-Year 3'!$J$9),IF('Budget-Year 3'!C18='Indirect & Fringe Rates'!$H$7,('Budget-Year 3'!F18*'Budget-Year 3'!$K$9),IF('Budget-Year 3'!C18='Indirect & Fringe Rates'!$H$8,('Budget-Year 3'!F18*'Budget-Year 3'!$L$9),IF('Budget-Year 3'!C18='Indirect & Fringe Rates'!$H$9,('Budget-Year 3'!F18*'Budget-Year 3'!$M$9),0)))))))","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F22:F31)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"F19+F32","v":0}]
[]
["C. Equipment"]
[null,"Description",null,"Price per Unit","Quantity","Funds Requested"]
["1.",null,null,null,null,{"$f":"D38*E38","v":0}]
["2.",null,null,null,null,{"$f":"D39*E39","v":0}]
["3.",null,null,null,null,0]
["4.",null,null,null,null,0]
["5.",null,null,null,null,0]
["Total equipment",null,null,null,null,{"$f":"SUM(F38:F42)","v":0}]
["D. Travel"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Domestic"]
["  a."]
["  b."]
["  c."]
["2.","Foreign"]
["  a."]
["  b."]
["  c."]
["Total travel",null,null,null,null,{"$f":"SUM(F47:F49,F51:F53)","v":0}]
["E. Participant Support Costs"]
[null,null,"Description","Price per Person","Number of People","Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"D57*E57","v":0}]
["2.","Travel",null,null,null,{"$f":"D58*E58","v":0}]
["3.","Subsistence",null,null,null,0]
["4.","Other",null,null,null,0]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F57:F60)","v":0}]
["F. Other Direct Costs"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Materials and supplies"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["2.","Publication and dissemination costs"]
["3.","Consultant services"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["4.","Computer services",null,null,null,null,null,null,null,null,null,null,"subcontract >= $25k:"]
["5.","Subrecipients",null,null,null,null,null,null,null,null,null,null,"yr. 1","yr. 1+2","yr. 1+2+3","base amount"]
["  a.",{"$f":"'Budget-Year 1'!B79","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F79>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M79=\"no\",N79=\"no\",O79=\"no\"),F79,IF(AND(M79=\"no\",N79=\"yes\"),0,IF(AND(M79=\"no\",N79=\"no\",O79=\"yes\"),SUM(25000-(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79))),IF('Budget-Year 3'!M79=\"yes\",0,\"formula fail\"))))","v":0}]
["  b.",{"$f":"'Budget-Year 1'!B80","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F80>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M80=\"no\",N80=\"no\",O80=\"no\"),F80,IF(AND(M80=\"no\",N80=\"yes\"),0,IF(AND(M80=\"no\",N80=\"no\",O80=\"yes\"),SUM(25000-(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80))),IF('Budget-Year 3'!M80=\"yes\",0,\"formula fail\"))))","v":0}]
["  c.",{"$f":"'Budget-Year 1'!B81","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F81>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M81=\"no\",N81=\"no\",O81=\"no\"),F81,IF(AND(M81=\"no\",N81=\"yes\"),0,IF(AND(M81=\"no\",N81=\"no\",O81=\"yes\"),SUM(25000-(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81))),IF('Budget-Year 3'!M81=\"yes\",0,\"formula fail\"))))","v":0}]
["  d.",{"$f":"'Budget-Year 1'!B82","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F82>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M82=\"no\",N82=\"no\",O82=\"no\"),F82,IF(AND(M82=\"no\",N82=\"yes\"),0,IF(AND(M82=\"no\",N82=\"no\",O82=\"yes\"),SUM(25000-(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82))),IF('Budget-Year 3'!M82=\"yes\",0,\"formula fail\"))))","v":0}]
["  e.",{"$f":"'Budget-Year 1'!B83","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F83>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(AND(M83=\"no\",N83=\"no\",O83=\"no\"),F83,IF(AND(M83=\"no\",N83=\"yes\"),0,IF(AND(M83=\"no\",N83=\"no\",O83=\"yes\"),SUM(25000-(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83))),IF('Budget-Year 3'!M83=\"yes\",0,\"formula fail\"))))","v":0}]
["6.","Tuition remission",null,null,null,null,null,null,null,null,"subcontract sum",{"$f":"SUM(F79:F83)","v":0},null,null,null,{"$f":"SUM(P79:P83)","v":0}]
["7.","Scholarships (for students)"]
["8.","Facility renovation"]
["9.","Facility rental (off-campus only)"]
["10.","Other"]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F65:F70,F72:F77,F79:F88)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F34+F43+F54+F61+F89","v":0}]
[]
["G. Indirect/Overhead Costs"]
[null,"Is funding agency federal or non-federal?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"If the funding agency is federal, where will 50% or more of the project activities take place?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N95=1,IF(N97=2,'Indirect & Fringe Rates'!C4,IF('Budget-Year 3'!N95=1,IF('Budget-Year 3'!N97=3,'Indirect & Fringe Rates'!C5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N95=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND('Cumulative Budget'!F69>=20001,'Cumulative Budget'!F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>50000,'Indirect & Fringe Rates'!C11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)","v":false}]
[null,{"$f":"IF($N$95=1,(F91-F43-F61-F84-F85-F86-F87-L84+P84),IF(AND($N$95=2,C101<0.35),$F$91,IF(AND(N95=2,C101=0.35),(F91-F43-F61-F84-F85-F86-F87-L84+P84))))","v":0},{"$f":"IF((OR(C99=0,C99=D99)),C100,IF(C100=D99,C99,0))","v":0.36},"Total indirect/overhead costs",null,{"$f":"B101*C101","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F91+F101","v":0}]
[]
["I. Cost Sharing"]
[null,"Description","Source","Cash","In-Kind","Value Committed",null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUMIF(O107:O111,Q107,F107:F111)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUMIF(P107:P111,Q107,F107:F111)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM(F107:F111)","v":0}]

{"sheet":"Budget-Year 4","index":3,"n_rows":116,"n_cols":17,"rows_kept":116,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,5],[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5],[33,0,33,4],[4,0,4,5],[5,0,5,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[18,0,18,4],[19,0,19,5],[20,3,30,4],[31,0,31,4],[32,0,32,5],[45,1,45,5],[34,0,34,5],[35,0,35,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,0,42,4],[43,0,43,5],[44,0,44,4],[61,0,61,5],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,5],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,0,53,4],[54,0,54,5],[55,0,55,1],[60,0,60,4],[73,1,73,4],[62,0,62,4],[63,1,63,5],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,2,69,4],[70,1,70,5],[71,1,71,4],[72,1,72,4],[89,0,89,5],[74,1,74,4],[75,1,75,4],[76,2,76,4],[77,1,77,5],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[87,2,87,4],[88,0,88,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[90,0,90,4],[91,0,91,5],[92,0,92,5],[93,0,100,0],[93,1,93,5],[94,1,94,5],[95,1,95,5],[96,1,96,5],[97,3,97,4],[100,3,100,4],[113,0,113,4],[114,0,114,5],[115,0,115,4],[101,0,101,5],[102,0,102,4],[103,0,103,5],[104,0,104,5],[111,0,111,5],[112,0,112,4]]}
["Proposal Budget: Year 4"]
["Fiscal Year:"]
["Project Title:",null,{"$f":"'Budget-Year 1'!C3:F3","v":0}]
["Principal Investigator(s):",null,{"$f":"'Budget-Year 1'!C4:F4","v":0}]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",{"$f":"'Budget-Year 1'!B9","v":0},{"$f":"'Budget-Year 1'!C9","v":0},null,null,null,{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I3,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I4,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I5,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0)))))","v":0},{"$f":"IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I6,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0)))))","v":0},{"$f":"IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I7,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0)))))","v":0},{"$f":"IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I8,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0)))))","v":0},{"$f":"IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I9,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Budget-Year 4'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0)))))","v":0}]
["2.",{"$f":"'Budget-Year 1'!B10","v":0},{"$f":"'Budget-Year 1'!C10","v":0}]
["3.",{"$f":"'Budget-Year 1'!B11","v":0},{"$f":"'Budget-Year 1'!C11","v":0}]
["4.",{"$f":"'Budget-Year 1'!B12","v":0},{"$f":"'Budget-Year 1'!C12","v":0}]
["5.",{"$f":"'Budget-Year 1'!B13","v":0},{"$f":"'Budget-Year 1'!C13","v":0}]
["6.",{"$f":"'Budget-Year 1'!B14","v":0},{"$f":"'Budget-Year 1'!C14","v":0}]
["7.",{"$f":"'Budget-Year 1'!B15","v":0},{"$f":"'Budget-Year 1'!C15","v":0}]
["8.",{"$f":"'Budget-Year 1'!B16","v":0},{"$f":"'Budget-Year 1'!C16","v":0}]
["9.",{"$f":"'Budget-Year 1'!B17","v":0},{"$f":"'Budget-Year 1'!C17","v":0}]
["10.",{"$f":"'Budget-Year 1'!B18","v":0},{"$f":"'Budget-Year 1'!C18","v":0}]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B9","v":0},{"$f":"C9","v":0},null,null,{"$f":"IF(C9='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F9*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C9='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F9*'Budget-Year 4'!$H$9),IF(C9='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F9*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C9='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F9*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C9='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F9*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C9='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F9*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C9='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F9*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["2.",{"$f":"B10","v":0},0,null,null,{"$f":"IF(C10='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F10*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C10='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F10*'Budget-Year 4'!$H$9),IF(C10='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F10*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C10='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F10*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C10='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F10*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C10='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F10*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C10='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F10*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["3.",0,0,null,null,{"$f":"IF(C11='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F11*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C11='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F11*'Budget-Year 4'!$H$9),IF(C11='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F11*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C11='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F11*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C11='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F11*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C11='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F11*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C11='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F11*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["4.",0,0,null,null,{"$f":"IF(C12='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F12*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C12='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F12*'Budget-Year 4'!$H$9),IF(C12='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F12*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C12='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F12*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C12='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F12*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C12='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F12*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C12='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F12*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["5.",0,0,null,null,{"$f":"IF(C13='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F13*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C13='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F13*'Budget-Year 4'!$H$9),IF(C13='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F13*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C13='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F13*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C13='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F13*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C13='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F13*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C13='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F13*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["6.",0,0,null,null,{"$f":"IF(C14='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F14*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C14='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F14*'Budget-Year 4'!$H$9),IF(C14='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F14*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C14='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F14*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C14='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F14*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C14='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F14*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C14='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F14*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["7.",0,0,null,null,{"$f":"IF(C15='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F15*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C15='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F15*'Budget-Year 4'!$H$9),IF(C15='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F15*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C15='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F15*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C15='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F15*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C15='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F15*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C15='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F15*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["8.",0,0,null,null,{"$f":"IF(C16='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F16*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C16='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F16*'Budget-Year 4'!$H$9),IF(C16='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F16*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C16='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F16*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C16='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F16*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C16='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F16*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C16='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F16*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["9.",0,0,null,null,{"$f":"IF(C17='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F17*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C17='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F17*'Budget-Year 4'!$H$9),IF(C17='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F17*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C17='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F17*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C17='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F17*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C17='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F17*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C17='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F17*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["10.",0,0,null,null,{"$f":"IF(C18='Indirect & Fringe Rates'!$H$3,('Budget-Year 4'!F18*'Budget-Year 4'!$G$9),IF('Budget-Year 4'!C18='Indirect & Fringe Rates'!$H$4,('Budget-Year 4'!F18*'Budget-Year 4'!$H$9),IF(C18='Indirect & Fringe Rates'!$H$5,('Budget-Year 4'!F18*'Budget-Year 4'!$I$9),IF('Budget-Year 4'!C18='Indirect & Fringe Rates'!$H$6,('Budget-Year 4'!F18*'Budget-Year 4'!$J$9),IF('Budget-Year 4'!C18='Indirect & Fringe Rates'!$H$7,('Budget-Year 4'!F18*'Budget-Year 4'!$K$9),IF('Budget-Year 4'!C18='Indirect & Fringe Rates'!$H$8,('Budget-Year 4'!F18*'Budget-Year 4'!$L$9),IF('Budget-Year 4'!C18='Indirect & Fringe Rates'!$H$9,('Budget-Year 4'!F18*'Budget-Year 4'!$M$9),0)))))))","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F22:F31)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"F19+F32","v":0}]
[]
["C. Equipment"]
[null,"Description",null,"Price per Unit","Quantity","Funds Requested"]
["1.",null,null,null,null,{"$f":"D38*E38","v":0}]
["2.",null,null,null,null,{"$f":"D39*E39","v":0}]
["3.",null,null,null,null,0]
["4.",null,null,null,null,0]
["5.",null,null,null,null,0]
["Total equipment",null,null,null,null,{"$f":"SUM(F38:F42)","v":0}]
["D. Travel"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Domestic"]
["  a."]
["  b."]
["  c."]
["2.","Foreign"]
["  a."]
["  b."]
["  c."]
["Total travel",null,null,null,null,{"$f":"SUM(F47:F49,F51:F53)","v":0}]
["E. Participant Support Costs"]
[null,null,"Description","Price per Person","Number of People","Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"D57*E57","v":0}]
["2.","Travel",null,null,null,{"$f":"D58*E58","v":0}]
["3.","Subsistence",null,null,null,0]
["4.","Other",null,null,null,0]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F57:F60)","v":0}]
["F. Other Direct Costs"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Materials and supplies"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["2.","Publication and dissemination costs"]
["3.","Consultant services"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["4.","Computer services",null,null,null,null,null,null,null,null,null,null,"subcontract >= $25k:"]
["5.","Subawards",null,null,null,null,null,null,null,null,null,null,"yr. 1","yr. 1+2","yr. 1+2+3","yr. 1+2+3+4","base amount"]
["  a.",{"$f":"'Budget-Year 1'!B79","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F79>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79,'Budget-Year 4'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(M79=\"yes\",0,IF(AND(M79=\"no\",N79=\"yes\"),0,IF(AND(M79=\"no\",N79=\"no\",O79=\"yes\"),0,IF(AND(M79=\"no\",N79=\"no\",O79=\"no\",P79=\"yes\"),25000-(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79)),IF(AND(M79=\"no\",N79=\"no\",O79=\"no\",P79=\"no\"),'Budget-Year 4'!F79,\"formula fail\")))))","v":0}]
["  b.",{"$f":"'Budget-Year 1'!B80","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F80>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80,'Budget-Year 4'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(M80=\"yes\",0,IF(AND(M80=\"no\",N80=\"yes\"),0,IF(AND(M80=\"no\",N80=\"no\",O80=\"yes\"),0,IF(AND(M80=\"no\",N80=\"no\",O80=\"no\",P80=\"yes\"),25000-(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80)),IF(AND(M80=\"no\",N80=\"no\",O80=\"no\",P80=\"no\"),'Budget-Year 4'!F80,\"formula fail\")))))","v":0}]
["  c.",{"$f":"'Budget-Year 1'!B81","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F81>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81,'Budget-Year 4'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(M81=\"yes\",0,IF(AND(M81=\"no\",N81=\"yes\"),0,IF(AND(M81=\"no\",N81=\"no\",O81=\"yes\"),0,IF(AND(M81=\"no\",N81=\"no\",O81=\"no\",P81=\"yes\"),25000-(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81)),IF(AND(M81=\"no\",N81=\"no\",O81=\"no\",P81=\"no\"),'Budget-Year 4'!F81,\"formula fail\")))))","v":0}]
["  d.",{"$f":"'Budget-Year 1'!B82","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F82>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82,'Budget-Year 4'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(M82=\"yes\",0,IF(AND(M82=\"no\",N82=\"yes\"),0,IF(AND(M82=\"no\",N82=\"no\",O82=\"yes\"),0,IF(AND(M82=\"no\",N82=\"no\",O82=\"no\",P82=\"yes\"),25000-(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82)),IF(AND(M82=\"no\",N82=\"no\",O82=\"no\",P82=\"no\"),'Budget-Year 4'!F82,\"formula fail\")))))","v":0}]
["  e.",{"$f":"'Budget-Year 1'!B83","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F83>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83,'Budget-Year 4'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(M83=\"yes\",0,IF(AND(M83=\"no\",N83=\"yes\"),0,IF(AND(M83=\"no\",N83=\"no\",O83=\"yes\"),0,IF(AND(M83=\"no\",N83=\"no\",O83=\"no\",P83=\"yes\"),25000-(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83)),IF(AND(M83=\"no\",N83=\"no\",O83=\"no\",P83=\"no\"),'Budget-Year 4'!F83,\"formula fail\")))))","v":0}]
["6.","Tuition remission",null,null,null,null,null,null,null,null,"subcontract sum",{"$f":"SUM(F79:F83)","v":0},null,null,null,null,{"$f":"SUM(Q79:Q83)","v":0}]
["7.","Scholarships (for students)"]
["8.","Facility renovation"]
["9.","Facility rental (off-campus only)"]
["10.","Other"]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F65:F70,F72:F77,F79:F88)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F34+F43+F54+F61+F89","v":0}]
[]
["G. Indirect/Overhead Costs"]
[null,"Is funding agency federal or non-federal?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"If the funding agency is federal, where will 50% or more of the project activities take place?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N95=1,IF(N97=2,'Indirect & Fringe Rates'!C4,IF('Budget-Year 4'!N95=1,IF('Budget-Year 4'!N97=3,'Indirect & Fringe Rates'!C5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N95=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND('Cumulative Budget'!F69>=20001,'Cumulative Budget'!F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>50000,'Indirect & Fringe Rates'!C11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)","v":false}]
[null,{"$f":"IF($N$95=1,(F91-F43-F61-F84-F85-F86-F87-L84+Q84),IF(AND($N$95=2,C101<0.35),$F$91,IF(AND(N95=2,C101=0.35),(F91-F43-F61-F84-F85-F86-F87-L84+Q84))))","v":0},{"$f":"IF((OR(C99=0,C99=D99)),C100,IF(C100=D99,C99,0))","v":0.36},"Total indirect/overhead costs",null,{"$f":"B101*C101","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F91+F101","v":0}]
[]
["I. Cost Sharing"]
[null,"Description","Source","Cash","In-Kind","Value Committed",null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUMIF(O107:O111,Q107,F107:F111)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUMIF(P107:P111,Q107,F107:F111)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM(F107:F111)","v":0}]

{"sheet":"Budget-Year 5","index":4,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,5],[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5],[33,0,33,4],[4,0,4,5],[5,0,5,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[18,0,18,4],[19,0,19,5],[20,3,30,4],[31,0,31,4],[32,0,32,5],[45,1,45,5],[34,0,34,5],[35,0,35,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,0,42,4],[43,0,43,5],[44,0,44,4],[61,0,61,5],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,5],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,0,53,4],[54,0,54,5],[55,0,55,1],[60,0,60,4],[73,1,73,4],[62,0,62,4],[63,1,63,5],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,2,69,4],[70,1,70,5],[71,1,71,4],[72,1,72,4],[89,0,89,5],[74,1,74,4],[75,1,75,4],[76,2,76,4],[77,1,77,5],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[87,2,87,4],[88,0,88,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[90,0,90,4],[91,0,91,5],[92,0,92,5],[93,0,100,0],[93,1,93,5],[94,1,94,5],[95,1,95,5],[96,1,96,5],[97,3,97,4],[100,3,100,4],[113,0,113,4],[114,0,114,5],[115,0,115,4],[101,0,101,5],[102,0,102,4],[103,0,103,5],[104,0,104,5],[111,0,111,5],[112,0,112,4]]}
["Proposal Budget: Year 5"]
["Fiscal Year:"]
["Project Title:",null,{"$f":"'Budget-Year 1'!C3:F3","v":0}]
["Principal Investigator(s):",null,{"$f":"'Budget-Year 1'!C4:F4","v":0}]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",{"$f":"'Budget-Year 1'!B9","v":0},{"$f":"'Budget-Year 1'!C9","v":0},null,null,null,{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I3,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I4,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0)))))","v":0},{"$f":"IF($C$2='Indirect & Fringe Rates'!A14,'Indirect & Fringe Rates'!I5,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF($C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0)))))","v":0},{"$f":"IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I6,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0)))))","v":0},{"$f":"IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I7,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0)))))","v":0},{"$f":"IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I8,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0)))))","v":0},{"$f":"IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I9,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF($C$2='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Budget-Year 5'!$C$2='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0)))))","v":0}]
["2.",{"$f":"'Budget-Year 1'!B10","v":0},{"$f":"'Budget-Year 1'!C10","v":0}]
["3.",{"$f":"'Budget-Year 1'!B11","v":0},{"$f":"'Budget-Year 1'!C11","v":0}]
["4.",{"$f":"'Budget-Year 1'!B12","v":0},{"$f":"'Budget-Year 1'!C12","v":0}]
["5.",{"$f":"'Budget-Year 1'!B13","v":0},{"$f":"'Budget-Year 1'!C13","v":0}]
["6.",{"$f":"'Budget-Year 1'!B14","v":0},{"$f":"'Budget-Year 1'!C14","v":0}]
["7.",{"$f":"'Budget-Year 1'!B15","v":0},{"$f":"'Budget-Year 1'!C15","v":0}]
["8.",{"$f":"'Budget-Year 1'!B16","v":0},{"$f":"'Budget-Year 1'!C16","v":0}]
["9.",{"$f":"'Budget-Year 1'!B17","v":0},{"$f":"'Budget-Year 1'!C17","v":0}]
["10.",{"$f":"'Budget-Year 1'!B18","v":0},{"$f":"'Budget-Year 1'!C18","v":0}]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F9:F18)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B9","v":0},{"$f":"C9","v":0},null,null,{"$f":"IF(C9='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F9*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C9='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F9*'Budget-Year 5'!$H$9),IF(C9='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F9*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C9='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F9*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C9='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F9*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C9='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F9*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C9='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F9*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["2.",{"$f":"B10","v":0},0,null,null,{"$f":"IF(C10='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F10*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C10='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F10*'Budget-Year 5'!$H$9),IF(C10='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F10*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C10='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F10*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C10='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F10*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C10='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F10*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C10='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F10*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["3.",0,0,null,null,{"$f":"IF(C11='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F11*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C11='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F11*'Budget-Year 5'!$H$9),IF(C11='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F11*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C11='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F11*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C11='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F11*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C11='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F11*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C11='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F11*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["4.",0,0,null,null,{"$f":"IF(C12='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F12*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C12='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F12*'Budget-Year 5'!$H$9),IF(C12='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F12*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C12='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F12*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C12='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F12*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C12='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F12*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C12='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F12*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["5.",0,0,null,null,{"$f":"IF(C13='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F13*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C13='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F13*'Budget-Year 5'!$H$9),IF(C13='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F13*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C13='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F13*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C13='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F13*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C13='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F13*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C13='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F13*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["6.",0,0,null,null,{"$f":"IF(C14='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F14*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C14='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F14*'Budget-Year 5'!$H$9),IF(C14='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F14*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C14='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F14*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C14='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F14*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C14='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F14*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C14='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F14*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["7.",0,0,null,null,{"$f":"IF(C15='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F15*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C15='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F15*'Budget-Year 5'!$H$9),IF(C15='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F15*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C15='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F15*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C15='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F15*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C15='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F15*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C15='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F15*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["8.",0,0,null,null,{"$f":"IF(C16='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F16*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C16='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F16*'Budget-Year 5'!$H$9),IF(C16='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F16*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C16='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F16*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C16='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F16*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C16='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F16*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C16='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F16*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["9.",0,0,null,null,{"$f":"IF(C17='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F17*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C17='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F17*'Budget-Year 5'!$H$9),IF(C17='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F17*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C17='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F17*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C17='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F17*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C17='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F17*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C17='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F17*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["10.",0,0,null,null,{"$f":"IF(C18='Indirect & Fringe Rates'!$H$3,('Budget-Year 5'!F18*'Budget-Year 5'!$G$9),IF('Budget-Year 5'!C18='Indirect & Fringe Rates'!$H$4,('Budget-Year 5'!F18*'Budget-Year 5'!$H$9),IF(C18='Indirect & Fringe Rates'!$H$5,('Budget-Year 5'!F18*'Budget-Year 5'!$I$9),IF('Budget-Year 5'!C18='Indirect & Fringe Rates'!$H$6,('Budget-Year 5'!F18*'Budget-Year 5'!$J$9),IF('Budget-Year 5'!C18='Indirect & Fringe Rates'!$H$7,('Budget-Year 5'!F18*'Budget-Year 5'!$K$9),IF('Budget-Year 5'!C18='Indirect & Fringe Rates'!$H$8,('Budget-Year 5'!F18*'Budget-Year 5'!$L$9),IF('Budget-Year 5'!C18='Indirect & Fringe Rates'!$H$9,('Budget-Year 5'!F18*'Budget-Year 5'!$M$9),0)))))))","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F22:F31)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"F19+F32","v":0}]
[]
["C. Equipment"]
[null,"Description",null,"Price per Unit","Quantity","Funds Requested"]
["1.",null,null,null,null,{"$f":"D38*E38","v":0}]
["2.",null,null,null,null,{"$f":"D39*E39","v":0}]
["3.",null,null,null,null,0]
["4.",null,null,null,null,0]
["5.",null,null,null,null,0]
["Total equipment",null,null,null,null,{"$f":"SUM(F38:F42)","v":0}]
["D. Travel"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Domestic"]
["  a."]
["  b."]
["  c."]
["2.","Foreign"]
["  a."]
["  b."]
["  c."]
["Total travel",null,null,null,null,{"$f":"SUM(F47:F49,F51:F53)","v":0}]
["E. Participant Support Costs"]
[null,null,"Description","Price per Person","Number of People","Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"D57*E57","v":0}]
["2.","Travel",null,null,null,{"$f":"D58*E58","v":0}]
["3.","Subsistence",null,null,null,0]
["4.","Other",null,null,null,0]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F57:F60)","v":0}]
["F. Other Direct Costs"]
["Description",null,null,null,null,"Funds Requested"]
["1.","Materials and supplies"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["2.","Publication and dissemination costs"]
["3.","Consultant services"]
["  a."]
["  b."]
["  c."]
["  d."]
["  e."]
["4.","Computer services",null,null,null,null,null,null,null,null,null,null,"subcontract >= $25k:"]
["5.","Subawards",null,null,null,null,null,null,null,null,null,null,"yr. 1","yr. 1+2","yr. 1+2+3","yr. 1+2+3+4","yr. 1+2+3+4+5","base amount"]
["  a.",{"$f":"'Budget-Year 1'!B79","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F79>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79,'Budget-Year 4'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79,'Budget-Year 4'!F79,'Budget-Year 5'!F79)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(P79=\"yes\",0,IF(AND(P79=\"no\",Q79=\"yes\"),25000-(SUM('Budget-Year 1'!F79,'Budget-Year 2'!F79,'Budget-Year 3'!F79,'Budget-Year 4'!F79)),IF('Budget-Year 5'!Q79=\"no\",'Budget-Year 5'!F79,\"formula fail\")))","v":0}]
["  b.",{"$f":"'Budget-Year 1'!B80","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F80>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80,'Budget-Year 4'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80,'Budget-Year 4'!F80,'Budget-Year 5'!F80)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(P80=\"yes\",0,IF(AND(P80=\"no\",Q80=\"yes\"),25000-(SUM('Budget-Year 1'!F80,'Budget-Year 2'!F80,'Budget-Year 3'!F80,'Budget-Year 4'!F80)),IF('Budget-Year 5'!Q80=\"no\",'Budget-Year 5'!F80,\"formula fail\")))","v":0}]
["  c.",{"$f":"'Budget-Year 1'!B81","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F81>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81,'Budget-Year 4'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81,'Budget-Year 4'!F81,'Budget-Year 5'!F81)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(P81=\"yes\",0,IF(AND(P81=\"no\",Q81=\"yes\"),25000-(SUM('Budget-Year 1'!F81,'Budget-Year 2'!F81,'Budget-Year 3'!F81,'Budget-Year 4'!F81)),IF('Budget-Year 5'!Q81=\"no\",'Budget-Year 5'!F81,\"formula fail\")))","v":0}]
["  d.",{"$f":"'Budget-Year 1'!B82","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F82>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82,'Budget-Year 4'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82,'Budget-Year 4'!F82,'Budget-Year 5'!F82)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(P82=\"yes\",0,IF(AND(P82=\"no\",Q82=\"yes\"),25000-(SUM('Budget-Year 1'!F82,'Budget-Year 2'!F82,'Budget-Year 3'!F82,'Budget-Year 4'!F82)),IF('Budget-Year 5'!Q82=\"no\",'Budget-Year 5'!F82,\"formula fail\")))","v":0}]
["  e.",{"$f":"'Budget-Year 1'!B83","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Budget-Year 1'!F83>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83,'Budget-Year 4'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83,'Budget-Year 4'!F83,'Budget-Year 5'!F83)>=25000,\"yes\",\"no\")","v":"no"},{"$f":"IF(P83=\"yes\",0,IF(AND(P83=\"no\",Q83=\"yes\"),25000-(SUM('Budget-Year 1'!F83,'Budget-Year 2'!F83,'Budget-Year 3'!F83,'Budget-Year 4'!F83)),IF('Budget-Year 5'!Q83=\"no\",'Budget-Year 5'!F83,\"formula fail\")))","v":0}]
["6.","Tuition remission",null,null,null,null,null,null,null,null,"subcontract sum",{"$f":"SUM(F79:F83)","v":0},null,null,null,null,null,{"$f":"SUM(R79:R83)","v":0}]
["7.","Scholarships (for students)"]
["8.","Facility renovation"]
["9.","Facility rental (off-campus only)"]
["10.","Other"]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F65:F70,F72:F77,F79:F88)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F34+F43+F54+F61+F89","v":0}]
[]
["G. Indirect/Overhead Costs"]
[null,"Is funding agency federal or non-federal?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"If the funding agency is federal, where will 50% or more of the project activities take place?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N95=1,IF(N97=2,'Indirect & Fringe Rates'!C4,IF('Budget-Year 5'!N95=1,IF('Budget-Year 5'!N97=3,'Indirect & Fringe Rates'!C5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N95=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND('Cumulative Budget'!F69>=20001,'Cumulative Budget'!F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>50000,'Indirect & Fringe Rates'!C11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,'Cumulative Budget'!F69<=20000)","v":false}]
[null,{"$f":"IF($N$95=1,(F91-F43-F61-F84-F85-F86-F87-L84+R84),IF(AND($N$95=2,C101<0.35),$F$91,IF(AND(N95=2,C101=0.35),(F91-F43-F61-F84-F85-F86-F87-L84+R84))))","v":0},{"$f":"IF((OR(C99=0,C99=D99)),C100,IF(C100=D99,C99,0))","v":0.36},"Total indirect/overhead costs",null,{"$f":"B101*C101","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F91+F101","v":0}]
[]
["I. Cost Sharing"]
[null,"Description","Source","Cash","In-Kind","Value Committed",null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["4.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["5.",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUMIF(O107:O111,Q107,F107:F111)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUMIF(P107:P111,Q107,F107:F111)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM(F107:F111)","v":0}]

{"sheet":"Cumulative Budget","index":5,"n_rows":94,"n_cols":17,"rows_kept":94,"cut":false,"hidden":false,"merged":[[91,0,91,4],[92,0,92,5],[93,0,93,4],[79,0,79,5],[80,0,80,4],[81,0,81,5],[82,0,82,5],[90,0,90,4],[83,0,89,5],[69,0,69,5],[70,0,70,5],[71,0,78,0],[75,3,75,4],[78,3,78,4],[71,1,74,5],[68,0,68,4],[54,0,54,5],[55,0,55,1],[55,2,65,4],[66,0,66,4],[67,0,67,5],[53,0,53,4],[42,0,42,5],[43,0,43,1],[41,0,41,4],[43,2,45,4],[48,2,52,4],[46,0,46,4],[47,0,47,5],[48,0,48,1],[32,0,32,4],[36,0,40,5],[35,0,35,4],[33,0,33,5],[34,0,34,5],[17,0,17,4],[18,0,18,5],[19,3,29,4],[30,0,30,4],[31,0,31,5],[3,0,3,5],[4,0,4,5],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,5,4],[5,5,6,5],[0,0,0,5],[1,2,1,5],[1,0,1,1],[2,0,2,1],[2,2,2,5]]}
["Project Budget: Cumulative"]
["Project Title:",null,{"$f":"'Budget-Year 1'!C3:F3","v":0}]
["Principal Investigator(s):",null,{"$f":"'Budget-Year 1'!C4:F4","v":0}]
[]
["A. Personnel"]
[null,"Name(s)","Staff Type","Number Person Months",null,"Funds Requested"]
[null,null,null,"Academic Year","Summer",null,"F&AS","CS","LTE","P,T,RA","RA,I","AH,UA","SE"]
["1.",{"$f":"'Budget-Year 1'!B9","v":0},{"$f":"'Budget-Year 1'!C9","v":0},{"$f":"SUM('Budget-Year 1'!D9,'Budget-Year 2'!D9,'Budget-Year 3'!D9,'Budget-Year 4'!D9,'Budget-Year 5'!D9)","v":0},{"$f":"SUM('Budget-Year 1'!E9,'Budget-Year 2'!E9,'Budget-Year 3'!E9,'Budget-Year 4'!E9,'Budget-Year 5'!E9)","v":0},{"$f":"SUM('Budget-Year 1'!F9,'Budget-Year 2'!F9,'Budget-Year 3'!F9,'Budget-Year 4'!F9,'Budget-Year 5'!F9)","v":0},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I3,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J3,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K3,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L3,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M3,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I4,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J4,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K4,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L4,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M4,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I5,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J5,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K5,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L5,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M5,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I6,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J6,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K6,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L6,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M6,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I7,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J7,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K7,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L7,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M7,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I8,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J8,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K8,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L8,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M8,0))))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!='Indirect & Fringe Rates'!#REF!,'Indirect & Fringe Rates'!#REF!,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$14,'Indirect & Fringe Rates'!$I9,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$15,'Indirect & Fringe Rates'!$J9,IF(#REF!='Indirect & Fringe Rates'!$A$16,'Indirect & Fringe Rates'!$K9,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$17,'Indirect & Fringe Rates'!$L9,IF('Cumulative Budget'!#REF!='Indirect & Fringe Rates'!$A$18,'Indirect & Fringe Rates'!$M9,0))))))","v":{"$error":"#REF!"}}]
["2.",{"$f":"'Budget-Year 1'!B10","v":0},{"$f":"'Budget-Year 1'!C10","v":0},{"$f":"SUM('Budget-Year 1'!D10,'Budget-Year 2'!D10,'Budget-Year 3'!D10,'Budget-Year 4'!D10,'Budget-Year 5'!D10)","v":0},{"$f":"SUM('Budget-Year 1'!E10,'Budget-Year 2'!E10,'Budget-Year 3'!E10,'Budget-Year 4'!E10,'Budget-Year 5'!E10)","v":0},{"$f":"SUM('Budget-Year 1'!F10,'Budget-Year 2'!F10,'Budget-Year 3'!F10,'Budget-Year 4'!F10,'Budget-Year 5'!F10)","v":0}]
["3.",{"$f":"'Budget-Year 1'!B11","v":0},{"$f":"'Budget-Year 1'!C11","v":0},{"$f":"SUM('Budget-Year 1'!D11,'Budget-Year 2'!D11,'Budget-Year 3'!D11,'Budget-Year 4'!D11,'Budget-Year 5'!D11)","v":0},{"$f":"SUM('Budget-Year 1'!E11,'Budget-Year 2'!E11,'Budget-Year 3'!E11,'Budget-Year 4'!E11,'Budget-Year 5'!E11)","v":0},{"$f":"SUM('Budget-Year 1'!F11,'Budget-Year 2'!F11,'Budget-Year 3'!F11,'Budget-Year 4'!F11,'Budget-Year 5'!F11)","v":0}]
["4.",{"$f":"'Budget-Year 1'!B12","v":0},{"$f":"'Budget-Year 1'!C12","v":0},{"$f":"SUM('Budget-Year 1'!D12,'Budget-Year 2'!D12,'Budget-Year 3'!D12,'Budget-Year 4'!D12,'Budget-Year 5'!D12)","v":0},{"$f":"SUM('Budget-Year 1'!E12,'Budget-Year 2'!E12,'Budget-Year 3'!E12,'Budget-Year 4'!E12,'Budget-Year 5'!E12)","v":0},{"$f":"SUM('Budget-Year 1'!F12,'Budget-Year 2'!F12,'Budget-Year 3'!F12,'Budget-Year 4'!F12,'Budget-Year 5'!F12)","v":0}]
["5.",{"$f":"'Budget-Year 1'!B13","v":0},{"$f":"'Budget-Year 1'!C13","v":0},{"$f":"SUM('Budget-Year 1'!D13,'Budget-Year 2'!D13,'Budget-Year 3'!D13,'Budget-Year 4'!D13,'Budget-Year 5'!D13)","v":0},{"$f":"SUM('Budget-Year 1'!E13,'Budget-Year 2'!E13,'Budget-Year 3'!E13,'Budget-Year 4'!E13,'Budget-Year 5'!E13)","v":0},{"$f":"SUM('Budget-Year 1'!F13,'Budget-Year 2'!F13,'Budget-Year 3'!F13,'Budget-Year 4'!F13,'Budget-Year 5'!F13)","v":0}]
["6.",{"$f":"'Budget-Year 1'!B14","v":0},{"$f":"'Budget-Year 1'!C14","v":0},{"$f":"SUM('Budget-Year 1'!D14,'Budget-Year 2'!D14,'Budget-Year 3'!D14,'Budget-Year 4'!D14,'Budget-Year 5'!D14)","v":0},{"$f":"SUM('Budget-Year 1'!E14,'Budget-Year 2'!E14,'Budget-Year 3'!E14,'Budget-Year 4'!E14,'Budget-Year 5'!E14)","v":0},{"$f":"SUM('Budget-Year 1'!F14,'Budget-Year 2'!F14,'Budget-Year 3'!F14,'Budget-Year 4'!F14,'Budget-Year 5'!F14)","v":0}]
["7.",{"$f":"'Budget-Year 1'!B15","v":0},{"$f":"'Budget-Year 1'!C15","v":0},{"$f":"SUM('Budget-Year 1'!D15,'Budget-Year 2'!D15,'Budget-Year 3'!D15,'Budget-Year 4'!D15,'Budget-Year 5'!D15)","v":0},{"$f":"SUM('Budget-Year 1'!E15,'Budget-Year 2'!E15,'Budget-Year 3'!E15,'Budget-Year 4'!E15,'Budget-Year 5'!E15)","v":0},{"$f":"SUM('Budget-Year 1'!F15,'Budget-Year 2'!F15,'Budget-Year 3'!F15,'Budget-Year 4'!F15,'Budget-Year 5'!F15)","v":0}]
["8.",{"$f":"'Budget-Year 1'!B16","v":0},{"$f":"'Budget-Year 1'!C16","v":0},{"$f":"SUM('Budget-Year 1'!D16,'Budget-Year 2'!D16,'Budget-Year 3'!D16,'Budget-Year 4'!D16,'Budget-Year 5'!D16)","v":0},{"$f":"SUM('Budget-Year 1'!E16,'Budget-Year 2'!E16,'Budget-Year 3'!E16,'Budget-Year 4'!E16,'Budget-Year 5'!E16)","v":0},{"$f":"SUM('Budget-Year 1'!F16,'Budget-Year 2'!F16,'Budget-Year 3'!F16,'Budget-Year 4'!F16,'Budget-Year 5'!F16)","v":0}]
["9.",{"$f":"'Budget-Year 1'!B17","v":0},{"$f":"'Budget-Year 1'!C17","v":0},{"$f":"SUM('Budget-Year 1'!D17,'Budget-Year 2'!D17,'Budget-Year 3'!D17,'Budget-Year 4'!D17,'Budget-Year 5'!D17)","v":0},{"$f":"SUM('Budget-Year 1'!E17,'Budget-Year 2'!E17,'Budget-Year 3'!E17,'Budget-Year 4'!E17,'Budget-Year 5'!E17)","v":0},{"$f":"SUM('Budget-Year 1'!F17,'Budget-Year 2'!F17,'Budget-Year 3'!F17,'Budget-Year 4'!F17,'Budget-Year 5'!F17)","v":0}]
["10.",{"$f":"'Budget-Year 1'!B18","v":0},{"$f":"'Budget-Year 1'!C18","v":0},{"$f":"SUM('Budget-Year 1'!D18,'Budget-Year 2'!D18,'Budget-Year 3'!D18,'Budget-Year 4'!D18,'Budget-Year 5'!D18)","v":0},{"$f":"SUM('Budget-Year 1'!E18,'Budget-Year 2'!E18,'Budget-Year 3'!E18,'Budget-Year 4'!E18,'Budget-Year 5'!E18)","v":0},{"$f":"SUM('Budget-Year 1'!F18,'Budget-Year 2'!F18,'Budget-Year 3'!F18,'Budget-Year 4'!F18,'Budget-Year 5'!F18)","v":0}]
["Total salaries and wages",null,null,null,null,{"$f":"SUM(F8:F17)","v":0}]
["B. Fringe Benefits"]
[null,"Name(s)","Staff Type",null,null,"Funds Requested"]
["1.",{"$f":"B8","v":0},{"$f":"C8","v":0},null,null,{"$f":"SUM('Budget-Year 1'!F22,'Budget-Year 2'!F22,'Budget-Year 3'!F22,'Budget-Year 4'!F22,'Budget-Year 5'!F22)","v":0}]
["2.",{"$f":"B9","v":0},0,null,null,{"$f":"SUM('Budget-Year 1'!F23,'Budget-Year 2'!F23,'Budget-Year 3'!F23,'Budget-Year 4'!F23,'Budget-Year 5'!F23)","v":0}]
["3.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F24,'Budget-Year 2'!F24,'Budget-Year 3'!F24,'Budget-Year 4'!F24,'Budget-Year 5'!F24)","v":0}]
["4.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F25,'Budget-Year 2'!F25,'Budget-Year 3'!F25,'Budget-Year 4'!F25,'Budget-Year 5'!F25)","v":0}]
["5.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F26,'Budget-Year 2'!F26,'Budget-Year 3'!F26,'Budget-Year 4'!F26,'Budget-Year 5'!F26)","v":0}]
["6.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F27,'Budget-Year 2'!F27,'Budget-Year 3'!F27,'Budget-Year 4'!F27,'Budget-Year 5'!F27)","v":0}]
["7.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F28,'Budget-Year 2'!F28,'Budget-Year 3'!F28,'Budget-Year 4'!F28,'Budget-Year 5'!F28)","v":0}]
["8.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F29,'Budget-Year 2'!F29,'Budget-Year 3'!F29,'Budget-Year 4'!F29,'Budget-Year 5'!F29)","v":0}]
["9.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F30,'Budget-Year 2'!F30,'Budget-Year 3'!F30,'Budget-Year 4'!F30,'Budget-Year 5'!F30)","v":0}]
["10.",0,0,null,null,{"$f":"SUM('Budget-Year 1'!F31,'Budget-Year 2'!F31,'Budget-Year 3'!F31,'Budget-Year 4'!F31,'Budget-Year 5'!F31)","v":0}]
["Total fringe benefits",null,null,null,null,{"$f":"SUM(F21:F30)","v":0}]
[]
["Total salaries, wages, & fringe benefits",null,null,null,null,{"$f":"F18+F31","v":0}]
[]
["C. Equipment"]
[null,null,null,null,null,"Funds Requested"]
[]
[]
[]
[]
[]
["Total equipment",null,null,null,null,{"$f":"SUM('Budget-Year 1'!F43,'Budget-Year 2'!F43,'Budget-Year 3'!F43,'Budget-Year 4'!F43,'Budget-Year 5'!F43)","v":0}]
["D. Travel"]
[null,null,null,null,null,"Funds Requested"]
["1.","Domestic",null,null,null,{"$f":"SUM('Budget-Year 1'!F47:F49,'Budget-Year 2'!F47:F49,'Budget-Year 3'!F47:F49,'Budget-Year 4'!F47:F49,'Budget-Year 5'!F47:F49)","v":0}]
["2.","Foreign",null,null,null,{"$f":"SUM('Budget-Year 1'!F51:F53,'Budget-Year 2'!F51:F53,'Budget-Year 3'!F51:F53,'Budget-Year 4'!F51:F53,'Budget-Year 5'!F51:F53)","v":0}]
["Total travel",null,null,null,null,{"$f":"SUM(F45:F46)","v":0}]
["E. Participant Support Costs"]
[null,null,null,null,null,"Funds Requested"]
["1.","Stipends",null,null,null,{"$f":"SUM('Budget-Year 1'!F57,'Budget-Year 2'!F57,'Budget-Year 3'!F57,'Budget-Year 4'!F57,'Budget-Year 5'!F57)","v":0}]
["2.","Travel",null,null,null,{"$f":"SUM('Budget-Year 1'!F58,'Budget-Year 2'!F58,'Budget-Year 3'!F58,'Budget-Year 4'!F58,'Budget-Year 5'!F58)","v":0}]
["3.","Subsistence",null,null,null,{"$f":"SUM('Budget-Year 1'!F59,'Budget-Year 2'!F59,'Budget-Year 3'!F59,'Budget-Year 4'!F59,'Budget-Year 5'!F59)","v":0}]
["4.","Other",null,null,null,{"$f":"SUM('Budget-Year 1'!F60,'Budget-Year 2'!F60,'Budget-Year 3'!F60,'Budget-Year 4'!F60,'Budget-Year 5'!F60)","v":0}]
["Total participant support costs",null,null,null,null,{"$f":"SUM(F50:F53)","v":0}]
["F. Other Direct Costs"]
[null,null,null,null,null,"Funds Requested"]
["1.","Materials and supplies",null,null,null,{"$f":"SUM('Budget-Year 1'!F65:F69,'Budget-Year 2'!F65:F69,'Budget-Year 3'!F65:F69,'Budget-Year 4'!F65:F69,'Budget-Year 5'!F65:F69)","v":0}]
["2.","Publication and dissemination costs",null,null,null,{"$f":"SUM('Budget-Year 1'!F70,'Budget-Year 2'!F70,'Budget-Year 3'!F70,'Budget-Year 4'!F70,'Budget-Year 5'!F70)","v":0}]
["3.","Consultant services",null,null,null,{"$f":"SUM('Budget-Year 1'!F72:F76,'Budget-Year 2'!F72:F76,'Budget-Year 3'!F72:F76,'Budget-Year 4'!F72:F76,'Budget-Year 5'!F72:F76)","v":0}]
["4.","Computer services",null,null,null,{"$f":"SUM('Budget-Year 1'!F77,'Budget-Year 2'!F77,'Budget-Year 3'!F77,'Budget-Year 4'!F77,'Budget-Year 5'!F77)","v":0}]
["5.","Subawards",null,null,null,{"$f":"SUM('Budget-Year 1'!F79:F83,'Budget-Year 2'!F79:F83,'Budget-Year 3'!F79:F83,'Budget-Year 4'!F79:F83,'Budget-Year 5'!F79:F83)","v":0}]
["6.","Tuition remission",null,null,null,{"$f":"SUM('Budget-Year 1'!F84,'Budget-Year 2'!F84,'Budget-Year 3'!F84,'Budget-Year 4'!F84,'Budget-Year 5'!F84)","v":0}]
["7.","Scholarships (for students)",null,null,null,{"$f":"SUM('Budget-Year 1'!F85,'Budget-Year 2'!F85,'Budget-Year 3'!F85,'Budget-Year 4'!F85,'Budget-Year 5'!F85)","v":0}]
["8.","Facility renovation",null,null,null,{"$f":"SUM('Budget-Year 1'!F86,'Budget-Year 2'!F86,'Budget-Year 3'!F86,'Budget-Year 4'!F86,'Budget-Year 5'!F86)","v":0}]
["9.","Facility rental (off-campus only)",null,null,null,{"$f":"SUM('Budget-Year 1'!F87,'Budget-Year 2'!F87,'Budget-Year 3'!F87,'Budget-Year 4'!F87,'Budget-Year 5'!F87)","v":0}]
["10.","Other",null,null,null,{"$f":"SUM('Budget-Year 1'!F88,'Budget-Year 2'!F88,'Budget-Year 3'!F88,'Budget-Year 4'!F88,'Budget-Year 5'!F88)","v":0}]
["Total other direct costs",null,null,null,null,{"$f":"SUM(F57:F66)","v":0}]
[]
["Total direct costs",null,null,null,null,{"$f":"F33+F42+F47+F54+F67","v":0}]
[]
["G. Indirect/Overhead Costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Base","Rate",null,null,"Funds Requested"]
[null,"Federal",{"$f":"IF(N73=1,IF(N75=2,'Indirect & Fringe Rates'!B4,IF('Cumulative Budget'!N73=1,IF('Cumulative Budget'!N75=3,'Indirect & Fringe Rates'!B5,0))))","v":0.36},false]
[null,"Non-federal",{"$f":"IF(N73=2,IF('Cumulative Budget'!F69<=5000,'Indirect & Fringe Rates'!B7,IF((AND(F69>=5001,F69<=20000)),'Indirect & Fringe Rates'!B8,IF((AND(F69>=20001,F69<=35000)),'Indirect & Fringe Rates'!B9,IF((AND('Cumulative Budget'!F69>=35001,'Cumulative Budget'!F69<=50000)),'Indirect & Fringe Rates'!B10,IF('Cumulative Budget'!F69>=50000,'Indirect & Fringe Rates'!B11,0))))))","v":false},{"$f":"AND('Cumulative Budget'!F69>=5001,F69<=20000)","v":false}]
[null,{"$f":"SUM('Budget-Year 1'!B101,'Budget-Year 2'!B101,'Budget-Year 3'!B101,'Budget-Year 4'!B101,'Budget-Year 5'!B101)","v":0},{"$f":"'Budget-Year 1'!C101","v":0.36},"Total indirect/overhead costs",null,{"$f":"SUM('Budget-Year 1'!F101,'Budget-Year 2'!F101,'Budget-Year 3'!F101,'Budget-Year 4'!F101,'Budget-Year 5'!F101)","v":0}]
[]
["H. Total Project Costs",null,null,null,null,{"$f":"F69+F79","v":0}]
[]
["I. Cost Sharing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash","In-kind","Criteria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["Total cash",null,null,null,null,{"$f":"SUM('Budget-Year 1'!F113,'Budget-Year 2'!F113,'Budget-Year 3'!F113,'Budget-Year 4'!F113,'Budget-Year 5'!F113)","v":0}]
["Total in-kind",null,null,null,null,{"$f":"SUM('Budget-Year 1'!F114,'Budget-Year 2'!F114,'Budget-Year 3'!F114,'Budget-Year 4'!F114,'Budget-Year 5'!F114)","v":0}]
[]
["Total cost sharing",null,null,null,null,{"$f":"SUM('Budget-Year 1'!F116,'Budget-Year 2'!F116,'Budget-Year 3'!F116,'Budget-Year 4'!F116,'Budget-Year 5'!F116)","v":0}]

{"sheet":"Indirect & Fringe Rates","index":6,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,7,0,12],[1,0,1,5],[5,0,5,5],[0,0,0,5]]}
["Indirect Cost Rates",null,null,null,null,null,null,"Fringe Benefits Rates"]
["Federal",null,null,null,null,null,null,"Personnel Type","FY 19-20","FY 20-21","FY 21-22","FY 22-23","FY 23-24"]
[null,"FY 19-20","FY 20-21","FY 21-22","FY 22-23","FY 23-24",null,"Unclassified (Faculty & Academic Staff)",0.38,{"$f":"I3*1.05","v":0.39900000000000002},0.41895000000000004,0.43989750000000005,0.46189237500000008]
["On-campus",0.36,0.36,0.36,0.36,0.36,null,"University Staff",0.56000000000000005,0.58800000000000008,0.61740000000000006,0.64827000000000012,0.68068350000000011]
["Off-campus",0.12,0.11,0.11,0.11,0.11,null,"Limited Term Employee (LTE)",0.25,{"$f":"I5*1.05","v":0.26250000000000001},{"$f":"J5*1.05","v":0.27562500000000001},{"$f":"K5*1.05","v":0.28940625000000003},{"$f":"L5*1.05","v":0.30387656250000006}]
["Non-Federal",null,null,null,null,null,null,"Graduate Assistant",0.13500000000000001,0.14175000000000001,0.14883750000000001,0.15627937500000003,0.16409334375000004]
["<$5,000",0.1,0.1,0.1,0.1,0.1,null,"Research Associate",0.26,0.27300000000000002,0.28665000000000002,0.30098250000000004,0.31603162500000004]
["$5,001-$20,000",0.15,0.15,0.15,0.15,0.15,null,"Ad Hoc",0.16,0.16800000000000001,0.17640000000000003,0.18522000000000005,0.19448100000000007]
["$20,001-$35,000",0.2,0.2,0.2,0.2,0.2,null,"Undergraduate Students",0.04,4.2000000000000003E-2,4.4100000000000007E-2,4.6305000000000013E-2,4.8620250000000018E-2]
["$35,001-$50,000",0.25,0.25,0.25,0.25,0.25]
[">$50,000",{"$f":"B4","v":0.36},{"$f":"C4","v":0.36},0.36,0.36,0.36]
[]
["Fiscal years"]
["2019-2020"]
["2020-2021"]
["2021-2022"]
["2022-2023"]
["2023-2024"]
[]
["Federal"]
["Non-federal"]
["N/A"]
["On campus"]
["Off campus"]