So, you want to run a linear regression in Excel. Maybe you need to do some forecasting, maybe you want to tease out a relationship between two (or more) variables. Maybe you have to explain some phenomenon and predict it, but you don’t have a clue how it works or…
This is my take on the Toads and Frogs logic puzzle. Instead of Frogs and Toads however, I will be using one of my favorite animals, the mighty ostrich. “Three pink ostriches are heading south to get home and run into three blue ostriches on a very narrow path in the savanna. The three blue ostriches…
This time we’re looking at something called the Josephus problem. As far as I can tell this is based off of an actual event in history or is at least attributed to a historical figure, Titus Flavius Josephus. Here is the basic set up: Josephus and 40 other of his fellow Jewish…
Posted by Rik Leja | Wednesday, 11 July, 2018 | No Comments For this project I decided to create an interactive world map in Excel treating each cell as a pixel and carving out the natural and political borders of territories, countries, and islands using colors and cell borders to differentiate the areas. My finished map…
I decided to make something a little more practical this time and I also wanted to showcase some VBA required to animate images on the spreadsheet, so I decided to create an animated travel checklist. The VBA used here can have any number of applications for any Excel projects in…
日本語の場合は、上隅にある旗をクリックして「日本語」を選択します。 Part two of this Plant growing blog will focus on adding flowers to the stems that we learned how to grow in part 1. There are a few sections, the first focuses on colors, the second deals with how and where the flowers will actually be growing. Then we look at the…
日本語の場合は、上隅にある旗をクリックして「日本語」を選択します Think of this as something like a gardening simulator in Excel. Using random numbers we will grow a plant from a flower pot on a sheet. This will cover a variety of Excel topics including the proper VBA syntax for: RGB colors, cell borders, color gradients, random number generators, and there…
Everything in this blog post will be about those uniquely fascinating numbers known as prime numbers. I will be explaining how to build something known as the Sieve of Eratosthenes, which I will explain in detail later. The sieve will be able to spit out all the prime numbers between 2…
In this post we are going to build a maze solver in Excel using VBA, to do this we will simulate a little person walking through a maze, they will be practicing the “right-hand rule,” that is, you can successfully escape any maze by placing your right hand (or left…
This will be the third and final blog post regarding the Monty Hall problem. The aim of the build this time is to make something that is both highly functional and stunningly beautiful. Since all we are concerned with this time is raw data it would be nice to have…
