{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Lists","Price schedule","List of costs","Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":25,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Selection lists"]
[]
["Date",null,null,"Months"]
[{"$f":"IF(ISNUMBER('List of costs'!AF4),'List of costs'!AF4,TODAY())","v":44874},1,{"$f":"DATE(YEAR($A$4)+1,1-$B4,1)","v":"2022-12-01"},{"$f":"C4","v":"2022-12-01"}]
[null,2,{"$f":"DATE(YEAR($A$4)+1,1-$B5,1)","v":"2022-11-01"},"2022-11-01"]
[null,3,"2022-10-01","2022-10-01"]
[null,4,"2022-09-01","2022-09-01"]
[null,5,"2022-08-01","2022-08-01"]
[null,6,"2022-07-01","2022-07-01"]
[null,7,"2022-06-01","2022-06-01"]
[null,8,"2022-05-01","2022-05-01"]
[null,9,"2022-04-01","2022-04-01"]
[null,10,"2022-03-01","2022-03-01"]
[null,11,"2022-02-01","2022-02-01"]
[null,12,"2022-01-01","2022-01-01"]
[null,13,"2021-12-01","2021-12-01"]
[null,14,"2021-11-01","2021-11-01"]
[null,15,"2021-10-01","2021-10-01"]
[null,16,"2021-09-01","2021-09-01"]
[null,17,"2021-08-01","2021-08-01"]
[null,18,"2021-07-01","2021-07-01"]
[null,19,"2021-06-01","2021-06-01"]
[null,20,"2021-05-01","2021-05-01"]
[null,21,"2021-04-01","2021-04-01"]
[null,22,"2021-03-01","2021-03-01"]
[null,23,"2021-02-01","2021-02-01"]
[null,24,"2021-01-01","2021-01-01"]
[null,25,"2020-12-01","2020-12-01"]
[null,26,"2020-11-01","2020-11-01"]
[null,27,"2020-10-01","2020-10-01"]
[null,28,"2020-09-01","2020-09-01"]
[null,29,"2020-08-01","2020-08-01"]
[null,30,"2020-07-01","2020-07-01"]
[null,31,"2020-06-01","2020-06-01"]
[null,32,"2020-05-01","2020-05-01"]
[null,33,"2020-04-01","2020-04-01"]
[null,34,"2020-03-01","2020-03-01"]
[null,35,"2020-02-01","2020-02-01"]
[null,36,"2020-01-01","2020-01-01"]
[null,37,"2019-12-01","2019-12-01"]
[null,38,"2019-11-01","2019-11-01"]
[null,39,"2019-10-01","2019-10-01"]
[null,40,"2019-09-01","2019-09-01"]
[null,41,"2019-08-01","2019-08-01"]
[null,42,"2019-07-01","2019-07-01"]
[null,43,"2019-06-01","2019-06-01"]
[null,44,"2019-05-01","2019-05-01"]
[null,45,"2019-04-01","2019-04-01"]
[null,46,"2019-03-01","2019-03-01"]
[null,47,"2019-02-01","2019-02-01"]
[null,48,"2019-01-01","2019-01-01"]

