EXCEL带批量计算的坐标表格(曲线段).xls
- 文档编号:2499239
- 上传时间:2022-10-30
- 格式:XLS
- 页数:130
- 大小:526KB
EXCEL带批量计算的坐标表格(曲线段).xls
《EXCEL带批量计算的坐标表格(曲线段).xls》由会员分享,可在线阅读,更多相关《EXCEL带批量计算的坐标表格(曲线段).xls(130页珍藏版)》请在冰豆网上搜索。
程序目录曲线主点桩号与坐标计算!
A1直线段坐标计算!
A1方位角计算及随机!
A1卵型曲线隐藏计算!
A1卵型曲线主点桩号计算!
A1附合导线平差!
A1水准平差!
A1四等水准!
A1四等水准数据反推!
A1自由测站!
A1圆曲线圆心法!
A1竖曲线!
A1前方交会!
A1参考椭球与高斯投影计算!
A1高斯平面距离值!
A1高斯投影坐标正算!
A1坐标换带计算!
A1缓和曲线-1!
A1圆曲线支矩法!
A1缓和曲线-2!
A1工程、国家坐标换算!
A1超高横坡计算!
A1求弦长或弧长!
A1不完整缓和曲线!
A1曲曲线线计计算算要要素素表表(已已知知条条件件)交点桩号交点坐标转角值方向转角值曲线半径缓和曲线长缓和曲线长JDN(X)E(Y)左+1,右-1(度)(弧度)RLS1LS2842807.6623808109.863515299.822-139324039.544508330.6901818719000490490393240.2基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2(度)(弧度)12T11.1121.112244.994244.9942392018239.33821114.177239810.0270.0273480.671#ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角JD至HZ方位角HZ至JD方位角N(x)E(y)T2LyL(弧度)(弧度)(弧度)(度)(度)489.9644.4463480.6715721.6376701.6371.0356471564.8674216811.72582902898.88271944985258曲曲线线主主点点桩桩号号、坐坐标标结结果果表表ZH桩号HY桩号路线方向QZ桩号YH桩号HZ桩号839326.991839816.991左+1,右-1842677.810845538.628846028.628N(X)E(Y)N(X)E(Y)-1N(X)E(Y)N(X)E(Y)N(X)3809884.898518293.8693809638.856517870.1383808576.058512345.6713808647.322备备注注:
此此程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线,当当为为对对称称缓缓和和曲曲线线时时,LS1=LS2;LS1=LS2;当当为为圆圆曲曲线线时时,LS1=LS2=0LS1=LS2=0。
涂涂红红处处输输入入变变量量K839+326.991至K846+028.628任意点桩号里程差W支矩x坐标支矩y坐标至起点距离切线角距中桩距离待求点坐标WCD(C2+D2)E左+,右-N(X)E(Y)844697.63114880.6400000.542293289-3.63808511.560513183.723844704.00994887.0180000.543002048-3.63808511.782513177.351844710.51384893.5220000.543724703-3.63808512.012513170.854844717.01774900.0260000.544447359-3.63808512.247513164.357844723.52164906.5300000.545170014-3.63808512.487513157.860844730.05054913.0590000.545895449-3.63808512.732513151.338844697.63114880.6400000.542293289-6.43808514.359513183.820844704.00994887.0180000.543002048-6.43808514.580513177.449844710.51384893.5220000.543724703-6.43808514.810513170.954844717.01774900.0260000.544447359-6.43808515.045513164.459844723.52164906.5300000.545170014-6.43808515.285513157.964844730.05054913.0590000.545895449-6.43808515.530513151.444844664.89114847.9000000.538655512-3.63808510.495513216.433844671.26994854.2780000.53936427-3.63808510.693513210.060844677.77384860.7820000.540086926-3.63808510.900513203.562844684.27774867.2860000.540809581-3.63808511.111513197.064844690.78164873.7900000.541532237-3.63808511.328513190.566844697.31054880.3190000.542257672-3.63808511.549513184.044844664.89114847.9000000.538655512-6.43808513.294513216.519844671.26994854.2780000.53936427-6.43808513.492513210.148844677.77384860.7820000.540086926-6.43808513.699513203.652844684.27774867.2860000.540809581-6.43808513.910513197.156844690.78164873.7900000.541532237-6.43808514.126513190.660844697.31054880.3190000.542257672-6.43808514.348513184.140841398.631581.6390000.1757376161.43808993.349516428.313841405.0051588.0140000.1764459491.43808991.272516422.285841411.5051594.5140000.1771681721.43808989.158516416.137841418.0051601.0140000.1778903941.43808987.049516409.988841424.5051607.5140000.1786126161.43808984.945516403.837841431.031614.0390000.1793376161.43808982.836516397.661841398.631581.6390000.175737616-1.43808995.996516427.400841405.0051588.0140000.176445949-1.43808993.919516421.374841411.5051594.5140000.177168172-1.43808991.807516415.228841418.0051601.0140000.177890394-1.43808989.698516409.081841424.5051607.5140000.178612616-1.43808987.594516402.932841431.031614.0390000.179337616-1.43808985.487516396.757841431.371614.3790000.1793753941.43808982.727516397.339841437.7451620.7540000.1800837271.43808980.671516391.304841444.2451627.2540000.1808059491.43808978.580516385.148841450.7451633.7540000.1815281721.43808976.494516378.991841457.2451640.2540000.1822503941.43808974.411516372.832841463.771646.7790000.1829753941.43808972.326516366.649841431.371614.3790000.179375394-1.43808985.377516396.436841437.7451620.7540000.180083727-1.43808983.322516390.402841444.2451627.2540000.180805949-1.43808981.232516384.248841450.7451633.7540000.181528172-1.43808979.146516378.093841457.2451640.2540000.182250394-1.43808977.064516371.937841463.771646.7790000.182975394-1.43808974.979516365.755841464.111647.1190000.1830131721.43808972.217516366.326841470.4851653.4940000.1837215051.43808970.184516360.283841476.9851659.9940000.1844437271.43808968.115516354.120841483.4851666.4940000.1851659491.43808966.051516347.956841489.9851672.9940000.1858881721.43808963.991516341.790841496.511679.5190000.1866131721.43808961.928516335.598841464.111647.1190000.183013172-1.43808974.871516365.433841470.4851653.4940000.183721505-1.43808972.838516359.391841476.9851659.9940000.184443727-1.43808970.770516353.230841483.4851666.4940000.185165949-1.43808968.706516347.068841489.9851672.9940000.185888172-1.43808966.647516340.903841496.511679.5190000.186613172-1.43808964.585516334.714845090.51115273.5200000.5859466231.43808528.630512791.262845096.88995279.8980000.5866553811.43808529.130512784.902845103.39385286.4020000.5873780371.43808529.644512778.417845109.89775292.9060000.5881006921.43808530.162512771.933845116.40165299.4100000.5888233481.43808530.686512765.449845122.93055305.9390000.5895487831.43808531.216512758.941845090.51115273.5200000.585946623-1.43808531.422512791.480845096.88995279.8980000.586655381-1.43808531.921512785
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- EXCEL 批量 计算 坐标 表格 曲线