Difference between revisions of "Importing data into PDS"
Line 1: | Line 1: | ||
*In PDS create a new file (File > New > Model Dev. File > OK). | *In PDS create a new file (File > New > Model Dev. File > OK). | ||
− | *From the Data Operations pull-down menu select Import From | + | *From the Data Operations pull-down menu select Import From Excel. |
*Browse to your data file and click Open. | *Browse to your data file and click Open. | ||
− | The | + | The Excel 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:02, 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 Excel.
- Browse to your data file and click Open.
The Excel 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.