Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 3

This section explains explains how to implement the formulas that define the emergent (reflected) rays into a custom VBA function. Though geometrically the last two presentation might look a little  elaborate, just be patient and follow the presentation, or even better try to just sneak peek and do it yourself. All this derivation is done based on first principles and some Mickey Mouse geometry. Take all the time you need, a day, a week or a month, it is worth it and you will be rewarded. With minor upgrades, this function can later be used to model complex cascaded optical systems.


Leave a Reply

Your email address will not be published. Required fields are marked *