Using Excel and MATLAB to Calculate Liquid Limit of Soil

Meng Hua Fan

doi:10.4028/www.scientific.net/AMR.926-930.3326

Paper Titles

The Stability Analysis for Multivariable System Based on Lyapunov’s Function and its Application in Oil-Water Separation
p.3310

The Stability and Hopf Bifurcation for a Predator-Prey Model with Delays
p.3314

The Synchronization of Two Different Fractional-Order Systems
p.3318

Usage Intensity-Based Optimal Replace-Repair Strategy for Warranty Items
p.3322

Using Excel and MATLAB to Calculate Liquid Limit of Soil
p.3326

Video Steganographic Algorithm Based on Motion Vector
p.3330

Water Surface Floater Clustering Based on Mean Shift
p.3334

A Hybrid Particle Swarm Optimization Algorithm for Dynamic Environments
p.3338

A New Fast Algorithm for Intra Prediction Mode Selection in the High Efficiency Video Coding (HEVC) Standard
p.3342

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 926-930Using Excel and MATLAB to Calculate Liquid Limit...

Using Excel and MATLAB to Calculate Liquid Limit of Soil

Abstract:

This paper explains and demonstrates how to calculate liquid limit of soil with TREND function of Excel and MATLAB via test data. The current graphical methods to determine liquid limit exist estimated reading results being not accurate enough. The TREND function of Excel was introduced and the related Excel worksheet was created, corresponding codes in MATLAB were programming similarly. The method of using Excel spreadsheets or MATLAB is very simple, efficient and accurate.

You might also be interested in these eBooks

Progress in Applied Sciences, Engineering and Technology

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 926-930)

Pages:

3326-3329

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.926-930.3326

Citation:

Cite this paper

Online since:

May 2014

Authors:

Meng Hua Fan*

Keywords:

Excel, Liquid Limit, MATLAB, Soil, TREND Function

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

* - Corresponding Author

References

[1] Zhao Xiushao, Mo Linli, Liu Weil, Ai Chenggang, Research on using Excel internal functions to solve limit moisture content test analytical solutions, J. Experimental Technology and Management. Vol. 30 (2013)13-16. (In Chinese).

Google Scholar

[2] GB/T50123-1999. Code for soil test method. China Planning Press. Beijing. 1999. (In Chinese).

Google Scholar

[3] Information on http: /office. microsoft. com/en-gb/excel-help/trend-function-HP010062548. aspx.

Google Scholar

[4] WANG Jian, SUN Xiu-li, ZHOU Tai-quan, WANG Wei, New method of processing data of soil mechanics experiment by using MATLAB, J. Building Science. Vol. 28 (2012)84-86, 97. (In Chinese).

Google Scholar