| Monthly Tech-Tip | No tracking! No ads! |
This batch-to-formula calculation was done by Albert E. Holthaus at Modern Art Products Company in Kansas City, MO (pre-1970). Handwriting something like this seems quaint today, but perhaps even more so is the fact that he actually did it!
Notice that he took the manufacturer-supplied percentage analysis for each material (bottom) and calculated the unity formula for use in his batch to formula calculation (top). The recipe material weight amounts are missing in the latter; this appears to be his effort to create a documentation page of the recipe on the oxide formula level (this is what mattered to him). It was a time when frit formulas were published by their manufacturers. He also calculated the glaze's chemistry as a percentage analysis, likely to lay a basis to assess it against stated requirements from stain suppliers (certain stains only work when the host glaze chemistry meets a certain profile).
Doing this now is so much simpler. But almost no one actually does! The closest most technicians get to oxide formulas is choosing which frit from a list of those whose approximate formula is supplied by the manufacturer!

This picture has its own page with more detail, click here to see it.
I did this batch-to-formula glaze chemistry calculation on a version of Desktop Insight that ran on the TRS-80 Model I that I used at home (shown here is my Model III at work, running Insight). The TRS-80's were the first popular consumer micro-computers for business. Notice the report only uses capital letters, that machine did not support lower case! The dot matrix printers of the time lasted forever on an ink ribbon. Fanfold paper fed from a box, I could tear off only as much as was needed for a report. Boot time was less than 5 seconds. Here is what is amazing: In 2021 I found this same recipe in my Insight-live account (the green screenshot)! The results are a little different, I had the chemistry of talc wrong in 1980. I have always maintained my records on computer and through the years, as I migrated from one system to another, I wrote code to carry the data forward. This machine was advanced, before this I was storing data on cassette tape.

This picture has its own page with more detail, click here to see it.
Management now thinks they can outsource his technical work. Danny was good, but he didn’t build a centralized, searchable record of material testing, shipment histories, specs, production problems, and solutions. Instead, his knowledge is buried in thousands of Excel and Word docs and PDFs. He should have used Insight-Live.com to organize, interlink, and preserve this critical data. Sadly, the company does not even realize what they face without Danny:
Had Danny been not just a watchdog but a technical innovator, suppliers and consultants would have been secured to support—not replace—his in-house expertise.
Buy me a coffee and we can talk