1
00:00:05,000 --> 00:00:06,000
Hello, friends.

2
00:00:06,000 --> 00:00:13,000
Today I will tell you how to record data acquired by Arduino.

3
00:00:14,000 --> 00:00:17,000
In Excel for that purpose.

4
00:00:17,000 --> 00:00:22,000
I just over here write a dummy program.

5
00:00:23,000 --> 00:00:29,000
Right now, I'm not connecting any sensors to my Arduino board.

6
00:00:29,000 --> 00:00:33,000
First of all, as you see over here, this is my Arduino.

7
00:00:33,000 --> 00:00:35,000
Uno is not connected.

8
00:00:36,000 --> 00:00:42,000
In this case, you just need to connect your Arduino board with your PC.

9
00:00:43,000 --> 00:00:47,000
As you see, when I just connect it.

10
00:00:48,000 --> 00:00:57,000
Arduino you know on com five is available you can set it from here just set the board in the Arduino

11
00:00:57,000 --> 00:00:58,000
It is.

12
00:00:58,000 --> 00:01:01,000
Arduino Uno in the com com five.

13
00:01:02,000 --> 00:01:08,000
Now just write a code for solar power extraction through the.

14
00:01:09,000 --> 00:01:10,000
Renault board.

15
00:01:10,000 --> 00:01:17,000
So initially I just put a temperature variable that its initial value is zero.

16
00:01:17,000 --> 00:01:20,000
Then I put voltage.

17
00:01:20,000 --> 00:01:23,000
It is generated by.

18
00:01:24,000 --> 00:01:25,000
Voltage sensor.

19
00:01:25,000 --> 00:01:28,000
Then I put just.

20
00:01:29,000 --> 00:01:30,000
Current.

21
00:01:31,000 --> 00:01:31,000
Value.

22
00:01:31,000 --> 00:01:33,000
Its initial value again.

23
00:01:33,000 --> 00:01:34,000
Zero.

24
00:01:34,000 --> 00:01:37,000
And finally the power generated by my.

25
00:01:38,000 --> 00:01:39,000
Panel.

26
00:01:39,000 --> 00:01:43,000
So after this, here is void setup.

27
00:01:44,000 --> 00:01:48,000
So baud rate of my Arduino Uno is 9600.

28
00:01:49,000 --> 00:01:50,000
Then void loop.

29
00:01:50,000 --> 00:01:52,000
In this case.

30
00:01:53,000 --> 00:01:54,000
Over here.

31
00:01:54,000 --> 00:01:56,000
I just use temperature.

32
00:01:57,000 --> 00:01:59,000
It is random.

33
00:01:59,000 --> 00:02:03,000
Use random number in the case of my.

34
00:02:05,000 --> 00:02:07,000
The location is ghaziabad over here.

35
00:02:08,000 --> 00:02:12,000
Temperature varies from ten degree Celsius to 50 degree.

36
00:02:12,000 --> 00:02:14,000
55 degree Celsius.

37
00:02:17,000 --> 00:02:19,000
So in this case.

38
00:02:20,000 --> 00:02:27,000
My temperature varies from 10 degree Celsius to 55 degree Celsius, so I just use random number.

39
00:02:28,000 --> 00:02:32,000
So temperature initial value is ten and final value is 55.

40
00:02:32,000 --> 00:02:35,000
Maximum value is 55 then voltage.

41
00:02:36,000 --> 00:02:41,000
I just use a panel of 250 watt.

42
00:02:41,000 --> 00:02:45,000
Its voltage rating is from 0 to 35 volt.

43
00:02:46,000 --> 00:02:49,000
And current is from zero to maximum ten.

44
00:02:51,000 --> 00:02:55,000
And the power is voltage into current.

45
00:02:56,000 --> 00:02:58,000
It generates DC voltage.

46
00:02:58,000 --> 00:03:03,000
So initially I just print these values over my serial monitor.

47
00:03:03,000 --> 00:03:09,000
And I also show you these values on serial plotter.

48
00:03:09,000 --> 00:03:19,000
So I just use serial print temperature then separated by comma after that voltage, then current and

49
00:03:19,000 --> 00:03:21,000
finally power.

50
00:03:21,000 --> 00:03:27,000
So I just now upload this code to my Arduino.

51
00:03:29,000 --> 00:03:33,000
Right now, no sensor is connected to my Arduino board.

52
00:03:33,000 --> 00:03:35,000
Uploading is done.

53
00:03:35,000 --> 00:03:37,000
You just click on serial monitor.

54
00:03:38,000 --> 00:03:42,000
So over here when you just click on serial monitor.

