The sample data file contains the recorded anion and cation concentrations in mg/l (or ppm) in columns B, C, D, E, I, J, K, and L. These columns and the ID in column A can be changed to any data desired. In addition, the values in the pH column can be entered by the user.
The Excel file has some calculations that are used for the ternary diagrams and the rectangular portions between the triangles. The input values are normalized in columns F, G, and H for the cations and in columns M, N, and O for the anions. The values are normalized again in columns P and Q for display in the rectangle between the triangles. In addition, the TDS is calculated by summing all of the mg/l columns. If the number of data points entered is greater than the existing rows, copy the equations for columns F, G, H, M, N, O, P and Q for all new data.
Once the data is input, open the GRF file in Grapher. The graph is automatically populated with the data.
If you want to see the extended Durov plot, with the TDS and pH, check the box in the Object Manager next to Extended Durov and those additional fields will display.
Updated September 29, 2016