道路设计-坐标放样Excel计算表

放样角度

(°′″)3894484.66388348.713894583.003

388449.1472

3894081.691

388845.448

140.567225°36′13″276°4′9″639.0378.00 2.005311 3.162341°33′54″225°0′0″ 4.472204.90

149.84

81.3

178.068

116.7

381.059

126.782347°8′9″92°58′18″206.0550.0000°0′0″0°0′0″0.0000.000

0°0′0″0°0′0″0.0003893447.28389348.603893445.748389348.91733893447.28389348.60 1.565348°18′6″0°0′0″ 1.573893301.57389531.513893300.055389531.8053 1.543348°58′11″196°44′38″3912738.2163893159.83389687.393893158.332389687.66663893447.28

389348.60

1.523349°32′16″320°53′58″445.4853892855.54389655.583892854.079389655.8604 1.488349°8′19″196°34′39″3912306.8093892516.45389626.153892515.029389626.434 1.449

348°41′44″197°1′14″3911966.5153892040.23389541.663892038.867389541.95413893447.28389348.60 1.395347°49′41″4°21′18″1421.6243891327.79389566.873891326.512389567.1611 1.311347°10′9″198°32′52″3910778.0043891092.98389506.953891091.73389507.2483 1.285346°34′37″199°8′22″3910538.4223891077.10389635.533891075.852389635.8128 1.280347°13′56″198°29′10″3910535.4303890759.02389649.803890757.81389650.0811 1.242346°55′9″198°47′59″3910220.3933889907.11389503.313889906.002389503.6087 1.147344°54′27″200°48′38″3909358.2303889439.37389669.853889438.319389670.1287 1.088345°9′18″200°33′58″3908909.4703888776.69389892.783888775.718389893.032 1.004345°27′56″200°15′36″3908272.4013888562.76390031.433888561.814390031.66530.975346°2′11″199°41′29″3908073.3973888133.56390269.043888132.665390269.24680.918346°59′12″198°44′43″3907670.1123887988.38390350.623887987.503390350.8170.899347°20′43″198°23′16″3907533.8233887540.61390274.783887539.786390274.98610.849345°57′8″199°46′50″3907080.7713886979.09390208.083886978.334390208.29410.786344°11′38″201°32′20″3906515.4653886748.85390126.663886748.121390126.88390.762342°55′12″202°48′43″3906278.2733886262.99390047.993886262.32390048.22330.710340°48′43″204°55′10″3905787.0443885881.99389919.703885881.365389919.94870.672338°17′20″207°26′28″3905395.1853885406.58389838.173885406.012389838.42850.624335°30′51″210°12′55″3904914.0683885341.90389655.063885341.34389655.34050.626333°23′9″212°20′28″3904831.4453884767.33389626.433884766.839389626.71390.567329°57′29″215°46′9″3904256.9553884238.51389664.793884238.083389665.06930.511326°50′9″218°53′34″3903734.6673883896.26389625.513883895.874389625.7940.480323°41′4″222°2′39″3903390.2463883494.10389587.453883493.762389587.73860.445319°30′58″226°12′45″3902986.3443883210.89389548.293883210.586389548.58330.422316°2′9″229°41′34″3902700.6743883009.76389612.323883009.48389612.60560.400314°25′58″231°17′49″3902506.9643882835.78389854.053882835.521389854.30660.365315°16′40″230°27′21″3902358.0133882501.98390268.593882501.761390268.79690.301316°38′25″229°5′59″3902067.3573882360.28390553.663882360.078390553.83270.266319°29′7″226°15′33″3901954.9043881874.30391079.683881874.156391079.78960.181322°41′11″223°3′59″3901524.1083881329.43

391515.71

3881329.352

391515.7672

0.097

323°53′9″

221°52′27″

3901025.779

放样距离

（m ）坐标放样

后视

测站

所要放样点

已知点间距离（m ）起始方位角（° ′ ″）

