02-20-2016 11:08 PM
Hi everyone
I'm currently working on temperautre PID control and i have no DAQ or any hardware present. The aim is simply to the PID temperature control simulation and the problem I am facing is reading the process variable in the PID block. Since there is no DAQ available, I only collected some temperature data previously using NI DAQ 9213 and i want to use the data in excel as process variable in the PID block. I know there is a way of reading excel and spreadsheet files in labview using read measurement file or spreadsheet measurement vi. but i couldnt come up with right solution so far. I really have no clue and I seriously need your help.
Below is the attched vi. im working on!
02-22-2016 12:12 PM
First, I would check that you are able to read the data as you expect. Most experienced users on this forum will tell you to avoid the Express VIs (the big blue boxes) and dynamic data (such as the "signals" output of Read from Measurement File). If your data is in fact a text file (.csv), use "Read Delimited Spreadsheet" instead. Connect the All Rows output from that function to a waveform graph; do you see your data displayed as you expect?
Once you know you're reading the data properly, you can feed it to the PID. You will want to put the PID in a loop, executing once for each row of data. You'll also want to wire the "dt" input of the PID for the actual time between measurements, since you'll be able to run it much faster than real time with data from a file.
Also, a note about terminology: the question in your post title is basically meaningless. You already have the process variable data - it's in your file! So no need to measure it, you've already done that, and no need for the PID. I'm assuming you actually want to measure the PID output.