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 >>

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

05/01/2011

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 3

04/28/2011

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…

Read More >>

2D Projectile Motion Tutorial #6

02/19/2011

This tutorial simplifies the previous model and manages to describe the (x,y) flight coordinates using just two formulas placed on columns D and E. A custom VBA trajectory function will be introduced in the next section which preserves the effects of gravity and aerodynamic drag. [sociallocker][/sociallocker]

Read More >>