您的当前位置:首页正文

excel坐标计算

2020-01-31 来源:好走旅游网
交点编号ZD1

l0(缓长)420R(半径)550053a(转向角)1418计算得出的数

E(外失距)T(切线长)653.5902967.156L(曲线总长)

5530.513

所在位置

输入里程偏移距离X坐标Y坐标381259.68381260381270381280381290381300381310381320381330381340381350381360381370381380381390381400381410381420381430381440381450381460381470381480381490381500381510381520381530381540381550381560381570381580381590381600381610381620381630381640381650381660381670381679.68558945.9153558945.9852558948.1695558950.3543558952.54558954.7269558956.9156558959.1063558961.2996558963.4959558965.6956558967.8991558970.1068558972.3192558974.5367558976.7596558978.9885558981.2238558983.4658558985.7149558987.9717558990.2365558992.5098558994.7919558997.0833558999.3844559001.6957559004.0174559006.3502559008.6943559011.0502559013.4183559015.7991559018.1929559020.6001559023.0213559025.4567559027.9068559030.3721559032.8528559035.3496559037.8627559040.3925559042.8578503012.1960

在第一缓和曲线上503012.5083在第一缓和曲线上503022.2668在第一缓和曲线上503032.0252在第一缓和曲线上503041.7834在第一缓和曲线上503051.5414在第一缓和曲线上503061.2989在第一缓和曲线上503071.056在第一缓和曲线上503080.8125在第一缓和曲线上503090.5683在第一缓和曲线上503100.3234在第一缓和曲线上503110.0776在第一缓和曲线上503119.8309在第一缓和曲线上503129.5831在第一缓和曲线上503139.3341在第一缓和曲线上503149.0839在第一缓和曲线上503158.8323在第一缓和曲线上503168.5793在第一缓和曲线上503178.3248在第一缓和曲线上503188.0685在第一缓和曲线上503197.8105在第一缓和曲线上503207.5507在第一缓和曲线上503217.2889在第一缓和曲线上503227.025在第一缓和曲线上503236.7589在第一缓和曲线上503246.4906在第一缓和曲线上503256.2198在第一缓和曲线上503265.9466在第一缓和曲线上503275.6707在第一缓和曲线上503285.392在第一缓和曲线上503295.1106在第一缓和曲线上503304.8261在第一缓和曲线上503314.5386在第一缓和曲线上503324.2478在第一缓和曲线上503333.9538在第一缓和曲线上503343.6563在第一缓和曲线上503353.3552在第一缓和曲线上503363.0504在第一缓和曲线上503372.7417在第一缓和曲线上503382.4291在第一缓和曲线上503392.1124在第一缓和曲线上503401.7915在第一缓和曲线上503411.4662在第一缓和曲线上503420.827

在圆曲线上

381680381700381720381740381760381780381800381820381840381860381880381900381920381940381960381980382000382020382040382060382080382100382120382140382160382180382200382220382240382260382280382300382320382340382360382380382400382420382440382460382480382500382520382540382560382580382600382620382640382660382680382700382720384850559042.9395559048.0862559053.3031559058.5902559063.9474559069.3747559074.8719559080.4389559086.0758559091.7825559097.5588559103.4047559109.3201559115.305559121.3591559127.4826559133.6753559139.9371559146.2679559152.6676559159.1363559165.6736559172.2797559178.9544559185.6976559192.5092559199.3892559206.3374559213.3537559220.4381559227.5905559234.8107559242.0987559249.4544559256.8777559264.3685559271.9266559279.552559287.2446559295.0043559302.831559310.7245559318.6849559326.7118559334.8054559342.9654559351.1917559359.4843559367.843559376.2677559384.7583559393.3147559401.9368560668.0166503421.1364在圆曲线上503440.4628在圆曲线上503459.7704在圆曲线上503479.0589在圆曲线上503498.3281在圆曲线上503517.5776在圆曲线上503536.8073在圆曲线上503556.0168在圆曲线上503575.206在圆曲线上503594.3746在圆曲线上503613.5223在圆曲线上503632.6488在圆曲线上503651.754在圆曲线上503670.8375在圆曲线上503689.8992在圆曲线上503708.9387在圆曲线上503727.9558在圆曲线上503746.9502在圆曲线上503765.9218在圆曲线上503784.8702在圆曲线上503803.7953在圆曲线上503822.6966在圆曲线上503841.5741在圆曲线上503860.4274在圆曲线上503879.2564在圆曲线上503898.0607在圆曲线上503916.8401在圆曲线上503935.5943在圆曲线上503954.3232在圆曲线上503973.0264在圆曲线上503991.7038在圆曲线上504010.355在圆曲线上504028.9798在圆曲线上504047.578在圆曲线上504066.1494在圆曲线上504084.6936在圆曲线上504103.2104在圆曲线上504121.6997在圆曲线上504140.1611在圆曲线上504158.5944在圆曲线上504176.9994在圆曲线上504195.3757在圆曲线上504213.7233在圆曲线上504232.0418在圆曲线上504250.331在圆曲线上504268.5906在圆曲线上504286.8204在圆曲线上504305.0202在圆曲线上504323.1898在圆曲线上504341.3288在圆曲线上504359.437在圆曲线上504377.5143在圆曲线上504395.5603在圆曲线上506091.886在圆曲线上