3880676.02391992.733880676.04391992.770.045243°26′6″302°19′59″3900423.677 3880302.02392108.913880302.065392108.89610.047162°47′55″22°58′18″3900063.269 3879793.82392330.953879793.926392330.90940.113159°1′27″26°45′0″3899580.035 3879523.33392935.813879523.468392935.69680.179140°41′58″45°5′3″3899371.847 3879077.25393212.343879077.442393212.19370.241142°39′52″43°7′25″3898955.967 3878430.62393600.883878430.889393600.6870.331144°22′55″41°24′46″3898351.916 3878070.20393796.483878070.513393796.26360.380145°18′55″40°28′58″3898013.135 3877691.20394076.333877691.558394076.080.437145°4′48″40°43′22″3897664.400 3877321.25394488.153877321.653394487.85060.502143°21′23″42°27′11″3897338.048 3877256.60394861.693877257.01394861.34580.536140°0′24″45°48′30″3897311.561 3877159.72395243.513877160.142395243.120.575137°15′0″48°34′14″3897253.891 3876967.50395834.623876967.945395834.1590.641133°59′18″51°50′29″3897122.673 3876871.22396088.093876871.677396087.59860.671132°53′29″52°56′31″3897052.653

0.0000°0′0″0°0′0″0.000 3876327.552396469.84273876327.03396470.380.749314°9′42″231°40′42″3896549.757 3875948.527397089.67843875947.96397090.290.834312°50′53″233°0′6″3896235.784 3875663.132397400.20113875662.53397400.850.885312°49′45″233°1′32″3895983.506 3875110.628397852.39683875109.96397853.100.970313°31′15″232°20′28″3895479.982 3874805.824398298.0734*******.12398298.83 1.034312°57′14″232°54′55″3895222.288 3873765.079398431.20743873764.25398431.98 1.133317°1′38″228°50′43″3894200.497 3873684.439398919.28883873683.60398920.12 1.181315°16′3″230°36′44″3894170.245 3873612.448399419.41883873611.60399420.31 1.230313°33′49″232°19′25″3894149.896 3873307.134400110.65583873306.25400111.63 1.316312°13′50″233°40′2″3893917.131 3873229.104400659.83993873228.21400660.88 1.371310°40′3″235°14′18″3893895.981 3873083.681401273.68633873082.77401274.80 1.439309°17′10″236°37′45″3893814.532 3872907.152401889.54243872906.22401890.73 1.510308°7′59″237°47′29″3893702.447 3872253.361401901.65093872252.35401902.84 1.561310°21′49″235°33′43″3893053.320 3871775.608402298.94333871774.54402300.18 1.634310°48′49″235°7′7″3892619.108 3871467.655402651.2513871466.55402652.53 1.690310°49′32″235°6′44″3892349.202 3870890.804402949.11523870889.63402950.43 1.763311°46′1″234°10′34″3891806.210 3870487.913403373.59433870486.69403374.96 1.833311°50′8″234°6′51″3891449.418 3875716.540396856.8833875717.135396856.29940.834135°33′32″50°17′15″3895982.319 3875353.697397049.1233875354.336397048.51630.881136°28′3″49°22′57″3895640.994 3874137.168398007.8293874137.953398007.1073 1.066137°23′28″48°28′28″3894528.795 3873010.712398927.8363873011.632398927.0039 1.240137°51′46″48°1′5″3893502.517 3872611.041399628.2643872612.009399627.3478 1.333136°33′57″49°19′33″3893176.825 3872124.357399919.1983872125.383399918.2469 1.399137°10′20″48°43′28″3892722.644 3872200.398400556.0183872201.415400554.9905 1.446134°42′21″51°12′0″3892863.740 3871480.741401187.5063871481.844401186.4028 1.560135°0′9″50°54′49″3892213.021 *******.432401490.2523871024.59401489.1124 1.625135°27′50″50°27′27″3891789.419 3870491.566401800.1283870492.788401798.9513 1.696136°4′55″49°50′41″3891292.436 3870005.415402372.1903870006.695402370.9446 1.786135°47′30″50°8′39″3890868.052 3869535.742403038.1253869537.079403036.7997 1.882135°14′43″50°42′3″3890469.877 3869153.326403343.3173869154.709403341.9551 1.941135°25′56″50°31′9″3890121.192 1331 2.828135°0′0″63°26′6″ 3.162

0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000 0.0000°0′0″0°0′0″0.000