{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Key data","Financing budget","Forwarding of funds","Example"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Key data","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[0,1,0,6],[0,9,0,14],[2,2,2,6],[4,2,4,4],[5,2,5,6],[6,2,6,6],[7,4,7,6],[8,4,8,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,2,20,6],[22,2,22,6]]}
[null,"Key data",{"$nulls":7},"Instructions for the grant recipient:\nPlease start by entering the key data before proceeding to the ‘Financing budget” tab.\nPlease only enter information in the blue cells. All other cells will be calculated automatically."]
[]
[null,"Name of the grant recipient: ",{"$nulls":5},{"$f":"IF(C3=\"Bitte eintragen\",\"- Bitte den Namen Ihres Vereins im Feld <Name des Zuschussempfängers> eintragen; \",\" \")","v":" "}]
[]
[null,"Is this the first budget \nor is an existing contract being modified?","First budget (no contract yet)",null,null,{"$f":"IF(C5=\"Modification to a contract\",\"How many times has the contract been modified?:\",\"\")","v":""},"Only select for modifications to a contract",{"$f":"IF(C5=\"Vertragsanpassung\",1,0)","v":0}]
[null,"Project title",{"$nulls":5},{"$f":"IF(C6=\"Veranstaltung\",1,IF(C6=\"Projekt\",1,0))","v":0}]
[null,"Agreement number"]
[null,"Do you require administration costs?",null,"Please enter the administration costs as a percentage ",{"$nulls":3},{"$f":"IF(C8=\"Ja, anderer Betrag\",1,0)","v":0}]
[null,"Are you providing a (financial) contribution of your own?","Select","Amount in EUR",{"$nulls":3},{"$f":"IF(C9=\"Ja, anderer Betrag\",1,0)","v":0}]
[null,"How many donors will be co-financing the project (in addition to GIZ)?","Select","Name of the provider of third-party funding",null,"Amount of third-party funding in EUR"]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR",null,{"$f":"IF(C11=\"Ja\",1,0)","v":0}]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR",null,{"$f":"IF(C12=\"Ja\",1,0)","v":0}]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR"]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR"]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR"]
[{"$nulls":3},"Name of the provider of third-party funding",null,"Amount of third-party funding in EUR"]
[null,"Will funds be forwarded to third-party recipients? (Please note, this does not relate to services) ","Select","This refers to third-party recipients that independently implement part of the recipient's project. A separate budget must be submitted and a commercial and legal eligibility check carried out by the GIZ project (needed criteria: legal entity and public-benefit nature). "]
[null,"Will medicines and/or pesticides and/or mineral fertilizers be procured?  ","Select","A separate internal GIZ approval process is needed."]
[null,"Will materials and equipment worth more than EUR 1,000,000 be procured or is more than 50% of the contract value earmarked for the procurement of materials and equipment for a contract worth at least EUR 400,000?","Select","A separate internal GIZ approval process is needed."]
[null,"Are construction measures being financed?  ","Select","A separate internal GIZ approval process is needed. \nPlease note that construction measures under local Contribution Contracts are only approved by GIZ in rare exceptions."]
[null,"Are tooltips to be displayed in the budget? \n‘Yes’ recommended for filling out the form\n‘No’ recommended for a better overview","yes"]
[]
[null,"Date of preparation of the budget:"]

