Free tool
Employer's Cost Estimate and Quantity Schedule (Excel Template)
This template puts the four steps of the guide How to calculate the employer's cost estimate (Turkish) into a table. It has three sheets: Cetvel (schedule), Metraj (quantities), Icmal (summary).
Download the Excel template — no sign-up. (Sheet and source labels are in Turkish.)
How to use it
- On the Cetvel sheet, enter the rate period (YYYY-MM) and, for each line, the item, quantity, unit price, source and period.
- Source list: Kamu rayici (public rate) · Idare onceki is (authority's previous work) · Piyasa (market) · Analiz (analysis).
- The two warning counters at the bottom of the sheet must read 0 (no line with a blank period or source).
- Enter measurements on the Metraj sheet; the Icmal sheet gives the item-based total.
If you would rather have us prepare the calculation: employer's cost estimate preparation · quantity take-off.
Frequently asked questions
What is the template for?
You enter item, quantity and unit price; amounts, the total and the 25% profit-and-overhead layer are calculated automatically. A warning counter at the bottom of the sheet shows lines with a blank period or source.
Which lines get profit and overhead?
25% is added only to lines whose source is set to 'Analiz' (analysis). Official rate unit prices already contain this percentage; it is not added a second time.
How are blank measurements handled in the quantity sheet?
Blank Number, Width, Length and Height are counted as 1; the quantity is rounded to three decimals. The summary sheet brings the item-based total automatically.