{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["TBL_VENTAS","FORMATO FACTURA","Hoja1"],"not_rendered":{"charts":0,"images":1,"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":"TBL_VENTAS","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["FACT #","COD. VENDEDOR","Num. vendedor","CIUDAD","PRODUCTO","CLIENTE","FECHA DE VENTA","CANTIDAD VENDIDA","PRECIO UNITARIO","V. SIN IVA","IVA 19%","TOTAL V"]
["BOG-014","01BOG","01","BOGOTÁ","NEVERA REF 001","Electro S.A","2021-03-13",14,3900,54600,10374,64974]
["BOG-014","01BOG","01","BOGOTÁ","TELEVISOR REF 002","Electro S.A","2021-03-13",16,3450,55200,10488,65688]
["BOG-014","01BOG","01","BOGOTÁ","LAVADORA REF 002","Electro S.A","2021-03-13",17,2300,39100,7429,46529]
["BOG-014","01BOG","01","BOGOTÁ","ESTUFA REF 004","Electro S.A","2021-03-13",7,1450,10150,1928.5,12078.5]
["BOG-015","04BOG","04","BOGOTÁ","TELEVISOR REF 002","Electrónicos ltda","2021-03-17",5,3450,17250,3277.5,20527.5]
["BOG-015","04BOG","04","BOGOTÁ","ESTUFA REF 004","Electrónicos ltda","2021-03-17",11,1450,15950,3030.5,18980.5]
["BOG-015","04BOG","04","BOGOTÁ","NEVERA REF 001","Electrónicos ltda","2021-03-17",10,3900,39000,7410,46410]
["BOG-015","04BOG","04","BOGOTÁ","ESTUFA REF 004","Electrónicos ltda","2021-03-17",7,1450,10150,1928.5,12078.5]
["BOG-015","04BOG","04","BOGOTÁ","LAVADORA REF 002","Electrónicos ltda","2021-03-17",10,2300,23000,4370,27370]
["BOG-016","02BOG","02","BOGOTÁ","ESTUFA REF 004","KOMERZIO","2021-03-21",7,1450,10150,1928.5,12078.5]
["BOG-016","02BOG","02","BOGOTÁ","NEVERA REF 001","KOMERZIO","2021-03-21",19,3900,74100,14079,88179]
["BOG-016","02BOG","02","BOGOTÁ","NEVERA REF 001","KOMERZIO","2021-03-21",11,3900,42900,8151,51051]
["BOG-016","02BOG","02","BOGOTÁ","LAVADORA REF 002","KOMERZIO","2021-03-21",20,2300,46000,8740,54740]
["BOG-016","02BOG","02","BOGOTÁ","ESTUFA REF 004","KOMERZIO","2021-03-21",5,1450,7250,1377.5,8627.5]
["BOG-016","02BOG","02","BOGOTÁ","TELEVISOR REF 002","KOMERZIO","2021-03-21",6,3450,20700,3933,24633]
["BOG-016","02BOG","02","BOGOTÁ","ESTUFA REF 004","KOMERZIO","2021-03-21",9,1450,13050,2479.5,15529.5]
["BOG-016","02BOG","02","BOGOTÁ","NEVERA REF 001","KOMERZIO","2021-03-21",7,3900,27300,5187,32487]
["BOG-017","04BOG","04","BOGOTÁ","LAVADORA REF 002","Ana maría Buitrago","2021-03-28",18,2300,41400,7866,49266]
["BOG-017","04BOG","04","BOGOTÁ","TELEVISOR REF 002","Ana maría Buitrago","2021-03-28",19,3450,65550,12454.5,78004.5]
["CAR-022","04CAR","04","CARTAGENA","TELEVISOR REF 002","Name electronics","2021-03-07",13,3450,44850,8521.5,53371.5]
["CAR-022","04CAR","04","CARTAGENA","ESTUFA REF 004","Name electronics","2021-03-07",3,1210,3630,689.7,4319.7]
["CAR-022","04CAR","04","CARTAGENA","NEVERA REF 001","Name electronics","2021-03-07",4,3700,14800,2812,17612]
["CAR-023","01CAR","01","CARTAGENA","LAVADORA REF 002","Namúra ltda","2021-03-08",15,3220,48300,9177,57477]
["CAR-023","01CAR","01","CARTAGENA","ESTUFA REF 004","Namúra ltda","2021-03-08",10,1210,12100,2299,14399]
["CAR-023","01CAR","01","CARTAGENA","LAVADORA REF 002","Namúra ltda","2021-03-08",15,3220,48300,9177,57477]
["CAR-025","03CAR","03","CARTAGENA","TELEVISOR REF 002","Los chalos S.A.","2021-03-12",14,3450,48300,9177,57477]
["CAR-026","02CAR","02","CARTAGENA","ESTUFA REF 004","Julia lopez","2021-03-17",16,1210,19360,3678.4,23038.400000000001]
["CAR-026","02CAR","02","CARTAGENA","TELEVISOR REF 002","Julia lopez","2021-03-17",4,3450,13800,2622,16422]
["CAR-026","02CAR","02","CARTAGENA","ESTUFA REF 004","Julia lopez","2021-03-17",14,1210,16940,3218.6,20158.599999999999]
["CAR-026","02CAR","02","CARTAGENA","NEVERA REF 001","Julia lopez","2021-03-17",1,3700,3700,703,4403]
["CAR-027","03CAR","03","CARTAGENA","NEVERA REF 001","Los chalos S.A.","2021-03-25",14,3700,51800,9842,61642]
["CAR-027","03CAR","03","CARTAGENA","LAVADORA REF 002","Los chalos S.A.","2021-03-25",9,3220,28980,5506.2,34486.199999999997]
["CAR-027","03CAR","03","CARTAGENA","ESTUFA REF 004","Los chalos S.A.","2021-03-25",6,1210,7260,1379.4,8639.4]
["CAR-027","03CAR","03","CARTAGENA","TELEVISOR REF 002","Los chalos S.A.","2021-03-25",1,3450,3450,655.5,4105.5]
["CAR-027","03CAR","03","CARTAGENA","LAVADORA REF 002","wilmer","2021-03-25",1,3450,3450,655.5,4105.5]
["CAR-027","03CAR","03","CARTAGENA","PRODUCTO WILMER","Electrónicos ltda","2021-03-25",1,3450,3450,655.5,4105.5]
["CAR-027","03CAR","03","CARTAGENA","PRODUCTO DESPIERTA","Electrónicos ltda","2021-03-25",1,3450,3450,655.5,4105.5]
["CAR-027","03CAR","03","CARTAGENA","PRODUCTO DESPIERTA","KOMERZIO","2021-03-25",1,3450,3450,655.5,4105.5]
["CAR-027","04CAR","04","CARTAGENA","YA ME CREEN INCREDULOS","KOMERZIO","2021-03-25",1,3450,3450,655.5,4105.5]

{"sheet":"FORMATO FACTURA","index":1,"n_rows":31,"n_cols":68,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,33,25,35],[25,36,25,55],[25,56,25,60],[25,61,25,66],[25,67,25,73],[28,33,30,60],[28,61,28,66],[28,67,28,73],[29,61,29,66],[29,67,29,73],[30,61,30,66],[30,67,30,73],[26,33,26,35],[26,36,26,55],[26,56,26,60],[26,61,26,66],[26,67,26,73],[27,33,27,35],[27,36,27,55],[27,56,27,60],[27,61,27,66],[27,67,27,73],[23,33,23,35],[23,36,23,55],[23,56,23,60],[23,61,23,66],[23,67,23,73],[24,33,24,35],[24,36,24,55],[24,56,24,60],[24,61,24,66],[24,67,24,73],[21,33,21,35],[21,36,21,55],[21,56,21,60],[21,61,21,66],[21,67,21,73],[22,33,22,35],[22,36,22,55],[22,56,22,60],[22,61,22,66],[22,67,22,73],[19,33,19,35],[19,36,19,55],[19,56,19,60],[19,61,19,66],[19,67,19,73],[20,33,20,35],[20,36,20,55],[20,56,20,60],[20,61,20,66],[20,67,20,73],[17,33,17,35],[17,36,17,55],[17,56,17,60],[17,61,17,66],[17,67,17,73],[18,33,18,35],[18,36,18,55],[18,56,18,60],[18,61,18,66],[18,67,18,73],[15,33,15,35],[15,36,15,55],[15,56,15,60],[15,61,15,66],[15,67,15,73],[16,33,16,35],[16,36,16,55],[16,56,16,60],[16,61,16,66],[16,67,16,73],[13,33,13,35],[13,36,13,55],[13,56,13,60],[13,61,13,66],[13,67,13,73],[14,33,14,35],[14,36,14,55],[14,56,14,60],[14,61,14,66],[14,67,14,73],[11,33,11,35],[11,36,11,55],[11,56,11,60],[11,61,11,66],[11,67,11,73],[12,33,12,35],[12,36,12,55],[12,56,12,60],[12,61,12,66],[12,67,12,73],[9,33,9,35],[9,36,9,55],[9,56,9,60],[9,61,9,66],[9,67,9,73],[10,33,10,35],[10,36,10,55],[10,56,10,60],[10,61,10,66],[10,67,10,73],[3,33,4,73],[5,33,5,73],[6,33,6,39],[6,40,6,61],[6,62,6,66],[6,67,6,73],[7,33,7,39],[7,40,7,61],[7,62,7,66],[7,67,7,73]]}
[]
[]
[]
[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,"SOLOELECTRICOS S.A"]
[]
[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,"ORDEN DE COMPRA"]
[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,"CLIENTE",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,"FECHA:"]
[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,"CIUDAD",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,"Factura No."]
[]
[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,"VEN",null,null,"CONCEPTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANT.",null,null,null,null,"VR.UNI",null,null,null,null,null,"SUBTOTAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"SON: XXXXXXXXXXXX X XX XX X X X X XXXXX  XXXXXXXX",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,"VALOR BASE"]
[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,null,"IVA"]
[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,null,"TOTAL"]

{"sheet":"Hoja1","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"chicos disculpen por no haber continuado con las tablas dinámicas"]
[]
[]
[null,null,5]
[null,null,12]
[null,null,{"$f":"SUM(C9:C10)","v":17}]