{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INVENTAIRE TOTAL","Sommaire","Zone Process & ligne 4","Zone APV L1","Vortex et Pamoma","Zone Cermex L1","Zone APV L2","Zone Vortex L2","Zone Cermex L2","Zone SKA L1&L2"],"not_rendered":{"charts":0,"images":2,"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":"INVENTAIRE TOTAL","index":0,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,5,3,9],[2,5,2,7],[2,8,2,9],[1,1,2,4],[1,5,1,7],[1,8,1,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCE","EA","KG","RL","M²"]
[null,"INVENTAIRE TOTAL DU : ",null,null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,null,"2017-04-25",null,null,"21/30",null,null,null,null,null,"               COMMENT FAIRE ?"]
[null,"Réf","TOTAL","UNITE","Designation","Quantité",null,null,null,null,null,null,null,1,"METTRE  LA DATE ET L'HEURE DE L'INVENTAIRE"]
[null,"11 EURO",{"$f":"IF(B5<>\"\",SUM(F5:J5),\"\")","v":0},"EA","Palette EURO",null,null,null,null,null,null,null,null,2,"SAISIR LA REFERENCE "]
[null,"13 CHEP",0,"EA","Palette CHEP",null,null,null,null,null,null,null,null,3,"SAISIR LES QUANTITES DANS LA LIGNE CORRESPONDANT  "]
[null,1106715,0,"EA","SCOTCH PETIT ROULEAU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"saisir les quantités dans "]
[null,1106716,0,"EA","MIMA FILMS filmage semi-auto ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dans la ligne correspondant"]
[null,1106719,0,"EA","ROULEAUX DE FILM 1000"]
[null,1106724,0,"EA","SCOTCH GRAND  ROULEAU"]
[null,1165027,0,"KG","COLLE SUPRA"]
[null,1291519,0,"KG","Colle ADVENTRA SP"]
[null,1359010,0,"EA","INTERCALAIRE EURO"]
[null,1359011,0,"EA","INTERCALAIRE CHEP"]
[null,1336528,0,"RL","FW MARS "]
[null,null,"","",""]
[null,null,"","","",null,null,null,null,null,null,null,null,4,"APRES AVOIR SAISI TOUTES LES DONNÉES, SELECTIONER LE TABLEAU (DE LA 1ère A LA DERNIERE DONNÉE)"]
[null,null,"","","",null,null,null,null,null,null,null,null,5,"APRES LA SELECTION, CLIQUER SUR L'ICONE DE FILTRAGE EN HAUT A DROITE DE LA FENETRE ET"]
[null,null,"","","",null,null,null,null,null,null,null,null,null,"SELECTIONNER DE A A Z                "]
[null,null,"","","",null,null,null,null,null,null,null,null,6,"LA LISTE EST PRETE A ETRE FACILEMENT SAISIE DANS SAP"]
[null,null,"","","",null,null,null,null,null,null,null,null,7,"SELECTIONER ET IMPRIMER  POUR L'EQUIPE SUIVENTE"]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]

{"sheet":"Sommaire","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Infos dans les cases blanches"]
[]
[null,"je voudrais avoir une macro qui fasse les impression des feuilles qui son dans la liste (colonne B) suivant si la colonne D est renseigner par un suigne ou caractére"]
[]
[null,null,"Sommaire"]
[]
[null,"ZONE","Feuille d'inventaire","Impression "]
[null,"Process & Ligne4",null,"X"]
[null,"Apv1",null,"x"]
[null,"vortex1",null,"x"]
[null,"CERMEX1",null,"x"]
[null,"Apv2",null,"x"]
[null,"vortex2",null,"x"]
[null,"CERMEX2",null,"x"]
[null,"SKA",null,"x"]
[]
[]
[null,"voici la liste des zone d'impression de chaque feuille"]
[null,"zone","zone d'impression"]
[null,"Zone Process & ligne 4","A1:I14 "]
[null,"Zone APV L1","A1:I10"]
[null,"Vortex et Pamoma","A1:I10"]
[null,"Zone Cermex L1","A1:I10"]
[null,"Zone APV L2","A1:I10"]
[null,"Zone Vortex L2","A1:I10"]
[null,"Zone Cermex L2","A1:I17"]
[null,"Zone SKA L1&L2","A1:I17"]

{"sheet":"Zone Process & ligne 4","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE Process & Ligne 4",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]

{"sheet":"Zone APV L1","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE APV Ligne 1",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Vortex et Pamoma","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,4,3,8],[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE  Vortex L1 & Paloma ",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf",null,"Designation","Quantité"]
[null,1165027,null,"COLLE SUPRA",null,null,null,null,"KG"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]

{"sheet":"Zone Cermex L1","index":5,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE Cermex L1",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,1165027,null,"COLLE SUPRA",null,null,null,null,"KG"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]

{"sheet":"Zone APV L2","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE APV Ligne 2",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]

{"sheet":"Zone Vortex L2","index":7,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE Vortex L2",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,1291519,null,"Colle ADVENTRA SP",null,null,null,null,"KG"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]

{"sheet":"Zone Cermex L2","index":8,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE Cermex L2",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation",null,null,"Quantité"]
[null,1165027,null,"COLLE SUPRA",null,null,null,null,"KG"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]

{"sheet":"Zone SKA L1&L2","index":9,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,4,3,8],[1,1,2,3],[1,4,1,6],[1,7,1,8],[2,4,2,6],[2,7,2,8]]}
[]
[null,"   INVENTAIRE  EMBALLAGE SKA L1+L2",null,null,"DATE",null,null,"HEURE"]
[null,null,null,null,"2017-04-25",null,null,"21/30"]
[null,"Réf","UNITE","Designation","Quantité"]
[null,1291519,null,"Colle ADVENTRA SP",null,null,null,null,"KG"]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]
[null,null,null,"",null,null,null,null,""]