{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["BUSCAR","cat 2025"],"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":"44658"},{"$f":"+IF(ISERROR(D1),E1,D1)","v":3},{"$f":"D1","v":3},{"$f":"MATCH(A1,Tabla_productos_truper_db_2025[código],0)","v":3},{"$f":"MATCH(A1,Tabla_productos_truper_db_2025[descripción],0)","v":{"$error":"#N/A"}}]
[]
[null,null,"BUSCAR\nx Código","44658"]
[]
[null,null,null,"código"]
[{"$f":"MATCH(D5,Tabla_productos_truper_db_2025[#Headers],0)","v":1},null,null,{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A6),\"***SIN RESULTADOS***\")","v":"44658"}]
[{"$f":"MATCH(C8,Tabla_productos_truper_db_2025[#Headers],0)","v":2}]
[{"$f":"MATCH(C9,Tabla_productos_truper_db_2025[#Headers],0)","v":3},null,"clave",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A7),\"\")","v":"MAHE-2515"},"Codigo SAT",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A16),\"\")","v":31163400}]
[{"$f":"MATCH(C11,Tabla_productos_truper_db_2025[#Headers],0)","v":10},null,"descripción",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A8),\"\")","v":"Rollo malla hexagonal cal.22, 1.5x 45m, abertura 25mm, 20kg"},"Descripcion SAT",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A17),\"\")","v":"Redes de metal y estructuras de cribado"}]
[]
[{"$f":"MATCH(D11,Tabla_productos_truper_db_2025[#Headers],0)","v":9},null,"precio distribuidor","precio mayoreo","Precio Medio Mayoreo","precio público"]
[{"$f":"MATCH(E11,Tabla_productos_truper_db_2025[#Headers],0)","v":12},null,{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A9),\"\")","v":1225},{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A11),\"\")","v":1350},{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A12),\"\")","v":1485},{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A13),\"\")","v":1635}]
[{"$f":"MATCH(F11,Tabla_productos_truper_db_2025[#Headers],0)","v":11}]
[{"$f":"MATCH(C16,Tabla_productos_truper_db_2025[#Headers],0)","v":13},null,"PROMOTRUPER",{"$f":"+IFERROR(IF(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A26)=0,\"\",INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A26)),\"\")","v":""}]
[{"$f":"MATCH(C17,Tabla_productos_truper_db_2025[#Headers],0)","v":6}]
[{"$f":"MATCH(E8,Tabla_productos_truper_db_2025[#Headers],0)","v":14},null,"Marca",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A14),\"\")","v":"Fiero"},"Familia",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A18),\"\")","v":"P873"}]
[{"$f":"MATCH(E9,Tabla_productos_truper_db_2025[#Headers],0)","v":15},null,"unidad",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A15),\"\")","v":"Rollo"},"Descripción Familia",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A19),\"\")","v":"Mallas hexagonales"}]
[{"$f":"MATCH(E16,Tabla_productos_truper_db_2025[#Headers],0)","v":16}]
[{"$f":"MATCH(E17,Tabla_productos_truper_db_2025[#Headers],0)","v":17},null,"alta rotación",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A20),\"\")","v":1},"ean",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A23),\"\")","v":"7506240606109"}]
[{"$f":"MATCH(C19,Tabla_productos_truper_db_2025[#Headers],0)","v":8},null,"caja",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A21),\"\")","v":1},"Peso[Kg]",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A24),\"\")","v":22.29}]
[{"$f":"MATCH(C20,Tabla_productos_truper_db_2025[#Headers],0)","v":4},null,"master",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A22),\"\")","v":0},"Volumen[cm3]",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A25),\"\")","v":93750}]
[{"$f":"MATCH(C21,Tabla_productos_truper_db_2025[#Headers],0)","v":5},null,"Código Barras",{"$f":"+IFERROR(INDEX(Tabla_productos_truper_db_2025[#Data],$C$1,$A23),\"\")","v":"7506240606109"}]
[{"$f":"MATCH(C22,Tabla_productos_truper_db_2025[#Headers],0)","v":20}]
[{"$f":"MATCH(E20,Tabla_productos_truper_db_2025[#Headers],0)","v":18}]
[{"$f":"MATCH(E21,Tabla_productos_truper_db_2025[#Headers],0)","v":19}]
[{"$f":"MATCH(C14,Tabla_productos_truper_db_2025[#Headers],0)","v":23}]
[{"$f":"MATCH(E19,Tabla_productos_truper_db_2025[#Headers],0)","v":7}]

