**
**
## 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?
Yes
No

Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.