Extracting Bending Data from Bendable Pipes and Tubes

atarget.gif (1372 bytes) This task shows you how to extract bending data from Bendable Pipes and Tubes and transfer it into a Microsoft Excel worksheet. Bending data can be fed into Bending machines to precisely create bends in bendable tubes and pipes.
ainfo.gif (980 bytes)
  • The standard macro supplied with this product displays bending data  in a sample format. However, a user with some Microsoft VBScript experience can change the script supplied to change the format.
  • The sample script assumes that the bendable objects are placed on a run under a distribution system or a logical line.
  • For more information on placing parts, see Placing a Part.
ascenari.gif (1364 bytes) 1. Using Windows Explorer, locate the intel_a\code\command subdirectory.
2. Copy the files PslTubingExtract.CATScript and PslTubingExtractTemplate.xls to C:\temp (with read-write access). Select the two files and click the right mouse button. Click Properties in the drop-down menu that displays. The Properties dialog box will display. Uncheck the Read-Only option.

3. In the specifications tree, select  the line (piping or tubing) under which the run containing the bendable objects has been placed.
4. Click Tools - Macro - Macros. The Macro dialog box will display. Select External File from the drop down list, select PslTubingExtract.CATScript and click Select. The Select External File dialog box will display. Select PslTubingExtract.CATScript and click Open. This will again display the Macro dialog box. Select PslTubingExtract.CATScript and click Run. Data will be extracted from the bendable objects and displayed in an Excel worksheet, part of which is displayed below. (The application will create the table, but you must have Excel installed!)

aendtask.gif (1477 bytes)