{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Deal Builder","Internal Calc ","PDF Generator","New PDF","Resign Rules","Aggregated Data Rules","Conversion for PDF","Lookups","Drop Downs","Pricing"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":62,"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":"Instructions","index":0,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Instructions "]
[]
[]
["Please fill out the Mandatory boxes F3-F15 "]
["Network code will auto populate when a quantity is entered"]

{"sheet":"Deal Builder","index":1,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,3,0,16],[6,3,6,4],[6,5,6,6],[16,3,16,5],[30,3,30,5],[14,3,14,4],[2,3,2,4],[4,3,4,4],[4,5,4,6],[30,14,30,16]]}
[null,null,null,"Zest4 Deal Calculator v3.1.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(#REF!,\"YES\")+COUNTIF(#REF!,\"YES\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,"CBM Name: ",null,"Choose.."]
[]
[null,null,null,"Customer Name:"]
[]
[null,null,null,"Partner Name:"]
[]
[null,null,null,null,"Partner Code:"]
[]
[null,null,null,null,"Deal Reference:"]
[]
[null,null,null,null,"Contract Term (Months):","Choose.."]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Choose Your Tariff"]
[]
[]
[null,null,null,"Quantity ","Network ","CTN Type","Tariff Type","Tariff Decription ","Length of Contract (Months)","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding"]
[null,null,null,0,{"$f":"IF(D21<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D21=0),0,VLOOKUP($H21,Pricing!$A:$F,5,0))","v":0},0,{"$f":"J21+K21","v":0},{"$f":"L21*D21","v":0},0,{"$f":"N21*D21","v":0}]
[null,null,null,0,{"$f":"IF(D22<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D22=0),0,VLOOKUP($H22,Pricing!$A:$F,5,0))","v":0},0,{"$f":"J22+K22","v":0},{"$f":"L22*D22","v":0},0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D23=0),0,VLOOKUP($H23,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D24=0),0,VLOOKUP($H24,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D25=0),0,VLOOKUP($H25,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D26=0),0,VLOOKUP($H26,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D27=0),0,VLOOKUP($H27,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D28=0),0,VLOOKUP($H28,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[]
[]
[null,null,null,"Choose Your Bolt Ons "]
[]
[]
[null,null,null,"Quantity ","Network","CTN Type","Bolt On Type","Bolt On Description ","Length of Contract (Months)","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding"]
[null,null,null,0,{"$f":"IF(D35<>0,\"O2\",\"Choose..\")","v":"Choose.."},"Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D35=0),0,VLOOKUP($H35,Pricing!$A:$F,5,0))","v":0},0,{"$f":"J35+K35","v":0},{"$f":"L35*D35","v":0},0,{"$f":"N35*D35","v":0}]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D36=0),0,VLOOKUP($H36,Pricing!$A:$F,5,0))","v":0},0,{"$f":"J36+K36","v":0},0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D37=0),0,VLOOKUP($H37,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D38=0),0,VLOOKUP($H38,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D39=0),0,VLOOKUP($H39,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D40=0),0,VLOOKUP($H40,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D41=0),0,VLOOKUP($H41,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]
[null,null,null,0,"Choose..","Choose..","Choose..","Choose..",0,{"$f":"IF(OR($F$13=\"Choose…\",$D42=0),0,VLOOKUP($H42,Pricing!$A:$F,5,0))","v":0},0,0,0,0,0]

