Excel表生成数据绘制横断面表格文件下载.xls

Excel表生成数据绘制横断面表格文件下载.xls

《Excel表生成数据绘制横断面表格文件下载.xls》由会员分享，可在线阅读，更多相关《Excel表生成数据绘制横断面表格文件下载.xls（11页珍藏版）》请在冰豆网上搜索。

橫断面原始数据录入高差m里程桩号高差m平距m平距m0.512.2-00-00.3-20.3-5K0+000.0.32-0-00.61528641.510424135240.512.2-00-00.3-20.3-5K0+020.0.32-0-00.61528641.510424135240.512.2-00-00.3-20.3-5K0+040.0.32-0-00.61528641.510424135240.5-12.2-200.40.32.30.33.6K0+060.-32-0-0-1-1528641.510424135240.512.2-00-00.3-20.3-5K0+080.0.32-0-00.61528641.510424135240.512.2-00-00.3-20.3-5K0+100.0.32-0-00.61528641.510424135240.512.2-00-00.3-20.3-5K0+120.0.32-0-00.61528641.510424135240.613.2-10.401.10.40.32.2K0+140.0.32-0-00.61528641.510424135240.512.2-00-00.3-20.3-5K0+160.-4-12.1-00.61.4528641.510424135240.512.2-00-00.3-20.3-5K0+180.0.32-0-00.61528641.51042413524设计数据录入中桩实测高中桩设计高左边距右边距橫坡中央分隔带绿化带非机动车道mmmm%宽与中桩高差宽宽2-0-1-111101111-2.0%2.50.31.53.50.52212-0-1-1910使用说明：

@#@按橫断面格式高差/平距输入原始数据。

@#@所有数据输入时不带任何格式。

@#@每个断面按20个点设计，如果不够可再加，要注意此栏加了，临时数据表里也相应增加，公式参看其他栏。

@#@所有黑色部分手动输入。

@#@其他的请不要任意改动。

@#@分别复制绘图数据至AutoCAD命令栏下，稍等出图，修改一下边坡，卡出挖填面积填入相应位置。

@#@OK，搞定注意：

@#@在cad出图时每完成一步命令后，点一下Esc键，然后再继续下一个出图命令，可避免出错!

@#@如果你有好的意见和建议请联系我。

@#@早起的虫子QQ：

@#@17641089172012/4/160.52212-0-1-19.5100.52212-01.3-111100.52212-0-1-112100.52212-0-1-18100.52212-0-1-19100.52212-0-1-111100.5221-2-12.3-111100.52212-0-1-111100.5221人行道边坡橫坡与中桩高差宽橫坡与中桩高差上边坡下边坡2.0%-0.18442.0%0.08100%150%设计数据录入非机动车道使用说明：

@#@按橫断面格式高差/平距输入原始数据。

@#@所有数据输入时不带任何格式。

@#@每个断面按20个点设计，如果不够可再加，要注意此栏加了，临时数据表里也相应增加，公式参看其他栏。

@#@所有黑色部分手动输入。

@#@其他的请不要任意改动。

@#@分别复制绘图数据至AutoCAD命令栏下，稍等出图，修改一下边坡，卡出挖填面积填入相应位置。

@#@OK，搞定注意：

@#@在cad出图时每完成一步命令后，点一下Esc键，然后再继续下一个出图命令，可避免出错!

@#@如果你有好的意见和建议请联系我。

@#@早起的虫子QQ：

