Versions Compared

Key

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

...

  1. Go to L:\tsstats and select "1New_culv-2012-2013.accdb." Make sure that the "Macros" menu is showing. If it does not say "Macros," click on the little circled arrow and select "Macros." Click on the "Unit Reports" macro.

  2. Enter the desired date range in the boxes and click "Ok."
  3. This dialog box will most likely appear (below). If it does, you must click YES to clear the data from the last time someone ran this report for their unit.
  4. Next the macro will ask you to enter the name of your unit. (See below.) You may enter it in full, as rendered in the Unit ID/ Unit Name table shown below, or type the first three letters of the name as shown in that same table (case sensitive); the script will then automatically choose the corresponding unit name. After entering the name, click “ok” to run the query and return a report.

         

NOTE: Please note that staff members have been entered into this database under the unit of their administrative supervisor. For example, while Nancy Solla Betty Spreadsheet does some copy cataloging, she is a direct report of the Batch Processing Unit Supervisor and is entered under Batch Processing. If you have a staff member who does some work for you but who reports to another manager, you can run your unit report and then run the “Individual Report” for any such staff member(s).

WHEN YOU HAVE NEW STAFFWhen you have new staff, you must notify the TS Stats admin (currently Nancy Solla) in order to have them added to the database. In order for a staff member (including student workers) to be included in your unit report, their name and net id must be in this database, and they must be assigned the proper unit name.

...