Autodesk 22505-051400-9000 - AutoCAD Electrical 2008, Руководство пользователя

Страница: 265 / 1304

Overview of the PLC spreadsheet/database format
The PLC information can be read from an Microsoft Excel spreadsheet, Access
database table, or a comma-delimited file. AutoCAD Electrical expects to find
certain columns containing the information needed to generate the drawings.
The columns can be in any order defined by your settings. All columns are
optional except the Module part number (Code) column. Three example PLC
data files are found in the User folder: DEMOPLC.XLS, DEMOPLC.CSV and
DEMOPLC_IEC.XLS. A settings file is also provided to run the Spreadsheet to
PLC I/O Utility: DEMOPLC_IEC.WDI.
Use the Spreadsheet to PLC I/O Utility tool to assign spreadsheet or table
column numbers to the data categories below.
Module data
This can be the code for a parametrically generated module,
or for a full module's library symbol. It can even be a non-
PLC symbol such as a variable speed drive. Module part numbers (Code)
The I/O address for each I/O point. This value gets annot-
ated to the "TAGA_" attribute. Address (ADDR)
The module's rack number, used for the attribute assigned
to the %%1 Prompt from the parametric data file. Rack numbers (R)
The module's group number, used for the attribute assigned
to the %%2 Prompt from the parametric data file. Group numbers (G)
The module's slot number, used for the attribute assigned
to the %%3 Prompt from the parametric data file. Slot numbers (S)
The module's remote terminal panel ID number, used for
the attribute assigned to the %%4 Prompt from the para-
metric data file. Remote terminal panel (RTP)
The wire number used for each I/O point. Wire numbers
Create PLC I/O Drawings from Spreadsheets | 253