Running out of prespray mid-job costs you a trip, and pouring by eye costs you money on every job. This calculator works out gallons of mix and ounces of concentrate from each area's square feet, your dilution and coverage, then shows the cost per job and per square foot and a printable mix card.
Nothing hidden here. You can read how a mix gets worked out right now, tab by tab. Pair it with our carpet cleaning quote calculator and both sides of the job are covered.
What the Carpet Cleaning Chemical Mix & Cost Calculator does
- Up to 30 products with price per gallon, dilution and coverage
- Up to 40 job lines by area, square feet, product and passes
- Gallons of mix, ounces of concentrate and cost for every line
- Printable Mix Card with concentrate to bring and ounces per sprayer fill
- Sales tax and a waste allowance built in
- Chemical cost per job and per square foot
- Chemical cost for the job, ready to copy into the Carpet Cleaning Quote Calculator
What's inside
7 tabs: Start Here, Dashboard, Job, Mix Card, Products, Lists, Settings.
Who it's for
Carpet cleaners who want the right mix every time and chemicals priced into every job.
What you get
Two spreadsheet files (.xlsx): one filled with examples so you can see exactly how it works, and a blank copy ready for your business. For Microsoft Excel and Google Sheets. No macros, no subscription.
The formulas are locked, so a stray keystroke can't break them. You only type in the yellow cells.
What you need to use it
- Microsoft Excel 2010 or newer, on Windows or Mac, including Microsoft 365
- Or Google Sheets in any web browser, free with a Google account
- A laptop or desktop works best for setup. Phones and tablets are fine for checking numbers and quick entries.
- No macros, add-ins or internet connection needed once it's downloaded. Apple Numbers isn't supported.
Amounts are Estimated. Always follow the product label for dilution, dwell time and safety.
Questions
How do I enter a ready-to-use product?
Type 128 oz per gallon. That means no water is added.
Can I plan two passes?
Yes. Type 2 passes on a line for heavy soil or a second treatment.
Is there a blank version?
Yes. Every download has two files: one filled with examples so you can see how everything works, and a blank copy ready for your own business. Your rates and settings come filled in as a starting point, so change them to match yours.
Can I change the formulas?
The gray formula cells are locked so they can't be erased by accident. If you really want to change one, open Review in Excel and choose Unprotect Sheet. There's no password.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The math works the same. Locks don't carry over, so just type in the yellow cells.
How do Free Lifetime Updates work?
Whenever we release a new version, you can download it free from your account, forever. We'll email you when there's something new.
