Using Excel Data Streamer - Arduino Oscilloscope (Exceloscope part4: automation with data streamer)
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- How to use Excel Data Streamer in conjunction with Arduino as an oscilloscope alternative.
00:00 Introduction
00:20 How to enable Data Streamer in Microsoft Excel
00:40 Enabling the connection
01:08 Arduino Code
02:00 Microsoft Excel setup
02:20 Configuring number of samples
02:57 Linking the Excel Oscilloscope chart to the Data Streamer worksheet
03:45 Example of working operation.
Two of my favorite technologies ( MS Excel and arduino). And now I can run it together. Thanks. good work.
Glad you liked it. I agree excel is one of my all time favorites.
Simple example and good explanation. Thank you for this video tutorial.
Thankyou for your comment.
Hey man, this video was actually super helpful! Thank you! :)
I am glad it helped. Thanks for your comment.
saved me a ton of time thanks bro!
Thanks for the feedback.
Thank you for an excellent and precise presentation. * * * * *
Thanks for the feedback.
I haven't tried it yet. But very very interesting video.
Thank you
You are welcome! Thanks for the comment.
You have made some pretty good stuff, where about in Australia are you?
Thanks. Looks like you have some pretty interesting videos on your channel. I am in Perth.
@@overengineeredinoz7683 thanks mate, I’ve subbed and I’ll keep a look out for your stuff as it comes out. I’m in Melbourne
Cheers. I have subscribed to your channel and will work my way through your library. I like the wpf application that controls the Arduino led on and off video
Great stuff! How did you transfer data from data in sheet to your sheet? when I do same as you did the data doesn't appear in my sheet
I created formulas in my oscilloscope workheet that referred to the cells in the data in worksheet
Interesting,
btw would be nice to hear you better (louder) - so the funny adds between dont blow my speakers
Thanks that is really useful feedback.
Hey! How did you manage to start the time from 0? Mine always starts at 7s or 25 seconds. Thanks.
The Arduino is providing the time value. Have a look at th-cam.com/video/z1iB6dyCXOc/w-d-xo.html (first video in the series where we build up the code).
Hello! Excelent video! When I click com devices it doesn't appear any COM and I already have my COM26 active with the arduino IDE in this case I'm using an ESP32
For me the comxx number that appears for the Arduino ide is the same number that appears in excel for that device. You can't connect the excel one while the Arduino serial monitor or serial plotter are engaged. I have not tried with a com number as high as 26 but it should work. I have seen websites explaining how to reset the com number assigned to the device in windows. You could try that.
@@overengineeredinoz7683 that's correct I already figured out that I had to close the monitor from the arduino to use it on the Excel, thank you very much!
Glad it worked
How to use data streamer to plot real time voltage against current graph from the Arduino sensor?
What component are you trying to measure current through?
If it is a resistor you could measure the voltage on both sides and then calculate the current.
I want to import real-time barometric pressure data from an Arduino to an OpenOffice Calc spreadsheet. I am using OpenOffice Calc, because it is freeware and it still supports Windows XP. Could someone please tell me how to do this? I am not finding the information. LibreOffice Calc has the Streaming function, but it is not operational, yet... Meaning, it is grayed out.
I haven't any experience with OpenOffice Calc so unfortunately don't have any advice. I would be interested in hearing about it if you succeed.
what happens if you record the data for about 2 days. can the add-in handle it? or do you know what is the data in limit of this?
I have not tried that. I adjusted the settings to record 200 entries but I think It can be a higher number. I am not sure what the limit is. If you are taking many readings over days it might not be the most practical way to do it.
how did you increase the number of rows? (Mine has maximum 500 Rows)
On Excel Worksheet called "Settings". You can set the number of rows it keeps with the setting called "Data Rows"
hi! I can't see the Data streamer option in my excel what to do?
I think the Data Streamer option became available in the subscription (Microsoft 365) version of Excel. if you have an older version it may not be there. You could upgrade excel or use the manual cut and paste method as per the video titled: Oscilloscope using Arduino (ExcelOscope: part1: Building it)
Also make sure when you do File - Options - Add Ins that you are choosing "COM add ins" in the drop down menu not the default "Excel Add Ins" before pressing the Go button
Hi, have you tried sending data out from Excel to Arduino? I'm trying to figure out how it works
I actually haven't tried that yet.
Hi Alex. I got it to work. See this video: th-cam.com/video/umBarmiCWEo/w-d-xo.html
hi. is there anyway we can save the data with the timestamp?
On the automated worksheet called "Data In" that excel fills in with the data it receives it has a column TIME. That column contains the date/time that the data was received.
@@overengineeredinoz7683 yes, but when you save the data, the date/time not appeared. it only shows the data recorded from the sensor