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