CN115757423B - Engineering cost data correction method, system, equipment and storage medium - Google Patents
Engineering cost data correction method, system, equipment and storage medium Download PDFInfo
- Publication number
- CN115757423B CN115757423B CN202211511295.XA CN202211511295A CN115757423B CN 115757423 B CN115757423 B CN 115757423B CN 202211511295 A CN202211511295 A CN 202211511295A CN 115757423 B CN115757423 B CN 115757423B
- Authority
- CN
- China
- Prior art keywords
- format
- data
- sub
- standard
- cells
- 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
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000012986 modification Methods 0.000 claims abstract description 39
- 230000004048 modification Effects 0.000 claims abstract description 39
- 230000002159 abnormal effect Effects 0.000 claims description 20
- 238000010276 construction Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 6
- 230000000694 effects Effects 0.000 abstract description 34
- 230000010354 integration Effects 0.000 abstract description 8
- 230000001502 supplementing effect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a method, a system, equipment and a storage medium for correcting engineering cost data, which are applied to the field of engineering cost, wherein the method comprises the following steps: when receiving the sub-table data to be corrected, sequentially acquiring column data in the sub-table data according to a preset modification sequence; determining an initial format of each cell in the column data, respectively; counting the number of cells corresponding to each initial format in the column data successively, and setting the initial format corresponding to the most cells as a standard format corresponding to the column data; uniformly modifying the format of the column data into a standard format corresponding to the column data; and outputting the modified sub-table when the column data in the sub-table are correspondingly modified into the standard format. The technical effect that this application had is: the data format of the sub-table can be automatically corrected, so that the convenience and the effect of the data integration process are improved.
Description
Technical Field
The present disclosure relates to the field of engineering construction costs, and in particular, to a method, a system, an apparatus, and a storage medium for correcting engineering construction cost data.
Background
The project cost refers to the total cost required for performing a certain project construction, namely the cost of building installation projects and the total cost of the construction projects, which are formed in the transaction activities such as land markets, equipment markets, technical labor markets and the like, for constructing a project.
In the process of counting the construction cost of a certain project, the construction cost is usually split due to huge data volume corresponding to the construction cost, each split sub-table is respectively distributed to corresponding staff for data collection, calculation and input, and then all sub-tables are integrated to obtain final construction cost data.
In the process of implementing the application, the inventor finds that the following problems exist in the process of collecting and integrating engineering cost data: in the process of inputting data into the sub-table by staff, a filling format of partial data may be wrong, so that when the sub-table data is integrated in the later period, the data cannot be displayed normally by the cells with wrong formats, and inconvenience is brought to the data integration process.
Disclosure of Invention
In order to help reduce inconvenience brought to a data integration process by cell format errors, the method, the system, the equipment and the storage medium for correcting engineering cost data are provided.
In a first aspect, the present application provides a method for correcting engineering cost data, which adopts the following technical scheme: the method is applied to a data correction platform; the method comprises the following steps:
when receiving the sub-table data to be corrected, sequentially acquiring column data in the sub-table data according to a preset modification sequence;
determining an initial format of each cell in the column data, respectively;
counting the number of cells corresponding to each initial format in the column data successively, and setting the initial format corresponding to the most cells as a standard format corresponding to the column data;
uniformly modifying the format of the column data into a standard format corresponding to the column data;
and outputting the modified sub-table when the column data in the sub-table are correspondingly modified into the standard format.
Through the technical scheme, after receiving the sub-table data to be corrected, the data correction platform sequentially acquires column data in the sub-table data, then sets the initial format of the corresponding most cells in each column of data as the standard format of the column data, and then correspondingly modifies the format of each column of data into the standard format; therefore, when partial format error cells exist in the sub-table, the data correction platform can automatically adjust the format of the error cells to be the correct format, the effect of automatically correcting the data format of the sub-table is achieved, and the convenience and the effect of the data integration process are improved.
In a specific embodiment, after the sequentially obtaining the column data in the sub-table data according to the preset modification sequence, the method further includes:
sequentially obtaining the title names corresponding to the column data in the sub-table data according to a preset modification sequence;
inquiring a conventional format corresponding to the title name in a preset title name format library;
the setting the initial format corresponding to the most cells to the standard format corresponding to the column data includes:
inquiring whether the initial format of the corresponding most cells exists in the header name format library;
if so, setting the initial format corresponding to the most cells as a standard format corresponding to the column data;
if the initial format of the corresponding most cells does not exist, eliminating the initial format of the corresponding most cells, and then determining the initial format of the corresponding most cells in the column data again until the determined initial format exists in the header name format library, and setting the initial format of the corresponding most cells as a standard format corresponding to the column data.
Through the technical scheme, before the format of the column data in the sub-table is modified into the standard format, firstly, whether the standard format belongs to the conventional format corresponding to the title name is inquired, if not, the current standard format is removed and the standard format is redetermined until the standard format belongs to the conventional format corresponding to the title name, so that the modified format can be mutually corresponding to the title name, and the modification effect of the data correction platform on the sub-table data is further improved.
In a specific embodiment, after the outputting the modified sub-table, the method further includes:
the header name and the standard format corresponding to each column of data in the modified sub-table are stored in a preset historical database in an associated mode;
the uniformly modifying the format of the column data into a standard format corresponding to the column data comprises the following steps:
if the number of the standard formats is unique, uniformly modifying the formats of the column data into standard formats corresponding to the column data;
if the number of the standard formats is not unique, the number of times of using the standard formats is searched in the historical database, and the standard format with the largest number of times of using is set as the unique standard format.
According to the technical scheme, after the data correction platform automatically corrects the format of sub-table data, the header name and the standard format corresponding to each column of data are stored in a preset historical database in an associated mode, then when the standard format corresponding to the most unit cells in a certain column of data is not unique, the record times of a plurality of standard formats corresponding to the column of data are respectively inquired in the database, and then the standard format with the most use times in the historical database is set as the standard format; on one hand, the possibility that the data correction platform is difficult to correct the sub-table data format normally due to the fact that the standard format is not unique is reduced; on the other hand, the setting of the standard format with the largest using times in the historical database is selected, so that the possibility of errors or inapplicability of format modification is reduced, and the correction effect on sub-table data is further improved.
In a specific embodiment, the setting the most frequently used standard format as the unique standard format includes:
if the standard format with the most use times is unique, setting the standard format with the most use times as the unique standard format;
if the standard format with the most use times is not unique, the latest storage time corresponding to the standard format with the most use times is inquired, and the standard format with the latest storage time and the most use times is set as the unique standard format.
Through the technical scheme, when the standard format with the most use times inquired in the historical database is not unique, the standard format with the latest storage time and the most use times is selected as the standard format; and timeliness of the standard format is improved, so that the correction effect of the data correction platform on the sub-table data is further improved.
In a specific implementation manner, after the query of the corresponding title format library of the title names in the preset title format library, the method further includes:
if the header name does not exist in the header name format library, setting the initial format corresponding to the most cells as a standard format corresponding to the column data.
According to the technical scheme, when the header names corresponding to the column data do not exist in the header name format library, namely the header names cannot be identified, the step of checking the correspondence between the standard names and the header names is skipped, and the initial format corresponding to the maximum cells is directly set to the standard format corresponding to the column data, so that the possibility that the data modification system cannot normally modify the sub-table data due to the entry errors of part of the header names is reduced, and the modification effect of the data modification platform on the sub-table data is further improved.
In a specific embodiment, the output modified sub-table includes:
inquiring whether blank cells exist in the cells corresponding to the names of the topic heads in the sub-table data; if the cell corresponding to the title name in the sub-table data does not have a blank cell, outputting a modified sub-table;
if the cell corresponding to the header name in the sub-table data has a blank cell, determining a standard format of column data corresponding to the blank cell;
inquiring a standard name matched with a standard format corresponding to the blank cell in a preset header name format library;
and filling the standard names into the blank cells and outputting the modified sub-table.
Through the technical scheme, when the header name corresponding to the sub-table list data is missing, the data correction platform can correspondingly inquire the standard name corresponding to the standard format in the header name format library according to the standard format of the column data, and then fill the standard name into the blank cell of the missing header name, so that the effect of automatically supplementing the missing header name according to the sub-table data format is achieved, and the correction effect of the data correction platform on the sub-table data is further improved.
In a specific embodiment, the output modified sub-table includes:
traversing the data display condition of each cell in the sub-table data;
if abnormal cells exist, which cannot be displayed completely, of the data, correspondingly adjusting column spacing of the sub-table data according to the positions of the abnormal cells until the abnormal cells, which cannot be displayed completely, do not exist in the sub-table data, and outputting the modified sub-table;
otherwise, directly outputting the modified sub-table.
Through the technical scheme, after the data correction platform corrects the format of the sub-table data, the column spacing of the sub-table data is automatically adjusted, so that cells in the sub-table data can be normally displayed; the method reduces the possibility that the original column spacing of part of the cells can not continuously display the cell data normally due to format change after the data format of the sub-table is adjusted, thereby further improving the correction effect of the data correction platform on the sub-table data.
In a second aspect, the present application provides a construction cost data correction system, which adopts the following technical scheme: the system is applied to a data correction platform; the system comprises:
the sub-table data receiving module is used for sequentially acquiring column data in the sub-table data according to a preset modification sequence when receiving the sub-table data to be modified;
an initial format determining module, configured to determine an initial format of each cell in the column data respectively;
the standard format setting module is used for successively counting the number of cells corresponding to each initial format in the column data and setting the initial format corresponding to the most cells as the standard format corresponding to the column data;
the sub-table format modification module is used for uniformly modifying the format of the column data into a standard format corresponding to the column data;
and the sub-table data output module is used for outputting the modified sub-table when the column data in the sub-table are correspondingly modified into the standard format.
Through the technical scheme, after receiving the sub-table data to be corrected, the data correction platform sequentially acquires column data in the sub-table data, then sets the initial format of the corresponding most cells in each column of data as the standard format of the column data, and then correspondingly modifies the format of each column of data into the standard format; therefore, when partial format error cells exist in the sub-table, the data correction platform can automatically adjust the format of the error cells to be the correct format, the effect of automatically correcting the data format of the sub-table is achieved, and the convenience and the effect of the data integration process are 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 any one of the engineering cost data correction methods described above.
In a fourth aspect, the present application provides a computer readable storage medium, which adopts the following technical solutions: a computer program capable of being loaded by a processor and executing any one of the above construction cost data correction methods is stored.
In summary, the present application includes at least one of the following beneficial technical effects:
1. after receiving the sub-table data to be corrected, the data correction platform sequentially acquires column data in the sub-table data, then sets the initial format of the corresponding most cells in each column of data as the standard format of the column data, and then correspondingly modifies the format of each column of data into the standard format; therefore, when partial format error cells exist in the sub-table, the data correction platform can automatically adjust the format of the error cells to be a correct format, the effect of automatically correcting the data format of the sub-table is achieved, and the convenience and the effect of the data integration process are improved;
2. when the header name corresponding to the sub-table list data is missing, the data correction platform can correspondingly inquire the standard name corresponding to the standard format in the header name format library according to the standard format of the column data, and then fill the standard name into the blank cell of the missing header name, so that the effect of automatically supplementing the missing header name according to the sub-table data format is achieved, and the correction effect of the data correction platform on the sub-table data is further improved.
Drawings
FIG. 1 is a schematic architecture diagram of a data modification platform in an embodiment of the present application.
FIG. 2 is a flow chart of a method of engineering cost data correction in an embodiment of the present application.
Fig. 3 is a block diagram of a construction of the construction cost data correction system in the embodiment of the present application.
Reference numerals: 301. a sub-table data receiving module; 302. an initial format determination module; 303. a standard format setting module; 304. a sub-table format modification module; 305. and the sub-table data output module.
Detailed Description
The present application is described in further detail below in conjunction with figures 1-3.
The embodiment of the application discloses a method for correcting engineering cost data, as shown in fig. 1, when the method is applied to a data correction platform and sub-table data is required to be integrated, a worker can firstly upload a sub-table to be integrated to the data correction platform by using an intelligent terminal such as a mobile phone or a computer, the data correction platform corrects received sub-table data, then feeds back the corrected sub-table to the intelligent terminal of the worker, and automatically sends the corrected sub-table to the intelligent terminal of the integrator after the worker confirms that the worker has no errors, so that the integrator can integrate the data.
As shown in fig. 2, the method comprises the steps of:
s10, when receiving the sub-table data to be corrected, sequentially acquiring column data in the sub-table data according to a preset modification sequence.
Specifically, when receiving a sub-table to be corrected, which is sent by a worker through an intelligent terminal, the data correction platform sequentially acquires column data in the sub-table data according to a preset modification sequence; the preset modification sequence may be left to right or right to left.
S20, determining the initial format of each cell in the column data respectively.
Specifically, when a certain column of data is acquired, the data correction platform will first determine the initial format of each cell corresponding to the column of data.
S30, counting the number of cells corresponding to each initial format in the column data successively, and setting the initial format corresponding to the most cells as a standard format corresponding to the column data.
Specifically, the data correction platform respectively determines initial formats corresponding to the cells of each column of data according to a preset modification sequence, and then sets the initial format corresponding to the most cells to be a standard format corresponding to the column of data; that is, the standard format corresponding to each column of data is determined successively; for example, the initial format in the a-column data has two formats of "x year x month" and "x year x month x day", the number of cells in the a-column data is 50, wherein the initial format of 2 cells is "x year x month", and the format of the remaining 48 cells is "x year x month x day", and the data correction platform determines "x year x month x day" as the standard format corresponding to the a-column data; then, after determining the standard format of the column a data, the standard format of the next column data after the column a data is continuously determined.
And S40, uniformly modifying the format of the column data into a standard format corresponding to the column data.
Specifically, after determining a standard format corresponding to a certain column of data, the data correction platform uniformly corrects the format corresponding to the column of data into the standard format; based on the foregoing example, i.e., the format of the 50 cells corresponding to column a data is all modified to "×year×month×day".
S50, outputting the modified sub-table when column data in the sub-table are correspondingly modified into a standard format.
Specifically, when all column data in the sub-table are modified into the corresponding standard format, that is, each column of data is correspondingly modified into the standard format corresponding to the column of data, the data modification platform outputs the modified sub-table to the intelligent terminal of the staff, and after the staff confirms that the error is absent, the modified sub-table is automatically sent to the intelligent terminal of the integrator, so that the integrator can integrate the data.
When receiving the sub-table data, the data correction platform can adjust the data format of each column in the sub-table to the format with the largest occurrence number in the column, so that when a small amount of errors exist in the format due to user error input or error setting in certain column data, the data correction platform can automatically correct the data format with the errors; therefore, the possibility that the integrated cell with the wrong format cannot normally display data due to the fact that part of data exist in the sub-table and have wrong filling formats is reduced, and the effect of sub-table data integration is improved.
In one embodiment, to further improve the effect of the data correction platform on the correction of sub-table data; after the data correction platform sequentially acquires the column data in the sub-table data according to the preset modification sequence, the following steps can be further executed:
sequentially acquiring the header names corresponding to the column data in the sub-table data according to a preset modification sequence, and then, correspondingly inquiring the conventional formats corresponding to the header names in a preset header name format library; different topic names and conventional formats corresponding to the different topic names are prestored in a preset topic name format library; for example, for the title "accounting date", the corresponding conventional formats in the title format library include ×year×month "," ×year×month×day "," 2020/11/22", and" 11/22", etc.
The step of the data modification platform setting the initial format corresponding to the most cells to the standard format corresponding to the column data may then be specifically performed as follows:
after the data correction platform counts the number of the cells corresponding to each initial format in the column data successively, firstly inquiring whether the initial format corresponding to the most cells exists in the header name format library; if so, setting the initial format corresponding to the most cells as a standard format corresponding to the column data; otherwise, after the initial format corresponding to the most cells is removed, determining the initial format corresponding to the most cells in the column data again, and setting the initial format corresponding to the most cells as a standard format corresponding to the column data until the determined initial format exists in the header name format library. For example, for a certain column of data, the number of cells corresponding to the initial format is arranged in order from large to small: format 1, format 2 and format 3, firstly inquiring whether a conventional format corresponding to the format 1 exists in the title name format library; if so, setting the format 1 as a standard format corresponding to the column data; otherwise, the format 1 is removed, and whether a conventional format corresponding to the format 2 exists in the title name format library is inquired; if so, format 2 is set to the standard format corresponding to the column data.
It should be noted that, if all the initial formats corresponding to the column data do not exist in the header format library, randomly selecting a conventional format corresponding to the column data header as a standard format from the header format library; when the data correction platform corrects the format of the column data, the state that the format of the column data and the column header names are mutually corresponding is always kept, the possibility that data errors or difficult integration conditions occur when the final modified cell format is not corresponding to the column header names and the later data are integrated is reduced, and therefore the correction effect of the data correction platform on the sub-table data is further improved.
In one embodiment, considering that when the data correction platform corrects column data, there may be a case that the initial format corresponding to the most cells in a certain column of data is not unique, so that the standard format corresponding to the column of data cannot be determined, and then the correction effect of the data correction platform is affected; after the data correction platform outputs the modified sub-table, the following steps can be further executed:
the header name and the standard format corresponding to each column of data in the modified sub-table are stored in a preset historical database in an associated mode; the step of the data modification system uniformly modifying the format of the column data into a standard format corresponding to the column data may be specifically performed as follows:
if the number of the standard formats is unique, uniformly modifying the formats of the column data into the standard formats corresponding to the column data; if the number of the standard formats is not unique, namely the initial format corresponding to the most cells in the column data is not unique, the number of times that the standard format is used is respectively queried in the historical database, and the standard format with the most use times is set as the unique standard format. For example, if the initial format of the corresponding most cells in a certain column of data is format 1 and format 2, respectively querying the historical use times corresponding to format 1 and format 2 in the historical database, and then setting the format with more use times as the unique standard format; therefore, on one hand, the possibility that the standard format cannot be determined to influence the correction effect of the data correction platform is reduced, on the other hand, the setting of the standard format with the largest use times in the historical database is selected, and the possibility that the format is corrected in an error or inapplicable condition is also reduced, so that the correction effect on the sub-table data is further improved.
In one embodiment, considering that when the data correction platform corrects the column data, there may be a plurality of cases where the number of corresponding uses of the standard format to be determined in the historical database is the same, so that the data correction system cannot determine the standard format, and then the correction effect of the data correction platform is affected; the step of the data modification platform setting the standard format most frequently used in the history database as the unique standard format may be specifically performed as:
if the standard format with the most use times is unique, setting the standard format with the most use times as the unique standard format; if the standard format with the most use times is not unique, respectively inquiring the latest storage time corresponding to the standard format with the most use times, and then setting the standard format with the latest storage time and the most use times as the unique standard format; for example, if the historical usage times corresponding to format 1 and format 2 in the historical database are the same, the latest storage time of format 1 and format 2 is queried respectively, and if the storage time corresponding to format 1 is 2021, 11, 1, 15, 13 minutes, 14 seconds, and the storage time corresponding to format 2 is 2021, 11, 5, 10, 08 minutes, 40 seconds, format 2 is the only standard format with the latest storage time and the largest usage times. When the data correction platform encounters the condition that the corresponding use times of a plurality of standard formats to be determined in the historical database are the same, the standard format with the latest storage time and the highest use times in the historical database is automatically selected as the unique standard format, so that the possibility that the data correction platform cannot determine the standard format is reduced; on the other hand, the timeliness of the standard format is improved by selecting the standard format with the latest storage time, so that the standard format finally determined is the standard format which is used recently, and the correction effect of the data correction platform on the sub-table is further improved.
In one embodiment, the situation that the data correction platform cannot query the title name in the title name format library is considered in consideration of the situation that the corresponding title name in the column data may be input by mistake or have wrongly written characters and the like by staff; in order to further improve the correction effect of the data correction platform on the sub-table, after the step of querying the corresponding header names in the preset header name format library by the data correction platform, the following steps may be further executed:
if the header name corresponding to the column data header name does not exist in the header name format library, that is, the problem that the header name is difficult to inquire in the header name format library is caused by the fact that a worker inputs the header name by mistake or the header name has wrongly written characters and the like; the data correction system directly sets the initial format corresponding to the most cells to be the standard format corresponding to the column data, and uniformly adjusts the format of the column data according to the standard format; therefore, the possibility that the data correction platform is difficult to adjust aiming at the format of the column data due to the fact that the column data header name is abnormal is reduced, and the correction effect of the data correction platform on the sub-table is further improved.
In one embodiment, consider the situation that there may be a missing topic name in the word list, that is, the situation that the staff member omits to input a topic name corresponding to a certain column; in order to further improve the correction effect of the data correction platform on the sub-table; the step of the data modification platform outputting the modified sub-table may be specifically performed as:
when the data correction platform correspondingly corrects column data in the sub-table into a standard format, firstly inquiring whether blank cells exist in cells corresponding to the head names in the sub-table data; if the blank cell does not exist, directly outputting the modified sub-table; if the blank cells exist, determining a standard format of column data corresponding to the blank cells, inquiring a standard name matched with the standard format in a preset header name format library, filling the standard name into the blank cells, and outputting a modified sub-table; for example, if the standard format is "×year×month×day", the standard name corresponding to the standard format, which is searched in the preset header name format library, is "accounting date"; therefore, the effect of automatically supplementing the missing title according to the format condition of the column data is achieved, and the correction effect of the data correction platform on the sub-table is further improved.
If the sub-table data has blank cell, the data correction system will determine that the abnormal condition exists in the header name, then directly set the initial format corresponding to the most cells as the standard format corresponding to the column data, and uniformly adjust the format of the column data according to the standard format; therefore, before the sub-table data is output, the standard format is also existed for the column data with blank header names, so that the data correction platform can query the standard name corresponding to the column data according to the standard format, and then automatically set the standard name as the header name of the column data.
In one embodiment, it is considered that after the data correction platform adjusts the format of the column data, there may be a situation that the column spacing of a certain column data is not changed due to the format change of the column data, so that the column data cannot be displayed normally; for example, when a cell of the initial format "x year x month" is adjusted to "x year x month x day", data of the format "x year x month x day" cannot be normally displayed at a column pitch corresponding to the original format "x year x month". In order to further improve the correction effect of the data correction platform on the sub-table; the step of the data modification platform outputting the modified sub-table may be specifically performed as:
the data correction platform firstly traverses the data display condition of each cell in the sub-table data, and if no abnormal cell exists in which the data cannot be completely displayed, the modified sub-table is directly output to the intelligent terminal of the staff; if abnormal cells exist, which cannot be displayed completely, of the data, correspondingly adjusting column spacing of the sub-table data according to the positions of the abnormal cells until the abnormal cells, which cannot be displayed completely, do not exist in the sub-table data, and outputting the modified sub-table; based on the foregoing example, that is, the column pitch corresponding to the abnormal cell which cannot be displayed completely is increased, i.e., "×year×month×day", so that "×year×month×day" can be displayed completely; the abnormal cells which cannot be displayed completely do not exist in the sub-table finally output by the data correction platform, so that the correction effect of the data correction platform on the sub-table is further improved.
FIG. 2 is a flow chart of a method of correcting manufacturing cost data in one embodiment. It should be understood that, although the steps in the flowchart of fig. 2 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. 2 may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the other steps or sub-steps of other steps.
Based on the method, the embodiment of the application also discloses a construction cost data correction system,
as shown in fig. 3, the system is applied to a data correction platform, and comprises the following modules:
the sub-table data receiving module 301 is configured to, when receiving sub-table data to be corrected, sequentially obtain column data in the sub-table data according to a preset modification sequence;
an initial format determining module 302, configured to determine an initial format of each cell in the column data;
a standard format setting module 303, configured to successively count the number of cells corresponding to each initial format in the column data, and set the initial format corresponding to the most cells as the standard format corresponding to the column data;
the sub-table format modification module 304 is configured to uniformly modify the format of the column data into a standard format corresponding to the column data;
the sub-table data output module 305 is configured to output the modified sub-table when column data in the sub-table is correspondingly modified to a standard format.
In one embodiment, the sub-table data receiving module 301 is further configured to sequentially obtain, according to a preset modification sequence, a header name corresponding to column data in the sub-table data; inquiring a corresponding conventional format of the title in a preset title format library; the standard format setting module 303 is further configured to query whether an initial format corresponding to the most cells exists in the header name format library; if so, setting the initial format corresponding to the most cells as a standard format corresponding to the column data; if the initial format of the corresponding most cells does not exist, eliminating the initial format of the corresponding most cells, and then determining the initial format of the corresponding most cells in the column data again until the determined initial format exists in the header name format library, and setting the initial format of the corresponding most cells as a standard format corresponding to the column data.
In one embodiment, the sub-table data output module 305 is further configured to store the header name and the standard format associated with each column of data in the modified sub-table into a preset history database; uniformly modifying the format of the column data to a standard format corresponding to the column data includes: if the number of the standard formats is unique, uniformly modifying the formats of the column data into the standard formats corresponding to the column data; if the number of the standard formats is not unique, the number of times of using the standard format is searched in the history database, and the standard format with the largest number of times of using is set as the unique standard format.
In one embodiment, the standard format setting module 303 is specifically configured to set, if the standard format with the largest number of uses is unique, the standard format with the largest number of uses as the unique standard format; if the standard format with the most use times is not unique, the latest storage time corresponding to the standard format with the most use times is inquired, and the standard format with the latest storage time and the most use times is set as the unique standard format.
In one embodiment, the standard format setting module 303 is further configured to set the initial format corresponding to the most cells to the standard format corresponding to the column data if the header name format library corresponding to the header name does not exist in the header name format library.
In one embodiment, the sub-table data output module 305 is further configured to query whether a blank cell exists in a cell corresponding to the header name in the sub-table data; if the cell corresponding to the title name in the sub-table data does not have a blank cell, outputting a modified sub-table; if the cell corresponding to the header name in the sub-table data has a blank cell, determining a standard format of column data corresponding to the blank cell; inquiring a standard name matched with a standard format corresponding to the blank cell in a preset header name format library; and filling the standard names into the blank cells and outputting the modified sub-table.
In one embodiment, the sub-table data output module 305 is further configured to traverse the data display condition of each cell in the sub-table data; if abnormal cells exist, which cannot be displayed completely, of the data, correspondingly adjusting column spacing of the sub-table data according to the positions of the abnormal cells until the abnormal cells, which cannot be displayed completely, do not exist in the sub-table data, and outputting the modified sub-table; otherwise, directly outputting the modified sub-table.
The embodiment of the application also discloses a computer device.
Specifically, the computer device includes a memory and a processor, and the memory stores a computer program that can be loaded by the processor and execute the construction cost data correction method described above.
The embodiment of the application also discloses a computer readable storage medium.
Specifically, the computer-readable storage medium storing a computer program that can be loaded by a processor and that executes the engineering cost data correction method as described above, for example, includes: 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 (4)
1. The engineering cost data correction method is characterized in that the method is applied to a data correction platform; the method comprises the following steps:
when receiving the sub-table data to be corrected, sequentially acquiring column data in the sub-table data according to a preset modification sequence;
determining an initial format of each cell in the column data, respectively;
counting the number of cells corresponding to each initial format in the column data successively, and setting the initial format corresponding to the most cells as a standard format corresponding to the column data; wherein the setting the initial format corresponding to the most cells to the standard format corresponding to the column data includes: inquiring whether the initial format of the corresponding most cells exists in a header name format library; if so, setting the initial format corresponding to the most cells as a standard format corresponding to the column data; if the initial format of the corresponding most cells does not exist, eliminating the initial format of the corresponding most cells, and then determining the initial format of the corresponding most cells in the column data again until the determined initial format exists in the header name format library, and setting the initial format of the corresponding most cells as a standard format corresponding to the column data;
uniformly modifying the format of the column data into a standard format corresponding to the column data; the step of uniformly modifying the format of the column data into a standard format corresponding to the column data comprises the step of uniformly modifying the format of the column data into a standard format corresponding to the column data if the number of the standard formats is unique; if the number of the standard formats is not unique, querying the number of times of using the standard formats in a history database respectively, and setting the standard format with the largest number of times of using as the unique standard format; setting the standard format with the most use times as a unique standard format comprises setting the standard format with the most use times as the unique standard format if the standard format with the most use times is unique; if the standard format with the most use times is not unique, inquiring the latest storage time corresponding to the standard format with the most use times, and setting the standard format with the latest storage time and the most use times as the unique standard format;
outputting a modified sub-table when column data in the sub-table are correspondingly modified into a standard format; the sub-table after modification is output, wherein the sub-table after modification comprises the step of inquiring whether blank cells exist in cells corresponding to the title in sub-table data; if the cell corresponding to the title name in the sub-table data does not have a blank cell, outputting a modified sub-table; if the cell corresponding to the header name in the sub-table data has a blank cell, determining a standard format of column data corresponding to the blank cell; inquiring a standard name matched with a standard format corresponding to the blank cell in a preset header name format library; filling the standard names into the blank cells and outputting modified sub-tables; traversing the data display condition of each cell in the sub-table data; if abnormal cells exist, which cannot be displayed completely, of the data, correspondingly adjusting column spacing of the sub-table data according to the positions of the abnormal cells until the abnormal cells, which cannot be displayed completely, do not exist in the sub-table data, and outputting the modified sub-table; otherwise, directly outputting the modified sub-table;
after the column data in the sub-table data are sequentially acquired according to the preset modification sequence, sequentially acquiring the topic names corresponding to the column data in the sub-table data according to the preset modification sequence;
inquiring a conventional format corresponding to the title name in a preset title name format library;
if the header names do not exist in the header name format library, setting the initial format corresponding to the most cells as a standard format corresponding to the column data;
and after the modified sub-table is output, storing the header name and standard format associated with each column of data in the modified sub-table into a preset historical database.
2. A construction cost data correction system, which is characterized in that the system is applied to a data correction platform; the system comprises:
the sub-table data receiving module is used for sequentially acquiring column data in the sub-table data according to a preset modification sequence when receiving the sub-table data to be modified;
an initial format determining module, configured to determine an initial format of each cell in the column data respectively;
the standard format setting module is used for successively counting the number of cells corresponding to each initial format in the column data and setting the initial format corresponding to the most cells as the standard format corresponding to the column data; wherein the setting the initial format corresponding to the most cells to the standard format corresponding to the column data includes: inquiring whether the initial format of the corresponding most cells exists in a header name format library; if so, setting the initial format corresponding to the most cells as a standard format corresponding to the column data; if the initial format of the corresponding most cells does not exist, eliminating the initial format of the corresponding most cells, and then determining the initial format of the corresponding most cells in the column data again until the determined initial format exists in the header name format library, and setting the initial format of the corresponding most cells as a standard format corresponding to the column data;
the sub-table format modification module is used for uniformly modifying the format of the column data into a standard format corresponding to the column data;
the sub-table data output module is used for uniformly modifying the format of the column data into a standard format corresponding to the column data if the number of the standard formats is unique; if the number of the standard formats is not unique, querying the number of times of using the standard formats in a history database respectively, and setting the standard format with the largest number of times of using as the unique standard format;
the standard format setting module is further configured to set the standard format with the largest number of uses as a unique standard format, and if the standard format with the largest number of uses is unique, set the standard format with the largest number of uses as a unique standard format; if the standard format with the most use times is not unique, inquiring the latest storage time corresponding to the standard format with the most use times, and setting the standard format with the latest storage time and the most use times as the unique standard format;
the sub-table data output module is used for outputting the modified sub-table when the column data in the sub-table are correspondingly modified into the standard format; the sub-table after modification is output, wherein the sub-table after modification comprises the step of inquiring whether blank cells exist in cells corresponding to the title in sub-table data; if the cell corresponding to the title name in the sub-table data does not have a blank cell, outputting a modified sub-table; if the cell corresponding to the header name in the sub-table data has a blank cell, determining a standard format of column data corresponding to the blank cell; inquiring a standard name matched with a standard format corresponding to the blank cell in a preset header name format library; filling the standard names into the blank cells and outputting modified sub-tables; traversing the data display condition of each cell in the sub-table data; if abnormal cells exist, which cannot be displayed completely, of the data, correspondingly adjusting column spacing of the sub-table data according to the positions of the abnormal cells until the abnormal cells, which cannot be displayed completely, do not exist in the sub-table data, and outputting the modified sub-table; otherwise, directly outputting the modified sub-table;
the sub-table data receiving module is further used for sequentially obtaining the topic names corresponding to the column data in the sub-table data according to a preset modification sequence; inquiring a conventional format corresponding to the title name in a preset title name format library;
the standard format setting module is further configured to set an initial format corresponding to the most cells to a standard format corresponding to the column data if the header name does not exist in the header name format library;
the sub-table data output module is further used for storing the header name and the standard format corresponding to each column of data in the modified sub-table in a preset historical database in an associated mode.
3. 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 performs the method of claim 1.
4. 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 as claimed in claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211511295.XA CN115757423B (en) | 2022-11-29 | 2022-11-29 | Engineering cost data correction method, system, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211511295.XA CN115757423B (en) | 2022-11-29 | 2022-11-29 | Engineering cost data correction method, system, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115757423A CN115757423A (en) | 2023-03-07 |
| CN115757423B true CN115757423B (en) | 2024-01-30 |
Family
ID=85340199
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211511295.XA Active CN115757423B (en) | 2022-11-29 | 2022-11-29 | Engineering cost data correction method, system, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115757423B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299081A (en) * | 2018-08-21 | 2019-02-01 | 中国平安人寿保险股份有限公司 | Clean method, apparatus, computer equipment and the storage medium of room rate data |
| CN109902272A (en) * | 2019-01-28 | 2019-06-18 | 平安科技（深圳）有限公司 | Electronic form data processing method, device, computer equipment and storage medium |
| CN111026757A (en) * | 2019-12-10 | 2020-04-17 | 首都医科大学附属北京友谊医院 | Method, device, equipment and storage medium for generating standard statistical format data |
| WO2020232880A1 (en) * | 2019-05-21 | 2020-11-26 | 平安科技（深圳）有限公司 | Data processing method and apparatus, storage medium and terminal device |
| CN112818937A (en) * | 2021-03-02 | 2021-05-18 | 广联达科技股份有限公司 | Excel file identification method and device, electronic equipment and readable storage medium |
| CN113204555A (en) * | 2021-05-21 | 2021-08-03 | 北京字跳网络技术有限公司 | Data table processing method and device, electronic equipment and storage medium |
| CN114036914A (en) * | 2021-10-20 | 2022-02-11 | 珠海金山办公软件有限公司 | Table data processing method and device, electronic equipment and storage medium |
| CN114239507A (en) * | 2021-12-01 | 2022-03-25 | 东软集团股份有限公司 | Data processing method, data processing apparatus, storage medium, computer device, and program product |
| CN114356903A (en) * | 2021-12-17 | 2022-04-15 | 四川新网银行股份有限公司 | Column correlation relationship discovery device and method of self-adaptive data structure |
-
2022
- 2022-11-29 CN CN202211511295.XA patent/CN115757423B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299081A (en) * | 2018-08-21 | 2019-02-01 | 中国平安人寿保险股份有限公司 | Clean method, apparatus, computer equipment and the storage medium of room rate data |
| CN109902272A (en) * | 2019-01-28 | 2019-06-18 | 平安科技（深圳）有限公司 | Electronic form data processing method, device, computer equipment and storage medium |
| WO2020232880A1 (en) * | 2019-05-21 | 2020-11-26 | 平安科技（深圳）有限公司 | Data processing method and apparatus, storage medium and terminal device |
| CN111026757A (en) * | 2019-12-10 | 2020-04-17 | 首都医科大学附属北京友谊医院 | Method, device, equipment and storage medium for generating standard statistical format data |
| CN112818937A (en) * | 2021-03-02 | 2021-05-18 | 广联达科技股份有限公司 | Excel file identification method and device, electronic equipment and readable storage medium |
| CN113204555A (en) * | 2021-05-21 | 2021-08-03 | 北京字跳网络技术有限公司 | Data table processing method and device, electronic equipment and storage medium |
| CN114036914A (en) * | 2021-10-20 | 2022-02-11 | 珠海金山办公软件有限公司 | Table data processing method and device, electronic equipment and storage medium |
| CN114239507A (en) * | 2021-12-01 | 2022-03-25 | 东软集团股份有限公司 | Data processing method, data processing apparatus, storage medium, computer device, and program product |
| CN114356903A (en) * | 2021-12-17 | 2022-04-15 | 四川新网银行股份有限公司 | Column correlation relationship discovery device and method of self-adaptive data structure |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115757423A (en) | 2023-03-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7392267B2 (en) | Annotation validity using partial checksums | |
| CN113434328B (en) | Logic configuration compiling error correction method and system for distributed control system | |
| CN110502384B (en) | Parameter calibration method, device, equipment and storage medium for electronic component | |
| CN115730008A (en) | Log analysis method, data synchronization system, electronic device and storage medium | |
| CN111199146B (en) | Test report generation method, device, computer equipment and storage medium | |
| US20120259872A1 (en) | Automatically Generating Data Transformations for Business Process Platforms | |
| CN115757423B (en) | Engineering cost data correction method, system, equipment and storage medium | |
| EP0498367A2 (en) | Program debugging device and process | |
| CN116089530A (en) | Mass data transmission control method, device and equipment | |
| CN115622890A (en) | Data configuration method and device, computer equipment and storage medium | |
| CN110807037B (en) | Data modification method and device, electronic equipment and storage medium | |
| CN110688395A (en) | Information query method, device, information statistical method and related equipment | |
| CN112632132A (en) | Method, device and equipment for processing abnormal import data | |
| US9940405B2 (en) | Automatically optimizing business process platforms | |
| CN111949728A (en) | Dynamic data difference comparison method and system | |
| CN111813769A (en) | Data processing method and device | |
| CN100334587C (en) | Method and system of data management and database | |
| CN115658778B (en) | Excel data source-based data processing method for visual application creation | |
| CN114826909B (en) | Server production instruction information maintenance system, method, device and storage medium | |
| CN113495831B (en) | Method, system, equipment and medium for generating test case based on keywords | |
| CN110609984B (en) | Method and system for automatically splitting Google key in Windows system | |
| CN114116747B (en) | Production execution system data analysis method and device | |
| CN113468155B (en) | Question data processing method and device | |
| CN117494678A (en) | Number generation method, system and storage medium after online form data insertion | |
| CN116756129A (en) | Data complement method and device, storage medium and electronic equipment |
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 |