How Does an Aperture Stop Influence Third Order Lens Aberrations? A Tutorial using Excel

This video tutorial describes the influence that shop-shifting has on the 3rd order Seidel and chromatic optical aberrations of a lens. An Excel spreadsheet is used to conduct soft experiments on these effects.
All of these videos are meant to guide students in PHYS 352 through computational ray tracing.
Introduction to the paraxial ray trace equations • Paraxial Ray Trace Equ...
Chromatic aberration • Chromatic Aberration: ...
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.pencilofrays.com/lens-des...
My favorite book reference for this is Introduction to Lens Design With Practical Zemax Examples by Joseph M. Geary.
OpticStudio is a product of Zemax (www.zemax.com)
Please consider clicking on "Like" so that I know what sort of content is being appreciated. I don't ask for support for developing this content, just the satisfaction of knowing that it is appreciated.
Optical Design Playlist: • Optics and Optical Design
#LensDesign
#YNUspreadsheet
#OpticalDesign
#ChromaticAberration

[@yadongwang8629]

I cannot recommend highly enough of this channel, and this optical design contents. I found its a very good complimentary with the Pencil of Rays and OpticalRealm for geometric optics and lens study.

[@stephenremillard1]

Thank you for the recommendation. I am a mere a novice by comparison to the others.
In addition, I would like to recommend www.youtube.com/@DesignOpticsFast

[@stephenremillard1]

Typo in the slide at 6:29. The stop shifted coma has A (the marginal ray invariant), not Abar (the chief ray invariant) in the denominator. The correct expression is S_II*=(Abar*/A)S_I. The slide in the video shows S_II*=(Abar*/Abar)S_I, which is an error. The spreadsheet calculation is fine. It was just a typo in this PowerPoint slide.

[@yadongwang8629]

Hello Stephen,
Last night I was constructing my excel table and comparing with your sheet. I notice that for both stop (front and back) sheets, the Lagrange Invariants for the lens (front and back) are different slightly. I recall this quantity represents the conservation of (information/energy) in the optical system which should remain unchanged moving through the system. I refer to your Petzval curvature video the single lens has identical Lagrange invariants...
currently, my invariants are the same for with and without stop. My doublet sheet is not ready, so I cannot say my results...The presence of the stop I think should be the factor that causes the gaining/lossing info during the ray propagation? Although, my results are very close to yours compared to the ZEMAX benchmark.
Have a nice day! Waiting for your Astigma and Distortion videos!!