CN112163908A

CN112163908A - Revit-based calculation and pricing unified processing method

Info

Publication number: CN112163908A
Application number: CN202011185751.7A
Authority: CN
Inventors: 不公告发明人
Original assignee: Individual
Current assignee: Individual
Priority date: 2020-10-30
Filing date: 2020-10-30
Publication date: 2021-01-01

Abstract

The invention aims to provide a Revit-based electromechanical installation engineering calculation and pricing method, which can simultaneously realize calculation and pricing by taking Revit as a platform.

Description

Revit-based calculation and pricing unified processing method

Technical Field

The invention belongs to the field of construction cost of installation projects of industrial and civil building projects, and relates to a method for uniformly processing construction project calculation and pricing based on Revit.

Background

The engineering cost software used in the market at present mostly divides the calculated amount and the pricing into two sets of software, and the calculated amount is firstly completed on the calculated amount software and then the pricing software is used for pricing to finish the engineering cost work. Although such software development is well established, with the development of BIM technology, a new perspective is brought to the engineering cost work. Revit is used as a powerful BIM application software, and the virtual construction of the Revit plays an incomparable role in the planning, implementation and operation and maintenance methods of the building industry. Therefore, the invention takes Revit as a link to complete the calculation and pricing work of the electromechanical installation professional on the platform.

Disclosure of Invention

The technical scheme adopted by the invention is an electromechanical installation engineering calculation and pricing method based on Revit, and specifically comprises the following steps:

step 1, model creation.

The model created by this step incorporates project parameters not available in the Revit system to facilitate filtering screening.

And 2, carrying out engineering quantity statistics. The steps are divided into the following two cases:

(1) the situation of engineering quantity can be counted by creating a model.

The components involved in this case are pipes, air ducts, bridges, conduits, sleeves, hangers and corresponding attachments.

(2) The situation of engineering quantity can be counted without creating a model.

This condition includes, block terminal, lamps and lanterns, terminal box, water pump, wind gap, fan, sanitary wares etc. are convenient for draw the primitive of quantity in the CAD drawing.

And 3, exporting a material list.

The detail list produced in the step is compiled in advance by using a C # programming language on a Visual intuod platform and is summarized according with the rule of the consumption quota of the installation project, so that the accuracy of the project amount is ensured.

And 4, pricing.

The step is also to compile the operation rules of the engineering quantity and the installation engineering consumption quota and the human-machine price list counted in the step 3 by using a C # programming language.

And 5, taking the fee.

In the step, a DataGrid window after the valuation is summarized according to the step 4 can be popped up, and an operator can perform increasing, decreasing and changing operations according to actual conditions.

And 6, generating a manufacturing cost information related table.

Drawings

FIG. 1 is a schematic view of a pipe self-building family and a pipeline connection mode;

FIG. 2 a project volume entry interface;

FIG. 3 is a loop information entry interface;

FIG. 4 creates key-codes for model lines;

FIG. 5 is a line pattern of a created model line;

FIG. 6 shows the self-construction project parameters of the conduit;

FIG. 7 is a setting interface before invoicing;

FIG. 8 is a pre-pricing material preview and action interface;

FIG. 9 a fare collection operator interface;

fig. 10 is a flow chart.

Detailed description of the invention

The present invention will be described in detail with reference to the following embodiments, and fig. 10 is a flowchart.

The invention relates to a Revit-based electromechanical installation engineering calculation and pricing method, which specifically comprises the following steps:

step 1, model creation. In this step, the created model name needs to be set in advance to a name that coincides with the quota item of the engineering consumption quota. For a pipe with different connection modes (such as a fire-fighting galvanized pipe), screening is needed through programming and is set by an operator in advance, and particularly, see the attached figure 7. In order to be able to count the created model engineering quantities according to the calculation rules, the family of pipes needs to be modified. Specifically, two example parameters of the size and the length corresponding to the pipe are set for the water and electric heating pipe, so that the size and the length of the pipe and the pipe can be obtained simultaneously through IExternalCommand in RevitAPI by utilizing the Name attribute under the Definition method in the Parameter type, the length of the pipe can be further calculated into the length of the pipe, and the pipe engineering quantity can be counted according to the calculation rule.

The step also has a key arrangement, namely, the self-building family is connected with the components one by one in the layout system configuration through an editing type, and the specific effect is shown in the attached figure 1.

Step 2, statistics of the engineering quantities of the pipes has been elaborated in step 1, the step mainly illustrates the engineering quantity statistics of the components without the need of creating the model, firstly, a button needs to be added on a Revit additional module interface through IExternalapplication in RevitAPI, and a DataGrid window capable of inputting the engineering quantities is popped up after the button is clicked, as shown in the attached figure 2.

The figure shows an electrical engineering quantity recording interface (similar to water supply and drainage and ventilation professions, which is not described in detail). The interface is divided into two parts, the left side is a corresponding material name, quantity and quota number column which needs to be input, and the right side is a quota number. That is, the engineering quantity is not only counted here, but also hooked with the corresponding quota, so as to be ready for later pricing.

