Thanks for your series of videos that lead me to understand more about execl-arduino connection. one question: can the data out sheet have more than 10chs? if we need to transfer more than 10 columns, what possibly can we do? thanks anyway.
Hi thanks for the great video,is it possible to connect an led screen that displays voltages and current to excel? Whatever the values on the screen will show in excel?
I measure voltage and show that in excel in the oscilloscope video. Using Excel Data Streamer - Arduino Oscilloscope (Exceloscope part4: automation with data streamer) For current you would want to have a known resistor in the circuit and then measure the voltage drop across it and then use ohms law to work out the current. An excel formula could be used to do the calculation or you could do it on the Arduino side.
Great video! Thank-you for sharing. What is the maximum number of output channels Excel will allow? The default in your video is 10, but microcontrollers such as the Arduino MEGA 2560 can handle many more. I'm curios if Excel has an output limit.
I haven't experimented with changing it but even if you are stuck with 10 there would be the possibility to use some sort of character as a separator and then put more than one set of information in each channel and then split it on the Arduino side.
@@overengineeredinoz7683 Thank-you for responding. That is a great idea to combine data into 10 channels if it is limited. I am hoping to be able to output to about 24 channels.
Is there any way to import the table into the Arduino or something like that? In my project I want it to be something more remote, without the need for a computer.
I wonder if can we communicate Excel Data Streamer to Adruino with WS2812 LED attached. A simple task, if I put number 2 in Cell A2, then 2nd LED will turn on.
Hello, that is really great what have you done and show here. Is it possible to control from excel addressable LEDs WS2812B? The idea is to connect the Barcode or QR Code Scanner to the computer and depends on which barcode would be scanned then proper individual LED would light up?
It is probably possible. I don't have any experience with ws2812b or barcode scanners but if they can appear as com port to computer it could work. Otherwise if you are able to read from the scanner to Arduino and control those ws2812b from Arduino then it would definitely be possible to do.
Hi, i'm currently doing a project where I have a set of list in excel and i need it to link the code numbers in the list to the LED lights without the need of typing "TRUE" or "FALSE". Is this possible?
Thanks. Here is links to the code from the video. github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_7Segment github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_LEDs github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_RGB_LED github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_Servos
Hi. Great video. I am using the servo control part of your code for my project. I was wondering if there is a way to control servo speed while keeping the same working principal?
I think to control servi speed I would try passing smaller incremental positions on the way to where the servo needs to end up. This could be done on Arduino side if still not slow enough try introducing a small delay between each new servo position command.
I have done the process for the servo part but I couldn't find the same icon to connect the com port except that everything that you explained was crt and I got r8 Pls help me with it to found out the error to the connection between excel to arduino If you provide your contact details like mail it would be helpful
I'm new to arduino. In fact I have one ordered buy haven't received it yet. My though is to use excel activex controls to control fan speed through the arduino. In other words build a cheap labview interface (I don't have) using excel (which I already have. It seems, using this method that it would be possible. Just send out a serial string when a value, in excel, is changed. But I ponder if using the computer's parallel interface wouldn't be more efficient. (yup. I still have a computer with a parallel interface (aka printer port). Assign each output pin (there's 8 total) on the parallel port to one of the control channels. BTW, I am already using parallel ports in this manner for other applications. It means not having to shell out mucho dinero for labview I/O boards/software.
Thanks for the comment! I don't have any experience with using a parallel interface so I won't comment on that. On the Arduino side of things what you are wanting to do is definitely possible. You can generate pulse width modulation signals from the Arduino really quite easily and that could be used to vary the speed of your fan motor. You probably wouldn't want the motor directly interfacing to the arduino pin without adding some other circuitry due to the motor being an inductive load that could generate spikes on the arduino pin and damage it. Often with motors a thing called an H-Bridge circuit is used.
@@overengineeredinoz7683 Yes I have a couple l298h driver for a small motor. The fan on the otherhand is 12A so I will build a driver circuit using some 20A transistors. I could control the fan through external means but where's the fun in that?? But, first I need to learn how to setup the Arduino. I just checked and it's out for delivery. Should be there when I get home tonight. I am building a wind tunnel to test drag and lift of golf discs. I'm currently working out how to spin the disc while it's in the tunnel and still monitor the lift and drag. drone motor mounted inline on the shaft between the load cell and the disc? I want to minimize the influence of the weight of the motor.
Very nice lesson, but why must so many who instruct via a keyboard, have to SLAP THE CRAP OUT OF THE ENTER OR RETURN KEY? Tap, tap, tap, tap, BANG! Is it some sort of self projection thing?
Thanks. Here is links to the code from the video. github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_7Segment github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_LEDs github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_RGB_LED github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_Servos
Great video 👍
Thanks
Thanks for your series of videos that lead me to understand more about execl-arduino connection.
one question: can the data out sheet have more than 10chs? if we need to transfer more than 10 columns, what possibly can we do? thanks anyway.
my bad, i found it on the setting sheet.
glad you found it. I have another video about communicating more than 10 items too.
Hi thanks for the great video,is it possible to connect an led screen that displays voltages and current to excel?
Whatever the values on the screen will show in excel?
I measure voltage and show that in excel in the oscilloscope video.
Using Excel Data Streamer - Arduino Oscilloscope (Exceloscope part4: automation with data streamer)
For current you would want to have a known resistor in the circuit and then measure the voltage drop across it and then use ohms law to work out the current. An excel formula could be used to do the calculation or you could do it on the Arduino side.
Great video! Thank-you for sharing. What is the maximum number of output channels Excel will allow? The default in your video is 10, but microcontrollers such as the Arduino MEGA 2560 can handle many more. I'm curios if Excel has an output limit.
I haven't experimented with changing it but even if you are stuck with 10 there would be the possibility to use some sort of character as a separator and then put more than one set of information in each channel and then split it on the Arduino side.
@@overengineeredinoz7683 Thank-you for responding. That is a great idea to combine data into 10 channels if it is limited. I am hoping to be able to output to about 24 channels.
@@loddie9 I have done another video showing how to do more than ten channels.
Is there any way to import the table into the Arduino or something like that? In my project I want it to be something more remote, without the need for a computer.
You could probably write the data received from excel to the eeprom. Then install your other sketch and have it read from the eeprom.
I wonder if can we communicate Excel Data Streamer to Adruino with WS2812 LED attached. A simple task, if I put number 2 in Cell A2, then 2nd LED will turn on.
It sounds possible to me.
@@overengineeredinoz7683 i wish to get some advice to achieve that. Thank you.
Hello, that is really great what have you done and show here. Is it possible to control from excel addressable LEDs WS2812B? The idea is to connect the Barcode or QR Code Scanner to the computer and depends on which barcode would be scanned then proper individual LED would light up?
It is probably possible. I don't have any experience with ws2812b or barcode scanners but if they can appear as com port to computer it could work. Otherwise if you are able to read from the scanner to Arduino and control those ws2812b from Arduino then it would definitely be possible to do.
Hi, i'm currently doing a project where I have a set of list in excel and i need it to link the code numbers in the list to the LED lights without the need of typing "TRUE" or "FALSE". Is this possible?
Yes I think it would be possible. Excel sends data to Arduino in a comma separated list. You can then process the data on the Arduino side.
This is really cool. can i ask your sample code for this for my plan project?
Thanks. Here is links to the code from the video.
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_7Segment
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_LEDs
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_RGB_LED
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_Servos
@@overengineeredinoz7683 thank you so much,,very appreciated.
@@overengineeredinoz7683 you are so great!
Hi. Great video. I am using the servo control part of your code for my project. I was wondering if there is a way to control servo speed while keeping the same working principal?
I think to control servi speed I would try passing smaller incremental positions on the way to where the servo needs to end up. This could be done on Arduino side if still not slow enough try introducing a small delay between each new servo position command.
I have done the process for the servo part but I couldn't find the same icon to connect the com port except that everything that you explained was crt and I got r8
Pls help me with it to found out the error to the connection between excel to arduino
If you provide your contact details like mail it would be helpful
I think the answer you are looking for will be covered in my video send data to Arduino using excel data streamer
The playlist excel data streamer will probably be useful for you.
Hello sir, Why I cant do this project with esp32 ?? ESP32 not answer
Can you get it to read and write to and from the serial monitor?
@@overengineeredinoz7683 can it do in arduino uno r3 ?
@@yingnie2022 uno r3 should work fine
I'm new to arduino. In fact I have one ordered buy haven't received it yet.
My though is to use excel activex controls to control fan speed through the arduino.
In other words build a cheap labview interface (I don't have) using excel (which I already have.
It seems, using this method that it would be possible.
Just send out a serial string when a value, in excel, is changed.
But I ponder if using the computer's parallel interface wouldn't be more efficient.
(yup. I still have a computer with a parallel interface (aka printer port).
Assign each output pin (there's 8 total) on the parallel port to one of the control
channels.
BTW, I am already using parallel ports in this manner for other applications.
It means not having to shell out mucho dinero for labview I/O boards/software.
Thanks for the comment!
I don't have any experience with using a parallel interface so I won't comment on that.
On the Arduino side of things what you are wanting to do is definitely possible. You can generate pulse width modulation signals from the Arduino really quite easily and that could be used to vary the speed of your fan motor. You probably wouldn't want the motor directly interfacing to the arduino pin without adding some other circuitry due to the motor being an inductive load that could generate spikes on the arduino pin and damage it.
Often with motors a thing called an H-Bridge circuit is used.
@@overengineeredinoz7683 Yes I have a couple l298h driver for a small motor. The fan on the otherhand is 12A so I will build a driver circuit using some 20A transistors. I could control the fan through external means but where's the fun in that??
But, first I need to learn how to setup the Arduino. I just checked and it's out for delivery. Should be there when I get home tonight.
I am building a wind tunnel to test drag and lift of golf discs. I'm currently working out how to spin the disc while it's in the tunnel and still monitor the lift and drag.
drone motor mounted inline on the shaft between the load cell and the disc? I want to minimize the influence of the weight of the motor.
Sounds like an interesting project.
Very nice lesson, but why must so many who instruct via a keyboard, have to SLAP THE CRAP OUT OF THE ENTER OR RETURN KEY? Tap, tap, tap, tap, BANG! Is it some sort of self projection thing?
Thanks for the feedback. I wasn't aware I was doing it. I guess it is a habit I will have to adjust.
Bom dia! I love your work! I want this sketch. Please!
Thanks. Here is links to the code from the video.
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_7Segment
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_LEDs
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_RGB_LED
github.com/OverEngineeredInOz/RUclips/tree/master/Excel_Data_Streamer_control_Servos
Can you zoom in a bit next time? Very hard to read the code. Thanks
Thanks for the feedback. That is a good suggestion.
you can see the code in GitHup
@@yingnie2022 github userid