Tag: Excel
-
Analysis to Action: Decision-Making Models
All of us, except for newborns, have to make decisions. When I go to the store, I have to make decisions. As I drive, I have to make decisions. Many of these decisions come naturally; but what if the analysis is more complex? As an engineer, at work, I often have several choices to make…
-
Numerical Solutions to the Logistic Equation: Exploring Population Models in Spreadsheets
Introduction The logistic equation is a fundamental mathematical model used to describe population growth in a constrained environment. It was first proposed by Pierre-François Verhulst in 1838 and is expressed as: Here, P represents the population size at time t, r is the intrinsic growth rate, and K is the carrying capacity of the environment,…
-
Solving a Simple Harmonic Oscillator with Spreadsheets
Introduction In this post, we’ll explore how to solve a simple harmonic oscillator using the Finite Difference Method (FDM) in spreadsheets. The simple harmonic oscillator is a fundamental concept in physics, described by a second-order differential equation that models various oscillatory systems, such as springs, pendulums, and circuits. While such equations can be challenging to…
-
Creating a VBA Function
In the previous post, we saw the example of a macro or a subroutine which calculated the hypotenuse of a right angled triangle. While subroutines and macros are quite useful, in that particular example, it would be more useful to have a custom function built which can be called, as and when required. Most MS…
-
Visual Basic for Applications
One of the coolest Excel features – in addition to the vast repositories of functions that are available in its spreadsheets – is VBA or Visual Basic for Applications. It allows a user to create a procedure – or a macro – to perform more advanced calculations or automate repetitive calculations. Accessing VBA 3. Once…