Category Archives: Tech

Excel Function Cheat Sheet – Jon’s Personal Reference Page

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

Database Fun – Art Collection

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

Google Local Guide Widget

Is 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

Shortcode Test

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

Quiz time!

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