I made a stereoscopic model in October last year, however, choosing the wrong colors (red and blue on a black background, the effect was very weak (if any). This series was suggested to me last week by one of the guests here on the website, Don L. (thanks Don!), who sent me his stereoscopic cube. I opened the model, put on… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #1: a more efficient composite rotation in the 3D Cartesian space"
This section is dedicated to modeling science in Excel 2003 standard.
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… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 7"
Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 6
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… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 6"
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. [sociallocker][/sociallocker]… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 5"
A Preliminary 2D Ray Tracing Demo for Spherical Mirrors in Excel
This is a demonstrative model for 2D spherical mirror ray tracing in Excel. It works in Excel 2003 at about 40 frames per second and in Excel 2007 at about 4 frames per second. You can start it in a hands-off demo mode by clicking the “Fully Automatic Demo” button and at any time you can hit the the “Demo… Read More... "A Preliminary 2D Ray Tracing Demo for Spherical Mirrors in Excel"
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"
Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 1
This is a first post of an introduction to optics series and it explain how to create a 2D ray tracing model for a spherical mirror. This section deals with the creation and charting of the mirror using a parametric equation for a circle. [sociallocker][/sociallocker] Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 1… Read More... "Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 1"
A Solver for Systems of Linear Equations in Excel
This is a linear system of equations solver in Excel. The size of the system is programmable by the user from 2 to 20 which means, depending on the setting selection, the model can instantly find the solution of linear systems starting from 2 equations and 2 unknowns up to 20 equations and 20 unknowns. It uses the following built-in… Read More... "A Solver for Systems of Linear Equations in Excel"
The Easy Way of Solving Systems of Linear Equations in Excel – using the INVERSE() spreadsheet function
This brief tutorial explains how to calculate the solution vector of a system of linear equations using the Excel spreadsheet function MINVERSE() which calculate the inverse of a matrix. [sociallocker][/sociallocker] Solving linear systems of equations in Excel – the easy way by George Lungu – This is a tutorial showing an easy and convenient method of solving moderate size systems… Read More... "The Easy Way of Solving Systems of Linear Equations in Excel – using the INVERSE() spreadsheet function"
A Legacy 3D Octal Planetary Model
This is an older model of planetary motion in 3D containing eight planets. A video preview can be watched here. [sociallocker][/sociallocker] Read More... "A Legacy 3D Octal Planetary Model"
MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations
This is a brief tutorial showing how to calculate the determinant of a matrix and the inverse of a matrix using two special spreadsheet functions MDETERM() and MINVERSE(). [sociallocker][/sociallocker] MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations by George Lungu – Using Excel built-in matrix operation functions might improve calculation efficiency but it definitely makes model… Read More... "MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations"
TRANSPOSE() & MMULT() – two important Excel spreadsheet functions for matrix manipulations
This is a tutorial introducing two important matrix manipulation spreadsheet functions in Excel: the matrix transposition function TRANSPOSE() and the matrix multiplication function MMULT(). These functions are a bit harder to use than the regular spreadsheet functions in the sense that the result is a matrix and a matrix cell range is treated by the program as a unity (you cannot change the… Read More... "TRANSPOSE() & MMULT() – two important Excel spreadsheet functions for matrix manipulations"