Development of spreadsheet based quantity take-off and cost estimation application

BETTEMİR, Ö.H.

Development of spreadsheet based quantity take-off and cost estimation application

Ö.H. Bettemir (İnönü Üniversitesi, İnşaat Mühendisliği Bölümü, Malatya, Türkiye)

Journal of Construction Engineering, Management & Innovation (Online)

0 0

Yıl: 2018 Cilt: 1 Sayı: 3 Sayfa Aralığı: 108 - 117 Metin Dili: İngilizce İndeks Tarihi: 14-10-2020

Development of spreadsheet based quantity take-off and cost estimation application

Öz:

Quantity take-off and cost estimation are the most time consuming and costly work items of the projectplanning phase. A structure consists of significantly many components, and quantities of all of these workitems have to be computed as well as necessary workmanship and materials should be determined. If quantitytake-off is computed incorrectly, then cost will also be estimated erroneously. Therefore, computation ofquantity take-off correctly has vital importance. Each constructed structure is unique, for this reason quantitytake-off has to be prepared for every structure. In this study, a spreadsheet application is developed for thecomputation of quantity take-off with minimum human intervention and endeavor. Positions of the loadbearing sections and architectural elements are defined by nodes and dimensions of these elements areidentified by entering related information to data cells. Topologies of the structural and architectural elementsare formed to determine the neighborhood and intersections. Voids are computed and subtracted to obtainexact quantities. Necessary materials and workmanships are determined by using database and cost isestimated by using unit prices of these items. Quantity take-off and cost is computed fast and accurately withminimized data input. Consequently, design offices can avoid purchasing expensive quantity take-offsoftware by utilizing this approach.

Anahtar Kelime:

Belge Türü: Makale Makale Türü: Araştırma Makalesi Erişim Türü: Erişime Açık

