Difference between revisions of "Importing data into PDS"

From Chemical Engineering @ UP wiki
Jump to: navigation, search
(Created page with '-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 ...')
 
Line 3: Line 3:
 
-Browse to your data file and click Open.
 
-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 an be changed in PDS after the import. Under the Date heading the date is entered in the format
+
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.

Revision as of 14:00, 1 November 2009

-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.