<div dir="auto">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. </div><div dir="auto"><br></div><div dir="auto">Some tabs are automatically getting locked and I am unable to Edit it.</div><div dir="auto"><br></div><div dir="auto">Regards,</div><div dir="auto">Namrata </div><div dir="auto"><br clear="all"><div dir="auto"><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><font face="arial black, sans-serif" size="4" style="font-family:"arial black",sans-serif;color:rgb(0,0,0)"></font></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">Warm regards,</span><br></div><div><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(102,102,102)">Pranati Shroff & Namrata Dhamankar <br></font></div><div><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(102,102,102)">M: 8180027226, </font><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">9767890575</span><br></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)"><br></span></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">E: </span><a href="mailto:info@sprout-green.com" style="font-family:"times new roman",serif" target="_blank">info@sprout-green.com</a></div><div><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(102,102,102)">w: </font><a href="http://www.sprout-green.com/" target="_blank"><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(66,133,244)">www.sprout-green.com</font></a> </div><div>w: <a href="http://www.sustainandsave.com" target="_blank"><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(66,133,244)">www.sustainandsave.com</font></a><br></div><div><br></div><div dir="ltr"><div><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(0,0,0)"><font style="font-family:"times new roman",serif;background-color:rgb(255,255,255);color:rgb(102,102,102)">Sprout & SAS, Office 7,8,9, </font></font></div><div><font face="times new roman, serif" style="font-family:"times new roman",serif;color:rgb(0,0,0)"><font style="font-family:"times new roman",serif;background-color:rgb(255,255,255);color:rgb(102,102,102)">2nd Floor, </font></font><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">Aditya Centeegra, </span></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">F C Road, </span><span style="font-family:"times new roman",serif;color:rgb(102,102,102)">Shivajinagar, Pune- 411004</span></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)"><br></span></div><div><a href="https://www.linkedin.com/company/sustainandsave/mycompany/" style="color:rgb(17,85,204)" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4zJie6Gxxk0AHkJMkZLg1ZVHYKCRQLCRWiOIDVV4braZ59DBdFZBMkHGUDLGzkgphaplTjlRV7N_-2x"></a><span style="color:rgb(34,34,34)"> </span><a href="https://www.facebook.com/sustainandsave/" style="color:rgb(17,85,204)" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4xQZbWMPFwkEN_8yDDFk-CNLdpE6TiqiLzTLHUQkQF1J2fYkrvrZB2OMSttLjcIY2QxBHu7jJCYQa7B"></a><span style="color:rgb(34,34,34)"> </span><a href="https://www.instagram.com/sustain_and_save/" style="color:rgb(17,85,204)" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4wW63cSwHz_3GJ4BmJ7BRndEAXdn-Fcu_c19_t9HIh_RCXZbI03OVMOA3PtR6GEkPJkIOBGn2mrx1Z_"></a><span style="color:rgb(34,34,34)"> </span><a href="https://www.youtube.com/@sustainandsave560" style="color:rgb(17,85,204)" target="_blank"><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4xFUL69CFHok9bJ3MSpUSBI4Bag6olF5YBpyyXM05Cx5QvbMNWn-cvYxXGdHH5SGhhoqtqHHTjnhpSZ"></a><br></div><div><span style="font-family:"times new roman",serif;color:rgb(102,102,102)"><br></span></div><div><br></div></div></div></div></div></div></div></div></div></div></div><div><br></div><div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Tue, 11 Feb 2025 at 2:34 AM, Chris Yates via Bldg-sim <<a href="mailto:bldg-sim@lists.onebuilding.org">bldg-sim@lists.onebuilding.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)"><div lang="EN-GB" link="#467886" vlink="#96607D" style="overflow-wrap: break-word;"><div class="m_8720318909437054089WordSection1"><p class="MsoNormal">Hello again,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’m persevering for some more answers on this!<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’ve also done a 7 minute video to visually explain the issues: <a href="https://youtu.be/GHd72MU8OAc" target="_blank">https://youtu.be/GHd72MU8OAc</a> (it will probably still make sense at 1.5 x speed).<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Any feedback is much appreciated. <u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">TIA/ Chris<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><div><div style="border-width:1pt medium medium;border-style:solid none none;padding:3pt 0cm 0cm;border-color:rgb(225,225,225) currentcolor currentcolor"><p class="MsoNormal"><b><span lang="EN-US" style="font-family:Calibri,sans-serif">From:</span></b><span lang="EN-US" style="font-family:Calibri,sans-serif"> <a href="mailto:chris.malcolm.yates@gmail.com" target="_blank" style="font-family:Calibri,sans-serif">chris.malcolm.yates@gmail.com</a> <<a href="mailto:chris.malcolm.yates@gmail.com" target="_blank" style="font-family:Calibri,sans-serif">chris.malcolm.yates@gmail.com</a>> <br><b style="font-family:Calibri,sans-serif">Sent:</b> 06 February 2025 15:48<br><b style="font-family:Calibri,sans-serif">To:</b> <a href="mailto:bldg-sim@onebuilding.org" target="_blank" style="font-family:Calibri,sans-serif">bldg-sim@onebuilding.org</a><br><b style="font-family:Calibri,sans-serif">Subject:</b> LEED v4 (2024) MEPC spreadsheet<u style="font-family:Calibri,sans-serif"></u><u style="font-family:Calibri,sans-serif"></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Hello all,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’m wondering if I’m alone in finding the LEED v4 (2024) MEPC spreadsheet completely awful to work with.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I suspect some of the issues may relate to localisation: I’m using SI units, and non-energystar related source and GHG factors.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Issues in order of severity:<u></u><u></u></p><ol style="margin-top:0cm" start="1" type="1"><li class="m_8720318909437054089MsoListParagraph" style="margin-left:0cm">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.<u></u><u></u></li><li class="m_8720318909437054089MsoListParagraph" style="margin-left:0cm">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.<u></u><u></u></li><li class="m_8720318909437054089MsoListParagraph" style="margin-left:0cm">Mis-labelling: Cell C9 in Summary tab refers to “total <u>proposed</u> annual use” the columns below are actually reporting the <u>baseline</u><u></u><u></u></li><li class="m_8720318909437054089MsoListParagraph" style="margin-left:0cm">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.<u></u><u></u></li></ol><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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!<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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).<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Many thanks<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Chris<u></u><u></u></p></div></div>_______________________________________________<br>
Bldg-sim mailing list<br>
<a href="http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org" rel="noreferrer" target="_blank">http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org</a><br>
To unsubscribe from this mailing list send a blank message to <a href="mailto:BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG" target="_blank">BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG</a><br>
</blockquote></div></div>