缓和曲线坐标计算程序

1、缓缓和和曲曲线线要要素素表表( (设设计计给给定定的的已已知知值值）缓和曲线长L LS S： 50切线长T TH H：圆半径R R： 200转向角：曲线总长L LH H： 125.438切曲差D DH:H:直缓点（ZHZH)坐标:X= 3666171.560Y=缓直点（HZHZ)坐标:X= 3666059.816Y=交点点（JDJD)坐标:X= 3666110.497Y=缓缓和和曲曲线线要要素素计计算算表表（计计算算复复核核值值）内移距p p：0.5208切线增长值q q：切线长T TH H：63.2590缓和曲线角0 0：圆曲线角：7.17147圆曲线长：曲线总长：125.438外矢距：切曲

2、差：1.080直缓点里程：缓缓和和曲曲线线上上任任意意一一点点的的坐坐标标计计算算值值 直直缓缓点点（ZH)ZH)至至缓缓圆圆点点(HY)(HY)段段 直直缓缓点点至至交交点点的的方方位位角角：195.08404缓和曲线长（m)X XY YX XF F0.000010.000010000.000000003666171.56011.000000000.000016673666170.59521.999999990.000133333666169.62932.999999940.000450003666168.66443.999999740.001066673666167.69954.99999

3、9220.002083333666166.73465.999998060.003600003666165.76976.999995800.005716663666164.80587.999991810.008533333666163.84098.999985240.012149993666162.876109.999975000.016666643666161.9121110.999959740.022183283666160.9481211.999937790.028799893666159.9841312.999907180.036616483666159.0211413.99986554

4、0.045733023666158.0581514.999810160.056249493666157.0961615.999737860.068265873666156.1341716.999645040.081882113666155.1721817.999527610.097198183666154.2111918.999380980.114314013666153.2502019.999200000.133329523666152.2902120.998978970.154344643666151.3312221.998711590.177459243666150.3722322.99

5、8390910.202773203666149.4132423.998009340.230386353666148.4562524.997558590.260398503666147.4992625.997029660.292909433666146.5422726.996412770.328018873666145.5872827.995697410.365826513666144.6322928.994872210.406431993666143.6783029.993925000.449934913666142.7253130.992842710.496434783666141.7733

6、231.991611390.546031073666140.8223332.990216150.598823163666139.8723433.988641140.654910353666138.9233534.986869530.714391853666137.9753635.984883460.777366773666137.0283736.982664010.843934133666136.0823837.980191210.914192813666135.1383938.977443950.988241573666134.1944039.974400001.06617905366613

7、3.2524140.971035951.148103713666132.3124241.967327191.234113873666131.3734342.963247891.324307683666130.4354443.958770941.418783103666129.4994544.953867971.517637893666128.5644645.948509261.620969593666127.6314746.942663751.728875533666126.6994847.936299011.841452773666125.7704948.929381191.95879815

8、3666124.8425049.921875002.081008183666123.916缓缓和和曲曲线线上上任任意意一一点点的的坐坐标标计计算算值值 圆圆缓缓点点(YH)(YH)至至缓缓直直点点（HZ)HZ)段段 缓缓直直点点至至交交点点的的方方位位角角：36.45253缓和曲线长（m)X XY YX XF F0.000010.0000.0003666059.81611.0000.0003666060.61722.0000.0003666061.41833.0000.0003666062.22044.0000.0013666063.02155.0000.0023666063.82366.00

9、00.0043666064.62577.0000.0063666065.42888.0000.0093666066.23199.0000.0123666067.034109.999975000.016666643666067.8381110.999959740.022183283666068.6421211.999937790.028799893666069.4471312.999907180.036616483666070.2531413.999865540.045733023666071.0601514.999810160.056249493666071.8671615.999737860

10、.068265873666072.6761716.999645040.081882113666073.4851817.999527610.097198183666074.2951918.999380980.114314013666075.1062019.999200000.133329523666075.9192120.998978970.154344643666076.7322221.998711590.177459243666077.5472322.998390910.202773203666078.3632423.998009340.230386353666079.1812524.997

