Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use convention:

CCBpeople__YYYYMMDDYYYYMM

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

...

  • The proper header, with code snippets.
  • The appropriate column spacing so header row is no more than 2 sentences high.
  • An djusted adjusted 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".

...

Concatenate Chair and the Chair type.

  • Column Insert column "GC". Header is "Chair, type"
  • Code:
    • =IF(ISBLANK(A2),"No Chair specified",CONCATENATE(A2,", ",B2))

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (columns A-E)

...