CN115630620A - Method and system for collecting and processing engineering cost analysis data - Google Patents

Method and system for collecting and processing engineering cost analysis data Download PDF

Info

Publication number
CN115630620A
CN115630620A CN202211348530.6A CN202211348530A CN115630620A CN 115630620 A CN115630620 A CN 115630620A CN 202211348530 A CN202211348530 A CN 202211348530A CN 115630620 A CN115630620 A CN 115630620A
Authority
CN
China
Prior art keywords
sub
data
list
header
general
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.)
Granted
Application number
CN202211348530.6A
Other languages
Chinese (zh)
Other versions
CN115630620B (en
Inventor
许学雷
薛晓倩
华锴
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhongcheng Zhixin Engineering Consulting Group Co ltd
Original Assignee
Zhongcheng Zhixin Engineering Consulting Group Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Zhongcheng Zhixin Engineering Consulting Group Co ltd filed Critical Zhongcheng Zhixin Engineering Consulting Group Co ltd
Priority to CN202211348530.6A priority Critical patent/CN115630620B/en
Publication of CN115630620A publication Critical patent/CN115630620A/en
Application granted granted Critical
Publication of CN115630620B publication Critical patent/CN115630620B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0283—Price estimation or determination
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/08—Construction

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Strategic Management (AREA)
  • General Engineering & Computer Science (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Development Economics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Game Theory and Decision Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Primary Health Care (AREA)
  • Tourism & Hospitality (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a method and a system for acquiring and processing engineering cost analysis data, which are applied to the field of engineering cost data processing, wherein the method comprises the following steps: when a sub-table to be integrated is obtained, sequentially identifying sub-table list headers inside the sub-table; inquiring a general table list header corresponding to the sub table list header and a standard format corresponding to the general table list header in a preset general table according to the sub table list header; clearing the format of the column data corresponding to the sub-table column header, and resetting the column data after clearing the format according to the standard format to obtain standard data; correspondingly integrating the sub-tables into a preset general table when the column data corresponding to the column headers of all the sub-tables in the sub-tables are reset as standard data; and outputting the general table when all the sub-tables to be integrated are integrated into the general table. The application has the technical effects that: the effect of automatically adjusting and integrating the sub-tables according to the format and the arrangement requirement of the general table is realized; therefore, the integration efficiency of the sub-table data is improved.

Description

Method and system for collecting and processing engineering cost analysis data
Technical Field
The application relates to the technical field of engineering cost data processing, in particular to a method and a system for acquiring and processing engineering cost analysis data.
Background
The project cost analysis refers to the analysis of estimation, approximate calculation, budget and final calculation of the determined project cost in different stages, and is used for commenting the economic rationality of the determined project cost; and through analysis, the possibility of reducing the construction cost and the measures to be taken are sought.
In the process of collecting and processing engineering cost analysis data, in order to improve the collection efficiency and share the data collection pressure, the collection requirement of the same data is often distributed to different responsible persons for collection respectively, and then sub-tables sent by different responsible persons are combined into a general table, so that the collection and integration of the data are completed.
In the process of implementing the present application, the inventors found that at least the following problems exist in the process of collecting and integrating the data of the sub-tables: the data formats and the arrangement positions of the column header of different sub-tables may be different, so that data integration personnel cannot directly integrate a plurality of sub-tables into the same general table, and the efficiency of data integration is poor.
Disclosure of Invention
In order to help to improve the efficiency of data integration, the method and the system for collecting and processing the engineering cost analysis data are provided.
In a first aspect, the present application provides a method for collecting and processing engineering cost analysis data, which adopts the following technical scheme: the method comprises the following steps:
when a sub-table to be integrated is obtained, sequentially identifying sub-table list headers inside the sub-table;
inquiring a general table list header corresponding to the sub-table list header and a standard format corresponding to the general table list header in a preset general table according to the sub-table list header;
clearing the format of the line data corresponding to the sub-table column header, and resetting the line data after clearing the format according to the standard format to obtain standard data;
when the column data corresponding to all the column headers of the sub-tables are reset as standard data, correspondingly integrating the sub-tables into a preset general table;
and outputting the general table when all the sub-tables to be integrated are integrated into the general table.
According to the technical scheme, when the sub-tables to be integrated are received, firstly, the general table list header corresponding to each sub-table list header and the standard format of the general table list header are determined, then, the format of the data corresponding to each sub-table list header is adjusted to the standard format, and then, the sub-tables with the formats adjusted are correspondingly integrated into the general table, so that the unified integration of the sub-table data is completed; before the data of the sub-tables are integrated, the formats of the column data in the sub-tables are unified, so that the possibility that the sub-tables are difficult to be directly integrated into the general table or the column header cannot be normally displayed after the sub-tables are integrated due to different data formats of different sub-tables and different arrangement positions of the column header is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the general table is realized; therefore, the integration efficiency of the sub-table data is improved.
In a specific implementation, the preset summary table further includes a fuzzy name library corresponding to the header name of each summary table, and the fuzzy name library includes a fuzzy name corresponding to each header of the summary table;
the querying, according to the sub-table list header, a total table list header corresponding to the sub-table list header in a preset total table includes:
if the preset summary table has a summary table list header identical to the sub-table list header; setting the head of the general list which is the same as the head of the sub list as the head of the general list corresponding to the head of the sub list;
if the preset general table does not have a general table list header identical to the sub-table list header; inquiring whether a fuzzy name which is the same as the head of the word list column exists in the fuzzy name library or not;
and if the fuzzy name same as the sub-list header exists, setting the total list header corresponding to the fuzzy name as the total list header corresponding to the sub-list header.
According to the technical scheme, when the general table does not have the general table list head which is the same as the sub table list head to be matched currently, the fuzzy name which is the same as the sub table list head in the fuzzy name library is inquired, and then the general table list head corresponding to the fuzzy name is set as the general table list head corresponding to the sub table list head; the possibility that partial sub-table list headers cannot find corresponding total table list headers in the total table due to the difference between the naming mode of the sub-table list headers and the total table list headers is reduced, and therefore the integration effect of sub-table data is improved.
In a specific implementation, after the querying whether there is an ambiguous name in the ambiguous name database that is the same as the subject of the word list, the method further includes:
if the fuzzy name same as the sub-list head does not exist, acquiring a first pinyin letter corresponding to the sub-list head;
respectively acquiring second phonetic letters corresponding to all the general table list headers;
comparing the first phonetic alphabet with all the second phonetic alphabets;
if all the second pinyin letters have the target pinyin letters which are the same as the first pinyin letters, setting the head of the general list corresponding to the target pinyin grandmother as the head of the general list corresponding to the head of the sub list.
By the technical scheme, when the fuzzy name which is the same as the sub-list head cannot be inquired in the fuzzy name library, the main list head corresponding to the sub-list head can be determined by utilizing a mode of judging whether the first pinyin letter of the sub-list head is consistent with the second pinyin letter of the main list head, so that the corresponding main list head can be correspondingly searched by partial sub-list heads with homophones and mispronounces, and the integration effect of sub-list data is further improved.
In a specific implementation, after the querying whether there is an ambiguous name in the ambiguous name database that is the same as the subject of the word list, the method further includes:
if the fuzzy name same as the sub-table list header does not exist, identifying the original format of the line data corresponding to the sub-table list header;
comparing the original format with a standard format in the summary table;
if only one standard format is the same as the original format, the total list header corresponding to the standard format which is the same as the original format is set as the total list header corresponding to the sub list header.
Through the technical scheme, when the fuzzy name which is the same as the sub-table column header cannot be inquired in the fuzzy name library, the total table column header which is the same as the original format and corresponds to the standard format can be set as the total table column header which is corresponding to the sub-table column header in a mode of inquiring whether the standard format which is corresponding to the original format of the sub-table column header is unique; the possibility that the sub-table list header is difficult to find the matched total table list header is further reduced, and therefore the integration effect of the sub-table data is further improved.
In a specific embodiment, said integrating the sub-table correspondence into a preset general table includes:
traversing the cells in the sub-table, and judging whether blank cells exist in the sub-table;
if no blank cell exists in the sub-table, correspondingly integrating the sub-table into a preset general table;
if the blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprises column header names corresponding to the blank cells, line sequence numbers corresponding to the blank cells and file names of the sub-table;
correspondingly filling the positioning data and the blank cells into a preset modification bullet frame, wherein the modification bullet frame comprises a display area of the positioning data and a filling area of the blank cells;
outputting the modification popup frame in a popup window mode;
and correspondingly filling and writing the filling data into the blank cells when the filling data input by the filling area is received.
Through the technical scheme, after the column data format of the sub-table is adjusted, whether blank cells exist in the sub-table or not is checked firstly, if the blank cells exist, the column header names corresponding to the blank cells, the row sequence numbers corresponding to the blank cells, the file names of the sub-table and other positioning data are recorded, then the positioning data and the blank cells are popped up in the form of the pop-up frame, so that a user can conveniently supplement or modify the blank cells, the workload of the user in the process of supplementing the data corresponding to the blank cells is reduced on the one hand, and the efficiency of sub-table data integration is improved on the other hand.
In a specific possible implementation, before the correspondingly filling the positioning data and the blank cells into a preset modification bullet box, the method further includes:
acquiring a line data screenshot between a line sequence number cell corresponding to a blank cell and the blank cell;
generating a thumbnail corresponding to the column data screenshot;
acquiring data of a previous cell and data of a next cell of the blank cell;
correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps:
correspondingly filling the positioning data, the thumbnail, the data of the previous cell, the data of the next cell and the blank cell into a preset modification bullet frame;
and outputting a column data screenshot corresponding to the thumbnail when a viewing request for the thumbnail is received.
By the technical scheme, when the bullet frame which needs the user to supplement the blank cell data is output,
meanwhile, reference data such as column data between the row sequence number unit cell corresponding to the blank unit cell and the blank unit cell, data of the last unit cell of the blank unit cell, data of the next unit cell and the like are integrated and displayed in the bullet frame, so that a user can quickly supplement the blank unit cell according to the reference data displayed in the bullet frame, and convenience of the user in supplementing the blank unit cell is improved.
In a specific possible implementation, the correspondingly filling the filling data into the blank cells includes:
carrying out consistency comparison on a data format corresponding to the filling data and a standard format corresponding to the blank cell;
if the data are consistent, correspondingly filling the filling data into the blank cells;
if not, adjusting the data format of the filling data to a standard format;
and filling and writing the filling data adjusted to the standard format into the blank cells.
By the technical scheme, when the filling data aiming at the blank cells are received, the data format of the filling data is automatically checked to ensure that the filling data format is the same as the standard format corresponding to the blank cells; the possibility that the filled data cannot be normally displayed after being supplemented into the general table due to the fact that the data format filled by the blank cells is inconsistent with the standard format corresponding to the blank cells is reduced, and therefore the integration effect of the sub-table data is further improved.
In a second aspect, the present application provides a system for collecting and processing engineering cost analysis data, which adopts the following technical solution: the system comprises:
the sub-table information acquisition module is used for sequentially identifying sub-table list headers in the sub-tables when the sub-tables to be integrated are acquired;
the standard format query module is used for querying a general table list header corresponding to the sub table list header and a standard format corresponding to the general table list header in a preset general table according to the sub table list header;
the standard format setting module is used for clearing the format of the line data corresponding to the sub-table column header and resetting the line data after the format is cleared according to the standard format to obtain standard data;
the sub-table data integration module is used for correspondingly integrating the sub-tables into a preset general table when the column data corresponding to the column headers of all the sub-tables in the sub-tables are reset as standard data;
and the general table data output module is used for outputting the general table when all the sub-tables to be integrated are integrated into the general table.
According to the technical scheme, when the sub-tables to be integrated are received, the general table list head corresponding to each sub-table list head and the standard format of the general table list head are determined, then the format of the data corresponding to each sub-table list head is adjusted to the standard format, and then the sub-tables with the adjusted formats are correspondingly integrated into the general table, so that the sub-table data are integrated uniformly; before the data of the sub-tables are integrated, the formats of the column data in the sub-tables are unified, so that the possibility that the sub-tables are difficult to be directly integrated into the general table or the column header cannot be normally displayed after the sub-tables are integrated due to different data formats of different sub-tables and different arrangement positions of the column header is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the general table is realized; therefore, the integration efficiency of the sub-table data is improved.
In a third aspect, the present application provides a computer device, which adopts the following technical solution: comprising a memory and a processor, the memory having stored thereon a computer program capable of being loaded by the processor and executing any of the methods of cost analysis data collection and processing described above.
In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solutions: a computer program is stored which can be loaded by a processor and which implements any of the above-described methods of project cost analysis data collection and processing.
In summary, the present application includes at least one of the following beneficial technical effects:
1. when the sub-tables to be integrated are received, firstly, determining a total table list header corresponding to each sub-table list header and a standard format of the total table list header, then respectively adjusting the format of the data corresponding to each sub-table list header into the standard format, and then correspondingly integrating the sub-tables with the adjusted formats into the total table, thereby completing the unified integration of the sub-table data; before the data of the sub-tables are integrated, the formats of the column data in the sub-tables are unified, so that the possibility that the data formats of different sub-tables and the arrangement positions of column header are different, the sub-tables are difficult to be directly integrated into the general table or the partial data cannot be normally displayed after the sub-tables are integrated is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and the arrangement requirement of the general table is realized; therefore, the integration efficiency of the sub-table data is improved;
2. when the fuzzy name same as the sub-list head cannot be inquired in the fuzzy name library, the main list head corresponding to the sub-list head can be determined by utilizing the mode of judging whether the first phonetic letters of the sub-list head are consistent with the second phonetic letters of the main list head, so that the sub-list head with part of homophones and mispronounces can also be correspondingly searched for the corresponding main list head, and the integration effect of sub-list data is further improved.
Drawings
FIG. 1 is a flow chart of a method for acquiring and processing project cost analysis data in an embodiment of the present application.
Fig. 2 is a schematic diagram for embodying a fuzzy database setting form according to an embodiment of the present application.
Fig. 3 is a schematic diagram for embodying a modified bullet frame arrangement manner in the embodiment of the present application.
Fig. 4 is a block diagram of a system for collecting and processing engineering cost analysis data according to an embodiment of the present invention.
Reference numerals: 401. a sub-table information acquisition module; 402. a standard format query module; 403. a standard format setting module; 404. a sub-table data integration module; 405. and a summary data output module.
Detailed Description
The present application is described in further detail below with reference to figures 1-4.
The embodiment of the application discloses a method for collecting and processing engineering cost analysis data, which is applied to a data integration platform, wherein the data integration platform can be a program running on an intelligent terminal such as a computer, a tablet or a mobile phone, the data integration platform can receive or output data by means of the intelligent terminal, and information interaction can be realized with a user by using an input/output device such as a touch display screen or a mouse, a keyboard and a display screen of the intelligent device.
As shown in fig. 1, the method comprises the steps of:
and S10, sequentially identifying the sub-table list headers in the sub-tables when the sub-tables to be integrated are obtained.
Specifically, when a plurality of sub-tables need to be integrated into a preset general table, a user can firstly input the sub-tables to be integrated into the data integration platform, and the data integration platform can sequentially identify the sub-table list header in each sub-table in a character identification mode after receiving the sub-tables to be integrated input by the user; for example, the name of the head of the first sub-table column corresponding to sub-table a is "item name".
And S20, inquiring the general table list header corresponding to the sub table list header and the standard format corresponding to the general table list header in the preset general table according to the sub table list header.
Specifically, the data in the general table is preset and input by background staff, and comprises a plurality of general table list headers corresponding to the sub-table list headers; that is, the data corresponding to the summary list header in the summary list is the data that the user needs to integrate, and the standard format corresponding to the summary list header is the format that the user needs; after identifying the sub-table list header in the sub-table, the data integration platform first queries the same general table list header as the sub-table list header in the general table and the standard format corresponding to the general table list header.
It should be noted that, if the preset summary table is not unique, after the user inputs the sub-tables to be integrated, the user needs to select the summary table to be integrated, and then the data integration platform integrates the sub-tables according to the summary table selected by the user.
And S30, eliminating the format of the column data corresponding to the sub-table column header, and resetting the column data after the format is eliminated according to the standard format to obtain the standard data.
Specifically, after querying a standard format corresponding to the sub-table list header, the data integration platform deletes an original data format of the line data corresponding to the sub-table list header, and then resets the line data with the format removed according to the standard format to obtain the standard data; the data corresponding to the standard data is still the original column data in the word table, but the data format corresponding to the standard data is the standard format required in the general table.
S40, when the column data corresponding to the column headers of all the sub-tables in the sub-table are reset to be standard data, correspondingly integrating the sub-tables into a preset general table.
Specifically, the data integration platform may sequentially adjust the column data in the sub-table from left to right, and when all the column data in the currently processed sub-table are adjusted to be the standard data, the sub-table is correspondingly integrated into the preset general table, that is, the column data in the sub-table is respectively and correspondingly copied to the lower areas of the column headers of different general tables in the general table.
And S50, outputting the general table when all the sub-tables to be integrated are integrated into the general table.
Specifically, when all the sub-table data to be integrated are integrated into the general table, the data integration platform outputs the general table formed after integration, and then the user can obtain the integrated data general table by downloading the general table output by the data integration platform; when data integration is carried out on the plurality of sub-tables, a user only needs to input the plurality of sub-tables into the data integration platform, the data integration platform can automatically identify the corresponding relation between the sub-tables and the general table, then automatically adjust the data in the sub-tables into the data format in the general table, and integrate the data in the sub-tables into the general table according to the arrangement scheme of the head of the general table, so that the possibility that the sub-tables are difficult to be directly integrated into the general table or the partial data cannot be normally displayed after integration due to different data formats of different sub-tables and different arrangement positions of the head of the general table is reduced; therefore, the integration efficiency of the sub-table data is improved.
In one embodiment, in conjunction with fig. 2, it is considered that there may be inconsistencies between the names of the partial sub-list headers and the overall list header, such as "count date" for the overall list header and "count time" for the sub-list headers; then, the sub-list header cannot find the corresponding general list header; the preset general table also comprises a fuzzy name library corresponding to the head name of each general table list, and the fuzzy name library is preset and recorded by background staff and comprises fuzzy names corresponding to each general table list head; for example: for the header of the general list of "accounting date", the corresponding fuzzy name may be "accounting date", "accounting time", and the like.
The step of the data integration platform querying the summary table entry header corresponding to the sub table entry header in the preset summary table according to the sub table entry header may be specifically executed as:
if the preset general table has a general table list head which is the same as the sub-table list head, namely, the general table has a general table list head which is consistent with the sub-table list head expression; setting the head of the general list which is the same as the head of the sub list as the head of the general list corresponding to the head of the sub list; if the preset general table does not have the general table list head which is the same as the sub table list head, namely, the general table does not have the general table list head which is consistent with the sub table list head expression; the data integration platform continues to inquire whether a fuzzy name which is the same as the sub-table list header exists in the fuzzy name library; if the fuzzy name corresponding to the sub-list head exists, setting the general list head corresponding to the fuzzy name as the general list head corresponding to the sub-list head; based on the foregoing example, for the sub-list header of the "accounting time", since the corresponding total list header is called "accounting day", the data integration platform cannot find the total list header identical to the sub-list header, and then the data integration platform can find the fuzzy name identical to the "accounting time" in the fuzzy name library, and the total list header corresponding to the fuzzy name of the "accounting time" is called "accounting day", at this time, the data integration platform determines that the sub-list header "accounting time" and the total list header "accounting day" correspond to each other. The arrangement of the fuzzy name library enables the data integration platform to quickly find the general list head corresponding to the sub list head by means of matching the fuzzy name aiming at the sub list head with a partial expression mode inconsistent with the general list head, so that the possibility that the sub list head is difficult to find the corresponding general list head to cause integration interruption is reduced, and the stability and the integration effect of sub list data integration are improved.
In one embodiment, when a sub-table editor edits a sub-table list header, a situation that the name of the sub-table list header has homophonic and wrongly written characters due to incorrect editing may exist, and then a data integration platform is difficult to find a total table list header consistent with the sub-table list header having homophonic and wrongly written characters is considered; for example, the sub-table header "accounting date" is wrongly edited by the sub-table editor to "nucleic acid date", which leads to a situation that the sub-table header cannot find the total table header corresponding to the sub-table header, i.e., "accounting date"; in order to further improve the data integration effect of the data integration platform; after the data integration platform queries whether the fuzzy name library has the fuzzy name which is the same as the head of the word list, the following steps can be continuously executed:
if the fuzzy name library does not have the fuzzy name same as the sub-list item header, the data integration platform sequentially acquires a first pinyin letter corresponding to the sub-list item header and second pinyin letters corresponding to all the general-list item headers, and then compares the first pinyin letter with all the second pinyin letters; if all the second pinyin letters have the target pinyin letters which are the same as the first pinyin letters, setting the head of the general list corresponding to the target pinyin grandmother as the head of the general list corresponding to the head of the sub-list; based on the foregoing example, the first pinyin character corresponding to the sub-table header "nucleic acid day" is "hesuanri", and the second pinyin character corresponding to the general table header "accounting day" is also "hesuanri"; that is, the data integration platform can quickly find the general table list header corresponding to the sub table list header with homophonic wrongly written characters by using a pinyin comparison mode under the condition that homophonic wrongly written characters exist in the sub table list header, thereby further improving the data integration effect of the data integration platform on the sub table.
In one embodiment, in order to further improve the effect of the data integration platform in integrating the sub-table data; after the data integration platform queries whether the fuzzy name library has the fuzzy name which is the same as the head of the word list, the following steps can be continuously executed:
if the fuzzy name library does not have the fuzzy name which is the same as the sub-table list header, the data integration platform can also identify the original format of the column data corresponding to the sub-table list header, then the original format is compared with all standard formats in the general table, and if only one standard format which is the same as the original format exists, the general table list header corresponding to the standard format which is the same as the original format is set as the general table list header corresponding to the sub-table list header; otherwise, sending out a reminding message to prompt the user to modify the sub-list header which cannot be identified; for example, if the data format corresponding to the sub-list header "accounting" is a date format, and only the standard format corresponding to the "accounting date" in all the total list headers is a date format, if the data integration platform does not inquire the same total list header and fuzzy name as the "accounting", the "accounting date" is set as the total list header corresponding to the "accounting" because the data format corresponding to the "accounting" and the standard format corresponding to the "accounting date" form a single correspondence relationship; the data integration platform can also quickly find the general table list head corresponding to the sub table list head by means of judging whether the sub table list head format and the general table list head format with a single corresponding relation exist, so that the effect of the data integration platform in integrating the sub table data is further improved.
In one embodiment, considering that blank cells for inputting column data may be omitted by a sub-table editor, if sub-table data with blank cells is directly integrated into a general table, the blank cells in the general table are difficult to trace and modify, so as to further improve the integration effect of a data integration platform on sub-table data; the step of the data integration platform correspondingly integrating the sub-tables into the preset general table may be specifically executed as:
when the column data corresponding to the column headers of all the sub-tables in the sub-table are reset as standard data, the data integration platform firstly traverses the cells in the sub-table to judge whether blank cells exist in the sub-table, and if no blank cells exist in the sub-table, the step of correspondingly integrating the sub-table into a preset general table is executed; if blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprise column header names corresponding to the blank cells, line sequence numbers corresponding to the blank cells and file names of the sub-table; then correspondingly filling the positioning data and the blank cells into a preset modification bullet frame, wherein the modification bullet frame comprises a display area of the positioning data and a filling area of the blank cells, and then outputting and displaying the generated bullet frame in a bullet frame mode, so that a user can conveniently refer to the display of the display area information in the bullet frame and correspondingly fill data in the blank cells; when the data integration platform receives filling data input by a user in a filling area, the filling data are correspondingly filled into the blank cells, so that the blank cells are filled; aiming at the condition that blank cells exist in the sub-tables, the data integration platform can display the related information of the blank cells in a form of a bullet frame, so that a user can directly and quickly complete the supplement of data in the blank cells in a mode of supplementing the data in the bullet frame, and the sub-tables with the blank cells do not need to be submitted again after being withdrawn and modified again, so that the efficiency of the user in supplementing the blank cells is improved on one hand, and the efficiency of the data integration platform in integrating the data of the sub-tables is also improved on the other hand.
In one embodiment, in order to further improve the efficiency and convenience when the user fills the blank cells; before the data integration platform correspondingly fills the positioning data and the blank cells into the preset modification bullet frame, the following steps can be executed:
after the data integration platform records positioning data, firstly acquiring a line data screenshot between a line number cell corresponding to a blank cell and the blank cell, and then generating a thumbnail corresponding to the line data screenshot; and acquiring data of a previous cell and data of a next cell of the blank cell while generating the thumbnail.
The step of the data integration platform correspondingly filling the positioning data and the blank cells into the preset modification bullet frame may be further performed as: correspondingly filling the positioning data, the thumbnail, the data of the previous cell, the data of the next cell and the blank cell into a preset modification bullet frame; the arrangement mode of the modified bullet frames can be as shown in figure 3; then, when receiving a viewing request for the thumbnail, the data integration platform outputs a column data screenshot corresponding to the thumbnail; that is, when the user clicks the thumbnail area, the data integration platform can show the column data screenshot corresponding to the thumbnail for the user, so that the user can further refer to the column data screenshot, and the data of the last cell of the blank cell and the data of the next cell of the blank cell are quickly filled in the blank cell, thereby further improving the efficiency and convenience of the user in filling the blank cell.
In one embodiment, a situation that the data filled in the blank cells by the user may not be displayed normally after being integrated into the summary sheet due to the fact that the data format filled in the blank cells by the user may be different from the standard format corresponding to the blank cells is considered; the step of correspondingly filling the filling data into the blank cells may be specifically performed as:
after receiving filling data input by a filling area, a data integration platform firstly carries out consistency comparison on a data format corresponding to the filling data and a standard format corresponding to a blank cell; if the data format corresponding to the filling data is consistent with the standard format corresponding to the blank cell, directly filling the filling data into the blank cell correspondingly; otherwise, the format adjustment of the filling data is replaced by a standard format, and then the filling data which is adjusted and replaced by the standard format is filled into the blank cells, so that when the filling data in the blank cells is integrated into the summary sheet, the data format corresponding to the filling data can be the same as the standard format corresponding to the blank cells, and the filling data can be normally displayed in the summary sheet.
FIG. 1 is a flow diagram illustrating a method for collecting and processing engineering cost analysis data according to one embodiment. It should be understood that, although the steps in the flowchart of fig. 1 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows; the steps are not limited to be performed in the exact order disclosed, and steps may be performed in other orders, unless explicitly stated otherwise; and at least some of the steps in fig. 1 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least some of the sub-steps or stages of other steps.
Based on the method, the embodiment of the application also discloses a system for acquiring and processing the engineering cost analysis data.
As shown in fig. 4, the system includes the following modules:
a sub-table information obtaining module 401, configured to sequentially identify sub-table list headers inside the sub-tables when obtaining the sub-tables to be integrated;
a standard format query module 402, configured to query, according to the sub-table list header, a total table list header corresponding to the sub-table list header and a standard format corresponding to the total table list header in a preset total table;
a standard format setting module 403, configured to clear a format of the column data corresponding to the sub-table column header, and reset the column data with the cleared format according to the standard format to obtain standard data;
a sub-table data integration module 404, configured to correspondingly integrate the sub-tables into a preset general table when the line data corresponding to the column headers of all the sub-tables in the sub-table are reset to be standard data;
a summary table data output module 405, configured to output a summary table when all the sub-tables to be integrated are integrated into the summary table.
In one embodiment, the preset summary table further includes a fuzzy name library corresponding to the header name of each summary table, and the fuzzy name library includes a fuzzy name corresponding to the header of each summary table; the standard format query module 402 is specifically configured to, if a preset summary table has a summary table entry header that is the same as a sub-table entry header; setting the head of the general list which is the same as the head of the sub list as the head of the general list corresponding to the head of the sub list; if the preset general table does not have a general table list header identical to the sub-table list header; inquiring whether a fuzzy name which is the same as the head of the word list exists in a fuzzy name library or not; if the fuzzy name same as the sub-list header exists, the general list header corresponding to the fuzzy name is set as the general list header corresponding to the sub-list header.
In one embodiment, the standard format query module 402 is further configured to obtain a first pinyin character corresponding to the sub-table header if there is no fuzzy name identical to the sub-table header; respectively acquiring second phonetic letters corresponding to all the general list item heads; comparing the first phonetic alphabet with all the second phonetic alphabets; if all the second pinyin letters have the target pinyin letters which are the same as the first pinyin letters, setting the head of the summary list corresponding to the target pinyin grandma as the head of the summary list corresponding to the head of the sub-list.
In one embodiment, the standard format query module 402 is further configured to identify the original format of the column data corresponding to the sub-table column header if there is no fuzzy name identical to the sub-table column header; comparing the original format with a standard format in a summary table; if only one standard format is the same as the original format, the header of the general list corresponding to the standard format is set as the header of the general list corresponding to the header of the sub list.
In one embodiment, the sub-table data integration module 404 is specifically configured to traverse cells in the sub-table, and determine whether there are blank cells in the sub-table; if no blank cell exists in the sub-table, correspondingly integrating the sub-table into a preset general table; if blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprises column header names corresponding to the blank cells, line sequence numbers corresponding to the blank cells and file names of the sub-table; correspondingly filling the positioning data and the blank cells into a preset modification bullet frame, wherein the modification bullet frame comprises a display area of the positioning data and a filling area of the blank cells; outputting a modification popup frame in a popup window form; and when the filling data input by the filling area is received, correspondingly filling the filling data into the blank cells.
In one embodiment, the sub-table data integration module 404 is further configured to obtain a column data screenshot between the row sequence number cell and the blank cell corresponding to the blank cell; generating a thumbnail corresponding to the column data screenshot; acquiring data of a previous cell and data of a next cell of the blank cell; correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps: correspondingly filling the positioning data, the thumbnail, the data of the previous cell, the data of the next cell and the blank cell into a preset modification bullet frame; and outputting a column data screenshot corresponding to the thumbnail when a viewing request for the thumbnail is received.
In one embodiment, the sub-table data integration module 404 is further configured to compare the data format corresponding to the padding data with the standard format corresponding to the blank cells for consistency; if the data are consistent, filling the filling data into the blank cells correspondingly; if not, adjusting the data format of the filling data to a standard format; and filling the filling data adjusted to the standard format into the blank cells.
The embodiment of the application also discloses computer equipment.
Specifically, the computer device includes a memory and a processor, the memory having stored thereon a computer program that can be loaded by the processor and executed to perform the above-described method of project cost analysis data collection and processing.
The embodiment of the application also discloses a computer readable storage medium.
Specifically, the computer readable storage medium stores a computer program capable of being loaded by a processor and executing the method for collecting and processing the engineering cost analysis data, the computer readable storage medium includes, for example: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The present embodiment is only for explaining the present invention, and it is not limited to the present invention, and those skilled in the art can make modifications of the present embodiment without inventive contribution as needed after reading the present specification, but all of them are protected by patent law within the scope of the claims of the present invention.

Claims (10)

1. A method of project cost analysis data acquisition and processing, the method comprising:
when a sub-table to be integrated is obtained, sequentially identifying sub-table list headers inside the sub-table;
inquiring a general table list header corresponding to the sub-table list header and a standard format corresponding to the general table list header in a preset general table according to the sub-table list header;
clearing the format of the line data corresponding to the sub-table column header, and resetting the line data after clearing the format according to the standard format to obtain standard data;
when the column data corresponding to all the column headers of the sub-tables are reset as standard data, correspondingly integrating the sub-tables into a preset general table;
and outputting the general table when all the sub-tables to be integrated are integrated into the general table.
2. The method of claim 1, wherein the predetermined summary table further comprises a fuzzy name library corresponding to each summary table list header name, the fuzzy name library comprising fuzzy names corresponding to each summary table list header;
the querying, according to the sub-table list header, a total table list header corresponding to the sub-table list header in a preset total table includes:
if the preset general table has a general table list head which is the same as the sub-table list head; setting the head of the general list which is the same as the head of the sub list as the head of the general list corresponding to the head of the sub list;
if the preset general table does not have the general table list head same as the sub-table list head; inquiring whether a fuzzy name which is the same as the head of the word list is existed in the fuzzy name library;
and if the fuzzy name same as the sub-list header exists, setting the total list header corresponding to the fuzzy name as the total list header corresponding to the sub-list header.
3. The method of claim 2, wherein after said querying whether the fuzzy name exists in the fuzzy name library that is the same as the head of the word list, further comprising:
if the fuzzy name same as the sub-table list header does not exist, acquiring a first pinyin letter corresponding to the sub-table list header;
respectively acquiring second phonetic letters corresponding to all the general table list headers;
comparing the first phonetic alphabet with all the second phonetic alphabets;
if the target pinyin letters identical to the first pinyin letters exist in all the second pinyin letters, setting the head of the summary list corresponding to the target pinyin grandma as the head of the summary list corresponding to the head of the sub-list.
4. The method of claim 2, wherein after said querying whether the fuzzy name exists in the fuzzy name library that is the same as the head of the word list, further comprising:
if the fuzzy name same as the sub-table list header does not exist, identifying the original format of the line data corresponding to the sub-table list header;
comparing the original format with a standard format in the summary table;
if only one standard format is the same as the original format, the total list header corresponding to the standard format which is the same as the original format is set as the total list header corresponding to the sub list header.
5. The method of claim 1, wherein the integrating the sub-table correspondence into a preset summary table comprises:
traversing the cells in the sub-table, and judging whether blank cells exist in the sub-table;
if no blank cell exists in the sub-table, correspondingly integrating the sub-table into a preset general table;
if the blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprises column header names corresponding to the blank cells, line sequence numbers corresponding to the blank cells and file names of the sub-table;
correspondingly filling the positioning data and the blank cells into a preset modification bullet frame, wherein the modification bullet frame comprises a display area of the positioning data and a filling area of the blank cells;
outputting the modification popup frame in a popup window mode;
and correspondingly filling and writing the filling data into the blank cells when the filling data input by the filling area is received.
6. The method according to claim 5, further comprising, before said correspondingly filling said positioning data and said blank cell into a preset modified bullet box:
acquiring a line data screenshot between a line sequence number cell corresponding to a blank cell and the blank cell;
generating a thumbnail corresponding to the column data screenshot;
acquiring data of a previous cell and data of a next cell of the blank cell;
correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps:
correspondingly filling the positioning data, the thumbnail, the data of the previous cell, the data of the next cell and the blank cell into a preset modification bullet frame;
and outputting a column data screenshot corresponding to the thumbnail when a viewing request for the thumbnail is received.
7. The method of claim 5, wherein the correspondingly filling the padding data into the blank cells comprises:
carrying out consistency comparison on a data format corresponding to the filling data and a standard format corresponding to the blank cell;
if the data are consistent, correspondingly filling the filling data into the blank cells;
if the data format of the filling data is not consistent with the standard format, adjusting the data format of the filling data to the standard format;
and filling and writing the filling data adjusted to the standard format into the blank cells.
8. A system for project cost analysis data acquisition and processing, the system comprising:
the sub-table information acquisition module (401) is used for sequentially identifying sub-table list headers in the sub-tables when the sub-tables to be integrated are acquired;
a standard format query module (402) for querying a general table list header corresponding to the sub table list header and a standard format corresponding to the general table list header in a preset general table according to the sub table list header;
a standard format setting module (403) for clearing the format of the column data corresponding to the sub-table column header, and resetting the column data after clearing the format according to the standard format to obtain standard data;
a sub-table data integration module (404) for correspondingly integrating the sub-tables into a preset general table when the column data corresponding to all the sub-table column header in the sub-tables are reset as standard data;
and the general table data output module (405) is used for outputting the general table when all the sub tables to be integrated are integrated into the general table.
9. A computer device comprising a memory and a processor, the memory having stored thereon a computer program that can be loaded by the processor and that executes the method according to any of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored which can be loaded by a processor and which executes the method of any one of claims 1 to 7.
CN202211348530.6A 2022-10-31 2022-10-31 Method and system for collecting and processing engineering cost analysis data Active CN115630620B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211348530.6A CN115630620B (en) 2022-10-31 2022-10-31 Method and system for collecting and processing engineering cost analysis data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211348530.6A CN115630620B (en) 2022-10-31 2022-10-31 Method and system for collecting and processing engineering cost analysis data

Publications (2)

Publication Number Publication Date
CN115630620A true CN115630620A (en) 2023-01-20
CN115630620B CN115630620B (en) 2023-12-26

Family

ID=84907934

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211348530.6A Active CN115630620B (en) 2022-10-31 2022-10-31 Method and system for collecting and processing engineering cost analysis data

Country Status (1)

Country Link
CN (1) CN115630620B (en)

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103020089A (en) * 2011-09-27 2013-04-03 深圳市金蝶友商电子商务服务有限公司 Method and device for importing data in EXCEL file to database
JP2015191277A (en) * 2014-03-27 2015-11-02 富士通株式会社 Data identification method, data identification program, and data identification device
CN105718456A (en) * 2014-12-01 2016-06-29 中国汽车工业国际合作有限公司 Proceedings document collection and processing method based on intermediate table
CN108153719A (en) * 2016-12-02 2018-06-12 北京国双科技有限公司 Merge the method and apparatus of electrical form
CN109359283A (en) * 2018-09-26 2019-02-19 中国平安人寿保险股份有限公司 Method of summary, terminal device and the medium of list data
CN109460398A (en) * 2018-10-12 2019-03-12 深圳绿米联创科技有限公司 Complementing method, device and the electronic equipment of time series data
CN110969000A (en) * 2018-09-30 2020-04-07 北京国双科技有限公司 Data merging processing method and device
CN114004221A (en) * 2021-10-26 2022-02-01 珠海金山办公软件有限公司 Method and device for correcting table content
CN114064657A (en) * 2021-11-24 2022-02-18 东软集团股份有限公司 Multi-table integration method, device, equipment and storage medium

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103020089A (en) * 2011-09-27 2013-04-03 深圳市金蝶友商电子商务服务有限公司 Method and device for importing data in EXCEL file to database
JP2015191277A (en) * 2014-03-27 2015-11-02 富士通株式会社 Data identification method, data identification program, and data identification device
CN105718456A (en) * 2014-12-01 2016-06-29 中国汽车工业国际合作有限公司 Proceedings document collection and processing method based on intermediate table
CN108153719A (en) * 2016-12-02 2018-06-12 北京国双科技有限公司 Merge the method and apparatus of electrical form
CN109359283A (en) * 2018-09-26 2019-02-19 中国平安人寿保险股份有限公司 Method of summary, terminal device and the medium of list data
CN110969000A (en) * 2018-09-30 2020-04-07 北京国双科技有限公司 Data merging processing method and device
CN109460398A (en) * 2018-10-12 2019-03-12 深圳绿米联创科技有限公司 Complementing method, device and the electronic equipment of time series data
CN114004221A (en) * 2021-10-26 2022-02-01 珠海金山办公软件有限公司 Method and device for correcting table content
CN114064657A (en) * 2021-11-24 2022-02-18 东软集团股份有限公司 Multi-table integration method, device, equipment and storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
ONETABLE TEAM: "如何高效合并多个的Excel、CSV表格？", pages 1 - 10, Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/460895169?utm_id=0> *

Also Published As

Publication number Publication date
CN115630620B (en) 2023-12-26

Similar Documents

Publication Publication Date Title
US11714841B2 (en) Systems and methods for processing a natural language query in data tables
CN110292775B (en) Method and device for acquiring difference data
US9430453B1 (en) Multi-page document recognition in document capture
CN104636322B (en) The method and device that a kind of text replicates
CN110210470B (en) Commodity information image recognition system
US11934774B2 (en) Systems and methods for generating social assets from electronic publications
US7937657B2 (en) User specific error analysis
CN111048215A (en) CRM-based medical video production method and system
CN111143370B (en) Method, apparatus and computer-readable storage medium for analyzing relationships between a plurality of data tables
CN113407536A (en) Method and device for associating table data, terminal equipment and medium
CN110825805A (en) Data visualization method and device
CN110647573B (en) Chart visualization editing method and system based on database technology
CN116562247A (en) Electronic form content generation method, electronic form content generation device and computer equipment
CN109471935B (en) Questionnaire survey object determining method and device, electronic equipment and storage medium
CN115630620A (en) Method and system for collecting and processing engineering cost analysis data
CN117054846A (en) Visual test method, system and device for chip and storage medium
CN117033309A (en) Data conversion method and device, electronic equipment and readable storage medium
CN114724170A (en) BOM generation method and device, electronic equipment and storage medium
CN115587098A (en) Method and system for intelligently identifying chart data
JP2019185140A (en) Image processing device, image processing method, and program
CN112286879B (en) Metadata-based data asset construction method and device
CN109710369B (en) full-graphical user interface display method and device
US7207484B2 (en) System and method for stocktaking management
CN112784106A (en) Content data processing method, report data processing method, computer device, and storage medium
CN117744615A (en) Form data processing method and device, electronic equipment and readable storage medium

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