Complete guide: how to export your captured data to your inspection sheet EXCEL file

Step 1: if you want to output to your EXCEL template file directly, open your EXCEL Template and check start cell and columns. AutoCAD to PDF Converter -file selection (To learn how to output your EXCEL template file in QA-CAD, you can download 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. )



Step 2: Go back to the QA settings window in QA-CAD. Press the Configure EXCEL template button.

AutoCAD to PDF Converter -file selection

Step 3:Then the Manage Excel templates window opens. Press the New button.

AutoCAD to PDF Converter -file selection

Step 4:Then 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.

AutoCAD to PDF Converter -file selection

Step 5: Go back to the Manage Excel templates window and click the ‘…’ button next to the Excel File Name input Field (the red rectangle in the below image)

AutoCAD to PDF Converter -file selection

Step 6:Then select your EXCEL template file (‘SampleFirstPieceApprovalForm.xlsx’ was selected in the below example image). Press the Open button.

AutoCAD to PDF Converter -file selection

Step 7:Press the Configure Columns button in the Manage Excel templates window.

AutoCAD to PDF Converter -file selection

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. AutoCAD to PDF Converter -file selection 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. AutoCAD to PDF Converter -file selection 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.

AutoCAD to PDF Converter -file selection

Step 11:Delete the rest of the columns (From column E to column K).

AutoCAD to PDF Converter -file selection

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).

AutoCAD to PDF Converter -file selection

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 .

AutoCAD to PDF Converter -file selection