Conversion Tables are used to record relationships between two variables. Conversion Tables in DataSight are a type of look up or interpolation table.

They can be used to hold data for:

• Stream/River stage discharge curves
• Water quality data. For example, plotting turbidity against discharge
• Stream rating tables
• Pump rating tables

Data can be entered manually point by point or by using simple cut/copy/paste functions from other electronic data sets. Once a Conversion Table has been created, it can be assigned to a specific Level 3 so that it can be compared with other data, or used in analysis.

Open Conversion Tables List

• Click Conversion Tables in the Analyse group on the DataSight Ribbon. The Conversion Tables list appears in the Main Panel, together with a Conversion Table grouped tab on the ribbon.

Create a Conversion Table

1. Select the Conversion Tables tab in the Main Panel.
2. Click New on the Quick Access Toolbar. A new Conversion Table form appears in the Main Panel. This form consists of a Table panel, a Values panel and a Conversion Table chart. Associated functionality can be found on the Conversion Table grouped tab on the ribbon.
3. Click on the Table Name text box and enter the table name.
4. Click in the X and Y Coordinate Label text boxes and type in the names of your two variables.
5. Enter dates for the Period of Applicability for the Conversion Table.
6. Assign the Conversion Table to a specific Level.
7. Click Comments to open the Comments window. Enter comments as required and click OK.
8. Select the Values Panel. Data can be entered either:

• Individually using the navigation buttons at the bottom of the data area where you select + to add a line and enter data, and - to remove a line of data.

Or,

• Directly from a spreadsheet in Excel or similar program. Highlight and copy your data in Excel. Return to the Conversion Table and in the Values panel right-click and select Paste.

                As data is entered it is graphed in the Conversion Table chart.

9. Click Transpose on the Conversion Table grouped tab to swap the position of the x and y axes.
10. Click Logarithmic on the Conversion Table grouped tab to change the chart scale to Logarithmic, which can be helpful when the data entered covers a large range of values.
11. Click Save in the Quick Access Toolbar. The Conversion Table is now saved and will appear in the Conversion Tables list.

Manage Conversion Tables

The Conversion Tables panel lists the names of all saved Conversion Tables, their assigned Level 3 (if applicable) and their period of applicability.

Modify and/or Copy a Conversion Table

1. Click Conversion Tables tab in the Main Panel.
2. Double click on the chosen conversion table row. The Conversion Table will open in a new threaded form in the Main Panel.
3. Modify the Conversion Table record as required. Use the Editing Navigation Bar at the bottom of the panel to do this.

• Select + to add a line and enter data.
• Click in a record to focus the cell and edit the line of data.
• Click ü to end the edit.
• Click û to cancel the edit if you make a mistake.
• Focus on a record, click outside the row then select - to remove a line of data.

4. You can also right click on the Conversion Table Values Panel and either Copy, Cut or Paste values into the table. Select All to highlight all the values, and then Copy to copy the entire table to clipboard.
5. Click Save in the Quick Access Toolbar. The Save As window appears.
6. Enter a new name for your modified table or click OK to overwrite the existing table.
7. The Conversion Table is now saved and will appear in the Conversion Table list.

Delete a Conversion Table

1. Click Conversion Tables tab in the Main Panel.
2. Click to check the Delete check box(es) against any Conversion Table that you wish to delete.
3. Click Save in the Quick Access Toolbar at any point to save changes and continue, otherwise when you Close the Conversion Tables panel you will be prompted to save your changes.