Free formulation calculator

See the formula ratio—and scale it to any batch.

Compare every ingredient to the total batch and to one selected base ingredient—useful for baker's percentages, spice blends, soaps, cosmetics, and repeatable maker formulas.

Excel-readyExport this tool as a downloadable .xlsx spreadsheet.
Start with the example

The values already filled in are a working example—not a recommendation.

  1. 1Choose the closest starting point.
  2. 2Replace the example with your real details.
  3. 3Read the live result and its important limits.

Formula inputs

Enter one common unit

All quantities must use the same measurement unit. Select the base ingredient used for the relative percentage column.

BaseQuantityIngredient

Two useful views

Total percentage and base percentage answer different questions.

Total-formula percentage shows how much each ingredient contributes to the entire mix. Base percentage compares each ingredient to the selected base at 100%—the familiar baker's-percentage method that also works well for many other formulation workflows.

About this free formulation & batching tool

How to use the Formula & Baker’s Percentage Scaler

Inspect base-100 ratios and scale to a target batch. The calculator runs privately in your browser and is designed to make the assumptions behind the answer visible.

What it helps you decide

Inspect base-100 ratios and scale to a target batch.

What to have ready

Start with a tested baseline formula, measured weights, the unit used by the full batch, and your actual finished yield or process loss.

How to use the result

Treat the output as a controlled batch draft. Record the assumptions, run a small test, and approve the result only after checking quality and safety.

Excel spreadsheet export

Download the Formula & Baker’s Percentage Scaler Excel Spreadsheet

Use the Formula & Baker’s Percentage Scaler in your browser, then export a branded .xlsx formula workbook to preserve the formula inputs, batch quantities, and calculated result for the next production run.

This gives you a portable formula workbook you can save with an order, production record, planning meeting, or pricing review. The workbook keeps the source link and date with the numbers, making it easier to understand where the result came from when you reopen or share it later.

Spreadsheet questions

Using this tool as an Excel workbook

Use the browser calculator for speed, then take the result into the spreadsheet workflow that fits your business.

Can I export the Formula & Baker’s Percentage Scaler to Excel?

Yes. Enter your information, review the live result, and select Export to Excel. Batch Scale creates a branded .xlsx workbook with your inputs and the result shown by the tool.

What is included in the Formula & Baker’s Percentage Scaler Excel Spreadsheet?

The workbook includes a Tool Result sheet, an Inputs sheet, the original calculator link, and the date generated. When a supported calculator has an Excel formula profile, its result cells remain connected to the editable input cells.

Can I use the spreadsheet in Google Sheets?

You can import the .xlsx workbook into Google Sheets. Because spreadsheet applications sometimes interpret formulas and formatting differently, confirm any important result after importing—especially before using it for pricing, safety, compliance, or production.

Is the Excel download free?

Yes. The calculator and workbook are free. The first Excel export on a device asks for your email and permission to receive occasional practical Batch Scale resources. Once captured, later tool exports on that device download directly.

Complete workflow guide

Bakery formulation and scaling

Baker’s percentages make recipe math easier, but consistent bread and pastry also depend on temperature, equipment, timing, handling, and the amount you can actually sell.

Ready for the connected version?

Turn the calculation into a repeatable workflow.

Batch Scale connects recipes, materials, costs, inventory, production, sales, and your storefront in one workspace.