11、558590.260398503666079.9992625.997029660.292909433666080.8202726.996412770.328018873666081.6412827.995697410.365826513666082.4652928.994872210.406431993666083.2893029.993925000.449934913666084.1163130.992842710.496434783666084.9443231.991611390.546031073666085.7743332.990216150.598823163666086.60534

12、33.988641140.654910353666087.4393534.986869530.714391853666088.2743635.984883460.777366773666089.1123736.982664010.843934133666089.9513837.980191210.914192813666090.7923938.977443950.988241573666091.6354039.974400001.066179053666092.4814140.971035951.148103713666093.3284241.967327191.234113873666094

13、.1784342.963247891.324307683666095.0304443.958770941.418783103666095.8844544.953867971.517637893666096.7404645.948509261.620969593666097.5994746.942663751.728875533666098.4604847.936299011.841452773666099.3244948.929381191.958798153666100.1895049.921875002.081008183666101.058圆圆曲曲线线上上任任意意一一点点的的坐坐标标计计

14、算算值值 缓缓圆圆点点（HY)HY)至至圆圆缓缓点点(YH)(YH)段段 圆圆心心至至交交点点的的方方位位角角：115.57008圆圆心心至至圆圆弧弧起起点点的的方方位位角角：112.182345圆圆心心坐坐标标：X=X= 3666199.827Y=圆曲线长（m)X XY YX XF F0.000013666123.91513666122.99023666122.0683366612122953666119.31363666118.39973666117.48683666116.57693666115.668103666114.762113666113.8581236

15、66112.95612.718953666112.309133666112.056143666111.159153666110.264163666109.371173666108.480183666107.591193666106.705203666105.821213666104.940223666104.061233666103.184243666102.310253666101.43825.43793666101.05763.25921.364091.080467608.067467553.685467591.54024.98707.0943125.4384.14055.264Y YF

16、F里里程程点点位位名名称称467608.0675.264直直缓缓点点467607.8066.264缓和曲线467607.5447.264缓和曲线467607.2838.264缓和曲线467607.0219.264缓和曲线467606.75910.264缓和曲线467606.49611.264缓和曲线467606.23312.264缓和曲线467605.96913.264缓和曲线467605.70414.264缓和曲线467605.43815.264缓和曲线467605.17216.264缓和曲线467604.90417.264缓和曲线467604.63518.264缓和曲线467604.365

17、19.264缓和曲线467604.09420.264缓和曲线467603.82121.264缓和曲线467603.54722.264缓和曲线467603.27123.264缓和曲线467602.99324.264缓和曲线467602.71325.264缓和曲线467602.43226.264缓和曲线467602.14827.264缓和曲线467601.86328.264缓和曲线467601.57529.264缓和曲线467601.28530.264缓和曲线中点467600.99231.264缓和曲线467600.69732.264缓和曲线467600.40033.264缓和曲线467600.1

18、0034.264缓和曲线467599.79735.264缓和曲线467599.49136.264缓和曲线缓缓和和曲曲线线要要素素表表( (设设计计给给定定的的已已知知值值）缓缓和和曲曲线线要要素素计计算算表表（计计算算复复核核值值）缓缓和和曲曲线线上上任任意意一一点点的的坐坐标标计计算算值值 直直缓缓点点（ZH)ZH)至至缓缓圆圆点点(HY)(HY)段段 467599.18237.264缓和曲线467598.87038.264缓和曲线467598.55539.264缓和曲线467598.23740.264缓和曲线467597.91541.264缓和曲线467597.59042.264缓和曲线4

19、67597.26243.264缓和曲线467596.93044.264缓和曲线467596.59445.264缓和曲线467596.25546.264缓和曲线467595.91247.264缓和曲线467595.56448.264缓和曲线467595.21349.264缓和曲线467594.85850.264缓和曲线467594.49851.264缓和曲线467594.13452.264缓和曲线467593.76653.264缓和曲线467593.39354.264缓和曲线467593.01655.264缓圆点Y YF F里里程程点点位位名名称称467553.685130.702缓直点4675

