用EXCEL计算椭圆坐标,和坐标转化

施工坐标原点的测量坐标为旋转角度（顺时针为正，逆时针为负）椭圆长短半轴x00度分秒度弧度a

y0000000b

以椭圆中心点为测站的直角坐标和极坐标

B横坐标A纵坐标y横坐标x纵坐标△x△y D￠度度118.73257118.7325718.73257118.75925 3.0557173

218.6802218.680218.6802218.78696 6.1111076

318.59258318.5925818.59258318.833069.1659429

418.46921418.4692118.46921418.897412.220212

518.30938518.3093818.30938518.9798115.2741515

618.11211618.1121118.11211619.0800518.3284918

717.87616717.8761617.87616719.1978421.3844621

817.59999817.5999917.59999819.3328624.4439724

917.28166917.2816617.28166919.4847627.5097527

1016.918791016.9187916.918791019.6531330.5855930

1116.508451116.5084516.508451119.8375633.6765333

1216.046991216.0469916.046991220.0376136.7892836

1315.529861315.5298615.529861320.2528239.9325939

1414.951291414.9512914.951291420.482743.1180443

1514.303821514.3038214.303821520.7267746.3609546

1613.577591613.5775913.577591620.9845449.6820949

1712.759161712.7591612.759161721.255553.1103453

1811.829421811.8294211.829421821.5391656.6874856

1910.759551910.7595510.759551921.8350260.4774660

209.502331209.5023319.5023312022.1425964.5868364

217.969586217.9695867.9695862122.461469.2180469

22 5.9521422 5.95214 5.952142222.7909674.8609674

22.7 3.87172622.7 3.871726 3.87172622.723.0278180.3207480

-118.73257-118.7325718.73257-118.75925356.9443356

-218.6802-218.680218.6802-218.78696353.8889353

-318.59258-318.5925818.59258-318.83306350.8341350

-418.46921-418.4692118.46921-418.8974347.7798347

-518.30938-518.3093818.30938-518.97981344.7259344

-618.11211-618.1121118.11211-619.08005341.6715341

-717.87616-717.8761617.87616-719.19784338.6155338

-817.59999-817.5999917.59999-819.33286335.556335

-917.28166-917.2816617.28166-919.48476332.4902332

-1016.91879-1016.9187916.91879-1019.65313329.4144329

-1116.50845-1116.5084516.50845-1119.83756326.3235326

-1216.04699-1216.0469916.04699-1220.03761323.2107323

-1315.52986-1315.5298615.52986-1320.25282320.0674320

-1414.95129-1414.9512914.95129-1420.4827316.882316

-1514.30382-1514.3038214.30382-1520.72677313.6391313

-1613.57759-1613.5775913.57759-1620.98454310.3179310

-1712.75916-1712.7591612.75916-1721.2555306.8897306

-1811.82942-1811.8294211.82942-1821.53916303.3125303

-1910.75955-1910.7595510.75955-1921.83502299.5225299 -209.502331-209.5023319.502331-2022.14259295.4132295 -217.969586-217.9695867.969586-2122.4614290.782290 -22 5.95214-22 5.95214 5.95214-2222.79096285.139285 -22.7 3.871726-22.7 3.871726 3.871726-22.723.02781279.6793279 1-18.73261-18.7326-18.7326118.75925176.9443176 2-18.68022-18.6802-18.6802218.78696173.8889173 3-18.59263-18.5926-18.5926318.83306170.8341170 4-18.46924-18.4692-18.4692418.8974167.7798167 5-18.30945-18.3094-18.3094518.97981164.7259164 6-18.11216-18.1121-18.1121619.08005161.6715161 7-17.87627-17.8762-17.8762719.19784158.6155158 8-17.68-17.6-17.6819.33286155.556155 9-17.28179-17.2817-17.2817919.48476152.4902152 10-16.918810-16.9188-16.91881019.65313149.4144149 11-16.508411-16.5084-16.50841119.83756146.3235146 12-16.04712-16.047-16.0471220.03761143.2107143 13-15.529913-15.5299-15.52991320.25282140.0674140 14-14.951314-14.9513-14.95131420.4827136.882136 15-14.303815-14.3038-14.30381520.72677133.6391133 16-13.577616-13.5776-13.57761620.98454130.3179130 17-12.759217-12.7592-12.75921721.2555126.8897126 18-11.829418-11.8294-11.82941821.53916123.3125123 19-10.759619-10.7596-10.75961921.83502119.5225119 20-9.5023320-9.50233-9.502332022.14259115.4132115 21-7.9695921-7.96959-7.969592122.4614110.782110 22-5.9521422-5.95214-5.952142222.79096105.139105 22.7-3.8717322.7-3.87173-3.8717322.723.0278199.6792699

