10/04/2013

Microsoft Excel: Energy Management at Your Fingertips

Discover tips and tricks for energy practices and projects

By Rama Ayer and Eric Woodroof

 

A valuable energy tool may be sitting unused on your computer desktop.

Microsoft Excel is well suited for energy management and advanced analysis; however, it is underutilized within most businesses. Many people are not aware of a whole raft of functions that could provide greater insight and save a ton of time.

Why does this happen? In many organizations, there is no formal training on Excel. Think about how most of us learned Excel – someone showed us the basics and we learned the rest on our own. Imagine what a little training would do for productivity and the ability to perform more advanced analysis, impressing your boss or client.

Excel and Energy
When it comes to energy analysis, where does Excel fit in? Excel is certainly not a replacement for sophisticated programs such as eQUEST, TRACE, or HAP, which have established their places in energy engineering. However, Excel is a “Swiss Army Knife” that can perform many functions in the depth and breadth that is sufficient for day-to-day energy engineering and financial analysis.

In order to effectively use Excel, you need to pick up some tips, tricks, and techniques. A tip saves you time by performing a given action in less time. A trick allows to you achieve a result that is not normally possible with built-in capability. A technique is a skillful way of applying the basic features, usually by combining them in innovative ways.

The 2013 version of Excel has over 450 functions, which can seem overwhelming, but I have prioritized some of the must-know functions and features. Detailed below are three tips that you can implement today.

Tip #1: Add Units to Numbers without Changing Numbers to Text

To display a unit of measure (kWh, Therms, lb., etc) in a cell without changing the number to text, create a custom number format following the steps below:

  1. Select the cells containing the numbers you want to format.
  2. Press  the key board shortcut key “ctrl +1” to bring the “format cells” dialog box.
  3. In the format cells choose the “custom format” option.
  4. In the type field, select a number format for your cells and type the unit of measure enclosed in quotes (e.g. " kWh" ) to the right of the number format.

You can use this formatted cell in any calculations, and once you have created this format, you can use it anywhere in the workbook. (See first screenshot for an example.)


View Larger 


Pages: 1  2  3  4  View All  
 


Visit our website today to learn about the design flexibility of a Morton building and the endless possibilities of partnering with our designBUILD team.


Wood construction is both cost and energy efficient. Check out Morton Buildings and our designBUILD team online today to discover all the benefits of post-frame construction.


When choosing a metal-clad building for your next construction project, consider Morton Buildings, Inc., and their designBUILD team, we’ll make your dream a reality.

We Can Help You Reduce Energy by 30%

Our mission is to help our customers manage their buildings' energy costs, improve reliability, and enhance performance while having a positive impact on the environment.
CLICK HERE to find out how.

 


Tennant Company is a recognized leader in designing, manufacturing and marketing solutions that help create a cleaner, safer, healthier world. With thousands of satisfied customers already using award winning ec-H2O technology, why not see what you're missing? Test ec-H2O on your soils in your facility. Get a free demo.


Tennant Company is a recognized leader in designing, manufacturing and marketing solutions that help create a cleaner, safer, healthier world. With thousands of satisfied customers already using award winning ec-H2O technology, why not see what you're missing? Test ec-H2O on your soils in your facility. Get a free demo.

 

Replace core drilling with Connectrac In-Carpet and On-Floor Wireways, the proven connectivity solution in open interior spaces of all kinds. These elegant low-profile wireways are great for AV / telecom connectivity wherever it’s needed.

 

Add highly responsive multi-zone comfort to any building project, in any climate. Our CITY MULTI H2i R2- and Y-Series VRF systems give you flexibility to fit the needs of any building. Enjoy 100% heating capacity at 0°F outdoor ambient, and 85% heating capacity at -13°F outdoor ambient.  For more information, log on to www.mitsubishipro.com


Visit our website today to learn about the design flexibility of a Morton building and the endless possibilities of partnering with our designBUILD team.


Wood construction is both cost and energy efficient. Check out Morton Buildings and our designBUILD team online today to discover all the benefits of post-frame construction.


When choosing a metal-clad building for your next construction project, consider Morton Buildings, Inc., and their designBUILD team, we’ll make your dream a reality.

We Can Help You Reduce Energy by 30%

Our mission is to help our customers manage their buildings' energy costs, improve reliability, and enhance performance while having a positive impact on the environment.
CLICK HERE to find out how.

 


Tennant Company is a recognized leader in designing, manufacturing and marketing solutions that help create a cleaner, safer, healthier world. With thousands of satisfied customers already using award winning ec-H2O technology, why not see what you're missing? Test ec-H2O on your soils in your facility. Get a free demo.


Tennant Company is a recognized leader in designing, manufacturing and marketing solutions that help create a cleaner, safer, healthier world. With thousands of satisfied customers already using award winning ec-H2O technology, why not see what you're missing? Test ec-H2O on your soils in your facility. Get a free demo.

 

Replace core drilling with Connectrac In-Carpet and On-Floor Wireways, the proven connectivity solution in open interior spaces of all kinds. These elegant low-profile wireways are great for AV / telecom connectivity wherever it’s needed.

 

Add highly responsive multi-zone comfort to any building project, in any climate. Our CITY MULTI H2i R2- and Y-Series VRF systems give you flexibility to fit the needs of any building. Enjoy 100% heating capacity at 0°F outdoor ambient, and 85% heating capacity at -13°F outdoor ambient.  For more information, log on to www.mitsubishipro.com


 
comments powered by Disqus

Related Products

Interiors
Envelope and Structural
Envelope and Structural

Sponsored Links