EXCEL ADD-IN TO MODEL THE SOIL COMPRESSION CURVE
AUTOR(ES)
Gubiani, Paulo I., Reinert, Dalvan J., Reichert, José M., Goulart, Rafael Z., Fontanela, Eracilda
FONTE
Eng. Agríc.
DATA DE PUBLICAÇÃO
2017-06
RESUMO
ABSTRACT Soil compression curve (CC) provides parameters to identify soil load-bearing capacity and susceptibility to compaction. An Excel add-in (ACC) incorporating graphical procedures for mathematical models for soil CC description and calculation of parameters was developed. By using the ACC, soil CC can be described by means of the Casagrande method, mathematically operationalized with the van Genuchten equation, with or without restrictions on its parameters, and by Dias Junior and Pierce method in its original form and also modified using the void ratio rather than soil bulk density. The ACC uses a single Excel spreadsheet for input and output data, in addition to a graphical interface and a tool for exporting editable charts. Compared to SAS statistical software, the ACC minimized the sum of squared residuals and estimated parameters of mathematical models with the same efficiency for 347 compression curves. The ACC programming script is available and can be modified or used as a framework for other programming projects.
Documentos Relacionados
- Water retention curve to analyze soil structure changes due to liming
- DYNAMIC OF PRESSURE-DEFORMATION CURVE IN UNIAXIAL COMPRESSION TEST IN DIFFERENT LOAD TIMES
- Effects of lysine-to-glycine mutations in the ATP-binding consensus sequences in the AddA and AddB subunits on the Bacillus subtilis AddAB enzyme activities.
- The Romanow reforms: add to shopping cart
- Chemical migration during soil water retention curve evaluation