{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Start here","Salaries & Wages","Equip-Travel-Participants","Other Direct","Subcontracts","Cumulative Budget","BA Upload","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":33,"comments":4,"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":"Start here","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,8,12,12],[13,5,13,6],[15,1,15,7],[11,0,11,2],[12,0,13,3],[9,0,9,2],[7,0,7,2],[5,0,5,2],[5,3,5,7],[7,3,7,7],[0,7,0,8],[2,0,2,1],[1,0,1,8],[3,0,3,2],[3,3,3,7]]}
[null,null,"Running Total for Cumulative Budget Amount = ",null,null,null,null,{"$f":"'Cumulative Budget'!AE65","v":0}]
["Worksheet for Project Budget"]
["Effective 7/1/2014  Revised 6/30/2014"]
["Principal Investigator:"]
[]
["Sponsor:"]
[]
["Project Title:"]
[]
["Project Period:",null,null,"Start Date",null,"End Date",null,"Total Years",1]
[null,null,null,null,"mm/dd/yyyy",null,"mm/dd/yyyy"]
["Indirect Cost Rate:",null,null,null,"On-campus Organized Research",null,{"$f":"VLOOKUP(E12,E18:G32,2,FALSE)","v":0.5}]
[null,null,null,null,null,null,null,null,"Please refer to the Indirect Cost Rate and Policy links on the Links Tab"]
[null,null,null,null,"(specify rate if Other)","<< Only enter rate       << for \"Other-specify\""]
[]
[null,"** Note: Enter data in white boxes only.  Please enter information in all of the boxes on this page.  There are helpful hints for most pages.  To view them, hover over a cell with a red triangle in the corner.  **"]
[]
[null,null,null,null,"On-campus Organized Research",0.5,"mtdc"]
[null,null,null,null,"On-campus Instruction",0.51,"mtdc"]
[null,null,null,null,"On-campus Other Sponsored Activities",0.32,"mtdc"]
[null,null,null,null,"Off-campus All Programs",0.26,"mtdc"]
[null,null,null,null,"Training",0.08,"direct"]
[null,null,null,null,"NSF-on-campus",{"$f":"+F18","v":0.5},"participant"]
[null,null,null,null,"NSF-off-campus",{"$f":"+F21","v":0.26},"participant"]
[null,null,null,null,"NSF - REU",0.5,"stipend"]
[null,null,null,null,"USDA-22%",0.28205000000000002,"direct"]
[null,null,null,null,"USDA-30%",0.42857000000000001,"direct"]
[null,null,null,null,"Other - 0%",0,"direct"]
[null,null,null,null,"Other - 8%",0.08,"direct"]
[null,null,null,null,"Other - 10%",0.1,"direct"]
[null,null,null,null,"Other - 15%",0.15,"direct"]
[null,null,null,null,"Other - Specify below",{"$f":"+E14","v":"(specify rate if Other)"},"other"]

