{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover","P(1)","P(2)","P(3)","P(4)","P(5)","Tuition Remission","Non-P(1~5)","Summary(1~5)","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Cover","index":0,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,6,24,21],[19,6,20,10],[13,1,14,4],[13,6,14,6],[19,3,20,4],[10,1,11,4],[23,6,23,19],[10,6,11,29],[16,6,17,6],[13,8,14,10],[16,8,17,10],[19,12,20,29],[0,0,0,29],[3,1,5,4],[3,6,5,29],[7,1,8,4],[7,6,8,29]]}
["Cover Page"]
[]
[]
[null,"Project Name"]
[]
[]
[]
[null,"Sponsor"]
[]
[]
[null,"Principal Investigator"]
[]
[]
[null,"Project Period",null,null,null,null,"begins"]
[]
[]
[null,null,null,null,null,null,"ends"]
[]
[]
[null,null,null,"Inflation Rate",null,null,0.03,null,null,null,null,null,"Note: This is  used to calculate the next year's SALARY BASE in Part A and Part B when you hit the \"Copy Data From Previous Year\" button"]
[]
[]
[]
[null,null,null,null,null,null,"NOTE:DHHS budgets have a salary cap of Executive Level II.  The current cap is:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,228000]
[null,null,null,null,null,null,"Please see: https://www.rsp.wisc.edu/awardmgt/NIHSalCap_change.html for additional salary guidance."]

{"sheet":"P(1)","index":1,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,30],[3,1,3,5],[3,17,3,23],[30,18,30,27],[31,1,31,5],[31,17,31,23],[32,1,32,3],[32,5,32,11],[42,5,42,11],[44,5,44,11],[46,5,46,11],[48,5,48,11],[56,18,56,27],[58,15,58,27],[63,13,63,22],[50,5,50,11],[52,5,52,11],[54,5,54,11],[56,3,56,15]]}
["Personnel Year 1"]
[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,"Year:",null,1]
[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":"SUMIF(N7:N29,\"=Post-Doc Fellows and/or Trainees\",Z7:Z29) + SUMIF(N35:N55,\"=Post-Doc Fellows and/or Trainees\",Z35:Z55)","v":0}]
[null,"A.  Senior / Key Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page.",null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z29) + SUM(Z35:Z55)","v":0},null,{"$f":"SUM(AB7:AB29) + SUM(AB35:AB55)","v":0}]
[null,"Prefix",null,"* First Name",null,"Middle Name",null,"* Last Name",null,"Suffix",null,"* Project Role",null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
["1.",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":"IF(NOT((ISBLANK(P7))),IF((OR(AND(ISBLANK(S7),ISBLANK(U7),ISBLANK(W7)),(S7+U7+W7)=0)),P7,IF((AND((S7>0),((U7+W7)>0))),\"error\",IF((S7>0),(P7*(S7/12)),(P7*((U7+W7)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\"),\"\",(IF(ISBLANK(N7),0,(VLOOKUP(N7,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z7)","v":""},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\",ISBLANK(AB7)),\"\",Z7+AB7)","v":""}]
[]
["2.",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":"IF(NOT((ISBLANK(P9))),IF((OR(AND(ISBLANK(S9),ISBLANK(U9),ISBLANK(W9)),(S9+U9+W9)=0)),P9,IF((AND((S9>0),((U9+W9)>0))),\"error\",IF((S9>0),(P9*(S9/12)),(P9*((U9+W9)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\"),\"\",(IF(ISBLANK(N9),0,(VLOOKUP(N9,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z9)","v":""},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\",ISBLANK(AB9)),\"\",Z9+AB9)","v":""}]
[]
["3.",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":"IF(NOT((ISBLANK(P11))),IF((OR(AND(ISBLANK(S11),ISBLANK(U11),ISBLANK(W11)),(S11+U11+W11)=0)),P11,IF((AND((S11>0),((U11+W11)>0))),\"error\",IF((S11>0),(P11*(S11/12)),(P11*((U11+W11)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\"),\"\",(IF(ISBLANK(N11),0,(VLOOKUP(N11,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z11)","v":""},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\",ISBLANK(AB11)),\"\",Z11+AB11)","v":""}]
[]
["4.",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":"IF(NOT((ISBLANK(P13))),IF((OR(AND(ISBLANK(S13),ISBLANK(U13),ISBLANK(W13)),(S13+U13+W13)=0)),P13,IF((AND((S13>0),((U13+W13)>0))),\"error\",IF((S13>0),(P13*(S13/12)),(P13*((U13+W13)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\"),\"\",(IF(ISBLANK(N13),0,(VLOOKUP(N13,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z13)","v":""},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\",ISBLANK(AB13)),\"\",Z13+AB13)","v":""}]
[]
["5.",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":"IF(NOT((ISBLANK(P15))),IF((OR(AND(ISBLANK(S15),ISBLANK(U15),ISBLANK(W15)),(S15+U15+W15)=0)),P15,IF((AND((S15>0),((U15+W15)>0))),\"error\",IF((S15>0),(P15*(S15/12)),(P15*((U15+W15)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\"),\"\",(IF(ISBLANK(N15),0,(VLOOKUP(N15,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z15)","v":""},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\",ISBLANK(AB15)),\"\",Z15+AB15)","v":""}]
[]
["6.",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":"IF(NOT((ISBLANK(P17))),IF((OR(AND(ISBLANK(S17),ISBLANK(U17),ISBLANK(W17)),(S17+U17+W17)=0)),P17,IF((AND((S17>0),((U17+W17)>0))),\"error\",IF((S17>0),(P17*(S17/12)),(P17*((U17+W17)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\"),\"\",(IF(ISBLANK(N17),0,(VLOOKUP(N17,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z17)","v":""},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\",ISBLANK(AB17)),\"\",Z17+AB17)","v":""}]
[]
["7.",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":"IF(NOT((ISBLANK(P19))),IF((OR(AND(ISBLANK(S19),ISBLANK(U19),ISBLANK(W19)),(S19+U19+W19)=0)),P19,IF((AND((S19>0),((U19+W19)>0))),\"error\",IF((S19>0),(P19*(S19/12)),(P19*((U19+W19)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\"),\"\",(IF(ISBLANK(N19),0,(VLOOKUP(N19,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z19)","v":""},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\",ISBLANK(AB19)),\"\",Z19+AB19)","v":""}]
[]
["8.",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":"IF(NOT((ISBLANK(P21))),IF((OR(AND(ISBLANK(S21),ISBLANK(U21),ISBLANK(W21)),(S21+U21+W21)=0)),P21,IF((AND((S21>0),((U21+W21)>0))),\"error\",IF((S21>0),(P21*(S21/12)),(P21*((U21+W21)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\"),\"\",(IF(ISBLANK(N21),0,(VLOOKUP(N21,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z21)","v":""},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\",ISBLANK(AB21)),\"\",Z21+AB21)","v":""}]
[]
["9.",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":"IF(NOT((ISBLANK(P23))),IF((OR(AND(ISBLANK(S23),ISBLANK(U23),ISBLANK(W23)),(S23+U23+W23)=0)),P23,IF((AND((S23>0),((U23+W23)>0))),\"error\",IF((S23>0),(P23*(S23/12)),(P23*((U23+W23)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\"),\"\",(IF(ISBLANK(N23),0,(VLOOKUP(N23,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z23)","v":""},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\",ISBLANK(AB23)),\"\",Z23+AB23)","v":""}]
[]
["10.",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":"IF(NOT((ISBLANK(P25))),IF((OR(AND(ISBLANK(S25),ISBLANK(U25),ISBLANK(W25)),(S25+U25+W25)=0)),P25,IF((AND((S25>0),((U25+W25)>0))),\"error\",IF((S25>0),(P25*(S25/12)),(P25*((U25+W25)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\"),\"\",(IF(ISBLANK(N25),0,(VLOOKUP(N25,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z25)","v":""},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\",ISBLANK(AB25)),\"\",Z25+AB25)","v":""}]
[]
["11.",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":"IF(NOT((ISBLANK(P27))),IF((OR(AND(ISBLANK(S27),ISBLANK(U27),ISBLANK(W27)),(S27+U27+W27)=0)),P27,IF((AND((S27>0),((U27+W27)>0))),\"error\",IF((S27>0),(P27*(S27/12)),(P27*((U27+W27)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\"),\"\",(IF(ISBLANK(N27),0,(VLOOKUP(N27,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z27)","v":""},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\",ISBLANK(AB27)),\"\",Z27+AB27)","v":""}]
[]
["12.",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":"IF(NOT((ISBLANK(P29))),IF((OR(AND(ISBLANK(S29),ISBLANK(U29),ISBLANK(W29)),(S29+U29+W29)=0)),P29,IF((AND((S29>0),((U29+W29)>0))),\"error\",IF((S29>0),(P29*(S29/12)),(P29*((U29+W29)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\"),\"\",(IF(ISBLANK(N29),0,(VLOOKUP(N29,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z29)","v":""},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\",ISBLANK(AB29)),\"\",Z29+AB29)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Senior/Key Person",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD29)","v":0}]
[null,"B.  Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page."]
[null,"* Number of Personnel",null,null,null,"* Project Role",null,null,null,null,null,null,null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
[null,null,null,null,null,"Post Doctoral Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P35))),IF((OR(AND(ISBLANK(S35),ISBLANK(U35),ISBLANK(W35)),(S35+U35+W35)=0)),P35,IF((AND((S35>0),((U35+W35)>0))),\"error\",IF((S35>0),(P35*(S35/12)),(P35*((U35+W35)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\"),\"\",(IF(ISBLANK(N35),0,(VLOOKUP(N35,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z35)","v":""},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\",ISBLANK(AB35)),\"\",Z35+AB35)","v":""}]
[]
[null,null,null,null,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P37))),IF((OR(AND(ISBLANK(S37),ISBLANK(U37),ISBLANK(W37)),(S37+U37+W37)=0)),P37,IF((AND((S37>0),((U37+W37)>0))),\"error\",IF((S37>0),(P37*(S37/12)),(P37*((U37+W37)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\"),\"\",(IF(ISBLANK(N37),0,(VLOOKUP(N37,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z37)","v":""},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\",ISBLANK(AB37)),\"\",Z37+AB37)","v":""}]
[]
[null,null,null,null,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P39))),IF((OR(AND(ISBLANK(S39),ISBLANK(U39),ISBLANK(W39)),(S39+U39+W39)=0)),P39,IF((AND((S39>0),((U39+W39)>0))),\"error\",IF((S39>0),(P39*(S39/12)),(P39*((U39+W39)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\"),\"\",(IF(ISBLANK(N39),0,(VLOOKUP(N39,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z39)","v":""},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\",ISBLANK(AB39)),\"\",Z39+AB39)","v":""}]
[]
[null,null,null,null,null,"Secretarial / Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P41))),IF((OR(AND(ISBLANK(S41),ISBLANK(U41),ISBLANK(W41)),(S41+U41+W41)=0)),P41,IF((AND((S41>0),((U41+W41)>0))),\"error\",IF((S41>0),(P41*(S41/12)),(P41*((U41+W41)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\"),\"\",(IF(ISBLANK(N41),0,(VLOOKUP(N41,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z41)","v":""},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\",ISBLANK(AB41)),\"\",Z41+AB41)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P43))),IF((OR(AND(ISBLANK(S43),ISBLANK(U43),ISBLANK(W43)),(S43+U43+W43)=0)),P43,IF((AND((S43>0),((U43+W43)>0))),\"error\",IF((S43>0),(P43*(S43/12)),(P43*((U43+W43)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\"),\"\",(IF(ISBLANK(N43),0,(VLOOKUP(N43,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z43)","v":""},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\",ISBLANK(AB43)),\"\",Z43+AB43)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P45))),IF((OR(AND(ISBLANK(S45),ISBLANK(U45),ISBLANK(W45)),(S45+U45+W45)=0)),P45,IF((AND((S45>0),((U45+W45)>0))),\"error\",IF((S45>0),(P45*(S45/12)),(P45*((U45+W45)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\"),\"\",(IF(ISBLANK(N45),0,(VLOOKUP(N45,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z45)","v":""},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\",ISBLANK(AB45)),\"\",Z45+AB45)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P47))),IF((OR(AND(ISBLANK(S47),ISBLANK(U47),ISBLANK(W47)),(S47+U47+W47)=0)),P47,IF((AND((S47>0),((U47+W47)>0))),\"error\",IF((S47>0),(P47*(S47/12)),(P47*((U47+W47)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\"),\"\",(IF(ISBLANK(N47),0,(VLOOKUP(N47,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z47)","v":""},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\",ISBLANK(AB47)),\"\",Z47+AB47)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P49))),IF((OR(AND(ISBLANK(S49),ISBLANK(U49),ISBLANK(W49)),(S49+U49+W49)=0)),P49,IF((AND((S49>0),((U49+W49)>0))),\"error\",IF((S49>0),(P49*(S49/12)),(P49*((U49+W49)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\"),\"\",(IF(ISBLANK(N49),0,(VLOOKUP(N49,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z49)","v":""},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\",ISBLANK(AB49)),\"\",Z49+AB49)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P51))),IF((OR(AND(ISBLANK(S51),ISBLANK(U51),ISBLANK(W51)),(S51+U51+W51)=0)),P51,IF((AND((S51>0),((U51+W51)>0))),\"error\",IF((S51>0),(P51*(S51/12)),(P51*((U51+W51)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\"),\"\",(IF(ISBLANK(N51),0,(VLOOKUP(N51,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z51)","v":""},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\",ISBLANK(AB51)),\"\",Z51+AB51)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P53))),IF((OR(AND(ISBLANK(S53),ISBLANK(U53),ISBLANK(W53)),(S53+U53+W53)=0)),P53,IF((AND((S53>0),((U53+W53)>0))),\"error\",IF((S53>0),(P53*(S53/12)),(P53*((U53+W53)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\"),\"\",(IF(ISBLANK(N53),0,(VLOOKUP(N53,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z53)","v":""},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\",ISBLANK(AB53)),\"\",Z53+AB53)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P55))),IF((OR(AND(ISBLANK(S55),ISBLANK(U55),ISBLANK(W55)),(S55+U55+W55)=0)),P55,IF((AND((S55>0),((U55+W55)>0))),\"error\",IF((S55>0),(P55*(S55/12)),(P55*((U55+W55)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\"),\"\",(IF(ISBLANK(N55),0,(VLOOKUP(N55,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z55)","v":""},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\",ISBLANK(AB55)),\"\",Z55+AB55)","v":""}]
[]
[null,{"$f":"SUM(B35:B55)","v":0},null," ←  Total Number Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Personnel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD35:AD55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wages, and Fringe Benefits ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31+AD57","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,{"$f":"AD59-AD3","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If you are unsure of what to write for Cal. Months, Acad. Months, and Sum. Months, please use this calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointment Type",null,"Percent Effort",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N67=\"Annual\",12*P67,0)","v":0},null,{"$f":"IF(N67=\"Academic\",9*P67,0)","v":0},null,{"$f":"IF(N67=\"Summer\",3*P67,0)","v":0}]

