[Bldg-sim] Estimating Energy Consumption Using Spreadsheets

[Michael Andelman]

I attended an Energy in Architecture course given by AIA in 1982.  I still
have the manual.

The energy calculations section includes a two page worksheet to do a
building block cooling load , a one page worksheet to do a building block
heating load, worksheets for annual heating loads using degree day method
and annual cooling loads using equivalent full load operating hour method,
and appropriate tables from ASHRAE.  

Looking it over I got a good laugh out of the last page - circles with marks
around the circumference (0-100) to be used for pie charts to show energy
costs by end use.

 

I had already started DOE2 (or should I say CAL-ERDA) for several years
prior to the course, but this was run on a main frame, and many people were
doing energy calc's by hand (remember - this was before PCs and
spreadsheets).

Things were very primitive back then.

 

Mike Andelman

 

From: bldg-sim-bounces at lists.onebuilding.org
[mailto:bldg-sim-bounces at lists.onebuilding.org] On Behalf Of Daniel Croisant
Sent: Monday, February 22, 2010 4:50 PM
To: bldg-sim at lists.onebuilding.org
Subject: [Bldg-sim] Estimating Energy Consumption Using Spreadsheets

 

Hello,

 

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. 

 

Thank you in advance,

Dan Croisant

Mechanical Design Engineer | LEED AP

Direct  262.522.4414  

 

I B C ENGINEERING SERVICES, INC. 

N8 W22195 Johnson Drive, Suite 180                  

Waukesha, Wisconsin  53186 

T 262.549.1190  : :  F  262.549.1620  

 

 <blocked::http://www.ibcengineering.com> www.ibcengineering.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20100222/0cc5afc1/attachment-0002.htm>