{"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":22,"n_cols":10,"rows_kept":22,"merged":[[0,1,0,6],[0,9,0,14],[2,2,2,6],[4,2,4,4],[5,2,5,6],[6,4,6,6],[7,4,7,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,2,19,6],[21,2,21,6]]}
[null,"Key data",{"$nulls":7},"Instructions for the financing 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 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?","Select",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,"Do you require administration costs?","Select","Please enter the administration costs as a percentage ",{"$nulls":3},{"$f":"IF(C7=\"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(C8=\"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(C10=\"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(C11=\"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 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."]
[null,"Are tooltips to be displayed in the budget? \n‘Yes’ recommended for filling out the form\n‘No’ recommended for a better overview","Select"]
[]
[null,"Date of budget finalisation:"]

{"sheet":"Financing budget","index":1,"n_rows":172,"n_cols":15,"rows_kept":172,"merged":[[0,0,0,8],[0,14,0,23],[2,14,2,23],[3,1,3,7],[3,8,3,9],[4,3,4,7],[4,9,142,9],[42,3,42,7],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[53,4,53,6],[54,4,54,6],[55,4,55,6],[56,4,56,6],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,4,60,6],[61,4,61,6],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[66,4,66,6],[67,4,67,6],[68,4,68,6],[69,4,69,6],[70,4,70,6],[71,4,71,6],[72,3,72,7],[73,4,73,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[80,4,80,6],[81,4,81,6],[82,4,82,6],[83,4,83,6],[84,4,84,6],[85,4,85,6],[86,4,86,6],[87,4,87,6],[88,4,88,6],[89,4,89,6],[90,4,90,6],[91,3,91,7],[92,4,92,6],[93,4,93,6],[94,4,94,6],[95,4,95,6],[96,4,96,6],[97,4,97,6],[98,4,98,6],[99,4,99,6],[100,4,100,6],[101,4,101,6],[102,4,102,6],[103,4,103,6],[104,4,104,6],[105,4,105,6],[106,4,106,6],[107,4,107,6],[108,3,108,7],[109,4,109,6],[110,4,110,6],[111,4,111,6],[112,4,112,6],[113,4,113,6],[114,4,114,6],[115,4,115,6],[116,4,116,6],[117,4,117,6],[118,4,118,6],[119,4,119,6],[120,4,120,6],[121,4,121,6],[122,4,122,6],[123,4,123,6],[124,4,124,6],[125,3,125,7],[136,3,136,7],[142,1,142,7],[143,3,143,7],[146,3,146,7],[154,3,154,7],[163,1,163,7],[163,8,163,9],[165,1,165,10],[167,1,167,9],[168,1,168,9],[169,1,169,9],[171,1,171,9]]}
[{"$f":"IF('Key data'!C3=\"\",\"Please fill out the 'Key data' tab first (see below)\",CONCATENATE(\"Estimated Budget - Annex 1\",CHAR(10),'Key data'!C3,\" - \",'Key data'!C6,\"\",'Key data'!E6,\"\",IF(L4=\"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'!C22","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."]
[{"$nulls":13},"change"]
[null,"Description","Code","Quantity ","Unit (e.g. person, vehicle, room)","Quantity","Unit (e.g. months, days, courses)","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,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’. "]
[null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Note: Blue fields to be filled in by \",IF('Key data'!C3=\"\",\"the recipient\",'Key data'!C3)),\"\")","v":""},{"$nulls":6},{"$f":"IF('Key data'!C20=\"yes\",\" Note: calculated automatically\",\"\")","v":""},null,null,{"$f":"IF('Key data'!C5=\"Modification to a contract\",\"VE\",\"NOVE\")","v":"NOVE"}]
[1,"Staff - prime cost for employees of the Recipient (job title)\n(Note 1: Only staff from your organisation; the evidence for this budget line must be provided in the form of payslips or, in the case of partial financing, in the form of payslips and time sheets.\nNote 2: Only direct costs for staff (gross cost for the employer) may be settled. Add-ons such as staff overheads that are calculated pro-rata for staff are not eligible for support)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O5),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I6:I42)","v":{"v":0,"d":"0.00"}},"GIZ is unable to provide pro-rata financing for any of the budget lines (with the exception of staff costs (item 1) which can be covered on a percentage basis, or costs that fall under the cost category ‘Pro-rata local project costs’ (item 7)). \n\nCosts that are incurred as part of the implementation of the project but are not funded 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},"people",null,"months",null,{"$f":"ROUND(D6*F6*H6,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D7*F7*H7,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D14*F14*H14,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D35*F35*H35,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[2,"External services (type/content of service)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O11),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I44:I72)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"$f":"ROUND(D44*H44,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"$f":"ROUND(D45*H45,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"$f":"ROUND(D51*H51,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[3,"Transportation/travel costs",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O22),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I74:I91)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D74*H74,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D75*H75,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},{"v":0,"d":"0.00"},null,null,"No change"]
[4,"Procurement of materials and equipment",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O34),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I93:I108)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D93*H93,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D94*H94,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},{"$f":"ROUND(D97*H97,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"]
[5,"Other costs/consumables",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O45),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I110:I125)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D110*H110,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D111*H111,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D112*H112,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(D114*H114,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"]
[6,"Funds for direct support of third-party beneficiaries\n(Note: This budget line should preferably cover in-kind contributions, i.e. contribution of materials and equipment, to third-party beneficiaries. In the case of financial contributions, proof of payment has to be regulated. The selection process for the third-party beneficiaries has to be described in the project description.)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O56),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I127:I136)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D127*F127*H127,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D128*F128*H128,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D129*F129*H129,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"]
[7,"Pro-rata local project costs (e.g. IT, research)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O61),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I138:I142)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D138*F138*H138,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D139*F139*H139,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":"I109+I92+I43+I5+I73+I126+I137","v":{"v":0,"d":"0.00"}}]
[8,"Administration costs",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O65),\"\")","v":""},{"$nulls":4},{"$f":"I145","v":{"v":0,"d":"0.00"}}]
[null,"Administration costs  (on budget lines 1 - 7)",null,{"$f":"'Key data'!E7","v":{"v":0,"d":"0%"}},{"$nulls":3},{"$f":"I143","v":{"v":0,"d":"0.00"}},{"$f":"ROUND(D145*H145,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":"I143+I144","v":{"v":0,"d":"0.00"}}]
[9,"Forwarding of funds to third-party recipients – a detailed budget must be provided –",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O68),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I148:I153)","v":{"v":0,"d":"0.00"}}]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"$f":"'Forwarding of funds'!I147","v":{"v":0,"d":"0.00"}},{"$f":"D148*F148*H148","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"v":0,"d":"0.00"},{"$f":"D149*F149*H149","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"v":0,"d":"0.00"},{"$f":"D150*F150*H150","v":{"v":0,"d":"0.00 €"}},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"v":0,"d":"0.00"},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"v":0,"d":"0.00"},{"v":0,"d":"0.00 €"},null,null,"No change"]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",{"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":"I146+I147","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IFERROR(I154/$I$164,\"\")","v":""}]
[10,"Own Contributions/third-party financing",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O73),\"\")","v":""},{"$nulls":5},{"$f":"SUM(J156:J163)","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"_xlfn.IFS('Key data'!C8=\"no\",\"no own contibution\",'Key data'!C8=\"yes\",'Key data'!C3,'Key data'!C8=\"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,1,"Unit",1,"Contribution ",{"$f":"IF('Key data'!C8=\"yes\",'Key data'!E8,\"\")","v":""},null,{"$f":"H156","v":""},{"$f":"IFERROR(J156/$I$164,\"\")","v":""},"No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E9,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G9, TRUE,\"\")","v":""},null,"",{"$f":"IFERROR(J157/$I$164,\"\")","v":""},"No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E10,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G10, TRUE,\"\")","v":""},null,"","","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E11,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G11, TRUE,\"\")","v":""},null,"","","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E12,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G12, TRUE,\"\")","v":""},null,"","","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\", \"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E13,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G13, TRUE,\"\")","v":""},null,"","","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E14,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G14, TRUE,\"\")","v":""},null,"","","No change"]
[null,{"$f":"_xlfn.IFS('Key data'!C9=0,\"No third-party financing\",'Key data'!C9= \"Select\",\"Please ensure that you have entered all necessary information in the 'key data' worksheet\",'Key data'!C9>0,'Key data'!E15,TRUE,\"\")","v":"Please ensure that you have entered all necessary information in the 'key data' worksheet"},null,1,"Unit",1,"Contribution ",{"$f":"_xlfn.IFS('Key data'!$C$9=\"Select\", \"\",'Key data'!$C$9>0,'Key data'!G15, TRUE,\"\")","v":""},null,{"$f":"H163","v":""},{"$f":"IFERROR(J163/$I$164,\"\")","v":""},"No change"]
[null,"Total funding",{"$nulls":6},{"$f":"I154+J155","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(K154:K163)","v":{"v":0,"d":"0%"}}]
[]
[null,"*All budget lines (with the exception of administration costs and pro-rata local project 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,"No income may be generated from the funds provided! For example, where the recipient provides rooms for training, etc., the costs may not be settled under this contract."]
[]
[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":155,"n_cols":14,"rows_kept":155,"merged":[[0,3,0,8],[3,1,3,7],[3,8,3,9],[4,3,4,7],[4,9,142,9],[42,3,42,7],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[53,4,53,6],[54,4,54,6],[55,4,55,6],[56,4,56,6],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,4,60,6],[61,4,61,6],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[66,4,66,6],[67,4,67,6],[68,4,68,6],[69,4,69,6],[70,4,70,6],[71,4,71,6],[72,3,72,7],[73,4,73,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[80,4,80,6],[81,4,81,6],[82,4,82,6],[83,4,83,6],[84,4,84,6],[85,4,85,6],[86,4,86,6],[87,4,87,6],[88,4,88,6],[89,4,89,6],[90,4,90,6],[91,3,91,7],[92,4,92,6],[93,4,93,6],[94,4,94,6],[95,4,95,6],[96,4,96,6],[97,4,97,6],[98,4,98,6],[99,4,99,6],[100,4,100,6],[101,4,101,6],[102,4,102,6],[103,4,103,6],[104,4,104,6],[105,4,105,6],[106,4,106,6],[107,4,107,6],[108,3,108,7],[125,3,125,7],[136,3,136,7],[143,3,143,7],[148,1,148,9],[150,1,150,9],[151,1,151,9],[152,1,152,9],[154,1,154,9]]}
[null,"Estimated Budget- Annex 1",null,"Name of the third-party recipient: ",{"$nulls":5},{"$f":"'Key data'!C22","v":"00:00:00"},{"$nulls":3},"no change"]
[{"$nulls":13},"change"]
[null,"Description","Code","Quantity","Unit (e.g. person, vehicle, room)","Quantity","Unit (e.g. months, days, courses)","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'!C20=\"yes\",\"Note: Blue fields to be filled in by the third-party recipient\",\"\")","v":""},{"$nulls":6},{"$f":"IF('Key data'!C20=\"yes\",\" Note: calculated automatically\",\"\")","v":""},null,null,{"$f":"IF('Key data'!C5=\"Modification to a contract\",\"VE\",\"NOVE\")","v":"NOVE"}]
[1,"Staff - prime cost for employees of the Recipient (job title)\n(Note 1: Only staff from your organisations; the evidence for this budget line must be provided in the form of payslips or, in the case of partial financing, in the form of payslips and time sheets.\nNote 2: Only direct costs for staff (gross cost for the employer) may be settled. Add-ons such as staff overheads that are calculated pro-rata for staff are not eligible for support)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O5),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I6:I42)","v":{"v":0,"d":"0.00"}},"GIZ is unable to provide pro-rata financing for any of the budget lines (with the exception of staff costs (item 1) which can be covered on a percentage basis, or costs that fall under the cost category ‘Pro-rata local project costs’ (item 7)). \n\nCosts that are incurred as part of the implementation of the project but are not funded 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},"people",null,"months",null,{"$f":"ROUND(D6*F6*H6,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D7*F7*H7,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D10*F10*H10,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"$f":"ROUND(D20*F20*H20,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"},null,null,"No change"]
[2,"External services (type/content of service)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O11),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I44:I72)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"Contract",{"$nulls":3},{"$f":"ROUND(D44*H44,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"$f":"ROUND(D45*H45,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"$f":"ROUND(D46*H46,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"$f":"ROUND(D47*H47,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"$f":"ROUND(D49*H49,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[{"$nulls":4},"Contract",{"$nulls":3},{"v":0,"d":"0.00"},null,null,"No change"]
[3,"Transportation/travel costs",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O22),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I74:I91)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D74*H74,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D75*H75,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D76*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},{"$f":"ROUND(D88*H88,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"]
[4,"Procurement of materials and equipment",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O34),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I93:I108)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D93*H93,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D94*H94,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(D96*H96,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"]
[5,"Other costs/consumables",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O45),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I110:I125)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D110*F110*H110,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D111*F111*H111,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},{"$f":"ROUND(D114*F114*H114,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"]
[6,"Funds for direct support of third-party beneficiaries\n(Note: This budget line should preferably cover in-kind contributions, i.e. contribution of materials and equipment, to third-party beneficiaries. In the case of financial contributions, proof of payment has to be regulated. The selection process for the third-party beneficiaries has to be described in the project description.)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O56),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I127:I136)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D127*F127*H127,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D128*F128*H128,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D129*F129*H129,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},{"$f":"ROUND(D133*F133*H133,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D134*F134*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"]
[7,"Pro-rata local project costs (e.g. IT, research)",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O61),\"\")","v":""},{"$nulls":4},{"$f":"SUM(I138:I142)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"$f":"ROUND(D138*F138*H138,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D139*F139*H139,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D140*F140*H140,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D141*F141*H141,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[{"$nulls":8},{"$f":"ROUND(D142*F142*H142,2)","v":{"v":0,"d":"0.00"}},null,null,"No change"]
[null,"Subtotal – direct costs",{"$nulls":6},{"$f":"I109+I92+I43+I5+I73+I126","v":{"v":0,"d":"0.00"}}]
[8,"Administration costs",null,{"$f":"IF('Key data'!C20=\"yes\",CONCATENATE(\"Tooltip:\",Example!O65),\"\")","v":""},{"$nulls":4},{"$f":"I145","v":{"v":0,"d":"0.00"}}]
[null,"Administration costs (on budget lines 1-7)",null,{"v":0,"d":"0.00%"},{"$nulls":3},{"$f":"I143","v":{"v":0,"d":"0.00 €"}},{"$f":"D145*H145","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":"I143+I144","v":{"v":0,"d":"0.00"}}]
[null,"GIZ funding (up to – upon provision of evidence)*",{"$nulls":6},{"$f":"I146","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"*All budget lines (with the exception of administration costs and pro-rata local project 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,"No income may be generated from the funds provided! For example, where the recipient provides rooms for training, etc., the costs may not be settled under this contract."]
[]
[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."]

{"sheet":"Example","index":3,"n_rows":88,"n_cols":15,"rows_kept":88,"merged":[[0,0,0,8],[3,1,3,7],[3,8,3,9],[4,3,4,7],[4,9,63,9],[4,14,8,14],[10,3,10,7],[10,14,19,14],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,3,21,7],[21,14,28,14],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,3,33,7],[33,14,42,14],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[43,4,43,6],[44,3,44,7],[44,14,52,14],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[53,4,53,6],[54,4,54,6],[55,3,55,7],[55,14,58,14],[60,3,60,7],[60,14,62,14],[63,1,63,7],[64,14,65,14],[67,3,67,7],[67,14,69,14],[72,14,74,14],[77,1,77,7],[77,8,77,9],[79,1,79,10],[81,1,82,9],[83,1,83,9],[84,1,84,9],[87,1,88,9],[87,14,89,14]]}
["Estimated Budget – Annex 1",{"$nulls":8},{"$f":"'Key data'!C33","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 (e.g. person, vehicle, room)","Quantity","Unit (e.g. months, days, courses)","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 - prime cost for employees of the Recipient (job title)\n(Note 1: Only staff from your organisations; the evidence for this budget line must be provided in the form of payslips or, in the case of partial financing, in the form of payslips and time sheets.\nNote 2: Only direct costs for staff (gross cost for the employer) may be settled. Add-ons such as staff overheads that are calculated pro-rata for staff are not eligible for support)",null,"",{"$nulls":4},{"$f":"SUM(I6:I10)","v":{"v":94000,"d":"94,000.00"}},"GIZ is unable to provide pro-rata financing for any of the budget lines (with the exception of staff costs (item 1) which can be covered on a percentage basis, or costs that fall under the cost category ‘Pro-rata local project costs’ (item 7)). \n\nCosts that are incurred as part of the implementation of the project but are not funded 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 display the gross cost for the employer, which is laid down in the employment contract. For part-time positions, enter the percentage in column D. Please state the statutory ancillary personnel costs that apply for your country. 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%"},"people",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%"},"people",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%"},"people",20,"months",{"v":600,"d":"600.00"},{"v":12000,"d":"12,000.00"}]
[{"$nulls":4},"people",null,"months",null,{"v":0,"d":"0.00"}]
[{"$nulls":4},"people",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 role title; no contract details (e.g. working hours); only state the number of contracts and the planned value (the relevant guidelines governing contracts awards must be observed); one budget line should be used for each contract; 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,1,"Contract ",null,null,{"v":5000,"d":"5,000.00"},{"$f":"D12*H12","v":{"v":5000,"d":"5,000.00"}}]
[null,"Catering and room rental",null,1,"Contract ",null,null,{"v":2000,"d":"2,000.00"},{"$f":"D13*H13","v":{"v":2000,"d":"2,000.00"}}]
[null,"Solar technology expert",null,null,"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Expert for…",null,null,"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"External workers (not in an employment relationship with recipient that is subject to social insurance contributions)",null,null,"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Consultancy assignments",null,null,"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"External companies, e.g. for bus transport",null,null,"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"Contract ",{"$nulls":3},{"v":0,"d":"0.00"}]
[3,"Transportation/travel costs",null,"",{"$nulls":4},{"$f":"SUM(I23:I31)","v":{"v":4500,"d":"4,500.00"}},{"$nulls":5},"Travel costs usually include all types of transportation, accommodation, per-diem allowances and visa charges. List all other costs separately. Costs are settled based on invoices and/or the recipient’s travel expense guidelines and/or statutory provisions, such as the Federal Travel Expenses Act (BRKG). You should not break down the costs for different into groups of people.\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,1,"Unit",null,null,{"v":4000,"d":"4,000.00"},{"$f":"D23*H23","v":{"v":4000,"d":"4,000.00"}}]
[null,"Domestic flights",null,1,"Unit",null,null,{"v":500,"d":"500.00"},{"$f":"D24*H24","v":{"v":500,"d":"500.00"}}]
[null,"International travel costs (per-diem/overnight accommodation allowance, means of transport, visa, required vaccinations)",{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"Domestic travel costs (per-diem/overnight accommodation allowance, means of transport)",{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"Transportation costs for goods",{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"Travel costs for workshop participants",{"$nulls":6},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"$f":"D30*F30*H30","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[]
[]
[4,"Procurement of materials and equipment",null,"",{"$nulls":4},{"$f":"SUM(I35:I44)","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,1,"Procurement",null,null,{"v":4000,"d":"4,000.00"},{"$f":"D35*H35","v":{"v":4000,"d":"4,000.00"}}]
[null,"Photographic equipment (camera and accessories)",{"$nulls":6},{"$f":"D36*H36","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"}]
[{"$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,"Other costs/consumables",{"$nulls":6},{"$f":"SUM(I46:I55)","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,1,"Unit",null,null,{"v":100,"d":"100.00"},{"$f":"D46*H46","v":{"v":100,"d":"100.00"}}]
[null,"IT software, licenses",{"$nulls":6},{"$f":"D47*H47","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},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[6,"Funds for direct support of third-party beneficiaries\n(Note: This budget line should preferably cover in-kind contributions, i.e. contribution of materials and equipment, to third-party beneficiaries. In the case of financial contributions, proof of payment has to be regulated. The selection process for the third-party beneficiaries has to be described in the project description.)",{"$nulls":6},{"$f":"SUM(I57:I60)","v":{"v":600,"d":"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 on page X of the project description)",null,10,"people",20,"days",{"v":3,"d":"3.00"},{"$f":"D57*F57*H57","v":{"v":600,"d":"600.00"}}]
[{"$nulls":8},{"$f":"D58*F58*H58","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":8},{"v":0,"d":"0.00"}]
[7,"Pro-rata local project costs (e.g. IT, research)",{"$nulls":6},{"$f":"SUM(I62:I63)","v":{"v":0,"d":"0.00"}},{"$nulls":5},"This budget line is for big international organizations, who – most of the time – have an allocation of certain costs to the exact project (pro-rata costs). So it still refers to direct costs but there is a calculation needed to understand the relation to the financed project – e.g. the IT costs for the project are calculated with 5%.This was formerly known as Shared-office-costs. In such cases we need an auditor’s report, before signing the contract, to verify the percentage or lumpsum allocated to the financed project."]
[{"$nulls":4},"%",null,"Unit",null,{"$f":"D62*F62*H62","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"Lump sum ",null,"Per month",null,{"$f":"D63*F63*H63","v":{"v":0,"d":"0.00"}}]
[null,"Subtotal – direct costs",{"$nulls":6},{"$f":"I45+I34+I11+I5+I22+I56","v":{"v":110200,"d":"110,200.00"}}]
[8,"Administration costs",{"$nulls":6},{"$f":"I66","v":{"v":5510,"d":"5,510.00"}},{"$nulls":5},"The administration costs should be 0% and 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 these costs may be examined by an auditor. The contract management section must be informed if the administration costs do not pertain to all budget lines 1-7."]
[null,"Administration costs  (on budget lines 1-7)",null,{"v":0.05,"d":"5%"},{"$nulls":3},{"$f":"I64","v":{"v":110200,"d":"110,200.00"}},{"$f":"D66*H66","v":{"v":5510,"d":"5,510.00"}}]
[null,"Subtotal – Funding by GIZ (up to – upon provision of evidence)*\n(direct costs + administration costs)",{"$nulls":6},{"$f":"I64+I65","v":{"v":115710,"d":"115,710.00"}}]
[9,"Forwarding of funds to third-party recipients – a detailed budget must be provided ",{"$nulls":12},"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 carried out by the GIZ project (sole criteria: legal entity and public-benefit nature)."]
[null,"OPQ",null,1,"Unit",1,"Forwarding of funds",{"v":10000,"d":"10,000.00"},{"$f":"D69*F69*H69","v":{"v":10000,"d":"10,000.00 €"}}]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",null,{"$f":"D70*F70*H70","v":{"v":0,"d":"0.00 €"}}]
[null,"XYZ (name of the third-party recipient) ",null,1,"Unit",1,"Forwarding of funds",null,{"v":0,"d":"0.00 €"},null,"Anteile in Prozent "]
[null,"GIZ funding (up to – upon provision of evidence)*",{"$nulls":6},{"$f":"I67","v":{"v":115710,"d":"115,710.00 €"}},{"$f":"I72","v":{"v":115710,"d":"115,710.00 €"}},{"$f":"J72/$I$78","v":{"v":0.8852421390865274,"d":"88.52%"}}]
[{"$f":"10","v":10},"Own Contributions/third-party financing",{"$nulls":7},{"$f":"SUM(J74:J76)","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,1,"Unit",1,"Contribution ",{"v":5000,"d":"5,000.00"},null,{"$f":"H74","v":{"v":5000,"d":"5,000.00"}},{"$f":"J74/$I$78","v":{"v":0.03825262030449086,"d":"3.83%"}}]
[null,"DEF (third-party financing)",null,1,"Unit",1,"Contribution ",{"v":10000,"d":"10,000.00"},null,{"$f":"H75","v":{"v":10000,"d":"10,000.00"}},{"v":0.07650524060898171,"d":"7.65%"}]
[{"$nulls":3},1,"Unit",1,"Contribution ",{"$nulls":3},{"$f":"IFERROR(J76/$I$78,\"\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":3},1,"Unit",1,"Contribution ",{"$nulls":3},{"$f":"IFERROR(J77/$I$78,\"\")","v":{"v":0,"d":"0.00%"}}]
[null,"Total financing",{"$nulls":6},{"$f":"I72+J73","v":{"v":130710,"d":"130,710.00 €"}},null,{"$f":"SUM(K72:K77)","v":{"v":0.9999999999999999,"d":"100.00%"}}]
[]
[null,"*All budget lines (with the exception of administration costs and pro-rata local project 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,"No income may be generated from the funds provided. For example, where the recipient provides rooms for training, etc., the costs may not be settled through this contract."]
[]
[]
[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."]