Method for reducing the cost of pre-plugging connectors and system thereof

Abstract

The present application relates to the field of vehicle wiring harness, and particularly relates to a method and system for reducing the pre-plugging cost of connectors, a computer device for implementing the method and a computer readable storage medium. The method for reducing the pre-plugging cost of connectors according to one aspect of the present application comprises the following steps: determining the quantity of wiring harnesses and the numbers associated with the wiring harnesses, and performing coding combination on the numbers associated with the wiring harnesses; determining the common vacant hole positions in each combination, and determining the total cost of sealing plugs for the common vacant hole positions in each combination based on the determined quantity of wiring harnesses; and sorting the determined total cost of sealing plugs for the common vacant hole positions in each combination to generate a combination cost reduction table, so as to determine a pre-plugging hole position table.

Description

Technical Field

[0001] This invention relates to the field of vehicle wiring harnesses, and more particularly to a method, system, computer device, and computer-readable storage medium for reducing the cost of pre-plugging holes in connectors. Background Technology

[0002] With the current customer-oriented development of vehicles, designing vehicle configurations based on customer needs has become increasingly important, leading to a growing number of vehicle configurations. Simultaneously, with the increasing number of platform models, wiring harness configurations are also highly diverse. Therefore, connectors with the same function and part number may exhibit different internal hole configurations with varying wire loops during actual use.

[0003] In automotive wiring harness sealing connectors, when wires are present in the holes, the wire terminals need to be sealed. When the hole positions are controlled, sealing plugs are required to achieve a seal. Additionally, if the vacant holes are known in advance, they can be pre-sealed during connector manufacturing.

[0004] Calculations based on connector raw materials and manufacturing processes reveal that, when the number of pre-plugged holes is large, the production cost is significantly lower than installing sealing plugs. Therefore, pre-plugging sealing connectors has become a common cost-reduction strategy. However, after pre-plugging, a new connector part number is required. If different part numbers are used for each configuration and project, this significantly increases the workload for both upstream and downstream processes. Summary of the Invention

[0005] To overcome one or more of the above-mentioned drawbacks, the present invention provides the following technical solution.

[0006] According to a first aspect of the invention, a method for reducing the cost of pre-plugging holes in connectors is provided, comprising the steps of: determining the amount of wire harness used and the number associated with the wire harness, and encoding and combining the number associated with the wire harness; determining common vacant holes in each combination, and determining the total cost of sealing plugs for the common vacant holes in each combination based on the determined amount of wire harness used; and sorting the determined total cost of sealing plugs for the common vacant holes in each combination to generate a combination cost reduction table, thereby determining a hole position table for pre-plugging holes.

[0007] According to an embodiment of the first aspect of the present invention, a method for reducing the cost of pre-plugging holes in connectors, wherein determining the common vacant holes in each combination further includes: determining the vacancy state of each hole in the harness to generate a vacancy state indicator, wherein vacancy state indicator 1 indicates that the hole is in a vacant state, and vacancy state indicator 0 indicates that the hole is in a non-vacant state.

[0008] A method for reducing the cost of pre-plugging holes in connectors according to an embodiment of a first aspect of the present invention, wherein determining the total cost of sealing plugs for common vacant holes in each combination based on the determined wire harness usage further comprises: multiplying the cost of sealing plugs for one or more common vacant holes corresponding to each combination by the sum of the wire harness usage in the corresponding combination and summing the results of the multiplication to generate the total cost of sealing plugs for common vacant holes in each combination.

[0009] A method for reducing the cost of pre-plugging holes in connectors according to an embodiment of a first aspect of the present invention, wherein encoding and combining the numbers associated with the wiring harness includes determining all permutations and combinations of the numbers associated with the wiring harness.

