1. Thank you for visiting HeavyEquipmentForums.com! Our objective is to provide industry professionals a place to gather to exchange questions, answers and ideas. We welcome you to register using the "Register" icon at the top of the page. We'd appreciate any help you can offer in spreading the word of our new site. The more members that join, the bigger resource for all to enjoy. Thank you!

Matience records

Discussion in 'Jobsite Coordination' started by Rlh constructio, Feb 5, 2016.

  1. Rlh constructio

    Rlh constructio Member

    Joined:
    Aug 29, 2015
    Messages:
    15
    Location:
    Salem ar
    I'm just trying to get some ideas here. We have several trucks,several dump trucks, and lots of equipment. How do you guys keep records. Do you keep up with every oil change, every hydraulic hose break or a busted tire. Do you keep a file for each one or use excel or what. Just trying to get all my ducks Ina row. Thanks
     
  2. simonsrplant

    simonsrplant Senior Member

    Joined:
    Feb 10, 2014
    Messages:
    374
    Occupation:
    Heavy Duty Off Road RSE
    Location:
    Alberta CANADA
    When I was looking after a bunch of iron under the same company full time I used to have a small book with a couple pages per unit. I would have unit and serial number(s) together with filters and "fast movers" parts numbers then service hours and a basic report of any major work done. And don't forget to write hours and date on filters when installed!
    Simple way to keep track of what's done and been done.
     
  3. caterpillarmech

    caterpillarmech Senior Member

    Joined:
    Nov 7, 2011
    Messages:
    533
    Occupation:
    Field Service Supervisor
    Location:
    Florence Texas
    We actually keep a spread sheet in google sheets. It is our online document accessible any where on the net. We keep all machine data, services, warranty data, and weekly location. I run an ipad in the truck but can also access it by my iphone during the day.
     
  4. still learn'n

    still learn'n Senior Member

    Joined:
    Feb 7, 2012
    Messages:
    325
    Location:
    Kansas
    This interests me to I need to get some sort of maintenance records to have looked online for some sort of software but havnt got any of that really yet. caterpillarmech can you post a pic of you sheet how it is set up?
     
  5. OFF

    OFF Senior Member

    Joined:
    Sep 30, 2009
    Messages:
    657
    Occupation:
    HD Mechanic/Shop Foreman
    Location:
    Alberta, Canada
    I keep a spread sheet that list all the equipment & parts on one tab, service information on another tab. Someone reads hour meters, I input those hours and the spread sheet spits out a report on what is due for service.
    It's all set up in Microsoft Access. I also keep paper files of all work orders. That's a regulation requirement (in these parts) for anything that's licenced to go on the roads.
     
  6. John C.

    John C. Senior Member

    Joined:
    Jun 12, 2007
    Messages:
    3,729
    Occupation:
    Equipment Mechanic
    Location:
    Northwest
    Access is a data base file and not a spread sheet even though it looks like one. A data base is the way to go as you can make fields up in records anyway you want and provide access to it from multiple ports. I don't care for the Microsoft product and prefer FileMaker Pro instead as it is far easier to set up and it can be changed over time as need be. Excel can be used but there are limitations on what you can get out of it. There are plenty of commercial products available but you have to keep in mind if not a custom set up you end up with either far more that you need and less than what is necessary and all that software is expensive.
     
  7. MDig

    MDig Member

    Joined:
    Mar 14, 2013
    Messages:
    10
    Location:
    Calgary
    GPS with a maintenance module, I know it sounds expensive (we pay $20/machine/month) but it really has streamlined our maintenance program. Hours/mileage is updated automatically, now we entered all the small items from the daily walk around sheets (i.e cracked mirror) that need repair between services, two weeks prior to service a notification is sent, this triggers us to get all the parts/filter etc. ready prior to the service. Notification is sent when it is due and what work is required on that particular unit, we set up a computer in our shop and when the mechanics get the machine a full list of repair items come up and when they complete the work on a machine they check it off as completed, all work/parts are recorded in the maintenance module,. We run 100+ pieces of equipment and continually were late on services, or waiting for parts when a machine came in for service which increase downtime dramatically, or bringing in a machine multiple times as parts come in etc. etc.. Think of it this way if you can get an extra billable hour out of the machine a month, or decreased you mechanics time on a machine you paid for your system. Not to mention the other benefits of GPS with stolen equipment, idle time, fleet tracking etc.
     
    Last edited: Feb 6, 2016
  8. DARO

    DARO Active Member

    Joined:
    Sep 8, 2014
    Messages:
    42
    Occupation:
    Mechanic for a local road builder .
    Location:
    Duluth MN USA
    Mdig whose GPS service do u use?
    DARO
     
  9. bigneal23

    bigneal23 Member

    Joined:
    Mar 1, 2007
    Messages:
    9
    Location:
    Alabama
    All,

    Thanks for sharing your techniques here. I know I am a little late to this conversation, but ran across it and wanted to share what I had to offer. I grew up working with my dad's construction company, and during so saw a need for equipment maintenance tracking too.

    Spreadsheets seem like an easy option, but there are trade offs. You can easily create a spreadsheet of all your equipment with the last oil change date and hour meter reading. Its a little more difficult to create it where you also maintain historical records of all oil changes. Then, when you want to track maintenance in other components it gets more complicated. Also, maybe you want some employees to be able to update certain portions of the sheet and not other portions (user permissions). How do you know if an employee is just entering a bunch of service dates at the end of the month? Are they always entering the last hour meter reading or leaving it blank? Attempting to do all this in a spreadsheet will get messy and is probably impossible. This is why a database powered system creates the best solution.

    I know there are many software options out there, but I didn't run across one that seemed like a good, affordable solution, at least for us. We had 50+ pieces of equipment, from trucks of all sizes to tractors and heavy equipment of all ages and makes. Many options are client side software installed on your computer directly and not accessible outside the office, which I didn't like for a few reasons (can be difficult supporting multiple users in different locations, mobile availability, and requires you to maintain software and updates). Also many options were over-complicated for our needs and required a significant investment. I transitioned into programming several years ago, during college, and not knowing of another good solution, I just recently built a web app to keep track of maintenance records that I'm trying to get off the ground now.

    My main goals for the app were for it to be flexible for many use cases, simple to setup and use, and affordable with little upfront commitment. If you are at all interested in something like this, please take a look at logaid.com, give it a try and let me know what you think. I'd really appreciate any feedback.

    Thanks