{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Projet 1 Liste de tâches","Paramètres et calculs"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Projet 1 Liste de tâches","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Liste de tâches du projet"]
[]
[null,"À compléter par :",null,null,"Délai :",null,"Surligner des Activités"]
[null,"Kim Abercrombie",null,null,{"$f":"TODAY()+95","v":"2012-11-27"},null,"     Cette semaine [18 juin - 24 juin]"]
[]
[null,"Projet 1"]
[null,"Activité","À rendre le","Budget","% effectué","Progression","Remarques"," "]
[null,"Planification",{"$f":"TODAY()-90","v":"2012-05-26"},{"v":476,"d":"476.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.25,"d":"25%"}}]
[null,"Préparation",{"$f":"TODAY()-2","v":"2012-08-22"},{"v":301,"d":"301.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tâche A",{"$f":"TODAY()-7","v":"2012-08-17"},{"v":429,"d":"429.00 €"},{"v":0,"d":"0%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0,"d":"0%"}}]
[null,"Tâche B",{"$f":"TODAY()+20","v":"2012-09-13"},{"v":332,"d":"332.00 €"},{"v":0.7,"d":"70%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.7,"d":"70%"}}]
[null,"Tâche C",{"$f":"TODAY()+40","v":"2012-10-03"},{"v":471,"d":"471.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tâche D",{"$f":"TODAY()+45","v":"2012-10-08"},{"v":418,"d":"418.00 €"},{"v":1,"d":"100%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":1,"d":"100%"}}]
[null,"Papiers",{"$f":"TODAY()+55","v":"2012-10-18"},{"v":150,"d":"150.00 €"},{"v":0,"d":"0%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0,"d":"0%"}},"Commencer lorsque la tâche B est terminée"]
[null,"Transmission",{"$f":"TODAY()+70","v":"2012-11-02"},{"v":330,"d":"330.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.25,"d":"25%"}}]
[null,"Suivi",{"$f":"TODAY()+90","v":"2012-11-22"},{"v":353,"d":"353.00 €"},{"v":0.5,"d":"50%"},{"$f":"tblListeDeTâches[[#This Row],[% effectué]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Paramètres et calculs","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Paramètres de surlignage"]
[null,"Le tableau ci-dessous stocke les paramètres et calculs pour la liste déroulante Surligner des Activités.\nToute modification peut entraîner des erreurs ou une perte de fonctionnalités."]
[null,"Pas de surlignage",null,null,{"$f":"B5","v":"Pas de surlignage"}]
[null,"Intervalle :","Début :","Fin :","À rendre :"]
[null,"     Cette semaine",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-08-20"},{"$f":"C7+6","v":"2012-08-26"},{"$f":"B7&\" [\"&TEXT(C7,\"j mmm\")&\" - \"&TEXT(D7,\"j mmm\")&\"]\"","v":"     Cette semaine [20 août - 26 août]"}]
[null,"     Ce mois-ci",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-08-01"},{"$f":"EDATE(C8,1)-1","v":"2012-08-31"},{"$f":"B8&\" [\"&TEXT(C8,\"j\")&\" - \"&TEXT(D8,\"j, mmm\")&\"]\"","v":"     Ce mois-ci [1 - 31, août]"}]
[null,"     Ce semestre",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-03-01"},{"$f":"EDATE(C9,4)-1","v":"2012-06-30"},{"$f":"B9&\" [\"&TEXT(C9,\"j mmm\")&\" - \"&TEXT(D9,\"j mmm\")&\"]\"","v":"     Ce semestre [1 mars - 30 juin]"}]
[null,"     Cette année",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"aaaa\")&\"]\"","v":"     Cette année [2012]"}]
[null,"Intervalle :",null,null,{"$f":"B11","v":"Intervalle :"}]
[null,"     La semaine dernière",{"$f":"C7-7","v":"2012-08-13"},{"$f":"C12+6","v":"2012-08-19"},{"$f":"B12&\" [\"&TEXT(C12,\"j mmm\")&\" - \"&TEXT(D12,\"j mmm\")&\"]\"","v":"     La semaine dernière [13 août - 19 août]"}]
[null,"     Le mois dernier",{"$f":"EDATE(C8,-1)","v":"2012-07-01"},{"$f":"EDATE(C13,1)-1","v":"2012-07-31"},{"$f":"B13&\" [\"&TEXT(C13,\"j\")&\" - \"&TEXT(D13,\"j mmm\")&\"]\"","v":"     Le mois dernier [1 - 31 juil]"}]
[null,"     Le trimestre dernier",{"$f":"EDATE(C9,-3)","v":"2011-12-01"},{"$f":"EDATE(C14,3)-1","v":"2012-02-29"},{"$f":"B14&\" [\"&TEXT(C14,\"j mmm\")&\" - \"&TEXT(D14,\"j mmm\")&\"]\"","v":"     Le trimestre dernier [1 déc - 29 févr]"}]
[null,"     L’année dernière",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     L’année dernière"}]
[]
[null,"Surlignage sélectionné :",{"$f":"IFERROR(MATCH(SurlignerActivités,SurlignageTâchesÀFaire,0),\"\")","v":""},{"$f":"SurlignerActivités","v":"     Cette semaine [18 juin - 24 juin]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Surligner le début",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Surligner la fin",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]