The PCB assembly method includes a method for creating a finished board assembly worksheet and a blank board assembly worksheet using an excel program stored in a well-known computer, and a method for using the worksheet; The finished board assembly table is used to complete the same and different stages of the finished board assembly on the blank board.
Each column of cells in the finished board assembly worksheet is used to place the same type of data for different board assembly schemes or Excel internal function calculation formulas, and each row of cells is used to place the same panel scheme or data different types of data for Excel internal function calculation formulas. To create the completed panel worksheet, perform the following steps:
(1) Start the EXCEL program stored on a well-known computer, create a workbook, select a worksheet;
(2) Enter the name of the worksheet using the cells in the table:
(3) Use a row of cells in the table as the header of the worksheet and enter the category name of the data in each cell column;
To create a data entry area, do the following:
(1) Create a data operation area
(2) Create a data output area
(3) Create the panel operation area
(4) Create an indirect output area, use Excel's internal search and reference function to reference all the data in the panel action area worksheet, and place it in the indirect output area.