Short answer
Before trusting any perfume formulation tool — a spreadsheet you built, one you downloaded, or dedicated software — run it against a small set of test formulas whose answers you have worked out by hand. Check that it totals correctly, handles a diluted row and a solvent row, gives the three percentages you expect, scales by total and around one fixed material, splits a production target into concentrate and alcohol, costs a diluted row correctly, and flags a restricted material on the basis you think it does. Then export a formula and re-import it to see what survives. An hour of testing tells you more than any feature list.
Why test at all
Every tool makes choices that are invisible until they matter: whether a dilution's solvent counts in the total, which percentage a restriction is checked against, how rounding is done, what happens to a blank cell. A tool can be internally consistent and still not do what you assume. Errors that come from these choices are worse than typos because they repeat in every formula. Common spreadsheet failure modes are described in perfume formula spreadsheet problems; this article is the test that catches them, whatever the tool.
The test formula
A deliberately simple 100 g formula with one diluted row and one solvent row. Every expected value below was calculated by hand.
| Row | Weight (g) | Dilution | Pure material (g) |
|---|---|---|---|
| Material A | 40.00 | 100% | 40.00 |
| Material B, 10% in DPG | 10.00 | 10% | 1.00 |
| Material C | 30.00 | 100% | 30.00 |
| DPG (solvent) | 20.00 | — | 0 |
| Total | 100.00 | 71.00 |
Test cases and expected answers
| Test | Expected | What a failure suggests |
|---|---|---|
| 1. Total weight | 100.00 g | Rows missed or double-counted |
| 2. Formula % (weight ÷ total) | A 40, B 10, C 30, DPG 20 | Wrong denominator |
| 3. Pure material of B | 1.00 g | Dilution ignored or applied twice |
| 4. Absolute % (pure ÷ total) | A 40.000, B 1.000, C 30.000 | Dilution not applied |
| 5. Relative % (pure ÷ total pure) | A 56.338, B 1.408, C 42.254 (sum 100) | Solvent counted as fragrance, or dilution ignored |
| 6. Scale to 250 g | A 100.00, B 25.00, C 75.00, DPG 50.00 | Scaling not proportional |
| 7. Scale so C = 45.00 g | Factor 1.5; total 150.00 g; A 60.00, B 15.00, DPG 30.00 | Fixed-material scaling unsupported or wrong |
| 8. 50 g of perfume at 20% | 10.00 g of this concentrate, 40.00 g alcohol; rows A 4.00, B 1.00, C 3.00, DPG 2.00 | Concentration taken on the wrong base |
| 9. Cost (A $120/kg, B's material $2,000/kg, C $80/kg, DPG $10/kg) | A $4.80, B $2.09 (material $2.00 + DPG $0.09), C $2.40, DPG $0.20; total $9.49 | Diluted row costed at the material's price for its full weight |
| 10. Rounding: three rows of 1 part each | 33.33% each, shown total 99.99% or 100% — but the tool should say which | Hidden rounding or forced totals |
The arithmetic behind each line is in the perfume dilution and calculations guide, the three percentages in formula %, absolute % and relative %, and the cost of diluted rows in perfume cost calculation.
Test the restriction check
Restriction checks vary most between tools. Give Material C an invented limit and find out what the tool compares it with:
- Its share of the concentrate (formula %, absolute % or relative %)?
- Its share of the finished product, using the concentration you entered?
- Does it know the product category, or only one limit per material?
- Does it look inside premixes and naturals' constituents, or only at the row?
None of these answers is wrong in itself, as long as you record limits in the matching form and know what the flag means. The underlying method is in how to calculate IFRA compliance.
For the record, RUŌOD Lab flags a row when its relative % exceeds the IFRA limit you recorded on that material; it ships no IFRA data and does not total constituents across naturals, and a premix recorded as a material is checked as one row. Its engine reports formula %, absolute % and relative % for every row and scales by total, by factor and around one material's weight.
Test data in and out
- Export the test formula in each format the tool offers.
- Open the exports: are dilutions, solvent flags, versions and notes there, or only names and weights?
- Import the export into a fresh copy of the tool, or another tool, and repeat tests 1–5.
Anything lost in the round trip is something you could lose when you change software. Formula data portability describes a fuller portability test.
Edge cases worth a minute
- A blank weight: is it treated as zero, as missing, or rejected?
- A very small weight (0.001 g): shown, rounded away, or flagged?
- A dilution entered as 0.1 instead of 10%: does the tool catch the unit?
- Renaming a material: do formulas that use it update, and does a where-used list still find them?
- Undo after a scale: does everything return exactly?
Keep the test
Save the test formula and its expected answers. Run them again after updating the tool or editing a spreadsheet's formulas — the moment a regression is most likely. Software selection more broadly is covered in the perfume formulation software guide and how to choose perfume formulation software.
Frequently asked questions
My tool shows slightly different relative percentages. Is it wrong?
Check rounding first: differences in the third decimal place usually are. Differences in the first decimal usually mean a different treatment of solvent or dilution — find out which.
Should I test a vendor's software before buying?
Yes, with a trial or a demonstration on your own test formula. A vendor who will not run your test is telling you something.
Written and reviewed by the RUŌOD Lab team. This article is general education about perfume formulation and record-keeping; it is not legal, regulatory or safety advice, and the examples are illustrations, not validated commercial formulas. How we write and check these guides.