Complete guide: how to export your captured data to your own inspection sheet EXCEL file. I.e. configure your own Excel template.
Step 1: Open the EXCEL file that will be configured as the Template, and identify the start cell for later reference.
In this guide we are using the sample First Piece Approval Form EXCEL file from the below link.
https://www.guthcad.com/tutorials/qa-cad/SampleFirstPieceApprovalForm.xlsx
Start Cell: A8. Column A is Balloon No. Column B is Dimension. Column C is Upper Tolerance. Column D is Lower Tolerance in this example EXCEL file.
In this guide we are using the sample First Piece Approval Form EXCEL file from the below link.
Step 2: Go to QA > QA Settings > Attributes. Select the applicable Definition Table, and press the Configure EXCEL template button.
Step 3: The Manage Excel templates window opens. Press the New button.
Step 4: Select Copy from current EXCEL template and type the template name in New Table Field (typed ‘MY SAMPLE’ in this below example). Then press the OK button.
Step 5: Click the ‘…’ button next to the Excel File Name input Field (the red rectangle in the below image)
Step 6: Select your EXCEL template file (‘SampleFirstPieceApprovalForm.xlsx’ was selected in the below example image). Press the Open button.
Step 7: Press the Configure Columns button in the Manage Excel templates window.
Step 8:
The Configure sheet window opens. In this window, you can set which data is output to which column in an EXCEL template.
For example: you can select or change that QA-CAD outputs dimension to Column B.
Type A in the Start Column and type 8 in the Start Row. Then change Column B to select Dimension in the dropdown menu.
(Previously we checked the EXCEL template output cell requirement at page8.
Start Cell is A8. Column A is Balloon No. Column B is Dimension. Column C is Upper Tolerance. Column D is Lower Tolerance).
Type A in the Start Column and type 8 in the Start Row. Then change Column B to select Dimension in the dropdown menu.
(Previously we checked the EXCEL template output cell requirement at page8.
Start Cell is A8. Column A is Balloon No. Column B is Dimension. Column C is Upper Tolerance. Column D is Lower Tolerance). Step 9:
Also change Column C to Upper Tolerance.
By the way, as you see from the above image, you can change or edit output attributes data. You can also insert another column, delete this column or make this column blank. if you select Max Dimension here, you can output maximum dimension (dimension plus upper tolerance). If you select Min Dimension here, you can output minimum dimension (dimension plus lower tolerance).
By the way, as you see from the above image, you can change or edit output attributes data. You can also insert another column, delete this column or make this column blank. if you select Max Dimension here, you can output maximum dimension (dimension plus upper tolerance). If you select Min Dimension here, you can output minimum dimension (dimension plus lower tolerance).
Step 10: Then change Column D to Lower Tolerance.
Step 11: Delete the rest of the columns (From column E to column K).
Step 12: Then press the OK button (In the below example, QA-CAD outputs balloon number to column A, dimension to column B, upper tolerance to column C and lower tolerance to column D in a selected EXCEL template).
Step 13: Then QA Settings window opens. Select ‘MY SAMPLE’ in the EXCEL template, press the OK button. Open your drawing file, capture dimensions and export captured data to your custom EXCEL template .
