Toggle navigationeGauge Logo

    Main Menu

  • Overview
    • Home Energy Monitoring
    • Commercial Energy Monitoring
  • eGuard
    • Overview
    • Portfolio
    • Portfolio
    • Other Software
    • Register a Device
    • Device Map
  • Support
    • Support Knowledgebase
    • Misc Support
    • Find My Device
    • Order Lookup
    • Internationalization
    • Firmware Release Notes
  • Company
    • Our Company
    • Blog
    • Partners
    • Careers
    • Contact

    Online Store

    Buy eGauge
  • Shop now
  • Find a distributor
  • Shop Now
  • Find a distributor
  • Account

  • Find
  • eGuard Login
  • Blog

    • Monitoring System Serves as Foundation for Energy Efficiency at Little Elementary
    • Continuous Monitoring Reveals Serious Malfunction at North Arvada Middle School
    • Renew Our Schools 2.0
    • How to Download Demand Data to a CSV File From Your eGauge
    • 3 Tips For a Successful CT Meter Installation
    • What is Power Factor?
    • How to Measure Peak Demand with Set and Rolling Averages
    • How to Set a Freezer Failure Alert
    • A Risky Home Appliance: The Meat Freezer
    • Why the Whitefish Contract is Suspicious
    • The Status of Submetering
    • Utilizing Battery Storage II
    • Utilizing Battery Storage
    • Use It or Lose It: The Residential SREC
    • Commercial Demand Charge
    • Aaahh!!! Real Energy Monsters
    • Knowledge of Power is Power
    • Get Schooled on Your Energy Usage
    • Open-Source Open Community

Company

    • Company

    • Blog

      • Monitoring System Serves as Foundation for Energy Efficiency at Little Elementary
      • Continuous Monitoring Reveals Serious Malfunction at North Arvada Middle School
      • Renew Our Schools 2.0
      • How to Download Demand Data to a CSV File From Your eGauge
      • 3 Tips For a Successful CT Meter Installation
      • What is Power Factor?
      • How to Measure Peak Demand with Set and Rolling Averages
      • How to Set a Freezer Failure Alert
      • A Risky Home Appliance: The Meat Freezer
      • Why the Whitefish Contract is Suspicious
      • The Status of Submetering
      • Utilizing Battery Storage II
      • Utilizing Battery Storage
      • Use It or Lose It: The Residential SREC
      • Commercial Demand Charge
      • Aaahh!!! Real Energy Monsters
      • Knowledge of Power is Power
      • Get Schooled on Your Energy Usage
      • Open-Source Open Community
    • Partners

    • Careers

    • Contact


  • Back to Top
  • Home
  • Company
  • Blog
  • 2018
  • February
  • 26
  • How to Download Demand Data to a CSV File From Your eGauge

Search Blog

RSS Feed

Feed Icon
Subscribe here to our Atom feed for our latest blog entries

Questions or Comments?

Send us an email at blog@egauge.net or connect with us on social media and we will respond as soon as possible.

How to Download Demand Data to a CSV File From Your eGauge

Written on Feb. 26, 2018

Last update on Feb. 27, 2018 .

How to Download Demand Data to a CSV File From Your eGauge


Prepare the Export

Downloading max demand values to a spreadsheet file is simple with our recent firmware update, v3.3.10! With this update, you can find the exact kW value, date, and time when the peak demand value occurred. Let’s walk through it step-by-step!

First, navigate to your eGauge device page on a web browser. Once loaded, find the drop-down menu on the graph (it looks like a gray triangle), click it, and select "Export Data to Spreadsheet." Next, change Export Type to “Max. Demand Value (e.g., kW for power)”, select the date range for which you’re interested in finding a max value, and change the Interval to the rolling average you’d like to find. For this last part, utility companies typically charge based on a rolling 15- or 30-minute average, so in the export menu, choose type in 15 or 30 and select “minute” from the drop-down menu. Finally, click export!



Processing the Data

Open your recently exported CSV file in a spreadsheet program. You should see a Date and Time column followed by columns for all of your device’s registers. Remove any columns for which you don’t want to find a max demand value. In this example, we’ll just look at the total Usage register. Next, in an empty cell we’re going to use a formula to find the max value, it’s called =MAX() in excel (other spreadsheet programs may use something slightly different). Put the range of your register column in this max function; it should look something like =MAX(B2:B50) when complete, hit enter. The output will be the max kW value in the range you selected!



Now, you’ll probably want to know when the max occurred. The easiest way to do this is to ctrl-f (or cmd-f) the value and look at the corresponding date. This method becomes harder if you have a large number of columns on your sheet, but you can use a function like the VLOOKUP() to get the same information.

This post should get you started exporting max demand values from your eGauge. If you’re curious how to see max demand in real time on your graph, check out this blog!

Tags : #csv #demand #egauge #power

Short url : http://www.egauge.net/blog/H/

  • Renew Our Schools 2.0 →
  • ← 3 Tips For a Successful CT Meter Installation

eGauge Systems LLC
1644 Conestoga Street, Suite 2
Boulder, CO 80301
1-877-342-8431
1-720-545-9767
info@egauge.net

About | Policies | Contact
social media logosocial media logo
© 2022 eGauge Systems LLC