B&O Mailing List

  • Posted
  • Proposals 14
  • Remote
  • #16010
  • Archived
Prakash T.S K.Julie E.Alison G.Sophie L. + 9 others have already sent a proposal.
  • 0

Description

Experience Level: Expert
This project is to create a mailing list of all the B&O shops in the UK. The information can be found at http://www.bang-olufsen.com/ and select the store locator. You will have to select each city in turn to obtain the details for the store in that city. I have attached an excel spreadsheet to this project that is to be completed. I have put a single entry in the spreadsheet by way of an example.

I require each field to have something in it. This requires a bit of thought for the address fields as some addresses are short and you then have to spread them out over the fields and other addresses are long so multiple data items will have to be entered into one field. Where this is necessary please use a comma to seperate the fields. The key thing is that all fields have data in them and it is human readable.

The county field also needs completing and the county is not always shown. An address lookup tool can be used to lookup the address from the postcoe which will give you the county. This service seems to work quite well http://www.postcoder.com/handy_tools/postcode_lookup.

The deliverable for this project is the attached spreadsheet completed for all B&O stores with each store on a seperate row.

Clarification Board

    There are no clarification messages.