Chromatic Aberration: Calculating the Lateral Color of a Lens

The lateral (transverse) chromatic aberration of a lens with a stop is computed using a spreadsheet and benchmarked against lens design software. The spreadsheet includes some stop shift analysis. A demonstration using Zemax OpticStudio is included.
Please consider clicking on "LIKE". I don't get paid for creating this content, and your positive feedback is the only encouragement that I receive to continue creating this kind of helpful material.
Textbook references are to Joseph M. Geary, Introduction to Lens Design: with Practical Zemax® Examples, (Willmann-Bell. Inc., 2015). The American Astronomical Society has assumed ownership of Willmann-Bell inventory.
Introduction to the paraxial ray trace equations • Paraxial Ray Trace Equ...
Spherical aberration theory • Video
Here is an excellent 5-minute description of chromatic aberration: • What is Chromatic Aber... Pay attention to how chr. ab. is minimized in color film, but not in digital detectors. Fascinating explanation of things.
A very thorough guide for YNU spreadsheeting, and an important resource to help you work through your own spreadsheet, is the "Pencil of Rays" website www.pencilofra...
Optical Design Playlist: • Optics and Optical Design
#ChromaticAberration
#YNUspreadsheet
#OpticalDesign
#LensDesign

[@zedius24]

Wow, I am so glad that I found this channel, thank you for your work!

[@linwang9055]

I couldn't find the expression for CTR in the later part of the video, did i miss any part....?

[@stephenremillard1]

The Excel formula in Cell I22 for CTR is =-F12*F15*(E10+F10-(E18*F10*E10))/I7
The mathematical expression for CTR is found at 3:38.