Avoiding Calculation Errors
|Help Home Previous Next|
When using Exl-Plan, it is important to ensure that no calculation errors arise; that its sub-models produce identical results; and that no imbalances occur in the opening or projected balance sheets.
Because Exl-Plan does not use floating values to forceably balance its balance sheets, it is very sensitive to formulae errors and consequently all structural changes to the model must be applied correctly. For example, if an additional cashflow-related item is introduced into the model as an assumption row, changes may be needed in the income statement, cashflow and balance sheet output reports. See Making Complex Changes.
Exl-Plan displays on-screen messages when it detects calculation errors when the F9 function key, *Tools/Setup > Calculate All & Check menu command or "C" toolbar button are used. These messages (see below) cover the most likely error situations. The following general procedure should help locate and eliminate errors:
The following messages will be displayed immediately after Exl-Plan recalculates if a calculation error is detected. Errors will only be reported if they are outside pre-set tolerance limits as Exl-Plan automatically filters out and ignores trivial errors due to rounding off and calculation differences etc. arising after the third decimal place.
Always Check Exl-Plan's Output
Exl-Plan was extensively tested during its development to ensure that it is robust and does not contain or cause any errors. It was tested with zero values throughout to eliminate divide by zero errors; with large values for every assumption to test for possible imbalances between the sub-models; and with values entered and calculated on a progressive basis to detect errors caused by the interaction between variables. All Exl-Plan's calculations and formulae were checked manually and the entire model was extensively checked using an auditing system. Notwithstanding this, PlanWare - Invest-Tech cannot guarantee that all possible errors or sources of error have been removed and cannot anticipate errors that may be introduced by users. Accordingly, users should always review the output reports for possible anomalies and calculation errors. In some circumstances, values may not appear to add up correctly due to rounding off.
Online: Support Purchase