[0010] According to a second aspect of the invention, a system for reducing the cost of pre-plugging holes in connectors is provided, comprising: a determining module configured to determine the amount of wire harness used and a number associated with the wire harness, and to encode and combine the numbers associated with the wire harness; a processing module configured to determine common vacant hole positions in each combination, and to determine the total cost of sealing plugs for the common vacant hole positions in each combination based on the determined amount of wire harness used; and a sorting module configured to sort the determined total cost of sealing plugs for the common vacant hole positions in each combination to generate a combination cost reduction table, thereby determining a hole position table for pre-plugging holes.

[0011] According to an embodiment of a second aspect of the present invention, a system for reducing the cost of pre-plugging holes in connectors, wherein the processing module is further configured to determine the vacancy state of each hole in the wiring harness to generate a vacancy state indicator, wherein vacancy state indicator 1 indicates that the hole is in a vacancy state, and vacancy state indicator 0 indicates that the hole is in a non-vacancy state.

[0012] According to an embodiment of a second aspect of the present invention, a system for reducing the cost of pre-plugging holes in connectors, wherein the processing module is further configured to multiply the cost of sealing plugs for one or more commonly vacant holes corresponding to each combination by the amount of wire harness used in the respective combination and to sum the results of the multiplication to generate a total cost of sealing plugs for the commonly vacant holes in each combination.

[0013] A system for reducing the cost of pre-plugging holes in connectors according to an embodiment of a second aspect of the present invention, wherein the determining module is further configured to determine all permutations and combinations of numbers associated with the wiring harness.

[0014] According to a third aspect of the present invention, a computer device is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement a method for reducing the cost of pre-plugging holes in connectors as described in any embodiment of the first aspect of the present invention.

[0015] According to a fourth aspect of the invention, a computer-readable storage medium is provided having a computer program stored thereon, wherein the program, when executed by a processor, implements the method for reducing the cost of pre-plugging holes in connectors as described in any embodiment of the first aspect of the invention.

[0016] According to one or more aspects of the present invention, a method and system for reducing the cost of pre-plugging holes in connectors, as described above, can be used. This method can perform a feasibility analysis on pre-plugging holes to reduce costs for connectors with a large number of unused holes, to obtain the combination scheme with the greatest cost reduction, and perform pre-plugging operations in the connector production process based on the combination scheme, thereby reducing the cost of connector production.

[0017] By incorporating the figures in this article and subsequently the appendix Figure 1 The specific embodiments used to illustrate certain principles of the invention will make other features and advantages of the methods and systems of the invention clearer or more apparent. Attached Figure Description

[0018] The above and / or other aspects and advantages of the present invention will become clearer and more readily understood from the following description taken in conjunction with the accompanying drawings, in which like or similar elements are denoted by the same reference numerals. The drawings include:

[0019] Figure 1 This is a flowchart of a method for reducing the cost of pre-plugging holes in connectors according to an embodiment of the present invention.

[0020] Figure 2 This is a schematic diagram of a system for reducing the cost of pre-plugging holes in connectors according to an embodiment of the present invention.

[0021] Figure 3 This is a schematic block diagram of a computer device according to an embodiment of the present invention. Detailed Implementation

[0022] In this specification, the invention is described more fully with reference to the accompanying drawings, which illustrate exemplary embodiments of the invention. However, the invention may be implemented in various forms and should not be construed as being limited to the embodiments given herein. The given embodiments are intended to make the disclosure herein complete and thorough, so as to more fully convey the scope of protection of the invention to those skilled in the art.

[0023] Terms such as "comprising" and "including" indicate that, in addition to the units and steps that are directly and explicitly stated in the specification, the technical solution of the present invention does not exclude the presence of other units and steps that are not directly or explicitly stated. Terms such as "first" and "second" do not indicate the order of the units in terms of time, space, size, etc., but are merely used to distinguish the units.

