Excel spreadsheet as input to PID Setpoint Profile VI

[Perillo_UTK]

Sure!

This is an Excel ".csv" file (comma delimited) with 2 columns:

Time (seconds) and randomly generated setpoints (mmH2O in our case ).

[Perillo_UTK]

bmann2000,

No, I have not. But will try.

Thanks for your reply!

[MikeS81]

Hi Perillo_U...,

the attached example should work for you.

If not, can you upload you vi?

Mike

[Perillo_UTK]

Hello Mike,

No, I am having the same problem and attached the VI for you.

Thanks Mike!

[Perillo_UTK]

Hello bmann2000,

The problem really isn't reading the data, but reading in an appropriate fashion to make it match the structure needed to feed the PID Setpint Profile SubVI.

Thanks for your reply!

[Perillo_UTK]

To help clarify, I am posting a copy of the PID Setpoint Profile VI.  Maybe this will help some.

Thanks!

[Justin_P]

Hi Perillo,

I took a look at your VI and it looks like you are inputting the correct data type.  What type of error are you getting?

Justin P

[Perillo_UTK]

Hello Justin, thanks for your interest.

Well,  apparently it reads all data from spreadsheet at once instead of sequentially, so a few seconds later I got either a "zero" value or "NaN".  This VI is actually a SubVI used in a control VI.

[Justin_P]

Does the second Setpoint Profile VI with the constant wired into it read the values sequentially? 

Justin

[Perillo_UTK]

The second VI is just a copy from the original included in LabView installation package (Real time package), which not everyone has access to, but when I try to substitute the constant with the data from the spreadsheets it gets messed up.