10 Data Load Validation Workbook

The Data Validation workbook contains all measures that are either loaded or touched during the batch calculation process. This template is used by the administrator only to verify the results of data loads and batch processes.

The Data Load Validation workbook contains the following tabs:

Bottom Up Working Plan Tab
Middle Out Working Plan Tab
Top Down Working Plan Tab
Miscellaneous Measures Tab

Data Load Validation Wizard

To open a Data Load Validation workbook:

Select New from the File menu, or click the New button in the toolbar.
On the Planning Admin tab, select Data Load Validation and click OK.

Figure 10-1 Creating a New Data Load Validation Workbook
The Calendar Selection step appears. Select the weeks you want to examine and click Next.

Figure 10-2 Data Load Validation Wizard: Calendar Selection
The Location Selection step appears. Select the channels you want to examine and click Finish.

Figure 10-3 Data Load Validation Wizard: Location Selection
The Product Selection step appears. Select the products you want to examine and click Next.

Figure 10-4 Data Load Validation Wizard: Product Selection

The Data Load Validation workbook is built.

Bottom Up Working Plan Tab

The Bottom Up Working Plan Tab has one worksheet, Bottom Up Working Plan.

Bottom Up Working Plan Worksheet

Use the Bottom Up Working Plan worksheet to validate that the subclass data was updated in the batch process. Note that this worksheet is read-only.

Figure 10-5 Bottom Up Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 10-1 Bottom Up Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipt Cost.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink C	Working plan shrink Cost.
Wp Shrink U	Working plan shrink units.
Wp Sales C	Working Plan Regular Sales Cost Value.
Wp Sales U	Working Plan Clearance Sales Unit Value.

Middle Out Working Plan Tab

The Middle Out Working Plan tab has one worksheet, Middle Out Working Plan.

Middle Out Working Plan Worksheet

Use the Middle Out Working Plan worksheet to validate that the department data was updated in the batch process. Note that this worksheet is read-only.

Figure 10-6 Middle Out Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 10-2 Middle Out Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink C	Working Plan Shrink Cost.
Wp Shrink U	Working Plan Shrink Units.
Wp Sales C	Working Plan Sales Cost.
Wp Sales U	Working Plan Sales Units.

Top Down Working Plan Tab

The Top Down Working Plan tab has one worksheet, Top Down Working Plan.

Top Down Working Plan Worksheet

Use the Top Down Working Plan worksheet to validate that the division-group data was updated in the batch process. Note that this worksheet is read-only.

Figure 10-7 Top Down Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 10-3 Top Down Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp On Order C	Working Plan On Order Cost Value.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Shrink C	Working Plan Shrink Cost.
Wp Sales C	Working Plan Sales Cost.

Miscellaneous Measures Tab

The Misc. Measures tab has one worksheet, Misc. Measures.

Miscellaneous Measures Worksheet

Use the Misc. Measures worksheet to validate that the measures were loaded in the batch process. Note that this worksheet is read-only.

Figure 10-8 Misc. Measures Worksheet

The following table lists the measures available on this worksheet.

Table 10-4 Misc Measures Worksheet Measures

Measure	Description
Wp Forecast Start Date	Working plan forecast start date.
Wp BOP Unelapsed	Bottom up working plan beginning of period unelapsed (time).
Wp Unelapsed	Bottom up working plan unelapsed (time).
Wp BOP Unelapsed	Middle out working plan beginning of period unelapsed (time).
Wp Unelapsed	Middle out working plan unelapsed (time).
Wp BOP Unelapsed	Top down working plan beginning of period unelapsed (time).
Wp BOP Unelapsed	Top down working plan unelapsed (time).