{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Amortissement infrastructures"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Amortissement infrastructures","index":0,"n_rows":303,"n_cols":19,"rows_kept":303,"cut":false,"hidden":false,"merged":[[253,2,253,5],[253,6,253,7],[254,2,254,5],[254,6,254,7],[255,2,255,5],[255,6,255,7],[91,12,91,14],[112,12,112,14],[83,10,83,11],[112,10,112,11],[157,8,157,9],[161,8,161,9],[159,2,159,5],[151,2,151,4],[149,2,149,5],[91,8,91,9],[95,8,95,9],[93,2,93,5],[112,8,112,9],[114,10,114,11],[116,2,116,7],[122,2,122,14],[126,2,126,4],[117,2,117,7],[85,8,85,9],[70,8,70,9],[63,2,63,14],[70,12,70,14],[60,2,60,4],[85,10,85,11],[66,2,66,14],[70,10,70,11],[105,2,105,4],[105,8,105,9],[101,12,101,14],[93,10,93,11],[91,10,91,11],[105,10,105,11],[101,10,101,11],[103,10,103,11],[103,2,103,5],[68,2,68,4],[81,12,81,14],[60,10,60,11],[83,2,83,4],[95,2,95,4],[95,12,95,14],[95,10,95,11],[114,2,114,8],[213,2,213,5],[205,2,205,5],[172,8,172,9],[170,2,170,8],[172,2,172,7],[172,10,172,11],[168,8,168,9],[161,2,161,4],[157,2,157,4],[180,10,180,11],[203,6,203,7],[182,2,182,5],[185,6,185,7],[184,2,184,5],[190,2,190,5],[187,6,187,7],[189,2,189,5],[189,6,189,7],[183,2,183,5],[182,6,182,7],[185,2,185,5],[178,2,178,5],[180,2,180,9],[173,2,173,7],[206,2,206,5],[205,6,205,7],[212,6,212,7],[208,6,208,7],[192,2,192,5],[195,10,195,11],[204,6,204,7],[202,6,202,7],[210,10,210,11],[208,10,208,11],[197,8,197,9],[199,2,199,5],[197,6,197,7],[193,6,193,7],[193,2,193,5],[203,2,203,5],[202,2,202,5],[200,6,200,7],[198,6,198,7],[201,6,201,7],[201,2,201,5],[227,8,227,9],[214,2,214,5],[212,2,212,5],[208,2,208,5],[191,6,191,7],[187,2,187,5],[195,2,195,9],[204,2,204,5],[214,6,214,7],[215,6,215,7],[198,2,198,5],[197,2,197,5],[192,6,192,7],[215,2,215,5],[207,2,207,5],[210,2,210,9],[212,8,212,9],[208,8,208,9],[213,6,213,7],[206,6,206,7],[207,6,207,7],[191,2,191,5],[200,2,200,5],[199,6,199,7],[231,2,231,5],[228,2,228,5],[217,2,217,5],[216,2,216,5],[218,6,218,7],[217,6,217,7],[216,6,216,7],[220,2,220,5],[219,2,219,5],[218,2,218,5],[222,2,222,5],[219,6,219,7],[220,6,220,7],[221,2,221,5],[221,6,221,7],[222,6,222,7],[223,6,223,7],[228,6,228,7],[250,2,250,5],[258,2,258,5],[265,5,265,6],[247,2,247,5],[247,6,247,7],[232,2,232,5],[237,2,237,5],[233,2,233,5],[236,2,236,5],[236,6,236,7],[238,6,238,7],[237,6,237,7],[238,2,238,5],[235,6,235,7],[233,6,233,7],[232,6,232,7],[256,6,256,7],[257,6,257,7],[258,6,258,7],[243,2,243,7],[251,2,251,5],[251,6,251,7],[252,2,252,5],[252,6,252,7],[287,2,287,5],[285,2,285,5],[288,6,288,7],[286,2,286,5],[276,12,276,14],[276,2,276,4],[288,2,288,5],[287,6,287,7],[284,6,284,7],[283,6,283,7],[285,6,285,7],[302,2,302,14],[299,2,299,14],[302,15,302,16],[300,2,300,14],[300,15,300,16],[289,12,289,14],[296,15,296,16],[294,2,294,9],[298,2,298,14],[298,15,298,16],[289,15,289,16],[289,2,289,9],[294,10,294,14],[161,12,161,14],[182,12,182,14],[302,17,302,18],[299,17,299,18],[301,17,301,18],[301,15,301,16],[300,17,300,18],[245,10,245,11],[301,2,301,14],[299,15,299,16],[270,5,270,6],[270,2,270,4],[258,8,258,9],[292,2,292,10],[298,17,298,18],[284,2,284,5],[286,6,286,7],[289,17,289,18],[296,17,296,18],[289,10,289,11],[248,2,248,5],[249,2,249,5],[247,12,247,14],[281,17,281,18],[193,17,193,18],[182,17,182,18],[182,15,182,16],[193,15,193,16],[193,12,193,14],[168,17,168,18],[172,17,172,18],[180,17,180,18],[175,15,175,16],[180,15,180,16],[168,12,168,14],[263,10,263,11],[247,10,247,11],[248,6,248,7],[250,6,250,7],[116,17,116,18],[124,17,124,18],[137,17,137,18],[126,17,126,18],[175,17,175,18],[161,17,161,18],[137,10,137,11],[126,8,126,9],[137,8,137,9],[126,12,126,14],[137,12,137,14],[172,15,172,16],[223,8,223,9],[182,10,182,11],[182,8,182,9],[197,15,197,16],[172,12,172,14],[208,15,208,16],[212,15,212,16],[157,12,157,14],[151,15,151,16],[105,12,105,14],[68,17,68,18],[60,17,60,18],[63,17,63,18],[70,15,70,16],[91,17,91,18],[101,15,101,16],[105,17,105,18],[101,17,101,18],[95,17,95,18],[95,15,95,16],[63,15,63,16],[81,15,81,16],[91,15,91,16],[85,17,85,18],[60,15,60,16],[68,15,68,16],[81,17,81,18],[105,15,105,16],[85,15,85,16],[112,15,112,16],[137,15,137,16],[85,12,85,14],[170,10,170,11],[227,6,227,7],[168,10,168,11],[159,10,159,11],[161,10,161,11],[157,10,157,11],[147,12,147,14],[151,12,151,14],[70,17,70,18],[112,17,112,18],[119,17,119,18],[168,15,168,16],[161,15,161,16],[141,17,141,18],[157,17,157,18],[147,17,147,18],[151,17,151,18],[147,15,147,16],[157,15,157,16],[141,15,141,16],[124,15,124,16],[119,15,119,16],[126,15,126,16],[116,15,116,16],[223,10,223,11],[225,10,225,11],[227,12,227,14],[238,15,238,16],[175,2,175,14],[186,6,186,7],[186,2,186,5],[193,10,193,11],[193,8,193,9],[190,6,190,7],[183,6,183,7],[184,6,184,7],[188,2,188,5],[188,6,188,7],[238,8,238,9],[238,10,238,11],[230,6,230,7],[229,2,229,5],[231,6,231,7],[223,2,223,5],[227,2,227,5],[225,2,225,9],[230,2,230,5],[229,6,229,7],[247,17,247,18],[263,17,263,18],[265,17,265,18],[263,15,263,16],[258,17,258,18],[265,8,265,9],[274,5,274,6],[272,5,272,6],[271,5,271,6],[258,12,258,14],[258,10,258,11],[269,5,269,6],[267,5,267,6],[247,15,247,16],[247,8,247,9],[249,6,249,7],[256,2,256,5],[266,5,266,6],[265,2,265,4],[257,2,257,5],[269,2,269,4],[274,2,274,4],[273,2,273,4],[271,2,271,4],[283,17,283,18],[258,15,258,16],[283,10,283,11],[273,5,273,6],[283,2,283,5],[266,2,266,4],[267,2,267,4],[268,5,268,6],[265,12,265,14],[275,2,275,4],[279,2,279,5],[276,5,276,6],[283,8,283,9],[276,17,276,18],[276,15,276,16],[283,15,283,16],[281,15,281,16],[283,12,283,14],[276,10,276,11],[275,5,275,6],[272,2,272,4],[268,2,268,4],[265,15,265,16],[265,10,265,11],[240,17,240,18],[245,17,245,18],[235,2,235,5],[234,2,234,5],[197,17,197,18],[212,17,212,18],[245,15,245,16],[212,10,212,11],[197,12,197,14],[197,10,197,11],[208,17,208,18],[238,17,238,18],[227,17,227,18],[208,12,208,14],[223,17,223,18],[223,12,223,14],[223,15,223,16],[227,15,227,16],[238,12,238,14],[240,15,240,16],[212,12,212,14],[240,2,240,14],[234,6,234,7],[227,10,227,11],[141,8,141,9],[139,2,139,4],[139,10,139,11],[141,10,141,11],[141,2,141,4],[151,10,151,11],[147,8,147,9],[147,10,147,11],[116,12,116,14],[149,10,149,11],[116,10,116,11],[141,12,141,14],[151,8,151,9],[116,8,116,9],[126,10,126,11],[119,2,119,14],[124,2,124,4],[124,10,124,11],[51,10,51,11],[49,8,49,9],[43,10,43,11],[81,10,81,11],[53,2,53,4],[53,8,53,9],[60,12,60,14],[41,2,41,5],[81,8,81,9],[49,12,49,14],[68,10,68,11],[60,8,60,9],[53,10,53,11],[49,10,49,11],[43,2,43,4],[49,2,49,4],[101,2,101,4],[101,8,101,9],[70,2,70,4],[53,12,53,14],[43,12,43,14],[7,17,7,18],[39,15,39,16],[14,17,14,18],[53,17,53,18],[43,15,43,16],[16,17,16,18],[31,15,31,16],[9,17,9,18],[14,2,14,4],[53,15,53,16],[49,15,49,16],[39,17,39,18],[51,2,51,5],[85,2,85,4],[39,2,39,4],[43,8,43,9],[39,8,39,9],[41,10,41,11],[39,10,39,11],[43,17,43,18],[49,17,49,18],[0,0,3,0],[1,18,2,18],[1,12,2,17],[1,1,2,11],[31,17,31,18],[27,17,27,18],[27,8,27,9],[27,2,27,4],[16,15,16,16],[16,2,16,4],[7,2,7,9],[7,10,7,11],[27,15,27,16],[9,2,9,16],[39,12,39,14],[31,12,31,14],[14,15,14,16],[14,10,14,11],[12,2,12,9],[16,8,16,9],[16,12,16,14],[29,2,29,4],[16,10,16,11],[5,2,5,9],[31,8,31,9],[31,10,31,11],[27,10,27,11],[29,10,29,11],[27,12,27,14],[31,2,31,4]]}
["23 / 03 / 2022"]
[null,"Amortissement des infrastructures \nd'évacuation et de dépollution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022]
[]
[]
[]
[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 \",S2)","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,null,null,null,{"$f":"902.74*1.025","v":925.30849999999998}]
[]
[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+D18*0.75)/600.88*$R$8","v":515.87396401943818},"=",{"$f":"(F18+G18+H18)*J18","v":0},"x",{"$f":"ROUND((1/$M$15*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L18*N18/100","v":0},"=",{"$f":"IF((G18*J18-G18*$J$18+H18*J18)*N18/100<0,0,(G18*J18-G18*$J$18+H18*J18)*N18/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(110+D19*0.75)/600.88*$R$8","v":631.36813506856606},"=",{"$f":"(F19+G19+H19)*J19","v":0},"x",{"$f":"ROUND((1/$M$15*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L19*N19/100","v":0},"=",{"$f":"IF((G19*J19-G19*$J$18+H19*J19)*N19/100<0,0,(G19*J19-G19*$J$18+H19*J19)*N19/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",746.86230611769406,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"600","mm",0,0,0,"x",862.35647716682206,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",977.85064821594995,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1093.3448192650778,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1208.8389903142058,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",1324.3331613633338,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",1439.8273324124616,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",1555.3215034615896,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F18:F27)","v":0},{"$f":"SUM(G18:G27)","v":0},{"$f":"SUM(H18:H27)","v":0},null,null,{"$f":"SUM(L18:L27)","v":0},null,null,null,null,{"$f":"SUM(Q18:Q27)","v":0},null,{"$f":"SUM(S18:S27)","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+D33*0.8)/600.88*$R$8","v":431.17823858341103},"=",{"$f":"(F33+G33+H33)*J33","v":0},"x",{"$f":"ROUND((1/$M$30*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L33*N33/100","v":0},"=",{"$f":"IF((G33*J33-G33*$J$18+H33*J33)*N33/100<0,0,(G33*J33-G33*$J$18+H33*J33)*N33/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(120+D34*0.8)/600.88*$R$8","v":492.77512980961251},"=",{"$f":"(F34+G34+H34)*J34","v":0},"x",{"$f":"ROUND((1/$M$30*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L34*N34/100","v":0},"=",{"$f":"IF((G34*J34-G34*$J$18+H34*J34)*N34/100<0,0,(G34*J34-G34*$J$18+H34*J34)*N34/100)","v":0}]
[null,null,null,"300 ","mm",0,0,0,"x",554.3720210358141,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"350 ","mm",0,0,0,"x",615.96891226201569,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"400","mm",0,0,0,"x",677.56580348821728,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"500","mm",0,0,0,"x",800.75958594062035,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","600","mm",0,0,0,"x",923.95336839302354,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F33:F39)","v":0},{"$f":"SUM(G33:G39)","v":0},{"$f":"SUM(H33:H39)","v":0},null,null,{"$f":"SUM(L33:L39)","v":0},null,null,null,null,{"$f":"SUM(Q33:Q39)","v":0},null,{"$f":"SUM(S33:S39)","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+(D45-D45*0.18-0.03)*1)/600.88*$R$8","v":391.86402275828783},"=",{"$f":"(F45+G45+H45)*J45","v":0},"x",{"$f":"ROUND((1/$M$42*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L45*N45/100","v":0},"=",{"$f":"IF((G45*J45-G45*$J$18+H45*J45)*N45/100<0,0,(G45*J45-G45*$J$18+H45*J45)*N45/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(70+(D46-D46*0.18-0.03)*1)/600.88*$R$8","v":423.43242951171618},"=",{"$f":"(F46+G46+H46)*J46","v":0},"x",{"$f":"ROUND((1/$M$42*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L46*N46/100","v":0},"=",{"$f":"IF((G46*J46-G46*$J$18+H46*J46)*N46/100<0,0,(G46*J46-G46*$J$18+H46*J46)*N46/100)","v":0}]
[null,null,null,"280","mm",0,0,0,"x",461.31451761583008,"=",{"$f":"(F47+G47+H47)*J47","v":0},"x",{"$f":"ROUND((1/$M$42*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L47*N47/100","v":0},"=",{"$f":"IF((G47*J47-G47*$J$18+H47*J47)*N47/100<0,0,(G47*J47-G47*$J$18+H47*J47)*N47/100)","v":0}]
[null,null,null,"315","mm",0,0,0,"x",505.51028707062977,"=",{"$f":"(F48+G48+H48)*J48","v":0},"x",{"$f":"ROUND((1/$M$42*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L48*N48/100","v":0},"=",{"$f":"IF((G48*J48-G48*$J$18+H48*J48)*N48/100<0,0,(G48*J48-G48*$J$18+H48*J48)*N48/100)","v":0}]
[null,null,"≥","355","mm",0,0,0,"x",556.01973787611507,"=",{"$f":"(F49+G49+H49)*J49","v":0},"x",{"$f":"ROUND((1/$M$42*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L49*N49/100","v":0},"=",{"$f":"IF((G49*J49-G49*$J$18+H49*J49)*N49/100<0,0,(G49*J49-G49*$J$18+H49*J49)*N49/100)","v":0}]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F45:F49)","v":0},{"$f":"SUM(G45:G49)","v":0},{"$f":"SUM(H45:H49)","v":0},null,null,{"$f":"SUM(L45:L49)","v":0},null,null,null,null,{"$f":"SUM(Q45:Q49)","v":0},null,{"$f":"SUM(S45:S49)","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+(D55-D55*0.18-0.03)*0.8)/600.88*$R$8","v":144.77733313806417},"=",{"$f":"(F55+G55+H55)*J55","v":0},"x",{"$f":"ROUND((1/$M$52*10000)/5,0)*5/100","v":1.35},"%","=",{"$f":"L55*N55/100","v":0},"=",{"$f":"IF((G55*J55-G55*$J$18+H55*J55)*N55/100<0,0,(G55*J55-G55*$J$18+H55*J55)*N55/100)","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(35+(D56-D56*0.18-0.03)*0.8)/600.88*$R$8","v":164.98111346025831},"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"125","mm",0,0,0,"x",180.13394870190388,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"160","mm",0,0,0,"x",215.49056426574353,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",235.69434458793768,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",281.15285031287448,"=",0,"x",1.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F55:F60)","v":0},{"$f":"SUM(G55:G60)","v":0},{"$f":"SUM(H55:H60)","v":0},null,null,{"$f":"SUM(L55:L60)","v":0},null,null,null,null,{"$f":"SUM(Q55:Q60)","v":0},null,{"$f":"SUM(S55:S60)","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":"P28+P61+P50+P40","v":0},null,{"$f":"R28+R61+R50+R40","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+D72*0.85)/600.88*$R$8","v":639.06774647184125},"=",{"$f":"(F72+G72+H72)*J72","v":0},"x",{"$f":"ROUND((1/$M$69*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L72*N72/100","v":0},"=",{"$f":"IF((G72*J72-G72*$J$72+H72*J72)*N72/100<0,0,(G72*J72-G72*$J$72+H72*J72)*N72/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(160+D73*0.85)/600.88*$R$8","v":769.96114032751962},"=",{"$f":"(F73+G73+H73)*J73","v":0},"x",{"$f":"ROUND((1/$M$69*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L73*N73/100","v":0},"=",{"$f":"IF((G73*J73-G73*$J$72+H73*J73)*N73/100<0,0,(G73*J73-G73*$J$72+H73*J73)*N73/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",900.85453418319787,"=",0,"x",1.65,"%","=",0,"=",{"$f":"IF((G74*J74-G74*$J$72+H74*J74)*N74/100<0,0,(G74*J74-G74*$J$72+H74*J74)*N74/100)","v":0}]
[null,null,null,"600","mm",0,0,0,"x",1031.7479280388764,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",1162.6413218945545,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1293.5347157502329,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1424.4281096059112,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",1555.3215034615896,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",1686.214897317268,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",1817.1082911729463,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F72:F81)","v":0},{"$f":"SUM(G72:G81)","v":0},{"$f":"SUM(H72:H81)","v":0},null,null,{"$f":"SUM(L72:L81)","v":0},null,null,null,null,{"$f":"SUM(Q72:Q81)","v":0},null,{"$f":"SUM(S72:S81)","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+D87*0.9)/600.88*$R$8","v":538.97279822926373},"=",{"$f":"(F87+G87+H87)*J87","v":0},"x",{"$f":"ROUND((1/$M$84*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L87*N87/100","v":0},"=",{"$f":"IF((G87*J87-G87*$J$72+H87*J87)*N87/100<0,0,(G87*J87-G87*$J$72+H87*J87)*N87/100)","v":0}]
[null,null,null,"300","mm",0,0,0,"x",{"$f":"(170+D88*0.9)/600.88*$R$8","v":677.56580348821728},"=",{"$f":"(F88+G88+H88)*J88","v":0},"x",{"$f":"ROUND((1/$M$84*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L88*N88/100","v":0},"=",{"$f":"IF((G88*J88-G88*$J$72+H88*J88)*N88/100<0,0,(G88*J88-G88*$J$72+H88*J88)*N88/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",816.15880874717084,"=",0,"x",{"$f":"ROUND((1/$M$84*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L89*N89/100","v":0},"=",{"$f":"IF((G89*J89-G89*$J$72+H89*J89)*N89/100<0,0,(G89*J89-G89*$J$72+H89*J89)*N89/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",954.75181400612428,"=",0,"x",{"$f":"ROUND((1/$M$84*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L90*N90/100","v":0},"=",0]
[null,null,"≥","600","mm",0,0,0,"x",1093.3448192650778,"=",0,"x",{"$f":"ROUND((1/$M$84*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L91*N91/100","v":0},"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F87:F91)","v":0},{"$f":"SUM(G87:G91)","v":0},{"$f":"SUM(H87:H91)","v":0},null,null,{"$f":"SUM(L87:L91)","v":0},null,null,null,null,{"$f":"SUM(Q87:Q91)","v":0},null,{"$f":"SUM(S87:S91)","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+(D97-D97*0.18-0.03)*1.1)/600.88*$R$8","v":497.26708310228338},"=",{"$f":"(F97+G97+H97)*J97","v":0},"x",{"$f":"ROUND((1/$M$94*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L97*N97/100","v":0},"=",{"$f":"IF((G97*J97-G97*$J$72+H97*J97)*N97/100<0,0,(G97*J97-G97*$J$72+H97*J97)*N97/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(120+(D98-D98*0.18-0.03)*1.1)/600.88*$R$8","v":531.99233053105445},"=",{"$f":"(F98+G98+H98)*J98","v":0},"x",{"$f":"ROUND((1/$M$94*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L98*N98/100","v":0},"=",{"$f":"IF((G98*J98-G98*$J$72+H98*J98)*N98/100<0,0,(G98*J98-G98*$J$72+H98*J98)*N98/100)","v":0}]
[null,null,null,"280","mm",0,0,0,"x",573.6626274455798,"=",0,"x",{"$f":"ROUND((1/$M$94*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L99*N99/100","v":0},"=",{"$f":"IF((G99*J99-G99*$J$72+H99*J99)*N99/100<0,0,(G99*J99-G99*$J$72+H99*J99)*N99/100)","v":0}]
[null,null,null,"315","mm",0,0,0,"x",622.27797384585949,"=",0,"x",{"$f":"ROUND((1/$M$94*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L100*N100/100","v":0},"=",0]
[null,null,"≥","355","mm",0,0,0,"x",677.83836973189329,"=",0,"x",{"$f":"ROUND((1/$M$94*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L101*N101/100","v":0},"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F97:F101)","v":0},{"$f":"SUM(G97:G101)","v":0},{"$f":"SUM(H97:H101)","v":0},null,null,{"$f":"SUM(L97:L101)","v":0},null,null,null,null,{"$f":"SUM(Q97:Q101)","v":0},null,{"$f":"SUM(S97:S101)","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+(D107-D107*0.18-0.03)*0.9)/600.88*$R$8","v":248.53267664175877},"=",{"$f":"(F107+G107+H107)*J107","v":0},"x",{"$f":"ROUND((1/$M$104*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L107*N107/100","v":0},"=",{"$f":"IF((G107*J107-G107*$J$72+H107*J107)*N107/100<0,0,(G107*J107-G107*$J$72+H107*J107)*N107/100)","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(95+(D108-D108*0.18-0.03)*0.9)/600.88*$R$8","v":271.26192950422717},"=",{"$f":"(F108+G108+H108)*J108","v":0},"x",2,"%","=",0,"=",{"$f":"IF((G108*J108-G108*$J$72+H108*J108)*N108/100<0,0,(G108*J108-G108*$J$72+H108*J108)*N108/100)","v":0}]
[null,null,null,"125","mm",0,0,0,"x",288.3088691510784,"=",0,"x",2,"%","=",0,"=",{"$f":"IF((G109*J109-G109*$J$72+H109*J109)*N109/100<0,0,(G109*J109-G109*$J$72+H109*J109)*N109/100)","v":0}]
[null,null,null,"160","mm",0,0,0,"x",328.08506166039808,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",350.81431452286643,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",401.95513346342034,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F107:F112)","v":0},{"$f":"SUM(G107:G112)","v":0},{"$f":"SUM(H107:H112)","v":0},null,null,{"$f":"SUM(L107:L112)","v":0},null,null,null,null,{"$f":"SUM(Q107:Q112)","v":0},null,{"$f":"SUM(S107:S112)","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,0,null,null,null,null,null,"x",{"$f":"ROUND((1800/600.88*$R$8)/10,0)*10","v":2770},"=",{"$f":"C118*J118","v":0},"x",{"$f":"ROUND((1/$M$115*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L118*N118/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":"P82+P92+P102+P113+Q118","v":0},null,{"$f":"R82+R92+R102+R113+S118","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+D128*0.85)/600.88*$R$8","v":823.85842015044602},"=",{"$f":"(F128+G128+H128)*J128","v":0},"x",{"$f":"ROUND((1/$M$125*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L128*N128/100","v":0},"=",{"$f":"IF((G128*J128-G128*$J$128+H128*J128)*N128/100<0,0,(G128*J128-G128*$J$128+H128*J128)*N128/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",{"$f":"(280+D129*0.85)/600.88*$R$8","v":954.75181400612428},"=",{"$f":"(F129+G129+H129)*J129","v":0},"x",{"$f":"ROUND((1/$M$125*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L129*N129/100","v":0},"=",{"$f":"IF((G129*J129-G129*$J$128+H129*J129)*N129/100<0,0,(G129*J129-G129*$J$128+H129*J129)*N129/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",1085.6452078618029,"=",0,"x",1.65,"%","=",0,"=",{"$f":"IF((G130*J130-G130*$J$128+H130*J130)*N130/100<0,0,(G130*J130-G130*$J$128+H130*J130)*N130/100)","v":0}]
[null,null,null,"600","mm",0,0,0,"x",1216.538601717481,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"700","mm",0,0,0,"x",1347.4319955731594,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"800","mm",0,0,0,"x",1478.3253894288378,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"900","mm",0,0,0,"x",1609.2187832845161,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1000","mm",0,0,0,"x",1740.1121771401945,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,null,"1100","mm",0,0,0,"x",1871.0055709958729,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"≥","1200","mm",0,0,0,"x",2001.898964851551,"=",0,"x",1.65,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F128:F137)","v":0},{"$f":"SUM(G128:G137)","v":0},{"$f":"SUM(H128:H137)","v":0},null,null,{"$f":"SUM(L128:L137)","v":0},null,null,null,null,{"$f":"SUM(Q128:Q137)","v":0},null,{"$f":"SUM(S128:S137)","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+D143*0.9)/600.88*$R$8","v":723.76347190786851},"=",{"$f":"(F143+G143+H143)*J143","v":0},"x",{"$f":"ROUND((1/$M$140*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L143*N143/100","v":0},"=",{"$f":"IF((G143*J143-G143*$J$128+H143*J143)*N143/100<0,0,(G143*J143-G143*$J$128+H143*J143)*N143/100)","v":0}]
[null,null,null,"300","mm",0,0,0,"x",{"$f":"(290+D144*0.9)/600.88*$R$8","v":862.35647716682206},"=",{"$f":"(F144+G144+H144)*J144","v":0},"x",{"$f":"ROUND((1/$M$140*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L144*N144/100","v":0},"=",{"$f":"IF((G144*J144-G144*$J$128+H144*J144)*N144/100<0,0,(G144*J144-G144*$J$128+H144*J144)*N144/100)","v":0}]
[null,null,null,"400","mm",0,0,0,"x",1000.9494824257755,"=",0,"x",{"$f":"ROUND((1/$M$140*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L145*N145/100","v":0},"=",{"$f":"IF((G145*J145-G145*$J$128+H145*J145)*N145/100<0,0,(G145*J145-G145*$J$128+H145*J145)*N145/100)","v":0}]
[null,null,null,"500","mm",0,0,0,"x",1139.5424876847292,"=",0,"x",{"$f":"ROUND((1/$M$140*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L146*N146/100","v":0},"=",0]
[null,null,null,"600","mm",0,0,0,"x",1278.1354929436825,"=",0,"x",{"$f":"ROUND((1/$M$140*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L147*N147/100","v":0},"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F143:F147)","v":0},{"$f":"SUM(G143:G147)","v":0},{"$f":"SUM(H143:H147)","v":0},null,null,{"$f":"SUM(L143:L147)","v":0},null,null,null,null,{"$f":"SUM(Q143:Q147)","v":0},null,{"$f":"SUM(S143:S147)","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+(D153-D153*0.18-0.03)*1.1)/600.88*$R$8","v":682.05775678088798},"=",{"$f":"(F153+G153+H153)*J153","v":0},"x",{"$f":"ROUND((1/$M$150*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L153*N153/100","v":0},"=",{"$f":"IF((G153*J153-G153*$J$128+H153*J153)*N153/100<0,0,(G153*J153-G153*$J$128+H153*J153)*N153/100)","v":0}]
[null,null,null,"250","mm",0,0,0,"x",{"$f":"(240+(D154-D154*0.18-0.03)*1.1)/600.88*$R$8","v":716.78300420965911},"=",{"$f":"(F154+G154+H154)*J154","v":0},"x",{"$f":"ROUND((1/$M$150*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L154*N154/100","v":0},"=",{"$f":"IF((G154*J154-G154*$J$128+H154*J154)*N154/100<0,0,(G154*J154-G154*$J$128+H154*J154)*N154/100)","v":0}]
[null,null,null,"280","mm",0,0,0,"x",758.45330112418458,"=",0,"x",{"$f":"ROUND((1/$M$150*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L155*N155/100","v":0},"=",{"$f":"IF((G155*J155-G155*$J$128+H155*J155)*N155/100<0,0,(G155*J155-G155*$J$128+H155*J155)*N155/100)","v":0}]
[null,null,null,"315","mm",0,0,0,"x",807.06864752446427,"=",0,"x",{"$f":"ROUND((1/$M$150*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L156*N156/100","v":0},"=",0]
[null,null,"≥","355","mm",0,0,0,"x",862.62904341049807,"=",0,"x",{"$f":"ROUND((1/$M$150*10000)/5,0)*5/100","v":1.65},"%","=",{"$f":"L157*N157/100","v":0},"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F153:F157)","v":0},{"$f":"SUM(G153:G157)","v":0},{"$f":"SUM(H153:H157)","v":0},null,null,{"$f":"SUM(L153:L157)","v":0},null,null,null,null,{"$f":"SUM(Q153:Q157)","v":0},null,{"$f":"SUM(S153:S157)","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+(D163-D163*0.18-0.03)*0.9)/600.88*$R$8","v":325.52879067451067},"=",{"$f":"(F163+G163+H163)*J163","v":0},"x",{"$f":"ROUND((1/$M$160*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L163*N163/100","v":0},"=",{"$f":"IF((G163*J163-G163*$J$128+H163*J163)*N163/100<0,0,(G163*J163-G163*$J$128+H163*J163)*N163/100)","v":0}]
[null,null,null,"110","mm",0,0,0,"x",{"$f":"(145+(D164-D164*0.18-0.03)*0.9)/600.88*$R$8","v":348.25804353697913},"=",{"$f":"(F164+G164+H164)*J164","v":0},"x",2,"%","=",0,"=",{"$f":"IF((G164*J164-G164*$J$128+H164*J164)*N164/100<0,0,(G164*J164-G164*$J$128+H164*J164)*N164/100)","v":0}]
[null,null,null,"125","mm",0,0,0,"x",365.30498318383042,"=",0,"x",2,"%","=",0,"=",{"$f":"IF((G165*J165-G165*$J$128+H165*J165)*N165/100<0,0,(G165*J165-G165*$J$128+H165*J165)*N165/100)","v":0}]
[null,null,null,"160","mm",0,0,0,"x",405.08117569315004,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,"180","mm",0,0,0,"x",427.81042855561844,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"≥","225","mm",0,0,0,"x",478.95124749617236,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F163:F168)","v":0},{"$f":"SUM(G163:G168)","v":0},{"$f":"SUM(H163:H168)","v":0},null,null,{"$f":"SUM(L163:L168)","v":0},null,null,null,null,{"$f":"SUM(Q163:Q168)","v":0},null,{"$f":"SUM(S163:S168)","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,0,null,null,null,null,null,"x",{"$f":"ROUND((2400/600.88*$R$8)/10,0)*10","v":3700},"=",{"$f":"C174*J174","v":0},"x",{"$f":"ROUND((1/$M$171*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L174*N174/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":"P138+P148+P158+P169+Q174","v":0},null,{"$f":"R138+R148+R158+R169+S174","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(G184=0,0,(14000*G184^-0.4)/600.88*$R$8)","v":0},"=",{"$f":"G184*J184","v":0},"x",{"$f":"ROUND((1/$M$181*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L184*N184/100","v":0},"=",{"$f":"L184*N184/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G185=0,0,(14000*G185^-0.4)/600.88*$R$8)","v":0},"=",0,"x",{"$f":"ROUND((1/$M$181*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L185*N185/100","v":0},"=",{"$f":"L185*N185/100","v":0}]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G186*J186","v":0},"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H184:H193)","v":0},null,null,null,{"$f":"SUM(L184:L193)","v":0},null,null,null,null,{"$f":"SUM(Q184:Q193)","v":0},null,{"$f":"SUM(S184:S193)","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(G199=0,0,(39000*G199^-(8/15))/600.88*$R$8)","v":0},"=",{"$f":"G199*J199","v":0},"x",{"$f":"ROUND((1/$M$196*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L199*N199/100","v":0},"=",{"$f":"L199*N199/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G200=0,0,(39000*G200^-(8/15))/600.88*$R$8)","v":0},"=",{"$f":"G200*J200","v":0},"x",{"$f":"ROUND((1/$M$196*10000)/5,0)*5/100","v":2.5},"%","=",{"$f":"L200*N200/100","v":0},"=",{"$f":"L200*N200/100","v":0}]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2.5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H199:H208)","v":0},null,null,null,{"$f":"SUM(L199:L208)","v":0},null,null,null,null,{"$f":"SUM(Q199:Q208)","v":0},null,{"$f":"SUM(S199:S208)","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(G214=0,0,(80+11000*G214^-1)/600.88*$R$8)","v":0},"=",{"$f":"G214*J214","v":0},"x",{"$f":"ROUND((1/$M$211*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L214*N214/100","v":0},"=",{"$f":"L214*N214/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G215=0,0,(80+11000*G215^-1)/600.88*$R$8)","v":0},"=",{"$f":"G215*J215","v":0},"x",{"$f":"ROUND((1/$M$211*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L215*N215/100","v":0},"=",{"$f":"L215*N215/100","v":0}]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H214:H223)","v":0},null,null,null,{"$f":"SUM(L214:L223)","v":0},null,null,null,null,{"$f":"SUM(Q214:Q223)","v":0},null,{"$f":"SUM(S214:S223)","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(G229=0,0,(11000*G229^-0.4)/600.88*$R$8)","v":0},"=",{"$f":"G229*J229","v":0},"x",{"$f":"ROUND((1/$M$226*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L229*N229/100","v":0},"=",{"$f":"L229*N229/100","v":0}]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G230=0,0,(11000*G230^-0.4)/600.88*$R$8)","v":0},"=",{"$f":"G230*J230","v":0},"x",{"$f":"ROUND((1/$M$226*10000)/5,0)*5/100","v":2},"%","=",{"$f":"L230*N230/100","v":0},"=",{"$f":"L230*N230/100","v":0}]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",2,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H229:H238)","v":0},null,null,null,{"$f":"SUM(L229:L238)","v":0},null,null,null,null,{"$f":"SUM(Q229:Q238)","v":0},null,{"$f":"SUM(S229:S238)","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":"P194+P209+P224+P239","v":0},null,{"$f":"R194+R209+R224+R239","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(G249=0,0,17000*G249^-0.65)/600.88*$R$8","v":0},"=",{"$f":"G249*J249","v":0},"x",{"$f":"ROUND((1/$M$246*10000)/5,0)*5/100","v":5},"%","=",{"$f":"L249*N249/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",{"$f":"IF(G250=0,0,17000*G250^-0.65)/600.88*$R$8","v":0},"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",0,"x",5,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,null,{"$f":"SUM(H249:H258)","v":0},null,null,null,{"$f":"SUM(L249:L258)","v":0},null,null,null,null,{"$f":"SUM(Q249:Q258)","v":0},null,{"$f":"SUM(S249:S258)","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(F267=0,0,(16000*F267^-0.35)/600.88*$R$8)","v":0},"=",{"$f":"F267*J267","v":0},"x",{"$f":"ROUND((1/$M$264*10000)/5,0)*5/100","v":3.35},"%","=",{"$f":"L267*N267/100","v":0},"=",{"$f":"L267*N267/100-IF(H267<=0,0,(16000*IF(H267>F267,F267,H267)^-0.35)/600.88*$R$8)*IF(H267>F267,F267,H267)*N267/100","v":0}]
[null,null,null,null,null,0,null,0,"x",{"$f":"IF(F268=0,0,(16000*F268^-0.35)/600.88*$R$8)","v":0},"=",0,"x",{"$f":"ROUND((1/$M$264*10000)/5,0)*5/100","v":3.35},"%","=",{"$f":"L268*N268/100","v":0},"=",{"$f":"L268*N268/100-IF(H268<=0,0,(16000*IF(H268>F268,F268,H268)^-0.35)/600.88*$R$8)*IF(H268>F268,F268,H268)*N268/100","v":0}]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",{"$f":"L269*N269/100-IF(H269<=0,0,(16000*IF(H269>F269,F269,H269)^-0.35)/600.88*$R$8)*IF(H269>F269,F269,H269)*N269/100","v":0}]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,null,null,null,0,null,0,"x",0,"=",0,"x",3.35,"%","=",0,"=",0]
[null,null,"Valeurs totales :",null,null,{"$f":"SUM(F267:F276)","v":0},null,{"$f":"SUM(H267:H276)","v":0},null,null,{"$f":"SUM(L267:L276)","v":0},null,null,null,null,{"$f":"SUM(Q267:Q276)","v":0},null,{"$f":"SUM(S267:S276)","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":"G285*J285","v":0},"x",0,"%","=",{"$f":"L285*N285/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G286*J286","v":0},"x",0,"%","=",{"$f":"L286*N286/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G287*J287","v":0},"x",0,"%","=",{"$f":"L287*N287/100","v":0},"=",0]
[null,null,null,null,null,null,0,null,"x",0,"=",{"$f":"G288*J288","v":0},"x",0,"%","=",{"$f":"L288*N288/100","v":0},"=",0]
[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,"Valeurs totales :",null,null,null,null,null,null,null,{"$f":"SUM(L285:L289)","v":0},null,null,null,null,{"$f":"SUM(Q285:Q289)","v":0},null,{"$f":"SUM(S285:S289)","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":"K28+K40+K50+K61+K82+K92+K102+K113+L118+K138+K148+K158+K169+L174+K194+K209+K224+K239+K259+K277+K290","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":"P64+P120+P176+P241+P259+P277+P290","v":0},null,{"$f":"R64+R120+R176+R241+R259+R277+R290","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":"P299*R10","v":0},null,{"$f":"R299*R10","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":"P64*0.12+P120*0.12+P176*0.14+P241*0.16+P259*0.16+P277*0.16+P290*0.16","v":0},null,{"$f":"R64*0.12+R120*0.12+R176*0.14+R241*0.16+R259*0.16+R277*0.16+R290*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":"P301*R10","v":0},null,{"$f":"R301*R10","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":"P299+P300+P301+P302","v":0},null,{"$f":"R299+R300+R301+R302","v":0}]