监理检测网论坛

注册

 

发新话题

[推荐] EXCEL 在测量计算中的应用 [复制链接]

1#
[UseMoney=50]
EXCEL 在测量计算中的应用tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


1 前言 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

随着计算机电脑网络和多媒体技术的发展普及,电脑在我们工作和生产中的应用越来越普遍,计算机的操作平台也由DOS过渡成为WINDOWS95、98系列。OFFICE97已成为我们办公必备软件。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

  tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2 电子表格——EXCEL 简介 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.1引用:引用的作用在于标识工作表上的单元格或单元格区域,并指明公式中所使用的数据的位置。通过引用,可以在公式中使用工作表不同部分的数据,或者在多个公式中使用同一单元格的数值。还可以引用同一工作簿不同工作表的单元格、不同工作簿的单元格、甚至其它应用程序中的数据。引用不同工作簿中的单元格称为外部引用。引用其它程序中的数据称为远程引用。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

当复制使用相对引用的公式时,被粘贴公式中的引用将被更新,并指向与当前公式位置相对应的其它单元格。如果不希望在复制公式时,引用发生改变,请使用绝对引用。例如,如果公式将单元格 A5乘以单元格 C1(=A5*C1),现在将公式复制到另一单元格中,则公式中的两个引用都将改变。如果在不希望改变的引用前加一个美元符号($),就可以对单元格 C1 进行绝对引用。如果要对单元格 C1 进行绝对引用,请如下在公式中加入美元符号:=A5*$C$1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3、 EXCEL在测量计算中的应用 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1坐标计算 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

我们可以把路中线分解成为:直线段、前缓和曲线段、圆曲线段、后缓和曲线段分别计算。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.1 资料表(ZL) tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

启动系统,进入EXCEL后,在电子表格中输入基本文字及表头。如交点桩号、JDX、JDY、方位角等等。为了叙述方便我们以石黄高速K25+800——K36+000段为例把表格定为40行。如表1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

在表中键入路线的路由特征及曲线要素。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

校正栏目 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

M3=IF(L3-L2>0,1,-1) tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

然后选第二个工作表。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


                                                      表1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

H tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

I tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

J tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

K tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

L tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

M tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点X tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点 Y tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点里程桩号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

半径 R tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

前缓和曲线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

圆曲线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

后缓和曲线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

方位角度分秒 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

方位角十进制 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

方位角弧度制 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

校正 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

od tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206179.668 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

496425.995 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

23000 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

92.542 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

92.90556 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.62150784 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

14 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205843.98 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503039.881 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29622.399 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

495.176 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3000 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

333.333 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

320.778 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

333.333 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

80.24466 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

80.41294 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.40347064 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

-1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

15 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206483.849 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

506828.215 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

33461.486 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1047.19 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3200 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

315.633 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1418.68 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

315.633 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

111.27567 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

111.4658 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.94544434 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

16 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205219.851 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

510042.69 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

36871.113 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2406.87 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4200 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

353.22 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3746.23 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

353.22 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

55.3229 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

55.54139 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0.96938011 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

-1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

od tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

209567.136 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

516377.893 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

44193.383 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

5276.47 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.2 直线段(ZX—1)如表2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

                                                       表2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
                        tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表中第1、2、行数据源自资料表: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B1=zl!D2;E1=zl!B2;G1=ZL!C2;B2=E1;E2=G1;G3=$B$1; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表中第3行为表格排列: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A4=$G$2; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B4=(A4-$G$2)*COS(RADIANS(ZL!$K$2))+$B$2; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C4=(A4-$G$2)*SIN(RADIANS(ZL!$K$2))+$E$2; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E4=A40+20; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F4=(E4-$G$2)*COS(RADIANS(ZL!$K$2))+$B$2; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G4=(E4-$G$2)*SIN(RADIANS(ZL!$K$2))+$E$2; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A5=INT(A4/20)*20+20;E5=INT(E4/20)*20+20; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


其余单元格分别为选中该列已定义完的单元格按住鼠标向下一拖,即可得到所要桩号坐标。其中“RADIANS()”函数意义为将“()”内的角度数值变为弧度. tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.3第一缓和曲线段(HH1——1)如表3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

                                                        表3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
                        tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表中第1、2、行数据源自资料表: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B1=ZL!F3   ;D1=ZL!G3   ;F1=ZL!K2  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

H1=ZL!D3-ZL!E3  ;B2=ZL!E3*COS(RADIANS($F$1+180))+ZL!B3  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D2=ZL!E3*SIN(RADIANS($F$1+180))+ZL!C3  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F2=ZL!M3  ;A4=$H$1  ;B4=$H$1-A4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C4=B4-B4^5/(40*$B$1^2*$D$1^2)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D4=B4^3/(6*$B$1*$D$1)-B4^7/(336*$B$1^3*$D$1^3)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E4=SQRT(C4*C4+D4*D4)  ;F4=30*B4^2/(PI()*$B$1*$D$1)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G4=$F$1+$F$2*F4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

H4=$B$2+E4*COS(RADIANS(G4))  ;I4=$D$2+E4*SIN(RADIANS(G4))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