{"sheet":"cat 2025","index":1,"n_rows":10,"n_cols":23,"rows_kept":10,"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","IVA","margen_mercado","PROMOTRUPER"]
["44656","MAHE-2510","Rollo malla hexagonal cal.22, 1x 45m, abertura 25mm, 13kg",1,0,"Rollo","7506240606086",1,925,845,1125,1025,"Fiero",31163400,"Redes de metal y estructuras de cribado","P873","Mallas hexagonales",13.76,59328,"7506240606086","16","MM00"]
["44657","MAHE-2512","Rollo malla hexagonal cal.22, 1.2x 45m, abertura 25mm, 16kg",1,0,"Rollo","7506240606093",1,1135,1035,1375,1250,"Fiero",31163400,"Redes de metal y estructuras de cribado","P873","Mallas hexagonales",16.46,75000,"7506240606093","16","MM00"]
["44658","MAHE-2515","Rollo malla hexagonal cal.22, 1.5x 45m, abertura 25mm, 20kg",1,0,"Rollo","7506240606109",1,1350,1225,1635,1485,"Fiero",31163400,"Redes de metal y estructuras de cribado","P873","Mallas hexagonales",22.29,93750,"7506240606109","16","MM00"]
["44659","MAHE-2517","Rollo malla hexagonal cal.22, 1.75x 45m, abertura 25mm, 23kg",1,0,"Rollo","7506240606116",1,1550,1415,1885,1715,"Fiero",31163400,"Redes de metal y estructuras de cribado","P873","Mallas hexagonales",23.28,119652,"7506240606116","16","MM00"]
["42859","MAGA-50X10","Rollo malla borreguera, 1m x 50m acero galvanizado, 23kg",1,0,"Rollo","7506240624226",1,1085,985,1315,1195,"Fiero",31163400,"Redes de metal y estructuras de cribado","P871","Mallas borregueras",21.98,66975.75,"7506240624226","16","MM0"]
["42860","MAGA-50X12","Rollo malla borreguera, 1.2m x 50m acero galvanizado, 26kg",1,0,"Rollo","7506240624233",1,1235,1125,1495,1365,"Fiero",31163400,"Redes de metal y estructuras de cribado","P871","Mallas borregueras",25.675000000000001,75000,"7506240624233","16","MM0"]
["42861","MAGA-50X14","Rollo malla borreguera, 1.4m x 50m acero galvanizado, 28kg",1,0,"Rollo","7506240624240",1,1395,1265,1685,1535,"Fiero",31163400,"Redes de metal y estructuras de cribado","P871","Mallas borregueras",29,77962.5,"7506240624240","16","MM0"]
["42862","MAGA-50X16","Rollo malla borreguera, 1.67m x 50m acero galvanizado, 31kg",1,0,"Rollo","7506240624257",1,1535,1395,1855,1685,"Fiero",31163400,"Redes de metal y estructuras de cribado","P871","Mallas borregueras",31.195,96192,"7506240624257","16","MM0"]
["44885","ALPU12-30","Rollo de alambre de púas 300m calibre 12.5, FIERO",1,0,"Rollo","7506240626107",1,1065,965,1285,1165,"Fiero",31152002,"Alambre de púas","P602","Alambre de púas y concertinas",30.54,27452.102999999999,"7506240626107","16","MM1"]