附合導(dǎo)線坐標(biāo)計(jì)算表(EXCEL)

1、附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表（嚴(yán)嚴(yán)密密平平差差）林林場(chǎng)場(chǎng)隧隧道道進(jìn)進(jìn)出出口口導(dǎo)導(dǎo)線線點(diǎn)號(hào)觀測(cè)左角觀測(cè)左角角度改正值改正后角值坐標(biāo)方位角邊長(zhǎng)改正數(shù)改正后的邊長(zhǎng)坐標(biāo)增量計(jì)算值改正后的坐標(biāo)增量坐標(biāo)()()()()()xyxyxy十進(jìn)制十進(jìn)制十進(jìn)制(m)(m)(m)D2505439981.3405439981.340474077.602474077.602252.2851252.2851D249 1163927.8116.657722 3.32116.6586445439878.0055439878.005473754.101473754.101188.9437839.198839.1980.

2、0034839.2014-828.995-130.465-828.998-130.468ZD1 1955155.9195.865528 0.33195.8656195439049.007473623.634204.8094670.959670.9590.0039670.9629-609.035-281.535-609.039-281.537ZD2 1860055.6186.015444 -1.53186.0150195438439.968473342.097210.8244146.598146.5980.0030146.6010-125.890-75.118-125.892-75.120ZD3

3、 2083433.5208.575972 -1.88208.575455438314.076473266.977239.3998287.857287.8570.0038287.8608-146.532-247.770-146.532-247.775ZD4 2201254.6220.215167 -2.00220.2146115438167.544473019.202279.6144486.566486.5660.0036486.569681.265-479.73281.269-479.735ZD5 1492345.6149.396-0.82149.3957725438248.813472539

4、.467249.0102643.722643.7220.0050643.7270-230.576-601.007-230.578-601.014ZD61654249 165.713611 -0.63165.7134365438018.235471938.453234.7237322.511322.5110.0038322.5148-186.255-263.290-186.256-263.295ZD7 2600438.5260.077361 -0.88260.0771175437831.979471675.158314.8008518.317518.3170.0016518.3186365.22

5、9-367.778365.234-367.775ZD8 1810258.5181.049583 1.20181.0499175438197.213471307.384315.8507506.183506.1830.0015506.1845363.200-352.572363.206-352.568ZD9 1735558.4173.932889 3.25173.9337925438560.420470954.816309.7845395.481395.4810.0017395.4827253.069-303.910253.073-303.907ZD10 1815705.5181.951528 4

6、.79181.9528585438813.493470650.908311.7373214.842214.8420.0015214.8435143.024-160.316143.025-160.317D246 2905817.1290.971417 5.63290.9729815438956.5215438956.521470490.593470490.59362.711162.7111D2445439028.0205439028.020470629.186470629.1865032.2340.0335032.267-921.600-3263.582-921.484-3263.508總和23

