{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Mes listes","Oct 23","Nov 23","Dec 23","Global 2023","Jan 24","Fev 24","Mars 24","Avril 24","Mai 24","Juin 24","Juil 24","Aout 24","Sept 24","Oct 24","Global 2024"],"not_rendered":{"charts":28,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":4,"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":"Mes listes","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Etat",null,"Offre",null,"Origine"]
["Autres",null,"AGEFIPH",null,"Facebook"]
["Closé",null,"AGEFIPH",null,"Insta"]
["Done",null,"CASH divisé X3",null,"LinkedIn"]
["Downsell",null,"CASH divisé X6",null,"Recommandation"]
["No offers",null,"CASH X1",null,"Site internet"]
["No show",null,"CPF",null,"Webi"]
["Paiement en attente",null,"CPF + CASH",null,"YT"]
["Planifié",null,"OPCO"]
["R2- Followup"]
["Rdv annulé"]
["Rdv replanifié"]
["Refus"]

{"sheet":"Oct 23","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I15:I102,\"CPF\",H15:H96)","v":2500},"CA global : ",{"$f":"SUM(G15:G247)","v":2500}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E15:E102, \"Yes\")+COUNTIF(E15:E102, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I15:I102,\"CPF\",H15:H96)","v":2500},"Encaissé global :",{"$f":"SUM(H15:H247)","v":2500},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q18:Q102, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E15:E102, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I15:I102,\"CASH 1 fois\",G15:G102)","v":0},"CA CPF ",{"$f":"SUM(K15:K102)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q18:Q102, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E15:E102, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I15:I102,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L15:L102)","v":0},"Femmes closées",{"$f":"COUNTIFS(F15:F102,\"closé\",Q15:Q102, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F15:F102,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I15:I102,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M15:M128)","v":0},"Hommes closés",{"$f":"COUNTIFS(F15:F102,\"closé\",Q15:Q102, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O15:O102, \"Yes\")+COUNTIFS(O15:O102, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F15:F102, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F15:F102,\"closé\",R15:R102, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":0}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O15:O102, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F15:F102, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F15:F102,\"closé\",R15:R102,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":0}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E15:E102, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F15:F102, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P15:P102)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F15:F118, \"Closé\")","v":1}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":5000}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K15:K83)","v":{"$error":"#DIV/0!"}}]
[]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarque","Raison Refus "]
[null,null,null,null,null,"Closé",2500,{"$f":"IF(F15=\"Closé\",IF(I15=\"CASH divisé X3\",750,IF(I15=\"CASH divisé X6\",416.16,IF(OR(I15={\"CPF + CASH\";\"CPF\";\"CASH X1\";\"OPCO\";\"AGEFIPH\"}),G15,\"\"))),\"\")","v":2500},"CPF"]

