{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Numericable","Telenet","Voo","Offers","Overview","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":3,"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":"Cover","index":0,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"CRC : Retails Minus tariffs for cable wholesale access"]
[]
[null,null,"Annex to the CRC communication of 11/12/2013 concerning setting wholesale access prices to cable networks. "]
[]
[null,null,"This file is an annexe to the CRC communication of 11/12/2013. The purpose of this file is to present in details the calculations for setting wholesale access prices to cable networks based on retail offers from cable operators and minus values from the CRC decisions. "]
[]
[null,null,"Usage : (1) select some operator's sheet, (2) fill in or update green tables if needed, (3) select retail offer in cell C52. The wholesale tariff is then computed in the orange table, the result is given in cell D98."]
[null,null,"The \"Overview\" sheets makes an overview of all different offers for each operator. The button on the bottom of the sheet runs a macro that computes the tariffs for each offer and updates the overview table."]
[]
[null,"Version : ","1.0"]
[null,"Date : ","2013-12-11"]
[]
[]
[null,"Minus Values :"]
[null,null,"Numericable"]
[null,"Analog TV :",0.2]
[null,"Digital TV :",0.2]
[null,"Pack :",0.2]
[null,null,"Telenet"]
[null,"Analog TV :",0.3]
[null,"Digital TV :",0.3]
[null,"Pack :",0.23]
[null,null,"Voo"]
[null,"Analog TV :",0.3]
[null,"Digital TV :",0.3]
[null,"Pack :",0.23]
[null,null,"Source : CRC Decision of 11/12/2013"]
[]
[null,"Contacts :"]
[null,null,"CSA"]
[null,null,"Boulevard de l'Impératrice, 13"]
[null,null,"B - 1000 Bruxelles"]
[null,null,"http://www.csa.be"]
[]
[null,null,"Bernardo Herman, directeur service \"distributeurs et opérateurs\""]
[null,null,"Tel. +32 2 349 58 83"]
[null,null,"Fax. +32 2 349 58 97"]
[null,null,"E-Mail : bernardo.herman@csa.be"]
[]
[null,null,"Julien Jost, conseiller service \"distributeurs et opérateurs\""]
[null,null,"Tel. +32 2 349 58 70"]
[null,null,"Fax. +32 2 349 58 97"]
[null,null,"E-Mail : julien.jost@csa.be"]

{"sheet":"Numericable","index":1,"n_rows":98,"n_cols":25,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,12,2,13],[2,14,2,17],[2,18,2,20],[2,21,2,22]]}
["Numericable"]
[]
["Retail offers :",null,null,null,null,null,null,null,null,null,"Offer characteristics :",null,"Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
[null,"Id.","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Link","Legend :","Label / Name",null,"Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[null,{"$f":"IF(C5<>\"-\",1,\"\")","v":1},"Télédistribution","Analog TV",17.809999999999999,{"$f":"IF(E5<>\"\",E5/1.21,\"\")","v":14.71900826446281},null,"Link",null,"Computation",null,{"$f":"C5","v":"Télédistribution"},"X",25,"-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(C6<>\"-\",B5+1,\"\")","v":2},"TV Plus (digital)","Digital TV",{"$f":"21.9+6","v":27.9},{"$f":"IF(E6<>\"\",E6/1.21,\"\")","v":23.057851239669422},"Incl. HD Decoder (6€)","Link",null,"Required Input",null,{"$f":"C6","v":"TV Plus (digital)"},"X",25,"X",130,17,"HD/HDD","-","-","-","-","-","-"]
[null,3,"Duo TV+Web","Dual play",39.9,32.97520661157025,"TV Start + décodeur HD PVR + BB50M 100G","Link",null,"Optional Input",null,"Duo TV+Web","X",25,"X",100,12,"HD/HDD","X","50M/2.5M","100G","-","-","-"]
[null,4,"Triple Play Extra","Triple play",55.9,46.198347107438018,"TV Plus + Tél. extra & voisins + BB 100M illimité + Box 160","Link",null,"Selection",null,"Triple Play Extra","X",25,"X",130,17,"Box 160 + HD","X","100M/5M","Illimité","X","Extra + Voisins","-"]
[null,5,"Triple Play Max","Triple play",69.900000000000006,57.768595041322321,"TV Plus & Bouquet Premium + Tél. extra & monde + BB 200M illimité + Box 320","Link",null,"Output",null,"Triple Play Max","X",25,"X",130,17,"Box 320 + HD","X","200M/8M","Illimité","X","Extra + Monde","Mini Premium"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,null,null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,null,null,null,null,null,null,"-"]
[null,null,"This table includes retail offers that are used as starting point for setting wholesale prices."]
["Standalone components :",null,null,null,null,null,null,null,null,null,null,"Packs composition :","This table maps \"packed\" retail offers to standalone components. "]
[null,"Id. ","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Discount","Excluded","Link",null,null,{"$f":"TRANSPOSE(C5:C16)","v":"Télédistribution"},"TV Plus (digital)","Duo TV+Web","Triple Play Extra","Triple Play Max","-","-","-","-","-","-","-"]
[null,{"$f":"IF(C20<>\"-\",1,\"\")","v":1},"Cable access (rights incl.)","Analog TV",17.809999999999999,{"$f":"IF(E20<>\"\",E20/1.21,\"\")","v":14.71900826446281},null,1,0,"Link",null,{"$f":"C20","v":"Cable access (rights incl.)"},0,0,0,0,0]
[null,{"$f":"IF(C21<>\"-\",B20+1,\"\")","v":2},"Cable access (rights excl.)","Analog TV",{"$f":"E20-E22","v":13.809999999999999},{"$f":"IF(E21<>\"\",E21/1.21,\"\")","v":11.413223140495868},null,1,0,"Link",null,{"$f":"C21","v":"Cable access (rights excl.)"},1,0,0,0,0]
[null,3,"TV Rights (analog)","TV Rights",4,3.3057851239669422,null,0,1,null,null,"TV Rights (analog)",1,0,0,0,0]
[null,4,"TV Plus (rights incl.)","Digital TV",21.9,18.099173553719009,null,1,0,"Link",null,"TV Plus (rights incl.)",0,0,0,0,0]
[null,5,"TV Plus (rights excl.)","Digital TV",{"$f":"E23-E25","v":17},14.049586776859504,null,1,0,"Link",null,"TV Plus (rights excl.)",0,1,1,1,1]
[null,6,"TV Rights (digital)","TV Rights",4.9000000000000004,4.0495867768595044,null,0,1,null,null,"TV Rights (digital)",0,1,1,1,1]
[null,7,"Cablebox HD","Decoder",6,4.9586776859504136,null,1,0,"Link",null,"Cablebox HD",0,0,0,1,1]
[null,8,"Cablebox HD + HDD","Decoder",7,5.785123966942149,null,1,0,"Link",null,"Cablebox HD + HDD",0,1,1,0,0]
[null,9,"La Box 160","Decoder",7,5.785123966942149,null,1,0,"Link",null,"La Box 160",0,0,0,1,0]
[null,10,"La Box 320","Decoder",10,8.2644628099173563,null,1,0,"Link",null,"La Box 320",0,0,0,0,1]
[null,11,"Internet 50M","Broadband",29.9,24.710743801652892,"Vol. limité 100G",1,0,"Link",null,"Internet 50M",0,0,1,0,0]
[null,12,"Internet 100M","Broadband",49.9,41.239669421487605,"Vol. limité 150G",1,0,"Link",null,"Internet 100M",0,0,0,1,0]
[null,13,"Internet 200M","Broadband",59.9,49.504132231404959,"Incl. volume illimité",1,0,"Link",null,"Internet 200M",0,0,0,0,1]
[null,14,"Internet - Option illimité","Broadband",9.9,8.1818181818181817,"Option volume illimité",1,0,"Link",null,"Internet - Option illimité",0,0,0,1,0]
[null,15,"Téléphone Start","Telephony",12.9,10.66115702479339,"Illimité fixe BE 24/24",1,1,"Link",null,"Téléphone Start",0,0,0,0,0]
[null,16,"Téléphone Extra","Telephony",19.899999999999999,16.446280991735538,"Illimité fixe BE 24/24 & Mobile BE soirs & week-ends",1,1,"Link",null,"Téléphone Extra",0,0,0,1,1]
[null,17,"Tél. - Option \"Voisins, Turquie, Maroc\"","Telephony",6.9,5.7024793388429753,"Illimité fixe \"Voisins, Turquie, Maroc\" soirs & week-ends",1,1,"Link",null,"Tél. - Option \"Voisins, Turquie, Maroc\"",0,0,0,1,0]
[null,18,"Tél. - Option \"Monde illimité\"","Telephony",11.9,9.8347107438016543,"Illimité fixe world 24/24",1,1,"Link",null,"Tél. - Option \"Monde illimité\"",0,0,0,0,1]
[null,19,"TV Bouquet \"Mini-premium\"","Extra",9.9,8.1818181818181817,null,1,1,"Link",null,"TV Bouquet \"Mini-premium\"",0,0,0,0,1]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,null,null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,null,"This table includes standalone retail offers that are used as components for building multiple play offers.  ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44)","v":17.809999999999999},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44)","v":28.9},58.8,121.5,139.5,0,0,0,0,0,0,0,"Sum of standalone prices."]
[null,null,"The \"Discount\" column indicates whether a discount can be applied to each component in case of a bundled offer. ",null,null,null,null,null,null,null,null,"\"Packed\" retail price (VAT incl.) :",{"$f":"TRANSPOSE(E5:E16)","v":17.809999999999999},27.9,39.9,55.9,69.900000000000006,0,0,0,0,0,0,0,"Price of the retail offer."]
[null,null,"As for now, only TV Rights are not discounted.",null,null,null,null,null,null,null,null,"Abolute discount (VAT incl.) :",{"$f":"M45-M46","v":0},{"$f":"N45-N46","v":1},18.899999999999999,65.599999999999994,69.599999999999994,0,0,0,0,0,0,0,"Absolute discount in case of \"packed\" offers. "]
[null,null,"The \"Excluded\" column indicates whether each item must be excluded from the base to which the minus applies. ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) for which discount applies :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44,$H$20:$H$44)","v":13.809999999999999},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44,$H$20:$H$44)","v":24},53.9,116.60000000000002,134.60000000000002,0,0,0,0,0,0,0,"Sum of standalone prices for items that cannot be discounted. "]
[null,null,"Typical \"Excludable\" items are TV Rights, Telephony in case of 3-Play or valued Extras like Voo-Foot. ",null,null,null,null,null,null,null,null,"Relative discount (wrt. \"discountable\" items) :",{"$f":"IF(M48<>0,-M47/M48,\"\")","v":0},{"$f":"IF(N48<>0,-N47/N48,\"\")","v":-4.1666666666666664E-2},-0.35064935064935066,-0.56260720411663789,-0.5170876671619612,"","","","","","","","Relative discount with respect to stand alone prices for items that cannot be discounted. "]
[]
["Pack tariff breakdown :"]
[null,"Select offer :","Télédistribution","Choose retail offer"]
[]
[null,null,"Component","Type","Standalone price (VAT incl.)","Discount","Discounted price (VAT incl.)","Weight"]
[null,null,{"$f":"IF(INDEX(M20:X20,1,MATCH($C$52,$M$19:$X$19,0)),C20,\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),1),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),2),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),5),\"\")","v":""},{"$f":"IF(C55<>\"\",E55*(1+F55),\"\")","v":""},{"$f":"IF(C55<>\"\",G55/SUM($G$55:$G$79),\"\")","v":""}]
[null,null,{"$f":"IF(INDEX(M21:X21,1,MATCH($C$52,$M$19:$X$19,0)),C21,\"\")","v":"Cable access (rights excl.)"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),1),\"\")","v":"Analog TV"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),2),\"\")","v":13.809999999999999},{"$f":"IF(C56<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),5),\"\")","v":0},{"$f":"IF(C56<>\"\",E56*(1+F56),\"\")","v":13.809999999999999},{"$f":"IF(C56<>\"\",G56/SUM($G$55:$G$79),\"\")","v":0.77540707467714765}]
[null,null,"TV Rights (analog)","TV Rights",4,0,4,0.22459292532285235]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,null,"Total :",{"$f":"SUM(E55:E79)","v":17.809999999999999},null,{"$f":"SUM(G55:G79)","v":17.809999999999999},{"$f":"SUM(H55:H79)","v":1}]
[null,null,null,"Share of TV, Broadband and TV Rights (ie. exclude \"Telephony\" and \"Extra\")",{"$f":"SUM(E55:E79)-SUMIF(D55:D79,\"=Extra\",E55:E79)-SUMIF(D55:D79,\"=Telephony\",E55:E79)","v":17.809999999999999},null,{"$f":"SUM(G55:G79)-SUMIF(D55:D79,\"=Extra\",G55:G79)-SUMIF(D55:D79,\"=Telephony\",G55:G79)","v":17.809999999999999},{"$f":"SUM(H55:H79)-SUMIF(D55:D79,\"=Extra\",H55:H79)-SUMIF(D55:D79,\"=Telephony\",H55:H79)","v":1}]
[null,null,"This table break downs the retail tariffs in components and computes the weight of each component as a percentage of the \"packed\" retail price. It applies the \"pack\" discount to items that can be discounted. "]
[]
["Wholesale tariff :"]
[null,"Offer :",{"$f":"C52","v":"Télédistribution"}]
[null,"Offer type :",{"$f":"INDEX($D$5:$D$16,MATCH(C85,$C$5:$C$16,0))","v":"Analog TV"}]
[null,"Selected Minus :",{"$f":"INDEX(offer.types.minus,MATCH(C86,offer.types),1)","v":"Analog TV"}]
[null,"Minus Value :",{"$f":"INDEX(minus.val.numericable,MATCH(C87,minus.name))","v":0.2}]
[]
[null,null,"Pack Retail price (VAT incl.)",{"$f":"INDEX(M46:X46,1,MATCH($C$52,$M$19:$X$19,0))","v":17.809999999999999},"Retail price of the offer (VAT incl.). "]
[null,null,"Minus VAT (21%)",{"$f":"D90/1.21-D90","v":-3.0909917355371892}]
[null,null,"Pack Retail price (VAT excl.)",{"$f":"SUM(D90:D91)","v":14.71900826446281}]
[null,null,"Share of (TV+BB+Rights)",{"$f":"H81","v":1},"Share of components that are not \"Telephony\" nor \"Extra\" (ie. that can be excluded except TV Rights that are deducted below). "]
[null,null,"2P equiv. Pack Retail price (VAT excl.)",{"$f":"D92*D93","v":14.71900826446281},"Retail price of an equivalent \"2-Play\" pack in case some components must be exluded. "]
[null,null,"Minus TV Rights (TVA excl.)",{"$f":"-SUMIF(D55:D79,\"TV Rights\",G55:G79)/1.21","v":-3.3057851239669422}]
[null,null,"Minus application base (VAT excl.)",{"$f":"SUM(D94:D95)","v":11.413223140495868}]
[null,null,"Minus \"Minus\"",{"$f":"-C88","v":-0.2}]
[null,null,"Wholesale tariff (VAT excl.)",{"$f":"D96*(1+D97)","v":9.1305785123966938},"Wholesale price (VAT excl.)."]

