Category Archives: Spreadsheets

One Year Site Anniversary

It’s a little hard to believe, but it’s been a year now since I rebooted Amdall Gallery and really got rolling on this artwork and analysis blog. Actually, it has been 13 months…I’m a little late in writing this post, as the one year mark would have been August 6th. Interestingly enough, my initial brief run with the site in

Read more

Access and VBA Cheat Sheet

As I’ve mentioned many times on this site, I am a huge fan of Microsoft’s data-crunching solutions. I’ve gained a reputation for it too; when I am about to offer a solution to something at work, co-workers usually say something like, “let me guess, it’s a pivot table.” Actually, usually it does involve pivot tables…but when I’m not preaching about

Read more

Milestone Statistics, Unnecessarily Detailed Data

Welcome to part two of three in a series of posts thanking readers, and taking a step back to review Amdall Gallery’s status as we approach a subscriber milestone. In the first, I dropped a poll asking what sort of giveaway subscribers might be interested in, and shared a few cool artists I’ve come across through working on this website.

Read more

My Experience Wearing a Fitness Tracker for a Year

In late February 2017, I started wearing a fitness tracking band. I bought a Fitbit Charge 2 HR, which tracks all sorts of wonderful bits of data such as steps, heart rate, sleep, and probably other stuff. I’ve been wearing it a lot less often lately, but for most of the past year, I wore it almost every day. For

Read more

Airline Fleet Totals, Leg Room Analysis Revisited

Happy New Year, all! I’m going to start 2018 by revisiting something I’ve wanted to take another crack at for a while. Four months ago, I wrote a post about carrier/aircraft seat pitch data, inspired by an article about American Airlines ordering new planes with diminished leg room. I found a site called seatguru.com that shares seat pitch (measurement from

Read more

Excel Function Cheat Sheet

As a huge Excel fanatic, over the years I’ve amassed a nice collection of spreadsheets; if you’ve explored this website much, I’m sure you’ve seen graphs from some of them. As part of that data crunching, I’ve also utilized a wide variety of functions and formulas to process data. I keep a master reference list of these Excel functions in

Read more