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
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
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
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
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
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
A few weeks ago, I was thinking about my two Twitter accounts; one personal and one for this site. I was wondering if there was a tool that would allow me to export or web-scrape my Twitter history into .xls or .csv, so I could crank out some pivot tables. There may be multiple ways to do this, but I
Read more
My family and I recently went to dinner with some friends, and the topic of Excel came up (I know how to party right?). A couple of people mentioned they wish they knew more about Excel; this got me pumped up! Since we don’t live in the same city, in lieu of actually helping them in person, I’m going to
Read more
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