{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Coût de l'eau potable","Amortissement infrastructures","Amortissement charroi et immob."],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Coût de l'eau potable","index":0,"n_rows":194,"n_cols":16,"rows_kept":194,"cut":false,"hidden":false,"merged":[[0,0,8,0],[16,3,16,4],[17,3,17,4],[4,10,5,10],[4,7,5,9],[6,8,7,9],[0,1,8,1],[2,8,2,10],[11,6,11,7],[11,8,11,9],[13,6,13,7],[2,3,2,6],[3,3,3,6],[6,3,6,6],[10,2,10,10],[6,10,7,10],[12,6,12,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[24,3,24,4],[49,5,49,7],[51,5,51,7],[58,5,58,7],[50,4,51,4],[41,5,41,7],[39,5,39,7],[72,8,72,10],[71,8,71,10],[53,5,53,7],[54,5,54,7],[48,5,48,7],[47,5,47,7],[44,5,44,7],[45,5,45,7],[70,8,70,10],[56,5,56,7],[64,2,64,9],[69,8,69,10],[27,3,27,4],[25,3,25,4],[120,6,120,7],[149,2,149,4],[116,6,116,7],[127,6,127,7],[174,3,176,3],[166,4,167,4],[121,6,121,7],[166,6,167,6],[133,2,133,9],[122,6,122,7],[166,3,167,3],[174,4,176,4],[150,2,150,6],[154,2,154,10],[123,6,123,7],[126,6,126,7],[128,6,128,7],[103,3,103,4],[105,3,105,4],[117,6,117,7],[114,6,114,7],[110,6,110,7],[89,3,89,4],[94,2,94,4],[96,8,96,10],[94,8,94,10],[95,2,95,4],[97,8,97,10],[95,8,95,10],[99,8,99,10],[100,8,100,10],[108,2,108,9],[113,6,113,7],[77,8,77,10],[76,8,76,10],[62,2,62,9],[81,8,81,10],[101,2,101,4],[83,8,83,10],[98,2,98,4],[98,8,98,10],[84,2,84,4],[85,2,85,4],[79,8,79,10],[84,8,84,10],[78,8,78,10],[86,8,86,10],[82,8,82,10],[86,2,86,4],[88,8,88,10],[87,8,87,10],[75,8,75,10],[73,8,73,10],[74,8,74,10],[85,8,85,10],[80,8,80,10],[18,6,18,7],[19,6,19,7],[6,13,7,13],[6,12,7,12],[68,8,68,10],[67,8,67,10],[38,5,38,7],[26,3,26,4],[43,5,43,7],[35,2,35,9],[42,5,42,7],[65,2,65,9],[59,5,59,7],[50,5,50,7],[57,5,57,7],[37,5,37,7],[22,3,22,4],[19,3,19,4],[18,3,18,4],[52,5,52,7],[40,5,40,7],[46,5,46,7],[55,5,55,7],[21,3,21,4]]}
["Version révisée le 25 / 07 / 2022",null,null,null,null,null,null,null,null,null,null,null,"Cell link Année de calcul",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cell link Nom de la commune",1]
[null,null,null,"Ministère du Développement durable et des Infrastructures",null,null,null,null,"Choisir l'année de calcul :",null,null,null,"PPRI",{"$f":"LOOKUP(N2,N13:N116,O13:O116)","v":0}]
[null,null,null,"Association Luxembourgeoise des Services d'Eau",null,null,null,null,null,null,null,null,"Zone urbaine",{"$f":"IF(OR(N2=1,N2=108),0,LOOKUP(N2,N13:N116,P13:P116))","v":0}]
[null,null,null,null,null,null,null,"Année de référence (comptes) :",null,null,2021,null,"Zone rurale",{"$f":"IF(OR(N2=1,N2=108),0,IF(N4=0,1,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Limite des coûts indexée",{"$f":"5/108*N7*IF($N$1=1,1*(1+D13)^(K7-K5),1)","v":5.0435185185185185}]
[null,null,null,"Tableur relatif au calcul du coût de l'eau potable",null,null,null,null,"Données prévisionnelles :",null,{"$f":"K5+2","v":2023},null,{"$f":"CONCATENATE(\"Indice ICPN base 100 2015 (moyenne de l'année \",K5,\")\")","v":"Indice ICPN base 100 2015 (moyenne de l'année 2021)"},108.94]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eau non facturée (%)",{"$f":"1-(D28)/(D22+D23)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consommation (l/habitant/jour)",{"$f":"D26/D19/365.25*1000","v":{"$error":"#DIV/0!"}}]
[null,null,"REMARQUE PRELIMINAIRE :\n \nAfin que les communes établissent en connaissance de cause la tarification de l’eau applicable à partir du 1er janvier de l'année X+1 en conformité avec la loi relative à l’eau, les communes procèdent au calcul du coût effectif de l’eau pour l'année qui précède X-1, le budget communal le plus récent décompté. A partir de l’année de référence X-1, le présent tableur fait une projection à l’année X+1 en tenant compte de l’évolution estimée en deux ans de l’indice des prix à la consommation et de l'indice des prix de la construction.\n\nAussi est-il préconisé de se fixer une période de trois ans pour rechercher les équilibres budgétaires. En d’autres termes, les charges et les recettes sont observées sur une période de 3 ans avant que les prix soient réajustés tout en tenant compte de l'évolution prévisible du bilan financier.",null,null,null,null,null,null,null,null,null,"Longueur réseau (m/habitant)",{"$f":"('Amortissement infrastructures'!F164+'Amortissement infrastructures'!F150+'Amortissement infrastructures'!F138+'Amortissement infrastructures'!F114+'Amortissement infrastructures'!F101+'Amortissement infrastructures'!F84+'Amortissement infrastructures'!F67+'Amortissement infrastructures'!F54)/D19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Légende :","coûts partiellement non imputables",null,"coûts non imputables"]
[null,null," Variation annuelle estimée de l'indice IPCN sur deux ans (prévision STATEC) :",2.5000000000000001E-2,null,null,null,null,null,null,null,null,"Nom de la commune",1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AERENZDALL",2,12969,0]
[null,"0.",{"$f":"CONCATENATE(\"Données à caractère général (année de référence \",$K$5,\")\")","v":"Données à caractère général (année de référence 2021)"},null,null,null,null,null,null,null,null,null,"BEAUFORT",3,5153,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"BECH",4,13156,0]
[null,null,"Commune : ",null,null,null,null,null,null,null,null,null,"BECKERICH",5,9566,0]
[null,null,"Superficie (ha) :",0,10,null,null,null,null,null,null,null,"BERDORF",6,10868,0]
[null,null,{"$f":"CONCATENATE(\"Population résidente (au 31 décembre \",$K$5,\") :\")","v":"Population résidente (au 31 décembre 2021) :"},0,null,null,null,null,null,null,null,null,"BERTRANGE",7,2189,0]
[null,null,"PPRI (m)",{"$f":"N3","v":0},null,null,null,null,null,null,null,null,"BETTEMBOURG",8,5467,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"BETTENDORF",9,6721,0]
[null,null,"Production autonome annuelle alimentant l'infrastructure d'approvisionnement locale (m3/an) : ",{"$f":"E42-SUM(E56:E57)","v":0},null,null,null,null,null,null,null,null,"BETZDORF",10,6426,0]
[null,null,"Achat annuelle d'eau potable suivant facture (m3/an) :",{"$f":"E50","v":0},null,null,null,null,null,null,null,null,"BISSEN",11,1638,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"BIWER",12,9197,0]
[null,null,"Consommation des entités privées et publiques internes et externes approvisionnées par l'infrastructure de distribution communale, tout secteur confondu NOTA BENE : ","Consommations internes et externes\n(m3/an)",null,null,null,null,null,null,null,null,"BOULAIDE",13,4223,0]
[null,null,"- quantité d'eau potable facturée aux consommateurs internes :",null,null,null,null,null,null,null,null,null,"BOURSCHEID",14,18712,0]
[null,null,"- quantité d'eau potable facturée aux consommateurs externes :",{"$f":"E53+E54","v":0},null,null,null,null,null,null,null,null,"BOUS",15,2264,0]
[null,null,"Somme de la vente privée et publique interne et externe (m3/an) :",{"$f":"D26+D27","v":0},null,null,null,null,null,null,null,null,"CLERVAUX",16,32029,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"COLMAR-BERG",17,3388,0]
[null,null,"Compteurs des consommateurs privés et publics internes et externes raccordés au réseau de distribution communal, tout secteur confondu NOTA BENE :",20,25,32,40,50,80,100,150,null,"CONSDORF",18,12575,0]
[null,null,"- nombre de compteurs :",null,null,null,null,null,null,null,null,null,"CONTERN",19,4404,0]
[null,null,"Diamètres totaux (mm) :",{"$f":"D31*D30","v":0},0,0,0,0,0,0,0,null,"DALHEIM",20,5047,0]
[null,null,"Somme des diamètres (mm) :",{"$f":"D32+E32+F32+G32+H32+I32+J32+K32","v":0},null,null,null,null,null,null,null,null,"DIEKIRCH",21,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"DIFFERDANGE",22,7717,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"DIPPACH",23,4175,0]
[null,"1.",{"$f":"CONCATENATE(\"Approvisionnement de la commune en eau potable et fourniture à d'autres entités (année de référence \",K5,\")\")","v":"Approvisionnement de la commune en eau potable et fourniture à d'autres entités (année de référence 2021)"},null,null,null,null,null,null,null,null,null,"DUDELANGE",24,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"ECHTERNACH",25,2744,0]
[null,null,null,"Capac. réservées\n(m3/jour) AIDE","Q prélev. / fournies\n(m3/an) AIDE","Remarques",null,null,null,null,null,null,"ELL",26,6801,0]
[null,"1.1.","Production autonome NOTA BENE :",null,null,null,null,null,null,null,null,null,"ERPELDANGE",27,4513,0]
[null,null,"- prélèvement sur sources :",null,null,null,null,null,null,null,null,null,"ESCH-SUR-ALZETTE",28,0,1]
[null,null,"- prélèvement sur forages :",null,null,null,null,null,null,null,null,null,"ESCH-SUR-SÛRE",29,23291,0]
[null,null,"Total de la production autonome annuelle d'eau potable prélevée par la commune : ",null,{"$f":"SUM(E40:E41)","v":0},"Reporté au chapitre 0.",null,{"$f":"D22","v":0},null,null,null,null,"ETTELBRUCK",30,3856,0]
[null,"1.2.","Approvisionnement externe :",null,null,null,null,null,null,null,null,null,"FEULEN",31,1613,0]
[null,null,"- syndicats :",null,null,null,null,null,null,null,null,null,"FISCHBACH",32,8168,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"FLAXWEILER",33,10735,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"FRISANGE",34,5171,0]
[null,null,"- communes :",null,null,null,null,null,null,null,null,null,"GARNICH",35,6204,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"GOESDORF",36,12555,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"GREVENMACHER",37,0,0]
[null,null,"Total de l'approvisionnement externe :",{"$f":"SUM(D45:D49)","v":0},{"$f":"SUM(E45:E49)","v":0},"Reporté au chapitre 0.",null,{"$f":"D31","v":0},null,null,null,null,"GROSBOUS",38,6785,0]
[null,"1.3.","Fourniture à des entités établies hors du territoire de la commune :",null,"Consommations externes",null,null,null,null,null,null,null,"HABSCHT",39,11699,0]
[null,null,"- preneurs d'eau externes alimentés par l'infrastructure d'approvisionnement local NOTA BENE :",null,null,null,null,null,null,null,null,null,"HELPERKNAPP",40,16764,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"HEFFINGEN",41,4111,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"HESPERANGE",42,7211,0]
[null,null,"- preneurs d'eau externes directement approvisionnés à la ressource NOTA BENE :",null,null,null,null,null,null,null,null,null,"JUNGLINSTER",43,21028,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"KÄERJENG",44,7582,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"KAYL",45,1490,0]
[null,null,"Total de la fourniture à des entités externes NOTA BENE :",{"$f":"SUM(D53:D57)","v":0},{"$f":"SUM(E53:E57)","v":0},null,null,null,null,null,null,null,"KEHLEN",46,9103,0]
[null,null,"Capacité disponible pour l'approvisionnement interne de la commune (m3/jour) AIDE :",{"$f":"E42/365+D50-SUM(D53:D54)","v":0},null,null,null,null,null,null,null,null,"KIISCHPELT",47,8788,0]
[null,null,"Quantité d'eau alimentant le réseau de distribution de la commune (m3/an) AIDE :",null,{"$f":"E42+E50-E58","v":0},null,null,null,null,null,null,null,"KOERICH",48,4200,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"KOPSTAL",49,868,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"LAC DE LA HAUTE SURE",50,14062,0]
[null,"2.",{"$f":"CONCATENATE(\"Coût complet des services liés à l'approvisionnement en eau potable \",IF(N1=2,CONCATENATE(\"(année de référence \",K5,\")\"),CONCATENATE(\"(données prévisionnelles \",K7,\")\")))","v":"Coût complet des services liés à l'approvisionnement en eau potable (année de référence 2021)"},null,null,null,null,null,null,null,null,null,"LAROCHETTE",51,3687,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"LENNINGEN",52,3192,0]
[null,"2.1.","Charges de fonctionnement, d'entretien et d'exploitation des infrastructures d'approvisionnement en eau potable",null,null,null,null,null,null,null,null,null,"LEUDELANGE",53,1614,0]
[null,null,"Coûts de fonctionnement (charges d’exploitation et d’entretien inscrites au budget ordinaire) + charges d’amortissement établies sur base du coût de renouvellement des investissements (charges de renouvellement théoriques)",null,null,null,null,null,null,null,null,null,"LINTGEN",54,1975,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"LORENTZWEILER",55,5350,0]
[null,null,"Dépenses pour :\nREMARQUE : Indication non exhaustive des codes du Plan budgétaire normalisé. Merci de signaler toute erreur de code.","Total article budgétaire (€)","Taux d'utilisation\neau potable","Coûts fixes\n(€/an)","Coûts variables\n(€/an)","Coûts totaux\n(€/an)","Remarques",null,null,null,"LUXEMBOURG",56,0,1]
[null,null,"- frais de personnel administratif et technique (art. 3/630/621xxx et autres) AIDE :",null,1,{"$f":"D69*E69*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,{"$f":"SUM(F69:G69)","v":0},null,null,null,null,"MAMER",57,6429,0]
[null,null,"- fournitures pour l'entretien et le nettoyage des bâtiments (art. 3/630/630200) :",null,1,{"$f":"D70*E70*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,{"$f":"SUM(F70:G70)","v":0},null,null,null,null,"MANTERNACH",58,6635,0]
[null,null,"- frais d'entretien et de nettoyage des bâtiments :",null,1,{"$f":"D71*E71*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"MERSCH",59,10882,0]
[null,null,"- fournitures pour l'entretien des réseaux (art. 3/630/6200) :",null,1,null,{"$f":"D72*E72*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"MERTERT",60,1921,0]
[null,null,"- frais de consommation électrique des infrastructures et des réseaux (art. 3/630/608112) :",null,1,null,{"$f":"D73*E73*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"MERTZIG",61,0,0]
[null,null,"- facturation interne des consommations eau-électricité-gaz (art. 3/630/608111/X & 112/X & 113/X) :",null,1,null,{"$f":"D74*E74*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"MONDERCANGE",62,4935,0]
[null,null,"- frais d'entretien des infrastructures et des réseaux (art. 3/630/603200) NOTA BENE :",null,1,{"$f":"D75*E75*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"MONDORF-LES-BAINS",63,3722,0]
[null,null,"- charges informatiques (art. 3/630/608112) AIDE :",null,1,null,{"$f":"D76*E76*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"NIEDERANVEN",64,10772,0]
[null,null,"- charges de matériel (art. 3/630/603xxx) :",null,1,null,{"$f":"D77*E77*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"NOMMERN",65,5382,0]
[null,null,"- charges de services extérieurs (art. 3/630/618xxx) AIDE :",null,1,null,{"$f":"D78*E78*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"PARC HOSINGEN",66,25874,0]
[null,null,"- charges d'assurances (art. 3/630/614xxx) :",null,1,{"$f":"D79*E79*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"PETANGE",67,2637,1]
[null,null,"- charges de contrats d'entretien (art. 3/630/612300) :",null,1,{"$f":"D80*E80*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"PREIZERDAUL",68,2476,0]
[null,null,"- charges de contrôle qualité :",null,1,null,{"$f":"D81*E81*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"PUTSCHEID",69,10196,0]
[null,null,"- charges de comptage et encaissement :",null,1,{"$f":"D82*E82*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"RAMBROUCH",70,25034,0]
[null,null,"- charges générales et diverses :",null,1,null,{"$f":"D83*E83*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},0,null,null,null,null,"RECKANGE-SUR-MESS",71,7760,0]
[null,null,"- charges administratives AIDE :",null,1,{"$f":"D84*E84*IF($N$1=1,(1+D13)^(K7-K5),1)","v":0},null,0,null,null,null,null,"REDANGE/ATTERT",72,10563,0]
[null,null,"- taxe de prélèvement de la production autonome AIDE :",null,null,null,{"$f":"D22*0.125","v":0},0,null,null,null,null,"REISDORF",73,5344,0]
[null,null,"- charges totales de l'amortissement des infrastructures « Sollwert » AIDE :",null,null,{"$f":"'Amortissement infrastructures'!N266","v":0},null,0,null,null,null,null,"REMICH",74,0,0]
[null,null,"- charges non opposables de l'amortissement en fonction du PPRI de la commune AIDE :",null,null,{"$f":"-1.3*D20*'Amortissement infrastructures'!H47*'Amortissement infrastructures'!L47/100*((1+0)+(0.12*(1+0)))*IF($N$1=1,(1+'Amortissement infrastructures'!O10)^(K7-K5),1)","v":0},null,0,null,null,null,null,"ROESER",75,8234,0]
[null,null,"- amortissement parc immobilier :",null,null,{"$f":"'Amortissement charroi et immob.'!O72","v":0},null,0,null,null,null,null,"ROSPORT-MOMPACH",76,23507,0]
[null,null,"- amortissement parc automobile :",null,null,{"$f":"'Amortissement charroi et immob.'!O47","v":0},null,0,null,null,null,null,"RUMELANGE",77,0,1]
[null,null,"Charges imputables de fonctionnement, d'entretien et d'exploitation ……………………………",{"$f":"CONCATENATE(IF(N1=2,CONCATENATE(\"(année de référence \",K5,\") :\"),CONCATENATE(\"(données prévisionnelles \",K7,\") :\")))","v":"(année de référence 2021) :"},null,{"$f":"SUM(F69:F89)","v":0},{"$f":"SUM(G69:G89)","v":0},{"$f":"SUM(H69:H89)","v":0},null,null,null,null,"SAEUL",78,6060,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"SANDWEILER",79,2034,0]
[null,"2.2.","Frais pour achat d'eau potable",null,null,null,null,null,null,null,null,null,"SANEM",80,6126,0]
[null,null,"Budget ou compte ordinaire",null,null,null,null,null,null,null,null,null,"SCHENGEN",81,13631,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"SCHIEREN",82,2133,0]
[null,null,"Achats à partir de NOTA BENE :",null,null,"Coûts fixes\n(€/an TTC)","Coûts variables\n(€/an TTC)","Coûts totaux\n(€/an TTC)","Remarques",null,null,null,"SCHIFFLANGE",83,0,1]
[null,null,"- syndicats (art. 3/630/608111/S) :",null,null,null,null,null,null,null,null,null,"SCHUTTRANGE",84,6225,0]
[null,null,{"$f":"IF(C45=\"\",\"\",C45)","v":""},null,null,null,null,{"$f":"(F97+G97)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,"STADTBREDIMUS",85,3311,0]
[null,null,{"$f":"IF(C46=\"\",\"\",C46)","v":""},null,null,null,null,{"$f":"(F98+G98)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,"STEINFORT",86,4578,0]
[null,null,"- communes (art. 3/630/608111/C) :",null,null,null,null,null,null,null,null,null,"STEINSEL",87,1534,0]
[null,null,{"$f":"IF(C48=\"\",\"\",C48)","v":""},null,null,null,null,{"$f":"(F100+G100)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,"STRASSEN",88,0,0]
[null,null,{"$f":"IF(C49=\"\",\"\",C49)","v":""},null,null,null,null,{"$f":"(F101+G101)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,"TANDEL",89,16801,0]
[null,null,{"$f":"CONCATENATE(\"Total des frais pour achat d'eau potable \",IF(N1=2,CONCATENATE(\"(année de référence \",K5,\") :\"),CONCATENATE(\"(données prévisionnelles \",K7,\") :\")))","v":"Total des frais pour achat d'eau potable (année de référence 2021) :"},null,null,{"$f":"SUM(F97:F101)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(G97:G101)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(H97:H101)","v":0},null,null,null,null,"TROISVIERGES",90,10196,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"USELDANGE",91,7968,0]
[null,null,"Coûts imputables des services liés à l'infrastructure d'approvisionnement locale en €/an ……",{"$f":"CONCATENATE(IF(N1=2,CONCATENATE(\"(année de référence \",K5,\") :\"),CONCATENATE(\"(données prévisionnelles \",K7,\") :\")))","v":"(année de référence 2021) :"},null,{"$f":"F90+F102","v":0},{"$f":"G90+G102","v":0},{"$f":"H90+H102","v":0},null,null,null,null,"VALLEE DE L'ERNZ",92,12969,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"VIANDEN",93,0,0]
[null,null,"Coût complet des services liés à l'infrastructure d'approvisionnement locale en €/an …………",{"$f":"CONCATENATE(IF(N1=2,CONCATENATE(\"(année de référence \",K5,\") :\"),CONCATENATE(\"(données prévisionnelles \",K7,\") :\")))","v":"(année de référence 2021) :"},null,null,null,{"$f":"H104-F87","v":0},null,null,null,null,"VICHTEN",94,2534,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAHL",95,8403,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"WALDBILLIG",96,11226,0]
[null,"3.",{"$f":"CONCATENATE(\"Recettes relatives à la fourniture de l'eau potable par la commune \",IF(N1=2,CONCATENATE(\"(année de référence \",K5,\")\"),CONCATENATE(\"(données prévisionnelles \",K7,\")\")))","v":"Recettes relatives à la fourniture de l'eau potable par la commune (année de référence 2021)"},null,null,null,null,null,null,null,null,null,"WALDBREDIMUS",97,2662,0]
[null,null,"Budget ou compte ordinaire",null,null,null,null,null,null,null,null,null,"WALFERDANGE",98,1462,0]
[null,null,null,"Recettes fixes\n(€/an)","Recettes variables\n(€/an)","Recettes totales\n(€/an)","Remarques",null,null,null,null,null,"WEILER-LA-TOUR",99,2793,0]
[null,"3.1.","Fourniture à des entités publiques établies hors du territoire de la commune :",null,null,null,null,null,null,null,null,null,"WEISWAMPACH",100,16314,0]
[null,null,"- entités externes alimentées par l'infrastructure d'approvisionnement local NOTA BENE :",null,null,null,null,null,null,null,null,null,"WILTZ",101,9400,0]
[null,null,{"$f":"IF(C53=\"\",\"\",C53)","v":""},null,null,{"$f":"(D114+E114)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,null,null,"WINCRANGE",102,37726,0]
[null,null,{"$f":"IF(C54=\"\",\"\",C54)","v":""},null,null,{"$f":"(D115+E115)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},null,null,null,null,null,null,"WINSELER",103,12071,0]
[null,null,"- entités qui ne sont pas approvisionnées par l'infrastructure d'approvisionnement local NOTA BENE :",null,null,null,null,null,null,null,null,null,"WORMELDANGE",104,11968,0]
[null,null,null,null,null,{"$f":"(D117+E117)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,null,null,null,{"$f":"(D118+E118)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"Total des recettes pour fourniture d'eau potable à l'autres entités (€/an) :",{"$f":"SUM(D114:D118)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(E114:E118)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(F114:F118)","v":0}]
[null,"3.2.","Fourniture d'eau potable aux consommateurs finaux internes AIDE :"]
[null,null,"- secteur des ménages AIDE :",null,null,{"$f":"(D121+E121)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"- secteur industriel :",null,null,{"$f":"(D122+E122)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"- secteur agricole :",null,null,{"$f":"(D123+E123)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"- secteur HORECA :",null,null,{"$f":"(D124+E124)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"Total des recettes pour fourniture d'eau potable aux consommateurs internes (€/an) :",{"$f":"SUM(D121:D124)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(E121:E124)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(F121:F124)","v":0}]
[null,"3.3.","Autres recettes :"]
[null,null,null,null,null,{"$f":"(D127+E127)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,null,null,null,{"$f":"(D128+E128)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,null,null,null,{"$f":"(D129+E129)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0}]
[null,null,"Total autres recettes (€/an) :",{"$f":"SUM(D127:D129)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(E127:E129)*IF($N$1=1,(1+$D$13)^(K7-K5),1)","v":0},{"$f":"SUM(F127:F129)","v":0}]
[null,null,{"$f":"CONCATENATE(\"Total des recettes pour fourniture d'eau potable en €/an \",IF(N1=2,CONCATENATE(\"(année de référence \",K5,\") :\"),CONCATENATE(\"(données prévisionnelles \",K7,\") :\")))","v":"Total des recettes pour fourniture d'eau potable en €/an (année de référence 2021) :"},{"$f":"D119+D125+D130","v":0},{"$f":"E119+E125+E130","v":0},{"$f":"F119+F125+F130","v":0}]
[]
[]
[null,"4.",{"$f":"CONCATENATE(\"Résultat comptable pour la distribution d'eau potable par l'inrastructure d'approvisionnement communale \",IF(N1=2,CONCATENATE(\"(année de référence \",K5,\")\"),CONCATENATE(\"(données prévisionnelles \",K7,\")\")))","v":"Résultat comptable pour la distribution d'eau potable par l'inrastructure d'approvisionnement communale (année de référence 2021)"}]
[]
[null,"4.1.","Calcul du coût imputable de l'eau potable "]
[null,null,null,"Coûts fixes","Coûts variables","Coûts totaux"]
[null,null,"Coûts imputables des services liés à l'approvisionnement en eau potable NOTA BENE :",{"$f":"F104-D130-(D114+D115)","v":0},{"$f":"G104-E130-(E114+E115)","v":0},{"$f":"H104-F130-(F114+F115)","v":0}]
[null,null,"Somme des diamètres des compteurs :",{"$f":"D33","v":0}]
[null,null,"Coût fixe par unité de diamètre du compteur (€/mm/an) :",{"$f":"D138/D139","v":{"$error":"#DIV/0!"}}]
[null,null,"Quantité d'eau potable distribuée par l'infrastructure d'approvisionnement communale (m3/an) :",null,{"$f":"D28","v":0},{"$f":"D28","v":0}]
[null,null,"Coût variable par m3 d'eau potable (€/m3) :",null,{"$f":"E138/E141","v":{"$error":"#DIV/0!"}}]
[null,null,"Coût global par m3 d'eau potable (€/m3) AIDE :",null,null,{"$f":"F138/F141","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Recalcul du coût unitaire par diamètre du compteur :"]
[null,null,"Diamètre du compteur :",20,25,32,40,50,80,100,150]
[null,null,"Coût fixe par compteur (€/an) AIDE :",{"$f":"$D$140*D146","v":{"$error":"#DIV/0!"}},{"$f":"$D$140*E146","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"5.",{"$f":"CONCATENATE(\"Tarification relative à la distribution interne pour l'année \",K7)","v":"Tarification relative à la distribution interne pour l'année 2023"}]
[null,null,{"$f":"CONCATENATE(\"CHOISIR L'OPTION « DONNEES PREVISIONNELLES \",K7,\" » DANS LE BANDEAU DE TITRE\")","v":"CHOISIR L'OPTION « DONNEES PREVISIONNELLES 2023 » DANS LE BANDEAU DE TITRE"}]
[]
[null,"5.1.","Approche « coûts rééquilibrés suivant circulaire ministérielle n°2909 »"]
[]
[null,null,"REMARQUE :\nLes prix proposés ci-après tiennent compte des consignes de rééquilibrage du coût de revient de l'eau telles que communiquées par la circulaire ministérielle n°2909 du 28 mars 2011. Ce rééquilibrage élimine l'effet pénalisant des conditions géographiques locales (ajustement de l'amortissement des infrastructures d'approvisionnement sur base du PPRI) et instaure le plafonnement du coût global par m3 opposable aux consommateurs afin de limiter les conséquences économiques des coûts sur les tarifs. Ce plafond est indexé sur l'échelle mobile des salaires.\nD'autre part, la tarification rééquilibrée préconise un partage fixe / variable standardisé pour les différents secteurs afin de tenir compte des coûts spécifiques que génèrent les activités de ces secteurs.\n\n"]
[]
[null,null,"Coût imputable rééquilibré :","100% =",null,"Variable : Fixe"]
[null,null,"- coût global indexé par m3 d'eau potable :",{"$f":"IF(F143>N6,N6,F143)","v":{"$error":"#DIV/0!"}},null,{"$f":"E138/F138","v":{"$error":"#DIV/0!"}}]
[null,null,"- coût global indexé par mm de diamètre des compteurs :",{"$f":"IF(F143>N6,(N6*F141)/D139,F138/D139)","v":{"$error":"#DIV/0!"}},null,{"$f":"D138/F138","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Partage fixe/variable non corrigé :","Fixe corresp.","Var. arrondie","Var. ≥ x €","Var. standard.","% variable"]
[null,null,"- secteur des ménages :",{"$f":"(1-E162/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))/IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<0.5,0.01,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<1.2,0.02,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<2.5,0.05,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<5,0.1,0.2)))),0)*IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<0.5,0.01,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<1.2,0.02,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<2.5,0.05,IF(F162/1/10^(ROUNDDOWN((LOG(F162/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F162/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G162<$G$169,IF($G$169>$D$158,$D$158,$G$169),G162)","v":{"$error":"#DIV/0!"}},{"$f":"$D$158*H162/100","v":{"$error":"#DIV/0!"}},75]
[null,null,"- secteur industriel :",{"$f":"(1-E163/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))/IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<0.5,0.01,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<1.2,0.02,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<2.5,0.05,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<5,0.1,0.2)))),0)*IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<0.5,0.01,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<1.2,0.02,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<2.5,0.05,IF(F163/1/10^(ROUNDDOWN((LOG(F163/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F163/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G163<$G$169,IF($G$169>$D$158,$D$158,$G$169),G163)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},35]
[null,null,"- secteur agricole :",{"$f":"(1-E164/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(G164<$G$169,IF($G$169>$D$158,$D$158,$G$169),G164)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},40]
[null,null,"- secteur HORECA :",{"$f":"(1-E165/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},55]
[]
[null,null,"Tarification rééquilibrée NOTA BENE :","Part fixe\n(€/mm/an hTVA)","Part variable\n(€/m3 hTVA)",null,"Prix plancher\n(€/m3) AIDE"]
[]
[null,null,"- secteur des ménages :",{"$f":"ROUND(ROUND(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))/IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<0.5,0.01,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<1.2,0.02,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<2.5,0.05,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<5,0.1,0.2)))),0)*IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<0.5,0.01,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<1.2,0.02,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<2.5,0.05,IF(D162/1/10^(ROUNDDOWN((LOG(D162/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D162/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"E162","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur industriel :",{"$f":"ROUND(ROUND(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))/IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<0.5,0.01,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<1.2,0.02,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<2.5,0.05,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<5,0.1,0.2)))),0)*IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<0.5,0.01,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<1.2,0.02,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<2.5,0.05,IF(D163/1/10^(ROUNDDOWN((LOG(D163/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D163/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"E163","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur agricole :",{"$f":"ROUND(ROUND(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))/IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<0.5,0.01,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<1.2,0.02,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<2.5,0.05,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<5,0.1,0.2)))),0)*IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<0.5,0.01,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<1.2,0.02,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<2.5,0.05,IF(D164/1/10^(ROUNDDOWN((LOG(D164/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D164/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"- secteur HORECA :",{"$f":"ROUND(ROUND(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))/IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<0.5,0.01,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<1.2,0.02,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<2.5,0.05,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<5,0.1,0.2)))),0)*IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<0.5,0.01,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<1.2,0.02,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<2.5,0.05,IF(D165/1/10^(ROUNDDOWN((LOG(D165/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D165/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,"5.2.","Approche « prix variables proposés »"]
[null,null,null,"Part fixe correspondante\n(€/mm/an hTVA )","Part variable proposée\n(€/m3 hTVA )"]
[null,null,"Prix variables proposés pour les différents secteurs NOTA BENE :"]
[null,null,null,null,null,"-5ƿ%","+5ƿ%"]
[null,null,"- secteur des ménages :",{"$f":"ROUND(ROUND(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))/IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<0.5,0.01,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<1.2,0.02,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<2.5,0.05,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<5,0.1,0.2)))),0)*IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<0.5,0.01,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<1.2,0.02,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<2.5,0.05,IF(D184/1/10^(ROUNDDOWN((LOG(D184/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D184/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"E184","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur industriel :",{"$f":"ROUND(ROUND(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))/IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<0.5,0.01,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<1.2,0.02,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<2.5,0.05,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<5,0.1,0.2)))),0)*IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<0.5,0.01,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<1.2,0.02,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<2.5,0.05,IF(D185/1/10^(ROUNDDOWN((LOG(D185/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D185/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"E185","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur agricole :",{"$f":"ROUND(ROUND(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))/IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<0.5,0.01,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<1.2,0.02,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<2.5,0.05,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<5,0.1,0.2)))),0)*IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<0.5,0.01,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<1.2,0.02,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<2.5,0.05,IF(D186/1/10^(ROUNDDOWN((LOG(D186/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D186/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"- secteur HORECA :",{"$f":"ROUND(ROUND(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))/IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<0.5,0.01,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<1.2,0.02,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<2.5,0.05,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<5,0.1,0.2)))),0)*IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<0.5,0.01,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<1.2,0.02,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<2.5,0.05,IF(D187/1/10^(ROUNDDOWN((LOG(D187/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D187/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,null,"Part fixe correspondante non corrigée (€/mm/an) :","Fixe corresp.","Var. arrondie","Var. standard.","% variable"]
[null,null,"- secteur des ménages :",{"$f":"(1-E184/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))/IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<0.5,0.01,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<1.2,0.02,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<2.5,0.05,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<5,0.1,0.2)))),0)*IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<0.5,0.01,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<1.2,0.02,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<2.5,0.05,IF(F184/1/10^(ROUNDDOWN((LOG(F184/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F184/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"$D$158*G184/100","v":{"$error":"#DIV/0!"}},75]
[null,null,"- secteur industriel :",{"$f":"(1-E185/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))/IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<0.5,0.01,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<1.2,0.02,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<2.5,0.05,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<5,0.1,0.2)))),0)*IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<0.5,0.01,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<1.2,0.02,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<2.5,0.05,IF(F185/1/10^(ROUNDDOWN((LOG(F185/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F185/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(($D$158*G185/100)>F186,F186,$D$158*G185/100)","v":{"$error":"#DIV/0!"}},35]
[null,null,"- secteur agricole :",{"$f":"(1-E186/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"$D$158*G186/100","v":{"$error":"#DIV/0!"}},40]
[null,null,"- secteur HORECA :",{"$f":"(1-E187/$D$158)*$D$159","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"$D$158*G187/100","v":{"$error":"#DIV/0!"}},55]
[]
[null,null,"Recalcul du prix unitaire par diamètre du compteur (€/an) :"]
[null,null,"Diamètre du compteur :",20,25,32,40,50,80,100,150]
[null,null,"- secteur des ménages :",{"$f":"D$190*$D178","v":{"$error":"#DIV/0!"}},{"$f":"E$190*$D178","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"- secteur industriel :",{"$f":"D$190*$D179","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"- secteur agricole :",{"$f":"D$190*$D180","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"- secteur HORECA :",{"$f":"D$190*$D181","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Amortissement infrastructures","index":1,"n_rows":266,"n_cols":18,"rows_kept":266,"cut":false,"hidden":false,"merged":[[265,13,265,14],[264,2,264,12],[264,13,264,14],[263,13,263,14],[265,2,265,12],[234,2,234,5],[233,6,233,7],[252,8,252,9],[246,10,246,12],[236,2,236,6],[236,8,236,9],[233,2,233,5],[252,13,252,14],[252,10,252,12],[246,13,246,14],[246,6,246,7],[246,2,246,4],[259,13,259,14],[263,2,263,12],[257,13,257,14],[262,13,262,14],[261,13,261,14],[257,2,257,12],[261,2,261,12],[259,2,259,12],[262,2,262,12],[255,2,255,13],[252,2,252,7],[248,2,248,4],[251,2,251,4],[250,2,250,4],[247,2,247,4],[241,13,241,14],[238,13,238,14],[238,6,238,7],[246,8,246,9],[244,2,244,5],[241,2,241,12],[239,2,239,5],[238,10,238,12],[238,2,238,5],[238,8,238,9],[231,2,231,4],[231,8,231,9],[221,10,221,12],[229,2,229,11],[233,13,233,14],[222,2,222,4],[224,2,224,4],[227,10,227,12],[233,8,233,9],[233,10,233,12],[227,13,227,14],[223,2,223,4],[226,2,226,4],[227,6,227,7],[227,2,227,4],[225,2,225,4],[221,6,221,7],[227,8,227,9],[221,13,221,14],[212,2,212,4],[216,2,216,4],[213,2,213,4],[219,8,219,9],[221,8,221,9],[217,13,217,14],[211,13,211,14],[211,10,211,12],[199,2,199,4],[221,2,221,4],[211,6,211,7],[211,8,211,9],[217,8,217,9],[205,2,205,7],[217,6,217,7],[219,2,219,6],[211,2,211,4],[214,2,214,4],[217,2,217,4],[202,13,202,14],[217,10,217,12],[215,2,215,4],[194,13,194,14],[209,8,209,9],[200,13,200,14],[194,6,194,7],[200,10,200,12],[200,8,200,9],[202,2,202,12],[196,2,196,4],[200,6,200,7],[194,10,194,12],[195,2,195,4],[194,8,194,9],[194,2,194,4],[209,2,209,4],[198,2,198,4],[200,2,200,4],[207,2,207,9],[197,2,197,4],[186,2,186,4],[182,2,182,4],[184,2,184,4],[185,2,185,4],[183,2,183,4],[181,2,181,4],[178,2,178,4],[179,2,179,4],[180,2,180,4],[190,13,190,14],[187,2,187,4],[192,8,192,9],[192,2,192,5],[188,2,188,4],[189,2,189,4],[190,2,190,4],[190,6,190,7],[190,8,190,9],[190,10,190,12],[167,13,167,14],[163,13,163,14],[170,2,170,12],[177,8,177,9],[177,6,177,7],[165,2,165,6],[177,13,177,14],[170,13,170,14],[177,2,177,4],[175,2,175,5],[167,8,167,9],[163,10,163,12],[167,10,167,12],[177,10,177,12],[163,8,163,9],[165,8,165,9],[163,2,163,4],[163,6,163,7],[175,8,175,9],[173,2,173,4],[167,6,167,7],[167,2,167,5],[168,2,168,5],[120,13,120,14],[139,2,139,4],[149,6,149,7],[141,6,141,7],[141,2,141,4],[149,8,149,9],[137,10,137,12],[127,10,127,12],[127,8,127,9],[137,8,137,9],[149,10,149,12],[127,2,127,4],[141,13,141,14],[120,2,120,12],[153,10,153,12],[151,8,151,9],[153,13,153,14],[153,8,153,9],[149,13,149,14],[141,10,141,12],[141,8,141,9],[139,8,139,9],[125,2,125,4],[127,6,127,7],[137,6,137,7],[127,13,127,14],[137,13,137,14],[151,2,151,4],[153,6,153,7],[153,2,153,4],[118,2,118,5],[125,8,125,9],[85,13,85,14],[117,10,117,12],[117,2,117,5],[113,6,113,7],[113,10,113,12],[117,6,117,7],[104,13,104,14],[92,13,92,14],[100,13,100,14],[113,13,113,14],[117,8,117,9],[113,8,113,9],[100,10,100,12],[92,2,92,4],[100,8,100,9],[104,6,104,7],[92,8,92,9],[102,8,102,9],[104,8,104,9],[117,13,117,14],[115,8,115,9],[123,2,123,12],[32,13,32,14],[41,10,41,12],[53,10,53,12],[57,10,57,12],[32,10,32,12],[34,13,34,14],[41,13,41,14],[57,13,57,14],[53,13,53,14],[66,2,66,4],[66,13,66,14],[68,8,68,9],[66,8,66,9],[70,8,70,9],[66,10,66,12],[70,10,70,12],[57,8,57,9],[83,13,83,14],[70,13,70,14],[83,10,83,12],[5,2,5,7],[11,2,11,12],[9,2,9,12],[41,6,41,7],[53,6,53,7],[55,8,55,9],[41,8,41,9],[20,2,20,4],[26,8,26,9],[22,2,22,4],[16,2,16,4],[18,8,18,9],[18,2,18,5],[24,8,24,9],[23,2,23,4],[37,2,37,7],[30,2,30,4],[29,2,29,4],[31,2,31,4],[32,8,32,9],[39,8,39,9],[34,2,34,12],[41,2,41,4],[115,2,115,6],[55,2,55,4],[53,8,53,9],[53,2,53,4],[39,2,39,4],[92,6,92,7],[100,6,100,7],[85,2,85,12],[83,2,83,4],[70,6,70,7],[70,2,70,4],[83,8,83,9],[83,6,83,7],[68,2,68,4],[90,8,90,9],[90,2,90,4],[104,10,104,12],[92,10,92,12],[102,2,102,4],[104,2,104,4],[88,2,88,12],[66,6,66,7],[57,6,57,7],[57,2,57,4],[7,13,7,14],[9,13,9,14],[0,0,3,0],[1,1,2,7],[28,6,28,7],[1,8,2,13],[4,0,12,0],[28,10,28,12],[24,13,24,14],[28,13,28,14],[24,10,24,12],[20,13,20,14],[20,10,20,12],[20,6,20,7],[28,2,28,4],[21,2,21,4],[20,8,20,9],[28,8,28,9],[13,2,13,12],[13,13,13,14],[1,14,2,14],[11,13,11,14],[26,2,26,5],[7,2,7,12]]}
["23 / 03 / 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone urbaine",{"$f":"'Coût de l''eau potable'!N4","v":0}]
[null,"Amortissement des \ninfrastructures d'approvisionnement",null,null,null,null,null,null,{"$f":"IF('Coût de l''eau potable'!$N$1=2,'Coût de l''eau potable'!$H$5,'Coût de l''eau potable'!$I$7)","v":"Année de référence (comptes) :"},null,null,null,null,null,{"$f":"IF('Coût de l''eau potable'!N1=2,'Coût de l''eau potable'!$K$5,'Coût de l''eau potable'!$K$7)","v":2021},null,"Zone rurale",{"$f":"'Coût de l''eau potable'!N5","v":0}]
[]
[]
[]
[null,"0.","Taux à base du calcul de l'amortissement",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel des prix de la construction de l'année \",'Coût de l''eau potable'!$K$5, \" (donnée STATEC) :\")","v":"Indice moyen annuel des prix de la construction de l'année 2021 (donnée STATEC) :"},null,null,null,null,null,null,null,null,null,null,902.74]
[]
[null,null,"Variation annuelle estimée de l'indice des prix de la construction :",null,null,null,null,null,null,null,null,null,null,{"$f":"'Coût de l''eau potable'!D13","v":2.5000000000000001E-2}]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel estimé des prix de la construction de l'année \",'Coût de l''eau potable'!$K$7,\" :\")","v":"Indice moyen annuel estimé des prix de la construction de l'année 2023 :"},null,null,null,null,null,null,null,null,null,null,{"$f":"N8*(1+N10)^('Coût de l''eau potable'!K7-'Coût de l''eau potable'!K5)","v":948.44121249999989}]
[]
[null,null,"Taux de TVA appliqué aux travaux d'infrastructures d'approvisionnement :",null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"1.","Captages",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"1.1.","Sources-captages",null,null,null,null,null,"Durée de vie utile :",null,null,60,"ans"]
[]
[null,null,"Déversement journalier moyen",null,null,"Nombre de sources","Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"0 - 250 m3/j",null,null,0,"x",{"$f":"ROUND((160000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":240000},"=",{"$f":"F22*H22","v":0},"x",{"$f":"ROUND((1/L19*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"J22*L22/100","v":0}]
[null,null,"250 - 800 m3/j",null,null,0,"x",{"$f":"ROUND((220000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":330000},"=",{"$f":"F23*H23","v":0},"x",{"$f":"ROUND((1/L19*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"J23*L23/100","v":0}]
[null,null,"> 800 m3/j",null,null,0,"x",{"$f":"ROUND((280000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":420000},"=",{"$f":"F24*H24","v":0},"x",{"$f":"ROUND((1/L19*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"J24*L24/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F22:F24)","v":0},null,null,{"$f":"SUM(J22:J24)","v":0},null,null,null,null,{"$f":"SUM(O22:O24)","v":0}]
[]
[null,"1.2.","Forages-captages",null,null,null,null,null,"Durée de vie utile :",null,null,35,"ans"]
[]
[null,null,"Profondeur du forage ",null,null,"Nombre de forages","Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"0 -  50 m",null,null,0,"x",{"$f":"ROUND((160000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":240000},"=",{"$f":"F30*H30","v":0},"x",{"$f":"ROUND((1/L27*10000)/5,0)*5/100","v":2.85},"%","=",{"$f":"J30*L30/100","v":0}]
[null,null,"50 -100 m",null,null,0,"x",{"$f":"ROUND((220000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":330000},"=",{"$f":"F31*H31","v":0},"x",{"$f":"ROUND((1/L27*10000)/5,0)*5/100","v":2.85},"%","=",{"$f":"J31*L31/100","v":0}]
[null,null,"> 100 m",null,null,0,"x",{"$f":"ROUND((280000/600.88*IF('Coût de l''eau potable'!N1=2,N8,N12))/10000,0)*10000","v":420000},"=",{"$f":"F32*H32","v":0},"x",{"$f":"ROUND((1/L27*10000)/5,0)*5/100","v":2.85},"%","=",{"$f":"J32*L32/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F30:F32)","v":0},null,null,{"$f":"SUM(J30:J32)","v":0},null,null,null,null,{"$f":"SUM(O30:O32)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des captages en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N25+N33","v":0}]
[]
[]
[null,"2.","Conduites d'adduction (zone verte)",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"2.1.","Fonte ductile",null,null,null,null,null,"Durée de vie utile :",null,null,70,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",80,"mm",0,"x",{"$f":"(80+D43*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":192.30248968180004},"=",{"$f":"F43*H43","v":0},"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",{"$f":"J43*L43/100","v":0}]
[null,null,null,"100","mm",0,"x",{"$f":"(80+D44*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":210.33084808946879},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(80+D45*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":232.86629609905469},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"150","mm",0,"x",{"$f":"(80+D46*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":255.40174410864066},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(80+D47*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":300.4726401278125},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"250","mm",0,"x",{"$f":"(80+D48*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":345.54353614698442},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"300 ","mm",0,"x",{"$f":"(80+D49*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":390.61443216615629},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"350 ","mm",0,"x",{"$f":"(80+D50*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":435.68532818532816},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"400","mm",0,"x",{"$f":"(80+D51*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":480.75622420450003},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"500","mm",0,"x",{"$f":"(80+D52*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":570.89801624284382},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,"≥","600","mm",0,"x",{"$f":"(80+D53*0.6)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":661.03980828118756},"=",0,"x",{"$f":"ROUND((1/L40*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F43:F53)","v":0},null,null,{"$f":"SUM(J43:J53)","v":0},null,null,null,null,{"$f":"SUM(O43:O53)","v":0}]
[]
[null,"2.2.","PEHD",null,null,null,null,null,"Durée de vie utile :",null,null,70,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,"x",{"$f":"(35+(D59-D59*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":141.24617867128211},"=",{"$f":"F59*H59","v":0},"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",{"$f":"J59*L59/100","v":0}]
[null,null,null,"110","mm",0,"x",{"$f":"(35+(D60-D60*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":160.95718386366664},"=",0,"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(35+(D61-D61*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":175.74043775795499},"=",0,"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"140","mm",0,"x",{"$f":"(35+(D62-D62*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":190.5236916522434},"=",{"$f":"F62*H62","v":0},"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",{"$f":"J62*L62/100","v":0}]
[null,null,null,"160","mm",0,"x",{"$f":"(35+(D63-D63*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":210.23469684462785},"=",0,"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"180","mm",0,"x",{"$f":"(35+(D64-D64*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":229.94570203701238},"=",0,"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(35+(D65-D65*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":249.65670722939691},"=",{"$f":"F65*H65","v":0},"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",{"$f":"J65*L65/100","v":0}]
[null,null,"≥","225","mm",0,"x",{"$f":"(35+(D66-D66*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":274.29546371987755},"=",0,"x",{"$f":"ROUND((1/L56*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F59:F66)","v":0},null,null,{"$f":"SUM(J59:J66)","v":0},null,null,null,null,{"$f":"SUM(O59:O66)","v":0}]
[]
[null,"2.3.","Acier",null,null,null,null,null,"Durée de vie utile :",null,null,70,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",80,"mm",0,"x",{"$f":"(130+D72*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":268.02159499400881},"=",{"$f":"F72*H72","v":0},"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",{"$f":"J72*L72/100","v":0}]
[null,null,null,"100","mm",0,"x",{"$f":"(130+D73*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":286.20018972174142},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(130+D74*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":308.92343313140725},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"150","mm",0,"x",{"$f":"(130+D75*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":331.64667654107313},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(130+D76*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":377.09316336040473},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"250","mm",0,"x",{"$f":"(130+D77*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":422.53965017973638},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"300","mm",0,"x",{"$f":"(130+D78*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":467.98613699906804},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"350","mm",0,"x",{"$f":"(130+D79*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":513.43262381839975},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"400","mm",0,"x",{"$f":"(130+D80*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":558.87911063773129},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"450","mm",0,"x",{"$f":"(130+D81*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":604.32559745706294},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,null,"500","mm",0,"x",{"$f":"(130+D82*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":649.77208427639471},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,"≥","600","mm",0,"x",{"$f":"(130+D83*0.605)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":740.6650579150579},"=",0,"x",{"$f":"ROUND((1/L69*10000)/5,0)*5/100","v":1.45},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F72:F83)","v":0},null,null,{"$f":"SUM(J72:J83)","v":0},null,null,null,null,{"$f":"SUM(O72:O83)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des conduites d'adduction en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N54+N67+N84","v":0}]
[]
[]
[null,"3.","Conduites de distribution (zone rurale à faible densité de construction)",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"3.1.","Fonte ductile",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",80,"mm",0,"x",{"$f":"(140+D94*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":294.46318732525629},"=",{"$f":"F94*H94*$R$2","v":0},"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J94*L94/100","v":0}]
[null,null,null,"100","mm",0,"x",{"$f":"(140+D95*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":315.49627213420314},"=",{"$f":"F95*H95*$R$2","v":0},"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(140+D96*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":341.7876281453868},"=",0,"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"150","mm",0,"x",{"$f":"(140+D97*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":368.07898415657036},"=",0,"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(140+D98*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":420.66169617893758},"=",0,"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"250","mm",0,"x",{"$f":"(140+D99*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":473.24440820130474},"=",0,"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"≥","300","mm",0,"x",{"$f":"(140+D100*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":525.82712022367195},"=",0,"x",{"$f":"ROUND((1/L91*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F94:F100)*$R$2","v":0},null,null,{"$f":"SUM(J94:J100)","v":0},null,null,null,null,{"$f":"SUM(O94:O100)","v":0}]
[]
[null,"3.2.","PEHD",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,"x",{"$f":"(95+(D106-D106*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":242.47090404074027},"=",{"$f":"F106*H106*$R$2","v":0},"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J106*L106/100","v":0}]
[null,null,null,"110","mm",0,"x",{"$f":"(95+(D107-D107*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":264.64578488217285},"=",0,"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(95+(D108-D108*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":281.27694551324726},"=",0,"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"140","mm",0,"x",{"$f":"(95+(D109-D109*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":297.90810614432166},"=",{"$f":"F109*H109*$R$2","v":0},"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J109*L109/100","v":0}]
[null,null,null,"160","mm",0,"x",{"$f":"(95+(D110-D110*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":320.08298698575425},"=",0,"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"180","mm",0,"x",{"$f":"(95+(D111-D111*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":342.25786782718677},"=",0,"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(95+(D112-D112*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":364.43274866861935},"=",{"$f":"F112*H112*$R$2","v":0},"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J112*L112/100","v":0}]
[null,null,"≥","225","mm",0,"x",{"$f":"(95+(D113-D113*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":392.15134972041011},"=",0,"x",{"$f":"ROUND((1/L103*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F106:F113)*$R$2","v":0},null,null,{"$f":"SUM(J106:J113)","v":0},null,null,null,null,{"$f":"SUM(O106:O113)","v":0}]
[]
[null,"3.3.","Branchements particuliers",null,null,null,null,null,"Durée de vie utile :",null,null,40,"ans",null,"Aide"]
[]
[null,null,"Nombre de                    branchements particuliers",null,null,null,"Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,{"$f":"SUM('Coût de l''eau potable'!D31:K31)*$R$2","v":0},null,null,null,"x",{"$f":"ROUND((1300/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))/10,0)*10","v":1950},"=",{"$f":"C119*H119","v":0},"x",{"$f":"ROUND((1/L116*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"J119*L119/100","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des conduites de distribution en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N101+N114+O119","v":0}]
[]
[]
[null,"4.","Conduites de distribution (zone urbaine à forte densité de construction)",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"4.1.","Fonte ductile",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",80,"mm",0,"x",{"$f":"(190+D129*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":369.58134735720944},"=",{"$f":"F129*H129*$R$1","v":0},"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J129*L129/100","v":0}]
[null,null,null,"100","mm",0,"x",{"$f":"(190+D130*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":390.61443216615629},"=",{"$f":"F130*H130*$R$1","v":0},"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(190+D131*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":416.9057881773399},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"150","mm",0,"x",{"$f":"(190+D132*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":443.19714418852351},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(190+D133*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":495.77985621089067},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"250","mm",0,"x",{"$f":"(190+D134*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":548.36256823325789},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"300","mm",0,"x",{"$f":"(190+D135*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":600.94528025562499},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"350","mm",0,"x",{"$f":"(190+D136*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":653.52799227799233},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"≥","400","mm",0,"x",{"$f":"(190+D137*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":706.11070430035954},"=",0,"x",{"$f":"ROUND((1/L126*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F129:F137)*$R$1","v":0},null,null,{"$f":"SUM(J129:J137)","v":0},null,null,null,null,{"$f":"SUM(O129:O137)","v":0}]
[]
[null,"4.2.","PEHD",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,"x",{"$f":"(145+(D143-D143*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":317.58906407269336},"=",{"$f":"F143*H143*$R$1","v":0},"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J143*L143/100","v":0}]
[null,null,null,"110","mm",0,"x",{"$f":"(145+(D144-D144*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":339.763944914126},"=",0,"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(145+(D145-D145*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":356.39510554520041},"=",0,"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"160","mm",0,"x",{"$f":"(145+(D146-D146*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":395.20114701770734},"=",0,"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"180","mm",0,"x",{"$f":"(145+(D147-D147*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":417.37602785913992},"=",0,"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J147*L147/100","v":0}]
[null,null,null,"200","mm",0,"x",{"$f":"(145+(D148-D148*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":439.55090870057245},"=",{"$f":"F148*H148*$R$1","v":0},"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J148*L148/100","v":0}]
[null,null,"≥","225","mm",0,"x",{"$f":"(145+(D149-D149*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":467.26950975236332},"=",0,"x",{"$f":"ROUND((1/L140*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F143:F149)*$R$1","v":0},null,null,{"$f":"SUM(J143:J149)","v":0},null,null,null,null,{"$f":"SUM(O143:O149)","v":0}]
[]
[null,"4.4.","Acier",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Valeur unitaire\n(€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,"≤",80,"mm",0,"x",{"$f":"(190+D155*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":369.58134735720944},"=",{"$f":"F155*H155*$R$1","v":0},"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J155*L155/100","v":0}]
[null,null,null,"100","mm",0,"x",{"$f":"(190+D156*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":390.61443216615629},"=",{"$f":"F156*H156*$R$1","v":0},"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"125","mm",0,"x",{"$f":"(190+D157*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":416.9057881773399},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"150","mm",0,"x",{"$f":"(190+D158*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":443.19714418852351},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"200","mm",0,"x",{"$f":"(190+D159*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":495.77985621089067},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"250","mm",0,"x",{"$f":"(190+D160*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":548.36256823325789},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"300","mm",0,"x",{"$f":"(190+D161*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":600.94528025562499},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,null,"350","mm",0,"x",{"$f":"(190+D162*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":653.52799227799233},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"≥","400","mm",0,"x",{"$f":"(190+D163*0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12)","v":706.11070430035954},"=",0,"x",{"$f":"ROUND((1/L152*10000)/5,0)*5/100","v":2},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F155:F163)*$R$1","v":0},null,null,{"$f":"SUM(J155:J163)","v":0},null,null,null,null,{"$f":"SUM(O155:O163)","v":0}]
[]
[null,"4.5.","Branchements particuliers",null,null,null,null,null,"Durée de vie utile :",null,null,40,"ans",null,"Aide"]
[]
[null,null,"Nombre de                    branchements particuliers",null,null,null,"Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,{"$f":"SUM('Coût de l''eau potable'!D31:K31)*R1","v":0},null,null,null,"x",{"$f":"ROUND((1800/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))/10,0)*10","v":2700},"=",{"$f":"C169*H169","v":0},"x",{"$f":"ROUND((1/L166*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"J169*L169/100","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des conduites de distribution en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N138+N150+N164+O169","v":0}]
[]
[]
[null,"5.","Réservoirs",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"5.1.","Réservoirs enterrés",null,null,null,null,null,"Durée de vie utile :",null,null,45,"ans"]
[]
[null,null,"Code national",null,null,"Volume de stockage (m3)","Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,"x",{"$f":"IF(F179=0,0,(118000*F179^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F179*H179","v":0},"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J179*L179/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F180=0,0,(118000*F180^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F181=0,0,(118000*F181^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F182=0,0,(118000*F182^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F183=0,0,(118000*F183^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F184=0,0,(118000*F184^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F185=0,0,(118000*F185^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F186=0,0,(118000*F186^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F187=0,0,(118000*F187^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F188=0,0,(118000*F188^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F189=0,0,(118000*F189^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,null,null,null,0,"x",{"$f":"IF(F190=0,0,(118000*F190^-0.7)/761*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",0,"x",{"$f":"ROUND((1/L176*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F179:F190)","v":0},null,null,{"$f":"SUM(J179:J190)","v":0},null,null,null,null,{"$f":"SUM(O179:O190)","v":0}]
[]
[null,"5.2.","Châteaux d'eau",null,null,null,null,null,"Durée de vie utile :",null,null,45,"ans"]
[]
[null,null,"Code national",null,null,"Volume de stockage (m3)","Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,"x",{"$f":"IF(F196=0,0,(230000*F196^-0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F196*H196","v":0},"x",{"$f":"ROUND((1/L193*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J196*L196/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F197=0,0,(230000*F197^-0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F197*H197","v":0},"x",{"$f":"ROUND((1/L193*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J197*L197/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F198=0,0,(230000*F198^-0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F198*H198","v":0},"x",{"$f":"ROUND((1/L193*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J198*L198/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F199=0,0,(230000*F199^-0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F199*H199","v":0},"x",{"$f":"ROUND((1/L193*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J199*L199/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F200=0,0,(230000*F200^-0.7)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F200*H200","v":0},"x",{"$f":"ROUND((1/L193*10000)/5,0)*5/100","v":2.2000000000000002},"%","=",{"$f":"J200*L200/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F196:F200)","v":0},null,null,{"$f":"SUM(J196:J200)","v":0},null,null,null,null,{"$f":"SUM(O196:O200)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des réservoirs en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N191+N201","v":0}]
[]
[]
[null,"6.","Stations élévatoires et régulatrices"]
[]
[null,"6.1.","Stations élévatoires dans le réseau d'adduction",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,"Bâtiment",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Code national",null,null,"Volume bâti (m3)","Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,"x",{"$f":"IF(F213=0,0,(1300*F213^-0.15)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F213*H213","v":0},"x",{"$f":"ROUND((1/L210*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J213*L213/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F214=0,0,(1300*F214^-0.15)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F214*H214","v":0},"x",{"$f":"ROUND((1/L210*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J214*L214/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F215=0,0,(1300*F215^-0.15)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F215*H215","v":0},"x",{"$f":"ROUND((1/L210*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J215*L215/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F216=0,0,(1300*F216^-0.15)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F216*H216","v":0},"x",{"$f":"ROUND((1/L210*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J216*L216/100","v":0}]
[null,null,null,null,null,0,"x",{"$f":"IF(F217=0,0,(1300*F217^-0.15)/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F217*H217","v":0},"x",{"$f":"ROUND((1/L210*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J217*L217/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F213:F217)","v":0},null,null,{"$f":"SUM(J213:J217)","v":0},null,null,null,null,{"$f":"SUM(O213:O217)","v":0}]
[]
[null,null,"Equipement électromécanique",null,null,null,null,null,"Durée de vie utile :",null,null,20,"ans"]
[]
[null,null,"Code national",null,null,"Capacité max. (m3/h)","Valeur unitaire (€/m3/h)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,{"$f":"IF(C213=\"\",\"\",C213)","v":""},null,null,0,"x",{"$f":"IF(F223=0,0,(1700*F223^-0.2)/682.08*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F223*H223","v":0},"x",{"$f":"ROUND((1/L220*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J223*L223/100","v":0}]
[null,null,{"$f":"IF(C214=\"\",\"\",C214)","v":""},null,null,0,"x",{"$f":"IF(F224=0,0,(1700*F224^-0.2)/682.08*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F224*H224","v":0},"x",{"$f":"ROUND((1/L220*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J224*L224/100","v":0}]
[null,null,{"$f":"IF(C215=\"\",\"\",C215)","v":""},null,null,0,"x",{"$f":"IF(F225=0,0,(1700*F225^-0.2)/682.08*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F225*H225","v":0},"x",{"$f":"ROUND((1/L220*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J225*L225/100","v":0}]
[null,null,{"$f":"IF(C216=\"\",\"\",C216)","v":""},null,null,0,"x",{"$f":"IF(F226=0,0,(1700*F226^-0.2)/682.08*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F226*H226","v":0},"x",{"$f":"ROUND((1/L220*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J226*L226/100","v":0}]
[null,null,{"$f":"IF(C217=\"\",\"\",C217)","v":""},null,null,0,"x",{"$f":"IF(F227=0,0,(1700*F227^-0.2)/682.08*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))","v":0},"=",{"$f":"F227*H227","v":0},"x",{"$f":"ROUND((1/L220*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J227*L227/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F223:F227)","v":0},null,null,{"$f":"SUM(J223:J227)","v":0},null,null,null,null,{"$f":"SUM(O223:O227)","v":0}]
[]
[null,"6.2.","Stations de régulation de la pression dans le réseau de distribution",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,"Bâtiment",null,null,null,null,null,"Durée de vie utile :",null,null,50,"ans"]
[]
[null,null,"Nombre de\nstations de régulation",null,null,null,"Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,0,null,null,null,"x",{"$f":"ROUND((50000/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))/1000,0)*1000","v":75000},"=",{"$f":"C235*H235","v":0},"x",{"$f":"ROUND((1/L232*10000)/5,0)*5/100","v":2},"%","=",{"$f":"J235*L235/100","v":0}]
[]
[null,null,"Equipement électromécanique",null,null,null,null,null,"Durée de vie utile :",null,null,20,"ans"]
[]
[null,null,"Nombre de\nstations de régulation",null,null,null,"Valeur unitaire\n(€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,{"$f":"C235","v":0},null,null,null,"x",{"$f":"ROUND((20000/600.88*IF('Coût de l''eau potable'!$N$1=2,$N$8,$N$12))/1000,0)*1000","v":30000},"=",{"$f":"C240*H240","v":0},"x",{"$f":"ROUND((1/L237*10000)/5,0)*5/100","v":5},"%","=",{"$f":"J240*L240/100","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des stations de pompage en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N218+N228+O235+O240","v":0}]
[]
[]
[null,"7.","Autres éléments",null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,"Désignation",null,null,"Pièces","Valeur unitaire (€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,"x",0,"=",{"$f":"F248*H248","v":0},"x",0,"%","=",{"$f":"J248*L248/100","v":0}]
[null,null,null,null,null,0,"x",0,"=",{"$f":"F249*H249","v":0},"x",0,"%","=",{"$f":"J249*L249/100","v":0}]
[null,null,null,null,null,0,"x",0,"=",{"$f":"F250*H250","v":0},"x",0,"%","=",{"$f":"J250*L250/100","v":0}]
[null,null,null,null,null,0,"x",0,"=",{"$f":"F251*H251","v":0},"x",0,"%","=",{"$f":"J251*L251/100","v":0}]
[null,null,null,null,null,0,"x",0,"=",{"$f":"F252*H252","v":0},"x",0,"%","=",{"$f":"J252*L252/100","v":0}]
[null,null,"Valeurs totales :",null,null,null,null,null,{"$f":"SUM(J248:J252)","v":0},null,null,null,null,{"$f":"SUM(O248:O252)","v":0}]
[]
[]
[null,"8.",{"$f":"CONCATENATE(\"Valeur patrimoniale et amortissement annuel \",IF('Coût de l''eau potable'!$N$1=2,CONCATENATE(\"(année de référence \",'Coût de l''eau potable'!$K$5,\")\"),CONCATENATE(\"(données prévisionnelles \",'Coût de l''eau potable'!$K$7,\")\")))","v":"Valeur patrimoniale et amortissement annuel (année de référence 2021)"},null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,"Valeur patrimoniale des infrastructures d'approvisionnement en € hors frais d'études :",null,null,null,null,null,null,null,null,null,null,{"$f":"I25+I33+I54+I67+I84+I101+I114+J119+I138+I150+I164+J169+I191+I201+I218+I228+J235+J240+I253","v":0}]
[]
[null,null,"Valeur unitaire du réseau de conduites en €/m hors frais d'études :",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((F54+F67+F84+F101+F114+F138+F150+F164)=0,0,(I54+I67+I84+I101+I114+I138+I150+I164)/(F54+F67+F84+F101+F114+F138+F150+F164))","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des coûts de remplacement en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N35+N86+N121+N171+N203+N242+N253","v":0}]
[null,null,"TVA sur les coûts de remplacement en €  :",null,null,null,null,null,null,null,null,null,null,{"$f":"N262*N14","v":0}]
[null,null,"TOTAL de l'amortissement annuel des frais d'études en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N35*0.16+N86*0.12+N121*0.12+N171*0.14+N203*0.16+N242*0.16+N253*0.16","v":0}]
[null,null,"TVA sur les frais d'études en €  :",null,null,null,null,null,null,null,null,null,null,{"$f":"N264*N14","v":0}]
[null,null,"TOTAL de l'amortissement annuel des infrastructures d'approvisionnement en € :",null,null,null,null,null,null,null,null,null,null,{"$f":"N262+N263+N264+N265","v":0}]

{"sheet":"Amortissement charroi et immob.","index":2,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,14,76,15],[71,14,71,15],[71,2,71,13],[69,14,69,15],[76,2,76,13],[69,9,69,10],[69,2,69,4],[69,11,69,13],[69,7,69,8],[74,2,74,8],[44,14,44,15],[44,11,44,13],[29,14,29,15],[33,14,33,15],[33,11,33,13],[59,14,59,15],[59,11,59,13],[63,11,63,13],[53,14,53,15],[53,11,53,13],[46,14,46,15],[44,7,44,8],[64,2,64,4],[66,2,66,4],[67,2,67,4],[65,2,65,4],[63,14,63,15],[61,9,61,10],[59,7,59,8],[59,9,59,10],[63,9,63,10],[55,2,55,4],[56,2,56,4],[53,9,53,10],[63,2,63,4],[53,7,53,8],[54,2,54,4],[53,2,53,4],[40,2,40,4],[38,2,38,4],[39,2,39,4],[41,2,41,4],[43,2,43,4],[68,2,68,4],[63,7,63,8],[59,2,59,4],[57,2,57,4],[58,2,58,4],[18,11,18,13],[46,2,46,13],[51,9,51,10],[49,2,49,6],[26,2,26,4],[33,9,33,10],[37,2,37,4],[42,2,42,4],[33,2,33,4],[35,2,35,4],[23,2,23,4],[21,2,21,4],[22,2,22,4],[19,2,19,4],[44,9,44,10],[29,11,29,13],[18,7,18,8],[25,2,25,4],[44,2,44,4],[20,2,20,4],[18,9,18,10],[27,2,27,4],[28,2,28,4],[29,9,29,10],[24,2,24,4],[36,2,36,4],[29,2,29,4],[33,7,33,8],[29,7,29,8],[34,2,34,4],[31,9,31,10],[16,9,16,10],[18,2,18,4],[14,2,14,5],[0,0,3,0],[1,1,2,8],[4,0,12,0],[5,2,5,15],[7,14,7,15],[9,14,9,15],[1,15,2,15],[1,9,2,14],[11,14,11,15],[9,2,9,13],[7,2,7,9],[11,2,11,13],[18,14,18,15]]}
["23 / 03 / 2022"]
[null,"Amortissement des parcs \nautomobile et immobilier",null,null,null,null,null,null,null,{"$f":"IF('Coût de l''eau potable'!$N$1=2,'Coût de l''eau potable'!$H$5,'Coût de l''eau potable'!$I$7)","v":"Année de référence (comptes) :"},null,null,null,null,null,{"$f":"IF('Coût de l''eau potable'!N1=2,'Coût de l''eau potable'!$K$5,'Coût de l''eau potable'!$K$7)","v":2021}]
[]
[]
[]
[null,"0.","Taux à base du calcul de l'amortissement"]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel des prix de la construction de l'année \",'Coût de l''eau potable'!$K$5,\" :\")","v":"Indice moyen annuel des prix de la construction de l'année 2021 :"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!N8","v":902.74}]
[]
[null,null,"Variation annuelle estimée de l'indice des prix de la construction :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!N10","v":2.5000000000000001E-2}]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel estimé des prix de la construction de l'année \",'Coût de l''eau potable'!$K$7,\" :\")","v":"Indice moyen annuel estimé des prix de la construction de l'année 2023 :"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!N12","v":948.44121249999989}]
[]
[]
[null,"1.","Parc automobile"]
[]
[null,"1.1.","Véhicules < 3,50 to",null,null,null,null,null,null,"Durée de vie utile :",null,null,5,"ans"]
[]
[null,null,"Désignation",null,null,"Nombre de véhicules","Quote-part de l'utilisation","Valeur unitaire\n(€)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,1,"x",0,"=",{"$f":"F20*G20*I20","v":0},"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",{"$f":"K20*M20/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",{"$f":"F21*G21*I21","v":0},"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",{"$f":"K21*M21/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",{"$f":"K23*M23/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",{"$f":"K24*M24/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",{"$f":"K25*M25/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M17*10000)/25,0)*25/100","v":20},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F20:F29)","v":0},null,null,null,{"$f":"SUM(K20:K29)","v":0},null,null,null,null,{"$f":"SUM(P20:P29)","v":0}]
[]
[null,"2.2.","Véhicules > 3,50 to",null,null,null,null,null,null,"Durée de vie utile :",null,null,10,"ans"]
[]
[null,null,"Désignation",null,null,"Nombre de véhicules","Quote-part de l'utilisation","Valeur unitaire\n(€)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,1,"x",0,"=",{"$f":"F35*G35*I35","v":0},"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",{"$f":"K35*M35/100","v":0}]
[null,null,null,null,null,0,1,"x",0,"=",{"$f":"F36*G36*I36","v":0},"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,null,null,null,0,1,"x",0,"=",0,"x",{"$f":"ROUND((1/M32*10000)/25,0)*25/100","v":10},"%","=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F35:F44)","v":0},null,null,null,{"$f":"SUM(K35:K44)","v":0},null,null,null,null,{"$f":"SUM(P35:P44)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel du parc automobile en € :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O30+O45","v":0}]
[]
[]
[null,"2.","Parc immobilier"]
[]
[null,"2.1.","Bâtiments administratifs",null,null,null,null,null,null,"Durée de vie utile :",null,null,40,"ans"]
[]
[null,null,"Désignation",null,null,"Volume bâti (m3)","Quote-part de l'utilisation","Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((350/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":530},"=",{"$f":"F55*G55*I55","v":0},"x",{"$f":"ROUND((1/M52*10000)/25,0)*25/100","v":2.5},"%","=",{"$f":"K55*M55/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((350/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":530},"=",{"$f":"F56*G56*I56","v":0},"x",{"$f":"ROUND((1/M52*10000)/25,0)*25/100","v":2.5},"%","=",{"$f":"K56*M56/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((350/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":530},"=",{"$f":"F57*G57*I57","v":0},"x",{"$f":"ROUND((1/M52*10000)/25,0)*25/100","v":2.5},"%","=",{"$f":"K57*M57/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((350/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":530},"=",{"$f":"F58*G58*I58","v":0},"x",{"$f":"ROUND((1/M52*10000)/25,0)*25/100","v":2.5},"%","=",{"$f":"K58*M58/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((350/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":530},"=",{"$f":"F59*G59*I59","v":0},"x",{"$f":"ROUND((1/M52*10000)/25,0)*25/100","v":2.5},"%","=",{"$f":"K59*M59/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F55:F59)","v":0},null,null,null,{"$f":"SUM(K55:K59)","v":0},null,null,null,null,{"$f":"SUM(P55:P59)","v":0}]
[]
[null,"2.2.","Halls techniques",null,null,null,null,null,null,"Durée de vie utile :",null,null,30,"ans"]
[]
[null,null,"Désignation",null,null,"Volume bâti (m3)","Quote-part de l'utilisation","Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((150/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":230},"=",{"$f":"F65*G65*I65","v":0},"x",{"$f":"ROUND((1/M62*10000)/25,0)*25/100","v":3.25},"%","=",{"$f":"K65*M65/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((150/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":230},"=",{"$f":"F66*G66*I66","v":0},"x",{"$f":"ROUND((1/M62*10000)/25,0)*25/100","v":3.25},"%","=",{"$f":"K66*M66/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((150/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":230},"=",{"$f":"F67*G67*I67","v":0},"x",{"$f":"ROUND((1/M62*10000)/25,0)*25/100","v":3.25},"%","=",{"$f":"K67*M67/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((150/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":230},"=",{"$f":"F68*G68*I68","v":0},"x",{"$f":"ROUND((1/M62*10000)/25,0)*25/100","v":3.25},"%","=",{"$f":"K68*M68/100","v":0}]
[null,null,null,null,null,0,1,"x",{"$f":"ROUND((150/600.88*IF('Coût de l''eau potable'!$N$1=2,$O$8,$O$12))/10,0)*10","v":230},"=",{"$f":"F69*G69*I69","v":0},"x",{"$f":"ROUND((1/M62*10000)/25,0)*25/100","v":3.25},"%","=",{"$f":"K69*M69/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F65:F69)","v":0},null,null,null,{"$f":"SUM(K65:K69)","v":0},null,null,null,null,{"$f":"SUM(P65:P69)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel du parc immobilier en € :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O60+O70","v":0}]
[]
[]
[null,"8.",{"$f":"CONCATENATE(\"Amortissement annuel \",IF('Coût de l''eau potable'!$N$1=2,CONCATENATE(\"(année de référence \",'Coût de l''eau potable'!$K$5,\")\"),CONCATENATE(\"(données prévisionnelles \",'Coût de l''eau potable'!$K$7,\")\")))","v":"Amortissement annuel (année de référence 2021)"}]
[]
[null,null,"TOTAL de l'amortissement annuel des parcs automobile et immobilier en € :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O47+O72","v":0}]