CRIO RT position control for user file

[Sea1]

Hello Everyone

I've created a PID controlled hydraulic application and I controlled the position  by using Sine generator with the help of

CRIO 9074 and NI 9263.I worked the code on Realtime side. My freq is about between 0.67 to 1.5Hz. I used Fs=1000 s=1000 for

1hz. It works very well.  But now I have a new problem I have to solve. I have calculated the position of cylinder in 1ms time resulation (or

2ms-3ms).How can I apply the position of cylinder with the help of excel file or any other file format(If I learn

the way of control. I can get the position from excel) . How can I use the data below as a position signal for PID.

for example

(1HZ-10MM)

1ms  0,1mm

2ms  0,4mm

3ms  0,87mm

. . .

1000ms 10mm

[GerdW]

Hi Sea,

convert your Excel file to CSV format. Transfer the CSV file to your cRIO and load it there using ReadFromSpreadsheetFile...

[Sea1]

Hi GerdW,

Thank you for your idea. But I m looking for answer the position control with the help of PID controller. I did position control with sinus generator as my set point data. But now I want to use  user defined position data as set point data instead of sinus generator. 

[Esteban.R]

Hi Sea1

I am not sure that I understand your issue or question; if you have a list of values in Excel with the parameters that you want to use for you PID then as GerdW recommended you can create and read the file to find a reference or pointer to select the parameters you want to use.

But if the excel data has some sort of parameter instead of reading a file it might be easier to calculate the values.

Could you provide us with more information or a more detailed explanation of what you want to do?

Regards

Esteban R.