You can enter simple formulas in the budget worksheet. These formulas can reference cells in different worksheets, working rows or comparison rows. Rather than including more complex spreadsheet functions, Phocas Budgeting and Forecasting keeps a level of simplicity by allowing for basic arithmetic in these formulas.
Formulas can be entered by:
clicking into the cell and typing ‘=', ie., 'equals’
pressing F2 while in a cell
Clicking into the formula (fx) bar while in a cell.
Once a cell contains a formula the cell value will have a blue fx indicator next to it. Hovering on this shows the formula.
When referencing cells you will see a description appear for the cell being referenced with a coloured dot corresponding to that cell.
Examples
IT Computer Costs may be a function of wages, in this case IT costs are 2% of wages of AU:
We might have an exchange rate on the Manual Entry Driver tab and we want to Budget our Australian Conference in AUD. In this example the Manuel Driver Tab is named 'Assumptions”.
Absolute vs Relative referencing
Referencing cells within a worksheet will be relative when these are copied forward i.e. if a cell referenced January data, then when the user copies this to February it will reference February data.
Referencing cell in a Total column will be absolute and copying these forward will always reference the total.