{"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":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"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'!AB4),'List of costs'!AB4,TODAY())","v":41695},1,{"$f":"DATE(YEAR($A$4)+1,1-$B4,1)","v":"2014-12-01"},{"$f":"C4","v":"2014-12-01"}]
[null,2,{"$f":"DATE(YEAR($A$4)+1,1-$B5,1)","v":"2014-11-01"},"2014-11-01"]
[null,3,"2014-10-01","2014-10-01"]
[null,4,"2014-09-01","2014-09-01"]
[null,5,"2014-08-01","2014-08-01"]
[null,6,"2014-07-01","2014-07-01"]
[null,7,"2014-06-01","2014-06-01"]
[null,8,"2014-05-01","2014-05-01"]
[null,9,"2014-04-01","2014-04-01"]
[null,10,"2014-03-01","2014-03-01"]
[null,11,"2014-02-01","2014-02-01"]
[null,12,"2014-01-01","2014-01-01"]
[null,13,"2013-12-01","2013-12-01"]
[null,14,"2013-11-01","2013-11-01"]
[null,15,"2013-10-01","2013-10-01"]
[null,16,"2013-09-01","2013-09-01"]
[null,17,"2013-08-01","2013-08-01"]
[null,18,"2013-07-01","2013-07-01"]
[null,19,"2013-06-01","2013-06-01"]
[null,20,"2013-05-01","2013-05-01"]
[null,21,"2013-04-01","2013-04-01"]
[null,22,"2013-03-01","2013-03-01"]
[null,23,"2013-02-01","2013-02-01"]
[null,24,"2013-01-01","2013-01-01"]
[null,25,"2012-12-01","2012-12-01"]
[null,26,"2012-11-01","2012-11-01"]
[null,27,"2012-10-01","2012-10-01"]
[null,28,"2012-09-01","2012-09-01"]
[null,29,"2012-08-01","2012-08-01"]
[null,30,"2012-07-01","2012-07-01"]
[null,31,"2012-06-01","2012-06-01"]
[null,32,"2012-05-01","2012-05-01"]
[null,33,"2012-04-01","2012-04-01"]
[null,34,"2012-03-01","2012-03-01"]
[null,35,"2012-02-01","2012-02-01"]
[null,36,"2012-01-01","2012-01-01"]
[null,37,"2011-12-01","2011-12-01"]
[null,38,"2011-11-01","2011-11-01"]
[null,39,"2011-10-01","2011-10-01"]
[null,40,"2011-09-01","2011-09-01"]
[null,41,"2011-08-01","2011-08-01"]
[null,42,"2011-07-01","2011-07-01"]
[null,43,"2011-06-01","2011-06-01"]
[null,44,"2011-05-01","2011-05-01"]
[null,45,"2011-04-01","2011-04-01"]
[null,46,"2011-03-01","2011-03-01"]
[null,47,"2011-02-01","2011-02-01"]
[null,48,"2011-01-01","2011-01-01"]

