EXCEL版衡重式挡土墙计算

衡重式挡土墙计算软件,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,衡重式挡土墙断面图示

一：挡土墙数据编辑栏,,,,,,,,,,,,,,二：挡土墙截面数据二：挡土墙截面数据,,,,,,,,,,,,,,,,,,,,,,,,

里程,距离,"墙高

（H）","上墙高

（H1）","下墙背高

（H2）","墙顶宽

（B）","墙趾宽

（DL）","墙趾高

（DH）","上墙背坡

斜率N1","下墙背坡

斜率N2","基底倾斜

N3","墙面坡

斜率N","台宽

（B1）",,挡土墙全高（HH）,上墙高（H1）,下墙背高（H2）,墙顶宽（B）,墙趾宽（DL）,墙趾高（DH）,上墙背坡斜率N1,"下墙背坡

斜率N2","基底倾斜

N3","墙面坡

斜率N",台宽（B1）,上墙底宽（B11）,下墙底宽（B21）,后墙趾高（DH1）,基础全宽（B2）,下墙高（DH2）,上墙面积（平方米）,下墙面积(平方米）,基础面积(平方米）,总体面积(平方米）,"上墙体积

（立方米）","下墙体积

(立方米）","基础体积

(立方米）","总体体积

(立方米）",

,m,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

K585+671.25,8.75,5.489,2.400,4.247,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.647,2.400,4.247,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.167,1.158,2.580,3.089,3.096,7.408,2.769,13.273,27.09,62.82,24.39,114.29,

K585+680X,,5.279,2.400,4.040,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.440,2.400,4.040,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.198,1.161,2.611,2.879,3.096,6.950,2.805,12.851,,,,,

K585+680D,10.00,5.464,2.400,4.222,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.622,2.400,4.222,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.170,1.158,2.584,3.064,3.096,7.354,2.773,13.223,30.96,70.92,27.94,129.82,

K585+690X,,5.224,2.400,3.986,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.386,2.400,3.986,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.206,1.162,2.619,2.824,3.096,6.829,2.815,12.740,,,,,

K585+690D,10.00,5.797,2.400,4.550,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.950,2.400,4.550,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.120,1.153,2.535,3.397,3.096,8.069,2.715,13.880,30.96,78.12,27.36,136.44,

K585+700X,,5.557,2.400,4.314,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.714,2.400,4.314,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.156,1.157,2.570,3.157,3.096,7.555,2.757,13.408,,,,,

K585+700D,10.00,6.152,2.800,4.744,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.544,2.800,4.744,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.447,1.392,2.924,3.352,4.060,9.046,3.807,16.913,40.60,87.50,38.32,166.42,

K585+710X,,5.912,2.800,4.508,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.308,2.800,4.508,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.483,1.396,2.959,3.112,4.060,8.454,3.857,16.371,,,,,

K585+710D,10.00,6.507,2.800,5.094,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.894,2.800,5.094,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.394,1.387,2.872,3.707,4.060,9.905,3.733,17.698,40.60,96.16,37.58,174.34,

K585+720X,,6.267,2.800,4.857,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.657,2.800,4.857,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.430,1.391,2.907,3.467,4.060,9.326,3.783,17.169,,,,,

K585+720D,10.00,6.468,2.800,5.056,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.856,2.800,5.056,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.400,1.388,2.877,3.668,4.060,9.812,3.741,17.613,40.60,95.21,37.66,173.48,

K585+730X,,6.228,2.800,4.820,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.620,2.800,4.820,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.436,1.391,2.912,3.428,4.060,9.231,3.791,17.082,,,,,

K585+730D,10.00,6.430,2.800,5.018,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.818,2.800,5.018,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.406,1.388,2.883,3.630,4.060,9.720,3.749,17.529,40.60,94.29,37.74,172.64,

K585+740X,,6.190,2.800,4.782,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.582,2.800,4.782,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.442,1.392,2.918,3.390,4.060,9.139,3.799,16.998,,,,,

K585+740D,10.00,6.190,2.800,4.782,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.582,2.800,4.782,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.442,1.392,2.918,3.390,4.060,9.139,3.799,16.998,40.60,88.43,38.24,167.28,

K585+750X,,5.950,2.800,4.546,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,,7.346,2.800,4.546,0.750,0.700,1.100,0.450,0.200,0.100,0.050,0.800,2.150,2.478,1.395,2.953,3.150,4.060,8.548,3.849,16.457,,,,,

K585+750D,10.00,5.788,2.400,4.541,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.941,2.400,4.541,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.122,1.154,2.536,3.388,3.096,8.050,2.717,13.863,30.96,77.93,27.38,136.27,

K585+760X,,5.548,2.400,4.305,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.705,2.400,4.305,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.158,1.157,2.571,3.148,3.096,7.536,2.759,13.391,,,,,

K585+760D,10.00,5.441,2.400,4.200,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.600,2.400,4.200,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.174,1.159,2.587,3.041,3.096,7.304,2.777,13.177,30.96,70.41,27.98,129.35,

K585+770X,,5.201,2.400,3.963,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.363,2.400,3.963,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.210,1.162,2.622,2.801,3.096,6.778,2.819,12.693,,,,,

K585+770D,10.00,5.257,2.400,4.018,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.418,2.400,4.018,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.201,1.161,2.614,2.857,3.096,6.902,2.809,12.807,30.96,66.35,28.30,125.61,

K585+780X,,5.017,2.400,3.782,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.182,2.400,3.782,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.237,1.165,2.649,2.617,3.096,6.369,2.851,12.316,,,,,

K585+780D,10.00,5.257,2.400,4.019,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,,6.419,2.400,4.019,0.750,0.600,0.900,0.400,0.200,0.100,0.050,0.800,1.830,2.201,1.161,2.614,2.857,3.096,6.902,2.809,12.807,30.96,66.35,28.30,125.61,

K585+790X,,5.017,2.400