Difference between revisions of "Importing data into PDS"
(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 | + | 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.
