Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

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

A spreadsheet and product technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as high development costs, affecting procurement, manufacturing and assembly, and burdens, and achieve accurate non-standard design and customized contracts. The effect of processing, improving the market competitiveness of enterprises and reducing production costs

Inactive Publication Date: 2011-05-04
SHENYANG NEU ZXTECH TECH
View PDF0 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule
  • Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule
  • Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0068] The technical solution of the present invention will be further described in more detail in conjunction with the accompanying drawings and the elevator industry options.

[0069] 1) Basic preparation for implementation

[0070] as attached figure 2 , adopt the method of standardization and variant design of elevator products to establish a basic variable elevator product structure, and establish a basic elevator product BOM structure tree on the basis of analyzing the product structure and design process, such as step 201; organize the main components of each component Parameters, variables, and constraint rules include variable configuration rules and constraint configuration rules, as in step 202 .

[0071] 2) Define the spreadsheet format

[0072] Defines the spreadsheet structure format. Define product main parameter definition area (including car depth, car width, door opening width, speed, etc.), main parameter restriction area, intermediate variable definitio...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06Q10/00G06F17/30G06Q10/06
Inventor 韦琛
Owner SHENYANG NEU ZXTECH TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Eureka Blog
Learn More
PatSnap group products