Collecting attendee names

You will collect the names and contact information for an important engineering event in Paris, France.

We need this information to understand who is attending the event, which country they are from and how to contact them.

cigre.org/content/download/21356/961897...

Download this list of attendees.

You can use Google Docs, Microsoft Excel or Open Office format.

Create these headings in the new spreadsheet:

- Country
- First Name
- Last Name
- Email address
- Company Name
- Job Title
- Address
- Telephone
- Fax

Only collect information for Australia.

Do not spend time collecting information for other countries.

Now look at the attendee list pdf that you downloaded.

For each of the attendees fill in the details on the spreadsheet.

One row per attendee.

Fill in the columns as best you can. The most important information is

- Country
- First Name
- Last Name
- company
- email
- telephone

If there are more than two names. E.g.

Barry John Smith

Then

- Barry - is the first name; and
- John Smith - is the last name

For each page:

- read the first column top to bottom
- then the second column top to bottom
- then move to the next page and start with the first column.

For example. The Australian attendees start on "Page 1, second column" and continue until "Page 4, first column"

Some attendees will have:

Job title, department, company, address

while others will not have the department field:

Job title, company, address

The company comes just before the address. You can combine the job title and department fields:

Chief Engineer, System Planning, Electranet, PO BOX

would become:

- Job Title: Chief Engineer, System Planning
- Company: Electranet

You must email me! my email address will be given to you.

You must:
- confirm that you understand this procedure; or
- ask questions (I love to answer questions)