88 · ARL Annual Salary Survey 2009–2010
4. The template Excel file is available at: http://www.arl.org/stats/annualsurveys/salary/salform09.shtml. This
is a generic, blank file that can hold data for Main, Law, or Medical libraries. The file’s name is “sal09xxxx.
xls”; open the file and save it to your own computer by choosing “Save As” under the File menu. When
saving the file, utilize ARL as the prefix for main library reports, use 09 to designate the year (2009-2010), and
change the “xxxx” in its name to your ARL institution code number, e.g., “ARL091150.xls.” Note: use MED
for medical libraries, e.g., “MED091150,” and LAW to denote law libraries, e.g., “LAW091150.”
The file contains columns labeled as follows:
Required: Name/ID#, LibID, Page, Line, Salary, Job, Sex, OEOcat, Yrsexp, Rank, Percent
Optional: Hisp, NatAm, Asian, Black, HawPI, White
In the LibID column, enter your ARL Library Institution Code. (See http://www.arl.org/stats/
annualsurveys/surveycoord/instno_inam.shtml if you do not know your code.) If you leave this column
blank we will fill it in for you when we receive the data.
Columns labeled “Page,” “Line,” and “Percent” are already filled for you. The numbers in the “Page” and
“Line” columns will be used to identify these positions in case of data errors; do not change them. Ten
“pages” of 25 lines each have been provided; if this is not sufficient to list all positions at your institution,
copy and paste lines 1-25 of the last page as needed.
Entering Data for Part II: Individual Data (Microsoft Excel Form)
1. The “Name/ID#” column is for your internal use, to enter and verify information for staff members by name.
ARL does not require that you submit the information in this field to ARL. Please delete this column before
sending the file to ARL. Upon receiving this file, ARL will delete any data in this column if you have not
deleted them already.
2. The “LibID” will hold your institution’s ARL number, for identification purposes. If you do not know your
ARL number, you can find it on the Web under ARL Library Institution Codes. If you leave this column
blank, it will be filled in by ARL staff.
3. “Salary” should be entered as it existed on July 1, 2009. Please do not hold up the reporting process for later
salary adjustments. Include all filled positions and exclude all vacant positions. Report the actual salary
paid. Do not adjust part-time salaries to their full-time equivalents; ARL will do this during the data analysis
and verification stage. Do not include fringe benefits.
4. Each position can have only one “Job” code, to be taken from the following list:
DIRLIB Director of Libraries (includes Dean of Libraries and equivalent titles)
ASCDIR Associate Director
ASTDIR Assistant Director
HDMED Head, Medical Library (Human Medicine only)
HDLAW Head, Law Library
HDBR Head, Other Branch Library (including Veterinary Medicine)
FSPEC Functional Specialist
BUSI Budget/Fiscal/Business Manager/Facilities
HUMRES Human Resources/Training/Staff Development
ITS Information Technology Systems