FFT_Hanning_window_w - Sample Excel Spreadsheet Generating an FFT with a Hanning Window(for a sine wave function with a DC offset J M Cimbala 90 Hz

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 with a Hanning Window (for a sine wave function with a DC offset) J. M. Cimbala 90 Hz 128 2 1 volts (or any other units) 20 Hz 0 radians Calculated values: DC = mean value of input signal = 2.01 volts (or any other units) (average of all the useful input data) 1.42 s 0.01 s 0.7 Hz 45 Hz 64 0 (use 20 points per period of the true signal) number of data points for plotting true signal = 568.89 Note: FFT does not automatically update! (also divide first one by 2) (also divide first one by 2, and add back the DC value) frequency (Hz) 2 256.984807753012 2.01-0.01-0.493247503592427 2.01 1 0.01 2.98 0.7 0.986495007184767-1.0169 0.02 0.98 0.245351916179819+1.61957072 0.01 2 0.02 2.34 1.41 0.991582349650347-2.0403 0.02 0.33-8.69447197757361E-004+3.2793 3 0.03 1.13 2.11 1.00014748090696-3.07682 0.02-0.87 0.01-9.02639910711162E-004+5.0215 4 0.04 1.36 2.81 1.01232317180642-4.13342 0.02-0.65 0.01-0.01-9.5088777783647E-004+6.89304 5 0.06 2.64 3.52 1.02830241381723-5.21759 0.02 0.64 0.01 0.01-1.01612334787129E-003+8.9477 6 0.07 2.87 4.22 1.04834614921952-6.33755 0.02 0.86 0.02 0.02-1.10107253521986E-003+1.1250 7 0.08 1.66 4.92 1.07279417476269-7.50252 0.02-0.35 0.03-0.01-1.2094753832663E-003+1.38801 8 0.09 1.02 5.63 1.10208010183891-8.72300 0.02-0.99 0.04-0.04-1.34640908953294E-003+1.6938 9 0.1 2 6.33 1.13675166527328-0.10011 0.02-0.01 0.05-1.51876037252756E-003+2.0557 10 0.11 2.98 7.03 1.17749827019776-0.11381 0.02 0.98 0.06 0.06-1.73592199937049E-003+2.4909 11 0.12 2.34 7.73 1.22518856311972-0.12851 0.02 0.33 0.07 0.02-2.01083438060306E-003+3.0230 12 0.13 1.13 8.44 1.28092219356409-0.14442 0.02-0.87 0.08-0.07-2.36157187701454E-003+3.6845 13 0.14 1.36 9.14 1.34610211151652-0.16181 0.02-0.65 0.1-0.06-2.81381204195879E-003+4.5212 14 0.16 2.64 9.84 1.42253727763679-0.18100 0.02 0.64 0.11 0.07-3.40477788435778E-003+5.5992 15 0.17 2.87 10.55 1.51259155529449-0.20243 0.02 0.86 0.13 0.11-4.18971764915908E-003+7.0162 16 0.18 1.66 11.25 1.61940470354883-0.22667 0.03-0.35 0.15-0.05-5.25291695018775E-003+8.9213 17 0.19 1.02 11.95 1.74722951960392-0.25448 0.03-0.99 0.16-0.16-6.72714819962954E-003+1.1548 18 0.2 2 12.66 1.90196292845754-0.28691 0.03-0.01 0.18-8.82959706415118E-003+1.5282 19 0.21 2.98 13.36 2.09201472556776-0.32545 0.03 0.98 0.2 0.2-1.19318265347693E-002+2.0776 20 0.22 2.34 14.06 2.32979382881706-0.37230 0.04 0.33 0.22 0.07-1.6704928139515E-002+2.92150 21 0.23 1.13 14.77 2.63439264462442-0.43083 0.04-0.87 0.24-0.21-2.44448626584585E-002+4.2883 22 0.24 1.36 15.47 3.03677091106562-0.50652 0.05-0.65 0.26-0.17-3.78758542460439E-002+6.6586 23 0.26 2.64 16.17 3.590652594491-0.6088501 0.06 0.64 0.29 0.18-6.3399895757191E-002+1.11610 24 0.27 2.87 16.88 4.39813386094516-0.75581 0.07 0.86 0.31 0.26-0.118570913523678+2.08909552 25 0.28 1.66 17.58 5.67989878149403-0.98635 0.09-0.35 0.33-0.12-0.264029837306617+4.65409677 0.01 26 0.29 1.02 18.28 8.01778305126938-1.40304 0.13-0.99 0.35-0.35-0.812310830159638+0.14321930 0.02 27 0.30....
View Full Document

This note was uploaded on 07/23/2008 for the course ME 345 taught by Professor Staff during the Spring '08 term at Pennsylvania State University, University Park.

Page1 / 23

FFT_Hanning_window_w - Sample Excel Spreadsheet Generating an FFT with a Hanning Window(for a sine wave function with a DC offset J M Cimbala 90 Hz

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