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

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.


This article has 2 Comments

  1. Thanks, Peter for the feedback. Animation is just a lure and the purpose it to give lazy users a chance to see what the model can do. In 2003 my speed is about 40 fps on a mediocre computer. The lens model you sent me looks very nice. Try to work the internals of the lens too. I will probably settle to just plain lens contours for now.

  2. George

    I have worked up a refraction model, based upon a minimum time calculation (to help move clear of your current territory of reflection).

    I am not convinced animation does it any favours at all though, much too slow. It might be better to provide some interactivity allowing the user to slide optical elements along the bench and then ‘switch on the lamp’ once the ‘experiment’ is set up.

    My initial image of the lens is strictly Office 2007 or later, using 3d formats. Since then I have produced a good looking image by using 2d shapes more suited to Office 97-2003. I have yet to try adjusting lens thickness to reflect its radius of curvature.

    A concave lens would require a different drawing and the diverging rays would need to be extrapolated back to the virtual image.

Leave a Reply

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