A one-key intelligent single generation system based on WPS

Abstract

A one-click intelligent bill of materials generation system based on WPS and its data processing method are disclosed, relating to the fields of intelligent manufacturing and industrial data processing technology. The system includes an intelligent process enhancement engine, a dual-dimensional automatic classification system, and a WPS native function integration architecture. The method obtains the bill of materials exported from design software, automatically calculates weight, adds allowances, and annotates processes using the engine; then, the classification system automatically groups the materials according to both material and shape dimensions and outputs them to independent worksheets. This invention relies entirely on WPS native functions and scripts, requiring no third-party plugins, solving the problems of cumbersome, inefficient, and error-prone manual operations in industrial bill of materials processing. It achieves full-process automation from design data to production instructions, improving the efficiency and data accuracy of the manufacturing production preparation stage.

Description

Technical Field

[0001] This invention relates to the field of intelligent manufacturing and industrial data processing technology, and more specifically, to an intelligent processing system and method for industrial bill of materials integrated into a general office software environment. Background Technology

[0002] In manufacturing industries such as machining, mold making, and steel structures, significant data gaps exist in the process from computer-aided design (CAD) to production material preparation. The bills of materials (BOMs) generated by mainstream 3D design software (such as PRESSUG) typically only include basic part dimensions, quantities, and theoretical weights using a single fixed density. Crucial information essential for downstream production, such as precise weights of multiple materials, machining allowances, and process routes, is generally missing. This situation forces process and planning personnel to invest significant time in repetitive manual calculations, data entry, and work order classification, resulting in low efficiency and a high risk of human error, thus becoming a bottleneck restricting production preparation efficiency and data accuracy.

[0003] Three problems exist with current technology: Problem 1 (Inefficiency): In existing technologies, process engineers need to manually calculate the design BOM (material density matching, volume calculation), manually add machining allowances, and manually annotate machining processes, which consumes a lot of time. Taking the processing of a material list containing 200 parts and involving 10 different materials as an example, the traditional manual method takes about 4-6 hours.

[0004] Problem 2 (high error rate): Manual operation is prone to errors in data transcription, complex calculations, rule matching and other processes, resulting in production waste.

[0005] Question 3 (Tool Limitations): Existing automation solutions are mostly independent plug-ins or software, which are complex to deploy and disconnected from the common office environment of enterprises (such as WPS / Excel), making it difficult to customize process rules according to enterprise needs.

[0006] Currently, industry solutions to this problem mainly fall into two categories: one relies entirely on manual spreadsheet operation, resulting in poor scalability and accuracy; the other involves developing independent professional plugins or small software programs for specific design software. While the latter can achieve partial automation, it typically suffers from inherent drawbacks such as complex deployment, poor compatibility with general office environments, high maintenance costs, limited functionality, inability to handle complex industrial logic, and difficulty in covering end-to-end "data augmentation-automatic classification" processes. There is a technical bias among those skilled in the art that general office software such as WPS and Microsoft Office, due to their positioning, lack the ability to handle complex industrial logic and automated processes in a native environment, thus favoring the development of independent systems.

[0007] This invention creatively utilizes a combination of native WPS functions and scripts to construct a complete data processing workflow, thereby breaking the technical prejudice that "general office software cannot handle complex industrial logic." This is considered one of the core contributions of this invention. Summary of the Invention

[0008] This invention aims to provide a universal, efficient, accurate, and easy-to-deploy intelligent solution for the entire industrial bill of materials (BOM) process. Its core concept is to build a plug-in-free, integrated, automated data processing workflow entirely based on the native capabilities of general office software such as WPS, achieving seamless conversion from design BOM to production work order with extremely low cost and technical barriers.

