{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Analyse Planning Injuste"],"read":"whole","date_system":"1900"}

{"sheet":"Analyse Planning Injuste","index":0,"n_rows":4,"n_cols":10,"rows_kept":4}
["Technicien","Tâche","Durée prévue (h)","Réalisée à temps ?","Complexité","Date","% Retard","Durée Moyenne","Score Charge Pondérée","Équité Planification"]
["Ali","Révision A",8,"Non","Élevée","01/04",{"$f":"IF(A2=\"Ali\",COUNTIFS(A$2:A$4,\"Ali\",D$2:D$4,\"Non\")/COUNTIF(A$2:A$4,\"Ali\"),\"\")","v":null},{"$f":"IF(A2=\"Ali\",SUMIFS(C$2:C$4,A$2:A$4,\"Ali\")/COUNTIF(A$2:A$4,\"Ali\"),\"\")","v":null},{"$f":"IF(A2=\"Ali\",COUNTIF(A$2:A$4,\"Ali\")*AVERAGEIF(E$2:E$4,\"Élevée\",C$2:C$4),\"\")","v":null},{"$f":"IF(A2=\"Ali\",IF(AVERAGEIF(A$2:A$4,\"Ali\",C$2:C$4)>AVERAGE(C$2:C$4),\"SURCHARGÉ\",\"ÉQUITABLE\"),\"\")","v":null}]
["Ali","Remplacement",7,"Non","Élevée","03/04"]
["Karim","Lubrification",2,"Oui","Faible","03/04"]