{"sheet":"P(2)","index":2,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[56,18,56,27],[58,15,58,27],[63,13,63,22],[50,5,50,11],[52,5,52,11],[54,5,54,11],[56,3,56,15],[46,5,46,11],[48,5,48,11],[31,1,31,5],[31,17,31,23],[32,1,32,3],[32,5,32,11],[44,5,44,11],[0,0,0,30],[3,1,3,5],[3,17,3,23],[30,18,30,27],[42,5,42,11]]}
["Personnel Year 2"]
[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,"Year:",null,2]
[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":"SUMIF(N7:N29,\"=Post-Doc Fellows and/or Trainees\",Z7:Z29) + SUMIF(N35:N55,\"=Post-Doc Fellows and/or Trainees\",Z35:Z55)","v":0}]
[null,"A.  Senior / Key Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page.",null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z29) + SUM(Z35:Z55)","v":0},null,{"$f":"SUM(AB7:AB29) + SUM(AB35:AB55)","v":0}]
[null,"Prefix",null,"* First Name",null,"Middle Name",null,"* Last Name",null,"Suffix",null,"* Project Role",null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
["1.",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":"IF(NOT((ISBLANK(P7))),IF((OR(AND(ISBLANK(S7),ISBLANK(U7),ISBLANK(W7)),(S7+U7+W7)=0)),P7,IF((AND((S7>0),((U7+W7)>0))),\"error\",IF((S7>0),(P7*(S7/12)),(P7*((U7+W7)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\"),\"\",(IF(ISBLANK(N7),0,(VLOOKUP(N7,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z7)","v":""},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\",ISBLANK(AB7)),\"\",Z7+AB7)","v":""}]
[]
["2.",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":"IF(NOT((ISBLANK(P9))),IF((OR(AND(ISBLANK(S9),ISBLANK(U9),ISBLANK(W9)),(S9+U9+W9)=0)),P9,IF((AND((S9>0),((U9+W9)>0))),\"error\",IF((S9>0),(P9*(S9/12)),(P9*((U9+W9)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\"),\"\",(IF(ISBLANK(N9),0,(VLOOKUP(N9,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z9)","v":""},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\",ISBLANK(AB9)),\"\",Z9+AB9)","v":""}]
[]
["3.",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":"IF(NOT((ISBLANK(P11))),IF((OR(AND(ISBLANK(S11),ISBLANK(U11),ISBLANK(W11)),(S11+U11+W11)=0)),P11,IF((AND((S11>0),((U11+W11)>0))),\"error\",IF((S11>0),(P11*(S11/12)),(P11*((U11+W11)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\"),\"\",(IF(ISBLANK(N11),0,(VLOOKUP(N11,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z11)","v":""},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\",ISBLANK(AB11)),\"\",Z11+AB11)","v":""}]
[]
["4.",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":"IF(NOT((ISBLANK(P13))),IF((OR(AND(ISBLANK(S13),ISBLANK(U13),ISBLANK(W13)),(S13+U13+W13)=0)),P13,IF((AND((S13>0),((U13+W13)>0))),\"error\",IF((S13>0),(P13*(S13/12)),(P13*((U13+W13)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\"),\"\",(IF(ISBLANK(N13),0,(VLOOKUP(N13,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z13)","v":""},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\",ISBLANK(AB13)),\"\",Z13+AB13)","v":""}]
[]
["5.",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":"IF(NOT((ISBLANK(P15))),IF((OR(AND(ISBLANK(S15),ISBLANK(U15),ISBLANK(W15)),(S15+U15+W15)=0)),P15,IF((AND((S15>0),((U15+W15)>0))),\"error\",IF((S15>0),(P15*(S15/12)),(P15*((U15+W15)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\"),\"\",(IF(ISBLANK(N15),0,(VLOOKUP(N15,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z15)","v":""},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\",ISBLANK(AB15)),\"\",Z15+AB15)","v":""}]
[]
["6.",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":"IF(NOT((ISBLANK(P17))),IF((OR(AND(ISBLANK(S17),ISBLANK(U17),ISBLANK(W17)),(S17+U17+W17)=0)),P17,IF((AND((S17>0),((U17+W17)>0))),\"error\",IF((S17>0),(P17*(S17/12)),(P17*((U17+W17)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\"),\"\",(IF(ISBLANK(N17),0,(VLOOKUP(N17,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z17)","v":""},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\",ISBLANK(AB17)),\"\",Z17+AB17)","v":""}]
[]
["7.",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":"IF(NOT((ISBLANK(P19))),IF((OR(AND(ISBLANK(S19),ISBLANK(U19),ISBLANK(W19)),(S19+U19+W19)=0)),P19,IF((AND((S19>0),((U19+W19)>0))),\"error\",IF((S19>0),(P19*(S19/12)),(P19*((U19+W19)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\"),\"\",(IF(ISBLANK(N19),0,(VLOOKUP(N19,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z19)","v":""},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\",ISBLANK(AB19)),\"\",Z19+AB19)","v":""}]
[]
["8.",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":"IF(NOT((ISBLANK(P21))),IF((OR(AND(ISBLANK(S21),ISBLANK(U21),ISBLANK(W21)),(S21+U21+W21)=0)),P21,IF((AND((S21>0),((U21+W21)>0))),\"error\",IF((S21>0),(P21*(S21/12)),(P21*((U21+W21)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\"),\"\",(IF(ISBLANK(N21),0,(VLOOKUP(N21,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z21)","v":""},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\",ISBLANK(AB21)),\"\",Z21+AB21)","v":""}]
[]
["9.",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":"IF(NOT((ISBLANK(P23))),IF((OR(AND(ISBLANK(S23),ISBLANK(U23),ISBLANK(W23)),(S23+U23+W23)=0)),P23,IF((AND((S23>0),((U23+W23)>0))),\"error\",IF((S23>0),(P23*(S23/12)),(P23*((U23+W23)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\"),\"\",(IF(ISBLANK(N23),0,(VLOOKUP(N23,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z23)","v":""},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\",ISBLANK(AB23)),\"\",Z23+AB23)","v":""}]
[]
["10.",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":"IF(NOT((ISBLANK(P25))),IF((OR(AND(ISBLANK(S25),ISBLANK(U25),ISBLANK(W25)),(S25+U25+W25)=0)),P25,IF((AND((S25>0),((U25+W25)>0))),\"error\",IF((S25>0),(P25*(S25/12)),(P25*((U25+W25)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\"),\"\",(IF(ISBLANK(N25),0,(VLOOKUP(N25,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z25)","v":""},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\",ISBLANK(AB25)),\"\",Z25+AB25)","v":""}]
[]
["11.",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":"IF(NOT((ISBLANK(P27))),IF((OR(AND(ISBLANK(S27),ISBLANK(U27),ISBLANK(W27)),(S27+U27+W27)=0)),P27,IF((AND((S27>0),((U27+W27)>0))),\"error\",IF((S27>0),(P27*(S27/12)),(P27*((U27+W27)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\"),\"\",(IF(ISBLANK(N27),0,(VLOOKUP(N27,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z27)","v":""},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\",ISBLANK(AB27)),\"\",Z27+AB27)","v":""}]
[]
["12.",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":"IF(NOT((ISBLANK(P29))),IF((OR(AND(ISBLANK(S29),ISBLANK(U29),ISBLANK(W29)),(S29+U29+W29)=0)),P29,IF((AND((S29>0),((U29+W29)>0))),\"error\",IF((S29>0),(P29*(S29/12)),(P29*((U29+W29)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\"),\"\",(IF(ISBLANK(N29),0,(VLOOKUP(N29,Fringe_Array,2, FALSE)+($AD$2*1%)))) * Z29)","v":""},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\",ISBLANK(AB29)),\"\",Z29+AB29)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Senior/Key Person",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD29)","v":0}]
[null,"B.  Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page."]
[null,"* Number of Personnel",null,null,null,"* Project Role",null,null,null,null,null,null,null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
[null,null,null,null,null,"Post Doctoral Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P35))),IF((OR(AND(ISBLANK(S35),ISBLANK(U35),ISBLANK(W35)),(S35+U35+W35)=0)),P35,IF((AND((S35>0),((U35+W35)>0))),\"error\",IF((S35>0),(P35*(S35/12)),(P35*((U35+W35)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\"),\"\",(IF(ISBLANK(N35),0,(VLOOKUP(N35,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z35)","v":""},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\",ISBLANK(AB35)),\"\",Z35+AB35)","v":""}]
[]
[null,null,null,null,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P37))),IF((OR(AND(ISBLANK(S37),ISBLANK(U37),ISBLANK(W37)),(S37+U37+W37)=0)),P37,IF((AND((S37>0),((U37+W37)>0))),\"error\",IF((S37>0),(P37*(S37/12)),(P37*((U37+W37)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\"),\"\",(IF(ISBLANK(N37),0,(VLOOKUP(N37,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z37)","v":""},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\",ISBLANK(AB37)),\"\",Z37+AB37)","v":""}]
[]
[null,null,null,null,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P39))),IF((OR(AND(ISBLANK(S39),ISBLANK(U39),ISBLANK(W39)),(S39+U39+W39)=0)),P39,IF((AND((S39>0),((U39+W39)>0))),\"error\",IF((S39>0),(P39*(S39/12)),(P39*((U39+W39)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\"),\"\",(IF(ISBLANK(N39),0,(VLOOKUP(N39,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z39)","v":""},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\",ISBLANK(AB39)),\"\",Z39+AB39)","v":""}]
[]
[null,null,null,null,null,"Secretarial / Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P41))),IF((OR(AND(ISBLANK(S41),ISBLANK(U41),ISBLANK(W41)),(S41+U41+W41)=0)),P41,IF((AND((S41>0),((U41+W41)>0))),\"error\",IF((S41>0),(P41*(S41/12)),(P41*((U41+W41)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\"),\"\",(IF(ISBLANK(N41),0,(VLOOKUP(N41,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z41)","v":""},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\",ISBLANK(AB41)),\"\",Z41+AB41)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P43))),IF((OR(AND(ISBLANK(S43),ISBLANK(U43),ISBLANK(W43)),(S43+U43+W43)=0)),P43,IF((AND((S43>0),((U43+W43)>0))),\"error\",IF((S43>0),(P43*(S43/12)),(P43*((U43+W43)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\"),\"\",(IF(ISBLANK(N43),0,(VLOOKUP(N43,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z43)","v":""},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\",ISBLANK(AB43)),\"\",Z43+AB43)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P45))),IF((OR(AND(ISBLANK(S45),ISBLANK(U45),ISBLANK(W45)),(S45+U45+W45)=0)),P45,IF((AND((S45>0),((U45+W45)>0))),\"error\",IF((S45>0),(P45*(S45/12)),(P45*((U45+W45)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\"),\"\",(IF(ISBLANK(N45),0,(VLOOKUP(N45,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z45)","v":""},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\",ISBLANK(AB45)),\"\",Z45+AB45)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P47))),IF((OR(AND(ISBLANK(S47),ISBLANK(U47),ISBLANK(W47)),(S47+U47+W47)=0)),P47,IF((AND((S47>0),((U47+W47)>0))),\"error\",IF((S47>0),(P47*(S47/12)),(P47*((U47+W47)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\"),\"\",(IF(ISBLANK(N47),0,(VLOOKUP(N47,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z47)","v":""},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\",ISBLANK(AB47)),\"\",Z47+AB47)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P49))),IF((OR(AND(ISBLANK(S49),ISBLANK(U49),ISBLANK(W49)),(S49+U49+W49)=0)),P49,IF((AND((S49>0),((U49+W49)>0))),\"error\",IF((S49>0),(P49*(S49/12)),(P49*((U49+W49)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\"),\"\",(IF(ISBLANK(N49),0,(VLOOKUP(N49,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z49)","v":""},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\",ISBLANK(AB49)),\"\",Z49+AB49)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P51))),IF((OR(AND(ISBLANK(S51),ISBLANK(U51),ISBLANK(W51)),(S51+U51+W51)=0)),P51,IF((AND((S51>0),((U51+W51)>0))),\"error\",IF((S51>0),(P51*(S51/12)),(P51*((U51+W51)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\"),\"\",(IF(ISBLANK(N51),0,(VLOOKUP(N51,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z51)","v":""},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\",ISBLANK(AB51)),\"\",Z51+AB51)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P53))),IF((OR(AND(ISBLANK(S53),ISBLANK(U53),ISBLANK(W53)),(S53+U53+W53)=0)),P53,IF((AND((S53>0),((U53+W53)>0))),\"error\",IF((S53>0),(P53*(S53/12)),(P53*((U53+W53)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\"),\"\",(IF(ISBLANK(N53),0,(VLOOKUP(N53,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z53)","v":""},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\",ISBLANK(AB53)),\"\",Z53+AB53)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P55))),IF((OR(AND(ISBLANK(S55),ISBLANK(U55),ISBLANK(W55)),(S55+U55+W55)=0)),P55,IF((AND((S55>0),((U55+W55)>0))),\"error\",IF((S55>0),(P55*(S55/12)),(P55*((U55+W55)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\"),\"\",(IF(ISBLANK(N55),0,(VLOOKUP(N55,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z55)","v":""},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\",ISBLANK(AB55)),\"\",Z55+AB55)","v":""}]
[]
[null,{"$f":"SUM(B35:B55)","v":0},null," ←  Total Number Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Personnel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD35:AD55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wages, and Fringe Benefits ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31+AD57","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,{"$f":"AD59-AD3","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If you are unsure of what to write for Cal. Months, Acad. Months, and Sum. Months, please use this calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointment Type",null,"Percent Effort",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N67=\"Annual\",12*P67,0)","v":0},null,{"$f":"IF(N67=\"Academic\",9*P67,0)","v":0},null,{"$f":"IF(N67=\"Summer\",3*P67,0)","v":0}]

