{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["F","BV","C","P","O","Hoja1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":9,"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":"F","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,4,6,5],[28,1,28,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"TODAY()","v":"2020-10-11"}]
[null,{"$f":"IF(ISERROR(VLOOKUP(B9,L_Clientes,1,0)),\"\",VLOOKUP(B9,L_Clientes,3,0))","v":""}]
[null,{"$f":"IF(ISERROR(VLOOKUP(B9,L_Clientes,1,0)),\"\",VLOOKUP(B9,L_Clientes,2,0))","v":""}]
[]
[]
[{"$f":"IF(ISERROR(VLOOKUP(B14,L_Productos,1,0)),\"\",VLOOKUP(B14,L_Productos,2,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(B14,L_Productos,1,0)),0,VLOOKUP(B14,L_Productos,3,0))","v":0},null,null,{"$f":"IF(E14>0,(C14-D14)*E14,0)","v":0}]
["",null,{"$f":"IF(ISERROR(VLOOKUP(B15,L_Productos,1,0)),0,VLOOKUP(B15,L_Productos,3,0))","v":0},null,null,{"$f":"IF(E15>0,(C15-D15)*E15,0)","v":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,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,{"$f":"IF(AND(F31>0,F11=\"Dólares\"),Num_Textod(F31),IF(AND(F31>0,F11=\"Soles\"),Num_Texto(F31),\"\"))","v":""},null,null,null,{"$f":"SUM(F14:F28)","v":0}]
[null,null,null,null,null,{"$f":"F29*0.18","v":0}]
[null,null,null,null,null,{"$f":"SUM(F29:F30)","v":0}]

{"sheet":"BV","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,4,6,5],[28,1,28,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"TODAY()","v":"2020-10-11"}]
[null,{"$f":"IF(ISERROR(VLOOKUP(B9,L_Clientes,1,0)),\"\",VLOOKUP(B9,L_Clientes,3,0))","v":""}]
[null,{"$f":"IF(ISERROR(VLOOKUP(B9,L_Clientes,1,0)),\"\",VLOOKUP(B9,L_Clientes,2,0))","v":""}]
[]
[]
[{"$f":"IF(ISERROR(VLOOKUP(B14,L_Productos,1,0)),\"\",VLOOKUP(B14,L_Productos,2,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(B14,L_Productos,1,0)),0,VLOOKUP(B14,L_Productos,4,0))","v":0},null,null,{"$f":"IF(E14>0,(C14-D14)*E14,0)","v":0}]
["",null,0,null,null,{"$f":"IF(E15>0,(C15-D15)*E15,0)","v":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,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,{"$f":"IF(AND(F29>0,F11=\"Dólares\"),Num_Textod(F29),IF(AND(F29>0,F11=\"Soles\"),Num_Texto(F29),\"\"))","v":""},null,null,null,{"$f":"SUM(F14:F28)","v":0}]

{"sheet":"C","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["LISTADO DE CLIENTES"]
[]
["NOMBRE O RAZÓN SOCIAL","R.U.C. o D.N.I.","DIRECCIÓN"]
["Varios","-------------------","------------------------------------------------------"]
["A",20507363009,"Av. Los Castillos 504 Z.I. San Francisco Ate - Lima - Lima"]
["B",20113087758,"Cal. El Martillo Mz B Lt 5 Urb Naranjal Los Olivos - Lima - Lima"]
["C",20516790327,"Av. General Garzón 1283 Int 609 Jesús María - Lima - Lima"]
["D",20101017789,"Mlc. García Rybeyro 288 Rímac - Lima - Lima"]
["E",20100157315,"Jr. Gonzales Prada 420 Surquillo - Lima - Lima"]
["F",10100398597,"Cal. Los Pinos 245 Sunampe - Chincha - Ica"]
["G",20138100015,"Av. Republica de Panamá 6355 Urb. San Antonio Miraflores-Lima-Lima"]

{"sheet":"P","index":3,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["LISTADO DE PRODUCTOS"]
[]
[]
["DESCRIPCIÓN","CÓDIGO","V. VENTA","P. VENTA"]
["mill. bls. Pead 16\"x25.5\"x0.5",1,15.4,{"$f":"C5*1.18","v":18.172000000000001}]
["mill. bls. Pead 20\"x28\"x0.5",2,21.35,{"$f":"C6*1.18","v":25.193000000000001}]
["mill. bls. Pead 26\"x46.5\"x0.5",3,225.8,{"$f":"C7*1.18","v":266.44400000000002}]
["mill. bls. Pebd trans 10\"x12\"x5mc","2bdt10125p",165.8,{"$f":"C8*1.18","v":195.64400000000001}]
["pqt. x 100 bls. Pebd trans 10\"x12\"x5mc","2bdt10125p",16.579999999999998,19.564399999999996]
["bls. Pebd trans 10\"x12\"x5mc","2bdt10125p",0.1658,0.19564399999999998]
["mill. bls. Pebd trans 10\"x15\"x2mc ","2bdt10152p",40,47.199999999999996]
["mill. bls. Pebd trans 10\"x15\"x6mc","2bdt10156p",239.9,283.08199999999999]
["mill. bls. Pead 16\"x25.5\"x0.5",4,15.4,18.172000000000001]
["mill. bls. Pead 20\"x28\"x0.5",5,21.35,25.193000000000001]
["mill. bls. Pead 26\"x46.5\"x0.5",6,225.8,266.44400000000002]
["mill. bls. Pebd trans 10\"x12\"x5mc","2bdt10125p",165.8,{"$f":"C16*1.18","v":195.64400000000001}]
["mill. bls. Pead 16\"x25.5\"x0.5",7,15.4,18.172000000000001]
["mill. bls. Pead 20\"x28\"x0.5",8,21.35,25.193000000000001]
["mill. bls. Pead 26\"x46.5\"x0.5",9,225.8,266.44400000000002]
["mill. bls. Pebd trans 10\"x12\"x5mc","2bdt10125p",165.8,195.64400000000001]
["mill. bls. Pead 16\"x25.5\"x0.5",10,15.4,18.172000000000001]
["mill. bls. Pead 20\"x28\"x0.5",11,21.35,25.193000000000001]
["mill. bls. Pead 26\"x46.5\"x0.5",12,225.8,266.44400000000002]
["mill. bls. Ziploc trans 10\"x12\"x5mc","2bdt10125p",165.8,195.64400000000001]

{"sheet":"O","index":4,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["CONDICIÓN DE PAGO",null,null,"VENDEDOR",null,null,"MONEDA",null,"COMPROBANTES"]
[]
["DESCRIPCIÓN",null,null,"DESCRIPCION",null,null,"DESCRIPCION",null,"DESCRIPCION","NÚMERO"]
["Contado",null,null,"MMC",null,null,"Soles",null,"Factura",0]
["30 dias",null,null,null,null,null,"Dólares",null,"Boleta de Venta",0]
["45 dias"]

{"sheet":"Hoja1","index":5,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ELABORADO POR"]
["WWW.ARCHIVOEXCEL.COM"]
["Lima - Perú"]
["Copyright©  2020"]
["ARCHIVO EXCEL E.I.R.L."]