CN115860677B - Component engineering quantity data processing method, system, equipment and storage medium - Google Patents
Component engineering quantity data processing method, system, equipment and storage medium Download PDFInfo
- Publication number
- CN115860677B CN115860677B CN202211600929.9A CN202211600929A CN115860677B CN 115860677 B CN115860677 B CN 115860677B CN 202211600929 A CN202211600929 A CN 202211600929A CN 115860677 B CN115860677 B CN 115860677B
- Authority
- CN
- China
- Prior art keywords
- engineering quantity
- component
- data
- data table
- quantity data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003860 storage Methods 0.000 title claims abstract description 9
- 238000003672 processing method Methods 0.000 title description 5
- 238000007781 pre-processing Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims abstract description 30
- 238000000034 method Methods 0.000 claims abstract description 28
- 230000002776 aggregation Effects 0.000 claims abstract description 19
- 238000004220 aggregation Methods 0.000 claims abstract description 19
- 238000004458 analytical method Methods 0.000 claims abstract description 17
- 230000010354 integration Effects 0.000 claims description 6
- 238000000605 extraction Methods 0.000 claims description 3
- 238000010276 construction Methods 0.000 claims description 2
- 238000001556 precipitation Methods 0.000 abstract description 4
- 238000009825 accumulation Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 abstract description 3
- 238000004140 cleaning Methods 0.000 abstract description 3
- 238000013461 design Methods 0.000 description 6
- 238000007405 data analysis Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000002787 reinforcement Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a system, equipment and a storage medium for processing component engineering quantity data, which are characterized in that the corresponding invalid content is cleaned by acquiring an engineering quantity data book so as to meet the warehousing standard, the information of various types of components is presented in a row form by classifying and integrating corresponding public field item columns of each preprocessing data table, the data table is transformed so as to carry out subsequent data aggregation analysis, the component engineering quantity data table is subjected to single-dimension or different-dimension aggregation analysis processing according to corresponding public fields in a data perspective table mode, the cross analysis of various component engineering quantity data can be realized, the index content of each classified engineering quantity is obtained, and the engineering quantity data difference among projects is conveniently compared. The invention can realize the automation of the component engineering quantity data table, batch data cleaning and collection, so as to quickly and efficiently obtain the classified engineering quantity indexes of various components, and is beneficial to the precipitation and accumulation of the enterprise engineering historical data.
Description
Technical Field
The invention belongs to the technical field of engineering information processing, and particularly relates to a method, a system, equipment and a storage medium for processing engineering quantity data of a component.
Background
The GTJ software is metering calculation software used in engineering and building industry, builds a building model based on various related information data of a building engineering project, obtains corresponding engineering quantity data through calculation by a built-in reinforcement leveling method, an engineering quantity list and a quota calculation rule, can be applied to the determination of engineering quantity in engineering pricing activities, and can improve engineering metering efficiency and quality.
However, the component engineering amount data produced by the current GTJ software cannot directly meet the requirements of cost measurement and data analysis, and is mainly expressed in the following steps:
1. unstructured format of the data table: the engineering quantity data tables of various types of components automatically generated by the GTJ software are different in format, and the problems that the merging unit cells, the subtotal, the total, the empty rows and the empty columns and the like cannot meet the warehouse-in requirement of a database exist, so that the engineering quantity summarization and the data analysis are affected;
2. data cannot be automatically collected: the component classification of the GTJ software is obtained by decomposing the building structure, but the similar components are required to be aggregated and calculated to obtain corresponding engineering quantity indexes during the construction cost data analysis, and the data table generated by the GTJ software can influence the data analysis effect and efficiency because the data aggregation function cannot be performed.
Due to the existence of the problems, engineering quantity data cannot be well classified and collected, and due to the fact that the format does not meet the requirements of database warehousing standards, data precipitation is difficult to carry out.
Disclosure of Invention
The invention aims to provide a method, a system, equipment and a storage medium for processing component engineering quantity data, which are used for solving the problems in the prior art.
In order to achieve the above purpose, the present invention adopts the following technical scheme:
in a first aspect, a method for processing engineering quantity data of a component is provided, including:
acquiring an engineering quantity data book derived from a BIM civil engineering metering platform, wherein the engineering quantity data book comprises a data table of various types of members;
deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, and canceling and merging the merging unit cells to obtain a preprocessing data table of each type of component;
traversing the pretreatment data tables of the various types of components, reserving common field item columns in the pretreatment data tables, and collecting the non-common field item column contents in the pretreatment data tables into the designated common field item columns;
integrating all the preprocessing data tables into a unified data table according to a common field item column, presenting information of all types of components in a row form, creating a fixed common field item column in the unified data table, extracting corresponding contents from the fixed common field item column into the set common field item column, and forming a component engineering quantity data table;
and adopting a pivot table tool to carry out single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to the corresponding public field.
Based on the technical content, the engineering quantity data book led out from the BIM civil engineering metering platform is obtained to clean corresponding invalid content so as to meet the warehousing standard, the pretreatment data tables are subjected to classification integration of corresponding public field item columns, information of various types of components is presented in a line form, data table transformation is realized so as to carry out subsequent data collection analysis, the engineering quantity data tables of the components are subjected to single-dimensional or different-dimensional aggregation analysis processing according to corresponding public fields in a data perspective table mode, cross analysis of engineering quantity data of various components can be realized so as to obtain index content of various classification engineering quantity, and engineering quantity data difference among projects can be conveniently compared.
In one possible design, the engineering quantity data book is derived from the GTJ software, and engineering quantity data of each type of component is stored in a data table unit.
In one possible design, the common field entry columns include a component type entry column, a component name entry column, a floor entry column, and an attribute entry column.
In one possible design, the grouping the non-common field entry column content in each of the pre-processing data tables into a specified common field entry column includes: the non-common field item column contents in each preprocessing data table are clustered into attribute item columns in a mode of merging character strings.
In one possible design, the creating the list of defined common field entries in the unified data table includes: a component code item column, an index content item column, a unit item column and an engineering quantity item column are newly added in a unified data table.
In one possible design, the engineering quantity data book is an Excel data book, and the method further includes: and acquiring an Excel VBA program package, implanting the Excel VBA program package into the Excel data book, and performing corresponding step processing of the engineering quantity data book by running the Excel VBA program package.
In one possible design, after forming the component engineering quantity data table, the method further includes: the component engineering quantity data table is stored in a database.
In a second aspect, a component engineering quantity data processing system is provided, including an acquisition unit, a preprocessing unit, a classification unit, an integration unit and an aggregation unit, wherein:
an acquisition unit for acquiring an engineering quantity data book derived from the BIM civil engineering metering platform, the engineering quantity data book containing data tables of various types of members;
the preprocessing unit is used for deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, canceling and merging the merging unit cells to obtain a preprocessing data table of each type of component;
the classifying unit is used for traversing the preprocessing data tables of the various types of components, reserving common field item columns in the preprocessing data tables, and collecting the contents of non-common field item columns in the preprocessing data tables into specified common field item columns;
the integration unit is used for integrating all the preprocessing data tables into a unified data table according to the public field item columns, presenting information of various types of components in a row form, creating a set public field item column in the unified data table, extracting corresponding contents from the set public field item column into the set public field item column, and forming a component engineering quantity data table;
and the aggregation unit is used for carrying out single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to the corresponding public field by adopting a pivot table tool.
In a third aspect, there is provided a component engineering quantity data processing apparatus comprising:
a memory for storing instructions;
and a processor for reading the instructions stored in the memory and executing the method according to any one of the above first aspects according to the instructions.
In a fourth aspect, there is provided a computer readable storage medium having instructions stored thereon which, when run on a computer, cause the computer to perform the method of any of the first aspects. Also provided is a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of any of the first aspects.
The beneficial effects are that: the invention cleans corresponding invalid content by acquiring the engineering quantity data book derived from the BIM civil engineering metering platform so as to meet the warehousing standard, classifies and integrates corresponding public field project columns of each preprocessing data table, presents information of various types of components in a row form, realizes data table transformation so as to carry out subsequent data aggregation analysis, carries out single-dimension or different-dimension aggregation analysis processing on the engineering quantity data table of the components according to corresponding public fields in a data perspective table mode, can realize cross analysis of engineering quantity data of various components so as to obtain index content of various classified engineering quantity, and is convenient for comparing engineering quantity data differences among projects. The invention can realize the automation of the component engineering quantity data table, batch data cleaning and collection, so as to quickly and efficiently obtain the classified engineering quantity indexes of various components, and is beneficial to the precipitation and accumulation of the enterprise engineering historical data.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of steps of a method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a system according to an embodiment of the present invention;
fig. 3 is a schematic diagram of the apparatus according to an embodiment of the present invention.
Detailed Description
It should be noted that the description of these examples is for aiding in understanding the present invention, but is not intended to limit the present invention. Specific structural and functional details disclosed herein are merely representative of example embodiments of the invention. This invention may, however, be embodied in many alternate forms and should not be construed as limited to the embodiments set forth herein.
It will be appreciated that the term "coupled" is to be interpreted broadly, and may be a fixed connection, a removable connection, or an integral connection, for example, unless explicitly stated and limited otherwise; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the terms in the embodiments can be understood by those of ordinary skill in the art according to the specific circumstances.
In the following description, specific details are provided to provide a thorough understanding of example embodiments. However, it will be understood by those of ordinary skill in the art that the example embodiments may be practiced without these specific details. For example, a system may be shown in block diagrams in order to avoid obscuring the examples with unnecessary detail. In other embodiments, well-known processes, structures, and techniques may be shown without unnecessary detail in order to avoid obscuring the embodiments.
Example 1:
the embodiment provides a method for processing engineering quantity data of a component, as shown in fig. 1, the method comprises the following steps:
s1, acquiring an engineering quantity data book derived from a BIM civil engineering metering platform, wherein the engineering quantity data book comprises data tables of all types of components.
In specific implementation, the engineering quantity data book can be exported through GTJ software, so that the engineering quantity data acquisition of the component is realized, and the specific implementation process comprises the following steps:
rule template preparation: according to the list and quota rules of different areas, all types of components are firstly drawn into one floor in GTJ software, then the ' view report ' interface is used for selecting ' civil engineering report quantity ', ' drawing input engineering quantity summary table ', then ' setting classification conditions ' are clicked, classification conditions of all components in a pop-up dialog box are set once according to requirements, the condition that the use marks of two attribute names of the component names ' and the ' floor ' are in a checked state during export is ensured, after the completion, the ' export ' button is clicked in the ' setting classification conditions ' dialog box, and the report rules of all components in each area are exported and then stored, so that rules suitable for local requirements can be imported during the follow-up export of engineering quantity data tables.
Exporting an engineering quantity data report: the method comprises the steps of selecting a civil engineering report amount, drawing and inputting an engineering amount summary table in a report viewing interface in GTJ software, clicking a classification condition setting button, clicking an import button in a classification condition setting dialog box, selecting a region and a quota rule suitable for a current project, determining import, and clicking a batch export setting button to export the engineering amount data table to the local place.
The finally derived engineering quantity data book is an Excel workbook file containing all types of component data tables, and engineering quantity data of various types of components are stored in the workbook by taking the workbook as a unit.
S2, deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, canceling and merging the merging unit cells to obtain the preprocessing data table of each type of component.
In the specific implementation, each component data table in the engineering quantity data book has a data presentation mode such as a header, a merging unit cell, a sub-meter, an aggregate and the like which do not accord with the database warehousing standard, the corresponding header content, the sub-meter content, the aggregate content and the empty row and the empty column are deleted, and the merging unit cell is canceled and merged to obtain the preprocessing data table of each type of component which accords with the database warehousing standard.
S3, traversing the pretreatment data tables of the various types of components, reserving common field item columns in the pretreatment data tables, and collecting the contents of non-common field item columns in the pretreatment data tables into the designated common field item columns.
In the specific implementation, the component types are numerous, the data tables of all the component types are not completely consistent, and all the component data tables cannot be combined into one table, so a table field system suitable for data collection of all the component data tables needs to be constructed, after traversing all the component type pretreatment data tables, common field item columns corresponding to fields such as component types, component names, floor attributes and the like in all the pretreatment data tables are determined and reserved, and other non-uniform field item columns are collected into an attribute field item column in a mode of combining character strings.
S4, integrating the pretreatment data tables into a unified data table according to the common field item columns, presenting information of various types of components in a row mode, creating a fixed common field item column in the unified data table, extracting corresponding contents from the fixed common field item column into the set common field item column, and forming a component engineering quantity data table.
When the method is implemented, after the classification of the common field item columns is completed, all the preprocessing data tables are integrated into a unified data table according to the common field item columns, field item columns with newly added setting common field items, such as component codes, index contents, units, engineering quantities and the like, are created in the unified data table, corresponding contents are extracted from the attribute field item columns into the setting common field item columns, namely character strings of all cells in the attribute field item columns are identified one by one according to set content identification and extraction rules, and the contents conforming to corresponding setting common fields are extracted into corresponding setting common field item columns. And finally forming a component engineering quantity data table to ensure that one line in the table expresses the engineering quantity of one component code of one component, so as to complete the transformation of the engineering quantity data table and realize the collection of the engineering quantity data of each component.
The implementation process of the steps S2-S4 can be automatically realized through an Excel VBA programming program, namely, firstly obtaining an Excel VBA program package after debugging is completed, then implanting the Excel VBA program package into an Excel data book, and carrying out corresponding data cleaning and collection processing of the engineering quantity data book by running the Excel VBA program package.
The finally obtained component engineering quantity data table can be stored in a local database so as to realize precipitation accumulation of enterprise engineering historical data. The warehousing processing of the component engineering quantity data table can also be automatically realized through an Excel VBA programming program.
S5, adopting a pivot table tool to conduct single-dimension or different-dimension aggregation analysis processing on the component engineering quantity data table according to the corresponding public fields.
When the method is implemented, after a final component engineering quantity data table is obtained, an Excel data pivot table tool can be utilized to conduct single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to corresponding public fields, cross analysis of various component engineering quantity data can be achieved, index content of various classified engineering quantities is obtained, and engineering quantity data differences among projects can be conveniently compared.
Example 2:
the embodiment provides a component engineering quantity data processing system, as shown in fig. 2, which comprises an acquisition unit, a preprocessing unit, a classification unit, an integration unit and an aggregation unit, wherein:
an acquisition unit for acquiring an engineering quantity data book derived from the BIM civil engineering metering platform, the engineering quantity data book containing data tables of various types of members;
the preprocessing unit is used for deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, canceling and merging the merging unit cells to obtain a preprocessing data table of each type of component;
the classifying unit is used for traversing the preprocessing data tables of the various types of components, reserving common field item columns in the preprocessing data tables, and collecting the contents of non-common field item columns in the preprocessing data tables into specified common field item columns;
the integration unit is used for integrating all the preprocessing data tables into a unified data table according to the public field item columns, presenting information of various types of components in a row form, creating a set public field item column in the unified data table, extracting corresponding contents from the set public field item column into the set public field item column, and forming a component engineering quantity data table;
and the aggregation unit is used for carrying out single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to the corresponding public field by adopting a pivot table tool.
Example 3:
the present embodiment provides a component engineering amount data processing apparatus, as shown in fig. 3, including, at a hardware level:
the data interface is used for establishing data butt joint between the processor and the memory and the external equipment so as to realize corresponding instruction interaction;
a memory for storing instructions;
and a processor for reading the instructions stored in the memory and executing the component engineering amount data processing method in embodiment 1 according to the instructions.
Optionally, the computer device further comprises an internal bus. The processor and memory and display may be interconnected by an internal bus, which may be an ISA (Industry Standard Architecture ) bus, a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus, or an EISA (Extended Industry Standard Architecture ) bus, among others. The buses may be classified as address buses, data buses, control buses, etc.
The Memory may include, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), flash Memory (Flash Memory), first-in first-out Memory (First Input First Output, FIFO), and/or first-in last-out Memory (First In Last Out, FILO), etc. The processor may be a general-purpose processor including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but also digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
Example 4:
the present embodiment provides a computer-readable storage medium having instructions stored thereon that, when executed on a computer, cause the computer to perform the component engineering amount data processing method of embodiment 1. The computer readable storage medium refers to a carrier for storing data, and may include, but is not limited to, a floppy disk, an optical disk, a hard disk, a flash Memory, and/or a Memory Stick (Memory Stick), etc., where the computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable system.
The present embodiment also provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the component engineering amount data processing method of embodiment 1. Wherein the computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable system.
Finally, it should be noted that: the foregoing description is only of the preferred embodiments of the invention and is not intended to limit the scope of the invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (7)
1. A method of processing construction quantity data, comprising:
acquiring an engineering quantity data book derived from a BIM civil engineering metering platform, wherein the engineering quantity data book comprises a data table of various types of members;
deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, and canceling and merging the merging unit cells to obtain a preprocessing data table of each type of component;
traversing pretreatment data tables of various types of components, reserving common field item columns in each pretreatment data table, wherein the common field item columns comprise component type item columns, component name item columns, floor item columns and attribute item columns, and collecting non-common field item column contents in each pretreatment data table into the attribute item columns in a mode of merging character strings;
integrating all the pretreatment data tables into a unified data table according to a common field item column, presenting information of all types of components in a row form, newly creating a component code item column, an index content item column, a unit item column and an engineering quantity item column in the unified data table, and then identifying and extracting corresponding contents from the attribute item column of each pretreatment data table according to a set content identification and extraction rule to form a component engineering quantity data table;
and adopting a pivot table tool to carry out single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to the corresponding public field.
2. The method for processing engineering quantity data of components according to claim 1, wherein the engineering quantity data book is derived from GTJ software, and engineering quantity data of each type of component is stored in units of data tables.
3. The method of claim 1, wherein the engineering quantity data book is an Excel data book, and the method further comprises: and acquiring an Excel VBA program package, implanting the Excel VBA program package into the Excel data book, and performing corresponding step processing of the engineering quantity data book by running the Excel VBA program package.
4. The method of processing component engineering amount data according to claim 1, wherein after forming the component engineering amount data table, the method further comprises: the component engineering quantity data table is stored in a database.
5. The component engineering quantity data processing system is characterized by comprising an acquisition unit, a preprocessing unit, a classifying unit, an integration unit and an aggregation unit, wherein:
an acquisition unit for acquiring an engineering quantity data book derived from the BIM civil engineering metering platform, the engineering quantity data book containing data tables of various types of members;
the preprocessing unit is used for deleting the header content, the sub-meter content, the total content and the empty row and column of each type of component data table in the engineering quantity data book, canceling and merging the merging unit cells to obtain a preprocessing data table of each type of component;
the classifying unit is used for traversing the preprocessing data tables of the various types of components, reserving common field item columns in the preprocessing data tables, wherein the common field item columns comprise component type item columns, component name item columns, floor item columns and attribute item columns, and collecting the contents of non-common field item columns in the preprocessing data tables into the attribute item columns in a mode of merging character strings;
an integrating unit, configured to integrate each preprocessing data table into a unified data table according to a common field item column, present information of each type of component in a form of a row, newly add and create a component code item column, an index content item column, a unit item column and an engineering quantity item column in the unified data table, and then identify and extract corresponding content from the attribute item column of each preprocessing data table to the component code item column, the index content item column, the unit item column and the engineering quantity item column according to a set content identification and extraction rule, so as to form a component engineering quantity data table;
and the aggregation unit is used for carrying out single-dimensional or different-dimensional aggregation analysis processing on the component engineering quantity data table according to the corresponding public field by adopting a pivot table tool.
6. A component engineering quantity data processing apparatus, characterized by comprising:
a memory for storing instructions;
a processor for reading instructions stored in said memory and performing the method according to any one of claims 1-4 in accordance with the instructions.
7. A computer readable storage medium having instructions stored thereon which, when run on a computer, cause the computer to perform the method of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211600929.9A CN115860677B (en) | 2022-12-12 | 2022-12-12 | Component engineering quantity data processing method, system, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211600929.9A CN115860677B (en) | 2022-12-12 | 2022-12-12 | Component engineering quantity data processing method, system, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115860677A CN115860677A (en) | 2023-03-28 |
| CN115860677B true CN115860677B (en) | 2024-03-22 |
Family
ID=85672614
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211600929.9A Active CN115860677B (en) | 2022-12-12 | 2022-12-12 | Component engineering quantity data processing method, system, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115860677B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6626959B1 (en) * | 1999-06-14 | 2003-09-30 | Microsoft Corporation | Automatic formatting of pivot table reports within a spreadsheet |
| CN102508850A (en) * | 2011-09-29 | 2012-06-20 | 用友软件股份有限公司 | Form data processing device and form data processing method |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| CN108491510A (en) * | 2018-03-22 | 2018-09-04 | 平安科技（深圳）有限公司 | Excel data import method, apparatus, computer equipment and the storage medium of database |
| WO2019205415A1 (en) * | 2018-04-22 | 2019-10-31 | 平安科技（深圳）有限公司 | Data import management method and apparatus, mobile terminal and storage medium |
| CN111046035A (en) * | 2019-10-29 | 2020-04-21 | 三盟科技股份有限公司 | Data automation processing method, system, computer equipment and readable storage medium |
| CN112286934A (en) * | 2020-10-29 | 2021-01-29 | 平安信托有限责任公司 | Database table importing method, device, equipment and medium |
| CN112559526A (en) * | 2020-12-15 | 2021-03-26 | 中国平安人寿保险股份有限公司 | Data table export method and device, computer equipment and storage medium |
| CN113127482A (en) * | 2019-12-31 | 2021-07-16 | 奇安信科技集团股份有限公司 | Data quality analysis method and device, computer equipment and storage medium |
| CN114357943A (en) * | 2021-12-03 | 2022-04-15 | 北京复兴华创技术有限公司 | Universal efficient Excel reading processing method, tool, medium and equipment |
| CN114881313A (en) * | 2022-04-26 | 2022-08-09 | 深圳平安综合金融服务有限公司 | Behavior prediction method and device based on artificial intelligence and related equipment |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327851A1 (en) * | 2008-06-27 | 2009-12-31 | Steven Raposo | Data analysis method |
-
2022
- 2022-12-12 CN CN202211600929.9A patent/CN115860677B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6626959B1 (en) * | 1999-06-14 | 2003-09-30 | Microsoft Corporation | Automatic formatting of pivot table reports within a spreadsheet |
| CN102508850A (en) * | 2011-09-29 | 2012-06-20 | 用友软件股份有限公司 | Form data processing device and form data processing method |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| CN108491510A (en) * | 2018-03-22 | 2018-09-04 | 平安科技（深圳）有限公司 | Excel data import method, apparatus, computer equipment and the storage medium of database |
| WO2019205415A1 (en) * | 2018-04-22 | 2019-10-31 | 平安科技（深圳）有限公司 | Data import management method and apparatus, mobile terminal and storage medium |
| CN111046035A (en) * | 2019-10-29 | 2020-04-21 | 三盟科技股份有限公司 | Data automation processing method, system, computer equipment and readable storage medium |
| CN113127482A (en) * | 2019-12-31 | 2021-07-16 | 奇安信科技集团股份有限公司 | Data quality analysis method and device, computer equipment and storage medium |
| CN112286934A (en) * | 2020-10-29 | 2021-01-29 | 平安信托有限责任公司 | Database table importing method, device, equipment and medium |
| CN112559526A (en) * | 2020-12-15 | 2021-03-26 | 中国平安人寿保险股份有限公司 | Data table export method and device, computer equipment and storage medium |
| CN114357943A (en) * | 2021-12-03 | 2022-04-15 | 北京复兴华创技术有限公司 | Universal efficient Excel reading processing method, tool, medium and equipment |
| CN114881313A (en) * | 2022-04-26 | 2022-08-09 | 深圳平安综合金融服务有限公司 | Behavior prediction method and device based on artificial intelligence and related equipment |
Non-Patent Citations (1)
| Title |
|---|
| 基于大数据架构的全过程工程咨询项目管理平台;潘多忠;程嘉;余渊;;土木建筑工程信息技术(第06期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115860677A (en) | 2023-03-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110309131A (en) | The method for evaluating quality and device of massive structured data | |
| CN111428599A (en) | Bill identification method, device and equipment | |
| CN112163553B (en) | Material price accounting method, device, storage medium and computer equipment | |
| CN111680855A (en) | Automatic risk detection and early warning method and system for whole process of project | |
| CN111553137B (en) | Report generation method and device, storage medium and computer equipment | |
| CN111143516A (en) | Article search result display method and related device | |
| CN115730605A (en) | Data analysis method based on multi-dimensional information | |
| CN104133838A (en) | Data processing method and system with system detection function | |
| CN114356940A (en) | Power grid data management platform and method | |
| CN111179068A (en) | Method, device and storage medium for determining enterprise performance credit level | |
| CN111143394B (en) | Knowledge data processing method, device, medium and electronic equipment | |
| CN112328805A (en) | Entity mapping method of vulnerability description information and database table based on NLP | |
| CN115860677B (en) | Component engineering quantity data processing method, system, equipment and storage medium | |
| CN113159118A (en) | Logistics data index processing method, device, equipment and storage medium | |
| CN112036150A (en) | Electricity price policy term analysis method, storage medium and computer | |
| CN110287114B (en) | Method and device for testing performance of database script | |
| CN114511174A (en) | Service index map construction method and device | |
| CN113642291B (en) | Method, system, storage medium and terminal for constructing logical structure tree reported by listed companies | |
| CN115470279A (en) | Data source conversion method, device, equipment and medium based on enterprise data | |
| Zou | Research on data cleaning in big data environment | |
| CN113190666A (en) | Industrial intellectual property analysis method, system, equipment and storage medium | |
| CN111882289A (en) | Device and method for measuring and calculating item data audit index interval | |
| CN109739839A (en) | Data processing empty value method, apparatus and terminal device | |
| CN112925856B (en) | Entity relationship analysis method, entity relationship analysis device, entity relationship analysis equipment and computer storage medium | |
| WO2023063082A1 (en) | Information processing device for intellectual property rights-related application, method, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address | ||
| CP03 | Change of name, title or address |
Address after: Room 509, Research Office Building, No. 2 Xincensi Road, Tianhe District, Guangzhou City, Guangdong Province, 510000 Patentee after: Zhongqian Engineering Consulting Co.,Ltd. Country or region after: China Address before: Floor 6 and 7, No. 234, Gaotang Road, Tianhe District, Guangzhou, Guangdong Province, 510000 Patentee before: Zhongqian Engineering Consulting Co.,Ltd. Country or region before: China |