{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Projet","Taches","CdC"],"not_rendered":{"charts":0,"images":13,"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":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,9,2,9],[9,1,9,2],[6,1,6,2],[7,1,7,2],[4,1,4,9],[19,1,19,2],[20,1,20,2],[22,6,23,6],[2,1,2,8],[1,1,1,8],[11,1,11,2],[12,1,12,2],[14,6,15,6],[9,4,9,8],[17,1,17,2],[17,4,17,8],[25,1,25,2],[25,4,25,8],[27,1,27,2],[28,1,28,2],[30,6,31,6],[33,1,33,2],[33,4,33,8],[35,1,35,2],[36,1,36,2],[38,6,39,6],[41,1,41,2],[41,4,41,8],[43,1,43,2],[44,1,44,2],[46,6,47,6],[49,1,49,2],[49,4,49,8],[51,1,51,2],[52,1,52,2],[54,6,55,6]]}
[]
[null,"CLIENT",null,null,null,null,null,null,null,{"$f":"B8/E8","v":5.0925925925925931E-6}]
[null,"Projet"]
[]
[null,{"$f":"J2","v":5.0925925925925931E-6}]
[]
[null,"Temps projet :",null,null,"Temps estimé :"]
[null,{"$f":"Taches!B10","v":"00:00:22"},null,null,50]
[]
[null,{"$f":"Taches!A2","v":"Tâche 1"},null,"-","Description",null,null,null,null,{"$f":"H15/H16","v":1.1111111111111112E-4}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"Taches!B2","v":"00:00:04"},null,null,"10:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B13-INT(B13))*24","v":1.1111111111111111E-3}]
[null,null,null,null,null,null,null,{"$f":"(E13-INT(E13))*24","v":10}]
[]
[null,{"$f":"Taches!A3","v":"Tâche 2"},null,"-","Description",null,null,null,null,{"$f":"H23/H24","v":1E-3}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,{"$f":"Taches!B3","v":"00:00:18"},null,null,"05:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B21-INT(B21))*24","v":5.0000000000000001E-3}]
[null,null,null,null,null,null,null,{"$f":"(E21-INT(E21))*24","v":5}]
[]
[null,"Tâche 3",null,"-","Description",null,null,null,null,{"$f":"H31/H32","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,"00:00:00.00",null,null,"10:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B29-INT(B29))*24","v":0}]
[null,null,null,null,null,null,null,{"$f":"(E29-INT(E29))*24","v":10}]
[]
[null,"Tâche 4",null,"-","Description",null,null,null,null,{"$f":"H39/H40","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,"00:00:00.00",null,null,"05:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B37-INT(B37))*24","v":0}]
[null,null,null,null,null,null,null,{"$f":"(E37-INT(E37))*24","v":5}]
[]
[null,"Tâche 5",null,"-","Description",null,null,null,null,{"$f":"H47/H48","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,"00:00:00.00",null,null,"10:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B45-INT(B45))*24","v":0}]
[null,null,null,null,null,null,null,{"$f":"(E45-INT(E45))*24","v":10}]
[]
[null,"Tâche 6",null,"-","Description",null,null,null,null,{"$f":"H55/H56","v":0}]
[]
[null,"Temps tâche :",null,null,"Temps estimé :"]
[null,"00:00:00.00",null,null,"05:00:00"]
[]
[null,null,null,null,null,null,"Hrs décimales :",{"$f":"(B53-INT(B53))*24","v":0}]
[null,null,null,null,null,null,null,{"$f":"(E53-INT(E53))*24","v":5}]

{"sheet":"Taches","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Taches","Chronos"]
["Tâche 1","00:00:04"]
["Tâche 2","00:00:18"]
["Tâche 3","00:00:00"]
["Tâche 4","00:00:00"]
["Tâche 5","00:00:00"]
["Tâche 6","00:00:00"]
[]
[]
["Temps Total",{"$f":"SUM(B2:B7)","v":"00:00:22"}]

{"sheet":"CdC","index":2,"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 :)"]