Windows / Doors per m2

[craig]

I've been watching for sometime the discussions surrounding per m² costs. I've always felt these comparisons on per m² are flawed and not a fair reflection (even when comparing per m² cost with one another and potentially from the same supplier). The quantity of fixed versus openable can be different and the amount of doors for example and type.

 

So I thought I would put a quick excel calculation tool together to get m² based on the entered info. Which can then be filtered through the relevant options.

 

 

There is a couple of minor points to make. 

 

1. It's basic but does the job.
2. Due to the sheet being locked (password supplied), it won't expand the table as new data is entered, so I extended the table to accommodate.
3. This presents an issue when calculating subtotals as it includes zeros and in the average cost per m² field, this presents an incorrect figure for "all items" as they aren't filtered. I have entered a cost per m2 field for all items to combat this.
4. It doesn't take quantities into account, each item needs to be entered individually.
5. When you filter, it will calculate only the visible cells in the "Average cost per m2" cell and displays the correct per m² cost. So you can filter by style for example (tilt and turn, top hung etc.) and it will always calculate the per m² cost on the selections made.
6. Discount amount (if any) can be entered and it will advise the percentage of discount supplied and then the cost per m² cells will adjust to the discounted rate.

 

I have tried to cover all the bases, including uPVC, Timber, Timber Alu Clad, Aluminium, timber type, internal finish, glazing etc. 

 

I've also put linear meterage data in plus install costs, which will display install cost per m²/linear meterage as well for a further breakdown. If you find this useful and can use this for comparisons with other suppliers / Buildhub members or if anyone would like to expand on it, feel free to download and amend accordingly. 

 

cost_per_m2.xlsx