{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Time-Sheet","Consultation","Feuil1","Paramètres","Liens"],"not_rendered":{"images":1,"macros":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Time-Sheet","index":0,"n_rows":63,"n_cols":6,"rows_kept":63}
["Key","Date","Heure","Contact","Société","Thème"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-02T09:00:00"},"2021-08-02","09:00:00","Anne","Truck International","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-02T10:45:00"},"2021-08-02","10:45:00","Zohra","Truck International","VBA"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-02T13:30:00"},"2021-08-02","13:30:00","Pol","Truck International","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-02T15:15:00"},"2021-08-02","15:15:00","Pierre","Truck International","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-03T09:00:00"},"2021-08-03","09:00:00","Paula","Belgo Pharma","Power Query"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-03T10:45:00"},"2021-08-03","10:45:00","Chantal","Belgo Pharma","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-03T13:30:00"},"2021-08-03","13:30:00","Pierre","Belgo Pharma","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-03T15:15:00"},"2021-08-03","15:15:00","Jean-Paul","Belgo Pharma","Le publipostage"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-04T09:00:00"},"2021-08-04","09:00:00","Anne-Marie","Les Paperies réunies","Importer des données"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-04T10:45:00"},"2021-08-04","10:45:00","Pol","Les Paperies réunies","Mise en page"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-05T09:00:00"},"2021-08-05","09:00:00","Zohra","Les Cubes ","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-05T10:45:00"},"2021-08-05","10:45:00","Anne","Les Cubes ","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-05T13:30:00"},"2021-08-05","13:30:00","Chantal","Les Cubes ","Mise en page"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-05T15:15:00"},"2021-08-05","15:15:00","Paul","Les Cubes ","Mise en page"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-06T09:00:00"},"2021-08-06","09:00:00","Paula","C.B.A.Z","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-06T10:45:00"},"2021-08-06","10:45:00","Jean-Paul","C.B.A.Z","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-06T13:30:00"},"2021-08-06","13:30:00","Jean-Philippe","C.B.A.Z","Power Query"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-06T15:15:00"},"2021-08-06","15:15:00","Stéphane","C.B.A.Z","Importer des données"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-09T09:00:00"},"2021-08-09","09:00:00","Maria","Belgo Pharma","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-09T10:45:00"},"2021-08-09","10:45:00","Anne","Belgo Pharma","Les tables structurées"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-09T13:30:00"},"2021-08-09","13:30:00","Jean-Pierre","Belgo Pharma","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-09T15:15:00"},"2021-08-09","15:15:00","Marie","Belgo Pharma","Importer des données"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-10T09:00:00"},"2021-08-10","09:00:00","Paul","Lene-Xi","Le publipostage"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-10T10:45:00"},"2021-08-10","10:45:00","Pol","Lene-Xi","Protection des cellules"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-10T13:30:00"},"2021-08-10","13:30:00","Marie","Lene-Xi","Le publipostage"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-10T15:15:00"},"2021-08-10","15:15:00","Enzo","Lene-Xi","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-11T09:00:00"},"2021-08-11","09:00:00","Jean-Pierre","Inter-Bois","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-11T10:45:00"},"2021-08-11","10:45:00","Marie","Inter-Bois","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-12T09:00:00"},"2021-08-12","09:00:00","Marie","La Savonneir bleue","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-12T10:45:00"},"2021-08-12","10:45:00","Magali","La Savonneir bleue","Power Query"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-12T13:30:00"},"2021-08-12","13:30:00","Paul","La Savonneir bleue","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-12T15:15:00"},"2021-08-12","15:15:00","Philippe","La Savonneir bleue","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-13T09:00:00"},"2021-08-13","09:00:00","Ann","Linked-Out","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-13T10:45:00"},"2021-08-13","10:45:00","Filip","Linked-Out","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-13T13:30:00"},"2021-08-13","13:30:00","Enzo","Linked-Out","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-13T15:15:00"},"2021-08-13","15:15:00","Stepfan","Linked-Out","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-17T09:00:00"},"2021-08-17","09:00:00","Zohra","World-Ticket","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-17T10:45:00"},"2021-08-17","10:45:00","Jean-Paul","World-Ticket","Le publipostage"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-17T13:30:00"},"2021-08-17","13:30:00","Filip","World-Ticket","Tableaux croisé dynamique"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-17T15:15:00"},"2021-08-17","15:15:00","Stepfan","World-Ticket","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-18T09:00:00"},"2021-08-18","09:00:00","Stepfan","La sSellerie","Power Query"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-18T10:45:00"},"2021-08-18","10:45:00","Stepfan","La sSellerie","Protection des cellules"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-19T09:00:00"},"2021-08-19","09:00:00","Pol","Mondial Telecom","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-19T10:45:00"},"2021-08-19","10:45:00","Stepfan","Mondial Telecom","Importer des données"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-19T13:30:00"},"2021-08-19","13:30:00","Philippe","Mondial Telecom","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-19T15:15:00"},"2021-08-19","15:15:00","Felipo","Mondial Telecom","Les tables structurées"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-25T09:00:00"},"2021-08-25","09:00:00","Zohra","Mondial Telecom","Importer des données"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-25T10:45:00"},"2021-08-25","10:45:00","Paul","Mondial Telecom","Power Query"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-26T09:00:00"},"2021-08-26","09:00:00","Jean-Pierre","Mondial Telecom","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-26T10:45:00"},"2021-08-26","10:45:00","Paul","Mondial Telecom","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-26T13:30:00"},"2021-08-26","13:30:00","Philippe","Mondial Telecom","Protection des cellules"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-26T15:15:00"},"2021-08-26","15:15:00","Chantal","Mondial Telecom","Le publipostage"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-27T09:00:00"},"2021-08-27","09:00:00","Philippe","Mondial Telecom","Fonctions Dates é heures"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-27T10:45:00"},"2021-08-27","10:45:00","Philippe","Mondial Telecom","VBA"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-30T09:00:00"},"2021-08-30","09:00:00","Anne-Marie","Inter-Rail","Mise en forme conditionnelle"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-30T10:45:00"},"2021-08-30","10:45:00","Anne-Marie","Inter-Rail","VBA"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-30T13:30:00"},"2021-08-30","13:30:00","Anne-Marie","Inter-Rail","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-30T15:15:00"},"2021-08-30","15:15:00","Jean-Paul","Inter-Rail","Word - Les styles "]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-31T09:00:00"},"2021-08-31","09:00:00","Jean-Philippe","Les Paperies réunies","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-31T10:45:00"},"2021-08-31","10:45:00","Stéphane","Les Paperies réunies","Power Pivot"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-31T13:30:00"},"2021-08-31","13:30:00","Stéphane","Les Paperies réunies","Fonctions de recherche"]
[{"$f":"t_TimeSheet[[#This Row],[Date]] + t_TimeSheet[[#This Row],[Heure]]","v":"2021-08-31T15:15:00"},"2021-08-31","15:15:00","Filip","Les Paperies réunies","Importer des données"]

