I am looking for a Levy Jennings plot template that I could use for
plotting QC. Nothing complicated, just something that I could used to
enter hematology QC data.

Sure, I can help you with that! Here's a step-by-step guide on how to create a Levy Jennings QC plot template in Microsoft Excel:

1. Open a new Excel workbook and create a new sheet for your QC data.
   
2. In the first column, enter the dates of your QC tests. In the second column, enter the results of your QC tests.
   
3. Calculate the mean and standard deviation of your QC results. To do this, use the
   Formula:

   AVERAGE 

   and
   Formula:

   STDEV 

   functions in Excel. For example, if your QC results are in column B, you can enter "=AVERAGE(B:B)" in a cell to calculate the mean, and "=STDEV(B:B)" in another cell to calculate the standard deviation.
   
4. Create a new sheet for your Levy Jennings plot. In the first column, enter a range of values that covers the range of your QC results. For example, if your QC results range from 80 to 120, you could enter values from 70 to 130 in the first column.
   
5. In the second column, enter the mean of your QC results.
   
6. In the third column, enter the upper control limit (UCL) and lower control limit (LCL) for your QC results. To calculate the UCL and LCL, use the following formulas:
   
   UCL = mean + (2 * standard deviation)
   LCL = mean - (2 * standard deviation)
   
7. Select the data in the first three columns and create a line chart. To do this, go to the Insert tab, click on the Line chart icon, and select the first option (Line).
   
8. Format the chart to your liking. You can add a chart title, axis labels, and gridlines. You can also change the colors and styles of the lines and markers.
   
9. Save the workbook as a template so you can reuse it for future QC tests. To do this, go to the File tab, click on Save As, and select Excel Template (*.xltx) from the Save as type dropdown menu.

That's it! You now have a Levy Jennings QC plot template that you can use to plot your hematology QC data. Let me know if you need any further assistance.

Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

http://peltiertech.com/WordPress/200...cess-control/-
Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom
SolutionsPeltier Technical Services, Inc. -
http://PeltierTech.com_______<David Antonacci wrote in message
... Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

plz send me the links or anything that can be used excel charting or making lj charts in clinical laboratory



David Antonacci wrote:

Levey-Jennings chart
03-Dec-08

Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

Previous Posts In This Thread:

On Saturday, June 02, 2007 1:09 PM
jimbo wrote:

Levy Jennings QC plot template
I am looking for a Levy Jennings plot template that I could use for
plotting QC. Nothing complicated, just something that I could used to
enter hematology QC data.

On Wednesday, December 03, 2008 10:47 PM
David Antonacci wrote:

Levey-Jennings chart
Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

On Wednesday, December 03, 2008 10:48 PM
David Antonacci wrote:

Levey-Jennings chart
Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

On Thursday, December 04, 2008 11:11 AM
Jon Peltier wrote:

Levey-Jennings chart
http://peltiertech.com/WordPress/200...cess-control/-
Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom
SolutionsPeltier Technical Services, Inc. -
http://PeltierTech.com_______<David Antonacci wrote in message
... Fairly simple in excel.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Self-Updating Windows Service Data Cache
http://www.eggheadcafe.com/tutorials...ating-win.aspx

PLZ HELP ME PLOTTING LJ CHARTS THAT ARE HELPFUL IN CLINICAL LABORATORY



David Antonacci wrote:

Levey-Jennings chart
03-Dec-08

Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

Previous Posts In This Thread:

On Saturday, June 02, 2007 1:09 PM
jimbo wrote:

Levy Jennings QC plot template
I am looking for a Levy Jennings plot template that I could use for
plotting QC. Nothing complicated, just something that I could used to
enter hematology QC data.

On Wednesday, December 03, 2008 10:47 PM
David Antonacci wrote:

Levey-Jennings chart
Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

On Wednesday, December 03, 2008 10:48 PM
David Antonacci wrote:

Levey-Jennings chart
Fairly simple in excel.
If you still require, inquire and I can explain or provide.
da

On Thursday, December 04, 2008 11:11 AM
Jon Peltier wrote:

Levey-Jennings chart
http://peltiertech.com/WordPress/200...cess-control/-
Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom
SolutionsPeltier Technical Services, Inc. -
http://PeltierTech.com_______<David Antonacci wrote in message
... Fairly simple in excel.

On Friday, February 05, 2010 11:05 PM
SYED HYDER ALI wrote:

LJ CHARTS PLOTTING
plz send me the links or anything that can be used excel charting or making lj charts in clinical laboratory


Submitted via EggHeadCafe - Software Developer Portal of Choice
..NET Compact Framework Kill All Programs
http://www.eggheadcafe.com/tutorials...mework-ki.aspx

On Saturday, June 2, 2007 at 10:39:14 PM UTC+5:30, jimbo wrote:
I am looking for a Levy Jennings plot template that I could use for
plotting QC. Nothing complicated, just something that I could used to
enter hematology QC data.