Hello, friends.
Today I will tell you how to record data acquired by Arduino.
In Excel for that purpose.
I just over here write a dummy program.
Right now, I'm not connecting any sensors to my Arduino board.
First of all, as you see over here, this is my Arduino.
Uno is not connected.
In this case, you just need to connect your Arduino board with your PC.
As you see, when I just connect it.
Arduino you know on com five is available you can set it from here just set the board in the Arduino
It is.
Arduino Uno in the com com five.
Now just write a code for solar power extraction through the.
Renault board.
So initially I just put a temperature variable that its initial value is zero.
Then I put voltage.
It is generated by.
Voltage sensor.
Then I put just.
Current.
Value.
Its initial value again.
Zero.
And finally the power generated by my.
Panel.
So after this, here is void setup.
So baud rate of my Arduino Uno is 9600.
Then void loop.
In this case.
Over here.
I just use temperature.
It is random.
Use random number in the case of my.
The location is ghaziabad over here.
Temperature varies from ten degree Celsius to 50 degree.
55 degree Celsius.
So in this case.
My temperature varies from 10 degree Celsius to 55 degree Celsius, so I just use random number.
So temperature initial value is ten and final value is 55.
Maximum value is 55 then voltage.
I just use a panel of 250 watt.
Its voltage rating is from 0 to 35 volt.
And current is from zero to maximum ten.
And the power is voltage into current.
It generates DC voltage.
So initially I just print these values over my serial monitor.
And I also show you these values on serial plotter.
So I just use serial print temperature then separated by comma after that voltage, then current and
finally power.
So I just now upload this code to my Arduino.
Right now, no sensor is connected to my Arduino board.
Uploading is done.
You just click on serial monitor.
So over here when you just click on serial monitor.
It will show you the.
Different values as you see it will generate.
You also put some delay inside this.
So it is generating four values right now if you want to show these values in a plotter.
Now, as you see over here, there is four values.
First value is temperature, second value is voltage, third value is current.
And finally, I got power.
So this is how you can generate different values.
Dummy values using Arduino, Uno or any Arduino.
Now I just want to grab these values inside the Excel.
So for that purpose, I just close this.
I just.
Close this also.
Now, again, I open ID because if you want to just load this values inside the Excel right now your
adeno is busy.
So I just open ardino id again.
Or you also.
You can also remove this using the basic program.
You just upload the basic program to the Arduino.
So now I just not use the serial monitor in this case.
So for Excel, I just.
Right click new.
Excel worksheet.
So over here is solar data.
So name it solar data.
Now just open.
This file.
In this file, I just record the data of Arduino.
That is created by.
My previous code.
It will take some time.
So over here, as you see, there is a data streamer in your case, maybe it is not available.
If it is not available, you just go to Google.
Just.
Place.
Data streamer.
Data.
Streamer for Excel.
So over here in this, you just go to Microsoft.
Just download.
Microsoft data streamer.
As you see in this case, it is downloaded.
So open is.
You just need to open this.
So over here, this is my data streamer file.
So these files are required.
To install the data streamer.
It will take some time.
So extract these files on desktop or anywhere.
I'm just.
Upload or extract these files on.
My desktop.
Now you just open file, go to options over here.
You just need to.
Go to.
Add ons.
It will take some time.
So over here.
As you see, manage go to comb edition.
Click go.
So in my case it is already available.
You just go to Add.
Then go to your desktop.
Over here.
This is my data streamer.
Just.
Place it.
Okay.
I already did this part.
It will take some time.
I just cancel it from here.
You just need to select this Excel data streamer so it is available in my case.
So right now I just go to data streamer.
So first I just upload the code to my Arduino.
Again.
The code is uploaded now in this case.
Do not select serial monitor.
Just close it.
Go to data streamer.
Connect the device as you see over here.
USB Serial.
Connect it.
So it will take some time.
Start data.
So as you see over here, I got four values.
This is my current value.
And these are my this is my channel one.
That is temperature.
This is my channel two.
This is my voltage, this is my current and this is my power.
So it will generate different values.
So all the different values.
As you see over here.
This is my time.
It is nearly 922.
As you see over here, my time is 922.
Just add 12.
It is a 24 hour clock.
So over here you just got.
Current value.
And below you have history data and you also set the sheet settings.
As you see.
So data interval number of data rows.
In the default case, it is 15.
You just put 100 also.
And default channels are ten.
You also change it.
Let's say it is four.
Let's go to data in, as you see.
So this is how you can grab or store the data generated from Arduino Uno using your program.
In this case, I am just generating dummy data.
You also connect your sensors to different digital pins or analog pins and grab the data.
Grab real time data from the.
Real world.
So this is how you can acquire.
Or store data into Excel using Arduino IDE.
Thank you.