- 13
- 90 813
ChefJeffPhD
เข้าร่วมเมื่อ 6 ต.ค. 2012
Hi, I'm Jeff Ackerman (aka ChefJeffPhD), and I'm a PhD mechanical engineer, educator, and entrepreneur. I plan to use my TH-cam channel to create content about learning engineering, developing technical skills, and to showcase some cool projects.
Save Arduino Serial Data to TXT, CSV, or Excel Using CoolTerm | Step-by-Step Guide
Learn how to collect, save, and analyze Arduino serial data using CoolTerm to create a TXT or Excel data file in this step-by-step tutorial.
In this video, I demonstrate how to set up a photoresistor with an Arduino, use the Serial Monitor and Serial Plotter, and configure Arduino to create comma-separated serial output values. I'll guide you through the process of using CoolTerm to save data as a TXT file, import it into Excel, visualize the data by plotting it, and calculate the average value of the collected data.
What you'll learn:
00:00 How to wire and set up a photoresistor with Arduino
01:00 Arduino code setup to read an analog voltage
03:07 Using the Arduino Serial Monitor and plotter for real-time data monitoring
03:56 How to create comma-separated output for easy data handling
05:38 Step-by-step guide on saving Arduino serial data to a TXT file using CoolTerm
10:00 Importing TXT file data into Excel
11:32 Plotting data and finding average values in Excel
If you want to learn a similar easy-to-use software to do the same thing directly in Excel (Windows-only), check out my other video on the topic:
th-cam.com/video/yGRhx2JYyOc/w-d-xo.html
Don’t forget to Like the video if it's helpful to you.
Resources:
Download CoolTerm: freeware.the-meiers.org
#arduino #datacollection #excel #txt #serial #arduinotutorial #dataanalysis #diy
In this video, I demonstrate how to set up a photoresistor with an Arduino, use the Serial Monitor and Serial Plotter, and configure Arduino to create comma-separated serial output values. I'll guide you through the process of using CoolTerm to save data as a TXT file, import it into Excel, visualize the data by plotting it, and calculate the average value of the collected data.
What you'll learn:
00:00 How to wire and set up a photoresistor with Arduino
01:00 Arduino code setup to read an analog voltage
03:07 Using the Arduino Serial Monitor and plotter for real-time data monitoring
03:56 How to create comma-separated output for easy data handling
05:38 Step-by-step guide on saving Arduino serial data to a TXT file using CoolTerm
10:00 Importing TXT file data into Excel
11:32 Plotting data and finding average values in Excel
If you want to learn a similar easy-to-use software to do the same thing directly in Excel (Windows-only), check out my other video on the topic:
th-cam.com/video/yGRhx2JYyOc/w-d-xo.html
Don’t forget to Like the video if it's helpful to you.
Resources:
Download CoolTerm: freeware.the-meiers.org
#arduino #datacollection #excel #txt #serial #arduinotutorial #dataanalysis #diy
มุมมอง: 2 413
วีดีโอ
Creating a Circuit Schematic with Custom Components Using circuit-diagram.org
มุมมอง 1.8K8 หลายเดือนก่อน
Hey everyone, in this video I'll show you how to create a simple circuit schematic with custom components using the www.circuit-diagram.org/ website. This video serves as a quick guide for students, makers, and engineers to create simple circuit schematic diagrams with an emphasis on custom components to communicate your ideas to others (and future you). In this tutorial, we cover: Navigation a...
Arduino Data Logging with Microsoft Excel Data Streamer
มุมมอง 8K9 หลายเดือนก่อน
In this video, I show you how to collect some data with an Arduino, send the data in a comma-separated variable format via Serial communication, and capture that data directly into a .csv data file using the built-in Microsoft Excel Data Streamer tool.
Arduino + PEMENOL Sound or Music Playback Module (MP3 Trigger) Tutorial
มุมมอง 12K2 ปีที่แล้ว
I made this video to explain how to use the PEMENOL Voice Playback Module MP3 Trigger with an Arduino. The documentation for this device is spotty, so the purpose of this video is to show the simplest way to trigger sounds or songs from your own .mp3 or .wav files using an Arduino.
Arduino + Aideepen YX5300 Serial MP3 Music or Sound Player Tutorial (SerialMP3Player Library)
มุมมอง 8K2 ปีที่แล้ว
This video shows how to use the "SerialMP3Player" library to control a YX5300 MP3 Music or Sound Player (MP3 Trigger). The goal of this video is to show the most basic setup to play one sound file using the YX5300, an Arduino, and a Bluetooth speaker with a 3.5 mm aux audio cable.
SolidWorks Radiation Heat Transfer Study Example for a Vacuum Former
มุมมอง 6K3 ปีที่แล้ว
This video shows how to create a steady-state and transient heat transfer study for an example vacuum former with radiation being the primary means of heat transfer. The study also includes a heater power input to simulate and select an appropriate heater power and convection losses in an inside ambient air room environment. Hope this helps! 0:00 Initial Setup 1:25 Steady State Heat Transfer Se...
Harbor Freight Impact Driver Reverse Engineering
มุมมอง 7523 ปีที่แล้ว
Harbor Freight Impact Driver Reverse Engineering
SolidWorks Transient Heat Transfer Analysis - How Long to Heat Up?
มุมมอง 18K3 ปีที่แล้ว
In this video, I show how to use SolidWorks to conduct a Transient Heat Transfer Analysis. Our goal is to estimate how long it will take to heat up an plastic filament extruder assembly from room temperature up to around 210 degrees C. This is a simplified simulation which ignores convection (assume good insulation) and uses heater bands to input a certain wattage into the extruder tube with th...
The Eco Face Shield
มุมมอง 1263 ปีที่แล้ว
Hi, I'm Dr. Jeff Ackerman, inventor of the Eco Face Shield, a fully-recyclable face shield design made from one piece of plastic. It's a super-comfortable face shield with a universal adult fit and a double-sided anti-fog coating that can be reused and fully recycled. With the Eco Face Shield, you get full-face protection with less waste. Protect the yourself and protect the earth - the Eco Fac...
SolidWorks Shaft FEA Example for Plastic Shredder
มุมมอง 6K4 ปีที่แล้ว
This is an example of how you can simulate the stress on a 0.5" hex shaft supported on the ends by ball bearings using a SolidWorks FEA simulation.
How to Record Your Screen on Zoom and Share the Video
มุมมอง 1.4K4 ปีที่แล้ว
I found a simple workflow for recording your screen on Zoom and easily sharing the video file using a link. I hope this video is helpful for fellow teachers that are working to move their class material online. Let me know if you have any questions! I learned that Zoom is offering free full-version accounts for educators due to the recent transition to online learning - here's the request link:...
SolidWorks CAM 2018 Tutorial - Basic CNC Pocket and Drilling Operation Setup
มุมมอง 26K5 ปีที่แล้ว
This is an introductory tutorial on how to setup pocket milling and hole drilling CAM operations with initial feeds and speeds for a simple part to be made on a HASS Mini Mill 2 CNC.
RoboTable - Robotic Overbed Table by Prehensile Technologies
มุมมอง 6665 ปีที่แล้ว
RoboTable is a robotic overbed table for beds, recliners, and wheelchairs. It allows a user to independently deploy, position, and store mobile devices using a remote or accessible switches from a bed or chair. We are looking for early adopters. For more info, check out our website and send us an email: www.prehensiletechnologies.com/ info@prehensiletechnologies.com We are grateful for the supp...
Hi, It works with Arduino uno R3 but not with the R4 Wifi? In the serial monitor it shows the data but when I connect excel it does not show for R4, whereas it does for R3. Is there any workaround for this?
@@Unfreeze007 I’m not sure if the R4 is supported by Excel Data Streamer. I’d recommend trying another Serial terminal option called CoolTerm (I made a video about this) or writing/finding a Python code that can read the data via the PySerial library.
Thank you!
very helpful
sir how to setup flow simulation study - suppose a gas like N2 at 300℃ entering a reactor and heating catalyst which is initially at room temperature, i want to time taken for the catalyst bed to reach 300℃, please help me
very interesting, thank you !
How to set title column automatically
I'm not sure how to do that in CoolTerm. There might be a setting that could accomplish that. One option would be to trigger the "Serial.print();" functions using a button or other boolean command and then have the first print statements after the data collection trigger be the column titles separated by commas. That would probably work.
what board are you selecting in arduino ide?
Great Vid and it might explain my issue I have had. I also wonder if it will do exactly the same with an ESP32 board? (only cos I have one)
how would this change if you use it in the flow simulation
Thank you for provide great instructions. Have a great weekend.
Hello, is it possible to record "TIME" colon also? When I want to export CSV file, I wan't to see time info.
I have also same problem. Did you fix it?
@@negarmeshkini2304 Same here, without the timestamp it's useless.
Your video is excellent, explain clearly and in detail. Learn a lot indeed. Do you use Ansys? I am eager to watch your some video Ansys thermomechanical simulation using Ansys software.
Your 100th like Professor!
Arduino with Excel is a recreational programming Disneyworld. Never had such fun. And this video made it even better. Thank you, ChefJeff!
This video reallh helped me submit my diagram for my technical project professionally. I dont know why they dont have the H-bridgequad driver IC natively, so I created one with the assistance 5 mins of this video. Thanks!!
how to draw a thermostat, sir?
Great Work Jeff! We'd love to offer you some boards if you might need them in the upcoming content. (PCBWayDaisy)
That would be great! I’ve been meaning to create some PCBs.
means that you need the arduino?
My excel not recognised the Arduino com, how to fix it?
I’d recommend trying to verify and identify the Serial COM port in the Arduino IDE, view the data in the Arduino IDE Serial Monitor, close it, and try to connect to it in Excel.
hi please help me out, i have a arduino uno r4 wifi board and everything is working fine except when i press start data, no data seems to be streaming in
I think that's a known issue. It's not quite compatible with recent new arduino versions. The potential solution is to add Serial.dtr(); in the setup function.
Hmm I’m not sure about this issue. I just got an R4 recently to try out but haven’t had time to test it. Could be compatibility issues like the commenter suggests. It’s new hardware, so I’m unclear if it’s supported in Data Streamer. This setup should theoretically work with any Serial Output from a COM channel. Maybe you could try using CoolTerm - I made a video about that too.
thank you
Thats good stuff. I am trying really hard to learn Arduino but most people do not explain what the line functions are like you have. That is very helpful to a guy starting out.
I didn't realize that Excel had that feature, this will be very handy - thank you. Also, you can copy from the Arduino IDE serial monitor, I did it this afternoon.
For some reason I’m not able to copy paste from it. I used to be able to do it on V1.7 before the current Arduino v2.X software update.
This is a great presentation. I did not know this can be done. And in addition, I too use SolidWorks in my daily work and I noticed you have several SolidWorks related videos. Thank you for sharing the Arduino information.
Great explanation, I didn't know about the Data Streamer, it looks really useful!
Hello, i have a project that is using MP3 all the code is fine and if i connect my earpiece to the MP3 it will work but when i connect to the speaker its very soft, what can i do?
Can you make a video showing how to attach a separate momentary switch for each channel.
I followed exactly but cant get it to trigger at all. I dont understand high or low. what do you mean? Plus I cant see exactly where the wires are plugged in on your modules. Too blurry.
Hi, Why I can have a black Convection icon and a blue convection icon also?
The day I even consider putting a $70 mouse in my shopping cart…
Ha I didn’t even notice that! Didn’t end up getting that mouse.
Thanks for making the video, is it possible to set up one trigger with multiple different sounds that you can skip thru?
No UART mode example? Grounding specific pins might be fine for a couple of sounds, but you quickly use up all your GPIOs if you do it this way.
I got this board. It is perfect for what I want to do . I am using a ultrasonic sensor at 2 different thresholds I want to play a sound. It works but when I have it set to return to high after my last threshold. It just repeats the last sound byte . What am I doing wrong?
I found that it works best if you trigger an adjacent pin with no sound or a short sound to interrupt playing the first sound. It’s a bit of a hacky solution, but it usually works. The pins sometimes play the whole song or sound when triggered with a short press. There may be some timing to the triggering it I’m unaware of. Try triggering an adjacent pin to stop the sound.
@@ChefJeffPhD wow didn't think you was going to reply so fast for being a older video.. I'll give it a shot. I have a couple more things I want to trigger with it. by looking at vague instructions, it says once trigger 7 is done it goes back high. I have 6 things to have triggered and I will make 7 no sound .
@@ChefJeffPhD hey there, after many many attempts to get this to work. I figured it out .. I had to write the code in the void setup to treat the mp3 trigger by receiving a signal from a button. But there is no button.
im asumming this could be connected to a 3.3 v pico too as long as as the voltage is taken care of.i am wondering though,how would i go about attaching leds to this also.Is this possible?
I believe that this chip is supposed to work on 5V. I’m not sure if 3.3V will provide enough power for the chip and electronics on board, but it could be worth a try. I don’t have this board on hand anymore to check. You could attach LEDs onto the trigger pins to visualize the trigger logic - they will be high by default and low when triggered. It would probably be better to use the microcontroller to attach the LEDs.
You need 5v. You generally have 5V going into the pico which you can tap off the VBUS pin of the pico to get your 5v.
Professor I still have a question, can this board respond to PWM? I know that I can use individual PWM switch boards in order to control each pin via PWM, but is there ANY other playback board like this one that responds to PWM?
Thanks for the video. I'm not using an arduino, though. How might I trigger this using, say, a "Try me" button? Also, I'm using the DY-HU8F module, and I rashly deleted the files that were on it, but I remember that they were named like "1-whatever.mp3", "2-whatever.mp3", and so on. So, is there flexibility in the naming? As you observed, instructions are minimal.
I believe the filing naming needs to be “0001.mp3”, “0002.mp3”, etc. the file naming does need a specific format when triggering them directly from the pins. If your using another device or a button, you can give the board 0V and 5V and solder a connection to one or more trigger pins that correspond to the file naming convention. You pull the trigger HIGH (5V) to not trigger the mp3, and pull the trigger pin LOW (0V) when you want to play a song. That should work!
The sound level is very low. Can hardly hear on my laptop.
Great video presentation thank you for your time
Hey, uhh how can i add heat regeneration within the part i'm designing?
What do you mean by “heat regeneration”? Do you want to add a heat source?
My SerialMP3Player doesnt power on.
I have a question… is it possible to activate those “audio pins” via PWM signal?.. if not, will Arduino help make that possible?.. I certainly do not want an individual relay for each pin, but my application is PWM and I would greatly appreciate it if you could give me any info and point me in the right direction?🙏
Hey, great video. I need some help.... am using an MP3 trigger board to play a sound to sync with lights from a prop but there always seems to be a 1.5 sec delay for the MP3 to play when triggered (even using a relay). Do you have any tips as to how to make a sound play instantly as soon as a trigger voltage (high 3.3v) is applied so it syncs perfectly with the prop I am using (which triggers instantly). Delaying the prop is not an option in this case unfortunately. Thanks in advance
I haven’t used this chip in awhile, but I recall that there was very little delay between grounding the pin and the audio playing. Keep in mind that the pins need to be grounded to play (with a common ground to the Arduino), not pulled high to 5V or 3.3V. This may be part of the reason why there is a delay in the sound playing, or there is a blocking delay of some kind in your code. You could test the functionality by manually grounding the trigger pin with a wire by hand to check the triggering and sound delay.
@@ChefJeffPhD thanks for the quick reply. Yes I think you are correct, grounding the pin does work a lot quicker. How could I make the sound trigger this way without having to physically touch the pins or press a switch? I need a digital pulse to ground the pins with no delay to make the sound work
Couple of things: First, make sure your sound file doesn't have empty space at the start of the file. If there's a 1 sec gap of no sound at the start of the file, the device will "play" it, but since there's 1 sec of no sound, you won't hear anything for 1 second. Two, relays aren't instant. If you need to trigger this when something goes high instead of low, use a transistor. I see in your other message that you need a digital pulse. Are you using a microprocessor? If so, you would set the digital output to pull up HIGH, and then trigger it by writing LOW to trigger the sound.
Thanks man, ive been trying too get this to work for my project for so long. You made it easy to follow, enjoyable and yes, got me with the rick roll lol
Anyone know how to make this randomly place a selection?
… I’ll try to answer.. the playback module just holds onto the audio files and has 7 channels or contact points that activate the assigned audio to that given channel number file to play. So having an arduino or raspberry is just another board added to the equation because those boards perform the action for you.. so instead of you manually triggering the playback module to play an audio file just by you closing the circuit with the ground wire, the arduino or raspberry can do that for you. So now what’s missing is the tool or method you want to use to trigger arduino to trigger the playback module at any of the given 7 channels. The arduino and raspberry can be activated by using a voice detection board, a motion detection board, a vibration detection board, a temperature detection board, and even a hand gesture sensing board. These are small and cheap and most other boards that perform tasks will respond to any of these sensor boards I mentioned. However if you’re wanting the music to repeat or play the next song fully automatically., then you need to tell arduino or raspberry exactly what to do and when to do it, which might just be coding jargon. The least complicated way to avoid coding or just the thought process in general would be to have a board, any board, but one that has a “shuffle” feature or random select feature and let it do all the communicating with the playback module for you. Hope that was helpful I’m still learning, I haven’t even touched one of these things yet, I’m still researching for myself so I can apply the technology to my large scale RC cars🙏👌💯
Nice video! FYI TX transmits data and RX receives data so you always have to connect the TX of one device to the RX of the other so you having to flip the pins is totally normal. if TX is connected to TX and RX to RX neither device can transmit or receive data. Device 1 TX goes to Device 2 RX Device 1 RX goes to Device 2 TX for serial communication to function. Thanks again for the video!
I really learnt a lot about using the Arduino IDE from your example. Great stuff!
Thank you. And tell me if the machine is homemade, which post processor to choose?
Great video. Im using a Nano Every board and a YX5300 and I want to play more than one song on the card, without buttons. Just play from "track1" and go through what's on the SD card once it boots up. I'm extreme newbie. Any help would be great!
Can the power source be configured as a battery instead?
Hi Jeff. Thanks for this video - I know you did it a year ago already (it is May 2023 now) but it is still very current. Thanks for taking the time to do this - what I find invaluable is all the problems you come up against and how you fix them - this is all learning for us minions and we learn by your mistakes (LOL). Some bloggers edit all the problems out and leave us with a clean video but you still include them and it is very important. Thanx dude. Well done. Subscribed and Liked tick :¬) 🤓p.s. I can't get my to work properly yet but it is early days. Cheers. PJ.. read on... EDITED----X well there I was trying to get it to work and this little voice came in my head ...."I had to change the TX pin to RX and the RX pin to TX" I swapped the leads... and.... KERCHING!!!! it works. Thanx Matey <phew!> 🔆🔆