{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Tableau de Bord Onboarding"],"read":"whole","date_system":"1900"}

{"sheet":"Tableau de Bord Onboarding","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[0,0,0,7],[8,0,8,3],[13,0,13,3]]}
["📊 TABLEAU DE BORD ONBOARDING RH"]
[]
["Nom du collaborateur","Poste","Date d'entrée","Parrain","Étape actuelle","État de l'onboarding","Taux de complétion (%)","Commentaires"]
["Martin Dupuis","Développeur","2024-04-01","Julie Lemoine","Semaine 1",{"$f":"IF(G4=100,\"Terminé\",IF(G4=0,\"À démarrer\",\"En cours\"))","v":null},{"$f":"IF(E4=\"Jour J\",10,IF(E4=\"Semaine 1\",40,IF(E4=\"Mois 1\",70,IF(E4=\"3 mois\",100,0))))","v":null}]
["Claire Moreau","Chargée RH","2024-03-20","Marc T.","3 mois",{"$f":"IF(G5=100,\"Terminé\",IF(G5=0,\"À démarrer\",\"En cours\"))","v":null},{"$f":"IF(E5=\"Jour J\",10,IF(E5=\"Semaine 1\",40,IF(E5=\"Mois 1\",70,IF(E5=\"3 mois\",100,0))))","v":null}]
["Youssef El Idrissi","Data Analyst","2024-04-15","Sarah K.","Jour J",{"$f":"IF(G6=100,\"Terminé\",IF(G6=0,\"À démarrer\",\"En cours\"))","v":null},{"$f":"IF(E6=\"Jour J\",10,IF(E6=\"Semaine 1\",40,IF(E6=\"Mois 1\",70,IF(E6=\"3 mois\",100,0))))","v":null}]
[]
[]
["🔍 Synthèse des Onboardings"]
["Nombre total de collaborateurs",{"$f":"COUNTA(A4:A6)","v":null}]
["Nombre d'onboardings terminés",{"$f":"COUNTIF(F4:F6,\"Terminé\")","v":null}]
["Nombre en cours",{"$f":"COUNTIF(F4:F6,\"En cours\")","v":null}]
["Nombre à démarrer",{"$f":"COUNTIF(F4:F6,\"À démarrer\")","v":null}]
["📈 Indicateurs Complémentaires"]
["Taux moyen de complétion (%)",{"$f":"AVERAGE(G4:G6)","v":null}]
["% Onboardings terminés",{"$f":"COUNTIF(F4:F6,\"Terminé\")/COUNTA(A4:A6)","v":null}]
["% Onboardings en cours",{"$f":"COUNTIF(F4:F6,\"En cours\")/COUNTA(A4:A6)","v":null}]
["% Onboardings à démarrer",{"$f":"COUNTIF(F4:F6,\"À démarrer\")/COUNTA(A4:A6)","v":null}]