-1-18.7326-1-18.7326-18.7326-118.75925183.0557183 -2-18.6802-2-18.6802-18.6802-218.78696186.1111186 -3-18.5926-3-18.5926-18.5926-318.83306189.1659189 -4-18.4692-4-18.4692-18.4692-418.8974192.2202192 -5-18.3094-5-18.3094-18.3094-518.97981195.2741195 -6-18.1121-6-18.1121-18.1121-619.08005198.3285198 -7-17.8762-7-17.8762-17.8762-719.19784201.3845201 -8-17.6-8-17.6-17.6-819.33286204.444204 -9-17.2817-9-17.2817-17.2817-919.48476207.5098207 -10-16.9188-10-16.9188-16.9188-1019.65313210.5856210 -11-16.5084-11-16.5084-16.5084-1119.83756213.6765213 -12-16.047-12-16.047-16.047-1220.03761216.7893216 -13-15.5299-13-15.5299-15.5299-1320.25282219.9326219 -14-14.9513-14-14.9513-14.9513-1420.4827223.118223 -15-14.3038-15-14.3038-14.3038-1520.72677226.3609226 -16-13.5776-16-13.5776-13.5776-1620.98454229.6821229 -17-12.7592-17-12.7592-12.7592-1721.2555233.1103233 -18-11.8294-18-11.8294-11.8294-1821.53916236.6875236 -19-10.7596-19-10.7596-10.7596-1921.83502240.4775240

-20-9.50233-20-9.50233-9.50233-2022.14259244.5868244 -21-7.96959-21-7.96959-7.96959-2122.4614249.218249 -22-5.95214-22-5.95214-5.95214-2222.79096254.861254 -22.7-3.87173-22.7-3.87173-3.87173-22.723.02781260.3207260

椭圆长短半轴

23.2

18.75

分秒序号

320.581

639.982

957.393

1312.74

1626.935

1942.576

23 4.077

2638.288

3035.19

358.110

4035.5111

4721.3912

5557.3313

7 4.9214

2139.415

4055.5316

637.2317

4114.9118

2838.8619

3512.620

13 4.9421

5139.4522

1914.6523

5639.4124

5320.0125

50 2.626

4647.2927

4333.0628

4017.4229

3655.9230

3321.7131

2924.8932

2451.8933

1924.4834

1238.635

4 2.6636

5255.0737

3820.5938

19 4.4639

5322.7640

1845.0841

3121.1342 2447.3943 4655.0544 820.5445 4045.3446 5639.4147 5320.0148 50 2.649 4647.2950 4333.0651 4017.4252 3655.9253 3321.7154 2924.8955 2451.8956 1924.4857 1238.658 4 2.6659 5255.0760 3820.5961 19 4.4662 5322.7663 1845.0864 3121.1365 2447.3966 4655.0567 820.5468 4045.3469 320.5870 639.9871 957.3972 1312.773 1626.9374 1942.5775 23 4.0776 2638.2877 3035.178 358.179 4035.5180 4721.3981 5557.3382 7 4.9283 2139.484 4055.5385 637.2386 4114.9187 2838.8688

3512.689 13 4.9490 5139.4591 1914.6592