How can I restructure Exl-Plans reports to include additional variables?
Let us assume that you need to add new variables which will impact on all monthly, quarterly and annual reports. One solution would be to work through the various reports making changes to formulae as required. Obviously, this has to be done with great care to ensure that the integrity of Exl-Plan is not disrupted. Another approach would be to (i) copy the contents of output reports into empty rows on their respective worksheets using simple cell references (like “=A16”), (ii) copy and paste (use Paste Special … Formats) the original reports’ formatting into the new reports and (iii) make all the desired changes within the copied reports. Although, it requires setting up, this approach may be more expedient in the long run as the underlying Exl-Plan model is not disrupted and changes should be much easier to apply and be more evident.