Plotting .tsv File

[davidblevy]

I'm new to plotting a .tsv file to USER_GRAPH and it seems pretty straightforward, but I can't seem to get the data to plot on the graph. It is located in my c: root directory as specified in the input file, and no error messages appear indicating that the file can't be found. I'm guessing there may be an issue with how the .tsv file is set up? Any information would be appreciated. Below is the .tsv file and the input file. Thank you, David.

TSV File (it is tab delimited but didn't copy in that way)

pH   U (mg/L)
color   Blue
y_axis   1
symbol   Square
symbol_size   2
line_width   2
8.015   0.237
7.5   0.237
7.03   0.233
6.5   0.216
6.01   0.153
5.475   0.100
4.995   0.113
4.505   0.152
4.02 0.190
3.49   0.219
3   0.226
2.02   0.231


PHREEQC input file

PHASES
Fix_H+
H+ = H+
log_k 0

SOLUTION 1 Well H24 11-15-21
-units   mg/L
Alkalinity   383 as Ca0.5(CO3)0.5
pH 7.58
Cl   194
F   0.36
S(6)   935.75
Ca   255
Mg   68.2
K   7.9
Na   301
U   0.234
END

SURFACE 1
Hfo_w 0.8e-3 600 0.04
Hfo_s 0.05e-3

END

SELECTED_OUTPUT
-file c:/output/Zeolite_Uranium_Sorption_Simulation_No_Cu_2021.dat
-reset   false

PRINT
-reset   false

USER_PUNCH
-headings pH TOTMOLE_U SURF %U_adsorbed
-start
10 PUNCH -la("H+")
20 PUNCH TOTMOLE("U")
30 PUNCH SURF("U","Hfo")
40 PUNCH (SURF("U","Hfo")/(TOTMOLE("U")+ SURF("U","Hfo")))*100

USER_GRAPH 1
chart_title         "Dissolved U (mg/L)"
-headings         U
-axis_titles      "pH" "U (mg/L)"
-axis_scale         x_axis 2 9
-axis_scale         y_axis 0 auto
-initial_solutions   false
-plot_tsv_file   c:/Zeolite_Diss_U.tsv

10 x = -LA("H+")
20 PLOT_XY x, TOT("U")*238*1000, symbol = Circle, Color = lime, symbol_size = 2, line_width = 2, y-axis = 1


EQUILIBRIUM_PHASES 1
Fix_H+ -7.8 H2SO4

EQUILIBRIUM_PHASES 2
Fix_H+ -7.6 H2SO4

EQUILIBRIUM_PHASES 3
Fix_H+ -7.4 H2SO4

EQUILIBRIUM_PHASES 4
Fix_H+ -7.2 H2SO4

EQUILIBRIUM_PHASES 5
Fix_H+ -7.0 H2SO4

EQUILIBRIUM_PHASES 6
Fix_H+ -6.8 H2SO4

EQUILIBRIUM_PHASES 7
Fix_H+ -6.6 H2SO4

EQUILIBRIUM_PHASES 8
Fix_H+ -6.4 H2SO4

EQUILIBRIUM_PHASES 9
Fix_H+ -6.2 H2SO4

EQUILIBRIUM_PHASES 10
Fix_H+ -6.0 H2SO4

EQUILIBRIUM_PHASES 11
Fix_H+ -5.8 H2SO4

EQUILIBRIUM_PHASES 12
Fix_H+ -5.6 H2SO4

EQUILIBRIUM_PHASES 13
Fix_H+ -5.4 H2SO4

EQUILIBRIUM_PHASES 14
Fix_H+ -5.2 H2SO4

EQUILIBRIUM_PHASES 15
Fix_H+ -5.0 H2SO4

EQUILIBRIUM_PHASES 16
Fix_H+ -4.8 H2SO4

EQUILIBRIUM_PHASES 17
Fix_H+ -4.6 H2SO4

EQUILIBRIUM_PHASES 18
Fix_H+ -4.4 H2SO4

EQUILIBRIUM_PHASES 19
Fix_H+ -4.2 H2SO4

EQUILIBRIUM_PHASES 20
Fix_H+ -4.0 H2SO4

EQUILIBRIUM_PHASES 21
Fix_H+ -3.8 H2SO4

EQUILIBRIUM_PHASES 22
Fix_H+ -3.6 H2SO4

EQUILIBRIUM_PHASES 23
Fix_H+ -3.4 H2SO4

EQUILIBRIUM_PHASES 24
Fix_H+ -3.2 H2SO4

EQUILIBRIUM_PHASES 25
Fix_H+ -3.0 H2SO4

EQUILIBRIUM_PHASES 26
Fix_H+ -2.8 H2SO4

EQUILIBRIUM_PHASES 27
Fix_H+ -2.6 H2SO4

EQUILIBRIUM_PHASES 28
Fix_H+ -2.4 H2SO4

EQUILIBRIUM_PHASES 29
Fix_H+ -2.2 H2SO4

EQUILIBRIUM_PHASES 30
Fix_H+ -2.0 H2SO4


USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 1
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 2
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 3
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 4
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 5
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 6
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 7
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 8
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 9
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 10
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 11
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 12
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 13
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 14
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 15
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 16
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 17
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 18
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 19
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 20
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 21
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 22
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 23
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 24
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 25
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 26
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 27
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 28
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 29
END

USE solution 1
USE surface 1
USE EQUILIBRIUM_PHASES 30
END

[dlparkhurst]

Worked for me. I put the tsv file in Excel and data->data tools->text to columns to add the tabs; I wrote the file as tab-delimited txt.

A user had a problem recently, where the file was encoded as little-endian, which caused the points not to be plotted. Notepad++ or other editors will tell you the encoding on the file on the bottom banner.

[davidblevy]

Thank you, I will try that!  David