道路全线标高及中、边桩坐标计算(EXCEL版)

计算桩号交点设计要素nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull计算要素nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull切线方位角计算nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull加桩点坐标计算nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull中桩坐标null中桩切线方位角nullnullnull偏角左负右正nullnullnull左边距右边距左边桩坐标null右边桩桩坐标nullnullnull交点里程交点坐标null方位角Ai-1,inullnullnull反方位角Ai,i-1nullnullnull转角αnullnullnull转向方位角Ai,i+1nullnullnull偏向Rls1ls2β1nullnullnullβ2nullnullnullp1p2q1q2T1T2LYZH里程HY里程YH里程HZ里程ZH点坐标nullHZ点坐标null第一直线段nullnullnull第一缓和段nullnullnull圆曲线段nullnullnull第二缓和段nullnullnull第二直线段nullnullnull第一直线段null第一缓和段nullnullnull圆曲线段nullnullnullnull第二缓和段nullnullnull第二直线段nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullXY°＇＂度°＇＂度°＇＂度°＇＂度nullnullnullnull°＇＂度°＇＂度nullnullnullnullnullnullnullnullnullnullnullXYXY°＇＂度°＇＂度°＇＂度°＇＂度°＇＂度XYxyXYφxyXYxyXYXYXY°＇＂度°＇＂度nullnullXYXY4360JD34639.9834608188.6543761.3211152417.5115.40486111112952417.5295.4048611111108459.4108.08316666672232916.9223.488027777811608080141926.214.3239448783141926.214.32394487831.6631.66339.91739.917262.767262.767221.8254377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.4841152417.5115.404861111111645.58116.0682178953945457.2194.9158903572-133615.95-132.89556963982232916.9223.48802777784608308.716543508.413-17.2157692289-0.06644026924608308.776543508.442-20.4889707539-16.087330960811.78466629694608297.587543504.377-1144.81812878-1459.05260332764606163.247543851.1864608287.47543855.1054608308.716543508.4131152417.5115.4048611111-562215-56.37083333334.17.24608310.826543511.9294608305.011543502.239nullJD45090.1094607773.896543367.9462232916.9223.4880277778432916.943.4880277778422219.342.3720277778181657.6181.116-1260808084853.058.814735309784853.058.81473530971.0251.02539.96839.968141.14141.14112.2784948.9695028.9695141.2475221.2474607876.296543465.0794607632.783543365.1972232916.9223.4880277778-335101133.68-33509.807311899313225356.611322.899057860937728207.0937728.3353028499181657.6181.1164611466.863546870.974171543582.98809924046745716.9816-16668892422.62517328838088.611-1099.4110300831-46.441103746215.80373911554607899.114543508.506-224220036.773281-34984545055.7586461811617.659-34981732602.7774612853.04543466.8894611466.863546870.9742232916.9223.4880277778nullnullnull0nullnull4611466.863546870.9744611466.863546870.974nullJD57934.594604919.955543312.351181657.6181.1161657.61.116715217.571.87152777781091440.1109.2444722222-125550505372.045.61723328565372.045.61723328560.4080.40824.99224.992210.12210.12269.8717724.477774.478044.3418094.3414605130.035543316.4434604850.7543510.73181657.6181.116-133886454.39-133885.24878075419222021.241922.339233189214732203.72147322.0010324571091440.1109.24447222224612853.04543466.894229239697.310012356187748933.59-50114459640.8952355658980789.85-1741.2232331892243.0563036973123.22267761894604884.625543434.908-5343507997.04373-3268885605102.14-3087979583651.48-1072377796387.24607518.591535868.6944612853.04543466.89181657.6181.116nullnullnull0nullnull4612853.04543466.894612853.04543466.89nullJD68648.8954604667.317544036.0171091440.1109.24447222222891440.1289.2444722222284257.628.7161375737.7137.9604722222185000000000000000217.579217.579426.018431.3168431.3168857.3268857.3264604739.031543830.5964604505.725544181.7171091440.1109.24447222220000-4605459.2-459.083554296700001375737.7137.96047222224607517.989535870.415004604739.031543830.596-568.328026519403.34101590521598.20854371534603097.188543684.63004604505.725544181.7174611083.911538250.4694607517.989535870.4151091440.1109.2444722222nullnullnull0nullnull4607517.989535870.4154607517.989535870.415nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000nullnullnullnullnullnullnullnull00000nullnullnull00000nullnullnullnull000000000000000000000000000000000000000000000000000000000000000000nullnullnull0nullnull0000null交点设计要素为可编辑区域，根据线路设计改写曲线设计要素nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull自动计算不可修改，部分要素计算列隐藏nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull输入偏角及偏距nullnullnullnullnull边桩坐标计算，不可编辑nullnullnull黄色区域为可编辑区域，输入交点要素及边桩偏角和偏距，A列输入加桩点里程。本表可连续输入20个交点要素，结合“全线坐标计算”标签可计算全线(全线单幅)路线坐标计算；如为双幅路线，则需分别编制。nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull输入桩号桩号换算设计要素nullnullnullnullnullnullnullnullnullnull曲线主点要素计算nullnullnullnullnullnullnullnullnullnullnullnullnullnullnull中桩切线方位角分段计算nullnullnullnull中桩坐标分段计算nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull中桩坐标null中桩切线方位角nullnullnull偏角左负右正nullnullnull左边距右边距左边桩坐标null右边桩桩坐标nullnullnull交点里程交点坐标nullAi-1,iAi,i-1αAi,i+1偏向Rls1ls2β1β2p1p2q1q2T1T2ZH里程HY里程YH里程HZ里程ZH点坐标nullHZ点坐标null→ZHZH→HYHY→YHYH→HZHZ→→ZHnullZH→HYnullnullnullHY→YHnullnullnullnullYH→HZnullnullnull→ZHnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullXY度度度度nullnullnullnull度度nullnullnullnullnullnullnullnullnullnullXYXY度度度度度XYxyXYφxyXYxyXYXYXY°＇＂度°＇＂度nullnullXYXY436043604639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111116.068217895394.9158903572-132.8955696398223.48802777784608308.716543508.413-17.2157692289-0.06644026924608308.776543508.442-20.4889707539-16.087519618211.78461272544608297.587543504.376-1144.81812878-1459.05260332764606163.247543851.1864608287.47543855.1054608308.716543508.4131152417.5115.4048611111-562215-56.37083333334.17.24608310.826543511.9294608305.011543502.239438043804639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111115.4222079813102.0778627964-98.0668081437223.48802777784608300.136543526.4792.78399997450.00028096134608300.135543526.479-13.32699831473.03548610325.97168832914608294.634543524.144-814.812439971-886.18633090444606796.921543662.6724608272.959543841.3414608300.135543526.4791152519.95115.4222079813nullnullnull0nullnull4608300.135543526.4794608300.135543526.479440044004639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111116.5666911771109.2398352355-65.0285397573223.48802777784608291.556543544.54522.78306315030.15399830484608291.417543544.478-6.165025875622.73401256972.58827394324608289.239543543.389-551.3758636552-488.88068958224607261.476543555.7174608258.449543827.5774608291.417543544.478116340.09116.5666911771nullnullnull0nullnull4608291.417543544.4784608291.417543544.478442044204639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111119.5016674826116.4018076746-33.7807644807223.48802777784608282.975543562.61142.7621260611.01935230254608282.064543562.1540.996946563542.70067086411.68716661754608281.487543561.812-344.5261298363-223.34377498484607594.292543505.424608243.938543813.8134608282.064543562.154119306119.5016674826nullnullnull0nullnull4608282.064543562.1544608282.064543562.154444044404639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111124.227136898123.5637801138-4.3234823138223.48802777784608274.395543580.67762.6351444693.21698931344608271.553543579.1628.158919002762.62388796173.28242783044608271.499543579.124-185.3328464479-54.63907320334607825.893543492.5794608229.428543800.0494608271.553543579.1621241337.69124.227136898nullnullnull0nullnull4608271.553543579.1624608271.553543579.162446044604639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111130.7430994231130.725752552923.3433067432223.48802777784608265.815543598.74382.1907303877.3493541634608259.431543595.05415.320891441882.19276872347.34916406444608259.43543595.056-65.858905603244.71067590384607980.946543502.7214608214.918543786.2854608259.43543595.0561304332.71130.7257525529nullnullnull0nullnull4608259.43543595.0564608259.43543595.056448044804639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111139.049555058137.88772499249.2196026904223.48802777784608257.235543616.809101.033558327313.96689783074608245.369543609.23622.4828638809101.101947309613.82391526054608245.469543609.35920.898110154995.96441475714608079.163543525.2424608200.407543772.5214608245.469543609.3591375315.81137.887724992nullnullnull0nullnull4608245.469543609.3594608245.469543609.359450045004639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111149.1465038027145.049697431273.3054055279223.48802777784608248.654543634.875118.525771552523.50554490284608229.249543620.94429.6448363201119.05635231322.6056450924608229.834543621.80981.0645216039115.25765872374608136.092543552.6514608185.897543758.7574608229.834543621.809145258.91145.0496974312nullnullnull0nullnull4608229.834543621.8094608229.834543621.809452045204639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111161.0339456572152.211669870395.6007152556223.48802777784608240.074543652.94133.728388325136.18626551824608211.272543629.23636.8068087592135.775811248433.5573176024608212.768543632.214119.9491465914114.56049667784608163.824543579.9184608171.387543744.9934608212.768543632.2141521242.01152.2116698703nullnullnull0nullnull4608212.768543632.2144608212.768543632.214454045404639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111174.7118806215159.3736423094116.1055318735223.48802777784608231.494543671.006145.342708157651.86759653174608192.12454363343.9687811983150.999422551246.50803560374608194.539543640.409142.1018937856102.50785672924608171.602543603.9084608156.876543731.2294608194.539543640.4091592225.11159.3736423094nullnullnull0nullnull4608194.539543640.4094608194.539543640.409456045604639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111190.1803086955166.5356147486134.8198553816223.48802777784608222.914543689.072151.651718062469.84195662444608173.181543630.98851.1307536375164.489626858661.25570747434608175.43543646.268151.372356424785.1111923924608166.355543622.9094608142.366543717.4654608175.43543646.268166328.21166.5356147486nullnullnull0nullnull4608175.43543646.2684608175.43543646.268458045804639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111207.4392298793173.6975871877151.7436857799223.48802777784608214.333543707.138150.461498802188.56660008414608156.778543621.8858.2927260766176.035914044377.57020072674608155.739543649.699150.968406067466.36074446764608153.158543636.2354608127.856543703.7014608155.739543649.6991734151.31173.6975871877nullnullnull0nullnull4608155.739543649.6994608155.739543649.699460046004639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111226.4886441729180.8595596269166.8770230685223.48802777784608205.753543725.204139.0426311392105.32005398534608146.544543604.37865.4546985157185.458108158695.19693315024608135.775543650.647143.514786342748.72753391494608135.615543643.8994608113.345543689.9364608135.775543650.6471805134.41180.8595596269nullnullnull0nullnull4608135.775543650.6474608135.775543650.647462046204639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111247.3285515763188.021532066180.2198672473223.48802777784608197.173543743.27114.0716020862115.7748834944608147.813543577.33672.6166709549192.6091790136113.86084548094608115.848543649.1131.111706733.57424098214608116.188543646.3574608098.835543676.1724608115.848543649.1188117.52188.021532066nullnullnull0nullnull4608115.848543649.14608115.848543649.1464046404639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111269.9589520895195.1835045051191.7722183162223.48802777784608188.593543761.33671.5722111556113.47763002374608168.12543539.93279.778643394197.3775365404133.27069360894608096.269543645.08115.393436158721.48412587284608096.463543644.3114608084.324543662.4084608096.269543645.08195110.62195.1835045051nullnullnull0nullnull4608096.269543645.084608096.269543645.08466046604639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111294.3798457125202.3454769443201.5340762754223.48802777784608180.012543779.4026.856976609889.22676697024608217.79543491.87986.9406158332199.6887721146153.12359334624608077.345543638.65197.586897058912.51714621914608077.373543638.5624608069.814543648.6444608077.345543638.6512022043.72202.3454769443nullnullnull0nullnull4608077.345543638.6514608077.345543638.651468046804639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111320.5912324452209.5074493834209.5054411248223.48802777784608171.432543797.468-85.531458288630.339517754608310.618543433.68894.1025882723199.5068196781173.10974683234608059.369543629.91278.57025881076.40242663734608059.368543629.9114608055.304543634.884608059.368543629.9112093019.59209.5054411248nullnullnull0nullnull4608059.368543629.9114608059.368543629.911470047004639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33543523.9644607997.958543580.484115.4048611111348.5931122878216.6694218225215.6863128645223.48802777784608162.852543815.534-211.8789190271-80.20161912874608464.675543366.981101.2645607114196.8345185377192.91727682664608042.624543619.00158.93153164482.67623563724608042.556543619.0994608040.793543621.1164608042.556543619.0992154110.73215.6863128645nullnullnull0nullnull4608042.556543619.0994608042.556543619.099472047204639.9834608188.6543761.321115.4048611111295.4048611111108.0831666667223.48802777781160808014.323944878314.32394487831.66294642861.662946428639.916811342639.9168113426262.7667093006262.76670930064377.2164457.2164679.0414759.0414608301.33