{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["MENU","F.COMPRA","F.VENTA","DEV. SVENTA","DEV. SCOMPRA","BASE","K","E","P","PRODUCTOS","CLIENTES","PROVEEDORES","RESUMEN","COSTO C."],"not_rendered":{"images":12,"macros":1,"defined_names":39},"read":"whole","date_system":"1900"}

{"sheet":"MENU","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[0,2,0,4],[0,5,0,7],[0,8,0,10],[0,11,0,13],[16,3,16,5],[17,9,17,11],[18,3,18,5]]}
[null,null,"FACTURACION",null,null,"REPORTES",null,null,"PRESENTAR",null,null,"CONFIGURACIONES"]
{"$rows_empty":15}
[{"$nulls":3},"ULTIMO Nº FACT. VTA PER. ANTERIOR"]
[{"$nulls":9},"ABONO"]
[{"$nulls":3},"DIGITE EL CODIGO DEL PRODUCTO",null,null,1001]
[]
[{"$nulls":3},"SELECCIONE EL NOMBRE DEL CLIENTE",null,null,"CARLOS PEREZ ESTRELLA"]
[]
[{"$nulls":3},"SELECCIONE EL NOMBRE DEL PROVEEDOR",null,null,"SEVASA S.A."]

{"sheet":"F.COMPRA","index":1,"n_rows":31,"n_cols":24,"rows_kept":31,"merged":[[0,0,0,5],[2,0,2,5],[4,1,4,3],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5]]}
["NOMBRE DEL NEGOCIO",{"$nulls":21},"ALCONTADO",0]
[{"$nulls":22},"ALCREDITO",1]
["FACTURA DE COMPRAS"]
[{"$nulls":4},"ESTADO:",null,{"$f":"IF(F4<>\"\",VLOOKUP(F4,ESTBASE,2,0),\"\")","v":""}]
["FECHA:",{"$f":"TODAY()","v":"2013-07-09"},null,null,"COD. CONT:",{"$f":"IF(G4<>0,VLOOKUP(C7,Proveedor,2,0),2000)","v":{"$error":"#N/A"}}]
[{"$nulls":4},"Nº FACT:"]
["PROVEEDOR:"]
["DIRECCION:",null,{"$f":"IF(C7<>\"\",VLOOKUP(C7,Proveedor,3,0),\"\")","v":""}]
["CANT.","CODIGO","PRODUCTO","DESCRIPCION","COSTO","C. TOTAL"]
[null,null,{"$f":"IF(B10<>\"\",VLOOKUP(B10,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"A10*E10","v":0}]
[null,null,"",null,null,{"$f":"A11*E11","v":0}]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[{"$nulls":4},"SUBTOTALES",{"$f":"SUM(F10:F27)","v":0}]
[{"$nulls":4},"IVA"]
[{"$nulls":4},"DESCUENTO"]
[{"$nulls":4},"TOTAL",{"$f":"F28+F29-F30","v":0}]

{"sheet":"F.VENTA","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[0,0,0,5],[2,0,2,5],[4,1,4,3],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[31,0,31,2]]}
["NOMBRE DEL NEGOCIO"]
[]
["FACTURA DE VENTAS"]
[{"$nulls":4},"ESTADO:",null,{"$f":"IF(F4<>\"\",VLOOKUP(F4,ESTBASE,2,0),\"\")","v":""}]
["FECHA:",{"$f":"TODAY()","v":"2013-07-09"},null,null,"COD. CONT:",{"$f":"IF(G4<>0,VLOOKUP(C7,CLIENTES,2,0),1000)","v":{"$error":"#N/A"}}]
[{"$nulls":4},"Nº FACT:",null,{"$f":"MAX(BASE!D3:D200)+1","v":1}]
["CLIENTE:"]
["DIRECCION:",null,{"$f":"IF(C7<>\"\",VLOOKUP(C7,CLIENTES,3,0),\"\")","v":""}]
["CANT.","CODIGO","PRODUCTO","DESCRIPCION","PRECIO","P. TOTAL"]
[null,null,{"$f":"IF(B10<>\"\",VLOOKUP(B10,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(A10>0,A10*E10,\"\")","v":""}]
[null,null,"",null,null,{"$f":"IF(A11>0,A11*E11,\"\")","v":""}]
[null,null,"",null,{"$f":"IF(B12<>\"\",VLOOKUP(B12,CATALOGO,5,0),\"\")","v":""},{"$f":"IF(A12>0,A12*E12,\"\")","v":""}]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[null,null,"",null,"",""]
[{"$nulls":4},"SUBTOTALES",{"$f":"SUM(F10:F27)","v":0}]
[{"$nulls":4},"IVA",{"$f":"F28*0.15","v":0}]
[{"$nulls":4},"DESCUENTO"]
[{"$nulls":4},"TOTAL",{"$f":"F28+F29-F30","v":0}]
["VENTIDO POR"]

{"sheet":"DEV. SVENTA","index":3,"n_rows":32,"n_cols":24,"rows_kept":32,"merged":[[0,0,0,5],[2,0,2,5],[4,1,4,3],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[31,0,31,2]]}
["NOMBRE DEL NEGOCIO",{"$nulls":21},"ALCONTADO",0]
[{"$nulls":22},"ALCREDITO",1]
["DEVOLUCION SOBRE VENTA"]
[{"$nulls":4},"ESTADO:",null,{"$f":"IF(F4<>\"\",VLOOKUP(F4,ESTBASE,2,0),\"\")","v":""}]
["FECHA:",{"$f":"TODAY()","v":"2013-07-09"},null,null,"COD. CONT:",{"$f":"IF(G4<>0,VLOOKUP(C7,CLIENTES,2,0),1000)","v":{"$error":"#N/A"}}]
[{"$nulls":4},"Nº FACT:"]
["CLIENTE:"]
["DIRECCION:",null,{"$f":"IF(C7<>\"\",VLOOKUP(C7,CLIENTES,3,0),\"\")","v":""}]
["CANT.","CODIGO","PRODUCTO","DESCRIPCION","PRECIO","C. TOTAL"]
[null,null,{"$f":"IF(B10<>\"\",VLOOKUP(B10,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"A10*E10","v":0}]
[null,null,"",null,null,{"$f":"A11*E11","v":0}]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[null,null,"",null,null,0]
[{"$nulls":4},"SUBTOTALES",{"$f":"SUM(F10:F27)","v":0}]
[{"$nulls":4},"IVA"]
[{"$nulls":4},"DESCUENTO"]
[{"$nulls":4},"TOTAL",{"$f":"F28+F29-F30","v":0}]
["VENDIDO POR"]

{"sheet":"DEV. SCOMPRA","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[0,0,0,5],[2,0,2,5],[4,1,4,3],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[31,0,31,2]]}
["NOMBRE DEL NEGOCIO"]
[]
["DEVOLUCION SOBRE COMPRAS"]
[{"$nulls":4},"ESTADO:",null,{"$f":"IF(F4<>\"\",VLOOKUP(F4,ESTBASE,2,0),\"\")","v":""}]
["FECHA:",{"$f":"TODAY()","v":"2013-07-09"},null,null,"COD. CONT:",{"$f":"IF(G4<>0,VLOOKUP(C7,Proveedor,2,0),2000)","v":2111001}]
[{"$nulls":4},"Nº FACT:"]
["PROVEEDOR:",null,"COMERCIAL STAR S. A."]
["DIRECCION:",null,{"$f":"IF(C7<>\"\",VLOOKUP(C7,Proveedor,3,0),\"\")","v":"BIL, Bº PETER FERRERA"}]
["CANT.","CODIGO","PRODUCTO","DESCRIPCION","PRECIO","P. TOTAL"]
[null,null,{"$f":"IF(B10<>\"\",VLOOKUP(B10,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(A10>0,A10*E10,\"\")","v":""}]
[null,null,"",null,null,{"$f":"IF(A11>0,A11*E11,\"\")","v":""}]
[null,null,"",null,null,{"$f":"IF(A12>0,A12*E12,\"\")","v":""}]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[null,null,"",null,null,""]
[{"$nulls":4},"SUBTOTALES",{"$f":"SUM(F10:F27)","v":0}]
[{"$nulls":4},"IVA"]
[{"$nulls":4},"DESCUENTO"]
[{"$nulls":4},"TOTAL",{"$f":"F28+F29-F30","v":0}]

{"sheet":"BASE","index":5,"n_rows":200,"n_cols":21,"rows_kept":200,"merged":[[0,0,1,0],[0,1,0,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,12,0,13],[0,14,0,16],[0,17,1,17]]}
["FECHA","Nº DE FACTURA",null,"CLIENTES","PROVEEDORES","ESTADO","COD. CONT.","CODIGO","PRODUCTO","DESCRIPCION","PREC -COSTO","COSTO\n REAL","CANTIDADES",null,"VALORES",null,null,"ABONO",null,null,{"$f":"MENU!G17","v":0}]
[null,"COMPRA","VENTA",{"$nulls":9},"ENTRADA","SALIDA","DEBE","HABER","COSTO TOTAL"]
[0,0,{"$f":"U1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF(H4<>\"\",VLOOKUP(H4,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H4<>\"\",VLOOKUP(H4,CATALOGO,4,0),0)","v":0},null,null,{"$f":"M4*K4","v":0},{"$f":"N4*K4","v":0},{"$f":"N4*L4","v":0}]
[{"$nulls":8},"",null,null,0,null,null,{"$f":"M5*K5","v":0},{"$f":"N5*K5","v":0},{"$f":"N5*L5","v":0}]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H36<>\"\",VLOOKUP(H36,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H36<>\"\",VLOOKUP(H36,CATALOGO,4,0),0)","v":0},null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H68<>\"\",VLOOKUP(H68,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H68<>\"\",VLOOKUP(H68,CATALOGO,4,0),0)","v":0},null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,{"$f":"M69*K69","v":0},{"$f":"N69*K69","v":0},{"$f":"N69*L69","v":0}]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H100<>\"\",VLOOKUP(H100,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H100<>\"\",VLOOKUP(H100,CATALOGO,4,0),0)","v":0},null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H132<>\"\",VLOOKUP(H132,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H132<>\"\",VLOOKUP(H132,CATALOGO,4,0),0)","v":0},null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,{"$f":"M133*K133","v":0},{"$f":"N133*K133","v":0},{"$f":"N133*L133","v":0}]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H164<>\"\",VLOOKUP(H164,CATALOGO,2,0),\"\")","v":""},null,null,{"$f":"IF(H164<>\"\",VLOOKUP(H164,CATALOGO,4,0),0)","v":0},null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},"",null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H196<>\"\",VLOOKUP(H196,CATALOGO,2,0),\"\")","v":""},null,null,0,null,null,0,0,0]
[{"$nulls":8},{"$f":"IF(H197<>\"\",VLOOKUP(H197,CATALOGO,2,0),\"\")","v":""},null,null,0,null,null,{"$f":"M197*K197","v":0},{"$f":"N197*K197","v":0},{"$f":"N197*L197","v":0}]
[{"$nulls":8},{"$f":"IF(H198<>\"\",VLOOKUP(H198,CATALOGO,2,0),\"\")","v":""},null,null,0,null,null,{"$f":"M198*K198","v":0},{"$f":"N198*K198","v":0},{"$f":"N198*L198","v":0}]
[{"$nulls":8},{"$f":"IF(H199<>\"\",VLOOKUP(H199,CATALOGO,2,0),\"\")","v":""},null,null,0,null,null,{"$f":"M199*K199","v":0},{"$f":"N199*K199","v":0},{"$f":"N199*L199","v":0}]
[{"$nulls":8},{"$f":"IF(H200<>\"\",VLOOKUP(H200,CATALOGO,2,0),\"\")","v":""},null,null,0,null,null,{"$f":"M200*K200","v":0},{"$f":"N200*K200","v":0},{"$f":"N200*L200","v":0}]

