{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Abstraction Charge Calculator","Supported Sources","SUC & EIUC"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Abstraction Charge Calculator","index":0,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[12,1,12,2],[44,1,45,1],[17,1,17,3],[19,1,19,6],[21,1,21,6],[28,1,28,2],[18,1,18,6]]}
["This publication was withdrawn on 1 April 2022. "]
["It has been replaced by the Water resources annual charge indicator tool."]
[null,"Version 5.0 (30/03/2020)"]
[null,"Full water abstraction licence - 2020/21 annual charge calculator"]
[]
[null,"This calculator is to be used as a guide only. If you need a definitive figure or have a question, please contact us on 03708 506506."]
[null,"What won't this calculator work for? ","Megalitres"]
[null,"Public water supply abstractions by statutory water companies, abstractions from canals managed by Canal & River Trust, aggregated licences, and licences where more than one answer applies to the Where, When and What questions."]
[null,"What don't we charge annually for?"]
[null,"Impoundment, temporary or transfer licences, abstractions producing less than 5 megawatts of power, or from inland waters with a chloride content higher than 8,000 milligrams per litre"]
[]
[]
[]
[null,null,null,"Insert below"]
[null,"How much water are you authorised to take?"]
[null,"Enter the annual licensed volume rather than actual volume abstracted each year. "]
[null,"Where do you take it from?","Unsupported"]
[null,"Unsupported - all sources, including groundwater, which are not included in any of the other categories. "]
[null,"Supported by Kielder Transfer Scheme – those sources or parts of sources specified in Schedule 1 of the abstraction charges scheme that are supported by the Kielder Transfer Scheme\nAll other supported - all other sources or parts of sources specified in Schedule 1 of the abstraction charges scheme"]
[null,"Tidal - Those parts of inland waters downstream of the normal tidal limit as marked on the 1:25,000 Ordnance Survey map."]
[null,"When do you take it?","All year"]
[]
[null,"What do you use it for?","Medium"]
[null,"We may apply a higher loss factor if we consider an abstraction to be so. "]
[null,"Do you have a two part tariff agreement? (only applies to spray irrigation)","No"]
[null,"(D) EIUC adjusted source factor","Supported/Unsupported"]
[]
[null,"Which abstraction charge region do you take it from?","Anglian"]
[]
[null,"(EIUC) Non Water Companies Environmental Improvement Unit Charge (£/’000m3)","Midlands"]
[null,"The Standard Unit Charge and Environmental Improvement Unit Charge for each regional charge area are specified in schedules 3 and 4 of the charges scheme"]
[null,"Total annual charge  ",{"$f":"IF(C111>25,C111,IF(C111<25,25))","v":25}]
[null,null," *Minimum charge of £25 applies to all licences "]
[null,"Total annual charge  ",{"$f":"IF(C25=\"Yes\",C58,IF(C25=\"No\",C32))","v":25}]
[null,"Two part tariff - 1st Part charge",{"$f":"IF(C25=\"Yes\",C58,IF(C25=\"No\",A60))","v":"Non Applicable"},{"$f":"IF(C25=\"Yes\",SUM(C72+C75),IF(C25=\"No\",A60))","v":"Non Applicable"}]
[]
[null,"Two part tariff - Total annual charge if full licensed amount taken (or returns not submitted on time)",{"$f":"IF(D37>25,D37,IF(D37<25,25))","v":"Non Applicable"},{"$f":"IF(C25=\"Yes\",C72+C73,IF(C25=\"No\",A60))","v":"Non Applicable"}]
[]
[null,"How much water did you actually take? (megalitres) ",0]
[null,"Actual abstraction should be less or equal to the authorised quantity. If left blank, the supplementary charge will be calculated on the basis of no water being abstracted. "]
[null,"Two part tariff - 2nd Part charge",{"$f":"IF(C25=\"Yes\",C75,IF(C25=\"No\",A60))","v":"Non Applicable"}]
[]
[null,"Two part tariff - Total annual charge adjusted for actual amount taken (if entered)",{"$f":"IF(D43>25,D43,IF(D43<25,25))","v":"Non Applicable"},{"$f":"IF(C25=\"Yes\",SUM(C72+C75),IF(C25=\"No\",A60))","v":"Non Applicable"}]
[null,{"$f":"IF(C25=\"Yes\",1,IF(C25=\"No\",0))","v":0}," *Minimum charge of £25 applies to all licences "]
[]
[]
[]
[null,"How much water did you actually take? (megalitres)"]
[null,"Two part tariff - 2nd part charge"]
[]
[null,"Two part tariff - Total annual charge "]
[null," *Minimum charge of £25 applies to all licences "]
[]
[null,"Unsupported"]
[null,"Supported by Kielder Transfer Scheme",{"$f":"SUM(C68*C64*C65*C66*C69*0.5)","v":0}]
[null,"All Other Supported",{"$f":"SUM(C68*C109*C65*C112)","v":0}]
[null,"Tidal"]
[null,"All year ",{"$f":"SUM(C55:C56)","v":0}]
[null,"Summer "]
["Non Applicable","Winter ","Gallons"]
["See below","High","Megalitres"]
[null,"Medium","Cubic metres"]
[null,"Low",{"$f":"SUM(G15*0.000004546)","v":0}]
[null,"Very low",{"$f":"IF(C17=\"All Other Supported\", 3, IF(C17=\"Unsupported\",1,IF(C17=\"Tidal\",0.2,IF(C17=\"Supported by Kielder Transfer Scheme\",9))))","v":1}]
[null,"None",{"$f":"IF(C21=\"Summer - 1 April to 31 Oct inc.\",1.6, IF(C21=\"Winter - 1 Nov to 31 March inc.\",0.16,IF(C21=\"All year\",1,IF(C21=\"Summer - Anti frost spraying\",1,IF(C21=\"All year - Spray irrigation (incl. trickle irrigation)\",1.6)))))","v":1}]
[null,"Supported/Unsupported",{"$f":"SUM(G86)","v":0.6}]
[null,"Tidal",{"$f":"IF(C28=\"Anglian\",27.51,IF(C28=\"Midlands\",14.95,IF(C28=\"Northumbria\",16.66,IF(C28=\"Yorkshire\",11.63,IF(C28=\"North West\",12.57,IF(C28=\"Southern\",19.23,IF(C28=\"South West inc. Wessex\",19.71,IF(C28=\"Thames\",13.84))))))))","v":27.51}]
[null,"Anglian",{"$f":"IF(C7=\"Megalitres\",D15,IF(C7=\"Gallons\",D15*0.000004546,IF(C7=\"Cubic metres\",D15/1000)))","v":0}]
[null,"Midlands",{"$f":"IF(C28=\"Dee\", 15.54+C67,IF(C28=\"Wye\", 15.54+C67,C67))","v":27.51}]
[null,"Northumbria",{"$f":"SUM(C39*C64*C65*C66*C69*0.5)","v":0}]
[null,"Yorkshire",{"$f":"IF(C25=\"Yes\",C37,IF(C25=\"No\",C34))","v":25}]
[null,"North West",{"$f":"IF(C25=\"Yes\",C58,IF(C25=\"No\",A60))","v":"Non Applicable"}]
[null,"Southern",{"$f":"SUM(C68*C64*C65*C66*C69*0.5)","v":0}]
[null,"South West inc. Wessex",0]
[null,"Thames",{"$f":"IF(C25=\"No\",A60,IF(C25=\"Yes\",C70))","v":"Non Applicable"}]
[null,"Dee"]
[null,"Wye",{"$f":"IF(C25=\"Yes\",SUM(C72+C75),IF(C25=\"No\",A60))","v":"Non Applicable"}]
[null,"Yes"]
[null,"No"]
[]
[null,"Anti-frost spraying",3.0000000000000001E-3,null,null,null,{"$f":"IF(B81=\"Dust suppression\",1,IF(B81=\"Spray irrigation (incl. trickle irrigation)\",1,IF(B81=\"Evaporative cooling\",1,IF(B81=\"Make-up or top-up water\",1))))","v":false}]
[null,"Anti-frost spraying",0.6,null,null,null,{"$f":"IF(B81=\"Industrial or commercial\",0.6,IF(B81=\"Water supply\",0.6,IF(B81=\"Water bottling\",0.6,IF(B81=\"General Farming & Domestic\",0.6,IF(B81=\"Boiler feed\",0.6,IF(B81=\"Conveying\",0.6,IF(B81=\"Anti-frost spraying\",0.6)))))))","v":0.6}]
[null,"Boiler feed",0.6,null,null,null,{"$f":"IF(B81=\"Vegetable or Mineral washing\",0.03,IF(B81=\"Non Evaporative cooling\",0.03))","v":false}]
[null,"Conveying",0.6,null,null,null,{"$f":"IF(B81=\"Lake or pond throughflow\",0.003,IF(B81=\"Fish farming\",0.003,IF(B81=\"Cress growing\",0.003,IF(B81=\"Transfer\",0.003,IF(B81=\"Flood irrigation (incl. water meadows, warping and pest control)\",0.003,IF(B81=\"Hydro-electric power generation >5Mw\",0.003,IF(B81=\"Heat pump\",0.003)))))))","v":false}]
[null,"Cress growing",3.0000000000000001E-3,null,null,null,{"$f":"IF(B81=\"Power generation (>5Mw)\",0.003,IF(B81=\"Hydraulic rams/testing\",0.003,IF(B81=\"Fish pass/canoe pass\",0.003,IF(B81=\"Effluent/slurry dilution\",0.003,IF(B81=\"Wet fencing or nature conservation\",0.003,IF(B81=\"Dewatering\",0.003))))))","v":false}]
[null,"Dewatering",3.0000000000000001E-3,null,null,null,{"$f":"SUM(G81:G85)","v":0.6}]
[null,"Dust suppression",1]
[null,"Effluent/slurry dilution",3.0000000000000001E-3]
[null,"Evaporative cooling",1]
[null,"Fish farming",3.0000000000000001E-3]
[null,"Fish pass/canoe pass",3.0000000000000001E-3]
[null,"Flood irrigation (incl. water meadows, warping and pest control)",3.0000000000000001E-3]
[null,"General Farming & Domestic",0.6]
[null,"Heat pump",3.0000000000000001E-3]
[null,"Hydraulic rams/testing",3.0000000000000001E-3]
[null,"Hydro-electric power generation >5Mw",3.0000000000000001E-3]
[null,"Industrial or commercial",0.6]
[null,"Lake or pond throughflow",3.0000000000000001E-3]
[null,"Make-up or top-up water",1]
[null,"Non Evaporative cooling",0.03]
[null,"Power generation (>5Mw)",3.0000000000000001E-3]
[null,"Spray irrigation (incl. trickle irrigation)",1]
[null,"Transfer",3.0000000000000001E-3]
[null,"Vegetable or mineral washing",0.03]
[null,"Water bottling",0.6]
[null,"Water supply",0.6]
[null,"Wet fencing or nature conservation",3.0000000000000001E-3]
[]
[null,"All year",{"$f":"IF(C62=\"All Other Supported\", 1, IF(C62=\"Unsupported\",1,IF(C62=\"Tidal\",0.2,IF(C62=\"Supported by Kielder Transfer Scheme\",1))))","v":false}]
[null,"All year - Spray irrigation (incl. trickle irrigation)",{"$f":"IF(C28=\"Anglian\",0,IF(C28=\"Midlands\",0,IF(C28=\"Northumbria\",0,IF(C28=\"Yorkshire\",0,IF(C28=\"North West\",0,IF(C28=\"Southern\",0,IF(C28=\"South West inc. Wessex\",0,IF(C28=\"Thames\",0))))))))","v":0}]
[null,"Summer - 1 April to 31 Oct inc.",{"$f":"SUM(C68*C64*C65*C66*C69)+(C68*C109*C65*C66*C112)","v":0}]
[null,"Summer - Anti frost spraying",{"$f":"IF(C28=\"Dee\",0,IF(C28=\"Wye\",0,C110))","v":0}]
[null,"Winter - 1 Nov to 31 March inc."]