{"sheet":"Consultation","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"merged":[[4,1,5,2]]}
[]
[]
[{"$nulls":4},{"$f":"pColumnValue + pRowValue","v":"2021-08-11T10:45:00"}]
[{"$nulls":4},"2021-08-11",{"$nulls":3},"En cours"]
[null,{"$f":"pColumnValue+pRowValue","v":"2021-08-11T10:45:00"},null,null,"10:45:00"]
[{"$nulls":8},"Thème"]
[null,"Date",{"$f":"IFERROR(VLOOKUP(pKeyValue,t_TimeSheet[],MATCH(Consultation!B7,t_TimeSheet[#Headers],0),FALSE),pColumnValue)","v":"2021-08-11"}]
[null,"Heure",{"$f":"IFERROR(VLOOKUP(pKeyValue,t_TimeSheet[],MATCH(Consultation!B8,t_TimeSheet[#Headers],0),FALSE),pRowValue)","v":"10:45:00"},{"$nulls":3},{"$f":"IFERROR(INDEX(t_WeekCalendar[],MATCH(Consultation!I4,t_WeekCalendar[Semaine],0),MATCH(\"Début\",t_WeekCalendar[#Headers],0)),\"\")","v":"2021-08-09"},{"$f":"IFERROR(G8+1,\"\")","v":"2021-08-10"},"2021-08-11","2021-08-12","2021-08-13"]
[null,"Contact",{"$f":"IFERROR(VLOOKUP(pKeyValue,t_TimeSheet[],MATCH(Consultation!B9,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Marie"},null,null,"09:00:00",{"$f":"IFERROR(VLOOKUP(G$8+$F9,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Power Pivot"},{"$f":"IFERROR(VLOOKUP(H$8+$F9,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Le publipostage"},{"$f":"IFERROR(VLOOKUP(I$8+$F9,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Word - Les styles "},{"$f":"IFERROR(VLOOKUP(J$8+$F9,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Word - Les styles "},{"$f":"IFERROR(VLOOKUP(K$8+$F9,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Fonctions de recherche"}]
[null,"Société",{"$f":"IFERROR(VLOOKUP(pKeyValue,t_TimeSheet[],MATCH(Consultation!B10,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Inter-Bois"},null,null,"10:45:00",{"$f":"IFERROR(VLOOKUP(G$8+$F10,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Les tables structurées"},{"$f":"IFERROR(VLOOKUP(H$8+$F10,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Protection des cellules"},{"$f":"IFERROR(VLOOKUP(I$8+$F10,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Tableaux croisé dynamique"},{"$f":"IFERROR(VLOOKUP(J$8+$F10,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Power Query"},{"$f":"IFERROR(VLOOKUP(K$8+$F10,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Fonctions de recherche"}]
[null,"Thème",{"$f":"IFERROR(VLOOKUP(pKeyValue,t_TimeSheet[],MATCH(Consultation!B11,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Tableaux croisé dynamique"},null,null,"13:30:00",{"$f":"IFERROR(VLOOKUP(G$8+$F11,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Fonctions Dates é heures"},{"$f":"IFERROR(VLOOKUP(H$8+$F11,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Le publipostage"},{"$f":"IFERROR(VLOOKUP(I$8+$F11,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$8+$F11,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Word - Les styles "},{"$f":"IFERROR(VLOOKUP(K$8+$F11,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Word - Les styles "}]
[{"$nulls":5},"15:15:00",{"$f":"IFERROR(VLOOKUP(G$8+$F12,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Importer des données"},{"$f":"IFERROR(VLOOKUP(H$8+$F12,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Tableaux croisé dynamique"},{"$f":"IFERROR(VLOOKUP(I$8+$F12,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$8+$F12,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Word - Les styles "},{"$f":"IFERROR(VLOOKUP(K$8+$F12,t_TimeSheet[],MATCH($I$6,t_TimeSheet[#Headers],0),FALSE),\"\")","v":"Tableaux croisé dynamique"}]
{"$rows_empty":14}
[null,null,{"$f":"HYPERLINK(\"https://magicoffice.be/a-propos/\",\"©Philippe Tulliez\")","v":"©Philippe Tulliez"}]

{"sheet":"Feuil1","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"hidden":true}
["Project N°","Status","StartProject","NumberOfDay","StartDate","Ordre","Ligne de recherche","Prochaine date","Id"]
["P001","Analyse","2021-04-13",3,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-04-13"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":1},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":""},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00144299001"}]
["P001","Développement",null,10,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-04-16"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":2},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":1},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":"2021-04-16"},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00144302002"}]
["P001","Test",null,5,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-04-26"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":3},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":2},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":"2021-04-26"},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00144312003"}]
["P002","Analyse","2021-08-14",4,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-08-14"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":1},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":""},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00244422001"}]
["P001","Mise en route",null,4,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-05-01"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":4},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":3},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":"2021-05-01"},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00144317004"}]
["P001","Fin du projet",null,null,{"$f":"IF(Tableau4[[#This Row],[Ordre]]=1,Tableau4[[#This Row],[StartProject]],Tableau4[[#This Row],[Prochaine date]])","v":"2021-05-05"},{"$f":"IFERROR(VLOOKUP(Tableau4[[#This Row],[Status]],t_Task[],2,0),0)","v":5},{"$f":"IFERROR(MATCH(Tableau4[[#This Row],[Project N°]] & \"*\" & TEXT(Tableau4[[#This Row],[Ordre]]-1,\"000\"),Tableau4[Id],0),\"\")","v":5},{"$f":"IF(Tableau4[[#This Row],[Ordre]]>1,INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"StartDate\",Tableau4[#Headers],0))+INDEX(Tableau4[],Tableau4[[#This Row],[Ligne de recherche]],MATCH(\"NumberOfDay\",Tableau4[#Headers],0)),\"\")","v":"2021-05-05"},{"$f":"IF(LEN(Tableau4[[#This Row],[Project N°]]),Tableau4[[#This Row],[Project N°]] & Tableau4[[#This Row],[StartDate]] & TEXT(Tableau4[[#This Row],[Ordre]],\"000\"),\"\")","v":"P00144321005"}]
[]
[]
[]
[]
[]
[{"$nulls":5},"Status","Ordre"]
[{"$nulls":5},"Analyse",1]
[{"$nulls":5},"Développement",2]
[{"$nulls":5},"Test",3]
[{"$nulls":5},"Mise en route",4]
[{"$nulls":5},"Fin du projet",5]

{"sheet":"Paramètres","index":3,"n_rows":4,"n_cols":7,"rows_kept":4}
["Semaine","Début","Fin",null,"Consult",null,"Date de test"]
["Prochaine",{"$f":"CurrentDate+7-1*WEEKDAY(CurrentDate+7,2)+1","v":"2021-08-16"},{"$f":"B2+4","v":"2021-08-20"},null,"Contact",null,"2021-08-12"]
["En cours",{"$f":"B2-7","v":"2021-08-09"},{"$f":"C2-7","v":"2021-08-13"},null,"Société"]
["Précédente",{"$f":"B3-7","v":"2021-08-02"},{"$f":"C3-7","v":"2021-08-06"},null,"Thème",null,{"$f":"CurrentDate","v":"2021-08-12"}]

{"sheet":"Liens","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"hidden":true}
["lien","Titre","Auteur","Url"]
[{"$f":"HYPERLINK(Tableau3[[#This Row],[Url]],Tableau3[[#This Row],[Titre]])","v":"Exercice pratique : Calendrier perpétuel Excel"},"Exercice pratique : Calendrier perpétuel Excel","Pierre Fauconnier","https://fauconnier.developpez.com/tutoriels/excel/calendrier/"]