Automating Excel Charts
The Human Resources department in a division of a large Swiss pharmaceutical
company recently asked
I Get It!® Development to help automate the process of
comparing employee compensation to market pay data. The division has about a
thousand employees in the Silicon Valley area.
Human Resources takes a database download of all employees’ compensation,
sorts by job title, deletes all job titles where there are fewer than 4
incumbents, and then manually creates charts showing individual compensation
versus market pay references. If a job title has more than 25 incumbents,
multiple charts are made. This labor intensive process takes several days.
I Get It! Development worked directly with the HR manager responsible for
this task to create a program which would automatically recognize which job
titles to ignore and which job titles to chart. As noted earlier, some job
titles had more employees than could reasonably and clearly be displayed on a
single chart. The program takes job titles with more than 25 employees and
creates as many charts as necessary, each on a separate page. For instance, if
one job title has 70 incumbents, the program creates 4 charts: 3 charts with 20
employees and 1 chart with 10. All of these “same job title” charts use the same
market pay references for comparison, and all charts scales are made the same to
enhance comparisons between the charts.
The process of creating the charts now takes less than a minute. “The time
savings for me is incredible! Now I can concentrate more on data analysis versus
spending so much time charting. This process can be applied with any number of
employees. I can't thank I Get It! Development enough for simplifying this
tedious task at this busy, busy, busy time of year for me!”
For the full story, download the
pdf file.
Spend more time analyzing and less time agonizing. If your company has a
labor intensive process that needs to automated, please
contact us for
information on how we can help you.