Shalay, waxaan qoray wax ku saabsan xakameynta beddelka WeMo adoo isticmaalaya Alexa^{(controlling a WeMo switch using Alexa)} maantana waxaan rabay inaan wax ka qoro sida aad u dhoofin karto xogta isticmaalka tamarta ee WeMo Insight beddelka Excel . WeMo Insight^{(WeMo Insight)} beddelka ayaa soo saara macluumaad badan oo faahfaahsan oo runtii faa'iido leh haddii aad isku dayayso inaad ogaato inta tamar ee aaladaha ama qalabka qaarkood ay ku isticmaalayaan gurigaaga ama xafiiskaaga.

Inkasta oo xogta app ay tahay mid weyn, waxaad u dhoofin kartaa 45 maalmood 'qiimihiisu xog aad u faahfaahsan oo Excel ah ka dibna ku samee wax kasta oo aad jeceshahay: samee jaantusyo iyo garaafyo muujinaya maalmaha tamarta ugu badan la isticmaalo, imisa saacadood qalabka wuxuu ku jiraa qaabka heeganka vs shid, iwm.

Maqaalkan, waxaan ka hadli doonaa habka loo dhoofiyo xogta ka dibna waxaan dul mari doonaa sida xogta loo habeeyo ee xaashida Excel . Waxaan sidoo kale ku tusi doonaa sida loo sameeyo jaantus degdeg ah si aad u qeexdo isticmaalka tamarta.

Ka Dhoofinta Xogta Tamarta ee WeMo

Sida caadiga ah, abka WeMo wuxuu ku siin doonaa xogta isticmaalka tamarta heerka sare ah sida inta uu qalabku jiray maanta iyo celceliska maalinta, qiyaasta kharashka bilaha ah iyo celceliska iyo isticmaalka tamarta hadda.

Tani way ku filan tahay dadka intooda badan, laakiin haddii aad tahay xog-ururin oo aad jeceshahay isticmaalka Excel , waxaad jeclaan doontaa xaqiiqda ah inaad dhoofin karto xog badan oo dheeraad ah si aad u falanqeyso naftaada. Si tan loo sameeyo, waxaan u baahanahay inaan taabano badhanka Edit ee dhanka midig ee sare ee barnaamijka WeMo . Shidayaasha ayaa bedeli doona sida loo soo bandhigay waana in aad taabo furaha WeMo Insight^{(WeMo Insight)} .

Shaashada soo socota, waxaad arki doontaa dhowr ikhtiyaar oo hoose, laakiin midda aan xiisayno waa dhoofinta xogta^{(Data Export)} . Qaar ka mid ah xulashooyinka kale ee aan sidoo kale sharxi doono mar dambe maadaama ay saameyn karaan waxa xogta la dhoofiyo.

Ugu dambeyntii, shaashadda ugu dambeysa, ku qor emailkaaga ka dibna taabo Dhoofinta Hadda^{(Export Now)} . Tani waxay isla markiiba kuu soo diri doontaa iimayl wata lifaaqa CSV oo ka kooban dhammaan xogta qalabka 45 maalmood ee u dambeeyay.

Haddii aad rabto, waxa kale oo aad habayn kartaa dhoofinta qorshaysan maalin kasta, toddobaadle ama bil kasta. Maadaama xogta la hayo kaliya 45 maalmood, waxaa fiican inaad dhoofiso xogta bishii hal mar, si aadan lumin wax xog ah haddii aad illowdo inaad gacanta ku dhoofiso.

Waxaan sidoo kale soo jeedinayaa in la isticmaalo inta jeer ee bilaha ah sababtoo ah sida ay hadda u shaqeyso, DHAMMAAN xogta 45-kii maalmood ee la soo dhaafay ayaa la soo diraa mar kasta oo aad sameyso dhoofinta. Ma aha sida xogta oo kale ama wax la mid ah. Ugu dambayntii, waa inaad samaysaa xaashi shaqo oo aad koobiyayso oo ku dhejiso xogta xaashida cusub ee cusub kuwii hore haddii aad rabto xog qiimaheedu ka badan yahay 45 maalmood oo hal xaashi ah.

