From Scattered Spreadsheets to a Single Source of Truth: The Hammer Haag Steel Story — As It Unfolds

The Challenge — And the Opportunity Behind It

Hammer Haag Steel didn't get to where they are by accident. Through years of hard work, skilled craftsmanship, and an unwavering commitment to their customers, they built a thriving steel fabrication operation — one that spans sales, estimating, engineering, production, and shipping, and that has earned the trust of a growing customer base that keeps coming back.

But growth has a way of stress-testing the systems that got you here. What works when you're smaller starts to strain when the volume increases, the jobs get more complex, and the expectations get higher. At HHS, a capable and dedicated team had been carrying the operation forward through a combination of Excel spreadsheets, paper travelers, manual checklists, and sheer institutional knowledge. That approach worked — until the business outgrew it.

The reality is that any manufacturing operation at HHS's level of complexity eventually reaches an inflection point: the workflows that built the business begin to limit what the business can become. Job status lived in people's heads rather than a system. Customer data was spread across multiple files and excel spreadsheets. When a question arose or a problem surfaced, finding the answer meant finding the right person — and the right person isn't always available.

This wasn't a reflection of how the team operated. It was a reflection of how fast the company had grown. Hammer Haag had built something worth protecting and scaling — and to do that, they needed infrastructure that could grow with them. Not a generic software solution that would force them to change the way they work, but a system purpose-built around the operation they had already built.

Why YOLM

Before partnering with YOLM, Hammer Haag had done what most growing businesses do — they looked for software solutions to help manage the complexity. Different tools were brought in across different departments: sales, production, engineering, applications for tracking. Each one promised to solve the problem.

Each one fell short.

The issue wasn't a lack of effort or adoption. The issue was fit. Every tool they tried required them to reshape their processes around the software's limitations rather than having the software adapt to the way their operation actually runs. Off-the-shelf software is built for the average business — and Hammer Haag is a custom fabrication operation running at the top of their industry. No pre-packaged solution was built with them in mind. And so, like most operations that outgrow what the market offers, Hammer Haag built their own solution — with spreadsheets. From the first RFQ to the final shipment, the entire end-to-end workflow was managed through Excel. Estimating, engineering, production tracking, scheduling, shipping — spreadsheets connected every stage of the operation. For a time, it worked. Macros got smarter. Workarounds got more sophisticated. But there is a ceiling to what a spreadsheet can do, and a growing business moving at HHS's pace will eventually find it.

What Hammer Haag needed wasn't another off-the-shelf product or a more elaborate macro. It was a partner willing to start with a blank page.

YOLM's approach was the opposite of everything HHS had tried before. Rather than presenting a pre-built system and asking the team to conform to it, YOLM mapped every workflow, every handoff, every edge case — and built from the ground up around the way HHS actually operates. Every module, every data field, every alert and approval chain was engineered to mirror their specific processes and designed to scale as the company grows.

The result is a phased transformation that delivers measurable value at each milestone, starting with the area that needed it most: shipping.

Phase 0: The Shipping Management System

The Starting Point

YOLM and Hammer Haag began with the shipping workflow — the most documentation-intensive and customer-visible part of the operation. This was the proof point: demonstrate clear, measurable improvement here, then expand the system outward through the full operation.

What Was Built

YOLM developed a comprehensive, database-driven QR code management system that tracks every manufactured steel part from post-production through final shipment. The system features three purpose-built components working together:

• For Project Managers — a back-office application providing complete visibility into job status, inventory, and shipment records at any moment.
• For Shipping Clerks — a mobile app that guides warehouse staff through every step of the loading process, from scanning individual parts to capturing photo documentation.
• For Customers — a real-time tracking link providing transparent, up-to-date shipment status without requiring a phone call.

Every manufactured part receives a durable QR code sticker — engineered to survive blasting, painting, and 70 mph transport for up to six months — that contains the full identity of that part: project, item number, part number, job name, purchase order, description, and weight. No more lost Sharpie markings. No more guesswork.

The system also handles the complexity that makes steel shipping uniquely challenging: bulk hardware (nuts, bolts, washers) is containerized under master QR codes, while the bundle and pallet management system groups multiple parts into single shippable units, capturing multi-layer photo documentation before shrink-wrapping and auto-calculating total weight.

When it's time to load a truck, a two-stage scanning workflow differentiates "ready to ship" from "confirmed shipped," capturing guided photo documentation from seven angles — creating an indisputable visual record of exactly what was on that truck and when.

A consolidated Bill of Loading is generated per truck regardless of how many POs are involved, complete with an embedded QR code linking to full shipment details. Before the physical BOL prints, a three-tier electronic sign-off is required from the Shipping Clerk, QC/Supervisor, and Truck Driver — building accountability into the process at every level.

