{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Detail"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":61,"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":"1900"}

{"sheet":"Summary","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Organization Name"]
[]
[null,null,"PROJECT: MAPs for PrEP: Dissolving microarray patches (MAPs) for long acting HIV and pregnancy prevention"]
[]
[]
[]
[]
[null,null,null,null,2020,null,2021,null,"TOTAL"]
["",null,"I. PERSONNEL",null,{"$f":"+Detail!I28","v":0},null,{"$f":"+Detail!M28","v":0},null,{"$f":"SUM(E10:H10)","v":0}]
[]
["",null,"II. FRINGE BENEFITS",null,{"$f":"+Detail!I31","v":{"$error":"#VALUE!"}},null,{"$f":"+Detail!M31","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(E12:H12)","v":{"$error":"#VALUE!"}}]
[""]
["",null,"III. TRAVEL",null,{"$f":"+Detail!I81","v":0},null,{"$f":"+Detail!M81","v":0},null,{"$f":"SUM(E14:H14)","v":0}]
[""]
["",null,"IV. EQUIPMENT",null,{"$f":"+Detail!I86","v":0},null,{"$f":"+Detail!M86","v":0},null,{"$f":"SUM(E16:H16)","v":0}]
[""]
["",null,"V. SUPPLIES",null,{"$f":"+Detail!I106","v":0},null,{"$f":"+Detail!M106","v":0},null,{"$f":"SUM(E18:H18)","v":0}]
[""]
["",null,"VI. CONTRACTUAL",null,{"$f":"+Detail!I126","v":0},null,{"$f":"+Detail!M126","v":0},null,{"$f":"SUM(E20:H20)","v":0}]
[""]
["",null,"VII. CONSTRUCTION",null,{"$f":"+Detail!I131","v":0},null,{"$f":"+Detail!M131","v":0},null,{"$f":"SUM(E22:H22)","v":0}]
["x"]
["x",null,"VIII. OTHER CATEGORIES",null,{"$f":"+Detail!I156","v":0},null,{"$f":"+Detail!M156","v":0},null,{"$f":"SUM(E24:H24)","v":0}]
[""]
[]
[]
["x",null,"TOTAL PROJECT COSTS",null,{"$f":"SUM(E10:E24)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(G10:G24)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(I10:I24)","v":{"$error":"#VALUE!"}}]
[]
[]
["end"]

