2008

2 Click the arrow on the Insert PLC (Parametric) tool to access
the RSLogix 500 Export to Spreadsheet tool.
3 Click the RSLogix 500 Export to Spreadsheet tool.
4 Select an .EAS or .CSV file and click Open.
5 In the RSLogix 500 Import dialog box, select whether the I/O
points should be displayed in 8, 16, or 32 point groupings.
6 Pick an I/O module for each set of I/O points. Enter it in the
edit box, select from the PLC dialog using Browse, or select
from the already used list once you have some modules selec-
ted.
7 Click OK to assign the module and move on to the next set of
points.
8 (Optional) To change a module assignment, select the module
assignment and click Change. In the RSLogix 500 Import
Change Module dialog box, change the selected module part
number by entering the new module name in the edit box,
selecting it from the PLC dialog using Browse, or selecting it
from the already used list once you have some modules selec-
ted. Click OK to assign the module and return to the Input
Module dialog box.
9 (Optional) Click Omit to skip a set of points, or click Future
to skip the points and add information so AutoCAD Electrical
will add a blank column when generating the drawing from
the spreadsheet.
10 Enter a name for the spreadsheet once a module has been as-
signed for each set of points. Click Save.
Use Microsoft Excel to modify your spreadsheet as needed.
11 Click Components ➤ Insert PLC Modules ➤ Spreadsheet to
PLC I/O Utility to create the PLC drawing. (page 257)
RSLogix 500 import
268 | Chapter 5 PLC