{"sheet":"P(3)","index":3,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,30],[3,1,3,5],[3,17,3,23],[30,18,30,27],[31,1,31,5],[31,17,31,23],[32,1,32,3],[32,5,32,11],[42,5,42,11],[44,5,44,11],[46,5,46,11],[48,5,48,11],[56,18,56,27],[58,15,58,27],[63,13,63,22],[50,5,50,11],[52,5,52,11],[54,5,54,11],[56,3,56,15]]}
["Personnel Year 3"]
[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,"Year:",null,3]
[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":"SUMIF(N7:N29,\"=Post-Doc Fellows and/or Trainees\",Z7:Z29) + SUMIF(N35:N55,\"=Post-Doc Fellows and/or Trainees\",Z35:Z55)","v":0}]
[null,"A.  Senior / Key Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page.",null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z29) + SUM(Z35:Z55)","v":0},null,{"$f":"SUM(AB7:AB29) + SUM(AB35:AB55)","v":0}]
[null,"Prefix",null,"* First Name",null,"Middle Name",null,"* Last Name",null,"Suffix",null,"* Project Role",null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
["1.",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":"IF(NOT((ISBLANK(P7))),IF((OR(AND(ISBLANK(S7),ISBLANK(U7),ISBLANK(W7)),(S7+U7+W7)=0)),P7,IF((AND((S7>0),((U7+W7)>0))),\"error\",IF((S7>0),(P7*(S7/12)),(P7*((U7+W7)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\"),\"\",(IF(ISBLANK(N7),0,(VLOOKUP(N7,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z7)","v":""},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\",ISBLANK(AB7)),\"\",Z7+AB7)","v":""}]
[]
["2.",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":"IF(NOT((ISBLANK(P9))),IF((OR(AND(ISBLANK(S9),ISBLANK(U9),ISBLANK(W9)),(S9+U9+W9)=0)),P9,IF((AND((S9>0),((U9+W9)>0))),\"error\",IF((S9>0),(P9*(S9/12)),(P9*((U9+W9)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\"),\"\",(IF(ISBLANK(N9),0,(VLOOKUP(N9,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z9)","v":""},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\",ISBLANK(AB9)),\"\",Z9+AB9)","v":""}]
[]
["3.",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":"IF(NOT((ISBLANK(P11))),IF((OR(AND(ISBLANK(S11),ISBLANK(U11),ISBLANK(W11)),(S11+U11+W11)=0)),P11,IF((AND((S11>0),((U11+W11)>0))),\"error\",IF((S11>0),(P11*(S11/12)),(P11*((U11+W11)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\"),\"\",(IF(ISBLANK(N11),0,(VLOOKUP(N11,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z11)","v":""},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\",ISBLANK(AB11)),\"\",Z11+AB11)","v":""}]
[]
["4.",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":"IF(NOT((ISBLANK(P13))),IF((OR(AND(ISBLANK(S13),ISBLANK(U13),ISBLANK(W13)),(S13+U13+W13)=0)),P13,IF((AND((S13>0),((U13+W13)>0))),\"error\",IF((S13>0),(P13*(S13/12)),(P13*((U13+W13)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\"),\"\",(IF(ISBLANK(N13),0,(VLOOKUP(N13,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z13)","v":""},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\",ISBLANK(AB13)),\"\",Z13+AB13)","v":""}]
[]
["5.",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":"IF(NOT((ISBLANK(P15))),IF((OR(AND(ISBLANK(S15),ISBLANK(U15),ISBLANK(W15)),(S15+U15+W15)=0)),P15,IF((AND((S15>0),((U15+W15)>0))),\"error\",IF((S15>0),(P15*(S15/12)),(P15*((U15+W15)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\"),\"\",(IF(ISBLANK(N15),0,(VLOOKUP(N15,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z15)","v":""},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\",ISBLANK(AB15)),\"\",Z15+AB15)","v":""}]
[]
["6.",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":"IF(NOT((ISBLANK(P17))),IF((OR(AND(ISBLANK(S17),ISBLANK(U17),ISBLANK(W17)),(S17+U17+W17)=0)),P17,IF((AND((S17>0),((U17+W17)>0))),\"error\",IF((S17>0),(P17*(S17/12)),(P17*((U17+W17)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\"),\"\",(IF(ISBLANK(N17),0,(VLOOKUP(N17,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z17)","v":""},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\",ISBLANK(AB17)),\"\",Z17+AB17)","v":""}]
[]
["7.",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":"IF(NOT((ISBLANK(P19))),IF((OR(AND(ISBLANK(S19),ISBLANK(U19),ISBLANK(W19)),(S19+U19+W19)=0)),P19,IF((AND((S19>0),((U19+W19)>0))),\"error\",IF((S19>0),(P19*(S19/12)),(P19*((U19+W19)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\"),\"\",(IF(ISBLANK(N19),0,(VLOOKUP(N19,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z19)","v":""},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\",ISBLANK(AB19)),\"\",Z19+AB19)","v":""}]
[]
["8.",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":"IF(NOT((ISBLANK(P21))),IF((OR(AND(ISBLANK(S21),ISBLANK(U21),ISBLANK(W21)),(S21+U21+W21)=0)),P21,IF((AND((S21>0),((U21+W21)>0))),\"error\",IF((S21>0),(P21*(S21/12)),(P21*((U21+W21)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\"),\"\",(IF(ISBLANK(N21),0,(VLOOKUP(N21,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z21)","v":""},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\",ISBLANK(AB21)),\"\",Z21+AB21)","v":""}]
[]
["9.",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":"IF(NOT((ISBLANK(P23))),IF((OR(AND(ISBLANK(S23),ISBLANK(U23),ISBLANK(W23)),(S23+U23+W23)=0)),P23,IF((AND((S23>0),((U23+W23)>0))),\"error\",IF((S23>0),(P23*(S23/12)),(P23*((U23+W23)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\"),\"\",(IF(ISBLANK(N23),0,(VLOOKUP(N23,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z23)","v":""},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\",ISBLANK(AB23)),\"\",Z23+AB23)","v":""}]
[]
["10.",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":"IF(NOT((ISBLANK(P25))),IF((OR(AND(ISBLANK(S25),ISBLANK(U25),ISBLANK(W25)),(S25+U25+W25)=0)),P25,IF((AND((S25>0),((U25+W25)>0))),\"error\",IF((S25>0),(P25*(S25/12)),(P25*((U25+W25)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\"),\"\",(IF(ISBLANK(N25),0,(VLOOKUP(N25,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z25)","v":""},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\",ISBLANK(AB25)),\"\",Z25+AB25)","v":""}]
[]
["11.",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":"IF(NOT((ISBLANK(P27))),IF((OR(AND(ISBLANK(S27),ISBLANK(U27),ISBLANK(W27)),(S27+U27+W27)=0)),P27,IF((AND((S27>0),((U27+W27)>0))),\"error\",IF((S27>0),(P27*(S27/12)),(P27*((U27+W27)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\"),\"\",(IF(ISBLANK(N27),0,(VLOOKUP(N27,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z27)","v":""},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\",ISBLANK(AB27)),\"\",Z27+AB27)","v":""}]
[]
["12.",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":"IF(NOT((ISBLANK(P29))),IF((OR(AND(ISBLANK(S29),ISBLANK(U29),ISBLANK(W29)),(S29+U29+W29)=0)),P29,IF((AND((S29>0),((U29+W29)>0))),\"error\",IF((S29>0),(P29*(S29/12)),(P29*((U29+W29)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\"),\"\",(IF(ISBLANK(N29),0,(VLOOKUP(N29,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z29)","v":""},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\",ISBLANK(AB29)),\"\",Z29+AB29)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Senior/Key Person",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD29)","v":0}]
[null,"B.  Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page."]
[null,"* Number of Personnel",null,null,null,"* Project Role",null,null,null,null,null,null,null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
[null,null,null,null,null,"Post Doctoral Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P35))),IF((OR(AND(ISBLANK(S35),ISBLANK(U35),ISBLANK(W35)),(S35+U35+W35)=0)),P35,IF((AND((S35>0),((U35+W35)>0))),\"error\",IF((S35>0),(P35*(S35/12)),(P35*((U35+W35)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\"),\"\",(IF(ISBLANK(N35),0,(VLOOKUP(N35,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z35)","v":""},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\",ISBLANK(AB35)),\"\",Z35+AB35)","v":""}]
[]
[null,null,null,null,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P37))),IF((OR(AND(ISBLANK(S37),ISBLANK(U37),ISBLANK(W37)),(S37+U37+W37)=0)),P37,IF((AND((S37>0),((U37+W37)>0))),\"error\",IF((S37>0),(P37*(S37/12)),(P37*((U37+W37)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\"),\"\",(IF(ISBLANK(N37),0,(VLOOKUP(N37,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z37)","v":""},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\",ISBLANK(AB37)),\"\",Z37+AB37)","v":""}]
[]
[null,null,null,null,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P39))),IF((OR(AND(ISBLANK(S39),ISBLANK(U39),ISBLANK(W39)),(S39+U39+W39)=0)),P39,IF((AND((S39>0),((U39+W39)>0))),\"error\",IF((S39>0),(P39*(S39/12)),(P39*((U39+W39)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\"),\"\",(IF(ISBLANK(N39),0,(VLOOKUP(N39,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z39)","v":""},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\",ISBLANK(AB39)),\"\",Z39+AB39)","v":""}]
[]
[null,null,null,null,null,"Secretarial / Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P41))),IF((OR(AND(ISBLANK(S41),ISBLANK(U41),ISBLANK(W41)),(S41+U41+W41)=0)),P41,IF((AND((S41>0),((U41+W41)>0))),\"error\",IF((S41>0),(P41*(S41/12)),(P41*((U41+W41)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\"),\"\",(IF(ISBLANK(N41),0,(VLOOKUP(N41,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z41)","v":""},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\",ISBLANK(AB41)),\"\",Z41+AB41)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P43))),IF((OR(AND(ISBLANK(S43),ISBLANK(U43),ISBLANK(W43)),(S43+U43+W43)=0)),P43,IF((AND((S43>0),((U43+W43)>0))),\"error\",IF((S43>0),(P43*(S43/12)),(P43*((U43+W43)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\"),\"\",(IF(ISBLANK(N43),0,(VLOOKUP(N43,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z43)","v":""},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\",ISBLANK(AB43)),\"\",Z43+AB43)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P45))),IF((OR(AND(ISBLANK(S45),ISBLANK(U45),ISBLANK(W45)),(S45+U45+W45)=0)),P45,IF((AND((S45>0),((U45+W45)>0))),\"error\",IF((S45>0),(P45*(S45/12)),(P45*((U45+W45)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\"),\"\",(IF(ISBLANK(N45),0,(VLOOKUP(N45,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z45)","v":""},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\",ISBLANK(AB45)),\"\",Z45+AB45)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P47))),IF((OR(AND(ISBLANK(S47),ISBLANK(U47),ISBLANK(W47)),(S47+U47+W47)=0)),P47,IF((AND((S47>0),((U47+W47)>0))),\"error\",IF((S47>0),(P47*(S47/12)),(P47*((U47+W47)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\"),\"\",(IF(ISBLANK(N47),0,(VLOOKUP(N47,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z47)","v":""},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\",ISBLANK(AB47)),\"\",Z47+AB47)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P49))),IF((OR(AND(ISBLANK(S49),ISBLANK(U49),ISBLANK(W49)),(S49+U49+W49)=0)),P49,IF((AND((S49>0),((U49+W49)>0))),\"error\",IF((S49>0),(P49*(S49/12)),(P49*((U49+W49)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\"),\"\",(IF(ISBLANK(N49),0,(VLOOKUP(N49,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z49)","v":""},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\",ISBLANK(AB49)),\"\",Z49+AB49)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P51))),IF((OR(AND(ISBLANK(S51),ISBLANK(U51),ISBLANK(W51)),(S51+U51+W51)=0)),P51,IF((AND((S51>0),((U51+W51)>0))),\"error\",IF((S51>0),(P51*(S51/12)),(P51*((U51+W51)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\"),\"\",(IF(ISBLANK(N51),0,(VLOOKUP(N51,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z51)","v":""},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\",ISBLANK(AB51)),\"\",Z51+AB51)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P53))),IF((OR(AND(ISBLANK(S53),ISBLANK(U53),ISBLANK(W53)),(S53+U53+W53)=0)),P53,IF((AND((S53>0),((U53+W53)>0))),\"error\",IF((S53>0),(P53*(S53/12)),(P53*((U53+W53)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\"),\"\",(IF(ISBLANK(N53),0,(VLOOKUP(N53,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z53)","v":""},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\",ISBLANK(AB53)),\"\",Z53+AB53)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P55))),IF((OR(AND(ISBLANK(S55),ISBLANK(U55),ISBLANK(W55)),(S55+U55+W55)=0)),P55,IF((AND((S55>0),((U55+W55)>0))),\"error\",IF((S55>0),(P55*(S55/12)),(P55*((U55+W55)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\"),\"\",(IF(ISBLANK(N55),0,(VLOOKUP(N55,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z55)","v":""},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\",ISBLANK(AB55)),\"\",Z55+AB55)","v":""}]
[]
[null,{"$f":"SUM(B35:B55)","v":0},null," ←  Total Number Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Personnel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD35:AD55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wages, and Fringe Benefits ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31+AD57","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,{"$f":"AD59-AD3","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If you are unsure of what to write for Cal. Months, Acad. Months, and Sum. Months, please use this calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointment Type",null,"Percent Effort",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N67=\"Annual\",12*P67,0)","v":0},null,{"$f":"IF(N67=\"Academic\",9*P67,0)","v":0},null,{"$f":"IF(N67=\"Summer\",3*P67,0)","v":0}]