Emaylka dhexdiisa , magaca feylku wuxuu noqon doonaa Dhoofinta aaladda magaca^{(Export for devicename)} . Maadaama uu yahay faylka CSV , waxaad ku furi kartaa Google Sheets , Excel ama barnaamijyo kale oo badan haddii aad rabto. Si fudud, waxaan u isticmaali doonaa Excel . Hadda aan eegno xaashida faafinta.

Xagga sare, waxaad heli doontaa qaar ka mid ah macluumaadka aasaasiga ah sida taariikhda iyo wakhtiga ugu dambeeya ee warbixinta tamarta, magaca qalabka, qaar ka mid ah MAC ID , xoogga signalada ee qalabka WeMo ka dibna Qiimaha tamarta ee kWh^{(Energy Cost per kWh)} iyo marinka (Watts) )^{(Threshold (Watts))} . Labadan qiyam ee ugu dambeeya waxa lagu beddeli karaa abka shaashadda ku yaal halka aad ku taabatay Dhoofinta Xogta^{(Data Export)} . Markaa qiyaasta kharashka bishii ee WeMo ku siiso waxay ku salaysan tahay tan .111 halkii kWh, laakiin kharashka tamartaagu wuu ka duwanaan karaa.

Habka ugu fiican ee tan lagu ogaan karo waa in la eego biilka tamarta oo aad u qaybisid wadarta tirada Korontada^{( Electric Amount)} wadarta kWh ee la isticmaalay^{(kWh Used)} . Waa inaad eegtaa oo kaliya qaybta Faahfaahinta Korontada^{(Electric Details)} ee biilkaaga, ee ma aha faahfaahinta gaaska. Waa kuwan tusaale biilka korontada si aan u caddeeyo:

Markaa halkan, waxaan qaadan lahaa $267.46 oo waxaan u qaybin lahaa 1830 kWh La isticmaalay taasna waxay i siinaysaa qiyaastii .146 , taas oo ah 14.6 senti kWh^{(14.6 cents per kWh)} ahaan kharash ahaan. Markaa hadda waxaan galaa app-ka WeMo oo aan ka beddelaa .111 ilaa .146 taasina waxay i siin doontaa qiyaas aad u sax ah oo ku saabsan qiimahayga billaha ah ee aaladdan.

Intaa waxaa dheer, waxaad hagaajin kartaa qiimaha Threshold , kaas oo asal ahaan tilmaamaya in qalabku shidan yahay ama^(On) ku jiro qaabka heeganka^(Standby) . Sida caadiga ah, qiimahan waxa loo dejiyay 8 Watts . Haddii qalabku isticmaalo wax ka yar intaa, waxaa lagu tixgalinayaa qaabka heeganka. Ma ihi injineer koronto oo runtii ma hubo waxa ugu fiican taas, markaa waxaan uga tagay 8w.

Hoos waxaa ah qaybta kooban ee isticmaalka maalinlaha ah, taas oo jebisa xisaabaadka muhiimka ah maalin kasta. Waxaad arki kartaa wakhtiga, wakhtiga heeganka, celceliska isticmaalka tamarta maalintii, iyo qiimaha maalinta. Haddii aad rabto inaad aragto wadarta tamarta la isticmaalo maalinta, kaliya samee qaacido oo ku dar Isticmaalka Korontada (On)^{(Power Consumption (On))} iyo Isticmaalka Korontada (Standby)^{(Power Consumption (Standby))} ee saf kasta. Ugu dambeyntii, xagga hoose, waxaad heleysaa burburka isticmaalka nus saac.

Iyadoo ku xiran inta maalmood ee qiimaha xogta aad haysato, tani waxay ku dari kartaa ilaa aad u badan oo xog ah. Tani waxay sidoo kale kuu ogolaaneysaa inaad abuurto garaafyo wanaagsan si aad u aragto isticmaalka tamarta waqti ka dib. Fikradayda, shaxda ugu fiican ee lagu daawado xogtan noocaan ah waa goob firdhiso X Y. ^{(Y Scatter)}Haddii aad dooratid labada tiir ee xogta, oo ay ku jiraan cinwaannada, dhagsii Geli^(Insert)  -  Chart , oo dooro XY Scatter , waxaad heli doontaa wax sidan oo kale ah:

Sida aad arki karto, talaajadheygu waxa uu isticmaalaa ku dhawaad ​​.006 kWh marka uusan ordin waxa uuna u boodaa ilaa .012 kWh marka uu qaboojinayo. Waxa kale oo ay isku beddeshaa goboladaas oo dhan habeen iyo maalin. Isticmaalka aaladaha kale waxay u badan tahay inay dhalin doonto jaantusyo kala duwan.

Ogsoonow in ay fikrad fiican tahay in dib loo dajiyo WeMo^(WeMo) haddii aad go'aansato inaad u guurto meel kale si aad ula socoto xogta ku saabsan qalab kale. Haddii aadan samayn, waxaad heli doontaa xog ka socota laba qalab oo kala duwan, taas oo ka dhigaysa xogta mid aan faa'iido lahayn ilaa aad xasuusato maalinta saxda ah ee aad u guurtay furaha.

Guud ahaan, WeMo Insight beddelka ayaa u qalma qiimaha haddii aad tahay xog junkie. Fikradayda, waxaad runtii u baahan tahay mid ka mid ah kuwan agagaarka guriga si aad ula socoto qalab kala duwan. Marka aad haysato laba toddobaad oo qiimihiisu yahay xogta hal qalab, waxa aan si dhab ah u socday in la beddelo oo dhan in badan, si aad markaas dib karaa xogta iyo bilaabaan raad qalab kale. Haddii aad wax su'aalo ah qabtid, xor u noqo inaad faallo ka bixiso. Ku raaxayso!

How to Export WeMo Energy Usage Data to Excel

Yeѕterday, I wrotе about controlling a WeMo switch using Alexa and today I wanted to write about how you can export the energy usage data from a WeMo Insight switch to Excel. The WeMo Insight switch generates a lot of detailed information that is really useful if you’re trying to figure out how much energy certain devices or appliances are using in your home or office.

Even though the app data is great, you can export 45 days’ worth of far more detailed data to Excel and then do whatever you like with it: create charts and graphs showing which days the most energy is being used, how many hours the device is in standby mode vs on, etc.

In this post, I’ll talk about the process for exporting the data and then go over how the data is organized in the Excel spreadsheet. I’ll also show you how to make a quick chart to graph out the energy usage.

Export Energy Data from WeMo

By default, the WeMo app will give you high-level energy usage data like how long the device was on today and on an average day, the estimated monthly cost and the average and current wattage usage.

This is good enough for most people, but if you are a data geek and you love using Excel, you’ll love the fact that you can export so much extra data out to analyze on your own. To do this, we need to tap on the Edit button at the top right of the WeMo app. The switches will change how they are displayed and you should tap on the WeMo Insight switch.

On the next screen, you’ll see a couple of options at the bottom, but the one we are interested in is Data Export. Some of the other options I’ll also explain later on as they can affect what data is exported.

Finally, on the last screen, type in your email address and then tap on Export Now. This will immediately send you an email with a CSV attachment containing all data for the device over the last 45 days.

If you like, you can also setup scheduled exports on a daily, weekly or monthly basis. Since data is only kept for 45 days, it’s a good idea to export the data once a month, so that you don’t lose any data if you forget to export manually.

I also suggest using the monthly frequency because the way it works right now, ALL the data for the last 45 days is sent every time you perform an export. It’s not like the data is reset or anything like that. Eventually, you’ll also have to create a master worksheet and copy and paste the data from the newer spreadsheets into the older ones if you want more than 45 days’ worth of data in a single spreadsheet.

In the email, the name of the file will be Export for devicename. Since it’s a CSV file, you can open it in Google Sheets, Excel or a host of other programs if you like. For simplicity, I will be using Excel. Now let’s take a look at the spreadsheet.

