A couple months ago, as my Samsung Galaxy S7 really started to show its age via slowdowns and battery degradation, I started surveying the current smartphone landscape to see what was available. My wife and I both use Galaxy S7 phones, and we each decided it was time to upgrade. I have very specific tastes when it comes to my
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
This is surely not a huge deal for many websites, but from my perspective, this site hit a rather large milestone today. Good ol’ jonamdall.com just had its 10,000th hit! For a small-time hobbyist like me, that seems really huge and quite unlikely to have ever happened. So, as a visitor, I have to thank you – yes you, reader!
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
About three weeks ago, I wrote about my first experience purchasing cryptocurrency, covering the basics about coins, exchanges, and wallets. In short, I purchased 21 different cryptocurrencies of varying base price and circulation, primarily to learn the ins-and-outs. My ulterior motive was to view a few of them as lottery tickets; essentially, buying extremely cheap coins in hope that one
Read more
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
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
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
Well, I’m still trying to figure out how to display quiz or survey results from a Google Document form. In trying to figure this out, I’ve been looking into this WordPress “shortcode.” Apparently, shortcode allows you to pop in some simple code to provide some commonly-sought-after functionality that would otherwise be complicated. Maybe WordPress veterans know all about this, but
Read more
After significant trial and error, I finally nailed displaying survey results on this blog! It’s fairly easy, now that I’ve figured it out. Just publish a page in your Google Spreadsheet (you can create a graph tab rather than publishing the entire thing). After that, copy the embedded link and paste into the blog. It’s that simple! As an added
Read more
I just figured out another fun thing I can do (potentially), so let’s see if it works. I created a very important quiz, housed in a Google Documents form. In theory, I can actually include this quiz in this blog, and the answers will still be stored properly! Well, let’s see if this works. Edit: It worked! Very cool. Now,
Read more