Method for solving parameters in Duncan-Chang hyperbolic model based on Excel

A technology of model parameters and hyperbola, which is applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., and can solve the problems of large human influence factors, low efficiency, low accuracy, etc.

Pending Publication Date: 2019-06-21
CENT SOUTH UNIV
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Some scholars also made an Excel spreadsheet for triaxial compression test data processing, but the strength envelopes of several Mohr stress circles are drawn as a straight line, and the two ends of t

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for solving parameters in Duncan-Chang hyperbolic model based on Excel
  • Method for solving parameters in Duncan-Chang hyperbolic model based on Excel
  • Method for solving parameters in Duncan-Chang hyperbolic model based on Excel

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0131] The specific implementation manners of the embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be understood that the specific implementations described here are only used to illustrate and explain the embodiments of the present invention, and are not used to limit the embodiments of the present invention.

[0132] The following describes the method and principle of using Excel to solve the shear strength index of triaxial compression test, see Figure 4 :

[0133] When drawing the strength envelope of each Mohr stress circle, due to the inhomogeneity of the soil sample, human error and equipment error, the strength envelope often cannot be tangent to all Mohr stress circles, and there are always some deviations. According to the planning and solution theory in operations research, the minimum value of the sum of squares of deviations can be solved to determine the strength envelope of the Moiré stress...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention belongs to the field of geotechnical engineering, and discloses a method for solving parameters in Duncan-Chang hyperbolic model based on Excel. The method comprises the following steps: importing triaxial compression test original data into an Excel worksheet; processing Triaxial compression test original data by using an Excel function calculation function to obtain triaxial compression test most basic data, initial data, Auxiliary parameters of a Duncan-Chang hyperbolic model and Model parameters of the Duncan-Chang hyperbolic model; Solving a triaxial compression test shear strength index by utilizing an Excel software planning and solving function; And finally, drawing a plurality of moire stress circles and strength envelope lines by utilizing an Excel software automatic drawing function. According to the invention, the operation is carried out on the visual interface, the operation is simple, the calculation result is accurate, the drawing is automatic, and thegraph is beautiful. And meanwhile, the worksheet can be stored for repeated use, so that the working efficiency is improved. The method disclosed by the invention can be universally applied to experiment teaching and scientific research.

Description

technical field [0001] The invention relates to a method for solving parameters in a Duncan-Zhang hyperbolic model based on Excel, and belongs to the technical field of geotechnical engineering. Background technique [0002] Triaxial compression test is a method to measure the shear strength of soil. Usually, 3 to 4 soil samples are used to apply axial pressure under different confining pressures, and shear until failure. In 1963, based on the test results of a large number of triaxial compression tests, Connor proposed that the stress-strain relationship of the soil is a hyperbolic relationship, that is, [0003] [0004] Where: σ 1 — Axial principal stress [0005] σ 3 — confining pressure [0006] σ 1 -σ 3 —principal stress difference; [0007] ε 1 - axial strain; [0008] a, d—sample constants. [0009] Based on this hyperbolic stress-strain relationship, Duncan et al. proposed a widely used incremental elastic model, generally known as the Duncan-Zhang hype...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/50
CPCY02T90/00
Inventor 阮波丁茴陈洋阮晨希郑世龙
Owner CENT SOUTH UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products