The present invention relates generally to systems for monitoring the refueling and maintenance of heavy work equipment, and more particularly to a method, system and apparatus for passively monitoring the maintenance and distribution of fluid products to heavy work vehicles in the field.
Due to the strenuous tasks and hostile environments in which work vehicles, normally referred to as “heavy equipment”, are required to perform, and the fact that such vehicles are normally operated at work site locations remote from the garage or maintenance yard at which the equipment is based, fuels, cooling fluids and certain lubricating resources must be delivered to the work site in order to maintain the life span of the equipment. Equipment of the type often referred to as track vehicles, large rubber tired vehicles, and stationary generators, crushers, etc., may include machinery such as tractors, bulldozers, earthmovers, etc. These types of heavy equipment are normally serviced at the work site by product maintenance and resource vehicles called lube trucks.
Lube trucks typically include an assortment of tanks, pumps, hoses and attaching connections or fittings for dispensing materials, which may include fuel, oils, greases, water, etc. Further, the lube vehicles may include an assortment of tanks and hoses for collecting waste or reclaimable products. The tank sizes often range from 30 to 2000 gallons or more.
Frequently, a plurality of such vehicles are serviced by a single lube truck, and often two or more lube trucks service several pieces of heavy equipment located in the same general area. These operations often result in several people being associated with the lube vehicles servicing several mobile equipment vehicles during one visit to the vehicle work site location. Consequently, it is often difficult to determine whether or not the correct materials (e.g. fuels, oils, greases, water, etc.) are being dispensed in the proper quantities to the correct receptacles. Further, the environments associated with these situations often make it difficult to trace the distributor, as well as keep good records of the amounts of the distributions. It is in many cases also difficult for the personnel, operators, owners and management of the heavy equipment being serviced to identify and keep track of the location and identity number or designation of a particular piece of heavy equipment to which the fluids are dispensed. Although attempts have been made to provide solutions to the problems alluded to, such solutions have to date been ineffective and user unfriendly in that they are difficult or complicated to use. Such systems frequently place expensive and sometimes fragile electronic equipment in the hands of workers uninterested or inadequately trained in the use of such devices. As a consequence, the devices are not used, are misused or even lost or damaged with the result that the intended purpose is frustrated.
Accordingly, it is an object of the present invention to provide an improved method and system, and associated apparatus, for passively monitoring distribution of consumable products to heavy duty work equipment.
Another object of the present invention is to provide a product distribution monitoring system that decreases the record keeping burden on the operator of a supply vehicle.
A further object of the present invention to provide a means for alerting an operator of an impending incorrect product distribution.
Yet another object of the present invention is to provide a means for signaling an operator during distribution to validate and acknowledge correct product distribution to a particular one of a plurality of discrete fluid receiving reservoirs.
Still another object of the present invention is to provide identification of the vehicles, receptacle ports, fluids and functionary personnel associated with the product distribution.
Another object of the present invention is to provide a multi-component, fluids distribution monitoring system that can be retrofit to an existing fleet of work equipment and lube trucks without requiring material modification of the fleet vehicles or fluids plumbing and supply systems.
Briefly, a preferred embodiment of the present invention includes a method and apparatus for passively monitoring the distribution of fuel and lubrication fluids to heavy work equipment vehicles or stationary equipment such as bulldozers, draglines, scrapers, loaders, etc. The system includes means for identifying and recording the identity of the dispensing vehicle, the dispensing operator, the location of the dispensing vehicle, the receiving vehicle, the receiving port on the receiving vehicle, the type of fluid dispensed, the quantity of fluid dispensed, and the time of the dispensing. The system also includes means for verifying that the proper fluid is being dispensed to a particular port. Use of the system does not require substantial modification of existing distribution equipment or interfere with normal servicing operations.
An advantage of the present invention is that it provides a system for passively monitoring the dispensing activity of a fluids servicing vehicle as it replenishes heavy work equipment fluids reservoirs and delivers lubricants to specified required points.
Another advantage of the present invention is that it provides a system for assisting the operator of a servicing vehicle with records keeping.
Still another advantage of the present invention is that it provides a means for instantaneously verifying that the port to which a particular fluid is applied is that intended.
A further advantage of the present invention is that it provides substantially all of the records keeping input required for efficient operation of a product distribution system without increasing the operator workload or interfering with the normal conduct of the dispensing operation.
These and other objects and advantages of the present invention will become apparent to those skilled in the art upon review of the following specification, the accompanying drawings and the appended claims.
Referring now to the drawings, a simplified embodiment of a system for passively monitoring the maintenance and distribution of fluid products to heavy work vehicles in accordance with the present invention is illustrated schematically in
The track vehicle 10 is shown to include a plurality of fittings or ports l3, in some cases arranged in an array or group 16, for receiving fuel, lubricating oils, coolants or other fluid products from the lube truck 12. In accordance with the present invention, an ID plate 14 is affixed to the vehicle 10 proximate a corresponding port and is encoded. As will be further explained below, each ID plate 14 will carry an electromagnetically readable code identifying at least the carrying track vehicle, the associated port, and the type of fluid to be dispensed into the associated port. The lube truck 12 includes a plurality of hoses 18 that distribute the fluid products from corresponding tanks 20 that store each product. Flow cells 22 gauge the amounts of fluid product dispensed from each tank 20 to its associated hose 18, and ultimately to a particular port 13 in the track vehicle 10. The amounts of product that the flow cells 22 or other flow measurement devices measure as having been dispensed are normally accumulated and retained in counters and/or communicated to some type of onboard data collecting system. However, although the quantities of the fluids or other products distributed are measured, no means is usually provided to assure that the fluids were properly distributed to the proper vehicle, or to the proper port on a particular vehicle. It is this deficiency in the prior art that is addressed by the present invention.
More specifically, in accordance with the present invention a passive monitoring system is provided which includes a programmable monitoring unit 23, a handheld sensor device 30, and a plurality of ID plates 14 mentioned above. The monitoring unit 23 may include a computer 24, which may be accessed by an operator through another computer, such as a laptop 26, or a front panel 28 with a keypad for allowing an operator to communicate with the computer, a printer 29, a receiver 38, an on/off switch 39, and a horn 40. The computer 24 is adapted to separately monitor the operation of each flow cell 22 and record the quantity of fluid passing therethrough from a tank 20 to a hose 18. Where a flow meter, or flow cell, does not exist on the lube truck, an appropriate flow measuring device may be installed at each hose line on the lube truck. Computer 24 also compares flow cell ID (which is associated with a particular tank, and therefore identifies the type of fluid supplied to a particular hose 18) to the type of fluid read from the ID plate associated with the port 13 to which the hose 18 is connected, and if the two do not match, the computer causes the horn 40 to sound, and a record of the incident including all inputs is preserved.
A handheld ID plate reader device 30 is provided for extracting information from each ID plate 14. Included in the handheld device 30 is at least an ID plate reader 32, a lube truck identifier 34, and an operator identifier 35, as well as a transmitter 36. The transmitter 36 sends information from the ID plate reader 32 and the lube truck identifier 34 to the receiver 38 included in the lube truck 12. The receiver 38, in turn, routes the information to the computer 24 in the lube truck 12. The computer 24 may communicate a signal to a horn 40, or some other type of annunciator that will emit a sound confirming or denying distribution of the correct product to a particular port 13 in the track vehicle 10. Alternatively, the hand held device may itself include a sound emitting device 33 for emitting a sound which can be matched or otherwise related to the lube truck signal. Note that since the subject apparatus is entirely passive and does not perform any control function, the operator may choose to ignore the alarm warning of distribution of a product to the wrong port, and continue to distribute the product despite the alarm warning. However, as will be discussed below, his error will be tracked and recorded and he may subsequently be called upon to explain his oversight or intentional noncompliance.
In the illustrated embodiment, the ID plates 14 may number from one to sixteen, enabling the monitoring of up to 16. products. Each ID plate includes at least a product identifier, a track vehicle identifier, and a port identifier. Preferably, the ID plate is comprised of metal with an array of magnet receiving apertures formed therein. As discussed below, particular combinations of magnets in the array apertures, as well as their respective polarities signify the ID numbers. This is to say that some of the apertures may have magnets embedded therein and some apertures may be without magnets. Furthermore, some of the magnets may be polarized opposite to others. In any event, the array in each ID plate is configured to present a readable code uniquely identifying at least the three items indicated above. The plate in which the apertures are formed may be of aluminum, steel, a suitable plastic, etc. Alternatively, the ID plate may include a barcode or some other form of identifier encoded to identify the three items listed above. In this embodiment, the plate covers several square inches and is less than 0.25 . inches thick. Further, one of the several plates may be utilized to identify a port at which engine run hours may be read.
In the illustrated embodiment, the computer may utilize StarRanger ViewPro software of the type manufactured by Scientronix, Inc. of San Jose, Calif.
One or more hand held reader devices may be associated with each lube vehicle. Preferably, there are two reader devices, one for the operator of the lube vehicle and one for the journeyman. In this embodiment, both the operator and the journeyman would be assigned a personal reader device preprogrammed to output, in addition to the read ID plate information, a lube truck identifying code and a user identifying code. In use, the hand held device is held against the particular ID plate, thereby extracting the identifiers encoded on the track vehicle plate. The data is then transmitted to the receiver on the lube truck unit along with the operator/journeyman ID.
In this embodiment, the housings for the units 42 include suitable cabling including a bundle of flow signal carrying lines leading to a plurality of jacks or sensors (for connection to the respective flow control and measurement devices on the carrying lube truck) for extracting flow information relating to each supply and/or collection hose. The housing face may include a plurality of hose line identifiers, or indicators, 46 a corresponding plurality of on/off switches 48 for selectively activating and disabling (turning off) each flow signal line, an upper row of indicators 50, each corresponding to one of the hose identifiers 46 and operative when illuminated to indicate that the corresponding hose is receiving (accepting) fluids, and a similar lower row of indicators 52, each corresponding to and associated with one of the hose lines to indicate that its corresponding hose is dispensing fluid. One of the indicators 46, designated 47 in
Each lube truck unit 42 also includes a front panel 52 for allowing the entry of information, a laptop 54 unit including a floppy disk drive 56 and a printer 58, and a global positioning system (GPS) 60 for generating and inputting a location signal. The GPS signal indicates the position of the vehicle, as well as the time associated with a dispensation at that position. Each unit 42 is equipped with at least one handheld device 62 for use by the operators of the carrying lube truck. Each hand held device 62 includes means for entering an ID identifying the operator and/or journeyman as pointed out above. One or more lube trucks may service multiple track vehicles 64.
As also discussed above, the track vehicles 64 include ID plates 66 encoded to identify and provide information about the track vehicle and the particular port being addressed by the lube truck operator. At least one identifier plate 68 on the track vehicle includes means for indicating engine run time hours and thus is not necessarily associated with a fill or collection port.
The identifier plates on each track vehicle may be color coded. Similarly, the nozzle on the pump on each hose from the lube truck may be color coded to correspond to the identifier plate affixed next to a corresponding fill port. This type of color-coding system may assist the operator in connecting the correct hose to the correct port by matching the nozzle color to the color of the identifier plate on the track vehicle. Any such matching system may help to ease the operator's task.
Code plate 106 is likewise configured to have an outer perimeter corresponding to the shape of aperture 104 so that when the code plate is installed in the frame 102, it too will be properly aligned. The code plate 106 may be retained within the frame 102 using any suitable mechanical or adhesive fastening means. A suitable adhesive coating applied to the back surface is the preferred fastener.
Plate 106 is provided with an array of cylindrical openings 112 for receiving a plurality of cylindrical magnets that when appropriately positioned and/or oriented (polarized), in predetermined areas of the plate, they will collectively evidence codes that identify (1) the track vehicle, and (2) the port to which the ID plate is associated. The type of material or product that is to be introduced into or removed from the reservoir linked to the port is identified in a data table associated with the port. Alternatively, the position of the magnets may evidence codes that identify the material or product that is to be introduced into or removed from the reservoir linked to the port. The magnets may be any shape suitable for use with the present invention. For magnet and plate material details of a similarly coded device, reference is made to the U.S. Pat. No. 3,995,145 of Harris, III, the entire disclosure of which is expressly incorporated herein by reference.
Any other method of coding the ID plate may be utilized that is suitable for use with the present invention. For example, the code may be electromagnetically coupled into a magnetizable strip or strips contained in or affixed to the ID plate. Similarly, a bar code or the like may be utilized.
Turning now to
Reader plate 122 is formed of any suitable plastic or metallic material and has an array of openings 124 formed therein with the centers of the openings being substantially aligned with the center-lines of the magnets 112 of ID plate 106. The diameters of the openings 124 are however somewhat larger than the diameters of their magnetic cylinders so as to provide receptacles within which Hall-effect sensors or other magnetic field responsive devices 126 may be mounted. Positional within container 114 and beneath plate 122 is a circuit board 128 that carries electrical components capable of converting electrical outputs generated by the sensors 126 into the coded signals read from an ID plate, and for transmitting such signals via an antenna 130 back to the lube vehicle receiver. Power for the reader is supplied by batteries 132. However, any other charging source that is suitable for use with the present invention, such as a vibration charging mechanism, may be utilized to supply power to the reader. The lube truck ID and operator ID may be input to the electronics by means of micro-switches 134 that can be preset at the time it is assigned to the operator. The switches may be externally accessible as illustrated, or may be internal and inaccessible to the user of the device. Further, any other method of inputting coding to the electronics suitable for use with the present invention may be utilized.
In operation, an operator takes a dispensing hose or a receiving hose to a track vehicle. The operator connects the dispensing hose (or the receiving hose) to a port located on the track vehicle and positions his reader device over the corresponding identifier plate 66 on the track vehicle. In response, an ID signal is transmitted to the lube truck unit as the operator commences the fill or extraction operation. Transmission may be via radio waves, light (such as infrared), audio, or any other suitable means of communication. However, only the operator's lube truck will accept the transmitted signal from the hand held device 62. The horn 72 on the lube truck will sound to indicate that the dispensing hose or receiving hose is attached to the correct or incorrect port. If the hose is attached to an incorrect port, an alarm will sound and the product may or may not continue to be dispensed, depending on the conduct of the operator. In other words, since the present invention is passive and does not control operation of the lube truck servicing, the product may continue to be dispensed should the operator choose to ignore the alarm and leave the switch in the ON position. However, the truck unit 42 will record information associated with the transaction.
In this embodiment, the lube vehicle sounds a horn at a frequency corresponding to the particular hose (type product) being used, followed by a horn frequency corresponding to the product type intended to be provided to the particular port as identified by the track vehicle ID plate (Block 152). If both sounds match (Block 152), the operator causes the fluid to be dispensed from the lube vehicle to the track vehicle port (Block 154). Alternatively, the hand held device may itself emit a sound which can be matched or otherwise related to the lube truck signal. The signal may have the same frequency as the signal emitted from the lube vehicle, and further, the signal may be specific to the particular port. If the sounds do not match (Block 152), the operator then inspects the port selected (Block 156) and again places his hand held device on the ID plate located next to the port (Block 148). The operator may choose the same port or a different port, depending on whether he believes he initially made a mistake or that the system experienced a transmission error. The information will be retransmitted when the hand held device is reapplied to the plate and the process is repeated (Blocks 148, 150, and 152).
Once the fluid begins to dispense (Block 158), the system checks to see if it is being dispensed from the correct flow cell (Block 160). If the fluid is being dispensed from the correct flow cell, the fluid continues to be dispensed (Block 162). If the fluid is not being dispensed from the correct flow cell, an alarm sounds from the lube vehicle (Block 164) and the operator may cause the dispensing of the fluid from the flow cell to cease (Block 166). The operator can then again inspect the port selected (Block 156) and connect the hose to a different port, if appropriate, until the system confirms a correct connection.
As fluid is dispensed, the system periodically determines whether or not the “full” fluid level has been reached (Block 168). If the full fluid level is reached, dispensing of the fluid to the port (Block 170) is stopped. If the full fluid level has not been reached, the operator will continue to dispense fluid (Block 162). The system may also determine whether or not all of the ports have been serviced (Block 172). When all the ports have been serviced, the hose is returned to the lube vehicle (Block 174). If the fluid level at a particular port is not full when the supply available from the currently used hose is exhausted, the operator will return the hose to the vehicle and, if available, use another hose dispensing the same fluid and continue the dispensing process (Block 162).
Once all of the fluid levels are full, the operator will return the hose to the lube vehicle, and a report may be generated. The report may include the track vehicle ID, port IDs, port fill amounts, “wrong port” alarm, lube vehicle ID, operator ID, site location, run time hours, the date, and start and stop times. The operator can review the report, and if the readings on the report are good, the operator can turn off, or deactivate, the equipment. If the report includes bad readings, or print errors, the operator can make notes that reflect these errors. A floppy disk, memory stick, radio or telephonic transmission, or any other suitable means, may be utilized to transfer the data to an enterprise system at another location.
Each lube truck dispense port may be assigned a separate level in the software program. Since levels execute asynchronously, multiple products can be delivered at the same time. When the controller receives the start transaction digital signal, the level associated with that digital input will become active and save the analog values from the track vehicle in integer variables and real variables that are used only that level. A formula will add 0.5 . to round off each real variable that has to be treated as a whole number.
When the data from an ID plate on the track vehicle is transmitted from the hand held device to the lube truck, the receiver parses the data and attributes it to the appropriate port. The track vehicle information is stored in the controller.
When the operator finishes dispensing the product, an end of transaction signal is sent to the controller. A signal is sent to the computer to log the information stored in the controller for that particular port. The controller can keep running totals of the amounts of fluids delivered at each port.
Each product may be logged to a separate file. For example, if a lube truck includes eight dispenser ports, there may be eight files. Each record may represent a transaction, such as gas fill up, etc.
Referring now to
Each hand held unit 202 is assigned to an operator by the office manager, and the assignment is registered in the system office database using a hexadecimal ID number that is permanently emblazoned on a plate affixed to the back of the hand held unit. The unit reads ID plates and run hours and automatically transmits the information to its associated lube truck operator panel when it is placed on an ID plate or run hour logger. The hand held unit is also used to obtain authorization for a dispense in the case that no ID plate is associated with a particular fill port. An operator ID plate can also be assigned to an equipment operator and used to identify the operator at a fueling station.
As will be further explained below, the ID plates 206 and run hour logger 208 are affixed to and carried on a piece of work equipment, such as the loader illustrated at 214, while the operator's panel 200 and meters 210 and 212 are carried on a lube truck such as that illustrated at 216. A GPS receiver (not shown) installed in the panel 200 provides wireless linkage to the GPS satellite system 217. Wireless communication of information obtained from the ID plates 206 and Run Hour indicator 208 using the hand held reader/transmitter unit 202 is communicated to an rf receiver (not shown) also contained within the panel 200, and communication of data between the panel 200 and the office PC 220 is accomplished by use of a memory stick 204 that is physically carried by the operator between the lube truck and system office.
The memory stick 204 is a commercially available solid state memory device used to transfer work orders from the office PC 220 to the lube trucks, and to return event logs from the lube trucks to the office PC. More specifically, the memory sticks 204 are used for bringing the entire fleet database (all lube trucks, work equipment, site locations, etc.) from the office computer to the operator panel of each lube truck at the beginning of the day, and for taking the dispense information back to the office computer at the end of the day. When any mobile component (panel 200) carrying the LubeRanger system software is operational, a memory stick 204 must be connected to a USB port (socket) 205 on the front side of the operator panel. In the system office, the memory stick 204 is inserted into a USB port containing receptacle on the office PC.
In
An embodiment of the operator panel 200 is illustrated in
The operator panel 200 is mounted on a stand in the truck cab (not shown) to provide easy access to the operator as he carries out his duties. As depicted generally in
The panel is electronically related to the associated truck by a serial number generated by an electrical identifying device called a “dongle” (not shown) that is electrically connected to the processor contained within the panel. The dongle number is entered into the system program in the office PC before the dongle is installed in the panel of a specific lube truck, and is recorded in an attached memory stick to identify the source of the lube event data carried thereby for report to the office PC. As indicated above, the panel also includes a commercially available GPS receiver (not shown) that receives data signals from the global positioning satellites via the antenna 218 and provides geographical coordinates identifying the position of the lube truck. A magnetic mounting plate (not shown) is typically used to mount the GPS antenna to the roof of the truck cab. An antenna cable connects the antenna to a third connector 244 on the back of the panel 200. The rf network antenna 201 is also mounted to the roof of the cab and is connected by another antenna cable to a fourth connector 246 provided on the back of the panel 200.
As pointed out above, the distribution box 228 acts as a junction box for the connection between the panel 200, the Diesel flow register 210 and fluid flow meters 212, as well as the flashing lamp 230 and horn 232 that are mounted on the top side of the truck. Strong magnets are normally used to mount the lamp and horn on top of the truck. As will be further discussed below, the horn and lamp are used to provide audio-visual feedback to the operator using the hand held unit.
A length of cable 211 having a connector 213 on its distal end extends from the distribution box 228 and connects to a short cable attached to the fuel register 210. Similarly, short cables 215 with end connectors 217 are used to couple the flow meters 212 to the distribution box. The flow register 210 is an electronic device that is mounted on top of the truck's fuel flow meter (not shown) and is a “smart” device that indicates and logs the flow of diesel fuel dispensed from the truck.
As shown in
The run hour logger/ID unit 260 shown in
A block diagram generally illustrating the internal components of the logger 260 is shown in
The sensor 270 is typically a piezoelectric device that in the presence of vibratory motion, such as that caused by a running engine, is caused to flex and generate a small oscillating electrical signal. The frequency of the signal is determined by the resonance frequency of the mechanical self oscillation of the sensor. The small oscillating electrical signal generated by the sensor is then amplified by the amplifier 272 to an appropriate digital signal level for input to the microcontroller 274. The input digital signals define units of time (“time signals”) that are registered by the controller as it uses a special algorithm to totalize the input time signals and generate a “run hour signal” that is proportional to the sum of the time signals generated during the time that the engine vibration is detected. The totalized or accumulated run hour value, in the form of a serial data signal, is then stored in flash memory in the microcontroller 274. Upon actuation of the magnetic reed switch 279, and as will be further explained below, the microcontroller 274 is caused to transmit the totalized run hour signal to the modulator 276 which in turn modulates its carrier frequency with the serial data signal output from the controller. The modulator output is then impressed upon the copper plates 277 and 278 thereby allowing the run hour value to be read and transmitted to the truck mounted operator panel 200.
Logger 260 also includes a second set of capacitive plates 280 and 281 upon which an externally generated signal value can be impressed, amplified by an amplifier 28, demodulated by a demodulator 284 and input to the controller 274 where it is used to preset, or reset, the engine run time value stored therein.
In
In
In addition to providing a control function for causing the logger 260 to output data including a run hour value, closure of switch 279 by the magnet of a hand held unit can also be used to cause microcontroller 274 to generate a wakeup signal in the form of an electronic impulse that can be communicated through the plates 277, 278 to the hand held unit and sensed thereby to cause it to wake up from its SLEEP state.
The hand held unit 290 also carries electrical components capable of converting electrical outputs generated by the array of sensors disposed beneath the receptacle 294 into the coded ID signals to be read from the ID plates 256 or 262, and for communicating such signals to the microprocessor 304, so that they too can be transmitted via transmitter 306 and antenna 308 back to the lube vehicle receiver in panel 200. Power for the unit 290 is supplied by batteries. However, any other charging source suitable for use with the present invention, such as a solar charger or vibration charging mechanism may be utilized to supply power to the reader/transmitter unit. The lube truck ID and/or operator ID may be also be input to the unit 290 and stored in electromagnetic memory 312 using well known signal transfer methods, or may be manually input to the unit via micro-switches (not shown) that can be preset at the time the unit is assigned to the operator.
Another portable unit that may be provided for the operator's use is shown generally at 320 in
In operation, the programmer 15 may be used for stand-alone reading of the ID plates and run hour loggers (i.e., without transmission back to the lube truck) as well as for presetting the run hour logger hour values. To set the run hours, the user will turn ON the programmer by pressing the ON/OFF key on the keypad 322, place programmer on the logger unit and wait for the acknowledgement beep. The beep indicates that the programmer has successfully read the logger unit's ID and current run hours. The logger unit's ID and the current run hour value are subsequently displayed on the programmer screen 324. The programmer is then removed from the logger unit, the ‘Set’ key is pressed and the run hours are set to the desired value using the arrow keys. To save the new run hour value, the programmer is placed back on the logger unit and the ‘Save’ key is pressed. The new run hours value will now be transferred to the logger unit. If the run hour setting was successful, the programmer will again beep and the new reading will be read from the logger unit and displayed on the screen 324.
The recommended hardware and software to be included in the data processing and control components of the system include:
The present invention is implemented using LubePro™ software that is part of the LubeRanger™ mobile fluid dispensing management system for construction equipment sold by Scientronics, Inc. of San Jose, Calif. The LubePro™ application is created in Microsoft® Access and runs under the Microsoft® Windows operating system in the computer contained in the operator panel.
LubeRanger™ is an integrated hardware and software system for processing construction site work orders assigned to lube trucks. It tracks fluid dispenses and equipment relocation, creates reports and makes data available to the enterprise system.
The LubePro™ application stores information about sites, equipment, operators and lube trucks and has an intuitive user interface that makes it easy to enter and maintain the information in the data tables. The program also receives collected data from the lube trucks and provides many reports to help manage the fuel and other fluids delivery process. Daily, weekly and monthly client delivery reports and summaries are included in the package.
The “Backup” function uses ‘Access Export’ and creates all of the LubeRanger tables in comma delimited ASCII format. This data may be imported into any other compliant database. This provides a simple interface to an enterprise system.
The “Export” function also uses “Access Export” and creates only the Event Table in comma delimited ASCII format. This table may be stored on a network drive or anywhere convenient for accessing by other programs.
As previously described, the memory stick 204 is a commercially available solid state memory device that is used for physically transporting data between the lube trucks and the office computer (PC). The memory sticks are managed in the office using 3 “baskets”. The first basket is the “IN” basket. At the end of each shift, the lube truck operators put the memory sticks with the daily lube events recorded therein into the “IN” basket. The equipment manager then takes the sticks from the “IN” basket, transfers the lube events data from all sticks into the office PC and puts the memory sticks in the “DONE” basket. After all of the sticks have been received and the data downloaded to the PC, the equipment manager creates new work orders, uploads the database to each of the memory sticks, and then puts the memory sticks in the “OUT” basket. At the start of the next shift, the lube truck operators take any one of the memory sticks from the “OUT” basket for insertion into their panel port.
The work orders define the sites and work equipment that each lube truck must service. Since all of the memory sticks are interchangeable and contain the same information, each lube truck operator will gain access to his work order as soon as he attaches a memory stick to the appropriate port on his operator panel. He is then in a position to commence his work day. During the shift, information about dispenses and other lube truck actions are automatically transmitted to and written into the stick in the lube truck. At the end of the shift, the stick is unplugged from the lube truck operator panel and carried back to the office and placed in the “IN” basket. The equipment manager must receive the data from all of the sticks and load it into the office computer database each day so that he can update the database and generate new work orders for transfer to the sticks.
The equipment manager specifies and manages equipment, fluids, sites, lube trucks, and operators. He also adds new equipment, fluids, sites, lube trucks, and operators into the database and creates daily work orders for each lube truck. The work orders contain a list of service sites to be serviced by each operator and lube truck. All work orders in the system are uploaded into each memory stick by individually connecting each memory stick to the USB port of the PC and sending the work orders to the stick. After the work orders are saved on the sticks, the sticks are placed into the “OUT” bin. The operators can then take any stick from the “OUT” bin and carry it to their lube truck.
Lube events are operations performed by the operators of the lube trucks during a particular shift. Lube events can be the dispense of fuels, oils or other fluids, or the collection of equipment run hours readings, controller start-up times, error messages, changes to ID plates, and data obtained from the ID plates by the hand held units, etc. The lube events input to each operator panel in each lube truck are written into the memory stick in that lube truck. Each event is logged and eventually received by the office database when the memory sticks are returned at the end of the shift.
Once the event data from all of the memory sticks is uploaded and the database is updated with the new events various reports can be produced.
To start-up the LubeRanger, the manager double clicks on the LubeRanger icon on the desktop of the office PC and the “Main Menu” appears as illustrated in
Basic Management
The Basic Management file contains the basic data of the system components. The “Basic Management” screen is a portal to a set of editing screens through which the equipment manager can maintain the LubeRanger data base. Data is entered in the order indicated by the numbers on the buttons.
1. Operator Window
The operator of the lube truck is the person who dispenses fluids, reads equipment run hours etc. The operator table consists of information relating to the lube truck operators and equipment operators. The equipment operator's ID must be entered if he fills his own equipment at a fueling station. In the case of equipment operators, the hand held ID field is used for the operator plate ID. Clicking on “1 Operator” in the “Main Menu” causes the “Operator List” illustrated as
Clicking on “New” on the “Operator List” causes the “Operator Edit” form (
To change operators the manager will select the new operator's name on the ‘Operator List’ form (
To delete an existing operator he can select the operator's name on the ‘Operator List’ form and click “Delete” to remove the selected Operator. Clicking on “Exit” on the “Operator List” form returns the “Main Menu” (
2. Port Type
The Port type is the name of a work equipment port. Every port on the equipment has a name and ID. The port type names and IDs remain the same for different equipment.
Clicking on “2. Port Type” on the “Main Menu” causes the “Port List” form (
A fluid can be fuel, oil, water or other liquid that is dispensed from lube truck to a work equipment.
Clicking on “3. Fluids” on the “Main Menu” opens the “Fluid List” form (
Clicking on “New” on the “Fluid List” form opens the “Fluid Edit” form (
Clicking “Save” stores the data in the fields and returns the screen to the “Fluid list” form. Clicking “Cancel” returns the screen to the “Fluid List” form without saving.
Selecting a fluid on the “Fluid List” form, or clicking “Edit” (or double clicking on the selected fluid) causes the “Fluid Edit” form to open. Upon changing the desired properties clicking “Save” closes the “Fluid Edit” form.
To delete a fluid one selects the fluid on the “Fluid List” form and clicks “Delete” to remove the selected fluid.
Clicking “Exit” on the “Fluid List” form returns the screen to the “Main Menu”.
4. Site
A site is the place where the construction equipment is located and serviced.
Clicking on “4. Site” on the “Main Menu” causes the “Site List” form (
To add a new site, the longitude, latitude and site size should be known. One way to acquire site coordinates is to use a handheld GPS unit to acquire coordinate readings at the site center.
Note that the coordinate format and radius are specified as follows:
The following fields must be filled in on the “Site Edit” form:
To change an existing site one select a site on the “Site List” form. (
To delete an existing site one selects the site on the ‘Site List’ form and clicks “Delete” to remove the selected site.
To exit to the Main Menu one clicks “Exit” on the “Site List” form.
5. Lube Truck
Lube Trucks carry and provide the fluids for the work equipment.
Clicking “5. Lube Truck” on the “Main Menu” causes the “Lube Truck List” form. (
Clicking on an item in the “LubeTruck List” form causes the “LubeTruck Edit” form (
To add a new tank, one clicks on “New” on the “LubeTruck Edit” form and fills in the following fields:
To change an existing tank, the manager selects the tank on the “Lube Truck Edit” form (
To delete a tank one selects the tank on the “Lube Truck Edit” form and clicks “Delete”.
To change an existing Lube Truck the manager selects the lube truck on the “Lube Truck List” form, clicks “Edit”, or double clicks on the selected lube truck, to open the “Lube Truck Edit” form and change the lube truck properties.
To save Lube Truck and tank changes one click “Save All” to confirm the changes to the lube truck on the “Lube Truck Edit” form and return to the “Lube Truck List” form. Pressing “Cancel All” returns the screen to the “Lube Truck List” form without saving any changes.
To delete an existing Lube Truck, the manager selects the truck on the “Lube Truck List” form an clicks “Delete”.
Clicking “Exit” on the “Lube Truck List” form returns the screen to the “Main Menu”.
6. Equipment
To edit the list of work equipment intended to receive the fluids from the lube truck one opens the Equipment List by clicking on ‘6. Equipment’ on the “Main Menu” (
To add new equipment click “New” on the “Equipment List” form to open the “Equipment Edit” form. (
To add a new port, click “New” on the “Equipment Edit” form to enter new data by filling in the following fields:
To change an existing port, select the port on the “Equipment Edit” form and click “Edit”, or double click on the selected port. Then change desired port properties and click “Update Port List”. This updates the list. It does not update the database. Repeat steps 1 . . . 4 until all desired ports are updated.
To delete a port, select the port on the “Equipment Edit” form and click “Delete”. Press “Save All” to add the equipment and its ports and return to the “Equipment List” form. Then press “Save All” to add the lube truck and its tanks to the database and return to the “Equipment List” form. Press “Cancel All” to return to the equipment list form without saving any changes.
To change existing equipment, select the equipment on the “Equipment List” form and click “Edit”, or double click on the selected equipment, to open the “Equipment Edit” form. Then change the equipment properties.
To save equipment and port changes, click “Save All” to confirm the changes to the equipment on the “Equipment Edit” form and return to the “Equipment List” form. Press “Cancel All” to return to the “Equipment List” form without saving any changes.
To delete existing equipment, select the lube truck on the “Lube Truck List” form and click “Delete”.
Exit to Main Menu by clicking “Exit” on the “Equipment List” form.
7. Maintenance Type
This is a list of different types of maintenance that need to be done at predefined run hour intervals. To open the ‘Maintenance Type’ list click ‘Maintenance Type’ on the Main Menu. The ‘Maintenance type list’ form will open (
This window is used to define what types of maintenances need to be done to a particular work equipment. Clicking on ‘Equip Maint’ in the Main Menu causes the Equipment list (
How the Preventive Maintenance works in LubeRanger The following is a step-by-step description of how the Preventive Maintenance works.
The Jobs created in the database can be to assign unauthorized dispenses where the equipment information is not available. If the equipment does not have an ID plate, then the lube truck operator can dispense the fluid without authorization and assign the dispense to a job afterwards. This is accomplished by clicking “9. Job” on the Main Menu to open the “Job list” form (
Clicking “New” on the “Job List” form causes the “Job Edit” form (
To change an existing job, he can select the job on the “Job list” form (
To delete an existing fluid, he selects job on the “Job List” form, and clicks on “Delete” to remove the selected job.
Clicking “Exit” on the “Job List” form returns the screen to the “Main Menu”.
The work order is created by the manager on the office PC and sent to the memory sticks each day for delivery to the lube trucks. All of the site and equipment information in the system is sent to each lube truck allowing any truck to be dispatched or re-routed to any site.
To create a Work Order the manager opens the Work Order List (
To create a new work order, the manager clicks “New” on the “Work Order List” form to open the “Work Order Edit” form (
To select a particular Lube Truck and Site, he double clicks on the desired lube truck in the “Select Lube Truck” box. To select sites that have to be serviced by the lube truck, he double clicks on the site names in the “Site List” box. More than one site can be selected. He then clicks “Save All” to save the work order and exit to the “Work Order List” form, or clicks “Cancel All” to return to the “Work Order List” form without saving.
“Clone” is used if there is a need to make a new work order that is similar to an existing one. This is a quick way of creating a new work order for a lube truck that has to repeatedly return to the same site(s). This is done by selecting equipment on the “Work Order List” form, clicking “Clone”, or “Edit”, on the selected work order to open the “Work Order Edit” form, changing the sites or lube truck ID on the work order, and pressing “Save All” to save the work order and return to the “Work Order List” form.
To delete an existing work order, the manager must select a work order on the “Work Order List” form, and then click “Delete”.
To exit to Main Menu click “Exit” on the “Work Order” form to return to “Main Menu”.
Send Work Order
To send a work order to a lube truck, the manager connects the memory stick to the office computer's USB port and clicks “Send” on the “Main Menu” to open the “Send Work Order” dialog box (
Lube events are stored in the memory sticks in the lube trucks and received from the memory sticks by the office PC.
For the office PC to receive the events data, the memory stick must be brought from the lube truck an inserted into the USB port on the office PC The manager clicks “Receive” on the “Main Menu”, and clicks “OK” when the memory stick is inserted, and the “Receive Lube Data” form opens. (
To delete old events, he clicks “Delete Old Events” on the “Main Menu” (
NB! Reports are available only up to the oldest event!
To create a dispense event manually, the manager presses the ‘Create Dispense’ button on the Main Menu to open the “Create Dispense” window (
The database should be backed up on a regular basis. The backed up database should be stored in both the PC and in the removable storage device (memory stick). To perform a backup, the manager clicks “Back Up Data” on the “Main Menu” and the “Select back Up Folder” form opens (
Data may also be restored. It is important that the correct folder be used to restore the data because the basic management data is replaced with the data in the archived folder. Data is restored when previously backed up data has to be used for database or reporting. Before using the Restore Data function a Backup of the current database data should be made, otherwise current data in the database will be lost!
Clicking “Restore Data” on the “Main Menu” causes the “Select Restore from Folder” form to open (
User access
The LubeRanger database works in two modes; “User” and “Administrator”. In User mode the database can not be edited, but the reports can be viewed. Using the administrator password, the manager can switch to the Administrator mode and the database can be edited.
User mode—The LubeRanger database is in user mode by default. User mode means that the database can not be changed or restored, but the data can be viewed and backed up.
Administrator mode—this mode gives full access to the administrator to change data, restore and delete. To change to administrator mode, one has to enter the administrator password. To switch to Administrator mode, one must click ‘Enter Password’ on the Main Menu. If there is no administrator password set, the “Enter Password” window (
This selection on the Main Menu produces documents that can be used to analyze what is happening in the field. Reports tie together the basic data (lube trucks, sites, fluids etc) with the lube events (dispenses, run hours, etc).
Clicking “Reports” on the “Main Menu” (
If the report is displayed on the screen, it can be printed by simply clicking “Print” on the “File” menu in the top left corner of the Windows desktop. The following is a brief list of the reports that are available:
Equipment Reports
Equipment
Equipment Ports
Fluids
Run Hours
Equipment Dispense
Equipment at Site
Equipment Moved
Equipment Fluid Cost by Site
Maintenance Due
Maintenance History
Site
Selection Site, Start date, End date
Information of sites serviced by operators.
Alarms
List of status change events.
List of all port types with properties.
Lube Trucks
Information about selected lube truck ports.
Logged lube trucks' status information.
List of dispenses from the selected lube truck.
Logged information about operators.
Limited Lube trucks' Status Report.
Daily Routine
Operation of this embodiment of the subject invention may be understood from the following typical example of the daily routine followed by a lube truck operator after he arrives at the system office, picks up a memory stick, and goes to his lube truck.
Upon entering the truck cab he inserts the memory stick into the operator panel stick port 205 (
On startup, the Home Screen 207 (as illustrated in
When the system is started and the LubeMonitor window 207 is as displayed in
As an aid to the operator, the LubeRanger™ constantly tries to determine the current site of the equipment listed on the work list screen according to the GPS coordinates. Status information on the current site is displayed in the ‘Current site’ box on screen 207. If the “Site Name” box displays a site name then the lube truck is within that site's range and the distance to that site's center is displayed in the ‘Distance to center’ box. If the “Site name” box displays the text ‘no GPS fix’, no Global Positioning System fix has been acquired. In that case the LubeRanger™ can't determine the lube truck's current position. If the “Site Name” box displays the text ‘no Site’, a Global Positioning System fix has been acquired and the LubeRanger™ can determine the current position but the lube truck is not within a defined site range.
If the current site is not determined automatically, then the site has to be selected manually as follows:
Under “Site selection” (
At this point the operator places the handheld unit on the operator panel start plates 247,249 as suggested in
If the dispense is to be made at a fueling station and the equipment operator needs to be identified, then the operator's personal ID plate has to be read prior to dispense. In doing so, the operator's hand held unit is positioned over his ID plate and he waits for an “ack” signal from the horn 232 and flashing lamp 230 (
To make a lube truck dispense to a piece of work equipment 340 (
The system also permits independent use for the purposes of run hours reading, dispense authorization or preventive maintenance acknowledgement. In the case illustrated in
After finishing the dispense, the operator will wait for a double sound and light signal that indicates the end of dispense and that the dispense data has been written into the system. To continue dispensing after double signal, a new dispense authorization must be obtained or an error signal will be recorded.
Preventive maintenance acknowledgement is done the same way as dispense authorization. When the maintenance is performed, the ID plate assigned as the maintenance plate for the equipment is read to acknowledge the maintenance.
When a dispense is made, but the equipment can not be identified (id plate missing etc), a job number can be assigned to the dispense. In this case the job number is shown on reports instead of the equipment information. To assign a job number to a dispense the operator dispense fluid without authorization, return to the cab and click on the “Job” button on the LubeMon screen. This will cause a “Job Assignment” screen to open as illustrated in
Before leaving a particular work site the operator will check the panel screen for equipment that has not been serviced. Such equipment will be marked on the screen with a black dot. He will also check the serviced ports for flow readings per equipment on the screen. Un-serviced ports will have 0 dispensed amounts. Displayed fluid amounts are day totals for the equipment port (all dispenses to one equipment port are summarized for each day); the run hour value is the latest reading for that equipment. The truck may now return to the office.
In order to move the days' event data to the office, the operator panel must be in the OFF mode before removal of the memory stick! If the operator panel is in the OFF mode the memory stick may be removed. Otherwise the operator panel must be shut down by pushing the “Close” button on the operator panel screen as shown in
This command shuts the system off after 30 seconds. The memory stick can now be removed from the operator panel (but only after the system has entered the OFF mode). The memory stick is the carried to the office computer as suggested by
While various alternatives have been described above, it should be understood that the present invention has been presented by way of example only, and not limitation. Thus, the breadth and scope of the invention should not be limited by any of the above described exemplary embodiments, but should be defined only in accordance with the following claims.
This application is a Continuation-in-Part to my application of like title Ser. No. 09/872,693 filed Jun. 1, 2001 now abandoned.
Number | Name | Date | Kind |
---|---|---|---|
3634657 | Ballard et al. | Jan 1972 | A |
3651312 | Barney | Mar 1972 | A |
3788617 | Barney | Jan 1974 | A |
3995145 | Harris, III | Nov 1976 | A |
4345146 | Story et al. | Aug 1982 | A |
5552987 | Barger et al. | Sep 1996 | A |
5823295 | Griffith et al. | Oct 1998 | A |
5913180 | Ryan | Jun 1999 | A |
RE36510 | Burns | Jan 2000 | E |
6047250 | Beaudoin et al. | Apr 2000 | A |
20030065570 | Fukushima et al. | Apr 2003 | A1 |
Number | Date | Country | |
---|---|---|---|
20050199312 A1 | Sep 2005 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 09872693 | Jun 2001 | US |
Child | 11061091 | US |