{"sheet":"Internal Calc ","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,7,28,10],[27,3,27,6],[28,3,28,6],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[11,0,11,1],[12,0,12,1],[5,0,5,1],[6,0,6,1],[26,0,26,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[20,0,20,1],[8,0,8,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[10,0,10,1],[0,0,0,11],[2,0,2,1],[3,0,3,1],[4,0,4,1],[7,0,7,1]]}
["Zest4 Deal Sheet"]
[]
["Partner name ",null,{"$f":"IF('Deal Builder'!F7=\"\",\"\",'Deal Builder'!F7)","v":""}]
["Partner Code",null,{"$f":"IF('Deal Builder'!F9=\"\",\"\",'Deal Builder'!F9)","v":""}]
["Customer name ",null,{"$f":"IF('Deal Builder'!F5=\"\",\"\",'Deal Builder'!F5)","v":""}]
["Total Voice Connections",null,{"$f":"IF(SUM('Deal Builder'!D21:D28)=0,\"\",SUM('Deal Builder'!D21:D28))","v":""}]
["Your Deal Reference",null,{"$f":"IF('Deal Builder'!F11=\"\",\"\",'Deal Builder'!F11)","v":""}]
["Estimated Customer Monthly Billing",null,{"$f":"I28","v":0}]
["Deal Profit",null,{"$f":"L28","v":0}]
[]
["Zygo billed rentals",null,"Tariff","Contract Length","Quantity","Buy Price Per Line Per Month","Mark Up/ Down","Sell Price Per Line Per Month","Total Sell Price Per Month","Funding Paid to Customer Per Line","Total Customer Funding","Total Gross Margin Over Term"]
["Tariff",null,{"$f":"IF('Deal Builder'!H21 =\"Choose..\",\"\",'Deal Builder'!H21)","v":""},{"$f":"'Deal Builder'!I21","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D21)","v":0},{"$f":"IFERROR('Deal Builder'!J21,0)","v":0},{"$f":"'Deal Builder'!K21","v":0},{"$f":"F12+G12","v":0},{"$f":"E12*H12","v":0},{"$f":"'Deal Builder'!N21","v":0},{"$f":"J12*E12","v":0},{"$f":"G12*E12*D12-K12","v":0},{"$f":"IFERROR(IF(FIND(\"AGG\",C12)>0,\"£1 per unit operation charge added to buy price\",\"\"),\"\")","v":""}]
["Tariff",null,{"$f":"IF('Deal Builder'!H22 =\"Choose..\",\"\",'Deal Builder'!H22)","v":""},{"$f":"'Deal Builder'!I22","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D22)","v":0},{"$f":"IFERROR('Deal Builder'!J22,0)","v":0},{"$f":"'Deal Builder'!K22","v":0},{"$f":"F13+G13","v":0},{"$f":"E13*H13","v":0},{"$f":"'Deal Builder'!N22","v":0},{"$f":"J13*E13","v":0},{"$f":"G13*E13*D13-K13","v":0},""]
["Tariff",null,{"$f":"IF('Deal Builder'!H23 =\"Choose..\",\"\",'Deal Builder'!H23)","v":""},{"$f":"'Deal Builder'!I23","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D23)","v":0},{"$f":"IFERROR('Deal Builder'!J23,0)","v":0},{"$f":"'Deal Builder'!K23","v":0},0,0,{"$f":"'Deal Builder'!N23","v":0},0,0,""]
["Tariff",null,{"$f":"IF('Deal Builder'!H24 =\"Choose..\",\"\",'Deal Builder'!H24)","v":""},{"$f":"'Deal Builder'!I24","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D24)","v":0},{"$f":"IFERROR('Deal Builder'!J24,0)","v":0},{"$f":"'Deal Builder'!K24","v":0},0,0,{"$f":"'Deal Builder'!N24","v":0},0,0,""]
["Tariff",null,{"$f":"IF('Deal Builder'!H25 =\"Choose..\",\"\",'Deal Builder'!H25)","v":""},{"$f":"'Deal Builder'!I25","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D25)","v":0},{"$f":"IFERROR('Deal Builder'!J25,0)","v":0},{"$f":"'Deal Builder'!K25","v":0},0,0,{"$f":"'Deal Builder'!N25","v":0},0,0,""]
["Tariff",null,{"$f":"IF('Deal Builder'!H26 =\"Choose..\",\"\",'Deal Builder'!H26)","v":""},{"$f":"'Deal Builder'!I26","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D26)","v":0},{"$f":"IFERROR('Deal Builder'!J26,0)","v":0},{"$f":"'Deal Builder'!K26","v":0},0,0,{"$f":"'Deal Builder'!N26","v":0},0,0,""]
["Tariff",null,{"$f":"IF('Deal Builder'!H27 =\"Choose..\",\"\",'Deal Builder'!H27)","v":""},{"$f":"'Deal Builder'!I27","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D27)","v":0},{"$f":"IFERROR('Deal Builder'!J27,0)","v":0},{"$f":"'Deal Builder'!K27","v":0},0,0,{"$f":"'Deal Builder'!N27","v":0},0,0,""]
["Tariff",null,{"$f":"IF('Deal Builder'!H28 =\"Choose..\",\"\",'Deal Builder'!H28)","v":""},{"$f":"'Deal Builder'!I28","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D28)","v":0},{"$f":"IFERROR('Deal Builder'!J28,0)","v":0},{"$f":"'Deal Builder'!K28","v":0},0,0,{"$f":"'Deal Builder'!N28","v":0},0,0,""]
["Bolt On",null,{"$f":"IF('Deal Builder'!H35=\"Choose..\",\"\",'Deal Builder'!H35)","v":""},{"$f":"'Deal Builder'!I35","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D35)","v":0},{"$f":"IFERROR('Deal Builder'!J35,0)","v":0},{"$f":"'Deal Builder'!K35","v":0},0,0,{"$f":"'Deal Builder'!N35","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H36=\"Choose..\",\"\",'Deal Builder'!H36)","v":""},{"$f":"'Deal Builder'!I36","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D36)","v":0},{"$f":"IFERROR('Deal Builder'!J36,0)","v":0},{"$f":"'Deal Builder'!K36","v":0},0,0,{"$f":"'Deal Builder'!N36","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H37=\"Choose..\",\"\",'Deal Builder'!H37)","v":""},{"$f":"'Deal Builder'!I37","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D37)","v":0},{"$f":"IFERROR('Deal Builder'!J37,0)","v":0},{"$f":"'Deal Builder'!K37","v":0},0,0,{"$f":"'Deal Builder'!N37","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H38=\"Choose..\",\"\",'Deal Builder'!H38)","v":""},{"$f":"'Deal Builder'!I38","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D38)","v":0},{"$f":"IFERROR('Deal Builder'!J38,0)","v":0},{"$f":"'Deal Builder'!K38","v":0},0,0,{"$f":"'Deal Builder'!N38","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H39=\"Choose..\",\"\",'Deal Builder'!H39)","v":""},{"$f":"'Deal Builder'!I39","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D39)","v":0},{"$f":"IFERROR('Deal Builder'!J39,0)","v":0},{"$f":"'Deal Builder'!K39","v":0},0,0,{"$f":"'Deal Builder'!N39","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H40=\"Choose..\",\"\",'Deal Builder'!H40)","v":""},{"$f":"'Deal Builder'!I40","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D40)","v":0},{"$f":"IFERROR('Deal Builder'!J40,0)","v":0},{"$f":"'Deal Builder'!K40","v":0},0,0,{"$f":"'Deal Builder'!N40","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H41=\"Choose..\",\"\",'Deal Builder'!H41)","v":""},{"$f":"'Deal Builder'!I41","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D41)","v":0},{"$f":"IFERROR('Deal Builder'!J41,0)","v":0},{"$f":"'Deal Builder'!K41","v":0},0,0,{"$f":"'Deal Builder'!N41","v":0},0,0]
["Bolt On",null,{"$f":"IF('Deal Builder'!H42=\"Choose..\",\"\",'Deal Builder'!H42)","v":""},{"$f":"'Deal Builder'!I42","v":0},{"$f":"IF($C$6=\"\",0,'Deal Builder'!D42)","v":0},{"$f":"IFERROR('Deal Builder'!J42,0)","v":0},{"$f":"'Deal Builder'!K42","v":0},0,0,{"$f":"'Deal Builder'!N42","v":0},0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H27)","v":0},{"$f":"SUM(I12:I27)","v":0},{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(K12:K27)","v":0},{"$f":"SUM(L12:L27)","v":0}]
[null,null,null,null,null,null,null,"Estimated Gross Margin Per Line",null,null,null,{"$f":"IFERROR(L28/C6,0)","v":0}]