7、302520 2330.42222 10.792330.42522角度閉合差=10.79(s),限差=17.32(s)f=10.79 f允允=5n=17.32 ff允允fx=-0.116(m),fy=-0.074(m),fd=0.137(m)總邊長(zhǎng)s=5032.234(m),全長(zhǎng)相對(duì)閉合差k=1/(D/fd）=1/36673允許相對(duì)閉合差k允允=1/35000 kk允允附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表點(diǎn)號(hào)觀測(cè)左角角度改正值改正后角值坐標(biāo)方位角邊長(zhǎng)坐標(biāo)增量計(jì)算值坐標(biāo)增量改正值改正后的坐標(biāo)增量坐標(biāo)()()()()xyxyxyxyD2505439981.340474077.602252252 1

8、717 06.3806.38D249116 39 27.85.95116 39 33.85439878.005473754.101188 56 40.1839.190-828.985-130.475-0.138 -0.33-829.123-130.805ZD1195 51 55.91.42195 51 57.35439048.882473623.296204 48 37.4670.950-609.022-281.542-0.111 -0.265 -609.133-281.807ZD2186 00 55.6-1.55186 00 54.15438439.749473341.489210 49 3

9、1.5146.589-383.251-117.541-0.024 -0.058 -383.275-117.599ZD3208 34 33.5-2.13208 34 31.45438056.474473223.890239 24 2.98287.841-132.583-98.050-0.048 -0.114 -132.631-98.164ZD4220 12 54.6-2.49220 12 52.25437923.843473125.726279 36 55.1486.558-50.598-98.846-0.08 -0.192-50.678-99.038ZD5149 23 4.6-8.92149

10、22 55.75437873.165473026.688248 59 50.8643.714-47.578-262.809-0.106 -0.254-47.684-263.063ZD6165 42 49-10.33165 42 38.75437825.480472763.624234 42 29.5322.50317.093-211.781-0.053 -0.12817.040-211.909ZD7260 04 38.5-14.47260 04 245437842.520472551.716314 46 53.5518.309-73.659-296.930-0.086 -0.205-73.74

11、5-297.135D67181 02 58.51.03181 02 59.55437768.775472254.581315 49 53506.175-40.943-176.898-0.084-0.2-41.027-177.098ZD8173 55 58.43.82173 56 02.25437727.749472077.483309 45 55.2395.473-89.166-175.630-0.065 -0.156-89.231-175.786ZD9181 57 05.55.87181 57 11.45437638.517471901.697311 43 6.6214.834-75.106

12、-119.238-0.036 -0.085 -75.14153 -119.3229D246290 58 17.17.01290 58 24.15438956.521470490.5936262 4242 40.1740.17D2445439028.020470629.1865032.136-920.657-3261.531-0.827 -1.977-921.484-3263.508總和-14.79aD246D244D246D244=aD250D249D250D249-n*180+測(cè)=624225.38aD246D244D246D244=624240.17f=-14.79 f允允=5n=17.3

13、2 ff允允fx=x-（xD246D246-xD249D249）=-1.98mmfy=y-（yD246D246-yD249D249）=109.19mm導(dǎo)線全長(zhǎng)閉合差f=fx2 2+fy2 2=109.21mm導(dǎo)線相對(duì)閉合差K=1/(D/f）1/46078允許相對(duì)閉合差K允允=1/35000 KK允允計(jì)算： 復(fù)核： 監(jiān)理工程師： 日期：30132330.223055611639281163927.811.65751163927.80.6577221955155.919.86527781860055.618.01527781955155.93013273013281860055.630132930

1453013313013322201254.63013333013341492345.630133530133616542493013373013382600438.53013393013401810258.51735558.41815705.52905817.1附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表點(diǎn)號(hào)觀測(cè)左角角度改正值 改正后角值坐標(biāo)方位角邊長(zhǎng)坐標(biāo)增量計(jì)算值坐標(biāo)增量改正值 改正后的坐標(biāo)增量坐標(biāo)()()()()xyxyxyxD2505439981.340252 17 06.38D249112 09 115439878.005184 26 12776.619-774.292

15、-60.077ZD1208 02 215439103.713212 28 37.75 363.226-306.419-195.039ZD2164 34 28.255438797.294197 03 17.38 400.874-383.245-117.571ZD3199 26 03 5438414.049216 29 18.24 164.901-132.577-98.060ZD4206 24 31 5438281.472242 54 09.36 111.048-50.583-98.857ZD5196 50 43.255438230.889259 45 19.36 267.082-47.501-2

16、62.824ZD6194 52 345438183.388274 37 38.73 212.47617.142-211.783ZD7161 27 13.755438200.530256 04 37.48 305.937-73.613-296.949D67180 54 2.255438126.917256 57 47.85 183.074-41.297-178.355ZD8166 06 555438085.620242 59 51.97 197.498-89.669-175.969ZD9174 42 39.1255437995.951237 48 19.09 140.921-75.082-119

17、.253ZD10198 28 24.255437920.869256 16 34.59 220.127-53.223-213.843ZD11209 00 145437867.646285 16 46.71 104.50327.54-100.809ZD12205 04 29.3755437895.186310 21 06.33 152.53198.761-116.241ZD13185 32 58.755437993.947315 54 11.33 342.751246.152-238.511ZD14179 07 20.255438240.099315 01 24.83 509.690360.55

18、3-360.257ZD15174 10 53.8755438600.652309 12 31.95 384.775243.235-298.142ZD16183 39 105438843.887312 51 31.57 164.706112.032-120.735D246289 51 40.6255438955.91962 43 03.32D244-922.086-3263.275ZD12205 04 29.3755437895.186y474077.602473754.101473694.024473498.985473381.414473283.354473184.497472921.673

19、472709.890472412.941472234.586472058.617471939.364471725.521471624.712附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表坐標(biāo)471508.471471269.960470909.703470611.561470490.826471624.712附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表點(diǎn)號(hào)觀測(cè)左角角度改正值改正后角值坐標(biāo)方位角邊長(zhǎng)坐標(biāo)增量計(jì)算值坐標(biāo)增量改正值改正后的坐標(biāo)增量坐標(biāo)()()()()xyxyxyxyD2505439981.340474077.602252 17 06.38D249112 09 09-1112 09 085439878.

20、005473754.101184 26 14.38776.607-774.279-60.085-0.128 -0.307 -774.407-60.392ZD1208 02 21-1208 02 205439103.598473693.709212 28 34.38363.227-306.424-195.035-0.06 -0.144 -306.484-195.179ZD2164 34 28.25-1164 34 27.255438797.113473498.530197 03 01.63400.871-383.251-117.541-0.066 -0.158 -383.317-117.699Z

21、D3199 26 03 -1199 26 025438413.796473380.831216 29 03.63164.900-132.583-98.050-0.027 -0.065 -132.610-98.115ZD4206 24 31 -1206 24 305438281.186473282.716242 53 33.63111.044-50.598-98.846-0.018 -0.044-50.616-98.890ZD5196 50 46.25-1196 50 45.255438230.570473183.826259 44 18.88267.081-47.578-262.809-0.0

22、44 -0.106-47.622-262.915ZD6194 52 34-1194 52 335438182.947472920.911274 36 51.88212.47017.093-211.781-0.035 -0.08417.058-211.865ZD7161 27 13.75-1161 27 12.755438200.005472709.046256 04 04.63305.930-73.659-296.930-0.051 -0.121-73.710-297.051D67180 54 2.25-1180 54 1.255438126.296472411.995256 58 05.88

23、181.574-40.943-176.898-0.03 -0.072-40.973-176.970ZD8166 06 55-1166 06 545438085.323472235.025243 04 59.88196.968-89.166-175.630-0.033 -0.078-89.199-175.708ZD9174 42 39.125-1174 42 38.1255437996.124472059.318237 47 38140.920-75.106-119.238-0.023 -0.056-75.129-119.294ZD10198 28 24.25-1198 28 23.255437

24、920.995471940.024256 16 01.25220.131-52.259-213.838-0.036 -0.087-52.295-213.925ZD11209 00 14-1209 00 135437868.699471726.099285 16 14.25104.50627.525-100.816-0.017 -0.04127.508-100.857ZD12205 04 29.375-1205 04 28.3755437896.207471625.242310 20 42.63152.53598.750-116.256-0.025 -0.0698.725-116.316ZD13

25、185 32 58.750185 32 58.755437994.932471508.925315 53 41.38342.751246.117-238.547-0.057 -0.136246.060-238.683ZD14179 07 20.250179 07 20.255438240.992471270.243315 01 1.63509.690360.513-360.298-0.084 -0.202360.429-360.500ZD15174 10 53.875-1174 10 52.8755438601.421470909.743309 11 54.5384.771243.179-29

26、8.183-0.064 -0.152243.115-298.335ZD16183 39 07-1183 39 065438844.536470611.408312 51 00.5164.703112.012-120.750-0.027 -0.065111.985-120.815D246289 51 40.625-1289 51 39.6255438956.521470490.59362 42 40.17D2445439028.020470629.1865000.678-920.657-3261.531-0.827 -1.977-921.484-3263.508總和 3590 25 50.75-

27、17aD246D244D246D244=aD250D249D250D249-n*180+測(cè)=624257.13aD246D244D246D244=624240.175000.678f=aD246D244D246D244-aD246D244D246D244=16.9617 f允允=5n=21.79 ff允允fx=x-（xD246D246-xD249D249）=0.827mfy=y-（yD246D246-yD249D249）=1.977m導(dǎo)線全長(zhǎng)閉合差f=fx2 2+fy2 2=2.1430021m導(dǎo)線相對(duì)閉合差K=1/(D/f）1/2333.5允許相對(duì)閉合差K允允=1/35000計(jì)算： 復(fù)核： 監(jiān)理工程師： 日期：ZD11209 00 14-1209 00 135437868.699471726.099附附合合導(dǎo)導(dǎo)線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算表表（嚴(yán)嚴(yán)密密平平差差）點(diǎn)號(hào)觀測(cè)左角角度改正值改正后角值坐標(biāo)方位角邊長(zhǎng)坐標(biāo)增量計(jì)算值坐標(biāo)增量改正值改正后的坐標(biāo)增量坐標(biāo)()()()()xyxyxyxyD2505439981.340474077.602252252 1717 06.3806.