Spreadsheet to PLC I/O Utility Setup Dialog Box

Defines how to set up the PLC drawings, including the number and type of ladders, number and spacing of rungs, style, scale, and placement of modules, and placement and spacing for inline devices.

Find

 Command entry:  AESS2PLC

Select the spreadsheet output file and click Open. In the Spreadsheet to PLC I/O Utility dialog box, click Setup.

Note: New default values can be programmed into the source file. The program source file name is "wdio.lsp." Open the file with any ASCII text editor and carefully edit the values near the top of the file.

Ladder

Origin	Specifies the insertion point for first (or only) ladder on the drawing. Corresponds to the upper left-hand corner of the ladder.
Orientation	Specifies to create a vertical bus ladder (with horizontal wires) or horizontal bus ladder (with vertical wires).
Reference numbers	Specifies the default referencing system: Numbers Only Numbers Ruling User Blocks X-Y Grid: All referencing is tied to an X-Y grid system of numbers and letters along the left-hand side and top of the drawing. Set the vertical and horizontal index numbers and letters, spacing, and origin in the X-Y grid setup dialog box. Tip: Use negative spacing values for horizontal or vertical to change the origin of the XY grid system to be other than the upper left-hand corner of the drawing. X Zones: Like X-Y Grid, but there is not a Y-axis. Set your horizontal labels, spacing, and origin of the drawing on the X Zones setup dialog box. Tip: Use a negative zone spacing value if you want the zone reference origin to be at the right side of the drawing.
Width	Specifies the width of each ladder (offset distance between the ladder's two bus wires) from left to right rail.
Distance between	Specifies the offset distance from the insertion point of one ladder to the insertion point of the next ladder.
Ladders per drawing	Specifies the number of ladders to insert. Vertical ladders insert left to right. Horizontal ladders insert top to bottom.
Rungs per ladder	Specifies the quantity of line reference / wire rungs per ladder. This value multiplied by the "Spacing - ladder rung to rung" value determines the length of the inserted ladders.
Rung spacing	Specifies the distance from one rung to the next rung on a ladder.
Rung count skip for I/O start	Specifies the quantity of rungs to skip before inserting a PLC module (0=no skip)
Suppression	Indicates whether to include/exclude bus rails and rungs.
Signal arrow style	Specifies the default wire signal arrow style. Select from the four predefined styles or a user-defined style. You can override the default style setting at insertion time.

Module

PLC graphical style	Specifies the default PLC module style. Select from the five predefined styles or a user-defined style.
Input offset from neutral	Specifies the Input module insertion offset distance (vertical ladder orientation - measured in +X direction from right-hand vertical bus; horizontal ladder orientation - measured in +Y direction from lower horizontal bus).
Output offset from hot bus	Specifies the Output module insertion offset distance (vertical ladder orientation - measured in -X direction from the left-hand vertical bus; horizontal ladder orientation - measured in the -Y direction from the upper horizontal bus). Note: If module type cannot be determined or if it is combination Input and Output, then the module is inserted down the middle of the ladder.
Maximum I/O per ladder	Specifies the maximum number of module I/O points to insert into each ladder without breaking the module and continuing it in the next ladder.
I/O point spacing	Specifies the insertion point offset distance between one in-line device and the next.
Scale	Specifies the PLC module scale override value (default = 1.0). Applies a scale factor to the PLC module insertion except for the "Spacing - I/O point to I/O point" value defined previously. If Apply this scale to module outline only is selected, then this scaling factor is applied only to the outline of the module.

In Line Devices

First input device from hot bus	Specifies the starting offset distance from the left-hand or upper bus for the first (or only) in-line device defined for each Input module I/O point.
First output device from neutral bus	Specifies the starting offset distance from the right-hand or lower bus for the first (or only) in-line device defined for each Output module I/O point.
Spacing between multiple devices	Specifies the insertion point offset distance between one in-line device and the next.

Spreadsheet/Table Columns

Displays the Spreadsheet to PLC I/O Drawing Generator dialog box for reviewing and mapping spreadsheet columns to attributes on the PLC module symbol.

Drawing Template

You can force the tool to use a specific template for new drawings. Enter the template drawing file name with the full path or click Browse to search for an existing template (it looks in the AutoCAD template folder where all of the user drawing templates are saved). For the current default template, leave the value blank. If you do not want to use a template drawing, enter a single dot in the edit box.

Note: Make sure that your template does not have any existing ladders.

Save

Saves the spreadsheet information in a .wdi file to reuse. Once you save the new .wdi file, the Spreadsheet to PLC I/O Utility dialog box redisplays and the new .wdi file name displays in the Settings edit box.