{"sheet":"PDF Generator","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["Partner name ",{"$f":"'Internal Calc '!C3","v":""}]
["Partner Code",{"$f":"'Internal Calc '!C4","v":""}]
["Customer name ",{"$f":"'Internal Calc '!C5","v":""}]
["Total Voice Connections",{"$f":"'Internal Calc '!C6","v":""}]
["Your Deal Reference",{"$f":"'Internal Calc '!C7","v":""}]
["Estimated Customer Monthly Billing",{"$f":"'Internal Calc '!C8","v":0}]
["Bonuses on Month One",{"$f":"'Internal Calc '!#REF!","v":{"$error":"#REF!"}}]
[]
["Tariff","Quanitity","Total monthly cost","Funding ","Margin"]
[{"$f":"'Internal Calc '!C12","v":""},{"$f":"IF('Internal Calc '!E12=0,\"\",'Internal Calc '!E12)","v":""},{"$f":"IF('Internal Calc '!E12=0,\"\",'Internal Calc '!H12)","v":""},{"$f":"IF('Internal Calc '!E12=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E12=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C13","v":""},{"$f":"IF('Internal Calc '!E13=0,\"\",'Internal Calc '!E13)","v":""},{"$f":"IF('Internal Calc '!E13=0,\"\",'Internal Calc '!H13)","v":""},{"$f":"IF('Internal Calc '!E13=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E13=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"IF('Internal Calc '!E14=0,\"\",'Internal Calc '!E14)","v":""},{"$f":"IF('Internal Calc '!E14=0,\"\",'Internal Calc '!H14)","v":""},{"$f":"IF('Internal Calc '!E14=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E14=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"IF('Internal Calc '!E15=0,\"\",'Internal Calc '!E15)","v":""},{"$f":"IF('Internal Calc '!E15=0,\"\",'Internal Calc '!H15)","v":""},{"$f":"IF('Internal Calc '!E15=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E15=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"IF('Internal Calc '!E16=0,\"\",'Internal Calc '!E16)","v":""},{"$f":"IF('Internal Calc '!E16=0,\"\",'Internal Calc '!H16)","v":""},{"$f":"IF('Internal Calc '!E16=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E16=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"IF('Internal Calc '!E17=0,\"\",'Internal Calc '!E17)","v":""},{"$f":"IF('Internal Calc '!E17=0,\"\",'Internal Calc '!H17)","v":""},{"$f":"IF('Internal Calc '!E17=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E17=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"IF('Internal Calc '!E18=0,\"\",'Internal Calc '!E18)","v":""},{"$f":"IF('Internal Calc '!E18=0,\"\",'Internal Calc '!H18)","v":""},{"$f":"IF('Internal Calc '!E18=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E18=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"IF('Internal Calc '!E19=0,\"\",'Internal Calc '!E19)","v":""},{"$f":"IF('Internal Calc '!E19=0,\"\",'Internal Calc '!H19)","v":""},{"$f":"IF('Internal Calc '!E19=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E19=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"IF('Internal Calc '!E20=0,\"\",'Internal Calc '!E20)","v":""},{"$f":"IF('Internal Calc '!E20=0,\"\",'Internal Calc '!H20)","v":""},{"$f":"IF('Internal Calc '!E20=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E20=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"IF('Internal Calc '!E21=0,\"\",'Internal Calc '!E21)","v":""},{"$f":"IF('Internal Calc '!E21=0,\"\",'Internal Calc '!H21)","v":""},{"$f":"IF('Internal Calc '!E21=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E21=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"IF('Internal Calc '!E22=0,\"\",'Internal Calc '!E22)","v":""},{"$f":"IF('Internal Calc '!E22=0,\"\",'Internal Calc '!H22)","v":""},{"$f":"IF('Internal Calc '!E22=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E22=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"IF('Internal Calc '!E23=0,\"\",'Internal Calc '!E23)","v":""},{"$f":"IF('Internal Calc '!E23=0,\"\",'Internal Calc '!H23)","v":""},{"$f":"IF('Internal Calc '!E23=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E23=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"IF('Internal Calc '!E24=0,\"\",'Internal Calc '!E24)","v":""},{"$f":"IF('Internal Calc '!E24=0,\"\",'Internal Calc '!H24)","v":""},{"$f":"IF('Internal Calc '!E24=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E24=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"IF('Internal Calc '!E25=0,\"\",'Internal Calc '!E25)","v":""},{"$f":"IF('Internal Calc '!E25=0,\"\",'Internal Calc '!H25)","v":""},{"$f":"IF('Internal Calc '!E25=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E25=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"IF('Internal Calc '!E26=0,\"\",'Internal Calc '!E26)","v":""},{"$f":"IF('Internal Calc '!E26=0,\"\",'Internal Calc '!H26)","v":""},{"$f":"IF('Internal Calc '!E26=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E26=0,\"\",'Internal Calc '!#REF!)","v":""}]
[{"$f":"'Internal Calc '!C27","v":""},{"$f":"IF('Internal Calc '!E27=0,\"\",'Internal Calc '!E27)","v":""},{"$f":"IF('Internal Calc '!E27=0,\"\",'Internal Calc '!H27)","v":""},{"$f":"IF('Internal Calc '!E27=0,\"\",'Internal Calc '!#REF!)","v":""},{"$f":"IF('Internal Calc '!E27=0,\"\",'Internal Calc '!#REF!)","v":""}]

{"sheet":"New PDF","index":4,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,0,5,4],[32,0,32,4],[30,0,31,4]]}
[]
[]
[]
[]
[]
[{"$f":"\"Deal Summary For: \"&'Deal Builder'!F5","v":"Deal Summary For: "}]
[{"$f":"\"Partner Name: \"&'Deal Builder'!F7","v":"Partner Name: "},null,null,null,"ZES"]
[{"$f":"\"Contract Term: \"&'Deal Builder'!F13&IF('Deal Builder'!F13=1,\" Month\",\" Months\")","v":"Contract Term: Choose.. Months"},null,null,"Deal Reference:","ZES8882"]
[]
[]
[{"$f":"'Conversion for PDF'!I1","v":"Tariff"},{"$f":"'Conversion for PDF'!J1","v":"Quantity"},{"$f":"'Conversion for PDF'!K1","v":"Monthly Cost Per Line Per Month"},{"$f":"'Conversion for PDF'!L1","v":"Funding Per Line"},{"$f":"'Conversion for PDF'!M1","v":"Total Funding"}]
[{"$f":"'Conversion for PDF'!I2","v":""},{"$f":"'Conversion for PDF'!J2","v":""},{"$f":"'Conversion for PDF'!K2","v":""},{"$f":"'Conversion for PDF'!L2","v":""},{"$f":"'Conversion for PDF'!M2","v":""}]
[{"$f":"'Conversion for PDF'!I3","v":""},{"$f":"'Conversion for PDF'!J3","v":""},{"$f":"'Conversion for PDF'!K3","v":""},{"$f":"'Conversion for PDF'!L3","v":""},{"$f":"'Conversion for PDF'!M3","v":""}]
[{"$f":"'Conversion for PDF'!I4","v":""},{"$f":"'Conversion for PDF'!J4","v":""},{"$f":"'Conversion for PDF'!K4","v":""},{"$f":"'Conversion for PDF'!L4","v":""},{"$f":"'Conversion for PDF'!M4","v":""}]
[{"$f":"'Conversion for PDF'!I5","v":""},{"$f":"'Conversion for PDF'!J5","v":""},{"$f":"'Conversion for PDF'!K5","v":""},{"$f":"'Conversion for PDF'!L5","v":""},{"$f":"'Conversion for PDF'!M5","v":""}]
[{"$f":"'Conversion for PDF'!I6","v":""},{"$f":"'Conversion for PDF'!J6","v":""},{"$f":"'Conversion for PDF'!K6","v":""},{"$f":"'Conversion for PDF'!L6","v":""},{"$f":"'Conversion for PDF'!M6","v":""}]
[{"$f":"'Conversion for PDF'!I7","v":""},{"$f":"'Conversion for PDF'!J7","v":""},{"$f":"'Conversion for PDF'!K7","v":""},{"$f":"'Conversion for PDF'!L7","v":""},{"$f":"'Conversion for PDF'!M7","v":""}]
[{"$f":"'Conversion for PDF'!I8","v":""},{"$f":"'Conversion for PDF'!J8","v":""},{"$f":"'Conversion for PDF'!K8","v":""},{"$f":"'Conversion for PDF'!L8","v":""},{"$f":"'Conversion for PDF'!M8","v":""}]
[{"$f":"'Conversion for PDF'!I9","v":""},{"$f":"'Conversion for PDF'!J9","v":""},{"$f":"'Conversion for PDF'!K9","v":""},{"$f":"'Conversion for PDF'!L9","v":""},{"$f":"'Conversion for PDF'!M9","v":""}]
[{"$f":"'Conversion for PDF'!I10","v":""},{"$f":"'Conversion for PDF'!J10","v":""},{"$f":"'Conversion for PDF'!K10","v":""},{"$f":"'Conversion for PDF'!L10","v":""},{"$f":"'Conversion for PDF'!M10","v":""}]
[{"$f":"'Conversion for PDF'!I11","v":""},{"$f":"'Conversion for PDF'!J11","v":""},{"$f":"'Conversion for PDF'!K11","v":""},{"$f":"'Conversion for PDF'!L11","v":""},{"$f":"'Conversion for PDF'!M11","v":""}]
[{"$f":"'Conversion for PDF'!I12","v":""},{"$f":"'Conversion for PDF'!J12","v":""},{"$f":"'Conversion for PDF'!K12","v":""},{"$f":"'Conversion for PDF'!L12","v":""},{"$f":"'Conversion for PDF'!M12","v":""}]
[{"$f":"'Conversion for PDF'!I13","v":""},{"$f":"'Conversion for PDF'!J13","v":""},{"$f":"'Conversion for PDF'!K13","v":""},{"$f":"'Conversion for PDF'!L13","v":""},{"$f":"'Conversion for PDF'!M13","v":""}]
[{"$f":"'Conversion for PDF'!I14","v":""},{"$f":"'Conversion for PDF'!J14","v":""},{"$f":"'Conversion for PDF'!K14","v":""},{"$f":"'Conversion for PDF'!L14","v":""},{"$f":"'Conversion for PDF'!M14","v":""}]
[{"$f":"'Conversion for PDF'!I15","v":""},{"$f":"'Conversion for PDF'!J15","v":""},{"$f":"'Conversion for PDF'!K15","v":""},{"$f":"'Conversion for PDF'!L15","v":""},{"$f":"'Conversion for PDF'!M15","v":""}]
[{"$f":"'Conversion for PDF'!I16","v":""},{"$f":"'Conversion for PDF'!J16","v":""},{"$f":"'Conversion for PDF'!K16","v":""},{"$f":"'Conversion for PDF'!L16","v":""},{"$f":"'Conversion for PDF'!M16","v":""}]
[{"$f":"'Conversion for PDF'!I17","v":""},{"$f":"'Conversion for PDF'!J17","v":""},{"$f":"'Conversion for PDF'!K17","v":""},{"$f":"'Conversion for PDF'!L17","v":""},{"$f":"'Conversion for PDF'!M17","v":""}]
[{"$f":"'Conversion for PDF'!I18","v":""},{"$f":"'Conversion for PDF'!J18","v":""},{"$f":"'Conversion for PDF'!K18","v":""},{"$f":"'Conversion for PDF'!L18","v":""},{"$f":"'Conversion for PDF'!M18","v":""}]
[{"$f":"'Conversion for PDF'!I19","v":""},{"$f":"'Conversion for PDF'!J19","v":""},{"$f":"'Conversion for PDF'!K19","v":""},{"$f":"'Conversion for PDF'!L19","v":""},{"$f":"'Conversion for PDF'!M19","v":""}]
[{"$f":"'Conversion for PDF'!I20","v":""},{"$f":"'Conversion for PDF'!J20","v":""},{"$f":"'Conversion for PDF'!K20","v":""},{"$f":"'Conversion for PDF'!L20","v":""},{"$f":"'Conversion for PDF'!M20","v":""}]
["Above is your Personalised Quote based on the information that you have supplied and is valid for 30 days from the point that it is generated, Please note these charges are subject to change depending on your requirements. "]

{"sheet":"Resign Rules","index":5,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["Update MF 10/01/18"]
["I think there has been some confusion on rules around migrating to the new SIM only O2 plans – please see below the rules that need to be applied:"]
["1)      They must have served their initial contract term on either standard 24 month plans or current Sim only 30 day plans and pay a £30 migration fee. (No resign required)"]
["2)      If they wish to resign then they can move to one of the new plans ( standard early resign rules apply) and no migration fee is chargeable if they resign for a new term of 24 months (last 3 months of contract, 24 month extension)"]
["3)      If they wish to move from a current SIM only 24 month plan – they can migrate to a new SIM only 24 Month tariff if they pay the £30 migration fee.  If this is a large increase in revenue (Needs to be linked to O2 RRP not price we charge) the mig fee may be waived."]
["4)      If they want to move from a current bespoke tariff commercial approval is required."]
[]
["Resign Rules – ABS – February 2018"]
[]
["As we have now moved to ABS and are now allowing partners to access Wholesale rates, we need to put some rules around moving their existing base from RRP to Wholesale to protect our initial investment and expected revenue.  The various resign scenario’s and associated rules are outlined below:"]
[]
["Resigns moving from a RRP 24 Month Agreement to a 30 Day SIM Only Plan"]
["Partners can resign to a SIMO 30 Day plan 3 months before the end of the existing contract"]
["The number when resigned has the remainder of the existing contract still to serve and then has to give 30 days’ notice from that point."]
["If the number is out of contract, it is free to move to a 30 day SIM Only plan."]
[]
["Resigns moving from a RRP 24 Month Agreement to a 24 Month SIM Only Plan"]
["Partners can resign to a SIMO 24 Month plan 3 months before the end of the existing contract"]
["The number when resigned has the remainder of the existing contract still to serve and then has to give 30 days’ notice from that point."]
["If the number is out of contract, it is free to move to a 24 Month SIM Only plan."]
[]
["Resigns moving from an RRP 24 Month Agreement to a 24 Month Wholesale Tariff (not SIMO)"]
["Partners can resign numbers on RRP tariffs to the 24 Month Wholesale (not SIMO) tariffs 6 months early."]
["This gives partners an additional 10% in rentals as on existing base they get a 10% discount and on the new tariffs they get 50% discount."]
["We are comfortable with this as they are locking the customer back in for an additional 24 months."]
[]
["Resigns where a bespoke tariff is being created"]
["Commercial will review the proposed tariff and the timing left on the existing contract before proposing a resign plan."]
[]
["Update on moving to new June 2018 Tariffs – Mandy email Tuesday 10th"]
[]
["I think there has been some confusion on rules around migrating to the new SIM only O2 plans – please see below the rules that need to be applied:"]
[]
["5)      They must have served their initial contract term on either standard 24 month plans or current Sim only 30 day plans and pay a £30 migration fee. (No resign required)"]
["6)      If they wish to resign then they can move to one of the new plans ( standard early resign rules apply) and no migration fee is chargeable if they resign for a new term of 24 months (last 3 months of contract, 24 month extension)"]
["7)      If they wish to move from a current SIM only 24 month plan – they can migrate to a new SIM only 24 Month tariff if they pay the £30 migration fee.  If this is a large increase in revenue (Needs to be linked to O2 RRP not price we charge) the mig fee may be waived."]
["8)      If they want to move from a current bespoke tariff commercial approval is required."]

{"sheet":"Aggregated Data Rules","index":6,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Aggregating Small Biz Sim Only Tariffs to avoid bill shock."]
["To give you the ability to compete with other offerings in the market we want to make available the option to build bespoke deals around using small biz tariffs and stacking them to create shared data bundles."]
["This is not a simple offering in the background and it presents some operational and commercial challenges.  We therefore need to have rules in place as to where and how this is offered and a clear process to ensure it is delivered to the customer/reseller correctly and declared to O2 correctly."]
["The rules are outlined below:"]
["1)      You need to get commercial sign off for each stackable shared biz opportunity"]
["2)      We will only offer this tariff for 50 users or over (amended to 20)"]
["3)      All users must be on the same small biz tariff – there are no mix and match options available e.g. all users on Small Biz 2GB"]
["4)      These tariffs are available for new / mig only"]
["5)      It is expected that these will be sold on a 24 month term"]
["6)      Each user is charged £2 RRP, £1 Reseller rate extra on top of the tariff base price per month for sharing the data.  This extra £2/1 rental is not counted towards GP as it is to cover the additional data declarations we may need to declare to O2 if an individual user goes over their data allowance"]
["7)      No top ups are available on these tariffs.  Once the shared bundle has been utilised, the group is charged overage. They can tariff migrate up a tariff but the whole group would need to tariff migrate up."]
["8)      A new tariff needs to be built each time for each individual group so we need a key identifier from the reseller to identify the group – e.g. company name to tag the group users together"]
["9)      We will allow up to 25% organic growth to a group and this will be part of the quotation terms.  This is to prevent resellers creating a big group of multiple customers all maxing out the data – this sill not be commercially viable for us."]
["10)   A quotation will be issued from the commercial team upon approval of the deal, this must be issued to the reseller as the basis of the bespoke tariff so that they understand the terms when they place an order."]
[]
["The Process – 4-5 working days"]
["1)      Submit a bespoke tariff request to the commercial team (this carries a 1-2 day SLA)"]
["2)      The commercial team on approval will issue you with a quote which you should send to your partner."]
["3)      As this is a bespoke tariff the partner needs to give you notice of when they wish to connect the deal."]
["4)      Once you get notice from the partner, submit the bespoke tariff request into the billing team and they will build the tariff within 2 days, make the tariff available on the portal and let you know the code for the tariff for this group."]
["5)      You let the partner know that the tariff is available and the group tariff code they need to select on the portal"]
["6)      Partner places the order and everyone knows what’s happening,"]
["Happy days!"]

{"sheet":"Conversion for PDF","index":7,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Tariff","Quantity","Monthly Cost Per Line Per Month","Total Cost Per Month","Funding Per Line","Total Funding",null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A1))),\"\")","v":"Tariff"},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B1))),\"\")","v":"Quantity"},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C1))),\"\")","v":"Monthly Cost Per Line Per Month"},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E1))),\"\")","v":"Funding Per Line"},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F1))),\"\")","v":"Total Funding"}]
[{"$f":"'Internal Calc '!C12","v":""},{"$f":"'Internal Calc '!E12","v":0},{"$f":"'Deal Builder'!L21","v":0},{"$f":"C2*B2","v":0},{"$f":"'Deal Builder'!N21","v":0},{"$f":"E2*B2","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A2))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B2))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C2))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E2))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F2))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C13","v":""},{"$f":"'Internal Calc '!E13","v":0},{"$f":"'Deal Builder'!L22","v":0},{"$f":"C3*B3","v":0},{"$f":"'Deal Builder'!N22","v":0},{"$f":"E3*B3","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A3))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B3))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C3))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E3))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F3))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C14","v":""},{"$f":"'Internal Calc '!E14","v":0},{"$f":"'Deal Builder'!L23","v":0},0,{"$f":"'Deal Builder'!N23","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A4))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B4))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C4))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E4))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F4))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C15","v":""},{"$f":"'Internal Calc '!E15","v":0},{"$f":"'Deal Builder'!L24","v":0},0,{"$f":"'Deal Builder'!N24","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B5))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C5))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E5))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F5))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C16","v":""},{"$f":"'Internal Calc '!E16","v":0},{"$f":"'Deal Builder'!L25","v":0},0,{"$f":"'Deal Builder'!N25","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B6))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C6))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E6))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F6))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C17","v":""},{"$f":"'Internal Calc '!E17","v":0},{"$f":"'Deal Builder'!L26","v":0},0,{"$f":"'Deal Builder'!N26","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B7))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C7))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E7))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F7))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C18","v":""},{"$f":"'Internal Calc '!E18","v":0},{"$f":"'Deal Builder'!L27","v":0},0,{"$f":"'Deal Builder'!N27","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B8))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C8))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E8))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F8))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C19","v":""},{"$f":"'Internal Calc '!E19","v":0},{"$f":"'Deal Builder'!L28","v":0},0,{"$f":"'Deal Builder'!N28","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B9))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C9))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E9))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F9))),\"\")","v":""}]
[{"$f":"IF(B10=0,\"\",\"Total\")","v":""},{"$f":"SUM(B2:B9)","v":0},{"$f":"SUM(C2:C9)","v":0},{"$f":"SUM(D2:D9)","v":0},0,0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B10))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E10))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F10))),\"\")","v":""}]
[{"$f":"IF(SUM(B12:B19)=0,\"\",\"Bolt Ons\")","v":""},"Quantity","Monthly Cost Per Line Per Month","Total Cost Per Month","Funding Per Line","Total Funding",null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B11))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E11))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F11))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C20","v":""},{"$f":"'Internal Calc '!E20","v":0},{"$f":"'Deal Builder'!L35","v":0},{"$f":"C12*B12","v":0},{"$f":"'Deal Builder'!N35","v":0},{"$f":"E12*B12","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B12))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E12))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F12))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C21","v":""},{"$f":"'Internal Calc '!E21","v":0},{"$f":"'Deal Builder'!L36","v":0},0,{"$f":"'Deal Builder'!N36","v":0},{"$f":"E13*B13","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B13))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E13))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F13))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C22","v":""},{"$f":"'Internal Calc '!E22","v":0},{"$f":"'Deal Builder'!L37","v":0},0,{"$f":"'Deal Builder'!N37","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B14))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E14))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F14))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C23","v":""},{"$f":"'Internal Calc '!E23","v":0},{"$f":"'Deal Builder'!L38","v":0},0,{"$f":"'Deal Builder'!N38","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B15))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C15))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E15))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F15))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C24","v":""},{"$f":"'Internal Calc '!E24","v":0},{"$f":"'Deal Builder'!L39","v":0},0,{"$f":"'Deal Builder'!N39","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B16))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C16))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E16))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F16))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C25","v":""},{"$f":"'Internal Calc '!E25","v":0},{"$f":"'Deal Builder'!L40","v":0},0,{"$f":"'Deal Builder'!N40","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A17))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B17))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C17))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E17))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F17))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C26","v":""},{"$f":"'Internal Calc '!E26","v":0},{"$f":"'Deal Builder'!L41","v":0},0,{"$f":"'Deal Builder'!N41","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A18))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B18))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C18))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E18))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F18))),\"\")","v":""}]
[{"$f":"'Internal Calc '!C27","v":""},{"$f":"'Internal Calc '!E27","v":0},{"$f":"'Deal Builder'!L42","v":0},0,{"$f":"'Deal Builder'!N42","v":0},0,null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A19))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B19))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C19))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E19))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F19))),\"\")","v":""}]
[{"$f":"IF(B20=0,\"\",\"Total\")","v":""},{"$f":"SUM(B12:B19)","v":0},{"$f":"'Deal Builder'!L43","v":0},0,{"$f":"'Deal Builder'!N43","v":0},{"$f":"SUM(F12:F19)","v":0},null,null,{"$f":"IFERROR(INDEX(A$1:A$20,SMALL(IF($A$1:$A$20<>\"\",ROW(A$1:A$20)-ROW(A$1)+1),ROWS(A$1:A20))),\"\")","v":""},{"$f":"IFERROR(INDEX(B$1:B$20,SMALL(IF($A$1:$A$20<>\"\",ROW(B$1:B$20)-ROW(B$1)+1),ROWS(B$1:B20))),\"\")","v":""},{"$f":"IFERROR(INDEX(C$1:C$20,SMALL(IF($A$1:$A$20<>\"\",ROW(C$1:C$20)-ROW(C$1)+1),ROWS(C$1:C20))),\"\")","v":""},{"$f":"IFERROR(INDEX(E$1:E$20,SMALL(IF($A$1:$A$20<>\"\",ROW(E$1:E$20)-ROW(E$1)+1),ROWS(E$1:E20))),\"\")","v":""},{"$f":"IFERROR(INDEX(F$1:F$20,SMALL(IF($A$1:$A$20<>\"\",ROW(F$1:F$20)-ROW(F$1)+1),ROWS(F$1:F20))),\"\")","v":""}]

