CALCULATION OF LABOR AND MATERIAL NEEDS IN BUILDING AND HOUSING BASED ON SNI 2008 USING MICROSOFT EXCEL MACROS

Setiawan, Eman and Tistogondo, Julistyana and Bagio, Tony Hartono and Afaq, Roufil (2016) CALCULATION OF LABOR AND MATERIAL NEEDS IN BUILDING AND HOUSING BASED ON SNI 2008 USING MICROSOFT EXCEL MACROS. Proceeding Forum in Research, Science, and Technology (FIRST) 2016. ISSN 2461-0739

[img] Text
0-cover-depan.pdf

Download (330kB)
[img] Text
0-toc.pdf

Download (119kB)
[img] Text
D2.pdf - Published Version
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (249kB)
Official URL: http://first.polsri.ac.id

Abstract

In a project in the field of civil engineering before construction activities required prior to the calculation of the basic unit price of work (HSPK), the draft budget (RAB), as well as the need for labor and materials. During this process a lot of calculations done by Microsoft Excel Program manually input the reference design is the Indonesian National Standard (SNI). Microsoft Excel very easily recognizable function (user interface), but sometimes the difficulty browse through original value or loss of cell resource, in addition to the output of Microsoft Excel do not meet all the needs. There the results of the planners only in the form HSPK and RAB do not cover the needs of labor and materials. Microsoft Excel Macro is one of the alternative programs that can calculate HSPK, RAB, as well as the need for labor and materials. The program is simple enough where the zoom is also equal to excel and do not need to see the formula of each cell. Construction of two-storey house calculated all its needs using the Microsoft Excel Macros, but at a fixed volume calculation process using Microsoft Excel Manual. The coefficient is used as an input program Microsoft Excel Macros is SNI 2008 on buildings. The result is the unit price in accordance with SNI 2008, the draft budget (RAB), need for labor in Unit One Day, and material needs in a unit adapted to SNI.

Item Type: Article
Uncontrolled Keywords: Microsoft Excel, Microsoft Excel Macros, SNI 2008, HSPK, RAB
Subjects: Q Science > QA Mathematics
Q Science > QA Mathematics > QA76 Computer software
T Technology > TA Engineering (General). Civil engineering (General)
T Technology > TD Environmental technology. Sanitary engineering
Divisions: General > Proceeding and Seminar
Depositing User: Administrator EPRINTS POLSRI
Date Deposited: 29 May 2017 01:17
Last Modified: 29 May 2017 01:17
URI: http://eprints.polsri.ac.id/id/eprint/3582

Actions (login required)

View Item View Item