Formulas: Preset and Custom
Use Model Reef’s preset formulas for timing, seasonality and recurrence - or build custom formulas using any drivers or variables to create logic that fits your exact forecasting needs.
Watch: Build Formulas in Minutes
Follow these steps to use preset formulas or write custom expressions that shape your model’s behaviour.
Step 1: Choose Formula Type
Step 2: Add Logic
Step 3: Connect to Drivers
See the Difference Instantly
Before Model Reef, formulas were fragile - buried in spreadsheets, hard to audit, and easy to break. Now every formula is clear, reusable and tied directly to your drivers and variables.
| Task | Before Model Reef | After Model Reef |
|---|---|---|
| Choose a Formula | Hidden cells | Transparent presets |
| Add Logic | Manual expressions | Structured custom formulas |
| Connect Drivers | Disconnected inputs | Linked, reusable logic |
Your formulas become cleaner, clearer and easier to maintain.
Logic That’s Clear, Flexible and Reusable
Model Reef gives you powerful tools to build logic that’s easy to read, easy to update and deeply integrated with your assumptions.
Clarity in decisions
Understand exactly how each series is calculated.
Accuracy you can trust
Preset formulas reduce errors and keep behaviour consistent.
Speed that saves hours
Write once - reuse logic everywhere across your model.
Experience modelling logic made simple.
Keep Learning, Keep Exploring
Every tutorial builds on the last - helping you layer structure, drivers and formulas into a clean, powerful modelling system.
Each new skill deepens your control over how your model behaves.
Explore the Features Behind This Workflow
Model Reef makes building and maintaining formulas easier, safer and faster.
Driver-Based Modelling
Reference any variable or driver to keep your formulas consistent.
Real-Time Scenario Analysis
See how formula-driven outputs change instantly under new assumptions.
Real-Time Collaboration
Review and refine formulas together with full transparency.
Deep Integrations
Blend external data with custom logic to create stronger forecasts.
See all features that make modelling logic more powerful.
Ready to Build Smarter Formulas?
Start your free 14-day trial and experience how structured formulas make your models faster, cleaner and more transparent.
Want to explore more? Compare plans