{"sheet":"Lookups","index":8,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Cell Reference"]
[]
[null,1,"onetariff",null,null,"1Sim Only Single User","tsosu",null,1,"One",null,"O2","otwo",null,"Small Biz Shared Data","sbsd"]
[null,12,"twelvetariff",null,null,"1Mobile Broadband","tmbb",null,12,"Twelve",null,"Vodafone","vodafone",null,"Shared Minutes","sm"]
[null,24,"twentyfourtariff",null,null,"24Sim Only Single User","tfsosu",null,24,"Twenty",null,null,null,null,"Shared Texts","st"]
[null,null,null,null,null,"24Single User","tfsu",null,null,null,null,null,null,null,"Individual Data","id"]
[null,null,null,null,null,"24Business Single Shared Data","tfbssd",null,null,null,null,null,null,null,"Shared Data","sd"]
[null,null,null,null,null,"24Parent","tfp",null,null,null,null,null,null,null,"Individual Topup","it"]
[null,null,null,null,null,"24Child","tfc",null,null,null,null,null,null,null,"UK Data Bolt On","ukdbo"]
[null,null,null,null,null,"24Mobile Broadband","tfmbb",null,null,null,null,null,null,null,"Roaming Data Bolt-ons","rdbo"]
[null,null,null,null,null,"1Single","os",null,null,null,null,null,null,null,"Roam & International Min Bolt ons","rimbo"]
[null,null,null,null,null,"1MBB","osmbb",null,null,null,null,null,null,null,"UK to Abroad Text Bolt-ons","uatbo"]
[null,null,null,null,null,"1Flex","oflex",null,null,null,null,null,null,null,"Roaming Data","rd"]
[null,null,null,null,null,"24Flex","tflex",null,null,null,null,null,null,null,"ROW Minutes","rowm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"International Caller","ic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared International Caller","sic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NGN Min Bolt ons","nmbo"]

{"sheet":"Drop Downs","index":9,"n_rows":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Cell Reference"]
["Name Ref","TermLength","onetariffNetwork","twelvetariffNetwork","twentyfourtariffNetwork","Vodafoneonetariff","oflex","tflex","O2onetariff","O2twentyfourtariff","tsosu","tmbb","tfsosu","tfmbb","tfmbbag","os","osmbb","Twentyotwobo","Twelveotwobo/Oneotwobo","Onevodafonebo/Twelvevodfonebo/Twentyvodafonebo","sbsd","id","it","rdbo","rimbo","uatbo","nmbo","rd","rowm","ic","CBMName"]
[]
[null,"Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose..","Choose.."]
[null,1,"O2","O2","O2","Single","Flex 30D WS","Flex 24M WS","Sim Only Single User","Sim Only Single User","Small Biz 300MB 30D WS","Mobile Broadband 1GB 30D","Small Biz 300MB 24M WS","Mobile Broadband 1GB 24M","Mobile Broadband 2GB Agg 24M","Forever Connected 500","2GB","Roaming Data","Roaming Data","UK Data Bolt On","Shared Data 5GB Wholesale 24M","Individual 500MB Wholesale Data Bolt on 24M","Individual 500MB Wholesale Data Top Up","250MB World Data","International Caller**","100 International SMS","100 Non Geo Mins","ROW Data 500MB (WS)","ROW 250 mins","Int. Caller 120 Mins","Ian Davis "]
[null,24,null,null,null,"MBB",null,null,"Flex","Flex","Small Biz 500MB 30D WS","Mobile Broadband 2GB 30D","Small Biz 500MB 24M WS","Mobile Broadband 2GB 24M","Mobile Broadband 4GB Agg 24M","Forever Connected","5GB","ROW Minutes","ROW Minutes","Roaming Data Bolt-ons","Shared Data 10GB Wholesale 24M","Individual 1GB Wholesale Data Bolt on 24M","Individual 1GB Wholesale Data Top Up","500MB World Data","100 mins UK - EU","250 International SMS","300 Non Geo Mins","ROW Data 1GB (WS)","ROW 500 mins","Int. Caller 500 Mins","Rob Foster"]
[null,null,null,null,null,null,null,null,"Mobile Broadband","Mobile Broadband","Small Biz 2GB 30D WS","Mobile Broadband 4GB 30D","Small Biz 2GB 24M WS","Mobile Broadband 4GB 24M","Mobile Broadband 8GB Agg 24M","Forever Connected 3GB","10GB","International Caller","International Caller","Roam & International Min Bolt ons","Shared Data 20GB Wholesale 24M","Individual 2GB Wholesale Data Bolt on 24M","Individual 2GB Wholesale Data Top Up","1GB World Data","500 mins UK - EU","500 International SMS",null,null,null,null,"Anton Le Saux"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 3GB 30D WS","Mobile Broadband 8GB 30D","Small Biz 3GB 24M WS","Mobile Broadband 8GB 24M","Mobile Broadband 20GB Agg 24M","Forever Connected 5GB","20GB",null,null,"UK to Abroad Text Bolt-ons","Shared Data 30GB Wholesale 24M","Individual 5GB Wholesale Data Bolt on 24M","Individual 5GB Wholesale Data Top Up",null,"1000 mins UK - EU","1000 International SMS",null,null,null,null,"Ben Ofosu"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 5GB 30D WS","Mobile Broadband 20GB 30D","Small Biz 5GB 24M WS","Mobile Broadband 20GB 24M","Mobile Broadband 30GB Agg 24M","Forever Connected 10GB","40GB",null,null,"NGN Min Bolt ons","Shared Data 40GB Wholesale 24M","Individual 8GB Wholesale Data Bolt on 24M","Individual 8GB Wholesale Data Top Up",null,"100 mins UK - World",null,null,null,null,null,"Jon Reynolds"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 8GB 30D WS","Mobile Broadband 30GB 30D","Small Biz 8GB 24M WS","Mobile Broadband 30GB 24M",null,"Forever Connected 20GB","50GB",null,null,null,"Shared Data 50GB Wholesale 24M",null,null,null,"500 mins UK - World",null,null,null,null,null,"Gemma Stopford"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 16GB 30D WS",null,"Small Biz 16GB 24M WS",null,null,null,"5GB UK + 250MB Worldwide",null,null,null,"Shared Data 75GB Wholesale 24M",null,null,null,"1000 mins UK - World",null,null,null,null,null,"Adam Williams"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 24GB 30D WS",null,"Small Biz 24GB 24M WS",null,null,null,null,null,null,null,"Shared Data 100GB Wholesale 24M",null,null,null,"100 mins Roam World"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 32GB 30D WS",null,"Small Biz 32GB 24M WS",null,null,null,null,null,null,null,"Shared Data 150GB Wholesale 24M",null,null,null,"250 mins Roam World"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 50GB 30D WS",null,"Small Biz 50GB 24M WS",null,null,null,null,null,null,null,"Shared Data 200GB Wholesale 24M",null,null,null,"500 mins Roam World"]
[null,null,null,null,null,null,null,null,null,null,"Small Biz 100GB 30D WS Promo",null,"Small Biz 100GB 24M WS Promo"]

{"sheet":"Pricing","index":10,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":true,"merged":[]}
["Tariff","Data","Term",null,"Standard Sell",null,"Overage Revenue"]
["Small Biz 300MB 30D WS","300MB","30D",null,5.7,null,3.25]
["Small Biz 500MB 30D WS","500MB","30D",null,6.9,null,3.25]
["Small Biz 2GB 30D WS","2GB","30D",null,8.5,null,3.25]
["Small Biz 3GB 30D WS","3GB","30D",null,8.5,null,3.25]
["Small Biz 5GB 30D WS","5GB","30D",null,9.5,null,3.25]
["Small Biz 8GB 30D WS","8GB","30D",null,10.5,null,3.25]
["Small Biz 16GB 30D WS","16GB","30D",null,11.25,null,3.25]
["Small Biz 24GB 30D WS","24GB","30D",null,12,null,3.25]
["Small Biz 32GB 30D WS","32GB","30D",null,12.5,null,3.25]
["Small Biz 50GB 30D WS","50GB","30D",null,16,null,3.25]
["Small Biz 100GB 30D WS Promo","100GB","30D",null,23,null,3.25]
["Small Biz 300MB 24M WS","300MB","24M",null,5,null,3.25]
["Small Biz 500MB 24M WS","500MB","24M",null,6,null,3.25]
["Small Biz 2GB 24M WS","2GB","24M",null,6.75,null,3.25]
["Small Biz 3GB 24M WS","3GB","24M",null,6.75,null,3.25]
["Small Biz 5GB 24M WS","5GB","24M",null,7.5,null,3.25]
["Small Biz 8GB 24M WS","8GB","24M",null,8.5,null,3.25]
["Small Biz 16GB 24M WS","16GB","24M",null,9.75,null,3.25]
["Small Biz 24GB 24M WS","24GB","24M",null,10.75,null,3.25]
["Small Biz 32GB 24M WS","32GB","24M",null,11.5,null,3.25]
["Small Biz 50GB 24M WS","50GB","24M",null,13.5,null,3.25]
["Small Biz 100GB 24M WS Promo","100GB","24M",null,20,null,3.25]
["Small Biz 500MB Agg 30D WS","500MB","30D",null,7.9,null,2]
["Small Biz 2GB Agg 30D WS","2GB","30D",null,9.5,null,2]
["Small Biz 3GB Agg 30D WS","3GB","30D",null,9.5,null,2]
["Small Biz 5GB Agg 30D WS","5GB","30D",null,10.5,null,2]
["Small Biz 8GB Agg 30D WS","8GB","30D",null,11.5,null,2]
["Small Biz 16GB Agg 30D WS","16GB","30D",null,12.25,null,2]
["Small Biz 24GB Agg 30D WS","24GB","30D",null,13,null,2]
["Small Biz 32GB Agg 30D WS","32GB","30D",null,13.5,null,2]
["Small Biz 500MB Agg 24M WS","500MB","24M",null,7,null,2]
["Small Biz 2GB Agg 24M WS","2GB","24M",null,7.75,null,2]
["Small Biz 3GB Agg 24M WS","3GB","24M",null,7.75,null,2]
["Small Biz 5GB Agg 24M WS","5GB","24M",null,8.5,null,2]
["Small Biz 8GB Agg 24M WS","8GB","24M",null,9.5,null,2]
["Small Biz 16GB Agg 24M WS","16GB","24M",null,10.75,null,2]
["Small Biz 24GB Agg 24M WS","24GB","24M",null,11.75,null,2]
["Small Biz 32GB Agg 24M WS","32GB","24M",null,12.5,null,2]
["Mobile Broadband 1GB 30D","1GB","30D",null,5.7,null,1]
["Mobile Broadband 2GB 30D","2GB","30D",null,6.6,null,1]
["Mobile Broadband 4GB 30D","4GB","30D",null,8.4,null,1]
["Mobile Broadband 8GB 30D","8GB","30D",null,10.199999999999999,null,1]
["Mobile Broadband 20GB 30D","20GB","30D",null,12.1,null,1]
["Mobile Broadband 30GB 30D","30GB","30D",null,14.85,null,1]
["Mobile Broadband 1GB 24M","1GB","24M",null,4.75,null,1]
["Mobile Broadband 2GB 24M","2GB","24M",null,5.5,null,1]
["Mobile Broadband 4GB 24M","4GB","24M",null,7,null,1]
["Mobile Broadband 8GB 24M","8GB","24M",null,8.5,null,1]
["Mobile Broadband 20GB 24M","20GB","24M",null,11,null,1]
["Mobile Broadband 30GB 24M","30GB","24M",null,13.5,null,1]
["Mobile Broadband 1GB Agg 30D","1GB","30D",null,6.7,null,1]
["Mobile Broadband 2GB Agg 30D","2GB","30D",null,7.6,null,1]
["Mobile Broadband 4GB Agg 30D","4GB","30D",null,9.4,null,1]
["Mobile Broadband 8GB Agg 30D","8GB","30D",null,11.2,null,1]
["Mobile Broadband 20GB Agg 30D","20GB","30D",null,13.1,null,1]
["Mobile Broadband 30GB Agg 30D","30GB","30D",null,15.85,null,1]
["Mobile Broadband 1GB Agg 24M","1GB","24M",null,5.75,null,1]
["Mobile Broadband 2GB Agg 24M","2GB","24M",null,6.5,null,1]
["Mobile Broadband 4GB Agg 24M","4GB","24M",null,8,null,1]
["Mobile Broadband 8GB Agg 24M","8GB","24M",null,9.5,null,1]
["Mobile Broadband 20GB Agg 24M","20GB","24M",null,12,null,1]
["Mobile Broadband 30GB Agg 24M","30GB","24M",null,14.5,null,1]
["Flex 30D WS","0GB","30D",null,5.5,null,3.25]
["Flex 24M WS","0GB","24M",null,5.5,null,3.25]
["Bolt Ons","Data","Term",null,"Standard Sell",null,"Overage Revenue"]
["Individual 500MB Wholesale Data Bolt on 24M",null,null,null,2.5]
["Individual 1GB Wholesale Data Bolt on 24M",null,null,null,4.18]
["Individual 2GB Wholesale Data Bolt on 24M",null,null,null,5.415]
["Individual 5GB Wholesale Data Bolt on 24M",null,null,null,8.3450000000000006]
["Individual 8GB Wholesale Data Bolt on 24M",null,null,null,10.425000000000001]
["Individual 500MB Wholesale Data Top Up",null,null,null,2.5]
["Individual 1GB Wholesale Data Top Up",null,null,null,4.1749999999999998]
["Individual 2GB Wholesale Data Top Up",null,null,null,5.415]
["Individual 5GB Wholesale Data Top Up",null,null,null,8.3450000000000006]
["Individual 8GB Wholesale Data Top Up",null,null,null,10.425000000000001]
["250MB World Data",null,null,null,20]
["500MB World Data",null,null,null,38]
["1GB World Data",null,null,null,75]
["International Caller**",null,null,null,3]
["100 mins UK - EU",null,null,null,3]
["500 mins UK - EU",null,null,null,7.5]
["1000 mins UK - EU",null,null,null,10]
["100 mins UK - World",null,null,null,20]
["500 mins UK - World",null,null,null,80]
["1000 mins UK - World",null,null,null,156]
["100 mins Roam World",null,null,null,30]
["250 mins Roam World",null,null,null,80]
["500 mins Roam World",null,null,null,155]
["100 International SMS",null,null,null,2]
["250 International SMS",null,null,null,5]
["500 International SMS",null,null,null,10]
["1000 International SMS",null,null,null,20]
["100 Non Geo Mins",null,null,null,3]
["300 Non Geo Mins",null,null,null,5]
["ROW Data 500MB (WS)",null,null,null,38]
["ROW Data 1GB (WS)",null,null,null,75]
["ROW 250 mins",null,null,null,80]
["ROW 500 mins",null,null,null,155]
["Int. Caller 120 Mins",null,null,null,4.5]
["Int. Caller 500 Mins",null,null,null,13.5]
["Shared Data 5GB Wholesale 24M",null,null,null,15]
["Shared Data 10GB Wholesale 24M",null,null,null,30]
["Shared Data 20GB Wholesale 24M",null,null,null,60]
["Shared Data 30GB Wholesale 24M",null,null,null,90]
["Shared Data 40GB Wholesale 24M",null,null,null,120]
["Shared Data 50GB Wholesale 24M",null,null,null,150]
["Shared Data 75GB Wholesale 24M",null,null,null,225]
["Shared Data 100GB Wholesale 24M",null,null,null,300]
["Shared Data 150GB Wholesale 24M",null,null,null,450]
["Shared Data 200GB Wholesale 24M",null,null,null,600]