其余单元格分别为选中该列已定义完的单元格按住鼠标向下一拖,即可得到所要桩号坐标。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.4圆曲线部分(YQX——1)如表4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

                                                           表4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点桩号= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29622.399 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

JDx= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205843.98 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Jdy= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503039.881 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切线长= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

495.176 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

R= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3000 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Ls= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

333.333 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

园曲线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

320.778 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

顺逆校正= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

-1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

桩    号= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29460.556 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切线方位角= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

89.72245988 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

X0     = tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205858.3527 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Y0      = tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502878.4561 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

桩    号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

点到切点距离 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切点的方位角 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切点到点的距离 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

X1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Y1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29460.556 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

89.7224599 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

0 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205858.3527 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502878.4561 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

7 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29480 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

19.444 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

89.5367834 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

19.4439663 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205858.5099 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502897.8995 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29500 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

39.444 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

89.3457974 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

39.4437166 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205858.8031 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502917.8973 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

9 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29520 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

59.444 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

89.1548115 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

59.4430286 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205859.2295 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502937.8927 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

10 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29540 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

79.444 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

88.9638255 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

79.4416801 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205859.7893 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

502957.8848 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表中曲线要素均源自资料表: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F3=$B$1-$B$2+$F$2  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B4='hh1-1'!F1+90*'hh1-1'!F2*yq1!F2^2/PI()/D2/F2  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D4='hh1-1'!B2+SQRT((yq1!F2yq1!F2^5/40/yq1!D2^2/yq1!F2^2)^2+(yq1!F2^3/6/yq1!D2/yq1!F2yq1!F2^7/336/yq1!D2^3/yq1!F2^3)^2)*COS(RADIANS('hh1-1'!F1+'hh1-1'!F2*30*yq1!F2^2/PI()/yq1!F2/yq1!D2)) tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F4='hh1-1'!D2+SQRT((yq1!F2- tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

yq1!F2^5/40/yq1!D2^2/yq1!F2^2)^2+(yq1!F2^3/6/yq1!D2/yq1!F2-yq1!F2^7/336/yq1!D2^3/yq1!F2^3)^2)*SIN(RADIANS('hh1-1'!F1+'hh1-1'!F2*30*yq1!F2^2/PI()/yq1!F2/yq1!D2)) tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

   表中第5行为表格排列; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A6=$F$3  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B6=A6-$F$3  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C6=$B$4+$D$3*90*B6/3.1415926/$D$2  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D6=2*$D$2*SIN(RADIANS(90*B6/3.1415926/$D$2))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E6=$D$4+D6*COS(RADIANS(C6))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F6=$F$4+D6*SIN(RADIANS(C6))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

其余单元格分别为选中该列已定义完的单元格按住鼠标向下一拖,即可得到所要桩号坐标。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.5第二缓和曲线段(HH1—2)如表5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表中曲线要素均源自资料表: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

                                                          表5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
                        tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B2=yq1!B2*COS(RADIANS($F$1+180))+yq1!$D$1  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D2=yq1!B2*SIN(RADIANS($F$1+180))+yq1!$F$1  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A4=H1-D1  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B4=$H$1-A4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C4=B4-B4^5/(40*$B$1^2*$D$1^2)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D4=B4^3/(6*$B$1*$D$1)-B4^7/(336*$B$1^3*$D$1^3)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E4=SQRT(C4*C4+D4*D4)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F4=30*B4^2/(PI()*$B$1*$D$1)  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G4=$F$1+$F$2*F4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

H4=$B$2+E4*COS(RADIANS(G4))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

I4=$D$2+E4*SIN(RADIANS(G4))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

其余单元格分别为选中该列已定义完的单元格按住鼠标向下一拖,即可得到所要桩号坐标。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.1.6直线段(ZX—2)如表6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

                                                           表6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

D tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

交点桩号= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

29622.399 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

JDx= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205843.98 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Jdy= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503039.881 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

切线长= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

495.176 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

R= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3000 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Ls= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

333.333 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

园曲线长 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

320.778 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

起点桩号= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30114.667 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

直线起X= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205926.45 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

直线起Y= tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503528.14 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

桩号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

X tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Y tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

桩号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

X tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

Y tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30114.667 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205926.45 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503528.141 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30800 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206040.589 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504203.903 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

7 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30120 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205927.34 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503533.4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30820 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206043.92 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504223.623 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30140 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205930.67 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503553.12 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30840 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206047.2509 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504243.344 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

9 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30160 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205934 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503572.841 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30860 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206050.5818 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504263.065 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

10 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30180 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205937.33 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503592.562 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30880 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206053.9127 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504282.785 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

11 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30200 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

205940.66 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

503612.282 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

30900 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

206057.2436 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

504302.506 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E3='hh1-2'!H1  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B4=E1+B2*COS(RADIANS(ZL!K3))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E4=G1+B2*SIN(RADIANS(ZL!$K$3))  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

A6=$E$3  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

B6=(A6-$E$3)*COS(RADIANS(ZL!$K$3))+$B$4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

C6=(A6-$E$3)*SIN(RADIANS(ZL!$K$3))+$E$4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

E6=A40+20  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

