Often costs such as subscriptions, ongoing newsletters and SEO services are recurring throughout the fiscal year. Allocadia allows you to input these recurring costs in your Plan Columns to track how these costs affect your Top-down Allocation while ensuring you stay on target. If you are dividing costs across several months, Allocadia can assist with simple operations such as in-cell calculations or copy and pasting your cell values for improved entry.
Use Allocadia as Your Calculator
Add, subtract, multiple of divide in the application – all without ever opening a calculator.
- On the Budget Tab, click into the cell where a calculation is desired
- Enter your in cell calculation with the following formula: =number +,-,/,* number e.g. =15*30
Note: If you enter an incomplete calculation or have an error in the formula syntax the cell will be outlined in red, and the calculation will not be complete. The box will be outlined in green after you have entered a valid calculation.
- Press Enter or select out of the box and your total will automatically be calculated.
Note: Allocadia does not record the formula, so once the calculation is complete there is no way to see the original equation.
Duplicate Cell Entries for Recurrent Costs
- On the Budget Tab, locate the Marketing Activity you would like to add recurrent costs for
- Click into the cell and copy the amount by right clicking and selecting copy
Tip: You can also copy the amount by using the keyboard shortcut key Control / Command and C.
- Add the recurrent costs by pasting the amount in the corresponding cells by right clicking and selecting paste
Tip: Using the keyboard shortcut key Control / Command and V also allows you to paste the amount