{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Coût de l'eau usée","Amortissement infrastructures","Amortissement charroi et immob."],"not_rendered":{"charts":0,"images":9,"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 usée","index":0,"n_rows":188,"n_cols":14,"rows_kept":188,"cut":false,"hidden":false,"merged":[[27,3,27,4],[64,2,64,3],[62,2,62,9],[52,8,52,9],[48,8,48,9],[80,2,80,3],[47,8,47,9],[95,4,95,5],[95,2,95,3],[83,2,83,3],[93,2,93,5],[88,4,89,4],[44,8,44,9],[30,5,30,6],[39,2,39,9],[0,0,8,0],[59,2,59,9],[56,2,56,6],[0,1,8,1],[53,8,53,9],[6,7,7,8],[21,3,21,4],[20,3,20,4],[30,3,30,4],[49,8,49,9],[4,2,4,5],[14,2,14,9],[16,3,16,4],[24,3,24,4],[18,3,18,4],[4,6,5,8],[10,2,10,9],[2,7,2,9],[23,3,23,4],[6,2,6,5],[25,3,25,4],[50,8,50,9],[45,8,45,9],[42,8,42,9],[3,2,3,6],[2,2,2,6],[7,2,7,5],[5,2,5,5],[4,9,5,9],[115,1,116,1],[129,2,129,3],[115,4,116,4],[124,2,124,3],[115,2,116,3],[86,2,86,5],[122,7,122,8],[87,2,87,5],[88,3,89,3],[97,2,97,9],[99,2,99,5],[82,2,82,3],[85,2,85,5],[75,2,75,3],[107,2,107,5],[60,2,60,9],[34,2,34,4],[108,4,108,5],[108,2,108,3],[129,7,129,8],[127,7,127,8],[144,2,144,3],[142,2,142,3],[135,2,135,3],[115,5,116,5],[115,7,116,8],[118,7,118,8],[146,2,146,3],[119,7,119,8],[115,6,116,6],[128,7,128,8],[125,7,125,8],[126,7,126,8],[123,2,123,3],[121,7,121,8],[130,2,130,3],[141,2,141,3],[138,2,138,9],[134,2,134,3],[133,7,133,8],[123,7,123,8],[131,7,131,8],[143,2,143,3],[175,4,177,4],[147,2,147,3],[145,2,145,3],[175,3,177,3],[167,3,168,3],[167,4,168,4],[167,6,168,6],[132,7,132,8],[139,2,139,5],[155,2,155,9],[150,2,150,9],[151,2,151,6],[7,11,8,11],[7,12,8,12],[46,8,46,9],[115,11,115,13],[17,3,17,4],[113,2,113,9],[68,2,68,3],[110,2,110,3],[28,3,28,4],[43,8,43,9],[110,4,110,5],[94,2,94,5],[11,6,11,7],[11,8,11,9],[12,6,12,7],[12,8,12,9],[69,2,69,3],[13,8,13,9],[13,6,13,7],[76,2,76,3],[66,2,66,3],[51,8,51,9],[41,8,41,9],[6,9,7,9]]}
["Version révisée le 18 / 04 / 2023",null,null,null,null,null,null,null,null,null,null,"Cell link Année de calcul",1]
[null,null,null,null,null,null,null,null,null,null,null,"Cell link Nom de la commune",1]
[null,null,"Ministère du Développement durable et des Infrastructures",null,null,null,null,"Choisir l'année de calcul :",null,null,null,"Zone urbaine",{"$f":"IF(OR(M2=1,M2=108),0,LOOKUP(M2,M13:M114,N13:N114))","v":0}]
[null,null,"Association Luxembourgeoise des Services d'Eau",null,null,null,null,null,null,null,null,"Zone rurale",{"$f":"IF(OR(M2=1,M2=108),0,IF(M3=0,1,0))","v":0}]
[null,null,null,null,null,null,"Année de référence (comptes) :",null,null,2022,null,"Limite des coûts indexée ",{"$f":"5/108*M8*IF($M$1=2,1*(1+$D$13)^(J7-J5),1)","v":5.3629629629629632}]
[null,null,"Tableur relatif au calcul du coût de ",null,null,null,null,null,null,null,null,"EHr de dimensionnement",{"$f":"'Amortissement infrastructures'!F281","v":0}]
[null,null,"l'évacuation et de la dépollution des eaux",null,null,null,null,"Données prévisionnelles :",null,{"$f":"J5+2","v":2024},null,"EHr raccordés",{"$f":"'Amortissement infrastructures'!H281","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Indice ICPN base 100 2015 (moyenne de l'année \",J5,\")\")","v":"Indice ICPN base 100 2015 (moyenne de l'année 2022)"},115.84]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evacuation (l/habitant/jour)",{"$f":"D22/D19/365*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,"Long. réseau EU/EM (m/habitant)",{"$f":"('Amortissement infrastructures'!F32+'Amortissement infrastructures'!G32+'Amortissement infrastructures'!F44+'Amortissement infrastructures'!G44+'Amortissement infrastructures'!F54+'Amortissement infrastructures'!G54+'Amortissement infrastructures'!F65+'Amortissement infrastructures'!G65+'Amortissement infrastructures'!F86+'Amortissement infrastructures'!G86+'Amortissement infrastructures'!F96+'Amortissement infrastructures'!G96+'Amortissement infrastructures'!F106+'Amortissement infrastructures'!G106+'Amortissement infrastructures'!F117+'Amortissement infrastructures'!G117+'Amortissement infrastructures'!F142+'Amortissement infrastructures'!G142+'Amortissement infrastructures'!F152+'Amortissement infrastructures'!G152+'Amortissement infrastructures'!F162+'Amortissement infrastructures'!G162+'Amortissement infrastructures'!F173+'Amortissement infrastructures'!G173)/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 conjoncture STATEC 2023) :",2.8000000000000001E-2,null,null,null,null,null,null,null,"Nom de la commune",1,0]
[null,null,null,null,null,null,null,null,null,null,null,"AERENZDALL",2,0]
[null,"0.",{"$f":"CONCATENATE(\"Données à caractère général (année de référence \",$J$5,\")\")","v":"Données à caractère général (année de référence 2022)"},null,null,null,null,null,null,null,null,"BEAUFORT",3,0]
[null,null,null,null,null,null,null,null,null,null,null,"BECH",4,0]
[null,null,"Commune : ",null,null,null,null,null,null,null,null,"BECKERICH",5,0]
[null,null,"Superficie (ha) :",0,null,null,null,null,null,null,null,"BERDORF",6,0]
[null,null,{"$f":"CONCATENATE(\"Population résidente (au 31 décembre \",$J$5,\") :\")","v":"Population résidente (au 31 décembre 2022) :"},0,null,null,null,null,null,null,null,"BERTRANGE",7,0]
[null,null,null,null,null,null,null,null,null,null,null,"BETTEMBOURG",8,0]
[null,null,"Evacuation des entités privées et publiques internes et collectée par l'infrastructure communale, tout secteur confondu NOTA BENE : ","Provenances internes\n(m3/an)",null,null,null,null,null,null,null,"BETTENDORF",9,0]
[null,null,"- quantité d'eau évacuée :",null,null,null,null,null,null,null,null,"BETZDORF",10,0]
[null,null,null,null,null,null,null,null,null,null,null,"BISSEN",11,0]
[null,null,"Evacuation des entités externes et collectée par l'infrastructure communale NOTA BENE : ","Provenances externes\n(m3/an)",null,null,null,null,null,null,null,"BIWER",12,0]
[null,null,"- quantité d'eau évacuée :",null,null,null,null,null,null,null,null,"BOULAIDE",13,0]
[null,null,"Quantité d'eau totale collectée par l'infrastructure communale :",{"$f":"D25+D22","v":0},null,null,null,null,null,null,null,"BOURSCHEID",14,0]
[null,null,null,null,null,null,null,null,null,null,null,"BOUS-WALDBREDIMUS",15,0]
[null,null,"Evacuation vers une infrastructure externe comunale ou syndicale se référer à NOTA BENE : ","Evacuations externes\n(m3/an)",null,null,null,null,null,null,null,"CLERVAUX",16,0]
[null,null,"- quantité d'eau évacuée :",null,null,null,null,null,null,null,null,"COLMAR-BERG",17,0]
[null,null,null,null,null,null,null,null,null,null,null,"CONSDORF",18,0]
[null,null,"Situation des raccordements au réseau public d'évacuation/dépollution :","Nombre des ménages/établissements\n(abonnés en unités) NOTA BENE",null,"Charge polluante moy. annuelle\n(EH m) NOTA BENE",null,null,"® Le tableau EHm s'ouvre en arrière plan",null,null,"CONTERN",19,0]
[null,null,"Provenances internes collectées par l'infrastructure communale, tout secteur confondu ","internes\nraccordés","internes\nnon raccordés","interne \nraccordée","interne \nnon raccordée",null,null,null,null,"DALHEIM",20,0]
[null,null,"NOTA BENE :",null,null,null,null,null,null,null,null,"DIEKIRCH",21,0]
[null,null,null,null,null,null,null,null,null,null,null,"DIFFERDANGE",22,1]
[null,null,"Provenances externes collectées par l'infrastructure communale NOTA BENE :",null,null,null,null,null,null,null,null,"DIPPACH",23,0]
[null,null,null,null,null,null,null,null,null,null,null,"DUDELANGE",24,1]
[null,null,"Charge polluante moyenne annuelle totale collectée par l'infrastructure communale",null,null,{"$f":"F35+F33","v":0},null,null,null,null,null,"ECHTERNACH",25,0]
[null,null,null,null,null,null,null,null,null,null,null,"ELL",26,0]
[null,null,null,null,null,null,null,null,null,null,null,"ERPELDANGE",27,0]
[null,"1.",{"$f":"CONCATENATE(\"Traitement des eaux évacuées de la commune (année de référence \",$J$5,\")\")","v":"Traitement des eaux évacuées de la commune (année de référence 2022)"},null,null,null,null,null,null,null,null,"ESCH-SUR-ALZETTE",28,1]
[null,null,null,null,null,null,null,null,null,null,null,"ESCH-SUR-SÛRE",29,0]
[null,null,"Dépollution autonome par des AIDE :","Nombre de \nSTEP autonomes\n\n(unités) AIDE","Capacité épuratoire autonome\n\n(EH r) AIDE","Capacité épuratoire cédée \nà de tierces entités\n(EH r) AIDE","Capacité épuratoire disponible \npour la commune\n(EH r) AIDE","Capacité épuratoire utilisée \npar la commune\n(EH r) AIDE","Remarques",null,null,"ETTELBRUCK",30,0]
[null,null,"- stations mécaniques AIDE :",null,null,null,{"$f":"E43-F43","v":0},null,null,null,null,"FEULEN",31,0]
[null,null,"- stations biologiques AIDE :",null,null,null,{"$f":"E44-F44","v":0},null,null,null,null,"FISCHBACH",32,0]
[null,null,"Total dépollution autonome:",null,null,null,{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},null,null,null,"FLAXWEILER",33,0]
[null,null,"Dépollution de la commune par des entités tierces :",null,null,null,null,null,null,null,null,"FRISANGE",34,0]
[null,null,"- syndicats AIDE :",null,null,null,null,null,null,null,null,"GARNICH",35,0]
[null,null,null,null,null,null,null,null,null,null,null,"GOESDORF",36,0]
[null,null,null,null,null,null,null,null,null,null,null,"GREVENMACHER",37,0]
[null,null,"- communes AIDE :",null,null,null,null,null,null,null,null,"GROSBOUS-WAHL",38,0]
[null,null,null,null,null,null,null,null,null,null,null,"HABSCHT",39,0]
[null,null,null,null,null,null,null,null,null,null,null,"HELPERKNAPP",40,0]
[null,null,"Total dépollution par entités tierces :",null,null,null,{"$f":"SUM(G47:G52)","v":0},{"$f":"SUM(H47:H52)","v":0},null,null,null,"HEFFINGEN",41,0]
[null,null,null,null,null,null,null,null,null,null,null,"HESPERANGE",42,0]
[null,null,"Total dépollution de la commune :",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"G45+G53","v":0},{"$f":"H45+H53","v":0},null,null,null,"JUNGLINSTER",43,0]
[null,null,null,null,null,null,"AIDE","AIDE",null,null,null,"KÄERJENG",44,0]
[null,null,"Réserve en infrastructures d'évacuation/dépollution de la commune AIDE :",null,null,null,null,{"$f":"G55-H55","v":0},null,null,null,"KAYL",45,0]
[null,null,null,null,null,null,null,null,null,null,null,"KEHLEN",46,0]
[null,null,null,null,null,null,null,null,null,null,null,"KIISCHPELT",47,0]
[null,"2.",{"$f":"CONCATENATE(\"Coût complet des services liés à l'évacuation et à la dépollution des eaux \",IF(M1=1,CONCATENATE(\"(année de référence \",J5,\")\"),CONCATENATE(\"(données prévisionnelles \",J7,\")\")))","v":"Coût complet des services liés à l'évacuation et à la dépollution des eaux (année de référence 2022)"},null,null,null,null,null,null,null,null,"KOERICH",48,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,"KOPSTAL",49,0]
[null,null,null,null,null,null,null,null,null,null,null,"LAC DE LA HAUTE SURE",50,0]
[null,"2.1.","Charges de fonctionnement, de maintenance et d'exploitation propres (infrastructures autonomes)",null,null,null,null,null,null,null,null,"LAROCHETTE",51,0]
[null,null,"(budget ou compte ordinaire)",null,null,null,null,null,null,null,null,"LENNINGEN",52,0]
[null,null,"Dépenses pour :\nREMARQUE : Indication non exhaustive des codes fonctionnels du Plan budgétaire normalisé. Merci de sigaler toute erreur de code.",null,"Total article budgétaire (€)","Taux d'utilisation assainissement","Frais fixes\n(€/an)","Frais variables\n(€/an)","Total des frais\n(€/an)","Remarques",null,"LEUDELANGE",53,0]
[null,null,"Achats de matières et de fournitures :",null,null,null,null,null,null,null,null,"LINTGEN",54,0]
[null,null,"- fournitures pour l'entretien et le nettoyage des bâtiments (art. 3/520/603200) :",null,null,1,null,{"$f":"E67*F67*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G67:H67)","v":0},null,null,"LORENTZWEILER",55,0]
[null,null,"- fournitures pour l'entretien des réseaux (art. 3/520/603200) :",null,null,1,null,{"$f":"E68*F68*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G68:H68)","v":0},null,null,"LUXEMBOURG",56,1]
[null,null,"- facturation interne des consommations eau-électricité-gaz des bâtiments (art. 3/520/608111/X & 112/X & 113/X) : ",null,null,1,null,{"$f":"E69*F69*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G69:H69)","v":0},null,null,"MAMER",57,0]
[null,null,"- frais de consommation électrique des infrastructures et des réseaux (art. 3/520/608112) :",null,null,1,null,{"$f":"E70*F70*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G70:H70)","v":0},null,null,"MANTERNACH",58,0]
[null,null,"- achats et fournitures divers (art. 3/520/608180) :",null,null,1,{"$f":"0.5*E71*F71*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"0.5*E71*F71*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G71:H71)","v":0},null,null,"MERSCH",59,0]
[null,null,"Services extérieurs :",null,null,null,null,null,null,null,null,"MERTERT",60,0]
[null,null,"- frais d'entretien et de nettoyage des bâtiments (art. 3/520/612300) :",null,null,1,null,{"$f":"E73*F73*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G73:H73)","v":0},null,null,"MERTZIG",61,0]
[null,null,"- frais d'assurances (incendie, responsabilité civile, etc) (art. 3/520/614xxx) :",null,null,1,{"$f":"E74*F74*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,0,null,null,"MONDERCANGE",62,0]
[null,null,"- frais d'entretien des véhicules automoteurs (art. 3/520/61223x) :",null,null,1,null,{"$f":"E75*F75*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"MONDORF-LES-BAINS",63,0]
[null,null,"- frais de services administratives et techniques (art. 3/520/61213x) :",null,null,1,null,{"$f":"E76*F76*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"NIEDERANVEN",64,0]
[null,null,"- frais d'entretien des réseaux et des stations d'épuration (art. 3/520/603200) NOTA BENE :",null,null,1,null,{"$f":"E77*F77*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"NOMMERN",65,0]
[null,null,"- frais d'évacuation des boues d'épuration (art. 3/520/6184xx) :",null,null,1,null,{"$f":"E78*F78*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"PARC HOSINGEN",66,0]
[null,null,"- frais d'enlèvement-recyclage-destruction des ordures (art. 3/520/6183xx) :",null,null,1,null,{"$f":"E79*F79*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"PETANGE",67,1]
[null,null,"- frais d'outillage et de matériel roulant (3/520/6122xx) :",null,null,1,null,{"$f":"E80*F80*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"PREIZERDAUL",68,0]
[null,null,"- frais pour prestations effectuées par d'autres services communaux (3/520/61218xx) :",null,null,1,{"$f":"0.5*E81*F81*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"0.5*E81*F81*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},0,null,null,"PUTSCHEID",69,0]
[null,null,"Frais de personnel - rémunérations :",null,null,null,null,null,null,null,null,"RAMBROUCH",70,0]
[null,null,"- frais du personnel propre du service (art. 3/520/621xxx) AIDE :",null,null,1,{"$f":"E83*F83*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,{"$f":"SUM(G83:H83)","v":0},null,null,"RECKANGE-SUR-MESS",71,0]
[null,null,"- frais du personnel ventilé d'autres services communaux (art. 3/520/621xxx) AIDE : ",null,null,1,{"$f":"E84*F84*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,{"$f":"SUM(G84:H84)","v":0},null,null,"REDANGE/ATTERT",72,0]
[null,null,"- frais divers (3/520/62188xx) :",null,null,1,{"$f":"0.5*E85*F85*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"0.5*E85*F85*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(G85:H85)","v":0},null,null,"REISDORF",73,0]
[null,null,"Amortissement charroi et immobilier :",null,null,null,{"$f":"'Amortissement charroi et immob.'!O77","v":0},null,{"$f":"SUM(G86:H86)","v":0},null,null,"REMICH",74,0]
[null,null,{"$f":"CONCATENATE(\"Total des charges hors amortissement des infrastructures et taxe de rejet \",IF(K1=1,CONCATENATE(\"(année de référence \",J5,\") :\"),CONCATENATE(\"(données prévisionnelles \",J7,\") :\")))","v":"Total des charges hors amortissement des infrastructures et taxe de rejet (données prévisionnelles 2024) :"},null,null,null,{"$f":"SUM(G66:G86)","v":0},{"$f":"SUM(H66:H85)","v":0},{"$f":"SUM(I66:I86)","v":0},null,null,"ROESER",75,0]
[null,null,null,null,null,null,null,null,null,null,null,"ROSPORT-MOMPACH",76,0]
[null,null,"Clef de répartition des charges de fonctionnement et d'exploitation : ","Amort. infrastruct. \n(€/an)","Ratio\n(%)",null,null,null,null,null,null,"RUMELANGE",77,1]
[null,null,null,null,null,null,null,null,null,null,null,"SAEUL",78,0]
[null,null,"Charges d'amortissement totales des infrastructures AIDE :",{"$f":"'Amortissement infrastructures'!P307","v":0},1,null,null,null,null,null,null,"SANDWEILER",79,0]
[null,null,"Charges d'amortissement non opposables AIDE :",{"$f":"-'Amortissement infrastructures'!R307","v":0},{"$f":"D92/D91","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"SANEM",80,0]
[null,null,"Charges d'amortissement imputables :",{"$f":"D91+D92","v":0},{"$f":"D93/D91","v":{"$error":"#DIV/0!"}},null,{"$f":"G87*E93","v":{"$error":"#DIV/0!"}},{"$f":"H87*E93","v":{"$error":"#DIV/0!"}},{"$f":"I87*E93","v":{"$error":"#DIV/0!"}},null,null,"SCHENGEN",81,0]
[null,null,"Charges d'amortissement réduites AIDE :",null,null,null,{"$f":"D93/2","v":0},null,{"$f":"G94","v":0},null,null,"SCHIEREN",82,0]
[null,null,"Charges taxe de rejet des eaux résiduaires AIDE :",null,null,null,null,{"$f":"(D26-D29)*0.11","v":0},{"$f":"H95","v":0},null,null,"SCHIFFLANGE",83,1]
[null,null,"Charges imputables de fonctionnement, de maintenance et d'exploitation ………………………………………...",null,{"$f":"CONCATENATE(IF(M1=1,CONCATENATE(\"(année de référence \",J5,\") :\"),CONCATENATE(\"(données prévisionnelles \",J7,\") :\")))","v":"(année de référence 2022) :"},null,{"$f":"SUM(G93:G95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H93:H95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I93:I95)","v":{"$error":"#DIV/0!"}},null,null,"SCHUTTRANGE",84,0]
[null,null,null,null,null,null,null,null,null,null,null,"STADTBREDIMUS",85,0]
[null,"2.2.","Charges de l'évacuation et de la dépollution des eaux usées de la commune effectuées par des entités tierces (infrastructures syndicales)",null,null,null,null,null,null,null,null,"STEINFORT",86,0]
[null,null,"Budget ou compte ordinaire de l'année de référence",null,null,null,null,null,null,null,null,"STEINSEL",87,0]
[null,null,"Evacuation/dépollution suivant factures à partir de NOTA BENE :",null,null,null,"Amort. infrastruct.\n(€/an TTC)","Frais de fonct.\n(€/an TTC)","Coûts totaux\n(€/an TTC)","Remarques",null,"STRASSEN",88,0]
[null,null,"- syndicats (art. 3/520/648211/S) :",null,null,null,null,null,null,null,null,"TANDEL",89,0]
[null,null,{"$f":"IF(C48=\"\",\"\",C48)","v":""},null,null,null,null,null,{"$f":"(G102+H102)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,null,"TROISVIERGES",90,0]
[null,null,{"$f":"IF(C49=\"\",\"\",C49)","v":""},null,null,null,null,null,{"$f":"(G103+H103)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,null,"USELDANGE",91,0]
[null,null,"- communes (art. 3/520/648211/C) :",null,null,null,null,null,null,null,null,"VALLEE DE L'ERNZ",92,0]
[null,null,{"$f":"IF(C51=\"\",\"\",C51)","v":""},null,null,null,null,null,{"$f":"(G105+H105)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,null,"VIANDEN",93,0]
[null,null,{"$f":"IF(C52=\"\",\"\",C52)","v":""},null,null,null,null,null,{"$f":"(G106+H106)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},null,null,"VICHTEN",94,0]
[null,null,null,null,null,null,{"$f":"SUM(G102:G106)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(H102:H106)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0},{"$f":"SUM(I102:I106)","v":0},null,null,"WALDBILLIG",96,0]
[null,null,null,null,null,null,null,null,null,null,null,"WALFERDANGE",98,0]
[null,null,"Coûts imputables des services liées à l'évacuation et à la dépollution des eaux en €/an ……………………...",null,{"$f":"CONCATENATE(IF(M1=1,CONCATENATE(\"(année de référence \",J5,\") :\"),CONCATENATE(\"(données prévisionnelles \",J7,\") :\")))","v":"(année de référence 2022) :"},null,{"$f":"G96+(I102+I103)*0.65+(I105+I106)*0.75","v":{"$error":"#DIV/0!"}},{"$f":"H96+(I102+I103)*0.35+(I105+I106)*0.25","v":{"$error":"#DIV/0!"}},{"$f":"I96+I107","v":{"$error":"#DIV/0!"}},null,null,"WEILER-LA-TOUR",99,0]
[null,null,null,null,null,null,null,null,null,null,null,"WEISWAMPACH",100,0]
[null,null,"Coût complet des services liées à l'évacuation et à la dépollution des eaux en €/an …………………………...",null,{"$f":"CONCATENATE(IF(M1=1,CONCATENATE(\"(année de référence \",J5,\") :\"),CONCATENATE(\"(données prévisionnelles \",J7,\") :\")))","v":"(année de référence 2022) :"},null,null,null,{"$f":"I109-D92+(D93-G94)-I87*E92","v":{"$error":"#DIV/0!"}},null,null,"WILTZ",101,0]
[null,null,null,null,null,null,null,null,null,null,null,"WINCRANGE",102,0]
[null,null,null,null,null,null,null,null,null,null,null,"WINSELER",103,0]
[null,"3.",{"$f":"CONCATENATE(\"Recettes relatives à l'évacuation et à la dépollution des eaux résiduaires \",IF(M1=1,CONCATENATE(\"(année de référence \",J5,\")\"),CONCATENATE(\"(données prévisionnelles \",J7,\")\")))","v":"Recettes relatives à l'évacuation et à la dépollution des eaux résiduaires (année de référence 2022)"},null,null,null,null,null,null,null,null,"WORMELDANGE",104,0]
[null,null,"Budget ou compte ordinaire(articles 7011)"]
[null,"3.1.","Evacuation/dépollution des eaux usées provenant d'une entité externe AIDE",null,"Recettes fixes\n(€/an)","Recettes variables\n(€/an)","Total des recettes\n(€/an)","Remarques",null,null,null,"Tableau des EH moyens annuels"]
[]
[null,null,"- syndicats :"]
[null,null,null,null,null,null,{"$f":"(E119+F119)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,null,null,null,null,{"$f":"(E120+F120)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"- communes :"]
[null,null,null,null,null,null,{"$f":"(E122+F122)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,null,null,null,null,{"$f":"(E123+F123)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"Total des recettes pour évacuation/dépollution des eaux usées provenant d'une entité externe (€/an) :",null,{"$f":"SUM(E119:E123)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(F119:F123)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(G119:G123)","v":0}]
[null,"3.2.","Evacuation/dépollution d'eaux usées générées par les abonnées de la commune"]
[null,null,"- secteur des ménages :",null,null,null,{"$f":"(E126+F126)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"- secteur industriel :",null,null,null,{"$f":"(E127+F127)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"- secteur agricole :",null,null,null,{"$f":"(E128+F128)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"- secteur HORESCA :",null,null,null,{"$f":"(E129+F129)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"Total des recettes pour évacuation/dépollution des eaux usées générées par les abonnées internes (€/an) :",null,{"$f":"SUM(E126:E129)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(F126:F129)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(G126:G129)","v":0}]
[null,"3.3.","Autres recettes"]
[null,null,null,null,null,null,{"$f":"(E132+F132)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,null,null,null,null,{"$f":"(E133+F133)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,null,null,null,null,{"$f":"(E134+F134)*IF($M$1=2,(1+$D$13)^(J7-J5),1)","v":0}]
[null,null,"Total autres recettes (€/an) :",null,{"$f":"SUM(E132:E134)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(F132:F134)*IF($M$1=2,(1+D13)^(J7-J5),1)","v":0},{"$f":"SUM(G132:G134)","v":0}]
[null,null,{"$f":"CONCATENATE(\"Total des recettes en €/an \",IF(M1=1,CONCATENATE(\"(année de référence \",J5,\") :\"),CONCATENATE(\"(données prévisionnelles \",J7,\") :\")))","v":"Total des recettes en €/an (année de référence 2022) :"},null,{"$f":"E130+E124+E135","v":0},{"$f":"F130+F124+F135","v":0},{"$f":"G130+G124+G135","v":0}]
[]
[]
[null,"4.",{"$f":"CONCATENATE(\"Résultat comptable pour l'évacuation et la dépollution des eaux résiduaires collectées par l'infrastructure communale \",IF(M1=1,CONCATENATE(\"(année de référence \",J5,\")\"),CONCATENATE(\"(données prévisionnelles \",J7,\")\")))","v":"Résultat comptable pour l'évacuation et la dépollution des eaux résiduaires collectées par l'infrastructure communale (année de référence 2022)"}]
[]
[null,"4.1.","Calcul du coût imputable de l'eau usée"]
[null,null,null,null,"Valeurs fixes","Valeurs variables","Valeurs totales"]
[null,null,"Coûts imputables des services liées à l'évacuation et à la dépollution des eaux résiduaires (€/an) NOTA BENE :",null,{"$f":"G109-E135","v":{"$error":"#DIV/0!"}},{"$f":"H109-F135","v":{"$error":"#DIV/0!"}},{"$f":"I109-G135","v":{"$error":"#DIV/0!"}}]
[null,null,"Total des charges polluantes moyennes annuelles collectées par l'infrastructure communale (EHm) :",null,{"$f":"F37","v":0}]
[null,null,"Coût fixe par EH moyen annuel (€/EHm/an) :",null,{"$f":"E143/E144","v":{"$error":"#DIV/0!"}}]
[null,null,"Quantité totale d'eau déversée dans le réseau public d'évacuation/dépollution (m3/an) :",null,null,{"$f":"D26","v":0},{"$f":"F146","v":0}]
[null,null,"Coût variable par m3 d'eau usée (€/m3) :",null,null,{"$f":"F143/F146","v":{"$error":"#DIV/0!"}}]
[null,null,"Coût global par m3 d'eau usée (€/m3) AIDE :",null,null,null,{"$f":"G143/G146","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"5.",{"$f":"CONCATENATE(\"Simulation pour l'application de prix fixes et variables relatifs à l'évacuation et la dépollution des eaux résiduaires pour l'année \",J7)","v":"Simulation pour l'application de prix fixes et variables relatifs à l'évacuation et la dépollution des eaux résiduaires pour l'année 2024"}]
[null,null,{"$f":"CONCATENATE(\"CHOISIR L'OPTION « DONNEES PREVISIONNELLES \",J7,\" » DANS LE BANDEAU DE TITRE\")","v":"CHOISIR L'OPTION « DONNEES PREVISIONNELLES 2024 » 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 (élimination partielle de l'amortissement des infrastructures d'évacuation moyennant la prise en compte de la moitié de l'amortissement local renseigné) 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 usée :",{"$f":"IF(G148>M5,M5,G148)","v":{"$error":"#DIV/0!"}},null,{"$f":"F143/G143","v":{"$error":"#DIV/0!"}}]
[null,null,"- coût global indexé par EHm :",{"$f":"IF(G148>M5,(M5*G146)/E144,G143/E144)","v":{"$error":"#DIV/0!"}},null,{"$f":"E143/G143","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Partage fixe/variable non corrigé :","Fixe corresp.","Var. > x €","Var. > x €","Var. standard.","% variable"]
[null,null,"- secteur des ménages :",{"$f":"(1-E163/$D$159)*$D$160","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$170,IF($G$170>$D$159,$D$159,$G$170),G163)","v":{"$error":"#DIV/0!"}},{"$f":"D159*H163/100","v":{"$error":"#DIV/0!"}},80]
[null,null,"- secteur industriel :",{"$f":"(1-E164/$D$159)*$D$160","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))/IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<0.5,0.01,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<1.2,0.02,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<2.5,0.05,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<5,0.1,0.2)))),0)*IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<0.5,0.01,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<1.2,0.02,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<2.5,0.05,IF(F164/1/10^(ROUNDDOWN((LOG(F164/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F164/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G164<$G$170,IF($G$170>$D$159,$D$159,$G$170),G164)","v":{"$error":"#DIV/0!"}},{"$f":"D159*H164/100","v":{"$error":"#DIV/0!"}},30]
[null,null,"- secteur agricole :",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"D159*H165/100","v":{"$error":"#DIV/0!"}},40]
[null,null,"- secteur HORECA :",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"D159*H166/100","v":{"$error":"#DIV/0!"}},55]
[]
[null,null,"Tarification rééquilibrée NOTA BENE :","Part fixe\n(€/EHm/an hTVA)","Part variable\n(€/m3 hTVA)",null,"Prix plancher\n(€/m3) AIDE"]
[]
[null,null,"- secteur des ménages :",{"$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 industriel :",{"$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!"}},{"$f":"E164","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur agricole :",{"$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,null,"- secteur HORECA :",{"$f":"ROUND(ROUND(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))/IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<0.5,0.01,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<1.2,0.02,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<2.5,0.05,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<5,0.1,0.2)))),0)*IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<0.5,0.01,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<1.2,0.02,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<2.5,0.05,IF(D166/1/10^(ROUNDDOWN((LOG(D166/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D166/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(€/EHm/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(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 industriel :",{"$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!"}},{"$f":"E186","v":{"$error":"#DIV/0!"}}]
[null,null,"- secteur agricole :",{"$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,"- secteur HORECA :",{"$f":"ROUND(ROUND(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))/IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<0.5,0.01,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<1.2,0.02,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<2.5,0.05,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<5,0.1,0.2)))),0)*IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<0.5,0.01,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<1.2,0.02,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<2.5,0.05,IF(D188/1/10^(ROUNDDOWN((LOG(D188/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(D188/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,1]
[]
[null,null,"Part fixe correspondante non corrigée (€/EHm/an) :","Fixe corresp.","Var. arrondie","Var. standard.","% variable"]
[null,null,"- secteur des ménages :",{"$f":"(1-E185/$D$159)*$D$160","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":"$D$159*G185/100","v":{"$error":"#DIV/0!"}},80]
[null,null,"- secteur industriel :",{"$f":"(1-E186/$D$159)*$D$160","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(ROUND(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))/IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<0.5,0.01,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<1.2,0.02,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<2.5,0.05,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<5,0.1,0.2)))),0)*IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<0.5,0.01,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<1.2,0.02,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<2.5,0.05,IF(F186/1/10^(ROUNDDOWN((LOG(F186/1)),0))<5,0.1,0.2))))*10^(ROUNDDOWN((LOG(F186/1)),0)),2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(($D$159*G186/100)>F187,F187,$D$159*G186/100)","v":{"$error":"#DIV/0!"}},35]
[null,null,"- secteur agricole :",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$D$159*G187/100","v":{"$error":"#DIV/0!"}},40]
[null,null,"- secteur HORECA :",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},55]

{"sheet":"Amortissement infrastructures","index":1,"n_rows":307,"n_cols":22,"rows_kept":307,"cut":false,"hidden":false,"merged":[[16,2,16,9],[20,8,20,9],[20,12,20,14],[33,2,33,4],[20,10,20,11],[5,2,5,9],[35,8,35,9],[35,10,35,11],[31,10,31,11],[33,10,33,11],[31,12,31,14],[35,2,35,4],[43,8,43,9],[45,10,45,11],[43,10,43,11],[47,17,47,18],[53,17,53,18],[0,0,3,0],[1,18,2,18],[1,12,2,17],[1,1,2,11],[35,17,35,18],[31,17,31,18],[31,8,31,9],[31,2,31,4],[20,15,20,16],[20,2,20,4],[7,2,7,9],[7,10,7,11],[9,2,9,16],[31,15,31,16],[13,2,13,16],[43,12,43,14],[35,12,35,14],[18,15,18,16],[18,10,18,11],[105,2,105,4],[105,8,105,9],[74,2,74,4],[57,12,57,14],[47,12,47,14],[7,17,7,18],[43,15,43,16],[9,17,9,18],[18,17,18,18],[11,2,11,16],[57,17,57,18],[47,15,47,16],[20,17,20,18],[35,15,35,16],[13,17,13,18],[11,17,11,18],[18,2,18,4],[57,15,57,16],[53,15,53,16],[43,17,43,18],[55,2,55,5],[89,2,89,4],[43,2,43,4],[47,8,47,9],[55,10,55,11],[53,8,53,9],[47,10,47,11],[85,10,85,11],[57,2,57,4],[57,8,57,9],[64,12,64,14],[45,2,45,5],[85,8,85,9],[53,12,53,14],[72,10,72,11],[64,8,64,9],[57,10,57,11],[53,10,53,11],[47,2,47,4],[53,2,53,4],[145,8,145,9],[143,2,143,4],[143,10,143,11],[145,10,145,11],[145,2,145,4],[155,10,155,11],[151,8,151,9],[151,10,151,11],[120,12,120,14],[153,10,153,11],[120,10,120,11],[145,12,145,14],[155,8,155,9],[120,8,120,9],[130,10,130,11],[123,2,123,14],[128,2,128,4],[128,10,128,11],[244,17,244,18],[249,17,249,18],[239,2,239,5],[238,2,238,5],[201,17,201,18],[216,17,216,18],[249,15,249,16],[216,10,216,11],[201,12,201,14],[201,10,201,11],[212,17,212,18],[242,17,242,18],[231,17,231,18],[212,12,212,14],[227,17,227,18],[227,12,227,14],[227,15,227,16],[231,15,231,16],[242,12,242,14],[244,15,244,16],[216,12,216,14],[244,2,244,14],[238,6,238,7],[231,10,231,11],[287,17,287,18],[262,15,262,16],[287,10,287,11],[277,5,277,6],[287,2,287,5],[270,2,270,4],[271,2,271,4],[272,5,272,6],[269,12,269,14],[279,2,279,4],[283,2,283,5],[280,5,280,6],[287,8,287,9],[280,17,280,18],[280,15,280,16],[287,15,287,16],[285,15,285,16],[287,12,287,14],[280,10,280,11],[279,5,279,6],[276,2,276,4],[272,2,272,4],[269,15,269,16],[269,10,269,11],[251,17,251,18],[267,17,267,18],[269,17,269,18],[267,15,267,16],[262,17,262,18],[269,8,269,9],[278,5,278,6],[276,5,276,6],[275,5,275,6],[262,12,262,14],[262,10,262,11],[273,5,273,6],[271,5,271,6],[251,15,251,16],[251,8,251,9],[253,6,253,7],[260,2,260,5],[270,5,270,6],[269,2,269,4],[261,2,261,5],[273,2,273,4],[278,2,278,4],[277,2,277,4],[275,2,275,4],[227,10,227,11],[229,10,229,11],[231,12,231,14],[242,15,242,16],[179,2,179,14],[190,6,190,7],[190,2,190,5],[197,10,197,11],[197,8,197,9],[194,6,194,7],[187,6,187,7],[188,6,188,7],[192,2,192,5],[192,6,192,7],[242,8,242,9],[242,10,242,11],[234,6,234,7],[233,2,233,5],[235,6,235,7],[227,2,227,5],[231,2,231,5],[229,2,229,9],[234,2,234,5],[233,6,233,7],[174,10,174,11],[231,6,231,7],[172,10,172,11],[163,10,163,11],[165,10,165,11],[161,10,161,11],[151,12,151,14],[155,12,155,14],[74,17,74,18],[116,17,116,18],[123,17,123,18],[172,15,172,16],[165,15,165,16],[145,17,145,18],[161,17,161,18],[151,17,151,18],[155,17,155,18],[151,15,151,16],[161,15,161,16],[145,15,145,16],[128,15,128,16],[123,15,123,16],[130,15,130,16],[120,15,120,16],[155,15,155,16],[109,12,109,14],[72,17,72,18],[64,17,64,18],[67,17,67,18],[74,15,74,16],[95,17,95,18],[105,15,105,16],[109,17,109,18],[105,17,105,18],[99,17,99,18],[99,15,99,16],[67,15,67,16],[85,15,85,16],[95,15,95,16],[89,17,89,18],[64,15,64,16],[72,15,72,16],[85,17,85,18],[109,15,109,16],[89,15,89,16],[116,15,116,16],[141,15,141,16],[89,12,89,14],[267,10,267,11],[251,10,251,11],[252,6,252,7],[254,6,254,7],[120,17,120,18],[128,17,128,18],[141,17,141,18],[130,17,130,18],[179,17,179,18],[165,17,165,18],[141,10,141,11],[130,8,130,9],[141,8,141,9],[130,12,130,14],[141,12,141,14],[176,15,176,16],[227,8,227,9],[186,10,186,11],[186,8,186,9],[201,15,201,16],[176,12,176,14],[212,15,212,16],[216,15,216,16],[161,12,161,14],[197,17,197,18],[186,17,186,18],[186,15,186,16],[197,15,197,16],[197,12,197,14],[172,17,172,18],[176,17,176,18],[184,17,184,18],[179,15,179,16],[184,15,184,16],[172,12,172,14],[165,12,165,14],[186,12,186,14],[306,17,306,18],[303,17,303,18],[305,17,305,18],[305,15,305,16],[304,17,304,18],[249,10,249,11],[305,2,305,14],[303,15,303,16],[274,5,274,6],[274,2,274,4],[262,8,262,9],[296,2,296,10],[302,17,302,18],[288,2,288,5],[290,6,290,7],[293,17,293,18],[300,17,300,18],[293,10,293,11],[252,2,252,5],[253,2,253,5],[251,12,251,14],[285,17,285,18],[306,2,306,14],[303,2,303,14],[306,15,306,16],[304,2,304,14],[304,15,304,16],[293,12,293,14],[300,15,300,16],[298,2,298,9],[302,2,302,14],[302,15,302,16],[293,15,293,16],[293,2,293,9],[298,10,298,14],[291,2,291,5],[289,2,289,5],[292,6,292,7],[290,2,290,5],[280,12,280,14],[280,2,280,4],[292,2,292,5],[291,6,291,7],[288,6,288,7],[287,6,287,7],[289,6,289,7],[254,2,254,5],[262,2,262,5],[269,5,269,6],[251,2,251,5],[251,6,251,7],[236,2,236,5],[241,2,241,5],[237,2,237,5],[240,2,240,5],[240,6,240,7],[242,6,242,7],[241,6,241,7],[242,2,242,5],[239,6,239,7],[237,6,237,7],[236,6,236,7],[260,6,260,7],[261,6,261,7],[262,6,262,7],[247,2,247,7],[255,2,255,5],[255,6,255,7],[256,2,256,5],[256,6,256,7],[235,2,235,5],[232,2,232,5],[221,2,221,5],[220,2,220,5],[222,6,222,7],[221,6,221,7],[220,6,220,7],[224,2,224,5],[223,2,223,5],[222,2,222,5],[226,2,226,5],[223,6,223,7],[224,6,224,7],[225,2,225,5],[225,6,225,7],[226,6,226,7],[227,6,227,7],[232,6,232,7],[231,8,231,9],[218,2,218,5],[216,2,216,5],[212,2,212,5],[195,6,195,7],[191,2,191,5],[199,2,199,9],[208,2,208,5],[218,6,218,7],[219,6,219,7],[202,2,202,5],[201,2,201,5],[196,6,196,7],[219,2,219,5],[211,2,211,5],[214,2,214,9],[216,8,216,9],[212,8,212,9],[217,6,217,7],[210,6,210,7],[211,6,211,7],[195,2,195,5],[204,2,204,5],[203,6,203,7],[177,2,177,7],[210,2,210,5],[209,6,209,7],[216,6,216,7],[212,6,212,7],[196,2,196,5],[199,10,199,11],[208,6,208,7],[206,6,206,7],[214,10,214,11],[212,10,212,11],[201,8,201,9],[203,2,203,5],[201,6,201,7],[197,6,197,7],[197,2,197,5],[207,2,207,5],[206,2,206,5],[204,6,204,7],[202,6,202,7],[205,6,205,7],[205,2,205,5],[118,2,118,8],[217,2,217,5],[209,2,209,5],[176,8,176,9],[174,2,174,8],[176,2,176,7],[176,10,176,11],[172,8,172,9],[165,2,165,4],[161,2,161,4],[184,10,184,11],[207,6,207,7],[186,2,186,5],[189,6,189,7],[188,2,188,5],[194,2,194,5],[191,6,191,7],[193,2,193,5],[193,6,193,7],[187,2,187,5],[186,6,186,7],[189,2,189,5],[182,2,182,5],[184,2,184,9],[89,8,89,9],[74,8,74,9],[67,2,67,14],[74,12,74,14],[64,2,64,4],[89,10,89,11],[70,2,70,14],[74,10,74,11],[109,2,109,4],[109,8,109,9],[105,12,105,14],[97,10,97,11],[95,10,95,11],[109,10,109,11],[105,10,105,11],[107,10,107,11],[107,2,107,5],[72,2,72,4],[85,12,85,14],[64,10,64,11],[87,2,87,4],[99,2,99,4],[99,12,99,14],[99,10,99,11],[257,2,257,5],[257,6,257,7],[258,2,258,5],[258,6,258,7],[259,2,259,5],[259,6,259,7],[95,12,95,14],[116,12,116,14],[87,10,87,11],[116,10,116,11],[161,8,161,9],[165,8,165,9],[163,2,163,5],[155,2,155,4],[153,2,153,5],[95,8,95,9],[99,8,99,9],[97,2,97,5],[116,8,116,9],[118,10,118,11],[120,2,120,7],[126,2,126,14],[130,2,130,4],[121,2,121,7]]}
["18 / 04 / 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone urbaine",{"$f":"'Coût de l''eau usée'!M3","v":0}]
[null,"Amortissement des infrastructures \nd'évacuation et de dépollution",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$M$1=1,'Coût de l''eau usée'!$G$5,'Coût de l''eau usée'!$H$7)","v":"Année de référence (comptes) :"},null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$M$1=1,'Coût de l''eau usée'!$J$5,'Coût de l''eau usée'!$J$7)","v":2022},null,"Zone rurale",{"$f":"'Coût de l''eau usée'!M4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capac. épuratoire autonome",{"$f":"'Coût de l''eau usée'!E55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capac. épuratoire utilisée",{"$f":"'Coût de l''eau usée'!H45","v":0}]
[]
[null,"0.","Taux à base du calcul de l'amortissement",null,null,null,null,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 usée'!$J$5,\" (donnée STATEC) :\")","v":"Indice moyen annuel des prix de la construction de l'année 2022 (donnée STATEC) :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1037.72]
[]
[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,null,null,null,{"$f":"'Coût de l''eau usée'!D13","v":2.8000000000000001E-2}]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel estimé des prix de la construction de l'année \",'Coût de l''eau usée'!$J$7,\" :\")","v":"Indice moyen annuel estimé des prix de la construction de l'année 2024 :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R8*(1+R10)^('Coût de l''eau usée'!J7-'Coût de l''eau usée'!J5)","v":1096.6458924799999}]
[]
[null,null,"Taux de TVA appliqué aux travaux d'infrastructures d'évacuation et de dépollution :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17]
[]
[]
[null,"1.","Collecteurs posés en zone verte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"1.1.","Béton armé",null,null,"Eau usée","Eau mixte","Eau pluviale",null,null,"Durée de vie utile :",null,75,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",300,"mm",0,0,0,"x",{"$f":"(110+D22*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":578.54513380375454},"=",{"$f":"(F22+G22+H22)*J22","v":0},"x",{"$f":"ROUND((1/$M$19*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L22*N22/100","v":0},"=",{"$f":"IF((G22*J22-G22*$J$22+H22*J22)*N22/100<0,0,(G22*J22-G22*$J$22+H22*J22)*N22/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(110+D23*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":708.07016375981891},"=",{"$f":"(F23+G23+H23)*J23","v":0},"x",{"$f":"ROUND((1/$M$19*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L23*N23/100","v":0},"=",{"$f":"IF((G23*J23-G23*$J$22+H23*J23)*N23/100<0,0,(G23*J23-G23*$J$22+H23*J23)*N23/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(110+D24*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":837.59519371588351},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",{"$f":"(110+D25*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":967.12022367194788},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",{"$f":"(110+D26*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1096.6452536280124},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",{"$f":"(110+D27*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1226.1702835840767},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",{"$f":"(110+D28*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1355.6953135401411},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",{"$f":"(110+D29*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1485.2203434962055},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",{"$f":"(110+D30*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1614.7453734522701},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",{"$f":"(110+D31*0.75)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1744.2704034083345},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F22:F31)","v":0},{"$f":"SUM(G22:G31)","v":0},{"$f":"SUM(H22:H31)","v":0},null,null,{"$f":"SUM(L22:L31)","v":0},null,null,null,null,{"$f":"SUM(Q22:Q31)","v":0},null,{"$f":"SUM(S22:S31)","v":0}]
[]
[null,"1.2.","Fonte ductile",null,null,null,null,null,null,null,"Durée de vie utile :",null,75,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","200","mm",0,0,0,"x",{"$f":"(120+D37*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":483.56011183597394},"=",{"$f":"(F37+G37+H37)*J37","v":0},"x",{"$f":"ROUND((1/$M$34*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L37*N37/100","v":0},"=",{"$f":"IF((G37*J37-G37*$J$22+H37*J37)*N37/100<0,0,(G37*J37-G37*$J$22+H37*J37)*N37/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(120+D38*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":552.64012781254155},"=",{"$f":"(F38+G38+H38)*J38","v":0},"x",{"$f":"ROUND((1/$M$34*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L38*N38/100","v":0},"=",{"$f":"IF((G38*J38-G38*$J$22+H38*J38)*N38/100<0,0,(G38*J38-G38*$J$22+H38*J38)*N38/100)","v":0}]
[null,null,null,"300 ","mm",0,0,0,"x",{"$f":"(120+D39*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":621.72014378910933},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"350 ","mm",0,0,0,"x",{"$f":"(120+D40*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":690.80015976567699},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(120+D41*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":759.88017574224477},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(120+D42*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":898.0402076953801},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","600","mm",0,0,0,"x",{"$f":"(120+D43*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1036.2002396485154},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F37:F43)","v":0},{"$f":"SUM(G37:G43)","v":0},{"$f":"SUM(H37:H43)","v":0},null,null,{"$f":"SUM(L37:L43)","v":0},null,null,null,null,{"$f":"SUM(Q37:Q43)","v":0},null,{"$f":"SUM(S37:S43)","v":0}]
[]
[null,"1.3.","PE",null,null,null,null,null,null,null,"Durée de vie utile :",null,75,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","225","mm",0,0,0,"x",{"$f":"(70+(D49-D49*0.18-0.03)*1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":439.46979163892956},"=",{"$f":"(F49+G49+H49)*J49","v":0},"x",{"$f":"ROUND((1/$M$46*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L49*N49/100","v":0},"=",{"$f":"IF((G49*J49-G49*$J$22+H49*J49)*N49/100<0,0,(G49*J49-G49*$J$22+H49*J49)*N49/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(70+(D50-D50*0.18-0.03)*1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":474.87329982692057},"=",{"$f":"(F50+G50+H50)*J50","v":0},"x",{"$f":"ROUND((1/$M$46*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L50*N50/100","v":0},"=",{"$f":"IF((G50*J50-G50*$J$22+H50*J50)*N50/100<0,0,(G50*J50-G50*$J$22+H50*J50)*N50/100)","v":0}]
[null,null,null,"280","mm",0,0,0,"x",{"$f":"(70+(D51-D51*0.18-0.03)*1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":517.35750965250963},"=",{"$f":"(F51+G51+H51)*J51","v":0},"x",{"$f":"ROUND((1/$M$46*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L51*N51/100","v":0},"=",{"$f":"IF((G51*J51-G51*$J$22+H51*J51)*N51/100<0,0,(G51*J51-G51*$J$22+H51*J51)*N51/100)","v":0}]
[null,null,null,"315","mm",0,0,0,"x",{"$f":"(70+(D52-D52*0.18-0.03)*1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":566.92242111569703},"=",{"$f":"(F52+G52+H52)*J52","v":0},"x",{"$f":"ROUND((1/$M$46*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L52*N52/100","v":0},"=",{"$f":"IF((G52*J52-G52*$J$22+H52*J52)*N52/100<0,0,(G52*J52-G52*$J$22+H52*J52)*N52/100)","v":0}]
[null,null,"≥","355","mm",0,0,0,"x",{"$f":"(70+(D53-D53*0.18-0.03)*1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":623.5680342164826},"=",{"$f":"(F53+G53+H53)*J53","v":0},"x",{"$f":"ROUND((1/$M$46*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L53*N53/100","v":0},"=",{"$f":"IF((G53*J53-G53*$J$22+H53*J53)*N53/100<0,0,(G53*J53-G53*$J$22+H53*J53)*N53/100)","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F49:F53)","v":0},{"$f":"SUM(G49:G53)","v":0},{"$f":"SUM(H49:H53)","v":0},null,null,{"$f":"SUM(L49:L53)","v":0},null,null,null,null,{"$f":"SUM(Q49:Q53)","v":0},null,{"$f":"SUM(S49:S53)","v":0}]
[]
[null,"1.4.","PEHD sous pression",null,null,null,null,null,null,null,"Durée de vie utile :",null,75,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,0,0,"x",{"$f":"(35+(D59-D59*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":162.36566955132471},"=",{"$f":"(F59+G59+H59)*J59","v":0},"x",{"$f":"ROUND((1/$M$56*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L59*N59/100","v":0},"=",{"$f":"IF((G59*J59-G59*$J$22+H59*J59)*N59/100<0,0,(G59*J59-G59*$J$22+H59*J59)*N59/100)","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(35+(D60-D60*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":185.02391479163896},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",{"$f":"(35+(D61-D61*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":202.01759872187461},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",{"$f":"(35+(D62-D62*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":241.66952789242441},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",{"$f":"(35+(D63-D63*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":264.32777313273868},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",{"$f":"(35+(D64-D64*0.18-0.03)*0.8)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":315.30882492344563},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F59:F64)","v":0},{"$f":"SUM(G59:G64)","v":0},{"$f":"SUM(H59:H64)","v":0},null,null,{"$f":"SUM(L59:L64)","v":0},null,null,null,null,{"$f":"SUM(Q59:Q64)","v":0},null,{"$f":"SUM(S59:S64)","v":0}]
[]
[]
[null,null,"TOTAL de l'amortissement annuel des collecteurs posés en zone verte en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P32+P65+P54+P44","v":0},null,{"$f":"R32+R65+R54+R44","v":0}]
[]
[]
[null,"2.","Collecteurs posés en zone rurale à faible densité de construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"2.1.","Béton armé",null,null,"Eau usée","Eau mixte","Eau pluviale",null,null,"Durée de vie utile :",null,60,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",300,"mm",0,0,0,"x",{"$f":"(160+D76*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":716.70516575688987},"=",{"$f":"(F76+G76+H76)*J76*$V$2","v":0},"x",{"$f":"ROUND((1/$M$73*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L76*N76/100","v":0},"=",{"$f":"IF((G76*J76-G76*$J$76+H76*J76)*N76/100<0,0,(G76*J76-G76*$J$76+H76*J76)*N76/100)*$V$2","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(160+D77*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":863.50019970709627},"=",{"$f":"(F77+G77+H77)*J77*$V$2","v":0},"x",{"$f":"ROUND((1/$M$73*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L77*N77/100","v":0},"=",0]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(160+D78*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1010.2952336573026},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",{"$f":"(160+D79*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1157.0902676075091},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",{"$f":"(160+D80*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1303.8853015577154},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",{"$f":"(160+D81*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1450.6803355079217},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",{"$f":"(160+D82*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1597.4753694581282},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",{"$f":"(160+D83*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1744.2704034083345},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",{"$f":"(160+D84*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1891.0654373585407},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",{"$f":"(160+D85*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":2037.8604713087473},"=",{"$f":"(F85+G85+H85)*J85*$V$2","v":0},"x",1.65,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F76:F85)*$V$2","v":0},{"$f":"SUM(G76:G85)*$V$2","v":0},{"$f":"SUM(H76:H85)*$V$2","v":0},null,null,{"$f":"SUM(L76:L85)","v":0},null,null,null,null,{"$f":"SUM(Q76:Q85)","v":0},null,{"$f":"SUM(S76:S85)","v":0}]
[]
[null,"2.2.","Fonte ductile",null,null,null,null,null,null,null,"Durée de vie utile :",null,60,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","200","mm",0,0,0,"x",{"$f":"(170+D91*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":604.45013979496741},"=",{"$f":"(F91+G91+H91)*J91*$V$2","v":0},"x",{"$f":"ROUND((1/$M$88*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L91*N91/100","v":0},"=",{"$f":"IF((G91*J91-G91*$J$76+H91*J91)*N91/100<0,0,(G91*J91-G91*$J$76+H91*J91)*N91/100)*$V$2","v":0}]
[null,null,null,"300","mm",0,0,0,"x",{"$f":"(170+D92*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":759.88017574224477},"=",{"$f":"(F92+G92+H92)*J92*$V$2","v":0},"x",{"$f":"ROUND((1/$M$88*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L92*N92/100","v":0},"=",{"$f":"IF((G92*J92-G92*$J$76+H92*J92)*N92/100<0,0,(G92*J92-G92*$J$76+H92*J92)*N92/100)*$V$2","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(170+D93*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":915.31021168952202},"=",{"$f":"(F93+G93+H93)*J93*$V$2","v":0},"x",{"$f":"ROUND((1/$M$88*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L93*N93/100","v":0},"=",{"$f":"IF((G93*J93-G93*$J$76+H93*J93)*N93/100<0,0,(G93*J93-G93*$J$76+H93*J93)*N93/100)*$V$2","v":0}]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(170+D94*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1070.7402476367993},"=",{"$f":"(F94+G94+H94)*J94*$V$2","v":0},"x",{"$f":"ROUND((1/$M$88*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L94*N94/100","v":0},"=",{"$f":"IF((G94*J94-G94*$J$76+H94*J94)*N94/100<0,0,(G94*J94-G94*$J$76+H94*J94)*N94/100)*$V$2","v":0}]
[null,null,"≥","600","mm",0,0,0,"x",{"$f":"(170+D95*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1226.1702835840767},"=",{"$f":"(F95+G95+H95)*J95*$V$2","v":0},"x",{"$f":"ROUND((1/$M$88*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L95*N95/100","v":0},"=",{"$f":"IF((G95*J95-G95*$J$76+H95*J95)*N95/100<0,0,(G95*J95-G95*$J$76+H95*J95)*N95/100)*$V$2","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F91:F95)*$V$2","v":0},{"$f":"SUM(G91:G95)*$V$2","v":0},{"$f":"SUM(H91:H95)*$V$2","v":0},null,null,{"$f":"SUM(L91:L95)","v":0},null,null,null,null,{"$f":"SUM(Q91:Q95)","v":0},null,{"$f":"SUM(S91:S95)","v":0}]
[]
[null,"2.3.","PE",null,null,null,null,null,null,null,"Durée de vie utile :",null,60,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","225","mm",0,0,0,"x",{"$f":"(120+(D101-D101*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":557.67778797763287},"=",{"$f":"(F101+G101+H101)*J101*$V$2","v":0},"x",{"$f":"ROUND((1/$M$98*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L101*N101/100","v":0},"=",{"$f":"IF((G101*J101-G101*$J$76+H101*J101)*N101/100<0,0,(G101*J101-G101*$J$76+H101*J101)*N101/100)*$V$2","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(120+(D102-D102*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":596.62164698442291},"=",{"$f":"(F102+G102+H102)*J102*$V$2","v":0},"x",{"$f":"ROUND((1/$M$98*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L102*N102/100","v":0},"=",{"$f":"IF((G102*J102-G102*$J$76+H102*J102)*N102/100<0,0,(G102*J102-G102*$J$76+H102*J102)*N102/100)*$V$2","v":0}]
[null,null,null,"280","mm",0,0,0,"x",{"$f":"(120+(D103-D103*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":643.354277792571},"=",{"$f":"(F103+G103+H103)*J103*$V$2","v":0},"x",{"$f":"ROUND((1/$M$98*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L103*N103/100","v":0},"=",{"$f":"IF((G103*J103-G103*$J$76+H103*J103)*N103/100<0,0,(G103*J103-G103*$J$76+H103*J103)*N103/100)*$V$2","v":0}]
[null,null,null,"315","mm",0,0,0,"x",{"$f":"(120+(D104-D104*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":697.87568040207714},"=",{"$f":"(F104+G104+H104)*J104*$V$2","v":0},"x",{"$f":"ROUND((1/$M$98*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L104*N104/100","v":0},"=",{"$f":"IF((G104*J104-G104*$J$76+H104*J104)*N104/100<0,0,(G104*J104-G104*$J$76+H104*J104)*N104/100)*$V$2","v":0}]
[null,null,"≥","355","mm",0,0,0,"x",{"$f":"(120+(D105-D105*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":760.18585481294122},"=",{"$f":"(F105+G105+H105)*J105*$V$2","v":0},"x",{"$f":"ROUND((1/$M$98*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L105*N105/100","v":0},"=",{"$f":"IF((G105*J105-G105*$J$76+H105*J105)*N105/100<0,0,(G105*J105-G105*$J$76+H105*J105)*N105/100)*$V$2","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F101:F105)*$V$2","v":0},{"$f":"SUM(G101:G105)*$V$2","v":0},{"$f":"SUM(H101:H105)*$V$2","v":0},null,null,{"$f":"SUM(L101:L105)","v":0},null,null,null,null,{"$f":"SUM(Q101:Q105)","v":0},null,{"$f":"SUM(S101:S105)","v":0}]
[]
[null,"2.4.","PEHD sous pression",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,0,0,"x",{"$f":"(95+(D111-D111*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":278.72577546265484},"=",{"$f":"(F111+G111+H111)*J111*$V$2","v":0},"x",{"$f":"ROUND((1/$M$108*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L111*N111/100","v":0},"=",{"$f":"IF((G111*J111-G111*$J$76+H111*J111)*N111/100<0,0,(G111*J111-G111*$J$76+H111*J111)*N111/100)*$V$2","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(95+(D112-D112*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":304.21630135800831},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",{"$f":"(95+(D113-D113*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":323.33419577952338},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",{"$f":"(95+(D114-D114*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":367.94261609639199},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",{"$f":"(95+(D115-D115*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":393.43314199174546},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",{"$f":"(95+(D116-D116*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":450.7868252562908},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F111:F116)*$V$2","v":0},{"$f":"SUM(G111:G116)*$V$2","v":0},{"$f":"SUM(H111:H116)*$V$2","v":0},null,null,{"$f":"SUM(L111:L116)","v":0},null,null,null,null,{"$f":"SUM(Q111:Q116)","v":0},null,{"$f":"SUM(S111:S116)","v":0}]
[]
[null,"2.5.","Branchements particuliers",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans",null,null,null,null,"Aide"]
[]
[null,null,"Nombre de branchements particuliers",null,null,null,null,null,"Valeur unitaire    (€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,{"$f":"'Coût de l''eau usée'!D33*V2","v":0},null,null,null,null,null,"x",{"$f":"ROUND((1800/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))/10,0)*10","v":3110},"=",{"$f":"C122*J122*$V$2","v":0},"x",{"$f":"ROUND((1/$M$119*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L122*N122/100","v":0},"=",{"$f":"0","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des collecteurs posés en zone rurale en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P86+P96+P106+P117+Q122","v":0},null,{"$f":"R86+R96+R106+R117+S122","v":0}]
[]
[]
[null,"3.","Collecteurs posés en zone urbaine à forte densité de construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"3.1.","Béton armé",null,null,"Eau usée","Eau mixte","Eau pluviale",null,null,"Durée de vie utile :",null,60,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",300,"mm",0,0,0,"x",{"$f":"(280+D132*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":923.94521368659298},"=",{"$f":"(F132+G132+H132)*J132*$V$1","v":0},"x",{"$f":"ROUND((1/$M$129*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L132*N132/100","v":0},"=",{"$f":"IF((G132*J132-G132*$J$132+H132*J132)*N132/100<0,0,(G132*J132-G132*$J$132+H132*J132)*N132/100)*$V$1","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(280+D133*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1070.7402476367993},"=",{"$f":"(F133+G133+H133)*J133*$V$1","v":0},"x",{"$f":"ROUND((1/$M$129*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L133*N133/100","v":0},"=",0]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(280+D134*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1217.5352815870058},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",{"$f":"(280+D135*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1364.3303155372123},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",{"$f":"(280+D136*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1511.1253494874186},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",{"$f":"(280+D137*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1657.9203834376249},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",{"$f":"(280+D138*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1804.7154173878314},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",{"$f":"(280+D139*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1951.5104513380377},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",{"$f":"(280+D140*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":2098.3054852882442},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",{"$f":"(280+D141*0.85)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":2245.10051923845},"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F132:F141)*$V$1","v":0},{"$f":"SUM(G132:G141)*$V$1","v":0},{"$f":"SUM(H132:H141)*$V$1","v":0},null,null,{"$f":"SUM(L132:L141)","v":0},null,null,null,null,{"$f":"SUM(Q132:Q141)","v":0},null,{"$f":"SUM(S132:S141)","v":0}]
[]
[null,"3.2.","Fonte ductile",null,null,null,null,null,null,null,"Durée de vie utile :",null,60,"ans"]
[]
[null,null,"Diamètre nominal",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","200","mm",0,0,0,"x",{"$f":"(290+D147*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":811.69018772467052},"=",{"$f":"(F147+G147+H147)*J147*$V$1","v":0},"x",{"$f":"ROUND((1/$M$144*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L147*N147/100","v":0},"=",{"$f":"IF((G147*J147-G147*$J$132+H147*J147)*N147/100<0,0,(G147*J147-G147*$J$132+H147*J147)*N147/100)*$V$1","v":0}]
[null,null,null,"300","mm",0,0,0,"x",{"$f":"(290+D148*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":967.12022367194788},"=",{"$f":"(F148+G148+H148)*J148*$V$1","v":0},"x",{"$f":"ROUND((1/$M$144*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L148*N148/100","v":0},"=",{"$f":"IF((G148*J148-G148*$J$132+H148*J148)*N148/100<0,0,(G148*J148-G148*$J$132+H148*J148)*N148/100)*$V$1","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(290+D149*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1122.550259619225},"=",{"$f":"(F149+G149+H149)*J149*$V$1","v":0},"x",{"$f":"ROUND((1/$M$144*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L149*N149/100","v":0},"=",{"$f":"IF((G149*J149-G149*$J$132+H149*J149)*N149/100<0,0,(G149*J149-G149*$J$132+H149*J149)*N149/100)*$V$1","v":0}]
[null,null,null,"500","mm",0,0,0,"x",{"$f":"(290+D150*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1277.9802955665025},"=",{"$f":"(F150+G150+H150)*J150*$V$1","v":0},"x",{"$f":"ROUND((1/$M$144*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L150*N150/100","v":0},"=",{"$f":"IF((G150*J150-G150*$J$132+H150*J150)*N150/100<0,0,(G150*J150-G150*$J$132+H150*J150)*N150/100)*$V$1","v":0}]
[null,null,null,"600","mm",0,0,0,"x",{"$f":"(290+D151*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":1433.4103315137797},"=",{"$f":"(F151+G151+H151)*J151*$V$1","v":0},"x",{"$f":"ROUND((1/$M$144*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L151*N151/100","v":0},"=",{"$f":"IF((G151*J151-G151*$J$132+H151*J151)*N151/100<0,0,(G151*J151-G151*$J$132+H151*J151)*N151/100)*$V$1","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F147:F151)*$V$1","v":0},{"$f":"SUM(G147:G151)*$V$1","v":0},{"$f":"SUM(H147:H151)*$V$1","v":0},null,null,{"$f":"SUM(L147:L151)","v":0},null,null,null,null,{"$f":"SUM(Q147:Q151)","v":0},null,{"$f":"SUM(S147:S151)","v":0}]
[]
[null,"3.3.","PE",null,null,null,null,null,null,null,"Durée de vie utile :",null,60,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤","225","mm",0,0,0,"x",{"$f":"(240+(D157-D157*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":764.91783590733598},"=",{"$f":"(F157+G157+H157)*J157*$V$1","v":0},"x",{"$f":"ROUND((1/$M$154*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L157*N157/100","v":0},"=",{"$f":"IF((G157*J157-G157*$J$132+H157*J157)*N157/100<0,0,(G157*J157-G157*$J$132+H157*J157)*N157/100)*$V$1","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(240+(D158-D158*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":803.86169491412591},"=",{"$f":"(F158+G158+H158)*J158*$V$1","v":0},"x",{"$f":"ROUND((1/$M$154*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L158*N158/100","v":0},"=",{"$f":"IF((G158*J158-G158*$J$132+H158*J158)*N158/100<0,0,(G158*J158-G158*$J$132+H158*J158)*N158/100)*$V$1","v":0}]
[null,null,null,"280","mm",0,0,0,"x",{"$f":"(240+(D159-D159*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":850.59432572227411},"=",{"$f":"(F159+G159+H159)*J159*$V$1","v":0},"x",{"$f":"ROUND((1/$M$154*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L159*N159/100","v":0},"=",{"$f":"IF((G159*J159-G159*$J$132+H159*J159)*N159/100<0,0,(G159*J159-G159*$J$132+H159*J159)*N159/100)*$V$1","v":0}]
[null,null,null,"315","mm",0,0,0,"x",{"$f":"(240+(D160-D160*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":905.11572833178025},"=",{"$f":"(F160+G160+H160)*J160*$V$1","v":0},"x",{"$f":"ROUND((1/$M$154*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L160*N160/100","v":0},"=",{"$f":"IF((G160*J160-G160*$J$132+H160*J160)*N160/100<0,0,(G160*J160-G160*$J$132+H160*J160)*N160/100)*$V$1","v":0}]
[null,null,"≥","355","mm",0,0,0,"x",{"$f":"(240+(D161-D161*0.18-0.03)*1.1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":967.42590274264433},"=",{"$f":"(F161+G161+H161)*J161*$V$1","v":0},"x",{"$f":"ROUND((1/$M$154*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L161*N161/100","v":0},"=",{"$f":"IF((G161*J161-G161*$J$132+H161*J161)*N161/100<0,0,(G161*J161-G161*$J$132+H161*J161)*N161/100)*$V$1","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F157:F161)*$V$1","v":0},{"$f":"SUM(G157:G161)*$V$1","v":0},{"$f":"SUM(H157:H161)*$V$1","v":0},null,null,{"$f":"SUM(L157:L161)","v":0},null,null,null,null,{"$f":"SUM(Q157:Q161)","v":0},null,{"$f":"SUM(S157:S161)","v":0}]
[]
[null,"3.4.","PEHD sous pression",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans"]
[]
[null,null,"Diamètre extérieur",null,null,"Longueur\n(m)","Longueur\n(m)","Longueur\n(m)","Valeur unitaire (€/m)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,"≤",90,"mm",0,0,0,"x",{"$f":"(145+(D167-D167*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":365.07579543336442},"=",{"$f":"(F167+G167+H167)*J167*$V$1","v":0},"x",{"$f":"ROUND((1/$M$164*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L167*N167/100","v":0},"=",{"$f":"IF((G167*J167-G167*$J$132+H167*J167)*N167/100<0,0,(G167*J167-G167*$J$132+H167*J167)*N167/100)*$V$1","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(145+(D168-D168*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":390.56632132871795},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",{"$f":"(145+(D169-D169*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":409.68421575023302},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",{"$f":"(145+(D170-D170*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":454.29263606710157},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",{"$f":"(145+(D171-D171*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":479.7831619624551},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",{"$f":"(145+(D172-D172*0.18-0.03)*0.9)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":537.13684522700055},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F167:F172)*$V$1","v":0},{"$f":"SUM(G167:G172)*$V$1","v":0},{"$f":"SUM(H167:H172)*$V$1","v":0},null,null,{"$f":"SUM(L167:L172)","v":0},null,null,null,null,{"$f":"SUM(Q167:Q172)","v":0},null,{"$f":"SUM(S167:S172)","v":0}]
[]
[null,"3.5.","Branchements particuliers",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans",null,null,null,null,"Aide"]
[]
[null,null,"Nombre de branchements particuliers",null,null,null,null,null,"Valeur unitaire    (€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,{"$f":"'Coût de l''eau usée'!D33*V1","v":0},null,null,null,null,null,"x",{"$f":"ROUND((2400/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))/10,0)*10","v":4140},"=",{"$f":"C178*J178*$V$1","v":0},"x",{"$f":"ROUND((1/$M$175*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L178*N178/100","v":0},"=",{"$f":"0","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des collecteurs posés en zone urbaine en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P142+P152+P162+P173+Q178","v":0},null,{"$f":"R142+R152+R162+R173+S178","v":0}]
[]
[]
[null,"4.","Bassins de rétention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,"4.1.","Conduites de rétention EM (SRK)",null,null,null,null,null,null,null,"Durée de vie utile :",null,40,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Code national",null,null,null,"Volume de stockage\n(m3)",null,"Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G188=0,0,(14000*G188^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G188*J188","v":0},"x",{"$f":"ROUND((1/$M$185*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L188*N188/100","v":0},"=",{"$f":"L188*N188/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G189=0,0,(14000*G189^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",{"$f":"ROUND((1/$M$185*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L189*N189/100","v":0},"=",{"$f":"L189*N189/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G190=0,0,(14000*G190^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G190*J190","v":0},"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G191=0,0,(14000*G191^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G192=0,0,(14000*G192^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G193=0,0,(14000*G193^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G194=0,0,(14000*G194^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G195=0,0,(14000*G195^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G196=0,0,(14000*G196^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G197=0,0,(14000*G197^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H188:H197)","v":0},null,null,null,{"$f":"SUM(L188:L197)","v":0},null,null,null,null,{"$f":"SUM(Q188:Q197)","v":0},null,{"$f":"SUM(S188:S197)","v":0}]
[]
[null,"4.2.","Bassins de rétention EM enterrés (RÜB)",null,null,null,null,null,null,null,"Durée de vie utile :",null,40,"ans"]
[]
[null,null,"Code national",null,null,null,"Volume de stockage\n(m3)",null,"Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G203=0,0,(39000*G203^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G203*J203","v":0},"x",{"$f":"ROUND((1/$M$200*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L203*N203/100","v":0},"=",{"$f":"L203*N203/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G204=0,0,(39000*G204^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G204*J204","v":0},"x",{"$f":"ROUND((1/$M$200*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L204*N204/100","v":0},"=",{"$f":"L204*N204/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G205=0,0,(39000*G205^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G206=0,0,(39000*G206^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G207=0,0,(39000*G207^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G208=0,0,(39000*G208^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G209=0,0,(39000*G209^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G210=0,0,(39000*G210^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G211=0,0,(39000*G211^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G212=0,0,(39000*G212^-(8/15))/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H203:H212)","v":0},null,null,null,{"$f":"SUM(L203:L212)","v":0},null,null,null,null,{"$f":"SUM(Q203:Q212)","v":0},null,{"$f":"SUM(S203:S212)","v":0}]
[]
[null,"4.3.","Bassins de rétention EP à ciel ouvert (RRB)",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans"]
[]
[null,null,"Code national",null,null,null,"Volume de stockage\n(m3)",null,"Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G218=0,0,(80+11000*G218^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G218*J218","v":0},"x",{"$f":"ROUND((1/$M$215*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L218*N218/100","v":0},"=",{"$f":"L218*N218/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G219=0,0,(80+11000*G219^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G219*J219","v":0},"x",{"$f":"ROUND((1/$M$215*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L219*N219/100","v":0},"=",{"$f":"L219*N219/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G220=0,0,(80+11000*G220^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G221=0,0,(80+11000*G221^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G222=0,0,(80+11000*G222^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G223=0,0,(80+11000*G223^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G224=0,0,(80+11000*G224^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G225=0,0,(80+11000*G225^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G226=0,0,(80+11000*G226^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G227=0,0,(80+11000*G227^-1)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H218:H227)","v":0},null,null,null,{"$f":"SUM(L218:L227)","v":0},null,null,null,null,{"$f":"SUM(Q218:Q227)","v":0},null,{"$f":"SUM(S218:S227)","v":0}]
[]
[null,"4.4.","Bassins de rétention EP enterrés (RRB)",null,null,null,null,null,null,null,"Durée de vie utile :",null,50,"ans"]
[]
[null,null,"Code national",null,null,null,"Volume de stockage\n(m3)",null,"Valeur unitaire (€/m3)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G233=0,0,(11000*G233^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G233*J233","v":0},"x",{"$f":"ROUND((1/$M$230*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L233*N233/100","v":0},"=",{"$f":"L233*N233/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G234=0,0,(11000*G234^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"G234*J234","v":0},"x",{"$f":"ROUND((1/$M$230*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L234*N234/100","v":0},"=",{"$f":"L234*N234/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G235=0,0,(11000*G235^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G236=0,0,(11000*G236^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G237=0,0,(11000*G237^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G238=0,0,(11000*G238^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G239=0,0,(11000*G239^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G240=0,0,(11000*G240^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G241=0,0,(11000*G241^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G242=0,0,(11000*G242^-0.4)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H233:H242)","v":0},null,null,null,{"$f":"SUM(L233:L242)","v":0},null,null,null,null,{"$f":"SUM(Q233:Q242)","v":0},null,{"$f":"SUM(S233:S242)","v":0}]
[]
[null,null,"TOTAL de l'amortissement annuel des bassins de rétention en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P198+P213+P228+P243","v":0},null,{"$f":"R198+R213+R228+R243","v":0}]
[]
[]
[null,"5.","Stations de pompage des eaux usées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,null,null,null,null,null,null,null,null,"Durée de vie utile :",null,20,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Code national",null,null,null,"Capacité maximale\n(l/s)",null,"Valeur unitaire (€/l/s)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G253=0,0,17000*G253^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",{"$f":"G253*J253","v":0},"x",{"$f":"ROUND((1/$M$250*10000)/5,0)*5/100","v":5},"%","=",{"$f":"L253*N253/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G254=0,0,17000*G254^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G255=0,0,17000*G255^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G256=0,0,17000*G256^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G257=0,0,17000*G257^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G258=0,0,17000*G258^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G259=0,0,17000*G259^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G260=0,0,17000*G260^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G261=0,0,17000*G261^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G262=0,0,17000*G262^-0.65)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12)","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H253:H262)","v":0},null,null,null,{"$f":"SUM(L253:L262)","v":0},null,null,null,null,{"$f":"SUM(Q253:Q262)","v":0},null,{"$f":"SUM(S253:S262)","v":0}]
[]
[]
[null,"6.","Stations d'épuration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,null,null,null,null,null,null,null,null,"Durée de vie utile :",null,30,"ans",null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Code national",null,null,"Dimensionnement\n(EH réservés)",null,"Raccordés\n(EH réservés)","Valeur unitaire (€/EHr)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F271=0,0,(16000*F271^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",{"$f":"F271*J271","v":0},"x",{"$f":"ROUND((1/$M$268*10000)/5,0)*5/100","v":3.35},"%","=",{"$f":"L271*N271/100","v":0},"=",{"$f":"L271*N271/100-IF(H271<=0,0,(16000*IF(H271>F271,F271,H271)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H271>F271,F271,H271)*N271/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F272=0,0,(16000*F272^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",{"$f":"ROUND((1/$M$268*10000)/5,0)*5/100","v":3.35},"%","=",{"$f":"L272*N272/100","v":0},"=",{"$f":"L272*N272/100-IF(H272<=0,0,(16000*IF(H272>F272,F272,H272)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H272>F272,F272,H272)*N272/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F273=0,0,(16000*F273^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L273*N273/100-IF(H273<=0,0,(16000*IF(H273>F273,F273,H273)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H273>F273,F273,H273)*N273/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F274=0,0,(16000*F274^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L274*N274/100-IF(H274<=0,0,(16000*IF(H274>F274,F274,H274)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H274>F274,F274,H274)*N274/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F275=0,0,(16000*F275^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L275*N275/100-IF(H275<=0,0,(16000*IF(H275>F275,F275,H275)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H275>F275,F275,H275)*N275/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F276=0,0,(16000*F276^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L276*N276/100-IF(H276<=0,0,(16000*IF(H276>F276,F276,H276)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H276>F276,F276,H276)*N276/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F277=0,0,(16000*F277^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L277*N277/100-IF(H277<=0,0,(16000*IF(H277>F277,F277,H277)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H277>F277,F277,H277)*N277/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F278=0,0,(16000*F278^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L278*N278/100-IF(H278<=0,0,(16000*IF(H278>F278,F278,H278)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H278>F278,F278,H278)*N278/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F279=0,0,(16000*F279^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L279*N279/100-IF(H279<=0,0,(16000*IF(H279>F279,F279,H279)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H279>F279,F279,H279)*N279/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F280=0,0,(16000*F280^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))","v":0},"=",0,"x",3.35,"%","=",0,"=",{"$f":"L280*N280/100-IF(H280<=0,0,(16000*IF(H280>F280,F280,H280)^-0.35)/600.88*IF('Coût de l''eau usée'!$M$1=1,$R$8,$R$12))*IF(H280>F280,F280,H280)*N280/100","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F271:F280)","v":0},null,{"$f":"SUM(H271:H280)","v":0},null,null,{"$f":"SUM(L271:L280)","v":0},null,null,null,null,{"$f":"SUM(Q271:Q280)","v":0},null,{"$f":"SUM(S271:S280)","v":0}]
[]
[]
[null,"7.","Autres éléments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charges totales",null,"Non imputables"]
[]
[null,null,"Désignation",null,null,null,"Pièces",null,"Valeur unitaire (€/pc)",null,"Valeur totale\n(€)",null,"Taux d'amortissement",null,null,"Amortissement annuel (€)",null,"Amortissement annuel (€)"]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G289*J289","v":0},"x",0,"%","=",{"$f":"L289*N289/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G290*J290","v":0},"x",0,"%","=",{"$f":"L290*N290/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G291*J291","v":0},"x",0,"%","=",{"$f":"L291*N291/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G292*J292","v":0},"x",0,"%","=",{"$f":"L292*N292/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G293*J293","v":0},"x",0,"%","=",{"$f":"L293*N293/100","v":0},"=",0]
[null,null,"Valeurs totales :",null,null,null,null,null,null,null,{"$f":"SUM(L289:L293)","v":0},null,null,null,null,{"$f":"SUM(Q289:Q293)","v":0},null,{"$f":"SUM(S289:S293)","v":0}]
[]
[]
[null,"8.","Valeur patrimoniale et amortissement annuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aide"]
[]
[null,null,"Valeur patrimoniale des infrastructures d'assainissement en € hors frais d'études :",null,null,null,null,null,null,null,{"$f":"K32+K44+K54+K65+K86+K96+K106+K117+L122+K142+K152+K162+K173+L178+K198+K213+K228+K243+K263+K281+K294","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charges totales",null,"Non imputables"]
[]
[null,null,"TOTAL de l'amortissement annuel des coûts de remplacement en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P68+P124+P180+P245+P263+P281+P294","v":0},null,{"$f":"R68+R124+R180+R245+R263+R281+R294","v":0}]
[null,null,"TVA sur les coûts de remplacement en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P303*R14","v":0},null,{"$f":"R303*R14","v":0}]
[null,null,"TOTAL de l'amortissement annuel des frais d'études en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P68*0.12+P124*0.12+P180*0.14+P245*0.16+P263*0.16+P281*0.16+P294*0.16","v":0},null,{"$f":"R68*0.12+R124*0.12+R180*0.14+R245*0.16+R263*0.16+R281*0.16+R294*0.16","v":0}]
[null,null,"TVA sur les frais d'études en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P305*R14","v":0},null,{"$f":"R305*R14","v":0}]
[null,null,"TOTAL de l'amortissement annuel des infrastructures d'assainissement en € :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P303+P304+P305+P306","v":0},null,{"$f":"R303+R304+R305+R306","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],[63,11,63,13],[69,14,69,15],[76,2,76,13],[69,2,69,4],[68,2,68,4],[71,2,71,13],[69,11,69,13],[74,2,74,5],[69,9,69,10],[66,2,66,4],[67,2,67,4],[69,7,69,8],[65,2,65,4],[33,11,33,13],[44,2,44,4],[36,2,36,4],[43,2,43,4],[35,2,35,4],[34,2,34,4],[37,2,37,4],[33,2,33,4],[41,2,41,4],[42,2,42,4],[39,2,39,4],[40,2,40,4],[38,2,38,4],[58,2,58,4],[53,2,53,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[54,2,54,4],[33,14,33,15],[33,9,33,10],[0,0,3,0],[1,15,2,15],[1,9,2,14],[1,1,2,8],[28,2,28,4],[29,7,29,8],[5,2,5,15],[7,10,7,11],[33,7,33,8],[7,14,7,15],[7,2,7,9],[27,2,27,4],[31,9,31,10],[16,9,16,10],[44,14,44,15],[51,9,51,10],[44,9,44,10],[44,11,44,13],[53,11,53,13],[46,2,46,13],[44,7,44,8],[49,2,49,6],[53,9,53,10],[53,7,53,8],[53,14,53,15],[46,14,46,15],[9,14,9,15],[11,14,11,15],[9,2,9,13],[11,2,11,13],[22,2,22,4],[14,2,14,5],[18,2,18,4],[18,14,18,15],[18,7,18,8],[18,9,18,10],[18,11,18,13],[59,14,59,15],[64,2,64,4],[63,2,63,4],[63,7,63,8],[63,9,63,10],[59,9,59,10],[61,9,61,10],[63,14,63,15],[59,7,59,8],[59,11,59,13],[59,2,59,4],[23,2,23,4],[29,14,29,15],[29,11,29,13],[29,2,29,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[29,9,29,10],[26,2,26,4],[25,2,25,4],[24,2,24,4]]}
["18 / 04 / 2023"]
[null,"Amortissement des parcs \nautomobile et immobilier",null,null,null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$M$1=1,'Coût de l''eau usée'!$G$5,'Coût de l''eau usée'!$H$7)","v":"Année de référence (comptes) :"},null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$M$1=1,'Coût de l''eau usée'!$J$5,'Coût de l''eau usée'!$J$7)","v":2022}]
[]
[]
[]
[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 usée'!$J$5,\" :\")","v":"Indice moyen annuel des prix de la construction de l'année 2022 :"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!R8","v":1037.72}]
[]
[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'!R10","v":2.8000000000000001E-2}]
[]
[null,null,{"$f":"CONCATENATE(\"Indice moyen annuel estimé des prix de la construction de l'année \",'Coût de l''eau usée'!$J$7,\" :\")","v":"Indice moyen annuel estimé des prix de la construction de l'année 2024 :"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!R12","v":1096.6458924799999}]
[]
[]
[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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":600},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":600},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":600},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":600},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":600},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":260},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":260},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":260},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":260},"=",{"$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 usée'!$M$1=1,$O$8,$O$12))/10,0)*10","v":260},"=",{"$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.","Amortissement annuel"]
[]
[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}]