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

Date | Property | eBIS No | Billing Client | Fee Earner | Category | Sub-Category | Qty | Sent to (Mailings) or Size (Adverts) | Literature Sent (Mailings) Publication (Adverts) | Sent via (Mailings) Ad Date (Adverts) | Recover? Y/N | Cost each | Total to Client | Date Billed | Additional Comments | Invoice No
2011-07-01 00:00:00 | [NAME], Unit 5, Segensworth | 0055078-SO-0000 | [NAME] | ARW | Emailing | Local Agents | 69 | Local Agents | Brochure + letter | In House | N | 0 |  | n/a
2011-07-05 00:00:00 | Acorn Business Centre, Unit 9, Portsmouth | 0024588-FA-0000 | PETA Ltd | RCD | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 2/8 & coded
2011-07-05 00:00:00 | Ameiva Point, Portsmouth | 0057182-FA-0000 | Tidebank UK Ltd | RCD | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y |  |  |  | Supplier invoice rec'd 2/8 & coded
2011-07-05 00:00:00 | Manor Court, 8-12, Segensworth | 0054918-FA-0000 | Legal & General Property Unit Trust | SDW | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 2/8 & coded
2011-07-05 00:00:00 | The Briars, Waterlooville | 0046302-FA-0001 | Whittle Jones Group Ltd | RCD | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 2/8 & coded
2011-07-05 00:00:00 | Luxor Court, Unit 6, Havant | 0020192-FA-0000 | Starbax Ltd | RCD | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 4/8 & coded
2011-07-05 00:00:00 | Highgrove Industrial Estate, Portsmouth | 0052518-FA-0000 | ING (UK) REIT (SPV NO. 2) Ltd | DMC | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 4/8 & coded
2011-07-05 00:00:00 | [NAME], Unit 5, Segensworth | 0055078-SO-0000 | [NAME] | ARW | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  | 25.7.11 |  | Inv No ARINV/00108725
2011-07-05 00:00:00 | Apex House, Gosport | 0056581-FA-0000 | Glenmore Commercial Estates Ltd | DMC | Advertising | Business Magazine | 1 | 1/4 page | Business Magazine | 15.07.11 | Y | -62.5 |  |  | Supplier invoice rec'd 4/8 & coded
2011-07-13 00:00:00 | Griffin Industrial Estate, Totton | 0054305-SO-0000 | PruPIM | ARW | Advertising | Echo | 1 | 10x2 | Echo M3 Feature | 19.07.11 | Y | -100 |  | 17.8.11 |  | Inv No ARINV/00110185
2011-07-13 00:00:00 | Apex House, Gosport | 0056581-FA-0000 | Glenmore Commercial Estates Ltd | DMC | Mailing | Occupier | 920 | Letter & brochure | All PO codes plus SO14-19, SO21-23, SO30-31 | Sector Services | Y | -563.72 | -828
2011-07-14 00:00:00 | Southampton Trade Park, Southampton | 0050208-SO-0000 | ICL Pension Trust Limited | ARW | Advertising | Echo | 1 | 10x2 | Echo M3 Feature | 19.07.11 | Y | -100 |  | 17.8.11 |  | Inv No ARINV/00110183
2011-07-14 00:00:00 | Wykeham Trade Park, Units 4 & C, Winchester | 0055766-SO-0000 | Cadbury Schwepps | ARW | Advertising | Echo | 1 | 10x2 | Echo M3 Feature | 19.07.11 | Y | -100 |  | 27.7.11 |  | Inv No ARINV/00108822
2011-07-14 00:00:00 | Swanwick Business Centre, Unit 8, Swanwick | 0032045-SO-0000 | Uptel SIPP c/o Trigg & Day | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30
2011-07-14 00:00:00 | Griffin Industrial Estate, Totton | 0054305-SO-0000 | PruPIM | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110185
2011-07-14 00:00:00 | Wykeham Trade Park, Units 4 & C, Winchester | 0055766-SO-0000 | Cadbury Schwepps | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 27.7.11 |  | Inv No ARINV/00108822
2011-07-14 00:00:00 | Southampton Trade Park, Southampton | 0050208-SO-0000 | ICL Pension Trust Limited | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110183
2011-07-14 00:00:00 | Chancerygate Business Centre, Southampton | 0055536-SO-0000 | [NAME] LLP | ARW | Mailing | Occupier | 264 | Local Occupiers | Letter, brochure & mini mailer | In House | Y | -0.95 |  | 17.8.11 |  | Inv No ARINV/00110184
2011-07-14 00:00:00 | Chancerygate Business Centre, Southampton | 0055536-SO-0000 | [NAME] LLP | ARW | Advertising | Echo | 1 | 10x3 | Echo M3 Feature | 19.07.11 | Y | -150 |  | 17.8.11 |  | Inv No ARINV/00110184
2011-07-23 00:00:00 | Vista Park, Unit 210, Nursling | 0057374-SO-0000 | SEGRO plc | ARW | Mailing | Occupier | 1000 | Local Occupiers | Letter, brochure & mini mailer | Sector Services | Y | -0.95 |  | 17.8.11 |  | Inv No ARINV/00110179
2011-07-23 00:00:00 | [NAME], Unit 9, Nurlsing | 0039794-SO-0000 | CBRE Investors | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110181
2011-07-23 00:00:00 | [NAME], Unit C, Hedge End | 0050298-SO-0000 | Navimo UK Ltd | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110174
2011-07-23 00:00:00 | [NAME], Unit 5, Segensworth | 0055078-SO-0000 | [NAME] | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 15.8.11 |  | Inv No ARINV/00110102
2011-07-23 00:00:00 | Southampton Trade Park, Southampton | 0050208-SO-0000 | ICL Pension Trust Limited | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110183
2011-07-23 00:00:00 | Marchwood Industrial Estate, Unit 1A.2 | 0048919-SO-0000 | Biome Technologies plc | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110180
2011-07-23 00:00:00 | [NAME], Unit 3, Eastleigh | 0037877-SO-0000 | Royal London Asset Management | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110177
2011-07-23 00:00:00 | Griffin Industrial Estate, Totton | 0054305-SO-0000 | PruPIM | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110185
2011-07-23 00:00:00 | Lower [NAME], Units 1&2, Southampton | 0057983-SO-0000 | F&C REIT Asset Management LLP | ARW | Advertising | [NAME] | 1 |  | [NAME] | In House | Y | -30 |  | 17.8.11 |  | Inv No ARINV/00110157
2011-08-01 00:00:00 | Fusion, Solent Business Park | 0053775-FA-0000 | Greenhills Property No 33 Ltd | SDW | Mailing | Occupier | 505 | Local Occupiers | Letter, brochure & mini mailer | Sector Services | Y | -0.95 |  | 17.8.11
2011-08-15 00:00:00 | Lower [NAME], Units 1&2, Southampton | 0057983-SO-0000 | F&C REIT Asset Management LLP | ARW | Mailing | Occupier | 27 | Local Occupiers | Letter, brochure & mini mailer | In House | Y | -0.95
2011-08-25 00:00:00 | Portfield Trade Park, Portsmouth | 0053633-FA-0000 | Hargreaves Holdings | RCD | Mailing | Occupier | 454 | National Trade Occupiers | Letter, brochure & mini mailer | Sector Services | Y | -0.95
2011-08-25 00:00:00 | Southampton Trade Park, Southampton | 0050208-SO-0000 | ICL Pension Trust Limited | ARW | Mailing | Occupier | 454 | National Trade Occupiers | Letter, brochure & mini mailer | Sector Services | Y | -0.95
2011-08-25 00:00:00 | Poole Trade Park, Poole | 0018147-FA-0000 | Standard Life UK Property Trust | JV | Mailing | Occupier | 454 | National Trade Occupiers | Letter, brochure & mini mailer | Sector Services | Y | -0.95
2011-08-30 00:00:00 | Vista Park, Unit 110, Nursling | Not Applicable | [NAME] | ARW | Mailing | Occupier | 63 | Nursling/Totton Occupiers | Letter & brochure with Let/Sold Sticker | In House | N | 0 |  | n/a
2011-09-05 00:00:00 | Anchorage Park, Portsmouth | 0058413-FA-0000 | Dooba Investments III Ltd | RCD | Advertising | Property Week | 1 | 1/2 page | Property Week | 09.09.11 | Y | -500 |  |  | Do not invoice until invoice for artwork in from Adventis
2011-09-05 00:00:00 | Anchorage Park, Portsmouth | 0058413-FA-0000 | Dooba Investments III Ltd | RCD | Advertising | Artwork | 1 | 1/2 page | Adventis | N/A | Y | -175 |  |  | Ensure supplier invoice received before invoicing client & invoice with [NAME] cost (see above).  Cost shown is estimated.
2011-09-01 00:00:00 | H&CA Investment Disposal | TBA | SEEDA/HCA | JV | Advertising | Estates [NAME] | 1 | 1/4 page | Estates [NAME] | 01.10.11 | Y | -1960
2011-10-02 00:00:00 | Meon House, Segensworth | TBA | [NAME] | NB | Photography | Aerial Photo | 1 | n/a | n/a | 01.10.11 | Y | -450