Jurnal Aplikasi Teknik Sipil
Vol 21, No 4 (2023)

Aplikasi Estimasi Biaya Bangunan Gedung Berdasarkan Analisa Harga Satuan Pekerjaan Berbasis Macro Excel

Lendra Lendra (Program Studi/Jurusan Teknik Sipil, Fakultas Teknik, Universitas Palangka Raya)
Robby Robby (Program Studi/Jurusan Teknik Sipil, Fakultas Teknik, Universitas Palangka Raya)
Frediyantoni F. Adji (Jurusan Arsitektur, Fakultas Teknik, Universitas Palangka Raya, Palangka Raya, Indonesia)
Muhammad Faqqih (Program Studi/Jurusan Teknik Sipil, Fakultas Teknik, Universitas Palangka Raya)



Article Info

Publish Date
27 Dec 2023

Abstract

Estimating construction project costs is usually done manually; it takes a long time, and the more comprehensive the estimate, the more manual calculations must be performed, increasing the risk of human errors. This study aims to make a building cost estimation application using the 2022 Work Unit Price Analysis (AHSP), based on excel macros, so that cost estimates become more accurate and efficient. The first step is to design the framework and application design and then analyze the database requirements. The second step: database creation and application interface design. The third step: testing, validation, and verification on two building projects in 2022. The estimation results of this application are very accurate and efficient, where the total cost is Rp. 382,998,432.00, while the bid price is Rp. 383,000,000.00. There is a difference in calculation costs compared to the bid price, which is Rp. 1,568.00 (0.00041%).

Copyrights © 2023






Journal Info

Abbrev

jats

Publisher

Subject

Civil Engineering, Building, Construction & Architecture

Description

Jurnal Aplikasi Teknik Sipil (JATS) E-ISSN 2579-891X, memuat tulisan tentang aplikasi dibidang Teknik Sipil. Aplikasi ini boleh berasal dari semua cabang ilmu teknik sipil baik itu struktural, geoteknik, manajemen konstruksi, hidrologi, transportasi, dan informatika teknik sipil. Sehingga aplikasi ...