{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Export Pop pour part d'offre","Clusters","Indice offres","Indice EP","Simulateur 2019 NRJ Global"],"not_rendered":{"images":4,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Export Pop pour part d'offre","index":0,"n_rows":85,"n_cols":9,"rows_kept":85,"hidden":true,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,0,5,1],[83,1,83,4],[84,1,84,4]]}
[null,"Offre croisée"]
[null,"Période : du 01 /01 /2017 au 31 /12 /2018"]
[null,"Chaînes : NRJHI NRJ12 CH25"]
[null,"Jours : Lundi, Mardi, Mercredi, Jeudi, Vendredi, Samedi, Dimanche"]
[]
["Total","Total","NRJ 12","CHERIE 25","NRJ Hits"]
["Total","GRP moy -H100000",0.263799,0.200877,null,{"$f":"C7/SUM($C7:$E7)","v":{"v":0.5677052397799758,"d":"57%"}},{"$f":"D7/SUM($C7:$E7)","v":{"v":0.4322947602200243,"d":"43%"}},{"v":0,"d":"0%"},{"$f":"+SUM(F7:H7)","v":{"v":1,"d":"100%"}}]
["Total","GRP moy E49EF",0.262724,0.106472,{"v":0.04767,"d":"0.047670"},{"$f":"C8/SUM($C8:$E8)","v":{"v":0.6302360950521271,"d":"63%"}},{"$f":"D8/SUM($C8:$E8)","v":{"v":0.25541061156342804,"d":"26%"}},{"$f":"E8/SUM($C8:$E8)","v":{"v":0.11435329338444487,"d":"11%"}},{"$f":"+SUM(F8:H8)","v":{"v":1,"d":"100%"}}]
["Total","GRP moy ACTIFS",0.263089,0.152485,0.033041,{"v":0.5864471763093075,"d":"59%"},{"v":0.33990169744658566,"d":"34%"},{"v":0.07365112624410687,"d":"7%"},{"v":1,"d":"100%"}]
["Total","GRP moy CSP+",0.202547,0.108094,0.033731,{"v":0.5881633814595844,"d":"59%"},{"v":0.3138873079112123,"d":"31%"},{"v":0.0979493106292033,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENF11A14",{"v":0.18713,"d":"0.187130"},0.054059,{"v":0.01998,"d":"0.019980"},{"v":0.7165092334848316,"d":"72%"},{"v":0.20698857827690118,"d":"21%"},{"v":0.07650218823826718,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENF4A10",0.081763,{"v":0.03234,"d":"0.032340"},0.034757,{"v":0.5492610506516189,"d":"55%"},{"v":0.21725110842402254,"d":"22%"},{"v":0.23348784092435845,"d":"23%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENF4A14",0.120752,0.040405,0.029199,{"v":0.634348273760743,"d":"63%"},{"v":0.21226018617747802,"d":"21%"},{"v":0.153391540061779,"d":"15%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENF4A14C",0.120665,0.040357,null,{"v":0.7493696513519892,"d":"75%"},{"v":0.2506303486480108,"d":"25%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS1124",0.211987,0.066462,0.028078,{"v":0.6915769247081008,"d":"69%"},{"v":0.21682266162524017,"d":"22%"},{"v":0.09160041366665905,"d":"9%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS15",0.249585,0.191993,0.027942,{"v":0.5315747997955358,"d":"53%"},{"v":0.40891335832339404,"d":"41%"},{"v":0.059511841881070025,"d":"6%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS15-24",{"v":0.22305,"d":"0.223050"},0.071977,0.031766,{"v":0.6825421597157834,"d":"68%"},{"v":0.22025257578956708,"d":"22%"},{"v":0.09720526449464953,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS<35",0.281354,0.080502,0.044414,{"v":0.6925295985428409,"d":"69%"},{"v":0.19814901420237774,"d":"20%"},{"v":0.1093213872547813,"d":"11%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS<50",0.289879,0.121792,0.042117,{"v":0.6387982934762488,"d":"64%"},{"v":0.26838964450360075,"d":"27%"},{"v":0.09281206202015038,"d":"9%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS1559",0.286529,0.155642,0.038373,{"v":0.5962596557235134,"d":"60%"},{"v":0.32388709462609044,"d":"32%"},{"v":0.07985324965039621,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS25-34",0.340321,0.089225,0.057525,{"v":0.6987092230906787,"d":"70%"},{"v":0.1831868454496367,"d":"18%"},{"v":0.11810393145968452,"d":"12%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS2549",0.314949,0.140628,0.046035,{"v":0.6278737350781081,"d":"63%"},{"v":0.2803521446855338,"d":"28%"},{"v":0.09177412023635798,"d":"9%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS2549C",0.314727,0.140329,null,{"v":0.691622569529904,"d":"69%"},{"v":0.30837743047009597,"d":"31%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS2559B",{"v":0.30295,"d":"0.302950"},{"v":0.17729,"d":"0.177290"},null,{"v":0.6308304181242712,"d":"63%"},{"v":0.3691695818757288,"d":"37%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS2559",0.298942,0.176124,0.040107,{"v":0.5802749755907238,"d":"58%"},{"v":0.3418735065696378,"d":"34%"},{"v":0.07785151783963833,"d":"8%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS3549",0.299851,0.170066,0.039441,{"v":0.5886841867605888,"d":"59%"},{"v":0.33388304493107007,"d":"33%"},{"v":0.07743276830834109,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS3559",0.290102,0.207525,0.035888,{"v":0.5437560331012249,"d":"54%"},{"v":0.38897687975033496,"d":"39%"},{"v":0.06726708714844006,"d":"7%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS4",0.230765,0.170102,0.028121,{"v":0.53792879987319,"d":"54%"},{"v":0.39651924995570975,"d":"40%"},{"v":0.06555195017110035,"d":"7%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS5059",0.276953,0.262038,null,{"v":0.5138360380785579,"d":"51%"},{"v":0.48616396192144207,"d":"49%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS25+",{"v":0.25385,"d":"0.253850"},0.211295,0.027323,{"v":0.5154649642210255,"d":"52%"},{"v":0.4290532582827717,"d":"43%"},{"v":0.0554817774962028,"d":"6%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy 35ANS+",0.237475,0.234389,0.021726,{"v":0.48111793188678864,"d":"48%"},{"v":0.4748657792905043,"d":"47%"},{"v":0.044016288822707104,"d":"4%"},{"v":1,"d":"100%"}]
["Total","GRP moy 50ANS+",0.207373,0.265382,0.013243,{"v":0.4266951715850682,"d":"43%"},{"v":0.5460557450853707,"d":"55%"},{"v":0.027249083329561025,"d":"3%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy ENS>60",0.173019,0.267371,0.004634,{"v":0.3887857733515495,"d":"39%"},{"v":0.600801305098152,"d":"60%"},{"v":0.01041292155029841,"d":"1%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy Fm-ef-6a",0.330003,0.109572,null,{"v":0.7507319570039243,"d":"75%"},{"v":0.24926804299607577,"d":"25%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy F2549CS+",0.234899,0.104752,0.046292,{"v":0.6086365084999599,"d":"61%"},{"v":0.27141831824906787,"d":"27%"},{"v":0.1199451732509723,"d":"12%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM2549",{"v":0.35272,"d":"0.352720"},0.172228,0.055405,{"v":0.6077680308364047,"d":"61%"},{"v":0.2967642107475967,"d":"30%"},{"v":0.09546775841599854,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FEM2549C",0.352257,0.171883,{"v":0.05538,"d":"0.055380"},{"v":0.6078426974047487,"d":"61%"},{"v":0.2965954583103258,"d":"30%"},{"v":0.09556184428492545,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FEM3559",0.329433,{"v":0.25839,"d":"0.258390"},0.046689,{"v":0.5191911264089568,"d":"52%"},{"v":0.40722634087298587,"d":"41%"},{"v":0.07358253271805734,"d":"7%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM3559C",{"v":0.32348,"d":"0.323480"},0.255782,0.044835,{"v":0.518316864205404,"d":"52%"},{"v":0.4098433416600305,"d":"41%"},{"v":0.07183979413456563,"d":"7%"},{"v":1.0000000000000002,"d":"100%"}]
["Total","GRP moy FEMMES",0.284504,0.238303,0.037112,{"v":0.50811635254385,"d":"51%"},{"$f":"D40/SUM($C40:$E40)","v":{"v":0.4256026318092438,"d":"43%"}},{"v":0.06628101564690607,"d":"7%"},{"v":0.9999999999999998,"d":"100%"}]
["Total","GRP moy FEM15-24",0.303495,0.087411,0.053041,{"v":0.6836289016481697,"d":"68%"},{"v":0.19689512486850907,"d":"20%"},{"v":0.11947597348332119,"d":"12%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FEM<35",{"v":0.34503,"d":"0.345030"},0.098047,0.063811,{"v":0.680682912201512,"d":"68%"},{"v":0.19342931771910166,"d":"19%"},{"v":0.1258877700793864,"d":"13%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM15-49",0.339344,0.149556,0.054756,{"v":0.6241888252865782,"d":"62%"},{"v":0.27509307356122253,"d":"28%"},{"v":0.10071810115219917,"d":"10%"},{"v":0.9999999999999998,"d":"100%"}]
["Total","GRP moy FEM>25",0.281661,0.260987,0.034696,{"v":0.4878564599268374,"d":"49%"},{"v":0.45204765269925734,"d":"45%"},{"v":0.06009588737390533,"d":"6%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM2534",0.385705,0.108765,0.074515,{"v":0.6778825452340571,"d":"68%"},{"v":0.1911561816216596,"d":"19%"},{"v":0.1309612731442832,"d":"13%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FEM2559",0.339255,0.218045,0.052354,{"v":0.556471375567125,"d":"56%"},{"v":0.35765368553310567,"d":"36%"},{"v":0.08587493889976938,"d":"9%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM3549",0.332859,0.208975,0.044331,{"v":0.567858879325787,"d":"57%"},{"v":0.3565122448457345,"d":"36%"},{"v":0.07562887582847833,"d":"8%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FEM>35",0.262652,{"v":0.28888,"d":"0.288880"},0.027526,{"v":0.4535849604012033,"d":"45%"},{"v":0.4988792141719828,"d":"50%"},{"v":0.04753582542681389,"d":"5%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEM50+",0.230741,0.325321,{"v":0.01991,"d":"0.019910"},{"v":0.40061148805844726,"d":"40%"},{"v":0.5648208593473294,"d":"56%"},{"v":0.03456765259422333,"d":"3%"},{"v":1,"d":"100%"}]
["Total","GRP moy FEMACT",0.293758,0.183029,0.041298,{"v":0.5670073443546908,"d":"57%"},{"v":0.35327986720325816,"d":"35%"},{"v":0.07971278844205101,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy F4-14",0.135875,{"v":0.04222,"d":"0.042220"},0.027816,{"v":0.6598724691735749,"d":"66%"},{"v":0.2050400415713585,"d":"21%"},{"v":0.1350874892550665,"d":"14%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy FOYER",0.416305,0.305975,null,{"v":0.5763761975964999,"d":"58%"},{"v":0.4236238024035,"d":"42%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy GAR4A14",0.106178,0.038654,0.030549,{"v":0.6054133572051705,"d":"61%"},{"v":0.22040015737166516,"d":"22%"},{"v":0.17418648542316445,"d":"17%"},{"v":1.0000000000000002,"d":"100%"}]
["Total","GRP moy HOMMES",0.211501,0.141536,0.017921,{"v":0.5701481030197488,"d":"57%"},{"v":0.3815418457076003,"d":"38%"},{"v":0.04831005127265081,"d":"5%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM<35",0.217541,0.063416,0.024675,{"v":0.7117742906501937,"d":"71%"},{"v":0.20749136216103026,"d":"21%"},{"v":0.08073434718877603,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM<50",0.239187,0.093338,0.029107,{"v":0.6614099415980886,"d":"66%"},{"v":0.2581021591009645,"d":"26%"},{"v":0.08048789930094682,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM2534",0.293559,0.069838,0.039474,{"v":0.7286674890970062,"d":"73%"},{"v":0.17335077481377412,"d":"17%"},{"v":0.09798173608921962,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM2549",0.275491,0.107357,0.036196,{"v":0.6574273823273928,"d":"66%"},{"v":0.2561950535027348,"d":"26%"},{"v":0.08637756416987238,"d":"9%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM2559",0.256606,0.132109,0.027196,{"v":0.616973342854601,"d":"62%"},{"v":0.31763766767409374,"d":"32%"},{"v":0.06538898947130516,"d":"7%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy H3549",0.265581,0.129649,0.034339,{"v":0.6182499202689208,"d":"62%"},{"v":0.3018118160295552,"d":"30%"},{"v":0.0799382637015241,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM3559",0.244613,0.153928,0.023063,{"v":0.5801961081963168,"d":"58%"},{"v":0.3651009003709642,"d":"37%"},{"v":0.05470299143271885,"d":"5%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy HOM<25",0.147224,0.058601,0.011002,{"v":0.6789929298472976,"d":"68%"},{"v":0.27026615689005523,"d":"27%"},{"v":0.05074091326264718,"d":"5%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM>25",0.222817,0.155854,null,{"v":0.5884184423945853,"d":"59%"},{"v":0.4115815576054147,"d":"41%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM>35",0.209275,0.173243,0.015233,{"v":0.5261457545047027,"d":"53%"},{"v":0.4355564159486714,"d":"44%"},{"v":0.0382978295466259,"d":"4%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOM>50",0.180364,{"v":0.19559,"d":"0.195590"},{"v":5.509E-3,"d":"0.005509"},{"v":0.472821741558159,"d":"47%"},{"v":0.512736490826109,"d":"51%"},{"v":0.014441767615732064,"d":"1%"},{"v":1,"d":"100%"}]
["Total","GRP moy HOMACT",0.234454,0.123967,0.025234,{"v":0.6111063325122832,"d":"61%"},{"v":0.3231210332199502,"d":"32%"},{"v":0.06577263426776661,"d":"7%"},{"v":1,"d":"100%"}]
["Total","GRP moy INACTIFS",0.233975,0.237668,null,{"v":0.49608496256702633,"d":"50%"},{"v":0.5039150374329737,"d":"50%"},{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
["Total","GRP moy ENS1134",0.264132,0.075674,0.039815,{"v":0.6957781576888528,"d":"70%"},{"v":0.19934092160338868,"d":"20%"},{"v":0.10488092070775853,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy CSP+2549",0.212284,0.086984,0.037967,{"v":0.629483891055199,"d":"63%"},{"v":0.2579328954586565,"d":"26%"},{"v":0.1125832134861447,"d":"11%"},{"v":1.0000000000000002,"d":"100%"}]
["Total","GRP moy INDCSP+",0.194013,0.106728,{"v":0.02635,"d":"0.026350"},{"v":0.5931468612710225,"d":"59%"},{"v":0.3262945174278718,"d":"33%"},{"v":0.08055862130110582,"d":"8%"},{"v":1,"d":"100%"}]
["Total","GRP moy INCSP-",{"v":0.32443,"d":"0.324430"},0.193144,0.039081,{"v":0.5828205980364858,"d":"58%"},{"v":0.3469725413406868,"d":"35%"},{"v":0.07020686062282742,"d":"7%"},{"v":1,"d":"100%"}]
["Total","GRP moy MEN-ENF",0.267052,0.303358,0.026152,{"$f":"C72/SUM($C72:$E72)","v":{"v":0.4476517109705278,"d":"45%"}},{"$f":"D72/SUM($C72:$E72)","v":{"v":0.508510431438811,"d":"51%"}},{"$f":"E72/SUM($C72:$E72)","v":{"v":0.04383785759066115,"d":"4%"}},{"$f":"+SUM(F72:H72)","v":{"v":1,"d":"100%"}}]
["Total","GRP moy MENAGERE",{"v":0.2838,"d":"0.283800"},0.259179,0.033727,{"v":0.4921051627692447,"d":"49%"},{"v":0.4494126990182173,"d":"45%"},{"v":0.05848213821253811,"d":"6%"},{"v":1,"d":"100%"}]
["Total","GRP moy MEN<50",0.361947,0.170144,0.052433,{"v":0.6192166617623914,"d":"62%"},{"v":0.2910812900753434,"d":"29%"},{"v":0.08970204816226537,"d":"9%"},{"v":1.0000000000000002,"d":"100%"}]
["Total","GRP moy MEN2559",0.346751,0.222322,0.054443,{"v":0.5561220562102657,"d":"56%"},{"v":0.3565618203863253,"d":"36%"},{"v":0.08731612340340905,"d":"9%"},{"v":1,"d":"100%"}]
["Total","GRP moy MEN>50",0.225666,0.325602,0.019914,{"v":0.39508597960019753,"d":"40%"},{"v":0.5700494763490447,"d":"57%"},{"v":0.03486454405075791,"d":"3%"},{"v":1.0000000000000002,"d":"100%"}]
["Total","GRP moy MENENF",0.329403,{"v":0.13872,"d":"0.138720"},0.054528,{"v":0.6302542231814346,"d":"63%"},{"v":0.2654161189780561,"d":"27%"},{"v":0.10432965784050925,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy Mnef-25",0.318034,0.171396,0.052281,{"v":0.5870916411149119,"d":"59%"},{"v":0.3163974886978481,"d":"32%"},{"v":0.09651087018724007,"d":"10%"},{"v":1,"d":"100%"}]
["Total","GRP moy CMen3-8",0.243685,0.102186,0.052083,{"v":0.6123446428481684,"d":"61%"},{"v":0.2567784216266201,"d":"26%"},{"v":0.13087693552521143,"d":"13%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy +100000h",{"v":0.23254,"d":"0.232540"},0.181361,0.029121,{"v":0.5248949262113394,"d":"52%"},{"v":0.4093724465150715,"d":"41%"},{"v":0.06573262727358913,"d":"7%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy PlibCsup",0.138239,0.064435,0.018986,{"v":0.6236533429576828,"d":"62%"},{"v":0.29069295317152394,"d":"29%"},{"v":0.08565370387079309,"d":"9%"},{"v":0.9999999999999999,"d":"100%"}]
["Total","GRP moy RACHA<60",0.355793,0.219852,0.048693,{"v":0.5698724088554598,"d":"57%"},{"v":0.35213618264465724,"d":"35%"},{"v":0.07799140849988308,"d":"8%"},{"v":1.0000000000000002,"d":"100%"}]
[]
[null,"Source : GRP: semestriel Thematik Janvier-Juin 2018(V35) et Med Loc(V1), bimestriel SNPTV / Couv: Médiadata Octobre-Novembre 2012 Médiamétrie"]
[null,"La cible \"25-49 ans PM Conso Pub(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"50-70 ans CSP+ ou retraites CSP+(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ensemble 11-24 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ensemble 15-59 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ensemble 35-49 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Femmes 15 à 49 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Femmes 35 à 49 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Filles 11 a 24 ans(NR CABV15)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Filles 4-14 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Foyer(NR CABV15)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Hommes < 35 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Hommes Actifs(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ind18+ CP Foy Vehineuf(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Individus de 25-59 dans Foyer Conso+(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Men15-49 PM Conso Pub(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ménageres CSP + avec Enfants -25 ans\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ménagères 25-59 dans Foyer Conso+(NR CABSATV19 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\rLa cible \"Ménagères > 50 ans(NR V24 et +)\" n'a pas d'audience sur l'univers Cable sur la période 01/01/2017 - 31/12/2018.\r"]

{"sheet":"Clusters","index":1,"n_rows":39,"n_cols":22,"rows_kept":39,"hidden":true}
["Libellé","Libellé Popcorn","Libellé BO","Cluster","Day","Access","Peak","Night","NRJ12","CH25","NRJ Hits","NRJ12","CH25","NRJ Hits",null,null,"NRJ12","CH25","NRJ Hits","Libellé offre",null,"TH cluster"]
["Femmes RDA avec enfant(s)","MENENF","TV_MEN_ENF","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B2,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6302542231814346,"d":"63%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B2,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.2654161189780561,"d":"27%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B2,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.10432965784050925,"d":"10%"}},"ouiouioui",null,"oui",{"$f":"IF('Simulateur 2019 NRJ Global'!C5=\"Millennials\",\"non disponible\",\"oui\")","v":"oui"},{"$f":"IF('Simulateur 2019 NRJ Global'!C5=\"Mixtes\",\"non disponible\",\"oui\")","v":"oui"},"Global",100,{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$5,Clusters!$D:$H,2,FALSE)","v":85}]
["Femmes 25-49 ans","FEM2549","TV_F25-49","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B3,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6077680308364047,"d":"61%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B3,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.2967642107475967,"d":"30%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B3,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.09546775841599854,"d":"10%"}},"ouiouioui",null,"non",{"$f":"IF('Simulateur 2019 NRJ Global'!C5=\"Millennials\",\"non disponible\",\"non\")","v":"non"},{"$f":"IF('Simulateur 2019 NRJ Global'!C5=\"Mixtes\",\"non disponible\",\"non\")","v":"non"},"Global Plus",105,{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$5,Clusters!$D:$H,3,FALSE)","v":110}]
["Femmes 35-59 ans","FEM3559","TV_F35-59","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B4,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5191911264089568,"d":"52%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B4,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.40722634087298587,"d":"41%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B4,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.07358253271805734,"d":"7%"}},"ouiouioui",null,107,102,95,"Global Max",108,{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$5,Clusters!$D:$H,4,FALSE)","v":130}]
["Femmes 25-59 ans","FEM2559","TV_FEM2559","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B5,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.556471375567125,"d":"56%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B5,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.35765368553310567,"d":"36%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B5,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.08587493889976938,"d":"9%"}},"ouiouioui",null,100,100,100,null,null,{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$5,Clusters!$D:$H,5,FALSE)","v":80}]
["Femmes RDA avec enfant(s) -25 ans","Mnef-25","TV_MEN_E-25","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B6,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5870916411149119,"d":"59%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B6,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.3163974886978481,"d":"32%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B6,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.09651087018724007,"d":"10%"}},"ouiouioui"]
["Femmes RDA -50 ans","MEN<50","TV_MEN15-49","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B7,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6192166617623914,"d":"62%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B7,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.2910812900753434,"d":"29%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B7,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.08970204816226537,"d":"9%"}},"ouiouioui",null,"Offre"]
["Femmes RDA 25-59 ans","MEN2559","TV_MEN_25-59","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B8,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5561220562102657,"d":"56%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B8,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.3565618203863253,"d":"36%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B8,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.08731612340340905,"d":"9%"}},"ouiouioui",null,"NRJ12","CH25","NRJ Hits"]
["Femmes 35-49 ans","FEM3549","TV_F35-49","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B9,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.567858879325787,"d":"57%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B9,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.3565122448457345,"d":"36%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B9,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.07562887582847833,"d":"8%"}},"ouiouioui",{"$f":"'Simulateur 2019 NRJ Global'!$C$3","v":"Femmes 25-49 ans"},{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$3,Clusters!$A:$N,12,FALSE)","v":{"v":0.6077680308364047,"d":"61%"}},{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$3,Clusters!$A:$N,13,FALSE)","v":{"v":0.2967642107475967,"d":"30%"}},{"$f":"VLOOKUP('Simulateur 2019 NRJ Global'!$C$3,Clusters!$A:$N,14,FALSE)","v":{"v":0.09546775841599854,"d":"10%"}}]
["Femmes RDA","MENAGERE","TV_MEN","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B10,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.4921051627692447,"d":"49%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B10,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.4494126990182173,"d":"45%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B10,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.05848213821253811,"d":"6%"}},"ouiouioui","Selection chaînes",{"$f":"'Simulateur 2019 NRJ Global'!C15","v":"oui"},{"$f":"'Simulateur 2019 NRJ Global'!D15","v":"oui"},{"$f":"'Simulateur 2019 NRJ Global'!E15","v":"oui"}]
["Femmes 25 ans et +","FEM>25","TV_FEM>25","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B11,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.4878564599268374,"d":"49%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B11,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.45204765269925734,"d":"45%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B11,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.06009588737390533,"d":"6%"}},"ouiouioui",null,{"$f":"IF(OR(Q10=\"non disponible\",Q10=\"non\"),0,Q9)","v":{"v":0.6077680308364047,"d":"61%"}},{"$f":"IF(OR(R10=\"non disponible\",R10=\"non\"),0,R9)","v":{"v":0.2967642107475967,"d":"30%"}},{"$f":"IF(OR(S10=\"non disponible\",S10=\"non\"),0,S9)","v":{"v":0.09546775841599854,"d":"10%"}}]
["Femmes avec enfant(s) -6 ans","Fm-ef-6a","TV_Fm-ef-6a","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B12,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.7507319570039243,"d":"75%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B12,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.24926804299607577,"d":"25%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B12,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0,"d":"0%"}},"ouiouioui","Offre résultante",{"$f":"IFERROR(Q11/SUM($Q$11:$S$11),\"% incorrects\")","v":{"v":0.6077680308364048,"d":"61%"}},{"$f":"IFERROR(R11/SUM($Q$11:$S$11),\"% incorrects\")","v":{"v":0.29676421074759674,"d":"30%"}},{"$f":"IFERROR(S11/SUM($Q$11:$S$11),\"% incorrects\")","v":{"v":0.09546775841599855,"d":"10%"}}]
["Femmes avec enfant(s) 3-8 ans","CMen3-8","TV_CMen3-8","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B13,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6123446428481684,"d":"61%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B13,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.2567784216266201,"d":"26%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B13,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.13087693552521143,"d":"13%"}},"ouiouioui"]
["Femmes 15-49 ans","FEM15-49","TV_F15-49","Femmes",85,110,130,80,"R","R","R",{"$f":"VLOOKUP(\"GRP moy \"&$B14,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6241888252865782,"d":"62%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B14,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.27509307356122253,"d":"28%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B14,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.10071810115219917,"d":"10%"}},"ouiouioui"]
["Femmes 15-34 ans","FEM<35","TV_F15-34","Millennials",85,130,110,80,"R","X","R",{"$f":"VLOOKUP(\"GRP moy \"&$B15,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.680682912201512,"d":"68%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B15,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.19342931771910166,"d":"19%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B15,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.1258877700793864,"d":"13%"}},"ouinon disponibleoui"]
["Femmes 25-34 ans","FEM2534","TV_F25-34","Millennials",85,130,110,80,"R","X","R",{"$f":"VLOOKUP(\"GRP moy \"&$B16,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6778825452340571,"d":"68%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B16,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.1911561816216596,"d":"19%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B16,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.1309612731442832,"d":"13%"}},"ouinon disponibleoui"]
["Individus 15-34 ans","ENS<35","TV_ENS15-34","Millennials",85,130,110,80,"R","X","R",{"$f":"VLOOKUP(\"GRP moy \"&$B17,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6925295985428409,"d":"69%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B17,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.19814901420237774,"d":"20%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B17,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.1093213872547813,"d":"11%"}},"ouinon disponibleoui"]
["Individus 25-34 ans","ENS25-34","TV_ENS25-34","Millennials",85,130,110,80,"R","X","R",{"$f":"VLOOKUP(\"GRP moy \"&$B18,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6987092230906787,"d":"70%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B18,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.1831868454496367,"d":"18%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B18,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.11810393145968452,"d":"12%"}},"ouinon disponibleoui"]
["Femmes 15-24 ans","FEM15-24","TV_F15-24","Millennials",85,130,110,80,"R","X","R",{"$f":"VLOOKUP(\"GRP moy \"&$B19,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6836289016481697,"d":"68%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B19,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.19689512486850907,"d":"20%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B19,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.11947597348332119,"d":"12%"}},"ouinon disponibleoui"]
["Individus 25-49 ans","ENS2549","TV_ENS25-49","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B20,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6278737350781081,"d":"63%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B20,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.2803521446855338,"d":"28%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B20,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.09177412023635798,"d":"9%"}},"ouiouinon disponible"]
["Individus 25-59 ans","ENS2559","TV_ENS2559","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B21,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5802749755907238,"d":"58%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B21,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.3418735065696378,"d":"34%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B21,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.07785151783963833,"d":"8%"}},"ouiouinon disponible"]
["Individus 35-59 ans","ENS3559","TV_ENS35-59","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B22,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5437560331012249,"d":"54%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B22,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.38897687975033496,"d":"39%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B22,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.06726708714844006,"d":"7%"}},"ouiouinon disponible"]
["RDA < 60 ans","RACHA<60","TV_RDA15-59","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B23,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5698724088554598,"d":"57%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B23,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.35213618264465724,"d":"35%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B23,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.07799140849988308,"d":"8%"}},"ouiouinon disponible"]
["Individus 15-49 ans","ENS<50","TV_ENS15-49","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B24,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.6387982934762488,"d":"64%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B24,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.26838964450360075,"d":"27%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B24,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.09281206202015038,"d":"9%"}},"ouiouinon disponible"]
["Individus 35-49 ans","ENS3549","TV_ENS35-49","Mixtes",85,110,130,80,"R","R","X",{"$f":"VLOOKUP(\"GRP moy \"&$B25,'Export Pop pour part d''offre'!$B:$G,5,FALSE)","v":{"v":0.5886841867605888,"d":"59%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B25,'Export Pop pour part d''offre'!$B:$G,6,FALSE)","v":{"v":0.33388304493107007,"d":"33%"}},{"$f":"VLOOKUP(\"GRP moy \"&$B25,'Export Pop pour part d''offre'!$B:$H,7,FALSE)","v":{"v":0.07743276830834109,"d":"8%"}},"ouiouinon disponible"]
["Individus 15-24 ans","ENS15-24","TV_ENS15-24","Non garantie"]
["Hommes 15-34 ans","HOM<35","TV_H15-34","Non garantie"]
["Actifs","ACTIFS","TV_ACTIF","Non garantie"]
["Parents avec enfant(s) 4-9 ans","E49EF","TV_E49EF","Non garantie"]
["Individus 25-49 ans CSP+","CSP+2549","TV_25-49CSP+","Non garantie"]
["Hommes 15-24 ans","HOM<25","TV_H15-24","Non garantie"]
["Femmes 25-49 ans CSP+","F2549CS+","TV_F25-49CSP+","Non garantie"]
["Hommes 25-49 ans","HOM2549","TV_H25-49","Non garantie"]
["Hommes 25-34 ans","HOM2534","TV_H25-34","Non garantie"]
["Individus CSP+","CSP+","TV_CSP+","Non garantie"]
["Enfants 11-14 ans","ENF11A14","TV_E11-14","Non garantie"]
["Individus 50 ans et +","50ANS+","TV_ENS50+","Non garantie"]
["Femmes 50 ans et +","FEM50+","TV_FEM50+","Non garantie"]
["Individus 35 ans et +","35ANS+","TV_ENS35+","Non garantie"]

{"sheet":"Indice offres","index":2,"n_rows":5,"n_cols":16,"rows_kept":5,"hidden":true}
[null,"P1","P2","P3","P4","P5","P6","P7","P8","P9","P10","P11","P12","P13","P14","P15"]
["Poids Prime",{"$f":"IF(OR('Simulateur 2019 NRJ Global'!C30<>\"\",AND('Simulateur 2019 NRJ Global'!C30=\"\",SUM('Simulateur 2019 NRJ Global'!C28:C31)<>0)),IF('Simulateur 2019 NRJ Global'!C30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!C30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!D30<>\"\",AND('Simulateur 2019 NRJ Global'!D30=\"\",SUM('Simulateur 2019 NRJ Global'!D28:D31)<>0)),IF('Simulateur 2019 NRJ Global'!D30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!D30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!E30<>\"\",AND('Simulateur 2019 NRJ Global'!E30=\"\",SUM('Simulateur 2019 NRJ Global'!E28:E31)<>0)),IF('Simulateur 2019 NRJ Global'!E30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!E30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!F30<>\"\",AND('Simulateur 2019 NRJ Global'!F30=\"\",SUM('Simulateur 2019 NRJ Global'!F28:F31)<>0)),IF('Simulateur 2019 NRJ Global'!F30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!F30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!G30<>\"\",AND('Simulateur 2019 NRJ Global'!G30=\"\",SUM('Simulateur 2019 NRJ Global'!G28:G31)<>0)),IF('Simulateur 2019 NRJ Global'!G30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!G30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!H30<>\"\",AND('Simulateur 2019 NRJ Global'!H30=\"\",SUM('Simulateur 2019 NRJ Global'!H28:H31)<>0)),IF('Simulateur 2019 NRJ Global'!H30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!H30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!I30<>\"\",AND('Simulateur 2019 NRJ Global'!I30=\"\",SUM('Simulateur 2019 NRJ Global'!I28:I31)<>0)),IF('Simulateur 2019 NRJ Global'!I30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!I30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!J30<>\"\",AND('Simulateur 2019 NRJ Global'!J30=\"\",SUM('Simulateur 2019 NRJ Global'!J28:J31)<>0)),IF('Simulateur 2019 NRJ Global'!J30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!J30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!K30<>\"\",AND('Simulateur 2019 NRJ Global'!K30=\"\",SUM('Simulateur 2019 NRJ Global'!K28:K31)<>0)),IF('Simulateur 2019 NRJ Global'!K30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!K30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!L30<>\"\",AND('Simulateur 2019 NRJ Global'!L30=\"\",SUM('Simulateur 2019 NRJ Global'!L28:L31)<>0)),IF('Simulateur 2019 NRJ Global'!L30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!L30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!M30<>\"\",AND('Simulateur 2019 NRJ Global'!M30=\"\",SUM('Simulateur 2019 NRJ Global'!M28:M31)<>0)),IF('Simulateur 2019 NRJ Global'!M30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!M30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!N30<>\"\",AND('Simulateur 2019 NRJ Global'!N30=\"\",SUM('Simulateur 2019 NRJ Global'!N28:N31)<>0)),IF('Simulateur 2019 NRJ Global'!N30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!N30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!O30<>\"\",AND('Simulateur 2019 NRJ Global'!O30=\"\",SUM('Simulateur 2019 NRJ Global'!O28:O31)<>0)),IF('Simulateur 2019 NRJ Global'!O30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!O30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!P30<>\"\",AND('Simulateur 2019 NRJ Global'!P30=\"\",SUM('Simulateur 2019 NRJ Global'!P28:P31)<>0)),IF('Simulateur 2019 NRJ Global'!P30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!P30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""},{"$f":"IF(OR('Simulateur 2019 NRJ Global'!Q30<>\"\",AND('Simulateur 2019 NRJ Global'!Q30=\"\",SUM('Simulateur 2019 NRJ Global'!Q28:Q31)<>0)),IF('Simulateur 2019 NRJ Global'!Q30<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!Q30<=0.4,Clusters!$T$3,Clusters!$T$4)),\"\")","v":""}]
["EP",{"$f":"IF('Simulateur 2019 NRJ Global'!C38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!C38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!C38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!D38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!D38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!D38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!E38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!E38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!E38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!F38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!F38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!F38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!G38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!G38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!G38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!H38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!H38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!H38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!I38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!I38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!I38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!J38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!J38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!J38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!K38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!K38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!K38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!L38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!L38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!L38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!M38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!M38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!M38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!N38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!N38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!N38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!O38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!O38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!O38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!P38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!P38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!P38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!Q38=\"\",\"\",IF('Simulateur 2019 NRJ Global'!Q38<=0.2,Clusters!$T$2,IF('Simulateur 2019 NRJ Global'!Q38<=0.4,Clusters!$T$3,Clusters!$T$4)))","v":""}]
["Synthèse",{"$f":"IF(AND(B2=\"\",B3=\"\"),\"\",IF(OR(B2=\"Global Max\",B3=\"Global Max\"),\"Global Max\",IF(OR(B2=\"Global Plus\",B3=\"Global Plus\"),\"Global Plus\",\"Global\")))","v":""},{"$f":"IF(AND(C2=\"\",C3=\"\"),\"\",IF(OR(C2=\"Global Max\",C3=\"Global Max\"),\"Global Max\",IF(OR(C2=\"Global Plus\",C3=\"Global Plus\"),\"Global Plus\",\"Global\")))","v":""},"","","","","","","","","","","","",""]
["Indices",{"$f":"IFERROR(VLOOKUP(B4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P4,Clusters!$T$2:$U$4,2,FALSE),\"\")","v":""}]

{"sheet":"Indice EP","index":3,"n_rows":3,"n_cols":15,"rows_kept":3,"hidden":true}
["du 1er janvier \nau 6 janvier","du 7 janvier \nau 10 février","du 11 février \nau 10 mars","du 11 mars \nau 7 avril","du 8 avril  \nau 28 avril","du 29 avril \nau 12 mai","du 13 mai \nau 30 juin","du 1er juillet \nau 14 juillet","du 15 juillet \nau 28 juillet","du 29 juillet \nau 18 août","du 19 août \nau 1er septembre","du 2 septembre au 20 octobre","du 21 octobre au 3 novembre","du 4 novembre au 22 décembre","du 23 décembre au 31 décembre"]
[{"$f":"IF('Simulateur 2019 NRJ Global'!C38=\"\",\"\",'Simulateur 2019 NRJ Global'!C38*102+(1-'Simulateur 2019 NRJ Global'!C38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!D38=\"\",\"\",'Simulateur 2019 NRJ Global'!D38*102+(1-'Simulateur 2019 NRJ Global'!D38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!E38=\"\",\"\",'Simulateur 2019 NRJ Global'!E38*102+(1-'Simulateur 2019 NRJ Global'!E38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!F38=\"\",\"\",'Simulateur 2019 NRJ Global'!F38*102+(1-'Simulateur 2019 NRJ Global'!F38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!G38=\"\",\"\",'Simulateur 2019 NRJ Global'!G38*102+(1-'Simulateur 2019 NRJ Global'!G38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!H38=\"\",\"\",'Simulateur 2019 NRJ Global'!H38*102+(1-'Simulateur 2019 NRJ Global'!H38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!I38=\"\",\"\",'Simulateur 2019 NRJ Global'!I38*102+(1-'Simulateur 2019 NRJ Global'!I38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!J38=\"\",\"\",'Simulateur 2019 NRJ Global'!J38*102+(1-'Simulateur 2019 NRJ Global'!J38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!K38=\"\",\"\",'Simulateur 2019 NRJ Global'!K38*102+(1-'Simulateur 2019 NRJ Global'!K38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!L38=\"\",\"\",'Simulateur 2019 NRJ Global'!L38*102+(1-'Simulateur 2019 NRJ Global'!L38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!M38=\"\",\"\",'Simulateur 2019 NRJ Global'!M38*102+(1-'Simulateur 2019 NRJ Global'!M38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!N38=\"\",\"\",'Simulateur 2019 NRJ Global'!N38*102+(1-'Simulateur 2019 NRJ Global'!N38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!O38=\"\",\"\",'Simulateur 2019 NRJ Global'!O38*102+(1-'Simulateur 2019 NRJ Global'!O38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!P38=\"\",\"\",'Simulateur 2019 NRJ Global'!P38*102+(1-'Simulateur 2019 NRJ Global'!P38)*100)","v":""},{"$f":"IF('Simulateur 2019 NRJ Global'!Q38=\"\",\"\",'Simulateur 2019 NRJ Global'!Q38*102+(1-'Simulateur 2019 NRJ Global'!Q38)*100)","v":""}]
[{"$f":"IF(AND('Simulateur 2019 NRJ Global'!C32<>\"\",'Simulateur 2019 NRJ Global'!C38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!D32<>\"\",'Simulateur 2019 NRJ Global'!D38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!E32<>\"\",'Simulateur 2019 NRJ Global'!E38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!F32<>\"\",'Simulateur 2019 NRJ Global'!F38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!G32<>\"\",'Simulateur 2019 NRJ Global'!G38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!H32<>\"\",'Simulateur 2019 NRJ Global'!H38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!I32<>\"\",'Simulateur 2019 NRJ Global'!I38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!J32<>\"\",'Simulateur 2019 NRJ Global'!J38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!K32<>\"\",'Simulateur 2019 NRJ Global'!K38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!L32<>\"\",'Simulateur 2019 NRJ Global'!L38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!M32<>\"\",'Simulateur 2019 NRJ Global'!M38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!N32<>\"\",'Simulateur 2019 NRJ Global'!N38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!O32<>\"\",'Simulateur 2019 NRJ Global'!O38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!P32<>\"\",'Simulateur 2019 NRJ Global'!P38=\"\"),1,0)","v":0},{"$f":"IF(AND('Simulateur 2019 NRJ Global'!Q32<>\"\",'Simulateur 2019 NRJ Global'!Q38=\"\"),1,0)","v":0}]

{"sheet":"Simulateur 2019 NRJ Global","index":4,"n_rows":53,"n_cols":17,"rows_kept":53,"merged":[[2,2,2,4],[2,7,2,8],[44,3,44,4],[45,3,45,4]]}
[null,"Simulateur 2019 - Ct GRP net net garanti"]
[]
[null,"Cible:","Femmes 25-49 ans",{"$nulls":3},"Annonceur:"]
[]
[null,"Cluster cible garantie:",{"$f":"VLOOKUP(C3,Clusters!$A:$D,4,FALSE)","v":"Femmes"}]
[]
[null,"Ct GRP base 100:"]
[]
[]
[null,"Sélection des chaînes définie par la régie, sinon précisez:"]
[]
[]
[]
[null,"Disponibilité",{"$f":"VLOOKUP($C$3,Clusters!$A:$M,9,FALSE)","v":"R"},{"$f":"VLOOKUP($C$3,Clusters!$A:$M,10,FALSE)","v":"R"},{"$f":"VLOOKUP($C$3,Clusters!$A:$M,11,FALSE)","v":"R"}]
[null,"Sélection chaîne (oui/non)","oui","oui","oui"]
[null,"Indices",{"$f":"IF(C15=\"oui\",IF(VLOOKUP($C$3,Clusters!$A:$O,15,FALSE)=CONCATENATE('Simulateur 2019 NRJ Global'!$C$15,'Simulateur 2019 NRJ Global'!$D$15,'Simulateur 2019 NRJ Global'!$E$15),Clusters!Q5,Clusters!Q4),\"-\")","v":100},{"$f":"IF(D15=\"oui\",IF(VLOOKUP($C$3,Clusters!$A:$O,15,FALSE)=CONCATENATE('Simulateur 2019 NRJ Global'!$C$15,'Simulateur 2019 NRJ Global'!$D$15,'Simulateur 2019 NRJ Global'!$E$15),Clusters!R5,Clusters!R4),\"-\")","v":100},{"$f":"IF(E15=\"oui\",IF(VLOOKUP($C$3,Clusters!$A:$O,15,FALSE)=CONCATENATE('Simulateur 2019 NRJ Global'!$C$15,'Simulateur 2019 NRJ Global'!$D$15,'Simulateur 2019 NRJ Global'!$E$15),Clusters!S5,Clusters!S4),\"-\")","v":100}]
[null,"% GRP",{"$f":"Clusters!Q12","v":{"v":0.6077680308364048,"d":"61%"}},{"$f":"Clusters!R12","v":{"v":0.29676421074759674,"d":"30%"}},{"$f":"Clusters!S12","v":{"v":0.09546775841599855,"d":"10%"}}]
[]
[null,"Indice chaînes:",{"$f":"IF(CONCATENATE(C15,D15,E15)=VLOOKUP(C3,Clusters!$A:$O,15,FALSE),100,SUMPRODUCT(C16:E16,C17:E17))","v":{"v":100,"d":"100.0"}}]
[]
[null,"Poids par période (% GRP):",null,{"$f":"IF(SUM(C24:Q24)=0,\"\",SUM(C24:Q24))","v":""}]
[null,"Période","P1 :\ndu 1er janvier \nau 6 janvier","P2: \ndu 7 janvier \nau 10 février","P3: \ndu 11 février \nau 10 mars","P4: \ndu 11 mars \nau 7 avril","P5: \ndu 8 avril  \nau 28 avril","P6: \ndu 29 avril \nau 12 mai","P7: \ndu 13 mai \nau 30 juin","P8: \ndu 1er juillet \nau 14 juillet","P9: \ndu 15 juillet \nau 28 juillet","P10: \ndu 29 juillet \nau 18 août","P11: \ndu 19 août au \n1er septembre","P12: \ndu 2 septembre \nau 20 octobre","P13: \ndu 21 octobre \nau 3 novembre","P14: \ndu 4 novembre\nau 22 décembre","P15: \ndu 23 décembre \nau 31 décembre"]
[null,"Indices",85,90,90,105,100,100,120,100,70,65,100,120,120,120,85]
[null,"% GRP"]
[]
[null,"Poids par tranche horaire (% GRP):"]
[null,"Tranche horaire","P1 :\ndu 1er janvier \nau 6 janvier","P2: \ndu 7 janvier \nau 10 février","P3: \ndu 11 février \nau 10 mars","P4: \ndu 11 mars \nau 7 avril","P5: \ndu 8 avril  \nau 28 avril","P6: \ndu 29 avril \nau 12 mai","P7: \ndu 13 mai \nau 30 juin","P8: \ndu 1er juillet \nau 14 juillet","P9: \ndu 15 juillet \nau 28 juillet","P10: \ndu 29 juillet \nau 18 août","P11: \ndu 19 août au \n1er septembre","P12: \ndu 2 septembre \nau 20 octobre","P13: \ndu 21 octobre \nau 3 novembre","P14: \ndu 4 novembre\nau 22 décembre","P15: \ndu 23 décembre \nau 31 décembre"]
[null,{"$f":"\"Day (\"&Clusters!V2&\")\"","v":"Day (85)"}]
[null,{"$f":"\"Access (\"&Clusters!V3&\")\"","v":"Access (110)"}]
[null,{"$f":"\"Peak (\"&Clusters!V4&\")\"","v":"Peak (130)"}]
[null,{"$f":"\"Night (\"&Clusters!V5&\")\"","v":"Night (80)"}]
[null,"TOTAL tranches",{"$f":"IF(OR(C24=\"\",C24=0),\"\",SUM(C28:C31))","v":""},{"$f":"IF(OR(D24=\"\",D24=0),\"\",SUM(D28:D31))","v":""},"","","","","","","","","","","","",""]
[null,"Offre déclenchée",{"$f":"'Indice offres'!B4","v":""},{"$f":"'Indice offres'!C4","v":""},{"$f":"'Indice offres'!D4","v":""},{"$f":"'Indice offres'!E4","v":""},{"$f":"'Indice offres'!F4","v":""},{"$f":"'Indice offres'!G4","v":""},{"$f":"'Indice offres'!H4","v":""},{"$f":"'Indice offres'!I4","v":""},{"$f":"'Indice offres'!J4","v":""},{"$f":"'Indice offres'!K4","v":""},{"$f":"'Indice offres'!L4","v":""},{"$f":"'Indice offres'!M4","v":""},{"$f":"'Indice offres'!N4","v":""},{"$f":"'Indice offres'!O4","v":""},{"$f":"'Indice offres'!P4","v":""}]
[]
[null,"Indice mediaplanning:",{"$f":"IFERROR(IF(OR(D21<>1,AVERAGE(C32:Q32)<>1),\"% incorrects\",SUM(C49:Q52)*100),\"\")","v":""}]
[]
[null,"Poids d'EP:"]
[null,"% d'EP 6 positions (102):"]
[null,"Offre déclenchée",{"$f":"'Indice offres'!B4","v":""},{"$f":"'Indice offres'!C4","v":""},{"$f":"'Indice offres'!D4","v":""},{"$f":"'Indice offres'!E4","v":""},{"$f":"'Indice offres'!F4","v":""},{"$f":"'Indice offres'!G4","v":""},{"$f":"'Indice offres'!H4","v":""},{"$f":"'Indice offres'!I4","v":""},{"$f":"'Indice offres'!J4","v":""},{"$f":"'Indice offres'!K4","v":""},{"$f":"'Indice offres'!L4","v":""},{"$f":"'Indice offres'!M4","v":""},{"$f":"'Indice offres'!N4","v":""},{"$f":"'Indice offres'!O4","v":""},{"$f":"'Indice offres'!P4","v":""}]
[]
[null,"Indice EP:",{"$f":"IF(IF(SUM('Indice EP'!A3:O3)<>0,\"% incorrects\",SUMPRODUCT(C24:Q24,'Indice EP'!A2:O2))=0,\"\",IF(SUM('Indice EP'!A3:O3)<>0,\"% incorrects\",SUMPRODUCT(C24:Q24,'Indice EP'!A2:O2)))","v":""}]
[]
[null,"Indice offres:",{"$f":"SUMPRODUCT(C24:Q24,'Indice offres'!B5:P5)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Ct GRP net net indicé 2019:",{"$f":"IFERROR(C7*C19*C35*C41/1000000,\"-\")","v":"-"},"sans indice offres"]
[null,"Ct GRP net net indicé 2019:",{"$f":"IFERROR(C7*C19*C35*C41*C43/100000000,\"-\")","v":"-"},"avec indice offres"]
[]
[null,"Ventilation * Indices","du 1er janvier \nau 6 janvier","du 7 janvier \nau 10 février","du 11 février \nau 10 mars","du 11 mars \nau 7 avril","du 8 avril  \nau 28 avril","du 29 avril \nau 12 mai","du 13 mai \nau 30 juin","du 1er juillet \nau 14 juillet","du 15 juillet \nau 28 juillet","du 29 juillet \nau 18 août","du 19 août \nau 1er septembre","du 2 septembre au 20 octobre","du 21 octobre au 3 novembre","du 4 novembre au 22 décembre","du 23 décembre au 31 décembre"]
[null,"Day",{"$f":"C$24*C28*Clusters!$V2*C$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"D$24*D28*Clusters!$V2*D$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"E$24*E28*Clusters!$V2*E$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"F$24*F28*Clusters!$V2*F$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"G$24*G28*Clusters!$V2*G$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"H$24*H28*Clusters!$V2*H$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"I$24*I28*Clusters!$V2*I$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"J$24*J28*Clusters!$V2*J$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"K$24*K28*Clusters!$V2*K$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"L$24*L28*Clusters!$V2*L$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"M$24*M28*Clusters!$V2*M$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"N$24*N28*Clusters!$V2*N$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"O$24*O28*Clusters!$V2*O$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"P$24*P28*Clusters!$V2*P$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"Q$24*Q28*Clusters!$V2*Q$23/10000","v":{"v":0,"d":"0.00"}}]
[null,"Access",{"$f":"C$24*C29*Clusters!$V3*C$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"D$24*D29*Clusters!$V3*D$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"E$24*E29*Clusters!$V3*E$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"F$24*F29*Clusters!$V3*F$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"G$24*G29*Clusters!$V3*G$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"H$24*H29*Clusters!$V3*H$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"I$24*I29*Clusters!$V3*I$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"J$24*J29*Clusters!$V3*J$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"K$24*K29*Clusters!$V3*K$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"L$24*L29*Clusters!$V3*L$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"M$24*M29*Clusters!$V3*M$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"N$24*N29*Clusters!$V3*N$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"O$24*O29*Clusters!$V3*O$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"P$24*P29*Clusters!$V3*P$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"Q$24*Q29*Clusters!$V3*Q$23/10000","v":{"v":0,"d":"0.00"}}]
[null,"Peak",{"$f":"C$24*C30*Clusters!$V4*C$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"D$24*D30*Clusters!$V4*D$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"E$24*E30*Clusters!$V4*E$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"F$24*F30*Clusters!$V4*F$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"G$24*G30*Clusters!$V4*G$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"H$24*H30*Clusters!$V4*H$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"I$24*I30*Clusters!$V4*I$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"J$24*J30*Clusters!$V4*J$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"K$24*K30*Clusters!$V4*K$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"L$24*L30*Clusters!$V4*L$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"M$24*M30*Clusters!$V4*M$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"N$24*N30*Clusters!$V4*N$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"O$24*O30*Clusters!$V4*O$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"P$24*P30*Clusters!$V4*P$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"Q$24*Q30*Clusters!$V4*Q$23/10000","v":{"v":0,"d":"0.00"}}]
[null,"Night",{"$f":"C$24*C31*Clusters!$V5*C$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"D$24*D31*Clusters!$V5*D$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"E$24*E31*Clusters!$V5*E$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"F$24*F31*Clusters!$V5*F$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"G$24*G31*Clusters!$V5*G$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"H$24*H31*Clusters!$V5*H$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"I$24*I31*Clusters!$V5*I$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"J$24*J31*Clusters!$V5*J$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"K$24*K31*Clusters!$V5*K$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"L$24*L31*Clusters!$V5*L$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"M$24*M31*Clusters!$V5*M$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"N$24*N31*Clusters!$V5*N$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"O$24*O31*Clusters!$V5*O$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"P$24*P31*Clusters!$V5*P$23/10000","v":{"v":0,"d":"0.00"}},{"$f":"Q$24*Q31*Clusters!$V5*Q$23/10000","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},"Données arrondies à l'euro. Le simulateur n’a en aucun cas une valeur contractuelle, toute demande de réservation sera soumise à la validation de NRJ GLOBAL."]