Spreadsheet to PLC I/O Utility

[JAXXCAD]

Long time ACAD/ACADE user (+22yrs), new to forums.

Having little to no PLC programming experience, I am looking to use the Spreadsheet to PLC I/O Utility to creaste a couple of modules not available in the Rockwell library or update.  My spreadsheet lists the module I/O addresses and descriptions but I am not familiar with the proper spreadsheet format to enable it to be used.

Anyone have or know the proper spreadsheet setup?

[dougmcalexander]

The Spreadsheet to PLC I/O utility is used to create entire drawings that include PLC modules, ladders/wiring, and even discrete devices that connect to the PLC I/O. The code field defines which module to use. It sounds like you need to first use the PLC Database File Editor to add the new module to the PLC database, so it will be available for the Spreadsheet to PLC I/O utility.

[JAXXCAD]

This is understood.  Looking for proper spreadsheet format.  Spreadsheet was not created from RSLogix, created by EE to give I/O point descriptions.

Is there a specific format that should be setup within the spreadsheet?  (see attached)

[jalger · Accepted solution]

Hi JaxxCAD,

There sure is a format! (you can export an empty one and use that for your I/O Charts)

You can find the sample DEMOPLC.xls in:

C:\Users\<User Name>\AppData\Roaming\Autodesk\AutoCAD Electrical 2015\R20.0\enu\Support\User

(I put a copy up to save you from looking 🙂 )

I Don't Remember if Break works in the address field of not... (Spacer works for leaving Blank spaces) guess its time to run a quick test.

I hope this helps,

Regards,

James

[dougmcalexander]

James already gave you the best solution. Autodesk supplies you a sample to use as a guide.

[pabeyta]

I am struggling. I downloaded the file you shared. I went to the PLC IO utility and tried to import this but it didnt do anything. Can you please help? I have been reassigned to help with this project and i have never done any of this before but can pick up anything pretty quick. I ultimately need to load our memory maps and make them auto-populate our autocad drawings and then do the programming basics. Help please. 

[dougmcalexander]

I have attached the sample file from Autodesk.  Use the .xlx file as a guide.  In the XLS file you type in module number, PLC addressing, address descriptions, and up to 9 discrete components.  The spreadsheet has cells for up to 6 but you can go up to 9.  The cells in red are for you to enter the block name of the symbol you wish to insert. 

You can save you import preferences to a .wdi file. 

The HELP system in the software has a tutorial for using this utility.