回弹计算.xls

1、水平 90604530-30-45-60-900 20-6.0-5.0-4.0-3.02.53.03.54.00 21-5.9-4.9-4.0-3.02.53.03.54.00 22-5.8-4.8-3.9-2.92.42.93.43.90 23-5.7-4.7-3.9-2.92.42.93.43.90 24-5.6-4.6-3.8-2.82.32.83.33.80 25-5.5-4.5-3.8-2.82.32.83.33.80 26-5.4-4.4-3.7-2.72.22.73.23.70 27-5.3-4.3-3.7-2.72.22.73.23.70 28-5.2-4.2-3.6-2.62

2、.12.63.13.60 29-5.1-4.1-3.6-2.62.12.63.13.60 30-5.0-4.0-3.5-2.52.02.53.03.50 31-4.9-4.0-3.5-2.52.02.53.03.50 32-4.8-3.9-3.4-2.41.92.42.93.40 33-4.7-3.9-3.4-2.41.92.42.93.40 34-4.6-3.8-3.3-2.31.82.32.83.30 35-4.5-3.8-3.3-2.31.82.32.83.30 36-4.4-3.7-3.2-2.21.72.22.73.20 37-4.3-3.7-3.2-2.21.72.22.73.20

3、 38-4.2-3.6-3.1-2.11.62.12.63.10 39-4.1-3.6-3.1-2.11.62.12.63.10 40-4.0-3.5-3.0-2.01.52.02.53.00 41-4.0-3.5-3.0-2.01.52.02.53.00 42-3.9-3.4-2.9-1.91.41.92.42.90 43-3.9-3.4-2.9-1.91.41.92.42.90 44-3.8-3.3-2.8-1.81.31.82.32.80 45-3.8-3.3-2.8-1.81.31.82.32.80 46-3.7-3.2-2.7-1.71.21.72.22.70 47-3.7-3.2-

4、2.7-1.71.21.72.22.70 48-3.6-3.1-2.6-1.61.11.62.12.60 49-3.6-3.1-2.6-1.61.11.62.12.60 50-3.5-3.0-2.5-1.51.01.52.02.50 检测角度 向上向下 Rma 表面修正值 底面修正值 202.5-3.0 212.4-2.9 222.3-2.8 232.2-2.7 242.1-2.6 252-2.5 261.9-2.4 271.8-2.3 281.7-2.2 291.6-2.1 301.5-2.0 311.4-1.9 321.3-1.8 331.2-1.7 341.1-1.6 351-1.5 3

5、60.9-1.4 370.8-1.3 380.7-1.2 390.6-1.1 400.5-1.0 410.4-0.9 420.3-0.8 430.2-0.7 440.1-0.6 450-0.5 460-0.4 470-0.3 480-0.2 490-0.1 5000.0 y = -0.1x + 4.5 R = 1 0 0.5 1 1.5 2 2.5 3 01020304050 表面修正值表面修正值 测区平均回弹值测区平均回弹值 系列1 线性 (系列1) y = 0.1x - 5 R = 1 -3.5 -3.0 -2.5 -2.0 -1.5 -1.0 -0.5 0.0 0.5 010203040

6、5060 底面修正值底面修正值 测区平均回弹值测区平均回弹值 系列1 线性 (系列1) Rm00.511.522.533.544.555.56 20.010.310.16058.656.153.15048.246.445.143.941.539.637.836.6 48.6605956.653.550.448.646.745.544.341.84038.136.9 48.86059.557.15450.94947.145.944.642.240.338.437.2 49.0606057.554.451.349.447.546.24542.540.638.837.5 49.260605854.8

7、51.749.847.946.645.442.84139.137.8 49.4606058.555.352.150.248.347.145.843.241.339.438.2 49.6606058.955.752.550.648.747.446.243.641.739.738.5 49.8606059.456.2535149.147.846.543.94240.138.8 50.0606059.956.753.451.449.548.246.944.342.340.439.1 50.260606057.153.851.949.948.547.244.642.640.739.4 50.46060

8、6057.654.352.350.34947.745434139.7 50.66060605854.752.750.749.44845.443.441.440 50.860606058.555.153.151.149.848.445.743.741.740.3 51.06060605955.653.551.550.148.846.144.14240.7 51.260606059.4565451.950.549.246.444.442.341 51.460606059.956.454.452.350.949.646.844.742.741.3 51.66060606056.954.852.751

9、.35047.245.14341.6 51.86060606057.355.253.151.750.347.545.443.341.8 52.06060606057.855.753.652.150.747.945.843.742.3 52.26060606058.256.15452.551.148.346.24442.6 52.46060606058.756.554.45351.548.746.544.443 52.66060606059.15754.853.451.94946.944.743.3 52.86060606059.657.455.253.852.349.447.345.143.6

