Overview and first steps
The Compare feature cross-references existing components (parts and pieces) in the drawing against the worksheet that was created from that drawing. This allows you to ensure that the drawing and worksheet are alike. Compare indicates if there are any discrepancies between these two pieces of information. The resulting compare will produce 3 new worksheets. It can also create a report that can be printed or saved as a document.
In this article, you will learn how to compare the drawing with the corresponding worksheet. Below is a listing of worksheets created, as well as an illustration of the comparison process.
-
Parts found only in Drawing (foundonlyindrawing.sp4)
-
Parts found only in Worksheet (foundonlyinworksheet.sp4)
-
Parts found both in Drawing and Worksheet (foundinbothdrawingandworksheet.sp4)
Before you begin the Compare:
-
Open your existing drawing that contains Cap symbols.
-
Know the location of the worksheet file associated with that drawing.
Note: The worksheet file being compared must be closed while using Compare.
For a step-by-step exercise, see Example exercise.
Example exercise
-
From the Office menu, select Worksheet, Compare.
The Compare Drawing with Worksheet dialog box appears. -
Under Worksheet, select the a worksheet file by clicking
if you want to change the current file.
-
Under Outputs, leave the boxes checked so that the worksheet files FoundOnlyInDrawing, FoundOnlyInWorksheet and FoundInBothDrawingAndWorksheet are created.
To change the location and/or name of each worksheet, click the appropriate -
Check Print Report if you want to print a summary sheet of the three output worksheets.
-
Under Comparison Criteria, check the boxes for Mfg Code, Catalog Code, Product Number, Product Description, Option Number and Option Description.
-
Click OK.
Once the Compare is done, the next step is to review the 3 output files that were created during the Compare.
Open any of the output files and review the information. You will be able to conclude if anything in the drawing is not found in the worksheet, if there is any product in the worksheet that is not in the drawing and lastly, which parts are found in both the drawing and the worksheet.
You could then revise either the drawing or the worksheet as necessary.