{"sheet":"Supported Sources","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,5,24,7],[25,5,25,7],[26,5,26,7],[4,3,4,4],[23,2,24,2],[23,3,24,3],[23,4,24,4]]}
[null,null,"Schedule 1 - Supported Sources "]
[]
[null,null,"The following are regarded as Supported Sources for the purposes of the Scheme."]
[]
[null,null,null,"National Grid References"]
[]
[null,null,"Source of Supply  ",null,"Upstream limit","Downstream limit(s)"]
[]
[null,null,"Ancholme  ",null,"TF 032 875","SE 975 211"]
[null,null,"Pant and Blackwater  ",null,"TL 644 353","TL 839 084"]
[null,null,"Little Ouse  ",null,"TL 987 807","TL 732 870"]
[null,null,"Thet  ",null,"TM 992 912","TL 869 830"]
[null,null,"Thet tributary  ",null,"TM 049 873","TL 987 872"]
[null,null,"Thet tributary  ",null,"TL 975 880","TL 983 880"]
[null,null,"Thet tributary  ",null,"TL 970 906","TL 983 898"]
[null,null,"Stour (Essex/Suffolk)  ",null,"TL 680 560","TM 101 330"]
[null,null,"Waveney  ",null,"TM 092 698","TM 494 935"]
[null,null,"Witham ",null,"SK 974 712","TF 323 445"]
[null,null,"Tees*  ",null,"NY 814 290","NZ 463 191"]
[null,null,"Tyne* ",null,"NY 632 924","NZ 121 646"]
[null,null,"Tyne-Tees Aqueduct* ",null,"NZ 026 617","NZ 005 215"]
[null,null,"Wear*  ",null,"NZ 012 377","NZ 294 524"]
[null,null,"Gloucester & Sharpness Canal ",null,"SO 827 184 ","SO 667 022"]
[null,null,"Severn  ",null,"SN 954 847","SO 822 182 &\nSO 818 216 "]
[]
[null,null,"Dee  ",null,"SH 929 351","SJ 408 658"]
[null,null,"Wye  ",null,"SN 966 656","SO 516 131"]
[null,null,"Candover Stream  ",null,"SU 567 367","SU 568 319"]
[null,null,"River Itchen  ",null,"SU 572 323","SU 439 153"]
[]
[null,null,"* Sources supported by the Kielder Reservoir Transfer Scheme"]

{"sheet":"SUC & EIUC","index":2,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Regional charging area","2020/2021\nStandard\nUnit Charge\n(£/1000m3)\n"]
[null,null,"Anglian",27.51]
[null,null,"Midlands",14.95]
[null,null,"Northumbria",16.66]
[null,null,"North West",12.57]
[null,null,"Southern",19.23]
[null,null,"South West (incl. Wessex)",19.71]
[null,null,"Thames",13.84]
[null,null,"Yorkshire",11.63]
[null,null,"Dee",15.54]
[null,null,"Wye",15.54]
[]
[]
[]
[null,null,"Regional charging area","2020/2021\nNon Water Undertaker Environmental Improvement Unit Charge (£/1000m3)"]
[null,null,"Anglian",0]
[null,null,"Midlands",0]
[null,null,"Northumbria",0]
[null,null,"North West","3.86*"]
[null,null,"Southern",0]
[null,null,"South West (incl. Wessex)","12.91*"]
[null,null,"Thames","5.69*"]
[null,null,"Yorkshire",0]
[null,null,"Dee",0]
[null,null,"Wye",0]
[]
[null,null,"*The EIUC charges for non-water undertakers in the North West, South West (incl. Wessex) and Thames charging areas will be held in abeyance and not be levied pending further changes to the Abstraction Charges Scheme."]
[]
[null,null,"Note 1: The Environmental Improvement Unit Charge is no longer applied to Water Undertakers as a result of legislative changes in section 58 Water Act 2014 which removes water undertakers’ right to compensation where their licences are varied or revoked by the Environment Agency. The removal of EIUC charges for water undertakers was consulted upon previously and approved by the Secretary of State."]