This brief section takes the two previously created custom VBA functions (Reflect() and Chart_Reflect()) and use them to create the data for both the incident and the reflected bundles of rays within the same table. The data is then plotted on the same chart with the mirror and the result is a preliminary model which you can experiment with. [sociallocker][/sociallocker]… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 5"

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

This section begins by charting the incident rays on the same 2D acatter chart with the mirror and then explains how to derive the Cartesian coordinates for a “final” point which together with the point of incidence will define the reflected ray. A custom VBA function is created for this purpose. [sociallocker][/sociallocker] Introduction to Geometrical Optics – a 2D ray… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 4"

## 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 basic… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 3"

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

This section explains the illumination setup by using an artificial star, derives the equations of the incident rays and also solves the system of equations for finding the exact coordinates of the points where the incident rays hit the mirror. Looking at the sign of the determinant of a quadratic equation involved in finding the intersection between an incoming ray… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 2"