![]() ![]() go to file import and select your arduino o/p text fileĪfter doing this google will create a google sheet. Its a very simple process please follow these steps:Ĥ. Now we will import the arduino data into a google sheet. i will suggest if you have multiple data, do the same. I separated different different readings with a "," so that i can create tables into the XL sheet. We will use this data to plot power usages graph.ĬoolTerm will save all data in a local folder and you can import this file into a XL sheet. Once you setup this it will start writing all the data coming from the arduino into a text file. To write data into a text file i am using CoolTerm, its a really simple tool for capturing data.Ĥ. Just for the testing purpose i changed to a different different load just to see if it works with other load, so far it worked great. print( ",") tkWh = tWh/ 1000 /// total killo watt hour used Serial. On the left-hand side, select ‘Logging’, then select ‘Printable output’, and maybe select ‘Always’. COM12) in the Serial line field, then click the Serial button. Now, open PuTTY and click on ‘Session’ at the left-hand side of the window. print( ",") tWh = tWh + Wh /// total watt hour used Serial. No need to worry because the Arduino will continue to send data to the port. define OE2 8 //Atribui valor do nome constante ao pino digital 8 define OE1 7 //Atribui valor do nome constante ao pino. print( ",") double Wh = 0.000833 * Power /// Watt hour on ch1 Serial. how do i put like, arduino working as normal with the buttons and LED´s, and also sending a message with the number that is selected to the coolterm. print( ",") double Power = voltage * current /// power on ch1 Serial. print(current, 3) //// current on ch 1 Serial. Power calculations are done in this section of the code.Īll you need to do is burn the code in arduino and check your readings on serial port. Include Wire I2C Library #include int address = 42 // I2C address double voltage = 121.7 /// ///// voltage reading double tkWh = 0 double tWh = 0 void setup ()Īfter reading the current now we will calculate the power. ![]() In this code i am calculating current,power, watt hour, total watt hour and total kilo watt hour. we will use this voltage reading to calculate the power uses. In my area the AC voltage is around 120-124V. This code is pretty straight forward, all you need to do is send a command to read current and the Current monitoring board will do everything for you. In this code i will write a command to read current through I2C. Data received by the sensor rig that is fully controlled by Arduino as a microcontroller, is then saved in a text file using CoolTerm terminal application. I will also explain how you can write data into an xl sheet and in a google sheet using arduino. This I2C adapter makes easy to connect current monitoring board. To read the current and power calculation i am using an arduino nano with an I2C adapter. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |