{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Menu","Transacción","Base Datos","Control Inv","Indices","Consultas"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Transacción","index":1,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,2,3]]}
[]
[null,"TRANSACCIÓN DE PRODUCTOS",null,null,null,null,null,null,null,1]
[]
[null,"Fecha:",null,"Consecutivo:"]
[]
[null,"Transacción:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Archivo Plano"]
[]
[null,"Código","Descripción Producto","Referencia","Und/Med.","Cantidad",null,"Saldo/Act.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha","Conse","Transacción","Código","Descripción","Referencia ","Und/Med","Cantidad"]
[]
[]
[null,null,null,null,null,null,null,null,null,10065]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total de unidades"]

{"sheet":"Base Datos","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"BASE DE DATOS MOVIMIENTOS"]
[]
[null,"Fecha","Conse","Transacción","Codigo","Descripción","Referencia ","Und/Med","Cantidad","ID","E","S"]
[null,"2023-05-11",1,"ENTRADA",485,"Acople Pista 14-11mm","FX036","Unidad",800]
[null,"2023-05-11",1,"ENTRADA",784,"Pasador FP 343",343,"Unidad",400]
[null,"2023-05-11",1,"ENTRADA",957,"Tornilo Central 5/16\" X 3 1/2\"","Galvanizado","Unidad",1000]
[null,"2023-05-12",1,"SALIDA",957,"Tornilo Central 5/16\" X 3 1/2\"","Galvanizado","Unidad",7500]
[null,"2023-05-12",1,"SALIDA",942,"Pegante sintetico","Acrilico","Litros",50]
[null,"2023-05-12",2,"ENTRADA",942,"Pegante sintetico","Acrilico","Litros",200]
[null,"2023-05-12",2,"SALIDA",123,"Arandela 1 1/2\" SUP",1035,"Unidad",280]
[null,"2023-05-12",3,"ENTRADA",957,"Tornilo Central 5/16\" X 3 1/2\"","Galvanizado","Unidad",500]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]
[null,"00:00:00",0,0,0,0,0,0,0]

{"sheet":"Control Inv","index":3,"n_rows":1003,"n_cols":11,"rows_kept":1003,"cut":false,"hidden":false,"merged":[[2,1,3,2],[3,7,3,9],[3,3,3,5]]}
[]
[]
[null,"CONTROL Y ADMINISTRACION DE INVENTARIO"]
[null,null,null,null,null,null,null,"Movimiento"]
[null,"Codigo","Descripción","Referencia","Und/Med","Prom/dia","Saldo Ini","Entradas","Salidas","Saldo Und","Saldo Dias"]
[null,123,"Arandela 1 1/2\" SUP",1035,"Unidad",120,1280]
[null,485,"Acople Pista 14-11mm","FX036","Unidad",85,5200]
[null,784,"Pasador FP 343",343,"Unidad",280,600]
[null,605,"Soldadura 1/4","MTE1035","Kilos",15,230]
[null,942,"Pegante sintetico","Acrilico","Litros",1.5,85]
[null,957,"Tornilo Central 5/16\" X 3 1/2\"","Galvanizado","Unidad",1780,25000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,92]
[null,null,{"$f":"INDEX(C6:C1000,C1002)","v":0}]

{"sheet":"Indices","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[]
[null,"INDICES DE CONTROL"]
[]
[null,null,"Rango Días",null,null,"Ref.",null,"% Partic."]
[null,"Cantidad de referencias agotadas",0,"<="]
[]
[null,"Cantidad de referencias estado critico",1,5]
[]
[null,"Cantidad de referencias inventario optimo",6,30]
[]
[null,"Cantidad de referencias exceso de inventario",31,">="]
[]
[null,"Total de referencias en inventario"]

{"sheet":"Consultas","index":5,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":true,"merged":[[39,1,39,2],[40,1,40,2],[39,3,39,5],[40,3,40,5],[1,1,1,4],[5,3,5,4],[6,1,6,4],[3,2,3,4],[26,2,26,4],[37,2,37,4]]}
[]
[null,"Consulta de información"]
[]
[null,null,"Consulta de Cartera Clientes"]
[]
[null,"Salida:","S001",{"$f":"IF(C6<>0,(INDEX(#REF!,MATCH($C$6,#REF!,0),1)),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(C6<>0,(INDEX(#REF!,MATCH($C$6,#REF!,0),3)),\"\")","v":{"$error":"#REF!"}}]
[]
[null,"Codigo","Producto","Marca","Talla","Cantidad","$$  Und.","$$  Total","Abonos","Saldo"]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,null,null,0]
[null,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H24)","v":0},{"$f":"SUM(I10:I24)","v":0},{"$f":"SUM(J10:J24)","v":0}]
[]
[null,null,"Consulta de Productos en Inventario"]
[]
[null,"Codigo","Producto","Marca","Talla","$ Costo","$ Venta","% Utili."]
[null,{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),1))","v":{"$error":"#N/A"}},null,{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),3))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),4))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),5))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),6))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),7))","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Saldo Inicial","Entradas","Salidas","Saldo Act."]
[null,null,"Movimiento en Unidades",{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),8))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),9))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),10))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),11))","v":{"$error":"#N/A"}}]
[null,null,"Movimiento en $ Costos",null,{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),12))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),13))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),14))","v":{"$error":"#N/A"}}]
[null,null,"Movimiento en $ Venta",null,{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),15))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),16))","v":{"$error":"#N/A"}},{"$f":"(INDEX('Control Inv'!$B$6:$J$1000,MATCH('Control Inv'!$C$1003,'Control Inv'!$C$6:$C$1000,0),16))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"Consulta Financiera por Periodo"]
[]
[null,"Ingrese fecha Inicial del Periodo a Consultar",null,"2007-12-01"]
[null,"  Ingrese fecha Final del Periodo a Consultar",null,"2007-12-31"]
[]
[null,null,"Valor de Venta de la Mercancia",{"$f":"SUMIF(#REF!,\"=1\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,"Costo Compra de la Mercancia",{"$f":"SUMIF('Base Datos'!#REF!,\"=1\",'Base Datos'!#REF!)","v":{"$error":"#REF!"}}]
[null,null,"Utilidad Neta Teorica",{"$f":"(D43-D44)","v":{"$error":"#REF!"}}]
[]
[null,null,"Recaudos del Periodo",{"$f":"SUMIF(#REF!,\"=1\",#REF!)","v":{"$error":"#REF!"}},{"$f":"D47/D43","v":{"$error":"#REF!"}}]