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

{"sheet":"Recipient","index":0,"n_rows":169,"n_cols":10,"rows_kept":169,"merged":[[0,0,0,9],[2,1,2,6],[6,8,150,8],[32,2,32,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[55,2,55,6],[56,2,56,6],[57,2,57,6],[58,2,58,6],[59,2,59,6],[60,2,60,6],[61,2,61,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[73,2,73,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[80,2,80,6],[81,2,81,6],[82,2,82,6],[83,2,83,6],[84,2,84,6],[85,2,85,6],[86,2,86,6],[87,2,87,6],[88,2,88,6],[89,2,89,6],[90,2,90,6],[91,2,91,6],[92,2,92,6],[93,2,93,6],[94,2,94,6],[95,2,95,6],[96,2,96,6],[97,2,97,6],[98,2,98,6],[99,2,99,6],[100,2,100,6],[101,2,101,6],[102,2,102,6],[103,2,103,6],[104,2,104,6],[105,2,105,6],[106,2,106,6],[107,2,107,6],[108,2,108,6],[109,2,109,6],[110,2,110,6],[111,2,111,6],[112,2,112,6],[113,2,113,6],[114,2,114,6],[115,2,115,6],[116,2,116,6],[117,2,117,6],[118,2,118,6],[119,2,119,6],[120,2,120,6],[121,2,121,6],[122,2,122,6],[123,2,123,6],[124,2,124,6],[125,2,125,6],[126,2,126,6],[127,2,127,6],[128,2,128,6],[129,2,129,6],[130,2,130,6],[131,2,131,6],[132,2,132,6],[133,2,133,6],[134,2,134,6],[135,2,135,6],[136,2,136,6],[137,2,137,6],[138,2,138,6],[139,2,139,6],[140,2,140,6],[141,2,141,6],[142,2,142,6],[143,2,143,6],[144,2,144,6],[145,2,145,6],[145,9,150,9],[146,2,146,6],[147,2,147,6],[148,2,148,6],[149,2,149,6],[150,2,150,6],[151,2,151,6],[152,2,152,6],[153,2,153,6],[154,2,154,6],[155,2,155,6],[156,2,156,6],[157,7,157,8],[164,0,164,9],[166,0,166,9],[168,0,168,8]]}
["Estimated Budget - Annex 1"]
["Contract number:"]
["Name of the recipient:",{"$nulls":6},"Date:"]
[]
["CONFIDENTIAL"]
["Description","Code","Quantity (up to)","Unit  \n(person)","Quantity for section 1. staff","Unit \n(month, contract, compensation, procurement and  unit)","Eligible up to \nin local currency ","Total GIZ Contribution \nin local currency (up to)","Own contribution / Third party financing in local currency (up to) "]
["1.  Staff\n(Note: Only direct costs for staff (monthly gross costs for the employer) may be settled. Add-ons such as staff overheads that are calculated pro-rata for staff are not eligible for support. Please indicate job functions, no names of individual persons. Staff costs are:\n\na) Prime costs for employees of the Recipient (staff employed by your organization). The evidence for this budget line must be provided in the form of payslips or, in the case of pro rata working time for the financed project,  in the form of payslips and time sheets.\n\nb) Costs for integrated consultants (self-employed or employed by a third party and seconded to the Recipient) working under conditions similar to staff  employed by the Recipient, provided that this is legally permissible under the law applicable to the contract of the integrated consultant.** ",90010000,{"$nulls":5},{"$f":"SUM(H8:H32)","v":{"v":0,"d":"0.00 "}},"\n\n\n\n\n\n\nThe pro-rata financing of budget lines should be avoided and applied only to personnel costs, if applicable.\n\n \nCosts that are incurred as part of the implementation of the project but are not financed by GIZ are calculated separately either as own contribution or, if applicable, as financial contribution of a third party."]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C8*E8*G8","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C9*E9*G9","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C10*E10*G10","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C11*E11*G11","v":{"v":0,"d":"0.00 "}}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"v":0,"d":"0.00 "}]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C32*E32*G32","v":{"v":0,"d":"0.00 "}}]
["2. External services (type/content of service) (incl. event management)",90020000,{"$nulls":5},{"$f":"SUM(H34:H60)","v":{"v":0,"d":"0.00 "}}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
["3. Transportation / Travel Costs",90030000,{"$nulls":5},{"$f":"SUM(H62:H85)","v":{"v":0,"d":"0.00 "}}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["4. CO2-Compensation for flights",90190000,{"$nulls":5},{"$f":"SUM(H87:H92)","v":{"v":0,"d":"0.00 "}}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
["5. Procurement of materials and equipment",90040000,{"$nulls":5},{"$f":"SUM(H94:H116)","v":{"v":0,"d":"0.00 "}}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
["6. Medicine\n(Note: A seperate internal GIZ approval process is needed).",90080000,{"$nulls":5},{"$f":"SUM(H118:H123)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["7. Pesticides and/or mineral fertilizers\n(Note: A seperate internal GIZ approval process is needed).",90090000,{"$nulls":5},{"$f":"SUM(H125:H130)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["8. Other costs",90050000,{"$nulls":5},{"$f":"SUM(H132:H144)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["9. Construction measures\n(Note: Only simple, low-complexity construction work with a small volume may be carried out).\n",90070000,{"$nulls":5},{"$f":"SUM(H146:H151)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "},null,"Funds in % "]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Total GIZ funding - local contribution from GIZ (up to – on provision of evidence)*                                                                                                                                                                                                                                                                                                                                                                                                                                                         ",null,"financing",{"$nulls":4},{"$f":"H7+H33+H61+H86+H93+H117+H124+H131+H145","v":{"v":0,"d":"0.00 "}},null,{"$f":"H152/H158","v":{"$error":"#DIV/0!"}}]
["10. Own contribution / third party financing",90210000,{"$nulls":6},{"$f":"SUM(SUM(I154:I157))","v":{"v":0,"d":"0.00 "}}]
["ABC (name of the financing party)",null,"contribution",{"$nulls":5},{"v":0,"d":"0.00 "},{"$f":"I154/H158","v":{"$error":"#DIV/0!"}}]
["XYZ (name of the financing party)",null,"contribution",{"$nulls":5},{"v":0,"d":"0.00 "},{"$f":"I155/H158","v":{"$error":"#DIV/0!"}}]
["ABC (name of the financing party)",null,"contribution",{"$nulls":5},{"v":0,"d":"0.00 "},{"$f":"I156/H158","v":{"$error":"#DIV/0!"}}]
["XYZ (name of the financing party)",null,"contribution",{"$nulls":5},{"v":0,"d":"0.00 "},{"$f":"I157/H158","v":{"$error":"#DIV/0!"}}]
["Total financing",{"$nulls":6},{"$f":"H152+I153","v":{"v":0,"d":"0.00 "}},null,{"$f":"J152+J154+J155+J156+J157","v":{"$error":"#DIV/0!"}}]
[]
[]
["*All budget lines will be settled upon provision of evidence."]
[]
["Information: In case of purchasing of goods and services from GIZ funds, the relevant 'procurement article' within the Agreement shall apply!"]
[]
["Revenues and profits of the recipient cannot be financed! For example, where the recipient provides rooms for training, etc., the costs may not be settled under this contract."]
[]
["For contract supplements: Please adjust the budget based on the most recently agreed budget and highlight any changes in a different colour."]
[]
["** Integrated Consultants are individuals who are self-employed or employed by a third party and seconded to the Recipient and therefore not working on the basis of an employment contract with the Recipient, but who still work under the instructions/supervision of the Recipient under conditions similar to employees (in particular regarding the way the work is organised and the tasks are performed, e.g. under conditions of de facto subordination and as team members, and regarding the remuneration), provided that this is legally permissible under the law applicable to the contract of the Integrated Consultant. The costs for these Integrated Consultants must be reasonable and in line with the normal practice of the recipient, e.g. not significantly different from costs for employees of the Recipient performing similar tasks. Temporary workers therefore can also be Integrated Consultants if they are working under conditions similar to employees and the costs are reasonable and in line with the normal practice of the Recipient.\nIn general, the budget line does not refer to individual persons but to job functions (e.g. the function “Financial Manager”)"]

{"sheet":"Example","index":1,"n_rows":78,"n_cols":11,"rows_kept":78,"merged":[[0,0,0,9],[2,1,2,6],[6,8,61,8],[6,9,10,9],[6,10,10,10],[11,2,11,6],[11,9,18,9],[11,10,18,10],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[19,9,25,9],[19,10,25,10],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[26,9,31,9],[26,10,31,10],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[32,9,38,9],[32,10,38,10],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[49,9,50,9],[49,10,58,10],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[55,2,55,6],[56,2,56,6],[57,2,57,6],[58,2,58,6],[59,2,59,6],[60,2,60,6],[60,9,61,9],[61,2,61,6],[62,2,62,6],[63,2,63,6],[63,10,64,10],[64,2,64,6],[65,2,65,6],[66,7,66,8],[73,0,73,9],[75,0,75,9],[77,0,77,8]]}
["Estimated Budget - Annex 1"]
["Contract nummer:"]
["Name of the recipient:",{"$nulls":6},"Date:"]
[]
["CONFIDENTIAL"]
["Description","Code","Quantity (up to)","Unit \n(person)","Quantity for section 1. staff","Unit \n(month, contract,  procurement and  unit)","Eligible up to \nin local currency ","Total GIZ Contribution \nin local currency (up to)","Own contribution / Third party financing in local currency (up to) "]
["1. Staff\n(Note: Only direct costs for staff (monthly gross costs for the employer) may be settled. Add-ons such as staff overheads that are calculated pro-rata for staff are not eligible for support. Please indicate job functions, no names of individual persons. Staff costs are:\n\na) Prime costs for employees of the Recipient (staff employed by your organization). The evidence for this budget line must be provided in the form of payslips or, in the case of pro rata working time for the financed project,  in the form of payslips and time sheets.\n\nb) Costs for integrated consultants (self-employed or employed by a third party and seconded to the Recipient) working under conditions similar to staff  employed by the Recipient, provided that this is legally permissible under the law applicable to the contract of the integrated consultant.** ",90010000,{"$nulls":5},{"$f":"SUM(H8:H11)","v":{"v":94000,"d":"94,000.00 "}},"\n\n\n\n\n\n\n'The pro-rata financing of budget lines should be avoided and applied only to personnel costs, if applicable.\n\n \nCosts that are incurred as part of the implementation of the project but are not financed by GIZ are calculated separately either as own contribution or, if applicable, as financial contribution of a third party.",null,"The column \"Eligible for support up to\" should always indicate the monthly gross employer salary. Please state in column D the percentage that GIZ should finance. Statutory employee-related costs incurred under the respective employment contract law may be taken into account. As a general rule, social contributions are eligible for funding, as are payments that have been agreed in an employment contract or under a collective bargaining agreement (with the exception of bonus and profit-sharing payments). Any ancillary costs that do not fall under this category must be discussed and agreed, reviewed and noted in the budget line before the contract is prepared. Contracts for ‘mini-jobs’ or for students on temporary work are to be allocated to staff costs, even if no social contributions are incurred in this context.                                                                                                                                                                                   If funding is to be provided for several people on a pro-rata basis (e.g. three people working 75%), please increase the number of months as required and enter the number of people in the budget line description."]
["Project manager",null,{"v":1,"d":"100%"},"person ",20,"months",{"v":3000,"d":"3,000.00 "},{"$f":"C8*E8*G8","v":{"v":60000,"d":"60,000.00 "}}]
["Financial manager",null,{"v":0.5,"d":"50%"},"person ",20,"months",{"v":2200,"d":"2,200.00 "},{"$f":"C9*E9*G9","v":{"v":22000,"d":"22,000.00 "}}]
["Severance payment / statutory accruals",null,{"v":1,"d":"100%"},"person ",20,"months",{"v":600,"d":"600.00 "},{"$f":"C10*E10*G10","v":{"v":12000,"d":"12,000.00 "}}]
[{"$nulls":3},"person ",null,"months",null,{"$f":"C11*E11*G11","v":{"v":0,"d":"0.00 "}}]
["2. External services (type/content of service) (incl. event management)",90020000,{"$nulls":5},{"$f":"SUM(H13:H19)","v":{"v":7000,"d":"7,000.00 "}},null,null,"Enter the function title; no contract details (e.g. working hours); only state the planned value (the relevant guidelines governing contracts awards must be observed!); one budget line should be used for each service type; (all costs such as training, business trips incurred as part of service delivery under a service contract are displayed in one budget line).                                                                                                                                                                                                              Events: Services provided by the same provider should be displayed in one budget line. (e.g.: if a hotel provides both catering and the venue, these costs belong in a single budget line; if another hotel is booked for accommodation, then these costs belong in a separate line).\nAny items for which the recipient receives income when running the event cannot be financed under the contract (e.g. rental for rooms on own premises). Funding can only be provided for costs for which evidence can actually be provided."]
["Moderation services",null,"contract/contracts",{"$nulls":4},{"v":5000,"d":"5,000.00 "}]
["Catering and room rental",null,"contract/contracts",{"$nulls":4},{"v":2000,"d":"2,000.00 "}]
["Solar technology expert",null,"contract/contracts",{"$nulls":4},{"$f":"G15","v":{"v":0,"d":"0.00 "}}]
["Expert for …",null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
["External workers (not in employment relationship with the recipient that is subject to social insurance contribution)",null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Consultancy assignments",null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"contract/contracts",{"$nulls":4},{"v":0,"d":"0.00 "}]
["3. Transportation / Travel Costs",90030000,{"$nulls":5},{"$f":"SUM(H21:H26)","v":{"v":500,"d":"500.00 "}},null,null,"Travel costs usually include all types of transportation (e.g. fuel, vehicle hire, flight costs, bus transfer, mileage lumpsums (if budgeted), accommodation, per-diem allowances and visa charges). Costs are settled based on invoices and/or appropriate evidence for per-diems (e.g. allowances sheets signed by the participants).\n\nPlease do not enter the number of flights - any deviations must be covered by a contract supplement, and the number of flights will be checked should an audit be carried out."]
["International flights",null,"Unit",{"$nulls":4},{"v":500,"d":"500.00 "}]
["Domestic flights",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["International travel costs (per-diem/overnight accomodation allowance, means of transport, visa, required vaccination)",null,"Unit",{"$nulls":4},{"$f":"G23","v":{"v":0,"d":"0.00 "}}]
["Domestic travel costs (per-diem/overnight accomodation allowance, means of transport)",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Transportation cost for goods",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Travel cost for workshop participants",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["4. CO2-Compensation for flights",90190000,{"$nulls":5},{"$f":"SUM(H28:H32)","v":{"v":70,"d":"70.00 "}},null,null,"CO2 emissions caused by flights can - if avoidance and reduction is not possible - be compensated. The requirement is that these flights are settled in the \"Transportation / travel costs\" budget line. Evidence of the flight compensation costs are vouchers from the compensation provider, which must show the following information: Flight route (start and destination), date, booking class and the calculated amount of CO2. If this information is not stated on the compensation provider's vouchers, the information on the flight route (start, destination, date, booking class) and the calculated amount of CO2 must be added by the recipient."]
["international flights",null,"compensation",{"$nulls":4},{"v":50,"d":"50.00 "}]
["national flights",null,"compensation",{"$nulls":4},{"v":20,"d":"20.00 "}]
[null,null,"compensation",{"$nulls":4},{"$f":"G30","v":{"v":0,"d":"0.00 "}}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"compensation",{"$nulls":4},{"v":0,"d":"0.00 "}]
["5. Procurement of materials and equipment",90040000,{"$nulls":5},{"$f":"SUM(H34:H39)","v":{"v":4000,"d":"4,000.00 "}},null,null,"\nAny procured goods that are included in a single invoice should be displayed in one budget line. For example, you can list IT equipment in one budget line. In this case, you should specify in brackets what goods are likely to be procured. You must provide additional details for medicines and pesticides and mineral fertilizers as their procurement is subject to approval."]
["IT equipment (laptops, printers, overhead projectors, accessories)",null,"procurement",{"$nulls":4},{"v":4000,"d":"4,000.00 "}]
["Photographic equipment (camera and accessories)",null,"procurement",{"$nulls":4},{"$f":"G35","v":{"v":0,"d":"0.00 "}}]
["XY machine (specify the machine - not a particular company or mode)",null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Furniture (desks, chairs, cupboards)",null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Vehicles, specify type: e.g. electric car, armoured SUV, electric scooter",null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Mobile phones",null,"procurement",{"$nulls":4},{"v":0,"d":"0.00 "}]
["6. Medicine\n(Note: A seperate internal GIZ approval process is needed).",90080000,{"$nulls":5},{"$f":"SUM(H41:H44)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["7. Pesticides and/or mineral fertilizers\n(Note: A seperate internal GIZ approval process is needed).",90090000,{"$nulls":5},{"$f":"SUM(H46:H49)","v":{"v":0,"d":"0.00 "}}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
[null,null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["8. Other costs",90050000,{"$nulls":5},{"$f":"SUM(H51:H59)","v":{"v":100,"d":"100.00 "}},null,null,"Please note that indirect costs are classed as administration costs. Only actual project- related direct costs can be budgeted as individual budget lines. This means that costs can only be settled on provision of the relevant evidence.\nFor rental costs, only direct costs, i.e. basic rent exclusive of ancillary costs, can be calculated. Include ancillary costs as indirect costs, i.e. as administration costs.                                                                      \nUnlike procured goods, which are used over a long period of time, consumables are commodities that are used up, e.g. ink cartridges or printer paper."]
["Office materials (printer paper, ink, cartridges, stationery)",null,"unit",{"$nulls":4},{"v":100,"d":"100.00 "}]
["IT software, licenses",null,"unit",{"$nulls":4},{"$f":"G52","v":{"v":0,"d":"0.00 "}}]
["Packaging material for xxx",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Laboratory equipment and material",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Hygiene products",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Tools",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Water",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Flyers/advertising materials",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["Phone costs, phone cards, etc",null,"unit",{"$nulls":4},{"v":0,"d":"0.00 "}]
["9. Construction measures\n (Note: Only simple, low-complexity construction work with a small volume may be carried out).",90070000,{"$nulls":5},{"$f":"SUM(H61:H62)","v":{"v":0,"d":"0.00 "}}]
["Ceiling renovation",{"$nulls":6},{"v":0,"d":"0.00 "},null,"Funds in % "]
["Floor repair (10 m²)",{"$nulls":6},{"v":0,"d":"0.00 "}]
["Total GIZ funding - local contribution from GIZ (up to – on provision of evidence)*                                                                                                                                                                                                                                                                                                                                                                                                                                                         ",null,"financing",{"$nulls":4},{"$f":"H7+H12+H20+H27+H33+H40+H45+H50+H60","v":{"v":105670,"d":"105,670.00 "}},null,{"$f":"H63/H67","v":{"v":0.88,"d":"88%"}}]
["10. Own contribution / third party financing",90210000,{"$nulls":6},{"$f":"SUM(SUM(I65:I66))","v":{"v":15000,"d":"15,000.00 "}},null,"Only enter the overall value of own contibutions/the third-party financing. Include a brief outline of the proportional financing in the project description. "]
["ABC (name of the financing party)",null,"contribution",{"$nulls":5},{"v":5000,"d":"5,000.00 "},{"$f":"I65/H67","v":{"v":0.04,"d":"4%"}}]
["XYZ (name of the financing party)",null,"contribution",{"$nulls":5},{"v":10000,"d":"10,000.00 "},{"$f":"I66/H67","v":{"v":0.08,"d":"8%"}}]
["Total financing",{"$nulls":6},{"$f":"H63+I64","v":{"v":120670,"d":"120,670.00 "}},null,{"$f":"J63+J65+J66","v":{"v":1,"d":"100%"}}]
[]
[]
["*All budget lines will be settled upon provision of evidence."]
[]
["Information: In case of purchasing of goods and services from GIZ funds, the relevant 'procurement article' within the Agreement shall apply!"]
[]
["Revenues and profits of the recipient cannot be financed! For example, where the recipient provides rooms for training, etc., the costs may not be settled under this contract."]
[]
["For contract supplements: Please adjust the budget based on the most recently agreed budget and highlight any changes in a different colour."]
[]
["** Integrated Consultants are individuals who are self-employed or employed by a third party and seconded to the Recipient and therefore not working on the basis of an employment contract with the Recipient, but who still work under the instructions/supervision of the Recipient under conditions similar to employees (in particular regarding the way the work is organised and the tasks are performed, e.g. under conditions of de facto subordination and as team members, and regarding the remuneration), provided that this is legally permissible under the law applicable to the contract of the Integrated Consultant. The costs for these Integrated Consultants must be reasonable and in line with the normal practice of the recipient, e.g. not significantly different from costs for employees of the Recipient performing similar tasks. Temporary workers therefore can also be Integrated Consultants if they are working under conditions similar to employees and the costs are reasonable and in line with the normal practice of the Recipient.\nIn general, the budget line does not refer to individual persons but to job functions (e.g. the function “Financial Manager”)."]