πŸ§ͺ Import MGM15 Formula & Procedure β€” Clean Model

One-pot synthesis: MIT β†’ 7-OH (oxidation) β†’ MGM15 (NaBHβ‚„ reduction). Salt and freebase MIT variants. 12 real-world ingredients.

⚠️ This will DELETE and replace the following Firestore data:
β€’ Formulas: mgm15-salt-85-90 and mgm15-freebase-85-90
β€’ Procedures: mgm15-salt-synthesis and mgm15-freebase-synthesis
β€’ SKUs: MGM15-Salt and MGM15-Freebase in skus collection
β€’ The sodium-borohydride ingredient will be added to the ingredients collection
Existing 7-OH formulas/procedures, raw material lots, finished goods, and batch records are NOT affected.
πŸ“‹ Design Notes for this Procedure:
β€’ Optimization fields: Steps marked [RANGE] have a targetRange field (e.g. "<10Β°C", "60 min") stored alongside the standard value. Lab techs enter actual values β€” these feed the Optimization Engine.
β€’ Prep instructions: Saturated NaHCO₃ (100g per 1L water) and Brine (360g NaCl per 1L water) instructions are embedded in step notes and shown on batch sheets.
β€’ NaBHβ‚„ addition: Modeled as a timed-drip step with additionMinutes: 60 and tempLimit: 10 fields. Batch sheet shows the constraint; lab tech records actual time and temp.
β€’ Water waste recording: Two type:"record" steps in extraction phases β€” lab tech enters liters of water waste collected from each separation.
β€’ Mixing speed/time: Action steps carry stirRpm and mixMinutes fields β€” same pattern as the quench step on your existing batch sheet.

🧬 12 Ingredients (11 shared with 7-OH + 1 new)

✏️ Formula Materials β€” Edit Before Import

Edit any factor, base, unit, or notes below. Changes apply to both Salt and Freebase variants (except Naβ‚‚CO₃ and its water which auto-scale per variant). Click Reset to Defaults to undo all edits. Step Label is read-only β€” it links formula materials to procedure steps.

Salt variant shown β€” Naβ‚‚CO₃ qty differs for Freebase
# Ingredient ID Step Label Base Factor Unit Notes

πŸ“‹ Procedure Steps β€” Edit Instructions Before Import

Edit step instructions below. Changes apply to both Salt and Freebase variants. Step names and types are read-only. Click Reset to Defaults to undo all edits.

# Phase Display Name Type Instruction

πŸš€ Run Import

Writes MGM15 ingredients, formulas (salt + freebase), procedures (salt + freebase), and SKUs. Does NOT touch 7-OH data.