- This topic has 5 replies, 3 voices, and was last updated 15 years, 7 months ago by
.
-
Posts
-
Do any of you have a XL or Access type form which can have figures of engineers sales figures, good jobs, aborted jobs etc which is easy to use and can produce printed performance graphs ?
While I am aware that both the above applications can generate such information it that format I cannot get my head around them, so I thought some of the studious types here may have already done the leg work or found another way of producing such reports ? 🙂
Re: For the Analytical
well I guess that no one measures engineer performance anymore, back to the drawing board I reckon
Re: For the Analytical
I do. I have spread sheets everywhere.
I have the engineers on a bonus system where via spread sheets I have the daily results, and as these are inputted a group calculation is created automatically which is used for the criteria against how I measure the reward.
In conjunction, I have the major accounts all tabulated where I can see on a monthly basis where the company stands regards percentage. I can tell what part of the income the main accounts match up to, and see at a glance the standing of this. Whenever I get a visit from any service manager, I can demonstrate what portion of my business they are, and their importance.
How is it done? Excel spread sheets. Nobody taught me, I sat at a lap-top on the decking in the back garden one Sunday morning and simply played with an excel file. I had torn a ligament of my shoulder, and was off both Golf & mowing the lawn (conveniently)
I started with a simple grid filled with numbers, worked out how to apply formulae, figured out how to merge & colour cells, and progressed from there. By the time it had got dark that night, the information was showing results.
I know I have been of no help, but the best way to get your head around it is just do it.
Alex
- You must be logged in to reply to this topic.