Excel spreadsheet - Sreadsheet for patio
-
shaun17
- Posts: 12
- Joined: Tue Mar 01, 2011 1:34 pm
- Location: cheshire
has anyone noticed that the excel spreadsheet for costing a patio is wrong the figures just don't add up for example the price per meter when you type in unit cost is wrong and also amount of sand and cement does not seem right.hate to point this out the spread sheet is on this site by the way
shaun mottershead
-
rab1
- Posts: 1869
- Joined: Sun Jun 07, 2009 10:19 pm
- Location: scotland
-
Dave_L
- Site Admin
- Posts: 4732
- Joined: Fri Jul 28, 2006 8:47 pm
- Location: Somerset
- Contact:
My thoughts too Rab but I couldn't be arsed to type it out!rab1 wrote:I'm sure if you send the Boss the correct formula for the spread sheet he will update it asap.
RW Gale Ltd - Civils & Surfacing Contractors based in Somerset
See what we get up to Our Facebook page
See what we get up to Our Facebook page
-
Dave_L
- Site Admin
- Posts: 4732
- Joined: Fri Jul 28, 2006 8:47 pm
- Location: Somerset
- Contact:
"Watch out, we got a badass over here" 
RW Gale Ltd - Civils & Surfacing Contractors based in Somerset
See what we get up to Our Facebook page
See what we get up to Our Facebook page
-
Tony McC
- Site Admin
- Posts: 8346
- Joined: Mon Jul 05, 2004 7:27 pm
- Location: Warrington, People's Republic of South Lancashire
- Contact:
That spreadsheet in various incarnations has been right for over 25 years, so I can't accept it's just suddenly started to go wrong!
Unit cost and equivalent price per m² - checked and it's correct. Are you overlooking the fact that the input is VAT inclusive while the output is nett?
The quantity of bedding sand is, if anything, generous as it's rounded up (never down) to the nearest tonne. So, if the calculation resulted in a sum of 3.01 tonnes, the sheet would report 4 tonnes. The calculation for cement is based on that generous 'rounded-up' value.
Although I'm no longer contracting or pricing-up, I've used the bones of that spreadsheet since 1986 when I first wrote it in SuperCalc (those were the days!) so I'm reasonably confident that it works.
Unit cost and equivalent price per m² - checked and it's correct. Are you overlooking the fact that the input is VAT inclusive while the output is nett?
The quantity of bedding sand is, if anything, generous as it's rounded up (never down) to the nearest tonne. So, if the calculation resulted in a sum of 3.01 tonnes, the sheet would report 4 tonnes. The calculation for cement is based on that generous 'rounded-up' value.
Although I'm no longer contracting or pricing-up, I've used the bones of that spreadsheet since 1986 when I first wrote it in SuperCalc (those were the days!) so I'm reasonably confident that it works.
Site Agent - Pavingexpert
-
shaun17
- Posts: 12
- Joined: Tue Mar 01, 2011 1:34 pm
- Location: cheshire
if you use the calculators for the unit cost and price per square meter it's way different same with sand and cement amounts I mean the calculators page as opposed to the excel sheetTony McC wrote:That spreadsheet in various incarnations has been right for over 25 years, so I can't accept it's just suddenly started to go wrong!
Unit cost and equivalent price per m² - checked and it's correct. Are you overlooking the fact that the input is VAT inclusive while the output is nett?
The quantity of bedding sand is, if anything, generous as it's rounded up (never down) to the nearest tonne. So, if the calculation resulted in a sum of 3.01 tonnes, the sheet would report 4 tonnes. The calculation for cement is based on that generous 'rounded-up' value.
Although I'm no longer contracting or pricing-up, I've used the bones of that spreadsheet since 1986 when I first wrote it in SuperCalc (those were the days!) so I'm reasonably confident that it works.
shaun mottershead