55
00:03:43,000 --> 00:03:45,000
It will show you the.

56
00:03:47,000 --> 00:03:51,000
Different values as you see it will generate.

57
00:03:51,000 --> 00:03:53,000
You also put some delay inside this.

58
00:03:54,000 --> 00:04:02,000
So it is generating four values right now if you want to show these values in a plotter.

59
00:04:02,000 --> 00:04:08,000
Now, as you see over here, there is four values.

60
00:04:08,000 --> 00:04:12,000
First value is temperature, second value is voltage, third value is current.

61
00:04:12,000 --> 00:04:15,000
And finally, I got power.

62
00:04:16,000 --> 00:04:20,000
So this is how you can generate different values.

63
00:04:20,000 --> 00:04:26,000
Dummy values using Arduino, Uno or any Arduino.

64
00:04:27,000 --> 00:04:33,000
Now I just want to grab these values inside the Excel.

65
00:04:33,000 --> 00:04:36,000
So for that purpose, I just close this.

66
00:04:37,000 --> 00:04:38,000
I just.

67
00:04:39,000 --> 00:04:41,000
Close this also.

68
00:04:41,000 --> 00:04:53,000
Now, again, I open ID because if you want to just load this values inside the Excel right now your

69
00:04:53,000 --> 00:04:54,000
adeno is busy.

70
00:04:55,000 --> 00:04:58,000
So I just open ardino id again.

71
00:05:01,000 --> 00:05:01,000
Or you also.

72
00:05:02,000 --> 00:05:06,000
You can also remove this using the basic program.

73
00:05:06,000 --> 00:05:09,000
You just upload the basic program to the Arduino.

74
00:05:10,000 --> 00:05:17,000
So now I just not use the serial monitor in this case.

75
00:05:19,000 --> 00:05:21,000
So for Excel, I just.

76
00:05:22,000 --> 00:05:23,000
Right click new.

77
00:05:24,000 --> 00:05:26,000
Excel worksheet.

78
00:05:27,000 --> 00:05:30,000
So over here is solar data.

79
00:05:32,000 --> 00:05:34,000
So name it solar data.

80
00:05:35,000 --> 00:05:38,000
Now just open.

81
00:05:39,000 --> 00:05:39,000
This file.

82
00:05:43,000 --> 00:05:48,000
In this file, I just record the data of Arduino.

83
00:05:49,000 --> 00:05:50,000
That is created by.

84
00:05:51,000 --> 00:05:53,000
My previous code.

85
00:05:55,000 --> 00:05:56,000
It will take some time.

86
00:05:57,000 --> 00:06:06,000
So over here, as you see, there is a data streamer in your case, maybe it is not available.

87
00:06:06,000 --> 00:06:11,000
If it is not available, you just go to Google.

88
00:06:13,000 --> 00:06:14,000
Just.

89
00:06:15,000 --> 00:06:16,000
Place.

90
00:06:18,000 --> 00:06:19,000
Data streamer.

91
00:06:21,000 --> 00:06:21,000
Data.

92
00:06:24,000 --> 00:06:26,000
Streamer for Excel.

93
00:06:27,000 --> 00:06:32,000
So over here in this, you just go to Microsoft.

94
00:06:35,000 --> 00:06:37,000
Just download.

95
00:06:38,000 --> 00:06:40,000
Microsoft data streamer.

96
00:06:41,000 --> 00:06:45,000
As you see in this case, it is downloaded.

97
00:06:45,000 --> 00:06:47,000
So open is.

98
00:06:52,000 --> 00:06:54,000
You just need to open this.

99
00:06:57,000 --> 00:07:00,000
So over here, this is my data streamer file.

100
00:07:00,000 --> 00:07:03,000
So these files are required.

101
00:07:04,000 --> 00:07:06,000
To install the data streamer.

102
00:07:06,000 --> 00:07:07,000
It will take some time.

103
00:07:09,000 --> 00:07:15,000
So extract these files on desktop or anywhere.

104
00:07:15,000 --> 00:07:16,000
I'm just.

105
00:07:18,000 --> 00:07:21,000
Upload or extract these files on.

106
00:07:22,000 --> 00:07:24,000
My desktop.

107
00:07:24,000 --> 00:07:33,000
Now you just open file, go to options over here.

108
00:07:34,000 --> 00:07:36,000
You just need to.

109
00:07:40,000 --> 00:07:41,000
Go to.

110
00:07:42,000 --> 00:07:43,000
Add ons.

111
00:07:45,000 --> 00:07:46,000
It will take some time.

112
00:07:48,000 --> 00:07:49,000
So over here.

