Andrew Walters
& Mateus Grahl
Winter 2015
Executive Summary
Honeywell International Inc. is a large (Fortune 100)
industrial conglomerate with plant locations in 49 states and over 110
countries. This project is aimed to assist supervisors at a manufacturing
plant. The spreadsheet information is modeled after the South Bend, IN location
and the Sao Paulo, Brazil sites. The project addresses two major issues at a
plant location with a large number of employees: tracking discipline and
tracking training for the employee population and is a combining of two
separate, but related internship projects that could have benefited from VBA
knowledge.
The South Bend site’s current discipline tracking system
was a single excel document shared among supervisors on a SharePoint server.
The spreadsheet has become cumbersome since hundreds of discipline incidents
have been added along with corresponding PDF files being embedded into the
spreadsheet. Each cell needed to be manipulated manually along with creation of
the physical form for the employees to sign. The supervisors stopped entering
in discipline which caused the employees to be able to dispute any escalating
discipline due to poor record keeping. There was no training tracking/planning
form at either site.
Our task was to streamline the process to help the
supervisors cut time in tracking discipline. Once discipline is more under
control, the next step is to create and manage training plans for the
employees. The system we have built allows supervisors to choose from a list of
existing employees and have information automatically populate different
required forms—for ease in printing and signing which is required at Honeywell.
Once the supervisors have scanned the signed documents back into the system,
then can then easily link the scanned PDF files with the click of a button,
rather than embed the files into the sheet.
Employee Identification numbers have been randomized to
protect information.
- http://files.gove.net/shares/files/15w/apw9/Honeywell_Training_Discipline_Tracker_Final.xlsm
- http://files.gove.net/shares/files/15w/apw9/VBA_Final_Project_Write.pdf
No comments:
Post a Comment