This section is dedicated to modeling science in Excel 2003 standard.
This is a continuation of the first part of the beginner series of tutorials in heat transfer modeling. The first part introduced the reader to the concept of heat capacity (being analogous to the electrical capacity). This section continues with the concept of heat conductance which is analogous to the electrical conductance. Ohm’s law applies. Toward the end, the principle… Read More... "Animated Heat Transfer Modeling for the Average Joe – part #2"
This the first tutorial on modeling heat transfer at a very introductory level. If you follow this series and spend your own effort in developing your own models you will be able to model heat transfer in very complex shapes (1D, 2D, 3D) in a short time and with the basic understanding of a 12 year old school boy. Animated heat transfer modeling… Read More... "Animated Heat Transfer Modeling for the Average Joe – part #1"
Hi guys, Here is a 1D dynamic model I built today simulating heat transfer in a 21-segment bar. Just click on the orange “Demo” button for a quick demo. Hitting “Reset” sets the 21 segments of the bar to the initial conditions which is a fully customizable initial temperature map. Clicking “Start/Pause” starts the simulation and you can watch the bar temperature profile… Read More... "A One-Dimensional Dynamic Heat Transfer Model – a diffusion model"
This last section of introductory PLL modeling shows how to upgrade the model with adjustable scale charts for three voltage signals within the loop. The model also shows how to create a Lissajous based phase display. [sociallocker][/sociallocker] How to Model a Phase-Locked Loop (PLL) in Excel – part #4 -This is the continuation of part #2 of the PLL tutorial. The previous… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#4"
This is a continuation of the PLL series of tutorials and it takes the recursive numerical formulas derived in the previous section, implementing a dynamic spreadsheet model with help from a copy-paste loop type of macro. This macro emulates the behavior of the phase locked loop model in time. At this point, the model is functional. Charting options for the waveforms… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#3"
Both frequency and phase modulation are important not only in electronics but also in science and physics in general. It seems like a trivial chore but when I first tried to model such a signal some time back I hit a hard wall. Our minds easily understand kinematics concepts such as coordinate, speed, acceleration and the relations between them in… Read More... "How to Model a Frequency Modulated (FM) Signal – an insight"
This is a continuation of the PLL series of tutorials and it starts by implementing and testing the low pass filter created in the previous section. After that, the block diagram is updated and the presentation begins to show how to build the PLL model in a worksheet using the existing LPF formulas. [sociallocker][/sociallocker] How to Model a Phase-Locked Loop (PLL) in… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#2"
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"
In this tutorial, most of the calculations for the numerical simulation a SMD (spring-mas-damper) system will be consolidated into a single formula, the coordinate formula. In this case, in order to calculate the coordinate at the end of a any time step, we will need just the coordinates from the previous two time steps and of course the input parameters (constants). These… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5"
This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations. [sociallocker][/sociallocker] A casual approach to numerical modeling – part #4 – a Spring-Mass-Damper-System – creating the animation by George Lungu – We are trying to generate animation for the system sketched above knowing the deviation from the equilibrium function of time. This deviation is… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4"
In the this tutorial, after we got most of the trajectory calculation concentrated in just two columns, we will write a custom VBA function (dual output) to replace the spreadsheet computations used. This process of starting with very simple models, then refining the calculations and then learning how to write custom functions for those calculations will be extremely useful later for developing more complex models. [sociallocker][/sociallocker]… Read More... "2D Projectile Motion Tutorial #7"
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] Projectile Motion Tutorial #5 by George Lungu – a 2D projectile motion model of projectile dynamics including… Read More... "2D Projectile Motion Tutorial #6"
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"
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"