![\"\"](\"https:\/\/alandix.com\/ref2021\/files\/2025\/12\/A1-download-results-50pc.jpg\")
<\/a><\/p>\nFig A1. UoA11 main page \u2013 \u2018Download current view\u2019 creates spreadsheet of results This produces a spreadsheet with four rows for each institution listing a profile of 4*,3*, 2*, 1* and unclassified results for Overall, Outputs, Impact and Environments respectively (Fig. A2).<\/p>\n Fig A2. Quality Profiles Spreadsheet with separate rows for Overall, Outputs, Impact, and Environment<\/p>\n The income spreadsheets are accessed from the Environment submssions database (Fig. A3).\u00a0 One must first select the desired unit of assessment (UoA11 in the case of this report) and then navigate to the Downloads area.<\/p>\n Fig A3. UoA11 main page \u2013 \u2018Download current view\u2019 creates spreadsheet of results This then contains download links for the income and income-in-kind CSV files (Fig A4).<\/p>\n Fig A4. Downloads tab including income and income-in-kind CSV files<\/p>\n The income spreadsheet (Fig. A5) covers 14 different types of income and a overall income total each on a separate row with five columns each containing yearly averages and overall totals covering different time periods.<\/p>\n Fig A5. Income Spreadsheet with separate rows for fourteen categories and overall total<\/p>\n The spreadsheets were processed by a small PHP script to create a single JSON file with all the information gathered together for each institution [JSON DATA<\/a>].\u00a0 This was then run through a second script to extract a summary CSV with one row per institution (Fig. A6), which was then used to calculate the various metrics and tables [EXCEL DATA<\/a>]\u00a0 All of the different outcomes profiles are included as separate columns, but only three of the income measures were included as there would have been 75 income totals plus a further eight research in kind columns.<\/p>\n Fig A6. Combined Spreadsheet with separate columns for each type of profile <\/p>\n [JSON DATA]\u00a0 https:\/\/alandix.com\/data\/REF2021\/ref2021-uoa11.json<\/a><\/p>\n [EXCEL DATA]\u00a0 https:\/\/alandix.com\/data\/REF2021\/summary-REF-FfM-UoA11-20250408.xlsx<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" This page contains details of how the data for the report was extracted from the official REF public domain data and then processed to create the summary spreadsheets.\u00a0 It is also included as an appendix of the main report. Downloading … Continue reading
\nhttps:\/\/results2021.ref.ac.uk\/profiles\/units-of-assessment\/11<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\nhttps:\/\/results2021.ref.ac.uk\/environment<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nLocal Processing<\/h1>\n
<\/a><\/p>\n
\nand small selection of income measures<\/p>\n