1
00:00:10,000 --> 00:00:11,000
Hello, friends.

2
00:00:11,000 --> 00:00:19,000
Today I will tell you how to log solar solar panel data into Excel.

3
00:00:20,000 --> 00:00:28,000
So for that purpose, first you have to extract data from the solar panel.

4
00:00:28,000 --> 00:00:33,000
For that purpose, you have to connect your solar panel through the DEC card.

5
00:00:33,000 --> 00:00:36,000
Or you can use Ardoino or some other controller.

6
00:00:37,000 --> 00:00:37,000
You should.

7
00:00:38,000 --> 00:00:43,000
Or you have to extract data from solar panel to your PC.

8
00:00:44,000 --> 00:00:54,000
So first, let's say I have a deck card and I first extract data or voltage.

9
00:00:54,000 --> 00:00:58,000
So for that purpose, I just go to measurement.

10
00:00:59,000 --> 00:01:00,000
Back, Max.

11
00:01:01,000 --> 00:01:05,000
So in this case, you have to first.

12
00:01:05,000 --> 00:01:06,000
T it.

13
00:01:07,000 --> 00:01:12,000
A channel, then you have to start the task.

14
00:01:15,000 --> 00:01:16,000
Connect this.

15
00:01:18,000 --> 00:01:20,000
Then you have to read.

16
00:01:20,000 --> 00:01:29,000
Because right now we have to read the data of voltage and current from solar panel.

17
00:01:30,000 --> 00:01:33,000
So just connect it like this.

18
00:01:33,000 --> 00:01:35,000
Then you have to.

19
00:01:36,000 --> 00:01:38,000
So we the task.

20
00:01:40,000 --> 00:01:43,000
And after that, you have to stop that ask.

21
00:01:44,000 --> 00:01:45,000
Okay.

22
00:01:45,000 --> 00:01:49,000
So in this manner, you have to connect this.

23
00:01:55,000 --> 00:01:57,000
Or you can use just.

24
00:01:58,000 --> 00:01:58,000
Directly.

25
00:01:58,000 --> 00:02:00,000
Stop that ask.

26
00:02:01,000 --> 00:02:02,000
It is up to you.

27
00:02:05,000 --> 00:02:11,000
And for continuous reading, you have to put a loop over reading.

28
00:02:11,000 --> 00:02:18,000
So right now over here, as you see, create a constant over there.

29
00:02:21,000 --> 00:02:31,000
And inside this, I virtually create my deck, as you see over here, to 080.

30
00:02:31,000 --> 00:02:33,000
Analog input zero.

31
00:02:33,000 --> 00:02:37,000
I get the voltage data over here.

32
00:02:37,000 --> 00:02:45,000
You can select input voltage and over here you have to create an indicator.

33
00:02:46,000 --> 00:02:47,000
Okay.

34
00:02:47,000 --> 00:02:54,000
So in place of this, I just use a gauge over here.

35
00:02:55,000 --> 00:03:01,000
So in this nomadic over here, this is my gauge.

36
00:03:02,000 --> 00:03:06,000
It will show me the data of solar panel.

37
00:03:08,000 --> 00:03:09,000
All this data.

38
00:03:12,000 --> 00:03:13,000
As you see.

39
00:03:13,000 --> 00:03:18,000
So like this if you want to read the current.

40
00:03:18,000 --> 00:03:19,000
So just.

41
00:03:20,000 --> 00:03:23,000
Create under another task.

42
00:03:24,000 --> 00:03:35,000
So I just copy this the complete task and put it over here, as you see.

43
00:03:35,000 --> 00:03:37,000
So over here, this is my.

44
00:03:40,000 --> 00:03:49,000
Current data and I also put some error handler.

45
00:03:50,000 --> 00:03:58,000
Connect this all here, so just make another error handler over here.

46
00:04:01,000 --> 00:04:03,000
Just connect this.

47
00:04:04,000 --> 00:04:11,000
So from a one, I get the current data, as you see over here.

48
00:04:11,000 --> 00:04:16,000
This is how you can extract data from solar panel.

49
00:04:16,000 --> 00:04:19,000
So it will show me current data.

50
00:04:19,000 --> 00:04:27,000
It will show me all this data and you can adjust your ratings according to your SO solar panel or some

51
00:04:27,000 --> 00:04:33,000
other input device like potentiometer or something.

52
00:04:36,000 --> 00:04:40,000
So this is how you can extract the data.

53
00:04:40,000 --> 00:04:44,000
Now you have to create an Excel file.

54
00:04:45,000 --> 00:04:50,000
So just over here, I just create a stop button.

55
00:04:50,000 --> 00:04:57,000
So now I want to store this data inside the Excel sheet.

56
00:04:57,000 --> 00:05:04,000
So for that purpose, I just build a first array and just connect.

57
00:05:04,000 --> 00:05:06,000
Or here, this is my voltage data.

58
00:05:07,000 --> 00:05:15,000
This is my current data and I just increase this and this is my indexing and different points.