384851382740382760382780382800382820382840382860382880382900382920382940382960385087.095

382980383000383020383040383060383080383100383120383140383160383180383200383220383240383260383280383300383320383340383360383380383400383420383440383460383480383500383520383540383560383580383600383620383640383660383680383700383720383740383760560668.7578559410.6245559419.3776559428.196559437.0797559446.0284559455.0422559464.1208559473.2641559482.4721559491.7445559501.0814559510.4825560847.1194559519.9477559529.4769559539.07559548.7269559558.4474559568.2313559578.0787559587.9893559597.963559607.9996559618.0991559628.2613559638.4861559648.7733559659.1228559669.5345559680.0082559690.5438559701.1411559711.8001559722.5205559733.3022559744.1451559755.0491559766.014559777.0396559788.1258559799.2725559810.4794559821.7466559833.0737559844.4608559855.9075559867.4138559878.9795559890.6045559902.2885559914.0315559925.8334559937.6938506092.5573在圆曲线上504413.5749在圆曲线上504431.5577在圆曲线上504449.5086在圆曲线上504467.4273在圆曲线上504485.3136在圆曲线上504503.1673在圆曲线上504520.988在圆曲线上504538.7756在圆曲线上504556.5298在圆曲线上504574.2505在圆曲线上504591.9373在圆曲线上504609.59在圆曲线上506247.2164在圆曲线上504627.2084在圆曲线上504644.7923在圆曲线上504662.3415在圆曲线上504679.8556在圆曲线上504697.3345在圆曲线上504714.7779在圆曲线上504732.1857在圆曲线上504749.5575在圆曲线上504766.8931在圆曲线上504784.1924在圆曲线上504801.4551在圆曲线上504818.6809在圆曲线上504835.8697在圆曲线上504853.0211在圆曲线上504870.1351在圆曲线上504887.2113在圆曲线上504904.2495在圆曲线上504921.2495在圆曲线上504938.2111在圆曲线上504955.1341在圆曲线上504972.0182在圆曲线上504988.8632在圆曲线上505005.6688在圆曲线上505022.435在圆曲线上505039.1613在圆曲线上505055.8477在圆曲线上505072.4939在圆曲线上505089.0997在圆曲线上505105.6648在圆曲线上505122.189在圆曲线上505138.6722在圆曲线上505155.1141在圆曲线上505171.5145在圆曲线上505187.8731在圆曲线上505204.1898在圆曲线上505220.4643在圆曲线上505236.6964在圆曲线上505252.8859在圆曲线上505269.0327在圆曲线上505285.1364在圆曲线上

进口

383780383800383820383840383860383880383900383920383940383960383980384000384020384040384060384080384082384100384120384140384160384180384200384220384240384260384280384300384320384340384360386370.194

386380386390386400386410386420386430386440386450386460386470386480386490386500386510386520386530386540386550386560386570386580386590559949.6127559961.59559973.6254559985.7188559997.8701560010.079560022.3455560034.6693560047.0504560059.4884560071.9834560084.535560097.1432560109.8077560122.5285560135.3053560136.586560148.1379560161.0263560173.9702560186.9694560200.0238560213.1333560226.2976560239.5165560252.7899560266.1177560279.4995560292.9354560306.425560319.9682561920.5846561929.3769561938.3509561947.3326561956.3217561965.318561974.3212561983.3313561992.3479562001.3708562010.3999562019.435562028.4758562037.5222562046.5739562055.6307562064.6926562073.7591562082.8303562091.9058562100.9854562110.0691562119.1566505301.1968505317.2139505333.1872505349.1167505365.0021505380.8433505396.6399505412.3918505428.0988505443.7607505459.3772505474.9482505490.4734505505.9527505521.3859505536.7727505538.3088505552.1129505567.4063505582.6528505597.8522505613.0041505628.1085505643.1651505658.1737505673.1342505688.0463505702.9098505717.7246505732.4905505747.2071506944.755506949.097506953.5091506957.9057506962.2871506966.6536506971.0058506975.3439506979.6683506983.9795506988.2777506992.5635506996.8371507001.0989507005.3494507009.5889507013.8178507018.0365507022.2454507026.4448507030.6352507034.8169507038.9904在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上在圆曲线上

