{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","CP & Installation Detail","Pricing & Billing Detail","Single Order Summary","Ethernet Direct Access Costs","Ethernet Connect Access Costs","OWAS","Data Connect Access Costs","Data Direct Access Costs"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":14,"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":"Introduction","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,2,15,3]]}
[]
[]
[null,null,null,"Order Form for the provision of \nLeased Lines and Ethernet Services"]
[]
[]
[]
[null,null,"This is the application form for the provision of new circuits for the below products:"]
[]
[null,null,"1.  Data Direct Access Service"]
[null,null,"2.  Ethernet Direct Access Service"]
[null,null,"3.  Data Connect Access Service"]
[null,null,"4.  Ethernet Connect Access Service"]
[null,null,"5.  Optical Wave Access Service "]
[]
[]
[null,null,"By returning this form to the KCOM Wholesale Team you acknowledge acceptance and agree to be bound by the Reference Offer for Leased Lines and Ethernet Services, available at https://www.kcom.com/wholesale/products/data-connectivity/data-connectivity-document-page/  as may be amended from time to time."]
[null,null,"This tool only provides wholesale charges within the Hull Area."]
[]
[]
[]
[]
[null,null,"v29"]

{"sheet":"CP & Installation Detail","index":1,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[16,6,17,8],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[13,2,13,3],[14,2,14,3],[16,2,16,3],[18,2,18,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[32,2,32,3],[33,2,33,3],[35,2,35,3],[36,2,36,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Product Selected",null,{"$f":"NOW()","v":"2024-04-02T15:17:56.210"}]
[null,null,null,null,"Single Orders",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Direct Access Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Connect Access Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethernet Direct Access Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethernet Connect Access Service"]
[null,null,"Section 1: CP Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optical Wave Access Service"]
[null,null,"Company Name"]
[null,null,"Contact Name"]
[null,null,"Contact Telephone Number"]
[null,null,"Email Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataDirectAccessService",null,"EthernetConnectAccessService","OpticalWaveAccessService"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Service Selected",null,"No Service Selected","No Service Selected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2Mb",null,"10Mb","OWAS 10Gb +filter"]
[null,null,"Section 2: New Product Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34Mb",null,"100Mb","Additional 10Gb Wavelength"]
[null,null,"Product",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45Mb",null,"1Gb Standard Connection","Resilient OWAS 10Gb +filter inc amplification"]
[null,null,"Bandwidth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"155Mb",null,"1Gb Free Connection","Excess Construction Charge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10Gb Standard Connection"]
[null,null,"Initial Term",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10Gb Free Connection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100Gb","Term"]
[null,null,"Required By",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Offer Period",null,"Term","5 Years"]
[null,null,"Please be aware that the standard leadtime for ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-31",null,"1 Year"]
[null,null,"completion is 42 working days from point of order acceptance.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",null,"3 Years  (1 & 10Gb Only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Years",null,"5 Years  (1 & 10Gb Only)"]
[null,null,"Section 3: Installation Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 Years (1 & 10Gb Only)"]
[null,null,"A End",null,null,null,"B End",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connectivity"]
[null,null,"Company Name",null,null,null,"Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New"]
[null,null,"Floor",null,null,null,"Floor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing",null,null,"2023-04-03"]
[null,null,"Location / Room",null,null,null,"Location / Room",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original with Sync-E",null,null,null,null,null,null,"D Shepherd 3/4/23"]
[null,null,"Building Name / Number",null,null,null,"Building Name / Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interface",null,null,"Interface",null,null,null,null,null,null,"If ISDN30 cct ‘s are no longer being sold then these i/f’s could be removed:-"]
[null,null,"Street",null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 BaseTX (RJ45)",null,null,"X21",null,null,null,null,null,null,"X21"]
[null,null,"Town / City",null,null,null,"Town / City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 BaseTX (RJ45)",null,null,"G703 75 Ohms (BNC)",null,null,null,null,null,null,"G703 75 Ohms (BNC)"]
[null,null,"Post Code",null,null,null,"Post Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 BaseLX(SMF) 1000BaseSX(MMF) 1000BaseTX(RJ45)",null,null,"G703 120 Ohms (RJ45)",null,null,null,null,null,null,"G703 120 Ohms (RJ45)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10GBase(SMF) (Dual LC (Fibre)",null,null,"10 BaseT"]
[null,null,"Onsite Contact Name",null,null,null,"Onsite Contact Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1310 Single Mode (1Gb) ",null,null,"100 BaseT"]
[null,null,"Contact Telephone Number",null,null,null,"Contact Telephone Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1310 Single Mode (1Gb)",null,null,"1000 BaseT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1310 Single Mode (10Gb)",null,null,"1310 Single Mode (1Gb) with Sync-E, PTP (IEEE 1588v2) & LLF"]
[null,null,"Connectivity",null,null,null,"Connectivity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1310 Single Mode (10Gb)",null,null,"1310 Single Mode (1Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,"Circuit Interface",null,null,null,"Circuit Interface",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (1Gb)",null,null,"1310 Single Mode (10Gb) with Sync-E, PTP (IEEE 1588v2) & LLF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (1Gb)",null,null,"1310 Single Mode (10Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,"Interconnect Information",null,null,null,null,"Far End - For Kcom Reference Only",null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (10Gb)",null,null,"850 Multi Mode (1Gb) with Sync-E, PTP (IEEE 1588v2) & LLF"]
[null,null,"Interconnect Circuit Bearer Reference",null,null,null,null,"Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (10Gb)",null,null,"850 Multi Mode (1Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,"ADVA ID or SDH Mux ID",null,null,null,null,"Building Name / Number",null,null,null,null,null,null,null,null,null,null,null,null,null,"LR4 (100Gb)",null,null,"850 Multi Mode (10Gb) with Sync-E, PTP (IEEE 1588v2) & LLF"]
[null,null,"Port Speed",null,null,null,null,"Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (10Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,"Duplex Setting",null,null,null,null,"Town / City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LR4 (100Gb)"]
[null,null,null,null,null,null,null,"Post Code",null,null,null,null,null,null,null,null,null,null,null,"Port Speed","10Mb","Duplex Setting","Full"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100Mb",null,"Half"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto",null,"Auto"]

{"sheet":"Pricing & Billing Detail","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,2,32,5],[9,5,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[20,3,20,5],[21,3,21,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Order 1","Connection ","Rental"]
[]
[]
[]
[]
[null,null,"Section 4: Pricing",null,null,null,null,null,null,null,null,"Data Direct Access Service",{"$f":"'Data Direct Access Costs'!C29","v":""},{"$f":"'Data Direct Access Costs'!B31","v":{"$error":"#N/A"}}]
[null,null,"Product","Service","Connection Charge Exc. VAT","Annual Rental\nExc. VAT",null,null,null,null,null,"Data Connect Access Service",{"$f":"'Data Connect Access Costs'!C29","v":{"$error":"#N/A"}},{"$f":"'Data Connect Access Costs'!B31","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF('CP & Installation Detail'!E14=\"No Product Specified\",\"Select Product in CP & Installation Detail\",'CP & Installation Detail'!E14)","v":0},{"$f":"IF('CP & Installation Detail'!E15=\"No Service Selected\",\"Select Service in CP & Installation Detail\",'CP & Installation Detail'!E15)","v":0},{"$f":"IF(OR(C9=\"No Product Selected\",D9=\"Select Service in CP & Installation Detail\"),\"-\",VLOOKUP(C9,L7:N12,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(OR(C9=\"No Product Selected\",D9=\"Select Service in CP & Installation Detail\"),\"-\",IF('CP & Installation Detail'!E17=\"Term\",\"Confirm Initial Term\",VLOOKUP(C9,L3:N12,3,FALSE))),\"-\")","v":"-"},null,null,null,null,null,"Ethernet Direct Access Service",{"$f":"'Ethernet Direct Access Costs'!D31","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!G31","v":{"$error":"#N/A"}}]
[null,null,"Term",{"$f":"'CP & Installation Detail'!E17","v":0},null,null,null,null,null,null,null,"Ethernet Connect Access Service",{"$f":"'Ethernet Connect Access Costs'!D31","v":{"$error":"#N/A"}},{"$f":"'Ethernet Connect Access Costs'!G31","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Optical Wave Access Service",{"$f":"OWAS!H8","v":{"$error":"#VALUE!"}},{"$f":"OWAS!I8","v":"£"}]
[null,null,"Section 5: Billing Details"]
[null,null,"Contact Name",null,null,null,null,null,null,null,null,"Payment"]
[null,null,"Floor",null,null,null,null,null,null,null,null,"Invoice"]
[null,null,"Room",null,null,null,null,null,null,null,null,"Direct Debit"]
[null,null,"Building Name / Number"]
[null,null,"Street"]
[null,null,"Town / City",null,null,null,null,null,null,null,null,"Rental Frequency"]
[null,null,"Post Code",null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
[null,null,"Payment Method",null,null,null,null,null,null,null,null,"Annually"]
[null,null,"Rental Frequency"]
[]
[]
[null,null,"Section 6: Additional Information"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Note: Hold down Alt & Enter Keys to insert new row"]

{"sheet":"Single Order Summary","index":3,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,3,15,4],[13,3,13,4],[14,3,14,4],[17,2,21,5],[34,2,35,5],[31,4,31,5],[32,4,32,5],[28,2,29,5],[10,2,11,5],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
[]
[]
[null,null,null,"Wholesale"]
[]
[null,null,"Single Order Summary"]
[null,null,"Product",{"$f":"IF('CP & Installation Detail'!E14=\"\",\"No Bandwidth Specified\",'CP & Installation Detail'!E14)","v":"No Bandwidth Specified"}]
[null,null,"Bandwidth",{"$f":"IF('CP & Installation Detail'!E15=\"\",\"No Bandwidth Specified\",'CP & Installation Detail'!E15)","v":"No Bandwidth Specified"}]
[null,null,"Connection Charge ExVAT",{"$f":"'Pricing & Billing Detail'!E9","v":{"$error":"#N/A"}}]
[null,null,"Annual Rental (Exc. VAT)",{"$f":"'Pricing & Billing Detail'!F9","v":"-"}]
[null,null,"Required By",{"$f":"IF('CP & Installation Detail'!E19=\"\",\"No Date Specified\",'CP & Installation Detail'!E19)","v":"No Date Specified"}]
[null,null,"Please be aware that the standard leadtime for completion is 42 working days from point of order acceptance."]
[]
[]
[null,null,"A End",{"$f":"IF('CP & Installation Detail'!E31=\"\",\"No Postcode Specified\",'CP & Installation Detail'!E31)","v":"No Postcode Specified"}]
[null,null,"B End",{"$f":"IF('CP & Installation Detail'!I31=\"\",\"No Postcode Specified\",'CP & Installation Detail'!I31)","v":"No Postcode Specified"}]
[null,null,"Far End",{"$f":"IF('CP & Installation Detail'!E44=\"\",\"No Postcode Specified\",'CP & Installation Detail'!E44)","v":"No Postcode Specified"}]
[]
[null,null,"Once you are happy that all details are accurate to your best knowledge, please print, sign, scan and return this page along with your workbook order to the KCOM Wholesale team on the details below. The team can also be contacted if you have any queries in completing the form. The Far End address is for reference only and is not provided as part of the cost above."]
[]
[]
[]
[]
[null,null,"KCOM Wholesale Team:"]
[null,null,"Email: wholesalepartners@kcom.com"]
[null,null,"Tel: 01482 602512"]
[]
[]
[]
[null,null,"This Order is subject to the terms and conditions set out in the Reference Offer for Leased Lines and Ethernet Services."]
[]
[]
[null,"Print Name",null,"Signature"]
[null,"Position"," ","Date"]
[]
[null,null,"KCOM Group PLC. Registered office: 37 Carr Lane Hull HU1 3RE – Registered in England and Wales No. 2150618                                                                 "]

{"sheet":"Ethernet Direct Access Costs","index":4,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":true,"merged":[[23,10,23,12]]}
["Bandwidth","Connection Charge - Standard",null,"Bandwidth","Connection Charge - Special Offer",null,"Selection",{"$f":"CONCATENATE('CP & Installation Detail'!E15,\" \",'CP & Installation Detail'!E17)","v":" "},null,null,"Bandwidth","Term","Rental Charge Per Annum ",null,"To 31/3/24"]
[{"$f":"K2","v":"10Mb 1 Year"},1700,null,"10Mb",0,null,null,null,null,null,{"$f":"CONCATENATE(L25,\" \",$L$32)","v":"10Mb 1 Year"},"1 Year",3987,null,3834]
[{"$f":"K3","v":"100Mb 1 Year"},1700,null,"100Mb",0,null,null,null,null,null,{"$f":"CONCATENATE(L26,\" \",$L$32)","v":"100Mb 1 Year"},"1 Year",3987,null,3834]
["1Gb Standard Connection 1 Year",1700,null,"1Gb",0,null,null,null,null,null,{"$f":"CONCATENATE(L27,\" \",$L$32)","v":"1Gb Standard Connection 1 Year"},"1 Year",3987,null,3834]
["1Gb Standard Connection 3 Years  (1 & 10Gb Only)",1700,null,"1Gb",0,null,null,null,null,null,{"$f":"CONCATENATE($L$27,\" \",L33)","v":"1Gb Standard Connection 3 Years  (1 & 10Gb Only)"},"1 Year",3834,null,3834]
["1Gb Standard Connection 5 Years  (1 & 10Gb Only)",1154,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$27,\" \",L34)","v":"1Gb Standard Connection 5 Years  (1 & 10Gb Only)"},"3 Year",3642,null,3642]
["1Gb Standard Connection 7 Years (1 & 10Gb Only)",1154,null,"1Gb",null,null,null,null,null,null,"1Gb Standard Connection 7 Years (1 & 10Gb Only)","5 Year",3489,null,3489]
["1Gb Free Connection ",1154,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$28,\" \",L36)","v":"1Gb Free Connection "},"7 Year",3259,null,3259]
["1Gb Free Connection 3 Years  (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$28,\" \",L33)","v":"1Gb Free Connection 3 Years  (1 & 10Gb Only)"},"1 Year","Not Available",null,"Not Available"]
["1Gb Free Connection 5 Years  (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$28,\" \",L34)","v":"1Gb Free Connection 5 Years  (1 & 10Gb Only)"},"3 Year",4027,null,4027]
["1Gb Free Connection 7 Years (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,"1Gb Free Connection 7 Years (1 & 10Gb Only)","5 Year",3720,null,3720]
["10Gb Free Connection ",0,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L36)","v":"10Gb Free Connection "},"7 Year",3424,null,3424]
["10Gb Standard Connection 3 Years  (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L33)","v":"10Gb Standard Connection 3 Years  (1 & 10Gb Only)"},"3 Year",6378,null,6378]
["10Gb Standard Connection 5 Years  (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L34)","v":"10Gb Standard Connection 5 Years  (1 & 10Gb Only)"},"5 Year",6114,null,6114]
["10Gb Standard Connection 7 Years (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L35)","v":"10Gb Standard Connection 7 Years (1 & 10Gb Only)"},"7 Year",4830,null,4830]
["10Gb Free Connection",0,null,"10Gb",null,null,null,null,null,null,"10Gb Free Connection","1 Year","Not Available",null,"Not Available"]
["10Gb Free Connection 3 Years  (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L33)","v":"10Gb Free Connection 3 Years  (1 & 10Gb Only)"},"3 Year",7736,null,7736]
["10Gb Free Connection 5 Years  (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L34)","v":"10Gb Free Connection 5 Years  (1 & 10Gb Only)"},"5 Year",6929,null,6929]
["10Gb Free Connection 7 Years (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L35)","v":"10Gb Free Connection 7 Years (1 & 10Gb Only)"},"7 Year",5412,null,5412]
[]
[]
["16/02/23 Connection Charges unified as circuits at New Circuit tariffs for ECAS, EDAS, DCAS and DDAS"]
[]
[null,null,null,null,null,null,null,null,null,null,"Inputs : Do not delete"]
[null,null,null,null,null,null,null,null,null,null,null,"10Mb"]
[null,null,null,null,null,null,null,null,null,null,null,"100Mb"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb Standard Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb Free Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"100Gb"]
["Single Order","End","Status","Connection","Speed","Term","Rental",null,null,null,null,"10Gb Standard Connection"]
[1,"Connection A End",{"$f":"'CP & Installation Detail'!E36","v":0},{"$f":"_xlfn.XLOOKUP(H1,$A$2:$A$20,$B$2:$B$20)","v":{"$error":"#N/A"}},{"$f":"'CP & Installation Detail'!E15","v":0},{"$f":"'CP & Installation Detail'!E17","v":0},{"$f":"_xlfn.XLOOKUP($H$1,$K$2:$K$20,$M$2:$M$20)","v":{"$error":"#N/A"}},null,null,null,null,"10Gb Free Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"3 Years  (1 & 10Gb Only)"]
[null,null,null,null,null,null,null,null,null,null,null,"5 Years  (1 & 10Gb Only)"]
[null,null,null,null,null,null,null,null,null,null,null,"7 Years (1 & 10Gb Only)"]

{"sheet":"Ethernet Connect Access Costs","index":5,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[[23,10,23,12]]}
["Bandwidth","Connection Charge - Standard",null,"Bandwidth","Connection Charge - Special Offer",null,"Selection",{"$f":"CONCATENATE('CP & Installation Detail'!E15,\" \",'CP & Installation Detail'!E17)","v":" "},null,null,"Bandwidth","Term","Rental Charge Per Annum "]
[{"$f":"K2","v":"10Mb 1 Year"},1700,null,"10Mb",0,null,null,null,null,null,{"$f":"CONCATENATE(L25,\" \",$L$32)","v":"10Mb 1 Year"},"1 Year",3987]
[{"$f":"K3","v":"100Mb 1 Year"},1700,null,"100Mb",0,null,null,null,null,null,{"$f":"CONCATENATE(L26,\" \",$L$32)","v":"100Mb 1 Year"},"1 Year",3987]
["1Gb Standard Connection 1 Year",1700,null,"1Gb",0,null,null,null,null,null,{"$f":"CONCATENATE($L$27,\" \",L32)","v":"1Gb Standard Connection 1 Year"},"1 Year",3987]
["1Gb Standard Connection 3 Years  (1 & 10Gb Only)",1154,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$27,\" \",L33)","v":"1Gb Standard Connection 3 Years  (1 & 10Gb Only)"},"3 Year",3642]
["1Gb Standard Connection 5 Years  (1 & 10Gb Only)",1154,null,"1Gb",null,null,null,null,null,null,"1Gb Standard Connection 5 Years  (1 & 10Gb Only)","5 Year",3489]
["1Gb Standard Connection 7 Years (1 & 10Gb Only)",1154,null,"1Gb",null,null,null,null,null,null,"1Gb Standard Connection 7 Years (1 & 10Gb Only)","7 Year",3259]
["1Gb Free Connection 1 Year",0,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$28,\" \",L32)","v":"1Gb Free Connection 1 Year"},"1 Year","Not Available"]
["1Gb Free Connection 3 Years  (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$28,\" \",L33)","v":"1Gb Free Connection 3 Years  (1 & 10Gb Only)"},"3 Year",4027]
["1Gb Free Connection 5 Years  (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,"1Gb Free Connection 5 Years  (1 & 10Gb Only)","5 Year",3720]
["1Gb Free Connection 7 Years (1 & 10Gb Only)",0,null,"1Gb",null,null,null,null,null,null,"1Gb Free Connection 7 Years (1 & 10Gb Only)","7 Year",3424]
["10Gb Standard Connection 1 Year",6000,null,"10Gb",0,null,null,null,null,null,{"$f":"CONCATENATE(L30,\" \",$L$32)","v":"10Gb Standard Connection 1 Year"},"1 Year",6714]
["10Gb Standard Connection 3 Years  (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L33)","v":"10Gb Standard Connection 3 Years  (1 & 10Gb Only)"},"3 Year",6378]
["10Gb Standard Connection 5 Years  (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L34)","v":"10Gb Standard Connection 5 Years  (1 & 10Gb Only)"},"5 Year",6114]
["10Gb Standard Connection 7 Years (1 & 10Gb Only)",4072,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$30,\" \",L35)","v":"10Gb Standard Connection 7 Years (1 & 10Gb Only)"},"7 Year",4830]
["10Gb Free Connection",0,null,"10Gb",null,null,null,null,null,null,"10Gb Free Connection","1 Year","Not Available"]
["10Gb Free Connection 3 Years  (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L33)","v":"10Gb Free Connection 3 Years  (1 & 10Gb Only)"},"3 Year",7736]
["10Gb Free Connection 5 Years  (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L34)","v":"10Gb Free Connection 5 Years  (1 & 10Gb Only)"},"5 Year",6929]
["10Gb Free Connection 7 Years (1 & 10Gb Only)",0,null,"10Gb",null,null,null,null,null,null,{"$f":"CONCATENATE($L$31,\" \",L35)","v":"10Gb Free Connection 7 Years (1 & 10Gb Only)"},"7 Year",5412]
["100Gb 1 Year",15000,null,"100Gb",0,null,null,null,null,null,{"$f":"CONCATENATE(L29,\" \",$L$32)","v":"100Gb 1 Year"},"1 Year",37175]
[]
["16/02/23 Connection Charges unified as circuits at New Circuit tariffs for ECAS, EDAS, DCAS and DDAS"]
[]
[null,null,null,null,null,null,null,null,null,null,"Inputs : Do not delete"]
[null,null,null,null,null,null,null,null,null,null,null,"10Mb"]
[null,null,null,null,null,null,null,null,null,null,null,"100Mb"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb Standard Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb Free Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"100Gb"]
["Single Order","End","Status","Connection","Speed","Term","Rental",null,null,null,null,"10Gb Standard Connection"]
[1,"Connection A End",{"$f":"'CP & Installation Detail'!E36","v":0},{"$f":"_xlfn.XLOOKUP(H1,$A$2:$A$20,$B$2:$B$20)","v":{"$error":"#N/A"}},{"$f":"'CP & Installation Detail'!E15","v":0},{"$f":"'CP & Installation Detail'!E17","v":0},{"$f":"_xlfn.XLOOKUP($H$1,'Ethernet Connect Access Costs'!$K$2:$K$20,'Ethernet Connect Access Costs'!$M$2:$M$20)","v":{"$error":"#N/A"}},null,null,null,null,"10Gb Free Connection"]
[null,null,null,null,null,null,null,null,null,null,null,"1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"3 Years  (1 & 10Gb Only)"]
[null,null,null,null,null,null,null,null,null,null,null,"5 Years  (1 & 10Gb Only)"]
[null,null,null,null,null,null,null,null,null,null,null,"7 Years (1 & 10Gb Only)"]

{"sheet":"OWAS","index":6,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"Service OWAS","Connection Charge - New Fibre (per end)","Price Change","Service OWAS","Connection Charge - Existing Fibre (per end)",null,"Service OWAS","Rental Charge 5yr",null,null,null,"Rental Charge 5yr pre 1/4/24"]
[null,"OWAS 10Gb +filter",{"$f":"15527/2","v":7763.5},"2023-04-01","OWAS 10Gb +filter",{"$f":"15527/2","v":7763.5},null,"OWAS 10Gb +filter",7625,null,null,null,7332]
[null,"Additional 10Gb Wavelength",750,null,"Additional 10Gb Wavelength",750,null,"Additional 10Gb Wavelength",1959,null,null,null,1959]
[null,"Resilient OWAS 10Gb +filter inc amplification","POA",null,"Resilient OWAS 10Gb +filter inc amplification","POA",null,"Resilient OWAS 10Gb +filter inc amplification","POA",null,null,null,"POA"]
[null,"Excess Construction Charge","POA",null,"Excess Construction Charge","POA",null,"Excess Construction Charge","POA",null,null,null,"POA"]
[]
["Single Order",null,null,"CONNECTION A",null,null,"Connection B","Total connection","rental"]
[1,"Connection A End",{"$f":"'CP & Installation Detail'!E36","v":0},{"$f":"IF('CP & Installation Detail'!E36=\"New\",VLOOKUP('CP & Installation Detail'!E15,B2:C5,2,FALSE),IF('CP & Installation Detail'!E36=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,E2:F5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'CP & Installation Detail'!I36","v":0},{"$f":"IF('CP & Installation Detail'!I36=\"New\",VLOOKUP('CP & Installation Detail'!E15,B2:C5,2,FALSE),IF('CP & Installation Detail'!I36=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"SUM(D8+G8)","v":{"$error":"#VALUE!"}},{"$f":"IF('CP & Installation Detail'!E15=\"OWAS 10Gb +filter\",VLOOKUP('CP & Installation Detail'!E15,H2:I5,2,FALSE),IF('CP & Installation Detail'!E15=\"Additional 10Gb Wavelength\",VLOOKUP('CP & Installation Detail'!E15,H2:I5,2,FALSE),\"£\"))","v":"£"}]
["Multiple Orders"]
[1,{"$f":"B8","v":"Connection A End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"E8","v":"Connection B End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(OR(D10=\"POA\",G10=\"POA\"),\"POA\",SUM(D10+G10))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[{"$f":"1+A10","v":2},{"$f":"B10","v":"Connection A End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"E10","v":"Connection B End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(OR(D11=\"POA\",G11=\"POA\"),\"POA\",SUM(D11+G11))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[{"$f":"1+A11","v":3},{"$f":"B10","v":"Connection A End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"E11","v":"Connection B End"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[4,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[5,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[6,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[7,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[8,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[9,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[10,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[11,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(OR(D20=\"POA\",G20=\"POA\"),\"P.O.A\",SUM(D20+G20))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[12,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[13,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[14,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[15,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[16,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[17,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[18,"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[{"$f":"1+A27","v":19},"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]
[{"$f":"1+A28","v":20},"Connection A End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},"Connection B End",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"New\",VLOOKUP(#REF!,$B$2:$C$5,2,FALSE),IF(#REF!=\"Existing\",VLOOKUP(#REF!,$E$2:$F$5,2,FALSE),\"\"))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"OWAS 10Gb +filter\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),IF(#REF!=\"Additional 10Gb Wavelength\",VLOOKUP(#REF!,$H$2:$I$5,2,FALSE),\"POA\"))","v":{"$error":"#REF!"}}]

{"sheet":"Data Connect Access Costs","index":7,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Bandwidth","New Fibre Connection Charge",null,null,null,null,"Bandwidth","Term"," Rental Charge",null,"Values pre 1/5/23","Pre 1/4/24"]
["64Kb",890,null,null,null,null,"2Mb","1 Year",11581,{"$f":"G2&H2","v":"2Mb1 Year"},10032.4,11136]
["128Kb",890,null,null,null,null,"2Mb","3 Years",11581,"2Mb3 Years",10032.4,11136]
["192Kb",890,null,null,null,null,"34Mb","1 Year",17400,"34Mb1 Year",17400,17400]
["256Kb",890,null,null,null,null,"34Mb","3 Years",15660,"34Mb3 Years",15660,15660]
["320Kb",3150,null,null,null,null,"45Mb","1 Year",21750,"45Mb1 Year",21750,21750]
["384Kb",3150,null,null,null,null,"45Mb","3 Years",19752,"45Mb3 Years",19752,19752]
["448Kb",3150,null,null,null,null,"155Mb","1 Year",52221,"155Mb1 Year",52221,52221]
["512Kb",3150,null,null,null,null,"155Mb","3 Years",46992,"155Mb3 Years",46992,46992]
["576Kb",3150]
["640Kb",3150]
["704Kb",3150]
["768Kb",3150]
["832Kb",3150]
["896Kb",3150]
["960Kb",3150]
["1024Kb",3150]
["2Mb",3150]
["34Mb",8090]
["45Mb",8090]
["155Mb",16160]
[]
["16/02/23 Connection Charges unified as circuits at New Circuit tariffs for ECAS, EDAS, DCAS and DDAS"]
[]
["Bandwidth",{"$f":"'CP & Installation Detail'!E15","v":0}]
["Term",{"$f":"'CP & Installation Detail'!E17","v":0}]
[]
[]
["Connection","New",{"$f":"VLOOKUP('CP & Installation Detail'!E15,A2:B21,2,FALSE)","v":{"$error":"#N/A"}}]
[]
["Rental",{"$f":"INDEX(I:I,MATCH(B25&B26,J:J,0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('CP & Installation Detail'!E15,G2:I33,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"MATCH(B25&B26,J:J,0)","v":{"$error":"#N/A"}}]

{"sheet":"Data Direct Access Costs","index":8,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Bandwidth","New Fibre Connection Charge",null,"Bandwidth","Existing Fibre Connection Charge"]
["2Mb",3150,null,"2Mb",3150]
["34Mb",8090,null,"34Mb",8090]
["45Mb",8090,null,"45Mb",8090]
["155Mb",16160,null,"155Mb",16160]
[]
[]
[]
[]
[]
["Bandwidth","Rental Same/Adjacent Exchange","Term (yrs)",null,"Annual Rental  Non Adjacent Exchange",null,"Values pre 1.5.23",null,"Pre 1/4/24"]
["2Mb",8249,"1 Year",{"$f":"A12&C12","v":"2Mb1 Year"},10214,null,7143,8844,7932,9821]
["2Mb",8249,"3 Years",{"$f":"A13&C13","v":"2Mb3 Years"},10214,null,7143,8844,7932,9821]
["2Mb",8249,"5 Years","2Mb5 Years",null,null,7143,null,7932]
["34Mb",34422,"1 Year","34Mb1 Year",null,null,34422,null,34422]
["34Mb",30981,"3 Years","34Mb3 Years",null,null,30981,null,30981]
["45Mb",43032,"1 Year","45Mb1 Year",null,null,43032,null,43032]
["45Mb",38730,"3 Years","45Mb3 Years",null,null,38730,null,38730]
["155Mb",102320,"1 Years","155Mb1 Years",null,null,102320,null,102320]
["155Mb",90300,"3 Years","155Mb3 Years",null,null,90300,null,90300]
[]
[]
[]
[]
["Term",{"$f":"'CP & Installation Detail'!E17","v":0},null,{"$f":"B26&B25","v":"00"}]
["Bandwidth",{"$f":"'CP & Installation Detail'!E15","v":0}]
[]
[]
["Connection A End",{"$f":"'CP & Installation Detail'!E36","v":0},{"$f":"IF('CP & Installation Detail'!E36=\"New\",VLOOKUP('CP & Installation Detail'!E15,A2:B5,2,FALSE),IF('CP & Installation Detail'!E36=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,D2:E5,2,FALSE),\"\"))","v":""}]
["Connection B End",{"$f":"'CP & Installation Detail'!I36","v":0},{"$f":"IF('CP & Installation Detail'!I36=\"New\",VLOOKUP('CP & Installation Detail'!E15,A2:B5,2,FALSE),IF('CP & Installation Detail'!I36=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,D2:E5,2,FALSE),\"\"))","v":""}]
["Rental",{"$f":"_xlfn.XLOOKUP(D25,'Data Direct Access Costs'!D12:D20,'Data Direct Access Costs'!B12:B20)","v":{"$error":"#N/A"}}]