Category Archives: Spreadsheets

Blog Post Length and Total Views Comparison

There was a point in time, just a few years ago, when I typically referred to Amdall Gallery as both an art and data analysis blog. In fact, I still even have it in the sub-title at the top of the site. I’ve been consistently writing posts every month since August 2017 (almost five years running now), and at the

Read more

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