{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Listen","Bordereau de prix","État des coûts","Remarques"],"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":"Listen","index":0,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Auswahllisten"]
[]
["Datum",null,null,"Monate"]
[{"$f":"IF(ISNUMBER('État des coûts'!$Q$4),'État des coûts'!$Q$4,TODAY())","v":44755},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":"Bordereau de prix","index":1,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[107,1,107,4],[107,8,107,12],[67,2,67,4],[86,2,86,7],[92,2,92,7],[93,2,93,7],[95,2,95,7],[94,2,94,7],[37,2,37,4],[25,2,25,4],[31,2,31,4],[33,2,33,4],[35,2,35,4],[26,2,26,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],[12,4,12,12],[20,1,20,4],[20,5,20,7],[20,8,20,9],[22,1,22,12],[15,4,15,12],[18,1,18,12],[19,1,19,11],[43,1,43,12],[46,2,46,4],[52,2,52,4],[54,2,54,4],[91,2,91,7],[56,2,56,4],[58,2,58,4],[72,2,72,4],[74,2,74,4],[76,2,76,4],[78,2,78,4],[85,2,85,7],[66,2,66,4],[47,2,47,4]]}
[null,null,"Remarques"]
[null,"Bordereau de prix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Une fois le contrat conclu, le bordereau de prix est masqué et vous pouvez remplir le relevé des coûts."]
[]
[null,"Intitulé de l’action :"]
[]
[]
[null,"Pays :",null,null,"<Pays d’intervention du projet>",null,null,null,"Date :"]
[]
[]
[null,"Numéro de l’action :",null,null,null,null,null,null,"Numéro du contrat :"]
[]
[]
[null,"Partenaire contractuel :",null,null,"<Nom de l’entreprise privée>",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($Q$22:$Q$65)","v":1}]
[]
[]
[null,"Monnaie :",null,null,"< monnaie>",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($Q$22:$Q$65)","v":1}]
[]
[]
[null,"IMPORTANT : \n- Ne sont remboursables que les coûts de revient ou coûts réels directs correspondant au pourcentage fixé contractuellement\n- Tous les postes du bordereau des prix représentent des valeurs maximales (quantités et coûts par unité, c.-à-d. « jusqu’à »)\n=> PRIÈRE de respecter le Guide relatif aux coûts éligibles à remboursement dans le cadre de PD(i)SP !",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-fr.pdf"]
[null,"Nom/désignation \n",null,null,null,"Quantité/ \nunité ",null,null,"Coûts par  \n quantité/unité ",null,"Total des \n coûts ","Part de l’entre-\nprise privée ","Part de\nla GIZ ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(Q23+64)","v":"@"},"<Nom de l’entreprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$22:R22)","v":0},null,1]
[null,"Expert·e·s de l’entreprise (coûts de revient)"]
[null,"3.4.1","Taux journaliers / salaires des collaborateurs de l’entreprise"]
[null,null,"<Nom, fonction>",null,null,null,null,{"$f":"IF(G26=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G26*J26","v":0},{"$f":"K26*AnteilFremd/100","v":0},{"$f":"K26-L26","v":0},null,null,{"$f":"C26","v":"<Nom, fonction>"}]
[null,null,"<Nom, fonction>",null,null,null,null,{"$f":"IF(G27=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G27*J27","v":0},{"$f":"K27*AnteilFremd/100","v":0},{"$f":"K27-L27","v":0},null,null,{"$f":"C27","v":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des taux journaliers / salaires des collaborateurs de l’entreprise",null,null,null,null,null,null,null,{"$f":"SUM(K25:K28)","v":0},{"$f":"SUM(L25:L28)","v":0},{"$f":"SUM(M25:M28)","v":0}]
[null,"3.4.3","Frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Indemnités journalières"]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G32=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G32*J32","v":0},{"$f":"K32*AnteilFremd/100","v":0},{"$f":"K32-L32","v":0},null,null,{"$f":"C32","v":"<Pays d’intervention>"}]
[null,"b","Frais d’hébergement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G34=1,\"nuit\",\"nuits\")","v":"nuits"},"jusqu’à",null,{"$f":"G34*J34","v":0},{"$f":"K34*AnteilFremd/100","v":0},{"$f":"K34-L34","v":0},null,null,{"$f":"C34","v":"<Pays d’intervention>"}]
[null,"c","Frais de voyage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",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":"<Pays d’intervention>"}]
[null,"d","Frais de transport aérien (classe économique)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<de - à>",null,null,null,null,{"$f":"IF(G38=1,\"vol\",\"vols\")","v":"vols"},"jusqu’à",null,{"$f":"G38*J38","v":0},{"$f":"K38*AnteilFremd/100","v":0},{"$f":"K38-L38","v":0},null,null,{"$f":"C38","v":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,{"$f":"SUM(K30:K39)","v":0},{"$f":"SUM(L30:L39)","v":0},{"$f":"SUM(M30:M39)","v":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"},"<Nom de l’entreprise>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R$22:R43)","v":1},null,1]
[null,"Expert·e·s de l’entreprise (coûts de revient)"]
[null,"3.4.1","Taux journaliers / salaires des collaborateurs de l’entreprise"]
[null,null,"<Nom, fonction>",null,null,null,null,{"$f":"IF(G47=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G47*J47","v":0},{"$f":"K47*AnteilFremd/100","v":0},{"$f":"K47-L47","v":0},null,null,{"$f":"C47","v":"<Nom, fonction>"}]
[null,null,"<Nom, fonction>",null,null,null,null,{"$f":"IF(G48=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G48*J48","v":0},{"$f":"K48*AnteilFremd/100","v":0},{"$f":"K48-L48","v":0},null,null,{"$f":"C48","v":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des taux journaliers / salaires des collaborateurs de l’entreprise",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","Frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"a","Indemnités journalières"]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G53=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G53*J53","v":0},{"$f":"K53*AnteilFremd/100","v":0},{"$f":"K53-L53","v":0},null,null,{"$f":"C53","v":"<Pays d’intervention>"}]
[null,"b","Frais d’hébergement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G55=1,\"nuit\",\"nuits\")","v":"nuits"},"jusqu’à",null,{"$f":"G55*J55","v":0},{"$f":"K55*AnteilFremd/100","v":0},{"$f":"K55-L55","v":0},null,null,{"$f":"C55","v":"<Pays d’intervention>"}]
[null,"c","Frais de voyage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",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":"<Pays d’intervention>"}]
[null,"d","Frais de transport aérien (classe économique)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<de - à>",null,null,null,null,{"$f":"IF(G59=1,\"vol\",\"vols\")","v":"vols"},"jusqu’à",null,{"$f":"G59*J59","v":0},{"$f":"K59*AnteilFremd/100","v":0},{"$f":"K59-L59","v":0},null,null,{"$f":"C59","v":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,{"$f":"SUM(K51:K60)","v":0},{"$f":"SUM(L51:L60)","v":0},{"$f":"SUM(M51:M60)","v":0}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K50+K61","v":0},{"$f":"L50+L61","v":0},{"$f":"M50+M61","v":0},null,null,null,null,{"$f":"K63","v":0}]
[]
[null,"Expert·e·s externes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ende",null,1]
[null,"3.4.2","Honoraires"]
[null,null,"<Nom, fonction>",null,null,null,null,"Jours","jusqu’à",null,{"$f":"G67*J67","v":0},{"$f":"K67*AnteilFremd/100","v":0},{"$f":"K67-L67","v":0},null,null,{"$f":"C67","v":"<Nom, fonction>"}]
[null,null,"<Nom, fonction>",null,null,null,null,"Jours","jusqu’à",null,{"$f":"G68*J68","v":0},{"$f":"K68*AnteilFremd/100","v":0},{"$f":"K68-L68","v":0},null,null,{"$f":"C68","v":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des honoraires",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,null,null,null,{"$f":"K70","v":0}]
[null,"3.4.3","Frais de voyage (conformément aux directives fiscales)"]
[null,"a","Indemnités journalières"]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G73=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",null,{"$f":"G73*J73","v":0},{"$f":"K73*AnteilFremd/100","v":0},{"$f":"K73-L73","v":0},null,null,{"$f":"C73","v":"<Pays d’intervention>"}]
[null,"b","Frais d’hébergement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",null,null,null,null,{"$f":"IF(G75=1,\"nuit\",\"nuits\")","v":"nuits"},"jusqu’à",null,{"$f":"G75*J75","v":0},{"$f":"K75*AnteilFremd/100","v":0},{"$f":"K75-L75","v":0},null,null,{"$f":"C75","v":"<Pays d’intervention>"}]
[null,"c","Frais de voyage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Pays d’intervention>",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":"<Pays d’intervention>"}]
[null,"d","Frais de transport aérien (classe économique)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<de - à>",null,null,null,null,{"$f":"IF(G79=1,\"vol\",\"vols\")","v":"vols"},"jusqu’à",null,{"$f":"G79*J79","v":0},{"$f":"K79*AnteilFremd/100","v":0},{"$f":"K79-L79","v":0},null,null,{"$f":"C79","v":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",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,null,null,null,{"$f":"K81","v":0}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K70+K81","v":0},0,0]
[]
[null,"3.4.4","Matériels et équipements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Biens d’équipement, le cas échéant quantité / unité>",null,null,null,null,null,null,null,null,{"$f":"K86*AnteilFremd/100","v":0},{"$f":"K86-L86","v":0},null,{"$f":"C86","v":"<Biens d’équipement, le cas échéant quantité / unité>"}]
[null,null,"<Biens de consommation, le cas échéant quantité / unité>",null,null,null,null,null,null,null,null,{"$f":"K87*AnteilFremd/100","v":0},{"$f":"K87-L87","v":0},null,{"$f":"C87","v":"<Biens de consommation, le cas échéant quantité / 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","Autres frais",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"<Coûts d’exploitation conformément au Guide relatif aux coûts éligibles à remboursement>",null,null,null,null,null,null,null,null,{"$f":"K92*AnteilFremd/100","v":0},{"$f":"K92-L92","v":0},null,{"$f":"C92","v":"<Coûts d’exploitation conformément au Guide relatif aux coûts éligibles à remboursement>"}]
[null,null,"<Amortissement de biens d’équipement conformément au Guide relatif aux coûts éligibles à remboursement>",null,null,null,null,null,null,null,null,{"$f":"K93*AnteilFremd/100","v":0},{"$f":"K93-L93","v":0},null,{"$f":"C93","v":"<Amortissement de biens d’équipement conformément au Guide relatif aux coûts éligibles à remboursement>"}]
[null,null,"<Coûts de l’atelier>",null,null,null,null,null,null,null,null,{"$f":"K94*AnteilFremd/100","v":0},{"$f":"K94-L94","v":0},null,{"$f":"C94","v":"<Coûts de l’atelier>"}]
[null,null,"Audit/rapport d’examen",null,null,null,null,null,null,null,null,{"$f":"K95*AnteilFremd/100","v":0},{"$f":"K95-L95","v":0},null,{"$f":"C95","v":"Audit/rapport d’examen"}]
[null,null,"<Désignation, le cas échéant quantité/unité>",null,null,null,null,null,null,null,null,{"$f":"K96*AnteilFremd/100","v":0},{"$f":"K96-L96","v":0},null,{"$f":"C96","v":"<Désignation, le cas échéant quantité/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,"Coûts du contrat (sans TVA au taux légal)",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,"Part des coûts du contrat (en pour cent)",null,null,null,null,null,null,null,null,100,100,{"$f":"K101-AnteilFremd","v":0}]
[]
[null,null,"Autres contributions de la GIZ à l’action",null,null,null,null,null,null,null,null,null,{"$f":"K103","v":0}]
[null,"Coûts totaux",null,null,null,null,null,null,null,null,{"$f":"L104+M104","v":0},{"$f":"L100","v":0},{"$f":"M100+M103","v":0}]
[null,"Part des coûts totaux (en pour cent)",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":"État des coûts","index":2,"n_rows":118,"n_cols":39,"rows_kept":118,"cut":false,"hidden":true,"merged":[[116,14,116,15],[116,17,116,21],[15,4,15,10],[15,11,15,12],[15,14,15,15],[15,16,15,17],[89,2,89,7],[20,1,21,12],[35,2,35,4],[26,1,26,12],[29,2,29,4],[18,1,18,12],[19,1,19,11],[30,2,30,4],[56,2,56,4],[62,2,62,4],[58,2,58,4],[60,2,60,4],[99,2,99,7],[95,2,95,7],[90,2,90,7],[96,2,96,7],[97,2,97,7],[98,2,98,7],[82,2,82,4],[70,2,70,4],[71,2,71,4],[76,2,76,4],[78,2,78,4],[80,2,80,4],[12,14,12,17],[111,14,111,17],[111,18,111,21],[113,14,113,17],[113,18,113,21],[109,14,109,21],[20,14,20,29],[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],[9,14,9,15],[9,16,9,17],[6,14,6,15],[6,16,6,17],[12,11,12,12],[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,24,21,25],[21,31,21,32],[21,26,21,27],[21,28,21,29],[22,31,23,32],[37,2,37,4],[39,2,39,4],[41,2,41,4],[51,2,51,4],[47,1,47,12],[50,2,50,4]]}
[]
[null,"État des coûts concernant :",null,null,null,null,null,null,null,null,null,null,null,null,"En raison d’un avenant au contrat, une nouvelle modification du bordereau des prix est possible."]
[]
[null,"Intitulé de l’action :",null,null,{"$f":"'Bordereau de prix'!E4","v":0},null,null,null,null,null,null,null,null,null,"Date :   "]
[]
[]
[null,"Pays :",null,null,{"$f":"'Bordereau de prix'!E7","v":"<Pays d’intervention du projet>"},null,null,null,null,null,null,null,null,null,"Durée de l’action :   "]
[]
[]
[null,"Numéro de l’action :",null,null,{"$f":"'Bordereau de prix'!E10","v":0},null,null,null,"Numéro du contrat :   ",null,null,{"$f":"'Bordereau de prix'!Vertragsnummer","v":0}]
[]
[]
[null,"Partenaire contractuel :",null,null,{"$f":"'Bordereau de prix'!E13","v":"<Nom de l’entreprise privée>"},null,null,null,null,null,null,"Interlocuteur :",null,null,"<Nom du responsable de l’état des coûts>",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$67)","v":1}]
[]
[]
[null,{"$f":"'Bordereau de prix'!B16","v":"Monnaie :"},null,null,{"$f":"'Bordereau de prix'!E16","v":"< monnaie>"},null,null,null,null,null,null,null,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$67)","v":1}]
[]
[]
[null,"IMPORTANT : \n- Ne sont remboursables que les coûts de revient ou coûts réels directs correspondant au pourcentage fixé contractuellement.\n- Tous les postes du bordereau des prix représentent des valeurs maximales (quantités et coûts par unité, c.-à-d. « jusqu’à »).\n=> PRIÈRE de respecter le Guide relatif aux coûts éligibles à remboursement dans le cadre de PD(i)SP !",null,null,null,null,null,null,null,null,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-fr.pdf"]
[null,"Informations issues du bordereau des prix\nCoûts prévisionnels",null,null,null,null,null,null,null,null,null,null,null,null,"Bordereau des prix par période sous revue - coûts réels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESTE \n(coûts prévisionnels moins coûts réels)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1re période sous revue",null,"2e période sous revue",null,"3e période sous revue",null,"4e période sous revue",null,"5e période sous revue",null,"6e période sous revue",null,"7e période sous revue",null,"8e période sous revue",null,null,"Reliquat restant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de :",null,"de :",{"$f":"IF(AND(P24<>\"\",R24<>\"\"),IF(ISNUMBER(P24),DATE(YEAR(P24),MONTH(P24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(R24<>\"\",T24<>\"\"),IF(ISNUMBER(R24),DATE(YEAR(R24),MONTH(R24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(T24<>\"\",V24<>\"\"),IF(ISNUMBER(T24),DATE(YEAR(T24),MONTH(T24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(V24<>\"\",X24<>\"\"),IF(ISNUMBER(V24),DATE(YEAR(V24),MONTH(V24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(X24<>\"\",Z24<>\"\"),IF(ISNUMBER(X24),DATE(YEAR(X24),MONTH(X24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(Z24<>\"\",AB24<>\"\"),IF(ISNUMBER(Z24),DATE(YEAR(Z24),MONTH(Z24)+1,1),\"\"),\"\")","v":""},"de :",{"$f":"IF(AND(AB24<>\"\",AD24<>\"\"),IF(ISNUMBER(AB24),DATE(YEAR(AB24),MONTH(AB24)+1,1),\"\"),\"\")","v":""},null,"(à la fin de l’ensemble de la période sous revue)"]
[null,null,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":"IF(AD24=\"\",IF(AB24=\"\",Z24,AB24),AD24)","v":0}]
[null,"Nom/désignation \n",null,null,null,"Quantité/ \nunité ",null,null,"Coûts par  \n quantité/unité ",null,"Total des \n coûts ","Part des partenaires ","Part de\nla GIZ ",null,"Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ","Coûts réels \n","Part de\nla GIZ ",null,"Total \n ","Part de\nla GIZ ",null,"Autozeilenhöhe breit","Autozeilenhöhe schmal","Block","Block \nUnternehmen Gesamtkosten","Umbruch davor erlaubt"]
[]
[{"$f":"CHAR(AK27+64)","v":"@"},{"$f":"'Bordereau de prix'!B23","v":"<Nom de l’entreprise>"},null,null,null,null,null,null,null,null,null,null,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,"Expert·e·s de l’entreprise (coûts de revient)"]
[null,"11.3","Taux journaliers / salaires des collaborateurs de l’entreprise"]
[null,null,{"$f":"'Bordereau de prix'!C26","v":"<Nom, fonction>"},null,null,null,{"$f":"'Bordereau de prix'!G26","v":0},{"$f":"IF(G30=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[null,null,{"$f":"'Bordereau de prix'!C27","v":"<Nom, fonction>"},null,null,null,{"$f":"'Bordereau de prix'!G27","v":0},{"$f":"IF(G31=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des taux journaliers / salaires des collaborateurs de l’entreprise",null,null,null,null,null,null,null,{"$f":"SUM(K29:K32)","v":0},{"$f":"SUM(L29:L32)","v":0},{"$f":"SUM(M29:M32)","v":0},null,{"$f":"SUM(O29:O32)","v":0},{"$f":"SUM(P29:P32)","v":0},{"$f":"SUM(Q29:Q32)","v":0},{"$f":"SUM(R29:R32)","v":0},{"$f":"SUM(S29:S32)","v":0},{"$f":"SUM(T29:T32)","v":0},{"$f":"SUM(U29:U32)","v":0},{"$f":"SUM(V29:V32)","v":0},{"$f":"SUM(W29:W32)","v":0},{"$f":"SUM(X29:X32)","v":0},{"$f":"SUM(Y29:Y32)","v":0},{"$f":"SUM(Z29:Z32)","v":0},{"$f":"SUM(AA29:AA32)","v":0},{"$f":"SUM(AB29:AB32)","v":0},{"$f":"SUM(AC29:AC32)","v":0},{"$f":"SUM(AD29:AD32)","v":0},null,{"$f":"SUM(AF29:AF32)","v":0},{"$f":"SUM(AG29:AG32)","v":0}]
[null,"11.5","Frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,null,null,null,null,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","Indemnités journalières"]
[null,null,{"$f":"'Bordereau de prix'!C32","v":"<Pays d’intervention>"},null,null,null,{"$f":"'Bordereau de prix'!G32","v":0},{"$f":"IF(G36=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"b","Frais d’hébergement",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C34","v":"<Pays d’intervention>"},null,null,null,{"$f":"'Bordereau de prix'!G34","v":0},{"$f":"IF(G38=1,\"nuit\",\"nuits\")","v":"nuits"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"c","Frais de voyage",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C36","v":"<Pays d’intervention>"},null,null,null,"Total",null,null,{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"d","Frais de transport aérien (classe économique)",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C38","v":"<de - à>"},null,null,null,{"$f":"'Bordereau de prix'!G38","v":0},{"$f":"IF(G42=1,\"vol\",\"vols\")","v":"vols"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,{"$f":"SUM(K34:K43)","v":0},{"$f":"SUM(L34:L43)","v":0},{"$f":"SUM(M34:M43)","v":0},null,{"$f":"SUM(O34:O43)","v":0},{"$f":"SUM(P34:P43)","v":0},{"$f":"SUM(Q34:Q43)","v":0},{"$f":"SUM(R34:R43)","v":0},{"$f":"SUM(S34:S43)","v":0},{"$f":"SUM(T34:T43)","v":0},{"$f":"SUM(U34:U43)","v":0},{"$f":"SUM(V34:V43)","v":0},{"$f":"SUM(W34:W43)","v":0},{"$f":"SUM(X34:X43)","v":0},{"$f":"SUM(Y34:Y43)","v":0},{"$f":"SUM(Z34:Z43)","v":0},{"$f":"SUM(AA34:AA43)","v":0},{"$f":"SUM(AB34:AB43)","v":0},{"$f":"SUM(AC34:AC43)","v":0},{"$f":"SUM(AD34:AD43)","v":0},null,{"$f":"SUM(AF34:AF43)","v":0},{"$f":"SUM(AG34:AG43)","v":0}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K33+K44","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,null,null,null,{"$f":"K46","v":0}]
[]
[{"$f":"CHAR(AK48+64)","v":"A"},{"$f":"'Bordereau de prix'!B44","v":"<Nom de l’entreprise>"},null,null,null,null,null,null,null,null,null,null,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,"Expert·e·s de l’entreprise (coûts de revient)"]
[null,"3.4.1","Taux journaliers / salaires des collaborateurs de l’entreprise"]
[null,null,{"$f":"'Bordereau de prix'!C47","v":"<Nom, fonction>"},null,null,null,{"$f":"'Bordereau de prix'!G47","v":0},{"$f":"IF(G51=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[null,null,{"$f":"'Bordereau de prix'!C48","v":"<Nom, fonction>"},null,null,null,{"$f":"'Bordereau de prix'!G48","v":0},{"$f":"IF(G52=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des taux journaliers / salaires des collaborateurs de l’entreprise",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","Frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,null,null,null,null,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","Indemnités journalières"]
[null,null,{"$f":"'Bordereau de prix'!C53","v":"<Pays d’intervention>"},null,null,null,{"$f":"'Bordereau de prix'!G53","v":0},{"$f":"IF(G57=1,\"jour\",\"jours\")","v":"jours"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"b","Frais d’hébergement",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C55","v":"<Pays d’intervention>"},null,null,null,{"$f":"'Bordereau de prix'!G55","v":0},{"$f":"IF(G59=1,\"nuit\",\"nuits\")","v":"nuits"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"c","Frais de voyage",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C57","v":"<Pays d’intervention>"},null,null,null,"Total",null,null,{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"d","Frais de transport aérien (classe économique)",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C59","v":"<de - à>"},null,null,null,{"$f":"'Bordereau de prix'!G59","v":0},{"$f":"IF(G63=1,\"vol\",\"vols\")","v":"vols"},"jusqu’à",{"$f":"'Bordereau de prix'!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":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,{"$f":"SUM(K55:K64)","v":0},{"$f":"SUM(L55:L64)","v":0},{"$f":"SUM(M55:M64)","v":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},{"$f":"SUM(AG55:AG64)","v":0}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"K54+K65","v":0},{"$f":"L54+L65","v":0},{"$f":"M54+M65","v":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},{"$f":"AG54+AG65","v":0},null,null,null,null,{"$f":"K67","v":0}]
[]
[null,"Expert·e·s externes",null,null,null,null,null,null,null,null,null,null,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","Honoraires"]
[null,null,{"$f":"'Bordereau de prix'!C67","v":"<Nom, fonction>"},null,null,{"$f":"'Bordereau de prix'!F67","v":0},{"$f":"'Bordereau de prix'!G67","v":0},{"$f":"'Bordereau de prix'!H67","v":"Jours"},{"$f":"'Bordereau de prix'!I67","v":"jusqu’à"},{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[null,null,{"$f":"'Bordereau de prix'!C68","v":"<Nom, fonction>"},null,null,{"$f":"'Bordereau de prix'!F68","v":0},{"$f":"'Bordereau de prix'!G68","v":0},{"$f":"'Bordereau de prix'!H68","v":"Jours"},{"$f":"'Bordereau de prix'!I68","v":"jusqu’à"},{"$f":"'Bordereau de prix'!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":"<Nom, fonction>"}]
[]
[null,null,"TOTAL des taux journaliers / salaires des collaborateurs de l’entreprise",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},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AF70:AF73)","v":0},0]
[null,"3.4.3","Frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,null,null,null,null,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",{"$f":"'Bordereau de prix'!C72","v":"Indemnités journalières"}]
[null,null,{"$f":"'Bordereau de prix'!C73","v":"<Pays d’intervention>"},null,null,{"$f":"'Bordereau de prix'!F73","v":0},{"$f":"'Bordereau de prix'!G73","v":0},{"$f":"'Bordereau de prix'!H73","v":"jours"},{"$f":"'Bordereau de prix'!I73","v":"jusqu’à"},{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"b",{"$f":"'Bordereau de prix'!C74","v":"Frais d’hébergement"},null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C75","v":"<Pays d’intervention>"},null,null,{"$f":"'Bordereau de prix'!F75","v":0},{"$f":"'Bordereau de prix'!G75","v":0},{"$f":"'Bordereau de prix'!H75","v":"nuits"},{"$f":"'Bordereau de prix'!I75","v":"jusqu’à"},{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"c",{"$f":"'Bordereau de prix'!C76","v":"Frais de voyage"},null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C77","v":"<Pays d’intervention>"},null,null,{"$f":"'Bordereau de prix'!F77","v":0},"Total",null,null,{"$f":"'Bordereau de prix'!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":"<Pays d’intervention>"}]
[null,"d",{"$f":"'Bordereau de prix'!C78","v":"Frais de transport aérien (classe économique)"},null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C79","v":"<de - à>"},null,null,{"$f":"'Bordereau de prix'!F79","v":0},{"$f":"'Bordereau de prix'!G79","v":0},{"$f":"'Bordereau de prix'!H79","v":"vols"},{"$f":"'Bordereau de prix'!I79","v":"jusqu’à"},{"$f":"'Bordereau de prix'!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":"<de - à>"}]
[]
[null,null,"TOTAL des frais de voyage (conformément aux directives fiscales)",null,null,null,null,null,null,null,{"$f":"SUM(K75:K84)","v":0},0,0,null,{"$f":"SUM(O75:O84)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,{"$f":"K87","v":0}]
[]
[null,"3.4.4","Matériels et équipements",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C86","v":"<Biens d’équipement, le cas échéant quantité / unité>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!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":"<Biens d’équipement, le cas échéant quantité / unité>"}]
[null,null,{"$f":"'Bordereau de prix'!C87","v":"<Biens de consommation, le cas échéant quantité / unité>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!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":"<Biens de consommation, le cas échéant quantité / 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,0,0,{"$f":"SUM(AA89:AA92)","v":0},0,0,0,null,{"$f":"SUM(AF89:AF92)","v":0},{"$f":"SUM(AG89:AG92)","v":0}]
[]
[null,"3.4.6","Autres frais",null,null,null,null,null,null,null,null,null,null,null,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":"'Bordereau de prix'!C92","v":"<Coûts d’exploitation conformément au Guide relatif aux coûts éligibles à remboursement>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!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":"<Coûts d’exploitation conformément au Guide relatif aux coûts éligibles à remboursement>"}]
[null,null,{"$f":"'Bordereau de prix'!C93","v":"<Amortissement de biens d’équipement conformément au Guide relatif aux coûts éligibles à remboursement>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!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":"<Amortissement de biens d’équipement conformément au Guide relatif aux coûts éligibles à remboursement>"}]
[null,null,{"$f":"'Bordereau de prix'!C94","v":"<Coûts de l’atelier>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!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":"<Coûts de l’atelier>"}]
[null,null,{"$f":"'Bordereau de prix'!C95","v":"Audit/rapport d’examen"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!K95","v":0},{"$f":"K99*AnteilFremd/100","v":0},{"$f":"K99-L99","v":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,{"$f":"C99","v":"Audit/rapport d’examen"}]
[null,null,{"$f":"'Bordereau de prix'!C96","v":"<Désignation, le cas échéant quantité/unité>"},null,null,null,null,null,null,null,{"$f":"'Bordereau de prix'!K96","v":0},{"$f":"K100*AnteilFremd/100","v":0},{"$f":"K100-L100","v":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,{"$f":"C100","v":"<Désignation, le cas échéant quantité/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},{"$f":"SUM(P95:P101)","v":0},{"$f":"SUM(Q95:Q101)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AA95:AA101)","v":0},0,0,0,null,{"$f":"SUM(AF95:AF101)","v":0},{"$f":"SUM(AG95:AG101)","v":0}]
[]
[null,"Coûts du contrat (sans TVA au taux légal)",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,"Part des coûts du contrat (en pour cent)",null,null,null,null,null,null,null,null,100,{"$f":"AnteilFremd","v":100},{"$f":"K105-L105","v":0}]
[]
[null,null,"Autres contributions de la GIZ à l’action",null,null,null,null,null,null,null,{"$f":"M107","v":0},null,{"$f":"'Bordereau de prix'!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,"Coûts totaux",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,{"$f":"U104+U107","v":0},0,0,0,0,0,0,{"$f":"AB104+AB107","v":0},0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coûts cumulés pour l’ensemble de la période sous revue (sans autres contributions de la GIZ)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de :",{"$f":"P23","v":"00:00:00"},"à :",{"$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,"Part de la GIZ "]
[]
[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":"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":"Remarques","index":3,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Remarques générales sur l’utilisation de ce modèle"]
[null,null,"v.2"]
[]
[null,null,"Remarques importantes sur les macros contenus dans ce fichier :"]
[null,null,"Pour pouvoir insérer et supprimer des lignes ou des blocs ou encore pour clore le bordereau de prix et établir un avenant au contrat, il faut conserver les macros de ce document et les activer après avoir ouvert le fichier."]
[null,null,"1. Lors de l’enregistrement manuel du fichier, toujours sélectionner le type de fichier « Classeur Excel prenant en charge les macros (*.xlsm) ». "]
[null,null,"2. Après avoir ouvert le fichier, sélectionner « Activer le contenu » dans la zone « Avertissement de sécurité » (barre jaune en haut de l’écran)."]
[]
[null,null,"Il faut tenir compte des points suivants concernant les fonctions du bordereau de prix :"]
[null,null,"- Les nouvelles lignes sont insérées sous la ligne sélectionnée."]
[null,null,"- Un nouveau bloc est toujours inséré derrière (devant les expert·e·s externes)."]
[null,null,"- C’est toujours l’élément sélectionné (ligne ou bloc) qui est supprimé."]
[null,null,"- Il faut conserver une ligne pour chaque type de ligne de saisie."]
[]
[null,null,"Un clic sur « Préparer impression » ajuste automatiquement les sauts de page et copie dans la ligne de bas de page le numéro de contrat saisi."]
[]
[null,null,"Remarque sur un bug d’EXCEL susceptible de se produire dans ce fichier"]
[null,null,"Il peut arriver que certaines cellules ne soient pas calculées automatiquement bien que la formule soit correcte. Si les macros du fichier sont activées, toutes les cellules sont forcément recalculées après l’ouverture du fichier et avant l’impression. On peut aussi cliquer sur le bouton prévu à cet effet dans les feuilles de calcul."]
[]
[null,null,"Remarques sur le bordereau de prix :"]
[null,"1.","Ne sont remboursables que les coûts de revient ou coûts réels directs correspondant au pourcentage fixé contractuellement."]
[null,"2.","- Tous les postes énumérés dans le bordereau des prix représentent des valeurs maximales (quantités et coûts par unité, c.-à-d. « jusqu’à »)"]
[null,null,"=> PRIÈRE de respecter le Guide relatif aux coûts éligibles à remboursement dans le cadre de PD(i)SP !"]
[]
[null,null,"Remarques sur les justificatifs de coûts :"]
[null,"1.","En ce qui concerne la contribution au PDSP, toutes les valeurs indiquées sont considérées comme des valeurs maximales (c.-à-d. « jusqu’à »)."]
[null,"2.","Les différences constatées sur certains postes budgétaires peuvent être compensées les unes avec les autres jusqu’à 10 % du poste concerné. Toute dérogation à cette règle doit faire l’objet d’une concertation préalable avec la GIZ."]