113
00:07:50,000 --> 00:07:54,000
As you see, manage go to comb edition.

114
00:07:56,000 --> 00:07:58,000
Click go.

115
00:07:58,000 --> 00:08:02,000
So in my case it is already available.

116
00:08:02,000 --> 00:08:04,000
You just go to Add.

117
00:08:06,000 --> 00:08:09,000
Then go to your desktop.

118
00:08:11,000 --> 00:08:12,000
Over here.

119
00:08:12,000 --> 00:08:13,000
This is my data streamer.

120
00:08:13,000 --> 00:08:14,000
Just.

121
00:08:15,000 --> 00:08:16,000
Place it.

122
00:08:16,000 --> 00:08:17,000
Okay.

123
00:08:17,000 --> 00:08:20,000
I already did this part.

124
00:08:20,000 --> 00:08:21,000
It will take some time.

125
00:08:21,000 --> 00:08:24,000
I just cancel it from here.

126
00:08:24,000 --> 00:08:30,000
You just need to select this Excel data streamer so it is available in my case.

127
00:08:31,000 --> 00:08:35,000
So right now I just go to data streamer.

128
00:08:35,000 --> 00:08:39,000
So first I just upload the code to my Arduino.

129
00:08:43,000 --> 00:08:43,000
Again.

130
00:08:45,000 --> 00:08:49,000
The code is uploaded now in this case.

131
00:08:49,000 --> 00:08:51,000
Do not select serial monitor.

132
00:08:53,000 --> 00:08:54,000
Just close it.

133
00:08:55,000 --> 00:08:57,000
Go to data streamer.

134
00:08:57,000 --> 00:09:02,000
Connect the device as you see over here.

135
00:09:02,000 --> 00:09:03,000
USB Serial.

136
00:09:05,000 --> 00:09:06,000
Connect it.

137
00:09:12,000 --> 00:09:15,000
So it will take some time.

138
00:09:22,000 --> 00:09:23,000
Start data.

139
00:09:26,000 --> 00:09:32,000
So as you see over here, I got four values.

140
00:09:32,000 --> 00:09:34,000
This is my current value.

141
00:09:34,000 --> 00:09:38,000
And these are my this is my channel one.

142
00:09:38,000 --> 00:09:39,000
That is temperature.

143
00:09:39,000 --> 00:09:40,000
This is my channel two.

144
00:09:40,000 --> 00:09:44,000
This is my voltage, this is my current and this is my power.

145
00:09:44,000 --> 00:09:48,000
So it will generate different values.

146
00:09:48,000 --> 00:09:50,000
So all the different values.

147
00:09:51,000 --> 00:09:53,000
As you see over here.

148
00:09:53,000 --> 00:09:54,000
This is my time.

149
00:09:54,000 --> 00:09:57,000
It is nearly 922.

150
00:09:57,000 --> 00:10:00,000
As you see over here, my time is 922.

151
00:10:00,000 --> 00:10:01,000
Just add 12.

152
00:10:01,000 --> 00:10:03,000
It is a 24 hour clock.

153
00:10:04,000 --> 00:10:06,000
So over here you just got.

154
00:10:07,000 --> 00:10:08,000
Current value.

155
00:10:08,000 --> 00:10:18,000
And below you have history data and you also set the sheet settings.

156
00:10:18,000 --> 00:10:19,000
As you see.

157
00:10:19,000 --> 00:10:22,000
So data interval number of data rows.

158
00:10:22,000 --> 00:10:24,000
In the default case, it is 15.

159
00:10:25,000 --> 00:10:26,000
You just put 100 also.

160
00:10:27,000 --> 00:10:30,000
And default channels are ten.

161
00:10:30,000 --> 00:10:31,000
You also change it.

162
00:10:31,000 --> 00:10:33,000
Let's say it is four.

163
00:10:35,000 --> 00:10:38,000
Let's go to data in, as you see.

164
00:10:39,000 --> 00:10:49,000
So this is how you can grab or store the data generated from Arduino Uno using your program.

165
00:10:49,000 --> 00:10:53,000
In this case, I am just generating dummy data.

166
00:10:53,000 --> 00:11:01,000
You also connect your sensors to different digital pins or analog pins and grab the data.

167
00:11:01,000 --> 00:11:04,000
Grab real time data from the.

168
00:11:05,000 --> 00:11:06,000
Real world.

169
00:11:06,000 --> 00:11:09,000
So this is how you can acquire.

170
00:11:09,000 --> 00:11:15,000
Or store data into Excel using Arduino IDE.

171
00:11:15,000 --> 00:11:16,000
Thank you.