CN1560779A - Joining method for printed circuit board - Google Patents

Joining method for printed circuit board Download PDF

Info

Publication number
CN1560779A
CN1560779A CNA2004100186666A CN200410018666A CN1560779A CN 1560779 A CN1560779 A CN 1560779A CN A2004100186666 A CNA2004100186666 A CN A2004100186666A CN 200410018666 A CN200410018666 A CN 200410018666A CN 1560779 A CN1560779 A CN 1560779A
Authority
CN
China
Prior art keywords
blanket
jigsaw
cell
excel
sheet material
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CNA2004100186666A
Other languages
Chinese (zh)
Other versions
CN100504884C (en
Inventor
林惠宾
林宁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to CNB2004100186666A priority Critical patent/CN100504884C/en
Publication of CN1560779A publication Critical patent/CN1560779A/en
Application granted granted Critical
Publication of CN100504884C publication Critical patent/CN100504884C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Abstract

The invention discloses a printed circuit board joining method applied to the producing project, financial cost account, and cell quote system, which includes a method for creating product board joining table and billet joining table with Excel program in known computer and the using method, the product board joining table is used to complete the process of the same and different phase jointing to the product board, the billet board jointing table is used to complete the process of the same and the different phase to the billet boards. The invention realizes the method for joining the boards two grade with the same phase or the different phase, if knows the size of the product board and the size of the board material and the process parameter of the project, the best billet and the best utilization rate can be achieved, increase the utilization rate of the printed circuit board.

Description

The board joint method of printed circuit board (PCB)
Technical field
The present invention relates to the P.e.c. class, especially the board joint method of printed circuit board (PCB) is used for P.e.c. factory production engineering, financial cost accounting and sales quotation system.
Background technology
The blanket that the production engineering of printed circuit board (PCB) factory is combined into production board production usefulness and the sheet material that will enter factory are opened and are expected into blanket and (open material and refer to configure earlier best blanket jigsaw scheme on sheet material, open material by the blanket jigsaw scheme of setting then) and the cost accounting of business management software, online quotations automatically etc. all must be used above-mentioned board joint method.
Along with the fast development of industries such as electronics, communication, the demand of printed circuit board (PCB) increases severely day by day.After the market department of general printed circuit board (PCB) factory receives user's order, use the blanket size by production engineering department by user's production board size and technological parameter measuring and calculating production again, the sheet material that the blanket size of measuring and calculating obtains is as far as possible opened the material utilization factor.
In order to improve the sheet material utilization factor of P.e.c., existing a part of printed circuit board (PCB) factory is engaged in engineering CAM for many years, and Fundamentals of Mathematics good engineering Shi Kaifa one-level homophase board joint method, its use is: set several blanket sizes earlier, (be generally storehouse sheet material 100% and open material size or several blankets of buying) user's production board is pieced together on several blankets of setting, finds out utilization factor blanket preferably.
In order further to improve the sheet material utilization factor of printed circuit board (PCB), printed circuit board (PCB) CAM software company and printed circuit board (PCB) ERP software company have developed one-level with the out-phase board joint method, to use with one-level homophase board joint method basic identical. the sheet material utilization factor is improved, but can not get blanket of storehouse sheet material the best and best sheet material utilization factor.
Summary of the invention
Technical scheme to be solved by this invention is to overcome above-mentioned shortcoming, a kind of board joint method that can realize secondary with the printed circuit board (PCB) of out-phase jigsaw is provided, as long as know production board size and sheet material and engineering department's technological parameter, just can find the blanket of the best of sheet material and best sheet material utilization factor, this has improved the utilization factor of printed circuit board (PCB) greatly.
The board joint method of printed circuit board (PCB) of the present invention comprises Excel program creation production board jigsaw worksheet and the method for blanket jigsaw worksheet and the using method of above-mentioned worksheet of application memory in known computer;
Production board jigsaw worksheet is used to finish production board and carries out process with the out-phase jigsaw on blanket, each column unit lattice of production board jigsaw worksheet are used to place the data of same classification of different blanket jigsaw schemes or the Excel intrinsic function computing formula of these data, each row cell is used to place the different classes of data of same jigsaw scheme or the Excel intrinsic function computing formula of these data, and the concrete grammar of creating production board jigsaw worksheet is:
(1) starts the Excel program that is stored in the known computer, a newly-built workbook, selected worksheet;
(2) title of a cell input service table in the usefulness table;
(3), import the item name of the data of its column at each cell with the gauge outfit of delegation's cell in showing as worksheet;
(4) create the data input area:
Column unit lattice in a, the usefulness table are placed digital number, import the natural number digital number in the cell from top to bottom respectively; Place the blanket numbering with the column unit lattice in the table, difference input alphabet sequence number in cell from top to bottom;
Two cells in b, the usefulness table are respectively as production board length cell lattice and production board length cell lattice; Piece together spacing cell and production board jigsaw hem width degree cell as production board respectively with two cells in the table;
C, place production board quantity with the column unit lattice in the table, each production board is pieced together scheme and is made up of several production boards, just imports several at its corresponding cell.
D, place the blanket structural code of various blanket jigsaw schemes with four column unit lattice in the table, in four cells of each row, import a kind of four part bit digital of blanket structural code of blanket jigsaw scheme respectively, promptly piece together assembly on the broadside of the number of piecing together the long limit that production board is arranged on long limit number, blanket of the broadside that production board is arranged, blanket on the broadside of blanket and have the number that assembly on the long limit of the number on long limit of production board and blanket has the broadside of production board;
, at first import the jigsaw structural code by 1 block of bad plate that production board is combined into from top to bottom, secondly import all possible jigsaw structural code that is combined into by 2 production boards, the jigsaw structural code of each permutation and combination takies delegation; Import all possible jigsaw structural code that is combined into by 3 production boards again, the jigsaw structural code of each permutation and combination takies delegation; By that analogy, until might permutation and combination the jigsaw structural code all import; The jigsaw structural code of the possible permutation and combination quantity of the blanket that is combined into by n piece production board and the jigsaw scheme of each permutation and combination thereof conforms to following equation and determines:
w a×l b+w b×l a＝n(w a≠0，l b≠0)
The group number of equational integer solution is exactly the quantity of possible permutation and combination; Press w for every group a,, l b, w b, l aTactic integer solution is exactly a kind of jigsaw structural code of jigsaw scheme.
(5) create the data operation zone
A, with the column unit lattice data of placing each blanket width in the table, the universal calculation equation of blanket width is w=a * w a+ j * (w a-1)+b * w b+ j * w b+ k * 2, concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
Place the data of each blanket length with the column unit lattice in the table, the universal calculation equation of blanket length is l=b * l b+ j * (l b-1)+a * l a+ j * l a+ k * 2, concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
B, place the blanket width with the column unit lattice in the table and deduct the later width dimensional data of hem width, universal calculation equation is w 0=w-2 * k, input method is as follows: concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
Place blanket length with the column unit lattice in the table and deduct the later length dimension data of hem width, universal calculation equation is l 0=l-2 * k, input method is as follows: concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
The width of c, the blanket that may occur permutation and combination is done a conversion greater than the situation of length, the wide length that is converted to of blanket, the length of blanket is converted to wide, also will carries out the conversion of jigsaw structure simultaneously, the length of blanket and the method for wide conversion are: utilize Excel internal logic function from w 0And l 0Select the length B of big value in two values, select the width A of little value as the blanket after changing as the blanket after changing;
With width and the length that two column unit lattice in the table are placed the blanket after the conversion respectively, utilize Excel internal logic function to judge, concrete grammar is a formula after each cell is imported its Excel internal logic function of answering respectively;
The width of the blanket that may occur permutation and combination is done a conversion greater than the situation of length, carries out the conversion of jigsaw structure, and the conversion method of jigsaw structure is: if l＞w then w aAnd l aNumerical value constant, if l ≯ w then w aWith l aNumerical value exchange; If l＞w then l bAnd w bNumerical value constant, if l ≯ w then l bAnd w bNumerical value exchange;
Place four part numerals of the blanket structure after the conversion respectively with four column unit lattice in the table, utilize Excel internal logic function to judge, concrete grammar is a formula after each cell is imported its Excel internal logic function of answering respectively;
D, place the blanket utilization factor of the blanket scheme after the conversion, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with the column unit lattice in the table;
(6) create the data output area:
Column unit lattice in a, the usefulness table are placed the ordering sequence number of blanket utilization factor, import the natural number digital number in the cell from top to bottom respectively;
Column unit lattice in b, the usefulness table are placed the blanket utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 100 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the blanket utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
C, place the blanket numbering of 100 kinds of blanket jigsaw schemes after the ordering with the column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Column unit lattice in d, the usefulness table are placed the blanket length of 100 kinds of blanket jigsaw schemes after the conversion, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Place the blanket width of 100 kinds of blanket jigsaw schemes after changing with the column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
E, place the 4-digit number of the blanket structure of 100 kinds of blanket jigsaw schemes after the conversion respectively with four column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Blanket jigsaw worksheet is used to finish 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor, carries out the process with the out-phase jigsaw on the sheet material plate, and its creation method is as follows:
(1) with the Excel program in the above-mentioned known computer that has started, a newly-built workbook, selected worksheet;
(2) in title with a cell input service table in the table;
(3), import the item name of the data of its column at each cell with the gauge outfit of delegation in showing as worksheet;
(4) create the data referencing zone
Utilize Excel internal searching and referencing function, quote in the production board jigsaw worksheet the total data of data output area, and be placed on this data referencing zone;
(5) create jigsaw computing zone:
Jigsaw computing zone is made up of 100 identical jigsaw unskilled labourer tabulations, and 100 little worksheets of identical jigsaw are respectively applied for 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor are carried out jigsaw on sheet material the process of finishing; With two cells respectively as sheet material width cell and sheet material length cell lattice; With two cells respectively as bad plate jigsaw spacing cell and bad plate jigsaw hem width cell; The creation method of 100 little worksheets of jigsaw is identical, and the creation method of the little worksheet of one of them jigsaw is:
A, finish the homophase jigsaw process of on the broadside of placing blanket on the broadside of sheet material, long limit, placing the long limit of blanket, the W of the number of the blanket broadside that in a cell, can place on the broadside of placement sheet material at sheet material with two cells in the table A, W ABe general formula W A is little=(integral part of numerical value of W-k * 2+j)/(w+j) is placed the number L that the blanket that can place on the long limit of calculating sheet material is grown the limit in another cell B, L BBe general formula L B is little=(integral part of numerical value of L-k * 2+j)/(l+j), concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this homophase jigsaw, general formula is (w * l) * (W A* L B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
B, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned a step, after the broadside number of placing blanket on the broadside of sheet material subtracted one, the long limit that can the surplus size when this blanket width adds former homophase jigsaw on the sheet material broadside put next blanket, i.e. general formula (W A is little-W A+ 1) * and whether the numerical value of w/l is greater than 1, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((W A-1) * L B+ 1 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
C, finish another out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned a step, after the broadside number of placing blanket on the broadside of sheet material subtracted two, the long limit that can the surplus size when these two blanket width add former homophase jigsaw on the sheet material broadside put down two blankets, i.e. general formula (W A is little-W A+ 2) * and whether the numerical value of w/l is greater than 2, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((W A-2) * L B+ 2 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
D, finish out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned a step, the integer number of the broadside of the blanket that the surplus size during former homophase jigsaw on the long limit of sheet material can be put down, i.e. general formula (L A is little-L AThe integral part of) * l/w, concrete grammar are to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W A* L B+ X * W B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and X is (L in the formula A is little-L AThe integral part of) * l/w;
E, finish another out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned a step, after the long limit number of placing blanket on the long limit of sheet material subtracted one, surplus size when this blanket length adds former homophase jigsaw on the long limit of sheet material can be put down the number of the broadside of blanket, i.e. general formula (L A is little-L A+ 1) * and the integral part of l/w, concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W A* (L B-1)+Y * W B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and Y is (L in the formula A is little-L A+ 1) * the l/w integral part;
F, finish the homophase jigsaw process of on the long limit of placing blanket on the broadside of sheet material, long limit, placing the broadside of blanket, the number on the blanket length limit that in a cell, can place on the broadside of placement sheet material at sheet material with two cells in the table B, W BBe general formula W B is little=(integral part of numerical value of W-k * 2+j)/(l+j) is placed the number L of the blanket broadside that can place on the long limit of calculating sheet material in another cell A, L ABe general formula L A is little=(integral part of numerical value of L-k * 2+j)/(w+j), concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this homophase jigsaw, general formula is (w * l) * (W A* L B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
G, finish out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned f step, after the broadside number of placing blanket on the long limit of sheet material subtracted one, the long limit that can the surplus size when this blanket width adds former homophase jigsaw on the long limit of sheet material put next blanket, i.e. general formula (L A is little-L A+ 1) * and whether the integral part of w/l numerical value is greater than 1, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((L A-l) * W B+ 1 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
H, finish another out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned f step, after the broadside number of placing blanket on the long limit of sheet material subtracted two, the long limit that can the surplus size when these two blanket width add former homophase jigsaw on the long limit of sheet material put down two blankets, i.e. general formula (L A is little-L A+ 2) * and whether the numerical value of w/l is greater than 2, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((L A-2) * W B+ 2 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
I, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned f step, the integer number of the broadside of the blanket that the surplus size during former homophase jigsaw on the sheet material broadside can be put down, i.e. general formula (W B is little-W BThe integral part of) * l/w, concrete grammar are to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W B* L A+ M * W A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and M is (W in the formula B is little-W BThe integral part of) * l/w;
J, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned f step, after the number on the long limit of the blanket of placing on the sheet material broadside during former homophase jigsaw subtracts one, the size on this base length of side limit adds the integer number of the broadside of the blanket that the surplus size on the former sheet material broadside can be put down, i.e. general formula (W B is little-W B+ 1) * and the integral part of l/w numerical value, concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W B* L A+ N * W A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and N is (W in the formula B is little-W B+ 1) * the l/w integral part;
K, with the table in a cell place the numerical value of maximum sheet material utilization factor, utilize the statistical function of the inner maximizing of Excel, choose a sheet material utilization factor maximum from above-mentioned a to j, concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
(6) create indirect output area
Utilize Excel internal searching and referencing function, quote the total data in the jigsaw computing regional work table, and be placed on this indirect output area;
The using method of described production board jigsaw worksheet and blanket jigsaw worksheet is as follows:
(1) imports the length and width size of production board respectively at production board length cell lattice, production board width cell;
(2) at interval cell, production board jigsaw hem width cell are imported processing technology respectively and are required production board jigsaw interval, the production board jigsaw hem width size reserved at the production board jigsaw;
(3) in sheet material length cell lattice, the sheet material width cell length and width size of input slab respectively;
(4) import processing technology respectively at bad plate jigsaw spacing cell, blanket jigsaw hem width cell and require the bad plate jigsaw interval of reserving, bad plate jigsaw hem width size;
(5) click the load button √ in the Excel formula bar or build, show the formula operation result in each cell by Enter.
In the above-mentioned formula, a is the length of the broadside of production board, b is the length on the long limit of production board, j is the width at the interval between the adjacent production board, k is the width on the limit of the production board on blanket four limits to the limit of blanket, w is the length of the broadside before a certain blanket length and width conversion, and l is the length on the long limit before a certain blanket length and width conversion, w 0The length of changing preceding broadside for a certain blanket length and width deducts the later dimensional data of hem width, l 0The length of changing preceding long limit for a certain blanket length and width deducts the later dimensional data of hem width, and A is the length of the broadside after a certain blanket length and width conversion, and B is the length on the long limit after a certain blanket length and width conversion, w aFor the integer number of the broadside of the production board on a certain blanket broadside promptly has the plate of what production boards wide on the blanket broadside, l bThe integer number of growing the long limit of the production board on the limit for a certain blanket promptly has the plate of what production boards long on the long limit of blanket, w bFor the integer number on the long limit of the production board on a certain blanket broadside promptly has the plate of what production boards long on the blanket broadside, l aThe integer number of growing the broadside of the production board on the limit for a certain blanket promptly has the plate of what production boards wide on the long limit of blanket, and W is the length of the broadside of sheet material, and L is the length on the long limit of sheet material, W AFor the integer number of the broadside of the blanket on a certain sheet material broadside promptly has the plate of what blankets wide on the sheet material broadside, L BThe integer number of growing the long limit of the blanket on the limit for a certain sheet material promptly has the plate of what base utmost points long on the long limit of sheet material, W BFor the integer number on the long limit of the blanket on a certain sheet material broadside promptly has the plate of what blankets long on the sheet material broadside, L AThe integer number of growing the broadside of the blanket on the limit for a certain sheet material promptly has the plate of what base utmost points wide on the long limit of sheet material.
As further improvement in the technical proposal, the board joint method of printed circuit board (PCB) of the present invention comprises that also following establishment concentrates the method for output area:
Delegation imports the item name of the data of its column as the gauge outfit of worksheet in a, the usefulness table at each cell;
Column unit lattice in b, the usefulness table are placed digital number, import natural number 1,2,3 to 45 in the cell from top to bottom respectively;
Column unit lattice in c, the usefulness table are placed the sheet material utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
D, place the blanket width and the length of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
Column unit lattice in e, the usefulness table are placed the blanket utilization factor of 45 kinds of sheet material jigsaw schemes after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
F, place the blanket numbering of the blanket jigsaw scheme of 45 kinds of sheet material jigsaw schemes after the ordering with the column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
G, place the 4-digit number of the jigsaw structural code of 45 kinds of sheet material jigsaw schemes after the ordering respectively with four column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
H, place with the column unit lattice in the table and to open the material utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
I, place the long limit surplus size of sheet material and the sheet material broadside surplus size of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
J, to place the plate of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table long and plate is wide, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
K, place the 4-digit number of the blanket jigsaw structural code of 45 kinds of sheet material jigsaw schemes after the ordering respectively with four column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence.
Compared with prior art, the present invention has following beneficial effect: the present invention has realized secondary with the out-phase jigsaw, can obtain whole production boards with out-phase blanket jigsaw.Again whole same out-phase blanket jigsaw on sheet material.To obtain the jigsaw scheme of the unique best utilization factor of best blanket and sheet material, the utilization factor of printed circuit board (PCB) is greatly improved.
Embodiment
Before the board joint method to printed circuit board (PCB) of the present invention elaborates, following problem is described earlier.
Blanket of the prior art is to open material or firsthand blanket by sheet material 100%.During jigsaw, on the blanket of several sizes, carry out jigsaw respectively with production board earlier, choose the highest blanket of blanket utilization factor as better blanket.Blanket of the present invention, the same out-phase blanket jigsaw that it has comprised nearly all possibility permutation and combination carries out choosing unique best jigsaw with the out-phase jigsaw on sheet material with these blankets again, obtains the best utilization factor of sheet material.
For the ease of understand, convenient narration, it is existing that to open the material structure with blanket jigsaw structure 7157 and sheet material be 0023 be that example makes a presentation jigsaw structure and describing mode thereof, and to the subalphbet symbol among the application and noun work to give a definition.
For example, blanket jigsaw structure is that 7157, the first figure places 7 are illustrated in the broadside that 7 production boards are arranged on the blanket broadside, i.e. w a=7; Second order digit 1 is illustrated in the long limit that 1 production board is arranged on the long limit of blanket, i.e. l b=1; The 3rd figure place 5 is illustrated in the long limit that 5 production boards are arranged on the blanket broadside, i.e. w b=5; The broadside that 7 production boards are arranged on the long limit of four figures 7 expression blankets, i.e. l a=7.This blanket jigsaw structure has constituted at the long upwards out-phase jigsaw of blanket.
For example, to open the material structure be 0023, the first figure place 0 is illustrated in 0 blanket on the broadside of sheet material broadside, i.e. W to sheet material A=0; Second order digit 0 is illustrated in the long limit that 0 blanket is arranged on the long limit of sheet material, i.e. L B=0; The 3rd figure place 2 is illustrated in the long limit that 2 blankets are arranged on the sheet material broadside, i.e. W B=2; The broadside that 3 blankets are arranged on the long limit of four figures 3 expression sheet materials, i.e. L A=7.This sheet material jigsaw structure is the homophase jigsaw.
Now to and the subalphbet symbol among the application and noun done to give a definition:
A----represents the length of the broadside of production board.
B----represents the length on the long limit of production board.
J----represents jigsaw at interval, and production board refers to the width at the interval between the adjacent production board during jigsaw on blanket; Blanket refers to the width at the interval between the adjacent blanket during jigsaw on sheet material.
K----represents the jigsaw hem width, and production board refers to the width on the limit of the production board on blanket four limits to the limit of blanket during jigsaw on blanket; Blanket width on limit to the limit of sheet material of the blanket on fingerboard material four limits during jigsaw on sheet material.
On blanket, the width on the limit of the production board on blanket four limits to the limit of blanket.
W----is expressed as the length of the broadside before a certain blanket length and width conversion.
L----is expressed as the length on the long limit before a certain blanket length and width conversion.
w 0The length that----is expressed as the broadside before a certain blanket length and width conversion deducts the later dimensional data of hem width.
l 0The length that----is expressed as the long limit before a certain blanket length and width conversion deducts the later dimensional data of hem width.
A----is expressed as the length of the broadside after a certain blanket length and width conversion.
B----is expressed as the length on the long limit after a certain blanket length and width conversion.
w a----represents the integer number of the broadside of the production board on a certain blanket broadside, promptly has the plate of what production boards wide on the blanket broadside.
l b----represents the integer number on the long limit of the production board on the long limit of a certain blanket, promptly has the plate of what production boards long on the long limit of blanket.
w b----represents the integer number on the long limit of the production board on a certain blanket broadside, promptly has the plate of what production boards long on the blanket broadside.
l a----represents the integer number of the broadside of the production board on the long limit of a certain blanket, promptly has the plate of what production boards wide on the long limit of blanket.
W----represents the length of the broadside of sheet material.
L----represents the length on the long limit of sheet material.
W A is little----represents the number (containing fraction part) of the broadside of the blanket on a certain sheet material broadside, W ABe W A is littleIntegral part.
L B is little----represents the number (containing fraction part) on the long limit of the blanket on the long limit of a certain sheet material, L BBe L B is littleIntegral part.
W B is little----represents the number (containing fraction part) on the long limit of the blanket on a certain sheet material broadside, W BBe W B is littleIntegral part.
L A is little----represents the number (containing fraction part) of the broadside of the blanket on the long limit of a certain sheet material, L ABe L A is littleIntegral part.
Promptly on the long limit of sheet material, there is the plate of what blankets wide.
Blanket utilization factor: the i.e. ratio of the total area of all production boards and blanket area in the blanket.
Open the material utilization factor: i.e. the ratio of the blanket total area in the sheet material and sheet material area.
Sheet material plate utilization factor: the i.e. ratio of the production board total area in the sheet material and sheet material area.
IF, MATCH, INDEX and LARGE are the intrinsic function that Microsoft Excel provides, and wherein, IF is the logic class function, and its function is: carry out true-false value and judge, and true and false according to what specified requirements is carried out logic estimates, and return different results; MATCH searches and the referenced classes function, and its function is: from quote or array the value of searching; INDEX searches and the referenced classes function, and its function is: from table or a value is returned in the unit area or to quoting of numerical value wherein; LARGE adds up class function, and its function is: k maximal value from return array.
Elaborate below in conjunction with the board joint method of embodiment to printed circuit board (PCB) of the present invention.
The board joint method of printed circuit board (PCB), the method, the method for creating blanket jigsaw worksheet and the using method of above-mentioned worksheet that comprise following application Excel program creation production board jigsaw worksheet, production board jigsaw worksheet is used to finish production board and carries out process with the out-phase jigsaw on blanket, and blanket jigsaw worksheet is used to finish blanket and carries out process with the out-phase jigsaw on sheet material.
It is as follows to create production board jigsaw worksheet method:
1, starts the Excel program that is stored in the known computer, a newly-built workbook, select sheet sheet1.
2, selected cell A2, the input service table name claims therein, as " production board jigsaw worksheet ".
3, use the gauge outfit of the 12nd row, import the item name of the data of its column at each cell as worksheet 1.
4, create the data input area:
A, at cell F12 input " digital number ", cell zone F13:F612 respectively input digit sequence number 1,2,3 ... 600; In cell G12 input " blanket numbering ", cell zone G13:G612 distinguish input alphabet sequence number A, B, C ..., Z, AA, AB, AC ..., AZ, BA, BB, BC ..., BZ ... XA, XB.
Two cells in b, the usefulness table are respectively as production board length cell lattice and production board length cell lattice; Piece together spacing cell and production board jigsaw hem width degree cell as production board respectively with two cells in the table;
C, at " n " of cell J12 input expression production board quantity, J13:J612 imports production board quantity respectively in the cell zone, each production board is pieced together scheme and is made up of several production boards, just imports several at its corresponding cell.
D, import " the w of number of the broadside of the production board of expression on a certain blanket broadside respectively at cell N12, O12, P12, Q12 a", " l of the number on the long limit of the production board on the long limit of a certain blanket of expression b", " w of the number on the long limit of the production board of expression on a certain blanket broadside b", " l of the number of the broadside of the production board on the long limit of a certain blanket of expression a".
At unit area N13:Q612, import the structural code of each blanket jigsaw scheme, method is: four part numerals of the structural code of a kind of blanket jigsaw scheme of each row input, for example to be 3517 jigsaw scheme in unit area N89:Q89 input blanket jigsaw structural code, then will be input to cell N89, O89, P89, Q89 to 3,5,1,7 respectively.At cell zone N89:Q89,, at first import jigsaw structural code from top to bottom by 1 block of bad plate that production board is combined into, secondly import all possible jigsaw structural code that is combined into by 2 production boards, the jigsaw structural code of each permutation and combination takies delegation; Import all possible blanket jigsaw structural code that is combined into by 3 production boards again, the jigsaw structural code of each permutation and combination takies delegation; By that analogy until might permutation and combination the jigsaw structural code all import.Concrete steps are as follows:
The blanket that is combined into by 1 production board, its permutation and combination has only a kind, be that the jigsaw structural code is 1100 bad plate,, promptly import the four part numbers peaceful 1,1,0,0 of jigsaw structural code respectively at cell N13, O13, P13, Q13 in cell zone N13:Q13 input jigsaw structural code.
By 2 blocks of bad plates that production board is combined into, its permutation and combination has 3 kinds, and promptly the jigsaw structural code is; 1200,2100,1111 blanket is imported the jigsaw structural code of these 3 kinds of permutation and combination respectively with 3 row cells.
By the blanket that 3 production boards are combined into, its permutation and combination has 6 kinds, and promptly the jigsaw structural code is equal, and 1300,3100,1121,1112,2111,1211 bad plate is imported the jigsaw structural code of these 6 kinds of permutation and combination of team respectively with 6 row cells.
By the blanket that n piece production board is combined into, its permutation and combination has the N kind, and the numerical value of N is determined by the group number of following equational integer solution:
w a×l b+w b×l a＝n(w a≠0，l b≠0)
In the formula: n----is combined into the quantity of the production board of blanket;
w a,, l b, w b, l aDefinition in front.
The quantity of the permutation and combination that the group number of equational integer solution just is, i.e. N; Press w for every group a,, l b, w b, l aTactic integer solution is exactly a kind of jigsaw structural code of jigsaw scheme, imports the jigsaw structural code of this N kind permutation and combination respectively with the capable cell of N.
Below only enumerated by 1,2,3 and the situation of the blanket formed of n piece production board, the situation that other is not enumerated also is to understand easily for the technician in described field.
5, create the data operation zone:
A, import letter " w ", the expression blanket length letter " l " of expression blanket width respectively at cell H12, I12; H13:H612 imports the computing formula of calculating its corresponding blanket width respectively in the cell zone, and its general formula is w=a * w a+ j * (w a-1)+b * w b+ j * w b+ k * 2, input method is as follows:
Formula after cell H13 input is converted to the Excel intrinsic function by above-mentioned general formula, H13=$A$10*N13+$A$12* (N13-1)+$B$10*P13+$A$12*P13+$B$12*2; Formula after cell H14 input is converted to the Excel intrinsic function by above-mentioned general formula, H14=$A$10*N14+$A$12* (N14-1)+$B$10*P14+$A$12*P14+$B$12*2; Selected then unit area H13:H14 points to this regional lower right corner with mouse pointer, drags and fills handle to cell H612, and the computing formula of the blanket width of cell H15～H612 correspondence is just filled automatically like this.
Import its corresponding blanket length calculation formula of calculating respectively at cell area I 13:I612, its general formula is l=b * l b+ j * (l b-1)+a * l a+ j * l a+ k * 2, input method is as follows: the formula after cell I13 input is converted to the Excel intrinsic function by above-mentioned general formula, I13=$B$10*O13+$A$12* (O13-1)+$A$10*Q13+$A$12*Q13+$B$12*2; Formula after cell I14 input is converted to the Excel intrinsic function by above-mentioned general formula, I14=$B$10*O14+$A$12* (O14-1)+$A$10*Q14+$A$12*Q14+$B$12*2; Selected then unit area I13:I14 points to this regional lower right corner with mouse pointer, drags and fills handle to cell I612, and the blanket length calculation formula of cell I15～I612 correspondence is just filled automatically like this.
B, import the meter letter " w that expression blanket width deducts the later width dimensions of hem width respectively at cell region D 13:E12 0", expression blanket length deducts the letter " l of the later length dimension of hem width 0", import the computing formula that its corresponding blanket width of calculating deducts the later width dimensions of hem width respectively at cell region D 13:D612, it can be w with formula 0=w-2 * k, input method is as follows:
Formula after single D13 input is converted to the Excel intrinsic function by above-mentioned general formula, D13=H13-$B$12*2; Formula after cell D14 input is converted to the Excel intrinsic function by above-mentioned general formula, D14=H14-$B$12*2; Selected then unit area D13:D14 points to this regional lower right corner with mouse pointer, drags and fills handle to D612, and the computing formula of D15-D612 correspondence is just filled automatically like this.
Import the computing formula that its corresponding blanket length of calculating deducts the later length dimension of hem width respectively at unit area E13:E612, its general formula is l 0=l-2 * k, input method is as follows: the formula after cell E13 input is converted to the Excel intrinsic function by above-mentioned general formula, E13=I13-$B$12*2; Formula after cell E14 input is converted to the Excel intrinsic function by above-mentioned general formula, E14=I14-$B$12*2; Selected then unit area E13:E14 points to this regional lower right corner with mouse pointer, drags and fills handle to E612, and the computing formula of E15～E612 correspondence is just filled automatically like this.
C, in all possible permutation and combination, the situation of the width of blanket greater than length may appear, at this moment to do a conversion, long the wide conversion of blanket, wide the long conversion of blanket, also to carry out the conversion of jigsaw structure simultaneously.The length of blanket and the method for wide conversion are: from w 0And l 0Select the length B of big value in two values, select the width A of little value as the blanket after changing as the blanket after changing.
Letter " the l of the blanket length after cell B12, C12 import the expression conversion respectively 1", the letter " w of the blanket width after the expression conversion 1", import the Excel intrinsic function formula that can realize above-mentioned conversion method respectively at cell area B 13:B612, input method is as follows:
Import the Excel intrinsic function formula that to realize above-mentioned conversion method, B13=IF (E13＞D13, E13, D13)+$D$7+$E$7 at cell B13; Import the Excel intrinsic function formula that to realize above-mentioned conversion method, B14=IF (E14＞D14, E14, D14)+$D$7+$E$7 at cell B14; Selected then unit area B13:B14 points to this regional lower right corner with mouse pointer, drags and fills handle to B612, and the computing formula of B15～B612 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula that to realize above-mentioned conversion method respectively at cell zone C 13:C612, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell C13 input, C13=IF (E13＞D13, D13, E13)+$B$7+$C$7; Import the Excel intrinsic function formula that to realize above-mentioned conversion method, C14=IF (E14＞D14, E14, D14)+$B$7+$C$7 at cell C14; Selected then unit area C13:C14 points to this regional lower right corner with mouse pointer, drags and fills handle to C612, and the computing formula of C15～C612 correspondence is just filled automatically like this.
The conversion method of jigsaw structure is: if l＞w then w aAnd l aNumerical value constant, if l ≯ w then w aWith l aNumerical value exchange; If l＞w then l bAnd w bNumerical value constant, if B ≯ A then l bAnd w bNumerical value exchange.Import " w respectively at cell U12, V12, W12, X12 A1", " l B1", " w B1", " l A1"; U13:U612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, and input method is as follows: import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell U13, U13=IF (I13＞H13; N13, Q13); Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell U14, and U14=IF (I14＞H14, N14, Q14); Selected then unit area U13:U14 points to this regional lower right corner with mouse pointer, drags and fills handle to U612, and the computing formula of U15～U612 correspondence is just filled automatically like this.
V13:V612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell V13 input, V13=IF (I13＞H13, O13, P13); Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell V14, and V14=IF (I14＞H14, O14, P14); Selected then unit area V13:V14 points to this regional lower right corner with mouse pointer, drags and fills handle to V612, and the computing formula of V15～V612 correspondence is just filled automatically like this.
W13:W612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell W13 input, W13=IF (I13＞H13, P13, O13); Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell W14, and W14=IF (I14＞H14, P14, O14); Selected then unit area W13:W14 points to this regional lower right corner with mouse pointer, drags and fills handle to W612, and the computing formula of W15～W612 correspondence is just filled automatically like this.
X13:X612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell X13 input, X13=IF (I13＞H13, Q13, N13); Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell X14, and X14=IF (I14＞H14, Q14, N14); Selected then unit area X13:X14 points to this regional lower right corner with mouse pointer, drags and fills handle to X612, and the computing formula of X15～X612 correspondence is just filled automatically like this.
D, in cell M12 input expression " the blanket utilization factor ", M13:M612 imports the computing formula of calculating its corresponding utilization factor respectively in the cell zone, its general formula is=a * b * n/ (w 1* l 1), input method is as follows:
Formula after cell M13 input is converted to the Excel intrinsic function by above-mentioned general formula, M13=$A$10*$B$10*J13/ (B13*C13); Formula after cell M14 input is converted to the Excel intrinsic function by above-mentioned general formula, M14=$A$10*$B$10*J14/ (B14*C14); Selected then unit area M13:M14 points to this regional lower right corner with mouse pointer, drags and fills handle to M612, and the computing formula of M15～M612 correspondence is just filled automatically like this.
6, create the data output area
A, at cell AE12 input " digital number ", importing the natural number digital number respectively, as 1,2,3 at cell zone AE13:AE112 ... 100.
B, in cell AF12 input " ordering back blanket utilization factor ", sort method is: the blanket utilization factor is sorted from large to small, choose preceding 100 blanket jigsaw schemes, and the utilization factor numerical value of maximum is put into cell AF13, second utilization factor numerical value is put into cell AF14,, the 100th utilization factor numerical value is put into cell AF112.AF13:AF112 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, and input method is as follows:
Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell AF13, AF13=LARGE ($AC$13:$AC$612, AF13); Import the Excel intrinsic function formula that can realize above-mentioned conversion method at cell AF14, AF14=LARGE ($AC$13:$AC$612, AF14); Selected then unit area AF13:AF14 points to this regional lower right corner with mouse pointer, drags and fills handle to AF112, and the computing formula of AF15～AF112 correspondence is just filled automatically like this.
C, in cell AD12 input " blanket numbering ", method in the corresponding blanket numbering of unit area AD13:AD112 input is: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell AD13 input, AD13=IF (AF13=0,0, INDEX ($G$13:$G$612, MATCH (AF14 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AD14=IF (AFH=0,0, INDEX ($G$13:$G$612, MATCH (AF14 ， $M$13:$M$612)) at cell AD14); Selected then unit area AD13:AD14 points to this regional lower right corner with mouse pointer, drags and fills handle to AD112, and the computing formula of AD15～AD112 correspondence is just filled automatically like this.
Letter " the l of d, the blanket length after cell AG12, AH12 import the expression conversion respectively 1", the letter " w of blanket width after the conversion 1",
At the formula of the corresponding blanket length of unit area AG13:AG112 input, at cell AG13 input Excel intrinsic function formula, AG13=IF (AF13=0,0, INDEX ($R$13:$R$612, MATCH (AF13 ， $M$13:$M$612))); At cell AG14 input Excel intrinsic function formula, AG14=IF (AF14=0,0, INDEX ($R$13:$R$612, MATCH (AF14 ， $M$13:$M$612))); Selected then unit area AG13:AG14 points to this regional lower right corner with mouse pointer, drags and fills handle to AG112, and the computing formula of AG15～AG112 correspondence is just filled automatically like this.
At the formula of the corresponding blanket width of unit area AH13:AH112 input, at cell AH13 input Excel intrinsic function formula, AH13=IF (AF13=0,0, INDEX ($S$13:$S$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AH14=IF (AF14=0,0, INDEX ($R$13:$R$612, MATCH (AF14 ， $M$13:$M$612)) at cell AH14); Selected then unit area AH13:AH14 points to this regional lower right corner with mouse pointer, drags and fills handle to AH612, and the computing formula of AH15～AH112 correspondence is just filled automatically like this.
E, import " w respectively at cell AI12, AJ12, AK12, AL12 A1", " l B1", " w B1", " l A1"; AI13:AI612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone; input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell AI13 input; AI13=IF (AF13=0; 0; INDEX ($U$13:$U$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AI14=IF (AF14=0,0, INDEX ($U$13:$U$612, MATCH (AF14 ， $M$13:$M$612)) at cell AI14); Selected then unit area U13:U14 points to this regional lower right corner with mouse pointer, drags and fills handle to AI612, and the computing formula of AI15～AI612 correspondence is just filled automatically like this.
AJ13:AJ612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell AJ13 input, AJ13=IF (AF13=0,0, INDEX ($V$13:$V$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AJ14=IF (AF14=0,0, INDEX ($V$13:$V$612, MATCH (AF14 ， $M$13:$M$612)) at cell AI14); Selected then unit area AJ13:AJ14 points to this regional lower right corner with mouse pointer, drags and fills handle to AJ612, and the computing formula of AJ15～AJ612 correspondence is just filled automatically like this.
AK13:AK612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell AK13 input, AK13=IF (AF13=0,0, INDEX ($W$13:$W$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AK14=IF (AF14=0,0, INDEX ($W$13:$W$612, MATCH (AF14 ， $M$13:$M$612)) at cell AI14); Selected then unit area AK13:AK14 points to this regional lower right corner with mouse pointer, drags and fills handle to AK612, and the computing formula of AK15～AK612 correspondence is just filled automatically like this.
AL13:AL612 imports the Excel intrinsic function formula that can realize above-mentioned conversion method respectively in the cell zone, input method is as follows: the Excel intrinsic function formula that can realize above-mentioned conversion method in cell AL13 input, AL13=IF (AF13=0,0, INDEX ($X$13:$X$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AL14=IF (AF14=0,0, INDEX ($x$13:$X$612, MATCH (AF14 ， $M$13:$M$612)) at cell AL14); Selected then unit area AL13:AL14 points to this regional lower right corner with mouse pointer, drags and fills handle to AL612, and the computing formula of AL15～AL612 correspondence is just filled automatically like this.
F, at cell AM12 input " production board plate number ", at unit area AM13:AM612 input corresponding finished plate plate number, can realize the Excel intrinsic function formula of above-mentioned conversion method in cell AM13 input, AM13=IF (AF13=0,0, INDEX ($J$13:$J$612, MATCH (AF13 ， $M$13:$M$612))); Import the Excel intrinsic function formula that to realize above-mentioned conversion method, AM14=IF (AF14=0,0, INDEX ($J$13:$J$612, MATCH (AF14 ， $M$13:$M$612)) at cell AD14); Selected then unit area AM13:AM14 points to this regional lower right corner with mouse pointer, drags and fills handle to AM612, and the computing formula of AM15～AM612 correspondence is just filled automatically like this.
Create the method for blanket jigsaw worksheet
Blanket jigsaw worksheet is divided into data referencing zone, jigsaw computing zone, the indirect output area of data and four parts of data centralization output area, be used to finish 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor, carry out the process with the out-phase jigsaw on the sheet material plate, its creation method is as follows:
1, starts the Excel program that is stored in the known computer, select sheet sheet2;
2, selected cell A1, the input service table name claims therein, as " blanket jigsaw worksheet ".
3,, import the item name of the data of its column at each cell with the gauge outfit of delegation's cell in showing as worksheet;
4, create the data referencing zone:
Use data for convenience, establishment data referencing zone, utilize Excel internal searching and referencing function formula, " blanket numbering ", " blanket utilization factor ", " blanket length ", " blanket width ", " w of preceding 100 blanket schemes of arranging from big to small by the blanket utilization factor of production board jigsaw worksheet output a", " l b", " w b", " l a" concrete numerical value, introduce this table and be placed on this data referencing zone.
Import " blanket numbering ", " w respectively at cell AP61, AQ61, AR61, AS61, AT61, AU61, AV61, AY61 a", " l b", " w b", " l a", " blanket width ", " blanket length ", " blanket utilization factor ";
The parameter of the blanket scheme of blanket utilization factor maximum is put into the 67th row, the parameter of the blanket scheme of blanket utilization factor second is put into the 73rd row, the parameter of the blanket scheme of blanket utilization factor the 3rd is put into the 79th row, by that analogy, every every trade number is for increasing progressively 6 arithmetic progression, the parameter that the blanket utilization factor is arranged the 100th blanket scheme is put into the 661st row (61+100 * 6=661 is capable), and concrete grammar is as follows:
$AF$13;
$AF$14;
$AF$15;
$AF$112.
Below only enumerated blanket utilization factor the 1st, 2,3 and 100 situation, the quoting and importing of the data of other blanket scheme similarly, concerning the technician in described field, also is to understand easily.
5, create jigsaw computing zone
Jigsaw computing zone is made up of 100 identical jigsaw unskilled labourer tabulations, and 100 little worksheets of identical jigsaw are respectively applied for 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor are carried out jigsaw on sheet material the process of finishing; With cell CJ58, CJ59 respectively as sheet material width cell and sheet material length cell lattice; With cell CK58, CK59 respectively as bad plate jigsaw spacing cell and bad plate jigsaw hem width cell; The creation method of 100 little worksheets of jigsaw is identical, and the creation method of the little worksheet of one of them jigsaw is:
A. in cell CJ61 input " plate is wide ", import Excel intrinsic function formula CJ62=$CK$58, CJ63=$CK$58, CJ64=$CK$58, CJ65=$CK$58, the CJ66=$CK$58 that quotes the wide data of plate respectively at cell CJ62～CJ66.
B. cell CK61 input " plate is long ", import Excel intrinsic function formula CK62=$CK$59, CK63=$CK$59, CK64=$CK$59, CK65=$CK$59, the CK66=$CK$59 that quotes the plate long data respectively at cell CK62～CK66.
C. letter " the W of the number of the broadside of the blanket of on the broadside of cell CL61 input expression sheet material, placing A"; At cell CM61 input alphabet " N1 ".
The formula of the number (containing fraction part) of the broadside of the blanket that should be able to place on the broadside of cell CL62 input calculating sheet material, general formula is W A=(W-k * 2+j)/(A+j), its Excel intrinsic function formula CL62=(CJ62-2*$E$10+$D$10)/(AU67+$D$10); The formula of the number (integral part) of the broadside of the blanket that on the broadside of cell CM62 input calculating sheet material, should be able to place, its Excel intrinsic function formula CM62=INT (CL62).
Carrying out the out-phase jigsaw at cell CL63 judges, the number of the broadside of the blanket that should be able to place on the broadside of sheet material is removed one, can the size of this blanket hem width add the long limit that put next blanket behind the original remaining hem width, be that can the CL62 fraction part add the long limit that put next blanket after the size of a blanket hem width, input can realize the Excel intrinsic function formula CL63=(CL62-INT (CL62)+1*IF (CM62＞1 of above-mentioned functions, 1,0)) * (AU67+$D$10)/(AV67+$D$10); At cell CM63 input Excel intrinsic function formula CM63=CL64*CM64.
If the result of above-mentioned judgement is the long limit that can put down blanket, then the number on the long limit of the blanket that can put down is placed on cell CL64, input can realize the Excel intrinsic function formula CL64=INT (CL63) of above-mentioned functions; At cell CM64 input Excel intrinsic function formula CM64=IF (CM62＞1,1,0).
Carrying out the out-phase jigsaw at cell CL65 judges, the number of the broadside of the blanket that should be able to place on the broadside of sheet material is removed two, the size of these two blanket hem widths adds the long limit that can put down several blankets behind the original remaining hem width, be that the CL62 fraction part adds the long limit that can put down several blankets after the size of two blanket hem widths, input can realize the Excel intrinsic function formula CL65=(CL62-INT (CL62)+2*IF (CM62＞2 of above-mentioned functions, 1,0)) * (AU67+$D$10)/(AV67+$D$10); At cell CM65 input Excel intrinsic function formula CM65=CL66*CM66.
If the result of above-mentioned judgement is the long limit that can put down blanket, then the number on the long limit of the blanket that can put down is placed on cell CL66, input can realize the Excel intrinsic function formula CL66=INT (CL65) of above-mentioned functions; At cell CM66 input Excel intrinsic function formula CM66=IF (CM62＞2,1,0).
D. letter " the L of the number on the long limit of the blanket of on the long limit of cell CQ61 input expression sheet material, placing B"; At cell CR61 input alphabet " N2 ".
The formula of the number (containing fraction part) on the long limit of the blanket that should be able to place on the long limit of cell CQ62 input calculating sheet material, general formula is L B=(L-k * 2+j)/(B+j), its Excel intrinsic function formula CQ62=(CK62-2*$E$10+$D$10)/(AV67+$D$10); The formula of the number (integral part) of the broadside of the blanket that on the broadside of cell CR62 input calculating sheet material, should be able to place, its Excel intrinsic function formula CR62=INT (CQ62).
Carrying out the out-phase jigsaw at cell CQ64 judges, can remaining length put down the broadside number (containing fraction part) of blanket on the long limit of sheet material, be the broadside that can put down several blankets after the size of CQ62 fraction part, input can realize that the Excel intrinsic function formula of above-mentioned functions is at cell CM63 input Excel intrinsic function formula CQ63=(CQ62-INT (CQ62)) * (AV67+$D$10)/(AU67+$D$10); Can remaining length put down the broadside number (integral part) of blanket on the long limit of cell CR64 placement sheet material, can realize the Excel intrinsic function formula CR64=INT (CQ64) of above-mentioned functions in cell CR64 input.
At the Excel intrinsic function formula CR65=INT (CQ66) of cell CQ65 input to the CQ66 round numbers; At cell CR6 input Excel intrinsic function formula CR65=IF (CR62＞1,1,0).
Carrying out the out-phase jigsaw at cell CQ66 judges, the number on the long limit of the blanket that should be able to place on the long limit of sheet material is removed one, the size on the long limit of this blanket adds the long limit that can put down several blankets after the size of original remaining long limit, be that can the CQ62 fraction part add the long limit that put several blankets after the size on the long limit of a blanket, input can realize the Excel intrinsic function formula CQ66=(CQ62-INT (CQ62)+1*IF (CR62＞1 of above-mentioned functions, 1,0)) * (AV67+$D$10)/(AU67+$D$10); At cell CR66 input Excel intrinsic function formula CR66=CQ65*CR65.
E. on the broadside of cell CP61 input expression sheet material " the broadside residue " of surplus size; Place surplus size on the broadside of scheme of homophase jigsaw at cell CP62～CP66, cell CP62～CP66 import respectively its corresponding Excel intrinsic function formula CP62=(CJ62-AU67*CM62-$D$10* (CM62-1))/2,
CP63＝(CJ62-AU67*(CM62-IF(CM63＝0，0，1))-AV67*CM63-$D$10*(CM62-1-IF(CM63＝0，0，1)+CM63))/2、
CP64＝IF(CR64＞0，IF(CP62＜DC62，CP62，DC62)，CP62)、
CP65＝(CJ62-AU67*(CM62-2*IF(CM65＝0，0，1))-AV67*CM65-$D$10*(CM62-1-2*IF(CM65＝0，0，1)+CM65))/2、
CP66＝IF(CR66＞0，IF(CP62＜DC62，CP62，DC62)，CP62)。
F. on the long limit of cell CT61 input expression sheet material " the long limit residue " of surplus size; Place surplus size on the long limit of scheme of homophase jigsaw at cell CT62～CT66, cell CT62～CT66 import respectively its corresponding Excel intrinsic function formula CT62=(CK62-AV67*CR62-$D$10* (CR62-1)/2,
CT63＝IF(CM63＞0，IF(CT62＜CZ62，CT62，CZ62)，CT62)、
CT64＝(CK62-AV67*CR62-AU67*CR64-$D$10*(CR62-1+CR64)/2、
CT65＝IF(CM65＞0，IF(CT62＜CZ62，CT62，CZ62)，CT62)、
CT66＝(CK62-AV67*(CR62-1)-AU67*CR66-$D$*(CR62-1-1+CR66))/2。
G. cell CU61 input " utilization factor relatively ", relatively which is big for two class utilization factors of the CW row placed of speech and DE row? import CU62=IF (CW62＞DE62,1,0), CU63=IF (CW63＞DE63 respectively at cell CU62, CU63, CU64, CU65, CU66,1,0), CU64=IF (CW64＞DE64,1,0), CU65=IF (CW65＞DE65,1,0), CU66=IF (CW66＞DE66,1,0).
H. utilization factor is placed the long limit of blanket on the long limit of input slab respectively and the utilization factor of homophase jigsaw of putting the broadside of blanket on the broadside at cell CW62～CW66, and on the basis that this homophase is pieced together mutually the utilization factor of 4 kinds of out-phase jigsaw,
Be after removing the broadside size of a blanket on the sheet material broadside pieced together of above-mentioned homophase, to add the former surplus utilization factor of making to place on surplus cun this out-phase plate in the long limit of blanket of sheet material broadside in this size; The surplus utilization factor of making to place on the size this out-phase plate of blanket broadside on the long limit of the sheet material that above-mentioned homophase is pieced together; After removing the broadside size of two blankets on the sheet material broadside that above-mentioned homophase is pieced together, add the former surplus utilization factor of making to place on the size this out-phase plate in the long limit of blanket of sheet material broadside in this size; After removing the long limit size of a blanket on the long limit of the sheet material that above-mentioned homophase is pieced together, add the utilization factor of placing this out-phase plate of blanket broadside on the former surplus size in the long limit of sheet material in this size.
At cell CW62, CW63, CW64, CW65, CW66 imports respectively and imports its corresponding Excel intrinsic function formula CW62=(AU67*AV67*CM62*CR62)/(CJ62*CK62) respectively, CW63=(AU67*AV67* ((CM62-IF (CM63=0,0,1)) * CR62+CM63*CY62))/(CJ62*CK62), CW64=(AU67*AV67* (CM62*CR62+CR64*DB62))/(CJ62*CK62), CW65=(AU67*AV67* ((CM62-2*IF (CM62＞2,1,0)) * CR62+CM65*CY62))/(CJ62*CK62), CW66=(AU67*AV67* ((CR62-IF (CR62＞1,1,0)) * CM62+CR66*DB62))/(CJ62*CK62).
I. letter " the L of the number of the broadside of the blanket of on the broadside of cell CX61 input expression sheet material, placing A"; At cell CM61 input alphabet " N3 ".
The formula of the number (containing fraction part) of the broadside of the blanket that should be able to place on the long limit of cell CX62 input calculating sheet material, general formula is L A=(L-k * 2+j)/(A+j), its Excel intrinsic function formula CX62=(CK62-2*$E$10+$D$10)/(AU67+$D$10); The formula of the number (integral part) of the broadside of the blanket that on the long limit of cell CM62 input calculating sheet material, should be able to place, its Excel intrinsic function formula CY62=INT (CX62).
Carrying out the out-phase jigsaw at cell CX63 judges, the number of the broadside of the blanket that should be able to place on the long limit of sheet material is removed one, can the size of this blanket hem width add the long limit that put next blanket behind the original remaining hem width, be that can CX 62 fraction parts add the long limit that put next blanket after the size of a blanket hem width, input energy name realizes the Excel intrinsic function formula CX63=(CK62-INT (CX62)+1*IF (CY62＞1 of above-mentioned functions, 1,0)) * (AU67+$D$10)/(AV67+$D$10) is at cell CY63 input Excel intrinsic function formula CM63=CX64*CY64.
If the result of above-mentioned judgement is the long limit that can put down blanket, then the number on the long limit of the blanket that can put down is placed on cell CX64, input can realize the Excel intrinsic function formula CX64=INT (CX63) of above-mentioned functions; At the public CY64=IF (CY62＞1,1,0) of cell CM64 input Excel intrinsic function.
Carrying out the out-phase jigsaw at cell CX65 judges, the number of the broadside of the blanket that should be able to place on the long limit of sheet material is removed two, the size of these two blanket hem widths adds the long limit that can put down several blankets behind the original remaining hem width, be that the CX62 fraction part adds the long limit that can put down several blankets after the size of two blanket hem widths, input energy name realizes the Excel intrinsic function formula CX65=(CX62-INT (CX62)+2*IF (CY62＞2 of above-mentioned functions, 1,0)) * (AU67+$D$10)/(AV67+$D$10); At cell CY65 input Excel intrinsic function formula CY65=CX66*CY66.
If the result of above-mentioned judgement is the long limit that can put down blanket, then the number on the long limit of the blanket that can put down is placed on cell CX66, input can realize the Excel intrinsic function formula CX66=INT (CX65) of above-mentioned functions; At cell CY66 input Excel intrinsic function formula CY66=IF (CY62＞2,1,0).
J. letter " the W of the number on the long limit of the blanket of on the broadside of cell DA61 input expression sheet material, placing B"; At cell DB61 input alphabet " N4 ".
The formula of the number (containing fraction part) on the long limit of the blanket that should be able to place on the broadside of cell DA62 input calculating sheet material, general formula is W B=(W-k * 2+j)/(B+j), its Excel intrinsic function formula DA62=(CJ62-2*$E$10+$D$10)/(AV67+$D$10); The formula of the number (integral part) on the long limit of the blanket that on the broadside of cell DB62 input calculating sheet material, should be able to place, its Excel intrinsic function formula DB62=INT (DA62).
Carrying out the out-phase jigsaw at cell DA64 judges, can remaining length put down the broadside number (containing fraction part) of blanket on the broadside of sheet material, be the broadside that can put down blanket after the size of DA62 fraction part, input can name realize that the Excel intrinsic function formula of above-mentioned functions is at cell DA63 input Excel intrinsic function formula DA64=(DA62-INT (DA62)) * (AV67+$D$10)/(AU67+$D$10); Can remaining length put down the broadside number (integral part) of blanket on the broadside of cell DB64 placement sheet material, can realize the Excel intrinsic function formula DB64=INT (DA64) of above-mentioned functions in cell CR64 input.
At the Excel intrinsic function formula DA65=INT (DA66) of cell DA65 input to the DA66 round numbers.At cell DB66 input Excel intrinsic function formula DB65=IF (DB62＞1,1,0).
Carrying out the out-phase jigsaw at cell DA66 judges, the number on the long limit of the blanket that should be able to place on the broadside of sheet material is removed one, the size on the long limit of this blanket adds the long limit that can put down several blankets after the size of original remaining long limit, be that can the DA62 fraction part add the broadside that put several blankets after the size on the long limit of blanket, input energy name realizes the Excel intrinsic function formula DA66=(DA62-INT (DA62)+1*IF (DB62＞1 of above-mentioned functions, 1,0)) * (AV67+$D$10)/(AU67+$D$10); At cell DB66 input Excel intrinsic function formula DB66=DA65*DB65.
K. on the broadside of cell DC61 input expression sheet material " the broadside residue " of surplus size; Place surplus size on the broadside of scheme of homophase jigsaw at cell DC62～DC66, cell DC62～DC66 import respectively its corresponding Excel intrinsic function formula DC62=(CJ62-AV67*DB62-$D$10* (DB62-1))/2,
DC63＝IF(CY63＞0，IF(DC62＜CP62，DC62，CP62)，DC62)、
DC64＝(CJ62-AV67*DB62-AU67*DB64-$D$10*(DB62-1+DB64))/2、
DC65＝IF(CY65＞0，IF(DC62＜CP62，DC62，CP62)，DC62)、
DC66＝(CJ62-AV67*(DB62-1)-AU67*DB66-$D$10*(DB62-1-1+DB66))/2。
L. on the broadside of cell CZ61 input expression sheet material " the long limit residue " of surplus size; Place surplus size on the broadside of scheme of homophase jigsaw at cell CZ62～CZ66, cell CZ62～CZ66 import respectively its corresponding Excel intrinsic function formula CZ62=(CK62-AU67*CY62-$D$10* (CY62-1)/2,
CZ63＝(CK62-AU67*(CY62-IF(CY63＝0，0，1))-AV67*CY63-$D$10*(CY62-1-IF(CY63＝0，0，1)+CY63))/2、
CZ64＝IF(DB64＞0，IF(CZ62＜CT62，CZ62，CT62)，CZ62)、
CZ65＝(CK62-AU67*(CY62-2*IF(CY65＝0，0，1))-AV67*CY65-$D$10*(CY62-1-2*IF(CY65＝0，0，1)+CY65))/2。
CZ66＝IF(DB66＞0，IF(CZ62＜CT62，CZ62，CT62)，CZ62)。
M. represent the broadside of placement blanket on the long limit of sheet material and put " utilization factor 2 " of utilization factor of homophase jigsaw on the long limit of blanket on the broadside at cell DE61 input GEFI.Place the broadside of blanket on the long limit of input slab respectively and put the utilization factor of homophase jigsaw on the long limit of blanket on the broadside at cell DE62～DE66, and on the basis that this homophase is pieced together mutually the utilization factor of 4 kinds of out-phase jigsaw, be after removing the broadside size of a blanket on the long limit of sheet material pieced together of above-mentioned homophase, to add the former surplus utilization factor of making to place on the size this out-phase plate in the long limit of blanket in the long limit of sheet material in this size; The surplus utilization factor of making to place on the size this out-phase plate of blanket broadside on the sheet material broadside that above-mentioned homophase is pieced together; After removing the broadside size of two blankets on the long limit of the sheet material that above-mentioned homophase is pieced together, add the former surplus utilization factor of making to place on the size this out-phase plate in the long limit of blanket in the long limit of sheet material in this size; After removing the long limit size of a blanket on the sheet material broadside that above-mentioned homophase is pieced together, add the former surplus utilization factor of making to place on the size this out-phase plate of blanket broadside of sheet material broadside in this size.At cell CW62, CW63, CW64, CW65, CW66 imports its corresponding Excel intrinsic function formula CW62=(AU67*AV67*CY62*DB62)/(CJ62*CK62) respectively, CW63=(AU67*AV67* ((CY62-1*IF (CY63=0,0,1)) * DB62+CY63*CM62))/(CJ62*CK62), CW64=(AU67*AV67* (DB62*CY62+DB64*CR62))/(CJ62*CK62), CW65=(AU67*AV67* ((CY62-IF (CM65=0,0,2)) * DB62+CY65*CM62))/(CJ62*CK62), CW66=(AU67*AV67* ((DB62-1*IF (DB62＞1,1,0)) * CY62+DB66*CR62))/(CJ62*CK62).
N. relatively being placed on two class utilization factors of CW row and DE row, which is big cell DD61 input " utilization factor relatively "? import DD62=IF (CW62＞DE62,0 respectively at cell DD62, DD63, DD64, DD65, DD66,1), DD63=IF (CW63＞DE63,0,1), DD64=IF (CW64＞DE64,0,1), DD65=IF (CW65＞DE65,0,1), DD66=IF (CW66＞DE66,0,1).
O. in cell DI61 input " utilization factor ", select bigger utilization factor to be placed on and be not placed on cell DI62～DI66, import Excel intrinsic function formula DI62=IF (CW62＞DE62 respectively at cell DI62～DI66, CW62, DE62), DI63=IF (CW63＞DE63, CW63, DE63), DI64=IF (CW64＞DE64, CW64, DE64), DI65=IF (CW65＞DE65, CW65, DE65), DI66=IF (CW66＞DE66, CW66, DE66).
That p. selects the utilization factor maximum in the DI62:DI66 of unit area is placed on cell DJ67, at cell DJ67 input Excel intrinsic function formula DJ=LARGE (DI62:DI66,1)
In the cell of above-mentioned steps, CL62, CQ62, CW62 are used for finishing a step that claim 1 is created jigsaw computing zone; CL62, CQ62, CW62 are used for finishing a step that claim 1 is created jigsaw computing zone; CL63, CW63 are used for finishing the b step that claim 1 is created jigsaw computing zone; CL65, CW65 are used for finishing the c step that claim 1 is created jigsaw computing zone; CL64, CW64 are used for finishing the d step that claim 1 is created jigsaw computing zone; CL66, CW66 are used for finishing the e step that claim 1 is created jigsaw computing zone; CX62, DA62, DE62 are used for finishing the j step that claim 1 is created jigsaw computing zone; CX63, DE63 are used for finishing the g step that claim 1 is created jigsaw computing zone; CX63, DE63 are used for finishing the g step that claim 1 is created jigsaw computing zone; CX65, DE65 are used for finishing the h step that claim 1 is created jigsaw computing zone; DA64, DE64 are used for finishing the i step that claim 1 is created jigsaw computing zone; DA66, DE66 are used for finishing the j step that claim 1 is created jigsaw computing zone; DJ67 is used for finishing the k step that claim 1 is created jigsaw computing zone.
6, create indirect output area
Because worksheet sheet2 is too big, it is not too convenient to watch, and can create a middle worksheet at worksheet sheet2 left,, whole parameters same, different jigsaw of worksheet sheet2 are referred to middle worksheet.
A, at cell BB61, BE61, BF61, input is " sheet material utilization factor ", " a sheet material width ", " sheet material length " respectively.
B, at cell BB67, BE67, BF67, respectively input can realize from the big table of sheet2, quoting with out-phase jigsaw relevant parameter Excel intrinsic function formula BB67=INDEX (CG62:CG66, MATCH (CD67, DI62:DI66)), BE67=INDEX (CJ62:CJ66, MATCH (CD67, DI62:DI66)), BF67=INDEX (CK62:CK66, MATCH (CD67, DI62:DI66)).
C, at cell BG61, BH61, BK61～BM61, BO61, BP61, BR61, respectively the input " W A", " N1 ", " sheet material broadside residue width 1 ", " L B", " N2 ", " sheet material long limit residue width 2 ", " utilization factor relatively 1 ", " sheet material utilization factor 1 ".
At cell BG61, BH61, BK61～BM61, BO61, BP61, BR61, input can realize quoting from the big table of sheet2 together respectively, different jigsaw relevant parameter Excel intrinsic function formula BG67=INDEX (CL62:CL66, MATCH (CD67, DI62:DI66)), BH67=INDEX (CM62:CM66, MATCH (CD67, DI62:DI66)), BK67=INDEX (CP62:CP66, MATCH (CD67, DI62:DI66)), BL67=INDEX (CQ62:CQ66, MATCH (CD67, DI62:DI66)), BM67=INDEX (CR62:CR66, MATCH (CD67, DI62:DI66)), BO67=INDEX (CT62:CT66, MATCH (CD67, DI62:DI66)), BP67=INDEX (CU62:CU66, MATCH (CD67, DI62:DI66)), BR67=INDEX (CW62:CW66, MATCH (CD67, DI62:DI66)).
D, at cell BS61～BZ61, CD61, respectively the input " L A", " N3 ", " sheet material long limit residue width 2 ", " W B", " N4 ", " sheet material long limit residue width 2 ", " utilization factor relatively 2 ", " sheet material utilization factor 2 ", " the sheet material utilization factor after the ordering ".
At cell BG61, BH61, BK61～BR61, input can realize quoting from the big table of sheet2 together respectively, different jigsaw relevant parameter Excel intrinsic function formula BS67=INDEX (CX62:CX62, MATCH (CD67, DI62:DI66)), BT67=INDEX (CY62:CY62, MATCH (CD67, DI62:DI66)), BU67=INDEX (CZ62:CZ62, MATCH (CD67, DI62:DI66)), BV67=INDEX (DA62:DA66, MATCH (CD67, DI62:DI66)), BW67=INDEX (DB62:DB66, MATCH (CD67, DI62:DI66)), BX67=INDEX (DC62:DC66, MATCH (CD67, DI62:DI66)), BY67=INDEX (DD62:DD66, MATCH (CD67, DI62:DI66)), BZ67=INDEX (DE62:DE66, MATCH (CD67, DI62:DI66)).
7, create concentrated output area
Because worksheet sheet2 is too big, it is not too convenient to watch, and can create an output services table above worksheet sheet2, and the output data in the worksheet sheet2 is concentrated in this table, and exporting the result like this can come into plain view.The creation method of this output services table is as follows:
A, with eighth row as gauge outfit.
B, at cell R8 input " digital number ", import natural number 1,2,3 respectively at cell region R 9:R53 ... 45.
C, at cell S8 input " sheet material utilization factor ", the i.e. ratio of the summation of all production board areas and sheet material area on the sheet material; Import the Excel intrinsic function formula S 9=LARGE ($V$62:$V$3000 that can realize quoting the big table corresponding data function at cell S9, R9) from sheet2; Import the Excel intrinsic function formula S 10=LARGE ($V$62:$V$3000 that can realize quoting the big table corresponding data function at cell S10, R10) from sheet2; Selected then unit area S9:S10 points to this regional lower right corner with mouse pointer, drags and fills handle to S53, and the computing formula of S11～S53 correspondence is just filled automatically like this.
D, cell T8 input " blanket is long "; Import the Excel intrinsic function formula T9=INDEX ($AW$62:$AW$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell T9) from sheet2; Import the Excel intrinsic function formula T10=INDEX ($AW$62:$AW$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell T10) from sheet2; Selected then unit area T9:T10 points to this regional lower right corner with mouse pointer, drags and fills handle to T53, and the computing formula of T11～53 correspondences is just filled automatically like this.
In cell U8 input " blanket is wide "; Import the Excel intrinsic function formula U9=INDEX ($AX$62:$AX$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell U9) from sheet2; Import the Excel intrinsic function formula U10=INDEX ($AX$62:$AX$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell U10) from sheet2; Selected then unit area U9:U10 points to this regional lower right corner with mouse pointer, drags and fills handle to U53, and the computing formula of U11～U53 correspondence is just filled automatically like this.
E, at cell V8 input " blanket utilization factor ", the i.e. ratio of the summation of all production board areas and blanket area on the blanket; Import the Excel intrinsic function formula V9=INDEX ($AY$62:$AY$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell V9) from sheet2; Import the Excel intrinsic function formula V10=INDEX ($AY$62:$AY$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell V10) from sheet2; Selected then unit area S9:S10 points to this regional lower right corner with mouse pointer, drags and fills handle to S53, and the computing formula of S11～S53 correspondence is just filled automatically like this.
F, in cell W8 input " jigsaw numbering "; Import the Excel intrinsic function formula W 9=INDEX ($AP$62:$AP$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell W9) from sheet2; Import the Excel intrinsic function formula W 10=INDEX ($AP$62:$AP$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell W10) from sheet2; Selected then unit area W9:W10 points to this regional lower right corner with mouse pointer, drags and fills handle to W53, and the computing formula of W11～W53 correspondence is just filled automatically like this.
G, import the number w of the broadside of the production board of expression on a certain blanket broadside respectively at cell X8, Y8, Z8, AA8 a, the production board on the long limit of a certain blanket of expression the number l on long limit b, the production board of expression on a certain storehouse plate broadside the number w on long limit b, the production board on the long limit of a certain blanket of expression the number l of broadside aImport the Excel intrinsic function formula X9=INDEX ($AQ$62:$AQ$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell X9) from sheet2; Import the Excel intrinsic function formula X10=INDEX ($AQ$62:$AQ$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell X10) from sheet2; Selected then unit area X9:X10 points to this regional lower right corner with mouse pointer, drags and fills handle to X53, and the computing formula of X11～X53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula Y9=INDEX ($AR$62:$AR$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell Y9) from sheet2; Import the Excel intrinsic function formula Y10=INDEX ($AR$62:$AR$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell Y10) from sheet2; Selected then unit area Y9:Y10 points to this regional lower right corner with mouse pointer, drags and fills handle to Y53, and the computing formula of Y11～Y53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula Z9=INDEX ($AS$62:$AS$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell Z9) from sheet2; Import the Excel intrinsic function formula Z10=INDEX ($AS$62:$AS$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell Z10) from sheet2; Selected then unit area Z9:Z10 points to this regional lower right corner with mouse pointer, drags and fills handle to Z53, and the computing formula of Z11～Z53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula AA9=INDEX ($AT$62:$AT$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AA9) from sheet2; Import the Excel intrinsic function formula AA10=INDEX ($AT$62:$AT$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AA10) from sheet2; Selected then unit area AA9:AA10 points to this regional lower right corner with mouse pointer, drags and fills handle to A53, and the computing formula of AA11～AA53 correspondence is just filled automatically like this.
H, " open the material utilization factor ", i.e. the ratio of the summation of all blanket areas and sheet material area on the sheet material in cell AB8 input; Import the Excel intrinsic function formula AB9=INDEX ($X$62:$X$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AB9) from sheet2; Import the Excel intrinsic function formula AB10=INDEX ($X$62:$X$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AB10) from sheet2; Selected then unit area AB9:AB10 points to this regional lower right corner with mouse pointer, drags and fills handle to AB53, and the computing formula of AB11～AB53 correspondence is just filled automatically like this.
I, in cell AC8 input " the long limit of sheet material residue "; Import the Excel intrinsic function formula AC9=INDEX ($Y$62:$Y$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AC9) from sheet2; Import the Excel intrinsic function formula AC10=INDEX ($Y$62:$Y$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AC10) from sheet2; Selected then unit area AC9:AC10 points to this regional lower right corner with mouse pointer, drags and fills handle to AC53, and the computing formula of AC11～AC53 correspondence is just filled automatically like this.
In cell AD8 input " sheet material broadside residue "; Import the Excel intrinsic function formula AD9=INDEX ($Z$62:$Z$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AD9 from sheet2; Import the Excel intrinsic function formula AD10=INDEX ($Z$62:$Z$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AD10) from sheet2; Selected then unit area AD9:AD10 points to this regional lower right corner with mouse pointer, drags and fills handle to AD53, and the computing formula of AD11～AD53 correspondence is just filled automatically like this.
J, cell AE8 input " plate is long "; Import the Excel intrinsic function formula AE9=INDEX ($AA$62:$AA$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AE9) from sheet2; Import the Excel intrinsic function formula AE10=INDEX ($AA$62:$AA$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AE10) from sheet2; Selected then unit area AE9:AE10 points to this regional lower right corner with mouse pointer, drags and fills handle to AE53, and the computing formula of AE11～AE53 correspondence is just filled automatically like this.
Cell AF8 input " plate is long "; Import the Excel intrinsic function formula AF9=INDEX ($AB$62:$AB$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AF9) from sheet2; Import the Excel intrinsic function formula AF10=INDEX ($AB$62:$AB$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AF10) from sheet2; Selected then unit area AF9:AF10 points to this regional lower right corner with mouse pointer, drags and fills handle to AF53, and the computing formula of AF11～AF53 correspondence is just filled automatically like this.
K, import the number W of the broadside of the blanket of expression on a certain storehouse plate broadside respectively at cell AG8, AH8, AI8, AJ8 A, the blanket on the long limit of a certain storehouse plate of expression the number L on long limit B, the blanket of expression on a certain storehouse plate broadside the number W on long limit B, the blanket on the long limit of a certain storehouse plate of expression the number L of broadside AImport the Excel intrinsic function formula AG9=INDEX ($AF$62:$AF$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AG9) from sheet2; Import the Excel intrinsic function formula AG10=INDEX ($AF$62:$AF$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AG10) from sheet2; Selected then unit area AG9:AG10 points to this regional lower right corner with mouse pointer, drags and fills handle to AG53, and the computing formula of AG11～AG53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula AH9=INDEX ($AG$62:$AG$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AH9) from sheet2; Import the Excel intrinsic function formula AH10=INDEX ($AG$62:$AG$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AH10) from sheet2; Selected then unit area AH9:AH10 points to this regional lower right corner with mouse pointer, drags and fills handle to AH53, and the computing formula of AH11～AH53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula AI9=INDEX ($AH$62:$AH$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AI9) from sheet2; Import the Excel intrinsic function formula AI10=INDEX ($AH$62:$AH$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AI10) from sheet2; Selected then unit area AI9:AI11 points to this regional lower right corner with mouse pointer, drags and fills handle to AI53, and the computing formula of AI11～AI53 correspondence is just filled automatically like this.
Import the Excel intrinsic function formula AJ9=INDEX ($AI$62:$AI$3000 that can realize quoting the big table corresponding data function, MATCH (S9 ， $W$62:$W$3000) at cell AJ9) from sheet2; Import the Excel intrinsic function formula AJ10=INDEX ($AI$62:$AI$3000 that can realize quoting the big table corresponding data function, MATCH (S10 ， $W$62:$W$3000) at cell AJ10) from sheet2; Selected then unit area AJ9:AJ10 points to this regional lower right corner with mouse pointer, drags and fills handle to AJ53, and the computing formula of AJ11～AJ53 correspondence is just filled automatically like this.
Production board jigsaw worksheet and blanket jigsaw worksheet have just been built up like this, if desired, can also add the form line to worksheet by method of the prior art.During each later on the use, only need to import relevant size respectively at first lattice of relative dimensions.The using method of production board jigsaw worksheet and blanket jigsaw worksheet is as follows:
(1) imports the length and width size of production board respectively at production board length cell lattice A10, production board width cell B10;
(2) at interval cell A12, production board jigsaw hem width cell B12 import processing technology respectively and require production board jigsaw interval, the production board jigsaw hem width size reserved at the production board jigsaw;
(3) in sheet material length cell lattice CJ59, the sheet material width cell CJ58 length and width size of input slab respectively;
(4) import processing technology respectively at bad plate jigsaw spacing cell CK59, blanket jigsaw hem width cell CK58 and require the bad plate jigsaw interval of reserving, bad plate jigsaw hem width size;
(5) click the load button √ in the Excel formula bar or build, show the formula operation result in each cell by Enter.

Claims (2)

1. the board joint method of a printed circuit board (PCB) comprises Excel program creation production board jigsaw worksheet and the method for blanket jigsaw worksheet and the using method of above-mentioned worksheet of application memory in known computer;
Production board jigsaw worksheet is used to finish production board and carries out process with the out-phase jigsaw on blanket, each column unit lattice of production board jigsaw worksheet are used to place the data of same classification of different blanket jigsaw schemes or the Excel intrinsic function computing formula of these data, each row cell is used to place the different classes of data of same jigsaw scheme or the Excel intrinsic function computing formula of these data, and the concrete grammar of creating production board jigsaw worksheet is:
(1) starts the Excel program that is stored in the known computer, a newly-built workbook, selected worksheet;
(2) title of a cell input service table in the usefulness table;
(3), import the item name of the data of its column at each cell with the gauge outfit of delegation's cell in showing as worksheet;
(4) create the data input area:
Column unit lattice in a, the usefulness table are placed digital number, import the natural number digital number in the cell from top to bottom respectively; Place the blanket numbering with the column unit lattice in the table, difference input alphabet sequence number in cell from top to bottom;
Two cells in b, the usefulness table are respectively as production board length cell lattice and production board length cell lattice; Piece together spacing cell and production board jigsaw hem width degree cell as production board respectively with two cells in the table;
C, place production board quantity with the column unit lattice in the table, each production board is pieced together scheme and is made up of several production boards, just imports several at its corresponding cell;
D, place the blanket structural code of various blanket jigsaw schemes with four column unit lattice in the table, in four cells of each row, import a kind of four part bit digital of blanket structural code of blanket jigsaw scheme respectively, promptly piece together assembly on the broadside of the number of piecing together the long limit that production board is arranged on long limit number, blanket of the broadside that production board is arranged, blanket on the broadside of blanket and have the number that assembly on the long limit of the number on long limit of production board and blanket has the broadside of production board;
, at first import the jigsaw structural code by 1 block of bad plate that production board is combined into from top to bottom, secondly import all possible jigsaw structural code that is combined into by 2 production boards, the jigsaw structural code of each permutation and combination takies delegation; Import all possible jigsaw structural code that is combined into by 3 production boards again, the jigsaw structural code of each permutation and combination takies delegation; By that analogy, until might permutation and combination the jigsaw structural code all import; The jigsaw structural code of the possible permutation and combination quantity of the blanket that is combined into by n piece production board and the jigsaw scheme of each permutation and combination thereof conforms to following equation and determines:
w a×l b+w b×l a＝n(w a≠0，l b≠0)
The group number of equational integer solution is exactly the quantity of possible permutation and combination; Press w for every group a, l b, w b, l aTactic integer solution is exactly a kind of jigsaw structural code of jigsaw scheme;
(5) create the data operation zone
A, with the column unit lattice data of placing each blanket width in the table, the universal calculation equation of blanket width is w=a * w a+ j * (w a-1)+b * w b+ j * w b+ k * 2, concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
Place the data of each blanket length with the column unit lattice in the table, the universal calculation equation of blanket length is l=b * l b+ j * (l b-1)+a * l a+ j * l a+ k * 2, concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
B, place the blanket width with the column unit lattice in the table and deduct the later width dimensional data of hem width, universal calculation equation is w 0=w-2 * k, input method is as follows: concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
Place blanket length with the column unit lattice in the table and deduct the later length dimension data of hem width, universal calculation equation is l 0=l-2 * k, input method is as follows: concrete grammar be each cell import respectively that it answers be converted to the Excel intrinsic function by above-mentioned general formula after formula;
The width of c, the blanket that may occur permutation and combination is done a conversion greater than the situation of length, the wide length that is converted to of blanket, the length of blanket is converted to wide, also will carries out the conversion of jigsaw structure simultaneously, the length of blanket and the method for wide conversion are: utilize Excel internal logic function from w 0And l 0Select the length B of big value in two values, select the width A of little value as the blanket after changing as the blanket after changing;
With width and the length that two column unit lattice in the table are placed the blanket after the conversion respectively, utilize Excel internal logic function to judge, concrete grammar is a formula after each cell is imported its Excel internal logic function of answering respectively;
The width of the blanket that may occur permutation and combination is done a conversion greater than the situation of length, carries out the conversion of jigsaw structure, and the conversion method of jigsaw structure is: if l＞w then w aAnd l aNumerical value constant, if l ≯ w then w aWith l aNumerical value exchange; If l＞w then l bAnd w bNumerical value constant, if l ≯ w then l bAnd w bNumerical value exchange;
Place four part numerals of the blanket structure after the conversion respectively with four column unit lattice in the table, utilize Excel internal logic function to judge, concrete grammar is a formula after each cell is imported its Excel internal logic function of answering respectively;
D, place the blanket utilization factor of the blanket scheme after the conversion, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with the column unit lattice in the table;
(6) create the data output area:
Column unit lattice in a, the usefulness table are placed the ordering sequence number of blanket utilization factor, import the natural number digital number in the cell from top to bottom respectively;
Column unit lattice in b, the usefulness table are placed the blanket utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 100 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the blanket utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
C, place the blanket numbering of 100 kinds of blanket jigsaw schemes after the ordering with the column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Column unit lattice in d, the usefulness table are placed the blanket length of 100 kinds of blanket jigsaw schemes after the conversion, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Place the blanket width of 100 kinds of blanket jigsaw schemes after changing with the column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
E, place the 4-digit number of the blanket structure of 100 kinds of blanket jigsaw schemes after the conversion respectively with four column unit lattice in the table, utilize Excel inside to see to look for and search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence with referencing function;
Blanket jigsaw worksheet is used to finish 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor, carries out the process with the out-phase jigsaw on the sheet material plate, and its creation method is as follows:
(1) with the Excel program in the above-mentioned known computer that has started, a newly-built workbook, selected worksheet;
(2) in title with a cell input service table in the table;
(3), import the item name of the data of its column at each cell with the gauge outfit of delegation in showing as worksheet;
(4) create the data referencing zone
Utilize Excel internal searching and referencing function, quote in the production board jigsaw worksheet the total data of data output area, and be placed on this data referencing zone;
(5) create jigsaw computing zone:
Jigsaw computing zone is made up of 100 identical jigsaw unskilled labourer tabulations, and 100 little worksheets of identical jigsaw are respectively applied for 100 kinds of the highest blanket jigsaw schemes of blanket utilization factor are carried out jigsaw on sheet material the process of finishing; With two cells respectively as sheet material width cell and sheet material length cell lattice; With two cells respectively as bad plate jigsaw spacing cell and bad plate jigsaw hem width cell; The creation method of 100 little worksheets of jigsaw is identical, and the creation method of the little worksheet of one of them jigsaw is:
A, finish the homophase jigsaw process of on the broadside of placing blanket on the broadside of sheet material, long limit, placing the long limit of blanket, the W of the number of the blanket broadside that in a cell, can place on the broadside of placement sheet material at sheet material with two cells in the table A, W ABe general formula W A is little=(integral part of numerical value of W-k * 2+j)/(w+j) is placed the number L that the blanket that can place on the long limit of calculating sheet material is grown the limit in another cell B, L BBe general formula L B is little=(integral part of numerical value of L-k * 2+j)/(l+j), concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this homophase jigsaw, general formula is (w * l) * (W A* L B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
B, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned a step, after the broadside number of placing blanket on the broadside of sheet material subtracted one, the long limit that can the surplus size when this blanket width adds former homophase jigsaw on the sheet material broadside put next blanket, i.e. general formula (W A is little-W A+ 1) * and whether the numerical value of w/l is greater than 1, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((W A-1) * L B+ 1 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
C, finish another out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned a step, after the broadside number of placing blanket on the broadside of sheet material subtracted two, the long limit that can the surplus size when these two blanket width add former homophase jigsaw on the sheet material broadside put down two blankets, i.e. general formula (W A is little-W A+ 2) * and whether the numerical value of w/l is greater than 2, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((W A-2) * L B+ 2 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
D, finish out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned a step, the integer number of the broadside of the blanket that the surplus size during former homophase jigsaw on the long limit of sheet material can be put down, i.e. general formula (L A is little-L AThe integral part of) * l/w, concrete grammar are to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W A* L B+ X * W B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and X is (L in the formula A is little-L AThe integral part of) * l/w;
E, finish another out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned a step, after the long limit number of placing blanket on the long limit of sheet material subtracted one, surplus size when this blanket length adds former homophase jigsaw on the long limit of sheet material can be put down the number of the broadside of blanket, i.e. general formula (L A is little-L A+ 1) * and the integral part of l/w, concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W A* (L B-1)+Y * W B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and Y is (L in the formula A is little-L A+ 1) * the l/w integral part;
F, finish the homophase jigsaw process of on the long limit of placing blanket on the broadside of sheet material, long limit, placing the broadside of blanket, the number on the blanket length limit that in a cell, can place on the broadside of placement sheet material at sheet material with two cells in the table B, W BBe general formula W BLittle=(integral part of numerical value of W-k * 2+j)/(l+j) is placed the number L of the blanket broadside that can place on the long limit of calculating sheet material in another cell A, L ABe general formula L A is little=(integral part of numerical value of L-k * 2+j)/(w+j), concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this homophase jigsaw, general formula is (w * l) * (W A* L B)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
G, finish out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned f step, after the broadside number of placing blanket on the long limit of sheet material subtracted one, the long limit that can the surplus size when this blanket width adds former homophase jigsaw on the long limit of sheet material put next blanket, i.e. general formula (L A is little-L A+ 1) * and whether the integral part of w/l numerical value is greater than 1, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((L A-1) * W B+ 1 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
H, finish another out-phase jigsaw on the long limit of sheet material with a cell, on the homophase jigsaw basis of above-mentioned f step, after the broadside number of placing blanket on the long limit of sheet material subtracted two, the long limit that can the surplus size when these two blanket width add former homophase jigsaw on the long limit of sheet material put down two blankets, i.e. general formula (L A is little-L A+ 2) * and whether the numerical value of w/l is greater than 2, and concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * ((L A-2) * W B+ 2 * L A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula;
I, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned f step, the integer number of the broadside of the blanket that the surplus size during former homophase jigsaw on the sheet material broadside can be put down, i.e. general formula (W B is little-W BThe integral part of) * l/w, concrete grammar are to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W B* L A+ M * W A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and M is (W in the formula B is little-W BThe integral part of) * l/w;
J, finish out-phase jigsaw on the sheet material broadside with a cell, on the homophase jigsaw basis of above-mentioned f step, after the number on the long limit of the blanket of placing on the sheet material broadside during former homophase jigsaw subtracts one, the size on this base length of side limit adds the integer number of the broadside of the blanket that the surplus size on the former sheet material broadside can be put down, i.e. general formula (W B is little-W B+ 1) * and the integral part of l/w numerical value, concrete grammar is to import the Excel intrinsic function formula that can realize above-mentioned functions respectively at two cells;
With the sheet material utilization factor that a cell is placed this out-phase jigsaw, general formula is (w * l) * (W B* L A+ N * W A)/(W * L), concrete grammar is the formula after this cell input is converted to the Excel intrinsic function by above-mentioned general formula, and N is (W in the formula B is little-W B+ 1) * the l/w integral part;
K, with the table in a cell place the numerical value of maximum sheet material utilization factor, utilize the statistical function of the inner maximizing of Excel, choose a sheet material utilization factor maximum from above-mentioned a to j, concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
(6) create indirect output area
Utilize Excel internal searching and referencing function, quote the total data in the jigsaw computing regional work table, and be placed on this indirect output area;
The using method of described production board jigsaw worksheet and blanket jigsaw worksheet is as follows:
(1) imports the length and width size of production board respectively at production board length cell lattice, production board width cell;
(2) at interval cell, production board jigsaw hem width cell are imported processing technology respectively and are required production board jigsaw interval, the production board jigsaw hem width size reserved at the production board jigsaw;
(3) in sheet material length cell lattice, the sheet material width cell length and width size of input slab respectively;
(4) import processing technology respectively at bad plate jigsaw spacing cell, blanket jigsaw hem width cell and require the bad plate jigsaw interval of reserving, bad plate jigsaw hem width size;
(5) click the load button √ in the Excel formula bar or build, show the formula operation result in each cell by Enter.
In the above-mentioned formula, a is the length of the broadside of production board, and b is the length on the long limit of production board, and j is the width at the interval between the adjacent production board; K is the width on the limit of the production board on blanket four limits to the limit of blanket; W is the length of the broadside before a certain blanket length and width conversion, and l is the length on the long limit before a certain blanket length and width conversion, w 0The length of changing preceding broadside for a certain blanket length and width deducts the later dimensional data of hem width, l 0The length of changing preceding long limit for a certain blanket length and width deducts the later dimensional data of hem width, and A is the length of the broadside after a certain blanket length and width conversion, and B is the length on the long limit after a certain blanket length and width conversion, w aFor the integer number of the broadside of the production board on a certain blanket broadside promptly has the plate of what production boards wide on the blanket broadside, l bThe integer number of growing the long limit of the production board on the limit for a certain blanket promptly has the plate of what production boards long on the long limit of blanket, w bFor the integer number on the long limit of the production board on a certain blanket broadside promptly has the plate of what production boards long on the blanket broadside, l aThe integer number of growing the broadside of the production board on the limit for a certain blanket promptly has the plate of what production boards wide on the long limit of blanket, and W is the length of the broadside of sheet material, and L is the length on the long limit of sheet material, W AFor the integer number of the broadside of the blanket on a certain sheet material broadside promptly has the plate of what blankets wide on the sheet material broadside, L BThe integer number of growing the long limit of the blanket on the limit for a certain sheet material promptly has the plate of what base utmost points long on the long limit of sheet material, W BFor the integer number on the long limit of the blanket on a certain sheet material broadside promptly has the plate of what blankets long on the sheet material broadside, L AThe integer number of growing the broadside of the blanket on the limit for a certain sheet material promptly has the plate of what base utmost points wide on the long limit of sheet material.
2. the board joint method of a kind of printed circuit board (PCB) according to claim 1 is characterized in that, the method for described establishment blanket jigsaw worksheet comprises that also following establishment concentrates the method for output area:
Delegation imports the item name of the data of its column as the gauge outfit of worksheet in a, the usefulness table at each cell;
Column unit lattice in b, the usefulness table are placed digital number, import natural number 1,2,3 to 45 in the cell from top to bottom respectively;
Column unit lattice in c, the usefulness table are placed the sheet material utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
D, place the blanket width and the length of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
Column unit lattice in e, the usefulness table are placed the blanket utilization factor of 45 kinds of sheet material jigsaw schemes after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
F, place the blanket numbering of the blanket jigsaw scheme of 45 kinds of sheet material jigsaw schemes after the ordering with the column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
G, place the 4-digit number of the jigsaw structural code of 45 kinds of sheet material jigsaw schemes after the ordering respectively with four column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
H, place with the column unit lattice in the table and to open the material utilization factor after the ordering, utilize the statistical function of the inner maximizing of Excel to finish the ordering from large to small of blanket utilization factor, and choose 45 kinds of blanket jigsaw schemes from large to small, and be placed into each cell from top to bottom respectively by the sheet material utilization factor; Concrete grammar is the Excel intrinsic function formula that can realize above-mentioned sort method of importing its correspondence at each cell;
I, place the long limit surplus size of sheet material and the sheet material broadside surplus size of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
J, to place the plate of 45 kinds of sheet material jigsaw schemes after the ordering respectively with two column unit lattice in the table long and plate is wide, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence;
K, place the 4-digit number of the blanket jigsaw structural code of 45 kinds of sheet material jigsaw schemes after the ordering respectively with four column unit lattice in the table, utilize Excel inside to see and look for referencing function advancing to search, can realize the above-mentioned Excel intrinsic function formula of searching with recited function what each cell was imported its correspondence.
CNB2004100186666A 2004-02-17 2004-02-17 Joining method for printed circuit board Expired - Fee Related CN100504884C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB2004100186666A CN100504884C (en) 2004-02-17 2004-02-17 Joining method for printed circuit board

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB2004100186666A CN100504884C (en) 2004-02-17 2004-02-17 Joining method for printed circuit board

Publications (2)

Publication Number Publication Date
CN1560779A true CN1560779A (en) 2005-01-05
CN100504884C CN100504884C (en) 2009-06-24

Family

ID=34440738

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2004100186666A Expired - Fee Related CN100504884C (en) 2004-02-17 2004-02-17 Joining method for printed circuit board

Country Status (1)

Country Link
CN (1) CN100504884C (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100449555C (en) * 2006-09-08 2009-01-07 华为技术有限公司 Implementing method for making up handset
CN100470558C (en) * 2007-06-27 2009-03-18 迈普（四川）通信技术有限公司 Board joint method of dual-side printed circuit board
US7891280B2 (en) 2007-04-02 2011-02-22 Innocom Technology (Shenzhen) Co., Ltd. Method for cutting PCB
CN104684275A (en) * 2013-12-03 2015-06-03 上海望友信息科技有限公司 PCB jointing method and system
CN105678408A (en) * 2015-12-30 2016-06-15 广州兴森快捷电路科技有限公司 Printed circuit board (PCB) combining and joining method and system
CN107920422A (en) * 2017-10-31 2018-04-17 惠州市金百泽电路科技有限公司 A kind of method that Automatic Optimal pcb board fixes production size

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100449555C (en) * 2006-09-08 2009-01-07 华为技术有限公司 Implementing method for making up handset
US7891280B2 (en) 2007-04-02 2011-02-22 Innocom Technology (Shenzhen) Co., Ltd. Method for cutting PCB
CN100470558C (en) * 2007-06-27 2009-03-18 迈普（四川）通信技术有限公司 Board joint method of dual-side printed circuit board
CN104684275A (en) * 2013-12-03 2015-06-03 上海望友信息科技有限公司 PCB jointing method and system
CN104684275B (en) * 2013-12-03 2018-09-14 上海望友信息科技有限公司 PCB board joint methods and system
CN105678408A (en) * 2015-12-30 2016-06-15 广州兴森快捷电路科技有限公司 Printed circuit board (PCB) combining and joining method and system
US10614386B2 (en) 2015-12-30 2020-04-07 Guangzhou Fastprint Circuit Tech Co., Ltd. PCB board assembling method and assembling system
CN107920422A (en) * 2017-10-31 2018-04-17 惠州市金百泽电路科技有限公司 A kind of method that Automatic Optimal pcb board fixes production size
CN107920422B (en) * 2017-10-31 2020-04-24 惠州市金百泽电路科技有限公司 Method for automatically optimizing fixed production size of PCB

Also Published As

Publication number Publication date
CN100504884C (en) 2009-06-24

Similar Documents

Publication Publication Date Title
CN1323789C (en) Welding assessment
CN1629871A (en) Workflow management apparatus and method
CN101079953A (en) Information processing system, information processing device, information processing method, and program
CN1365571A (en) Image synthesizing device, recording medium, and program
CN1816275A (en) Quality management system of print substrate
CN1187744A (en) Spread spectrum communication system
CN1526115A (en) Method and a system for reducing update frequency of image processing device
CN1460958A (en) Injection molding cost estimation system
CN1770864A (en) 4x4 discrete cosine transform rapid parallel device based on AVS and its method
CN1723453A (en) Method and system for processing a sound field representation
CN1765099A (en) Device and method for simulating communication system capable of easily controlling protocol message
CN1737747A (en) Information processing device
CN1560779A (en) Joining method for printed circuit board
CN1760869A (en) Information display control device, server and information display control method
CN1955956A (en) Method of graphic and XML file interexchange based on BPEL
CN1856801A (en) Method and system for differentially and regularly modifying a digital image by pixel
CN101055566A (en) Function collection method and device of electronic data table
CN1764928A (en) Multi-gradation monochromatic image display method, multi-gradation monochromatic image display device, computer, monochromatic display device, re-conversion adapter, and video card
CN1325058A (en) Image display device, image display method and recording medium
CN1101139A (en) Computer imput method of figure-sign coding
CN1723690A (en) Pixel interpolation circuit and pixel interpolation method, and image reader
CN1501718A (en) Image processing method, image processing apparatus and image processing program
CN1231440A (en) Data processing method, recording medium and dat aprocessor
CN1182246A (en) Learning methods in binary systems
CN1261862C (en) Input prediction processing method, device and program and the program recording medium

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
C17 Cessation of patent right
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20090624

Termination date: 20120217