...

Oliver has a third "faculty" spreadsheet (data from Joyce Boda); not updated except by hand.

...

Copy previous "

...

master" list as a template for the new master list.

Use convention:

CCBpeople__YYYYMMDD

This is now the current, date-stamped, people's "master" list.

Replace header row of "master" spreadsheet.

Cut-and-paste header from previous version of "master" spreadsheet.

...

This carries over all sorts of adjustments, such as:

• The proper header, with code snippets.
• The appropriate column spacing so header row is no more than 2 sentences high.

...

• An djusted spreadsheet so header row does not move as one scrolls up and down through spreadsheet.

...

• An adjust spreadsheet so it will print well:
  • Page set up => Sheet tab:
    • Set "Rows to repeat at top:" to: $1:$1
    • Under this tab's "Print" section, select "Gridlines".

Delete all but faculty entries

• Use Data => Filter to show all but "*Faculty" rows, and delete those rows. then turn off Filter to show faculty members.

Prepare grad data

...

and paste into "master" spreadsheet

Add "Grad" to title of each person in the "grad" spreadsheet.

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (columns A-E)

• Paste below faculty data so that data is not over-written.

====================

Cut-and-paste email addresses from NetID column (D) to Email address column (H).

...

Current_Faculty201308_oh10

Copy previous "master" list as a template for the new master list.

Delete all but faculty entries

Use Data => Filter to show all but "*Faculty" rows, and delete those rows. then turn off Filter to show faculty members.