闭合导线测量计算程序.xls

《闭合导线测量计算程序.xls》由会员分享，可在线阅读，更多相关《闭合导线测量计算程序.xls（14页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、导 线 坐 标 计 算 表点号角值（）方位角边长（m）增量计算（m）改正增量（m）坐标（m）观测值改正后值XYXYXF114834598.2081634433F1013016281301625.54834287.8671140058.5239.713-97.562218.961-97.564218.963F161554010.515540084834190.30389416.5202.4081.112202.4051.111202.406ZD1185162618516244834191.414945730.5282.602-24.426281.544-24.428281.546F1710151

2、57.51015155.54834166.986164926288.840276.47783.599276.47583.601ZD22030012203009.54834443.461394935.5210.640161.769134.908161.768134.909ZD31751910.51751908.54834605.229350844261.301213.664150.419213.662150.421F18421415.5421413.54834818.8912572257.5240.223-52.474-234.422-52.476-234.420F191693918169391

3、5.54834766.4152470213195.616-76.317-180.115-76.318-180.114F201952037.519520354834690.0972622248219.754-29.140-217.813-29.141-217.811F211704826.517048244834660.9562531112172.751-49.969-165.366-49.970-165.365ZD419849041984901.54834610.9852720013.5202.2127.070-202.0887.069-202.087ZD51710211.51710209483

4、4618.0542630222.5163.758-19.845-162.551-19.846-162.550F11804213804210.54834598.208F104834287.867辅助计算左=1980030.5D=2679.818X=310.359Y=-90.519 f左=30.5fx=0.018fY=-0.019 f容=10n=36f=fX2+fY2=0.019K=1/（D/f）1/141043 f测f容Y438649.162438739.662438958.625439161.031439442.577439526.178439661.088439811.509439577.0

5、88439396.975439179.163439013.798438811.712438649.162438739.662坐标（m）导 线 坐 标 计 算 表点号角值（）方位角观测值改正后值F11163.742539F1013016281301625.5114.016289F161554010.515540889.68517789ZD11851626185162494.95851122F171015157.51015155.516.82392789ZD220301220309.539.82656678ZD31751910.5175198.535.14559456F18421415.54214

6、13.5-102.6173221F1916939181693915.5-112.9630166F201952037.51952035-97.619961F211704826.51704824-106.8132943ZD4198494198491.5-87.996211ZD5171211.517129-96.96037767F11804213804210.5F10辅 助计 算B左=1974356270.5D=2679.818B左=1980030.5 f左=30.5 f容=10n=36f=fX2+fY2=0.026172505 f测f容f=fX2+fY2=0.026172505边长（m）增量计算（

7、m）XY1634433114.016289114058.64239.713-97.562218.96189.6851778989416.64202.4081.112202.40594.95851122945730.64282.602-24.427281.54416.82392789164926.14288.840276.47783.59939.82656678394935.64210.640161.769134.90835.1455945635844.14261.301213.664150.420257.38267792572257.64240.223-52.474-234.422247.03

8、69834247213.14195.616-76.317-180.115262.3800392622248.14219.754-29.140-217.813253.18670572531112.14172.751-49.969-165.366272.003789272013.64202.2127.070-202.088263.0396223263222.64163.758-19.845-162.551310.358-90.518fX=0.017fY=-0.018K=1/（D/f）1/102390.58260417导 线 坐 标 计 算 表方位角K=1/（D/f）1/102390.5826041

9、7改正增量（m）坐标（m）XYXY4834598.208438649.1624834287.867438739.662-97.560218.9594834190.307438958.6211.113202.4044834191.420439161.025-24.425281.5424834166.995439442.567276.47983.5974834443.473439526.164161.770134.9074834605.244439661.071213.666150.4184834818.909439811.489-52.472-234.4244834766.437439577.0

10、65-76.316-180.1164834690.121439396.949-29.139-217.8144834660.983439179.135-49.968-165.3674834611.015439013.7677.071-202.0894834618.086438811.678-19.844-162.5524834598.242438649.1264834287.867438739.662说明：绿色字体的数值为已知条件或现场实际测得数值，需要直接输入就可以了红色字体的数值为需要在计算器上算得，然后再输入步骤：1、把现场测得角度、边长输入表格，附合导线角度一定要区分左右角2、平差后计算

11、改正后角度值，并将改正后角度值输入表格3、计算各边坐标方位角，并换算成角度值填入坐标方位角一栏（直接用计算器，将表格中十进制的角度值换算成六十进制角度值，再输入坐标方位角一栏即可）4、自动计算计算改正后坐标增量，然后用计算器校核坐标增量闭合差，输入改正后坐标增量5、输入起始边坐标6、将完成的数据复制到另一个文档4、自动计算计算改正后坐标增量，然后用计算器校核坐标增量闭合差，输入改正后坐标增量导 线 坐 标 计 算 表点号角值（）坐标方位角边长（m）增量计算（m）改正增量（m）坐标（m）观测值改正后值XYXYXYF114834598.208438649.1621634433-97.562218.

12、961-97.560218.959F10130162813016284834287.867438739.662114058.6239.7131.112202.4051.113202.404F161554010.51554010.54834190.307438958.62189416.64202.408-24.427281.544-24.425281.542ZD1185162618516264834191.420439161.025945730.6282.602276.47783.599276.47983.597F171015157.51015157.54834166.995439442.567

13、164926.1288.840161.769134.908161.770134.907ZD22030122030124834443.473439526.164394935.6210.640213.664150.42213.666150.418ZD31751910.51751910.54834605.244439661.07135844.1261.301-52.474-234.422-52.472-234.424F18421415.5421415.54834818.909439811.4892572257.6240.223-76.317-180.115-76.316-180.116F191693

14、91816939184834766.437439577.065247213.1195.616-29.14-217.813-29.139-217.814F201952037.51952037.54834690.121439396.9492622248.1219.754-49.969-165.366-49.968-165.367F211704826.51704826.54834660.983439179.1352531112.1172.7517.07-202.0887.071-202.089ZD41984941984944834611.015439013.767272013.6202.212-19.845-162.551-19.844-162.552ZD5171211.5171211.54834618.086438811.678263222.6163.758F118042138042134834598.242438649.126F104834287.867438739.662407.920-309.479辅助计算B左=1980030.5D=2679.818fX=0.017 f左=30.5fY=-0.018 f容=10n=36f=fX2+fY2=1/102391 f测f容辅助计算f=fX2+fY2=1/102391