Method for extracting data
By using VBA programs to automatically perform keyword selection and data processing, the problem of low efficiency in extracting engineering quantity calculation draft data was solved, and efficient and accurate extraction and tracking of engineering quantity data was achieved.
Patent Information
- Application Number
- CN202511915397.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-12-18
- Publication Date
- 2026-03-06
AI Technical Summary
In existing technologies, the data extraction efficiency of engineering quantity calculation drafts is low, requiring manual screening and summation, which leads to a decline in work quality and inaccurate data.
The VBA program is used to automatically perform keyword selection, create new worksheets, extract and track data, and provide feedback on the processing status, reducing manual operations and improving the degree of automation.
It improves the efficiency and accuracy of extracting engineering quantity data, reduces manual operations, and ensures data quality and work efficiency.
Smart Images
Figure CN121614537A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of engineering cost data technology, and more specifically to a method for extracting data. Background Technology
[0002] Currently, cost estimation software stores and processes quantity calculation drafts in Excel workbooks and worksheets. The table structure is organized according to the sub-item structure of a single project. Extracting quantities requires manual screening and summation. A single project may have hundreds or thousands of sub-item data tables. Quantity extraction requires repeated manual screening and summation, which consumes a lot of time and energy. Human error reduces work quality and efficiency and affects the accuracy of quantity data. Summary of the Invention
[0003] The purpose of this invention is to address the current situation where the extraction of engineering quantities is inefficient, cumbersome, and prone to errors, by providing a method for extracting data that facilitates data tracking, improves work quality and efficiency, and ensures the accuracy of engineering quantity data.
[0004] The technical solution of the present invention is as follows:
[0005] A method for extracting data, with the following specific steps:
[0006] Select keywords;
[0007] Create a new worksheet;
[0008] Extract data, track data;
[0009] Feedback processing status.
[0010] Furthermore, the selection of keywords uses a VBA program, including floor, name, volume (m3), template area (m2), remarks, and source. The default selection is the floor, the name, the volume (m3), the template area (m2), and the remarks.
[0011] Furthermore, the creation of the new worksheet is done automatically using a VBA program.
[0012] Furthermore, the data extraction and tracking process uses a VBA program. If the workbook worksheet title keywords simultaneously satisfy the floor, name, volume (m3), template area (m2), and remarks, then the workbook worksheet data is copied to the new worksheet, and the workbook worksheet name from which the data originates is written in the source column.
[0013] Furthermore, the feedback processing uses a VBA program to report the number of worksheets that have been scanned.
[0014] The beneficial effects of this invention are: it provides a method for extracting data, leveraging the advantages of automatic execution via VBA, default keyword selection to reduce manual operations, and, when keywords are simultaneously satisfied, importing data into a new worksheet and writing the source worksheet name in the source column for easy data tracking. Combined with feedback on the number of scanned worksheets, it improves work quality and efficiency and ensures the accuracy of engineering quantity data. Attached Figure Description
[0015] Figure 1 This is a schematic diagram illustrating the creation of a new worksheet according to an embodiment of the present invention.
[0016] Figure 2 This is a schematic diagram illustrating the data extraction and tracking process according to an embodiment of the present invention.
[0017] Figure 3 This is a schematic diagram illustrating the feedback processing in an embodiment of the present invention.
[0018] Figure 4 This is a flowchart of an Excel-VBA program according to an embodiment of the present invention.
[0019] Figure 5 This is a partial VBA program code example of an embodiment of the present invention. Detailed Implementation
[0020] The present invention will now be described in further detail.
[0021] Select keywords;
[0022] like Figure 1 Create a new worksheet;
[0023] like Figure 2 Extract data, track data;
[0024] like Figure 3 Feedback processing status.
[0025] The above steps extract data into a worksheet, which facilitates the extraction of project quantities, tracking of data sources, and, combined with feedback processing, can improve work quality.
[0026] The selection of keywords uses VBA programming and includes floor, name, volume (m3), template area (m2), remarks, and source. The default selection is the floor, the name, the volume (m3), the template area (m2), and the remarks.
[0027] The above steps enable keyword matching, and the default keyword selection allows VBA to automate the process, reducing manual intervention.
[0028] The creation of new worksheets is done automatically using a VBA program.
[0029] The above steps can be automated using VBA, improving work efficiency.
[0030] The data extraction and tracking process uses a VBA program. If the workbook worksheet title keywords simultaneously satisfy the floor, name, volume (m3), template area (m2), and remarks, then the workbook worksheet data is copied to the new worksheet, and the workbook worksheet name from which the data originated is written in the source column.
[0031] The above steps enable VBA to automatically extract and track data, improving work efficiency and data accuracy.
[0032] The feedback processing status.
[0033] The above steps can help users further check the data extraction status.
[0034] like Figure 4 As shown, this describes the workflow of VBA.
[0035] like Figure 5 As shown, you can refer to the code, but are not limited to the code shown in the figure.
Claims
1. A method of extracting data, characterized by The method comprises the following steps: selecting a keyword; creating a new worksheet; extracting data and tracking data; feeding back processing conditions.
2. The method of claim 1, wherein: The keyword selection uses a VBA program, including floor, name, volume (m3), template area (m2), remarks, and source, and the floor, name, volume (m3), template area (m2), and remarks are selected by default.
3. The method of claim 1, wherein: The new worksheet is automatically created by using a VBA program.
4. The method of claim 2, wherein: The data extraction and tracking use a VBA program to traverse the workbook worksheet title keyword, which needs to meet the floor, name, volume (m3), template area (m2), and remarks at the same time, then the workbook worksheet data is copied to the new worksheet, and the source column is written with the workbook worksheet name of the data source.
5. The method of claim 1, wherein: The feedback processing conditions use a VBA program to feed back the number of scanned worksheets.