This is an animation of an asynchronous electric motor in Microsoft Excel. You can download the model by clicking on the icon below and trying to run it. What is an electric motor and how does an electric motor work? An electric motor is part of a larger class of devices known as electric machines. In order to define an… Read More... "Animated Asynchronous Electric Motor Model in MS Excel"
A Legacy Animated Planetary Model – video preview
A preview of a legacy planetary model. [sociallocker][/sociallocker] Read More... "A Legacy Animated Planetary Model – video preview"
Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL
This section updates an angle formula so that the virtual glider can now perform both backward and forward loops, as well as inverted flight. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #11- 360 full coverage – loops by George Lungu – This section fixes an angle issue so that the virtual aircraft will now be able to perform both backward and forward loops. Upgrading… Read More... "Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL"
Longitudinal Aircraft Dynamics #10 – implementing the numerical method
This section of the turorial finalizes the main dynamics calculations and implements the numerical method for approximating the glider trajectory. At this point, the model is already functional but with a crude interface. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #10- the numerical method by George Lungu – This section deals worksheet implementation of the numerical setup for a dynamic modeling of the flight. The… Read More... "Longitudinal Aircraft Dynamics #10 – implementing the numerical method"
Longitudinal Aircraft Dynamics #9 – more about forces and momenta – preliminary validation and testing
This tutorial finalizes the implementation of the forces and momenta acting on the plane. It also initiates some hand testing and validation of the overall dynamics of the plane. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #9- finalizing the dynamics – preliminary validation by George Lungu – This section continues with the dynamics formulas governing our 2D plane. Worksheet lever calculation formulas: – Copy… Read More... "Longitudinal Aircraft Dynamics #9 – more about forces and momenta – preliminary validation and testing"
Longitudinal Aircraft Dynamics #8 – worksheet implementation of the dynamics equations (c)
This section continues the worksheet implementation of the dynamics formulas for aerodynamic forces and momenta. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #8- worksheet implementation of the real dynamics by George Lungu – This section continues with the dynamics formulas governing our 2D plane. Worksheet implementation of the force calculation formulas: – We will calculate these forces in a new area of the worksheet.… Read More... "Longitudinal Aircraft Dynamics #8 – worksheet implementation of the dynamics equations (c)"
Longitudinal Aircraft Dynamics #7 – worksheet implementation of the dynamics equations (b)
This section continues the worksheet implementation of the dynamics formulas. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #7- worksheet implementation of the real dynamics by George Lungu – This section continues with the dynamics formulas governing our 2D plane and their worksheet implementation. Some Reynolds number corrections: – We introduced one single named cell for the Reynolds number (Re) when in fact there… Read More... "Longitudinal Aircraft Dynamics #7 – worksheet implementation of the dynamics equations (b)"
Longitudinal Aircraft Dynamics #6 – worksheet implementation of the dynamics equations (a)
In this section, the parameters cl, cd and cm are scaled back to the force of lift, drag and the pitching moment of the aircraft. After that, the numerical modeling scheme is described together with the macros behind it. At the end, the formulas for the angles of attack of the wing and the horizontal stabilizer are introduced. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #6- worksheet… Read More... "Longitudinal Aircraft Dynamics #6 – worksheet implementation of the dynamics equations (a)"
Animated Heat Transfer Modeling for the Average Joe – part #3
This section shows how to model heat transfer in a linear bar by dividing it in elementary sections in which the basic linear equations introduced in the previous tutorials can be used. Animated heat transfer modeling for the average Joe – part #3 by George Lungu – This is a new section of the beginner series of tutorials in heat… Read More... "Animated Heat Transfer Modeling for the Average Joe – part #3"
How to Model a Phase-Locked Loop (PLL) in Excel – part#1
A Phase-Locked Loop is a type of electronic circuit. It generates an oscillation with the same frequency as a reference oscillation and a relatively constant phase difference with respect to the same reference. The applications spectrum of such a circuit are extremely wide. Signal modulation, demodulation, detection and filtering, frequency conversion and synthesis are just a fraction of what this circuit can do.… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#1"
2D Projectile Motion Tutorial #5
This is the next in a series of projectile motion tutorials for creating 2D trajectory models using numerical analysis of projectile dynamics (including aerodynamic drag). The trajectory formulas were derived in the previous tutorial. This post describes the Excel implementation (spreadsheet formulas, VBA code, buttons and charts). [sociallocker][/sociallocker] Projectile Motion Tutorial #5 – a 2D projectile motion model using numerical analysis of projectile dynamics (including aerodynamic drag)… Read More... "2D Projectile Motion Tutorial #5"
2D Projectile Motion Tutorial #4
This tutorial derives the formulas of a projectile model taking into account the aerodynamic drag. A finite differences numerical method is used. Though fairly easy to apply and understand, this type of methods can solve much more complex problems than the high-school type approach shown in the previous tutorials. An Excel model will be implemented in the next section. Projectile Motion… Read More... "2D Projectile Motion Tutorial #4"
2D Projectile Motion Tutorial #3
Now that we have a simple animated projectile motion (previous tutorial) let’s try to add on the chart the three instantaneous speed vectors associated with the projectile. These speed vectors are: the horizontal speed, vertical speed and the total speed vector. The model works in all Excel versions but in 2007 it’s rather slow. [sociallocker][/sociallocker] Projectile Motion Tutorial #3 –… Read More... "2D Projectile Motion Tutorial #3"
2D Projectile Motion Tutorial #2
This part of the tutorial shows you how to animate the model created in the first part. Since it is addressed to beginners, this part of the tutorial will show you in detail how to create buttons and the associated macros for the input data interface and it will also show you how to animate the flight of the projectile and explain… Read More... "2D Projectile Motion Tutorial #2"