{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Budget Summary","Personnel Costs","Direct and Indirect Costs","Travel Breakdown"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Budget Summary","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,4,2]]}
["PRINCIPLES OF TRUSTWORTHINESS TOOLKIT PILOT PROJECT"]
["AAMC Center for Health Justice"]
[]
["Period of Performance: 1 Year"]
["This is an autopopulated summary page. Please enter information in the 'Personnel Costs' and 'Direct and Indirect Costs' tabs.\n\nAllowable and Non-Allowable Costs: Allowable costs include expenses directly associated with the local execution of actions aligned with the trustworthiness principles. These may include, but are not limited to, resources for community engagement, incentives for providing feedback, materials for discussions, collaboration tools, costs related to organizing meetings and events, and personnel time. Non-allowable costs include expenses unrelated to the project's goals, such as personal expenses, unrelated travel costs, or unrelated equipment purchases. "]
[]
[]
["Itemized Project Budget","Total Costs"]
["Personnel (Salaries only)",{"$f":"'Personnel Costs'!F17","v":0}]
["Personnel (Fringe benefits)",{"$f":"'Personnel Costs'!G17","v":0}]
["Total Personnel (salaries+fringe)",{"$f":"SUM(B9:B10)","v":0}]
[]
["Consulting ",{"$f":"'Direct and Indirect Costs'!D14","v":0}]
["Travel",{"$f":"'Direct and Indirect Costs'!E24","v":0}]
["Supplies",{"$f":"'Direct and Indirect Costs'!B35","v":0}]
["Equipment",{"$f":"'Direct and Indirect Costs'!B46","v":0}]
["Subawards",{"$f":"'Direct and Indirect Costs'!B57","v":0}]
["Other Expenses",{"$f":"'Direct and Indirect Costs'!B68","v":0}]
["Total Direct Costs",{"$f":"SUM(B11:B18)","v":0}]
[]
["Total Indirect Costs ",{"$f":"'Direct and Indirect Costs'!B80","v":0}]
[]
[]
[]
[]
["Total Funding Requested\n(Direct Costs + Indirect Costs)",{"$f":"SUM(B19,B21)","v":0}]

{"sheet":"Personnel Costs","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,7]]}
["PRINCIPLES OF TRUSTWORTHINESS TOOLKIT PILOT PROJECT"]
["AAMC Center for Health Justice"]
[]
["Period of Performance: ","1 Year"]
[]
["PERSONNEL COSTS"]
[null,null,null,null,null,null,0]
["Employee Name","Organization Name","Role on Project","Base Salary","% Effort","Salary Request","Fringes","Total"]
[null,null,null,null,0,{"$f":"MIN(D9,192300)*E9","v":0},{"$f":"ROUND(F9*$G$7,0)","v":0},{"$f":"SUM(F9:G9)","v":0}]
[null,null,null,null,0,0,{"$f":"ROUND(F10*$G$7,0)","v":0},{"$f":"SUM(F10:G10)","v":0}]
[null,null,null,null,0,0,0,{"$f":"SUM(F11:G11)","v":0}]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
["TOTAL PERSONNEL COSTS",null,null,null,null,{"$f":"SUM(F9:F16)","v":0},{"$f":"SUM(G9:G16)","v":0},{"$f":"SUM(H9:H16)","v":0}]

{"sheet":"Direct and Indirect Costs","index":2,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[[70,0,70,1],[5,0,5,3],[15,0,15,4],[25,0,25,1],[36,0,36,1],[47,0,47,1],[58,0,58,1]]}
["PRINCIPLES OF TRUSTWORTHINESS TOOLKIT PILOT PROJECT"]
["AAMC Center for Health Justice"]
[]
["Period of Performance: ","1 Year"]
[]
["CONSULTANT/CONTRACTOR"]
["Name","Hourly Rate","# of Hours"]
[null,0,0,{"$f":"B8*C8","v":0}]
[null,null,null,{"$f":"B9*C9","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total Consultant",null,null,{"$f":"SUM(D7:D13)","v":0}]
[]
["TRAVEL"]
["Item","# of persons","Days","Rate","Costs"]
["Ground Transportation - Mileage for local travel",null,null,null,{"$f":"B18*C18*D18","v":0}]
["Ground Transportation - Rideshare (i.e. Uber/Lyft)",null,null,null,{"$f":"B19*C19*D19","v":0}]
["Ground Transportation - Public Transportation",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Travel",null,null,null,{"$f":"SUM(E18:E23)","v":0}]
[]
["SUPPLIES"]
["Item","Costs"]
[]
[]
[]
[]
[]
[]
[]
["Total Supplies",{"$f":"SUM(B28:B34)","v":0}]
[]
["EQUIPMENT"]
["Item","Costs"]
[]
[]
[]
[]
[]
[]
[]
["Total Equipment",{"$f":"SUM(B39:B45)","v":0}]
[]
["SUBAWARDS"]
["Item","Costs"]
[]
[]
[]
[]
[]
[]
[]
["Total Subawards",{"$f":"SUM(B50:B56)","v":0}]
[]
["OTHER EXPENSES"]
["Item","Costs"]
["Meals"]
["Meeting Expenses"]
[]
[]
[]
[]
[]
["Total Other Expenses",{"$f":"SUM(B61:B67)","v":0}]
[]
[]
["INDIRECT COSTS"]
["Item","Costs"]
[]
[]
[]
[]
[]
[]
[]
["Total Indirect Costs",{"$f":"SUM(B73:B79)","v":0}]

{"sheet":"Travel Breakdown","index":3,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":true,"merged":[[149,9,149,12]]}
["Year 1, 2, 3",null,"TRAVEL DETAIL"]
[]
[null,null,null,null,null,null,"No. persons","Days","Rate","Cost"]
["AAMC Travel (Lisa Chew/Katy",null,null,null,null,null,null,null,0,{"$f":"G4*H4*I4","v":0}]
[null,null,null,null,null,"Transportation (airfare)",null,1,500,{"$f":"G5*H5*I5","v":0}]
[null,null,null,null,null,"Lodging",null,2,350,{"$f":"G6*H6*I6","v":0}]
[null,null,null,null,null,"meals",null,2,79,{"$f":"G7*H7*I7","v":0}]
[null,null,null,null,null,"Ground Transportation",null,2,30,{"$f":"G8*H8*I8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J8)","v":0},"per year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Year 2",null,"TRAVEL DETAIL"]
[]
[null,null,null,null,null,null,"no. persons","Days","Rate","Cost"]
[null,null,null,null,null,null,null,null,0,{"$f":"G22*H22*I22","v":0}]
[null,null,null,null,null,"Transportation (Airfare)",0,1,500,{"$f":"G23*I23*H23","v":0}]
[null,null,null,null,null,"Lodging",0,2,350,{"$f":"G24*I24*H24","v":0}]
[null,null,null,null,null,"meals",0,2,{"$f":"90-19","v":71},{"$f":"G25*I25*H25","v":0}]
[null,null,null,null,null,"Ground Transportation",0,2,25,{"$f":"G26*I26*H26","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22:J26)","v":0}]
[]
[]
[null,null,null,null,null,null,"No. persons","Days","Rate","Cost"]
[null,null,null,null,null,null,null,null,0,{"$f":"G31*H31*I31","v":0}]
[null,null,null,null,null,"Transportation (airfare)",0,1,500,{"$f":"G32*H32*I32","v":0}]
[null,null,null,null,null,"Lodging",0,1,350,{"$f":"G33*H33*I33","v":0}]
[null,null,null,null,null,"meals",0,1,{"$f":"90-19","v":71},{"$f":"G34*H34*I34","v":0}]
[null,null,null,null,null,"Ground Transportation",0,1,25,{"$f":"G35*H35*I35","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J31:J35)","v":0}]
[]
[]
["Year 3",null,"TRAVEL DETAIL"]
[]
[null,null,null,null,null,null,"no. persons","Days","Rate","Cost"]
[null,null,null,null,null,null,0,0,0,{"$f":"G42*H42*I42","v":0}]
[null,null,null,null,null,"Transportation (airfare)",0,1,500,{"$f":"G43*H43*I43","v":0}]
[null,null,null,null,null,"Lodging",0,2,350,{"$f":"G44*H44*I44","v":0}]
[null,null,null,null,null,"meals",0,2,{"$f":"90-19","v":71},{"$f":"G45*H45*I45","v":0}]
[null,null,null,null,null,"Ground Transportation",0,2,25,{"$f":"G46*H46*I46","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J42:J46)","v":0}]
[]
[]
[null,null,null,null,null,null,"no. persons","Days","Rate","Cost"]
[null,null,null,null,null,"Registration",0,1,1950,{"$f":"G51*H51*I51","v":0}]
[null,null,null,null,null,"Transportation (airfare)",0,1,500,{"$f":"G52*H52*I52","v":0}]
[null,null,null,null,null,"Lodging",0,3,350,{"$f":"G53*H53*I53","v":0}]
[null,null,null,null,null,"meals",0,3,{"$f":"90-19","v":71},{"$f":"G54*H54*I54","v":0}]
[null,null,null,null,null,"Ground Transportation",0,3,25,{"$f":"G55*H55*I55","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J51:J55)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"Transportation (airfare)",0,1,500,{"$f":"G61*H61*I61","v":0}]
[null,null,null,null,null,"Lodging",0,1,350,{"$f":"G62*H62*I62","v":0}]
[null,null,null,null,null,"meals",0,2,90,{"$f":"G63*H63*I63","v":0}]
[null,null,null,null,null,"Ground Transportation",0,2,25,{"$f":"G64*H64*I64","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J60:J64)","v":0}]