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:

GBE Green Building Calculator Project Revisions A13 BRM 250520 PNG

Version 1

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

GBC Data Sources:

GBC Data Sources V2 A16 BRM 210121 PNG

Version 2

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

GBC Green Building Calculator
GBC ScreenShot Calculator

GBC Schedule of Accommodation:

GBE Green Building Calculator Schedule Accommodation A13 BRM 250520 PNG

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

GBC Sched Accom V2 A16 BRM 210121

Version 2

• Drop Down menus
• More optional cells

GBC Room by Room Schedule of Accommodation

GBE Green Building Calculator Room By Room Losses A13 BRM 250520 PNG

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:

GBE Green Building Calculator Form Factor A13 BRM 250520 PNG

Version 1

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

GBC FormFactor V2 A16 BRM 210121 PNG

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

GBE Green Building Calculator Building Elements Areas A13 BRM 250520 PNG

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.: 

GBE Green Building Calculator Compare Choose UValues A13 BRM 250520 PNG

• 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:

GBE Green Building Calculator Insulation kValue Thickness PNG

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

GBE Green Building Calculator Decrement Delay A13 BRM 250520 PNG

Version 2

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

GBC Legend & Terms:

GBE Green Building Calculator Legend A13 BRM 210520 PNG

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

GBE Green Building Calculator Elements B of MQTRC A13 BRM 210520 PNG

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:

GBE Green Building Calculator Resistances A13 BRM 210520 PNG

Version 1 (unlikely to be updated)

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

GBC Conductivities:

GBE Green Building Calculator Conductivities A13 BRM 250520 PNG

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:

GBE Green Building Calculator Products Properties A13 BRM 250520 PNG

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

GBC Profile To Volume V2 A16 BRM 210121

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:

GBE Green Building Calculator Secondary Elements A13 BRM 250520 PNG

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

GBC Bespoke B1 EH A16 BRM 210121

GBC Secondary Element Upgrades VB1 131020

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:

GBE Green Building Calculator Elements Summary A13 BRM 210520 PNG

Version 1

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

GBC Elements Summary V2 A15 BRM 240920

Version 2

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

GBC UToWattsToCO2:

GBE Green Building Calculator U To Watts To CO2 A13 BRM 210520 PNG

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:

GBE Green Building Calculator Carbon In Fuel A13 210520 PNG

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:

GBE Green Building Calculator CostPerm2 Converter A13 BRM 250520 PNG

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:

GBE Green Building Calculator Supplier Request A13 BRM 250520 PNG

Version 1

• Used to request information on products from manufacturers or suppliers

GBC Man Sup Request V2 A16 BRM 210121

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

GBE Whole Building EE + EC + SC Calculator

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

GBC Version 2 EE EC SC Calculator

GBC Elemental EE EC SC V2 A16 BRM 210121 PNG

Version 2

• Added new function

GBC Life Cycle Assessment Environmental Product Declaration

GBC Elemental LCA V2 A16 BRM 210121 PNG

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.