{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BASE","EDIT"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"BASE","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["code article","désignation","quantité","date import"]
["AA004","type 4",8,"2015-03-19"]
["AA001","type 1",5,"2015-10-23"]
["AA005","type 5",2,"2016-03-31"]
["AA003","type 1",2,"2015-08-24"]
["AA003","type 4",8,"2015-12-22"]
["AA001","type 4",8,"2016-01-11"]
["AA003","type 1",7,"2016-01-15"]
["AA004","type 1",10,"2016-02-20"]
["AA004","type 2",5,"2015-02-24"]
["AA004","type 4",6,"2015-03-20"]
["AA002","type 2",7,"2015-02-23"]
["AA002","type 5",3,"2016-04-20"]
["AA002","type 3",12,"2016-01-31"]
["AA005","type 3",10,"2015-10-11"]
["AA002","type 4",8,"2015-11-28"]
["AA003","type 5",8,"2015-12-22"]
["AA002","type 3",1,"2016-03-11"]
["AA002","type 5",4,"2015-10-03"]
["AA001","type 3",12,"2015-11-04"]
["AA005","type 2",8,"2015-02-22"]
["AA003","type 4",12,"2015-03-18"]
["AA001","type 2",7,"2015-12-02"]
["AA003","type 2",4,"2015-03-21"]
["AA005","type 5",6,"2015-11-12"]
["AA001","type 1",5,"2016-03-03"]
["AA004","type 3",3,"2015-09-13"]
["AA005","type 2",4,"2016-03-27"]
["AA005","type 5",1,"2015-09-17"]
["AA004","type 3",6,"2016-02-08"]
["AA001","type 1",10,"2015-02-21"]

{"sheet":"EDIT","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["code article","date maxi","quantité à date"]
["AA001",{"$f":"MAX(IF(BASE!$A$2:$A$50=A2,BASE!$D$2:$D$50))","v":"2016-03-03"},{"$f":"INDEX(BASE!$C$2:$C$50,MATCH(A2&B2,BASE!$A$2:$A$50&BASE!$D$2:$D$50,0))","v":5}]
["AA002",{"$f":"MAX(IF(BASE!$A$2:$A$50=A3,BASE!$D$2:$D$50))","v":"2016-04-20"},{"$f":"INDEX(BASE!$C$2:$C$50,MATCH(A3&B3,BASE!$A$2:$A$50&BASE!$D$2:$D$50,0))","v":3}]
["AA003",{"$f":"MAX(IF(BASE!$A$2:$A$50=A4,BASE!$D$2:$D$50))","v":"2016-01-15"},{"$f":"INDEX(BASE!$C$2:$C$50,MATCH(A4&B4,BASE!$A$2:$A$50&BASE!$D$2:$D$50,0))","v":7}]
["AA004",{"$f":"MAX(IF(BASE!$A$2:$A$50=A5,BASE!$D$2:$D$50))","v":"2016-02-20"},{"$f":"INDEX(BASE!$C$2:$C$50,MATCH(A5&B5,BASE!$A$2:$A$50&BASE!$D$2:$D$50,0))","v":10}]
["AA005",{"$f":"MAX(IF(BASE!$A$2:$A$50=A6,BASE!$D$2:$D$50))","v":"2016-03-31"},{"$f":"INDEX(BASE!$C$2:$C$50,MATCH(A6&B6,BASE!$A$2:$A$50&BASE!$D$2:$D$50,0))","v":2}]