All use cases
Quotes & Estimates

An HVAC purchasing worker turned an old special-job pricing spreadsheet into a cleaner web calculator

Document the rules in a pricing spreadsheet before turning it into a simple quote-calculator demo.

Real storyDone with Grok Bot
TradesHVAC

What they did

An X poster whose profile identifies HVAC/R purchasing said Grok Bot rebuilt an old Excel spreadsheet used to price special HVAC systems and situations. The result was a cleaner web layout for estimates.

How it went

The poster reported doing this within ten minutes. There is no published formula audit, pricing comparison or measured quoting outcome, so that is their build-time claim, not a guarantee. What makes the idea useful is preserving a shop’s established rules while making the inputs easier to understand.

Worth knowing

A polished calculator can hide a wrong formula. Test it against known spreadsheet examples, including blank inputs, unusual quantities and rounding. Keep it internal until an estimator checks the outputs; do not let AI supply new equipment or labor prices. This is a firsthand social-media account or discussion, not an independently verified business result. The reusable prompt is our adaptation, not a quote of the poster’s exact setup. Wisconsin angle: A Wisconsin HVAC shop might start with one awkward add-on or special configuration. Keep permit assumptions, price-book dates and manual-quote exceptions visible.

Try it yourself

You help a Wisconsin HVAC business with practical office work. TASK: Document the rules in a pricing spreadsheet before turning it into a simple quote-calculator demo. INPUTS (fill in brackets; remove private customer/employee details): - [SPREADSHEET RULES]: formulas and field definitions - [APPROVED PRICE BOOK]: date and units - [FIVE KNOWN EXAMPLES]: inputs and correct outputs - [MANUAL QUOTE EXCEPTIONS]: cases to block STEPS: 1. Explain each formula and its units, flagging ambiguity. 2. Draft a small calculator specification preserving those rules exactly. 3. Recalculate my five examples with visible arithmetic and report mismatches. 4. Write an optional Lovable demo brief: fake inputs only, no live prices or customer sending, show assumptions and review warnings. 5. Supply tests for empty values, out-of-range values, rounding and manual-quote exceptions. GUARDRAILS: Use only my facts. Mark gaps NEEDED; unreadable text UNREADABLE. Cite the source row, note or document page for each finding. Never invent prices, quantities, tests, credentials, approvals or promises. Separate facts from assumptions. Do not diagnose a safety-critical system or invent code/legal requirements. Flag those for a qualified professional. Draft only: do not send, publish, book, purchase, charge, delete or modify records. Show calculations and flag uncertainty so I can check them. DELIVER: A concise working draft/table, missing facts, and a checklist of what I must verify before use. Write in plain local-shop language, not marketing jargon. Finish with a small test plan: try this on five past examples, compare with the originals, record errors and total time including review. Do not claim savings until I measure them.

Want help getting this working? Rise Systems in Oconomowoc sets these up.

Want this running in your business without the DIY? Rise Systems in Oconomowoc sets these up.

Free 15-minute AI check-up
Read the original

Source: X (Twitter) · October 29, 2026

Related