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.
Are You Ready For Office 365?
Office 365 is
- Email and calendaring powered by Microsoft Exchange
- Office Web Apps - the office productivity apps you already know, tailored for the
web
- Websites powered by Microsoft SharePoint both for internal-facing intranet and customer-facing
website
- Instant Messaging and Online Meetings powered by Microsoft Lync
- All with a financially-backed 99.9% uptime guarantee
Sign up for a free trial:
Your information will not be shared with any other party. You must provide
a valid email in order to recieve your login information and starting information
kit.
Watch
this video to see how Office 365 can help your business.
|
|