Full-Month Reports for Admin-Supe
An enhancement to the Leaves Calendar provides an Excel report
of monthly info, in either a detailed list or summary form,
for all staff members of an admin-supe.
(It's easier to do and see than it is to describe.)
Here are the steps:
-
If you are using the Netscape browser please start a session using
the Microsoft Internet Explorer browser. The Netscape browser
sometimes doesn't save files properly. Go to
www.princeton.edu/leaves/info/supemonth.htm in MSIE.
(That is this page.)
-
Save these two files on your PC by right-clicking on each and
choosing "Save Target As...".
-
monthlist.iqy to obtain a
list of all Leaves taken by your staff for the specified month.
-
monthsum.iqy to obtain a
summary of Leaves taken for the specified month for each
member of your staff.
Be sure to note the location where you saved them.
-
Open Excel
-
Open a blank spreadsheet and select a cell to use for the upper left
position of the data.
Steps 5 and 6 for Traditional Excel
-
Use the drop-down menu under "Data" to launch the query. The exact
words displayed by Excel vary with the version.
-
For Excel 2000
Pull down "Data" -> "Get External Data" -> "Run Saved Query"
-
For Excel 2002
Pull down "Data" -> "Import External Data" -> "Import Data"
-
Select one of the two .iqy files you saved in Step 2 (above) and click
either "Get Data" or "Open" (depending upon the version of Excel).
Now skip to Step 9.
ALTERNATIVE Steps 5 and 6 (now 7 and 8) for Newer Versions of Excel
and/or Windows
-
Open Windows Explorer in a separate window, and find the two
.iqy files you saved in Step 2 (above).
-
Select one of the two .iqy files by clicking on it and holding down
the mouse button. Drag the selected file to the upper left corner
of the spreadsheet and release the button. The program should
activate and fetch the data.
All Users Continue to Step 9
-
Follow the instructions (i.e., accept the cell of the existing worksheet
that you've already chosen, give a month in YYYYMM form, and login
with your netid and email password).
This will display the detailed list (monthlist.iqy) of all staff for
whom the login person is an admin-supe, or the sum of activity by type
for all such staff (monthsum.iqy). In both cases the display is for the
month requested. The monthsum report also lists the LAST LOCKED MONTHS
for all staff.
