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) | |
|---|---|---|---|---|---|---|---|---|
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
0 | 0 | 0 | ||||||
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 | |
|---|---|---|---|
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:
Odor Evolution Notes:
Refractive Index (Experimental):
Final Batch Approval Signature:
Form Template Insights
Please remove this form template insights section before publishing.
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.