在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上在第二缓和曲线上

386600386610386620386630386640386650386660386670386680386690386700386710386720386730386740386750386760386770386780386790386790.194562128.2477562137.3422562146.4399562155.5407562164.6444562173.7508562182.8597562191.9709562201.0842562210.1995562219.3166562228.4353562237.5554562246.6768562255.7992562264.9226562274.0466562283.1712562292.2961562301.4212562301.5982507043.156在第二缓和曲线上507047.3141在第二缓和曲线上507051.4651在第二缓和曲线上507055.6094在第二缓和曲线上507059.7474在第二缓和曲线上507063.8795在第二缓和曲线上507068.006在第二缓和曲线上507072.1274在第二缓和曲线上507076.2441在第二缓和曲线上507080.3564在第二缓和曲线上507084.4648在第二缓和曲线上507088.5696在第二缓和曲线上507092.6712在第二缓和曲线上507096.7701在第二缓和曲线上507100.8666在第二缓和曲线上507104.9611在第二缓和曲线上507109.054在第二缓和曲线上507113.1457在第二缓和曲线上507117.2367在第二缓和曲线上507121.3272在第二缓和曲线上

507121.4065里程大于第二曲线终点

原始数据转换成弧度0.929184205出的数据

77.38323998

X,Y

558945.915262433,503012.196005598558945.985159621,503012.508278528558948.169524053,503022.266790301558950.354324447,503032.025204476558952.539983235,503041.783426423558954.726922822,503051.541361401558956.915565577,503061.298914505558959.106333821,503071.055990605558961.299649809,503080.812494298558963.495935725,503090.568329848558965.695613664,503100.323401136558967.899105623,503110.0776116558970.106833485,503119.830864183558972.319219007,503129.58306128558974.536683812,503139.33410468558976.759649366,503149.083895513558978.988536976,503158.832334194558981.223767767,503168.579320371558983.465762675,503178.324752868558985.714942431,503188.068529631558987.971727545,503197.810547675558990.236538297,503207.550703026558992.509794716,503217.288890671558994.791916572,503227.025004501558997.083323356,503236.758937257558999.384434271,503246.490580475559001.695668208,503256.219824436559004.017443738,503265.946558106559006.350179094,503275.670669084559008.694292153,503285.39204355559011.050200422,503295.110566211559013.418321019,503304.826120244559015.799070658,503314.538587243559018.192865629,503324.247847169559020.600121785,503333.953778293559023.021254516,503343.656257141559025.456678739,503353.355158447559027.906808873,503363.05035509559030.372058821,503372.741718051559032.852841953,503382.429116352559035.349571081,503392.112417007559037.862658444,503401.791484967559040.392515682,503411.466183069559042.857778326,503420.826997207前一交点X558837.178前一交点Y502526.401下一个交点下一个交点XY559594.027505907.704562301.598507121.407本交点X本交点YZH点

HY点

559042.939545997,503421.136377572559048.086221484,503440.462817768559053.303140754,503459.770415044559058.590234822,503479.058914092559063.947433775,503498.32805986559069.374666776,503517.577597547559074.871862058,503536.807272616559080.438946933,503556.01683079559086.075847786,503575.206018058559091.782490078,503594.374580679559097.558798352,503613.522265186559103.404696225,503632.648818385559109.320106397,503651.753987364559115.304950647,503670.837519493559121.359149838,503689.899162429559127.482623913,503708.938664115559133.675291902,503727.955772792559139.937071917,503746.950236992559146.267881159,503765.921805551559152.667635915,503784.870227604559159.136251559,503803.795252594559165.673642557,503822.696630273559172.279722463,503841.574110706559178.954403924,503860.427444274559185.697598682,503879.256381676559192.509217568,503898.060673936559199.389170513,503916.8400724559206.337366542,503935.594328749559213.353713778,503954.32319499559220.438119443,503973.026423471559227.590489859,503991.703766876559234.810730449,504010.354978232559242.09874574,504028.979810912559249.45443936,504047.578018637559256.877714045,504066.149355481559264.368471636,504084.693575873559271.926613081,504103.2104346559279.552038439,504121.699686812559287.244646877,504140.161088022559295.004336674,504158.594394114559302.831005224,504176.999361341559310.724549034,504195.375746333559318.684863726,504213.723306095559326.71184404,504232.041798016559334.805383834,504250.330979869559342.965376087,504268.590609812559351.191712897,504286.820446397559359.484285487,504305.020248568559367.842984203,504323.189775667559376.267698517,504341.328787436559384.758317027,504359.437044021559393.314727463,504377.514305973559401.93681668,504395.560334255560668.016616769,506091.886043581