20、54.283129.702缓和曲线467554.882128.702缓和曲线467555.480127.702缓和曲线467556.078126.702缓和曲线467556.675125.702缓和曲线467557.273124.702缓和曲线467557.869123.702缓和曲线467558.466122.702缓和曲线467559.061121.702缓和曲线467559.656120.702缓和曲线467560.250119.702缓和曲线467560.843118.702缓和曲线467561.435117.702缓和曲线467562.026116.702缓和曲线467562.616

21、115.702缓和曲线467563.205114.702缓和曲线467563.792113.702缓和曲线467564.378112.702缓和曲线467564.963111.702缓和曲线467565.546110.702缓和曲线467566.128109.702缓和曲线467566.707108.702缓和曲线467567.285107.702缓和曲线467567.861106.702缓和曲线467568.435105.702缓和曲线中点467569.008104.702缓和曲线467569.577103.702缓和曲线缓缓和和曲曲线线上上任任意意一一点点的的坐坐标标计计算算值值 圆圆缓缓

22、点点(YH)(YH)至至缓缓直直点点（HZ)HZ)段段 36.45253467570.145102.702缓和曲线467570.711101.702缓和曲线467571.274100.702缓和曲线467571.83499.702缓和曲线467572.39298.702缓和曲线467572.94797.702缓和曲线467573.50096.702缓和曲线467574.05095.702缓和曲线467574.59694.702缓和曲线467575.14093.702缓和曲线467575.68192.702缓和曲线467576.21891.702缓和曲线467576.75290.702缓和曲线4

23、67577.28389.702缓和曲线467577.81088.702缓和曲线467578.33487.702缓和曲线467578.85486.702缓和曲线467579.37185.702缓和曲线467579.88384.702缓和曲线467580.39183.702缓和曲线467580.89682.702缓和曲线467581.39681.702缓和曲线467581.89280.702圆缓点467407.982Y YF F里里程程点点位位名名称称467593.01555.264圆弧起点（缓圆点）467592.63356.264圆曲线467592.24757.264圆曲线467591.8565

24、8.264圆曲线467591.46059.264圆曲线467591.06060.264圆曲线467590.65561.264圆曲线467590.24662.264圆曲线467589.83263.264圆曲线467589.41364.264圆曲线467588.99065.264圆曲线467588.56266.264圆曲线467588.13067.264圆曲线467587.81767.983圆曲线中点467587.69468.264圆曲线467587.25369.264圆曲线467586.80770.264圆曲线467586.35771.264圆曲线467585.90372.264圆曲线46758

25、5.44473.264圆曲线467584.98074.264圆曲线467584.51275.264圆曲线467584.04076.264圆曲线467583.56477.264圆曲线圆圆曲曲线线上上任任意意一一点点的的坐坐标标计计算算值值 缓缓圆圆点点（HY)HY)至至圆圆缓缓点点(YH)(YH)段段 467583.08278.264圆曲线467582.59779.264圆曲线467582.10780.264圆曲线467581.89180.702圆弧终点（圆缓点）直直线线段段（K116+527.000K116+645.717K116+527.000K116+645.717）距距中中距距、开开口口

26、线线计计算算程程序序已知点点名X坐标Y坐标直线段起点坐标：3665632.390465850.372直线段终点坐标：3665684.946465956.822起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：直线段起点至终点方位角：63.43255直线段起点桩号：116527.000直线段终点桩号：116645.717测点点位里程X坐标Y坐标左开口线点116563.4883665728.809465843.461左开口线点116563.4873665648.543465883.089右开口线点116563.4883665593.580465910.226左开口线点上游超界

27、3665585.029465754.441右开口线点下游超界3665694.123465976.532左开口线点116562.4953665720.456465846.478右开口线点116564.0463665603.174465906.111说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K116+527K116+645.717K116+527K116+645.717桩桩号号范范围围内内直直线线段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不

28、不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)131.430-89.5161.65551561131.3800.000-87.75989725131.31061.297-26.32289125136.434-0.001-97.86655803136.4340.497-97.37112853130.906-80.690-6.12199335131.17250.873-36.47125188直直线线段段（K116+527.000K116+645.717K116

29、+527.000K116+645.717）距距中中距距、开开口口线线计计算算程程序序圆圆弧弧段段（116+645.717116+833.902116+645.717116+833.902）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标圆心坐标：3665236.610466178.170直圆点坐标：3665684.946465956.822圆直点坐标：3665734.920466137.100起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：圆心至直圆点的方位角：333.43263圆心至直圆点的半径：500.000圆心至圆直点的方位角：355.17183圆

