Importing data into PDS

From Chemical Engineering @ UP wiki
Revision as of 14:00, 1 November 2009 by 137.215.116.83 (Talk)

Jump to: navigation, search
  • In PDS create a new file (File > New > Model Dev. File > OK).
  • From the Data Operations pull-down menu select Import From Excell.
  • Browse to your data file and click Open.

The Excell file has to have a specific format. The first and second column's headings must be "Date" and "Time" respectively. From the third column onwards variable names are used as column headings in the form VariableName/Var/CV. i.e. 12TT9001.PV/Var/CV, 12TIC9001.SP/Var/MV. The last argument of the variable name headings indicate if the variable is a controlled variable (CV), a manipulated variable (MV) or a disturbance variable (DV). Variable types can be changed in PDS after the import. Under the Date heading the date is entered in the format dd/mm/yyyy and under the Time heading the time is entered in the format hh:mm:ss. The data elements for the variables at the timestamps in the first two columns are entered under their respective headings.