2011

Create PLC I/O Drawings from Spreadsheets
Overview of the PLC spreadsheet/database format
The PLC information can be read from a 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 following data categories.
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 rack number of the module, used for the attribute as-
signed to the %%1 Prompt from the parametric data file.
Rack numbers (R)
The group number of the module, used for the attribute
assigned to the %%2 Prompt from the parametric data
file.
Group numbers (G)
The slot number of the module, used for the attribute as-
signed to the %%3 Prompt from the parametric data file.
Slot numbers s
The remote terminal panel ID number of the module, used
for the attribute assigned to the %%4 Prompt from the
parametric data file.
Remote terminal panel (RTP)
The wire number used for each I/O point.Wire numbers
The value assigned to the TAG attribute of the module.Module's tag
626 | Chapter 8 PLC