Global @@variables
Define exchange rates, tax rates, period boundaries, allocation percentages once. Use them in formulas by name. Change the value once and every formula that referenced it updates.
Use case
Survive month-end close without rewriting the same formulas.
Close week is the same workbook every month, the same FX conversion, the same waterfall, the same accruals — re-derived from scratch by whoever is on rotation. Formula Foundry stores the patterns once and lets you flip a single @@variable to recalc the model.
Free plan — no credit card required.
Month-end close in Excel & Google Sheets
Three habits that turn close week into close day.
Replace constants with @@variables
FX rate, target margin, allocation %. Define each as a global @@variable; every formula that referenced the hard-coded number now reads from one place. Updating the rate updates 500 cells at once.
Save the patterns to snippets
Your quarterly waterfall, your accrual formula, your variance-vs-budget call — all named, all stored, all one click to insert into next month's workbook.
Share the library with the team
On Business, the snippet library is shared across the workspace, and @@variables travel with the workbook, so the analyst on rotation isn't reverse-engineering last month's formula. Everyone uses the same vetted version.
Excel variables & a shared formula library
The pieces that turn re-derivation into reuse.
Shared snippet library
Your team's vetted formulas — the waterfall, the FX conversion, the variance-vs-budget calc — saved once, named once, inserted into next month's workbook by anyone on the team.
Multi-line editor for the gnarly ones
Accrual formulas have a tendency to grow until they're 300 characters of nested SUMIFS. The multi-line editor with indentation makes them maintainable instead of throwaway.
Centralized billing and invites
On Business, anyone on your @company domain gets access on first sign-in — no procurement cycle. One invoice for the whole finance team, prorated as you add seats.
Google Sheets variables in a close model
Variables — change one, recalc the model.
Month-end close FAQ
Close FAQs
- Variables and snippets are on every plan. Pro is a single-user plan: it lifts the Free limits for one person. The team-wide standardization piece, a shared snippet library, is a Business feature, along with per-seat billing, domain-based invites, and priority support. If you're standardizing formulas across a finance team, Business is the plan.
- The cells keep the resolved values they computed — your numbers don't disappear. Some premium features are reserved for paid plans, but the existing formulas stay valid because they're standard Sheets / Excel formulas under the hood. The free plan never expires.
- Variables are per-workbook today; snippets sync across the workbooks of an account. So the waterfall pattern you saved as a snippet is one click away in next month's workbook even though it's a fresh file. Cross-workbook variables are on the roadmap; ask if your close depends on it.
- Most teams seed the variable list and a starter snippet library in an afternoon, then accrue more snippets each month as people notice patterns they re-derive. The standardization payoff compounds — month one is just installing; month three is when nobody is reverse-engineering last quarter's formulas.
Free for Excel & Google Sheets
Stop re-deriving the same formulas every month.
Install Formula Foundry, set up your team's variables and snippets once, and reclaim the days you spent rebuilding the workbook.