{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["GASTOS","CÂMBIO","ROTEIROS E DICAS","FOTOS","PLANO"],"not_rendered":{"charts":0,"images":27,"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":"GASTOS","index":0,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,29,3,29],[2,30,3,30],[2,31,3,31],[2,32,3,32],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,27,3,27],[2,28,3,28],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[36,1,36,3],[37,1,37,3],[1,1,1,3],[34,1,34,2],[35,1,35,2],[33,1,33,3],[2,3,3,3]]}
[28]
[{"$f":"ROUND(IF(C3=\"REAIS $\",CÂMBIO!B4,IF(C3=\"DÓLARES $\",CÂMBIO!C4,IF(C3=\"PESO ARS $\",CÂMBIO!D4,IF(C3=\"PESO CLP $\",CÂMBIO!E4,\"ERRO\")))),3)","v":3.4},{"$f":"CONCATENATE(\"ARG CHI BOL SET/OUT 2017 - \",A1,\" DIAS\")","v":"ARG CHI BOL SET/OUT 2017 - 28 DIAS"},null,null,"2017-09-08",{"$f":"E2+1","v":"2017-09-09"},{"$f":"F2+1","v":"2017-09-10"},"2017-09-11","2017-09-12","2017-09-13","2017-09-14","2017-09-15","2017-09-16","2017-09-17","2017-09-18",{"$f":"O2+1","v":"2017-09-19"},{"$f":"P2+1","v":"2017-09-20"},"2017-09-21","2017-09-22","2017-09-23","2017-09-24","2017-09-25","2017-09-26","2017-09-27","2017-09-28","2017-09-29","2017-09-30","2017-10-01","2017-10-02","2017-10-03","2017-10-04","2017-10-05","2017-10-06"]
[null,"TOTAL EM: ","REAIS $",{"$f":"(D5+D10+D15+D19+D24)","v":9181.1625785123961},{"$f":"E5+E10+E15+E19+E24","v":0},1506.8,256,371.9,101,94.188429752066128,1341.8611570247933,50.241322314049583,6.1818181818181817,5.6198347107438016,164.6611570247934,476.99555371900829,320.41459504132229,351.55999999999995,79.437206611570247,306.82302479338847,106,200,206.01680991735537,107.65355371900827,435.48408264462807,659.16277685950422,12.363636363636363,118.01652892561984,288.30909090909091,694,747,173.47199999999998,0]
[null,"CATEGORIAS","MÉDIA / DIA"]
[null,"TRANSPORTES",{"$f":"D5/$A$1","v":157.56881936245574},{"$f":"somacor($F5:$AG5)","v":4411.9269421487606},{"$f":"somacor(E6:E9)*$A$2","v":0},{"$f":"somacor(F6:F9)*$A$2","v":1292},154,105.9,0,3.3719008264462809,342.71074380165288,0,0,0,39.33884297520661,264.62200000000001,0,92.003999999999991,15.454545454545455,219.71558677685951,10,22,20,22.479338842975206,323.22254545454541,78.67768595041322,0,0,110.42975206611571,606,634,55.999999999999993,0]
[null,"CARRO",{"$f":"D6/$A$1","v":8.3860684769775684},{"$f":"somacor(E6:AG6)*$A$2","v":234.80991735537194},null,null,null,null,null,null,7600,null,null,null,null,null,null,null,null,null,null,null,100,null,{"$f":"500","v":500},{"$f":"1500+1500","v":3000},null,null,1500,{"$f":"350+160","v":510},150,60]
[null,"LOTAÇÃO",{"$f":"D7/$A$1","v":9.0963648170011808},{"$f":"somacor(E7:AG7)*$A$2","v":254.69821487603306},null,null,null,null,null,null,null,null,null,null,null,null,null,27.06,null,{"$f":"2500","v":2500},null,null,null,null,{"$f":"5000+2500+800","v":8300},null,null,null,30]
[null,"ONIBUS",27.828457497048408,779.19680991735538,null,280,{"$f":"25+730+15","v":770},{"$f":"29.5+500","v":529.5},null,{"$f":"600","v":600},null,null,null,null,{"$f":"7000","v":7000},null,null,null,{"$f":"750+2000","v":2750},{"$f":"60.49","v":60.49},50,{"$f":"110","v":110},null,{"$f":"1300+2000+700","v":4000},11.52,11000,null,null,null,null,null,220]
[null,"AÉRIO",112.25792857142858,3143.2220000000002,null,{"$f":"1236","v":1236},null,null,null,null,300,null,null,null,null,{"$f":"77.83","v":77.83},null,null,null,null,null,null,null,null,234.6,null,null,null,null,504,604]
[null,"ALIMENTAÇÃO",{"$f":"D10/$A$1","v":42.181282172373074},{"$f":"somacor($F10:$AG10)","v":1181.0759008264461},{"$f":"somacor(E11:E14)*$A$2","v":0},{"$f":"somacor(F11:F14)*$A$2","v":192.79999999999998},67,48,15,14.611570247933884,{"$f":"somacor(K11:K14)*$A$2","v":59.008264462809919},10.902479338842975,6.1818181818181817,5.6198347107438016,24.165289256198349,64.628099173553721,40.968595041322317,104.34599999999999,58.304661157024789,25.289256198347111,36,89.000000000000014,63.179305785123965,16.803305785123968,50.443355371900829,24.109090909090909,12.363636363636363,0,47.879338842975194,29.999999999999996,35,39.472000000000001,0]
[null,"CAFÉ",0.75867768595041318,{"$f":"somacor(E11:AG11)*$A$2","v":21.242975206611568},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2200,null,1580]
[null,"ALMOÇO",16.211578512396695,{"$f":"somacor(E12:AG12)*$A$2","v":453.92419834710745},null,150,100,200,null,null,6500,null,null,null,null,7500,null,24.18,9.76,{"$f":"2750","v":2750},null,200,2990,2990,3900,null,null,null,null,140,null,9.08]
[null,"JANTAR",11.152802833530107,312.278479338843,null,700,235,null,null,null,null,{"$f":"1940","v":1940},null,null,null,null,null,null,null,null,null,200,13.64,null,null,null,null,null,140]
[null,"LANCHE",14.058223140495867,393.63024793388428,null,114,null,{"$f":"20+20","v":40},75,{"$f":"1050+1050+500","v":2600},{"$f":"2500+1500","v":4000},null,1100,1000,4300,{"$f":"2800+1200","v":4000},{"$f":"2290+5000","v":7290},6.51,{"$f":"(990*3)+900+600","v":4470},{"$f":"600+1150","v":1750},180,45,null,null,8.39,4290,null,null,55,10,{"$f":"105+70","v":175},43]
[null,"HOSPEDAGEM",45.968659976387258,{"$f":"somacor($F15:$AG15)","v":1287.1224793388433},{"$f":"somacor(E16:E18)*$A$2","v":0},{"$f":"somacor(F16:F18)*$A$2","v":0},0,60,0,39.900826446280995,320.3305785123967,0,0,0,44.958677685950413,134.87603305785126,0,0,0,61.81818181818182,60,0,105.97800000000001,0,61.81818181818182,153.44200000000001,0,0,30,58,78,78,0]
[null,"HOTEL",45.968659976387244,{"$f":"somacor(E16:AG16)*$A$2","v":1287.1224793388428},null,null,null,300,null,7100,57000,null,null,null,8000,24000,null,null,null,11000,300,null,31.17,null,11000,45.13,null,null,150,290,390,390]
[null,"CASA",0,{"$f":"somacor(E17:AG17)*$A$2","v":0}]
[null,"CAMPING",0,0]
[null,"PASSEIOS",56.695753837072019,{"$f":"somacor($F19:$AG19)","v":1587.4811074380166},{"$f":"somacor(E20:E23)*$A$2","v":0},{"$f":"somacor(F20:F23)*$A$2","v":0},30,150,44,0,578.84297520661153,39.33884297520661,0,0,0,12.869421487603304,0,0,0,0,0,89,0,22.479338842975206,0,402.93400000000003,0,118.01652892561984,99.999999999999986,0,0,0,0]
[null,"CITY TOURS",0,{"$f":"somacor(E20:AG20)*$A$2","v":0}]
[null,"TRILHAS/PASSEIOS",42.451657024793391,{"$f":"somacor(E21:AG21)*$A$2","v":1188.6463966942149},null,null,null,{"$f":"750","v":750},220,null,103000,null,null,null,null,2290,null,null,null,null,null,null,null,null,null,118.51]
[null,"EVENTOS",1.0714285714285714,30,null,null,150]
[null,"ENTRADAS",13.172668240850058,368.83471074380162,null,null,null,null,null,null,null,7000,null,null,null,null,null,null,null,null,null,{"$f":"445","v":445},null,4000,null,null,null,21000,500]
[null,"COMPRAS",25.484148170011803,{"$f":"somacor($F24:$AG24)","v":713.55614876033053},{"$f":"somacor(E25:E28)*$A$2","v":0},{"$f":"somacor(F25:F28)*$A$2","v":22},5,8,42,36.304132231404957,40.968595041322317,0,0,0,56.198347107438011,0,279.44599999999997,155.20999999999998,5.6779999999999999,0,0,0,16.859504132231407,45.891570247933878,0,0,0,0,0,0,0,0,0]
[null,"LEMBRANÇAS",0.6428571428571429,{"$f":"somacor(E25:AG25)*$A$2","v":18},null,90]
[null,"ROUPAS",15.724136953955135,{"$f":"somacor(E26:AG26)*$A$2","v":440.27583471074377},null,null,null,null,null,1000,null,null,null,null,null,null,{"$f":"57.03+25.16","v":82.19},45.65]
[null,"CALÇADOS",0,0]
[null,"COMODIDADE",9.1171540731995275,255.28031404958676,null,20,25,40,{"$f":"40+(100+50+10+5+2+2+1)","v":210},{"$f":"1960+3500","v":5460},{"$f":"1700+1590+4000","v":7290},null,null,null,{"$f":"3000+7000","v":10000},null,null,null,{"$f":"1.67","v":1.67},null,null,null,3000,{"$f":"5000+2000+1000+100+50+10+5+1","v":8166}]
[]
[null,"OBS: VALORES CONVERTIDOS PARA MOEDA ESCOLHIDA"]
[null,"$ DÓLAR","$ PESO CLP","$PESO ARG"]
[null,"R$ REAIS"]

