{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil7","Version basique manuelle"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":0,"defined_names":15,"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":"Feuil1","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,6,1,6],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5]]}
["Jour actuel","Début","Durée (Sem)","Fin","Réalisation","Jours passés de l'étape","Jours restants de l'étape","Jours restants avant échéance"]
[{"$f":"TODAY()","v":"2018-03-26"},null,null,null,null,null,null,null,null,null,"Mail des destinataires"]
["A1- Intégration","2018-04-03",4,"2018-04-13",{"$f":"IF(($A$2-B3)<=0,0,IF((($A$2-B3)/(D3-B3))>=1,1,(($A$2-B3)/(D3-B3))))","v":0},{"$f":"(D3-B3)*E3","v":0},{"$f":"D3-B3-F3","v":10},{"$f":"D3-$A$2","v":18},{"$f":"IF((D3-$A$2)<=0,\"Fini\",IF((D3-$A$2)<=7,\"Attention\",\"\"))","v":""},{"$f":"IF((D3-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["A2- Formation Production Qualité","2018-04-09",5,"2018-04-27",{"$f":"IF(($A$2-B4)<=0,0,IF((($A$2-B4)/(D4-B4))>=1,1,(($A$2-B4)/(D4-B4))))","v":0},0,{"$f":"D4-B4-F4","v":18},{"$f":"D4-$A$2","v":32},{"$f":"IF((D4-$A$2)<=0,\"Fini\",IF((D4-$A$2)<=7,\"Attention\",\"\"))","v":""},{"$f":"IF((D4-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["A3- Recensement KPI","2018-04-09",3,"2018-06-29",0,0,81,95,"",{"$f":"IF((D5-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["A4- Moyen d'enregistrement","2018-05-02",4,"2018-07-31",0,0,90,127,"",{"$f":"IF((D6-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["A5- Moyen de suivi - Tableau de bord","2018-05-02",8,"2018-08-31",0,0,121,158,"",{"$f":"IF((D7-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["A6- Création de KPI et implantation","2018-04-09",2,"2018-09-28",0,0,172,186,"",{"$f":"IF((D8-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["B1-CHRV- Listing produits","2018-04-03",3,"2018-05-09",0,0,36,44,"",{"$f":"IF((D9-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["B2-CHRV- Listing éléments à nettoyer","2018-04-03",4,"2018-05-31",0,0,58,66,"",{"$f":"IF((D10-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["B3-CHRV- MAJ PND","2018-05-02",2,"2018-07-31",0,0,90,127,"",{"$f":"IF((D11-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["B4-CHRV- Implantation (Affichage, formation)","2018-07-02",3,"2018-09-28",0,0,88,186,"",{"$f":"IF((D12-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["C1-CHRV- Planing Hakim","2018-04-03",3,"2018-04-13",0,{"$f":"(D13-B13)*E13","v":0},{"$f":"D13-B13-F13","v":10},18,"",{"$f":"IF((D13-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["C2-CHRV- Listing éléments à contrôler","2018-04-09",3,"2018-04-30",0,0,21,35,"",{"$f":"IF((D14-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["C3-CHRV- Checklist","2018-05-02",3,"2018-05-31",0,0,29,66,"",{"$f":"IF((D15-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["C4-CHRV- Système de notation","2018-05-02",3,"2018-05-31",0,0,29,66,"",{"$f":"IF((D16-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
["C5-CHRV- Audits et évaluation","2018-06-01",4,{"$f":"B17+C17*7","v":"2018-06-29"},0,{"$f":"(D17-B17)*E17","v":0},{"$f":"D17-B17-F17","v":28},95,"",{"$f":"IF((D17-$A$2)<=7,Feuil7!$A$3,Feuil7!$A$4)","v":2}]
[]
[]
["> Graphique en barres"]
[]
[null,{"$f":"B3","v":43193}]

{"sheet":"Feuil7","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Image"]
[1,{"$f":"\"Feuil7!\"&D3","v":"Feuil7!$C$3"},null,{"$f":"CELL(\"adresse\",C3)","v":"$C$3"}]
[2,{"$f":"\"Feuil7!\"&D4","v":"Feuil7!$C$4"},null,{"$f":"CELL(\"adresse\",C4)","v":"$C$4"}]

{"sheet":"Version basique manuelle","index":2,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Nombre de semaines",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["Acceptation des plans","A",4]
["Preparation du terrain","B",2]
["Creusage des fondations","D",1]
["Coulage des fondations","G",2]
["Comande des materiaux","C",1]
["Livraison des materiaux","F",2]
["Commade des portes et fenetres","E",2]
["Livraison des portes et fenetres","H",9]
["Mise en place des portes et fenetres","J",1]
["Pose des murs, charpente, toit","I",8]
[]
["Exemple :"]
["Tu dois remplir les tâche"]
["Tu dois colorer les cases de la plage horaire de la tâche"]
[]
["Rapide mais peu évolué"]