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 automatically be drawn to the right of your data set.

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:

30,000 Foot Control Chart Template

You can find this template by selecting the "QI Macros" menu > Control Chart Templates > Special (CUSUM, EWMA) > XmR 30000 Foot:

Control Chart Templates Special Menu


Why Choose QI Macros to Create Control Charts?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support