Differences

This shows you the differences between two versions of the page.

--- en:resources [2019-07-03] – [Excel Add-ins for data processing] Kamil Nešetřil
+++ en:resources [2023-09-30] (current) – auto Kamil Nešetřil
@@ Line 1: / Line 1: @@
+~~NOTOC~~
+====== Free Software ======
+==== Groundwater Modelling Tools ====
+  * [[usgs>https://water.usgs.gov/water-resources/water-resources-software-catalog/|USGS – Groundwater Software.]] Extremely useful: [[usgs>https://www.usgs.gov/software/modelmuse-a-graphical-user-interface-groundwater-models|ModelMuse]] –  GUI for [[usgs>https://www.usgs.gov/mission-areas/water-resources/science/modflow-and-related-programs?qt-science_center_objects=0|MODFLOW]], MT3D-MS and other.
+  * [[excel>https://www.gsienv.com/software/|GSI Environmental]] – e.g. Excel tools for contamination hydrogeology.
+  * [[https://www.sspa.com/software|S.S. Papadopulos & Associates]]
+  * [[https://www.serdp-estcp.org/Tools-and-Training/Environmental-Restoration/Groundwater-Plume-Treatment|SERDP & ESTCP]] Simple tools for contamination hydrogeology.
+  * [[epa>https://www.epa.gov/research/epa-science-models-and-research-tools-smart-search|US EPA]] search
+  * [[https://www.deltares.nl/en/software/|Deltares]] – e.g. iMOD. Almost all for free (e.g. [[https://oss.deltares.nl/deltares-open-software-welcome|FOSS]]).
+  * [[https://www.pc-progress.com/en/Default.aspx?hydrus-1d|Hydrus-1D]] for unsaturated zone
+  * Geochemistry: [[usgs>https://www.usgs.gov/software/phreeqc-version-3/|PHREEQC]], [[chem>https://www.phreeplot.org/|PhreePlot]], [[chem>https://www.eawag.ch/en/department/surf/projects/chemeql/|ChemEQL]], [[db>https://thermoddem.brgm.fr/|Thermoddem]] (Thermochemical and mineralogical tables for geochemical modeling)
+  * Other: [[https://h2ogeo.upc.edu/software|Universitat Politècnica de Catalunya, Grupo de Hidrología Subterránea]], [[https://www.waterlog.info/software.htm|waterlog.info]], [[https://www.people.ku.edu/~jfdevlin/Software.html|J.F.Devlin]], [[excel>https://sites.google.com/a/hidrogeocol.com.co/carlos_molano/Home|Carlos Molano]] (MS Excels)
+==== Online groundwater tools (calculators) ====
+  * [[git>CAST-IIT/CAST|Contamination Assessment and Site management Tool (CAST)]] – New complex tool focused on BTEX and steady-state plumes. Free registration.
+  * [[usgs>https://ca.water.usgs.gov/projects/gamactt/|Groundwater age mixtures and contaminant trends tool]]
+  * [[https://www.groundwatersoftware.com/calculator.htm|Calculators]] (GroundwaterSoftware.com)
+  * [[epa>https://www3.epa.gov/ceampubl/learn2model/part-two/onsite/b0_onsite.html|EPA On-line Tools for Site Assessment Calculation]]
+  * [[https://www.lmnoeng.com/|The fluid flow calculations]] (Ken Edwards, LMNO Engineering)
+  * [[chem>http://www.aqion.onl/|pH calculator]] (aqion)
+  * [[usgs>https://water.usgs.gov/water-resources/software/DOTABLES/|Dissolved oxygen solubility tables]] (DOTABLES)
+  * [[https://epa-visl.ornl.gov/cgi-bin/visl_search|Vapor intrusion screening levels calculator]] (VISL)
+  * [[https://www.canadianriversinstitute.com/baseflow-separation|Hydrograph Separation Tool]] (SepHydro)
+  * [[https://tu-dresden.de/bu/umwelt/hydro/inowas/research/fields/mar-web|INOWAS DSS]] – Free web-based modeling platform for planning, management and optimisation of Managed Aquifer Recharge (MAR)
+  * [[https://eslog.esdat.net/|ESlog]] – free online borehole profile
+  * [[https://rais.ornl.gov/index.html|Risk Assessment Information System]]
+==== Excel Add-ins for data processing ====
+[[excel>https://www.microsoft.com/en-us/download/details.aspx?id=39379|Microsoft Power Query for Excel]] (in Excel 2016 and later – available directly: //Data → Get & Transform Data//): \\
+cross table (pivot table) to list (normalization) – [[https://medium.com/lets-excel/ms-excel-i-finally-get-it-unpivot-in-power-query-is-awesome-f036145a479|details]].
+[[excel>https://www.asap-utilities.com|ASAP utilities]]\\
+{{:asap.png?direct|My favourite tools in ASAP Utilities}}