You will be editing the UserConvTables.mdb Access database.
1. Locate this file and open it in Access
(it will be in the EasyCal Data folder, by default, this is :- C:\EC6\Data)
2. Open the ConvertHead table.
Each conversion table corresponds to one row of this table. Add the fields as follows:
ConvFuncCode
Unique Code (6 letters max) – e.g. “THERMJ”
ConvFuncDesc
Description that will appear in conversion table pull-down box when entering a test. Keep it to under 20 letters so they all fit on the screen.
XAxisUnits
The units that the equipment works in, e.g. ‘C, ‘F or K for a thermocouple. Note if you enter this as ‘C* then EasyCal will automatically provide the user with the choice of ‘C, ‘F or K (it will do the conversions for you).
YAxisUnits
The units that the calibrator will work in, e.g. mV, kR, mH, etc.
CalFunction
The function that must be selected when entering the test to see this choice, e.g. DCV (DC Volts) for a thermocouple. Options are: DCV, ACV, DCI, ACI, RESISTANCE, CAPACITANCE, FREQUENCY
ScaleFactorDecPlaces
The number of decimal places that the Conversion Rate is shown to on the test entry screen.
YAxisDecPlaces
The number of decimal places that the Required Value is shown to on the test entry screen.
3. Open the ConvertData table.
Each point on the conversion “curve” has a row in this table. Enter the fields as follows:
ConvFuncCode
This code must match the ConvFuncCode in the ConvertHead table. All points on the curve that correspond to the same function will have the same code here.
SeqNum
The sequence number of the point along the curve. This must start at 1 and go up in steps of 1 with no gaps. Each conversion curve stored in this table will have their own sequence.
XAxisValue
The point’s X-axis value, i.e. the calibrator’s value in mV (or whatever is selected)
YAxisValue
The point’s Y-axis value, i.e. the equipment’s value in ‘C (or whatever is selected)
Example
Here is an example showing the entries for two thermocouple conversion tables:
ConvertHead:
| ConvFuncCode | ConvFuncDesc | XAxis Units | YAxis Units | Cal Function | ScaleFactor DecPlaces | YAxis DecPlaces |
| THERMJ | Thermocouple Type J | mV | ‘C* | DCV | 3 | 3 |
| THERMK | Thermocouple Type K | mV | ‘C* | DCV | 3 | 3 |
ConvertData:
| Conv FuncCode | SeqNum | XAxisValue | YAxisValue |
| THERMJ | 1 | -210 | -8.095 |
| THERMJ | 2 | -209 | -8.076 |
| : | : | : | : |
| THERMJ | 1411 | 1200 | 69.553 |
| THERMK | 1 | -270 | -6.458 |
| THERMK | 2 | -269 | -6.457 |
| : | : | : | : |
| THERMK | 1643 | 1372 | 54.886 |
Notes on screen dump displayed above:
“RequiredValue” is shown to 3 decimal places because field YAxisDecPlaces is set to 3. The RequiredValue units are “mV” above since this is the entry in the XAxisUnits field. “Conversion Rate” is shown to 3 decimal places because field ScaleFactorDecPlaces is set to 3. The entries shown in the Conversion Table pull-down list are taken from the fields ConvFuncDesc. The YAxisUnits fields are suffixed to it, e.g. “‘C” above.