Files used for flow tracing
===========================

The input files used for the flow tracing analysis are in the 'Flow_tracing_input_files' subdirectory.
 
For the flow tracing code, see https://github.com/ElectricityAuthority/TPM. 
 
The outputs of the flow tracing analysis are in the 'Flow_tracing_output_files' subdirectory.
 
Key outputs have been copy-and-pasted into 'Deeper_connection_working_-_assets_covered_in_Application_A_only.xlsx' (described below). 
 This is the main spreadsheet that calculates deeper connection charges.

Files used in the application of the deeper connection method
=============================================================

Most assets are only subject to the deeper connection charge in Application A (because they are assumed to be commissioned before mid-2016).

For these assets, 'Deeper_connection_working_-_assets_covered_in_Application_A_only.xlsx' is used to calculate the deeper connection charges and the LCE rental rebates, which are dumped into 'Deeper_connection_charges_-_Application_A_only.csv' and 'Deeper_connection_rentals_-_Application_A_only.csv' respectively.

These charges and rentals are loaded into SQL by 'load_application_A_charges.sql'. At a later stage, the rentals are subtracted from the charges, to determine the net amount that each party must pay.

A few assets are subject to the deeper connection charge in both Applications A and B (because they are assumed to be commissioned between mid-2016 and 2019). 

For historical reasons, these investments were not included in the vSPD modelling of the scenario, and hence are not included in the above spreadsheet.
Rather, the deeper connection charges for these assets are estimated separately in 'Simplified_deeper_connection_working_-_assets_covered_in_both_Applications_A_and_B.xlsx', and the results are dumped into 'Deeper_connection_charges_-_Applications_A_and_B.csv'.

These charges are loaded into SQL by 'load_applications_A_and_B_charges.sql'. At a later stage, assumed rental rebates are subtracted from the charges, to determine the net amount that each party must pay.