{"sheet":"Price schedule","index":1,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[107,1,107,4],[107,8,107,12],[43,1,43,12],[46,2,46,4],[74,2,74,4],[76,2,76,4],[94,2,94,7],[95,2,95,7],[67,2,67,4],[86,2,86,7],[93,2,93,7],[92,2,92,7],[91,2,91,7],[78,2,78,4],[85,2,85,7],[72,2,72,4],[33,2,33,4],[35,2,35,4],[37,2,37,4],[66,2,66,4],[47,2,47,4],[52,2,52,4],[54,2,54,4],[56,2,56,4],[58,2,58,4],[25,2,25,4],[31,2,31,4],[12,4,12,12],[20,1,20,4],[20,5,20,7],[20,8,20,9],[26,2,26,4],[15,4,15,12],[18,1,18,12],[19,1,19,11],[22,1,22,12],[3,4,3,12],[9,4,9,7],[9,8,9,10],[9,11,9,12],[6,4,6,7],[6,8,6,10],[6,11,6,12]]}
[null,null,"Hinweise"]
[null,"Price schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concluding the contract will hide the price schedule and allow you to fill in the list of costs."]
[]
[null,"Title of the measure:"]
[]
[]
[null,"Country:",null,null,"<Project country>",null,null,null,"Date:"]
[]
[]
[null,"Project/Programme no:",null,null,null,null,null,null,"Contract number:"]
[]
[]
[null,"Partner:",null,null,"<Name of private sector enterprise>",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($Q$22:$Q$65)","v":1}]
[]
[]
[null,"Währung:",null,null,"<Currency>",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($Q$22:$Q$65)","v":1}]
[]
[]
[null,"IMPORTANT: \n- Only prime costs are eligible for reimbursement in accordance with the percentage agreed in the contract\n- All items listed in the price schedule are stated as maximum values (amounts and costs per unit i.e. ‘up to’)\n=> PLEASE read the Guidelines on Eligible Costs in (i)DPPs",null,null,null,null,null,null,null,null,null,null,null,null,"Hilfsspalten, auszublenden"]
[null,"https://www.giz.de/en/downloads/giz2022-leitfaden-erstattungsfaehige-kosten-im-rahmen-von-iepw-en.pdf"]
[null,"Name \n",null,null,null,"Quantity / \nUnit ",null,null,"Costs \nof quantity / unit ",null,"Total costs \n","Partner Share \n","Share \nof GIZ ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(Q23+64)","v":"@"},"<Name of enterprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$22:R22)","v":0},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"3.4.1","Daily rates / salaries for the private enterprise’s employees "]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G26=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G26*J26","v":0},{"$f":"K26*AnteilFremd/100","v":0},{"$f":"K26-L26","v":0},null,null,{"$f":"C26","v":"<Name, function>"}]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G27=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G27*J27","v":0},{"$f":"K27*AnteilFremd/100","v":0},{"$f":"K27-L27","v":0},null,null,{"$f":"C27","v":"<Name, function>"}]
[]
[null,null,"Sum daily rates / salaries",null,null,null,null,null,null,null,{"$f":"SUM(K25:K28)","v":0},{"$f":"SUM(L25:L28)","v":0},0]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Per diem allowances"]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G32=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G32*J32","v":0},{"$f":"K32*AnteilFremd/100","v":0},{"$f":"K32-L32","v":0},null,null,{"$f":"C32","v":"<Country of assignment>"}]
[null,"b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G34=1,\"night\",\"nights\")","v":"nights"},"at",null,{"$f":"G34*J34","v":0},{"$f":"K34*AnteilFremd/100","v":0},{"$f":"K34-L34","v":0},null,null,{"$f":"C34","v":"<Country of assignment>"}]
[null,"c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,"total",null,null,null,{"$f":"J36","v":0},{"$f":"K36*AnteilFremd/100","v":0},{"$f":"K36-L36","v":0},null,null,{"$f":"C36","v":"<Country of assignment>"}]
[null,"d","Flight costs (pref. Economy, Business Class poss. over 4hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<from – to>",null,null,null,null,{"$f":"IF(G38=1,\"flight\",\"flights\")","v":"flights"},"at",null,{"$f":"G38*J38","v":0},{"$f":"K38*AnteilFremd/100","v":0},{"$f":"K38-L38","v":0},null,null,{"$f":"C38","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K30:K39)","v":0},0,0]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K29+K40","v":0},0,0,null,null,null,null,{"$f":"K42","v":0}]
[]
[{"$f":"CHAR(Q44+64)","v":"A"},"<Name of enterprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$22:R43)","v":1},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"3.4.1","Daily rates / salaries for the private enterprise’s employees "]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G47=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G47*J47","v":0},{"$f":"K47*AnteilFremd/100","v":0},{"$f":"K47-L47","v":0},null,null,{"$f":"C47","v":"<Name, function>"}]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G48=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G48*J48","v":0},{"$f":"K48*AnteilFremd/100","v":0},{"$f":"K48-L48","v":0},null,null,{"$f":"C48","v":"<Name, function>"}]
[]
[null,null,"Sum daily rates / salaries",null,null,null,null,null,null,null,{"$f":"SUM(K46:K49)","v":0},{"$f":"SUM(L46:L49)","v":0},{"$f":"SUM(M46:M49)","v":0}]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Per diem allowances"]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G53=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G53*J53","v":0},{"$f":"K53*AnteilFremd/100","v":0},{"$f":"K53-L53","v":0},null,null,{"$f":"C53","v":"<Country of assignment>"}]
[null,"b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G55=1,\"night\",\"nights\")","v":"nights"},"at",null,{"$f":"G55*J55","v":0},{"$f":"K55*AnteilFremd/100","v":0},{"$f":"K55-L55","v":0},null,null,{"$f":"C55","v":"<Country of assignment>"}]
[null,"c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,"total",null,null,null,{"$f":"J57","v":0},{"$f":"K57*AnteilFremd/100","v":0},{"$f":"K57-L57","v":0},null,null,{"$f":"C57","v":"<Country of assignment>"}]
[null,"d","Flight costs (pref. Economy, Business Class poss. over 4hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<from – to>",null,null,null,null,{"$f":"IF(G59=1,\"flight\",\"flights\")","v":"flights"},"at",null,{"$f":"G59*J59","v":0},{"$f":"K59*AnteilFremd/100","v":0},{"$f":"K59-L59","v":0},null,null,{"$f":"C59","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K51:K60)","v":0},0,0]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K50+K61","v":0},0,0,null,null,null,null,{"$f":"K63","v":0}]
[]
[null,"External experts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ende",null,1]
[null,"3.4.2","Fee "]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G67=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G67*J67","v":0},{"$f":"K67*AnteilFremd/100","v":0},{"$f":"K67-L67","v":0},null,null,{"$f":"C67","v":"<Name, function>"}]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G68=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G68*J68","v":0},{"$f":"K68*AnteilFremd/100","v":0},{"$f":"K68-L68","v":0},null,null,{"$f":"C68","v":"<Name, function>"}]
[]
[null,null,"Sum fees",null,null,null,null,null,null,null,{"$f":"SUM(K66:K69)","v":0},{"$f":"SUM(L66:L69)","v":0},{"$f":"SUM(M66:M69)","v":0}]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Per diem allowances"]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G73=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G73*J73","v":0},{"$f":"K73*AnteilFremd/100","v":0},{"$f":"K73-L73","v":0},null,null,{"$f":"C73","v":"<Country of assignment>"}]
[null,"b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,null,{"$f":"IF(G75=1,\"night\",\"nights\")","v":"nights"},"up to",null,{"$f":"G75*J75","v":0},{"$f":"K75*AnteilFremd/100","v":0},{"$f":"K75-L75","v":0},null,null,{"$f":"C75","v":"<Country of assignment>"}]
[null,"c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Country of assignment>",null,null,null,"total",null,null,null,{"$f":"J77","v":0},{"$f":"K77*AnteilFremd/100","v":0},{"$f":"K77-L77","v":0},null,null,{"$f":"C77","v":"<Country of assignment>"}]
[null,"d","Flight costs (Economy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<from – to>",null,null,null,null,{"$f":"IF(G79=1,\"flight\",\"flights\")","v":"flights"},"up to",null,{"$f":"G79*J79","v":0},{"$f":"K79*AnteilFremd/100","v":0},{"$f":"K79-L79","v":0},null,null,{"$f":"C79","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K71:K80)","v":0},{"$f":"SUM(L71:L80)","v":0},{"$f":"SUM(M71:M80)","v":0}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K70+K81","v":0},0,0]
[]
[null,"3.4.4","Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Name, poss. quantity / unit>",null,null,null,null,null,null,null,null,{"$f":"K86*AnteilFremd/100","v":0},{"$f":"K86-L86","v":0},null,{"$f":"C86","v":"<Name, poss. quantity / unit>"}]
[null,null,"<Consumables, if applicable amount/unit>",null,null,null,null,null,null,null,null,{"$f":"K87*AnteilFremd/100","v":0},{"$f":"K87-L87","v":0},null,{"$f":"C87","v":"<Consumables, if applicable amount/unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K85:K88)","v":0},{"$f":"SUM(L85:L88)","v":0},{"$f":"SUM(M85:M88)","v":0}]
[]
[null,"3.4.6","Other costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Operating costs in accordance with the Guidelines on Eligible Costs>",null,null,null,null,null,null,null,null,{"$f":"K92*AnteilFremd/100","v":0},{"$f":"K92-L92","v":0},null,{"$f":"C92","v":"<Operating costs in accordance with the Guidelines on Eligible Costs>"}]
[null,null,"<Depreciation of equipment in accordance with the Guidelines on Eligible Costs>",null,null,null,null,null,null,null,null,{"$f":"K93*AnteilFremd/100","v":0},{"$f":"K93-L93","v":0},null,{"$f":"C93","v":"<Depreciation of equipment in accordance with the Guidelines on Eligible Costs>"}]
[null,null,"<Workshop costs>",null,null,null,null,null,null,null,null,{"$f":"K94*AnteilFremd/100","v":0},{"$f":"K94-L94","v":0},null,{"$f":"C94","v":"<Workshop costs>"}]
[null,null,"Audit report",null,null,null,null,null,null,null,null,{"$f":"K95*AnteilFremd/100","v":0},0,null,"Audit report"]
[null,null,"<Name, poss. quantity / unit>",null,null,null,null,null,null,null,null,{"$f":"K96*AnteilFremd/100","v":0},0,null,"<Name, poss. quantity / unit>"]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K91:K97)","v":0},{"$f":"SUM(L91:L97)","v":0},{"$f":"SUM(M91:M97)","v":0}]
[]
[null,"Costs of contract (excl. statutory VAT)",null,null,null,null,null,null,null,null,{"$f":"SUM($R$22:$R$65)+K83+K89+K98","v":0},{"$f":"K100*AnteilFremd/100","v":0},{"$f":"K100-L100","v":0},null,null,null,null,null,1]
[null,"Share in cost of contract (%)",null,null,null,null,null,null,null,null,100,100,{"$f":"K101-AnteilFremd","v":0}]
[]
[null,null,"Further GIZ contributions to the measure",null,null,null,null,null,null,null,null,null,{"$f":"K103","v":0}]
[null,"Total costs",null,null,null,null,null,null,null,null,{"$f":"L104+M104","v":0},{"$f":"L100","v":0},{"$f":"M100+M103","v":0}]
[null,"Share in total cost (%)",null,null,null,null,null,null,null,null,100,{"$f":"IF($K$104>0,ROUND(100*L104/$K$104,1),\"\")","v":""},{"$f":"IF($K$104>0,ROUND(100*M104/$K$104,1),\"\")","v":""}]
[]
[]
[]
[null,"Date",null,null,null,null,null,null,"Signature"]

