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…