Users with knowledge of Excel and Excel VBA programming may wish to customise the VOLUMES and ANNUAL SUMS utilities.
Within the Control sheets of these applications, cell positions must not be changed (e.g. by adding or removing rows) as this will stop the application from working correctly. The same applies to the Volume Input sheet in the VOLUMES application and the Annual Sums and the Comparisons sheets in the ANNUAL SUMS application. The “Output” sheets in the VOLUMES application are locked and cannot be modified.
New sheets can be added without any limitation, but you must not change the names of any existing sheets. Copying of “Output” sheets in the VOLUMES application is allowed. New sheets that refer to data in these sheets and the Annual Sums and the Comparisons sheets in the ANNUAL SUMS application may be added.
Using VBA programming, significant changes could be made to the application, such as customisation of output. This requires some knowledge of VBA programming.