9 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 9-1 Creating a New Data Load Validation Workbook
The Calendar Selection step appears. Select the weeks you want to examine and click Next.

Figure 9-2 Data Load Validation Wizard: Calendar Selection
The Product Selection step appears. Select the products you want to examine and click Next.

Figure 9-3 Data Load Validation Wizard: Product Selection
The Location Selection step appears. Select the stores you want to examine and click Finish.

Figure 9-4 Data Load Validation Wizard: Location 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 9-5 Bottom Up Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 9-1 Bottom Up Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost.
Wp BOP Inv R	Working Plan Beginning of Period Inventory Retail Value.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan in-season forecast demand units.
Wp Fcst Pre-Season U	Working plan preseason forecast demand units.
Wp EOP Inv C	Working Plan End of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown Perm R	Working plan permanent price markdown for retail.
Wp Markdown Promo R	Working plan promotional price markdown for retail.
Wp Markdown Clr R	Working plan clearance price markdown for retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipt Cost.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working plan shrink retail.
Wp Shrink U	Working plan shrink units.
Wp Sales Reg R	Working Plan Regular Sales Retail Value.
Wp Sales Clr R	Working Plan Clearance Sales Retail Value.
Wp Sales Promo R	Working Plan Promotional Sales Retail Value.
Wp Sales Reg U	Working Plan Regular Sales Units.
Wp Sales Clr U	Working Plan Clearance Sales Units.
Wp Sales Promo U	Working Plan Promotional Sales Units.

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 9-6 Middle Out Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 9-2 Middle Out Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp BOP Inv R	Working Plan Beginning of Period Inventory Retail Value.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan forecast for in-season units.
Wp Fcst Pre-season U	Working plan forecast for preseason units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown Perm R	Working plan permanent markdown value.
Wp Markdown Promo R	Working plan promotional price markdown for retail.
Wp Markdown Clr R	Working plan clearance price markdown for retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working Plan Shrink Retail.
Wp Shrink U	Working Plan Shrink Units.
Wp Sales Reg R	Working plan regular sales retail.
Wp Sales Clr R	Working plan clearance sales retail.
Wp Sales Promo R	Working plan promotional sales retail.
Wp Sales Reg U	Working plan regular sales units.
Wp Sales Clr U	Working plan clearance sales units.
Wp Sales Promo U	Working plan promotional 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 9-7 Top Down Working Plan Worksheet

The following table lists the measures available on this worksheet.

Table 9-3 Top Down Working Plan Worksheet Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp BOP Inv R	Working Plan Beginning of Period Inventory Retail Value.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan in-season forecast units.
Wp Fcst Pre-Season U	Working plan preseason forecast units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown R	Working Plan Markdown Retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working Plan Shrink Retail.
Wp Shrink U	Working Plan Shrink Units.

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 9-8 Misc. Measures Worksheet

The following table lists the measures available on this worksheet.

Table 9-4 Misc Measures Worksheet Measures

Measure	Description
Wp Start Date	Working plan 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).
Ty Clearance BOP Inv C	This Year Clearance Beginning of Period Inventory Cost.
Ty Clearance BOP Inv R	This Year Clearance Beginning of Period Inventory Retail.
Ty Clearance BOP Inv U	This Year Clearance Beginning of Period Inventory Unit.
Ty Regular BOP Inv C	This Year Regular Beginning of Period Inventory Cost.
Ty Regular BOP Inv R	This Year Regular Beginning of Period Inventory Retail Value.
Ty Regular BOP Inv U	This Year Regular Beginning of Period Inventory Units.
Ty Clearance EOP Inv C	This Year Clearance End of Period Inventory Cost.
Ty Clearance EOP Inv R	This Year Clearance End of Period Inventory Retail.
Ty Clearance EOP Inv U	This Year Clearance End of Period Inventory Units.
Ty Regular EOP Inv C	This Year Regular End of Period Inventory Cost.
Ty Regular EOP Inv R	This Year Regular End of Period Inventory Retail Value.
Ty Regular EOP Inv U	This Year Regular End of Period Inventory Units.
Ty Misc In R	This Year Miscellaneous In Retail Value.
Ty Misc In U	This Year Miscellaneous In Units.
Ty Misc Out R	This Year Miscellaneous Out Retail Value.
Ty Misc Out U	This Year Miscellaneous Out Units.
Ty Markdown Perm R	This year's permanent price markdown for retail.
Ty Markdown Promo R	This year's promotional price markdown for retail.
Ty Markdown Clr R	This year's clearance price markdown for retail.
Ty MarkUp R	This Year Markup Retail Value.
Ty On Order C	This Year On Order Cost.
Ty On Order R	This Year On Order Retail.
Ty On Order U	This Year On Order Units.
Ty Receipts C	This Year Receipt Cost.
Ty Receipts R	This Year Receipt Retail Value.
Ty Receipts U	This Year Receipt Units.
Ty Shrink R	This Year Shrink Retail Value.
Ty Shrink U	This Year Shrink Units.
Ty Sales Clr R	This year's clearance sales.
Ty Sales Clr U	This year's clearance sales units.
Ty Sales Promo R	This year's promotional sales.
Ty Sales Promo U	This Year promotional sales units.
Ty Sales Reg R	This year's regular sales.
Ty Sales Reg U	This year's regular sales units.