Summary:
Harness the power of global variables and formulas in Saturation for consistent and efficient budgeting.
What is a Global?
A 'Global' in budgeting is akin to a variable in mathematics. It represents a specific value or formula that can be used across multiple areas of a budget. By setting a global value, users can reference it multiple times without having to re-enter the value repeatedly.
For example, imagine you're budgeting for a film project lasting 6 weeks. Instead of manually entering '6 weeks' for every relevant cost, you can set a global variable, say TW (Total Weeks), and use it throughout your budget.
Steps to Use Globals & Formulas:
Accessing Globals & Formulas: In any rate, qty, or number cell, press the "=" symbol to enable the formula mode. Here, you can combine standard arithmetic with your globals.
Begin typing letters after "=", and a dropdown will appear, showcasing your current globals.
Setting up Globals: On the left sidebar, you'll find a button labeled "Globals." Clicking on this opens the Globals setup table. Here's a breakdown of the columns:
Symbol: Add a shortcode for your global. Example:
TWfor "Total Weeks."Description: Define the global. Using our example, "Total Weeks."
Formula: Enter a number or a custom formula. For our example, '6'.
Unit: Specify the measurement unit. Here, it's 'weeks'.
Evaluation: A non-editable column showing the final value.
Use formulas to reference these globals. For instance, with
TWrepresenting 6 weeks, a formula might look like= TW * $1000to determine costs over that period.
Requirements/Limitations:
Only number columns support Globals and formulas.
Best suited for overarching modifications rather than specific entries.
Benefits:
Consistency: Globals ensure you have consistent numbers throughout.
Efficiency: Update one global to modify all related values.
Dynamic Budgeting: Real-time calculations mean faster, more accurate budget adjustments.
Frequently Asked Questions:
Q: Can Globals & Formulas be combined in one cell?
A: Absolutely! Reference a global within a formula for dynamic calculations.Q: Can you have more than one global?
A: Yes! Just structure it like a formula example. (=TW+SW)
Notes/Additional Info:
Together, Globals & Formulas offer a potent tool for large-scale budgets where certain constants, like duration or tax rates, impact multiple entries.