Tech Talk
How I “AI” for Consulting Projects
I now use AI constantly for client projects. I'm sharing this detailed "how-to" as an inspiration for fellow modelers. It's easy to feel a sense of "AI hopelessness" relative to those out there who have hit the seventh level. I follow Boris Cherny on Twitter as a classic example. Yes. The Claude…
Setting up “Courteous” (and Efficient and Accurate) Data Entry
This Tech Talk blog shares how to create custom, Conditional Formatting in a Microsoft Excel template to make manual data entry efficient and accurate. See the background blog on the user interface design motivation for this, and let us know if we can help you with your data situation! Excel and…
Well-Behaved Color Data Calculations
Color tolerancing is critical for quality control on colored products and for applications like assessing efficacy of cleaning products. We use a standard Excel data entry template (subject of an upcoming post) that can calculate the CMC Delta-E statistic to quantify the color difference between…
Google Colab Tutorial For Running Python Notebooks
This provides a short tutorial for Google Colab as an alternative to Jupyter for running Python code. We show how to bring in, modify and run a Jupyter Notebook from a Github repository. Colab (short for "Colaboratory") is a Google cloud service. It allows users to write and execute Python code in…
Good, Better, Best For Python Projects
I blogged about my observation that Python-coded models and analyses can be grouped into three robustness levels by architecture and macroscopic coding arrangement. Here is a more detailed discussion of the three levels taught also at this training link to a Practical Python for Modelers short…
When The Data Get Big(ger) Part2
It is crucial to move beyond using *.CSV files when the scope of a project goes beyond 1MM rows of data. This is an add-on to my initial post about using Pyarrow Feather in Python for efficient data storage. The first post makes a good case for this, but it leaves out some nitty gritty details…
When the Data Get Big(ger)
This blog describes how we manage life when the data get too big for Excel-compatible formats such as CSV. Practically, when working with exploratory data analysis, there is no rush to jump to fancy data formats on the client-facing side of things. Even when people hire a consultant to help with…