{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","SALARY-FRINGE","TRAVEL","OTHER COSTS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Summary","index":0,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,0,29,5],[37,0,37,5],[45,0,45,5],[23,0,23,1],[26,0,26,1],[24,0,24,1],[19,0,19,1],[13,0,13,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1]]}
["OSP-2  BUDGET & COSTSHARING",null,"Proposal Number"]
[null,null,"PI"]
["Attach additional explanation of cost-sharing.",null,"Agency"]
[null,null,"Start date"]
[null,null,"End date"]
[null,null,"For multiyear, this is Year "]
[]
["BUDGET CATEGORY",null,"Direct Costs","Cost Share"]
["Salary and Wages",null,{"$f":"'SALARY-FRINGE'!D48","v":0},{"$f":"'SALARY-FRINGE'!F48","v":0}]
["Fringe Benefits",null,{"$f":"'SALARY-FRINGE'!D49","v":0},{"$f":"'SALARY-FRINGE'!F49","v":0}]
["Travel",null,{"$f":"TRAVEL!D47","v":0},{"$f":"TRAVEL!F47","v":0}]
["Equipment",null,{"$f":"'OTHER COSTS'!D19","v":0},{"$f":"'OTHER COSTS'!F19","v":0}]
["Supplies",null,{"$f":"'OTHER COSTS'!D13","v":0},{"$f":"'OTHER COSTS'!F13","v":0}]
["Other Costs",null,{"$f":"'OTHER COSTS'!D53","v":0},{"$f":"'OTHER COSTS'!F53","v":0}]
["Communication",null,{"$f":"'OTHER COSTS'!D25","v":0},{"$f":"'OTHER COSTS'!F25","v":0}]
["Participant Support",null,{"$f":"'OTHER COSTS'!D32","v":0},{"$f":"'OTHER COSTS'!F32","v":0}]
["Consultants",null,{"$f":"'OTHER COSTS'!D43","v":0},{"$f":"'OTHER COSTS'!F43","v":0}]
["Subcontracts",null,{"$f":"'OTHER COSTS'!D37","v":0},{"$f":"'OTHER COSTS'!F37","v":0}]
["TOTAL DIRECT COSTS",null,{"$f":"SUM(C9:C18)","v":0},{"$f":"SUM(D9:D18)","v":0}]
["Indirect Costs (55% of Salary & Wages)",null,{"$f":"SUM(C9*0.55)","v":0}]
["TOTAL COSTS",null,{"$f":"IF(C24>=1,\"\", C19+C20)","v":0}]
[]
["Complete this section if HPU idc waived or other rate requested"]
["Other Indirect Costs (enter amount & attach OSP-3)"]
["TOTAL COSTS",null,{"$f":"IF(C24=\"\",\"\",IF(C24>=0,C19+C24))","v":""}]
[]
["Unrecovered Indirect Costs (if HPU Indirect Costs waived)",null,{"$f":"IF(C24=\"\",\"\",IF(C24>=0,C20-C24))","v":""}]
[]
[]
["I certify that the information provided is accurate and that any cost-sharing is required for the program or is necessary per the University's Cost-Sharing Policy"]
[]
[]
[]
[]
["PI Signature                                          ","Date",null,"Dean Signature                             ",null,"Date"]
[]
[]
["I certify that the budget information has been reviewed and is consistent with the policies of OSP"]
[]
[]
[]
[]
["A.V.P - OSP Signature                                 ","Date"]
[]
[]
["I have reviewed and approved the budget and cost-sharing commitment for this proposal"]
[]
[]
[]
["S. V. P. & Provost ","Date"]
[]
[]
[]
["Chief Financial Officer                          ","Date"]

{"sheet":"SALARY-FRINGE","index":1,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["SALARIES, WAGES & FRINGE BENEFITS"]
[]
["Full-time Faculty, Academic Year","Annual Salary","% Effort","Salary ","% Effort","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B4*C4)","v":0},null,{"$f":"SUM(B4*E4)","v":0}]
[null,null,null,0,null,{"$f":"SUM(B5*E5)","v":0}]
[null,null,null,0,null,0]
["Subtotal ",null,null,{"$f":"SUM(D4:D6)","v":0},null,{"$f":"SUM(F4:F6)","v":0}]
["Fringe Benefits",0.23,null,{"$f":"SUM(D7*B8)","v":0},null,{"$f":"SUM(F7*B8)","v":0}]
[]
["Full-time Faculty, Summer","Monthly Summer Salary","# Summer Mos.","Salary","% Effort","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B11*C11)","v":0},null,{"$f":"SUM(B11*E11)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D11:D13)","v":0},null,{"$f":"SUM(F11:F13)","v":0}]
["Fringe Benefits",0.23,null,{"$f":"SUM(D14*B15)","v":0},null,{"$f":"SUM(F14*B15)","v":0}]
[]
["Full-time Staff","Annual Salary","% Effort","Salary ","% Effort","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B18*C18)","v":0},null,{"$f":"SUM(B18*E18)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D18:D20)","v":0},null,{"$f":"SUM(F18:F20)","v":0}]
["Fringe Benefits",0.28999999999999998,null,{"$f":"SUM(D21*B22)","v":0},null,{"$f":"SUM(F21*B22)","v":0}]
[]
["Part-time Staff (< 19 hrs/wk)","Hrly Rate","Total Hrs","Salary ","Total Hrs","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B25*C25)","v":0},null,{"$f":"SUM(B25*E25)","v":0}]
[null,null,null,0,null,{"$f":"SUM(B26*E26)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D25:D28)","v":0},null,{"$f":"SUM(F25:F28)","v":0}]
["Fringe Benefits",0.18,null,{"$f":"SUM(D29*B30)","v":0},null,{"$f":"SUM(F29*B30)","v":0}]
[]
["Graduate Asst (< 17 hrs/wk)","Hrly Rate","Total Hrs","Salary","Total Hrs","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B33*C33)","v":0},null,{"$f":"SUM(B33*E33)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D33:D36)","v":0},null,{"$f":"SUM(F33:F36)","v":0}]
["Fringe Benefits",0,null,{"$f":"SUM(D37*B38)","v":0},null,{"$f":"SUM(F37*B38)","v":0}]
[]
["Undergrad Workers (<17 hrs/wk)","Hrly Rate","Total Hrs","Salary ","Total Hrs","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B41*C41)","v":0},null,{"$f":"SUM(B41*E41)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D41:D44)","v":0},null,{"$f":"SUM(F41:F44)","v":0}]
["Fringe Benefits",0,null,{"$f":"SUM(D45*B46)","v":0},null,{"$f":"SUM(F45*B46)","v":0}]
[]
[null,"TOTAL SALARIES",null,{"$f":"D7+D14+D21+D29+D37+D45","v":0},null,{"$f":"F7+F14+F21+F29+F37+F45","v":0}]
[null,"TOTAL FRINGE",null,{"$f":"D8+D15+D22+D30+D38+D46","v":0},null,{"$f":"F8+F15+F22+F30+F38+F46","v":0}]

