{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Projet","Taches","Temps Add.","Feuil1"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Projet","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,1,49,2],[49,4,49,8],[51,1,51,2],[52,1,52,2],[41,1,41,2],[41,4,41,8],[43,1,43,2],[44,1,44,2],[33,1,33,2],[33,4,33,8],[35,1,35,2],[36,1,36,2],[25,1,25,2],[25,4,25,8],[27,1,27,2],[28,1,28,2],[19,1,19,2],[20,1,20,2],[2,1,2,8],[1,1,1,8],[11,1,11,2],[12,1,12,2],[9,4,9,8],[17,1,17,2],[17,4,17,8],[9,1,9,2],[6,1,6,2],[7,1,7,2],[4,1,4,9]]}
[]
[null,"CLIENT",null,null,null,null,null,null,null,{"$f":"(B8/E8)","v":0.35798374879493194}]
[null,"Projet"]
[]
[null,"llllllllllllllllll"]
[]
[null,"Temps projet :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C10+Taches!D10)","v":0.75211805555555578},null,null,{"$f":"E13+E21+E29+E37+E45+E53","v":2.1009837962962963}]
[]
[null,{"$f":"Taches!A2","v":"Tâche 1"},null,"-","Description",null,null,null,null,{"$f":"B13/E13","v":5.0847222222222224E-2}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C2+Taches!D2)","v":4.2372685185185187E-2},null,null,0.83333333333333337]
[]
[]
[]
[]
[null,{"$f":"Taches!A3","v":"Tâche 2"},null,"-","Description",null,null,null,null,{"$f":"B21/E21","v":0.47333515432941825}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C3+Taches!D3)","v":0.50141203703703707},null,null,1.0593171296296295]
[]
[]
[]
[]
[null,"Tâche 3",null,"-","Description",null,null,null,null,{"$f":"B29/E29","v":1}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C4+Taches!D4)","v":8.3333333333333329E-2},null,null,8.3333333333333329E-2]
[]
[]
[]
[]
[null,"Tâche 4",null,"-","Description",null,null,null,null,{"$f":"Taches!G8/Taches!G9","v":1}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C5+Taches!D5)","v":8.3333333333333329E-2},null,null,8.3333333333333329E-2]
[]
[]
[]
[]
[null,"Tâche 5",null,"-","Description",null,null,null,null,{"$f":"Taches!G10/Taches!G11","v":1}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C6+Taches!D6)","v":2.0833333333333332E-2},null,null,2.0833333333333332E-2]
[]
[]
[]
[]
[null,"Tâche 6",null,"-","Description",null,null,null,null,{"$f":"Taches!G12/Taches!G13","v":1}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!C7+Taches!D7)","v":2.0833333333333332E-2},null,null,2.0833333333333332E-2]

