This is a demo of a recent client project. Based on my Google Distance Calculator example (go here to view and download). Below is a video demo and downloadable example of the project. Technologies Used: Excel VBA, Google Maps Distance Matrix API, Google Maps Static Map API. My client needed a list of addresses to […]
I’m going to provide a sample text file and a sample Excel VBA macro file for you to test. You can find the download below. Structured Data is Nice but Not Always Possible It would nice if every system had the ability to export data in more structured formats, like XML or json, rather than […]
I’ve read a few articles on this – specifically people asking how to check if an optional parameters has been passed to a C# method/function/class. I saw several responses where people suggested you don’t have to check – just set your default values or use overloading. The problem with both solutions is that they fail […]
Excel File download with VBA and Google Maps to calculate distance and duration between multiple destination addresses. Updated 5/23/2019: Fixed error where re-encoded origin string resulted in incorrect distances after 10 destination addresses. I’ve been asked to update this and address a few things in the code for a couple years. Back on October of […]
Last week, Matthew Moran, gave a workshop as part of The Russell Fisher Business Collection at the Camarillo Library. The RF Business Collection is a grant that provides the library funds for hosting business workshops and informational seminars. Georg Winkler administers and books speakers for the event. He has also started getting them on video […]
We just published the initial version (beta: ver. 0.5) of an MPAA Content Security Audit Review Tool built in Microsoft Excel. The Motion Picture Association of America (MPAA) has a Content Security Best Practices Common Guidelines document that our client needed us to follow to help them pass a digital security audit review. The audit […]
This came up for a client recently, so we decided it was worth covering here on the blog. Also, it was supposed to be our first Tech Tuesday content but we had to get to a client early to ensure they passed a network security audit that was tied to a substantial amount of new business. […]
AKA: How to build better technology solutions for your organization. Part 1 | Part 2 | Part 3 RECAP & INTRODUCTION In part 1 I covered origins and impact. In part 2, I wrote about objectives, what to expect, and described the dangers of process-driven thinking. In part 3, we’re going to explain how to move […]
AKA: How to build better technology solutions for your organization. Part 1 | Part 2 | Part 3 RECAP & INTRODUCTION In my last article I discussed the origins, impact, and initial premise for Concept Over Process. Today, I want to cover what to expect as you learn more about COP, the objectives of COP, and […]