{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Detailed Budget","Summary Budget"],"read":"whole","date_system":"1900"}

{"sheet":"Detailed Budget","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,4,2],[3,3,3,6],[3,7,4,7],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,2],[14,0,14,1],[16,0,16,2],[19,0,19,1],[20,0,20,1],[22,0,22,1],[23,0,23,2],[25,0,25,1],[26,0,26,1],[27,0,27,2],[29,0,29,1],[30,0,30,1],[32,0,32,2],[34,2,34,6]]}
["Organization Name",{"$nulls":4},"Organization Name"]
["Project Title",{"$nulls":4},"Project Title"]
["Duration",{"$nulls":4},"Project Title"]
["        ",null,null,"Unit Cost",{"$nulls":3},"Total Requested Funds"]
[{"$nulls":3},"Unit","Number"," Amount  ","Rate"]
["A",null,"Personnel","Months    ",null,"salary           (month or year)","% effort"]
["A.1",null,"Personnel"]
["A.1.1.",{"$nulls":5},{"$f":"D8/A3","v":{"$error":"#VALUE!"}},{"$f":"F8*D8","v":0}]
["A.1.2.",{"$nulls":5},{"$f":"D9/A3","v":{"$error":"#VALUE!"}},{"$f":"F9*D9","v":0}]
["A.1.3.",{"$nulls":5},{"$f":"D10/A3","v":{"$error":"#VALUE!"}},0]
["A.1.4.",{"$nulls":5},{"$f":"D11/A3","v":{"$error":"#VALUE!"}},0]
["A.1.5.",{"$nulls":5},{"$f":"D12/A3","v":{"$error":"#VALUE!"}},0]
["Subtotal Personnel",{"$nulls":6},{"$f":"SUM(H8:H12)","v":0}]
["B",null,"Research Activities"]
["B.1",null,"(description, e.g. data collection)"]
["B.2",null,"(description, e.g. field work, other research activities)"]
["Subtotal Research Activities",{"$nulls":6},{"$f":"SUM(H15:H16)","v":0}]
["C",null,"Travel ","# people","# days","Cost","# trips"]
["C.1",null,"International Travel "]
["C.1.1.",null,"   International Airfare (from…to /RT)",{"$nulls":4},{"$f":"D20*F20*G20","v":{"v":0,"d":"0.00"}}]
["C.1.2.",null,"   Per Diem (City, Country)",{"$nulls":4},{"$f":"D21*E21*F21*G21","v":{"v":0,"d":"0.00"}}]
["C.2",null,"Domestic Travel ","Trip",null,"Cost"]
["C.2.1.",null,"   Domestic Transportation (e.g., taxi, meetings, venues, etc.)",{"$nulls":4},{"$f":"D23*F23","v":{"v":0,"d":"0.00"}}]
["Subtotal Travel",{"$nulls":6},{"$f":"SUM(H20,H21,H23)","v":{"v":0,"d":"0.00"}}]
["D",null,"Equipment  ",null,"# units","unit cost"]
["D.1",null,"(description, e.g. laptops)",{"$nulls":4},{"$f":"E26*F26","v":{"v":0,"d":"0.00"}}]
["D.2",null,"(description, e.g. software, cloud  services, apis, etc.)"]
["Subtotal Equipment",null,"Sub Total Equipment",{"$nulls":4},{"$f":"SUM(H26:H27)","v":{"v":0,"d":"0.00"}}]
["E",null,"Other Direct Costs"]
["E.1",null,"Publication (e.g., reports,infographic design, and printing)"]
["E.2",null,"Dissemination and capacity strengthening activities"]
["E.3",null,"Contracts and partners"]
["Subtotal Other Direct Costs ",{"$nulls":6},{"$f":"SUM(H30:H32)","v":{"v":0,"d":"0.00"}}]
["F",null,"Total Direct Costs",{"$nulls":4},{"$f":"SUM(H13,H17,H24,H28,H33)","v":{"v":0,"d":"0.00"}}]
["G",null,"Total Indirect Costs (13%)",{"$nulls":4},{"$f":"0.13*H34","v":{"v":0,"d":"0.00"}}]
["H",null,"Total Project Cost ",{"$nulls":4},{"$f":"H35+H34","v":0}]

{"sheet":"Summary Budget","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,4,2],[3,3,4,3]]}
["Organization Name"]
["Project Title"]
["Duration"]
["        ",null,null,"Total Project Budget"]
[]
["A",null,"Personnel",{"$f":"'Detailed Budget'!H13","v":{"v":0,"d":"0.0"}}]
["B",null,"Research Activities",{"$f":"'Detailed Budget'!H17","v":{"v":0,"d":"0.0"}}]
["C",null,"Travel ",{"$f":"'Detailed Budget'!H24","v":{"v":0,"d":"0.0"}}]
["D",null,"Equipment",{"$f":"'Detailed Budget'!H28","v":{"v":0,"d":"0.0"}}]
["E",null,"Other Direct Costs",{"$f":"'Detailed Budget'!H33","v":{"v":0,"d":"0.0"}}]
["F",null,"Total Direct Costs",{"$f":"'Detailed Budget'!H34","v":{"v":0,"d":"0.0"}}]
["G",null,"Total Indirect Costs",{"$f":"'Detailed Budget'!H35","v":{"v":0,"d":"0.0"}}]
["H",null,"Total",{"$f":"SUM(D6:D12)","v":{"v":0,"d":"0.00"}}]