With the release of Service Pack 1 of DriveWorks 6, some Special Variables were added to enhance the creation of projects. The variable DWSpecificationID is automatically incremented from an initial value of 1 whenever a specification of a given project is created. This can be used to select the next available part number from a table or an Excel Spreadsheet.

1. Create an Excel lookup table with a column representing the DWSpecificationID and another representing the part numbers to be looked up.

2. Create a variable in DriveWorks named PartNumberCounter and make the value =DWSpecificationID.

3. Add the Excel spreadsheet to DriveWorks as a table.




4. Create a variable, PartNumber, to lookup the next part number based on the table and the counter variable.




5. The PartNumber variable will now update after each specification.



7. And again…..