{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SIMULATION COUT GRP M6","CALCULS M6","SIMULATION COUT GRP PTNT","CALCULS PTNT","INDICES"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SIMULATION COUT GRP M6","index":0,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,13,18,13],[8,11,10,11],[3,3,3,6],[1,1,1,14],[13,0,13,2],[3,8,3,11],[8,1,9,1],[17,11,18,11],[17,1,18,1],[28,1,28,2],[28,4,28,5],[28,7,28,8],[28,10,28,11],[25,4,25,5],[25,7,25,8],[25,10,25,11],[26,4,26,5],[26,7,26,8],[26,10,26,11],[48,1,53,1],[55,1,60,1],[29,4,29,5],[29,7,29,8],[33,4,33,5],[35,4,35,5],[35,7,35,8],[35,10,35,11],[33,1,33,2],[35,1,35,2],[29,10,29,11],[41,1,46,1]]}
[]
[null,"CALCULETTE COUT GRP GARANTI 2022 - M6"]
[]
[null,"CIBLE :",null,"Femmes 25-34 ans",null,null,null,null,{"$f":"IF(VLOOKUP(D4,INDICES!B:E,4,FALSE)=\"\",\"\",(VLOOKUP(D4,INDICES!B:E,4,FALSE)))","v":""}]
[]
[null,"CHOIX MEDIAPLANNING"]
[null,"1. Saisir la répartition par période en GRP"]
[]
[null,"SAISONNALITE",null,"2022-01-01","2022-03-07","2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,"2022-03-06","2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,"Indices saisonnalité (CGV 2022)",null,92,108,102,120,90,75,130,90]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:K13)","v":0}]
[]
[null,"2. Saisir la répartition en GRP par tranche horaire sur chaque période"]
[null,"NB : maximum de 75% des GRP à délivrer dans une même Day Part"]
[]
[null,"TRANCHES HORAIRES",null,{"$f":"D9","v":"2022-01-01"},{"$f":"E9","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année",null,"Indices TH\n(CGV 2022)"]
[null,null,null,{"$f":"D10","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,"Day (0300-1799)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D20:K20)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,2))","v":90}]
[null,"Access (1800-1999)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D21:K21)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,3))","v":100}]
[null,"Peak (2000-2199)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D22:K22)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,4))","v":145}]
[null,"Night (2200-2699)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D23:K23)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,5))","v":85}]
[null,"Ensemble journée (0300 - 2699)",null,{"$f":"SUM(D20:D23)","v":0},{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},0,{"$f":"SUM(H20:H23)","v":0},{"$f":"SUM(I20:I23)","v":0},0,{"$f":"SUM(K20:K23)","v":0},{"$f":"SUM(L20:L23)","v":0}]
[null,null,null,{"$f":"IF(OR(D20>75%,D21>75%,D22>75%, D23>75%),\" max 75%\",\"\")","v":""},{"$f":"IF(OR(E20>75%,E21>75%,E22>75%, E23>75%),\" max 75%\",\"\")","v":""},"","",{"$f":"IF(OR(H20>75%,H21>75%,H22>75%, H23>75%),\" max 75%\",\"\")","v":""},{"$f":"IF(OR(I20>75%,I21>75%,I22>75%, I23>75%),\" max 75%\",\"\")","v":""},"",""]
[null,null,null,null,"STANDARD",null,null,"SELECT",null,null,"SELECT +"]
[null,null,null,null,100,null,null,105,null,null,108]
[]
[null,"INDICE CHOIX MEDIAPLANNING ANNONCEUR",null,null,{"$f":"IF(D4=0,\"-\",IF(D4=\"Enfants 4-10 ans\",100,IF(L13<>1,\"-\",IF(L24<>1,\"-\",'CALCULS M6'!L36))))","v":"-"},null,null,{"$f":"IF($D$4=0,\"-\",IF($D$4=\"Enfants 4-10 ans\",$E$29*H27/100,IF($L$13<>1,\"-\",IF($L$24<>1,\"-\",$E$29*H27/100))))","v":"-"},null,null,{"$f":"IF($D$4=0,\"-\",IF($D$4=\"Enfants 4-10 ans\",$E$29*K27/100,IF($L$13<>1,\"-\",IF($L$24<>1,\"-\",$E$29*K27/100))))","v":"-"}]
[null,null,null,null,{"$f":"IF(D4=0,\"\",IF(L13=0,\"\",IF(L24=0,\"\",IF(L13<>100%,\"% incorrects\",IF(L24<>100%,\"% incorrects\",\"\")))))","v":""},null,null,{"$f":"E30","v":""},null,null,{"$f":"E30","v":""}]
[null,"CALCULS DES COUTS GRP INDICÉS DES CHOIX MEDIAPLANNING"]
[null,"3. Saisir le coût GRP net non indicé"]
[]
[null,"Coût GRP net non indicé"]
[null,"(hors effets saisonnalité, tranches horaires et catégorie de coût GRP garanti)"]
[null,"Coût GRP net indicé selon les choix mediaplanning",null,null,{"$f":"IF(E29=\"-\",\"-\",E34*E29/100)","v":"-"},null,null,{"$f":"IF(H29=\"-\",\"-\",E34*H29/100)","v":"-"},null,null,{"$f":"IF(K29=\"-\",\"-\",E34*K29/100)","v":"-"}]
[]
[null,"Les éléments ci-dessus sont des simulations et n'ont pas de valeur contractuelle."]
[]
[null,"Coûts GRP net base 30 pour chaque catégorie de coût GRP net garanti"]
[]
[null,"STANDARD",null,{"$f":"D9","v":"2022-01-01"},{"$f":"E9","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D10","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!D8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!E8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!F8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!G8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!H8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!I8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!J8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!K8))","v":"-"}]
[null,null,"Access",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!D9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!E9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!F9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!G9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!H9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!I9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!J9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!K9))","v":"-"}]
[null,null,"Peak",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!D10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!E10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!F10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!G10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!H10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!I10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!J10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!K10))","v":"-"}]
[null,null,"Night",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!D11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!E11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!F11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!G11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!H11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!I11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!J11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS M6'!K11))","v":"-"}]
[]
[null,"SELECT",null,{"$f":"D42","v":"2022-01-01"},{"$f":"E42","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D43","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D44*1.05))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Access",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D45*1.05))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Peak",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D46*1.05))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Night",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D47*1.05))","v":"-"},"-","-","-","-","-","-","-"]
[]
[null,"SELECT+",null,{"$f":"D42","v":"2022-01-01"},{"$f":"E42","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D43","v":"2022-03-06"},{"$f":"E43","v":"2022-04-10"},"2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D44*1.08))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Access",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D45*1.08))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Peak",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D46*1.08))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Night",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D47*1.08))","v":"-"},"-","-","-","-","-","-","-"]
[]
[null,"Chiffres arrondis à l'euro"]

