Looking for a g Chart Template in Excel?
QI Macros has a ready made template for you!
Why use a g chart?
g Charts are used to analyze the time or units BETWEEN rare events. For example, a hospital might track never events such as retained foreign objects during surgery. They could measure days between events or surgeries between events. The g Chart is also known as the geometric means chart.
QI Macros g chart template
To create a g Chart, just drop your data into the yellow input area and QI Macros draws a chart to the right.
After you have input your data, click on the chart, then QI Macros chart menu and then Analyze Stability.
g Chart Template Options
QI Macros g chart template is flexible enough to handle different kinds of data.
Days Between Events
Input dates, then days between are calculated
Units Between Events
Input number of units (e.g surgeries, shifts) between events.
QI Macros also contains a g Chart Gunston - Missed vs Met
In the yellow input area, track each period (day/week/month) where you met or missed an objective (e.g., no accidents). The template will calculate the number of days met/missed and the control limits. On any given day, the business either:
- Met the objective (no accidents)
- Missed the objective (accident)
- No data (forgot to track the information)
The final step is to analyze stability using QI Macros chart menu as previously described.
Examples of Rare Event Data where a g Chart would be useful
- Admissions between infections
- Discharges between readmissions
- Patients between complications
- Days between adverse drug events
- Days between needle sticks
Stop Struggling with g Charts!
Start creating your g Charts in just minutes.
QI Macros Draws These Charts Too!