If any users take part in the annual Community Learning Benchmarking Club data submission, haven't filled their template spreadsheets in yet, and have access to SSRS reports we may be able to help.
We have a SSRS report ( "CL Benchmarking data" ) that will generate the numbers required for the CL Benchmarking spreadsheet and a modified version of the template spreadsheet ( "1617 Benchmark Template (WMS).xlsx" ) to paste the data from the SSRS report into which will complete most of the template figures automatically.
Once you have the SSRS report installed you run it and export a word document of the report; you then open the word document of data and the modified template spreadsheet and copy and past the table from the word document to cell A1 in the "TERMS Data" sheet of the spreadsheet. This should fill the majority of the numbers in the DATA part of the spreadsheet in leaving you to fill the name of the authority in and copy the relevant allocation details across.
Benchmarking Course Detail Template
There is a second SSRS report ("CL Benchmarking Course Detail") that will generate a list of the CL courses in TERMS along with the GLH details and enrolment counts. As with the benchmarking data save the report output as a Word document, then copy and paste the table into the spreadsheet.
NB: When you paste your list into A12 check to see if your list goes past row 609. If it does you will need to modify the Sum() functions in cells B8 and B9 to take account of the extra rows otherwise the figures will be wrong.
Getting the reports
Please get in touch with the helpdesk if you would like copies of the two SSRS reports and modified CL Benchmarking template spreadsheet.