GBC ScreenShots Calculator V1 + V2

GBE > Encyclopaedia > Files > Calculators > Whole Building Calculators > G#38796

GBC ScreenShots Calculator V1 + V2
About:

---

GBC ScreenShots:

• Some of the worksheets are to some degree stand-alone, but most are also interlinked within this one spreadsheet so decisions made on earlier worksheets feed into later worksheets to carryout calculations.
• Later worksheets require more information or decisions by the user to make use of the earlier decisions, in more calculations.
• One sheets “UToWattsToCO2” require few inputs by the user, it assembles and calculates most things for you, you only need to choose the fuel source.
• The user is required to assess the results and decide if they wish to reconsider earlier decisions and go back to adjust values and to instantaneously improve the overall results.

---

GBC Welcome:

• Version 1

 

• Version 2
  • Added Award Logos
  • Added Links to website content

---

GBC About:

• This page, is about the scope and ambitions of this Calculator

---

GBC Development:

• Described what the calculator is about and how parts interact and future development

---

GBC Instructions:

Version 1

• Line by line or cell by cell instructions to edit the worksheets to make them project specific
• Cells to populate or change are highlighted for speed to navigation across many worksheets

Version 2

• Checked currency of all cell locations
• Checked currency of instructions
• Added more instruction for more functions and new calculators

---

GBC Cell Colour Code Legend:

Version 2

• Colour coded cells to help uses to identify which cells:
  • to populate by user
  • have drop down lists to choose from
  • are automatically worked out but can be changed by the user
  • automatically work out and should be avoided by user
• Conditional formatting cell colours: Yes, ?, No
• Editing Aide memoir symbols

Version 20 (or sooner?)

• BIM App version of legend

---

GBC Revisions:

• Record of changes and levels of completion during development by GBC
• Aimed at enabling audit trails back through the updates

---

User’s Project Revisions:

Version 1

• Keep your own records of application of GBC in projects for your own audit trails

---

GBC Data Sources:

Version 2

• Schedule of data sources used by GBC to compile the calculator

---

GBC Green Building Calculator
GBC ScreenShot Calculator

---

GBC Schedule of Accommodation:

Version 1

• Campus, Estate:
  • Number of Buildings
• Whole Buildings:
  • Number of Floors
  • Size of buildings or floors
  • Building Temperatures
  • Building Hours of occupation
• Individual rooms:
  • Room temperatures
  • Room hours of operation

Version 2

• Drop Down menus
• More optional cells

---

GBC Room by Room Schedule of Accommodation

Version 1

• Users add sizes, hours of operation, design temperatures, inside and out
• It works out areas and volumes,
• ‘Room by room heat loss’ calculator to determine radiator or under floor heating requirements

Version 2

• Or start with a boiler size and work out how much insulation is needed to ensure the boiler is enough

---

GBC Form Factor:

Version 1

• A quick analysis of the building form factor and set target U values to respond to them.

Version 2 features added or developed:

• Added Terraces for community scale projects
• Correlation between form factor and insulation thicknesses
• Choose insulation material to see required insulation thickness
• Form Factor including for dormers, bay windows, porches, conservatories, oriel windows, colonnades, etc.

---

GBC Building Elements Scope:

Version 1

• Basic scope of 29 elements 12 Sub-elements in external envelope
• Users identify which apply to their projects with Yes/No

Version 2

• Over 100 elements including:
• Historic building elements
• Terraces
• Non-external envelop elements
• Domestic Services
• Furniture
• Landscape
• Non-Domestic elements
• Preparations for later versions

---

GBC Building Element Area Calculations

Version 1

• List of 29 building elements and 12 secondary-elements in the external envelop
• The user adds their respective dimensions and areas missing from the schedule of accommodation

• To accommodate a multitude of secondary element sizes, an additional schedule is included

Version 2

• Increased to over 100 Building Elements:
• additional Building Envelope Elements
• Non-Building Envelop Elements
• Structure
• Services
• Finishes
• Furniture
• Landscape
• Infrastructure

---

GBC U values Etc.: 

• Version 1
  • Comparisons between Regulations, Design Standards, Campaigns
  • Building Regulations (E, W and others), FEES,
  • Design Standards: Energy Standards, AECB carbonLite, Passivhaus, EnerPHit, EAMs, etc.
  • Including: U values, Airtightness, Form factors, Primary Energy, Glazing %, Orientation, etc.
  • Allowing users to choose and apply chosen set of targets to projects.

• 

  GBC UValue Etc V2 A16 BRM 210121

  Version 2

  • Rationalised order
  • Added more Envelop Elements
  • Added: Scottish, Welsh TAN6, TfL, etc.
  • Plan to turn into Drop Down List with Look up table

---

GBC Insulation: Material k to U Value Thicknesses

Wide view:

Close up:

Version 1

