Method for automatically counting number of grounded materials
By designing grounding wiring tables and BOM tables, the number of grounding materials is automatically counted using programs, which solves the problems of low efficiency and error-prone traditional manual statistics, and achieves efficient and accurate material quantity statistics.
Patent Information
- Application Number
- CN202510271414.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-03-08
- Publication Date
- 2025-06-24
AI Technical Summary
Traditional manual statistics on the quantity of grounding materials are inefficient and error-prone.
Provides an automatic statistics method for the quantity of grounding materials. Through the design of the grounding wiring table and BOM table, the program is used to automatically count the quantity of materials such as fasteners, wiring heads, heat shrink wire number labels.
Improve work efficiency and accuracy, reduce human errors, realize automated statistics, and simplify the process of material quantity summary.
Smart Images
Figure CN120197602A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the statistics of grounding materials for rail transit vehicles, and particularly to an automatic statistics method for the quantity of grounding materials. Background Art
[0002] When conducting grounding design, it is necessary to compile a grounding wiring table to record the grounding type of each device, the required grounding materials, etc.; after completing the grounding wiring table, it is necessary to summarize the quantity of each grounding material for compiling the BOM table. The traditional method for summarizing the quantity of materials is manual statistics, which has problems such as low efficiency and easy errors. Summary of the Invention
[0003] The present invention solves the problems of low efficiency and easy errors in manually counting the quantity of grounding materials by providing an automatic statistics method for the quantity of grounding materials.
[0004] The present invention is realized by the following technical solutions:
[0005] An automatic statistics method for the quantity of grounding materials, including a grounding wiring table and a BOM table;
[0006] In the grounding wiring table:
[0007] The serial number in column A, i.e., the serial number in the grounding wiring table;
[0008] The wire number in column B, i.e., the wire number of the grounding wire;
[0009] The point position 1 in column C, i.e., the point position of the connection point 1 of the grounding wire;
[0010] The point position 2 in column D, i.e., the point position of the connection point 2 of the grounding wire;
[0011] Column E is the quantity, i.e., the number of grounding wires;
[0012] The wire diameter in column F, i.e., the wire diameter of the grounding wire;
[0013] The wire length in column G, i.e., the wire length of the grounding wire;
[0014] The category number in column H, i.e., the number of the grounding wire in the construction drawing;
[0015] The connection bolt 1 in column I, i.e., the bolt specification used for the connection point 1 of the grounding wire;
[0016] The connection bolt 2 in column J, i.e., the bolt specification used for the connection point 2 of the grounding wire;
[0017] The connection head 1 in column K, i.e., the specification of the connection head 1 of the grounding wire. In the figure, the example is 5-16f, where 5 is the bolt specification and 16 is the connection head specification;
[0018] The connection head 2 in column L, i.e., the specification of the connection head 2 of the grounding wire;
[0019] The grounding type of the Mth column is type 1, that is, the grounding type of the grounding wire connection terminal 1. F means self - contained, and E means that fasteners need to be provided; a number is added after E to represent different grounding types, such as E1.0; the numbers in the brackets are the serial numbers of the fasteners. For example, (4.51.2.3) means that fasteners 1 to 5 are used.
[0020] The grounding type of the Nth column is type 2, that is, the grounding type of the grounding wire connection terminal 2.
[0021] In the BOM list:
[0022] The serial number in the Ath column. If the material is a fastener, its serial number is the serial number in the grounding wiring table; if the material is other materials, its serial number only represents the number.
[0023] The name in the Bth column is the material name.
[0024] The material code in the Cth column is the material code of the material.
[0025] The quantity in the Dth column. The unit of the grounding wire length is defaulted to meter, and the unit of other materials is defaulted to piece.
[0026] The double - click to clear in the Fth column means that after double - clicking, all contents except the first row are cleared.
[0027] The double - click to count in the Gth column means that after double - clicking, the material quantity is automatically counted.
[0028] The specific steps are as follows:
[0029] (1) Determine the effective number of rows of the grounding wiring table
[0030] Determine the total number of rows H1 of the grounding wiring table. To exclude blank rows, judge whether the Cth column of each row from the H1th row to the 2nd row is empty. If it is not empty, stop the loop, and the row number of this row is the total effective number of rows H2.
[0031] (2) Formatting
[0032] Set the table header of the grounding wiring table to be in the 4th row, and the row H3 below the table header is the 5th row. Select the area of the Oth column from the H3th row to the H2th row, and clear the spaces at both ends of each cell in this area.
[0033] (3) Count the number of fasteners
[0034] In the grounding type, F means self - contained and E means that fasteners need to be provided. Only count the fasteners in the grounding type E. The grounding information in the grounding wiring table starts from the H3th row and is counted from the H3th row.
[0035] A. For the M-th and N-th columns from the H3-th row to the H2-th row, determine whether the value of the cell contains E. If it does, proceed to step B; if not, stop the determination and move on to the next column.
[0036] B. The expression forms of the grounding type include E1.0, E 1.0, and E11. Obtain the length ls of the value of the cell. Starting from the second character, determine whether each character is a digit. If it is a digit, stop the determination and record the position k. If the (k + 1)-th character is ".", the starting position st of the fastener number is k + 4; if it is not ".", then st = k + 2.
[0037] C. For the cells in the M-th and N-th columns from the H3-th row to the H2-th row, starting from the st-th character to the ls-th character, sequentially determine whether each character is a digit. If the k1-th character is a digit, then starting from k + 1, sequentially determine whether each subsequent character is a digit. If the k2-th character is not a digit, stop the loop and read the characters between k1 and k2 - 1, which is the fastener number xh.
[0038] D. In the E-th column of each row of the grounding wiring table, the number of occurrences of the grounding type is recorded. For the fastener xh, the quantity in the xh-th row of the BOM table plus the quantity in the E-th column of the row where xh is located in the grounding wiring table updates the quantity of one fastener. Before updating the fastener quantity, clear the value in the column where the quantity is located.
[0039] (4) Count the quantities of the terminal connectors, ground wires, and heat shrink tube number labels
[0040] A. Write the terminal connector 1 in the K-th column, terminal connector 2 in the L-th column, and the quantity in the E-th column of the grounding wiring table into the BOM table in sequence.
[0041] B. Write the ground wire diameter in the F-th column and the wire length in the G-th column multiplied by the quantity in the E-th column into the BOM table in sequence.
[0042] C. Write the size of the wire number label of the heat shrink tube packaging the ground wire diameter specification in the F-th column and the quantity in the E-th column into the BOM table in sequence.
[0043] D. Mark the area of the terminal connectors, ground wires, and heat shrink tube number labels in the BOM from the x-th row to the y-th row, and sort this area by name.
[0044] E. For each row in the BOM from the x-th row to the y-th row, if the name of this row is the same as the previous row, add the quantity of this row to the quantity of the previous row.
[0045] F. For each row in the BOM from the y-th row to the x-th row, if the name of this row is the same as the previous row, delete the previous row.
[0046] G. Starting from the x-th row in the BOM, update the serial number of each row.
[0047] (5) Set the BOM form format to left alignment with a grid.
[0048] (6) For ease of operation, add a button. To prevent accidental touch, double-click the button to run the program. Finally, create a standard template file. When using it, fill in the information in the grounding wiring table, and double-click the button to generate the BOM form.
[0049] The present invention automatically counts the quantity of grounding materials through a program, including the quantity of fasteners, terminal heads, heat shrink tubing numbers, and the length of flexible copper stranded wires or cables. After completing the grounding wiring table in the template file, simply double-click the button to automatically count the grounding materials, improving work efficiency and accuracy. Description of the Drawings
[0050] Figure 1 It is a template file for the grounding wiring table, where:
[0051] The serial number in column A, which is the serial number in the grounding wiring table;
[0052] The wire number in column B, which is the wire number of the grounding wire;
[0053] The point 1 in column C (point 1), which is the point of the connection point 1 of the grounding wire;
[0054] The point 2 in column D, which is the point of the connection point 2 of the grounding wire;
[0055] The quantity in column E, which is the number of grounding wires;
[0056] The wire diameter (mm2) in column F, which is the wire diameter of the grounding wire;
[0057] The wire length (mm) in column G, which is the wire length of the grounding wire;
[0058] The category number in column H, which is the number of the grounding wire in the construction drawing;
[0059] The connecting bolt 1 in column I, which is the bolt specification used for the connection point 1 of the grounding wire;
[0060] The connecting bolt 2 in column J, which is the bolt specification used for the connection point 2 of the grounding wire;
[0061] The terminal head 1 in column K, which is the specification of the terminal head 1 of the grounding wire. Figure 1 Example 5-16f, 5 is the bolt specification and 16 is the terminal head specification;
[0062] The terminal head 1 in column L, which is the specification of the terminal head 1 of the grounding wire;
[0063] Column M (Grounding Type 1) Grounding Type 1, that is, the grounding type of the grounding wire connection head 1. F means self - contained, and E means that fasteners need to be provided; a number is added after E to represent different grounding types, such as E1.0; the number in the parentheses is the serial number of the fastener, such as (4.51.2.3) indicating that fasteners 1 - 5 are used.
[0064] Column N (Grounding Type 2) Grounding Type 1, that is, the grounding type of the grounding wire connection head 2;
[0065] Figure 2 This is the BOM table template file, where:
[0066] The serial number in Column A. If the material is a fastener, its serial number is the serial number in the grounding wiring table; if the material is other materials, its serial number only represents the number.
[0067] Column B Name, which is the material name;
[0068] Column C (Point 1) Material Code, which is the material code of the material;
[0069] Column D Quantity. The unit of the grounding wire length is defaulted to meters, and the unit of other materials is defaulted to pieces;
[0070] Column F Double - click to Clear, which means that after double - clicking, all contents except the first row are cleared;
[0071] Column G Double - click to Count, which means that after double - clicking, the material quantity is automatically counted;
[0072] Figure 3 This is the flowchart for counting grounding materials;
[0073] Figure 4 This is the flowchart for counting the number of fasteners;
[0074] Figure 5 This is the flowchart for counting the number of connection heads, ground wires, and heat - shrinkable wire number labels. Specific implementation mode
[0075] As Figures 1-5 shown, the present invention is an automatic counting method for the quantity of grounding materials, and the specific process is as follows:
[0076] (1) Determine the effective number of rows in the grounding wiring table
[0077] Determine the total number of rows H1 in the grounding wiring table. To exclude blank rows, it is judged whether the content in Column C (Point 1) of each row from the H1 - th row to the 2 - nd row is empty. If it is not an empty value, the loop stops, and the row number is the total effective number of rows H2.
[0078] (2) Format processing
[0079] Set the header of the grounding wiring table template file to be on the 4th line, and the line below the header, H3, is the 5th line.
[0080] Select the area from row H3 to row H2, column O, and clear the spaces at both ends of each cell in this area.
[0081] (3) Count the number of fasteners
[0082] In the grounding type, F is self - contained, and E requires fasteners to be provided. Only count the fasteners in the grounding type E. The grounding information in the grounding wiring table starts from row H3, and start counting from row H3.
[0083] A. For column M (grounding type 1) and column N (grounding type 2) from row H3 to row H2, determine whether the value of the cell contains E. If it does, go to step B; if not, stop the judgment and go to the next column.
[0084] B. The expression form of the grounding type may be E1.0, E 1.0, E11, etc. Get the length ls of the value of the cell. Starting from the second character, determine whether each character is a number. If it is a number, stop the judgment and record the position k. If the (k + 1)th character is a dot., then the starting position st of the fastener serial number is k + 4; if it is not a dot., then st = k + 2.
[0085] C. For the cells in column M (grounding type 1) and column N (grounding type 2) from row H3 to row H2, starting from the st - th character to the ls - th character, determine whether each character is a number in turn. If the k1 - th character is a number, then starting from k + 1, determine whether each character is a number in turn. If the k2 - th character is not a number, stop the loop and read the characters between k1 and k2 - 1, which is the fastener serial number xh.
[0086] D. The number in column E (quantity) of each row in the grounding wiring table is the number of occurrences of the grounding type. For the fastener xh, add the quantity in column E of the row where xh is located in the grounding wiring table to the quantity in the xh - th row of the BOM table, that is, update the quantity of a fastener. Before updating the fastener quantity, clear the value in the column where the quantity is located.
[0087] (4) Count the number of terminal connectors, ground wires, and heat - shrink wire number labels
[0088] A. Write the terminal connector 1 (column K), terminal connector 2 (column L), and quantity (column E) in the grounding wiring table into the BOM table in sequence.
[0089] B. Multiply the ground wire diameter (column F) and length (column G) by the quantity (column E) and write them into the BOM table in sequence.
[0090] C. Write the size (Column F) and quantity (Column E) of the heat-shrink wire number labels into the BOM table in sequence.
[0091] D. Mark the area from row x to row y in the BOM for the connection heads, ground wires, and heat-shrink wire number labels, and sort this area by name.
[0092] E. For each row from row x to row y in the BOM, if the name of this row is the same as that of the previous row, add the quantity of this row to the quantity of the previous row.
[0093] F. For each row from row y to row x in the BOM, if the name of this row is the same as that of the previous row, delete the previous row.
[0094] G. Update the serial number of each row starting from row x in the BOM.
[0095] (5) Set the BOM table format to left alignment with a grid.
[0096] (6) To facilitate operation, add a button. To prevent accidental touch, double-click the button to run the program. Finally, create a standard template file. When using it, fill in the information in the grounding wiring table, and double-click the button to generate the BOM table.
[0097] The overall flowchart is as Figure 3 shown.
Claims
1. A method for automatically counting the number of grounded materials, characterized by: Includes ground wiring table and BOM table; Ground wiring table: Column A serial number, which is the serial number in the ground wiring table; The line number in column B is the ground line number; Point 1 in column C is the point where the grounding wire is connected to point 1; Point 2 in column D is the point where the grounding wire is connected to point 2; Column E is the quantity, i.e. the number of grounding wires; The wire diameter in column F is the diameter of the ground wire; The length of the G column is the length of the ground line; The category number in column H is the number of the grounding wire in the construction drawing; Column I connection bolt 1, i.e. the bolt specification used at grounding wire connection point 1; Connection bolt 2 in column J, i.e. the bolt specification used at grounding wire connection point 2; The Kth column terminal 1, i.e. the specification of the grounding terminal 1, in the example 5-16f in the figure, 5 is the bolt specification, and 16 is the terminal specification; The Lth column terminal 2, i.e. the specification of the grounding terminal 2; The Mth column is grounding type 1, i.e. the grounding type of grounding terminal 1. F means self-contained and E means fasteners need to be provided. A number after E indicates different grounding types, such as E1.
0. The number in brackets is the serial number of the fastener, such as (4.51.2.3) indicates that fasteners 1 to 5 are used. The grounding type 2 in the Nth column is the grounding type of the grounding terminal 2; In the BOM table: The serial number in column A, if the material is a fastener, its serial number is the serial number in the ground wiring table; if the material is other materials, its serial number only indicates the number; The name in column B is the name of the material; Column C, material code, is the material code; For the quantity in column D, the default unit for ground wire length is meter, and the default unit for other materials is piece; The specific steps are: (1) Determine the number of valid rows in the ground wiring table Determine the total number of rows H1 in the ground wiring table. In order to exclude blank rows, determine whether the Cth column of each row from row H1 to row 2 is empty. If it is not empty, stop the loop, and the number of the row is the total number of valid rows H2; (2) Format processing Set the header of the ground wiring table to row 4, the row H3 below the header to row 5, select the area from row H3 to row H2, column O, and clear the spaces at both ends of each cell in the area; (3) Count the number of fasteners In the grounding type, F means self-provided and E means fasteners need to be provided. Only fasteners in grounding type E need to be counted. The grounding information in the grounding wiring table starts from row H3 and is counted from row H3. A. For the M and N columns of rows H3 to H2, determine whether the cell value contains E. If so, proceed to step B; if not, stop judging and proceed to the next column; B. The expressions of grounding types include E1.0, E 1.0, and E11. Get the length ls of the cell value, and start judging whether each character is a number from the second character. If it is a number, stop judging and record the position k; if the k+1th character is ".", the starting position of the fastener serial number st=k+4; if it is not ".", st=k+2; C. For the cells in the Mth column and the Nth column of the H3th row to the H2th row, determine whether each character is a number from the stth character to the lsth character. If the k1th character is a number, then determine whether each character is a number from k+1. If the k2th character is not a number, stop the loop and read the characters between k1 and k2-1, which is the fastener serial number xh. D. The Eth column of each row in the ground wiring table is the number of times the ground type appears. For fastener xh, the quantity in the xhth row of the BOM table plus the quantity in the Eth column of the row where xh is located in the ground wiring table, that is, the quantity of a fastener is updated. Before updating the fastener quantity, the value of the quantity column is cleared; (4) Count the number of terminal blocks, ground wires, and heat shrink wire labels A. Write the Kth column terminal 1, the Lth column terminal 2 and the Eth column quantity in the ground wiring table into the BOM table in sequence; B. Multiply the ground wire diameter in column F and the wire length in column G by the quantity in column E and write them into the BOM table in sequence; C. Write the size of the wire number label of the heat shrink wire with the ground wire diameter specification in column F and the quantity in column E into the BOM table in sequence; D. Note the area from row x to row y for the terminal, ground wire, and heat shrink wire number labels in the BOM, and sort the area by name; E. For each row from row x to row y in the BOM, if the row has the same name as the previous row, the quantity of the row is added to the quantity of the previous row; F. For each line from line y to line x in the BOM, if the name of the line is the same as the previous line, delete the previous line; G. Update the serial number of each row starting from row x in the BOM; (5) The BOM table format is set to left-aligned and grid; (6) To facilitate operation, add a button. To prevent accidental touch, double-click the button to run the program. Finally, make a standard template file. When using it, fill in the information in the ground wiring table. Double-click the button to generate the BOM table.
2. The method for automatically counting the number of grounded materials according to claim 1 is characterized by: The ground wiring table also has a column F that can be cleared by double-clicking, which means that all contents except the first row will be cleared after double-clicking.
3. The method for automatically counting the number of grounded materials according to claim 1 is characterized by: The ground wiring table also has a double-click statistics in column G, which means that the material quantity will be automatically counted after double-clicking.