[0024] The invention is described below with reference to flowchart illustrations, block diagrams, and / or flowcharts of methods and systems according to embodiments of the invention. It will be understood that each block of these flowchart illustrations and / or block diagrams, and combinations thereof, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing apparatus to constitute a machine, such that these instructions, executable by the processor of the computer or other programmable data processing apparatus, create components for implementing the functions / operations specified in these flowchart illustrations and / or blocks and / or one or more flowchart illustrations.

[0025] Figure 1 This is a flowchart of a method for reducing the cost of pre-plugging holes in connectors according to an embodiment of the present invention.

[0026] like Figure 1 As shown, in step 110, the amount of wire harness used and the number associated with the wire harness are determined, and the number associated with the wire harness is encoded and combined.

[0027] In one example, sealing connectors with a large number of unused holes can be identified, and the wire harness part numbers to be analyzed can be selected based on the connector part numbers. The specific usage (e.g., annual usage) of the wire harness corresponding to each part number within a certain time period can be calculated. Each item is then identified using letters (e.g., A, B, C) to form a wire harness number, and the collected information is compiled into a table as shown in Table 1 below. Then, the wire harness numbers associated with the wire harnesses are coded and combined to form permutations of A, B, C, AB, AC, BC, ABC.

[0028] Wire harness number project Wire Harness Family Wire Harness Part Number Wire harness usage A P-1 ENG 01 50107 B P-1 ENG 02 1444 C P-1 ENG- 03 28238

[0029] Table 1

[0030] In step 120, common vacant holes in each combination are determined, and the total cost of sealing plugs for the common vacant holes in each combination is determined based on the determined wire harness usage. Optionally, determining the common vacant holes in each combination further includes: determining the vacancy state of each hole in the wire harness to generate a vacancy state indicator, wherein vacancy state indicator 1 indicates that the hole is vacant, and vacancy state indicator 0 indicates that the hole is not vacant. Optionally, determining the total cost of sealing plugs for the common vacant holes in each combination based on the determined wire harness usage further includes: multiplying the cost of sealing plugs for one or more common vacant holes corresponding to each combination by the sum of the wire harness usage in the corresponding combination and summing the results of the multiplication to generate the total cost of sealing plugs for the common vacant holes in each combination.

[0031] In one example, the table shown in Table 2 below is created based on the harness number, harness usage, and the vacancy status of each hole in the harness.

[0032]

[0033] Table 2

[0034] As shown in Table 2, the vacancy status of each hole position corresponding to each wire harness number is statistically analyzed. A vacancy indicator 1 indicates that the hole position is vacant, and a vacancy indicator 0 indicates that the hole position is not vacant. The cost of the sealing plug used for each hole position is also determined. Next, the wire harness numbers A, B, C, and D shown in Table 2 are encoded and combined to form all permutations such as A, AB, ABC, and ABCD. Then, for each permutation, the common vacant hole positions are determined. For example, for the combination ABC in Table 2, the vacant hole position is hole position 3, and for the combination AB in Table 2, the vacant hole positions are hole positions 1 and 3.

[0035] It is understood that the above-described holes 1-5 and their vacancy states are merely examples, and more holes and their vacancy states can be determined without departing from the scope and spirit of the present invention.

[0036] After determining the common vacant holes for each permutation combination, the cost of the corresponding sealing plug for each common vacant hole is multiplied by the total wiring harness usage for that combination to obtain the sum of the sealing plug costs for that hole. The sum of the sealing plug costs for all common vacant holes is then accumulated to obtain the maximum reducible cost for that combination. As an example, for the AB and ABC combinations shown in Table 2 above, the maximum reducible cost for combination AB can be calculated using the following formula: Maximum reducible cost of combination AB = Sealing plug cost (hole 1) Wire harness usage (A+B) + cost of sealing plugs (hole position 3) The wiring harness usage (A+B) and the maximum cost reduction for this combination ABC can be calculated using the following formula: Maximum cost reduction for combination ABC = Cost of sealing plug (hole position 3) Wire harness usage (A+B+C).

