Excel frequencies formulation

[bsmill]

André
I looked at your request and to be honest it made no sense to me. Just by knowing that you have 500 hrs. in the month of Aug. to me that would mean ALL your Units is due some type of service, because the min. Service hrs is 125. I have worked all my life with maintaining trucks and other equipment and a system similar to the one below works well but only with prompt and proper information updates. Current hours can be obtained through many different ways, like fuel tickets, end of day reports, Morning reports, trip sheets, lease forms and others.
OR start over by changing = Current Hrs. to Start Hrs. AFTER the "E" Service is completed. Column "D" will calculate the difference between the two.
Col A, Unit # "B", Start Hrs. "C", Current Hrs. "D", (Hrs. used to calc. service intervals) "E", Service "F", Service Completed "G", Service Date "H", Service Change "I2" to "I10" Interval Hours (A - F) "J2" to "J10", (A,B,A2,C,A3,D,A4,E,F).
=VLOOKUP($D2,$I$2:$J$10,2) Enter into Column "E" row of first Unit #
=($C2-$B2) Enter into Column "D" same row to have the differences in hours.
=IF($E2=$F2,"","Service Due") Enter into Column "H" in row of first unit #

To change Font colors highlite column right click, go to format cells=Font tab change font color click OK.
When you have the equations in the proper cells “Double click the Fill Handle” OR grab the fill handle and drag it to the bottom of your Dataset.

Rows “I” and “J” are the reference columns. If you have to move them just highlite both columns then move them as far right as needed. Make sure that the equation changes to the proper rows and columns. Then Save.

Bsmill