Getting Equipment Maintenance Records Into MS Excel Via a Tablet.

6/11/2015 - 10:38:20 AM

How do you maintain good records without slowing down your service and maintenance operation?  We looked for alternatives to paper, tags etc. for recording equipment maintenance.  Rather than spend thousands on so-so software, we opted to just build our own low cost software to record equipment service. Now we simply record what we do on a tablet and then export the detailed service record to a line on MS Excel for sorting on an as needed basis. 

Leroy & Jeremy collaborated to write some pretty simple script in visual basic, put it on a touch screen windows tablet, bought a label printer and we were in business.  With a few simple touch screen strokes, the program records the equipment ID number, basic safety checkoffs, maintenance checkoffs, records the date/time, name of tech, and prints a ready to rent tag.  There is also an option to print an “out of service” tag which automatically sends an email to the rental manager to make sure the parts get ordered or the unit gets marked as out of service. We have been using I-pods and tablets in equipment service for quite a few months the simplicity of it. And being simple means it gets done. 
Leave a comment if you have suggestions or want to know more about setting this up for yourself. 

Update 6-17-15.......Jeremy grouped together the files needed, you can download them here.   Getting it from here to a working version will require an hour or so by someone who can write in Microsoft visual basic. Not complicated at all. One of our guys who designed this has an 8th grade education........neither had a college edu.


1 comment
I am interested on this solution.
Brenton Alexander
6/16/2015 - 1:42:32 AM
Leave a Comment

stolen tools recovered  arborist lift  compact tracked lift  spider lift  DeWalt  nascar  Ditch Witch Repair  mini loader repair  stand on loader  Dingo Repair  paint room  paint buildup  Tool Sale  Open House  Auction  Specials  Black Friday  October   Equipment Auction  Annual Auction  Milwaukee Sale  Discounts  Honda EU2000 Generator  Honda EU2200 Generator  Honda 2200  Honda 2000  hurricane  CARE   Stump Grinder  Wood Chipper  Tree Removal Rental  Branch Chipper  Honda Gap Power  Stihl Gap Power  laminated plank  OSHA Plank  dingo  mini track loader  Alturnamat Colors  Honda Snow Blower Shear Pin  Dewalt Water Supply  floor nailer  18 guage  Honda snow blower  Mats  Alturnamats  splicing rope  rope splicing tools  JLG  Skytrak  Pettibone  Edelrid Arborist  srt climbing  Wet Core Drilling  why wet core drilling only  Dry Core Drilling  Top Dressing  Compost  honda water pump parts  Honda generator parts  honda mower parts  honda snowblower parts  parking  alturnamats on grass  blower newtons  blower ratings in newtons  compare stihl blowers  Silica Dust  OSHA  tree roots  arborist  air spade  mower  brush cutting  leaking pipe  Stabila  Spectra Precision  laser  concrete grinding  concrete polishing  erosion control matting  curlex wood fiber  straw matting  erosion control  tree rope  knots  sweeper  cleaning parking lots  tiller  Honda Snowblower  snow blower  tracks  SCR aftertreatment  emissions  tier 4  DEF fluid  Stihl service  stihl parts  Stihl repairs  plastic mats  mud mats  ground protection  pressure washer  pressure washer repairs  Deck code  Simpson  Deck Building  Gift Cards  hours  store hours  generator reviews  Honda Generator  EU2000i generator  2 cycle repair  ethanol problems  chain saw repair  aerate  lawn care  overseed   Standby Generator  charging a phone  Portable Generator  safety gear inspection  safety harness  trailer rental  trailer safety  trailer hitches  men's night  food  Lithium Battery  Miter Saw  Arborist Equipment  Tree Removal  Honda Inverter Generator  Group Photo  Team Pictures  Inspect Pipe  Camera Snake  Underground Pipe Inspection  blocked drain  unclog a drain line  Sewer Camera  documenting maintenance  equipment maintenance  service record   rental equipment delivery  low cost delivery  nail delivery costs  tool delivery  generator delivery  Hydraulic Concrete Chain Saw  ICS Chain Saw  Gas Powered Concrete Chain Saw  Concrete Cutting Chain Saw  Stihl Concrete Chain Saw 
Back to Top