{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Recipient"],"not_rendered":{"images":1,"defined_names":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Recipient","index":0,"n_rows":40,"n_cols":9,"rows_kept":40,"merged":[[0,0,0,8],[2,1,2,6],[6,7,29,7]]}
["Estimated Budget - Annex 1"]
[]
["Name of the Recipient:",{"$nulls":6},"Date:"]
[]
[]
["Description","Quantity (up to)","Unit (e.g. person, vehicle, room, unit, …)","Quantity","Unit \n(e.g. months, days,  trainings, unit, …)","Eligible up to \nin local currency ","Total GIZ Contribution \nin local currency (up to)","Own Funds / Third party financing in local currency (up to) ","TOTAL \nin local currency (up to)"]
["1. Staff (Job Title) \n(Note: This budget line will be settled against payslips and, if partially financed, against payslips and time sheets.)",{"$nulls":5},{"$f":"SUM(G8:G11)","v":{"v":0,"d":"0.00 "}},"GIZ will be unable to finance partial costs within one budget line (with the exception of staff costs - position 1 - which can be financed partially). \nThe 'own funds / third party financing' will have to be used for different budget lines, which are not already financed from GIZ. ",{"$f":"SUM(I8:I11)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B8*D8*F8","v":{"v":0,"d":"0.00 "}},null,{"$f":"G8","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B9*D9*F9","v":{"v":0,"d":"0.00 "}},null,{"$f":"G9","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B10*D10*F10","v":{"v":0,"d":"0.00 "}},null,{"v":0,"d":"0.00 "}]
[{"$nulls":6},{"$f":"B11*D11*F11","v":{"v":0,"d":"0.00 "}},null,{"v":0,"d":"0.00 "}]
["2. External Experts / Consultant (Job Title) ",{"$nulls":5},{"$f":"SUM(G13:G15)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(I13:I15)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B13*D13*F13","v":{"v":0,"d":"0.00 "}},null,{"$f":"G13","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B14*D14*F14","v":{"v":0,"d":"0.00 "}},null,{"$f":"G14","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B15*D15*F15","v":{"v":0,"d":"0.00 "}},null,{"v":0,"d":"0.00 "}]
["3. Transportation / Travel Costs",{"$nulls":5},{"$f":"SUM(G17:G19)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(I17:I19)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B17*D17*F17","v":{"v":0,"d":"0.00 "}},null,{"$f":"G17","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B18*D18*F18","v":{"v":0,"d":"0.00 "}},null,{"$f":"G18","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B19*D19*F19","v":{"v":0,"d":"0.00 "}},null,{"$f":"G19","v":{"v":0,"d":"0.00 "}}]
["4. Training costs",{"$nulls":5},{"$f":"SUM(G21:G23)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(I21:I23)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B21*D21*F21","v":{"v":0,"d":"0.00 "}},null,{"$f":"G21","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B22*D22*F22","v":{"v":0,"d":"0.00 "}},null,{"$f":"G22","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B23*D23*F23","v":{"v":0,"d":"0.00 "}},null,{"v":0,"d":"0.00 "}]
["5. Procurement of Goods",{"$nulls":5},{"$f":"SUM(G25:G26)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(I25:I26)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B25*D25*F25","v":{"v":0,"d":"0.00 "}},null,{"$f":"G25","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B26*D26*F26","v":{"v":0,"d":"0.00 "}},null,{"$f":"G26","v":{"v":0,"d":"0.00 "}}]
["6. Other costs / Consumables",{"$nulls":5},{"$f":"SUM(G28:G30)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(I28:I30)","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B28*D28*F28","v":{"v":0,"d":"0.00 "}},null,{"$f":"G28","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B29*D29*F29","v":{"v":0,"d":"0.00 "}},null,{"$f":"G29","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":6},{"$f":"B30*D30*F30","v":{"v":0,"d":"0.00 "}},null,{"$f":"G30","v":{"v":0,"d":"0.00 "}}]
["Subtotal - Funding by GIZ \n(up to - against evidence)*                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ",null,null,{"$f":"G31/I35","v":{"$error":"#DIV/0!"}},"financing",null,{"$f":"G27+G24+G20+G16+G12+G7","v":{"v":0,"d":"0.00 "}},null,{"$f":"I27+I24+I20+I16+I12+I7","v":{"v":0,"d":"0.00 "}}]
["7. Own funds / third party financing",{"$nulls":6},{"$f":"SUM(SUM(H33:H34))","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(SUM(I33:I34))","v":{"v":0,"d":"0.00 "}}]
["ABC (name of the financing party)",1,"unit",{"$f":"F33/I35","v":{"$error":"#DIV/0!"}},"financing",null,null,{"$f":"F33","v":{"v":0,"d":"0.00 "}},{"$f":"H33","v":{"v":0,"d":"0.00 "}}]
["XYZ (name of the financing party)",1,"unit",{"$f":"F34/I35","v":{"$error":"#DIV/0!"}},"financing",null,null,{"$f":"F34","v":{"v":0,"d":"0.00 "}},{"$f":"H34","v":{"v":0,"d":"0.00 "}}]
["Gesamtfinanzierung ",{"$nulls":5},{"$f":"SUM(G7+G12+G16+G20+G27+G24)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(H32)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(I7+I12+I16+I20+I27+I32+I24)","v":{"v":0,"d":"0.00 "}}]
[]
[]
["*All budget lines will be settled against evidence."]
[]
["Information: In case of purchasing of goods and services from GIZ funds, the relevant 'procurement article' within the Agreement shall apply!"]