{"sheet":"K","index":6,"n_rows":199,"n_cols":10,"rows_kept":199,"merged":[[0,0,0,9],[3,0,4,0],[3,1,3,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,3,9]]}
["MOVIMIENTO DE INVENTARIOS"]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[{"$nulls":4},{"$f":"IF(MENU!G19<>\"\",VLOOKUP(MENU!G19,CATALOGO,1,0))","v":1001},null,null,{"$f":"IF(MENU!G19<>\"\",VLOOKUP(MENU!G19,CATALOGO,2,0))","v":"ARROZ"}]
["FECHA","Nº DE FACTURA",null,"CODIGO","PRODUCTO","DESCRIPCION","PREC-\nCOST","CANTIDADES"]
[null,"COMPRA","VENTA",{"$nulls":4},"ENTRADA","SALIDA","SALDOS"]
[{"$nulls":9},{"$f":"H6-I6","v":0}]
[{"$nulls":9},{"$f":"IF((H7-I7)<>0,(H7-I7+J6),\"\")","v":""}]
[{"$nulls":9},{"$f":"IF((H8-I8)<>0,(H8-I8+J7),\"\")","v":""}]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},{"$f":"IF((H72-I72)<>0,(H72-I72+J71),\"\")","v":""}]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},{"$f":"IF((H136-I136)<>0,(H136-I136+J135),\"\")","v":""}]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]
[{"$nulls":9},""]