{"sheet":"P(4)","index":4,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[56,18,56,27],[58,15,58,27],[63,13,63,22],[50,5,50,11],[52,5,52,11],[54,5,54,11],[56,3,56,15],[46,5,46,11],[48,5,48,11],[31,1,31,5],[31,17,31,23],[32,1,32,3],[32,5,32,11],[44,5,44,11],[0,0,0,30],[3,1,3,5],[3,17,3,23],[30,18,30,27],[42,5,42,11]]}
["Personnel Year 4"]
[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,"Year:",null,4]
[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":"SUMIF(N7:N29,\"=Post-Doc Fellows and/or Trainees\",Z7:Z29) + SUMIF(N35:N55,\"=Post-Doc Fellows and/or Trainees\",Z35:Z55)","v":0}]
[null,"A.  Senior / Key Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page.",null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z29) + SUM(Z35:Z55)","v":0},null,{"$f":"SUM(AB7:AB29) + SUM(AB35:AB55)","v":0}]
[null,"Prefix",null,"* First Name",null,"Middle Name",null,"* Last Name",null,"Suffix",null,"* Project Role",null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
["1.",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":"IF(NOT((ISBLANK(P7))),IF((OR(AND(ISBLANK(S7),ISBLANK(U7),ISBLANK(W7)),(S7+U7+W7)=0)),P7,IF((AND((S7>0),((U7+W7)>0))),\"error\",IF((S7>0),(P7*(S7/12)),(P7*((U7+W7)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\"),\"\",(IF(ISBLANK(N7),0,(VLOOKUP(N7,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z7)","v":""},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\",ISBLANK(AB7)),\"\",Z7+AB7)","v":""}]
[]
["2.",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":"IF(NOT((ISBLANK(P9))),IF((OR(AND(ISBLANK(S9),ISBLANK(U9),ISBLANK(W9)),(S9+U9+W9)=0)),P9,IF((AND((S9>0),((U9+W9)>0))),\"error\",IF((S9>0),(P9*(S9/12)),(P9*((U9+W9)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\"),\"\",(IF(ISBLANK(N9),0,(VLOOKUP(N9,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z9)","v":""},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\",ISBLANK(AB9)),\"\",Z9+AB9)","v":""}]
[null,null,null,null,null,null,100]
["3.",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":"IF(NOT((ISBLANK(P11))),IF((OR(AND(ISBLANK(S11),ISBLANK(U11),ISBLANK(W11)),(S11+U11+W11)=0)),P11,IF((AND((S11>0),((U11+W11)>0))),\"error\",IF((S11>0),(P11*(S11/12)),(P11*((U11+W11)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\"),\"\",(IF(ISBLANK(N11),0,(VLOOKUP(N11,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z11)","v":""},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\",ISBLANK(AB11)),\"\",Z11+AB11)","v":""}]
[]
["4.",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":"IF(NOT((ISBLANK(P13))),IF((OR(AND(ISBLANK(S13),ISBLANK(U13),ISBLANK(W13)),(S13+U13+W13)=0)),P13,IF((AND((S13>0),((U13+W13)>0))),\"error\",IF((S13>0),(P13*(S13/12)),(P13*((U13+W13)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\"),\"\",(IF(ISBLANK(N13),0,(VLOOKUP(N13,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z13)","v":""},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\",ISBLANK(AB13)),\"\",Z13+AB13)","v":""}]
[]
["5.",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":"IF(NOT((ISBLANK(P15))),IF((OR(AND(ISBLANK(S15),ISBLANK(U15),ISBLANK(W15)),(S15+U15+W15)=0)),P15,IF((AND((S15>0),((U15+W15)>0))),\"error\",IF((S15>0),(P15*(S15/12)),(P15*((U15+W15)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\"),\"\",(IF(ISBLANK(N15),0,(VLOOKUP(N15,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z15)","v":""},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\",ISBLANK(AB15)),\"\",Z15+AB15)","v":""}]
[]
["6.",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":"IF(NOT((ISBLANK(P17))),IF((OR(AND(ISBLANK(S17),ISBLANK(U17),ISBLANK(W17)),(S17+U17+W17)=0)),P17,IF((AND((S17>0),((U17+W17)>0))),\"error\",IF((S17>0),(P17*(S17/12)),(P17*((U17+W17)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\"),\"\",(IF(ISBLANK(N17),0,(VLOOKUP(N17,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z17)","v":""},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\",ISBLANK(AB17)),\"\",Z17+AB17)","v":""}]
[]
["7.",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":"IF(NOT((ISBLANK(P19))),IF((OR(AND(ISBLANK(S19),ISBLANK(U19),ISBLANK(W19)),(S19+U19+W19)=0)),P19,IF((AND((S19>0),((U19+W19)>0))),\"error\",IF((S19>0),(P19*(S19/12)),(P19*((U19+W19)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\"),\"\",(IF(ISBLANK(N19),0,(VLOOKUP(N19,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z19)","v":""},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\",ISBLANK(AB19)),\"\",Z19+AB19)","v":""}]
[]
["8.",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":"IF(NOT((ISBLANK(P21))),IF((OR(AND(ISBLANK(S21),ISBLANK(U21),ISBLANK(W21)),(S21+U21+W21)=0)),P21,IF((AND((S21>0),((U21+W21)>0))),\"error\",IF((S21>0),(P21*(S21/12)),(P21*((U21+W21)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\"),\"\",(IF(ISBLANK(N21),0,(VLOOKUP(N21,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z21)","v":""},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\",ISBLANK(AB21)),\"\",Z21+AB21)","v":""}]
[]
["9.",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":"IF(NOT((ISBLANK(P23))),IF((OR(AND(ISBLANK(S23),ISBLANK(U23),ISBLANK(W23)),(S23+U23+W23)=0)),P23,IF((AND((S23>0),((U23+W23)>0))),\"error\",IF((S23>0),(P23*(S23/12)),(P23*((U23+W23)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\"),\"\",(IF(ISBLANK(N23),0,(VLOOKUP(N23,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z23)","v":""},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\",ISBLANK(AB23)),\"\",Z23+AB23)","v":""}]
[]
["10.",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":"IF(NOT((ISBLANK(P25))),IF((OR(AND(ISBLANK(S25),ISBLANK(U25),ISBLANK(W25)),(S25+U25+W25)=0)),P25,IF((AND((S25>0),((U25+W25)>0))),\"error\",IF((S25>0),(P25*(S25/12)),(P25*((U25+W25)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\"),\"\",(IF(ISBLANK(N25),0,(VLOOKUP(N25,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z25)","v":""},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\",ISBLANK(AB25)),\"\",Z25+AB25)","v":""}]
[]
["11.",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":"IF(NOT((ISBLANK(P27))),IF((OR(AND(ISBLANK(S27),ISBLANK(U27),ISBLANK(W27)),(S27+U27+W27)=0)),P27,IF((AND((S27>0),((U27+W27)>0))),\"error\",IF((S27>0),(P27*(S27/12)),(P27*((U27+W27)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\"),\"\",(IF(ISBLANK(N27),0,(VLOOKUP(N27,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z27)","v":""},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\",ISBLANK(AB27)),\"\",Z27+AB27)","v":""}]
[]
["12.",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":"IF(NOT((ISBLANK(P29))),IF((OR(AND(ISBLANK(S29),ISBLANK(U29),ISBLANK(W29)),(S29+U29+W29)=0)),P29,IF((AND((S29>0),((U29+W29)>0))),\"error\",IF((S29>0),(P29*(S29/12)),(P29*((U29+W29)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\"),\"\",(IF(ISBLANK(N29),0,(VLOOKUP(N29,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z29)","v":""},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\",ISBLANK(AB29)),\"\",Z29+AB29)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Senior/Key Person",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD29)","v":0}]
[null,"B.  Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page."]
[null,"* Number of Personnel",null,null,null,"* Project Role",null,null,null,null,null,null,null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
[null,null,null,null,null,"Post Doctoral Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P35))),IF((OR(AND(ISBLANK(S35),ISBLANK(U35),ISBLANK(W35)),(S35+U35+W35)=0)),P35,IF((AND((S35>0),((U35+W35)>0))),\"error\",IF((S35>0),(P35*(S35/12)),(P35*((U35+W35)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\"),\"\",(IF(ISBLANK(N35),0,(VLOOKUP(N35,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z35)","v":""},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\",ISBLANK(AB35)),\"\",Z35+AB35)","v":""}]
[]
[null,null,null,null,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P37))),IF((OR(AND(ISBLANK(S37),ISBLANK(U37),ISBLANK(W37)),(S37+U37+W37)=0)),P37,IF((AND((S37>0),((U37+W37)>0))),\"error\",IF((S37>0),(P37*(S37/12)),(P37*((U37+W37)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\"),\"\",(IF(ISBLANK(N37),0,(VLOOKUP(N37,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z37)","v":""},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\",ISBLANK(AB37)),\"\",Z37+AB37)","v":""}]
[]
[null,null,null,null,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P39))),IF((OR(AND(ISBLANK(S39),ISBLANK(U39),ISBLANK(W39)),(S39+U39+W39)=0)),P39,IF((AND((S39>0),((U39+W39)>0))),\"error\",IF((S39>0),(P39*(S39/12)),(P39*((U39+W39)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\"),\"\",(IF(ISBLANK(N39),0,(VLOOKUP(N39,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z39)","v":""},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\",ISBLANK(AB39)),\"\",Z39+AB39)","v":""}]
[]
[null,null,null,null,null,"Secretarial / Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P41))),IF((OR(AND(ISBLANK(S41),ISBLANK(U41),ISBLANK(W41)),(S41+U41+W41)=0)),P41,IF((AND((S41>0),((U41+W41)>0))),\"error\",IF((S41>0),(P41*(S41/12)),(P41*((U41+W41)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\"),\"\",(IF(ISBLANK(N41),0,(VLOOKUP(N41,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z41)","v":""},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\",ISBLANK(AB41)),\"\",Z41+AB41)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P43))),IF((OR(AND(ISBLANK(S43),ISBLANK(U43),ISBLANK(W43)),(S43+U43+W43)=0)),P43,IF((AND((S43>0),((U43+W43)>0))),\"error\",IF((S43>0),(P43*(S43/12)),(P43*((U43+W43)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\"),\"\",(IF(ISBLANK(N43),0,(VLOOKUP(N43,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z43)","v":""},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\",ISBLANK(AB43)),\"\",Z43+AB43)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P45))),IF((OR(AND(ISBLANK(S45),ISBLANK(U45),ISBLANK(W45)),(S45+U45+W45)=0)),P45,IF((AND((S45>0),((U45+W45)>0))),\"error\",IF((S45>0),(P45*(S45/12)),(P45*((U45+W45)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\"),\"\",(IF(ISBLANK(N45),0,(VLOOKUP(N45,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z45)","v":""},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\",ISBLANK(AB45)),\"\",Z45+AB45)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P47))),IF((OR(AND(ISBLANK(S47),ISBLANK(U47),ISBLANK(W47)),(S47+U47+W47)=0)),P47,IF((AND((S47>0),((U47+W47)>0))),\"error\",IF((S47>0),(P47*(S47/12)),(P47*((U47+W47)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\"),\"\",(IF(ISBLANK(N47),0,(VLOOKUP(N47,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z47)","v":""},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\",ISBLANK(AB47)),\"\",Z47+AB47)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P49))),IF((OR(AND(ISBLANK(S49),ISBLANK(U49),ISBLANK(W49)),(S49+U49+W49)=0)),P49,IF((AND((S49>0),((U49+W49)>0))),\"error\",IF((S49>0),(P49*(S49/12)),(P49*((U49+W49)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\"),\"\",(IF(ISBLANK(N49),0,(VLOOKUP(N49,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z49)","v":""},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\",ISBLANK(AB49)),\"\",Z49+AB49)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P51))),IF((OR(AND(ISBLANK(S51),ISBLANK(U51),ISBLANK(W51)),(S51+U51+W51)=0)),P51,IF((AND((S51>0),((U51+W51)>0))),\"error\",IF((S51>0),(P51*(S51/12)),(P51*((U51+W51)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\"),\"\",(IF(ISBLANK(N51),0,(VLOOKUP(N51,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z51)","v":""},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\",ISBLANK(AB51)),\"\",Z51+AB51)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P53))),IF((OR(AND(ISBLANK(S53),ISBLANK(U53),ISBLANK(W53)),(S53+U53+W53)=0)),P53,IF((AND((S53>0),((U53+W53)>0))),\"error\",IF((S53>0),(P53*(S53/12)),(P53*((U53+W53)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\"),\"\",(IF(ISBLANK(N53),0,(VLOOKUP(N53,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z53)","v":""},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\",ISBLANK(AB53)),\"\",Z53+AB53)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P55))),IF((OR(AND(ISBLANK(S55),ISBLANK(U55),ISBLANK(W55)),(S55+U55+W55)=0)),P55,IF((AND((S55>0),((U55+W55)>0))),\"error\",IF((S55>0),(P55*(S55/12)),(P55*((U55+W55)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\"),\"\",(IF(ISBLANK(N55),0,(VLOOKUP(N55,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z55)","v":""},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\",ISBLANK(AB55)),\"\",Z55+AB55)","v":""}]
[]
[null,{"$f":"SUM(B35:B55)","v":0},null," ←  Total Number Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Personnel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD35:AD55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wages, and Fringe Benefits ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31+AD57","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,{"$f":"AD59-AD3","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If you are unsure of what to write for Cal. Months, Acad. Months, and Sum. Months, please use this calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointment Type",null,"Percent Effort",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N67=\"Annual\",12*P67,0)","v":0},null,{"$f":"IF(N67=\"Academic\",9*P67,0)","v":0},null,{"$f":"IF(N67=\"Summer\",3*P67,0)","v":0}]

