This section establishes the administrative traceability of the batch, linking the formulation to specific project briefs, perfumers, and regulatory timelines.
Formulation Name / Code:
Project / Client ID:
Target Application:
Creation Date:
Compounded By:
Perfumer
Technician
Batch / Lot Number:
Status:
This section defines the physical scale and chemical base of the fragrance. The inputs here serve as the mathematical foundation for all percentage and concentration formulas in the spreadsheet.
Total Target Batch Mass (g):
Desired Concentration (%) [Concentrate-to-Solvent Ratio]:
Calculated Target Concentrate Mass (g):
Carrier Solvent Type:
Actual Carrier Solvent Mass Added (g):
Specific Gravity of Finished Batched (g/mL):
The core formulation matrix. This table handles the raw materials, their olfactive classifications, and the critical math determining odor impact.
Ingredient Code | Chemical / Natural Material Name | Note Category | Odor Threshold | Mass Added (g) | Formula: Blend % | Formula: Concentration (PPM) | Formula: Odor Activity Value (OAV) | ||
|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | ||
1 | 0 | 0 | 0 | ||||||
2 | 0 | 0 | 0 | ||||||
3 | 0 | 0 | 0 | ||||||
4 | 0 | 0 | 0 | ||||||
5 | 0 | 0 | 0 | ||||||
6 | 0 | 0 | 0 | ||||||
7 | 0 | 0 | 0 | ||||||
8 | 0 | 0 | 0 | ||||||
9 | 0 | 0 | 0 | ||||||
10 | 0 | 0 | 0 | ||||||
11 | TOTALS | 0 | 0 |
This section automatically cross-references the formulation data against the International Fragrance Association (IFRA) standards to prevent safety violations before mixing.
IFRA Product Category Selection:
Restricted Material Check Tracking Matrix
Material | Current Blend Concentration ((Oakmoss Mass / Total Batch Mass) * 100) | Maximum Allowed Limit for Selected Category | ||
|---|---|---|---|---|
A | B | C | ||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 |
IFRA Alert Flag:
IF Current Concentration Allowed Limit: [ PASS: Formulation complies with IFRA Amendment standards. ]
IF Current Concentration > Allowed Limit: [ !! CRITICAL ALERT: OAKMOSS EXCEEDS MAX ALLOWED LIMIT FOR THIS CATEGORY !! ]
Post-compounding qualitative and physical evaluation to ensure batch-to-batch consistency and trace aging characteristics.
Physical Appearance:
Initial Olfactive Evaluation (Maceration Day 0):
Top Notes:
Heart Notes:
Dry Down:
Aging/Maceration Log (Day 14 Re-Evaluation):
Color Changed Observed:
Description of Color Changed Observed:
Odor Evolution Notes:
Refractive Index (Experimental):
Final Batch Approval Signature:
Form Template Insights
Important Note:
This analysis provides strategic insights to help you get the most from your form's submission data for powerful follow-up actions and better outcomes.
AI-Generated Content: This template and its accompanying guidance are AI-generated to provide a practical starting point for your form-building needs. Please review and customise the content to ensure it is accurate, appropriate and suitable for your intended use.
This guide is provided for general informational and planning purposes only. It does not constitute professional, legal, financial, medical, employment, privacy, regulatory, or advice of any other kind, nor does it certify that this template is suitable or compliant for any particular jurisdiction or purpose.
Laws, regulations, industry practices and business requirements vary. You are responsible for reviewing and customising the template to suit your intended use and obtaining advice from appropriately qualified professionals where necessary.
Please delete this section before publishing your form. See our Terms of Service for further information.
This specialized form serves as an advanced analytical blueprint and quality control mechanism for perfumers, flavorists, and lab technicians. At its core, the document transitions a creative olfactive concept into a precise, scalable, and safe chemical reality. By centralizing raw raw material inputs, mathematical thresholds, and strict international safety regulations into a single data architecture, the form bridges the gap between artistic expression and rigorous chemical engineering.
To configure an element, select it on the form.