CN115630620B - 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 PDFInfo
- Publication number
- CN115630620B CN115630620B CN202211348530.6A CN202211348530A CN115630620B CN 115630620 B CN115630620 B CN 115630620B CN 202211348530 A CN202211348530 A CN 202211348530A CN 115630620 B CN115630620 B CN 115630620B
- Authority
- CN
- China
- Prior art keywords
- sub
- list
- data
- total
- header
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 collecting 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 acquired, sub-table list headers in the sub-table are sequentially identified; inquiring a total list head corresponding to the sub-list head in a preset total list according to the sub-list head, and a standard format corresponding to the total list head; clearing the format of column data corresponding to the sub-column header, and resetting the column data with the cleared format according to the standard format to obtain standard data; when the column data corresponding to all the sub-column headers in the sub-table are reset to be standard data, integrating the sub-table into a preset total table; outputting the total table when all the sub-tables to be integrated are integrated into the total table. The technical effect that this application had is: the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the total table is realized; therefore, the integration efficiency of the sub-table data is improved.
Description
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 engineering cost analysis refers to the analysis of estimation, budget and resolution of the determined engineering cost at different stages, and is used for commenting on the economic rationality of the determined engineering cost; and through analysis, seek to reduce the potential of construction costs and the measures to be taken.
In the process of collecting and processing engineering cost analysis data, in order to improve the collection efficiency and share the pressure of data collection, the collection requirement of the same data is often distributed to different responsible persons to collect respectively, and then sub-tables sent by the different responsible persons are combined into a total table, so that the collection and integration of the data are completed.
In the process of implementing the present application, the inventor finds that at least the following problems exist in the process of collecting and integrating the data of the sub-table: the data formats and the arrangement positions of the row headers of different sub-tables may be different, so that a data integration person cannot directly integrate a plurality of sub-tables into the same summary table, and the data integration efficiency is poor.
Disclosure of Invention
In order to help to promote the efficiency of data integration, the present application provides a method and a system for collecting and processing engineering cost analysis data.
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 acquired, sequentially identifying sub-table list header in the sub-table;
inquiring a total list head corresponding to the sub-list head in a preset total list according to the sub-list head, and a standard format corresponding to the total list head;
clearing the format of column data corresponding to the sub-column header, and resetting the column data with the cleared format according to the standard format to obtain standard data;
when column data corresponding to all sub-column headers in a sub-table are reset to standard data, integrating the sub-table into a preset total table;
outputting the summary list when all the sub-tables to be integrated are integrated into the summary list.
Through the technical scheme, when receiving the sub-table to be integrated, the total table list head corresponding to each sub-table list head and the standard format of the total table list head are firstly determined, then the format of the column data corresponding to each sub-table list head is respectively adjusted to the standard format, and then the sub-table with the adjusted format is correspondingly integrated into the total table, so that unified integration of the sub-table data is completed; before the sub-table data is integrated, the formats of the sub-table internal column data are unified, so that the possibility that the sub-tables are difficult to be directly integrated into a summary table or the integrated partial data cannot be normally displayed due to different data formats of different sub-tables and arrangement positions of column headers is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the summary table is realized; therefore, the integration efficiency of the sub-table data is improved.
In a specific implementation manner, the preset summary table further comprises a fuzzy name library corresponding to each summary table list header, and the fuzzy name library comprises fuzzy names corresponding to each summary table list header;
the step of inquiring the total list head corresponding to the sub-list head in the preset total list according to the sub-list head comprises the following steps:
if the preset summary list has the same summary list header as the sub-list header; setting the same total list head as the sub list head as the total list head corresponding to the sub list head;
if the total list head which is the same as the sub-list head does not exist in the preset total list; inquiring whether the fuzzy name which is the same as the head of the word list exists in the fuzzy name library;
if the fuzzy name is the same as the sub-list header, the total list header corresponding to the fuzzy name is set as the total list header corresponding to the sub-list header.
Through the technical scheme, when the total list head which is the same as the sub-list head to be matched currently does not exist in the total list, inquiring the fuzzy names which are the same as the sub-list head in the fuzzy name library, and then setting the total list head corresponding to the fuzzy names as the total list head corresponding to the sub-list head; the possibility that partial sub-list titles cannot find the corresponding total list titles in the total list due to the fact that differences exist between the naming modes of the sub-list titles and the total list titles is reduced, and therefore the integration effect of sub-list data is improved.
In a specific embodiment, after said querying whether there is a fuzzy name in the fuzzy name base that is the same as the word list header, further comprising:
if the fuzzy name which is the same as the sub-list head does not exist, acquiring a first pinyin letter corresponding to the sub-list head;
respectively obtaining second pinyin letters corresponding to all the total list headers;
comparing the first pinyin letters with all the second pinyin letters;
if the target pinyin letters which are the same as the first pinyin letters exist in all the second pinyin letters, setting the total list head corresponding to the target pinyin ancestor as the total list head corresponding to the sub-list head.
Through the technical scheme, when the fuzzy names identical with the sub-list titles cannot be searched in the fuzzy name library, whether the first pinyin letters of the sub-list titles are consistent with the second pinyin letters of the sub-list titles or not can be determined by comparing the first pinyin letters of the sub-list titles with the second pinyin letters of the sub-list titles, so that the sub-list titles with homophone-like wrongly written characters in part can also be correspondingly searched for the corresponding sub-list titles, and the integration effect of sub-list data is further improved.
In a specific embodiment, after said querying whether there is a fuzzy name in the fuzzy name base that is the same as the word list header, further comprising:
if the fuzzy name which is the same as the sub-column header does not exist, the original format of the column data which corresponds to the sub-column header is identified;
comparing the original format with a standard format in the summary table;
if only one standard format is the same as the original format, setting the total list head corresponding to the standard format which is the same as the original format as the total list head corresponding to the sub-list head.
By the technical scheme, when the fuzzy names identical to the sub-list titles cannot be queried in the fuzzy name library, the total list titles corresponding to the standard format identical to the original format can be set as the total list titles corresponding to the sub-list titles by querying whether the standard format corresponding to the original format of the sub-list titles is unique; the possibility that the sub-list header is difficult to find the matched total list header is further reduced, and therefore the integration effect of sub-list data is further improved.
In a specific embodiment, the integrating the sub-table into a preset summary table includes:
Traversing the cells in the sub-table, and judging whether blank cells exist in the sub-table;
if the blank cells do not exist in the sub-table, correspondingly integrating the sub-table into a preset total table;
if the sub-table contains blank cells, recording positioning data corresponding to the blank cells, wherein the positioning data comprises a column header name corresponding to the blank cells, a row serial number corresponding to the blank cells and a file name 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 modified bullet frame in a bullet window mode;
and when the filling data input by the filling area is received, correspondingly filling the filling data into the blank cells.
Through the technical scheme, after the column data format of the sub-table is adjusted, whether the blank cells exist in the sub-table is checked, if the blank cells exist, positioning data such as the column header names corresponding to the blank cells, the row serial numbers corresponding to the blank cells, the file names of the sub-table and the like are recorded, and then the positioning data and the blank cells are popped out in the form of a pop-up frame, so that a user can conveniently supplement or modify the blank cells, the workload of the user when the user supplements the data corresponding to the blank cells is reduced, and the efficiency of the sub-table data integration is improved.
In a specific embodiment, before the writing the positioning data and the blank cells into the preset modification frame, the method further includes:
acquiring a column data screenshot between a row serial number cell corresponding to a blank cell and the blank cell;
generating a thumbnail corresponding to the column data screenshot;
acquiring data of one cell and data of the next cell on the blank cell;
the correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps:
the positioning data, the thumbnail, the data of the last cell, the data of the next cell and the blank cell are correspondingly filled into a preset modification bullet frame;
and outputting a column data screenshot corresponding to the thumbnail when receiving a view request for the thumbnail.
By the technical proposal, when the bullet frame which needs the user to supplement the blank cell data is output,
meanwhile, the column data between the row serial number cell and the blank cell corresponding to the blank cell, the data of one cell on the blank cell, the data of the next cell and other reference data are integrated and displayed in the bullet frame, so that a user can quickly supplement the blank Bai Shanyuan cell according to the reference data displayed in the bullet frame, and convenience in supplementing the blank cell by the user is improved.
In a specific embodiment, the writing the refill data into the blank cell includes:
consistency comparison is carried out on the data format corresponding to the filling data and the standard format corresponding to the blank cell;
if the data are consistent, correspondingly filling the filling data into the blank cells;
if the data formats of the filling data are inconsistent, the data formats of the filling data are adjusted to standard formats;
and filling the filling data adjusted to the standard format into the blank cells.
According to 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 displayed normally after being fed into the summary list 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 scheme: the system comprises:
The sub-table information acquisition module is used for sequentially identifying sub-table list headers in the sub-table when the sub-table to be integrated is acquired;
the standard format query module is used for querying the total list head corresponding to the sub-list head in a preset total list according to the sub-list head and the standard format corresponding to the total list head;
the standard format setting module is used for clearing the format of the column data corresponding to the sub-column header, and resetting the column data with the cleared format according to the standard format to obtain standard data;
the sub-table data integration module is used for integrating the sub-table corresponding to all the column data corresponding to the sub-table list head in the sub-table into a preset total table when the column data corresponding to all the sub-table list head in the sub-table is reset to be standard data;
the total table data output module is used for outputting the total table when all the sub-tables to be integrated are integrated into the total table.
Through the technical scheme, when receiving the sub-table to be integrated, the total table list head corresponding to each sub-table list head and the standard format of the total table list head are firstly determined, then the format of the column data corresponding to each sub-table list head is respectively adjusted to the standard format, and then the sub-table with the adjusted format is correspondingly integrated into the total table, so that unified integration of the sub-table data is completed; before the sub-table data is integrated, the formats of the sub-table internal column data are unified, so that the possibility that the sub-tables are difficult to be directly integrated into a summary table or the integrated partial data cannot be normally displayed due to different data formats of different sub-tables and arrangement positions of column headers is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the summary 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 scheme: comprising a memory and a processor, said memory having stored thereon a computer program capable of being loaded by the processor and performing a method of collecting and processing construction cost analysis data as any one of the 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 that can be loaded by a processor and that performs any of the methods of engineering cost analysis data collection and processing described above.
In summary, the present application includes at least one of the following beneficial technical effects:
1. when receiving the sub-table to be integrated, firstly determining the total table list head corresponding to each sub-table list head and the standard format of the total table list head, then respectively adjusting the format of the column data corresponding to each sub-table list head into the standard format, and then correspondingly integrating the sub-table with the adjusted format into the total table, thereby completing unified integration of the sub-table data; before the sub-table data is integrated, the formats of the sub-table internal column data are unified, so that the possibility that the sub-tables are difficult to be directly integrated into a summary table or the integrated partial data cannot be normally displayed due to different data formats of different sub-tables and arrangement positions of column headers is reduced, and the effect of automatically adjusting and integrating the sub-tables according to the format and arrangement requirements of the summary table is realized; thereby improving the integration efficiency of the sub-table data;
2. When the fuzzy names which are the same as the sub-list titles cannot be searched in the fuzzy name library, whether the first pinyin letters of the sub-list titles are consistent with the second pinyin letters of the sub-list titles or not can be determined by comparing the first pinyin letters of the sub-list titles with the second pinyin letters of the sub-list titles, so that the sub-list titles with homophone mispronounced characters can be correspondingly searched for the corresponding sub-list titles, and the integration effect of the sub-list data is further improved.
Drawings
FIG. 1 is a flow chart of a method of process cost analysis data collection and processing in an embodiment of the present application.
FIG. 2 is a schematic diagram of an embodiment of the present application for embodying a fuzzy database arrangement.
Fig. 3 is a schematic diagram of an embodiment of the present application for implementing a modified frame arrangement.
FIG. 4 is a block diagram of a system for collecting and processing project cost analysis data in an embodiment of the present application.
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 total data output module.
Detailed Description
The present application is described in further detail below in conjunction with 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 between the data integration platform and a user can be realized by utilizing input/output equipment 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:
s10, when the sub-table to be integrated is acquired, sub-table list head inside the sub-table is sequentially identified.
Specifically, when a plurality of sub-tables need to be integrated into a preset summary table, a user can input the sub-tables to be integrated into a data integration platform, and the data integration platform can sequentially identify sub-table list headers in each sub-table by using a word recognition mode after receiving the sub-tables to be integrated input by the user; for example, the name of the first sub-table column header corresponding to sub-table A is "project name".
S20, inquiring the total list head corresponding to the sub list head and the standard format corresponding to the total list head in a preset total list according to the sub list head.
Specifically, the data in the summary list is preset and recorded by a background staff, and comprises a plurality of summary list headers corresponding to the sub-list headers; namely, the data corresponding to the total list head in the total list is the data which the user needs to integrate, and the standard format corresponding to the total list head is the format which the user needs; after the data integration platform identifies the sub-table list header in the sub-table, the data integration platform firstly queries the total table list header which is the same as the sub-table list header in the total table and the standard format corresponding to the total 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 a plurality of sub-tables according to the summary table selected by the user.
S30, clearing the format of column data corresponding to the sub-column header, and resetting the column data with the cleared format according to the standard format to obtain standard data.
Specifically, after the data integration platform queries the standard format corresponding to the sub-table column header, the original data format of the column data corresponding to the sub-table column header is deleted firstly, and then the column data after the format is cleared is reset 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 list, but the data format corresponding to the standard data is the standard format required in the summary list.
S40, integrating the sub-table correspondence into a preset summary table when column data corresponding to all sub-table column headers in the sub-table are reset to standard data.
Specifically, the data integration platform can sequentially adjust column data in the sub-table according to the left-to-right order, and when all column data in the currently processed sub-table are adjusted to be standard data, the sub-table is correspondingly integrated into a preset total table, namely, the column data in the sub-table are correspondingly copied to the lower areas of different total table column headers in the total table respectively.
S50, outputting a total table when all the sub-tables to be integrated are integrated into the total table.
Specifically, when all the sub-table data to be integrated are integrated into the summary table, the data integration platform outputs the summary table formed after integration, and then the user can obtain the integrated data summary table by downloading the summary table output by the data integration platform; when integrating data of a plurality of sub-tables, a user only needs to input the plurality of sub-tables into a data integration platform, the data integration platform can automatically identify the corresponding relation between the sub-tables and the total table, then automatically adjust the data in the sub-tables into the data format in the total table, and integrate the data in the sub-tables into the total table according to the arrangement scheme of the list heads of the total table, thereby reducing the possibility that the sub-tables are difficult to be directly integrated into the total table or partial data cannot be normally displayed after integration due to different data formats of different sub-tables and different arrangement positions of the list heads; therefore, the integration efficiency of the sub-table data is improved.
In one embodiment, in connection with FIG. 2, it is contemplated that the names of some of the sub-listing headers may not be identical to the representation of the total listing header, e.g., the representation of the total listing header is "accounting day" and the representation in the sub-listing header is "accounting time"; then, the situation that the sub-list header cannot find the corresponding total list header is caused; the preset summary list also comprises a fuzzy name library corresponding to the names of the summary list titles, wherein the fuzzy name library is preset and recorded by background staff and comprises fuzzy names corresponding to the summary list titles; for example: for the summary list header of "accounting date", the corresponding fuzzy name may be similar names such as "accounting date", "accounting time", etc.
The step of the data integration platform querying the total list header corresponding to the sub-list header in the preset total list according to the sub-list header may be specifically performed as follows:
if the preset summary list has the same summary list header as the sub-list header, namely the summary list has the summary list header consistent with the sub-list header in expression; setting the same total list head as the sub list head as the total list head corresponding to the sub list head; if the preset summary list does not contain the summary list header which is the same as the sub-list header, namely the summary list does not contain the summary list header which is consistent with the sub-list header in expression; the data integration platform continues to inquire whether the fuzzy name which is the same as the sub-list header exists in the fuzzy name library; if the fuzzy name corresponding to 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; based on the foregoing example, for the sub-list header of "accounting time", since the corresponding total list header name is "accounting day", the data integration platform cannot find the same total list header as the sub-list header, and then the data integration platform can find the fuzzy name consistent with the "accounting time" in the fuzzy name library, and the total list header corresponding to the fuzzy name of "accounting time" is "accounting day", where the data integration platform determines that the sub-list header "accounting time" and the total list header "accounting day" correspond to each other. The fuzzy name library is arranged to enable the sub-list titles inconsistent with the total list titles in a part of expression modes, the data integration platform can quickly find the total list titles corresponding to the sub-list titles by means of matching the fuzzy names, the possibility that the sub-list titles are difficult to find the corresponding total list titles to cause integration interruption is reduced, and therefore stability and integration effect of sub-list data integration are improved.
In one embodiment, considering that when a sub-table editor edits sub-table list titles, there may be a case that the sub-table list titles have homophones due to incorrect editing, and then the data integration platform is difficult to find the total list titles consistent with the sub-table list titles with homophones; for example, the sub-list header "accounting date" is mistakenly edited as "nucleic acid date" by a sub-list editor, and then the sub-list header cannot find the total list header corresponding to the sub-list header, namely "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 same as the head of the word list, the following steps can be further executed:
if the fuzzy name library does not have the fuzzy name identical with the sub-list head, the data integration platform sequentially acquires a first pinyin letter corresponding to the sub-list head and a second pinyin letter corresponding to all the total list head, and then compares the first pinyin letter with all the second pinyin letters; if the target pinyin letters which are the same as the first pinyin letters exist in all the second pinyin letters, setting the total list head corresponding to the target pinyin ancestor as the total list head corresponding to the sub list head; based on the foregoing example, the first pinyin letter corresponding to the sub-list header "nucleic acid day" is "hessianri" and the second pinyin letter corresponding to the total list header "accounting day" is also "hessianri"; namely, the data integration platform can quickly find the total list header corresponding to the sub-list header with the homophone mispronounced character by using a pinyin comparison mode under the condition that the homophone mispronounced character exists in the sub-list header, so that the data integration effect of the data integration platform on the sub-list is further improved.
In one embodiment, to further enhance the effect of the data integration platform in integrating sub-table data; after the data integration platform queries whether the fuzzy name library has the fuzzy name same as the head of the word list, the following steps can be further executed:
if the fuzzy name library does not have the same fuzzy name as the sub-list header, the data integration platform can also identify the original format of the column data corresponding to the sub-list header, then compare the original format with all the standard formats in the total table, and if only one standard format is the same as the original format, set the total list header corresponding to the standard format identical to the original format as the total list header corresponding to the sub-list header; otherwise, sending out reminding information to prompt a user to modify the sub-list header which cannot be identified; for example, if the data format corresponding to the sub-table list header "accounting" is a date format and only the standard format corresponding to the "accounting date" is a date format, then if the data integration platform does not query the same total table list header and the fuzzy name as the "accounting", the "accounting date" is set as the total table list header corresponding to the "accounting date" because the data format corresponding to the "accounting" and the standard format corresponding to the "accounting date" form a single corresponding relationship; the data integration platform can also quickly find out the total list header corresponding to the sub-list header by judging whether the sub-list header format and the total list header format with single corresponding relation exist, so that the effect of the data integration platform in integrating sub-list data is further improved.
In one embodiment, considering that blank cells of input column data may be missed by a sub-table editor in a sub-table, if sub-table data with blank cells are directly integrated into a total table, the blank cells in the total table are difficult to trace and modify, so as to further improve the integration effect of the data integration platform on the sub-table data; the step of integrating the sub-table correspondence into the preset summary table by the data integration platform may be specifically performed as follows:
when the column data corresponding to all the sub-table column headers in the sub-table are reset to be standard data, the data integration platform firstly traverses the cells in the sub-table, judges whether blank cells exist in the sub-table, and if the blank cells do not exist in the sub-table, performs the step of integrating the sub-table into a preset total table; if the blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprises a column header name corresponding to the blank cells, a row serial number corresponding to the blank cells and a file name of the sub-table; then, the positioning data and the blank cells are correspondingly filled into a preset modification bullet frame, the modification bullet frame comprises a display area of the positioning data and a filling area of the blank cells, and then the generated bullet frame is output and displayed in a bullet frame mode so that a user can refer to display of display area information in the bullet frame and correspondingly fill the data in the blank cells; when receiving the filling data input by a user in the filling area, the data integration platform correspondingly fills the filling data into the blank cells, so that the filling of the blank cells is completed; aiming at the situation that blank cells exist in the sub-table, the data integration platform can display the related information of the blank cells in the form of a bullet frame, so that a user can quickly complete the supplement of data in the blank cells in a manner of supplementing the data in the bullet frame without submitting the sub-table with the blank cells again after withdrawing and modifying the sub-table with the blank cells, on one hand, the efficiency of the user for supplementing the blank cells is improved, and on the other hand, the efficiency of the data integration platform for integrating the sub-table data is also improved.
In one embodiment, to further improve the efficiency and convenience of the user when filling the space Bai Shanyuan grid; before the data integration platform writes the positioning data and the blank cells into the preset modification frame, the following steps may be executed first:
after recording positioning data, the data integration platform firstly acquires a column data screenshot between a row serial number cell corresponding to a blank cell and the blank cell, and then generates a thumbnail corresponding to the column data screenshot; and acquiring data of one cell and data of the next cell on the blank cell while generating the thumbnail.
The step of the data integration platform correspondingly writing the positioning data and the blank cells into the preset modified frame may be further performed as follows: filling the positioning data, the thumbnail, the data of the last cell, the data of the next cell and the blank cell into a preset modification bullet frame correspondingly; the arrangement mode of the modified spring frame can be shown in figure 3; then, when receiving a view 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 displays the column data screenshot corresponding to the thumbnail to the user, so that the user can further refer to the column data screenshot, the data of one cell on the blank cell and the data of the next cell on the blank cell, and the data in the blank Bai Shanyuan cell are quickly filled, thereby further improving the efficiency and convenience of the user in filling the space Bai Shanyuan cells.
In one embodiment, consider the case that the data format of the data filled in the blank cells by the user may be different from the standard format corresponding to the blank cells, which in turn results in that the data filled in the blank cells may be difficult to display normally after being integrated into the summary table; the step of correspondingly filling the refill data into the blank cells may be specifically performed as:
after receiving the filling data input by the filling area, the 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, the filling data is directly correspondingly filled into the blank cell; otherwise, the format of the filling data is adjusted and replaced by the standard format, and then the filling data with the adjusted and replaced standard format is filled into the blank cells, so that when the filling data in the blank Bai Shanyuan cells is integrated into the summary table, 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 displayed normally in the summary table.
FIG. 1 is a flow chart of a method for collecting and processing project cost analysis data in one embodiment. It should be understood that, although the steps in the flowchart of fig. 1 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows; the steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders; and at least some of the steps in fig. 1 may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor does the order in which the sub-steps or stages are performed necessarily occur in sequence, but may be performed alternately or alternately with at least some of the other steps or sub-steps of other steps.
Based on the method, the embodiment of the application also discloses a system for collecting and processing the engineering cost analysis data.
As shown in fig. 4, the system includes the following modules:
the sub-table information acquisition module 401 is configured to sequentially identify sub-table list headers in the sub-table when the sub-table to be integrated is acquired;
the standard format query module 402 is configured to query, in a preset summary table, a summary table list header corresponding to the sub-table list header, and a standard format corresponding to the summary table list header;
the standard format setting module 403 is configured to clear a format of 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;
the sub-table data integrating module 404 is configured to integrate the sub-table correspondence into a preset summary table when column data corresponding to all sub-table column headers in the sub-table are reset to standard data;
the summary data output module 405 is configured to output a summary when all the sub-tables to be integrated are integrated into the summary.
In one embodiment, the preset summary table further includes a fuzzy name library corresponding to each summary table list title, and the fuzzy name library includes a fuzzy name corresponding to each summary table list title; the standard format query module 402 is specifically configured to, if the total table preset has the same total table list header as the sub-table list header; setting the same total list head as the sub list head as the total list head corresponding to the sub list head; if the preset summary list does not have the same summary list header as the sub-list header; inquiring whether the fuzzy name which is the same as the head of the word list exists in the fuzzy name library; if the fuzzy name is the same as the sub-list header, the total list header corresponding to the fuzzy name is set as the total 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 letter corresponding to the sub-column header if the fuzzy name identical to the sub-column header does not exist; respectively obtaining second pinyin letters corresponding to all the total list headers; comparing the first pinyin letters with all the second pinyin letters; if the target pinyin letters which are the same as the first pinyin letters exist in all the second pinyin letters, setting the total list head corresponding to the target pinyin ancestor as the total list head corresponding to the sub list head.
In one embodiment, the standard format query module 402 is further configured to identify an original format of the column data corresponding to the sub-column header if there is no ambiguous name identical to the sub-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 total list head corresponding to the standard format which is the same as the original format is set as the total list head corresponding to the sub list head.
In one embodiment, the sub-table data integration module 404 is specifically configured to traverse cells in the sub-table, and determine whether a blank cell exists in the sub-table; if the blank cells do not exist in the sub-table, correspondingly integrating the sub-table into a preset total table; if the blank cells exist in the sub-table, recording positioning data corresponding to the blank cells, wherein the positioning data comprises a column header name corresponding to the blank cells, a row serial number corresponding to the blank cells and a file name of the sub-table; correspondingly writing 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 modified bullet frame in a bullet window mode; 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 a row serial number cell and a blank cell corresponding to the blank cell; generating a thumbnail corresponding to the column data screenshot; acquiring data of one cell and data of the next cell on the blank cell; the step of correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps: filling the positioning data, the thumbnail, the data of the last cell, the data of the next cell and the blank cell into a preset modification bullet frame correspondingly; and when receiving a view request for the thumbnail, outputting a column data screenshot corresponding to the thumbnail.
In one embodiment, the sub-table data integration module 404 is further configured to compare the data format corresponding to the filling data with the standard format corresponding to the blank cell; if the data are consistent, correspondingly filling the filling data into the blank cells; if the data formats of the filling data are inconsistent, the data formats of the filling data are adjusted to standard formats; and filling the filling data adjusted to the standard format into the blank cells.
The embodiment of the application also discloses a computer device.
In particular, the computer device comprises a memory and a processor, the memory storing a computer program that can be loaded by the processor and that performs the method of engineering cost analysis data acquisition and processing described above.
The embodiment of the application also discloses a computer readable storage medium.
In particular, the computer-readable storage medium stores a computer program that can be loaded by a processor and that performs the method of engineering cost analysis data acquisition and processing as described above, for example, the computer-readable storage medium comprising: a U-disk, a removable hard disk, a Read-only memory (ROM), a random access memory (RandomAccessMemory, RAM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
The present embodiment is only for explanation of the present invention and is not to be construed as limiting the present invention, and modifications to the present embodiment, which may not creatively contribute to the present invention as required by those skilled in the art after reading the present specification, are all protected by patent laws within the scope of claims of the present invention.
Claims (7)
1. A method for collecting and processing engineering cost analysis data, the method comprising:
When a sub-table to be integrated is acquired, sequentially identifying sub-table list header in the sub-table;
inquiring a total list head corresponding to the sub-list head in a preset total list according to the sub-list head, and a standard format corresponding to the total list head;
the preset summary list also comprises a fuzzy name library corresponding to the names of all the summary list titles, and the fuzzy name library comprises fuzzy names corresponding to all the summary list titles;
the step of inquiring the total list head corresponding to the sub-list head in the preset total list according to the sub-list head comprises the following steps:
if the preset summary list has the same summary list header as the sub-list header; setting the same total list head as the sub list head as the total list head corresponding to the sub list head;
if the total list head which is the same as the sub-list head does not exist in the preset total list; inquiring whether the fuzzy name which is the same as the sub-list header exists in the fuzzy name library;
if the fuzzy name which is the 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;
If the fuzzy name which is the same as the sub-column header does not exist, the original format of the column data which corresponds to the sub-column header is identified;
comparing the original format with a standard format in the summary table;
if only one standard format is the same as the original format, setting the total list head corresponding to the standard format which is the same as the original format as the total list head corresponding to the sub-list head;
if the fuzzy name which is the same as the sub-list head does not exist, acquiring a first pinyin letter corresponding to the sub-list head;
respectively obtaining second pinyin letters corresponding to all the total list headers;
comparing the first pinyin letters with all the second pinyin letters;
if the target pinyin letters which are the same as the first pinyin letters exist in all the second pinyin letters, setting the total list head corresponding to the target pinyin ancestor as the total list head corresponding to the sub-list head;
clearing the format of column data corresponding to the sub-column header, and resetting the column data with the cleared format according to the standard format to obtain standard data;
When column data corresponding to all sub-column headers in a sub-table are reset to standard data, integrating the sub-table into a preset total table;
outputting the summary list when all the sub-tables to be integrated are integrated into the summary list.
2. The method of claim 1, wherein the integrating the sub-table correspondence into a pre-set summary table comprises:
traversing the cells in the sub-table, and judging whether blank cells exist in the sub-table;
if the blank cells do not exist in the sub-table, correspondingly integrating the sub-table into a preset total table;
if the sub-table contains blank cells, recording positioning data corresponding to the blank cells, wherein the positioning data comprises a column header name corresponding to the blank cells, a row serial number corresponding to the blank cells and a file name 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 modified bullet frame in a bullet window mode;
and when the filling data input by the filling area is received, correspondingly filling the filling data into the blank cells.
3. The method of claim 2, further comprising, prior to the corresponding filling of the positioning data and the blank cells into a predetermined modified frame:
acquiring a column data screenshot between a row serial number cell corresponding to a blank cell and the blank cell;
generating a thumbnail corresponding to the column data screenshot;
acquiring data of one cell and data of the next cell on the blank cell;
the correspondingly filling the positioning data and the blank cells into a preset modification bullet frame comprises the following steps:
the positioning data, the thumbnail, the data of the last cell, the data of the next cell and the blank cell are correspondingly filled into a preset modification bullet frame;
and outputting a column data screenshot corresponding to the thumbnail when receiving a view request for the thumbnail.
4. The method of claim 2, wherein the correspondingly writing the refill data into the blank cells comprises:
consistency comparison is carried out on the data format corresponding to the filling data and the standard format corresponding to the blank cell;
If the data are consistent, correspondingly filling the filling data into the blank cells;
if the data formats of the filling data are inconsistent, the data formats of the filling data are adjusted to standard formats;
and filling the filling data adjusted to the standard format into the blank cells.
5. A system for collecting and processing project cost analysis data, said system comprising:
the sub-table information acquisition module (401) is used for sequentially identifying sub-table list header in the sub-table when the sub-table to be integrated is acquired;
the standard format query module (402) is used for querying a total list head corresponding to the sub-list head in a preset total list according to the sub-list head and a standard format corresponding to the total list head;
the preset summary list also comprises a fuzzy name library corresponding to the names of all the summary list titles, and the fuzzy name library comprises fuzzy names corresponding to all the summary list titles;
the step of inquiring the total list head corresponding to the sub-list head in the preset total list according to the sub-list head comprises the following steps:
if the preset summary list has the same summary list header as the sub-list header; setting the same total list head as the sub list head as the total list head corresponding to the sub list head;
If the total list head which is the same as the sub-list head does not exist in the preset total list; inquiring whether the fuzzy name which is the same as the sub-list header exists in the fuzzy name library;
if the fuzzy name which is the 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;
if the fuzzy name which is the same as the sub-list head does not exist, acquiring a first pinyin letter corresponding to the sub-list head;
respectively obtaining second pinyin letters corresponding to all the total list headers;
comparing the first pinyin letters with all the second pinyin letters;
if the target pinyin letters which are the same as the first pinyin letters exist in all the second pinyin letters, setting the total list head corresponding to the target pinyin ancestor as the total list head corresponding to the sub-list head;
a standard format setting module (403) configured to clear a format of column data corresponding to the sub-column header, and reset the column data after the format is cleared according to the standard format to obtain standard data;
a sub-table data integration module (404) configured to integrate the sub-table correspondence into a preset summary table when column data corresponding to all sub-table column headers in the sub-table are reset to standard data;
And the total table data output module (405) is used for outputting the total table when all the sub-tables to be integrated are integrated into the total table.
6. A computer device comprising a memory and a processor, the memory having stored thereon a computer program capable of being loaded by the processor and performing the method according to any of claims 1 to 4.
7. A computer readable storage medium, characterized in that a computer program is stored which can be loaded by a processor and which performs the method according to any of claims 1 to 4.
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 CN115630620A (en) | 2023-01-20 |
| CN115630620B true 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)
| 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 apparatus |
| 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, device and storage medium |
-
2022
- 2022-10-31 CN CN202211348530.6A patent/CN115630620B/en active Active
Patent Citations (9)
| 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 apparatus |
| 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, device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115630620A (en) | 2023-01-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10031649B2 (en) | Automated content detection, analysis, visual synthesis and repurposing | |
| US9092417B2 (en) | Systems and methods for extracting data from a document in an electronic format | |
| CN114207598B (en) | Spreadsheet conversion | |
| US8583679B2 (en) | Method of providing by-viewpoint patent map and system thereof | |
| CN109558513B (en) | Content recommendation method, device, terminal and storage medium | |
| CN105631393A (en) | Information recognition method and device | |
| US20040117341A1 (en) | Concept navigation in data storage systems | |
| US7630961B2 (en) | Method of processing multi-lingual queries | |
| JP2008276736A (en) | Interactive system and program for raising image retrieval performance | |
| JP4502615B2 (en) | Similar sentence search device, similar sentence search method, and program | |
| CN1321392C (en) | Image retrieval device and image display device and method therefor | |
| JP5345963B2 (en) | Method for generating tag data to search for images | |
| CN105893438A (en) | Search prompting method and apparatus | |
| US6606671B1 (en) | Method for analyzing input/output operations of a data processing system | |
| US7170503B2 (en) | Layer editing method and apparatus in a pen computing system | |
| CN115630620B (en) | Method and system for collecting and processing engineering cost analysis data | |
| CN117272953B (en) | Automatic document information filling method, system and storage medium | |
| CN114490627A (en) | Data processing method and device, electronic equipment and storage medium | |
| US7398467B1 (en) | Method and apparatus for providing spelling analysis | |
| CN112035513A (en) | SQL statement performance optimization method, device, terminal and storage medium | |
| CN117034866A (en) | Method, device, computer equipment and storage medium for generating document index label | |
| CN116756261A (en) | GIS data processing method based on relational database management tool | |
| CN116561181A (en) | Data query method, device, computer equipment, and computer-readable storage medium | |
| CN112597040B (en) | Interface automatic testing method and device and electronic equipment | |
| CN115796137A (en) | Method and system for extracting information from tabular data in document |
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 |