{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,6,6,9]],"flags":["formulas_cached_only"]}
["Prorata","Personne","Charge",null,"Tâche","Temps"]
[1,"Marvin",0,null,"Corbeille mes urgences",5]
[1,"Sami",0,null,"Corbeille ADC035",1]
[1,"Laurent",0,null,"Prise d'appel",1]
[1,"Pierre-Yves",0]
[1,"John",0]
[1,"Anthony",0,null,null,null,"Plage de planification :"]
[1,"Alexis",0,null,null,null,"Début"]
[1,"Victoria",0]
[1,"Lova",0,null,null,null,"Semaine : ",1,"Jusqu'à semaine :",52]
[1,"Emilie",0]
[1,"Sivilay",0,{"$nulls":6},"Fin"]
[1,"Nelly",0]
[1,"Carine",0]
[]
[{"$nulls":4},"Ce bouton devrait disparaitre, sert à \"remplir\" les tableaux arrays"]
[{"$nulls":10},"Autre mode de remplissage, pour tester"]
[]
[]
[{"$nulls":4},"Vider le tableau en feuil2"]
[]
[{"$nulls":10},"Inutile maintenant"]
[]
[]
[{"$nulls":4},"Lance la macro qui remplit la feuil2 (ne marche pas à cause des modifications dans la sub ecriture)"]
[{"$nulls":5},"où je suis justement bloqué à cause du problème que j'explique"]