QZ点

560668.757845184,506092.557296464559410.624470668,504413.574890242559419.377574549,504431.557735726559428.19601258,504449.508632916559437.079668153,504467.427344445559446.028423798,504485.313633374559455.042161186,504503.167263188559464.120761126,504520.987997807559473.26410357,504538.775601585559482.472067616,504556.529839315559491.744531505,504574.250476229559501.081372626,504591.937278006559510.482467517,504609.590010772560847.119439937,506247.216378716559519.947691866,504627.2084411559529.476920514,504644.792336022559539.070027453,504662.341463022559548.726885834,504679.855590047559558.447367962,504697.334485505559568.231345303,504714.77791827559578.07868848,504732.185657686559587.989267283,504749.557473568559597.962950661,504766.893136206559607.999606732,504784.192416368559618.09910278,504801.455085304559628.261305258,504818.680914748559638.486079789,504835.869676921559648.773291171,504853.021144532559659.122803373,504870.135090786559669.534479544,504887.211289384559680.008182008,504904.249514524559690.543772271,504921.249540908559701.141111018,504938.211143742559711.80005812,504955.134098741559722.520472632,504972.018182131559733.302212798,504988.863170651559744.145136048,505005.668841557559755.049099005,505022.434972628559766.013957484,505039.16134216559777.039566497,505055.847728981559788.12578025,505072.493912443559799.272452148,505089.099672432559810.479434799,505105.664789368559821.746580009,505122.189044209559833.073738793,505138.672218451559844.460761371,505155.114094137559855.907497169,505171.514453852559867.413794827,505187.873080733559878.979502195,505204.189758468559890.604466339,505220.464271299559902.288533539,505236.696404027559914.031549297,505252.885942011559925.833358332,505269.032671176559937.693804589,505285.136378011

YH点

559949.612731234,505301.196849574559961.589980662,505317.213873498559973.625394498,505333.187237985559985.718813594,505349.116731818559997.870078038,505365.002144361560010.079027153,505380.843265557560022.345499497,505396.639885937560034.66933287,505412.391796622560047.050364312,505428.098789321560059.488430108,505443.760656339560071.983365787,505459.377190578560084.535006127,505474.948185536560097.143185156,505490.473435319560109.807736154,505505.952734632560122.528491657,505521.385878792560135.305283457,505536.772663724560136.586038135,505538.308784621560148.137942603,505552.112885967560161.02629941,505567.406342674560173.970183451,505582.652831619560186.969423569,505597.852151195560200.023847873,505613.004100421560213.133283742,505628.108478939560226.29755783,505643.165087022560239.516496062,505658.173725576560252.789923644,505673.134196139560266.117665058,505688.046300887560279.499544072,505702.909842635560292.935383734,505717.724624841560306.425006381,505732.490451606560319.968233637,505747.207127682561920.584583174,506944.755043672561929.376900375,506949.097019472561938.350934573,506953.509124556561947.33259918,506957.905676113561956.321677559,506962.28705008561965.317955025,506966.653623403561974.321218797,506971.005774001561983.331257952,506975.34388074561992.347863376,506979.668323402562001.370827715,506983.97948265562010.399945329,506988.277740007562019.435012241,506992.563477819562028.47582609,506996.83707923562037.522186081,507001.098928153562046.573892938,507005.349409241562055.630748851,507009.58890786562064.692557431,507013.81781006562073.759123659,507018.036502551562082.830253835,507022.245372673562091.905755531,507026.444808368562100.985437538,507030.635198161562110.069109819,507034.816931125562119.156583457,507038.99039686

HZ点

562128.247670606,507043.155985468562137.342184442,507047.314087525562146.439939107,507051.465094057562155.540749667,507055.609396517562164.644432055,507059.747386757562173.750803021,507063.879457004562182.859680085,507068.005999839562191.970881484,507072.12740817562201.084226118,507076.244075207562210.199533507,507080.356394442562219.31662373,507084.46475962562228.435317384,507088.569564722562237.555435524,507092.671203934562246.676799619,507096.770071629562255.799231496,507100.866562344562264.922553291,507104.961070751562274.046587398,507109.053991641562283.171156418,507113.145719896562292.296083104,507117.236650468562301.421190314,507121.327178354562301.598218,507121.406533243

第一缓曲线第一缓曲线第二缓曲线起第二缓曲线起点里程终点里程点里程终点里程381259.68381679.68386370.194##########

因篇幅问题不能全部显示,请点此查看更多更全内容