{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Factura","Copias_Factura","Filtro"],"not_rendered":{"charts":0,"images":1,"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":"Factura","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,9,3],[25,1,26,3]]}
[]
[null,"FACTURA #"]
[11,{"$f":"IF(B2=\"FACTURA #\", A3,IF(B2=\"RECIBO #\",A4))","v":11}]
[1]
[]
[]
[null,"Cod Cliente RIF/CI",null,{"$f":"IFERROR(MATCH(C7,Copias_Factura!B:B,0),\"--\")","v":"--"}]
[null,"Nombre"]
[null,"Dirección"]
[]
[null,"Telefono1&2",null,null,{"$f":"TODAY()","v":"2016-07-02"},{"$f":"NOW()","v":42553.785303703706}]
[null,"Forma de pago"]
[null,"Cod Prod","Descripcion Producto","Precio/U/Venta","Cantidad","Total"]
[null,null,{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B14,Codigo,0),1)),\"\",INDEX(Datosstock,MATCH(B14,Codigo,0),1))","v":""},{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B14,Codigo,0),7)),\"\",INDEX(Datosstock,MATCH(B14,Codigo,0),7))","v":""},null,{"$f":"IF(ISERROR(D14*E14),\"\",D14*E14)","v":""}]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B21,Codigo,0),1)),\"\",INDEX(Datosstock,MATCH(B21,Codigo,0),1))","v":""},"",null,""]
[null,null,{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B22,Codigo,0),1)),\"\",INDEX(Datosstock,MATCH(B22,Codigo,0),1))","v":""},{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B22,Codigo,0),7)),\"\",INDEX(Datosstock,MATCH(B22,Codigo,0),7))","v":""},null,""]
[null,null,{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B23,Codigo,0),1)),\"\",INDEX(Datosstock,MATCH(B23,Codigo,0),1))","v":""},{"$f":"IF(ISERROR(INDEX(Datosstock,MATCH(B23,Codigo,0),7)),\"\",INDEX(Datosstock,MATCH(B23,Codigo,0),7))","v":""},null,""]
[]
[null,"Precio neto:",null,null,"SUB TOTAL",{"$f":"IF(SUM(F14:F17)<=0,\"\",SUM(F14:F17))","v":""}]
[null,{"$f":"IF(ISERROR(numletr(F27)),\"\",numletr(F27))","v":""},null,null,0.12,{"$f":"IF((SUM(F14:F17)*E26)<=0,\"\",SUM(F14:F17)*E26)","v":""}]
[null,null,null,null,"TOTAL",{"$f":"IF(SUM(F25:F26)<=0,\"\",SUM(F25:F26))","v":""}]
[null,"Nota:Todo pago que no sea en efectivo o targeta, la entrega de mercancía se efectuará después de hecho efectivo"]

