Support Forums
Rounding with Polynomial

We are using the DT85 to track temperature data by the second with both k-type TC's and RTD's. We are converting the C degree to F with Polynomial 1. What we are finding when we export our data to CSV is that the temperatures have 6 decimal places. Is there a way to round these up/down before exporting?

We are using the DT85 to track temperature data by the second with both k-type TC's and RTD's. We are converting the C degree to F with Polynomial 1. What we are finding when we export our data to CSV is that the temperatures have 6 decimal places. Is there a way to round these up/down before exporting?

Hi MorriltonPacking,

The database will record the data in a full accuracy of 18 bit. If you wish to cut the data into specific number of digit after decimal point you will need to use modulo operation (remainder after division).

Example:
1CV=25.435466

If you with to have 2 decimal digit then you need to grab 0.005466 as a substrahend. 2CV=1CV%0.01

Then 3CV=1CV-2CV to get the number with 2 decimal digits.

best regards,
dataTaker Expert

Hi MorriltonPacking, The database will record the data in a full accuracy of 18 bit. If you wish to cut the data into specific number of digit after decimal point you will need to use modulo operation (remainder after division). Example: 1CV=25.435466 If you with to have 2 decimal digit then you need to grab 0.005466 as a substrahend. 2CV=1CV%0.01 Then 3CV=1CV-2CV to get the number with 2 decimal digits. best regards, dataTaker Expert

Thank you for figuring out how it can be done, but can you let me know where to enter the modulo operation and how it would look? Thank you for your help and please excuse my ignorance in this area.

Thank you for figuring out how it can be done, but can you let me know where to enter the modulo operation and how it would look? Thank you for your help and please excuse my ignorance in this area.

Hi MorriltonPacking,

If you are using dEX 2.0, you can check the following screenshot.

I created a temperature channel (thermocouple) but disable logging as I do not want this data:
625e99f6ab06c

Then added a calculation channel: Temperature - Temperature%0.01
625e9a54e57d1

The component for modulo division will depend on the number of digit, if you wish to have 2 decimal digits then use 0.01.

Best regards,
dataTaker Expert

Hi MorriltonPacking, If you are using dEX 2.0, you can check the following screenshot. I created a temperature channel (thermocouple) but disable logging as I do not want this data: ![625e99f6ab06c](serve/attachment&path=625e99f6ab06c) Then added a calculation channel: Temperature - Temperature%0.01 ![625e9a54e57d1](serve/attachment&path=625e9a54e57d1) The component for modulo division will depend on the number of digit, if you wish to have 2 decimal digits then use 0.01. Best regards, dataTaker Expert
47
3
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft