边桩坐标自动计算表格Excel

断链输入 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 备注：1：此表只需输入前里程及后里程。2：如果没有断链请编造一个，原则是将断链放入下标段！3：不详细之处请看帮助及批注！序号前里程后里程断链值累计断链整理0.0001K34062.510+K34014.718+47.79247.792K34014.718+K34062.510+2K37942.988+K37803.151+139.837187.629K37803.151+K37942.988+3K39787.668+K39777.369+10.299197.928K39777.369+K39787.668+4K41476.634+K41465.000+11.634209.562K41465.000+K41476.634+5K42626.170+K42628.169+-1.999207.563K42626.170+K42628.169+6K45000.000+K45008.000+-8.000199.563K45000.000+K45008.000+竖曲线参数输入表备注：1：此表前四栏是数据输入区，（起点、终点天然没有半径！）其它栏是计算区，不详细之处请看帮助及批注！2：请依次按右侧的命令！！变坡点里程高程半径I1I2竖曲线起点竖曲线终点起点K34180.000+413.741K34340.000+418.5426000.030.065K34341.828+K34433.756+2K34900.000+455.1418000.06535714290.030K34915.971+K34979.613+3K35020.000+458.7430000.030.061K35021.292+K35114.292+终点K35350.000+478.870.061K35397.792+K35397.792+曲线参数及加宽超高横坡输入表备注：1：“终点”二字不能去掉！2：对于起点、终点只需输入X,Y及里程。3：每个交点还需输入半径、两个缓和曲线长、圆曲线总超高及其总加宽。4：请依次按上边的命令！！5：要检查曲线四大桩的里程请于统一里程之前！交点号JD-XJD-Y交点桩号半径缓和曲线1长缓和曲线2长转角切线1长切线2长ZHHYYHHZ方位角圆曲线总加宽（米）圆曲线总超高起点29428.884400253.7K33969.099+JD1129453.368400298.614K34020.253+503535-1.16851.15451.154K33969.099+K34004.099+K34027.510+K34062.510+1.07169923152JD1229827.333400262.404K34339.278+56.65240402.641246.086246.086K34188.776+K34228.776+K34338.393+K34378.393+6.18665897482.51329573.552400434.959K34343.611+553535-1.31960.80560.805K34378.390+K34413.390+K34450.941+K34485.941+2.5444593241429632.01400597.395K34502.187+12035350.55151.51551.515K34546.256+K34581.256+K34612.348+K34647.348+1.225344081229607.984400712.769K34618.098+85.4343535-1.03366.33466.334K34647.348+K34682.348+K34735.601+K34770.601+1.776106568529766.315400858.247K34823.700+49.19935351.84483.67383.673K34835.611+K34870.611+K34926.337+K34961.337+0.743117190629657.531400925.604K34910.029+104.1033535-0.50244.27644.276K34961.337+K34996.337+K35013.548+K35048.548+2.587188641629599.944401027.391K35025.636+116.50940400.84672.67272.672K35048.548+K35088.548+K35147.090+K35187.090+2.085658678729464.551401056.27K35157.273+40.2053030-1.78165.76765.767K35187.090+K35217.090+K35258.696+K35288.696+2.931444258929503.095401142.491K35221.788+68.837060-0.70528.67752.608K35288.695+K35288.695+K35307.253+K35367.253+1.150408943529638.197401206.921K35368.741+66.7660351.56797.07186.205K35367.254+K35427.254+K35484.377+K35519.377+0.4449965568终点29560.264401371.881K35520.030+0.000K35615.614+K35615.614+K35615.614+K35615.614+2.0121503806K0001.235+K34027.510+导线资料序号点名XYZ1A002B30682.225400796.5433C004D30518.124400831.5455E2-1指定里程计算备注：1：置仪点、后视点只需输入导线资料表中有的名称。2：下面的表只需输入施工里程、距中、夹角，其它栏是计算区。3：不详细之处请看帮助及批注！4：请依次按上边的命令！！置仪点30682.2245321568后视点30518.1239612568方位角347°57′34″B400796.5431756061D400831.545431166距离167.792施工里程距中夹角XY统一里程方位角距离K33969.099+29428.884400253.700K33969.099+203°25′6″1365.848K33985.000+29436.827400267.471K33985.000+203°1′1″1353.120K34000.000+29446.019400279.293K34000.000+202°42′19″1340.057K34004.099+29448.986400282.119K34004.099+202°38′33″1336.229K34025.000+29467.068400292.297K34025.000+202°32′12″1315.626K34040.000+29481.821400294.769K34040.000+202°41′6″1301.056K34062.510+29504.284400293.684K34062.510+203°7′3″1280.786K34014.718+29504.284400293.684K34062.510+203°7′3″1280.786K34020.000+29461.972400297.781K34067.792+203°13′52″1276.153K34040.000+29481.878400295.853K34087.792+203°40′9″1258.657K34060.000+29501.785400293.926K34107.792+204°7′11″1241.237K34080.000+29521.692400291.998K34127.792+204°34′58″1223.896K34110.000+29551.553400289.107K34157.792+205°17′17″1197.866K34130.000+29571.459400287.180K34177.792+205°38′26″1179.300K34150.000+29591.371400285.306K34197.792+205°42′36″1159.454K34170.000+29611.346400285.118K34217.792+205°25′58″1140.351K34210.000+29647.174400301.033K34257.792+203°57′56″1113.858K34230.000+29658.824400317.161K34277.792+202°57′33″1110.072K34720.000+29654.762400755.748K34767.792+180°29′18″992.307K35121.505+29546.228401038.642K35169.297+347°47′4″1208.887K35485.000+29595.643401296.995K35532.792+333°50′37″1233.294K35460.000+29606.221401274.344K35507.792+334°34′45″1213.844K34890.000+29725.944401000.516K34937.792+347°57′34″977.792K34900.000+29716.164401002.602K34947.792+347°57′34″987.792K34910.000+29706.384401004.688K34957.792+347°57′34″997.792K34920.000+29696.604401006.774K34967.792+347°57′34″1007.792K34930.000+29686.824401008.860K34977.792+347°57′34″1017.792K34940.000+29677.044401010.946K34987.792+347°57′34″1027.792K34950.000+29667.264401013.032K34997.792+347°57′34″1037.792K34960.000+29657.484401015.118K35007.792+347°57′34″1047.792K34970.000+29647.704401017.204K35017.792+347°57′34″1057.792K34980.000+29637.924401019.290K35027.792+347°57′34″1067.792K34990.000+29628.144401021.376K35037.792+347°57′34″1077.792K35000.000+29618.364401023.462K35047.792+347°57′34″1087.792K35010.000+29608.584401025.548K35057.792+347°57′34″1097.792K35020.000+29598.804401027.634K35067.792+347°57′34″1107.792K35030.000+29589.024401029.720K35077.792+347°57′34″1117.792K35040.000+29579.244401031.806K35087.792+347°57′34″1127.792K35050.000+29569.464401033.892K35097.792+347°57′34″1137.792K35060.000+29559.684401035.978K35107.792+347°57′34″1147.792K35070.000+29549.904401038.064K35117.792+347°57′34″1157.792K35080.000+29540.124401040.150K35127.792+347°57′34″1167.792K35090.000+29530.344401042.237K35137.792+347°57′34″1177.792K35100.000+29520.582401044.405K35147.792+347°57′19″1187.791K35110.000+29511.002401047.255K35157.792+347°55′3″1197.755K35120.000+29501.980401051.529K35167.792+347°48′32″1207.475K35130.000+29494.163401057.724K35177.792+347°36′5″1216.432K35140.000+29488.111401065.653K35187.792+347°17′59″1224.062K35150.000+29484.198401074.828K35197.792+346°55′23″1229.923K35160.000+29482.663401084.683K35207.792+346°29′36″1233.682K35170.000+29483.557401094.621K35217.792+346°2′7″1235.173K35180.000+29486.327401104.220K35227.792+345°34′19″1234.842K35190.000+29490.125401113.468K35237.792+345°6′43″1233.508K35200.000+29494.513401122.449K35247.792+344°39′21″1231.614K35210.000+29500.097401130.734K35257.792+344°12′51″1228.458K35220.000+29506.806401138.139K35267.792+343°47′43″1224.050K35230.000+29514.387401144.652K35277.792+343°24′6″1218.615K35240.000+29522.588401150.369K35287.792+343°1′56″1212.415K35250.000+29531.204401155.441K35297.792+342°40′55″1205.677K35260.000+29540.075401160.056K35307.792+342°20′43″1198.602K35270.000+29549.073401164.418K35317.792+342°0′51″1191.371K35280.000+29558.088401168.744K35327.792+341°40′49″1184.152K35290.000+29567.011401173.256K35337.792+341°20′7″1177.121K35300.000+29575.718401178.172K35347.792+340°58′15″1170.469K35310.000+29584.054401183.690K35357.792+340°34′50″1164.414K35320.000+29591.824401189.978K35367.792+340°9′35″1159.209K35330.000+29598.778401197.154K35377.792+339°42′28″1155.138K35340.000+29604.636401205.247K35387.792+339°13′46″1152.491K35350.000+29609.221401214.123K35397.792+338°44′8″1151.395K35360.000+29612.429401223.585K35407.792+338°14′21″1151.879K35370.000+29614.190401233.419K35417.792+337°45′11″1153.931K35380.000+29614.464401243.406K35427.792+337°17′26″1157.497K35390.000+29613.244401253.322K35437.792+336°51′46″1162.483K35400.000+29610.654401262.974K35447.792+336°28′39″1168.683K35410.000+29607.095401272.316K35457.792+336°7′46″1175.697K35420.000+29602.990401281.434K35467.792+335°48′22″1183.160K35430.000+29598.722401290.478K35477.792+335°29′36″1190.777K35440.000+29594.450401299.520K35487.792+335°11′5″1198.432K35450.000+29590.178401308.562K35497.792+334°52′48″1206.121K35460.000+29585.907401317.603K35507.792+334°34′45″1213.844K35470.000+29581.641401326.648K35517.792+334°16′55″1221.596K35480.000+29577.574401335.783K35527.792+333°58′50″1229.240K35490.000+29574.140401345.171K35537.792+333°39′34″1236.464K35500.000+29571.813401354.888K35547.792+333°18′20″1242.885K35510.000+29571.034401364.846K35557.792+332°54′47″1248.083K35520.000+29571.918401374.795K35567.792+332°29′22″1251.861K35530.000+29574.440401384.460K35577.792+332°2′40″1254.126K35540.000+29578.480401393.598K35587.792+331°35′22″1254.881K35550.000+29583.624401402.169K35597.792+331°8′0″1254.474K35560.000+29589.410401410.323K35607.792+330°40′45″1253.383路面 设计 领导形象设计圆作业设计ao工艺污水处理厂设计附属工程施工组织设计清扫机器人结构设计 半宽4.25直线设计横坡2高程距路面0自动计算表备注：1：只需输入“施工里程”、“路面设计半宽”、“直线设计横坡”、“高程距路面”即可。2：请依次按上边的命令！！施工里程统一里程左B左X左Y左Z中桩X中桩Y中桩Z右X右Y右Z右BK33969.099+K33969.099+4.2529432.616400251.666405.97129428.884400253.700405.97929425.153400255.734405.8944.25K33979.099+K33979.099+4.8229437.919400260.006406.26929433.754400262.434406.27929430.082400264.574406.1944.25K33989.099+K33989.099+5.3929443.522400267.769406.56829439.113400270.873406.57929435.637400273.320406.4944.25K33999.099+K33999.099+5.9629449.734400274.549406.86729445.396400278.642406.87929442.304400281.558406.7944.25K34009.099+K34009.099+6.2529456.538400280.149407.16629452.898400285.229407.17929450.423400288.684407.0944.25K34019.099+K34066.891+4.2529508.235400289.032408.90429508.644400293.262408.91329509.054400297.492408.8284.25K34029.099+K34029.099+6.1629472.384400287.354407.76729471.025400293.361407.77929470.088400297.507407.6944.25K34039.099+K34039.099+5.5929481.257400289.143408.06829480.921400294.721408.07929480.666400298.963407.9944.25K34049.099+K34049.099+5.0229490.690400289.736408.36929490.917400294.748408.37929491.108400298.993408.2944.25K34059.099+K34059.099+4.4429500.475400289.583408.67029500.888400294.009408.67929501.284400298.241408.5944.25K34069.099+K34116.891+4.2529558.002400284.213410.40429558.411400288.443410.41329558.821400292.673410.3284.25K34079.099+K34126.891+4.2529567.955400283.249410.70429568.365400287.479410.71329568.775400291.709410.6284.25K34089.099+K34136.891+4.2529577.909400282.285411.00429578.318400286.515411.01329578.728400290.746410.9284.25K34099.099+K34146.891+4.2529587.896400281.333411.30429588.273400285.567411.31329588.683400290.168411.2214.62K34109.099+K34156.891+4.2529598.076400280.636411.60429598.249400284.883411.61329598.462400290.123411.5085.24K34119.099+K34166.891+4.2529608.464400280.656411.90429608.245400284.900411.91329607.943400290.762411.7965.87K34129.099+K34176.891+4.2529618.964400281.883412.20429618.170400286.058412.21329616.957400292.438412.0836.49程序功能本程序可以使用帮助1：所有工作表都不能进行删除、插入行或列的操作！但是在计算完毕后可以粘贴到其它工作表进行各种操作。2：你只有在完成了绿色标签的工作表的情况下才能进行以后的工作（废话）！3：有断链时，在计算前统一里程是必须的！（没有断链按“统一里程”相对于没按，因为两个里程相同）。4：在“自动计算边桩坐标高程”工作表中，“B左”及“B右”是按Y=Kx+B线性加宽进行计算的，边桩高程按绕中轴旋转计算。5：其它诸如给数据画表格之类的常规操作，请自行解决！6：不详之处，请参阅每章工作表上的备注及批注。7：各种输入数据支持粘贴，复制操作。也可作计算操作。如：里程是等间距可以选择自动填充或编制公式自动计算。