You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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

  • No labels