{"sheet":"Telenet","index":2,"n_rows":98,"n_cols":25,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,12,2,13],[2,14,2,17],[2,18,2,20],[2,21,2,22]]}
["Telenet"]
[]
["Retail offers :",null,null,null,null,null,null,null,null,null,"Offer characteristics :",null,"Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
[null,"Id.","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Link","Legend :","Label / Name",null,"Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[null,{"$f":"IF(C5<>\"-\",1,\"\")","v":1},"TV Analogique","Analog TV",15.2,{"$f":"IF(E5<>\"\",E5/1.21,\"\")","v":12.561983471074379},null,"Link",null,"Computation",null,{"$f":"C5","v":"TV Analogique"},"X","?","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(C6<>\"-\",B5+1,\"\")","v":2},"TV Digitale","Digital TV",23.4,{"$f":"IF(E6<>\"\",E6/1.21,\"\")","v":19.33884297520661},"Price incl. decoder (8,20€)","Link",null,"Required Input",null,{"$f":"C6","v":"TV Digitale"},"X","?","X",75,"?","HD Digicorder","-","-","-","-","-","-"]
[null,{"$f":"IF(C7<>\"-\",B6+1,\"\")","v":3},"Whop","Triple play",{"$f":"53.25+8.2","v":61.45},50.785123966942152,"Price incl. decoder (8,20€)","Link",null,"Optional Input",null,"Whop","X","?","X",75,"?","HD Digicorder","X","60M/4M","100G","X","FreePhone EU","-"]
[null,{"$f":"IF(C8<>\"-\",B7+1,\"\")","v":4},"Whoppa","Triple play",{"$f":"63.5+8.2","v":71.7},59.256198347107443,"Price incl. decoder (8,20€)","Link",null,"Selection",null,"Whoppa","X","?","X",75,"?","HD Digicorder","X","120M/6M","Illimité","X","FreePhone EU","-"]
[null,{"$f":"IF(C9<>\"-\",B8+1,\"\")","v":""},"-",null,null,"",null,null,null,"Output",null,"-"]
[null,{"$f":"IF(C10<>\"-\",B9+1,\"\")","v":""},"-",null,null,"",null,null,null,null,null,"-"]
[null,{"$f":"IF(C11<>\"-\",B10+1,\"\")","v":""},"-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,null,null,null,null,null,null,"-"]
[null,"","-",null,null,null,null,null,null,null,null,"-"]
[null,null,"This table includes retail offers that are used as starting point for setting wholesale prices."]
["Standalone components :",null,null,null,null,null,null,null,null,null,null,"Packs composition :","This table maps \"packed\" retail offers to standalone components. "]
[null,"Id. ","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Discount","Excluded","Link",null,null,{"$f":"TRANSPOSE(C5:C16)","v":"TV Analogique"},"TV Digitale","Whop","Whoppa","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(C20<>\"-\",1,\"\")","v":1},"Cable access (rights incl.)","Analog TV",15.2,{"$f":"IF(E20<>\"\",E20/1.21,\"\")","v":12.561983471074379},null,1,0,"Link",null,{"$f":"C20","v":"Cable access (rights incl.)"},0,0,0,0]
[null,{"$f":"IF(C21<>\"-\",B20+1,\"\")","v":2},"Cable access (rights excl.)","Analog TV",{"$f":"E20-E22","v":12.02},{"$f":"IF(E21<>\"\",E21/1.21,\"\")","v":9.9338842975206614},null,1,0,"Link",null,{"$f":"C21","v":"Cable access (rights excl.)"},1,1,1,1]
[null,{"$f":"IF(C22<>\"-\",B21+1,\"\")","v":3},"TV Rights","TV Rights",3.18,2.6280991735537191,null,0,1,"Link",null,"TV Rights",1,1,1,1]
[null,4,"HD Digicorder","Decoder",8.1999999999999993,6.776859504132231,null,1,0,"Link",null,"HD Digicorder",0,1,1,1]
[null,5,"Internet 60","Broadband",46.5,38.429752066115704,null,1,0,"Link",null,"Internet 60",0,0,1,0]
[null,6,"Internet 120","Broadband",66.5,54.958677685950413,null,1,0,"Link",null,"Internet 120",0,0,0,1]
[null,7,"Tel. Freephone EU","Telephony",20.5,16.942148760330578,null,1,1,"Link",null,"Tel. Freephone EU",0,0,1,1]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,null,"This table includes standalone retail offers that are used as components for building multiple play offers.  ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44)","v":15.2},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44)","v":23.4},90.4,110.4,0,0,0,0,0,0,0,0,"Sum of standalone prices."]
[null,null,"The \"Discount\" column indicates whether a discount can be applied to each component in case of a bundled offer. ",null,null,null,null,null,null,null,null,"\"Packed\" retail price (VAT incl.) :",{"$f":"TRANSPOSE(E5:E16)","v":15.2},23.4,61.45,71.7,0,0,0,0,0,0,0,0,"Price of the retail offer."]
[null,null,"As for now, only TV Rights are not discounted.",null,null,null,null,null,null,null,null,"Abolute discount (VAT incl.) :",{"$f":"M45-M46","v":0},{"$f":"N45-N46","v":0},28.950000000000003,38.700000000000003,0,0,0,0,0,0,0,0,"Absolute discount in case of \"packed\" offers. "]
[null,null,"The \"Excluded\" column indicates whether each item must be excluded from the base to which the minus applies. ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) for which discount applies :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44,$H$20:$H$44)","v":12.02},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44,$H$20:$H$44)","v":20.22},87.22,107.22,0,0,0,0,0,0,0,0,"Sum of standalone prices for items that cannot be discounted. "]
[null,null,"Typical \"Excludable\" items are TV Rights, Telephony in case of 3-Play or valued Extras like Voo-Foot. ",null,null,null,null,null,null,null,null,"Relative discount (wrt. \"discountable\" items) :",{"$f":"IF(M48<>0,-M47/M48,\"\")","v":0},{"$f":"IF(N48<>0,-N47/N48,\"\")","v":0},-0.33191928456775971,-0.36094012311135987,"","","","","","","","","Relative discount with respect to stand alone prices for items that cannot be discounted. "]
[]
["Pack tariff breakdown :"]
[null,"Select offer :","TV Analogique","Choose retail offer"]
[]
[null,null,"Component","Type","Standalone price (VAT incl.)","Discount","Discounted price (VAT incl.)","Weight"]
[null,null,{"$f":"IF(INDEX(M20:X20,1,MATCH($C$52,$M$19:$X$19,0)),C20,\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),1),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),2),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),5),\"\")","v":""},{"$f":"IF(C55<>\"\",E55*(1+F55),\"\")","v":""},{"$f":"IF(C55<>\"\",G55/SUM($G$55:$G$79),\"\")","v":""}]
[null,null,{"$f":"IF(INDEX(M21:X21,1,MATCH($C$52,$M$19:$X$19,0)),C21,\"\")","v":"Cable access (rights excl.)"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),1),\"\")","v":"Analog TV"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),2),\"\")","v":12.02},{"$f":"IF(C56<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),5),\"\")","v":0},{"$f":"IF(C56<>\"\",E56*(1+F56),\"\")","v":12.02},{"$f":"IF(C56<>\"\",G56/SUM($G$55:$G$79),\"\")","v":0.79078947368421049}]
[null,null,"TV Rights","TV Rights",3.18,0,3.18,0.20921052631578949]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,null,"Total :",{"$f":"SUM(E55:E79)","v":15.2},null,{"$f":"SUM(G55:G79)","v":15.2},{"$f":"SUM(H55:H79)","v":1}]
[null,null,null,"Share of TV, Broadband and TV Rights (ie. exclude \"Telephony\" and \"Extra\")",{"$f":"SUM(E55:E79)-SUMIF(D55:D79,\"=Extra\",E55:E79)-SUMIF(D55:D79,\"=Telephony\",E55:E79)","v":15.2},null,{"$f":"SUM(G55:G79)-SUMIF(D55:D79,\"=Extra\",G55:G79)-SUMIF(D55:D79,\"=Telephony\",G55:G79)","v":15.2},{"$f":"SUM(H55:H79)-SUMIF(D55:D79,\"=Extra\",H55:H79)-SUMIF(D55:D79,\"=Telephony\",H55:H79)","v":1}]
[null,null,"This table break downs the retail tariffs in components and computes the weight of each component as a percentage of the \"packed\" retail price. It applies the \"pack\" discount to items that can be discounted. "]
[]
["Wholesale tariff :"]
[null,"Offer :",{"$f":"C52","v":"TV Analogique"}]
[null,"Offer type :",{"$f":"INDEX($D$5:$D$16,MATCH(C85,$C$5:$C$16,0))","v":"Analog TV"}]
[null,"Selected Minus :",{"$f":"INDEX(offer.types.minus,MATCH(C86,offer.types),1)","v":"Analog TV"}]
[null,"Minus Value :",{"$f":"INDEX(minus.val.telenet,MATCH(C87,minus.name))","v":0.3}]
[]
[null,null,"Pack Retail price (VAT incl.)",{"$f":"INDEX(M46:X46,1,MATCH($C$52,$M$19:$X$19,0))","v":15.2},"Retail price of the offer (VAT incl.). "]
[null,null,"Minus VAT (21%)",{"$f":"D90/1.21-D90","v":-2.6380165289256201}]
[null,null,"Pack Retail price (VAT excl.)",{"$f":"SUM(D90:D91)","v":12.561983471074379}]
[null,null,"Share of (TV+BB+Rights)",{"$f":"H81","v":1},"Share of components that are not \"Telephony\" nor \"Extra\" (ie. that can be excluded except TV Rights that are deducted below). "]
[null,null,"2P equiv. Pack Retail price (VAT excl.)",{"$f":"D92*D93","v":12.561983471074379},"Retail price of an equivalent \"2-Play\" pack in case some components must be exluded. "]
[null,null,"Minus TV Rights (TVA excl.)",{"$f":"-SUMIF(D55:D79,\"TV Rights\",G55:G79)/1.21","v":-2.6280991735537191}]
[null,null,"Minus application base (VAT excl.)",{"$f":"SUM(D94:D95)","v":9.9338842975206596}]
[null,null,"Minus \"Minus\"",{"$f":"-C88","v":-0.3}]
[null,null,"Wholesale tariff (VAT excl.)",{"$f":"D96*(1+D97)","v":6.9537190082644615},"Wholesale price (VAT excl.)."]