30、心至圆直点的半径：500.000测点点位里程X坐标Y坐标左开口线点116667.5203665761.698465946.824左开口线点116667.5203665694.169465976.576右开口线点116667.5203665626.587466006.352左开口线点上游超界3665675.105465936.890左开口线点下游超界3665736.894466161.042说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K116+645.717K116+833.902K116+645.717K116+833.902桩桩号号范范围围内内的的圆圆弧弧段段；2 2、本本程程

31、序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。起算桩号（直圆点）： 116645.717终止桩号（圆直点）： 116833.902H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)131.430-73.793-14.06702387131.380-0.0004-87.75962068131.31073.850-13.76960478136.4

32、34-0.494-97.37434027136.434-0.577-97.29088402圆圆弧弧段段（116+645.717116+833.902116+645.717116+833.902）距距中中距距、开开口口线线计计算算程程序序直直线线段段（K116+833.902K118+163.155K116+833.902K118+163.155）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标直线段起点坐标：3665734.920466137.100直线段终点坐标：3665844.090467461.863起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：

33、直线段起点至终点方位角：85.17206直线段起点桩号：116833.902直线段终点桩号：118163.155测点点位里程X坐标Y坐标左开口线点116857.9253665807.562466155.218左开口线点116857.9263665736.894466161.043右开口线点116857.9273665666.236466166.866右开口线点上游超界3665733.124466119.232左开口线点下游超界3665846.170467482.132左开口线点116858.7563665794.665466157.115右开口线点116857.4853665683.64846

34、6164.988说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K116+833.902K118+163.155K116+833.902K118+163.155桩桩号号范范围围内内的的直直线线段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)132.550-70.9

35、09-19.191132.590-0.001-90.179132.82070.897-19.743132.2900.322-89.258132.240-0.408-89.072130.906-57.899-28.913131.17253.389-33.955直直线线段段（K116+833.902K118+163.155K116+833.902K118+163.155）距距中中距距、开开口口线线计计算算程程序序圆圆弧弧段段（118+163.155118+392.978118+163.155118+392.978）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标圆心坐标：36663

36、42.470467421.420直圆点坐标：3665844.108467461.862圆直点坐标：3665913.774467678.753起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：圆心至直圆点的方位角：175.21382圆心至直圆点的半径：500.000圆心至圆直点的方位角：149.01297圆心至圆直点的半径：500.001测点点位里程X坐标Y坐标左开口线点118183.5163665903.406467475.117左开口线点118183.5313665846.170467482.132右开口线点118183.5323665790.256467488.973

37、右开口线点118183.5323665790.256467488.973右开口线点118183.5323665790.256467488.973右开口线点118183.5323665790.256467488.973右开口线点上游超界3665842.204467438.764右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界366

38、5921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712右开口线点下游超界3665921.554467691.712说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K118+163.155K118+392.978K118+163.155K118+392.978桩桩号号范范围围内内的的圆圆弧弧段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据

39、不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。起算桩号（直圆点）： 118163.155终止桩号（圆直点）： 118392.978H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)135.613-57.665-38.56135231134.5000.000-93.99963694136.43456.331-41.53742417136.43456.331-41.53742417136.43456.

40、331-41.53742417136.43456.331-41.53742417136.4340.567-97.3014359136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000766136.4340.228-97.64000

41、766136.4340.228-97.64000766圆圆弧弧段段（118+163.155118+392.978118+163.155118+392.978）距距中中距距、开开口口线线计计算算程程序序直直线线段段（K118+392.978-K118+646.660K118+392.978-K118+646.660）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标直线段起点坐标：3665913.774467678.753直线段终点坐标：3666044.343467896.253起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：直线段起点至终点方位角：59.0

42、1224直线段起点桩号：118392.978直线段终点桩号：118646.660测点点位里程X坐标Y坐标左开口线点118408.0913665968.706467663.403左开口线点118408.0933665921.554467691.712右开口线点118408.0953665873.756467720.408左开口线点上游超界3665907.100467667.292右开口线点下游超界3666055.600467916.010左开口线点118408.0753665954.637467671.831右开口线点118408.1263665885.810467713.208说说明明：1 1

