Cross section in excel
Download as PPTX, PDF
1 like721 views
This document contains information about how to set a print area and print out a cross section sheet in Excel. It includes a sample cross section with elevation and distance values for various points along the section including the toe points on the left and right sides. It also shows calculations for determining the slope stakes at the toe points based on the horizontal and vertical distances.
Cross section in excel
- 1. How to Set Print Area And How to Print out Cross Section Sheet How To Draw Cross Section In Excel How to Set Print Area And How to Print out Cross Section Sheet How To Draw Cross Section In Excel Project 1.253 0.505 3.389 Area of SubBase Area of Embecment (Fill) Area of Embecment (Cut)Area of Agregate Base Course(WBM) Surveying Engineering Design Information Consulant Subscribe Channel Area Of Asphat Wearing Course Area Of Asphalt Base Course 3.764 60.874 - NSL -20.320 213.500 NSL -18.500 213.127 NSL -14.5 212.9 NSL -5.731 212.740 NSL 0.000 213.111 NSL 1.386 213.194 NSL 8.890 213.194 NSL 13.900 213.194 NSL 20.000 213.245 Toe PointLS -15.937 212.982 FRL -10.000 215.950 FRL -5.000 216.050 FRL 0.000 216.150 FRL 5.000 216.050 FRL 10.000 215.950 Toe Point RS 15.485 213.207 Sub Grade -11.589 215.156 Sub Grade -10.000 215.180 Sub Grade -5.000 215.280 Sub Grade 0.000 215.380 Sub Grade 5.000 215.280 Sub Grade 10.000 215.180 Sub Grade 11.589 215.156 212.000 213.000 214.000 215.000 216.000 217.000 -23 -22 -21 -20 -19 -18 -17 -16 -15 -14 -13 -12 -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Elevations Distance 0+000 NSL FRL ABC WBM Sub Base Sub Grade Remaning Fill Remani ngFill Remaning Fill Remaning Fill 0.170 0.470 0.770 Distance Elevation Distance (X) Elevation (Y) Distance (X) Elevation (Y) Toe Point Distance (X) Elevation (Y) Toe Point Distance (X) Elevation (Y) Toe Point Distance (X) Elevation (Y) Toe Point -20.320 213.500 -15.937 212.982 -10.100 215.898 0.100 -10.340 215.773 0.340 -10.958 215.471 -11.589 215.156 1.540 -18.500 213.127 -10.000 215.950 -10.000 215.900 -0.002 -10.000 215.780 -0.007 -10.000 215.480 0.000 -10.000 215.180 -0.031 -14.5 212.9 -5.000 216.050 -5.000 216.000 -5.000 215.880 -5.000 215.580 -5.000 215.280 -5.731 212.740 0.000 216.150 0.000 216.100 0.000 215.980 0.000 215.680 0.000 215.380 0.000 213.111 5.000 216.050 5.000 216.000 5.000 215.880 5.000 215.580 5.000 215.280 1.386 213.194 10.000 215.950 10.000 215.900 10.000 215.780 10.000 215.480 10.000 215.180 8.890 213.194 15.485 213.207 10.100 215.898 0.100 10.340 215.773 0.340 10.958 215.471 0.958 11.589 215.156 1.589 13.900 213.194 20.000 213.245 0.050 0.120 0.300 0.300 Embecment NSL FRL(FINSH ROAD LEVEL) (AWC) Asphalt Base Course(ABC) DesignPavement(RoadStrucures) 0+000 Base Course(WBM) Aggregate Sub Base Sub Grade Slope Slope X = X= Y = Y= Z = Z= Distt= Distt= Ele = Ele= RightSideToeElevation= 213.207 TOEFORRIGHTSIDESECTION CALCULATIONOFSLOPESTAKE TOEFORLEFTSIDESECTION 0.500 Horizantal Vertical 10.000 2 1 NSL PGL Distance Elevation Distance ElevationDistance 14.500 18.500 15.485 Qa isa r Ma l ik RightSideToeDistance= 13.900 213.194 10.000 215.95020.000 213.245 CALCULATIONOFSLOPESTAKE SLOPE 2.789 2.295 15.48548855 NSL SLOPE Horizantal Vertical 15.93691064 212.9815447 CALCULATIONOFSLOPESTAKE 1.427 LeftSideToeDistance= -15.937 LeftSideToeElevation= 212.982 Qa isa r Ma l ik 3.305 2 1 0.500 8.500 215.950 213.2072557 FRL Distance Elevation 10.000 Elevation 212.900 213.127 HowtoSetPrintAreaAndHowtoPrintoutCrossSectionSheet HowToDrawCrossSectionInExcel