{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover","Map and key","Model formatting","Inputs","Time","Calcs","Dashboard","Checks","Track","F_Outputs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":64,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,"PR24 Tax reconciliation tool"]
[]
[null,"Model code","PR24PD15"]
[null,"Version number:","3b"]
[null,"File name:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"PR24PD15 Tax reconciliation - Portsmouth Water.xlsm"}]
[null,"Date:","2024-12-01"]
[]
[null,"For enquiries please contact:","PR24@ofwat.gov.uk"]

{"sheet":"Map and key","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Map and key"}]
[]
[null,"ASSUMPTIONS",null,"INPUTS",null,"CALCULATIONS",null,"OUTPUTS"]
[]
[null,{"$f":"Cover!A1","v":"Cover"},null,{"$f":"Inputs!$A$1","v":"Inputs"},null,{"$f":"Time!A$1","v":"Time"},null,{"$f":"Dashboard!$A$1","v":"Dashboard"}]
[null,"Model documentation sheet",null,"Inputs ",null,"Flags and dates",null,"Summary ofkey inputs and outputs"]
[]
[null,{"$f":"'Model formatting'!$A$1","v":"Model formatting"},null,null,null,{"$f":"Calcs!$A$1","v":"Calcs"},null,{"$f":"Checks!$A$1","v":"Checks"}]
[null,"Explanation of different formatting types",null,null,null,"Main calculation sheet of model",null,"Checks"]
[]
[null,{"$f":"$A$1","v":"Map and key"},null,null,null,null,null,{"$f":"Track!$A$1","v":"Track"}]
[null,"Table of contents",null,null,null,null,null,"Sheet to track key outputs from the model"]
[]
[]
[]
[]
["END"]

{"sheet":"Model formatting","index":2,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Model formatting"}]
[]
[]
["SHEET TABS"]
[]
[null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks & alerts"]
[null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,"Red shade",null,"Error"]
[]
[null,null,null,null,"Gold shade",null,"Alert"]
[]
[]
["END"]

{"sheet":"Inputs","index":3,"n_rows":487,"n_cols":19,"rows_kept":487,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Inputs"}]
[null,null,null,null,{"$f":"Time!E$21","v":"Model Period BEG"},{"$f":" Checks!$F$9","v":0},"Error chks",null,null,{"$f":"Time!J$21","v":"2018-04-01"},{"$f":"Time!K$21","v":"2019-04-01"},{"$f":"Time!L$21","v":"2020-04-01"},{"$f":"Time!M$21","v":"2021-04-01"},{"$f":"Time!N$21","v":"2022-04-01"},{"$f":"Time!O$21","v":"2023-04-01"},{"$f":"Time!P$21","v":"2024-04-01"},{"$f":"Time!Q$21","v":"2025-04-01"},{"$f":"Time!R$21","v":"2026-04-01"},{"$f":"Time!S$21","v":"2027-04-01"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period END"},null,null,null,null,{"$f":"Time!J$22","v":"2019-03-31"},{"$f":"Time!K$22","v":"2020-03-31"},{"$f":"Time!L$22","v":"2021-03-31"},{"$f":"Time!M$22","v":"2022-03-31"},{"$f":"Time!N$22","v":"2023-03-31"},{"$f":"Time!O$22","v":"2024-03-31"},{"$f":"Time!P$22","v":"2025-03-31"},{"$f":"Time!Q$22","v":"2026-03-31"},{"$f":"Time!R$22","v":"2027-03-31"},{"$f":"Time!S$22","v":"2028-03-31"}]
[null,null,null,null,{"$f":"Time!E$58","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$58","v":"Pre Fcst"},{"$f":"Time!K$58","v":"Pre Fcst"},{"$f":"Time!L$58","v":"Forecast"},{"$f":"Time!M$58","v":"Forecast"},{"$f":"Time!N$58","v":"Forecast"},{"$f":"Time!O$58","v":"Forecast"},{"$f":"Time!P$58","v":"Forecast"},{"$f":"Time!Q$58","v":"Post-Fcst"},{"$f":"Time!R$58","v":"Post-Fcst"},{"$f":"Time!S$58","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$86","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$86","v":2018},{"$f":"Time!K$86","v":2019},{"$f":"Time!L$86","v":2020},{"$f":"Time!M$86","v":2021},{"$f":"Time!N$86","v":2022},{"$f":"Time!O$86","v":2023},{"$f":"Time!P$86","v":2024},{"$f":"Time!Q$86","v":2025},{"$f":"Time!R$86","v":2026},{"$f":"Time!S$86","v":2027}]
[null,null,null,null,{"$f":"Time!E$10","v":"Model column counter"},null,null,null,null,{"$f":"Time!J$10","v":1},{"$f":"Time!K$10","v":2},{"$f":"Time!L$10","v":3},{"$f":"Time!M$10","v":4},{"$f":"Time!N$10","v":5},{"$f":"Time!O$10","v":6},{"$f":"Time!P$10","v":7},{"$f":"Time!Q$10","v":8},{"$f":"Time!R$10","v":9},{"$f":"Time!S$10","v":10}]
[null,null,null,null,null,"Constant","Unit","Total"]
["TIME"]
[]
[null,null,null,null,"First date of time ruler","2018-04-01","date"]
[null,null,null,null,"Last Pre Forecast Date","2020-03-31","date"]
[null,null,null,null,"Acquisition date (midnight)","2020-03-31","date"]
[null,null,null,null,"Last forecast date","2025-03-31","date"]
[null,null,null,null,"Operation Finish Date (midnight)","2025-03-31","date"]
[null,null,null,null,"First Modelling Column Financial Year Number",2018,"year"]
[null,null,null,null,"Financial Year End Month Number",3,"month #"]
[]
["NON CHANGEABLE INPUTS"]
[]
[null,null,null,null,"Model Check Tolerance Level",1E-3,"tolerance"]
[null,null,null,null,"Model Track Tolerance Level",1E-3,"tolerance"]
[]
["NET PRESENT VALUE CALCULATION INPUTS"]
[]
[null,null,null,null,"WACC - WR",3.1099999999999999E-2,"%"]
[null,null,null,null,"WACC - WN",3.1099999999999999E-2,"%"]
[null,null,null,null,"WACC - WWN",null,"%"]
[null,null,null,null,"WACC - BR",null,"%"]
[null,null,null,null,"WACC - DMMY",2.92E-2,"%"]
[]
[null,null,null,null,"Financing cost index",null,"Index",null,null,null,null,4,3,2,1,0]
[]
["MANUAL INPUTS"]
[null,null,null,null,"Adjustment to reflect the difference between full tax value and the value paid/received of any tax losses received/surrendered to the group (negative number)"]
[null,null,null,null,"Manual adjustment - WR - real",null,"£m",{"$f":"SUM(J35:R35)","v":0}]
[null,null,null,null,"Manual adjustment - WN - real",null,"£m",{"$f":"SUM(J36:R36)","v":0}]
[null,null,null,null,"Manual adjustment - WWN - real",null,"£m",{"$f":"SUM(J37:R37)","v":0}]
[null,null,null,null,"Manual adjustment - BR - real",null,"£m",{"$f":"SUM(J38:R38)","v":0}]
[null,null,null,null,"Manual adjustment - DMMY - real",null,"£m",{"$f":"SUM(J39:R39)","v":0}]
[]
["FD MODEL INPUTS"]
[]
[null,null,null,null,"Tax WR - real ",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax WN - real ",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax WWN - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax BR - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax DMMY - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Water resources - Allowed Revenues - real",0,"£m",30.706373682072236,0,0,0,5.5746950615134043,5.5952739400354572,5.6014440675656294,5.630792508201365,5.5548256987036693,0.56915878552479204,0.57006368356461512,0.56045981523896704]
[null,null,null,null,"Water network - Allowed Revenues - real",0,"£m",194.94984977477199,0,0,0,28.433832993938683,28.684006812506301,28.795534875786078,28.541745283076512,28.338729479273603,11.657055029779121,11.059849028203352,10.498279635585581]
[null,null,null,null,"Wastewater network - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Capital expenditure writing down allowance pool 1",0.18,"%"]
[null,null,null,null,"Capital expenditure writing down allowance pool 2",0.06,"%"]
[null,null,null,null,"Capital expenditure writing down allowance pool 3",0.02,"%"]
[]
[null,null,null,null,"Statutory Corporation tax rate","Global input","%",0,0,0,0,0.17,0.17,0.17,0.17,0.17,0,0,0]
[]
[null,null,null,null,"Notional Cost of Debt override - real",0,"%",0,0,0,0,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2]
[null,null,null,null,"Indexation rate for index linked debt percentage increase - override",0,"%",0,0,0,0,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,"Notional Cost of Debt override (nominal)",0,"%",0,0,0,0,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2]
[]
[null,null,null,null,"Re-profiled revenues active switch - WR, WN, WWN, BR, DMMY",0,"1 = Active, 0 = Inactive"]
[]
[null,null,null,null,"Total 5 year model integrity checks",0,"checks"]
[]
[null,null,null,null,"Totex - Tax allowance switch - WR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - WN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - WWN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - BR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - DMMY",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"WRFIM - Tax allowance switch - WR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - WN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - WWN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - BR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - DMMY",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WR",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WN",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WWN",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - BR",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - DMMY",0,"alert"]
[]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WWN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - BR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - DMMY",0,"alert"]
[]
[null,null,null,null,"Water resources - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",-0.78261878905371096,0,0,0,-0.14708086425150499,-0.15165507912972601,-0.156371552090661,-0.16124823671006799,-0.166263056871751,0,0,0]
[null,null,null,null,"Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",-4.7270735030328384,0,0,0,-0.88837894761908298,-0.916007532890037,-0.94449536716291704,-0.97395089132037105,-1.0042407640404301,0,0,0]
[null,null,null,null,"Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E43","v":"FD MODEL INPUTS - Tax WR - real "},{"$f":"F43","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E44","v":"FD MODEL INPUTS - Tax WN - real "},{"$f":"F44","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E45","v":"FD MODEL INPUTS - Tax WWN - real"},{"$f":"F45","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E46","v":"FD MODEL INPUTS - Tax BR - real"},{"$f":"F46","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E47","v":"FD MODEL INPUTS - Tax DMMY - real"},{"$f":"F47","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E49","v":"FD MODEL INPUTS - Water resources - Allowed Revenues - real"},{"$f":"F49","v":0},"£m",30.706373682072236,0,0,0,5.5746950615134043,5.5952739400354572,5.6014440675656294,5.630792508201365,5.5548256987036693,0.56915878552479204,0.57006368356461512,0.56045981523896704]
[null,null,null,null,{"$f":" A$41 & \" - \" & E50","v":"FD MODEL INPUTS - Water network - Allowed Revenues - real"},{"$f":"F50","v":0},"£m",194.94984977477199,0,0,0,28.433832993938683,28.684006812506301,28.795534875786078,28.541745283076512,28.338729479273603,11.657055029779121,11.059849028203352,10.498279635585581]
[null,null,null,null,{"$f":" A$41 & \" - \" & E51","v":"FD MODEL INPUTS - Wastewater network - Allowed Revenues - real"},{"$f":"F51","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E52","v":"FD MODEL INPUTS - Bio resources - Allowed Revenues - real"},{"$f":"F52","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E53","v":"FD MODEL INPUTS - Dummy control - Allowed Revenues - real"},{"$f":"F53","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E55","v":"FD MODEL INPUTS - Capital expenditure writing down allowance pool 1"},{"$f":"F55","v":0.18},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E56","v":"FD MODEL INPUTS - Capital expenditure writing down allowance pool 2"},{"$f":"F56","v":0.06},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E57","v":"FD MODEL INPUTS - Capital expenditure writing down allowance pool 3"},{"$f":"F57","v":0.02},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E59","v":"FD MODEL INPUTS - Statutory Corporation tax rate"},{"$f":"F59","v":"Global input"},"%",0,0,0,0,0.17,0.17,0.17,0.17,0.17,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E61","v":"FD MODEL INPUTS - Notional Cost of Debt override - real"},{"$f":"F61","v":0},"%",0,0,0,0,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2]
[null,null,null,null,{"$f":" A$41 & \" - \" & E62","v":"FD MODEL INPUTS - Indexation rate for index linked debt percentage increase - override"},{"$f":"F62","v":0},"%",0,0,0,0,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,{"$f":" A$41 & \" - \" & E63","v":"FD MODEL INPUTS - Notional Cost of Debt override (nominal)"},{"$f":"F63","v":0},"%",0,0,0,0,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E65","v":"FD MODEL INPUTS - Re-profiled revenues active switch - WR, WN, WWN, BR, DMMY"},{"$f":"F65","v":0},{"$f":"G65","v":"1 = Active, 0 = Inactive"}]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E67","v":"FD MODEL INPUTS - Total 5 year model integrity checks"},{"$f":"F67","v":0},{"$f":"G67","v":"checks"}]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E69","v":"FD MODEL INPUTS - Totex - Tax allowance switch - WR"},{"$f":"F69","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E70","v":"FD MODEL INPUTS - Totex - Tax allowance switch - WN"},{"$f":"F70","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E71","v":"FD MODEL INPUTS - Totex - Tax allowance switch - WWN"},{"$f":"F71","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E72","v":"FD MODEL INPUTS - Totex - Tax allowance switch - BR"},{"$f":"F72","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E73","v":"FD MODEL INPUTS - Totex - Tax allowance switch - DMMY"},{"$f":"F73","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E75","v":"FD MODEL INPUTS - WRFIM - Tax allowance switch - WR"},{"$f":"F75","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E76","v":"FD MODEL INPUTS - WRFIM - Tax allowance switch - WN"},{"$f":"F76","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E77","v":"FD MODEL INPUTS - WRFIM - Tax allowance switch - WWN"},{"$f":"F77","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E78","v":"FD MODEL INPUTS - WRFIM - Tax allowance switch - BR"},{"$f":"F78","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E79","v":"FD MODEL INPUTS - WRFIM - Tax allowance switch - DMMY"},{"$f":"F79","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E81","v":"FD MODEL INPUTS - Totex - Tax allowance 5 year alert - WR"},{"$f":"F81","v":0},"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E82","v":"FD MODEL INPUTS - Totex - Tax allowance 5 year alert - WN"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E83","v":"FD MODEL INPUTS - Totex - Tax allowance 5 year alert - WWN"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E84","v":"FD MODEL INPUTS - Totex - Tax allowance 5 year alert - BR"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E85","v":"FD MODEL INPUTS - Totex - Tax allowance 5 year alert - DMMY"},0,"alert"]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E87","v":"FD MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WR"},{"$f":"F87","v":0},"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E88","v":"FD MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WN"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E89","v":"FD MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WWN"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E90","v":"FD MODEL INPUTS - WRFIM - Tax allowance 5 year alert - BR"},0,"alert"]
[null,null,null,null,{"$f":" A$41 & \" - \" & E91","v":"FD MODEL INPUTS - WRFIM - Tax allowance 5 year alert - DMMY"},0,"alert"]
[]
[null,null,null,null,{"$f":" A$41 & \" - \" & E93","v":"FD MODEL INPUTS - Water resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":"F93","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$41 & \" - \" & E94","v":"FD MODEL INPUTS - Water network - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":"F94","v":0},"£m",-0.78261878905371096,0,0,0,-0.14708086425150499,-0.15165507912972601,-0.156371552090661,-0.16124823671006799,-0.166263056871751,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real",{"$f":"F95","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real",{"$f":"F96","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real",{"$f":"F97","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"FD MODEL INPUTS - Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",{"$f":"F99","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real",{"$f":"F100","v":0},"£m",-4.7270735030328384,0,0,0,-0.88837894761908298,-0.916007532890037,-0.94449536716291704,-0.97395089132037105,-1.0042407640404301,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real",{"$f":"F101","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",{"$f":"F102","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"FD MODEL INPUTS - Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real",{"$f":"F103","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["NEW MODEL INPUTS"]
[]
[null,null,null,null,"Tax WR - real ",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax WN - real ",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax WWN - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax BR - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Tax DMMY - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Water resources - Allowed Revenues - real",0,"£m",30.706373682072236,0,0,0,5.5746950615134043,5.5952739400354572,5.6014440675656294,5.630792508201365,5.5548256987036693,0.56915878552479204,0.57006368356461512,0.56045981523896704]
[null,null,null,null,"Water network - Allowed Revenues - real",0,"£m",194.94984977477199,0,0,0,28.433832993938683,28.684006812506301,28.795534875786078,28.541745283076512,28.338729479273603,11.657055029779121,11.059849028203352,10.498279635585581]
[null,null,null,null,"Wastewater network - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - Allowed Revenues - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Capital expenditure writing down allowance pool 1",0.18,"%"]
[null,null,null,null,"Capital expenditure writing down allowance pool 2",0.06,"%"]
[null,null,null,null,"Capital expenditure writing down allowance pool 3",0.03,"%"]
[]
[null,null,null,null,"Statutory Corporation tax rate","Global input","%",0,0,0,0,0.19,0.19,0.19,0.25,0.25,0,0,0]
[]
[null,null,null,null,"Notional Cost of Debt override - real",0,"%",0,0,0,0,1.7698873786408109E-2,1.5822834951456199E-2,1.4979805825242831E-2,1.5418330097087152E-2,1.614811650485426E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2]
[null,null,null,null,"Indexation rate for index linked debt percentage increase - override",0,"%",0,0,0,0,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,"Notional Cost of Debt override (nominal)",0,"%",0,0,0,0,4.822984000000019E-2,4.6297520000000092E-2,4.5429199999999947E-2,4.5880880000000013E-2,4.6632559999999823E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2]
[]
[null,null,null,null,"Re-profiled revenues active switch - WR, WN, WWN, BR, DMMY",0,"1 = Active, 0 = Inactive"]
[]
[null,null,null,null,"Total 5 year model integrity checks",0,"checks"]
[]
[null,null,null,null,"Totex - Tax allowance switch - WR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - WN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - WWN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - BR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"Totex - Tax allowance switch - DMMY",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"WRFIM - Tax allowance switch - WR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - WN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - WWN",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - BR",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,"WRFIM - Tax allowance switch - DMMY",0,"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WR",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WN",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - WWN",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - BR",0,"alert"]
[null,null,null,null,"Totex - Tax allowance 5 year alert - DMMY",0,"alert"]
[]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WWN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - BR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - DMMY",0,"alert"]
[]
[null,null,null,null,"Water resources - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",-0.78261878905371096,0,0,0,-0.14708086425150499,-0.15165507912972601,-0.156371552090661,-0.16124823671006799,-0.166263056871751,0,0,0]
[null,null,null,null,"Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",-4.7270735030328384,0,0,0,-0.88837894761908298,-0.916007532890037,-0.94449536716291704,-0.97395089132037105,-1.0042407640404301,0,0,0]
[null,null,null,null,"Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real",0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E169","v":"NEW MODEL INPUTS - Tax WR - real "},{"$f":"F169","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E170","v":"NEW MODEL INPUTS - Tax WN - real "},{"$f":"F170","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E171","v":"NEW MODEL INPUTS - Tax WWN - real"},{"$f":"F171","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E172","v":"NEW MODEL INPUTS - Tax BR - real"},{"$f":"F172","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E173","v":"NEW MODEL INPUTS - Tax DMMY - real"},{"$f":"F173","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E175","v":"NEW MODEL INPUTS - Water resources - Allowed Revenues - real"},{"$f":"F175","v":0},"£m",30.706373682072236,0,0,0,5.5746950615134043,5.5952739400354572,5.6014440675656294,5.630792508201365,5.5548256987036693,0.56915878552479204,0.57006368356461512,0.56045981523896704]
[null,null,null,null,{"$f":" A$167 & \" - \" & E176","v":"NEW MODEL INPUTS - Water network - Allowed Revenues - real"},{"$f":"F176","v":0},"£m",194.94984977477199,0,0,0,28.433832993938683,28.684006812506301,28.795534875786078,28.541745283076512,28.338729479273603,11.657055029779121,11.059849028203352,10.498279635585581]
[null,null,null,null,{"$f":" A$167 & \" - \" & E177","v":"NEW MODEL INPUTS - Wastewater network - Allowed Revenues - real"},{"$f":"F177","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E178","v":"NEW MODEL INPUTS - Bio resources - Allowed Revenues - real"},{"$f":"F178","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E179","v":"NEW MODEL INPUTS - Dummy control - Allowed Revenues - real"},{"$f":"F179","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E181","v":"NEW MODEL INPUTS - Capital expenditure writing down allowance pool 1"},{"$f":"F181","v":0.18},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E182","v":"NEW MODEL INPUTS - Capital expenditure writing down allowance pool 2"},{"$f":"F182","v":0.06},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E183","v":"NEW MODEL INPUTS - Capital expenditure writing down allowance pool 3"},{"$f":"F183","v":0.03},"%",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E185","v":"NEW MODEL INPUTS - Statutory Corporation tax rate"},{"$f":"F185","v":"Global input"},"%",0,0,0,0,0.19,0.19,0.19,0.25,0.25,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E187","v":"NEW MODEL INPUTS - Notional Cost of Debt override - real"},{"$f":"F187","v":0},"%",0,0,0,0,1.7698873786408109E-2,1.5822834951456199E-2,1.4979805825242831E-2,1.5418330097087152E-2,1.614811650485426E-2,1.1490003519418313E-2,1.1490003519418313E-2,1.1490003519418313E-2]
[null,null,null,null,{"$f":" A$167 & \" - \" & E188","v":"NEW MODEL INPUTS - Indexation rate for index linked debt percentage increase - override"},{"$f":"F188","v":0},"%",0,0,0,0,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,{"$f":" A$167 & \" - \" & E189","v":"NEW MODEL INPUTS - Notional Cost of Debt override (nominal)"},{"$f":"F189","v":0},"%",0,0,0,0,{"$f":"L189","v":4.822984000000019E-2},4.6297520000000092E-2,4.5429199999999947E-2,4.5880880000000013E-2,4.6632559999999823E-2,4.5134703625000903E-2,4.5134703625000903E-2,4.5134703625000903E-2]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E191","v":"NEW MODEL INPUTS - Re-profiled revenues active switch - WR, WN, WWN, BR, DMMY"},{"$f":"F191","v":0},"1 = Active, 0 = Inactive"]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E193","v":"NEW MODEL INPUTS - Total 5 year model integrity checks"},0,"checks"]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E195","v":"NEW MODEL INPUTS - Totex - Tax allowance switch - WR"},{"$f":"F195","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E196","v":"NEW MODEL INPUTS - Totex - Tax allowance switch - WN"},{"$f":"F196","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E197","v":"NEW MODEL INPUTS - Totex - Tax allowance switch - WWN"},{"$f":"F197","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E198","v":"NEW MODEL INPUTS - Totex - Tax allowance switch - BR"},{"$f":"F198","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E199","v":"NEW MODEL INPUTS - Totex - Tax allowance switch - DMMY"},{"$f":"F199","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E201","v":"NEW MODEL INPUTS - WRFIM - Tax allowance switch - WR"},{"$f":"F201","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E202","v":"NEW MODEL INPUTS - WRFIM - Tax allowance switch - WN"},{"$f":"F202","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E203","v":"NEW MODEL INPUTS - WRFIM - Tax allowance switch - WWN"},{"$f":"F203","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E204","v":"NEW MODEL INPUTS - WRFIM - Tax allowance switch - BR"},{"$f":"F204","v":0},"0 = Allowed, 1 = Not allowed",0,0,"na","na",0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E205","v":"NEW MODEL INPUTS - WRFIM - Tax allowance switch - DMMY"},{"$f":"F205","v":0},"0 = Allowed, 1 = Not allowed",{"$f":"H205","v":0},0,"na","na",0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E207","v":"NEW MODEL INPUTS - Totex - Tax allowance 5 year alert - WR"},{"$f":"F207","v":0},"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E208","v":"NEW MODEL INPUTS - Totex - Tax allowance 5 year alert - WN"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E209","v":"NEW MODEL INPUTS - Totex - Tax allowance 5 year alert - WWN"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E210","v":"NEW MODEL INPUTS - Totex - Tax allowance 5 year alert - BR"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E211","v":"NEW MODEL INPUTS - Totex - Tax allowance 5 year alert - DMMY"},0,"alert"]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E213","v":"NEW MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WR"},{"$f":"F213","v":0},"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E214","v":"NEW MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WN"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E215","v":"NEW MODEL INPUTS - WRFIM - Tax allowance 5 year alert - WWN"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E216","v":"NEW MODEL INPUTS - WRFIM - Tax allowance 5 year alert - BR"},0,"alert"]
[null,null,null,null,{"$f":" A$167 & \" - \" & E217","v":"NEW MODEL INPUTS - WRFIM - Tax allowance 5 year alert - DMMY"},0,"alert"]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E219","v":"NEW MODEL INPUTS - Water resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":"F219","v":0},"£m",{"$f":"H219","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E220","v":"NEW MODEL INPUTS - Water network - Totex (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H220","v":-0.78261878905371096},0,0,0,-0.14708086425150499,-0.15165507912972601,-0.156371552090661,-0.16124823671006799,-0.166263056871751,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E221","v":"NEW MODEL INPUTS - Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H221","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E222","v":"NEW MODEL INPUTS - Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H222","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E223","v":"NEW MODEL INPUTS - Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H223","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" A$167 & \" - \" & E225","v":"NEW MODEL INPUTS - Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":"F225","v":0},"£m",{"$f":"H225","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E226","v":"NEW MODEL INPUTS - Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H226","v":-4.7270735030328384},0,0,0,-0.88837894761908298,-0.916007532890037,-0.94449536716291704,-0.97395089132037105,-1.0042407640404301,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E227","v":"NEW MODEL INPUTS - Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H227","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E228","v":"NEW MODEL INPUTS - Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H228","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" A$167 & \" - \" & E229","v":"NEW MODEL INPUTS - Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real"},0,"£m",{"$f":"H229","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["END"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - WWN",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - BR",0,"alert"]
[null,null,null,null,"WRFIM - Tax allowance 5 year alert - DMMY",0,"alert"]

{"sheet":"Time","index":4,"n_rows":89,"n_cols":19,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Time"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period END"},{"$f":" Checks!$F$9","v":0},"Error chks",null,null,{"$f":"Time!J$22","v":"2019-03-31"},{"$f":"Time!K$22","v":"2020-03-31"},{"$f":"Time!L$22","v":"2021-03-31"},{"$f":"Time!M$22","v":"2022-03-31"},{"$f":"Time!N$22","v":"2023-03-31"},{"$f":"Time!O$22","v":"2024-03-31"},{"$f":"Time!P$22","v":"2025-03-31"},{"$f":"Time!Q$22","v":"2026-03-31"},{"$f":"Time!R$22","v":"2027-03-31"},{"$f":"Time!S$22","v":"2028-03-31"}]
[null,null,null,null,{"$f":"Time!E$58","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$58","v":"Pre Fcst"},{"$f":"Time!K$58","v":"Pre Fcst"},{"$f":"Time!L$58","v":"Forecast"},{"$f":"Time!M$58","v":"Forecast"},{"$f":"Time!N$58","v":"Forecast"},{"$f":"Time!O$58","v":"Forecast"},{"$f":"Time!P$58","v":"Forecast"},{"$f":"Time!Q$58","v":"Post-Fcst"},{"$f":"Time!R$58","v":"Post-Fcst"},{"$f":"Time!S$58","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$86","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$86","v":2018},{"$f":"Time!K$86","v":2019},{"$f":"Time!L$86","v":2020},{"$f":"Time!M$86","v":2021},{"$f":"Time!N$86","v":2022},{"$f":"Time!O$86","v":2023},{"$f":"Time!P$86","v":2024},{"$f":"Time!Q$86","v":2025},{"$f":"Time!R$86","v":2026},{"$f":"Time!S$86","v":2027}]
[null,null,null,null,{"$f":"Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$10","v":1},{"$f":"Time!K$10","v":2},{"$f":"Time!L$10","v":3},{"$f":"Time!M$10","v":4},{"$f":"Time!N$10","v":5},{"$f":"Time!O$10","v":6},{"$f":"Time!P$10","v":7},{"$f":"Time!Q$10","v":8},{"$f":"Time!R$10","v":9},{"$f":"Time!S$10","v":10}]
[]
["MODEL PERIOD"]
[]
[null,"Model Column Counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I10 + 1","v":1},2,3,4,5,6,7,8,9,10]
[null,null,null,null,"Model Column Total",{"$f":" MAX(J10:CA10)","v":10},"column"]
[]
[null,null,null,null,{"$f":" E$10","v":"Model column counter"},0,"counter",0,0,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM(J14:CA14)","v":1},null,{"$f":" IF( J13 = 1, 1, 0)","v":1},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Inputs!E$10","v":"First date of time ruler"},{"$f":" Inputs!F$10","v":"2018-04-01"},{"$f":" Inputs!G$10","v":"date"}]
[null,null,null,null,"First model period BEG",{"$f":" DATE(YEAR(F16), MONTH(F16), 1)","v":"2018-04-01"},"month"]
[]
[null,null,null,null,{"$f":" E$17","v":"First model period BEG"},{"$f":" F$17","v":"2018-04-01"},{"$f":" G$17","v":"month"}]
[null,null,null,null,{"$f":" E$14","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model Period BEG",null,"date",null,null,{"$f":" IF( J20 = 1, $F19, I22 + 1)","v":"2018-04-01"},"2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,"Model Period END",null,"date",null,null,{"$f":" DATE(YEAR(J21), MONTH(J21) + 12, DAY(1) - 1)","v":"2019-03-31"},"2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[]
[null,null,null,null,{"$f":" E$22","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,"less",{"$f":" E$21","v":"Model Period BEG"},"00:00:00","date","00:00:00","00:00:00","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,"Days in Model Period",null,"days",{"$f":" SUM(J26:CA26)","v":3653},null,{"$f":" J24 - J25 + 1","v":365},366,365,365,365,366,365,365,365,366]
[]
[]
["PRE FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" Inputs!E$11","v":"Last Pre Forecast Date"},{"$f":" Inputs!F$11","v":"2020-03-31"},{"$f":" Inputs!G$11","v":"date"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"Last Pre Forecast Flag",null,"flag",{"$f":" SUM(J33:CA33)","v":1},null,{"$f":" IF(J32 = $F31, 1, 0)","v":0},1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Flag",null,"flag",{"$f":" SUM(J34:CA34)","v":2},null,{"$f":" IF($F31 >= J32, 1, 0)","v":1},1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Total",{"$f":" SUM(J34:CA34)","v":2},"columns"]
[]
[null,null,null,null,{"$f":" Inputs!E$12","v":"Acquisition date (midnight)"},{"$f":" Inputs!F$12","v":"2020-03-31"},{"$f":" Inputs!G$12","v":"date"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"Acquisition / initial balance date flag",null,"flag",{"$f":" SUM(J39:CA39)","v":1},null,{"$f":" IF(J38 = $F37, 1, 0)","v":0},1,0,0,0,0,0,0,0,0]
[]
[]
["FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$33","v":"Last Pre Forecast Flag"},0,"flag",1,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,"1st Forecast Period Flag",null,"flag",{"$f":" SUM(J45:CA45)","v":1},null,{"$f":" I44","v":0},0,1,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"Inputs!E$13","v":"Last forecast date"},{"$f":"Inputs!F$13","v":"2025-03-31"},{"$f":"Inputs!G$13","v":"date"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"Last Forecast Period Flag",null,"flag",{"$f":" SUM(J49:CA49)","v":1},null,{"$f":" IF(AND($F47 > I48, $F47 <= J48), 1, 0)","v":0},0,0,0,0,0,1,0,0,0]
[]
[null,null,null,null,{"$f":" E$45","v":"1st Forecast Period Flag"},0,"flag",1,0,0,0,1,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$49","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"Forecast Period Flag",null,"flag",{"$f":" SUM(J53:CA53)","v":5},null,{"$f":" J51 - I52 + I53","v":0},0,1,1,1,1,1,0,0,0]
[null,null,null,null,"Forecast Period Total ",{"$f":" SUM(J53:CA53)","v":5},"columns"]
[]
[null,null,null,null,{"$f":" E$34","v":"Pre Forecast Period Flag"},0,"flag",2,0,1,1,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$53","v":"Forecast Period Flag"},0,"flag",5,0,0,0,1,1,1,1,1,0,0,0]
[null,null,null,null,"Pre Forecast vs Forecast",null,"flag",null,null,{"$f":" IF(J56 = 1, \"Pre Fcst\", IF(J57 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Pre Fcst"},"Pre Fcst","Forecast","Forecast","Forecast","Forecast","Forecast","Post-Fcst","Post-Fcst","Post-Fcst"]
[]
[]
["POST FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$49","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"1st Post Last Forecast Period Flag",null,"flag",{"$f":" SUM(J64:CA64)","v":1},null,{"$f":" I63","v":0},0,0,0,0,0,0,1,0,0]
[]
[null,null,null,null,{"$f":" E$64","v":"1st Post Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,0,0,1,0,0]
[null,null,null,null,"Post Forecast Period Flag",null,"flag",{"$f":" SUM(J67:CA67)","v":3},null,{"$f":" I67 + J66","v":0},0,0,0,0,0,0,1,1,1]
[null,null,null,null,"Post Forecast Period Total",{"$f":" SUM(J67:CA67)","v":3},"columns"]
[]
[]
["MODELLING PERIOD CHECK"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model Column Total"},{"$f":" F$11","v":10},{"$f":" G$11","v":"column"}]
[null,null,null,"less",{"$f":" E$35","v":"Pre Forecast Period Total"},{"$f":" F$35","v":2},{"$f":" G$35","v":"columns"}]
[null,null,null,"less",{"$f":" E$54","v":"Forecast Period Total "},{"$f":" F$54","v":5},{"$f":" G$54","v":"columns"}]
[null,null,null,"less",{"$f":" E$68","v":"Post Forecast Period Total"},{"$f":" F$68","v":3},{"$f":" G$68","v":"columns"}]
[null,null,null,null,"Modelling Period Check",{"$f":" IF(F73 - SUM(F74:F76) <> 0, 1, 0)","v":0},"check"]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"Inputs!E15","v":"First Modelling Column Financial Year Number"},{"$f":"Inputs!F15","v":2018},{"$f":"Inputs!G15","v":"year"}]
[null,null,null,null,{"$f":"Inputs!E16","v":"Financial Year End Month Number"},{"$f":"Inputs!F16","v":3},{"$f":"Inputs!G16","v":"month #"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,{"$f":" E$14","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Financial Year Ending",null,"year #",null,null,{"$f":" IF(J85 = 1, $F82, IF(J84 > (DATE(I86, $F83 + 1, 1) - 1), I86 + 1, I86))","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027]
[]
[]
["END"]

{"sheet":"Calcs","index":5,"n_rows":200,"n_cols":19,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Calcs"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period END"},{"$f":" Checks!$F$9","v":0},"Error chks",null,null,{"$f":"Time!J$22","v":"2019-03-31"},{"$f":"Time!K$22","v":"2020-03-31"},{"$f":"Time!L$22","v":"2021-03-31"},{"$f":"Time!M$22","v":"2022-03-31"},{"$f":"Time!N$22","v":"2023-03-31"},{"$f":"Time!O$22","v":"2024-03-31"},{"$f":"Time!P$22","v":"2025-03-31"},{"$f":"Time!Q$22","v":"2026-03-31"},{"$f":"Time!R$22","v":"2027-03-31"},{"$f":"Time!S$22","v":"2028-03-31"}]
[null,null,null,null,{"$f":"Time!E$58","v":"Pre Forecast vs Forecast"},null,null,null,null,{"$f":"Time!J$58","v":"Pre Fcst"},{"$f":"Time!K$58","v":"Pre Fcst"},{"$f":"Time!L$58","v":"Forecast"},{"$f":"Time!M$58","v":"Forecast"},{"$f":"Time!N$58","v":"Forecast"},{"$f":"Time!O$58","v":"Forecast"},{"$f":"Time!P$58","v":"Forecast"},{"$f":"Time!Q$58","v":"Post-Fcst"},{"$f":"Time!R$58","v":"Post-Fcst"},{"$f":"Time!S$58","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$86","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$86","v":2018},{"$f":"Time!K$86","v":2019},{"$f":"Time!L$86","v":2020},{"$f":"Time!M$86","v":2021},{"$f":"Time!N$86","v":2022},{"$f":"Time!O$86","v":2023},{"$f":"Time!P$86","v":2024},{"$f":"Time!Q$86","v":2025},{"$f":"Time!R$86","v":2026},{"$f":"Time!S$86","v":2027}]
[null,null,null,null,{"$f":"Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$10","v":1},{"$f":"Time!K$10","v":2},{"$f":"Time!L$10","v":3},{"$f":"Time!M$10","v":4},{"$f":"Time!N$10","v":5},{"$f":"Time!O$10","v":6},{"$f":"Time!P$10","v":7},{"$f":"Time!Q$10","v":8},{"$f":"Time!R$10","v":9},{"$f":"Time!S$10","v":10}]
[]
["Tax differences"]
[null,null,null,null,{"$f":" Inputs!E$105","v":"FD MODEL INPUTS - Tax WR - real "},{"$f":" Inputs!F$105","v":0},{"$f":" Inputs!G$105","v":"£m"},{"$f":" Inputs!H$105","v":0},{"$f":" Inputs!I$105","v":0},{"$f":" Inputs!J$105","v":0},{"$f":" Inputs!K$105","v":0},{"$f":" Inputs!L$105","v":0},{"$f":" Inputs!M$105","v":0},{"$f":" Inputs!N$105","v":0},{"$f":" Inputs!O$105","v":0},{"$f":" Inputs!P$105","v":0},{"$f":" Inputs!Q$105","v":0},{"$f":" Inputs!R$105","v":0},{"$f":" Inputs!S$105","v":0}]
[null,null,null,null,{"$f":" Inputs!E$106","v":"FD MODEL INPUTS - Tax WN - real "},{"$f":" Inputs!F$106","v":0},{"$f":" Inputs!G$106","v":"£m"},{"$f":" Inputs!H$106","v":0},{"$f":" Inputs!I$106","v":0},{"$f":" Inputs!J$106","v":0},{"$f":" Inputs!K$106","v":0},{"$f":" Inputs!L$106","v":0},{"$f":" Inputs!M$106","v":0},{"$f":" Inputs!N$106","v":0},{"$f":" Inputs!O$106","v":0},{"$f":" Inputs!P$106","v":0},{"$f":" Inputs!Q$106","v":0},{"$f":" Inputs!R$106","v":0},{"$f":" Inputs!S$106","v":0}]
[null,null,null,null,{"$f":" Inputs!E$107","v":"FD MODEL INPUTS - Tax WWN - real"},{"$f":" Inputs!F$107","v":0},{"$f":" Inputs!G$107","v":"£m"},{"$f":" Inputs!H$107","v":0},{"$f":" Inputs!I$107","v":0},{"$f":" Inputs!J$107","v":0},{"$f":" Inputs!K$107","v":0},{"$f":" Inputs!L$107","v":0},{"$f":" Inputs!M$107","v":0},{"$f":" Inputs!N$107","v":0},{"$f":" Inputs!O$107","v":0},{"$f":" Inputs!P$107","v":0},{"$f":" Inputs!Q$107","v":0},{"$f":" Inputs!R$107","v":0},{"$f":" Inputs!S$107","v":0}]
[null,null,null,null,{"$f":" Inputs!E$108","v":"FD MODEL INPUTS - Tax BR - real"},{"$f":" Inputs!F$108","v":0},{"$f":" Inputs!G$108","v":"£m"},{"$f":" Inputs!H$108","v":0},{"$f":" Inputs!I$108","v":0},{"$f":" Inputs!J$108","v":0},{"$f":" Inputs!K$108","v":0},{"$f":" Inputs!L$108","v":0},{"$f":" Inputs!M$108","v":0},{"$f":" Inputs!N$108","v":0},{"$f":" Inputs!O$108","v":0},{"$f":" Inputs!P$108","v":0},{"$f":" Inputs!Q$108","v":0},{"$f":" Inputs!R$108","v":0},{"$f":" Inputs!S$108","v":0}]
[null,null,null,null,{"$f":" Inputs!E$109","v":"FD MODEL INPUTS - Tax DMMY - real"},{"$f":" Inputs!F$109","v":0},{"$f":" Inputs!G$109","v":"£m"},{"$f":" Inputs!H$109","v":0},{"$f":" Inputs!I$109","v":0},{"$f":" Inputs!J$109","v":0},{"$f":" Inputs!K$109","v":0},{"$f":" Inputs!L$109","v":0},{"$f":" Inputs!M$109","v":0},{"$f":" Inputs!N$109","v":0},{"$f":" Inputs!O$109","v":0},{"$f":" Inputs!P$109","v":0},{"$f":" Inputs!Q$109","v":0},{"$f":" Inputs!R$109","v":0},{"$f":" Inputs!S$109","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$231","v":"NEW MODEL INPUTS - Tax WR - real "},{"$f":" Inputs!F$231","v":0},{"$f":" Inputs!G$231","v":"£m"},{"$f":" Inputs!H$231","v":0},{"$f":" Inputs!I$231","v":0},{"$f":" Inputs!J$231","v":0},{"$f":" Inputs!K$231","v":0},{"$f":" Inputs!L$231","v":0},{"$f":" Inputs!M$231","v":0},{"$f":" Inputs!N$231","v":0},{"$f":" Inputs!O$231","v":0},{"$f":" Inputs!P$231","v":0},{"$f":" Inputs!Q$231","v":0},{"$f":" Inputs!R$231","v":0},{"$f":" Inputs!S$231","v":0}]
[null,null,null,null,{"$f":" Inputs!E$232","v":"NEW MODEL INPUTS - Tax WN - real "},{"$f":" Inputs!F$232","v":0},{"$f":" Inputs!G$232","v":"£m"},{"$f":" Inputs!H$232","v":0},{"$f":" Inputs!I$232","v":0},{"$f":" Inputs!J$232","v":0},{"$f":" Inputs!K$232","v":0},{"$f":" Inputs!L$232","v":0},{"$f":" Inputs!M$232","v":0},{"$f":" Inputs!N$232","v":0},{"$f":" Inputs!O$232","v":0},{"$f":" Inputs!P$232","v":0},{"$f":" Inputs!Q$232","v":0},{"$f":" Inputs!R$232","v":0},{"$f":" Inputs!S$232","v":0}]
[null,null,null,null,{"$f":" Inputs!E$233","v":"NEW MODEL INPUTS - Tax WWN - real"},{"$f":" Inputs!F$233","v":0},{"$f":" Inputs!G$233","v":"£m"},{"$f":" Inputs!H$233","v":0},{"$f":" Inputs!I$233","v":0},{"$f":" Inputs!J$233","v":0},{"$f":" Inputs!K$233","v":0},{"$f":" Inputs!L$233","v":0},{"$f":" Inputs!M$233","v":0},{"$f":" Inputs!N$233","v":0},{"$f":" Inputs!O$233","v":0},{"$f":" Inputs!P$233","v":0},{"$f":" Inputs!Q$233","v":0},{"$f":" Inputs!R$233","v":0},{"$f":" Inputs!S$233","v":0}]
[null,null,null,null,{"$f":" Inputs!E$234","v":"NEW MODEL INPUTS - Tax BR - real"},{"$f":" Inputs!F$234","v":0},{"$f":" Inputs!G$234","v":"£m"},{"$f":" Inputs!H$234","v":0},{"$f":" Inputs!I$234","v":0},{"$f":" Inputs!J$234","v":0},{"$f":" Inputs!K$234","v":0},{"$f":" Inputs!L$234","v":0},{"$f":" Inputs!M$234","v":0},{"$f":" Inputs!N$234","v":0},{"$f":" Inputs!O$234","v":0},{"$f":" Inputs!P$234","v":0},{"$f":" Inputs!Q$234","v":0},{"$f":" Inputs!R$234","v":0},{"$f":" Inputs!S$234","v":0}]
[null,null,null,null,{"$f":" Inputs!E$235","v":"NEW MODEL INPUTS - Tax DMMY - real"},{"$f":" Inputs!F$235","v":0},{"$f":" Inputs!G$235","v":"£m"},{"$f":" Inputs!H$235","v":0},{"$f":" Inputs!I$235","v":0},{"$f":" Inputs!J$235","v":0},{"$f":" Inputs!K$235","v":0},{"$f":" Inputs!L$235","v":0},{"$f":" Inputs!M$235","v":0},{"$f":" Inputs!N$235","v":0},{"$f":" Inputs!O$235","v":0},{"$f":" Inputs!P$235","v":0},{"$f":" Inputs!Q$235","v":0},{"$f":" Inputs!R$235","v":0},{"$f":" Inputs!S$235","v":0}]
[]
[null,null,null,null,"Difference in tax revenue WR - real",null,"£m",{"$f":"SUM(J20:S20)","v":0},null,{"$f":"J14-J8","v":0},{"$f":"K14-K8","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in tax revenue WN - real",null,"£m",{"$f":"SUM(J21:S21)","v":0},null,{"$f":"J15-J9","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in tax revenue WWN - real",null,"£m",{"$f":"SUM(J22:S22)","v":0},null,{"$f":"J16-J10","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in tax revenue BR - real",null,"£m",{"$f":"SUM(J23:S23)","v":0},null,{"$f":"J17-J11","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in tax revenue DMMY - real",null,"£m",{"$f":"SUM(J24:S24)","v":0},null,{"$f":"J18-J12","v":0},0,0,0,0,0,0,0,0,0]
[]
["Reconciliation items differences"]
[]
[null,null,null,null,{"$f":" Inputs!E$155","v":"FD MODEL INPUTS - Water resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$155","v":0},{"$f":" Inputs!G$155","v":"£m"},{"$f":" Inputs!H$155","v":0},{"$f":" Inputs!I$155","v":0},{"$f":" Inputs!J$155","v":0},{"$f":" Inputs!K$155","v":0},{"$f":" Inputs!L$155","v":0},{"$f":" Inputs!M$155","v":0},{"$f":" Inputs!N$155","v":0},{"$f":" Inputs!O$155","v":0},{"$f":" Inputs!P$155","v":0},{"$f":" Inputs!Q$155","v":0},{"$f":" Inputs!R$155","v":0},{"$f":" Inputs!S$155","v":0}]
[null,null,null,null,{"$f":" Inputs!E$156","v":"FD MODEL INPUTS - Water network - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$156","v":0},{"$f":" Inputs!G$156","v":"£m"},{"$f":" Inputs!H$156","v":-0.78261878905371096},{"$f":" Inputs!I$156","v":0},{"$f":" Inputs!J$156","v":0},{"$f":" Inputs!K$156","v":0},{"$f":" Inputs!L$156","v":-0.14708086425150499},{"$f":" Inputs!M$156","v":-0.15165507912972601},{"$f":" Inputs!N$156","v":-0.156371552090661},{"$f":" Inputs!O$156","v":-0.16124823671006799},{"$f":" Inputs!P$156","v":-0.166263056871751},{"$f":" Inputs!Q$156","v":0},{"$f":" Inputs!R$156","v":0},{"$f":" Inputs!S$156","v":0}]
[null,null,null,null,{"$f":" Inputs!E$157","v":"FD MODEL INPUTS - Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$157","v":0},{"$f":" Inputs!G$157","v":"£m"},{"$f":" Inputs!H$157","v":0},{"$f":" Inputs!I$157","v":0},{"$f":" Inputs!J$157","v":0},{"$f":" Inputs!K$157","v":0},{"$f":" Inputs!L$157","v":0},{"$f":" Inputs!M$157","v":0},{"$f":" Inputs!N$157","v":0},{"$f":" Inputs!O$157","v":0},{"$f":" Inputs!P$157","v":0},{"$f":" Inputs!Q$157","v":0},{"$f":" Inputs!R$157","v":0},{"$f":" Inputs!S$157","v":0}]
[null,null,null,null,{"$f":" Inputs!E$158","v":"FD MODEL INPUTS - Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$158","v":0},{"$f":" Inputs!G$158","v":"£m"},{"$f":" Inputs!H$158","v":0},{"$f":" Inputs!I$158","v":0},{"$f":" Inputs!J$158","v":0},{"$f":" Inputs!K$158","v":0},{"$f":" Inputs!L$158","v":0},{"$f":" Inputs!M$158","v":0},{"$f":" Inputs!N$158","v":0},{"$f":" Inputs!O$158","v":0},{"$f":" Inputs!P$158","v":0},{"$f":" Inputs!Q$158","v":0},{"$f":" Inputs!R$158","v":0},{"$f":" Inputs!S$158","v":0}]
[null,null,null,null,{"$f":" Inputs!E$159","v":"FD MODEL INPUTS - Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$159","v":0},{"$f":" Inputs!G$159","v":"£m"},{"$f":" Inputs!H$159","v":0},{"$f":" Inputs!I$159","v":0},{"$f":" Inputs!J$159","v":0},{"$f":" Inputs!K$159","v":0},{"$f":" Inputs!L$159","v":0},{"$f":" Inputs!M$159","v":0},{"$f":" Inputs!N$159","v":0},{"$f":" Inputs!O$159","v":0},{"$f":" Inputs!P$159","v":0},{"$f":" Inputs!Q$159","v":0},{"$f":" Inputs!R$159","v":0},{"$f":" Inputs!S$159","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$281","v":"NEW MODEL INPUTS - Water resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$281","v":0},{"$f":" Inputs!G$281","v":"£m"},{"$f":" Inputs!H$281","v":0},{"$f":" Inputs!I$281","v":0},{"$f":" Inputs!J$281","v":0},{"$f":" Inputs!K$281","v":0},{"$f":" Inputs!L$281","v":0},{"$f":" Inputs!M$281","v":0},{"$f":" Inputs!N$281","v":0},{"$f":" Inputs!O$281","v":0},{"$f":" Inputs!P$281","v":0},{"$f":" Inputs!Q$281","v":0},{"$f":" Inputs!R$281","v":0},{"$f":" Inputs!S$281","v":0}]
[null,null,null,null,{"$f":" Inputs!E$282","v":"NEW MODEL INPUTS - Water network - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$282","v":0},{"$f":" Inputs!G$282","v":"£m"},{"$f":" Inputs!H$282","v":-0.78261878905371096},{"$f":" Inputs!I$282","v":0},{"$f":" Inputs!J$282","v":0},{"$f":" Inputs!K$282","v":0},{"$f":" Inputs!L$282","v":-0.14708086425150499},{"$f":" Inputs!M$282","v":-0.15165507912972601},{"$f":" Inputs!N$282","v":-0.156371552090661},{"$f":" Inputs!O$282","v":-0.16124823671006799},{"$f":" Inputs!P$282","v":-0.166263056871751},{"$f":" Inputs!Q$282","v":0},{"$f":" Inputs!R$282","v":0},{"$f":" Inputs!S$282","v":0}]
[null,null,null,null,{"$f":" Inputs!E$283","v":"NEW MODEL INPUTS - Wastewater network - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$283","v":0},{"$f":" Inputs!G$283","v":"£m"},{"$f":" Inputs!H$283","v":0},{"$f":" Inputs!I$283","v":0},{"$f":" Inputs!J$283","v":0},{"$f":" Inputs!K$283","v":0},{"$f":" Inputs!L$283","v":0},{"$f":" Inputs!M$283","v":0},{"$f":" Inputs!N$283","v":0},{"$f":" Inputs!O$283","v":0},{"$f":" Inputs!P$283","v":0},{"$f":" Inputs!Q$283","v":0},{"$f":" Inputs!R$283","v":0},{"$f":" Inputs!S$283","v":0}]
[null,null,null,null,{"$f":" Inputs!E$284","v":"NEW MODEL INPUTS - Bio resources - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$284","v":0},{"$f":" Inputs!G$284","v":"£m"},{"$f":" Inputs!H$284","v":0},{"$f":" Inputs!I$284","v":0},{"$f":" Inputs!J$284","v":0},{"$f":" Inputs!K$284","v":0},{"$f":" Inputs!L$284","v":0},{"$f":" Inputs!M$284","v":0},{"$f":" Inputs!N$284","v":0},{"$f":" Inputs!O$284","v":0},{"$f":" Inputs!P$284","v":0},{"$f":" Inputs!Q$284","v":0},{"$f":" Inputs!R$284","v":0},{"$f":" Inputs!S$284","v":0}]
[null,null,null,null,{"$f":" Inputs!E$285","v":"NEW MODEL INPUTS - Dummy control - Totex (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$285","v":0},{"$f":" Inputs!G$285","v":"£m"},{"$f":" Inputs!H$285","v":0},{"$f":" Inputs!I$285","v":0},{"$f":" Inputs!J$285","v":0},{"$f":" Inputs!K$285","v":0},{"$f":" Inputs!L$285","v":0},{"$f":" Inputs!M$285","v":0},{"$f":" Inputs!N$285","v":0},{"$f":" Inputs!O$285","v":0},{"$f":" Inputs!P$285","v":0},{"$f":" Inputs!Q$285","v":0},{"$f":" Inputs!R$285","v":0},{"$f":" Inputs!S$285","v":0}]
[null,null,null,null,{"$f":" Inputs!E$286","v":0}]
[null,null,null,null,"Difference in Totex adjustment WR - real",null,"£m",{"$f":"SUM(J40:S40)","v":0},null,{"$f":"J28-J34","v":0},{"$f":"K28-K34","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in Totex adjustment WN - real",null,"£m",{"$f":"SUM(J41:S41)","v":0},null,{"$f":"J29-J35","v":0},{"$f":"K29-K35","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in Totex adjustment WWN - real",null,"£m",{"$f":"SUM(J42:S42)","v":0},null,{"$f":"J30-J36","v":0},{"$f":"K30-K36","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in Totex adjustment BR - real",null,"£m",{"$f":"SUM(J43:S43)","v":0},null,{"$f":"J31-J37","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in Totex adjustment DMMY - real",null,"£m",{"$f":"SUM(J44:S44)","v":0},null,{"$f":"J32-J38","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Inputs!E$161","v":"FD MODEL INPUTS - Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$161","v":0},{"$f":" Inputs!G$161","v":"£m"},{"$f":" Inputs!H$161","v":0},{"$f":" Inputs!I$161","v":0},{"$f":" Inputs!J$161","v":0},{"$f":" Inputs!K$161","v":0},{"$f":" Inputs!L$161","v":0},{"$f":" Inputs!M$161","v":0},{"$f":" Inputs!N$161","v":0},{"$f":" Inputs!O$161","v":0},{"$f":" Inputs!P$161","v":0},{"$f":" Inputs!Q$161","v":0},{"$f":" Inputs!R$161","v":0},{"$f":" Inputs!S$161","v":0}]
[null,null,null,null,{"$f":" Inputs!E$162","v":"FD MODEL INPUTS - Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$162","v":0},{"$f":" Inputs!G$162","v":"£m"},{"$f":" Inputs!H$162","v":-4.7270735030328384},{"$f":" Inputs!I$162","v":0},{"$f":" Inputs!J$162","v":0},{"$f":" Inputs!K$162","v":0},{"$f":" Inputs!L$162","v":-0.88837894761908298},{"$f":" Inputs!M$162","v":-0.916007532890037},{"$f":" Inputs!N$162","v":-0.94449536716291704},{"$f":" Inputs!O$162","v":-0.97395089132037105},{"$f":" Inputs!P$162","v":-1.0042407640404301},{"$f":" Inputs!Q$162","v":0},{"$f":" Inputs!R$162","v":0},{"$f":" Inputs!S$162","v":0}]
[null,null,null,null,{"$f":" Inputs!E$163","v":"FD MODEL INPUTS - Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$163","v":0},{"$f":" Inputs!G$163","v":"£m"},{"$f":" Inputs!H$163","v":0},{"$f":" Inputs!I$163","v":0},{"$f":" Inputs!J$163","v":0},{"$f":" Inputs!K$163","v":0},{"$f":" Inputs!L$163","v":0},{"$f":" Inputs!M$163","v":0},{"$f":" Inputs!N$163","v":0},{"$f":" Inputs!O$163","v":0},{"$f":" Inputs!P$163","v":0},{"$f":" Inputs!Q$163","v":0},{"$f":" Inputs!R$163","v":0},{"$f":" Inputs!S$163","v":0}]
[null,null,null,null,{"$f":" Inputs!E$164","v":"FD MODEL INPUTS - Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$164","v":0},{"$f":" Inputs!G$164","v":"£m"},{"$f":" Inputs!H$164","v":0},{"$f":" Inputs!I$164","v":0},{"$f":" Inputs!J$164","v":0},{"$f":" Inputs!K$164","v":0},{"$f":" Inputs!L$164","v":0},{"$f":" Inputs!M$164","v":0},{"$f":" Inputs!N$164","v":0},{"$f":" Inputs!O$164","v":0},{"$f":" Inputs!P$164","v":0},{"$f":" Inputs!Q$164","v":0},{"$f":" Inputs!R$164","v":0},{"$f":" Inputs!S$164","v":0}]
[null,null,null,null,{"$f":" Inputs!E$165","v":"FD MODEL INPUTS - Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$165","v":0},{"$f":" Inputs!G$165","v":"£m"},{"$f":" Inputs!H$165","v":0},{"$f":" Inputs!I$165","v":0},{"$f":" Inputs!J$165","v":0},{"$f":" Inputs!K$165","v":0},{"$f":" Inputs!L$165","v":0},{"$f":" Inputs!M$165","v":0},{"$f":" Inputs!N$165","v":0},{"$f":" Inputs!O$165","v":0},{"$f":" Inputs!P$165","v":0},{"$f":" Inputs!Q$165","v":0},{"$f":" Inputs!R$165","v":0},{"$f":" Inputs!S$165","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$287","v":"NEW MODEL INPUTS - Water resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$287","v":0},{"$f":" Inputs!G$287","v":"£m"},{"$f":" Inputs!H$287","v":0},{"$f":" Inputs!I$287","v":0},{"$f":" Inputs!J$287","v":0},{"$f":" Inputs!K$287","v":0},{"$f":" Inputs!L$287","v":0},{"$f":" Inputs!M$287","v":0},{"$f":" Inputs!N$287","v":0},{"$f":" Inputs!O$287","v":0},{"$f":" Inputs!P$287","v":0},{"$f":" Inputs!Q$287","v":0},{"$f":" Inputs!R$287","v":0},{"$f":" Inputs!S$287","v":0}]
[null,null,null,null,{"$f":" Inputs!E$288","v":"NEW MODEL INPUTS - Water network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$288","v":0},{"$f":" Inputs!G$288","v":"£m"},{"$f":" Inputs!H$288","v":-4.7270735030328384},{"$f":" Inputs!I$288","v":0},{"$f":" Inputs!J$288","v":0},{"$f":" Inputs!K$288","v":0},{"$f":" Inputs!L$288","v":-0.88837894761908298},{"$f":" Inputs!M$288","v":-0.916007532890037},{"$f":" Inputs!N$288","v":-0.94449536716291704},{"$f":" Inputs!O$288","v":-0.97395089132037105},{"$f":" Inputs!P$288","v":-1.0042407640404301},{"$f":" Inputs!Q$288","v":0},{"$f":" Inputs!R$288","v":0},{"$f":" Inputs!S$288","v":0}]
[null,null,null,null,{"$f":" Inputs!E$289","v":"NEW MODEL INPUTS - Wastewater network - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$289","v":0},{"$f":" Inputs!G$289","v":"£m"},{"$f":" Inputs!H$289","v":0},{"$f":" Inputs!I$289","v":0},{"$f":" Inputs!J$289","v":0},{"$f":" Inputs!K$289","v":0},{"$f":" Inputs!L$289","v":0},{"$f":" Inputs!M$289","v":0},{"$f":" Inputs!N$289","v":0},{"$f":" Inputs!O$289","v":0},{"$f":" Inputs!P$289","v":0},{"$f":" Inputs!Q$289","v":0},{"$f":" Inputs!R$289","v":0},{"$f":" Inputs!S$289","v":0}]
[null,null,null,null,{"$f":" Inputs!E$290","v":"NEW MODEL INPUTS - Bio resources - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$290","v":0},{"$f":" Inputs!G$290","v":"£m"},{"$f":" Inputs!H$290","v":0},{"$f":" Inputs!I$290","v":0},{"$f":" Inputs!J$290","v":0},{"$f":" Inputs!K$290","v":0},{"$f":" Inputs!L$290","v":0},{"$f":" Inputs!M$290","v":0},{"$f":" Inputs!N$290","v":0},{"$f":" Inputs!O$290","v":0},{"$f":" Inputs!P$290","v":0},{"$f":" Inputs!Q$290","v":0},{"$f":" Inputs!R$290","v":0},{"$f":" Inputs!S$290","v":0}]
[null,null,null,null,{"$f":" Inputs!E$291","v":"NEW MODEL INPUTS - Dummy control - WRFIM (+ or -) Value Chosen - active - adjusted - real"},{"$f":" Inputs!F$291","v":0},{"$f":" Inputs!G$291","v":"£m"},{"$f":" Inputs!H$291","v":0},{"$f":" Inputs!I$291","v":0},{"$f":" Inputs!J$291","v":0},{"$f":" Inputs!K$291","v":0},{"$f":" Inputs!L$291","v":0},{"$f":" Inputs!M$291","v":0},{"$f":" Inputs!N$291","v":0},{"$f":" Inputs!O$291","v":0},{"$f":" Inputs!P$291","v":0},{"$f":" Inputs!Q$291","v":0},{"$f":" Inputs!R$291","v":0},{"$f":" Inputs!S$291","v":0}]
[]
[null,null,null,null,"Difference in WRFIM adjustment WR - real",null,"£m",{"$f":"SUM(J58:S58)","v":0},null,{"$f":"J46-J52","v":0},{"$f":"K46-K52","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in WRFIM adjustment WN - real",null,"£m",{"$f":"SUM(J59:S59)","v":0},null,{"$f":"J47-J53","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in WRFIM adjustment WWN - real",null,"£m",{"$f":"SUM(J60:S60)","v":0},null,{"$f":"J48-J54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in WRFIM adjustment BR - real",null,"£m",{"$f":"SUM(J61:S61)","v":0},null,{"$f":"J49-J55","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in WRFIM adjustment DMMY - real",null,"£m",{"$f":"SUM(J62:S62)","v":0},null,{"$f":"J50-J56","v":0},0,0,0,0,0,0,0,0,0]
[]
["Time value of money factors"]
[null,null,null,null,{"$f":" Inputs!E$31","v":"Financing cost index"},{"$f":" Inputs!F$31","v":0},{"$f":" Inputs!G$31","v":"Index"},{"$f":" Inputs!H$31","v":0},{"$f":" Inputs!I$31","v":0},{"$f":" Inputs!J$31","v":0},{"$f":" Inputs!K$31","v":0},{"$f":" Inputs!L$31","v":4},{"$f":" Inputs!M$31","v":3},{"$f":" Inputs!N$31","v":2},{"$f":" Inputs!O$31","v":1},{"$f":" Inputs!P$31","v":0},{"$f":" Inputs!Q$31","v":0},{"$f":" Inputs!R$31","v":0},{"$f":" Inputs!S$31","v":0}]
[null,null,null,null,{"$f":" Inputs!E$25","v":"WACC - WR"},{"$f":" Inputs!F$25","v":3.1099999999999999E-2},{"$f":" Inputs!G$25","v":"%"}]
[null,null,null,null,"Time value of money factor - WR",null,"Factor",null,null,{"$f":"(1+$F66) ^ J65","v":1},{"$f":"(1+$F66) ^ K65","v":1},1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1,1,1]
[]
[null,null,null,null,{"$f":" Inputs!E$31","v":"Financing cost index"},{"$f":" Inputs!F$31","v":0},{"$f":" Inputs!G$31","v":"Index"},{"$f":" Inputs!H$31","v":0},{"$f":" Inputs!I$31","v":0},{"$f":" Inputs!J$31","v":0},{"$f":" Inputs!K$31","v":0},{"$f":" Inputs!L$31","v":4},{"$f":" Inputs!M$31","v":3},{"$f":" Inputs!N$31","v":2},{"$f":" Inputs!O$31","v":1},{"$f":" Inputs!P$31","v":0},{"$f":" Inputs!Q$31","v":0},{"$f":" Inputs!R$31","v":0},{"$f":" Inputs!S$31","v":0}]
[null,null,null,null,{"$f":" Inputs!E$26","v":"WACC - WN"},{"$f":" Inputs!F$26","v":3.1099999999999999E-2},{"$f":" Inputs!G$26","v":"%"}]
[null,null,null,null,"Time value of money factor - WN",null,"Factor",null,null,{"$f":"(1+$F70) ^ J69","v":1},1,1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1,1,1]
[]
[null,null,null,null,{"$f":" Inputs!E$31","v":"Financing cost index"},{"$f":" Inputs!F$31","v":0},{"$f":" Inputs!G$31","v":"Index"},{"$f":" Inputs!H$31","v":0},{"$f":" Inputs!I$31","v":0},{"$f":" Inputs!J$31","v":0},{"$f":" Inputs!K$31","v":0},{"$f":" Inputs!L$31","v":4},{"$f":" Inputs!M$31","v":3},{"$f":" Inputs!N$31","v":2},{"$f":" Inputs!O$31","v":1},{"$f":" Inputs!P$31","v":0},{"$f":" Inputs!Q$31","v":0},{"$f":" Inputs!R$31","v":0},{"$f":" Inputs!S$31","v":0}]
[null,null,null,null,{"$f":" Inputs!E$27","v":"WACC - WWN"},{"$f":" Inputs!F$27","v":0},{"$f":" Inputs!G$27","v":"%"}]
[null,null,null,null,"Time value of money factor - WWN",null,"Factor",null,null,{"$f":"(1+$F74) ^ J73","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" Inputs!E$31","v":"Financing cost index"},{"$f":" Inputs!F$31","v":0},{"$f":" Inputs!G$31","v":"Index"},{"$f":" Inputs!H$31","v":0},{"$f":" Inputs!I$31","v":0},{"$f":" Inputs!J$31","v":0},{"$f":" Inputs!K$31","v":0},{"$f":" Inputs!L$31","v":4},{"$f":" Inputs!M$31","v":3},{"$f":" Inputs!N$31","v":2},{"$f":" Inputs!O$31","v":1},{"$f":" Inputs!P$31","v":0},{"$f":" Inputs!Q$31","v":0},{"$f":" Inputs!R$31","v":0},{"$f":" Inputs!S$31","v":0}]
[null,null,null,null,{"$f":" Inputs!E$28","v":"WACC - BR"},{"$f":" Inputs!F$28","v":0},{"$f":" Inputs!G$28","v":"%"}]
[null,null,null,null,"Time value of money factor - BR",null,"Factor",null,null,{"$f":"(1+$F78) ^ J77","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" Inputs!E$31","v":"Financing cost index"},{"$f":" Inputs!F$31","v":0},{"$f":" Inputs!G$31","v":"Index"},{"$f":" Inputs!H$31","v":0},{"$f":" Inputs!I$31","v":0},{"$f":" Inputs!J$31","v":0},{"$f":" Inputs!K$31","v":0},{"$f":" Inputs!L$31","v":4},{"$f":" Inputs!M$31","v":3},{"$f":" Inputs!N$31","v":2},{"$f":" Inputs!O$31","v":1},{"$f":" Inputs!P$31","v":0},{"$f":" Inputs!Q$31","v":0},{"$f":" Inputs!R$31","v":0},{"$f":" Inputs!S$31","v":0}]
[null,null,null,null,{"$f":" Inputs!E$29","v":"WACC - DMMY"},{"$f":" Inputs!F$29","v":2.92E-2},{"$f":" Inputs!G$29","v":"%"}]
[null,null,null,null,"Time value of money factor - DMMY",null,"Factor",null,null,{"$f":"(1+$F82) ^ J81","v":1},1,1.122016155346969,1.0901828170879997,1.0592526399999997,1.0291999999999999,1,1,1,1]
[]
["Revenue adjustment for WR"]
[null,null,null,null,{"$f":" E$20","v":"Difference in tax revenue WR - real"},{"$f":" F$20","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Inputs!E$35","v":"Manual adjustment - WR - real"},{"$f":" Inputs!F$35","v":0},{"$f":" Inputs!G$35","v":"£m"},{"$f":" Inputs!H$35","v":0},{"$f":" Inputs!I$35","v":0},{"$f":" Inputs!J$35","v":0},{"$f":" Inputs!K$35","v":0},{"$f":" Inputs!L$35","v":0},{"$f":" Inputs!M$35","v":0},{"$f":" Inputs!N$35","v":0},{"$f":" Inputs!O$35","v":0},{"$f":" Inputs!P$35","v":0},{"$f":" Inputs!Q$35","v":0},{"$f":" Inputs!R$35","v":0},{"$f":" Inputs!S$35","v":0}]
[null,null,null,null,{"$f":" E$67","v":"Time value of money factor - WR"},{"$f":" F$67","v":0},"Factor",0,0,1,1,1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1,1,1]
[null,null,null,null,"Revenue adjustment for WR - real",null,"£m",{"$f":"SUM(J89:S89)","v":0},null,{"$f":" SUM(J86:J87) * J88","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$89","v":"Revenue adjustment for WR - real"},{"$f":" F$89","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Revenue adjustment for WR - real",{"$f":"SUM(L91:P91)","v":0},"£m"]
[]
["Revenue adjustment for WN"]
[null,null,null,null,{"$f":" E$21","v":"Difference in tax revenue WN - real"},{"$f":" F$21","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Inputs!E$36","v":"Manual adjustment - WN - real"},{"$f":" Inputs!F$36","v":0},{"$f":" Inputs!G$36","v":"£m"},{"$f":" Inputs!H$36","v":0},{"$f":" Inputs!I$36","v":0},{"$f":" Inputs!J$36","v":0},{"$f":" Inputs!K$36","v":0},{"$f":" Inputs!L$36","v":0},{"$f":" Inputs!M$36","v":0},{"$f":" Inputs!N$36","v":0},{"$f":" Inputs!O$36","v":0},{"$f":" Inputs!P$36","v":0},{"$f":" Inputs!Q$36","v":0},{"$f":" Inputs!R$36","v":0},{"$f":" Inputs!S$36","v":0}]
[null,null,null,null,{"$f":" E$71","v":"Time value of money factor - WN"},{"$f":" F$71","v":0},"Factor",0,0,1,1,1.1303245164191837,1.0962317102309997,1.0631672099999998,1.0310999999999999,1,1,1,1]
[null,null,null,null,"Revenue adjustment for WN - real",null,"£m",{"$f":"SUM(J98:S98)","v":0},null,{"$f":" SUM(J95:J96) * J97","v":0},{"$f":" SUM(K95:K96) * K97","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E98","v":"Revenue adjustment for WN - real"},{"$f":"F98","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Revenue adjustment for WN - real",{"$f":"SUM(L100:P100)","v":0},"£m"]
[]
["Revenue adjustment for WWN"]
[null,null,null,null,{"$f":" E$22","v":"Difference in tax revenue WWN - real"},{"$f":" F$22","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Inputs!E$37","v":"Manual adjustment - WWN - real"},{"$f":" Inputs!F$37","v":0},{"$f":" Inputs!G$37","v":"£m"},{"$f":" Inputs!H$37","v":0},{"$f":" Inputs!I$37","v":0},{"$f":" Inputs!J$37","v":0},{"$f":" Inputs!K$37","v":0},{"$f":" Inputs!L$37","v":0},{"$f":" Inputs!M$37","v":0},{"$f":" Inputs!N$37","v":0},{"$f":" Inputs!O$37","v":0},{"$f":" Inputs!P$37","v":0},{"$f":" Inputs!Q$37","v":0},{"$f":" Inputs!R$37","v":0},{"$f":" Inputs!S$37","v":0}]
[null,null,null,null,{"$f":" E$75","v":"Time value of money factor - WWN"},{"$f":" F$75","v":0},"Factor",0,0,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Revenue adjustment for WWN - real",null,"£m",{"$f":"SUM(J107:S107)","v":0},null,{"$f":" SUM(J104:J105) * J106","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$107","v":"Revenue adjustment for WWN - real"},{"$f":" F$107","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Revenue adjustment for WWN - real",{"$f":"SUM(L109:P109)","v":0},"£m"]
[]
["Revenue adjustment for BR"]
[null,null,null,null,{"$f":" E$23","v":"Difference in tax revenue BR - real"},{"$f":" F$23","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Inputs!E$38","v":"Manual adjustment - BR - real"},{"$f":" Inputs!F$38","v":0},{"$f":" Inputs!G$38","v":"£m"},{"$f":" Inputs!H$38","v":0},{"$f":" Inputs!I$38","v":0},{"$f":" Inputs!J$38","v":0},{"$f":" Inputs!K$38","v":0},{"$f":" Inputs!L$38","v":0},{"$f":" Inputs!M$38","v":0},{"$f":" Inputs!N$38","v":0},{"$f":" Inputs!O$38","v":0},{"$f":" Inputs!P$38","v":0},{"$f":" Inputs!Q$38","v":0},{"$f":" Inputs!R$38","v":0},{"$f":" Inputs!S$38","v":0}]
[null,null,null,null,{"$f":" E$79","v":"Time value of money factor - BR"},{"$f":" F$79","v":0},"Factor",0,0,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Revenue adjustment for BR - real",null,"£m",{"$f":"SUM(J116:S116)","v":0},null,{"$f":" SUM(J113:J114) * J115","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$116","v":"Revenue adjustment for BR - real"},{"$f":" F$116","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Revenue adjustment for BR  real",{"$f":"SUM(L118:P118)","v":0},"£m"]
[]
["Revenue adjustment for DMMY"]
[null,null,null,null,{"$f":" E$24","v":"Difference in tax revenue DMMY - real"},{"$f":" F$24","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Inputs!E$39","v":"Manual adjustment - DMMY - real"},{"$f":" Inputs!F$39","v":0},{"$f":" Inputs!G$39","v":"£m"},{"$f":" Inputs!H$39","v":0},{"$f":" Inputs!I$39","v":0},{"$f":" Inputs!J$39","v":0},{"$f":" Inputs!K$39","v":0},{"$f":" Inputs!L$39","v":0},{"$f":" Inputs!M$39","v":0},{"$f":" Inputs!N$39","v":0},{"$f":" Inputs!O$39","v":0},{"$f":" Inputs!P$39","v":0},{"$f":" Inputs!Q$39","v":0},{"$f":" Inputs!R$39","v":0},{"$f":" Inputs!S$39","v":0}]
[null,null,null,null,{"$f":" E$83","v":"Time value of money factor - DMMY"},{"$f":" F$83","v":0},"Factor",0,0,1,1,1.122016155346969,1.0901828170879997,1.0592526399999997,1.0291999999999999,1,1,1,1]
[null,null,null,null,"Revenue adjustment for DMMY - real",null,"£m",{"$f":"SUM(J125:S125)","v":0},null,{"$f":" SUM(J122:J123) * J124","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$125","v":"Revenue adjustment for DMMY - real"},{"$f":" F$125","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Revenue adjustment for DMMY - real",{"$f":"SUM(L127:P127)","v":0},"£m"]
[]
["Allowed revenue difference"]
[null,null,null,null,{"$f":" Inputs!E$111","v":"FD MODEL INPUTS - Water resources - Allowed Revenues - real"},{"$f":" Inputs!F$111","v":0},{"$f":" Inputs!G$111","v":"£m"},{"$f":" Inputs!H$111","v":30.706373682072236},{"$f":" Inputs!I$111","v":0},{"$f":" Inputs!J$111","v":0},{"$f":" Inputs!K$111","v":0},{"$f":" Inputs!L$111","v":5.5746950615134043},{"$f":" Inputs!M$111","v":5.5952739400354572},{"$f":" Inputs!N$111","v":5.6014440675656294},{"$f":" Inputs!O$111","v":5.630792508201365},{"$f":" Inputs!P$111","v":5.5548256987036693},{"$f":" Inputs!Q$111","v":0.56915878552479204},{"$f":" Inputs!R$111","v":0.57006368356461512},{"$f":" Inputs!S$111","v":0.56045981523896704}]
[null,null,null,null,{"$f":" Inputs!E$112","v":"FD MODEL INPUTS - Water network - Allowed Revenues - real"},{"$f":" Inputs!F$112","v":0},{"$f":" Inputs!G$112","v":"£m"},{"$f":" Inputs!H$112","v":194.94984977477199},{"$f":" Inputs!I$112","v":0},{"$f":" Inputs!J$112","v":0},{"$f":" Inputs!K$112","v":0},{"$f":" Inputs!L$112","v":28.433832993938683},{"$f":" Inputs!M$112","v":28.684006812506301},{"$f":" Inputs!N$112","v":28.795534875786078},{"$f":" Inputs!O$112","v":28.541745283076512},{"$f":" Inputs!P$112","v":28.338729479273603},{"$f":" Inputs!Q$112","v":11.657055029779121},{"$f":" Inputs!R$112","v":11.059849028203352},{"$f":" Inputs!S$112","v":10.498279635585581}]
[null,null,null,null,{"$f":" Inputs!E$113","v":"FD MODEL INPUTS - Wastewater network - Allowed Revenues - real"},{"$f":" Inputs!F$113","v":0},{"$f":" Inputs!G$113","v":"£m"},{"$f":" Inputs!H$113","v":0},{"$f":" Inputs!I$113","v":0},{"$f":" Inputs!J$113","v":0},{"$f":" Inputs!K$113","v":0},{"$f":" Inputs!L$113","v":0},{"$f":" Inputs!M$113","v":0},{"$f":" Inputs!N$113","v":0},{"$f":" Inputs!O$113","v":0},{"$f":" Inputs!P$113","v":0},{"$f":" Inputs!Q$113","v":0},{"$f":" Inputs!R$113","v":0},{"$f":" Inputs!S$113","v":0}]
[null,null,null,null,{"$f":" Inputs!E$114","v":"FD MODEL INPUTS - Bio resources - Allowed Revenues - real"},{"$f":" Inputs!F$114","v":0},{"$f":" Inputs!G$114","v":"£m"},{"$f":" Inputs!H$114","v":0},{"$f":" Inputs!I$114","v":0},{"$f":" Inputs!J$114","v":0},{"$f":" Inputs!K$114","v":0},{"$f":" Inputs!L$114","v":0},{"$f":" Inputs!M$114","v":0},{"$f":" Inputs!N$114","v":0},{"$f":" Inputs!O$114","v":0},{"$f":" Inputs!P$114","v":0},{"$f":" Inputs!Q$114","v":0},{"$f":" Inputs!R$114","v":0},{"$f":" Inputs!S$114","v":0}]
[null,null,null,null,{"$f":" Inputs!E$115","v":"FD MODEL INPUTS - Dummy control - Allowed Revenues - real"},{"$f":" Inputs!F$115","v":0},{"$f":" Inputs!G$115","v":"£m"},{"$f":" Inputs!H$115","v":0},{"$f":" Inputs!I$115","v":0},{"$f":" Inputs!J$115","v":0},{"$f":" Inputs!K$115","v":0},{"$f":" Inputs!L$115","v":0},{"$f":" Inputs!M$115","v":0},{"$f":" Inputs!N$115","v":0},{"$f":" Inputs!O$115","v":0},{"$f":" Inputs!P$115","v":0},{"$f":" Inputs!Q$115","v":0},{"$f":" Inputs!R$115","v":0},{"$f":" Inputs!S$115","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$237","v":"NEW MODEL INPUTS - Water resources - Allowed Revenues - real"},{"$f":" Inputs!F$237","v":0},{"$f":" Inputs!G$237","v":"£m"},{"$f":" Inputs!H$237","v":30.706373682072236},{"$f":" Inputs!I$237","v":0},{"$f":" Inputs!J$237","v":0},{"$f":" Inputs!K$237","v":0},{"$f":" Inputs!L$237","v":5.5746950615134043},{"$f":" Inputs!M$237","v":5.5952739400354572},{"$f":" Inputs!N$237","v":5.6014440675656294},{"$f":" Inputs!O$237","v":5.630792508201365},{"$f":" Inputs!P$237","v":5.5548256987036693},{"$f":" Inputs!Q$237","v":0.56915878552479204},{"$f":" Inputs!R$237","v":0.57006368356461512},{"$f":" Inputs!S$237","v":0.56045981523896704}]
[null,null,null,null,{"$f":" Inputs!E$238","v":"NEW MODEL INPUTS - Water network - Allowed Revenues - real"},{"$f":" Inputs!F$238","v":0},{"$f":" Inputs!G$238","v":"£m"},{"$f":" Inputs!H$238","v":194.94984977477199},{"$f":" Inputs!I$238","v":0},{"$f":" Inputs!J$238","v":0},{"$f":" Inputs!K$238","v":0},{"$f":" Inputs!L$238","v":28.433832993938683},{"$f":" Inputs!M$238","v":28.684006812506301},{"$f":" Inputs!N$238","v":28.795534875786078},{"$f":" Inputs!O$238","v":28.541745283076512},{"$f":" Inputs!P$238","v":28.338729479273603},{"$f":" Inputs!Q$238","v":11.657055029779121},{"$f":" Inputs!R$238","v":11.059849028203352},{"$f":" Inputs!S$238","v":10.498279635585581}]
[null,null,null,null,{"$f":" Inputs!E$239","v":"NEW MODEL INPUTS - Wastewater network - Allowed Revenues - real"},{"$f":" Inputs!F$239","v":0},{"$f":" Inputs!G$239","v":"£m"},{"$f":" Inputs!H$239","v":0},{"$f":" Inputs!I$239","v":0},{"$f":" Inputs!J$239","v":0},{"$f":" Inputs!K$239","v":0},{"$f":" Inputs!L$239","v":0},{"$f":" Inputs!M$239","v":0},{"$f":" Inputs!N$239","v":0},{"$f":" Inputs!O$239","v":0},{"$f":" Inputs!P$239","v":0},{"$f":" Inputs!Q$239","v":0},{"$f":" Inputs!R$239","v":0},{"$f":" Inputs!S$239","v":0}]
[null,null,null,null,{"$f":" Inputs!E$240","v":"NEW MODEL INPUTS - Bio resources - Allowed Revenues - real"},{"$f":" Inputs!F$240","v":0},{"$f":" Inputs!G$240","v":"£m"},{"$f":" Inputs!H$240","v":0},{"$f":" Inputs!I$240","v":0},{"$f":" Inputs!J$240","v":0},{"$f":" Inputs!K$240","v":0},{"$f":" Inputs!L$240","v":0},{"$f":" Inputs!M$240","v":0},{"$f":" Inputs!N$240","v":0},{"$f":" Inputs!O$240","v":0},{"$f":" Inputs!P$240","v":0},{"$f":" Inputs!Q$240","v":0},{"$f":" Inputs!R$240","v":0},{"$f":" Inputs!S$240","v":0}]
[null,null,null,null,{"$f":" Inputs!E$241","v":"NEW MODEL INPUTS - Dummy control - Allowed Revenues - real"},{"$f":" Inputs!F$241","v":0},{"$f":" Inputs!G$241","v":"£m"},{"$f":" Inputs!H$241","v":0},{"$f":" Inputs!I$241","v":0},{"$f":" Inputs!J$241","v":0},{"$f":" Inputs!K$241","v":0},{"$f":" Inputs!L$241","v":0},{"$f":" Inputs!M$241","v":0},{"$f":" Inputs!N$241","v":0},{"$f":" Inputs!O$241","v":0},{"$f":" Inputs!P$241","v":0},{"$f":" Inputs!Q$241","v":0},{"$f":" Inputs!R$241","v":0},{"$f":" Inputs!S$241","v":0}]
[]
[null,null,null,null,"Difference in allowed revenue WR - real",null,"£m",{"$f":"SUM(J143:S143)","v":0},null,{"$f":"J137-J131","v":0},{"$f":"K137-K131","v":0},{"$f":"L137-L131","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Difference in allowed revenue WN - real",null,"£m",{"$f":"SUM(J144:S144)","v":0},null,{"$f":"J138-J132","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in allowed revenue WWN - real",null,"£m",{"$f":"SUM(J145:S145)","v":0},null,{"$f":"J139-J133","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in allowed revenue BR - real",null,"£m",{"$f":"SUM(J146:S146)","v":0},null,{"$f":"J140-J134","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference in allowed revenue DMMY - real",null,"£m",{"$f":"SUM(J147:S147)","v":0},null,{"$f":"J141-J135","v":0},0,0,0,0,0,0,0,0,0]
[]
["Check"]
[null,null,null,null,{"$f":" E$20","v":"Difference in tax revenue WR - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$21","v":"Difference in tax revenue WN - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$22","v":"Difference in tax revenue WWN - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$23","v":"Difference in tax revenue BR - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$24","v":"Difference in tax revenue DMMY - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$40","v":"Difference in Totex adjustment WR - real"},{"$f":" F$40","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$41","v":"Difference in Totex adjustment WN - real"},{"$f":" F$41","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$42","v":"Difference in Totex adjustment WWN - real"},{"$f":" F$42","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$43","v":"Difference in Totex adjustment BR - real"},{"$f":" F$43","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$44","v":"Difference in Totex adjustment DMMY - real"},{"$f":" F$44","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$58","v":"Difference in WRFIM adjustment WR - real"},{"$f":" F$58","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$59","v":"Difference in WRFIM adjustment WN - real"},{"$f":" F$59","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$60","v":"Difference in WRFIM adjustment WWN - real"},{"$f":" F$60","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$61","v":"Difference in WRFIM adjustment BR - real"},{"$f":" F$61","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$62","v":"Difference in WRFIM adjustment DMMY - real"},{"$f":" F$62","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$143","v":"Difference in allowed revenue WR - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$144","v":"Difference in allowed revenue WN - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$145","v":"Difference in allowed revenue WWN - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$146","v":"Difference in allowed revenue BR - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$147","v":"Difference in allowed revenue DMMY - real"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WR",null,null,null,null,{"$f":"J150-J168-J156-J162","v":0},{"$f":"K150-K168-K156-K162","v":0},{"$f":"L150-L168-L156-L162","v":0},{"$f":"M150-M168-M156-M162","v":0},0,0,0,0,0,0]
[null,null,null,null,"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WN",null,null,null,null,{"$f":"J151-J169-J157-J163","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WWN",null,null,null,null,{"$f":"J152-J170-J158-J164","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) BR",null,null,null,null,{"$f":"J153-J171-J159-J165","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) DMMY",null,null,null,null,{"$f":"J154-J172-J160-J166","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Inputs!E$20","v":"Model Check Tolerance Level"},{"$f":" Inputs!F$20","v":1E-3},{"$f":" Inputs!G$20","v":"tolerance"}]
[]
[null,null,null,null,{"$f":" E$174","v":"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WR"},0,0,0,0,0,0,{"$f":" L$174","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$175","v":"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WN"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$176","v":"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) WWN"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$177","v":"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) BR"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$178","v":"Difference on tax - difference on allowed revenue (adjusted for reconciliation adjustments) DMMY"},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Check  - difference on tax - difference on allowed revenue WR",null,"check",null,null,{"$f":"IF($F$180<ABS(J182),1,0)","v":0},{"$f":"IF($F$180<ABS(K182),1,0)","v":0},{"$f":"IF($F$180<ABS(L182),1,0)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Check  - difference on tax - difference on allowed revenue WN",null,"check",null,null,{"$f":"IF($F$180<ABS(J183),1,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Check  - difference on tax - difference on allowed revenue WWN",null,"check",null,null,{"$f":"IF($F$180<ABS(J184),1,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Check  - difference on tax - difference on allowed revenue BR",null,"check",null,null,{"$f":"IF($F$180<ABS(J185),1,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Check  - difference on tax - difference on allowed revenue DMMY",null,"check",null,null,{"$f":"IF($F$180<ABS(J186),1,0)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Check summary WR",{"$f":" IF(SUM(L188:P188) <> 0, 1, 0)","v":0},"check"]
[null,null,null,null,"Check summary WN",{"$f":" IF(SUM(L189:P189) <> 0, 1, 0)","v":0},"check"]
[null,null,null,null,"Check summary WWN",{"$f":" IF(SUM(L190:P190) <> 0, 1, 0)","v":0},"check"]
[null,null,null,null,"Check summary BR",{"$f":" IF(SUM(L191:P191) <> 0, 1, 0)","v":0},"check"]
[null,null,null,null,"Check summary DMMY",{"$f":" IF(SUM(L192:P192) <> 0, 1, 0)","v":0},"check"]
[]
["END"]

{"sheet":"Dashboard","index":6,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Dashboard"}]
[]
[null,null,null,"FD model name","PRT PR19 FD Financial model"]
[null,null,null,"New model name","PRT PR19 Capital allowance update Financial model"]
[]
[null,null,null,"Wholesale control","Price base","Allowed revenue adjustment £m"]
[null,null,null,"Water Resources","Real - 2017/18 FYA CPIH deflated",{"$f":"Calcs!F92","v":0}]
[null,null,null,"Water Network","Real - 2017/18 FYA CPIH deflated",{"$f":"Calcs!F101","v":0}]
[null,null,null,"Wastewater Network","Real - 2017/18 FYA CPIH deflated",{"$f":"Calcs!F110","v":0}]
[null,null,null,"Bioresources","Real - 2017/18 FYA CPIH deflated",{"$f":"Calcs!F119","v":0}]
[null,null,null,"Dummy","Real - 2017/18 FYA CPIH deflated",{"$f":"Calcs!F128","v":0}]
[]
[null,null,null,null,"FD model","New model"]
[null,null,null,"Reprofiling switch",{"$f":"Inputs!F127","v":0},{"$f":"Inputs!F253","v":0}]
[null,null,null,"Model error checks",{"$f":"Inputs!F129","v":0},{"$f":"Inputs!F255","v":0}]
[]
[null,null,null,null,"FD model","New model"]
[null,null,null,"Capital expenditure writing down allowance pool 1",{"$f":"Inputs!F117","v":0.18},{"$f":"Inputs!F243","v":0.18}]
[null,null,null,"Capital expenditure writing down allowance pool 2",{"$f":"Inputs!F118","v":0.06},{"$f":"Inputs!F244","v":0.06}]
[null,null,null,"Capital expenditure writing down allowance pool 3",{"$f":"Inputs!F119","v":0.02},{"$f":"Inputs!F245","v":0.03}]
[null,null,null,"2020-21 statutory tax rate",{"$f":"Inputs!L$121","v":0.17},{"$f":"Inputs!L$247","v":0.19}]
[null,null,null,"2021-22 statutory tax rate",{"$f":"Inputs!M$121","v":0.17},{"$f":"Inputs!M$247","v":0.19}]
[null,null,null,"2022-23 statutory tax rate",{"$f":"Inputs!N$121","v":0.17},{"$f":"Inputs!N$247","v":0.19}]
[null,null,null,"2023-24 statutory tax rate",{"$f":"Inputs!O$121","v":0.17},{"$f":"Inputs!O$247","v":0.25}]
[null,null,null,"2024-25 statutory tax rate",{"$f":"Inputs!P$121","v":0.17},{"$f":"Inputs!P$247","v":0.25}]
[null,null,null,"2020-21 index linked debt interest rate",{"$f":" Inputs!L$61","v":1.1490003519418313E-2},{"$f":"Inputs!L$249","v":1.7698873786408109E-2}]
[null,null,null,"2021-22 index linked debt interest rate",{"$f":" Inputs!M$61","v":1.1490003519418313E-2},{"$f":"Inputs!M$249","v":1.5822834951456199E-2}]
[null,null,null,"2022-23 index linked debt interest rate",{"$f":" Inputs!N$61","v":1.1490003519418313E-2},{"$f":"Inputs!N$249","v":1.4979805825242831E-2}]
[null,null,null,"2023-24 index linked debt interest rate",{"$f":" Inputs!O$61","v":1.1490003519418313E-2},{"$f":"Inputs!O$249","v":1.5418330097087152E-2}]
[null,null,null,"2024-25 index linked debt interest rate",{"$f":" Inputs!P$61","v":1.1490003519418313E-2},{"$f":"Inputs!P$249","v":1.614811650485426E-2}]
[null,null,null,"2020-21 index linked debt indexation rate",{"$f":" Inputs!L$62","v":0.03},{"$f":"Inputs!L$250","v":0.03}]
[null,null,null,"2021-22 index linked debt indexation rate",{"$f":" Inputs!M$62","v":0.03},{"$f":"Inputs!M$250","v":0.03}]
[null,null,null,"2022-23 index linked debt indexation rate",{"$f":" Inputs!N$62","v":0.03},{"$f":"Inputs!N$250","v":0.03}]
[null,null,null,"2023-24 index linked debt indexation rate",{"$f":" Inputs!O$62","v":0.03},{"$f":"Inputs!O$250","v":0.03}]
[null,null,null,"2024-25 index linked debt indexation rate",{"$f":" Inputs!P$62","v":0.03},{"$f":"Inputs!P$250","v":0.03}]
[null,null,null,"2020-21 nominal debt interest rate",{"$f":" Inputs!L$63","v":4.5134703625000903E-2},{"$f":"Inputs!L$251","v":4.822984000000019E-2}]
[null,null,null,"2021-22 nominal debt interest rate",{"$f":" Inputs!M$63","v":4.5134703625000903E-2},{"$f":"Inputs!M$251","v":4.6297520000000092E-2}]
[null,null,null,"2022-23 nominal debt interest rate",{"$f":" Inputs!N$63","v":4.5134703625000903E-2},{"$f":"Inputs!N$251","v":4.5429199999999947E-2}]
[null,null,null,"2023-24 nominal debt interest rate",{"$f":" Inputs!O$63","v":4.5134703625000903E-2},{"$f":"Inputs!O$251","v":4.5880880000000013E-2}]
[null,null,null,"2024-25 nominal debt interest rate",{"$f":" Inputs!P$63","v":4.5134703625000903E-2},{"$f":"Inputs!P$251","v":4.6632559999999823E-2}]
[null,null,null,"Totex - Tax allowance 5 year alert - WR",{"$f":" Inputs!F$81","v":0},{"$f":" Inputs!F$207","v":0}]
[null,null,null,"Totex - Tax allowance 5 year alert - WN",{"$f":" Inputs!F$82","v":0},{"$f":" Inputs!F$208","v":0}]
[null,null,null,"Totex - Tax allowance 5 year alert - WWN",{"$f":" Inputs!F$83","v":0},{"$f":" Inputs!F$209","v":0}]
[null,null,null,"Totex - Tax allowance 5 year alert - BR",{"$f":" Inputs!F$84","v":0},{"$f":" Inputs!F$210","v":0}]
[null,null,null,"Totex - Tax allowance 5 year alert - DMMY",{"$f":" Inputs!F$85","v":0},{"$f":" Inputs!F$211","v":0}]
[null,null,null,"WRFIM - Tax allowance 5 year alert - WR",{"$f":" Inputs!F$87","v":0},{"$f":" Inputs!F$213","v":0}]
[null,null,null,"WRFIM - Tax allowance 5 year alert - WN",{"$f":" Inputs!F$88","v":0},{"$f":" Inputs!F$214","v":0}]
[null,null,null,"WRFIM - Tax allowance 5 year alert - WWN",{"$f":" Inputs!F$89","v":0},{"$f":" Inputs!F$215","v":0}]
[null,null,null,"WRFIM - Tax allowance 5 year alert - BR",{"$f":" Inputs!F$90","v":0},{"$f":" Inputs!F$216","v":0}]
[null,null,null,"WRFIM - Tax allowance 5 year alert - DMMY",{"$f":" Inputs!F$91","v":0},{"$f":" Inputs!F$217","v":0}]
[]
[]
[]
["END"]

{"sheet":"Checks","index":7,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Checks"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period END"},{"$f":" Checks!$F$9","v":0},"Error chks"]
[null,null,null,null,{"$f":"Time!E$58","v":"Pre Forecast vs Forecast"}]
[null,null,null,null,{"$f":"Time!E$86","v":"Financial Year Ending"}]
[null,null,null,null,{"$f":"Time!E$10","v":"Model column counter"},"Constant","Unit","Total"]
[]
["CHECK SUMMARY"]
[]
[null,null,null,null,"Total Checks",{"$f":"SUM(F11:F20)","v":0},"check "]
[]
[null,null,null,null,"[do not delete this row]","[range start]"]
[]
[null,null,null,null,{"$f":" Time!E$77","v":"Modelling Period Check"},{"$f":" Time!F$77","v":0},{"$f":" Time!G$77","v":"check"}]
[null,null,null,null,{"$f":" Calcs!E$194","v":"Check summary WR"},{"$f":" Calcs!F$194","v":0},{"$f":" Calcs!G$194","v":"check"}]
[null,null,null,null,{"$f":" Calcs!E$195","v":"Check summary WN"},{"$f":" Calcs!F$195","v":0},{"$f":" Calcs!G$195","v":"check"}]
[null,null,null,null,{"$f":" Calcs!E$196","v":"Check summary WWN"},{"$f":" Calcs!F$196","v":0},{"$f":" Calcs!G$196","v":"check"}]
[null,null,null,null,{"$f":" Calcs!E$197","v":"Check summary BR"},{"$f":" Calcs!F$197","v":0},{"$f":" Calcs!G$197","v":"check"}]
[null,null,null,null,{"$f":" Calcs!E$198","v":"Check summary DMMY"},{"$f":" Calcs!F$198","v":0},{"$f":" Calcs!G$198","v":"check"}]
[]
[null,null,null,null,"[do not delete this row]","[range ends]"]
[]
[]
["END"]

{"sheet":"Track","index":8,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Track"},null,null,null,null,null,null,null,null,null,null,null,"do not del col",null,"do not del col"]
[null,null,null,null,null,{"$f":" Checks!$F$9","v":0},"Error chks",null,null,{"$f":" SUM(J7:J31)","v":0}]
[null,null,null,null,"Store Track Results"]
[]
[null,null,null,null,null,null,"Unit",null,null,{"$f":" MATCH($H$6, M6:O6, 0)","v":2},"Difference","Diff Pct"]
[null,null,null,null,"Comparison column label",null,null,"test",null,null,null,null,null,"test"]
[null,null,null,null,"[do not delete row]"]
[]
[null,null,null,null,{"$f":" Calcs!E$89","v":"Revenue adjustment for WR - real"},{"$f":" Calcs!F$89","v":0},{"$f":" Calcs!G$89","v":"£m"},{"$f":" Calcs!H$89","v":0},null,{"$f":" IF(ABS(K9) > TRK_TOL, 1, 0)","v":0},{"$f":" H9 - INDEX(M9:O9, $J$5)","v":0},{"$f":" IF(ABS(K9) > TRK_TOL, IF(INDEX(M9:O9, $J$5) = 0, 0, H9 / INDEX(M9:O9, $J$5) - 1), 0)","v":0}]
[null,null,null,null,{"$f":" Calcs!E$98","v":"Revenue adjustment for WN - real"},{"$f":" Calcs!F$98","v":0},{"$f":" Calcs!G$98","v":"£m"},{"$f":" Calcs!H$98","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$107","v":"Revenue adjustment for WWN - real"},{"$f":" Calcs!F$107","v":0},{"$f":" Calcs!G$107","v":"£m"},{"$f":" Calcs!H$107","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$116","v":"Revenue adjustment for BR - real"},{"$f":" Calcs!F$116","v":0},{"$f":" Calcs!G$116","v":"£m"},{"$f":" Calcs!H$116","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$125","v":"Revenue adjustment for DMMY - real"},{"$f":" Calcs!F$125","v":0},{"$f":" Calcs!G$125","v":"£m"},{"$f":" Calcs!H$125","v":0},null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$20","v":"Difference in tax revenue WR - real"},{"$f":" Calcs!F$20","v":0},{"$f":" Calcs!G$20","v":"£m"},{"$f":" Calcs!H$20","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$21","v":"Difference in tax revenue WN - real"},{"$f":" Calcs!F$21","v":0},{"$f":" Calcs!G$21","v":"£m"},{"$f":" Calcs!H$21","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$22","v":"Difference in tax revenue WWN - real"},{"$f":" Calcs!F$22","v":0},{"$f":" Calcs!G$22","v":"£m"},{"$f":" Calcs!H$22","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$23","v":"Difference in tax revenue BR - real"},{"$f":" Calcs!F$23","v":0},{"$f":" Calcs!G$23","v":"£m"},{"$f":" Calcs!H$23","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$24","v":"Difference in tax revenue DMMY - real"},{"$f":" Calcs!F$24","v":0},{"$f":" Calcs!G$24","v":"£m"},{"$f":" Calcs!H$24","v":0},null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$143","v":"Difference in allowed revenue WR - real"},{"$f":" Calcs!F$143","v":0},{"$f":" Calcs!G$143","v":"£m"},{"$f":" Calcs!H$143","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$144","v":"Difference in allowed revenue WN - real"},{"$f":" Calcs!F$144","v":0},{"$f":" Calcs!G$144","v":"£m"},{"$f":" Calcs!H$144","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$145","v":"Difference in allowed revenue WWN - real"},{"$f":" Calcs!F$145","v":0},{"$f":" Calcs!G$145","v":"£m"},{"$f":" Calcs!H$145","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$146","v":"Difference in allowed revenue BR - real"},{"$f":" Calcs!F$146","v":0},{"$f":" Calcs!G$146","v":"£m"},{"$f":" Calcs!H$146","v":0},null,0,0,0]
[null,null,null,null,{"$f":" Calcs!E$147","v":"Difference in allowed revenue DMMY - real"},{"$f":" Calcs!F$147","v":0},{"$f":" Calcs!G$147","v":"£m"},{"$f":" Calcs!H$147","v":0},null,0,0,0]
["INFO ONLY"]
[]
[null,null,null,null,"Date",null,null,{"$f":" TODAY()","v":"2024-12-17"}]
[null,null,null,null,"Time",null,null,{"$f":" NOW()","v":45643.413115625001}]
[null,null,null,null,"File",null,null,{"$f":" MID(CELL(\"filename\",$A$1), SEARCH(\"[\", CELL(\"filename\",$A$1)) + 1, SEARCH(\"]\", CELL(\"filename\",$A$1)) - SEARCH(\"[\", CELL(\"filename\",$A$1)) - 1)","v":"PR24PD15 Tax reconciliation - Portsmouth Water.xlsm"}]
[null,null,null,null,"[do not delete row]",null,null,null,null,"range end"]
[]
[null,null,null,null,"Comment: Key input and logic changes"]
[null,null,null,null,"Comment: Key result changes"]
[]
[]
["End of sheet"]

{"sheet":"F_Outputs","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19RR001_OUT"]
["Acronym","Reference","Item description","Unit","Model","2024-25"]
[]
[null,"C_PR24PD15_PD12_29WR_PR24","PR19 Tax revenue adjustment in 2017-18 FYA (CPIH deflated) prices (WR)","£m","Price Review 2024",{"$f":"Dashboard!F7","v":0}]
[null,"C_PR24PD15_PD12_29WN_PR24","PR19 Tax revenue adjustment in 2017-18 FYA (CPIH deflated) prices (WN)","£m","Price Review 2024",{"$f":"Dashboard!F8","v":0}]
[null,"C_PR24PD15_PD12_29WWN_PR24","PR19 Tax revenue adjustment in 2017-18 FYA (CPIH deflated) prices (WWN)","£m","Price Review 2024",{"$f":"Dashboard!F9","v":0}]
[null,"C_PR24PD15_PD12_29BIO_PR24","PR19 Tax revenue adjustment in 2017-18 FYA (CPIH deflated) prices (BR)","£m","Price Review 2024",{"$f":"Dashboard!F10","v":0}]
[null,"C_PR24PD15_PD12_29ADDN1_PR24","PR19 Tax revenue adjustment in 2017-18 FYA (CPIH deflated) prices (ADDN1)","£m","Price Review 2024",{"$f":"Dashboard!F11","v":0}]
[null,"PR24QA_PR24PD15_OUT1","Date & Time for Model - PR24PD15","Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]17/12/2024 09:54:53"}]
[null,"PR24QA_PR24PD15_OUT2","Name of Model - PR24PD15","Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"PR24PD15 Tax reconciliation - Portsmouth Water.xlsm"}]
[null,"PR24QA_PR24PD15_OUT3","F_Inputs time stamp - PR24PD15","Text","Price Review 2024","na"]
[null,"PR24QA_PR24PD15_OUT4","Model override switch for - PR24PD15","nr","Price Review 2024",1]