{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inventaire","Liste de sélection d’inventaire","Recherche de bac"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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","index":0,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,"INVENTAIRE"]
[null,"VALEUR TOTALE INVENTAIRE","ARTICLES D’INVENTAIRE :",null,null,"NOMBRE PARE-BRISE :",null,"NOMBRE DE JOINT :"]
[null,{"$f":"SUM(InventoryTable[VALEUR INVENTAIRE])","v":65.5},{"$f":"COUNTA(InventoryTable[MODELE])","v":2},null,null,{"$f":"COUNTIF(C2:C200,\"PB\")","v":1},null,{"$f":"COUNTIF(C6:C200,\"JT\")","v":1}]
[]
[null,"Référence","PIECE","MARQUE","MODELE","N° RAC","EMPLACEMENT","QTÉ","QTÉ RÉAPPROVISIONNEMENT","COÛT","VALEUR INVENTAIRE","RÉAPPROVISIONNER","N°Cmd"]
[null,"5426ACL1C","PB","BENZ","W 901 - 903",125,null,1,0,60,{"$f":"InventoryTable[[#This Row],[QTÉ]]*InventoryTable[[#This Row],[COÛT]]","v":60},null,{"$f":"IF(InventoryTable[[#This Row],[QTÉ]]<InventoryTable[[#This Row],[QTÉ RÉAPPROVISIONNEMENT]],1,0)","v":0}]
[null,"5426ASMV","JT","BENZ","W 901 - 903",125,null,1,0,5.5,{"$f":"InventoryTable[[#This Row],[QTÉ]]*InventoryTable[[#This Row],[COÛT]]","v":5.5},null,{"$f":"IF(InventoryTable[[#This Row],[QTÉ]]<InventoryTable[[#This Row],[QTÉ RÉAPPROVISIONNEMENT]],1,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[N° RAC]],TableRechercheBac[],3,FALSE),\"\")","v":""}]

{"sheet":"Liste de sélection d’inventaire","index":1,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"SUIVI DE COMMANDES"]
[]
[null,"N° Cmd","Immat.","Modèle","Eurocode","Pièce","Fourn.","Par","Date","Heure","Prix","Port","Téléphone","Compte","Franco","Reçu","Facturé"]
[null,"2001-11-01","43DF50","BENZ","5426ACL1C","PB",null,"TEL","2016-11-02","9H00",60,null,null,null,null,"OK"]
[]
[]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(InventoryPickList[Immat.],InventoryTable[],4,FALSE),\"\")","v":""}]

{"sheet":"Recherche de bac","index":2,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[null,"RECHERCHE BAC"]
[]
[null,"CE TABLEAU FOURNIT DES DONNÉES À LA FOIS POUR LES FEUILLES DE LISTE D’INVENTAIRE ET DE LISTE DE SÉLECTION D’INVENTAIRE."]
[null,"N° BAC","DESCRIPTION","EMPLACEMENT","LARGEUR","HAUTEUR","LONGUEUR"]