中等强度混凝土高性能化-耐久性模型.xls

表表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.9714291001103101758150000#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.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.0027113 即最优胶水比 粉煤灰掺量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.385280202-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为为考考核核指指标标的的二二次次多多项项式式模模型型回回归归分分析析及及方方差差分分析析的的源源数数据据序号胶水比粉煤灰掺量磨细矿粉掺量（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.6508081630062.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.67361111100122.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.7505365172.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/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.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-100000001)(BBTB=C+F+K34511.9166666670037012.055555556905034712.077844311699838912.2882352946914041612.3771428570044512.4722222221009546712.830303038216848012.857142857010048512.7714285710052012.971428571100110011111.91666672.0555555562.07784431 2.28823529090696905098140119.068766534523018018011.9166666670012.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.2882352938.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.9166666670012.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.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.989717212.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.236020760591.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.029114=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.737122229.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.5555555652.77777778479.7374069931930.999999412.4722222249.6969697101.8181818631.6687224912911.999999212.83030303059.523809520867867.000000312.85714286000993993.000000612.7714285757.1428571462.85714286406.8047337815814.999999612.9714285700014301430.000000511.916666675027.77777778328.707085511291128.99999912.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.85714286000993993.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#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为为考考核核指指标标的的二二次次多多项项式式模模型型的的回回归归分分析析及及方方差差分分析析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.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.83030303 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.20-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.58823535.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.9743041 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.68263475.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.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.485207052.7777778 101.818182 59.5238095062.85714292.5010390.0837222.5010390.083722FWBKFWBKFWBQ)/(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 1295.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.82938776 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.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.82938776 369.822485 447.485207 57.1428571 62.85714294071111111112.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.83 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.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 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