Skip to content

How To Blog

how to

  • The 10 Best Online Shopping Sites for Cheap Electronics Cool Websites
  • Best Smart Locks, Cameras, and Thermostats for Airbnb Hosts Smart Home
  • How to Make a Custom Discord Status With YouTube, Twitch, and More Computer Tips
  • 9 Things To Do Before Selling Your Mac OS X
  • Best sharp calculator ribbon 2020

    Best sharp calculator ribbon 2020

  • 8 Best Free and Paid Cloud Storage (2017) How-To
  • What’s the Difference Between a Virus, a Trojan, a Worm, and a Rootkit? Computer Tips
  • How to Encrypt Your Hard Drive for Free

    How to Encrypt Your Hard Drive for Free

How to Export WeMo Energy Usage Data to Excel

Posted on October 6, 2020 By No Comments on How to Export WeMo Energy Usage Data to Excel

Yesterday I wrote about managing a WeMo switch with Alexa, and today I wanted to write about how you can export energy usage data from a WeMo Insight switch to Excel. The WeMo Insight switch generates a lot of detailed information that is really helpful if you are trying to figure out how much power certain devices or devices in your home or office are using.

Even though the app data is great, you can export much more detailed 45 days of data to Excel, and then do whatever you want with it: create charts and graphs showing which days are using the most energy, how many hours the device is. is idle or on, etc.

In this post, I will walk you through the process of exporting data, and then explain how the data is organized in an Excel spreadsheet. I will also show you how to quickly create a chart showing your energy consumption.

Export energy data from WeMo

By default, the WeMo app provides you with high-level energy usage data such as how long the device has been on today and on average per day, estimated monthly cost, and average and current energy consumption.

How to Export WeMo Energy Usage Data to Excel

That’s enough for most people, but if you’re a data fanatic and love using Excel, you’ll love the fact that you can export so much additional data for your own analysis. To do this, we need to click the “Change” button in the upper right corner of the WeMo application. The switches will change the way they are displayed and you should click on the WeMo Insight switch.

How to Export WeMo Energy Usage Data to Excel

On the next screen, you will see several options at the bottom, but we are interested in exporting data. I will explain some of the other parameters later as they can affect what data is exported.

How to Export WeMo Energy Usage Data to Excel

Finally, on the last screen, enter your email address and click Export Now. You will be immediately sent an email with a CSV attachment containing all device data from the last 45 days.

How to Export WeMo Energy Usage Data to Excel

Optionally, you can also set up scheduled exports on a daily, weekly or monthly basis. Since the data is only retained for 45 days, it is recommended that you export the data once a month to avoid losing data if you forget to export it manually.

How to Export WeMo Energy Usage Data to Excel

I also suggest using a monthly frequency because the way it works now is ALL data from the last 45 days is sent every time you export. It doesn’t look like a data dump or something. In the end, you will also have to create a master worksheet and copy and paste data from new tables to old ones if you want a single table to contain data for more than 45 days.

How to Export WeMo Energy Usage Data to Excel

In the email, the filename will be “Export for devicename ”. Since this is a CSV file, you can open it in Google Sheets, Excel, or a host of other programs if you like. For the sake of simplicity, I’ll be using Excel. Now let’s look at the table.

How to Export WeMo Energy Usage Data to Excel

At the top, you will get some basic information like the date and time of the last update for this energy report, the device name, some MAC ID, the signal strength of the WeMo device, and then the energy cost per kWh and the threshold (W). These last two values ??can be changed in the application on the screen where you clicked Export Data. So the estimated monthly cost WeMo gives you is based on this 0.11 cost per kWh, but your electricity costs may differ.

The best way to find out is to look at your electricity bill and divide the total electricity by the total kWh used. You should only look at the electrical part of the bill, not gas. Here’s an example of my electricity bill to clarify:

How to Export WeMo Energy Usage Data to Excel

So here I would take $ 267.46 and divide by 1830 kWh and that gives me about 0.146, which is 14.6 cents per kWh as cost. So now I go into the WeMo app and change it from .111 to .146 and that gives me a very accurate estimate of my monthly cost for this device.

In addition, you can adjust the threshold value, which basically determines whether the device is on or in standby mode. By default, this value is set to 8 W. If the device consumes less, it is considered in standby mode. I’m not an electrical engineer and I’m not entirely sure what is the best for this, so I just left it at 8W.

How to Export WeMo Energy Usage Data to Excel

Below is the daily usage summary section, which breaks down the main statistics by day. You can see the running time, standby time, average power consumption per day and daily value. If you want to see the total power consumed per day, just create a formula and add Power Consumption (On) and Power Consumption (Standby) for each row. Finally, at the bottom, you will see a breakdown by usage for half an hour.

How to Export WeMo Energy Usage Data to Excel

Depending on how many days you have data in, there can be quite a few rows of data. It will also allow you to create beautiful graphs to see your energy consumption over time. In my opinion, the best chart for viewing this type of data is the XY Scatter chart. If you select two columns of data including the headers, click Insert – Chart and select XY Scatter, you get something like this: < / p>

How to Export WeMo Energy Usage Data to Excel

As you can see, my refrigerator uses about 0.006 kWh when not in operation and jumps to 0.012 kWh when cooled. It also alternates between these states day and night. Use on other devices will likely result in a different kind of diagram.

Note that resetting WeMo is a good idea if you decide to move it to a different location to track data on another device. If you don’t, you will receive data from two different devices, making it useless unless you remember the exact day you moved the switch.

Overall, the WeMo Insight toggle is well worth the money if you’re a data lover. In my opinion, you only really need one of them to track different devices. If you have a couple of weeks of data for one device, it doesn’t change much, so you can reset the data and start tracking another device. If you have any questions, do not hesitate to comment. Enjoy!

–

Gadgets

Post navigation

Previous Post: How to Tell if an Email is Fake, Spoofed or Spam
Next Post: How to Control a WeMo Insight Switch using Alexa & Echo

Related Posts

  • Top 5 Tablets to Increase Productivity Gadgets
  • The Best Xbox One Headsets Gadgets
  • How to Change Your 3D Printer Filament Gadgets
  • Top 10 gifts for book lovers Gadgets
  • Review – iClever Portable Wireless Bluetooth 4.0 Speaker Gadgets
  • AnyCubic Photon Mono X 3D Printer – Review Gadgets

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018

2021 Android ) Apple apps Best black browser change Chrome Closing words Concluding remarks Conclusion Delete Download Error Facebook Files Find Free) From games Google Keyboard Mac make Music Netflix ( online Open Packaging Password phone? Screen sites Tips using Video Videos Watch Websites What With Working? your YouTube

  • Everything a Beginner Needs to Know About Torrents How-To
  • How To Remove “Continue Watching” From Netflix Computer Tips
  • How to get Android O Features on any Android Smartphone
  • Best calculator small 2020 black
  • S2M Explains : How Do Face ID & Fingerprint Scan Work? Are They Secure? General Software
  • Best Free Team Chat Software for Windows 10 Tools Review
  • How To Control Your Xbox One With a Smart Assistant Smart Home
  • Pre-Installed MacOS Software Which Is Actually Really Good General Software

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
Go to mobile version