{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Customer Agreement","Standard M2M Connections","Formulas","Smart Tracker Schedule","Standard M2M Terms"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":2,"defined_names":53,"comments":2,"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":"Customer Agreement","index":0,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[[60,1,60,21],[48,2,48,20],[49,2,49,4],[49,5,49,16],[49,18,49,20],[50,2,50,20],[59,1,59,21],[44,2,44,20],[45,2,45,20],[46,2,47,4],[46,5,47,16],[46,17,47,17],[46,18,47,20],[38,2,38,20],[39,2,39,20],[40,2,40,20],[41,2,41,20],[42,2,42,20],[31,2,31,13],[31,16,31,20],[32,3,32,13],[32,17,32,20],[43,2,43,12],[43,13,43,20],[33,2,33,20],[34,1,34,21],[35,1,35,21],[36,1,50,1],[36,2,36,20],[36,21,50,21],[37,2,37,6],[37,7,37,11],[37,13,37,18],[37,19,37,20],[28,6,28,13],[28,18,28,20],[29,2,29,13],[29,16,29,20],[30,6,30,13],[30,18,30,20],[25,2,25,13],[25,16,25,20],[26,3,26,11],[26,17,26,18],[27,2,27,13],[27,16,27,20],[22,16,24,16],[22,17,22,20],[23,3,23,13],[23,17,23,20],[24,3,24,13],[24,17,24,20],[15,1,15,21],[16,1,16,21],[17,1,33,1],[17,2,17,20],[17,21,33,21],[18,5,18,16],[18,19,18,20],[19,2,19,20],[20,2,20,12],[20,13,20,15],[20,18,20,20],[21,2,21,20],[22,2,24,2],[22,3,22,13],[22,14,32,14],[22,15,32,15],[11,2,11,16],[11,17,11,20],[12,2,12,20],[13,2,13,11],[13,12,13,15],[7,2,7,20],[8,2,8,15],[8,16,8,20],[9,2,9,20],[10,2,10,20],[0,0,60,0],[0,1,0,21],[0,22,60,22],[1,2,3,2],[1,6,1,16],[1,18,2,18],[1,19,2,20],[2,6,2,17],[3,3,3,21],[4,1,4,21],[14,2,14,20],[5,1,14,1],[5,2,5,20],[5,21,14,21],[6,2,6,15],[6,16,6,20]]}
[]
[null,null,null,null,null,null,"Customer Agreement M2M",null,null,null,null,null,null,null,null,null,null,null,"Dealer Code","ZD XXXX"]
[null,null,null,null,null,null,"For assistance please call Customer Service on 0161 956 3300"]
[]
[null,"          General Information"]
[]
[null,null,"Which category best describes you as a customer?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ltd/Plc (under 50 employees)"]
[]
[null,null,"Please choose the type of order:",null,null,null,null,null,null,null,null,null,null,null,null,null,"New Connections/Ports/Migrations"]
[]
[null,null,{"$f":"IF(Q9=\"Upgrade\",\"The customer must have been connected for 12 months and been issued with a new full UK spec handset from the recommended list.\",\"For all orders it is important to specify the precise details for existing customers to avoid confusion over the billing set up.\")","v":"For all orders it is important to specify the precise details for existing customers to avoid confusion over the billing set up."}]
[null,null,{"$f":"IF(Q9=\"Upgrade\",\"Please enter the Zest4 Acc No. for the handset(s) to be upgraded:\",(IF(Q9=\"Choose Option\",\"\",(IF(Q9=\"Customer Change\",\"Please enter the current Zest4 Acc No. for the attached handsets(s):\",(IF(Q9=\"Number Change\",\"Please enter the existing Mobile Number to be changed:\",\"If you are an existing Zest4 customer, please enter Acc or Mobile No:\")))))))","v":"If you are an existing Zest4 customer, please enter Acc or Mobile No:"}]
[]
[null,null,"Complete totals if applicable:",null,null,null,null,null,null,null,null,null,"New connections",null,null,null,null,"Ports",null,"Migs"]
[]
[]
[null,"          Business Details"]
[]
[null,null,"Business Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Reg. No."]
[]
[null,null,"How long has the company been in business?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Years",null,"Months"]
[]
[null,null,"Registered Office Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Billing address\n(if different)"]
[]
[]
[]
[null,null,"County",null,null,null,null,null,null,null,null,null,"Postcode",null,null,null,"County",null,null,"Postcode"]
[]
[null,null,"Business tel number",null,null,null,null,null,null,null,null,null,null,null,null,null,"Business tel number"]
[]
[null,null,"Business fax number",null,null,null,null,null,null,null,null,null,null,null,null,null,"Business fax number"]
[]
[null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
[]
[]
[null,"          Operative Provisions"]
[]
[null,null,"Contract duration",null,null,null,null,null,null,null,null,null,"months","Credit Check Reference: "]
[]
[null,null,"1.  Upon our acceptance of this customer agreement, we, All Communications Limited (trading as Zest4), agree to permit use of the M2M SIM card(s) and to provide the services on the terms and conditions set out on this customer contract, the current terms & conditions and in the connection schedule."]
[null,null,"2.  You acknowledge that we are a supplier of mobile telecommunication and machine to machine services and are independent of any dealer who may have seperately supplied you with devices, software solution (s) and/or related equipment. "]
[null,null,"3.  You acknowledge that we will not be requiring to comply with any statements made by any dealer or customer unless they are set out in this customer agreement or in the connection schedule."]
[null,null,"4.  We may use information regarding you to administer your account and also send you information about our products and services and the products and services of others. We may also search the files of one or more credit reference agencies who may keep a record of that search. If you do not wish your information to be used for marketing purposes please tick "]
[null,null,"this box or contact us using the contact details overleaf."]
[null,null,"5.  By signing this agreement you confirm that you are an authorised signatory of the company entering into this contract."]
[]
[null,null,"Authorised Signature(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,"Print Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Position:"]
[]
[null,null,"Choose Option",null,null,null,null,null,null,null,null,null,"Choose Option"]
[null,null,"Ltd/Plc (under 50 employees)",null,null,null,null,null,null,null,null,null,"New Connections/Ports/Migrations"]
[null,null,"Ltd/Plc (50 employees or more)",null,null,null,null,null,null,null,null,null,"Upgrades"]
[null,null,"Partnership (50 employees or more)",null,null,null,null,null,null,null,null,null,"Number Change"]
[null,null,"NHS",null,null,null,null,null,null,null,null,null,"Customer Change"]
[null,null,"Charity"]
[null,null,"Government"]
[null,null,"Other"]

{"sheet":"Standard M2M Connections","index":1,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[[35,13,35,15],[36,13,36,15],[4,19,5,20],[32,8,32,11],[4,4,4,16],[23,14,23,15],[24,2,24,13],[25,2,25,13],[26,2,26,13],[29,3,29,6],[30,3,30,6],[31,2,31,5],[29,10,29,15],[30,10,30,15],[38,1,38,17],[34,12,35,12],[33,2,35,2],[37,3,37,6],[33,3,33,6],[34,3,34,6],[35,3,35,6],[36,3,36,6],[33,8,33,11],[32,7,35,7],[36,8,36,11],[32,3,32,6],[37,13,37,15],[34,8,34,11],[35,8,35,11],[34,13,34,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partner (Tier 2) Name","Partner (Tier 2) Contact Name","Partner (Tier 2) Contact Email Address"]
[null,null,null,null,"M2M Connection Schedule"]
[null,null,null,null,"February 2018 - Version 2"]
[]
[null,null,null,null,"For assistance please call Customer Service on 0161 956 3300",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal Use Only"]
[]
[null,null,"Conn Type","Mobile Number","Customer Name","Quote Ref -               (For Zest4 use)","Term","Network - \nAll Vofafone connections have a monthly recurring access fee. ","Tariff Type","Zest4 Tariff","Line Rental per month","UK Data Overage ","UK Price Per Text","UK Voice ppm","SIM Number","IP Address","Spend Limits / Data Alerts","Spend Limits / Data Caps","Spend Limits / Data Alert and Data Cap Email Addrress","Mobile Network Operator","Network Tariff Name"]
[null,1,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H8),\"\",IFERROR(VLOOKUP(H8,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J8,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,2,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H9),\"\",IFERROR(VLOOKUP(H9,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J9,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,3,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J10,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J10,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J10,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J10,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H10),\"\",IFERROR(VLOOKUP(H10,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J10,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,4,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J11,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J11,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J11,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J11,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H11),\"\",IFERROR(VLOOKUP(H11,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J11,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,5,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J12,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J12,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J12,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J12,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H12),\"\",IFERROR(VLOOKUP(H12,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J12,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,6,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J13,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J13,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J13,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J13,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H13),\"\",IFERROR(VLOOKUP(H13,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J13,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,7,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J14,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J14,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J14,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J14,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H14),\"\",IFERROR(VLOOKUP(H14,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J14,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,8,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J15,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J15,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J15,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J15,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H15),\"\",IFERROR(VLOOKUP(H15,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J15,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,9,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J16,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J16,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J16,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J16,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H16),\"\",IFERROR(VLOOKUP(H16,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J16,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,10,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J17,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J17,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J17,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J17,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H17),\"\",IFERROR(VLOOKUP(H17,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J17,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,11,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J18,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J18,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H18),\"\",IFERROR(VLOOKUP(H18,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J18,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,12,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J19,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J19,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J19,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J19,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H19),\"\",IFERROR(VLOOKUP(H19,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J19,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,13,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J20,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J20,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J20,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J20,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H20),\"\",IFERROR(VLOOKUP(H20,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J20,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,14,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J21,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J21,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J21,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J21,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H21),\"\",IFERROR(VLOOKUP(H21,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J21,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,15,"Select",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($J22,Formulas!$A:$H,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J22,Formulas!A:C,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J22,Formulas!A:D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J22,Formulas!A:E,5,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(H22),\"\",IFERROR(VLOOKUP(H22,Formulas!$G$5:$H$7,2,FALSE),\"N/A\"))","v":""},{"$f":"IFERROR(VLOOKUP(J22,Formulas!A:F,6,FALSE),\"\")","v":""}]
[null,null,"Please insert extra rows as required"]
[null,null,"Comments",null,null,null,null,null,null,null,null,null,null,null,"Business Partner Details"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP Contact Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP Contact Email"]
[]
[null,null,"Misc Details",null,null,null,null,null,null,null,"Customer Declaration"]
[null,null,"Network",null,null,null,null,null,null,null,"I confirm that the above information in conjunction with the Customer Agreement represent the full agreement and acknowledge"]
[null,null,"Customer Acc No",null,null,null,null,"Contract Term",{"$f":"G8","v":0},null," that we will not be required to comply with any statements made by any dealer unless they are set out in this customer agreement "]
[null,null,"Account Address",null,null,null,null,"Delivery Address"]
[null,null,"Name",null,null,null,null,"Delivery address","50 Alderley Road"]
[null,null,"Address",null,null,null,null,null,"Wilmslow"]
[null,null,null,null,null,null,null,null,"Cheshire",null,null,null,"Signed"]
[]
[null,null,null,null,null,null,null,"Postcode","SK9 1NY",null,null,null,"Name"]
[null,null,"Tel",null,null,null,null,"Tel","0161 956 3300",null,null,null,"Position"]
[]
[]
[]
[null,null,null,"Dealer","30 day","Vodafone","N/A - Reseller"]
[null,null,null,"Reseller","24 months","O2",0]
[null,null,null,null,"36 months",null,0.1]
[null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,0.4]

{"sheet":"Formulas","index":2,"n_rows":236,"n_cols":35,"rows_kept":236,"cut":false,"hidden":true,"merged":[]}
[null,"Price","Data Overage","Voice Overage","Text Overage","Network Tariff","Unlock Pin:","6264",null,null,null,null,null,null,"Network"]
["DTDVFPAYU",null,null,null,null,null,null,{"$f":"MAX('Standard M2M Connections'!B:B)+7","v":22},null,null,"30 day","Vodafone","30 dayVodafone","DTDVF","Vodafone","PAYU","PAYU",null,"TD","TFM","TSM",null,"DTDVF","DTFMVF","DTSMVF","DTDOT","DTFMOT","DTSMOT","DTFMAS","DTSMAS","DTFMEE","DTFMTT","DTFMZC","DTSMZC","DTDAS"]
["Voda Managed PAYU 30 days Primary User",18,"£6.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,null,"30 day","O2","30 dayO2","DTDOT","O2","Aggregated Bundle","AB",null,"Vodafone","Vodafone","Vodafone",null,"PAYU","PAYU","PAYU","Aggregated Bundle","Aggregated Bundle","Aggregated Bundle","Aggregated Bundle","Aggregated Bundle","Single User","Aggregated Bundle","UK Roaming","UK Roaming","Trial"]
["Additional User 30 day",12,"£6.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,null,"30 day","Anywhere SIM",{"$f":"K4&L4","v":"30 dayAnywhere SIM"},"DTDAS","Anywhere SIM","Voice & Data","VD",null,"O2","O2","O2",null,"Aggregated Bundle","Aggregated Bundle","Aggregated Bundle",null,"Global Roaming"]
[null,null,null,null,null,null,"O2","O2 UK 4G",null,null,"24 months","Vodafone","24 monthsVodafone","DTFMVF","Tele2","Single User","SU",null,"Anywhere SIM","Anywhere SIM","Zest4Connect",null,null,"Voice & Data","Voice & Data"]
["DTFMVFPAYU",null,null,null,null,null,"Zest4Connect","Arkessa Connect Si",null,null,"24 months","O2","24 monthsO2","DTFMOT","Zest4Connect","UK Roaming","UKR",null,null,"EE","Anywhere SIM"]
["Voda Managed PAYU 24M Primary User",16.5,"£4.5.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ","Vodafone","Vodafone UK 4G",null,null,"36 months","Vodafone","36 monthsVodafone","DTSMVF","EE","Trial","T",null,null,"Zest4Connect"]
["Additional User 24M",12,"£4.5.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,null,"36 months","O2","36 monthsO2","DTSMOT",null,"Global Roaming","GR",null,null,"Tele2"]
[null,null,null,null,null,null,"SIM Activation",{"$f":"COUNTIFS('Standard M2M Connections'!C:C,Formulas!G9)","v":0},null,null,"24 months","Anywhere SIM",{"$f":"K9&L9","v":"24 monthsAnywhere SIM"},"DTFMAS"]
["DTSMVFPAYU",null,null,null,null,null,"New Order",{"$f":"COUNTIFS('Standard M2M Connections'!C:C,Formulas!G10)","v":0},null,null,"24 months","EE","24 monthsEE","DTFMEE"]
["Voda Managed PAYU 36M Primary User",16,"£4.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,null,"24 months","Tele2","24 monthsTele2","DTFMTT"]
["Additional User 36M",12,"£4.00 Per GB","N/A","N/A","ZVF4G1GB/011460 ",{"$f":"COUNTIFS('Standard M2M Connections'!H:H,Formulas!H12)","v":0},"O2",null,null,"24 months","Zest4Connect","24 monthsZest4Connect","DTFMZC"]
[null,null,null,null,null,null,{"$f":"COUNTIFS('Standard M2M Connections'!H:H,Formulas!H13)","v":0},"Zest4Connect",null,null,"36 months","Zest4Connect","36 monthsZest4Connect","DTSMZC"]
["DTFMVFAB",null,null,null,null,null,{"$f":"COUNTIFS('Standard M2M Connections'!H:H,Formulas!H14)","v":0},"Vodafone",null,null,"36 months","Anywhere SIM","36 monthsAnywhere SIM","DTSMAS"]
["VF Aggregated 1GB 24M",5.5,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,0]
["VF Aggregated 5GB 24M",9.5,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",{"$f":"VLOOKUP(VLOOKUP(MAX(G12:G14),G12:H14,2,FALSE),G5:H7,2,FALSE)","v":"O2 UK 4G"},{"$f":"MAX(G12:G14)","v":0},null,0.1]
["VF Aggregated 10GB 24M",13,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,0.2]
["VF Aggregated 25GB 24M",23,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,0.3,null,null,null,null,null,"30 day","TD"]
["VF Aggregated 50GB 24M",42,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,0.4,null,null,null,null,null,"24 months","TFM"]
["VF Aggregated 100GB 24M",80,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 ",null,null,null,null,null,null,null,null,null,"36 months","TSM"]
["VF Aggregated 200GB 24M",150,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
[]
["DTSMVFAB"]
["VF Aggregated 1GB 36M",5,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 5GB 36M",8,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 10GB 36M",12,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 25GB 36M",22,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 50GB 36M",40,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 100GB 36M",75,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 200GB 36M",140,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
[]
["DTFMOTAB"]
["TELUK 10MB AGG 24M (WS) ",1.1000000000000001,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 30MB AGG 24M (WS) ",1.2,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 50MB AGG 24M (WS) ",1.3,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 100MB AGG 24M (WS) ",1.4,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 150MB AGG 24M (WS) ",1.5,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 200MB AGG 24M (WS) ",1.6,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 250MB AGG 24M (WS) ",1.7,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 300MB AGG 24M (WS) ",1.8,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 500MB AGG 24M (WS) ",2.5,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 1GB AGG 24M (WS)",4.5,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 2GB AGG 24M (WS)",8,"£0.02 Per MB","N/A","N/A","O2MRC/011458"]
["TELUK 3GB AGG 24M (WS)",10.75,"£0.02 Per MB","N/A","N/A","O2MRC/011458"]
["TELUK 5GB AGG 24M (WS)",18.25,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
["TELUK 10GB AGG 24M (WS)",33,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
["TELUK 50GB AGG 24M (WS)",111.73,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
[]
["DTSMOTAB"]
["TELUK 10MB AGG 36M (WS) ",1,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 30MB AGG 36M (WS) ",1.1000000000000001,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 50MB AGG 36M (WS) ",1.2,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 100MB AGG 36M (WS) ",1.3,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 150MB AGG 36M (WS) ",1.4,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 200MB AGG 36M (WS) ",1.5,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 250MB AGG 36M (WS) ",1.6,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 300MB AGG 36M (WS) ",1.7,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 500MB AGG 36M (WS) ",2.0499999999999998,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 1GB AGG 36M (WS) ",4,"£0.05 Per MB","N/A","N/A","021TBSIMA"]
["TELUK 2GB AGG 36M (WS)",7.75,"£0.02 Per MB","N/A","N/A","O2MRC/011458"]
["TELUK 3GB AGG 36M (WS)",10.25,"£0.02 Per MB","N/A","N/A","O2MRC/011458"]
["TELUK 5GB AGG 36M (WS)",17.75,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
["TELUK 10GB AGG 36M (WS)",31.46,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
["TELUK 50GB AGG 36M (WS)",103.75,"£0.02 Per MB","N/A","N/A","O2MRA/011457"]
[]
["DTDVFAB"]
["VF Aggregated 1GB 30 Day",7,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 5GB 30 Day",12,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 10GB 30 Day",15,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 25GB 30 Day",35,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 50GB 30 Day",55,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 100GB 30 Day",120,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
["VF Aggregated 200GB 30 Day",200,"£20 per GB","N/A","N/A","ZVF4G1GB/011460 "]
[]
["DTDOTAB"]
["TELUK 10MB AGG 30DAY (WS)",1.25,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 30MB AGG 30DAY (WS)",1.35,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 50MB AGG 30DAY (WS)",1.45,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 100MB AGG 30DAY (WS)",1.55,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 200MB AGG 30DAY (WS)",1.8,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 300MB AGG 30DAY (WS)",2,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 500MB AGG 30DAY (WS)",3,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 1GB AGG 30DAY (WS)",5,"£0.05 Per MB","£0.14 Per Minute","£0.09 Per Text","021TBSIMA"]
["TELUK 2GB AGG 30DAY (WS)",9,"£20.00 per GB","£0.14 Per Minute","£0.09 Per Text","O2MRC/011458"]
["TELUK 3GB AGG 30DAY (WS)",12.5,"£20.00 per GB","£0.14 Per Minute","£0.09 Per Text","O2MRC/011458"]
["TELUK 5GB AGG 30DAY (WS)",20,"£20.00 per GB","£0.14 Per Minute","£0.09 Per Text","O2MRA/011457"]
["TELUK 10GB AGG 30DAY (WS)",37.5,"£20.00 per GB","£0.14 Per Minute","£0.09 Per Text","O2MRA/011457"]
["TELUK 50GB AGG 30DAY (WS)",185,"£20.00 per GB","£0.14 Per Minute","£0.09 Per Text","O2MRA/011457"]
[]
["DTFMOTGR"]
["O2 Global Roaming SIM 50MB",1.78,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 100MB",2.15,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 200MB",2.9,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 300MB",3.6,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 400MB",4.3499999999999996,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 500MB",5.05,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 1GB",8.8000000000000007,"£0.1 per MB","£0.48 per Min","£0.4 per Text","O2GL2AD/011485"]
["O2 Global Roaming SIM 2GB",14.8,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 3GB",19.75,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 4GB",24.65,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 5GB",29.55,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 10GB",54.1,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 20GB",103.25,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
["O2 Global Roaming SIM 50GB",250.7,"£0.1 per MB","£0.48 per Min","£0.4 per Text","02GL2AE/011486"]
[]
["DTSMASAB"]
["Anywhere Sim 1MB 36M (WS)",0.48000000000000004,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 10MB 36M (WS)",1.2000000000000002,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 15MB 36M (WS)",1.6,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 20MB 36M (WS)",2,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 25MB 36M (WS)",2.4,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 30MB 24M (WS)",2.8,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 35MB 36M (WS)",2.72,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 40MB 36M (WS)",2.8800000000000003,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 45MB 36M (WS)",3.1,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 50MB 36M (WS)",3.3000000000000003,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 55MB 36M (WS)",3.4800000000000004,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 60MB 36M (WS)",3.64,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 65MB 36M (WS)",3.7800000000000007,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 70MB 36M (WS)",3.9000000000000008,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 75MB 36M (WS)",4.08,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 80MB 36M (WS)",4.25,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 85MB 36M (WS)",4.5900000000000007,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 90MB 36M (WS)",4.7500000000000009,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 95MB 36M (WS)",4.9000000000000004,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 100MB 36M (WS)",5.04,"£0.10 per MB","N/A","N/A","N/A"]
[]
["DTFMASAB"]
["Anywhere Sim 1MB 24M (WS)",0.48000000000000004,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 10MB 24M (WS)",1.2000000000000002,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 15MB 24M (WS)",1.6,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 20MB 24M (WS)",2,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 25MB 24M (WS)",2.4,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 30MB 24M (WS)",2.8,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 35MB 24M (WS)",3.2,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 40MB 24M (WS)",3.5100000000000002,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 45MB 24M (WS)",3.8000000000000003,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 50MB 24M (WS)",4.07,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 55MB 24M (WS)",4.32,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 60MB 24M (WS)",4.5500000000000007,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 65MB 24M (WS)",4.7600000000000007,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 70MB 24M (WS)",4.9500000000000011,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 75MB 24M (WS)",5.12,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 80MB 24M (WS)",5.2700000000000005,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 85MB 24M (WS)",5.4,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 90MB 24M (WS)",5.6050000000000013,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 95MB 24M (WS)",5.8,"£0.10 per MB","N/A","N/A","N/A"]
["Anywhere Sim 100MB 24M (WS)",5.9850000000000003,"£0.10 per MB","N/A","N/A","N/A"]
[]
["DTFMTTAB"]
["TELE2UKROAM50MB",0.22216349999999974,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM100MB",0.44432699999999947,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM200MB",0.88865399999999983,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM300MB",1.3329810000000011,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM400MB",1.7773080000000006,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM500MB",2.221635,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM600MB",2.6659620000000013,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM700MB",3.1102890000000007,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM800MB",3.5546160000000002,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM900MB",3.9989429999999997,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM1GB",4.54990848,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UPROAM2GB",9.0998169600000018,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM3GB",13.649725440000001,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM4GB",18.19963392,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM5GB",22.749542399999999,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM6GB",27.299450880000002,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM7GB",31.849359359999998,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM8GB",36.399267840000007,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM9GB",40.949176319999999,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM10GB",45.499084800000006,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM20GB",90.998169600000011,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM30GB",136.49725439999997,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM50GB",227.49542400000001,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM100GB",454.99084800000003,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
["TELE2UKROAM200GB",909.98169600000017,"£20.00 per GB","N/A","N/A","DATE LTE SMS MT/MO-UK ONLY-2R V2-ZEST4"]
[]
["DTFMEESU"]
["EEUK1MB",0.72000000000000008,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK2MB",0.94399999999999995,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK3MB",1.2,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK5MB",1.6800000000000002,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK100MB",5.0720000000000001,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK500MB",7.3970000000000011,"£0.50 Per MB","N/A","N/A","N/A"]
["EEUK1GB",7.4359999999999999,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK2GB",9.9959999999999987,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK4GB",12.586,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK8GB",16.562000000000001,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK16GB",29.694000000000003,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK32GB",59.163999999999994,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK64GB",118.97199999999999,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK128GB",233.77199999999999,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK256GB",480.11599999999999,"£0.10 Per MB","N/A","N/A","N/A"]
["EEUK512GB",951.80400000000009,"£0.10 Per MB","N/A","N/A","N/A"]
[]
["DTFMVFVD"]
["VF V&D Aggregated 5MB 24M",1.75,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAO/013506"]
["VF V&D Aggregated 100MB 24M",3.3,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAS/013507"]
["VF V&D Aggregated 250MB 24M",5.75,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAT/013508"]
["VF V&D Aggregated 500MB 24M",9.1,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAU/013316"]
[]
["DTSMVFVD"]
["VF V&D Aggregated 5MB 36M",1.55,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAO/013506"]
["VF V&D Aggregated 100MB 36M",3.1,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAS/013507"]
["VF V&D Aggregated 250MB 36M",5.5,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAT/013508"]
["VF V&D Aggregated 500MB 36M",8.8000000000000007,"£0.8 per MB","£0.7 per Min","£0.15 per Text","VFAGAU/013316"]
[]
["DTFMZCUKR"]
["Arkessa Si Connect 1MB 24M",0.4,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 5MB 24M",0.6,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 10MB 24M",0.8,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 20MB 24M",1.2,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 30MB 24M",1.6,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 40MB 24M",2,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 50MB 24M",2.4,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 60MB 24M",2.8,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 70MB 24M",3.2,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 80MB 24M",3.6,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 90MB 24M",4,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 100MB 24M",4.5,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
[]
["DTSMZCUKR"]
["Arkessa Si Connect 1MB 36M",0.32,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 5MB 36M",0.48,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 10MB 36M",0.67,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 20MB 36M",1.05,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 30MB 36M",1.4,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 40MB 36M",1.8,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 50MB 36M",2.2000000000000002,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 60MB 36M",2.5499999999999998,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 70MB 36M",2.85,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 80MB 36M",3.2,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 90MB 36M",3.6,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
["Arkessa Si Connect 100MB 36M",3.99,"£0.1 per MB","n/a","n/a","ACSIAG1BF/013307"]
[]
["DTDAST"]
["Trial SIM",0,"n/a","n/a","n/a","N/A"]

{"sheet":"Smart Tracker Schedule","index":3,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,3,2,7],[7,4,7,8],[36,2,36,9],[32,2,34,9],[37,3,37,5],[31,2,31,9],[6,6,6,7],[4,6,4,7],[5,6,5,7],[43,3,43,5],[46,1,46,10],[41,6,43,6],[41,2,43,2],[44,3,44,5],[45,3,45,5],[43,7,43,9],[44,7,44,9],[45,7,45,9],[41,7,41,9],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,7,42,9],[42,3,42,5],[38,7,38,9],[39,7,39,9],[40,7,40,9]]}
[0,null,null,null,null,null,null,"Partner Name","Partner Contact Name","Partner Contact Email Address",null,null,null,null,"Select","Select","Select","Select","Select","Select","Select"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New","Y","Smartphone","Mini","Standard","Lower £180 / Upper £200","O2"]
[null,null,null,"M2M Smart Tracking Solutions"]
[null,null,null,"The Smart Tracking Service is a “Mobile M2M Service” and the M2M Mobile Terms and Mobile Equipment Terms will apply"]
[null,null,null,null,null,null,"Device Type",null,"No. Devices","Total One Off Upfront Cost                         "]
[null,null,null,null,null,null,"Tracker Device (£60 per Device)",null,0,{"$f":"I6*60","v":0}]
[null,null,null,null,null,null,"Smart Tracker Harness (£20 Per Harness)",null,0,{"$f":"I7*20","v":0}]
[null,null,null,null,"For assistance please call Customer Service on 0161 956 3300",null,null,null,null,null,null,null,null,null,null,null,null,"Novation","N","BIS","Micro","Heavy","Set to ignore","Gamma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iPhone","Nano","Opt-out"]
[null,null,"Conn Type","Device Serial Number","Customer Name","User Name/Code","Zest4 Tariff","Line Rental per month","Network Operator","Term",null,null,null,null,null,null,"Change of Tariff","Y"]
[null,1,"New",null,null,null,"Smart Tracking",{"$f":"IF(G11=\"Track & Go\",8.28,IF(G11=\"Smart Tracking\",14.33,0))","v":14.33},null,{"$f":"IF(G11=\"\",\"\",36)","v":36}]
[null,{"$f":"B11+1","v":2},"New",null,null,null,"Smart Tracking",{"$f":"IF(G12=\"Track & Go\",8.28,IF(G12=\"Smart Tracking\",14.33,0))","v":14.33},null,{"$f":"IF(G12=\"\",\"\",36)","v":36}]
[null,{"$f":"B12+1","v":3},"New",null,null,null,null,{"$f":"IF(G13=\"Track & Go\",8.28,IF(G13=\"Smart Tracking\",14.33,0))","v":0},null,{"$f":"IF(G13=\"\",\"\",36)","v":""}]
[null,4,"New",null,null,null,null,{"$f":"IF(G14=\"Track & Go\",8.28,IF(G14=\"Smart Tracking\",14.33,0))","v":0},null,{"$f":"IF(G14=\"\",\"\",36)","v":""}]
[null,5,"New",null,null,null,null,{"$f":"IF(G15=\"Track & Go\",8.28,IF(G15=\"Smart Tracking\",14.33,0))","v":0},null,{"$f":"IF(G15=\"\",\"\",36)","v":""}]
[null,{"$f":"B15+1","v":6},"New",null,null,null,null,{"$f":"IF(G16=\"Track & Go\",8.28,IF(G16=\"Smart Tracking\",14.33,0))","v":0},null,{"$f":"IF(G16=\"\",\"\",36)","v":""}]
[null,{"$f":"B16+1","v":7},"New",null,null,null,null,{"$f":"IF(G17=\"Track & Go\",8.28,IF(G17=\"Smart Tracking\",14.33,0))","v":0},null,{"$f":"IF(G17=\"\",\"\",36)","v":""}]
[null,{"$f":"B17+1","v":8},"New",null,null,null,null,0,null,{"$f":"IF(G18=\"\",\"\",36)","v":""}]
[null,{"$f":"B18+1","v":9},"New",null,null,null,null,0,null,{"$f":"IF(G19=\"\",\"\",36)","v":""}]
[null,{"$f":"B19+1","v":10},"New",null,null,null,null,0,null,{"$f":"IF(G20=\"\",\"\",36)","v":""}]
[null,{"$f":"B20+1","v":11},"New",null,null,null,null,0,null,{"$f":"IF(G21=\"\",\"\",36)","v":""}]
[null,{"$f":"B21+1","v":12},"New",null,null,null,null,0,null,{"$f":"IF(G22=\"\",\"\",36)","v":""}]
[null,{"$f":"B22+1","v":13},"New",null,null,null,null,0,null,{"$f":"IF(G23=\"\",\"\",36)","v":""}]
[null,{"$f":"B23+1","v":14},"New",null,null,null,null,0,null,{"$f":"IF(G24=\"\",\"\",36)","v":""}]
[null,{"$f":"B24+1","v":15},"New",null,null,null,null,0,null,{"$f":"IF(G25=\"\",\"\",36)","v":""}]
[null,{"$f":"B25+1","v":16},"New",null,null,null,null,0,null,{"$f":"IF(G26=\"\",\"\",36)","v":""}]
[null,{"$f":"B26+1","v":17},"New",null,null,null,null,0,null,{"$f":"IF(G27=\"\",\"\",36)","v":""}]
[null,{"$f":"B27+1","v":18},"New",null,null,null,null,0,null,{"$f":"IF(G28=\"\",\"\",36)","v":""}]
[null,{"$f":"B28+1","v":19},"New",null,null,null,null,0,null,{"$f":"IF(G29=\"\",\"\",36)","v":""}]
[null,{"$f":"B29+1","v":20},"New",null,null,null,null,0,null,{"$f":"IF(G30=\"\",\"\",36)","v":""}]
[null,null,"Please insert extra rows as required"]
[null,null,"Comments"]
[]
[]
[]
[]
[null,null,"Misc Details"]
[null,null,"Network","O2"]
[null,null,"Customer Acc No",null,null,null,"Contract Term",36]
[null,null,"Account Address",null,null,null,"Delivery Address"]
[null,null,"Name",null,null,null,"Delivery address"]
[null,null,"Address",null,null,null,"Address"]
[]
[]
[null,null,"Postcode",null,null,null,"Postcode"]
[null,null,"Tel",null,null,null,"Tel"]

{"sheet":"Standard M2M Terms","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}