Excerpt
The "people" data from Kevin needs to be aggregated, and added to existing faculty info, for it to be useful.

Kevin provides two spreadsheets whenever he kindly provides us with a snapshot (monthly?). One is the "grad" spreadsheet (from Pat Hine's data), and the other is a "staff" spreadsheet (from Sharon de Roos's data).

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

Table of Contents

Rename "grad" spreadsheet

Use convention:

CCBpeople__YYYYMMDD

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

Replace header row of "master" spreadsheet.

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

Set appropriate column spacing so header row is no more than 2 sentences high.

Adjust spreadsheet so header row does not move as one scrolls up and down through spreadsheet.

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".

Prepare grad data within "master" spreadsheet

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

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

Do the appropriate data concatenations and substitutions

Full name

=CONCATENATE(B2," ",C2)

Email-to-NetID conversion

=SUBSTITUTE(H2,"@cornell.edu","")

Text-copy or Values-copy NetID conversion column (J) into NetID column (D)

Move staff data into "master" spreadsheet

Copy faculty names into "master" spreadsheet

Current_Faculty201308_oh10