{"sheet":"E","index":7,"n_rows":199,"n_cols":8,"rows_kept":199,"merged":[[0,0,0,7],[2,5,2,7],[3,0,4,0],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,7]]}
["ESTADO DE CUENTA CLIENTES"]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[{"$nulls":4},{"$f":"IF(MENU!G21<>\"\",VLOOKUP(MENU!G21,CLIENTES,2,0))","v":1112001},{"$f":"IF(MENU!G21<>\"\",VLOOKUP(MENU!G21,CLIENTES,1,0))","v":"CARLOS PEREZ ESTRELLA"}]
["FECHA","Nº DE FACT.","CLIENTES","COD. \nCONT.","DESCRIPCION","VALORES"]
[null,"VENTA",{"$nulls":3},"DEBE","HABER","SALDO"]
[{"$nulls":7},{"$f":"F6-G6","v":0}]
[{"$nulls":7},{"$f":"IF((F7-G7)<>0,(F7-G7+H6),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF((F8-G8)<>0,(F8-G8+H7),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF((F72-G72)<>0,(F72-G72+H71),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF((F136-G136)<>0,(F136-G136+H135),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]

{"sheet":"P","index":8,"n_rows":199,"n_cols":8,"rows_kept":199,"merged":[[0,0,0,7],[2,5,2,7],[3,0,4,0],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,7]]}
["ESTADO DE CUENTA X PAGAR"]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[{"$nulls":4},{"$f":"IF(MENU!G23<>\"\",VLOOKUP(MENU!G23,Proveedor,2,0))","v":2111001},{"$f":"IF(MENU!G23<>\"\",VLOOKUP(MENU!G23,Proveedor,1,0))","v":"SEVASA S.A."}]
["FECHA","Nº DE FACT.","PROVEEDOR","COD. \nCONT.","DESCRIPCION","VALORES"]
[null,"COMPRA",{"$nulls":3},"DEBE","HABER","SALDO"]
[{"$nulls":7},{"$f":"G6-F6","v":0}]
[{"$nulls":7},{"$f":"IF((G7-F7)<>0,(G7-F7+H6),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF((G8-F8)<>0,(G8-F8+H7),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF((G72-F72)<>0,(G72-F72+H71),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF((G136-F136)<>0,(G136-F136+H135),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]

{"sheet":"PRODUCTOS","index":9,"n_rows":17,"n_cols":5,"rows_kept":17,"merged":[[0,0,0,4],[2,0,2,4]]}
[{"$f":"F.COMPRA!A1","v":"NOMBRE DEL NEGOCIO"}]
[]
["CATALOGO DE PRODUCTOS"]
[]
["COD. PROD.","NOMBRE DE ARTICULO","DESCRIPCION","COSTO R/U","PRECIO/U"]
[]
[0,"ANULADO"]
[1000,"GRANOS BASICOS"]
[1001,"ARROZ",null,{"$f":"'COSTO C.'!L7","v":0},{"$f":"'COSTO C.'!M7","v":0}]
[1002,"AZUCAR",null,{"$f":"'COSTO C.'!L8","v":0},{"$f":"'COSTO C.'!M8","v":0}]
[1003,"FRIJOLES",null,{"$f":"'COSTO C.'!L9","v":0},{"$f":"'COSTO C.'!M9","v":0}]
[1004,"HARINA",null,{"$f":"'COSTO C.'!L10","v":0},{"$f":"'COSTO C.'!M10","v":0}]
[2000,"COSMETICOS"]
[2001,"PERFUMES",null,{"$f":"'COSTO C.'!L11","v":0},{"$f":"'COSTO C.'!M11","v":0}]
[2002,"PINTURA DE UÑA",null,{"$f":"'COSTO C.'!L12","v":0},{"$f":"'COSTO C.'!M12","v":0}]
[2003,"PINTURAS DE LABIO",null,{"$f":"'COSTO C.'!L13","v":0},{"$f":"'COSTO C.'!M13","v":0}]
[2004,"LAPIZ DECEJAS",null,{"$f":"'COSTO C.'!L14","v":0},{"$f":"'COSTO C.'!M14","v":0}]

{"sheet":"CLIENTES","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,0,6],[4,4,4,6],[13,2,13,3]]}
["LISTA DE CLIENTES Y CONTROL DE CUENTAS POR COBRAR"]
[]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[]
[{"$nulls":4},"RESUMEN CUENTAS X COBRAR"]
["NOMBRE DEL CLIENTE","ID CONTABLE","DIRECCION","TELEFONO","DEBE","HABER","SALDO"]
["CARLOS PEREZ ESTRELLA",1112001,"Bº LOMA VERDE",88405102]
["JUAN BLANDON CASTILLO",1112001,"Bº SANTA INES",84091378]
["NADIEZDHA MARTINEZ",1121003,"Bº LOS ANGELES",27922456]
[]
[]
[]
[]
[null,null,"SUMA TOTAL CUENTAS X C",null,{"$f":"SUM(E7:E13)","v":0},{"$f":"SUM(F7:F13)","v":0},{"$f":"SUM(G7:G13)","v":0}]

{"sheet":"PROVEEDORES","index":11,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,0,6],[4,4,4,6],[13,2,13,3]]}
["LISTA DE PROVEEDORES Y CONTROL DE CUENTAS POR PAGAR"]
[]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[]
[{"$nulls":4},"RESUMEN CUENTAS X PAGAR"]
["NOMBRE DEL PROVEEDOR","ID CONTABLE","DIRECCION","TELEFONO","DEBE","HABER","SALDO"]
["COMERCIAL STAR S. A.",2111001,"BIL, Bº PETER FERRERA",27922406]
["DISTRIBUIDORA LACTEOS S.A.",2111002,"BILWI Bº SANDINO",27922507]
["SEVASA S.A.",2111001,"MANAGUA",27922506]
[]
[]
[]
[]
[null,null,"SUMA TOTAL CUENTAS X P",null,{"$f":"SUM(E7:E13)","v":0},{"$f":"SUM(F7:F13)","v":0},{"$f":"SUM(G7:G13)","v":0}]

{"sheet":"RESUMEN","index":12,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[0,0,0,7],[2,0,2,7],[6,2,6,4],[6,5,6,7],[28,2,28,4]]}
["NOMBRE DEL NEGOCIO"]
[]
["RESUMEN DE INVENTARIO MINIMO Y MAXIMO MAS UTILIDAD BRUTA DEL EJERCICIO"]
[]
["DEL",{"$f":"BASE!A4","v":"00:00:00"},"AL",{"$f":"TODAY()","v":"2013-07-09"}]
[]
[null,null,"RESUMEN DE KARDEX",null,null,"UTILIDAD BRUTA/V"]
["CODIGO","PRODUCTO","ENTRADA","SALIDA","SALDOS","VENTAS","COSTOS","UTILIDAD"]
[{"$f":"PRODUCTOS!A8","v":1000},{"$f":"PRODUCTOS!B8","v":"GRANOS BASICOS"}]
[{"$f":"PRODUCTOS!A9","v":1001},{"$f":"PRODUCTOS!B9","v":"ARROZ"}]
[{"$f":"PRODUCTOS!A10","v":1002},{"$f":"PRODUCTOS!B10","v":"AZUCAR"}]
[{"$f":"PRODUCTOS!A11","v":1003},{"$f":"PRODUCTOS!B11","v":"FRIJOLES"}]
[{"$f":"PRODUCTOS!A12","v":1004},{"$f":"PRODUCTOS!B12","v":"HARINA"}]
[{"$f":"PRODUCTOS!A13","v":2000},{"$f":"PRODUCTOS!B13","v":"COSMETICOS"}]
[{"$f":"PRODUCTOS!A14","v":2001},{"$f":"PRODUCTOS!B14","v":"PERFUMES"}]
[{"$f":"PRODUCTOS!A15","v":2002},{"$f":"PRODUCTOS!B15","v":"PINTURA DE UÑA"}]
[{"$f":"PRODUCTOS!A16","v":2003},{"$f":"PRODUCTOS!B16","v":"PINTURAS DE LABIO"}]
[{"$f":"PRODUCTOS!A17","v":2004},{"$f":"PRODUCTOS!B17","v":"LAPIZ DECEJAS"}]
{"$rows_empty":10}
[null,null,"SUMA TOTAL",null,null,{"$f":"SUM(F9:F28)","v":0},{"$f":"SUM(G9:G28)","v":0},{"$f":"SUM(H9:H28)","v":0}]

{"sheet":"COSTO C.","index":13,"n_rows":23,"n_cols":17,"rows_kept":23,"merged":[[0,0,0,12],[0,14,0,16],[2,0,2,12],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,14,5,14],[4,15,5,15],[4,16,5,16]]}
["TABLA DE CALCULO DEL COSTO COMERCIAL Y EL PRECIO DE VENTA",{"$nulls":13},"CALCULO DEL FACTOR EQUIVALENTE"]
[]
["APLICA EL COSTO COMERCIAL METODO DE COSTO POR RECARGOS Y EL METODO DEL FACTOR EQUIVALENTE"]
[]
["Nº","CANTIDAD","ARTICULO","COSTO/U","FACTURA\n TOTAL","REBAJA",null,"FACTURA \nNETO TOTAL","TRANSPORTE","FACT. EQUIV.","COSTO TOTAL","COSTO C./U","PRECIO \nVENTA 60%",null,"DETALLES","%","IMPORTE"]
[{"$nulls":5},"%","IMPORTE"]
[{"$nulls":4},{"$f":"B7*D7","v":0},null,{"$f":"E7*F7%","v":0},{"$f":"E7-G7","v":0},null,{"$f":"$Q$15","v":0},{"$f":"IF(J7>0,E7*J7,H7+I7)","v":0},{"$f":"IF(B7>0,K7/B7,0)","v":0},{"$f":"IF(L7>0,L7*0.6+L7,0)","v":0},null,"TOTAL FACT. S/D",null,{"$f":"IF(SUM(E7:E23)=SUM(H7:H23),SUM(E7:E23),0)","v":0}]
[{"$nulls":4},{"$f":"B8*D8","v":0},null,{"$f":"E8*F8%","v":0},{"$f":"E8-G8","v":0},null,{"$f":"$Q$15","v":0},{"$f":"IF(J8>0,E8*J8,H8+I8)","v":0},{"$f":"IF(B8>0,K8/B8,0)","v":0},{"$f":"IF(L8>0,L8*0.6+L8,0)","v":0},null,"DESCUENTO",null,{"$f":"IF($Q$7>0,$Q$7*P8%,0)","v":0}]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"REBAJA",null,{"$f":"IF($Q$7>0,$Q$7*P9%,0)","v":0}]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"EMBALAJE"]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"FLETE"]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"RECARGOS"]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"FACT. TOTAL",null,{"$f":"Q7-SUM(Q8:Q9)+SUM(Q10:Q12)","v":0}]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0,null,"FACTOR EQUIV.",null,{"$f":"IF(Q7>0,Q13/Q7,0)","v":0}]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]
[{"$nulls":4},0,null,0,0,null,0,0,0,0]