{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","CP & Installation Detail","Pricing & Billing Detail","Single Order Summary","Multi CP & Installation Detail ","Multi Pricing & Billing Detail","Multi Order Summary","Ethernet Direct Access Costs","Ethernet Connect Access Costs","OWAS","Data Connect Access Costs","Data Direct Access Costs"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":15,"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,"v25"]

{"sheet":"CP & Installation Detail","index":1,"n_rows":43,"n_cols":32,"rows_kept":43,"cut":false,"hidden":false,"merged":[[17,2,17,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[37,2,37,4],[31,2,31,3],[32,2,32,3],[34,2,34,3],[35,2,35,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[15,6,16,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],[15,2,15,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":"2023-08-08T09:42:24.760"}]
[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,"No Product Selected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45Mb",null,"1Gb","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,"10Gb","Excess Construction Charge"]
[null,null,"Initial Term",null,null,null,"Note: Multi-year discounts are only applicable in conjunction with special offers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100Gb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Term","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,"1 Year","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,{"$f":"IF(AND(V1>T19,V1<T20),T21,\"3 Yr Term Not Available\")","v":"3 Yr Term Not Available"}]
[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,"5 Years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Years"]
[null,null,"Section 3: Installation Details",null,"Single Circuit Only - For multiple circuit orders (project) please complete below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connectivity"]
[null,null,"A End",null,null,null,"B End",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New"]
[null,null,"Company Name",null,null,null,"Company Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing"]
[null,null,"Floor",null,null,null,"Floor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-03"]
[null,null,"Room",null,null,null,"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,"New",null,"Connectivity",null,"New",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,"Far End - For Kcom Reference Only",null,null,null,null,null,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,"Company Name",null,null,null,null,null,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,"Building Name / Number",null,null,null,null,null,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,"Street",null,null,null,null,null,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,"Town / City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LR4 (100Gb)"]
[null,null,"Post Code"]

{"sheet":"Pricing & Billing Detail","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,2,29,5],[9,5,11,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":{"$error":"#N/A"}},{"$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":"No Product Selected"},{"$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":"-"},{"$f":"IFERROR(IF(OR(C9=\"No Product Selected\",D9=\"Select Service in CP & Installation Detail\"),\"-\",IF('CP & Installation Detail'!E16=\"Term\",\"Confirm Initial Term\",VLOOKUP(C9,L3:N12,3,FALSE))),\"-\")","v":"-"},null,null,null,null,null,"Ethernet Direct Access Service",{"$f":"IF('CP & Installation Detail'!$E$16='CP & Installation Detail'!$V$18,'Ethernet Direct Access Costs'!E18,IF('CP & Installation Detail'!$E$16='CP & Installation Detail'!$T$21,'Ethernet Direct Access Costs'!I18))","v":false},{"$f":"'Ethernet Direct Access Costs'!K18","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Ethernet Connect Access Service",{"$f":"'Ethernet Connect Access Costs'!D16","v":"3 Year Term Not Available"},{"$f":"'Ethernet Connect Access Costs'!G16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Optical Wave Access Service",{"$f":"OWAS!H8","v":{"$error":"#N/A"}},{"$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,"\n"]
[]
[]
[]
[]
[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":[[10,2,11,5],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[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]]}
[]
[]
[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 Product Selected"}]
[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":"-"}]
[null,null,"Annual Rental (Exc. VAT)",{"$f":"'Pricing & Billing Detail'!F9","v":"-"}]
[null,null,"Required By",{"$f":"IF('CP & Installation Detail'!E18=\"\",\"No Date Specified\",'CP & Installation Detail'!E18)","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'!E30=\"\",\"No Postcode Specified\",'CP & Installation Detail'!E30)","v":"No Postcode Specified"}]
[null,null,"B End",{"$f":"IF('CP & Installation Detail'!I30=\"\",\"No Postcode Specified\",'CP & Installation Detail'!I30)","v":"No Postcode Specified"}]
[null,null,"Far End",{"$f":"IF('CP & Installation Detail'!E43=\"\",\"No Postcode Specified\",'CP & Installation Detail'!E43)","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":"Multi CP & Installation Detail ","index":4,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":true,"merged":[[8,10,9,10],[8,15,9,15],[2,6,2,7],[2,8,2,9],[2,10,2,11],[3,6,3,7],[3,8,3,9],[3,10,3,11],[5,6,5,7],[3,12,3,15],[2,4,2,5],[5,4,5,5],[7,4,7,5],[5,8,5,9],[2,12,2,15]]}
[]
[]
[null,null,null,null,"Section 1 CP Details:-",null,"Company Name",null,"Contact Name",null,"Contact Telephone Number",null,"Email Address",null,null,null,null,null,null,{"$f":"IF(OR($I$6=$T$17),$T$25:$T$27,IF(OR($I$6=$S$17),$S$25:$S$27,IF(OR($I$6=$U$17),$U$24:$U$25)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"BT Business",null,"Jordan Miller",null,null,null,"jordan.miller@bt.com",null,null,null,null,null,null,{"$f":"IF(OR($I$6=$S$17),$S$18:$S$23,IF(OR($I$6=$T$17),$T$18:$T$23,IF(OR($I$6=$U$17),$U$18:$U$22)))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Section 2 New Product Requirements:-",null,"Multiple Circuit Requirements :",null,"Optical Wave Access Service",null,"5 Years"]
[]
[null,null,null,null,"Section 3: Installation Details:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Product Selected"]
[null,null,null,null,"Cct No.","Bandwidth","Post code","A End Address","Circuit Interface","Connectivity","Contact Name & Number","B End Address","Post code","Circuit Interface","Connectivity","Contact Name & Number",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,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optical Wave Access Service"]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,5]
[null,null,null,null,6]
[null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethernet Connect Access Service","Ethernet Direct Access Service","Optical Wave Access Service"]
[null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Service Selected","No Service Selected","No Service Selected"]
[null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,"10Mb","10Mb","OWAS 10Gb +filter"]
[null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,"100Mb","100Mb","Additional 10Gb Wavelength"]
[null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,"1Gb","1Gb","Resilient OWAS 10Gb +filter inc amplification"]
[null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,"10Gb","10Gb","Excess Construction Charge"]
[null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,"100Gb","100Gb"]
[null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,"Term","Term","Term"]
[null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Year","1 Year","5 Years"]
[null,null,null,null,16]
[null,null,null,null,17]
[null,null,null,null,18]
[null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connectivity"]
[null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New"]
[null,null,null,null,null,null,null,"Address information should list Name, Floor, Room, Building Name/Number/ Street/Town/City",null,null,null,"Address information should list Name, Floor, Room, Building Name/Number/ Street/Town/City",null,null,null,null,null,null,null,"Existing"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interface"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G703 75 Ohms (BNC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,"10 BaseT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 BaseT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 BaseT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1310 Single Mode (1Gb) 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,"1310 Single Mode (1Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1310 Single Mode (10Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"850 Multi Mode (1Gb) 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,"850 Multi Mode (1Gb) with Sync-E, PTP (IEEE 1588v2), No LLF"]
[null,null,null,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) & LLF"]
[null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LR4 (100Gb)"]

{"sheet":"Multi Pricing & Billing Detail","index":5,"n_rows":47,"n_cols":51,"rows_kept":47,"cut":false,"hidden":true,"merged":[[41,2,45,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"edas","edas","ecas","ecas","owas","owas"]
[null,null,null,null,null,null,null,null,null,null,null,"SINGLE Order ","Connection ","Rental","Connection ","Rental","Connection ","Rental"]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Ethernet Direct Access Costs'!E18+'Ethernet Direct Access Costs'!I18","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K18","v":{"$error":"#N/A"}},{"$f":"'Ethernet Connect Access Costs'!D16","v":"3 Year Term Not Available"},{"$f":"'Ethernet Connect Access Costs'!G16","v":0},{"$f":"OWAS!H8","v":{"$error":"#N/A"}},{"$f":"OWAS!I8","v":"£"}]
[null,null,null,null,null,null,null,null,null,null,null,"Connection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental"]
[null,null,"Section 4: Pricing",null,null,null,null,null,null,null,"Multi-Order",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"Product","Service","Connection Charge Exc. VAT","Annual Rental\nExc. VAT"]
[null,{"$f":"'Multi CP & Installation Detail '!E11","v":1},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F11)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F11=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F11)),\"\",'Multi CP & Installation Detail '!F11)","v":""},{"$f":"IFERROR(IF(OR(D7=\"\",D7=\"-\"),\"£\",VLOOKUP(C7,$K$5:$AE$9,2,FALSE)),\"-\")","v":"£"},{"$f":"IFERROR(IF(OR(D7=\"\",D7=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K6=\"Term\",\"Confirm Initial Term\",VLOOKUP(C7,$K$7:$AY$9,22,FALSE))),\"-\")","v":"-"},null,null,null,null,"Ethernet Direct Access Service",{"$f":"'Ethernet Direct Access Costs'!E20","v":""},{"$f":"'Ethernet Direct Access Costs'!E21+'Ethernet Direct Access Costs'!I21","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E22+'Ethernet Direct Access Costs'!I22","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E23+'Ethernet Direct Access Costs'!I23","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E24+'Ethernet Direct Access Costs'!I24","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E25+'Ethernet Direct Access Costs'!I25","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E26+'Ethernet Direct Access Costs'!I26","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E27+'Ethernet Direct Access Costs'!I27","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E28+'Ethernet Direct Access Costs'!I28","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E29+'Ethernet Direct Access Costs'!I29","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E30+'Ethernet Direct Access Costs'!I30","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E31+'Ethernet Direct Access Costs'!I31","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E32+'Ethernet Direct Access Costs'!I32","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E33+'Ethernet Direct Access Costs'!I33","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E34+'Ethernet Direct Access Costs'!I34","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E35+'Ethernet Direct Access Costs'!I35","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E36+'Ethernet Direct Access Costs'!I36","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E37+'Ethernet Direct Access Costs'!I37","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E38+'Ethernet Direct Access Costs'!I38","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!E39+'Ethernet Direct Access Costs'!I39","v":{"$error":"#VALUE!"}},{"$f":"'Ethernet Direct Access Costs'!K20","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K21","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K22","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K23","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K24","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K25","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K26","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K27","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K28","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K29","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K30","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K31","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K32","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K33","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K34","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K35","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K36","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K37","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K38","v":{"$error":"#N/A"}},{"$f":"'Ethernet Direct Access Costs'!K39","v":{"$error":"#N/A"}}]
[null,{"$f":"'Multi CP & Installation Detail '!E12","v":2},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F12)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F12=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F12)),\"\",'Multi CP & Installation Detail '!F12)","v":""},{"$f":"IFERROR(IF(OR(D8=\"\",D8=\"-\"),\"£         -\",VLOOKUP(C8,$K$5:$AE$9,3,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D8=\"\",D8=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K7=\"Term\",\"Confirm Initial Term\",VLOOKUP(C8,$K$7:$AY$9,23,FALSE))),\"-\")","v":"-"},null,null,null,null,"Ethernet Connect Access Service",{"$f":"'Ethernet Connect Access Costs'!D18","v":""},{"$f":"'Ethernet Connect Access Costs'!D19","v":""},{"$f":"'Ethernet Connect Access Costs'!D20","v":""},{"$f":"'Ethernet Connect Access Costs'!D21","v":""},{"$f":"'Ethernet Connect Access Costs'!D22","v":""},{"$f":"'Ethernet Connect Access Costs'!D23","v":""},{"$f":"'Ethernet Connect Access Costs'!D24","v":""},{"$f":"'Ethernet Connect Access Costs'!D25","v":""},{"$f":"'Ethernet Connect Access Costs'!D26","v":""},{"$f":"'Ethernet Connect Access Costs'!D27","v":""},{"$f":"'Ethernet Connect Access Costs'!D28","v":""},{"$f":"'Ethernet Connect Access Costs'!D29","v":""},{"$f":"'Ethernet Connect Access Costs'!D30","v":""},{"$f":"'Ethernet Connect Access Costs'!D31","v":""},{"$f":"'Ethernet Connect Access Costs'!D32","v":""},{"$f":"'Ethernet Connect Access Costs'!D33","v":""},{"$f":"'Ethernet Connect Access Costs'!D34","v":""},{"$f":"'Ethernet Connect Access Costs'!D35","v":""},{"$f":"'Ethernet Connect Access Costs'!D36","v":""},{"$f":"'Ethernet Connect Access Costs'!D37","v":""},{"$f":"'Ethernet Connect Access Costs'!G18","v":false},{"$f":"'Ethernet Connect Access Costs'!G19","v":false},{"$f":"'Ethernet Connect Access Costs'!G20","v":false},{"$f":"'Ethernet Connect Access Costs'!G21","v":false},{"$f":"'Ethernet Connect Access Costs'!G22","v":false},{"$f":"'Ethernet Connect Access Costs'!G23","v":false},{"$f":"'Ethernet Connect Access Costs'!G24","v":false},{"$f":"'Ethernet Connect Access Costs'!G25","v":false},{"$f":"'Ethernet Connect Access Costs'!G26","v":false},{"$f":"'Ethernet Connect Access Costs'!G27","v":false},{"$f":"'Ethernet Connect Access Costs'!G28","v":false},{"$f":"'Ethernet Connect Access Costs'!G29","v":false},{"$f":"'Ethernet Connect Access Costs'!G30","v":false},{"$f":"'Ethernet Connect Access Costs'!G31","v":false},{"$f":"'Ethernet Connect Access Costs'!G32","v":false},{"$f":"'Ethernet Connect Access Costs'!G33","v":false},{"$f":"'Ethernet Connect Access Costs'!G34","v":false},{"$f":"'Ethernet Connect Access Costs'!G35","v":false},{"$f":"'Ethernet Connect Access Costs'!G36","v":false},{"$f":"'Ethernet Connect Access Costs'!G37","v":false}]
[null,{"$f":"'Multi CP & Installation Detail '!E13","v":3},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F13)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F13=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F13)),\"\",'Multi CP & Installation Detail '!F13)","v":""},{"$f":"IFERROR(IF(OR(D9=\"\",D9=\"-\"),\"£         -\",VLOOKUP(C9,$K$5:$AE$9,4,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D9=\"\",D9=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K8=\"Term\",\"Confirm Initial Term\",VLOOKUP(C9,$K$7:$AY$9,24,FALSE))),\"-\")","v":"-"},null,null,null,null,"Optical Wave Access Service",{"$f":"OWAS!H10","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H11","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H12","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H13","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H14","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H15","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H16","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H17","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H18","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H19","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H20","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H21","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H22","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H23","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H24","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H25","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H26","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H27","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H28","v":{"$error":"#VALUE!"}},{"$f":"OWAS!H29","v":{"$error":"#VALUE!"}},{"$f":"OWAS!I10","v":"POA"},{"$f":"OWAS!I11","v":"POA"},{"$f":"OWAS!I12","v":"POA"},{"$f":"OWAS!I13","v":"POA"},{"$f":"OWAS!I14","v":"POA"},{"$f":"OWAS!I15","v":"POA"},{"$f":"OWAS!I16","v":"POA"},{"$f":"OWAS!I17","v":"POA"},{"$f":"OWAS!I18","v":"POA"},{"$f":"OWAS!I19","v":"POA"},{"$f":"OWAS!I20","v":"POA"},{"$f":"OWAS!I21","v":"POA"},{"$f":"OWAS!I22","v":"POA"},{"$f":"OWAS!I23","v":"POA"},{"$f":"OWAS!I24","v":"POA"},{"$f":"OWAS!I25","v":"POA"},{"$f":"OWAS!I26","v":"POA"},{"$f":"OWAS!I27","v":"POA"},{"$f":"OWAS!I28","v":"POA"},{"$f":"OWAS!I29","v":"POA"}]
[null,{"$f":"'Multi CP & Installation Detail '!E14","v":4},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F14)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F14=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F14)),\"\",'Multi CP & Installation Detail '!F14)","v":""},{"$f":"IFERROR(IF(OR(D10=\"\",D10=\"-\"),\"£         -\",VLOOKUP(C10,$K$5:$AE$9,5,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D10=\"\",D10=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K9=\"Term\",\"Confirm Initial Term\",VLOOKUP(C10,$K$7:$AY$9,25,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E15","v":5},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F15)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F15=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F15)),\"\",'Multi CP & Installation Detail '!F15)","v":""},{"$f":"IFERROR(IF(OR(D11=\"\",D11=\"-\"),\"£         -\",VLOOKUP(C11,$K$5:$AE$9,6,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D11=\"\",D11=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K10=\"Term\",\"Confirm Initial Term\",VLOOKUP(C11,$K$7:$AY$9,26,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E16","v":6},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F16)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F16=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F16)),\"\",'Multi CP & Installation Detail '!F16)","v":""},{"$f":"IFERROR(IF(OR(D12=\"\",D12=\"-\"),\"£         -\",VLOOKUP(C12,$K$5:$AE$9,7,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D12=\"\",D12=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K11=\"Term\",\"Confirm Initial Term\",VLOOKUP(C12,$K$7:$AY$9,27,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E17","v":7},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F17)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F17=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F17)),\"\",'Multi CP & Installation Detail '!F17)","v":""},{"$f":"IFERROR(IF(OR(D13=\"\",D13=\"-\"),\"£         -\",VLOOKUP(C13,$K$5:$AE$9,8,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D13=\"\",D13=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K12=\"Term\",\"Confirm Initial Term\",VLOOKUP(C13,$K$7:$AY$9,28,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E18","v":8},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F18)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F18=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F18)),\"\",'Multi CP & Installation Detail '!F18)","v":""},{"$f":"IFERROR(IF(OR(D14=\"\",D14=\"-\"),\"£         -\",VLOOKUP(C14,$K$5:$AE$9,9,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D14=\"\",D14=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K13=\"Term\",\"Confirm Initial Term\",VLOOKUP(C14,$K$7:$AY$9,29,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E19","v":9},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F19)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F19=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F19)),\"\",'Multi CP & Installation Detail '!F19)","v":""},{"$f":"IFERROR(IF(OR(D15=\"\",D15=\"-\"),\"£         -\",VLOOKUP(C15,$K$5:$AE$9,10,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D15=\"\",D15=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K14=\"Term\",\"Confirm Initial Term\",VLOOKUP(C15,$K$7:$AY$9,30,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E20","v":10},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F20)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F20=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F20)),\"\",'Multi CP & Installation Detail '!F20)","v":""},{"$f":"IFERROR(IF(OR(D16=\"\",D16=\"-\"),\"£         -\",VLOOKUP(C16,$K$5:$AE$9,11,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D16=\"\",D16=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K15=\"Term\",\"Confirm Initial Term\",VLOOKUP(C16,$K$7:$AY$9,31,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E21","v":11},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F21)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F21=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F21)),\"\",'Multi CP & Installation Detail '!F21)","v":""},{"$f":"IFERROR(IF(OR(D17=\"\",D17=\"-\"),\"£         -\",VLOOKUP(C17,$K$5:$AE$9,12,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D17=\"\",D17=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K16=\"Term\",\"Confirm Initial Term\",VLOOKUP(C17,$K$7:$AY$9,32,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E22","v":12},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F22)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F22=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F22)),\"\",'Multi CP & Installation Detail '!F22)","v":""},{"$f":"IFERROR(IF(OR(D18=\"\",D18=\"-\"),\"£         -\",VLOOKUP(C18,$K$5:$AE$9,13,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D18=\"\",D18=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K17=\"Term\",\"Confirm Initial Term\",VLOOKUP(C18,$K$7:$AY$9,33,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E23","v":13},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F23)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F23=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F23)),\"\",'Multi CP & Installation Detail '!F23)","v":""},{"$f":"IFERROR(IF(OR(D19=\"\",D19=\"-\"),\"£         -\",VLOOKUP(C19,$K$5:$AE$9,14,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D19=\"\",D19=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K18=\"Term\",\"Confirm Initial Term\",VLOOKUP(C19,$K$7:$AY$9,34,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E24","v":14},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F24)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F24=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F24)),\"\",'Multi CP & Installation Detail '!F24)","v":""},{"$f":"IFERROR(IF(OR(D20=\"\",D20=\"-\"),\"£         -\",VLOOKUP(C20,$K$5:$AE$9,15,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D20=\"\",D20=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K19=\"Term\",\"Confirm Initial Term\",VLOOKUP(C20,$K$7:$AY$9,35,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E25","v":15},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F25)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F25=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F25)),\"\",'Multi CP & Installation Detail '!F25)","v":""},{"$f":"IFERROR(IF(OR(D21=\"\",D21=\"-\"),\"£         -\",VLOOKUP(C21,$K$5:$AE$9,16,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D21=\"\",D21=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K20=\"Term\",\"Confirm Initial Term\",VLOOKUP(C21,$K$7:$AY$9,36,FALSE))),\"-\")","v":"-"},null,null,null,null,{"$f":"cou","v":{"$error":"#NAME?"}}]
[null,{"$f":"'Multi CP & Installation Detail '!E26","v":16},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F26)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F26=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F26)),\"\",'Multi CP & Installation Detail '!F26)","v":""},{"$f":"IFERROR(IF(OR(D22=\"\",D22=\"-\"),\"£         -\",VLOOKUP(C22,$K$5:$AE$9,17,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D22=\"\",D22=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K21=\"Term\",\"Confirm Initial Term\",VLOOKUP(C22,$K$7:$AY$9,37,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E27","v":17},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F27)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F27=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F27)),\"\",'Multi CP & Installation Detail '!F27)","v":""},{"$f":"IFERROR(IF(OR(D23=\"\",D23=\"-\"),\"£         -\",VLOOKUP(C23,$K$5:$AE$9,18,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D23=\"\",D23=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K22=\"Term\",\"Confirm Initial Term\",VLOOKUP(C23,$K$7:$AY$9,38,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E28","v":18},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F28)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F28=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F28)),\"\",'Multi CP & Installation Detail '!F28)","v":""},{"$f":"IFERROR(IF(OR(D24=\"\",D24=\"-\"),\"£         -\",VLOOKUP(C24,$K$5:$AE$9,19,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D24=\"\",D24=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K23=\"Term\",\"Confirm Initial Term\",VLOOKUP(C24,$K$7:$AY$9,39,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E29","v":19},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F29)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F29=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F29)),\"\",'Multi CP & Installation Detail '!F29)","v":""},{"$f":"IFERROR(IF(OR(D25=\"\",D25=\"-\"),\"£         -\",VLOOKUP(C25,$K$5:$AE$9,20,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D25=\"\",D25=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K24=\"Term\",\"Confirm Initial Term\",VLOOKUP(C25,$K$7:$AY$9,40,FALSE))),\"-\")","v":"-"}]
[null,{"$f":"'Multi CP & Installation Detail '!E30","v":20},{"$f":"IF(OR('Multi CP & Installation Detail '!$I$6=\"No Product Selected\",ISBLANK('Multi CP & Installation Detail '!F30)),\"\",'Multi CP & Installation Detail '!$I$6)","v":""},{"$f":"IF(OR('Multi CP & Installation Detail '!F30=\"No Service Selected\",ISBLANK('Multi CP & Installation Detail '!F30)),\"\",'Multi CP & Installation Detail '!F30)","v":""},{"$f":"IFERROR(IF(OR(D26=\"\",D26=\"-\"),\"£         -\",VLOOKUP(C26,$K$5:$AE$9,21,FALSE)),\"-\")","v":"£         -"},{"$f":"IFERROR(IF(OR(D26=\"\",D26=\"-\"),\"-\",IF('Multi CP & Installation Detail '!K25=\"Term\",\"Confirm Initial Term\",VLOOKUP(C26,$K$7:$AY$9,41,FALSE))),\"-\")","v":"-"}]
[]
[null,null,"Section 5: Billing Details",null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Contact Name"]
[null,null,"Floor"]
[null,null,"Room"]
[null,null,"Building Name / Number",null,null,null,null,null,null,null,"External Cable Connect","Rental Frequency"]
[null,null,"Street",null,null,null,null,null,null,null,"Payment","Monthly"]
[null,null,"Town / City",null,null,null,null,null,null,null,"Invoice","Quarterly"]
[null,null,"Post Code",null,null,null,null,null,null,null,"Direct Debit","Annually"]
[]
[null,null,"Payment Method"]
[null,null,"Rental Frequency"]
[]
[]
[null,null,"Section 6: Additional Information"]
[]
[]
[]
[]
[]
[null,null,"Note: Hold down Alt & Enter Keys to insert new row"]

{"sheet":"Multi Order Summary","index":6,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[[9,17,22,20],[17,2,17,11],[13,2,16,11],[26,2,26,3],[26,4,26,6],[26,8,26,11],[28,2,28,11],[29,2,29,9],[5,8,5,9],[5,10,5,11],[25,2,25,3],[25,4,25,6],[25,8,25,11],[6,8,6,9],[6,10,6,11],[7,8,7,9],[7,10,7,11],[8,8,8,9],[8,10,8,11],[10,8,10,9],[10,10,10,11],[23,2,23,11]]}
[]
[null,null,null,null,"Wholesale"]
[]
[null,null,"Order Summary"]
[]
[null,null,"Order Type",null,null,null,null,"Quantity","Connection Charges",null,"Annual Charges"]
[null,null,"Ethernet Direct Access Service",null,null,null,null,{"$f":"IF('Multi Pricing & Billing Detail'!C7=\"Ethernet Direct Access Service\",COUNTIF('Multi Pricing & Billing Detail'!F7:F26,\">1\"),\"-\")","v":"-"},{"$f":"IF(H7=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!E7:E26))","v":"-"},null,{"$f":"IF(H7=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!F7:F26))","v":"-"}]
[null,null,"Ethernet Connect Access Service",null,null,null,null,{"$f":"IF('Multi Pricing & Billing Detail'!C7=\"Ethernet Connect Access Service\",COUNTIF('Multi Pricing & Billing Detail'!F7:F26,\">1\"),\"-\")","v":"-"},{"$f":"IF(H8=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!E7:E26))","v":"-"},null,{"$f":"IF(H8=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!F7:F26))","v":"-"}]
[null,null,"Optical Wave Access Service",null,null,null,null,{"$f":"IF('Multi Pricing & Billing Detail'!C7=\"Optical Wave Access Service\",COUNTIF('Multi Pricing & Billing Detail'!F7:F26,\">1\"),\"-\")","v":"-"},{"$f":"IF(H9=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!E7:E26))","v":"-"},null,{"$f":"IF(H9=\"-\",\"-\",SUM('Multi Pricing & Billing Detail'!F7:F26))","v":"-"}]
[]
[null,null,null,null,null,null,"Totals*:",{"$f":"SUM(H7:H9)","v":0},{"$f":"SUM(I7:J9)","v":0},null,{"$f":"SUM(K7:L9)","v":0}]
[null,null,"* Totals exclude any Excess Construction Charges for resilient requirements "]
[]
[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,null,"Print Name",null,null,null,null,"Signature"]
[null,null,"Position",null," ",null,null,"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":7,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,2,41,9]]}
[null,"Bandwidth","Connection Charge - New Fibre","Special Offer","Bandwidth","Connection Charge - Existing Fibre",null,"Bandwidth","Term","Rental Charge Per Annum ",null,null,"Bandwidth","Term","Rental Charge Per Annum ",null,"Rental Charge pre 1/4/23"]
[null,"10Mb",1700,"3 Year","10Mb",0,null,"10Mb","1 Year",3834,null,{"$f":"M2&N2","v":"10Mb1 Year"},"10Mb","1 Year",3834,null,3384]
[null,"100Mb",1700,"3 Year","100Mb",0,null,"100Mb","1 Year",3834,null,"10Mb3 Years","10Mb","3 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,"1Gb",1700,"3 Year","1Gb",0,null,"1Gb","1 Year",3834,null,"100Mb1 Year","100Mb","1 Year",3834,null,3384]
[null,"10Gb",6000,"3 Year","10Gb",0,null,"10Gb","1 Year",6714,null,"100Mb3 Years","100Mb","3 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb1 Year","1Gb","1 Year",3834,null,3534]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb3 Years","1Gb","3 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb5 Years","1Gb","5 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,"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,"10Gb1 Year","10Gb","1 Year",6714,null,6570]
[null,null,null,null,null,null,null,null,null,null,null,"10Gb3 Years","10Gb","3 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"10Gb5 Years","10Gb","5 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"10Mb5 Years","10Mb","5 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[null,null,null,null,null,null,null,null,null,null,null,"100Mb5 Years","100Mb","5 Years","N/A Select 1 Year",null,"N/A Select 1 Year"]
[]
[]
["order","Exchange Distance:",null,null,"Connection",null,null,null,"Connection"]
["single order"]
[1,"Single Connection","New",null,{"$f":"VLOOKUP('CP & Installation Detail'!E15,B2:C5,2,FALSE)","v":{"$error":"#N/A"}},null,"Special Offer",null,{"$f":"IF('CP & Installation Detail'!E16='CP & Installation Detail'!$T$21,VLOOKUP('CP & Installation Detail'!E15,B2:F5,5,FALSE),\"\")","v":""},"Rental",{"$f":"_xlfn.XLOOKUP('CP & Installation Detail'!E15,'Ethernet Direct Access Costs'!H2:H5,'Ethernet Direct Access Costs'!J2:J5)","v":{"$error":"#N/A"}},null,null,{"$f":"D18","v":0},{"$f":"H18","v":0},{"$f":"'CP & Installation Detail'!E16","v":0},{"$f":"'CP & Installation Detail'!E15","v":0}]
["Multi order"]
[1,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J11","v":0},null,{"$f":"IF(C20=\"New\",VLOOKUP('Multi CP & Installation Detail '!F11,B2:C5,2,FALSE),IF(C20=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F11,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O11","v":0},null,{"$f":"IF(G20=\"New\",VLOOKUP('Multi CP & Installation Detail '!F11,B2:C5,2,FALSE),IF(G20=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F11,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D7&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"_xlfn.XLOOKUP(J20,$L$2:$L$13,$O$2:$O$13)","v":{"$error":"#N/A"}},null,null,{"$f":"D20","v":0},{"$f":"H20","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F11","v":0}]
[2,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J12","v":0},null,{"$f":"IF(C21=\"New\",VLOOKUP('Multi CP & Installation Detail '!F12,B2:C5,2,FALSE),IF(C21=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F12,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O12","v":0},null,{"$f":"IF(G21=\"New\",VLOOKUP('Multi CP & Installation Detail '!F12,B2:C5,2,FALSE),IF(G21=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F12,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D8&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F12","v":0}]
[3,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J13","v":0},null,{"$f":"IF(C22=\"New\",VLOOKUP('Multi CP & Installation Detail '!F13,B2:C5,2,FALSE),IF(C22=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F13,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O13","v":0},null,{"$f":"IF(G22=\"New\",VLOOKUP('Multi CP & Installation Detail '!F13,B2:C5,2,FALSE),IF(G22=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F13,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D9&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F13","v":0}]
[4,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J14","v":0},null,{"$f":"IF(C23=\"New\",VLOOKUP('Multi CP & Installation Detail '!F14,B2:C5,2,FALSE),IF(C23=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F14,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O14","v":0},null,{"$f":"IF(G23=\"New\",VLOOKUP('Multi CP & Installation Detail '!F14,B2:C5,2,FALSE),IF(G23=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F14,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D10&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F14","v":0}]
[5,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J15","v":0},null,{"$f":"IF(C24=\"New\",VLOOKUP('Multi CP & Installation Detail '!F15,B2:C5,2,FALSE),IF(C24=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F15,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O15","v":0},null,{"$f":"IF(G24=\"New\",VLOOKUP('Multi CP & Installation Detail '!F15,B2:C5,2,FALSE),IF(G24=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F15,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D11&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F15","v":0}]
[6,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J16","v":0},null,{"$f":"IF(C25=\"New\",VLOOKUP('Multi CP & Installation Detail '!F16,B2:C5,2,FALSE),IF(C25=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F16,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O16","v":0},null,{"$f":"IF(G25=\"New\",VLOOKUP('Multi CP & Installation Detail '!F16,B2:C5,2,FALSE),IF(G25=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F16,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D12&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F16","v":0}]
[7,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J17","v":0},null,{"$f":"IF(C26=\"New\",VLOOKUP('Multi CP & Installation Detail '!F17,B2:C5,2,FALSE),IF(C26=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F17,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O17","v":0},null,{"$f":"IF(G26=\"New\",VLOOKUP('Multi CP & Installation Detail '!F17,B2:C5,2,FALSE),IF(G26=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F17,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D13&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F17","v":0}]
[8,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J18","v":0},null,{"$f":"IF(C27=\"New\",VLOOKUP('Multi CP & Installation Detail '!F18,B2:C5,2,FALSE),IF(C27=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F18,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O18","v":0},null,{"$f":"IF(G27=\"New\",VLOOKUP('Multi CP & Installation Detail '!F18,B2:C5,2,FALSE),IF(G27=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F18,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D14&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F18","v":0}]
[9,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J19","v":0},null,{"$f":"IF(C28=\"New\",VLOOKUP('Multi CP & Installation Detail '!F19,B2:C5,2,FALSE),IF(C28=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F19,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O19","v":0},null,{"$f":"IF(G28=\"New\",VLOOKUP('Multi CP & Installation Detail '!F19,B2:C5,2,FALSE),IF(G28=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F19,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D15&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F19","v":0}]
[10,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J20","v":0},null,{"$f":"IF(C29=\"New\",VLOOKUP('Multi CP & Installation Detail '!F20,B2:C5,2,FALSE),IF(C29=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F20,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O20","v":0},null,{"$f":"IF(G29=\"New\",VLOOKUP('Multi CP & Installation Detail '!F20,B2:C5,2,FALSE),IF(G29=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F20,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D16&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F20","v":0}]
[11,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J21","v":0},null,{"$f":"IF(C30=\"New\",VLOOKUP('Multi CP & Installation Detail '!F21,B2:C5,2,FALSE),IF(C30=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F21,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O21","v":0},null,{"$f":"IF(G30=\"New\",VLOOKUP('Multi CP & Installation Detail '!F21,B2:C5,2,FALSE),IF(G30=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F21,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D17&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F21","v":0}]
[12,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J22","v":0},null,{"$f":"IF(C31=\"New\",VLOOKUP('Multi CP & Installation Detail '!F22,B2:C5,2,FALSE),IF(C31=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F22,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O22","v":0},null,{"$f":"IF(G31=\"New\",VLOOKUP('Multi CP & Installation Detail '!F22,B2:C5,2,FALSE),IF(G31=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F22,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D18&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F22","v":0}]
[13,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J23","v":0},null,{"$f":"IF(C32=\"New\",VLOOKUP('Multi CP & Installation Detail '!F23,B2:C5,2,FALSE),IF(C32=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F23,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O23","v":0},null,{"$f":"IF(G32=\"New\",VLOOKUP('Multi CP & Installation Detail '!F23,B2:C5,2,FALSE),IF(G32=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F23,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D19&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F23","v":0}]
[14,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J24","v":0},null,{"$f":"IF(C33=\"New\",VLOOKUP('Multi CP & Installation Detail '!F24,B2:C5,2,FALSE),IF(C33=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F24,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O24","v":0},null,{"$f":"IF(G33=\"New\",VLOOKUP('Multi CP & Installation Detail '!F24,B2:C5,2,FALSE),IF(G33=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F24,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D20&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F24","v":0}]
[15,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J25","v":0},null,{"$f":"IF(C34=\"New\",VLOOKUP('Multi CP & Installation Detail '!F25,B2:C5,2,FALSE),IF(C34=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F25,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O25","v":0},null,{"$f":"IF(G34=\"New\",VLOOKUP('Multi CP & Installation Detail '!F25,B2:C5,2,FALSE),IF(G34=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F25,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D21&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F25","v":0}]
[16,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J26","v":0},null,{"$f":"IF(C35=\"New\",VLOOKUP('Multi CP & Installation Detail '!F26,B2:C5,2,FALSE),IF(C35=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F26,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O26","v":0},null,{"$f":"IF(G35=\"New\",VLOOKUP('Multi CP & Installation Detail '!F26,B2:C5,2,FALSE),IF(G35=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F26,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D22&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F26","v":0}]
[17,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J27","v":0},null,{"$f":"IF(C36=\"New\",VLOOKUP('Multi CP & Installation Detail '!F27,B2:C5,2,FALSE),IF(C36=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F27,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O27","v":0},null,{"$f":"IF(G36=\"New\",VLOOKUP('Multi CP & Installation Detail '!F27,B2:C5,2,FALSE),IF(G36=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F27,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D23&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F27","v":0}]
[18,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J28","v":0},null,{"$f":"IF(C37=\"New\",VLOOKUP('Multi CP & Installation Detail '!F28,B2:C5,2,FALSE),IF(C37=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F28,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O28","v":0},null,{"$f":"IF(G37=\"New\",VLOOKUP('Multi CP & Installation Detail '!F28,B2:C5,2,FALSE),IF(G37=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F28,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D24&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F28","v":0}]
[19,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J29","v":0},null,{"$f":"IF(C38=\"New\",VLOOKUP('Multi CP & Installation Detail '!F29,B2:C5,2,FALSE),IF(C38=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F29,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O29","v":0},null,{"$f":"IF(G38=\"New\",VLOOKUP('Multi CP & Installation Detail '!F29,B2:C5,2,FALSE),IF(G38=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F29,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D25&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F29","v":0}]
[20,"Connection A End",{"$f":"'Multi CP & Installation Detail '!$J30","v":0},null,{"$f":"IF(C39=\"New\",VLOOKUP('Multi CP & Installation Detail '!F30,B2:C5,2,FALSE),IF(C39=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F30,E2:F5,2,FALSE),\"\"))","v":""},null,{"$f":"'Multi CP & Installation Detail '!$O30","v":0},null,{"$f":"IF(G39=\"New\",VLOOKUP('Multi CP & Installation Detail '!F30,B2:C5,2,FALSE),IF(G39=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F30,E2:F5,2,FALSE),\"\"))","v":""},{"$f":"'Multi Pricing & Billing Detail'!D26&'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$error":"#N/A"},null,null,0,0,{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"'Multi CP & Installation Detail '!F30","v":0}]
[]
[]
[null,"Original code","IF(Q5=\"Same\",INDEX(I2:I9,(MATCH(Q8:Q9,J2:J9,0))),IF(Q9=\"10Mb\",INDEX(B13:N25,(MATCH(Q6,A13:A25,0)),(MATCH(Q7,B12:N12,0))),IF(Q9=\"100Mb\",INDEX(B30:N42,(MATCH(Q6,A30:A42,0)),(MATCH(Q7,B29:N29,0))),IF(Q9=\"1Gb\",INDEX(B47:N59,(MATCH(Q6,A47:A59,0)),(MATCH(Q7,B46:N46,0))),IF(H63=\"10Gb\",INDEX(I2:I9,(MATCH(H63&E63,J2:J9,0))),\"Error\")))))"]

{"sheet":"Ethernet Connect Access Costs","index":8,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Bandwidth","Connection Charge - Standard","Special Offer","Bandwidth","Connection Charge - Special Offer",null,null,"Bandwidth","Term","Rental Charge Per Annum ",null,"Bandwidth","Term","Rental Charge Per Annum - any Exchange",null,null,null,"Prices amended 1/4/23",null,null,"Rental Charge Per Annum -pre 1/4/23"]
["10Mb",1700,"3 Year","10Mb",0,null,null,"10Mb","1 Year",3834,null,"10Mb","1 Year",3834,"10Mb1 Year",null,null,3834,null,null,3384]
["100Mb",1700,"3 Year","100Mb",0,null,null,"100Mb","1 Year",3834,null,"10Mb","3 Years","N/A Select 1 Year Term ","10Mb3 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
["1Gb",1700,"3 Year","1Gb",0,null,null,"1Gb","1 Year",3834,null,"10Mb","5 Years","N/A Select 1 Year Term ","10Mb5 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
["10Gb",6000,"3 Year","10Gb",0,null,null,"10Gb","1 Year",6714,null,"100Mb","1 Year",3834,"100Mb1 Year",null,null,3834,null,null,3384]
[null,null,null,null,null,null,null,null,null,null,null,"100Mb","3 Years","N/A Select 1 Year Term","100Mb3 Years",null,null,"N/A Select 1 Year Term",null,null,"N/A Select 1 Year Term"]
["100Gb",15000,"3 Year","100Gb",0,null,null,"100Gb","1 Year",37175,null,"100Mb","5 Years","N/A Select 1 Year Term ","100Mb5 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb","1 Year",3834,"1Gb1 Year",null,null,3834,null,null,3384]
["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,"1Gb","3 Years","N/A Select 1 Year Term ","1Gb3 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
[null,null,null,null,null,null,null,null,null,null,null,"1Gb","5 Years","N/A Select 1 Year Term ","1Gb5 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
[null,null,null,null,null,null,null,null,null,null,null,"10Gb","1 Year",6714,"10Gb1 Year",null,null,6714,null,null,6570]
[null,null,null,null,null,null,null,null,null,null,null,"10Gb","3 Years","N/A Select 1 Year Term ","10Gb3 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
[null,null,null,null,null,null,null,null,null,null,null,"10Gb","5 Years","N/A Select 1 Year Term ","10Gb5 Years",null,null,"N/A Select 1 Year Term ",null,null,"N/A Select 1 Year Term "]
[null,null,null,null,null,null,null,null,null,null,null,"100Gb","1 Year",37175,"100Gb1 Year",null,null,37175,null,null,34650]
["Single Order","End","Status","Connection","Speed","Term","Rental",null,null,null,null,"100Gb","3 Years","N/A Select ","100Gb3 Years",null,null,"N/A Select ",null,null,"N/A Select "]
[1,"Connection A End",{"$f":"'CP & Installation Detail'!E35","v":"New"},{"$f":"IF('CP & Installation Detail'!$E$16='CP & Installation Detail'!$V$18,_xlfn.XLOOKUP('CP & Installation Detail'!$E$15,'Ethernet Connect Access Costs'!$A$2:$A$7,'Ethernet Connect Access Costs'!$B$2:$B$7),IF('CP & Installation Detail'!$E$16='CP & Installation Detail'!$T$21,_xlfn.XLOOKUP('CP & Installation Detail'!$E$15,'Ethernet Connect Access Costs'!$A$2:$A$7,'Ethernet Connect Access Costs'!$E$2:$E$7),\"3 Year Term Not Available\"))","v":"3 Year Term Not Available"},{"$f":"'CP & Installation Detail'!E15","v":0},{"$f":"'CP & Installation Detail'!E16","v":0},{"$f":"_xlfn.XLOOKUP('CP & Installation Detail'!$E$15,'Ethernet Connect Access Costs'!$H$2:$H$7,'Ethernet Connect Access Costs'!$J$2:$J$7)","v":0},null,null,null,null,"100Gb","5 Years","N/A Select ","100Gb5 Years",null,null,"N/A Select ",null,null,"N/A Select "]
["Multi Order"]
[1,null,{"$f":"'Multi CP & Installation Detail '!J11","v":0},{"$f":"IF(C18=\"New\",VLOOKUP('Multi CP & Installation Detail '!F11,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C18=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F11,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F11","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"IF(E18=\"100Mb\",INDEX($N$2:$N$13,(MATCH(E18&F18,$O$2:$O$13,0))),IF(E18=\"10Mb\",INDEX($N$2:$N$13,(MATCH(E18&F18,$O$2:$O$13,0))),IF(E18=\"1Gb\",INDEX($N$2:$N$13,(MATCH(E18&F18,$O$2:$O$13,0))),IF(E18=\"10Gb\",INDEX($N$2:$N$13,(MATCH(E18&F18,$O$2:$O$13,0))),IF(E18=\"100Gb\",INDEX($N$2:$N$18,(MATCH(E18&F18,$O$2:$O$18,0))))))))","v":false}]
[{"$f":"1+A18","v":2},null,{"$f":"'Multi CP & Installation Detail '!J12","v":0},{"$f":"IF(C19=\"New\",VLOOKUP('Multi CP & Installation Detail '!F12,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C19=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F12,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F12","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},{"$f":"IF(E19=\"100Mb\",INDEX($N$2:$N$13,(MATCH(E19&F19,$O$2:$O$13,0))),IF(E19=\"10Mb\",INDEX($N$2:$N$13,(MATCH(E19&F19,$O$2:$O$13,0))),IF(E19=\"1Gb\",INDEX($N$2:$N$13,(MATCH(E19&F19,$O$2:$O$13,0))),IF(E19=\"10Gb\",INDEX($N$2:$N$13,(MATCH(E19&F19,$O$2:$O$13,0))),IF(E19=\"100Gb\",INDEX($N$2:$N$18,(MATCH(E19&F19,$O$2:$O$18,0))))))))","v":false}]
[{"$f":"1+A19","v":3},null,{"$f":"'Multi CP & Installation Detail '!J13","v":0},{"$f":"IF(C20=\"New\",VLOOKUP('Multi CP & Installation Detail '!F13,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C20=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F13,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F13","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[4,null,{"$f":"'Multi CP & Installation Detail '!J14","v":0},{"$f":"IF(C21=\"New\",VLOOKUP('Multi CP & Installation Detail '!F14,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C21=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F14,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F14","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[5,null,{"$f":"'Multi CP & Installation Detail '!J15","v":0},{"$f":"IF(C22=\"New\",VLOOKUP('Multi CP & Installation Detail '!F15,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C22=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F15,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F15","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[6,null,{"$f":"'Multi CP & Installation Detail '!J16","v":0},{"$f":"IF(C23=\"New\",VLOOKUP('Multi CP & Installation Detail '!F16,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C23=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F16,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F16","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[7,null,{"$f":"'Multi CP & Installation Detail '!J17","v":0},{"$f":"IF(C24=\"New\",VLOOKUP('Multi CP & Installation Detail '!F17,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C24=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F17,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F17","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[8,null,{"$f":"'Multi CP & Installation Detail '!J18","v":0},{"$f":"IF(C25=\"New\",VLOOKUP('Multi CP & Installation Detail '!F18,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C25=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F18,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F18","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[9,null,{"$f":"'Multi CP & Installation Detail '!J19","v":0},{"$f":"IF(C26=\"New\",VLOOKUP('Multi CP & Installation Detail '!F19,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C26=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F19,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F19","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[10,null,{"$f":"'Multi CP & Installation Detail '!J20","v":0},{"$f":"IF(C27=\"New\",VLOOKUP('Multi CP & Installation Detail '!F20,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C27=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F20,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F20","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[11,null,{"$f":"'Multi CP & Installation Detail '!J21","v":0},{"$f":"IF(C28=\"New\",VLOOKUP('Multi CP & Installation Detail '!F21,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C28=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F21,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F21","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[12,null,{"$f":"'Multi CP & Installation Detail '!J22","v":0},{"$f":"IF(C29=\"New\",VLOOKUP('Multi CP & Installation Detail '!F22,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C29=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F22,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F22","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[13,null,{"$f":"'Multi CP & Installation Detail '!J23","v":0},{"$f":"IF(C30=\"New\",VLOOKUP('Multi CP & Installation Detail '!F23,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C30=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F23,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F23","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[14,null,{"$f":"'Multi CP & Installation Detail '!J24","v":0},{"$f":"IF(C31=\"New\",VLOOKUP('Multi CP & Installation Detail '!F24,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C31=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F24,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F24","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[15,null,{"$f":"'Multi CP & Installation Detail '!J25","v":0},{"$f":"IF(C32=\"New\",VLOOKUP('Multi CP & Installation Detail '!F25,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C32=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F25,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F25","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[16,null,{"$f":"'Multi CP & Installation Detail '!J26","v":0},{"$f":"IF(C33=\"New\",VLOOKUP('Multi CP & Installation Detail '!F26,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C33=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F26,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F26","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[17,null,{"$f":"'Multi CP & Installation Detail '!J27","v":0},{"$f":"IF(C34=\"New\",VLOOKUP('Multi CP & Installation Detail '!F27,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C34=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F27,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F27","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[18,null,{"$f":"'Multi CP & Installation Detail '!J28","v":0},{"$f":"IF(C35=\"New\",VLOOKUP('Multi CP & Installation Detail '!F28,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C35=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F28,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F28","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[19,null,{"$f":"'Multi CP & Installation Detail '!J29","v":0},{"$f":"IF(C36=\"New\",VLOOKUP('Multi CP & Installation Detail '!F29,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C36=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F29,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F29","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]
[20,null,{"$f":"'Multi CP & Installation Detail '!J30","v":0},{"$f":"IF(C37=\"New\",VLOOKUP('Multi CP & Installation Detail '!F30,'Ethernet Connect Access Costs'!$A$2:$B$7,2,FALSE),IF(C37=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F30,'Ethernet Connect Access Costs'!$D$2:$E$7,2,FALSE),\"\"))","v":""},{"$f":"'Multi CP & Installation Detail '!F30","v":0},{"$f":"'Multi CP & Installation Detail '!$K$6","v":"5 Years"},false]

{"sheet":"OWAS","index":9,"n_rows":29,"n_cols":9,"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,"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",7332]
[null,"Additional 10Gb Wavelength",750,null,"Additional 10Gb Wavelength",750,null,"Additional 10Gb Wavelength",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,"Excess Construction Charge","POA",null,"Excess Construction Charge","POA",null,"Excess Construction Charge","POA"]
[]
["Single Order",null,null,"CONNECTION A",null,null,"Connection B","Total connection","rental"]
[1,"Connection A End",{"$f":"'CP & Installation Detail'!E35","v":"New"},{"$f":"IF('CP & Installation Detail'!E35=\"New\",VLOOKUP('CP & Installation Detail'!E15,B2:C5,2,FALSE),IF('CP & Installation Detail'!E35=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,E2:F5,2,FALSE),\"\"))","v":{"$error":"#N/A"}},"Connection B End",{"$f":"'CP & Installation Detail'!I35","v":"New"},{"$f":"IF('CP & Installation Detail'!I35=\"New\",VLOOKUP('CP & Installation Detail'!E15,B2:C5,2,FALSE),IF('CP & Installation Detail'!I35=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,E2:F5,2,FALSE),\"\"))","v":{"$error":"#N/A"}},{"$f":"SUM(D8+G8)","v":{"$error":"#N/A"}},{"$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":"'Multi CP & Installation Detail '!J11","v":0},{"$f":"IF('Multi CP & Installation Detail '!J11=\"New\",VLOOKUP('Multi CP & Installation Detail '!F11,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J11=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F11,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"E8","v":"Connection B End"},{"$f":"'Multi CP & Installation Detail '!O11","v":0},{"$f":"IF('Multi CP & Installation Detail '!O11=\"New\",VLOOKUP('Multi CP & Installation Detail '!F11,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O11=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F11,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"IF(OR(D10=\"POA\",G10=\"POA\"),\"POA\",SUM(D10+G10))","v":{"$error":"#VALUE!"}},{"$f":"IF('Multi CP & Installation Detail '!F11=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F11,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F11=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F11,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[{"$f":"1+A10","v":2},{"$f":"B10","v":"Connection A End"},{"$f":"'Multi CP & Installation Detail '!J12","v":0},{"$f":"IF('Multi CP & Installation Detail '!J12=\"New\",VLOOKUP('Multi CP & Installation Detail '!F12,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J12=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F12,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"E10","v":"Connection B End"},{"$f":"'Multi CP & Installation Detail '!O12","v":0},{"$f":"IF('Multi CP & Installation Detail '!O12=\"New\",VLOOKUP('Multi CP & Installation Detail '!F12,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O12=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F12,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"IF(OR(D11=\"POA\",G11=\"POA\"),\"POA\",SUM(D11+G11))","v":{"$error":"#VALUE!"}},{"$f":"IF('Multi CP & Installation Detail '!F12=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F12,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F12=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F12,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[{"$f":"1+A11","v":3},{"$f":"B10","v":"Connection A End"},{"$f":"'Multi CP & Installation Detail '!J13","v":0},{"$f":"IF('Multi CP & Installation Detail '!J13=\"New\",VLOOKUP('Multi CP & Installation Detail '!F13,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J13=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F13,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"E11","v":"Connection B End"},{"$f":"'Multi CP & Installation Detail '!O13","v":0},{"$f":"IF('Multi CP & Installation Detail '!O13=\"New\",VLOOKUP('Multi CP & Installation Detail '!F13,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O13=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F13,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F13=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F13,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F13=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F13,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[4,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J14","v":0},{"$f":"IF('Multi CP & Installation Detail '!J14=\"New\",VLOOKUP('Multi CP & Installation Detail '!F14,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J14=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F14,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O14","v":0},{"$f":"IF('Multi CP & Installation Detail '!O14=\"New\",VLOOKUP('Multi CP & Installation Detail '!F14,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O14=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F14,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F14=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F14,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F14=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F14,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[5,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J15","v":0},{"$f":"IF('Multi CP & Installation Detail '!J15=\"New\",VLOOKUP('Multi CP & Installation Detail '!F15,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J15=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F15,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O15","v":0},{"$f":"IF('Multi CP & Installation Detail '!O15=\"New\",VLOOKUP('Multi CP & Installation Detail '!F15,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O15=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F15,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F15=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F15,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F15=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F15,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[6,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J16","v":0},{"$f":"IF('Multi CP & Installation Detail '!J16=\"New\",VLOOKUP('Multi CP & Installation Detail '!F16,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J16=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F16,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O16","v":0},{"$f":"IF('Multi CP & Installation Detail '!O16=\"New\",VLOOKUP('Multi CP & Installation Detail '!F16,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O16=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F16,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F16=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F16,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F16=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F16,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[7,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J17","v":0},{"$f":"IF('Multi CP & Installation Detail '!J17=\"New\",VLOOKUP('Multi CP & Installation Detail '!F17,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J17=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F17,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O17","v":0},{"$f":"IF('Multi CP & Installation Detail '!O17=\"New\",VLOOKUP('Multi CP & Installation Detail '!F17,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O17=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F17,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F17=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F17,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F17=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F17,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[8,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J18","v":0},{"$f":"IF('Multi CP & Installation Detail '!J18=\"New\",VLOOKUP('Multi CP & Installation Detail '!F18,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J18=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F18,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O18","v":0},{"$f":"IF('Multi CP & Installation Detail '!O18=\"New\",VLOOKUP('Multi CP & Installation Detail '!F18,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O18=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F18,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F18=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F18,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F18=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F18,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[9,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J19","v":0},{"$f":"IF('Multi CP & Installation Detail '!J19=\"New\",VLOOKUP('Multi CP & Installation Detail '!F19,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J19=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F19,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O19","v":0},{"$f":"IF('Multi CP & Installation Detail '!O19=\"New\",VLOOKUP('Multi CP & Installation Detail '!F19,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O19=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F19,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F19=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F19,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F19=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F19,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[10,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J20","v":0},{"$f":"IF('Multi CP & Installation Detail '!J20=\"New\",VLOOKUP('Multi CP & Installation Detail '!F20,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J20=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F20,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O20","v":0},{"$f":"IF('Multi CP & Installation Detail '!O20=\"New\",VLOOKUP('Multi CP & Installation Detail '!F20,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O20=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F20,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F20=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F20,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F20=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F20,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[11,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J21","v":0},{"$f":"IF('Multi CP & Installation Detail '!J21=\"New\",VLOOKUP('Multi CP & Installation Detail '!F21,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J21=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F21,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O21","v":0},{"$f":"IF('Multi CP & Installation Detail '!O21=\"New\",VLOOKUP('Multi CP & Installation Detail '!F21,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O21=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F21,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$f":"IF(OR(D20=\"POA\",G20=\"POA\"),\"P.O.A\",SUM(D20+G20))","v":{"$error":"#VALUE!"}},{"$f":"IF('Multi CP & Installation Detail '!F21=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F21,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F21=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F21,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[12,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J22","v":0},{"$f":"IF('Multi CP & Installation Detail '!J22=\"New\",VLOOKUP('Multi CP & Installation Detail '!F22,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J22=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F22,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O22","v":0},{"$f":"IF('Multi CP & Installation Detail '!O22=\"New\",VLOOKUP('Multi CP & Installation Detail '!F22,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O22=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F22,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F22=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F22,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F22=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F22,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[13,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J23","v":0},{"$f":"IF('Multi CP & Installation Detail '!J23=\"New\",VLOOKUP('Multi CP & Installation Detail '!F23,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J23=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F23,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O23","v":0},{"$f":"IF('Multi CP & Installation Detail '!O23=\"New\",VLOOKUP('Multi CP & Installation Detail '!F23,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O23=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F23,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F23=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F23,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F23=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F23,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[14,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J24","v":0},{"$f":"IF('Multi CP & Installation Detail '!J24=\"New\",VLOOKUP('Multi CP & Installation Detail '!F24,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J24=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F24,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O24","v":0},{"$f":"IF('Multi CP & Installation Detail '!O24=\"New\",VLOOKUP('Multi CP & Installation Detail '!F24,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O24=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F24,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F24=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F24,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F24=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F24,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[15,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J25","v":0},{"$f":"IF('Multi CP & Installation Detail '!J25=\"New\",VLOOKUP('Multi CP & Installation Detail '!F25,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J25=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F25,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O25","v":0},{"$f":"IF('Multi CP & Installation Detail '!O25=\"New\",VLOOKUP('Multi CP & Installation Detail '!F25,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O25=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F25,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F25=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F25,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F25=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F25,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[16,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J26","v":0},{"$f":"IF('Multi CP & Installation Detail '!J26=\"New\",VLOOKUP('Multi CP & Installation Detail '!F26,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J26=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F26,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O26","v":0},{"$f":"IF('Multi CP & Installation Detail '!O26=\"New\",VLOOKUP('Multi CP & Installation Detail '!F26,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O26=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F26,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F26=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F26,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F26=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F26,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[17,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J27","v":0},{"$f":"IF('Multi CP & Installation Detail '!J27=\"New\",VLOOKUP('Multi CP & Installation Detail '!F27,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J27=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F27,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O27","v":0},{"$f":"IF('Multi CP & Installation Detail '!O27=\"New\",VLOOKUP('Multi CP & Installation Detail '!F27,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O27=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F27,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F27=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F27,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F27=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F27,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[18,"Connection A End",{"$f":"'Multi CP & Installation Detail '!J28","v":0},{"$f":"IF('Multi CP & Installation Detail '!J28=\"New\",VLOOKUP('Multi CP & Installation Detail '!F28,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J28=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F28,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O28","v":0},{"$f":"IF('Multi CP & Installation Detail '!O28=\"New\",VLOOKUP('Multi CP & Installation Detail '!F28,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O28=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F28,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F28=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F28,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F28=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F28,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[{"$f":"1+A27","v":19},"Connection A End",{"$f":"'Multi CP & Installation Detail '!J29","v":0},{"$f":"IF('Multi CP & Installation Detail '!J29=\"New\",VLOOKUP('Multi CP & Installation Detail '!F29,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J29=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F29,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O29","v":0},{"$f":"IF('Multi CP & Installation Detail '!O29=\"New\",VLOOKUP('Multi CP & Installation Detail '!F29,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O29=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F29,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F29=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F29,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F29=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F29,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]
[{"$f":"1+A28","v":20},"Connection A End",{"$f":"'Multi CP & Installation Detail '!J30","v":0},{"$f":"IF('Multi CP & Installation Detail '!J30=\"New\",VLOOKUP('Multi CP & Installation Detail '!F30,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!J30=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F30,$E$2:$F$5,2,FALSE),\"\"))","v":""},"Connection B End",{"$f":"'Multi CP & Installation Detail '!O30","v":0},{"$f":"IF('Multi CP & Installation Detail '!O30=\"New\",VLOOKUP('Multi CP & Installation Detail '!F30,$B$2:$C$5,2,FALSE),IF('Multi CP & Installation Detail '!O30=\"Existing\",VLOOKUP('Multi CP & Installation Detail '!F30,$E$2:$F$5,2,FALSE),\"\"))","v":""},{"$error":"#VALUE!"},{"$f":"IF('Multi CP & Installation Detail '!F30=\"OWAS 10Gb +filter\",VLOOKUP('Multi CP & Installation Detail '!F30,$H$2:$I$5,2,FALSE),IF('Multi CP & Installation Detail '!F30=\"Additional 10Gb Wavelength\",VLOOKUP('Multi CP & Installation Detail '!F30,$H$2:$I$5,2,FALSE),\"POA\"))","v":"POA"}]

{"sheet":"Data Connect Access Costs","index":10,"n_rows":33,"n_cols":11,"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"]
["64Kb",890,null,null,null,null,"2Mb","1 Year",11136,{"$f":"G2&H2","v":"2Mb1 Year"},10032.4]
["128Kb",890,null,null,null,null,"2Mb","3 Years",11136,"2Mb3 Years",10032.4]
["192Kb",890,null,null,null,null,"34Mb","1 Year",17400,"34Mb1 Year",17400]
["256Kb",890,null,null,null,null,"34Mb","3 Years",15660,"34Mb3 Years",15660]
["320Kb",3150,null,null,null,null,"45Mb","1 Year",21750,"45Mb1 Year",21750]
["384Kb",3150,null,null,null,null,"45Mb","3 Years",19752,"45Mb3 Years",19752]
["448Kb",3150,null,null,null,null,"155Mb","1 Year",52221,"155Mb1 Year",52221]
["512Kb",3150,null,null,null,null,"155Mb","3 Years",46992,"155Mb3 Years",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'!E16","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":11,"n_rows":31,"n_cols":8,"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"]
["2Mb",7932,"1 Year",{"$f":"A12&C12","v":"2Mb1 Year"},9821,null,7143,8844]
["2Mb",7932,"3 Years",{"$f":"A13&C13","v":"2Mb3 Years"},9821,null,7143,8844]
["2Mb",7932,"5 Years","2Mb5 Years",null,null,7143]
["34Mb",34422,"1 Year","34Mb1 Year",null,null,34422]
["34Mb",30981,"3 Years","34Mb3 Years",null,null,30981]
["45Mb",43032,"1 Year","45Mb1 Year",null,null,43032]
["45Mb",38730,"3 Years","45Mb3 Years",null,null,38730]
["155Mb",102320,"1 Years","155Mb1 Years",null,null,102320]
["155Mb",90300,"3 Years","155Mb3 Years",null,null,90300]
[]
[]
[]
[]
["Term",{"$f":"'CP & Installation Detail'!E16","v":0},null,{"$f":"B26&B25","v":"00"}]
["Bandwidth",{"$f":"'CP & Installation Detail'!E15","v":0}]
[]
[]
["Connection A End",{"$f":"'CP & Installation Detail'!E35","v":"New"},{"$f":"IF('CP & Installation Detail'!E35=\"New\",VLOOKUP('CP & Installation Detail'!E15,A2:B5,2,FALSE),IF('CP & Installation Detail'!E35=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,D2:E5,2,FALSE),\"\"))","v":{"$error":"#N/A"}}]
["Connection B End",{"$f":"'CP & Installation Detail'!I35","v":"New"},{"$f":"IF('CP & Installation Detail'!I35=\"New\",VLOOKUP('CP & Installation Detail'!E15,A2:B5,2,FALSE),IF('CP & Installation Detail'!I35=\"Existing\",VLOOKUP('CP & Installation Detail'!E15,D2:E5,2,FALSE),\"\"))","v":{"$error":"#N/A"}}]
["Rental",{"$f":"_xlfn.XLOOKUP(D25,'Data Direct Access Costs'!D12:D20,'Data Direct Access Costs'!B12:B20)","v":{"$error":"#N/A"}}]