{"sheet":"CÂMBIO","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,1,10,4],[1,1,1,4],[28,7,29,7],[27,11,30,11],[2,6,2,7],[2,8,2,9],[1,6,1,13],[2,10,2,12]]}
[null,{"$f":"gfCelColorName(B3)","v":"5287936"},{"$f":"gfCelColorName(C3)","v":"15773696"},"49407","8421504"]
[null,"TABELA DE CÁLCULO",null,null,null,null,"TABELA DE CÂMBIO"]
[null,"REAIS $","DÓLARES $","PESO ARS $","PESO CLP $",null,"PAGO",null,"RECEBIDO",null,"DETALHES | GASTO TOTAL EM REAIS: ",null,null,{"$f":"SUM(G5:G8)+G17+P3","v":5240.4449999999997}]
[null,3.4,1,17,605,null,"VALOR","MOEDA","VALOR","MOEDA","CÂMBIO","LOCAL","DATA","TIPO"]
[null,null,{"$f":"ROUND(B5/B4,3)","v":0},{"$f":"ROUND(C5,3)*D4","v":0},{"$f":"ROUND(C5,3)*E4","v":0},null,{"$f":"5677.78/4","v":1419.4449999999999},"REAIS",{"$f":"1600/4","v":400},"DÓLARES",3.51,"NATAL - RN","2016-06-23","CASH"]
[null,{"$f":"ROUND(C6,3)*B4","v":0},null,{"$f":"ROUND(C6*D4,3)","v":0},{"$f":"ROUND(C6*E4,3)","v":0},null,340,"REAIS",100,"DÓLARES",3.4,"RECIFE - PE","2017-09-06","CARTÃO 0958"]
[null,{"$f":"ROUND(C7,3)*B4","v":0},{"$f":"ROUND(D7/D4,3)","v":0},null,{"$f":"ROUND(C7,3)*E4","v":0},null,987,"REAIS",300,"DÓLARES",3.2542040000000001,{"$f":"L6","v":"RECIFE - PE"},{"$f":"M6","v":"2017-09-06"},"CASH"]
[null,{"$f":"ROUND(C8,3)*B4","v":0},{"$f":"ROUND(E8/E4,3)","v":0},{"$f":"ROUND(C8,3)*D4","v":0},null,null,2394,"REAIS",700,"DÓLARES",3.42,"RECIFE - PE","2017-09-08","CARTÃO 5509"]
[null,null,null,null,null,null,100,"DÓLARES",1700,"PESOS ARG",17,"BUENOS AIRES","2017-09-09","CASH"]
[null,null,null,null,null,null,50,"DÓLARES",850,"PESOS ARG",17,"BUENOS AIRES","2017-09-10","CASH"]
[null,null,null,null,null,null,300,"DÓLARES",4300,"PESOS ARG",17.2,"MENDOZA","2017-09-11","CASH"]
[null,null,null,null,null,null,200,"DÓLARES",123000,"PESOS CLP",165,"SANTIAGO","2017-09-13","CASH"]
[null,null,null,null,null,null,72.94,"DÓLARES",43500,"PESOS CLP",596.38099999999997,"SANTIAGO BANK STAFF",{"$f":"M12","v":"2017-09-13"},"CASH"]
[null,null,null,null,null,null,{"$f":"259.46+2.5","v":261.95999999999998},"DÓLARES",150000,"PESOS CLP",578.12,"ATACAMA","2017-09-14","CASH"]
[null,null,null,null,null,null,999.94,"REAIS",289,"DÓLARES",{"$f":"G15/I15","v":3.4600000000000004},"RECIFE - PE","2017-09-20","CARTÃO 5509"]
[null,null,null,null,null,null,100,"DÓLARES",62400,"PESOS CLP",624,"PUERTO VARAS","2017-09-26","CASH"]
[null,null,null,null,null,null,100,"REAIS",{"$f":"G17/5.5*1000","v":18181.818181818184},"PESOS CLP",{"$f":"I17/G17","v":181.81818181818184},"PUNTA ARENAS","2017-09-28","CASH"]
[null,null,null,null,null,null,349,"REAIS",100,"DÓLARES",3.49,"EL CALAFATE","2017-10-02","CARTÃO 5509"]
[null,null,null,null,null,null,36.86,"DÓLARES",500,"PESOS ARG",{"$f":"I19/G19","v":13.564839934888768},"USHUAIA","2017-10-03","CASH"]
[null,null,null,null,null,null,{"$f":"48.72+2.5","v":51.22},"DÓLARES",700,"PESOS ARG",{"$f":"I20/G20","v":13.666536509176103},"BUENOS AIRES","2017-10-05","CASH"]

{"sheet":"ROTEIROS E DICAS","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,{"$f":"CONCATENATE(\"ROTEIRO \",GASTOS!B2)","v":"ROTEIRO ARG CHI BOL SET/OUT 2017 - 28 DIAS"}]
[null,"CIDADE","O QUE FAZER","NOTA","OBSERVAÇÕES"]
[null,"BUENOS AIRES","CIDADE",8,"MONUMENTOS E PRAÇAS"]
[null,"MENDOZA","FULL DAY BASE ACONCÁGUA",8," BOM PASEIO PRA QUEM GOSTA DE UM POUCO DE AVENTURA"]
[null,"ATACAMA","VALE LA LUNA, TUOR ASTRONÔMICO, GEYZER DEL TAYTO, SALAR DE TARA",10,"DA PRA FAZER O GEYSER DE TAITOR, VALE DA LUNA E TUOR ASTRONÔMICO NO MESMO DIA, OS 3 MELHORES E O SALAR DE TARA MUITO BOM TBM PRA OUTRO DIA"]
[null,"SANTIAGO","CENTRO, DIA DE MONTANHA, VINA DEL MAR E VAL PARAÍSO",8,"RECOMENTO UM DIA DE MONTANHA PRA QUER QUER CURTIR NEVE"]
[null,"PUERTO MONTT","CIDADE",7]
[null,"BARILOCHE","CERRO CATEDRAL",8,"PASSEIO PRINCIPAL PRA QUEM TEM UM DIA EM BARILOCHE OUTRA BOA OPÇÃO É O TRONADOR"]
[null,"PUERTO VARAS","VULCÃO OSORNO E SALTOS DE PRETOÉH",7,"BOM, MAS RECOMENDO IR COM AGENCIAS OU COM CARRO, NÃO HÁ TRANSPORTE PÚBLICO PARA O OSORNO"]
[null,"PUNTA ARENA","CIDADE",7,"CIDADE"]
[null,"PUERTO NATALES","TORRES DEL PAINE",9,"EXCELENTE RECOMENDO UMA SEMANA NESTE LOCAL, CHOVE MUITO E AS CAMINHADAS SÃO LONGAS"]
[null,"EL CALAFATE","GLACIAL PERITO MORENO",9,"BOM PARA CONEHCER"]
[null,"USHUAIA","CIDADE",8]
[null,"BUENOS AIRES","CIDADE",8]

{"sheet":"FOTOS","index":3,"n_rows":162,"n_cols":2,"rows_kept":162,"cut":false,"hidden":false,"merged":[[161,1,161,22],[121,1,121,22],[141,1,141,22],[1,1,1,22],[21,1,21,22],[41,1,41,22],[61,1,61,22],[81,1,81,22],[101,1,101,22]]}
[]
[null,"BUENOS AIRES - ARGENTINA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MENDOZA - ARGENTINA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DESERTO DO ATACAMA - CHILE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SANTIAGO - CHILE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PUERTO MONTT / PUERTO VARAS - CHILE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BARILOCHE - ARGENTINA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PUNTA ARENAS / PUERTO NATALES - CHILE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PARQUE TORRES DEL PAINE - CHILE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EL CALAFATE / USHUAIA - ARGENTINA"]

{"sheet":"PLANO","index":4,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nr","data","local","passeio","descrção"]
[null,1,"2017-09-09","buenos aires","cidade"]
[null,{"$f":"B3+1","v":2},"2017-09-10",{"$f":"D3","v":"buenos aires"},"cidade","Saida 22:30 hs. Chegada 12:55 hs.  Duração 14:25 hs. - Cama Ejecutivo"]
[null,{"$f":"B4+1","v":3},"2017-09-11","mendonza","cidade"]
[null,4,"2017-09-12",{"$f":"D5","v":"mendonza"},"alta montanha"]
[null,5,"2017-09-13","santiago chile","cidade","Saida 06:30 hs. Chegada 13:00 hs. Duração 06:30 hs. - Semicama Promocional"]
[null,6,"2017-09-14","atacama","cidade e astronômico","ida 06h30 -> 08h40"]
[null,7,"2017-09-15","atacama","gaizers e vale la luna"]
[null,8,"2017-09-16","atacama","lagunas"]
[null,9,"2017-09-17","atacama","salar de tara","saida 4:30 - volta12:00 - Dur: 7h"]
[null,10,"2017-09-18","santiago chile","cidade","volta 13h45 -> 15h50"]
[null,11,"2017-09-19",{"$f":"D12","v":"santiago chile"},"cidade"," Saida 07:17 chegada 09:50 - Semi Cama"]
[null,12,"2017-09-20","santiago chile","compras","3h de viagem - maule"]
[null,13,"2017-09-21","santiago chile","el colorado","Saida 23:15  Chegada 07:05 Duração 07h50 - Semi Cama"]
[null,14,"2017-09-22","santiago chile","val paraíso","a partir das 15h - 4h30 de viagem"]
[null,15,"2017-09-23","puerto montt","cidade","QK8TC6 - 08h15 -- 10h00 - sky"]
[null,16,"2017-09-24","bariloche","cidade",21400]
[null,17,"2017-09-25","bariloche","cerro catedral","duração 4h30"]
[null,18,"2017-09-26","puerto varas","cidade"]
[null,19,"2017-09-27",{"$f":"D20","v":"puerto varas"},"salto de petroéh e osorno","duração 6h30 - 13h15 - 19h50"]
[null,20,"2017-09-28","punta arenas","cidade","ida 11:25 - > 13:35"]
[null,21,"2017-09-29","puerto natales chile","cidade"]
[null,22,"2017-09-30",{"$f":"D23","v":"puerto natales chile"},"torres del paIne","3h15"]
[null,23,"2017-10-01",{"$f":"D24","v":"puerto natales chile"},{"$f":"E24","v":"torres del paIne"}]
[null,24,"2017-10-02","el calafate","cidade"]
[null,25,"2017-10-03","ushuia arg","cidade"]
[null,26,"2017-10-04","buenos aires","cidade"]
[null,27,"2017-10-05","buenos aires","cidade"]
[null,28,"2017-10-06","recife, brasil","volta"]
[null,null,"legenda:","1º corte se neces.","2º corte"]