{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stock","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Stock","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,"2019-10-29"]
["Code","Libellé","Catégorie","1900-01-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01"]
["dummy1","article1","Sorties"]
["dummy1","article1","Besoins dépendants",null,1,1,1,1]
["dummy1","article1","Commandes clients"]
["dummy1","article1","Productions confirmées"]
["dummy1","article1","Productions planifiées"]
["dummy1","article1","Stock",null,{"$f":"D8-D3-D4-D5+D6+D7-E3-E4-E5+E6+E7","v":-1},{"$f":"E8-F3-F4-F5+F6+F7","v":-2},{"$f":"F8-G3-G4-G5+G6+G7","v":-3},-4,-4,-4,-4,-4]
["dummy1","article1","Stock Couv (Mois)",{"$f":"IF(D8/SUM(D3:D5)<=1,D8/SUM(D3:D5),IF(D8/SUM(D3:E5)<=1,1+D8/SUM(D3:E5),IF(D8/SUM(D3:F5)<=1,2+D8/SUM(D3:F5),IF(D8/SUM(D3:G5)<=1,3+D8/SUM(D3:G5),IF(D8/SUM(D3:H5)<=1,4+D8/SUM(D3:H5),\">=5\")))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E8/SUM(F3:F5)<=1,E8/SUM(F3:F5),IF(E8/SUM(F3:G5)<=1,1+E8/SUM(F3:G5),IF(E8/SUM(F3:H5)<=1,2+E8/SUM(F3:H5),IF(E8/SUM(F3:H5)<=1,3+E8/SUM(F3:I5),IF(E8/SUM(F3:J5)<=1,4+E8/SUM(F3:J5),\">=5\")))))","v":-1},{"$f":"IF(F8/SUM(G3:G5)<=1,F8/SUM(G3:G5),IF(F8/SUM(G3:H5)<=1,1+F8/SUM(G3:H5),IF(F8/SUM(G3:I5)<=1,2+F8/SUM(G3:I5),IF(F8/SUM(G3:I5)<=1,3+F8/SUM(G3:J5),IF(F8/SUM(G3:K5)<=1,4+F8/SUM(G3:K5),\">=5\")))))","v":-2},-3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["dummy2","article2","Sorties"]
["dummy2","article2","Besoins dépendants",null,null,null,5,33,35,28,19,26]
["dummy2","article2","Commandes clients",null,170,20]
["dummy2","article2","Productions confirmées",null,114,null,220]
["dummy2","article2","Productions planifiées",null,null,null,null,null,null,null,60]
["dummy2","article2","Stock"]
["dummy2","article2","Stock Couv (Mois)"]
["dummy3","article3","Sorties",null,4,450,450,390,390,468,416,416]
["dummy3","article3","Besoins dépendants",null,null,83,null,59,null,66]
["dummy3","article3","Commandes clients",null,131,25]
["dummy3","article3","Productions confirmées",null,null,1425]
["dummy3","article3","Productions planifiées",null,null,null,null,null,1425,null,null,1140]
["dummy3","article3","Stock"]
["dummy3","article3","Stock Couv (Mois)"]
["dummy4","article4","Sorties",null,null,null,null,null,1000,5500,2500,2000]
["dummy4","article4","Besoins dépendants",null,98610,33681,25620,52800,13820,79860,445,16745]
["dummy4","article4","Commandes clients",null,2380,18350,null,23050,null,39800]
["dummy4","article4","Productions confirmées",null,null,55000,null,84608]
["dummy4","article4","Productions planifiées",null,null,null,null,null,null,98056,null,41888]
["dummy4","article4","Stock"]
["dummy4","article4","Stock Couv (Mois)"]
["dummy5","article5","Sorties",null,5604,null,null,null,5500,6435,7997,4112]
["dummy5","article5","Besoins dépendants",null,132,15081]
["dummy5","article5","Commandes clients",null,5040,81544,null,31880,null,null,76680]
["dummy5","article5","Productions confirmées",null,null,131500,null,null,null,20160]
["dummy5","article5","Productions planifiées",null,null,null,null,null,null,null,66528]
["dummy5","article5","Stock"]
["dummy5","article5","Stock Couv (Mois)"]
["dummy6","article6","Sorties",null,69,218,234,165,165,198,176,176]
["dummy6","article6","Besoins dépendants",null,null,83,null,59,null,66]
["dummy6","article6","Commandes clients",null,19,29]
["dummy6","article6","Productions confirmées",null,106,null,588]
["dummy6","article6","Productions planifiées",null,null,null,null,null,480,null,null,720]
["dummy6","article6","Stock"]
["dummy6","article6","Stock Couv (Mois)",1]
["dummy7","article7","Sorties",null,null,142,185,224,213,213,213,195]
["dummy7","article7","Besoins dépendants",null,null,83,null,59,null,66]
["dummy7","article7","Commandes clients",null,16,60]
["dummy7","article7","Productions confirmées",null,null,null,null,1500]
["dummy7","article7","Productions planifiées",null,null,null,null,null,null,null,null,1000]
["dummy7","article7","Stock",1]
["dummy7","article7","Stock Couv (Mois)"]

{"sheet":"Feuil2","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Code","Libellé","Catégorie"]
["dummy","article","Sorties"]
["dummy","article","Besoins dépendants"]
["dummy","article","Commandes clients"]
["dummy","article","Productions confirmées"]
["dummy","article","Productions planifiées"]
["dummy","article","Stock",100,{"$f":"D7-D2-D3-D4+D5+D6-E2-E3-E4+E5+E6","v":100},{"$f":"E7-F2-F3-F4+F5+F6","v":100}]
["dummy","article","Stock Couv (Mois)",{"$f":"IF(D7/SUM(D2:D4)<=1,D7/SUM(D2:D4),IF(D7/SUM(D2:E4)<=1,1+D7/SUM(D2:E4),IF(D7/SUM(D2:F4)<=1,2+D7/SUM(D2:F4),IF(D7/SUM(D2:G4)<=1,3+D7/SUM(D2:G4),IF(D7/SUM(D2:H4)<=1,4+D7/SUM(D2:H4),\">=5\")))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E7/SUM(F2:F4)<=1,E7/SUM(F2:F4),IF(E7/SUM(F2:G4)<=1,1+E7/SUM(F2:G4),IF(E7/SUM(F2:H4)<=1,2+E7/SUM(F2:H4),IF(E7/SUM(F2:H4)<=1,3+E7/SUM(F2:I4),IF(E7/SUM(F2:J4)<=1,4+E7/SUM(F2:J4),\">=5\")))))","v":{"$error":"#DIV/0!"}}]

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