{"sheet":"Detail","index":1,"n_rows":166,"n_cols":14,"rows_kept":166,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"NAME OF ORGANIZATIION"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"SALARY INFLATION:",null,0,null,null,null,3.5999999999999997E-2]
[null,null,null,null,null,null,"NEW HIRE SALARY INFLATION:",null,0,null,null,null,0]
[null,null,null,null,null,null,"OTHER INFLATION:",null,0,null,null,null,0]
[]
[null,"I. PERSONNEL",null,null,null,null,null,null,"5/1/2020-12/31/2020",null,null,null,"1/1/2021-6/30/2021","TOTAL"]
["",null,"TITLE"," ","NAME","Rate","Days",null,"Amount Requested","Rate","Days",null,"Amount Requested","Amount Requested"]
[null,null,null,null,null,null,null,null,{"$f":"ROUND((F14*G14),0)","v":0},null,null,null,{"$f":"ROUND((J14*K14),0)","v":0},{"$f":"+M14+I14","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"ROUND((F19*G19),0)","v":0},null,null,null,0,0]
["",null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,{"$f":"ROUND((F23*G23),0)","v":0},null,null,null,{"$f":"ROUND((J23*K23),0)","v":0},{"$f":"+M23+I23","v":0}]
[null,null,null,null,null,null,"______ ",null,"______ ",null,"______ ",null,"______ ","______ "]
[null,null,"   TOTAL SALARIES",null,null,null,{"$f":"SUM(G14:G24)","v":0},null,{"$f":"SUM(I14:I24)","v":0},null,{"$f":"SUM(K14:K24)","v":0},null,{"$f":"SUM(M14:M24)","v":0},{"$f":"SUM(N14:N24)","v":0}]
[]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null,"  TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(I25:I27)","v":0},null,null,null,{"$f":"SUM(M25:M27)","v":0},{"$f":"SUM(M28+I28)","v":0}]
[]
["","II. FRINGE BENEFITS"]
["","*","  TOTAL FRINGE BENEFITS",null,null,"%",null,null,{"$f":"ROUND(I28*$F$31,0)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"ROUND(M28*$F$31,0)","v":{"$error":"#VALUE!"}},{"$f":"SUM(M31+I31)","v":{"$error":"#VALUE!"}}]
[""]
["","III. TRAVEL"]
["",null,"A) International Travel"]
["",null,"From/To--Purpose","Airfare","Per Diem","Duration (Days)","# Trips","# Travelers",null,null,"# Trips","# Travelers"]
["",null,"Destination/Purpose",null,null,null,0,0,{"$f":"(E36*F36*H36) + (D36*H36)*G36","v":0},null,null,null,{"$f":"SUM(D36*L36)+(E36*F36*H4)*K36","v":0},{"$f":"M36+I36","v":0}]
["",null,"Destination/Purpose",null,null,null,null,null,{"$f":"SUM(D37*H37)+(E37*F37*H5)*G37","v":0},null,null,null,{"$f":"SUM(D37*L37)+(E37*F37*L37)*K37","v":0},{"$f":"M37+I37","v":0}]
["",null,"Destination/Purpose",null,null,null,null,null,{"$f":"ROUND(((($D38*G38*H38)+($E38*$F38*G38*H38))*I$10),0)","v":0},null,null,null,{"$f":"SUM(D38*L38)+(E38*F38*L38)*K38","v":0},0]
["",null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(D39*L39)+(E39*F39*L39)*K39","v":0},0]
["",null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUND(((($D40*K40*L40)+($E40*$F40*K40*L40))*M$10),0)","v":0},0]
["",null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUND(((($D41*K41*L41)+($E41*$F41*K41*L41))*M$10),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["",null,"    Total International Travel",null,null,null,null,null,{"$f":"SUM(I36:I41)","v":0},null,null,null,{"$f":"SUM(M36:M41)","v":0},0]
[""]
["",null,"B) Ground Transit",null,null,"Airport Transfer","# Trips","# Travelers",null,null,"# Trips","# Travelers"]
["",null,{"$f":"C36","v":"Destination/Purpose"},null,null,null,0,0,{"$f":"F46*G46*H46","v":0},null,null,null,{"$f":"F46*K46*L46","v":0},{"$f":"+M46+I46","v":0}]
[null,null,{"$f":"C37","v":"Destination/Purpose"},null,null,null,null,null,{"$f":"F47*G47*H47","v":0},null,null,null,{"$f":"F47*K47*L47","v":0},{"$f":"+M47+I47","v":0}]
[null,null,{"$f":"C38","v":"Destination/Purpose"},null,null,null,null,null,0,null,null,null,0,0]
[null,null,{"$f":"C39","v":0},null,null,null,null,null,0,null,null,null,0,0]
[null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,"      Total Ground Transit",null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"   TOTAL INTERNATIONAL TRAVEL",null,null,null,null,null,{"$f":"+I53+I43","v":0},null,null,null,{"$f":"+M53+M43","v":0},{"$f":"+N53+N43","v":0}]
[]
["",null,"C) In-Country Travel"]
["",null,"From/To--Purpose","Airfare or Train","Per Diem","Duration (Days)","# Trips","# Travelers",null,null,"# Trips","# Travelers"]
[]
[]
[]
[]
[]
["",null,null,null,null,null,null,null,{"$f":"ROUND(((($D64*G64*H64)+($E64*$F64*G64*H64))*I$10),0)","v":0},null,null,null,{"$f":"SUM(D64*L64)+(E64*F64*L64)*K64","v":0},{"$f":"+M64+I64","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"Total In-Country Travel",null,null,null,null,null,{"$f":"SUM(I64:I65)","v":0},null,null,null,{"$f":"SUM(M64:M65)","v":0},{"$f":"SUM(N64:N65)","v":0}]
[""]
[]
["",null,"D) In-Country Transit ",null,null,"Ground Transit (Taxi and Metro)","# Trips","# Travelers",null,null,"# Trips","# Travelers"]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(((($F70*G70*H70))*I$10),0)","v":0},null,null,null,{"$f":"F70*K70*L70","v":0},{"$f":"+M70+I70","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,{"$f":"C64","v":0},null,null,null,null,null,{"$f":"ROUND(((($F75*G75*H75))*I$10),0)","v":0},null,null,null,{"$f":"F75*K75*L75","v":0},0]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"      Total In-Country Transit",null,null,null,null,null,{"$f":"SUM(I75:I76)","v":0},null,null,null,{"$f":"SUM(M75:M76)","v":0},{"$f":"SUM(N75:N76)","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"   TOTAL IN-COUNTRY TRAVEL",null,null,null,null,null,{"$f":"+I77+I66","v":0},null,null,null,{"$f":"+M77+M66","v":0},{"$f":"+N77+N66","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"  TOTAL TRAVEL",null,null,null,null,null,{"$f":"+I79+I55","v":0},null,null,null,{"$f":"+M79+M55","v":0},{"$f":"+N79+N55","v":0}]
[""]
["","IV. EQUIPMENT** ",null,null,null,null,"Unit Cost","# of Units",null,null,"Unit Cost","# of Units"]
["",null,"Not applicable for this scope of work; see description at bottom of budget. Molds should be listed under supplies.",null,null,0,0,0,{"$f":"+$G84*H84*I$10","v":0},null,{"$f":"+G84*M$10","v":0},0,{"$f":"+$K84*L84","v":0},{"$f":"+M84+I84","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"  TOTAL EQUIPMENT",null,null,null,null,null,{"$f":"SUM(I84:I85)","v":0},null,null,null,{"$f":"SUM(M84:M85)","v":0},{"$f":"SUM(N84:N85)","v":0}]
[""]
[]
[null,"V. SUPPLIES "]
[null,null,"Item","Unit","Unit Cost",null,"# of Units",null,null,"Unit Cost",null,"# of Units"]
["",null,null,null,null,null,null,null,{"$f":"G91*E91","v":0},null,null,null,{"$f":"J91*L91","v":0},{"$f":"+M91+I91","v":0}]
["",null,null,null,null,null,null,null,{"$f":"G92*E92","v":0},null,null,null,{"$f":"J92*L92","v":0},0]
[null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"J93*L93","v":0},0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"______ "]
[null,null,"  TOTAL SUPPLIES",null,null,null,null,null,{"$f":"SUM(I91:I105)","v":0},null,null,null,{"$f":"SUM(M91:M105)","v":0},{"$f":"SUM(N91:N105)","v":0}]
[null,null,"SUPPLIES overhead base -->",null,null,null,null,null,{"$f":"+I106","v":0},null,null,null,{"$f":"+M106","v":0},{"$f":"+M107+I107","v":0}]
[]
[null,"VI. CONTRACTUAL COSTS"]
[]
["",null,"A) CONSULTANTS",null,null,null,null,"# Days",null,null,"$ Day","#  Days"]
["",null,null,null,null,null,null,null,{"$f":"+ROUND((($G112*H112)*I$10),0)","v":0},null,{"$f":"+G112*$M$10","v":0},null,{"$f":"+ROUND((K112*L112),0)","v":0},{"$f":"+M112+I112","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"  TOTAL CONSULTANTS",null,null,null,null,null,{"$f":"SUM(I112:I113)","v":0},null,null,null,{"$f":"SUM(M112:M113)","v":0},{"$f":"SUM(N112:N113)","v":0}]
[]
[null,null,"B) SUBAGREEMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M117+I117","v":0}]
[]
[null,null,"Total Subagreements",null,null,null,null,null,{"$f":"SUM(I117:I117)","v":0},null,null,null,{"$f":"SUM(M117:M117)","v":0},{"$f":"SUM(N117:N117)","v":0}]
[]
[null,null,"C) SUBCONTRACTS"]
[null,null,null,null,null,null,null,null,0,null,null,null,0,{"$f":"+M122+I122","v":0}]
[null,null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null," Total Subcontracts",null,null,null,null,null,{"$f":"SUM(I122:I123)","v":0},null,null,null,{"$f":"SUM(M122:M123)","v":0},{"$f":"SUM(N122:N123)","v":0}]
[null,null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null,"  TOTAL CONTRACTUAL COSTS",null,null,null,null,null,{"$f":"+I124+I119+I114","v":0},null,null,null,{"$f":"+M124+M119+M114","v":0},{"$f":"+N124+N119+N114","v":0}]
[]
[null,"VII. CONSTRUCTION"]
[null,null,"Not applicable for this scope of work",null,null,null,null,null,0,null,null,null,0,{"$f":"+M129+I129","v":0}]
[null,null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null,"  TOTAL CONSTRUCTION",null,null,null,null,null,{"$f":"SUM(I129:I130)","v":0},null,null,null,{"$f":"SUM(M129:M130)","v":0},{"$f":"SUM(N129:N130)","v":0}]
[]
["","VIII. OTHER CATEGORIES"]
[]
[null,null,"A) INTERNATIONAL VISAS & IMMUNIZATIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M136+I136","v":0}]
[null,null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null,"  TOTAL INTERNATIONAL VISAS & IMMUNIZATIONS",null,null,null,null,null,{"$f":"SUM(I136:I137)","v":0},null,null,null,{"$f":"SUM(M136:M137)","v":0},{"$f":"SUM(N136:N137)","v":0}]
[]
[null,null,"B) OTHER PROJECT COSTS"]
["",null,"Description","Unit",null,null,"Unit Cost","# Units",null,null,"Unit Cost","# Units"]
["",null,null,null,null,null,null,null,{"$f":"+ROUND((G142*H142),0)","v":0},null,null,null,{"$f":"+ROUND((K142*L142),0)","v":0},{"$f":"+M142+I142","v":0}]
["",null,null,null,null,null,null,null,{"$f":"+ROUND((G143*H143),0)","v":0},null,null,null,{"$f":"+ROUND((K143*L143),0)","v":0},{"$f":"+M143+I143","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+ROUND((G144*H144),0)","v":0},null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,null,null,null,0,null,null,null,0,0]
["",null,null,null,null,1.4455144003025586E-2,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["",null,null,null,null,1.3908934376180813E-2,null,null,0,null,null,null,0,0]
["",null,null,null,null,8.785119550935281E-3,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,"______ "]
[null,null,"  TOTAL OTHER PROJECT COSTS",null,null,null,null,null,{"$f":"SUM(I142:I153)","v":0},null,null,null,{"$f":"SUM(M142:M153)","v":0},{"$f":"SUM(N142:N153)","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
["",null,"  TOTAL OTHER CATEGORIES",null,null,null,null,null,{"$f":"+I138+I154","v":0},null,null,null,{"$f":"+M138+M154","v":0},{"$f":"+N138+N154","v":0}]
["",null,null,null,null,null,null,null,"______ ",null,null,null,"______ ","______ "]
[null,null,"TOTAL PROJECT COSTS"]
[null,null,null,null,null,null,null,null,{"$f":"+I156+I131+I126+I106+I86+I81+I31+I28","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"+M156+M131+M126+M106+M86+M81+M31+M28","v":{"$error":"#VALUE!"}},{"$f":"+N156+N131+N126+N106+N86+N81+N31+N28","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[null,null,"**US Government definition of equipment: non-expendable, tangible personal property, having a useful life of more than one year and an acquisition cost which equals or exceeds the lesser of the capitalization level established by the recipient organization for financial statement purposes, or $5,000"]