CN113610594B - Equipment review price data processing method and system - Google Patents
Equipment review price data processing method and system Download PDFInfo
- Publication number
- CN113610594B CN113610594B CN202110842760.7A CN202110842760A CN113610594B CN 113610594 B CN113610594 B CN 113610594B CN 202110842760 A CN202110842760 A CN 202110842760A CN 113610594 B CN113610594 B CN 113610594B
- Authority
- CN
- China
- Prior art keywords
- quotation
- data
- scheme
- price
- checking
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000012552 review Methods 0.000 title claims abstract description 45
- 238000003672 processing method Methods 0.000 title claims description 9
- 239000000463 material Substances 0.000 claims abstract description 63
- 238000000354 decomposition reaction Methods 0.000 claims abstract description 61
- 238000000034 method Methods 0.000 claims abstract description 35
- 238000012550 audit Methods 0.000 claims abstract description 26
- 238000012545 processing Methods 0.000 claims abstract description 18
- 230000008569 process Effects 0.000 claims abstract description 7
- 238000004364 calculation method Methods 0.000 claims description 63
- 238000007726 management method Methods 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 3
- 239000000047 product Substances 0.000 description 11
- 230000006870 function Effects 0.000 description 9
- 230000000875 corresponding effect Effects 0.000 description 8
- 238000013507 mapping Methods 0.000 description 7
- 238000013461 design Methods 0.000 description 6
- 230000008676 import Effects 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 239000002994 raw material Substances 0.000 description 4
- 230000010354 integration Effects 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000006855 networking Effects 0.000 description 2
- 238000012946 outsourcing Methods 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 239000013070 direct material Substances 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0611—Request for offers or quotes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a system for processing equipment price reporting data. The method comprises a quotation process and a price review process. The quotation flow comprises the following steps: creating a quotation scheme for equipment to be quoted; loading a data filling template; determining an equipment decomposition subunit; respectively filling data of each equipment decomposition subunit, uploading supporting materials, and associating the supporting materials with filling data; calculating quotation; and saving and reporting the quotation scheme. The price checking flow comprises the following steps: receiving a quotation scheme; data auditing is carried out on the quotation scheme, and auditing unit price is determined; checking support materials of the quotation scheme or adding new support materials for the quotation scheme; calculating an audit price; and (5) preserving the price checking scheme. The invention realizes the standardization and informatization of quotation and price examination, and has extremely high application value.
Description
Technical Field
The invention belongs to the technical field of quotation, and particularly relates to a method and a system for processing equipment price reporting data.
Background
The price of equipment/products is typically quoted by the enterprise, and the price of an equipment/product is determined after the price is reviewed by the requesting party. In the prior art, a mode of manually filling data item by item and checking on site is mainly adopted, and an informationized technical means is lacked, so that the reporting and checking work efficiency is low, the time is long, the related data cannot be effectively managed and utilized, and the actual requirements cannot be met.
Disclosure of Invention
In response to at least one of the needs for improvement or at least one of the drawbacks of the prior art, the present invention provides a method and system for processing equipment review data.
To achieve the above object, according to a first aspect of the present invention, there is provided an equipment review data processing method including the steps of:
creating a quotation scheme for equipment to be quoted, and setting quotation related information in the quotation scheme;
loading a data filling template, wherein the data filling template comprises a filling interface template and a quotation calculation template;
determining a device decomposition subunit according to the quotation related information, and generating a quotation scheme reporting interface according to the reporting interface template;
respectively carrying out data reporting of each equipment decomposition subunit on the quotation scheme reporting interface, uploading supporting materials, and associating the supporting materials with reporting data;
Calculating a bid based on the fill data using the standard bid calculation template;
and storing and reporting the quotation scheme, wherein the quotation scheme comprises quotation related information, the data reporting template, the reporting data, the supporting material and the quotation.
Preferably, before storing and reporting the quotation scheme, the method further comprises the steps of:
Checking and modifying the quotation proposal, the checking taking any combination of one or more of the following checks:
consistency check: checking whether inconsistent content exists in the quotation scheme;
integrity check: checking whether the quotation proposal has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
calculating error checking: checking whether calculation errors exist in the quotation scheme;
Rationality checking: and analyzing whether the ratio of various amounts in the quotation scheme is reasonable.
Preferably, the determining the equipment decomposing subunit according to the quotation related information is implemented in any one or more of the following ways:
determining equipment decomposition subunits according to the working composition decomposition structure;
and/or determining an equipment decomposition subunit according to the equipment composition decomposition structure;
and/or determining the equipment resolution subunit in accordance with the fill unit composition structure.
Preferably, the step of saving and reporting the quotation scheme includes the steps of:
and reporting the filling data of the equipment decomposition subunit in a summarizing way according to the determination mode of the equipment decomposition subunit.
According to a second aspect of the present invention, there is provided an equipment review data processing method comprising the steps of:
Receiving a quotation scheme, wherein the quotation scheme comprises quotation related information, a data filling template, filling data, supporting materials and quotation, the filling data comprise data of equipment decomposition subunits, and the data filling template comprises a filling interface template and a quotation calculation template;
data auditing is carried out on the quotation scheme, and auditing quantity and auditing unit price are determined;
checking support materials of the quotation scheme or adding new support materials for the quotation scheme;
calculating an audit price according to the quotation scheme, the audit quantity and the audit unit price by using the quotation calculation template;
And storing a price checking scheme, wherein the price checking scheme comprises the price checking unit price and the price checking unit price.
Preferably, before the storing of the trial price, the method further comprises the steps of:
Checking and modifying the quotation proposal, the checking comprising any combination of one or more of the following:
consistency check: checking whether inconsistent content exists in the quotation scheme;
integrity check: checking whether the quotation proposal has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
calculating error checking: checking whether calculation errors exist in the quotation scheme;
Rationality checking: and analyzing whether the ratio of various amounts in the quotation scheme is reasonable.
Preferably, the data audit includes any combination of one or more of the following audits:
Manual auditing: checking the filling data of the quotation proposal one by one, and filling checking unit price;
batch auditing: selecting a plurality of filling data of the quotation scheme, and uniformly setting calculation coefficients of auditing unit price;
summarizing and checking: summarizing data of equipment decomposition subunits in the quotation scheme to an interface for auditing;
Checking the price ratio: and searching historical data according to the quotation scheme, and comparing and auditing the historical data with the quotation scheme.
Preferably, the method further comprises the steps of:
Checking the working progress in the process of checking the price, and displaying the working progress in a graphical mode;
Analyzing the price composition of the quotation scheme and the price review scheme;
Analyzing the quotation scheme and the trial scheme difference;
and generating a price review report according to the quotation scheme and the price review scheme.
According to a third aspect of the present invention, there is provided an equipment review data processing system comprising an offer system comprising:
the system comprises a creation module, a display module and a display module, wherein the creation module is used for creating a quotation scheme for equipment to be quoted and setting quotation related information in the quotation scheme;
The template loading module is used for loading a data filling template, wherein the data filling template comprises a filling interface template and a quotation calculation template;
The interface generation module is used for determining equipment decomposition subunits according to the quotation related information and generating a quotation scheme filling interface according to the filling interface template;
The filling module is used for respectively filling data of each equipment decomposition subunit on the quotation scheme filling interface, uploading supporting materials and associating the supporting materials with filling data;
A calculation module for calculating a bid based on the fill data using the standard bid calculation template;
And the reporting module is used for storing and reporting the quotation scheme, wherein the quotation scheme comprises quotation related information, the data reporting template, the reporting data, the supporting material and the quotation.
According to a fourth aspect of the present invention, there is provided an equipment report review data processing system including a review system including:
The system comprises a receiving module, a judging module and a judging module, wherein the receiving module is used for receiving a quotation scheme, the quotation scheme comprises quotation related information, a data reporting template, reporting data, supporting materials and quotation, the reporting data comprises data of equipment decomposition subunits, and the data reporting template comprises a reporting interface template and a quotation calculation template;
the data auditing module is used for conducting data auditing on the quotation scheme and determining auditing quantity and auditing unit price;
A support material management module for viewing support materials of the quotation scheme or adding new support materials for the quotation scheme;
The calculating module is used for calculating an audit price according to the quotation scheme, the audit quantity and the audit unit price by utilizing the quotation calculating template;
The storage module is used for storing the price checking scheme, wherein the price checking scheme comprises the price checking unit price and the price checking unit price.
Overall, compared with the prior art, the invention has the beneficial effects:
(1) By loading the data filling template, unifying the contents such as quotation scheme formats, standards, contents and the like, standardized acquisition of quotation scheme data is realized, and the problems that field filling is disordered, important data such as raw materials and the like cannot be identified and utilized due to EXCEL quotation in the past are prevented;
(2) Through the quotation scheme, the electronic management and the mutual verification of the supporting materials, the equipment price checking center can receive the quotation scheme, realize the seamless butt joint and the remote checking of quotation data and an equipment price database, and the enterprise provides true and effective quotation data with complete content and complete elements;
(3) The method has the advantages that necessary informatization management means are provided for the checked units, quotation personnel can rapidly extract and fill data through enterprise ERP data and historical quotation schemes, check the quotation schemes, find and analyze error and difference reasons, form scientific and reasonable quotation schemes, and reduce repeated work.
(4) Firstly, realizing collaborative joint price checking, and providing effective historical data for checking by means of a price checking management information system and an equipment price database through establishing a small local area network on a price checking site, wherein all procedural documents and data are recorded on a server side, so that the problems of data loss and secret leakage are prevented;
(5) The traceability and the whole-course recording of the price checking process are realized, the information including time, place, personnel, operation and the like is included, rights and responsibilities are strictly distinguished, and the influence of human factors on a price scheme is reduced;
(6) The method realizes informatization management of important supporting materials such as contracts, invoices, drawings, technical schemes and the like, ensures the price scheme to be fully and reasonably compliant, and is favorable for avoiding the price checking risk;
(7) The method changes the traditional experience type price checking method in the past, can search historical data with reference through intelligent price comparison, carries out longitudinal verification and transverse comparison on enterprise quotation data through modes of accurate matching, fuzzy matching and the like, realizes informatization price checking in a big data environment, timely discovers various false report conceal behaviors, and provides means support for scientifically and reasonably determining equipment price;
(8) The price scheme data is synchronously processed, and some simple physical labor is transmitted to a computer for processing through automatic summarization and real-time updating, so that the problem of error, forgetting, missing and the like is solved;
(9) The method and the device provide means for annotating, templates, drafts, batch processing, comparison analysis, price comparison, automatic report generation and the like, are convenient for the price-checking specialists to effectively conduct auditing work, and comprehensively improve the working quality and efficiency.
Drawings
FIG. 1 is a schematic diagram of a quotation flow of an equipment review data processing method according to an embodiment of the invention;
FIG. 2 is a schematic view of an audit flow chart of an equipment report audit data processing method according to another embodiment of the present invention;
FIG. 3 is a schematic diagram of a bid interface of an equipment review data processing system in accordance with an embodiment of the present invention;
FIG. 4 is a schematic view of an audit interface of an equipment review data processing system according to another embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. In addition, the technical features of the embodiments of the present invention described below may be combined with each other as long as they do not collide with each other.
As shown in fig. 1 and fig. 3, a method for processing equipment review data according to an embodiment of the present invention includes the steps of:
s1, creating a quotation scheme for equipment to be quoted, and setting quotation related information in the quotation scheme.
Enterprise quotation personnel create a completely new quotation scheme by creating a quotation scheme function, and the quotation related information is quotation scheme related information. In one embodiment, the offer related information includes basic information of equipment/product name, specification model, offer unit, year, etc. to be offered;
S2, loading a data filling template, wherein the data filling template comprises a filling interface template and a quotation calculating template.
The interface of the filling interface template is a preset style of the interface for the user to fill data. Specifically, the filling interface template may include contents, options, page layout, and the like that need to be filled.
The quotation calculation template is a preset method for calculating quotation according to data filling by a user. Specifically, the offer calculation template may include: (1) The calculation formula and the data source position (formula calculation range) of the parameters in the calculation formula, namely, which data in a filling interface is adopted to calculate the calculation formula, wherein the formula calculation range can specify cell calculation, column calculation, row calculation, single-table calculation, current-stage calculation or full-table calculation; (2) The execution order of the plurality of calculation formulas, i.e. which calculation formula is calculated first and which calculation formula is calculated next if there are a plurality of calculation formulas, for example, whether a cell formula is calculated first or a row formula is calculated. It may also be set whether the calculation formula is enabled, etc.
Different data reporting templates can be created at the quotation system of the reporting and auditing system according to different stages. After the creation is completed, the background operation and maintenance system of the reporting and checking system generates a series of plug-in packages of templates, and the plug-in packages are issued to the quotation system. The quotation system can load the plug-in package into the quotation system after receiving the plug-in package generated by the background operation and maintenance system, and the quotation system has a set of filling scheme tables in corresponding stages after loading.
For example, four types of data filling templates for the calculation of the overview and the calculation of the budget accounting can be provided. And (3) carrying out general calculation: inaccurate balance data obtained through rough statistics before budget planning generally refers to multi-finger design rough calculation, and the content of the multi-finger design rough calculation is large in generality. Budget: the project is more detailed and important for planning the income and expense conditions of engineering projects in a certain period in the future. Accounting: in project progress, project actual investment and budget are made to perform rolling accounting so as to find and analyze reasons for GAP occurrence, and the project profitability is prevented from being influenced by investment waste. And (3) resolution: after the project delivery is finished and the income is confirmed, the accounting budget and the general calculation are analyzed and compared, the gap is found, and the reason is analyzed to summarize the experience. The data of the corresponding stage is filled by providing four tables of project approximation, project budget, project accounting and project resolution. After quotation is finished, the price data can be correlated and compared with the data, and price data differences of all stages can be visually seen so as to analyze and summarize.
The method comprises the steps of establishing a data filling template library in advance in a background operation and maintenance system of a reporting and auditing system, wherein the data filling template library comprises a plurality of data filling templates, carrying out version management and flow approval on the data filling templates in the data filling template library, and selecting the data filling templates passing the flow approval for loading in the quoting and reporting step.
S3, determining a device decomposition subunit according to the quotation related information in the step S1, and generating a quotation scheme filling interface according to the filling interface template in the step S2.
The equipment to be quoted is split into a plurality of equipment decomposition subunits, so that the multi-person collaborative quotation can be realized.
And reporting/checking prices according to the equipment decomposition subunit, so that unit cost data are calculated step by step, the unit cost data are collected step by step, and finally, the total cost of the whole project is estimated. The method has the characteristics of high estimation accuracy and easiness in division operation of projects.
The manner in which the equipment decomposition sub-units are determined is implemented in a combination of any one or more of the following ways.
(1) The equipment decomposition sub-unit is determined in accordance with the working composition decomposition structure.
The work composition decomposition structure refers to a structure divided according to the work content of the equipment to be quoted, for example, decomposition is performed according to stages of design, test and the like, and the quoted data of the stages are respectively filled according to the stages of design, test and the like.
(2) The equipment decomposition sub-units are determined according to the equipment composition decomposition structure.
The equipment composition decomposition structure refers to a structure divided according to a composition combination of equipment to be quoted, such as a system composition, a subsystem/subsystem level composition, a product composition, a component composition, and the like. The quotation personnel obtain equipment composition decomposition structures according to the design BOM or the production BOM, determine corresponding equipment decomposition subunits, can select to construct directly on a system main interface through operations such as line insertion, line copying, line pasting, line deletion and the like, and can also select an importing mode.
(3) And determining the equipment decomposition subunit according to the filling unit composition structure.
The unit composition structure refers to the information related to the unit composition such as the unit part composition, the specialty, the responsible person, the responsibility, the authority and the like.
The equipment decomposition sub-unit may be determined according to the working composition decomposition structure for the equipment under development, and the equipment decomposition sub-unit may be determined according to the equipment composition decomposition structure for the equipment under development.
And S4, respectively carrying out data filling of each equipment decomposition subunit on a quotation scheme filling interface.
Preferably, the system comprises specific prices such as enterprise information, direct materials, working hour quota, military special project, total working hour of tasks, five fees and the like, and is cooperatively operated by multiple departments.
Any one of three modes of file import, system integration and manual filling is adopted. The file import refers to filling quotation by adopting the file of the imported file; the system integration refers to the process of collecting data from quotation related systems such as PDM, contract purchasing system and the like for quotation filling through an interface calling mode; manual filling refers to filling of quotations manually.
The file import adopts any one of the following modes:
template introduction mode: downloading a standard form template from the quotation scheme filling interface, filling the standard form template to generate a standard filling form, and importing the standard form template into the quotation scheme filling interface;
Detail introduction mode: and establishing a mapping relation between the filled-in filling items of the nonstandard form file and the filling items of the filling interface of the quotation proposal. In the detail importing interface, uploading an EXCEL file to be imported, selecting a field on the left side of the interface, finding a column corresponding to the field in the preview interface on the right side, and double-clicking the column to generate a mapping relation with the selected field. The mapping relation is stored in a database of the server, and if the mapping relation is stored, the mapping relation can be automatically mapped when the mapping relation is imported next time.
The structure file importing mode is as follows: downloading a structure file standard form template from the quotation scheme filling interface, wherein the structure file standard form template defines filling standards of a plurality of products with structural relations, filling the structure file standard form template to generate a structure file standard filling form, and importing the filled structure file standard form template into the quotation scheme filling interface;
History data import: acquiring historical filling data, and importing the historical filling data in the quotation scheme filling interface;
Standard data import: acquiring preset standard filling data, and importing the standard filling data into the quotation scheme filling interface;
And (3) data packet import: analyzing key fields contained in a data packet, and establishing a mapping relation between information in the data packet and a filling item of the quotation scheme filling interface according to the key fields;
And (3) introducing: and copying and filling the content and pasting the content to the quotation scheme filling interface.
And S5, uploading the supporting material and associating the supporting material with the filling data.
The support material is an important basis for reporting and checking price data, and the system supports synchronous input of quotation support materials, including uploading, downloading, deleting, sharing and other functions, so that file sharing and calling among all internal projects are realized, and the support material is added from an external system through an interface and accurately managed to each cell data storage position. For example, a row of component data, technical data may be added for that row, and purchase order price data may be added for a unit price. For another example, when a certain affiliated unit reports a plurality of pieces of equipment at the same year, the supporting material of the basic information data of the unit can be shared among a plurality of pieces of equipment, so that the disorder of the supporting material and the repeated work are avoided.
The system supports support materials of different formats: folders, compression packages, word documents, excel forms, PDF, pictures of various format types, etc., while supporting materials of different service types, such as purchase invoices, technical contracts, technical indexes, etc.
The support material may be subordinate to the table level, row level, and cell level, i.e., associated with a row, or table, or cell in the filled data.
S6, calculating the quotation based on the filling data of the step S4 by using the quotation calculation template of the step S2.
And clicking calculation can read corresponding filling data according to the selected quotation calculation template, execute calculation of a corresponding calculation formula and calculate corresponding price data.
Thus, the quotation scheme is preliminarily completed, and comprises quotation related information, a data filling template, filling data, supporting materials and quotation.
S7, checking and modifying the quotation scheme, wherein the checking adopts any combination of one or more of the following checking modes.
Consistency check: checking whether inconsistent contents exist in the quotation scheme;
integrity check: checking whether the quotation scheme has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
Calculating error checking: checking whether calculation errors exist in the quotation scheme;
rationality checking: analyzing whether the ratio of various amounts in the quotation scheme is reasonable;
and (3) checking in real time: the calculation formula in the quotation calculation template can be called to verify whether the currently filled data is correct or not at any time.
S8, saving the quotation scheme.
And storing the filled quotation scheme data.
S9, reporting a quotation scheme.
Reporting the successfully stored quotation proposal to a demander or a third party price checking organization.
Reporting also preferably supports the following functions:
(1) Support multi-interface offsite offers: in the same reporting/review item, different underwriting units and price data for each department in a subordinate unit or units may be required. Some units and departments are in the same local area network or intranet, and some units and departments cannot realize networking. For the network, the data can be summarized and integrated directly on line; and for the networking failure, reporting/issuing can be adopted, and the aggregation and integration can be carried out in a physical file transmission mode.
(2) And supporting unified reporting.
(3) And supporting information hierarchical summarization and hierarchical reporting.
Reporting is preferably performed by summarizing the reporting data of the equipment decomposition subunit by using any one or a combination of the following modes:
reporting the filling data of the equipment decomposition subunit in a summarizing way according to the equipment composition decomposition structure;
And/or reporting the filling data of the equipment decomposition subunit according to the working composition decomposition structure;
and/or reporting the filling data of the equipment decomposition subunit according to the filling unit composition structure.
The reporting also includes the following functions.
(4) And supporting the quotation scheme, the price report and the report to be automatically generated, and outputting and printing the report in a complete set according to the army type requirements.
(5) Supporting the reporting and receiving of encrypted data packets.
As shown in fig. 2 and fig. 4, a method for processing equipment review data according to an embodiment of the present invention includes the steps of:
S1, receiving a quotation scheme.
And receiving a quotation scheme reported by an enterprise, wherein the quotation scheme comprises quotation related information, a data reporting template, reporting data, supporting materials and quotation, the reporting data comprises data of equipment decomposition subunits, the data reporting template comprises a reporting interface template and a quotation calculation template, and the price checking work can be directly started after the receiving is successful.
S2, data auditing is carried out on the quotation scheme, and the auditing quantity and auditing unit price are determined.
Data audits include any combination of one or more of the following audits.
Manual auditing: the method is that price-checking personnel check price-quoting data piece by piece, and the checked price data is filled into the system.
Batch price checking: the method is characterized in that batch auditing can be carried out on quotation data, a plurality of quotation data are selected, and a certain calculation coefficient is set to achieve the effect of batch auditing, so that the price auditing efficiency is improved. For example, assuming that the design calculation coefficient is 0.8, the price of the filling item a is 100, and the price of the filling item B is 200 in the quotation scheme, the trial price of the filling item a is 80, and the trial price of the filling item B is 160.
Summarizing and checking prices: the method is that data of multiple product decomposition structures can be summarized to the same interface for auditing, so that the operation of an audit staff is more convenient. The data in different product decomposition structures are different, but the data have certain similarity, such as material price, component price and the like, and price data corresponding to each structure are required to be checked, so that a plurality of tables are required to be operated, and the data of the same table of the current structure and all sub-level structures can be summarized to the same page by summarizing the price, thereby being convenient for the operation of the price inspector and greatly improving the working efficiency.
Checking the price ratio: the method can search the same condition data and the same name table data in the historical data, and can apply the searched data to the currently-to-be-checked table, and can also carry out comparison reference. When the price is compared with the historical data, the historical data comprises accurate matching and fuzzy matching, wherein the accurate matching is that all search conditions are required to be met, and the fuzzy matching is that only one search condition is required to be met.
The price comparison checking function defines the object as data, and can select a comparison product or comparison unit data according to the requirement, wherein the data meeting the conditions is used as the comparison object, for example, an expert has checked the product A, then the comparison is carried out in the project or other projects by the same material or unit information as the material or unit information used in the product A, a new page is opened for displaying, the comparison data is displayed in a mode of an upper structure and a lower structure, all the data of the table are displayed in an upper part, and the lower structure corresponds to the price comparison result selected above.
And S3, checking the support material of the quotation scheme or adding new support material for the quotation scheme.
The inspector can check the supporting materials provided by the quotation unit to check the rationality of the price; in addition, new support materials can be added as a basis for the price review, for example, the support materials lack of some important data in the price proposal can be assumed, the price quotation units can be required to supplement the support materials in the price review stage, and the supplement support materials can be added.
S4, calculating the audit price according to the quotation scheme and the audit price determined in the step S2 by using the quotation calculation template in the quotation scheme.
And reading the required data from the quotation scheme, the auditing quantity and the auditing unit price according to the quotation calculating template, executing a calculating formula and calculating the auditing price.
S5, checking data compliance.
Checking and modifying the quotation proposal, the checking comprising any combination of one or more of the following:
consistency check: checking whether inconsistent contents exist in the quotation scheme;
integrity check: checking whether the quotation scheme has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
Calculating error checking: checking whether calculation errors exist in the quotation scheme;
Rationality checking: and analyzing whether the ratio of various amounts in the quotation scheme is reasonable.
S6, saving the price checking scheme.
Storing the price data which is checked to a database;
And S7, acquiring the working progress in the process of checking the price, and displaying the working progress in a graphical mode.
The person in charge of the examination can check the overall working progress, can also check the working progress of each expert/examination person, show through the way of the graphic;
s8, analyzing the price composition of the quotation scheme and the price review scheme.
The ratio analysis is carried out according to the BOM structure type, for example, the ratio proportion of each component in a certain type of engine can be clearly checked to see the price composition of each part of the engine; the ratio analysis is carried out on the detail data, the ratio analysis is carried out on the data comprising raw materials, components, auxiliary materials and the like, the ratio of the amount of money in the raw materials, the components, outsourcing finished products and outsourcing auxiliary materials can be checked, the data comprising the raw materials, the components and the like with larger total cost amount can be rapidly positioned, and a user can be helped to rapidly screen key data from thousands of data for analysis and the like;
S9, analyzing the difference between the quotation scheme and the trial scheme.
The army examination price, the factory report price, the check decrease price, the amplitude and other values of the selected options are displayed through the options in the elective course-mesh name list, and the difference condition is displayed in a columnar graph;
And S10, generating a price review report according to the quotation scheme and the price review scheme.
Different reports are generated according to different templates preset in the system, report content is automatically generated, document information can be stored in a database after the document is edited, a document entity is stored on a server, and the reports can be output to a designated position. In the report/review toolbar, an annotating function and a draft function can also be provided. The annotating function is to annotate the file. The draft function corresponds to providing a temporary folder.
The invention provides a device price reporting data processing system, which comprises a quotation system, wherein the quotation system comprises:
the creation module is used for creating a quotation scheme for the equipment to be quoted and setting quotation related information in the quotation scheme;
The template loading module is used for loading a data filling template, and the data filling template comprises a filling interface template and a quotation calculation template;
the interface generation module is used for determining equipment decomposition subunits according to the related quotation information and generating a quotation scheme reporting interface according to the reporting interface template;
the filling module is used for respectively filling data of each equipment decomposition subunit on a quotation scheme filling interface, uploading supporting materials and associating the supporting materials with the filling data;
The calculation module is used for calculating quotation based on the filling data by using the standard quotation calculation template;
And the reporting module is used for storing and reporting the quotation scheme, wherein the quotation scheme comprises quotation related information, a data reporting template, reporting data, supporting materials and quotation.
The invention provides a device report price-checking data processing system, which comprises a price-checking system, wherein the price-checking system comprises:
The system comprises a receiving module, a display module and a display module, wherein the receiving module is used for receiving a quotation scheme, the quotation scheme comprises quotation related information, a data reporting template, reporting data, supporting materials and quotation, the reporting data comprises data of equipment decomposition subunits, and the data reporting template comprises a reporting interface template and a quotation calculation template;
the data auditing module is used for conducting data auditing on the quotation scheme and determining auditing quantity and auditing unit price;
the support material management module is used for checking support materials of the quotation scheme or adding new support materials for the quotation scheme;
The calculating module is used for calculating the audit price according to the quotation scheme, the audit quantity and the audit unit price by utilizing the quotation calculating template;
the storage module is used for storing the price checking scheme, wherein the price checking scheme comprises checking unit price and price checking.
The implementation principle and technical effect of the system are similar to those of the method, and are not repeated here.
It should be noted that, in any of the above embodiments, the methods are not necessarily sequentially executed in the sequence number, and it is meant that the methods may be executed in any other possible sequence, as long as it cannot be inferred from the execution logic that the methods are necessarily executed in a certain sequence.
It will be readily appreciated by those skilled in the art that the foregoing description is merely a preferred embodiment of the invention and is not intended to limit the invention, but any modifications, equivalents, improvements or alternatives falling within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (8)
1. The equipment review price data processing method is characterized by comprising the following steps:
creating a quotation scheme for equipment to be quoted, and setting quotation related information in the quotation scheme;
loading a data filling template, wherein the data filling template comprises a filling interface template and a quotation calculation template;
Determining a device decomposition subunit according to the quotation related information, and generating a quotation scheme reporting interface according to the reporting interface template; the equipment decomposition subunit is determined according to the quotation related information in any one or more of the following modes:
determining equipment decomposition subunits according to the working composition decomposition structure;
and/or determining an equipment decomposition subunit according to the equipment composition decomposition structure;
And/or determining equipment decomposition subunits according to the filling unit composition structure;
respectively carrying out data reporting of each equipment decomposition subunit on the quotation scheme reporting interface, uploading supporting materials, and associating the supporting materials with reporting data;
calculating a bid based on the fill data using a standard bid calculation template;
Storing and reporting the quotation scheme, wherein the quotation scheme comprises the quotation related information, the data reporting template, the reporting data, the supporting material and the quotation, and the storing and reporting the quotation scheme comprises the following steps: and reporting the filling data of the equipment decomposition subunit in a summarizing way according to the determination mode of the equipment decomposition subunit.
2. The equipment review data processing method as set forth in claim 1, further comprising the steps of, before storing and reporting the quotation proposal:
Checking and modifying the quotation proposal, the checking taking any combination of one or more of the following checks:
consistency check: checking whether inconsistent content exists in the quotation scheme;
integrity check: checking whether the quotation proposal has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
calculating error checking: checking whether calculation errors exist in the quotation scheme;
Rationality checking: and analyzing whether the ratio of various amounts in the quotation scheme is reasonable.
3. The equipment review price data processing method is characterized by comprising the following steps:
Receiving a quotation scheme, wherein the quotation scheme comprises quotation related information, a data filling template, filling data, supporting materials and quotation, the filling data comprise data of equipment decomposition subunits, and the data filling template comprises a filling interface template and a quotation calculation template;
data auditing is carried out on the quotation scheme, and auditing quantity and auditing unit price are determined;
checking support materials of the quotation scheme or adding new support materials for the quotation scheme;
calculating an audit price according to the quotation scheme, the audit quantity and the audit unit price by using the quotation calculation template;
And storing a price checking scheme, wherein the price checking scheme comprises the price checking unit price and the price checking unit price.
4. A method of processing equipment review data as claimed in claim 3, further comprising the steps of, prior to storing said review:
Checking and modifying the quotation proposal, the checking comprising any combination of one or more of the following:
consistency check: checking whether inconsistent content exists in the quotation scheme;
integrity check: checking whether the quotation proposal has all necessary contents;
compliance review: checking whether repeated content or unnecessary content exists in the quotation scheme;
calculating error checking: checking whether calculation errors exist in the quotation scheme;
Rationality checking: and analyzing whether the ratio of various amounts in the quotation scheme is reasonable.
5. A method of processing equipment review data as claimed in claim 3, wherein the data review comprises any combination of one or more of the following:
Manual auditing: checking the filling data of the quotation proposal one by one, and filling checking unit price;
batch auditing: selecting a plurality of filling data of the quotation scheme, and uniformly setting calculation coefficients of auditing unit price;
summarizing and checking: summarizing data of equipment decomposition subunits in the quotation scheme to an interface for auditing;
Checking the price ratio: and searching historical data according to the quotation scheme, and comparing and auditing the historical data with the quotation scheme.
6. A method of processing equipment review data as claimed in claim 3, further comprising the steps of:
Checking the working progress in the process of checking the price, and displaying the working progress in a graphical mode;
Analyzing the price composition of the quotation scheme and the price review scheme;
Analyzing the quotation scheme and the trial scheme difference;
and generating a price review report according to the quotation scheme and the price review scheme.
7. An equipment review data processing system, comprising a quotation system, the quotation system comprising:
the system comprises a creation module, a display module and a display module, wherein the creation module is used for creating a quotation scheme for equipment to be quoted and setting quotation related information in the quotation scheme;
The template loading module is used for loading a data filling template, wherein the data filling template comprises a filling interface template and a quotation calculation template;
The interface generation module is used for determining equipment decomposition subunits according to the quotation related information and generating a quotation scheme filling interface according to the filling interface template;
The filling module is used for respectively filling data of each equipment decomposition subunit on the quotation scheme filling interface, uploading supporting materials and associating the supporting materials with filling data;
A calculation module for calculating a bid based on the fill data using a standard bid calculation template;
And the reporting module is used for storing and reporting the quotation scheme, wherein the quotation scheme comprises quotation related information, the data reporting template, the reporting data, the supporting material and the quotation.
8. An equipment review data processing system, comprising a review system, the review system comprising:
The system comprises a receiving module, a judging module and a judging module, wherein the receiving module is used for receiving a quotation scheme, the quotation scheme comprises quotation related information, a data reporting template, reporting data, supporting materials and quotation, the reporting data comprises data of equipment decomposition subunits, and the data reporting template comprises a reporting interface template and a quotation calculation template;
the data auditing module is used for conducting data auditing on the quotation scheme and determining auditing quantity and auditing unit price;
A support material management module for viewing support materials of the quotation scheme or adding new support materials for the quotation scheme;
The calculating module is used for calculating an audit price according to the quotation scheme, the audit quantity and the audit unit price by utilizing the quotation calculating template;
The storage module is used for storing the price checking scheme, wherein the price checking scheme comprises the price checking unit price and the price checking unit price.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110842760.7A CN113610594B (en) | 2021-07-26 | 2021-07-26 | Equipment review price data processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110842760.7A CN113610594B (en) | 2021-07-26 | 2021-07-26 | Equipment review price data processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113610594A CN113610594A (en) | 2021-11-05 |
| CN113610594B true CN113610594B (en) | 2024-05-24 |
Family
ID=78338325
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110842760.7A Active CN113610594B (en) | 2021-07-26 | 2021-07-26 | Equipment review price data processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113610594B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105741011A (en) * | 2016-01-18 | 2016-07-06 | 四川建设网有限责任公司 | Engineering tender offer and evaluation method and engineering tender offer and evaluation system |
| CN108335080A (en) * | 2018-01-25 | 2018-07-27 | 广州建衡工程咨询有限公司 | A kind of Construction Audit system and implementation method |
| CN108364193A (en) * | 2018-01-25 | 2018-08-03 | 广州建衡工程咨询有限公司 | A kind of construction project cost auditing method and system |
| CN109359946A (en) * | 2018-10-23 | 2019-02-19 | 上海新致软件股份有限公司 | Construction Audit method and system |
| CN111861366A (en) * | 2020-06-08 | 2020-10-30 | 远光软件股份有限公司 | Project-ground intelligent auditing system and computer |
-
2021
- 2021-07-26 CN CN202110842760.7A patent/CN113610594B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105741011A (en) * | 2016-01-18 | 2016-07-06 | 四川建设网有限责任公司 | Engineering tender offer and evaluation method and engineering tender offer and evaluation system |
| CN108335080A (en) * | 2018-01-25 | 2018-07-27 | 广州建衡工程咨询有限公司 | A kind of Construction Audit system and implementation method |
| CN108364193A (en) * | 2018-01-25 | 2018-08-03 | 广州建衡工程咨询有限公司 | A kind of construction project cost auditing method and system |
| CN109359946A (en) * | 2018-10-23 | 2019-02-19 | 上海新致软件股份有限公司 | Construction Audit method and system |
| CN111861366A (en) * | 2020-06-08 | 2020-10-30 | 远光软件股份有限公司 | Project-ground intelligent auditing system and computer |
Non-Patent Citations (2)
| Title |
|---|
| 刘燕芳 ; .建筑电气工程造价审核常见问题及解决措施.山西建筑.2018,(第13期),全文. * |
| 建筑电气工程造价审核常见问题及解决措施;刘燕芳;;山西建筑(第13期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113610594A (en) | 2021-11-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Azeroual et al. | The effects of using business intelligence systems on an excellence management and decision-making process by start-up companies: A case study | |
| CN104299105A (en) | Credit data management system supporting complex enterprise environment and credit data management method | |
| CN112232761B (en) | Infrastructure application system and method | |
| CN111861366A (en) | Project-ground intelligent auditing system and computer | |
| CN110728422A (en) | Building information model, method, device and settlement system for construction project | |
| US20080249816A1 (en) | System and Method for Monitoring Workflow in a Project Management System | |
| US7987209B2 (en) | Enhanced trade compliance system: mass amendment | |
| US20120253997A1 (en) | Method for multi-dimensional accounting of business transactions and system therefor | |
| Hikmawati et al. | Improving Data Quality and Data Governance Using Master Data Management: A Review | |
| WO2019127819A1 (en) | Brand promotion project management method and apparatus, terminal device and medium | |
| CN111897866A (en) | Remote sensing monitoring pattern spot docking system and using method thereof | |
| CN113610595B (en) | Report and examination price informatization management method and system | |
| CN108846645A (en) | A kind of enterprise's flattened management method and system | |
| US8473528B2 (en) | Delivery enablement workforce utilization tool integration | |
| CN111178680A (en) | Wind power plant engineering quality overall process management system, method and equipment | |
| CN114372731B (en) | Post target making method, device, equipment and storage medium based on big data | |
| CN102376023A (en) | Integration method for evaluation material for credit evaluation | |
| Lidyah et al. | The Evolution of Accounting Information Systems Research: A Bibliometric Analysis of Key Concepts and Influential Authors | |
| CN112288150A (en) | Boats and ships industry pipe fitting processing management and control integrated system | |
| CN113610594B (en) | Equipment review price data processing method and system | |
| CN115545651A (en) | Engineering construction joint surveying and mapping sharing system | |
| CN110597899B (en) | Project expense management method and system | |
| Luo et al. | Research on Power Market Data Asset Management Framework | |
| CN118052511A (en) | Flow type bill reimbursement information display method, computer device and computer readable storage medium | |
| Lanjun | Study on the reconstruction of accounting information system based on the financial accounting conceptual framework |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |