How to convert network ‘Descriptor’ to ‘Page Title’ in a ProWORX 32 project

FAQ Pencarian

Goals and Symptoms

Convert the network Descriptor to the Page Title in a ProWORX 32 project.

Facts and Changes

ProWORX 32 version 2.xx

Causes and Fixes

ProWORX 32 lacks the ability to print the network descriptor on the same page as the Logic network
printout. It only allows the printing of the Page Title on the network printout. This may be a problem
for ProWORX NxT users that convert a project containing only network descriptors to a ProWORX 32
project.

The following procedure provides a workaround to convert the network Descriptor to the 'Page Title' so
that they can be printed with the network. (The resolution is very lengthy but, it should only take about 5
minutes o perform the conversion.)

Before the network Descriptor can be converted to the 'Page Title', the text from the nine separate
'Descriptor lines will need to be merged in a temporary worksheet.

Open the 'ProWORX 32' project.
Export the documentation to an Excel spreadsheet by right-clicking on the project name and

selecting 'Export\Documentation'.

Open the Excel spreadsheet that the documentation was exported to.
Click on the horizontal scroll arrow that can be found at the bottom left corner of the spreadsheet until

the 'Network' tab is displayed.

Click on the 'NETWORK' tab to open the sheet.

Scroll across the sheet to view the Descriptor' column.
Highlight the nine columns labeled Descriptor 1 through Descriptor 9.
Right click and select copy.

Create a new temporary blank worksheet.
Paste the Descriptor' columns to the new worksheet.
Insert a column between the Descriptor' columns (In my example, the extra columns are shown highlighted in grey)
Resize the new column to 2 character widths.
Click on the first cell of the new column, add a space using the spacebar and hit the 'Enter' key

to insert a carriage return. (The carriage return is used to separate the 'Short Comment' lines
when they are merged.)

Repeat the last step for the other new columns.
Click on the the letter for the column field (i.e., 'D' in my example below) to highlight it.
Type the keys 'Ctrl-D' to fill down the column.
Repeat the last two steps for the other extra columns.

(The steps in this page is used to create the formula for merging the network Descriptor' lines.)

Click on the cell in Row 1 Column A and type in '='.

Click on the cell in Row 1 Column C and type in '&'

Click on the cell in Row 1 Column D and type in '&'.

Click on the cell in Row 1 Column E and type in '&'.
Click on the cell in Row 1 Column F and type in '&'.
Click on the cell in Row 1 Column G and type in '&'.
Click on the cell in Row 1 Column H and type in '&'
Click on the cell in Row 1 Column I and type in '&'.
Click on the cell in Row 1 Column J and type in '&'.
Click on the cell in Row 1 Column K and type in '&'.
Click on the cell in Row 1 Column L and type in '&'.
Click on the cell in Row 1 Column M and type in '&'.
Click on the cell in Row 1 Column N and type in '&'.
Click on the cell in Row 1 Column O and type in '&'.
Click on the cell in Row 1 Column P and type in '&'.
Click on the cell in Row 1 Column Q and type in '&'.
Click on the cell in Row 1 Column R and type in '&'.
Click on the cell in Row 1 Column S and type in '&'.
Hit the Enter key.

(If steps are followed correctly, you should see something similar to the following. )

Note: If you make a mistake, clear the error using the backspace key, There is a Microsoft bug
where if the enter key is hit and the user tries to go back and edit hte cell, Excel will only
return the formula and not the merged text.

Click on column 'A' to highlight it.
Type the keys 'Ctrl-D' to fill down the column with the formula that was type in. (This is the step where all of the four 'Short Comment' lines are merged into one comment.)