Benchmarking and Continuous Improvement Tool

P

Path of Totality

#1
I have been using this for 10+ years and thought I would share in case anybody could use it. I use it mainly for benchmarking and continuous improvements but I have also seen it used for cost tracking. The basic breakdown is that the first tab is what would be used to communicate to Management or Production without all the raw data on some separate file as said data would be inputs on the subsequent tabs. Please note that most of the "front page" is full of macros linked to all other tabs.
 

Attachments

Elsmar Forum Sponsor

insect warfare

QA=Question Authority
Trusted Information Resource
#2
Thanks for sharing...did you mean to say 'formulas' instead of 'macros', since there is no VBA code within the workbook?

I was able to open the file due to the blank password, however could you please share the password(s) to unprotect the worksheets (for those of us who would want to analyze the workbook and possibly make changes)?

Brian :rolleyes:
 
P

Path of Totality

#3
Sorry. Yes, formulas not macros. As for the password I'll have to do some searching as I haven't needed said password for years.
 
Thread starter Similar threads Forum Replies Date
B Document Approval Matrix Benchmarking Document Control Systems, Procedures, Forms and Templates 3
G Web based tool for benchmarking audit findings Benchmarking 6
M Benchmarking Process Data - Man-day calculation gone wrong Benchmarking 5
M What is Benchmarking? Benchmarking 7
gunnyshore Benchmarking: Approved Supplier List for Multiple Sites Supplier Quality Assurance and other Supplier Issues 2
M Benchmarking - Timely Closure of Corrective Actions Nonconformance and Corrective Action 3
M Tell me about Benchmarking Benchmarking 4
W Benchmarking Teardown and Salvage Process Benchmarking 1
A CATERPILLAR BGPP (Benchmarking Guide for Painting Process) Questionnaire Customer and Company Specific Requirements 4
P Cross Site Benchmarking of levels of business excellence Benchmarking 3
C Benchmarking Warranty Rates - What Rates should Trigger Actions? Benchmarking 1
C PPAP Benchmarking as it relates to the Aerospace Industry APQP and PPAP 7
V Benchmarking cGMP compliance (Systems compliance ) US Food and Drug Administration (FDA) 4
B Automotive Supplier Benchmarking - Supplier PPM Data Benchmarking 5
R Cost of Quality Benchmarking Information for the Electronics Industry Benchmarking 1
C Benchmarking our QMS against other organisations Benchmarking 8
R Benchmarking Supplier Certification Programs Supplier Quality Assurance and other Supplier Issues 7
S Benchmarking of Capability, Accuracy and Stability analyses - In Heat treatment Capability, Accuracy and Stability - Processes, Machines, etc. 3
S Load Testing Benchmarking Benchmarking 3
S Benchmarking PVC Profile Extrusion Metrics Benchmarking 2
R Benchmarking New Supplier First Article Processes Supplier Quality Assurance and other Supplier Issues 4
W Benchmarking vs. Goal Setting - Differences Benchmarking 3
M Benchmarking Audit programs General Auditing Discussions 13
F What's the best way to present benchmarking data? Benchmarking 6
C Benchmarking Preventive Maintenance Sales Benchmarking 0
Z Injection Molding cycle time benchmarking - Ball State University student Benchmarking 10
W Internal Benchmarking between product groups Benchmarking 4
B QFD (Quality Function Deployment) - World Class / Competitor Benchmarking Benchmarking 3
R What is the purpose of Benchmarking? Benchmarking 5
D Who can share Benchmarking Methods? Benchmarking 4
BradM DEA (Data Envelopment Analysis) for Benchmarking Quality Tools, Improvement and Analysis 0
A Information About Benchmarking Parameters of Castings Used for Automobile Sector Benchmarking 2
D Hospital benchmarking process - Rate of unplanned re-admissions Hospitals, Clinics & other Health Care Providers 5
D How to Benchmark? Is Benchmarking of any value? Seeking advice Benchmarking 34
Crusader ISO 9001 Objectives Data for Benchmarking / Comparison Benchmarking 0
C Benchmarking The Worst in Business Benchmarking 5
J Automotive makers strategy and benchmarking on supplier quality management Supplier Quality Assurance and other Supplier Issues 2
P Benchmarking and how it differs from the ISO or QS standards? Benchmarking 1
Marc Definition Strategic Benchmarking - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 0
Marc Definition Benchmarking - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 1
J TL 9000 and benchmarking data - Wholesale distribution Benchmarking 3
M Benchmarking - Information Services Provider Benchmarking 4
Y Benchmarking and Success Rate Survey (ROI) from ISO 9001 Implementation Benchmarking 11
Geoff Cotton APQP Benchmarking Exercise - Help Wanted Benchmarking 5
M Benchmarking documentation systems as ISO 9004 suggests. Benchmarking 3
H Benchmarking - What objectives have your company set? Benchmarking 4
F Preventive and Predictive Maintenance - Benchmarking Partner Benchmarking 6
I Automotive Benchmarking Benchmarking 4
A Quality Organizational Chart Benchmarking - See attachment Benchmarking 11
E Total Quality Information Software - Benchmarking my product against other software Benchmarking 12

Similar threads

Top Bottom