Excel隧洞计算程序(坐标)

**二期城门洞直线段放样程序起点计算参数

X0坐标Y0坐标方位(度)十 进 制起点桩号27907.23249292.99456.153856.2606190.854

隧 洞 参 数

半洞宽度圆心到底板高度成门洞半径城门洞圆心角

3.7500 2.17

4.33120120.0000

纵坡参数

变坡点桩号变坡点高程坡 比

27897.64449280.336 27897.18749280.642 27896.48549281.111 27896.12349281.353 27895.66449281.66 27895.33449281.88 27895.10749282.032 27895.21349281.961 27895.13349282.014 27895.1249282.022 27895.08849282.044 27894.95349282.133 27894.9949282.109 27895.06649282.058 27895.21149281.961 27895.34149281.874 27895.88449281.512 27896.40649281.163 27896.8849280.846 27897.1749280.653 27897.42149280.485 27903.08849282.653 27903.4549282.411 27904.42449281.761

27904.6349281.623

27901.05549284.011 27900.10149284.649 27899.3849285.13 27898.81349285.508 27898.24349285.889 27897.95249286.083 27897.82349286.169 27897.85849286.146 27897.84349286.156 27897.81349286.176 27897.86449286.142 27897.75649286.214 27898.00149286.051 27898.66349285.609 27899.20349285.248 27899.64949284.95

27904.14249287.953 27904.81549287.503 27905.32249287.164 27905.81749286.834 27906.1849286.591 27906.60849286.305 27906.71249286.236 27907.02349286.028 27907.08949285.984 27907.11849285.964 27907.17349285.928 27907.01249286.036 27906.75149286.21 27906.24449286.549 27905.68949286.92 27905.09349287.318

27904.54749287.682

27908.83149290.45 27910.07149290.293 27910.22349290.255 27910.2749290.191 27910.3549290.099 27910.37449290.219 27909.68649290.363 27909.28649290.776 27908.48749290.914 27907.73549291.291 27906.94849291.714 27905.93249292.099 27905.08549292.749 27904.2149293.006 27903.50549292.385 27902.88149292.749 27902.35949292.99 27902.29149292.932 27902.22249293.263 27902.30349293.405 27902.39849293.42 27902.51849293.19 27902.60149293.104 27902.90149293.086 27903.51349292.864

27904.5249292.502

程序