I’ve updated my technique for using Revit with PHPP. The previous workflow used walls to create a schedule that could be exported to PHPP. The obvious limitation is that it doesn’t work for roofs and floor slabs. The new technique uses curtain panels hosted on a mass object.
Create an in-place mass representing the thermal envelope. Do not include elements that are outside the thermal envelope, like a rainscreen or a parapet. A mass is useful to give you the gross volume and surface-to-volume ratio. And if you start modeling the building with the conceptual mass, then there is little extra work involved.
Host a curtain system on the mass using a simple curtain panel style. If you make changes to the mass, you will have to update the curtain system by selecting it and clicking on “Update to Face”. Assign the mass and curtain system to a future phase called “Energy Modeling” so that they don’t interfere with scheduling other building components.
Set up instance parameters for the curtain panels that match the required PHPP inputs. Create a schedule for the PHPP areas.
Export the schedule as a delimited text file with the default options.
R > Export > Reports > Schedule
Open PHPP and the text file in Excel. Accept the default options when opening the text file in Excel. Link the PHPP cells to the exported schedule. You can delete the text file. Excel will maintain the values when the linked file is deleted.
What’s missing is an automatic way to determine the orientation of the walls and windows. You can create a curtain panel that knows its orientation via a reporting parameter. See this video. However, this only works, as far as I know, with pattern-based curtain panels, so it isn’t as useful as having a curtain system hosted to a mass object.