{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Budget","Fringe Detail","Salary Cap","Special Course Fees","3rd Party Cost Share","% Effort Conversion","Cayuse Budget","Validation Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":107,"n_cols":26,"rows_kept":107,"cut":false,"hidden":false,"merged":[[18,8,18,9],[18,12,18,13],[18,16,18,17],[18,20,18,21],[16,12,16,13],[17,12,17,13],[16,16,16,17],[17,16,17,17],[16,20,16,21],[17,20,17,21],[16,8,16,9],[17,8,17,9],[85,1,85,3],[87,1,87,3],[91,1,91,3],[103,0,103,1],[89,1,89,3],[88,1,88,3],[97,2,97,3],[19,24,19,25],[19,4,19,7],[19,16,19,19],[19,20,19,23],[19,8,19,11],[19,12,19,15],[78,1,78,3],[83,1,83,3],[77,1,77,3],[80,1,80,3],[82,1,82,3],[65,1,65,3],[68,1,68,3],[64,2,64,3],[12,2,12,3],[69,1,69,3],[32,2,32,3],[22,2,22,3],[27,2,27,3],[16,4,16,5],[17,4,17,5],[18,4,18,5],[16,2,16,3],[17,2,17,3],[18,2,18,3],[0,4,0,5],[0,6,0,7],[2,1,2,3],[3,1,3,3],[4,1,4,3],[1,0,1,5]]}
["Total Sponsor Cost",{"$f":"Y105","v":0},"Total Cost Share Cost",{"$f":"Z105","v":0},"Total Project Cost",null,{"$f":"Y107","v":0}]
["Start Here"]
["PI:",null,null,null,null,null," "]
["Project Title:"]
["Sponsor:"]
[]
["Start Date:",null,"End Date:"]
["Project Location:",null,"Number budget periods:",{"$f":"IF(ISNUMBER(CEILING(DATEDIF($B$7, $D$7, \"m\")/12,1)),CEILING(DATEDIF($B$7, $D$7, \"m\")/12,1),1)","v":0},"(Range 1-5)"]
["IDC Type:","Select One","Cost of living increase (%):",0,"(Range 0-10%)"]
["IDC Rate:",null,"Period to begin increase",1,"(Range 1-2)"]
[]
[null,"Cayuse Proposal Number:"]
[null,"Preparer:"]
[null,"Budget Prepared Date:"]
[null,"Cost Share:","No"]
["VERSION DATE 7/1/2022"]
[null,null,"Budget Period Start",null,{"$f":"B7","v":"00:00:00"},null,null,null,{"$f":"IF(Number_of_budget_periods>1, E18+DAY(1), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>2, I18+DAY(1), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>3, M18+DAY(1), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>4, Q18+DAY(1), \"\")","v":""}]
[null,null,"Budget Period End",null,{"$f":"IF($D$7 < EDATE(E17,12), $D$7, EDATE(E17,12)-DAY(1))","v":"00:00:00"},null,null,null,{"$f":"IF(Number_of_budget_periods>1,IF($D$7 < EDATE(I17,12), $D$7, EDATE(I17,12)-DAY(1)),\"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>2,IF($D$7 < EDATE(M17,12), $D$7, EDATE(M17,12)-DAY(1)),\"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>3,IF($D$7 < EDATE(Q17,12), $D$7, EDATE(Q17,12)-DAY(1)),\"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>4,IF($D$7 < EDATE(U17,12), $D$7, EDATE(U17,12)-DAY(1)),\"\")","v":""}]
[null,null,"Number of Months",null,{"$f":"MONTH(E18-E17)","v":1},null,null,null,{"$f":"IF(Number_of_budget_periods>1, MONTH(I18-I17), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>2, MONTH(M18-M17), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>3, MONTH(Q18-Q17), \"\")","v":""},null,null,null,{"$f":"IF(Number_of_budget_periods>4, MONTH(U18-U17), \"\")","v":""}]
[null,null,null,null,"Period 1",null,null,null,"Period 2",null,null,null,"Period 3",null,null,null,"Period 4",null,null,null,"Period 5",null,null,null,"Totals"]
[null,null,null,null,"% Effort","Sponsor","% CS Effort","UM Cost Share","% Effort","Sponsor","% CS Effort","UM Cost Share","% Effort","Sponsor","% CS Effort","UM Cost Share","% Effort","Sponsor","% CS Effort","UM Cost Share","% Effort","Sponsor","% CS Effort","UM Cost Share","Sponsor","UM Cost Share"]
["I. Salaries and Wages - KEY PERSONNEL",null,null,"Base Salary"]
[null,"PRINCIPAL INVESTIGATOR",{"$f":"B3 & \"\"","v":""}]
[null,61266,"Academic Year",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D24*E24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D24*G24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D24*I24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G24","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D24*K24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D24*M24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G24","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D24*O24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D24*Q24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G24","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D24*S24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D24*U24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G24","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D24*W24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F24,J24,N24,R24,V24)","v":0},{"$f":"SUM(H24,L24,P24,T24,X24)","v":0}]
[null,61254,"Summer",{"$f":"D24/3","v":0},1,{"$f":"IF(Number_of_budget_periods > 0, $D25*E25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D25*G25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D25*I25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G25","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D25*K25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D25*M25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G25","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D25*O25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D25*Q25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G25","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D25*S25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D25*U25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G25","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D25*W25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F25,J25,N25,R25,V25)","v":0},{"$f":"SUM(H25,L25,P25,T25,X25)","v":0}]
[null,61266,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D26*E26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D26*G26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D26*I26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G26","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D26*K26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D26*M26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G26","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D26*O26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D26*Q26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G26","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D26*S26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D26*U26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G26","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D26*W26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F26,J26,N26,R26,V26)","v":0},{"$f":"SUM(H26,L26,P26,T26,X26)","v":0}]
[]
[null,"INVESTIGATOR"]
[null,61266,"Academic Year",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D29*E29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D29*G29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D29*I29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G29","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D29*K29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D29*M29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G29","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D29*O29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D29*Q29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G29","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D29*S29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D29*U29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G29","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D29*W29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F29,J29,N29,R29,V29)","v":0},{"$f":"SUM(H29,L29,P29,T29,X29)","v":0}]
[null,61254,"Summer",{"$f":"D29/3","v":0},1,{"$f":"IF(Number_of_budget_periods > 0, $D30*E30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D30*G30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 1, $D30*I30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 1, $D30*K30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 2, $D30*M30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 2, $D30*O30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 3, $D30*Q30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 3, $D30*S30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 4, $D30*U30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 4, $D30*W30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F30,J30,N30,R30,V30)","v":0},0]
[null,61266,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D31*E31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D31*G31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 1, $D31*I31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 1, $D31*K31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 2, $D31*M31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 2, $D31*O31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 3, $D31*Q31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 3, $D31*S31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 4, $D31*U31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 4, $D31*W31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F31,J31,N31,R31,V31)","v":0},0]
[]
[null,"MONTHLY"]
[null,61266,"Academic Year",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D34*E34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D34*G34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D34*I34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G34","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D34*K34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D34*M34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G34","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D34*O34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D34*Q34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G34","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D34*S34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D34*U34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G34","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D34*W34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F34,J34,N34,R34,V34)","v":0},{"$f":"SUM(H34,L34,P34,T34,X34)","v":0}]
[null,61254,"Summer",{"$f":"D34/3","v":0},1,{"$f":"IF(Number_of_budget_periods > 0, $D35*E35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D35*G35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 1, $D35*I35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 1, $D35*K35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 2, $D35*M35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 2, $D35*O35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 3, $D35*Q35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 3, $D35*S35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 4, $D35*U35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 4, $D35*W35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F35,J35,N35,R35,V35)","v":0},0]
[null,61666,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, $D36*E36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D36*G36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 1, $D36*I36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 1, $D36*K36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 2, $D36*M36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 2, $D36*O36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 3, $D36*Q36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 3, $D36*S36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},1,{"$f":"IF(Number_of_budget_periods > 4, $D36*U36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 4, $D36*W36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F36,J36,N36,R36,V36)","v":0},{"$f":"SUM(H36,L36,P36,T36,X36)","v":0}]
[]
["II. Salaries and Wages - OTHER PERSONNEL"]
[null,"MONTHLY",null,null,1,{"$f":"IF(Number_of_budget_periods > 0, $D39*E39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D39*G39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D39*I39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G39","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D39*K39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D39*M39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G39","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D39*O39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D39*Q39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G39","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D39*S39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D39*U39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G39","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D39*W39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F39,J39,N39,R39,V39)","v":0},{"$f":"SUM(H39,L39,P39,T39,X39)","v":0}]
[]
[null,"BI-WEEKLY",null,null,1,{"$f":"IF(Number_of_budget_periods > 0, $D41*E41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},0,{"$f":"IF(Number_of_budget_periods > 0, $D41*G41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D41*I41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$G41","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D41*K41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+1), 0)","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D41*M41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$G41","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D41*O41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+2), 0)","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D41*Q41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$G41","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D41*S41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+3), 0)","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D41*U41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"$G41","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D41*W41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number+4), 0)","v":0},{"$f":"SUM(F41,J41,N41,R41,V41)","v":0},{"$f":"SUM(H41,L41,P41,T41,X41)","v":0}]
[]
[null,"STUDENT EMPLOYEES"]
[null,"Graduate Assistants","# students","Rate/Month"]
[null,"1. Academic year",null,null,1,{"$f":"$C45*$D45*E45*9","v":0},0,{"$f":"$C45*$D45*G45*9","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 1, $C45*$D45*I45*9,0)","v":0},{"$f":"$G45","v":0},{"$f":"IF(Number_of_budget_periods > 1, $C45*$D45*K45*9,0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 2, $C45*$D45*M45*9,0)","v":0},{"$f":"$G45","v":0},{"$f":"IF(Number_of_budget_periods > 2, $C45*$D45*O45*9,0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 3, $C45*$D45*Q45*9,0)","v":0},{"$f":"$G45","v":0},{"$f":"IF(Number_of_budget_periods > 3, $C45*$D45*S45*9,0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 4, $C45*$D45*U45*9,0)","v":0},{"$f":"$G45","v":0},{"$f":"IF(Number_of_budget_periods > 4, $C45*$D45*W45*9,0)","v":0},{"$f":"SUM(F45,J45,N45,R45,V45)","v":0},{"$f":"SUM(H45,L45,P45,T45,X45)","v":0}]
[null,"2. Summer",null,null,1,{"$f":"$C46*$D46*E46*3","v":0},0,{"$f":"$C46*$D46*G46*3","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 1, $C46*$D46*I46*3,0)","v":0},{"$f":"$G46","v":0},{"$f":"IF(Number_of_budget_periods > 1, $C46*$D46*K46*3,0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 2, $C46*$D46*M46*3,0)","v":0},{"$f":"$G46","v":0},{"$f":"IF(Number_of_budget_periods > 2, $C46*$D46*O46*3,0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 3, $C46*$D46*Q46*3,0)","v":0},{"$f":"$G46","v":0},{"$f":"IF(Number_of_budget_periods > 3, $C46*$D46*S46*3,0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 4, $C46*$D46*U46*3,0)","v":0},{"$f":"$G46","v":0},{"$f":"IF(Number_of_budget_periods > 4, $C46*$D46*W46*3,0)","v":0},{"$f":"SUM(F46,J46,N46,R46,V46)","v":0},{"$f":"SUM(H46,L46,P46,T46,X46)","v":0}]
[]
[null,"Student Workers - hourly"]
[null,"# students","# hours / year","Rate/Hour"]
[null,null,null,null,1,{"$f":"$B50*$C50*$D50*E50","v":0},0,{"$f":"$B50*$C50*$D50*G50","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 1, $B50*$C50*$D50*I50,0)","v":0},{"$f":"$G50","v":0},{"$f":"IF(Number_of_budget_periods > 1, $B50*$C50*$D50*K50,0)","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 2, $B50*$C50*$D50*M50,0)","v":0},{"$f":"$G50","v":0},{"$f":"IF(Number_of_budget_periods > 2, $B50*$C50*$D50*O50,0)","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 3, $B50*$C50*$D50*Q50,0)","v":0},{"$f":"$G50","v":0},{"$f":"IF(Number_of_budget_periods > 3, $B50*$C50*$D50*S50,0)","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 4, $B50*$C50*$D50*U50,0)","v":0},{"$f":"$G50","v":0},{"$f":"IF(Number_of_budget_periods > 4, $B50*$C50*$D50*W50,0)","v":0},{"$f":"SUM(F50,J50,N50,R50,V50)","v":0},{"$f":"SUM(H50,L50,P50,T50,X50)","v":0}]
[null,"TEMPORARY EMPLOYEES"]
["# hours","Insurance","Title","Rate/Hour"]
[null,null,null,null,1,{"$f":"$A53*$D53*E53","v":0},0,{"$f":"$A53*$D53*G53","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 1, $A53*$D53*I53,0)","v":0},{"$f":"$G53","v":0},{"$f":"IF(Number_of_budget_periods > 1, $A53*$D53*K53,0)","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 2, $A53*$D53*M53,0)","v":0},{"$f":"$G53","v":0},{"$f":"IF(Number_of_budget_periods > 2, $A53*$D53*O53,0)","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 3, $A53*$D53*Q53,0)","v":0},{"$f":"$G53","v":0},{"$f":"IF(Number_of_budget_periods > 3, $A53*$D53*S53,0)","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 4, $A53*$D53*U53,0)","v":0},{"$f":"$G53","v":0},{"$f":"IF(Number_of_budget_periods > 4, $A53*$D53*W53,0)","v":0},{"$f":"SUM(F53,J53,N53,R53,V53)","v":0},{"$f":"SUM(H53,L53,P53,T53,X53)","v":0}]
[]
[null,null,null,"Subtotal - Salaries and Wages",null,{"$f":"SUM(F23:F54)","v":0},null,{"$f":"SUM(H23:H54)","v":0},null,{"$f":"SUM(J23:J54)","v":0},null,{"$f":"SUM(L23:L54)","v":0},null,{"$f":"SUM(N23:N54)","v":0},null,{"$f":"SUM(P23:P54)","v":0},null,{"$f":"SUM(R23:R54)","v":0},null,{"$f":"SUM(T23:T54)","v":0},null,{"$f":"SUM(V23:V54)","v":0},null,{"$f":"SUM(X23:X54)","v":0},{"$f":"SUM(Y23:Y54)","v":0},{"$f":"SUM(Z23:Z54)","v":0}]
["III. Fringe Benefits",null," "]
[null,"Salaried Employees (monthly)",null,{"$f":"'Validation Data'!$E$2","v":0.35859999999999997},null,{"$f":"$D57*SUM(F23:F40)","v":0},null,{"$f":"$D57*SUM(H23:H40)","v":0},null,{"$f":"$D57*SUM(J23:J40)","v":0},null,{"$f":"$D57*SUM(L23:L40)","v":0},null,{"$f":"$D57*SUM(N23:N40)","v":0},null,{"$f":"$D57*SUM(P23:P40)","v":0},null,{"$f":"$D57*SUM(R23:R40)","v":0},null,{"$f":"$D57*SUM(T23:T40)","v":0},null,{"$f":"$D57*SUM(V23:V40)","v":0},null,{"$f":"$D57*SUM(X23:X40)","v":0},{"$f":"SUM(F57,J57,N57,R57,V57)","v":0},{"$f":"SUM(H57,L57,P57,T57,X57)","v":0}]
[null,"Graduate Assistants - Academic Year",null,{"$f":"'Validation Data'!$E$6","v":1.2E-2},null,{"$f":"SUMPRODUCT((MOD(ROW(F45:F47),2)=1)*(F45:F47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(H45:H47),2)=1)*(H45:H47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(J45:J47),2)=1)*(J45:J47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(L45:L47),2)=1)*(L45:L47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(N45:N47),2)=1)*(N45:N47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(P45:P47),2)=1)*(P45:P47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(R45:R47),2)=1)*(R45:R47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(T45:T47),2)=1)*(T45:T47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(V45:V47),2)=1)*(V45:V47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(X45:X47),2)=1)*(X45:X47))*GA_Academic_rate","v":0},0,{"$f":"SUM(H58,L58,P58,T58,X58)","v":0}]
[null,"Graduate Assistants - Summer",null,{"$f":"'Validation Data'!$E$6","v":1.2E-2},null,{"$f":"SUMPRODUCT((MOD(ROW(F45:F47),2)=0)*(F45:F47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(H45:H47),2)=0)*(H45:H47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(J45:J47),2)=0)*(J45:J47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(L45:L47),2)=0)*(L45:L47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(N45:N47),2)=0)*(N45:N47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(P45:P47),2)=0)*(P45:P47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(R45:R47),2)=0)*(R45:R47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(T45:T47),2)=0)*(T45:T47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(V45:V47),2)=0)*(V45:V47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(X45:X47),2)=0)*(X45:X47))*GA_Academic_rate","v":0},0,0]
[null,"Student Workers (undergraduate)",null,{"$f":"'Validation Data'!$E$6","v":1.2E-2},null,{"$f":"$D60*F50","v":0},null,{"$f":"$D60*H50","v":0},null,{"$f":"$D60*J50","v":0},null,{"$f":"$D60*L50","v":0},null,{"$f":"$D60*N50","v":0},null,{"$f":"$D60*P50","v":0},null,{"$f":"$D60*R50","v":0},null,{"$f":"$D60*T50","v":0},null,{"$f":"$D60*V50","v":0},null,{"$f":"$D60*X50","v":0},0,0]
[null,"Hourly Employees",null,{"$f":"'Validation Data'!$E$3","v":0.52829999999999999},null,{"$f":"$D61*SUM(F41:F42)","v":0},null,{"$f":"$D61*SUM(H41:H42)","v":0},null,{"$f":"$D61*SUM(J41:J42)","v":0},null,{"$f":"$D61*SUM(L41:L42)","v":0},null,{"$f":"$D61*SUM(N41:N42)","v":0},null,{"$f":"$D61*SUM(P41:P42)","v":0},null,{"$f":"$D61*SUM(R41:R42)","v":0},null,{"$f":"$D61*SUM(T41:T42)","v":0},null,{"$f":"$D61*SUM(V41:V42)","v":0},null,{"$f":"$D61*SUM(X41:X42)","v":0},0,0]
[null,"Temporary Employees (No Insurance)",null,{"$f":"'Validation Data'!$E$4","v":7.4399999999999994E-2},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),F53:F54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),H53:H54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),J53:J54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),L53:L54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),N53:N54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),P53:P54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),R53:R54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),T53:T54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),V53:V54)*Temp_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),X53:X54)*Temp_rate","v":0},0,0]
[null,"Tempoary Employees (Insurance)",null,{"$f":"'Validation Data'!$E$5","v":0.14399999999999999},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),F53:F54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),H53:H54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),J53:J54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),L53:L54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),N53:N54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),P53:P54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),R53:R54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),T53:T54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),V53:V54)*Temp_no_insurance_rate","v":0},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),X53:X54)*Temp_no_insurance_rate","v":0},0,0]
[null,null,null,"Subtotal - Fringe Benefits",null,{"$f":"SUM(F57:F63)","v":0},null,{"$f":"SUM(H57:H63)","v":0},null,{"$f":"SUM(J57:J63)","v":0},null,{"$f":"SUM(L57:L63)","v":0},null,{"$f":"SUM(N57:N63)","v":0},null,{"$f":"SUM(P57:P63)","v":0},null,{"$f":"SUM(R57:R63)","v":0},null,{"$f":"SUM(T57:T63)","v":0},null,{"$f":"SUM(V57:V63)","v":0},null,{"$f":"SUM(X57:X63)","v":0},{"$f":"SUM(Y57:Y63)","v":0},{"$f":"SUM(Z57:Z63)","v":0}]
["IV. Equipment > $5,000",null,"Name of Instrument"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F66+IF(Number_of_budget_periods > 1, J66,0)+IF(Number_of_budget_periods > 2, N66,0)+IF(Number_of_budget_periods > 3, R66,0)+IF(Number_of_budget_periods > 4, V66,0)","v":0},{"$f":"H66+IF(Number_of_budget_periods > 1, L66,0)+IF(Number_of_budget_periods > 2, P66,0)+IF(Number_of_budget_periods > 3, T66,0)+IF(Number_of_budget_periods > 4, X66,0)","v":0}]
[]
[null,null,null,"Subtotal - Equipment",null,{"$f":"SUM(F66:F67)","v":0},null,{"$f":"SUM(H66:H67)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(J66:J67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(L66:L67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(N66:N67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(P66:P67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(R66:R67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(T66:T67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(V66:V67), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(X66:X67), 0)","v":0},{"$f":"SUM(Y66:Y67)","v":0},{"$f":"SUM(Z66:Z67)","v":0}]
["V. Travel","Select domestic or international"]
[null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F70+IF(Number_of_budget_periods > 1, J70,0)+IF(Number_of_budget_periods > 2, N70,0)+IF(Number_of_budget_periods > 3, R70,0)+IF(Number_of_budget_periods > 4, V70,0)","v":0},{"$f":"H70+IF(Number_of_budget_periods > 1, L70,0)+IF(Number_of_budget_periods > 2, P70,0)+IF(Number_of_budget_periods > 3, T70,0)+IF(Number_of_budget_periods > 4, X70,0)","v":0}]
[]
[null,null,null,"Subtotal - Travel",null,{"$f":"SUM(F70:F71)","v":0},null,{"$f":"SUM(H70:H71)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(J70:J71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(L70:L71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(N70:N71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(P70:P71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(R70:R71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(T70:T71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(V70:V71), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(X70:X71), 0)","v":0},{"$f":"SUM(Y70:Y71)","v":0},{"$f":"SUM(Z70:Z71)","v":0}]
["VI. Participant Support",null,"# Participants","Amount"]
[null,null,null,null,1,{"$f":"$C74*$D74*$E74","v":0},{"$f":"1-E74","v":0},{"$f":"$C74*$D74*$G74","v":0},{"$f":"E74","v":1},{"$f":"IF(Number_of_budget_periods > 1, $C74*$D74*$E74,0)","v":0},{"$f":"1-I74","v":0},{"$f":"IF(Number_of_budget_periods > 1, $C74*$D74*$G74,0)","v":0},{"$f":"I74","v":1},{"$f":"IF(Number_of_budget_periods > 2, $C74*$D74*$E74,0)","v":0},{"$f":"1-M74","v":0},{"$f":"IF(Number_of_budget_periods > 2, $C74*$D74*$G74,0)","v":0},{"$f":"M74","v":1},{"$f":"IF(Number_of_budget_periods > 3, $C74*$D74*$E74,0)","v":0},{"$f":"1-Q74","v":0},{"$f":"IF(Number_of_budget_periods > 3, $C74*$D74*$G74,0)","v":0},{"$f":"Q74","v":1},{"$f":"IF(Number_of_budget_periods > 4, $C74*$D74*$E74,0)","v":0},{"$f":"1-U74","v":0},{"$f":"IF(Number_of_budget_periods > 4, $C74*$D74*$G74,0)","v":0},{"$f":"SUM(F74,J74,N74,R74,V74)","v":0},{"$f":"SUM(H74,L74,P74,T74,X74)","v":0}]
[]
[null,null,null,"Subtotal - Participant Support",null,{"$f":"SUM(F74:F75)","v":0},null,{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},null,{"$f":"SUM(L74:L75)","v":0},null,{"$f":"SUM(N74:N75)","v":0},null,{"$f":"SUM(P74:P75)","v":0},null,{"$f":"SUM(R74:R75)","v":0},null,{"$f":"SUM(T74:T75)","v":0},null,{"$f":"SUM(V74:V75)","v":0},null,{"$f":"SUM(X74:X75)","v":0},{"$f":"SUM(Y74:Y75)","v":0},{"$f":"SUM(Z74:Z75)","v":0}]
["VII. Other Direct Costs"]
[null,"Materials & Supplies (Unit cost under $5,000)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F79+IF(Number_of_budget_periods > 1, J79,0)+IF(Number_of_budget_periods > 2, N79,0)+IF(Number_of_budget_periods > 3, R79,0)+IF(Number_of_budget_periods > 4, V79,0)","v":0},{"$f":"H79+IF(Number_of_budget_periods > 1, L79,0)+IF(Number_of_budget_periods > 2, P79,0)+IF(Number_of_budget_periods > 3, T79,0)+IF(Number_of_budget_periods > 4, X79,0)","v":0}]
[]
[null,"Publication Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F81+IF(Number_of_budget_periods > 1, J81,0)+IF(Number_of_budget_periods > 2, N81,0)+IF(Number_of_budget_periods > 3, R81,0)+IF(Number_of_budget_periods > 4, V81,0)","v":0},{"$f":"H81+IF(Number_of_budget_periods > 1, L81,0)+IF(Number_of_budget_periods > 2, P81,0)+IF(Number_of_budget_periods > 3, T81,0)+IF(Number_of_budget_periods > 4, X81,0)","v":0}]
[]
[null,"Consultant Services"]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F84+IF(Number_of_budget_periods > 1, J84,0)+IF(Number_of_budget_periods > 2, N84,0)+IF(Number_of_budget_periods > 3, R84,0)+IF(Number_of_budget_periods > 4, V84,0)","v":0},{"$f":"H84+IF(Number_of_budget_periods > 1, L84,0)+IF(Number_of_budget_periods > 2, P84,0)+IF(Number_of_budget_periods > 3, T84,0)+IF(Number_of_budget_periods > 4, X84,0)","v":0}]
[]
[null,"Computer Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F86+IF(Number_of_budget_periods > 1, J86,0)+IF(Number_of_budget_periods > 2, N86,0)+IF(Number_of_budget_periods > 3, R86,0)+IF(Number_of_budget_periods > 4, V86,0)","v":0},{"$f":"H86+IF(Number_of_budget_periods > 1, L86,0)+IF(Number_of_budget_periods > 2, P86,0)+IF(Number_of_budget_periods > 3, T86,0)+IF(Number_of_budget_periods > 4, X86,0)","v":0}]
[]
[null,"Subawards/Contractual"]
[null,"Organization Name",null,null,null,"Amount","Exclude","Include",null,"Amount","Exclude","Include",null,"Amount","Exclude","Include",null,"Amount","Exclude","Include",null,"Amount","Exclude","Include"]
[null,null,null,null,null,null,{"$f":"IF(F90<25000,0,(F90-25000))","v":0},{"$f":"F90-G90","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, $F90, 0)","v":0},{"$f":"IF(Number_of_budget_periods>1,IF(SUM(H90)>25000,J90,IF(SUM(H90,J90)<25000,0,SUM(H90,J90)-25000)),0)","v":0},{"$f":"IF(Number_of_budget_periods > 1, J90-K90,0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, $F90, 0)","v":0},{"$f":"IF(Number_of_budget_periods > 2, IF(SUM(L90,H90) > 25000, N90, IF(SUM(H90,L90,N90) < 25000, 0, SUM(H90, L90,N90)-25000)),0)","v":0},{"$f":"IF(Number_of_budget_periods > 2, N90-O90,0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, $F90, 0)","v":0},{"$f":"IF(Number_of_budget_periods > 3, IF(SUM(H90,P90,L90) > 25000, R90, IF(SUM(H90,L90,P90,R90) < 25000, 0, SUM(H90,L90, P90,R90)-25000)),0)","v":0},{"$f":"IF(Number_of_budget_periods > 3, R90-S90,0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, $F90, 0)","v":0},{"$f":"IF(Number_of_budget_periods > 4, IF(SUM(H90,L90,T90,P90) > 25000, V90, IF(SUM(H90,L90,P90,T90,V90) < 25000, 0, SUM(H90,L90,P90, T90,V90)-25000)),0)","v":0},{"$f":"IF(Number_of_budget_periods > 4, V90-W90,0)","v":0},{"$f":"F90+IF(Number_of_budget_periods > 1, J90,0)+IF(Number_of_budget_periods > 2, N90,0)+IF(Number_of_budget_periods > 3, R90,0)+IF(Number_of_budget_periods > 4, V90,0)","v":0}]
[]
[null,"Other - Tuition/Fees for Graduate Students"]
[null,"% Increase","Number of Students","Hours"]
[" ",0,0,10,1,{"$f":"('Validation Data'!E18*MIN($D94,10)*(1+$B$94)+MIN($D94, 10)*'Validation Data'!G18)*E94*2*$C$94","v":0},{"$f":"1-E94","v":0},{"$f":"('Validation Data'!E18*MIN($D94,10)*(1+$B$94)+MIN($D94, 10)*'Validation Data'!G18)*G94*2*$C$94","v":0},{"$f":"E94","v":1},{"$f":"IF(Number_of_budget_periods > 1,('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^2+MIN($D94, 10)*'Validation Data'!G18)*I94*2*$C$94,0)","v":0},{"$f":"1-I94","v":0},{"$f":"IF(Number_of_budget_periods > 1,('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^2+MIN($D94, 10)*'Validation Data'!G18)*K94*2*$C$94,0)","v":0},{"$f":"I94","v":1},{"$f":"IF(Number_of_budget_periods > 2, ('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^3+MIN($D94, 10)*'Validation Data'!G18)*M94*2*$C$94,0)","v":0},{"$f":"1-M94","v":0},{"$f":"IF(Number_of_budget_periods > 2, ('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^3+MIN($D94, 10)*'Validation Data'!G18)*O94*2*$C$94,0)","v":0},{"$f":"M94","v":1},{"$f":"IF(Number_of_budget_periods > 3,('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^4+MIN($D94, 10)*'Validation Data'!G18)*Q94*2*$C$94,0)","v":0},{"$f":"1-Q94","v":0},{"$f":"IF(Number_of_budget_periods > 3,('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^4+MIN($D94, 10)*'Validation Data'!G18)*S94*2*$C$94,0)","v":0},{"$f":"Q94","v":1},{"$f":"IF(Number_of_budget_periods > 4, ('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^5+MIN($D94, 10)*'Validation Data'!G18)*U94*2*$C$94,0)","v":0},{"$f":"1-U94","v":0},{"$f":"IF(Number_of_budget_periods > 4, ('Validation Data'!E18*MIN($D94,10)*(1+$B$94)^5+MIN($D94, 10)*'Validation Data'!G18)*W94*2*$C$94,0)","v":0},{"$f":"SUM(F94,J94,N94,R94,V94)","v":0},{"$f":"SUM(H94,L94,P94,T94,X94)","v":0}]
[null,null,"Special Course Fees (from Tab)",{"$f":"'Special Course Fees'!G13","v":0},1,{"$f":"$D95*E95","v":0},{"$f":"1-E95","v":0},{"$f":"$D95*G95","v":0},{"$f":"E95","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D95*I95,0)","v":0},{"$f":"1-I95","v":0},{"$f":"IF(Number_of_budget_periods > 1, $D95*K95,0)","v":0},{"$f":"I95","v":1},{"$f":"IF(Number_of_budget_periods > 2, $D95*M95,0)","v":0},{"$f":"1-M95","v":0},{"$f":"IF(Number_of_budget_periods > 2, $D95*O95,0)","v":0},{"$f":"M95","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D95*Q95,0)","v":0},{"$f":"1-Q95","v":0},{"$f":"IF(Number_of_budget_periods > 3, $D95*S95,0)","v":0},{"$f":"Q95","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D95*U95,0)","v":0},{"$f":"1-U95","v":0},{"$f":"IF(Number_of_budget_periods > 4, $D95*W95,0)","v":0},{"$f":"SUM(F95,J95,N95,R95,V95)","v":0},{"$f":"SUM(H95,L95,P95,T95,X95)","v":0}]
[null,null,null,"Subtotal - Tuition and Fees",null,{"$f":"SUM(F94:F95)","v":0},null,{"$f":"SUM(H94:H95)","v":0},null,{"$f":"SUM(J94:J95)","v":0},null,{"$f":"SUM(L94:L95)","v":0},null,{"$f":"SUM(N94:N95)","v":0},null,{"$f":"SUM(P94:P95)","v":0},null,{"$f":"SUM(R94:R95)","v":0},null,{"$f":"SUM(T94:T95)","v":0},null,{"$f":"SUM(V94:V95)","v":0},null,{"$f":"SUM(X94:X95)","v":0},{"$f":"SUM(F96,J96,N96,R96,V96)","v":0},{"$f":"SUM(H96,L96,P96,T96,X96)","v":0}]
[null,"Other","Items"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F98,J98,N98,R98,V98)","v":0},{"$f":"SUM(H98,L98,P98,T98,X98)","v":0}]
[]
[null,null,null,"Subtotal - Other Direct Costs",null,{"$f":"SUM(F78:F86)+SUM(F94:F95)+SUM(F90:F91)+SUM(F98:F99)","v":0},null,{"$f":"SUM(H78:H86)+SUM(H94:H95)+SUM(H98:H99)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(J78:J86)+SUM(J94:J95)+SUM(J90:J91)+SUM(J98:J99),0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 1, SUM(L78:L86)+SUM(L94:L95)+SUM(L98:L99), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(N78:N86)+SUM(N94:N95)+SUM(N90:N91)+SUM(N98:N99),0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 2, SUM(P78:P86)+SUM(P94:P95)+SUM(P98:P99), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(R78:R86)+SUM(R94:R95)+SUM(R90:R91)+SUM(R98:R99),0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 3, SUM(T78:T86)+SUM(T94:T95)+SUM(T98:T99), 0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(V78:V86)+SUM(V94:V95)+SUM(V90:V91)+SUM(V98:V99),0)","v":0},null,{"$f":"IF(Number_of_budget_periods > 4, SUM(X78:X86)+SUM(X94:X95)+SUM(X98:X99), 0)","v":0},{"$f":"SUM(F100,J100,N100,R100,V100)","v":0},{"$f":"SUM(H100,L100,P100,T100,X100)","v":0}]
["TOTALS"]
[null,null,null,"Total Direct Costs"," ",{"$f":"SUM(F55,F64,F72,F68,F100,F76)","v":0},null,{"$f":"IF($C$15=\"Yes\", SUM(H55,H64,H72,H68,H100,H76), 0)","v":0},null,{"$f":"SUM(J55,J64,J72,J68,J100,J76)","v":0},null,{"$f":"IF($C$15=\"Yes\",SUM(L55,L64,L72,L68,L100,L76),0)","v":0},null,{"$f":"SUM(N55,N64,N72,N68,N100,N76)","v":0},null,{"$f":"IF($C$15=\"Yes\",SUM(P55,P64,P72,P68,P100,P76),0)","v":0},null,{"$f":"SUM(R55,R64,R72,R68,R100,R76)","v":0},null,{"$f":"IF($C$15=\"Yes\",SUM(T55,T64,T72,T68,T100,T76),0)","v":0},null,{"$f":"SUM(V55,V64,V72,V68,V100,V76)","v":0},null,{"$f":"IF($C$15=\"Yes\",SUM(X55,X64,X72,X68,X100,X76),0)","v":0},{"$f":"SUM(V102,R102,N102,J102,F102)","v":0},{"$f":"SUM(X102,T102,P102,L102,H102)","v":0}]
[null,null,null,"Base for F&A",null,{"$f":"IF($C$104 = \"TDC\", F102,F102-SUM(G90:G91)-F76-F96-F68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", H102,H102-H76-H96-H68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", J102,J102-SUM(K90:K91)-J76-J96-J68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", L102,L102-L76-L96-L68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", N102,N102-SUM(O90:O91)-N76-N96-N68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", P102,P102-P76-P96-P68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", R102,R102-SUM(S90:S91)-R76-R96-R68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", T102,T102-T76-T96-T68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", V102,V102-SUM(W90:W91)-V76-V96-V68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", X102,X102-X76-X96-X68)","v":0},{"$f":"SUM(V103,R103,N103,J103,F103)","v":0},{"$f":"SUM(X103,T103,P103,L103,H103)","v":0}]
["Facilities & Admin Costs",null,{"$f":"$B$9","v":"Select One"},{"$f":"$B$10","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*F103, IF($C$104=\"TDC\", $D$104*F102,0))","v":0},null,{"$f":"IF($C$15=\"Yes\",IF($C$104=\"MTDC\", $D$104*H103, IF($C$104=\"TDC\", $D$104*H102,0)),0)","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*J103, IF($C$104=\"TDC\", $D$104*J102,0))","v":0},null,{"$f":"IF($C$15=\"Yes\",IF($C$104=\"MTDC\", $D$104*L103, IF($C$104=\"TDC\", $D$104*L102,0)),0)","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*N103, IF($C$104=\"TDC\", $D$104*N102,0))","v":0},null,{"$f":"IF($C$15=\"Yes\",IF($C$104=\"MTDC\", $D$104*P103, IF($C$104=\"TDC\", $D$104*P102,0)),0)","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*R103, IF($C$104=\"TDC\", $D$104*R102,0))","v":0},null,{"$f":"IF($C$15=\"Yes\",IF($C$104=\"MTDC\", $D$104*T103, IF($C$104=\"TDC\", $D$104*T102,0)),0)","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*V103, IF($C$104=\"TDC\", $D$104*V102,0))","v":0},null,{"$f":"IF($C$15=\"Yes\",IF($C$104=\"MTDC\", $D$104*X103, IF($C$104=\"TDC\", $D$104*X102,0)),0)","v":0},{"$f":"SUM(V104,R104,N104,J104,F104)","v":0},{"$f":"SUM(X104,T104,P104,L104,H104)","v":0}]
[null,null,null,"Total Sponsor Costs/Total UM Cost Share",null,{"$f":"F104+F102","v":0},null,{"$f":"IF($C$15=\"Yes\",H104+H102,0)","v":0},null,{"$f":"J104+J102","v":0},null,{"$f":"IF($C$15=\"Yes\",L104+L102,0)","v":0},null,{"$f":"N104+N102","v":0},null,{"$f":"IF($C$15=\"Yes\",P104+P102,0)","v":0},null,{"$f":"R104+R102","v":0},null,{"$f":"IF($C$15=\"Yes\",T104+T102,0)","v":0},null,{"$f":"V104+V102","v":0},null,{"$f":"IF($C$15=\"Yes\",X104+X102,0)","v":0},{"$f":"SUM(V105,R105,N105,J105,F105)","v":0},{"$f":"SUM(X105,T105,P105,L105,H105)","v":0}]
[null,null,null,"Third Party Cost Share (from Tab)",null,null,null,{"$f":"'3rd Party Cost Share'!B16","v":0},null,null,null,{"$f":"'3rd Party Cost Share'!C16","v":0},null,null,null,{"$f":"'3rd Party Cost Share'!D16","v":0},null,null,null,{"$f":"'3rd Party Cost Share'!E16","v":0},null,null,null,{"$f":"'3rd Party Cost Share'!F16","v":0},null,{"$f":"SUM(X106,T106,P106,L106,H106)","v":0}]
[null,null,null,"Total Project Costs (Sponsored + cost share)",null,{"$f":"SUM(F105+H105+H106)","v":0},null,null,null,{"$f":"SUM(J105+L105+L106)","v":0},null,null,null,{"$f":"SUM(N105+P105+P106)","v":0},null,null,null,{"$f":"SUM(R105+T105+T106)","v":0},null,null,null,{"$f":"SUM(V105+X105+X106)","v":0},null,null,{"$f":"SUM(Y105+Z105+Z106)","v":0}]

{"sheet":"Fringe Detail","index":1,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[[22,1,22,2],[3,3,3,4],[8,3,8,4],[0,25,0,26],[1,6,1,8],[1,10,1,12],[1,14,1,16],[1,18,1,20],[1,22,1,24],[0,5,0,8],[0,9,0,12],[0,13,0,16],[0,17,0,20],[0,21,0,24],[1,25,1,26]]}
["Fringe Benefits Break Down",null,null,null,null,"Budget Period 1",null,null,null,"Budget Period 2",null,null,null,"Budget Period 3",null,null,null,"Budget Period 4",null,null,null,"Budget Period 5",null,null,null,"Total"]
[null,null,null,null,null,"SALARY","FRINGE",null,null,"SALARY","FRINGE",null,null,"SALARY","FRINGE",null,null,"SALARY","FRINGE",null,null,"SALARY","FRINGE",null,null,"FRINGE"]
[null,"Principal Investigator",null,null,null,"Total","Sponsor",null,"UM","Total","Sponsor",null,"UM","Total","Sponsor",null,"UM","Total","Sponsor",null,"UM","Total","Sponsor",null,"UM","Sponsor","UM"]
[null,null,null,{"$f":"Budget!C23","v":""},null,{"$f":"SUM(Budget!F24:'Budget'!F26)","v":0},{"$f":"Budget!F24*Salaried_rate+Budget!F25*Salaried_rate+Budget!F26*Salaried_rate","v":0},null,{"$f":"Budget!H24*Salaried_rate+Budget!H25*Salaried_rate+Budget!H26*Salaried_rate","v":0},{"$f":"SUM(Budget!J24:'Budget'!J26)","v":0},{"$f":"Budget!J24*Salaried_rate+Budget!J25*Salaried_rate+Budget!J26*Salaried_rate","v":0},null,{"$f":"Budget!L24*Salaried_rate+Budget!L25*Salaried_rate+Budget!L26*Salaried_rate","v":0},{"$f":"SUM(Budget!N24:'Budget'!N26)","v":0},{"$f":"Budget!N24*Salaried_rate+Budget!N25*Salaried_rate+Budget!N26*Salaried_rate","v":0},null,{"$f":"Budget!P24*Salaried_rate+Budget!P25*Salaried_rate+Budget!P26*Salaried_rate","v":0},{"$f":"SUM(Budget!R24:'Budget'!R26)","v":0},{"$f":"Budget!R24*Salaried_rate+Budget!R25*Salaried_rate+Budget!R26*Salaried_rate","v":0},null,{"$f":"Budget!T24*Salaried_rate+Budget!T25*Salaried_rate+Budget!T26*Salaried_rate","v":0},{"$f":"SUM(Budget!V24:'Budget'!V26)","v":0},{"$f":"Budget!V24*Salaried_rate+Budget!V25*Salaried_rate+Budget!V26*Salaried_rate","v":0},null,{"$f":"Budget!X24*Salaried_rate+Budget!X25*Salaried_rate+Budget!X26*Salaried_rate","v":0},{"$f":"SUM(G4,K4,O4,S4,W4)","v":0},{"$f":"SUM(I4,M4,Q4,U4,Y4)","v":0}]
[]
[]
[]
[null,"Investigator"]
[null,null,null,{"$f":"Budget!C28","v":0},null,{"$f":"SUM(Budget!F29:'Budget'!F31)","v":0},{"$f":"Budget!F29*Salaried_rate+Budget!F30*Salaried_rate+Budget!F31*Salaried_rate","v":0},null,{"$f":"Budget!H29*Salaried_rate+Budget!H30*Salaried_rate+Budget!H31*Salaried_rate","v":0},{"$f":"SUM(Budget!J29:'Budget'!J31)","v":0},{"$f":"Budget!J29*Salaried_rate+Budget!J30*Salaried_rate+Budget!J31*Salaried_rate","v":0},null,{"$f":"Budget!L29*Salaried_rate+Budget!L30*Salaried_rate+Budget!L31*Salaried_rate","v":0},{"$f":"SUM(Budget!N29:'Budget'!N31)","v":0},{"$f":"Budget!N29*Salaried_rate+Budget!N30*Salaried_rate+Budget!N31*Salaried_rate","v":0},null,{"$f":"Budget!P29*Salaried_rate+Budget!P30*Salaried_rate+Budget!P31*Salaried_rate","v":0},{"$f":"SUM(Budget!R29:'Budget'!R31)","v":0},{"$f":"Budget!R29*Salaried_rate+Budget!R30*Salaried_rate+Budget!R31*Salaried_rate","v":0},null,{"$f":"Budget!T29*Salaried_rate+Budget!T30*Salaried_rate+Budget!T31*Salaried_rate","v":0},{"$f":"SUM(Budget!V29:'Budget'!V31)","v":0},{"$f":"Budget!V29*Salaried_rate+Budget!V30*Salaried_rate+Budget!V31*Salaried_rate","v":0},null,{"$f":"Budget!X29*Salaried_rate+Budget!X30*Salaried_rate+Budget!X31*Salaried_rate","v":0},{"$f":"SUM(G9,K9,O9,S9,W9)","v":0},{"$f":"SUM(I9,M9,Q9,U9,Y9)","v":0}]
[]
[]
[]
[null,"Other Monthy"]
[null,null,null,{"$f":"Budget!C33","v":0},null,{"$f":"SUM(Budget!F34:'Budget'!F36)","v":0},{"$f":"Budget!F34*Salaried_rate+Budget!F35*Salaried_rate+Budget!F36*Salaried_rate","v":0},null,{"$f":"Budget!H34*Salaried_rate+Budget!H35*Salaried_rate+Budget!H36*Salaried_rate","v":0},{"$f":"SUM(Budget!J34:'Budget'!J36)","v":0},{"$f":"Budget!J34*Salaried_rate+Budget!J35*Salaried_rate+Budget!J36*Salaried_rate","v":0},null,{"$f":"Budget!L34*Salaried_rate+Budget!L35*Salaried_rate+Budget!L36*Salaried_rate","v":0},{"$f":"SUM(Budget!N34:'Budget'!N36)","v":0},{"$f":"Budget!N34*Salaried_rate+Budget!N35*Salaried_rate+Budget!N36*Salaried_rate","v":0},null,{"$f":"Budget!P34*Salaried_rate+Budget!P35*Salaried_rate+Budget!P36*Salaried_rate","v":0},{"$f":"SUM(Budget!R34:'Budget'!R36)","v":0},{"$f":"Budget!R34*Salaried_rate+Budget!R35*Salaried_rate+Budget!R36*Salaried_rate","v":0},null,{"$f":"Budget!T34*Salaried_rate+Budget!T35*Salaried_rate+Budget!T36*Salaried_rate","v":0},{"$f":"SUM(Budget!V34:'Budget'!V36)","v":0},{"$f":"Budget!V34*Salaried_rate+Budget!V35*Salaried_rate+Budget!V36*Salaried_rate","v":0},null,{"$f":"Budget!X34*Salaried_rate+Budget!X35*Salaried_rate+Budget!X36*Salaried_rate","v":0},{"$f":"SUM(G14,K14,O14,S14,W14)","v":0},{"$f":"SUM(I14,M14,Q14,U14,Y14)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(Z4:Z18)","v":0},{"$f":"SUM(AA4:AA18)","v":0}]

{"sheet":"Salary Cap","index":2,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,3,19],[5,18,5,19],[5,3,5,5],[5,6,5,8],[5,9,5,11],[5,12,5,14],[5,15,5,17]]}
[]
["If an investigator's 12 month salary exceeds the NIH Salary Cap, please enter the Salary Cap numbers into the Budget Tab  base salary for that investigator to calculate sponsored funds. Enter ACTUAL BASE into the correct Base column below to calculate required cost-share, and enter the resulting cost-share figures into the Budget Tab cost-share columns. You may manually adjust blue boxes if effort varies annually. See Effort Conversion Tab to correctly calculate % sponsored and cost-shared effort with Salary Cap for the Cayuse record."]
[]
[]
[" "]
[null,null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"TOTALS"]
["Investigator","Base","Salary Cap","% Effort","Sponsor","Cost Share","% Effort","Sponsor","Cost Share","% Effort","Sponsor","Cost Share","% Effort","Sponsor","Cost Share","% Effort","Sponsor","Cost Share","Sponsor","Cost Share"]
["Sample"]
["Academic Year",157500,{"$f":"'Validation Data'!D2*0.75","v":152775},0.15,{"$f":"$C9*D9","v":22916.25},{"$f":"($B9-$C9)*D9","v":708.75},{"$f":"D9","v":0.15},{"$f":"$C9*G9","v":22916.25},{"$f":"($B9-$C9)*G9","v":708.75},{"$f":"D9","v":0.15},{"$f":"$C9*J9","v":22916.25},{"$f":"($B9-$C9)*J9","v":708.75},{"$f":"D9","v":0.15},{"$f":"$C9*M9","v":22916.25},{"$f":"($B9-$C9)*M9","v":708.75},{"$f":"D9","v":0.15},{"$f":"$C9*P9","v":22916.25},{"$f":"($B9-$C9)*P9","v":708.75},{"$f":"E9+H9+K9+N9+Q9","v":114581.25},3543.75]
["Summer",{"$f":"B9/3","v":52500},{"$f":"'Validation Data'!D2*0.25","v":50925},0.15,{"$f":"$C10*D10","v":7638.75},{"$f":"($B10-$C10)*D10","v":236.25},{"$f":"D10","v":0.15},{"$f":"$C10*G10","v":7638.75},{"$f":"($B10-$C10)*G10","v":236.25},{"$f":"D10","v":0.15},{"$f":"$C10*J10","v":7638.75},{"$f":"($B10-$C10)*J10","v":236.25},{"$f":"D10","v":0.15},{"$f":"$C10*M10","v":7638.75},{"$f":"($B10-$C10)*M10","v":236.25},{"$f":"D10","v":0.15},{"$f":"$C10*P10","v":7638.75},{"$f":"($B10-$C10)*P10","v":236.25},38193.75,1181.25]
["Totals (12 mo)",{"$f":"B9+B10","v":210000},{"$f":"C9+C10","v":203700},null,{"$f":"E9+E10","v":30555},{"$f":"F9+F10","v":945},null,{"$f":"H9+H10","v":30555},{"$f":"I9+I10","v":945},null,{"$f":"K9+K10","v":30555},{"$f":"L9+L10","v":945},null,{"$f":"N9+N10","v":30555},{"$f":"O9+O10","v":945},null,{"$f":"Q9+Q10","v":30555},{"$f":"R9+R10","v":945},{"$f":"E11+H11+K11+N11+Q11","v":152775},{"$f":"F11+I11+L11+O11+R11","v":4725}]
["12-month personnel Salary",210000,{"$f":"'Validation Data'!D2","v":203700},0.15,{"$f":"$C12*D12","v":30555},{"$f":"($B12-$C12)*D12","v":945},{"$f":"D12","v":0.15},{"$f":"$C12*G12","v":30555},{"$f":"($B12-$C12)*G12","v":945},{"$f":"D12","v":0.15},{"$f":"$C12*J12","v":30555},{"$f":"($B12-$C12)*J12","v":945},{"$f":"D12","v":0.15},{"$f":"$C12*M12","v":30555},{"$f":"($B12-$C12)*M12","v":945},{"$f":"D12","v":0.15},{"$f":"$C12*P12","v":30555},{"$f":"($B12-$C12)*P12","v":945},152775,4725]
[" "]
["Academic Year",0,{"$f":"'Validation Data'!D2*0.75","v":152775},0,{"$f":"$C14*D14","v":0},{"$f":"($B14-$C14)*D14","v":0},{"$f":"D14","v":0},{"$f":"$C14*G14","v":0},{"$f":"($B14-$C14)*G14","v":0},{"$f":"D14","v":0},{"$f":"$C14*J14","v":0},{"$f":"($B14-$C14)*J14","v":0},{"$f":"D14","v":0},{"$f":"$C14*M14","v":0},{"$f":"($B14-$C14)*M14","v":0},{"$f":"D14","v":0},{"$f":"$C14*P14","v":0},{"$f":"($B14-$C14)*P14","v":0},{"$f":"E14+H14+K14+N14+Q14","v":0},{"$f":"F14+I14+L14+O14+R14","v":0}]
["Summer",{"$f":"B14/3","v":0},{"$f":"'Validation Data'!D2*0.25","v":50925},0,{"$f":"$C15*D15","v":0},{"$f":"($B15-$C15)*D15","v":0},{"$f":"D15","v":0},{"$f":"$C15*G15","v":0},{"$f":"($B15-$C15)*G15","v":0},{"$f":"D15","v":0},{"$f":"$C15*J15","v":0},{"$f":"($B15-$C15)*J15","v":0},{"$f":"D15","v":0},{"$f":"$C15*M15","v":0},{"$f":"($B15-$C15)*M15","v":0},{"$f":"D15","v":0},{"$f":"$C15*P15","v":0},{"$f":"($B15-$C15)*P15","v":0},0,0]
["Totals (12 mo)",{"$f":"B14+B15","v":0},{"$f":"C14+C15","v":203700},null,{"$f":"E14+E15","v":0},{"$f":"F14+F15","v":0},null,{"$f":"H14+H15","v":0},{"$f":"I14+I15","v":0},null,{"$f":"K14+K15","v":0},{"$f":"L14+L15","v":0},null,{"$f":"N14+N15","v":0},{"$f":"O14+O15","v":0},null,{"$f":"Q14+Q15","v":0},{"$f":"R14+R15","v":0},0,0]
["12-month personnel Salary",0,{"$f":"'Validation Data'!D2","v":203700},0,{"$f":"$C17*D17","v":0},{"$f":"($B17-$C17)*D17","v":0},{"$f":"D17","v":0},{"$f":"$C17*G17","v":0},{"$f":"($B17-$C17)*G17","v":0},{"$f":"D17","v":0},{"$f":"$C17*J17","v":0},{"$f":"($B17-$C17)*J17","v":0},{"$f":"D17","v":0},{"$f":"$C17*M17","v":0},{"$f":"($B17-$C17)*M17","v":0},{"$f":"D17","v":0},{"$f":"$C17*P17","v":0},{"$f":"($B17-$C17)*P17","v":0},0,0]
[" "]
["Academic Year",0,{"$f":"'Validation Data'!D2*0.75","v":152775},0,{"$f":"$C19*D19","v":0},{"$f":"($B19-$C19)*D19","v":0},{"$f":"D19","v":0},{"$f":"$C19*G19","v":0},{"$f":"($B19-$C19)*G19","v":0},{"$f":"D19","v":0},{"$f":"$C19*J19","v":0},{"$f":"($B19-$C19)*J19","v":0},{"$f":"D19","v":0},{"$f":"$C19*M19","v":0},{"$f":"($B19-$C19)*M19","v":0},{"$f":"D19","v":0},{"$f":"$C19*P19","v":0},{"$f":"($B19-$C19)*P19","v":0},{"$f":"E19+H19+K19+N19+Q19","v":0},{"$f":"F19+I19+L19+O19+R19","v":0}]
["Summer",{"$f":"B19/3","v":0},{"$f":"'Validation Data'!D2*0.25","v":50925},0,{"$f":"$C20*D20","v":0},{"$f":"($B20-$C20)*D20","v":0},{"$f":"D20","v":0},{"$f":"$C20*G20","v":0},{"$f":"($B20-$C20)*G20","v":0},{"$f":"D20","v":0},{"$f":"$C20*J20","v":0},{"$f":"($B20-$C20)*J20","v":0},{"$f":"D20","v":0},{"$f":"$C20*M20","v":0},{"$f":"($B20-$C20)*M20","v":0},{"$f":"D20","v":0},{"$f":"$C20*P20","v":0},{"$f":"($B20-$C20)*P20","v":0},0,0]
["Totals (12 mo)",{"$f":"B19+B20","v":0},{"$f":"C19+C20","v":203700},null,{"$f":"E19+E20","v":0},{"$f":"F19+F20","v":0},null,{"$f":"H19+H20","v":0},{"$f":"I19+I20","v":0},null,{"$f":"K19+K20","v":0},{"$f":"L19+L20","v":0},null,{"$f":"N19+N20","v":0},{"$f":"O19+O20","v":0},null,{"$f":"Q19+Q20","v":0},{"$f":"R19+R20","v":0},0,0]
["12-month personnel Salary",0,{"$f":"'Validation Data'!D2","v":203700},0,{"$f":"$C22*D22","v":0},{"$f":"($B22-$C22)*D22","v":0},{"$f":"D22","v":0},{"$f":"$C22*G22","v":0},{"$f":"($B22-$C22)*G22","v":0},{"$f":"D22","v":0},{"$f":"$C22*J22","v":0},{"$f":"($B22-$C22)*J22","v":0},{"$f":"D22","v":0},{"$f":"$C22*M22","v":0},{"$f":"($B22-$C22)*M22","v":0},{"$f":"D22","v":0},{"$f":"$C22*P22","v":0},{"$f":"($B22-$C22)*P22","v":0},0,0]
[" "]
["Academic Year",0,{"$f":"'Validation Data'!D2*0.75","v":152775},0,{"$f":"$C24*D24","v":0},{"$f":"($B24-$C24)*D24","v":0},{"$f":"D24","v":0},{"$f":"$C24*G24","v":0},{"$f":"($B24-$C24)*G24","v":0},{"$f":"D24","v":0},{"$f":"$C24*J24","v":0},{"$f":"($B24-$C24)*J24","v":0},{"$f":"D24","v":0},{"$f":"$C24*M24","v":0},{"$f":"($B24-$C24)*M24","v":0},{"$f":"D24","v":0},{"$f":"$C24*P24","v":0},{"$f":"($B24-$C24)*P24","v":0},{"$f":"E24+H24+K24+N24+Q24","v":0},{"$f":"F24+I24+L24+O24+R24","v":0}]
["Summer",{"$f":"B24/3","v":0},{"$f":"'Validation Data'!D2*0.25","v":50925},0,{"$f":"$C25*D25","v":0},{"$f":"($B25-$C25)*D25","v":0},{"$f":"D25","v":0},{"$f":"$C25*G25","v":0},{"$f":"($B25-$C25)*G25","v":0},{"$f":"D25","v":0},{"$f":"$C25*J25","v":0},{"$f":"($B25-$C25)*J25","v":0},{"$f":"D25","v":0},{"$f":"$C25*M25","v":0},{"$f":"($B25-$C25)*M25","v":0},{"$f":"D25","v":0},{"$f":"$C25*P25","v":0},{"$f":"($B25-$C25)*P25","v":0},0,0]
["Totals (12 mo)",{"$f":"B24+B25","v":0},{"$f":"C24+C25","v":203700},null,{"$f":"E24+E25","v":0},{"$f":"F24+F25","v":0},null,{"$f":"H24+H25","v":0},{"$f":"I24+I25","v":0},null,{"$f":"K24+K25","v":0},{"$f":"L24+L25","v":0},null,{"$f":"N24+N25","v":0},{"$f":"O24+O25","v":0},null,{"$f":"Q24+Q25","v":0},{"$f":"R24+R25","v":0},0,0]
["12-month personnel Salary",0,{"$f":"'Validation Data'!D2","v":203700},0,{"$f":"$C27*D27","v":0},{"$f":"($B27-$C27)*D27","v":0},{"$f":"D27","v":0},{"$f":"$C27*G27","v":0},{"$f":"($B27-$C27)*G27","v":0},{"$f":"D27","v":0},{"$f":"$C27*J27","v":0},{"$f":"($B27-$C27)*J27","v":0},{"$f":"D27","v":0},{"$f":"$C27*M27","v":0},{"$f":"($B27-$C27)*M27","v":0},{"$f":"D27","v":0},{"$f":"$C27*P27","v":0},{"$f":"($B27-$C27)*P27","v":0},0,0]
[" "]
["Academic Year",0,{"$f":"'Validation Data'!D2*0.75","v":152775},0,{"$f":"$C29*D29","v":0},{"$f":"($B29-$C29)*D29","v":0},{"$f":"D29","v":0},{"$f":"$C29*G29","v":0},{"$f":"($B29-$C29)*G29","v":0},{"$f":"D29","v":0},{"$f":"$C29*J29","v":0},{"$f":"($B29-$C29)*J29","v":0},{"$f":"D29","v":0},{"$f":"$C29*M29","v":0},{"$f":"($B29-$C29)*M29","v":0},{"$f":"D29","v":0},{"$f":"$C29*P29","v":0},{"$f":"($B29-$C29)*P29","v":0},{"$f":"E29+H29+K29+N29+Q29","v":0},{"$f":"F29+I29+L29+O29+R29","v":0}]
["Summer",{"$f":"B29/3","v":0},{"$f":"'Validation Data'!D2*0.25","v":50925},0,{"$f":"$C30*D30","v":0},{"$f":"($B30-$C30)*D30","v":0},{"$f":"D30","v":0},{"$f":"$C30*G30","v":0},{"$f":"($B30-$C30)*G30","v":0},{"$f":"D30","v":0},{"$f":"$C30*J30","v":0},{"$f":"($B30-$C30)*J30","v":0},{"$f":"D30","v":0},{"$f":"$C30*M30","v":0},{"$f":"($B30-$C30)*M30","v":0},{"$f":"D30","v":0},{"$f":"$C30*P30","v":0},{"$f":"($B30-$C30)*P30","v":0},0,0]
["Totals (12 mo)",{"$f":"B29+B30","v":0},{"$f":"C29+C30","v":203700},null,{"$f":"E29+E30","v":0},{"$f":"F29+F30","v":0},null,{"$f":"H29+H30","v":0},{"$f":"I29+I30","v":0},null,{"$f":"K29+K30","v":0},{"$f":"L29+L30","v":0},null,{"$f":"N29+N30","v":0},{"$f":"O29+O30","v":0},null,{"$f":"Q29+Q30","v":0},{"$f":"R29+R30","v":0},0,0]
["12-month personnel Salary",0,{"$f":"'Validation Data'!D2","v":203700},0,{"$f":"$C32*D32","v":0},{"$f":"($B32-$C32)*D32","v":0},{"$f":"D32","v":0},{"$f":"$C32*G32","v":0},{"$f":"($B32-$C32)*G32","v":0},{"$f":"D32","v":0},{"$f":"$C32*J32","v":0},{"$f":"($B32-$C32)*J32","v":0},{"$f":"D32","v":0},{"$f":"$C32*M32","v":0},{"$f":"($B32-$C32)*M32","v":0},{"$f":"D32","v":0},{"$f":"$C32*P32","v":0},{"$f":"($B32-$C32)*P32","v":0},0,0]
[" "]
["Academic Year",0,{"$f":"'Validation Data'!D2*0.75","v":152775},0,{"$f":"$C34*D34","v":0},{"$f":"($B34-$C34)*D34","v":0},{"$f":"D34","v":0},{"$f":"$C34*G34","v":0},{"$f":"($B34-$C34)*G34","v":0},{"$f":"D34","v":0},{"$f":"$C34*J34","v":0},{"$f":"($B34-$C34)*J34","v":0},{"$f":"D34","v":0},{"$f":"$C34*M34","v":0},{"$f":"($B34-$C34)*M34","v":0},{"$f":"D34","v":0},{"$f":"$C34*P34","v":0},{"$f":"($B34-$C34)*P34","v":0},{"$f":"E34+H34+K34+N34+Q34","v":0},{"$f":"F34+I34+L34+O34+R34","v":0}]
["Summer",{"$f":"B34/3","v":0},{"$f":"'Validation Data'!D2*0.25","v":50925},0,{"$f":"$C35*D35","v":0},{"$f":"($B35-$C35)*D35","v":0},{"$f":"D35","v":0},{"$f":"$C35*G35","v":0},{"$f":"($B35-$C35)*G35","v":0},{"$f":"D35","v":0},{"$f":"$C35*J35","v":0},{"$f":"($B35-$C35)*J35","v":0},{"$f":"D35","v":0},{"$f":"$C35*M35","v":0},{"$f":"($B35-$C35)*M35","v":0},{"$f":"D35","v":0},{"$f":"$C35*P35","v":0},{"$f":"($B35-$C35)*P35","v":0},0,0]
["Totals (12 mo)",{"$f":"B34+B35","v":0},{"$f":"C34+C35","v":203700},null,{"$f":"E34+E35","v":0},{"$f":"F34+F35","v":0},null,{"$f":"H34+H35","v":0},{"$f":"I34+I35","v":0},null,{"$f":"K34+K35","v":0},{"$f":"L34+L35","v":0},null,{"$f":"N34+N35","v":0},{"$f":"O34+O35","v":0},null,{"$f":"Q34+Q35","v":0},{"$f":"R34+R35","v":0},0,0]
["12-month personnel Salary",0,{"$f":"'Validation Data'!D2","v":203700},0,{"$f":"$C37*D37","v":0},{"$f":"($B37-$C37)*D37","v":0},{"$f":"D37","v":0},{"$f":"$C37*G37","v":0},{"$f":"($B37-$C37)*G37","v":0},{"$f":"D37","v":0},{"$f":"$C37*J37","v":0},{"$f":"($B37-$C37)*J37","v":0},{"$f":"D37","v":0},{"$f":"$C37*M37","v":0},{"$f":"($B37-$C37)*M37","v":0},{"$f":"D37","v":0},{"$f":"$C37*P37","v":0},{"$f":"($B37-$C37)*P37","v":0},0,0]

