-
Controlling the Machine is no longer being updated. Don't worry, though, you can still follow Nate Holt at his new blog, AutoCAD Electrical Etcetera. You'll find it at http://nateholt.wordpress.com. Or you can subscribe to his feed to get latest words of wisdom automatically: http://nateholt.wordpress.com/feed/. You also can continue to view the Controlling Machine archives for Nate's AutoCAD Electrical tips and tricks.
-
A couple SS->PLC I/O Tricks
July 26, 2006, 02:51 PM Nate HoltHere are a few tricks/tips that might be useful with the Spreadsheet --> PLC I/O generator utility.
1. Pin number assignments to terminal symbols. You can define the terminal symbol block name and the tag for the terminal but there's no obvious way to also define the terminal's pin number assignment. Try this... in the terminal's tag field, add a "colon" and then the pin number. The utility will see the colon as a delimiter in the field and insert what follows it into the terminal's TERM01 attribute. This gives you the pin number in your drawing. For example, let's say the terminal's tag name is to be TB1 and its pin number assignment to be "1A". Enter the colon delimiter and the "1A" suffix as shown here.
2. Pin number assignments to component symbols. Let's say you want to insert a pushbutton symbol but also want to annotate the pins as "21" and "22". There are no columns in the spreadsheet for pin numbers. But you can concatenate extra attribute assignments into any field of the in-line device using a ";" semicolon delimiter. In the example shown below, the normal LOC attribute is "FIELD" but we've forced two more attribute definitions into this one field. The component's TERM01 attribute is to be assigned a value of "21" and TERM02 a value of "22".
UPDATE: the attributes you manually add with the semicolon delimiters are not limited to pin number attributes.
Comments
-
August 11, 2006 11:55 AM Young_adsk
How to add the teminals' Catalog Data(such as Manufacturer, catalog, assmeble) by the spreadsheet?
-
August 17, 2006 03:43 AM Nate Holt
You can define MFG, CAT, and ASSYCODE values in the spreadsheet and merge to the in-line devices connected to the I/O points. There are two ways to do this. One way is to add MFG and CAT (and optionally ASSYCODE) columns in the spreadsheet for each set of in-line device columns. For example, there is a D1TAG, D1DESC, D1BLK, and D1LOC fields shown in the sample spreadsheet for the first device column. You can add D1CAT, D1MFG columns to your spreadsheet and then adjust the column order/number definition in the SS->PLC utility's "Settings" > "Spreadsheet/Table columns" subdialog. The other way to do this is to just add more attributes to an existing field in the spreadsheet. For example, in the one shown above you could have in the D2LOC column something like this: FIELD;TERM01=21;MFG=SIEMENS;CAT=12345
You must be logged in to post a comment.