Skip to main content
Whole Building, Elements, U Values, Areas, Temperatures differences, Heat loss, Element %, Fuel choice, CO2

GBE > G#15320

LSBU EREID 2017 Task 9

LSBU EREID 2017 Task 9


From my email 31/03/17

Hi Students

The calculators are now in the Task 9 DropBox folder for your current Task 9

You final task before submitting your complete Task 1-9 file


Task 9 > Week 10 Calculations

  • Whole building calculations
  • Building Element Areas > U values > Temperature Differences > Heat Loss > Elemental % > Fuel > in use carbon


Life skill

  • Read this more than once before you start, often during and at least once after you think you are finished.
  • Read with highlighter in hand and highlight the important issues that you need to address
  • Check off the highlighted items against your work until you have done it all
  • Add deadlines to your electronic diaries with advance warnings and alarm calls on days of submission and attendance and no not press snooze or you will snooze through life.


Spreadsheet(s) and additional page(s) of assumptions/comments:

  • Learning from Task 5 elemental assembly, materials and finishes
  • Being consistent with Task 6 Elemental U values (dynamically link Task 6 and Task 9 spreadsheets)
  • Learning from and being consistent with Task 7 Whole Building EE EC SC (schedules of materials)
  • Learning from Task 8 Services and Fuel choices
  • Update any or all of the above if you find they are not detailed enough or not consistent (applies to many of you)
  • Keep in mind an ambition to stick to ‘Fabric-First’ approach
  • Fabric-first means: very well insulated, airtight, thermal bridge-free construction, (needing little heating or cooling)


Protect the original file

Do not work in the file in Dropbox copy it to your computer and use File > save as > name your file (see below) so you keep the original file safe in case you delete a load of calculating cells by accident


Populate the calculator and get results

  • Add more rows if you need them by copying the content of the calculating rows into a new empty rows.
  • Its important to copy them in or the calculator may not work correctly.


Populate tables to get results

  • Column D & C: Select the elements in column D that your project includes by typing Yes or No in column C
  • Yes in column C turn on the calculation in the remainder of each row.
  • Column E: For each row with Yes in column C hyperlink the Green cells in column E to the equivalent (U-values) cells in your Spreadsheet from Task 6 Elemental U values.
  • Column E: Row 34: change the number of hours of operation from 8 to whatever is appropriate for your building’s use patterns.
  • Columns FG&H: Update the Green cells with size information from your building.
  • Column J: If you need to do a sheet of calculations for other than simple rectangular shapes or many buildings you can overwrite the calculation in the blue cells with total areas instead of columns FG&H
  • Column I: For those elements that repeat add quantities in the green cells.
  • Column K: K5: Accept that below ground temperatures are stable at 11 degrees, unless you have evidence to the contrary.
  • Column K: K11 If your site survey suggests your site outdoor temperature never reached 0 degrees then change outside temperatures to suit.
  • Column M: If your internal temperatures are higher or lower than 20 degrees than change M5 and/or M7
  • Column P: P31 choose the fuel for heating from a drop down menu and choose.
  • Blue cells do the calculations and you get figures related to your building performance
  • Column Q: if the percentages look out of balance or greater than desired, consider revising the performance of any element, by increasing insulation thicknesses or finding better windows and doors with better U values.


Handing it in

  • Hand in at the next lecture, on 2 No. A3 (or A4) landscape paper (to be read side by side);
  • If you plan to use many sheets make sure the font is close to 10 point at A3
  • Staple or footnote each (student name and page number) so they can be found and read together
  • File in dropbox homework folder, at latest midnight the night before the next lecture.


Updating previous tasks

  • If you have updated previous home works add them to their dropbox but add a number before the ‘.’ (starting with 2) for me to consider and improve your score if applicable.


The deadline:

  • Will be midnight 11:59/00:00 the night before the next lecture.
  • Get a good night sleep before the morning lecture
  • Life skill: add it to your electronic diaries with advance warnings and early morning wake up calls, turn off snooze function and get up.
  • But the files that arrive sooner will make me happier as a client.
  • I will collect the last files at 04:00 am on the day of the lecture (this is not your deadline)
  • If you miss the 11:59/00:00 deadline do the work anyway and do it as soon as possible, it will be taken into account in the final score minus points for lateness.


The file naming convention:

  • So that you do not overwrite each other’s work when you drop files into dropbox
  • “Task 9 your given and family name EBB7525 ERIED 2017.xls or xlsx”
  • depending upon the version and software you use.
  • Do not add extra hyphens or brackets or gaps to the file name, do not close gaps that I put there.

Replacing previous homework files with a better one:

  • g. “Task 2 your given and family name EBB7525 ERIED 2017 2.doc” or .docx or .pdf or .xls or .xlsx


DropBox (how dropbox works let column and scroll down)

  • I have opened and added your email addresses to a dropbox and invited you to visit to collect files and deliver files there too.
  • I added subfolders which you will be able to see and I will collect your file and move it to the subfolder as I mark it.
  • Let me know if you still have not had an invite to dropbox.


Scoring: In the weeks context marking is: (5 points)

  • Was it on time?
  • Was it delivered by dropbox?
  • Did the file name adopt the convention?
  • Was it delivered on paper at the lecture?
  • Did it follow the homework brief?


Regards BrianSpecMan

18th March 2017 – 26th March 2017

© GBE NGS ASWS Brian Murphy aka BrianSpecMan
16th April 2016 – 26th March 2017

LSBU EREID 2016 Task 9>10
See Also:

Website page

LSBU EREID PGDip Architecture 2016 G#9905

Homework AssignmentsG#10189

Task 9 > Week 10 Whole Building U Values Energy Carbon

Files in DropBox:

GBE Calculator BuildingUVtoWattsCO2 A06BRM260317.xls

GBE Calculator BuildingUVtoWattsCO2 A06BRM260317.xlsx

LSBU EREID 2017 Task 9 CalculationsWholeBuildingUValuesEnergyCarbon.docx

Task 8 > Week 9 Servicing the building

Task 7 > Week 8 Whole Building EE EC & SC calculation

Task 6 > Week 7 Elemental U-values

Task 5 > Week 6 Elemental Assembly + Materials

Task 4 > Week 5 Elemental Performance

Task 3 > Week 4 Site Analysis

Task 2 > Week 3 Brief

Task 1 > Week 2 CV

Previous year’s feedback

Extract for this homework only


You need to be invited to Dropbox with a valid email address

Let me know if you have still not got access

(how dropbox works let column and scroll down)


  • _ Handout for printing


  • _ Slides for viewing

© GBE NGS ASWS Brian Murphy aka BrianSpecMan
16th April 2016 – 26th March 2017

Leave a Reply