{"sheet":"Voo","index":3,"n_rows":98,"n_cols":25,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,12,2,13],[2,18,2,20],[2,21,2,22],[2,14,2,17]]}
["Voo"]
[]
["Retail offers :",null,null,null,null,null,null,null,null,null,"Offer characteristics :",null,"Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
[null,"Id.","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Link","Legend :","Label / Name",null,"Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[null,{"$f":"IF(C5<>\"-\",1,\"\")","v":1},"TV Analogique","Analog TV",16.86,{"$f":"IF(E5<>\"\",E5/1.21,\"\")","v":13.933884297520661},null,"Link",null,"Computation",null,{"$f":"C5","v":"TV Analogique"},"X","20+","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(C6<>\"-\",B5+1,\"\")","v":2},"TV Numérique Interactive","Digital TV",{"$f":"16.86+6.09","v":22.95},{"$f":"IF(E6<>\"\",E6/1.21,\"\")","v":18.966942148760332},"Price incl. decoder (6,09€)","Link",null,"Required Input",null,{"$f":"C6","v":"TV Numérique Interactive"},"X","20+","X","65+",11,"VOOcorder","-","-","-","-","-","-"]
[null,{"$f":"IF(C7<>\"-\",B6+1,\"\")","v":3},"Duo TV NET \"Un peu\"","Dual play",40.950000000000003,33.842975206611577,"Price \"all in\"","Link",null,"Optional Input",null,"Duo TV NET \"Un peu\"","X","20+","X","65+",11,"VOOcorder","X","30M","100G","-","-","-"]
[null,{"$f":"IF(C8<>\"-\",B7+1,\"\")","v":4},"Duo TV NET \"Beaucoup\"","Dual play",50.95,42.107438016528931,"Price \"all in\"","Link",null,"Selection",null,"Duo TV NET \"Beaucoup\"","X","20+","X","65+",11,"VOOcorder","X","40M","Illimité","-","-","-"]
[null,{"$f":"IF(C9<>\"-\",B8+1,\"\")","v":5},"Duo TV NET \"Passionnement\"","Dual play",60.95,50.371900826446286,"Price \"all in\"","Link",null,"Output",null,"Duo TV NET \"Passionnement\"","X","20+","X","65+",11,"VOOcorder","X","50M","Illimité","-","-","VooFoot"]
[null,{"$f":"IF(C10<>\"-\",B9+1,\"\")","v":6},"Duo TV NET \"A la folie\"","Dual play",70.95,58.63636363636364,"Price \"all in\"","Link",null,null,null,"Duo TV NET \"A la folie\"","X","20+","X","65+",11,"VOOcorder","X","70M","Illimité","-","-","VooFoot"]
[null,{"$f":"IF(C11<>\"-\",B10+1,\"\")","v":7},"Duo TV NET \"Fiber 100\"","Dual play",90.95,75.165289256198349,"Price \"all in\"","Link",null,null,null,"Duo TV NET \"Fiber 100\"","X","20+","X","65+",11,"VOOcorder","X","100M","Illimité","-","-","VooFoot"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,null,"This table includes retail offers that are used as starting point for setting wholesale prices."]
["Standalone components :",null,null,null,null,null,null,null,null,null,null,"Packs composition :","This table maps \"packed\" retail offers to standalone components. "]
[null,"Id. ","Name","Type","Retail price (VAT incl.)","Retail price (VAT excl.)","Remark","Discount","Excluded","Link",null,null,{"$f":"TRANSPOSE(C5:C16)","v":"TV Analogique"},"TV Numérique Interactive","Duo TV NET \"Un peu\"","Duo TV NET \"Beaucoup\"","Duo TV NET \"Passionnement\"","Duo TV NET \"A la folie\"","Duo TV NET \"Fiber 100\"","-","-","-","-","-"]
[null,{"$f":"IF(C20<>\"-\",1,\"\")","v":1},"Cable access (rights incl.)","Analog TV",16.86,{"$f":"IF(E20<>\"\",E20/1.21,\"\")","v":13.933884297520661},null,1,0,"Link",null,{"$f":"C20","v":"Cable access (rights incl.)"},0,0,0,0,0,0,0]
[null,{"$f":"IF(C21<>\"-\",B20+1,\"\")","v":2},"Cable access (rights excl.)","Analog TV",{"$f":"E20-SUM(E22:E23)","v":13.469999999999999},{"$f":"IF(E21<>\"\",E21/1.21,\"\")","v":11.132231404958677},null,1,0,"Link",null,{"$f":"C21","v":"Cable access (rights excl.)"},1,1,1,1,1,1,1]
[null,{"$f":"IF(C22<>\"-\",B21+1,\"\")","v":3},"TV Rights","TV Rights",2.91,2.4049586776859506,null,0,1,"Link",null,"TV Rights",1,1,1,1,1,1,1]
[null,4,"Promotion audiovisuel","TV Rights",0.48,0.39669421487603307,"Tecteo Only",0,1,"Link",null,"Promotion audiovisuel",1,1,1,1,1,1,1]
[null,5,"VOOcorder","Decoder",6.09,5.0330578512396693,null,1,0,"Link",null,"VOOcorder",0,1,1,1,1,1,1]
[null,6,"Internet \"Un peu\"","Broadband",24.95,20.619834710743802,null,1,0,"Link",null,"Internet \"Un peu\"",0,0,1,0,0,0,0]
[null,7,"Internet \"Beaucoup\"","Broadband",34.950000000000003,28.884297520661161,null,1,0,"Link",null,"Internet \"Beaucoup\"",0,0,0,1,0,0,0]
[null,8,"Internet \"Passionnement\"","Broadband",44.95,37.148760330578519,null,1,0,"Link",null,"Internet \"Passionnement\"",0,0,0,0,1,0,0]
[null,9,"Internet \"A la folie\"","Broadband",54.95,45.413223140495873,null,1,0,"Link",null,"Internet \"A la folie\"",0,0,0,0,0,1,0]
[null,10,"Internet \"Fiber 100\"","Broadband",74.95,61.942148760330582,null,1,0,"Link",null,"Internet \"Fiber 100\"",0,0,0,0,0,0,1]
[null,11,"VooFoot","Extra",10.8,8.9256198347107443,null,1,1,"Link",null,"VooFoot",0,0,0,0,1,1,1]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,"","-",null,null,"",null,null,null,null,null,"-"]
[null,null,"This table includes standalone retail offers that are used as components for building multiple play offers.  ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44)","v":16.86},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44)","v":22.95},47.9,57.900000000000006,78.7,88.7,108.7,0,0,0,0,0,"Sum of standalone prices."]
[null,null,"The \"Discount\" column indicates whether a discount can be applied to each component in case of a bundled offer. ",null,null,null,null,null,null,null,null,"\"Packed\" retail price (VAT incl.) :",{"$f":"TRANSPOSE(E5:E16)","v":16.86},22.95,40.950000000000003,50.95,60.95,70.95,90.95,0,0,0,0,0,"Price of the retail offer."]
[null,null,"As for now, only TV Rights are not discounted.",null,null,null,null,null,null,null,null,"Abolute discount (VAT incl.) :",{"$f":"M45-M46","v":0},{"$f":"N45-N46","v":0},6.9499999999999957,6.9500000000000028,17.75,17.75,17.75,0,0,0,0,0,"Absolute discount in case of \"packed\" offers. "]
[null,null,"The \"Excluded\" column indicates whether each item must be excluded from the base to which the minus applies. ",null,null,null,null,null,null,null,null,"Sum of standalone prices (VAT incl.) for which discount applies :",{"$f":"SUMPRODUCT(M20:M44,$E$20:$E$44,$H$20:$H$44)","v":13.469999999999999},{"$f":"SUMPRODUCT(N20:N44,$E$20:$E$44,$H$20:$H$44)","v":19.559999999999999},44.51,54.510000000000005,75.31,85.31,105.31,0,0,0,0,0,"Sum of standalone prices for items that cannot be discounted. "]
[null,null,"Typical \"Excludable\" items are TV Rights, Telephony in case of 3-Play or valued Extras like Voo-Foot. ",null,null,null,null,null,null,null,null,"Relative discount (wrt. \"discountable\" items) :",{"$f":"IF(M48<>0,-M47/M48,\"\")","v":0},{"$f":"IF(N48<>0,-N47/N48,\"\")","v":0},-0.15614468658728367,-0.12749954136855626,-0.23569247111937325,-0.20806470519282616,-0.16854999525211281,"","","","","","Relative discount with respect to stand alone prices for items that cannot be discounted. "]
[]
["Pack tariff breakdown :"]
[null,"Select offer :","TV Analogique","Choose retail offer"]
[]
[null,null,"Component","Type","Standalone price (VAT incl.)","Discount","Discounted price (VAT incl.)","Weight"]
[null,null,{"$f":"IF(INDEX(M20:X20,1,MATCH($C$52,$M$19:$X$19,0)),C20,\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),1),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),2),\"\")","v":""},{"$f":"IF(C55<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C55,$C$20:$C$44,0),5),\"\")","v":""},{"$f":"IF(C55<>\"\",E55*(1+F55),\"\")","v":""},{"$f":"IF(C55<>\"\",G55/SUM($G$55:$G$79),\"\")","v":""}]
[null,null,{"$f":"IF(INDEX(M21:X21,1,MATCH($C$52,$M$19:$X$19,0)),C21,\"\")","v":"Cable access (rights excl.)"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),1),\"\")","v":"Analog TV"},{"$f":"IF(C56<>\"\",INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),2),\"\")","v":13.469999999999999},{"$f":"IF(C56<>\"\",INDEX($M$49:$X$49,1,MATCH($C$52,$M$19:$X$19,0))*INDEX($D$20:$J$44,MATCH(C56,$C$20:$C$44,0),5),\"\")","v":0},{"$f":"IF(C56<>\"\",E56*(1+F56),\"\")","v":13.469999999999999},{"$f":"IF(C56<>\"\",G56/SUM($G$55:$G$79),\"\")","v":0.79893238434163694}]
[null,null,"TV Rights","TV Rights",2.91,0,2.91,0.1725978647686833]
[null,null,"Promotion audiovisuel","TV Rights",0.48,0,0.48,2.8469750889679714E-2]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,"","","","","",""]
[null,null,null,"Total :",{"$f":"SUM(E55:E79)","v":16.86},null,{"$f":"SUM(G55:G79)","v":16.86},{"$f":"SUM(H55:H79)","v":1}]
[null,null,null,"Share of TV, Broadband and TV Rights (ie. exclude \"Telephony\" and \"Extra\")",{"$f":"SUM(E55:E79)-SUMIF(D55:D79,\"=Extra\",E55:E79)-SUMIF(D55:D79,\"=Telephony\",E55:E79)","v":16.86},null,{"$f":"SUM(G55:G79)-SUMIF(D55:D79,\"=Extra\",G55:G79)-SUMIF(D55:D79,\"=Telephony\",G55:G79)","v":16.86},{"$f":"SUM(H55:H79)-SUMIF(D55:D79,\"=Extra\",H55:H79)-SUMIF(D55:D79,\"=Telephony\",H55:H79)","v":1}]
[null,null,"This table break downs the retail tariffs in components and computes the weight of each component as a percentage of the \"packed\" retail price. It applies the \"pack\" discount to items that can be discounted. "]
[]
["Wholesale tariff :"]
[null,"Offer :",{"$f":"C52","v":"TV Analogique"}]
[null,"Offer type :",{"$f":"INDEX($D$5:$D$16,MATCH(C85,$C$5:$C$16,0))","v":"Analog TV"}]
[null,"Selected Minus :",{"$f":"INDEX(offer.types.minus,MATCH(C86,offer.types),1)","v":"Analog TV"}]
[null,"Minus Value :",{"$f":"INDEX(minus.val.voo,MATCH(C87,minus.name))","v":0.3}]
[]
[null,null,"Pack Retail price (VAT incl.)",{"$f":"INDEX(M46:X46,1,MATCH($C$52,$M$19:$X$19,0))","v":16.86},"Retail price of the offer (VAT incl.). "]
[null,null,"Minus VAT (21%)",{"$f":"D90/1.21-D90","v":-2.9261157024793381}]
[null,null,"Pack Retail price (VAT excl.)",{"$f":"SUM(D90:D91)","v":13.933884297520661}]
[null,null,"Share of (TV+BB+Rights)",{"$f":"H81","v":1},"Share of components that are not \"Telephony\" nor \"Extra\" (ie. that can be excluded except TV Rights that are deducted below). "]
[null,null,"2P equiv. Pack Retail price (VAT excl.)",{"$f":"D92*D93","v":13.933884297520661},"Retail price of an equivalent \"2-Play\" pack in case some components must be exluded. "]
[null,null,"Minus TV Rights (TVA excl.)",{"$f":"-SUMIF(D55:D79,\"TV Rights\",G55:G79)/1.21","v":-2.8016528925619837}]
[null,null,"Minus application base (VAT excl.)",{"$f":"SUM(D94:D95)","v":11.132231404958677}]
[null,null,"Minus \"Minus\"",{"$f":"-C88","v":-0.3}]
[null,null,"Wholesale tariff (VAT excl.)",{"$f":"D96*(1+D97)","v":7.7925619834710735},"Wholesale price (VAT excl.)."]

