DASYLab

cancel
Showing results for 
Search instead for 
Did you mean: 

write module not rounding correctly

In a simple worksheet, the write module is set to save in the ASCII format with 6 decimal places. However, it is only saving to two decimal places, so instead of .0258, I get .03. Does anyone know how to rectify this situation?

 

Thanks

0 Kudos
Message 1 of 5
(6,781 Views)

Hi,

 

First, nnsure that all of your channels are configured for 6 decimals in the Write Data Ascii options.

 

Next, how are you reading the file? Excel? Maybe you need to configure the decimals in Excel? Check by looking at a cell, and observing the value in the entry field at the top of the Excel window.

 

Confirm by opening the file in Notepad or another text editor.

 

Even if the data didn't have any digits, it would fill with zero.

 

DASYLab - V 11.00.01
Worksheet name: (unknown)
Recording date     : 7/12/2010, 10:32:15
Block length       : 4
Delta              : 0.1 sec.
Number of channels : 2
Date    Time    Slider 0 [V]    Slider 1 [V]    
7/12/2010    10:32:15.0    0.000000    2.000000    
7/12/2010    10:32:15.1    0.025133    2.021726    
7/12/2010    10:32:15.2    0.050264    2.043372    
7/12/2010    10:32:15.3    0.075394    2.064938    
7/12/2010    10:32:15.4    0.100520    2.086421    
7/12/2010    10:32:15.5    0.125643    2.107823    
7/12/2010    10:32:15.6    0.150761    2.129142    
7/12/2010    10:32:15.7    0.175872    2.150376    

 

And this is what it looks like in Excel. Note that Excel interprets the time weirdly when it has decimal seconds, and it truncates any value where the decimals are 0.

 

DASYLab - V 11.00.01


Worksheet name: (unknown)

Recording date     : 7/12/2010, 10:32:15
Block length       : 4


Delta              : 0.1 sec.


Number of channels : 2

Date Time Slider 0 [V] Slider 1 [V]
7/12/2010 32:15.0 0 2
7/12/2010 32:15.1 0.025133 2.021726
7/12/2010 32:15.2 0.050264 2.043372
7/12/2010 32:15.3 0.075394 2.064938
7/12/2010 32:15.4 0.10052 2.086421
7/12/2010 32:15.5 0.125643 2.107823
7/12/2010 32:15.6 0.150761 2.129142

 

Measurement Computing (MCC) has free technical support. Visit www.mccdaq.com and click on the "Support" tab for all support options, including DASYLab.
Message 2 of 5
(6,780 Views)

Perfect, it was in fact excel not giving the appropriate number of decimal values. Thank you very much!

0 Kudos
Message 3 of 5
(6,776 Views)

I enjoy blaming Excel (or any other software!).

Measurement Computing (MCC) has free technical support. Visit www.mccdaq.com and click on the "Support" tab for all support options, including DASYLab.
0 Kudos
Message 4 of 5
(6,774 Views)

yes, the blame game is fun. Especially when it involves microsoft products

0 Kudos
Message 5 of 5
(6,768 Views)