公路工程的数据处理模板.xls

公路路基、路面的弯沉值相关计算桩号检测值修正值车型系数(二级公路)1.645000150.58083.205修正值标准差（S）3.982000248.40179.619000351.79585.202Lp（2-3）S范围92.1226637000454.09788.98976.1928104000553.92288.702000655.11590.664新平均修正值（Lp）83.991000850.72883.447000953.69288.323新修正值标准差（S）3.652001048.82780.320001149.71181.774Lp（2-3）S范围91.295594001247.48078.10576.6866562001347.13177.531001449.07080.720新平均修正值（Lp）83.994001549.52581.469001749.98482.223新修正值标准差（S）3.383001850.34982.824001951.55184.801Lp（2-3）S范围90.7593133002050.43582.96577.228262002150.52183.107002250.42482.948弯沉值（Lr）84.3252984002354.24489.232002451.06083.993002550.83583.623002650.10682.424002853.18087.482003049.79081.904003154.95590.401003247.65478.391003352.45286.283003453.26287.616003651.06283.996003750.08282.385003852.75686.783003950.40082.907004052.93987.085004148.02979.008004249.36181.198004347.85778.725004450.44182.975004551.17884.187004651.31384.409004750.53083.122004947.36477.914005049.60881.605弯沉值的折线图17 13 19 25 31 37 43 49 55 61 67 73 79 85 9170.000 75.000 80.000 85.000 90.000 95.000 修正值005254.47889.617005348.39679.612005449.79381.909005552.94087.086005652.29186.018005753.20087.515005852.57986.492005948.19179.274006048.76280.213006152.79886.852006251.96985.490006349.15480.859006450.71383.422006551.54384.789006652.49486.352006751.55984.815006849.21980.965007052.33686.093007151.41184.571007253.10187.350007353.17287.468007449.83181.971007549.19180.920007653.72888.382007748.57179.900007847.77478.588007952.83686.916008052.67486.648008254.47089.602008354.15889.089008451.50284.721008551.25484.313008652.26285.971008751.19384.213008848.89880.437008947.29277.796009053.09787.345009152.24185.936009252.62886.573009351.72685.089009448.96080.539009554.01188.848009650.55683.165009749.37781.225009849.41981.294009950.29382.733010050.23982.643弯沉值的折线图17 13 19 25 31 37 43 49 55 61 67 73 79 85 9170.000 75.000 80.000 85.000 90.000 95.000 修正值