{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["FACTURA","BASE","PRODUCTOS","CLIENTES"],"not_rendered":{"images":1,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"FACTURA","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[0,0,0,5],[1,2,1,4],[3,1,3,2],[5,0,5,1],[5,2,5,5],[6,0,6,1],[6,2,6,5],[12,9,14,12],[20,0,20,2]]}
["NOMBRE DEL NEGOCIO"]
[null,null,"Direccion y Nº Identificacion Fiscal"]
[{"$nulls":9},{"$f":"IF(J2<>\"\",VLOOKUP(J2,Clientes,2,0),\"\")","v":""}]
["FECHA:",{"$f":"TODAY()","v":"2018-01-04"},null,null,"FAC. Nº:",null,{"$f":"MAX(BASE!B2:B150)+1","v":1}]
[]
["CLIENTE:",null,"Paula Hodgson Perez"]
["DIRECCION:",null,{"$f":"IF(C6<>\"\",VLOOKUP(C6,Clientes,2,0),\"\")","v":"Bº Santo Domingo Contigua A la escuela primaria"},{"$nulls":6},{"$f":"IF(J6<>\"\",VLOOKUP(J6,Clientes,2,0),\"\")","v":""}]
[]
["CANT.","COD.PROD","PRODUCTO","DESCRIPCION","P/U","TOTAL"]
[null,null,{"$f":"IF($B10<>\"\",VLOOKUP($B10,CATALOGO,2,0),\"\")","v":""},{"$f":"IF($B10<>\"\",VLOOKUP($B10,CATALOGO,3,0),\"\")","v":""},{"$f":"IF($B10<>\"\",VLOOKUP($B10,CATALOGO,4,0),\"\")","v":""},{"$f":"IF(A10>0,A10*E10,\"\")","v":""}]
[null,null,"","","",{"$f":"IF(A11>0,A11*E11,\"\")","v":""}]
[null,null,"","","",""]
[null,null,"","","","",{"$nulls":3},"Descarga tu Plantilla de Cuentas por Cobrar\nClic aquí →"]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[{"$nulls":4},"SUBTOTALES",{"$f":"SUM(F10:F17)","v":0}]
[{"$nulls":4},"IVA 12 %",{"$f":"F18*12%","v":0}]
["       ________________________________",{"$nulls":3},"TOTAL A PAG",{"$f":"F18+F19","v":0}]
["Firma del Vendedor"]

{"sheet":"BASE","index":1,"n_rows":23,"n_cols":10,"rows_kept":23}
["FECHA","Nº.FACT","CLIENTE","CANT","COD.PROD","PRODUCTO","DESCRIPCION","PRECIO UNIT","PRECIO TOTAL","IVA"]
[{"$nulls":9},{"$f":"H2*12","v":0}]
[{"$nulls":9},{"$f":"H3*12","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]

{"sheet":"PRODUCTOS","index":2,"n_rows":6,"n_cols":5,"rows_kept":6}
["COD.PROD","PRODUCTO","DESCRIPCION","PRECIO UNIT","PROVEEDOR"]
[1001,"Arroz","80/20",{"v":45,"d":"$45.00"}]
[1002,"Azucar","Caña",{"v":48,"d":"$48.00"}]
[1003,"Aceite","Ambar",{"v":30,"d":"$30.00"}]
[1004,"Harina","Star",{"v":20,"d":"$20.00"}]
[1005,"Frijoles","Rojo",{"v":25,"d":"$25.00"}]

{"sheet":"CLIENTES","index":3,"n_rows":3,"n_cols":3,"rows_kept":3}
["CLIENTE","DIRECCIÓN","CIUDAD"]
["Paula Hodgson Perez","Bº Santo Domingo Contigua A la escuela primaria","Bilwis"]
["Roger Perez Bello","Bº Las Colinas,Frente al instituto Colon","Bilwis"]