{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hoja_Productos","Hoja_Clientes","FACTURA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Hoja_Productos","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Codigo","Productos","Precio Compra","Precio Venta"]
[null,10,"Leche",2.5,3]
[null,20,"Soda",2,2.5]
[null,30,"Galleta Oreo",0.5,1]
[null,40,"Coca Cola",1.5,1.8]
[null,50,"Inka Cola",1.6,1.8]
[null,60,"Cuaderno",2.2200000000000002,3]
[null,70,"Lapicero",1.1000000000000001,1.5]
[null,80,"Celular",800,850]

{"sheet":"Hoja_Clientes","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Codigo","Razón Social","RUC","Telefono","Descripcion","Direccion"]
[null,"Cli_01","ATOMIC EIRL",123654827,0,"…","Jr. Faustino Maldonado"]
[null,"Cli_02","SOMBREROS RIOJA SAC",205645875,0,"…","Jr. Almirante G."]
[null,"Cli_03","MI EMPRESA SAC",203654875,0,"…","Jr. La Libertad"]
[null,"Cli_04","EL POTRO MECANICA SAC",205896423,0,"…","Jr. Santa Elena"]
[null,"Cli_05","ESTUDIO GG SAC",204587953,0,"…","Jr. Ricardo Palma"]
[null,"Cli_06","MILY Y TOMY EIRL",204458788,0,"…","Av. Magdalena 504"]

{"sheet":"FACTURA","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"Código Cliente"]
[null,null,null,null,"Nombre Doc","A_002"]
[]
[null,"N° Items"]
[]
[null,"Cliente:",{"$f":"VLOOKUP(F4,CLIENTES[],2,FALSE)","v":{"$error":"#N/A"}},null,"RUC:",4236445]
[null,"Dirección",{"$f":"VLOOKUP(F4,CLIENTES[],6,FALSE)","v":{"$error":"#N/A"}},null,"FECHA:","2018-02-02"]
[]
[]
[null,"Codigo","Producto","Cantidad","Precio","Sub Total"]
[null,40,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],2,FALSE)","v":"Coca Cola"},1,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],4,FALSE)","v":1.8},{"$f":"TABLA_PRODUCTOS[Precio]*TABLA_PRODUCTOS[Cantidad]","v":1.8}]
[null,80,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],2,FALSE)","v":"Celular"},2,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],4,FALSE)","v":850},{"$f":"TABLA_PRODUCTOS[Precio]*TABLA_PRODUCTOS[Cantidad]","v":1700}]
[null,30,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],2,FALSE)","v":"Galleta Oreo"},1,{"$f":"VLOOKUP(TABLA_PRODUCTOS[Codigo],PRODUCTOS[],4,FALSE)","v":1},{"$f":"TABLA_PRODUCTOS[Precio]*TABLA_PRODUCTOS[Cantidad]","v":1}]
[]
[]
[null,null,null,null,"Sub Total",{"$f":"SUM(TABLA_PRODUCTOS[Sub Total])","v":1702.8}]
[null,null,null,null,"IGV",{"$f":"F19*0.18","v":306.50399999999996}]
[null,null,null,null,"TOTAL",{"$f":"SUM(F19:F20)","v":2009.3039999999999}]