EXCEL畫道路道路開挖橫斷面、自動計算斷面面積、體積

,,,,,,復(fù)制到CAD,斷面面積,兩個斷面體積

,,,,,,pl,,

K1+500,中樁,設(shè)計標高,0,",",91.65,"0,91.65",18.90,161.88

,中樁,地面標高,0,",",89.8,"0,89.8",,

,邊柱,地面標高,10.5,",",89.75,"10.5,89.75",,

,邊樁,設(shè)計標高,10.5,",",91.5,"10.5,91.5",,

,中樁,設(shè)計標高,0,",",91.65,"0,91.65",,

,,,,,,,0.00,

,,,,,,ucs,,

,,,,,,n,,

,,,,,,"13,0",,

,,,,,,pl,,

K1+510,中樁,設(shè)計標高,0,",",91.37,"0,91.37",13.48,134.03

,中樁,地面標高,0,",",90.123,"0,90.123",,

,邊柱,地面標高,10.5,",",89.9,"10.5,89.9",,

,邊樁,設(shè)計標高,10.5,",",91.22,"10.5,91.22",,

,中樁,設(shè)計標高,0,",",91.37,"0,91.37",,

,,,,,,,0.00,

,,,,,,ucs,,

,,,,,,n,,

,,,,,,"13,0",,

,,,,,,pl,,

K1+520,中樁,設(shè)計標高,0,",",91.129,"0,91.129",13.33,128.81

,中樁,地面標高,0,",",89.8,"0,89.8",,

,邊柱,地面標高,10.5,",",89.76,"10.5,89.76",,

,邊樁,設(shè)計標高,10.5,",",90.97,"10.5,90.97",,

,中樁,設(shè)計標高,0,",",91.129,"0,91.129",,

,,,,,,,0.00,

,,,,,,ucs,,

,,,,,,n,,

,,,,,,"13,0",,

,,,,,,pl,,

K1+530,中樁,設(shè)計標高,0,",",90.884,"0,90.884",12.43,107.02

,中樁,地面標高,0,",",89.66,"0,89.66",,

,邊柱,地面標高,10.5,",",89.66,"10.5,89.66",,

,邊樁,設(shè)計標高,10.5,",",90.804,"10.5,90.804",,

,中樁,設(shè)計標高,0,",",90.884,"0,90.884",,

,,,,,,,0.00,

,,,,,,ucs,,

,,,,,,n,,

,,,,,,"13,0",,

,,,,,,pl,,

K1+540,中樁,設(shè)計標高,0,",",90.638,"0,90.638",8.97,87.18

,中樁,地面標高,0,",",89.68,"0,89.68",,

,邊柱,地面標高,10.5,",",89.75,"10.5,89.75",,

,邊樁,設(shè)計標高,10.5,",",90.501,"10.5,90.501",,

,中樁,設(shè)計標高,0,",",90.638,"0,90.638",,

,,,,,,,0.00,

,,,,,,ucs,,

,,,,,,n,,

,,,,,,"13,0",,

,,,,,,pl,,

K1+550,中樁,設(shè)計標高,0,",",90.456,"0,90.456",8.46,618.92

,中樁,地面標高,0,",",89.7,"0,89.7",,

,邊柱,地面標高,10.5,",",89.45,"10.5,89.45",,