{"sheet":"Taches","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
["Taches","Chronos Secondes","Heures","T_Add",null,"Heures Décimales"]
["Tâche 1",0,0,{"$f":"'Temps Add.'!T9","v":4.2372685185185187E-2},null,"Tâche 1",{"$f":"(Projet!ChronoT1-INT(Projet!ChronoT1))*24","v":1.0169444444444444}]
["Tâche 2",0,0,{"$f":"'Temps Add.'!T14","v":0.50141203703703707},null,null,{"$f":"(Projet!E13-INT(Projet!E13))*24","v":20}]
["Tâche 3",0,0,{"$f":"'Temps Add.'!T19","v":8.3333333333333329E-2},null,"Tâche 2",{"$f":"(ChronosT2-INT(ChronosT2))*24","v":12.033888888888889}]
["Tâche 4",0,0,{"$f":"'Temps Add.'!T24","v":8.3333333333333329E-2},null,null,{"$f":"(Projet!E21-INT(Projet!E21))*24","v":1.4236111111111089}]
["Tâche 5",0,0,{"$f":"'Temps Add.'!T29","v":2.0833333333333332E-2},null,"Tâche 3",{"$f":"(Projet!B29-INT(Projet!B29))*24","v":2}]
["Tâche 6",0,0,{"$f":"'Temps Add.'!T34","v":2.0833333333333332E-2},null,null,{"$f":"(Projet!E29-INT(Projet!E29))*24","v":2}]
[null,null,null,null,null,"Tâche 4",{"$f":"(Projet!B37-INT(Projet!E37))*24","v":2}]
[null,null,null,null,null,null,{"$f":"(Projet!E37-INT(Projet!E37))*24","v":2}]
["Temps Total",{"$f":"SUM(B2:B7)","v":0},{"$f":"SUM(C2:C7)","v":0},{"$f":"SUM(D2:D7)","v":0.75211805555555578},null,"Tâche 5",{"$f":"(Projet!B45-INT(Projet!B45))*24","v":0.5}]
[null,null,null,null,null,null,{"$f":"(Projet!E45-INT(Projet!E45))*24","v":0.5}]
[null,null,null,null,null,"Tâche 6",{"$f":"(Projet!B53-INT(Projet!B53))*24","v":0.5}]
[null,null,null,null,null,null,{"$f":"(Projet!E53-INT(Projet!E53))*24","v":0.5}]

{"sheet":"Temps Add.","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,18,33,18],[0,0,4,19],[17,18,18,18],[20,1,20,17],[22,18,23,18],[25,1,25,17],[27,18,28,18],[30,1,30,17],[7,18,8,18],[5,1,5,17],[10,1,10,17],[12,18,13,18],[15,1,15,17]]}
[]
[]
[]
[]
[]
["Tâche 1 -",{"$f":"Projet!E10","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","01:01:01",null,{"$f":"SUM(B9:R9)","v":4.2372685185185187E-2}]
[]
["Tâche 2 -",{"$f":"Projet!E18","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","10:00:00","02:02:02",null,{"$f":"SUM(B14:R14)","v":0.50141203703703707}]
[]
["Tâche 3 -",{"$f":"Projet!E26","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","02:00:00","00:00:00",null,{"$f":"SUM(B19:R19)","v":8.3333333333333329E-2}]
[]
["Tâche 4 -",{"$f":"Projet!E34","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","02:00:00","00:00:00",null,{"$f":"SUM(B24:R24)","v":8.3333333333333329E-2}]
[]
["Tâche 5 -",{"$f":"Projet!E42","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:30:00","00:00:00",null,{"$f":"SUM(B29:R29)","v":2.0833333333333332E-2}]
[]
["Tâche 6 -",{"$f":"Projet!E50","v":"Description"}]
[]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
["Durée","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:30:00","00:00:00",null,{"$f":"SUM(B34:R34)","v":2.0833333333333332E-2}]

{"sheet":"Feuil1","index":3,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"AZETTYUIOPQSDFGHJKLMWXCVBN"]
[null,null,"123456azrtyuiopqsdfghiopqsdfghjkklllll"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[null,null,"123456azrtyuiopqsdfghjklmwxcvbnnnAZER"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Oui, je me suis dit qu'il y avait peut-être des \"liaisons\" entre le code VBA et certaines cellules et/ou formules."]
[null,null,"J'ai effectivement écrasé quelques cellules pour faire mes \"tests\" donc j'ai peut-être brisé le code. Je ne sais pas."]
[]
[null,null,"Les boutons \"Réinit.\" permettent de remettre à zéro le \"Temps Tâche\". C'est pour cela qu'il y a un bouton \"Réinit.\" par tâche. Bouton pour lequel on a prévu une \"sécurité\" avec le pop-up qui apparait pour confirmer l'action."]
[]
[null,null,"Petit rappel au cas où :"]
[null,null,"Le projet est composé de 6 tâches."]
[null,null,"Pour chacune d'elle, il est possible de :"]
[null,null,"- Modifier B10 et E10 (texte)"]
[null,null,"- Renseigner E13 (temps estimé) au format heure"]
[null,null,"- Lancer le timer (bouton \"Démarrer\")"]
[null,null,"- Arrêter le timer (bouton \"Arrêter\")"]
[null,null,"- Rajouter du temps supplémentaires (bouton \"Temps additionnel\" -> renvoi à Feuille \"Temps Add.\")"]
[null,null,"- Réinitialiser le timer (bouton \"Réinit.\")"]
[null,null,"Pour la Tâche 1, par exemple, J10 indique en pourcentage l'avancée de la tâche (temps passé) par rapport au temps estimé."]
[]
[null,null,"B8 (Feuille Projet) = cumul. des \"Temps tâche\" (B13+B21+B29+B37+B45+B53)"]
[null,null,"E8 (Feuille Projet) = cumul des \"Temps estimé\" (E13+E21+E29+E37+E45+E53)"]
[null,null,"J2 (Feuille Projet) = pourcentage de l'avancée du projet (temps passé) par rapport au temps estimé."]
[null,null,"B5-J5 (Feuillet Projet) = barre de progression dynamique indexée à J2."]
[]
[null,null,"EDIT : En reprenant votre dernier fichier pour rédiger mon rappel, je viens de m'apercevoir que la barre de progression est désormais fonctionnelle...!!"]
[null,null,"Je viens de faire un test : Tâche 1 à 00:01:00 et toutes les autres tâches à 00:00:00."]
[null,null,"Démarrage du timer : les pourcentages (J10 et J2) ainsi que la barre fonctionnent."]
[null,null,"Arrêter du timer : tout s'arrête."]
[null,null,"Relance du timer : tout redémarre."]
[null,null,"Réinitialisation timer : La barre ne s'actualise pas sauf si..."]
[null,null,"...Redémarrage du timer : La barre s'actualise."]