{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Mode d'emploi","Pertes","Avant – Perception","Mon DILO","Synthèse"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Mode d'emploi","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[4,2,4,5],[5,2,5,5],[6,2,6,5],[17,1,17,5]]}
[]
[null,"DILO — Vis ma journée"]
[null,"Day In the Life Of · version allégée"]
[]
[null,"1.  Avant","Onglet « Avant – Perception » : note en 2 minutes comment tu CROIS répartir ta journée, et ta cible IDÉALE."]
[null,"2.  Pendant","Onglet « Mon DILO » : au fil de l'eau, par blocs de 5 à 15 min, décris l'activité et choisis UNE couleur."]
[null,"3.  Après","Onglet « Synthèse » : compare le perçu, le réel et l'idéal. Repère 2–3 pertes à réduire en priorité."]
[]
[null,"LES 4 COULEURS"]
[]
[null,"Couleur","Famille","Ce que ça recouvre","Objectif"]
[null,"VERT","Valeur ajoutée client","Ce pour quoi le client / projet me paie.","À renforcer","VA -Valeur Ajoutée"]
[null,"ORANGE","Valeur requise (entreprise)","Obligatoire sans valeur directe : normes, contrôles, reporting.","À réduire","RVA -VA Requise"]
[null,"ROUGE","Pure perte","7 types de pertes ou Muda provenant du lean : Transport, Ergonomie, Temps d'attente, Reprises, Inventaires, Surqualité, Surproduction","À éliminer","NVA -Non VA"]
[null,"BLEU","Gaspillage sur l'humain","7 types de pertes liés à l'humain : routines, conflits, silos, désinformation, démotivation, stress/pression, indécision","À réduire","PVA -Personnes VA"]
[null,"VIOLET","Pertes de Focus / productivité","3 types de pertes liées au focus : interruptions, dispersion (mutlitâches), dilution (dans le temps)","À réduire","FVA -Focus VA"]
[]
[null,"Astuce : une seule couleur par ligne — la dominante de l'activité. On note la tendance, pas la seconde près."]

