{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Main Budget","salary worksheet","fringe rates table","Assumptions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":10,"comments":2,"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":"Summary","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,11],[1,1,1,11]]}
["Principal Investigator",{"$f":"'Main Budget'!C1","v":0}]
["Project Sponsor",{"$f":"'Main Budget'!C4","v":0}]
["Project Title",{"$f":"'Main Budget'!C5","v":0}]
["Project Start Date",{"$f":"'Main Budget'!C2","v":"00:00:00"}]
["Project End Date",{"$f":"'Main Budget'!C3","v":"00:00:00"}]
[]
[]
[]
[null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5"]
["Personnel Costs",null,{"$f":"'Main Budget'!G7","v":"00 Jan '00- 30 Dec '00"},null,{"$f":"'Main Budget'!I7","v":"31 Dec '00 - 30 Dec '01"},null,{"$f":"'Main Budget'!K7","v":"31 Dec '01 - 30 Dec '02"},null,{"$f":"'Main Budget'!M7","v":"31 Dec '02 - 30 Dec '03"},null,{"$f":"'Main Budget'!O7","v":"31 Dec '03 - 30 Dec '04"},"Total"]
["Total Salary",null,{"$f":"'Main Budget'!G18","v":0},null,{"$f":"'Main Budget'!I18","v":0},null,{"$f":"'Main Budget'!K18","v":0},null,{"$f":"'Main Budget'!M18","v":0},null,{"$f":"'Main Budget'!O18","v":0},{"$f":"'Main Budget'!P18","v":0}]
["Fringe Costs",null,{"$f":"'Main Budget'!G20","v":0},null,{"$f":"'Main Budget'!I20","v":0},null,{"$f":"'Main Budget'!K20","v":0},null,{"$f":"'Main Budget'!M20","v":0},null,{"$f":"'Main Budget'!O20","v":0},{"$f":"Sumvisible(C12:K12)","v":0}]
["Total Salary and Fringe",null,{"$f":"C11+C12","v":0},null,{"$f":"E11+E12","v":0},null,0,null,0,null,0,{"$f":"Sumvisible(C13:K13)","v":0}]
[]
["Research Travel",null,{"$f":"'Main Budget'!G40","v":0},null,{"$f":"'Main Budget'!I40","v":0},null,{"$f":"'Main Budget'!K40","v":0},null,{"$f":"'Main Budget'!M40","v":0},null,{"$f":"'Main Budget'!O40","v":0},{"$f":"Sumvisible(C15:K15)","v":0}]
[]
["Course Support",null,{"$f":"'Main Budget'!G61","v":0},null,{"$f":"'Main Budget'!I61","v":0},null,{"$f":"'Main Budget'!K61","v":0},null,{"$f":"'Main Budget'!M61","v":0},null,{"$f":"'Main Budget'!O61","v":0},{"$f":"Sumvisible(C17:K17)","v":0}]
[]
["Workshop Costs",null,{"$f":"'Main Budget'!G83","v":0},null,{"$f":"'Main Budget'!I83","v":0},null,{"$f":"'Main Budget'!K83","v":0},null,{"$f":"'Main Budget'!M83","v":0},null,{"$f":"'Main Budget'!O83","v":0},{"$f":"Sumvisible(C19:K19)","v":0}]
[]
["Publication Expenses",null,{"$f":"'Main Budget'!G68","v":0},null,{"$f":"'Main Budget'!I68","v":0},null,{"$f":"'Main Budget'!K68","v":0},null,{"$f":"'Main Budget'!M68","v":0},null,{"$f":"'Main Budget'!O68","v":0},{"$f":"Sumvisible(C21:K21)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Main Budget'!M86","v":0}]
["Other Direct Costs"]
["Equipment",null,{"$f":"'Main Budget'!G26","v":0},null,{"$f":"'Main Budget'!I26","v":0},null,{"$f":"'Main Budget'!K26","v":0},null,{"$f":"'Main Budget'!M26","v":0},null,{"$f":"'Main Budget'!O26","v":0},{"$f":"Sumvisible(C24:K24)","v":0}]
["Supplies, Materials, and Reproduction",null,{"$f":"'Main Budget'!G86+'Main Budget'!G87+'Main Budget'!G88","v":0},null,{"$f":"'Main Budget'!I86+'Main Budget'!I87+'Main Budget'!I88","v":0},null,{"$f":"'Main Budget'!K86+'Main Budget'!K87+'Main Budget'!K88","v":0},null,{"$f":"'Main Budget'!M86+'Main Budget'!M87+'Main Budget'!M88","v":0},null,{"$f":"'Main Budget'!O86+'Main Budget'!O87+'Main Budget'!O88","v":0},{"$f":"Sumvisible(C25:K25)","v":0}]
["Consultants, Subcontracts and Other",null,{"$f":"'Main Budget'!G89+'Main Budget'!G91+'Main Budget'!G95+'Main Budget'!G90","v":0},null,{"$f":"'Main Budget'!I89+'Main Budget'!I91+'Main Budget'!I95+'Main Budget'!I90","v":0},null,{"$f":"'Main Budget'!K89+'Main Budget'!K91+'Main Budget'!K95+'Main Budget'!K90","v":0},null,{"$f":"'Main Budget'!M89+'Main Budget'!M91+'Main Budget'!M95+'Main Budget'!M90","v":0},null,{"$f":"'Main Budget'!O89+'Main Budget'!O91+'Main Budget'!O95+'Main Budget'!O90","v":0},{"$f":"Sumvisible(C26:K26)","v":0}]
["Total Other Direct Costs",null,{"$f":"SUM(C24:C26)","v":0},null,{"$f":"SUM(E24:E26)","v":0},null,0,null,0,null,0,{"$f":"Sumvisible(C27:K27)","v":0}]
[]
["Total Direct Expenses",null,{"$f":"C13+C15+C17+C19+C21+C27","v":0},null,{"$f":"E13+E15+E17+E19+E21+E27","v":0},null,0,null,0,null,0,{"$f":"Sumvisible(C29:K29)","v":0}]
["Overhead on Direct Expenses",null,{"$f":"'Main Budget'!G100","v":0},null,{"$f":"'Main Budget'!I100","v":0},null,{"$f":"'Main Budget'!K100","v":0},null,{"$f":"'Main Budget'!M100","v":0},null,{"$f":"'Main Budget'!O100","v":0},{"$f":"Sumvisible(C30:K30)","v":0}]
["Total",null,{"$f":"C29+C30","v":0},null,{"$f":"E29+E30","v":0},null,0,null,0,null,0,{"$f":"Sumvisible(C31:K31)","v":0}]

{"sheet":"Main Budget","index":1,"n_rows":102,"n_cols":17,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,6,1,15],[3,6,3,15],[4,6,4,15]]}
["Principal Investigator:",null,null,null,"Cost of Living Assumption"]
["Project Period Start",null,null,null,0.02]
["Project Period End"]
["Sponsor"]
["Title"]
[null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5","Total All Years"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT($C$2, \"dd mmm 'yy\"),\"- \", TEXT(DATE(YEAR($C$2)+1,MONTH($C$2),DAY($C$2))-1, \"dd mmm 'yy\"))","v":"00 Jan '00- 30 Dec '00"},null,{"$f":"CONCATENATE(TEXT(DATE(YEAR($C$2)+1,MONTH($C$2),DAY($C$2)), \"dd mmm 'yy\"),\" - \", TEXT(DATE(YEAR($C$2)+2,MONTH($C$2),DAY($C$2))-1, \"dd mmm 'yy\"))","v":"31 Dec '00 - 30 Dec '01"},null,{"$f":"CONCATENATE(TEXT(DATE(YEAR($C$2)+2,MONTH($C$2),DAY($C$2)), \"dd mmm 'yy\"),\" - \", TEXT(DATE(YEAR($C$2)+3,MONTH($C$2),DAY($C$2))-1, \"dd mmm 'yy\"))","v":"31 Dec '01 - 30 Dec '02"},null,{"$f":"CONCATENATE(TEXT(DATE(YEAR($C$2)+3,MONTH($C$2),DAY($C$2)), \"dd mmm 'yy\"),\" - \", TEXT(DATE(YEAR($C$2)+4,MONTH($C$2),DAY($C$2))-1, \"dd mmm 'yy\"))","v":"31 Dec '02 - 30 Dec '03"},null,{"$f":"CONCATENATE(TEXT(DATE(YEAR($C$2)+4,MONTH($C$2),DAY($C$2)), \"dd mmm 'yy\"),\" - \", TEXT(DATE(YEAR($C$2)+5,MONTH($C$2),DAY($C$2))-1, \"dd mmm 'yy\"))","v":"31 Dec '03 - 30 Dec '04"},null,"Notes"]
["A. Personnel Costs"]
["Principal Investigator",{"$f":"'salary worksheet'!C10","v":6010},null,null,null,null,{"$f":"'salary worksheet'!J10","v":0},null,{"$f":"'salary worksheet'!L10","v":0},null,{"$f":"'salary worksheet'!N10","v":0},null,{"$f":"'salary worksheet'!P10","v":0},null,{"$f":"'salary worksheet'!R10","v":0},{"$f":"Sumvisible(G9:O9)","v":0}]
["Senior Faculty",{"$f":"'salary worksheet'!C10","v":6010},null,null,null,null,{"$f":"'salary worksheet'!J15-'salary worksheet'!J10","v":0},null,{"$f":"'salary worksheet'!L15-'salary worksheet'!L10","v":0},null,{"$f":"'salary worksheet'!N15-'salary worksheet'!N10","v":0},null,{"$f":"'salary worksheet'!P15-'salary worksheet'!P10","v":0},null,{"$f":"'salary worksheet'!R15-'salary worksheet'!R10","v":0},{"$f":"Sumvisible(G10:O10)","v":0}]
["Research Associates - Other Faculty",{"$f":"'salary worksheet'!C34","v":6030},null,null,null,null,{"$f":"'salary worksheet'!J39","v":0},null,{"$f":"'salary worksheet'!L39","v":0},null,{"$f":"'salary worksheet'!N39","v":0},null,{"$f":"'salary worksheet'!P39","v":0},null,{"$f":"'salary worksheet'!R39","v":0},0]
["Faculty Summer Salary",{"$f":"'salary worksheet'!C26","v":6040},null,null,null,null,{"$f":"'salary worksheet'!J31","v":0},null,{"$f":"'salary worksheet'!L31","v":0},null,{"$f":"'salary worksheet'!N31","v":0},null,{"$f":"'salary worksheet'!P31","v":0},null,{"$f":"'salary worksheet'!R31","v":0},0]
["Professional Exempt Staff",{"$f":"'salary worksheet'!C42","v":6050},null,null,null,null,{"$f":"'salary worksheet'!J44","v":0},null,{"$f":"'salary worksheet'!L44","v":0},null,{"$f":"'salary worksheet'!N44","v":0},null,{"$f":"'salary worksheet'!P44","v":0},null,{"$f":"'salary worksheet'!R44","v":0},0]
["Non-Exempt Staff",{"$f":"'salary worksheet'!C47","v":6070},null,null,null,null,{"$f":"'salary worksheet'!J47","v":0},null,{"$f":"'salary worksheet'!L47","v":0},null,{"$f":"'salary worksheet'!N47","v":0},null,{"$f":"'salary worksheet'!P47","v":0},null,{"$f":"'salary worksheet'!R47","v":0},0]
["Research and Teaching Assistants",{"$f":"CONCATENATE('salary worksheet'!C67, \", \", 'salary worksheet'!C76,\", \", 'salary worksheet'!C62)","v":"6110, 6120, 6140"},null,null,null,null,{"$f":"'salary worksheet'!J81+'salary worksheet'!J63+'salary worksheet'!J72","v":0},null,{"$f":"'salary worksheet'!L81+'salary worksheet'!L63+'salary worksheet'!L72","v":0},null,{"$f":"'salary worksheet'!N81+'salary worksheet'!N63+'salary worksheet'!N72","v":0},null,{"$f":"'salary worksheet'!P81+'salary worksheet'!P63+'salary worksheet'!P72","v":0},null,{"$f":"'salary worksheet'!R81+'salary worksheet'!R63+'salary worksheet'!R72","v":0},0]
["Post Docs",{"$f":"'salary worksheet'!C53","v":6150},null,null,null,null,{"$f":"'salary worksheet'!J54","v":0},null,{"$f":"'salary worksheet'!L54","v":0},null,{"$f":"'salary worksheet'!N54","v":0},null,{"$f":"'salary worksheet'!P54","v":0},null,{"$f":"'salary worksheet'!R54","v":0},{"$f":"Sumvisible(G16:O16)","v":0}]
[]
["Total Salary",null,null,null,null,null,{"$f":"SUM(G9:G16)","v":0},null,{"$f":"SUM(I9:I16)","v":0},null,0,null,0,null,0,{"$f":"Sumvisible(G18:O18)","v":0}]
[]
["Fringe Costs",null,null,null,null,null,{"$f":"'salary worksheet'!J85","v":0},null,{"$f":"'salary worksheet'!L85","v":0},null,{"$f":"'salary worksheet'!N85","v":0},null,{"$f":"'salary worksheet'!P85","v":0},null,{"$f":"'salary worksheet'!L85","v":0},{"$f":"Sumvisible(G20:O20)","v":0}]
[]
["Total Salary and Fringe",null,null,null,null,null,{"$f":"G18+G20","v":0},null,{"$f":"I18+I20","v":0},null,{"$f":"K18+K20","v":0},null,{"$f":"M18+M20","v":0},null,{"$f":"O18+O20","v":0},{"$f":"Sumvisible(G22:O22)","v":0}]
[]
["B. Equipment"]
["Itemize Equipment over $5,000",null,null,null,null,null,null,null,{"$f":"SUM(G25*(1+$E$2))","v":0},null,{"$f":"I25*(1+$E$2)","v":0},null,{"$f":"K25*(1+$E$2)","v":0},null,{"$f":"M25*(1+$E$2)","v":0},{"$f":"Sumvisible(G25:O25)","v":0}]
["Total Equipment",null,null,null,null,null,{"$f":"G25","v":0},null,{"$f":"I25","v":0},null,{"$f":"K25","v":0},null,0,null,0,{"$f":"Sumvisible(G26:O26)","v":0}]
[]
["C. Research Travel"]
["Faculty Travel",null,"Trips","People","Cost","Days"]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C30*D30*E30","v":0},null,{"$f":"SUM(G30*(1+$E$2))","v":0},null,{"$f":"I30*(1+$E$2)","v":0},null,{"$f":"K30*(1+$E$2)","v":0},null,{"$f":"M30*(1+$E$2)","v":0},{"$f":"Sumvisible(G30:O30)","v":0}]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C31*D31*E31*F31","v":0},null,{"$f":"SUM(G31*(1+$E$2))","v":0},null,{"$f":"I31*(1+$E$2)","v":0},null,{"$f":"K31*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G31:O31)","v":0}]
["Per Diems","7650, 7670",null,null,null,null,{"$f":"C32*D32*E32*F32","v":0},null,{"$f":"SUM(G32*(1+$E$2))","v":0},null,{"$f":"I32*(1+$E$2)","v":0},null,{"$f":"K32*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G32:O32)","v":0}]
["On Site Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C33*D33*E33*F33","v":0},null,{"$f":"SUM(G33*(1+$E$2))","v":0},null,{"$f":"I33*(1+$E$2)","v":0},null,{"$f":"K33*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G33:O33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G34:O34)","v":0}]
["Research Associates",null,"Trips","People","Cost","Days"]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C36*D36*E36","v":0},null,{"$f":"SUM(G36*(1+$E$2))","v":0},null,{"$f":"I36*(1+$E$2)","v":0},null,{"$f":"K36*(1+$E$2)","v":0},null,{"$f":"M36*(1+$E$2)","v":0},{"$f":"Sumvisible(G36:O36)","v":0}]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C37*D37*E37*F37","v":0},null,{"$f":"SUM(G37*(1+$E$2))","v":0},null,{"$f":"I37*(1+$E$2)","v":0},null,{"$f":"K37*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G37:O37)","v":0}]
["Per Diems","7650, 7670",null,null,null,null,{"$f":"C38*D38*E38*F38","v":0},null,{"$f":"SUM(G38*(1+$E$2))","v":0},null,{"$f":"I38*(1+$E$2)","v":0},null,{"$f":"K38*(1+$E$2)","v":0},null,0,0]
["On Site Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C39*D39*E39*F39","v":0},null,{"$f":"SUM(G39*(1+$E$2))","v":0},null,{"$f":"I39*(1+$E$2)","v":0},null,{"$f":"K39*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G39:O39)","v":0}]
["Total Research Travel",null,null,null,null,null,{"$f":"SUM(G29:G39)","v":0},null,{"$f":"SUM(I29:I39)","v":0},null,{"$f":"SUM(K29:K39)","v":0},null,{"$f":"SUM(M29:M39)","v":0},null,0,{"$f":"Sumvisible(G40:O40)","v":0}]
[]
["D. Course Support"]
["Student Travel",null,"Trips","People","Cost","Days"]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C44*D44*E44","v":0},null,{"$f":"SUM(G44*(1+$E$2))","v":0},null,{"$f":"I44*(1+$E$2)","v":0},null,{"$f":"K44*(1+$E$2)","v":0},null,{"$f":"M44*(1+$E$2)","v":0},{"$f":"Sumvisible(G44:O44)","v":0}]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C45*D45*E45*F45","v":0},null,{"$f":"SUM(G45*(1+$E$2))","v":0},null,{"$f":"I45*(1+$E$2)","v":0},null,{"$f":"K45*(1+$E$2)","v":0},null,0,0]
["On Site Group Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C46*D46*E46*F46","v":0},null,{"$f":"SUM(G46*(1+$E$2))","v":0},null,{"$f":"I46*(1+$E$2)","v":0},null,{"$f":"K46*(1+$E$2)","v":0},null,0,0]
[]
["Faculty Travel",null,"Trips","People","Cost","Days"]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C49*D49*E49","v":0},null,{"$f":"SUM(G49*(1+$E$2))","v":0},null,{"$f":"I49*(1+$E$2)","v":0},null,{"$f":"K49*(1+$E$2)","v":0},null,{"$f":"M49*(1+$E$2)","v":0},{"$f":"Sumvisible(G49:O49)","v":0}]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C50*D50*E50*F50","v":0},null,{"$f":"SUM(G50*(1+$E$2))","v":0},null,{"$f":"I50*(1+$E$2)","v":0},null,{"$f":"K50*(1+$E$2)","v":0},null,0,0]
["Per Diems","7650, 7670",null,null,null,null,{"$f":"C51*D51*E51*F51","v":0},null,{"$f":"SUM(G51*(1+$E$2))","v":0},null,{"$f":"I51*(1+$E$2)","v":0},null,{"$f":"K51*(1+$E$2)","v":0},null,0,{"$f":"Sumvisible(G51:O51)","v":0}]
["Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C52*D52*E52*F52","v":0},null,{"$f":"SUM(G52*(1+$E$2))","v":0},null,{"$f":"I52*(1+$E$2)","v":0},null,{"$f":"K52*(1+$E$2)","v":0},null,0,0]
["Design Critics",null,"Trips/Event","People","Cost","Days"]
["Honoraria",8690,null,null,null,null,{"$f":"D54*E54","v":0},null,{"$f":"SUM(G54*(1+$E$2))","v":0},null,{"$f":"I54*(1+$E$2)","v":0},null,{"$f":"K54*(1+$E$2)","v":0},null,{"$f":"M54*(1+$E$2)","v":0},{"$f":"Sumvisible(G54:O54)","v":0}]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C55*D55*E55","v":0},null,0,null,0,null,0,null,0,0]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C56*D56*E56*F56","v":0},null,0,null,0,null,0,null,0,0]
["Per Diems","7650, 7670",null,null,null,null,{"$f":"C57*D57*E57*F57","v":0},null,0,null,0,null,0,null,0,0]
["Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C58*D58*E58*F58","v":0},null,0,null,0,null,0,null,0,0]
["Course Materials","7650, 7670",null,null,null,null,0,null,{"$f":"SUM(G59*(1+$E$2))","v":0},null,{"$f":"I59*(1+$E$2)","v":0},null,{"$f":"K59*(1+$E$2)","v":0},null,{"$f":"M59*(1+$E$2)","v":0},{"$f":"Sumvisible(G59:O59)","v":0}]
["Printing and Plotting","7650, 7670",null,null,null,null,0,null,0,null,{"$f":"I60*(1+$E$2)","v":0},null,{"$f":"K60*(1+$E$2)","v":0},null,{"$f":"M60*(1+$E$2)","v":0},0]
["Total Course Support",null,null,null,null,null,{"$f":"SUM(G44:G60)","v":0},null,{"$f":"SUM(I44:I60)","v":0},null,0,null,0,null,0,0]
[]
["E. Publication Expenses"]
["Writing / Editing / Translating",8551,null,null,null,null,null,null,{"$f":"SUM(G64*(1+$E$2))","v":0},null,{"$f":"I64*(1+$E$2)","v":0},null,{"$f":"K64*(1+$E$2)","v":0},null,{"$f":"M64*(1+$E$2)","v":0},{"$f":"Sumvisible(G64:O64)","v":0}]
["Graphic Design",8551,null,null,null,null,null,null,{"$f":"SUM(G65*(1+$E$2))","v":0},null,{"$f":"I65*(1+$E$2)","v":0},null,{"$f":"K65*(1+$E$2)","v":0},null,0,0]
["Printing",8553,null,null,null,null,null,null,{"$f":"SUM(G66*(1+$E$2))","v":0},null,{"$f":"I66*(1+$E$2)","v":0},null,{"$f":"K66*(1+$E$2)","v":0},null,0,0]
["Other (Specify)",null,null,null,null,null,null,null,{"$f":"SUM(G67*(1+$E$2))","v":0},null,{"$f":"I67*(1+$E$2)","v":0},null,{"$f":"K67*(1+$E$2)","v":0},null,0,0]
["Total Publication",null,null,null,null,null,{"$f":"SUM(G64:G67)","v":0},null,{"$f":"SUM(I64:I67)","v":0},null,{"$f":"SUM(K64:K67)","v":0},null,{"$f":"SUM(M64:M67)","v":0},null,0,0]
[]
["F. Workshop Expenses"]
["Catering",8060,null,null,null,null,null,null,{"$f":"SUM(G71*(1+$E$2))","v":0},null,{"$f":"I71*(1+$E$2)","v":0},null,{"$f":"K71*(1+$E$2)","v":0},null,{"$f":"M71*(1+$E$2)","v":0},{"$f":"Sumvisible(G71:O71)","v":0}]
["Printing Materials",8550,null,null,null,null,null,null,{"$f":"SUM(G72*(1+$E$2))","v":0},null,{"$f":"I72*(1+$E$2)","v":0},null,{"$f":"K72*(1+$E$2)","v":0},null,0,0]
["Room Rental",7230,null,null,null,null,null,null,{"$f":"SUM(G73*(1+$E$2))","v":0},null,{"$f":"I73*(1+$E$2)","v":0},null,{"$f":"K73*(1+$E$2)","v":0},null,0,0]
["Security or Cleaning Expenses",7260,null,null,null,null,null,null,{"$f":"SUM(G74*(1+$E$2))","v":0},null,{"$f":"I74*(1+$E$2)","v":0},null,{"$f":"K74*(1+$E$2)","v":0},null,0,0]
["Speakers",null,"Trips/Event","People","Cost","Days"]
["Honoraria",8690,null,null,null,null,{"$f":"D76*E76","v":0},null,{"$f":"SUM(G76*(1+$E$2))","v":0},null,{"$f":"I76*(1+$E$2)","v":0},null,{"$f":"K76*(1+$E$2)","v":0},null,{"$f":"M76*(1+$E$2)","v":0},{"$f":"Sumvisible(G76:O76)","v":0}]
["Airfare (economy)","7650, 7670",null,null,null,null,{"$f":"C77*D77*E77","v":0},null,0,null,0,null,0,null,0,0]
["Hotel","7650, 7670",null,null,null,null,{"$f":"C78*D78*E78*F78","v":0},null,0,null,0,null,0,null,0,0]
["Per Diems","7650, 7670",null,null,null,null,{"$f":"C79*D79*E79*F79","v":0},null,0,null,0,null,0,null,0,0]
["Ground Transportation","7650, 7670",null,null,null,null,{"$f":"C80*D80*E80*F80","v":0},null,0,null,0,null,0,null,0,0]
["Supplies",6640,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Other (Specify)",null,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Total Conference Expenses",null,null,null,null,null,{"$f":"SUM(G71:G82)","v":0},null,{"$f":"SUM(I71:I82)","v":0},null,{"$f":"SUM(K71:K82)","v":0},null,{"$f":"SUM(M71:M82)","v":0},null,{"$f":"SUM(O71:O82)","v":0},0]
[]
["G.  Other Direct Costs"]
["Materials and Supplies",6640,null,null,null,null,null,null,{"$f":"SUM(G86*(1+$E$2))","v":0},null,{"$f":"I86*(1+$E$2)","v":0},null,{"$f":"K86*(1+$E$2)","v":0},null,{"$f":"M86*(1+$E$2)","v":0},{"$f":"Sumvisible(G86:O86)","v":0}]
["Reproduction / Maps",8550,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Photocopying",8540,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Consultants (Specify)",7980,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Local project meetings and meals",8060,null,null,null,null,null,null,0,null,0,null,0,null,0,{"$f":"Sumvisible(G90:O90)","v":0}]
["Other (Specify)",null,null,null,null,null,null,null,0,null,0,null,0,null,0,0]
["Total Other Direct Costs",null,null,null,null,null,{"$f":"SUM(G86:G91)","v":0},null,{"$f":"SUM(I86:I91)","v":0},null,{"$f":"SUM(K86:K91)","v":0},null,{"$f":"SUM(M86:M91)","v":0},null,0,0]
[]
["H. Subcontract"]
["Subcontract to other institution/agency (Specify)",8190,null,null,null,null,null,null,{"$f":"SUM(G95*(1+$E$2))","v":0},null,{"$f":"I95*(1+$E$2)","v":0},null,{"$f":"K95*(1+$E$2)","v":0},null,{"$f":"M95*(1+$E$2)","v":0},{"$f":"Sumvisible(G95:O95)","v":0}]
["Total Subcontract",null,null,null,null,null,{"$f":"SUM(G95)","v":0},null,{"$f":"SUM(I95)","v":0},null,{"$f":"SUM(K95)","v":0},null,{"$f":"SUM(M95)","v":0},null,0,0]
[]
["Total Direct Costs",null,null,null,null,null,{"$f":"SUM(G96+G92+G83+G68+G61+G40+G26+G22)","v":0},null,{"$f":"SUM(I96+I92+I83+I68+I61+I40+I26+I22)","v":0},null,{"$f":"SUM(K96+K92+K83+K68+K61+K40+K26+K22)","v":0},null,{"$f":"SUM(M96+M92+M83+M68+M61+M40+M26+M22)","v":0},null,{"$f":"SUM(O96+O92+O83+O68+O61+O40+O26+O22)","v":0},{"$f":"Sumvisible(G98:O98)","v":0}]
[]
["Indirect Costs",8400,"Rate:",0.2,null,null,{"$f":"SUM(G98*$D100)","v":0},null,{"$f":"SUM(I98*$D100)","v":0},null,{"$f":"SUM(K98*$D100)","v":0},null,{"$f":"SUM(M98*$D100)","v":0},null,{"$f":"SUM(O98*$D100)","v":0},{"$f":"Sumvisible(G100:O100)","v":0}]
[]
["Total Costs (Direct + Indirect)",null,null,null,null,null,{"$f":"G98+G100","v":0},null,{"$f":"I98+I100","v":0},null,{"$f":"K98+K100","v":0},null,0,null,0,{"$f":"Sumvisible(G102:O102)","v":0}]

{"sheet":"salary worksheet","index":2,"n_rows":86,"n_cols":20,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Main Budget'!A1","v":"Principal Investigator:"},{"$f":"'Main Budget'!C1","v":0},null,null,null,null,null,null,null,null,"Cost of Living Increase",null,null,null,"Summer Months","% Effort"]
[{"$f":"'Main Budget'!A4","v":"Sponsor"},{"$f":"'Main Budget'!C4","v":0},null,null,null,null,null,null,null,null,"Faculty Increase",null,0.03,null,1,{"$f":"O2/9*0.95","v":0.10555555555555554},"Note: Harvard Policy is to only cover 95% of summer salary from grants"]
["Title",{"$f":"'Main Budget'!C5","v":0},null,null,null,{"$f":"IF(MONTH('Main Budget'!C2)<6,7-MONTH('Main Budget'!C2),19-MONTH('Main Budget'!C2))","v":6},"Number of Project Months in first Harvard FY",null,null,null,"Staff, RA, & Post-Doc Increase",null,0.03,null,2,{"$f":"O3/9*0.95","v":0.21111111111111108}]
["Project Start Date:",{"$f":"'Main Budget'!C2","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"O4/9*0.95","v":0.31666666666666665}]
["Project End Date:",{"$f":"'Main Budget'!C3","v":"00:00:00"}]
[]
[null,null,null,null,null,null,null,null,"Grant Year 1",null,"Grant Year 2",null,"Grant Year 3",null,"Grant Year 4",null,"Grant Year 5"]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+1)),\" - \",IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+1),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+2)))","v":"FY1900 - FY1901"},null,{"$f":"CONCATENATE(IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+1),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+2)),\" - \",IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+2),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+3)))","v":"FY1901 - FY1902"},null,{"$f":"CONCATENATE(IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+2),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+3)),\" - \",IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+3),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+4)))","v":"FY1902 - FY1903"},null,{"$f":"CONCATENATE(IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+3),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+4)),\" - \",IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+4),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+5)))","v":"FY1903 - FY1904"},null,{"$f":"CONCATENATE(IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+4),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+5)),\" - \",IF(MONTH('Main Budget'!$C$2)<7,CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+5),CONCATENATE(\"FY\",YEAR('Main Budget'!$C$2)+6)))","v":"FY1904 - FY1905"}]
["Position","Position Type","Object Code","Name","Notes","FTE Salary Base","FTE",null,"% Effort","Total","% Effort","Total","% Effort",null,"% Effort",null,"% Effort",null,"Project Total"]
["Principal Investigator","Faculty",6010,null,null,null,1,null,0,{"$f":"F10*G10*I10*(1+$M$2*$F$3/12)","v":0},{"$f":"$I10","v":0},{"$f":"$F10*(1+$M$2)*(1+$M$2*$F$3/12)*K10*G10","v":0},{"$f":"$I10","v":0},{"$f":"$F10*(1+$M$2)^2*(1+$M$2*$F$3/12)*G10*M10","v":0},{"$f":"$I10","v":0},{"$f":"$F10*(1+$M$2)^3*(1+$M$2*$F$3/12)*G10*O10","v":0},{"$f":"$I10","v":0},{"$f":"$F10*(1+$M$2)^4*(1+$M$2*$F$3/12)*G10*Q10","v":0},{"$f":"J10+L10+N10+P10+R10","v":0}]
["Faculty ","Faculty",6010,null,null,null,1,null,0,{"$f":"F11*G11*I11*(1+$M$2*$F$3/12)","v":0},0,{"$f":"$F11*(1+$M$2)*(1+$M$2*$F$3/12)*K11*G11","v":0},{"$f":"$I11","v":0},{"$f":"$F11*(1+$M$2)^2*(1+$M$2*$F$3/12)*G11*M11","v":0},{"$f":"$I11","v":0},{"$f":"$F11*(1+$M$2)^3*(1+$M$2*$F$3/12)*G11*O11","v":0},{"$f":"$I11","v":0},{"$f":"$F11*(1+$M$2)^4*(1+$M$2*$F$3/12)*G11*Q11","v":0},{"$f":"J11+L11+N11+P11+R11","v":0}]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,{"$f":"J13+L13+N13+P13+R13","v":0}]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,{"$f":"J14+L14+N14+P14+R14","v":0}]
["Subtotal Principal Investigator",null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J14)","v":0},null,{"$f":"SUM(L10:L14)","v":0},null,{"$f":"SUM(N10:N14)","v":0},null,{"$f":"SUM(P10:P14)","v":0},null,{"$f":"SUM(R10:R14)","v":0},{"$f":"SUM(J15:R15)","v":0},{"$f":"S15-SUM(J15:R15)","v":0}]
["Faculty Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$5+(12-$F$3)*'fringe rates table'!$D$5)/12*J15","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$5+(12-$F$3)*'fringe rates table'!$E$5)/12*L15","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$5+(12-$F$3)*'fringe rates table'!$F$5)/12*N15","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$5+(12-$F$3)*'fringe rates table'!$G$5)/12*P15","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$5+(12-$F$3)*'fringe rates table'!$H$5)/12*R15","v":0},{"$f":"SUM(I16:R16)","v":0}]
[]
["Faculty Instruction","Faculty",6010,null,null,null,1,null,0,{"$f":"F18*G18*I18*(1+$M$2*$F$3/12)","v":0},{"$f":"$I18","v":0},{"$f":"$F18*(1+$M$2)*(1+$M$2*$F$3/12)*K18*G18","v":0},{"$f":"$I18","v":0},{"$f":"$F18*(1+$M$2)^2*(1+$M$2*$F$3/12)*G18*M18","v":0},{"$f":"$I18","v":0},{"$f":"$F18*(1+$M$2)^3*(1+$M$2*$F$3/12)*G18*O18","v":0},{"$f":"$I18","v":0},{"$f":"$F18*(1+$M$2)^4*(1+$M$2*$F$3/12)*G18*Q18","v":0},{"$f":"J18+L18+N18+P18+R18","v":0}]
["Faculty ","Faculty",6010,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,{"$f":"J19+L19+N19+P19+R19","v":0}]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Faculty ","Faculty",6020,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Senior Faculty",null,null,null,null,null,null,null,null,{"$f":"SUM(J18:J22)","v":0},null,{"$f":"SUM(L18:L22)","v":0},null,{"$f":"SUM(N18:N22)","v":0},null,{"$f":"SUM(P18:P22)","v":0},null,{"$f":"SUM(R18:R22)","v":0},{"$f":"SUM(J23:R23)","v":0},{"$f":"S23-SUM(J23:R23)","v":0}]
["Faculty Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$5+(12-$F$3)*'fringe rates table'!$D$5)/12*J23","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$5+(12-$F$3)*'fringe rates table'!$E$5)/12*L23","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$5+(12-$F$3)*'fringe rates table'!$F$5)/12*N23","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$5+(12-$F$3)*'fringe rates table'!$G$5)/12*P23","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$5+(12-$F$3)*'fringe rates table'!$H$5)/12*R23","v":0},{"$f":"SUM(I24:R24)","v":0}]
[]
["Principal Investigator Summer Salary","Faculty",6040,null,null,{"$f":"F10","v":0},1,null,null,{"$f":"F26*G26*I26*(1+$M$2*$F$3/12)","v":0},{"$f":"$I26","v":0},{"$f":"$F26*(1+$M$2)*(1+$M$2*$F$3/12)*K26*G26","v":0},{"$f":"$I26","v":0},{"$f":"$F26*(1+$M$2)^2*(1+$M$2*$F$3/12)*G26*M26","v":0},{"$f":"$I26","v":0},{"$f":"$F26*(1+$M$2)^3*(1+$M$2*$F$3/12)*G26*O26","v":0},{"$f":"$I26","v":0},{"$f":"$F26*(1+$M$2)^4*(1+$M$2*$F$3/12)*G26*Q26","v":0},{"$f":"J26+L26+N26+P26+R26","v":0}]
["Faculty Summer Salary","Faculty",6040,null,null,0,1,null,null,{"$f":"F27*G27*I27*(1+$M$2*$F$3/12)","v":0},{"$f":"$I27","v":0},0,0,0,0,0,0,0,0]
["Faculty Summer Salary","Faculty",6040,null,null,0,1,null,null,0,{"$f":"$I28","v":0},0,0,0,0,0,0,0,0]
["Faculty Summer Salary","Faculty",6040,null,null,0,1,null,null,{"$f":"F29*G29*I29*(1+$M$2*$F$3/12)","v":0},{"$f":"$I29","v":0},{"$f":"$F29*(1+$M$2)*(1+$M$2*$F$3/12)*K29*G29","v":0},0,{"$f":"$F29*(1+$M$2)^2*(1+$M$2*$F$3/12)*G29*M29","v":0},0,{"$f":"$F29*(1+$M$2)^3*(1+$M$2*$F$3/12)*G29*O29","v":0},0,{"$f":"$F29*(1+$M$2)^4*(1+$M$2*$F$3/12)*G29*Q29","v":0},{"$f":"J29+L29+N29+P29+R29","v":0}]
["Faculty Summer Salary","Faculty",6040,null,null,0,1,null,null,0,{"$f":"$I30","v":0},0,0,0,0,0,0,0,0]
["Subtotal Faculty Summer",null,null,null,null,null,null,null,null,{"$f":"SUM(J26:J30)","v":0},null,{"$f":"SUM(L26:L30)","v":0},null,{"$f":"SUM(N26:N30)","v":0},null,{"$f":"SUM(P26:P30)","v":0},null,{"$f":"SUM(R26:R30)","v":0},{"$f":"SUM(J31:R31)","v":0}]
["Faculty Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$5+(12-$F$3)*'fringe rates table'!$D$5)/12*J31","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$5+(12-$F$3)*'fringe rates table'!$E$5)/12*L31","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$5+(12-$F$3)*'fringe rates table'!$F$5)/12*N31","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$5+(12-$F$3)*'fringe rates table'!$G$5)/12*P31","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$5+(12-$F$3)*'fringe rates table'!$H$5)/12*R31","v":0},{"$f":"SUM(I32:R32)","v":0}]
[]
["Research Associates - Other Fac.","Other Faculty",6030,null,null,null,1,null,0,{"$f":"F34*G34*I34*(1+$M$2*$F$3/12)","v":0},{"$f":"$I34","v":0},{"$f":"$F34*(1+$M$2)*(1+$M$2*$F$3/12)*K34*G34","v":0},{"$f":"$I34","v":0},{"$f":"$F34*(1+$M$2)^2*(1+$M$2*$F$3/12)*G34*M34","v":0},{"$f":"$I34","v":0},{"$f":"$F34*(1+$M$2)^3*(1+$M$2*$F$3/12)*G34*O34","v":0},{"$f":"$I34","v":0},{"$f":"$F34*(1+$M$2)^4*(1+$M$2*$F$3/12)*G34*Q34","v":0},{"$f":"J34+L34+N34+P34+R34","v":0}]
["Research Associates - Other Fac.","Other Faculty",6030,null,null,null,1,null,0,{"$f":"F35*G35*I35*(1+$M$2*$F$3/12)","v":0},0,{"$f":"$F35*(1+$M$2)*(1+$M$2*$F$3/12)*K35*G35","v":0},0,{"$f":"$F35*(1+$M$2)^2*(1+$M$2*$F$3/12)*G35*M35","v":0},0,{"$f":"$F35*(1+$M$2)^3*(1+$M$2*$F$3/12)*G35*O35","v":0},0,{"$f":"$F35*(1+$M$2)^4*(1+$M$2*$F$3/12)*G35*Q35","v":0},{"$f":"J35+L35+N35+P35+R35","v":0}]
["Research Associates - Other Fac.","Other Faculty",6030,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Research Associates - Other Fac.","Other Faculty",6030,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Research Associates - Other Fac.","Other Faculty",6030,null,null,null,1,null,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Other Faculty",null,null,null,null,null,null,null,null,{"$f":"SUM(J34:J38)","v":0},null,{"$f":"SUM(L34:L38)","v":0},null,{"$f":"SUM(N34:N38)","v":0},null,{"$f":"SUM(P34:P38)","v":0},null,{"$f":"SUM(R34:R38)","v":0},{"$f":"SUM(J39:R39)","v":0}]
["Faculty Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$5+(12-$F$3)*'fringe rates table'!$D$5)/12*J39","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$5+(12-$F$3)*'fringe rates table'!$E$5)/12*L39","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$5+(12-$F$3)*'fringe rates table'!$F$5)/12*N39","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$5+(12-$F$3)*'fringe rates table'!$G$5)/12*P39","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$5+(12-$F$3)*'fringe rates table'!$H$5)/12*R39","v":0},{"$f":"SUM(I40:R40)","v":0}]
[]
["Senior Research Associate","Exempt",6050,null,null,null,1,null,0,{"$f":"F42*G42*I42*(1+$M$3*$F$3/12)","v":0},{"$f":"$I42","v":0},{"$f":"$F42*(1+$M$3)*(1+$M$3*$F$3/12)*K42*G42","v":0},{"$f":"$I42","v":0},{"$f":"$F42*(1+$M$3)^2*(1+$M$3*$F$3/12)*G42*M42","v":0},{"$f":"$I42","v":0},{"$f":"$F42*(1+$M$3)^3*(1+$M$3*$F$3/12)*G42*O42","v":0},{"$f":"$I42","v":0},{"$f":"$F42*(1+$M$3)^4*(1+$M$3*$F$3/12)*G42*Q42","v":0},{"$f":"J42+L42+N42+P42+R42","v":0}]
["Specialist","Exempt",6050,null,null,0,1,null,0,{"$f":"F43*G43*I43*(1+$M$3*$F$3/12)","v":0},{"$f":"$I43","v":0},{"$f":"$F43*(1+$M$3)*(1+$M$3*$F$3/12)*K43*G43","v":0},{"$f":"$I43","v":0},{"$f":"$F43*(1+$M$3)^2*(1+$M$3*$F$3/12)*G43*M43","v":0},{"$f":"$I43","v":0},{"$f":"$F43*(1+$M$3)^3*(1+$M$3*$F$3/12)*G43*O43","v":0},{"$f":"$I43","v":0},{"$f":"$F43*(1+$M$3)^4*(1+$M$3*$F$3/12)*G43*Q43","v":0},{"$f":"J43+L43+N43+P43+R43","v":0}]
["Subtotal Exempt Staff",null,null,null,null,null,null,null,null,{"$f":"SUM(J42:J43)","v":0},null,{"$f":"SUM(L42:L43)","v":0},null,{"$f":"SUM(N42:N43)","v":0},null,{"$f":"SUM(P42:P43)","v":0},null,{"$f":"SUM(R42:R43)","v":0},{"$f":"SUM(J44:R44)","v":0}]
["Exempt Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$8+(12-$F$3)*'fringe rates table'!$D$8)/12*J44","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$8+(12-$F$3)*'fringe rates table'!$E$8)/12*L44","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$8+(12-$F$3)*'fringe rates table'!$F$8)/12*N44","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$8+(12-$F$3)*'fringe rates table'!$G$8)/12*P44","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$8+(12-$F$3)*'fringe rates table'!$H$8)/12*R44","v":0},{"$f":"SUM(I45:R45)","v":0}]
[]
["Clerical/Technical","Non-exempt",6070,"Staff Assistant",null,null,1,null,0,{"$f":"F47*G47*I47*(1+$M$3*$F$3/12)","v":0},{"$f":"$I47","v":0},{"$f":"$F47*(1+$M$3)*(1+$M$3*$F$3/12)*K47*G47","v":0},{"$f":"$I47","v":0},{"$f":"$F47*(1+$M$3)^2*(1+$M$3*$F$3/12)*G47*M47","v":0},{"$f":"$I47","v":0},{"$f":"$F47*(1+$M$3)^3*(1+$M$3*$F$3/12)*G47*O47","v":0},{"$f":"$I47","v":0},{"$f":"$F47*(1+$M$3)^4*(1+$M$3*$F$3/12)*G47*Q47","v":0},{"$f":"J47+L47+N47+P47+R47","v":0}]
["Subtotal Non-Exempt Staff",null,null,null,null,null,null,null,null,{"$f":"SUM(J46:J47)","v":0},null,{"$f":"SUM(L46:L47)","v":0},null,{"$f":"SUM(N46:N47)","v":0},null,{"$f":"SUM(P46:P47)","v":0},null,{"$f":"SUM(R46:R47)","v":0},{"$f":"SUM(J48:R48)","v":0}]
["Non-Exempt Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$9+(12-$F$3)*'fringe rates table'!$D$9)/12*J48","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$9+(12-$F$3)*'fringe rates table'!$E$9)/12*L48","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$9+(12-$F$3)*'fringe rates table'!$F$9)/12*N48","v":0},null,{"$f":"($F$3*'fringe rates table'!$F$9+(12-$F$3)*'fringe rates table'!$G$9)/12*P48","v":0},null,{"$f":"($F$3*'fringe rates table'!$G$9+(12-$F$3)*'fringe rates table'!$H$9)/12*R48","v":0},{"$f":"SUM(I49:R49)","v":0}]
[]
[]
["Post Doc","Post-Doc",6150,"Post-Doc",null,0,1,null,0,{"$f":"F52*G52*I52*(1+$M$3*$F$3/12)","v":0},{"$f":"$I52","v":0},{"$f":"$F52*(1+$M$3)*(1+$M$3*$F$3/12)*K52*G52","v":0},{"$f":"$I52","v":0},{"$f":"$F52*(1+$M$3)^2*(1+$M$3*$F$3/12)*G52*M52","v":0},{"$f":"$I52","v":0},{"$f":"$F52*(1+$M$3)^3*(1+$M$3*$F$3/12)*G52*O52","v":0},{"$f":"$I52","v":0},{"$f":"$F52*(1+$M$3)^4*(1+$M$3*$F$3/12)*G52*Q52","v":0},{"$f":"J52+L52+N52+P52+R52","v":0}]
["Post Doc","Post-Doc",6150,"Post-Doc",null,0,1,null,0,{"$f":"F53*G53*I53*(1+$M$3*$F$3/12)","v":0},0,0,0,0,0,0,0,0,0]
["Subtotal PostDoc",null,null,null,null,null,null,null,null,{"$f":"SUM(J52:J53)","v":0},null,{"$f":"SUM(L52:L53)","v":0},null,{"$f":"SUM(N52:N53)","v":0},null,{"$f":"SUM(P52:P53)","v":0},null,{"$f":"SUM(R52:R53)","v":0},{"$f":"SUM(J54:R54)","v":0}]
["PostDoc Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$6+(12-$F$3)*'fringe rates table'!$D$6)/12*J54","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$6+(12-$F$3)*'fringe rates table'!$E$6)/12*L54","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$6+(12-$F$3)*'fringe rates table'!$F$6)/12*N54","v":0},null,{"$f":"('fringe rates table'!$F$6)*P54","v":0},null,{"$f":"('fringe rates table'!$F$6)*R54","v":0},{"$f":"SUM(I55:R55)","v":0}]
[]
[]
["Research Assistant Summer (Monthly)","Grad Student",6140,"Research Assistant",null,0,1,null,0,{"$f":"F58*G58*I58","v":0},{"$f":"$I58","v":0},{"$f":"$F58*(1+$M$3)*K58*G58","v":0},{"$f":"$I58","v":0},{"$f":"$F58*(1+$M$3)^2*G58*M58","v":0},{"$f":"$I58","v":0},{"$f":"$F58*(1+$M$3)^3*G58*O58","v":0},{"$f":"$I58","v":0},{"$f":"$F58*(1+$M$3)^4*G58*Q58","v":0},{"$f":"J58+L58+N58+P58+R58","v":0}]
["Research Assistant Summer (Monthly)","Grad Student",6140,"Research Assistant",null,0,1,null,0,{"$f":"F59*G59*I59","v":0},{"$f":"$I59","v":0},{"$f":"$F59*(1+$M$3)*K59*G59","v":0},{"$f":"$I59","v":0},{"$f":"$F59*(1+$M$3)^2*G59*M59","v":0},{"$f":"$I59","v":0},{"$f":"$F59*(1+$M$3)^3*G59*O59","v":0},{"$f":"$I59","v":0},{"$f":"$F59*(1+$M$3)^4*G59*Q59","v":0},0]
["Research Assistant Summer (Monthly)","Grad Student",6140,"Research Assistant",null,0,1,null,0,{"$f":"F60*G60*I60","v":0},{"$f":"$I60","v":0},{"$f":"$F60*(1+$M$3)*K60*G60","v":0},{"$f":"$I60","v":0},{"$f":"$F60*(1+$M$3)^2*G60*M60","v":0},{"$f":"$I60","v":0},{"$f":"$F60*(1+$M$3)^3*G60*O60","v":0},{"$f":"$I60","v":0},{"$f":"$F60*(1+$M$3)^4*G60*Q60","v":0},{"$f":"J60+L60+N60+P60+R60","v":0}]
["Research Assistant Summer (Monthly)","Grad Student",6140,"Research Assistant",null,0,1,null,0,{"$f":"F61*G61*I61","v":0},{"$f":"$I61","v":0},{"$f":"$F61*(1+$M$3)*K61*G61","v":0},{"$f":"$I61","v":0},{"$f":"$F61*(1+$M$3)^2*G61*M61","v":0},{"$f":"$I61","v":0},{"$f":"$F61*(1+$M$3)^3*G61*O61","v":0},{"$f":"$I61","v":0},{"$f":"$F61*(1+$M$3)^4*G61*Q61","v":0},{"$f":"J61+L61+N61+P61+R61","v":0}]
["Research Assistant Summer (Monthly)","Grad Student",6140,"Research Assistant",null,0,1,null,0,{"$f":"F62*G62*I62","v":0},{"$f":"$I62","v":0},{"$f":"$F62*(1+$M$3)*K62*G62","v":0},{"$f":"$I62","v":0},{"$f":"$F62*(1+$M$3)^2*G62*M62","v":0},{"$f":"$I62","v":0},{"$f":"$F62*(1+$M$3)^3*G62*O62","v":0},{"$f":"$I62","v":0},{"$f":"$F62*(1+$M$3)^4*G62*Q62","v":0},0]
["Subtotal RA Summer Monthly",null,null,null,null,null,null,null,null,{"$f":"SUM(J58:J62)","v":0},null,{"$f":"SUM(L58:L62)","v":0},null,{"$f":"SUM(N58:N62)","v":0},null,{"$f":"SUM(P58:P62)","v":0},null,{"$f":"SUM(R58:R62)","v":0},{"$f":"SUM(J63:R63)","v":0}]
["RA Summer Monthly Fringe",null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(I64:R64)","v":0}]
[]
[null,null,null,null,null,"Hourly Rate","Hours/week","Weeks"]
["Research Assistant Academic Year (Hourly)","Grad Student",6110,"Research Assistant",null,null,null,null,null,{"$f":"F67*G67*H67","v":0},null,{"$f":"$F67*(1+$M$3)*H67*G67","v":0},null,{"$f":"$F67*(1+$M$3)^2*G67*H67","v":0},null,{"$f":"$F67*(1+$M$3)^3*G67*H67","v":0},null,{"$f":"$F67*(1+$M$3)^4*G67*H67","v":0},{"$f":"J67+L67+N67+P67+R67","v":0}]
["Research Assistant Academic Year (Hourly)","Grad Student",6110,"Research Assistant",null,null,null,null,null,{"$f":"F68*G68*H68","v":0},null,{"$f":"$F68*(1+$M$3)*H68*G68","v":0},null,{"$f":"$F68*(1+$M$3)^2*G68*H68","v":0},null,{"$f":"$F68*(1+$M$3)^3*G68*H68","v":0},null,{"$f":"$F68*(1+$M$3)^4*G68*H68","v":0},0]
["Research Assistant Academic Year (Hourly)","Grad Student",6110,"Research Assistant",null,null,null,null,null,0,null,{"$f":"$F69*(1+$M$3)*H69*G69","v":0},null,{"$f":"$F69*(1+$M$3)^2*G69*H69","v":0},null,{"$f":"$F69*(1+$M$3)^3*G69*H69","v":0},null,{"$f":"$F69*(1+$M$3)^4*G69*H69","v":0},0]
["Research Assistant Academic Year (Hourly)","Grad Student",6110,"Research Assistant",null,null,null,null,null,{"$f":"F70*G70*H70","v":0},null,{"$f":"$F70*(1+$M$3)*H70*G70","v":0},null,{"$f":"$F70*(1+$M$3)^2*G70*H70","v":0},null,{"$f":"$F70*(1+$M$3)^3*G70*H70","v":0},null,{"$f":"$F70*(1+$M$3)^4*G70*H70","v":0},{"$f":"J70+L70+N70+P70+R70","v":0}]
["Research Assistant Academic Year (Hourly)","Grad Student",6110,"Research Assistant",null,null,null,null,null,0,null,{"$f":"$F71*(1+$M$3)*H71*G71","v":0},null,{"$f":"$F71*(1+$M$3)^2*G71*H71","v":0},null,{"$f":"$F71*(1+$M$3)^3*G71*H71","v":0},null,{"$f":"$F71*(1+$M$3)^4*G71*H71","v":0},0]
["Subtotal RA AY Hourly",null,null,null,null,null,null,null,null,{"$f":"SUM(J67:J71)","v":0},null,{"$f":"SUM(L67:L71)","v":0},null,{"$f":"SUM(N67:N71)","v":0},null,{"$f":"SUM(P67:P71)","v":0},null,{"$f":"SUM(R67:R71)","v":0},{"$f":"SUM(J72:R72)","v":0},{"$f":"SUM(J72:R72)-S72","v":0}]
["RA AY Hourly Fringe",null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(I73:R73)","v":0}]
[]
[null,null,null,null,null,"Hourly Rate","Hours/week","Weeks"]
["Research Assistant Summer (Hourly)","Grad Student",6120,"Research Assistant",null,null,null,null,null,{"$f":"F76*G76*H76","v":0},null,null,null,{"$f":"$F76*(1+$M$3)^2*G76*H76","v":0},null,{"$f":"$F76*(1+$M$3)^3*G76*H76","v":0},null,{"$f":"$F76*(1+$M$3)^4*G76*H76","v":0},{"$f":"J76+L76+N76+P76+R76","v":0}]
["Research Assistant Summer (Hourly)","Grad Student",6120,"Research Assistant",null,null,null,null,null,0,null,null,null,{"$f":"$F77*(1+$M$3)^2*G77*H77","v":0},null,{"$f":"$F77*(1+$M$3)^3*G77*H77","v":0},null,{"$f":"$F77*(1+$M$3)^4*G77*H77","v":0},{"$f":"J77+L77+N77+P77+R77","v":0}]
["Research Assistant Summer (Hourly)","Grad Student",6120,"Research Assistant",null,null,null,null,null,{"$f":"F78*G78*H78","v":0},null,null,null,{"$f":"$F78*(1+$M$3)^2*G78*H78","v":0},null,{"$f":"$F78*(1+$M$3)^3*G78*H78","v":0},null,{"$f":"$F78*(1+$M$3)^4*G78*H78","v":0},{"$f":"J78+L78+N78+P78+R78","v":0}]
["Research Assistant Summer (Hourly)","Grad Student",6120,"Research Assistant",null,null,null,null,null,null,null,{"$f":"$F79*(1+$M$3)*H79*G79","v":0},null,{"$f":"$F79*(1+$M$3)^2*G79*H79","v":0},null,{"$f":"$F79*(1+$M$3)^3*G79*H79","v":0},null,{"$f":"$F79*(1+$M$3)^4*G79*H79","v":0},0]
["Research Assistant Summer (Hourly)","Grad Student",6120,"Research Assistant",null,null,null,null,null,null,null,{"$f":"$F80*(1+$M$3)*H80*G80","v":0},null,{"$f":"$F80*(1+$M$3)^2*G80*H80","v":0},null,{"$f":"$F80*(1+$M$3)^3*G80*H80","v":0},null,{"$f":"$F80*(1+$M$3)^4*G80*H80","v":0},0]
["Subtotal RA Summer Hourly",null,null,null,null,null,null,null,null,{"$f":"SUM(J76:J80)","v":0},null,{"$f":"SUM(L76:L80)","v":0},null,{"$f":"SUM(N76:N80)","v":0},null,{"$f":"SUM(P76:P80)","v":0},null,{"$f":"SUM(R76:R80)","v":0},{"$f":"SUM(J81:R81)","v":0}]
["Research Assistant (Hourly) Fringe",null,null,null,null,null,null,null,null,{"$f":"($F$3*'fringe rates table'!$C$10+(12-$F$3)*'fringe rates table'!$D$10)/12*J81","v":0},null,{"$f":"($F$3*'fringe rates table'!$D$10+(12-$F$3)*'fringe rates table'!$E$10)/12*L81","v":0},null,{"$f":"($F$3*'fringe rates table'!$E$10+(12-$F$3)*'fringe rates table'!$F$10)/12*N81","v":0},null,{"$f":"('fringe rates table'!$F$10)*P81","v":0},null,{"$f":"('fringe rates table'!$F$10)*R81","v":0},{"$f":"SUM(I82:R82)","v":0}]
[]
["Subtotal Salary",null,null,null,null,null,null,null,null,{"$f":"J15+J39+J31+J44+J48+J72+J81+J54+J63+J23","v":0},null,{"$f":"L15+L39+L31+L44+L48+L72+L81+L54+L63+L23","v":0},null,{"$f":"N15+N39+N31+N44+N48+N72+N81+N54+N63+N23","v":0},null,{"$f":"P15+P39+P31+P44+P48+P72+P81+P54+P63+P23","v":0},null,{"$f":"R15+R39+R31+R44+R48+R72+R81+R54+R63+R23","v":0},{"$f":"S15+S39+S31+S44+S48+S72+S81+S54+S63+S23","v":0}]
["Subtotal Fringe",null,null,null,null,null,null,null,null,{"$f":"J16+J40+J32+J45+J49+J73+J82+J55+J64+J24","v":0},null,{"$f":"L16+L40+L32+L45+L49+L73+L82+L55+L64+L24","v":0},null,{"$f":"N16+N40+N32+N45+N49+N73+N82+N55+N64+N24","v":0},null,{"$f":"P16+P40+P32+P45+P49+P73+P82+P55+P64+P24","v":0},null,{"$f":"R16+R40+R32+R45+R49+R73+R82+R55+R64+R24","v":0},{"$f":"S16+S40+S32+S45+S49+S73+S82+S55+S64+S24","v":0}]
["Total Salary + Fringe",null,null,null,null,null,null,null,null,{"$f":"SUM(J84:J85)","v":0},null,{"$f":"SUM(L84:L85)","v":0},null,{"$f":"SUM(N84:N85)","v":0},null,{"$f":"SUM(P84:P85)","v":0},null,{"$f":"SUM(R84:R85)","v":0},{"$f":"SUM(S84:S85)","v":0}]

{"sheet":"fringe rates table","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Fringe & Vacation Assessment Rates"]
["University Area",null,"FY15","FY16","FY17","FY18","FY19","FY20"]
[null,"Start Date:","2014-07-01","2015-07-01","2016-07-01","2017-07-01","2018-07-01","2019-07-01"]
[null,"End Date:","2015-06-30","2016-06-30","2017-06-30","2018-06-30","2019-06-30","2020-06-30"]
["Faculty & Other Academic","6010, 6020, 6030, 6040",0.247,0.26400000000000001,0.26700000000000002,0.26700000000000002,0.26700000000000002,0.26700000000000002]
["Post-Docs","6150",0.23200000000000001,0.251,0.25900000000000001,0.25900000000000001,0.25900000000000001,0.25900000000000001]
["Teaching Assistants","6152",0.17599999999999999,0.19,0.193,0.193,0.193,0.193]
["Exempt (Fringe + Vacation)","6050, 6051",{"$f":"+C17+C18","v":0.42799999999999999},0.442,0.44500000000000001,0.44500000000000001,0.44500000000000001,{"$f":"+H17+H18","v":0.44500000000000001}]
["Non-Exempt (Fringe + Vacation)","6070, 6071, 6080",{"$f":"+C21+C22","v":0.55900000000000005},0.57799999999999996,0.58399999999999996,0.58399999999999996,{"$f":"+G21+G22","v":0.58399999999999996},0.58399999999999996]
["Temporary, Unenrolled","6090, 6120",7.6999999999999999E-2,9.0999999999999998E-2,9.7000000000000003E-2,9.7000000000000003E-2,9.7000000000000003E-2,9.7000000000000003E-2]
["Extra Compensation, Pensionable","6190, 6191",0.15,0.15,0.15,0.15,0.15,0.15]
["Extra Compensation, Non-pensionable","6200-6204",0.08,0.08,0.08,0.08,0.08,0.08]
["Enrolled Students","6110",0,0,0,0,0,0]
[]
[]
["Admin & Professional"]
["Fringe",null,0.32200000000000001,0.33800000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002,0.33900000000000002]
["Vacation Fringe",null,0.106,0.104,0.106,0.106,0.106,0.106]
[]
["Clerical/Technical, Service and Trade"]
["Fringe",null,0.45500000000000002,0.47599999999999998,0.48,0.48,0.48,0.48]
["Vacation Fringe",null,0.104,0.10199999999999999,0.104,0.104,0.104,0.104]
[]
[]
["PI Instruction"]
["PI Additional Effort"]
["PI Course Buyout"]
[]
["Faculty Instruction"]
["Faculty Additional Effort"]
["Faculty Course Buyout"]

{"sheet":"Assumptions","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Assumptions"]
["All Grants are assumed to run for full years. Partial year grants should have the effort figures adjusted for the final year so that they represent % of full year effort. (So for example an 18 month grant that the PI is at 50% effort on should have 25% effort entered for the last year. 50% times 6 months remaining divided by 12 months = 25%)"]
["Fringe and salary calculations are based on the assumption that grants begin on the first of the month. Grants which begin on other dates (particularly those which begin in the last couple days of the month) may result in incorrect months or fiscal years displayed in column headings, and slight variations (on the order of a tenth of a percent) in salary and fringe calculations."]
["Expenses are assumed to be distributed evenly across the years of the grant with a slight increase to account for inflation. Expenses which will not be evenly distributed (for example a grant which has a single workshop across two years) should be entered manually into the appropriate year column of the main budget spreadsheet."]
["By default, the spreadsheet assumes that effort percentages will be constant across the years of the grant, though this can be manually edited in the salary worksheet."]
["The spreadsheet assumes all costs are subject to overhead."]
["Grants are assumed to start in FY15. For grants starting in later years, delete the FY15 column (Column C) in the fringe rates table and add a FY21 column to the right of the fringe rates table."]
["PER DIEMS: The per diem rate for M&IE includes the following items: all meals, room service, laundry, dry cleaning and pressing of clothing, and fees and tips for persons who provide services, such as food servers and luggage handlers."]