{"sheet":"Special Course Fees","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,6],[10,0,10,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3]]}
[]
["Special Course Fees Per Year"]
[null,null,null,null,"# students","Special Course Credit hours/semester","Course Fees"]
["Fine Art Courses",null,null,null,null,null,{"$f":"E4*F4*'Validation Data'!E21*2","v":0}]
["Broadcast and Film/Video Courses",null,null,null,null,null,{"$f":"E5*F5*'Validation Data'!E22*2","v":0}]
["Communication Sciences & Disorders Courses",null,null,null,null,null,{"$f":"E6*F6*'Validation Data'!E23*2","v":0}]
["Teacher Education Courses",null,null,null,null,null,{"$f":"E7*F7*'Validation Data'!E24*2","v":0}]
["Business Courses",null,null,null,null,null,{"$f":"E8*F8*'Validation Data'!E25*2","v":0}]
["Engineering Courses",null,null,null,null,null,{"$f":"E9*F9*'Validation Data'!E26*2","v":0}]
["Nursing Courses",null,null,null,null,null,{"$f":"E10*F10*'Validation Data'!E27*2","v":0}]
["Performing Arts Courses (prefixes THEA & DANC)",null,null,null,null,null,{"$f":"E11*F11*'Validation Data'!E28*2","v":0}]
[]
[null,null,null,null,null,"Total Fees",{"$f":"SUM(G4:G11)","v":0}]
["Information on special course fees may be found here:"]
["https://www.memphis.edu/usbs/fees/otherfees.php#special"]

{"sheet":"3rd Party Cost Share","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,3,6],[1,0,1,6]]}
[]
["Third Party Cost Share"]
["This tab should only be used if an external partner organization is committing cost share to the sponsored project. Any amounts identified will need to be substantiated with a letter of commitment."]
[]
["ORGANIZATION NAME","Period 1","Period 2","Period 3","Period 4","Period 5","TOTALS"]
[null,null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTALS",{"$f":"SUM(B6:B15)","v":0},{"$f":"SUM(C6:C15)","v":0},{"$f":"SUM(D6:D15)","v":0},{"$f":"SUM(E6:E15)","v":0},{"$f":"SUM(F6:F15)","v":0},0]

{"sheet":"% Effort Conversion","index":5,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,1,33,2],[34,1,34,2],[35,1,35,4],[28,1,30,8],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[1,1,3,11],[11,5,11,6],[9,1,9,2],[9,3,9,4],[9,5,9,6],[10,1,10,2],[10,3,10,4],[10,5,10,6],[14,1,14,11],[9,9,9,10],[10,9,10,10],[4,1,7,6],[4,8,7,11],[17,1,19,8],[20,4,21,4],[20,5,21,5],[20,6,21,6],[20,7,21,7],[20,8,21,8],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,4]]}
[]
[null,"Effort/Calendar Month Calculator for Cayuse Record"]
[]
[]
[null,"        To convert Summer + Academic Year % Effort for 9-month faculty  to Total % Effort and Person Months, enter budgeted % effort yellow boxes and the blue box results in Cayuse Investigator/Research Team section.",null,null,null,null,null,null,"        For 12-month personnel, enter budgeted % effort into yellow box and the blue box results in Cayuse Investigator/ Research Team section."]
[]
[]
[]
[]
[null,"3 months",null,"9 months",null,"Combined",null,null,null,"12 month"]
[null,"Summer Term",null,"Academic Year",null,"9 months and 3 months",null,null,null,"Calendar Year"]
[null,null,null,null,null,"Total"]
[null,"  % effort ","Person\nMonths","  % effort","Person\nMonths","% effort","Person\nMonths",null,null,"  % effort","Person Months"]
[null,0,{"$f":"B14*0.03","v":0},0,{"$f":"D14*0.09","v":0},{"$f":"G14/12*100","v":0},{"$f":"C14+E14","v":0}," ",null,0,{"$f":"J14*0.12","v":0}]
[]
[]
[]
[null,"Salary Cap Sponsored Effort/Calendar Month Calculator                              for Cayuse Record - 9 month faculty"]
[]
[]
[null,null,null,null,"Budgeted % effort","Sponsored Effort","Person Months","Cost Shared Effort","Person Months"]
[]
[null,"Salary Cap AY",null,{"$f":"'Validation Data'!D2*0.75","v":152775},0.15,{"$f":"(D23*E23)/(D25)","v":0.14549999999999999},{"$f":"9*F23","v":1.3094999999999999}," "]
[null,"Salary Cap SU",null,{"$f":"'Validation Data'!D2*0.25","v":50925},0.15,{"$f":"(D24*E24)/(D26)","v":0.14549999999999999},{"$f":"F24*3","v":0.4365}," "]
[null,"Investigator Base AY",null,157500,null,null,null,{"$f":"((D25-D23)*E23)/D25","v":4.4999999999999997E-3},{"$f":"H25*9","v":4.0499999999999994E-2}]
[null,"Investigator Base SU",null,{"$f":"D25/3","v":52500},null,null,null,{"$f":"((D26-D24)*E24)/D26","v":4.4999999999999997E-3},{"$f":"H26*3","v":1.3499999999999998E-2}]
[null,"TOTAL",null,null,null,{"$f":"G27/12","v":0.14549999999999999},{"$f":"G23+G24","v":1.746},{"$f":"I27/12","v":4.4999999999999997E-3},{"$f":"I25+I26","v":5.3999999999999992E-2}]
[]
[null,"Salary Cap Sponsored Effort/Calendar Month Calculator                              for Cayuse Record - 12 month personnel"]
[]
[]
[null,null,null,null,"Budgeted % effort","Sponsored Effort","Person Months","Cost Shared Effort","Person Months"]
[]
[null,"Salary Cap CY",null,{"$f":"'Validation Data'!D2","v":203700},0.15,{"$f":"(D34*E34)/D35","v":0.14549999999999999},{"$f":"12*F34","v":1.746}," "]
[null,"Investigator Base CY",null,210000,null,null,null,{"$f":"((D35-D34)*E34)/D35","v":4.4999999999999997E-3},{"$f":"H35*12","v":5.3999999999999992E-2}]
[null,"TOTAL",null,null,null,{"$f":"G34/12","v":0.14549999999999999},{"$f":"G34","v":1.746},{"$f":"I36/12","v":4.4999999999999997E-3},{"$f":"I35","v":5.3999999999999992E-2}]

