Research Article
The Use Of Excel Macro Feature On Cost Estimation Calculation
@INPROCEEDINGS{10.4108/eai.16-11-2019.2293109, author={Putri Lynna A. Luthan and Nathanael Sitanggang}, title={The Use Of Excel Macro Feature On Cost Estimation Calculation}, proceedings={Proceedings of the the 3rd Annual Conference of Engineering and Implementation on Vocational Education, ACEIVE 2019, 16 November 2019, Universitas Negeri Medan, North Sumatra, Indonesia}, publisher={EAI}, proceedings_a={ACEIVE}, year={2020}, month={3}, keywords={excel macros cost estimateion models steel weights estimators}, doi={10.4108/eai.16-11-2019.2293109} }- Putri Lynna A. Luthan
Nathanael Sitanggang
Year: 2020
The Use Of Excel Macro Feature On Cost Estimation Calculation
ACEIVE
EAI
DOI: 10.4108/eai.16-11-2019.2293109
Abstract
This study aims to describe the stages of calculating the construction costs estimation using the Macro feature on Excel. The problem that being studied is how are the stages of using the Excel Macro to determine the volume of steel and the reinforcement model that needed for a construction. The research method used is a qualitative descriptive type with the research subject being a construction project contractor who uses an Excel Macro for a Micro Hydro Power Plant development project. Data is obtained through observation, interviews and reviewing various sources of documents. The results found are the stages of using Excel macros to calculate the number, model of reinforcement, dimensions, code and the amount of residual material produced by the estimator as a guide for workers. This finding is very useful because with the use of Excel macro can improve the estimation work for planning consultants and contractors to be more effective and efficient.