| 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 you 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.
Grab header from previous
...
version of "master" spreadsheet.
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(D2H2,"@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