LSBU EREID 2017 Task 9

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

GBE > G#15320

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 BrianSpecMan@icloud.com

18th March 2017 – 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

https://greenbuildingencyclopaedia.uk/?p=15320

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

https://greenbuildingencyclopaedia.uk/?p=15324

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

https://greenbuildingencyclopaedia.uk/?p=11023

Task 6 > Week 7 Elemental U-values

https://greenbuildingencyclopaedia.uk/?p=10450

Task 5 > Week 6 Elemental Assembly + Materials

https://greenbuildingencyclopaedia.uk/?p=10401

Task 4 > Week 5 Elemental Performance

https://greenbuildingencyclopaedia.uk/?p=10290

Task 3 > Week 4 Site Analysis

https://greenbuildingencyclopaedia.uk/?p=10189

Task 2 > Week 3 Brief

https://greenbuildingencyclopaedia.uk/?p=10033

Task 1 > Week 2 CV

https://greenbuildingencyclopaedia.uk/?p=9967

Previous year’s feedback

Academic Comments on Student Submissions G#1023 N#1042

Extract for this homework only

3 AcademicCommentCourseworkSubmissions Survey

DropBox

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)

Lectures

_ Handout for printing

_ Slides for viewing

Tags: