MS Excel for generating RSL5000 rungs

I'm looking for a way to export/edit/import a single rung via excel so that I can use the auto increment facililty to create more rungs for importing back into my 5000 program. I had a go but it all ended up in one cell. Is there a format option that will place the results vertically on the spreadsheet? I'm guessing that this is what I need but as usual, all answers welcome. Thanks.

I've done this using the concatenate function in excel. Break your code up in similar chunks, ie, column A might be SOR XIC, then column B an address, column C OTE, column D an address, and column E contains EOR.

It'll take a few AND and CONCATENATE functions to get everything into one big text string in one cell, then copy, double click the rung in RSLogix and paste. Voila.

Having everything in one cell is what you want, as long as you separate the rungs by using SOR and EOR (start of rung, end of rung).

If you copy the text string from a single rung in RSLogix you can paste that to a cell in Excel. From that point you need to use the DATA --> "text to columns" feature to break the text at the numerical points. From there you can use the auto increment feature.

You aren't done though, you need to then rebuild that text so you can paste it into RSLogix. So you need to "concatenate" those multiple columns together back to a single cell to copy and paste.

That works great, but what if you want to do multiple rungs?

Well, you need to concatenate again to include the next rung of logic, but don't forget to manually add the "SOR" (Start Of Rung) and "EOR" (End Of Rung) functions to create the break points between rungs.

It wall works rather nicely, however if you want to expand your abilities of using Excel to auto-generate your code start learning VBA and how to create .L5X files. Then you can import the file right into the code. If you are good you could include comments, complex rungs....

Thank you. I'll work on it.

That's brilliant! "EOR" turns out to be a ; and SOR seems to be three spaces but wow that's quick Loads of rungs in seconds. Thank you.

Take a look at this thread for an example. In that particular thread I used Logix500 because thats what the OP was using however the same technique works in Logix 5000

http://www.plctalk.net/qanda/showpost.php?p=361042&postcount=11