{"sheet":"Nov 23","index":2,"n_rows":136,"n_cols":23,"rows_kept":136,"cut":false,"hidden":false,"merged":[[10,5,11,14]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(J18:J105,\"CPF\",H18:H99)","v":20000},"CA global : ",{"$f":"SUM(G18:G250)","v":48500}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E18:E105, \"Yes\")+COUNTIF(E18:E105, \"No\")","v":72},"Paiement CPF + Cash",{"$f":"SUMIF(J18:J105,\"CPF\",H18:H99)","v":20000},"Encaissé global :",{"$f":"SUM(H18:H250)","v":32748.48},null,null,null,null,"Hommes ",{"$f":"COUNTIFS(R21:R105, \"homme\")","v":1}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E18:E105, \"Yes\")","v":59},"Paiement 1X cash:",{"$f":"SUMIF(J18:J105,\"CASH 1 fois\",G18:G105)","v":0},"CA CPF ",{"$f":"SUM(L18:L105)","v":9460},null,null,null,null,"Femme ",{"$f":"COUNTIFS(R21:R105, \"femme\")","v":16}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E18:E105, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(J18:J105,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(M18:M105)","v":13040},"Femmes closées",null,{"$f":"COUNTIFS(F18:F105,\"closé\",R18:R105, \"femme\")","v":17},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"J5/M4","v":1.0625}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F18:F105,\"rdv annulé\")","v":4},"Opco",{"$f":"SUMIF(J18:J105,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(N18:N131)","v":22500},"Hommes closés",null,{"$f":"COUNTIFS(F18:F105,\"closé\",R18:R105, \"homme\")","v":1},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"J6/M3","v":1}]
[null,"R2 rdv ",{"$f":"COUNTIFS(P18:P105, \"Yes\")+COUNTIFS(P18:P105, \"No\")","v":34},"Follow-up ",{"$f":"COUNTIF(F18:F105, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":72},"Salariés closés",null,{"$f":"COUNTIFS(F18:F105,\"closé\",S18:S105, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"J7/G10","v":0}]
[null,"R2 Réalisés",{"$f":"COUNTIF(P18:P105, \"Yes\")","v":16},"Echec ",{"$f":"SUMIF(F18:F105, \"echec\")","v":0},"Appels :",59,"Sans-emploi closés",null,{"$f":"COUNTIFS(F18:F105,\"closé\",S18:S105,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"J8/G10","v":0}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E18:E105, \"No\")","v":13},"Non qualifiés",{"$f":"SUMIF(F18:F105, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",null,{"$f":"AVERAGE(Q18:Q105)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":0.81944444444444442},"Taux de conversion :",{"$f":"G10/G8","v":0.32203389830508472},"Closings :",{"$f":"COUNTIFS(F18:F121, \"Closé\")","v":19}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":0.47058823529411764},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":40000}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(L18:L86)","v":525.55555555555554}]
["2023-11-01"]
[11,"NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[]
["Début liste des écritures courantes du mois"]
["Deanerys","xx1","y@gmail.com",62511455,"Yes","Autres",2500,{"$f":"IF(F18=\"Closé\",IF(J18=\"CASH divisé X3\",750,IF(J18=\"CASH divisé X6\",416.16,IF(J18=\"CASH X1\",2000,IF(OR(J18=\"CPF\",J18= \"CPF + CASH\",J18= \"OPCO\",J18= \"AGEFIPH\"),G18,\"\")))),\"\")","v":""},6,"CPF",2500,{"$f":"IF(F18=\"Closé\",K18,\"\")","v":""},{"$f":"IF(AND(F18=\"CLosé\",OR(J18=\"CPF\",J18=\"CPF + CASH\",J18=\"OPCO\",J18=\"AGEFIPH\")),G18-K18,\"\")","v":""},{"$f":"IF(AND(F18=\"CLosé\",OR(J18=\"CPF\",J18=\"CPF + CASH\",J18=\"OPCO\",J18=\"AGEFIPH\")),G18,\"\")","v":""},"Insta","Yes",null,"Femme",null,null,"hhhhhhhhhhhhh",null,"Non"]
["30 janv. 2024 à 20:27","xx2","y@gmail.com",62511455,"Yes","Closé",2500,2500,null,"CPF",2500,2500,0,2500,"Webi",null,null,"Femme",null,null,"hhhhhhhhhhhhhhh",null,"Non"]
["Dsl pour l'attente je peaufinais le fichier, j'ai fait une copie j'ai mis toutes les formules que je souhaitais et les mises en formes uniquement sur l'onglet Nov 23 je copierai plus tard sur les autres onglets. Du coup est-il possible par exemple si sur l'onglet Nov 23 la ligne 22 (c'est la première qui a un paiement en plusieurs fois) la cellule J22 est noté \"CASH 6X\" et I22 est noté \"1\" reporter la ligne entière avec les mêmes mises en forme et formules 5 fois sur les 5 prochains onglets soit une fois en Dec 23, une fois en Janv 24, Fev 24, Mars 24, Avril 24 en revanche il faut que la cellule I22 se modifie à chaque fois Si en Nov 23 c'est noté 1 mettre dans l'onglet Dec 23 en I15 mettre 2 (Je précise, il faut que la ligne se recopie au début à chaque fois, c'est à dire qu'on doit voir apparaître les paiements en plusieurs fois en premier dans le tableau donc si j'écris dans une ligne et qu'au dernier moment dans l'onglet précédent je mets à jour un paiement que j'aurais oublié, ajouter une ligne au dessus de la ligne pour que les paiements en plusieurs fois soient regroupés ensemble) en Janv 24 en I15 mettre 3 ainsi de suite. Idem pour les paiements en trois fois, il faut que ça soit reporté 2 fois, se sont lignes marqués \"CASH X3\" en cellule I donc par exemple si le premier paiement est en décembre, le deuxième sera janvier et le dernier en février.","xx3","y@gmail.com",62511455,"Yes","R2- Followup",null,"",null,"CPF + CASH",1340,"","","","Webi","No",null,null,null,null,"hhhhhhhhhhh",null,"Non"]
["Voilà je ne sais pas si j'ai bien expliqué et si ce n'est pas trop dur à mettre en place. J'ajoute que ce fichier est un fichier partagé avec mes collègues et que ceci n'est qu'une copie, du coup si vous arrivez à m'aider comment dois-je recopier la macro je ne sais pas où c'est je n'ai jamais fait.","xx4","y@gmail.com",62511455,"Yes","Closé",2500,2500,null,"CPF + CASH",1400,1400,1100,2500,"Webi","Yes",null,"Femme",null,null,null,null,"Non"]
["Je vous remercie infiniment :)","xx5","y@gmail.com",62511455,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["Voici le lien","xx6","y@gmail.com",62511455,"Yes","Autres",null,"",null,"CPF",null,"","","","Facebook",null,null,null,null,null,null,null,"Non"]
["https://www.cjoint.com/c/NAEtuf2NmJM","xx7","y@gmail.com",62511455,"Yes","R2- Followup",null,null,null,"CPF + CASH",1300,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Closé",2500,416.16,1,"CASH divisé X6",null,0,"","","Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
["test JPP","xx9","y@gmail.com",62511455,"Yes","Closé",2500,416.16,1,"CASH divisé X6",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Non"]
["test JPP","xx10","y@gmail.com",62511455,"Yes","R2- Followup",null,"",1,"CASH divisé X6",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-04","xx11","y@gmail.com",62511455,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-04","xx12","y@gmail.com",62511455,"No",null,null,"",null,"CPF",null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-06","xx13",null,62511455,"Yes","R2- Followup",null,"",null,"CPF",750,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["test JPP","xx14",null,62511455,"Yes","Closé",2500,750,1,"CASH divisé X3",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Oui"]
["2023-11-06","xx15",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-06","xx16",null,null,"No",null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-06","xx17",null,null,"Yes","No offers",null,"",null,null,300,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-06","xx18",null,null,"Yes","Autres",null,"",null,"CPF + CASH",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-06","xx19",null,null,"Yes","R2- Followup",null,"",null,null,500,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["test JPP","xx20",null,null,"Yes","Closé",2500,750,1,"CASH divisé X3",null,0,"","","Webi","Yes",null,"Femme",null,null,null,null,"Non"]
["2023-11-07","xx21",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["test JPP","xx22",null,null,"Yes","Closé",2500,416.16,1,"CASH divisé X6",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Non"]
["test JPP","xx23",null,null,"Yes","R2- Followup",null,"",1,"CASH divisé X6",null,"","","","Insta",null,null,null,null,null,null,null,"Non"]
["2023-11-08","xx24",null,null,"Yes","R2- Followup",null,"",null,"OPCO",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-09","xx25",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-10","xx26",null,null,"Yes","Closé",2500,2500,null,"CPF",null,0,2500,2500,"Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-10","xx27",null,null,"Yes","R2- Followup",null,"",null,"CASH X1",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-10","xx28",null,null,"Yes","Closé",2500,2500,null,"CPF",null,0,2500,2500,"Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-10","xx29",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["test JPP","xx30",null,null,"Yes","Closé",2500,750,1,"CASH divisé X3",null,0,"","","Webi","Yes",null,"Femme",null,null,null,null,"Non"]
["2023-11-11","xx31",null,null,"No","No show",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-13","xx32",null,null,"Yes","R2- Followup",null,"",null,"CASH X1",null,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["test JPP","xx33",null,null,"Yes","R2- Followup",null,"",1,"CASH divisé X6",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-13","xx34",null,null,"Yes",null,null,"",null,"CPF",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["test JPP","xx35",null,null,"Yes","R2- Followup",null,"",1,"CASH divisé X6",500,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
["2023-11-14","xx36",null,null,"No","No show",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-15","xx37",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-15","xx38",null,null,"Yes","Closé",2500,2500,null,"CPF",700,700,1800,2500,"Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-16","xx39",null,null,"Yes","Closé",2500,2500,null,"CPF",2500,2500,0,2500,"Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-16","xx40",null,null,"Yes","R2- Followup",null,"",null,"CPF",370,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-16","xx41",null,null,"Yes","Autres",null,"",null,"CASH X1",null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-17","xx42",null,null,"Yes","Closé",2000,2000,null,"CASH X1",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-17","xx43",null,null,"Yes","R2- Followup",null,"",null,"CASH X1",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-17","xx44",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-17","xx45",null,null,"No","Rdv annulé",null,"",null,null,null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-17","xx46",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-17","xx47",null,null,"No","No show",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-17","xx48",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-17","xx49",null,null,"No","No show",null,"",null,null,null,"","","",null,"No",null,null,null,null,null,null,"Non"]
["2023-11-20","xx50",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-20","xx51",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-21","xx52",null,null,"Yes","R2- Followup",null,"",null,"CASH X1",null,"","","","Facebook","No",null,null,null,null,null,null,"Non"]
["2023-11-22","xx53",null,null,"Yes","Closé",2500,2500,null,"CPF",2360,2360,140,2500,"Webi","Yes",null,"Homme",null,null,null,null,"Non"]
["2023-11-23","xx54",null,null,"Yes","Closé",2000,2000,null,"CASH X1",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-23","xx55",null,null,"No",null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-24","xx56",null,null,"No",null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx57",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx58",null,null,"Yes","Refus",null,"",null,null,null,"","","",null,"Yes",null,null,null,null,null,null,"Non"]
["2023-11-25","xx59",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi",null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx60",null,null,"Yes",null,null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-25","xx61",null,null,"No","No show",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx62",null,null,"No","Rdv annulé",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx63",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-25","xx64",null,null,"Yes","Rdv annulé",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["2023-11-25","xx65",null,null,"Yes","Closé",2000,2000,null,"CASH X1",null,0,"","","Webi","Yes",null,"Femme",null,null,null,null,"Non"]
["2023-11-27","xx66",null,null,"Yes","Closé",2500,2500,null,"CPF",null,0,2500,2500,"Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-27","xx67",null,null,"Yes","Closé",2500,2500,null,"CPF",null,0,2500,2500,"Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-27","xx68",null,null,"Yes","R2- Followup",null,"",null,null,null,"","","","Webi","No",null,null,null,null,null,null,"Non"]
["2023-11-29","xx69",null,null,"No","Rdv replanifié",null,"",null,null,null,"","","",null,"Yes",null,null,null,null,null,null,"Non"]
["2023-11-29","xx70",null,null,"No","Rdv annulé",null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
["test JPP","xx71",null,null,"Yes","Closé",2500,750,1,"CASH divisé X3",null,0,"","","Webi",null,null,"Femme",null,null,null,null,"Non"]
["2023-11-29","xx72",null,null,"Yes","R2- Followup",null,"",null,"CPF",null,"","","","Webi","Yes",null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Dec 23","index":3,"n_rows":100,"n_cols":23,"rows_kept":100,"cut":false,"hidden":false,"merged":[[10,5,11,14]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(J21:J106,\"CPF\",H21:H99)","v":5000},"CA global : ",{"$f":"SUM(G21:G251)","v":9500}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E21:E106, \"Yes\")+COUNTIF(E21:E106, \"No\")","v":29},"Paiement CPF + Cash",{"$f":"SUMIF(J21:J106,\"CPF\",H21:H99)","v":5000},"Encaissé global :",{"$f":"SUM(H21:H251)","v":7750},null,null,null,null,"Hommes ",{"$f":"COUNTIFS(R21:R106, \"homme\")","v":3}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E21:E106, \"Yes\")","v":24},"Paiement 1X cash:",{"$f":"SUMIF(J21:J106,\"CASH 1 fois\",G21:G106)","v":0},"CA CPF ",{"$f":"SUM(L21:L106)","v":0},null,null,null,null,"Femme ",{"$f":"COUNTIFS(R21:R106, \"femme\")","v":23}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E21:E106, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(J21:J106,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(M21:M106)","v":0},"Femmes closées",null,{"$f":"COUNTIFS(F21:F106,\"closé\",R21:R106, \"femme\")","v":4},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"J5/M4","v":0.17391304347826086}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F21:F106,\"rdv annulé\")","v":2},"Opco",{"$f":"SUMIF(J21:J106,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(N21:N132)","v":0},"Hommes closés",null,{"$f":"COUNTIFS(F21:F106,\"closé\",R21:R106, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"J6/M3","v":0}]
[null,"R2 rdv ",{"$f":"COUNTIFS(P21:P106, \"Yes\")+COUNTIFS(P21:P106, \"No\")","v":12},"Follow-up ",{"$f":"COUNTIF(F21:F106, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":29},"Salariés closés",null,{"$f":"COUNTIFS(F21:F106,\"closé\",S21:S106, \"Salarié(e)\")","v":2},null,"% Conversion de salariés ",null,null,{"$f":"J7/G10","v":0.5}]
[null,"R2 Réalisés",{"$f":"COUNTIF(P21:P106, \"Yes\")","v":8},"Echec ",{"$f":"SUMIF(F21:F106, \"echec\")","v":0},"Appels :",24,"Sans-emploi closés",null,{"$f":"COUNTIFS(F21:F106,\"closé\",S21:S106,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"J8/G10","v":0}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E21:E106, \"No\")","v":5},"Non qualifiés",{"$f":"SUMIF(F21:F106, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",null,{"$f":"AVERAGE(Q21:Q106)","v":38.6875}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":0.82758620689655171},"Taux de conversion :",{"$f":"G10/G8","v":0.16666666666666666},"Closings :",{"$f":"COUNTIFS(F21:F122, \"Closé\")","v":4}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":0.66666666666666663},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":10000}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(L21:L86)","v":{"$error":"#DIV/0!"}}]
["2023-12-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarque","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
["test JPP","xx14",null,62511455,"Yes","Done",2500,{"$f":"IF(F16=\"Closé\",IF(J16=\"CASH divisé X3\",750,IF(J16=\"CASH divisé X6\",416.16,IF(J16=\"CASH X1\",2000,IF(OR(J16=\"CPF\",J16= \"CPF + CASH\",J16= \"OPCO\",J16= \"AGEFIPH\"),G16,\"\")))),\"\")","v":""},2,"CASH divisé X3",null,{"$f":"IF(F16=\"Closé\",K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16-K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16,\"\")","v":""},"Webi",null,null,"Femme",null,null,null,null,"Oui"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Done",2500,{"$f":"IF(F17=\"Closé\",IF(J17=\"CASH divisé X3\",750,IF(J17=\"CASH divisé X6\",416.16,IF(J17=\"CASH X1\",2000,IF(OR(J17=\"CPF\",J17= \"CPF + CASH\",J17= \"OPCO\",J17= \"AGEFIPH\"),G17,\"\")))),\"\")","v":""},2,"CASH divisé X6",null,{"$f":"IF(F17=\"Closé\",K17,\"\")","v":""},{"$f":"IF(AND(F17=\"CLosé\",OR(J17=\"CPF\",J17=\"CPF + CASH\",J17=\"OPCO\",J17=\"AGEFIPH\")),G17-K17,\"\")","v":""},{"$f":"IF(AND(F17=\"CLosé\",OR(J17=\"CPF\",J17=\"CPF + CASH\",J17=\"OPCO\",J17=\"AGEFIPH\")),G17,\"\")","v":""},"Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
[]
["Début liste des écritures courantes du mois"]
[null,null,null,null,"Yes","Autres",null,null,null,"CPF",null,null,null,null,"Webi",null,null,"Homme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi","Yes",39,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi","Yes",null,"Homme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi","Yes",33,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",2040,null,null,null,"Webi","Yes",47,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,750,null,"CASH divisé X3",null,null,null,null,"Webi",null,53,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,2500,null,"CPF",null,null,null,null,"Webi","Yes",42,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,2500,null,"CPF",null,null,null,null,"Webi",null,null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",1200,null,null,null,"Webi",null,null,"Homme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",1035,null,null,null,"Webi","Yes",50,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",2500,null,null,null,"Webi","No",29,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CASH divisé X6",null,null,null,null,"Webi","No",21,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CASH divisé X6",null,null,null,null,"Webi",null,null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi",null,28,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi",null,49,"Homme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",1440,null,null,null,"Webi","Yes",50,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",2870,null,null,null,"Webi","No",33,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,39,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,1625,null,null,null,"Webi",null,39,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,"Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2000,2000,null,"CASH X1",null,null,null,null,"Webi","Yes",35,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"No","Rdv annulé",null,null,null,null,null,null,null,null,null,null,null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","Rdv annulé",null,null,null,"CASH divisé X6",null,null,null,null,"Webi","No",32,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi",null,null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Global 2023","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,5,12,13]]}
[]
[]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"'Oct 23'!E2+'Nov 23'!E2+'Dec 23'!E2","v":27500},"CA global : ",{"$f":"'Oct 23'!G2+'Nov 23'!G2+'Dec 23'!G2","v":60500}]
[null,"Rdv bookés ",{"$f":"'Oct 23'!C3+'Nov 23'!C3+'Dec 23'!C3","v":101},"Paiement CPF + Cash",{"$f":"'Oct 23'!E3+'Nov 23'!E3+'Dec 23'!E3","v":27500},"Encaissé global :",{"$f":"'Oct 23'!G3+'Nov 23'!G3+'Dec 23'!G3","v":42998.479999999996}]
[null,"Rdv réalisés",{"$f":"'Oct 23'!C4+'Nov 23'!C4+'Dec 23'!C4","v":83},"Paiement 1X cash:",{"$f":"'Oct 23'!E4+'Nov 23'!E4+'Dec 23'!E4","v":0},"CA CPF ",{"$f":"'Oct 23'!G4+'Nov 23'!G4+'Dec 23'!G4","v":9460}]
[null,"Rdv replannifiés ",{"$f":"'Oct 23'!C5+'Nov 23'!C5+'Dec 23'!C5","v":0},"Paiement divisé Cash",{"$f":"'Oct 23'!E5+'Nov 23'!E5+'Dec 23'!E5","v":0},"CA Cash ",{"$f":"'Oct 23'!G5+'Nov 23'!G5+'Dec 23'!G5","v":13040},"Femmes closées",{"$f":"'Oct 23'!I5+'Nov 23'!J5+'Dec 23'!J5","v":21},null,"% Conversion de Femmes",{"$f":"I6/G11","v":0.875}]
[null,"Rdv annulés",{"$f":"'Oct 23'!C6+'Nov 23'!C6+'Dec 23'!C6","v":6},"Opco",{"$f":"'Oct 23'!E6+'Nov 23'!E6+'Dec 23'!E6","v":0},"Encaissé Cash ",{"$f":"'Oct 23'!G6+'Nov 23'!G6+'Dec 23'!G6","v":22500},"Hommes closés",{"$f":"'Oct 23'!I6+'Nov 23'!J6+'Dec 23'!J6","v":1},null,"% Conversion d' Hommes",{"$f":"I7/G11","v":4.1666666666666664E-2}]
[null,"R2 rdv ",{"$f":"'Oct 23'!C7+'Nov 23'!C7+'Dec 23'!C7","v":46},"Follow-up ",{"$f":"'Oct 23'!E7+'Nov 23'!E7+'Dec 23'!E7","v":0},"Réservations :",{"$f":"'Oct 23'!G7+'Nov 23'!G7+'Dec 23'!G7","v":101},"Salariés closés",{"$f":"'Oct 23'!I7+'Nov 23'!J7+'Dec 23'!J7","v":2},null,"% Conversion de salariés ",{"$f":"I8/G11","v":8.3333333333333329E-2}]
[null,"R2 Réalisés",{"$f":"'Oct 23'!C8+'Nov 23'!C8+'Dec 23'!C8","v":24},"Echec ",{"$f":"'Oct 23'!E8+'Nov 23'!E8+'Dec 23'!E8","v":0},"Appels :",{"$f":"'Oct 23'!G8+'Nov 23'!G8+'Dec 23'!G8","v":83},"Sans-emploi closés",{"$f":"'Oct 23'!I8+'Nov 23'!J8+'Dec 23'!J8","v":0},null,"% Conversion sans-emploi",{"$f":"I9/G11","v":0}]
[null,"No-Shows :",{"$f":"'Oct 23'!C9+'Nov 23'!C9+'Dec 23'!C9","v":18},"Non qualifiés",{"$f":"'Oct 23'!E9+'Nov 23'!E9+'Dec 23'!E9","v":0},"Follow-up",{"$f":"'Oct 23'!G9+'Nov 23'!G9+'Dec 23'!G9","v":0},"Moyenne d'âge ",{"$f":"AVERAGE('Oct 23'!I9,'Nov 23'!J9,'Dec 23'!J9)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"AVERAGE('Oct 23'!C10,'Nov 23'!C10,'Dec 23'!C10)","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"AVERAGE('Oct 23'!E10,'Nov 23'!E10,'Dec 23'!E10)","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"'Oct 23'!G10+'Nov 23'!G10+'Dec 23'!G10","v":24}]
[null,"Taux de présence R2:",{"$f":"AVERAGE('Oct 23'!C11,'Nov 23'!C11,'Dec 23'!C11)","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"'Oct 23'!E11+'Nov 23'!E11+'Dec 23'!E11","v":55000}]
[null,null,null,"Moy montant closé CPF ",{"$f":"AVERAGE('Oct 23'!E12,'Nov 23'!E12,'Dec 23'!E12)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"OCT ",{"$f":"'Oct 23'!G2","v":2500},null,"Taux de conv mensuel : "]
[null,null,"NOV",{"$f":"'Nov 23'!G2","v":48500},null,"OCT",{"$f":"'Oct 23'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"DEC ",{"$f":"'Dec 23'!G2","v":9500},null,"NOV",{"$f":"'Nov 23'!E10","v":0.32203389830508472}]
[null,null,null,null,null,"DEC",{"$f":"'Dec 23'!E10","v":0.16666666666666666}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"             "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2024-01-01"]
[null,null,null,{"$f":"EDATE(D44,1)","v":"2024-02-01"}]

{"sheet":"Jan 24","index":5,"n_rows":102,"n_cols":23,"rows_kept":102,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I18:I106,\"CPF\",G18:G106)","v":0},"CA global : ",{"$f":"SUM(G18:G251)","v":12000}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E18:E106, \"Yes\")+COUNTIF(E18:E106, \"No\")","v":28},"Paiement CPF + Cash",{"$f":"SUMIF(I18:I106,\"CPF + CASH\",G18:G106)","v":0},"Encaissé global :",{"$f":"SUM(H18:H251)","v":9916.66}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E18:E106, \"Yes\")","v":19},"Paiement 1X cash:",{"$f":"SUMIF(I18:I106,\"CASH 1 fois\",G18:G106)","v":0},"CA CPF ",{"$f":"SUM(K18:K106)","v":11537}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E18:E106, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I19:I106,\"CASH divisé\",G19:G106)","v":0},"CA Cash ",{"$f":"SUM(L18:L106)","v":3837},"Femmes closées",{"$f":"COUNTIFS(F18:F106,\"closé\",Q18:Q106, \"femme\")","v":0},null,"% Conversion de Femmes",{"$f":"I5/G10","v":0}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F2:F106,\"rdv annulé\")/C3","v":7.1428571428571425E-2},"Opco",{"$f":"SUMIF(I20:I106,\"OPCO\",G20:G106)","v":0},"Encaissé Cash ",{"$f":"SUM(M18:M132)","v":1163},"Hommes closés",{"$f":"COUNTIFS(F18:F106,\"closé\",Q18:Q106, \"homme\")","v":0},null,"% Conversion d' Hommes",{"$f":"I6/G10","v":0}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O18:O106, \"Yes\")+COUNTIFS(O18:O106, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F18:F106, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":28},"Salariés closés",{"$f":"COUNTIFS(F18:F106,\"closé\",R18:R106, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",{"$f":"I7/G10","v":0}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O18:O106, \"Yes\")","v":0},"Echec ",{"$f":"COUNTIF(F19:F106, \"echec\")","v":0},"Appels :",19,"Sans-emploi closés",{"$f":"COUNTIFS(F18:F106,\"closé\",R18:R106,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",{"$f":"I8/G10","v":0}]
[null,"No-Shows :",{"$f":"COUNTIFS(E18:E106, \"No\")","v":9},"Non qualifiés",{"$f":"COUNTIF(F20:F106, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P18:P106)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":0.6785714285714286},"Taux de conversion :",{"$f":"G10/G8","v":0.26315789473684209},"Closings :",{"$f":"COUNTIFS(F18:F122, \"Closé\")","v":5}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGEIF(I18:I106,\"CPF\",G18:G106)","v":{"$error":"#DIV/0!"}}]
["2024-01-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
["test JPP","xx14",null,62511455,"Yes","Done",2500,{"$f":"IF(F16=\"Closé\",IF(J16=\"CASH divisé X3\",750,IF(J16=\"CASH divisé X6\",416.16,IF(J16=\"CASH X1\",2000,IF(OR(J16=\"CPF\",J16= \"CPF + CASH\",J16= \"OPCO\",J16= \"AGEFIPH\"),G16,\"\")))),\"\")","v":""},3,"CASH divisé X3",null,{"$f":"IF(F16=\"Closé\",K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16-K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16,\"\")","v":""},"Webi",null,null,"Femme",null,null,null,null,"Oui"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Done",2500,{"$f":"IF(F17=\"Closé\",IF(J17=\"CASH divisé X3\",750,IF(J17=\"CASH divisé X6\",416.16,IF(J17=\"CASH X1\",2000,IF(OR(J17=\"CPF\",J17= \"CPF + CASH\",J17= \"OPCO\",J17= \"AGEFIPH\"),G17,\"\")))),\"\")","v":""},3,"CASH divisé X6",null,{"$f":"IF(F17=\"Closé\",K17,\"\")","v":""},{"$f":"IF(AND(F17=\"CLosé\",OR(J17=\"CPF\",J17=\"CPF + CASH\",J17=\"OPCO\",J17=\"AGEFIPH\")),G17-K17,\"\")","v":""},{"$f":"IF(AND(F17=\"CLosé\",OR(J17=\"CPF\",J17=\"CPF + CASH\",J17=\"OPCO\",J17=\"AGEFIPH\")),G17,\"\")","v":""},"Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
[]
["Début liste des écritures courantes du mois"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",3000,null,null,null,"Webi","No",null,"Homme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2000,2000,null,"CASH X1",null,null,null,null,"Webi",null,53,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",1700,null,null,null,"Webi",null,null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CPF",null,null,null,null,"Webi","Yes",null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,2500,null,"CPF",3000,null,null,null,"Webi","Yes",29,"Homme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Insta",null,25,"Homme","Indépendant",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Homme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Homme","Indépendant",null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,2500,null,"CPF",1515,1515,985,2500,"Webi",null,23,"Femme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi","No",null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi","No",null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,"CASH divisé X6",null,null,null,null,"Webi","No",null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"Yes","Rdv replanifié",null,null,null,null,null,null,null,null,"Webi","No",null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"No","Rdv replanifié",null,null,null,null,null,null,null,null,"Webi",null,null,"Femme",null,null,null,null,"Non"]
[null,null,null,null,"Yes","R2- Followup",null,null,null,null,null,null,null,null,"Webi",null,51,"Femme","Indépendant",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,2500,null,"CPF",2322,2322,178,2500,"Webi",null,29,"Homme","Salarié(e)",null,null,null,"Non"]
[null,null,null,null,"Yes","Closé",2500,416.66,null,"CASH divisé X6",null,null,null,null,"Webi",null,26,"Homme","Sans emploi",null,null,null,"Non"]
[null,null,null,null,"No","No show",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"No","Rdv annulé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"No","Rdv annulé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Fev 24","index":6,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"CA global : ",{"$f":"SUM(G21:G253)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E21:E108, \"Yes\")+COUNTIF(E21:E108, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"Encaissé global :",{"$f":"SUM(H21:H253)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q24:Q108, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E21:E108, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I21:I108,\"CASH 1 fois\",G21:G108)","v":0},"CA CPF ",{"$f":"SUM(K21:K108)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q24:Q108, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E21:E108, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I21:I108,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L21:L108)","v":0},"Femmes closées",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F21:F108,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I21:I108,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M21:M134)","v":0},"Hommes closés",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O21:O108, \"Yes\")+COUNTIFS(O21:O108, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F21:F108, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O21:O108, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F21:F108, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E21:E108, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F21:F108, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P21:P108)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F21:F124, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K21:K89)","v":{"$error":"#DIV/0!"}}]
["2024-02-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Done",2500,{"$f":"IF(F16=\"Closé\",IF(J16=\"CASH divisé X3\",750,IF(J16=\"CASH divisé X6\",416.16,IF(J16=\"CASH X1\",2000,IF(OR(J16=\"CPF\",J16= \"CPF + CASH\",J16= \"OPCO\",J16= \"AGEFIPH\"),G16,\"\")))),\"\")","v":""},4,"CASH divisé X6",null,{"$f":"IF(F16=\"Closé\",K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16-K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16,\"\")","v":""},"Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
[]
["Début liste des écritures courantes du mois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Mars 24","index":7,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"CA global : ",{"$f":"SUM(G21:G253)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E21:E108, \"Yes\")+COUNTIF(E21:E108, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"Encaissé global :",{"$f":"SUM(H21:H253)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q24:Q108, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E21:E108, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I21:I108,\"CASH 1 fois\",G21:G108)","v":0},"CA CPF ",{"$f":"SUM(K21:K108)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q24:Q108, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E21:E108, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I21:I108,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L21:L108)","v":0},"Femmes closées",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F21:F108,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I21:I108,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M21:M134)","v":0},"Hommes closés",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O21:O108, \"Yes\")+COUNTIFS(O21:O108, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F21:F108, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":0}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O21:O108, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F21:F108, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":0}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E21:E108, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F21:F108, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P21:P108)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F21:F124, \"Closé\")","v":1}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K21:K89)","v":{"$error":"#DIV/0!"}}]
["2024-03-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Done",2500,{"$f":"IF(F16=\"Closé\",IF(J16=\"CASH divisé X3\",750,IF(J16=\"CASH divisé X6\",416.16,IF(J16=\"CASH X1\",2000,IF(OR(J16=\"CPF\",J16= \"CPF + CASH\",J16= \"OPCO\",J16= \"AGEFIPH\"),G16,\"\")))),\"\")","v":""},5,"CASH divisé X6",null,{"$f":"IF(F16=\"Closé\",K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16-K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16,\"\")","v":""},"Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
[]
["Début liste des écritures courantes du mois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,"Closé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Avril 24","index":8,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"CA global : ",{"$f":"SUM(G21:G253)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E21:E108, \"Yes\")+COUNTIF(E21:E108, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I21:I108,\"CPF\",H21:H102)","v":0},"Encaissé global :",{"$f":"SUM(H21:H253)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q24:Q108, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E21:E108, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I21:I108,\"CASH 1 fois\",G21:G108)","v":0},"CA CPF ",{"$f":"SUM(K21:K108)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q24:Q108, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E21:E108, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I21:I108,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L21:L108)","v":0},"Femmes closées",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F21:F108,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I21:I108,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M21:M134)","v":0},"Hommes closés",{"$f":"COUNTIFS(F21:F108,\"closé\",Q21:Q108, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O21:O108, \"Yes\")+COUNTIFS(O21:O108, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F21:F108, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O21:O108, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F21:F108, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F21:F108,\"closé\",R21:R108,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E21:E108, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F21:F108, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P21:P108)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F21:F124, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K21:K89)","v":{"$error":"#DIV/0!"}}]
["2024-04-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
["test JPP","xx8","y@gmail.com",62511455,"Yes","Done",2500,{"$f":"IF(F16=\"Closé\",IF(J16=\"CASH divisé X3\",750,IF(J16=\"CASH divisé X6\",416.16,IF(J16=\"CASH X1\",2000,IF(OR(J16=\"CPF\",J16= \"CPF + CASH\",J16= \"OPCO\",J16= \"AGEFIPH\"),G16,\"\")))),\"\")","v":""},6,"CASH divisé X6",null,{"$f":"IF(F16=\"Closé\",K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16-K16,\"\")","v":""},{"$f":"IF(AND(F16=\"CLosé\",OR(J16=\"CPF\",J16=\"CPF + CASH\",J16=\"OPCO\",J16=\"AGEFIPH\")),G16,\"\")","v":""},"Webi","Yes",null,"Femme",null,null,null,null,"Oui"]
[]
["Début liste des écritures courantes du mois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Mai 24","index":9,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"CA global : ",{"$f":"SUM(G16:G248)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E16:E103, \"Yes\")+COUNTIF(E16:E103, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"Encaissé global :",{"$f":"SUM(H16:H248)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q19:Q103, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E16:E103, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I16:I103,\"CASH 1 fois\",G16:G103)","v":0},"CA CPF ",{"$f":"SUM(K16:K103)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q19:Q103, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E16:E103, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I16:I103,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L16:L103)","v":0},"Femmes closées",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F16:F103,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I16:I103,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M16:M129)","v":0},"Hommes closés",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O16:O103, \"Yes\")+COUNTIFS(O16:O103, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F16:F103, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O16:O103, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F16:F103, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E16:E103, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F16:F103, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P16:P103)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F16:F119, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K16:K84)","v":{"$error":"#DIV/0!"}}]
["2024-05-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Juin 24","index":10,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"CA global : ",{"$f":"SUM(G16:G248)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E16:E103, \"Yes\")+COUNTIF(E16:E103, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"Encaissé global :",{"$f":"SUM(H16:H248)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q19:Q103, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E16:E103, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I16:I103,\"CASH 1 fois\",G16:G103)","v":0},"CA CPF ",{"$f":"SUM(K16:K103)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q19:Q103, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E16:E103, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I16:I103,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L16:L103)","v":0},"Femmes closées",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F16:F103,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I16:I103,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M16:M129)","v":0},"Hommes closés",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O16:O103, \"Yes\")+COUNTIFS(O16:O103, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F16:F103, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O16:O103, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F16:F103, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E16:E103, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F16:F103, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P16:P103)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F16:F119, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K16:K84)","v":{"$error":"#DIV/0!"}}]
["2024-06-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Juil 24","index":11,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"CA global : ",{"$f":"SUM(G16:G248)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E16:E103, \"Yes\")+COUNTIF(E16:E103, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"Encaissé global :",{"$f":"SUM(H16:H248)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q19:Q103, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E16:E103, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I16:I103,\"CASH 1 fois\",G16:G103)","v":0},"CA CPF ",{"$f":"SUM(K16:K103)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q19:Q103, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E16:E103, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I16:I103,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L16:L103)","v":0},"Femmes closées",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F16:F103,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I16:I103,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M16:M129)","v":0},"Hommes closés",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O16:O103, \"Yes\")+COUNTIFS(O16:O103, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F16:F103, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O16:O103, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F16:F103, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E16:E103, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F16:F103, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P16:P103)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F16:F119, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K16:K84)","v":{"$error":"#DIV/0!"}}]
["2024-07-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Aout 24","index":12,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"CA global : ",{"$f":"SUM(G16:G248)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E16:E103, \"Yes\")+COUNTIF(E16:E103, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"Encaissé global :",{"$f":"SUM(H16:H248)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q19:Q103, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E16:E103, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I16:I103,\"CASH 1 fois\",G16:G103)","v":0},"CA CPF ",{"$f":"SUM(K16:K103)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q19:Q103, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E16:E103, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I16:I103,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L16:L103)","v":0},"Femmes closées",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F16:F103,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I16:I103,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M16:M129)","v":0},"Hommes closés",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O16:O103, \"Yes\")+COUNTIFS(O16:O103, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F16:F103, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O16:O103, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F16:F103, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E16:E103, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F16:F103, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P16:P103)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F16:F119, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K16:K84)","v":{"$error":"#DIV/0!"}}]
["2024-08-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,{"$f":"e","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Sept 24","index":13,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"CA global : ",{"$f":"SUM(G16:G248)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E16:E103, \"Yes\")+COUNTIF(E16:E103, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I16:I103,\"CPF\",H16:H97)","v":0},"Encaissé global :",{"$f":"SUM(H16:H248)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q19:Q103, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E16:E103, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I16:I103,\"CASH 1 fois\",G16:G103)","v":0},"CA CPF ",{"$f":"SUM(K16:K103)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q19:Q103, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E16:E103, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I16:I103,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L16:L103)","v":0},"Femmes closées",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F16:F103,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I16:I103,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M16:M129)","v":0},"Hommes closés",{"$f":"COUNTIFS(F16:F103,\"closé\",Q16:Q103, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O16:O103, \"Yes\")+COUNTIFS(O16:O103, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F16:F103, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O16:O103, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F16:F103, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F16:F103,\"closé\",R16:R103,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E16:E103, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F16:F103, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P16:P103)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F16:F119, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K16:K84)","v":{"$error":"#DIV/0!"}}]
["2024-09-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Oct 24","index":14,"n_rows":105,"n_cols":23,"rows_kept":105,"cut":false,"hidden":false,"merged":[[10,5,11,13]]}
[null,null,null,null,null,"Gross Totals"]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"SUMIF(I17:I104,\"CPF\",H17:H98)","v":0},"CA global : ",{"$f":"SUM(G17:G249)","v":0}]
[null,"Rdv bookés ",{"$f":"COUNTIF(E17:E104, \"Yes\")+COUNTIF(E17:E104, \"No\")","v":0},"Paiement CPF + Cash",{"$f":"SUMIF(I17:I104,\"CPF\",H17:H98)","v":0},"Encaissé global :",{"$f":"SUM(H17:H249)","v":0},null,null,null,"Hommes ",{"$f":"COUNTIFS(Q20:Q104, \"homme\")","v":0}]
[null,"Rdv réalisés",{"$f":"COUNTIF(E17:E104, \"Yes\")","v":0},"Paiement 1X cash:",{"$f":"SUMIF(I17:I104,\"CASH 1 fois\",G17:G104)","v":0},"CA CPF ",{"$f":"SUM(K17:K104)","v":0},null,null,null,"Femme ",{"$f":"COUNTIFS(Q20:Q104, \"femme\")","v":0}]
[null,"Rdv replannifiés ",{"$f":"COUNTIF(E17:E104, \"Replannifié\")","v":0},"Paiement divisé Cash",{"$f":"SUMIF(I17:I104,\"CASH divisé\")","v":0},"CA Cash ",{"$f":"SUM(L17:L104)","v":0},"Femmes closées",{"$f":"COUNTIFS(F17:F104,\"closé\",Q17:Q104, \"femme\")","v":0},null,"% Conversion de Femmes closées /Femmes appelées ",null,null,{"$f":"I5/L4","v":{"$error":"#DIV/0!"}}]
[null,"Rdv annulés",{"$f":"COUNTIFS(F17:F104,\"rdv annulé\")","v":0},"Opco",{"$f":"SUMIF(I17:I104,\"OPCO\")","v":0},"Encaissé Cash ",{"$f":"SUM(M17:M130)","v":0},"Hommes closés",{"$f":"COUNTIFS(F17:F104,\"closé\",Q17:Q104, \"homme\")","v":0},null,"% Conversion d' Hommes closés / Hommes appelés ",null,null,{"$f":"I6/L3","v":{"$error":"#DIV/0!"}}]
[null,"R2 rdv ",{"$f":"COUNTIFS(O17:O104, \"Yes\")+COUNTIFS(O17:O104, \"No\")","v":0},"Follow-up ",{"$f":"COUNTIF(F17:F104, \"Follow-up\")","v":0},"Réservations :",{"$f":"C3","v":0},"Salariés closés",{"$f":"COUNTIFS(F17:F104,\"closé\",R17:R104, \"Salarié(e)\")","v":0},null,"% Conversion de salariés ",null,null,{"$f":"I7/G10","v":{"$error":"#DIV/0!"}}]
[null,"R2 Réalisés",{"$f":"COUNTIF(O17:O104, \"Yes\")","v":0},"Echec ",{"$f":"SUMIF(F17:F104, \"echec\")","v":0},"Appels :",0,"Sans-emploi closés",{"$f":"COUNTIFS(F17:F104,\"closé\",R17:R104,\"Sans emploi\")","v":0},null,"% Conversion sans-emploi",null,null,{"$f":"I8/G10","v":{"$error":"#DIV/0!"}}]
[null,"No-Shows R1:",{"$f":"COUNTIFS(E17:E104, \"No\")","v":0},"Non qualifiés",{"$f":"SUMIF(F17:F104, \"Non qualifié\")","v":0},"Follow-up",{"$f":"E7","v":0},"Moyenne d'âge ",{"$f":"AVERAGE(P17:P104)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"G10/G8","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"COUNTIFS(F17:F120, \"Closé\")","v":0}]
[null,"Taux de présence R2:",{"$f":"C8/C7","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"E2+E3+E4+E5+E6","v":0}]
[null,null,null,"Moyenne montant CPF ",{"$f":"AVERAGE(K17:K85)","v":{"$error":"#DIV/0!"}}]
["2024-10-01"]
["Date","NOM prénom","E-Mail ","Téléphone","Présent","Etat","CA","Encaissé ","X","Offre","CPF Dispo ","Montant en CPF","Montant en Cash ","Montant encaissé en cash ","Origine","Présent R2","Age ","Sexe","Statut","Fonction","Remarques","Raison Refus ","Offre\ncopies\n3/6"]
["Début liste des reports d'acompte"]
[]
["Début liste des écritures courantes du mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]

{"sheet":"Global 2024","index":15,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,5,12,13]]}
[]
[]
[null,"Cold Traffic",null,"Paiement CPF:",{"$f":"'Jan 24'!E2+'Fev 24'!E2+'Mars 24'!E2+'Avril 24'!E2+'Mai 24'!E2+'Juin 24'!E2+'Juil 24'!E2+'Aout 24'!E2+'Sept 24'!E2+'Oct 24'!E2","v":0},"CA global : ",{"$f":"'Jan 24'!G2+'Fev 24'!G2+'Mars 24'!G2+'Avril 24'!G2+'Mai 24'!G2+'Juin 24'!G2+'Juil 24'!G2+'Aout 24'!G2+'Sept 24'!G2+'Oct 24'!G2","v":12000}]
[null,"Rdv bookés ",{"$f":"'Jan 24'!C3+'Fev 24'!C3+'Mars 24'!C3+'Avril 24'!C3+'Mai 24'!C3+'Juin 24'!C3+'Juil 24'!C3+'Aout 24'!C3+'Sept 24'!C3+'Oct 24'!C3","v":28},"Paiement CPF + Cash",{"$f":"'Jan 24'!E3+'Fev 24'!E3+'Mars 24'!E3+'Avril 24'!E3+'Mai 24'!E3+'Juin 24'!E3+'Juil 24'!E3+'Aout 24'!E3+'Sept 24'!E3+'Oct 24'!E3","v":0},"Encaissé global :",{"$f":"'Jan 24'!G3+'Fev 24'!G3+'Mars 24'!G3+'Avril 24'!G3+'Mai 24'!G3+'Juin 24'!G3+'Juil 24'!G3+'Aout 24'!G3+'Sept 24'!G3+'Oct 24'!G3","v":9916.66}]
[null,"Rdv réalisés",{"$f":"'Jan 24'!C4+'Fev 24'!C4++'Mars 24'!C4+'Avril 24'!C4+'Mai 24'!C4+'Juin 24'!C4+'Juil 24'!C4+'Aout 24'!C4+'Sept 24'!C4+'Oct 24'!C4","v":19},"Paiement 1X cash:",{"$f":"'Jan 24'!E4+'Fev 24'!E4+'Mars 24'!E4+'Avril 24'!E4+'Mai 24'!E4+'Juin 24'!E4+'Juil 24'!E4+'Aout 24'!E4+'Sept 24'!E4+'Oct 24'!E4","v":0},"CA CPF ",{"$f":"'Jan 24'!G4+'Fev 24'!G4+'Mars 24'!G4+'Avril 24'!G4+'Mai 24'!G4+'Juin 24'!G4+'Juil 24'!G4+'Aout 24'!G4+'Sept 24'!G4+'Oct 24'!G4","v":11537}]
[null,"Rdv replannifiés ",{"$f":"'Jan 24'!C5+'Fev 24'!C5+'Mars 24'!C5+'Avril 24'!C5+'Mai 24'!C5+'Juin 24'!C5+'Juil 24'!C5+'Aout 24'!C5+'Sept 24'!C5+'Oct 24'!C5","v":0},"Paiement divisé Cash",{"$f":"'Jan 24'!E5+'Fev 24'!E5+'Mars 24'!E5+'Avril 24'!E5+'Mai 24'!E5+'Juin 24'!E5+'Juil 24'!E5+'Aout 24'!E5+'Sept 24'!E5+'Oct 24'!E5","v":0},"CA Cash ",{"$f":"'Jan 24'!G5+'Fev 24'!G5+'Mars 24'!G5+'Avril 24'!G5+'Mai 24'!G5+'Juin 24'!G5+'Juil 24'!G5+'Aout 24'!G5+'Sept 24'!G5+'Oct 24'!G5","v":3837},"Femmes closées",{"$f":"'Jan 24'!I5+'Fev 24'!I5+'Mars 24'!I5+'Avril 24'!I5+'Mai 24'!I5+'Juin 24'!I5+'Juil 24'!I5+'Aout 24'!I5+'Sept 24'!I5+'Oct 24'!I5","v":0},null,"% Conversion de Femmes",{"$f":"I6/G11","v":0}]
[null,"Rdv annulés",{"$f":"'Jan 24'!C6+'Fev 24'!C6+'Mars 24'!C6+'Avril 24'!C6+'Mai 24'!C6+'Juin 24'!C6+'Juil 24'!C6+'Aout 24'!C6+'Sept 24'!C6+'Oct 24'!C6","v":7.1428571428571425E-2},"Opco",{"$f":"'Jan 24'!E6+'Fev 24'!E6+'Mars 24'!E6+'Avril 24'!E6+'Mai 24'!E6+'Juin 24'!E6+'Juil 24'!E6+'Aout 24'!E6+'Sept 24'!E6+'Oct 24'!E6","v":0},"Encaissé Cash ",{"$f":"'Jan 24'!G6+'Fev 24'!G6+'Mars 24'!G6+'Avril 24'!G6+'Mai 24'!G6+'Juin 24'!G6+'Juil 24'!G6+'Aout 24'!G6+'Sept 24'!G6+'Oct 24'!G6","v":1163},"Hommes closés",{"$f":"'Jan 24'!I6+'Fev 24'!I6+'Mars 24'!I6+'Avril 24'!I6+'Mai 24'!I6+'Juin 24'!I6+'Juil 24'!I6+'Aout 24'!I6+'Sept 24'!I6+'Oct 24'!I6","v":0},null,"% Conversion d' Hommes",{"$f":"I7/G11","v":0}]
[null,"R2 rdv ",{"$f":"'Jan 24'!C7+'Fev 24'!C7+'Mars 24'!C7+'Avril 24'!C7+'Mai 24'!C7+'Juin 24'!C7+'Juil 24'!C7+'Aout 24'!C7+'Sept 24'!C7+'Oct 24'!C7","v":0},"Follow-up ",{"$f":"'Jan 24'!E7+'Fev 24'!E7+'Mars 24'!E7+'Avril 24'!E7+'Mai 24'!E7+'Juin 24'!E7+'Juil 24'!E7+'Aout 24'!E7+'Sept 24'!E7+'Oct 24'!E7","v":0},"Réservations :",{"$f":"'Jan 24'!G7+'Fev 24'!G7+'Mars 24'!G7+'Avril 24'!G7+'Mai 24'!G7+'Juin 24'!G7+'Juil 24'!G7+'Aout 24'!G7+'Sept 24'!G7+'Oct 24'!G7","v":28},"Salariés closés",{"$f":"'Jan 24'!I7+'Fev 24'!I7+'Mars 24'!I7+'Avril 24'!I7+'Mai 24'!I7+'Juin 24'!I7+'Juil 24'!I7+'Aout 24'!I7+'Sept 24'!I7+'Oct 24'!I7","v":0},null,"% Conversion de salariés ",{"$f":"I8/G11","v":0}]
[null,"R2 Réalisés",{"$f":"'Jan 24'!C8+'Fev 24'!C8+'Mars 24'!C8+'Avril 24'!C8+'Mai 24'!C8+'Juin 24'!C8+'Juil 24'!C8+'Aout 24'!C8+'Sept 24'!C8+'Oct 24'!C8","v":0},"Echec ",{"$f":"'Jan 24'!E8+'Fev 24'!E8+'Mars 24'!E8+'Avril 24'!E8+'Mai 24'!E8+'Juin 24'!E8+'Juil 24'!E8+'Aout 24'!E8+'Sept 24'!E8+'Oct 24'!E8","v":0},"Appels :",{"$f":"'Jan 24'!G8+'Fev 24'!G8+'Mars 24'!G8+'Avril 24'!G8+'Mai 24'!G8+'Juin 24'!G8+'Juil 24'!G8+'Aout 24'!G8+'Sept 24'!G8+'Oct 24'!G8","v":19},"Sans-emploi closés",{"$f":"'Jan 24'!I8+'Fev 24'!I8+'Mars 24'!I8+'Avril 24'!I8+'Mai 24'!I8+'Juin 24'!I8+'Juil 24'!I8+'Aout 24'!I8+'Sept 24'!I8+'Oct 24'!I8","v":0},null,"% Conversion sans-emploi",{"$f":"I9/G11","v":0}]
[null,"No-Shows :",{"$f":"'Jan 24'!C9+'Fev 24'!C9+'Mars 24'!C9+'Avril 24'!C9+'Mai 24'!C9+'Juin 24'!C9+'Juil 24'!C9+'Aout 24'!C9+'Sept 24'!C9+'Oct 24'!C9","v":9},"Non qualifiés",{"$f":"'Jan 24'!E9+'Fev 24'!E9+'Mars 24'!E9+'Avril 24'!E9+'Mai 24'!E9+'Juin 24'!E9+'Juil 24'!E9+'Aout 24'!E9+'Sept 24'!E9+'Oct 24'!E9","v":0},"Follow-up",{"$f":"'Jan 24'!G9+'Fev 24'!G9+'Mars 24'!G9+'Avril 24'!G9+'Mai 24'!G9+'Juin 24'!G9+'Juil 24'!G9+'Aout 24'!G9+'Sept 24'!G9+'Oct 24'!G9","v":0},"Moyenne d'âge ",{"$f":"AVERAGE('Jan 24'!I9,'Fev 24'!I9,'Mars 24'!I9,'Avril 24'!I9,'Mai 24'!I9,'Juin 24'!I9,'Juil 24'!I9,'Aout 24'!I9,'Sept 24'!I9,'Oct 24'!I9)","v":{"$error":"#DIV/0!"}}]
[null,"Taux de présence R1:",{"$f":"AVERAGE('Jan 24'!C10,'Fev 24'!C10,'Mars 24'!C10,'Avril 24'!C10,'Mai 24'!C10,'Juin 24'!C10,'Juil 24'!C10,'Aout 24'!C10,'Sept 24'!C10,'Oct 24'!C10)","v":{"$error":"#DIV/0!"}},"Taux de conversion :",{"$f":"AVERAGE('Jan 24'!E10,'Fev 24'!E10,'Mars 24'!E10,'Avril 24'!E10,'Mai 24'!E10,'Juin 24'!E10,'Juil 24'!E10,'Aout 24'!E10,'Sept 24'!E10,'Oct 24'!E10)","v":{"$error":"#DIV/0!"}},"Closings :",{"$f":"'Jan 24'!G10+'Fev 24'!G10+'Mars 24'!G10+'Avril 24'!G10+'Mai 24'!G10+'Juin 24'!G10+'Juil 24'!G10+'Aout 24'!G10+'Sept 24'!G10+'Oct 24'!G10","v":6}]
[null,"Taux de présence R2:",{"$f":"C9/C8","v":{"$error":"#DIV/0!"}},"Total CA closé :",{"$f":"'Jan 24'!E11+'Fev 24'!E11+'Mars 24'!E11+'Avril 24'!E11+'Mai 24'!E11+'Juin 24'!E11+'Juil 24'!E11+'Aout 24'!E11+'Sept 24'!E11+'Oct 24'!E11","v":0}]
[null,null,null,"Moy montant closé CPF ",{"$f":"AVERAGE('Jan 24'!E12,'Fev 24'!E12,'Mars 24'!E12,'Avril 24'!E12,'Mai 24'!E12,'Juin 24'!E12,'Juil 24'!E12,'Aout 24'!E12,'Sept 24'!E12,'Oct 24'!E12)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"DEC",{"$error":"#REF!"},null,"Taux de conv mensuel : "]
[null,null,"JANVIER",{"$f":"'Jan 24'!E11","v":0},null,"DEC",{"$error":"#REF!"}]
[null,null,"FEVRIER",{"$f":"'Fev 24'!E11","v":0},null,"JANVIER",{"$f":"'Jan 24'!E10","v":0.26315789473684209}]
[null,null,"MARS",{"$f":"'Mars 24'!E11","v":0},null,"FEVRIER",{"$f":"'Fev 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"AVRIL",{"$f":"'Avril 24'!E11","v":0},null,"MARS",{"$f":"'Mars 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"MAI",{"$f":"'Mai 24'!E11","v":0},null,"AVRIL",{"$f":"'Avril 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"JUIN",{"$f":"'Juin 24'!E11","v":0},null,"MAI",{"$f":"'Mai 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"JUILLET",{"$f":"'Juil 24'!E11","v":0},null,"JUIN",{"$f":"'Juin 24'!E10","v":{"$error":"#DIV/0!"}},null,null,null,"             "]
[null,null,"AOUT",{"$f":"'Aout 24'!E11","v":0},null,"JUILLET",{"$f":"'Juil 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"SEPT",{"$f":"'Sept 24'!E11","v":0},null,"AOUT",{"$f":"'Aout 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,"OCT",{"$f":"'Oct 24'!E11","v":0},null,"SEPT",{"$f":"'Sept 24'!E10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"OCT",{"$f":"'Oct 24'!E10","v":{"$error":"#DIV/0!"}}]