CC BY
3
THE BIM-BASED AUTOMATED COST COMPUTATION AND VISUALIZATION OF COST DATA
A. Hazra * S. Bose*
A. Chakraborty** S. Qasemi ** M. A. A. Obeid ** E. Behruz**
* Narula Institute of Technology, Kolkata
** Peoples' Friendship University of Russia (RUDN University), Moscow
Abstract
Material quantity take-off is frequently used in the construction industry to enhance efficacy of schedule and cost estimates, starting with the early stages of design and continuing through the building process. Identifying things and their connections with drawings, gathering data for computing units of measurement such as areas, volumes are all part of the quantity take-off method. BIM (Building information Modeling), on the other hand, make material quantity take-off more exact and quicker which in turn cut expenses. The paper focuses to compute the total cost of each element of the BIM model, as well as the total cost of the complete BIM model using REVIT. The entire cost data of the BIM model then exported to Microsoft Excel, and to visualize the cost data Microsoft Power BI application has been used. With the use of the developed dynamo script, we can analyses the cost data with element category. For example, if we want to know how much the structural, architectural, or interior portions would cost, it can easily compute it using this script and visualize it using Power BI. We may also assess materials depending on their cost and choose the most cost-effective alternative. Construction estimating is a large process with several procedures and estimation sections, as well as a large number of things that must be computed minutely, which can result in numerous inaccuracies. It will save a lot of time and avoid human error if we can compute item costs using the BIM model.
The Keywords
Building information modeling (BIM), BIM-based cost analysis of element quantity, Dynamo Script, Cost analysis
Date of receipt in edition
05.12.2022
Date of acceptance for printing
14.12.2022
Introduction
In terms of building procedures, planning, coordination, and the use of information technology tools, the construction industry has changed dramatically over the last couple of decades [1]. There have been several modifications which starts from the ways of preparing different papers necessary for a tendering procedure
of a building project to completion. Bill of quantities generation is still a time-consuming task that is prone to significant degrees of mistake if done manually [2, 3]. The cost of materials, labor, and parts is included in the bill of quantities (BOQ). For the tendering process, a bill of quantities is generated together with other documentation. It's essentially a cost estimate for a project. Because of the many assumptions used while calculating the bill of materials, they exhibit a lot of fluctuation with the actual cost of the project. The overall quantity of material, labor, and parts utilized in the building project is listed in the bill of quantities. Along with the tender documentation, a bill of quantities is created. It provides an estimate of the entire project cost as well as the total quantities of materials necessary for the project. Traditionally, manual calculations are used to create bill of quantities [4]. The BOQ document is manually computed and includes all contents in the usual format. The preparation of a BOQ document is a time-consuming task that takes up a significant amount of time prior to the tendering process. The amount of inaccuracy in bill of quantities calculations is considerable [5]. When any aspect of the project work changes, the bill of quantities must be rechecked and recalculated. Changes in construction activities that occur after the project is completed may not be accounted for in the computed bill of quantities. The traditional quantity take-off technique is less dependable, precise, and time-consuming than quantity take-off based on building information modeling (BIM) [6]. The quality of BIM models, on the other hand, has an impact on the quality of BIM-based quantity take-off. The study is focused on drywalls, which are made up of wall framings and panels. Contractors and subcontractors cannot execute quantity take-off for purchasing materials if BIM models from the design phases do not include wall framing models [7]. In the building phase, developing wall framing models on a tight timeline is time-consuming, costly, and error-prone. Increased geometries in a BIM model delay software performance as well. As a result of this study, an automated approach for determining wall framing quantities from drywalls in a BIM model is provided.
BIM (Building Information Modeling) it is utilized for scheduling and cost computation, quantity take-off (QTO) is an essential aspect of building projects. Obtaining precise QTOs from 2D conventional drawings, on the other hand, is time-consuming and tiresome [8]. As a result, the usage of BIM for QTO is growing. The correct, automated estimation of formwork areas from BIM, according to literature, is still a challenge. This is mostly due to a lack of modelling norms, processes, and categorization, as well as modelling faults such as overlapping structural parts and BIM software constraints [9]. It's vital to remember that QTO is required at various stages of the design and building process, depending on the requirements and information available. Furthermore, the bulk of BIM technologies do not offer automated formwork production, despite the fact that it is a time-consuming job that is required for construction phase planning, visualization, and interference check [10].
Building Information Modeling (BIM)-based quantity take-off is a quicker and more reliable way than traditional 2D-based quantity take-off. However, the accuracy of the derived numbers is influenced by the quality of BIM models. Extracted amounts deviate due to incomplete information and ineffective modelling methodologies. Because compound elements, like as walls and floors, comprise many material layers of varying sizes, this is always a concern [11]. Each compound element layer, which is made up of a core layer and additional layers, must be produced according to the real structure in order to acquire precise amount take-offs of these layers. This is a time-consuming and error-prone solution, though. Furthermore, if a model's design is not finished, it may be difficult to alter it in the future. Using information from BIM-based conflict detection to delete excess amounts and add missing quantities, this study presents a method to increase the accuracy of extracted quantities of compound elements from incomplete or erroneous BIM models. Accurate material quantities may be provided via the BIM process, and time spent editing BIM models is reduced. It can also be used on other construction elements that have similar problems [12].
The technique of quantity take-off has been transformed by Building Information Modeling (BIM), a digital modelling approach that represents geometric and semantic information of a facility. By extracting
z
M
O -l M
D CD
I-iu
w is § S
W
(C ■u 3
a £
tt
§8
* o < °
I TJ
u <u
w +J
if ro
mi O
O (Q
00 -a
w 8 ro
S
*
N 2
< "H X 00
■ <u
< r.
geometric data and semantic features of each architectural element from BIM models, quantity may be measured automatically. This process is known as BIM-based quantity take-off, and the quantities retrieved may be insufficient or wrong if the BIM model is incomplete or incorrect [13]. A BIM model that is as similar to the actual building as feasible should be constructed in order to achieve accurate numbers. In practice, a BIM model's detail is generated during the design and construction phases. For quantity take-off and cost estimate, the BIM model from the design phases must usually be verified and changed, or even generated [14]. This is due to the fact that the BIM model created by the design teams during the design process may not contain fully detailed architectural features. Furthermore, depending on the modelling technique, the amounts may be minimal or excessive.
The major goal of this study is to devise a strategy for improving the accuracy of different element quantities derived from incomplete or erroneous BIM models. The suggested technique can cut modelling or editing time in half, resulting in better BIM-based quantity take-off and cost estimating results [15]. Without modifying the BIM model, this method automatically removes excess quantities of compound components that overlap with other elements and calculates the amounts of each layer of a compound element with a separate dimension. This approach is useful during the design development phase, when a cost estimate is required for design appraisal and decision-making [16]. This approach may also be used to develop a quick and precise bill of quantities for tendering after the design is complete. Architectural walls and floors, which are significant architectural components, are the main compound elements in this study. The proposed technique was based on the authors' prior research; however, it was expanded by applying the basic concept to a different building element category, architectural floors. The computation methods have also been updated. For example, instead of requiring user input, the algorithms may now divide and arrange values based on element kinds or room names, and the ceiling height in the computation is now automatically assigned [17]. The BIM software used in this research is Autodesk Revit 2020, Dynamo (visual programming extension in Revit), Microsoft Power BI and the prototype system is developed in Revit 2020, a visual programming extension in Revit. The research begins with a literature review of related research. Subsequently, the inaccuracy of BIM-based quantity takes off for compound elements is explained in detail. This article uses Revit to calculate the total cost of each BIM model piece as well as the overall cost of the whole BIM model. The whole cost of the BIM model will be exported to Microsoft Excel, and the cost data will be shown using the Microsoft Power BI tool. We may analyse the cost data using the items category using the dynamo script. For example, if we want to know how much the structural, architectural, or interior components would cost, we can use this script to simply calculate it and visualize it using Power BI. We may also evaluate materials based on their cost and select the most cost-effective option [18, 19].
Description of the proposed method
Building model elements, such as walls, columns, beams, floors, doors, and windows, are loaded from a BIM model to the system using dynamo programming application in our BIM-based cost calculating of quantities.
The building model elements should have at least LOD 300 (Level of Development as per industrial specification), with correct size, form, orientation, and placement, as well as the necessary data and parameters such as description, unit cost, cost or element group, and take-off unit for accurate computation [20].
The algorithms compute the overall cost of each element by automatically generating volume and area from the imported building model parts. The application then generates a Microsoft Excel output with the element's type, category, description, take-off unit, unit cost rate, and total cost.
The process of BIM-based cost calculating of quantities consists of three major processes.
Process 1:
Area and volume are generated from a BIM model, with the elements picked from the BIM model. The overall area and volume of any element, such as a wall, floor, beam, column, or foundation are calculated using the dynamo program itself as shown in the fig 1. We put the unit cost of each element in their description, so each element knows its unit cost [21]. As a result, the dynamo program determines the overall cost of each element by multiplying the unit cost by the area and volume of the element as shown in the fig 2.
The cost computation dynamo script is depicted in the diagram below.
Take Elements in Active View
Target Element based Parameter
Oefine Parameter t»y Code Block
Filter out •"Null" Value from Study Objects
Target Cost Parameter
Fig. 1. Cost Computation, Dynamo Script flow Chart one (Process-1)
Match Corresponding
Indices with corresponding parameter name
Divide Original Elements with Equivalent Deviser
Apply with
Cost Parameter Object
True & Correct The Quantities to Multiply
Get Elements Cost Parameters
Generates Cost of Each Objects
R^mqve "Null"
Resuïts bv Function Applv
Target Cast Units — "m2, m3, im,"
Multiply With Cost Rate Parameter
Replace "Null" Values
z
M Û -I M
D CD
Fig. 2. Cost Computation, Dynamo Script flow Chart two (Process-1)
I-iu
Round The ■
Set The Cost
Uniform & Even ■ of The Object s.
Target Cost Parartwter, "Cost Itemized"
Fig. 3. Cost Computation, Dynamo Script flow Chart three (Process-1)
Process 2:
We'll export the total cost schedule to Microsoft Excel after establishing the total cost of each element. The schedule has been divided into the following sections: item cat-egory, cost group, description, unit cost, take-off rate, and total cost [22]. as shown in the fig 3. Item category defines its item element, cost group defines its function (ar-chitecture, structure, or interior), description defines the model description, unit cost defines the unit cost of the element to be constructed, take-off rate defines its unit, and total cost defines the total cost of that element to be constructed as shown in the fig 4. The flow chart below depicts the visual programming process as a whole.
Sc
W Ü $ g
00
fc
tt O
(C 3
a £
cû
* o < °
I TJ
u <u
w +J
if ro <A É mi O
O (Q
00 -a
«¡8
S
* ¿
N S
< "H X 00
■ <u
< c
Elements Type ■ Proceed to Various Parameters ■
& Cost Rate ■ ■
Prepare Big List for Excel
Remove Objects that don't have Cost Rate
Bring "Cost Itemized"
Get Cost Value
Filter Out Nuil or Emptv Value
Target Parameter "Cost Group"
Fig. 4. Cost Data Export, Dynamo Script flow Chart one (Process-2)
Apply Longest
Lacing of Each m
List of
Parameters m
Generates Values per Element for the list or Parameters
Transpose into Lists
Bring Items to Front to End
Add List Select Excel Choose File ■
Header ■ Sheet Path
Fig. 5. Cost Data Export, Dynamo Script flow Chart two (Process-2)
Process 3:
Microsoft Power BI is a business intelligence tool that helps companies/ indi-viduals to identify insights in their data. Connecting different data sources, transform-ing and cleaning the data into a data model, and creating charts or graphs to visualize the data are all possible with Power BI. To further visualize the cost data, we are utilizing the Power BI tool.
The total cost of the BIM model will be exported to Microsoft Excel and shown using the Microsoft Power BI tool. Using Microsoft Power BI tool, we can analyze the cost data by customize with the appropriate templates. For instance, if we want to know how much structural, architectural, or interior components would cost, if we just want to view the total structural costs, if we may check either the structural foundation cost or the entire cost of the column or we may calculate the total cost of the exterior wall or tiles, all of these cost data can be categorized and visualize using power BI. We may also compare materials by price and choose the most cost-effective solution. As a result, we may use the Power BI tool to visualize the cost data and make decisions based on our construction budget.
Total Cost by Cos! Group
2M
Total Cost by Cost Group
ZW
Cost Group v
□ Architecture D Interior
□ Structure
26106
Unit Cost
1751892
Total Cost
Category
□ Ceilings
□ Floors Structural Columns
□ Structural Foundations
□ Structural Framing
□ Walls
Cod Group
# Structure
fe&Mfci
Description
Q Bathroom Floor Tiles
□ Bathroom Wall Tiles D Bedroom Wooden Tile Q Column
□ Curtain Wall
□ Exterior Wall
CD Ground Floor Base/ Plinth Q Hall Room Tiles/Ceramic White Q Internal Ceiling O Internal/ Partition Wall
□ Lint en Beam
□ Main Beam O Plinth Beam
□ Rool Slab
D Tapered Foundation
Cost Group Category Description Unit Cost Total Cost
Interior Ceihng» internal Ceiling ao rrm
Interior floors Bathroom Floor Tries 40 4511
Interior Floors Bedroom Wooden Tile 40 10000
Intenor floors Hall Room Tilev C«r»m< White 40 24556
Structure floors Ground Floor Bj»«/ Plinth 90 17700?
Structure floors Roof Slab 423 2BS4S2
Structure Structural Columns Cofcimn 423 94850
Structure Structural Foundations Tapered Foundation 5Q0 697472
Structure S*ruCM*1 framing Unien Beam 490 27850
Structure Structural framing Main Beam 400 S4710
Structure Structural Framing Plmtti Beam 490 78844
Architecture Wails Curtwn Wall 240 39370
Architecture Walls Êxtenor Wall 107 14SI 25
Architecture Walls Internal/ Partition Wall 64 2318S
Interior Walls Bathroom WaiTiies 40 10940
Totol 1751892
Fig. 6. Cost Data Diagram using Power BI
The prototype system development
Fig. 7. BIM Model (LOD 300)
For this testing we have taken a small house (38' x 29') with consisting of 1 master bedroom, 1 toilet and attached kitchen / dining / drawing hall. In this building we have used different types of doors, window, curtain wall, floor tile etc. This building, as structural members, consists of tapered footing, column, Plinth beam, second beam, main beam, structural slab. Figures 8 and 9 depict aspects of a BIM model, such as structural, architecture, and inte-rior elements. The components are shown in the diagram below.
ID Z
M Û -I M
D
CÛ
I-iu
M
Z iu
w ,0
$ o (À
■a c
fc
tt O
(C 3
a £
a
2 ti
* o < °
I TJ
u <u
w +J
if ro <A É mi o
O (Q
00 -a
«¡8
S
* ¿
N S
< "H X 00
■ <u
< r.
Fig. 8. Architectural and Interior elements
Fig. 9. Structural elements-
Process 1: Cost Computation of the BIM Model using Dynamo Script
We will compute the total cost of each part as well as the total cost of the entire BIM model, and this is calculated using Revit and Dynamo.
We have created 3 parameters for this cost analysis,
• Cost Group (Type Parameter), it signifies the type of element (Architecture / Struc-ture / Interior).
• Take-off Rate (Type Parameter), it signifies the unit in (SF / CF).
• Total Cost (Instance Parameter), it signifies the total cost in Rs.
Fig. 10. Project Parameters
We put in the Cost Group, Take-off Rate, description, and Unit Cost once we've created the parameters. Total cost = steel cost + cement cost + sand cost + aggregate cost + labor & shuttering cost, has been used to compute the unit cost.
Fig. 11. Project Setup Description / Type Properties
We'll use dynamo script to compute the overall cost of the BIM model after setting the parameters and their values.
Process 2: Export the Cost Data using Dynamo Script
After determining the total cost of each part, we'll export the entire cost schedule to Microsoft Excel. The following components make up the schedule: item category, cost group, description, unit cost, take-off rate, and
z
M Û -I M
D CD
I-iu
Sc
W Ü
S S
W
(C 3
a £
tt
§8
* o < °
I TJ
u <u
w +J
if ro
mi O
O (Q
00 -a
«¡8
S
*
N S
< "H
X
■ <u
< c
total cost. Item category specifies the item element, cost group specifies the function (architecture, structure, or interior), description specifies the model description, unit cost specifies the unit cost of the element to be constructed, take-off rate specifies the unit, and total cost specifies the total cost of the ele-ment to be constructed.
We must select the path of the excel file in the Dynamo script's "File Path" before ex-tracting the cost data (fig. 12).
To extract the data from Revit in Excel form after choosing the Excel file location, click the RUN button on the Dynamo script (fig. 13), because the data is so large, fig. 13 is a sample picture of the excel data.
Fig. 12. File path selection in dynamo script
1 Cost Group Desçrétiçfï Unit Cost Rate Total Cost
z Uih AfchtecH*» EsAwior Wal 107 SF 36775
3 Wak Architeoiiae Exterior Wal 107 SF 27581
4 Wats Architediae Exterior Wal 107 SF 35527
5 Wak Architec*ije Intemali Partition Wal 64 SF 45B7
6 Wak Afdweona* Internal^ Partition Wal 64 SF 4888
7 Wak Ardu* Internal/ Partition Wal 64 SF 6679
8 Wak Architecuae Internal/ Partition Wal 64 SF 7031
9 Wak AiehlHMt Exterior Wal 107 SF 27581
» Wak Archneotta* Extwlor Wal 107 SF 1907
n Wak Aiet-rteeUae Exterior Wal 107 SF 14ÎI5
12 Wak Ardwecttae Emetlor Wal 107 SF 1633
o Wak fir ctaecnae Curtain Wal 240 SF 13685
M Wak Archie©"*» Curtain Wal 240 SF 13685
15 Floors Structiae Grow-d Floor Baser Pinth 60 CF 177O07
% Snuduial CohMTOi Structi*e Co**m 423 CF 5832
1? SttucMial Colurms Structiae Co4*m 423 CF 5832
W S"uc*w«J Coftami Structiae Column 423 CF 5832
19 Sftuctuial Colianns Stivcti*e Column 423 CF 5832
20 Sttuctuial CoJiems Structiae Column 423 CF 5832
21 Stiucttaal Coli*rms Stiuoti*e Column 423 CF 5832
22 SuuCluial Columi Stiueti*» Column 423 CF 5832
23 Stiuctual Columns Structure Column 423 CF 5832
24 Sbucttaal Colianns Structure Column 423 CF 5832
25 Suuduial Columns Stiucture Cokanr 423 CF 5832
2S Suuctuial Columns Structura Column 423 CF 5832
27 Suuetuial Coldmt Structue Column 423 CF 5832
28 Suuctuial Columns Struct t*e Column 423 CF 5832
23 Suuctuial Columns Stiucture Column 423 CF 6616
» SbuOtunl Columns Struct«*» Column 423 CF 5832
»1 Suuetuial Columns Structure Column 423 CF 6616
Suucw* at Framing Structure PlnthBeam 430 CF 0355
33 5oudv*aJ Framing Struct i*e PlirthBearn 430 CF 11140
34 Snuduial Fraimng Struct«*» Plinth Beam 430 CF 8355
33 Stiucmal Framing Structure Plinth Beam 430 CF 1TI40
W Stiuduial Framing Structi*e PlrthBeam 430 CF 8571
37 Sttuctuiat Framing Stoic ti* 9 Plnth Beam 430 CF 8571
W Sliuctuiai Framing Stivcti*» Plinth Beam 430 CF 11356
» Sr«MC»uial Framing Structu» Plinth Beam 430 CF 11356
40 Stiuctual Framing Struct!*» Lint en Beam 430 CF S355
41 Structuial Framing Stiucti*e Lint en Beam 430 CF 8355
42 SuutMutal Framing Stiucture Lint en Beam 490 CF ÎÎ140
43 SttuCtuial Framing Structure Main Beam 400 CF 6350
44 SbucluiW Framing Stiucture Mam Bean 400 CF 7188
45 Stluctulal Framing Stiucture Main Beam 400 CF 6350
4« 47 48 Suuautal Framing Suuetuial Framing Suuetuial Framing Structiae Structure Structure Main Beam Main Beam Main Beam 400 CF 400 CF 400 CF 71B8 6490 6490
49 Suuetuial Framing Stiucture Main Beam 400 CF 7327
M Sttuctuial Framing Structure Mam Beam 400 CF 732?
SI floors Structure Rool Slab 423 CF 285482
K Floors Inter lot Ha« Room Tlesf Cetamic WKt 40 SF 23123
» Floors Interior Bathroom Floor Ttes 40 SF 4511
5* Wak Interior Bathroom Wail Ties 40 SF 3056
Wib Interior Bathroom Val Ties 40 SF 2789
Shectl ©
Fig. 13. Plotting of Cost Data in Excel
Process 3: Cost Data Analysis using Power BI
The total cost of the BIM model will be exported to Microsoft Excel and shown using the Microsoft Power BI tool. Using Microsoft Power BI tool, we can analyze the cost data by customize with the appropriate templates. For instance, if we want to know how much structural, architectural, or interior components would cost, if we just want to view the total structural costs, if we may check either the structural foundation cost or the entire cost of the column or we may calculate the total cost of the exterior wall or tiles, all of these cost data can be categorized and visualize using power BI. We may also compare materials by price and choose the most cost-effective solution. As a result, we may use the Power BI tool to visualize the cost data and make decisions based on our construction budget.
Microsoft Power BI is a business intelligence tool that helps companies/ individuals to identify insights in their data. Connecting different data sources, transforming and clean-ing the data into a data model, and creating charts or graphs to visualize the data are all possible with Power BI. To further visualize the cost data, we are utilizing the Power BI tool by importing Excel data into Microsoft Power BI, then customize using the appro-priate templates which allow to visualize the cost data in several ways. For example, if you just want to view structural costs, you may check either the structural foundation cost or the entire cost of the column. You may calculate the total cost of the exterior wall or tiles by using the calculator.
Total building cost based on the BIM model and anticipated unit cost data.
Fig. 14. Total Estimated Cost
The building will cost 18,91,380 Rs round of 2M in total., according to the BIM model. So, using this script, we can estimate the cost roughly. The following graph depicts the overall cost of a certain cost group, such as architecture, structural, and interior design.
Result and Discussion
We can determine the total cost of each piece or elements from figure 14, and power BI enables us to split the total cost of each constituent individually.
z
M Û -I M
D
CÛ
I-iu
w is
S S
W
(C 3
a £
tt
§8
* o < °
I TJ
u <u
w +J
if ro
mi O
O (Q
00 -a
«¡8
S
*
N S
< "H X 00
■ <u
< r.
Similar to how pulling out the entire cost data from Revit would take a long time, using this script allows us to acquire the cost data quickly and see it independently for each el-ement in Power BI.
As an illustration, if we want to extract the floor material cost data from Revit, we must first go to the material take off and then choose the appropriate parameters before we can obtain the cost data (as 15 fig.).
The live dashboard provided by Power BI, in contrast, allows us to click on the cost group and category to view the cost statistics (as fig. 16).
<Floor Material Takeoff>
A B RH c« D E F G
Description Type Cost Group Material Area M ate nal Volume Takeoff Rate Total Cost
Inteno
Hail Room Tiles/ Ceramic Wi Tiles Interior S 78 SF 38 CF SF 23123 00
Bathroom FJoof Tiles Bathroom Tile [Interior 113 SF 7 CF SF 4511.00
Bedroom Wooden Tile Wooden Tile ! Interior 250 SF 16 CF SF 10000 00
Hall Room Tiles/ Ceramic Wh Tiles Interior 36 SF 2 CF SF 1433 00
Interior" "
Structure
Ground Floor Base/ Plinth Ground Floor ! Structure 1124 SF 2213 CF CF 177007.00
Roof Slab Floor : Structure 1350 SF 675 CF CF 235432.00
Fig. 15. Total Estimated Cost
It would take a lot of time to extract all of the material cost data from Revit separately, thus this Dynamo script was created to extract the cost data quickly and view it separate-ly on power BI with just a few clicks. The cost information is shown in figures 17 to 21 below separately for each element.
Fig. 16. Total Estimated Cost
Fig. 17. Total Structural Cost
z
M û -I M
D
CÛ
Fig. 18. Total Architecture Cost
I-iu
M
Z
LLI
W ,0
$ o W
■a c
fc
tt O
Fig. 19. Total Interior Cost
(C 3
a £
cû
2 3
* o < °
I T3
u <u
if ro ^ É mi O
O (Q 10 T3 «¡8 if ro s
N S
< "H
X
■ <u
< .c
Total Cost by Cost Croup
O loie»nal/ Partition Wall
Coit Group Cilagory Dticriphon Unit Cost Toul Colt
ArcrvittKTui« Wail» Con*>r> Wall_MO 393 7Q
Total 1B170
I4ÛO
Unit Cost
I Î9Î70 I Total Coit
Fig. 20. Total Curtain Wall Cost
Fig. 21. Total Interior Floor Cost
We can calculate cost of the BIM model using this script. Furthermore, various cost data can be analyzed utilizing the Power BI application. Interior costs, like overall structural costs or interior cost can be broken down into several categories. Specific parts can also be examined, such as if we want to calculate the whole ceiling cost or just the tile cost or the wall cost.
Conclusion
Material quantity take-off is widely utilized in the construction industry, begin-ning with the early phases of design and continuing through the construction process to improve scheduling and cost predictions. The quantity take-off procedure includes identifying items and their connections on drawings, gathering dimensions, and computing units of measurement such as areas, volumes, and linear meters. As a result, quantity take-off takes a long time to interpret traditional printed and CAD designs, despite its relevance. In order to avoid mistakes caused by duplicate counts and omis-sions, estimators must extensively analyse each drawing set and do calculations with precision. BIM, on the other hand, can enable more precise and faster material quantity take-off while also lowering costs.
In this paper we have calculated the total item cost of each element by dynamo pro-gramming to remove the manual process of estimating and to proper visualize that cost data by element category using power BI.
In this paper, we used dynamo script to calculate the total cost of each item in the BIM model, as well as the overall cost of the entire BIM model in REVIT. The total cost of the BIM model is determined, and the cost sheet is exported together with the BIM model's element data. Using the Microsoft Power BI application, we visualize the cost data as per element category. We just split the pieces into cost categories using the dy-namo script for improved cost analysis. For example, utilizing the dynamo script and visualizing using Power BI, we were able to determine how much structural, architec-tural, and interior work costs, as well as appraise materials based on cost and chose the most cost-effective option.
Manually extracting the cost data from each element in Revit takes a lot of time. With the help of this Dynamo script, we can acquire the cost data of the elements in Excel form and then import the data into Power BI to view the cost data individually for each element in dashboards.
References
1. Chukwuma Nnaji and Ali A. Karakhan, "Technologies for Safety and Health Management in Construction: Current Use, Implementation Benefits and Limitations, and Adoption Barriers," Journal of Building Engineering 29 (May 2020): 101212, https://doi.org/10.1016/j.jobe.2020.101212.
2. AACE International (2011). "Supporting Skills and Knowledge of a Cost Engineer". Based Upon AACE® International Recommended Practice 11R-88, Required Skills and Knowledge of Cost Engineering.
3. Bansal, V. K., and Pal, M. (2007). "Potential of geographic information systems in building cost estimation and visualiza-tion." Automation in Construction, 16(3), 311 - 322.
4. Becerik-gerber, B., Asce, A. M., Jazizadeh, F., Li, N., and Calis, G. (2012). "Application Areas and Data Requirements for BIM-Enabled Facilities Management." (March), 431 - 442.
5. Becerik-gerber, B., Asce, A. M., and Kensek, K. (2010). "Building Information Modeling in Architecture, Engineering, and Construction: Emerging Research Directions and Trends." (July), 139 - 147.
6. Becerik-gerber, B., Asce, A. M., Ku, K., and Jazizadeh, F. (2012). "BIM-Enabled Virtual and Collaborative Construction Engineering and Management." (July), 234 - 245.
7. Abushwereb M., Liu H. and Al-Hussein M. (2019). A knowledge-based approach towards automated manufacturing-centric BIM: wood frame design and modelling for light-frame buildings. In Modular and Offsite Construction (MOC) Summit. Alberta, Canada, 100 - 107.
8. AGACAD (2020). BIM Software & Autodesk Revit Apps T4R (Tools for Revit) — AGACAD TOOLS4BIM. Available at: http://www.aga-cad.com/ [Accessed 23 September 2019].
9. Andersson L., Farrell K., Moshkovich O. and Cranbourne C. (2016). Implementing virtual design and construction using BIM: current and future practices. Routledge.
10. Autodesk (2016). Dynamo BIM. Available at: http://dynamobim.org/ [Accessed 10 January 2018].
11. Ecvarovská R. and Matejka P. (2014). Comparative analysis of creating traditional quantity takeoff method and using a BIM tool. In Construction Economics Conference.
12. Brook M. (2017). Estimating and tendering for construction work. 5th ed. New York: Routledge.
z
M
O
-I
M
D CD
I-iu
w is § S
W
(C 3
a £
tt
§8
* o
< °
I TJ
u <u
w +J
if ro
mi O
O (Q
00 -O
«¡8 s
N 2
< "H X 00
■ <u
< r.
13. Cho J. and Chun J. (2015). Cost estimating methods for RC structures by quantity takeoff and quantity prediction in the design development stage, Journal of Asian Architecture and Building Engineering, Vol. 14, 65 - 72. DOI: 10.3130/jaabe.14.65.
14. Firat C. E., Arditi D., Hamalainen J. P., Stenstrand J. and Kiiras J. (2010). Quantity take-off in model-based systems. In Proceedings of the 27th CIB W78 International Conference. Cairo, Egypt, 16 - 18.
15. Franco J., Mahdi F. and Abaza H. (2015). Using building information modeling (BIM) for estimating and scheduling, adoption barriers, Universal Journal of Management, Vol. 3, 376 - 384. DOI: 10.13189/ujm.2015.030905.
16. Hardin B. and McCool D. (2015). BIM and construction management: proven tools, methods, and workflows. 2nd ed. Wiley.
17. Holm L., Schaufelberger J. E., Griffin D. and Cole T. (2005). Construction cost estimating: process and practices. 1st ed. Pearson.
18. Zima K. (2017). Impact of information included in the BIM on preparation of bill of quantities, Procedia Engineering, Vol. 208, 203 - 210. DOI: 10.1016/J.PR0ENG.2017.11.039.
19. Autodesk (2022). Dynamo BIM. Available at: http://dynamobim.org.
20. BIMForum (2019). Level of development (LOD) specification part 1 & commentary for building information models and data. Available from: https://bimforum.org/wp-content/uploads/2019/04/LOD-Spec-2019- Part-I-and-Guide-2019-04-29.pdf.
21. Alavi, H., Bortolini, R. & Forcada, N. BIM-based decision support for building condition assessment. Autom. Constr. 135, 104117. https://doi.org/10.1016/_j.autcon.2021.104117 (2022).
22. Burggraf, P.; Dannapfel, M.; Ebade-Esfahani, M.; Scheidler, F. Creation of an expert system for design validation in BIM-based factory design through automatic checking of semantic information. Procedia CIRP 2021, 99, 3 - 8.
АВТОМАТИЗИРОВАННЫЙ РАСЧЕТ ЗАТРАТ НА ОСНОВЕ BIM И ВИЗУАЛИЗАЦИЯ ДАННЫХ О ЗАТРАТАХ
А. Хазра * С. Босе *
А. Чакраборти ** Ш. Касеми** М. А. А. Обейд** E. Бехруз **
* Технологический институт Нарула, г. Калькутта ** Российский университет дружбы народов (РУДН), г. Москва
Ключевые слова
моделирование зданий (BIM), анализ стоимости количества элементов на основе BIM, скрипт Dynamo, анализ затрат.
Дата поступления в редакцию
05.12.2022
Дата принятия к печати
14.12.2022
Аннотация
Расчет количества материалов часто используется в строительной отрасли для повышения эффективности планирования и оценки стоимости, начиная с ранних стадий проектирования и продолжая в процессе строительства. Идентификация вещей и их связи с чертежами, сбор данных для вычисления единиц измерения, таких как площади, объемы, — все это часть метода учета количества. С другой стороны, BIM (моделирование информации о строительстве) делает расчет количества материалов более точным и быстрым, что, в свою очередь, снижает расходы. В документе основное внимание уделяется расчету общей стоимости каждого элемента модели BIM, а также общей стоимости полной модели BIM с использованием REVIT. Все данные о затратах модели BIM затем экспортируются
в Microsoft Excel, а для визуализации данных о затратах используется приложение Microsoft Power BI. С помощью разработанного динамо-скрипта мы можем анализировать данные о стоимости с категорией элемента. Например, если мы хотим узнать, сколько будут стоить структурные, архитектурные или внутренние части, он мо-жет легко вычислить их с помощью этого скрипта и визуализировать с помощью Power BI. Мы также можем оценить материалы в зависимости от их стоимости и выбрать наиболее выгодный вариант. Смета строительства — это большой процесс с несколькими процедурами и сметными разделами, а также большим количеством моментов, которые необходимо просчитывать поминутно, что может привести к многочисленным неточностям. Это сэкономит много времени и позволит избежать человеческих ошибок, если мы сможем рассчитать стоимость товара с помощью модели BIM.
и
Z н
Û -I н
D CD
Ссылка для цитирования:
A. Hazra, S. Bose, A. Chakraborty, S. Qasemi, M. A. A. Obeid, E. Behruz. The BIM-based automated cost computation and visualization of cost data. — Системные технологии. — 2023. — № 1 (46). — С. 12 - 27.
H ш
Z = W ra
S s
w Я
го
i * 2 8 2 я
* О < °
I TJ
и <u
w -M
if re
mi О
О га 00 -а
«¡8 Л ге
S
*
N S
< и
X 00
■ <u
< г.
