home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-387-Vol-3of3.iso
/
s
/
sched393.zip
/
LETTER.TXT
< prev
next >
Wrap
Text File
|
1993-02-15
|
5KB
|
105 lines
Evan Lauber
185 Rt. 206 Bldg 16 Suite 1
Flanders, New Jersey 07836
(201)584-8596
Feb. 15, 1993
To Whom It May Concern:
Enclosed please find a copy of a spreadsheet that I have
written entitled Scheduler; I updated it on 2/15/93. I have
developed this spreadsheet to help make my job easier. I am
a District Manager for a large company in New Jersey. I
don't think there is a program on the market today that will
meet the needs my product addresses. Scheduler will allow
you to type in the hours that an employee works and it will
automatically figure out the hours that they will incur for
the week, it also figures out overtime, subtracts break
times automatically, sums up the total hours for the
district for each day, and for the week. This is a very
valuable service. To help you see just how beneficial this
is, try to calculate the number of hours an employee will
have if he or she works Monday 10:00AM to 7:30PM, Tuesday
11:00AM to 8:30PM, Wednesday 9:30AM to 5:00PM, Thursday
9:15AM to 6:45PM, and Friday 8:00AM to 10:00PM. It will
probably take you at least a few minutes to figure it out;
did you deduct break times? Multiply how long it took you to
figure that out by 10 to 100 employees many with different
schedules, and the time needed to accurately sum up the
total hours by department, store, district, by each day, or
for the week, and you will soon come to appreciate this
product! If you didn't get 45 hours you definitely need
this product! In addition it also has a corporate calendar
that will automatically set the date on the schedule
correctly, the calendar has the current year, last year,
next year, and the year after next. Furthermore it can be
easily configured for any companies fiscal year. Besides
saving the manager a lot of time (time is money)! when
making a schedule, it makes it very easy to update the
schedule when people are late, call in sick or need to
switch their schedule with other employees. District
Schedule also makes it very easy to cut hours and stay
within your weekly hourly budget. If your budget is very
strict you could even update the times' employees have
worked after every day, to project your total District or
Store Hours at the end of the week. There is also room for
up to 7 employees in each store with up to 12 stores.There
are three major versions to date two Quatro versions one has
8 stores and one has 10 stores, and One Lotus Version which
supports upto 12 stores. You can also keep track of all of
the employees phone numbers; the stores phone number, the
direct line phone number, store address, and the Managers
address, employees social security number. all of this on
only one easy to read page. I have found this printout to be
an invaluable asset; so much so that during the day I keep
it with me at all times. I have also designed it so you can
print out two different easy to read schedules, the first is
a for your employees only and a second printout for your
records. Scheduler also keeps track of employees birthdays,
sales averages, dates tardy, dates absent, counceling
records, and other notes you may want to keep.
Since I have originally designed Scheduler for Quatro Pro
and have spent much more time with Quatro the Quatro version
has been revised much more, and should be bug free. the
lotus version only has one bug that I could not fix. If you
try to delete a time with the delete key it will change the
format of the cell and delete any lines drawn around the
cell. Therefore make sure you use the space bar to delete
things in Lotus, If anyone can help me fix this bug I would
be very grateful.
Scheduler can also be easily adapted for a store manager to
keep track of his employees by department, and then sum them
up by day, department, and store. It can be adapted for
more employees per store or department, and for more stores,
or it can be made to be linked with other files if needed. I
am sure that you will be interested in this product in some
capacity I hope you will agree with me, and find this
spreadsheet a worthy asset to any manager that has to make a
schedule. Before I designed this program my schedules always
ended up being updated, and altered with a lot of white
out, I am sure you can imagine just how messy they became! I
hope you will appreciate the neat print out and understand
that if marketed it would become very useful especially to
those managers who already use Quatro Pro, or use laptops.
If you are interested in marketing this product or know
someone who may be interested, in any capacity please
contact me.
Yours,
Evan Lauber
Author
P.S.
Scheduler should load into those little computers like the
Wizard or Atari Portfolio since they have lotus 123 in them!