59
00:05:15,000 --> 00:05:19,000
So control you and this.

60
00:05:20,000 --> 00:05:21,000
Is connected to the edge.

61
00:05:21,000 --> 00:05:23,000
And over here, I just.

62
00:05:25,000 --> 00:05:27,000
More on.

63
00:05:29,000 --> 00:05:35,000
So now let's say I want to see 100 data or 200 data.

64
00:05:35,000 --> 00:05:40,000
In that case, you have to just make some changes over here.

65
00:05:41,000 --> 00:05:42,000
Then this.

66
00:05:44,000 --> 00:05:45,000
Data.

67
00:05:46,000 --> 00:05:56,000
I just use comparison when this iteration value salutation values from here is greater than some value

68
00:05:57,000 --> 00:05:57,000
or here.

69
00:05:57,000 --> 00:05:59,000
This is the memory.

70
00:06:06,000 --> 00:06:11,000
Greater than this automatically stop to control you over here.

71
00:06:11,000 --> 00:06:15,000
So over here is the requirement of data.

72
00:06:15,000 --> 00:06:18,000
Let's say 100 data or ten data or 20 data.

73
00:06:18,000 --> 00:06:19,000
It won't stop.

74
00:06:19,000 --> 00:06:21,000
And over here we get that data.

75
00:06:22,000 --> 00:06:25,000
So let's say over here I just put ten.

76
00:06:25,000 --> 00:06:30,000
So when duration is greater than ten, I got the data over here.

77
00:06:31,000 --> 00:06:33,000
So then data and all this data.

78
00:06:33,000 --> 00:06:37,000
So just go to file input output.

79
00:06:38,000 --> 00:06:39,000
Right.

80
00:06:39,000 --> 00:06:40,000
The limited file.

81
00:06:42,000 --> 00:06:46,000
And over here you have to connect to your data.

82
00:06:46,000 --> 00:06:52,000
And over here, you require a path for your file.

83
00:06:53,000 --> 00:07:00,000
And in this case, you have to append the file, create constant.

84
00:07:01,000 --> 00:07:09,000
And if you want to write again and again into your file, then in that case, you have to make it true.

85
00:07:10,000 --> 00:07:15,000
And over here the delimiter is my comma.

86
00:07:15,000 --> 00:07:17,000
So control you.

87
00:07:17,000 --> 00:07:21,000
And over here you have to provide the path.

88
00:07:21,000 --> 00:07:26,000
So first you have to create a CSV file.

89
00:07:26,000 --> 00:07:28,000
I already create a CSV file.

90
00:07:28,000 --> 00:07:28,000
Over here.

91
00:07:28,000 --> 00:07:31,000
This is my ANOVA.

92
00:07:32,000 --> 00:07:33,000
Don't CSB.

93
00:07:33,000 --> 00:07:38,000
So I just also tell you how to create an Excel CSV file.

94
00:07:38,000 --> 00:07:42,000
So just create Microsoft Excel as you see over here.

95
00:07:42,000 --> 00:07:44,000
Let's say it is one, two, three.

96
00:07:45,000 --> 00:07:47,000
The name is one, two, three.

97
00:07:47,000 --> 00:07:49,000
So just open it.

98
00:07:55,000 --> 00:08:00,000
And in that case, you have to just save this file.

99
00:08:05,000 --> 00:08:10,000
In CSV format, comma delimited CSV format.

100
00:08:10,000 --> 00:08:13,000
So as you see or here, just save it.

101
00:08:14,000 --> 00:08:17,000
Some features or workbook might be not there.

102
00:08:17,000 --> 00:08:18,000
So just.

103
00:08:19,000 --> 00:08:21,000
See you close.

104
00:08:25,000 --> 00:08:29,000
Close as you see or hear, my CSV file is created.

105
00:08:29,000 --> 00:08:30,000
I just do it.

106
00:08:30,000 --> 00:08:31,000
Press one.

107
00:08:31,000 --> 00:08:33,000
So over here, we just.

108
00:08:34,000 --> 00:08:36,000
We'll do those four part.

109
00:08:37,000 --> 00:08:39,000
Select the CSV file.

110
00:08:39,000 --> 00:08:39,000
Save it.

111
00:08:40,000 --> 00:08:41,000
Control you.

112
00:08:42,000 --> 00:08:46,000
So this is the program for data over here.

113
00:08:46,000 --> 00:08:54,000
Analog data for the current and analog data for the voltage is there from the solar panel and it is

114
00:08:54,000 --> 00:08:58,000
saved inside the one, two, three file.

115
00:08:58,000 --> 00:09:07,000
First mutation will contain the number like zero one, two, three up to memory and second one will

116
00:09:07,000 --> 00:09:13,000
get the current data and third one will get the voltage data according to the given program.

117
00:09:13,000 --> 00:09:23,000
So this is how you can create or how you can log the data or solar panel into your Excel file.

118
00:09:23,000 --> 00:09:24,000
Thank you.