The people data from Kevin needs to be aggregated for it to be useful.
Kevin provides two spreadsheets whenever you 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.
Replace header row of "grad" spreadsheet.
Grab header from previous master people list.
Add "grad" to title of each person in the "grad" spreadsheet.
Do the appropriate data concatenations and substitutions
Full name
=CONCATENATE(B2," ",C2)
Email to NetID conversion
=SUBSTITUTE(D2,"@cornell.edu","")