{"sheet":"TRAVEL","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["TRAVEL EXPENSES"]
[]
["Airfare (by destination & person)","Cost/Trip","# of Trips","Total","# of Trips","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B4*C4)","v":0},null,{"$f":"SUM(B4*E4)","v":0}]
[null,null,null,{"$f":"SUM(B5*C5)","v":0},null,{"$f":"SUM(B5*E5)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal ",null,null,{"$f":"SUM(D4:D8)","v":0},null,{"$f":"SUM(F4:F8)","v":0}]
[]
["Lodging (by location & person)","Cost/Night","# of Nights","Total","# of Nights","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B12*C12)","v":0},null,{"$f":"SUM(B12*E12)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D12:D16)","v":0},null,{"$f":"SUM(F12:F16)","v":0}]
[]
["Meals (by person)","Rate/Day","# of Days","Total","# of Days","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B20*C20)","v":0},null,{"$f":"SUM(B20*E20)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D20:D24)","v":0},null,{"$f":"SUM(F20:F24)","v":0}]
[]
["Local Travel (to/from location)","Rate/Mile or Trip","# of Miles orTrips","Total","# of Miles orTrips","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B28*C28)","v":0},null,{"$f":"SUM(B28*E28)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D28:D30)","v":0},null,{"$f":"SUM(F28:F30)","v":0}]
[]
["Car Rental (by location)","Daily Rate","# of Days","Total","# of Days","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B34*C34)","v":0},null,{"$f":"SUM(B34*E34)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D34:D36)","v":0},null,{"$f":"SUM(F34:F36)","v":0}]
[]
["Other","Rate","# of Units","Total","# of Units","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B40*C40)","v":0},null,{"$f":"SUM(B40*E40)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D40:D43)","v":0},null,{"$f":"SUM(F40:F43)","v":0}]
[]
[]
[null,"TOTAL TRAVEL",null,{"$f":"D9+D17+D25+D31+D37+D44","v":0},null,{"$f":"F9+F17+F25+F31+F37+F44","v":0}]

