Home » knowledge » From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

There are many types of processing tools for vehicle wiring harness data, and the fields of application involve automobile, aviation, electronics and other industries. The choice of the right tool is often based on the needs of the product and the enterprise itself. Commonly used data processing tools in the industry include CATIA-VPLM, EBcable, Vesys, Ldorado, Midline CAD, Zetai CAPP, etc. All kinds of software can be used together , the modules in the software can be selected and configured according to the status of the product.

There are many types of processing tools for vehicle wiring harness data, and the fields of application involve automobile, aviation, electronics and other industries. The choice of the right tool is often based on the needs of the product and the enterprise itself. Commonly used data processing tools in the industry include CATIA-VPLM, EBcable, Vesys, Ldorado, Midline CAD, Zetai CAPP, etc. All kinds of software can be used together , the modules in the software can be selected and configured according to the status of the product.

Why choose CATIA V5 ENVOIA VPLM module?

Features of ENVOIA VPLM System It is easy to define the potential impact and configuration of design changes, and change management is also very convenient, which can optimize the process of synchronous engineering, realize data sharing, and make data locking/unlocking more convenient. To put it simply, when modifying the wiring harness module, you can see the data of other systems in the system such as body-in-white, seat, engine, etc., and use these data as the boundary to accurately modify and define the wiring harness module, and modify it at the same time. The later data can be uploaded from the computer to the system locally or locked on the system online. After the modification is completed, the data will be unlocked, and the relevant change information will also be synchronized to the system;

What methods are there for the design of harness data in Catia?

First, you need to complete the component definition of the Catalog directory

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

There are as many as 600 or 700 kinds of components involved in the vehicle wiring harness. The definition and maintenance of components such as connector terminal coverings will bring great convenience to the wiring harness design. design.

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

The 3D design in Catia commonly uses the wiring harness design module and the generative curve module. The application of the wiring harness design module is the main wiring harness design method. The components with ancillary electrical properties are installed in the body-in-white, vehicle electrical appliances, fixing holes and other positions. The components are connected to form a preliminary wiring harness direction and meet the constraints of each boundary system; the generative curve is usually used for local modification and spatial adjustment, which is suitable for small-scale data processing.

Generative Curve Design Method

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

EPD module wiring harness design

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

How to form EBOM and Cutting table?

According to Capital Harness System, on the CHS platform, system-level logic circuit and physical circuit design can be completed; various simulation verifications can be performed on the completed circuit; the completed circuit design can interact with 3D mechanical software such as CATIA to obtain accurate Wire length information; can flatten the 3D topology structure completed in 3D mechanical software into 2D, and complete process design and engineering calculations; finally provide various reports and data such as wire list, EBOM, template diagram, etc. required for production .

CHS Flowchart

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

After the 3D design in Catia has coordinated the spatial position and completed a reasonable layout, the Capital Harness System software can be used to import the principle/wiring diagram design in the software into the wiring relationship information, and at the same time, the principle/wiring diagram design will also be transmitted to the CATIA wiring harness. Design, complete the wire harness automatic laying in CATIA, and transmit the length information and topology of the wire harness to the capital engineer, the wire harness design module of CHS, to carry out 3D exhibits, process design, validity inspection and engineering calculation, etc., and generate processing, EBOM, wire list and other information required for procurement.

The formation of wiring harness product drawings?

You can use the EHF module in catia to flatten the electrical wiring harness or use the Capital Harness Engineer to use the data generated by the logical design to complete the design of the two-dimensional engineering wiring harness diagram;

How to decompose and convert the wiring harness company’s drawings?

The situation that needs to be briefly explained here is that the analysis of drawings is the engineering content of many wiring harness factories. Because wiring harness companies in the first-tier suppliers of OEMs usually maintain data sharing with OEMs, complete synchronous development, and assist vehicle manufacturers Enterprise design. Therefore, it is necessary to maintain consistency with car companies in the application environment of product data to facilitate collaboration. Therefore, there are wiring harness companies in the form of secondary supporting business. Since most of the input information is frozen data, such decomposition and conversion work will be too much. So for the secondary supporting enterprises, which analysis software is used more for wire harness production? It is recommended to use domestic self-owned brand software such as Zhongline cad and Zetai capp. The following is the function introduction of the two types of software:

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

Importance of Excel in Data Processing

In the process from the design of the whole vehicle wiring harness to the formation of product drawings, many product data are solidified in the 2D drawings. However, the information required by the enterprise procurement, process and other links is the unit information that can be extracted independently. Therefore, the application of the excel function of the office software at this time is indispensable in the product development process under the multi-model and multi-configuration. Commonly used methods for arranging the information data of wire harness product units are: data pivot and vlookup function, integrated function table, etc.

Vlookup function application 1 – subtotal

Because of the different configurations and models of the products, the data of the products have the characteristics of common materials and special materials. In order to accurately count the data of these materials, the vlookup function can better handle the information in the BOM of multiple products;

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

Vlookup Function Application 2 – Cell Pivot

In the process of data classification and summarization, the materials used are classified and summarized, and the common materials and special materials are distinguished to form the material information of the product. The data perspective method is one of the important application methods.

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

Development of integrated functions

Using the embedded link function, after completing the product direction dimension in the panel control, you can use the coordinate definition in Excel to automatically generate the coordinates of both ends of the wire, thereby calculating the size of the wire.

From the application of ENOVIA VPLM to Vlookup, see the processing of vehicle wiring harness data

The above is a brief introduction to the application tools of the vehicle wiring harness design data. More functions will be continuously developed in the application. However, in the processing of the vehicle wiring harness, we need to combine the actual situation of the enterprise and product characteristics. Choose the right tool to process product data.

The Links:   CM600HA-24E M190ETN010