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

05/03/2011

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…

Read More >>

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

05/02/2011

This section simplifies the formula for the Cartesian coordinates of the terminal point of the reflected ray and derives a very similar formula for a terminal point of the virtual reflected ray. In the next section all these new formulas together with some old formulas will be combined into a new user defined VBA function which will be used alone to trace the incident, the reflected and the virtual reflected…

Read More >>