[1] Plebankiewicz E., Zima K., Skibniewski M. Analysis of the First Polish BIM-based Cost Estimation Application. Procedia Engineering 123 (2015) 405-414.
[2] Bečvarovská R., Matějka P. Comparative Analysis of Creating Traditional Quantity Takeoff Method and Using A BIM Tool. In Construction Maeconomics Conference (2014).
[3] Olsen D., Taylor J. M. Quantity Take-Off Using Building Information Modeling (BIM), and Its Limiting Factors. Procedia Engineering 196 (2017) 1098-1105.
[4] Sattineni A., Bradford R. H. Estimating with BIM: A survey of US construction companies. Proceedings of the 28th ISARC, Seoul, Korea (2011) 564-569.
[5] Lee S. K., Kim K. R., Yu J. H. BIM and OntologyBased Approach for Building Cost Estimation. Automation in Construction 41 (2014) 96-105.
[6] Kim S. A., Chin S., Yoon S. W., Shin T. H., Kim Y. S., Choi C. Automated Building Information Modeling System for Building Interior to Improve Productivity of BIM-Based Quantity Take-Off. In Proceedings for the 26th International Symposium on Automation and Robotics in Construction (2009) 492-496.
[7] Aram S., Eastman C., Sacks R. A KnowledgeBased Framework for Quantity Takeoff and Cost Estimation in The AEC Industry Using BIM. In ISARC. Proceedings of the International Symposium on Automation and Robotics in Construction (2014).
[8] Choi J., Kim H., Kim I. Open BIM-based Quantity Take-Off System for Schematic Estimation of Building Frame in Early Design Stage. Journal of Computational Design and Engineering 2(1) (2015) 16-25.
[9] Chen S. M., Chen P. H., Chang L. M. A framework For an Automated and Integrated Project Scheduling and Management System. Automation in Construction 35 (2013) 89-110.
[10] Smith P. Project Cost Management–Global Issues and Challenges. Procedia-Social and Behavioral Sciences 119 (2014) 485-494.
[11] Smith P. Global Professional Standards for Project Cost Management. Procedia-Social and Behavioral Sciences 226 (20169 124-131.
[12] Monteiro A., Martins J. P. A survey On Modeling Guidelines for Quantity Takeoff-Oriented BIMBased Design. Automation in Construction 35 (2013) 238-253.
[13] Wijayakumar M., Jayasena H. S. Automation of BIM Quantity Take-Off to Suit QS's Requirements. In Second World Construction Symposium (2013).
[14] Didkovskaya O. V., Mamayeva O. A., Ilyina M. V. Development of cost engineering system in construction. Procedia Engineering 153 (2016) 131-135.
[15] Wu S., Wood G., Ginige K., Jong S. W. A Technical Review of BIM Based Cost Estimating in UK Quantity Surveying Practice, Standards and Tools. Journal of Information Technology in Construction 19 (2014) 534-562.
[16] Smith P. Project Cost Management with 5D BIM. Procedia-Social and Behavioral Sciences 226 (2016) 193-200.
[17] Chapra S. C., Canale R. P. (1998). Numerical methods for engineers, New York: McGraw-Hill (1998).
[18] O'Rourke J., Chien C. B., Olson T., Naddor D. A New Linear Algorithm for Intersecting Convex Polygons. Computer Graphics and Image Processing, 19(4) (1982) 384-391.
[19] Chin F., Wang C. A. Optimal Algorithms for The Intersection and The Minimum Distance Problems Between Planar Polygons. IEEE Transactions on Computers 32(12) (1983) 1203-1207.
[20] Margalit A., Knott G. D. An Algorithm for Computing the Union, Intersection or Difference of Two Polygons. Computers & Graphics 13(2) (1989) 167-183.

APA	BETTEMİR Ö (2018). Development of spreadsheet based quantity take-off and cost estimation application. , 108 - 117.
Chicago	BETTEMİR Ö.H. Development of spreadsheet based quantity take-off and cost estimation application. (2018): 108 - 117.
MLA	BETTEMİR Ö.H. Development of spreadsheet based quantity take-off and cost estimation application. , 2018, ss.108 - 117.
AMA	BETTEMİR Ö Development of spreadsheet based quantity take-off and cost estimation application. . 2018; 108 - 117.
Vancouver	BETTEMİR Ö Development of spreadsheet based quantity take-off and cost estimation application. . 2018; 108 - 117.
IEEE	BETTEMİR Ö "Development of spreadsheet based quantity take-off and cost estimation application." , ss.108 - 117, 2018.
ISNAD	BETTEMİR, Ö.H.. "Development of spreadsheet based quantity take-off and cost estimation application". (2018), 108-117.

APA	BETTEMİR Ö (2018). Development of spreadsheet based quantity take-off and cost estimation application. Journal of Construction Engineering, Management & Innovation (Online), 1(3), 108 - 117.
Chicago	BETTEMİR Ö.H. Development of spreadsheet based quantity take-off and cost estimation application. Journal of Construction Engineering, Management & Innovation (Online) 1, no.3 (2018): 108 - 117.
MLA	BETTEMİR Ö.H. Development of spreadsheet based quantity take-off and cost estimation application. Journal of Construction Engineering, Management & Innovation (Online), vol.1, no.3, 2018, ss.108 - 117.
AMA	BETTEMİR Ö Development of spreadsheet based quantity take-off and cost estimation application. Journal of Construction Engineering, Management & Innovation (Online). 2018; 1(3): 108 - 117.
Vancouver	BETTEMİR Ö Development of spreadsheet based quantity take-off and cost estimation application. Journal of Construction Engineering, Management & Innovation (Online). 2018; 1(3): 108 - 117.
IEEE	BETTEMİR Ö "Development of spreadsheet based quantity take-off and cost estimation application." Journal of Construction Engineering, Management & Innovation (Online), 1, ss.108 - 117, 2018.
ISNAD	BETTEMİR, Ö.H.. "Development of spreadsheet based quantity take-off and cost estimation application". Journal of Construction Engineering, Management & Innovation (Online) 1/3 (2018), 108-117.