[0009] The objective of this invention is achieved through the following technical solution: a one-click intelligent material output sheet generation system based on WPS, mainly comprising: Intelligent Process Enhancement Engine: This engine is the system's "core processing module" and "decision center." It is not a simple calculator, but an intelligent processing module integrating a material knowledge base (containing multiple material densities) and a process rule base (containing standard allowances and process mappings). Its workflow is as follows: It receives the original bill of materials data rows, identifies the "material" (e.g., "45#", "AL6061") and "dimension" (e.g., "thickness 200, length 20, width 50" represents sheet metal, "thickness 100, length ⌀50" represents round material), and then automatically performs the following operations: adds processing allowances to the dimension data and adjusts the final dimensions based on allowance recognition logic; matches the precise density from the density cell using nested IF functions; identifies the shape based on shape recognition logic, calls the corresponding volume formula to calculate the theoretical weight, and dynamically labels the recommended processing type in the process column (e.g., "no chamfer, no grinding", "chamfer 2.0, four-sided grinding", "chamfer 2.0, rough turning").

[0010] Dual-Dimensional Automatic Classification System: This module is the "automatic classification module" for production tasks. After the process enhancement steps are completed, the system traverses the entire bill of materials, using "material" and "geometry" as the joint classification key to perform pivoting and grouping of the data. For example, it separates all parts made of "plastic steel" from all parts made of "45#" material; simultaneously, within all materials, it further categorizes different shapes such as "sheet metal" and "round metal." Finally, the system automatically creates an independent spreadsheet for each unique "material-shape" combination within the same workbook, accurately copying all corresponding data entries to form a production task package that can be directly distributed to different work stages (such as sawing, laser cutting, and purchasing).

[0011] WPS Native Function Integration Architecture: This is the outstanding innovation and practical guarantee of this invention. All functional logic of the entire system, including complex data matching, calculation, judgment, and grouping operations, is implemented through carefully designed combinations of WPS native functions (such as array formulas like LOOKUP, IF, and SUMIF) and VBA macro scripts. Users only need to open the system's template file on a computer with WPS Office software installed to start using it; there is no need to download, install, or configure any additional plugins or software, nor is there a need to learn a new software interface, achieving "zero-friction" integration with the user's existing work environment.

[0012] Based on the above system, the present invention also provides an intelligent material output sheet data processing method, the steps of which are all automatically executed by the above system in the WPS environment, realizing end-to-end automation from data import to classification output. Attached Figure Description

[0013] ‌ Figure 1 This is a schematic diagram of the system architecture of the present invention, illustrating the connection and data flow relationship between the intelligent process enhancement engine, the dual-dimensional automatic classification system, and the WPS native function integration architecture.

[0014] Figure 2 This is a flowchart of the data processing method of the present invention, which shows the complete steps of data acquisition, intelligent enhancement, automatic classification and output in sequence.

[0015] There are two attached images. Detailed Implementation

[0016] To make the objectives, technical solutions, and advantages of this invention clearer, the specific implementation of this invention will be described in detail below using the "PRESSUG 3D design software" as an example. This embodiment should not be construed as limiting the scope of protection of this invention.

[0017] Environment Preparation and Data Input: In the WPS template file provided by this invention, the user locates the "Original Data" input area. After completing the design in PRESSUG software, the user exports a standard format Excel bill of materials file. The user then copies the data from this file, row by row, to the "Original Data" area of ​​the WPS template according to the corresponding column headings (such as "Code", "Material", "Thickness", "Length (Diameter)", "Width", and "Quantity").

[0018] Real-time triggering of intelligent enhancement: When data is pasted into the "Original Data" area, the "Intelligent Bill of Materials" area, which is linked to it through a complex function chain, will automatically refresh and display the results. This process is fully automatic, and the logic behind it is as follows: Each row of data triggers a function chain, first identifying the content "AL6061" in the "Material" cell, and matching the density value of 2.8g / cm³ from the hidden density cell; then, parsing the "Thickness, Length (Diameter), Width" in the "Specifications" cell, identifying it as sheet metal or round material, and identifying the minimum dimension as the thickness dimension; then, adding milling allowance to the sheet metal according to the rule library (e.g., diameter +1, length +5 for round steel material), and calculating the volume and weight of the new dimension; finally, based on the combination of material and shape, automatically marking "Chamfer 2.0, Rough Turning" in the "Process" column, and supplementing relevant information in the "Remarks" column.

