CN110532534A - The method and apparatus for generating engineering value document - Google Patents
The method and apparatus for generating engineering value document Download PDFInfo
- Publication number
- CN110532534A CN110532534A CN201910799180.7A CN201910799180A CN110532534A CN 110532534 A CN110532534 A CN 110532534A CN 201910799180 A CN201910799180 A CN 201910799180A CN 110532534 A CN110532534 A CN 110532534A
- Authority
- CN
- China
- Prior art keywords
- engineering
- computation rule
- data
- unit
- formula
- 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
- 238000000034 method Methods 0.000 title claims abstract description 57
- 238000004364 calculation method Methods 0.000 claims abstract description 28
- 230000015572 biosynthetic process Effects 0.000 claims description 31
- 238000003786 synthesis reaction Methods 0.000 claims description 31
- 238000004590 computer program Methods 0.000 claims description 17
- 238000003860 storage Methods 0.000 claims description 15
- 238000010276 construction Methods 0.000 claims description 7
- 238000012550 audit Methods 0.000 claims description 4
- 238000009826 distribution Methods 0.000 claims description 4
- 238000005194 fractionation Methods 0.000 claims description 4
- 230000008569 process Effects 0.000 abstract description 12
- 238000004519 manufacturing process Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 12
- 230000006870 function Effects 0.000 description 10
- 239000000463 material Substances 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000003014 reinforcing effect Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000002123 temporal effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
- 238000003466 welding Methods 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biodiversity & Conservation Biology (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Primary Health Care (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of method and apparatus for generating engineering value document, belong to project file process field.It is converted into the formula that report file is capable of identifying processing by receiving the computation rule of listings data and costs associated for defining quotation template, then by computation rule, the relationship generation that summarizes of the formula and quote data that then will convert into summarizes expression formula；Finally partial data is locked, exports quote data, generates quotation template, i.e. engineering value document.The present invention provides the solution that data are made a report on for bidding stage, business personnel can be helped according to the calculation expression in computation rule automatic report generation file, and calculation expression is automatically generated according to data summarization relationship, greatly reduce the time of production report file quotation template；Calculation expression is generated according to computation rule by computer, successfully avoids and accidentally deletes the problems such as changing by mistake.
Description
Technical field
The present invention relates to file process fields, and in particular to the method and dress of valuation file are generated into Construction Cost Industry
It sets.
Background technique
Many real estate enterprises do not have supplier's gate system at present, can not realize online bidding by information-based mode.
Traditional use Excel file quoting model is also easy to produce formula break links, and data have the risk being tampered, and data format is not
It is uniformly not easy to be analyzed, compare.When carrying out bidding, it is short to be faced with the period, the difficulties such as heavy workload for real estate enterprise.It is existing
The mode for using Excel file to offer, it is necessary first to make Excel quotation template and be supplied to supplier and offer, make
It needs operating personnel to expend considerable time and effort in the process and calculation formula is write according to computation rule, this has resulted in people
Power and temporal waste, especially the bidding period is short, heavy workload in the case where seem especially prominent.Due to computational chart
The problems such as being derived from manual compiling up to formula, being easy to produce formula break links, change by mistake, accidentally delete, not only increases operating personnel's
Workload also virtually increases the workload of auditor.
Currently on the market without making a report on the scheme that link solves the above problems for bidding stage data.
Summary of the invention
In view of the above-mentioned drawbacks in the prior art, the present invention provides the methods, devices and systems for generating valuation file.
Specifically, the present invention provides a kind of methods for generating engineering value document, comprising:
Step 1 receives listings data for defining quotation template, and the listings data is relevant to Practical Project point
Subitem information；
Step 2, receive with the computation rule of costs associated, generate computation rule table；The computation rule is by text table
The calculation expression shown, including operator, placeholder and mathematics bracket；
Step 3, the computation rule for receiving step 2 are converted into the formula that report file is capable of identifying processing；
The relationship generation that summarizes of step 4, the formula being converted into according to step 3 and quote data summarizes expression formula；
Step 5 locks partial data, exports quote data, generates quotation template, i.e. engineering value document.
It further, include following step by the method that computation rule is converted into the formula that report file is capable of identifying processing
It is rapid:
Computation rule is split according to operator is calculated, the whole elements obtained after fractionation are stored in a number of characters
Group；
Actual position of the corresponding expense of placeholder in character array in report file is obtained, whole placeholders are replaced
Change corresponding actual position into, the actual position is by row, column coordinate representation；
The whole elements completed in replaced character array are sequentially spliced into calculation expression.
Further, the quote data is arranged to different ranks, generates and converges according to classification summarized manner in step 4
Total expression formula.
Further, the quote data is arranged to following different rank: profession, industry situation, branch and engineering item, first
Several professions are first divided into, several industry situations is further subdivided under each profession, several distributions, each distribution is divided under each industry situation
It is lower to divide several specific engineering items.
Further, quote data summarized manner in step 4 are as follows: professional synthesis conjunction valence is equal to the comprehensive of whole industry situations and closes
The sum of valence, the synthesis conjunction valence of industry situation are equal to the sum of the synthesis conjunction valence of whole branches, and the synthesis conjunction valence of branch is equal to complete under the branch
The sum of the synthesis conjunction valence of portion's engineering item, the synthesis conjunction valence of engineering item are equal to project amount multiplied by the comprehensive unit price of the engineering item.
Further, the report file is Excel file.
Further, by browser receive remote user's input, listings data by defining quotation template and based on
Calculate rule.
The present invention also provides a kind of devices for generating engineering value document, comprising:
Listings data receiving unit, receives the listings data for defining quotation template, and the listings data is and reality
The relevant branch's subitem information of engineering；
Computation rule receiving unit, for receiving and the computation rule of costs associated, generation computation rule table；The calculating
Rule is by the calculation expression of text representation, including oeprator, placeholder and mathematics bracket；
Computation rule converting unit, for the computation rule received to be converted into the public affairs that report file is capable of identifying processing
Formula；
The relationship generation that summarizes of collection unit, formula and quote data for being converted into according to step 3 summarizes expression
Formula；
File generating unit exports quote data, generates quotation template for locking partial data.
The present invention also provides a kind of equipment for generating engineering value document, comprising:
Memory, for storing computer program；
Processor, when for executing computer program the step of the realization such as method of above-mentioned generation engineering quotation file.
The present invention also provides a kind of computer readable storage medium, computer is stored on computer readable storage medium
Program, when computer program is executed by processor the step of the realization such as method of above-mentioned generation engineering quotation file.
The online online pricing system for generating engineering value document is realized the present invention also provides a kind of, the system comprises
Work out bidding inventory, establishment construction budget, establishment four Engineering Settlement, budget and balance auditing units；
The establishment bidding inventory unit is used to be completed on line in bidding stage according to the instruction of user in engineering
Carry out the establishment of bid inventory；
Construction budget unit is worked out for engineering in the budget stage, according to user instructions to complete by valuation platform online
The budget compilation of engineering project；
It works out Engineering Settlement unit to be used in engineering in accounts settling phase, be completed according to user instructions by valuation platform online
Engineering project clearing；
Budget and balance auditing unit is entering the audit stage for engineering, is completed according to user instructions by valuation platform online
Project examination；
Wherein the establishment bidding inventory unit includes:
Listings data receiving unit, receives the listings data for defining quotation template, and the listings data is and reality
The relevant branch's subitem information of engineering；
Computation rule receiving unit, for receiving and the computation rule of costs associated, generation computation rule table；The calculating
Rule is by the calculation expression of text representation, including oeprator, placeholder and mathematics bracket；
Computation rule converting unit, for the computation rule received to be converted into the public affairs that report file is capable of identifying processing
Formula；
The relationship generation that summarizes of collection unit, formula and quote data for being converted into according to step 3 summarizes expression
Formula；
File generating unit exports quote data, generates quotation template, is i.e. engineering is valuated for locking partial data
File.
Further, online pricing system uses B/S structure, receives the clear of the definition quotation template of user by browser
Forms data and computation rule with costs associated.
Compared with prior art, the present invention obtain it is following the utility model has the advantages that
For the traditional mode of currently used report file (such as Microsoft's Excel file) quotation, the present invention is provided
A set of solution made a report on for bidding stage data, can help business personnel according to computation rule automatic report generation
Calculation expression in file, and calculation expression is automatically generated according to data summarization relationship.Generation valuation provided by the invention
The methods, devices and systems of file can automatically generate calculation expression according to computation rule, greatly reduce production report file
The time of quotation template.The present invention generates calculation expression according to computation rule by computer, successfully avoids accidentally to delete and changes by mistake
Problem.
Detailed description of the invention
Fig. 1 is the flow chart of present invention production quotation template；
Fig. 2 is the computation rule exemplary diagram of Civil Specialities part of the present invention expense；
Fig. 3 is that the present invention according to computation rule automatically generates calculation expression flow diagram；
Fig. 4 is the flow chart that placeholder is substituted for actual position in the embodiment of the present invention；
Fig. 5 is the quote data schematic diagram that set membership is had in the embodiment of the present invention.
Specific embodiment
Understand for the ease of those of ordinary skill in the art and implement the application, with reference to the accompanying drawing to the technology of the application
Scheme is clearly and completely described, it is clear that and described embodiment is only some embodiments of the present application, rather than all
Embodiment.Based on the embodiment in the application, those of ordinary skill in the art institute without making creative work
The every other embodiment obtained, shall fall in the protection scope of this application.
Embodiment one:
The embodiment of the present invention one is related to a kind of method for generating engineering value document and a kind of generation engineering value document
Device.
The method of generation engineering value document of the invention can valuate literary by the inclusion of the engineering in computer equipment
Part generating means are realized.
The computer equipment includes that one kind can be automatic to carry out numerical value calculating according to the instruction for being previously set or storing
And/or the electronic equipment of information processing, hardware include but is not limited to microprocessor, specific integrated circuit (ASIC), may be programmed
Gate array (FPGA), digital processing unit (DSP), embedded device etc..The computer equipment also includes the network equipment.Wherein net
Network equipment includes but is not limited to single network server, the server group of multiple network servers composition or is based on cloud computing
The cloud being made of a large amount of hosts or network server of (Cloud Computing)；Wherein, cloud computing is the one of distributed computing
Kind, a super virtual computer consisting of a loosely coupled set of computers.
Preferably, engineering value document generating means of the invention are suitable for being used for cloud system.
Wherein, network locating for the user equipment and the network equipment includes but is not limited to internet, wide area network, metropolitan area
Net, local area network, VPN network etc..
User equipment, the network equipment and network described above be only for example, other are existing or are likely to occur from now on
User equipment, the network equipment and network are such as applicable to the present invention, should also be included within the scope of protection of the present invention, and to draw
It is incorporated herein with mode.
It is provided in this embodiment generate engineering value document device include:
Listings data receiving unit, receives the listings data for defining quotation template, and the listings data is and reality
The relevant branch's subitem information of engineering；
Computation rule receiving unit, for receiving and the computation rule of costs associated, generation computation rule table；The calculating
Rule is by the calculation expression of text representation, including oeprator, placeholder and mathematics bracket；
Computation rule converting unit, for the computation rule received to be converted into the public affairs that report file is capable of identifying processing
Formula；
The relationship generation that summarizes of collection unit, formula and quote data for being converted into according to step 3 summarizes expression
Formula；
File generating unit exports quote data, generates quotation template for locking partial data.
The present embodiment additionally provides a kind of generating device of engineering quotation file, comprising:
Memory, for storing computer program；
Processor, when for executing computer program the step of the realization such as method of above-mentioned generation engineering quotation file.
The present embodiment additionally provides a kind of computer readable storage medium, and calculating is stored on computer readable storage medium
Machine program, when computer program is executed by processor the step of the realization such as method of above-mentioned generation engineering quotation file.
The present embodiment is using Microsoft's Excel file (Microsoft Excel report software file) as report text
Part makes quotation template, and the specific method for generating engineering value document includes the following steps:
Step 1: user connection internet computer or other can network on intelligent terminal, accessed using browser
Online valuation platform, the platform cost of implementation operation are changed online, selection establishment bid checklist module, and new files simultaneously switch to point
The subitem inventory page adds branch, inventory and material list according to engineering practice.
Online valuation platform, or referred to as online pricing system, it is main pre- including establishment bidding inventory, establishment engineering
It calculates, establishment four Engineering Settlement, budget and balance auditing units, solves building trade respectively in each stage project cost of engineering construction
Problem；
Work out bidding inventory unit: engineering can be existed in bidding stage, user by working out bidding checklist module
The establishment of bid inventory is carried out on line；
Work out construction budget unit: in the budget stage, user's engineering can be valuated the establishment work of platform online by us
Journey budget module completes the work of the budget of engineering project；
Work out Engineering Settlement unit: in accounts settling phase, user's engineering can be valuated the establishment work of platform online by us
Journey settlement module completes the work of the clearing of engineering project；
Budget and balance auditing unit: into the audit stage, user can be examined engineering by the budget and balance for platform of valuating online
The examination of core completion engineering.
A variety of implementations are had existed in the prior art in view of online valuation platform, and details are not described herein again.This implementation
The device for the generations engineering value document that example provides can be used as a subsystem of online valuation platform, such as to work out bidding clear
Single unit exists, and also can be used as independent product or system exists.
Step 2: user writes that the profit of bill of quantities (i.e. bid inventory), material tune be poor, tax according to different professions
The computation rule of the expenses such as gold specifies the calculating of the various expenses of bill of quantities under different majors, defines calculation expression
Create-rule.Follow an important principle when defining computation rule: " there can be no repeat for expense category under the same profession
", which, which ensure that, can obtain unique rule according to profession and expense category.The profession includes civil engineering, dress
Repair engineering, Garden Engineering, municipal works, installing engineering etc..Computation rule can pass through placeholder, mathematical operator and bracket group
At expression formula be described, such as administration fee be equal to labour cost add machinery cost, then the computation rule of administration fee is just by people
Placeholder+machinery cost placeholder of expenses of labour forms computation rule: RGF+JXF.For the more figuratively table of bright computation rule
Up to mode, the present embodiment combination Fig. 2 is shown by taking the expense of Civil Specialities part as an example.
Step 3: when export excel quotation template, the profession according to belonging to inventory and expense category determine unique first
Then computation rule carries out computation rule according to operator the calculation expression of generation excel after the operation such as phrase fractionation, replacement
Formula, i.e. Excel formula.Excel formula may include: function, reference, operator and/or constant.Wherein, reference refers at one
Using the data for including in worksheet different piece in formula, or the value of the same cell is used in multiple formula；
Cell in the same book (the i.e. same Excel file) on other worksheets and other books can be quoted (i.e.
Other Excel files) in data.
Step 4: quote data has set membership, in excel quotation template some expenses be need from level to level to
On summarize, such as: have tri- inventories of A1, A2, A3 under A branch, then the synthesis conjunction valence of A branch is equal to the synthesis conjunction valence of A1
The synthesis conjunction valence of the synthesis conjunction valence+A3 of+A2, then needs to be automatically generated according to the set membership of quote data and summarizes expression formula.
Illustrate by taking quote data screenshot Fig. 5 as an example: civil engineering is profession, and small high-rise is industry situation, and reinforced bar engineering is branch,
Screw shell is specific engineering item.
The sum of synthesis conjunction valence=whole industry situation synthesis conjunction valence of profession；Synthesis conjunction valence=whole branch synthesis of industry situation
The sum of conjunction valence；The sum of synthesis conjunction valence=whole inventory synthesis conjunction valence of branch；
The computation rule of comprehensive conjunction valence: comprehensive conjunction valence=project amount × comprehensive unit price.The project amount of each engineering item × its is comprehensive
Close the summation of unit price.
The rule of comprehensive conjunction valence is not limited to the present embodiment provided method, related with the division mode of engineering.For example,
If architectural engineering partitioned project, subdivisional work divided step by step are as follows: partitioned project, sub- partitioned project, subdivisional work, then right
The synthesis conjunction valence rule answered may is that the sum of the comprehensive conjunction valence of the sub- partitioned project of synthesis conjunction valence=whole of partitioned project；Every height
Partitioned project integrates the sum of the comprehensive conjunction valence of conjunction valence=whole subdivisional work；The synthesis conjunction valence of each subdivisional work=whole project institute
It is related to the summation of expense of all categories.
Step 5: the data for not allowing supplier or other unauthorized users to modify of excel table are locked, are prevented
Only data and expression formula are tampered the correctness for guaranteeing data, and quote data export excel is then formed excel quotation mould
Plate.
Embodiment two
The present embodiment further describes in the step of embodiment one three and automatically generates calculation expression according to computation rule
Method.
Computation rule is a kind of calculation expression of character string type, is made of the bracket of operator, placeholder, mathematics；
There are two types of modes for the definition of placeholder:
One is according to the first letter of pinyin of expense category form, such as: expense category be labour cost placeholder should
For RGF；Another kind is customized expense code, and expense code is made of English alphabet.
As shown in figure 3, according to computation rule automatically generate calculation expression method the following steps are included:
Step 301: computation rule is generated according to profession and expense category, and all each datas have professional attributes,
Each expense has affiliated expense category, the profession and expense category of current record is first obtained first, then from computation rule
Unique computation rule is obtained in table.
Computation rule table in the present embodiment is a two-dimensional data table, and each row of tables of data records major name and should
The computation rule and relevant information of all kinds of expenses under profession, the column of tables of data include expense code name, expense title, calculating basis,
Radix explanation, rate, expense category etc..
Step 302: assuming that the calculation expression of inventory set-fee under civil engineering is obtained, the meter of inventory set-fee under civil engineering
Calculating rule is A+B+C+D+E+F, splits according to operator is calculated to computation rule, such a character is obtained after fractionation
Array: [' A', '+', ' B', '+', ' C', '+', ' D', '+', ' E', '+', ' F'].
Step 303: placeholder (A, B, C ...) is substituted for the expense in the actual position of excel by circulation array.
The process of replacement is as shown in Figure 4.Assuming that the position of labour cost A is C2, the position of main material expense B is C3, machinery cost C
Position is C4, the position of auxiliary material expense D is C5, the position of administration fee E is C6, the position of profit F is C7, then now beginning to follow
Ring:
Recycle for the first time: A is substituted for the true of current expense by judging current character for placeholder by current character A
Real position i.e. C2, then present array is [' C2', '+', ' B', '+', ' C', '+', ' D', '+', ' E', '+', '
F']。
Second recycles: current character is+, by judge that current character for arithmetic operator, directly returns to current character,
So present array is [' C2', '+', ' B', '+', ' C', '+', ' D', '+', ' E', '+', ' F'].
………
And so on finally obtain array are as follows: [' C2', '+', ' C3', '+', ' C4', '+', ' C5', '+', ' C6', '
+','C7']。
Step 304: current array being carried out the calculation expression for being spliced to form inventory set-fee under civil engineering are as follows: C2+C3+
C4+C5+C6+C7.
Embodiment three
The present embodiment is related to by summarizing layer by layer, by son and father, the method for calculating the synthesis conjunction valence of parent.
To illustrate that set membership, interception part quote data are as shown in Figure 5 vividerly.By entitled screw shell,
Electroslag pressure welding, III grade of reinforcing bar, the comprehensive conjunction valence of the inventory of I grade of reinforcing bar calculate the synthesis conjunction valence of reinforced bar engineering automatically, similarly calculate
The synthesis conjunction valence of concrete works closes valence by reinforced bar engineering and concrete works closes valence and summarize the comprehensive of calculating small high-rise upwards
Conjunction valence is closed, the synthesis conjunction valence for summarizing to obtain civil engineering is continued up.Summarize layer by layer in this way, by son and father, calculates parent
Comprehensive conjunction valence.If being now to automatically generate the synthesis conjunction valence calculation expression of A branch, circulation template data first passes through father and son
Relationship finds the inventory that father node is A branch, then obtains the comprehensive conjunction valence of the inventory in the position of excel, circulation terminates to return to A
The comprehensive array closing price and setting of all inventories, array under branch are as follows: [' C2', ' C3', ' C4'], finally with "+" number as even
It connects symbol and array is spliced into calculation expression: C2+C3+C4.
Summarize layer by layer in this way, by son and father, calculates the synthesis conjunction valence of parent.Finally calculate total expense of entire engineering
With.
Example IV
The present embodiment is related to the method that the present invention realizes locking data and generates Excel file.
The method of locking data the following steps are included:
Step 501 determines that the data for allowing supplier or other users to modify are arranged according to requirements of the owner；
Step 502 circulation quote data obtains the unit case that every data line allows supplier or other users to modify
Set, circulation complete generate one can planning unit lattice position array: [{ row number: " C ", line number: " 5 " }, and row number: " C ", row
Number: " 8 " } ...]；
Step 503 is using the API of JAVA routine call Apache POI locking table cell, and locking is entirely
The cell of Microsoft Excel file；
Step 504 according to can the API that unlock of position array recursive call POI of planning unit lattice cell is carried out
Unlock.
Generate the implementation method of Excel file:
It obtains first and needs derived quote data, then generated using the API of JAVA routine call Apache POI
Finally by the JAVA API for calling POI to provide Microsoft is written in quote data by Microsoft Excel file
Quotation template is formed in Excel file.
The flow chart and block diagram in the drawings show the method, apparatus and computer journey according to multiple embodiments of the application
The architecture, function and operation in the cards of sequence product.In this regard, each box in flow chart and block diagram can generation
A part of one unit of table, module, section or code, can for realizing the computer of logic function comprising one or more
It executes instruction.It should also be noted that in some implementations as replacements, function marked in the box can also be attached to be different from
The sequence marked in figure occurs.It is also noted that the combination of each box or box in block diagram and flow chart, Ke Yiyong
The dedicated hardware based system of defined function or movement is executed to realize, or can be referred to specialized hardware and computer
The combination of order is realized.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, method, article or equipment for including a series of elements not only includes those elements, and
And further include other elements that are not explicitly listed, or further include for this process, method, article or equipment institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including institute
State in the process, method, article or equipment of element that there is also other identical elements.
For convenience of description, it is divided into various units when description apparatus above with function to describe respectively.Certainly, implementing this
The function of each unit can be realized in the same or multiple software and or hardware when application.
It should be understood by those skilled in the art that, the embodiment of the present invention can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the present invention
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the present invention, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The present invention be referring to according to the method for the embodiment of the present invention, the process of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
The application can describe in the general context of computer-executable instructions executed by a computer, such as program
Module.Generally, program module includes routines performing specific tasks or implementing specific abstract data types, programs, objects, group
Part, data structure etc..The application can also be practiced in a distributed computing environment, in these distributed computing environments, by
Task is executed by the connected remote processing devices of communication network.In a distributed computing environment, program module can be with
In the local and remote computer storage media including storage equipment.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/or
The forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including described want
There is also other identical elements in the process, method of element, commodity or equipment.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for system reality
For applying example, since it is substantially similar to the method embodiment, so being described relatively simple, related place is referring to embodiment of the method
Part explanation.
The above description is only an example of the present application, is not intended to limit this application.For those skilled in the art
For, various changes and changes are possible in this application.All any modifications made within the spirit and principles of the present application are equal
Replacement, improvement etc., should be included within the scope of the claims of this application.
Claims (11)
1. a kind of method for generating engineering value document, characterized by comprising:
Step 1 receives listings data for defining quotation template, and the listings data is branch relevant to Practical Project point
Item information；
Step 2, receive with the computation rule of costs associated, generate computation rule table；The computation rule is by text representation
Calculation expression, including operator, placeholder and mathematics bracket；
Step 3, the computation rule for receiving step 2 are converted into the formula that report file is capable of identifying processing；
The relationship generation that summarizes of step 4, the formula being converted into according to step 3 and quote data summarizes expression formula；
Step 5 locks partial data, exports quote data, generates quotation template, i.e. engineering value document.
2. according to the method described in claim 1, it is characterized by:
By computation rule be converted into report file be capable of identifying processing formula method the following steps are included:
Computation rule is split according to operator is calculated, the whole elements obtained after fractionation are stored in a character array；
Actual position of the corresponding expense of placeholder in character array in report file is obtained, whole placeholders are substituted for
Corresponding actual position, the actual position is by row, column coordinate representation；
The whole elements completed in replaced character array are sequentially spliced into calculation expression.
3. according to the method described in claim 1, it is characterized by:
The quote data is arranged to different ranks, generates in step 4 according to classification summarized manner and summarizes expression formula.
4. according to the method described in claim 3, it is characterized by:
The quote data is arranged to following different rank: profession, industry situation, branch and engineering item are first divided into several
Profession, it is each profession under be further subdivided into several industry situations, several distributions are divided under each industry situation, several tools are divided under each distribution
The engineering item of body.
5. according to the method described in claim 4, it is characterized by:
Quote data summarized manner in step 4 are as follows: professional synthesis conjunction valence is equal to the sum of the synthesis conjunction valence of whole industry situations, industry situation
Comprehensive conjunction valence is equal to the sum of the synthesis conjunction valence of whole branches, and the synthesis conjunction valence of branch is equal to the synthesis of all-work item under the branch
The sum of conjunction valence, the synthesis conjunction valence of engineering item are equal to project amount multiplied by the comprehensive unit price of the engineering item.
6. according to the method described in claim 1, it is characterized by:
Listings data and computation rule that remote user inputs, for defining quotation template are received by browser.
7. a kind of device for generating engineering value document, which is characterized in that described device includes:
Listings data receiving unit, receives the listings data for defining quotation template, and the listings data is and Practical Project
Relevant branch's subitem information；
Computation rule receiving unit, for receiving and the computation rule of costs associated, generation computation rule table；The computation rule
It is by the calculation expression of text representation, including oeprator, placeholder and mathematics bracket；
Computation rule converting unit, for the computation rule received to be converted into the formula that report file is capable of identifying processing；
The relationship generation that summarizes of collection unit, formula and quote data for being converted into according to step 3 summarizes expression formula；
File generating unit exports quote data, generates quotation template for locking partial data.
8. a kind of equipment for generating engineering value document, which is characterized in that the equipment includes:
Memory, for storing computer program；
Processor realizes the method for the generation engineering value document such as one of claim 1-6 when for executing computer program
The step of.
9. a kind of computer readable storage medium, computer program, computer program are stored on computer readable storage medium
The step of engineering value document method is generated as described in one of claim 1-6 is realized when being executed by processor.
10. a kind of online pricing system generates engineering value document for realizing online, it is characterised in that: the online valuation
Including establishment bidding inventory unit, establishment construction budget unit, establishment Engineering Settlement unit, budget and balance auditing unit；
The establishment bidding inventory unit is used to be carried out on line in bidding stage according to the instruction of user completion in engineering
The establishment of bid inventory；
Construction budget unit is worked out for engineering in the budget stage, according to user instructions to complete engineering by valuation platform online
The estimate for a project establishment；
It works out Engineering Settlement unit to be used in engineering in accounts settling phase, engineering is completed by valuation platform online according to user instructions
Project clearing；
Budget and balance auditing unit is entering the audit stage for engineering, completes engineering by valuation platform online according to user instructions
Audit；
Wherein the establishment bidding inventory unit includes:
Listings data receiving unit, receives the listings data for defining quotation template, and the listings data is and Practical Project
Relevant branch's subitem information；
Computation rule receiving unit, for receiving and the computation rule of costs associated, generation computation rule table；The computation rule
It is by the calculation expression of text representation, including oeprator, placeholder and mathematics bracket；
Computation rule converting unit, for the computation rule received to be converted into the formula that report file is capable of identifying processing；
The relationship generation that summarizes of collection unit, formula and quote data for being converted into according to step 3 summarizes expression formula；
File generating unit exports quote data, generates quotation template, i.e. engineering value document for locking partial data.
11. online pricing system according to claim 10, it is characterised in that:
The system uses B/S structure, receives the listings data of the definition quotation template of user by browser and has with expense
The computation rule of pass.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910799180.7A CN110532534A (en) | 2019-08-28 | 2019-08-28 | The method and apparatus for generating engineering value document |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910799180.7A CN110532534A (en) | 2019-08-28 | 2019-08-28 | The method and apparatus for generating engineering value document |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110532534A true CN110532534A (en) | 2019-12-03 |
Family
ID=68664617
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910799180.7A Pending CN110532534A (en) | 2019-08-28 | 2019-08-28 | The method and apparatus for generating engineering value document |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110532534A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111310425A (en) * | 2020-01-22 | 2020-06-19 | 金地（集团）股份有限公司 | System implementation method for list intellectualization and intelligent list system |
| CN111598733A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Method and system for counting progress money per period in progress report cost stage |
| CN112308670A (en) * | 2020-10-30 | 2021-02-02 | 上海东方投资监理有限公司 | Cloud pricing method, system, device and storage medium |
| CN112767040A (en) * | 2021-01-26 | 2021-05-07 | 广联达科技股份有限公司 | Method and device for generating project pricing file, computer equipment and storage medium |
| CN113689207A (en) * | 2021-08-04 | 2021-11-23 | 广联达科技股份有限公司 | Method and device for switching unit price forms and electronic equipment |
| CN115268734A (en) * | 2022-06-09 | 2022-11-01 | 新奥数能科技有限公司 | Quotation generation method, device, equipment and storage medium based on quotation tool |
| CN116188091A (en) * | 2023-05-04 | 2023-05-30 | 品茗科技股份有限公司 | Method, device, equipment and medium for automatic matching unit price reference of cost list |
| CN117575379A (en) * | 2023-10-25 | 2024-02-20 | 青矩技术股份有限公司 | Manufacturing cost index generation method, device, equipment and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140089247A1 (en) * | 2012-09-21 | 2014-03-27 | Sas Institute Inc. | Fast Binary Rule Extraction for Large Scale Text Data |
| CN106557857A (en) * | 2015-09-30 | 2017-04-05 | 国家电网公司 | Project of transmitting and converting electricity amount bill compilation and pricing method |
| CN106648662A (en) * | 2016-12-23 | 2017-05-10 | 江西博微新技术有限公司 | Engineering cost calculation description language BCL-based report generation device and generation method |
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | The editing of electricity power engineering cost and inventory application system based on working drawing budget management |
-
2019
- 2019-08-28 CN CN201910799180.7A patent/CN110532534A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140089247A1 (en) * | 2012-09-21 | 2014-03-27 | Sas Institute Inc. | Fast Binary Rule Extraction for Large Scale Text Data |
| CN106557857A (en) * | 2015-09-30 | 2017-04-05 | 国家电网公司 | Project of transmitting and converting electricity amount bill compilation and pricing method |
| CN106648662A (en) * | 2016-12-23 | 2017-05-10 | 江西博微新技术有限公司 | Engineering cost calculation description language BCL-based report generation device and generation method |
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | The editing of electricity power engineering cost and inventory application system based on working drawing budget management |
Non-Patent Citations (1)
| Title |
|---|
| 恒企教育财经研发部: "初级财务数据分析", 中国商业出版社, pages: 0191 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111310425A (en) * | 2020-01-22 | 2020-06-19 | 金地（集团）股份有限公司 | System implementation method for list intellectualization and intelligent list system |
| CN111598733A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Method and system for counting progress money per period in progress report cost stage |
| CN112308670A (en) * | 2020-10-30 | 2021-02-02 | 上海东方投资监理有限公司 | Cloud pricing method, system, device and storage medium |
| CN112767040A (en) * | 2021-01-26 | 2021-05-07 | 广联达科技股份有限公司 | Method and device for generating project pricing file, computer equipment and storage medium |
| CN113689207A (en) * | 2021-08-04 | 2021-11-23 | 广联达科技股份有限公司 | Method and device for switching unit price forms and electronic equipment |
| CN113689207B (en) * | 2021-08-04 | 2024-04-26 | 广联达科技股份有限公司 | Monovalent form switching method and device and electronic equipment |
| CN115268734A (en) * | 2022-06-09 | 2022-11-01 | 新奥数能科技有限公司 | Quotation generation method, device, equipment and storage medium based on quotation tool |
| CN116188091A (en) * | 2023-05-04 | 2023-05-30 | 品茗科技股份有限公司 | Method, device, equipment and medium for automatic matching unit price reference of cost list |
| CN117575379A (en) * | 2023-10-25 | 2024-02-20 | 青矩技术股份有限公司 | Manufacturing cost index generation method, device, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110532534A (en) | The method and apparatus for generating engineering value document | |
| Nagalingam et al. | Building information modelling and future quantity surveyor's practice in Sri Lankan construction industry | |
| US20180341896A1 (en) | Enterprise Construction Project Management and Business Integration System | |
| Halttula et al. | Managing data flows in infrastructure projects: the lifecycle process model | |
| Tavakolan et al. | Developing an optimization financing cost-scheduling trade-off model in construction project | |
| Kelly et al. | Focus issue on legacy information systems and business process change: a business perspective of legacy information systems | |
| Lee et al. | Stochastic project financing analysis system for construction | |
| Yang et al. | Computerizing ICBF method for schedule delay analysis | |
| Kenny | The role of agricultural sector performance on economic growth in Nigeria | |
| US8392313B2 (en) | Financial options system and method | |
| Kehily et al. | Leveraging whole life cycle costs when utilising building information modelling technologies | |
| Marques et al. | A tutorial for modeling real options lattices from project cash flows | |
| Sadiah et al. | Design of the Inventory Application of CV Diva Karya Mandiri Using Rad (Rapid Application Development) | |
| Smith, GL, Pearson-Taylor, J., Anderson, DC & Marsh | Project valuation, capital investment and strategic alignment-tools and techniques at Anglo Platinum | |
| Adetayo et al. | A scientometric review of bim in facility management research | |
| US20200410560A1 (en) | Prefilled Owner Invoices | |
| CN114037304A (en) | Data collection method, equipment and medium for cost data | |
| McCowan et al. | Decision support system to evaluate and compare concession options | |
| Gharehbaghi | On-Site engineering information systems (EIS) for building and construction projects | |
| Nikitina et al. | Comparative Analysis of Project Management Software Products | |
| Le et al. | BIM-INTEGRATED SYSTEM: A SUCCESSFUL ALTERNATIVE FOR ESTIMATING CASH FLOW IN BUILDING PROJECTS | |
| Klijn et al. | Event Knowledge Graphs for Auditing: A Case Study | |
| JP7554788B2 (en) | Business support device, business support method, and business support program | |
| Wibowo et al. | DESIGN OF CHURCH FINANCIAL INFORMATION SYSTEM WITH ACCOUNTING STANDARDS USING RAPID APPLICATION DEVELOPMENT METHOD (RAD) | |
| Bogdanovich et al. | Development of information accounting system sunder globalization of economy |
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: 20191203 |
|
| RJ01 | Rejection of invention patent application after publication |