@#@17641089172012/4/165绘绘图图设设置置地面线生成1K0+000.04001000pline366.5,8.5371.5,8pline371.5,8373.5,7pline373.5,7381.5,4.8pline381.5,4.8387.5,4.9pline387.5,4.9391.5,4.9pline391.5,4.9393,5pline393,5394,4.75pline394,4.75394,6.25pline394,6.25398,6pline398,6400,11pline400,11404,11.25pline404,11.25405,13.252K0+020.3040010030pline366.5,36.5371.5,36pline371.5,36373.5,35pline373.5,35381.5,32.8pline381.5,32.8387.5,32.9pline387.5,32.9391.5,32.9pline391.5,32.9393,33pline393,33394,32.75pline394,32.75394,34.25pline394,34.25398,34pline398,34400,39pline400,39404,39.25pline404,39.25405,41.253K0+040.6040010030pline366.5,67371.5,66.5pline371.5,66.5373.5,65.5pline373.5,65.5381.5,63.3pline381.5,63.3387.5,63.4pline387.5,63.4391.5,63.4pline391.5,63.4393,63.5pline393,63.5394,63.25pline394,63.25394,64.75pline394,64.75398,64.5pline398,64.5400,69.5pline400,69.5404,69.75pline404,69.75405,71.754K0+060.9040010030pline366.5,108.15371.5,107.65pline371.5,107.65373.5,108.25pline373.5,108.25381.5,106.05pline381.5,106.05387.5,107.75pline387.5,107.75391.5,107.75pline391.5,107.75393,107.35pline393,107.35394,107.1pline394,107.1394,104.85pline394,104.85398,104.6pline398,104.6400,101pline400,101404,97.8pline404,97.8405,99.85K0+080.12040010030pline366.5,129.5371.5,129pline371.5,129373.5,128pline373.5,128381.5,125.8pline381.5,125.8387.5,125.9pline387.5,125.9391.5,125.9pline391.5,125.9393,126pline393,126394,125.75pline394,125.75394,127.25pline394,127.25398,127pline398,127400,132pline400,132404,132.25pline404,132.25405,134.256K0+100.04801200pline446.5,5.5451.5,5pline451.5,5453.5,4pline453.5,4461.5,1.8pline461.5,1.8467.5,1.9pline467.5,1.9471.5,1.9pline471.5,1.9473,2pline473,2474,1.75pline474,1.75474,3.25pline474,3.25478,3pline478,3480,8pline480,8484,8.25pline484,8.25485,10.257K0+120.3048012030pline446.5,36.5451.5,36pline451.5,36453.5,35pline453.5,35461.5,32.8pline461.5,32.8467.5,32.9pline467.5,32.9471.5,32.9pline471.5,32.9473,33pline473,33474,32.75pline474,32.75474,34.25pline474,34.25478,34pline478,34480,39pline480,39484,39.25pline484,39.25485,41.258K0+140.6048012030pline446.5,78.95451.5,78.35pline451.5,78.35453.5,77.35pline453.5,77.35461.5,74.15pline461.5,74.15467.5,75.25pline467.5,75.25471.5,74.9pline471.5,74.9473,74.9pline473,74.9474,73.8pline474,73.8474,73.45pline474,73.45478,73.2pline478,73.2480,71pline480,71484,71.25pline484,71.25485,73.259K0+160.9048012030pline446.5,98.5451.5,98pline451.5,98453.5,97pline453.5,97461.5,94.8pline461.5,94.8467.5,94.9pline467.5,94.9471.5,94.9pline471.5,94.9473,95pline473,95474,94.75pline474,94.75474,96.25pline474,96.25478,96pline478,96480,101pline480,101484,96.8pline484,96.8485,95.510K0+180.12048012030pline446.5,128.5451.5,128pline451.5,128453.5,127pline453.5,127461.5,124.8pline461.5,124.8467.5,124.9pline467.5,124.9471.5,124.9pline471.5,124.9473,125pline473,125474,124.75pline474,124.75474,126.25pline474,126.25478,126pline478,126480,131pline480,131484,131.25pline484,131.25485,133.25生成设计线生成设计线pline405,13.25408,13.15pline408,13.15413,12.7pline413,12.7415,13.3pline415,13.3419,14.3pline419,14.3419.5,16.3pline419.5,16.3421.5,16.1pline421.5,16.1423.5,15.1pline423.5,15.1424.5,14.6pline374.01,7378.75,10.16pline378.75,10.16382.75,10.08pline382.75,10.08382.75,9.886pline