{"sheet":"Cayuse Budget","index":6,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,3,3,4],[23,0,23,6],[8,0,8,7],[9,1,10,1]]}
["Summary Budget:"," "]
[]
["Lead PI:",{"$f":"Budget!B3","v":0},"Sponsor:",{"$f":"Budget!B5","v":0}]
[]
[" # of Budget Periods:",{"$f":"Budget!D8","v":0}]
[null,"Project Dates:","Current Period","Entire Project"]
[null,"Start:",{"$f":"Budget!E17","v":"00:00:00"},{"$f":"Budget!B7","v":"00:00:00"}]
[null,"End:",{"$f":"Budget!E18","v":"00:00:00"},{"$f":"Budget!D7","v":"00:00:00"}]
[]
["Cost Sharing","Itemize and Enter in Cost Share  with funding source",{"$f":"Budget!H105","v":0},{"$f":"Budget!Z105","v":0}]
[]
["F&A Rates",null,"Current Period","Entire Project"]
[null,"F&A Rate (1):",{"$f":"Budget!D104","v":0},{"$f":"Budget!D104","v":0}]
[]
["Budget Categories",null,"Current Period","Entire Project"]
[null,"SPONSOR DIRECT COSTS:",{"$f":"Budget!F102","v":0},{"$f":"Budget!Y102","v":0}]
[null,"BASE for F&A Rate (1):",{"$f":"Budget!F103","v":0},{"$f":"Budget!Y103","v":0}]
[null,"INDIRECT COSTS (F&A):",{"$f":"Budget!F104","v":0},{"$f":"Budget!Y104","v":0}," "]
[]
[null,"TOTAL SPONSOR PROPOSED COSTS:",{"$f":"Budget!F105","v":0},{"$f":"Budget!Y105","v":0}]
[null,"Internal Cost Sharing:",{"$f":"Budget!H105","v":0},{"$f":"Budget!Z105","v":0}]
[null,"TOTAL PROJECT COSTS:",{"$f":"Budget!F107","v":0},{"$f":"Budget!Y107","v":0}]