At the top, you’ll get some basic information like the last updated date and time 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 (Watts). These last two values can be changed in the app on the screen where you tapped on Data Export. So the estimated monthly cost that WeMo gives you is based on this .111 per kWh value, but your energy costs may be different.

The best way to figure this out is to look at your energy bill and divide the total Electric Amount by the total kWh Used. You should only be looking at the Electric Details part of your bill, not the gas details. Here’s an example of my electric bill just to make it clear:

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

In addition, you can adjust the Threshold value, which basically dictates whether the device is On or in Standby mode. By default, this value is set to 8 Watts. If the device uses less than that, it is considered in standby mode. I’m no electrical engineer and I’m not really sure what the best value for that is, so I just left it at 8w.

Below that is the daily usage summary section, which breaks down key stats by day. You can see time on, time in standby, average power consumption over the day, and the day’s cost. If you want to see total power consumed for the day, just create a formula and add Power Consumption (On) and Power Consumption (Standby) for each row. Finally, at the bottom, you get a breakdown of usage by half-hour.

Depending on how many days’ worth of data you have, this can add up to quite a lot of rows of data. This will also allow you to create nice graphs to see energy usage over time. In my opinion, the best chart for viewing this type of data is an X Y Scatter plot. If you select the two columns of data, including the headings, click on Insert – Chart, and choose X Y Scatter, you’ll get something like this:

As you can see, my fridge uses around .006 kWh when not running and jumps to about .012 kWh when cooling. It also alternates between these states all day and night. Usage by other devices will probably generate different looking charts.

Note that it’s a good idea to reset the WeMo if you decide to move it to another location to track data about a different device. If you don’t, you’ll get data from two different devices, which will make the data useless unless you remember the exact day you moved the switch.

Overall, the WeMo Insight switch is worth the cost if you are a data junkie. In my opinion, you really only need one of these around the house to track different devices. Once you have a couple of weeks’ worth of data for one device, it’s not really going to change all that much, so you can then reset the data and start tracking another device. If you have any questions, feel free to comment. Enjoy!

Related posts

• Sida loo xakameeyo WeMo Insight Switch anoo isticmaalaya Alexa & Echo

• Sida loo soo dejiyo Xogta LinkedIn iyadoo la adeegsanayo Qalabka Dhoofinta Xogta ee LinkedIn

• Sida loo soo dejiyo Xogta Instagram iyadoo la isticmaalayo Aaladda Dhoofinta Xogta ee Instagram

• Si dhakhso leh ugu wareeji xogta Amazon S3 adoo isticmaalaya AWS Soo Dejinta

• U Dhoofi Xogta SQL ee Excel oo wata Madaxyada Saarka

• Mosonth 2K Webcam Review

• Sida dib loogu dejiyo ama loo nadiifiyo Isticmaalka Xogta gudaha Windows 11/10

• Waa maxay sababta Garmin Instinct Solar u yahay Socodka ugu Wanaagsan Smartwatch

• Farsamada ugu Fiican ee aan sugayno 2022

• Kudar Sidebar iyo Qalabka Desktop gudaha Windows 10 oo wata 8GadgetPack

• 5ta kaadhadhka codka ugu fiican ee kombayutarkaga 2021

• Kamaradaha Waxqabadka ugu Fiican ee ka hooseeya $100

• 3-da Kaararka MicroSD ee ugu Wanaagsan ee la Iibsado 2020

• Sida loo maareeyo Xadka Isticmaalka Xogta ee Windows 11/10

• Sida loo isticmaalo GoPro HERO sidii kamarad shabakadeed

• 10 kanaal oo Amazon Fire Stick ah oo bilaash ah oo ay tahay inaad ku rakibto

• Sida loo yareeyo Isticmaalka Xogta YouTube-ka ee Windows 11/10 PC

• 5 Apps iyo Alaadaha Dabagalka Ilmaha ugu Wanaagsan si loola socdo Goobta

• Amazon Fire TV Stick 4K vs Amazon Fire TV Cube: waa maxay faraqa u dhexeeya?

• Roku Streaming Stick Plus vs Amazon Fire TV Stick 4K: keebaa ka wanaagsan?