{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["BUSCAR","cat 2023"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"BUSCAR","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+\"\"&D3","v":"45026"},{"$f":"+IF(ISERROR(D1),E1,D1)","v":1},{"$f":"D1","v":1},{"$f":"MATCH(A1,Cata_2023_truper[código],0)","v":1},{"$f":"MATCH(A1,Cata_2023_truper[descripción],0)","v":{"$error":"#N/A"}}]
[]
[null,null,"BUSCAR\nx Código",45026]
[]
[null,null,null,"código"]
[{"$f":"MATCH(D5,Cata_2023_truper[#Headers],0)","v":1},null,null,{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A6),\"***SIN RESULTADOS***\")","v":"45026"}]
[{"$f":"MATCH(C8,Cata_2023_truper[#Headers],0)","v":2}]
[{"$f":"MATCH(C9,Cata_2023_truper[#Headers],0)","v":3},null,"clave",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A7),\"\")","v":"CLE-5B"},"Codigo SAT",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A16),\"\")","v":31162000}]
[{"$f":"MATCH(C11,Cata_2023_truper[#Headers],0)","v":10},null,"descripción",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A8),\"\")","v":"Bolsa con 1 kg de clavo estándar 5' con cabeza, Fiero"},"Descripcion SAT",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A17),\"\")","v":"Clavos"}]
[]
[{"$f":"MATCH(D11,Cata_2023_truper[#Headers],0)","v":9},null,"precio distribuidor","precio mayoreo","Precio Medio Mayoreo","precio público"]
[{"$f":"MATCH(E11,Cata_2023_truper[#Headers],0)","v":12},null,{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A9),\"\")","v":28},{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A11),\"\")","v":33},{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A12),\"\")","v":37},{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A13),\"\")","v":40}]
[{"$f":"MATCH(F11,Cata_2023_truper[#Headers],0)","v":11}]
[{"$f":"MATCH(C16,Cata_2023_truper[#Headers],0)","v":13},null,"PROMOTRUPER",{"$f":"+IFERROR(IF(INDEX(Cata_2023_truper[#Data],$C$1,$A26)=0,\"\",INDEX(Cata_2023_truper[#Data],$C$1,$A26)),\"\")","v":"Enero 2024"}]
[{"$f":"MATCH(C17,Cata_2023_truper[#Headers],0)","v":6}]
[{"$f":"MATCH(E8,Cata_2023_truper[#Headers],0)","v":14},null,"Marca",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A14),\"\")","v":"Fiero"},"Familia",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A18),\"\")","v":"P519"}]
[{"$f":"MATCH(E9,Cata_2023_truper[#Headers],0)","v":15},null,"unidad",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A15),\"\")","v":"kg"},"Descripción Familia",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A19),\"\")","v":"Clavos para madera"}]
[{"$f":"MATCH(E16,Cata_2023_truper[#Headers],0)","v":16}]
[{"$f":"MATCH(E17,Cata_2023_truper[#Headers],0)","v":17},null,"alta rotación",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A20),\"\")","v":1},"ean",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A23),\"\")","v":"7506240610229"}]
[{"$f":"MATCH(C19,Cata_2023_truper[#Headers],0)","v":8},null,"caja",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A21),\"\")","v":10},"Peso[Kg]",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A24),\"\")","v":0.96}]
[{"$f":"MATCH(C20,Cata_2023_truper[#Headers],0)","v":4},null,"master",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A22),\"\")","v":20},"Volumen[cm3]",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A25),\"\")","v":987.52599999999995}]
[{"$f":"MATCH(C21,Cata_2023_truper[#Headers],0)","v":5},null,"Código Barras",{"$f":"+IFERROR(INDEX(Cata_2023_truper[#Data],$C$1,$A23),\"\")","v":"7506240610229"}]
[{"$f":"MATCH(C22,Cata_2023_truper[#Headers],0)","v":20}]
[{"$f":"MATCH(E20,Cata_2023_truper[#Headers],0)","v":18}]
[{"$f":"MATCH(E21,Cata_2023_truper[#Headers],0)","v":19}]
[{"$f":"MATCH(C14,Cata_2023_truper[#Headers],0)","v":21}]
[{"$f":"MATCH(E19,Cata_2023_truper[#Headers],0)","v":7}]