{"sheet":"Validation Data","index":7,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,1,16,4],[17,0,17,3],[18,0,18,3],[19,0,19,3]]}
["Location:","IDC Type:","IDC Rate:","Salary Cap","Fringe Rates:","Travel:","Roles:","Supplies:","Other:","Expiration Date","Yes/No","Participant Support:","Materials and Supplies","Cost Share","Class Hours"]
["Select One","Select One",0.435,203700,0.35859999999999997,"--","Investigator","Laptops/computers/etc","Printing","2022-07-01","Yes","Tuition","Research consumables","No","9hrs/sem"]
["On-Campus","MTDC",0.55000000000000004,null,0.52829999999999999,"Domestic","Principal Investigator","Consumables","Animal per diems",null,"No","Stipends","Equipment less than $5,000","Yes","10hrs/sem"]
["Off-Campus","TDC",0.35,null,7.4399999999999994E-2,"International","Salaried Employee","Laboratory supplies","Human subject incentive",null,null,"Travel allowance","Laptop computer"]
[null,"--",0.26,null,0.14399999999999999,null,null,"Non-capitalized equipment","IMC fees",null,null,"Subsistence","Write In"]
[null,null,0.15,null,1.2E-2,null,null,"Write in","Animal purchase and shipping",null,null,"Write in"]
[null,null,0.08,null,null,null,null,null,"Write in"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Reference: ","https://www.memphis.edu/usbs/fees/fees_feecharts_fall2021_spring2022.php",null,null,null,null,"Program Service Fee per hour"]
["Regular Courses",null,null,null,521,null,85]
[]
["Special Course Fees"]
["Fine Art Courses",null,null,null,30]
["Broadcast and Film/Video Courses",null,null,null,30]
["Communication Sciences & Disorders Courses",null,null,null,25]
["Teacher Education Courses",null,null,null,25]
["Business Courses",null,null,null,35]
["Engineering Courses",null,null,null,45]
["Nursing Courses",null,null,null,30]
["Performing Arts Courses (prefixes THEA & DANC)",null,null,null,20]