• Please use real names.

    Greetings to all who have registered to OPF and those guests taking a look around. Please use real names. Registrations with fictitious names will not be processed. REAL NAMES ONLY will be processed

    Firstname Lastname

    Register

    We are a courteous and supportive community. No need to hide behind an alia. If you have a genuine need for privacy/secrecy then let me know!
  • Welcome to the new site. Here's a thread about the update where you can post your feedback, ask questions or spot those nasty bugs!

The Fourier transform tool in Excel

Doug Kerr

Well-known member
This is to replace a thread (dating back to March, 2009) that recently had to be destroyed by the OPF bomb squad in connection with a potential security weakness in the forum.

In any event, the URL in the original post was stale, owing to my having had to move The Pumpkin to a new server a few months ago.

The correct current reference is given below.

************

Especially in connection with the concept of modulation transfer function (MTF), we often encounter reference to the Fourier transform. In fact, the modulation transfer function of an optical system (in the form that plots the modulation transfer coefficient against spatial frequency, not the form we usually see in lens specs) is the Fourier transform of the system point spread function.

If we are prepared to deal with the source and result functions expressed as discrete values at repetitive intervals, then it is the discrete Fourier transform (DFT) that is used.

There are many tools that will actually let us determine the DFT of a function. Perhaps the most widely accessible is the Fourier Analysis tool in the spreadsheet application Microsoft Excel.

But if we decide to try a test problem, we quickly encounter the matter of interpretation of the time scales. For example, suppose that our input and output functions descriptions are in terms of values at 16 points. We see that, for our system, the MTF drops to 10% of its "zero frequency" value, a level of interest, at point 7. But what is that in cycles per mm?

In March of 2009 I released a new tutorial article, "The Fourier Transform Tool in Microsoft Excel", which explains how this works. It does so in the context of a brief discussion of the use of the tool itself, and first the article gives an explanation of the Fourier transform and the discrete Fourier transform themselves.

The article is available here:

http://dougkerr.net/Pumpkin/index.htm#Excel_Fourier

Best regards,

Doug
 
Top