{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Suivi","BDD","ToDoList"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":8,"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":"Dashboard","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,5,7,6],[0,0,0,8],[6,7,7,8],[9,5,10,6],[9,7,10,8],[3,5,4,6],[3,7,4,8],[1,7,1,8],[15,0,16,1],[15,2,16,3],[3,2,4,3],[6,0,7,1],[6,2,7,3],[9,2,10,3],[12,2,13,3],[3,0,4,1],[9,0,10,1],[12,0,13,1]]}
["Tableau de bord des colis réutilisables"]
["Sélectionnez un colis :",null,null,null,null,null,null,3]
[]
["Première date d'arrivée chez AfB :",null,{"$f":"_xlfn.MINIFS(Tableau1[Date réception\n  AFB/boutique],Tableau1[[Colis ]],$H$2)","v":"2022-04-01"},null,null,"Dernière date d'arrivée chez AfB :",null,{"$f":"_xlfn.MAXIFS(Tableau1[Date réception\n  AFB/boutique],Tableau1[[Colis ]],$H$2)","v":"2023-04-04"}]
[]
[]
["Premier état :",null,{"$f":"INDEX(Tableau1[[Colis ]:[Commentaires état]],MATCH(TEXT($H$2,\"@\"),Tableau1[[Colis ]],0),4)","v":"utilisable"},null,null,"Dernier état :",null,{"$f":"INDEX(Tableau1[[Colis ]:[Commentaires état]],MATCH(1,(Tableau1[[Colis ]]=TEXT($H$2,\"@\"))*(Tableau1[Date réception\n  AFB/boutique]=$H$4),0),4)","v":"endommagé"}]
[]
[]
["Premier commentaire :",null,{"$f":"INDEX(Tableau1[[Colis ]:[Commentaires état]],MATCH(TEXT($H$2,\"@\"),Tableau1[[Colis ]],0),5)","v":"ame 3 1"},null,null,"Dernier commentaire :",null,{"$f":"INDEX(Tableau1[[Colis ]:[Commentaires état]],MATCH(1,(Tableau1[[Colis ]]=TEXT($H$2,\"@\"))*(Tableau1[Date réception\n  AFB/boutique]=$H$4),0),5)","v":"ame 3 2"}]
[]
[]
["Nombre de passages du colis chez AfB :",null,{"$f":"COUNTIF(Tableau1[[Colis ]],Dashboard!H2)","v":2}]
[]
[]
["Nombre de jours entre chaques passages :",null,{"$f":"DATEDIF($C$4,$H$4,\"d\")","v":368}]

{"sheet":"Suivi","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Fiche de suivi des colis réutilisables",null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-11-17"}]
["Colis ","N° Chronopost","Date réception\n  AFB/boutique","Etat du colis réutilisable ","Commentaires état","Accessoires\n de calage ","Origine\n du produit ","Améliorations (ergonomie d'utilisation, suggestions)"]
["2","chrono1","2022-01-01","neuf","ame1","bulles","Dotation","comment1"]
["5","chrono2","2022-02-02","utilisable","ame 05 01","bulles","RE","comment 5 1"]
["1","chrono 1 1","2022-03-03","endommagé","ame 1 1","autre","RE","com 1 1 "]
["3","chrono 3 1","2022-04-01","utilisable","ame 3 1","bulles","RE","ame 3 1"]
["4","chrono 4 1","2022-04-02","endommagé","ame 4 1","autre","Dotation","comm 4 1"]
["2","chrono 2 2","2023-02-03","utilisable","ame 2 2","autre","RE","comm 2 2"]
["5","chrono 5 2","2023-04-03","endommagé","ame 5 2","bulles","RE","comm 5 2"]
["1","chrono 1 2","2023-04-04","inutilisable","ame 1 2","autre","RE","comm 1 2"]
["3","chrono 3 2","2023-04-04","endommagé","ame 3 2","autre","RE","comm 3 2"]
["4","chrono 4 2","2023-06-06","inutilisable","ame 4 2","bulles","RE","comm 4 2"]

{"sheet":"BDD","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[1,null,"neuf",null,"bulles",null,"RE"]
[2,null,"utilisable",null,"autre",null,"Dotation"]
[3,null,"endommagé"]
[4,null,"inutilisable"]
[5]

{"sheet":"ToDoList","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}