The subfolder "Transformations" contains 8 spreadsheets.
These spreadsheets contain data and data transformations used in Sections 2.1, 4 and 5 and Appendices D and E.

- The spreadsheet LabourShares.xlsx uses as input data from the "Supply and Use Tables" (accessed 17 October 2017) 
and in "Breakdown of gross operating surplus/mixed income of the UK by industry section" (accessed 10 October 2017) 
to computes labour shares in the tradable and nontradable sectors. This spreadsheet also contains output for Figure 
D-1 in the Appendix. The cells in the green sheet has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet Tradability&Shares_9718.xlsx uses as input data from the "Supply and Use Tables" (accessed 30 October 2020) 
to compute the tradability index, which is in turn used to classify SIC2 sectors into tradable and nontradable sectors. 
The spreadsheet also computes tradable consumption share. This spreadsheet also contains output for Table 2 
and for Figure D-1 in the Appendix. This output has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet Hours_LR_Sep2020.xlsx uses data from "Labour productivity by 
industry division, Average Total Hours, by Industry" (accessed 18 January 2021) and the sectoral classification obtained in 
Tradability&Shares_9718.xlsx spreadsheet to construct tradable and nontradable time series for hours worked. 
This is done by adding up the tradable and nontradable sectors. Transformations of these data are used to produce 
Tables 6 and E.1 and to estimate the model. Green cells sheets have been hardpasted in sheet "sectoral_raw_data" of 
DataSOETNT_Dec2020.xlsx. Order may not be necessary the same.
This output has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet T_NT_output_sa_LR_Dec2020.xlsx uses data in "GDP output approach 
- low-level aggregates" (accessed 31 March 2021) and the the sectoral classification derived in Tradability&Shares_9718.xlsx 
spreadsheet to construct tradable and nontradable GVA time series and the relative price of nontradable goods (P). 
This is done by chain-linking the tradable and nontradable sectors. Transformations of these data are used to 
produce Figure 1 and Tables 6 and E.1 and to estimate the model. Green cells in green sheets have been hardpasted 
in sheet "sectoral_raw_data" of DataSOETNT_Dec2020.xlsx. Order may not be necessary the same.
This output has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet T_NT_consumption_LR_sa_Dec2020.xlsx uses data in "Consumer Trends: CVM and CP" (30 June 2021) as 
well as the sectoral classification derived in Tradability&Shares_9718.xlsx to construct time series for tradable 
and nontradable consumption (CVM and CP) and the consumption price deflators. The transformation of this data is 
used to produce Tables 6 and E.1. This is done by chain-linking the tradable and nontradable products. The spreadsheet 
contains the mapping between SIC2 sectors and COICOP. Green cells in the "AggregationQly" sheet have been hardpasted 
in sheet "sectoral_raw_data" of DataSOETNT_Dec2020.xlsx. Order may not be necessary the same.
This output has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet T_NT_investment_Feb2022.xlsx uses data in "Business investment by industry and asset" (26 April 2021)
and "UK Economic Accounts time series" (accessed 30 June 2021) to compute the time series for nominal tradable investment and 
nontradable investment used for the computation of the trade balance in Section 5.3 of the paper. 
The computations related to the trade balance can be found in Section5\Data\selectedDataSeries.xlsx.
Since not all the SIC2 sectors are available, the sector classification in Tradability&Shares_9718.xlsx is 
used at a higher level of disaggregation. The quarterly data is in current prices and it is non-seasonally 
adjusted. The spreadsheet is simply added up across tradable and nontradable sectors. Green cells in 
"TNT_investment" sheet have been hardpasted in sheet "sectoral_raw_data" of DataSOETNT_Dec2020.xlsx. 
Order may not be necessary the same. The output has been hardpasted in BrexitDataPaper.xlsx.

- The spreadsheet DataSOETNT_Dec2020.xlsx uses raw data from "LFS: Total actual 
weekly hours worked", "Number of People in Employment", "AWE: Whole Economy Level: Seasonally Adjusted Total Pay
Excluding Arrears" and "LFS: Population Aged 16+: UK: All: 000s, Quarterly"
and "UK Economic Accounts time series" (accessed 30 June 2021) contains all transformations to estimate the 
model, generate Figure 1, compute Tables 6 and produce Figures D1-D4. The orange cells in the sheet 
"DataQ_estimatiON87" has been hardpasted in EstimatiON.xlsx. 
Note that order may not be necessary the same.

- The spreadsheet RealRates.xlsx uses data from FRED (series code TB3MS and CPIAUCSL_PC1  - accessed 31 Sepbemter 2021) 
and SPF (CPI6, Median Level Forecast Data for Levels - accessed 31 Sepbemter 2021) to work out real rates used for the estimation 
of the model (data is hardpasted in DataSOETNT_Dec2020.xlsx).