{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AID","NCAGTV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":31,"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":"AID","index":0,"n_rows":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,17,5,18],[4,0,4,1],[4,17,4,18],[5,0,6,0],[5,2,6,2],[5,3,6,4],[5,5,6,9],[5,10,6,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,1],[3,2,3,9],[3,17,3,18]]}
["Teresita's Tours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESPROTEGIDO","AGENCIA","OB","TM","EJ","Z8","A4"]
["Travel Agency & Tour Operator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N.D. AGT Nº",10103,null,"INSIDE SUCRE AGENCIA DE VIAJES Y TURISMO",0.08,0.05,0.05,0.06,0.05]
["Sucre - Bolivia"]
["CLIENTE ",null,"INSIDE SUCRE AGENCIA DE VIAJES Y TURISMO",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE IMPRESIÓN","2016-03-07"]
["DIRECCION",null,{"$f":"IF(C4=\"\",\"\",VLOOKUP(C4,[1]CLIENTES!$A$3:$E$148,2,0))","v":"JUNIN"},null,null,null,null,null,null,null,null,null,null,null,null,null,"TELEFONO",{"$f":"IF(C4=\"\",\"\",VLOOKUP(C4,[1]CLIENTES!$A$3:$E$148,3,0))","v":6415003}]
["Nº","FECHA DE","COD","DOCUMENTO Nº",null,"RUTA Y/O SERVICIO",null,null,null,null,"PASAJER@","IMPORTE",null,"NETO",null,"COMISION",null,"NETO A PAGAR"]
[null,"EMISION",null,null,null,null,null,null,null,null,null,"BOLIVIANOS","DOLARES","BOLIVIANOS","DOLARES","BOLIVIANOS","DOLARES","BOLIVIANOS","DOLARES"]
[{"$f":"IF(B8=\"\",\"\",COUNT(B8:B8))","v":1},"2016-03-04","OB",930,1661651252,"SRE","CBB",null,null,null,"GORENA JUAN",231,0,194,0,{"$f":"IF(N8=0,0,+N8*T8)","v":15.52},0,{"$f":"IF(L8=\"\",0,L8-P8)","v":215.48},{"$f":"M8-Q8","v":0},{"$f":"INDEX($V$1:$Z$2,MATCH($C$4,$U$1:$U$2,0),MATCH($C8,$V$1:$Z$1,0))","v":0.08},1]
[{"$f":"IF(B9=\"\",\"\",COUNT($B$8:B9))","v":2},"2016-03-04","OB",930,1661651264,"SRE","LPB","CBB","SRE",null,"ORTUSTE LAURA",590,0,482,0,38.56,0,{"$f":"IF(L9=\"\",0,L9-P9)","v":551.44000000000005},{"$f":"M9-Q9","v":0},0.08,{"$f":"+U8+1","v":2}]
[{"$f":"IF(B10=\"\",\"\",COUNT($B$8:B10))","v":3},"2016-03-04","OB",930,1661651265,"SRE","LPB","CBB","SRE",null,"RENTERIA WILBER",590,0,482,0,38.56,0,{"$f":"IF(L10=\"\",0,L10-P10)","v":551.44000000000005},{"$f":"M10-Q10","v":0},0.08,3]
[{"$f":"IF(B11=\"\",\"\",COUNT($B$8:B11))","v":4},"2016-03-04","OB",930,1661651266,"VVI","CBB","SRE",null,null,"ANTELO LAURA MATILDE",249,0,196,0,15.68,0,{"$f":"IF(L11=\"\",0,L11-P11)","v":233.32},{"$f":"M11-Q11","v":0},0.08,4]
[{"$f":"IF(B12=\"\",\"\",COUNT($B$8:B12))","v":5},"2016-03-04","OB",930,1661651267,"LPB","SRE",null,null,null,"ARCIENEGA ADALIT",443,0,359,0,28.72,0,{"$f":"IF(L12=\"\",0,L12-P12)","v":414.28},{"$f":"M12-Q12","v":0},0.08,5]
[{"$f":"IF(B13=\"\",\"\",COUNT($B$8:B13))","v":6},"2016-03-04","OB",930,1661651283,"CBB","SRE",null,null,null,"COCA ANTEZANA ALFREDO",210,0,163,0,13.040000000000001,0,196.96,0,0.08,{"$f":"+#REF!+1","v":{"$error":"#REF!"}}]
[{"$f":"IF(B14=\"\",\"\",COUNT($B$8:B14))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(L14=\"\",0,L14-P14)","v":0},{"$f":"M14-Q14","v":0},{"$error":"#N/A"},{"$f":"+#REF!+1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"TOTALES",{"$f":"SUM(L8:L14)","v":2313},{"$f":"SUM(M8:M14)","v":0},{"$f":"SUM(N8:N14)","v":1876},{"$f":"SUM(O8:O14)","v":0},{"$f":"SUM(P8:P14)","v":150.07999999999998},{"$f":"SUM(Q8:Q14)","v":0},{"$f":"SUM(R8:R14)","v":2162.92},{"$f":"SUM(S8:S14)","v":0}]

{"sheet":"NCAGTV","index":1,"n_rows":290,"n_cols":15,"rows_kept":290,"cut":false,"hidden":false,"merged":[]}
["Nº","AGENCIA",{"$f":"CONCATENATE(\"BOB \"&SUBTOTAL(9,C2:C290))","v":"BOB 0"},{"$f":"CONCATENATE(\"USD \"&SUBTOTAL(9,D2:D290))","v":"USD 0"},{"$f":"CONCATENATE(\"COMISION  BOB \"&SUBTOTAL(9,E2:E290))","v":"COMISION  BOB 0"},"FECHA DE IMPRESIÓN","FECHA DE ENTREGA","FECHA DE VENCIMIENTO","RECIBO","FACTURA","OBS. VLADY","OBSERVACIONES",{"$f":"IF(A1-#REF!=1,\"OK\",\"FA\")","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(HYPERLINK(\"#\" & ADDRESS(MATCH(A1,[1]NCAGTE!$S:$S,0),19,1,1,\"NCAGTE\"), \"VER NOTA\"),\"NO VER\")","v":"NO VER"},"DESPROTEGIDO"]
[null,null,null,null,null,null,null,{"$f":"IF(G2=\"\",\"\",+G2+15)","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(G4=\"\",\"\",+G4+15)","v":""}]
[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,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,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,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,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,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,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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(G68=\"\",\"\",+G68+15)","v":""}]
[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,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,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,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,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,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,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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(G132=\"\",\"\",+G132+15)","v":""}]
[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,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,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,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,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,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,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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(G196=\"\",\"\",+G196+15)","v":""}]
[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,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,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,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,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,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,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,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(G260=\"\",\"\",+G260+15)","v":""}]
[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,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,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,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,""]