{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BOM","PDS021 Composants"],"not_rendered":{"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"BOM","index":0,"n_rows":62,"n_cols":68,"rows_kept":62}
[]
[{"$nulls":7},"Date  de MAJ",43068,{"$nulls":5},"PDT FINI",3,{"$nulls":8},"Responsable article",null,"SALPETIER",{"$nulls":6},"Modèle",{"$nulls":29},"MDPX"]
[{"$nulls":24},"Groupe article",null,1010,{"$nulls":6},"Taille",{"$nulls":29},1,null,2]
[{"$nulls":7},"TP Factor",1.574,{"$nulls":15},"Groupe produit",null,1515,{"$nulls":6},"Classe",{"$nulls":29},"CL III","CL III","CL III"]
[{"$nulls":7},"Taux horaire",39.3608,{"$nulls":24},"Code Movex produit"]
[{"$nulls":8},"Données Movex (MMS001 / 002 / 003 / CRS230)",{"$nulls":24},"Volume annuel",null,"Description pièce primaire",{"$nulls":12},"Decomposition prix pièce primaire",{"$nulls":5},"Formules de calcul pièce primaire"]
[null,null,"Niveau","N° SEQ",{"$nulls":3},"Numéro EPDM","Code Movex / Poste de charge","nouveau / existant","Nom ","Désignation ","N°SEQ","N° OPE","PDC3","TPS EN CH\nEXECUTION","N°SEQ2","N°OPE","PDC2","TPS EN CH\nEXECUTION2","N°SEQ3","N°OPE2","PDC5","TPS EN CH\nEXECUTION22","Modèle de création MMS","U/M de base","Poids brut","Poids net","Modèle","Matricule O/N","Type/volume","Série économique","Type de pièce","VCOGS unitaire","Qté / an","Série Economique proposée","Forcer série Economique ","Type Tôle","Epaisseur mm","Dimention X (mm)","Dimention Y (mm)","Laser","Nb trous","Nb plis","Nb goujons","peinture","Interdire cisaillage","VCOGS pièce primaire","VCOGS  Tôle","VCOGS cisaillage","VCOGS découpe (poinçonage ou laser) ","VCOGS Pliage","VCOGS goujons","VCOGS peinture","surface de la tôle (m²)","Surface de la pièce (m²)","Nb Pièces possible dans tole 11115015 ","Nb Pièces possible dans tole cisaillée","Série économique2","Cisaillage nécessaire","Taux peinture ?","Simulation de coût découpe laser CVP","Simulation de coût poinçonnage CVP","Modèle A 1 CL I","Modèle A 1 CL II","Modèle A 2 CL I"]
[null,null,"1.1.1",{"$nulls":4},"SW00221039",1,"Nouveau code","DESSOUS INT CAISSE MDPX","DESSOUS INT CAISSE MDPX",null,100,22380,99,{"$nulls":8},"MODEL01F",{"$nulls":8},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,2,3]
[null,null,"1.1.2",{"$nulls":4},"SW00221017",2,"Nouveau code","DESSUS INT CAISSE MDPX","DESSUS INT CAISSE MDPX",null,100,22380,99,{"$nulls":17},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1,null,{"$f":"COLUMN()","v":68}]
[null,null,"1.1.3",{"$nulls":4},"SW00221185",3,"Nouveau code","MANCHON INT CAISSE MDPX","MANCHON INT CAISSE MDPX",null,100,22220,99,null,110,22630,0.4,{"$nulls":13},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.4",{"$nulls":4},"SW00223544",4,"Nouveau code","LONGERON EXT INTER CADRES MDPX","LONGERON EXT INTER CADRES MDPX",null,100,22220,99,null,110,22630,0.4,{"$nulls":13},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.5",{"$nulls":4},"SW00221082",5,"Nouveau code","LONGERON INT INTER CADRES MDPX","LONGERON INT INTER CADRES MDPX",null,100,22220,99,null,110,22630,0.4,{"$nulls":13},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.7",{"$nulls":4},"SW00221404",6,"Nouveau code","CADRE EXT ASS PG MDPX","CADRE EXT ASS PG MDPX",null,200,28200,46,null,298,22998,0,{"$nulls":13},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,null,2]
[null,null,"1.1.7.1",200,{"$nulls":3},"SW00221405",7,"Nouveau code","MONTANT GAUCHE CADRE PG MDPX","MONTANT GAUCHE CADRE PG MDPX",null,100,22380,99,null,110,22630,2.4,{"$nulls":4},"MODEL01F",{"$nulls":8},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,null,2]
[null,null,"1.1",{"$nulls":4},"SW00221257","85755 . . .","Code existant","CAISSE ASS PIVOTS DG MDPX","CAISSE ASS PIVOTS DG MDPX",{"$nulls":12},"MODEL01F",{"$nulls":8},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1]
[null,null,"1.1",{"$nulls":4},"SW00223533","85755 . . .","Code existant","CAISSE ASS PIVOTS DD MDPX","CAISSE ASS PIVOTS DD MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,null,1]
[null,null,"1.1",{"$nulls":4},"SW00223531","85755 . . .","Code existant","CAISSE ASS PIVOTS GG MDPX","CAISSE ASS PIVOTS GG MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,null,null,1]
[null,null,"1.1.6",{"$nulls":4},"SW00099500",82418010,"Code existant","CADRE EXT ASS P D M.D.P","CADRE EXT ASS P D M.D.P",{"$nulls":21},32.357,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,2]
[null,null,"1.1.7.2",205,{"$nulls":4},82456022,null,"MONTANT GAUCHE CADRE PD M.D.P","MONTANT GAUCHE CADRE PD M.D.P",{"$nulls":21},4.65,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,"Modèle A 1 CL II","Modèle A 2 CL I"]
[null,null,"1.1.7.3",210,200,{"$nulls":3},82454008,null,"TRAVERSE BASSE CADRE M.D.P","TRAVERSE BASSE CADRE M.D.P",{"$nulls":21},4.478,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1.65505226480836,1.61764705882353]
[null,null,"1.1.7.4",215,200,{"$nulls":3},82854007,null,"TRAVERSE HAUTE CADRE 40à160","TRAVERSE HAUTE CADRE 40à160",{"$nulls":21},3.698,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1.72822299651568,1.67647058823529]
[null,null,"1.1.7.5",220,200,{"$nulls":3},82966021,null,"CRAPAUDINE G CARENA 40-160","CRAPAUDINE G CARENA 40-160",{"$nulls":21},3.799,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,1.801393728223,1.73529411764706]
[null,null,"1.1.7.6",225,200,{"$nulls":3},26502039,null,"PILIER FIX CALE K+/-","PILIER FIX CALE K+/-",{"$nulls":21},0.313,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,1.87456445993031,1.79411764705882]
[null,null,"1.1.7.7",230,200,{"$nulls":3},62878005,null,"ANNEAU LEVAGE CARENA","ANNEAU LEVAGE CARENA",{"$nulls":21},0.073,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,1.94773519163763,1.85294117647059]
[null,null,"1.1.7.8",235,200,{"$nulls":3},62865013,null,"PILIER FIXATION POUR 3MM","PILIER FIXATION POUR 3MM",{"$nulls":21},0.095,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,6,null,12]
[null,null,"1.1.7.9",240,200,{"$nulls":3},"FICT3359",null,"APPRET GRIS HYDRO","APPRET GRIS HYDRO",{"$nulls":21},1.818,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.02,null,0.04]
[null,null,"1.1.7.10",null,200,28200,null,"/","/",null,"Temps assemble cadre","Temps assemble cadre",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.23,null,0.46]
[null,null,"1.1.8",{"$nulls":4},"SW00100955",62865013,null,"PILIER FIXATION POUR 3MM","PILIER FIXATION POUR 3MM",{"$nulls":21},0.095,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,2,2]
[null,null,"1.1.9",{"$nulls":4},"SW00223793",62865014,null,"PILIER LEVAGE MDPX","PILIER LEVAGE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,2,2]
[null,null,"1.1.10",{"$nulls":5},46000005,null,"PAPIER MASQUAGE","PAPIER MASQUAGE",{"$nulls":21},4.244,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.012,0.012,0.012]
[null,null,"1.1.11",{"$nulls":5},46000031,null,"TOILE ADHESIVE ADVANCE AT170","TOILE ADHESIVE ADVANCE AT170",{"$nulls":21},7.15,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.112,0.112,0.112]
[null,null,"1.1.12",{"$nulls":5},62899163,null,"MOUSSE ACRYLIQUE ADHESIVE15X10","MOUSSE ACRYLIQUE ADHESIVE15X10",{"$nulls":21},0.394,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,4,4,4]
[null,null,"1.1.13",{"$nulls":5},46000023,null,"RUBSON ACRYLIC A1","RUBSON ACRYLIC A1",{"$nulls":21},2.462,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.3,0.3,0.3]
[null,null,"1.1.14",{"$nulls":4},"/","/",null,"Soudure caisse int","Soudure caisse int",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.5,0.5,0.5]
[null,null,"1.1.15",{"$nulls":4},"SW00223503",8,null,"RENFORT DESSOUS INT MDPX","RENFORT DESSOUS INT MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.16",{"$nulls":4},"SW00223501",8,null,"RENFORT DESSUS INT MDPX","RENFORT DESSUS INT MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.17",{"$nulls":4},"SW00223499",8,null,"RENFORT MANCHON INT MDPX","RENFORT MANCHON INT MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.18",{"$nulls":4},"SW00223504",8,null,"RENFORT LONGERON INT MDPX","RENFORT LONGERON INT MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.19",{"$nulls":4},"SW00223506",8,null,"TREILLI MANCHON CAISSE MDPX","TREILLI MANCHON CAISSE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.20",{"$nulls":4},"SW00223518",8,null,"TREILLI DESSUS/OUS CAISSE MDPX","TREILLI DESSUS/OUS CAISSE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,2,2,2]
[null,null,"1.1.21",{"$nulls":4},"SW00100972",62874009,null,"PROTECTION 70X250X3","PROTECTION 70X250X3",{"$nulls":21},2.638,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,16,16,16]
[null,null,"1.1.22",{"$nulls":4},"SW00180536",82874486,null,"PROTECTION DESSOUS cl I II","PROTECTION DESSOUS cl I II",{"$nulls":21},2.626,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,4,4,4]
[null,null,"1.1.23",{"$nulls":4},"/","/",null,"Soudure renfort","Soudure renfort",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.5,0.5,0.5]
[null,null,"1.1.24",{"$nulls":4},"SW00101076",62885001,null,"TUBE SCELLEMENT CAISSE CARENA","TUBE SCELLEMENT CAISSE CARENA",{"$nulls":21},0.176,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,6,6,6]
[null,null,"1.1.25",{"$nulls":4},"SW00126984",26502039,null,"PILIER FIX CALE K+/-","PILIER FIX CALE K+/-",{"$nulls":21},0.313,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.26",{"$nulls":4},"SW00101079",62885020,null,"TUBE ALARME CAISSE CARENA","TUBE ALARME CAISSE CARENA",{"$nulls":21},0.188,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.27",{"$nulls":4},"SW00220845","-",null,"DESSOUS EXT CAISSE MDPX","DESSOUS EXT CAISSE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.28",{"$nulls":4},"SW00220860","-",null,"MANCHON EXT CAISSE MDPX","MANCHON EXT CAISSE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.29",{"$nulls":4},"/","/",null,"Soudure caisse ext","Soudure caisse ext",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.3,0.3,0.3]
[null,null,"1.1.30",{"$nulls":4},"/","/",null,"coffrage caisse","coffrage caisse",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.3,0.3,0.3]
[null,null,"1.1.31",{"$nulls":5},"FICT2616",null,"LITRE MORTIER EPSILON MUF","LITRE MORTIER EPSILON MUF",{"$nulls":21},0.427,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,60,60,60]
[null,null,"1.1.32",{"$nulls":4},"/","/",null,"Betonage caisse","Betonage caisse",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.3,0.3,0.3]
[null,null,"1.1.33",{"$nulls":4},"SW00220850","-",null,"DESSUS EXT CAISSE MDPX","DESSUS EXT CAISSE MDPX",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,1,1]
[null,null,"1.1.34",{"$nulls":4},"SW00217045",28877033,null,"GOUJON CDS Ø5X18 FIL COUCHE","GOUJON CDS Ø5X18 FIL COUCHE",{"$nulls":21},0.023,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,26,26,26]
[null,null,"1.1.35",{"$nulls":4},"/","/",null,"Pose Dessus","Pose Dessus",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.05,0.05,0.05]
[null,null,"1.1.36",{"$nulls":4},"/","/",null,"Decoffrage","Decoffrage",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.15,0.15,0.15]
[null,null,"1.1.37",{"$nulls":4},"SW00126880",21901003,null,"CALE BOIS POUR COFFRE","CALE BOIS POUR COFFRE",{"$nulls":21},1.899,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,4,4,4]
[null,null,"1.1.38",{"$nulls":4},"SW00150269",28818160,null,"ROND MU 08","ROND MU 08",{"$nulls":21},0.007,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,4,4,4]
[null,null,"1.1.39",{"$nulls":4},"SW00150526",28828405,null,"VIS H,M8-100,6.8,ZINGUEE","VIS H,M8-100,6.8,ZINGUEE",{"$nulls":21},0.277,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,4,4,4]
[null,null,"1.1.40",{"$nulls":4},"/","/",null,"Pose cale bois","Pose cale bois",{"$nulls":21},{"$error":"#N/A"},0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,0.15,0.15,0.15]
[null,"Porte","1.2",{"$nulls":4},"SW00099600",82480178,null,"PORTE BET P D CL III M.D.P","PORTE BET P D CL III M.D.P",{"$nulls":21},122.137,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,2]
[null,null,"1.3",{"$nulls":4},"SW00099604",82480186,null,"PORTE BET P G CL III M.D.P","PORTE BET P G CL III M.D.P",{"$nulls":21},153.222,0,0,0,null,"",{"$nulls":8},0,0,0,0,0,0,0,0,0,0,0,0,false,0.5,0,0,1,null,2]

{"sheet":"PDS021 Composants","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"merged":[[1,1,1,8]]}
["A","B","C","D","E","F","G","H","I"]
[null,"PDS021 Opérations"]
[null,"Doit exister dans MOVEX ou dans le fichier de création ","Ordre dans lequel les composants doivent apparaitre dans la structure","Doit exister dans le fichier opérations ","Doit exister dans MOVEX ou dans le fichier de création ","Coefficient d'assemblage. Toujours positif","Préciser 1 si le composant est à réintégrer (lien négatif)","Par défaut 00000000","Par défaut 99999999"]
[null,"Article Produit","séquence","n° opération","composant","quantité","Code SS/Co Prod","date debut","date fin"]