Say you have a message filled with static, and you suspect there’s something off about it. The pixels appear to be random, but not quite. How, how, how might you determine if the image is indeed entirely randomized?
JSON: How to Read Your Google Location Data
A few days ago, I was actively avoiding my life plans (and scrolling through WordPress) when I stumbled upon a GIF from Vincze Istvan showing where Google had plotted his locations over the last few years.
And my brain exploded. I mean, I knew in the back of my mind that anytime I checked my email or looked for directions or asked Lyft for a ride, my information at that particular time and place was probably being stored somewhere. That storage place had always felt far too abstract to make me paranoid.
Until I saw it projected in a GIF in a supremely tangible way.
Continue reading “JSON: How to Read Your Google Location Data”
VBA: How to Use VLookUp in a Macro
Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.
VBA: How to Exclude Numbers from a List
Alright, I ran short of time this week, so I don’t have a tutorial. But I DO have another fun UDF (User-Defined Function)–this one takes two parameters. Both need to be strings made of comma separated numbers. The function excludes the second set of numbers from the output.
VBA: How to Get A List From a Range of Numbers
A couple months ago, I did the exact opposite of this. I called it the ListToRange() Function. It’s weirdly helpful at work because I have to go back and forth between having numbers listed out and then having them clustered for other things.
Continue reading “VBA: How to Get A List From a Range of Numbers”
gifGuide2Code 