2 Week Mapping

The Week Mapping workbook is used only by the administrator to adjust historical sales to accommodate calendar shifts. The adjusted sales then appear in the Item Planning workbook 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 Week Mapping workbook contains one tab: Week Mapping Tab.

Building the Week Mapping Workbook

To build a Week Mapping workbook:

1. Click the New icon in the toolbar.

2. The New Workbook dialog box appears. On the Item Planning Administration tab, select Week Mapping and click OK.

   Figure 2-1 New Workbook Dialog Box

   
   

3. The Week Mapping wizard appears at the calendar step. Select the weeks you want to map and click Finish.

   Figure 2-2 Week Mapping Wizard

   
   

The workbook is built.

Week Mapping Tab

This tab contains a single worksheet called Set LY Mappings.

Set LY Mappings Worksheet

Use this worksheet to 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-3 Set LY Mappings Worksheet

Table 2-1 Set LY Mappings 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.

Next Steps

After you have mapped the weeks, build the Reference Curves workbook to create reference curves.