Napravite drugi sheet (LISTA MATERIJALA). Koristite VLOOKUP ili XLOOKUP funkciju da automatski povučete cijenu materijala prema šifri.
Primjer formule za cijenu: =VLOOKUP(B2;'Materijali'!$A$2:$B$100;2;FALSE)
Izrada obračunskog lista građevinske knjige u Excelu nije raketna nauka, ali zahtijeva disciplinu. Ključne stvari koje ponesite iz ovog članka:
Preuzmite naš besplatni predložak (link u opisu – ili kreirajte sami za 10 minuta) i počnite sa urednim vođenjem građevinske knjige već danas.
Pitanje za čitaoce: Koji su vaši najveći izazovi kod obračuna sa investitorima? Pišite u komentare ispod!
Autor: Tim portala Građevinski Knjigovodstvo.
Ažurirano: Oktobar 2025.
Zabranjeno kopiranje bez navođenja izvora. Predlošci su vlasništvo autora i služe isključivo u edukativne svrhe.
Introduction
In the construction industry, accurate and efficient calculation of costs, materials, and labor is crucial for project success. Traditional methods of manual calculations can be time-consuming and prone to errors. With the advancement of technology, spreadsheet software like Microsoft Excel has become an essential tool for construction professionals. This paper focuses on creating a comprehensive calculation sheet, "Obračunski list gradjevinske knjige," using Excel, to streamline construction project management.
Background
Construction projects involve numerous calculations, including material quantities, labor costs, and equipment expenses. A construction book, or "gradjevinska knjiga," is a document that records all aspects of a construction project, including costs, progress, and materials used. Manual calculations and record-keeping can be tedious and susceptible to errors, which can lead to project delays and cost overruns.
Objectives
The objectives of this paper are:
Methodology
To achieve the objectives, the following steps were taken:
The Obračunski list gradjevinske knjige Excel Template
The template consists of several worksheets, each designed to perform specific calculations:
The template uses various Excel functions, such as:
Benefits and Conclusion
The "Obračunski list gradjevinske knjige" Excel template offers several benefits, including:
In conclusion, the "Obračunski list gradjevinske knjige" Excel template is a practical tool for construction professionals to streamline their calculations and improve project efficiency. Its use can lead to better project management, reduced costs, and improved productivity.
Recommendations
Based on this study, the following recommendations are made:
I hope this draft paper provides a good starting point for your research! Please let me know if you need further assistance or have any specific requests.
For mathematical equations, I used $$ syntax, for example $$Q = A \times B \times C$$.
Obračunski list građevinske knjige (Calculation Sheet of the Construction Book) is a fundamental document in construction management used to track and verify the actual quantity of work performed on-site. While physical blocks of these forms are common, Excel versions are widely used to automate complex calculations and ensure data accuracy. Core Purpose and Function
The primary goal of this document is to provide a "calculation proof" (dokaznica mjera) for completed works. It serves as the legal and financial basis for: Monthly Billing
: Tracking progress on a monthly basis to issue interim payment certificates. Verification
: Both the supervisory engineer and the contractor's site manager must sign each sheet to confirm the authenticity of the recorded quantities. Final Settlement
: At the end of a project, all sheets are bound together to form the complete Construction Book, which is handed over to the client. Essential Components of the Excel Sheet
A proper Excel "Obračunski list" typically includes the following data fields: Project Identification
: Field for the project name, location/site, and specific object or sector. Sheet Tracking obracunski list gradjevinske knjige excel
: Every item from the project's Bill of Quantities (Troškovnik) must have its own separate sheet, numbered for reference. Work Description
: Detailed information on the type of work (e.g., earthworks, masonry), including the specific position number from the original estimate. Calculation Proof (Dokaznica mjera)
: Columns for mathematical formulas (Length × Width × Height) that justify the total quantity. Financial Data
: Unit price, total monthly quantity, and cumulative total to date. Signatures
: Specific placeholders for the contractor’s representative and the supervisory authority (Nadzorni organ). Strategic Benefits of Using Excel
Using an Excel-based system provides several advantages over manual paper entries:
Here are a few options for the post, depending on where you plan to publish it (e.g., a professional LinkedIn post, a Facebook group, or a blog intro).
Ovo su osnovne kolone koje morate imati:
| Kolona | Naziv | Opis | |--------|-------|------| | A | Red. br. | 1, 2, 3... | | B | Šifra pozicije | Iz troškovnika (npr. 01.01) | | C | Opis rada | Detaljan opis | | D | Jed. mjere | m2, m3, kom | | E | Planirano | Količina iz projekta (konstantna) | | F | Izvedeno (prethodno) | Kumulativ do prošlog mjeseca | | G | Izvedeno (tekući mjesec) | Radovi u ovom obračunskom periodu | | H | Izvedeno (ukupno) | =SUM(F2:G2) | | I | Ostatak za izvesti | =E2-H2 | | J | Jedinična cijena (€/KM) | Bez PDV-a | | K | Vrijednost (tekući) | =G2J2 | | L | Vrijednost (kumulativ) | =H2J2 | | M | Napomena | Eventualna odstupanja |
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. Napravite drugi sheet (LISTA MATERIJALA)
Need a ready-to-use template? Search for "Excel obrazac obračunski list građevinske knjige" – but after reading this guide, you can confidently build your own, tailored to your specific contract conditions.
Have you used Excel for construction billing? Share your tips or questions in the comments below!