This website requires certain cookies to work and uses other cookies to help you have the best experience. By visiting this website, certain cookies have already been set, which you may delete and block. By closing this message or continuing to use our site, you agree to the use of cookies. Visit our updated privacy and cookie policy to learn more.
This Website Uses Cookies
By closing this message or continuing to use our site, you agree to our cookie policy. Learn More
This website requires certain cookies to work and uses other cookies to help you have the best experience. By visiting this website, certain cookies have already been set, which you may delete and block. By closing this message or continuing to use our site, you agree to the use of cookies. Visit our updated privacy and cookie policy to learn more.
ES Magazine logo
search
cart
facebook twitter linkedin youtube
  • Sign In
  • Create Account
  • Sign Out
  • My Account
ES Magazine logo
  • Home
  • Magazine
    • Current Issue
    • Digital Edition
    • Ad Index
  • Products
  • News
  • Sectors
    • Colleges/ Universities
    • Commercial
    • Government/ Institutional
    • Health Care
    • Hospitality
    • K-12
    • Mission Critical
  • Topics
    • Building Automation
    • Cooling & Chillers
    • Design/ Construction Process
    • Heating & Boilers
    • IAQ
    • Life Safety
    • Motors & Drives
    • Pumps & Flow Controls
    • Retrofits
    • Ventilation
  • Columns
    • Back2Basics
    • Building Automation Column
    • Case In Point
    • Commissioning
    • Editor's Note
    • Facility Files
    • IAQ: A Physician's View
    • Tomorrow's Environment
  • Multimedia
    • Videos
    • Podcasts
    • Webinars
    • Video Spotlights
    • Interactive Spotlights
    • Sneak Peek Spotlight
    • White Paper eBlast
    • Case Study eBlasts
  • Resources
    • eNewsletters
    • Continuing Education
    • White Papers
    • Industry Events
    • ES Store
    • Classifieds
    • Custom Content & Marketing Services
    • Market Research
  • Today's Boiler
    • Today’s Boiler Digital Edition
  • Directory
    • SourceBook
    • Take a Tour
  • Contact
    • Contact Us
    • Advertise
Home » The Energy Wiz: Fuel Factors
Columns

The Energy Wiz: Fuel Factors

August 30, 2004
Lindsay Audin, CEM, CEP
Reprints
No Comments
Analyzing weather-related energy use is often done ... wrongly. Regression analysis can help do it better.

When a new hospital in New England opened, it expected about 5,000 heating degree-days (HDD), based on the weather bureau's 30-year average. But its first winter was exceptionally cold, with 5,500 HDD during the eight-month winter period. The facility manager noted that he used 267,480 CCF of natural gas during those winter months, so he figures he did so at a rate of 48.6 CCF/HDD (i.e., 267,480 CCF/5500 HDD). Based on this factor, he calculates that a normal 5,000-HDD winter would require that he burn 48.63 x 5000 = 243,150 CCF.

What's wrong with this method?

Don't Forget Base Usage

If, indeed all heating fuel was used solely to counter exterior temperatures, that method should provide a reasonably good answer. Unfortunately, many facilities also consume gas in heating line distribution losses, steam leaks, boiler pilot lights, and domestic hot water.

In the case of the hospital in question, fuel is also used to make steam for sterilizers, prepare food in the cafeteria, and keep a therapeutic swimming pool warm. To properly correct for weather variations, the relatively constant monthly usage of fuel for these other systems must be taken into account.

Regression To The Rescue

We may better determine the relationship between monthly fuel usage and HDD by using Microsoft Excel™ to chart it. Set up a table of monthly data (Figure 1) and highlight the two columns containing your consumption and HDD data. Use Excel's Chart Wizard and (under "Standard Types") choose "XY (Scatter)."

Once the chart has been created (Figure 2), click on the "Chart" command (not the Chart Wizard) and "Add Trendline." Under the "Type" tab, choose "Linear." Under the "Options" tab, check off both "Display equation on chart" and "Display R-squared value on chart."

Excel then draws a best-fit trendline for your data points, calculates a linear mathematical formula, and provides an R2 value (indicating how well the formula fits the data). An R2 of 1.0 is perfect, but most of us are happy when it's .7 or higher. In our example, the data fits rather well, making R2 = .976.

