Over the years I have used Excel to help me know what is going on and what to expect each month. I designed these spreadsheets just as may of you have since the canned reports on our dealership systems don't go far enough.

I will give an example of each form and if you are interested I can give you the formulas that I use in each cell. These forms take a while to load so don't give up.

If any of you have something different or better then let me have it so it can be shared.

  • tech efficiency
  • Service Department Analysis