43、、本本程程序序只只适适用用于于主主渠渠道道K116+833.902K118+163.155K116+833.902K118+163.155桩桩号号范范围围内内的的直直线线段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)136.800-54.998-43.602136.780

44、-0.0004-98.560136.55055.750-42.350136.630-0.177-98.083137.4300.517-99.343136.880-38.598-60.162136.52041.709-56.331直直线线段段（K118+392.978-K118+646.660K118+392.978-K118+646.660）距距中中距距、开开口口线线计计算算程程序序圆圆弧弧段段（118+646.660118+968.294118+646.660118+968.294）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标圆心坐标：3665615.650468153.

45、590直圆点坐标：3666044.343467896.253圆直点坐标：3666113.019468204.820起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：圆心至直圆点的方位角：329.01276圆心至直圆点的半径：500.000圆心至圆直点的方位角：365.52510圆心至圆直点的半径：500.000测点点位里程X坐标Y坐标左开口线点118669.4013666102.680467890.586左开口线点118669.4013666055.600467916.010右开口线点118669.4013666007.572467941.946左开口线点上游超界3666

46、030.596467873.353左开口线点下游超界3666111.312468221.385左开口线点118669.2763666086.104467899.386右开口线点118669.3963666018.498467936.041说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K118+646.660K118+968.294K118+646.660K118+968.294桩桩号号范范围围内内的的圆圆弧弧段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它

47、它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。起算桩号（直圆点）： 118646.660终止桩号（圆直点）： 118968.294H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)137.840-53.506-47430-0.0003-99.8597411137.48054.583-45.3767002137.550-0.712-99.3875485137.640-0.277-100.0030964137.631-34.740-65.52221306137.45242

48、.164-57.74030099圆圆弧弧段段（118+646.660118+968.294118+646.660118+968.294）距距中中距距、开开口口线线计计算算程程序序直直线线段段（K118+968.294-K120+423.213K118+968.294-K120+423.213）距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标直线段起点坐标：3666113.019468204.820直线段终点坐标：3665963.947469652.091起算高程：130边坡起算坡比：2.000坡脚至中心线距离：85底板坡比：直线段起点至终点方位角：95.52511直线段起点桩号

49、：118968.294直线段终点桩号：120423.213测点点位里程X坐标Y坐标左开口线点118984.9473666164.967468226.912右开口线点118984.9473666111.312468221.385右开口线点118984.9473666057.176468215.809右开口线点上游超界3666113.970468194.549右开口线点下游超界3665963.947469652.091左开口线点118985.0083666154.862468225.932右开口线点118999.8763666070.355468232.175左开口线点120423.1793665

50、963.971469652.050说说明明：1 1、本本程程序序只只适适用用于于主主渠渠道道K118+968.294-K120+423K118+968.294-K120+423桩桩号号范范围围内内的的直直线线段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。H高程距中距(m)（左负右正）开口线偏差值偏外为正偏内为负（m)137.750-5

51、3.938-46.562137.6400.0008-100.279137.52054.423-45.617137.5100.106-99.914137.4300.000-99.860137.737-43.786-56.688137.58339.637-60.529137.430-0.020-99.840直直线线段段（K118+968.294-K120+423.213K118+968.294-K120+423.213）距距中中距距、开开口口线线计计算算程程序序白白条条河河引引渠渠（0+0000+7000+0000+700）开开挖挖距距中中距距、开开口口线线计计算算程程序序已知点点名X坐标Y坐标说说明明：1 1、本本程程序序只只适适用用于于引引渠渠0+0000+8000+0000+800桩桩号号范范围围内内直直线线段段；2 2、本本程程序序中中用用黄黄颜颜色色界界定定的的范范围围内内数数据据不不得得更更改改；3 3、计计算算时时只只输输入入緑緑色色界界定定范范围围内内的的数数据据，其其它它数数据据不不得得人人工工输输入入；4 4、如如果果计计算算时时行行数数不不够够则则从从A A列列至至N N列列向向下下拉拉即即可可。直线段起点