converting 1D waveform to String

[pjkunwor1@gmail.com]

Hello,

I am using PXI-1036 with PXI-4472 to acquire acceleration. I am using Daqmx to acquire my analog acceleration signals. 

I am trying to write time stamped values in a excel sheet.  Please look at the picture attached below for more details. 

Problem - I have a broken wire while connecting my analog 1D waveform to a build array VI. 

How can I fix this problem?? Should I use convert to/from dynamic data?? If yes, then how?

Best,

Puspa kunwor

 

[crossrulz]

Use the Export Waveforms To Spreadsheet File.VI.  It will do all of the work for you.

[pjkunwor1@gmail.com]

Hello crossrulz,

Thank you for your reply. I tried using Export Waveforms To Spreadsheet File.VI but I don’t know how to add time stamped to my acquire data. 

I found following example vi and added to my code and I am able to acquire both time and waveform data in a sub string. Picture below. 

Is there a way to write this substring (time, waveform data) into two columns on excel with headers?? 

Thank you,

Puspa Kunwor 

 

[crossrulz]

---

pjkunwor1@gmail.com wrote:

Thank you for your reply. I tried using Export Waveforms To Spreadsheet File.VI but I don’t know how to add time stamped to my acquire data.

---

That VI puts the timestamps as the first column in the file.

[pjkunwor1@gmail.com]

Hello crossrulz,

Thank you for your help. I am able to acquire my time stamped accelerometer data using Export waveform VI. 

But I have encountered another problem. It am not acquiring correct measurement. I have setup all my inputs (sensitivity, units, excitation current etc.) correct from datasheet of my accel but the output is completely different and inaccurate. 

I can see the vibration as high as 50g in my graph when I exert force on my accel but data written by Daqmx write does not reflect that. 

Do I need to do any signal conditioning? 

 Best,

Pjkunwor1