How to use the Pg2 Editor through Excel 97

Part 1 Get PG2EQEDT.XLS
1) Unzip PG2EQEDT.ZIP

Part 2 Load PG2EQEDT.XLS
2) Start Excel 97
3) Click on File or use Alt F
4) Click on Open
5) Open PG2EQEDT.XLS

Part 3 Create Equipment List Reports
6) Set Options on Menu Sheet
These options are turned off and on by clicking the box next to them.
 a) Turn off Enter Sheet Name (No Check Mark in Box)
 b) Turn off Include not Used (No Check Mark in Box)
 c) Turn off Include Icons and Sounds (No Check Mark in Box)

7) Click on the Equipment List Report Button

8) If you want to select a german(deu) or french(fra) equipment file.
Change the file type to the proper suffix
a) To change suffix - select files of type down arrow
b) Select the suffix

9) Select the equipment file.

10) If another file in the same directory exists with the same file name with a suffix of .txt.
    It will be selected as the equipment name file.
    If not, you will need to select the correct equipment name file.
11) A window will pop up asking you to confirm the files selected.  Click OK

12) The spreadsheet will run showing the percentage complete.

Part 4 Printing a Report
13) First you must of defined your printer to your system
14) Select the sheet you wish to print
15) Select the file button or ALT F Again
16) Select Print (If this option isn't available then the printer has been setup for your system)
17) On the Print Window verify the correct printer is selected
18) Verify Active sheet is selected
19) Select Print preview
20) Select SETUP if you wish to change the size of print
21) Select PRINT and it should work

Part 5 Changing Order of Equipment
22) Select close or print to return to the sheet with the equipment report
23) Select the sheet you want change the order
24) Select DATA on the Excel 97 or ALT D
25) Select SORT
26) Make sure My List has Header Rows is checked
27) Select which columns you wish to sort by.

Let me know if you need help with the other options.



Part 5 Edit an Equipment File
22) Go To Menu Sheet
23) Select






 c) Turn on


2) Open PG2EQEDT.XLS


