When an EWS schedule is open, the Financial Consolidation schedule and local modeling enhancements are “merged”.

For example, you have made local modeling enhancements, adding line item details in order to analyze product sales by salesperson. However, your administrator has deleted some of these products from the Financial Consolidation schedule.

Following on from the example above, you save the package.

As a result:

• A second sheet entitled Previous Version is added to the workbook. It displays the schedule in its previous state and highlights the deleted rows using red arrows.

• A local Excel file is automatically created in the EWS folder. It contains a merge report and displays how the schedule appeared before the rows were deleted. This file has the title <[numeric ID]>_R.xls.

The copy of the schedule that can be used to generate a new merge report (if necessary) is also saved in a local Excel file called <[numerical ID]>_C.xls. If this file is deleted, the application will not be able to generate a merge report the next time you open the schedule. A message will tell the user that the local modeling has been lost.