{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["New Order","Lookups","Drop Downs","Pricing"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":36,"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":"New Order","index":0,"n_rows":1128,"n_cols":13,"rows_kept":1128,"cut":false,"hidden":false,"merged":[[118,1,119,5],[118,6,118,7],[118,8,118,11],[119,6,119,7],[119,8,119,11],[14,8,14,9],[114,1,115,5],[114,6,114,7],[114,8,114,11],[115,6,115,7],[115,8,115,11],[117,1,117,5],[117,6,117,7],[117,8,117,11],[92,2,92,6],[92,7,92,9],[95,1,102,11],[105,1,106,11],[113,1,113,5],[113,6,113,7],[113,8,113,11],[89,2,89,6],[89,7,89,9],[90,2,90,6],[90,7,90,9],[91,2,91,6],[91,7,91,9],[86,2,86,6],[86,7,86,9],[87,2,87,6],[87,7,87,9],[88,2,88,6],[88,7,88,9],[83,2,83,6],[83,7,83,9],[84,2,84,6],[84,7,84,9],[85,2,85,6],[85,7,85,9],[80,2,80,6],[80,7,80,9],[81,2,81,6],[81,7,81,9],[82,2,82,6],[82,7,82,9],[58,3,58,4],[58,5,58,6],[58,7,58,11],[59,7,59,11],[60,7,60,11],[78,1,78,4],[78,5,78,6],[78,8,78,10],[56,3,56,4],[56,5,56,6],[56,7,56,11],[57,3,57,4],[57,5,57,6],[57,7,57,11],[54,3,54,4],[54,5,54,6],[54,7,54,11],[55,3,55,4],[55,5,55,6],[55,7,55,11],[52,3,52,4],[52,5,52,6],[52,7,52,11],[53,3,53,4],[53,5,53,6],[53,7,53,11],[47,6,47,8],[47,9,47,11],[50,3,50,4],[50,5,50,6],[50,7,50,11],[51,3,51,4],[51,5,51,6],[51,7,51,11],[43,6,43,8],[43,9,43,11],[44,9,44,11],[45,9,45,11],[46,6,46,8],[46,9,46,11],[39,6,39,8],[39,9,39,11],[40,6,40,8],[40,9,40,11],[42,6,42,8],[42,9,42,11],[36,6,36,8],[36,9,36,11],[37,6,37,8],[37,9,37,11],[38,6,38,8],[38,9,38,11],[25,3,25,5],[25,7,25,9],[26,2,26,3],[26,4,26,6],[26,8,26,9],[35,6,35,8],[35,9,35,11],[22,3,22,5],[22,7,22,9],[23,3,23,5],[23,7,23,9],[24,3,24,5],[24,7,24,9],[28,3,28,5],[28,7,28,8],[28,9,28,10],[29,3,29,5],[29,7,29,8],[29,9,29,10],[31,1,32,11],[19,3,19,5],[19,7,19,9],[20,3,20,5],[20,7,20,9],[21,3,21,5],[21,7,21,9],[14,1,14,2],[14,4,14,6],[14,10,14,11],[17,3,17,5],[17,7,17,9],[18,3,18,5],[18,7,18,9],[12,1,12,2],[12,4,12,6],[12,10,12,11],[13,1,13,2],[13,4,13,6],[13,10,13,11],[10,1,10,2],[10,4,10,6],[10,10,10,11],[11,1,11,2],[11,4,11,6],[11,10,11,11],[5,7,5,8],[5,9,5,11],[8,1,8,2],[8,4,8,6],[8,10,8,11],[9,1,9,2],[9,4,9,6],[9,10,9,11],[1,6,1,11],[2,7,2,8],[2,9,2,11],[3,7,3,8],[3,9,3,11],[4,7,4,8],[4,9,4,11],[2,1,5,5]]}
[]
[]
[null,"Zest4 FDH Dealer Order Form v2.1.1",null,null,null,null,null,"Partner Name"]
[null,null,null,null,null,null,null,"Partner Code"]
[null,null,null,null,null,null,null,"Credit Check Ref."]
[null,null,null,null,null,null,null,"Email Address"]
[]
[null,"Customer Information"]
[null,"Name & Billing Address",null,null,"Installation Address (if different)",null,null,null,"Contact Name"]
[null,null,null,null,null,null,null,null,"Email Address"]
[null,null,null,null,null,null,null,null,"Telephone No."]
[null,null,null,null,null,null,null,null,"Company No."]
[null,null,null,null,null,null,null,null,"VAT No."]
[null,null,null,null,null,null,null,null,"Company Size"]
[null,null,null,null,null,null,null,null,"Term / months"]
[]
[null,"Line Rental"]
[null,"New/Port","Service Type","Product",null,null,"Quantity","Phone Number",null,null,"Monthly Price","Set Up Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D19,subscriptions,4,0)*G19,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D19,subscriptions,5,0)*G19,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",VLOOKUP('New Order'!E27,#REF!,2,FALSE)*IF(H27=\"\",1,H27))","v":""}]
[null,"Bespoke Connectivity"]
[null,"New / Migration","Quote Reference","Product",null,null,"Bandwidth","Line Rental",null,"Set Up Cost",null,"Cost over Term"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H30=\"\",J30=\"\"),\"\",H30*K15+J30)","v":""}]
[]
[null,"Please note: Upon cessation of a leased line, assured or converged service, the managed routed associated with this service must be returned within 30 days. Failure to return this equipment will result in a £300 ex. VAT charge being applied."]
[]
[]
[null,"Bolt Ons",null,null,null,null,"Total Monthly Cost for Line Rental and Bolt Ons"]
[null,"Bolt On Type","Product","Qty","Price","Set Up Cost","Line Rental",null,null,{"$f":"IF(SUM(K19:K26)+C62+B66+H30=0,\"\",SUM(K19:K26)+C62+B66+H30)","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(C37,boltons,4,0)*IF(C37=\"UK Virtual Number\",IF(D37<=5,0,D37-5),D37),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C37,boltons,5,0)*D37,\"\")","v":""},"Bolt Ons",null,null,{"$f":"IF(SUM(E37:E49)+IF(G62=\"\",0,G62)=0,\"\",SUM(E37:E49)+IF(G62=\"\",0,G62))","v":""}]
[null,null,null,null,"","","Monthly Cost ex. VAT",null,null,{"$f":"IF(SUM(J36:L37)=0,\"\",SUM(J36:L37))","v":""}]
[null,null,null,null,"","","VAT",null,null,{"$f":"IF(J38=\"\",\"\",J38*0.2)","v":""}]
[null,null,null,null,"","","Monthly Cost inc. VAT",null,null,{"$f":"IF(J39=\"\",\"\",J39+J38)","v":""}]
[null,null,null,null,"","","Cost over Term inc. VAT",null,null,{"$f":"IF(J40=\"\",\"\",J40*K15)","v":""}]
[null,null,null,null,"","","Installation, Site Survey and Hardware"]
[null,null,null,null,"","","Installation Required?"]
[null,null,null,null,"","","Site Survey Required?"]
[null,null,null,null,"","","Cost for Install & Site Survey",null,null,{"$f":"IF(COUNTIFS(C19:C26,\"8X8\")+COUNTIFS(C19:C26,\"Horizon\")=0,\"\",IF(J43=\"Yes\",VLOOKUP(SUMIFS(G19:G26,C19:C26,\"8X8\")+SUMIFS(G19:G26,C19:C26,\"Horizon\"),horizoninstall,2,TRUE),0)+IF(J44=\"Yes\",VLOOKUP(SUMIFS(G19:G26,C19:C26,\"8X8\")+SUMIFS(G19:G26,C19:C26,\"Horizon\"),horizonsurvey,2,TRUE),0))","v":""}]
[null,null,null,null,"","","Install Cost (Bespoke Connectivity)",null,null,{"$f":"IF(J30=\"\",\"\",J30)","v":""}]
[null,null,null,null,"","","Other Set Up Costs",null,null,{"$f":"IF(SUM(L19:L26)+SUM(F37:F48)+C66=0,\"\",SUM(L19:L26)+SUM(F37:F48)+C66)","v":""}]
[null,null,null,null,"","","Hardware",null,null,{"$f":"IF(SUM(K82:K93)=0,\"\",SUM(K82:K93)+L79)","v":""}]
[]
[null,"Line Porting"]
[null,"Phone Number","Single/MultiLine","Current Network",null,"Current Supplier",null,"Installation Address inc Postcode"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bespoke Price (NGN Numbers, CAT5 Cabling)",null,null,"VCC Call Recording"]
[null,"Quote Reference","Quoted Cost P/M",null,"Duration","Quantity","Monthly Cost"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E62,vccprices,2,0)*F62,\"\")","v":""}]
[]
[null,"PCI Compliance"]
[null,"Monthly Cost","Upfront Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hardware"]
[]
[]
[null,"Qualified Subscriptions for Hardware Incentive",null,null,null,null,null,null,"Delivery Cost",null,null,{"$f":"SUM(L82:L93)","v":0}]
[]
[null,"Hardware Type","Model",null,null,null,null,"Quantity",null,null,"Cost","Delivery"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B82=\"8X8\",VLOOKUP(C82,eightbyeighthwpricing,2,0),IF(B82=\"Horizon\",VLOOKUP(C82,horizonhwpricing,2,0),\"\"))*H82,\"\")","v":""},{"$f":"IF(B82=\"\",\"\",5*H82)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(B83=\"\",\"\",5*H83)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[]
[null,"Special Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Declaration & Signatures"]
[null,"The customer hereby orders and Zest4 agrees to supply, the equipment and services set out in this Service Order Form. The customer expressly agrees that it has read, understood and accepts the terms & conditions of this Agreement without limitation the Conditions reproduced hereafter."]
[]
[]
[null,"Zest4 will not accept any liability for any existing agreement termination fees unless expressly included and detailed on this order form."]
[]
[null,"All Communications Ltd trading as Zest4 is registered in England & Wales number 07983353"]
[]
[]
[null,"Signed On Behalf of the customer",null,null,null,null,"Name"]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,"Date"]
[]
[null,"Signed On Behalf of Zest4",null,null,null,null,"Name"]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Lookups","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Cell Reference","lntypes"," ",null,"lbotypes"," ",null,"lhwtypes"," "]
[null,"PSTN","pstn",null,"Mobile Minutes","mobileminutes",null,"8X8","eightbyeighthw"]
[null,"Assured","assured",null,"Akixi","akixi",null,"Horizon","horizonhw"]
[null,"Horizon","horizon",null,"Call Recording","callrecording"]
[null,"8X8","eightbyeight",null,"8X8","eightbyeightbo"]
[null,"SIP","sip",null,"Misc","misc"]
[null,"ISDN","isdn"]
[null,"FTTC","fttc"]
[null,"ADSL","adsl"]
[null,"FTTP","fttp"]
[null,"GFAST","gfast"]
[null,"Converged","converged"]

{"sheet":"Drop Downs","index":2,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Table Ref","dntypes","pstn","assured","horizon","eightbyeight","sip","isdn","fttc","adsl","fttp","gfast","converged","dbotypes","mobileminutes","akixi","callrecording","eightbyeightbo","misc","hwtypes","eightbyeighthw","horizonhw","porting","vcc"]
[null,"Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose.."]
[null,"PSTN","PSTN New Install","Assured 5","Horizon Basic","Lobby","SIP Basic New Install","ISDN2 New Install","Z4 FTTC 80/20 (12 Months)","Z4 ADSL+","Z4 FTTP 40/10","Z4 GFAST 160/30","ADSL2+ Converged","Mobile Minutes","1000 Mobile Minutes","Akixi Lite Supervisor","Call Recording 900MB","UK Virtual Number","Horizon Integrator","8X8","Cisco 7811 - PoE","Cisco SPA 504","Single Line","10 Days"]
[null,"Assured","PSTN Transfer","Assured 10","Horizon Premium","X1","SIP Basic Transfer","ISDN2 Transfer","Z4 FTTC 80/20 (24 Months)",null,"Z4 FTTP 55/10","Z4 GFAST 330/50","FTTC Converged Unlimited","Akixi","3000 Mobile Minutes","Akixi Lite Extension","Call Recording 1800MB","International Virtual Number","Horizon CRM Integrator","Horizon","Cisco 7821 - PoE","Cisco SPA 504 (Hardware Incentive)","Multi Line","40 Days"]
[null,"Horizon",null,"Assured 15","Collaborate","X2","SIP Premium New Install","ISDN2 DDI",null,null,"Z4 FTTP 80/20",null,null,"Call Recording","5000 Mobile Minutes","Akixi 1000 Supervisor","Call Recording 3600MB","International Toll Free Virtual Number","Horizon Desktop Softphone",null,"Cisco 8841 - PoE","Cisco SPA 122","DDI Block (1-10)","100 Days"]
[null,"8X8",null,null,null,"X3","SIP Premium Transfer","ISDN30 New Install",null,null,"Z4 FTTP 160/30",null,null,"8X8","10000 Mobile Minutes","Akixi 1000 Extension","Call Recording 9000MB","International Virtual Fax Number","Horizon Smartphone App",null,"Cisco 8861 - PoE","Cisco SPA 122 (Hardware Incentive)","DDI Block (11+)","400 Days"]
[null,"SIP",null,null,null,"X4","SIP Extra New Install","ISDN30 Transfer",null,null,"Z4 FTTP 20/30",null,null,"Misc",null,"Akixi 2000 Supervisor","Call Recording 18000MB",null,"Horizon Call Queue User",null,"Cisco IP Phone 8800 Key Expansion Module","Cisco SPADS500"]
[null,"ISDN",null,null,null,"X6","SIP Extra Transfer","ISDN30 DDI",null,null,"Z4 FTTP 330/50",null,null,null,null,"Akixi 2000 Extension","Call Recording 45000MB",null,"Horizon Receptionist Console",null,"Cisco Power Supply for SPA525G2, SPA504G, SPA502G, SPA112, SPA122","Polycom SoundStation IP 5000"]
[null,"ADSL",null,null,null,"X7",null,null,null,null,null,null,null,null,null,null,"Call Recording 90000MB",null,null,null,"Cisco SPA 122 ATA","Cisco MPP 6851"]
[null,"FTTC",null,null,null,"X8",null,null,null,null,null,null,null,null,null,null,"Call Recording 180000MB",null,null,null,"Cisco SPA 504G","Cisco MPP 8841"]
[null,"FTTP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Call Recording 360000MB",null,null,null,"Panasonic DECT + DECT Base, UK","Cisco MPP 8851"]
[null,"GFAST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Month Business Call Recording",null,null,null,"Panasonic DECT Compact H/S UK","Cisco MPP 8861"]
[null,"Converged",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 Month Business Call Recording",null,null,null,"Panasonic DECT Desk Phone UK","Cisco SPA 122"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 Month Business Call Recording",null,null,null,"Panasonic DECT Extra H/S UK","Cisco MPP UK Power Cord (7832 PSU Component 3 of 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24 Month Business Call Recording",null,null,null,"Panasonic DECT Repeater UK","Cisco MPP 8800 Series Power Supply"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"84 Month Compliant Call Recording",null,null,null,"Panasonic DECT Rugged H/S UK","Cisco MPP 8800 Series Expansion Module"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom IP 5000 Speakerphone","Cisco PA100 power supply"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom IP 6000 Speakerphone","Plantronics Blackwire 5220 USB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom IP5000 Power Injector","Poly Voyager 5200 Bluetooth Headset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom IP6000 Power Injector","Poly Voyager 6200 UC Bluetooth Headset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom Power Supply for VVX 300, 301, 310, 311, 400, 401, 410, 411","Poly Voyager 8200 UC  Bluetooth Headset "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom PSU EU for VVX300, 310, 400, 410 - 48V","Poly Voyager Focus UC Bluetooth Headset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 101PoE","Poly Savi 8220 Headset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 150PoE","Polycom Trio 8500 Conference Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 201PoE","Polycom Trio 8800 Conference Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 250PoE","Polycom Trio Conference Unit Power Supply"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 301","Polycom Trio Extra Microphones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 311","Polycom Studio USB Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 350PoE","Polycom VVX 150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 401","Polycom VVX 150 (Hardware Incentive)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 411","Polycom VVX 250"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 450PoE","Polycom VVX 250 (Hardware Incentive)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 501","Polycom VVX 310"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 601","Polycom VVX 310 (Hardware Incentive)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX Webcam","Polycom VVX 450"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VVX 28 Line Color Sidecar adds 28 Line Keys","Polycom VVX 450 (Hardware Incentive)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VVX 40 Line Paper Label Sidecar adds 40 Line Keys","Polycom VVX 500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom RealPrescence Trio 8800 IP Conference phone (No Power Kit)","Polycom VVX 600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 450 Expansion Module"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX Colour Expansion Module"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 201 Power Supply "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 411 Power Supply"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX Power Supply "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX x50 Power Supply "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom USB WiFi Adaptor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink W52P Dect Handset and Base Station                                      "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink W52H Dect Handset Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink Dect Repeater"]

{"sheet":"Pricing","index":3,"n_rows":48,"n_cols":35,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Table Ref","subscriptions",null,null,null,null,null,null,"boltons",null,null,null,null,null,null,"eightbyeighthwpricing",null,null,"horizonhwpricing",null,null,"horizondelivery",null,null,"portingpricing",null,null,"horizoninstall",null,null,"horizonsurvey",null,null,"vccprices"]
[null,"Subscriptions","Wholesale Sell","Wholesale Set Up Sell","RRP Sell","RRP Set Up Sell","RRP Rev Share",null,"Bolt Ons","Wholesale Sell","Wholesale Set Up Sell","RRP Sell","RRP Set Up Sell","RRP Rev Share",null,"8x8 Hardware","Sell",null,"Horizon Hardware","Sell",null,"Delivery Bands","Cost Out",null,"Porting Charges","Sell Price",null,"Horizon Install","Sell",null,"Horizon Install Costs","Sell",null,"VCC Call Recording","Sell"]
[null,"PSTN New Install",10.5,75,12.99,99,0.1,null,"Horizon Integrator",1.25,0,1.5,0,0.1,null,"Cisco 7811 - PoE",62.02,null,"Cisco SPA 504",103.5,null,0,0,null,"Single Line",12,null,1,430,null,1,150,null,"10 Days",18]
[null,"PSTN Transfer",10.5,null,12.99,null,0.1,null,"Horizon CRM Integrator",3.5,0,4,0,0.1,null,"Cisco 7821 - PoE",80.89,null,"Cisco SPA 504 (Hardware Incentive)",0,null,1,15,null,"Multi Line",22,null,11,430,null,11,270,null,"40 Days",20]
[null,"Assured 5",31.200000000000003,null,40,null,0.2,null,"Horizon Desktop Softphone",2,0,2.25,0,0.1,null,"Cisco 8841 - PoE",147.69999999999999,null,"Cisco SPA 122",61,null,11,30,null,"DDI Block (1-10)",56,null,31,755,null,31,325,null,"100 Days",27]
[null,"Assured 10",35.1,null,45,null,0.2,null,"Horizon Smartphone App",2,0,2.25,0,0.1,null,"Cisco 8861 - PoE",290.5,null,"Cisco SPA 122 (Hardware Incentive)",0,null,31,35,null,"DDI Block (11+)",110,null,49,1135,null,49,430,null,"400 Days",36]
[null,"Assured 15",36.660000000000004,null,47,null,0.2,null,"Horizon Call Queue User",1.76,0,2,0,0.1,null,"Cisco IP Phone 8800 Key Expansion Module",194.62,null,"Cisco SPADS500",100,null,51,55,null,null,null,null,97,1510,null,97,540]
[null,"SIP Basic New Install",5.28,60,6,70,0.1,null,"Horizon Receptionist Console",22,0,25,0,0.1,null,"Cisco Power Supply for SPA525G2, SPA504G, SPA502G, SPA112, SPA122",10,null,"Polycom SoundStation IP 5000",355,null,80,75]
[null,"SIP Basic Transfer",5.28,null,6,null,0.1,null,"Horizon Call Centre Supervisor",22,0,25,0,0.1,null,"Cisco SPA 122 ATA",45.33,null,"Cisco MPP 6851",105.78,null,101,100]
[null,"SIP Premium New Install",5.72,60,6.5,70,0.1,null,"Horizon Call Centre Agent",4.4000000000000004,0,5,0,0.1,null,"Cisco SPA 504G",83.91,null,"Cisco MPP 8841",135,null,151,125]
[null,"SIP Premium Transfer",5.72,null,6.5,null,0.1,null,"UK Virtual Number",1,0,1,0,0,null,"Panasonic DECT + DECT Base, UK",87.4,null,"Cisco MPP 8851",157.84,null,201,145]
[null,"SIP Extra New Install",6.16,60,7,70,0.1,null,"International Virtual Number",6,8,9,10,0.1,null,"Panasonic DECT Compact H/S UK",180.86,null,"Cisco MPP 8861",175.27]
[null,"SIP Extra Transfer",6.16,null,7,null,0.1,null,"International Toll Free Virtual Number",6,8,9,10,0.1,null,"Panasonic DECT Desk Phone UK",90.54,null,"Cisco SPA 122",61]
[null,"Horizon Basic",8.4499999999999993,0,9.9499999999999993,0,0.15,null,"International Virtual Fax Number",6,8,9,10,0.1,null,"Panasonic DECT Extra H/S UK",64.62,null,"Cisco MPP UK Power Cord (7832 PSU Component 3 of 3)",5.5]
[null,"Horizon Premium",10.25,0,14.95,0,0.3,null,"Call Recording 900MB",11,0,12.5,0,0.1,null,"Panasonic DECT Repeater UK",93.54,null,"Cisco MPP 8800 Series Power Supply",25]
[null,"Collaborate",4.5,0,6,0,0.2,null,"Call Recording 1800MB",22,0,25,0,0.1,null,"Panasonic DECT Rugged H/S UK",306.52,null,"Cisco MPP 8800 Series Expansion Module",175.22]
[null,"Lobby",3.5,15,4,15,0.1,null,"Call Recording 3600MB",38.28,0,43.5,0,0.1,null,"Polycom IP 5000 Speakerphone",355,null,"Cisco PA100 power supply",10]
[null,"X1",8.5,15,11,15,0.2,null,"Call Recording 9000MB",55,0,42.5,0,0.1,null,"Polycom IP 6000 Speakerphone",303.48,null,"Plantronics Blackwire 5220 USB",94]
[null,"X2",13.5,15,20,15,0.25,null,"Call Recording 18000MB",88,0,100,0,0.1,null,"Polycom IP5000 Power Injector",64.78,null,"Poly Voyager 5200 Bluetooth Headset",96.71]
[null,"X3",17.5,15,25,15,0.25,null,"Call Recording 45000MB",132,0,150,0,0.1,null,"Polycom IP6000 Power Injector",64.78,null,"Poly Voyager 6200 UC Bluetooth Headset",147]
[null,"X4",25,15,37,15,0.25,null,"Call Recording 90000MB",198,0,225,0,0.1,null,"Polycom Power Supply for VVX 300, 301, 310, 311, 400, 401, 410, 411",15,null,"Poly Voyager 8200 UC  Bluetooth Headset ",195.35]
[null,"X6",60,15,90,15,0.25,null,"Call Recording 180000MB",330,0,375,0,0.1,null,"Polycom PSU EU for VVX300, 310, 400, 410 - 48V",15,null,"Poly Voyager Focus UC Bluetooth Headset",146.81]
[null,"X7",75,15,105,15,0.25,null,"Call Recording 360000MB",550,0,625,0,0.1,null,"Polycom VVX 101PoE",64.319999999999993,null,"Poly Savi 8220 Headset",233.38]
[null,"X8",90,15,135,15,0.25,null,"1000 Mobile Minutes",8,0,10,0,0.1,null,"Polycom VVX 150PoE",72.67,null,"Polycom Trio 8500 Conference Unit",583.99]
[null,"ISDN2 New Install",23,200,27,200,0.1,null,"3000 Mobile Minutes",24,0,30,0,0.1,null,"Polycom VVX 201PoE",66.81,null,"Polycom Trio 8800 Conference Unit",794]
[null,"ISDN2 Transfer",23,0,27,0,0.1,null,"5000 Mobile Minutes",40,0,50,0,0.1,null,"Polycom VVX 250PoE",116.16,null,"Polycom Trio Conference Unit Power Supply",110]
[null,"ISDN2 DDI",0.3,1.5,0.3,1.5,0.1,null,"10000 Mobile Minutes",80,0,100,0,0.1,null,"Polycom VVX 301",81.94,null,"Polycom Trio Extra Microphones",225]
[null,"ISDN30 New Install",12,1200,13.5,1200,0.1,null,"Akixi 1000 Supervisor",6.25,165,6.75,182.5,0.1,null,"Polycom VVX 311",97.62,null,"Polycom Studio USB Bar",680]
[null,"ISDN30 Transfer",12,0,13.5,0,0.1,null,"Akixi 1000 Extension",1.95,0,2.1,0,0.1,null,"Polycom VVX 350PoE",151.28,null,"Polycom VVX 150",65]
[null,"ISDN30 DDI",0.25,1.5,0.3,1.5,0.1,null,"Akixi 2000 Supervisor",23.95,425,25.75,472.5,0.1,null,"Polycom VVX 401",103.77,null,"Polycom VVX 150 (Hardware Incentive)",0]
[null,"Z4 ADSL+",9.5,0,12.5,0,0.2,null,"Akixi 2000 Extension",1.95,0,2.1,0,0.1,null,"Polycom VVX 411",106.33,null,"Polycom VVX 250",101.5]
[null,"Z4 FTTC 80/20 (12 Months)",18.5,0,25,0,0.2,null,"3 Month Business Call Recording",1.5,0,2,0,0.2,null,"Polycom VVX 450PoE",175.22,null,"Polycom VVX 250 (Hardware Incentive)",0]
[null,"Z4 FTTC 80/20 (24 Months)",17,0,23.5,0,0.2,null,"6 Month Business Call Recording",1.75,0,2.25,0,0.2,null,"Polycom VVX 501",145.9,null,"Polycom VVX 310",94.7]
[null,"Z4 GFAST 160/30",30,50,38,50,0.2,null,"12 Month Business Call Recording",2,0,2.5,0,0.2,null,"Polycom VVX 601",179.96,null,"Polycom VVX 310 (Hardware Incentive)",0]
[null,"Z4 GFAST 330/50",34,50,43,50,0.2,null,"24 Month Business Call Recording",4,0,5,0,0.2,null,"Polycom VVX Webcam",83.91,null,"Polycom VVX 450",125]
[null,"Z4 FTTP 40/10",29,50,37,50,0.2,null,"84 Month Compliant Call Recording",10,0,12.5,0,0.2,null,"VVX 28 Line Color Sidecar adds 28 Line Keys",144.16,null,"Polycom VVX 450 (Hardware Incentive)",0]
[null,"Z4 FTTP 55/10",31,50,40,50,0.2,null,null,null,null,null,null,null,null,"VVX 40 Line Paper Label Sidecar adds 40 Line Keys",72.61,null,"Polycom VVX 500",155.19999999999999]
[null,"Z4 FTTP 80/20",33,50,42,50,0.2,null,null,null,null,null,null,null,null,"Polycom RealPrescence Trio 8800 IP Conference phone (No Power Kit)",1400,null,"Polycom VVX 600",197.6]
[null,"Z4 FTTP 160/30",39,50,50,50,0.2,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 450 Expansion Module",175.35]
[null,"Z4 FTTP 20/30",43,50,55,50,0.2,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX Colour Expansion Module",173.4]
[null,"Z4 FTTP 330/50",50,50,63,50,0.2,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 201 Power Supply ",13]
[null,"ADSL2+ Converged",31.2,0,40,0,0.2,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX 411 Power Supply",25.25]
[null,"FTTC Converged Unlimited",46.8,0,60,0,0.2,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX Power Supply ",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom VVX x50 Power Supply ",25.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polycom USB WiFi Adaptor",24.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink W52P Dect Handset and Base Station                                      ",94.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink W52H Dect Handset Only",64.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yealink Dect Repeater",137.1]