rstelektronik Posted June 17, 2023 Share Posted June 17, 2023 The values we read in the Daq factory are values with commas. But when we save it to excel in logging, it rounds the values to integers, for example 43.65 -->44 as 56.10-->56. where does this problem come from and how can i fix it Quote Link to comment Share on other sites More sharing options...
AzeoTech Posted June 19, 2023 Share Posted June 19, 2023 DAQFactory doesn't write directly to Excel, it writes to CSV files which you can open in Notepad and view. Open it in Notepad and look and see if the numbers are rounded there. If they are rounded, then the issue is the sig figs you have specified in the logging set. Sig figs is NOT the same as what DAQFactory calls precision. Precision is the number of digits after the decimal point. Sig figs is significant figures, a scientific standard. So 145242.6 to 4 significant figures is 145200. If they are not rounded in the file, then the issue is the formatting that Excel is doing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.