GRID Semiannual Facility Spreadsheet Calculations
Modified on: Fri, 24 Aug, 2018 at 3:22 PM
The numbers in the GRID Semiannual Facility Report are derived from the data entered on the monthly forms. We take the average of the numbers the facility provides for each measure. However, if we encounter a data anomaly for a specific month, we disregard that measure for the entire month.
For example, assume you reported the following radiography turnaround times (TAT) on your monthly forms:
July - 45 hours
August - 48 hours
September - 24 hours
October - 24 hours
November - 24 hours
December - 24 hours
Based on the other numbers provided, we can see July and August had data anomalies. For example, for July:
Number of exams completed – 697
Number with TAT < 12 hours – 200
Number with TAT between 12 and 24 hours – 200
Number with TAT between 24 and 48 hours – 297
Given these numbers, the mean TAT reported of 45 hours for July is mathematically impossible. Even if we assume the maximum value for each input, e.g. all exams signed within 12 hours were signed in exactly 12 hours, the mean TAT must be less than 31 hours (see spreadsheet, below). Because the correct number could not be determined, we do not use it when calculating this measure for the 6-month period. The same thing happened in August. So that leaves us with September through December, for which you reported 24 hours for each month. The average of those four months is 24, which appears on your semiannual report.
When we find such anomalies, we advise facilities of them before the end of the reporting period, so they have a chance to correct the data.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.