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!