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

Based on the formulas derived up to this point in the series, this section creates an improved custom VBA function which calculates the x-y Cartesian coordinates of three points: the incident point, the terminal point of the real reflected ray and the terminal point of the virtual reflected ray. The structure of the  function is fairly simple and it is very easy to use too. The model is upgraded using the new function in a new worksheet.


Leave a Reply

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