I've put together a SAP-ish spreadsheet, I'd love to know if it's too simplistic, faulty or actually a bit useful.

It's at http://www.handymandy.co.uk/house/sappish.xls

I wanted to be able to play around and quickly look at the impact (financial and carbon) of different choices for our new house, 2G v. 3G, insulation values, window sizes etc. etc. Feel free to download and enter your own data.

I'd be REALLY grateful for your comments, and if a similar spreadsheet already exists I'd love to know about that. I've looked at the Kingspan website one but I want to be able to play around a lot more and see the results immediately.

thanks
RobinB

Dantenz many thanks for your comment, I really hope I haven't been wasting you time here.

The 63m2 relates only to the ground floor - total is about 200m2 over 2.5 floors. I have a lot of external walls compared to m2. I think the relevant details for the calculation are footprint in m2 and other external surfaces in m2 so total floor area is not relevant in that respect.

Does that make the figures seem more realistic? I don't have anything much to benchmark against. I'd be delighted it you told me that was too much energy.

thanks again
RobinB

You could try this free software

http://www.sei.ie/Your_Building/EPBD/DEAP/

Dwellings Energy Assessment Procedure (DEAP) - Irish Equivalent of SAP

Note the manual is available to download too .

The software is free and relatively easy to use

DEAP serves 2 functions in Ireland

1. To assist in demonstarting compliance with B Regs
2. To prepare data files for publishing BER ( EPC ) Certs

Caution - I think you produce electricity a little ( but not a lot ) less CO2 intensively than we do in Ireland so CO2 emission rate may be out a little .

The resulting calculated energy consumption ought to be ok .

UK and Irish B Regs are similar - but not identical - so if DEAP warns about about elements not complying - you need to bear this in mind too

But notwitstanding all that - I would hope you find it useful

From the DEAP manual
"Acknowledgements:
DEAP is the outcome of a development study carried out for SEI by a project team from the UCD Energy
Research Group, National Energy Services Ltd., Rickaby Thompson Associates Ltd. and Emerald Energy.
Much of the calculation procedure in DEAP, the accompanying tabulated data and the documentation in
this manual is drawn or adapted from the UK Standard Assessment Procedure (SAP) for Energy Rating of
Dwellings 2005 and 2008."

A thought - if any EPC assessor has the time - I would love to see a SAP assessment / rating data entry input into DEAP to see how close ( or hopefully not - far apart ) the results are .

Robin as you see the DEAP manual

http://www.sei.ie/Your_Building/BER/BER_Assessors/Technical/DEAP/DEAP_2009/DEAP_Manual_Version_3_October_2008_.pdf

looks a lot like the SAP manual

http://projects.bre.co.uk/SAP2005/pdf/SAP2005.pdf

Take note that Primary Energy factors ( Table 12 SAP , Table 8 DEAP ) differ but not massively

We have a free downloadable version of our SAP software which gives you limited reports plus a predicted energy assessment. You can download at.

http://www.completepicture.co.uk/

Cheers
Paul

Evan I think it was probably too amateur to bother with. Sorry about that. Others will have a better idea I'm sure.

I haven't been able to post the sappish.xls file here or indeed anywhere but I do have it. If you'd like a copy or to post it for me just whisper your email address.

The aim is to be able to play with different variables - and come to a conclusion about how energy costs and Co2 emissions would change, and what "green" elements would give best value for money on a fixed budget. As I said it probably isn't quite right.

RobinB

Thanks guys.

I've tried putting my figures into the DEAP software and got an annoying low "score" of D1, but I'm not sure what it thinks I'm doing badly. There seem to be a lot of assumptions in there that you can't adjust.

Anyway I'll try your spreadsheet next wookey.

Posted By: wookeyMore to the point the other software here is all Windows-only, so far as I know. A simple .xls can be turned into a openoffice spreadsheet and thus be more widely useful.

There is a SAP spreadsheet here:http://wookware.org/files/SAPWorksheet9.80.ods" rel="nofollow" >http://wookware.org/files/SAPWorksheet9.80.ods

No idea how that compares to RobinB's - it just reproduces the SAP2005 sums.

This looks potentially quite handy, I presume from its file name this is for 9.80, have you considered updating it to 9.83 and adding in the CO2 element?