Spreadsheet: 157263d1337688075-index-match-sumproduct-and-a-dynamic-list-upload
Sheet: Data

Company code | Plant | BC | Customer | Customer Name | Forecast Set | Forecast Subset | P & M Ext. Cust No. | P & M Material | Material Name | Fiscal year/period | Area Bud | Net Sales (Budget) | Energy Surcharge Budget | Net Sales (Incl. ES) Budget
5555 | Branch 1 | 5002 | 1001 | Customer 1 | Forecast 1 | Forecast 1 |  |  |  | Z1/001.2013 | 10 | 0.28 | 0.08 | 0.36
5555 | Branch 1 | 5002 | 1002 | Customer 2 | Forecast 2 | Forecast 2 |  |  |  | Z1/002.2013 | 0.04 | 0.29 | 0.1 | 0.39
5555 | Branch 1 | 5002 | 1003 | Customer 3 | Forecast 3 | Forecast 3 |  |  |  | Z1/003.2013 | 0.04 | 0.27 | 0.09 | 0.36
5555 | Branch 1 | 5002 | 1004 | Customer 4 | Forecast 4 | Forecast 4 |  |  |  | [NAME] | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1005 | Customer 5 | Forecast 5 | Forecast 5 |  |  |  | Z1/005.2013 | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1006 | Customer 6 | Forecast 6 | Forecast 6 |  |  |  | Z1/006.2013 | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1007 | Customer 7 | Forecast 7 | Forecast 7 |  |  |  | Z1/007.2013 | 0.04 | 0.31 | 0.1 | 0.41
5555 | Branch 1 | 5002 | 1008 | Customer 8 | Forecast 8 | Forecast 8 |  |  |  | [NAME] | 0.04 | 0.29 | 0.09 | 0.38
5555 | Branch 1 | 5002 | 1009 | Customer 9 | Forecast 9 | Forecast 9 |  |  |  | Z1/009.2013 | 0.03 | 0.18 | 0.04 | 0.22
5555 | Branch 1 | 5002 | 1010 | Customer 10 | Forecast 10 | Forecast 10 |  |  |  | Z1/010.2013 | 0.04 | 0.27 | 0.08 | 0.35
5555 | Branch 1 | 5002 | 1011 | Customer 11 | Forecast 11 | Forecast 11 |  |  |  | Z1/011.2013 | 0.04 | 0.26 | 0.08 | 0.34
5555 | Branch 1 | 5002 | 1012 | Customer 12 | Forecast 12 | Forecast 12 |  |  |  | Z1/012.2013 | 0.04 | 0.29 | 0.09 | 0.38
5555 | Branch 1 | 5002 | 1013 | Customer 13 | Forecast 13 | Forecast 13 |  |  |  | Z1/001.2013 | 0.11 | 6.78 | 1.03 | 7.81
5555 | Branch 1 | 5002 | 1014 | Customer 14 | Forecast 14 | Forecast 14 |  |  |  | Z1/002.2013 | 0.11 | 7.04 | 1.21 | 8.25
5555 | Branch 1 | 5002 | 1015 | Customer 15 | Forecast 15 | Forecast 15 |  |  |  | Z1/003.2013 | 0.1 | 6.51 | 1.09 | 7.6
5555 | Branch 1 | 5002 | 1016 | Customer 16 | Forecast 16 | Forecast 16 |  |  |  | [NAME] | 0.12 | 7.34 | 1.23 | 8.57
5555 | Branch 1 | 5002 | 1017 | Customer 17 | Forecast 17 | Forecast 17 |  |  |  | Z1/005.2013 | 0.12 | 7.25 | 1.19 | 8.44
5555 | Branch 1 | 5002 | 1018 | Customer 18 | Forecast 18 | Forecast 18 |  |  |  | Z1/006.2013 | 0.12 | 7.3 | 1.19 | 8.49
5555 | Branch 1 | 5002 | 1019 | Customer 19 | Forecast 19 | Forecast 19 |  |  |  | Z1/007.2013 | 0.12 | 7.53 | 1.22 | 8.75
5555 | Branch 1 | 5002 | 1020 | Customer 20 | Forecast 20 | Forecast 20 |  |  |  | [NAME] | 0.11 | 7.19 | 1.13 | 8.32
5555 | Branch 1 | 5002 | 1001 | Customer 1 | Forecast 15 | Forecast 15 |  |  |  | [NAME] | 20 | 0.28 | 0.08 | 0.36
5555 | Branch 1 | 5002 | 1002 | Customer 2 | Forecast 2 | Forecast 2 |  |  |  | Z1/002.2013 | 0.04 | 0.29 | 0.1 | 0.39
5555 | Branch 1 | 5002 | 1003 | Customer 3 | Forecast 13 | Forecast 13 |  |  |  | Z1/003.2013 | 0.04 | 0.27 | 0.09 | 0.36
5555 | Branch 1 | 5002 | 1004 | Customer 4 | Forecast 14 | Forecast 14 |  |  |  | [NAME] | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1005 | Customer 5 | Forecast 5 | Forecast 5 |  |  |  | Z1/005.2013 | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1006 | Customer 6 | Forecast 1 | Forecast 1 |  |  |  | Z1/006.2013 | 0.04 | 0.3 | 0.1 | 0.4
5555 | Branch 1 | 5002 | 1007 | Customer 7 | Forecast 7 | Forecast 7 |  |  |  | Z1/007.2013 | 0.04 | 0.31 | 0.1 | 0.41
5555 | Branch 1 | 5002 | 1008 | Customer 8 | Forecast 3 | Forecast 3 |  |  |  | [NAME] | 0.04 | 0.29 | 0.09 | 0.38
5555 | Branch 1 | 5002 | 1009 | Customer 9 | Forecast 4 | Forecast 4 |  |  |  | Z1/009.2013 | 0.03 | 0.18 | 0.04 | 0.22
5555 | Branch 1 | 5002 | 1010 | Customer 10 | Forecast 7 | Forecast 7 |  |  |  | Z1/010.2013 | 0.04 | 0.27 | 0.08 | 0.35
5555 | Branch 1 | 5002 | 1011 | Customer 11 | Forecast 17 | Forecast 17 |  |  |  | Z1/011.2013 | 0.04 | 0.26 | 0.08 | 0.34
5555 | Branch 1 | 5002 | 1012 | Customer 12 | Forecast 8 | Forecast 8 |  |  |  | Z1/012.2013 | 0.04 | 0.29 | 0.09 | 0.38
5555 | Branch 1 | 5002 | 1013 | Customer 13 | Forecast 19 | Forecast 19 |  |  |  | Z1/001.2013 | 0.11 | 6.78 | 1.03 | 7.81
5555 | Branch 1 | 5002 | 1014 | Customer 14 | Forecast 3 | Forecast 3 |  |  |  | Z1/002.2013 | 0.11 | 7.04 | 1.21 | 8.25
5555 | Branch 1 | 5002 | 1015 | Customer 15 | Forecast 4 | Forecast 4 |  |  |  | Z1/003.2013 | 0.1 | 6.51 | 1.09 | 7.6
5555 | Branch 1 | 5002 | 1016 | Customer 16 | Forecast 16 | Forecast 16 |  |  |  | [NAME] | 0.12 | 7.34 | 1.23 | 8.57
5555 | Branch 1 | 5002 | 1017 | Customer 17 | Forecast 17 | Forecast 17 |  |  |  | Z1/005.2013 | 0.12 | 7.25 | 1.19 | 8.44
5555 | Branch 1 | 5002 | 1018 | Customer 18 | Forecast 1 | Forecast 1 |  |  |  | Z1/006.2013 | 0.12 | 7.3 | 1.19 | 8.49
5555 | Branch 1 | 5002 | 1019 | Customer 19 | Forecast 5 | Forecast 5 |  |  |  | Z1/007.2013 | 0.12 | 7.53 | 1.22 | 8.75
5555 | Branch 1 | 5002 | 1020 | Customer 20 | Forecast 9 | Forecast 9 |  |  |  | [NAME] | 0.11 | 7.19 | 1.13 | 8.32