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

Property | Type | Category | Sub-Category | Cost | Budget Approved | Spend Date | Budget Date
Meon House, Segensworth | Budget | Brochure | Design | 88 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Boards | Board - Spl | 330 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Emailing | Local Agents | 0 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Emailing | IAS/OAS | 0 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Mailing | EACH | 95 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Emailing | Occupier | 200 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Advertising | SCPR Lineage | 44 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Advertising | Business Magazine | 125 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Advertising | [NAME] | 30 | Y |  | 2011-12-31 00:00:00
Meon House, Segensworth | Budget | Internet | NovaLoca | 50 | Y |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Brochure | In-House | 0 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Boards | Board - Std | 140 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Emailing | Local Agents | 0 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Mailing | Occupier | 300 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Emailing | IAS/OAS | 0 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Advertising | [NAME] | 44 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Advertising | Echo | 185 | N |  | 2011-12-31 00:00:00
[NAME], Unit 13, Eastleigh | Budget | Other | Key Copying | 25 | N |  | 2011-12-31 00:00:00
HBS House, Southampton | Budget | Brochure | In-House | 0 | N |  | 2011-12-31 00:00:00
HBS House, Southampton | Budget | Boards | Board - Std | 125 | N |  | 2011-12-31 00:00:00
HBS House, Southampton | Budget | Emailing | Local Agents | 0 | N |  | 2011-12-31 00:00:00
HBS House, Southampton | Budget | Advertising | [NAME] | 84 | N |  | 2011-12-31 00:00:00
HBS House, Southampton | Budget | Advertising | SCPR Lineage | 44 | N |  | 2011-12-31 00:00:00
[NAME], Unit 5, Segensworth | Spend | Emailing | Local Agents | 0 |  | 2011-07-01 00:00:00
Acorn Business Centre, Unit 9, Portsmouth | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Ameiva Point, Portsmouth | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Manor Court, 8-12, Segensworth | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
The Briars, Waterlooville | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Luxor Court, Unit 6, Havant | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Highgrove Industrial Estate, Portsmouth | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
[NAME], Unit 5, Segensworth | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Apex House, Gosport | Spend | Advertising | Business Magazine | -62.5 |  | 2011-07-05 00:00:00
Griffin Industrial Estate, Totton | Spend | Advertising | Echo | -100 |  | 2011-07-13 00:00:00
Apex House, Gosport | Spend | Mailing | Occupier | -828 |  | 2011-07-13 00:00:00
Southampton Trade Park, Southampton | Spend | Advertising | Echo | -100 |  | 2011-07-14 00:00:00
Wykeham Trade Park, Units 4 & C, Winchester | Spend | Advertising | Echo | -100 |  | 2011-07-14 00:00:00
Swanwick Business Centre, Unit 8, Swanwick | Spend | Advertising | [NAME] | -30 |  | 2011-07-14 00:00:00
Griffin Industrial Estate, Totton | Spend | Advertising | [NAME] | -30 |  | 2011-07-14 00:00:00
Wykeham Trade Park, Units 4 & C, Winchester | Spend | Advertising | [NAME] | -30 |  | 2011-07-14 00:00:00
Southampton Trade Park, Southampton | Spend | Advertising | [NAME] | -30 |  | 2011-07-14 00:00:00
Chancerygate Business Centre, Southampton | Spend | Mailing | Occupier | -250.8 |  | 2011-07-14 00:00:00
Chancerygate Business Centre, Southampton | Spend | Advertising | Echo | -150 |  | 2011-07-14 00:00:00
Vista Park, Unit 210, Nursling | Spend | Mailing | Occupier | -950 |  | 2011-07-23 00:00:00
[NAME], Unit 9, Nurlsing | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
[NAME], Unit C, Hedge End | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
[NAME], Unit 5, Segensworth | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
Southampton Trade Park, Southampton | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
Marchwood Industrial Estate, Unit 1A.2 | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
[NAME], Unit 3, Eastleigh | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
Griffin Industrial Estate, Totton | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
Lower [NAME], Units 1&2, Southampton | Spend | Advertising | [NAME] | -30 |  | 2011-07-23 00:00:00
Fusion, Solent Business Park | Spend | Mailing | Occupier | -479.75 |  | 2011-08-01 00:00:00
Lower [NAME], Units 1&2, Southampton | Spend | Mailing | Occupier | -25.65 |  | 2011-08-15 00:00:00
Portfield Trade Park, Portsmouth | Spend | Mailing | Occupier | -431.3 |  | 2011-08-25 00:00:00
Southampton Trade Park, Southampton | Spend | Mailing | Occupier | -431.3 |  | 2011-08-25 00:00:00
Poole Trade Park, Poole | Spend | Mailing | Occupier | -431.3 |  | 2011-08-25 00:00:00
Vista Park, Unit 110, Nursling | Spend | Mailing | Occupier | 0 |  | 2011-08-30 00:00:00
Anchorage Park, Portsmouth | Spend | Advertising | Property Week | -500 |  | 2011-09-05 00:00:00
Anchorage Park, Portsmouth | Spend | Advertising | Artwork | -175 |  | 2011-09-05 00:00:00
H&CA Investment Disposal | Spend | Advertising | Estates [NAME] | -1960 |  | 2011-09-01 00:00:00
Meon House, Segensworth | Spend | Photography | Aerial Photo | -450 |  | 2011-10-02 00:00:00