{"sheet":"P(5)","index":5,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,30],[3,1,3,5],[3,17,3,23],[30,18,30,27],[2,1,2,5],[31,17,31,23],[32,1,32,3],[32,5,32,11],[42,5,42,11],[31,5,31,9],[44,5,44,11],[46,5,46,11],[48,5,48,11],[56,18,56,27],[58,15,58,27],[63,13,63,22],[50,5,50,11],[52,5,52,11],[54,5,54,11],[56,3,56,15]]}
["Personnel Year 5"]
[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,"Year:",null,5]
[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":"SUMIF(N7:N29,\"=Post-Doc Fellows and/or Trainees\",Z7:Z29) + SUMIF(N35:N55,\"=Post-Doc Fellows and/or Trainees\",Z35:Z55)","v":0}]
[null,"A.  Senior / Key Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page.",null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z29) + SUM(Z35:Z55)","v":0},null,{"$f":"SUM(AB7:AB29) + SUM(AB35:AB55)","v":0}]
[null,"Prefix",null,"* First Name",null,"Middle Name",null,"* Last Name",null,"Suffix",null,"* Project Role",null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
["1.",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":"IF(NOT((ISBLANK(P7))),IF((OR(AND(ISBLANK(S7),ISBLANK(U7),ISBLANK(W7)),(S7+U7+W7)=0)),P7,IF((AND((S7>0),((U7+W7)>0))),\"error\",IF((S7>0),(P7*(S7/12)),(P7*((U7+W7)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\"),\"\",(IF(ISBLANK(N7),0,(VLOOKUP(N7,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z7)","v":""},null,{"$f":"IF(OR(ISBLANK(Z7),Z7=\"empty\",Z7=\"error\",ISBLANK(AB7)),\"\",Z7+AB7)","v":""}]
[]
["2.",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":"IF(NOT((ISBLANK(P9))),IF((OR(AND(ISBLANK(S9),ISBLANK(U9),ISBLANK(W9)),(S9+U9+W9)=0)),P9,IF((AND((S9>0),((U9+W9)>0))),\"error\",IF((S9>0),(P9*(S9/12)),(P9*((U9+W9)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\"),\"\",(IF(ISBLANK(N9),0,(VLOOKUP(N9,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z9)","v":""},null,{"$f":"IF(OR(ISBLANK(Z9),Z9=\"empty\",Z9=\"error\",ISBLANK(AB9)),\"\",Z9+AB9)","v":""}]
[]
["3.",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":"IF(NOT((ISBLANK(P11))),IF((OR(AND(ISBLANK(S11),ISBLANK(U11),ISBLANK(W11)),(S11+U11+W11)=0)),P11,IF((AND((S11>0),((U11+W11)>0))),\"error\",IF((S11>0),(P11*(S11/12)),(P11*((U11+W11)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\"),\"\",(IF(ISBLANK(N11),0,(VLOOKUP(N11,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z11)","v":""},null,{"$f":"IF(OR(ISBLANK(Z11),Z11=\"empty\",Z11=\"error\",ISBLANK(AB11)),\"\",Z11+AB11)","v":""}]
[]
["4.",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":"IF(NOT((ISBLANK(P13))),IF((OR(AND(ISBLANK(S13),ISBLANK(U13),ISBLANK(W13)),(S13+U13+W13)=0)),P13,IF((AND((S13>0),((U13+W13)>0))),\"error\",IF((S13>0),(P13*(S13/12)),(P13*((U13+W13)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\"),\"\",(IF(ISBLANK(N13),0,(VLOOKUP(N13,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z13)","v":""},null,{"$f":"IF(OR(ISBLANK(Z13),Z13=\"empty\",Z13=\"error\",ISBLANK(AB13)),\"\",Z13+AB13)","v":""}]
[]
["5.",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":"IF(NOT((ISBLANK(P15))),IF((OR(AND(ISBLANK(S15),ISBLANK(U15),ISBLANK(W15)),(S15+U15+W15)=0)),P15,IF((AND((S15>0),((U15+W15)>0))),\"error\",IF((S15>0),(P15*(S15/12)),(P15*((U15+W15)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\"),\"\",(IF(ISBLANK(N15),0,(VLOOKUP(N15,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z15)","v":""},null,{"$f":"IF(OR(ISBLANK(Z15),Z15=\"empty\",Z15=\"error\",ISBLANK(AB15)),\"\",Z15+AB15)","v":""}]
[]
["6.",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":"IF(NOT((ISBLANK(P17))),IF((OR(AND(ISBLANK(S17),ISBLANK(U17),ISBLANK(W17)),(S17+U17+W17)=0)),P17,IF((AND((S17>0),((U17+W17)>0))),\"error\",IF((S17>0),(P17*(S17/12)),(P17*((U17+W17)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\"),\"\",(IF(ISBLANK(N17),0,(VLOOKUP(N17,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z17)","v":""},null,{"$f":"IF(OR(ISBLANK(Z17),Z17=\"empty\",Z17=\"error\",ISBLANK(AB17)),\"\",Z17+AB17)","v":""}]
[]
["7.",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":"IF(NOT((ISBLANK(P19))),IF((OR(AND(ISBLANK(S19),ISBLANK(U19),ISBLANK(W19)),(S19+U19+W19)=0)),P19,IF((AND((S19>0),((U19+W19)>0))),\"error\",IF((S19>0),(P19*(S19/12)),(P19*((U19+W19)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\"),\"\",(IF(ISBLANK(N19),0,(VLOOKUP(N19,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z19)","v":""},null,{"$f":"IF(OR(ISBLANK(Z19),Z19=\"empty\",Z19=\"error\",ISBLANK(AB19)),\"\",Z19+AB19)","v":""}]
[]
["8.",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":"IF(NOT((ISBLANK(P21))),IF((OR(AND(ISBLANK(S21),ISBLANK(U21),ISBLANK(W21)),(S21+U21+W21)=0)),P21,IF((AND((S21>0),((U21+W21)>0))),\"error\",IF((S21>0),(P21*(S21/12)),(P21*((U21+W21)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\"),\"\",(IF(ISBLANK(N21),0,(VLOOKUP(N21,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z21)","v":""},null,{"$f":"IF(OR(ISBLANK(Z21),Z21=\"empty\",Z21=\"error\",ISBLANK(AB21)),\"\",Z21+AB21)","v":""}]
[]
["9.",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":"IF(NOT((ISBLANK(P23))),IF((OR(AND(ISBLANK(S23),ISBLANK(U23),ISBLANK(W23)),(S23+U23+W23)=0)),P23,IF((AND((S23>0),((U23+W23)>0))),\"error\",IF((S23>0),(P23*(S23/12)),(P23*((U23+W23)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\"),\"\",(IF(ISBLANK(N23),0,(VLOOKUP(N23,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z23)","v":""},null,{"$f":"IF(OR(ISBLANK(Z23),Z23=\"empty\",Z23=\"error\",ISBLANK(AB23)),\"\",Z23+AB23)","v":""}]
[]
["10.",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":"IF(NOT((ISBLANK(P25))),IF((OR(AND(ISBLANK(S25),ISBLANK(U25),ISBLANK(W25)),(S25+U25+W25)=0)),P25,IF((AND((S25>0),((U25+W25)>0))),\"error\",IF((S25>0),(P25*(S25/12)),(P25*((U25+W25)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\"),\"\",(IF(ISBLANK(N25),0,(VLOOKUP(N25,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z25)","v":""},null,{"$f":"IF(OR(ISBLANK(Z25),Z25=\"empty\",Z25=\"error\",ISBLANK(AB25)),\"\",Z25+AB25)","v":""}]
[]
["11.",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":"IF(NOT((ISBLANK(P27))),IF((OR(AND(ISBLANK(S27),ISBLANK(U27),ISBLANK(W27)),(S27+U27+W27)=0)),P27,IF((AND((S27>0),((U27+W27)>0))),\"error\",IF((S27>0),(P27*(S27/12)),(P27*((U27+W27)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\"),\"\",(IF(ISBLANK(N27),0,(VLOOKUP(N27,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z27)","v":""},null,{"$f":"IF(OR(ISBLANK(Z27),Z27=\"empty\",Z27=\"error\",ISBLANK(AB27)),\"\",Z27+AB27)","v":""}]
[]
["12.",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":"IF(NOT((ISBLANK(P29))),IF((OR(AND(ISBLANK(S29),ISBLANK(U29),ISBLANK(W29)),(S29+U29+W29)=0)),P29,IF((AND((S29>0),((U29+W29)>0))),\"error\",IF((S29>0),(P29*(S29/12)),(P29*((U29+W29)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\"),\"\",(IF(ISBLANK(N29),0,(VLOOKUP(N29,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z29)","v":""},null,{"$f":"IF(OR(ISBLANK(Z29),Z29=\"empty\",Z29=\"error\",ISBLANK(AB29)),\"\",Z29+AB29)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Senior/Key Person",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD7:AD29)","v":0}]
[null,"B.  Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please see the bottom of the page."]
[null,"* Number of Personnel",null,null,null,"* Project Role",null,null,null,null,null,null,null,"Salary Category",null,"Base Salary ($)",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months",null,null,"* Requested Salary ($)",null,"* Fringe Benefits ($)",null,"* Funds Requested ($)"]
[]
[null,null,null,null,null,"Post Doctoral Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P35))),IF((OR(AND(ISBLANK(S35),ISBLANK(U35),ISBLANK(W35)),(S35+U35+W35)=0)),P35,IF((AND((S35>0),((U35+W35)>0))),\"error\",IF((S35>0),(P35*(S35/12)),(P35*((U35+W35)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\"),\"\",(IF(ISBLANK(N35),0,(VLOOKUP(N35,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z35)","v":""},null,{"$f":"IF(OR(ISBLANK(Z35),Z35=\"empty\",Z35=\"error\",ISBLANK(AB35)),\"\",Z35+AB35)","v":""}]
[]
[null,null,null,null,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P37))),IF((OR(AND(ISBLANK(S37),ISBLANK(U37),ISBLANK(W37)),(S37+U37+W37)=0)),P37,IF((AND((S37>0),((U37+W37)>0))),\"error\",IF((S37>0),(P37*(S37/12)),(P37*((U37+W37)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\"),\"\",(IF(ISBLANK(N37),0,(VLOOKUP(N37,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z37)","v":""},null,{"$f":"IF(OR(ISBLANK(Z37),Z37=\"empty\",Z37=\"error\",ISBLANK(AB37)),\"\",Z37+AB37)","v":""}]
[]
[null,null,null,null,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P39))),IF((OR(AND(ISBLANK(S39),ISBLANK(U39),ISBLANK(W39)),(S39+U39+W39)=0)),P39,IF((AND((S39>0),((U39+W39)>0))),\"error\",IF((S39>0),(P39*(S39/12)),(P39*((U39+W39)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\"),\"\",(IF(ISBLANK(N39),0,(VLOOKUP(N39,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z39)","v":""},null,{"$f":"IF(OR(ISBLANK(Z39),Z39=\"empty\",Z39=\"error\",ISBLANK(AB39)),\"\",Z39+AB39)","v":""}]
[]
[null,null,null,null,null,"Secretarial / Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT((ISBLANK(P41))),IF((OR(AND(ISBLANK(S41),ISBLANK(U41),ISBLANK(W41)),(S41+U41+W41)=0)),P41,IF((AND((S41>0),((U41+W41)>0))),\"error\",IF((S41>0),(P41*(S41/12)),(P41*((U41+W41)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\"),\"\",(IF(ISBLANK(N41),0,(VLOOKUP(N41,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z41)","v":""},null,{"$f":"IF(OR(ISBLANK(Z41),Z41=\"empty\",Z41=\"error\",ISBLANK(AB41)),\"\",Z41+AB41)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P43))),IF((OR(AND(ISBLANK(S43),ISBLANK(U43),ISBLANK(W43)),(S43+U43+W43)=0)),P43,IF((AND((S43>0),((U43+W43)>0))),\"error\",IF((S43>0),(P43*(S43/12)),(P43*((U43+W43)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\"),\"\",(IF(ISBLANK(N43),0,(VLOOKUP(N43,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z43)","v":""},null,{"$f":"IF(OR(ISBLANK(Z43),Z43=\"empty\",Z43=\"error\",ISBLANK(AB43)),\"\",Z43+AB43)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P45))),IF((OR(AND(ISBLANK(S45),ISBLANK(U45),ISBLANK(W45)),(S45+U45+W45)=0)),P45,IF((AND((S45>0),((U45+W45)>0))),\"error\",IF((S45>0),(P45*(S45/12)),(P45*((U45+W45)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\"),\"\",(IF(ISBLANK(N45),0,(VLOOKUP(N45,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z45)","v":""},null,{"$f":"IF(OR(ISBLANK(Z45),Z45=\"empty\",Z45=\"error\",ISBLANK(AB45)),\"\",Z45+AB45)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P47))),IF((OR(AND(ISBLANK(S47),ISBLANK(U47),ISBLANK(W47)),(S47+U47+W47)=0)),P47,IF((AND((S47>0),((U47+W47)>0))),\"error\",IF((S47>0),(P47*(S47/12)),(P47*((U47+W47)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\"),\"\",(IF(ISBLANK(N47),0,(VLOOKUP(N47,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z47)","v":""},null,{"$f":"IF(OR(ISBLANK(Z47),Z47=\"empty\",Z47=\"error\",ISBLANK(AB47)),\"\",Z47+AB47)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P49))),IF((OR(AND(ISBLANK(S49),ISBLANK(U49),ISBLANK(W49)),(S49+U49+W49)=0)),P49,IF((AND((S49>0),((U49+W49)>0))),\"error\",IF((S49>0),(P49*(S49/12)),(P49*((U49+W49)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\"),\"\",(IF(ISBLANK(N49),0,(VLOOKUP(N49,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z49)","v":""},null,{"$f":"IF(OR(ISBLANK(Z49),Z49=\"empty\",Z49=\"error\",ISBLANK(AB49)),\"\",Z49+AB49)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P51))),IF((OR(AND(ISBLANK(S51),ISBLANK(U51),ISBLANK(W51)),(S51+U51+W51)=0)),P51,IF((AND((S51>0),((U51+W51)>0))),\"error\",IF((S51>0),(P51*(S51/12)),(P51*((U51+W51)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\"),\"\",(IF(ISBLANK(N51),0,(VLOOKUP(N51,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z51)","v":""},null,{"$f":"IF(OR(ISBLANK(Z51),Z51=\"empty\",Z51=\"error\",ISBLANK(AB51)),\"\",Z51+AB51)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P53))),IF((OR(AND(ISBLANK(S53),ISBLANK(U53),ISBLANK(W53)),(S53+U53+W53)=0)),P53,IF((AND((S53>0),((U53+W53)>0))),\"error\",IF((S53>0),(P53*(S53/12)),(P53*((U53+W53)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\"),\"\",(IF(ISBLANK(N53),0,(VLOOKUP(N53,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z53)","v":""},null,{"$f":"IF(OR(ISBLANK(Z53),Z53=\"empty\",Z53=\"error\",ISBLANK(AB53)),\"\",Z53+AB53)","v":""}]
[]
[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":"IF(NOT((ISBLANK(P55))),IF((OR(AND(ISBLANK(S55),ISBLANK(U55),ISBLANK(W55)),(S55+U55+W55)=0)),P55,IF((AND((S55>0),((U55+W55)>0))),\"error\",IF((S55>0),(P55*(S55/12)),(P55*((U55+W55)/9))))),\"empty\")","v":"empty"},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\"),\"\",(IF(ISBLANK(N55),0,(VLOOKUP(N55,Fringe_Array,2,FALSE)+($AD$2*1%)))) * Z55)","v":""},null,{"$f":"IF(OR(ISBLANK(Z55),Z55=\"empty\",Z55=\"error\",ISBLANK(AB55)),\"\",Z55+AB55)","v":""}]
[]
[null,{"$f":"SUM(B35:B55)","v":0},null," ←  Total Number Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Other Personnel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD35:AD55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wages, and Fringe Benefits ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD31+AD57","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,{"$f":"AD59-AD3","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If you are unsure of what to write for Cal. Months, Acad. Months, and Sum. Months, please use this calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointment Type",null,"Percent Effort",null,null,"Cal. Months",null,"Acad. Months",null,"Sum. Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N67=\"Annual\",12*P67,0)","v":0},null,{"$f":"IF(N67=\"Academic\",9*P67,0)","v":0},null,{"$f":"IF(N67=\"Summer\",3*P67,0)","v":0}]

{"sheet":"Tuition Remission","index":6,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6],[14,0,16,6]]}
["Worksheet for Project Budget"]
["Tuition Remission"]
[]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
["Select First Semester","Select…","Select…","Select…","Select…","Select…"]
["Number of PA/RA",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
["Sub-Total",{"$f":"ROUND(B6*IF(B5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(C6*IF(C5 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},0,0,0,{"$f":"SUM(B7:F7)","v":0}]
["Select Second Semester","Select…","Select…","Select…","Select…","Select…"]
["Number of PA/RA",null,null,null,null,null,{"$f":"SUM(B9:F9)","v":0}]
["Sub-Total",{"$f":"ROUND(B9*IF(B8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},{"$f":"ROUND(C9*IF(C8 = \"Fall 2017 to Fall 2025\", 6000, 5364),0)","v":0},0,0,0,{"$f":"SUM(B10:F10)","v":0}]
[]
["Total Tuition Remission",{"$f":"ROUND(SUM(B7, B10),0)","v":0},{"$f":"ROUND(SUM(C7, C10),0)","v":0},{"$f":"ROUND(SUM(D7, D10),0)","v":0},{"$f":"ROUND(SUM(E7, E10),0)","v":0},{"$f":"ROUND(SUM(F7, F10),0)","v":0},{"$f":"SUM(B12:F12)","v":0}]
[]
[]
["NOTE:  To ensure that you have requested sufficient funds to cover the cost of Tuition Remission,   please indicate the number of PA/RA students you will have in each year.  If you expect to have one student for the full budget year and another for half the budget year, you may indicate 1.5 students."]

{"sheet":"Non-P(1~5)","index":7,"n_rows":144,"n_cols":27,"rows_kept":144,"cut":false,"hidden":false,"merged":[[46,3,46,15],[29,3,29,15],[30,3,30,15],[25,3,25,15],[26,3,26,15],[86,3,86,15],[42,3,42,15],[48,3,48,15],[49,3,49,15],[36,3,36,15],[44,3,44,15],[54,4,54,15],[68,3,68,15],[0,0,0,27],[14,3,14,15],[15,3,15,15],[16,3,16,15],[11,3,11,15],[12,3,12,15],[13,3,13,15],[4,3,4,15],[6,3,6,15],[8,3,8,15],[10,3,10,15],[2,3,2,15],[7,3,7,15],[9,3,9,15],[23,3,23,15],[24,3,24,15],[27,3,27,15],[28,3,28,15],[41,3,41,15],[100,3,100,15],[101,3,101,15],[102,3,102,15],[103,3,103,15],[98,3,98,15],[99,3,99,15],[94,3,94,15],[90,3,90,15],[89,3,89,15],[62,3,62,15],[58,15,58,25],[87,3,87,15],[88,3,88,15],[75,12,75,15],[77,12,77,15],[81,12,81,15],[84,3,84,15],[79,12,79,15],[83,12,83,15],[20,3,20,15],[21,3,21,15],[22,3,22,15],[17,3,17,15],[18,3,18,15],[19,3,19,15],[66,3,66,15],[71,12,71,15],[73,12,73,15],[31,3,31,15],[32,3,32,15],[33,3,33,15],[34,3,34,15],[38,3,38,15],[40,3,40,15],[64,3,64,15],[65,3,65,15],[67,3,67,15],[55,3,55,15],[60,3,60,15],[50,3,50,15],[51,3,51,15],[52,3,52,15],[53,3,53,15],[141,3,141,15],[143,1,143,15],[123,10,123,12],[127,3,127,7],[119,0,119,1],[121,0,121,1],[123,0,123,1],[125,0,125,1],[127,0,127,1],[119,3,119,7],[121,3,121,7],[123,3,123,7],[125,3,125,7],[104,3,104,15],[105,3,105,15],[131,17,131,25],[133,15,133,25],[136,3,136,15],[138,1,138,15],[132,1,132,3],[132,5,132,12],[91,3,91,15],[92,3,92,15],[93,3,93,15],[96,3,96,15],[97,3,97,15],[125,10,125,12],[127,10,127,12],[95,3,95,15],[108,3,108,15],[110,1,110,15],[119,10,119,12],[121,10,121,12],[112,3,112,15],[117,10,117,12],[117,3,117,8],[114,12,114,15]]}
["Non-Personnel Years 1 ~ 5"]
[]
[null,null,null,"C.      Equipment item",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"1."]
[]
[null,"2."]
[]
[null,"3."]
[]
[null,"4."]
[]
[null,"5."]
[]
[null,"6."]
[]
[null,"7."]
[]
[null,"8."]
[]
[null,"9."]
[]
[null,"10."]
[]
[null,"11."]
[]
[null,"12."]
[]
[null,"13."]
[]
[null,"14."]
[]
[null,"15."]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R5:R33)","v":0},null,{"$f":"SUM(T5:T33)","v":0},null,{"$f":"SUM(V5:V33)","v":0},null,{"$f":"SUM(X5:X33)","v":0},null,{"$f":"SUM(Z5:Z33)","v":0}]
[]
[null,null,null,"D.      Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"1.",null,"Domestic Travel Costs (Include Canada, Mexico, and U.S. Possessions)"]
[]
[null,"2.",null,"Foreign Travel Costs"]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R39:R42)","v":0},null,{"$f":"SUM(T39:T42)","v":0},null,{"$f":"SUM(V39:V42)","v":0},null,{"$f":"SUM(X39:X42)","v":0},null,{"$f":"SUM(Z39:Z42)","v":0}]
[]
[null,null,null,"E.      Participant/Trainee Support Center (excluded from MTDC)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"1.",null,"Tuition / Fees / Health Insurance"]
[]
[null,"2.",null,"Stipends"]
[]
[null,"3.",null,"Travel"]
[]
[null,"4.",null,"Subsistence"]
[]
[null,"5.",null,"Other"]
[]
[null,"2",null," ←  Number of Participants/Trainees",null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R47:R55)","v":0},null,{"$f":"SUM(T47:T55)","v":0},null,{"$f":"SUM(V47:V55)","v":0},null,{"$f":"SUM(X47:X55)","v":0},null,{"$f":"SUM(Z47:Z55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continue Below ↓"]
[]
[null,null,null,"F.      Other Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"1.",null,"Materials and Supplies"]
[]
[null,"2.",null,"Publication Costs"]
[]
[null,"3.",null,"Consultant Services"]
[]
[null,"4.",null,"ADP / Computer Services"]
[]
[]
[null,"5.",null,"Subawards / Consortium / Contractual Costs",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R72+T72+V72+X72+Z72","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R72>25000,25000,R72)","v":0},null,{"$f":"IF(T72>25000-R73,25000-R73,T72)","v":0},null,{"$f":"IF(V72>25000-T73-R73,25000-T73-R73,V72)","v":0},null,{"$f":"IF(X72>25000-V73-T73-R73,25000-V73-T73-R73,X72)","v":0},null,{"$f":"IF(Z72>25000-X73-V73-T73-R73,25000-X73-V73-T73-R73,Z72)","v":0},{"$f":"R73+T73+V73+X73+Z73","v":0}]
[null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R74>25000,25000,R74)","v":0},null,{"$f":"IF(T74>25000-R75,25000-R75,T74)","v":0},null,{"$f":"IF(V74>25000-T75-R75,25000-T75-R75,V74)","v":0},null,{"$f":"IF(X74>25000-V75-T75-R75,25000-V75-T75-R75,X74)","v":0},null,{"$f":"IF(Z74>25000-X75-V75-T75-R75,25000-X75-V75-T75-R75,Z74)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R76>25000,25000,R76)","v":0},null,{"$f":"IF(T76>25000-R77,25000-R77,T76)","v":0},null,{"$f":"IF(V76>25000-T77-R77,25000-T77-R77,V76)","v":0},null,{"$f":"IF(X76>25000-V77-T77-R77,25000-V77-T77-R77,X76)","v":0},null,{"$f":"IF(Z76>25000-X77-V77-T77-R77,25000-X77-V77-T77-R77,Z76)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R78>25000,25000,R78)","v":0},null,{"$f":"IF(T78>25000-R79,25000-R79,T78)","v":0},null,{"$f":"IF(V78>25000-T79-R79,25000-T79-R79,V78)","v":0},null,{"$f":"IF(X78>25000-V79-T79-R79,25000-V79-T79-R79,X78)","v":0},null,{"$f":"IF(Z78>25000-X79-V79-T79-R79,25000-X79-V79-T79-R79,Z78)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R80>25000,25000,R80)","v":0},null,{"$f":"IF(T80>25000-R81,25000-R81,T80)","v":0},null,{"$f":"IF(V80>25000-T81-R81,25000-T81-R81,V80)","v":0},null,{"$f":"IF(X80>25000-V81-T81-R81,25000-V81-T81-R81,X80)","v":0},null,{"$f":"IF(Z80>25000-X81-V81-T81-R81,25000-X81-V81-T81-R81,Z80)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R82>25000,25000,R82)","v":0},null,{"$f":"IF(T82>25000-R83,25000-R83,T82)","v":0},null,{"$f":"IF(V82>25000-T83-R83,25000-T83-R83,V82)","v":0},null,{"$f":"IF(X82>25000-V83-T83-R83,25000-V83-T83-R83,X82)","v":0},null,{"$f":"IF(Z82>25000-X83-V83-T83-R83,25000-X83-V83-T83-R83,Z82)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R84>25000,25000,R84)","v":0},null,{"$f":"IF(T84>25000-R85,25000-R85,T84)","v":0},null,{"$f":"IF(V84>25000-T85-R85,25000-T85-R85,V84)","v":0},null,{"$f":"IF(X84>25000-V85-T85-R85,25000-V85-T85-R85,X84)","v":0},null,{"$f":"IF(Z84>25000-X85-V85-T85-R85,25000-X85-V85-T85-R85,Z84)","v":0}]
[]
[null,"6.",null,"Equipment or Facility Rental / User Fees"]
[]
[null,"7.",null,"Alterations and Renovations"]
[]
[null,"8.",null,"Tuition Remission",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Tuition Remission'!B12","v":0},null,{"$f":"'Tuition Remission'!C12","v":0},null,{"$f":"'Tuition Remission'!D12","v":0},null,{"$f":"'Tuition Remission'!E12","v":0},null,{"$f":"'Tuition Remission'!F12","v":0}]
[]
[null,"9."]
[]
[null,"10."]
[]
[null,"11."]
[]
[null,"12."]
[]
[null,"13."]
[]
[null,"14."]
[]
[null,"15."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"R63+R65+R67+R69+R72+R74+R76+R78+R80+R82+R84+R87+R89+R91+R93+R95+R97+R99+R101+R103+R105","v":0},null,{"$f":"T63+T65+T67+T69+T72+T74+T76+T78+T80+T82+T84+T87+T89+T91+T93+T95+T97+T99+T101+T103+T105","v":0},null,{"$f":"V63+V65+V67+V69+V72+V74+V76+V78+V80+V82+V84+V87+V89+V91+V93+V95+V97+V99+V101+V103+V105","v":0},null,{"$f":"X63+X65+X67+X69+X72+X74+X76+X78+X80+X82+X84+X87+X89+X91+X93+X95+X97+X99+X101+X103+X105","v":0},null,{"$f":"Z63+Z65+Z67+Z69+Z72+Z74+Z76+Z78+Z80+Z82+Z84+Z87+Z89+Z91+Z93+Z95+Z97+Z99+Z101+Z103+Z105","v":0}]
[]
[null,null,null,"G.      Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"Total Direct Costs (A thru F) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'P(1)'!AD31+'P(1)'!AD57+'Non-P(1~5)'!R35+'Non-P(1~5)'!R43+'Non-P(1~5)'!R57+'Non-P(1~5)'!R107","v":0},null,{"$f":"'P(2)'!AD31+'P(2)'!AD57+'Non-P(1~5)'!T35+'Non-P(1~5)'!T43+'Non-P(1~5)'!T57+'Non-P(1~5)'!T107","v":0},null,{"$f":"'P(3)'!AD31+'P(3)'!AD57+'Non-P(1~5)'!V35+'Non-P(1~5)'!V43+'Non-P(1~5)'!V57+'Non-P(1~5)'!V107","v":0},null,{"$f":"'P(4)'!AD31+'P(4)'!AD57+'Non-P(1~5)'!X35+'Non-P(1~5)'!X43+'Non-P(1~5)'!X57+'Non-P(1~5)'!X107","v":0},null,{"$f":"'P(5)'!AD31+'P(5)'!AD57+'Non-P(1~5)'!Z35+'Non-P(1~5)'!Z43+'Non-P(1~5)'!Z57+'Non-P(1~5)'!Z107","v":0}]
[]
[null,null,null,"H.      Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Calculated MTDC Indirect Cost Base",null,null,null,null,{"$f":"'P(1)'!AD59+'Non-P(1~5)'!R43+'Non-P(1~5)'!R63+'Non-P(1~5)'!R65+'Non-P(1~5)'!R67+'Non-P(1~5)'!R69+'Non-P(1~5)'!R73+'Non-P(1~5)'!R75+'Non-P(1~5)'!R77+'Non-P(1~5)'!R79+'Non-P(1~5)'!R81+'Non-P(1~5)'!R83+'Non-P(1~5)'!R85+'Non-P(1~5)'!R87+'Non-P(1~5)'!R89+'Non-P(1~5)'!R93+'Non-P(1~5)'!R95+'Non-P(1~5)'!R97","v":0},null,{"$f":"'P(2)'!AD59+'Non-P(1~5)'!T43+'Non-P(1~5)'!T63+'Non-P(1~5)'!T65+'Non-P(1~5)'!T67+'Non-P(1~5)'!T69+'Non-P(1~5)'!T73+'Non-P(1~5)'!T75+'Non-P(1~5)'!T77+'Non-P(1~5)'!T79+'Non-P(1~5)'!T81+'Non-P(1~5)'!T83+'Non-P(1~5)'!T85+'Non-P(1~5)'!T87+'Non-P(1~5)'!T89+'Non-P(1~5)'!T93+'Non-P(1~5)'!T95+'Non-P(1~5)'!T97","v":0},null,{"$f":"'P(3)'!AD59+'Non-P(1~5)'!V43+'Non-P(1~5)'!V63+'Non-P(1~5)'!V65+'Non-P(1~5)'!V67+'Non-P(1~5)'!V69+'Non-P(1~5)'!V73+'Non-P(1~5)'!V75+'Non-P(1~5)'!V77+'Non-P(1~5)'!V79+'Non-P(1~5)'!V81+'Non-P(1~5)'!V83+'Non-P(1~5)'!V85+'Non-P(1~5)'!V87+'Non-P(1~5)'!V89+'Non-P(1~5)'!V93+'Non-P(1~5)'!V95+'Non-P(1~5)'!V97","v":0},null,{"$f":"'P(4)'!AD59+'Non-P(1~5)'!X43+'Non-P(1~5)'!X63+'Non-P(1~5)'!X65+'Non-P(1~5)'!X67+'Non-P(1~5)'!X69+'Non-P(1~5)'!X73+'Non-P(1~5)'!X75+'Non-P(1~5)'!X77+'Non-P(1~5)'!X79+'Non-P(1~5)'!X81+'Non-P(1~5)'!X83+'Non-P(1~5)'!X85+'Non-P(1~5)'!X87+'Non-P(1~5)'!X89+'Non-P(1~5)'!X93+'Non-P(1~5)'!X95+'Non-P(1~5)'!X97","v":0},null,{"$f":"'P(5)'!AD59+'Non-P(1~5)'!Z43+'Non-P(1~5)'!Z63+'Non-P(1~5)'!Z65+'Non-P(1~5)'!Z67+'Non-P(1~5)'!Z69+'Non-P(1~5)'!Z73+'Non-P(1~5)'!Z75+'Non-P(1~5)'!Z77+'Non-P(1~5)'!Z79+'Non-P(1~5)'!Z81+'Non-P(1~5)'!Z83+'Non-P(1~5)'!Z85+'Non-P(1~5)'!Z87+'Non-P(1~5)'!Z89+'Non-P(1~5)'!Z93+'Non-P(1~5)'!Z95+'Non-P(1~5)'!Z97","v":0}]
[]
[]
[null,null,null,"Indirect Cost Type",null,null,null,null,null,null,"Indirect Cost Rate (%)",null,null,null,"Indirect Cost Base ($)"]
[]
["Year 1",null,null,"MTDC",null,null,null,null,null,null,null,null,null,"x",{"$f":"R115","v":0},"=",null,{"$f":"K120*O120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
["Year 2",null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"T115","v":0},"=",null,null,null,{"$f":"K122*O122","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
["Year 3",null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"V115","v":0},"=",null,null,null,null,null,{"$f":"K124*O124","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
["Year 4",null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"X115","v":0},"=",null,null,null,null,null,null,null,{"$f":"K126*O126","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
["Year 5",null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"Z115","v":0},"=",null,null,null,null,null,null,null,null,null,{"$f":"K128*O128","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Indirect Costs",null,{"$f":"R120","v":0},null,{"$f":"T122","v":0},null,{"$f":"V124","v":0},null,{"$f":"X126","v":0},null,{"$f":"Z128","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cognizant Federal Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continue Below ↓"]
[]
[]
[null,null,null,"I.      Total Direct and Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"Total Direct and Indirect Institutional Costs (G + H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R111+R130","v":0},null,{"$f":"T111+T130","v":0},null,{"$f":"V111+V124","v":0},null,{"$f":"X111+X130","v":0},null,{"$f":"Z111+Z130","v":0}]
[]
[]
[null,null,null,"J.      Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[]
[null,"Fee"]

{"sheet":"Summary(1~5)","index":8,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["Summary Years 1 ~ 5"]
[]
[]
[]
[null,null,null,"Section A, Senior / Key Person",null,null,null,null,null,null,null,null,null,{"$f":"'P(1)'!AD31+'P(2)'!AD31+'P(3)'!AD31+'P(4)'!AD31+'P(5)'!AD31","v":0}]
[]
[null,null,null,"Section B, Other Personnel",null,null,null,null,null,null,null,null,null,{"$f":"'P(1)'!AD57+'P(2)'!AD57+'P(3)'!AD57+'P(4)'!AD57+'P(5)'!AD57","v":0}]
[]
[null,null,null,"Total Number Other Personnel",null,null,null,null,null,null,null,{"$f":"'P(1)'!B57+'P(2)'!B57+'P(3)'!B57+'P(4)'!B57+'P(5)'!B57","v":0}]
[]
[null,null,null,"Total Salary, Wages, and Fringe Benefits (A + B)",null,null,null,null,null,null,null,null,null,{"$f":"'P(1)'!AD59+'P(2)'!AD59+'P(3)'!AD59+'P(4)'!AD59+'P(5)'!AD59","v":0}]
[]
[null,null,null,"Section C, Equipment",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R35+'Non-P(1~5)'!T35+'Non-P(1~5)'!V35+'Non-P(1~5)'!X35+'Non-P(1~5)'!Z35","v":0}]
[]
[null,null,null,"Section D, Travel",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R43+'Non-P(1~5)'!T43+'Non-P(1~5)'!V43+'Non-P(1~5)'!X43+'Non-P(1~5)'!Z43","v":0}]
[]
[null,null,null,"1. Domestic",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R39+'Non-P(1~5)'!T39+'Non-P(1~5)'!V39+'Non-P(1~5)'!X39+'Non-P(1~5)'!Z39","v":0}]
[]
[null,null,null,"2. Foreign",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R41+'Non-P(1~5)'!T41+'Non-P(1~5)'!V41+'Non-P(1~5)'!X41+'Non-P(1~5)'!Z41","v":0}]
[]
[null,null,null,"Section E, Participant / Trainee Support Costs",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R57+'Non-P(1~5)'!T57+'Non-P(1~5)'!V57+'Non-P(1~5)'!X57+'Non-P(1~5)'!Z57","v":0}]
[]
[null,null,null,"1. Tuition / Fees / Health Insurance",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R47+'Non-P(1~5)'!T47+'Non-P(1~5)'!V47+'Non-P(1~5)'!X47+'Non-P(1~5)'!Z47","v":0}]
[]
[null,null,null,"2. Stipends",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R49+'Non-P(1~5)'!T49+'Non-P(1~5)'!V49+'Non-P(1~5)'!X49+'Non-P(1~5)'!Z49","v":0}]
[]
[null,null,null,"3. Travel",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R51+'Non-P(1~5)'!T51+'Non-P(1~5)'!V51+'Non-P(1~5)'!X51+'Non-P(1~5)'!Z51","v":0}]
[]
[null,null,null,"4. Subsistence",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R53+'Non-P(1~5)'!T53+'Non-P(1~5)'!V53+'Non-P(1~5)'!X53+'Non-P(1~5)'!Z53","v":0}]
[]
[null,null,null,"5. Other",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R55+'Non-P(1~5)'!T55+'Non-P(1~5)'!V55+'Non-P(1~5)'!X55+'Non-P(1~5)'!Z55","v":0}]
[]
[null,null,null,"6. Number of Participants / Trainees",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!B57","v":"2"}]
[]
[null,null,null,"Section F, Other Direct Costs",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R107+'Non-P(1~5)'!T107+'Non-P(1~5)'!V107+'Non-P(1~5)'!X107+'Non-P(1~5)'!Z107","v":0}]
[]
[null,null,null,"1. Materials and Supplies",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R63+'Non-P(1~5)'!T63+'Non-P(1~5)'!V63+'Non-P(1~5)'!X63+'Non-P(1~5)'!Z63","v":0}]
[]
[null,null,null,"2. Publication Costs",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R65+'Non-P(1~5)'!T65+'Non-P(1~5)'!V65+'Non-P(1~5)'!X65+'Non-P(1~5)'!Z65","v":0}]
[]
[null,null,null,"3. Consultant Services",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R67+'Non-P(1~5)'!T67+'Non-P(1~5)'!V67+'Non-P(1~5)'!X67+'Non-P(1~5)'!Z67","v":0}]
[]
[null,null,null,"4. ADP / Computer Services",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R69+'Non-P(1~5)'!T69+'Non-P(1~5)'!V69+'Non-P(1~5)'!X69+'Non-P(1~5)'!Z69","v":0}]
[]
[null,null,null,"5. Subawards / Consortium / Contractual Costs",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!AA72+'Non-P(1~5)'!AA74+'Non-P(1~5)'!AA76+'Non-P(1~5)'!AA78+'Non-P(1~5)'!AA80+'Non-P(1~5)'!AA82+'Non-P(1~5)'!AA84","v":0}]
[]
[null,null,null,"6. Equipment or Facility Rental / User Fees",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R87+'Non-P(1~5)'!T87+'Non-P(1~5)'!V87+'Non-P(1~5)'!X87+'Non-P(1~5)'!Z87","v":0}]
[]
[null,null,null,"7. Alterations or Renovations",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R89+'Non-P(1~5)'!T89+'Non-P(1~5)'!V89+'Non-P(1~5)'!X89+'Non-P(1~5)'!Z89","v":0}]
[]
[null,null,null,"8. Other 1 (Tuition Remission)",null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R91+'Non-P(1~5)'!T91+'Non-P(1~5)'!V91+'Non-P(1~5)'!X91+'Non-P(1~5)'!Z91","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"9. Other 2 (\",'Non-P(1~5)'!D93:P93,\")\")","v":"9. Other 2 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R93+'Non-P(1~5)'!T93+'Non-P(1~5)'!V93+'Non-P(1~5)'!X93+'Non-P(1~5)'!Z93","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"10. Other 3 (\",'Non-P(1~5)'!D95:P95,\")\")","v":"10. Other 3 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R95+'Non-P(1~5)'!T95+'Non-P(1~5)'!V95+'Non-P(1~5)'!X95+'Non-P(1~5)'!Z95","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"11. Other 4 (\",'Non-P(1~5)'!D97:P97,\")\")","v":"11. Other 4 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R97+'Non-P(1~5)'!T97+'Non-P(1~5)'!V97+'Non-P(1~5)'!X97+'Non-P(1~5)'!Z97","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"12. Other 5 (\",'Non-P(1~5)'!D99:P99,\")\")","v":"12. Other 5 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R99+'Non-P(1~5)'!T99+'Non-P(1~5)'!V99+'Non-P(1~5)'!X99+'Non-P(1~5)'!Z99","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"13. Other 6 (\",'Non-P(1~5)'!D101:P101,\")\")","v":"13. Other 6 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R101+'Non-P(1~5)'!T101+'Non-P(1~5)'!V101+'Non-P(1~5)'!X101+'Non-P(1~5)'!Z101","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"14. Other 7 (\",'Non-P(1~5)'!D103:P103,\")\")","v":"14. Other 7 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R103+'Non-P(1~5)'!T103+'Non-P(1~5)'!V103+'Non-P(1~5)'!X103+'Non-P(1~5)'!Z103","v":0}]
[]
[null,null,null,{"$f":"CONCATENATE(\"15. Other 8 (\",'Non-P(1~5)'!D105:P105,\")\")","v":"15. Other 8 ()"},null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R105+'Non-P(1~5)'!T105+'Non-P(1~5)'!V105+'Non-P(1~5)'!X105+'Non-P(1~5)'!Z105","v":0}]
[]
[null,null,null,"Section G, Direct Costs (A thru F)",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R111+'Non-P(1~5)'!T111+'Non-P(1~5)'!V111+'Non-P(1~5)'!X111+'Non-P(1~5)'!Z111","v":0}]
[]
[null,null,null,"Section H, Indirect Costs",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R130+'Non-P(1~5)'!T130+'Non-P(1~5)'!V130+'Non-P(1~5)'!X130+'Non-P(1~5)'!Z130","v":0}]
[]
[null,null,null,"Section I, Total Direct and Indirect Costs (G + H)",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R139+'Non-P(1~5)'!T139+'Non-P(1~5)'!V139+'Non-P(1~5)'!X139+'Non-P(1~5)'!Z139","v":0}]
[]
[null,null,null,"Section J, Fee",null,null,null,null,null,null,null,null,null,{"$f":"'Non-P(1~5)'!R144+'Non-P(1~5)'!T144+'Non-P(1~5)'!V144+'Non-P(1~5)'!X144+'Non-P(1~5)'!Z144","v":0}]

{"sheet":"Reference","index":9,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,29]]}
["Reference"]
[]
["Fringe Rates","FY 2026"]
[]
["Category","Rate"]
["Academic Staff",0.34699999999999998]
["Ad Hoc Program Specialists",0.14599999999999999]
["Grad Interns",0.253]
["Limited Term Employees",0.10100000000000001]
["Post-Doc Fellows and/or Trainees",0.158]
["Pre-Doc Fellows and/or Trainees",0.20699999999999999]
["Program Assistants",0.20699999999999999]
["Project Assistants",0.20699999999999999]
["Regular University Staff",0.43099999999999999]
["Regular Faculty",0.34699999999999998]
["Research Assistants",0.20699999999999999]
["Research Associates",0.253]
["Student Hourly Employes",1.9E-2]
["Teaching Assistants",0.20699999999999999]
["Undergraduate Assistants",0.14599999999999999]
["Undergraduate Interns",0.14599999999999999]