RBBS in a Box Volume 1 #2

home *** CD-ROM | disk | FTP | other *** search

/ RBBS in a Box Volume 1 #2 / RBBS_vol1_no2.iso / add2 / pcmech12.zip / PCMECH.DOC < prev next >

Wrap

Text File | 1989-05-25 | 52KB | 1,519 lines

P C M E C H A N I C Version 1.2 USERS MANUAL Copyright (C) 1986,1988 Michael R. Busman C O N T E N T S --------------- PAGE LIST OF FILES ON THIS DISK ....................... 1 INTRODUCTION ..................................... 2 INSTALLATION & HARDWARE REQUIREMENTS ............. 4 GETTING STARTED .................................. 6 UTILITIES SYSTEM ................................. 7 INVENTORY SYSTEM ................................. 8 WORK ORDER SYSTEM ................................ 10 PREVENTIVE MAINTENANCE SYSTEM .................... 13 EQUIPMENT DATABASE SYSTEM ........................ 15 EMPLOYEE DATABASE SYSTEM ......................... 16 TIPS & POINTERS .................................. 17 GETTING HELP ..................................... 18 HOW TO REGISTER PC MECHANIC ...................... 19 DISCLAIMER OF WARRANTY THIS SOFTWARE AND MANUAL ARE SOLD "AS IS" AND WITHOUT WARRANTIES AS TO PERFORMANCE OF MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED. BECAUSE OF THE VARIOUS HARDWARE AND SOFTWARE ENVIRONMENTS INTO WHICH THIS PROGRAM MAY BE PUT, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED. GOOD DATA PROCESSING PROCEDURE DICTATES THAT ANY PROGRAM BE THOROUGHLY TESTED WITH NON-CRITICAL DATA BEFORE RELYING ON IT. THE USER MUST ASSUME THE ENTIRE RISK OF USING THE PROGRAM. ANY LIABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF PURCHASE PRICE. PC MECHANIC Page 1 LIST OF FILES ON THIS DISK -------------------------- To insure that you are working with the complete PC MECHANIC package, the following files should be included on the program disk: FILENAME FUNCTION -------- -------- INSTALL.BAT Installation batch file PCMECH.EXE Main PC MECHANIC executable file READ.ME Explains how to print out documentation manual Display using the DOS TYPE command PCMECH.DOC This file, the users manual PRINTER.BAS Short BASIC program for configuring printer INV.OVL Inventory system overlay file UTILITY.OVL Utilities subsystem overlay file WORK.OVL Work order system overlay file PM.OVL Preventive maintenance system overlay file EQUIP.OVL Equipment database system overlay file EMPL.OVL Employee database system overlay file PMMASLST.FRM Report format file TRADERPT.FRM Report format file LOCAT.FRM Report format file EQUIPRPT.FRM Report format file WOHEQUIP.FRM Report format file WOHLOC.FRM Report format file PMDONE.FRM Report format file PMBAKLOG.FRM Report format file PERFREVU.FRM Report format file EMPLIST.FRM Report format file SENIORITY.FRM Report format file PC MECHANIC Page 2 INTRODUCTION ------------ Why computerize the preventive maintenance and work order system? If your operation handles more than a couple of hundred work requests per week, it is very easy for many to "fall through the crack" or get lost in a paperwork system. Once a work request arrives and is passed on to the appropriate trade supervisor, you have no immediate record of the request or control over the prioritization or scheduling. Have you ever wondered how much output you are getting from your employees? Does it take an inordinate amount of time to dig up information on how much was spent on repairs for a particular piece of equipment? Can you easily document how much was spent on repairs for a certain department due to the department's neglect or abuse of equipment? Once set up does your preventive maintenance system keep an employee occupied pulling cards or writing up preventive maintenance work orders? Do you know what your corrective and preventive maintenance backlogs are? Have you ever had to hunt through file drawers to find a part number or lubricant type for a piece of equipment? Do you know how many of the outstanding work requests are 1 week, 2 weeks, 1 month, or 2 months old? Do you know how much spare parts inventory is sitting on the shelf? Do you have too many last minute parts purchases because someone forgot to tell you when the supply got low? Do you have $3000-$15,000 to spend on a commercial maintenance software package? If you honestly answered the above questions, then you should begin to think about how the PC MECHANIC MAINTENANCE MANAGEMENT SYSTEM may be an organizational tool to help you. How? Because a computerized work order and preventive maintenance system can do the necessary number crunching and menial tasks such as retrieving records, printing work assignments, posting to records, and report generation that may be too much for your present staff. The PC MECHANIC is an application written in the dBASE programming language. Although dBASE is a very powerful database management program, it can be very difficult for people to use. To use the PC MECHANIC, you don't have to know the first thing about dBASE. I've done the hard work writing a totally menu- driven system that is E A S Y to use. The menus and input screens almost make these instructions unnecessary. Depending on how most people will need information in reports, I've built in a lot of flexibility to search based on different criteria. Since we touched on the subject of programming, let me tell you a little about myself. I don't claim to be a programmer as can be evidenced by a look at some of my source code. It might PC MECHANIC Page 3 not be pretty, but it somehow manages to work. I do think I know a little about maintenance and computerized maintenance systems. My full-time employment is in the area of energy management and maintenance for a major U.S. hospitality company. I am involved every day with building maintenance personnel and have been exposed to a number of maintenance software packages over the past few years. My two main gripes about most maintenance software are the high cost and complexity for the typical user. Armed with a rebellious spirit to stick it to the greed- mongers charging thousands, a desire to better learn dBASE programming, and a wild fantasy that I might actually be able to keep my wife in mink and diamonds, I set out to write a shareware maintenance management program that would be easy to use. What is shareware? I like to think of it as "test drive before you buy". Try it. If you don't like it, throw it away or burn it. You haven't lost anything. If you do find you like it and it benefits your operation, then most shareware authors request that you send in a registration payment to the author to reward him for his efforts. Most shareware authors urge you to spread copies of their program around to friends, associates, user groups, or bulletin boards. Some authors warn that if you continue to use their program and don't send in the registration payment, you will suffer from bad Karma, guilt trips, or swarms of locusts. I think I am a little more reasonable and to the point. I hold the copyright to this program. If you think it is lousy, don't use it. Better yet, drop me a note telling me your beef and I will do my best to incorporate your suggestions into the program. If you do like it and use it, I would suggest a registration payment of $50.00 or whatever amount you would like to contribute to my wife's mink and diamonds fund. In all seriousness, let me say that I have invested many, many hours of my free time writing the PC MECHANIC. I would like to think that someone appreciates it enough to register, or at least enough to send a note with comments. Registered users will be notified of future updates, which will be available at minimal cost. For everyone, I will be available for help and questions. My home telephone number is (312) 869-0114. I can also be reached on Compuserve, user ID# 71121,2014. If it is during the day and it is an emergency, my wife can give out my office number, but I prefer to keep this to a minimum. Registration payments or questions can be sent to: Michael R. Busman 820 Oakton Street Evanston, IL 60202 Whether you become a registered user or not, I hope you find that the PC MECHANIC provides many of the functions of commercial PC MECHANIC Page 4 maintenance management software in an easy-to-use, inexpensive package. At some point in the documentation, most folks usually put some sort of legal disclaimer stating that they are not responsible for anything. Upon strong legal recommendation, I have included similar wording at the beginning of this manual. I have spent a lot of time trying to find all of the bugs in the PC MECHANIC. It should be relatively bug-free, however, I can't give a 100% guarantee. What I will promise is that if you find a bug and notify me, I will do my best to correct it. As far as liability is concerned, if you manage to blow up a boiler or eat through the condenser tubes in a chiller, then it's your own damn fault. INSTALLATION & HARDWARE REQUIREMENTS ------------------------------------ Hardware & Software: -IBM or compatible PC, 640K ram memory recommended -Hard disk drive -Color monitor recommended -Dot matrix printer for work orders, reports, listings, etc. -DOS 2.0 or above -Interpreted BASIC (filename BASICA.COM) from your DOS (Disk Operating System) disk -Backup and restore programs (filenames BACKUP.COM and RESTORE.COM), also from your DOS disk Forms Requirements: -3.5 inch high continuous feed paper is recommended for printing of work orders and preventive maintenance work orders. This is a convenient size as work orders printed in condensed print easily fit in a maintenance engineer's shirt pocket. There are probably many possible sources for this paper, however, 2 that I know of are: Visible Computer Supply, St. Charles, IL tel. 312-377-0990 3.5 inch by 5 inch continuous file cards(index card size), catalog # DP325 TFC, 5000/carton Moore Business Forms,3.5 inch by 8.5 inch, 2 part continuous feed paper, 3700 sheets/box, mfg.# FO-450 Installation: Beginning with this version of PC MECHANIC (version 1.2), it PC MECHANIC Page 5 is no longer necessary to use dBASE III Plus or dBASE IV. PC MECHANIC now runs stand-alone, so you don't need anything else. Additionally, it runs much faster now than under the dBASE interpreter. The first time installation of PC MECHANIC should follow the steps below. If you already have PC MECHANIC running on your PC, go to step 4 below. 1. Turn on your PC and wait until you have the C> prompt, or whatever hard disk drive you want to use. During these instructions I will refer to the C> prompt or the "C" drive for your hard disk. You could be set up with a different drive letter so substitute yours accordingly. 2. Place the PC MECHANIC disk in the "A" diskette drive. Type in "A:INSTALL" (without the quotes) and hit the enter key. 3. Put the DOS disk which contains interpreted BASIC (BASICA.COM) in the "A" diskette drive. Without typing the quote marks, enter the following:"COPY A:BASICA.COM" and hit the enter key. This will copy the BASIC interpreter to your PC MECHANIC subdirectory. PC MECHANIC uses a short basic program to set the printer for 3.5 inch high forms/condensed print, condensed print only, and resets the printer for normal print. This should work for most Epson/IBM/Okidata printers. If your printer is different, consult your printer manual for the proper escape codes to use. Since most printer manuals give the correct printer codes with examples in BASIC, I decided to opt for this and allow users to edit the program (PRINTER.BAS). If this sounds like Greek, find someone familiar with BASIC, printer programming, or contact me. 4. With the DOS disk still in the "A" diskette drive, type in without the quote marks, "COPY A:BACKUP.COM", and hit the enter key. Next type in without the quote marks, "COPY A:RESTORE.COM", and hit enter. 5. You have just finished the first part of the installation process. You now have a subdirectory on your hard drive called \PCMECH. The PC MECHANIC executable program and report format files have been transferred to this subdirectory. Also, you have copied three files from your DOS disk to this subdirectory. PC MECHANIC Page 6 6. If you already have an earlier version of PC MECHANIC running on your PC, you just need to copy the PC MECHANIC disk to the proper subdirectory. Type in without the quote marks, "CD PCMECH" and hit enter. Put the PC MECHANIC disk in the "A" drive and type in "COPY A:*.* and hit enter. GETTING STARTED --------------- That's all there is to it. To fire up PC MECHANIC, you must be at the C> prompt and in the PC MECHANIC subdirectory. To make sure you are in the correct subdirectory, type in without the quote marks, "CD PCMECH" and hit the enter key. Then type "PCMECH" and hit enter. You will soon see the PC MECHANIC title screen for a few seconds, next the shareware message (otherwise known as a commercial message from the sponsors), next a prompt to make sure that you have set the caps lock on, and finally, the main menu will be displayed. In basic usage, menu selection is made by highlighting the item with the up and down arrow cursor keys and hitting enter or by hitting the number key corresponding to the desired choice, ie: hit 6 to enter the UTILITIES SYSTEM. In fact, that's exactly what you should do now. Before you can use the system, we have to enter the UTILITIES SYSTEM and create the database files. Highlight this menu option and hit enter or just hit the number 6. At the UTILITIES SYSTEM menu, select option 5, which is for FIRST TIME INSTALLATION. The other menu options will be explained later. When the installation process has finished, you will be shown the UTILITIES SYSTEM menu again. Select option 6, which will return you to the main menu. Most menus and data entry screens are fairly intuitive as to what you should type in. When filling in the data entry screens, if a piece of information is not known, leave the field blank. If you are ever unsure of an entry or menu option, one of the enhancements to this version of PC MECHANIC is context sensitive help. You access this by hitting the F1 function key. Remember, HELP IS ACCESSED BY HITTING F1. When you complete a field, hit enter or the down arrow key to position the cursor at the start of the next field. If you make a mistake and haven't left a field yet, you have the left & right arrows, backspace, delete, and insert keys available for editing the data field. Sometimes, you can move back one field by hitting the up arrowkey. This will vary due to the usage of dBASE READ commands. Finally, if you PC MECHANIC Page 7 make a mistake, continue entering data in the remaining fields. When you get to the bottom of the screen, you will be asked if everything is OK. The normal response is Y for yes or N for no. By hitting N, or just enter since the default is no, you can step back through the data fields and make corrections where necessary. If a field is OK, just hit enter to move on to the next field. In these instructions, there will be many instances where you will be told to type in something. The proper keystroke or keystrokes will be shown within quotation marks, such as these "". What you type in should be the keystrokes contained within the quote marks, but not including the quote marks. UTILITIES SYSTEM ---------------- The UTILITIES SYSTEM is accessed by selecting option 6 from the PC MECHANIC main menu. When you enter the system, you will be presented with the utilities menu. The options to select are as follows: 1. BACKUP DATABASE FILES 2. RESTORE DATABASE FILES 3. REBUILD INDEXES 4. CONVERT FROM PREVIOUS VERSION 5. FIRST TIME INSTALLATION 6. RETURN TO MAIN MENU Option 1 will perform a DOS backup of all the database files. You should have several blank formatted diskettes available to do this. As the size of the databases grow, you will need additional diskettes. The disks should be labelled in sequence, ie:Backup #1, Backup #2, Backup #3, etc. It is VERY IMPORTANT that you keep the disks in sequence. YOU should also do the backup operation EVERY DAY. It doesn't take very long and will save your skin one day when your hard disk decides to go off to never-never land. It should be noted that the program is hard coded to backup to the "A" diskette drive. If you have violent problems with this, perhaps, I can re-compile a modified version for you which will backup to a different drive. Option 2 performs a DOS restore of all the database files in the PC MECHANIC subdirectory. If you ever lose your hard disk, or buy a new computer and want to set everything up on the new machine, you will be glad to have this option. Option 3 rebuilds all of the indexes. I won't try to explain what indexes are-only that they help the system keep PC MECHANIC Page 8 records in order. If the indexes should get corrupted by a power failure or other misfortune, this option should rebuild them cleanly. Option 4 allows the user to convert from an earlier version of PC MECHANIC. Before using this version for the first time, select the conversion option. When it has finished, you will be returned to the utilities menu and you will be ready to go. Option 5 we already covered and should be used before the very first time PC MECHANIC is run. Option 6 returns the user to the PC MECHANIC main menu. INVENTORY SYSTEM ---------------- To enter the inventory system, select #1 at the main menu. The menu selection items you will be shown are: 1. Enter/Modify/Delete Parts Records 2. Issues/Returns Transactions 3. Vendors Database 4. Purchases Records 5. Reports Menu 6. Return to Main Menu Enter/Modify/Delete Parts Records: If you want to set up the inventory system, probably the first area to enter is the Vendors Database. The reason for this is that the vendor identification number will be needed for the parts records. The vendor data to enter is pretty much self- explanatory. The vendor identification # is generated by the computer and will be needed in other parts of the program. When all data inputs have been made,you will be prompted if everything is OK or not. The response should be "Y" for yes or "N" for no. When you are satisfied with the inputs and answer "Y" to everything OK, the next prompt will be a blinking "MORE". This is asking if you have more entries to make. Again, the proper response is "Y" for yes or "N" for no. Assuming the vendors database has been set up, you will want to set up the parts records. Select item #1 at the inventory system menu. You will then be given the options to enter, modify, delete, or return to the previous menu. Some notes about PC MECHANIC Page 9 entering parts records are in order. The Item # is a part number which YOU assign to each part. You may want to start at 1 and sequentially number every item, or you may want to devise a letter and number code to describe the part. Mfg., is the manufacturer. Cat. # is the manufacturer's catalog or ordering number. Location is described by storeroom (Strm.), row in the storeroom, shelf in the row, and bin number on the shelf. The program allows for two storeroom locations. Desc. is for a description of the part, and can be 2 lines of 40 characters each. Value is the total opening value of the item stocked. This will be updated automatically as you issue material or receive purchases. Qty.on Hand is the quantity on hand. Reorder at is the level of inventory the part quantity must fall to before it is reordered. Reorder Qty. is the amount that should be reordered based on previous experience. Unit price is the quoted price the last time the item was ordered. This should be updated each order. In the section for vendors, you only need to enter the vendor ID# and the system will bring up the company name of the vendor. There is space to enter 3 vendors who carry the particular part. At the end, you will be prompted if everything is OK and if there are more entries to be made. Issues/Returns Transactions: The second selection choice is for transactions such as issues and receipts of items ordered, and also returns to the storeroom. To handle receipts, a record must be set up previously in the purchases section of the inventory system. When the transactions choice is made, a sub-menu will be shown. The choices on this menu are parts issued, parts returned, receipts of items ordered, delete old transactions, and return to the inventory system menu. Issues and returns are identical in the data input screen. The first field is date, which defaults to the current date. Type over this date or hit enter to accept the date. The next field is item, where you should enter the part number of the item. Description is system generated. If you want to track the transaction to a work order or preventive maintenance work order, enter the appropriate work order number or PM work order number. Next, enter the quantity of the part issued or returned to stock. After the prompt asking if everything is OK, the average cost and value of the part will be displayed. The quantity on hand and value of the part will be automatically updated to account for the transaction. To enter parts received, the data fields to input are date, purchase order number (PO#), part #, vendor ID#, and quantity received. The part description and vendor company name are generated by the computer. If everything is OK, the value and updated quantity backordered will be displayed. PC MECHANIC Page 10 To delete old transactions, you will be prompted to enter a cut-off date. All transactions before this date will be deleted from the database. Only use this option when you are sure you will not need to access the transaction information again. The purchases database is used to track items ordered and purchases by vendor. The data input fields are discussed below. Date defaults to the current system date. Type over this or hit enter to accept the date. P.O. # is the purchase order number. Part # is the part identification number you set up previously. Vendor ID is the vendor identification number. Description and vendor name are generated by the system. The next inputs are for the quantity ordered and unit price to pay. Ext. Cost is the extended cost and is system generated. The Qty. Backordered is is the quantity back ordered and is initially set equal to the quantity ordered. The reports menu contains selections for a number of inventory system reports. The parts listing is a basic list of all parts by part number, description and other information. The vendor listing is an alphabetic listing of vendors, identification numbers, contacts, and phone numbers. The reorder report is a listing of all parts where the quantity on hand has fallen below or is equal to the reorder level. The consumption report is a listing of usage over a user specified period of time, which also includes value of parts used. The purchases by vendor report gives the breakdown over a period of time of purchases from each vendor. It could be very useful to see if any favoritism is being shown to a particular vendor. The backorder report lists those items where the date promised has passed and the item has not been received yet. The final menu choice is to return to the inventory system main menu. WORK ORDER SYSTEM ----------------- To enter the work order system, select item #2 from the main menu. The work order system menu will then display the following choices: 1. Enter New Work Orders 2. Edit/Display/Reissue Work Orders 3. Close Out Completed Work Orders 4. Reports Menu 5. Delete Old Work Orders 6. Return to Main Menu To enter new work orders into the system, select item # 1. The first thing to happen is that the BASIC program for setting PC MECHANIC Page 11 up your printer will be loaded into memory. To print work orders in condensed mode and set the form length to 3.5 inches, select option #1 "SET UP PRINTER FOR WORK ORDERS" and hit enter. Make sure your printer is turned on to avoid time out errors. You will then see displayed the data input screen for entering work orders. The work order number is generated by the computer and is the reference number you will use later to track the work order. The current date is the default, so you can accept it by hitting enter or change it by typing over the date. The other fields to input are the equipment identification number, department making the work request or reporting the problem, location, person requesting the work, and responsible trade for the job. Priority can be input, as 1,2,3 or A,B,C or whatever system you may want to use. The work description fields allow you to enter up to 3 lines, each 40 characters long, which should be sufficient for most jobs. When you are finished, you will be prompted if everything is ok. The response should be "Y" for yes or "N" for no. You will then be prompted if you want to print out the work order. Again, the response to the prompt is "Y" or "N", without the quote marks. Next, will be displayed a flashing prompt with the word "MORE". This is the prompt asking if you have more work orders to input or if you are finished. The proper response is "Y" or "N". When you are finished, the BASIC printer control program will again be loaded into memory. You can select option #3 to reset the printer to normal printing and form length. A word of advice is offered here to avoid future headaches. Make up a list of standard codes for the various trades you employ and another list of standard location names or abbreviations. These should be used to develop consistency in data input and will be necessary later on when you want to request a report for a specific trade or location. If an exact match is not made to what you request, there will be no report or records will be missed. For example, if part of the time you enter "CA" as a trade code for carpenter, and part of the time you enter "CARP", the system will interpret these as 2 separate trades. If you request a report for all backlogged work belonging to the trade "CA", all work orders entered for "CARP" will be overlooked. Be careful. To edit, display, or reissue (reprint) a work order, select item #2 at the work order system menu. The input screen is identical to the new work order entry screen, so there is no further discussion of this item needed. To close out completed work orders, select item # 3 from the work order system menu. Enter the work order # when prompted to do so. You will then see the original work order data entry screen,however, there are some additional input fields. Status should be updated to complete by entering "C" (without the quote PC MECHANIC Page 12 marks) in the status field. Date complete and remarks, for any appropriate comments are self explanatory. There are fields to enter the identification numbers of up to 3 employees who participated in doing the job. These are entered one at a time. You enter the employee's ID# and the system displays the employee's last name. Enter the number of hours the employee devoted to the job and the system calculates and displays the labor cost associated with that particular employee. The system then totals up the labor cost for the job. You can also enter up to 3 parts used also. This operates in a similar manner. Enter the part number, and the system displays a shortened part description. Enter the quantity used, and the system calculates and displays the part cost. After entering up to 3 parts used, the system totals the parts cost. You will then get the familiar prompt asking if everything is OK or not. Answer with "Y" or "N". A new prompt will then be displayed asking if you want to automatically update the inventory files. In a large operation with a full-time storeroom clerk, you would most likely answer "N" for no to this prompt as issues will probably be handled from the storeroom and tracked there. For a smaller operation, I have added this option so that the inventory quantity and value can be reduced by the proper amounts without requiring the user to exit from the work order screen and enter the inventory system. If you want to update the inventory files, enter a "Y" for yes. Use a little caution here to avoid "double dipping" or deducting from inventory at the storeroom and when closing out the work order. The next prompt will be the flashing MORE?, asking if you have more to close out. The familiar response is "Y" for yes or "N" for no. Selection of item #4 from the work order system menu will bring up the menu of available reports. Item #1 of this menu is for a backlog listing of all work orders, sorted by trade. Items #2,3, or 4 will generate a backlog report for a specific trade, location, or piece of equipment. The user is prompted to enter the search string. Item # 5 is for the work order aging report. By trade, this will list the number of work orders of different ages, ie: 0-7 days, 8-14 days, etc. Items #6&7 are for work history reports sorted by a specific location or piece of equipment. The user again is prompted to enter the search string. Item #8 returns the user to the work order system main menu. After a period of time, the size of the work history database will probably get quite sizeable. You may determine that you don't need to keep this information for longer than 3 months, 6 months, or 1 year. To delete old work orders from the history database, select item #5 from the work order system main menu. You will be prompted to enter a cutoff date. All work orders with a completion date before the cutoff date will be purged from the database. Use this option with CAUTION. PC MECHANIC Page 13 Menu item # 6 will return the user to the PC MECHANIC main menu. PREVENTIVE MAINTENANCE SYSTEM ----------------------------- To enter the preventive maintenance system, select item # 3 from the maintenance system main menu. The preventive maintenance system menu will then display the following options. 1. Generic Maintenance Tasks 2. Define PM Requirements 3. Modify/Delete PM Requirements 4. Print Scheduled PM Work Orders 5. Update Completed PM/Transfer to History 6. PM Reports Menu 7. Return to Main Menu Selecting item #1 will take the user to the area for entering, deleting, or printing a listing of generic maintenance tasks. I call this generic because this is where the user can create a look-up table of common maintenance tasks for equipment. For example, with few differences, a 90 day inspection for an air handling unit will probably be the same regardless of the manufacturer. By filling in the maintenance tasks in this section and assigning a code, the user only needs to enter the code later when defining PM requirements. If a particular piece of equipment has additional or different requirements, these can be added. The data input screen for defining the PM requirements will automatically pull in the list of maintenance tasks, which should save a great deal of typing. When you make the selection to enter a generic maintenance task, you will be prompted to enter the code. It is suggested to make a letter/number combination based on the equipment and frequency of maintenance. For example, a 6 month inspection for a chilled water pump might be coded as CHWP180, meaning chilled water pump and 180 days as the frequency. Use whatever coding system is easiest for you. When the input screen is displayed, the other data fields are for a short name or description of the maintenance inspection,frequency in days, and 5 lines of 40 characters each to enter the maintenance tasks to be performed. Menu item #2 is for defining the PM requirements. The first prompt is for the user to enter a generic maintenance code or hit enter if this is a custom or different type of PM. The other input fields are for equipment identification number, equipment name or description,INITIAL DUE DATE, location,responsible trade, frequency of maintenance in days, and the 5 lines of tasks to be performed. A short explanation about the initial due date. This PC MECHANIC Page 14 is the date for the first time to do the required PM. Once this has been completed, the program will change the due date to a due date in the future, based on the frequency in days. Again, remember that if you entered a generic maintenance code, the frequency and 5 maintenance task fields will automatically be filled in by the program. Additionally, the PM reference number displayed on the monitor is generated by the computer and will be used later to call up specific records. Menu item #3 is for modifying or deleting PM requirements. The user is prompted to enter the appropriate PM reference number. The next prompt asks the user to decide to delete or modify the associated PM record. If the selection is to modify, the same data input screen is shown to the user as in item #2. To print out the scheduled PM work orders, select item #4 from the preventive maintenance system menu. The user will then be prompted to enter a start date and end date. Typically, the user will want to print out all of the scheduled maintenance for the coming week. So, he would enter today's date as the start date and a week from today or yesterday as the ending date. Remember that the program is designed to print out on 3.5" high paper and that the program will load the short BASIC program, which will set the printer for this size paper and condensed print. Many data field names will print out on the PM work order with a space after the name. This is for the maintenance worker to fill in any appropriate information, such as parts used, hours spent, employee identification number,remarks, etc. This information will be input later when the completed PM work order is updated. Menu item #5 allows the user to update completed work orders and transfer the information to the PM history file. The user is initially prompted to enter the PM reference number. The record is called up with the same data entry screen, however, there are additional input fields to enter information such as status, parts used, hours spent, remarks, etc. The status field should be filled with a "C" to indicate that it has been completed. This will flag the program to transfer the record to history and update the due date to a future date. The user will be asked if he wants to update the inventory system from the update completed PM screen. For a larger operation with a full time storeroom clerk, all transactions will probably be logged there. For smaller operations, the user can input the part number and quantity of parts used to automatically subtract these from inventory and charge the cost to the PM work order. The input of employee ID# and hours spent on the PM job is like the work order system and needs no further detailed explanation. Menu item #6 will display the submenu of available PM reports. These are fairly self-explanatory and will not be PC MECHANIC Page 15 detailed here. Menu item #7 returns the user to the preventive maintenance system menu. EQUIPMENT DATABASE SYSTEM ------------------------- To enter the equipment database system, select choice 4 from the main menu. The equipment database takes the place of a card system for recording nameplate and rating information on equipment. The choices available from the equipment database system menu are as follows: 1. Enter Equipment Records 2. Update Equipment Records 3. Delete Equipment Records 4. Print Hard Copy 5. Return to Main Menu Selecting choice 1 or 2 will allow the user to enter new equipment records or to update existing records. Most of the data field names are self-explanatory. Please note that not all fields are applicable to every piece of equipment, so leave them blank where appropriate. When the input or update screen has been filled in, the user will get a prompt at the bottom of the screen asking if everything is ok. The correct responses are "Y" for yes or "N" for no. If "N" is entered, the user can edit any incorrect entries. When "Y" is finally entered, the next prompt will be be a flashing "MORE" also at the bottom of the screen. Again, the correct responses are "Y" for yes or "N" for no. To delete equipment records, such as when an old piece of equipment is removed, select choice 3 from the equipment database system menu. The user is then prompted to enter the equipment identification number. After deleting a record, the user is prompted if he desires to delete more records. Answer "Y" or "N" to the flashing "MORE" prompt. Selection of choice 4 will allow the user to print out a copy of a specific equipment record. The user is prompted to enter the equipment identification number. After printing, he is again given the "MORE" prompt. Answer "Y" or "N". To return to the maintenance system main menu, select choice 5 from the equipment database system menu. PC MECHANIC Page 16 EMPLOYEE DATABASE SYSTEM ------------------------ To enter the employee database system, select choice 5 from the maintenance system main menu. The next set of menu choices presented to the user are as follows: 1. Enter Employee Records 2. Modify Employee Records 3. Delete Employee Records 4. Print Employee Listing 5. Print Seniority Report 6. Print Coming Review Dates Report 7. Exit to Main Menu To enter new employee records or modify existing records, select menu choice 1 or 2. The input data fields are for employee last name, first name, middle initial,employee identification number, social security number, date of birth, hire date, trade, hourly pay rate, date last performance review was done, home telephone number, name of a person to contact in an emergency, and telephone number of the emergency contact person. After filling in all of the fields, the user is prompted if everything is ok. Enter "Y" for yes or "N" for no. The next prompt is the flashing word "MORE", asking if the user has more records to enter or modify. The correct response to this prompt is "Y" or "N". To delete an employee record, select menu item 3. The user is next prompted to enter the employee's identification number. To print an alphabetical listing of all employees, select choice 4 from the menu. This lists most important information about the employee. This includes the identification number, which is needed for closing out work orders and preventive maintenance work orders. The seniority report can be printed out by selecting choice 5 from the menu. This lists employees based on date of hire, starting from the employee with the most time up to the most recent hire. The coming review dates report can be printed out by selecting choice 6 from the menu. This prints a listing of all employees who had their last annual performance review 11 months ago or later. This can be useful so that the supervisor or department head can adequately prepare for a meaningful review of his employees. To exit from the employee database system and return to the maintenance system main menu, select choice 7. PC MECHANIC Page 17 TIPS & POINTERS --------------- The following is a list of miscellaneous suggestions which you might find helpful. 1. On a daily or weekly basis, print a history listing by location and send to the originating department to indicate what work was performed for that period of time. 2. On a daily or weekly basis, print a listing of the outstanding work orders for review with the respective trade supervisors or foreman. 3. Enter work orders as received and update as completed. 4. At the end of E A C H D A Y, that's right, each day, do a backup of the PC MECHANIC subdirectory containing the database and index files. I can guarantee you now that someday, you are going to have hard disk problems. It is not a question of if, only when. When the day arrives that your hard disk decides to go off to "Never-Never Land", you will have a backup on hand that is no less current than yesterday. 5. On a weekly basis, print the aging report to see where you stand on completing the backlog. There should be very few old work orders unless there is a good reason for scheduling the work or you are waiting on parts. 6. On a weekly basis, print the PM jobs for the coming week. This could be done Friday afternoon or Monday morning. 7. It is suggested that you always work with the caps lock key on. I have tried to filter all keyboard input to uppercase, however, it is possible I may have missed a few here or there. This will lead to consistent input of your data. 8. Standard location names and trade codes should be developed. I discussed this earlier as a means to develop consistent data inputs. You will save some grief later on if you make a small effort to do this at the beginning. 9. Backup your data files daily. I will probably mention this again because I know what it's like to wipe out a hard disk. PC MECHANIC Page 18 GETTING HELP ------------ As I mentioned at the outset, I am available to assist any user of the PC MECHANIC, whether registered or not. My home telephone number is (312) 869-0114. If there is a real emergency, my wife can give out my work number, but I prefer to minimize this. I can also be reached through Compuserve, where I maintain an account. My user number is 71121,2014. Leave me a message on Easy Plex. Finally, if you would like to write, send any correspondence to: Michael R. Busman 820 Oakton Street Evanston, IL 60202 One last commercial message from the sponsors. Please remember that the PC MECHANIC is available as a low-cost, shareware alternative to expensive, complex maintenance management software. If you find it of use in your operation, do my wife a favor(remember the mink & diamonds fund) and register your copy. Lastly, I am always looking for comments-both favorable and downright nasty. Also, I appreciate suggested enhancements. Have fun you grease monkeys. PC MECHANIC Page 19 You can order directly from me using the registration form on the next page or from the Public (Software) Library (PSL) by calling 1-800-2424-PSL for orders only (call 713-665-7017 for questions about orders) or by writing: PSL P.O. Box 35705 Houston, TX 77235-5705 MC/Visa Accepted. For technical support, contact Michael Busman at the sources listed above. PC MECHANIC Page 20 REGISTRATION FORM ----------------- Name ____________________________ Title ___________________________ Company _________________________ Address _________________________ _________________________ City ____________________________ State ____ Zip _________ Telephone _______________________ Please register ____ copies of PC MECHANIC @ $50.00/copy for me. Total enclosed: $__________ Make checks payable to: Michael R. Busman