As shown in fig. 2, after the engineering volume is recorded, the right export of the point will import the recorded information into an excel table created by the NPOI plugin, where the excel table functions as a database.

For further explanation of the step 2, as the wiring pipe, the wire and the cable of the electrical specialty do not influence the integration of the pipeline of the electromechanical installation specialty, the invention creatively utilizes the model line of Revit to replace the wiring pipe, the wire and the cable.

The specific implementation is as follows, as shown in fig. 3. This is a loop information entry interface that aggregates information into the loop information of the electrical system. After the loop information is recorded and exported from the upper right corner of the attached drawing 3, the corresponding model line is created by taking each line information in the drawing as a name, and the code is shown in the attached drawing 4. The model line created is shown in fig. 5.

Thus, the function of Revit to create model lines is used to represent conduit, wire and cable.

In addition, the electric wires and cables sometimes cannot be threaded through the pipes, or an operator unit does not completely receive all the work contents of the threading pipes, the electric wires and the cables. The invention creatively solves the function of what material the drawn model line represents.

The specific implementation is as follows, the default model line in the program rule represents the threading pipe, the electric wire and the cable, and the corresponding specification model and the corresponding laying mode can be distinguished by the model line name (namely, the loop information). If the model line is to represent other contents, the Iexternalapplication in RevitAPI needs to be started to add another button on the interface of the Revit additional module, the button is used for converting the model line into a threading pipe with loop information in a click or frame selection mode, and the threading pipe is provided with required item parameters in advance, so that the material distinguishing function can be completed by checking the item parameters. These project parameters also include the book coefficients specified in the installation work consumption quota. Also, the installation location or other contents can be distinguished. Different installation locations or related contents correspond to different quotum coefficients, which are also set in advance in the program. Fig. 6 is a partial project parameter.

And 3, exporting the detail list. According to the steps and the programming logic, materials of different specialties are gathered and counted into different excel tables. The specification has been programmed to process the coefficients specified by the consumption quota according to the project parameters of the model, all to ensure that the statistics of the engineering quantities conform to the calculation rules.

And 4, pricing. The interfaces of fig. 7 and 8 would pop up in sequence before this step begins, depending on the programming logic design. FIG. 7 is a key content setup interface including labor costs, setup complete, point continue, and pop-up FIG. 8. The interface lists all the materials in the model and the manual input according to the profession, so that an operator can select the contents of the project quantity to be extracted independently. For example, if the operator only constructs the fire-fighting single item, he can delete other contents which are not constructed by the operator by double-clicking the deletion column shown in fig. 8, so that the goal is achieved. In the interface of fig. 8, a NULL line is shown in red italics to indicate that the material of the line lacks a corresponding rating file (explained in more detail below), and the operator needs to check the created model to see if the primitive names are set according to the rating names.

After the interface selection of fig. 8 is complete, click on the top right set quota. The invention enters into the pricing link.

The specific operating logic is as follows, and the NPOI plug-in is utilized in the programming, so that excel is used as a database. The excel database comprises the list and the quota file, wherein the quota file is the installation project consumption quota which is issued by a government executive part and is the operation basis of all pricing software. The quota of the installation project consumption can be downloaded in an official network of a governing department and then converted into an excel file in a corresponding format, so that the quota file cited by the invention is formed, and in addition, the quota file also comprises a manual material machine shift price list. The invention firstly inputs the project quantity specification of the extracted material according to the model or the setting rule, and then the specification, the rating file and the price list are operated. Thus, pricing is completed.

And 5, taking the fee. After the invoicing is completed, a budget table is generated, the table format is set through the IcellStyle of the NPOI, and according to the generated corresponding table, the attached figure 9, namely the fee-taking table, is popped up. The operator can operate the fee-taking operation by himself. After the fee is taken, clicking to determine, and then completing the whole pricing work of the installation project.

While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims

1. The method for uniformly processing the calculated amount and the pricing based on Revit is characterized by comprising the following steps of:

by creating a self-built pipe fitting family, adding two example parameters of size and length for the pipe fitting family, and hanging the pipe fitting family with the pipe, the accurate engineering quantity which accords with the installation calculation rule can be calculated.

2. And the hooking of the primitives and the rating items is realized by a method of defining the primitive names to be consistent with the rating item names of the engineering consumption rating.

3. By inputting the engineering quantity and the quota number, the matching of the engineering quantity and the quota item can be completed without creating a model.

4. By creating project parameters for the primitives, various coefficients of the project consumption quota requirements can be set for the project volume.

5. The method for unified Revit-based accounting and pricing treatment according to claim 1, wherein Revit's model lines are used instead of threading tubes, wires and cables.

6. The expression of various materials and installation positions is realized by converting the model line into a line pipe, so that different engineering consumption quota coefficients are matched.

7. The method of claim 1, wherein the operator can select the quota item to be collected, process the collection content, and automatically generate various tables required by the construction cost.