Excel_example_FFT_sine_wave

# Excel_example_FFT_sine_wave - Sample Excel Spreadsheet...

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

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

View Full Document
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