{"sheet":"Financing budget","index":1,"n_rows":179,"n_cols":15,"rows_kept":179,"merged":[[0,0,0,8],[0,14,0,23],[1,0,1,9],[3,14,3,23],[4,1,4,7],[4,8,4,9],[5,3,5,7],[5,9,149,9],[43,3,43,7],[44,3,44,6],[45,3,45,6],[46,3,46,6],[47,3,47,6],[48,3,48,6],[49,3,49,6],[50,3,50,6],[51,3,51,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,3,58,6],[59,3,59,6],[60,3,60,6],[61,3,61,6],[62,3,62,6],[63,3,63,6],[64,3,64,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[69,3,69,6],[70,3,70,6],[71,3,71,6],[72,3,72,6],[73,3,73,7],[74,3,74,6],[75,3,75,6],[76,3,76,6],[77,3,77,6],[78,3,78,6],[79,3,79,6],[80,3,80,6],[81,3,81,6],[82,3,82,6],[83,3,83,6],[84,3,84,6],[85,3,85,6],[86,3,86,6],[87,3,87,6],[88,3,88,6],[89,3,89,6],[90,3,90,6],[91,3,91,6],[92,3,92,7],[93,3,93,6],[94,3,94,6],[95,3,95,6],[96,3,96,6],[97,3,97,6],[98,3,98,7],[99,3,99,6],[100,3,100,6],[101,3,101,6],[102,3,102,6],[103,3,103,6],[104,3,104,6],[105,3,105,6],[106,3,106,6],[107,3,107,6],[108,3,108,6],[109,3,109,6],[110,3,110,6],[111,3,111,6],[112,3,112,6],[113,3,113,6],[114,3,114,6],[115,3,115,7],[116,3,116,6],[117,3,117,6],[118,3,118,6],[119,3,119,6],[120,3,120,6],[121,3,121,6],[122,3,122,6],[123,3,123,6],[124,3,124,6],[125,3,125,6],[126,3,126,6],[127,3,127,6],[128,3,128,6],[129,3,129,6],[130,3,130,6],[131,3,131,6],[132,3,132,7],[133,4,133,6],[134,4,134,6],[135,4,135,6],[136,4,136,6],[137,4,137,6],[138,4,138,6],[139,4,139,6],[140,4,140,6],[141,4,141,6],[142,4,142,6],[143,3,143,7],[144,3,144,6],[145,3,145,6],[146,3,146,6],[147,3,147,6],[148,3,148,6],[149,1,149,7],[150,3,150,7],[151,4,151,6],[152,1,152,7],[153,3,153,7],[154,3,154,6],[155,3,155,6],[156,3,156,6],[157,3,157,6],[158,3,158,6],[159,3,159,6],[160,1,160,7],[161,3,161,7],[162,3,162,6],[163,3,163,6],[164,3,164,6],[165,3,165,6],[166,3,166,6],[167,3,167,6],[168,3,168,6],[169,3,169,6],[170,1,170,7],[170,8,170,9],[172,1,172,10],[174,1,174,9],[175,1,175,9],[176,1,176,9],[178,1,178,9]]}
[{"$f":"IF('Key data'!C3=\"\",\"Please fill out the 'Key data' tab first (see below)\",CONCATENATE(\"Budget - Annex 1\",CHAR(10),'Key data'!C3,\" - \",'Key data'!C6,\"\",'Key data'!E6,\"\",IF(L5=\"VE\",CONCATENATE(\" - \",'Key data'!G5,\"SUPPLEMENT TO THE CONTRACT\",\"\"),\"\")))","v":"Please fill out the 'Key data' tab first (see below)"},{"$nulls":8},{"$f":"'Key data'!C23","v":"00:00:00"},{"$nulls":3},"no change","Instructions:\nPlease fill out the key data sheet before proceeding to the 'Financing budget’ tab.\nOn this ‘Financing budget’ tab, please only enter information in the blue cells. All other cells will be calculated automatically."]
[{"$f":"IF(NOT(ISBLANK('Key data'!C7)),CONCATENATE(\"Agreement number: \",'Key data'!C7),\"\")","v":""}]
[{"$nulls":9},"2024-09",{"$nulls":3},"change"]
[null,"Description","Code","Quantity ","Unit (person)","Quantity","Unit (e.g. month, contract, flight...)","Eligible for support up to  \nin EUR \n(price per unit) ","Total \nGIZ funding\nin EUR (up to)","Own contributions / third-party financing\nin EUR (up to) ",null,{"$f":"IF($L$5=\"VE\",CONCATENATE(\"For contract modifications:\",CHAR(10),\"Has this budget line changed?\"),\"\")","v":""},null,null,"General information: \nThis budget format is used as a basis for settlement. You may create additional files with more detailed information for your own internal use.\nAll items listed in the budget must be included in the project description to ensure that the project reference is clear. \nThe table contains formulas that must be retained.  \nPlease keep the two-decimal-place format. \nWe advise rounding up units to the nearest full unit. Costs are agreed at a value of ‘up to’. "]
[{"$nulls":11},{"$f":"IF('Key data'!C5=\"Modification to a contract\",\"VE\",\"NOVE\")","v":"NOVE"}]
[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) 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, provided that this is legally permissible under the law applicable to the contract of the integrated consultant. For further requirements see Annex 3a: Requirements regarding budget and financial processing-giz.de ",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O5),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I7:I43)","v":{"v":0,"d":"0.00 €"}},"\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe pro-rata financing of budget lines should be avoided and applied only to personnel costs and fair-shared 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,{"$f":"IF(L5=\"VE\",\"PLEASE NOTE: GIZ cannot cover any costs that arise as a result of currency fluctuations.\",\"\")","v":""}]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D7*F7*H7,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D8*F8*H8,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D9*F9*H9,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D12*F12*H12,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D13*F13*H13,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D15*F15*H15,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D36*F36*H36,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D43*F43*H43,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[2,"External services (type/content of service)",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O11),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I45:I73)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"$f":"ROUND(H45,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"$f":"ROUND(H46,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[3,"Transportation / travel costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O22),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I75:I92)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H75,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H76,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H92,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[4,"CO2-Compensation for flights",null,{"$f":"IF('Key data'!C21=\"Yes\",CONCATENATE(\"Tooltip: \",Example!O30),\"\")","v":"Tooltip: 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."},{"$nulls":4},{"$f":"SUM(I94:I98)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Compensation",{"$nulls":4},{"$f":"ROUND(H94,2)","v":{"v":0,"d":"0.00 €"}},null,null,"no change"]
[{"$nulls":3},"Compensation",{"$nulls":4},{"$f":"ROUND(H95,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"no change"]
[{"$nulls":3},"Compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"no change"]
[5,"Procurement of materials and equipment",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O37),\"\")","v":"Tooltip:Any 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.  "},{"$nulls":4},{"$f":"SUM(I100:I115)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H100,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H101,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[6,"Other costs / consumables",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O48),\"\")","v":"Tooltip:Please note that indirect costs are classed as administration costs. Only direct costs can be budgeted as individual budget lines.\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."},{"$nulls":4},{"$f":"SUM(I117:I132)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H117,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H118,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[7,"Funds for direct support of third-party beneficiaries\n(Note: This budget line refers solely to financial contributions to third-party beneficiaries. These contributions should not be used for the purchase of medicines, pesticides and/or mineral fertilizers. The selection process for the third-party beneficiaries has to be described in the project description. Provision of evidence: see sub-budget line.)",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O59),\"\")","v":"Tooltip:Please take note of the information provided in the budget line. The provision of evidence must be agreed and indicated in the budget. The selection criteria are to be explained in the project description. \nNB: In this context, the term ‘third-party beneficiaries’ refers solely to individuals/entities that benefit from the recipient’s project. This includes start-up funding, funding for initiatives, cash-for-work, funding competitions, grants, etc. Arrangements on the provision of evidence must be agreed. You will need to contact the Contract Management Section for advice on specific details. "},{"$nulls":4},{"$f":"SUM(I134:I143)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D134*H134,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D135*H135,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[8,"Fair-Shared Costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O64),\"\")","v":"Tooltip:This budget line is only for organizations that operate with an allocation or apportionment of overhead costs in their accounting systems and can provide corresponding evidence, provided these costs are not assigned to administrative costs. The type of evidence required will be determined on an individual basis. A specific example is the percentage proof based on total costs and timesheets."},{"$nulls":4},{"$f":"SUM(I145:I149)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"$f":"ROUND(H145,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H146,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"Subtotal – direct costs",{"$nulls":6},{"$f":"I6+I44+I74+I93+I99+I116+I133+I144","v":{"v":0,"d":"0.00 €"}}]
[9,"Administration costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O68),\"\")","v":"Tooltip:The administration costs are normally covered by the recipient’s own contribution. GIZ can cover a small portion of such costs in cases where the recipient is unable to do so. The type and amount of the costs may have to be confirmed in advance by an auditor. The contract management section must be informed if the administration costs do not pertain to all budget lines."},{"$nulls":4},{"$f":"I152","v":{"v":0,"d":"0.00 €"}}]
[null,"Administration costs  (on budget lines 1 - X)",null,{"$f":"'Key data'!E8","v":{"v":0,"d":"0.00%"}},{"$nulls":3},{"$f":"I150","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(D152*H152,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"Subtotal – Funding by GIZ (up to – upon provision of evidence)*\n(direct costs + administration costs)",{"$nulls":6},{"$f":"I150+I151","v":{"v":0,"d":"0.00 €"}}]
[10,"Forwarding of funds to third-party recipients – a detailed budget must be provided –",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O71),\"\")","v":"Tooltip:These are third-party recipients (co-implementation partners) that independently implement part of the project. A separate budget must be submitted and a commercial and legal eligibility check must be carried out."},{"$nulls":4},{"$f":"SUM(I155:I160)","v":{"v":0,"d":"0.00 €"}}]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"$f":"'Forwarding of funds'!I144","v":{"v":0,"d":"0.00 €"}},{"$f":"H155","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"v":0,"d":"0.00 €"},{"$f":"H156","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"v":0,"d":"0.00 €"},{"$f":"H157","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":3},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},null,"Funds in % ","No change"]
[null,"GIZ funding (up to – upon provision of evidence)*",{"$nulls":6},{"$f":"I153+I154","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IFERROR(I161/$I$171,\"\")","v":""}]
[11,"Own Contributions / third-party financing",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O76),\"\")","v":"Tooltip:Only enter the overall value of own contibutions/the third-party financing. Include a brief outline of the proportional financing in the project description. "},{"$nulls":5},{"$f":"SUM(J163:J170)","v":{"v":0,"d":"0.00 €"}}]
[null,{"$f":"_xlfn.IFS('Key data'!C9=\"no\",\"no own contibution\",'Key data'!C9=\"yes\",'Key data'!C3,'Key data'!C9=\"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$9=\"Auswählen\", \"\",'Key data'!$C$9>0,'Key data'!E9, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"$f":"H163","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(J163/$I$171,\"\")","v":""},"No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E10,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G10, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"$f":"H164","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(J164/$I$171,\"\")","v":""},"No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E11,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G11, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},"","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E12,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G12, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},"","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10=\"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E13,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G13, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},"","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E14,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G14, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},"","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E15,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G15, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},"","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C10=0,\"No third-party financing\",'Key data'!C10= \"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C10>0,'Key data'!E16,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,"Contribution ",{"$nulls":3},{"$f":"_xlfn.IFS('Key data'!$C$10=\"Auswählen\", \"\",'Key data'!$C$10>0,'Key data'!G16, TRUE,\"\")","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},{"$f":"IFERROR(J170/$I$171,\"\")","v":""},"No change"]
[null,"Total funding",{"$nulls":6},{"$f":"I161+J162","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(K161:K170)","v":{"v":0,"d":"0.00%"}}]
[]
[null,"*All budget lines (with the exception of administration costs) are settled upon provision of evidence."]
[]
[null,"Please note: In cases where GIZ funding is to be provided for the award of contracts for external services and/or materials and equipment and/or goods, the relevant procurement guidelines must be observed in accordance with the contractual provisions."]
[]
[null,"Profits of the recipient will not be financed. "]
[]
[null,"For contract supplements: Please adjust the budget based on the most recently agreed budget and highlight any changes in a different colour. GIZ cannot bear costs that arise as a result of currency fluctuations."]

