{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BASE DE DATOS","FORMATO FACTURA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"BASE DE DATOS","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["CONSECUTIVO","NOMBRE CLIENTE","IDENTIFICACION","FECHA DE FACTURA","NUMERO DE FACTURA","DESCRIPCIÓN","VR. UNITARIO","CANTIDAD"]
[1,"DORANIS ALARCON",84821046,"2021-01-01",2056,"VENTA 1",15245,50]
[2,"MARIA FERNANDA LOAIZA",36503700,"2025-08-07","FE2583","VENTA 2",13245,11]
[3,"FREDDY MONTENEGRO",72071405,"2030-02-14",4141,"VENTA 3",541222,3]
[4,"ADRIANA MORALES MENDEZ",44056449,"2000-05-13",2889,"VENTA 4",4100,44]
[5,"EMBIENTES S.A.",88891085,"2040-07-14",4511,"VENTA 5",36000,71]
[6,"EMPAQUES ECOLOGICOS LTDA",22958387,"2017-08-15",52365,"VENTA 6",47000,42]
[7,"ARCHIVO S.A.S",34320643,"2020-05-24","FOV7895","VENTA 7",88000,15]

{"sheet":"FORMATO FACTURA","index":1,"n_rows":26,"n_cols":59,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,53,0,62],[1,58,1,62],[2,58,2,62],[23,5,25,20],[4,9,4,20],[23,25,23,29],[24,25,24,29],[25,25,25,29],[23,21,23,24],[24,21,24,24],[25,21,25,24],[7,25,7,29],[8,5,22,8],[8,9,22,17],[8,18,22,20],[8,21,22,24],[8,25,22,29],[7,5,7,8],[7,9,7,17],[7,18,7,20],[7,21,7,24],[5,5,5,8],[5,9,5,17],[5,18,5,22],[5,23,5,29],[6,5,6,8],[4,5,4,8],[1,53,1,57],[2,53,2,57],[2,5,2,29],[3,5,3,29],[4,22,4,24],[4,25,4,29]]}
[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,"CONSECUTIVO"]
[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,"DESDE",null,null,null,null,"HASTA"]
[null,null,null,null,null,"EMPRESA DE WILMER",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,7,null,null,null,null,7]
[null,null,null,null,null,"900.222.333-8"]
[null,null,null,null,null,"CLIENTE:",null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,2,FALSE)","v":"ARCHIVO S.A.S"},null,null,null,null,null,null,null,null,null,null,null,null,"FAC:",null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,5,FALSE)","v":"FOV7895"}]
[null,null,null,null,null,"NIT: ",null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643},null,null,null,null,null,null,null,null,"FECHA:",null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,4,FALSE)","v":"2020-05-24"}]
[]
[null,null,null,null,null,"ITEM",null,null,null,"DESCRIPCIÓN",null,null,null,null,null,null,null,null,"CAN",null,null,"VR. UNI",null,null,null,"VR .TOTAL"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$H$8,6,FALSE)","v":"VENTA 7"},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$H$8,8,FALSE)","v":15},null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$H$8,7,FALSE)","v":88000},null,null,null,{"$f":"+S9*V9","v":1320000}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($BB$3,'BASE DE DATOS'!$A$1:$E$8,3,FALSE)","v":34320643}]
[null,null,null,null,null,"SON: Valor en letras del total de la factura",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALOR",null,null,null,{"$f":"+Z9","v":1320000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA",null,null,null,{"$f":"+Z24*19/100","v":250800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"+Z24+Z25","v":1570800}]