<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Gill Sans MT";
panose-1:2 11 5 2 2 1 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;
position:relative;
top:0pt;
mso-text-raise:0pt;
letter-spacing:0pt;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Dan,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I believe the approach you may
be looking for information on is called <i>Bin Analysis</i> or <i>Modified Bin
Analysis</i>. With this approach, you can use spreadsheets to estimate
energy use based on the number of hours each year an area spends within a
temperature bin. Correlations between weather-dependent loads (ventilation
CFM, CHW loads, HW loads) can be estimated, or better yet, calibrated using building
trends or metered data.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>More complex bin models can
include detailed envelope calculations, occupancy and internal load diversity schedules,
and regressions that estimate chiller, heat rejection, fan and pump energy
based on part-load performance data obtained from manufacturers or metered data
(existing buildings) and good engineering judgement. In my experiences,
it isn’t uncommon to have an ‘occupied’ and ‘unoccupied’
bin model for the same project.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You may be able to find some
ASHRAE literature on the topic on the internet or through libraries. Unfortunately,
I don’t have any examples at hand that I can provide to you for your
review.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>John<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='color:#1F497D'>John T. Forester, </span><span
style='color:#568E14'>LEED AP BD+C</span><span style='color:#1F497D'><br>
Demand Management Institute<br>
35 Walnut Street<br>
Wellesley, MA 02481<br>
Phone: 781 431 1100 x14<br>
Fax: 781 431 1109<br>
email: <a href="mailto:jforester@dmiinc.comweb">jforester@dmiinc.com</a><br>
web: <a href="http://www.dmiinc.com/">www.dmiinc.com</a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
bldg-sim-bounces@lists.onebuilding.org
[mailto:bldg-sim-bounces@lists.onebuilding.org] <b>On Behalf Of </b>Daniel
Croisant<br>
<b>Sent:</b> Monday, February 22, 2010 4:50 PM<br>
<b>To:</b> bldg-sim@lists.onebuilding.org<br>
<b>Subject:</b> [Bldg-sim] Estimating Energy Consumption Using Spreadsheets<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hello,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I’ve “grown-up” in the time when energy
modeling programs always existed. I’m curious if anyone that has
been in the business for awhile has any experience using spreadsheets to
estimate a building’s energy consumption, and if so, would you be so kind
as to share them with me? I’m not looking to use it on any projects
and would not try to hold anyone liable for any results. I’m just
curious as to how people tackled the issue of estimating energy usage, other
than degree days, before the popularization of DOE and other energy modeling
programs. Plus I think it would just be fun to play around with what
other people have used. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thank you in advance,<o:p></o:p></p>
<p class=MsoNormal style='line-height:13.0pt'><b><span style='color:maroon'>Dan
Croisant</span></b><span style='font-family:"Gill Sans MT","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:#333333'>Mechanical Design Engineer</span><span style='font-size:9.0pt;
font-family:"Gill Sans MT","sans-serif";color:#333333'> | LEED AP</span><o:p></o:p></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:#333333'>Direct 262.522.4414 </span><o:p></o:p></p>
<p class=MsoNormal style='line-height:13.0pt'><o:p> </o:p></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:maroon'>I B C ENGINEERING SERVICES, INC. <o:p></o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:gray'>N8 W22195 Johnson Drive, Suite 180
<o:p></o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:gray'>Waukesha, Wisconsin 53186 </span><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:gray'>T 262.549.1190 : : F 262.549.1620 </span><span
style='font-size:9.0pt;font-family:"Gill Sans MT","sans-serif";color:gray'><o:p></o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='font-size:9.0pt;
color:gray'><o:p> </o:p></span></p>
<p class=MsoNormal style='line-height:13.0pt'><span style='color:maroon'><a
href="blocked::http://www.ibcengineering.com"
title="http://www.ibcengineering.com"><span style='color:maroon'>www.ibcengineering.com</span></a></span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>