Need a Levey Jennings Template in Excel?

QI Macros has a Ready-Made Levey Jennings Template for You!

Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose.

Example of a QI Macros Levey Jennings Control Chart Template

Example of QI Macros Levey Jennings Chart Excel template

The template opens to the standard Levey Jennings chart. However, there are several other template options including percent, target and fixed standard deviation charts:

levey-jennings-template-tabs

Here is how each Levey Jennings Control Chart Template works

Chart Center Line Sigma Lines Input Area
Levey Jennings 1-Chg Calculated from the data

Calculated from the data and drawn at 1, 2 and 3 standard deviations

process change
Levey Jennings Percent Calculated from the data

Default draws sigma lines at 10, 20, and 30% from the center line.

Percentages can be changed using the drop down menu.

process change
Levey Jennings Target

Calculated from the data but can be overridden by inputting a different value in the Target cell

Default draws sigma lines at 5, 10 and 15% from the center line.

Percentages can be changed using the drop down menu.

target value
Levey Jennings Fixed Stdev

Calculated from the data but can be overridden by inputting a different value in the Center Line cell

Calculated from the data but can be overridden by inputting a different value in the Stdev cell

Center Line and Fixed Standard Deviation input

 

Note: According to SOFT / AAFS FORENSIC TOXICOLOGY LABORATORY GUIDELINES 9.1.12, standard deviation may represent an unacceptably large percentage deviation from the mean. Therefore, a realistic percentage deviation should be used, such as ±20% or ±30%. This option is available in the Levey Jennings Percent template and the Percent Macro.

 

To Find Levey Jennings Templates in QI Macros for Excel:

Click on the QI Macros menu > Control Chart Templates > Special (CUSUM, EWMA) > Levey Jennings Stdev or Levey Jennings 10%:

control-chart-cusum-menu


Stop Struggling with Levey Jennings Charts!
Start creating your Levey Jennings Charts in just minutes.

Download a free 30-day trial. Get Levey Jennings Charts now!

QI Macros Draws These Charts Too!