{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["3d_covering note","3e_breakdown of actual costs","3f_totals per category","3e_breakdown Sub-Grant","3f_totals Sub-Grant"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":15,"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":"3d_covering note","index":0,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[29,3,29,11],[28,4,28,7],[34,6,34,11],[35,7,35,11],[23,8,23,9],[26,4,26,5],[26,7,26,8],[51,0,51,6],[29,0,29,2],[3,3,4,5],[0,0,0,10],[3,7,3,8],[6,9,6,11],[7,9,7,11],[3,9,5,11],[6,7,6,8],[4,7,4,8],[5,3,5,5],[6,3,6,5],[7,3,7,5],[7,7,7,8],[8,3,8,5],[23,10,23,11],[9,9,9,11],[8,9,8,11],[8,7,8,8],[9,7,9,8],[24,8,24,9],[24,10,24,11],[10,3,10,7],[20,5,20,8],[21,5,21,8]]}
["Financial Statement - Covering Note"]
[]
["The Recipient"]
["Name:",null,null,null,null,null,null,"Name and place"]
[null,null,null,null,null,null,null,"of Bank:"]
["Adress:"]
[null,null,null,null,null,null,null,"Account number:"]
[null,null,null,null,null,null,null,"Bank code:"]
[null,null,null,null,null,null,null,"SWIFT/BIC"]
[null,null,null,null,null,null,null,"IBAN"]
["E-Mail:"]
[]
[]
["Deutsche Gesellschaft für Internationale"]
["Zusammenarbeit (GIZ) GmbH"]
["Friedrich-Ebert-Allee 36"]
["53113 Bonn"]
["Germany"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-04-04"}]
["Project Processing No.:"]
["Agreement No.:"]
[]
["Financial Statement",null,null,null,null,null,null,null,"Statement-No.:"]
[null,null,null,null,null,null,null,null,"Reference-No.:"]
[]
["for the period from",null,null,null,null,null,"to"]
[]
["in the amount of €",null,null,null,{"$f":"IF('3f_totals per category'!C22=0,\"\",'3f_totals per category'!C22)","v":""},null,null,null,"(automatically transfer from annex 3f)"]
["in words:"]
[]
["I hereby confirm that the attached financial statement is fully and correctly provided for the"]
["above mentioned period."]
["Declaration on co-financing (if applicable):"]
["We confirm that the co-financing parties "]
["have met their contribution to the amount of"]
["Declaration:"]
["The actual costs to be financed from the GIZ grant have not been financed from other subsidies."]
[]
["The following information is attached (please tick):"]
[null,"Totals per category"]
[null,"breakdown of actual costs per category"]
[null,"proof by the bank of the amount credited for "]
[null,"disbursement by GIZ"]
[null,"information on interest"]
[null,"inventory of goods "]
[null,"handing over certificate"]
[null,"other"]
[]
[]
[]
[]
["Date and original signature of the Recipient"]

{"sheet":"3e_breakdown of actual costs","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,6,2,7],[3,0,3,1],[29,2,30,2],[29,4,29,7],[30,4,30,7],[4,0,4,1],[5,0,5,1],[29,0,30,1],[1,2,1,7]]}
["Financial Statement - Breakdown of actual costs per category  - Recipient"]
["Recipient:",null,{"$f":"IF('3d_covering note'!D4=\"\",\"\",'3d_covering note'!D4)","v":""}]
["Project Processing No.:",null,{"$f":"IF('3d_covering note'!F21=\"\",\"\",'3d_covering note'!F21)","v":""},"Agreement No.:",{"$f":"IF('3d_covering note'!F22=\"\",\"\",'3d_covering note'!F22)","v":""}]
["Budget line:"]
["Period from:",null,{"$f":"IF('3d_covering note'!E27=\"\",\"\",'3d_covering note'!E27)","v":""}]
["to:",null,{"$f":"IF('3d_covering note'!H27=\"\",\"\",'3d_covering note'!H27)","v":""}]
[]
[{"$f":"ROMAN(1)","v":"I"},{"$f":"ROMAN(2)","v":"II"},{"$f":"ROMAN(3)","v":"III"},{"$f":"ROMAN(4)","v":"IV"},{"$f":"ROMAN(5)","v":"V"},{"$f":"ROMAN(6)","v":"VI"},{"$f":"ROMAN(7)","v":"VII"},{"$f":"ROMAN(8)","v":"VIII"},{"$f":"ROMAN(9)","v":"IX"}]
["no. of vouch-er","Internal voucher number of the\nRecipient","Date of \nvoucher","Name of the Recipient\nfrom voucher/evidence","Reason for payment\n(detailled content of voucher/evidence)","Currency \nof voucher","Amount \nof voucher\n","Exchange rate*\n","Actual costs in the currency of Grant Agreement\n\n€"]
[1,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",\"\",G10*H10)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(G11=\"\",\"\",G11*H11)","v":""}]
[3,null,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total",null,null,null,{"$f":"SUM(I10:I29)","v":0}]
[null,null,null,null,"(please transfer to \"totals per category\")"]
[]
[]
[]
[]
[null,"*real exchange rate or after written approval of GIZ-Financial Management InforEuro or an own comparable system"]

{"sheet":"3f_totals per category","index":2,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,1,4,3],[20,0,20,1],[10,0,10,1],[11,0,11,1],[14,2,14,4],[15,2,15,4],[20,2,20,4],[19,2,19,4],[18,2,18,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[0,0,0,9],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[7,2,7,4],[8,2,8,4],[6,2,6,4],[9,5,9,6],[6,5,6,6],[9,2,9,4],[7,5,7,6],[8,5,8,6],[1,1,1,10],[2,1,2,3],[2,6,2,7],[33,0,33,1],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[20,5,20,6],[21,5,21,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[16,2,16,4],[27,2,27,6],[23,0,23,1],[21,0,21,1],[13,2,13,4],[28,2,28,6],[10,5,10,6],[23,2,23,4],[24,0,24,7],[11,5,11,6],[12,5,12,6],[21,2,21,4],[17,0,17,1],[19,0,19,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[18,0,18,1],[17,2,17,4],[12,0,12,1]]}
["Financial Statement - Totals per categories (budget lines) - Recipient"]
["Recipient:",{"$f":"IF('3d_covering note'!D4=\"\",\"\",'3d_covering note'!D4)","v":""}]
["Project Processing No.:",{"$f":"IF('3d_covering note'!F21=\"\",\"\",'3d_covering note'!F21)","v":""},null,null,null,"Agreement No.:",{"$f":"IF('3d_covering note'!F22=\"\",\"\",'3d_covering note'!F22)","v":""}]
["Period from:",{"$f":"IF('3d_covering note'!E27=\"\",\"\",'3d_covering note'!E27)","v":""}]
["to:",{"$f":"IF('3d_covering note'!H27=\"\",\"\",'3d_covering note'!H27)","v":""}]
[]
[{"$f":"ROMAN(1)","v":"I"},null,{"$f":"ROMAN(2)","v":"II"},null,null,{"$f":"ROMAN(3)","v":"III"},null,{"$f":"ROMAN(4)","v":"IV"},{"$f":"ROMAN(5)","v":"V"},{"$f":"ROMAN(6)","v":"VI"},{"$f":"ROMAN(7)","v":"VII"}]
["Category \n(budget line according Grant article 1.2)",null,"Actual costs\nfor the current period\n(transfer from \nbreakdown/Annex 3e)",null,null,null,null,"Actual costs from previous periods","Total agreed amount of budget lines according to Grant article 1.2","Rest \nbudget \nin","Rest budget\nin"]
[null,null,"€",null,null,"Only for GIZ",null,"€","€","€","%"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",I10-H10-C10)","v":""},{"$f":"IF(J10=\"\",\"\",J10/I10)","v":""}]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J11=\"\",\"\",J11/I11)","v":""}]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
["Total €",null,{"$f":"SUM(C10:C21)","v":0},null,null,null,null,{"$f":"SUM(H10:H21)","v":0},{"$f":"SUM(I10:I21)","v":0},{"$f":"SUM(J10:J21)","v":0}]
[]
["current amount of advance or pre instalment payments/deposits  which are no actual cost until this above-mentioned period, but forwarded to third parties",null,0]
["* in the case of more than one forwarding of funds, a corresponding list must be attached"]
[]
["Declaration on co-financing according to article 1.6 (if applicable):"]
["We confirm that the co-financing parties "]
["have met their contribution to the amount of"]
[]
["Declaration: The actual costs to be financed from the GIZ grant have not been financed from other subsidies."]
[]
[]
[]
["Date and original signature of the Recipient"]

{"sheet":"3e_breakdown Sub-Grant","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,2,1,7],[3,6,3,7],[4,0,4,1],[5,0,5,1],[2,2,2,7],[30,0,31,1],[30,2,31,2],[30,4,30,7],[31,4,31,7],[6,0,6,1]]}
["Financial Statement - Breakdown of actual costs per category - Sub-Grant/Forwarding of funds "]
["Recipient:",null,{"$f":"IF('3d_covering note'!D4=\"\",\"\",'3d_covering note'!D4)","v":""}]
["Sub-Grant/Forwarding of ..:"]
["Project Processing No.:",null,{"$f":"IF('3d_covering note'!F21=\"\",\"\",'3d_covering note'!F21)","v":""},"Agreement No.:",{"$f":"IF('3d_covering note'!F22=\"\",\"\",'3d_covering note'!F22)","v":""}]
["Budget line:"]
["Period from:",null,{"$f":"IF('3d_covering note'!E27=\"\",\"\",'3d_covering note'!E27)","v":""}]
["to:",null,{"$f":"IF('3d_covering note'!H27=\"\",\"\",'3d_covering note'!H27)","v":""}]
[]
[{"$f":"ROMAN(1)","v":"I"},{"$f":"ROMAN(2)","v":"II"},{"$f":"ROMAN(3)","v":"III"},{"$f":"ROMAN(4)","v":"IV"},{"$f":"ROMAN(5)","v":"V"},{"$f":"ROMAN(6)","v":"VI"},{"$f":"ROMAN(7)","v":"VII"},{"$f":"ROMAN(8)","v":"VIII"},{"$f":"ROMAN(9)","v":"IX"}]
["no. of vouch-er","Internal voucher number of the\nRecipient","Date of \nvoucher","Name of the Recipient\nfrom voucher/evidence","Reason for payment\n(detailled content of voucher/evidence)","Currency \nof voucher","Amount \nof voucher\n","Exchange rate*\n","Actual costs in the currency of Grant Agreement\n\n€"]
[1,null,null,null,null,null,null,null,{"$f":"IF(G11=\"\",\"\",G11*H11)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(G12=\"\",\"\",G12*H12)","v":""}]
[3,null,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total",null,null,null,{"$f":"SUM(I11:I30)","v":0}]
[null,null,null,null,"(please transfer to \"totals per category\")"]
[]
[]
[]
[null,"*real exchange rate or after written approval of GIZ-Financial Management InforEuro or an own comparable system"]

{"sheet":"3f_totals Sub-Grant","index":4,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,1,5,3],[0,0,0,9],[1,1,1,10],[3,1,3,3],[3,6,3,7],[4,1,4,3],[2,1,2,10],[7,0,7,1],[7,2,7,4],[7,5,7,6],[8,0,8,1],[8,2,8,4],[8,5,8,6],[9,0,9,1],[9,2,9,4],[9,5,9,6],[10,0,10,1],[10,2,10,4],[10,5,10,6],[11,0,11,1],[11,2,11,4],[11,5,11,6],[12,0,12,1],[12,2,12,4],[12,5,12,6],[13,0,13,1],[13,2,13,4],[13,5,13,6],[14,0,14,1],[14,2,14,4],[14,5,14,6],[15,0,15,1],[15,2,15,4],[15,5,15,6],[16,0,16,1],[16,2,16,4],[16,5,16,6],[17,0,17,1],[17,2,17,4],[17,5,17,6],[18,0,18,1],[18,2,18,4],[18,5,18,6],[19,0,19,1],[19,2,19,4],[19,5,19,6],[20,0,20,1],[20,2,20,4],[20,5,20,6],[21,0,21,1],[21,2,21,4],[21,5,21,6],[22,0,22,1],[22,2,22,4],[22,5,22,6],[24,0,24,1],[24,2,24,4],[25,0,25,7],[28,2,28,6],[29,2,29,6]]}
["Financial Statement - Totals per categories (budget lines) - Sub-Grant/Forwarding of funds "]
["Recipient:",{"$f":"IF('3d_covering note'!D4=\"\",\"\",'3d_covering note'!D4)","v":""}]
["Sub-Grant/Forwarding of ..:"]
["Project Processing No.:",{"$f":"IF('3d_covering note'!F21=\"\",\"\",'3d_covering note'!F21)","v":""},null,null,null,"Agreement No.:",{"$f":"IF('3d_covering note'!F22=\"\",\"\",'3d_covering note'!F22)","v":""}]
["Period from:",{"$f":"IF('3d_covering note'!E27=\"\",\"\",'3d_covering note'!E27)","v":""}]
["to:",{"$f":"IF('3d_covering note'!H27=\"\",\"\",'3d_covering note'!H27)","v":""}]
[]
[{"$f":"ROMAN(1)","v":"I"},null,{"$f":"ROMAN(2)","v":"II"},null,null,{"$f":"ROMAN(3)","v":"III"},null,{"$f":"ROMAN(4)","v":"IV"},{"$f":"ROMAN(5)","v":"V"},{"$f":"ROMAN(6)","v":"VI"},{"$f":"ROMAN(7)","v":"VII"}]
["Category \n(budget line according Grant article 1.2)",null,"Actual costs\nfor the current period\n(transfer from \nbreakdown/Annex 3e)",null,null,null,null,"Actual costs from previous periods","Total agreed amount of budget lines according to Grant article 1.2","Rest \nbudget \nin","Rest budget\nin"]
[null,null,"€",null,null,"Only for GIZ",null,"€","€","€","%"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C11=\"\",\"\",I11-H11-C11)","v":""},{"$f":"IF(J11=\"\",\"\",J11/I11)","v":""}]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J12=\"\",\"\",J12/I12)","v":""}]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
["Total €",null,{"$f":"SUM(C11:C22)","v":0},null,null,null,null,{"$f":"SUM(H11:H22)","v":0},{"$f":"SUM(I11:I22)","v":0},{"$f":"SUM(J11:J22)","v":0}]
[]
["current amount of advance or pre instalment payments/deposits which are no actual cost until this above-mentioned period but forwarded to third parties",null,0]
["* in the case of more than one forwarding of funds, a corresponding list must be attached"]
[]
[]
[]
[]
[]
["Declaration: The actual costs to be financed from the GIZ grant have not been financed from other subsidies."]