The following are some spreadsheet solutions for typical themes in an
introductory soil mechanics courses. The files may be downloaded
to
your pc.
Basic spreadsheets:
TEMA/THEME
| PHASE:
Jord/vann/luft-forhold/Phase diagram
Grafisk fasediagram. Graphical solution of the soil phase relationships |
Excel 5.0 or Excel 97 |
| GSD:
Kornfordelingskurver/Grain size distribution
Plotting og klassifisering av sikte- og hydrometeranalyser. Plotting and classification of GSD and hydrometer test results |
Excel 5.0 or Excel 97 |
| STRESS:
Spenningsprofil/Intial stress profiles
Vertikal og horisontalspennninger i jorden Vertical and horizontal in situ stresses |
Excel 5.0 or Excel 97 |
| DISTRIB:
Spenningsfordeling med dybden/Stress distributions
Spenningsfordeling i dypet med elastisk, plastisk, 2:1 og konstant last Stress distributions assuming elasticity, plasticity, 2:1 and uniform loading |
Excel 5.0 or Excel 97 |
| CIRCLE: Mohrs
sirkel/Mohr's circle
Interaktivt redskap for å vurdere spenninger på vilkårlig plan. Dyamic interactive Mohr's circle solved using the pole approach |
Excel 5.0 or Excel 97 |
| OEDOMINT:
Ødometertolkning/Oedometer interpretation
Beregnings- og tolkningsverktøy for ødometerdata. Processing and interpretation of oedometer test data |
Excel 5.0 or Excel 97 |
| OEDOMSIM:
Ødometer simulator/Oedometer simulator
Simuler en ødometer test Simulation of an oedometer test |
Excel 5.0 or Excel 97 |
| SETTLE:
Setningsanalyse/Settlement analysis
Beregn setninger i sand og leire Estimating settlements in sand and clay |
Excel 5.0 or Excel 97 |
| TRIAXPLT:
Treaksplotting/Triaxial plotter
Tolker og presenterer treaksresultat i forskjellige format Presents triaxial data in various formats |
Excel 5.0 or Excel 97 |
Advanced spreadsheets
TEMA/THEME
| Box element illustration | Excel |
| Bearing capacity | Excel |
| Earth pressure zones | Excel |
| Critical State parameters from undrained triaxial test | Visual Basic |
Redaktør: Rolf Sandven, Kontaktadresse:
webmaster, Sist
oppdatert: 07.01.2002.