The Use Of Excel Macro Feature On Cost Estimation Calculation

Luthan, Putri Lynna A. and Sitanggang, Nathanael The Use Of Excel Macro Feature On Cost Estimation Calculation. In: 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.

[thumbnail of Article.pdf]
Preview
Text
Article.pdf - Published Version

Download (739kB) | Preview
[thumbnail of Turnitin.pdf]
Preview
Text
Turnitin.pdf - Published Version

Download (3MB) | Preview

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.

Item Type: Conference or Workshop Item (Paper)
Keywords: excel macros; cost estimateion; models; steel weights; estimators
Subjects: L Education > LC Special aspects of education
L Education > LC Special aspects of education > LC1022 Computer-assisted education
S Agriculture > SF Animal culture > SF111 Cost, yield, and profit. Accounting
T Technology > TK Electrical engineering. Electronics Nuclear engineering > TK7800 Electronics > TK7885 Computer engineering. Computer hardware TK8300-8360 Photoelectronic devices (General)
Divisions: Fakultas Teknik
Depositing User: Mrs Catur Dedek Khadijah
Date Deposited: 23 May 2023 02:05
Last Modified: 23 May 2023 13:20
URI: https://digilib.unimed.ac.id/id/eprint/52224

Actions (login required)

View Item
View Item