30,000 Foot Control Chart for Excel
The 30,000 foot control chart was developed by Forrest W. Breyfogle III as part of his 30,000 foot level metric tracking approach. Both are part of the Integrated Enterprise Excellence (IEE) Business Management System he developed.
Further information about the 30,000 foot level metric tracking approach can be found on his website at www.smartersolutions.com. Here is an excerpt:
" With this approach, the organization will be tracked using high level metrics so that typical response levels from inputs within the system (even though they are assignable) will be reported as common-cause variability.
For this to occur, an infrequent subgrouping/sampling plan is needed so that potential input variables, which can affect the response, occur between these subgrouping categories. A control chart will then be created so the between-subgroup variability magnitude affects the lower control limit (LCL) and upper control limit (UCL) calculations.
With this approach, high level business metrics such as revenue and profit would typically be tracked using a monthly infrequent subgrouping/sampling plan."
QI Macros add-in for Excel contains a 30,000 foot control chart template
Just type data into the yellow input area and the chart will be drawn to the right. Enter USL/LSL in cells AF2 and AF4 to get parts per million (PPM) and percent defects in cells AF15 and AF17. You can also cut and paste data from another spreadsheet into the template:
You can find this template on the menu QI Macros adds to Excel. It is located under Control Chart Templates > Special (CUSUM, EWMA) > XmR 30000 Foot:
Why Choose QI Macros to Create Control Charts?
- Only $299 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free