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

{"sheet":"Budget","index":0,"n_rows":106,"n_cols":29,"rows_kept":106,"cut":false,"hidden":false,"merged":[[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[16,8,16,9],[17,8,17,9],[16,10,16,11],[17,10,17,11],[16,12,16,13],[17,12,17,13],[16,6,16,7],[17,6,17,7],[19,14,19,15],[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],[64,4,64,27],[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],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[17,14,17,15],[17,16,17,17],[17,18,17,19],[17,20,17,21],[18,18,18,19],[16,24,16,25],[16,26,16,27],[17,22,17,23],[17,24,17,25],[17,26,17,27],[18,20,18,21],[16,22,16,23],[18,22,18,23],[93,0,95,0],[18,24,18,25],[18,26,18,27],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[18,14,18,15],[18,16,18,17]]}
["Total Sponsor Cost",{"$f":"AC105","v":0},null,null,"Total Project Cost",null,{"$f":"AC106","v":0}]
["Start Here"]
["PI:",null,null,null,null,null," "]
["Project Title:"," "]
["Sponsor:"," "]
[null," "]
["Start Date:",null,"End Date:"]
["Project Location:",null,"Number budget months:",{"$f":"IF(ISNUMBER(CEILING(DATEDIF($B$7, $D$7, \"m\")/1,1)),CEILING(DATEDIF($B$7, $D$7, \"m\")/1,1),1)","v":0},"(Range 1-12)"]
["IDC Type:",null,"Cost of living increase (%):",null,"(Range 0-10%)"]
["IDC Rate:",null,"Period to begin increase",null,"(Range 1-12)"]
[]
[null,"Cayuse Proposal Number:"]
[null,"Preparer:"]
[null,"Budget Prepared Date:"]
[]
["VERSION DATE",{"$f":"'Validation Data'!J2","v":"2025-06-30"}]
[null,null,"Budget Period Start",null,{"$f":"B7","v":"00:00:00"},null,{"$f":"IF(Number_of_budget_periods>1, E18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>2, G18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>3, I18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>4, K18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>5, M18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>6, O18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>7, Q18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>8, S18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>9, U18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>10, W18+DAY(1), \"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>11, Y18+DAY(1), \"\")","v":""}]
[null,null,"Budget Period End",null,{"$f":"IF($D$7 < EDATE(E17,1), $D$7, EDATE(E17,1)-DAY(1))","v":"00:00:00"},null,{"$f":"IF(Number_of_budget_periods>1,IF($D$7 < EDATE(G17,1), $D$7, EDATE(G17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>2,IF($D$7 < EDATE(I17,1), $D$7, EDATE(I17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>3,IF($D$7 < EDATE(K17,1), $D$7, EDATE(K17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>4,IF($D$7 < EDATE(M17,1), $D$7, EDATE(M17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>5,IF($D$7 < EDATE(O17,1), $D$7, EDATE(O17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>6,IF($D$7 < EDATE(Q17,1), $D$7, EDATE(Q17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>7,IF($D$7 < EDATE(S17,1), $D$7, EDATE(S17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>8,IF($D$7 < EDATE(U17,1), $D$7, EDATE(U17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>9,IF($D$7 < EDATE(W17,1), $D$7, EDATE(W17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>10,IF($D$7 < EDATE(Y17,1), $D$7, EDATE(Y17,1)-DAY(1)),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>11,IF($D$7 < EDATE(AA17,1), $D$7, EDATE(AA17,1)-DAY(1)),\"\")","v":""}]
[null,null,"Number of Days",null,{"$f":"DAY(E18-E17)","v":0},null,{"$f":"IF(Number_of_budget_periods>1,DAY(G18-G17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>2,DAY(I18-I17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>3,DAY(K18-K17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>4,DAY(M18-M17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>5,DAY(O18-O17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>6,DAY(Q18-Q17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>7,DAY(S18-S17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>8,DAY(U18-U17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>9,DAY(W18-W17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>10,DAY(Y18-Y17),\"\")","v":""},null,{"$f":"IF(Number_of_budget_periods>11,DAY(AA18-AA17),\"\")","v":""}]
[null,null,null,null,{"$f":"TEXT(E17,\"mmmm\")","v":"January"},null,{"$f":"TEXT(G17,\"mmmm\")","v":""},null,{"$f":"TEXT(I17,\"mmmm\")","v":""},null,{"$f":"TEXT(K17,\"mmmm\")","v":""},null,{"$f":"TEXT(M17,\"mmmm\")","v":""},null,{"$f":"TEXT(O17,\"mmmm\")","v":""},null,{"$f":"TEXT(Q17,\"mmmm\")","v":""},null,{"$f":"TEXT(S17,\"mmmm\")","v":""},null,{"$f":"TEXT(U17,\"mmmm\")","v":""},null,{"$f":"TEXT(W17,\"mmmm\")","v":""},null,{"$f":"TEXT(Y17,\"mmmm\")","v":""},null,{"$f":"TEXT(AA17,\"mmmm\")","v":""},null,"Totals"]
[null,null,null,null,"% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","% Effort","Sponsor","Sponsor"]
["I. Salaries and Wages - KEY PERSONNEL",null,null,"Base Salary"]
[null,"PRINCIPAL INVESTIGATOR",{"$f":"B3 & \"\"","v":""}]
[null,61266,"Academic Year",null,1,{"$f":"IF(OR(MONTH(E$17) < 6, MONTH(E$17) > 8), IF(Number_of_budget_periods > 0, $D24*E24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(OR(MONTH(G$17) < 6, MONTH(G$17) > 8), $D24*G24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(OR(MONTH(I$17) < 6, MONTH(I$17) > 8), $D24*I24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(OR(MONTH(K$17) < 6, MONTH(K$17) > 8), $D24*K24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(OR(MONTH(M$17) < 6, MONTH(M$17) > 8), $D24*M24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(OR(MONTH(O$17) < 6, MONTH(O$17) > 8), $D24*O24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(OR(MONTH(Q$17) < 6, MONTH(Q$17) > 8), $D24*Q24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(OR(MONTH(S$17) < 6, MONTH(S$17) > 8), $D24*S24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(OR(MONTH(U$17) < 6, MONTH(U$17) > 8), $D24*U24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(OR(MONTH(W$17) < 6, MONTH(W$17) > 8), $D24*W24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(OR(MONTH(Y$17) < 6, MONTH(Y$17) > 8), $D24*Y24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E24","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(OR(MONTH(AA$17) < 6, MONTH(AA$17) > 8), $D24*AA24*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"SUM(F24,H24,J24,L24,N24,P24,R24,T24,V24,X24,Z24,AB24)","v":0}]
[null,61254,"Summer",{"$f":"D24/3","v":0},1,{"$f":"IF(AND(MONTH(E$17) >= 6, MONTH(E$17) <= 8), IF(Number_of_budget_periods > 0, $D25*E25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(AND(MONTH(G$17) >= 6, MONTH(G$17) <= 8), $D25*G25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(AND(MONTH(I$17) >= 6, MONTH(I$17) <= 8), $D25*I25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(AND(MONTH(K$17) >= 6, MONTH(K$17) <= 8), $D25*K25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(AND(MONTH(M$17) >= 6, MONTH(M$17) <= 8), $D25*M25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(AND(MONTH(O$17) >= 6, MONTH(O$17) <= 8), $D25*O25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(AND(MONTH(Q$17) >= 6, MONTH(Q$17) <= 8), $D25*Q25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(AND(MONTH(S$17) >= 6, MONTH(S$17) <= 8), $D25*S25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(AND(MONTH(U$17) >= 6, MONTH(U$17) <= 8), $D25*U25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(AND(MONTH(W$17) >= 6, MONTH(W$17) <= 8), $D25*W25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(AND(MONTH(Y$17) >= 6, MONTH(Y$17) <= 8), $D25*Y25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E25","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(AND(MONTH(AA$17) >= 6, MONTH(AA$17) <= 8), $D25*AA25*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"SUM(F25,H25,J25,L25,N25,P25,R25,T25,V25,X25,Z25,AB25)","v":0}]
[null,61266,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, (IF(AND(MONTH(E$17) < 7, YEAR(E$17)=YEAR($B$7)),$D26*E26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*E26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 1, (IF(AND(MONTH(G$17) < 7, YEAR(G$17)=YEAR($B$7)),$D26*G26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*G26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 2, (IF(AND(MONTH(I$17) < 7, YEAR(I$17)=YEAR($B$7)),$D26*I26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*I26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 3, (IF(AND(MONTH(K$17) < 7, YEAR(K$17)=YEAR($B$7)),$D26*K26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*K26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 4, (IF(AND(MONTH(M$17) < 7, YEAR(M$17)=YEAR($B$7)),$D26*M26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*M26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 5, (IF(AND(MONTH(O$17) < 7, YEAR(O$17)=YEAR($B$7)),$D26*O26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*O26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 6, (IF(AND(MONTH(Q$17) < 7, YEAR(Q$17)=YEAR($B$7)),$D26*Q26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*Q26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 7, (IF(AND(MONTH(S$17) < 7, YEAR(S$17)=YEAR($B$7)),$D26*S26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*S26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 8, (IF(AND(MONTH(U$17) < 7, YEAR(U$17)=YEAR($B$7)),$D26*U26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*U26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 9, (IF(AND(MONTH(W$17) < 7, YEAR(W$17)=YEAR($B$7)),$D26*W26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*W26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 10, (IF(AND(MONTH(Y$17) < 7, YEAR(Y$17)=YEAR($B$7)),$D26*Y26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*Y26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E26","v":1},{"$f":"IF(Number_of_budget_periods > 11, (IF(AND(MONTH(AA$17) < 7, YEAR(AA$17)=YEAR($B$7)),$D26*AA26*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D26*AA26*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"SUM(F26,H26,J26,L26,N26,P26,R26,T26,V26,X26,Z26,AB26)","v":0}]
[]
[null,"INVESTIGATOR"]
[null,61266,"Academic Year",null,1,{"$f":"IF(OR(MONTH(E$17) < 6, MONTH(E$17) > 8), IF(Number_of_budget_periods > 0, $D29*E29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(OR(MONTH(G$17) < 6, MONTH(G$17) > 8), $D29*G29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(OR(MONTH(I$17) < 6, MONTH(I$17) > 8), $D29*I29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(OR(MONTH(K$17) < 6, MONTH(K$17) > 8), $D29*K29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(OR(MONTH(M$17) < 6, MONTH(M$17) > 8), $D29*M29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(OR(MONTH(O$17) < 6, MONTH(O$17) > 8), $D29*O29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(OR(MONTH(Q$17) < 6, MONTH(Q$17) > 8), $D29*Q29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(OR(MONTH(S$17) < 6, MONTH(S$17) > 8), $D29*S29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(OR(MONTH(U$17) < 6, MONTH(U$17) > 8), $D29*U29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(OR(MONTH(W$17) < 6, MONTH(W$17) > 8), $D29*W29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(OR(MONTH(Y$17) < 6, MONTH(Y$17) > 8), $D29*Y29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E29","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(OR(MONTH(AA$17) < 6, MONTH(AA$17) > 8), $D29*AA29*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"SUM(F29,H29,J29,L29,N29,P29,R29,T29,V29,X29,Z29,AB29)","v":0}]
[null,61254,"Summer",{"$f":"D29/3","v":0},1,{"$f":"IF(AND(MONTH(E$17) >= 6, MONTH(E$17) <= 8), IF(Number_of_budget_periods > 0, $D30*E30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(AND(MONTH(G$17) >= 6, MONTH(G$17) <= 8), $D30*G30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(AND(MONTH(I$17) >= 6, MONTH(I$17) <= 8), $D30*I30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(AND(MONTH(K$17) >= 6, MONTH(K$17) <= 8), $D30*K30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(AND(MONTH(M$17) >= 6, MONTH(M$17) <= 8), $D30*M30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(AND(MONTH(O$17) >= 6, MONTH(O$17) <= 8), $D30*O30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(AND(MONTH(Q$17) >= 6, MONTH(Q$17) <= 8), $D30*Q30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(AND(MONTH(S$17) >= 6, MONTH(S$17) <= 8), $D30*S30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(AND(MONTH(U$17) >= 6, MONTH(U$17) <= 8), $D30*U30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(AND(MONTH(W$17) >= 6, MONTH(W$17) <= 8), $D30*W30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(AND(MONTH(Y$17) >= 6, MONTH(Y$17) <= 8), $D30*Y30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E30","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(AND(MONTH(AA$17) >= 6, MONTH(AA$17) <= 8), $D30*AA30*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"SUM(F30,H30,J30,L30,N30,P30,R30,T30,V30,X30,Z30,AB30)","v":0}]
[null,61266,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, (IF(AND(MONTH(E$17) < 7, YEAR(E$17)=YEAR($B$7)),$D31*E31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*E31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 1, (IF(AND(MONTH(G$17) < 7, YEAR(G$17)=YEAR($B$7)),$D31*G31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*G31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 2, (IF(AND(MONTH(I$17) < 7, YEAR(I$17)=YEAR($B$7)),$D31*I31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*I31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 3, (IF(AND(MONTH(K$17) < 7, YEAR(K$17)=YEAR($B$7)),$D31*K31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*K31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 4, (IF(AND(MONTH(M$17) < 7, YEAR(M$17)=YEAR($B$7)),$D31*M31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*M31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 5, (IF(AND(MONTH(O$17) < 7, YEAR(O$17)=YEAR($B$7)),$D31*O31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*O31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 6, (IF(AND(MONTH(Q$17) < 7, YEAR(Q$17)=YEAR($B$7)),$D31*Q31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*Q31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 7, (IF(AND(MONTH(S$17) < 7, YEAR(S$17)=YEAR($B$7)),$D31*S31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*S31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 8, (IF(AND(MONTH(U$17) < 7, YEAR(U$17)=YEAR($B$7)),$D31*U31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*U31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 9, (IF(AND(MONTH(W$17) < 7, YEAR(W$17)=YEAR($B$7)),$D31*W31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*W31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 10, (IF(AND(MONTH(Y$17) < 7, YEAR(Y$17)=YEAR($B$7)),$D31*Y31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*Y31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E31","v":1},{"$f":"IF(Number_of_budget_periods > 11, (IF(AND(MONTH(AA$17) < 7, YEAR(AA$17)=YEAR($B$7)),$D31*AA31*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D31*AA31*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"SUM(F31,H31,J31,L31,N31,P31,R31,T31,V31,X31,Z31,AB31)","v":0}]
[]
[null,"MONTHLY"]
[null,61266,"Academic Year",null,1,{"$f":"IF(OR(MONTH(E$17) < 6, MONTH(E$17) > 8), IF(Number_of_budget_periods > 0, $D34*E34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(OR(MONTH(G$17) < 6, MONTH(G$17) > 8), $D34*G34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(OR(MONTH(I$17) < 6, MONTH(I$17) > 8), $D34*I34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(OR(MONTH(K$17) < 6, MONTH(K$17) > 8), $D34*K34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(OR(MONTH(M$17) < 6, MONTH(M$17) > 8), $D34*M34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(OR(MONTH(O$17) < 6, MONTH(O$17) > 8), $D34*O34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(OR(MONTH(Q$17) < 6, MONTH(Q$17) > 8), $D34*Q34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(OR(MONTH(S$17) < 6, MONTH(S$17) > 8), $D34*S34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(OR(MONTH(U$17) < 6, MONTH(U$17) > 8), $D34*U34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(OR(MONTH(W$17) < 6, MONTH(W$17) > 8), $D34*W34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(OR(MONTH(Y$17) < 6, MONTH(Y$17) > 8), $D34*Y34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"$E34","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(OR(MONTH(AA$17) < 6, MONTH(AA$17) > 8), $D34*AA34*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/9,0)","v":0},{"$f":"SUM(F34,H34,J34,L34,N34,P34,R34,T34,V34,X34,Z34,AB34)","v":0}]
[null,61254,"Summer",{"$f":"D34/3","v":0},1,{"$f":"IF(AND(MONTH(E$17) >= 6, MONTH(E$17) <= 8), IF(Number_of_budget_periods > 0, $D35*E35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(AND(MONTH(G$17) >= 6, MONTH(G$17) <= 8), $D35*G35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(AND(MONTH(I$17) >= 6, MONTH(I$17) <= 8), $D35*I35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(AND(MONTH(K$17) >= 6, MONTH(K$17) <= 8), $D35*K35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(AND(MONTH(M$17) >= 6, MONTH(M$17) <= 8), $D35*M35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(AND(MONTH(O$17) >= 6, MONTH(O$17) <= 8), $D35*O35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(AND(MONTH(Q$17) >= 6, MONTH(Q$17) <= 8), $D35*Q35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(AND(MONTH(S$17) >= 6, MONTH(S$17) <= 8), $D35*S35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(AND(MONTH(U$17) >= 6, MONTH(U$17) <= 8), $D35*U35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(AND(MONTH(W$17) >= 6, MONTH(W$17) <= 8), $D35*W35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(AND(MONTH(Y$17) >= 6, MONTH(Y$17) <= 8), $D35*Y35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"$E35","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(AND(MONTH(AA$17) >= 6, MONTH(AA$17) <= 8), $D35*AA35*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/3,0)","v":0},{"$f":"SUM(F35,H35,J35,L35,N35,P35,R35,T35,V35,X35,Z35,AB35)","v":0}]
[null,61666,"12 Month",null,1,{"$f":"IF(Number_of_budget_periods > 0, (IF(AND(MONTH(E$17) < 7, YEAR(E$17)=YEAR($B$7)),$D36*E36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*E36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 1, (IF(AND(MONTH(G$17) < 7, YEAR(G$17)=YEAR($B$7)),$D36*G36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*G36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 2, (IF(AND(MONTH(I$17) < 7, YEAR(I$17)=YEAR($B$7)),$D36*I36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*I36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 3, (IF(AND(MONTH(K$17) < 7, YEAR(K$17)=YEAR($B$7)),$D36*K36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*K36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 4, (IF(AND(MONTH(M$17) < 7, YEAR(M$17)=YEAR($B$7)),$D36*M36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*M36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 5, (IF(AND(MONTH(O$17) < 7, YEAR(O$17)=YEAR($B$7)),$D36*O36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*O36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 6, (IF(AND(MONTH(Q$17) < 7, YEAR(Q$17)=YEAR($B$7)),$D36*Q36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*Q36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 7, (IF(AND(MONTH(S$17) < 7, YEAR(S$17)=YEAR($B$7)),$D36*S36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*S36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 8, (IF(AND(MONTH(U$17) < 7, YEAR(U$17)=YEAR($B$7)),$D36*U36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*U36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 9, (IF(AND(MONTH(W$17) < 7, YEAR(W$17)=YEAR($B$7)),$D36*W36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*W36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 10, (IF(AND(MONTH(Y$17) < 7, YEAR(Y$17)=YEAR($B$7)),$D36*Y36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*Y36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},{"$f":"$E36","v":1},{"$f":"IF(Number_of_budget_periods > 11, (IF(AND(MONTH(AA$17) < 7, YEAR(AA$17)=YEAR($B$7)),$D36*AA36*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number)/12, $D36*AA36*(1+Cost_of_living_increase)^(3-Cost_of_living_increase_starts_on_Budget_Period_number)/12)),0)","v":0},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)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D39*G39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D39*I39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D39*K39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D39*M39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 5, $D39*O39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 6, $D39*Q39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 7, $D39*S39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 8, $D39*U39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 9, $D39*W39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 10, $D39*Y39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E39","v":1},{"$f":"IF(Number_of_budget_periods > 11, $D39*AA39*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"SUM(F39,H39,J39,L39,N39,P39,R39,T39,V39,X39,Z39,AB39)","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)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 1, $D41*G41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D41*I41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 3, $D41*K41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 4, $D41*M41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 5, $D41*O41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 6, $D41*Q41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 7, $D41*S41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 8, $D41*U41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 9, $D41*W41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 10, $D41*Y41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"$E41","v":1},{"$f":"IF(Number_of_budget_periods > 11, $D41*AA41*(1+Cost_of_living_increase)^(2-Cost_of_living_increase_starts_on_Budget_Period_number), 0)/12","v":0},{"$f":"SUM(F41,H41,J41,L41,N41,P41,R41,T41,V41,X41,Z41,AB41)","v":0}]
[]
[null,"STUDENT EMPLOYEES"]
["Graduate Assistants","GA Type","# students","Rate/Month"]
["1. Academic year","--",null,null,1,{"$f":" IF(Number_of_budget_periods > 0,IF(OR(MONTH(E$17) < 6, MONTH(E$17) > 8), $C45*$D45*E45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(OR(MONTH(G$17) < 6, MONTH(G$17) > 8),  $C45*$D45*G45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 2,IF(OR(MONTH(I$17) < 6, MONTH(I$17) > 8),  $C45*$D45*I45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 3,IF(OR(MONTH(K$17) < 6, MONTH(K$17) > 8), $C45*$D45*K45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 4,IF(OR(MONTH(M$17) < 6, MONTH(M$17) > 8), $C45*$D45*M45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 5, IF(OR(MONTH(O$17) < 6, MONTH(O$17) > 8),$C45*$D45*O45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 6,IF(OR(MONTH(Q$17) < 6, MONTH(Q$17) > 8), $C45*$D45*Q45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 7,IF(OR(MONTH(S$17) < 6, MONTH(S$17) > 8), $C45*$D45*S45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 8,IF(OR(MONTH(U$17) < 6, MONTH(U$17) > 8), $C45*$D45*U45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 9,IF(OR(MONTH(W$17) < 6, MONTH(W$17) > 8), $C45*$D45*W45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":" IF(Number_of_budget_periods > 10, IF(OR(MONTH(Y$17) < 6, MONTH(Y$17) > 8), $C45*$D45*Y45,0),0)","v":0},{"$f":"$E45","v":1},{"$f":"IF(Number_of_budget_periods > 11,IF(OR(MONTH(AA$17) < 6, MONTH(AA$17) > 8),  $C45*$D45*AA45,0),0)","v":0},{"$f":"SUM(F45,H45,J45,L45,N45,P45,R45,T45,V45,X45,Z45,AB45)","v":0}]
["2. Summer","--",null,null,1,{"$f":"IF(Number_of_budget_periods > 0, IF(AND(MONTH(E$17) >= 6, MONTH(E$17) <= 8), $C46*$D46*E46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 1, IF(AND(MONTH(G$17) >= 6, MONTH(G$17) <= 8), $C46*$D46*G46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 2, IF(AND(MONTH(I$17) >= 6, MONTH(I$17) <= 8), $C46*$D46*I46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 3, IF(AND(MONTH(K$17) >= 6, MONTH(K$17) <= 8), $C46*$D46*K46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 4, IF(AND(MONTH(M$17) >= 6, MONTH(M$17) <= 8), $C46*$D46*M46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 5, IF(AND(MONTH(O$17) >= 6, MONTH(O$17) <= 8), $C46*$D46*O46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 6, IF(AND(MONTH(Q$17) >= 6, MONTH(Q$17) <= 8), $C46*$D46*Q46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 7, IF(AND(MONTH(S$17) >= 6, MONTH(S$17) <= 8), $C46*$D46*S46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 8, IF(AND(MONTH(U$17) >= 6, MONTH(U$17) <= 8), $C46*$D46*U46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 9, IF(AND(MONTH(W$17) >= 6, MONTH(W$17) <= 8), $C46*$D46*W46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 10, IF(AND(MONTH(Y$17) >= 6, MONTH(Y$17) <= 8), $C46*$D46*Y46,0),0)","v":0},{"$f":"$E46","v":1},{"$f":"IF(Number_of_budget_periods > 11, IF(AND(MONTH(AA$17) >= 6, MONTH(AA$17) <= 8), $C46*$D46*AA46,0),0)","v":0},0]
[]
[null,"Student Workers - hourly"]
[null,"# students","# hours / year","Rate/Hour"]
[null,null,null,null,1,{"$f":"$B50*$C50*$D50*E50/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 1, $B50*$C50*$D50*G50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 2, $B50*$C50*$D50*I50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 3, $B50*$C50*$D50*K50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 4, $B50*$C50*$D50*M50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 5, $B50*$C50*$D50*O50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 6, $B50*$C50*$D50*Q50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 7, $B50*$C50*$D50*S50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 8, $B50*$C50*$D50*U50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 9, $B50*$C50*$D50*W50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 10, $B50*$C50*$D50*Y50,0)/12","v":0},{"$f":"$E50","v":1},{"$f":"IF(Number_of_budget_periods > 11, $B50*$C50*$D50*AA50,0)/12","v":0},{"$f":"SUM(F50,H50,J50,L50,N50,P50,R50,T50,V50,X50,Z50,AB50)","v":0}]
[null,"TEMPORARY EMPLOYEES"]
["# hours","Insurance","Title","Rate/Hour"]
[null,null,null,null,1,{"$f":"$A53*$D53*E53/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 1, $A53*$D53*G53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 2, $A53*$D53*I53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 3, $A53*$D53*K53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 4, $A53*$D53*M53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 5, $A53*$D53*O53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 6, $A53*$D53*Q53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 7, $A53*$D53*S53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 8, $A53*$D53*U53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 9, $A53*$D53*W53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 10, $A53*$D53*Y53,0)/12","v":0},{"$f":"$E53","v":1},{"$f":"IF(Number_of_budget_periods > 11, $A53*$D53*AA53,0)/12","v":0},{"$f":"SUM(F53,H53,J53,L53,N53,P53,R53,T53,V53,X53,Z53,AB53)","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},null,{"$f":"SUM(Z23:Z54)","v":0},null,{"$f":"SUM(AB23:AB54)","v":0},{"$f":"SUM(AC23:AC54)","v":0}]
["III. Fringe Benefits",null," "]
[null,"Salaried Employees (monthly)",null,{"$f":"'Validation Data'!$E$2","v":0.36820000000000003},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},null,{"$f":"$D57*SUM(Z23:Z40)","v":0},null,{"$f":"$D57*SUM(AB23:AB40)","v":0},{"$f":"SUM(F57,H57,J57,L57,N57,P57,R57,T57,V57,X57,Z57,AB57)","v":0}]
[null,"Graduate Assistants - Academic Year",null,{"$f":"IF(B45=\"Biweekly\",'Validation Data'!Q2,IF(B45=\"Monthly\",'Validation Data'!Q3,IF(B45=\"--\",0,\"Select a GA Type\")))","v":0},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},null,{"$f":"SUMPRODUCT((MOD(ROW(Z45:Z47),2)=1)*(Z45:Z47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(AB45:AB47),2)=1)*(AB45:AB47))*GA_Academic_rate","v":0},0]
[null,"Graduate Assistants - Summer",null,{"$f":"IF(B46=\"Biweekly\",'Validation Data'!Q2,IF(B46=\"Monthly\",'Validation Data'!Q3,IF(B46=\"--\",0,\"Select a GA Type\")))","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(F45:F47),2)=0)*(F45:F47))*GA_Summer_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_Summer_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(R45:R47),2)=0)*(R45:R47))*GA_Summer_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(T45:T47),2)=0)*(T45:T47))*GA_Summer_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},null,{"$f":"SUMPRODUCT((MOD(ROW(Z45:Z47),2)=0)*(Z45:Z47))*GA_Academic_rate","v":0},null,{"$f":"SUMPRODUCT((MOD(ROW(AB45:AB47),2)=0)*(AB45:AB47))*GA_Academic_rate","v":0},0]
[null,"Student Workers (undergraduate)",null,{"$f":"IF(B45=\"Biweekly\",'Validation Data'!Q2,IF(B45=\"Monthly\",'Validation Data'!Q3,IF(B45=\"--\",0,\"Select a GA Type\")))","v":0},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},null,{"$f":"$D60*Z50","v":0},null,{"$f":"$D60*AB50","v":0},0]
[null,"Hourly Employees",null,{"$f":"'Validation Data'!$E$3","v":0.42170000000000002},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},null,{"$f":"$D61*SUM(Z41:Z42)","v":0},null,{"$f":"$D61*SUM(AB41:AB42)","v":0},0]
[null,"Temporary Employees (No Insurance)",null,{"$f":"'Validation Data'!$E$4","v":6.93E-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":"$D62*SUMIF($B53:$B53,\"No\",L53:L54)","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":"$D62*SUMIF($B53:$B53,\"No\",T53:T54)","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},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"No\",$B53:$B54)),Z53:Z54)*Temp_rate","v":0},null,{"$f":"$D62*SUMIF($B53:$B53,\"No\",AB53:AB54)","v":0},0]
[null,"Tempoary Employees (Insurance)",null,{"$f":"'Validation Data'!$E$5","v":6.93E-2},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":"$D63*SUMIF($B53:$B53,\"Yes\",L53:L54)","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":"$D63*SUMIF($B53:$B53,\"Yes\",T53:T54)","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},null,{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH(\"Yes\",$B53:$B54)),Z53:Z54)*Temp_no_insurance_rate","v":0},null,{"$f":"$D63*SUMIF($B53:$B53,\"Yes\",AB53:AB54)","v":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},null,{"$f":"SUM(Z57:Z63)","v":0},null,{"$f":"SUM(AB57:AB63)","v":0},{"$f":"SUM(AC57:AC63)","v":0}]
["IV. Equipment > $5,000",null,"Name of Instrument",null,"The total requested for all budget items below this point should be entered in the first month column only."]
[null," ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F66","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," `"]
[null,null,null,"Subtotal - Equipment",null,{"$f":"SUM(F66:F67)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC66:AC67)","v":0}]
["V. Travel","Select domestic or international"]
[null,"--",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F70","v":0}]
[]
[null,null,null,"Subtotal - Travel",null,{"$f":"SUM(F70:F71)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC70:AC71)","v":0}]
["VI. Participant Support",null,"# Participants","Amount"]
[null,null,null,null,1,{"$f":"$C74*$D74*$E74","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F74","v":0}]
[]
[null,null,null,"Subtotal - Participant Support",null,{"$f":"SUM(F74:F75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC74:AC75)","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,null,null,null,null,{"$f":"F79","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,null,null,null,null,{"$f":"F81","v":0}]
[]
[null,"Consultant/Contractual 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,null,null,null,null,{"$f":"F84","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,null,null,null,null,{"$f":"F86","v":0}]
[]
[null,"Subawards"]
[null,"Organization Name",null,null,null,"Amount","Exclude","Include"]
[null," ",null,null,null,0,{"$f":"IF(F90<25000,0,(F90-25000))","v":0},{"$f":"F90-G90","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F90","v":0}]
[]
[null,"Other - Tuition/Fees for Graduate Students"]
[null,"Percent Increase","Number of Students","Hours"]
[null,null,0,0,1,{"$f":"('Validation Data'!E18*MIN($D94,10)*(1+$B$94)+MIN($D94, 10)*'Validation Data'!G18)*E94*2*$C$94","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F94","v":0}]
[null,null,"Special Course Fees (from Tab)",{"$f":"'Special Course Fees'!G13","v":0},1,{"$f":"$D95*E95","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F95","v":0}]
[null,null,null,"Subtotal - Tuition and Fees",null,{"$f":"SUM(F94:F95)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F96","v":0}]
[null,"Other","Items"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F98","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F100","v":0}]
["TOTALS"]
[null,null,null,"Total Direct Costs"," ",{"$f":"SUM(F55,F64,F72,F68,F100,F76)","v":0},null,{"$f":"SUM(H55,H64,H72,H68,H100,H76)","v":0},null,{"$f":"SUM(J55,J64,J72,J68,J100,J76)","v":0},null,{"$f":"SUM(L55,L64,L72,L68,L100,L76)","v":0},null,{"$f":"SUM(N55,N64,N72,N68,N100,N76)","v":0},null,{"$f":"SUM(P55,P64,P72,P68,P100,P76)","v":0},null,{"$f":"SUM(R55,R64,R72,R68,R100,R76)","v":0},null,{"$f":"SUM(T55,T64,T72,T68,T100,T76)","v":0},null,{"$f":"SUM(V55,V64,V72,V68,V100,V76)","v":0},null,{"$f":"SUM(X55,X64,X72,X68,X100,X76)","v":0},null,{"$f":"SUM(Z55,Z64,Z72,Z68,Z100,Z76)","v":0},null,{"$f":"SUM(AB55,AB64,AB72,AB68,AB100,AB76)","v":0},{"$f":"SUM(N102,L102,J102,H102,F102,P102,R102,T102,V102,X102,Z102,AB102)","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-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-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-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-V76-V96-V68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", X102,X102-X76-X96-X68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", Z102,Z102-Z76-Z96-Z68)","v":0},null,{"$f":"IF($C$104 = \"TDC\", AB102,AB102-AB76-AB96-AB68)","v":0},{"$f":"SUM(N103,L103,J103,H103,F103,P103,R103,T103,V103,X103,Z103,AB103)","v":0}]
["Facilities & Admin Costs",null,{"$f":"$B$9","v":0},{"$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$104=\"MTDC\", $D$104*H103, IF($C$104=\"TDC\", $D$104*H102,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$104=\"MTDC\", $D$104*L103, IF($C$104=\"TDC\", $D$104*L102,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$104=\"MTDC\", $D$104*P103, IF($C$104=\"TDC\", $D$104*P102,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$104=\"MTDC\", $D$104*T103, IF($C$104=\"TDC\", $D$104*T102,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$104=\"MTDC\", $D$104*X103, IF($C$104=\"TDC\", $D$104*X102,0))","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*Z103, IF($C$104=\"TDC\", $D$104*Z102,0))","v":0},null,{"$f":"IF($C$104=\"MTDC\", $D$104*AB103, IF($C$104=\"TDC\", $D$104*AB102,0))","v":0},{"$f":"SUM(N104,L104,J104,H104,F104,P104,R104,T104,V104,X104,Z104,AB104)","v":0}]
[null,null,null,"Total Sponsor Costs/Total Cost Share",null,{"$f":"F104+F102","v":0},null,{"$f":"H104+H102","v":0},null,{"$f":"J104+J102","v":0},null,{"$f":"L104+L102","v":0},null,{"$f":"N104+N102","v":0},null,{"$f":"P104+P102","v":0},null,{"$f":"R104+R102","v":0},null,{"$f":"T104+T102","v":0},null,{"$f":"V104+V102","v":0},null,{"$f":"X104+X102","v":0},null,{"$f":"Z104+Z102","v":0},null,{"$f":"AB104+AB102","v":0},{"$f":"SUM(N105,L105,J105,H105,F105,P105,R105,T105,V105,X105,Z105,AB105)","v":0}]
[null,null,null,"Total Project Costs (Sponsored + cost share)",null,{"$f":"SUM(F105:F105)","v":0},null,{"$f":"SUM(H105:H105)","v":0},null,{"$f":"SUM(J105:J105)","v":0},null,{"$f":"SUM(L105:L105)","v":0},null,{"$f":"SUM(N105:N105)","v":0},null,{"$f":"SUM(P105:P105)","v":0},null,{"$f":"SUM(R105:R105)","v":0},null,{"$f":"SUM(T105:T105)","v":0},null,{"$f":"SUM(V105:V105)","v":0},null,{"$f":"SUM(X105:X105)","v":0},null,{"$f":"SUM(Z105:Z105)","v":0},null,{"$f":"SUM(AB105:AB105)","v":0},{"$f":"SUM(F106,H106,J106,L106,N106,P106,R106,T106,V106,X106,Z106,AB106)","v":0}]

{"sheet":"Fringe Detail","index":1,"n_rows":22,"n_cols":42,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,17,1,19],[22,1,22,2],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[3,3,3,4],[8,3,8,4],[13,3,13,4],[1,35,1,37],[1,38,1,40],[1,20,1,22],[1,23,1,25],[1,26,1,28],[1,29,1,31],[1,32,1,34]]}
[]
["Fringe Benefits Break Down",null,null,null,null,"Budget Period 1",null,null,"Budget Period 2",null,null,"Budget Period 3",null,null,"Budget Period 4",null,null,"Budget Period 5",null,null,"Budget Period 6",null,null,"Budget Period 7",null,null,"Budget Period 8",null,null,"Budget Period 9",null,null,"Budget Period 10",null,null,"Budget Period 11",null,null,"Budget Period 12",null,null,"Total"]
[null,"Principal Investigator",null,null,null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Total Salary","Sponsor",null,"Sponsor"]
[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":"SUM(Budget!H24:'Budget'!H26)","v":0},{"$f":"Budget!H24*Salaried_rate+Budget!H25*Salaried_rate+Budget!H26*Salaried_rate","v":0},null,{"$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":"SUM(Budget!L24:'Budget'!L26)","v":0},{"$f":"Budget!L24*Salaried_rate+Budget!L25*Salaried_rate+Budget!L26*Salaried_rate","v":0},null,{"$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":"SUM(Budget!P24:'Budget'!P26)","v":0},{"$f":"Budget!P24*Salaried_rate+Budget!P25*Salaried_rate+Budget!P26*Salaried_rate","v":0},null,{"$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":"SUM(Budget!T24:'Budget'!T26)","v":0},{"$f":"Budget!T24*Salaried_rate+Budget!T25*Salaried_rate+Budget!T26*Salaried_rate","v":0},null,{"$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":"SUM(Budget!X24:'Budget'!X26)","v":0},{"$f":"Budget!X24*Salaried_rate+Budget!X25*Salaried_rate+Budget!X26*Salaried_rate","v":0},null,{"$f":"SUM(Budget!Z24:'Budget'!Z26)","v":0},{"$f":"Budget!Z24*Salaried_rate+Budget!Z25*Salaried_rate+Budget!Z26*Salaried_rate","v":0},null,{"$f":"SUM(Budget!AB24:'Budget'!AB26)","v":0},{"$f":"Budget!AB24*Salaried_rate+Budget!AB25*Salaried_rate+Budget!AB26*Salaried_rate","v":0},null,{"$f":"SUM(G4,J4,M4,P4,S4,V4,Y4,AB4,AE4,AH4,AK4,AN4)","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":"SUM(Budget!H29:'Budget'!H31)","v":0},{"$f":"Budget!H29*Salaried_rate+Budget!H30*Salaried_rate+Budget!H31*Salaried_rate","v":0},null,{"$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":"SUM(Budget!L29:'Budget'!L31)","v":0},{"$f":"Budget!L29*Salaried_rate+Budget!L30*Salaried_rate+Budget!L31*Salaried_rate","v":0},null,{"$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":"SUM(Budget!P29:'Budget'!P31)","v":0},{"$f":"Budget!P29*Salaried_rate+Budget!P30*Salaried_rate+Budget!P31*Salaried_rate","v":0},null,{"$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":"SUM(Budget!T29:'Budget'!T31)","v":0},{"$f":"Budget!T29*Salaried_rate+Budget!T30*Salaried_rate+Budget!T31*Salaried_rate","v":0},null,{"$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":"SUM(Budget!X29:'Budget'!X31)","v":0},{"$f":"Budget!X29*Salaried_rate+Budget!X30*Salaried_rate+Budget!X31*Salaried_rate","v":0},null,{"$f":"SUM(Budget!Z29:'Budget'!Z31)","v":0},{"$f":"Budget!Z29*Salaried_rate+Budget!Z30*Salaried_rate+Budget!Z31*Salaried_rate","v":0},null,{"$f":"SUM(Budget!AB29:'Budget'!AB31)","v":0},{"$f":"Budget!AB29*Salaried_rate+Budget!AB30*Salaried_rate+Budget!AB31*Salaried_rate","v":0},null,{"$f":"SUM(G9,J9,M9,P9,S9,V9,Y9,AB9,AE9,AH9,AK9,AN9)","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":"SUM(Budget!H34:'Budget'!H36)","v":0},{"$f":"Budget!H34*Salaried_rate+Budget!H35*Salaried_rate+Budget!H36*Salaried_rate","v":0},null,{"$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":"SUM(Budget!L34:'Budget'!L36)","v":0},{"$f":"Budget!L34*Salaried_rate+Budget!L35*Salaried_rate+Budget!L36*Salaried_rate","v":0},null,{"$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":"SUM(Budget!P34:'Budget'!P36)","v":0},{"$f":"Budget!P34*Salaried_rate+Budget!P35*Salaried_rate+Budget!P36*Salaried_rate","v":0},null,{"$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":"SUM(Budget!T34:'Budget'!T36)","v":0},{"$f":"Budget!T34*Salaried_rate+Budget!T35*Salaried_rate+Budget!T36*Salaried_rate","v":0},null,{"$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":"SUM(Budget!X34:'Budget'!X36)","v":0},{"$f":"Budget!X34*Salaried_rate+Budget!X35*Salaried_rate+Budget!X36*Salaried_rate","v":0},null,{"$f":"SUM(Budget!Z34:'Budget'!Z36)","v":0},{"$f":"Budget!Z34*Salaried_rate+Budget!Z35*Salaried_rate+Budget!Z36*Salaried_rate","v":0},null,{"$f":"SUM(Budget!AB34:'Budget'!AB36)","v":0},{"$f":"Budget!AB34*Salaried_rate+Budget!AB35*Salaried_rate+Budget!AB36*Salaried_rate","v":0},null,{"$f":"SUM(G14,J14,M14,P14,S14,V14,Y14,AB14,AE14,AH14,AK14,AN14)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP4:AP18)","v":0}]
[null,null,null," "]

{"sheet":"% Effort Conversion","index":2,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[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]]}
[]
[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}]

{"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/"]

{"sheet":"Cayuse Budget","index":4,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,3,3,4],[20,0,20,6],[8,0,8,7]]}
["Summary Budget:"," "]
[]
["Lead PI:",{"$f":"Budget!B3","v":0},"Sponsor:",{"$f":"Budget!B5","v":" "}]
[]
["* # 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"}]
[]
["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!AC102","v":0}]
[null,"BASE for F&A Rate (1):",{"$f":"Budget!F103","v":0},{"$f":"Budget!AC103","v":0}]
[null,"INDIRECT COSTS (F&A):",{"$f":"Budget!F104","v":0},{"$f":"Budget!AC104","v":0}," "]
[]
[null,"TOTAL SPONSOR PROPOSED COSTS:",{"$f":"Budget!F105","v":0},{"$f":"Budget!AC105","v":0}]
[null,"TOTAL PROJECT COSTS:",{"$f":"Budget!F106","v":0},{"$f":"Budget!AC106","v":0}]

{"sheet":"Validation Data","index":5,"n_rows":28,"n_cols":17,"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","GA Type","GA Fringe Rates"]
["Select One","Select One",0.45,221900,0.36820000000000003,"--","Investigator","Laptops/computers/etc","Printing","2025-06-30","Yes","Tuition","Research consumables","No","9hrs/sem","Select One",9.7000000000000003E-3]
["On-Campus","MTDC",0.46,null,0.42170000000000002,"Domestic","Principal Investigator","Consumables","Animal per diems",null,"No","Stipends","Equipment less than $5,000","Yes","10hrs/sem","Biweekly",4.9599999999999998E-2]
["Off-Campus","TDC",0.56499999999999995,null,6.93E-2,"International","Salaried Employee","Laboratory supplies","Human subject incentive",null,null,"Travel allowance","Laptop computer",null,null,"Monthly"]
[null,"--",0.37,null,6.93E-2,null,null,"Non-capitalized equipment","IMC fees",null,null,"Subsistence","Write In",null,null,"--"]
[null,null,0.26,null,null,null,null,"Write in","Animal purchase and shipping",null,null,"Write in"]
[null,null,0.15,null,null,null,null,null,"Write in"]
[null,null,0.08]
[]
[]
[]
[]
[]
[]
[]
[]
["Reference: ","https://www.memphis.edu/usbs/fees/",null,null,null,null,"Program Service Fee per hour"]
["Regular Courses",null,null,null,553,null,93]
[]
["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,35]
["Teacher Education Courses",null,null,null,25]
["Business Courses",null,null,null,35]
["Engineering Courses",null,null,null,75]
["Nursing Courses",null,null,null,40]
["Performing Arts Courses (prefixes THEA & DANC)",null,null,null,20]