{"sheet":"Forwarding of funds","index":2,"n_rows":152,"n_cols":14,"rows_kept":152,"merged":[[0,0,0,1],[0,3,0,8],[1,0,1,9],[3,1,3,7],[3,8,3,9],[4,3,4,7],[4,9,139,9],[42,3,42,7],[43,3,43,6],[44,3,44,6],[45,3,45,6],[46,3,46,6],[47,3,47,6],[48,3,48,6],[49,3,49,6],[50,3,50,6],[51,3,51,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,3,58,6],[59,3,59,6],[60,3,60,7],[61,3,61,6],[62,3,62,6],[63,3,63,6],[64,3,64,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[69,3,69,6],[70,3,70,6],[71,3,71,6],[72,3,72,6],[73,3,73,6],[74,3,74,6],[75,3,75,6],[76,3,76,6],[77,3,77,7],[78,3,78,6],[79,3,79,6],[80,3,80,6],[81,3,81,6],[82,3,82,6],[83,3,83,6],[84,3,84,6],[85,3,85,6],[86,3,86,6],[87,3,87,6],[88,3,88,6],[89,3,89,6],[90,3,90,7],[91,3,91,6],[92,3,92,6],[93,3,93,6],[94,3,94,6],[95,3,95,6],[96,3,96,6],[97,3,97,6],[98,3,98,6],[99,3,99,6],[100,3,100,6],[101,3,101,6],[102,3,102,6],[103,3,103,6],[104,3,104,6],[105,3,105,6],[106,3,106,6],[107,3,107,7],[108,3,108,6],[109,3,109,6],[110,3,110,6],[111,3,111,6],[112,3,112,6],[113,3,113,6],[114,3,114,6],[115,3,115,6],[116,3,116,6],[117,3,117,6],[118,3,118,6],[119,3,119,6],[120,3,120,6],[121,3,121,6],[122,3,122,6],[123,3,123,6],[124,3,124,7],[125,4,125,6],[126,4,126,6],[127,4,127,6],[128,4,128,6],[129,4,129,6],[130,4,130,6],[131,3,131,7],[132,3,132,6],[133,3,133,6],[134,3,134,6],[135,3,135,6],[136,3,136,6],[137,3,137,6],[138,3,138,6],[139,1,139,7],[140,3,140,7],[141,4,141,6],[142,1,142,7],[143,1,143,7],[145,1,145,10],[147,1,147,9],[148,1,148,9],[149,1,149,9],[151,1,151,9]]}
["Budget- Annex 1",null,null,"Name of the third-party recipient: ",{"$nulls":5},{"$f":"'Key data'!C23","v":"00:00:00"},{"$nulls":3},"no change"]
[{"$f":"IF(NOT(ISBLANK('Key data'!C7)),CONCATENATE(\"Agreement number: \",'Key data'!C7),\"\")","v":""},{"$nulls":12},"change"]
[null,"Description","Code","Quantity","Unit (person)","Quantity","Unit (e.g. month, contract, flight...)","Eligible for support up to  \nin EUR \n(price per unit) ","Total \nGIZ funding\nin EUR (up to)","Own contributions / third-party financing\nin EUR (up to) ",null,{"$f":"IF($L$4=\"VE\",CONCATENATE(\"For contract modifications:\",CHAR(10),\"Has this budget line changed?\"),\"\")","v":""}]
[null,{"$f":"IF('Key data'!C21=\"yes\",\"Note: Blue fields to be filled in by the third-party recipient\",\"\")","v":"Note: Blue fields to be filled in by the third-party recipient"},{"$nulls":6},{"$f":"IF('Key data'!C21=\"yes\",\" Note: calculated automatically\",\"\")","v":" Note: calculated automatically"},null,null,{"$f":"IF('Key data'!C5=\"Modification to a contract\",\"VE\",\"NOVE\")","v":"NOVE"}]
[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) 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, provided that this is legally permissible under the law applicable to the contract of the integrated consultant. For further requirements see Annex 3a: Requirements regarding budget and financial processing-giz.de ",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O5),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I6:I42)","v":{"v":0,"d":"0.00 €"}},"\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe pro-rata financing of budget lines should be avoided and applied only to personnel costs and fair-shared 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,{"$f":"IF(L4=\"VE\",\"PLEASE NOTE: GIZ cannot cover any costs that arise as a result of currency fluctuations.\",\"\")","v":""}]
[{"$nulls":4},"person",1,"months",null,{"$f":"ROUND(D6*F6*H6,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D7*F7*H7,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D10*F10*H10,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D17*F17*H17,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"$f":"ROUND(D20*F20*H20,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"},null,null,"No change"]
[2,"External services (type/content of service)",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O11),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I44:I60)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"$f":"ROUND(H44,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"$f":"ROUND(H45,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[3,"Transportation / travel costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O22),\"\")","v":"Tooltip: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."},{"$nulls":4},{"$f":"SUM(I62:I77)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"$f":"ROUND(H62,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H63,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
["4","CO2-compensation for flights",null,{"$f":"IF('Key data'!C21=\"Yes\",CONCATENATE(\"Tooltip: \",Example!O30),\"\")","v":"Tooltip: 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."},{"$nulls":4},{"$f":"SUM(I79:I90)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"compensation",{"$nulls":4},{"$f":"ROUND(H79,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"$f":"ROUND(H80,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":3},"compensation",{"$nulls":4},{"$f":"ROUND(H90,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[5,"Procurement of materials and equipment",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O37),\"\")","v":"Tooltip:Any 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.  "},{"$nulls":4},{"$f":"SUM(I92:I107)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"$f":"ROUND(H92,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H93,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[6,"Other costs / consumables",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O48),\"\")","v":"Tooltip:Please note that indirect costs are classed as administration costs. Only direct costs can be budgeted as individual budget lines.\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."},{"$nulls":4},{"$f":"SUM(I109:I124)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"$f":"ROUND(H109,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H110,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H122,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H124,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[7,"Funds for direct support of third-party beneficiaries\n(Note: This budget line refers solely to financial contributions to third-party beneficiaries. These contributions should not be used for the purchase of medicines, pesticides and/or mineral fertilizers. The selection process for the third-party beneficiaries has to be described in the project description. Provision of evidence: see sub-budget line.)",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O59),\"\")","v":"Tooltip:Please take note of the information provided in the budget line. The provision of evidence must be agreed and indicated in the budget. The selection criteria are to be explained in the project description. \nNB: In this context, the term ‘third-party beneficiaries’ refers solely to individuals/entities that benefit from the recipient’s project. This includes start-up funding, funding for initiatives, cash-for-work, funding competitions, grants, etc. Arrangements on the provision of evidence must be agreed. You will need to contact the Contract Management Section for advice on specific details. "},{"$nulls":4},{"$f":"SUM(I126:I131)","v":{"v":0,"d":"0.00 €"}}]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D126*H126,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D127*H127,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D128*H128,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"$f":"ROUND(D129*H129,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XXX (Settled against ...)",{"$nulls":6},{"v":0,"d":"0.00 €"},null,null,"No change"]
[8,"Fair-Shared Costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O64),\"\")","v":"Tooltip:This budget line is only for organizations that operate with an allocation or apportionment of overhead costs in their accounting systems and can provide corresponding evidence, provided these costs are not assigned to administrative costs. The type of evidence required will be determined on an individual basis. A specific example is the percentage proof based on total costs and timesheets."},{"$nulls":4},{"$f":"SUM(I133:I139)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"$f":"ROUND(H133,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(H134,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[{"$nulls":8},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"Subtotal – direct costs",{"$nulls":6},{"$f":"I132+I125+I108+I91+I78+I61+I43+I5","v":{"v":0,"d":"0.00 €"}}]
[9,"Administration costs",null,{"$f":"IF('Key data'!C21=\"yes\",CONCATENATE(\"Tooltip:\",Example!O68),\"\")","v":"Tooltip:The administration costs are normally covered by the recipient’s own contribution. GIZ can cover a small portion of such costs in cases where the recipient is unable to do so. The type and amount of the costs may have to be confirmed in advance by an auditor. The contract management section must be informed if the administration costs do not pertain to all budget lines."},{"$nulls":4},{"$f":"I142","v":{"v":0,"d":"0.00 €"}}]
[null,"Administration costs (on budget lines 1-X)",null,{"v":0,"d":"0.00%"},{"$nulls":3},{"$f":"I140","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(D142*H142,2)","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"Subtotal – GIZ funding (up to – upon provision of evidence)*\n(direct costs + administration costs)",{"$nulls":6},{"$f":"I140+I141","v":{"v":0,"d":"0.00 €"}}]
[null,"GIZ funding (up to – upon provision of evidence)*",{"$nulls":6},{"$f":"I143","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"*All budget lines (with the exception of administration costs) are settled upon provision of evidence."]
[]
[null,"Please note: In cases where GIZ funding is to be provided for the award of contracts for external services and/or materials and equipment and/or goods, the relevant procurement guidelines must be observed in accordance with the contractual provisions."]
[]
[null,"Profits of the third-party recipient will not be financed."]
[]
[null,"For contract supplements: Please adjust the budget based on the most recently agreed budget and highlight any changes in a different colour. GIZ cannot bear costs that arise as a result of currency fluctuations."]

{"sheet":"Example","index":3,"n_rows":92,"n_cols":15,"rows_kept":92,"merged":[[0,0,0,8],[3,1,3,7],[3,8,3,9],[4,3,4,7],[4,9,66,9],[4,14,8,14],[10,3,10,7],[10,14,19,14],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6],[21,3,21,7],[21,14,28,14],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,7],[29,14,35,14],[30,3,30,6],[31,3,31,6],[32,3,32,6],[33,3,33,6],[34,3,34,6],[35,3,35,6],[36,3,36,7],[36,14,45,14],[37,3,37,6],[38,3,38,6],[39,3,39,6],[40,3,40,6],[41,3,41,6],[42,3,42,6],[43,3,43,6],[44,3,44,6],[45,3,45,6],[46,3,46,6],[47,3,47,7],[47,14,55,14],[48,3,48,6],[49,3,49,6],[50,3,50,6],[51,3,51,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,3,58,7],[58,14,61,14],[59,4,59,6],[60,4,60,6],[61,4,61,6],[62,4,62,6],[63,3,63,7],[63,14,65,14],[64,4,64,6],[65,4,65,6],[66,1,66,7],[67,2,67,7],[67,14,68,14],[68,4,68,6],[69,1,69,7],[70,3,70,7],[70,14,72,14],[71,3,71,6],[72,3,72,6],[73,3,73,6],[74,1,74,7],[75,3,75,7],[75,14,77,14],[76,3,76,6],[77,3,77,6],[78,3,78,6],[79,3,79,6],[80,1,80,7],[80,8,80,9],[82,1,82,10],[84,1,85,9],[86,1,86,9],[87,1,87,9],[89,1,89,9],[91,1,92,9],[91,14,93,14]]}
["Budget – Annex 1",{"$nulls":8},{"$f":"'Key data'!C34","v":"00:00:00"},{"$nulls":4},"Instructions:\nThis is merely intended to provide guidance in filling out the ‘Financing budget’ tab. "]
[]
[null,"Description","Code","Quantity ","Unit (person)","Quantity","Unit (e.g. month, contract, flight...)","Eligible for support up to  \nin EUR \n(price per unit) ","Total \nGIZ contribution\nin EUR (up to)","Own contributions / third-party financing\nin EUR (up to) ",{"$nulls":4},"General information: \nThis budget format is used as a basis for settlement. You may create additional files with more detailed information for your own internal use.\nAll items listed in the budget must be included in the project description to ensure that the project reference is clear. \nThe table contains formulas that must be retained.  \nPlease keep the two-decimal-place format. \nWe advise rounding up units to the nearest full unit. Costs are agreed at a value of ‘up to’. "]
[null,"Note: Blue fields to be filled in by the recipient",{"$nulls":6},"Note: calculated automatically",{"$nulls":5},"Notes on filling out the table"]
[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) 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, provided that this is legally permissible under the law applicable to the contract of the integrated consultant. For further requirements see Annex 3a: Requirements regarding budget and financial processing-giz.de ",null,"",{"$nulls":4},{"$f":"SUM(I6:I10)","v":{"v":94000,"d":"94,000.00 €"}},"\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe pro-rata financing of budget lines should be avoided and applied only to personnel costs and fair-shared costs, if applicable.\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":4},"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."]
[null,"Project manager",null,{"v":1,"d":"100%"},"person",20,"months",{"v":3000,"d":"3,000.00 €"},{"$f":"D6*F6*H6","v":{"v":60000,"d":"60,000.00 €"}}]
[null,"Financial manager ",null,{"v":0.5,"d":"50%"},"person",20,"months",{"v":2200,"d":"2,200.00 €"},{"$f":"D7*F7*H7","v":{"v":22000,"d":"22,000.00 €"}}]
[null,"Severance payments / statutory accruals ",null,{"v":1,"d":"100%"},"person",20,"months",{"v":600,"d":"600.00 €"},{"v":12000,"d":"12,000.00 €"}]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"}]
[{"$nulls":4},"person",null,"months",null,{"v":0,"d":"0.00 €"}]
[2,"External services (type/content of service)\n",null,"",{"$nulls":4},{"$f":"SUM(I12:I21)","v":{"v":7000,"d":"7,000.00 €"}},{"$nulls":5},"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."]
[null,"Moderation services",null,"Contract/Contracts",{"$nulls":3},{"v":5000,"d":"5,000.00 €"},{"$f":"ROUND(H12,2)","v":{"v":5000,"d":"5,000.00 €"}}]
[null,"Catering and room rental",null,"Contract/Contracts",{"$nulls":3},{"v":2000,"d":"2,000.00 €"},{"$f":"ROUND(H13,2)","v":{"v":2000,"d":"2,000.00 €"}}]
[null,"Solar technology expert",null,"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"Expert for…",null,"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"External workers (not in an employment relationship with recipient that is subject to social insurance contributions)",null,"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"Consultancy assignments",null,"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"External companies, e.g. for bus transport",null,"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[{"$nulls":3},"Contract/Contracts",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[3,"Transportation / travel costs",null,"",{"$nulls":4},{"$f":"SUM(I23:I29)","v":{"v":14500,"d":"14,500.00 €"}},{"$nulls":5},"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."]
[null,"International flights",null,"Flight",{"$nulls":3},{"v":4000,"d":"4,000.00 €"},{"$f":"H23","v":{"v":4000,"d":"4,000.00 €"}}]
[null,"Domestic flights",null,"Flight",{"$nulls":3},{"v":500,"d":"500.00 €"},{"$f":"H24","v":{"v":500,"d":"500.00 €"}}]
[null,"International travel costs (per-diem/overnight accommodation allowance, means of transport, visa, required vaccinations)",null,"Unit",{"$nulls":3},{"v":10000,"d":"10,000.00 €"},{"v":10000,"d":"10,000.00 €"}]
[null,"Domestic travel costs (per-diem/overnight accommodation allowance, means of transport)",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"Transportation costs for goods",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[null,"Travel costs for workshop participants",null,"Unit",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[{"$nulls":3},"Unit",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[4,"CO2-Compensation for flights",{"$nulls":6},{"$f":"SUM(I31:I36)","v":{"v":500,"d":"500.00 €"}},{"$nulls":5},"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."]
[null,"International flights",null,"Compensation",{"$nulls":3},{"v":300,"d":"300.00 €"},{"$f":"H31","v":{"v":300,"d":"300.00 €"}}]
[null,"Domestic flights",null,"Compensation",{"$nulls":3},{"v":200,"d":"200.00 €"},{"$f":"H32","v":{"v":200,"d":"200.00 €"}}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[5,"Procurement of materials and equipment",null,"",{"$nulls":4},{"$f":"SUM(I38:I47)","v":{"v":4000,"d":"4,000.00 €"}},{"$nulls":5},"Any 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.  "]
[null,"IT equipment (laptops, printers, overhead projectors, accessories)",null,"Procurement",{"$nulls":3},{"v":4000,"d":"4,000.00 €"},{"$f":"ROUND(H38,2)","v":{"v":4000,"d":"4,000.00 €"}}]
[null,"Photographic equipment (camera and accessories)",{"$nulls":6},{"$f":"ROUND(H39,2)","v":{"v":0,"d":"0.00 €"}}]
[null,"XY machine (specify the machine – not a particular company or model)",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Furniture (desks, chairs, cupboards)",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Vehicles, specify type:  e.g. electric car, armoured SUV, electric scooter",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Mobile phones",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"in kind contributions to third-party beneficiares (evidence in  form of procurement vouchers and handover records)",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[6,"Other costs / consumables",{"$nulls":6},{"$f":"SUM(I49:I58)","v":{"v":100,"d":"100.00 €"}},{"$nulls":5},"Please note that indirect costs are classed as administration costs. Only direct costs can be budgeted as individual budget lines.\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."]
[null,"Office materials (printer paper, ink cartridges, stationery)",null,"Unit",{"$nulls":3},{"v":100,"d":"100.00 €"},{"$f":"ROUND(H49,2)","v":{"v":100,"d":"100.00 €"}}]
[null,"IT software, licenses",{"$nulls":6},{"$f":"ROUND(H50,2)","v":{"v":0,"d":"0.00 €"}}]
[null,"Packaging material for xxx",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Laboratory equipment and materials",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Hygiene products",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Tools",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Water",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Flyers/advertising materials",{"$nulls":6},{"v":0,"d":"0.00 €"}]
[null,"Phone costs, phone cards, etc",{"$nulls":6},{"$f":"ROUND(H57,2)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[7,"Funds for direct support of third-party beneficiaries\n(Note: This budget line refers solely to financial contributions to third-party beneficiaries. These contributions should not be used for the purchase of medicines, pesticides and/or mineral fertilizers. The selection process for the third-party beneficiaries has to be described in the project description. Provision of evidence: see sub-budget line.)",{"$nulls":6},{"$f":"SUM(I60:I63)","v":{"v":75600,"d":"75,600.00 €"}},{"$nulls":5},"Please take note of the information provided in the budget line. The provision of evidence must be agreed and indicated in the budget. The selection criteria are to be explained in the project description. \nNB: In this context, the term ‘third-party beneficiaries’ refers solely to individuals/entities that benefit from the recipient’s project. This includes start-up funding, funding for initiatives, cash-for-work, funding competitions, grants, etc. Arrangements on the provision of evidence must be agreed. You will need to contact the Contract Management Section for advice on specific details. "]
[null,"Cash-for-work (settled against provision of lists of paticipants, confirmation of receipt by signature or fingerprint; selection process is described in the project description)",null,20,"People",null,null,{"v":30,"d":"30.00 €"},{"$f":"D60*H60","v":{"v":600,"d":"600.00 €"}}]
[null,"Start-up financing (settlement is based on proof of actual use by the third-party beneficiary); Art.5.2 of the contract applies",null,5,"Start-ups",null,null,{"v":15000,"d":"15,000.00 €"},{"$f":"D61*H61","v":{"v":75000,"d":"75,000.00 €"}}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"v":0,"d":"0.00 €"}]
[8,"Fair-Shared Costs",{"$nulls":6},{"$f":"SUM(I65:I66)","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},"This budget line is only for organizations that operate with an allocation or apportionment of overhead costs in their accounting systems and can provide corresponding evidence, provided these costs are not assigned to administrative costs. The type of evidence required will be determined on an individual basis. A specific example is the percentage proof based on total costs and timesheets."]
[null,"direct fair-shared costs (6.42% of the direct costs of budget lines 1-6, based on the recipient fair-shared cost model)",null,null,"Unit",{"$nulls":3},{"$f":"D65*H65","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"Unit",{"$nulls":3},{"$f":"D66*H66","v":{"v":0,"d":"0.00 €"}}]
[null,"Subtotal – direct costs",{"$nulls":6},{"$f":"I5+I11+I22+I30+I37+I48+I59+I64","v":{"v":195700,"d":"195,700.00 €"}}]
[9,"Administration costs",{"$nulls":6},{"$f":"I69","v":{"v":9785,"d":"9,785.00 €"}},{"$nulls":5},"The administration costs are normally covered by the recipient’s own contribution. GIZ can cover a small portion of such costs in cases where the recipient is unable to do so. The type and amount of the costs may have to be confirmed in advance by an auditor. The contract management section must be informed if the administration costs do not pertain to all budget lines."]
[null,"Administration costs  (on budget lines 1-8)",null,{"v":0.05,"d":"5.00%"},{"$nulls":3},{"$f":"I67","v":{"v":195700,"d":"195,700.00 €"}},{"$f":"ROUND(D69*H69,2)","v":{"v":9785,"d":"9,785.00 €"}}]
[null,"Subtotal – Funding by GIZ (up to – upon provision of evidence)*\n(direct costs + administration costs)",{"$nulls":6},{"$f":"I67+I68","v":{"v":205485,"d":"205,485.00"}}]
[10,"Forwarding of funds to third-party recipients – a detailed budget must be provided ",{"$nulls":6},{"$f":"SUM(I72:I74)","v":{"v":10000,"d":"10,000.00 €"}},{"$nulls":5},"These are third-party recipients (co-implementation partners) that independently implement part of the project. A separate budget must be submitted and a commercial and legal eligibility check must be carried out."]
[null,"OPQ",null,"Forwarding of funds",{"$nulls":3},{"v":10000,"d":"10,000.00 €"},{"$f":"H72","v":{"v":10000,"d":"10,000.00 €"}}]
[null,"XYZ (name of the third-party recipient) ",null,"Forwarding of funds",{"$nulls":4},{"$f":"H73","v":{"v":0,"d":"0.00 €"}}]
[null,"XYZ (name of the third-party recipient)",null,"Forwarding of funds",{"$nulls":4},{"v":0,"d":"0.00 €"},null,"Funds in %"]
[null,"GIZ funding (up to – upon provision of evidence)*",{"$nulls":6},{"$f":"I70+I71","v":{"v":215485,"d":"215,485.00 €"}},{"$f":"I75","v":{"v":215485,"d":"215,485.00 €"}},{"$f":"J75/$I$81","v":{"v":0.9349198429398876,"d":"93.49%"}}]
[11,"Own Contributions/third-party financing",{"$nulls":7},{"$f":"SUM(J77:J80)","v":{"v":15000,"d":"15,000.00 €"}},{"$nulls":4},"Only enter the overall value of own contibutions/the third-party financing. Include a brief outline of the proportional financing in the project description. "]
[null,"ABC (own contribution)",null,"Contribution ",{"$nulls":3},{"v":5000,"d":"5,000.00 €"},null,{"$f":"H77","v":{"v":5000,"d":"5,000.00 €"}},{"$f":"J77/$I$81","v":{"v":0.021693385686704123,"d":"2.17%"}}]
[null,"DEF (third-party financing)",null,"Contribution ",{"$nulls":3},{"v":10000,"d":"10,000.00 €"},null,{"$f":"H78","v":{"v":10000,"d":"10,000.00 €"}},{"v":0.043386771373408246,"d":"4.34%"}]
[{"$nulls":3},"Contribution "]
[{"$nulls":3},"Contribution "]
[null,"Total financing",{"$nulls":6},{"$f":"I75+J76","v":{"v":230485,"d":"230,485.00 €"}},null,{"$f":"SUM(K75:K80)","v":{"v":1,"d":"100.00%"}}]
[]
[null,"*All budget lines (with the exception of administration costs) are settled upon provision of evidence."]
[]
[null,"Please note: In cases where GIZ funding is to be provided for the award of contracts for external services and/or materials and equipment and/or goods, the relevant procurement guidelines must be observed in accordance with the contractual provisions."]
[]
[]
[null,"Profits of the recipient will not be financed."]
[]
[null,"Self-prepared vouchers for the use of the  beneficiary's (third- party's) internal facilities and spaces may be submitted, provided that it is confirmed that\na) it involves reallocation of the beneficiary's (third-party's) costs within its own organization; GIZ reserves the right to randomly verify the self-costs\nb) the use of comparable facilities at market prices does not result in cost savings."]
[]
[null,"For contract supplements: Please adjust the budget based on the most recently agreed budget and highlight any changes in a different colour. GIZ cannot cover any costs that arise as a result of currency fluctuations.",{"$nulls":12},"Explain the re-allocation of budget funds in the request to modify a contract. A reason must be given particularly in cases where staff costs have increased."]