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, EDA Phocas Budgeting and Forecasting keeps a level of simplicity by allowing for basic arithmetic in these forumulas.
...
Referencing cells within a worksheet will be relative when these are copied forward i.e. if a cell referenced Jan January data, then when the user copies this to Feb February it will reference Feb February data.
Referencing cell in a Total column will be absolute and copying these forward will always reference the total.
...