Create PLC Drawings from a Spreadsheet

Prerequisites

Completion of the Using the Spreadsheet to PLC I/O Utility Lesson

Objective:  In this project you use the default demoplc.xls spreadsheet and hard-coded default settings to generate three PLC drawings.

Process:  Create PLC Drawings from a Spreadsheet

Instructions

1:  If the Project Manager is not displayed, on the Project tab, Project Tools panel, click Manager.

2:  If PLC_Modules_NFPA is the active project, skip to step 6. If it is open but not active, in the Project Manager, do the following:
â–  Right-click PLC_Modules_NFPA.
â–  Click Activate.
â–  Skip to step 6.

3:  In the Project Manager, click Open Project.

4:  Browse to where you installed the exercise files. Select PLC_Modules_NFPA.wdp. Click Open.

5:  From the Projects list, click the expansion node next to PLC_Modules_NFPA to expand the drawing list.

6:  On the Import/Export Data tab, Import panel, click PLC I/O Utility.

7:  In the Select PLC I/O Spreadsheet Output File dialog box, in the User directory, which opens by default, select demoplc.xls. Click Open.

8:  In the Spreadsheet to PLC I/O Utility dialog box, leave the Settings box blank. This enables you to use the hard-coded default settings that match the demoplc.xls file.

9:  Under Ladder Reference Numbering, do the following:
â–  For Start, type 900
â–  For Index, type 1
â–  Under Column to Column, click Next Sequential Number.
â–  Under Drawing to Drawing, click Next Sequential Number.

10:  Under Module Placement, do the following:
â–  Click Always Start at Top of Ladder.
â–  Clear Include Unused/Extra Connections.
â–  Select Allow Pre-Defined Breaks.
 

11:  Under Drawing File Creation, do the following:
â–  Clear Use Active Drawing.
â–  For Starting File Name, type PLC_Module_NFPA_12
â–  Click Free Run.
â–  For Sheet, type 12
â–  Select Add New Drawings to Active Project.
■ Click Start. 

12:  Look in the Project Manager and verify that the following three drawings have been generated and added to the project drawing list: PLC_Module_NFPA_12.dwg, PLC_Module_NFPA_13.dwg, and PLC_Module_NFPA_14.dwg. 
 

Â