[0037] In step 130, the total cost of the sealing plugs for the common vacant holes in each of the combinations is sorted to generate a combination cost reduction table, thereby determining the hole location table for pre-plugging holes.

[0038] In one example, the maximum cost reduction can be calculated for all permutations and combinations such as A, AB, ABC, ABCD, etc., and the maximum cost reduction of all calculated combinations can be sorted from largest to smallest to obtain a cost reduction table, as shown in Table 3 below.

[0039]

[0040] Table 3

[0041] Table 3 shows the ranking of the maximum cost reduction potential of all permutations and combinations formed by encoding and combining wire harness numbers A, B, C, and D. Based on this table, it can be seen that combination ACD is the combination with the largest cost reduction value. Therefore, a pre-plugging scheme can be formulated based on the common vacant hole positions determined by combination ACD, so that hole position 3 of combination ACD can be pre-plugged during the production process, and so on.

[0042] Those skilled in the art will understand that the various information about wire harnesses in Tables 1-3 above are merely illustrative examples. Without departing from the scope and spirit of the present invention, the above process can be used to process other connector part numbers, wire harness part numbers, wire harness usage, vacant hole positions and their corresponding sealing plug costs to generate a combination cost reduction table as shown in Table 3, thereby obtaining a combination that can achieve cost reduction and a hole position table of its pre-plugged holes.

[0043] Alternatively, although Table 2 above shows a feasibility analysis for pre-plugging cost reduction for one connector part number, it is understood that Table 2 above can also be used to perform feasibility analysis for pre-plugging cost reduction for other connector part numbers to generate multiple combined cost reduction tables, and the generated multiple combined cost reduction tables can be compared to obtain a more complete cost reduction plan.

[0044] The above-mentioned method for reducing the cost of pre-plugging holes in connectors is applied to the pre-plugging hole process of connectors. It can perform a feasibility analysis of pre-plugging hole cost reduction for connectors with a large number of empty holes to obtain the combination scheme with the greatest cost reduction, and carry out the pre-plugging hole operation in the connector production process based on the combination scheme, thereby reducing the cost of connector production.

[0045] Figure 2 This is a schematic diagram of a system for reducing the cost of pre-plugging holes in connectors according to an embodiment of the present invention.

[0046] like Figure 2 As shown, the system 20 for reducing the cost of pre-plugging holes in connectors includes: a determination module 210 configured to determine the amount of wire harness used and the number associated with the wire harness, and to encode and combine the number associated with the wire harness; a processing module 220 configured to determine common vacant hole positions in each combination, and to determine the total cost of sealing plugs for the common vacant hole positions in each combination based on the determined amount of wire harness used; and a sorting module 230 configured to sort the determined total cost of sealing plugs for the common vacant hole positions in each combination to generate a combination cost reduction table, thereby determining a hole position table for pre-plugging holes.

[0047] Optionally, the processing module 220 is further configured to determine the vacancy state of each hole in the harness to generate a vacancy state indicator, wherein the vacancy state indicator 1 indicates that the hole is in a vacancy state, and the vacancy state indicator 0 indicates that the hole is in a non-vacancy state.

[0048] Optionally, the processing module 220 is further configured to multiply the cost of the sealing plugs for the common vacant holes corresponding to each combination by the amount of wire harness used in the respective combination and sum the results of the multiplication to generate a total cost of the sealing plugs for the common vacant holes in each combination.

[0049] In one example, module 210 can be configured to count sealing connectors with a large number of vacant holes, and select the wire harness part numbers to be analyzed based on the connector part numbers. It then counts the specific usage (e.g., annual usage) of the wire harness corresponding to each part number within a certain time period, and identifies each item using letters (e.g., A, B, C) to form a wire harness number. The collected information is then compiled into the table shown in Table 1 above. The wire harness numbers associated with the wire harnesses are then coded and combined to form permutations of A, B, C, AB, AC, BC, and ABC.