{"sheet":"CALCULS M6","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[13,1,14,2],[1,1,1,10],[17,1,18,2],[27,1,28,2]]}
[]
[null,2022]
[]
[]
[null,null,null,{"$f":"'SIMULATION COUT GRP M6'!D9","v":"2022-01-01"},{"$f":"'SIMULATION COUT GRP M6'!E9","v":"2022-03-07"},{"$f":"'SIMULATION COUT GRP M6'!F9","v":"2022-04-11"},{"$f":"'SIMULATION COUT GRP M6'!G9","v":"2022-05-09"},{"$f":"'SIMULATION COUT GRP M6'!H9","v":"2022-07-11"},{"$f":"'SIMULATION COUT GRP M6'!I9","v":"2022-08-01"},{"$f":"'SIMULATION COUT GRP M6'!J9","v":"2022-08-22"},{"$f":"'SIMULATION COUT GRP M6'!K9","v":"2022-12-19"}]
[null,null,null,{"$f":"'SIMULATION COUT GRP M6'!D10","v":"2022-03-06"},{"$f":"'SIMULATION COUT GRP M6'!E10","v":"2022-04-10"},{"$f":"'SIMULATION COUT GRP M6'!F10","v":"2022-05-08"},{"$f":"'SIMULATION COUT GRP M6'!G10","v":"2022-07-10"},{"$f":"'SIMULATION COUT GRP M6'!H10","v":"2022-07-31"},{"$f":"'SIMULATION COUT GRP M6'!I10","v":"2022-08-21"},{"$f":"'SIMULATION COUT GRP M6'!J10","v":"2022-12-18"},{"$f":"'SIMULATION COUT GRP M6'!K10","v":"2022-12-31"}]
[null,null,null,{"$f":"'SIMULATION COUT GRP M6'!D11","v":92},{"$f":"'SIMULATION COUT GRP M6'!E11","v":108},{"$f":"'SIMULATION COUT GRP M6'!F11","v":102},{"$f":"'SIMULATION COUT GRP M6'!G11","v":120},{"$f":"'SIMULATION COUT GRP M6'!H11","v":90},{"$f":"'SIMULATION COUT GRP M6'!I11","v":75},{"$f":"'SIMULATION COUT GRP M6'!J11","v":130},{"$f":"'SIMULATION COUT GRP M6'!K11","v":90}]
[null,"Day (0300-1799)",{"$f":"'SIMULATION COUT GRP M6'!$N$20","v":90},{"$f":"$C8*D$7/10000","v":0.82799999999999996},{"$f":"$C8*E$7/10000","v":0.97199999999999998},0.91800000000000004,1.08,0.81,0.67500000000000004,1.17,{"$f":"$C8*K$7/10000","v":0.81}]
[null,"Access (1800-1999)",{"$f":"'SIMULATION COUT GRP M6'!$N$21","v":100},{"$f":"$C9*D$7/10000","v":0.92},1.08,1.02,1.2,0.9,0.75,1.3,0.9]
[null,"Peak (2000-2199)",{"$f":"'SIMULATION COUT GRP M6'!$N$22","v":145},1.3340000000000001,1.5660000000000001,1.4790000000000001,1.74,1.3049999999999999,1.0874999999999999,1.885,1.3049999999999999]
[null,"Night (2200-2699)",{"$f":"'SIMULATION COUT GRP M6'!$N$23","v":85},0.78200000000000003,0.91800000000000004,0.86699999999999999,1.02,0.76500000000000001,0.63749999999999996,1.105,0.76500000000000001]
[]
[]
[null,"Pression GRP par période saisie ou calculée (tenant compte de la pression différente par TH sur chaque période)",null,{"$f":"D7","v":92},108,102,120,90,75,130,90]
[null,null,null,{"$f":"'SIMULATION COUT GRP M6'!D13","v":0},{"$f":"'SIMULATION COUT GRP M6'!E13","v":0},{"$f":"'SIMULATION COUT GRP M6'!F13","v":0},{"$f":"'SIMULATION COUT GRP M6'!G13","v":0},{"$f":"'SIMULATION COUT GRP M6'!H13","v":0},{"$f":"'SIMULATION COUT GRP M6'!I13","v":0},{"$f":"'SIMULATION COUT GRP M6'!J13","v":0},{"$f":"'SIMULATION COUT GRP M6'!K13","v":0},{"$f":"SUM(D15:K15)","v":0}]
[]
[]
[null,"Poids par période et par TH et calcul de l'indice",null,{"$f":"D5","v":"2022-01-01"},"2022-03-07","2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,{"$f":"D6","v":"2022-03-06"},{"$f":"E6","v":"2022-04-10"},"2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,null,{"$f":"D7","v":92},108,102,120,90,75,130,90,{"$f":"SUMPRODUCT(D20:K20,D15:K15)","v":0}]
[null,"Day (0300-1799)",{"$f":"'SIMULATION COUT GRP M6'!$N$20","v":90},{"$f":"'SIMULATION COUT GRP M6'!D20","v":0},{"$f":"'SIMULATION COUT GRP M6'!E20","v":0},{"$f":"'SIMULATION COUT GRP M6'!F20","v":0},{"$f":"'SIMULATION COUT GRP M6'!G20","v":0},{"$f":"'SIMULATION COUT GRP M6'!H20","v":0},{"$f":"'SIMULATION COUT GRP M6'!I20","v":0},{"$f":"'SIMULATION COUT GRP M6'!J20","v":0},{"$f":"'SIMULATION COUT GRP M6'!K20","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D21:K21)","v":0}]
[null,"Access (1800-1999)",{"$f":"'SIMULATION COUT GRP M6'!$N$21","v":100},{"$f":"'SIMULATION COUT GRP M6'!D21","v":0},{"$f":"'SIMULATION COUT GRP M6'!E21","v":0},{"$f":"'SIMULATION COUT GRP M6'!F21","v":0},{"$f":"'SIMULATION COUT GRP M6'!G21","v":0},{"$f":"'SIMULATION COUT GRP M6'!H21","v":0},{"$f":"'SIMULATION COUT GRP M6'!I21","v":0},{"$f":"'SIMULATION COUT GRP M6'!J21","v":0},{"$f":"'SIMULATION COUT GRP M6'!K21","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D22:K22)","v":0}]
[null,"Peak (2000-2199)",{"$f":"'SIMULATION COUT GRP M6'!$N$22","v":145},{"$f":"'SIMULATION COUT GRP M6'!D22","v":0},{"$f":"'SIMULATION COUT GRP M6'!E22","v":0},{"$f":"'SIMULATION COUT GRP M6'!F22","v":0},{"$f":"'SIMULATION COUT GRP M6'!G22","v":0},{"$f":"'SIMULATION COUT GRP M6'!H22","v":0},{"$f":"'SIMULATION COUT GRP M6'!I22","v":0},{"$f":"'SIMULATION COUT GRP M6'!J22","v":0},{"$f":"'SIMULATION COUT GRP M6'!K22","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D23:K23)","v":0}]
[null,"Night (2200-2699)",{"$f":"'SIMULATION COUT GRP M6'!$N$23","v":85},{"$f":"'SIMULATION COUT GRP M6'!D23","v":0},{"$f":"'SIMULATION COUT GRP M6'!E23","v":0},{"$f":"'SIMULATION COUT GRP M6'!F23","v":0},{"$f":"'SIMULATION COUT GRP M6'!G23","v":0},{"$f":"'SIMULATION COUT GRP M6'!H23","v":0},{"$f":"'SIMULATION COUT GRP M6'!I23","v":0},{"$f":"'SIMULATION COUT GRP M6'!J23","v":0},{"$f":"'SIMULATION COUT GRP M6'!K23","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D24:K24)","v":0}]
[null,"TOTAL",{"$f":"SUMPRODUCT($C$21:$C$24,L21:L24)","v":0},{"$f":"'SIMULATION COUT GRP M6'!D24","v":0},{"$f":"'SIMULATION COUT GRP M6'!E24","v":0},{"$f":"'SIMULATION COUT GRP M6'!F24","v":0},{"$f":"'SIMULATION COUT GRP M6'!G24","v":0},{"$f":"'SIMULATION COUT GRP M6'!H24","v":0},{"$f":"'SIMULATION COUT GRP M6'!I24","v":0},{"$f":"'SIMULATION COUT GRP M6'!J24","v":0},{"$f":"'SIMULATION COUT GRP M6'!K24","v":0},{"$f":"SUM(L21:L24)","v":0}]
[null,null,"indice sur la période avec poids TH",{"$f":"SUMPRODUCT(D8:D11,D21:D24)*100","v":0},{"$f":"SUMPRODUCT(E8:E11,E21:E24)*100","v":0},0,0,0,{"$f":"SUMPRODUCT(I8:I11,I21:I24)*100","v":0},{"$f":"SUMPRODUCT(J8:J11,J21:J24)*100","v":0},{"$f":"SUMPRODUCT(K8:K11,K21:K24)*100","v":0}]
[]
[null,"Poids par période et par TH et calcul de l'indice",null,{"$f":"D18","v":"2022-01-01"},{"$f":"E18","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,{"$f":"D19","v":"2022-03-06"},{"$f":"E19","v":"2022-04-10"},"2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,null,{"$f":"+D20","v":92},{"$f":"+E20","v":108},102,120,90,75,130,90,{"$f":"SUMPRODUCT(D30:K30,D15:K15)","v":0}]
[null,"Day (0300-1799)",{"$f":"'SIMULATION COUT GRP M6'!$N$20","v":90},{"$f":"D21*D$15","v":0},{"$f":"E21*E$15","v":0},0,0,0,0,0,{"$f":"K21*K$15","v":0},{"$f":"SUM(D31:K31)","v":0}]
[null,"Access (1800-1999)",{"$f":"'SIMULATION COUT GRP M6'!$N$21","v":100},{"$f":"D22*D$15","v":0},0,0,0,0,0,0,0,{"$f":"SUM(D32:K32)","v":0}]
[null,"Peak (2000-2199)",{"$f":"'SIMULATION COUT GRP M6'!$N$22","v":145},0,0,0,0,0,0,0,0,{"$f":"SUM(D33:K33)","v":0}]
[null,"Night (2200-2699)",{"$f":"'SIMULATION COUT GRP M6'!$N$23","v":85},0,0,0,0,0,0,0,0,{"$f":"SUM(D34:K34)","v":0}]
[null,"TOTAL",{"$f":"SUMPRODUCT($C$31:$C$34,L31:L34)","v":0},{"$f":"SUM(D31:D34)","v":0},0,0,0,0,0,0,0,0]
[null,null,"indice sur la période avec poids TH",{"$f":"SUMPRODUCT(D8:D11,D31:D34)*100","v":0},0,0,0,0,{"$f":"SUMPRODUCT(I8:I11,I31:I34)*100","v":0},{"$f":"SUMPRODUCT(J8:J11,J31:J34)*100","v":0},0,{"$f":"SUMPRODUCT(D31:K34,D8:K11)*100","v":0}]

{"sheet":"SIMULATION COUT GRP PTNT","index":2,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[41,1,46,1],[48,1,53,1],[55,1,60,1],[29,4,29,5],[29,7,29,8],[29,10,29,11],[33,1,33,2],[33,4,33,5],[35,1,35,2],[35,4,35,5],[35,7,35,8],[35,10,35,11],[26,4,26,5],[26,7,26,8],[26,10,26,11],[28,1,28,2],[28,4,28,5],[28,7,28,8],[28,10,28,11],[17,1,18,1],[17,11,18,11],[17,13,18,13],[25,4,25,5],[25,7,25,8],[25,10,25,11],[13,0,13,2],[1,1,1,14],[3,3,3,6],[3,8,3,11],[8,1,9,1],[8,11,10,11]]}
[]
[null,"CALCULETTE COUT GRP GARANTI 2022 - PUISSANCE TNT"]
[]
[null,"CIBLE :",null,"Femmes 25-34 ans",null,null,null,null,{"$f":"IF(VLOOKUP(D4,INDICES!B:E,4,FALSE)=\"\",\"\",(VLOOKUP(D4,INDICES!B:E,4,FALSE)))","v":""}]
[]
[null,"CHOIX MEDIAPLANNING"]
[null,"1. Saisir la répartition par période en GRP"]
[]
[null,"SAISONNALITE",null,"2022-01-01","2022-03-07","2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,"2022-03-06","2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,"Indices saisonnalité (CGV 2022)",null,92,110,105,125,90,75,135,90]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:K13)","v":0}]
[]
[null,"2. Saisir la répartition en GRP par tranche horaire sur chaque période"]
[null,"NB : maximum de 75% des GRP à délivrer dans une même Day Part"]
[]
[null,"TRANCHES HORAIRES",null,{"$f":"D9","v":"2022-01-01"},{"$f":"E9","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année",null,"Indices TH\n(CGV 2022)"]
[null,null,null,{"$f":"D10","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,"Day (0300-1799)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D20:K20)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,2))","v":90}]
[null,"Access (1800-1999)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D21:K21)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,3))","v":100}]
[null,"Peak (2000-2199)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D22:K22)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,4))","v":145}]
[null,"Night (2200-2699)",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($D$13:$K$13,D23:K23)","v":0},null,{"$f":"IF(D4=0,\"-\",HLOOKUP(VLOOKUP($D$4,lots,2,FALSE),sets,5))","v":85}]
[null,"Ensemble journée (0300 - 2699)",null,{"$f":"SUM(D20:D23)","v":0},{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},0,{"$f":"SUM(H20:H23)","v":0},{"$f":"SUM(I20:I23)","v":0},0,{"$f":"SUM(K20:K23)","v":0},{"$f":"SUM(L20:L23)","v":0}]
[null,null,null,{"$f":"IF(OR(D20>75%,D21>75%,D22>75%, D23>75%),\" max 75%\",\"\")","v":""},"","","",{"$f":"IF(OR(H20>75%,H21>75%,H22>75%, H23>75%),\" max 75%\",\"\")","v":""},{"$f":"IF(OR(I20>75%,I21>75%,I22>75%, I23>75%),\" max 75%\",\"\")","v":""},"",""]
[null,null,null,null,"STANDARD",null,null,"SELECT",null,null,"SELECT +"]
[null,null,null,null,100,null,null,105,null,null,108]
[]
[null,"INDICE CHOIX MEDIAPLANNING ANNONCEUR",null,null,{"$f":"IF(D4=0,\"-\",IF(D4=\"Enfants 4-10 ans\",100,IF(L13<>1,\"-\",IF(L24<>1,\"-\",'CALCULS PTNT'!L36))))","v":"-"},null,null,{"$f":"IF($D$4=0,\"-\",IF($D$4=\"Enfants 4-10 ans\",$E$29*H27/100,IF($L$13<>1,\"-\",IF($L$24<>1,\"-\",$E$29*H27/100))))","v":"-"},null,null,{"$f":"IF($D$4=0,\"-\",IF($D$4=\"Enfants 4-10 ans\",$E$29*K27/100,IF($L$13<>1,\"-\",IF($L$24<>1,\"-\",$E$29*K27/100))))","v":"-"}]
[null,null,null,null,{"$f":"IF(D4=0,\"\",IF(L13=0,\"\",IF(L24=0,\"\",IF(L13<>100%,\"% incorrects\",IF(L24<>100%,\"% incorrects\",\"\")))))","v":""},null,null,{"$f":"E30","v":""},null,null,{"$f":"E30","v":""}]
[null,"CALCULS DES COUTS GRP INDICÉS DES CHOIX MEDIAPLANNING"]
[null,"3. Saisir le coût GRP net non indicé"]
[]
[null,"Coût GRP net non indicé"]
[null,"(hors effets saisonnalité, tranches horaires et catégorie de coût GRP garanti)"]
[null,"Coût GRP net indicé selon les choix mediaplanning",null,null,{"$f":"IF(E29=\"-\",\"-\",E34*E29/100)","v":"-"},null,null,{"$f":"IF(H29=\"-\",\"-\",E34*H29/100)","v":"-"},null,null,{"$f":"IF(K29=\"-\",\"-\",E34*K29/100)","v":"-"}]
[]
[null,"Les éléments ci-dessus sont des simulations et n'ont pas de valeur contractuelle."]
[]
[null,"Coûts GRP net base 30 pour chaque catégorie de coût GRP net garanti"]
[]
[null,"STANDARD",null,{"$f":"D9","v":"2022-01-01"},{"$f":"E9","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D10","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!D8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!E8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!F8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!G8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!H8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!I8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!J8))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!K8))","v":"-"}]
[null,null,"Access",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!D9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!E9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!F9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!G9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!H9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!I9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!J9))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!K9))","v":"-"}]
[null,null,"Peak",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!D10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!E10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!F10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!G10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!H10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!I10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!J10))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!K10))","v":"-"}]
[null,null,"Night",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!D11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!E11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!F11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!G11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!H11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!I11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!J11))","v":"-"},{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",$E$34*'CALCULS PTNT'!K11))","v":"-"}]
[]
[null,"SELECT",null,{"$f":"D42","v":"2022-01-01"},{"$f":"E42","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D43","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D44*1.05))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Access","-","-","-","-","-","-","-","-"]
[null,null,"Peak","-","-","-","-","-","-","-","-"]
[null,null,"Night","-","-","-","-","-","-","-","-"]
[]
[null,"SELECT+",null,{"$f":"D42","v":"2022-01-01"},{"$f":"E42","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19"]
[null,null,null,{"$f":"D43","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,"Day",{"$f":"IF($E$34=0,\"-\",IF($D$4=0,\"-\",D44*1.08))","v":"-"},"-","-","-","-","-","-","-"]
[null,null,"Access","-","-","-","-","-","-","-","-"]
[null,null,"Peak","-","-","-","-","-","-","-","-"]
[null,null,"Night","-","-","-","-","-","-","-","-"]
[]
[null,"Chiffres arrondis à l'euro"]

{"sheet":"CALCULS PTNT","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,1,1,10],[13,1,14,2],[17,1,18,2],[27,1,28,2]]}
[]
[null,2022]
[]
[]
[null,null,null,{"$f":"+'SIMULATION COUT GRP PTNT'!D9","v":"2022-01-01"},{"$f":"+'SIMULATION COUT GRP PTNT'!E9","v":"2022-03-07"},{"$f":"+'SIMULATION COUT GRP PTNT'!F9","v":"2022-04-11"},{"$f":"+'SIMULATION COUT GRP PTNT'!G9","v":"2022-05-09"},{"$f":"+'SIMULATION COUT GRP PTNT'!H9","v":"2022-07-11"},{"$f":"+'SIMULATION COUT GRP PTNT'!I9","v":"2022-08-01"},{"$f":"+'SIMULATION COUT GRP PTNT'!J9","v":"2022-08-22"},{"$f":"+'SIMULATION COUT GRP PTNT'!K9","v":"2022-12-19"}]
[null,null,null,{"$f":"+'SIMULATION COUT GRP PTNT'!D10","v":"2022-03-06"},{"$f":"+'SIMULATION COUT GRP PTNT'!E10","v":"2022-04-10"},{"$f":"+'SIMULATION COUT GRP PTNT'!F10","v":"2022-05-08"},{"$f":"+'SIMULATION COUT GRP PTNT'!G10","v":"2022-07-10"},{"$f":"+'SIMULATION COUT GRP PTNT'!H10","v":"2022-07-31"},{"$f":"+'SIMULATION COUT GRP PTNT'!I10","v":"2022-08-21"},{"$f":"+'SIMULATION COUT GRP PTNT'!J10","v":"2022-12-18"},{"$f":"+'SIMULATION COUT GRP PTNT'!K10","v":"2022-12-31"}]
[null,null,null,{"$f":"+'SIMULATION COUT GRP PTNT'!D11","v":92},{"$f":"+'SIMULATION COUT GRP PTNT'!E11","v":110},{"$f":"+'SIMULATION COUT GRP PTNT'!F11","v":105},{"$f":"+'SIMULATION COUT GRP PTNT'!G11","v":125},{"$f":"+'SIMULATION COUT GRP PTNT'!H11","v":90},{"$f":"+'SIMULATION COUT GRP PTNT'!I11","v":75},{"$f":"+'SIMULATION COUT GRP PTNT'!J11","v":135},{"$f":"+'SIMULATION COUT GRP PTNT'!K11","v":90}]
[null,"Day (0300-1799)",{"$f":"+'SIMULATION COUT GRP PTNT'!N20","v":90},{"$f":"$C8*D$7/10000","v":0.82799999999999996},{"$f":"$C8*E$7/10000","v":0.99},0.94499999999999995,1.125,0.81,0.67500000000000004,1.2150000000000001,{"$f":"$C8*K$7/10000","v":0.81}]
[null,"Access (1800-1999)",{"$f":"+'SIMULATION COUT GRP PTNT'!N21","v":100},{"$f":"$C9*D$7/10000","v":0.92},1.1000000000000001,1.05,1.25,0.9,0.75,1.35,0.9]
[null,"Peak (2000-2199)",{"$f":"+'SIMULATION COUT GRP PTNT'!N22","v":145},1.3340000000000001,1.595,1.5225,1.8125,1.3049999999999999,1.0874999999999999,1.9575,1.3049999999999999]
[null,"Night (2200-2699)",{"$f":"+'SIMULATION COUT GRP PTNT'!N23","v":85},0.78200000000000003,0.93500000000000005,0.89249999999999996,1.0625,0.76500000000000001,0.63749999999999996,1.1475,0.76500000000000001]
[]
[]
[null,"Pression GRP par période saisie ou calculée (tenant compte de la pression différente par TH sur chaque période)",null,{"$f":"D7","v":92},110,105,125,90,75,135,90]
[null,null,null,{"$f":"+'SIMULATION COUT GRP PTNT'!D13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J13","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K13","v":0},{"$f":"SUM(D15:K15)","v":0}]
[]
[]
[null,"Poids par période et par TH et calcul de l'indice",null,{"$f":"D5","v":"2022-01-01"},"2022-03-07","2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,{"$f":"D6","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,null,{"$f":"D7","v":92},110,105,125,90,75,135,90,{"$f":"SUMPRODUCT(D20:K20,D15:K15)","v":0}]
[null,"Day (0300-1799)",{"$f":"+C8","v":90},{"$f":"+'SIMULATION COUT GRP PTNT'!D20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J20","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K20","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D21:K21)","v":0}]
[null,"Access (1800-1999)",{"$f":"+C9","v":100},{"$f":"+'SIMULATION COUT GRP PTNT'!D21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J21","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K21","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D22:K22)","v":0}]
[null,"Peak (2000-2199)",145,{"$f":"+'SIMULATION COUT GRP PTNT'!D22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J22","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K22","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D23:K23)","v":0}]
[null,"Night (2200-2699)",85,{"$f":"+'SIMULATION COUT GRP PTNT'!D23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J23","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K23","v":0},{"$f":"SUMPRODUCT($D$15:$K$15,D24:K24)","v":0}]
[null,"TOTAL",{"$f":"SUMPRODUCT($C$21:$C$24,L21:L24)","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!D24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!E24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!F24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!G24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!H24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!I24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!J24","v":0},{"$f":"+'SIMULATION COUT GRP PTNT'!K24","v":0},{"$f":"SUM(L21:L24)","v":0}]
[null,null,"indice sur la période avec poids TH",{"$f":"SUMPRODUCT(D8:D11,D21:D24)*100","v":0},{"$f":"SUMPRODUCT(E8:E11,E21:E24)*100","v":0},0,0,0,0,0,{"$f":"SUMPRODUCT(K8:K11,K21:K24)*100","v":0}]
[]
[null,"Poids par période et par TH et calcul de l'indice",null,{"$f":"D18","v":"2022-01-01"},{"$f":"E18","v":"2022-03-07"},"2022-04-11","2022-05-09","2022-07-11","2022-08-01","2022-08-22","2022-12-19","Année"]
[null,null,null,{"$f":"D19","v":"2022-03-06"},"2022-04-10","2022-05-08","2022-07-10","2022-07-31","2022-08-21","2022-12-18","2022-12-31"]
[null,null,null,{"$f":"+D20","v":92},{"$f":"+E20","v":110},105,125,90,75,135,90,{"$f":"SUMPRODUCT(D30:K30,D15:K15)","v":0}]
[null,"Day (0300-1799)",{"$f":"+C8","v":90},{"$f":"D21*D$15","v":0},{"$f":"E21*E$15","v":0},0,0,0,0,0,{"$f":"K21*K$15","v":0},{"$f":"SUM(D31:K31)","v":0}]
[null,"Access (1800-1999)",{"$f":"+C9","v":100},{"$f":"D22*D$15","v":0},0,0,0,0,0,0,0,{"$f":"SUM(D32:K32)","v":0}]
[null,"Peak (2000-2199)",145,0,0,0,0,0,0,0,0,{"$f":"SUM(D33:K33)","v":0}]
[null,"Night (2200-2699)",85,0,0,0,0,0,0,0,0,{"$f":"SUM(D34:K34)","v":0}]
[null,"TOTAL",{"$f":"SUMPRODUCT($C$31:$C$34,L31:L34)","v":0},{"$f":"SUM(D31:D34)","v":0},0,0,0,0,0,0,0,0]
[null,null,"indice sur la période avec poids TH",{"$f":"SUMPRODUCT(D8:D11,D31:D34)*100","v":0},0,0,0,0,{"$f":"SUMPRODUCT(I8:I11,I31:I34)*100","v":0},{"$f":"SUMPRODUCT(J8:J11,J31:J34)*100","v":0},0,{"$f":"SUMPRODUCT(D31:K34,D8:K11)*100","v":0}]

{"sheet":"INDICES","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"INFORMATIONS RELATIVES AUX CIBLES"]
[]
[null,"CIBLES","lot d'indice TH","Type de cible","Commentaires"]
[null,"Femmes 25-34 ans","A","Socio-Démo"]
[null,"Femmes 25-49 ans","A","Socio-Démo",null,null,"INDICES DE TRANCHES HORAIRES"]
[null,"Femmes 25-59 ans","A","Socio-Démo"]
[null,"Femmes 35-49 ans","A","Socio-Démo"]
[null,"FRDA 15-49 ans","A","Socio-Démo",null,null,null,"CIBLES FEMININES","CIBLES ENSEMBLE","CIBLES MASCULINES"]
[null,"FRDA avec enfant < 15 ans","A","Socio-Démo",null,null,null,"A","B","C"]
[null,"FRDA avec enfant < 25 ans","A","Socio-Démo",null,null,"Day (0300-1799)",90,85,80]
[null,"FRDA 25-59 ans","A","Socio-Démo",null,null,"Access (1800-1999)",100,100,115]
[null,"M/G Ach biscuits sucrés < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +",null,"Peak (2000-2199)",145,140,125]
[null,"M/G Ach BRSA gazeuses < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +",null,"Night (2200-2699)",85,80,75]
[null,"M/G Ach BRSA plates < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach café en dosettes < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach confiserie de chocolat < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach déodorants < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach desserts frais < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach fromages frais fondus salés < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach gels douche < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach produits apéritifs < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach shampoings < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach tablettes de chocolat < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"M/G Ach traiteur frais < 50 ans","A","Acheteurs","Cible garantie uniquement en achats Select +"]
[null,"FRDA 15-49 Data consommation éco-responsable Alimentation","A","Cible data enriching","Cible garantie uniquement en achats Select +"]
[null,"Femmes 15-49 Data consommation éco-responsable Hygiène/beauté","A","Cible data enriching","Cible garantie uniquement en achats Select +"]
[null,"Femmes 25-49 Data foyer avec enfant 0-3 ans","A","Cible data enriching","Cible garantie uniquement en achats Select +"]
[null,"Ensemble 15-49 ans","B","Socio-Démo"]
[null,"Ensemble 25-34 ans","B","Socio-Démo"]
[null,"Ensemble 25-49 ans","B","Socio-Démo"]
[null,"Ensemble 25-59","B","Socio-Démo"]
[null,"Ensemble 35-49 ans","B","Socio-Démo"]
[null,"ICSP+ 25-49 ans","B","Socio-Démo"]
[null,"Individus 25-49 Data consommation éco-responsable","B","Cible data enriching","Cible garantie uniquement en achats Select +"]
[null,"Individus 25-49 Data intentionniste déménagement","B","Cible data enriching","Cible garantie uniquement en achats Select +"]
[null,"Hommes 25-49 ans","C","Socio-Démo"]
[null,"Ensemble 15-34 ans","C","Socio-Démo","Cible garantie uniquement en achats Select et Select + et conditionnée à un investissement conjoint minimum sur 6play de 50% du budget TV"]