道路工程测量计算excel(功能齐全)

本程序是本人花了大量的时间编成的，为了表示对劳动成果的尊重，请你付点小费，你不会

忠 QQ：337699117 邮箱：337699117@https://www.360docs.net/doc/a8528918.html, 开户行：中国工商银行卡号：622202240300户名：徐明忠付费100元整付完费请将你的邮箱地址发到我的邮箱中，我会在一天内将密码发。谢谢合作！！！！！！

欢迎你使用！

请加我的QQ：

欢迎使用！！

W S K E Z2M

1102.8469986

-1-20666.3715611774.126685.24241819611859.3691-0.967755757 -1-508.767064.407880485.242324850

1-1005.7910112.310203864.40798160 #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#DIV/0!

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

W S K E Z2M

1102.8469986#VALUE!

-185.24241819

-1-449.394092064.407880485.24232485#VALUE!

1-946.4180920112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!0

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

W S K E Z2M 1102.8469986#VALUE!

-17.022*******.022********.2424181995.824498140 -1-608.224207064.407880485.24232485

1-1105.248210112.310203864.4079816

#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#VALUE! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

W S K E Z2M 1102.8469986

-1 6.854980654 6.85498065485.2424181995.99188198#VALUE!

-1-609.684907064.407880485.24232485#VALUE!

1-1106.708910112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#VALUE! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

W S K E Z2M 1102.8469986#VALUE!

-1 6.853322838 6.853********.2424181995.9935398#VALUE!

-1-609.699374064.407880485.24232485

1-1106.723370112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!T

FSGC 0.005RAbs(I

-J)H+0.01(Z-L)J+(I-336.5084548

40.0348773

40.2562619

95.7

338.164336.5084548127.55

338.177337.67213310

0转换前原坐标方位角转换后坐标方位角角度差值85.23921306085.2392130685°14′21.17″0°0′0″X0

###########0.000YO

500895.0010.000X1

###########10.000M 3615414.145方位Y1500899.9840.000N 500895.001

方度、点号需转换R 需转换V

转换后X 转换后Y 13615406.172500895.665

-1.6599E-058.0006015423615363.903500259.347-637.630803-2.687969657EX 施工坐标与大地坐标转换EXCEL表格成果输出

33615472.936500379.368-508.974604-101.3835522 43615398.423500706.101-189.553136-0.010154291 53615447.634501297.377403.76720770.022069493 63615645.854501711.242832.6557627-163.1649827 700-799231.1483561368.391 800-799231.1483561368.391 900-799231.1483561368.391 1000-799231.1483561368.391

）

你不会介意吧！创作人：徐明银行卡号：622202************* 开中，我会在一天内将密码发到你的邮箱中

159.4263

5.1644425

P 4.951433D S

4.9514117

55.100556#VALUE!#VALUE!#VALUE! -17.6044410678.96159.37290880.969372 -20.834441.4877592-99.45819-13.75678 47.9022221.1241313-88.06205-48.23128

0#DIV/0!#DIV/0!#DIV/0!

59.37290880.969372

P D S

55.100556#VALUE!#VALUE!#VALUE! -17.60444#VALUE!#VALUE!#VALUE! -20.834441.4877592-158.8301-13.77461 47.9022221.1241313-143.5455-69.3646

0#DIV/0!#DIV/0!#DIV/0!

-158.8301-13.77461

P D S 55.100556#VALUE!#VALUE!#VALUE! -17.60444 1.672453-1.4607-4.953567 -20.834441.4877592-0.526157-5.13757 47.9022221.1241313 1.3355128-4.988775

0#DIV/0!#DIV/0!#DIV/0!

-1.4607-4.953567

P D S 55.100556#VALUE!#VALUE!#VALUE! -17.604441.6753744-0.014467-4.951412 -20.834441.48775920.9093064-4.867222 47.9022221.1241313 2.5809607-4.225557

0#DIV/0!#DIV/0!#DIV/0!

-0.014467-4.951412

P D S 55.100556#VALUE!#VALUE!#VALUE! -17.604441.6754033-0.000143-4.951412 -20.834441.48775920.9235197-4.864523 47.9022221.1241313 2.5932848-4.21798

0#DIV/0!#DIV/0!#DIV/0!

-0.000143-4.951412

ZP YP FZP FYP k

-0.01068 -44-3.990326 3.9709786#DIV/0!

-2-2-2-2#DIV/0!

-2-2-2-2#VALUE!

#DIV/0!

000

-44-3.990326 3.9709786

EXCEL表格计算方位角距离

转换后坐标方位角

转换前原坐标方位角

0.41510

4.9830

12.007228910

象限角 1.487704920

方位角弧度表示 1.487704920

方位角度表示85.239213060

度、分、秒表示85°14′21.17″0°0′0″

距离 5.00010.000

一

哟！！

10678.96055

1.487759231

D J

#VALUE!#VALUE! 10678.96055-10680.47694 1.487759231-3.00414753 1.124131343-2.640519642

#DIV/0!#DIV/0!

#VALUE!#VALUE!

#VALUE!#VALUE! 1.487759231-3.055083655 1.124131343-2.691455768

#DIV/0!#DIV/0!

#VALUE!#VALUE! 1.672452997-1.857547771 1.487759231-1.672854005 1.124131343-1.309226118

#DIV/0!#DIV/0!

#VALUE!#VALUE! 1.675374396-1.573718146 1.487759231-1.38610298 1.124131343-1.022475093

#DIV/0!#DIV/0!

#VALUE!#VALUE! 1.67540333-1.570825261 1.487759231-1.383181162 1.124131343-1.019553274

#DIV/0!#DIV/0!

zp2YP2K FXPD Wz

4.25337.9937308

4.25-17.36163

4.25-20.50036

4.2547.54084

4.25#DIV/0!

4.25-20.50036