HIT: Uses for Excel

[Wanda Nall <wpnall@YAHOO.COM>]

Sorry, I tend to forget that LM_NET does not allow
attachments.

There were many responses but I think that the
following pretty well covers the replies that I got.

Before I automated, I used Excel to keep circulation
statistics; track
patron numbers (how many in for research,
reference,general use, etc.);
to
track budget; my hours worked, conferences attended,
sick days, etc.;
keep
track of accessions; magazine subscriptions; inventory
info; keep track
of
items added to or weeded or lost in the collection by
Dewey number.
When I had Student workers, I tracked their hours and
how much they
should
be paid - had to schedule them so they wouldn't work
over their funding
limit.

Now, I use it to help with reports, to track volunteer
hours, to track
my
work days, to help with inventory to track my budget,
to keep computer
use
statistics.


I am an excel nut.  I use it for book orders, advisory
lists, budget,
keeping track of continuing education hours and
personal and
professional days taken.


1. Budget- I use one file for the year with a
worksheet for each budget
(Book Fair, Overdues, Gift Money, Regular Budget,
Title 1)
2. Book order- title, author, ISBN, publisher, cost,
review source,
Dewey- Can be sorted by any of these
3. Class lists with a column to check participation
like a grade book
4.Addresses for other media specialists- can create
mailing labels,
merge into a form letter :))
5. Bibliographies of all sorts- title, author, Dewey,
publisher, topic

My tech person encouraged me to use Excel rather than
the Database. It
works well.


=====
Wanda Nall
Library Media Specialist
Hereford ISD
Hereford, Tx 79045
wandanall@hisd.net

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-
All LM_NET postings are protected by copyright law.
To change your LM_NET status, e-mail to: listserv@listserv.syr.edu
In the message write EITHER: 1) SIGNOFF LM_NET  2) SET LM_NET NOMAIL
3) SET LM_NET MAIL  4) SET LM_NET DIGEST  * Allow for confirmation.
LM_NET Help & Information: http://ericir.syr.edu/lm_net/
Archive: http://askeric.org/Virtual/Listserv_Archives/LM_NET.shtml
LM_NET Select/EL-Announce: http://www.cuenet.com/archive/el-announce/
LM_NET Supporters: http://ericir.syr.edu/lm_net/ven.html
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-