2 Mapping Setup Workbook

The Mapping Setup workbook is used by the administrator to map weeks for last year and adjusted last year.

The last year mapping is used to identify which week to map and when to map, determining the last year values in a workbook. The adjusted last year is used to adjust historical sales to accommodate calendar shifts.

The adjusted sales then appear in the Merchandise Planning workbook templates for reference while planning. This functionality is helpful when events shift from one week to another or when there are different numbers of weeks from one calendar year to another.

The Mapping Setup workbook contains the following tab:

• Mapping Tab

Mapping Setup Wizard

To open a Mapping Setup workbook:

1. Select New from the File menu, or click the New button in the toolbar.

2. On the Planning Admin tab, select Mapping Setup and click OK.

   Figure 2-1 Creating a New Mapping Setup Workbook

   
   

The Mapping Setup workbook is built.

Mapping Tab

The Mapping tab has one worksheet, the Mapping worksheet.

Mapping Worksheet

Within this worksheet, you can set the mappings for last year and adjusted last year.

The week indicated in the Adj LY Lag measure is where the performance data is retrieved when you look at Ly data.

Figure 2-2 Mapping Worksheet

The following table lists the measures available on this worksheet.

Table 2-1 Mapping Worksheet Measures

Measure	Description
Ly Lag	Identifies the week used for mapping as last year.
Adj LY Lag	Identifies the week used for mapping as adjusted last year.