Creating a Mileage Matrix

Creating a mileage matrix grid is easy enough if you only have a few addresses. But what if you have dozens of addresses? Enter Python, the GoogleMaps API, and the popular data-science library, Pandas.

What we need to begin with is a dictionary of addresses. For each address, we want …


Exception Reports with Excel

The filter option in Excel spreadsheets provides for an incredibly easy way to find and sort your data. But there are times when it can get a bit clunky, especially if you have a large range of different values, and you or your users are not comfortable with or familiar …


From Hobby to Criminal Evidence

We moved into our first home in May 2017 and by September we were victims of an attempted burglary. We were one of the lucky ones that day; neighbors homes were broken into and items were stolen, including a diamond engagement ring.

It was late September 2017 and I am …


From Hobby to Criminal Evidence

We moved into our first home in May 2017 and by September we were victims of an attempted burglary. We were one of the lucky ones that day; neighbors homes were broken into and items were stolen, including a diamond engagement ring.

It was late September 2017 and I am …