{"sheet":"Feuil2","index":1,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Semaine","Corbeille urgente","Corbeille AC","Lundi matin","Lundi aprem","Mardi Matin","Mardi Aprem","Mercredi Matin","Mercredi Aprem","Jeudi Matin","Jeudi Aprem","Vendredi Matin","Vendredi Aprem"]
["Semaine 1","Marvin  5","Marvin  21","Marvin  25","Sami  25","Laurent  25","Pierre-Yves  25","John  25","Anthony  25","Alexis  25","Victoria  25","Lova  25","Emilie  25"]
["Semaine 2","Sami  5","Sami  21","Sivilay  25","Nelly  25","Carine  25","Carine  26","Nelly  26","Sivilay  26","Emilie  26","Lova  26","Victoria  26","Alexis  26"]
["Semaine 3","Laurent  5","Laurent  21","Anthony  26","John  26","Pierre-Yves  26","Laurent  26","Sami  26","Marvin  26","Marvin  27","Sami  27","Laurent  27","Pierre-Yves  27"]
["Semaine 4","Pierre-Yves  5","Pierre-Yves  21","John  27","Anthony  27","Alexis  27","Victoria  27","Lova  27","Emilie  27","Sivilay  27","Nelly  27","Carine  27","Carine  28"]
["Semaine 5","John  5","John  21","Nelly  28","Sivilay  28","Emilie  28","Lova  28","Victoria  28","Alexis  28","Anthony  28","John  28","Pierre-Yves  28","Laurent  28"]
["Semaine 6","Anthony  5","Anthony  21","Sami  28","Marvin  28","Marvin  29","Sami  29","Laurent  29","Pierre-Yves  29","John  29","Anthony  29","Alexis  29","Victoria  29"]
["Semaine 7","Alexis  5","Alexis  21","Lova  29","Emilie  29","Sivilay  29","Nelly  29","Carine  29","Carine  30","Nelly  30","Sivilay  30","Emilie  30","Lova  30"]
["Semaine 8","Victoria  5","Victoria  21","Victoria  30","Alexis  30","Anthony  30","John  30","Pierre-Yves  30","Laurent  30","Sami  30","Marvin  30","Marvin  31","Sami  31"]
["Semaine 9","Lova  5","Lova  21","Laurent  31","Pierre-Yves  31","John  31","Anthony  31","Alexis  31","Victoria  31","Lova  31","Emilie  31","Sivilay  31","Nelly  31"]
["Semaine 10","Emilie  5","Emilie  21","Carine  31","Carine  32","Nelly  32","Sivilay  32","Emilie  32","Lova  32","Victoria  32","Alexis  32","Anthony  32","John  32"]
["Semaine 11","Sivilay  5","Sivilay  21","Pierre-Yves  32","Laurent  32","Sami  32","Marvin  32","Marvin  33","Sami  33","Laurent  33","Pierre-Yves  33","John  33","Anthony  33"]
["Semaine 12","Nelly  5","Nelly  21","Alexis  33","Victoria  33","Lova  33","Emilie  33","Sivilay  33","Nelly  33","Carine  33","Carine  34","Nelly  34","Sivilay  34"]
["Semaine 13","Carine  5","Carine  21","Emilie  34","Lova  34","Victoria  34","Alexis  34","Anthony  34","John  34","Pierre-Yves  34","Laurent  34","Sami  34","Marvin  34"]
["Semaine 14","Carine  10","Carine  22","Marvin  35","Sami  35","Laurent  35","Pierre-Yves  35","John  35","Anthony  35","Alexis  35","Victoria  35","Lova  35","Emilie  35"]
["Semaine 15","Nelly  10","Nelly  22","Sivilay  35","Nelly  35","Carine  35","Carine  36","Nelly  36","Sivilay  36","Emilie  36","Lova  36","Victoria  36","Alexis  36"]
["Semaine 16","Sivilay  10","Sivilay  22","Anthony  36","John  36","Pierre-Yves  36","Laurent  36","Sami  36","Marvin  36","Marvin  37","Sami  37","Laurent  37","Pierre-Yves  37"]
["Semaine 17","Emilie  10","Emilie  22","John  37","Anthony  37","Alexis  37","Victoria  37","Lova  37","Emilie  37","Sivilay  37","Nelly  37","Carine  37","Carine  38"]
["Semaine 18","Lova  10","Lova  22","Nelly  38","Sivilay  38","Emilie  38","Lova  38","Victoria  38","Alexis  38","Anthony  38","John  38","Pierre-Yves  38","Laurent  38"]
["Semaine 19","Victoria  10","Victoria  22","Sami  38","Marvin  38","Marvin  39","Sami  39","Laurent  39","Pierre-Yves  39","John  39","Anthony  39","Alexis  39","Victoria  39"]
["Semaine 20","Alexis  10","Alexis  22","Lova  39","Emilie  39","Sivilay  39","Nelly  39","Carine  39","Carine  40","Nelly  40","Sivilay  40","Emilie  40","Lova  40"]
["Semaine 21","Anthony  10","Anthony  22","Victoria  40","Alexis  40","Anthony  40","John  40","Pierre-Yves  40","Laurent  40","Sami  40","Marvin  40","Marvin  41","Sami  41"]
["Semaine 22","John  10","John  22","Laurent  41","Pierre-Yves  41","John  41","Anthony  41","Alexis  41","Victoria  41","Lova  41","Emilie  41","Sivilay  41","Nelly  41"]
["Semaine 23","Pierre-Yves  10","Pierre-Yves  22","Carine  41","Carine  42","Nelly  42","Sivilay  42","Emilie  42","Lova  42","Victoria  42","Alexis  42","Anthony  42","John  42"]
["Semaine 24","Laurent  10","Laurent  22","Pierre-Yves  42","Laurent  42","Sami  42","Marvin  42","Marvin  43","Sami  43","Laurent  43","Pierre-Yves  43","John  43","Anthony  43"]
["Semaine 25","Sami  10","Sami  22","Alexis  43","Victoria  43","Lova  43","Emilie  43","Sivilay  43","Nelly  43","Carine  43","Carine  44","Nelly  44","Sivilay  44"]
["Semaine 26","Marvin  10","Marvin  22","Emilie  44","Lova  44","Victoria  44","Alexis  44","Anthony  44","John  44","Pierre-Yves  44","Laurent  44","Sami  44","Marvin  44"]
["Semaine 27","Marvin  15","Marvin  23","Marvin  45","Sami  45","Laurent  45","Pierre-Yves  45","John  45","Anthony  45","Alexis  45","Victoria  45","Lova  45","Emilie  45"]
["Semaine 28","Sami  15","Sami  23","Sivilay  45","Nelly  45","Carine  45","Carine  46","Nelly  46","Sivilay  46","Emilie  46","Lova  46","Victoria  46","Alexis  46"]
["Semaine 29","Laurent  15","Laurent  23","Anthony  46","John  46","Pierre-Yves  46","Laurent  46","Sami  46","Marvin  46","Marvin  47","Sami  47","Laurent  47","Pierre-Yves  47"]
["Semaine 30","Pierre-Yves  15","Pierre-Yves  23","John  47","Anthony  47","Alexis  47","Victoria  47","Lova  47","Emilie  47","Sivilay  47","Nelly  47","Carine  47","Carine  48"]
["Semaine 31","John  15","John  23","Nelly  48","Sivilay  48","Emilie  48","Lova  48","Victoria  48","Alexis  48","Anthony  48","John  48","Pierre-Yves  48","Laurent  48"]
["Semaine 32","Anthony  15","Anthony  23","Sami  48","Marvin  48","Marvin  49","Sami  49","Laurent  49","Pierre-Yves  49","John  49","Anthony  49","Alexis  49","Victoria  49"]
["Semaine 33","Alexis  15","Alexis  23","Lova  49","Emilie  49","Sivilay  49","Nelly  49","Carine  49","Carine  50","Nelly  50","Sivilay  50","Emilie  50","Lova  50"]
["Semaine 34","Victoria  15","Victoria  23","Victoria  50","Alexis  50","Anthony  50","John  50","Pierre-Yves  50","Laurent  50","Sami  50","Marvin  50","Marvin  51","Sami  51"]
["Semaine 35","Lova  15","Lova  23","Laurent  51","Pierre-Yves  51","John  51","Anthony  51","Alexis  51","Victoria  51","Lova  51","Emilie  51","Sivilay  51","Nelly  51"]
["Semaine 36","Emilie  15","Emilie  23","Carine  51","Carine  52","Nelly  52","Sivilay  52","Emilie  52","Lova  52","Victoria  52","Alexis  52","Anthony  52","John  52"]
["Semaine 37","Sivilay  15","Sivilay  23","Pierre-Yves  52","Laurent  52","Sami  52","Marvin  52","Marvin  53","Sami  53","Laurent  53","Pierre-Yves  53","John  53","Anthony  53"]
["Semaine 38","Nelly  15","Nelly  23","Alexis  53","Victoria  53","Lova  53","Emilie  53","Sivilay  53","Nelly  53","Carine  53","Carine  54","Nelly  54","Sivilay  54"]
["Semaine 39","Carine  15","Carine  23","Emilie  54","Lova  54","Victoria  54","Alexis  54","Anthony  54","John  54","Pierre-Yves  54","Laurent  54","Sami  54","Marvin  54"]
["Semaine 40","Carine  20","Carine  24","Marvin  55","Sami  55","Laurent  55","Pierre-Yves  55","John  55","Anthony  55","Alexis  55","Victoria  55","Lova  55","Emilie  55"]
["Semaine 41","Nelly  20","Nelly  24","Sivilay  55","Nelly  55","Carine  55","Carine  56","Nelly  56","Sivilay  56","Emilie  56","Lova  56","Victoria  56","Alexis  56"]
["Semaine 42","Sivilay  20","Sivilay  24","Anthony  56","John  56","Pierre-Yves  56","Laurent  56","Sami  56","Marvin  56","Marvin  57","Sami  57","Laurent  57","Pierre-Yves  57"]
["Semaine 43","Emilie  20","Emilie  24","John  57","Anthony  57","Alexis  57","Victoria  57","Lova  57","Emilie  57","Sivilay  57","Nelly  57","Carine  57","Carine  58"]
["Semaine 44","Lova  20","Lova  24","Nelly  58","Sivilay  58","Emilie  58","Lova  58","Victoria  58","Alexis  58","Anthony  58","John  58","Pierre-Yves  58","Laurent  58"]
["Semaine 45","Victoria  20","Victoria  24","Sami  58","Marvin  58","Marvin  59","Sami  59","Laurent  59","Pierre-Yves  59","John  59","Anthony  59","Alexis  59","Victoria  59"]
["Semaine 46","Alexis  20","Alexis  24","Lova  59","Emilie  59","Sivilay  59","Nelly  59","Carine  59","Carine  60","Nelly  60","Sivilay  60","Emilie  60","Lova  60"]
["Semaine 47","Anthony  20","Anthony  24","Victoria  60","Alexis  60","Anthony  60","John  60","Pierre-Yves  60","Laurent  60","Sami  60","Marvin  60","Marvin  61","Sami  61"]
["Semaine 48","John  20","John  24","Laurent  61","Pierre-Yves  61","John  61","Anthony  61","Alexis  61","Victoria  61","Lova  61","Emilie  61","Sivilay  61","Nelly  61"]
["Semaine 49","Pierre-Yves  20","Pierre-Yves  24","Carine  61","Carine  62","Nelly  62","Sivilay  62","Emilie  62","Lova  62","Victoria  62","Alexis  62","Anthony  62","John  62"]
["Semaine 50","Laurent  20","Laurent  24","Pierre-Yves  62","Laurent  62","Sami  62","Marvin  62","Marvin  63","Sami  63","Laurent  63","Pierre-Yves  63","John  63","Anthony  63"]
["Semaine 51","Sami  20","Sami  24","Alexis  63","Victoria  63","Lova  63","Emilie  63","Sivilay  63","Nelly  63","Carine  63","Carine  64","Nelly  64","Sivilay  64"]
["Semaine 52","Marvin  20","Marvin  24","Emilie  64","Lova  64","Victoria  64","Alexis  64","Anthony  64","John  64","Pierre-Yves  64","Laurent  64","Sami  64","Marvin  64"]
[null,"Somme Urgent","Somme AC",null,"Somme Appel"]
["Marvin",4,4,null,40]
["Sami",4,4,null,40]
["Laurent",4,4,null,40]
["Pierre-Yves",4,4,null,40]
["John",4,4,null,40]
["Anthony",4,4,null,40,{"$nulls":6},"Alexis"]
["Alexis",4,4,null,40]
["Victoria",4,4,null,40,{"$nulls":6},"Carine"]
["Lova",4,4,null,40]
["Emilie",4,4,null,40,{"$nulls":6},"Marvin"]
["Sivilay",4,4,null,40]
["Nelly",4,4,null,40]
["Carine",4,4,null,40]
[]
[null,4,4,null,40]
[null,0,0,null,0]
[null,0,0,null,0]

{"sheet":"Feuil3","index":2,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[2,0,2,4],[31,0,31,6],[36,0,36,6],[41,0,41,6],[46,0,46,6],[28,12,28,16],[29,12,29,16],[33,7,34,8],[33,10,34,11],[38,13,39,15],[2,6,2,10],[48,10,49,11],[53,10,54,11],[51,0,51,6],[29,0,29,4],[29,7,29,8],[29,10,29,11],[61,13,62,14],[67,13,68,14],[72,13,73,14],[43,13,44,15],[38,7,39,8],[43,7,44,8],[48,7,49,8],[53,7,54,8],[38,10,39,11],[43,10,44,11],[77,13,78,14],[82,13,83,14],[33,17,34,18],[38,17,39,18],[43,17,44,18],[48,17,49,18],[53,17,54,18],[33,13,34,15],[48,13,49,15],[53,13,54,15]],"flags":["formulas_cached_only"]}
[]
[]
["CHOIX SANS PRORATA",{"$nulls":5},"CHOIX AVEC PRORATA"]
["Marvin",4,4,null,40,null,"Marvin",4,6,null,41]
["Sami",4,4,null,40,null,"Sami",4,4,null,42]
["Laurent",4,4,null,40,null,"Laurent",4,5,null,42]
["Pierre-Yves",4,4,null,40,null,"Pierre-Yves",4,5,null,42]
["John",4,4,null,40,null,"John",4,5,null,42]
["Anthony",4,4,null,40,null,"Anthony",4,0,null,42]
["Alexis",4,4,null,40,null,"Alexis",4,0,null,34]
["Victoria",4,4,null,40,null,"Victoria",4,5,null,42]
["Lova",4,4,null,40,null,"Lova",4,5,null,42]
["Emilie",4,4,null,40,null,"Emilie",4,5,null,42]
["Sivilay",4,4,null,40,null,"Sivilay",4,6,null,41]
["Nelly",4,4,null,40,null,"Nelly",4,5,null,42]
["Carine",4,4,null,40,null,"Carine",3,0,null,26]
[]
[null,4,4,null,40,null,null,3.923076923076923,3.923076923076923,null,40]
[null,0,0,null,0,null,null,0.14201183431952677,1.8106508875739646,null,3.076923076923077]
[null,0,0,null,0,null,null,1,6,null,16]
[null,1,1,null,0]
{"$rows_empty":7}
[{"$nulls":12},"Remplissage du tableau 1 \"Tcharge\" pour ce qui est en gras"]
["Tester si le tableau 2 \"Charge\" est vide ?",{"$nulls":6},"Test du début, avant tout",null,"Erase","Test après erase",null,"Remplissage du tableau 2 \"Charge\" pour ce qui est pas gras",{"$nulls":4},"Test de fin"]
[]
["GRAS A GRAS"]
["Prorata","Personne","Charge",null,"Prorata","Personne","Charge"]
[1,"Marvin",0,null,1,"Marvin",0,"TABLEAU 2 VIDE",null,null,"TABLEAU 2 VIDE",null,null,"La condition \"est ce pas en gras\" ne s'active pas",null,null,null,"TABLEAU 2 VIDE"]
[1,"Sami",0,null,1,"Sami",0]
[]
["GRAS A PAS GRAS"]
["Prorata","Personne","Charge",null,"Prorata","Personne","Charge"]
[1,"Marvin",0,null,1,"Marvin",0,"TABLEAU 2 VIDE",null,null,"TABLEAU 2 VIDE",null,null,"La condition \"est ce pas en gras\" s'active",null,null,null,"TABLEAU 2 PLEIN"]
[1,"Sami",0,null,1,"Sami",0]
[]
["PAS GRAS A PAS GRAS"]
["Prorata","Personne","Charge",null,"Prorata","Personne","Charge"]
[1,"Marvin",0,null,1,"Marvin",0,"TABLEAU 2 PLEIN",null,null,"TABLEAU 2 PLEIN",null,null,"La condition \"est ce pas en gras\" s'active",null,null,null,"TABLEAU 2 PLEIN"]
[1,"Sami",0,null,1,"Sami",0]
[]
["PAS GRAS A GRAS"]
["Prorata","Personne","Charge",null,"Prorata","Personne","Charge"]
[1,"Marvin",0,null,1,"Marvin",0,"TABLEAU 2 PLEIN",null,null,"TABLEAU 2 PLEIN",null,null,"La condition \"est ce pas en gras\" ne s'active pas",null,null,null,"TABLEAU 2 PLEIN"]
[1,"Sami",0,null,1,"Sami",0]
[]
["GRAS A GRAS"]
["Prorata","Personne","Charge",null,"Prorata","Personne","Charge"]
[1,"Marvin",0,null,1,"Marvin",0,"TABLEAU 2 VIDE",null,null,"TABLEAU 2 VIDE",null,null,"La condition \"est ce pas en gras\" ne s'active pas",null,null,null,"TABLEAU 2 VIDE"]
[1,"Sami",0,null,1,"Sami",0]
[]
[]
[]
[]
[]
[]
[{"$nulls":13},"TABLEAU 2 VIDE"]
[]
[]
[]
[]
[]
[{"$nulls":13},"TABLEAU 2 PLEIN"]
[]
[]
[]
[]
[{"$nulls":13},"TABLEAU 2 PLEIN"]
[]
[]
[]
[]
[{"$nulls":13},"TABLEAU 2 PLEIN"]
[]
[]
[]
[]
[{"$nulls":13},"TABLEAU 2 VIDE"]