With American election season in full swing, at least as I write this (February 1st, 2024), I thought it might be appropriate to write about Benford’s law, how it has been used in the past to analyze numbers, why it has been used to search for election fraud, and, importantly, when it is inappropriate to
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 looks like this: A few
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 the future, particularly using images