Monthly Deck Generator
Oct'4th 2016 - Nov'17th 2016
VWR International LLC
Project Charter
PROBLEM STATEMENT
Get the data from various files and populate into monthly dashboard and export them to powerpoint. This involves manual copying and pasting data from separate tabs which is time consuming and have quality issues.
OBJECTIVE
Primary Objective:
Reducing the manual process and increase the quality
Secondary Objective
-
To save time taken to process from 45 Min to 5 Min by implementing automation.
-
To develop a procedure for populating the data from various sheet tabs into one excel dashboard.
-
Export them to powerpoint. Quality check once the reports are generated.
-
To propose an alternate method that reduces the rework rate.
EXPECTED DELIVERABLES
Implementing Automation, will lower the rework and increase quality, through
-
Poka-yoke
-
Without adding additional resources,
-
Decrease time,
-
Lower human fault,
If achieved, the Monthly Dashboard could be produced with greater quality in very short time.
PROJECT SCOPE- IN SCOPE
In Scope:
Quality Management, Customer Service Satisfaction, Use of Automated tool, Time Management, Associates who run Monthly dashboard
Out Scope:
Can only be used for Monthly dashboard
Work Break down Structure
The Tool has been created on Microsoft Excel VBA. It has been incorporated with excel VBA and it needs the base inputs from other files to copy and paste the data for for the user specified time period. The QC mechanism is also incorporated successfully. It can also export data to powerpoint based on the requirements. If this is implemented successfully then the Turn Around Time for the stakeholder can be achieved without any issues on quality.
The Tool has been created and it performs good. The user needs to open the template and specify the time period in the input sheet tab and click "Run". When the button is clicked the tool runs, opens the respective files and copies them to the rawdata tab and exports each tab into the powerpoint template with required formatting. The QC status can be checked whether the tool has run the report correctly. If the reports are ran correctly then it marks as "QC Passed" else the tool marks "QC Failed"
-
The official meeting with team members and management was conducted on Oct'4th 2016
-
The Project has Gone live after getting approval with IT on Nov'17th 2016
-
It saves time and increases the quality