{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Year 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":61,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Year 1","index":0,"n_rows":200,"n_cols":14,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 01/2020"]
[]
["NAME","Year",1,null,"GRANT",{"$f":"C8","v":0},null,null,null,"Direct",{"$f":"D198","v":0},null,"Target",{"$f":"H7","v":0}]
[{"$f":"C7","v":0},null,{"$f":"C9","v":"00:00:00"},"to",{"$f":"IF(C4=0,0,DATE(YEAR(C4)+1,MONTH(C4),DAY(C4)-1))","v":"00:00:00"},null,null,null,null,"Direct & Indirect",{"$f":"D200","v":0},null,"Difference",{"$f":"IF(H8=0,0,IF(H8=1,N3-K3,N3-K4))","v":0}]
["Grant Information"]
[]
[null,"PI Name:",null,null,null,null,"Budget Cap:",null,null,"Cap Types"]
[null,"Grant Title:",null,null,null,null,"Cap type:",null,null,"Type 1","Direct only"]
[null,"Project start date:",null,null,null,null,null,null,null,"Type 2","Direct and Indirect costs"]
[]
["PERSONNEL (01,07)"]
[null,"Categories and subtotals are for the SF 424 form.  Do not change titles unless you are using a different form."]
["Key Personnel"]
["Name","Position","Monthly Salary","Months","%","Benefit Type","Year 1 Inflation","Other Yrs Inflation",null,"Base","Cal. Months","Req. Salary","Fringe ","Total"]
[null,null,null,null,null,1,0.04,0.02,null,{"$f":"ROUND((C15*12)*(1+G15),0)*((1+H15)^($C$3-1))","v":0},{"$f":"E15*D15","v":0},{"$f":"IF($M$58=\"No\",ROUND(J15*(K15/12),0),IF(J15>$M$59,ROUND($M$59*(K15/12),0),ROUND(J15*(K15/12),0)))","v":0},{"$f":"IF(ISBLANK(F15),0,ROUND(INDEX($D$58:$D$63,F15)*L15/100,0))","v":0},{"$f":"L15+M15","v":0}]
[null,null,null,null,null,1,0.04,0.02,null,0,0,0,0,0]
[null,null,null,null,null,1,0.04,0.02,null,0,0,0,0,0]
[null,null,null,null,null,1,0.04,0.02,null,0,0,0,0,0]
[null,null,null,null,null,1,0.04,0.02,null,0,0,0,0,0]
[null,null,null,null,null,1,0.04,0.02,null,0,0,0,0,0]
[" ",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K15:K20)","v":0},{"$f":"SUM(L15:L20)","v":0},{"$f":"SUM(M15:M20)","v":0},{"$f":"SUM(N15:N20)","v":0}]
["Post-Doc Associates"]
[]
[null,null,null,null,null,6,0.04,0.02,null,{"$f":"ROUND((C24*12)*(1+G24),0)*((1+H24)^($C$3-1))","v":0},{"$f":"E24*D24","v":0},{"$f":"IF($M$58=\"No\",ROUND(J24*(K24/12),0),IF(J24>$M$59,ROUND($M$59*(K24/12),0),ROUND(J24*(K24/12),0)))","v":0},{"$f":"IF(ISBLANK(F24),0,ROUND(INDEX($D$58:$D$63,F24)*L24/100,0))","v":0},{"$f":"L24+M24","v":0}]
[null,null,null,null,null,6,0.04,0.02,null,{"$f":"ROUND((C25*12)*(1+G25),0)*((1+H25)^($C$3-1))","v":0},{"$f":"E25*D25","v":0},{"$f":"IF($M$58=\"No\",ROUND(J25*(K25/12),0),IF(J25>$M$59,ROUND($M$59*(K25/12),0),ROUND(J25*(K25/12),0)))","v":0},{"$f":"IF(ISBLANK(F25),0,ROUND(INDEX($D$58:$D$63,F25)*L25/100,0))","v":0},{"$f":"L25+M25","v":0}]
[null,null,null,null,null,6,0.04,0.02,null,{"$f":"ROUND((C26*12)*(1+G26),0)*((1+H26)^($C$3-1))","v":0},{"$f":"E26*D26","v":0},{"$f":"IF($M$58=\"No\",ROUND(J26*(K26/12),0),IF(J26>$M$59,ROUND($M$59*(K26/12),0),ROUND(J26*(K26/12),0)))","v":0},{"$f":"IF(ISBLANK(F26),0,ROUND(INDEX($D$58:$D$63,F26)*L26/100,0))","v":0},{"$f":"L26+M26","v":0}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K24:K26)","v":0},{"$f":"SUM(L24:L26)","v":0},{"$f":"SUM(M24:M26)","v":0},{"$f":"SUM(N24:N26)","v":0}]
["TA/RA/SA"]
["Name","Position","Schedule (1 or 2)","Months","%","Grad Type","Year 1 Inflation","Other Yrs Inflation","Tuition","Base","Cal. Months","Req. Salary","Fringe ","Total"]
[null,null,null,null,null,1,0.04,0.02,{"$f":"IF(C30=0,0,IF(C30=2,0,(INDEX($J$59:$J$63,F30))*(K30*2)))","v":0},{"$f":"IF(C30=0,0,(IF(C30=1,INDEX($H$59:$H$63,F30),INDEX($I$59:$I$63,F30)))*(1+G30)*((1+H30)^($C$3-1)))","v":0},{"$f":"E30*D30","v":0},{"$f":"IF($M$58=\"No\",ROUND(J30*(K30/12),0),IF(J30>$M$59,ROUND($M$59*(K30/12),0),ROUND(J30*(K30/12),0)))","v":0},{"$f":"IF(ISBLANK(F30),0,ROUND(($D$61/100)*L30,0))","v":0},{"$f":"L30+M30","v":0}]
[null,null,null,null,null,1,0.04,0.02,{"$f":"IF(C31=0,0,IF(C31=2,0,(INDEX($J$59:$J$63,F31))*(K31*2)))","v":0},{"$f":"IF(C31=0,0,(IF(C31=1,INDEX($H$59:$H$63,F31),INDEX($I$59:$I$63,F31)))*(1+G31)*((1+H31)^($C$3-1)))","v":0},{"$f":"E31*D31","v":0},{"$f":"IF($M$58=\"No\",ROUND(J31*(K31/12),0),IF(J31>$M$59,ROUND($M$59*(K31/12),0),ROUND(J31*(K31/12),0)))","v":0},{"$f":"IF(ISBLANK(F31),0,ROUND(($D$61/100)*L31,0))","v":0},{"$f":"L31+M31","v":0}]
[null,null,null,null,null,1,0.04,0.02,{"$f":"IF(C32=0,0,IF(C32=2,0,(INDEX($J$59:$J$63,F32))*(K32*2)))","v":0},{"$f":"IF(C32=0,0,(IF(C32=1,INDEX($H$59:$H$63,F32),INDEX($I$59:$I$63,F32)))*(1+G32)*((1+H32)^($C$3-1)))","v":0},{"$f":"E32*D32","v":0},{"$f":"IF($M$58=\"No\",ROUND(J32*(K32/12),0),IF(J32>$M$59,ROUND($M$59*(K32/12),0),ROUND(J32*(K32/12),0)))","v":0},{"$f":"IF(ISBLANK(F32),0,ROUND(($D$61/100)*L32,0))","v":0},{"$f":"L32+M32","v":0}]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I30:I32)","v":0},null,{"$f":"SUM(K30:K32)","v":0},{"$f":"SUM(L30:L32)","v":0},{"$f":"SUM(M30:M32)","v":0},{"$f":"SUM(N30:N32)","v":0}]
["Undergraduates"]
[]
[null,null,null,null,null,3,0.04,0.02,null,{"$f":"ROUND((C36*12)*(1+G36),0)*((1+H36)^($C$3-1))","v":0},{"$f":"E36*D36","v":0},{"$f":"IF($M$58=\"No\",ROUND(J36*(K36/12),0),IF(J36>$M$59,ROUND($M$59*(K36/12),0),ROUND(J36*(K36/12),0)))","v":0},{"$f":"IF(ISBLANK(F36),0,ROUND(INDEX($D$58:$D$63,F36)*L36/100,0))","v":0},{"$f":"L36+M36","v":0}]
[null,null,null,null,null,3,0.04,0.02,null,{"$f":"ROUND((C37*12)*(1+G37),0)*((1+H37)^($C$3-1))","v":0},{"$f":"E37*D37","v":0},{"$f":"IF($M$58=\"No\",ROUND(J37*(K37/12),0),IF(J37>$M$59,ROUND($M$59*(K37/12),0),ROUND(J37*(K37/12),0)))","v":0},{"$f":"IF(ISBLANK(F37),0,ROUND(INDEX($D$58:$D$63,F37)*L37/100,0))","v":0},{"$f":"L37+M37","v":0}]
[null,null,null,null,null,3,0.04,0.02,null,{"$f":"ROUND((C38*12)*(1+G38),0)*((1+H38)^($C$3-1))","v":0},{"$f":"E38*D38","v":0},{"$f":"IF($M$58=\"No\",ROUND(J38*(K38/12),0),IF(J38>$M$59,ROUND($M$59*(K38/12),0),ROUND(J38*(K38/12),0)))","v":0},{"$f":"IF(ISBLANK(F38),0,ROUND(INDEX($D$58:$D$63,F38)*L38/100,0))","v":0},{"$f":"L38+M38","v":0}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K36:K38)","v":0},{"$f":"SUM(L36:L38)","v":0},{"$f":"SUM(M36:M38)","v":0},{"$f":"SUM(N36:N38)","v":0}]
["Classified Staff"]
[]
[null,null,null,null,null,2,0.04,0.02,null,{"$f":"ROUND((C42*12)*(1+G42),0)*((1+H42)^($C$3-1))","v":0},{"$f":"E42*D42","v":0},{"$f":"IF($M$58=\"No\",ROUND(J42*(K42/12),0),IF(J42>$M$59,ROUND($M$59*(K42/12),0),ROUND(J42*(K42/12),0)))","v":0},{"$f":"IF(ISBLANK(F42),0,ROUND(INDEX($D$58:$D$63,F42)*L42/100,0))","v":0},{"$f":"L42+M42","v":0}]
[null,null,null,null,null,2,0.04,0.02,null,{"$f":"ROUND((C43*12)*(1+G43),0)*((1+H43)^($C$3-1))","v":0},{"$f":"E43*D43","v":0},{"$f":"IF($M$58=\"No\",ROUND(J43*(K43/12),0),IF(J43>$M$59,ROUND($M$59*(K43/12),0),ROUND(J43*(K43/12),0)))","v":0},{"$f":"IF(ISBLANK(F43),0,ROUND(INDEX($D$58:$D$63,F43)*L43/100,0))","v":0},{"$f":"L43+M43","v":0}]
[null,null,null,null,null,2,0.04,0.02,null,{"$f":"ROUND((C44*12)*(1+G44),0)*((1+H44)^($C$3-1))","v":0},{"$f":"E44*D44","v":0},{"$f":"IF($M$58=\"No\",ROUND(J44*(K44/12),0),IF(J44>$M$59,ROUND($M$59*(K44/12),0),ROUND(J44*(K44/12),0)))","v":0},{"$f":"IF(ISBLANK(F44),0,ROUND(INDEX($D$58:$D$63,F44)*L44/100,0))","v":0},{"$f":"L44+M44","v":0}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K42:K44)","v":0},{"$f":"SUM(L42:L44)","v":0},{"$f":"SUM(M42:M44)","v":0},{"$f":"SUM(N42:N44)","v":0}]
["Professional Staff"]
[]
[null,null,null,null,null,5,0.04,0.02,null,{"$f":"ROUND((C48*12)*(1+G48),0)*((1+H48)^($C$3-1))","v":0},{"$f":"E48*D48","v":0},{"$f":"IF($M$58=\"No\",ROUND(J48*(K48/12),0),IF(J48>$M$59,ROUND($M$59*(K48/12),0),ROUND(J48*(K48/12),0)))","v":0},{"$f":"IF(ISBLANK(F48),0,ROUND(INDEX($D$58:$D$63,F48)*L48/100,0))","v":0},{"$f":"L48+M48","v":0}]
[null,null,null,null,null,5,0.04,0.02,null,{"$f":"ROUND((C49*12)*(1+G49),0)*((1+H49)^($C$3-1))","v":0},{"$f":"E49*D49","v":0},{"$f":"IF($M$58=\"No\",ROUND(J49*(K49/12),0),IF(J49>$M$59,ROUND($M$59*(K49/12),0),ROUND(J49*(K49/12),0)))","v":0},{"$f":"IF(ISBLANK(F49),0,ROUND(INDEX($D$58:$D$63,F49)*L49/100,0))","v":0},{"$f":"L49+M49","v":0}]
[null,null,null,null,null,5,0.04,0.02,null,{"$f":"ROUND((C50*12)*(1+G50),0)*((1+H50)^($C$3-1))","v":0},{"$f":"E50*D50","v":0},{"$f":"IF($M$58=\"No\",ROUND(J50*(K50/12),0),IF(J50>$M$59,ROUND($M$59*(K50/12),0),ROUND(J50*(K50/12),0)))","v":0},{"$f":"IF(ISBLANK(F50),0,ROUND(INDEX($D$58:$D$63,F50)*L50/100,0))","v":0},{"$f":"L50+M50","v":0}]
[null,null,null,null,null,5,0.04,0.02,null,{"$f":"ROUND((C51*12)*(1+G51),0)*((1+H51)^($C$3-1))","v":0},{"$f":"E51*D51","v":0},{"$f":"IF($M$58=\"No\",ROUND(J51*(K51/12),0),IF(J51>$M$59,ROUND($M$59*(K51/12),0),ROUND(J51*(K51/12),0)))","v":0},{"$f":"IF(ISBLANK(F51),0,ROUND(INDEX($D$58:$D$63,F51)*L51/100,0))","v":0},{"$f":"L51+M51","v":0}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K48:K51)","v":0},{"$f":"SUM(L48:L51)","v":0},{"$f":"SUM(M48:M51)","v":0},{"$f":"SUM(N48:N51)","v":0}]
["Name","Position","Monthly Salary","Months","%","Benefit Type","Year 1 Inflation","Other Yrs Inflation",null,"Base","Cal. Months","Req. Salary","Fringe ","Total"]
[]
["TOTAL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L21,L27,L33,L39,L45,L52)","v":0},{"$f":"SUM(M21,M27,M33,M39,M45,M52)","v":0},{"$f":"SUM(N21,N27,N33,N39,N45,N52)","v":0}]
[]
[null,"Benefits","UPDATED 7/21",null,null,"TA/RA/SA types  *UPDATED 1/27/2020",null,null,null,null,null,"NIH Salary Cap"]
[null,"Type 1","Faculty",23.2,null,null,"Student Level","Schedule 1","Schedule 2","Tuition Rate",null,"Apply?:","Yes"]
[null,"Type 2","Class. Staff",37.299999999999997,null,"Type 1","Master",{"$f":"2388*2*12","v":57312},{"$f":"4100*2*12","v":98400},{"$f":"9369/3","v":3123},null,"Cap:",199300]
[null,"Type 3","Hourly",20.399999999999999,null,"Type 2","DNP level I",{"$f":"2567*2*12","v":61608},{"$f":"4279*2*12","v":102696},{"$f":"9369/3","v":3123}]
[null,"Type 4","TA/RA/SA",21.6,null,"Type 3","DNP level II",{"$f":"2758*2*12","v":66192},{"$f":"4470*2*12","v":107280},{"$f":"9369/3","v":3123},null,null,"updated 2/1/2021"]
[null,"Type 5","Prof. Staff",29.4,null,"Type 4","PhD level I",{"$f":"2567*2*12","v":61608},{"$f":"4279*2*12","v":102696},{"$f":"(6431)/3","v":2143.6666666666665}]
[null,"Type 6"," Post-doc",16.3,null,"Type 5","PhD level II",{"$f":"2758*2*12","v":66192},{"$f":"4470*2*12","v":107280},{"$f":"(6431)/3","v":2143.6666666666665}]
[]
["CONSULTANT (02)"]
[]
["Name","Days/Hours","Rate","Fee","Travel","PerDiem","Total"]
[null,null,null,null,null,null,{"$f":"SUM(D68:F68)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D69:F69)","v":0}]
[null,null,null,{"$f":"B70*C70","v":0},null,null,{"$f":"SUM(D70:F70)","v":0}]
[" ",null,null,{"$f":"B71*C71","v":0},null,"Subtotal",{"$f":"SUM(G68:G70)","v":0}]
[]
["Human Subject Payments",null,null,"#","Amount",null,"Total "]
[null,null,null,null,null,null,{"$f":"D74*E74","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D76*E76","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D78*E78","v":0}]
[]
["TOTAL",null,null,null,null,"subtotal",{"$f":"SUM(G74:G79)","v":0},null,null,null,null,null,null,{"$f":"SUM(G71,G80)","v":0}]
[]
["OTHER (03)"]
[]
["Item","Amount",null,"Item","Amount",null,"Off-Campus Costs"]
["Telecomm",null,null,"Advertise"]
["Long dist.",null,null,"Subscripts",null,null,"Item","Amount"]
["Hardware",null,null,"Transcribe",null,null,"Rent"]
["Other",null,null,"UW Service Fee"]
["Mailing",null,null,"Conference Fee"]
["Letters",null,null,"Maintenance"]
["Packages",null,null,"Lab Fees"]
["Mail Svcs",null,null,"Computer Svcs"]
["Publishing",null,null,"IRB Fees (Non-UW)"]
["Copying"]
["Printing"]
[]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B85:B96,E85:E96,H87:H96)","v":0}]
[]
["TRAVEL (04)"]
[]
["Name","Dest.","# of trips","Air Travel","PerDiem Rate","Days","Per Diem Total","Misc ","Total"]
[null,null,null,null,null,null,{"$f":"E102*F102","v":0},null,{"$f":"(H102+G102+D102)*C102","v":0}]
["Foreign",null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,"Foreign Subtotal",null,null,null,{"$f":"SUM(I102:I108)","v":0}]
["Domestic, Canada, Mexico",null,null,null,null,null,{"$f":"E110*F110","v":0},null,{"$f":"(D110+G110+H110)*C110","v":0}]
[null,null,null,null,null,null,{"$f":"E111*F111","v":0},null,{"$f":"(D111+G111+H111)*C111","v":0}]
[null,null,null,null,null,null,{"$f":"E112*F112","v":0},null,{"$f":"(D112+G112+H112)*C112","v":0}]
[null,null,null,null,null,null,{"$f":"E113*F113","v":0},null,{"$f":"(D113+G113+H113)*C113","v":0}]
[null,null,null,null,null,null,{"$f":"E114*F114","v":0},null,{"$f":"(D114+G114+H114)*C114","v":0}]
["Local",null,"# Trips","AvgMiles","Rate/Mi.","Misc. "]
[null,null,null,null,0.56000000000000005,null,null,null,{"$f":"ROUND((C116*D116*E116)+F116,0)","v":0}]
[null,null,null,null,0.56000000000000005,null,null,null,{"$f":"ROUND((C117*D117*E117)+F117,0)","v":0}]
[null,null,null,null,0.56000000000000005,null,null,null,{"$f":"ROUND((C118*D118*E118)+F118,0)","v":0}]
[null,null,null,null,"Domestic Subtotal",null,null,null,{"$f":"SUM(I111:I118)","v":0}]
[null,null,null,null,"*updated 1/13/2021"]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I109+I119","v":0}]
[]
["SUPPLIES (05) & EQUIPMENT (06)"]
["Items under $2000",null,null,null,"DO NOT USE THIS SECTION",null,null,null,"Items over $5000"]
[null,"Item","Amount",null,null,"Item","Amount",null,null,"Item","Amount"]
[null,"Office",null,null,null,"Computers"]
[null,"Books",null,null,null,"Laptops"]
[null,"Reprints",null,null,null,"Servers"]
[null,"Blank Media"]
[null,"Chemicals"]
[null,"Bio-Assays"]
[null,"Vivarium"]
[null,"Computers"]
[null,"Laptops"]
[null,"Printer"]
[null,"Other computing"]
[null,"Software"]
[null,"Food/Participant refreshments"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"05",{"$f":"SUM(C126:C144)","v":0}]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,"06",{"$f":"SUM(G126:G145,K126:K145)","v":0}]
[]
["STUDENT COSTS (08)"]
[]
["Stipends",null,null,null,null,null,"TA/RA/SA Tuition",null,null,null,"Other"]
["Annual Amt.","# of Trainees","Months","Total",null,null,null,null,null,null,"Item","Amount"]
[null,null,null,{"$f":"(A151/12)*C151*B151","v":0},null,null,"Base Tuition",{"$f":"I33","v":0}]
[null,null,null,{"$f":"(A152/12)*C152*B152","v":0},null,null,"Inflation rate",0.1]
[null,null,null,{"$f":"(A153/12)*C153*B153","v":0},null,null,"Tuition",{"$f":"ROUND(H151*((1+H152)^C3),0)","v":0}]
[null,null,null,{"$f":"(A154/12)*C154*B154","v":0}]
["Subtotals",null,null,{"$f":"SUM(D151:D154)","v":0},null,null,null,{"$f":"H153","v":0},null,null,null,{"$f":"SUM(L151:L154)","v":0}]
[]
["TOTAL",null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D155:L155)","v":0}]
[]
["SUBCONTRACTS"]
[null,null,null,null,null,null,null,null,"Previous","Amt Subject"]
["Entity",null,"Dir. Costs","IDC",null,"Total",null,"All Yrs total","yrs base","to IDC"]
[null,null,null,null,null,{"$f":"C162+D162","v":0},null,null,0,{"$f":"IF(F162=0,0,IF(B174=3,F162,IF(I162>=25000,0,IF(25000-I162>F162,F162,25000-I162))))","v":0}]
[null,null,null,null,null,{"$f":"C163+D163","v":0},null,null,0,{"$f":"IF(F163=0,0,IF(B175=3,F163,IF(I163>=25000,0,IF(25000-I163>F163,F163,25000-I163))))","v":0}]
[null,null,null,null,null,{"$f":"C164+D164","v":0},null,null,0,{"$f":"IF(F164=0,0,IF(B176=3,F164,IF(I164>=25000,0,IF(25000-I164>F164,F164,25000-I164))))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F165=0,0,IF(B177=3,F165,IF(I165>=25000,0,IF(25000-I165>F165,F165,25000-I165))))","v":0}]
["TOTAL",null,{"$f":"SUM(C162:C165)","v":0},{"$f":"SUM(D162:D165)","v":0},null,null,null,null,null,{"$f":"SUM(J162:J164)","v":0},null,null,null,{"$f":"SUM(C166:E166)","v":0}]
[]
["DIRECT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N55,N80,N97,N121,N144,N145,N157,N166)","v":0}]
[]
["INDIRECT (F&A) COSTS"]
[]
["UW"]
[null,"Type","Amount",null,"IDC type",null,null,null,"Base types"]
["Base",1,{"$f":"IF(B174=1,(N168-N145-N157-N166+J166),IF(B174=2,(N168-N145-N157-N166+J166-SUM(H87:H96)),IF(B174=3,N168,0)))","v":0},null,"type 1",0.55500000000000005,"Research",null,"type 1","Modified (TDC less tuition, equip, & sbctrt over 25K)"]
["IDC (F&A)",1,{"$f":"ROUND(C174*INDEX(E174:F179,B175,2),0)","v":0},null,"type 2",0.26,"Off-campus",null,"type 2","Off-campus Modified (less rent & other off campus costs)"]
["Rate",{"$f":"INDEX(E174:F179,B175,2)","v":0.55500000000000005},null,null,"type 3",0.53,"Training, Unrestricted",null,"type 3","Total Direct Costs"]
[null,null,null,null,"type 4",0.08,"Training, Restricted",null,"type 4","Other"]
[" ",null,null,null,"type 5","0%","None"]
[null,null,null,null,"type 6",null,"Other (fill in)"]
[]
[]
["TOTAL",null,null,null,"*Hover over \"Research\" for comment with upcoming F&A rates",null,null,null,null,null,null,null,null,{"$f":"C175","v":0}]
[]
["TOTALS"]
[]
["GC-1",null,null,null,null,424,null,null,null,null,null,398]
[null,"Salaries","01",{"$f":"L55","v":0},null,null,"Key Prsnl",{"$f":"N21","v":0},"Other",null,null,null,"Personnel",{"$f":"N55","v":0}]
[null,"Consultant","02",{"$f":"N80","v":0},null,null,"Other Prsnl",{"$f":"N55-N21","v":0},"Supplies",{"$f":"N144+SUM(G126:G144)","v":0},null,null,"Consultant",{"$f":"G71","v":0}]
[null,"Other Svs.","03",{"$f":"N97","v":0},null,null,"Equipment",{"$f":"SUM(K126:K143)","v":0},"Pub. costs",{"$f":"B95","v":0},null,null,"Equipment",{"$f":"SUM(K126:K143)","v":0}]
[null,"Travel","04",{"$f":"N121","v":0},null,null,"Travel",null,"Consultants",{"$f":"G71","v":0},null,null,"Supplies",{"$f":"N144+SUM(G126:G143)","v":0}]
[null,"Supplies","05",{"$f":"N144","v":0},null,null,"Foreign",{"$f":"I109","v":0},"Comp. Srvs",{"$f":"E92","v":0},null,null,"Travel",{"$f":"N121","v":0}]
[null,"Equipment","06",{"$f":"N145","v":0},null,null,"Domestic",{"$f":"I119","v":0}," Subcontracts",{"$f":"N166","v":0},null,null,"Other",{"$f":"SUM(N97,G80,N157)","v":0}]
[null,"Fringe","07",{"$f":"M55","v":0},null,null,"Trainees",null,"Rental",{"$f":"H87","v":0},null,null,"Subcontracts",{"$f":"C166","v":0}]
[null,"StudentAid","08",{"$f":"N157","v":0},null,null,"Tuition",{"$f":"H155","v":0},"Alterations",0]
[null,"Sbcont/Patnt","__",{"$f":"N166","v":0},null,null,"Stipends",{"$f":"D155+L155","v":0},"Other costs",{"$f":"SUM(G80,B86:B94,E85:E91,E93:E95,H88:H95)","v":0},null,null,"Subtotal Direct",{"$f":"SUM(N187:N193)","v":0}]
[null,"Unalloc","38",null,null,null,null,null,"Other ",null,null,null,"Subcon. IDC",{"$f":"D166","v":0}]
[null,null,null,null,null,null,null,null,"Other"]
[null,"TOT DIRECT",null,{"$f":"SUM(D187:D195)","v":0},null,null,"Total Direct",{"$f":"SUM(H187:H197,J187:J197)","v":0},null,null,null,null,"Total Direct",{"$f":"SUM(N195:N196)","v":0}]
[null,"Indirect (F&A)","25-99",{"$f":"N182","v":0},null,null,"Total Indirect (F&A)",{"$f":"N182","v":0},null,null,null,null,"Indirect Costs (F&A)",{"$f":"C175","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D198:D199)","v":0},null,null,"Total",{"$f":"SUM(H198:H199)","v":0},null,null,null,null,"Total",{"$f":"SUM(N198:N199)","v":0}]