Before you buy please check your computer meets these Minimum Requirements. You will need:

  • a Windows computer, i.e. a PC (some have also run it on a Mac running Parallels, with the PC version of Excel installed)
  • Microsoft Office 2010 or later
  • A recent version of PHPP, v9.6, v9.3, v9.1 or v8.5. All these versions are supported in PHribbon v2, however we still recommend using v9.6 in order that you have an accurate PHPP. You can buy PHPP from the AECB shop or if you have version 9.1 or 9.3 the Passivhaus institute provides a free upgrade to version 9.6. To get it please contact their main enquiries number +49 615 182 6990 or email phpp @ (no spaces)

To buy PHribbon please email with the 4 digit number described below and the options you would like. The 4 digit number is part of a registration process used to create your licence key, to get the number please open this FindSerialNum spreadsheet and press the button. This just reads a unique code on your computer, it makes no changes whatsoever. The options to choose from are:

  • £45 Base module
    Required for all options, includes buttons 1-5, 7, 12, 13
  • £30 Costing module
    Indicative costs for retrofits, buttons 9-11 incl Variants and Step by Step
  • £75 Daylight Factor module
    Separate Spreadsheet written by Mark Siddall of LEAP and automatic data transfer from PHPP
  • £60 New! Embodied CO2 module released Oct 2019
    Calculates retrofit or construction CO2 using areas from your PHPP
  • International Version
    Same options and prices as above. Omits the UK climate tool and if the costing module is chosen the user would need to replace costs with those for their own area in their own currency

Software will distributed by Dropbox to enable updates to be sent to you automatically. Once you have the software you will need to enable macros, macros are already part of PHPP v9.6 variants version written by the Passivhaus Institute. You can enable them each time you open a spreadsheet that uses them. Enter the licence key at the top of the install tab. If you change your computer in the future, that’s no problem, a new code can be sent to you free of charge.



There are 3 parts to the training: training videos, question and answer seminars and a user guide.
Feedback is very welcome, we are continually striving to improve our user experience. Occasional improvements may be necessary from time to time.

1. Training Videos for v2
Build PHPP part 1 (same as the video on the PHribbon page)
Build PHPP part 2, Daylight Factor, Graph variants, TBs
Latest features in v2.28, 15min version of the 3min intro video

Daylight Factor – Mark Siddall’s training for his daylight factor spreadsheet

Embodied CO2 Full LCA part 1: background and adding U-values
Embodied CO2 Full LCA part 2: windows, extra elements and yellow cells
Embodied CO2 Full LCA part 3: battens, stud walls, roof finishes and updating the calculation
Embodied CO2 Full LCA part 4: checking the calculation and explanation of formulas
(The U value name check mentioned in part 4 is added in v2.25)

Retrofit Costs, ‘Simple’ option
Retrofit Costs, ‘Variants’ and ‘Step by Step’ options

2. PHribbon Seminars
We are now having question and answer seminars for PHribbon once a month, last Friday of the month at 2pm.
The next one will be on Friday 27th March at 2pm.
Please contact Tim Martel if you’d like to join that so he can send you a link.

3. User Manual
A user manual is provided with the software and can be accessed through the menu. Another copy is available here
RibbonHelp v2.22
Ribbon New Features in this version v2.22


Licence Agreement Terms and Conditions

By using this software you agree to these terms:

  • Users may not redistribute the PHribbon spreadsheet, or repackage it free of charge or otherwise.
  • The software has been rigorously tested and great care has been taken to ensure there are no errors, however not every situation in which PHPP can be used can be foreseen, therefore checks for costs are still recommended. Any mistakes found will be corrected free of charge and all users updated. The user is responsible for checking the figures, especially in circumstances where they are critical. In extreme circumstances the maximum compensation will be a refund of the price paid for the software. By using this software you agree that no legal claim can be made against the AECB nor Tim Martel.
  • Costs provided are indicative only and are the best information available to the author. By their very nature they are variable according to location, supplier and quantity. They serve only as a starting point and can be updated at any time either for one project (i.e. changing the figure in the costs tab in the PHPP) or by changing the master table for all future projects in the PHribbon spreadsheet.
  • The price of the software includes a short software manual and free training videos. There are also free question and answer seminars on a monthly basis. Minor updates may be available from time to time free of charge. Revisions of the thermal bridge library and various other libraries will be made available if funds from sales allow.