{"sheet":"Salaries & Wages","index":1,"n_rows":386,"n_cols":32,"rows_kept":386,"cut":false,"hidden":false,"merged":[[64,3,64,7],[8,13,8,15],[78,0,78,14],[78,17,78,19],[52,3,52,7],[56,3,56,7],[58,3,58,7],[60,3,60,7],[66,3,66,7],[50,3,50,7],[10,0,10,14],[10,17,10,19],[46,3,46,7],[48,3,48,7],[54,3,54,7],[62,3,62,7],[68,3,68,7],[70,3,70,7],[72,3,72,7],[195,3,195,7],[113,3,113,7],[117,3,117,7],[123,3,123,7],[125,3,125,7],[127,3,127,7],[183,3,183,7],[115,3,115,7],[119,3,119,7],[121,3,121,7],[146,17,146,19],[181,3,181,7],[135,3,135,7],[137,3,137,7],[139,3,139,7],[329,3,329,7],[331,3,331,7],[333,3,333,7],[187,3,187,7],[189,3,189,7],[191,3,191,7],[193,3,193,7],[203,3,203,7],[205,3,205,7],[207,3,207,7],[317,3,317,7],[319,3,319,7],[321,3,321,7],[323,3,323,7],[325,3,325,7],[327,3,327,7],[197,3,197,7],[199,3,199,7],[201,3,201,7],[129,3,129,7],[131,3,131,7],[133,3,133,7],[146,0,146,14],[185,3,185,7],[214,0,214,14],[214,17,214,19],[249,3,249,7],[251,3,251,7],[253,3,253,7],[255,3,255,7],[282,17,282,19],[257,3,257,7],[259,3,259,7],[261,3,261,7],[263,3,263,7],[265,3,265,7],[267,3,267,7],[269,3,269,7],[271,3,271,7],[273,3,273,7],[275,3,275,7],[282,0,282,14],[335,3,335,7],[337,3,337,7],[339,3,339,7],[341,3,341,7],[343,3,343,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Running Total for Cumulative Budget Amount = ",null,null,null,null,null,{"$f":"'Cumulative Budget'!AE65","v":0}]
[]
["Worksheet for Project Budget - Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Please select an escalation rate for all salaries below"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03]
[null,"Senior Personnel"]
[null,"Prefix",null,"First Name",null,"Middle Init.",null,"Last Name",null,"Classification",null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[1,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L16*(+N16+P16+R16),0)","v":0},null,{"$f":"VLOOKUP(J16,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V16*T16,0)","v":0},null,{"$f":"ROUND(X16+T16,0)","v":0},null,null,null,{"$f":"ROUND(AB16*V16,0)","v":0},null,{"$f":"ROUND(AD16+AB16,0)","v":0}]
[]
[2,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L18*(+N18+P18+R18),0)","v":0},null,{"$f":"VLOOKUP(J18,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V18*T18,0)","v":0},null,{"$f":"ROUND(X18+T18,0)","v":0},null,null,null,{"$f":"ROUND(AB18*V18,0)","v":0},null,{"$f":"ROUND(AD18+AB18,0)","v":0}]
[]
[3,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L20*(+N20+P20+R20),0)","v":0},null,{"$f":"VLOOKUP(J20,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V20*T20,0)","v":0},null,{"$f":"ROUND(X20+T20,0)","v":0},null,null,null,{"$f":"ROUND(AB20*V20,0)","v":0},null,{"$f":"ROUND(AD20+AB20,0)","v":0}]
[]
[4,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L22*(+N22+P22+R22),0)","v":0},null,{"$f":"VLOOKUP(J22,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V22*T22,0)","v":0},null,{"$f":"ROUND(X22+T22,0)","v":0},null,null,null,{"$f":"ROUND(AB22*V22,0)","v":0},null,{"$f":"ROUND(AD22+AB22,0)","v":0}]
[]
[5,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L24*(+N24+P24+R24),0)","v":0},null,{"$f":"VLOOKUP(J24,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V24*T24,0)","v":0},null,{"$f":"ROUND(X24+T24,0)","v":0},null,null,null,{"$f":"ROUND(AB24*V24,0)","v":0},null,{"$f":"ROUND(AD24+AB24,0)","v":0}]
[]
[6,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L26*(+N26+P26+R26),0)","v":0},null,{"$f":"VLOOKUP(J26,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V26*T26,0)","v":0},null,{"$f":"ROUND(X26+T26,0)","v":0},null,null,null,{"$f":"ROUND(AB26*V26,0)","v":0},null,{"$f":"ROUND(AD26+AB26,0)","v":0}]
[]
[7,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L28*(+N28+P28+R28),0)","v":0},null,{"$f":"VLOOKUP(J28,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V28*T28,0)","v":0},null,{"$f":"ROUND(X28+T28,0)","v":0},null,null,null,{"$f":"ROUND(AB28*V28,0)","v":0},null,{"$f":"ROUND(AD28+AB28,0)","v":0}]
[]
[8,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L30*(+N30+P30+R30),0)","v":0},null,{"$f":"VLOOKUP(J30,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V30*T30,0)","v":0},null,{"$f":"ROUND(X30+T30,0)","v":0},null,null,null,{"$f":"ROUND(AB30*V30,0)","v":0},null,{"$f":"ROUND(AD30+AB30,0)","v":0}]
[]
[9,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L32*(+N32+P32+R32),0)","v":0},null,{"$f":"VLOOKUP(J32,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V32*T32,0)","v":0},null,{"$f":"ROUND(X32+T32,0)","v":0},null,null,null,{"$f":"ROUND(AB32*V32,0)","v":0},null,{"$f":"ROUND(AD32+AB32,0)","v":0}]
[]
[10,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L34*(+N34+P34+R34),0)","v":0},null,{"$f":"VLOOKUP(J34,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V34*T34,0)","v":0},null,{"$f":"ROUND(X34+T34,0)","v":0},null,null,null,{"$f":"ROUND(AB34*V34,0)","v":0},null,{"$f":"ROUND(AD34+AB34,0)","v":0}]
[]
[11,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L36*(+N36+P36+R36),0)","v":0},null,{"$f":"VLOOKUP(J36,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V36*T36,0)","v":0},null,{"$f":"ROUND(X36+T36,0)","v":0},null,null,null,{"$f":"ROUND(AB36*V36,0)","v":0},null,{"$f":"ROUND(AD36+AB36,0)","v":0}]
[]
[12,null,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L38*(+N38+P38+R38),0)","v":0},null,{"$f":"VLOOKUP(J38,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V38*T38,0)","v":0},null,{"$f":"ROUND(X38+T38,0)","v":0},null,null,null,{"$f":"ROUND(AB38*V38,0)","v":0},null,{"$f":"ROUND(AD38+AB38,0)","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,"Total Senior Personnel",null,{"$f":"SUM(Z16:Z38)","v":0},null,null,null,"Total Senior Personnel",null,{"$f":"SUM(AF16:AF38)","v":0}]
[]
[]
[null,"Other Personnel"]
[null,"Number of Personnel",null,null,null,null,null,null,null,null,null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[null,null,null,"Post Doctoral Associate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L47*(+N47+P47+R47)*B47,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V47*T47,0)","v":0},null,{"$f":"ROUND(X47+T47,0)","v":0},null,null,null,{"$f":"ROUND(AB47*V47,0)","v":0},null,{"$f":"ROUND(AD47+AB47,0)","v":0}]
[]
[null,null,null,"Post Doctoral Associate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L49*(+N49+P49+R49)*B49,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V49*T49,0)","v":0},null,{"$f":"ROUND(X49+T49,0)","v":0},null,null,null,{"$f":"ROUND(AB49*V49,0)","v":0},null,{"$f":"ROUND(AD49+AB49,0)","v":0}]
[]
[null,0,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L51*(+N51+P51+R51)*B51,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V51*T51,0)","v":0},null,{"$f":"ROUND(X51+T51,0)","v":0},null,null,null,{"$f":"ROUND(AB51*V51,0)","v":0},null,{"$f":"ROUND(AD51+AB51,0)","v":0}]
[]
[null,0,null,"Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L53*(+N53+P53+R53)*B53,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V53*T53,0)","v":0},null,{"$f":"ROUND(X53+T53,0)","v":0},null,null,null,{"$f":"ROUND(AB53*V53,0)","v":0},null,{"$f":"ROUND(AD53+AB53,0)","v":0}]
[]
[null,0,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L55*(+N55+P55+R55)*B55,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V55*T55,0)","v":0},null,{"$f":"ROUND(X55+T55,0)","v":0},null,null,null,{"$f":"ROUND(AB55*V55,0)","v":0},null,{"$f":"ROUND(AD55+AB55,0)","v":0}]
[]
[null,0,null,"Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L57*(+N57+P57+R57)*B57,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V57*T57,0)","v":0},null,{"$f":"ROUND(X57+T57,0)","v":0},null,null,null,{"$f":"ROUND(AB57*V57,0)","v":0},null,{"$f":"ROUND(AD57+AB57,0)","v":0}]
[]
[null,0,null,"Secretarial/Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L59*(+N59+P59+R59)*B59,0)","v":0},null,{"$f":"$H$375","v":0.51},null,{"$f":"ROUND(V59*T59,0)","v":0},null,{"$f":"ROUND(X59+T59,0)","v":0},null,null,null,{"$f":"ROUND(AB59*V59,0)","v":0},null,{"$f":"ROUND(AD59+AB59,0)","v":0}]
[]
[null,0,null,"Non-Student Hourly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L61*(+N61+P61+R61)*B61,0)","v":0},null,{"$f":"$H$371","v":0.12},null,{"$f":"ROUND(V61*T61,0)","v":0},null,{"$f":"ROUND(X61+T61,0)","v":0},null,null,null,{"$f":"ROUND(AB61*V61,0)","v":0},null,{"$f":"ROUND(AD61+AB61,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L63*(+N63+P63+R63)*B63,0)","v":0},null,{"$f":"VLOOKUP(J63,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V63*T63,0)","v":0},null,{"$f":"ROUND(X63+T63,0)","v":0},null,null,null,{"$f":"ROUND(AB63*V63,0)","v":0},null,{"$f":"ROUND(AD63+AB63,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L65*(+N65+P65+R65)*B65,0)","v":0},null,{"$f":"VLOOKUP(J65,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V65*T65,0)","v":0},null,{"$f":"ROUND(X65+T65,0)","v":0},null,null,null,{"$f":"ROUND(AB65*V65,0)","v":0},null,{"$f":"ROUND(AD65+AB65,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L67*(+N67+P67+R67)*B67,0)","v":0},null,{"$f":"VLOOKUP(J67,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V67*T67,0)","v":0},null,{"$f":"ROUND(X67+T67,0)","v":0},null,null,null,{"$f":"ROUND(AB67*V67,0)","v":0},null,{"$f":"ROUND(AD67+AB67,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L69*(+N69+P69+R69)*B69,0)","v":0},null,{"$f":"VLOOKUP(J69,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V69*T69,0)","v":0},null,{"$f":"ROUND(X69+T69,0)","v":0},null,null,null,{"$f":"ROUND(AB69*V69,0)","v":0},null,{"$f":"ROUND(AD69+AB69,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L71*(+N71+P71+R71)*B71,0)","v":0},null,{"$f":"VLOOKUP(J71,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V71*T71,0)","v":0},null,{"$f":"ROUND(X71+T71,0)","v":0},null,null,null,{"$f":"ROUND(AB71*V71,0)","v":0},null,{"$f":"ROUND(AD71+AB71,0)","v":0}]
[]
[null,0,null,null,null,null,null,null,null," Select one",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L73*(+N73+P73+R73)*B73,0)","v":0},null,{"$f":"VLOOKUP(J73,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V73*T73,0)","v":0},null,{"$f":"ROUND(X73+T73,0)","v":0},null,null,null,{"$f":"ROUND(AB73*V73,0)","v":0},null,{"$f":"ROUND(AD73+AB73,0)","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,"Total Other Personnel",null,{"$f":"SUM(Z47:Z73)","v":0},null,null,null,"Total Other Personnel",null,{"$f":"SUM(AF47:AF73)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1 Totals","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X47:X73,X16:X38)","v":0},null,{"$f":"SUM(T47:T73,T16:T38)","v":0}]
["Worksheet for Project Budget - Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,"Senior Personnel"]
[null,"Prefix",null,"First Name",null,"Middle Init.",null,"Last Name",null,"Classification",null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[1,{"$f":"+IF(years>1,+B16,0)","v":0},null,{"$f":"+IF(years>1,+D16,0)","v":0},null,{"$f":"+IF(years>1,+F16,0)","v":0},null,{"$f":"+IF(years>1,+H16,0)","v":0},null,{"$f":"+IF(years>1,J16, J16)","v":" Select one"},null,{"$f":"+IF(years>1,+L16+(L16*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N16,0)","v":0},null,{"$f":"+IF(years>1,+P16,0)","v":0},null,{"$f":"+IF(years>1,+R16,0)","v":0},null,{"$f":"ROUND(L83*(+N83+P83+R83),0)","v":0},null,{"$f":"VLOOKUP(J83,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V83*T83,0)","v":0},null,{"$f":"ROUND(X83+T83,0)","v":0},null,{"$f":"+IF(years>1,+AB16+(AB16*$R$12),0)","v":0},null,{"$f":"ROUND(AB83*V83,0)","v":0},null,{"$f":"ROUND(AD83+AB83,0)","v":0}]
[]
[2,{"$f":"+IF(years>1,+B18,0)","v":0},null,{"$f":"+IF(years>1,+D18,0)","v":0},null,{"$f":"+IF(years>1,+F18,0)","v":0},null,{"$f":"+IF(years>1,+H18,0)","v":0},null,{"$f":"+IF(years>1,J18, J18)","v":" Select one"},null,{"$f":"+IF(years>1,+L18+(L18*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N18,0)","v":0},null,{"$f":"+IF(years>1,+P18,0)","v":0},null,{"$f":"+IF(years>1,+R18,0)","v":0},null,{"$f":"ROUND(L85*(+N85+P85+R85),0)","v":0},null,{"$f":"VLOOKUP(J85,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V85*T85,0)","v":0},null,{"$f":"ROUND(X85+T85,0)","v":0},null,{"$f":"+IF(years>1,+AB18+(AB18*$R$12),0)","v":0},null,{"$f":"ROUND(AB85*V85,0)","v":0},null,{"$f":"ROUND(AD85+AB85,0)","v":0}]
[]
[3,{"$f":"+IF(years>1,+B20,0)","v":0},null,{"$f":"+IF(years>1,+D20,0)","v":0},null,{"$f":"+IF(years>1,+F20,0)","v":0},null,{"$f":"+IF(years>1,+H20,0)","v":0},null,{"$f":"+IF(years>1,J20, J20)","v":" Select one"},null,{"$f":"+IF(years>1,+L20+(L20*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N20,0)","v":0},null,{"$f":"+IF(years>1,+P20,0)","v":0},null,{"$f":"+IF(years>1,+R20,0)","v":0},null,{"$f":"ROUND(L87*(+N87+P87+R87),0)","v":0},null,{"$f":"VLOOKUP(J87,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V87*T87,0)","v":0},null,{"$f":"ROUND(X87+T87,0)","v":0},null,{"$f":"+IF(years>1,+AB20+(AB20*$R$12),0)","v":0},null,{"$f":"ROUND(AB87*V87,0)","v":0},null,{"$f":"ROUND(AD87+AB87,0)","v":0}]
[]
[4,{"$f":"+IF(years>1,+B22,0)","v":0},null,{"$f":"+IF(years>1,+D22,0)","v":0},null,{"$f":"+IF(years>1,+F22,0)","v":0},null,{"$f":"+IF(years>1,+H22,0)","v":0},null,{"$f":"+IF(years>1,J22, J22)","v":" Select one"},null,{"$f":"+IF(years>1,+L22+(L22*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N22,0)","v":0},null,{"$f":"+IF(years>1,+P22,0)","v":0},null,{"$f":"+IF(years>1,+R22,0)","v":0},null,{"$f":"ROUND(L89*(+N89+P89+R89),0)","v":0},null,{"$f":"VLOOKUP(J89,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V89*T89,0)","v":0},null,{"$f":"ROUND(X89+T89,0)","v":0},null,{"$f":"+IF(years>1,+AB22+(AB22*$R$12),0)","v":0},null,{"$f":"ROUND(AB89*V89,0)","v":0},null,{"$f":"ROUND(AD89+AB89,0)","v":0}]
[]
[5,{"$f":"+IF(years>1,+B24,0)","v":0},null,{"$f":"+IF(years>1,+D24,0)","v":0},null,{"$f":"+IF(years>1,+F24,0)","v":0},null,{"$f":"+IF(years>1,+H24,0)","v":0},null,{"$f":"+IF(years>1,J24, J24)","v":" Select one"},null,{"$f":"+IF(years>1,+L24+(L24*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N24,0)","v":0},null,{"$f":"+IF(years>1,+P24,0)","v":0},null,{"$f":"+IF(years>1,+R24,0)","v":0},null,{"$f":"ROUND(L91*(+N91+P91+R91),0)","v":0},null,{"$f":"VLOOKUP(J91,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V91*T91,0)","v":0},null,{"$f":"ROUND(X91+T91,0)","v":0},null,{"$f":"+IF(years>1,+AB24+(AB24*$R$12),0)","v":0},null,{"$f":"ROUND(AB91*V91,0)","v":0},null,{"$f":"ROUND(AD91+AB91,0)","v":0}]
[]
[6,{"$f":"+IF(years>1,+B26,0)","v":0},null,{"$f":"+IF(years>1,+D26,0)","v":0},null,{"$f":"+IF(years>1,+F26,0)","v":0},null,{"$f":"+IF(years>1,+H26,0)","v":0},null,{"$f":"+IF(years>1,J26, J26)","v":" Select one"},null,{"$f":"+IF(years>1,+L26+(L26*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N26,0)","v":0},null,{"$f":"+IF(years>1,+P26,0)","v":0},null,{"$f":"+IF(years>1,+R26,0)","v":0},null,{"$f":"ROUND(L93*(+N93+P93+R93),0)","v":0},null,{"$f":"VLOOKUP(J93,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V93*T93,0)","v":0},null,{"$f":"ROUND(X93+T93,0)","v":0},null,{"$f":"+IF(years>1,+AB26+(AB26*$R$12),0)","v":0},null,{"$f":"ROUND(AB93*V93,0)","v":0},null,{"$f":"ROUND(AD93+AB93,0)","v":0}]
[]
[7,{"$f":"+IF(years>1,+B28,0)","v":0},null,{"$f":"+IF(years>1,+D28,0)","v":0},null,{"$f":"+IF(years>1,+F28,0)","v":0},null,{"$f":"+IF(years>1,+H28,0)","v":0},null,{"$f":"+IF(years>1,J28, J28)","v":" Select one"},null,{"$f":"+IF(years>1,+L28+(L28*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N28,0)","v":0},null,{"$f":"+IF(years>1,+P28,0)","v":0},null,{"$f":"+IF(years>1,+R28,0)","v":0},null,{"$f":"ROUND(L95*(+N95+P95+R95),0)","v":0},null,{"$f":"VLOOKUP(J95,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V95*T95,0)","v":0},null,{"$f":"ROUND(X95+T95,0)","v":0},null,{"$f":"+IF(years>1,+AB28+(AB28*$R$12),0)","v":0},null,{"$f":"ROUND(AB95*V95,0)","v":0},null,{"$f":"ROUND(AD95+AB95,0)","v":0}]
[]
[8,{"$f":"+IF(years>1,+B30,0)","v":0},null,{"$f":"+IF(years>1,+D30,0)","v":0},null,{"$f":"+IF(years>1,+F30,0)","v":0},null,{"$f":"+IF(years>1,+H30,0)","v":0},null,{"$f":"+IF(years>1,J30, J30)","v":" Select one"},null,{"$f":"+IF(years>1,+L30+(L30*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N30,0)","v":0},null,{"$f":"+IF(years>1,+P30,0)","v":0},null,{"$f":"+IF(years>1,+R30,0)","v":0},null,{"$f":"ROUND(L97*(+N97+P97+R97),0)","v":0},null,{"$f":"VLOOKUP(J97,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V97*T97,0)","v":0},null,{"$f":"ROUND(X97+T97,0)","v":0},null,{"$f":"+IF(years>1,+AB30+(AB30*$R$12),0)","v":0},null,{"$f":"ROUND(AB97*V97,0)","v":0},null,{"$f":"ROUND(AD97+AB97,0)","v":0}]
[]
[9,{"$f":"+IF(years>1,+B32,0)","v":0},null,{"$f":"+IF(years>1,+D32,0)","v":0},null,{"$f":"+IF(years>1,+F32,0)","v":0},null,{"$f":"+IF(years>1,+H32,0)","v":0},null,{"$f":"+IF(years>1,J32, J32)","v":" Select one"},null,{"$f":"+IF(years>1,+L32+(L32*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N32,0)","v":0},null,{"$f":"+IF(years>1,+P32,0)","v":0},null,{"$f":"+IF(years>1,+R32,0)","v":0},null,{"$f":"ROUND(L99*(+N99+P99+R99),0)","v":0},null,{"$f":"VLOOKUP(J99,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V99*T99,0)","v":0},null,{"$f":"ROUND(X99+T99,0)","v":0},null,{"$f":"+IF(years>1,+AB32+(AB32*$R$12),0)","v":0},null,{"$f":"ROUND(AB99*V99,0)","v":0},null,{"$f":"ROUND(AD99+AB99,0)","v":0}]
[]
[10,{"$f":"+IF(years>1,+B34,0)","v":0},null,{"$f":"+IF(years>1,+D34,0)","v":0},null,{"$f":"+IF(years>1,+F34,0)","v":0},null,{"$f":"+IF(years>1,+H34,0)","v":0},null,{"$f":"+IF(years>1,J34, J34)","v":" Select one"},null,{"$f":"+IF(years>1,+L34+(L34*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N34,0)","v":0},null,{"$f":"+IF(years>1,+P34,0)","v":0},null,{"$f":"+IF(years>1,+R34,0)","v":0},null,{"$f":"ROUND(L101*(+N101+P101+R101),0)","v":0},null,{"$f":"VLOOKUP(J101,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V101*T101,0)","v":0},null,{"$f":"ROUND(X101+T101,0)","v":0},null,{"$f":"+IF(years>1,+AB34+(AB34*$R$12),0)","v":0},null,{"$f":"ROUND(AB101*V101,0)","v":0},null,{"$f":"ROUND(AD101+AB101,0)","v":0}]
[]
[11,{"$f":"+IF(years>1,+B36,0)","v":0},null,{"$f":"+IF(years>1,+D36,0)","v":0},null,{"$f":"+IF(years>1,+F36,0)","v":0},null,{"$f":"+IF(years>1,+H36,0)","v":0},null,{"$f":"+IF(years>1,J36, J36)","v":" Select one"},null,{"$f":"+IF(years>1,+L36+(L36*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N36,0)","v":0},null,{"$f":"+IF(years>1,+P36,0)","v":0},null,{"$f":"+IF(years>1,+R36,0)","v":0},null,{"$f":"ROUND(L103*(+N103+P103+R103),0)","v":0},null,{"$f":"VLOOKUP(J103,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V103*T103,0)","v":0},null,{"$f":"ROUND(X103+T103,0)","v":0},null,{"$f":"+IF(years>1,+AB36+(AB36*$R$12),0)","v":0},null,{"$f":"ROUND(AB103*V103,0)","v":0},null,{"$f":"ROUND(AD103+AB103,0)","v":0}]
[]
[12,{"$f":"+IF(years>1,+B38,0)","v":0},null,{"$f":"+IF(years>1,+D38,0)","v":0},null,{"$f":"+IF(years>1,+F38,0)","v":0},null,{"$f":"+IF(years>1,+H38,0)","v":0},null,{"$f":"+IF(years>1,J38, J38)","v":" Select one"},null,{"$f":"+IF(years>1,+L38+(L38*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N38,0)","v":0},null,{"$f":"+IF(years>1,+P38,0)","v":0},null,{"$f":"+IF(years>1,+R38,0)","v":0},null,{"$f":"ROUND(L105*(+N105+P105+R105),0)","v":0},null,{"$f":"VLOOKUP(J105,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V105*T105,0)","v":0},null,{"$f":"ROUND(X105+T105,0)","v":0},null,{"$f":"+IF(years>1,+AB38+(AB38*$R$12),0)","v":0},null,{"$f":"ROUND(AB105*V105,0)","v":0},null,{"$f":"ROUND(AD105+AB105,0)","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,"Total Senior Personnel",null,{"$f":"SUM(Z83:Z105)","v":0},null,null,null,"Total Senior Personnel",null,{"$f":"SUM(AF83:AF105)","v":0}]
[]
[]
[null,"Other Personnel"]
[null,"Number of Personnel",null,null,null,null,null,null,null,null,null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[null,{"$f":"IF(years>1,+B47,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L47+(L47*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N47,0)","v":0},null,{"$f":"+IF(years>1,+P47,0)","v":0},null,{"$f":"+IF(years>1,+R47,0)","v":0},null,{"$f":"ROUND(L114*(+N114+P114+R114)*B114,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V114*T114,0)","v":0},null,{"$f":"ROUND(X114+T114,0)","v":0},null,{"$f":"+IF(years>1,+AB47+(AB47*$R$12),0)","v":0},null,{"$f":"ROUND(AB114*V114,0)","v":0},null,{"$f":"ROUND(AD114+AB114,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B49,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L49+(L49*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N49,0)","v":0},null,{"$f":"+IF(years>1,+P49,0)","v":0},null,{"$f":"+IF(years>1,+R49,0)","v":0},null,{"$f":"ROUND(L116*(+N116+P116+R116)*B116,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V116*T116,0)","v":0},null,{"$f":"ROUND(X116+T116,0)","v":0},null,{"$f":"+IF(years>1,+AB49+(AB49*$R$12),0)","v":0},null,{"$f":"+AB116*V116","v":0},null,{"$f":"ROUND(AD116+AB116,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B51,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L51+(L51*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N51,0)","v":0},null,{"$f":"+IF(years>1,+P51,0)","v":0},null,{"$f":"+IF(years>1,+R51,0)","v":0},null,{"$f":"ROUND(L118*(+N118+P118+R118)*B118,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V118*T118,0)","v":0},null,{"$f":"ROUND(X118+T118,0)","v":0},null,{"$f":"+IF(years>1,+AB51+(AB51*$R$12),0)","v":0},null,{"$f":"+AB118*V118","v":0},null,{"$f":"ROUND(AD118+AB118,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B53,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L53+(L53*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N53,0)","v":0},null,{"$f":"+IF(years>1,+P53,0)","v":0},null,{"$f":"+IF(years>1,+R53,0)","v":0},null,{"$f":"ROUND(L120*(+N120+P120+R120)*B120,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V120*T120,0)","v":0},null,{"$f":"ROUND(X120+T120,0)","v":0},null,{"$f":"+IF(years>1,+AB53+(AB53*$R$12),0)","v":0},null,{"$f":"+AB120*V120","v":0},null,{"$f":"ROUND(AD120+AB120,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B55,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L55+(L55*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N55,0)","v":0},null,{"$f":"+IF(years>1,+P55,0)","v":0},null,{"$f":"+IF(years>1,+R55,0)","v":0},null,{"$f":"ROUND(L122*(+N122+P122+R122)*B122,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V122*T122,0)","v":0},null,{"$f":"ROUND(X122+T122,0)","v":0},null,{"$f":"+IF(years>1,+AB55+(AB55*$R$12),0)","v":0},null,{"$f":"+AB122*V122","v":0},null,{"$f":"ROUND(AD122+AB122,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B57,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L57+(L57*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N57,0)","v":0},null,{"$f":"+IF(years>1,+P57,0)","v":0},null,{"$f":"+IF(years>1,+R57,0)","v":0},null,{"$f":"ROUND(L124*(+N124+P124+R124)*B124,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V124*T124,0)","v":0},null,{"$f":"ROUND(X124+T124,0)","v":0},null,{"$f":"+IF(years>1,+AB57+(AB57*$R$12),0)","v":0},null,{"$f":"+AB124*V124","v":0},null,{"$f":"ROUND(AD124+AB124,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B59,0)","v":0},null,"Secretarial/Clerical",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L59+(L59*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N59,0)","v":0},null,{"$f":"+IF(years>1,+P59,0)","v":0},null,{"$f":"+IF(years>1,+R59,0)","v":0},null,{"$f":"ROUND(L126*(+N126+P126+R126)*B126,0)","v":0},null,{"$f":"$H$375","v":0.51},null,{"$f":"ROUND(V126*T126,0)","v":0},null,{"$f":"ROUND(X126+T126,0)","v":0},null,{"$f":"+IF(years>1,+AB59+(AB59*$R$12),0)","v":0},null,{"$f":"+AB126*V126","v":0},null,{"$f":"ROUND(AD126+AB126,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B61,0)","v":0},null,"Non-Student Hourly",null,null,null,null,null,null,null,{"$f":"+IF(years>1,+L61+(L61*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N61,0)","v":0},null,{"$f":"+IF(years>1,+P61,0)","v":0},null,{"$f":"+IF(years>1,+R61,0)","v":0},null,{"$f":"ROUND(L128*(+N128+P128+R128)*B128,0)","v":0},null,{"$f":"$H$371","v":0.12},null,{"$f":"ROUND(V128*T128,0)","v":0},null,{"$f":"ROUND(X128+T128,0)","v":0},null,{"$f":"+IF(years>1,+AB61+(AB61*$R$12),0)","v":0},null,{"$f":"+AB128*V128","v":0},null,{"$f":"ROUND(AD128+AB128,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B63,0)","v":0},null,{"$f":"+IF(years>1,+D63,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J63,J63)","v":" Select one"},null,{"$f":"+IF(years>1,+L63+(L63*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N63,0)","v":0},null,{"$f":"+IF(years>1,+P63,0)","v":0},null,{"$f":"+IF(years>1,+R63,0)","v":0},null,{"$f":"ROUND(L130*(+N130+P130+R130)*B130,0)","v":0},null,{"$f":"VLOOKUP(J130,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V130*T130,0)","v":0},null,{"$f":"ROUND(X130+T130,0)","v":0},null,{"$f":"+IF(years>1,+AB63+(AB63*$R$12),0)","v":0},null,{"$f":"+AB130*V130","v":0},null,{"$f":"ROUND(AD130+AB130,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B65,0)","v":0},null,{"$f":"+IF(years>1,+D65,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J65,J65)","v":" Select one"},null,{"$f":"+IF(years>1,+L65+(L65*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N65,0)","v":0},null,{"$f":"+IF(years>1,+P65,0)","v":0},null,{"$f":"+IF(years>1,+R65,0)","v":0},null,{"$f":"ROUND(L132*(+N132+P132+R132)*B132,0)","v":0},null,{"$f":"VLOOKUP(J132,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V132*T132,0)","v":0},null,{"$f":"ROUND(X132+T132,0)","v":0},null,{"$f":"+IF(years>1,+AB65+(AB65*$R$12),0)","v":0},null,{"$f":"+AB132*V132","v":0},null,{"$f":"ROUND(AD132+AB132,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B67,0)","v":0},null,{"$f":"+IF(years>1,+D67,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J67,J67)","v":" Select one"},null,{"$f":"+IF(years>1,+L67+(L67*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N67,0)","v":0},null,{"$f":"+IF(years>1,+P67,0)","v":0},null,{"$f":"+IF(years>1,+R67,0)","v":0},null,{"$f":"ROUND(L134*(+N134+P134+R134)*B134,0)","v":0},null,{"$f":"VLOOKUP(J134,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V134*T134,0)","v":0},null,{"$f":"ROUND(X134+T134,0)","v":0},null,{"$f":"+IF(years>1,+AB67+(AB67*$R$12),0)","v":0},null,{"$f":"+AB134*V134","v":0},null,{"$f":"ROUND(AD134+AB134,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B69,0)","v":0},null,{"$f":"+IF(years>1,+D69,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J69,J69)","v":" Select one"},null,{"$f":"+IF(years>1,+L69+(L69*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N69,0)","v":0},null,{"$f":"+IF(years>1,+P69,0)","v":0},null,{"$f":"+IF(years>1,+R69,0)","v":0},null,{"$f":"ROUND(L136*(+N136+P136+R136)*B136,0)","v":0},null,{"$f":"VLOOKUP(J136,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V136*T136,0)","v":0},null,{"$f":"ROUND(X136+T136,0)","v":0},null,{"$f":"+IF(years>1,+AB69+(AB69*$R$12),0)","v":0},null,{"$f":"+AB136*V136","v":0},null,{"$f":"ROUND(AD136+AB136,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B71,0)","v":0},null,{"$f":"+IF(years>1,+D71,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J71,J71)","v":" Select one"},null,{"$f":"+IF(years>1,+L71+(L71*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N71,0)","v":0},null,{"$f":"+IF(years>1,+P71,0)","v":0},null,{"$f":"+IF(years>1,+R71,0)","v":0},null,{"$f":"ROUND(L138*(+N138+P138+R138)*B138,0)","v":0},null,{"$f":"VLOOKUP(J138,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V138*T138,0)","v":0},null,{"$f":"ROUND(X138+T138,0)","v":0},null,{"$f":"+IF(years>1,+AB71+(AB71*$R$12),0)","v":0},null,{"$f":"+AB138*V138","v":0},null,{"$f":"ROUND(AD138+AB138,0)","v":0}]
[]
[null,{"$f":"IF(years>1,+B73,0)","v":0},null,{"$f":"+IF(years>1,+D73,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>1,+J73,J73)","v":" Select one"},null,{"$f":"+IF(years>1,+L73+(L73*$R$12),0)","v":0},null,{"$f":"+IF(years>1,+N73,0)","v":0},null,{"$f":"+IF(years>1,+P73,0)","v":0},null,{"$f":"+IF(years>1,+R73,0)","v":0},null,{"$f":"ROUND(L140*(+N140+P140+R140)*B140,0)","v":0},null,{"$f":"VLOOKUP(J140,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V140*T140,0)","v":0},null,{"$f":"ROUND(X140+T140,0)","v":0},null,{"$f":"+IF(years>1,+AB73+(AB73*$R$12),0)","v":0},null,{"$f":"+AB140*V140","v":0},null,{"$f":"ROUND(AD140+AB140,0)","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,"Total Other Personnel",null,{"$f":"SUM(Z114:Z140)","v":0},null,null,null,"Total Other Personnel",null,{"$f":"SUM(AF114:AF140)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2 Totals","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X114:X140,X83:X105)","v":0},null,{"$f":"SUM(T114:T140,T83:T107)","v":0}]
["Worksheet for Project Budget - Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,"Senior Personnel"]
[null,"Prefix",null,"First Name",null,"Middle Init.",null,"Last Name",null,"Classification",null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[1,{"$f":"+IF(years>2,+B83,0)","v":0},null,{"$f":"+IF(years>2,+D83,0)","v":0},null,{"$f":"+IF(years>2,+F83,0)","v":0},null,{"$f":"+IF(years>2,+H83,0)","v":0},null,{"$f":"+IF(years>2,+J83,J83)","v":" Select one"},null,{"$f":"+IF(years>2,+L83+(L83*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N83,0)","v":0},null,{"$f":"+IF(years>2,+P83,0)","v":0},null,{"$f":"+IF(years>2,+R83,0)","v":0},null,{"$f":"ROUND(L151*(+N151+P151+R151),0)","v":0},null,{"$f":"VLOOKUP(J151,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V151*T151,0)","v":0},null,{"$f":"ROUND(X151+T151,0)","v":0},null,{"$f":"+IF(years>2,+AB83+(AB83*$R$12),0)","v":0},null,{"$f":"ROUND(AB151*V151,0)","v":0},null,{"$f":"ROUND(AD151+AB151,0)","v":0}]
[]
[2,{"$f":"+IF(years>2,+B85,0)","v":0},null,{"$f":"+IF(years>2,+D85,0)","v":0},null,{"$f":"+IF(years>2,+F85,0)","v":0},null,{"$f":"+IF(years>2,+H85,0)","v":0},null,{"$f":"+IF(years>2,+J85,J85)","v":" Select one"},null,{"$f":"+IF(years>2,+L85+(L85*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N85,0)","v":0},null,{"$f":"+IF(years>2,+P85,0)","v":0},null,{"$f":"+IF(years>2,+R85,0)","v":0},null,{"$f":"ROUND(L153*(+N153+P153+R153),0)","v":0},null,{"$f":"VLOOKUP(J153,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V153*T153,0)","v":0},null,{"$f":"ROUND(X153+T153,0)","v":0},null,{"$f":"+IF(years>2,+AB85+(AB85*$R$12),0)","v":0},null,{"$f":"ROUND(AB153*V153,0)","v":0},null,{"$f":"ROUND(AD153+AB153,0)","v":0}]
[]
[3,{"$f":"+IF(years>2,+B87,0)","v":0},null,{"$f":"+IF(years>2,+D87,0)","v":0},null,{"$f":"+IF(years>2,+F87,0)","v":0},null,{"$f":"+IF(years>2,+H87,0)","v":0},null,{"$f":"+IF(years>2,+J87,J87)","v":" Select one"},null,{"$f":"+IF(years>2,+L87+(L87*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N87,0)","v":0},null,{"$f":"+IF(years>2,+P87,0)","v":0},null,{"$f":"+IF(years>2,+R87,0)","v":0},null,{"$f":"ROUND(L155*(+N155+P155+R155),0)","v":0},null,{"$f":"VLOOKUP(J155,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V155*T155,0)","v":0},null,{"$f":"ROUND(X155+T155,0)","v":0},null,{"$f":"+IF(years>2,+AB87+(AB87*$R$12),0)","v":0},null,{"$f":"ROUND(AB155*V155,0)","v":0},null,{"$f":"ROUND(AD155+AB155,0)","v":0}]
[]
[4,{"$f":"+IF(years>2,+B89,0)","v":0},null,{"$f":"+IF(years>2,+D89,0)","v":0},null,{"$f":"+IF(years>2,+F89,0)","v":0},null,{"$f":"+IF(years>2,+H89,0)","v":0},null,{"$f":"+IF(years>2,+J89,J89)","v":" Select one"},null,{"$f":"+IF(years>2,+L89+(L89*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N89,0)","v":0},null,{"$f":"+IF(years>2,+P89,0)","v":0},null,{"$f":"+IF(years>2,+R89,0)","v":0},null,{"$f":"ROUND(L157*(+N157+P157+R157),0)","v":0},null,{"$f":"VLOOKUP(J157,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V157*T157,0)","v":0},null,{"$f":"ROUND(X157+T157,0)","v":0},null,{"$f":"+IF(years>2,+AB89+(AB89*$R$12),0)","v":0},null,{"$f":"ROUND(AB157*V157,0)","v":0},null,{"$f":"ROUND(AD157+AB157,0)","v":0}]
[]
[5,{"$f":"+IF(years>2,+B91,0)","v":0},null,{"$f":"+IF(years>2,+D91,0)","v":0},null,{"$f":"+IF(years>2,+F91,0)","v":0},null,{"$f":"+IF(years>2,+H91,0)","v":0},null,{"$f":"+IF(years>2,+J91,J91)","v":" Select one"},null,{"$f":"+IF(years>2,+L91+(L91*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N91,0)","v":0},null,{"$f":"+IF(years>2,+P91,0)","v":0},null,{"$f":"+IF(years>2,+R91,0)","v":0},null,{"$f":"ROUND(L159*(+N159+P159+R159),0)","v":0},null,{"$f":"VLOOKUP(J159,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V159*T159,0)","v":0},null,{"$f":"ROUND(X159+T159,0)","v":0},null,{"$f":"+IF(years>2,+AB91+(AB91*$R$12),0)","v":0},null,{"$f":"ROUND(AB159*V159,0)","v":0},null,{"$f":"ROUND(AD159+AB159,0)","v":0}]
[]
[6,{"$f":"+IF(years>2,+B93,0)","v":0},null,{"$f":"+IF(years>2,+D93,0)","v":0},null,{"$f":"+IF(years>2,+F93,0)","v":0},null,{"$f":"+IF(years>2,+H93,0)","v":0},null,{"$f":"+IF(years>2,+J93,J93)","v":" Select one"},null,{"$f":"+IF(years>2,+L93+(L93*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N93,0)","v":0},null,{"$f":"+IF(years>2,+P93,0)","v":0},null,{"$f":"+IF(years>2,+R93,0)","v":0},null,{"$f":"ROUND(L161*(+N161+P161+R161),0)","v":0},null,{"$f":"VLOOKUP(J161,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V161*T161,0)","v":0},null,{"$f":"ROUND(X161+T161,0)","v":0},null,{"$f":"+IF(years>2,+AB93+(AB93*$R$12),0)","v":0},null,{"$f":"ROUND(AB161*V161,0)","v":0},null,{"$f":"ROUND(AD161+AB161,0)","v":0}]
[]
[7,{"$f":"+IF(years>2,+B95,0)","v":0},null,{"$f":"+IF(years>2,+D95,0)","v":0},null,{"$f":"+IF(years>2,+F95,0)","v":0},null,{"$f":"+IF(years>2,+H95,0)","v":0},null,{"$f":"+IF(years>2,+J95,J95)","v":" Select one"},null,{"$f":"+IF(years>2,+L95+(L95*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N95,0)","v":0},null,{"$f":"+IF(years>2,+P95,0)","v":0},null,{"$f":"+IF(years>2,+R95,0)","v":0},null,{"$f":"ROUND(L163*(+N163+P163+R163),0)","v":0},null,{"$f":"VLOOKUP(J163,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V163*T163,0)","v":0},null,{"$f":"ROUND(X163+T163,0)","v":0},null,{"$f":"+IF(years>2,+AB95+(AB95*$R$12),0)","v":0},null,{"$f":"ROUND(AB163*V163,0)","v":0},null,{"$f":"ROUND(AD163+AB163,0)","v":0}]
[]
[8,{"$f":"+IF(years>2,+B97,0)","v":0},null,{"$f":"+IF(years>2,+D97,0)","v":0},null,{"$f":"+IF(years>2,+F97,0)","v":0},null,{"$f":"+IF(years>2,+H97,0)","v":0},null,{"$f":"+IF(years>2,+J97,J97)","v":" Select one"},null,{"$f":"+IF(years>2,+L97+(L97*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N97,0)","v":0},null,{"$f":"+IF(years>2,+P97,0)","v":0},null,{"$f":"+IF(years>2,+R97,0)","v":0},null,{"$f":"ROUND(L165*(+N165+P165+R165),0)","v":0},null,{"$f":"VLOOKUP(J165,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V165*T165,0)","v":0},null,{"$f":"ROUND(X165+T165,0)","v":0},null,{"$f":"+IF(years>2,+AB97+(AB97*$R$12),0)","v":0},null,{"$f":"ROUND(AB165*V165,0)","v":0},null,{"$f":"ROUND(AD165+AB165,0)","v":0}]
[]
[9,{"$f":"+IF(years>2,+B99,0)","v":0},null,{"$f":"+IF(years>2,+D99,0)","v":0},null,{"$f":"+IF(years>2,+F99,0)","v":0},null,{"$f":"+IF(years>2,+H99,0)","v":0},null,{"$f":"+IF(years>2,+J99,J99)","v":" Select one"},null,{"$f":"+IF(years>2,+L99+(L99*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N99,0)","v":0},null,{"$f":"+IF(years>2,+P99,0)","v":0},null,{"$f":"+IF(years>2,+R99,0)","v":0},null,{"$f":"ROUND(L167*(+N167+P167+R167),0)","v":0},null,{"$f":"VLOOKUP(J167,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V167*T167,0)","v":0},null,{"$f":"ROUND(X167+T167,0)","v":0},null,{"$f":"+IF(years>2,+AB99+(AB99*$R$12),0)","v":0},null,{"$f":"ROUND(AB167*V167,0)","v":0},null,{"$f":"ROUND(AD167+AB167,0)","v":0}]
[]
[10,{"$f":"+IF(years>2,+B101,0)","v":0},null,{"$f":"+IF(years>2,+D101,0)","v":0},null,{"$f":"+IF(years>2,+F101,0)","v":0},null,{"$f":"+IF(years>2,+H101,0)","v":0},null,{"$f":"+IF(years>2,+J101,J101)","v":" Select one"},null,{"$f":"+IF(years>2,+L101+(L101*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N101,0)","v":0},null,{"$f":"+IF(years>2,+P101,0)","v":0},null,{"$f":"+IF(years>2,+R101,0)","v":0},null,{"$f":"ROUND(L169*(+N169+P169+R169),0)","v":0},null,{"$f":"VLOOKUP(J169,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V169*T169,0)","v":0},null,{"$f":"ROUND(X169+T169,0)","v":0},null,{"$f":"+IF(years>2,+AB101+(AB101*$R$12),0)","v":0},null,{"$f":"ROUND(AB169*V169,0)","v":0},null,{"$f":"ROUND(AD169+AB169,0)","v":0}]
[]
[11,{"$f":"+IF(years>2,+B103,0)","v":0},null,{"$f":"+IF(years>2,+D103,0)","v":0},null,{"$f":"+IF(years>2,+F103,0)","v":0},null,{"$f":"+IF(years>2,+H103,0)","v":0},null,{"$f":"+IF(years>2,+J103,J103)","v":" Select one"},null,{"$f":"+IF(years>2,+L103+(L103*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N103,0)","v":0},null,{"$f":"+IF(years>2,+P103,0)","v":0},null,{"$f":"+IF(years>2,+R103,0)","v":0},null,{"$f":"ROUND(L171*(+N171+P171+R171),0)","v":0},null,{"$f":"VLOOKUP(J171,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V171*T171,0)","v":0},null,{"$f":"ROUND(X171+T171,0)","v":0},null,{"$f":"+IF(years>2,+AB103+(AB103*$R$12),0)","v":0},null,{"$f":"ROUND(AB171*V171,0)","v":0},null,{"$f":"ROUND(AD171+AB171,0)","v":0}]
[]
[12,{"$f":"+IF(years>2,+B105,0)","v":0},null,{"$f":"+IF(years>2,+D105,0)","v":0},null,{"$f":"+IF(years>2,+F105,0)","v":0},null,{"$f":"+IF(years>2,+H105,0)","v":0},null,{"$f":"+IF(years>2,+J105,J105)","v":" Select one"},null,{"$f":"+IF(years>2,+L105+(L105*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N105,0)","v":0},null,{"$f":"+IF(years>2,+P105,0)","v":0},null,{"$f":"+IF(years>2,+R105,0)","v":0},null,{"$f":"ROUND(L173*(+N173+P173+R173),0)","v":0},null,{"$f":"VLOOKUP(J173,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V173*T173,0)","v":0},null,{"$f":"ROUND(X173+T173,0)","v":0},null,{"$f":"+IF(years>2,+AB105+(AB105*$R$12),0)","v":0},null,{"$f":"ROUND(AB173*V173,0)","v":0},null,{"$f":"ROUND(AD173+AB173,0)","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,"Total Senior Personnel",null,{"$f":"SUM(Z151:Z173)","v":0},null,null,null,"Total Senior Personnel",null,{"$f":"SUM(AF151:AF173)","v":0}]
[]
[]
[null,"Other Personnel"]
[null,"Number of Personnel",null,null,null,null,null,null,null,null,null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[null,{"$f":"IF(years>2,+B114,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L114+(L114*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N114,0)","v":0},null,{"$f":"+IF(years>2,+P114,0)","v":0},null,{"$f":"+IF(years>2,+R114,0)","v":0},null,{"$f":"ROUND(L182*(+N182+P182+R182)*B182,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V182*T182,0)","v":0},null,{"$f":"ROUND(X182+T182,0)","v":0},null,{"$f":"+IF(years>2,+AB114+(AB114*$R$12),0)","v":0},null,{"$f":"ROUND(AB182*V182,0)","v":0},null,{"$f":"ROUND(AD182+AB182,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B116,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L116+(L116*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N116,0)","v":0},null,{"$f":"+IF(years>2,+P116,0)","v":0},null,{"$f":"+IF(years>2,+R116,0)","v":0},null,{"$f":"ROUND(L184*(+N184+P184+R184)*B184,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V184*T184,0)","v":0},null,{"$f":"ROUND(X184+T184,0)","v":0},null,{"$f":"+IF(years>2,+AB116+(AB116*$R$12),0)","v":0},null,{"$f":"ROUND(AB184*V184,0)","v":0},null,{"$f":"ROUND(AD184+AB184,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B118,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L118+(L118*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N118,0)","v":0},null,{"$f":"+IF(years>2,+P118,0)","v":0},null,{"$f":"+IF(years>2,+R118,0)","v":0},null,{"$f":"ROUND(L186*(+N186+P186+R186)*B186,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V186*T186,0)","v":0},null,{"$f":"ROUND(X186+T186,0)","v":0},null,{"$f":"+IF(years>2,+AB118+(AB118*$R$12),0)","v":0},null,{"$f":"ROUND(AB186*V186,0)","v":0},null,{"$f":"ROUND(AD186+AB186,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B120,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L120+(L120*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N120,0)","v":0},null,{"$f":"+IF(years>2,+P120,0)","v":0},null,{"$f":"+IF(years>2,+R120,0)","v":0},null,{"$f":"ROUND(L188*(+N188+P188+R188)*B188,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V188*T188,0)","v":0},null,{"$f":"ROUND(X188+T188,0)","v":0},null,{"$f":"+IF(years>2,+AB120+(AB120*$R$12),0)","v":0},null,{"$f":"ROUND(AB188*V188,0)","v":0},null,{"$f":"ROUND(AD188+AB188,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B122,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L122+(L122*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N122,0)","v":0},null,{"$f":"+IF(years>2,+P122,0)","v":0},null,{"$f":"+IF(years>2,+R122,0)","v":0},null,{"$f":"ROUND(L190*(+N190+P190+R190)*B190,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V190*T190,0)","v":0},null,{"$f":"ROUND(X190+T190,0)","v":0},null,{"$f":"+IF(years>2,+AB122+(AB122*$R$12),0)","v":0},null,{"$f":"ROUND(AB190*V190,0)","v":0},null,{"$f":"ROUND(AD190+AB190,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B124,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L124+(L124*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N124,0)","v":0},null,{"$f":"+IF(years>2,+P124,0)","v":0},null,{"$f":"+IF(years>2,+R124,0)","v":0},null,{"$f":"ROUND(L192*(+N192+P192+R192)*B192,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V192*T192,0)","v":0},null,{"$f":"ROUND(X192+T192,0)","v":0},null,{"$f":"+IF(years>2,+AB124+(AB124*$R$12),0)","v":0},null,{"$f":"ROUND(AB192*V192,0)","v":0},null,{"$f":"ROUND(AD192+AB192,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B126,0)","v":0},null,"Secretarial/Clerical",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L126+(L126*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N126,0)","v":0},null,{"$f":"+IF(years>2,+P126,0)","v":0},null,{"$f":"+IF(years>2,+R126,0)","v":0},null,{"$f":"ROUND(L194*(+N194+P194+R194)*B194,0)","v":0},null,{"$f":"$H$375","v":0.51},null,{"$f":"ROUND(V194*T194,0)","v":0},null,{"$f":"ROUND(X194+T194,0)","v":0},null,{"$f":"+IF(years>2,+AB126+(AB126*$R$12),0)","v":0},null,{"$f":"ROUND(AB194*V194,0)","v":0},null,{"$f":"ROUND(AD194+AB194,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B128,0)","v":0},null,"Non-Student Hourly",null,null,null,null,null,null,null,{"$f":"+IF(years>2,+L128+(L128*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N128,0)","v":0},null,{"$f":"+IF(years>2,+P128,0)","v":0},null,{"$f":"+IF(years>2,+R128,0)","v":0},null,{"$f":"ROUND(L196*(+N196+P196+R196)*B196,0)","v":0},null,{"$f":"$H$371","v":0.12},null,{"$f":"ROUND(V196*T196,0)","v":0},null,{"$f":"ROUND(X196+T196,0)","v":0},null,{"$f":"+IF(years>2,+AB128+(AB128*$R$12),0)","v":0},null,{"$f":"ROUND(AB196*V196,0)","v":0},null,{"$f":"ROUND(AD196+AB196,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B130,0)","v":0},null,{"$f":"+IF(years>2,+D130,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J130,J130)","v":" Select one"},null,{"$f":"+IF(years>2,+L130+(L130*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N130,0)","v":0},null,{"$f":"+IF(years>2,+P130,0)","v":0},null,{"$f":"+IF(years>2,+R130,0)","v":0},null,{"$f":"ROUND(L198*(+N198+P198+R198)*B198,0)","v":0},null,{"$f":"VLOOKUP(J198,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V198*T198,0)","v":0},null,{"$f":"ROUND(X198+T198,0)","v":0},null,{"$f":"+IF(years>2,+AB130+(AB130*$R$12),0)","v":0},null,{"$f":"ROUND(AB198*V198,0)","v":0},null,{"$f":"ROUND(AD198+AB198,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B132,0)","v":0},null,{"$f":"+IF(years>2,+D132,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J132,J132)","v":" Select one"},null,{"$f":"+IF(years>2,+L132+(L132*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N132,0)","v":0},null,{"$f":"+IF(years>2,+P132,0)","v":0},null,{"$f":"+IF(years>2,+R132,0)","v":0},null,{"$f":"ROUND(L200*(+N200+P200+R200)*B200,0)","v":0},null,{"$f":"VLOOKUP(J200,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V200*T200,0)","v":0},null,{"$f":"ROUND(X200+T200,0)","v":0},null,{"$f":"+IF(years>2,+AB132+(AB132*$R$12),0)","v":0},null,{"$f":"ROUND(AB200*V200,0)","v":0},null,{"$f":"ROUND(AD200+AB200,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B134,0)","v":0},null,{"$f":"+IF(years>2,+D134,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J134,J134)","v":" Select one"},null,{"$f":"+IF(years>2,+L134+(L134*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N134,0)","v":0},null,{"$f":"+IF(years>2,+P134,0)","v":0},null,{"$f":"+IF(years>2,+R134,0)","v":0},null,{"$f":"ROUND(L202*(+N202+P202+R202)*B202,0)","v":0},null,{"$f":"VLOOKUP(J202,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V202*T202,0)","v":0},null,{"$f":"ROUND(X202+T202,0)","v":0},null,{"$f":"+IF(years>2,+AB134+(AB134*$R$12),0)","v":0},null,{"$f":"ROUND(AB202*V202,0)","v":0},null,{"$f":"ROUND(AD202+AB202,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B136,0)","v":0},null,{"$f":"+IF(years>2,+D136,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J136,J136)","v":" Select one"},null,{"$f":"+IF(years>2,+L136+(L136*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N136,0)","v":0},null,{"$f":"+IF(years>2,+P136,0)","v":0},null,{"$f":"+IF(years>2,+R136,0)","v":0},null,{"$f":"ROUND(L204*(+N204+P204+R204)*B204,0)","v":0},null,{"$f":"VLOOKUP(J204,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V204*T204,0)","v":0},null,{"$f":"ROUND(X204+T204,0)","v":0},null,{"$f":"+IF(years>2,+AB136+(AB136*$R$12),0)","v":0},null,{"$f":"ROUND(AB204*V204,0)","v":0},null,{"$f":"ROUND(AD204+AB204,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B138,0)","v":0},null,{"$f":"+IF(years>2,+D138,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J138,J138)","v":" Select one"},null,{"$f":"+IF(years>2,+L138+(L138*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N138,0)","v":0},null,{"$f":"+IF(years>2,+P138,0)","v":0},null,{"$f":"+IF(years>2,+R138,0)","v":0},null,{"$f":"ROUND(L206*(+N206+P206+R206)*B206,0)","v":0},null,{"$f":"VLOOKUP(J206,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V206*T206,0)","v":0},null,{"$f":"ROUND(X206+T206,0)","v":0},null,{"$f":"+IF(years>2,+AB138+(AB138*$R$12),0)","v":0},null,{"$f":"ROUND(AB206*V206,0)","v":0},null,{"$f":"ROUND(AD206+AB206,0)","v":0}]
[]
[null,{"$f":"IF(years>2,+B140,0)","v":0},null,{"$f":"+IF(years>2,+D140,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>2,+J140,J140)","v":" Select one"},null,{"$f":"+IF(years>2,+L140+(L140*$R$12),0)","v":0},null,{"$f":"+IF(years>2,+N140,0)","v":0},null,{"$f":"+IF(years>2,+P140,0)","v":0},null,{"$f":"+IF(years>2,+R140,0)","v":0},null,{"$f":"ROUND(L208*(+N208+P208+R208)*B208,0)","v":0},null,{"$f":"VLOOKUP(J208,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V208*T208,0)","v":0},null,{"$f":"ROUND(X208+T208,0)","v":0},null,{"$f":"+IF(years>2,+AB140+(AB140*$R$12),0)","v":0},null,{"$f":"ROUND(AB208*V208,0)","v":0},null,{"$f":"ROUND(AD208+AB208,0)","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,"Total Other Personnel",null,{"$f":"SUM(Z182:Z208)","v":0},null,null,null,"Total Other Personnel",null,{"$f":"SUM(AF182:AF208)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3 Totals","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X182:X208,X151:X173)","v":0},null,{"$f":"SUM(T182:T208,T151:T175)","v":0}]
["Worksheet for Project Budget - Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 4"]
[null,"Senior Personnel"]
[null,"Prefix",null,"First Name",null,"Middle Init.",null,"Last Name",null,"Classification",null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[1,{"$f":"+IF(years>3,+B151,0)","v":0},null,{"$f":"+IF(years>3,+D151,0)","v":0},null,{"$f":"+IF(years>3,+F151,0)","v":0},null,{"$f":"+IF(years>3,+H151,0)","v":0},null,{"$f":"+IF(years>3,+J151,J151)","v":" Select one"},null,{"$f":"+IF(years>3,+L151+(L151*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N151,0)","v":0},null,{"$f":"+IF(years>3,+P151,0)","v":0},null,{"$f":"+IF(years>3,+R151,0)","v":0},null,{"$f":"ROUND(L219*(+N219+P219+R219),0)","v":0},null,{"$f":"VLOOKUP(J219,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V219*T219,0)","v":0},null,{"$f":"ROUND(X219+T219,0)","v":0},null,{"$f":"+IF(years>3,+AB151+(AB151*$R$12),0)","v":0},null,{"$f":"ROUND(AB219*V219,0)","v":0},null,{"$f":"ROUND(AD219+AB219,0)","v":0}]
[]
[2,{"$f":"+IF(years>3,+B153,0)","v":0},null,{"$f":"+IF(years>3,+D153,0)","v":0},null,{"$f":"+IF(years>3,+F153,0)","v":0},null,{"$f":"+IF(years>3,+H153,0)","v":0},null,{"$f":"+IF(years>3,+J153,J153)","v":" Select one"},null,{"$f":"+IF(years>3,+L153+(L153*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N153,0)","v":0},null,{"$f":"+IF(years>3,+P153,0)","v":0},null,{"$f":"+IF(years>3,+R153,0)","v":0},null,{"$f":"ROUND(L221*(+N221+P221+R221),0)","v":0},null,{"$f":"VLOOKUP(J221,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V221*T221,0)","v":0},null,{"$f":"ROUND(X221+T221,0)","v":0},null,{"$f":"+IF(years>3,+AB153+(AB153*$R$12),0)","v":0},null,{"$f":"ROUND(AB221*V221,0)","v":0},null,{"$f":"ROUND(AD221+AB221,0)","v":0}]
[]
[3,{"$f":"+IF(years>3,+B155,0)","v":0},null,{"$f":"+IF(years>3,+D155,0)","v":0},null,{"$f":"+IF(years>3,+F155,0)","v":0},null,{"$f":"+IF(years>3,+H155,0)","v":0},null,{"$f":"+IF(years>3,+J155,J155)","v":" Select one"},null,{"$f":"+IF(years>3,+L155+(L155*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N155,0)","v":0},null,{"$f":"+IF(years>3,+P155,0)","v":0},null,{"$f":"+IF(years>3,+R155,0)","v":0},null,{"$f":"ROUND(L223*(+N223+P223+R223),0)","v":0},null,{"$f":"VLOOKUP(J223,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V223*T223,0)","v":0},null,{"$f":"ROUND(X223+T223,0)","v":0},null,{"$f":"+IF(years>3,+AB155+(AB155*$R$12),0)","v":0},null,{"$f":"ROUND(AB223*V223,0)","v":0},null,{"$f":"ROUND(AD223+AB223,0)","v":0}]
[]
[4,{"$f":"+IF(years>3,+B157,0)","v":0},null,{"$f":"+IF(years>3,+D157,0)","v":0},null,{"$f":"+IF(years>3,+F157,0)","v":0},null,{"$f":"+IF(years>3,+H157,0)","v":0},null,{"$f":"+IF(years>3,+J157,J157)","v":" Select one"},null,{"$f":"+IF(years>3,+L157+(L157*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N157,0)","v":0},null,{"$f":"+IF(years>3,+P157,0)","v":0},null,{"$f":"+IF(years>3,+R157,0)","v":0},null,{"$f":"ROUND(L225*(+N225+P225+R225),0)","v":0},null,{"$f":"VLOOKUP(J225,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V225*T225,0)","v":0},null,{"$f":"ROUND(X225+T225,0)","v":0},null,{"$f":"+IF(years>3,+AB157+(AB157*$R$12),0)","v":0},null,{"$f":"ROUND(AB225*V225,0)","v":0},null,{"$f":"ROUND(AD225+AB225,0)","v":0}]
[]
[5,{"$f":"+IF(years>3,+B159,0)","v":0},null,{"$f":"+IF(years>3,+D159,0)","v":0},null,{"$f":"+IF(years>3,+F159,0)","v":0},null,{"$f":"+IF(years>3,+H159,0)","v":0},null,{"$f":"+IF(years>3,+J159,J159)","v":" Select one"},null,{"$f":"+IF(years>3,+L159+(L159*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N159,0)","v":0},null,{"$f":"+IF(years>3,+P159,0)","v":0},null,{"$f":"+IF(years>3,+R159,0)","v":0},null,{"$f":"ROUND(L227*(+N227+P227+R227),0)","v":0},null,{"$f":"VLOOKUP(J227,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V227*T227,0)","v":0},null,{"$f":"ROUND(X227+T227,0)","v":0},null,{"$f":"+IF(years>3,+AB159+(AB159*$R$12),0)","v":0},null,{"$f":"ROUND(AB227*V227,0)","v":0},null,{"$f":"ROUND(AD227+AB227,0)","v":0}]
[]
[6,{"$f":"+IF(years>3,+B161,0)","v":0},null,{"$f":"+IF(years>3,+D161,0)","v":0},null,{"$f":"+IF(years>3,+F161,0)","v":0},null,{"$f":"+IF(years>3,+H161,0)","v":0},null,{"$f":"+IF(years>3,+J161,J161)","v":" Select one"},null,{"$f":"+IF(years>3,+L161+(L161*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N161,0)","v":0},null,{"$f":"+IF(years>3,+P161,0)","v":0},null,{"$f":"+IF(years>3,+R161,0)","v":0},null,{"$f":"ROUND(L229*(+N229+P229+R229),0)","v":0},null,{"$f":"VLOOKUP(J229,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V229*T229,0)","v":0},null,{"$f":"ROUND(X229+T229,0)","v":0},null,{"$f":"+IF(years>3,+AB161+(AB161*$R$12),0)","v":0},null,{"$f":"ROUND(AB229*V229,0)","v":0},null,{"$f":"ROUND(AD229+AB229,0)","v":0}]
[]
[7,{"$f":"+IF(years>3,+B163,0)","v":0},null,{"$f":"+IF(years>3,+D163,0)","v":0},null,{"$f":"+IF(years>3,+F163,0)","v":0},null,{"$f":"+IF(years>3,+H163,0)","v":0},null,{"$f":"+IF(years>3,+J163,J163)","v":" Select one"},null,{"$f":"+IF(years>3,+L163+(L163*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N163,0)","v":0},null,{"$f":"+IF(years>3,+P163,0)","v":0},null,{"$f":"+IF(years>3,+R163,0)","v":0},null,{"$f":"ROUND(L231*(+N231+P231+R231),0)","v":0},null,{"$f":"VLOOKUP(J231,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V231*T231,0)","v":0},null,{"$f":"ROUND(X231+T231,0)","v":0},null,{"$f":"+IF(years>3,+AB163+(AB163*$R$12),0)","v":0},null,{"$f":"ROUND(AB231*V231,0)","v":0},null,{"$f":"ROUND(AD231+AB231,0)","v":0}]
[]
[8,{"$f":"+IF(years>3,+B165,0)","v":0},null,{"$f":"+IF(years>3,+D165,0)","v":0},null,{"$f":"+IF(years>3,+F165,0)","v":0},null,{"$f":"+IF(years>3,+H165,0)","v":0},null,{"$f":"+IF(years>3,+J165,J165)","v":" Select one"},null,{"$f":"+IF(years>3,+L165+(L165*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N165,0)","v":0},null,{"$f":"+IF(years>3,+P165,0)","v":0},null,{"$f":"+IF(years>3,+R165,0)","v":0},null,{"$f":"ROUND(L233*(+N233+P233+R233),0)","v":0},null,{"$f":"VLOOKUP(J233,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V233*T233,0)","v":0},null,{"$f":"ROUND(X233+T233,0)","v":0},null,{"$f":"+IF(years>3,+AB165+(AB165*$R$12),0)","v":0},null,{"$f":"ROUND(AB233*V233,0)","v":0},null,{"$f":"ROUND(AD233+AB233,0)","v":0}]
[]
[9,{"$f":"+IF(years>3,+B167,0)","v":0},null,{"$f":"+IF(years>3,+D167,0)","v":0},null,{"$f":"+IF(years>3,+F167,0)","v":0},null,{"$f":"+IF(years>3,+H167,0)","v":0},null,{"$f":"+IF(years>3,+J167,J167)","v":" Select one"},null,{"$f":"+IF(years>3,+L167+(L167*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N167,0)","v":0},null,{"$f":"+IF(years>3,+P167,0)","v":0},null,{"$f":"+IF(years>3,+R167,0)","v":0},null,{"$f":"ROUND(L235*(+N235+P235+R235),0)","v":0},null,{"$f":"VLOOKUP(J235,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V235*T235,0)","v":0},null,{"$f":"ROUND(X235+T235,0)","v":0},null,{"$f":"+IF(years>3,+AB167+(AB167*$R$12),0)","v":0},null,{"$f":"ROUND(AB235*V235,0)","v":0},null,{"$f":"ROUND(AD235+AB235,0)","v":0}]
[]
[10,{"$f":"+IF(years>3,+B169,0)","v":0},null,{"$f":"+IF(years>3,+D169,0)","v":0},null,{"$f":"+IF(years>3,+F169,0)","v":0},null,{"$f":"+IF(years>3,+H169,0)","v":0},null,{"$f":"+IF(years>3,+J169,J169)","v":" Select one"},null,{"$f":"+IF(years>3,+L169+(L169*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N169,0)","v":0},null,{"$f":"+IF(years>3,+P169,0)","v":0},null,{"$f":"+IF(years>3,+R169,0)","v":0},null,{"$f":"ROUND(L237*(+N237+P237+R237),0)","v":0},null,{"$f":"VLOOKUP(J237,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V237*T237,0)","v":0},null,{"$f":"ROUND(X237+T237,0)","v":0},null,{"$f":"+IF(years>3,+AB169+(AB169*$R$12),0)","v":0},null,{"$f":"ROUND(AB237*V237,0)","v":0},null,{"$f":"ROUND(AD237+AB237,0)","v":0}]
[]
[11,{"$f":"+IF(years>3,+B171,0)","v":0},null,{"$f":"+IF(years>3,+D171,0)","v":0},null,{"$f":"+IF(years>3,+F171,0)","v":0},null,{"$f":"+IF(years>3,+H171,0)","v":0},null,{"$f":"+IF(years>3,+J171,J171)","v":" Select one"},null,{"$f":"+IF(years>3,+L171+(L171*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N171,0)","v":0},null,{"$f":"+IF(years>3,+P171,0)","v":0},null,{"$f":"+IF(years>3,+R171,0)","v":0},null,{"$f":"ROUND(L239*(+N239+P239+R239),0)","v":0},null,{"$f":"VLOOKUP(J239,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V239*T239,0)","v":0},null,{"$f":"ROUND(X239+T239,0)","v":0},null,{"$f":"+IF(years>3,+AB171+(AB171*$R$12),0)","v":0},null,{"$f":"ROUND(AB239*V239,0)","v":0},null,{"$f":"ROUND(AD239+AB239,0)","v":0}]
[]
[12,{"$f":"+IF(years>3,+B173,0)","v":0},null,{"$f":"+IF(years>3,+D173,0)","v":0},null,{"$f":"+IF(years>3,+F173,0)","v":0},null,{"$f":"+IF(years>3,+H173,0)","v":0},null,{"$f":"+IF(years>3,+J173,J173)","v":" Select one"},null,{"$f":"+IF(years>3,+L173+(L173*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N173,0)","v":0},null,{"$f":"+IF(years>3,+P173,0)","v":0},null,{"$f":"+IF(years>3,+R173,0)","v":0},null,{"$f":"ROUND(L241*(+N241+P241+R241),0)","v":0},null,{"$f":"VLOOKUP(J241,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V241*T241,0)","v":0},null,{"$f":"ROUND(X241+T241,0)","v":0},null,{"$f":"+IF(years>3,+AB173+(AB173*$R$12),0)","v":0},null,{"$f":"ROUND(AB241*V241,0)","v":0},null,{"$f":"ROUND(AD241+AB241,0)","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,"Total Senior Personnel",null,{"$f":"SUM(Z219:Z241)","v":0},null,null,null,"Total Senior Personnel",null,{"$f":"SUM(AF219:AF241)","v":0}]
[]
[]
[null,"Other Personnel"]
[null,"Number of Personnel",null,null,null,null,null,null,null,null,null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[null,{"$f":"IF(years>3,+B182,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L182+(L182*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N182,0)","v":0},null,{"$f":"+IF(years>3,+P182,0)","v":0},null,{"$f":"+IF(years>3,+R182,0)","v":0},null,{"$f":"ROUND(L250*(+N250+P250+R250)*B250,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V250*T250,0)","v":0},null,{"$f":"ROUND(X250+T250,0)","v":0},null,{"$f":"+IF(years>3,+AB182+(AB182*$R$12),0)","v":0},null,{"$f":"ROUND(AB250*V250,0)","v":0},null,{"$f":"ROUND(AD250+AB250,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B184,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L184+(L184*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N184,0)","v":0},null,{"$f":"+IF(years>3,+P184,0)","v":0},null,{"$f":"+IF(years>3,+R184,0)","v":0},null,{"$f":"ROUND(L252*(+N252+P252+R252)*B252,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V252*T252,0)","v":0},null,{"$f":"ROUND(X252+T252,0)","v":0},null,{"$f":"+IF(years>3,+AB184+(AB184*$R$12),0)","v":0},null,{"$f":"ROUND(AB252*V252,0)","v":0},null,{"$f":"ROUND(AD252+AB252,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B186,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L186+(L186*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N186,0)","v":0},null,{"$f":"+IF(years>3,+P186,0)","v":0},null,{"$f":"+IF(years>3,+R186,0)","v":0},null,{"$f":"ROUND(L254*(+N254+P254+R254)*B254,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V254*T254,0)","v":0},null,{"$f":"ROUND(X254+T254,0)","v":0},null,{"$f":"+IF(years>3,+AB186+(AB186*$R$12),0)","v":0},null,{"$f":"ROUND(AB254*V254,0)","v":0},null,{"$f":"ROUND(AD254+AB254,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B188,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L188+(L188*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N188,0)","v":0},null,{"$f":"+IF(years>3,+P188,0)","v":0},null,{"$f":"+IF(years>3,+R188,0)","v":0},null,{"$f":"ROUND(L256*(+N256+P256+R256)*B256,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V256*T256,0)","v":0},null,{"$f":"ROUND(X256+T256,0)","v":0},null,{"$f":"+IF(years>3,+AB188+(AB188*$R$12),0)","v":0},null,{"$f":"ROUND(AB256*V256,0)","v":0},null,{"$f":"ROUND(AD256+AB256,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B190,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L190+(L190*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N190,0)","v":0},null,{"$f":"+IF(years>3,+P190,0)","v":0},null,{"$f":"+IF(years>3,+R190,0)","v":0},null,{"$f":"ROUND(L258*(+N258+P258+R258)*B258,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V258*T258,0)","v":0},null,{"$f":"ROUND(X258+T258,0)","v":0},null,{"$f":"+IF(years>3,+AB190+(AB190*$R$12),0)","v":0},null,{"$f":"ROUND(AB258*V258,0)","v":0},null,{"$f":"ROUND(AD258+AB258,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B192,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L192+(L192*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N192,0)","v":0},null,{"$f":"+IF(years>3,+P192,0)","v":0},null,{"$f":"+IF(years>3,+R192,0)","v":0},null,{"$f":"ROUND(L260*(+N260+P260+R260)*B260,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V260*T260,0)","v":0},null,{"$f":"ROUND(X260+T260,0)","v":0},null,{"$f":"+IF(years>3,+AB192+(AB192*$R$12),0)","v":0},null,{"$f":"ROUND(AB260*V260,0)","v":0},null,{"$f":"ROUND(AD260+AB260,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B194,0)","v":0},null,"Secretarial/Clerical",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L194+(L194*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N194,0)","v":0},null,{"$f":"+IF(years>3,+P194,0)","v":0},null,{"$f":"+IF(years>3,+R194,0)","v":0},null,{"$f":"ROUND(L262*(+N262+P262+R262)*B262,0)","v":0},null,{"$f":"$H$375","v":0.51},null,{"$f":"ROUND(V262*T262,0)","v":0},null,{"$f":"ROUND(X262+T262,0)","v":0},null,{"$f":"+IF(years>3,+AB194+(AB194*$R$12),0)","v":0},null,{"$f":"ROUND(AB262*V262,0)","v":0},null,{"$f":"ROUND(AD262+AB262,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B196,0)","v":0},null,"Non-Student Hourly",null,null,null,null,null,null,null,{"$f":"+IF(years>3,+L196+(L196*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N196,0)","v":0},null,{"$f":"+IF(years>3,+P196,0)","v":0},null,{"$f":"+IF(years>3,+R196,0)","v":0},null,{"$f":"ROUND(L264*(+N264+P264+R264)*B264,0)","v":0},null,{"$f":"$H$371","v":0.12},null,{"$f":"ROUND(V264*T264,0)","v":0},null,{"$f":"ROUND(X264+T264,0)","v":0},null,{"$f":"+IF(years>3,+AB196+(AB196*$R$12),0)","v":0},null,{"$f":"ROUND(AB264*V264,0)","v":0},null,{"$f":"ROUND(AD264+AB264,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B198,0)","v":0},null,{"$f":"+IF(years>3,+D198,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J198,J198)","v":" Select one"},null,{"$f":"+IF(years>3,+L198+(L198*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N198,0)","v":0},null,{"$f":"+IF(years>3,+P198,0)","v":0},null,{"$f":"+IF(years>3,+R198,0)","v":0},null,{"$f":"ROUND(L266*(+N266+P266+R266)*B266,0)","v":0},null,{"$f":"VLOOKUP(J266,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V266*T266,0)","v":0},null,{"$f":"ROUND(X266+T266,0)","v":0},null,{"$f":"+IF(years>3,+AB198+(AB198*$R$12),0)","v":0},null,{"$f":"ROUND(AB266*V266,0)","v":0},null,{"$f":"ROUND(AD266+AB266,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B200,0)","v":0},null,{"$f":"+IF(years>3,+D200,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J200,J200)","v":" Select one"},null,{"$f":"+IF(years>3,+L200+(L200*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N200,0)","v":0},null,{"$f":"+IF(years>3,+P200,0)","v":0},null,{"$f":"+IF(years>3,+R200,0)","v":0},null,{"$f":"ROUND(L268*(+N268+P268+R268)*B268,0)","v":0},null,{"$f":"VLOOKUP(J268,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V268*T268,0)","v":0},null,{"$f":"ROUND(X268+T268,0)","v":0},null,{"$f":"+IF(years>3,+AB200+(AB200*$R$12),0)","v":0},null,{"$f":"ROUND(AB268*V268,0)","v":0},null,{"$f":"ROUND(AD268+AB268,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B202,0)","v":0},null,{"$f":"+IF(years>3,+D202,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J202,J202)","v":" Select one"},null,{"$f":"+IF(years>3,+L202+(L202*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N202,0)","v":0},null,{"$f":"+IF(years>3,+P202,0)","v":0},null,{"$f":"+IF(years>3,+R202,0)","v":0},null,{"$f":"ROUND(L270*(+N270+P270+R270)*B270,0)","v":0},null,{"$f":"VLOOKUP(J270,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V270*T270,0)","v":0},null,{"$f":"ROUND(X270+T270,0)","v":0},null,{"$f":"+IF(years>3,+AB202+(AB202*$R$12),0)","v":0},null,{"$f":"ROUND(AB270*V270,0)","v":0},null,{"$f":"ROUND(AD270+AB270,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B204,0)","v":0},null,{"$f":"+IF(years>3,+D204,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J204,J204)","v":" Select one"},null,{"$f":"+IF(years>3,+L204+(L204*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N204,0)","v":0},null,{"$f":"+IF(years>3,+P204,0)","v":0},null,{"$f":"+IF(years>3,+R204,0)","v":0},null,{"$f":"ROUND(L272*(+N272+P272+R272)*B272,0)","v":0},null,{"$f":"VLOOKUP(J272,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V272*T272,0)","v":0},null,{"$f":"ROUND(X272+T272,0)","v":0},null,{"$f":"+IF(years>3,+AB204+(AB204*$R$12),0)","v":0},null,{"$f":"ROUND(AB272*V272,0)","v":0},null,{"$f":"ROUND(AD272+AB272,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B206,0)","v":0},null,{"$f":"+IF(years>3,+D206,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J206,J206)","v":" Select one"},null,{"$f":"+IF(years>3,+L206+(L206*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N206,0)","v":0},null,{"$f":"+IF(years>3,+P206,0)","v":0},null,{"$f":"+IF(years>3,+R206,0)","v":0},null,{"$f":"ROUND(L274*(+N274+P274+R274)*B274,0)","v":0},null,{"$f":"VLOOKUP(J274,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V274*T274,0)","v":0},null,{"$f":"ROUND(X274+T274,0)","v":0},null,{"$f":"+IF(years>3,+AB206+(AB206*$R$12),0)","v":0},null,{"$f":"ROUND(AB274*V274,0)","v":0},null,{"$f":"ROUND(AD274+AB274,0)","v":0}]
[]
[null,{"$f":"IF(years>3,+B208,0)","v":0},null,{"$f":"+IF(years>3,+D208,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>3,+J208,J208)","v":" Select one"},null,{"$f":"+IF(years>3,+L208+(L208*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N208,0)","v":0},null,{"$f":"+IF(years>3,+P208,0)","v":0},null,{"$f":"+IF(years>3,+R208,0)","v":0},null,{"$f":"ROUND(L276*(+N276+P276+R276)*B276,0)","v":0},null,{"$f":"VLOOKUP(J276,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V276*T276,0)","v":0},null,{"$f":"ROUND(X276+T276,0)","v":0},null,{"$f":"+IF(years>3,+AB208+(AB208*$R$12),0)","v":0},null,{"$f":"ROUND(AB276*V276,0)","v":0},null,{"$f":"ROUND(AD276+AB276,0)","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,"Total Other Personnel",null,{"$f":"SUM(Z250:Z276)","v":0},null,null,null,"Total Other Personnel",null,{"$f":"SUM(AF250:AF278)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 4 Totals","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X250:X276,X219:X241)","v":0},null,{"$f":"SUM(T250:T276,T219:T243)","v":0}]
["Worksheet for Project Budget - Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 5"]
[null,"Senior Personnel"]
[null,"Prefix",null,"First Name",null,"Middle Init.",null,"Last Name",null,"Classification",null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[1,{"$f":"+IF(years>4,+B219,0)","v":0},null,{"$f":"+IF(years>4,+D219,0)","v":0},null,{"$f":"+IF(years>4,+F219,0)","v":0},null,{"$f":"+IF(years>4,+H219,0)","v":0},null,{"$f":"+IF(years>4,+J219,J219)","v":" Select one"},null,{"$f":"+IF(years>4,+L219+(L219*$R$12),0)","v":0},null,{"$f":"+IF(years>3,+N219,0)","v":0},null,{"$f":"+IF(years>4,+P219,0)","v":0},null,{"$f":"+IF(years>4,+R219,0)","v":0},null,{"$f":"ROUND(L287*(+N287+P287+R287),0)","v":0},null,{"$f":"VLOOKUP(J287,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V287*T287,0)","v":0},null,{"$f":"ROUND(X287+T287,0)","v":0},null,{"$f":"+IF(years>4,+AB219+(AB219*$R$12),0)","v":0},null,{"$f":"ROUND(AB287*V287,0)","v":0},null,{"$f":"ROUND(AD287+AB287,0)","v":0}]
[]
[2,{"$f":"+IF(years>4,+B221,0)","v":0},null,{"$f":"+IF(years>4,+D221,0)","v":0},null,{"$f":"+IF(years>4,+F221,0)","v":0},null,{"$f":"+IF(years>4,+H221,0)","v":0},null,{"$f":"+IF(years>4,+J221,J221)","v":" Select one"},null,{"$f":"+IF(years>4,+L221+(L221*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N221,0)","v":0},null,{"$f":"+IF(years>4,+P221,0)","v":0},null,{"$f":"+IF(years>4,+R221,0)","v":0},null,{"$f":"ROUND(L289*(+N289+P289+R289),0)","v":0},null,{"$f":"VLOOKUP(J289,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V289*T289,0)","v":0},null,{"$f":"ROUND(X289+T289,0)","v":0},null,{"$f":"+IF(years>4,+AB221+(AB221*$R$12),0)","v":0},null,{"$f":"ROUND(AB289*V289,0)","v":0},null,{"$f":"ROUND(AD289+AB289,0)","v":0}]
[]
[3,{"$f":"+IF(years>4,+B223,0)","v":0},null,{"$f":"+IF(years>4,+D223,0)","v":0},null,{"$f":"+IF(years>4,+F223,0)","v":0},null,{"$f":"+IF(years>4,+H223,0)","v":0},null,{"$f":"+IF(years>4,+J223,J223)","v":" Select one"},null,{"$f":"+IF(years>4,+L223+(L223*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N223,0)","v":0},null,{"$f":"+IF(years>4,+P223,0)","v":0},null,{"$f":"+IF(years>4,+R223,0)","v":0},null,{"$f":"ROUND(L291*(+N291+P291+R291),0)","v":0},null,{"$f":"VLOOKUP(J291,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V291*T291,0)","v":0},null,{"$f":"ROUND(X291+T291,0)","v":0},null,{"$f":"+IF(years>4,+AB223+(AB223*$R$12),0)","v":0},null,{"$f":"ROUND(AB291*V291,0)","v":0},null,{"$f":"ROUND(AD291+AB291,0)","v":0}]
[]
[4,{"$f":"+IF(years>4,+B225,0)","v":0},null,{"$f":"+IF(years>4,+D225,0)","v":0},null,{"$f":"+IF(years>4,+F225,0)","v":0},null,{"$f":"+IF(years>4,+H225,0)","v":0},null,{"$f":"+IF(years>4,+J225,J225)","v":" Select one"},null,{"$f":"+IF(years>4,+L225+(L225*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N225,0)","v":0},null,{"$f":"+IF(years>4,+P225,0)","v":0},null,{"$f":"+IF(years>4,+R225,0)","v":0},null,{"$f":"ROUND(L293*(+N293+P293+R293),0)","v":0},null,{"$f":"VLOOKUP(J293,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V293*T293,0)","v":0},null,{"$f":"ROUND(X293+T293,0)","v":0},null,{"$f":"+IF(years>4,+AB225+(AB225*$R$12),0)","v":0},null,{"$f":"ROUND(AB293*V293,0)","v":0},null,{"$f":"ROUND(AD293+AB293,0)","v":0}]
[]
[5,{"$f":"+IF(years>4,+B227,0)","v":0},null,{"$f":"+IF(years>4,+D227,0)","v":0},null,{"$f":"+IF(years>4,+F227,0)","v":0},null,{"$f":"+IF(years>4,+H227,0)","v":0},null,{"$f":"+IF(years>4,+J227,J227)","v":" Select one"},null,{"$f":"+IF(years>4,+L227+(L227*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N227,0)","v":0},null,{"$f":"+IF(years>4,+P227,0)","v":0},null,{"$f":"+IF(years>4,+R227,0)","v":0},null,{"$f":"ROUND(L295*(+N295+P295+R295),0)","v":0},null,{"$f":"VLOOKUP(J295,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V295*T295,0)","v":0},null,{"$f":"ROUND(X295+T295,0)","v":0},null,{"$f":"+IF(years>4,+AB227+(AB227*$R$12),0)","v":0},null,{"$f":"ROUND(AB295*V295,0)","v":0},null,{"$f":"ROUND(AD295+AB295,0)","v":0}]
[]
[6,{"$f":"+IF(years>4,+B229,0)","v":0},null,{"$f":"+IF(years>4,+D229,0)","v":0},null,{"$f":"+IF(years>4,+F229,0)","v":0},null,{"$f":"+IF(years>4,+H229,0)","v":0},null,{"$f":"+IF(years>4,+J229,J229)","v":" Select one"},null,{"$f":"+IF(years>4,+L229+(L229*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N229,0)","v":0},null,{"$f":"+IF(years>4,+P229,0)","v":0},null,{"$f":"+IF(years>4,+R229,0)","v":0},null,{"$f":"ROUND(L297*(+N297+P297+R297),0)","v":0},null,{"$f":"VLOOKUP(J297,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V297*T297,0)","v":0},null,{"$f":"ROUND(X297+T297,0)","v":0},null,{"$f":"+IF(years>4,+AB229+(AB229*$R$12),0)","v":0},null,{"$f":"ROUND(AB297*V297,0)","v":0},null,{"$f":"ROUND(AD297+AB297,0)","v":0}]
[]
[7,{"$f":"+IF(years>4,+B231,0)","v":0},null,{"$f":"+IF(years>4,+D231,0)","v":0},null,{"$f":"+IF(years>4,+F231,0)","v":0},null,{"$f":"+IF(years>4,+H231,0)","v":0},null,{"$f":"+IF(years>4,+J231,J231)","v":" Select one"},null,{"$f":"+IF(years>4,+L231+(L231*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N231,0)","v":0},null,{"$f":"+IF(years>4,+P231,0)","v":0},null,{"$f":"+IF(years>4,+R231,0)","v":0},null,{"$f":"ROUND(L299*(+N299+P299+R299),0)","v":0},null,{"$f":"VLOOKUP(J299,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V299*T299,0)","v":0},null,{"$f":"ROUND(X299+T299,0)","v":0},null,{"$f":"+IF(years>4,+AB231+(AB231*$R$12),0)","v":0},null,{"$f":"ROUND(AB299*V299,0)","v":0},null,{"$f":"ROUND(AD299+AB299,0)","v":0}]
[]
[8,{"$f":"+IF(years>4,+B233,0)","v":0},null,{"$f":"+IF(years>4,+D233,0)","v":0},null,{"$f":"+IF(years>4,+F233,0)","v":0},null,{"$f":"+IF(years>4,+H233,0)","v":0},null,{"$f":"+IF(years>4,+J233,J233)","v":" Select one"},null,{"$f":"+IF(years>4,+L233+(L233*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N233,0)","v":0},null,{"$f":"+IF(years>4,+P233,0)","v":0},null,{"$f":"+IF(years>4,+R233,0)","v":0},null,{"$f":"ROUND(L301*(+N301+P301+R301),0)","v":0},null,{"$f":"VLOOKUP(J301,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V301*T301,0)","v":0},null,{"$f":"ROUND(X301+T301,0)","v":0},null,{"$f":"+IF(years>4,+AB233+(AB233*$R$12),0)","v":0},null,{"$f":"ROUND(AB301*V301,0)","v":0},null,{"$f":"ROUND(AD301+AB301,0)","v":0}]
[]
[9,{"$f":"+IF(years>4,+B235,0)","v":0},null,{"$f":"+IF(years>4,+D235,0)","v":0},null,{"$f":"+IF(years>4,+F235,0)","v":0},null,{"$f":"+IF(years>4,+H235,0)","v":0},null,{"$f":"+IF(years>4,+J235,J235)","v":" Select one"},null,{"$f":"+IF(years>4,+L235+(L235*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N235,0)","v":0},null,{"$f":"+IF(years>4,+P235,0)","v":0},null,{"$f":"+IF(years>4,+R235,0)","v":0},null,{"$f":"ROUND(L303*(+N303+P303+R303),0)","v":0},null,{"$f":"VLOOKUP(J303,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V303*T303,0)","v":0},null,{"$f":"ROUND(X303+T303,0)","v":0},null,{"$f":"+IF(years>4,+AB235+(AB235*$R$12),0)","v":0},null,{"$f":"ROUND(AB303*V303,0)","v":0},null,{"$f":"ROUND(AD303+AB303,0)","v":0}]
[]
[10,{"$f":"+IF(years>4,+B237,0)","v":0},null,{"$f":"+IF(years>4,+D237,0)","v":0},null,{"$f":"+IF(years>4,+F237,0)","v":0},null,{"$f":"+IF(years>4,+H237,0)","v":0},null,{"$f":"+IF(years>4,+J237,J237)","v":" Select one"},null,{"$f":"+IF(years>4,+L237+(L237*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N237,0)","v":0},null,{"$f":"+IF(years>4,+P237,0)","v":0},null,{"$f":"+IF(years>4,+R237,0)","v":0},null,{"$f":"ROUND(L305*(+N305+P305+R305),0)","v":0},null,{"$f":"VLOOKUP(J305,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V305*T305,0)","v":0},null,{"$f":"ROUND(X305+T305,0)","v":0},null,{"$f":"+IF(years>4,+AB237+(AB237*$R$12),0)","v":0},null,{"$f":"ROUND(AB305*V305,0)","v":0},null,{"$f":"ROUND(AD305+AB305,0)","v":0}]
[]
[11,{"$f":"+IF(years>4,+B239,0)","v":0},null,{"$f":"+IF(years>4,+D239,0)","v":0},null,{"$f":"+IF(years>4,+F239,0)","v":0},null,{"$f":"+IF(years>4,+H239,0)","v":0},null,{"$f":"+IF(years>4,+J239,J239)","v":" Select one"},null,{"$f":"+IF(years>4,+L239+(L239*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N239,0)","v":0},null,{"$f":"+IF(years>4,+P239,0)","v":0},null,{"$f":"+IF(years>4,+R239,0)","v":0},null,{"$f":"ROUND(L307*(+N307+P307+R307),0)","v":0},null,{"$f":"VLOOKUP(J307,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V307*T307,0)","v":0},null,{"$f":"ROUND(X307+T307,0)","v":0},null,{"$f":"+IF(years>4,+AB239+(AB239*$R$12),0)","v":0},null,{"$f":"ROUND(AB307*V307,0)","v":0},null,{"$f":"ROUND(AD307+AB307,0)","v":0}]
[]
[12,{"$f":"+IF(years>4,+B241,0)","v":0},null,{"$f":"+IF(years>4,+D241,0)","v":0},null,{"$f":"+IF(years>4,+F241,0)","v":0},null,{"$f":"+IF(years>4,+H241,0)","v":0},null,{"$f":"+IF(years>4,+J241,J241)","v":" Select one"},null,{"$f":"+IF(years>4,+L241+(L241*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N241,0)","v":0},null,{"$f":"+IF(years>4,+P241,0)","v":0},null,{"$f":"+IF(years>4,+R241,0)","v":0},null,{"$f":"ROUND(L309*(+N309+P309+R309),0)","v":0},null,{"$f":"VLOOKUP(J309,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V309*T309,0)","v":0},null,{"$f":"ROUND(X309+T309,0)","v":0},null,{"$f":"+IF(years>4,+AB241+(AB241*$R$12),0)","v":0},null,{"$f":"ROUND(AB309*V309,0)","v":0},null,{"$f":"ROUND(AD309+AB309,0)","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,"Total Senior Personnel",null,{"$f":"SUM(Z287:Z309)","v":0},null,null,null,"Total Senior Personnel",null,{"$f":"SUM(AF287:AF309)","v":0}]
[]
[]
[null,"Other Personnel"]
[null,"Number of Personnel",null,null,null,null,null,null,null,null,null,"Base Salary/ Month",null,"Cal Month",null,"Acad. Month",null,"Summer Month",null,"Requested Salary",null,"Fringe Rate %",null,"Fringe Benefit $",null,"Federal Fund Requested $",null,"Cost-Shared / Matching Salary",null,"Fringe Benefit $",null,"Cost-Shared / Matching Funds $"]
[]
[null,{"$f":"IF(years>4,+B250,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L250+(L250*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N250,0)","v":0},null,{"$f":"+IF(years>4,+P250,0)","v":0},null,0,null,{"$f":"ROUND(L318*(+N318+P318+R318)*B318,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V318*T318,0)","v":0},null,{"$f":"ROUND(X318+T318,0)","v":0},null,{"$f":"+IF(years>4,+AB250+(AB250*$R$12),0)","v":0},null,{"$f":"ROUND(AB318*V318,0)","v":0},null,{"$f":"ROUND(AD318+AB318,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B252,0)","v":0},null,"Post Doctoral Associate",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L252+(L252*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N252,0)","v":0},null,{"$f":"+IF(years>4,+P252,0)","v":0},null,{"$f":"+IF(years>4,+R252,0)","v":0},null,{"$f":"ROUND(L320*(+N320+P320+R320)*B320,0)","v":0},null,{"$f":"$H$377","v":0.33},null,{"$f":"ROUND(V320*T320,0)","v":0},null,{"$f":"ROUND(X320+T320,0)","v":0},null,{"$f":"+IF(years>4,+AB252+(AB252*$R$12),0)","v":0},null,{"$f":"ROUND(AB320*V320,0)","v":0},null,{"$f":"ROUND(AD320+AB320,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B254,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L254+(L254*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N254,0)","v":0},null,{"$f":"+IF(years>4,+P254,0)","v":0},null,{"$f":"+IF(years>4,+R254,0)","v":0},null,{"$f":"ROUND(L322*(+N322+P322+R322)*B322,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V322*T322,0)","v":0},null,{"$f":"ROUND(X322+T322,0)","v":0},null,{"$f":"+IF(years>4,+AB254+(AB254*$R$12),0)","v":0},null,{"$f":"ROUND(AB322*V322,0)","v":0},null,{"$f":"ROUND(AD322+AB322,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B256,0)","v":0},null,"Graduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L256+(L256*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N256,0)","v":0},null,{"$f":"+IF(years>4,+P256,0)","v":0},null,{"$f":"+IF(years>4,+R256,0)","v":0},null,{"$f":"ROUND(L324*(+N324+P324+R324)*B324,0)","v":0},null,{"$f":"$H$370","v":0.13},null,{"$f":"ROUND(V324*T324,0)","v":0},null,{"$f":"ROUND(X324+T324,0)","v":0},null,{"$f":"+IF(years>4,+AB256+(AB256*$R$12),0)","v":0},null,{"$f":"ROUND(AB324*V324,0)","v":0},null,{"$f":"ROUND(AD324+AB324,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B258,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L258+(L258*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N258,0)","v":0},null,{"$f":"+IF(years>4,+P258,0)","v":0},null,{"$f":"+IF(years>4,+R258,0)","v":0},null,{"$f":"ROUND(L326*(+N326+P326+R326)*B326,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V326*T326,0)","v":0},null,{"$f":"ROUND(X326+T326,0)","v":0},null,{"$f":"+IF(years>4,+AB258+(AB258*$R$12),0)","v":0},null,{"$f":"ROUND(AB326*V326,0)","v":0},null,{"$f":"ROUND(AD326+AB326,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B260,0)","v":0},null,"Undergraduate Students",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L260+(L260*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N260,0)","v":0},null,{"$f":"+IF(years>4,+P260,0)","v":0},null,{"$f":"+IF(years>4,+R260,0)","v":0},null,{"$f":"ROUND(L328*(+N328+P328+R328)*B328,0)","v":0},null,{"$f":"$H$383","v":4.5999999999999999E-2},null,{"$f":"ROUND(V328*T328,0)","v":0},null,{"$f":"ROUND(X328+T328,0)","v":0},null,{"$f":"+IF(years>4,+AB260+(AB260*$R$12),0)","v":0},null,{"$f":"ROUND(AB328*V328,0)","v":0},null,{"$f":"ROUND(AD328+AB328,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B262,0)","v":0},null,"Secretarial/Clerical",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L262+(L262*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N262,0)","v":0},null,{"$f":"+IF(years>4,+P262,0)","v":0},null,{"$f":"+IF(years>4,+R262,0)","v":0},null,{"$f":"ROUND(L330*(+N330+P330+R330)*B330,0)","v":0},null,{"$f":"$H$375","v":0.51},null,{"$f":"ROUND(V330*T330,0)","v":0},null,{"$f":"ROUND(X330+T330,0)","v":0},null,{"$f":"+IF(years>4,+AB262+(AB262*$R$12),0)","v":0},null,{"$f":"ROUND(AB330*V330,0)","v":0},null,{"$f":"ROUND(AD330+AB330,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B264,0)","v":0},null,"Non-Student Hourly",null,null,null,null,null,null,null,{"$f":"+IF(years>4,+L264+(L264*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N264,0)","v":0},null,{"$f":"+IF(years>4,+P264,0)","v":0},null,{"$f":"+IF(years>4,+R264,0)","v":0},null,{"$f":"ROUND(L332*(+N332+P332+R332)*B332,0)","v":0},null,{"$f":"$H$371","v":0.12},null,{"$f":"ROUND(V332*T332,0)","v":0},null,{"$f":"ROUND(X332+T332,0)","v":0},null,{"$f":"+IF(years>4,+AB264+(AB264*$R$12),0)","v":0},null,{"$f":"ROUND(AB332*V332,0)","v":0},null,{"$f":"ROUND(AD332+AB332,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B266,0)","v":0},null,{"$f":"+IF(years>4,+D266,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J266,J266)","v":" Select one"},null,{"$f":"+IF(years>4,+L266+(L266*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N266,0)","v":0},null,{"$f":"+IF(years>4,+P266,0)","v":0},null,{"$f":"+IF(years>4,+R266,0)","v":0},null,{"$f":"ROUND(L334*(+N334+P334+R334)*B334,0)","v":0},null,{"$f":"VLOOKUP(J334,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V334*T334,0)","v":0},null,{"$f":"ROUND(X334+T334,0)","v":0},null,{"$f":"+IF(years>4,+AB266+(AB266*$R$12),0)","v":0},null,{"$f":"ROUND(AB334*V334,0)","v":0},null,{"$f":"ROUND(AD334+AB334,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B268,0)","v":0},null,{"$f":"+IF(years>4,+D268,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J268,J268)","v":" Select one"},null,{"$f":"+IF(years>4,+L268+(L268*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N268,0)","v":0},null,{"$f":"+IF(years>4,+P268,0)","v":0},null,{"$f":"+IF(years>4,+R268,0)","v":0},null,{"$f":"ROUND(L336*(+N336+P336+R336)*B336,0)","v":0},null,{"$f":"VLOOKUP(J336,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V336*T336,0)","v":0},null,{"$f":"ROUND(X336+T336,0)","v":0},null,{"$f":"+IF(years>4,+AB268+(AB268*$R$12),0)","v":0},null,{"$f":"ROUND(AB336*V336,0)","v":0},null,{"$f":"ROUND(AD336+AB336,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B270,0)","v":0},null,{"$f":"+IF(years>4,+D270,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J270,J270)","v":" Select one"},null,{"$f":"+IF(years>4,+L270+(L270*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N270,0)","v":0},null,{"$f":"+IF(years>4,+P270,0)","v":0},null,{"$f":"+IF(years>4,+R270,0)","v":0},null,{"$f":"ROUND(L338*(+N338+P338+R338)*B338,0)","v":0},null,{"$f":"VLOOKUP(J338,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V338*T338,0)","v":0},null,{"$f":"ROUND(X338+T338,0)","v":0},null,{"$f":"+IF(years>4,+AB270+(AB270*$R$12),0)","v":0},null,{"$f":"ROUND(AB338*V338,0)","v":0},null,{"$f":"ROUND(AD338+AB338,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B272,0)","v":0},null,{"$f":"+IF(years>4,+D272,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J272,J272)","v":" Select one"},null,{"$f":"+IF(years>4,+L272+(L272*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N272,0)","v":0},null,{"$f":"+IF(years>4,+P272,0)","v":0},null,{"$f":"+IF(years>4,+R272,0)","v":0},null,{"$f":"ROUND(L340*(+N340+P340+R340)*B340,0)","v":0},null,{"$f":"VLOOKUP(J340,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V340*T340,0)","v":0},null,{"$f":"ROUND(X340+T340,0)","v":0},null,{"$f":"+IF(years>4,+AB272+(AB272*$R$12),0)","v":0},null,{"$f":"ROUND(AB340*V340,0)","v":0},null,{"$f":"ROUND(AD340+AB340,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B274,0)","v":0},null,{"$f":"+IF(years>4,+D274,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J274,J274)","v":" Select one"},null,{"$f":"+IF(years>4,+L274+(L274*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N274,0)","v":0},null,{"$f":"+IF(years>4,+P274,0)","v":0},null,{"$f":"+IF(years>4,+R274,0)","v":0},null,{"$f":"ROUND(L342*(+N342+P342+R342)*B342,0)","v":0},null,{"$f":"VLOOKUP(J342,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V342*T342,0)","v":0},null,{"$f":"ROUND(X342+T342,0)","v":0},null,{"$f":"+IF(years>4,+AB274+(AB274*$R$12),0)","v":0},null,{"$f":"ROUND(AB342*V342,0)","v":0},null,{"$f":"ROUND(AD342+AB342,0)","v":0}]
[]
[null,{"$f":"IF(years>4,+B276,0)","v":0},null,{"$f":"+IF(years>4,+D276,0)","v":0},null,null,null,null,null,{"$f":"+IF(years>4,+J276,J276)","v":" Select one"},null,{"$f":"+IF(years>4,+L276+(L276*$R$12),0)","v":0},null,{"$f":"+IF(years>4,+N276,0)","v":0},null,{"$f":"+IF(years>4,+P276,0)","v":0},null,{"$f":"+IF(years>4,+R276,0)","v":0},null,{"$f":"ROUND(L344*(+N344+P344+R344)*B344,0)","v":0},null,{"$f":"VLOOKUP(J344,$D$356:$H$386,5)","v":0},null,{"$f":"ROUND(V344*T344,0)","v":0},null,{"$f":"ROUND(X344+T344,0)","v":0},null,{"$f":"+IF(years>4,+AB276+(AB276*$R$12),0)","v":0},null,{"$f":"ROUND(AB344*V344,0)","v":0},null,{"$f":"ROUND(AD344+AB344,0)","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,"Total Other Personnel",null,{"$f":"SUM(Z318:Z344)","v":0},null,null,null,"Total Other Personnel",null,{"$f":"SUM(AF318:AF344)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 5 Totals","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X318:X344,X287:X309)","v":0},null,{"$f":"SUM(T318:T344,T287:T309)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumulative Totals - All Years","Fringes",null,"Salaries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+X78+X146+X214+X282+X350","v":0},null,{"$f":"+Z78+Z146+Z214+Z282+Z350","v":0}]
[null,"List of Classifications and Fringe Rates",null,null,null,null,null,null,null,"Escalation"]
[]
[null,null,null," Select one",null,null,null,0]
[null,null,null,"Admin Spec",null,null,null,0.378,null,0]
[null,null,null,"Assist/Assoc Dir",null,null,null,0.378,null,5.0000000000000001E-3]
[null,null,null,"Assoc/Ass't Prof",null,null,null,0.315,null,0.01]
[null,null,null,"Clerk",null,null,null,0.51,null,1.4999999999999999E-2]
[null,null,null,"Comp Support",null,null,null,0.378,null,0.02]
[null,null,null,"Comp Tech",null,null,null,0.378,null,2.5000000000000001E-2]
[null,null,null,"Data Entry/Tech",null,null,null,0.51,null,0.03]
[null,null,null,"Director",null,null,null,0.378,null,3.5000000000000003E-2]
[null,null,null,"Engineer",null,null,null,0.378,null,0.04]
[null,null,null,"Ext Prog Asst",null,null,null,0.378]
[null,null,null,"Ext Specialist",null,null,null,0.378]
[null,null,null,"Extension Dir",null,null,null,0.378]
[null,null,null,"Faculty",null,null,null,0.315]
[null,null,null,"Graduate Student",null,null,null,0.13]
[null,null,null,"Hourly (Non-student)",null,null,null,0.12]
[null,null,null,"Instructor",null,null,null,0.315]
[null,null,null,"Lecturer",null,null,null,0.315]
[null,null,null,"Manager",null,null,null,0.378]
[null,null,null,"Merit",null,null,null,0.51]
[null,null,null,"P&S",null,null,null,0.378]
[null,null,null,"Post Doc Assoc",null,null,null,0.33]
[null,null,null,"Professor",null,null,null,0.315]
[null,null,null,"Prog Asst/Coord",null,null,null,0.378]
[null,null,null,"Research Assoc",null,null,null,0.378]
[null,null,null,"Scientist",null,null,null,0.378]
[null,null,null,"Secretary",null,null,null,0.51]
[null,null,null,"Student Hourly",null,null,null,4.5999999999999999E-2]
[null,null,null,"Systems Analyst",null,null,null,0.378]
[null,null,null,"Systems Support",null,null,null,0.378]
[null,null,null,"Technician",null,null,null,0.51]

{"sheet":"Equip-Travel-Participants","index":2,"n_rows":95,"n_cols":29,"rows_kept":95,"cut":false,"hidden":false,"merged":[[31,2,31,8],[17,2,17,8],[19,2,19,8],[5,2,5,8],[7,2,7,8],[9,2,9,8],[11,2,11,8],[13,2,13,8],[15,2,15,8],[47,4,47,8],[51,7,51,8],[49,6,49,8],[1,0,1,18],[41,2,41,8],[43,2,43,8],[45,2,45,8],[33,2,33,8],[35,2,35,8],[37,2,37,8],[21,2,21,8],[23,2,23,8],[39,2,39,8],[25,2,25,8],[27,2,27,8],[29,2,29,8]]}
[null,null,"Running Total for Cumulative Budget Amount = ",null,null,null,null,null,{"$f":"'Cumulative Budget'!AE65","v":0}]
["           Worksheet for Project Budget - Equipment, Travel, Participant/Trainee Support Costs"]
[]
[null,null,"Equipment Description",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
[null,null,"List items and dollar amount for each item exceeding $5,000"]
[null,null,"Equipment item",null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds"]
[]
[1,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[2,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[3,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[4,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[5,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[6,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[7,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[8,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
[]
[9,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[10,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total funds requested for all eqiupment listed",null,null,null,null,null,null,null,{"$f":"SUM(K8:K26)","v":0},null,{"$f":"SUM(M8:M26)","v":0},null,{"$f":"SUM(O8:O26)","v":0},null,{"$f":"SUM(Q8:Q26)","v":0},null,{"$f":"SUM(S8:S26)","v":0},null,{"$f":"SUM(U8:U26)","v":0},null,{"$f":"SUM(W8:W26)","v":0},null,{"$f":"SUM(Y8:Y26)","v":0},null,{"$f":"SUM(AA8:AA26)","v":0},null,{"$f":"SUM(AC8:AC26)","v":0}]
[]
[]
[]
[null,null,"Travel"]
[]
[1,null,"Domestic Travel Costs (incl. Canada, Mexico and U.S. Possessions",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K34*1.03,0)","v":0},null,{"$f":"IF(years>2,+M34*1.03,0)","v":0},null,{"$f":"IF(years>3,+O34*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q34*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U34*1.03,0)","v":0},null,{"$f":"IF(years>2,+W34*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y34*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA34*1.03,0)","v":0}]
[]
[2,null,"Foreign Travel Costs",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K36*1.03,0)","v":0},null,{"$f":"IF(years>2,+M36*1.03,0)","v":0},null,{"$f":"IF(years>3,+O36*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q36*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U36*1.03,0)","v":0},null,{"$f":"IF(years>2,+W36*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y36*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA36*1.03,0)","v":0}]
[]
[null,null,"Total Travel Cost",null,null,null,null,null,null,null,{"$f":"SUM(K34:K36)","v":0},null,{"$f":"SUM(M34:M36)","v":0},null,{"$f":"SUM(O34:O36)","v":0},null,{"$f":"SUM(Q34:Q36)","v":0},null,{"$f":"SUM(S34:S36)","v":0},null,{"$f":"SUM(U34:U36)","v":0},null,{"$f":"SUM(W34:W36)","v":0},null,{"$f":"SUM(Y34:Y36)","v":0},null,{"$f":"SUM(AA34:AA36)","v":0},null,{"$f":"SUM(AC34:AC36)","v":0}]
[]
[null,null,"Participant/Trainee Support Costs (for NSF only)"]
[]
[2,null,"Stipend",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K42*1.03,0)","v":0},null,{"$f":"IF(years>2,+M42*1.03,0)","v":0},null,{"$f":"IF(years>3,+O42*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q42*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U42*1.03,0)","v":0},null,{"$f":"IF(years>2,+W42*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y42*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA42*1.03,0)","v":0}]
[]
[3,null,"Travel",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K44*1.03,0)","v":0},null,{"$f":"IF(years>2,+M44*1.03,0)","v":0},null,{"$f":"IF(years>3,+O44*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q44*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U44*1.03,0)","v":0},null,{"$f":"IF(years>2,+W44*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y44*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA44*1.03,0)","v":0}]
[]
[4,null,"Subsistence",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K46*1.03,0)","v":0},null,{"$f":"IF(years>2,+M46*1.03,0)","v":0},null,{"$f":"IF(years>3,+O46*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q46*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U46*1.03,0)","v":0},null,{"$f":"IF(years>2,+W46*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y46*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA46*1.03,0)","v":0}]
[]
[5,null,"Other ",null,null,null,null,null,null,null,null,null,{"$f":"IF(years>1,+K48*1.03,0)","v":0},null,{"$f":"IF(years>2,+M48*1.03,0)","v":0},null,{"$f":"IF(years>3,+O48*1.03,0)","v":0},null,{"$f":"IF(years>4,+Q48*1.03,0)","v":0},null,0,null,{"$f":"IF(years>1,+U48*1.03,0)","v":0},null,{"$f":"IF(years>2,+W48*1.03,0)","v":0},null,{"$f":"IF(years>3,+Y48*1.03,0)","v":0},null,{"$f":"IF(years>4,+AA48*1.03,0)","v":0}]
[]
[null,null,null,null,null,null,"Total Participant/Trainee Support Costs",null,null,null,{"$f":"SUM(K42:K48)","v":0},null,{"$f":"SUM(M42:M48)","v":0},null,{"$f":"SUM(O42:O48)","v":0},null,{"$f":"SUM(Q42:Q48)","v":0},null,{"$f":"SUM(S42:S48)","v":0},null,{"$f":"SUM(U42:U48)","v":0},null,{"$f":"SUM(W42:W48)","v":0},null,{"$f":"SUM(Y42:Y48)","v":0},null,{"$f":"SUM(AA42:AA48)","v":0},null,{"$f":"SUM(AC42:AC48)","v":0}]
[]
[null,null,null,null,null,null,null,"# of Participants/Trainees",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U13","v":0}]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U42","v":0}]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,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,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Other Direct","index":3,"n_rows":186,"n_cols":29,"rows_kept":186,"cut":false,"hidden":false,"merged":[[68,0,72,0],[68,2,68,3],[70,2,70,3],[72,2,72,3],[74,0,78,0],[74,2,74,3],[76,2,76,3],[78,2,78,3],[157,8,157,16],[61,2,61,5],[61,6,61,7],[62,2,62,5],[63,2,63,5],[66,2,66,7],[127,8,127,16],[94,2,94,8],[92,2,92,8],[88,2,88,8],[90,2,90,8],[86,2,86,8],[84,2,84,8],[28,0,32,0],[34,0,38,0],[38,2,38,3],[22,2,22,5],[23,2,23,5],[1,0,1,18],[21,2,21,5],[5,2,5,8],[7,2,7,8],[9,2,9,8],[11,2,11,8],[13,2,13,8],[15,2,15,8],[17,2,17,8],[19,2,19,8],[21,6,21,7],[46,2,46,7],[82,2,82,8],[26,2,26,7],[28,2,28,3],[30,2,30,3],[32,2,32,3],[34,2,34,3],[36,2,36,3],[42,2,42,5],[43,2,43,5],[41,2,41,5],[41,6,41,7],[80,2,80,8],[48,0,52,0],[48,2,48,3],[50,2,50,3],[52,2,52,3],[54,0,58,0],[54,2,54,3],[56,2,56,3],[58,2,58,3]]}
[null,null,"Running Total for Cumulative Budget Amount = ",null,null,null,null,null,{"$f":"'Cumulative Budget'!AE65","v":0}]
["Worksheet for Project Budget - Equipment, Travel, Participant/Trainee Support Costs"]
[]
[null,null,"           Other Direct Costs",null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",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,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds"]
[]
[1,null,"Materials and Supplies"]
[]
[2,null,"Publication Costs"]
[]
[3,null,"Consultant Services"]
[]
[4,null,"ADP/Computer Services"]
[]
[5,null,"Subawards/Consortium/Contractual Costs",null,null,null,null,null,null,null,{"$f":"Subcontracts!K60","v":0},null,{"$f":"Subcontracts!M60","v":0},null,{"$f":"Subcontracts!O60","v":0},null,{"$f":"Subcontracts!Q60","v":0},null,{"$f":"Subcontracts!S60","v":0},null,{"$f":"Subcontracts!U60","v":0},null,{"$f":"Subcontracts!W60","v":0},null,{"$f":"Subcontracts!Y60","v":0},null,{"$f":"Subcontracts!AA60","v":0},null,{"$f":"Subcontracts!AC60","v":0}]
[]
[6,null,"Equipment or Facility Rental/User Fees"]
[]
[7,null,"Alterations and Renovations",null,null,null,null,null,null,null,0]
[]
[8,null,"Graduate Student Tuition (most majors)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$22=\"1/2-time\",K23,K24),0)","v":0},null,{"$f":"ROUND(IF($I$22=\"1/2-time\",M23,M24),0)","v":0},null,{"$f":"ROUND(IF($I$22=\"1/2-time\",O23,O24),0)","v":0},null,{"$f":"ROUND(IF($I$22=\"1/2-time\",Q23,Q24),0)","v":0},null,{"$f":"ROUND(IF($I$22=\"1/2-time\",S23,S24),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C29*VLOOKUP(K29,$I$101:$Q$126,5,FALSE)+C31*VLOOKUP(K31,$I$101:$Q$126,5,FALSE)+C33*VLOOKUP(K33,$I$101:$Q$126,5,FALSE)+C35*VLOOKUP(K35,$I$101:$Q$126,9,FALSE)+C37*VLOOKUP(K37,$I$101:$Q$126,9,FALSE)+C39*VLOOKUP(K39,$I$101:$Q$126,9,FALSE)","v":0},null,{"$f":"+E29*VLOOKUP(M29,$I$101:$Q$133,5,FALSE)+E31*VLOOKUP(M31,$I$101:$Q$133,5,FALSE)+E33*VLOOKUP(M33,$I$101:$Q$133,5,FALSE)+E35*VLOOKUP(M35,$I$101:$Q$133,9,FALSE)+E37*VLOOKUP(M37,$I$101:$Q$133,9,FALSE)+E39*VLOOKUP(M39,$I$101:$Q$133,9,FALSE)","v":0},null,{"$f":"+F29*VLOOKUP(O29,$I$101:$Q$133,5,FALSE)+F31*VLOOKUP(O31,$I$101:$Q$133,5,FALSE)+F33*VLOOKUP(O33,$I$101:$Q$133,5,FALSE)+F35*VLOOKUP(O35,$I$101:$Q$133,9,FALSE)+F37*VLOOKUP(O37,$I$101:$Q$133,9,FALSE)+F39*VLOOKUP(O39,$I$101:$Q$133,9,FALSE)","v":0},null,{"$f":"+G29*VLOOKUP(Q29,$I$101:$Q$133,5,FALSE)+G31*VLOOKUP(Q31,$I$101:$Q$133,5,FALSE)+G33*VLOOKUP(Q33,$I$101:$Q$133,5,FALSE)+G35*VLOOKUP(Q35,$I$101:$Q$133,9,FALSE)+G37*VLOOKUP(Q37,$I$101:$Q$133,9,FALSE)+G39*VLOOKUP(Q39,$I$101:$Q$133,9,FALSE)","v":0},null,{"$f":"+H29*VLOOKUP(S29,$I$101:$Q$133,5,FALSE)+H31*VLOOKUP(S31,$I$101:$Q$133,5,FALSE)+H33*VLOOKUP(S33,$I$101:$Q$133,5,FALSE)+H35*VLOOKUP(S35,$I$101:$Q$133,9,FALSE)+H37*VLOOKUP(S37,$I$101:$Q$133,9,FALSE)+H39*VLOOKUP(S39,$I$101:$Q$133,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C29*VLOOKUP(K29,$I$101:$Q$126,3,FALSE)+C31*VLOOKUP(K31,$I$101:$Q$126,3,FALSE)+C33*VLOOKUP(K33,$I$101:$Q$126,3,FALSE)+C35*VLOOKUP(K35,$I$101:$Q$126,7,FALSE)+C37*VLOOKUP(K37,$I$101:$Q$126,7,FALSE)+C39*VLOOKUP(K39,$I$101:$Q$126,7,FALSE)","v":0},null,{"$f":"+E29*VLOOKUP(M29,$I$101:$Q$126,3,FALSE)+E31*VLOOKUP(M31,$I$101:$Q$126,3,FALSE)+E33*VLOOKUP(M33,$I$101:$Q$126,3,FALSE)+E35*VLOOKUP(M35,$I$101:$Q$126,7,FALSE)+E37*VLOOKUP(M37,$I$101:$Q$126,7,FALSE)+E39*VLOOKUP(M39,$I$101:$Q$126,7,FALSE)","v":0},null,{"$f":"+F29*VLOOKUP(O29,$I$101:$Q$126,3,FALSE)+F31*VLOOKUP(O31,$I$101:$Q$126,3,FALSE)+F33*VLOOKUP(O33,$I$101:$Q$126,3,FALSE)+F35*VLOOKUP(O35,$I$101:$Q$126,7,FALSE)+F37*VLOOKUP(O37,$I$101:$Q$126,7,FALSE)+F39*VLOOKUP(O39,$I$101:$Q$126,7,FALSE)","v":0},null,{"$f":"+G29*VLOOKUP(Q29,$I$101:$Q$126,3,FALSE)+G31*VLOOKUP(Q31,$I$101:$Q$126,3,FALSE)+G33*VLOOKUP(Q33,$I$101:$Q$126,3,FALSE)+G35*VLOOKUP(Q35,$I$101:$Q$126,7,FALSE)+G37*VLOOKUP(Q37,$I$101:$Q$126,7,FALSE)+G39*VLOOKUP(Q39,$I$101:$Q$126,7,FALSE)","v":0},null,{"$f":"+H29*VLOOKUP(S29,$I$101:$Q$126,3,FALSE)+H31*VLOOKUP(S31,$I$101:$Q$126,3,FALSE)+H33*VLOOKUP(S33,$I$101:$Q$126,3,FALSE)+H35*VLOOKUP(S35,$I$101:$Q$126,7,FALSE)+H37*VLOOKUP(S37,$I$101:$Q$126,7,FALSE)+H39*VLOOKUP(S39,$I$101:$Q$126,7,FALSE)","v":0}]
[]
[]
[null,null,"Graduate Student Tuition (most majors)"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[8,null,"Graduate Student Tuition( Engineering & Architecture)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$42=\"1/2-time\",K43,K44),0)","v":0},null,{"$f":"ROUND(IF($I$42=\"1/2-time\",M43,M44),0)","v":0},null,{"$f":"ROUND(IF($I$42=\"1/2-time\",O43,O44),0)","v":0},null,{"$f":"ROUND(IF($I$42=\"1/2-time\",Q43,Q44),0)","v":0},null,{"$f":"ROUND(IF($I$42=\"1/2-time\",S43,S44),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C49*VLOOKUP(K49,$I$131:$Q$156,5,FALSE)+C51*VLOOKUP(K51,$I$131:$Q$156,5,FALSE)+C53*VLOOKUP(K53,$I$131:$Q$156,5,FALSE)+C55*VLOOKUP(K55,$I$131:$Q$156,9,FALSE)+C57*VLOOKUP(K57,$I$131:$Q$156,9,FALSE)+C59*VLOOKUP(K59,$I$131:$Q$156,9,FALSE)","v":0},null,{"$f":"+E49*VLOOKUP(M49,$I$131:$Q$156,5,FALSE)+E51*VLOOKUP(M51,$I$131:$Q$156,5,FALSE)+E53*VLOOKUP(M53,$I$131:$Q$156,5,FALSE)+E55*VLOOKUP(M55,$I$131:$Q$156,9,FALSE)+E57*VLOOKUP(M57,$I$131:$Q$156,9,FALSE)+E59*VLOOKUP(M59,$I$131:$Q$156,9,FALSE)","v":0},null,{"$f":"+F49*VLOOKUP(O49,$I$131:$Q$156,5,FALSE)+F51*VLOOKUP(O51,$I$131:$Q$156,5,FALSE)+F53*VLOOKUP(O53,$I$131:$Q$156,5,FALSE)+F55*VLOOKUP(O55,$I$131:$Q$156,9,FALSE)+F57*VLOOKUP(O57,$I$131:$Q$156,9,FALSE)+F59*VLOOKUP(O59,$I$131:$Q$156,9,FALSE)","v":0},null,{"$f":"+G49*VLOOKUP(Q49,$I$131:$Q$156,5,FALSE)+G51*VLOOKUP(Q51,$I$131:$Q$156,5,FALSE)+G53*VLOOKUP(Q53,$I$131:$Q$156,5,FALSE)+G55*VLOOKUP(Q55,$I$131:$Q$156,9,FALSE)+G57*VLOOKUP(Q57,$I$131:$Q$156,9,FALSE)+G59*VLOOKUP(Q59,$I$131:$Q$156,9,FALSE)","v":0},null,{"$f":"+H49*VLOOKUP(S49,$I$131:$Q$156,5,FALSE)+H51*VLOOKUP(S51,$I$131:$Q$156,5,FALSE)+H53*VLOOKUP(S53,$I$131:$Q$156,5,FALSE)+H55*VLOOKUP(S55,$I$131:$Q$156,9,FALSE)+H57*VLOOKUP(S57,$I$131:$Q$156,9,FALSE)+H59*VLOOKUP(S59,$I$131:$Q$156,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C49*VLOOKUP(K49,$I$131:$Q$156,3,FALSE)+C51*VLOOKUP(K51,$I$131:$Q$156,3,FALSE)+C53*VLOOKUP(K53,$I$131:$Q$156,3,FALSE)+C55*VLOOKUP(K55,$I$131:$Q$156,7,FALSE)+C57*VLOOKUP(K57,$I$131:$Q$156,7,FALSE)+C59*VLOOKUP(K59,$I$131:$Q$156,7,FALSE)","v":0},null,{"$f":"+E49*VLOOKUP(M49,$I$131:$Q$156,3,FALSE)+E51*VLOOKUP(M51,$I$131:$Q$156,3,FALSE)+E53*VLOOKUP(M53,$I$131:$Q$156,3,FALSE)+E55*VLOOKUP(M55,$I$131:$Q$156,7,FALSE)+E57*VLOOKUP(M57,$I$131:$Q$156,7,FALSE)+E59*VLOOKUP(M59,$I$131:$Q$156,7,FALSE)","v":0},null,{"$f":"+F49*VLOOKUP(O49,$I$131:$Q$156,3,FALSE)+F51*VLOOKUP(O51,$I$131:$Q$156,3,FALSE)+F53*VLOOKUP(O53,$I$131:$Q$156,3,FALSE)+F55*VLOOKUP(O55,$I$131:$Q$156,7,FALSE)+F57*VLOOKUP(O57,$I$131:$Q$156,7,FALSE)+F59*VLOOKUP(O59,$I$131:$Q$156,7,FALSE)","v":0},null,{"$f":"+G49*VLOOKUP(Q49,$I$131:$Q$156,3,FALSE)+G51*VLOOKUP(Q51,$I$131:$Q$156,3,FALSE)+G53*VLOOKUP(Q53,$I$131:$Q$156,3,FALSE)+G55*VLOOKUP(Q55,$I$131:$Q$156,7,FALSE)+G57*VLOOKUP(Q57,$I$131:$Q$156,7,FALSE)+G59*VLOOKUP(Q59,$I$131:$Q$156,7,FALSE)","v":0},null,{"$f":"+H49*VLOOKUP(S49,$I$131:$Q$156,3,FALSE)+H51*VLOOKUP(S51,$I$131:$Q$156,3,FALSE)+H53*VLOOKUP(S53,$I$131:$Q$156,3,FALSE)+H55*VLOOKUP(S55,$I$131:$Q$156,7,FALSE)+H57*VLOOKUP(S57,$I$131:$Q$156,7,FALSE)+H59*VLOOKUP(S59,$I$131:$Q$156,7,FALSE)","v":0}]
[]
[]
[null,null,"Engineering & Architecture Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[]
[8,null,"Graduate Student Tuition(Business & STB)",null,null,null,"select 1/4-time/1/2-time > >",null,"1/2-time",null,{"$f":"ROUND(IF($I$62=\"1/2-time\",K63,K64),0)","v":0},null,{"$f":"ROUND(IF($I$62=\"1/2-time\",M63,M64),0)","v":0},null,{"$f":"ROUND(IF($I$62=\"1/2-time\",O63,O64),0)","v":0},null,{"$f":"ROUND(IF($I$62=\"1/2-time\",Q63,Q64),0)","v":0},null,{"$f":"ROUND(IF($I$62=\"1/2-time\",S63,S64),0)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Maximum",null,{"$f":"+C69*VLOOKUP(K69,$I$161:$Q$186,5,FALSE)+C71*VLOOKUP(K71,$I$161:$Q$186,5,FALSE)+C73*VLOOKUP(K73,$I$161:$Q$186,5,FALSE)+C75*VLOOKUP(K75,$I$161:$Q$186,9,FALSE)+C77*VLOOKUP(K77,$I$161:$Q$186,9,FALSE)+C79*VLOOKUP(K79,$I$161:$Q$186,9,FALSE)","v":0},null,{"$f":"+E69*VLOOKUP(M69,$I$161:$Q$186,5,FALSE)+E71*VLOOKUP(M71,$I$161:$Q$186,5,FALSE)+E73*VLOOKUP(M73,$I$161:$Q$186,5,FALSE)+E75*VLOOKUP(M75,$I$161:$Q$186,9,FALSE)+E77*VLOOKUP(M77,$I$161:$Q$186,9,FALSE)+E79*VLOOKUP(M79,$I$161:$Q$186,9,FALSE)","v":0},null,{"$f":"+F69*VLOOKUP(O69,$I$161:$Q$186,5,FALSE)+F71*VLOOKUP(O71,$I$161:$Q$186,5,FALSE)+F73*VLOOKUP(O73,$I$161:$Q$186,5,FALSE)+F75*VLOOKUP(O75,$I$161:$Q$186,9,FALSE)+F77*VLOOKUP(O77,$I$161:$Q$186,9,FALSE)+F79*VLOOKUP(O79,$I$161:$Q$186,9,FALSE)","v":0},null,{"$f":"+G69*VLOOKUP(Q69,$I$161:$Q$186,5,FALSE)+G71*VLOOKUP(Q71,$I$161:$Q$186,5,FALSE)+G73*VLOOKUP(Q73,$I$161:$Q$186,5,FALSE)+G75*VLOOKUP(Q75,$I$161:$Q$186,9,FALSE)+G77*VLOOKUP(Q77,$I$161:$Q$186,9,FALSE)+G79*VLOOKUP(Q79,$I$161:$Q$186,9,FALSE)","v":0},null,{"$f":"+H69*VLOOKUP(S69,$I$161:$Q$186,5,FALSE)+H71*VLOOKUP(S71,$I$161:$Q$186,5,FALSE)+H73*VLOOKUP(S73,$I$161:$Q$186,5,FALSE)+H75*VLOOKUP(S75,$I$161:$Q$186,9,FALSE)+H77*VLOOKUP(S77,$I$161:$Q$186,9,FALSE)+H79*VLOOKUP(S79,$I$161:$Q$186,9,FALSE)","v":0}]
[8,null,"Graduate Student Tuition",null,null,null,null,null,"Minimum",null,{"$f":"+C69*VLOOKUP(K69,$I$161:$Q$186,3,FALSE)+C71*VLOOKUP(K71,$I$161:$Q$186,3,FALSE)+C73*VLOOKUP(K73,$I$161:$Q$186,3,FALSE)+C75*VLOOKUP(K75,$I$161:$Q$186,7,FALSE)+C77*VLOOKUP(K77,$I$161:$Q$186,7,FALSE)+C79*VLOOKUP(K79,$I$161:$Q$186,7,FALSE)","v":0},null,{"$f":"+E69*VLOOKUP(M69,$I$161:$Q$186,3,FALSE)+E71*VLOOKUP(M71,$I$161:$Q$186,3,FALSE)+E73*VLOOKUP(M73,$I$161:$Q$186,3,FALSE)+E75*VLOOKUP(M75,$I$161:$Q$186,7,FALSE)+E77*VLOOKUP(M77,$I$161:$Q$186,7,FALSE)+E79*VLOOKUP(M79,$I$161:$Q$186,7,FALSE)","v":0},null,{"$f":"+F69*VLOOKUP(O69,$I$161:$Q$186,3,FALSE)+F71*VLOOKUP(O71,$I$161:$Q$186,3,FALSE)+F73*VLOOKUP(O73,$I$161:$Q$186,3,FALSE)+F75*VLOOKUP(O75,$I$161:$Q$186,7,FALSE)+F77*VLOOKUP(O77,$I$161:$Q$186,7,FALSE)+F79*VLOOKUP(O79,$I$161:$Q$186,7,FALSE)","v":0},null,{"$f":"+G69*VLOOKUP(Q69,$I$161:$Q$186,3,FALSE)+G71*VLOOKUP(Q71,$I$161:$Q$186,3,FALSE)+G73*VLOOKUP(Q73,$I$161:$Q$186,3,FALSE)+G75*VLOOKUP(Q75,$I$161:$Q$186,7,FALSE)+G77*VLOOKUP(Q77,$I$161:$Q$186,7,FALSE)+G79*VLOOKUP(Q79,$I$161:$Q$186,7,FALSE)","v":0},null,{"$f":"+H69*VLOOKUP(S69,$I$161:$Q$186,3,FALSE)+H71*VLOOKUP(S71,$I$161:$Q$186,3,FALSE)+H73*VLOOKUP(S73,$I$161:$Q$186,3,FALSE)+H75*VLOOKUP(S75,$I$161:$Q$186,7,FALSE)+H77*VLOOKUP(S77,$I$161:$Q$186,7,FALSE)+H79*VLOOKUP(S79,$I$161:$Q$186,7,FALSE)","v":0}]
[]
[]
[null,null,"Business and STB Students Only"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["Masters Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[null,null,1]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[null,null,"Year 1",null,"Year 2","Year 3","Year 4","Year 5"]
["PhD Students (enter no. of students per term)",null,null,null,null,null,null,null,"Summer",null,"Summer 2014",null,"Summer 2015",null,"Summer 2016",null,"Summer 2017",null,"Summer 2018"]
[]
[null,null,null,null,null,null,null,null,"Fall",null,"Fall 2014",null,"Fall 2015",null,"Fall 2016",null,"Fall 2017",null,"Fall 2018"]
[]
[null,null,null,null,null,null,null,null,"Spring",null,"Spring 2015",null,"Spring 2016",null,"Spring 2017",null,"Spring 2018",null,"Spring 2019"]
[]
[9,null,"other"]
[]
[10,null,"other"]
[]
[11,null,"other"]
[]
[12,null,"other"]
[]
[null,null,"Total Other Direct Costs",null,null,null,null,null,null,null,{"$f":"SUM(K8:K22)+K42+K62+K81+K83+K85+K87","v":0},null,{"$f":"SUM(M8:M22)+M42+M62+M81+M83+M85+M87","v":0},null,{"$f":"SUM(O8:O22)+O42+O62+O81+O83+O85+O87","v":0},null,{"$f":"SUM(Q8:Q22)+Q42+Q62+Q81+Q83+Q85+Q87","v":0},null,{"$f":"SUM(S8:S22)+S42+S62+S81+S83+S85+S87","v":0},null,{"$f":"SUM(U8:U22)+U42+U62+U81+U83+U85+U87","v":0},null,{"$f":"SUM(W8:W22)+W42+W62+W81+W83+W85+W87","v":0},null,{"$f":"SUM(Y8:Y22)+Y42+Y62+Y81+Y83+Y85+Y87","v":0},null,{"$f":"SUM(AA8:AA22)+AA42+AA62+AA81+AA83+AA85+AA87","v":0},null,{"$f":"SUM(AC8:AC22)+AC42+AC62+AC81+AC83+AC85+AC87","v":0}]
[]
[]
[]
[null,null,"Total All Direct Costs",null,null,null,null,null,null,null,{"$f":"K89+'Salaries & Wages'!Z41+'Salaries & Wages'!Z75+'Equip-Travel-Participants'!K28+'Equip-Travel-Participants'!K38+'Equip-Travel-Participants'!K50","v":0},null,{"$f":"M89+'Salaries & Wages'!Z108+'Salaries & Wages'!Z143+'Equip-Travel-Participants'!M28+'Equip-Travel-Participants'!M38+'Equip-Travel-Participants'!M50","v":0},null,{"$f":"O89+'Salaries & Wages'!Z176+'Salaries & Wages'!Z211+'Equip-Travel-Participants'!O28+'Equip-Travel-Participants'!O38+'Equip-Travel-Participants'!O50","v":0},null,{"$f":"Q89+'Salaries & Wages'!Z244+'Salaries & Wages'!Z279+'Equip-Travel-Participants'!Q28+'Equip-Travel-Participants'!Q38+'Equip-Travel-Participants'!Q50","v":0},null,{"$f":"S89+'Salaries & Wages'!Z312+'Salaries & Wages'!Z347+'Equip-Travel-Participants'!S28+'Equip-Travel-Participants'!S38+'Equip-Travel-Participants'!S50","v":0},null,{"$f":"+U89+'Equip-Travel-Participants'!U50+'Equip-Travel-Participants'!U38+'Equip-Travel-Participants'!U28+'Salaries & Wages'!AF41+'Salaries & Wages'!AF75","v":0},null,{"$f":"+W89+'Equip-Travel-Participants'!W50+'Equip-Travel-Participants'!W38+'Equip-Travel-Participants'!W28+'Salaries & Wages'!AF108+'Salaries & Wages'!AF143","v":0},null,{"$f":"+Y89+'Equip-Travel-Participants'!Y50+'Equip-Travel-Participants'!Y38+'Equip-Travel-Participants'!Y28+'Salaries & Wages'!AF176+'Salaries & Wages'!AF211","v":0},null,{"$f":"+AA89+'Equip-Travel-Participants'!AA50+'Equip-Travel-Participants'!AA38+'Equip-Travel-Participants'!AA28+'Salaries & Wages'!AF279+'Salaries & Wages'!AF244","v":0},null,{"$f":"+AC89+'Equip-Travel-Participants'!AC50+'Equip-Travel-Participants'!AC38+'Equip-Travel-Participants'!AC28+'Salaries & Wages'!AF347+'Salaries & Wages'!AF312","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max",null,"esc. Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2-time"]
[null,null,null,null,null,null,null,null,"Fall 2014",null,999,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K101*$S$98","v":1040.9580000000001},null,{"$f":"M101*$S$98","v":2081.9160000000002},null,{"$f":"O101*$S$98","v":2081.9160000000002},null,{"$f":"Q101*$S$98","v":4162.79}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,1084.6782360000002,null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Fall 2017",null,1130.2347219120002,null,2260.4694438240003,null,2260.4694438240003,null,4519.8075215600002]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1177.7045802323041,null,2355.4091604646082,null,2355.4091604646082,null,4709.6394374655201]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1227.1681726020608,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1278.7092358513476,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1332.4150237571041,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Spring 2015",null,998.75,null,1998,null,1998,null,3995]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K110*$S$98","v":1040.6975},null,{"$f":"M110*$S$98","v":2081.9160000000002},null,{"$f":"O110*$S$98","v":2081.9160000000002},null,{"$f":"Q110*$S$98","v":4162.79}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1084.4067950000001,null,2169.3564720000004,null,2169.3564720000004,null,4337.6271800000004]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K112*$S$98","v":1129.95188039},null,{"$f":"M112*$S$98","v":2260.4694438240003},null,{"$f":"O112*$S$98","v":2260.4694438240003},null,{"$f":"Q112*$S$98","v":4519.8075215600002}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K113*$S$98","v":1177.40985936638},null,{"$f":"M113*$S$98","v":2355.4091604646082},null,{"$f":"O113*$S$98","v":2355.4091604646082},null,{"$f":"Q113*$S$98","v":4709.6394374655201}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1226.861073459768,null,2454.3363452041217,null,2454.3363452041217,null,4907.4442938390721]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1278.3892385450783,null,2557.4184717026951,null,2557.4184717026951,null,5113.5569541803134]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1332.0815865639718,null,2664.8300475142082,null,2664.8300475142082,null,5328.3263462558871]
[]
[null,null,null,null,null,null,null,null,"Summer 2014",null,555,null,1110,null,1110,null,2220]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K119*$S$98","v":578.31000000000006},null,{"$f":"M119*$S$98","v":1156.6200000000001},null,{"$f":"O119*$S$98","v":1156.6200000000001},null,{"$f":"Q119*$S$98","v":2313.2400000000002}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,602.59902000000011,null,1205.1980400000002,null,1205.1980400000002,null,2410.3960800000004]
[null,null,null,null,null,null,null,null,"Summer 2017",null,627.90817884000012,null,1255.8163576800002,null,1255.8163576800002,null,2511.6327153600005]
[null,null,null,null,null,null,null,null,"Summer 2018",null,654.28032235128012,null,1308.5606447025602,null,1308.5606447025602,null,2617.1212894051205]
[null,null,null,null,null,null,null,null,"Summer 2019",null,681.76009589003388,null,1363.5201917800678,null,1363.5201917800678,null,2727.0403835601355]
[null,null,null,null,null,null,null,null,"Summer 2020",null,710.39401991741533,null,1420.7880398348307,null,1420.7880398348307,null,2841.5760796696613]
[null,null,null,null,null,null,null,null,"Summer 2021",null,740.23056875394684,null,1480.4611375078937,null,1480.4611375078937,null,2960.9222750157874]
[]
[null,null,null,null,null,null,null,null,"Engineering & Architecture students"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2014",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K131*$S$98","v":1199.6025},null,{"$f":"M131*$S$98","v":2399.2049999999999},null,{"$f":"O131*$S$98","v":2399.2049999999999},null,{"$f":"Q131*$S$98","v":4798.41}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,{"$f":"K132*$S$98","v":1249.985805},null,{"$f":"M132*$S$98","v":2499.9716100000001},null,{"$f":"O132*$S$98","v":2499.9716100000001},null,{"$f":"Q132*$S$98","v":4999.9432200000001}]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K133*$S$98","v":1302.4852088100001},null,{"$f":"M133*$S$98","v":2604.9704176200003},null,{"$f":"O133*$S$98","v":2604.9704176200003},null,{"$f":"Q133*$S$98","v":5209.9408352400005}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1357.1895875800201,null,2714.3791751600402,null,2714.3791751600402,null,5428.7583503200804]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1151.25,null,2302.5,null,2302.5,null,4605]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K140*$S$98","v":1199.6025},null,{"$f":"M140*$S$98","v":2399.2049999999999},null,{"$f":"O140*$S$98","v":2399.2049999999999},null,{"$f":"Q140*$S$98","v":4798.41}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1249.985805,null,2499.9716100000001,null,2499.9716100000001,null,4999.9432200000001]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K142*$S$98","v":1302.4852088100001},null,{"$f":"M142*$S$98","v":2604.9704176200003},null,{"$f":"O142*$S$98","v":2604.9704176200003},null,{"$f":"Q142*$S$98","v":5209.9408352400005}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K143*$S$98","v":1357.1895875800201},null,{"$f":"M143*$S$98","v":2714.3791751600402},null,{"$f":"O143*$S$98","v":2714.3791751600402},null,{"$f":"Q143*$S$98","v":5428.7583503200804}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1414.1915502583811,null,2828.3831005167622,null,2828.3831005167622,null,5656.7662010335243]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1473.5875953692332,null,2947.1751907384664,null,2947.1751907384664,null,5894.3503814769329]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1535.478274374741,null,3070.956548749482,null,3070.956548749482,null,6141.9130974989639]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,640,null,1280,null,1280,null,2560]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K149*$S$98","v":666.88},null,{"$f":"M149*$S$98","v":1333.76},null,{"$f":"O149*$S$98","v":1333.76},null,{"$f":"Q149*$S$98","v":2667.52}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,694.88896,null,1389.77792,null,1389.77792,null,2779.55584]
[null,null,null,null,null,null,null,null,"Summer 2017",null,724.07429632000003,null,1448.1485926400001,null,1448.1485926400001,null,2896.2971852800001]
[null,null,null,null,null,null,null,null,"Summer 2018",null,754.48541676544005,null,1508.9708335308801,null,1508.9708335308801,null,3017.9416670617602]
[null,null,null,null,null,null,null,null,"Summer 2019",null,786.17380426958857,null,1572.3476085391771,null,1572.3476085391771,null,3144.6952170783543]
[null,null,null,null,null,null,null,null,"Summer 2020",null,819.19310404891132,null,1638.3862080978226,null,1638.3862080978226,null,3276.7724161956453]
[null,null,null,null,null,null,null,null,"Summer 2021",null,853.59921441896563,null,1707.1984288379313,null,1707.1984288379313,null,3414.3968576758625]
[]
[null,null,null,null,null,null,null,null,"Business & STB"]
[null,null,null,null,null,null,null,null,null,null,"Masters - Min",null,"Masters-Max",null,"PhD - Min",null,"PhD - Max"]
[]
[null,null,null,null,null,null,null,null,"Fall 2014",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Fall 2015",null,{"$f":"K161*$S$98","v":1263.9460000000001},null,{"$f":"M161*$S$98","v":2526.85},null,{"$f":"O161*$S$98","v":2526.85},null,{"$f":"Q161*$S$98","v":5053.7}]
[null,null,null,null,null,null,null,null,"Fall 2016",null,{"$f":"K162*$S$98","v":1317.0317320000001},null,{"$f":"M162*$S$98","v":2632.9776999999999},null,{"$f":"O162*$S$98","v":2632.9776999999999},null,{"$f":"Q162*$S$98","v":5265.9553999999998}]
[null,null,null,null,null,null,null,null,"Fall 2017",null,{"$f":"K163*$S$98","v":1372.3470647440001},null,{"$f":"M163*$S$98","v":2743.5627634000002},null,{"$f":"O163*$S$98","v":2743.5627634000002},null,{"$f":"Q163*$S$98","v":5487.1255268000004}]
[null,null,null,null,null,null,null,null,"Fall 2018",null,1429.9856414632482,null,2858.7923994628004,null,2858.7923994628004,null,5717.5847989256008]
[null,null,null,null,null,null,null,null,"Fall 2019",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Fall 2020",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Fall 2021",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Spring 2015",null,1213,null,2425,null,2425,null,4850]
[null,null,null,null,null,null,null,null,"Spring 2016",null,{"$f":"K170*$S$98","v":1263.9460000000001},null,{"$f":"M170*$S$98","v":2526.85},null,{"$f":"O170*$S$98","v":2526.85},null,{"$f":"Q170*$S$98","v":5053.7}]
[null,null,null,null,null,null,null,null,"Spring 2017",null,1317.0317320000001,null,2632.9776999999999,null,2632.9776999999999,null,5265.9553999999998]
[null,null,null,null,null,null,null,null,"Spring 2018",null,{"$f":"K172*$S$98","v":1372.3470647440001},null,{"$f":"M172*$S$98","v":2743.5627634000002},null,{"$f":"O172*$S$98","v":2743.5627634000002},null,{"$f":"Q172*$S$98","v":5487.1255268000004}]
[null,null,null,null,null,null,null,null,"Spring 2019",null,{"$f":"K173*$S$98","v":1429.9856414632482},null,{"$f":"M173*$S$98","v":2858.7923994628004},null,{"$f":"O173*$S$98","v":2858.7923994628004},null,{"$f":"Q173*$S$98","v":5717.5847989256008}]
[null,null,null,null,null,null,null,null,"Spring 2020",null,1490.0450384047047,null,2978.861680240238,null,2978.861680240238,null,5957.723360480476]
[null,null,null,null,null,null,null,null,"Spring 2021",null,1552.6269300177023,null,3103.9738708103282,null,3103.9738708103282,null,6207.9477416206564]
[null,null,null,null,null,null,null,null,"Spring 2022",null,1617.8372610784459,null,3234.3407733843619,null,3234.3407733843619,null,6468.6815467687238]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summer 2014",null,674,null,1348,null,1348,null,2695]
[null,null,null,null,null,null,null,null,"Summer 2015",null,{"$f":"K179*$S$98","v":702.30799999999999},null,{"$f":"M179*$S$98","v":1404.616},null,{"$f":"O179*$S$98","v":1404.616},null,{"$f":"Q179*$S$98","v":2808.19}]
[null,null,null,null,null,null,null,null,"Summer 2016",null,731.804936,null,1463.609872,null,1463.609872,null,2926.1339800000001]
[null,null,null,null,null,null,null,null,"Summer 2017",null,762.54074331200002,null,1525.081486624,null,1525.081486624,null,3049.03160716]
[null,null,null,null,null,null,null,null,"Summer 2018",null,794.56745453110409,null,1589.1349090622082,null,1589.1349090622082,null,3177.09093466072]
[null,null,null,null,null,null,null,null,"Summer 2019",null,827.93928762141047,null,1655.8785752428209,null,1655.8785752428209,null,3310.5287539164706]
[null,null,null,null,null,null,null,null,"Summer 2020",null,862.7127377015097,null,1725.4254754030194,null,1725.4254754030194,null,3449.5709615809624]
[null,null,null,null,null,null,null,null,"Summer 2021",null,898.94667268497312,null,1797.8933453699462,null,1797.8933453699462,null,3594.4529419673631]

{"sheet":"Subcontracts","index":4,"n_rows":74,"n_cols":35,"rows_kept":74,"cut":false,"hidden":false,"merged":[[45,2,45,8],[59,2,59,8],[55,2,55,8],[29,2,29,8],[20,2,20,8],[22,2,22,8],[30,2,30,8],[32,2,32,8],[24,2,24,8],[26,2,26,8],[52,2,52,8],[53,2,53,8],[34,2,34,8],[18,2,18,8],[44,2,44,8],[40,2,40,8],[42,2,42,8],[6,0,6,18],[1,0,1,18],[57,2,57,8],[28,2,28,8],[12,2,12,8],[14,2,14,8],[16,2,16,8],[8,0,8,18],[3,0,3,18],[48,2,48,8],[50,2,50,8],[4,0,4,18],[7,0,7,18],[5,0,5,18],[36,2,36,8],[38,2,38,8],[46,2,46,8]]}
[null,null,null,null,null,null,null,null,null,null,"Running Total for Cumulative Budget Amount = ",null,null,null,null,null,{"$f":"'Cumulative Budget'!AE65","v":0}]
["Worksheet for Project Budget - Subcontracts"]
[]
["For each subcontract, you will need to submit the following with the GoldSheet:"]
["1. Transmittal letter from the Sponsored Research Office"]
["2. Statement of Work"]
["3. Separate subcontractor's budget "]
["4. Budget Justification"]
["If you have questions regarding subcontracts, please contact your Pre-Award Administrator"]
[]
[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,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT SUB"]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"Cost-Sharing / Matching Funds",null,"TOTAL",null,"SUB TO IDC",null,"TO IDC"]
[]
[null,null,"Subcontract 1 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:S15)+SUM(K17:S17)","v":0},null,{"$f":"IF(AE15<25000,AE15,25000)","v":0},null,{"$f":"AE15-AG15","v":0}]
[]
[null,null,"Subcontract 1 - Indirect Costs"]
[]
[null,null,"Subcontract 2 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K19:S19)+SUM(K21:S21)","v":0},null,{"$f":"IF(AE19<25000,AE19,25000)","v":0},null,{"$f":"AE19-AG19","v":0}]
[]
[null,null,"Subcontract 2 - Indirect Costs"]
[]
[null,null,"Subcontract 3 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K23:S23)+SUM(K25:S25)","v":0},null,{"$f":"IF(AE23<25000,AE23,25000)","v":0},null,{"$f":"AE23-AG23","v":0}]
[]
[null,null,"Subcontract 3 - Indirect Costs"]
[]
[null,null,"Subcontract 4 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K27:S27)+SUM(K29:S29)","v":0},null,{"$f":"IF(AE27<25000,AE27,25000)","v":0},null,{"$f":"AE27-AG27","v":0}]
[]
[null,null,"Subcontract 4 - Indirect Costs"]
[]
[null,null,"Subcontract 5 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K31:S31)+SUM(K33:S33)","v":0},null,{"$f":"IF(AE31<25000,AE31,25000)","v":0},null,{"$f":"AE31-AG31","v":0}]
[]
[null,null,"Subcontract 5 - Indirect Costs"]
[]
[null,null,"Subcontract 6 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K35:S35)+SUM(K37:S37)","v":0},null,{"$f":"IF(AE35<25000,AE35,25000)","v":0},null,{"$f":"AE35-AG35","v":0}]
[]
[null,null,"Subcontract 6 - Indirect Costs"]
[]
[null,null,"Subcontract 7 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K39:S39)+SUM(K41:S41)","v":0},null,{"$f":"IF(AE39<25000,AE39,25000)","v":0},null,{"$f":"AE39-AG39","v":0}]
[]
[null,null,"Subcontract 7 - Indirect Costs"]
[]
[null,null,"Subcontract 8 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K43:S43)+SUM(K45:S45)","v":0},null,{"$f":"IF(AE43<25000,AE43,25000)","v":0},null,{"$f":"AE43-AG43","v":0}]
[]
[null,null,"Subcontract 8 - Indirect Costs"]
[]
[null,null,"Subcontract 9 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K47:S47)+SUM(K49:S49)","v":0},null,{"$f":"IF(AE47<25000,AE47,25000)","v":0},null,{"$f":"AE47-AG47","v":0}]
[]
[null,null,"Subcontract 9 - Indirect Costs"]
[]
[null,null,"Subcontract 10 - Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K51:S51)+SUM(K53:S53)","v":0},null,{"$f":"IF(AE51<25000,AE51,25000)","v":0},null,{"$f":"AE51-AG51","v":0}]
[]
[null,null,"Subcontract 10 - Indirect Costs"]
[]
[]
[null,null,"Total All Direct Costs",null,null,null,null,null,null,null,{"$f":"+K15+K19+K23+K27+K31+K35+K39+K43+K47+K51","v":0},null,{"$f":"+M15+M19+M23+M27+M31+M35+M39+M43+M47+M51","v":0},null,{"$f":"+O15+O19+O23+O27+O31+O35+O39+O43+O47+O51","v":0},null,{"$f":"+Q15+Q19+Q23+Q27+Q31+Q35+Q39+Q43+Q47+Q51","v":0},null,{"$f":"+S15+S19+S23+S27+S31+S35+S39+S43+S47+S51","v":0},null,{"$f":"+U15+U19+U23+U27+U31+U35+U39+U43+U47+U51","v":0},null,{"$f":"+W15+W19+W23+W27+W31+W35+W39+W43+W47+W51","v":0},null,{"$f":"+Y15+Y19+Y23+Y27+Y31+Y35+Y39+Y43+Y47+Y51","v":0},null,{"$f":"+AA15+AA19+AA23+AA27+AA31+AA35+AA39+AA43+AA47+AA51","v":0},null,{"$f":"+AC15+AC19+AC23+AC27+AC31+AC35+AC39+AC43+AC47+AC51","v":0},null,{"$f":"SUM(AE15:AE53)","v":0},null,{"$f":"SUM(AG15:AG53)","v":0},null,{"$f":"SUM(AI15:AI54)","v":0}]
[]
[null,null,"Total All Indirect Costs",null,null,null,null,null,null,null,{"$f":"+K17+K21+K25+K29+K33+K37+K41+K45+K49+K53","v":0},null,{"$f":"+M17+M21+M25+M29+M33+M37+M41+M45+M49+M53","v":0},null,{"$f":"+O17+O21+O25+O29+O33+O37+O41+O45+O49+O53","v":0},null,{"$f":"+Q17+Q21+Q25+Q29+Q33+Q37+Q41+Q45+Q49+Q53","v":0},null,{"$f":"+S17+S21+S25+S29+S33+S37+S41+S45+S49+S53","v":0},null,{"$f":"+U17+U21+U25+U29+U33+U37+U41+U45+U49+U53","v":0},null,{"$f":"+W17+W21+W25+W29+W33+W37+W41+W45+W49+W53","v":0},null,{"$f":"+Y17+Y21+Y25+Y29+Y33+Y37+Y41+Y45+Y49+Y53","v":0},null,{"$f":"+AA17+AA21+AA25+AA29+AA33+AA37+AA41+AA45+AA49+AA53","v":0},null,{"$f":"+AC17+AC21+AC25+AC29+AC33+AC37+AC41+AC45+AC49+AC53","v":0}]
[]
[null,null,"Total All Subcontract Costs",null,null,null,null,null,null,null,{"$f":"SUM(K56:K58)","v":0},null,{"$f":"SUM(M56:M58)","v":0},null,{"$f":"SUM(O56:O58)","v":0},null,{"$f":"SUM(Q56:Q58)","v":0},null,{"$f":"SUM(S56:S58)","v":0},null,{"$f":"SUM(U56:U58)","v":0},null,{"$f":"SUM(W56:W58)","v":0},null,{"$f":"SUM(Y56:Y58)","v":0},null,{"$f":"SUM(AA56:AA58)","v":0},null,{"$f":"SUM(AC56:AC58)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Base amount for MTDC",null,{"$f":"SUM(K65:K74)","v":0},null,{"$f":"SUM(M65:M74)","v":0},null,{"$f":"SUM(O65:O74)","v":0},null,{"$f":"SUM(Q65:Q74)","v":0},null,{"$f":"SUM(S65:S74)","v":0}]
[null,null,null,null,null,null,null,null,"sub1",null,{"$f":"+IF(K15+K17<25000,+K15+K17,25000)","v":0},null,{"$f":"+IF(M15+M17+SUM(K15:K17)<25000,+SUM(M15:M17),25000-K65)","v":0},null,{"$f":"+IF(O15+O17+SUM(K15:M17)<25000,+SUM(O15:O17),25000-SUM(K65:M65))","v":0},null,{"$f":"+IF(Q15+Q17+SUM(K15:O17)<25000,+SUM(Q15:Q17),25000-SUM(K65:O65))","v":0},null,{"$f":"+IF(S15+S17+SUM(K15:Q17)<25000,+SUM(S15:S17),25000-SUM(K65:Q65))","v":0}]
[null,null,null,null,null,null,null,null,"sub2",null,{"$f":"+IF(K19+K21<25000,+K19+K21,25000)","v":0},null,{"$f":"+IF(M19+M21+SUM(K19:K21)<25000,+SUM(M19:M21),25000-K66)","v":0},null,{"$f":"+IF(O19+O21+SUM(K19:M21)<25000,+SUM(O19:O21),25000-SUM(K66:M66))","v":0},null,{"$f":"+IF(Q19+Q21+SUM(K19:O21)<25000,+SUM(Q19:Q21),25000-SUM(K66:O66))","v":0},null,{"$f":"+IF(S19+S21+SUM(K19:Q21)<25000,+SUM(S19:S21),25000-SUM(K66:Q66))","v":0}]
[null,null,null,null,null,null,null,null,"sub3",null,{"$f":"+IF(K23+K25<25000,+K23+K25,25000)","v":0},null,{"$f":"+IF(M23+M25+SUM(K23:K25)<25000,+SUM(M23:M25),25000-K67)","v":0},null,{"$f":"+IF(O23+O25+SUM(K23:M25)<25000,+SUM(O23:O25),25000-SUM(K67:M67))","v":0},null,{"$f":"+IF(Q23+Q25+SUM(K23:O25)<25000,+SUM(Q23:Q25),25000-SUM(K67:O67))","v":0},null,{"$f":"+IF(S23+S25+SUM(K23:Q25)<25000,+SUM(S23:S25),25000-SUM(K67:Q67))","v":0}]
[null,null,null,null,null,null,null,null,"sub4",null,{"$f":"+IF(K27+K29<25000,+K27+K29,25000)","v":0},null,{"$f":"+IF(M27+M29+SUM(K27:K29)<25000,+SUM(M27:M29),25000-K68)","v":0},null,{"$f":"+IF(O27+O29+SUM(K27:M29)<25000,+SUM(O27:O29),25000-SUM(K68:M68))","v":0},null,{"$f":"+IF(Q27+Q29+SUM(K27:O29)<25000,+SUM(Q27:Q29),25000-SUM(K68:O68))","v":0},null,{"$f":"+IF(S27+S29+SUM(K27:Q29)<25000,+SUM(S27:S29),25000-SUM(K68:Q68))","v":0}]
[null,null,null,null,null,null,null,null,"sub5",null,{"$f":"+IF(K31+K33<25000,+K31+K33,25000)","v":0},null,{"$f":"+IF(M31+M33+SUM(K31:K33)<25000,+SUM(M31:M33),25000-K69)","v":0},null,{"$f":"+IF(O31+O33+SUM(K31:M33)<25000,+SUM(O31:O33),25000-SUM(K69:M69))","v":0},null,{"$f":"+IF(Q31+Q33+SUM(K31:O33)<25000,+SUM(Q31:Q33),25000-SUM(K69:O69))","v":0},null,{"$f":"+IF(S31+S33+SUM(K31:Q33)<25000,+SUM(S31:S33),25000-SUM(K69:Q69))","v":0}]
[null,null,null,null,null,null,null,null,"sub6",null,{"$f":"+IF(K35+K37<25000,+K35+K37,25000)","v":0},null,{"$f":"+IF(M35+M37+SUM(K35:K37)<25000,+SUM(M35:M37),25000-K70)","v":0},null,{"$f":"+IF(O35+O37+SUM(K35:M37)<25000,+SUM(O35:O37),25000-SUM(K70:M70))","v":0},null,{"$f":"+IF(Q35+Q37+SUM(K35:O37)<25000,+SUM(Q35:Q37),25000-SUM(K70:O70))","v":0},null,{"$f":"+IF(S35+S37+SUM(K35:Q37)<25000,+SUM(S35:S37),25000-SUM(K70:Q70))","v":0}]
[null,null,null,null,null,null,null,null,"sub7",null,{"$f":"+IF(K39+K41<25000,+K39+K41,25000)","v":0},null,{"$f":"+IF(M39+M41+SUM(K39:K41)<25000,+SUM(M39:M41),25000-K71)","v":0},null,{"$f":"+IF(O39+O41+SUM(K39:M41)<25000,+SUM(O39:O41),25000-SUM(K71:M71))","v":0},null,{"$f":"+IF(Q39+Q41+SUM(K39:O41)<25000,+SUM(Q39:Q41),25000-SUM(K71:O71))","v":0},null,{"$f":"+IF(S43+S45+SUM(K43:Q45)<25000,+SUM(S43:S45),25000-SUM(K71:Q71))","v":0}]
[null,null,null,null,null,null,null,null,"sub8",null,{"$f":"+IF(K43+K45<25000,+K43+K45,25000)","v":0},null,{"$f":"+IF(M43+M45+SUM(K43:K45)<25000,+SUM(M43:M45),25000-K72)","v":0},null,{"$f":"+IF(O43+O45+SUM(K43:M45)<25000,+SUM(O43:O45),25000-SUM(K72:M72))","v":0},null,{"$f":"+IF(Q43+Q45+SUM(K43:O45)<25000,+SUM(Q43:Q45),25000-SUM(K72:O72))","v":0},null,{"$f":"+IF(S43+S45+SUM(K43:Q45)<25000,+SUM(S43:S45),25000-SUM(K72:Q72))","v":0}]
[null,null,null,null,null,null,null,null,"sub9",null,{"$f":"+IF(K47+K49<25000,+K47+K49,25000)","v":0},null,{"$f":"+IF(M47+M49+SUM(K47:K49)<25000,+SUM(M47:M49),25000-K73)","v":0},null,{"$f":"+IF(O47+O49+SUM(K47:M49)<25000,+SUM(O47:O49),25000-SUM(K73:M73))","v":0},null,{"$f":"+IF(Q47+Q49+SUM(K47:O49)<25000,+SUM(Q47:Q49),25000-SUM(K73:O73))","v":0},null,{"$f":"+IF(S47+S49+SUM(K47:Q49)<25000,+SUM(S47:S49),25000-SUM(K73:Q73))","v":0}]
[null,null,null,null,null,null,null,null,"sub10",null,{"$f":"+IF(K51+K53<25000,+K51+K53,25000)","v":0},null,{"$f":"+IF(M51+M53+SUM(K51:K53)<25000,+SUM(M51:M53),25000-K74)","v":0},null,{"$f":"+IF(O51+O53+SUM(K51:M53)<25000,+SUM(O51:O53),25000-SUM(K74:M74))","v":0},null,{"$f":"+IF(Q51+Q53+SUM(K51:O53)<25000,+SUM(Q51:Q53),25000-SUM(K74:O74))","v":0},null,{"$f":"+IF(S51+S53+SUM(K51:Q53)<25000,+SUM(S51:S53),25000-SUM(K74:Q74))","v":0}]

{"sheet":"Cumulative Budget","index":5,"n_rows":84,"n_cols":35,"rows_kept":84,"cut":false,"hidden":false,"merged":[[71,2,72,8],[32,2,32,8],[66,2,66,8],[52,2,52,8],[36,2,36,8],[40,2,40,8],[50,2,50,5],[58,2,58,8],[54,2,54,8],[56,2,56,8],[62,2,62,6],[42,2,42,8],[44,2,44,8],[46,2,46,8],[14,2,14,8],[16,2,16,8],[69,7,69,8],[60,2,60,8],[64,2,64,8],[34,2,34,8],[48,2,48,8],[20,2,20,8],[38,2,38,8],[22,2,22,8],[18,2,18,8],[26,2,26,8],[28,2,28,8],[24,2,24,8],[30,2,30,8],[12,2,12,8],[0,0,0,26],[6,2,6,8],[8,2,8,8],[10,2,10,8],[4,2,4,8]]}
["Worksheet for Project Budget - Cumulative Budget"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year 1",null,"Year 1",null,"Year 2",null,"Year 2",null,"Year 3",null,"Year 3",null,"Year 4",null,"Year 4",null,"Year 5",null,"Year 5",null,"Total",null,"Total",null,"Total"]
[]
[null,null,null,null,null,null,null,null,null,null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Funds Requested",null,"Cost-Sharing / Matching Funds",null,"Cost of Project (all sources)"]
[]
["A",null,"Senior/Key Personnel",null,null,null,null,null,null,null,{"$f":"'Salaries & Wages'!Z41","v":0},null,{"$f":"'Salaries & Wages'!AF41","v":0},null,{"$f":"'Salaries & Wages'!Z108","v":0},null,{"$f":"'Salaries & Wages'!AF108","v":0},null,{"$f":"'Salaries & Wages'!Z176","v":0},null,{"$f":"'Salaries & Wages'!AF176","v":0},null,{"$f":"'Salaries & Wages'!Z244","v":0},null,{"$f":"'Salaries & Wages'!AF244","v":0},null,{"$f":"'Salaries & Wages'!Z312","v":0},null,{"$f":"'Salaries & Wages'!AF312","v":0},null,{"$f":"+K7+O7+S7+W7+AA7","v":0},null,{"$f":"+M7+Q7+U7+Y7+AC7","v":0},null,{"$f":"SUM(AE7:AH7)","v":0}]
[]
["B",null,"Other Personnel",null,null,null,null,null,null,null,{"$f":"'Salaries & Wages'!Z75","v":0},null,{"$f":"+'Salaries & Wages'!AF75","v":0},null,{"$f":"+'Salaries & Wages'!Z143","v":0},null,{"$f":"+'Salaries & Wages'!AF143","v":0},null,{"$f":"'Salaries & Wages'!Z211","v":0},null,{"$f":"'Salaries & Wages'!AF211","v":0},null,{"$f":"'Salaries & Wages'!Z279","v":0},null,{"$f":"'Salaries & Wages'!AF279","v":0},null,{"$f":"'Salaries & Wages'!Z347","v":0},null,{"$f":"'Salaries & Wages'!AF347","v":0},null,{"$f":"+K9+O9+S9+W9+AA9","v":0},null,{"$f":"+M9+Q9+U9+Y9+AC9","v":0},null,{"$f":"SUM(AE9:AH9)","v":0}]
[]
[" ",null,"Total Number other Personnel",null,null,null,null,null,null,null,{"$f":"+SUM('Salaries & Wages'!B47:B73)","v":0},null,null,null,{"$f":"+SUM('Salaries & Wages'!B114:B140)","v":0},null,null,null,{"$f":"+SUM('Salaries & Wages'!B182:B208)","v":0},null,null,null,{"$f":"+SUM('Salaries & Wages'!B250:B276)","v":0},null,null,null,{"$f":"+SUM('Salaries & Wages'!B318:B344)","v":0}]
[]
[" ",null,"Total Salary, Wages and Fringe Benefits",null,null,null,null,null,null,null,{"$f":"+K7+K9","v":0},null,{"$f":"+M7+M9","v":0},null,{"$f":"+O7+O9","v":0},null,{"$f":"+Q7+Q9","v":0},null,{"$f":"+S7+S9","v":0},null,{"$f":"+U7+U9","v":0},null,{"$f":"+W7+W9","v":0},null,{"$f":"+Y7+Y9","v":0},null,{"$f":"+AA7+AA9","v":0},null,{"$f":"+AC7+AC9","v":0},null,{"$f":"+K13+O13+S13+W13+AA13","v":0},null,{"$f":"+M13+Q13+U13+Y13+AC13","v":0},null,{"$f":"SUM(AE13:AH13)","v":0}]
[]
["C",null,"Equipment",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K28","v":0},null,{"$f":"+'Equip-Travel-Participants'!U28","v":0},null,{"$f":"+'Equip-Travel-Participants'!M28","v":0},null,{"$f":"+'Equip-Travel-Participants'!W28","v":0},null,{"$f":"+'Equip-Travel-Participants'!O28","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y28","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q28","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA28","v":0},null,{"$f":"+'Equip-Travel-Participants'!S28","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC28","v":0},null,{"$f":"+K15+O15+S15+W15+AA15","v":0},null,{"$f":"+M15+Q15+U15+Y15+AC15","v":0},null,{"$f":"SUM(AE15:AH15)","v":0}]
[]
["D",null,"Travel",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K38","v":0},null,{"$f":"+'Equip-Travel-Participants'!U38","v":0},null,{"$f":"+'Equip-Travel-Participants'!M38","v":0},null,{"$f":"+'Equip-Travel-Participants'!W38","v":0},null,{"$f":"+'Equip-Travel-Participants'!O38","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y38","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q38","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA38","v":0},null,{"$f":"+'Equip-Travel-Participants'!S38","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC38","v":0},null,{"$f":"+K17+O17+S17+W17+AA17","v":0},null,{"$f":"+M17+Q17+U17+Y17+AC17","v":0},null,{"$f":"SUM(AE17:AH17)","v":0}]
[]
[" ",null,"Domestic",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K34","v":0},null,{"$f":"+'Equip-Travel-Participants'!U34","v":0},null,{"$f":"+'Equip-Travel-Participants'!M34","v":0},null,{"$f":"+'Equip-Travel-Participants'!W34","v":0},null,{"$f":"+'Equip-Travel-Participants'!O34","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y34","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q34","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA34","v":0},null,{"$f":"+'Equip-Travel-Participants'!S34","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC34","v":0},null,{"$f":"+K19+O19+S19+W19+AA19","v":0},null,{"$f":"+M19+Q19+U19+Y19+AC19","v":0},null,{"$f":"SUM(AE19:AH19)","v":0}]
[]
[" ",null,"Foreign",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K36","v":0},null,{"$f":"+'Equip-Travel-Participants'!U36","v":0},null,{"$f":"+'Equip-Travel-Participants'!M36","v":0},null,{"$f":"+'Equip-Travel-Participants'!W36","v":0},null,{"$f":"+'Equip-Travel-Participants'!O36","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y36","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q36","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA36","v":0},null,{"$f":"+'Equip-Travel-Participants'!S36","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC36","v":0},null,{"$f":"+K21+O21+S21+W21+AA21","v":0},null,{"$f":"+M21+Q21+U21+Y21+AC21","v":0},null,{"$f":"SUM(AE21:AH21)","v":0}]
[]
["E",null,"Participant/Trainee Support Costs",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K50","v":0},null,{"$f":"+'Equip-Travel-Participants'!U50","v":0},null,{"$f":"+'Equip-Travel-Participants'!M50","v":0},null,{"$f":"+'Equip-Travel-Participants'!W50","v":0},null,{"$f":"+'Equip-Travel-Participants'!O50","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y50","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q50","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA50","v":0},null,{"$f":"+'Equip-Travel-Participants'!S50","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC50","v":0},null,{"$f":"+K23+O23+S23+W23+AA23","v":0},null,{"$f":"+M23+Q23+U23+Y23+AC23","v":0},null,{"$f":"SUM(AE23:AH23)","v":0}]
[]
[2,null,"Stipends",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K42","v":0},null,{"$f":"+'Equip-Travel-Participants'!U42","v":0},null,{"$f":"+'Equip-Travel-Participants'!M42","v":0},null,{"$f":"+'Equip-Travel-Participants'!W42","v":0},null,{"$f":"+'Equip-Travel-Participants'!O42","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y42","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q42","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA42","v":0},null,{"$f":"+'Equip-Travel-Participants'!S42","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC42","v":0},null,{"$f":"+K25+O25+S25+W25+AA25","v":0},null,{"$f":"+M25+Q25+U25+Y25+AC25","v":0},null,{"$f":"SUM(AE25:AH25)","v":0}]
[]
[3,null,"Travel",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K44","v":0},null,{"$f":"+'Equip-Travel-Participants'!U44","v":0},null,{"$f":"+'Equip-Travel-Participants'!M44","v":0},null,{"$f":"+'Equip-Travel-Participants'!W44","v":0},null,{"$f":"+'Equip-Travel-Participants'!O44","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y44","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q44","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA44","v":0},null,{"$f":"+'Equip-Travel-Participants'!S44","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC44","v":0},null,{"$f":"+K27+O27+S27+W27+AA27","v":0},null,{"$f":"+M27+Q27+U27+Y27+AC27","v":0},null,{"$f":"SUM(AE27:AH27)","v":0}]
[]
[4,null,"Subsistence",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K46","v":0},null,{"$f":"+'Equip-Travel-Participants'!U46","v":0},null,{"$f":"+'Equip-Travel-Participants'!M46","v":0},null,{"$f":"+'Equip-Travel-Participants'!W46","v":0},null,{"$f":"+'Equip-Travel-Participants'!O46","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y46","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q46","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA46","v":0},null,{"$f":"+'Equip-Travel-Participants'!S46","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC46","v":0},null,{"$f":"+K29+O29+S29+W29+AA29","v":0},null,{"$f":"+M29+Q29+U29+Y29+AC29","v":0},null,{"$f":"SUM(AE29:AH29)","v":0}]
[]
[5,null,"Other",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K48","v":0},null,{"$f":"+'Equip-Travel-Participants'!U48","v":0},null,{"$f":"+'Equip-Travel-Participants'!M48","v":0},null,{"$f":"+'Equip-Travel-Participants'!W48","v":0},null,{"$f":"+'Equip-Travel-Participants'!O48","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y48","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q48","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA48","v":0},null,{"$f":"+'Equip-Travel-Participants'!S48","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC48","v":0},null,{"$f":"+K31+O31+S31+W31+AA31","v":0},null,{"$f":"+M31+Q31+U31+Y31+AC31","v":0},null,{"$f":"SUM(AE31:AH31)","v":0}]
[]
[6,null,"Number of Participants/Trainees",null,null,null,null,null,null,null,{"$f":"+'Equip-Travel-Participants'!K52","v":0},null,{"$f":"+'Equip-Travel-Participants'!U52","v":0},null,{"$f":"+'Equip-Travel-Participants'!M52","v":0},null,{"$f":"+'Equip-Travel-Participants'!W52","v":0},null,{"$f":"+'Equip-Travel-Participants'!O52","v":0},null,{"$f":"+'Equip-Travel-Participants'!Y52","v":0},null,{"$f":"+'Equip-Travel-Participants'!Q52","v":0},null,{"$f":"+'Equip-Travel-Participants'!AA52","v":0},null,{"$f":"+'Equip-Travel-Participants'!S52","v":0},null,{"$f":"+'Equip-Travel-Participants'!AC52","v":0}]
[]
["F",null,"Other Direct Costs",null,null,null,null,null,null,null,{"$f":"SUM(K37:K59)","v":0},null,{"$f":"SUM(M37:M59)","v":0},null,{"$f":"SUM(O37:O59)","v":0},null,{"$f":"SUM(Q37:Q59)","v":0},null,{"$f":"SUM(S37:S59)","v":0},null,{"$f":"SUM(U37:U59)","v":0},null,{"$f":"SUM(W37:W59)","v":0},null,{"$f":"SUM(Y37:Y59)","v":0},null,{"$f":"SUM(AA37:AA59)","v":0},null,{"$f":"SUM(AC37:AC59)","v":0},null,{"$f":"+K35+O35+S35+W35+AA35","v":0},null,{"$f":"+M35+Q35+U35+Y35+AC35","v":0},null,{"$f":"SUM(AE35:AH35)","v":0}]
[]
[1,null,"Materials and Supplies",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K8","v":0},null,{"$f":"+'Other Direct'!U8","v":0},null,{"$f":"+'Other Direct'!M8","v":0},null,{"$f":"+'Other Direct'!W8","v":0},null,{"$f":"+'Other Direct'!O8","v":0},null,{"$f":"+'Other Direct'!Y8","v":0},null,{"$f":"+'Other Direct'!Q8","v":0},null,{"$f":"+'Other Direct'!AA8","v":0},null,{"$f":"+'Other Direct'!S8","v":0},null,{"$f":"+'Other Direct'!AC8","v":0},null,{"$f":"+K37+O37+S37+W37+AA37","v":0},null,{"$f":"+M37+Q37+U37+Y37+AC37","v":0},null,{"$f":"SUM(AE37:AH37)","v":0}]
[]
[2,null,"Publication Costs",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K10","v":0},null,{"$f":"+'Other Direct'!U10","v":0},null,{"$f":"+'Other Direct'!M10","v":0},null,{"$f":"+'Other Direct'!W10","v":0},null,{"$f":"+'Other Direct'!O10","v":0},null,{"$f":"+'Other Direct'!Y10","v":0},null,{"$f":"+'Other Direct'!Q10","v":0},null,{"$f":"+'Other Direct'!AA10","v":0},null,{"$f":"+'Other Direct'!S10","v":0},null,{"$f":"+'Other Direct'!AC10","v":0},null,{"$f":"+K39+O39+S39+W39+AA39","v":0},null,{"$f":"+M39+Q39+U39+Y39+AC39","v":0},null,{"$f":"SUM(AE39:AH39)","v":0}]
[]
[3,null,"Consultant Services",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K12","v":0},null,{"$f":"+'Other Direct'!U12","v":0},null,{"$f":"+'Other Direct'!M12","v":0},null,{"$f":"+'Other Direct'!W12","v":0},null,{"$f":"+'Other Direct'!O12","v":0},null,{"$f":"+'Other Direct'!Y12","v":0},null,{"$f":"+'Other Direct'!Q12","v":0},null,{"$f":"+'Other Direct'!AA12","v":0},null,{"$f":"+'Other Direct'!S12","v":0},null,{"$f":"+'Other Direct'!AC12","v":0},null,{"$f":"+K41+O41+S41+W41+AA41","v":0},null,{"$f":"+M41+Q41+U41+Y41+AC41","v":0},null,{"$f":"SUM(AE41:AH41)","v":0}]
[]
[4,null,"ADP/Computer Services",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K14","v":0},null,{"$f":"+'Other Direct'!U14","v":0},null,{"$f":"+'Other Direct'!M14","v":0},null,{"$f":"+'Other Direct'!W14","v":0},null,{"$f":"+'Other Direct'!O14","v":0},null,{"$f":"+'Other Direct'!Y14","v":0},null,{"$f":"+'Other Direct'!Q14","v":0},null,{"$f":"+'Other Direct'!AA14","v":0},null,{"$f":"+'Other Direct'!S14","v":0},null,{"$f":"+'Other Direct'!AC14","v":0},null,{"$f":"+K43+O43+S43+W43+AA43","v":0},null,{"$f":"+M43+Q43+U43+Y43+AC43","v":0},null,{"$f":"SUM(AE43:AH43)","v":0}]
[]
[5,null,"Subawards/Consortium/Contractual Costs",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K16","v":0},null,{"$f":"+'Other Direct'!U16","v":0},null,{"$f":"+'Other Direct'!M16","v":0},null,{"$f":"+'Other Direct'!W16","v":0},null,{"$f":"+'Other Direct'!O16","v":0},null,{"$f":"+'Other Direct'!Y16","v":0},null,{"$f":"+'Other Direct'!Q16","v":0},null,{"$f":"+'Other Direct'!AA16","v":0},null,{"$f":"+'Other Direct'!S16","v":0},null,{"$f":"+'Other Direct'!AC16","v":0},null,{"$f":"+K45+O45+S45+W45+AA45","v":0},null,{"$f":"+M45+Q45+U45+Y45+AC45","v":0},null,{"$f":"SUM(AE45:AH45)","v":0}]
[]
[6,null,"Equipment or Facility Rental/User Fees",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K18","v":0},null,{"$f":"+'Other Direct'!U18","v":0},null,{"$f":"+'Other Direct'!M18","v":0},null,{"$f":"+'Other Direct'!W18","v":0},null,{"$f":"+'Other Direct'!O18","v":0},null,{"$f":"+'Other Direct'!Y18","v":0},null,{"$f":"+'Other Direct'!Q18","v":0},null,{"$f":"+'Other Direct'!AA18","v":0},null,{"$f":"+'Other Direct'!S18","v":0},null,{"$f":"+'Other Direct'!AC18","v":0},null,{"$f":"+K47+O47+S47+W47+AA47","v":0},null,{"$f":"+M47+Q47+U47+Y47+AC47","v":0},null,{"$f":"SUM(AE47:AH47)","v":0}]
[]
[7,null,"Alterations and Renovations",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K20","v":0},null,{"$f":"+'Other Direct'!U20","v":0},null,{"$f":"+'Other Direct'!M20","v":0},null,{"$f":"+'Other Direct'!W20","v":0},null,{"$f":"+'Other Direct'!O20","v":0},null,{"$f":"+'Other Direct'!Y20","v":0},null,{"$f":"+'Other Direct'!Q20","v":0},null,{"$f":"+'Other Direct'!AA20","v":0},null,{"$f":"+'Other Direct'!S20","v":0},null,{"$f":"+'Other Direct'!AC20","v":0},null,{"$f":"+K49+O49+S49+W49+AA49","v":0},null,{"$f":"+M49+Q49+U49+Y49+AC49","v":0},null,{"$f":"SUM(AE49:AH49)","v":0}]
[]
[8,null,"Graduate Student Tuition",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K22+'Other Direct'!K42+'Other Direct'!K62","v":0},null,{"$f":"+'Other Direct'!U22+'Other Direct'!U42+'Other Direct'!U62","v":0},null,{"$f":"+'Other Direct'!M22+'Other Direct'!M42+'Other Direct'!M62","v":0},null,{"$f":"+'Other Direct'!W22+'Other Direct'!W42+ +'Other Direct'!W62","v":0},null,{"$f":"+'Other Direct'!O22+'Other Direct'!O42+'Other Direct'!O62","v":0},null,{"$f":"+'Other Direct'!Y22+'Other Direct'!Y42+'Other Direct'!Y62","v":0},null,{"$f":"+'Other Direct'!Q22+'Other Direct'!Q42+'Other Direct'!Q62","v":0},null,{"$f":"+'Other Direct'!AA22+'Other Direct'!AA42+'Other Direct'!AA62","v":0},null,{"$f":"+'Other Direct'!S22+'Other Direct'!S42+'Other Direct'!S62","v":0},null,{"$f":"+'Other Direct'!AC22+'Other Direct'!AC42+'Other Direct'!AC62","v":0},null,{"$f":"+K51+O51+S51+W51+AA51","v":0},null,{"$f":"+M51+Q51+U51+Y51+AC51","v":0},null,{"$f":"SUM(AE51:AH51)","v":0}]
[]
[9,null,{"$f":"+'Other Direct'!C81:I81","v":"other"},null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K81","v":0},null,{"$f":"+'Other Direct'!U81","v":0},null,{"$f":"+'Other Direct'!M81","v":0},null,{"$f":"+'Other Direct'!W81","v":0},null,{"$f":"+'Other Direct'!O81","v":0},null,{"$f":"+'Other Direct'!Y81","v":0},null,{"$f":"+'Other Direct'!Q81","v":0},null,{"$f":"+'Other Direct'!AA81","v":0},null,{"$f":"+'Other Direct'!S81","v":0},null,{"$f":"+'Other Direct'!AC81","v":0},null,{"$f":"+K53+O53+S53+W53+AA53","v":0},null,{"$f":"+M53+Q53+U53+Y53+AC53","v":0},null,{"$f":"SUM(AE53:AH53)","v":0}]
[]
[10,null,"other",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K83","v":0},null,{"$f":"+'Other Direct'!U83","v":0},null,{"$f":"+'Other Direct'!M83","v":0},null,{"$f":"+'Other Direct'!W83","v":0},null,{"$f":"+'Other Direct'!O83","v":0},null,{"$f":"+'Other Direct'!Y83","v":0},null,{"$f":"+'Other Direct'!Q83","v":0},null,{"$f":"+'Other Direct'!AA83","v":0},null,{"$f":"+'Other Direct'!S83","v":0},null,{"$f":"+'Other Direct'!AC83","v":0},null,{"$f":"+K55+O55+S55+W55+AA55","v":0},null,{"$f":"+M55+Q55+U55+Y55+AC55","v":0},null,{"$f":"SUM(AE55:AH55)","v":0}]
[]
[11,null,"other",null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K85","v":0},null,{"$f":"+'Other Direct'!U85","v":0},null,{"$f":"+'Other Direct'!M85","v":0},null,{"$f":"+'Other Direct'!W85","v":0},null,{"$f":"+'Other Direct'!O85","v":0},null,{"$f":"+'Other Direct'!Y85","v":0},null,{"$f":"+'Other Direct'!Q85","v":0},null,{"$f":"+'Other Direct'!AA85","v":0},null,{"$f":"+'Other Direct'!S85","v":0},null,{"$f":"+'Other Direct'!AC85","v":0},null,{"$f":"+K57+O57+S57+W57+AA57","v":0},null,{"$f":"+M57+Q57+U57+Y57+AC57","v":0},null,{"$f":"SUM(AE57:AH57)","v":0}]
[]
[12,null,{"$f":"+'Other Direct'!C87:I87","v":"other"},null,null,null,null,null,null,null,{"$f":"+'Other Direct'!K87","v":0},null,{"$f":"+'Other Direct'!U87","v":0},null,{"$f":"+'Other Direct'!M87","v":0},null,{"$f":"+'Other Direct'!W87","v":0},null,{"$f":"+'Other Direct'!O87","v":0},null,{"$f":"+'Other Direct'!Y87","v":0},null,{"$f":"+'Other Direct'!Q87","v":0},null,{"$f":"+'Other Direct'!AA87","v":0},null,{"$f":"+'Other Direct'!S87","v":0},null,{"$f":"+'Other Direct'!AC87","v":0},null,{"$f":"+K59+O59+S59+W59+AA59","v":0},null,{"$f":"+M59+Q59+U59+Y59+AC59","v":0},null,{"$f":"SUM(AE59:AH59)","v":0}]
[]
["G",null,"Direct Costs",null,null,null,null,null,null,null,{"$f":"+K13+K15+K17+K23+K35","v":0},null,{"$f":"+M13+M15+M17+M23+M35","v":0},null,{"$f":"+O13+O15+O17+O23+O35","v":0},null,{"$f":"+Q13+Q15+Q17+Q23+Q35","v":0},null,{"$f":"+S13+S15+S17+S23+S35","v":0},null,{"$f":"+U13+U15+U17+U23+U35","v":0},null,{"$f":"+W13+W15+W17+W23+W35","v":0},null,{"$f":"+Y13+Y15+Y17+Y23+Y35","v":0},null,{"$f":"+AA13+AA15+AA17+AA23+AA35","v":0},null,{"$f":"+AC13+AC15+AC17+AC23+AC35","v":0},null,{"$f":"+K61+O61+S61+W61+AA61","v":0},null,{"$f":"+M61+Q61+U61+Y61+AC61","v":0},null,{"$f":"SUM(AE61:AH61)","v":0}]
[]
["H",null,"Indirect Costs",null,null,null,null,"Rate",{"$f":"+K79","v":0.5},null,{"$f":"ROUND($K$79*SUM(K80:K84),0)","v":0},null,{"$f":"ROUND($K$79*SUM(M80:M84),0)","v":0},null,{"$f":"ROUND($O$79*SUM(O80:O84),0)","v":0},null,{"$f":"ROUND($O$79*SUM(Q80:Q84),0)","v":0},null,{"$f":"ROUND($S$79*SUM(S80:S84),0)","v":0},null,{"$f":"ROUND($S$79*SUM(U80:U84),0)","v":0},null,{"$f":"ROUND($W$79*SUM(W80:W84),0)","v":0},null,{"$f":"ROUND($W$79*SUM(Y80:Y84),0)","v":0},null,{"$f":"ROUND($AA$79*SUM(AA80:AA84),0)","v":0},null,{"$f":"ROUND($AA$79*SUM(AC80:AC84),0)","v":0},null,{"$f":"ROUND(K63+O63+S63+W63+AA63,0)","v":0},null,{"$f":"ROUND(M63+Q63+U63+Y63+AC63,0)","v":0},null,{"$f":"SUM(AE63:AH63)","v":0}]
[]
["I",null,"Total Direct and Indirect Costs",null,null,null,null,null,null,null,{"$f":"+K61+K63","v":0},null,{"$f":"+M61+M63","v":0},null,{"$f":"+O61+O63","v":0},null,{"$f":"+Q61+Q63","v":0},null,{"$f":"+S61+S63","v":0},null,{"$f":"+U61+U63","v":0},null,{"$f":"+W61+W63","v":0},null,{"$f":"+Y61+Y63","v":0},null,{"$f":"+AA61+AA63","v":0},null,{"$f":"+AC61+AC63","v":0},null,{"$f":"+K65+O65+S65+W65+AA65","v":0},null,{"$f":"+M65+Q65+U65+Y65+AC65","v":0},null,{"$f":"SUM(AE65:AH65)","v":0}]
[]
["J",null,"Fee",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,"Percent Requested",null,"Percent Cost-Shared"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AE65/AI65","v":{"$error":"#DIV/0!"}},null,{"$f":"+AG65/AI65","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AE69:AH69)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Base Amount > >",null,null,{"$f":"SUM(K80:K84)","v":0},null,{"$f":"SUM(M80:M84)","v":0},null,{"$f":"SUM(O80:O84)","v":0},null,{"$f":"SUM(Q80:Q84)","v":0},null,{"$f":"SUM(S80:S84)","v":0},null,{"$f":"SUM(U80:U84)","v":0},null,{"$f":"SUM(W80:W84)","v":0},null,{"$f":"SUM(Y80:Y84)","v":0},null,{"$f":"SUM(AA80:AA84)","v":0},null,{"$f":"SUM(AC80:AC84)","v":0}]
[]
[null,null,"If this is an NIH Modular application, this is your modular amount each year (must be in multiple of $25,000) >>"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K61-Subcontracts!K58","v":0},null,null,null,{"$f":"+O61-Subcontracts!M58","v":0},null,null,null,{"$f":"+S61-Subcontracts!O58","v":0},null,null,null,{"$f":"+W61-Subcontracts!Q58","v":0},null,null,null,{"$f":"+AA61-Subcontracts!S58","v":0},null,null,null,{"$f":"+AE61-Subcontracts!W58","v":0}]
[]
[null,null,null,null,null,null,null,null,"Salary",null,{"$f":"'Salaries & Wages'!Z78","v":0},null,null,null,{"$f":"'Salaries & Wages'!Z146","v":0},null,null,null,{"$f":"'Salaries & Wages'!Z214","v":0},null,null,null,{"$f":"'Salaries & Wages'!Z282","v":0},null,null,null,{"$f":"'Salaries & Wages'!Z350","v":0},null,null,null,{"$f":"'Salaries & Wages'!Z353","v":0}]
[null,null,null,null,null,null,null,null,"Fringe",null,{"$f":"'Salaries & Wages'!X78","v":0},null,null,null,{"$f":"'Salaries & Wages'!X146","v":0},null,null,null,{"$f":"'Salaries & Wages'!X214","v":0},null,null,null,{"$f":"'Salaries & Wages'!X282","v":0},null,null,null,{"$f":"'Salaries & Wages'!X350","v":0},null,null,null,{"$f":"'Salaries & Wages'!X353","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Rate",null,{"$f":"+'Start here'!$G$12","v":0.5},null,null,null,{"$f":"+'Start here'!$G$12","v":0.5},null,null,null,{"$f":"+'Start here'!$G$12","v":0.5},null,null,null,{"$f":"+'Start here'!$G$12","v":0.5},null,null,null,{"$f":"+'Start here'!$G$12","v":0.5}]
[null,null,null,null,null,null,null,null,"mtdc",null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +K61-K51-K15-K49-K45+Subcontracts!K64,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +M61-M51-M15-M49-M45,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +O61-O51-O15-O49-O45+Subcontracts!M64,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +Q61-Q51-Q15-Q49-Q45,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +S61-S51-S15-S49-S45+Subcontracts!O64,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +U61-U51-U15-U49-U45,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +W61-W51-W15-W49-W45+Subcontracts!Q64,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +Y61-Y51-Y15-Y49-Y45,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +AA61-AA51-AA15-AA49-AA45+Subcontracts!S64,\"false\")","v":0},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"mtdc\", +AC61-AC51-AC15-AC49-AC45,\"false\")","v":0}]
[null,null,null,null,null,null,null,null,"direct",null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +K61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +M61-M45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +O61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +Q61-Q45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +S61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +U61-U45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +W61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +Y61-Y45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +AA61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"direct\", +AC61-AC45,\"false\")","v":"false"}]
[null,null,null,null,null,null,null,null,"stipend-REU",null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +K27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +M27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +O27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +Q27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +S27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +U27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +W27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +Y27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +AA27,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"stipend\", +AC27,\"false\")","v":"false"}]
[null,null,null,null,null,null,null,null,"participant",null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +K61-K51-K15-K23-K49-K45+Subcontracts!K64,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +M61-M51-M15-M23-M49-M45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +O61-O51-O15-O23-O49-O45+Subcontracts!M64,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +Q61-Q51-Q15-Q23-Q49-Q45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +S61-S51-S15-S23-S49-S45+Subcontracts!O64,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +U61-U51-U15-U23-U49-U45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +W61-W51-W15-W23-W49-W45+Subcontracts!Q64,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +Y61-Y51-Y15-Y23-Y49-Y45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +AA61-AA51-AA15-AA23-AA49-AA45+Subcontracts!S64,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"participant\", +AC61-AC51-AC15-AC23-AC49-AC45,\"false\")","v":"false"}]
[null,null,null,null,null,null,null,null,"other",null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +K61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +M61-M45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +O61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +Q61-Q45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +S61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +U61-U45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +W61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +Y61-Y45,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +AA61,\"false\")","v":"false"},null,{"$f":"IF(VLOOKUP('Start here'!$E$12,'Start here'!$E$18:$G$32,3,FALSE)=\"other\", +AC61-AC45,\"false\")","v":"false"}]

{"sheet":"BA Upload","index":6,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Sponsor:",{"$f":"'Start here'!D6","v":0}]
["Title: ",{"$f":"'Start here'!D8","v":0}]
["PI Name: ",{"$f":"'Start here'!D4","v":0}]
["Period of Performance:",{"$f":"'Start here'!E10","v":"00:00:00"},{"$f":"'Start here'!G10","v":"00:00:00"}]
["GoldSheet Number:"]
["Account Number:"]
[]
["Budget Categories","Budget Code","Amount"]
["Salary/Hourly","0108",{"$f":"ROUND('Salaries & Wages'!Z353,0)","v":0}]
["Payroll Benefits","0130",{"$f":"ROUND('Salaries & Wages'!X353,0)","v":0}]
["Equipment","0710",{"$f":"ROUND('Cumulative Budget'!AE15,0)","v":0}]
["Travel Domestic","0215",{"$f":"ROUND('Cumulative Budget'!AE19+'Cumulative Budget'!AE27+'Cumulative Budget'!AE29,0)","v":0}]
["Travel Foreign","0216",{"$f":"ROUND('Cumulative Budget'!AE21,0)","v":0}]
["Student Tuition","0610",{"$f":"ROUND('Cumulative Budget'!AE51,0)","v":0}]
["Supplies","0410",{"$f":"ROUND('Cumulative Budget'!AE37,0)","v":0}]
["Subcontracts"]
["Subject to IDC","0396",{"$f":"ROUND(Subcontracts!AG56,0)","v":0}]
["Not Subejct to IDC","0376",{"$f":"ROUND(Subcontracts!AI56,0)","v":0}]
["Other Direct Costs"]
["Telecom Charges","0340",0]
["Computer Usage","0353",{"$f":"ROUND('Cumulative Budget'!AE43,0)","v":0}]
["Printing/Copying","0373",{"$f":"ROUND('Cumulative Budget'!AE39,0)","v":0}]
["Services/Honoraria","0302",{"$f":"ROUND('Cumulative Budget'!AE41+'Cumulative Budget'!AE25,0)","v":0}]
["Postage","0379",0]
["Other  ","0630",{"$f":"ROUND('Cumulative Budget'!AE31+'Cumulative Budget'!AE47+'Cumulative Budget'!AE53+'Cumulative Budget'!AE55+'Cumulative Budget'!AE57+'Cumulative Budget'!AE59,0)","v":0}]
["Total Direct Costs",null,{"$f":"SUM(C9:C25)","v":0}]
["Indirect Costs","0642",{"$f":"ROUND('Cumulative Budget'!AE63,0)","v":0}]
["Total Costs",null,{"$f":"SUM(C26:C27)","v":0}]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}