10、 53.0606060606057.855.654.252.749.847.645.443.9 53.2606060606058.356.154.653.150.24845.844.3 53.4606060606058.756.55553.550.548.346.144.6 53.6606060606059.256.955.453.950.648.746.444.9 53.8606060606059.657.355.854.351.34946.845.3 54.060606060606057.856.354.751.749.447.145.6 54.260606060606058.256.75

11、5.152.149.847.546 54.460606060606058.657.155.652.550.247.946.3 54.660606060606059.157.55652.950.548.246.6 54.860606060606059.557.956.453.250.948.547 55.060606060606059.958.456.853.651.348.947.3 55.26060606060606058.857.25451.649.347.7 55.46060606060606059.257.654.45249.648 55.66060606060606059.75854

12、.852.45048.4 55.8606060606060606058.555.252.850.348.7 56.0606060606060606058.955.653.250.749.1 56.2606060606060606059.35653.551.149.4 56.4606060606060606059.756.453.951.449.8 56.660606060606060606056.854.351.850.1 56.860606060606060606057.254.752.250.5 57.060606060606060606057.655.152.550.8 57.26060

13、606060606060605855.552.951.2 57.460606060606060606058.455.953.351.6 57.660606060606060606058.956.353.751.9 57.860606060606060606059.356.75452.3 58.060606060606060606059.75754.452.7 58.26060606060606060606057.454.853 58.46060606060606060606057.855.253.4 58.66060606060606060606058.255.653.8 58.8606060

14、6060606060606058.655.954.1 59.0606060606060606060605956.354.5 59.26060606060606060606059.456.754.9 59.46060606060606060606059.857.155.2 59.6606060606060606060606057.555.6 59.8606060606060606060606057.956 60.0606060606060606060606058.356.4 未录入修正表，直接按公式计算 测点 测区角度修正 133323435353434353434343230352834313

15、3.60033.6031.531.5 23332333031263029283330343430343431.60031.602828 33036303634343034333433343335343333.60033.6031.531.5 43634323235323334303432344228343333.20033.2030.830.8 53233363635343430343234422834334033.90033.9032.132.1 634343836343635343636343336363435350035.0034.134.1 7263635343633362829393

16、5363432283033.40033.4031.231.2 83544363636343538343536383538373335.90035.9035.935.9 932323420253234353637353722253537330033.0030.430.4 103732363635403833353528323434303534.50034.5033.233.2 11#NUM!#NUM! #NUM!#NUM!#NUM! 12#NUM!#NUM! #NUM!#NUM!#NUM! 13#NUM!#NUM! #NUM!#NUM!#NUM! 14#NUM!#NUM! #NUM!#NUM!#

17、NUM! 15#NUM!#NUM! #NUM!#NUM!#NUM! 16#NUM!#NUM! #NUM!#NUM!#NUM! 17#NUM!#NUM! #NUM!#NUM!#NUM! 18#NUM!#NUM! #NUM!#NUM!#NUM! 19#NUM!#NUM! #NUM!#NUM!#NUM! 20#NUM!#NUM! #NUM!#NUM!#NUM! 4845464449474446454245434444444644.9 角度 修正 后回 弹值 碳化 深度 碳化 修正 后回 弹值 测区强度 换算值 1516 平 均 回弹值 91011121314 角度修正 12345678 444444

18、4745504750464748464548454846.4 4745444445454545454348444544444544.7 4846474142444546474445475049454645.8 4748464549504748454642484546474846.8 4548504746484547494847495047464547.3 4748454547484645474545464748474546.2 4849464545474849464847454444434446.1 4442464748494342454447464743424545 464342454749

19、4547484645444647444545.6 测点 测区 1503641423845423636393641444232 2404042424638504450424044404239 3434144424442384344434038404241 4383841404838413642384038364040 5383938365040424640404042444643 6394041424140404140424041414040 7394041404242424544424241404041 8393845464042424241424241394343 9434241424242

20、3414042434243404140 10424245444243414042404140424041 11 12 13 14 15 16 17 18 19 20 141589101112131234567 角度修正 测面 (c/b/d 修正深度修正 3439.3039.3c039.3040.140.1 4041.6041.6c041.604545 3941.7041.7c041.7045.245.2 3939.2039.2c039.2039.939.9 3840.8040.8c040.8043.343.3 4240.5040.5c040.5042.642.6 4241.3041.3c041

21、.3044.344.3 4441.8041.8c041.8045.445.4 4241.8041.8c041.8045.445.4 4241.5041.5c041.5044.844.8 #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! #NUM!#NUM! 角度 修正 后回 弹值 浇面 修正 后回 弹值 测区强度 换算值 16 平 均 回弹值 角度修正浇筑面修正碳化深度修正