[0019] One-click automatic categorization: After confirming the data in the "Smart Bill of Materials" is correct, the user presses the preset start shortcut key (e.g., Ctrl+Shift+C). The system's built-in macro script begins execution: it reads all unique value combinations in the "Material" and "Shape" columns of the "Smart Bill of Materials"; then, it creates a new worksheet for each combination in the current workbook and names it after the combination (e.g., "CR12", "45# Round Material"); finally, the script iterates through each row of data and copies it to the worksheet with the corresponding name. The entire process is completed within seconds.

[0020] Output and Application: After classification, the production planner can directly print the "45# Round Material" worksheet and send it to the lathe section, and send the "CR12" worksheet to the laser cutting center. Each worksheet is a clear, independent production instruction containing all processing information.

[0021] Through the above steps, the present invention achieves a fully automated conversion from original design data to executable production instructions. Beneficial effects

[0022] Compared with the prior art, the technical solution provided by the present invention has the following significant advantages: Significantly improved processing efficiency: The manual calculation, data entry, and classification work that originally took hours or even days can be completed in just a few minutes. Manual operations are reduced by more than 95%, freeing up the time and energy of process engineers. For example, "processing a bill of materials containing 200 parts and 10 different materials would typically take 4-6 hours manually, while this system can complete it in 10 minutes, improving efficiency by over 95%."

[0023] Achieving zero-error data flow: Through a built-in rule base and automated calculations, the inevitable omissions and errors in manual transcription and calculation are completely eliminated, ensuring the accuracy of material data at its source and effectively avoiding production waste and delays caused by data errors. For example, "By replacing manual table lookups with built-in precise matching functions (such as embedded IF functions), errors in lookup and calculations are fundamentally eliminated."

[0024] It boasts excellent versatility and configurability: the system's core logic is decoupled from specific rules (density library, allowance rules, process mapping). By modifying the rule configuration table in WPS Spreadsheet, which serves as the backend database, it can quickly adapt to the standards of different industries (such as sheet metal, mold making, and machining) and the data formats output by different design software without modifying the code, demonstrating strong scalability.

[0025] Extremely low deployment and usage costs: By fully utilizing the existing and most widely used WPS Office software as the operating platform, it achieves "no need to install additional software, and users can use it without special training." Users do not need to change their existing work habits, and the learning cost is almost zero, which greatly promotes the rapid implementation and promotion of the technology.

[0026] Enhanced production collaboration: The automatically categorized task package worksheets naturally align with the production division of labor in different work sections such as turning, grinding, and milling, making task distribution clearer and production collaboration smoother.

Claims

1. A WPS-based intelligent material output sheet generation system, characterized in that, include: The processing engine is used to automatically perform weight calculations, add allowances, and enhance information such as process annotations on the bill of materials data imported from WPS documents. The classification system connects to the processing engine and automatically identifies and groups the enhanced data based on preset material and shape dimensions. The system functions are implemented through WPS embedded macro scripts and worksheet functions, completing the entire process from data import to group output within a single WPS document.

2. The system according to claim 1, characterized in that, The processing engine has an embedded rule library used to match the calculation model and process parameters corresponding to the material data.

3. The system according to claim 1, characterized in that, The processing logic is implemented by calling native functions through macro languages ​​or VBA scripts supported by WPS.

4. A method for generating intelligent material output sheets based on WPS, characterized in that, The process includes the following steps: Importing the original bill of materials data into a WPS document; automatically performing information enhancement processing on the original data to generate intermediate data containing processing information; automatically identifying and grouping the intermediate data based on both material and shape dimensions; and outputting the grouped data to a separate worksheet within the WPS document.

5. The method according to claim 4, characterized in that, The raw data is either exported from engineering design software or table data pasted by the user.

Images