{"sheet":"cat 2023","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["código","clave","descripción","caja","master","unidad","ean","alta rotación","precio mayoreo","precio distribuidor","precio público","Precio Medio Mayoreo","Marca","Codigo SAT","Descripcion SAT","Familia","Descripción Familia","Peso[Kg]","Volumen[cm3]","Código Barras","PROMOTRUPER"]
["45026","CLE-5B","Bolsa con 1 kg de clavo estándar 5' con cabeza, Fiero",10,20,"kg","7506240610229",1,33,28,40,37,"Fiero",31162000,"Clavos","P519","Clavos para madera",0.96,987.52599999999995,"7506240610229","Enero 2024"]
["44458","ALRE-151","Kilo de alambre recocido calibre 15 en rollo de 1Kg, Fiero",10,0,"kg","7506240638438",1,33,30,39,36,"Fiero",30264401,"Alambre de acero al carbón serie sae 1100 enrollada en caliente","P625","Alambre recocido",1.01,1040.5999999999999,"7506240638438","Diciembre 2023"]
["46063","CAB-10V","Rollo de 100 m de cable THHW-LS 10 AWG verde, Volteck",1,4,"Caja","7501206678534",1,1485,1349,1795,1625,"Volteck",26121600,"Cables eléctricos y accesorios","P727","Cables conductores",6.16,7943.83,"7501206678534","Noviembre 2023"]
["40124","CAB-14R-500","Metro de cable THHW-LS 14 AWG rojo en carrete de 500 m",500,0,"Metro","7506240657163",0,6.75,6.19,8.25,7.45,"Volteck",26121600,"Cables eléctricos y accesorios","P727","Cables conductores",2.9000000000000001E-2,27.75,"7506240657163","Noviembre 2023"]
["44847","CLCG-2-1/2N","Kilo de clavo para concreto 2-1/2' negro, caja de 25 kg",25,0,"kg","7506240613794",0,65,54,79,72,"Fiero",31162000,"Clavos","P040","Clavos para concreto",1.016,490.464,"7506240613794","Octubre 2023"]
["40085","PVC-105","Tubo de 3 m de PVC de 1-1/2' hidráulico RD 26, Foset",5,0,"Pieza","7506240669081",0,79,67,95,89,"Foset",24141700,"Tubos y núcleos de embalaje y etiquetas y accesorios","P681","Tubos y conexiones PVC",1.0920000000000001,8112,"7506240669081","Septiembre 2023"]
["45043","CPVC-002","Tubo de 3/4' de CPVC hidráulico RD 13.5 de 3 m, Foset",10,0,"Pieza","7506240646570",1,62,56,75,69,"Foset",40172609,"Acoples de tubos de plástico cpvc","P685","Tubos de CPVC",0.55400000000000005,1452,"7506240646570","Agosto 2023"]
["40081","PVC-101","Tubo de 3 m de PVC de 1/2' hidráulico RD 21, Foset",5,0,"Pieza","7506240669043",0,22,18,26,24,"Foset",24141700,"Tubos y núcleos de embalaje y etiquetas y accesorios","P681","Tubos y conexiones PVC",0.26800000000000002,1728,"7506240669043","Julio 2023"]
["44497","CLS-2","Bolsa con 1 kg de clavo estándar 2' sin cabeza, Fiero",10,0,"kg","7506240603016",0,56,47,69,62,"Fiero",31162000,"Clavos","P519","Clavos para madera",1,593.39,"7506240603016","Junio 2023"]
["14366","SOL-60/40","Soldadura con núcleo resina 60/40, para electrónica, 450 g",2,12,"Pieza","7501206622759",1,569,475,685,625,"Truper",30263201,"Alambre de estaño","P292","Soldaduras",0.46,326.37,"7501206622759","Marzo 2023"]
["45121","ALG-145B","Rollo de 30 g de alambre galvanizado calibre 14.5, en bolsa",20,240,"Pieza","7506240648895",0,4,3,5,4.5,"Fiero",26121540,"Cable galvanizado","P552","Alambre galvanizado",0.04,147.63999999999999,"7506240648895","Enero 2023"]
["11753","CAT-15ND","Carretilla 5 ft3 Neumática, bastidor tubular, Truper",1,0,"Pieza","7501206611210",1,1305,1190,1585,1435,"Truper",24101507,"Carretillas","P432","Carretillas nacionales y Latam",16.760000000000002,70357.558999999994,"7501206611210","Diciembre 2022"]
["13472","WT-550","Aceite multiusos en aerosol, 550ml (19oz), Truper",6,48,"Pieza","7506240653318",0,84,65,102,92,"Truper",15121500,"Preparados lubricantes","P482","Lubricantes, aceites y grasas",0.52,1235.9880000000001,"7506240653318"]
["19683","WEC-14","Cortador de maleza con mango de 30', Truper",3,0,"Pieza","7501206627907",0,199,155,245,219,"Truper",27112000,"Herramientas manuales de jardinería, agricultura y forestación","P739","Azadones de zanco",1.153,8447.8220000000001,"7501206627907"]