{"sheet":"Pertes","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["VA -Valeur Ajoutée",null,"RVA -VA Requise",null,"NVA -Non VA",null,"PVA -Personnes VA",null,"FVA -Focus VA"]
["A renforcer",null,"A réduire",null,"A éliminer",null,"À réduire",null,"À réduire"]
["Client externe","Activité permettant de produire ou réaliser de la valeur pour un client externe","Management","Activités de pilotage et de gestion","Transport","Déplacements inutiles d'objets/pièces","Routine","Activités réalisés sans véritable attention et intention, de manière détachée avec plus de risque d'erreur et moins de productivité","Interruptions","20% des interruptions (mail/appel/personne) conduisent à 2h de perte de productivité en moyenne"]
["Client interne","Activité permettant de produire ou réaliser de la valeur pour un client interne","Normes","Application des normes","Ergonomie","Déplacements inutiles ou inefficaces de personnes","Démotivation","Procrastination, \"quiet quitting\" ou désinvestissement sur cette activité","Dispersion","Dispersion sur le multitâches (efficace seulement pour 2% de la population), 40% d'improductivité et +50% d'erreurs…"]
[null,null,"Reporting","Activités d'information","Temps d'attente","Attente d'information/ressources ou prise de décisions","Conflit","Tensions avec d'autres personnes conduisant à plus de réserve/distance","Dilution","Reprise de tâche arrêtées, dispersées ou procrastinées "]
[null,null,"Admin","Temps administratif (email…)","Reprises","Refaire une tâche erronnée ou mal faite, ou faire en redondance, ou relancer","Silos","Manque de partage/communication entre silos"]
[{"$nulls":4},"Inventaire","Accumuler matière première, produits finis ou documents, informations ou dossiers","Désinformation","Information non disponible, ou mauvaise information, ou trop d'infos"]
[{"$nulls":4},"Surqualité","Ressources surqualifiées, solution sur-dimensionnée, travail trop précis…","Stress/pression","Travail en mode stress conduisant à des erreurs, ou besoins de compenser"]
[{"$nulls":4},"Surproduction","Intervention au-delà du périmètre, validation inutile","Indécision","Lenteur voire paralysie sur la prise de décision d'une action ou d'un projet"]
[]
["Détails"]
["Client externe","Conception, codage, création de nouvelles fonctionnalités","Management","Réunion d'équipe","Transport","Déplacement outils, machines, véhicules","Routine","Tâche automatique (sans véritable attention)","Interruptions","Collègue/Manager"]
[null,"Production, assemblage, empaquetage pour livrer au client","Management","Entretiens d'évaluation","Transport","Déplacements inutiles (la situation aurait pu être résolue sans)","Routine","Habitude cristallisée (faire comme avant)","Interruptions","Mail/Messagerie"]
[null,"Assistance directe au client pour utiliser le produit","Management","Gestion attribution rôles","Transport","Déplacement matières et matériaux, produits semi-finis ou finis, ","Routine","Exécution sans réflexion (cliquer, valider)","Interruptions","Notification"]
[null,null,"Management","Gestion congés",{"$nulls":4},"Interruptions","Réunion/Appel"]
["Client interne","Fourniture de matériels, outils, documents internes",null,null,"Ergonomie","Se déplacer d'un endroit à un autre","Démotivation","Procrastination (repousser les tâches)","Interruptions","Auto-interruption"]
[null,"Support logistique, IT, RH pour les équipes","Normes","Analyse et suivi, veille des normes","Ergonomie","Se déplacer d'un endroit à un autre (réunion)","Démotivation","Quiet quitting (faire le minimum)","Interruptions","Recherche/Attente"]
[null,"Conseils, formations, partage de compétences","Normes","Application des normes","Ergonomie",null,"Démotivation","Manque d'intérêt (travail non prioritaire)","Interruptions","Changement de projet"]
[null,null,"Normes","Contrôle des normes",{"$nulls":4},"Interruptions","Autre"]
[{"$nulls":4},"Temps d'attente","Attente de décision (manager indisponible)","Conflit","Tension interpersonnelle (friction, non-dit)"]
[null,null,"Reporting","Activités d'information","Temps d'attente","Attente d'information (données manquantes)","Conflit","Incompréhension d'équipe (mauvaise communication)","Dispersion","Multitâche entre 2 projets"]
[null,null,"Reporting","Construction et évaluation de tableaux de reporting","Temps d'attente","File d'attente (ressource partagée occupée)","Conflit","Approches contradictoires (désaccord)","Dispersion","Multitâche entre projet et activités mail"]
[null,null,"Reporting","Réunions de reporting","Temps d'attente",{"$nulls":3},"Dispersion","Multitâche entre activité récurrente et activité projet"]
[{"$nulls":6},"Silos","Manque de partage (chacun fait de son côté)","Dispersion","Autre"]
[null,null,"Admin","Temps administratif (email…)","Reprises","Correction d'erreurs (rework)","Silos","Communication cloisonnée (entre équipes)"]
[null,null,"Admin","Gestion des outils informatiques de suivi des activités (congés, notes de frais…)","Reprises","Redondance involontaire (tâche déjà faite)","Silos","Dépendances cachées (découvertes tard)","Dilution","Tâche arrêtée (abandonner, reprendre plus tard)"]
[null,null,"Admin","Gestion de l'informatique (PC, mots de passe, cybersécurité, mises à jour…)","Reprises","Relance (dossier oublié ou en retard)",null,null,"Dilution","Relance tardive (reprendre après 2 semaines)"]
[{"$nulls":4},"Reprises",null,"Désinformation","Info incomplète (contexte partiel)","Dilution"]
[{"$nulls":6},"Désinformation","Trop de canaux (Slack, email, docs, réunion)","Dilution"]
[{"$nulls":4},"Inventaire","Accumulation de documents (archives stagnantes)","Désinformation","Obsolescence (infos à jour hier, fausses aujourd'hui)","Dilution"]
[{"$nulls":4},"Inventaire","Stock excédentaire (matières, fournitures)",null,null,"Dilution","Autre"]
[{"$nulls":4},"Inventaire","Backlog stagnant (tâches jamais traitées)","Stress/pression","Urgence artificielle (deadline serrée)"]
[{"$nulls":6},"Stress/pression","Surcharge (trop de tâches parallèles)"]
[{"$nulls":4},"Surqualité","Finition excessive (détails non demandés)","Stress/pression","Sous-dotation (équipe trop petite)"]
[{"$nulls":4},"Surqualité","Double validation (approvals inutiles)"]
[{"$nulls":4},"Surqualité","Documentation exhaustive (trop détaillée)","Indécision","Analyse paralysante (étudier sans décider)"]
[{"$nulls":6},"Indécision","Consensus obligatoire (attendre accord de tous)"]
[{"$nulls":4},"Surproduction","Scope creep (ajout de fonctionnalités non demandées)","Indécision","Peur de se tromper (reporter la décision)"]
[{"$nulls":4},"Surproduction","Production à l'avance (fabrication anticipée)"]
[{"$nulls":4},"Surproduction","Variantes inutiles (proposer trop d'options)"]

{"sheet":"Avant – Perception","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[8,1,8,7],[14,1,14,7]]}
[]
[null,"Avant de mesurer — ma perception"]
[null,"Sur une journée type de 8 h. Renseigne les heures perçues, puis ta cible idéale."]
[]
[null,"1 · Ce que je CROIS faire"]
[null,null,"VA- Valeur Ajoutée","RVA -VA Requise","NVA -Non VA","PVA -Personnes VA","FVA -Focus VA","Total"]
[null,"Temps (heures)",4.5,{"v":1,"d":"1.0"},1.8,0.5,0.2,{"$f":"SUM(C7:G7)","v":{"v":8,"d":"8.0"}}]
[null,"Répartition (%)",{"$f":"IF($H$7=0,0,C7/$H$7)","v":{"v":0.5625,"d":"56.3%"}},{"$f":"IF($H$7=0,0,D7/$H$7)","v":{"v":0.125,"d":"12.5%"}},{"$f":"IF($H$7=0,0,E7/$H$7)","v":{"v":0.225,"d":"22.5%"}},{"$f":"IF($H$7=0,0,F7/$H$7)","v":{"v":0.0625,"d":"6.3%"}},{"$f":"IF($H$13=0,0,G7/$H$13)","v":{"v":0.025,"d":"2.5%"}},{"$f":"IF($H$7=0,0,SUM(C8:G8))","v":{"v":1,"d":"100.0%"}}]
[null,"Cellules bleues = à remplir librement (total libre)."]
[]
[null,"2 · Ma cible IDÉALE (réaliste)"]
[null,null,"VA- Valeur Ajoutée","RVA -VA Requise","NVA -Non VA","PVA -Personnes VA","FVA -Focus VA","Total"]
[null,"Temps (heures)",{"v":6,"d":"6.0"},{"v":1,"d":"1.0"},0.3,0.5,0.2,{"$f":"SUM(C13:G13)","v":{"v":8,"d":"8.0"}}]
[null,"Répartition (%)",{"$f":"IF($H$13=0,0,C13/$H$13)","v":{"v":0.75,"d":"75.0%"}},{"$f":"IF($H$13=0,0,D13/$H$13)","v":{"v":0.125,"d":"12.5%"}},{"$f":"IF($H$13=0,0,E13/$H$13)","v":{"v":0.0375,"d":"3.8%"}},{"$f":"IF($H$13=0,0,F13/$H$13)","v":{"v":0.0625,"d":"6.3%"}},{"$f":"IF($H$13=0,0,G13/$H$13)","v":{"v":0.025,"d":"2.5%"}},{"$f":"IF($H$13=0,0,SUM(C14:G14))","v":{"v":1,"d":"100.0%"}}]
[null,"Plus de vert, moins de rouge — atteignable, pas parfaite."]

{"sheet":"Mon DILO","index":3,"n_rows":22,"n_cols":10,"rows_kept":22}
[]
["Mon DILO — journal de la journée"]
["Heure début / fin (la durée se calcule seule). Pour chaque interruption : note son TYPE et le temps de REPRISE (min pour se remettre dans la tâche)."]
["Nom :","____________________"]
["Projet :","____________________"]
["Date :","__ / __ / ____"]
[]
["Heure début","Heure fin","Durée (min)","Activité","Couleur d'activité","Catégorie","% Pertes","Tps perdu (min)","Détails","Tâche / Projet"]
["09:00:00","09:10:00",{"$f":"IF(AND($A9<>\"\",$B9<>\"\"),($B9-$A9)*1440,\"\")","v":{"v":9.999999999999964,"d":"10"}},"Brief équipe / passation","RVA -VA Requise","Management",{"v":1,"d":"100%"},{"$f":"G9*C9","v":{"v":9.999999999999964,"d":"10"}},"Point d'équipe","Réunion"]
["09:10:00","09:40:00",{"$f":"IF(AND($A10<>\"\",$B10<>\"\"),($B10-$A10)*1440,\"\")","v":{"v":30.000000000000053,"d":"30"}},"Conception (tâche de fond)","VA -Valeur Ajoutée","Client externe",{"v":0,"d":"0%"},0,"Deep work","Projet Alpha"]
["09:40:00","09:45:00",{"$f":"IF(AND($A11<>\"\",$B11<>\"\"),($B11-$A11)*1440,\"\")","v":{"v":4.999999999999982,"d":"5"}},"Mail consulté en cours de tâche","FVA -Focus VA","Dispersion",{"v":0.5,"d":"50%"},{"v":2.499999999999991,"d":"2.5"},"Mail/Messagerie","Synchronisation"]
["09:45:00","10:00:00",{"$f":"IF(AND($A12<>\"\",$B12<>\"\"),($B12-$A12)*1440,\"\")","v":{"v":15.000000000000027,"d":"15"}},"Question collègue → changt de sujet","FVA -Focus VA","Interruptions",{"v":0.5,"d":"50%"},{"v":7.500000000000013,"d":"7.5"},"Appel manager","Projet Gamma"]
[{"$f":"B12","v":"10:00:00"},"10:30:00",{"$f":"IF(AND($A13<>\"\",$B13<>\"\"),($B13-$A13)*1440,\"\")","v":{"v":29.99999999999997,"d":"30"}},"Reprise d'un dossier suite à une erreur","NVA -Non VA","Reprises",{"v":1,"d":"100%"},{"v":29.99999999999997,"d":"30"},"Priorité validée le matin","Urgence"]
[{"$f":"B13","v":"10:30:00"},"11:30:00",60,"Travail de fond de résolution technique","VA -Valeur Ajoutée","Client interne",{"v":0,"d":"0%"},0,"Deep work","Projet Alpha"]
[{"$f":"B14","v":"11:30:00"},"11:45:00",15,"Temps d'explication des progrès","PVA -Personnes VA","PVA -Personnes VA",{"v":0.5,"d":"50%"},7.5,"Tensions","Projet Alpha"]
["11:45:00","12:00:00",{"$f":"IF(AND($A16<>\"\",$B16<>\"\"),($B16-$A16)*1440,\"\")","v":{"v":15.000000000000027,"d":"15"}},"Réunion de travail sur projet","FVA -Focus VA","Interruptions",{"v":0.5,"d":"50%"},{"v":7.500000000000013,"d":"7.5"},"Deep work","Projet Alpha"]
[{"$f":"B16","v":"12:00:00"},"12:30:00",30,"Se déplacer pour rencontrer le client","NVA -Non VA","Ergonomie",{"v":0.5,"d":"50%"},15,"Nouvelle priorité validée le matin","Urgence"]
[{"$f":"B17","v":"12:30:00"},"12:45:00",15,"Echange sur un projet","PVA -Personnes VA","PVA -Personnes VA",{"v":0.5,"d":"50%"},7.5,"Parler à demi-mots","Projet Alpha"]
[null,null,{"$f":"IF(AND($A19<>\"\",$B19<>\"\"),($B19-$A19)*1440,\"\")","v":""}]
[null,null,{"$f":"IF(AND($A20<>\"\",$B20<>\"\"),($B20-$A20)*1440,\"\")","v":""}]
[]
["Total (min)",null,{"$f":"SUM(C9:C20)","v":{"v":225.00000000000003,"d":"225"}},{"$nulls":4},{"$f":"SUM(H9:H20)","v":{"v":87.49999999999996,"d":"88"}}]

{"sheet":"Synthèse","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[20,1,20,2],[21,1,21,2],[22,1,22,2]]}
[]
[null,"Synthèse — Perçu · Réel · Idéal"]
[null,"Le réel est calculé automatiquement depuis « Mon DILO »."]
[]
[null,"Perçu (avant mesure)"]
[null,null,"VA -Valeur Ajoutée","RVA -VA Requise","NVA -Non VA","PVA -Personnes VA","FVA -Focus VA","Total"]
[null,"Temps (heures)",{"$f":"'Avant – Perception'!C7","v":4.5},{"$f":"'Avant – Perception'!D7","v":{"v":1,"d":"1.0"}},{"$f":"'Avant – Perception'!E7","v":1.8},{"$f":"'Avant – Perception'!F7","v":0.5},{"$f":"'Avant – Perception'!G7","v":0.2},{"$f":"SUM(C7:G7)","v":{"v":8,"d":"8.0"}}]
[null,"Répartition (%)",{"$f":"IF($H$7=0,0,C7/$H$7)","v":{"v":0.5625,"d":"56.3%"}},{"$f":"IF($H$7=0,0,D7/$H$7)","v":{"v":0.125,"d":"12.5%"}},{"$f":"IF($H$7=0,0,E7/$H$7)","v":{"v":0.225,"d":"22.5%"}},{"$f":"IF($H$7=0,0,F7/$H$7)","v":{"v":0.0625,"d":"6.3%"}},{"$f":"IF($H$7=0,0,G7/$H$7)","v":{"v":0.025,"d":"2.5%"}},{"$f":"IF($H$7=0,0,SUM(C8:G8))","v":{"v":1,"d":"100%"}}]
[]
[null,"Réel (mesuré)"]
[null,null,"VA -Valeur Ajoutée","RVA -VA Requise","NVA -Non VA","PVA -Personnes VA","FVA -Focus VA","Total"]
[null,"Temps (heures)",{"$f":"SUMIF('Mon DILO'!E9:E20,\"VA -Valeur Ajoutée\",'Mon DILO'!C9:C20)/60","v":{"v":1.5000000000000009,"d":"1.5"}},{"$f":"SUMIF('Mon DILO'!E9:E20,\"RVA -VA Requise\",'Mon DILO'!C9:C20)/60","v":{"v":0.16666666666666607,"d":"0.2"}},{"$f":"SUMIF('Mon DILO'!E9:E20,\"NVA -Non VA\",'Mon DILO'!C9:C20)/60","v":{"v":0.9999999999999996,"d":"1.0"}},{"$f":"SUMIF('Mon DILO'!E9:E20,\"PVA -Personnes VA\",'Mon DILO'!C9:C20)/60","v":0.5},{"$f":"SUMIF('Mon DILO'!E9:E20,\"FVA -Focus VA\",'Mon DILO'!C9:C20)/60","v":{"v":0.5833333333333339,"d":"0.6"}},{"$f":"SUM(C12:G12)","v":{"v":3.7500000000000004,"d":"3.8"}}]
[null,"Répartition (%)",{"$f":"IF($H$12=0,0,C12/$H$12)","v":{"v":0.4000000000000002,"d":"40.0%"}},{"$f":"IF($H$12=0,0,D12/$H$12)","v":{"v":0.04444444444444428,"d":"4.4%"}},{"$f":"IF($H$12=0,0,E12/$H$12)","v":{"v":0.2666666666666665,"d":"26.7%"}},{"$f":"IF($H$12=0,0,F12/$H$12)","v":{"v":0.1333333333333333,"d":"13.3%"}},{"$f":"IF($H$12=0,0,G12/$H$12)","v":{"v":0.1555555555555557,"d":"15.6%"}},{"$f":"IF($H$12=0,0,SUM(C13:G13))","v":{"v":1,"d":"100%"}}]
[]
[null,"Idéal (cible)"]
[null,null,"VA -Valeur Ajoutée","RVA -VA Requise","NVA -Non VA","PVA -Personnes VA","FVA -Focus VA","Total"]
[null,"Temps (heures)",{"$f":"'Avant – Perception'!C13","v":{"v":6,"d":"6.0"}},{"$f":"'Avant – Perception'!D13","v":{"v":1,"d":"1.0"}},{"$f":"'Avant – Perception'!E13","v":0.3},{"$f":"'Avant – Perception'!F13","v":0.5},{"$f":"'Avant – Perception'!G13","v":0.2},{"$f":"SUM(C17:G17)","v":{"v":8,"d":"8.0"}}]
[null,"Répartition (%)",{"$f":"IF($H$17=0,0,C17/$H$17)","v":{"v":0.75,"d":"75.0%"}},{"$f":"IF($H$17=0,0,D17/$H$17)","v":{"v":0.125,"d":"12.5%"}},{"$f":"IF($H$17=0,0,E17/$H$17)","v":{"v":0.0375,"d":"3.8%"}},{"$f":"IF($H$17=0,0,F17/$H$17)","v":{"v":0.0625,"d":"6.3%"}},{"$f":"IF($H$17=0,0,G17/$H$17)","v":{"v":0.025,"d":"2.5%"}},{"$f":"IF($H$17=0,0,SUM(C18:G18))","v":{"v":1,"d":"100%"}}]
[]
[null,"INDICATEURS CLÉS RÉEL"]
[null,"Temps total mesuré (min)",null,{"$f":"SUM('Mon DILO'!C9:C20)","v":{"v":225.00000000000003,"d":"225"}}]
[null,"Perte réelle de reconcentration (min)",null,{"$f":"SUM('Mon DILO'!H9:H21)","v":{"v":87.49999999999996,"d":"88"}}]
[null,"Part de pure perte (rouge)",null,{"$f":"IF($H$12=0,0,E13)","v":{"v":0.2666666666666665,"d":"26.7%"}}]