What it helps you decide
Dose from the specified phase and keep supplier limits visible.
Emulsion formulation
Calculate preservative from the phase your supplier specifies.
Compare water-phase and total-batch dosing, calculate an active amount, and keep the supplier usage range visible.
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.
- 1Choose the closest starting point.
- 2Replace the example with your real details.
- 3Read the live result and its important limits.
Your numbers
Phase weights and rates
Use the filled example first. Then replace each field with a measured value or your best current estimate.
Step 1Answer one question at a time. Your example values stay available.
Important limit
Follow the preservative supplier—not a generic calculator.
Use the supplier-required basis, pH range, temperature, solubility, incompatibilities, challenge testing, and good manufacturing controls. Never use this result alone to release a water-based product.
About this free beauty & personal care tool
How to use the Preservative & Active Phase Calculator
Dose from the specified phase and keep supplier limits visible. The calculator runs privately in your browser and is designed to make the assumptions behind the answer visible.
What to have ready
Use exact formula weights plus supplier-confirmed INCI names, use ranges, phase instructions, pH limits, and compatibility information.
Key inputs: Total batch weight; Water-phase weight; Preservative rate on water phase; Active rate on total batch; Supplier minimum use rate.
How to use the result
Use the result as a bench-trial or label draft. Supplier instructions, stability, preservation, safety, and market-specific review still control the finished product.
Excel spreadsheet export
Download the Preservative & Active Phase Excel Spreadsheet
Use the Preservative & Active Phase Calculator in your browser, then export a branded .xlsx formulation workbook to carry the formula inputs and calculated planning result into a bench or documentation workflow.
This gives you a portable formulation 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 Preservative & Active Phase Calculator 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 Preservative & Active Phase 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
Candle, soap, and cosmetic formulation
A calculator can check the math. A reliable product also needs clear supplier information, a repeatable process, testing in the final package, and the right label for what the product is and what you claim it does.
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.