{"sheet":"List of costs","index":2,"n_rows":118,"n_cols":39,"rows_kept":118,"cut":false,"hidden":true,"merged":[[19,1,19,12],[20,14,20,29],[21,26,21,27],[116,14,116,15],[116,17,116,21],[97,2,97,7],[98,2,98,7],[99,2,99,7],[109,14,109,21],[111,14,111,17],[111,18,111,21],[113,14,113,17],[113,18,113,21],[18,1,18,12],[96,2,96,7],[95,2,95,7],[78,2,78,4],[20,1,21,12],[35,2,35,4],[26,1,26,12],[29,2,29,4],[89,2,89,7],[80,2,80,4],[82,2,82,4],[71,2,71,4],[51,2,51,4],[56,2,56,4],[58,2,58,4],[90,2,90,7],[3,14,3,15],[24,1,24,4],[24,8,24,9],[3,4,3,12],[3,16,3,17],[6,4,6,12],[9,4,9,7],[9,11,9,12],[9,8,9,10],[12,4,12,10],[24,5,24,7],[6,14,6,15],[6,16,6,17],[12,11,12,12],[12,14,12,17],[15,4,15,10],[20,31,20,32],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[21,28,21,29],[21,31,21,32],[21,24,21,25],[22,31,23,32],[37,2,37,4],[39,2,39,4],[41,2,41,4],[76,2,76,4],[70,2,70,4],[30,2,30,4],[60,2,60,4],[62,2,62,4],[47,1,47,12],[50,2,50,4]]}
[]
[null,"List of costs for:",null,null,null,null,null,null,null,null,null,null,null,null,"The price schedule may be changed as a result of a supplement to the contract. "]
[]
[null,"Measure title:",null,null,{"$f":"'Price schedule'!E4","v":0},null,null,null,null,null,null,null,null,null,"Date: "]
[]
[]
[null,"Country:",null,null,{"$f":"'Price schedule'!E7","v":"<Project country>"},null,null,null,null,null,null,null,null,null,"Programme/Project term:   "]
[]
[]
[null,"Project/Programme no:",null,null,{"$f":"'Price schedule'!E10","v":0},null,null,null,"Contract number:  ",null,null,{"$f":"'Price schedule'!Vertragsnummer","v":0}]
[]
[]
[null,"Partner:",null,null,{"$f":"'Price schedule'!E13","v":"<Name of private sector enterprise>"},null,null,null,null,null,null,"Contact:",null,null,"<Person responsible for the list of costs>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($AK$26:$AK$69)","v":1}]
[]
[]
[null,"Währung:",null,null,{"$f":"'Price schedule'!E16","v":"<Currency>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($AK$26:$AK$69)","v":1}]
[]
[]
[null,"IMPORTANT: \n- Only prime costs are eligible for reimbursement in accordance with the percentage agreed in the contract\n- All items listed in the price schedule are stated as maximum values (amounts and costs per unit i.e. ‘up to’)\n=> PLEASE read the Guidelines on Eligible Costs in (i)DPPs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hilfsspalten, auszublenden"]
[null,"https://www.giz.de/en/downloads/giz2022-leitfaden-erstattungsfaehige-kosten-im-rahmen-von-iepw-en.pdf"]
[null,"Figures from Price schedule\nTARGET costs",null,null,null,null,null,null,null,null,null,null,null,null,"List of costs by reporting period – ACTUAL costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDUAL (TARGET costs minus ACTUAL costst)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st reporting period",null,"2nd reporting period",null,"3rd reporting period",null,"4th reporting period",null,"5th reporting period",null,"6th reporting period",null,"7th reporting period",null,"8th reporting period",null,null,"Remaining residual funds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"from:",null,"from:",{"$f":"IF(AND(P24<>\"\",R24<>\"\"),IF(ISNUMBER(P24),DATE(YEAR(P24),MONTH(P24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(R24<>\"\",T24<>\"\"),IF(ISNUMBER(R24),DATE(YEAR(R24),MONTH(R24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(T24<>\"\",V24<>\"\"),IF(ISNUMBER(T24),DATE(YEAR(T24),MONTH(T24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(V24<>\"\",X24<>\"\"),IF(ISNUMBER(V24),DATE(YEAR(V24),MONTH(V24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(X24<>\"\",Z24<>\"\"),IF(ISNUMBER(X24),DATE(YEAR(X24),MONTH(X24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(Z24<>\"\",AB24<>\"\"),IF(ISNUMBER(Z24),DATE(YEAR(Z24),MONTH(Z24)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(X24<>\"\",AD24<>\"\"),IF(ISNUMBER(X24),DATE(YEAR(X24),MONTH(X24)+1,1),\"\"),\"\")","v":""},null,"(at the end of the overall reporting period)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to:",null,"to:",null,"to:",null,"to:",null,"to:",null,"to:",null,"to:",null,"to:",null,null,null,null,null,{"$f":"IF(AD24=\"\",IF(AB24=\"\",Z24,AB24),AD24)","v":0}]
[null,"Name \n",null,null,null,"Quantity /  \nUnit ",null,null,"Costs \nof quantity /  unit ",null,"Total costs \n","Partner \nshare ","Share \nof GIZ  ",null,"Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ","Actual \ncosts ","Share \nof GIZ ",null,"Total \n ","Share \nof GIZ ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(AK27+64)","v":"@"},{"$f":"'Price schedule'!B23","v":"<Name of enterprise>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AL$26:AL26)","v":0},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"3.4.1","Daily rates / salaries for the private enterprise’s employees "]
[null,null,{"$f":"'Price schedule'!C26","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G26","v":0},{"$f":"IF(G30=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J26","v":0},{"$f":"G30*J30","v":0},{"$f":"K30*AnteilFremd/100","v":0},{"$f":"K30-L30","v":0},null,null,{"$f":"O30*AnteilGIZ/100","v":0},null,{"$f":"Q30*AnteilGIZ/100","v":0},null,{"$f":"S30*AnteilGIZ/100","v":0},null,{"$f":"U30*AnteilGIZ/100","v":0},null,{"$f":"W30*AnteilGIZ/100","v":0},null,{"$f":"Y30*AnteilGIZ/100","v":0},null,{"$f":"AA30*AnteilGIZ/100","v":0},null,{"$f":"AC30*AnteilGIZ/100","v":0},null,{"$f":"K30-O30-Q30-S30-U30-W30-Y30-AA30-AC30","v":0},{"$f":"M30-P30-R30-T30-V30-X30-Z30-AB30-AD30","v":0},null,null,{"$f":"C30","v":"<Name, function>"}]
[null,null,{"$f":"'Price schedule'!C27","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G27","v":0},{"$f":"IF(G31=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J27","v":0},{"$f":"G31*J31","v":0},{"$f":"K31*AnteilFremd/100","v":0},{"$f":"K31-L31","v":0},null,null,{"$f":"O31*AnteilGIZ/100","v":0},null,{"$f":"Q31*AnteilGIZ/100","v":0},null,{"$f":"S31*AnteilGIZ/100","v":0},null,{"$f":"U31*AnteilGIZ/100","v":0},null,{"$f":"W31*AnteilGIZ/100","v":0},null,{"$f":"Y31*AnteilGIZ/100","v":0},null,{"$f":"AA31*AnteilGIZ/100","v":0},null,{"$f":"AC31*AnteilGIZ/100","v":0},null,{"$f":"K31-O31-Q31-S31-U31-W31-Y31-AA31-AC31","v":0},{"$f":"M31-P31-R31-T31-V31-X31-Z31-AB31-AD31","v":0},null,null,{"$f":"C31","v":"<Name, function>"}]
[]
[null,null,"Sum daily rates / salaries",null,null,null,null,null,null,null,{"$f":"SUM(K29:K32)","v":0},0,0,null,{"$f":"SUM(O29:O32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF29:AF32)","v":0},0]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Per diem allowances"]
[null,null,{"$f":"'Price schedule'!C32","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G32","v":0},{"$f":"IF(G36=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J32","v":0},{"$f":"G36*J36","v":0},{"$f":"K36*AnteilFremd/100","v":0},{"$f":"K36-L36","v":0},null,null,{"$f":"O36*AnteilGIZ/100","v":0},null,{"$f":"Q36*AnteilGIZ/100","v":0},null,{"$f":"S36*AnteilGIZ/100","v":0},null,{"$f":"U36*AnteilGIZ/100","v":0},null,{"$f":"W36*AnteilGIZ/100","v":0},null,{"$f":"Y36*AnteilGIZ/100","v":0},null,{"$f":"AA36*AnteilGIZ/100","v":0},null,{"$f":"AC36*AnteilGIZ/100","v":0},null,{"$f":"K36-O36-Q36-S36-U36-W36-Y36-AA36-AC36","v":0},{"$f":"M36-P36-R36-T36-V36-X36-Z36-AB36-AD36","v":0},null,null,{"$f":"C36","v":"<Country of assignment>"}]
[null,"b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C34","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G34","v":0},{"$f":"IF(G38=1,\"night\",\"nights\")","v":"nights"},"at",{"$f":"'Price schedule'!J34","v":0},{"$f":"G38*J38","v":0},{"$f":"K38*AnteilFremd/100","v":0},{"$f":"K38-L38","v":0},null,null,{"$f":"O38*AnteilGIZ/100","v":0},null,{"$f":"Q38*AnteilGIZ/100","v":0},null,{"$f":"S38*AnteilGIZ/100","v":0},null,{"$f":"U38*AnteilGIZ/100","v":0},null,{"$f":"W38*AnteilGIZ/100","v":0},null,{"$f":"Y38*AnteilGIZ/100","v":0},null,{"$f":"AA38*AnteilGIZ/100","v":0},null,{"$f":"AC38*AnteilGIZ/100","v":0},null,{"$f":"K38-O38-Q38-S38-U38-W38-Y38-AA38-AC38","v":0},{"$f":"M38-P38-R38-T38-V38-X38-Z38-AB38-AD38","v":0},null,null,{"$f":"C38","v":"<Country of assignment>"}]
[null,"c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C36","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J36","v":0},{"$f":"J40","v":0},{"$f":"K40*AnteilFremd/100","v":0},{"$f":"K40-L40","v":0},null,null,{"$f":"O40*AnteilGIZ/100","v":0},null,{"$f":"Q40*AnteilGIZ/100","v":0},null,{"$f":"S40*AnteilGIZ/100","v":0},null,{"$f":"U40*AnteilGIZ/100","v":0},null,{"$f":"W40*AnteilGIZ/100","v":0},null,{"$f":"Y40*AnteilGIZ/100","v":0},null,{"$f":"AA40*AnteilGIZ/100","v":0},null,{"$f":"AC40*AnteilGIZ/100","v":0},null,{"$f":"K40-O40-Q40-S40-U40-W40-Y40-AA40-AC40","v":0},{"$f":"M40-P40-R40-T40-V40-X40-Z40-AB40-AD40","v":0},null,null,{"$f":"C40","v":"<Country of assignment>"}]
[null,"d","Flight costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C38","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G38","v":0},{"$f":"IF(G42=1,\"flight\",\"flights\")","v":"flights"},"at",{"$f":"'Price schedule'!J38","v":0},{"$f":"G42*J42","v":0},{"$f":"K42*AnteilFremd/100","v":0},{"$f":"K42-L42","v":0},null,null,{"$f":"O42*AnteilGIZ/100","v":0},null,{"$f":"Q42*AnteilGIZ/100","v":0},null,{"$f":"S42*AnteilGIZ/100","v":0},null,{"$f":"U42*AnteilGIZ/100","v":0},null,{"$f":"W42*AnteilGIZ/100","v":0},null,{"$f":"Y42*AnteilGIZ/100","v":0},null,{"$f":"AA42*AnteilGIZ/100","v":0},null,{"$f":"AC42*AnteilGIZ/100","v":0},null,{"$f":"K42-O42-Q42-S42-U42-W42-Y42-AA42-AC42","v":0},{"$f":"M42-P42-R42-T42-V42-X42-Z42-AB42-AD42","v":0},null,null,{"$f":"C42","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K34:K43)","v":0},0,0,null,{"$f":"SUM(O34:O43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF34:AF43)","v":0},0]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K33+K44","v":0},0,0,null,{"$f":"O33+O44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AF33+AF44","v":0},0,null,null,null,null,{"$f":"K46","v":0}]
[]
[{"$f":"CHAR(AK48+64)","v":"A"},{"$f":"'Price schedule'!B44","v":"<Name of enterprise>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AL$26:AL47)","v":1},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"3.4.1","Daily rates / salaries for the private enterprise’s employees "]
[null,null,{"$f":"'Price schedule'!C47","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G47","v":0},{"$f":"IF(G51=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J47","v":0},{"$f":"G51*J51","v":0},{"$f":"K51*AnteilFremd/100","v":0},{"$f":"K51-L51","v":0},null,null,{"$f":"O51*AnteilGIZ/100","v":0},null,{"$f":"Q51*AnteilGIZ/100","v":0},null,{"$f":"S51*AnteilGIZ/100","v":0},null,{"$f":"U51*AnteilGIZ/100","v":0},null,{"$f":"W51*AnteilGIZ/100","v":0},null,{"$f":"Y51*AnteilGIZ/100","v":0},null,{"$f":"AA51*AnteilGIZ/100","v":0},null,{"$f":"AC51*AnteilGIZ/100","v":0},null,{"$f":"K51-O51-Q51-S51-U51-W51-Y51-AA51-AC51","v":0},{"$f":"M51-P51-R51-T51-V51-X51-Z51-AB51-AD51","v":0},null,null,{"$f":"C51","v":"<Name, function>"}]
[null,null,{"$f":"'Price schedule'!C48","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G48","v":0},{"$f":"IF(G52=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J48","v":0},{"$f":"G52*J52","v":0},{"$f":"K52*AnteilFremd/100","v":0},{"$f":"K52-L52","v":0},null,null,{"$f":"O52*AnteilGIZ/100","v":0},null,{"$f":"Q52*AnteilGIZ/100","v":0},null,{"$f":"S52*AnteilGIZ/100","v":0},null,{"$f":"U52*AnteilGIZ/100","v":0},null,{"$f":"W52*AnteilGIZ/100","v":0},null,{"$f":"Y52*AnteilGIZ/100","v":0},null,{"$f":"AA52*AnteilGIZ/100","v":0},null,{"$f":"AC52*AnteilGIZ/100","v":0},null,{"$f":"K52-O52-Q52-S52-U52-W52-Y52-AA52-AC52","v":0},{"$f":"M52-P52-R52-T52-V52-X52-Z52-AB52-AD52","v":0},null,null,{"$f":"C52","v":"<Name, function>"}]
[]
[null,null,"Sum daily rates / salaries",null,null,null,null,null,null,null,{"$f":"SUM(K50:K53)","v":0},{"$f":"SUM(L50:L53)","v":0},{"$f":"SUM(M50:M53)","v":0},null,{"$f":"SUM(O50:O53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF50:AF53)","v":0},{"$f":"SUM(AG50:AG53)","v":0}]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Per diem allowances"]
[null,null,{"$f":"'Price schedule'!C53","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G53","v":0},{"$f":"IF(G57=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J53","v":0},{"$f":"G57*J57","v":0},{"$f":"K57*AnteilFremd/100","v":0},{"$f":"K57-L57","v":0},null,null,{"$f":"O57*AnteilGIZ/100","v":0},null,{"$f":"Q57*AnteilGIZ/100","v":0},null,{"$f":"S57*AnteilGIZ/100","v":0},null,{"$f":"U57*AnteilGIZ/100","v":0},null,{"$f":"W57*AnteilGIZ/100","v":0},null,{"$f":"Y57*AnteilGIZ/100","v":0},null,{"$f":"AA57*AnteilGIZ/100","v":0},null,{"$f":"AC57*AnteilGIZ/100","v":0},null,{"$f":"K57-O57-Q57-S57-U57-W57-Y57-AA57-AC57","v":0},{"$f":"M57-P57-R57-T57-V57-X57-Z57-AB57-AD57","v":0},null,null,{"$f":"C57","v":"<Country of assignment>"}]
[null,"b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C55","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G55","v":0},{"$f":"IF(G59=1,\"night\",\"nights\")","v":"nights"},"at",{"$f":"'Price schedule'!J55","v":0},{"$f":"G59*J59","v":0},{"$f":"K59*AnteilFremd/100","v":0},{"$f":"K59-L59","v":0},null,null,{"$f":"O59*AnteilGIZ/100","v":0},null,{"$f":"Q59*AnteilGIZ/100","v":0},null,{"$f":"S59*AnteilGIZ/100","v":0},null,{"$f":"U59*AnteilGIZ/100","v":0},null,{"$f":"W59*AnteilGIZ/100","v":0},null,{"$f":"Y59*AnteilGIZ/100","v":0},null,{"$f":"AA59*AnteilGIZ/100","v":0},null,{"$f":"AC59*AnteilGIZ/100","v":0},null,{"$f":"K59-O59-Q59-S59-U59-W59-Y59-AA59-AC59","v":0},{"$f":"M59-P59-R59-T59-V59-X59-Z59-AB59-AD59","v":0},null,null,{"$f":"C59","v":"<Country of assignment>"}]
[null,"c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C57","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J57","v":0},{"$f":"J61","v":0},{"$f":"K61*AnteilFremd/100","v":0},{"$f":"K61-L61","v":0},null,null,{"$f":"O61*AnteilGIZ/100","v":0},null,{"$f":"Q61*AnteilGIZ/100","v":0},null,{"$f":"S61*AnteilGIZ/100","v":0},null,{"$f":"U61*AnteilGIZ/100","v":0},null,{"$f":"W61*AnteilGIZ/100","v":0},null,{"$f":"Y61*AnteilGIZ/100","v":0},null,{"$f":"AA61*AnteilGIZ/100","v":0},null,{"$f":"AC61*AnteilGIZ/100","v":0},null,{"$f":"K61-O61-Q61-S61-U61-W61-Y61-AA61-AC61","v":0},{"$f":"M61-P61-R61-T61-V61-X61-Z61-AB61-AD61","v":0},null,null,{"$f":"C61","v":"<Country of assignment>"}]
[null,"d","Flight costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C59","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G59","v":0},{"$f":"IF(G63=1,\"flight\",\"flights\")","v":"flights"},"at",{"$f":"'Price schedule'!J59","v":0},{"$f":"G63*J63","v":0},{"$f":"K63*AnteilFremd/100","v":0},{"$f":"K63-L63","v":0},null,null,{"$f":"O63*AnteilGIZ/100","v":0},null,{"$f":"Q63*AnteilGIZ/100","v":0},null,{"$f":"S63*AnteilGIZ/100","v":0},null,{"$f":"U63*AnteilGIZ/100","v":0},null,{"$f":"W63*AnteilGIZ/100","v":0},null,{"$f":"Y63*AnteilGIZ/100","v":0},null,{"$f":"AA63*AnteilGIZ/100","v":0},null,{"$f":"AC63*AnteilGIZ/100","v":0},null,{"$f":"K63-O63-Q63-S63-U63-W63-Y63-AA63-AC63","v":0},{"$f":"M63-P63-R63-T63-V63-X63-Z63-AB63-AD63","v":0},null,null,{"$f":"C63","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K55:K64)","v":0},0,0,null,{"$f":"SUM(O55:O64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF55:AF64)","v":0},0]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K54+K65","v":0},0,0,null,{"$f":"O54+O65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AF54+AF65","v":0},0,null,null,null,null,{"$f":"K67","v":0}]
[]
[null,"External experts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ende",null,1]
[null,"3.4.2","Fee"]
[null,null,{"$f":"'Price schedule'!C67","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G67","v":0},{"$f":"IF(G71=1,\"day\",\"days\")","v":"days"},"up to",{"$f":"'Price schedule'!J67","v":0},{"$f":"G71*J71","v":0},{"$f":"K71*AnteilFremd/100","v":0},{"$f":"K71-L71","v":0},null,null,{"$f":"O71*AnteilGIZ/100","v":0},null,{"$f":"Q71*AnteilGIZ/100","v":0},null,{"$f":"S71*AnteilGIZ/100","v":0},null,{"$f":"U71*AnteilGIZ/100","v":0},null,{"$f":"W71*AnteilGIZ/100","v":0},null,{"$f":"Y71*AnteilGIZ/100","v":0},null,{"$f":"AA71*AnteilGIZ/100","v":0},null,{"$f":"AC71*AnteilGIZ/100","v":0},null,{"$f":"K71-O71-Q71-S71-U71-W71-Y71-AA71-AC71","v":0},{"$f":"M71-P71-R71-T71-V71-X71-Z71-AB71-AD71","v":0},null,null,{"$f":"C71","v":"<Name, function>"}]
[null,null,{"$f":"'Price schedule'!C68","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G68","v":0},{"$f":"IF(G72=1,\"day\",\"days\")","v":"days"},"up to",{"$f":"'Price schedule'!J68","v":0},{"$f":"G72*J72","v":0},{"$f":"K72*AnteilFremd/100","v":0},{"$f":"K72-L72","v":0},null,null,{"$f":"O72*AnteilGIZ/100","v":0},null,{"$f":"Q72*AnteilGIZ/100","v":0},null,{"$f":"S72*AnteilGIZ/100","v":0},null,{"$f":"U72*AnteilGIZ/100","v":0},null,{"$f":"W72*AnteilGIZ/100","v":0},null,{"$f":"Y72*AnteilGIZ/100","v":0},null,{"$f":"AA72*AnteilGIZ/100","v":0},null,{"$f":"AC72*AnteilGIZ/100","v":0},null,{"$f":"K72-O72-Q72-S72-U72-W72-Y72-AA72-AC72","v":0},{"$f":"M72-P72-R72-T72-V72-X72-Z72-AB72-AD72","v":0},null,null,{"$f":"C72","v":"<Name, function>"}]
[]
[null,null,"Sum fees",null,null,null,null,null,null,null,{"$f":"SUM(K70:K73)","v":0},{"$f":"SUM(L70:L73)","v":0},{"$f":"SUM(M70:M73)","v":0},null,{"$f":"SUM(O70:O73)","v":0},{"$f":"SUM(P70:P73)","v":0},{"$f":"SUM(Q70:Q73)","v":0},{"$f":"SUM(R70:R73)","v":0},{"$f":"SUM(S70:S73)","v":0},{"$f":"SUM(T70:T73)","v":0},{"$f":"SUM(U70:U73)","v":0},{"$f":"SUM(V70:V73)","v":0},{"$f":"SUM(W70:W73)","v":0},{"$f":"SUM(X70:X73)","v":0},{"$f":"SUM(Y70:Y73)","v":0},{"$f":"SUM(Z70:Z73)","v":0},{"$f":"SUM(AA70:AA73)","v":0},{"$f":"SUM(AB70:AB73)","v":0},{"$f":"SUM(AC70:AC73)","v":0},{"$f":"SUM(AD70:AD73)","v":0},null,{"$f":"SUM(AF70:AF73)","v":0},0]
[null,"3.4.3","Travel expenses (according to tax guidelines)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"  a","Per diem allowances"]
[null,null,{"$f":"'Price schedule'!C73","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G73","v":0},{"$f":"IF(G77=1,\"day\",\"days\")","v":"days"},"up to",{"$f":"'Price schedule'!J73","v":0},{"$f":"G77*J77","v":0},{"$f":"K77*AnteilFremd/100","v":0},{"$f":"K77-L77","v":0},null,null,{"$f":"O77*AnteilGIZ/100","v":0},null,{"$f":"Q77*AnteilGIZ/100","v":0},null,{"$f":"S77*AnteilGIZ/100","v":0},null,{"$f":"U77*AnteilGIZ/100","v":0},null,{"$f":"W77*AnteilGIZ/100","v":0},null,{"$f":"Y77*AnteilGIZ/100","v":0},null,{"$f":"AA77*AnteilGIZ/100","v":0},null,{"$f":"AC77*AnteilGIZ/100","v":0},null,{"$f":"K77-O77-Q77-S77-U77-W77-Y77-AA77-AC77","v":0},{"$f":"M77-P77-R77-T77-V77-X77-Z77-AB77-AD77","v":0},null,null,{"$f":"C77","v":"<Country of assignment>"}]
[null,"  b","Cost of overnight accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C75","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G75","v":0},{"$f":"IF(G79=1,\"night\",\"nights\")","v":"nights"},"up to",{"$f":"'Price schedule'!J75","v":0},{"$f":"G79*J79","v":0},{"$f":"K79*AnteilFremd/100","v":0},{"$f":"K79-L79","v":0},null,null,{"$f":"O79*AnteilGIZ/100","v":0},null,{"$f":"Q79*AnteilGIZ/100","v":0},null,{"$f":"S79*AnteilGIZ/100","v":0},null,{"$f":"U79*AnteilGIZ/100","v":0},null,{"$f":"W79*AnteilGIZ/100","v":0},null,{"$f":"Y79*AnteilGIZ/100","v":0},null,{"$f":"AA79*AnteilGIZ/100","v":0},null,{"$f":"AC79*AnteilGIZ/100","v":0},null,{"$f":"K79-O79-Q79-S79-U79-W79-Y79-AA79-AC79","v":0},{"$f":"M79-P79-R79-T79-V79-X79-Z79-AB79-AD79","v":0},null,null,{"$f":"C79","v":"<Country of assignment>"}]
[null,"  c","Travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C77","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J77","v":0},{"$f":"J81","v":0},{"$f":"K81*AnteilFremd/100","v":0},{"$f":"K81-L81","v":0},null,null,{"$f":"O81*AnteilGIZ/100","v":0},null,{"$f":"Q81*AnteilGIZ/100","v":0},null,{"$f":"S81*AnteilGIZ/100","v":0},null,{"$f":"U81*AnteilGIZ/100","v":0},null,{"$f":"W81*AnteilGIZ/100","v":0},null,{"$f":"Y81*AnteilGIZ/100","v":0},null,{"$f":"AA81*AnteilGIZ/100","v":0},null,{"$f":"AC81*AnteilGIZ/100","v":0},null,{"$f":"K81-O81-Q81-S81-U81-W81-Y81-AA81-AC81","v":0},{"$f":"M81-P81-R81-T81-V81-X81-Z81-AB81-AD81","v":0},null,null,{"$f":"C81","v":"<Country of assignment>"}]
[null,"  d","Flight costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C79","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G79","v":0},{"$f":"IF(G83=1,\"flight\",\"flights\")","v":"flights"},"up to",{"$f":"'Price schedule'!J79","v":0},{"$f":"G83*J83","v":0},{"$f":"K83*AnteilFremd/100","v":0},{"$f":"K83-L83","v":0},null,null,{"$f":"O83*AnteilGIZ/100","v":0},null,{"$f":"Q83*AnteilGIZ/100","v":0},null,{"$f":"S83*AnteilGIZ/100","v":0},null,{"$f":"U83*AnteilGIZ/100","v":0},null,{"$f":"W83*AnteilGIZ/100","v":0},null,{"$f":"Y83*AnteilGIZ/100","v":0},null,{"$f":"AA83*AnteilGIZ/100","v":0},null,{"$f":"AC83*AnteilGIZ/100","v":0},null,{"$f":"K83-O83-Q83-S83-U83-W83-Y83-AA83-AC83","v":0},{"$f":"M83-P83-R83-T83-V83-X83-Z83-AB83-AD83","v":0},null,null,{"$f":"C83","v":"<from – to>"}]
[]
[null,null,"Sum travel expenses",null,null,null,null,null,null,null,{"$f":"SUM(K75:K84)","v":0},{"$f":"SUM(L75:L84)","v":0},{"$f":"SUM(M75:M84)","v":0},null,{"$f":"SUM(O75:O84)","v":0},{"$f":"SUM(P75:P84)","v":0},{"$f":"SUM(Q75:Q84)","v":0},{"$f":"SUM(R75:R84)","v":0},{"$f":"SUM(S75:S84)","v":0},{"$f":"SUM(T75:T84)","v":0},{"$f":"SUM(U75:U84)","v":0},{"$f":"SUM(V75:V84)","v":0},{"$f":"SUM(W75:W84)","v":0},{"$f":"SUM(X75:X84)","v":0},{"$f":"SUM(Y75:Y84)","v":0},{"$f":"SUM(Z75:Z84)","v":0},{"$f":"SUM(AA75:AA84)","v":0},{"$f":"SUM(AB75:AB84)","v":0},{"$f":"SUM(AC75:AC84)","v":0},{"$f":"SUM(AD75:AD84)","v":0},null,{"$f":"SUM(AF75:AF84)","v":0},0]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K74+K85","v":0},0,0,null,{"$f":"O74+O85","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD74+AD85","v":0},null,{"$f":"AF74+AF85","v":0},{"$f":"AG74+AG85","v":0}]
[]
[null,"3.4.4","Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C86","v":"<Name, poss. quantity / unit>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K86","v":0},{"$f":"K90*AnteilFremd/100","v":0},{"$f":"K90-L90","v":0},null,null,{"$f":"O90*AnteilGIZ/100","v":0},null,{"$f":"Q90*AnteilGIZ/100","v":0},null,{"$f":"S90*AnteilGIZ/100","v":0},null,{"$f":"U90*AnteilGIZ/100","v":0},null,{"$f":"W90*AnteilGIZ/100","v":0},null,{"$f":"Y90*AnteilGIZ/100","v":0},null,{"$f":"AA90*AnteilGIZ/100","v":0},null,{"$f":"AC90*AnteilGIZ/100","v":0},null,{"$f":"K90-O90-Q90-S90-U90-W90-Y90-AA90-AC90","v":0},{"$f":"M90-P90-R90-T90-V90-X90-Z90-AB90-AD90","v":0},null,{"$f":"C90","v":"<Name, poss. quantity / unit>"}]
[null,null,{"$f":"'Price schedule'!C87","v":"<Consumables, if applicable amount/unit>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K87","v":0},{"$f":"K91*AnteilFremd/100","v":0},{"$f":"K91-L91","v":0},null,null,{"$f":"O91*AnteilGIZ/100","v":0},null,{"$f":"Q91*AnteilGIZ/100","v":0},null,{"$f":"S91*AnteilGIZ/100","v":0},null,{"$f":"U91*AnteilGIZ/100","v":0},null,{"$f":"W91*AnteilGIZ/100","v":0},null,{"$f":"Y91*AnteilGIZ/100","v":0},null,{"$f":"AA91*AnteilGIZ/100","v":0},null,{"$f":"AC91*AnteilGIZ/100","v":0},null,0,0,null,{"$f":"C91","v":"<Consumables, if applicable amount/unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K89:K92)","v":0},{"$f":"SUM(L89:L92)","v":0},{"$f":"SUM(M89:M92)","v":0},null,{"$f":"SUM(O89:O92)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Y89:Y92)","v":0},0,0,0,0,0,null,{"$f":"SUM(AF89:AF92)","v":0},{"$f":"SUM(AG89:AG92)","v":0}]
[]
[null,"3.4.6","Other costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"'Price schedule'!C92","v":"<Operating costs in accordance with the Guidelines on Eligible Costs>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K92","v":0},{"$f":"K96*AnteilFremd/100","v":0},{"$f":"K96-L96","v":0},null,null,{"$f":"O96*AnteilGIZ/100","v":0},null,{"$f":"Q96*AnteilGIZ/100","v":0},null,{"$f":"S96*AnteilGIZ/100","v":0},null,{"$f":"U96*AnteilGIZ/100","v":0},null,{"$f":"W96*AnteilGIZ/100","v":0},null,{"$f":"Y96*AnteilGIZ/100","v":0},null,{"$f":"AA96*AnteilGIZ/100","v":0},null,{"$f":"AC96*AnteilGIZ/100","v":0},null,{"$f":"K96-O96-Q96-S96-U96-W96-Y96-AA96-AC96","v":0},{"$f":"M96-P96-R96-T96-V96-X96-Z96-AB96-AD96","v":0},null,{"$f":"C96","v":"<Operating costs in accordance with the Guidelines on Eligible Costs>"}]
[null,null,{"$f":"'Price schedule'!C93","v":"<Depreciation of equipment in accordance with the Guidelines on Eligible Costs>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K93","v":0},{"$f":"K97*AnteilFremd/100","v":0},{"$f":"K97-L97","v":0},null,null,{"$f":"O97*AnteilGIZ/100","v":0},null,{"$f":"Q97*AnteilGIZ/100","v":0},null,{"$f":"S97*AnteilGIZ/100","v":0},null,{"$f":"U97*AnteilGIZ/100","v":0},null,{"$f":"W97*AnteilGIZ/100","v":0},null,{"$f":"Y97*AnteilGIZ/100","v":0},null,{"$f":"AA97*AnteilGIZ/100","v":0},null,{"$f":"AC97*AnteilGIZ/100","v":0},null,0,0,null,{"$f":"C97","v":"<Depreciation of equipment in accordance with the Guidelines on Eligible Costs>"}]
[null,null,{"$f":"'Price schedule'!C94","v":"<Workshop costs>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K94","v":0},{"$f":"K98*AnteilFremd/100","v":0},{"$f":"K98-L98","v":0},null,null,{"$f":"O98*AnteilGIZ/100","v":0},null,{"$f":"Q98*AnteilGIZ/100","v":0},null,{"$f":"S98*AnteilGIZ/100","v":0},null,{"$f":"U98*AnteilGIZ/100","v":0},null,{"$f":"W98*AnteilGIZ/100","v":0},null,{"$f":"Y98*AnteilGIZ/100","v":0},null,{"$f":"AA98*AnteilGIZ/100","v":0},null,{"$f":"AC98*AnteilGIZ/100","v":0},null,0,0,null,{"$f":"C98","v":"<Workshop costs>"}]
[null,null,{"$f":"'Price schedule'!C95","v":"Audit report"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K95","v":0},{"$f":"K99*AnteilFremd/100","v":0},0,null,null,{"$f":"O99*AnteilGIZ/100","v":0},null,{"$f":"Q99*AnteilGIZ/100","v":0},null,{"$f":"S99*AnteilGIZ/100","v":0},null,{"$f":"U99*AnteilGIZ/100","v":0},null,{"$f":"W99*AnteilGIZ/100","v":0},null,{"$f":"Y99*AnteilGIZ/100","v":0},null,{"$f":"AA99*AnteilGIZ/100","v":0},null,{"$f":"AC99*AnteilGIZ/100","v":0},null,0,0,null,"Audit report"]
[null,null,{"$f":"'Price schedule'!C96","v":"<Name, poss. quantity / unit>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K96","v":0},{"$f":"K100*AnteilFremd/100","v":0},0,null,null,{"$f":"O100*AnteilGIZ/100","v":0},null,{"$f":"Q100*AnteilGIZ/100","v":0},null,{"$f":"S100*AnteilGIZ/100","v":0},null,{"$f":"U100*AnteilGIZ/100","v":0},null,{"$f":"W100*AnteilGIZ/100","v":0},null,{"$f":"Y100*AnteilGIZ/100","v":0},null,{"$f":"AA100*AnteilGIZ/100","v":0},null,{"$f":"AC100*AnteilGIZ/100","v":0},null,0,0,null,"<Name, poss. quantity / unit>"]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K95:K101)","v":0},{"$f":"SUM(L95:L101)","v":0},{"$f":"SUM(M95:M101)","v":0},null,{"$f":"SUM(O95:O101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF95:AF101)","v":0},{"$f":"SUM(AG95:AG101)","v":0}]
[]
[null,"Total costs of contract (excl. statutory VAT)",null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$26:$B$103,$B$102,K$26:K$103)","v":0},{"$f":"K104*AnteilFremd/100","v":0},{"$f":"K104-L104","v":0},null,{"$f":"SUMIF($B$26:$B$103,$B$102,O$26:O$103)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIF($B$26:$B$103,$B$102,AF$26:AF$103)","v":0},{"$f":"SUMIF($B$26:$B$103,$B$102,AG$26:AG$103)","v":0},null,null,null,null,null,1]
[null,"Share in cost of contract (%)",null,null,null,null,null,null,null,null,100,{"$f":"AnteilFremd","v":100},{"$f":"K105-L105","v":0}]
[]
[null,null,"Further GIZ contributions to the measure",null,null,null,null,null,null,null,{"$f":"M107","v":0},null,{"$f":"'Price schedule'!M103","v":0},null,null,{"$f":"O107","v":0},null,{"$f":"Q107","v":0},null,{"$f":"S107","v":0},null,{"$f":"U107","v":0},null,{"$f":"W107","v":0},null,{"$f":"Y107","v":0},null,{"$f":"AA107","v":0},null,{"$f":"AC107","v":0}]
[null,"Total costs",null,null,null,null,null,null,null,null,{"$f":"K107+K104","v":0},{"$f":"L104+L107","v":0},{"$f":"M104+M107","v":0},null,{"$f":"O104+O107","v":0},{"$f":"P104+P107","v":0},{"$f":"Q104+Q107","v":0},0,0,0,0,0,0,0,{"$f":"Y104+Y107","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumulated costs for the entire reporting period (without further GIZ contributions)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"from:",{"$f":"P23","v":"00:00:00"},"to:",{"$f":"IF(AI24<>0,AI24,IF(Z24<>\"\",Z24,IF(X24<>\"\",X24,IF(V24<>\"\",V24,IF(T24<>\"\",T24,IF(R24<>\"\",R24,P24))))))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,"GIZ share"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O104+Q104+S104+U104+W104+Y104+AA104+AC104","v":0},null,null,null,{"$f":"SUM(P104,R104,T104,V104,X104,Z104,AB104,AD104)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,"Signature"]

{"sheet":"Notes","index":3,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Note on general use of this document"]
[null,null,"v.2"]
[]
[null,null,"Important note on the macros in this file:"]
[null,null,"To make possible the addition and deletion of lines and blocks, completion of the price schedule and the generation of a contract supplement, the macros in this document must be retained and be activated after opening."]
[null,null,"1. If the file is saved manually, always select \"Excel worksheet with macros (*.xlsm) as file type. "]
[null,null,"2. After opening the file, select 'Enable content' in the warning message (yellow bar at the top edge)."]
[]
[null,null,"The following instructions apply for the functions in the price schedule:"]
[null,null,"- Insert new lines below the highlighted cell."]
[null,null,"- Always insert a new below (before the external experts)."]
[null,null,"- The highlighted line or block is always deleted."]
[null,null,"- One line must be retained for each type of entry line."]
[]
[null,null,"'Prepare for print' automatically sets the print layout and inserts the entered contract number in the footer."]
[]
[null,null,"Note on Excel bug which can arise in this file"]
[null,null,"It is possible that individual cells may not be automatically calculated despite containing the correct formula. If the file macros are activated, recalculation of all cells is forced after opening and before printing. In addition, the button provided for this purpose in the worksheets can be clicked."]
[]
[null,null,"Notes on the price schedule:"]
[null,"1.","Only prime costs are eligible for reimbursement in accordance with the percentage agreed in the contract."]
[null,"2.","All items listed in the price schedule are stated as maximum values \n(amounts and costs per unit i.e. ‘up to’)."]
[null,null,"=> PLEASE read the Guidelines on Eligible Costs in (i)DPPs"]
[]
[null,null,"Notes on the statement of costs:"]
[null,"1.","For the PPP contribution, all amounts shown are regarded as maximum values (i.e. 'up to')."]
[null,"2.","Deviations in an individual budget item can be offset against other budget items up to a total of 10% of the respective item. Deviations beyond this require prior agreement by GIZ."]