How to use the Carpet Cleaning Chemical Mix & Cost Calculator

How much prespray, rinse and protector a job needs, how to mix each sprayer, and what the chemicals cost per job. Here's every step.

Get this tool · $14Start here

Version 1.0 · 7 tabs · Excel and Google Sheets · Free Lifetime Updates

At a Glance
StepHow long
1Before you start1 min 2Add your products10 min, once 3Plan the jobSee step 4Mix and price itSee step
Messages explainedSee them →

Before you start

The one rule: yellow cells with blue text are yours to fill in. Gray cells calculate on their own and are locked, so you can't erase a formula by accident.
  1. Your download is a zip with two files. Double-click it to open it. Start with the one marked with examples to see how everything works, then use the blank one for your business.
  2. Open the file in Microsoft Excel. Using Google Sheets? Upload it to Google Drive, then open it with Google Sheets.
  3. Start on the Start Here tab. It has the same steps, right inside the file.
  4. The sample data is there so you can see how everything works. Type over it with your own when you're ready.

Here's how to add your chemicals once, then get the mix and cost for any job.

1Add your products (one time, about 10 minutes)

  1. Open Settings. Set your sprayer size, waste extra and the sales tax you pay.
  2. Open Products. Add each chemical with price per gallon, ounces per gallon of mix and coverage.

2Plan the job

  1. Open Job. Add a line for each area and product, with square feet and passes.
  2. Type the carpet area once on the Dashboard for cost per square foot.

3Mix and price it

  1. Print the Mix Card for the van.
  2. Copy Chemical cost for this job into the Carpet Cleaning Quote Calculator.

What the messages mean

The tool watches your numbers and tells you in plain words when something needs a look. Here's every message you might see.

⚠ Product isn't on the Products tab.
What it means: A job line names a product that isn't listed.
What to do: Pick it from the list.
Add coverage for this product on Products.
What it means: The product has no coverage.
What to do: Add square feet per gallon of mix.

Using Google Sheets or your phone

  • To use Google Sheets, upload the file to Google Drive, then right-click it and choose Open with, then Google Sheets.
  • Dropdowns, colors, and every calculation work the same in Google Sheets.
  • On a phone, the Google Sheets and Excel apps work for quick changes. For setup and printing, a computer is easier.
  • Want to start fresh? Type over the yellow example cells. Don't delete rows, since other tabs may be reading them.

Ready when you are

That's the whole thing, nothing held back. See pricing and screenshots for this tool, or compare every carpet cleaning tool side by side.

Common questions

Is it exact?

No. It's an estimate. Real use depends on soil, fiber and how you apply it. Adjust coverage as you learn.

Quick reference from the Start Here tab

Welcome

Every gallon of prespray and rinse costs money, and running short on a job costs more. Add your chemicals once, then list the areas for a job: this calculator shows how much mix and concentrate you need, what it costs and how to mix each sprayer.

Where To Start

1

Open 'Settings'. Set your sprayer size, the extra for waste and the sales tax you pay.

2

Open 'Products'. Add each chemical with its price per gallon of concentrate, dilution and coverage.

3

Open 'Job'. Name the job and add a line for each area and product: square feet, product and passes.

4

Print the 'Mix Card' for the van.

5

Copy 'Chemical cost for this job' from the Dashboard into the Carpet Cleaning Quote Calculator.

Which Cells To Edit

Yellow cells with blue text are yours to fill in. Italic yellow cells marked (optional) can stay empty. Gray cells calculate on their own and are locked.

Need to change a formula? In Excel go to Review, then Unprotect Sheet. In Google Sheets use Data, then Protect sheets and ranges. No password needed.

What The Results Mean

Gallons of mix: square feet × passes ÷ coverage per gallon of mix.

Concentrate: gallons of mix × ounces of concentrate per gallon. The Mix Card adds your waste extra.

Cost: gallons of mix × cost per gallon of mix (concentrate price, dilution and sales tax).

Chemical cost per sq ft: job chemical cost ÷ the carpet area you type on the Dashboard.

How To Clear The Examples And Reuse It

Easiest: open the Blank file. Or select the yellow cells on the Job tab and press Delete. Keep your Products and Settings.

There are 40 job lines and 30 products. Save a copy of the file for each job, or clear the Job tab and start again.

Good To Know

Dilution vs ratio: 4 oz per gallon is about 1:32. 8 oz per gallon is 1:16. Ready-to-use products are 128 oz per gallon.

Coverage: how many square feet one gallon of mix covers. It varies with soil and carpet, so adjust it once you see your real use.

Passes: use 2 for heavy soil or a second treatment, like pet enzyme on a bad spot.

Always follow the product label for dilution, dwell time and safety. Never mix different chemicals together.

Share box: the "Share with other EasyWorkTools tools" box on the Dashboard lists the numbers this file gives to or gets from the other Carpet Cleaning tools. Copy them by hand. The labels match exactly, so it's clear where each one goes.

Getting Updates

Every update is free. When a new version is ready we email you, and you can download it any time.

Moving to a new version: copy the yellow cells from each sheet into the same sheets of the new file.

Using Google Sheets? Upload this file to Google Drive and open it with Google Sheets (or File, then Import, then Upload). The math works the same.

Your License

This file is licensed to one business, including everyone who works there. Please don't share, resell or post it online.

© 2026 EasyWorkTools. All rights reserved. easyworktools.com

Every tab

This file has 7 tabs, in this order:

  1. Start Here
  2. Dashboard
  3. Job
  4. Mix Card
  5. Products
  6. Lists
  7. Settings
Still stuck on something? Ask us. We answer within one business day, and we'll add the answer here for everyone.