• Lists of insulation materials organised by material groups, format sub-groups with best average and worst k values
• Applying the chosen U values this provides an instant comparison of insulation materials and thicknesses

Version 2

• more insulation materials, densities and more k values

---

GBC Insulation: Materials to Decrement Delay

Version 2

• Includes the first stages of development of the Decrement Delay calculator (incomplete)

---

GBC Legend & Terms:

Version 1

• Legend of cell colour codes, cell fills and Schedule of terms and insulation materials to help understanding
• Not a functioning part of the calculator (incomplete)

Version 2

• Added all element codes

---

GBC Elements:  Assemblies of Components & U value

Version 1

• Detailed descriptions of 24 of 29 potential elements and 12 secondary-elements making up the external envelop of a building and includes their functional components
• Allows the user to choose elements and assemble them by choosing their combination of functional components and then choosing the materials for each component.
• Where possible a default size is added and where necessary the user adds insulation and other component thicknesses.
• Using each materials k values and set resistances it calculates all of the R and U values automatically

• 

  GBE Green Building Calculator Elements U values A13 BRM 210520 PNG

  Costs of insulation and windows are added here to help persuade architects and clients to spend money on insulation and higher performance windows and glazing

 

Version 2

• 5 external envelop elements added
• Total over 100 Elements
• Added retrofit options: Drop Down List
  • Exiting unchanged, reclaim and repair and reinstall, remove, etc.

---

GBC Elements: Bill of Materials Quantities Costs

Version 1

• Only addressed Insulation and Glazing

Version 2

• Bill of materials, quantities, labour and costs
  • Components, Elements, Whole Buildings
  • Based on building fabric initially
  • Domestic Services started
• Enables recording Cost data
  • Determined by own searches by the designer
    • In time Cost Planning by any designer
  • Enables Tendering by Constructors
    • Automatic totalling to avoid errors

---

GBC Resistances:

Version 1 (unlikely to be updated)

• Is an information resource for default surface and cavity resistivity
• ‘Elements’ link to values from here

---

GBC Conductivities:

Version 1

• Is an information resource for the calculator to interrogate
• Materials and their properties for use in Components of ‘Elements’
• The user can copy and paste information manually into ‘Components’

Version 2

• Drop Down Lists developed
• Look up tables to be established
• Automated cell population to be implemented
• Developed as a look up table to automatically populate Component of ‘Elements’
• More materials datasets to be added from literature and LCA EPD

---

GBC Products:

Version 1

• Lists of Products with characteristics,

Version 2

• To be develop into a Look Up Table to populate Components of Elements
• More Product Datasets to be obtained by
• More Product Datasets to be added from literature and LCA EPD, BIM Libraries
• Manufacturer Supplier Request created to collect data see below

---

GBC Insulation Cost Thickness:

Version 0

• Is an information resource for materials, their properties and costs for use in Components of ‘Elements’
• The user can obtain their own information or copy information manually
• Its is being developed as a look up table to automatically populate Component of ‘Elements’

Version 1

• Redundant

---

GBC Section Profile > Area > Volume Calculator

Version 2

• Converter
• Not part of calculator
• Solid and Hollow sections
• Rectilinear and Circular
• Building Components
• Services Components
• Cable, Pipes and Ducts

Version 3

• More complex cable sections to add
• Other Profiles to add

---

GBC Secondary Elements Costs:

Version 1

• Is an information resource for secondary elements (Windows doors rooflights) and their properties for use in Components of ‘Elements’
• The user can obtain their own or copy and paste information manually

Version 2

• Its is to be developed as a look up table to automatically populate Component cells of ‘Elements’

---

GBC Secondary Element Upgrades

Bespoke Development

• Window Upgrade Options
• Initial and Running Costs
• Embodied Carbon and In use Carbon
• Waste diversion, embodied energy and Carbon in waste

---

GBC Element Summery:

Version 1

• Summarises 24 of 39 Elements and 12 Secondary Elements calculated U values,
• Compares with targeted U values, highlighting any shortfalls

---

Version 2

• Over 100 elements listed
• Non External envelop element
• More elements added

---

GBC UToWattsToCO2:

Version 1

• Assembles elemental areas and U values
• Calculates energy losses from each element and total secondary elements to give total losses
• Calculated each as a % of the whole so comparisons can be made by the user
• Enables reconsideration of earlier decisions
• Particularly useful is the comparison of basement, walls, roofs, floors and all glazing

Version 2

• Over 100 elements listed
• Non-external envelope elements added

---

GBC FuelCarbonFactor:

Version 1

• Is an information resource developed as a look up table used by ‘UToWattsToCO2’

Version 2

• More fuel Choices
• Updated CO2 in fuels to match today’s statistics
• Added Fuel costs to carry out running costs analysis
• Carbon back periods not just cost pay back periods
• Value Engineering scenarios possible

