This workbook valid till 31 dec 2200 (***this is Excel Macro enable workbook).Please ensure you have suitable software MS office to run. Trial Version available . download here >> https://payhip.com/b/s3qSO.

***User experience apologize have to expect MS office macro lag environment on some process especially chart.

***Preloaded "Library & IFRA" item. for realistic experience update your own experience and update IFRA reference.

The MyScentCal Analytical Workbook: Automated Fragrance Formulation & R&D Platform

Detailed Product Description:

Unlock Precision in Your Perfumery

The "MyScentCal" Analytical Notebook transforms your R&D process from manual calculation guesswork into a precise, dynamic, and automated workflow. Built on robust VBA, this macro-enabled Excel workbook is designed specifically for beginner and intermediate perfumers who need instant, objective analysis of their fragrance blends.

Stop wasting time with unreliable spreadsheets and start focusing on the art of formulation.

Core Objectives & Functionality

The platform operates as a secure, structured digital lab book that provides instant, data-driven feedback on your formula's identity and composition.

• Objective: Eliminate calculation errors, standardize testing records, and provide real-time analytical insights into fragrance identity (Family, Accord, Gender).
• Running Style (VBA-Powered Automation): The workbook is highly optimized for speed. Simply change an ingredient weight on the Formula Calculator sheet, and the core VBA pipeline instantly calculates, sorts, and displays the full analysis on the Profile sheet. All sheet protection and security checks are handled automatically in the background.

Key Benefits & Selling Points

1. Dynamic Composition Analysis

Forget manual lookups. The workbook instantly calculates and displays the exact percentage contribution of every component:

• Real-Time Accords: See the precise weight percentage of every Facet and Accord (e.g., Citrus, Floral, Spicy) contributing to the final blend, dynamically updated as you adjust weights.
• Structured Output: Accord and Family charts are automatically sorted by percentage contribution, giving you an immediate visual hierarchy of your formula.

2. Advanced Classification & Identity Scoring

Access specialized formulation scores that simplify complex fragrance architecture:

• Automated Gender Classification (Profile!G38): Get an instant, calculated rating of whether your formula leans Masculine, Feminine, or Unisex based on ingredient weights and classification.
• Complex Family Scoring: The VBA runs custom algorithms to calculate specialized scores for architecturally defined families, specifically Chypre and Fougère, based on the presence of key components (like Oakmoss, Lavender, and Bergamot) and their note type (Top, Middle, Base).

3. Structured R&D and Security

Maintain a professional, traceable development path suitable for small brands and dedicated hobbyists:

• 10-Batch Testing Archive: Easily save and archive the full formula, classification scores, and profile values for up to 10 unique test batches (Record TEST sheet) for later comparison and historical analysis.
• Integrated Research: Quick-access web search button links directly to the Fragrantica Notes database, allowing you to research ingredients without leaving the workbook.
• Security & Longevity: Code is protected via Workbook Structure passwords, and the tool includes a System Check & Reset button to self-diagnose and fix common macro environment issues (lag, sheet corruption).

4. Data Management & Compliance

The system operates on an easily maintainable, user-updatable database:

• Self-Managed Library: You maintain the My Library and IFRA Reference sheets up to 2000 rows, giving you full control over your material data, GC-MS data fields, and safety limits.
• Print Blocking: The workbook protects your raw intellectual property by automatically blocking the printing of the sensitive My Library and IFRA Reference sheets.