Just downloaded and reviewed our 2017-18 QAR apprenticeship data.
All the numbers in the Summary, Comparative and Minimum Standards sheets correspond with our own internal tracking systems. But the Trend sheets show cohort sizes for 2017-18 that are twice the cohort sizes shown on the other (correct) sheets. This then results in a different overall QAR % to the one shown on the other sheets.
Is this a error? Does anybody else have this issue?
I have now worked out why this is happening. The pivot table selector in the top right hand of the Trend spreadsheets has a default setting of All which results in the Overall and Timely data being added together. Hence the almost double values.
So this issue is not the result of an error, just my inability to correctly use a pivot table!