These files calculate the allocative efficiency effects of a price cap (summarised in 'Efficiency effect of price cap.xlsx')

The file 'Modelled changes in bills' takes model results from the 'Demand_major_capex' scenario and calculates changes in charges on a MWh basis.
The file 'Shares of interconnection charges in final bills' takes external information on non-wholesale non-transmission costs and calculates implied price caps 
and then reallocates revenue to respect the caps.

Step (1): the file 'Modelled changes in bills' takes model results from the Demand scenario and calculates changes in charges on a MWh basis.
Step (2): add the per MWh charges to the Caps sheet (C183:X238) in the file 'Shares of interconnection charges in final bills' 
(an initial version labelled OLD allocated charges based on shares of demand but the policy was revised circa May 2019 to have charges 
realocated based on reductions in transmission charges)
 - this file takes external information on non-wholesale non-transmission costs and calculates implied price caps and then reallocates
revenue to respect the caps (see the 'Limit on charge change' sheet). Changes in charges are calculated in In the 'Caps' sheet, C152:X179, and alongside 
this the cells Y152:AT179 contain limits on price changes - against which 
breaches are recorded in AU152:BP179. 
Cells C4:X31 record changes in charges that are required to respect the cap. 
Cells C32:X59 - then consider the amount of revenue that needs to be reallocated to other areas (that are inside the cap)
Cells C60:X87 flag the areas for which charges are not being reallocated and therefore areas where charges need to increase. 
These can be manually adjusted
to avoid reallocating charges to areas where reallocation would cause their charges to breach the cap (see BQ152:CL179)
Cells C88:X115 calculate the increases and decreases in charges due to the price cap. 
The 2018 quantity (in cells C3:X3 in the Cap sheet) - used to reallocate revenue not recovered due to the price cap, is taken from the spreadsheet in step 1)
The results of this step are summarised in the "Limit on charge change" sheet (AI6:AQ27).
Step (3) Create a new 'aob.csv' file that is adjusted for the price cap. The file 'aob - reallocation of charges.xlsx' links to the file in Step 2 and creates a vector for price/charge changes
in the Reallocation sheet, to enable amendment to the model output file.
The 'aob Demand' sheet in 'aob - reallocation of charges.xlsx' needs to include a copy of the aob.csv file from the Demand Output folder - 
that should be pasted in to maintain the links in the 'aob cap' sheet that updates the 'aob demand' data. 
The 'aob Cap' sheet can then be used in the 'Demand_price_cap' folder - to calculate the welfare effects of the price changes... 
Step (4) run the 'Welfare and costs.py' file in the 'AoB model\Output\Demand_price_cap' to calculate the welfare effects of the price cap..