液塑限自動計算表和圖學(xué)習(xí)和教練版

液塑限聯(lián)合測定試驗記錄表,,,,,,,,,,,本圖坐標是用雙對數(shù)函數(shù)做的,,,,,,,,,,,,,

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

工程名稱,,第四個注意點在由此向下第四行綠色單元格的批注中,,,,,,,土樣制備說明,,,,,,,,,,,,,,,

試驗次數(shù),,,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,塑性指數(shù),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,第一個注意點后面的批注,,兩點連成的線用的是后面的紅色數(shù)據(jù),,,,,,,,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將趨勢線的公式取出來存在某一個單元格之中，想解決以上問題都需要用到什么知識，在哪里可以查到。請指教。圖表外的好多數(shù)據(jù)都是編程序用的輔助數(shù)據(jù)，不用管他。,,,,,,0.159961615,標準公式系數(shù),,,,,INDEX,引有,,,,,,,,

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

,,,,,,,,,4.179706054,輔助公式系數(shù),,,,,LN,返回給定數(shù)值的自然對數(shù),,,,,,,,

,,,,,,,,,0.780349314,,,,,,LINEST,返回線性回歸方程的參數(shù),,,,,,,,

,,,,,,,,,,,,,,,POWER,返回某數(shù)的乘冪,,,,,,,,

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

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

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