Product ProdName Store Date Reference
1 Hammer A 1/11/2021 1-AX-JFY
1 Hammer F 3/12/2021 1-FY-DJY
2 Nail B 5/13/2021 2-BZ-SJY
2 Nail G 8/14/2021 2-GX-MJY
3 Screwdriver C 1/15/2022 3-CY-JFY
3 Screwdriver A 2/16/2022 3-AZ-DJY
4 Ladder D 4/17/2022 4-DX-SJY
4 Ladder I 8/18/2022 4-IY-MJY
5 Drill E 9/19/2022 5-EZ-JFY
5 Drill J 12/20/2022 5-JX-DJY
1 Hammer F 3/12/2021 1-FY-DJY
3 Screwdriver A 2/16/2022 3-AZ-DJY
5 Drill E 9/19/2022 5-EZ-JFY
5 Drill J 12/20/2022 5-JX-DJY
Product ProdName Store Date Reference StoreRef RefCode
1 Hammer A 1/11/2021 1-AX-JFY AX JFY
1 Hammer F 3/12/2021 1-FY-DJY FY DJY
2 Nail B 5/13/2021 2-BZ-SJY BZ SJY
2 Nail G 8/14/2021 2-GX-MJY GX MJY
3 Screwdriver C 1/15/2022 3-CY-JFY CY JFY
3 Screwdriver A 2/16/2022 3-AZ-DJY AZ DJY
4 Ladder D 4/17/2022 4-DX-SJY DX SJY
4 Ladder I 8/18/2022 4-IY-MJY IY MJY
5 Drill E 9/19/2022 5-EZ-JFY EZ JFY
5 Drill J 12/20/2022 5-JX-DJY JX DJY
Concat Prod Trim Substitute Sub
Len Left Right Mid
Product ProdName Store Date Reference StoreRef RefCode
1 Hammer A 1/11/2021 1-AX-JFY AX JFY
1 Hammer F 3/12/2021 1-FY-DJY FY DJY
2 Nail B 5/13/2021 2-BZ-SJY BZ SJY
2 Nail G 8/14/2021 2-GX-MJY GX MJY
3 Screwdriver C 1/15/2022 3-CY-JFY CY JFY
3 Screwdriver A 2/16/2022 3-AZ-DJY AZ DJY
4 Ladder D 4/17/2022 4-DX-SJY DX SJY
4 Ladder I 8/18/2022 4-IY-MJY IY MJY
5 Drill E 9/19/2022 5-EZ-JFY EZ JFY
5 Drill J 12/20/2022 5-JX-DJY JX DJY
12/31/1899
Subtract Dates Datedif Year Month eomonth
YearFrac
Weekday Day of Week
Reference Product Store Volume Profit District Region
1-AX-JFY 1A 34 1170.96
1-FY-DJY 1E 28 695.52
2-BZ-SJY 2B 39 999.57
2-GX-MJY 2C 0 3748.68
3-CY-JFY 3C 43 1698.07
3-AZ-DJY 3A 78 139.62
4-DX-SJY 4D 60 1879.8
4-IY-MJY 4D 80 2828.8
5-EZ-JFY 5F 91 861.77
5-JX-DJY 5E 70 1101.1
Lookup Table
Store Lookup District Region
A D1 North
B D1 North
C D2 South
D D3 West
E D3 East
1 2 3
Reference Product Store Volume Profit District Region
1-AX-JFY 1A 34 1170.96 D1 North
1-FY-DJY 1E 28 695.52 D3 East
2-BZ-SJY 2B 39 999.57 D1 North
2-GX-MJY 2C 0 3748.68 D2 South
3-CY-JFY 3C 43 1698.07 D2 South
3-AZ-DJY 3A 78 139.62 D1 North
4-DX-SJY 4D 60 1879.8 D3 West
4-IY-MJY 4D 80 2828.8 D3 West
5-EZ-JFY 5F 91 861.77 #N/A #N/A
5-JX-DJY 5E 70 1101.1 D3 East
Row
District
Region
City
Region Lookup Table
Store Lookup District Region
A D1 North
B D1 North
C D2 South
D D3 West
E D3 East
1 2 3
Reference Product Store Volume Profit District Region
1-AX-JFY 1A 34 1170.96 D1 North
1-FY-DJY 1E 28 695.52 D3 East
2-BZ-SJY 2B 39 999.57 D1 North
2-GX-MJY 2C 0 3748.68 D2 South
3-CY-JFY 3C 43 1698.07 D2 South
3-AZ-DJY 3A 78 139.62 D1 North
4-DX-SJY 4D 60 1879.8 D3 West
4-IY-MJY 4D 80 2828.8 D3 West
5-EZ-JFY 5F 91 861.77 #N/A #N/A
5-JX-DJY 5E 70 1101.1 D3 East
Region Store - Match Region Lookup Table
North Store Lookup District Region
East A D1 North
North B D1 North
South C D2 South
South D D3 West
North E D3 East
West 1 2 3
West
#N/A
East
1 2 3
1
2
3
4
5
6
Reference Product Store Volume Profit Price District
1-AX-JFY 1A 34 1170.96 D1
1-FY-DJY 1E 28 695.52 D3
2-BZ-SJY 2B 39 999.57 D1
2-GX-MJY 2C 0 3748.68 D2
3-CY-JFY 3C 43 1698.07 D2
3-AZ-DJY 3A 78 139.62 D1
4-DX-SJY 4D 60 1879.8 D3
4-IY-MJY 4D 80 2828.8 D3
5-EZ-JFY 5F 91 861.77 #N/A
5-JX-DJY 5E 70 1101.1 D3
Region Region Store-Match Region Lookup Table
North North 1 North Store Lookup District Region
East East 5 East A D1 North
North North 2 North B D1 North
South South 3 South C D2 South
South South 3 South D D3 West
North North 1 North E D3 East
West West 4 West 1 2 3
West West 4 West
#N/A #N/A #N/A #N/A
East East 5 East