{"sheet":"Price schedule","index":1,"n_rows":86,"n_cols":20,"rows_kept":86,"cut":false,"hidden":false,"merged":[[40,2,40,4],[6,8,6,10],[6,11,6,12],[3,4,3,12],[9,4,9,7],[9,8,9,10],[9,11,9,12],[6,4,6,7],[18,1,18,12],[21,2,21,4],[24,2,24,4],[12,4,12,12],[15,4,15,12],[16,1,16,4],[16,5,16,7],[16,8,16,9],[26,2,26,4],[28,2,28,4],[30,2,30,4],[72,2,72,7],[34,1,34,12],[37,2,37,4],[42,2,42,4],[71,2,71,7],[44,2,44,4],[46,2,46,4],[57,2,57,4],[59,2,59,4],[61,2,61,4],[66,2,66,7],[52,2,52,4],[55,2,55,4]]}
[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$18:$Q$51)","v":1}]
[]
[]
[null,null,null,null,"(all figures in the columns are assumed maxima, i.e. 'up to')",null,null,null,null,null,null,null,null,null,"Hilfsspalten, auszublenden"]
[null,"Name \n\n",null,null,null,"Quantity / \nUnit \n",null,null,"Costs in EUR \nof quantity / \nunit ",null,"Total costs \n\nin EUR ","Partner Share  \n\nin EUR ","Share of GIZ \n\nin EUR ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(Q19+64)","v":"@"},"<Name of enterprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$18:R18)","v":0},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"11.3","Daily rates / salaries for the private enterprise’s employees "]
[null,null,"<Name, function>",null,null,null,null,{"$f":"IF(G22=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G22*J22","v":0},{"$f":"K22*AnteilFremd/100","v":0},{"$f":"K22-L22","v":0},null,null,{"$f":"C22","v":"<Name, function>"}]
[null,"11.5","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(G25=1,\"day\",\"days\")","v":"days"},"at",null,{"$f":"G25*J25","v":0},{"$f":"K25*AnteilFremd/100","v":0},{"$f":"K25-L25","v":0},null,null,{"$f":"C25","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(G27=1,\"night\",\"nights\")","v":"nights"},"at",null,{"$f":"G27*J27","v":0},{"$f":"K27*AnteilFremd/100","v":0},{"$f":"K27-L27","v":0},null,null,{"$f":"C27","v":"<Country of assignment>"}]
[null,"  c/d","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":"J29","v":0},{"$f":"K29*AnteilFremd/100","v":0},{"$f":"K29-L29","v":0},null,null,{"$f":"C29","v":"<Country of assignment>"}]
[null,"  e","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(G31=1,\"flight\",\"flights\")","v":"flights"},"at",null,{"$f":"G31*J31","v":0},{"$f":"K31*AnteilFremd/100","v":0},{"$f":"K31-L31","v":0},null,null,{"$f":"C31","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K20:K32)","v":0},{"$f":"SUM(L20:L32)","v":0},{"$f":"SUM(M20:M32)","v":0},null,null,null,null,{"$f":"K33","v":0}]
[]
[{"$f":"CHAR(Q35+64)","v":"A"},"<Name of enterprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$18:R34)","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(G38=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G38*J38","v":0},{"$f":"K38*AnteilFremd/100","v":0},{"$f":"K38-L38","v":0},null,null,{"$f":"C38","v":"<Name, function>"}]
[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(G41=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G41*J41","v":0},{"$f":"K41*AnteilFremd/100","v":0},{"$f":"K41-L41","v":0},null,null,{"$f":"C41","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(G43=1,\"night\",\"nights\")","v":"nights"},"up to",null,{"$f":"G43*J43","v":0},{"$f":"K43*AnteilFremd/100","v":0},{"$f":"K43-L43","v":0},null,null,{"$f":"C43","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":"J45","v":0},{"$f":"K45*AnteilFremd/100","v":0},{"$f":"K45-L45","v":0},null,null,{"$f":"C45","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(G47=1,\"flight\",\"flights\")","v":"flights"},"up to",null,{"$f":"G47*J47","v":0},{"$f":"K47*AnteilFremd/100","v":0},{"$f":"K47-L47","v":0},null,null,{"$f":"C47","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K36:K48)","v":0},{"$f":"SUM(L36:L48)","v":0},{"$f":"SUM(M36:M48)","v":0},null,null,null,null,{"$f":"K49","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(G53=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G53*J53","v":0},{"$f":"K53*AnteilFremd/100","v":0},{"$f":"K53-L53","v":0},null,null,{"$f":"C53","v":"<Name, function>"}]
[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(G56=1,\"day\",\"days\")","v":"days"},"up to",null,{"$f":"G56*J56","v":0},{"$f":"K56*AnteilFremd/100","v":0},{"$f":"K56-L56","v":0},null,null,{"$f":"C56","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(G58=1,\"night\",\"nights\")","v":"nights"},"up to",null,{"$f":"G58*J58","v":0},{"$f":"K58*AnteilFremd/100","v":0},{"$f":"K58-L58","v":0},null,null,{"$f":"C58","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":"J60","v":0},{"$f":"K60*AnteilFremd/100","v":0},{"$f":"K60-L60","v":0},null,null,{"$f":"C60","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(G62=1,\"flight\",\"flights\")","v":"flights"},"up to",null,{"$f":"G62*J62","v":0},{"$f":"K62*AnteilFremd/100","v":0},{"$f":"K62-L62","v":0},null,null,{"$f":"C62","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K51:K63)","v":0},{"$f":"SUM(L51:L63)","v":0},{"$f":"SUM(M51:M63)","v":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":"K67*AnteilFremd/100","v":0},{"$f":"K67-L67","v":0},null,{"$f":"C67","v":"<Name, poss. quantity / unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K66:K68)","v":0},{"$f":"SUM(L66:L68)","v":0},{"$f":"SUM(M66:M68)","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,"Audit report",null,null,null,null,null,null,null,null,{"$f":"K72*AnteilFremd/100","v":0},{"$f":"K72-L72","v":0},null,{"$f":"C72","v":"Audit report"}]
[null,null,"<Name, poss. quantity / unit>",null,null,null,null,null,null,null,null,{"$f":"K73*AnteilFremd/100","v":0},{"$f":"K73-L73","v":0},null,{"$f":"C73","v":"<Name, poss. quantity / unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K71:K74)","v":0},{"$f":"SUM(L71:L74)","v":0},{"$f":"SUM(M71:M74)","v":0}]
[]
[null,"Costs of contract (excl. statutory VAT)",null,null,null,null,null,null,null,null,{"$f":"SUM($R$18:$R$51)+K64+K69+K75","v":0},{"$f":"K77*AnteilFremd/100","v":0},{"$f":"K77-L77","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":"K78-AnteilFremd","v":0}]
[]
[null,null,"Further GIZ contributions to the measure",null,null,null,null,null,null,null,null,null,{"$f":"K80","v":0}]
[null,"Total costs",null,null,null,null,null,null,null,null,{"$f":"L81+M81","v":0},{"$f":"L77","v":0},{"$f":"M77+M80","v":0}]
[null,"Share in total cost (%)",null,null,null,null,null,null,null,null,100,{"$f":"IF($K$81>0,ROUND(100*L81/$K$81,1),\"\")","v":""},{"$f":"IF($K$81>0,ROUND(100*M81/$K$81,1),\"\")","v":""}]
[]
[]
[]
[null,"Date",null,null,null,null,null,null,"Signature"]

{"sheet":"List of costs","index":2,"n_rows":96,"n_cols":35,"rows_kept":96,"cut":false,"hidden":true,"merged":[[76,2,76,7],[75,2,75,7],[61,2,61,4],[16,1,17,12],[28,2,28,4],[22,1,22,12],[25,2,25,4],[70,2,70,7],[63,2,63,4],[65,2,65,4],[86,14,86,21],[16,14,16,25],[88,14,89,17],[88,18,89,21],[91,14,91,17],[91,18,91,21],[3,14,3,15],[20,1,20,4],[20,8,20,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],[20,5,20,7],[6,14,6,15],[6,16,6,17],[12,11,12,12],[12,14,12,17],[15,4,15,12],[16,27,16,28],[17,14,17,15],[17,16,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,27,17,28],[18,27,19,28],[30,2,30,4],[32,2,32,4],[34,2,34,4],[59,2,59,4],[44,2,44,4],[50,2,50,4],[38,1,38,12],[41,2,41,4],[46,2,46,4],[48,2,48,4],[56,2,56,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,{"$f":"MAX($AG$22:$AG$55)","v":1}]
[]
[]
[null,null,null,null,"(all figures in the columns are assumed maxima, i.e. 'up to')",null,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,"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,"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,null,"Remaining residual funds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"from:",null,"from:",{"$f":"IF(AND(P20<>\"\",R20<>\"\"),IF(ISNUMBER(P20),DATE(YEAR(P20),MONTH(P20)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(R20<>\"\",T20<>\"\"),IF(ISNUMBER(R20),DATE(YEAR(R20),MONTH(R20)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(T20<>\"\",V20<>\"\"),IF(ISNUMBER(T20),DATE(YEAR(T20),MONTH(T20)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(V20<>\"\",X20<>\"\"),IF(ISNUMBER(V20),DATE(YEAR(V20),MONTH(V20)+1,1),\"\"),\"\")","v":""},"from:",{"$f":"IF(AND(X20<>\"\",Z20<>\"\"),IF(ISNUMBER(X20),DATE(YEAR(X20),MONTH(X20)+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,"Name \n\n",null,null,null,"Quantity /  \nUnit \n",null,null,"Costs in EUR  \nof quantity /  unit ",null,"Total costs \n\nin EUR ","Partner  \nshare \nin EUR ","Share of GIZ  \n\nin EUR ",null,"Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ","Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ","Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ","Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ","Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ","Actual \ncosts \nin EUR ","Share of GIZ \n\nin EUR ",null,"Total \n \nin EUR ","Share of GIZ \n\nin EUR ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(AG23+64)","v":"@"},{"$f":"'Price schedule'!B19","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,{"$f":"COUNT(AH$22:AH22)","v":0},null,1]
[null,"Private enterprise’s experts (prime costs)"]
[null,"11.3","Daily rates / salaries for the private enterprise’s employees "]
[null,null,{"$f":"'Price schedule'!C22","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G22","v":0},{"$f":"IF(G26=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J22","v":0},{"$f":"G26*J26","v":0},{"$f":"K26*AnteilFremd/100","v":0},{"$f":"K26-L26","v":0},null,null,{"$f":"O26*AnteilGIZ/100","v":0},null,{"$f":"Q26*AnteilGIZ/100","v":0},null,{"$f":"S26*AnteilGIZ/100","v":0},null,{"$f":"U26*AnteilGIZ/100","v":0},null,{"$f":"W26*AnteilGIZ/100","v":0},null,{"$f":"Y26*AnteilGIZ/100","v":0},null,{"$f":"K26-O26-Q26-S26-U26-W26-Y26","v":0},{"$f":"M26-P26-R26-T26-V26-X26-Z26","v":0},null,null,{"$f":"C26","v":"<Name, function>"}]
[null,"11.5","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,1]
[null,"  a","Per diem allowances"]
[null,null,{"$f":"'Price schedule'!C25","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G25","v":0},{"$f":"IF(G29=1,\"day\",\"days\")","v":"days"},"at",{"$f":"'Price schedule'!J25","v":0},{"$f":"G29*J29","v":0},{"$f":"K29*AnteilFremd/100","v":0},{"$f":"K29-L29","v":0},null,null,{"$f":"O29*AnteilGIZ/100","v":0},null,{"$f":"Q29*AnteilGIZ/100","v":0},null,{"$f":"S29*AnteilGIZ/100","v":0},null,{"$f":"U29*AnteilGIZ/100","v":0},null,{"$f":"W29*AnteilGIZ/100","v":0},null,{"$f":"Y29*AnteilGIZ/100","v":0},null,{"$f":"K29-O29-Q29-S29-U29-W29-Y29","v":0},{"$f":"M29-P29-R29-T29-V29-X29-Z29","v":0},null,null,{"$f":"C29","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,1]
[null,null,{"$f":"'Price schedule'!C27","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G27","v":0},{"$f":"IF(G31=1,\"night\",\"nights\")","v":"nights"},"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":"K31-O31-Q31-S31-U31-W31-Y31","v":0},{"$f":"M31-P31-R31-T31-V31-X31-Z31","v":0},null,null,{"$f":"C31","v":"<Country of assignment>"}]
[null,"  c/d","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,1]
[null,null,{"$f":"'Price schedule'!C29","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J29","v":0},{"$f":"J33","v":0},{"$f":"K33*AnteilFremd/100","v":0},{"$f":"K33-L33","v":0},null,null,{"$f":"O33*AnteilGIZ/100","v":0},null,{"$f":"Q33*AnteilGIZ/100","v":0},null,{"$f":"S33*AnteilGIZ/100","v":0},null,{"$f":"U33*AnteilGIZ/100","v":0},null,{"$f":"W33*AnteilGIZ/100","v":0},null,{"$f":"Y33*AnteilGIZ/100","v":0},null,{"$f":"K33-O33-Q33-S33-U33-W33-Y33","v":0},{"$f":"M33-P33-R33-T33-V33-X33-Z33","v":0},null,null,{"$f":"C33","v":"<Country of assignment>"}]
[null,"  e","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,1]
[null,null,{"$f":"'Price schedule'!C31","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G31","v":0},{"$f":"IF(G35=1,\"flight\",\"flights\")","v":"flights"},"at",{"$f":"'Price schedule'!J31","v":0},{"$f":"G35*J35","v":0},{"$f":"K35*AnteilFremd/100","v":0},{"$f":"K35-L35","v":0},null,null,{"$f":"O35*AnteilGIZ/100","v":0},null,{"$f":"Q35*AnteilGIZ/100","v":0},null,{"$f":"S35*AnteilGIZ/100","v":0},null,{"$f":"U35*AnteilGIZ/100","v":0},null,{"$f":"W35*AnteilGIZ/100","v":0},null,{"$f":"Y35*AnteilGIZ/100","v":0},null,{"$f":"K35-O35-Q35-S35-U35-W35-Y35","v":0},{"$f":"M35-P35-R35-T35-V35-X35-Z35","v":0},null,null,{"$f":"C35","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K24:K36)","v":0},{"$f":"SUM(L24:L36)","v":0},{"$f":"SUM(M24:M36)","v":0},null,{"$f":"SUM(O24:O36)","v":0},{"$f":"SUM(P24:P36)","v":0},{"$f":"SUM(Q24:Q36)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AB24:AB36)","v":0},{"$f":"SUM(AC24:AC36)","v":0},null,null,null,null,{"$f":"K37","v":0}]
[]
[{"$f":"CHAR(AG39+64)","v":"A"},{"$f":"'Price schedule'!B35","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,{"$f":"COUNT(AH$22:AH38)","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'!C38","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G38","v":0},{"$f":"IF(G42=1,\"day\",\"days\")","v":"days"},"up to",{"$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":"K42-O42-Q42-S42-U42-W42-Y42","v":0},{"$f":"M42-P42-R42-T42-V42-X42-Z42","v":0},null,null,{"$f":"C42","v":"<Name, function>"}]
[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,1]
[null,"  a","Per diem allowances  "]
[null,null,{"$f":"'Price schedule'!C41","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G41","v":0},{"$f":"IF(G45=1,\"day\",\"days\")","v":"days"},"up to",{"$f":"'Price schedule'!J41","v":0},{"$f":"G45*J45","v":0},{"$f":"K45*AnteilFremd/100","v":0},{"$f":"K45-L45","v":0},null,null,{"$f":"O45*AnteilGIZ/100","v":0},null,{"$f":"Q45*AnteilGIZ/100","v":0},null,{"$f":"S45*AnteilGIZ/100","v":0},null,{"$f":"U45*AnteilGIZ/100","v":0},null,{"$f":"W45*AnteilGIZ/100","v":0},null,{"$f":"Y45*AnteilGIZ/100","v":0},null,{"$f":"K45-O45-Q45-S45-U45-W45-Y45","v":0},{"$f":"M45-P45-R45-T45-V45-X45-Z45","v":0},null,null,{"$f":"C45","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,1]
[null,null,{"$f":"'Price schedule'!C43","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G43","v":0},{"$f":"IF(G47=1,\"night\",\"nights\")","v":"nights"},"up to",{"$f":"'Price schedule'!J43","v":0},{"$f":"G47*J47","v":0},{"$f":"K47*AnteilFremd/100","v":0},{"$f":"K47-L47","v":0},null,null,{"$f":"O47*AnteilGIZ/100","v":0},null,{"$f":"Q47*AnteilGIZ/100","v":0},null,{"$f":"S47*AnteilGIZ/100","v":0},null,{"$f":"U47*AnteilGIZ/100","v":0},null,{"$f":"W47*AnteilGIZ/100","v":0},null,{"$f":"Y47*AnteilGIZ/100","v":0},null,{"$f":"K47-O47-Q47-S47-U47-W47-Y47","v":0},{"$f":"M47-P47-R47-T47-V47-X47-Z47","v":0},null,null,{"$f":"C47","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,1]
[null,null,{"$f":"'Price schedule'!C45","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J45","v":0},{"$f":"J49","v":0},{"$f":"K49*AnteilFremd/100","v":0},{"$f":"K49-L49","v":0},null,null,{"$f":"O49*AnteilGIZ/100","v":0},null,{"$f":"Q49*AnteilGIZ/100","v":0},null,{"$f":"S49*AnteilGIZ/100","v":0},null,{"$f":"U49*AnteilGIZ/100","v":0},null,{"$f":"W49*AnteilGIZ/100","v":0},null,{"$f":"Y49*AnteilGIZ/100","v":0},null,{"$f":"K49-O49-Q49-S49-U49-W49-Y49","v":0},{"$f":"M49-P49-R49-T49-V49-X49-Z49","v":0},null,null,{"$f":"C49","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,1]
[null,null,{"$f":"'Price schedule'!C47","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G47","v":0},{"$f":"IF(G51=1,\"flight\",\"flights\")","v":"flights"},"up to",{"$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":"K51-O51-Q51-S51-U51-W51-Y51","v":0},{"$f":"M51-P51-R51-T51-V51-X51-Z51","v":0},null,null,{"$f":"C51","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K40:K52)","v":0},{"$f":"SUM(L40:L52)","v":0},{"$f":"SUM(M40:M52)","v":0},null,{"$f":"SUM(O40:O52)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AB40:AB52)","v":0},{"$f":"SUM(AC40:AC52)","v":0},null,null,null,null,{"$f":"K53","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,"Ende",null,1]
[null,"3.4.2","Fee"]
[null,null,{"$f":"'Price schedule'!C53","v":"<Name, function>"},null,null,null,{"$f":"'Price schedule'!G53","v":0},{"$f":"IF(G57=1,\"day\",\"days\")","v":"days"},"up to",{"$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":"K57-O57-Q57-S57-U57-W57-Y57","v":0},{"$f":"M57-P57-R57-T57-V57-X57-Z57","v":0},null,null,{"$f":"C57","v":"<Name, function>"}]
[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,1]
[null,"  a","Per diem allowances"]
[null,null,{"$f":"'Price schedule'!C56","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G56","v":0},{"$f":"IF(G60=1,\"day\",\"days\")","v":"days"},"up to",{"$f":"'Price schedule'!J56","v":0},{"$f":"G60*J60","v":0},{"$f":"K60*AnteilFremd/100","v":0},{"$f":"K60-L60","v":0},null,null,{"$f":"O60*AnteilGIZ/100","v":0},null,{"$f":"Q60*AnteilGIZ/100","v":0},null,{"$f":"S60*AnteilGIZ/100","v":0},null,{"$f":"U60*AnteilGIZ/100","v":0},null,{"$f":"W60*AnteilGIZ/100","v":0},null,{"$f":"Y60*AnteilGIZ/100","v":0},null,{"$f":"K60-O60-Q60-S60-U60-W60-Y60","v":0},{"$f":"M60-P60-R60-T60-V60-X60-Z60","v":0},null,null,{"$f":"C60","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,1]
[null,null,{"$f":"'Price schedule'!C58","v":"<Country of assignment>"},null,null,null,{"$f":"'Price schedule'!G58","v":0},{"$f":"IF(G62=1,\"night\",\"nights\")","v":"nights"},"up to",{"$f":"'Price schedule'!J58","v":0},{"$f":"G62*J62","v":0},{"$f":"K62*AnteilFremd/100","v":0},{"$f":"K62-L62","v":0},null,null,{"$f":"O62*AnteilGIZ/100","v":0},null,{"$f":"Q62*AnteilGIZ/100","v":0},null,{"$f":"S62*AnteilGIZ/100","v":0},null,{"$f":"U62*AnteilGIZ/100","v":0},null,{"$f":"W62*AnteilGIZ/100","v":0},null,{"$f":"Y62*AnteilGIZ/100","v":0},null,{"$f":"K62-O62-Q62-S62-U62-W62-Y62","v":0},{"$f":"M62-P62-R62-T62-V62-X62-Z62","v":0},null,null,{"$f":"C62","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,1]
[null,null,{"$f":"'Price schedule'!C60","v":"<Country of assignment>"},null,null,null,"total",null,null,{"$f":"'Price schedule'!J60","v":0},{"$f":"J64","v":0},{"$f":"K64*AnteilFremd/100","v":0},{"$f":"K64-L64","v":0},null,null,{"$f":"O64*AnteilGIZ/100","v":0},null,{"$f":"Q64*AnteilGIZ/100","v":0},null,{"$f":"S64*AnteilGIZ/100","v":0},null,{"$f":"U64*AnteilGIZ/100","v":0},null,{"$f":"W64*AnteilGIZ/100","v":0},null,{"$f":"Y64*AnteilGIZ/100","v":0},null,{"$f":"K64-O64-Q64-S64-U64-W64-Y64","v":0},{"$f":"M64-P64-R64-T64-V64-X64-Z64","v":0},null,null,{"$f":"C64","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,1]
[null,null,{"$f":"'Price schedule'!C62","v":"<from – to>"},null,null,null,{"$f":"'Price schedule'!G62","v":0},{"$f":"IF(G66=1,\"flight\",\"flights\")","v":"flights"},"up to",{"$f":"'Price schedule'!J62","v":0},{"$f":"G66*J66","v":0},{"$f":"K66*AnteilFremd/100","v":0},{"$f":"K66-L66","v":0},null,null,{"$f":"O66*AnteilGIZ/100","v":0},null,{"$f":"Q66*AnteilGIZ/100","v":0},null,{"$f":"S66*AnteilGIZ/100","v":0},null,{"$f":"U66*AnteilGIZ/100","v":0},null,{"$f":"W66*AnteilGIZ/100","v":0},null,{"$f":"Y66*AnteilGIZ/100","v":0},null,{"$f":"K66-O66-Q66-S66-U66-W66-Y66","v":0},{"$f":"M66-P66-R66-T66-V66-X66-Z66","v":0},null,null,{"$f":"C66","v":"<from – to>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K55:K67)","v":0},{"$f":"SUM(L55:L67)","v":0},{"$f":"SUM(M55:M67)","v":0},null,{"$f":"SUM(O55:O67)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AB55:AB67)","v":0},{"$f":"SUM(AC55:AC67)","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,1]
[null,null,{"$f":"'Price schedule'!C67","v":"<Name, poss. quantity / unit>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K67","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":"K71-O71-Q71-S71-U71-W71-Y71","v":0},{"$f":"M71-P71-R71-T71-V71-X71-Z71","v":0},null,{"$f":"C71","v":"<Name, poss. quantity / unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K70:K72)","v":0},{"$f":"SUM(L70:L72)","v":0},{"$f":"SUM(M70:M72)","v":0},null,{"$f":"SUM(O70:O72)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AB70:AB72)","v":0},{"$f":"SUM(AC70:AC72)","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,1]
[null,null,{"$f":"'Price schedule'!C72","v":"Audit report"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K72","v":0},{"$f":"K76*AnteilFremd/100","v":0},{"$f":"K76-L76","v":0},null,null,{"$f":"O76*AnteilGIZ/100","v":0},null,{"$f":"Q76*AnteilGIZ/100","v":0},null,{"$f":"S76*AnteilGIZ/100","v":0},null,{"$f":"U76*AnteilGIZ/100","v":0},null,{"$f":"W76*AnteilGIZ/100","v":0},null,{"$f":"Y76*AnteilGIZ/100","v":0},null,{"$f":"K76-O76-Q76-S76-U76-W76-Y76","v":0},{"$f":"M76-P76-R76-T76-V76-X76-Z76","v":0},null,{"$f":"C76","v":"Audit report"}]
[null,null,{"$f":"'Price schedule'!C73","v":"<Name, poss. quantity / unit>"},null,null,null,null,null,null,null,{"$f":"'Price schedule'!K73","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":"K77-O77-Q77-S77-U77-W77-Y77","v":0},{"$f":"M77-P77-R77-T77-V77-X77-Z77","v":0},null,{"$f":"C77","v":"<Name, poss. quantity / unit>"}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K75:K78)","v":0},{"$f":"SUM(L75:L78)","v":0},{"$f":"SUM(M75:M78)","v":0},null,{"$f":"SUM(O75:O78)","v":0},{"$f":"SUM(P75:P78)","v":0},{"$f":"SUM(Q75:Q78)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AB75:AB78)","v":0},{"$f":"SUM(AC75:AC78)","v":0}]
[]
[null,"Total costs of contract (excl. statutory VAT)",null,null,null,null,null,null,null,null,{"$f":"SUMIF($B$22:$B$80,$B$79,K$22:K$80)","v":0},{"$f":"K81*AnteilFremd/100","v":0},{"$f":"K81-L81","v":0},null,{"$f":"SUMIF($B$22:$B$80,$B$79,O$22:O$80)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIF($B$22:$B$80,$B$79,AB$22:AB$80)","v":0},{"$f":"SUMIF($B$22:$B$80,$B$79,AC$22:AC$80)","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":"K82-L82","v":0}]
[]
[null,null,"Further GIZ contributions to the measure",null,null,null,null,null,null,null,{"$f":"M84","v":0},null,{"$f":"'Price schedule'!M80","v":0},null,null,{"$f":"O84","v":0},null,{"$f":"Q84","v":0},null,{"$f":"S84","v":0},null,{"$f":"U84","v":0},null,{"$f":"W84","v":0},null,{"$f":"Y84","v":0}]
[null,"Total costs",null,null,null,null,null,null,null,null,{"$f":"K84+K81","v":0},{"$f":"L81+L84","v":0},{"$f":"M81+M84","v":0},null,{"$f":"O81+O84","v":0},{"$f":"P81+P84","v":0},{"$f":"Q81+Q84","v":0},0,0,0,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":"P19","v":"00:00:00"},"to:",{"$f":"IF(Z20<>\"\",Z20,IF(X20<>\"\",X20,IF(V20<>\"\",V20,IF(T20<>\"\",T20,IF(R20<>\"\",R20,P20)))))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total in EUR",null,null,null,"GIZ share in EUR"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O81+Q81+S81+U81+W81+Y81","v":0},null,null,null,{"$f":"P81+R81+T81+V81+X81+Z81","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,"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.","This is a maximum budget ('up to')."]
[null,"2.","Please identify the above individual items as far possible, if necessary on a supplementary sheet. "]
[]
[]
[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."]