{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Recap","Détail"],"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":"Recap","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Suivi avancement inventaire S 40_2016"]
[]
[null,"Date d'importation","2016-09-28T08:01:53"]
[null,"N° de semaine","40_2016"]
[]
[null,"Statut","Nbre de ligne","Valeur",null,null,"Nbre de ligne","Valeur"]
[null,1,{"$f":"COUNTIF(Détail!X:X,B7)","v":0},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B7)","v":0},null,{"$f":"B10","v":5},{"$f":"C10","v":7},43]
[null,2,{"$f":"COUNTIF(Détail!X:X,B8)","v":0},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B8)","v":0},null,{"$f":"B11","v":6},{"$f":"C11","v":4},85,null,null,"macro-ajout-de-colonne-en-fonction-de-la-semaine"]
[null,3,{"$f":"COUNTIF(Détail!X:X,B9)","v":0},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B9)","v":0},null,{"$f":"B12","v":7},{"$f":"C12","v":0},0]
[null,5,{"$f":"COUNTIF(Détail!X:X,B10)","v":7},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B10)","v":43},null,"Total",{"$f":"SUM(G7:G9)","v":11},{"$f":"SUM(H7:H9)","v":128}]
[null,6,{"$f":"COUNTIF(Détail!X:X,B11)","v":4},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B11)","v":85},null,"Pourcentage",{"$f":"G10/C14","v":1},{"$f":"H10/D14","v":1}]
[null,7,{"$f":"COUNTIF(Détail!X:X,B12)","v":0},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B12)","v":0},null,"Reste a inventorier",{"$f":"C14-G10","v":0}]
[null,8,{"$f":"COUNTIF(Détail!X:X,B13)","v":0},{"$f":"SUMIFS(Détail!AF:AF,Détail!X:X,Recap!B13)","v":0}]
[null,"Total",{"$f":"SUM(C7:C13)","v":11},{"$f":"SUM(D7:D13)","v":128}]

{"sheet":"Détail","index":1,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Date d'importation","Suivi lignes inventoriées","Période","Y/N","OP","Article","Article2","Numéro","Numéro2","Numéro3","Magasin","Magasinchamps2","Emplacement1","Emplacement2","Emplacement3","Emplacement4","Emplacement5","X","Y","Type","Quantité "," UDM","CUMP","Statut de l'inventaire","Date","Nom","Ligne ","Nom","ID","Date","ID 2","Valeurs"]
["2016-09-28T08:01:53",{"$f":"CONCATENATE(F2,\".\",H2,\".\",M2,\".\",N2,\".\",O2,\".\",P2,\".\",Q2,\".\",R2,\".\",S2)","v":"A.R1.1-V3.12.AB.-.X.A3.A30"},"2016-09-28T08:01:53","X","RU","A","Y","R1",null,null,1,1,"1-V3",12,"AB","-","X","A3","A30",3,1,"NB",1,5,"2016-07-01","XZ202",369,null,null,null,null,{"$f":"W2*U2","v":1}]
["2016-09-28T08:01:53",{"$f":"CONCATENATE(F3,\".\",H3,\".\",M3,\".\",N3,\".\",O3,\".\",P3,\".\",Q3,\".\",R3,\".\",S3)","v":"A.R21.1-V3.12.AB.-.X.A7.A71"},"2016-09-28T08:01:53","X","RU","A","C","R21",null,null,1,1,"1-V3",12,"AB","-","X","A7","A71",3,7,"NB",1,6,null,null,null,null,18,null,null,{"$f":"W3*U3","v":7}]
["2016-09-28T08:01:53","A.R31.1-V3.12.DB.-.X.A2.A20","2016-09-28T08:01:53","X","RU","A","V","R31",null,null,1,1,"1-V3",12,"DB","-","X","A2","A20",3,73,"NB",1,6,null,null,null,null,18,null,null,73]
["2016-09-28T08:01:53","A.R18.1-V3.12.CD.-.X..","2016-09-28T08:01:53","X","RU","A","R","R18",null,null,1,1,"1-V3",12,"CD","-","X",null,null,3,1,"NB",1,6,null,null,null,null,18,null,null,1]
["2016-09-28T08:01:53","A.R3.1-V3.12.AB.-.X.B5.B52","2016-09-28T08:01:53","X","RU","A","E","R3",null,null,1,1,"1-V3",12,"AB","-","X","B5","B52",3,10,"NB",1,5,"2016-07-01","XZ202",371,null,null,null,null,10]
["2016-09-28T08:01:53","A.Z2.1-V3.12.DB.-.X..","2016-09-28T08:01:53","X","RU","A","T","Z2",null,null,1,1,"1-V3",12,"DB","-","X",null,null,3,8,"NB",1,5,"2016-07-01","XZ202",372,null,null,null,null,8]
["2016-09-28T08:01:53","B.H2.1-V3.12.DB.-.X.F8.F81","2016-09-28T08:01:53","X","RU","B","E","H2",null,null,1,1,"1-V3",12,"DB","-","X","F8","F81",3,2,"NB",1,5,"2016-07-01","XZ202",373,null,null,null,null,2]
["2016-09-28T08:01:53","B.H6.1-V3.12.AB.-.X.D6.D60","2016-09-28T08:01:53","X","RU","B","Z","H6",null,null,1,1,"1-V3",12,"AB","-","X","D6","D60",3,2,"NB",1,5,"2016-07-01","XZ202",375,null,null,null,null,2]
["2016-09-28T08:01:53","A.H9.1-V3.12.AB.-.X..","2016-09-28T08:01:53","X","RU","A","U","H9",null,null,1,1,"1-V3",12,"AB","-","X",null,null,3,14,"NB",1,5,"2016-07-01","XZ202",376,null,null,null,null,14]
["2016-09-28T08:01:53","A.V33.1-V3.12.AB.-.X..","2016-09-28T08:01:53","X","RU","A","Y","V33",null,null,1,1,"1-V3",12,"AB","-","X",null,null,3,4,"NB",1,6,null,null,null,null,18,null,null,4]
["2016-09-28T08:01:53","A.D12.1-V3.12.AB.-.-.Z0.Z00","2016-09-28T08:01:53","X","RU","A","Y","D12",null,null,1,1,"1-V3",12,"AB","-","-","Z0","Z00",3,6,"NB",1,5,"2016-07-01","XZ202",378,null,null,null,null,6]