Excel based construction cost estimator for concrete structures /
by Patricia Pearl C. Parian and Kimberly O. Separa.
- Indang, Cavite : Cavite State University- Main Campus, 2019.
- xx, 183 pages : illustrations ; 28 cm.
Design Project (Bachelor of Science in Civil Engineering) Cavite State University.
Includes bibliographical references.
College of Engineering and Information Technology (CEIT), Department of Civil Engineering College of Engineering and Information Technology (CEIT), Department of Civil Engineering
PARIAN, PATRICIA PEARL C., and SEPARA, KIMBERLY O. Excel-based Construction Cost Estimator for Concrete Structures. Undergraduate Thesis. Bachelor of Science in Civil Engineering. Cavite State University, Indang, Cavite. June 2019. Adviser: Engr. Renato B. Cubilla.
Efficient construction management is the key to success of any project and effective planning is the way to attain this. In the construction planning process, the cost estimation and scheduling are regarded as the most important parts because they set the guidelines and predict the outcome of the project. With the increased use of computers in the construction industry and spreadsheet programs such as Excel, many companies have converted their estimating forms into computer spreadsheets. To further develop technological solutions and provide reference for future researches, this study aims to design a computer-based construction cost estimator using Microsoft Excel.
The study was conducted from September 2018 to April 2019 at the Department of Civil Engineering, College of Engineering and Information Technology, Cavite State University, Indang, Cavite. The objectives of the study were to develop an Excel - based construction estimating software that will provide construction estimates fast, easy and efficient. The study also sought to understand the different methods and principles used in construction estimates as well as the wide range and beneficial usage of Microsoft Excel.
The estimation covered the architectural works, structural works, electrical works, plumbing works, and finishing works. The primary tool used in the study was the 2013-2016 version of Microsoft Excel. All data such as formulas, tables, principles and techniques were based on Simplified Construction Estimate by Max. B. Fajardo Jr. and Estimating Bill of Materials by Vicente A. Tagayun.
The results were analyzed using percent-error formula to test the accuracy of the results. It is concluded that Microsoft Excel is a powerful tool and can be used in construction estimates.