AUT Journal of Civil Engineering

AUT Journal of Civil Engineering

Automated Bar Bending Schedule and Reinforcement Procurement-Waste Estimation for Apartment Pile Caps: an Excel-Macros Case Study

Document Type : Research Article

Authors
1 Construction Management Study Program (D4), Faculty of Engineering, Universitas Negeri Medan, Indonesia
2 Building Engineering Education Study Program (S1), Faculty of Engineering, Universitas Negeri Medan, Indonesia
Abstract
Waste material in construction projects is a major challenge that leads to increased project costs and inefficiency. One material that often experiences significant waste is reinforced concrete, primarily due to inefficient steel cutting, errors in the planning of bar lengths, and discrepancies between the working drawings and field conditions. Accurate reinforcement take-off and procurement planning are important for controlling construction waste, but spreadsheet automation is frequently reported without a clear distinction between theoretical material demand and actual site scrap. This study evaluates an Excel-macro-assisted bar bending schedule (BBS) workflow for three pile-cap group (P1-P3) in an Indonesian apartment construction project using project drawings, reinforcement schedules and procurement quantities collected during May-July 2025. The reconstructed BBS indicates reinforcement requirements of 825.53 kg for P1, 1,105.01 kg for P2 and 9,746.84 kg for P3, totaling 11,677.38 kg when the displayed subgroup values are summed. Reported procurement is 12,158.56 kg, giving a mass difference of 481.18 kg and a procurement surplus ratio of 3.9575% relative to ordered mass (approximately 3.958%). This figure is an estimated a procurement-demand balance, not an independently measured disposal rate. The contribution is a traceable case-study workflow linking detailed bar schedules to quantity aggregation and a clearly defined surplus indicator, rather than a demonstrated new cutting-stock optimization algorithm. Further validation requires bar-level stock allocation, reusable-offcut records, independent calculation checks and field measurements.
Keywords
Subjects


Articles in Press, Accepted Manuscript
Available Online from 13 November 2026