2004 Crunching FFTs with Microsoft® Excel This application n

The Datasheet Archive - 100 Million Datasheets from 7500 Manufacturers.

2004 Crunching FFTs with Microsoft® Excel This application n

Datasheet Thumbnail

Top Searches for this datasheet

CONVERSION/SAMPLING CIRCUITS BASESTATIONS WIRELESS INFRASTRUCTURE HIGH-SPEED SIGNAL PROCESSING
2004
Crunching FFTs with Microsoft® Excel
This application note demonstrates quickly verify dynamic performance without requiring expensive data-processing software. Although Microsoft Excel limits number data points this application note shows successful Excel processing displaying results typical spectrum.
Introduction
Fast Fourier Transforms (FFTs) powerful tool evaluating dynamic performance analog-to-digital converters (ADCs). Numerous programs available process ("crunch") output code into components. Many these programs custom applications written programmer. While these custom programs handy, source code always available. Other crunching programs MATLAB®. MATLAB very popular industry, however, MATLAB ubiquitous Microsoft Excel 2004 Mathworks charging approximately US$3000 basic MATLAB software along with signal processing toolbox annual licensing agreement. This application note introduces Excel spreadsheet that crunches output code into components. "Crunching_FFTs.xls" spreadsheet been automated using macros ease-of-use. provides formatted single-tone plot from user's data. user simply required enter three variables data record. Using Excel crunch FFTs benefits. Excel records intermediate steps from data plot, which user then explore analyzing equation each spreadsheet cell. simplicity, however, default setting Crunching_FFTs.xls spreadsheet hides intermediate detailed calculations. wish analyze details calculation, simply click "Show_Detailed_Calculations" bubble. major drawback using Microsoft Excel perform Fourier analysis: data record limited 4096 data points1. Another shortcoming Crunching FFTs.xls spreadsheet that requires coherent sampling. Maxim's application note (Coherent Sampling Calculator (CSC)) more information2.
Step-by-step instructions using "Crunching_FFTs.xls"
Starting with cell replace existing data record column with data record. number data points data record must power (128, 256, 512, 1024, 2048.). Enter three required input variables into cells Remember that must adhere coherent sampling. fSAMPLE sampling frequency under test. NRECORD number data points used create your FFTs. This value must power Click macro button titled "Click Here After Changing fSAMPLE." Click macro button titled "Click Here After Changing NRECORD." Click macro button titled "Click Here Crunch FFT3." Enjoy using your Single-Tone Plot.
Theoretical examples
"Example_Data_Records.xls" spreadsheet provided fun, simple practice using Crunching_FFTs.xls spreadsheet. These example data records were created from software model ADC. This software model only accounts quantization error thermal noise, therefore harmonics present FFTs these data records.
MAX1420 example
"Crunching spreadsheet shows data taken from 12-bit MAX1420EVKIT with 60.0489984MHz sampling frequency 2.125758MHz input tone -0.5dBFS. Unlike data discussed "Theoretical examples" section above, MAX1420 shows harmonics device nonlinearities. second harmonic seen 4.0251516MHz third harmonic 6.377274MHz. Figure
Figure 12-Bit MAX1420 created with Crunching_FFTs.xls spreadsheet
MAX12553 example
spreadsheet shows data taken from 14-bit MAX12553 device while mounted MAX12555EVKIT with 65.00352MHz sampling frequency 30.01017MHz input tone -0.6dBFS. Figure Comparing Figure Figure easily that 14-bit device (Figure results lower noise floor than 12-bit device (Figure
Figure 14-Bit MAX12553 created with Crunching_FFTs.xls spreadsheet
Notes
4096 data-point record acceptable verify accuracy ADC. MAXIM, however, typically uses MATLAB software longer data records characterize ADC's dynamic parameters such SNR, SINAD, THD, SFDR. Longer data records produce more consistent results from plot plot. certainly possible additional functionality Crunching FFTs.xls spreadsheet that would allow window sampling. Maxim's Coherent Sampling Window Sampling application note more information. reader succeeds adding window sampling functionality, this author would certainly interested results. macro linked "Click Here Crunch FFT" button requires "Analysis ToolPak VBA" successfully. run-time error '1004' that says 'ATPVBAEN.XLA' could found, must install Analysis ToolPak VBA. This ToolPak free part your Excel software. install TookPak from Microsoft Excel, pull down "Tools" menu select "Add-Ins." From Add-Ins window, check Analysis ToolPak VBA. need your Microsoft Office installation this ToolPak. Once TookPak added, click macro button titled Click Here Crunch FFT.
Microsoft registered trademark Microsoft Corporation United States and/or other countries. MATLAB registered trademark MathWorks, Inc.
More Information MAX1121: QuickView Full (PDF) Data Sheet Free Samples MAX1122: QuickView Full (PDF) Data Sheet Free Samples MAX1123: QuickView Full (PDF) Data Sheet Free Samples MAX1123: QuickView Full (PDF) Data Sheet Free Samples MAX1206: QuickView Full (PDF) Data Sheet Free Samples MAX1207: QuickView Full (PDF) Data Sheet Free Samples MAX1208: QuickView Full (PDF) Data Sheet Free Samples MAX1211: QuickView Full (PDF) Data Sheet Free Samples MAX1213: QuickView Full (PDF) Data Sheet Free Samples MAX12553: QuickView Full (PDF) Data Sheet Free Samples MAX1420: QuickView Full (PDF) Data Sheet Free Samples MAX1421: QuickView Full (PDF) Data Sheet Free Samples MAX1422: QuickView Full (PDF) Data Sheet Free Samples MAX1425: QuickView Full (PDF) Data Sheet Free Samples MAX1426: QuickView Full (PDF) Data Sheet Free Samples MAX1444: QuickView Full (PDF) Data Sheet Free Samples MAX1446: QuickView Full (PDF) Data Sheet Free Samples MAX1448: QuickView Full (PDF) Data Sheet Free Samples MAX1449: QuickView Full (PDF) Data Sheet Free Samples

2004 Crunching FFTs with Microsoft® Excel This application n

Top Searches for this datasheet

Other recent searches