Spreadsheet: 147709d1332940259-help-with-circular-reference-book2-excel-help
Sheet: KA

 | Dimension | Member
 | Brand -->
 | Customer --> |  |  |  |  |  |  |  | GSV Share
 | Account manager --> |  |  |  |  |  |  |  | Unit Share
 | Channel --> |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario |  | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | Fiscal year --> |  | 250 | 250 | 330 | 355 | 473
 |  |  | 60 ML | 250 ML | 330 ML | 355 ML | 473 ML | Totaal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Indirect Volume | SU | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indirect Volume | SU | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
 | Financial Sales Units | SU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial Sales Units | SU | 0
 | Financial Sales Units | EA | 42624.85526228805 | 8481553.642971298 | 281776.8987560938 | 735548.8065774594 | 154143.4413325625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial Sales Units | EA | 0 | 42625.8552622881 | 42626.8552622881 | 42627.8552622881 | 42628.8552622881 | 42629.8552622881 | 42630.8552622881 | 42631.8552622881 | 42632.8552622881 | 42633.8552622881 | 42634.8552622881 | 42635.8552622881
 | Financial Sales Units Promoted | EA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial Sales Units Promoted | EA
 | Unconditional Free Goods Trade Units | EA | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unconditional Free Goods Trade Units | EA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Financial Sales Units Regular | EA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial Sales Units Regular | EA
 | GSV per unit | EUR |  |  |  | 1.3312 | 1.77424 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSV per unit | EUR
 | GSV | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSV | EUR
 | GSV Excluding FGT unconditional | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSV Excluding FGT unconditional | EUR
 | List price reduction Promo | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List price reduction Promo | EUR
 | List price reduction | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List price reduction | EUR
 | Free Goods Trade Uncond | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Free Goods Trade Uncond | EUR
 | Financial | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial | EUR
 | Logistical | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Logistical | EUR
 | 1N (Trade net price) | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1N (Trade net price) | EUR
 | Net Price reduction | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Price reduction | EUR
 | 3rd party allocations | EUR | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd party allocations | EUR | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Financial | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Financial | EUR
 | Logistical | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Logistical | EUR
 | 2N (Exposure) | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2N (Exposure) | EUR
 | Main placement | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Main placement | EUR
 | Add placement - Ambient | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add placement - Ambient | EUR
 | Add placement - Cooler | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add placement - Cooler | EUR
 | Temporary promotion | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Temporary promotion | EUR
 | Temp. price reduction | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Temp. price reduction | EUR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Advertising | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Advertising | EUR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Target reach incentive | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target reach incentive | EUR
 | Data sharing | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data sharing | EUR
 | 3N (Customer Prof.) | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3N (Customer Prof.) | EUR
 | Depreciation | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation | EUR
 | Product Displays | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Displays | EUR
 | POS Materials | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POS Materials | EUR
 | 4N (Customer Prof. Incl non cpm costs) | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4N (Customer Prof. Incl non cpm costs) | EUR
 | Total Trade Spend Unconditional | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Trade Spend Unconditional | EUR
 | Total Trade Spend Conditional | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Trade Spend Conditional | EUR
 | Total Trade Spend | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Trade Spend | EUR
 | Permanent Discount | EUR |  |  |  |  |  |  | 1
 | Joint Advertising | EUR |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | Check
 |  |  | 60 ML | 250 ML | 330 ML | 355 ML | 473 ML
 | GSV per SU | Ratio per SU
 | 1N per SU | Ratio per SU
 | 2N per SU | Ratio per SU
 | 3N per SU | Ratio per SU
 |  |  | 60 ML | 250 ML | 330 ML | 355 ML | 473 ML
 | 1n per SU ex promo | Ratio per SU
 | 2n per SU ex promo | Ratio per SU
 | 3n per SU ex promo | Ratio per SU
 |  |  | 60 ML | 250 ML | 330 ML | 355 ML | 473 ML
 | 0n per EA ex promo | Ratio per EA |  |  |  |  |  | N/A
 | 1n per EA ex promo | Ratio per EA |  |  |  |  |  | N/A
 | Basic rate |  | N/A | N/A | N/A | N/A | N/A
 | Advance rate |  | N/A | N/A | N/A | N/A | N/A
 | 0N -> 1N
 | Unconditional on invoice - 0N --> 1N |  |  |  |  |  |  |  |  |  |  |  |  |  | GSV/Units |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Description | Bucket | Filling /packing size | Type | Condition | Base | Start date | End date | Volume / Sales | Volume / Sales | Total | Agr no # | FS KEY | [NAME] | Vol Key | Start month | End month | Target month |  |  |  |  | 0N --> 1N | Driver | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
 | Test | Logistical | All filling sizes | % per can | 0.0125 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 0 |  | A-00025888
 | Test | List price reduction | Single Cans | Ct per can | 0.05 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 150000 |  | 0
 | Test | List price reduction | Single Cans | Ct per can | 0.05 |  | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 |  | 150000 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  | 0
 | Totaal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
 | Unconditional off ivoice - 1N --> 2N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Description | Bucket | Filling /packing size | Type | Condition | Base | Start date | End date | Volume / Sales | Volume / Sales | Total | Agr no # | FS KEY | [NAME] | Vol Key | LS/VR | Value | Start month | End month | Target month |  |  | 1N --> 2N | Driver | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
 | Test | Financial | Pet can | % per can | 0.02 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 100000 |  | 20003456
 | Test | Net price reduction | 330 ml | % per can |  |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 200000 |  | 20017265
 | Test | Logistical | 250 ml | ct per can |  |  | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 |  | 0
 | Test | Logistical | 250 ml | ct per can |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
 | Totaal
 | Conditional off ivoice - 2N --> 3N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Description | Bucket | Filling /packing size | Type | Condition | Base | Start date | End date | Volume / Sales | Volume / Sales | Total | Agr no # | FS KEY | [NAME] | Vol Key | LS/VR | Value | Start month | End month | Target month |  |  | 2N --> 3N | Driver | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
 | Test | Main placement | 250 ml | % per can | 0.05 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 0 |  | 20017265
 | Test | Add placement - Ambient | 2 Pack | % per can | 0.06 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 25000 |  | 20017265
 | ----------- | Target reach incentive | 60 ml | % per can | 0.06 |  | 2012-02-01 00:00:00 | 2012-12-31 00:00:00 |  | 0
 | ----------- | Data sharing | 330 ml | % per can | 0.06 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 0
 | ----------- | Add placement - Cooler | 250 ml | LS | 100000 |  | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
 | Totaal
 | Promotion plan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Description | On/Off invoice | Bucket | Filling /packing size | Type | Condition | Base | Start date | End date | Volume / Sales | Total | Agr no # |  | FS KEY | [NAME] | Vol Key | LS/VR | Value | Start month | End month | Target month |  | Promotion plan | Driver | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY
 | Promo 1 Week 13 | Off invoice |  | 355 ml | ct per can | 0.125 |  | 2012-04-29 00:00:00 | 2012-05-13 00:00:00 | 250000 |  | 20017265
 | Promo 1 Week 13 Folder | Advertising |  | 473 ml | LS | 10000 |  | 2012-04-29 00:00:00 | 2012-05-13 00:00:00 | 0 |  | 20017265
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0
 | ----------- |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
 | Totaal
 |  | Bucket | Filling size | Type | Filling size Key | Base | [NAME] | Volume Key
 |  | List price reduction | 60 ml | % per can | 1 | GSV | 1 | 1
 |  | Logistical | 250 ml | Ct per can | 2 | Units | 2 | 1
 |  |  | 330 ml |  | 3 |  |  | 1
 |  |  | 355 ml |  | 4 |  |  | 1
 |  |  | 473 ml |  | 5 |  |  | 1
 |  |  | All filling sizes |  | 6 |  |  | 1
 |  |  | Chilled can |  | 2 |  |  | 0
 |  |  | Pet can |  | 2 |  |  | 0
 |  |  | 2 Pack |  | 2 |  |  | 0
 |  |  | 4 Pack |  | 2 |  |  | 0
 |  |  | 6 Pack |  | 2 |  |  | 0
 |  |  | 8 Pack |  | 2 |  |  | 0
 |  |  | 12 Pack |  | 2 |  |  | 0
 |  |  | Single Cans |  | 2
 |  | Bucket | Filling size | Type | Filling size Key | Base | [NAME] | Volume Key
 |  | Financial | 60 ml | % per can | 1 | NSV | 1 | 1
 |  | Logistical | 250 ml | % per can | 2 | NSV - Fin % | 2 | 1
 |  | Net price reduction | 330 ml | ct per can | 3 | Units | 3 | 1
 |  |  | 355 ml | LS | 4 |  |  | 1
 |  |  | 473 ml |  | 5 |  |  | 1
 |  |  | All filling sizes |  | 6 |  |  | 1
 |  |  | Chilled can |  | 2 |  |  | 0
 |  |  | Pet can |  | 2 |  |  | 0
 |  |  | 2 Pack |  | 2 |  |  | 0
 |  |  | 4 Pack |  | 2 |  |  | 0
 |  |  | 6 Pack |  | 2 |  |  | 0
 |  |  | 8 Pack |  | 2 |  |  | 0
 |  |  | 12 Pack |  | 2 |  |  | 0
 |  | Bucket | Filling size | Type | Filling size Key | Base | [NAME] | Volume Key
 |  | Main placement | 60 ml | % per can | 1 | NSV | 1 | 1
 |  | Add placement - Ambient | 250 ml | % per can | 2 | NSV - Fin % | 1 | 1
 |  | Add placement - Cooler | 330 ml | ct per can | 3 | Units | 3 | 1
 |  | Target reach incentive | 355 ml | LS | 4 | LS | 4 | 1
 |  | Data sharing | 473 ml |  | 5 |  |  | 1
 |  |  | All filling sizes |  | 6 |  |  | 1
 |  |  | Chilled can |  | 2 |  |  | 0
 |  |  | Pet can |  | 2 |  |  | 0
 |  |  | 2 Pack |  | 2 |  |  | 0
 |  |  | 4 Pack |  | 2 |  |  | 0
 |  |  | 6 Pack |  | 2 |  |  | 0
 |  |  | 8 Pack |  | 2 |  |  | 0
 |  |  | 12 Pack |  | 2 |  |  | 0
 | Type | Bucket | Filling size | Type | Filling size Key | Base | [NAME] | Volume Key
 | On invoice | List price reduction Promo | 60 ml | % per can | 1 | NSV | 1 | 1
 | Off invoice | Temp. price reduction | 250 ml | ct per can | 2 | Units | 1 | 1
 | Advertising | Advertising | 330 ml | LS | 3 | LS | 3 | 1
 |  |  | 355 ml |  | 4 |  | 4 | 1
 |  |  | 473 ml |  | 5 |  |  | 1
 |  |  | All filling sizes |  | 6 |  |  | 1
 |  |  | Chilled can |  | 2 |  |  | 0
 |  |  | Pet can |  | 2 |  |  | 0
 |  |  | 2 Pack |  | 2 |  |  | 0
 |  |  | 4 Pack |  | 2 |  |  | 0
 |  |  | 6 Pack |  | 2 |  |  | 0
 |  |  | 8 Pack |  | 2 |  |  | 0
 |  |  | 12 Pack |  | 2 |  |  | 0
 |  | Account plan | ct per can | Permanent discount | OK | 1
 |  | Account plan | % per can | Permanent discount | OK | 1
 |  | Account plan | LS | Joint Advertising | OK | 2
 |  | Promotional plan | ct per can | Joint Advertising | OK | 2
 |  | Promotional plan | % per can | Joint Advertising | OK | 2
 |  | Promotional plan | LS | Joint Advertising | OK | 2