《中等强度混凝土高性能化-耐久性模型.xls》由会员分享，可在线阅读，更多相关《中等强度混凝土高性能化-耐久性模型.xls（29页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、表表1.20-11.20-1试试验验原原始始数数据据胶水比粉煤灰磨细矿粉水泥水通过电量B/WF(kg/m3)K(kg/m3)C(kg/m3)W(kg/m3)（库仑）11.91666700345180143022.0555569050230180112932.077844699818016795742.2882356914018017091652.37714300416175102562.4722221009525018093172.8303038216821716591282.857143010038016886792.77142900485175993102.9714291001103101
2、758150000#DIV/0!表表1.20-21.20-2 已已通通过过电电量量为为考考核核指指标标的的线线性性回回归归及及方方差差分分析析水泥磨细矿粉粉煤灰胶水比常数项C(kg/m3)K(kg/m3)F(kg/m3)B/W3.572959243.6032372072.071579564-905.4738582 1777.3492126.1999796347.9594776654.7890915611090.531181281.67137340.742675488119.0687665#N/A#N/A#N/A3.6076794825#N/A#N/A#N/A14177.37116204589.
3、644270886.85581#N/A#N/A#N/A0.861786220.861786220.1193671840.9040453974708.3778432905.4424622652.7276549773.9782170.3321051440.2049352070.1871099840.6894069580.4106093220.3302677420.3166456280.555809822(对应表1.20-2）5.605.600000083.884383.88430-10000.0016180.001618000-100.0044690.004469000000.00271130.0
4、027113 即最优胶水比 粉煤灰掺量B=413.787W=16547.998464C=326.9773843273274848180451.40452.361961356.70260135735752521)(BBT;5078.2/WB%;5998.11FFK(B/W)K(B/W)FK2F2（B/W）0.512155558-8.38528020224.480955140.6322361195.648735194934.02019581868.04039224.48095514-8.385280202B/W24.4809551411.297470390.512155558F8.38528020
5、2-0.512155558-1.264472239K2.50781769911.599801679.379515525KFKWBFWBKFWBKFWBQC5121556.0)/(38528.8)/(480955.246322361.06487352.5)/(0202.9342277142.3246.197)/(029.4890328.73712222.50781769911.599801679.3795155256.289149609134.555398887.97531149 表表1 1 以以通通过过电电量量Q Q为为考考核核指指标标的的二二次次多多项项式式模模型型回回归归分分析析及及方方差
6、差分分析析的的源源数数据据序号胶水比粉煤灰掺量磨细矿粉掺量（B/W）F2K2B/WF(%)K(%)11.916666667003.6736111110022.05555555624.3243243213.513513514.225308642591.6727538182.615047532.07784431119.8847262228.242074934.317436982395.402337797.614796242.28823529417.737789235.989717225.236020761314.62916581295.25974652.377142857005.650808163
7、0062.47222222222.4719101121.348314616.111882716504.9867441455.750536572.8303030317.5588865135.974304078.010615243308.31449551294.15055382.857142857020.833333338.1632653060434.027777892.771428571007.68081632700102.97142857119.2307692321.153846158.829387755369.8224852447.4852071111.916666667003.673611
8、11100122.05555555624.3243243213.513513514.225308642591.6727538182.6150475132.07784431119.8847262228.242074934.317436982395.402337797.6147962142.28823529417.737789235.989717225.236020761314.62916581295.259746152.377142857005.65080816300162.47222222222.4719101121.348314616.111882716504.9867441455.7505
9、365172.8303030317.5588865135.974304078.010615243308.31449551294.150553182.857142857020.833333338.1632653060434.0277778192.771428571007.68081632700202.97142857119.2307692321.153846158.829387755369.8224852447.4852071 表表2 2 以以通通过过电电量量Q Q为为考考核核指指标标的的二二次次多多项项式式模模型型的的回回归归分分析析及及方方差差分分析析FK(B/W)K(B/W)FK2F2（B
10、/W）0.512155558-8.38528020224.480955140.6322361195.648735194934.02019586.44954E-151.02432E-131.42308E-133.05938E-151.96553E-142.55554E-121.000000005.35226E-13#N/A#N/A#N/A#N/A2.13696E+2910#N/A#N/A#N/A#N/A5509532.86467E-24#N/A#N/A#N/A#N/A1.0000005.36568E-161.0000001806.4316921919.7286228477.59157712233
11、.9511323660.1279938266.654176.3059E+276.70139E+272.95936E+284.27063E+288.25928E+281.33581E+291.0000001.0000001.0000001.0000001.0000001.0000001)(BBT659-573-2671221-573500.08500.0823-6-107-1-26231.99371.9937-1-507-6-10.2008070.20080710122-107-5122.797822.797801-10000.0013490.0013490000003-30010-3300-1
12、00000001)(BBTB=C+F+K34511.9166666670037012.055555556905034712.077844311699838912.2882352946914041612.3771428570044512.4722222221009546712.830303038216848012.857142857010048512.7714285710052012.971428571100110011111.91666672.0555555562.07784431 2.28823529090696905098140119.068766534523018018011.91666
13、66670012.05555555624.3243243 13.513513512.07784431119.8847262 28.242074912.28823529417.7377892 35.989717212.3771428570012.47222222222.4719101 21.348314612.8303030317.5588865 35.974304112.857142857020.833333312.7714285710012.97142857119.2307692 21.15384621111 磨细矿渣掺量1.91666672.0555555562.07784431 2.28
14、82352938.81115166024.3243243219.8847262 17.7377892013.5135135128.2420749 35.989717239394144143.67361114.2253086424.31743698 5.236020760591.6727538395.402337 314.62916642.339438180182.6150475797.614796 1295.259750328.7070855561.585928 638.3780184242451451%.3795.9K2.65695B/W10.8061F15.6927K11.91666666
15、70012.05555555624.3243243 13.513513512.07784431119.8847262 28.242074912.28823529417.7377892 35.989717212.3771428570012.47222222222.4719101 21.348314612.8303030317.5588865 35.974304112.857142857020.833333312.7714285710012.97142857119.2307692 21.153846211111.91666672.0555555562.07784431 2.28823529024.
16、3243243219.8847262 17.7377892013.5135135128.2420749 35.98971723.67361114.2253086424.31743698 5.236020760591.6727538395.402337 314.6291660182.6150475797.614796 1295.2597505041.3173653 40.588235311.9166666670012.05555555624.3243243 13.513513512.07784431119.8847262 28.242074912.28823529417.7377892 35.9
17、89717212.3771428570012.47222222222.4719101 21.348314612.8303030317.5588865 35.974304112.857142857020.833333312.7714285710012.97142857119.2307692 21.153846211111.91666672.0555555562.07784431 2.28823529024.3243243219.8847262 17.7377892013.5135135128.2420749 35.98971723.67361114.2253086424.31743698 5.2
18、36020760591.6727538395.402337 314.6291660182.6150475797.614796 1295.25975027.7777777858.6826347 82.35294121)(BBTK=15.6926910.9092B/W0.007897F0.0079B/W0.005806F0.9092020.007897B/W0.0078970.005806F2.6569490910.8060753Q=磨细矿粉掺量粉煤灰掺量胶水比常数项K(%)F(%)B/W3.227714199-197.2459595-4890.029114 7371.32884890.02911
19、4=197.24595953.2277141992.50781769911.599801679.3795155254890.029114197.24595953.2277141991)(BBTFWBKFWBKFWBQ)/(007897.0000602.0002903.0)/(454601.0018894.0083722.0)/(501039.2417821.2222KFKWBFWBKFWBKFWBQC5121556.0)/(38528.8)/(480955.246322361.06487352.5)/(0202.9342277142.3246.197)/(029.4890328.7371222
20、29.0901879323.52211504108.8005199110.8082461(B/W)F(B/W)KFK通过电量（库仑）00014301430.000000511.916666675027.77777778328.707085511291128.99999912.0555555641.3173652758.68263473561.585928957956.999999212.0778443140.5882352982.35294118638.3780176916915.999999112.2882352900010251025.00000112.3771428655.5555555
21、652.77777778479.7374069931930.999999412.4722222249.6969697101.8181818631.6687224912911.999999212.83030303059.523809520867867.000000312.85714286000993993.000000612.7714285757.1428571462.85714286406.8047337815814.999999612.9714285700014301430.000000511.916666675027.77777778328.707085511291128.99999912
22、.0555555641.3173652758.68263473561.585928957956.999999212.0778443140.5882352982.35294118638.3780176916915.999999112.2882352900010251025.00000112.3771428655.5555555652.77777778479.7374069931930.999999412.4722222249.6969697101.8181818631.6687224912911.999999212.83030303059.523809520867867.000000312.85
23、714286000993993.000000612.7714285757.1428571462.85714286406.8047337815814.999999612.97142857磨细矿粉掺量粉煤灰掺量胶水比常数项11K(%)F(%)B/W1.91666667 2.055555563.227714199-197.2459595-4890.029114 7371.3288024.32432432.39843E-137.55733E-131.1969E-111.374E-11013.5135135#N/A#N/A#N/A#N/A3.67361111 4.22530864#N/A#N/A#N/A
24、#N/A0591.672754#N/A#N/A#N/A#N/A0182.6150472.865E-2505051.8813491919514.3287347816.75218027.77777781.81108E+266.81207E+281.66919E+290328.7070851.0000001.0000001.000000 表表1 1 以以通通过过电电量量Q Q为为考考核核指指标标的的二二次次多多项项式式模模型型回回归归分分析析及及方方差差分分析析的的源源数数据据 表表2 2 以以通通过过电电量量Q Q为为考考核核指指标标的的二二次次多多项项式式模模型型的的回回归归分分析析及及方方差差
25、分分析析03-300-3300000000001-1000000.00003270.000032700000.0706940.07069400000.0366260.03662600000.000150.000153452301801804162502173804853101111112.37714286 2.47222222 2.83030303 2.85714286 2.77142857 2.971428570100820010009516810001104162502173804853103.673611110004.22530864 591.672754 182.615047 328.
26、7070854.31743698 395.402337 797.614796 561.5859285.23602076 314.629166 1295.25975 638.3780185.650808160006.11188272 504.986744 455.750537 479.7374078.01061524 308.314495 1294.15055 631.6687228.163265310434.02777807.680816330008.82938776 369.822485 447.485207 406.8047341111112.37714286 2.47222222 2.8
27、3030303 2.85714286 2.77142857 2.97142857022.4719101 17.55888650019.2307692021.3483146 35.9743041 20.8333333021.15384625.65080816 6.11188272 8.01061524 8.16326531 7.68081633 8.829387760504.986744 308.31449500369.8224850455.750537 1294.15055 434.0277780447.4852070479.737407 631.66872200406.804734表表1.2
28、0-51.20-5 通通过过电电量量Q(Q(库库仑仑)序号实测值11430211293957491651025693179128867999310815通过电量模型预测值与实测值的对比11109876543210700800900100011001200130014001500试验序号通过电量Q(库仑）系列1系列2Poly.(系列2)3.673611110004.22530864 591.672754 182.615047504.31743698 395.402337 797.614796 41.31736535.23602076 314.629166 1295.25975 40.588235
29、35.650808160006.11188272 504.986744 455.750537 55.55555568.01061524 308.314495 1294.15055 49.69696978.163265310434.02777807.680816330008.82938776 369.822485 447.485207 57.14285711111112.37714286 2.47222222 2.83030303 2.85714286 2.77142857 2.97142857022.4719101 17.55888650019.2307692021.3483146 35.97
30、43041 20.8333333021.15384625.65080816 6.11188272 8.01061524 8.16326531 7.68081633 8.829387760504.986744 308.31449500369.8224850455.750537 1294.15055 434.0277780447.485207055.5555556 49.69696970057.14285713.673611110004.22530864 591.672754 182.615047 27.77777784.31743698 395.402337 797.614796 58.6826
31、3475.23602076 314.629166 1295.25975 82.35294125.650808160006.11188272 504.986744 455.750537 52.77777788.01061524 308.314495 1294.15055 101.8181828.163265310434.027778 59.52380957.680816330008.82938776 369.822485 447.485207 62.85714291111112.37714286 2.47222222 2.83030303 2.85714286 2.77142857 2.9714
32、2857022.4719101 17.55888650019.2307692021.3483146 35.9743041 20.8333333021.15384625.65080816 6.11188272 8.01061524 8.16326531 7.68081633 8.829387760504.986744 308.31449500369.8224850455.750537 1294.15055 434.0277780447.485207052.7777778 101.818182 59.5238095062.85714292.5010390.0837222.5010390.08372
33、2FWBKFWBKFWBQ)/(007897.0000602.0002903.0)/(454601.0018894.0083722.0)/(501039.2417821.2222003.673611110000024.3243243 13.5135135 4.22530864 591.672754 182.6150475027.777777832919.8847262 28.2420749 4.31743698 395.402337 797.614796 41.3173653 58.682634756217.7377892 35.9897172 5.23602076 314.629166 12
34、95.25975 40.5882353 82.3529412638005.650808160000022.4719101 21.3483146 6.11188272 504.986744 455.750537 55.5555556 52.777777848017.5588865 35.9743041 8.01061524 308.314495 1294.15055 49.6969697 101.818182632020.8333333 8.163265310434.027778059.52380950007.680816330000019.2307692 21.1538462 8.829387
35、76 369.822485 447.485207 57.1428571 62.8571429407003.673611110000024.3243243 13.5135135 4.22530864 591.672754 182.6150475027.777777832919.8847262 28.2420749 4.31743698 395.402337 797.614796 41.3173653 58.682634756217.7377892 35.9897172 5.23602076 314.629166 1295.25975 40.5882353 82.3529412638005.650
36、808160000022.4719101 21.3483146 6.11188272 504.986744 455.750537 55.5555556 52.777777848017.5588865 35.9743041 8.01061524 308.314495 1294.15055 49.6969697 101.818182632020.8333333 8.163265310434.027778059.52380950007.680816330000019.2307692 21.1538462 8.82938776 369.822485 447.485207 57.1428571 62.8
37、5714294071111111112.07784431 2.28823529 2.37714286 2.47222222 2.83030303 2.85714286 2.77142857 2.97 1.9166666719.8847262 17.7377892022.4719101 17.55888650019.2028.2420749 35.9897172021.3483146 35.9743041 20.8333333021.204.31743698 5.23602076 5.65080816 6.11188272 8.01061524 8.16326531 7.68081633 8.8
38、3 3.67361111395.402337 314.6291660504.986744 308.314495003700797.614796 1295.259750455.750537 1294.15055 434.0277780447041.3173653 40.5882353055.5555556 49.69696970057.1058.6826347 82.3529412052.7777778 101.818182 59.5238095062.90561.585928 638.3780180479.737407 631.668722004070模型预测值1430.00000051128
39、.9999994956.9999992915.99999911025.0000005930.9999994911.9999992867.0000003993.0000006814.9999996表表1.20-51.20-5 通通过过电电量量Q(Q(库库仑仑)111111112.0555555562.07784431 2.28823529 2.377142862.4722222222.83030303 2.85714286 2.7714285724.3243243219.8847262 17.7377892022.4719101117.55888650013.5135135128.2420749
40、 35.9897172021.3483146135.9743041 20.833333304.2253086424.31743698 5.23602076 5.650808166.1118827168.01061524 8.16326531 7.68081633591.6727538395.402337 314.6291660504.9867441308.31449500182.6150475797.614796 1295.259750455.75053651294.15055 434.02777805041.3173653 40.5882353055.5555555649.69696970027.7777777858.6826347 82.3529412052.77777778101.818182 59.52380950328.7070855561.585928 638.3780180479.7374069631.6687220012.9714285719.230769221.15384628.82938776369.822485447.48520757.142857162.8571429406.804734