Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule

Abstract

The invention relates to a method and device for realizing automatic product configuration by utilizing spreadsheet definition rule. The method comprises the following steps: defining a spreadsheet structure and inputting product related / configuration parameters; reading matching rules of spreadsheet definition by a system; automatically completing product matching by the system; after matching operation is completed, obtaining BOM (bill of material) data of the product by the system; and supporting importing the BOM data of the product into a three-dimensional CAD (computer aided design) system for design verification. The device comprises a data reading module, a formula management module, a naming management module and a formula generating module. The invention has the following beneficial effects: the spreadsheet form is used for replacing the traditional logical judgement program expression form; and the system modifies configuration conveniently and can automatically carry out non-standard design and customized contract processing rapidly and accurately, thus improving the accuracy and reducing the production cost.

Description

technical field [0001] The invention relates to the field of product design, in particular to a method and system for defining rules by means of an electronic form and realizing automatic matching of mass-customized products. Background technique [0002] Under mass customization, the object of product development has changed from a single product to a series of products, and the subsequent product diversity has put forward new requirements for product data management. The types of products of this type of enterprise customers are often not many, but the order requirements are mostly different, such as elevators, gearboxes and other products. In addition to common parts such as standard parts, this type of product structure has a large number of raw materials, structures, and dimensional changes in parts between different products. In the packing list of an elevator, there are more than 300 parameters that need to be modified between different specifications, and 40-50 of t...

AI Technical Summary

Problems solved by technology

[0005] 1. Many companies use designers to search for various constraint rules in spreadsheets and manually modify them one by one, which is prone to omissions and mistakes, which will affect all aspects of procurement, manufacturing and assembly, affect the delivery cycle and even cause major damage to the company. loss

Involves situations where order changes are more likely to cause data confusion

[0006] 2. Some small and medium-sized enterprises simply digest the contract parameters through the design department and process them as technical parameters inside the factory. Such technical parameters are difficult to achieve the ability to automatically generate production orders and packing lists, and the production is completely digested and produced through the capabilities of the manufacturing department. This method places a heavy burden on the manufacturing department and has the same problems as manual processing in the long run

[0007] 3. Some enterprises of this type implement product selection and matching functions through secondary development of corresponding modules on back-end systems such as PDM or ERP. Practice has shown that the development cost of this method is very high, and the flexibility of non-standard contract processing Low, poor maintainability, and ultimately also affects product lead times and costs

Images