The Use Of Excel Macro Feature On Cost Estimation Calculation

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.