{"sheet":"Copias_Factura","index":1,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["# Factura","RIF/CI","Nombre Cliente","Dirección","Cod-A/Pueblo/Ciudad","Telfono","Fecha","Descripcion Producto","Cant.","Prcio/U/Vent","Valor","IVA","Total",null,null,null,null,"E-19056809-0"]
[8,"J-30637770-0","CONDOMINIO RES. VISTA REAL","AV, 114, RES. VISTA REAL URB. EL BOSQUE","Cagua","0243-2424529","2016-02-11","Alambre cromado",2,683.94900000000007,1367.8980000000001,null,null,null,null,null,null,"G-31410845-0"]
[null,null,null,null,null,null,null,"Correas Ventilador",1,11022.627,11022.627,null,null,null,null,null,null,"G-31410845-0"]
[null,null,null,null,null,null,null,"Bombas Aceite Motor 3304-3306",3,75158.264999999999,225474.79499999998,28543.838399999997,266409.15839999996,null,null,null,null,"J-30637770-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V-15274577-6"]
[9,"V-31080518-0","SUPERFLY, C.A","CALLE CARABOBO CASA 144-30 LA VIÑA","Valencia","0414-3005624","2016-02-13","Bombas Aceite Motor 3304-3306",1,75158.264999999999,75158.264999999999,null,null,null,null,null,null,"V-31080518-0"]
[null,null,null,null,null,null,null,"Alambre acero inoxidable",1,432.13800000000003,432.13800000000003,9070.84836,84661.251360000009]
[]
[10,"G-31410845-0","LA BURRA LARGA C.A","CALLE CALLEJON MANGO QTA LA","Barquisimeto City","0246-2424528","2016-02-13","Alambre corrugado",1,539.17500000000007,539.17500000000007]
[null,null,null,null,null,null,null,"Alambre endurecido",1,130.87200000000001,130.87200000000001]
[null,null,null,null,null,null,null,"Correas Ventilador",1,11022.627,11022.627,1403.1208799999999,13095.794880000001]
[]
[10,"G-31410845-0","LA BURRA LARGA C.A","CALLE CALLEJON MANGO QTA LA","Barquisimeto City","0246-2424528","2016-02-13","Alambre corrugado",1,539.17500000000007,539.17500000000007]
[null,null,null,null,null,null,null,"Alambre endurecido",1,130.87200000000001,130.87200000000001]
[null,null,null,null,null,null,null,"Correas Ventilador",1,11022.627,11022.627,1403.1208799999999,13095.794880000001]
[]
[11,"E-19056809-0","El capta huellas","Av. Alfredo Cardona N° 145 Urb. La Julia","Marac","0243-2424527","2016-02-14","Alambre cromado",1,683.94900000000007,683.94900000000007]
[null,null,null,null,null,null,null,"Alambre acero inoxidable",1,432.13800000000003,432.13800000000003]
[null,null,null,null,null,null,null,"Alambre endurecido",1,130.87200000000001,130.87200000000001]
[null,null,null,null,null,null,null,"Bombas Aceite Motor 3304-3306",1,75158.264999999999,75158.264999999999,9168.6268799999998,85573.850879999998]
[]
[12,"V-15274577-6","Joca","Urdaneta Cooperativa","Maracay","0414-4571649","2016-02-14","Alambre acero inoxidable",1,432.13800000000003,432.13800000000003]
[null,null,null,null,null,null,null,"Alambre cromado",1,683.94900000000007,683.94900000000007,133.93044,1250.0174400000001]

{"sheet":"Filtro","index":2,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Cod Cliente RIF/CI","Nombre Cliente","Dirección","Pueblo/Ciudad","Telefono 1","Telefono 2","Fecha","Cod Cliente RIF/CI","Nombre Cliente","Dirección","Pueblo/Ciudad","Telefono 1","Telefono 2","Fecha"]
["J-30637770-0","CONDOMINIO RES. VISTA REAL","AV, 114, RES. VISTA REAL URB. EL BOSQUE","Cagua","0243-2424529","0414-2456400","2014-07-10","J-30637770-0","CONDOMINIO RES. VISTA REAL","AV, 114, RES. VISTA REAL URB. EL BOSQUE","Cagua","0243-2424529","0414-2456400","2014-07-10"]
["E-19056809-0","El capta huellas","Av. Alfredo Cardona N° 145 Urb. La Julia","Marac","0243-2424527","0414-2456398","2015-03-07","E-19056809-0","El capta huellas","Av. Alfredo Cardona N° 145 Urb. La Julia","Marac","0243-2424527","0414-2456398","2015-03-07"]
["V-15274577-6","Joca","Urdaneta Cooperativa","Maracay","0414-4571649","0243-2424525","11/01/2016","V-15274577-6","Joca","Urdaneta Cooperativa","Maracay","0414-4571649","0243-2424525","11/01/2016"]
["G-31410845-0","LA BURRA LARGA C.A","CALLE CALLEJON MANGO QTA LA","Barquisimeto City","0246-2424528","0416-2456399","2014-11-07","G-31410845-0","LA BURRA LARGA C.A","CALLE CALLEJON MANGO QTA LA","Barquisimeto City","0246-2424528","0416-2456399","2014-11-07"]
["J-30909911-6","SERVIPLAGAS, C.A.","AV MICHELENA C.C. ARPE NIVEL NAVE D, LOCAL 9-D","Turmer","0414-3005625","0426-8020407","2014-09-08","J-30909911-6","SERVIPLAGAS, C.A.","AV MICHELENA C.C. ARPE NIVEL NAVE D, LOCAL 9-D","Turmer","0414-3005625","0426-8020407","2014-09-08"]
["V-31080518-0","SUPERFLY, C.A","CALLE CARABOBO CASA 144-30 LA VIÑA","Valencia","0414-3005624","0426-8020406","","V-31080518-0","SUPERFLY, C.A","CALLE CARABOBO CASA 144-30 LA VIÑA","Valencia","0414-3005624","0426-8020406",""]