公路施工放线-测量人员必备软件.xls
下载文档
上传人:正***
编号:856248
2023-12-22
77页
14.40MB
1、目录1)曲线元素表2)中、边桩坐标计算表3)放样距离方位角计算4)长、短链表使用说明1)首先填写曲线元素表(千万别填错)2)曲线元素表最多只能填24个曲线(如果合同段曲线多于24个曲线可将本程序复制后再接着填写)。3)坐标计算表能计算至1011行。4)坐标计算表只填写要计算的里程和左、右边距就可以(本程序以正交90为基准)、如果计算桥梁、涵洞不是正交请在坐标计算表右侧将90改成斜交度数填写左角数值、本程序交角以前进方向左角为基准如设计图纸交角标注不是前进左角请换算成左角。5)各曲线元素填写一般情况应连续不要中间断开(如JD1、JD2、JD3)。6)填写坐标计算表里程计算坐标不需考虑是曲线还是直2、线点、里程只填写数字不需填符号(如166567.890填写后就自动变为K166+567.890)。7)如果需要计算放样的方位角、距离只需在坐标计算表填左、右距离并在放样距离、方位角计算表将测站及后视点坐标数据填写正确就能自动计算出放样距离方位角数据。8)千万别删掉此页否则将破坏程序结构无法计算!9)本算例云南省锁龙寺蒙自高速公路四合同的曲线元素数据。10)本版本增加了长、短链使用时特别注意如标段无长短链请将表格内数据设为0、如果有请按长、短链表格说明填写。锁蒙高速公路第四高监办 王德明 电话:13099818685 邮箱公路曲线元素表序号转角序号转角里程转角坐标方位角转角半径缓合曲线 转角方向3、JDXY度分秒度分秒RL左2、右11JD28K159+852.8942608913.485150930.9741681848155252500.00030022JD29K161+875.0502607116.415151868.653152264362922800.00030023JD30K165+125.1402607099.492155220.4749017217335401601.88520014JD31K166+559.0502605394.861155713.0161635313935481041.17620025JD32K167+368.9302604921.070156407.94、071241713256221191.89720016JD33K168+443.7602603988.155156959.7811492335252728860.00023017JD34K169+020.0302603406.799157012.16717451493282195.23420028JD35K169+733.9502602713.914157187.5811654736212381804.07120019JD36K170+457.5902601987.752157096.12018710431528161405.684200210JD37K171+533.0902600920.95、11157251.61417142272834291200.000200111JD38K176+029.0602596691.147155688.46520016564515231200.000200212JD39K179+062.6802593892.527156991.94715513322871500.000200113JD40K180+167.1102592781.733157047.0321779401453142000.000200214JD41K181+755.4802591265.786157531.5961621626743416000.0000215JD42K184+9446、.6702588385.067158902.81415432441519286000.0000116JD43K188+380.9202584988.948159509.5851695212719265253.969011718192021222324切线外距直缓点缓园点园缓点缓直点TEZHHYYHHZ498.60825.677159354.286159654.286160046.660160346.660634.823139.545161240.227161540.227162108.091162408.0911299.007399.869163826.133164026.133165883.7、699166083.699475.35867.111166083.692166283.692166803.241167003.241365.68330.622167003.247167203.247167525.517167725.517309.77524.296168133.985168363.985168516.101168746.101273.9367.637168746.094168946.094169093.135169293.135440.81132.819169293.139169493.139169966.505170166.505291.08814.106170166.5028、170366.502170546.067170746.067405.92539.734171127.165171327.165171725.633171925.633600.761101.583175428.299175628.299176376.147176576.147393.61129.559178669.069178869.069179248.569179448.569361.40317.838179805.707180005.707180325.369180525.369405.25513.670181350.225181350.225182159.505182159.505807.9、20454.055184137.466184137.466185742.238185742.238336.25510.749188044.665188044.665188716.259188716.259公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒1K186+060.0002587277.635159100.67121.1402587281.353159121.48238.8902587270.795159062.3871695212902K185+989.0002587347.528159088.18410、21.1402587351.247159108.99438.8902587340.688159049.9001695212903K185+972.5002587363.771159085.28210.0002587365.530159095.12610.0002587362.012159075.437169521290490590613.000#VALUE!#VALUE!13.000#VALUE!#VALUE!90713.000#VALUE!#VALUE!13.000#VALUE!#VALUE!90813.000#VALUE!#VALUE!13.000#VALUE!#VALUE!909K18611、+000.0002587336.700159090.11816952129010K186+040.0002587297.323159097.15416952129011K186+100.0002587234.311159108.41216952129012K186+140.0002587194.935159115.44716952129013K186+200.0002587135.870159126.00016952129014K186+240.0002587096.494159133.03516952129015K186+300.0002587037.429159143.588169521212、9016K186+340.0002586998.053159150.62416952129017K186+400.0002586938.988159161.17616952129018K186+440.0002586899.611159168.21216952129019K186+500.0002586840.547159178.76516952129020K186+540.0002586801.170159185.80016952129021K186+600.0002586742.106159196.35316952129022K186+640.0002586702.729159203.3813、816952129023K186+700.0002586643.665159213.94116952129024K186+755.0002586589.522159223.61516952129025K186+800.0002586545.223159231.52916952129026K186+840.0002586505.847159238.56516952129027K186+900.0002586446.782159249.11816952129028K186+935.0002586412.328159255.27316952129029K186+970.0002586377.873114、59261.42913.0002586380.160159274.22713.0002586375.587159248.63216952129030K187+000.0002586348.341159266.70613.0002586350.628159279.50313.0002586346.055159253.90816952129031903290339034903590369037903890399040904190429043904490459046904790489049905090519052905390549055905690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右15、边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒5790589059906090619062906390649065906690679068906990709071907290739074907590769077907890799080908190829083908490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒8590869087908890899090909190929093909490959096909790989099901009010190102901039016、104901059010690107901089010990110901119011290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒11390114901159011690117901189011990120901219012290123901249012590126901279012890129901309013190132901339013490135901369013790138901399014090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(17、m)Y(m)YSX(m)Y(m)度分秒14190142901439014490145901469014790148901499015090151901529015390154901559015690157901589015990160901619016290163901649016590166901679016890公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒1699017090171901729017390174901759017690177901789017990180901819018290183918、018490185901869018790188901899019090191901929019390194901959019690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒19790198901999020090201902029020390204902059020690207902089020990210902119021290213902149021590216902179021890219902209022190222902239022490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边19、桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒22590226902279022890229902309023190232902339023490235902369023790238902399024090241902429024390244902459024690247902489024990250902519025290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒2539025490255902569025790258902599026090261902629026320、902649026590266902679026890269902709027190272902739027490275902769027790278902799028090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒28190282902839028490285902869028790288902899029090291902929029390294902959029690297902989029990300903019030290303903049030590306903079030890公路中、边桩21、坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒30990310903119031290313903149031590316903179031890319903209032190322903239032490325903269032790328903299033090331903329033390334903359033690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒3379033890339903409034190342903422、390344903459034690347903489034990350903519035290353903549035590356903579035890359903609036190362903639036490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒3659036690367903689036990370903719037290373903749037590376903779037890379903809038190382903839038490385903869038790388903899023、390903919039290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒39390394903959039690397903989039990400904019040290403904049040590406904079040890409904109041190412904139041490415904169041790418904199042090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒4219042290424、239042490425904269042790428904299043090431904329043390434904359043690437904389043990440904419044290443904449044590446904479044890公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒4499045090451904529045390454904559045690457904589045990460904619046290463904649046590466904679046890469925、047090471904729047390474904759047690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒47790478904799048090481904829048390484904859048690487904889048990490904919049290493904949049590496904979049890499905009050190502905039050490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX26、(m)Y(m)度分秒50590506905079050890509905109051190512905139051490515905169051790518905199052090521905229052390524905259052690527905289052990530905319053290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒5339053490535905369053790538905399054090541905429054390544905459054690547905489054927、905509055190552905539055490555905569055790558905599056090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒56190562905639056490565905669056790568905699057090571905729057390574905759057690577905789057990580905819058290583905849058590586905879058890公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角28、X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒58990590905919059290593905949059590596905979059890599906009060190602906039060490605906069060790608906099061090611906129061390614906159061690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒6179061890619906209062190622906239062490625906269062790628906229、990630906319063290633906349063590636906379063890639906409064190642906439064490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒64590646906479064890649906509065190652906539065490655906569065790658906599066090661906629066390664906659066690667906689066990670906719067290公路中、边桩坐标计算序号里程中30、桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒67390674906759067690677906789067990680906819068290683906849068590686906879068890689906909069190692906939069490695906969069790698906999070090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒7019070290703907049070590706907079070890731、099071090711907129071390714907159071690717907189071990720907219072290723907249072590726907279072890公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒7299073090731907329073390734907359073690737907389073990740907419074290743907449074590746907479074890749907509075190752907539075490755932、075690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒75790758907599076090761907629076390764907659076690767907689076990770907719077290773907749077590776907779077890779907809078190782907839078490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒7859078690787907889033、789907909079190792907939079490795907969079790798907999080090801908029080390804908059080690807908089080990810908119081290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒8139081490815908169081790818908199082090821908229082390824908259082690827908289082990830908319083290833908349083534、908369083790838908399084090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒84190842908439084490845908469084790848908499085090851908529085390854908559085690857908589085990860908619086290863908649086590866908679086890公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分35、秒86990870908719087290873908749087590876908779087890879908809088190882908839088490885908869088790888908899089090891908929089390894908959089690公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒8979089890899909009090190902909039090490905909069090790908909099091090911909129091390914909136、590916909179091890919909209092190922909239092490公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒92590926909279092890929909309093190932909339093490935909369093790938909399094090941909429094390944909459094690947909489094990950909519095290公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)Z37、SX(m)Y(m)YSX(m)Y(m)度分秒95390954909559095690957909589095990960909619096290963909649096590966909679096890969909709097190972909739097490975909769097790978909799098090公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒9819098290983909849098590986909879098890989909909099190992909939099490938、959099690997909989099990100090100190100290100390100490100590100690100790公路中、边桩坐标计算序号里程中桩左边距左边桩右边距右边桩切线方位角 左角X(m)Y(m)ZSX(m)Y(m)YSX(m)Y(m)度分秒中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXYK186+055.99015642.276144252215651.3711442110.4 15625.605144335.62600000150000K185+984.99015578.1941441838.1155839、7.3261441425.7 15561.4541442623.1后视点K185+968.49015563.310144173.715567.631144154.215558.994144193.3XY#VALUE!#VALUE!2620000155000后视方位角A14210.5#VALUE!#VALUE!#VALUE!#VALUE!距离D20615.52813#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!K185+995.99015588.1181441940.9K186+035.99015624.2181442328.5K40、186+100.00015682.0271442930.7K186+140.00015718.1761443315.7K186+200.00015772.4351443851.2K186+240.00015808.6311444233.6K186+300.00015862.959144485.3K186+340.00015899.2001445145.2K186+400.00015953.5951445713.1K186+440.00015989.881145050.5K186+500.00016044.343145614.7K186+540.00016080.672145949.7K186+41、600.00016135.2001451510.2K186+640.00016171.5731451842.8K186+700.00016226.1641452359.8K186+755.00016276.2401452848.5K186+800.00016317.2351453243.4K186+840.00016353.6921453611.2K186+900.00016408.4091454121.2K186+935.00016440.3441454421K186+970.00016472.2921454720.216477.6011454451.6 16466.9921454948.942、K187+000.00016499.6861454953.216504.9851454724.9 16494.3941455221.7中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角43、A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角44、A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角45、A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角46、A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角47、A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY中、边桩放样距离方位角计算里程中桩左边桩右边桩测站坐标距离D方位角A距离D方位角A距离D方位角AXY长、短链表格序号HZZH长、短链里程121185742.238186078.57186074.562345678使用说明1)如果标段内无长短链将表格不填任何数字。2)表格HZ栏填长链后退里程曲线HZ里程、红1及红2栏按遂桩坐标表长短链里程填写。长度4.01185742.238186078.5710000000000000000000002186074.56