Excel - Adding and Graphing Sine Waves with Any Amplitude or Phase

Поділитися
Вставка
  • Опубліковано 12 лис 2024

КОМЕНТАРІ • 15

  • @sorinmarinescu4032
    @sorinmarinescu4032 Рік тому +2

    Great info. especially when you added that degrees had to be changed to radiant. I just love it when people give out the important info at the beginning. Thanks,

    • @E4E
      @E4E  Рік тому

      Thank you so much. I've taught myself and enjoy it when people can get their work done with less stress! All the best. Any ideas for new videos are very welcome. Cheers.

  • @romellojayathilake3419
    @romellojayathilake3419 2 роки тому +2

    Thank you for this great video! This helped me big time!

    • @E4E
      @E4E  2 роки тому

      Thanks a lot for the kind words. I'm really glad it helped! Happy new year :)

  • @scottybuenites
    @scottybuenites Рік тому +2

    Incredibly useful, thank you very much.

    • @E4E
      @E4E  Рік тому

      Thanks so much for this. I'm hankering for more video ideas, if you have any, that's great. Glad it helped!

  • @deldridg
    @deldridg 2 роки тому +2

    Hi James - if it's of any interest or use to you, I've created a simple "Wave Generator" Excel spreadsheet that adds 40 sine waves to the original (40 harmonics) and have set it up with preset parameters to create: sine, square, sawtooth and triangle waves. You choose your shape from a dropdown and enter the number of harmonics you want, from 1 to 40 and it plots them. I'm amazed at how few harmonics are needed to get very decent approximations. You can easily add other shapes to the calculations. Anyway - if you're interested, let me know and I'll email to you. Cheers from Sydney - David
    PS. You give very clear explanations and I look forward to exploring your channel! 🙂

    • @E4E
      @E4E  2 роки тому +1

      Hi David, thanks for the message. That's great to here and I would never turn down an offer to look at good work. At HNC level electronics in the UK, students are required to create such waves. I was always amazed at the pattern within the formulas themselves and how quickly the shapes take.... shape! Please do and please suggest any videos you'd like making. Thanks again, James. See this link too! www.desmos.com/calculator/5sjobevyrt Hope the Sydney weather improves! Cheers
      James.

    • @deldridg
      @deldridg 2 роки тому

      @@E4E Thank you for the kind words and for your lovely comment about my young son Will. He will be thrilled to have such an accolade! He's interested in many things and it's amazing what kids can do when they don't throw their precious time at passive electronic entertainment! We love making things together and you may have noticed he made an Arduino ECG monitor and then we designed and built an RC plane. A real privilege for me. Now he's showing an interest in sound design and electronics. I'll point him to your channel in the holidays, though at 12 it may be a little challenging for him!
      Tomorrow I will tidy up my spreadsheet a little for you. I did a FFT for each of the wave shapes and will put in a bit of documentation before sending. It's nothing terribly special but should be easy for a student to reverse engineer and may have some value.
      Thank you for the great link. Since I was young (in the 70s/80s) I've been fascinated by mathematical graphing (Fractals etc.) and these days enjoy messing around wtih Python as well as Excel. Great to share with the kids too. Lately my attention has been taken by synthesizing sound, so this has led to playing around with waves/FFT etc.
      Take care and many thanks. Regards - David
      PS. Just finished watching England beat Pakistan in the T20 cricket finals here in Australia. Very exciting game!!

    • @deldridg
      @deldridg 2 роки тому

      @@E4E Hi James - I tried to send the spreadsheet to you a few days ago and am checking that it got there. I found your email address on another comment, so fingers crossed! Anyway - thanks again for your hard work putting these excellent tutorials together. Cheers, David

  • @stevemiller235
    @stevemiller235 2 роки тому

    HI James - If I had a data set that already forms a wave pattern how could I add your amplitude and phase shift example so I could manipulate my data?

  • @stevemiller235
    @stevemiller235 2 роки тому +1

    I have a couple questions. Is there I way I could email you to discuss the scope of my project

    • @E4E
      @E4E  2 роки тому

      Hello Steve, I'll help as much as I can! It's electronics4engineers@gmail.com cheers.