AECB PHribbon is a set of tools that run from an extra ribbon tab in Excel, just like ‘Insert’ or ‘Page Layout’. It includes the Window Tool and is available with or without REALcosting (Retrofit Economics).
• works within PHPP exactly like any other toolbar
• for new buildings and retrofits
• Simple, Variants and Step by Step retrofit costs
• designed for PHPP v9.6, beta versions available for v9.1 and 9.3. PC only.
1 Select Climate. Selects your climate region from a standard or a detailed map and helps you enter other site data
2 U-values. 30 standard U-value construction build-ups you can use and edit
3 k-values. Choose build ups of k-values from a library, with links to BBAs to download
4 Window Tool. window tool calculates d reveal and enters the dimensions, ‘1’s and ‘0’s, and name
5 Graph Variants. adds a “Graphs” tab and graphs variants broken down by building element: walls, roof, etc so you can compare
6 Simple Adds retrofit costs of just the current PHPP
7 Variants Adds retrofit costs for each variant. Each variant is a separately costed option
8 Step By Step Uses variants for costs, each represents a stage in a series of steps. Also known as incremental retrofit
View/Edit the various libraries
9 U-values. Goes to the U-value tab to allow you to modify the U-values library
10 k-values. Goes to the k-value tab to allow you to modify the library
11 Costs. Goes to the RCosts tab so you can modify standard costs, or typical options
12 TBs. Goes to the Thermal Bridges library
Some screen shots are shown below.
The two parts of the dialogue below help you enter climate, orientation and other site related data.
Choose your climate from either the standard map or one with county boundaries.
Choose U-value build-ups from a library of up to 30. Copies to and from the library, can also set up 6 variants.
Choose build ups of k-values from a library, with links to BBAs to download. The categories on the left can be used to filter suitable options.
The window tool helps you add windows by entering much of the data for you, the dimensions, ‘1’s and ‘0’s, d reveal and name. It uses frame dimensions from the components tab. The d reveal is entered as a formula so it will update if you change the window or frame dimensions.
Retrofitting insulation into houses improves comfort, reduces running costs and saves CO2. PHribbon software allows users to try out retrofit measures and see the impact on energy and cost. It has all the features previously in ‘REALcosting’, with dialogues to obtain indicative costs for your projects.
PHribbon is used with the latest version of Passivhaus Planning Package (PHPP sold separately by AECB).
REALcosting has been rewritten into 3 buttons that work directly in your PHPP: (6) without variants, (7) using Variants and (8) where each variants is a step of a retrofit. For each a costs tab is added to your PHPP and is custom written in front of you, it only contains the rows and columns relevant for your PHPP. Cells are entered as formulas so that as you develop your PHPP, the results change (though some large changes may require a re-run). It has all the features previously available in the various versions of REALcosting in one place, including co-benefits.
Typically about 10 dialogues take you through costs for each of the U-value constructions, windows, services and some miscellaneous items. One of the dialogues is shown below on the completed sheet. Costs come from a central library of rates that can be edited and most quantities are determined from PHPP.
Part of the Thermal Bridge Library is shown below, showing the construction build up for each calculation. Psi values are given for several different thicknesses of each configuration.
£45 for PHribbon without retrofit costing
£75 for PHribbon with retrofit costing (simple, variant and Step-By-Step versions)
Prices include a manual and support.
For enquiries or to purchase please contact Tim, details below.
Training sessions are being arranged, please contact Tim. PHPP training is separately available from the AECB.
Contact Tim by email at firstname.lastname@example.org or by phone on 01453 759466 / 07531 288147.