{"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":1,"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":135,"n_cols":13,"rows_kept":135,"cut":false,"hidden":false,"merged":[[20,2,20,3],[20,4,20,5],[21,2,21,3],[21,4,21,5],[23,2,23,3],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[114,0,115,0],[129,2,130,2],[129,3,130,3],[7,10,8,10],[7,11,8,11],[115,10,115,12],[11,2,11,3],[91,1,91,8],[46,1,46,2],[88,1,88,2],[26,2,26,3],[88,3,88,4],[72,1,72,4],[47,1,47,2],[7,7,7,8],[7,5,7,6],[108,6,108,7],[124,1,124,2],[122,1,122,2],[111,6,111,7],[127,1,127,8],[123,1,123,2],[120,1,120,2],[121,1,121,2],[119,1,119,2],[109,1,109,2],[118,1,118,2],[113,1,113,2],[112,6,112,7],[110,6,110,7],[93,5,94,5],[107,6,107,7],[104,6,104,7],[105,6,105,7],[101,1,101,2],[99,6,99,7],[101,6,101,7],[106,6,106,7],[93,4,94,4],[93,6,94,7],[96,6,96,7],[97,6,97,7],[38,1,38,8],[32,1,32,3],[86,3,86,4],[86,1,86,2],[54,1,54,2],[44,1,44,2],[42,1,42,2],[40,1,40,8],[58,1,58,2],[73,3,73,4],[73,1,73,2],[61,1,61,2],[71,1,71,4],[66,3,67,3],[10,2,10,3],[12,2,12,3],[4,8,5,8],[108,1,108,2],[93,3,94,3],[103,1,103,2],[64,1,64,4],[100,6,100,7],[65,1,65,4],[66,2,67,2],[75,1,75,8],[77,1,77,4],[60,1,60,2],[63,1,63,4],[25,2,25,3],[85,1,85,4],[28,4,28,5],[37,1,37,8],[28,2,28,3],[53,1,53,2],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,6,5,7],[5,0,5,5],[13,2,13,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[16,2,16,3],[15,2,15,3],[8,1,8,8]]}
[null,null,null,null,null,null,null,null,null,null,"Cell link Année de calcul",1]
["Ministère de l'Environnement, du Climat et de la Biodiversité",null,null,null,null,null,null,null,null,null,"Cell link Nom de la commune",1]
["Administration de la gestion de l'eau",null,null,null,null,null,null,null,null,null,"Zone urbaine",{"$f":"IF(OR(L2=1,L2=108),0,LOOKUP(L2,L13:L114,M13:M114))","v":0}]
["Association Luxembourgeoise des Services d'Eau",null,null,null,null,null,null,null,null,null,"Zone rurale",{"$f":"IF(OR(L2=1,L2=108),0,IF(L3=0,1,0))","v":0}]
[null,null,null,null,null,null,"Année de référence (comptes) :",null,2024,null,"Limite des coûts indexée ",{"$f":"5/108*L8*IF($L$1=2,1*(1+#REF!)^(#REF!-I5),1)","v":5.5638888888888891}]
["Requête de données dans le cadre le l'analyse économique relative à la directive-cadre eau 2000/60/CE",null,null,null,null,null,null,null,null,null,"EHr de dimensionnement",{"$f":"'Amortissement infrastructures'!F281","v":0}]
[null,null,"Calcul du coût de l'eau usée",null,null,null,null,null,null,null,"EHr raccordés",{"$f":"'Amortissement infrastructures'!H281","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Indice IPCN base 100 en 2015 (moyenne de l'année \",I5,\")\")","v":"Indice IPCN base 100 en 2015 (moyenne de l'année 2024)"},120.18]
[0,{"$f":"CONCATENATE(\"Données à caractère général (année de référence \",$I$5,\")\")","v":"Données à caractère général (année de référence 2024)"}]
[null,null,"Veuillez d'abord sélectionner le nom de la commune",null,null,null,null,null,null,null,"Evacuation (l/habitant/jour)",{"$f":"C17/C13/365*1000","v":{"$error":"#DIV/0!"}}]
[null,"Commune : ",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)/C13","v":{"$error":"#DIV/0!"}}]
[null,"Superficie (ha) :"]
[null,{"$f":"CONCATENATE(\"Population résidente (au 31 décembre \",$I$5,\") :\")","v":"Population résidente (au 31 décembre 2024) :"},null,null,null,null,null,null,null,null,"Nom de la commune",1,0]
[null,"Nombre de ménages",null,null,null,null,null,null,null,null,"AERENZDALL",2,0]
[null,null,null,null,null,null,null,null,null,null,"BEAUFORT",3,0]
[null,"Evacuation des entités privées et publiques internes ainsi que des entités externes et collectée par l'infrastructure communale, par secteur  ","Provenances externes (m3/an)",null,"Provenances internes (m3/an)",null,null,null,null,null,"BECH",4,0]
[null,"-secteur des ménages",null,null,null,null,null,null,null,null,"BECKERICH",5,0]
[null,"-secteur  industriel",null,null,null,null,null,null,null,null,"BERDORF",6,0]
[null,"-secteur agricole",null,null,null,null,null,null,null,null,"BERTRANGE",7,0]
[null,"-secteur HORECA",null,null,null,null,null,null,null,null,"BETTEMBOURG",8,0]
[null,null,"Total Provenances externes",null,"Total provenances internes",null,null,null,null,null,"BETTENDORF",9,0]
[null,null,{"$f":"SUM(C17:D20)","v":0},null,{"$f":"SUM(E17:F20)","v":0},null,null,null,null,null,"BETZDORF",10,0]
[null,null,null,null,null,null,null,null,null,null,"BISSEN",11,0]
[null,"Quantité totale d'eau collectée par l'infrastucture communale (externes+internes)",{"$f":"C22+E22","v":0},null,null,null,null,null,null,null,"BIWER",12,0]
[null,null,null,null,null,null,null,null,null,null,"BOULAIDE",13,0]
[null,"Evacuation vers une infrastructure externe comunale ou syndicale se référer à NOTA BENE : ","Evacuation externes (m3/an)",null,null,null,null,null,null,null,"BOURSCHEID",14,0]
[null,"- quantité d'eau évacuée :",null,null,null,null,null,null,null,null,"BOUS-WALDBREDIMUS",15,0]
[null,null,null,null,null,null,null,null,null,null,"CLERVAUX",16,0]
[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,"COLMAR-BERG",17,0]
[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,"CONSDORF",18,0]
[null,"NOTA BENE :",null,null,null,null,null,null,null,null,"CONTERN",19,0]
[null,null,null,null,null,null,null,null,null,null,"DALHEIM",20,0]
[null,"Provenance externes collectées par l'infrastructure communale, tout secteur confondu ",null,null,null,null,null,null,null,null,"DIEKIRCH",21,0]
[null,null,null,null,null,null,null,null,null,null,"DIFFERDANGE",22,1]
[null,"Charge polluante moyenne annuelle totale collectée par l'infrastructure communale",null,null,{"$f":"E33+E31","v":0},null,null,null,null,null,"DIPPACH",23,0]
[null,null,null,null,null,null,null,null,null,null,"DUDELANGE",24,1]
[null,null,null,null,null,null,null,null,null,null,"ECHTERNACH",25,0]
[1,"Coût complet des services liés à l'évacuation et à la dépollution des eaux (année de référence 2024)",null,null,null,null,null,null,null,null,"ELL",26,0]
[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,"ERPELDANGE",27,0]
[null,null,null,null,null,null,null,null,null,null,"ESCH-SUR-ALZETTE",28,1]
["1.1","Charges de fonctionnement, de maintenance et d'exploitation propres (infrastructures autonomes)",null,null,null,null,null,null,null,null,"ESCH-SUR-SÛRE",29,0]
[null,"(budget ou compte ordinaire)",null,null,null,null,null,null,null,null,"ETTELBRUCK",30,0]
[null,"Dépenses pour :\n",null,"Total article budgétaire (€)","Taux d'utilisation assainissement","Frais fixes\n(€/an)","Frais variables\n(€/an)","Total des frais\n(€/an)","Remarques",null,"FEULEN",31,0]
[null,"Achats de matières et de fournitures :",null,null,null,null,null,null,null,null,"FISCHBACH",32,0]
[null,"- fournitures pour l'entretien et le nettoyage des bâtiments (art. 3/520/603200) :",null,null,1,null,{"$f":"D45*E45","v":0},{"$f":"SUM(F45:G45)","v":0},null,null,"FLAXWEILER",33,0]
[null,"- fournitures pour l'entretien des réseaux (art. 3/520/603200) :",null,null,1,null,{"$f":"D46*E46","v":0},{"$f":"SUM(F46:G46)","v":0},null,null,"FRISANGE",34,0]
[null,"- facturation interne des consommations eau-électricité-gaz des bâtiments (art. 3/520/608111/X & 112/X & 113/X) : ",null,null,1,null,0,{"$f":"SUM(F47:G47)","v":0},null,null,"GARNICH",35,0]
[null,"- frais de consommation électrique des infrastructures et des réseaux (art. 3/520/608112) :",null,null,1,null,0,{"$f":"SUM(F48:G48)","v":0},null,null,"GOESDORF",36,0]
[null,"- achats et fournitures divers (art. 3/520/608180) :",null,null,1,{"$f":"0.5*D49*E49","v":0},{"$f":"0.5*D49*E49","v":0},{"$f":"SUM(F49:G49)","v":0},null,null,"GREVENMACHER",37,0]
[null,"Services extérieurs :",null,null,null,null,null,null,null,null,"GROSBOUS-WAHL",38,0]
[null,"- frais d'entretien et de nettoyage des bâtiments (art. 3/520/612300) :",null,null,1,null,{"$f":"D51*E51","v":0},{"$f":"SUM(F51:G51)","v":0},null,null,"HABSCHT",39,0]
[null,"- frais d'assurances (incendie, responsabilité civile, etc) (art. 3/520/614xxx) :",null,null,1,{"$f":"D52*E52","v":0},null,0,null,null,"HELPERKNAPP",40,0]
[null,"- frais d'entretien des véhicules automoteurs (art. 3/520/61223x) :",null,null,1,null,{"$f":"D53*E53","v":0},0,null,null,"HEFFINGEN",41,0]
[null,"- frais de services administratives et techniques (art. 3/520/61213x) :",null,null,1,null,{"$f":"D54*E54","v":0},0,null,null,"HESPERANGE",42,0]
[null,"- frais d'entretien des réseaux et des stations d'épuration (art. 3/520/603200) NOTA BENE :",null,null,1,null,0,0,null,null,"JUNGLINSTER",43,0]
[null,"- frais d'évacuation des boues d'épuration (art. 3/520/6184xx) :",null,null,1,null,0,0,null,null,"KÄERJENG",44,0]
[null,"- frais d'enlèvement-recyclage-destruction des ordures (art. 3/520/6183xx) :",null,null,1,null,0,0,null,null,"KAYL",45,0]
[null,"- frais d'outillage et de matériel roulant (3/520/6122xx) :",null,null,1,null,0,0,null,null,"KEHLEN",46,0]
[null,"- frais pour prestations effectuées par d'autres services communaux (3/520/61218xx) :",null,null,1,{"$f":"0.5*D59*E59","v":0},{"$f":"0.5*D59*E59","v":0},0,null,null,"KIISCHPELT",47,0]
[null,"Frais de personnel - rémunérations :",null,null,null,null,null,null,null,null,"KOERICH",48,0]
[null,"- frais du personnel propre du service (art. 3/520/621xxx) AIDE :",null,null,1,{"$f":"D61*E61","v":0},null,{"$f":"SUM(F61:G61)","v":0},null,null,"KOPSTAL",49,0]
[null,"- frais du personnel ventilé d'autres services communaux (art. 3/520/621xxx) AIDE : ",null,null,1,{"$f":"D62*E62","v":0},null,{"$f":"SUM(F62:G62)","v":0},null,null,"LAC DE LA HAUTE SURE",50,0]
[null,"- frais divers (3/520/62188xx) :",null,null,1,{"$f":"0.5*D63*E63","v":0},{"$f":"0.5*D63*E63","v":0},{"$f":"SUM(F63:G63)","v":0},null,null,"LAROCHETTE",51,0]
[null,"Amortissement charroi et immobilier :",null,null,null,{"$f":"'Amortissement charroi et immob.'!O77","v":0},null,{"$f":"SUM(F64:G64)","v":0},null,null,"LENNINGEN",52,0]
[null,"Total des charges hors amortissemetn des infrastructures et taxes de rejet",null,null,null,{"$f":"SUM(F44:F64)","v":0},{"$f":"SUM(G44:G63)","v":0},{"$f":"SUM(H44:H64)","v":0},null,null,"LEUDELANGE",53,0]
[null,null,null,null,null,null,null,null,null,null,"LINTGEN",54,0]
[null,"Clef de répartition des charges de fonctionnement et d'exploitation : ","Amort. infrastruct. \n(€/an)","Ratio\n(%)",null,null,null,null,null,null,"LORENTZWEILER",55,0]
[null,null,null,null,null,null,null,null,null,null,"LUXEMBOURG",56,1]
[null,"Charges d'amortissement totales des infrastructures AIDE :",{"$f":"'Amortissement infrastructures'!P307","v":0},1,null,null,null,null,null,null,"MAMER",57,0]
[null,"Charges d'amortissement non opposables AIDE :",{"$f":"-'Amortissement infrastructures'!R307","v":0},{"$f":"C70/C69","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"MANTERNACH",58,0]
[null,"Charges d'amortissement imputables :",{"$f":"C69+C70","v":0},{"$f":"C71/C69","v":{"$error":"#DIV/0!"}},null,{"$f":"F65*D71","v":{"$error":"#DIV/0!"}},{"$f":"G65*D71","v":{"$error":"#DIV/0!"}},{"$f":"H65*D71","v":{"$error":"#DIV/0!"}},null,null,"MERSCH",59,0]
[null,"Charges d'amortissement réduites AIDE :",null,null,null,{"$f":"C71/2","v":0},null,{"$f":"F72","v":0},null,null,"MERTERT",60,0]
[null,"Charges taxe de rejet des eaux résiduaires AIDE :",null,null,null,null,{"$f":"(C24-C27)*0.1","v":0},{"$f":"G73","v":0},null,null,"MERTZIG",61,0]
[null,"Charges imputables de fonctionnement, de maintenance et d'exploitation ………………………………………...",null,{"$f":"CONCATENATE(IF(L1=1,CONCATENATE(\"(année de référence \",I5,\") :\"),CONCATENATE(\"(données prévisionnelles \",#REF!,\") :\")))","v":"(année de référence 2024) :"},null,{"$f":"SUM(F71:F73)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G71:G73)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H71:H73)","v":{"$error":"#DIV/0!"}},null,null,"MONDERCANGE",62,0]
[null,null,null,null,null,null,null,null,null,null,"MONDORF-LES-BAINS",63,0]
["1.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,"NIEDERANVEN",64,0]
[null,"Budget ou compte ordinaire de l'année de référence",null,null,null,null,null,null,null,null,"NOMMERN",65,0]
[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,"PARC HOSINGEN",66,0]
[null,"- syndicats (art. 3/520/648211/S) :",null,null,null,null,null,null,null,null,"PETANGE",67,1]
[null,null,null,null,null,null,null,{"$f":"(F80+G80)","v":0},null,null,"PREIZERDAUL",68,0]
[null,null,null,null,null,null,null,{"$f":"(F81+G81)","v":0},null,null,"PUTSCHEID",69,0]
[null,"- communes (art. 3/520/648211/C) :",null,null,null,null,null,null,null,null,"RAMBROUCH",70,0]
[null,null,null,null,null,null,null,{"$f":"(F83+G83)","v":0},null,null,"RECKANGE-SUR-MESS",71,0]
[null,null,null,null,null,null,null,{"$f":"(F84+G84)","v":0},null,null,"REDANGE/ATTERT",72,0]
[null,null,null,null,null,{"$f":"SUM(F80:F84)","v":0},{"$f":"SUM(G80:G84)","v":0},{"$f":"SUM(H80:H84)","v":0},null,null,"REISDORF",73,0]
[null,null,null,null,null,null,null,null,null,null,"REMICH",74,0]
[null,"Coûts imputables des services liées à l'évacuation et à la dépollution des eaux en €/an ……………………...",null,{"$f":"CONCATENATE(IF(L1=1,CONCATENATE(\"(année de référence \",I5,\") :\"),CONCATENATE(\"(données prévisionnelles \",#REF!,\") :\")))","v":"(année de référence 2024) :"},null,{"$f":"F74+(H80+H81)*0.65+(H83+H84)*0.75","v":{"$error":"#DIV/0!"}},{"$f":"G74+(H80+H81)*0.35+(H83+H84)*0.25","v":{"$error":"#DIV/0!"}},{"$f":"H74+H85","v":{"$error":"#DIV/0!"}},null,null,"ROESER",75,0]
[null,null,null,null,null,null,null,null,null,null,"ROSPORT-MOMPACH",76,0]
[null,"Coût complet des services liées à l'évacuation et à la dépollution des eaux en €/an …………………………...",null,{"$f":"CONCATENATE(IF(L1=1,CONCATENATE(\"(année de référence \",I5,\") :\"),CONCATENATE(\"(données prévisionnelles \",#REF!,\") :\")))","v":"(année de référence 2024) :"},null,null,null,{"$f":"H87-C70+(C71-F72)-H65*D70","v":{"$error":"#DIV/0!"}},null,null,"RUMELANGE",77,1]
[null,null,null,null,null,null,null,null,null,null,"SAEUL",78,0]
[null,null,null,null,null,null,null,null,null,null,"SANDWEILER",79,0]
[2,{"$f":"CONCATENATE(\"Recettes relatives à l'évacuation et à la dépollution des eaux résiduaires \",IF(L1=1,CONCATENATE(\"(année de référence \",I5,\")\"),CONCATENATE(\"(données prévisionnelles \",#REF!,\")\")))","v":"Recettes relatives à l'évacuation et à la dépollution des eaux résiduaires (année de référence 2024)"},null,null,null,null,null,null,null,null,"SANEM",80,0]
[null,"Budget ou compte ordinaire(articles 7011)",null,null,null,null,null,null,null,null,"SCHENGEN",81,0]
[null,null,null,"Recettes fixes\n(€/an)","Recettes variables\n(€/an)","Total des recettes\n(€/an)","Remarques",null,null,null,"SCHIEREN",82,0]
["2.2","Evacuation/dépollution des eaux usées provenant d'une entité externe AIDE",null,null,null,null,null,null,null,null,"SCHIFFLANGE",83,1]
[null,"- syndicats :",null,null,null,null,null,null,null,null,"SCHUTTRANGE",84,0]
[null,null,null,null,null,{"$f":"(D97+E97)","v":0},null,null,null,null,"STADTBREDIMUS",85,0]
[null,null,null,null,null,{"$f":"(D98+E98)","v":0},null,null,null,null,"STEINFORT",86,0]
[null,"- communes :",null,null,null,null,null,null,null,null,"STEINSEL",87,0]
[null,null,null,null,null,{"$f":"(D100+E100)","v":0},null,null,null,null,"STRASSEN",88,0]
[null,null,null,null,null,{"$f":"(D101+E101)","v":0},null,null,null,null,"TANDEL",89,0]
[null,"Total des recettes pour évacuation/dépollution des eaux usées provenant d'une entité externe (€/an) :",null,{"$f":"SUM(D97:D101)","v":0},{"$f":"SUM(E97:E101)","v":0},{"$f":"SUM(F97:F101)","v":0},null,null,null,null,"TROISVIERGES",90,0]
[null,null,null,null,null,null,null,null,null,null,"USELDANGE",91,0]
[null,"Evacuation/dépollution d'eaux usées générées par les abonnées de la commune",null,null,null,null,null,null,null,null,"VALLEE DE L'ERNZ",92,0]
[null,"- secteur des ménages :",null,null,null,{"$f":"(D105+E105)","v":0},null,null,null,null,"VIANDEN",93,0]
[null,"- secteur industriel :",null,null,null,{"$f":"(D106+E106)","v":0},null,null,null,null,"VICHTEN",94,0]
[null,"- secteur agricole :",null,null,null,0,null,null,null,null,"WALDBILLIG",96,0]
[null,"- secteur HORECA :",null,null,null,0,null,null,null,null,"WALFERDANGE",98,0]
[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(D105:D108)","v":0},{"$f":"SUM(E105:E108)","v":0},{"$f":"SUM(F105:F108)","v":0},null,null,null,null,"WEILER-LA-TOUR",99,0]
[null,"Autres recettes",null,null,null,null,null,null,null,null,"WEISWAMPACH",100,0]
[null,null,null,null,null,{"$f":"(D111+E111)*IF($L$1=2,(1+#REF!)^(#REF!-I5),1)","v":0},null,null,null,null,"WILTZ",101,0]
[null,null,null,null,null,{"$f":"(D112+E112)*IF($L$1=2,(1+#REF!)^(#REF!-I5),1)","v":0},null,null,null,null,"WINCRANGE",102,0]
[null,null,null,null,null,{"$f":"(D113+E113)*IF($L$1=2,(1+#REF!)^(#REF!-I5),1)","v":0},null,null,null,null,"WINSELER",103,0]
[null,"Total autres recettes (€/an) :",null,{"$f":"SUM(D111:D113)","v":0},{"$f":"SUM(E111:E113)","v":0},{"$f":"SUM(F111:F113)","v":0},null,null,null,null,"WORMELDANGE",104,0]
[null,"Total des recettes en €/an (année de référence 2024) :",null,{"$f":"D109+D102+D114","v":0},{"$f":"E109+E102+E114","v":0},{"$f":"F109+F102+F114","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Tableau des EH moyens annuels"]
[]
["3","Calcul du coût imputable de l'eau usée"]
[null,null,null,"Valeurs fixes","Valeurs variables","Valeurs totales"]
["3.1","Coûts imputables des services liées à l'évacuation et à la dépollution des eaux résiduaires (€/an) NOTA BENE :",null,{"$f":"F87-D114","v":{"$error":"#DIV/0!"}},{"$f":"G87-E114","v":{"$error":"#DIV/0!"}},{"$f":"H87-F114","v":{"$error":"#DIV/0!"}}]
[null,"Total des charges polluantes moyennes annuelles collectées par l'infrastructure communale (EHm) :",null,{"$f":"E35","v":0}]
[null,"Coût fixe par EH moyen annuel (€/EHm/an) :",null,{"$f":"D120/D121","v":{"$error":"#DIV/0!"}}]
[null,"Quantité totale d'eau déversée dans le réseau public d'évacuation/dépollution (m3/an) :",null,null,{"$f":"C27","v":0},{"$f":"E123","v":0}]
[null,"Coût variable par m3 d'eau usée (€/m3) :",null,null,{"$f":"E120/E123","v":{"$error":"#DIV/0!"}}]
[null,"Coût global par m3 d'eau usée (€/m3) AIDE :",null,null,null,{"$f":"F120/F123","v":{"$error":"#DIV/0!"}}]
[]
[]
[4,"Tarification en vigeur relatifs à l'évacuation et la dépollution des eaux résiduaires pour l'année  2024"]
[]
[null,null,"Part fixe\n(€/EHm/an hTVA)","Part variable\n(€/m3 hTVA)"]
[]
[null,"- secteur des ménages :"]
[null,"- secteur industriel :"]
[null,"- secteur agricole :"]
[null,"- secteur HORECA :"]

{"sheet":"Amortissement infrastructures","index":1,"n_rows":307,"n_cols":22,"rows_kept":307,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
[null,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'!L3","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'!$L$1=1,'Coût de l''eau usée'!$G$5,'Coût de l''eau usée'!#REF!)","v":"Année de référence (comptes) :"},null,null,null,null,null,2024,null,"Zone rurale",{"$f":"'Coût de l''eau usée'!L4","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'!#REF!","v":{"$error":"#REF!"}}]
[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'!#REF!","v":{"$error":"#REF!"}}]
[]
[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'!$I$5,\" (base 100 en 1970) :\")","v":"Indice moyen annuel des prix de la construction de l'année 2024 (base 100 en 1970) :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1148.21]
[]
[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,2.7E-2]
[]
[null,null,"Indice moyen annuel estimé des prix de la construction de l'année",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1187.58]
[]
[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",640.14503727865792,"=",{"$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",783.46109040074555,"=",{"$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",926.77714352283328,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",1070.0931966449209,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",1213.4092497670085,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1356.7253028890962,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1500.0413560111836,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",1643.3574091332712,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",1786.6734622553588,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",1929.9895153774464,"=",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",535.04659832246045,"=",{"$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",611.48182665424042,"=",{"$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",687.9170549860205,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"350 ","mm",0,0,0,"x",764.35228331780058,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"400","mm",0,0,0,"x",840.78751164958067,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"500","mm",0,0,0,"x",993.65796831314071,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","600","mm",0,0,0,"x",1146.5284249767008,"=",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",486.2618138397018,"=",{"$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",525.43486835973908,"=",{"$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",572.4425337837838,"=",{"$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",627.28481011183601,"=",{"$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",689.96169734389571,"=",{"$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",179.65336067101583,"=",{"$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",204.72411556383972,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",223.52718173345761,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",267.40100279589933,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",292.47175768872324,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",348.88095619757689,"=",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",793.01549394221809,"=",{"$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",955.44035414725067,"=",{"$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",1117.8652143522834,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",1280.2900745573158,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",1442.7149347623485,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1605.1397949673812,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1767.5646551724137,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",1929.9895153774464,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",2092.4143755824789,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",2254.8392357875118,"=",{"$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",668.80824790307554,"=",{"$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",840.78751164958067,"=",{"$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",1012.7667753960858,"=",{"$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",1184.7460391425907,"=",{"$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",1356.7253028890962,"=",{"$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",617.05586568033561,"=",{"$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",660.14622565237653,"=",{"$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",711.85465761882574,"=",{"$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",772.18116157968336,"=",{"$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",841.12573753494894,"=",{"$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",308.4027701537745,"=",{"$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",336.60736940820135,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",357.76081884902146,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",407.11886754426843,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",435.32346679869528,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",498.78381512115567,"=",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'!C31*V2","v":0},null,null,null,null,null,"x",{"$f":"ROUND((1800/600.88*IF('Coût de l''eau usée'!$L$1=1,$R$8,$R$12))/10,0)*10","v":3440},"=",{"$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",1022.3211789375583,"=",{"$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",1184.7460391425907,"=",{"$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",1347.1708993476236,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",1509.5957595526563,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",1672.0206197576888,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1834.4454799627215,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1996.8703401677542,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",2159.2952003727869,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",2321.7200605778194,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",2484.1449207828518,"=",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",898.11393289841578,"=",{"$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",1070.0931966449209,"=",{"$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",1242.0724603914259,"=",{"$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",1414.0517241379312,"=",{"$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",1586.0309878844362,"=",{"$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",846.36155067567574,"=",{"$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",889.45191064771666,"=",{"$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",941.16034261416598,"=",{"$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",1001.4868465750236,"=",{"$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",1070.4314225302892,"=",{"$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",403.94680556849954,"=",{"$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",432.15140482292645,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",453.30485426374656,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",502.66290295899347,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",530.86750221342038,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",594.32785053588088,"=",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'!C31*V1","v":0},null,null,null,null,null,"x",4590,"=",{"$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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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('[1]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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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'!$L$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":[[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],[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],[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],[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],[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],[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,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],[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]]}
[]
[null,"Amortissement des parcs \nautomobile et immobilier",null,null,null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$L$1=1,'Coût de l''eau usée'!$G$5,'Coût de l''eau usée'!#REF!)","v":"Année de référence (comptes) :"},null,null,null,null,null,{"$f":"IF('Coût de l''eau usée'!$L$1=1,'Coût de l''eau usée'!$I$5,'Coût de l''eau usée'!#REF!)","v":2024}]
[]
[]
[]
[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'!$I$5,\" :\")","v":"Indice moyen annuel des prix de la construction de l'année 2024 :"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Amortissement infrastructures'!R8","v":1148.21}]
[]
[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.7E-2}]
[]
[null,null,"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":1187.58}]
[]
[]
[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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":670},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":670},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":670},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":670},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":670},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":290},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":290},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":290},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":290},"=",{"$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'!$L$1=1,$O$8,$O$12))/10,0)*10","v":290},"=",{"$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}]