---

GBC Cost Per m2:

Version 1

• This is a converter:
• If the information provided by Manufacturers/Suppliers is not in £/m2
• This will help with converting the information provided to the required format

---

GBC Drop Down Lists:

Version 1

• Used to populate cells with readymade answers to avoid typing, avoid errors and limit choices
• Lists can be added to, as long as the last two cells remain at bottom of sets

Version 2

• Many more lists developed to allow preparation for versions 3 & 4
• Drop down lists highlighted in worksheets

---

GBC Manufacturer Supplier Request Letter:

Version 1

• Invites sharing of product datasets

Version 2

• Additional data sets required for new functions
• Added guidance on use of form

GBC Manufacturer Supplier Request Form:

Version 1

• Used to request information on products from manufacturers or suppliers

Version 2 

• Making the Form more intelligent for the data providers
• Help populating cells:
  • Many more ‘drop down lists’ to choose from multiple choices
  • Limiting choices, avoiding typos
• Added more datasets to be completed
• Preparing the way to engage with version 3 & 4 ambitions

---

GBC Condensation Check:

• To be developed (Version 2 or 3?)

---

GBC EE EC SC Calculator: Separate Calculator Initially

• To be developed: Embodied Energy Embodied Carbon Sequestered Carbon calculator

GBC Version 2 EE EC SC Calculator

Version 2

• Added new function

---

GBC Life Cycle Assessment Environmental Product Declaration

Version 2

• New Function added
• for over 100 elements
• Elements and their component
• Life cycle stages and their emissions
• Engages with LCA EPD datasets to populate cells

Version 3

• More LCA EPD datasets
• Summary Sheets

---

GBC Readymade Competent Elemental Assemblies

• Version 3-4 To be developed:
• 892 Competent Elemental assemblies ready to use in Excel
• Building fabric, Envelop, Interior and Landscape
• Passivhaus U values (R values)
• EE EC SC and LCA
• To allow rapid impact awareness and carbon literacy

---

GBC User Feedback

• An opportunity for users to highlight any problems or opportunities for improvements

---

GBC User Survey

• There are many planned stages of development, have we go the order right?
• What are your ambitions and priorities?

---

© GBE GBC GBL NGS ASWS Brian Murphy aka BrianSpecMan **
31st October 2020 – 3rd June 2021

GBC ScreenShots Calculator
See Also:

---

GBE Satellite Website

• https://GreenBuildingCalculator.uk

---

GBC Green Building Calculator

• GBC About (Calculator) G#
• GBC ScreenShots (Calculator) G#38796
• GBC Development Versions (Calculator) G#38792
• GBC Features Benefits (Calculator) G#38788

---

GBC Case Studies

• Architectural Competition Entry

---

Building Type Analysis

---

Bespoke GBC Developments

---

GBE CPD

• GBC CPD Green Building Calculator PDF Show
  • GBC CPD Green Building Calculator A00 BRM 300612 PDF

---

GBE Past Event

• SPAB STBA Conference 2020 (Event) G#38634

---

GBE Shop

• GBE Green Building Calculator Big Practice (Shop) G#38525
• GBE Green Building Calculator Small Practice (Shop) G#38524
• GBE Green Building Calculator Student (Shop) G#38520

---

GBE Video

• Green Building Calculator V0.0.0.

---

GBE Projects

• CAP’EM and CAP’EM Compass
• Interreg funded project to develop an LCA & EPD method and Tools,
• https://GreenBuildingEncyclopaedia.uk/?p=546

---

GBE Calculator

Psi calculation

• https://GreenBuildingEncyclopaedia.uk/?p=14582

• GBE Waste Cost lite calculator
• https://GreenBuildingEncyclopaedia.uk/?p=531

Whole Building Calculators

• GBE shop
• https://GreenBuildingEncyclopaedia.uk/?p=11095
• It proved challenging for the students but they persevered and succeeded.
• GBE Embodied Energy, Embodied Carbon and Sequestered Carbon Calculator (EE EC SC)

GreenGauge Advanced Details

• (Thermal bridge & Psi values)
• https://GreenBuildingEncyclopaedia.uk/?p=25033

GBE Datasets

• ICE for (EE EC SC Database v3) (currently using 1.6)
• ICE Database (Jargon Buster) G#1018 N#1037

Thermal Mass Calculator

• https://GreenBuildingEncyclopaedia.uk/?p=16163

LCA and EPD datasets

• Renuables
• https://GreenBuildingEncyclopaedia.uk/?p=17689

Decrement Delay

• (overheating prevention)
• https://GreenBuildingEncyclopaedia.uk/?p=31148 

Condensation Check

---

© GBE GBC GBL NGS ASWS Brian Murphy aka BrianSpecMan **
31st October 2020

GBC ScreenShots Calculator G#38796 End.