les rgles suivre

Catgorie4me3me2me1reexcepCatgorie4me3me2me1reexcepVr (Km/h)406080100120Vr (Km/h)406080100120Distance d'arrt Da (m)en alignement4070105160230Catgorie4me3me2me1reexcepen courbe4580120180275Dclivit imax (%)87654

Vr (Km/h)60donc Catgorie de la route3meimax (%)imaxDclivit imax (%)70.07

Distance d'arrt Da (m)en alignement70Longueur min d (m)en alignement150en courbe80en courbe170

Variante

1er variantepointaltitudepente et distancedistance de visibilt de confortarayon minimal pour dmax=7% longueur clothoide XET XmA238i10.16710.000d180.544.03B218d16.0120.0a1152R138.181.91L125.761.29E10.72T1156.027.80Xm112.880.640.33731826790.1447974089B218i20.0414.091d293.314.67ERROR:#DIV/0!0C209d211.0220.0a2161R238.181.91L225.761.29E20.72T2232.4611.62Xm212.880.640.33731826790.1447974089C209i30.0636.250d3197.469.87ERROR:#DIV/0!0D194d312.0240.0a346.5R3123.256.16L341.162.06E30.57T353.202.66Xm320.581.030.16697778220.1145426077D194i40.0757.500d4190.849.54ERROR:#DIV/0!0E170d416.0320.0a429R4123.256.16L441.162.06E40.57T432.021.60Xm420.581.030.16697778220.1145426077E170i50.0434.348d5209.0910.45ERROR:#DIV/0!0F160d511.5230.0a511R5123.256.16L541.162.06E50.57T511.920.60Xm520.581.030.16697778220.1145426077F160i60.0323.214d6217.1210.86ERROR:#DIV/0!0G151d614.0280.0a654R6123.256.16L641.162.06E60.57T663.093.15Xm620.581.030.16697778220.1145426077G151i7-0.058-5.833d7345.3817.27ERROR:#DIV/0!0H158d76.0120.0sr569.34sd76.5Nbr6f10.250158f20.16120151vr140.00400160vr260.00630170L07.00950194119020914102181530238

2eme variantepointaltitudepente et distancedistance de visibilt de confortarayon minimal pour dmax=7% longueur clothoide XET XmH238i10.0575.714d191.074.55G230d17.0140.0a1124R139.371.97L126.071.30E10.72T175.403.77Xm113.040.65G230i20.0595.882d2199.559.98F220d28.5170.0a219R2123.256.16L241.162.06E20.57T220.721.04Xm220.581.03F220i30.0616.122d3198.189.91E208d39.8196.0a328R3123.256.16L341.162.06E30.57T330.871.54Xm320.581.03E208i40.13910.000d4165.588.28D176d411.5230.0a445R4123.256.16L441.162.06E40.57T451.292.56Xm420.581.03D176i50.0434.255d5209.7210.49C164d514.1282.0a520R5123.256.16L541.162.06E50.57T521.831.09Xm520.581.03C164i60.0616.132d6198.129.91B151d610.6212.0a633R6123.256.16L641.162.06E60.57T636.681.83Xm620.581.03B151i7-0.0-2.8d7282.6614.13A158d712.0240.0Sd73.5Sr655.60Nbr6f10.25f20.16vr140.00vr260.00L07.001002040DistanceAltitude0158212.0151494.0164724.0176920.02081090.02301230.0238.8

Feuil1

Numro du profil Distances partielles(ml)Distances d'applications(ml)Surface(m2)Volume(m3)Volume Total(m3)12345678910111213DblaisRemblaisDblaisRemblaisDblaisRemblaisGaucheDroiteGaucheDroiteGaucheDroiteGaucheDroite

58.84511829.44.02412.988900118.30887.87300206.1810228.551.9005.54291.898400287.6798.5260386.19633031.51.19480.01430.68732.176737.6360.4521.6568.56638.08690.216423.251.46321.50520.2933034.01934.9966.819069.0156.819529.53.88260.61240.08120.1124114.53618.06182.3953.3158132.6015.71086157.13428.004200107.013120.06300227.0760Total672.959488.9418

Feuil2

Ndu profilCubes des dblais pour chaque profilFoisonnementCubes dfinitifs des dblaisCubes des remblais pour chaque profilsCubes employer dans la longueur rpondant chaque profilExcs des cubes des remblais sur les dblaisExcs des cubes des dblais sur les remblais DEBLAIS en excsEMPRUT pour remblaisIndication des lieux de dpt ou demploi des dblais en excsDistance de transportTransportsObservationsA porter en remblais sue la routeA porter en dpt ou rserv pour un autre usage A la pelle Au camionCubesProduits des cubes par les distancescubesProduits des cubes par les distances1234567891011121314151617dm=68.62m1206.241.23247.4000247.4247.4-247.4m3P1versP258.8--247.414547.12000386.20386.20--------338.087.6145.790.2145.744.510--------469.0113.8082.826.826.8207631.5-44.5m3P4versP31831.5567--44.531.5m3P4versP263--44.52801.55132.626.5159.15.7115.7110153.41107.346.11107.3m3P5versP391.5--107.39817.946.11m3P5versdept100--46.1146116227.145.41272.5000272.5-272.5272.5m3P6versdept70--272.519075Tot672.9134.6942.148958.231430.7748.3131.5567717.8150852.5