{"sheet":"OTHER COSTS","index":3,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[34,0,34,1],[35,0,35,1],[33,0,33,1]]}
[]
["Supplies (itemize)","Cost/Unit","# Units","Total","# Units","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B3*C3)","v":0},null,{"$f":"SUM(B3*E3)","v":0}]
[null,null,null,{"$f":"SUM(B4*C4)","v":0},null,{"$f":"SUM(B4*E4)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,"Total Supplies",null,{"$f":"SUM(D3:D12)","v":0},null,{"$f":"SUM(F3:F12)","v":0}]
[]
["Equipment (> $5000) ","Cost/Unit","# Units","Total","# Units","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B16*C16)","v":0},null,{"$f":"SUM(B16*E16)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,"Total Equipment",null,{"$f":"SUM(D16:D18)","v":0},null,{"$f":"SUM(F16:F18)","v":0}]
[]
["Communication","Cost/Unit","# Units","Total","# Units","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B22*C22)","v":0},null,{"$f":"SUM(B22*E22)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,"Total Communication",null,{"$f":"SUM(D22:D24)","v":0},null,{"$f":"SUM(F22:F24)","v":0}]
[]
["Participant Support","Cost/ Participant","# of participants","Total","# of participants","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B28*C28)","v":0},null,{"$f":"SUM(B28*E28)","v":0}]
[null,null,null,{"$f":"SUM(B29*C29)","v":0},null,0]
[null,null,null,{"$f":"SUM(B30*C30)","v":0},null,0]
[null,null,null,0,null,{"$f":"SUM(B31*E31)","v":0}]
[null,"Total Participant Support",null,{"$f":"SUM(D28:D31)","v":0},null,{"$f":"SUM(F28:F31)","v":0}]
[]
["Subcontracts (institution)",null,"Amount","Total","Amount","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(C35)","v":0},null,{"$f":"SUM(E35)","v":0}]
[null,null,null,{"$f":"SUM(C36)","v":0},null,{"$f":"SUM(E36)","v":0}]
[null,"Total Subcontracts",null,{"$f":"SUM(D35:D36)","v":0},null,{"$f":"SUM(F35:F36)","v":0}]
[]
["Consultants","hrly rate","total hrs","Total","total hrs","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B40*C40)","v":0},null,{"$f":"SUM(B40*E40)","v":0}]
[null,null,null,{"$f":"SUM(B41*C41)","v":0},null,0]
[null,null,null,{"$f":"SUM(B42*C42)","v":0},null,0]
[null,"Total Consultants",null,{"$f":"SUM(D40:D42)","v":0},null,{"$f":"SUM(F40:F42)","v":0}]
[]
["Other Costs","Cost/Unit","# Units","Total","# Units","Cost Share","Cost Share Justification"]
[null,null,null,{"$f":"SUM(B46*C46)","v":0},null,{"$f":"SUM(B46*E46)","v":0}]
[null,null,null,0,null,{"$f":"SUM(B47*E47)","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,"Total Other Costs",null,{"$f":"SUM(D46:D52)","v":0},null,{"$f":"SUM(F46:F52)","v":0}]