Using Formulae Instead of Values
|Help Home Previous Next|
By inserting formulae instead of values within the unprotected, cream assumption rows within assumption reports, it is possible to reduce the number of values to be entered every time the model is altered. For example:
The scope for using formulae is considerable. For example, they could be used to handle foreign currency transactions by inserting additional schedules for projected sales in local currencies and adding a further row for projected exchange rates to convert these values to the currency used throughout Exl-Plan.
When using formulae instead of values, avoid creation of circular calculations which may become evident if Exl-Plan apparently fails to update even after pressing the F9 function key etc.
You may wish to progress to a more powerful version of Exl-Plan for the purpose of generating more detailed monthly and quarterly multi-year projections and to gain access to a range of powerful planning tools for "what-ifs" sensitivity analyses, profitability improvement etc. For detailed descriptions, visit <http://www.planware.org/exldesc.htm> and for trial copy downloads go to <http://www.planware.org/exldown.htm>.
Online: Support Free Registration Purchase Upgrade