Bugs in LEED MEPC spreadsheet

edit

Hello,

Please excuse the cross-posting. I’m wondering if I’m alone in finding the LEED v4 (2024) MEPC spreadsheet buggy to work with.

I’ve done a 7-minute video to visually explain the issues: https://youtu.be/rG2pgtjdRrs (it will probably still make sense at 1.5 x speed).

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. It's still causing a major headache though - our LEED consultant, understandably, is very nervous.

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 Yates