液塑限自动计算表和图学习和教练版

液塑限联合测定试验记录表,,,,,,,,,,,本图坐标是用双对数函数做的,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,

工程名称,,第四个注意点在由此向下第四行绿色单元格的批注中,,,,,,,土样制备说明,,,,,,,,,,,,,,,

试验次数,,,1,,2,,3,,,,,,,,,,X,,Y,,X,,Y,

试验项目,,,,,,,,,,,,,,,,,10,1,10,1,1,10,1,10

入土深度（mm),h1,,4.3,,10.8,,20.2,,,,,,,,,,20,1,10,2,2,10,1,20

,h2,,4.3,,10.5,,20.2,,,,,,,,,,30,1,10,3,3,10,1,30

,平均入土深度,,4.3,,10.6,,20.2,,,,,,,,,,40,1,10,4,4,10,1,40

含水量%,盒号,,2,8,6,3,9,11,,,,,,,,,50,1,10,5,5,10,1,50

,盒重g,,19.4,13.6,19.8,14.7,14.8,20.4,,,,,,,,,60,1,10,6,6,10,1,60

,盒+湿土重g,,44.5,38.5,48.2,41.5,44.9,50.5,,,,,,,,,70,1,10,7,7,10,1,70

,盒+干土重g,,66.7,60.5,70.7,62.7,65.9,71.4,液限Wl=,43.3,第二个注意点在批注中,,,,,,80,1,10,8,8,10,1,80

,水份重g,,2.9,2.9,5.9,5.6,9.1,9.2,塑限Wp=,9.5,,,,,,,90,1,10,9,9,10,1,90

,干土重g,,22.2,22.0,22.5,21.2,21.0,20.9,塑性指数,Ip=,Wl,-,Wp,=,33.8,,100,1,10,10,10,10,1,100

,含水量%,,13.0,13.1,26.3,26.6,43.4,43.9,备注:,,,,,,,,,,10,20,20,10,1,

,平均含水量%,,13.0,,26.5,,43.6,,,,,,,,,,,,10,30,30,10,1,

,,,,第三个注意点在上面批注中,,,,,,,,,,,,,,,,,,10,1,

,,,0.041083693,0.89749568,0.136999239,0.859513843,0.253917552,0.434898924,第一个注意点后面的批注,,两点连成的线用的是后面的红色数据,,,,,,,,10,40,40,10,1,

盒号及重量,,,0.096058314,,0.284557773,,0.365689195,,,,,,,,,4.3,20.2,,10,50,50,10,1,

1,2,3,4,5,6,7,8,9,10,11,,,,,,13.0,43.6,,10,60,60,10,1,

23.4,19.4,14.7,15.6,13.5,19.8,17.6,13.6,14.8,19.2,20.4,,,,,,4.3,10.64791225,20.2,10,70,70,10,1,

0.899612889,0.413512787,0.433805467,0.582898309,0.363452647,0.218282425,0.492434513,0.414296309,0.958120663,0.528684713,0.309517255,,,,,,13.0,26.5,43.6,10,90,90,10,1,

2,8,6,3,9,11,5,7,1,4,10,,,,,,,,,10,100,100,10,1,

含水量的范围,,,1,,2,,3,,,,,,,,,,,,,,,,,

,,,12,15,25,30,40,45,,,,,,,,,,,,,,,,

,,,顺便给我讲一下如何用VBA将趋势线的公式取出来存在某一个单元格之中，想解决以上问题都需要用到什么知识，在哪里可以查到。请指教。图表外的好多数据都是编程序用的辅助数据，不用管他。,,,,,,0.159961615,标准公式系数,,,,,INDEX,引有,,,,,,,,

,,,,,,,,,1.281477387,,,,,,EXP,返回e的n次方,,,,,,,,

,,,,,,,,,4.179706054,辅助公式系数,,,,,LN,返回给定数值的自然对数,,,,,,,,

,,,,,,,,,0.780349314,,,,,,LINEST,返回线性回归方程的参数,,,,,,,,

,,,,,,,,,,,,,,,POWER,返回某数的乘幂,,,,,,,,

,,,,,,,,,2.608532134,砂土塑限入土深度,,,,,,,,,,,,,,

,,,,,,,,,2.871024632,粘土塑限入土深度,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,