ACI Home Performance Conference 2007

MAM 08 - Using Spreadsheets: Energy Analysis & Related Tasks (Hands-on)

Monday, April 23, 2007 · 8:00 AM - 12:00 PM

Computers are essential to our work and crunching numbers is where they really shine. Proprietary programs, though user friendly, often isolate us from the assumptions that support their processes and conclusions. Underlying these programs are basic spreadsheets that do the work and can reveal why we get the answers we do. This hands-on course will look at a variety of useful spreadsheet tools and learn to create our own.

Handouts will include a CD with open-source spreadsheets for the examples discussed. Participants should bring a laptop with Microsoft Excel or compatible spreadsheet program installed. Basic knowledge of Excel is recommended.

By attending this session, participants will

Understand a variety of relevant tasks that can be accomplished with a spreadsheet
Gain an understanding of the first principles upon which "black box" systems work and develop a healthy skepticism
Have the confidence to design and execute basic spreadsheets to answer and support your own questions about building science

Keyword(s):

audit, bill analysis, building science, costs, diagnostics, evaluation, feedback, heat loss / gain, load calculations, measured results, modeled results, predicting savings

Type: Half-Day
CEU: Building Performance Institute, Inc. (BPI) National Association of the Remodeling Industry (NARI)

Course Presenter(s):

Tom Wilson

Course Document(s):

MAM08_Wilson

You may need Adobe Reader to view PDF documents. If you do not have Adobe Reader installed, please download the Free software here.

Previous Page Back to Top