Spreadsheet: 123306d1317546375-budget-v-spend-pivot-table-can-this-be-automated-marketing-budgets-working-test-file-v4
Sheet: Pivot_Table

Sum of Cost | Column Labels
Row Labels | Artwork | Board - Std | Business Magazine | EACH | Echo | Estates [NAME] | IAS/OAS | In-House | Local Agents | [NAME] | Occupier | Property Week | SCPR Lineage | Key Copying | Design | Board - Spl | NovaLoca | Aerial Photo | Grand Total
Acorn Business Centre, Unit 9, Portsmouth |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Ameiva Point, Portsmouth |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Anchorage Park, Portsmouth | -175 |  |  |  |  |  |  |  |  |  |  | -500 |  |  |  |  |  |  | -675
Spend | -175 |  |  |  |  |  |  |  |  |  |  | -500 |  |  |  |  |  |  | -675
Apex House, Gosport |  |  | -62.5 |  |  |  |  |  |  |  | -828 |  |  |  |  |  |  |  | -890.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  | -828 |  |  |  |  |  |  |  | -890.5
Chancerygate Business Centre, Southampton |  |  |  |  | -150 |  |  |  |  |  | -250.8 |  |  |  |  |  |  |  | -400.8
Spend |  |  |  |  | -150 |  |  |  |  |  | -250.8 |  |  |  |  |  |  |  | -400.8
[NAME], Unit 5, Segensworth |  |  | -62.5 |  |  |  |  |  | 0 | -30 |  |  |  |  |  |  |  |  | -92.5
Spend |  |  | -62.5 |  |  |  |  |  | 0 | -30 |  |  |  |  |  |  |  |  | -92.5
Fusion, Solent Business Park |  |  |  |  |  |  |  |  |  |  | -479.75 |  |  |  |  |  |  |  | -479.75
Spend |  |  |  |  |  |  |  |  |  |  | -479.75 |  |  |  |  |  |  |  | -479.75
Griffin Industrial Estate, Totton |  |  |  |  | -100 |  |  |  |  | -60 |  |  |  |  |  |  |  |  | -160
Spend |  |  |  |  | -100 |  |  |  |  | -60 |  |  |  |  |  |  |  |  | -160
H&CA Investment Disposal |  |  |  |  |  | -1960 |  |  |  |  |  |  |  |  |  |  |  |  | -1960
Spend |  |  |  |  |  | -1960 |  |  |  |  |  |  |  |  |  |  |  |  | -1960
[NAME], Unit C, Hedge End |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Spend |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
HBS House, Southampton |  | 125 |  |  |  |  |  | 0 | 0 | 84 |  |  | 44 |  |  |  |  |  | 253
Budget |  | 125 |  |  |  |  |  | 0 | 0 | 84 |  |  | 44 |  |  |  |  |  | 253
Highgrove Industrial Estate, Portsmouth |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Lower [NAME], Units 1&2, Southampton |  |  |  |  |  |  |  |  |  | -30 | -25.65 |  |  |  |  |  |  |  | -55.65
Spend |  |  |  |  |  |  |  |  |  | -30 | -25.65 |  |  |  |  |  |  |  | -55.65
Luxor Court, Unit 6, Havant |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Manor Court, 8-12, Segensworth |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Marchwood Industrial Estate, Unit 1A.2 |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Spend |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Meon House, Segensworth |  |  | 125 | 95 |  |  | 0 |  | 0 | 30 | 200 |  | 44 |  | 88 | 330 | 50 | -450 | 512
Budget |  |  | 125 | 95 |  |  | 0 |  | 0 | 30 | 200 |  | 44 |  | 88 | 330 | 50 |  | 962
Spend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -450 | -450
[NAME], Unit 9, Nurlsing |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Spend |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
[NAME], Unit 13, Eastleigh |  | 140 |  |  | 185 |  | 0 | 0 | 0 | 44 | 300 |  |  | 25 |  |  |  |  | 694
Budget |  | 140 |  |  | 185 |  | 0 | 0 | 0 | 44 | 300 |  |  | 25 |  |  |  |  | 694
Poole Trade Park, Poole |  |  |  |  |  |  |  |  |  |  | -431.3 |  |  |  |  |  |  |  | -431.3
Spend |  |  |  |  |  |  |  |  |  |  | -431.3 |  |  |  |  |  |  |  | -431.3
Portfield Trade Park, Portsmouth |  |  |  |  |  |  |  |  |  |  | -431.3 |  |  |  |  |  |  |  | -431.3
Spend |  |  |  |  |  |  |  |  |  |  | -431.3 |  |  |  |  |  |  |  | -431.3
Southampton Trade Park, Southampton |  |  |  |  | -100 |  |  |  |  | -60 | -431.3 |  |  |  |  |  |  |  | -591.3
Spend |  |  |  |  | -100 |  |  |  |  | -60 | -431.3 |  |  |  |  |  |  |  | -591.3
[NAME], Unit 3, Eastleigh |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Spend |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Swanwick Business Centre, Unit 8, Swanwick |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
Spend |  |  |  |  |  |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -30
The Briars, Waterlooville |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Spend |  |  | -62.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62.5
Vista Park, Unit 110, Nursling |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
Spend |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
Vista Park, Unit 210, Nursling |  |  |  |  |  |  |  |  |  |  | -950 |  |  |  |  |  |  |  | -950
Spend |  |  |  |  |  |  |  |  |  |  | -950 |  |  |  |  |  |  |  | -950
Wykeham Trade Park, Units 4 & C, Winchester |  |  |  |  | -100 |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -130
Spend |  |  |  |  | -100 |  |  |  |  | -30 |  |  |  |  |  |  |  |  | -130
Grand Total | -175 | 265 | -375 | 95 | -265 | -1960 | 0 | 0 | 0 | -202 | -3328.1 | -500 | 88 | 25 | 88 | 330 | 50 | -450 | -6314.1