| Author |
 Topic  |
|
|
Ashmita
Junior Member
USA
3 Posts |
 Posted - 03/23/2006 : 21:59:54
|
I am looking for a way to export data from PHREEQC to excel file. I have been trying to use selected_output and User_punch, though the file gets created, data from the phreeqc output files doesnt get exported. I have a 1-D transport model. I will appreciate any help on this issue
Thanks
Ashmita
|
|
|
diederik
Moderator
Belgium
19 Posts |
Posted - 03/24/2006 : 08:37:40
|
Ashmita
The file created by phreeqc using the keyword selected_output is not an Excell-fill but an ASCII-text file (Tab delimited). I usually open the file (e.g., output.sel) in Excell by using the Text Import Wizard (Delimeted , Tab of space). This file can then be saved as an Excell file.
Diederik
|
 |
|
|
Ashmita
Junior Member
USA
3 Posts |
Posted - 03/28/2006 : 17:00:59
|
Thanks Diederik, I am able to create ASCII files and excel files from the output, however my problem is when I create the file, I can see headings etc but none of the numerical values (molality, si values etc) show up in the the file. I have a very simple 1D (15 cell) transport model, with chemical speciation. Is there a way I can post my input? Thanks again.
Ashmita
|
|
|
|
Ashmita
Junior Member
USA
3 Posts |
Posted - 03/28/2006 : 19:53:07
|
Hi Diederik,
I just figured out how to open the files. Thanks a lot for your help.
Ashmita
|
|
|
|
nounou
Junior Member
France
1 Posts |
Posted - 08/16/2007 : 12:37:31
|
Hello,
I have just started modeling with PHREEC and I have some difficulties is what some ones can help me. I want to model the leaching copper by organic matter by experiments of columns. and my question how of introducing the organic matter into PHREEQC?
Thank you for your help
Lobna
|
|
|
|
diederik
Moderator
Belgium
19 Posts |
Posted - 08/27/2007 : 16:08:55
|
Lobna,
there are different ways to introduce organic matter in phreeqc:
if you consider only immobile organic matter, you can introduce it as a cation exchange site or a surface site. You have also the possibility to introduce quite complex organic matter models such as the WHAM model (see chapter 7 in http://www.xs4all.nl/~appt/a&p/index.html).
if you are mainly interested in representing the organic matter as a simple aqueous ligand, you define it as a new master species in the SOLUTION_MASTER_SPECIES block (e.g., L) and some additions aqueous complexation reactions (in the SOLUTION_SPECIES block) with appropriate thermodynamic constants. An example of this is given by Lenhart and Honeyman (1999) (not in phreeqc format) for U(IV)-organic matter complexation (Geochemica et Cosmochimica Acta, 63:2891-2901).
You can define organic matter also as colloids with all kind of surface complexation reactions on it and making the colloids mobile and immobile. An example is given on the webpage of Appelo: http://www.xs4all.nl/~appt/exmpls/index.html colloid transport.
Note that not all of this is already available in the distributed version of HP1. In the near future, a updated HP1 will be distributed with the newest versions of hydrus and phreeqc, having most of these options in it.
diederik |
|
|
|
S_Jessen
Junior Member
Denmark
4 Posts |
Posted - 03/04/2010 : 08:12:13
|
Ashmita, in the phreeqc selected_output data block you can simply state that you want the output written to a *.xls file. Of couse this file contains just a tab-delimited text-file, but when you double-click on it, it will open in Excel.
About getting output written to the selected_output file... It is usually something with th "end"-statements in the phreeqc input file... try moving the selected output data a bit around in the file, e.g., to the beginning of the beginning input file.
And/or try mingling with the "end"'s. Sometimes it helps realizing that in PHREEQC "end" really means "run": I.e., when phreeqc reads an "end" it stops reading the input file for a moment, and executes what it read between this "end" and the previous "end".
Soren
|
Edited by - S_Jessen on 03/04/2010 09:31:22 |
|
|
| |
Topic |
|
PHREEQC