The formula of 34.215 X + 9912.2 means that 34.215 (not 48.63) CCF are consumed for each HDD, and 9,912.2 CCF/month are used regardless of the temperature. If we extend the trendline back to zero HDD (see dashed line), it would cross at 9,912.2. To highlight the flat consumption and extend the trendline, we added the cross-hatched area and dashed line using Excel's "Draw" commands.

Using The Formula To Better

Predict Fuel Consumption Using his simple factor of 48.63 CCF/HDD, our facility manager concluded a normal 5,000 HDD winter would consume 243,150 CCF. Using our more precise formula, we instead come up with 250,373 CCF (over 7,200 CCF higher). That's because the flat usage of almost 10,000 CCF per month (which accounts for almost 32% of his winter consumption) occurs regardless of outdoor temperature. Had it been higher, the facility manager's overly simple method would have further underestimated winter fuel usage.

For those buying heating fuel through a third-party marketer, usage above an agreed-upon level may be charged not at the contract rate, but at the spot market rate (which could be considerably higher), so it pays to be as accurate as possible when forecast usage. ES

es-subscribe

Recent Articles by Lindsay Audin, CEM, CEP

Energy Wiz: What's Your CADE!

Energy Wiz: Don't Muddy Your Carbon Footprint

Energy Wiz: LEEDing Toward Better Existing Buildings

Energy Wiz: Playing The Demand Response Game

Energy Wiz: The Ups And Downs Of Elevator Energy Efficiency

Audin is president of Energywiz, Inc. (www.energywiz.com), a New York-based consulting firm that helps commercial/industrial clients get the most out of the competitive energy market. He was formerly energy manager for Columbia University and founded the New York Energy Buyers Forum.

Related Articles

The Energy Wiz: Factors In Forecasting

The Energy Wiz: The PC Way To Buy Energy

the energy wiz: THE FACs Of Life

The Energy Wiz: Improving The Trusty Scatter Plot

Related Products

The Green Energy Management Book

Energy Systems Engineering: Evaluation and Implementation, Third Edition

The Integrative Design Guide to Green Building: Redefining the Practice of Sustainability

Energy Conservation in Residential, Commercial, and Industrial Facilities

Related Directories

Industrial Fuel Systems LLC

You must login or register in order to post a comment.

Report Abusive Comment

Subscribe For Free!
  • Print & Digital Edition Subscriptions
  • eNewsletters
  • Online Registration
  • Subscription Customer Service

More Videos

Popular Stories

Dynamic Data Center Workloads Require a Dynamic Cooling Solution

Dynamic Data Center Workloads Require a Dynamic Cooling Solution

Protecting Pharmacists

Protecting Pharmacists: New USP 800 Standards Focus on Safety in Handling Hazardous Drugs

The Dangers of Neglecting Regular Boiler Maintenance

The Dangers of Neglecting Regular Boiler Maintenance

Jeff Edwards

Jeffrey W. Edwards Presented with ASPE Award of Merit

A2L Nov 2019 Figure 1

A2L Refrigerants: Safely Addressing Flammability Concerns

ES-20toWatch-winners250


Todays boiler

Events

December 30, 2030

Webinar Sponsorship Information

For webinar sponsorship information, visit www.bnpevents.com/webinars or email webinars@bnpmedia.com.

View All Submit An Event

Poll

Favorite Engineered Systems columns

Which Engineered Systems column is your favorite:
View Results Poll Archive

Products

The Green Energy Management Book

The Green Energy Management Book

Learn from our experts how to evaluate job opportunities, market your services, sell a Walk-through Survey, target areas for an Energy Audit, calculate energy savings, do retrofit work, and win continuing contracts for retrofit work.

See More Products

ES Kohler webinar


ES_2018Top10States_360

Engineered Systems Magazine

Engineered Systems December 2019

2019 December

Check out the December 2019 edition of Engineered Systems: Discussion of the "next generation" of building controls, the health impact of indoor particulate matter, evidence-based decision-making in the built environment and much more!
View More Create Account
  • Resources
    • ES Glossary
    • HVAC glossary
    • New Products
    • Mechanical Group
    • Partners
    • List Rental
    • Privacy Policy
    • Survey And Sample
  • Want More
    • Connect
  • Contact

Copyright ©2019. All Rights Reserved BNP Media.

Design, CMS, Hosting & Web Development :: ePublishing