附合导线坐标计算表(EXCEL)

附合导线坐标计算表（严密平差）林场隧道进出口导线点号D250D249116°39′27.8″116.6577223.32ZD1195°51′55.9″195.8655280.33ZD2186°00′55.6″186.015444-1.53ZD3208°34′33.5″208.575972-1.88ZD4220°12′54.6″220.215167-2.00ZD5149°23′45.6″149.396ZD6-0.82116.658644188.9437195.865619186.015019208.57545239.3998220.214611279.6144149.395772165.713436234.7237ZD7260°04′38.5″260.077361-0.88ZD8181°02′58.5″181.0495831.20ZD9173°55′58.4″173.9328893.25ZD10181°57′05.5″181.9515284.79D246290°58′17.1″290.9714175.63D244总和∑2330°25′20″2330.4222210.792330.425225032.2340.0335032.267-921.600-3263.582观测左角(°′″)观测左角(°′″)十进制角度改正值改正后角值(″)(°′″)十进制坐标方位角(°′″)十进制252.2851边长(m)改正数(m)改正后的边长(m)坐标增量计算值ΔxΔy改正后的坐标增量ΔxΔyx坐标y474077.602473754.1015439981.3405439878.005839.198670.959146.598287.857486.566643.722322.511518.317506.183395.481214.8420.00340.00390.00300.00380.00360.00500.00380.00160.00150.00170.0015839.2014670.9629146.6010287.8608486.5696643.7270322.5148518.3186506.1845395.4827214.8435-828.995-609.035-125.890-146.53281.265-230.576-186.255365.229363.200253.069143.024-130.465-281.535-75.118-247.770-479.732-601.007-263.290-367.778-352.572-303.910-160.316-828.998-609.039-125.892-146.53281.269-230.578-186.256365.234363.206253.073143.025-130.468-281.537-75.120-247.775-479.735-601.014-263.295-367.775-352.568-303.907-160.3175438956.521470490.593470629.1865439028.020204.8094210.82445439049.0075438439.9685438314.0765438167.544249.01025438248.8135438018.235314.80085437831.979315.8507309.78455438197.2135438560.420311.73735438813.49362.7111-921.484-3263.508473623.634473342.097473266.977473019.202472539.467471938.453471675.158471307.384470954.816470650.908165°42′49″165.713611-0.63260.077117181.049917173.933792181.952858290.972981角度闭合差=10.79(s),限差=±17.32(s)fβ=10.79″ fβ允=±5√n=17.32″ fβ﹤fβ允fx=-0.116(m),fy=-0.074(m),fd=0.137(m)总边长[s]=5032.234(m),全长相对闭合差k=1/(∑D/fd）=1/36673允许相对闭合差k允=1/35000 k﹤k允