[0050] In one example, the table shown in Table 2 above is created based on the harness number, the amount of harness used, and the vacancy status of each hole in the harness.

[0051] As shown in Table 2, the vacancy status of each hole position corresponding to each wire harness number is statistically analyzed. A vacancy indicator 1 indicates that the hole position is vacant, and a vacancy indicator 0 indicates that the hole position is not vacant. The cost of the sealing plug used for each hole position is also determined. Next, the wire harness numbers A, B, C, and D shown in Table 2 are encoded and combined to form all permutations such as A, AB, ABC, and ABCD. Then, for each permutation, the common vacant hole positions are determined. For example, for the combination ABC in Table 2, the vacant hole position is hole position 3, and for the combination AB in Table 2, the vacant hole positions are hole positions 1 and 3.

[0052] It is understood that the above-described holes 1-5 and their vacancy states are merely examples, and more holes and their vacancy states can be determined without departing from the scope and spirit of the present invention.

[0053] In one example, processing module 220 is configured to, after determining the common vacant holes for each permutation combination, multiply the corresponding sealing plug cost of the common vacant holes by the sum of the wiring harness usage for that combination to obtain the total sealing plug cost for that hole, and then sum the total sealing plug costs of all common vacant holes to obtain the maximum reducible cost for that combination. As an example, for the AB and ABC combinations shown in Table 2 above, the maximum reducible cost of combination AB can be calculated using the following formula: Maximum reducible cost of combination AB = Sealing plug cost (hole 1) Wire harness usage (A+B) + cost of sealing plugs (hole position 3) The wiring harness usage (A+B) and the maximum cost reduction for this combination ABC can be calculated using the following formula: Maximum cost reduction for combination ABC = Cost of sealing plug (hole position 3) Wire harness usage (A+B+C).

[0054] In one example, the sorting module 230 is configured to sort all calculated combinations by maximum cost reduction from largest to smallest to obtain a combination cost reduction table, as shown in Table 3 above. Table 3 shows the combination cost reduction, which represents the sorting of the maximum cost reduction of all permutations and combinations formed by encoding and combining wire harness numbers A, B, C, and D. Based on this table, it can be seen that combination ACD is the combination with the largest cost reduction value. Therefore, a pre-plugging scheme can be formulated based on the common vacant hole position determined by combination ACD, so that hole position 3 of combination ACD can be pre-plugged during the production process, and so on.

[0055] Those skilled in the art will understand that the various information about wire harnesses in Tables 1-3 above are merely illustrative examples. Without departing from the scope and spirit of the present invention, the above process can be used to process other connector part numbers, wire harness part numbers, wire harness usage, vacant hole positions and their corresponding sealing plug costs to generate a combination cost reduction table as shown in Table 3, thereby obtaining a combination that can achieve cost reduction and a hole position table of its pre-plugged holes.

[0056] Alternatively, although Table 2 above shows a feasibility analysis for pre-plugging cost reduction for one connector part number, it is understood that Table 2 above can also be used to perform feasibility analysis for pre-plugging cost reduction for other connector part numbers to generate multiple combined cost reduction tables, and the generated multiple combined cost reduction tables can be compared to obtain a more complete cost reduction plan.

[0057] The aforementioned system for reducing the cost of pre-plugging holes in connectors is applied to the pre-plugging process of connectors. It can perform a feasibility analysis on pre-plugging holes to reduce costs for connectors with a large number of empty holes, so as to obtain the combination scheme with the greatest cost reduction, and carry out the pre-plugging operation in the connector production process based on the combination scheme, thereby reducing the cost of connector production.

[0058] Figure 3 This is a schematic block diagram of a computer device according to another embodiment of the present invention. The computer device 30 includes a memory 310, a processor 320, and a computer program 330 stored in the memory and executable on the processor. The processor 320 executes the computer program 330 to implement the above-described method for reducing the cost of pre-plugging holes in connectors.

