{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,5],[0,6,0,8],[1,8,1,9],[3,0,15,0],[0,0,0,1]]}
["ANNEE  2017",null,"Date du jour",{"$f":"NOW()","v":"2017-06-13T08:23:06.320"}]
[null,null,null,null,null,null,null,null,"Nombre de territoires "]
[null,"ARTICLES","Noms","Rentré le","Sortie le","Alerte à J+115","A faire rentrer","Rendre à J+130","Urgent","Ecart de jours"]
[null,"objet1","A","2017-05-10",null,{"$f":"IF(E4=\"\",\"\",E4+115)","v":""},{"$f":"IF(AND(J4>=115,J4<=129),\"A faire rentrer\",\"\")","v":""},{"$f":"IF(E4=\"\",\"\",E4+130)","v":""},{"$f":"IF(J4>=130,\"Urgent\",\"\")","v":""},{"$f":"IF(E4=\"\",0,DATEDIF(E4,$D$1,\"D\"))","v":0},null,"A",null,{"$f":"IFERROR(RANK($D4,$D$4:$D$16)+COUNTIF($D$3:D3,D4)/1000,COUNTIF($D$3:D3,\"\")/1000)","v":2}]
[null,"objet2","H","2017-05-23",null,null,{"$f":"IF(AND(J5>=115,J5<=129),\"A faire rentrer\",\"\")","v":""},{"$f":"IF(E5=\"\",\"\",E5+130)","v":""},{"$f":"IF(J5>=130,\"Urgent\",\"\")","v":""},{"$f":"IF(E5=\"\",0,DATEDIF(E5,$D$1,\"D\"))","v":0},null,"B",null,{"$f":"IFERROR(RANK($D5,$D$4:$D$16)+COUNTIF($D$3:D4,D5)/1000,COUNTIF($D$3:D4,\"\")/1000)","v":1}]
[null,"objet3","G",null,"2017-05-09",{"$f":"IF(E7=\"\",\"\",E7+115)","v":"2017-05-02"},"","2017-09-16","",{"$f":"IF(E6=\"\",0,DATEDIF(E6,$D$1,\"D\"))","v":35},null,"C",null,{"$f":"IFERROR(RANK($D6,$D$4:$D$16)+COUNTIF($D$3:D5,D6)/1000,COUNTIF($D$3:D5,\"\")/1000)","v":0}]
[null,"objet4","I",null,"2017-01-07",{"$f":"IF(E7=\"\",\"\",E7+115)","v":"2017-05-02"},"","2017-05-17",{"$f":"IF(J7>=130,\"Urgent\",\"\")","v":"Urgent"},157,null,"D",null,{"$f":"IFERROR(RANK($D7,$D$4:$D$16)+COUNTIF($D$3:D6,D7)/1000,COUNTIF($D$3:D6,\"\")/1000)","v":1E-3}]
[null,"objet5","B","2017-03-30",null,"","","",{"$f":"IF(J8>=130,\"Urgent\",\"\")","v":""},0,null,"E",null,{"$f":"IFERROR(RANK($D8,$D$4:$D$16)+COUNTIF($D$3:D7,D8)/1000,COUNTIF($D$3:D7,\"\")/1000)","v":10}]
[null,"objet6","C","2017-04-09",null,{"$f":"IF(E9=\"\",\"\",E9+115)","v":""},{"$f":"IF(AND(J9>=115,J9<=129),\"A faire rentrer\",\"\")","v":""},{"$f":"IF(E9=\"\",\"\",E9+130)","v":""},{"$f":"IF(J9>=130,\"Urgent\",\"\")","v":""},0,null,"F",null,{"$f":"IFERROR(RANK($D9,$D$4:$D$16)+COUNTIF($D$3:D8,D9)/1000,COUNTIF($D$3:D8,\"\")/1000)","v":5}]
[null,"objet7","H","2017-04-11",null,{"$f":"IF(E10=\"\",\"\",E10+115)","v":""},{"$f":"IF(AND(J10>=115,J10<=129),\"A faire rentrer\",\"\")","v":""},{"$f":"IF(E10=\"\",\"\",E10+130)","v":""},{"$f":"IF(J10>=130,\"Urgent\",\"\")","v":""},0,null,"G",null,{"$f":"IFERROR(RANK($D10,$D$4:$D$16)+COUNTIF($D$3:D9,D10)/1000,COUNTIF($D$3:D9,\"\")/1000)","v":3}]
[null,"objet8","D","2017-04-01",null,"","","","",0,null,"H",null,{"$f":"IFERROR(RANK($D11,$D$4:$D$16)+COUNTIF($D$3:D10,D11)/1000,COUNTIF($D$3:D10,\"\")/1000)","v":7}]
[null,"objet9",null,"2017-04-01",null,"","","","",0,null,"I",null,{"$f":"IFERROR(RANK($D12,$D$4:$D$16)+COUNTIF($D$3:D11,D12)/1000,COUNTIF($D$3:D11,\"\")/1000)","v":7.0010000000000003}]
[null,"objet10","H",null,"2017-04-21",{"$f":"IF(E13=\"\",\"\",E13+115)","v":"2017-08-14"},"",{"$f":"IF(E13=\"\",\"\",E13+130)","v":"2017-08-29"},"",53,null,null,null,{"$f":"IFERROR(RANK($D13,$D$4:$D$16)+COUNTIF($D$3:D12,D13)/1000,COUNTIF($D$3:D12,\"\")/1000)","v":2E-3}]
[null,"objet11",null,"2017-04-09",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK($D14,$D$4:$D$16)+COUNTIF($D$3:D13,D14)/1000,COUNTIF($D$3:D13,\"\")/1000)","v":5.0010000000000003}]
[null,"objet12",null,"2017-04-11",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK($D15,$D$4:$D$16)+COUNTIF($D$3:D14,D15)/1000,COUNTIF($D$3:D14,\"\")/1000)","v":3.0009999999999999}]
[null,"objet13",null,"2017-04-01",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK($D16,$D$4:$D$16)+COUNTIF($D$3:D15,D16)/1000,COUNTIF($D$3:D15,\"\")/1000)","v":7.0019999999999998}]

{"sheet":"Feuil2","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Ordre de sortie"]
["Objet","date  rentré"]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A1)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet3"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B1)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"00:00:00"},null,"le système utilise la colonne N de Feuil1 qui peut être masquée ou déplacée sur une autre feuille"]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A2)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet4"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B2)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"00:00:00"},null,"les objet sont classés serlon les dates croissantes, "]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A3)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet10"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B3)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"00:00:00"},null,"les objets \"sans date\" d'entrée sont classés, en priorité en début de liste selon l'ordre de feuil1"]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A4)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet2"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B4)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-05-23"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A5)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet1"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B5)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-05-10"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A6)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet7"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B6)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-11"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A7)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet12"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B7)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-11"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A8)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet6"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B8)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-09"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A9)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet11"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B9)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-09"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A10)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet8"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B10)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-01"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A11)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet9"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B11)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-01"}]
[{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(A12)),Feuil1!$N$4:$N$16,0),1),\"\")","v":"objet13"},{"$f":"IFERROR(INDEX(Feuil1!$B$4:$J$16,MATCH(SMALL(Feuil1!$N$4:$N$16,ROW(B12)),Feuil1!$N$4:$N$16,0),3),\"\")","v":"2017-04-01"}]