Download as PDF, TXT or read. 2.2 - Essai triaxial 2.3 - Essai de compression simple 2.4 - P. Pendant un essai triaxial cyclique o. Il s’agit d’un limon brun noir BUT DE L’ESSAI: Il s’agit de d Shear strength of a compacted residual soil from consolidated drained and constant water content. Download as PDF, TXT or read. 2.2 - Essai triaxial 2.3 - Essai de compression simple 2.4 - P. Pendant un essai triaxial cyclique o. Il s’agit d’un limon brun noir BUT DE L’ESSAI: Il s’agit de d Shear strength of a compacted residual soil from consolidated drained and constant water content.

It is difficult to determine the Mohr-Coulomb failure envelope visually, and it is strongly influenced by abnormal test data evaluating the shear strength parameters of soil via trend line and unable to adjust the scope of permissible error. So it is recommended to evaluate shear strength parameters of soil using Solver of Excel for direct shear tests and triaxial tests and you can control the allowable deviation. The mathematics model of nonlinear programming was established to evaluate shear strength parameters of soil from the results of direct shear test and triaxial shear test. The related Excel worksheet was created and the optimum results of the objective function were obtained by setting the Solver parameters dialog box accurately. The method is simple, inexpensive and rapid. Abstract: The Information system need to handle a large number of Excel reports, while Excel is not easy to deal with large amounts of data and information extraction. The technology XML tag can be applied to describe data in a text file, using Extensible Style sheet Language (xsl),the XML Data Relationship was conversed to prepare for display.

The same XML data allows a variety of different style sheets, the sheets can be flexible displayed in various ways, using XML technology to create and resolve data, Excel reports can be achieved flexible and efficient import and export. Abstract: The method combining linear programming theory and computer technology, affords the possibility for the Optimization problem of food prescription in engineering design. Excel's Solver function may be used to solve problems with up to 200 decision variables, enough to calculate the most problems about food prescription. Combined design requirement of mayonnaise prescription, the decision variables, constraint condition and mathematics model of cost are established.

The optimization prescription of minimum cost is gotten through the function of Excel programming calculation. It may provide valuable reference for the application of computer in prescription design.

Abstract: Connected with the Serial Communications data manage needed in the industry control, based on the methods of the Serial Communications program and circular queue data sink, with the introduction to Excel interactive objects and objects’s methods, this paper studies the EXCEL tabular methods through Visual C++. Through the electronic controlled high-pressure common-rail part production quality management system, the reliability and stability of the Serial Communications data Excel tabular have been verified.