Airtable Reporting Dashboard using Google Apps Script, Google Big Query and Google Data Studio

Airtable Report Dashboard Using Google Apps, Google Big Query, and Google Data Studio OVERVIEW: This blog covers the technologies I used to create a client’s Airtable Reporting Dashboard using Google Sheets/Google Apps Scripts, Big Query, and Google Data Studio. It contains links to the javascript and sql I used plus a video that demonstrates the […]

Continue reading

Airtable Database Systems: The Good, The Bad, and the Ugly (really ugly)

I’ve begun consulting organizations on using Airtable for tracking company information. Airtable provides an amazing platform for moving away from Spreadsheets (Excel or Google sheets) as a way of tracking company workflow and data. It is a rudimentary relational database system that looks and feels like a spreadsheet. As a stop-gap, proof-of-concept, or even the […]

Continue reading

Updated: Microsoft Excel VBA and Google Maps to calculate distances and time from multiple locations

Excel File download with VBA and Google Maps to calculate distance and duration between multiple destination addresses. Update 12/17/2019: Important! You must have a Google Matrix API Key and IT MUST BE CONNECTED TO AN API BILLING ACCOUNT! If your billing account is not active or connected to the API account, the tool WILL NOT […]

Continue reading

Google Apps Workshop Slides and Video

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 […]

Continue reading

Microsoft Access and Word VBA Document Assembly System Demo

Summary: This demonstrates a methodology and some of the associated technologies I’ve used to create complex and flexible contract generators, proposal generators, and other document assembly systems. Technologies: Microsoft Access (SQL Server*) Microsoft Word – Word Templates – Word Global Template w/AutoText Entries * SQL Server: For simplicity, this demonstration uses Microsoft Access as the […]

Continue reading

Moving From Excel to MS Access & SQL Server for Cleaning Up, Extracting, & Reporting on Data

Summary In our own work with data analytics, in coaching financial & business analysts, and with data conversions, we often coach clients to learn and use Microsoft Access or SQL Server, rather than (or perhaps more accurately, in conjunction with) Microsoft Excel. In this article, we explore some of the reasons why. “I suppose it […]

Continue reading

VBA to Extract All Excel Formulas in a Workbook

Summary Some visual-basic for applications code to extract all the formulas from every sheet in an Excel Workbook and save them in a text file. Background Avoiding a long explanation, we’ve been writing a reporting tool that combines a Microsoft Access front-end to a SQL Server database. It generates and updates some Excel reports/data visualizations […]

Continue reading