A color-coded alert system prevents errors before they happen: under-shipping warnings, over-shipping flags, duplicate scan prevention, and restricted manual data entry requiring supervisor override.

The Results

"We cannot even begin to describe the stability which that creates within the workplace and management of jobs. When problems arise, we are able to see exactly what occurred and will be able to show evidence to customers of specific job parts."

"This is beginning to and will continue to straighten out the flows and speed of finished jobs being sent out. We are so happy with the product so far and are even more excited to continue to implement it and see the wins that it creates within the company!!"

— Hammer Haag Steel Team

For the first time, HHS has a single source of truth for every job moving through their shipping workflow. When a customer calls, the answer is in the system. When something goes wrong, the evidence is already documented. The guesswork is gone.

What Comes Next for Hammer Haag

Phase 0 is just the beginning. The shipping system proved the concept — now the same centralized approach expands across the entire operation.

Phase 1 brings the full workflow into one database, from the first RFQ through final shipment. This means a unified customer database, digital Work Order Checklists auto-populated from quote data, a BOM-driven engineering module that generates fab lists and shipping lists automatically, digital travelers replacing paper through every production stage, material receipt verification, QR tracking on all parts and assemblies from pre-fabrication forward, quality and error tracking with automated HR notifications, and a foundational finance module tying invoicing directly to project milestones. When Phase 1 is complete, every piece of information about every job — from initial quote through final shipment — lives in one place.

Phase 2 layers intelligence on top of that foundation. AI-assisted BOM extraction from 3D models, automated vendor RFQ distribution, purchase order generation from vendor quotes, proposal vs. purchase order comparison with automatic discrepancy flagging, scheduling assistance with material availability integration, and advanced dashboards and forecasting. The tedious manual work gets faster and more accurate. The decisions that used to depend on one person's memory get built into the system.

The YOLM Difference

What makes this transformation work isn't just the technology — it's the philosophy behind it, and the architecture built to deliver on it.

YOLM was built around a single conviction: complexity kills speed. Most enterprise software creates complexity — fragmented databases, integration nightmares, layers of middleware, and systems that require IT teams just to keep the lights on. YOLM calls this the old way, and they've built something fundamentally different.

The YOLM platform runs on what they call the Simplicity of One — one unified database, one platform, one model. Where a traditional tech stack requires separate systems for database, search, API, authentication, file storage, and UI — each needing to be integrated and synchronized — YOLM consolidates all of it into a single, high-performance runtime. For Hammer Haag, that means the moment a shipping clerk scans a part on the floor, every dashboard, every report, every record updates instantly. No batch processing. No overnight syncs. No "my spreadsheet doesn't match yours."

At the core of the development environment is Yolm Studio — an AI-powered platform that doesn't just write code, but understands the entire application. It can generate complete workflows, recommend components, and make changes across the full stack simultaneously. This is what allows YOLM to build and iterate at a speed that traditional development simply cannot match — and it's what allows Hammer Haag's own team to create new reports, dashboards, and workflows as their needs evolve, without waiting on a development queue.

Most software asks businesses to change the way they work to fit the software. YOLM builds the software to fit the way you work — and then keeps building as you grow.

What This Means for You

If your operation is running on a combination of spreadsheets, paper documents, disconnected software, and tribal knowledge — you already know the cost of that gap. In lost time, in customer confidence, in the risk that walks out the door every time a key employee leaves.

And if Microsoft Access is part of your current setup, you may already be feeling a different kind of ceiling. Access was built for a different era — designed for small-scale, desktop-based data management when the internet was still young. It has no native web deployment. It has no mobile interface. There is no way to give your team real-time access from the shop floor on a tablet, no way to give your customers a live tracking link, and no native API layer to connect it to the tools your business depends on today. Access is a desktop application, and the world your business operates in is not. Your team is mobile. Your customers expect transparency. Your operation needs to be accessible from anywhere, on any device, in real time. Access cannot get you there — and no amount of engineering around it will change that.

The same is true for operations running end-to-end on spreadsheets. Excel is a powerful tool. But it was never meant to run a business. At some point, the macros get smarter, the workarounds get more elaborate, and the system gets more fragile — until one wrong formula or one missing file brings the whole thing down.

Hammer Haag Steel's story is still being written. But the early results are already showing what becomes possible when software is built around your operation instead of the other way around.

YOLM builds custom software solutions for manufacturing operations that are growing faster than their current systems can keep up with — whether you're running on spreadsheets, Access, or a patchwork of tools that were never meant to talk to each other.

Ready to see what a transformation like this could look like for your operation?

Let's start the conversation.

Listen to our podcasts | Schedule a consultation

For more information about YOLM and the Hammer Haag Steel digital transformation, or to inquire about a custom software solution for your operation, please contact:
Anne Bruce, YOLM.ai, 310-704-8266