CN109857799A - The automatic auditing system of tender price and method - Google Patents
The automatic auditing system of tender price and method Download PDFInfo
- Publication number
- CN109857799A CN109857799A CN201910083421.8A CN201910083421A CN109857799A CN 109857799 A CN109857799 A CN 109857799A CN 201910083421 A CN201910083421 A CN 201910083421A CN 109857799 A CN109857799 A CN 109857799A
- Authority
- CN
- China
- Prior art keywords
- price
- data
- module
- automatic
- basic data
- 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.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of automatic auditing system of tender price and methods, comprising: data creation module, parameter configuration module, automatic screening module and data export module；The data creation module, for the ready basic data of user to be directed into system；The parameter configuration module, the base rule for configuration rates abnormal examination；The automatic screening module obtains the selection result for carrying out lookup comparison to basic data according to the base rule of price abnormal examination；The data export module, is checked for exporting the selection result to user, is examined automatically tender price by system, tender price is examined to reach automatic, reduces artificial workload, is improved tender price and is examined efficiency, interference from human factor is reduced, improves price and examines the purpose of accuracy.
Description
Technical field
The present invention relates to bid Inspection Technique fields, and in particular to a kind of automatic auditing system of tender price and method.
Background technique
" to apply modern scientific and technical result in response supplies bidding work, carry forward vigorously management innovation, mechanism innovation, skill
Art innovation ", the requirement of " accelerating material informationization construction, in-depth computer-aided tool application ".It solves existing for assessment of bids process
Service difficultion promotes goods and materials quality of bidding evaluation, speed and human involvement factor, while providing data branch for goods and materials class Public Bidding
Support effectively evades supplies bidding risk of policy making and audit risk, supports Supplies Purchasing by Bidding more optimized with all strength.
During concentrating the assessment of bids, the examination of tender price is mainly carried out by expert by manual type, comprising: tender price
Whether meet whether requirement of invitation for bid, the tax rate meet, with the presence or absence of offering in vain, alter mark or situations such as enclose mark.
Concentrate during the assessment of bids that bidder is more, it is more to mark packet quantity, cause offer by tender data flood tide to be verified, expert by
One mode examined leads to problems such as more heavy workload, time length, human intervention factor, low efficiency, accuracy rate limited.
Summary of the invention
In order to solve the above technical problems, the invention proposes a kind of automatic auditing system of tender price and methods, to reach
It is automatic to examine tender price, artificial workload is reduced, tender price is improved and examines efficiency, reduce interference from human factor, improve
The purpose of price examination accuracy.
In order to achieve the above objectives, technical scheme is as follows: a kind of automatic auditing system of tender price, the system
It include: data creation module, parameter configuration module, automatic screening module and data export module；
The data creation module, for the ready basic data of user to be directed into system；
The parameter configuration module, the base rule for configuration rates abnormal examination；
The automatic screening module, for carrying out lookup pair to basic data according to the base rule of price abnormal examination
Than obtaining the selection result；
The data export module, is checked for exporting the selection result to user.
Further, the basic data includes: row quotation information table, opening of bid list and price limit requirement table.
Further, the basic data is stored in Excel table, described to import the ready basic data of user
It is that the data in Excel table are converted into system.
Further, the base rule of the price abnormal examination is carried out by bidding professor according to when batch practical requirement of invitation for bid
Setting.
Further, the base rule according to price abnormal examination carries out searching comparison being to data to basic data
Field be compared.
Further, described export the selection result is exported after the selection result is converted into Excel table.
Further, the system also includes shared data managers, and the shared data manager is for managing capable report
Valence information table, form storage of the field to index in the row quotation information table.
A kind of tender price automatic checking method, which comprises basic data is directed into system by user；Mark is special
Family is according to when batch base rule of practical requirement of invitation for bid setting price abnormal examination；System is advised according to the basis of price abnormal examination
Lookup comparison then is carried out to basic data, obtains the selection result；The selection result is exported checks and bidding professor review to user.
The present invention has the advantage that
(1) the present invention automatically examines tender price by system, reduces artificial workload, improves bid price
Lattice examine efficiency, reduce interference from human factor, improve price and examine accuracy.
(2) the present invention carries out conversion extraction to the data in Excel table by the Excel resolution component in office,
The efficiency for improving data processing, to improve the efficiency of auditing system.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described.
Fig. 1 is the automatic auditing system the functional block diagram of tender price disclosed by the embodiments of the present invention；
Fig. 2 is a kind of automatic auditing system logical architecture schematic diagram of tender price disclosed by the embodiments of the present invention；
Fig. 3 is the working principle diagram of quotation information data sharing disclosed by the embodiments of the present invention；
Fig. 4 is that chart disclosed by the embodiments of the present invention exports to Excel schematic diagram.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description.
The present invention provides a kind of automatic auditing system of tender price and methods, its working principle is that automatically right by system
Tender price is examined, is examined tender price to reach automatic, is reduced artificial workload, improves tender price and examine effect
Rate reduces interference from human factor, improves price and examine the purpose of accuracy.
Below with reference to embodiment and specific embodiment, the present invention is described in further detail.
As shown in Figure 1, a kind of automatic auditing system of tender price, the system comprises: data creation module, parameter configuration
Module, automatic screening module and data export module；
The data creation module, for the ready basic data of user to be directed into system；
The parameter configuration module, the base rule for configuration rates abnormal examination；
The automatic screening module, for carrying out lookup pair to basic data according to the base rule of price abnormal examination
Than obtaining the selection result；
The data export module, is checked for exporting the selection result to user.
Wherein, the basic data includes: row quotation information table, opening of bid list and price limit requirement table.
Wherein, the basic data is stored in Excel table, and described be directed into the ready basic data of user is
It is that the data in Excel table are converted in system.
Wherein, the base rule of the price abnormal examination is set by bidding professor according to when batch practical requirement of invitation for bid
It sets.
Wherein, the base rule according to price abnormal examination carries out searching comparison being the word to data to basic data
Section is compared.
Wherein, described export the selection result is exported after the selection result is converted into Excel table.
Wherein, derived data further include: tander sum horizontal analysis data, price point counting data, price abnormal examination
Data.
Wherein, the system also includes shared data managers, and the shared data manager is for managing row offer
Table is ceased, form storage of the field in the row quotation information table to index.
A kind of tender price automatic checking method, which comprises basic data is directed into system by user；Mark is special
Family is according to when batch base rule of practical requirement of invitation for bid setting price abnormal examination；System is advised according to the basis of price abnormal examination
Lookup comparison then is carried out to basic data, obtains the selection result；The selection result is exported checks and bidding professor review to user.
Wherein, the logical architecture of system is as shown in Figure 2:
Wherein, view shows: defining all appearances of software interface.Mainly it is made of RCP multipage editing machine and RCP control,
Multipage editing machine be integrated into main program by RCP extension point, wherein has defined interface to extend point, benefit in multipage editor
User's various individual demands in different software scene can be met with RCP Plugin Mechanism.
Wherein, service logic: realizing the benchmark service logic and the response of interface operation of software, and Business Logic utilizes
Independent business logic processing class realizes the separation of logical layer and boundary layer.
Wherein, data model: software kernels data model definitions and domain logic realize layer, and predominantly upper-level system uses slotting
Part form provides data query, cost data calculates, report data calculates, and statistical data analysis calculates etc., in addition to this also mentions
It operates for software data resource Uniform Access, and is called by OSGi service for plug-in unit upper-layer functionality.
It is as shown in Figure 3: for the working principle of row quotation information data sharing, row quotation information data sharing: row in software
Quotation information data volume can very (the Excel data file university of single batch may reach million) up to a hundred greatly.For such
A large amount of data either load, store or carry out logical operation, are all very big burden for Installed System Memory.
It is therefore, soft in order to reduce Installed System Memory expense there is many duplicate contents meanwhile it is understood that in these data
It determines to use data sharing to row quotation information in part.The principle of data sharing is similar to the Flyweight Pattern in design pattern.?
Under the mode, the original value of a field is no longer saved in row quotation information object, and only saves an index, all original values
All it is managed collectively in shared object.In shared object, identical content will not repeat addition management, thus can root
According to the consumption of the different size of memory headroom of how much saving of duplicate contents.And according to the understanding to actual conditions, row offer
Occur the probability of same word segment value or higher in breath, using data sharing, substantial portion of memory overhead can be saved.
It is as shown in Figure 4: to export to Excel schematic diagram for chart, tander sum horizontal analysis, price abnormal examination in system
The data such as analysis need support export Excel, and support the export of chart content.This exports the function of Excel to chart,
It is realized by the XML file read-write directly to Excel.Export Excel function is divided into 2 parts, passes through libxl.dll first
Data are exported in Excel form document, the operation then drawn a diagram again to existing Excel file.
Expert obtains bidder's quotation file at the scene, is loaded into system；It selects according to the actual situation on site,
Optimal price check method；The automatic screening of system: the data and built-in inspection logic imported according to user, to bidder's valence
Lattice are checked one by one, for the information of ungratified requirement of invitation for bid, are presented to bidding professor in systems；Bidding professor is secondary
It verifies: underproof project is gone out for system screening, advanced secondary audit by bidding professor, and assign evaluation meaning in software
See；Generate unqualified reason: for underproof project, tool automatically generates unqualified reason.
Above-described is only the preferred implementation of a kind of automatic auditing system of tender price disclosed in this invention and method
Mode, it is noted that for those of ordinary skill in the art, without departing from the concept of the premise of the invention, also
Several modifications and improvements can be made, these are all within the scope of protection of the present invention.
Claims (8)
1. a kind of automatic auditing system of tender price, which is characterized in that the system comprises: data creation module, parameter configuration
Module, automatic screening module and data export module；
The data creation module, for the ready basic data of user to be directed into system；
The parameter configuration module, the base rule for configuration rates abnormal examination；
The automatic screening module is obtained for carrying out lookup comparison to basic data according to the base rule of price abnormal examination
To the selection result；
The data export module, is checked for exporting the selection result to user.
2. the automatic auditing system of tender price according to claim 1, which is characterized in that the basic data includes: row
Quotation information table, opening of bid list and price limit require table.
3. the automatic auditing system of tender price according to claim 1, which is characterized in that the basic data is stored in
In Excel table, the described ready basic data of user is directed into system is turned to the data in Excel table
It changes.
4. the automatic auditing system of tender price according to claim 1, which is characterized in that the base of the price abnormal examination
Plinth rule is configured by bidding professor according to when batch practical requirement of invitation for bid.
5. the automatic auditing system of tender price according to claim 1, which is characterized in that described according to price abnormal examination
Base rule to basic data carry out search comparison be to be compared to the field of data.
6. the automatic auditing system of tender price according to claim 1, which is characterized in that described to be by the selection result export
It is exported after the selection result is converted into Excel table.
7. the automatic auditing system of tender price according to claim 2, which is characterized in that the system also includes shared numbers
According to manager, the shared data manager is for managing row quotation information table, and the field in the row quotation information table is with rope
The form storage drawn.
8. a kind of tender price automatic checking method, which is characterized in that the described method includes: basic data is directed by user is
In system；Expert is marked according to when batch base rule of practical requirement of invitation for bid setting price abnormal examination；System is examined extremely according to price
The base rule looked into carries out lookup comparison to basic data, obtains the selection result；The selection result is exported checks and the assessment of bids to user
Expert's review.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910083421.8A CN109857799A (en) | 2019-01-29 | 2019-01-29 | The automatic auditing system of tender price and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910083421.8A CN109857799A (en) | 2019-01-29 | 2019-01-29 | The automatic auditing system of tender price and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109857799A true CN109857799A (en) | 2019-06-07 |
Family
ID=66896697
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910083421.8A Pending CN109857799A (en) | 2019-01-29 | 2019-01-29 | The automatic auditing system of tender price and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109857799A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110390564A (en) * | 2019-07-18 | 2019-10-29 | 广联达科技股份有限公司 | Build project quick self-checking method, system and computer readable storage medium in pricing |
| CN112464032A (en) * | 2019-12-24 | 2021-03-09 | 上海汇招信息技术有限公司 | Bidding clearing method |
| CN112988662A (en) * | 2021-02-19 | 2021-06-18 | 惠州市建设集团工程建设监理有限公司 | BIM-based project supervision information processing method, system, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060253289A1 (en) * | 2003-02-28 | 2006-11-09 | Chandran Kymal | Quality information management system |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
| CN104217276A (en) * | 2013-06-05 | 2014-12-17 | 上海宝信软件股份有限公司 | Rule-based automatic auditing method and system |
| CN104240037A (en) * | 2014-09-27 | 2014-12-24 | 武钢集团昆明钢铁股份有限公司 | Remote bid evaluation system and method |
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105719070A (en) * | 2016-01-18 | 2016-06-29 | 四川建设网有限责任公司 | Electronic auxiliary reviewing method and system |
-
2019
- 2019-01-29 CN CN201910083421.8A patent/CN109857799A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060253289A1 (en) * | 2003-02-28 | 2006-11-09 | Chandran Kymal | Quality information management system |
| CN104217276A (en) * | 2013-06-05 | 2014-12-17 | 上海宝信软件股份有限公司 | Rule-based automatic auditing method and system |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
| CN104240037A (en) * | 2014-09-27 | 2014-12-24 | 武钢集团昆明钢铁股份有限公司 | Remote bid evaluation system and method |
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105719070A (en) * | 2016-01-18 | 2016-06-29 | 四川建设网有限责任公司 | Electronic auxiliary reviewing method and system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110390564A (en) * | 2019-07-18 | 2019-10-29 | 广联达科技股份有限公司 | Build project quick self-checking method, system and computer readable storage medium in pricing |
| CN110390564B (en) * | 2019-07-18 | 2022-04-15 | 广联达科技股份有限公司 | Method, system and computer readable storage medium for quick self-checking items in building pricing program |
| CN112464032A (en) * | 2019-12-24 | 2021-03-09 | 上海汇招信息技术有限公司 | Bidding clearing method |
| CN112988662A (en) * | 2021-02-19 | 2021-06-18 | 惠州市建设集团工程建设监理有限公司 | BIM-based project supervision information processing method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110430206B (en) | Method for generating and configuring firewall security policy based on script templating | |
| CN109472642A (en) | The editing of electricity power engineering cost and inventory application system based on working drawing budget management | |
| CN109857799A (en) | The automatic auditing system of tender price and method | |
| CN104216912B (en) | The implementation method and device of a kind of business form work fluidisation without intrusive mood | |
| CN110119977A (en) | Financial accounting voucher automatic generation method, system, medium and electronic equipment | |
| US20110264591A1 (en) | Method and platform for integrating a heterogeneous workgroup collaborative design system and a plm system | |
| CN110704518A (en) | Business data processing method and device based on Flink engine | |
| CN102521662A (en) | Consumption charging method in cloud computing environment | |
| CN111507686B (en) | Automatic budget system and method for engineering design change | |
| CN104270787A (en) | Full-automatic closed-loop control method of wireless network work order | |
| CN104050297B (en) | A kind of inquiry transaction distribution method and device | |
| CN105718601A (en) | Business dynamic integration model and application method thereof | |
| CN106897920A (en) | A kind of automatic measures and procedures for the examination and approval of operation flow and system | |
| CN107808334A (en) | A kind of method that accounting voucher is automatically generated from business paper | |
| CN110782225A (en) | Workflow dynamic reconstruction method for parameter value influence flow branch | |
| US20190243905A1 (en) | Generating and identifying distinct portions of a merged file | |
| CN109542863A (en) | Mine machine system is dug in artificial intelligence storage | |
| CN116258469B (en) | Service data processing method, system, equipment and medium based on communication software | |
| CN103530436B (en) | Tooling layout drawing parameterization generation method based on AUTOCAD. NET API | |
| CN110866813A (en) | Intelligent accounting system for managing accountants | |
| CN110347736A (en) | A kind of data self mapping method towards RDF triple | |
| CN112686646B (en) | Contract line reporting management method and system | |
| CN103413191A (en) | Integration management method of budget management and financial accounting and system | |
| CN111598729B (en) | Method for conveniently compiling settlement change list | |
| CN114625344A (en) | Application service generation system and service process configuration method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190607 |
|
| RJ01 | Rejection of invention patent application after publication |