LEED v4 (2024) MEPC spreadsheet

4 posts / 0 new
Last post

Hello all,

I'm wondering if I'm alone in finding the LEED v4 (2024) MEPC spreadsheet
completely awful to work with.

I suspect some of the issues may relate to localisation: I'm using SI units,
and non-energystar related source and GHG factors.

Issues in order of severity:

1. In Performance outputs tab, PRM compliance report table, GHG
emissions not picked up for purchased heat or chilled water. GHG emissions
in Summary tab are mis-reported as a result.
2. Intermittent locking of the GHG source combo box in Performance
outputs tab, table 1 "Energy sources". Sometimes it lets you change it from
"Energystar". Other times it doesn't.
3. Mis-labelling: Cell C9 in Summary tab refers to "total proposed
annual use" the columns below are actually reporting the baseline
4. Generally speaking, using the "add rows" button does not fill me
with confidence. It partially crashes the clipboard (no marching ants after
use) and if it fails, then you've got a broken spreadsheet.

I got around the GHG reporting by using the older EAP spreadsheet to report
cost, source, and GHG. I included this in the LEED submission, along with
the MEPC (warts and all), and a bug report.

However, all this shenanigans has left the LEED AP overly concerned about
the submission - they're pressing me to release all my models so they can do
a third party review!

It would be very helpful to get other modeller's experience of using this
spreadsheet - especially with a similar localisation (SI units and local
source/ GHG factors).

Many thanks

Chris

Chris Yates2's picture
Offline
Joined: 2011-10-02
Reputation: 0