Excel_example_FFT_sine_wave

Excel_example_FFT_sine_wave - Sample Excel Spreadsheet -...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sample Excel Spreadsheet - Generating an FFT from a time signal J. M. Cimbala 100 Hz 128 1 volts (or any other units) 1.5 volts (or any other units) 28 Hz 0 radians Calculated values: 1.28 s 0.01 s 0.78 Hz 50 Hz 64 0 (use 10 points per period of the true signal) number of data points for plotting true signal = 358.4 Note: FFT does not automatically update! frequency (Hz) 1 128.921244047066 1.01 (also divide first one by 2) 1 0.01 2.47 0.78 0.921536504595524+2.6195004421504E-002i 0.01 2 0.02 0.45 1.56 0.922416742319615+5.2486672543572E-002i 0.01 3 0.03-0.27 2.34 0.923893423520171+7.89731502267303E-002i 0.01 4 0.04 2.03 3.13 0.925981216247253+0.105755596577703i 0.01 5 0.05 1.88 3.91 0.928701147902541+0.132939815680295i 0.01 6 0.06-0.36 4.69 0.932081123878215+0.160638046533899i 0.01 7 0.07 0.63 5.47 0.936156634411841+0.188970978154193i 0.01 8 0.08 2.5 6.25 0.940971683731069+0.218070070643291i 0.02 9 0.09 0.81 7.03 0.946579988172627+0.248080282621489i 0.02 10 0.1-0.43 7.81 0.953046506477536+0.27916333276519i 0.02 11 0.11 1.72 8.59 0.960449387536545+0.311501661180398i 0.02 12 0.12 2.16 9.38 0.968882450941967+0.345303309299269i 0.02 13 0.13-0.16 10.16 0.978458357353641+0.380808011302353i 0.02 14 0.14 0.28 10.94 0.989312684262129+0.418294895463171i 0.02 15 0.15 2.43 11.72 1.00160920641675+0.458092345050408i 0.02 16 0.16 1.19 12.5 1.01554680165914+0.500590788594014i 0.02 17 0.17-0.5 13.28 1.031368582261+0.546259514921599i 0.02 18 0.18 1.37 14.06 1.04937412159381+0.595669098441651i 0.02 19 0.19 2.36 14.84 1.06993605972299+0.64952177235676i 0.02 20 0.2 0.12 15.63 1.09352302029489+0.70869326721525i 0.02 21 0.21-0.03 16.41 1.12073181324498+0.774291527578504i 0.02 22 0.22 2.27 17.19 1.15233361763623+0.847740847605359i 0.02 23 0.23 1.55 17.97 1.18934176413138+0.930905287021752i 0.02 24 0.24-0.47 18.75 1.23311388526054+1.02627459416434i 0.03 25 0.25 1 19.53 1.28551062498883+1.13725300361843i 0.03 26 0.26 2.47 20.31 1.34915114128981+1.26862409450374i 0.03 27 0.27 0.45 21.09 1.42784204634648+1.42733112657021i 0.03 28 0.28-0.27 21.88 1.52733463813982+1.62385453309011i 0.03 29 0.29 2.03 22.66 1.65674639302718+1.87479769797453i 0.04 30 0.3 1.88 23.44 1.83144292164013+2.20812930472555i 0.04 31 0.31-0.36 24.22 2.07949262777013+2.67492440784464i 0.05 32 0.32 0.63 25 2.45820680974189+3.37945085680802i 0.07 33 0.33 2.5 25.78 3.1056236895742+4.57281849044491i 0.09 34 0.34 0.81 26.56 4.45987522720207+7.05200598637379i 0.13 35 0.35-0.43 27.34 9.04545993453521+15.4090791469905i 0.28 36 0.36 1.72 28.13-43.7257158487798-80.5652746454557i 1.43 37 0.37 2.16 28.91-5.5173034261433-11.0482174996406i 0.19 38 0.38-0.16 29.69-2.68990654766659-5.88881228618564i 0.1 39 0.39 0.28 30.47-1.65400513060386-3.9879258084731i 0.07 40 0.4 2.43 31.25-1.11770058914585-2.99557922605424i 0.05 41 0.41 1.19 32.03-0.790571292341466-2.38347231807819i 0.04 42 0.42-0.5 32.81-0.570785736157486-1.96634766972297i 0.03 43 0.43 1.37 33.59-0.413405836496812-1.66243507227695i 0.03 44 0.44 2.36 34.38-0.29552607737019-1.43003967065237i-0....
View Full Document

Page1 / 22

Excel_example_FFT_sine_wave - Sample Excel Spreadsheet -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online