Model¶
Sheet visibility: hidden.
Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.
| Cell | Stored value or cached result | Formula |
|---|---|---|
| A1 | Hantush's Solution for a rectangular infiltration basin to simulate mounding: | |
| E12 | ref: Hantush, M. ,1967, Growth and Decay of Groundwater Mounds in Response to Uniform Percolation,WRR v.3 no.1 | |
| G14 | W = constant rate of percolation | |
| G15 | K = hydraulic conductivity | |
| K17 | 40.666666666666664 | =A27*G40/A26 |
| A24 | Input Values | |
| A25 | 4 | =Results!A7*2 |
| B25 | w | |
| D25 | Percolation Rate (meters/day) | |
| A26 | 0.15 | =Results!A8 |
| B26 | Sy | |
| D26 | Specific Yield | |
| I26 | .02 < S < .3 | |
| A27 | 4 | =Results!A9*2 |
| B27 | K | |
| D27 | Horizontal Hydraulic Conductivity (meters/day) | |
| I27 | K | |
| J27 | 10-1 - 10-3 | |
| L27 | silt, sandy silt, clayey sand | |
| A28 | 2.5 | =Results!A10 |
| B28 | l | |
| D28 | 1/2 length of basin (meters) | |
| J28 | 10-2 - 1 | |
| L28 | sily sand fine sand | |
| A29 | 2.5 | =Results!A11 |
| B29 | a | |
| D29 | 1/2 width of basin (meters) | |
| J29 | 1 - 100 | |
| L29 | well sorted sand | |
| J30 | 10 - 1000 | |
| L30 | gravel | |
| A31 | 0 | =0 |
| B31 | x | |
| D31 | x coordinate (meters) | |
| A32 | 0 | |
| B32 | y | |
| D32 | y coordinate (meters) | |
| A33 | 1.75 | =Results!A12/24 |
| B33 | t | |
| D33 | time (days) | |
| A35 | 3.05 | |
| B35 | hi(0) | |
| D35 | initial head (meters) | |
| H35 | h(te) - h | |
| B36 | h(te) | |
| D36 | head at end of simulation (meters) | |
| H36 | -3.564058345697294 | =A36-B47 |
| D38 | constant of linearization | |
| G40 | 1.525 | =0.5*(A35+A36) |
| A41 | Output | |
| B42 | Simpson | |
| D42 | Trapezoid | |
| G42 | note: for manual calculations (that do not employ the macros associated with the "Re-Calculate Now" button on the Results worksheet), one needs to iterate between solution given in cell b47 and the value for the head needed for linearization cell a36. Result only valid for X,Y obs point in G48, G49 | |
| A43 | h2-hi2 = | |
| B43 | 3.400011891534532 | =((Model!$A$25/(2Model!$A$27))(Model!$K$17Model!$A$33))SUM(Model!B50:E50) |
| C43 | m2 | |
| D43 | 3.3993380824709485 | =((Model!$A$25/(2Model!$A$27))(Model!$K$17Model!$A$33))SUM(Model!B51:E51) |
| E43 | m2 | |
| A45 | h-hi= | |
| B45 | 0.5140583456972942 | =SQRT(B43+(Model!$A$35)^2)-Model!$A$35 |
| C45 | m | |
| D45 | 0.5139638161001225 | =SQRT(D43+(Model!$A$35)^2)-Model!$A$35 |
| E45 | m | |
| A47 | h= | |
| B47 | 3.564058345697294 | =B45+Model!A35 |
| C47 | m | |
| D47 | 3.5639638161001224 | =D45+Model!A35 |
| E47 | m | |
| G47 | Constants and variables needed for calculation | |
| A48 | Integral evaluation: | |
| C48 | 0.001 | |
| D48 | dt | |
| E48 | fixed | |
| G48 | 0 | =Model!B67 |
| H48 | x | |
| I48 | Location of observation point, x direction, meters | |
| B49 | PS1 | |
| C49 | PS2 | |
| D49 | PS3 | |
| E49 | PS4 | |
| G49 | 0 | |
| H49 | y | |
| I49 | Location of observation point, y direction, meters | |
| A50 | Simpson | |
| B50 | 0.023887671369095077 | ='pS1'!L1014 |
| C50 | 0.023887671369095077 | ='pS2'!L1014 |
| D50 | 0.023887671369095077 | ='ps3'!L1014 |
| E50 | 0.023887671369095077 | ='pS4'!L1014 |
| G50 | 281.530104075363 | =(Results!A92(0.5*(Results!A13+Model!G51)))/Results!A8 |
| H50 | ν | |
| I50 | average linear velocity, used in integration | |
| A51 | Trapezoidal | |
| B51 | 0.02388293734757107 | ='pS1'!H1013 |
| C51 | 0.02388293734757107 | ='pS2'!H1013 |
| D51 | 0.02388293734757107 | ='ps3'!H1013 |
| E51 | 0.02388293734757107 | ='pS4'!H1013 |
| G51 | 11.114757805652227 | =Model!C67 |
| H51 | h(te) | |
| I51 | estimated head | |
| G52 | 23.537845123307918 | =((Results!$A$72/(2Results!$A$92))(Model!G50Results!$A$12/24))SUM(Model!B50:E50) |
| H52 | h2-hi2 | |
| A53 | Calculations based on values input in Results worksheet are below | |
| G53 | 1.1147579876175406 | =(SQRT(Model!$G$52+Results!$A$13^2))-Results!$A$13 |
| H53 | h-hi | |
| I53 | calculated head | |
| G54 | 11.11475798761754 | =G53+Results!A13 |
| H54 | h | |
| C56 | Hest | |
| D56 | Hcalc | |
| E56 | Hcalc - Hest | |
| F56 | Hfinal | |
| B57 | 0 | =Results!B18 |
| C57 | 11.114757805652227 | |
| D57 | 11.11475798761754 | =Model!$G$54 |
| E57 | 1.8196531392788984e-07 | =D57-C57 |
| F57 | 11.11475798761754 | |
| G57 | 10.497 | |
| H57 | 20.497 | |
| B58 | 10 | =Results!B19 |
| C58 | 10.486875452132807 | |
| D58 | 11.11475798761754 | =Model!$G$54 |
| E58 | 0.6278825354847335 | =D58-C58 |
| F58 | 10.486867879398066 | |
| G58 | 10.173 | |
| H58 | 20.173 | |
| B59 | 20 | =Results!B20 |
| C59 | 10.24710233008628 | |
| D59 | 11.11475798761754 | =Model!$G$54 |
| E59 | 0.8676556575312606 | =D59-C59 |
| F59 | 10.24709739316538 | |
| B60 | 30 | =Results!B21 |
| C60 | 10.13166360194291 | |
| D60 | 11.11475798761754 | =Model!$G$54 |
| E60 | 0.9830943856746313 | =D60-C60 |
| F60 | 10.131661783515751 | |
| B61 | 40 | =Results!B22 |
| C61 | 10.071639953961744 | |
| D61 | 11.11475798761754 | =Model!$G$54 |
| E61 | 1.0431180336557961 | =D61-C61 |
| F61 | 10.071639737618707 | |
| B62 | 50 | =Results!B23 |
| C62 | 10.041090492544937 | |
| D62 | 11.11475798761754 | =Model!$G$54 |
| E62 | 1.0736674950726037 | =D62-C62 |
| F62 | 10.041090599140507 | |
| B63 | 60 | =Results!B24 |
| C63 | 10.0263876822925 | |
| D63 | 11.11475798761754 | =Model!$G$54 |
| E63 | 1.088370305325041 | =D63-C63 |
| F63 | 10.02638769597553 | |
| B64 | 70 | =Results!B25 |
| C64 | 10.019805225716764 | |
| D64 | 11.11475798761754 | =Model!$G$54 |
| E64 | 1.0949527619007764 | =D64-C64 |
| F64 | 10.01980517217047 | |
| B65 | 80 | =Results!B26 |
| C65 | 10.017089343355233 | |
| D65 | 11.11475798761754 | =Model!$G$54 |
| E65 | 1.097668644262308 | =D65-C65 |
| F65 | 10.017089294261096 | |
| B66 | 90 | =Results!B27 |
| C66 | 10.016062805459622 | |
| D66 | 11.11475798761754 | =Model!$G$54 |
| E66 | 1.0986951821579183 | =D66-C66 |
| F66 | 10.016062779878537 | |
| B67 | 0 | |
| C67 | 11.114757805652227 | |
| D67 | 11.11475798761754 | =Model!$G$54 |
| E67 | 1.8196531392788984e-07 | =D67-C67 |
| F67 | 11.11475798761754 |