{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Projet","Taches","Temps Add.","CdC"],"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],[1,9,2,9],[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}]
[null,"Projet"]
[]
[null,{"$f":"J2","v":0}]
[]
[null,"Temps projet :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B10+Taches!C10)","v":"00:00:00"},null,null,{"$f":"E13+E21+E29+E37+E45+E53","v":"03:00:00"}]
[]
[null,{"$f":"Taches!A2","v":"Tâche 1"},null,"-","Description",null,null,null,null,{"$f":"Taches!F2/Taches!F3","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B2+Taches!C2)","v":"00:00:00"},null,null,"00:30:00"]
[]
[]
[]
[]
[null,{"$f":"Taches!A3","v":"Tâche 2"},null,"-","Description",null,null,null,null,{"$f":"Taches!F4/Taches!F5","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B3+Taches!C3)","v":"00:00:00"},null,null,"00:30:00"]
[]
[]
[]
[]
[null,"Tâche 3",null,"-","Description",null,null,null,null,{"$f":"Taches!F6/Taches!F7","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B4+Taches!C4)","v":"00:00:00"},null,null,"00:30:00"]
[]
[]
[]
[]
[null,"Tâche 4",null,"-","Description",null,null,null,null,{"$f":"Taches!F8/Taches!F9","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B5+Taches!C5)","v":"00:00:00"},null,null,"00:30:00"]
[]
[]
[]
[]
[null,"Tâche 5",null,"-","Description",null,null,null,null,{"$f":"Taches!F10/Taches!F11","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B6+Taches!C6)","v":"00:00:00"},null,null,"00:30:00"]
[]
[]
[]
[]
[null,"Tâche 6",null,"-","Description",null,null,null,null,{"$f":"Taches!F12/Taches!F13","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"(Taches!B7+Taches!C7)","v":"00:00:00"},null,null,"00:30:00"]

{"sheet":"Taches","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,4,10,4],[11,4,12,4],[0,4,0,5],[1,4,2,4],[3,4,4,4],[5,4,6,4],[7,4,8,4]]}
["Taches","Chronos",null,null,"Heures Décimales"]
["Tâche 1","00:00:00",{"$f":"'Temps Add.'!T9","v":0},null,"Tâche 1",{"$f":"(Projet!ChronoT1-INT(Projet!ChronoT1))*24","v":0}]
["Tâche 2","00:00:00",{"$f":"'Temps Add.'!T14","v":0},null,null,{"$f":"(Projet!E13-INT(Projet!E13))*24","v":0.5}]
["Tâche 3","00:00:00",{"$f":"'Temps Add.'!T19","v":0},null,"Tâche 2",{"$f":"(ChronosT2-INT(ChronosT2))*24","v":0}]
["Tâche 4","00:00:00",{"$f":"'Temps Add.'!T24","v":0},null,null,{"$f":"(Projet!E21-INT(Projet!E21))*24","v":0.5}]
["Tâche 5","00:00:00",{"$f":"'Temps Add.'!T29","v":0},null,"Tâche 3",{"$f":"(Projet!B29-INT(Projet!B29))*24","v":0}]
["Tâche 6","00:00:00",{"$f":"'Temps Add.'!T34","v":0},null,null,{"$f":"(Projet!E29-INT(Projet!E29))*24","v":0.5}]
[null,null,null,null,"Tâche 4",{"$f":"(Projet!B37-INT(Projet!E37))*24","v":0}]
[null,null,null,null,null,{"$f":"(Projet!E37-INT(Projet!E37))*24","v":0.5}]
["Temps Total",{"$f":"SUM(B2:B7)","v":"00:00:00"},{"$f":"SUM(C2:C7)","v":"00:00:00"},null,"Tâche 5",{"$f":"(Projet!B45-INT(Projet!B45))*24","v":0}]
[null,null,null,null,null,{"$f":"(Projet!E45-INT(Projet!E45))*24","v":0.5}]
[null,null,null,null,"Tâche 6",{"$f":"(Projet!B53-INT(Projet!B53))*24","v":0}]
[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","00:00:00",null,{"$f":"SUM(B9:R9)","v":0}]
[]
["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","00:00:00","00:00:00",null,{"$f":"SUM(B14:R14)","v":0}]
[]
["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","00:00:00","00:00:00",null,{"$f":"SUM(B19:R19)","v":0}]
[]
["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","00:00:00","00:00:00",null,{"$f":"SUM(B24:R24)","v":0}]
[]
["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:00:00","00:00:00",null,{"$f":"SUM(B29:R29)","v":0}]
[]
["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:00:00","00:00:00",null,{"$f":"SUM(B34:R34)","v":0}]

{"sheet":"CdC","index":3,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"tomafou - 15 nov. 2021 à 11:10"]
[null,null,"Merci pour votre réponse et vos observations !"]
[]
[null,null,"Concernant mes click clicks :"]
[null,null,"L'idée c'est de pouvoir démarrer un timer pour une tâche et de l'arrêter/relancer au besoin."]
[null,null,"Je jongle entre différents dossiers et tâches donc j'ai besoin de pouvoir arrêter le temps du Projet 1/Tâche 1 pour démarrer le timer du P3/T1 et puis revenir sur le P2/T3 etc...etc..."]
[]
[null,null,"En gros, il faudrait un bouton PLAY / PAUSE un peu comme ça :"]
[null,null,"http://wudatime.com/wp-content/themes/wudatime/img/features/features_progressBar.png"]
[]
[null,null,"Scénario type :"]
[null,null,"1/ je crée un nouveau fichier pour un nouveau projet"]
[null,null,"2/ je renseigne mon fichier avec le nom du projet et les tâches utiles"]
[null,null,"3/ je démarre le timer d'une tâche"]
[null,null,"4/ j'arrête le timer (pause repas par exemple)"]
[null,null,"4bis/ je relance le timer le temps d'une modification et j'arrête le timer."]
[null,null,"5/ j'enregistre et je ferme le fichier"]
[null,null,"6/ 4 jours plus tard, je réouvre mon fichier et je lance le timer d'une tâche (tous les temps sont conservés)"]
[null,null,"7/ A la fin du projet, je connais le temps passé total"]
[]
[null,null,"Fonctions :"]
[null,null,"- 1 bouton \"Démarrer\""]
[null,null,"- 1 bouton \"Arrêter\""]
[null,null,"(ou dans le top du top, un bouton \"Démarrer\" qui se transforme en \"Arrêter\" - Play/Pause)"]
[null,null,"- 1 bouton \"Réinitialiser\" si besoin (mais je ne suis pas encore pleinement convaincu de l'utilité)"]
[null,null,"- Le timer doit continuer à tourner si l'on passe sur une autre fenêtre/fichier/dossier/application/etc..."]
[null,null,"- Le timer doit s'arrêter en fermant le fichier"]
[]
[null,null,"Je crois que c'est tout pour le moment :)"]