F6=(E6-$E$3)*COS(RADIANS(ZL!$K$3))+$B$4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

G6=(E6-$E$3)*SIN(RADIANS(ZL!$K$3))+$E$4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


这样就完成了“直线——缓和曲线——圆曲线——缓和曲线——直线”的计算过程。如果下面还有需要计算,就将“HH1——1”“YQX1”“HH1——2”“ZX2”这四个工作表复制在后面的工作表中即可。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.2路基高程计算: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

路基高程计算就很简单了,下面以‘石—黄高速公路石衡界至沧州市段衡水市分段’中K25+800——K26+520为例:(表7) tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


                                                             表7 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
                        tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

   其中:K25+800——K25+915段纵坡I=-0.0006; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     K25+915——K26+185段为凹竖曲线,半径R=300000,T=135; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     K26+185——K26+300段纵坡I=+0.0003; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     K26+300——K26+500段为凸竖曲线,半径R=200000,T=100; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     K26+500—— 段纵坡I=-0.0007; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G2=20.4  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G3=G2+(A3-A2)*-0.0006  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G4——G8由G3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G9=$G$8-(A9-$A$8)*0.0006+(A9-$A$8)^2/2/300000  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G10——G23由G3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G24=G23+(A24-A23)*0.0003  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G25——G29由G3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G30=$G$29+(A30-$A$29)*(0.0003)-(A30-$A$29)^2/2/200000  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G31——G39由G3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G40=G39-(A40-A39)*0.0007  ; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

     G41——由G3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


3.3路基高程的验收比较 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

路基交验工作是我们经常遇到的,其中最繁琐的就是路基高程的验收比较,对路基高程与设计高程做出比较,我们才可以知道所接收的路基是低还是高,高的需要挖掉,低的需要重新处理,也就可以进行高程索赔。下面我以石黄高速公路E标段的路基接收检测结果的一部分为例,加以说明。如表8: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

当时所检测的点分别为距中线:1.5M、10.25M、12M双幅六个点。其中B、C、D、E、F、G等六列为水平仪的前视读数,本表暂做隐藏处理,表里不做体现。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.1 H、I、J、K、L、M等六列为所测点的高程: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

H3=视线高-B3; tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

I3、J3、K3、L3、M3为H3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.2 N、O、P、Q、R、S等六列为设计高程,数值是从表7中拷贝的。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

表8 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

前视读数 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

实测高程 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

桩号 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

1.5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

8.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.75 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

32800 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.107 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.245 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.332 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.523 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.871 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.733 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.646 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.455 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.378 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

32840 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.029 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.056 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.331 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.365 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.548 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.623 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.949 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.922 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.647 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.613 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.43 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.355 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

5 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

32900 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.102 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.099 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.315 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.365 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.589 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.63 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.876 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.879 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.663 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.613 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.389 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.348 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

6 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

32940 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.181 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.182 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.385 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.447 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.64 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.708 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.908 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.907 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.704 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.642 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.449 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.381 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

33000 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.231 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.195 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.389 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.451 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.695 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

2.759 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.858 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.894 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.7 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.638 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.394 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

18.33 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
                        tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è


3.3.3  T、U、V、W、X、Y等六列为比较值: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

T3=INT((H3-(N3-0.71))*1000); tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

U3、V3、W3、X3、Y3为T3单元格拖出。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

在这六列中使用了条件格式功能,设置单元格的条件格式可以判断单元格是否符合所需条件,如果符合就按指定格式显示。如本表中比较值大于10毫米小于-20毫米的显示为桔黄色。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

    条件格式的具体设置步骤如下: tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.1 选择要设置格式的单元格。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.2 单击“格式”菜单中的“条件格式”。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.3 要把选定单元格中的数值作为格式的条件,单击“单元格值为”选项,接着选定比较词组,然后在合适的框中键入数值。输入的数值可以是常数,也可以是公式,公式前要加上等号(=)。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

除了单元格中的数值外,如果还要对选定单元格中的数据或条件进行评估,可使用公式作格式条件。单击左面框中的“公式为”,在右面的框中输入公式。公式最后的求值结果必须可以判断出逻辑值为真或假。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.4 单击“格式”。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.5 选择要应用的字体样式、字体颜色、边框、背景色或图案,指定是否带下划线。只有单元格中的值满足条件或是公式返回逻辑值真时,Microsoft Excel 才应用选定的格式。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

3.3.3.6 要加入另一个条件,单击“添加”,然后重复步骤 3-5。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

最多可设定三个条件。 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

4、结束语 tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

EXCEL是一个功能很强的软件,它具有强大的运算分析处理能力。本文只是对它在工程测量计算中的使用作了简单的介绍。我们在使用它的时候会发现它能够大大提高我们的工作效率。
[/UseMoney]tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
分享 转发
高处不胜寒 起舞弄清影 何似在人间
                                                醉·清风
TOP
2#

谢谢tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è

tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
TOP
3#

回复:[推荐] EXCEL 在测量计算中的应用

直接上传一张样表嘛,多方便!!tb6 LJ!Ú mbbs.3c3t.comhóÇ!4Nf"è
TOP
发主话题