We have finally put together a MEPS Heat Pump to PHPP tool for New Zealand and Australia (MEPS tool). Download here
The Minimum Energy Performance Standards (MEPS) database is part of the Energy Rating Product Database, administered under the joint Australia and New Zealand Equipment Energy Efficiency (E3) program, and serves as the official public database for heat pump (air conditioner) MEPS information in both countries.
The MEPS tool just pulls over the bare minimum of data required for PHI Certification from the MEPS database (three test points for heating and one for cooling). Not every heat pump sold and listed in this database has enough data in the database to meet the PHI data requirements. This MEPS tool is very much an engineer’s hack and simply checks to see if there is enough data and then provides the bare minimum to meet the PHI data requirement. This means that we have data for 3687 heat pumps sold in New Zealand and Australia which can just have the data copied into PHPP with easy directions and a printable page for submitting for local Certifications.
We’ve checked a few cases and it seems to work well and the results for these cases were conservative compared to the full set of manufacturers data.
Please share the link to this page and not the actual file as we will update it here and we want folks to have the latest version.
This free Excel tool uses Filter and Xlookup which may only be available in Excel 2021 and later.
The authors of this tool have used their best efforts to provide accurate and authoritative information in regard to the subject matter covered. While reasonable care has been taken to provide accurate information, the author(s) and Sustainable Engineering Ltd make no warranty of any kind, expressed or implied, with regard to the information provided being suitable for any particular purpose. The information presented must be used with care by professionals who understand the implications of what they are doing. The author(s) and Sustainable Engineering Ltd shall not be liable in the event of incidental or consequential damages in connection with, or arising from, the use of the information contained in this course.