The big news of the day was the solar eclipse that was visible in a line across the U.S. Unfortunately, I was well south of the areas of 100% “totality” (total coverage of the sun by the moon). According to a map published by NASA, I was in the 75% totality band: What that meant from the practical side of
Read more
I’ve posted quite a bit regarding my love for Excel and Pivot Tables, but I haven’t actually mentioned my other source for data-crunching fun – Microsoft Access. Occasionally, I’ll come across some data structure or method of viewing that can’t be accomplished using Excel (or can’t be accomplished well). That’s when I’ll jump into database design. One example of this
Read more
Ages ago in the early 2000s, I got an itch to learn about web design, so I tried to teach myself how to create a website using html. I was able to whip up an amazingly terrible site called jonsource.com. I coded the thing in Notepad, paid some company to host it, and was wildly successful with maybe 100 hits!
Read more
I mentioned in a previous article on this topic that I also wanted to explore the state-by-state numbers, but needed to finish processing data from Census.gov. Well, that is now done, so I’m going to explore what I found. I think this will be my last post on mass shooting data analysis, unless something new surfaces. Previous articles: Part 1,
Read moreAlright, I admit that this is probably embarrassing and sad…I have difficulty making good fashionable choices. Especially when we start talking about branching out to different colors, matching clothes, and all that. Honestly, if I could get away with it, I’d just wear khaki shorts and a black t-shirt every day at home, and gray slacks with a light blue
Read moreI was going through some of my older spreadsheets and data sets, and came across some materials I put together based on a CNN online article. Unfortunately, this is from way back in the ancient times (2012), so I’m not sure it’s still as interesting. On the other hand, we were in the age of large federal budgets then, and
Read more
Prior to this week, I honestly didn’t know too much about cryptocurrency. I knew the basics, mostly hearing or reading about Bitcoin. I knew there were other types, but had no clue how many. I’ve even got a “if only I would have” story about it; I considered buying some for fun around 2010-2011, but didn’t care enough about it
Read more
Updated research on this topic can be found here: Airline Fleet Totals, Leg Room Analysis Revisited. This more recent article integrates fleet totals for a more complete view of seat pitch distribution across airlines. Research on the topic of airline and airplane seat size comparisons was triggered by an article I read recently. Unfortunately, I can’t remember where the article
Read more
In the previous post, I explored Mother Jones’ data on mass shooting events in the U.S. What they collected was impressive in depth, but only seems to cover a small subset of violence that falls under the “mass shooting” definition (four or more shot and/or killed in a single event [incident], at the same general time and location, not including
Read more
This is part one of a four post series. The most recent post includes an after-Vegas data update, summary of all graphs, and possible solutions to the issue. I get made fun of quite a bit for this, but one of my favorite things is crunching data using Pivot Tables and Charts in Excel. Doesn’t that sound fun? Sadly, I
Read more
Since I recently found out that Google Forms had a large update, I went back to my old Survey on this site to see if everything still worked. For the most part, it did! I was also hoping for some improvements to the Results html/embed process, but unfortunately it’s still pretty similar to the old method. While you can directly
Read moreIs it possible to add a widget or something that shows my Google Local Guide information? Well, let’s give it a shot! I want it to look like this: But instead, it seems to look like this…not quite what I had in mind. Jon • Level 6 4,672 points Learn more about points <!– Place this tag where you want
Read more