Tech

Updating IP Address In OpenDNS With Raspberry Pi

Like many people I use OpenDNS instead of my internet provider’s DNS. In addition to the speed gains I get (because it’s faster than my provider’s DNS) I like to look at the reports OpenDNS provides. In order for the reports to work OpenDNS needs my IP address. But my IP address is dynamic so […]


Raspberry Pi Print Server With AirPrint (iOS) Compatibility

I was looking for a low cost way for my family to print from their iPhones, iPods and iPads when I realized that this would be a good job for my Raspberry Pi. The web is littered with instructions for this project. I mostly followed Lynsay Shepherd’s tutorial but not exactly. The steps I followed […]


Setting Up A Raspberry Pi

Lately I’ve been doing some projects with the Raspberry Pi. The Raspberry Pi is a small computer on a single circuit board using an SD card as it’s hard drive. I decided to share some of the things I’ve done with mine starting in this post with how I set up the operating system. Note […]


List Differences in Two Cell Ranges in Google Spreadsheet

Another tip from my recent work in Google Spreadsheets. I had two columns of data and was looking for a way to display items that appeared in one column that didn’t appear in the other. The combination of the FILTER and MATCH functions is how I accomplished this. The FILTER function returns items from a […]


Access Data From Another Spreadsheet in Google Spreadsheets

I’ve been working with Google Spreadsheets a bit lately and have learned a few tricks. One such trick was learned when I had to find a way to have data in one spreadsheet automatically update based on data that’s in another spreadsheet. This turned out to be quite easy once figured out. Here’s how to […]