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

Compare with Current View Page History

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

Copy previous "master" list as a template for the new master list.

Use convention:

CCBpeople__YYYYMMDD

This is now the current, date-stamped, people's "master" list.

This carries over all sorts of adjustments, such as:

  • The proper header, with code snippets.
  • The appropriate column spacing so header row is no more than 2 sentences high.
  • An djusted spreadsheet so header row does not move as one scrolls up and down through spreadsheet.
  • An 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".

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.

Prepare grad data and paste into "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

  • No labels