{"sheet":"Offers","index":4,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[30,1,30,2],[30,3,30,6],[30,7,30,9],[30,10,30,11],[0,1,0,2],[0,3,0,6],[0,7,0,9],[0,10,0,11],[15,1,15,2],[15,3,15,6],[15,7,15,9],[15,10,15,11]]}
["Numericable","Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
["Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[{"$f":"Numericable!L5","v":"Télédistribution"},{"$f":"IF($A3=\"-\",\"\",Numericable!M5)","v":"X"},{"$f":"IF($A3=\"-\",\"\",Numericable!N5)","v":25},{"$f":"IF($A3=\"-\",\"\",Numericable!O5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!P5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!Q5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!R5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!S5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!T5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!U5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!V5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!W5)","v":"-"},{"$f":"IF($A3=\"-\",\"\",Numericable!X5)","v":"-"}]
[{"$f":"Numericable!L6","v":"TV Plus (digital)"},{"$f":"IF($A4=\"-\",\"\",Numericable!M6)","v":"X"},{"$f":"IF($A4=\"-\",\"\",Numericable!N6)","v":25},{"$f":"IF($A4=\"-\",\"\",Numericable!O6)","v":"X"},{"$f":"IF($A4=\"-\",\"\",Numericable!P6)","v":130},{"$f":"IF($A4=\"-\",\"\",Numericable!Q6)","v":17},{"$f":"IF($A4=\"-\",\"\",Numericable!R6)","v":"HD/HDD"},{"$f":"IF($A4=\"-\",\"\",Numericable!S6)","v":"-"},{"$f":"IF($A4=\"-\",\"\",Numericable!T6)","v":"-"},{"$f":"IF($A4=\"-\",\"\",Numericable!U6)","v":"-"},{"$f":"IF($A4=\"-\",\"\",Numericable!V6)","v":"-"},{"$f":"IF($A4=\"-\",\"\",Numericable!W6)","v":"-"},{"$f":"IF($A4=\"-\",\"\",Numericable!X6)","v":"-"}]
[{"$f":"Numericable!L7","v":"Duo TV+Web"},{"$f":"IF($A5=\"-\",\"\",Numericable!M7)","v":"X"},{"$f":"IF($A5=\"-\",\"\",Numericable!N7)","v":25},{"$f":"IF($A5=\"-\",\"\",Numericable!O7)","v":"X"},{"$f":"IF($A5=\"-\",\"\",Numericable!P7)","v":100},{"$f":"IF($A5=\"-\",\"\",Numericable!Q7)","v":12},{"$f":"IF($A5=\"-\",\"\",Numericable!R7)","v":"HD/HDD"},{"$f":"IF($A5=\"-\",\"\",Numericable!S7)","v":"X"},{"$f":"IF($A5=\"-\",\"\",Numericable!T7)","v":"50M/2.5M"},{"$f":"IF($A5=\"-\",\"\",Numericable!U7)","v":"100G"},{"$f":"IF($A5=\"-\",\"\",Numericable!V7)","v":"-"},{"$f":"IF($A5=\"-\",\"\",Numericable!W7)","v":"-"},{"$f":"IF($A5=\"-\",\"\",Numericable!X7)","v":"-"}]
[{"$f":"Numericable!L8","v":"Triple Play Extra"},{"$f":"IF($A6=\"-\",\"\",Numericable!M8)","v":"X"},{"$f":"IF($A6=\"-\",\"\",Numericable!N8)","v":25},{"$f":"IF($A6=\"-\",\"\",Numericable!O8)","v":"X"},{"$f":"IF($A6=\"-\",\"\",Numericable!P8)","v":130},{"$f":"IF($A6=\"-\",\"\",Numericable!Q8)","v":17},{"$f":"IF($A6=\"-\",\"\",Numericable!R8)","v":"Box 160 + HD"},{"$f":"IF($A6=\"-\",\"\",Numericable!S8)","v":"X"},{"$f":"IF($A6=\"-\",\"\",Numericable!T8)","v":"100M/5M"},{"$f":"IF($A6=\"-\",\"\",Numericable!U8)","v":"Illimité"},{"$f":"IF($A6=\"-\",\"\",Numericable!V8)","v":"X"},{"$f":"IF($A6=\"-\",\"\",Numericable!W8)","v":"Extra + Voisins"},{"$f":"IF($A6=\"-\",\"\",Numericable!X8)","v":"-"}]
[{"$f":"Numericable!L9","v":"Triple Play Max"},{"$f":"IF($A7=\"-\",\"\",Numericable!M9)","v":"X"},{"$f":"IF($A7=\"-\",\"\",Numericable!N9)","v":25},{"$f":"IF($A7=\"-\",\"\",Numericable!O9)","v":"X"},{"$f":"IF($A7=\"-\",\"\",Numericable!P9)","v":130},{"$f":"IF($A7=\"-\",\"\",Numericable!Q9)","v":17},{"$f":"IF($A7=\"-\",\"\",Numericable!R9)","v":"Box 320 + HD"},{"$f":"IF($A7=\"-\",\"\",Numericable!S9)","v":"X"},{"$f":"IF($A7=\"-\",\"\",Numericable!T9)","v":"200M/8M"},{"$f":"IF($A7=\"-\",\"\",Numericable!U9)","v":"Illimité"},{"$f":"IF($A7=\"-\",\"\",Numericable!V9)","v":"X"},{"$f":"IF($A7=\"-\",\"\",Numericable!W9)","v":"Extra + Monde"},{"$f":"IF($A7=\"-\",\"\",Numericable!X9)","v":"Mini Premium"}]
[{"$f":"Numericable!L10","v":"-"},{"$f":"IF($A8=\"-\",\"\",Numericable!M10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!N10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!O10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!P10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!Q10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!R10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!S10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!T10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!U10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!V10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!W10)","v":""},{"$f":"IF($A8=\"-\",\"\",Numericable!X10)","v":""}]
[{"$f":"Numericable!L11","v":"-"},{"$f":"IF($A9=\"-\",\"\",Numericable!M11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!N11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!O11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!P11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!Q11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!R11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!S11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!T11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!U11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!V11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!W11)","v":""},{"$f":"IF($A9=\"-\",\"\",Numericable!X11)","v":""}]
[{"$f":"Numericable!L12","v":"-"},{"$f":"IF($A10=\"-\",\"\",Numericable!M12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!N12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!O12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!P12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!Q12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!R12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!S12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!T12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!U12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!V12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!W12)","v":""},{"$f":"IF($A10=\"-\",\"\",Numericable!X12)","v":""}]
[{"$f":"Numericable!L13","v":"-"},{"$f":"IF($A11=\"-\",\"\",Numericable!M13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!N13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!O13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!P13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!Q13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!R13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!S13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!T13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!U13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!V13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!W13)","v":""},{"$f":"IF($A11=\"-\",\"\",Numericable!X13)","v":""}]
[{"$f":"Numericable!L14","v":"-"},{"$f":"IF($A12=\"-\",\"\",Numericable!M14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!N14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!O14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!P14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!Q14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!R14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!S14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!T14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!U14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!V14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!W14)","v":""},{"$f":"IF($A12=\"-\",\"\",Numericable!X14)","v":""}]
[{"$f":"Numericable!L15","v":"-"},{"$f":"IF($A13=\"-\",\"\",Numericable!M15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!N15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!O15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!P15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!Q15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!R15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!S15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!T15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!U15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!V15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!W15)","v":""},{"$f":"IF($A13=\"-\",\"\",Numericable!X15)","v":""}]
[{"$f":"Numericable!L16","v":"-"},{"$f":"IF($A14=\"-\",\"\",Numericable!M16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!N16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!O16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!P16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!Q16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!R16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!S16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!T16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!U16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!V16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!W16)","v":""},{"$f":"IF($A14=\"-\",\"\",Numericable!X16)","v":""}]
[]
["Telenet","Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
["Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[{"$f":"Telenet!L5","v":"TV Analogique"},{"$f":"IF($A18=\"-\",\"\",Telenet!M5)","v":"X"},{"$f":"IF($A18=\"-\",\"\",Telenet!N5)","v":"?"},{"$f":"IF($A18=\"-\",\"\",Telenet!O5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!P5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!Q5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!R5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!S5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!T5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!U5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!V5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!W5)","v":"-"},{"$f":"IF($A18=\"-\",\"\",Telenet!X5)","v":"-"}]
[{"$f":"Telenet!L6","v":"TV Digitale"},{"$f":"IF($A19=\"-\",\"\",Telenet!M6)","v":"X"},{"$f":"IF($A19=\"-\",\"\",Telenet!N6)","v":"?"},{"$f":"IF($A19=\"-\",\"\",Telenet!O6)","v":"X"},{"$f":"IF($A19=\"-\",\"\",Telenet!P6)","v":75},{"$f":"IF($A19=\"-\",\"\",Telenet!Q6)","v":"?"},{"$f":"IF($A19=\"-\",\"\",Telenet!R6)","v":"HD Digicorder"},{"$f":"IF($A19=\"-\",\"\",Telenet!S6)","v":"-"},{"$f":"IF($A19=\"-\",\"\",Telenet!T6)","v":"-"},{"$f":"IF($A19=\"-\",\"\",Telenet!U6)","v":"-"},{"$f":"IF($A19=\"-\",\"\",Telenet!V6)","v":"-"},{"$f":"IF($A19=\"-\",\"\",Telenet!W6)","v":"-"},{"$f":"IF($A19=\"-\",\"\",Telenet!X6)","v":"-"}]
[{"$f":"Telenet!L7","v":"Whop"},{"$f":"IF($A20=\"-\",\"\",Telenet!M7)","v":"X"},{"$f":"IF($A20=\"-\",\"\",Telenet!N7)","v":"?"},{"$f":"IF($A20=\"-\",\"\",Telenet!O7)","v":"X"},{"$f":"IF($A20=\"-\",\"\",Telenet!P7)","v":75},{"$f":"IF($A20=\"-\",\"\",Telenet!Q7)","v":"?"},{"$f":"IF($A20=\"-\",\"\",Telenet!R7)","v":"HD Digicorder"},{"$f":"IF($A20=\"-\",\"\",Telenet!S7)","v":"X"},{"$f":"IF($A20=\"-\",\"\",Telenet!T7)","v":"60M/4M"},{"$f":"IF($A20=\"-\",\"\",Telenet!U7)","v":"100G"},{"$f":"IF($A20=\"-\",\"\",Telenet!V7)","v":"X"},{"$f":"IF($A20=\"-\",\"\",Telenet!W7)","v":"FreePhone EU"},{"$f":"IF($A20=\"-\",\"\",Telenet!X7)","v":"-"}]
[{"$f":"Telenet!L8","v":"Whoppa"},{"$f":"IF($A21=\"-\",\"\",Telenet!M8)","v":"X"},{"$f":"IF($A21=\"-\",\"\",Telenet!N8)","v":"?"},{"$f":"IF($A21=\"-\",\"\",Telenet!O8)","v":"X"},{"$f":"IF($A21=\"-\",\"\",Telenet!P8)","v":75},{"$f":"IF($A21=\"-\",\"\",Telenet!Q8)","v":"?"},{"$f":"IF($A21=\"-\",\"\",Telenet!R8)","v":"HD Digicorder"},{"$f":"IF($A21=\"-\",\"\",Telenet!S8)","v":"X"},{"$f":"IF($A21=\"-\",\"\",Telenet!T8)","v":"120M/6M"},{"$f":"IF($A21=\"-\",\"\",Telenet!U8)","v":"Illimité"},{"$f":"IF($A21=\"-\",\"\",Telenet!V8)","v":"X"},{"$f":"IF($A21=\"-\",\"\",Telenet!W8)","v":"FreePhone EU"},{"$f":"IF($A21=\"-\",\"\",Telenet!X8)","v":"-"}]
[{"$f":"Telenet!L9","v":"-"},{"$f":"IF($A22=\"-\",\"\",Telenet!M9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!N9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!O9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!P9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!Q9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!R9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!S9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!T9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!U9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!V9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!W9)","v":""},{"$f":"IF($A22=\"-\",\"\",Telenet!X9)","v":""}]
[{"$f":"Telenet!L10","v":"-"},{"$f":"IF($A23=\"-\",\"\",Telenet!M10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!N10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!O10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!P10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!Q10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!R10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!S10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!T10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!U10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!V10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!W10)","v":""},{"$f":"IF($A23=\"-\",\"\",Telenet!X10)","v":""}]
[{"$f":"Telenet!L11","v":"-"},{"$f":"IF($A24=\"-\",\"\",Telenet!M11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!N11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!O11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!P11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!Q11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!R11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!S11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!T11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!U11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!V11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!W11)","v":""},{"$f":"IF($A24=\"-\",\"\",Telenet!X11)","v":""}]
[{"$f":"Telenet!L12","v":"-"},{"$f":"IF($A25=\"-\",\"\",Telenet!M12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!N12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!O12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!P12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!Q12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!R12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!S12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!T12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!U12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!V12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!W12)","v":""},{"$f":"IF($A25=\"-\",\"\",Telenet!X12)","v":""}]
[{"$f":"Telenet!L13","v":"-"},{"$f":"IF($A26=\"-\",\"\",Telenet!M13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!N13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!O13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!P13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!Q13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!R13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!S13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!T13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!U13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!V13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!W13)","v":""},{"$f":"IF($A26=\"-\",\"\",Telenet!X13)","v":""}]
[{"$f":"Telenet!L14","v":"-"},{"$f":"IF($A27=\"-\",\"\",Telenet!M14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!N14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!O14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!P14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!Q14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!R14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!S14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!T14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!U14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!V14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!W14)","v":""},{"$f":"IF($A27=\"-\",\"\",Telenet!X14)","v":""}]
[{"$f":"Telenet!L15","v":"-"},{"$f":"IF($A28=\"-\",\"\",Telenet!M15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!N15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!O15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!P15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!Q15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!R15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!S15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!T15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!U15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!V15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!W15)","v":""},{"$f":"IF($A28=\"-\",\"\",Telenet!X15)","v":""}]
[{"$f":"Telenet!L16","v":"-"},{"$f":"IF($A29=\"-\",\"\",Telenet!M16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!N16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!O16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!P16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!Q16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!R16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!S16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!T16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!U16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!V16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!W16)","v":""},{"$f":"IF($A29=\"-\",\"\",Telenet!X16)","v":""}]
[]
["Voo","Analog TV",null,"Digital TV",null,null,null,"Broadband",null,null,"Telephony",null,"Extras"]
["Name","Analog TV","#Channels","Digital TV","#Channels","#HD Channels","Decoder","Broadband","Bitrate Dn[/Up]","Quota","Telephony","Options","-"]
[{"$f":"Voo!L5","v":"TV Analogique"},{"$f":"IF($A33=\"-\",\"\",Voo!M5)","v":"X"},{"$f":"IF($A33=\"-\",\"\",Voo!N5)","v":"20+"},{"$f":"IF($A33=\"-\",\"\",Voo!O5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!P5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!Q5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!R5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!S5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!T5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!U5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!V5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!W5)","v":"-"},{"$f":"IF($A33=\"-\",\"\",Voo!X5)","v":"-"}]
[{"$f":"Voo!L6","v":"TV Numérique Interactive"},{"$f":"IF($A34=\"-\",\"\",Voo!M6)","v":"X"},{"$f":"IF($A34=\"-\",\"\",Voo!N6)","v":"20+"},{"$f":"IF($A34=\"-\",\"\",Voo!O6)","v":"X"},{"$f":"IF($A34=\"-\",\"\",Voo!P6)","v":"65+"},{"$f":"IF($A34=\"-\",\"\",Voo!Q6)","v":11},{"$f":"IF($A34=\"-\",\"\",Voo!R6)","v":"VOOcorder"},{"$f":"IF($A34=\"-\",\"\",Voo!S6)","v":"-"},{"$f":"IF($A34=\"-\",\"\",Voo!T6)","v":"-"},{"$f":"IF($A34=\"-\",\"\",Voo!U6)","v":"-"},{"$f":"IF($A34=\"-\",\"\",Voo!V6)","v":"-"},{"$f":"IF($A34=\"-\",\"\",Voo!W6)","v":"-"},{"$f":"IF($A34=\"-\",\"\",Voo!X6)","v":"-"}]
[{"$f":"Voo!L7","v":"Duo TV NET \"Un peu\""},{"$f":"IF($A35=\"-\",\"\",Voo!M7)","v":"X"},{"$f":"IF($A35=\"-\",\"\",Voo!N7)","v":"20+"},{"$f":"IF($A35=\"-\",\"\",Voo!O7)","v":"X"},{"$f":"IF($A35=\"-\",\"\",Voo!P7)","v":"65+"},{"$f":"IF($A35=\"-\",\"\",Voo!Q7)","v":11},{"$f":"IF($A35=\"-\",\"\",Voo!R7)","v":"VOOcorder"},{"$f":"IF($A35=\"-\",\"\",Voo!S7)","v":"X"},{"$f":"IF($A35=\"-\",\"\",Voo!T7)","v":"30M"},{"$f":"IF($A35=\"-\",\"\",Voo!U7)","v":"100G"},{"$f":"IF($A35=\"-\",\"\",Voo!V7)","v":"-"},{"$f":"IF($A35=\"-\",\"\",Voo!W7)","v":"-"},{"$f":"IF($A35=\"-\",\"\",Voo!X7)","v":"-"}]
[{"$f":"Voo!L8","v":"Duo TV NET \"Beaucoup\""},{"$f":"IF($A36=\"-\",\"\",Voo!M8)","v":"X"},{"$f":"IF($A36=\"-\",\"\",Voo!N8)","v":"20+"},{"$f":"IF($A36=\"-\",\"\",Voo!O8)","v":"X"},{"$f":"IF($A36=\"-\",\"\",Voo!P8)","v":"65+"},{"$f":"IF($A36=\"-\",\"\",Voo!Q8)","v":11},{"$f":"IF($A36=\"-\",\"\",Voo!R8)","v":"VOOcorder"},{"$f":"IF($A36=\"-\",\"\",Voo!S8)","v":"X"},{"$f":"IF($A36=\"-\",\"\",Voo!T8)","v":"40M"},{"$f":"IF($A36=\"-\",\"\",Voo!U8)","v":"Illimité"},{"$f":"IF($A36=\"-\",\"\",Voo!V8)","v":"-"},{"$f":"IF($A36=\"-\",\"\",Voo!W8)","v":"-"},{"$f":"IF($A36=\"-\",\"\",Voo!X8)","v":"-"}]
[{"$f":"Voo!L9","v":"Duo TV NET \"Passionnement\""},{"$f":"IF($A37=\"-\",\"\",Voo!M9)","v":"X"},{"$f":"IF($A37=\"-\",\"\",Voo!N9)","v":"20+"},{"$f":"IF($A37=\"-\",\"\",Voo!O9)","v":"X"},{"$f":"IF($A37=\"-\",\"\",Voo!P9)","v":"65+"},{"$f":"IF($A37=\"-\",\"\",Voo!Q9)","v":11},{"$f":"IF($A37=\"-\",\"\",Voo!R9)","v":"VOOcorder"},{"$f":"IF($A37=\"-\",\"\",Voo!S9)","v":"X"},{"$f":"IF($A37=\"-\",\"\",Voo!T9)","v":"50M"},{"$f":"IF($A37=\"-\",\"\",Voo!U9)","v":"Illimité"},{"$f":"IF($A37=\"-\",\"\",Voo!V9)","v":"-"},{"$f":"IF($A37=\"-\",\"\",Voo!W9)","v":"-"},{"$f":"IF($A37=\"-\",\"\",Voo!X9)","v":"VooFoot"}]
[{"$f":"Voo!L10","v":"Duo TV NET \"A la folie\""},{"$f":"IF($A38=\"-\",\"\",Voo!M10)","v":"X"},{"$f":"IF($A38=\"-\",\"\",Voo!N10)","v":"20+"},{"$f":"IF($A38=\"-\",\"\",Voo!O10)","v":"X"},{"$f":"IF($A38=\"-\",\"\",Voo!P10)","v":"65+"},{"$f":"IF($A38=\"-\",\"\",Voo!Q10)","v":11},{"$f":"IF($A38=\"-\",\"\",Voo!R10)","v":"VOOcorder"},{"$f":"IF($A38=\"-\",\"\",Voo!S10)","v":"X"},{"$f":"IF($A38=\"-\",\"\",Voo!T10)","v":"70M"},{"$f":"IF($A38=\"-\",\"\",Voo!U10)","v":"Illimité"},{"$f":"IF($A38=\"-\",\"\",Voo!V10)","v":"-"},{"$f":"IF($A38=\"-\",\"\",Voo!W10)","v":"-"},{"$f":"IF($A38=\"-\",\"\",Voo!X10)","v":"VooFoot"}]
[{"$f":"Voo!L11","v":"Duo TV NET \"Fiber 100\""},{"$f":"IF($A39=\"-\",\"\",Voo!M11)","v":"X"},{"$f":"IF($A39=\"-\",\"\",Voo!N11)","v":"20+"},{"$f":"IF($A39=\"-\",\"\",Voo!O11)","v":"X"},{"$f":"IF($A39=\"-\",\"\",Voo!P11)","v":"65+"},{"$f":"IF($A39=\"-\",\"\",Voo!Q11)","v":11},{"$f":"IF($A39=\"-\",\"\",Voo!R11)","v":"VOOcorder"},{"$f":"IF($A39=\"-\",\"\",Voo!S11)","v":"X"},{"$f":"IF($A39=\"-\",\"\",Voo!T11)","v":"100M"},{"$f":"IF($A39=\"-\",\"\",Voo!U11)","v":"Illimité"},{"$f":"IF($A39=\"-\",\"\",Voo!V11)","v":"-"},{"$f":"IF($A39=\"-\",\"\",Voo!W11)","v":"-"},{"$f":"IF($A39=\"-\",\"\",Voo!X11)","v":"VooFoot"}]
[{"$f":"Voo!L12","v":"-"},{"$f":"IF($A40=\"-\",\"\",Voo!M12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!N12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!O12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!P12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!Q12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!R12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!S12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!T12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!U12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!V12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!W12)","v":""},{"$f":"IF($A40=\"-\",\"\",Voo!X12)","v":""}]
[{"$f":"Voo!L13","v":"-"},{"$f":"IF($A41=\"-\",\"\",Voo!M13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!N13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!O13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!P13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!Q13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!R13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!S13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!T13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!U13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!V13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!W13)","v":""},{"$f":"IF($A41=\"-\",\"\",Voo!X13)","v":""}]
[{"$f":"Voo!L14","v":"-"},{"$f":"IF($A42=\"-\",\"\",Voo!M14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!N14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!O14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!P14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!Q14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!R14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!S14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!T14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!U14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!V14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!W14)","v":""},{"$f":"IF($A42=\"-\",\"\",Voo!X14)","v":""}]
[{"$f":"Voo!L15","v":"-"},{"$f":"IF($A43=\"-\",\"\",Voo!M15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!N15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!O15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!P15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!Q15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!R15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!S15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!T15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!U15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!V15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!W15)","v":""},{"$f":"IF($A43=\"-\",\"\",Voo!X15)","v":""}]
[{"$f":"Voo!L16","v":"-"},{"$f":"IF($A44=\"-\",\"\",Voo!M16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!N16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!O16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!P16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!Q16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!R16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!S16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!T16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!U16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!V16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!W16)","v":""},{"$f":"IF($A44=\"-\",\"\",Voo!X16)","v":""}]

{"sheet":"Overview","index":5,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Numericable",{"$f":"TRANSPOSE(Numericable!C5:C16)","v":"Télédistribution"},"TV Plus (digital)","Duo TV+Web","Triple Play Extra","Triple Play Max","-","-","-","-","-","-","-"]
["Pack Retail price (VAT incl.)",17.809999999999999,27.9,39.9,55.9,69.900000000000006]
["Minus VAT (21%)",-3.0909917355371892,-4.8421487603305771,-6.9247933884297481,-9.7016528925619809,-12.131404958677685]
["Pack Retail price (VAT excl.)",14.71900826446281,23.057851239669422,32.97520661157025,46.198347107438018,57.768595041322321]
["Share of (TV+BB+Rights)",1,0.99999999999999989,1,0.79030184383409485,0.71191066839275785]
["2P equiv. Pack Retail price (VAT excl.)",14.71900826446281,23.057851239669418,32.97520661157025,36.510638901095788,41.126079107978327]
["Minus TV Rights (TVA excl.)",-3.3057851239669422,-4.0495867768595044,-4.0495867768595044,-4.0495867768595044,-4.0495867768595044]
["Minus application base (VAT excl.)",11.413223140495868,19.008264462809912,28.925619834710744,32.461052124236282,37.076492331118821]
["Minus \"Minus\"",-0.2,-0.2,-0.2,-0.2,-0.2]
["Wholesale tariff (VAT excl.)",9.1305785123966938,15.206611570247929,23.140495867768596,25.968841699389028,29.661193864895058]
[]
["Telenet",{"$f":"TRANSPOSE(Telenet!C5:C16)","v":"TV Analogique"},"TV Digitale","Whop","Whoppa","-","-","-","-","-","-","-","-"]
["Pack Retail price (VAT incl.)",15.2,23.4,61.45,71.7]
["Minus VAT (21%)",-2.6380165289256201,-4.0611570247933884,-10.664876033057851,-12.44380165289256]
["Pack Retail price (VAT excl.)",12.561983471074379,19.33884297520661,50.785123966942152,59.256198347107443]
["Share of (TV+BB+Rights)",1,1,0.7771252291885935,0.81728413561761348]
["2P equiv. Pack Retail price (VAT excl.)",12.561983471074379,19.33884297520661,39.466401102181052,48.429150846101564]
["Minus TV Rights (TVA excl.)",-2.6280991735537191,-2.6280991735537191,-2.6280991735537191,-2.6280991735537191]
["Minus application base (VAT excl.)",9.9338842975206596,16.710743801652892,36.838301928627331,45.801051672547842]
["Minus \"Minus\"",-0.3,-0.3,-0.23,-0.23]
["Wholesale tariff (VAT excl.)",6.9537190082644615,11.697520661157023,28.365492485043045,35.266809787861838]
[]
["Voo",{"$f":"TRANSPOSE(Voo!C5:C16)","v":"TV Analogique"},"TV Numérique Interactive","Duo TV NET \"Un peu\"","Duo TV NET \"Beaucoup\"","Duo TV NET \"Passionnement\"","Duo TV NET \"A la folie\"","Duo TV NET \"Fiber 100\"","-","-","-","-","-"]
["Pack Retail price (VAT incl.)",16.86,22.95,40.950000000000003,50.95,60.95,70.95,90.95]
["Minus VAT (21%)",-2.9261157024793381,-3.9830578512396677,-7.1070247933884261,-8.8425619834710716,-10.578099173553717,-12.313636363636363,-15.784710743801654]
["Pack Retail price (VAT excl.)",13.933884297520661,18.966942148760332,33.842975206611577,42.107438016528931,50.371900826446286,58.63636363636364,75.165289256198349]
["Share of (TV+BB+Rights)",1,1,1,1,0.86456896945183315,0.87945170988136068,0.90126816876000904]
["2P equiv. Pack Retail price (VAT excl.)",13.933884297520661,18.966942148760332,33.842975206611577,42.107438016528931,43.549982386850608,51.567850261225246,67.744082602250273]
["Minus TV Rights (TVA excl.)",-2.8016528925619837,-2.8016528925619837,-2.8016528925619837,-2.8016528925619837,-2.8016528925619837,-2.8016528925619837,-2.8016528925619837]
["Minus application base (VAT excl.)",11.132231404958677,16.165289256198349,31.041322314049594,39.305785123966949,40.748329494288626,48.766197368663263,64.942429709688284]
["Minus \"Minus\"",-0.3,-0.3,-0.23,-0.23,-0.23,-0.23,-0.23]
["Wholesale tariff (VAT excl.)",7.7925619834710735,11.315702479338844,23.901818181818189,30.265454545454553,31.376213710602244,37.549971973870711,50.00567087645998]

{"sheet":"Lists","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["Operators","Numericable"]
[null,"Voo - Brutele"]
[null,"Voo - Tecteo"]
[null,"Telenet","operators"]
[]
[]
["Offer types","Analog TV","Analog TV"]
[null,"Digital TV","Digital TV"]
[null,"Dual play","Pack"]
[null,"Triple play","Pack"]
[null,"offer.types","offer.types.minus"]
[]
["Service components","Analog TV"]
[null,"Digital TV"]
[null,"Decoder"]
[null,"TV Rights"]
[null,"Broadband"]
[null,"Telephony"]
[null,"Extra","service.components"]
[]
[null,null,"Numericable","Telenet","Voo"]
["Minus","Analog TV",{"$f":"Cover!C17","v":0.2},{"$f":"Cover!C21","v":0.3},{"$f":"Cover!C25","v":0.3}]
[null,"Digital TV",{"$f":"Cover!C18","v":0.2},{"$f":"Cover!C22","v":0.3},{"$f":"Cover!C26","v":0.3}]
[null,"Pack",{"$f":"Cover!C19","v":0.2},{"$f":"Cover!C23","v":0.23},{"$f":"Cover!C27","v":0.23}]
[null,"minus.name","minus.val.numericable"]