[0059] According to another aspect of the invention, a computer-readable storage medium is also provided, on which a computer program is stored, which, when executed by a processor, can implement the above-described method for reducing the cost of pre-plugging holes in connectors.

[0060] The embodiments and examples presented herein are provided to best illustrate embodiments according to the present technology and its particular applications, thereby enabling those skilled in the art to practice and use the invention. However, those skilled in the art will understand that the above description and examples are provided merely for ease of illustration and example. The descriptions presented are not intended to cover all aspects of the invention or to limit the invention to the precise forms disclosed.

Claims

1. A method for reducing the cost of pre-plugging holes in connectors, characterized in that, Includes the following steps: Determine the amount of wire harness used and the number associated with the wire harness, and encode and combine the numbers associated with the wire harness; The common vacant holes corresponding to the wire harnesses for each coding combination are determined, and the total cost of sealing plugs for the common vacant holes corresponding to the wire harnesses for each coding combination is determined based on the determined wire harness usage. as well as The total cost of the sealing plugs for the common vacant hole positions corresponding to the determined wire harnesses for each coding combination is sorted to generate a combination cost reduction table, thereby determining the hole position table for pre-plugging holes. The determination of the total cost of sealing plugs for the common vacant holes corresponding to the wire harnesses for each coding combination based on the determined wire harness usage further includes: multiplying the cost of sealing plugs for one or more common vacant holes corresponding to the wire harnesses for each coding combination by the sum of the wire harness usage for the corresponding coding combination, and summing the results of the multiplication to generate the total cost of sealing plugs for the common vacant holes corresponding to the wire harnesses for each coding combination.

2. The method according to claim 1, wherein determining the common vacant aperture corresponding to each type of coded combination of wire harness further comprises: The vacancy status of each hole in the wire harness is determined to generate a vacancy status indicator, wherein vacancy status indicator 1 indicates that the hole is in a vacancy state, and vacancy status indicator 0 indicates that the hole is in a non-vacancy state.

3. The method of claim 1, wherein encoding the numbering associated with the harness includes determining all permutations and combinations of the numbering associated with the harness.

4. A system for reducing the cost of pre-plugging holes in connectors, characterized in that, include: A determination module is configured to determine the amount of wire harness used and the number associated with the wire harness, and to encode and combine the number associated with the wire harness. The processing module is configured to determine the common vacant holes corresponding to the wire harnesses for each coding combination, and to determine the total cost of sealing plugs for the common vacant holes corresponding to the wire harnesses for each coding combination based on the determined wire harness usage. as well as A sorting module is configured to sort the total cost of sealing plugs for common vacant hole positions corresponding to the determined wire harnesses for each coding combination to generate a combination cost reduction table, thereby determining a hole position table for pre-plugging holes. The processing module is further configured to multiply the cost of the sealing plugs for the common vacant holes corresponding to the wire harnesses of each coding combination by the sum of the wire harness usage for the corresponding coding combination, and to sum the results of the multiplication to generate the total cost of the sealing plugs for the common vacant holes corresponding to the wire harnesses of each coding combination.

5. The system of claim 4, wherein the processing module is further configured to determine the vacancy state of each hole in the wire harness to generate a vacancy state indicator, wherein vacancy state indicator 1 indicates that the hole is in a vacancy state, and vacancy state indicator 0 indicates that the hole is in a non-vacancy state.

6. The system of claim 4, wherein the determining module is further configured to determine all permutations and combinations of numbers associated with the harness.

7. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, The processor executes the computer program to achieve: The method for reducing the cost of pre-plugging holes in connectors as described in any one of claims 1-3.

8. A computer-readable storage medium storing a computer program thereon, characterized in that, The computer program can be implemented when executed by a processor: The method for reducing the cost of pre-plugging holes in connectors as described in any one of claims 1-3.

Images