<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18372">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Gill Sans MT;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
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 dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Dan:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>As much as I LOVE to spend time (billable?) creating complex
and clunkly fragile spreadsheets to meet my own rapid prototyping energy
analysis needs, I feel obligated to caution you to think very carefully about
economics before using heading down a path of using a spreadsheets developed by
'others' as a basis for much of anything. Your time might be better spent
studying and exploring what is 'beneath the hoods of popular and well documented
whole building energy simulation programs. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Having said that, I strongly believe anyone seriously
interested in mastering skills for estimating building energy should have a
strong understanding of the many available tools, and an awareness of the
evolution of those tools. (*How did we get here?) I can share a few
of my favorite resources developing an understanding of alternatives to 'full
blown' 8760 analysis tools and how they work. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010></SPAN><SPAN
class=906353003-23022010><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>1) ASHRAE RP-363: If you are an ASHRAE memeber, consider
downloading RP-363 documentation (ASEAM). This text lays out the methodologies
for estimating loads, systems, plants, control strategies and so forth. It's an
'oldie but a goodie'. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Login -> Bookstore -> Papers and Articles -> Memebers
Only Free Access to Research Projects, Final Reports, </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Search for the term "363" - you are looking for this:
</FONT></SPAN><SPAN class=906353003-23022010>RP-363 -- Upgrading Documentation
of the Proposed TC 4.7 Simplified Energy Analysis Procedure </SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Chapter One has a nice section laying out the foundations for
some alternatives to hourly analysis, as well a discussion on limitations. If
you REALLY want to build your own spreadsheet model for estimating building
energy consumption, this book should be in your arsenal. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>2) Volume 1 and Volume 2 of the "<FONT size=2 face=Arial><FONT
size=2 face=Arial>ARCHITECT'S AND ENGINEER'S GUIDE TO ENERGY CONSERVATION IN
EXISTING BUILDINGS"</FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.wbdg.org/ccb/DOE/TECH/doe_v1.pdf">http://www.wbdg.org/ccb/DOE/TECH/doe_v1.pdf</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.wbdg.org/ccb/DOE/TECH/doe_v2.pdf">http://www.wbdg.org/ccb/DOE/TECH/doe_v2.pdf</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>These 2 guides were written over 20 years ago and for the
ASEAM software. A suprising amount of descriptive information from these guides
continues to be relevant today . Section 4.2 of Volume one has a nice
description if alternative calculation methods. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>Best,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906353003-23022010><FONT color=#0000ff
size=2 face=Arial>_Chris</FONT></SPAN></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2 face=Arial>Chris
Balbach, PE, CEM, CMVP</FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2 face=Arial>Vice
President of Research and Development</FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2
face=Arial>Performance Systems Development of NY, LLC</FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2 face=Arial>124
Brindley Street, Suite 4, Ithaca, NY 14850</FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2 face=Arial><A
href="http://www.psdconsulting.com">http://www.psdconsulting.com</A></FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2 face=Arial>ph: (
607)-327-1647</FONT></SPAN></DIV>
<DIV><SPAN class=906353003-23022010><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><FONT color=#0000ff size=2
face=Arial></FONT><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> 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<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<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 style="LINE-HEIGHT: 13pt" class=MsoNormal><B><SPAN style="COLOR: maroon">Dan
Croisant</SPAN></B><SPAN
style="FONT-FAMILY: 'Gill Sans MT'"><o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: #333333; FONT-SIZE: 9pt">Mechanical Design Engineer</SPAN><SPAN
style="FONT-FAMILY: 'Gill Sans MT'; COLOR: #333333; FONT-SIZE: 9pt"> | LEED
AP</SPAN><o:p></o:p></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: #333333; FONT-SIZE: 9pt">Direct 262.522.4414
</SPAN><o:p></o:p></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><o:p> </o:p></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: maroon; FONT-SIZE: 9pt">I B C ENGINEERING SERVICES, INC.
<o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: gray; FONT-SIZE: 9pt">N8 W22195 Johnson Drive, Suite
180
<o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: gray; FONT-SIZE: 9pt">Waukesha, Wisconsin 53186 </SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"><o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: gray; FONT-SIZE: 9pt">T 262.549.1190 : : F
262.549.1620 </SPAN><SPAN
style="FONT-FAMILY: 'Gill Sans MT'; COLOR: gray; FONT-SIZE: 9pt"><o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN
style="COLOR: gray; FONT-SIZE: 9pt"><o:p> </o:p></SPAN></P>
<P style="LINE-HEIGHT: 13pt" class=MsoNormal><SPAN style="COLOR: maroon"><A
title=http://www.ibcengineering.com
href="blocked::http://www.ibcengineering.com"><SPAN
style="COLOR: maroon">www.ibcengineering.com</SPAN></A></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BODY></HTML>