[Bldg-sim] LEED v4 (2024) MEPC spreadsheet

Thu Feb 13 02:07:12 PST 2025

GBCI got back to me to acknowledge the issues. Thank goodness.

It took them 3 days, so not a bad turnaround.

From: Sprout Info_Mail <info at sprout-green.com> 
Sent: 11 February 2025 15:42
To: chris.malcolm.yates at gmail.com
Cc: bldg-sim at onebuilding.org
Subject: Re: [Bldg-sim] LEED v4 (2024) MEPC spreadsheet

Thanks Chris for putting great efforts to compile the issues in a video. I too am facing the similar issue with the sheet since last week and your email came at just the right time. 

Some tabs are automatically getting locked and I am unable to Edit it.

Regards,

Namrata 

Warm regards,

Pranati Shroff & Namrata Dhamankar 

M: 8180027226, 9767890575

E:  <mailto:info at sprout-green.com> info at sprout-green.com

w:  <http://www.sprout-green.com/> www.sprout-green.com   

w:  <http://www.sustainandsave.com> www.sustainandsave.com

Sprout & SAS, Office 7,8,9, 

2nd Floor, Aditya Centeegra, 

F C Road, Shivajinagar, Pune- 411004

 <https://www.linkedin.com/company/sustainandsave/mycompany/>    <https://www.facebook.com/sustainandsave/>    <https://www.instagram.com/sustain_and_save/>    <https://www.youtube.com/@sustainandsave560> 

On Tue, 11 Feb 2025 at 2:34 AM, Chris Yates via Bldg-sim <bldg-sim at lists.onebuilding.org <mailto:bldg-sim at lists.onebuilding.org> > wrote:

Hello again,

I’m persevering for some more answers on this!

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

Any feedback is much appreciated. 

TIA/ Chris

From: chris.malcolm.yates at gmail.com <mailto:chris.malcolm.yates at gmail.com>  <chris.malcolm.yates at gmail.com <mailto:chris.malcolm.yates at gmail.com> > 
Sent: 06 February 2025 15:48
To: bldg-sim at onebuilding.org <mailto:bldg-sim at onebuilding.org> 
Subject: LEED v4 (2024) MEPC spreadsheet

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

_______________________________________________
Bldg-sim mailing list
http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org
To unsubscribe from this mailing list send  a blank message to BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG <mailto:BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20250213/cb84741d/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD0000.jpg
Type: image/jpeg
Size: 823 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20250213/cb84741d/attachment.jpg>