Hello, friends.
Today I will tell you how to log solar solar panel data into Excel.
So for that purpose, first you have to extract data from the solar panel.
For that purpose, you have to connect your solar panel through the DEC card.
Or you can use Ardoino or some other controller.
You should.
Or you have to extract data from solar panel to your PC.
So first, let's say I have a deck card and I first extract data or voltage.
So for that purpose, I just go to measurement.
Back, Max.
So in this case, you have to first.
T it.
A channel, then you have to start the task.
Connect this.
Then you have to read.
Because right now we have to read the data of voltage and current from solar panel.
So just connect it like this.
Then you have to.
So we the task.
And after that, you have to stop that ask.
Okay.
So in this manner, you have to connect this.
Or you can use just.
Directly.
Stop that ask.
It is up to you.
And for continuous reading, you have to put a loop over reading.
So right now over here, as you see, create a constant over there.
And inside this, I virtually create my deck, as you see over here, to 080.
Analog input zero.
I get the voltage data over here.
You can select input voltage and over here you have to create an indicator.
Okay.
So in place of this, I just use a gauge over here.
So in this nomadic over here, this is my gauge.
It will show me the data of solar panel.
All this data.
As you see.
So like this if you want to read the current.
So just.
Create under another task.
So I just copy this the complete task and put it over here, as you see.
So over here, this is my.
Current data and I also put some error handler.
Connect this all here, so just make another error handler over here.
Just connect this.
So from a one, I get the current data, as you see over here.
This is how you can extract data from solar panel.
So it will show me current data.
It will show me all this data and you can adjust your ratings according to your SO solar panel or some
other input device like potentiometer or something.
So this is how you can extract the data.
Now you have to create an Excel file.
So just over here, I just create a stop button.
So now I want to store this data inside the Excel sheet.
So for that purpose, I just build a first array and just connect.
Or here, this is my voltage data.
This is my current data and I just increase this and this is my indexing and different points.
So control you and this.
Is connected to the edge.
And over here, I just.
More on.
So now let's say I want to see 100 data or 200 data.
In that case, you have to just make some changes over here.
Then this.
Data.
I just use comparison when this iteration value salutation values from here is greater than some value
or here.
This is the memory.
Greater than this automatically stop to control you over here.
So over here is the requirement of data.
Let's say 100 data or ten data or 20 data.
It won't stop.
And over here we get that data.
So let's say over here I just put ten.
So when duration is greater than ten, I got the data over here.
So then data and all this data.
So just go to file input output.
Right.
The limited file.
And over here you have to connect to your data.
And over here, you require a path for your file.
And in this case, you have to append the file, create constant.
And if you want to write again and again into your file, then in that case, you have to make it true.
And over here the delimiter is my comma.
So control you.
And over here you have to provide the path.
So first you have to create a CSV file.
I already create a CSV file.
Over here.
This is my ANOVA.
Don't CSB.
So I just also tell you how to create an Excel CSV file.
So just create Microsoft Excel as you see over here.
Let's say it is one, two, three.
The name is one, two, three.
So just open it.
And in that case, you have to just save this file.
In CSV format, comma delimited CSV format.
So as you see or here, just save it.
Some features or workbook might be not there.
So just.
See you close.
Close as you see or hear, my CSV file is created.
I just do it.
Press one.
So over here, we just.
We'll do those four part.
Select the CSV file.
Save it.
Control you.
So this is the program for data over here.
Analog data for the current and analog data for the voltage is there from the solar panel and it is
saved inside the one, two, three file.
First mutation will contain the number like zero one, two, three up to memory and second one will
get the current data and third one will get the voltage data according to the given program.
So this is how you can create or how you can log the data or solar panel into your Excel file.
Thank you.