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

Compare with Current View Page History

« Previous Version 5 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.

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

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