CN104077665A - Power grid project manufacturing cost analysis data collecting system and method - Google Patents
Power grid project manufacturing cost analysis data collecting system and method Download PDFInfo
- Publication number
- CN104077665A CN104077665A CN201410327839.6A CN201410327839A CN104077665A CN 104077665 A CN104077665 A CN 104077665A CN 201410327839 A CN201410327839 A CN 201410327839A CN 104077665 A CN104077665 A CN 104077665A
- Authority
- CN
- China
- Prior art keywords
- engineering
- data
- excel
- editions
- file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a power grid project manufacturing cost analysis data collecting system and method. The system comprises a user basic data maintenance module, a micro-blog file conversion engine and an Excel file import and export engine, wherein the user basic data maintenance module is used for managing a user, a department, a character and a resource, a user management module receives call of a service data processing module, the micro-blog file conversion engine is used for analyzing and processing micro-blog files, and converting the micro-blog files into files of the Data set format or the Xml format, the micro-blog files comprise 2008-edition manufacturing cost projects and 2012-edition settlement projects, the micro-blog file conversion engine receives call of the service data processing module, the Excel file import and export engine carries out import analyzing and export analyzing on an Excel of the xls format and an Excel of the xlsx format according to the configured files, a plurality of layers of column headers of the Excels can be identified through import analyzing, the needed Excel format can be generated automatically through export analyzing, and the Excel file import and export engine receives call of the service data processing module. According to the system and the method, the index data are firm in the follow-up upgrading and adjusting process.
Description
Technical field
The present invention relates to a kind of electricity power engineering analysis of prices data gathering system and method.
Background technology
Shandong District analysis of prices work in 2012 relates to 355 of the projects of transmitting and converting electricity of operation altogether, and wherein city net has 245,110 of rural power grids, totally 903 of all types of sample engineering collections, nearly 100,000 data contents.
At present, it is mainly to rely on manually collect and gather calculating that constituent parts carries out analysis of prices basic data collection work, in to analysis of prices basic data collection process, need to a large amount of data collect, the processing such as statistics, computational analysis.
These information data amounts are huge, data structure is complicated, collection arranges and amount of calculation is large, the in the situation that, task short in the time being tight, data statistics work has occupied company's skill through most working time of personnel and energy, hand computation simultaneously easily causes analysis of prices result inaccurate, affect analysis of prices data accuracy, affect fairness and the science of cost horizontal analysis.
Index is that staff needs one of data to be processed, and index is constantly to change, and has brought a lot of inconvenience to the maintenance of data.
Summary of the invention
Object of the present invention is exactly in order to address the above problem, and a kind of electricity power engineering analysis of prices data gathering system and method are provided, and it has advantages of that achievement data table is very firm in follow-up upgrading and adjustment process.
To achieve these goals, the present invention adopts following technical scheme:
Electricity power engineering analysis of prices data gathering system, comprising:
User base data maintenance module, for user, department, role and resource are managed, described user management module receives calling of business data processing module;
Rich micro-file transform engine, for rich micro-file is carried out to dissection process, converts rich micro-file to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine, for the parsing that imports for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server, for realizing data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module, for realizing all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index is made a report on module, for typing indication information, imports index template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing index template and report form template.
Described engineering management module, comprising:
Create separately engineering module, support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering module in batches, user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on module, comprising:
Make a report on by hand module, support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel module, supports that user imports engineering objective data in batches, and import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file module, support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check module, at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting user to be configured screening to the project data source of form, supports to add engineering and deletes engineering;
Custom table head module, for supporting user to customize the report heading having created, and can save as report form template;
Derive Reports module, for supporting user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described Configuration Manager, comprising:
Index template management module, supports that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module administration module, supports user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Electricity power engineering analysis of prices method of data capture, comprises the steps:
User base data maintenance: user, department, role and resource are managed, and described user management module receives calling of business data processing module;
Rich micro-file transform engine: rich micro-file is carried out to dissection process, rich micro-file is converted to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing importing for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server: realize data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module: realize all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing, comprises the steps:
Engineering management: create engineering, and the essential information of typing engineering;
Index is made a report on: typing indication information, imports index template and report form template;
Report generation: output user form;
Configuration management: index template and report form template are managed.
Described engineering management, comprises the steps:
Create separately engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering in batches: user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel: support that user imports engineering objective data in batches, import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file: support user to import the rich micro-file of target engineering, support the project file of the rich mirosoftware product of the rich micro-project of transmitting and converting electricity clearing application software of < 2008 editions > > of < Cost for Electric Power Engineering and < < 2012 editions > >, two cover and the Excel file that above two software is derived;
Data check: at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that user is configured screening to the project data source of form, support to add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading having created, and can save as report form template;
Derive form: support user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file.
Described configuration management, comprises the steps:
Index Template Manager: support that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module management: support user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Beneficial effect of the present invention:
1) basic database, especially index tables of data, very firm in follow-up upgrading and adjustment process.
2) by configuring flexibly and effectively, essential information and the checking information of all almost constant indexs are saved as to template file, deal with the index variation that the later stage exists.
3) by craft make a report on, Excel imports and exports and upload the modes such as rich micro-file, optimizes analysis of prices index collection mode, alleviates analysis of prices index collection work amount, improves the accuracy that analysis of prices index is collected.
4) by means such as engineering management and controls of authority, analysis of prices index collection work is shared to routine work, alleviate the workload that each electric company and relevant unit's Cost Index are collected.
5) by automatic Check on the page and verification achievement data, improve the accuracy that achievement data is collected, for analysis of prices work provide really, effectively, sample data accurately.
6) stability: native system is not having under the prerequisite of new demand, can, hardly with revising code, by the mode of adjustment index template and report form template, tackle the variation of achievement data.
7) configurability: the configuration of native system almost all adopts the mode of Excel, and which is simple and clear, and little adjustment user can oneself configure completely, alleviated the extensive work of later maintenance.Other business configuration file is all used the mode of registration table to be incorporated in the middle of system, directly covers original file, and can not restart service if the later stage need to modify in many application server cluster.
8) integrality: native system from the craft of data make a report on, the importing of data is, the aspects such as check of the derivation of data, data, guarantee that data are from collecting importings, to the integrality and the reliability that generate, and user operated to the powerful verifying function of support.
Accompanying drawing explanation
9) system adopts the mode of index template, deals with the achievement data of annual variation, by this unique identification of standard index name, realizes the unified management of index.
Accompanying drawing explanation
Fig. 1 is system architecture schematic diagram of the present invention;
Fig. 2 is that index template and report form template are related to schematic diagram;
Fig. 3 is index template schematic diagram;
Fig. 4 is that achievement data table generates process flow diagram.
Embodiment
Below in conjunction with accompanying drawing and embodiment, the invention will be further described.
As shown in Figure 1, 2, 3, electricity power engineering analysis of prices data gathering system, comprising:
User base data maintenance module, for user, department, role and resource are managed, described user management module receives calling of business data processing module;
Rich micro-file transform engine, for rich micro-file is carried out to dissection process, converts rich micro-file to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine, for the parsing that imports for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server, for realizing data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module, for realizing all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index is made a report on module, for typing indication information, imports index template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing index template and report form template.
Described engineering management module, comprising:
Create separately engineering module, support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering module in batches, user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on module, comprising:
Make a report on by hand module, support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel module, supports that user imports engineering objective data in batches, and import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file module, support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check module, at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting user to be configured screening to the project data source of form, supports to add engineering and deletes engineering;
Custom table head module, for supporting user to customize the report heading having created, and can save as report form template;
Derive Reports module, for supporting user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described Configuration Manager, comprising:
Index template management module, supports that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module administration module, supports user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Electricity power engineering analysis of prices method of data capture, comprises the steps:
User base data maintenance: user, department, role and resource are managed, and described user management module receives calling of business data processing module;
Rich micro-file transform engine: rich micro-file is carried out to dissection process, rich micro-file is converted to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing importing for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server: realize data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module: realize all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing, comprises the steps:
Engineering management: create engineering, and the essential information of typing engineering;
Index is made a report on: typing indication information, imports index template and report form template;
Report generation: output user form;
Configuration management: index template and report form template are managed.
Described engineering management, comprises the steps:
Create separately engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering in batches: user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel: support that user imports engineering objective data in batches, import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file: support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check: at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that user is configured screening to the project data source of form, support to add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading having created, and can save as report form template;
Derive form: support user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file.
Described configuration management, comprises the steps:
Index Template Manager: support that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module management: support user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 cost Excel forms, clearing 2012 costing engineering files or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Described rich micro-file refers to and uses the 2008 editions > > of power industry product < < Cost for Electric Power Engineering of Jiangxi Bowei New Technology Co., Ltd. or the clearing of < < project of transmitting and converting electricity to apply the budgetary estimate of 2012 editions > > software programming electricity power engineerings, settlement data file.
2008 editions engineerings of described cost have referred to use the electricity power engineering budgetary estimate data file of 2008 editions > > software programmings of Jiangxi Bowei New Technology Co., Ltd.'s power industry product < < Cost for Electric Power Engineering.
2012 editions engineerings of described clearing have referred to use the project of transmitting and converting electricity final account for completed project report file of 2012 editions > > software programmings of the power industry product < < of Jiangxi Bowei New Technology Co., Ltd. project of transmitting and converting electricity clearing application.
As shown in Figure 4,
Step (1):
Excel document analysis goes out general DataTable: according to Excel, import and export engine and Excel file can be converted to the general DataTable that has index name;
2008 editions costing engineering files or 2012 editions clearing project files, by resolving, parse interim XML file; Interim XML file further generates general DataSet;
2008 editions cost Excel files or 2012 editions clearing Excel files, by configuration rule, read corresponding tables of data, then, by the read method of Excel, data are temporarily first read out, and parse interim DataSet file; Interim DataSet file, by configuration rule, converts interim DataSet to the discernible generation of system general DataSet;
Step (2):
General DataTable and index template write interim importing table: when importing to temporary table, have how many indexs, just import how many indexs, and classify when representing according to index template;
General DataSet and index template write interim importing table;
Step (3): the interim table that imports generates achievement data table.
Although above-mentioned, by reference to the accompanying drawings the specific embodiment of the present invention is described; but be not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that creative work can make or distortion still in protection scope of the present invention.
Claims (10)
1. electricity power engineering analysis of prices data gathering system, is characterized in that, comprising:
User base data maintenance module, for user, department, role and resource are managed, described user management module receives calling of business data processing module;
Rich micro-file transform engine, for rich micro-file is carried out to dissection process, converts rich micro-file to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine, for the parsing that imports for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server, for realizing data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module, for realizing all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively.
2. electricity power engineering analysis of prices data gathering system as claimed in claim 1, is characterized in that, described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index is made a report on module, for typing indication information, imports index template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing index template and report form template.
3. electricity power engineering analysis of prices data gathering system as claimed in claim 2, is characterized in that, described engineering management module, comprising:
Create separately engineering module, support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering module in batches, user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on module, comprising:
Make a report on by hand module, support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel module, supports that user imports engineering objective data in batches, and import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file module, support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check module, at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, the data of verification comprise type, length, calculated relationship.
4. electricity power engineering analysis of prices data gathering system as claimed in claim 2, is characterized in that, described report generation module, comprising:
Configuration data source module, for supporting user to be configured screening to the project data source of form, supports to add engineering and deletes engineering;
Custom table head module, for supporting user to customize the report heading having created, and saves as report form template;
Derive Reports module, for supporting user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described Configuration Manager, comprising:
Index template management module, supports that user checks existing index template in system by list mode, and index template is edited and enabled;
Reports module administration module, supports user to check the report form template under existing report form template classification and each classification in system by list mode.
5. electricity power engineering analysis of prices data gathering system as claimed in claim 4, it is characterized in that, described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system, according to index template, and in tables of data, preserves corresponding record after being listed as by customization;
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
6. the applied method of system as described in above-mentioned arbitrary claim, is characterized in that, comprises the steps:
User base data maintenance: user, department, role and resource are managed, and described user management module receives calling of business data processing module;
Rich micro-file transform engine: rich micro-file is carried out to dissection process, rich micro-file is converted to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing importing for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server: realize data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module: realize all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively.
7. method as claimed in claim 6, is characterized in that, described business data processing, comprises the steps:
Engineering management: create engineering, and the essential information of typing engineering;
Index is made a report on: typing indication information, imports index template and report form template;
Report generation: output user form;
Configuration management: index template and report form template are managed.
8. method as claimed in claim 7, is characterized in that, described engineering management, comprises the steps:
Create separately engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering in batches: user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel: support that user imports engineering objective data in batches, import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file: support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check: at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, and the data of verification comprise type, length, calculated relationship.
9. method as claimed in claim 7, is characterized in that,
Described report generation, comprises the steps:
Disposition data source: support that user is configured screening to the project data source of form, support to add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading having created, and save as report form template;
Derive form: support user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described configuration management, comprises the steps:
Index Template Manager: support that user checks existing index template in system by list mode, and index template is edited and enabled;
Reports module management: support user to check the report form template under existing report form template classification and each classification in system by list mode.
10. method as claimed in claim 7, it is characterized in that, described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system, according to index template, and in tables of data, preserves corresponding record after being listed as by customization;
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410327839.6A CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410327839.6A CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104077665A true CN104077665A (en) | 2014-10-01 |
| CN104077665B CN104077665B (en) | 2016-04-06 |
Family
ID=51598910
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410327839.6A Active CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104077665B (en) |
Cited By (32)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105373864A (en) * | 2015-12-09 | 2016-03-02 | 国网四川省电力公司遂宁供电公司 | Rural power grid design method |
| CN105446945A (en) * | 2015-12-01 | 2016-03-30 | 广东电网有限责任公司电网规划研究中心 | Word mark report generation method |
| CN105975473A (en) * | 2016-01-19 | 2016-09-28 | 北京匡恩网络科技有限责任公司 | Customized trend analysis subsystem |
| CN106648763A (en) * | 2016-12-06 | 2017-05-10 | 明博教育科技股份有限公司 | Batch data importing component and importing method thereof |
| CN106709671A (en) * | 2017-02-16 | 2017-05-24 | 广东华联软件科技有限公司 | Construction cost index dynamization establishment method and dynamic index system |
| CN106845930A (en) * | 2016-12-30 | 2017-06-13 | 宁波贤晟信息技术有限公司 | One kind declaration data handling system |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN106940839A (en) * | 2017-03-13 | 2017-07-11 | 中国南方电网有限责任公司超高压输电公司 | A kind of project of transmitting and converting electricity qualitative data managing and control system and method |
| CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
| CN107240011A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of index allocation processing method and system |
| CN107436928A (en) * | 2017-07-12 | 2017-12-05 | 国网山东省电力公司经济技术研究院 | The through-flow method of amount valency of substation project |
| WO2017211076A1 (en) * | 2016-06-07 | 2017-12-14 | 福建福昕软件开发股份有限公司 | Automatic filling method for associated documents |
| CN107527185A (en) * | 2017-08-04 | 2017-12-29 | 昆明理工大学 | A kind of project cost documentation and the parallel practice method examined |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN107944731A (en) * | 2017-12-04 | 2018-04-20 | 国网河北省电力公司经济技术研究院 | The method for building up and device of typical project cost template |
| CN108121691A (en) * | 2017-11-23 | 2018-06-05 | 国家电网公司 | Manage the method and system of project of transmitting and converting electricity bill of quantities |
| CN108694512A (en) * | 2018-05-30 | 2018-10-23 | 国网山东省电力公司经济技术研究院 | A kind of power grid analysis of prices data in-depth processing system and method |
| CN109086403A (en) * | 2018-08-01 | 2018-12-25 | 徐工集团工程机械有限公司 | A kind of three-dimensional electronic random file dynamic creation method of Classification Oriented user |
| CN109086970A (en) * | 2018-07-06 | 2018-12-25 | 武汉瑞莱保能源技术有限公司 | A kind of field operation regulation electronization solution |
| CN109241501A (en) * | 2018-08-15 | 2019-01-18 | 北京北信源信息安全技术有限公司 | Document analysis method and apparatus |
| CN109472481A (en) * | 2018-10-31 | 2019-03-15 | 广东电网有限责任公司 | A kind of mesolow distribution engineering overall process stream compression method and device |
| CN109634964A (en) * | 2018-12-13 | 2019-04-16 | 深圳市航建工程造价咨询有限公司 | Cost Index exponent data base management system |
| CN109784689A (en) * | 2018-12-28 | 2019-05-21 | 远光软件股份有限公司 | A kind of power grid infrastructure project method for processing report data |
| CN109857799A (en) * | 2019-01-29 | 2019-06-07 | 国网物资有限公司 | The automatic auditing system of tender price and method |
| CN111159993A (en) * | 2019-12-25 | 2020-05-15 | 江苏方天电力技术有限公司 | Automatic analysis and report generation system platform for power transformation mobile operation card |
| CN111221454A (en) * | 2020-04-21 | 2020-06-02 | 广东电网有限责任公司东莞供电局 | Power grid service data processing method, device, equipment and storage medium |
| CN111242505A (en) * | 2020-01-23 | 2020-06-05 | 厦门海迈科技股份有限公司 | Configurable grouped comparison engineering cost index analysis method and system |
| CN111401014A (en) * | 2020-03-12 | 2020-07-10 | 山东浪潮通软信息科技有限公司 | Multi-index multi-dimensional analysis method, system and construction method based on report |
| CN111898356A (en) * | 2020-07-20 | 2020-11-06 | 昆明海巍科技有限公司 | Engineering cost analysis method and system for reducing repeated workload |
| CN113610595A (en) * | 2021-07-26 | 2021-11-05 | 航天信息***工程(北京)有限公司 | Method and system for informatization management of price reporting and reviewing |
| CN117973343A (en) * | 2024-04-01 | 2024-05-03 | 中国铁路设计集团有限公司 | Intelligent processing method and system for urban rail engineering investment estimation indexes |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN103699966A (en) * | 2013-04-12 | 2014-04-02 | 国家电网公司 | Multidimensional overall-process data control system and control method based on user requirement |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
-
2014
- 2014-07-10 CN CN201410327839.6A patent/CN104077665B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103699966A (en) * | 2013-04-12 | 2014-04-02 | 国家电网公司 | Multidimensional overall-process data control system and control method based on user requirement |
Non-Patent Citations (1)
| Title |
|---|
| 张琦等: "《电建行业工程量清单报价软件的应用》", 《电网技术》, vol. 31, 30 June 2007 (2007-06-30), pages 176 - 178 * |
Cited By (46)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105225076B (en) * | 2015-11-12 | 2020-10-23 | 国网宁夏电力公司经济技术研究院 | Cost analysis data acquisition and processing system |
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105446945A (en) * | 2015-12-01 | 2016-03-30 | 广东电网有限责任公司电网规划研究中心 | Word mark report generation method |
| CN105446945B (en) * | 2015-12-01 | 2017-12-01 | 广东电网有限责任公司电网规划研究中心 | Word marks report-generating method |
| CN105373864A (en) * | 2015-12-09 | 2016-03-02 | 国网四川省电力公司遂宁供电公司 | Rural power grid design method |
| CN105975473A (en) * | 2016-01-19 | 2016-09-28 | 北京匡恩网络科技有限责任公司 | Customized trend analysis subsystem |
| WO2017211076A1 (en) * | 2016-06-07 | 2017-12-14 | 福建福昕软件开发股份有限公司 | Automatic filling method for associated documents |
| CN106648763A (en) * | 2016-12-06 | 2017-05-10 | 明博教育科技股份有限公司 | Batch data importing component and importing method thereof |
| CN106845930A (en) * | 2016-12-30 | 2017-06-13 | 宁波贤晟信息技术有限公司 | One kind declaration data handling system |
| CN106845930B (en) * | 2016-12-30 | 2020-04-24 | 宁波贤晟信息技术有限公司 | Customs declaration data processing system |
| CN106709671A (en) * | 2017-02-16 | 2017-05-24 | 广东华联软件科技有限公司 | Construction cost index dynamization establishment method and dynamic index system |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN106940839A (en) * | 2017-03-13 | 2017-07-11 | 中国南方电网有限责任公司超高压输电公司 | A kind of project of transmitting and converting electricity qualitative data managing and control system and method |
| CN106940839B (en) * | 2017-03-13 | 2020-11-24 | 中国南方电网有限责任公司超高压输电公司 | Power transmission and transformation project quality data management and control system and method |
| CN107240011A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of index allocation processing method and system |
| CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
| CN107436928A (en) * | 2017-07-12 | 2017-12-05 | 国网山东省电力公司经济技术研究院 | The through-flow method of amount valency of substation project |
| CN107436928B (en) * | 2017-07-12 | 2021-05-18 | 国网山东省电力公司经济技术研究院 | Measuring price through-flow method of transformer substation engineering |
| CN107527185B (en) * | 2017-08-04 | 2020-11-20 | 昆明理工大学 | Parallel implementation method for compiling and examining construction project cost file |
| CN107527185A (en) * | 2017-08-04 | 2017-12-29 | 昆明理工大学 | A kind of project cost documentation and the parallel practice method examined |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN108121691A (en) * | 2017-11-23 | 2018-06-05 | 国家电网公司 | Manage the method and system of project of transmitting and converting electricity bill of quantities |
| CN107944731A (en) * | 2017-12-04 | 2018-04-20 | 国网河北省电力公司经济技术研究院 | The method for building up and device of typical project cost template |
| CN108694512A (en) * | 2018-05-30 | 2018-10-23 | 国网山东省电力公司经济技术研究院 | A kind of power grid analysis of prices data in-depth processing system and method |
| CN109086970A (en) * | 2018-07-06 | 2018-12-25 | 武汉瑞莱保能源技术有限公司 | A kind of field operation regulation electronization solution |
| CN109086403B (en) * | 2018-08-01 | 2022-03-15 | 徐工集团工程机械有限公司 | Classified user-oriented dynamic creating method for three-dimensional electronic random file |
| CN109086403A (en) * | 2018-08-01 | 2018-12-25 | 徐工集团工程机械有限公司 | A kind of three-dimensional electronic random file dynamic creation method of Classification Oriented user |
| CN109241501A (en) * | 2018-08-15 | 2019-01-18 | 北京北信源信息安全技术有限公司 | Document analysis method and apparatus |
| CN109472481A (en) * | 2018-10-31 | 2019-03-15 | 广东电网有限责任公司 | A kind of mesolow distribution engineering overall process stream compression method and device |
| CN109634964B (en) * | 2018-12-13 | 2022-06-14 | 深圳市航建工程造价咨询有限公司 | Cost index database management system |
| CN109634964A (en) * | 2018-12-13 | 2019-04-16 | 深圳市航建工程造价咨询有限公司 | Cost Index exponent data base management system |
| CN109784689A (en) * | 2018-12-28 | 2019-05-21 | 远光软件股份有限公司 | A kind of power grid infrastructure project method for processing report data |
| CN109784689B (en) * | 2018-12-28 | 2022-03-15 | 远光软件股份有限公司 | Power grid infrastructure project report data processing method |
| CN109857799A (en) * | 2019-01-29 | 2019-06-07 | 国网物资有限公司 | The automatic auditing system of tender price and method |
| CN111159993A (en) * | 2019-12-25 | 2020-05-15 | 江苏方天电力技术有限公司 | Automatic analysis and report generation system platform for power transformation mobile operation card |
| CN111159993B (en) * | 2019-12-25 | 2023-09-01 | 江苏方天电力技术有限公司 | Automatic analysis and report generation system platform for power transformation mobile operation card |
| CN111242505A (en) * | 2020-01-23 | 2020-06-05 | 厦门海迈科技股份有限公司 | Configurable grouped comparison engineering cost index analysis method and system |
| CN111242505B (en) * | 2020-01-23 | 2023-07-25 | 厦门海迈科技股份有限公司 | Configurable and grouping comparison type engineering cost index analysis method and system |
| CN111401014A (en) * | 2020-03-12 | 2020-07-10 | 山东浪潮通软信息科技有限公司 | Multi-index multi-dimensional analysis method, system and construction method based on report |
| CN111221454A (en) * | 2020-04-21 | 2020-06-02 | 广东电网有限责任公司东莞供电局 | Power grid service data processing method, device, equipment and storage medium |
| CN111898356A (en) * | 2020-07-20 | 2020-11-06 | 昆明海巍科技有限公司 | Engineering cost analysis method and system for reducing repeated workload |
| CN111898356B (en) * | 2020-07-20 | 2021-07-16 | 昆明海巍科技有限公司 | Engineering cost analysis method and system for reducing repeated workload |
| CN113610595A (en) * | 2021-07-26 | 2021-11-05 | 航天信息***工程(北京)有限公司 | Method and system for informatization management of price reporting and reviewing |
| CN113610595B (en) * | 2021-07-26 | 2024-05-24 | 航天信息***工程(北京)有限公司 | Report and examination price informatization management method and system |
| CN117973343A (en) * | 2024-04-01 | 2024-05-03 | 中国铁路设计集团有限公司 | Intelligent processing method and system for urban rail engineering investment estimation indexes |
| CN117973343B (en) * | 2024-04-01 | 2024-06-07 | 中国铁路设计集团有限公司 | Intelligent processing method and system for urban rail engineering investment estimation indexes |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104077665B (en) | 2016-04-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104077665B (en) | Electricity power engineering analysis of prices data gathering system and method | |
| US9390391B2 (en) | System and method for benchmarking environmental data | |
| CN106325969B (en) | The reversely tracing system of demand change | |
| CN101719119A (en) | Report management system and method | |
| CN112364223B (en) | Digital archive system | |
| CN109816328A (en) | Power engineering Project Technical economic information system | |
| CN104615699A (en) | Family net pedigree system and data acquisition method thereof | |
| CN104461671A (en) | Method and system for periodically managing code modification report | |
| CN110728123B (en) | Report generation method, system and related equipment | |
| CN101446971A (en) | Method for building content management system and device thereof | |
| CN109408043A (en) | A kind of program creating method and device | |
| CN112016287A (en) | Data management method, platform, storage medium and electronic device | |
| CN103455896A (en) | Paperless assembling quality control method based on internet of things | |
| CN113569543A (en) | Implementation method of nuclear power engineering automatic report generation technology | |
| CN110660461B (en) | Cross-platform medical data information uploading system based on artificial intelligence | |
| CN116796950A (en) | Online review system and method for power distribution network project capable of being researched | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN111178026A (en) | Method for realizing operation analysis report of special line for collecting passenger | |
| CN105404613A (en) | XLS (Microsoft Excel) data export method and system based on SAP (System Applications and Products in Data Processing) platform | |
| CN109460318A (en) | It is a kind of can rollback archives acquisition data introduction method, computer installation and computer readable storage medium | |
| CN115587098A (en) | Method and system for intelligently identifying chart data | |
| CN114818642A (en) | Dynamic filling method for data report | |
| CN108596555A (en) | A kind of information directly reports management system | |
| CN114491016A (en) | Automatic document classification and automatic maintenance method | |
| CN102310950B (en) | Experiment intelligent interpretation system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Liu Hongzhi Inventor after: Jin Shudong Inventor after: Li Yan Inventor after: Wang Wei Inventor after: Wei Xuelin Inventor after: Liu Xiang Inventor after: Jia Shanjie Inventor after: Fan Hairong Inventor after: Li Hong Inventor after: Tu Qingbo Inventor after: Gao Huawei Inventor after: Li Yimei Inventor after: Li Jingwen Inventor after: Han Yanfeng Inventor after: Wang Xiaoyan Inventor before: Tu Qingbo Inventor before: Liu Xiang Inventor before: Fan Hairong Inventor before: Li Hong Inventor before: Gao Huawei Inventor before: Liu Hongzhi Inventor before: Han Yanfeng Inventor before: Jin Shudong Inventor before: Li Yan Inventor before: Wei Xuelin |
|
| COR | Change of bibliographic data | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |