Obracunski List Gradjevinske Knjige Excel May 2026

How to Create a Construction Book Calculation Sheet in Excel: A Step-by-Step Guide

Managing a construction project, whether it's a family house or a commercial building, requires precise financial tracking. In many European countries, particularly in the former Yugoslavia region, the "Građevinska knjiga" (Construction Book) is a legal requirement. Within it, the Obračunski list (Calculation Sheet) is the most critical tool for tracking costs, work progress, and payments to subcontractors.

• automatsko bojenje odstupanja (crveno za više od 10% razlike)
• zbirne preglede po fazama radova
• mjesečne obračune sa prenosom stanja

Postavite pravilo da se ćelija zacrveni ako "Ukupna kumulativna količina" premaši "Ugovorenu količinu" iz troškovnika. To je jasan alarm da su se na terenu pojavili vantroškovnički radovi ili greška u izmjeri. 3. Zaštita listova (Protect Sheet) obracunski list gradjevinske knjige excel

Ručno kucanje rezultata: Nikada nemojte sabirati na kalkulatoru pa upisivati broj u Excel. Pustite softver da računa. How to Create a Construction Book Calculation Sheet

Standardizacija: Možete kreirati sopstveni "Template" (šablon) koji će svi inženjeri u firmi koristiti. automatsko bojenje odstupanja (crveno za više od 10%

Povezivanje sa Predmerom: Koristite VLOOKUP funkciju da na osnovu šifre pozicije Excel automatski povuče opis i jediničnu cenu.

Final Word

The Obračunski list in Excel is not just a table – it is your project's financial dashboard. When built correctly, it prevents disputes, ensures transparency, and saves hours of manual calculation. Start simple, then add complexity (e.g., PivotTables for cost analysis by work type) as you get comfortable.

Descriptive Part: Basic project data, including the construction site name, contractor, investor, contract number, and the specific type of work (e.g., concrete pouring or roof demolition).