CN105225076B - Cost analysis data acquisition and processing system - Google Patents
Cost analysis data acquisition and processing system Download PDFInfo
- Publication number
- CN105225076B CN105225076B CN201510769064.2A CN201510769064A CN105225076B CN 105225076 B CN105225076 B CN 105225076B CN 201510769064 A CN201510769064 A CN 201510769064A CN 105225076 B CN105225076 B CN 105225076B
- Authority
- CN
- China
- Prior art keywords
- data
- cost analysis
- checking
- party
- basic
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A cost analysis data collection and processing system comprising: the form acquisition module is used for acquiring a form containing basic data of the cost analysis indexes; the form checking module is used for checking the collected forms to be input and the third-party forms; the form uploading module is used for uploading the successfully verified form to be input or the third-party form to the system and storing the successfully verified form to the memory of the system; the data checking module is used for checking the cost analysis index basic data in each cell in the form to be input or the third-party form; the data summarization module is used for summarizing the cost analysis index basic data which are successfully verified into various cost analysis indexes according to data types and inputting the cost analysis index basic data into a cost analysis basic database; and the data output module is used for extracting the cost analysis indexes corresponding to the required categories of the report form from the cost analysis basic database.
Description
Technical Field
The invention relates to the field of computer informatization application management, in particular to a cost analysis data acquisition and processing system.
Background
In the power grid project, the cost data report is used for providing reliable methods and bases for professional management and analysis work such as project investment control, cost level analysis, project decision analysis and the like, wherein the cost data report comprises cost analysis results such as estimation, approximate calculation, settlement data and the like according to collected cost data. In addition, because no unified data acquisition and reporting standard exists, the acquired cost analysis sample data adopts different pricing modes, so that the data analysis operation is complicated and time-consuming, the accuracy is difficult to guarantee, the management and control difficulty of the cost data is increased, and the reference value of the report is reduced.
Disclosure of Invention
Accordingly, there is a need for a cost analysis data collection and processing system.
The embodiment of the invention provides a cost analysis data acquisition and processing system, which can comprise:
the form acquisition module is used for acquiring a form containing the cost analysis index basic data, wherein the form containing the cost analysis index basic data comprises any one or two of a form to be input uploaded by input personnel and a third-party form generated by third-party software;
the form checking module is used for checking the collected form to be input and the third-party form;
the form uploading module is used for uploading the successfully verified form to be input or the third-party form to the system and storing the successfully verified form to be input or the third-party form in a memory of the system;
the data checking module is used for checking the cost analysis index basic data in each cell in the form to be input or the third-party form;
the data summarization module is used for summarizing the cost analysis index basic data which are successfully verified into various cost analysis indexes according to data types and inputting the cost analysis basic data into a cost analysis basic database, wherein the data types comprise at least one of engineering basic information, technical and economic parameters, approximate calculation cost indexes and settlement cost indexes;
the data output module is used for extracting cost analysis indexes corresponding to the types required by the report forms from the cost analysis basic database; the system is also used for generating a cost analysis index report by adopting a required format report template based on the cost analysis index corresponding to the required category of the report, wherein the required category comprises one or more of power transmission and transformation project category, implementation unit, main transformer parameter, outgoing line return parameter at the present stage, power distribution form, circuit breaker number parameter, wiring form, reactor parameter and technical material parameter;
the business module is used for calculating cost analysis technical indexes according to the cost analysis index basic data in the cost analysis basic database; and the system is also used for inquiring the cost analysis technical index according to the required inquiry and screening conditions.
Preferably, the form collection module includes:
a specification form providing unit, configured to provide a download file of the specification form, so that the entering personnel can manually enter the cost analysis index basic data, where the specification form is an EXCEL form data form, and the form in which the cost analysis index basic data is entered is the form to be entered;
the data receiving unit is used for receiving the imported form to be input;
or, the data receiving unit is further configured to receive the third-party table that includes the cost analysis index basic data and is generated by the third-party software.
Preferably, the table checking module comprises:
the basic information checking unit is used for checking the file format, the file data volume, the number and the name of the contained worksheets and the contained header information of the form to be entered, if the file format of the form to be entered is correct, the file data volume of the form to be entered meets the standard data volume, the number of the worksheets contained in the form to be entered is consistent with the standard number, and the header information contained in the form to be entered meets the header information requirement, the basic information checking unit is successful in checking, and if not, the basic information checking unit is failed in checking;
the content checking unit is used for checking whether one of a piece of data which only has a project name and lacks the cost analysis index basic data corresponding to the project name, a piece of data which comprises two or more pieces of data with the same project name and a piece of data which does not fill in a necessary filling cell exists in the form to be input, if one of the piece of data which only has the project name and lacks the cost analysis index basic data corresponding to the project name, the piece of data which comprises the two or more pieces of data with the same project name and the piece of data which does not fill in the necessary filling cell exists in the form to be input, the content checking unit fails to check, and if not, the content checking unit succeeds in checking;
alternatively, the first and second electrodes may be,
the basic information checking unit is further configured to check a file format, a file data amount, the number and name of included worksheets, and included header information of the third-party form, and if the file format of the third-party form is correct, the file data amount of the third-party form meets a standard data amount, the number of the worksheets included in the third-party form is consistent with the standard number, and the header information included in the third-party form meets a header information requirement, the basic information checking unit is checked successfully, otherwise, the basic information checking unit is checked unsuccessfully;
the content checking unit is further configured to check whether one of a piece of data including only a project name and lacking the cost analysis index basic data corresponding to the project name, a piece of data including two or more pieces of data having the same project name, and a piece of data not filled in a necessary filling cell exists in the third-party table, and if one of the piece of data including only a project name and lacking the cost analysis index basic data corresponding to the project name, the piece of data including the two or more pieces of data having the same project name, and the piece of data not filled in the necessary filling cell exists in the third-party table, the content checking unit fails to check, otherwise, the content checking unit succeeds in checking;
and the verification failure prompt module is used for generating a verification failure prompt message when the basic information verification unit or the content verification unit fails in verification.
Preferably, the data verification module includes:
the data checking unit is used for checking the cost analysis index basic data in each cell in the table to be input, and highlighting the cells containing data which do not meet the data type, the cells containing data which do not meet the data range and the cells containing data which do not meet the content length so as to prompt the abnormal data of the cells;
the calculation and verification unit is used for verifying the calculation result of each cell according to the calculation relational expression set in each cell in the table to be input, and highlighting the cell with the wrong calculation result to prompt that the cell result is abnormal;
alternatively, the first and second electrodes may be,
the data checking unit is used for checking the cost analysis index basic data in each cell in the third-party table, and highlighting the cells containing data which do not meet the data type, the cells containing data which do not meet the data range and the cells containing data which do not meet the content length so as to prompt the abnormal data of the cells;
and the calculation and verification unit is used for verifying the calculation result of each cell according to the calculation relational expression set in each cell in the third party table and highlighting the cell with the wrong calculation result to prompt that the cell result is abnormal.
The cost analysis data acquisition and processing system provided by the embodiment of the invention improves the reporting and acquisition modes of the cost analysis data, provides a standard form and a specified third-party software or EXCEL form for a data acquisition scheme, improves the normalization and the reliability of the acquired data, establishes a cost analysis base database for cost index data analysis, and provides reference report data for professional management analysis work such as project investment control, cost level analysis, engineering decision analysis and the like.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments are briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic diagram of the architecture of a cost analysis data acquisition and processing system in accordance with a preferred embodiment.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a cost analysis data collecting and processing system, which may include:
the form acquisition module 11 is used for acquiring forms containing basic data of the cost analysis indexes, wherein the mentioned forms containing the basic data of the cost analysis indexes can comprise any one or two of forms to be recorded uploaded by recording personnel and third-party forms generated by third-party software, or more forms containing the basic data of the cost analysis indexes;
the form checking module 12 is used for checking the collected forms to be input and the third-party forms by the form collecting module 11;
the form uploading module 13 is used for uploading the successfully verified form to be entered or the third-party form to the system and storing the successfully verified form to the memory of the system;
the data checking module 14 is used for checking the cost analysis index basic data in each cell in the form to be entered or the third-party form;
a data summarizing module 15, configured to summarize cost analysis index basic data successfully verified by the data verifying module 14 into each cost analysis index according to a data category, and input the cost analysis index basic data into a cost analysis basic database, where the data category includes at least one of engineering basic information, technical and economic parameters, approximate cost index, and settlement cost index; the cost analysis basic database summarizes various index information and can be used for functions of inquiry, classification and summarization and the like, and the system can automatically classify and summarize the cost analysis indexes of the power transmission and transformation project according to the types of the power transmission and transformation project (power transformation, overhead lines, cables, communication equipment, communication optical cables, etc.), implementation units, voltage grades and the like so as to realize the centralized management of cost data files, the management of cost analysis index data and the combined reference of cost analysis index conditions.
A data output module 16, which is used for extracting the cost analysis index corresponding to the category required by the report form from the cost analysis basic database; the system is also used for generating a cost analysis index report by adopting a required format report template based on cost analysis indexes corresponding to required categories of the report, wherein the required categories comprise one or more of power transmission and transformation project categories, implementation units, main transformer parameters, outgoing line return parameters in the period, power distribution forms, circuit breaker number parameters, wiring forms, reactor parameters and technical material parameters; the data in the report can also comprise project estimation, approximate calculation and settlement data. The system provides the customization function of the index report, can flexibly customize the report, and realizes the cost analysis of the national power grid company and the cost analysis index report of the unit. The method mainly comprises the following steps: (1) standard index template: the system defaults a national power grid and a unit cost analysis report template; (2) flexibly customizing the report form: the output report format can be flexibly set, and meanwhile, the index report template can be selected for adjustment to form a new index report; (3) and (4) report result output: and selecting a project for reference analysis by setting a main network project reference item. Such as: and filtering fields such as voltage class, power supply company, transformer substation type, power distribution device type, wiring type and the like to obtain corresponding projects. According to the customized report format and the screened project set, the system reads the indexes corresponding to the main network project to form a national power grid and unit cost analysis basic data report and realize the derivation of the report data;
a service module 17, configured to calculate a cost analysis skill index according to the cost analysis index basic data in the cost analysis basic database; and the method is also used for inquiring cost analysis technical indexes according to the required inquiry and screening conditions. Wherein the technical index is calculated according to the engineering estimation, the approximate calculation and the settlement data.
Further optionally, the form collection module 11 according to the embodiment of the present invention may further include:
further optionally, according to the type of the table of the cost analysis index basic data, the table collection module 11 in the embodiment of the present invention may further implement a collection function through the specification table providing unit 111, the data receiving unit 112, and the data receiving unit 112:
the standard form providing unit 111 is used for providing a download file of a standard form so that an entry worker can manually enter the basic data of the cost analysis index, the standard form is an EXCEL form data form, and the form with the basic data of the cost analysis index is entered as a form to be entered; the standard form is set by a power grid entry worker according to actual needs, wherein filling modes, data units, calculation rules and the like are specified for standardizing entry contents of the entry worker, the entry worker can directly and manually input cost analysis index basic data to a system at a user terminal, and the standard form is provided for the entry worker for downloading units which can avoid the entry worker from entering redundant contents or missing filling, filling-less contents and standardizing entry data;
a data receiving unit 112, configured to receive an imported form to be entered;
the data receiving unit 112 is further configured to receive a third-party table generated by third-party software and containing basic data of the cost analysis index. The third-party software may be designated by a power grid worker, for example, 2008 (06), 2014 (13), 2012, etc. in the boco-micro software, and may pre-establish a field correspondence rule between the third-party software and the basic data of the required cost analysis index, so that the data receiving unit 112 may read the index value in the file one by one or synchronously according to the field correspondence rule, and the file in the boco-micro software format may include an approximate calculation file and an as-built settlement file.
The form verification module 12 of the embodiment of the present invention may be configured to verify the form, and when the verification is successful, the form may be further uploaded, and if the verification fails, the form is not uploaded and prompted. The table verification module 12 of the embodiment of the present invention may further implement a verification function through the basic information verification unit 121, the content verification unit 122, and the verification failure prompt module 123:
the basic information checking unit 121 is configured to check a file format, a file data amount, the number and name of included worksheets, and included header information of the form to be entered, where if the file format of the form to be entered is correct, the file data amount of the form to be entered meets the standard data amount, the number of worksheets included in the form to be entered is consistent with the standard number, and the header information included in the form to be entered meets the header information requirement, the basic information checking unit 121 succeeds in checking, and otherwise, the basic information checking unit 121 fails in checking; if the file format is specified with suffix names of × xls and × xlsx, the basic information verification unit 121 should check whether the file suffix name of the table to be entered is one of × xls and × xlsx; the file data amount may be a prescribed value, for example, 200, and then the basic information verification unit 121 should check whether the number of data pieces to be entered into the form exceeds 200 when detecting; the number and name of the included worksheets may be specified, for example, it is specified that the uploaded worksheets only include 8 worksheets, and the names of the worksheets must include 8 worksheets of a power transformation project, an overhead line, a cable line, a communication device, a communication cable, a rural power grid power transformation project, a rural power grid overhead line, and a rural power grid cable line, so that the basic information checking unit 121 should check whether the worksheets to be entered include and include only the 8 worksheets during the detection; the header information is used for expressing the attribute of the table, can specify the content of the header information, and check whether the uploaded table is consistent with the specified content of the header information;
the content checking unit 122 is configured to check whether one of a piece of data including only a project name and lacking cost analysis index basic data corresponding to the project name, a piece of data including two or more pieces of data having the same project name, and a piece of data not filled in the necessary filling cells exists in the to-be-entered form, and if one of the piece of data including only the project name and lacking cost analysis index basic data corresponding to the project name, the piece of data including two or more pieces of data having the same project name, and the piece of data not filled in the necessary filling cells exists in the to-be-entered form, the content checking unit 122 fails in checking, otherwise, the content checking unit 122 succeeds in checking;
the basic information checking unit 121 is further configured to check a file format, a file data amount, the number and name of included worksheets, and included header information of the third-party form, where if the file format of the third-party form is correct, the file data amount of the third-party form meets the standard data amount, the number of worksheets included in the third-party form is consistent with the standard number, and the header information included in the third-party form meets the header information requirement, the basic information checking unit 121 succeeds in checking, and otherwise, the basic information checking unit 121 fails in checking; if the file format is specified with suffix names of × xls and × xlsx, the basic information verification unit 121 should check whether the file suffix name of the table to be entered is one of × xls and × xlsx; the file data amount may be a prescribed value, for example, 200, and then the basic information verification unit 121 should check whether the number of data pieces to be entered into the form exceeds 200 when detecting; the number and name of the included worksheets may be specified, for example, it is specified that the uploaded worksheets only include 8 worksheets, and the names of the worksheets must include 8 worksheets of a power transformation project, an overhead line, a cable line, a communication device, a communication cable, a rural power grid power transformation project, a rural power grid overhead line, and a rural power grid cable line, so that the basic information checking unit 121 should check whether the worksheets to be entered include and include only the 8 worksheets during the detection; the header information is used for expressing the attribute of the table, can specify the content of the header information, and check whether the uploaded table is consistent with the specified content of the header information;
the content checking unit 122 is further configured to check whether one of a piece of data, two or more pieces of data, and a piece of data, which contains only the project name and lacks the cost analysis index basic data corresponding to the project name, a piece of data, which contains two or more pieces of same project name, and a piece of data, which does not fill the necessary cell, exists in the third-party table, if one of the piece of data, the piece of data;
and the verification failure prompt module 123 is configured to generate a verification failure prompt message when the basic information verification unit or the content verification unit fails to verify.
Further optionally, after the table upload module 13 uploads the table successfully verified by the table verification module 12, the data verification module 14 in the embodiment of the present invention may further verify the data in the table through the data verification unit 141 and the calculation verification unit 142:
the data checking unit 141 is used for checking the cost analysis index basic data in each cell in the table to be entered, and highlighting the cells containing data which do not satisfy the data type, the cells containing data which do not satisfy the data range and the cells containing data which do not satisfy the content length so as to prompt the abnormal data of the cells;
the calculation and verification unit 142 is used for verifying the calculation result of each cell according to the calculation relational expression set in each cell in the table to be entered, and highlighting the cell with the wrong calculation result to prompt that the cell result is abnormal;
the data checking unit 141 is used for checking the cost analysis index basic data in each cell in the third-party table, and highlighting the cells containing data which do not satisfy the data type, the cells containing data which do not satisfy the data range, and the cells containing data which do not satisfy the content length so as to prompt the abnormal data of the cells;
and the calculation and verification unit 142 is configured to verify the calculation result of each cell according to the calculation relational expression set in each cell in the third square table, and highlight the cell with the wrong calculation result to prompt that the cell result is abnormal.
The cost analysis data acquisition and processing system of the embodiment of the invention can further comprise a withdrawing module, and when the input personnel reports an error, the cost analysis data acquisition and processing system can support the input personnel to withdraw the imported form through the withdrawing module.
In the embodiment of the invention, the architecture for implementing the embodiment of the invention can adopt an integrated framework technology and Web application integrated development service middleware, can be suitable for modular development and integrated application of medium and large-scale systems, and has good expansibility and adaptability in the aspect of integrated development. Various standard components based on Java EE standards are built in the platform, the component service is issued according to OSGi4.0 standard, updating is easy, and development and integration are convenient. The JNDI data source management system can support dynamic skin switching, multi-project integration capability, a sound authority management mechanism, a dynamic deployment updating function module, automatic menu generation and multiple sessions.
In the embodiment of the invention, a framework for implementing the embodiment of the invention adopts a Java EE framework, in order to meet the service application requirements of the project, the framework based on J2EE is preferentially used for development during technology type selection, meanwhile, a system is required to be developed by using the Java technology of the same SDK version, the consistency and better compatibility of an application program are ensured, a high-performance Web site is erected, the research and development efficiency is improved, the software quality is ensured, an economic evaluation working platform is planned to be researched and developed by adopting a Java EE platform after the asset investment project is fixed, and a WebLogic server is introduced for deployment. Meanwhile, the Java EE platform and the WebLogic server can be easily switched to Linux and Unix systems to operate, and the method is also suitable for realizing SOA architecture and erecting various SOA basic services.
In the embodiment of the invention, the architecture for implementing the embodiment of the invention adopts an architecture design based on SOA service, adopts an advanced Service Oriented (SOA) software design concept, drives services by business, and drives the technology by the service to enable each function to better serve the business. A standard-based unified platform is built, cross-platform integration is realized on a standard level, and an integration mechanism for other existing systems is provided.
In the embodiment of the invention, the B/S architecture is adopted for implementing the embodiment of the invention, the client side adopts a Web mode, the function of the system is accessed through the browser, and the client side is zero in installation, easy to use, attractive in interface and convenient for upgrading and maintaining the system. And the consistency of the platform and the protocol is ensured, and the componentization design of the system can be conveniently realized by adopting a B/S framework.
The embodiment of the invention improves the reporting and collecting modes of the cost analysis data, and provides a standard form and a specified third-party software or EXCEL form for a data collecting scheme, thereby improving the normative and reliability of the collected data and solving the problem of sample data collection; according to the power grid project cost analysis and the requirements of national grid companies on the main grid project cost analysis, the collection of the total basic data of the cost analysis is realized; the construction cost data format is standardized, the construction cost data collection mode is optimized, the data quality is improved while the sample data collection workload is reduced, and the timeliness, integrity and accuracy of data collection are improved; by establishing a cost analysis base database for power grid engineering, a reliable data source is provided for daily skill work and cost analysis work, and professional technology support capability and technology management level are improved.
The embodiment of the invention provides a functional module for automatically checking the logical calculation of index data and verifying the correctness of a data format. When the data has deviation and the filling value has logic error, the service auxiliary judgment is provided through the corresponding prompt information to prompt the user about the found problem. After the cost analysis indexes in each subsystem are filled, the system automatically summarizes the total engineering number and the cost analysis indexes of the power grid engineering according to the engineering types (power transformation, lines and the like), the construction management units, the voltage grades and the like.
The system provided by the embodiment of the invention can completely match the cost analysis specification of national network companies and output diversified results to support investment decisions. The system can support direct output of cost analysis and custom cost analysis reports of national grid companies. The projects of the reference analysis can be selected step by step and combined or rejected according to a variety of screening conditions. According to the customized report format and the screened project set, the system reads indexes corresponding to the projects to form a national power grid cost analysis result report, and diversified cost analysis result export is realized. Meanwhile, by flexible configuration of cost analysis basic data and realization of diversified application, engineering cost control and application depth are optimized, and reliable application support is provided for investment decision of project construction work.
The modules or units in the embodiments of the present invention may be implemented by a general-purpose integrated circuit, such as a CPU (central processing Unit), or an ASIC (Application Specific integrated circuit).
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The steps in the method of the embodiment of the invention can be sequentially adjusted, combined and deleted according to actual needs.
The modules or units in the device of the embodiment of the invention can be combined, divided and deleted according to actual needs.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention.
Claims (4)
1. A cost analysis data collection and processing system, comprising:
the form acquisition module is used for acquiring a form containing the cost analysis index basic data, wherein the form containing the cost analysis index basic data comprises any one or two of a form to be input uploaded by input personnel and a third-party form generated by third-party software;
the form checking module is used for checking the collected form to be input and the third-party form;
the form uploading module is used for uploading the successfully verified form to be input or the third-party form to the system and storing the successfully verified form to be input or the third-party form in a memory of the system;
the data checking module is used for checking the cost analysis index basic data in each cell in the form to be input or the third-party form;
the data summarization module is used for summarizing the cost analysis index basic data which are successfully verified into various cost analysis indexes according to data types and inputting the cost analysis basic data into a cost analysis basic database, wherein the data types comprise at least one of engineering basic information, technical and economic parameters, approximate calculation cost indexes and settlement cost indexes;
the data output module is used for extracting cost analysis indexes corresponding to the types required by the report forms from the cost analysis basic database; the system is also used for generating a cost analysis index report by adopting a required format report template based on the cost analysis index corresponding to the required category of the report, wherein the required category comprises one or more of power transmission and transformation project category, implementation unit, main transformer parameter, outgoing line return parameter at the present stage, power distribution form, circuit breaker number parameter, wiring form, reactor parameter and technical material parameter;
the business module is used for calculating cost analysis technical indexes according to the cost analysis index basic data in the cost analysis basic database; and the system is also used for inquiring the cost analysis technical index according to the required inquiry and screening conditions.
2. The system of claim 1, wherein the form collection module comprises:
a specification form providing unit, configured to provide a download file of the specification form, so that the entering personnel can manually enter the cost analysis index basic data, where the specification form is an EXCEL form data form, and the form in which the cost analysis index basic data is entered is the form to be entered;
the data receiving unit is used for receiving the imported form to be input;
or, the data receiving unit is further configured to receive the third-party table that includes the cost analysis index basic data and is generated by the third-party software.
3. The system of claim 2, wherein the table check module comprises:
the basic information checking unit is used for checking the file format, the file data volume, the number and the name of the contained worksheets and the contained header information of the form to be entered, if the file format of the form to be entered is correct, the file data volume of the form to be entered meets the standard data volume, the number of the worksheets contained in the form to be entered is consistent with the standard number, and the header information contained in the form to be entered meets the header information requirement, the basic information checking unit is successful in checking, and if not, the basic information checking unit is failed in checking;
the content checking unit is used for checking whether one of a piece of data which only has a project name and lacks the cost analysis index basic data corresponding to the project name, a piece of data which comprises two or more pieces of data with the same project name and a piece of data which does not fill in a necessary filling cell exists in the form to be input, if one of the piece of data which only has the project name and lacks the cost analysis index basic data corresponding to the project name, the piece of data which comprises the two or more pieces of data with the same project name and the piece of data which does not fill in the necessary filling cell exists in the form to be input, the content checking unit fails to check, and if not, the content checking unit succeeds in checking;
alternatively, the first and second electrodes may be,
the basic information checking unit is further configured to check a file format, a file data amount, the number and name of included worksheets, and included header information of the third-party form, and if the file format of the third-party form is correct, the file data amount of the third-party form meets a standard data amount, the number of the worksheets included in the third-party form is consistent with the standard number, and the header information included in the third-party form meets a header information requirement, the basic information checking unit is checked successfully, otherwise, the basic information checking unit is checked unsuccessfully;
the content checking unit is further configured to check whether one of a piece of data including only a project name and lacking the cost analysis index basic data corresponding to the project name, a piece of data including two or more pieces of data having the same project name, and a piece of data not filled in a necessary filling cell exists in the third-party table, and if one of the piece of data including only a project name and lacking the cost analysis index basic data corresponding to the project name, the piece of data including the two or more pieces of data having the same project name, and the piece of data not filled in the necessary filling cell exists in the third-party table, the content checking unit fails to check, otherwise, the content checking unit succeeds in checking;
and the verification failure prompt module is used for generating a verification failure prompt message when the basic information verification unit or the content verification unit fails in verification.
4. The system of claim 3, wherein the data verification module comprises:
the data checking unit is used for checking the cost analysis index basic data in each cell in the table to be input, and highlighting the cells containing data which do not meet the data type, the cells containing data which do not meet the data range and the cells containing data which do not meet the content length so as to prompt the abnormal data of the cells;
the calculation and verification unit is used for verifying the calculation result of each cell according to the calculation relational expression set in each cell in the table to be input, and highlighting the cell with the wrong calculation result to prompt that the cell result is abnormal;
alternatively, the first and second electrodes may be,
the data checking unit is used for checking the cost analysis index basic data in each cell in the third-party table, and highlighting the cells containing data which do not meet the data type, the cells containing data which do not meet the data range and the cells containing data which do not meet the content length so as to prompt the abnormal data of the cells;
and the calculation and verification unit is used for verifying the calculation result of each cell according to the calculation relational expression set in each cell in the third party table and highlighting the cell with the wrong calculation result to prompt that the cell result is abnormal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510769064.2A CN105225076B (en) | 2015-11-12 | 2015-11-12 | Cost analysis data acquisition and processing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510769064.2A CN105225076B (en) | 2015-11-12 | 2015-11-12 | Cost analysis data acquisition and processing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105225076A CN105225076A (en) | 2016-01-06 |
| CN105225076B true CN105225076B (en) | 2020-10-23 |
Family
ID=54994031
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510769064.2A Active CN105225076B (en) | 2015-11-12 | 2015-11-12 | Cost analysis data acquisition and processing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105225076B (en) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105989546A (en) * | 2016-04-13 | 2016-10-05 | 国网吉林省电力有限公司经济技术研究院 | Power transmission and transformation construction cost basic data collection and analysis system |
| CN106294294B (en) * | 2016-08-03 | 2019-03-26 | 上海电气泰雷兹交通自动化***有限公司 | Rail traffic signal system unifies the consistency desired result method of formatted data file |
| CN108228635A (en) * | 2016-12-19 | 2018-06-29 | 北京奇虎科技有限公司 | Introduction method, device and the financial system of financial data |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN107844962B (en) * | 2017-11-24 | 2020-08-04 | 广东电网有限责任公司电网规划研究中心 | Distribution network engineering cost data collection system based on standard data structure |
| CN109325665A (en) * | 2018-08-30 | 2019-02-12 | 广东源恒软件科技有限公司 | A kind of project cost appraisal procedure and system |
| CN109255590A (en) * | 2018-09-08 | 2019-01-22 | 中建精诚工程咨询有限公司 | A kind of construction project cost auditing system |
| CN109359283B (en) * | 2018-09-26 | 2023-07-25 | 中国平安人寿保险股份有限公司 | Summarizing method of form data, terminal equipment and medium |
| CN109857799A (en) * | 2019-01-29 | 2019-06-07 | 国网物资有限公司 | The automatic auditing system of tender price and method |
| CN110457532B (en) * | 2019-07-24 | 2022-12-23 | 深圳市华阳国际工程造价咨询有限公司 | Construction cost consultation database establishing method and system |
| CN110991982A (en) * | 2019-10-28 | 2020-04-10 | 中船重工海鑫工程管理(北京)有限公司 | Construction project building information management method and system |
| CN112734385B (en) * | 2021-01-13 | 2021-12-07 | 广东普信项目管理有限公司 | Engineering cost analysis data acquisition and processing method and system |
| CN117973343B (en) * | 2024-04-01 | 2024-06-07 | 中国铁路设计集团有限公司 | Intelligent processing method and system for urban rail engineering investment estimation indexes |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2631803A1 (en) * | 2005-12-02 | 2007-06-07 | Thomson Licensing | Work flow metadata system and method |
| CN202919443U (en) * | 2012-12-09 | 2013-05-08 | 付宗平 | Workbench special for construction engineering cost budget |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
-
2015
- 2015-11-12 CN CN201510769064.2A patent/CN105225076B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2631803A1 (en) * | 2005-12-02 | 2007-06-07 | Thomson Licensing | Work flow metadata system and method |
| CN202919443U (en) * | 2012-12-09 | 2013-05-08 | 付宗平 | Workbench special for construction engineering cost budget |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105225076A (en) | 2016-01-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105225076B (en) | Cost analysis data acquisition and processing system | |
| CN107357856B (en) | Method for realizing data integration and data service based on power grid panoramic service model | |
| CN104077665B (en) | Electricity power engineering analysis of prices data gathering system and method | |
| CN101867501B (en) | Method and system for automatically testing consistence of SNMP (Simple Network Management Protocol) interface information model | |
| CN105184189A (en) | Online control and management system for intelligent substation SCD file | |
| CN109034616A (en) | A kind of statistical analysis system based on intelligent substation configuration data control | |
| CN105488293B (en) | A kind of method and system configuring virtual terminator line in SCD | |
| CN109816349A (en) | A kind of test verification management platform | |
| CN103679557B (en) | Power system operating mode data management system based on C/S framework and its implementation | |
| CN113760730A (en) | Automatic testing method and device | |
| CN103777092A (en) | Cloud technology based relay protection test system and method | |
| CN113778903B (en) | Method and system for generating test case of power distribution terminal and storage medium | |
| CN115017484A (en) | Access control method and device | |
| CN105868287B (en) | Multi-source data-based WAMS application system data integration method | |
| CN113095059B (en) | Method, device, equipment and storage medium for verifying substation configuration description file | |
| CN107146166B (en) | Distribution network planning auxiliary system | |
| CN111553782A (en) | Enterprise credit evaluation method and system based on hybrid cloud and block chain | |
| CN113705143A (en) | Automatic simulation system and automatic simulation method | |
| CN103413190A (en) | Real-time auditing system of operation ticket and method | |
| CN112348454B (en) | Intelligent management and control system and method for handover test of electrical equipment | |
| CN104199663A (en) | Comprehensive automated information table automatic generating method and system | |
| CN114123482A (en) | Main plant station information joint debugging decoupling method | |
| CN113887754A (en) | Construction method and system of power distribution terminal unified operation and maintenance platform and constructed platform | |
| CN113919427A (en) | Electric power equipment archive data management method and system | |
| CN109741594B (en) | Configuration method and device for equipment data acquisition |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |