{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["WELCOME","INFO VIAJE","PREVIAJE","VIAJE","DASHBOARD","ANALISIS","Hoja2"],"not_rendered":{"charts":4,"images":16,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":3},"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":"WELCOME","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INFO VIAJE","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,1,14,5],[10,1,10,2],[10,4,10,5],[0,0,0,1],[0,2,0,6],[4,1,4,2],[4,4,4,5],[2,1,2,5]]}
[{"$error":"#VALUE!"},null,"INFORMACIÓN GENERAL DEL VIAJE \n(TRIP PROFILE)"]
[]
[null,"PLAN DE VIAJE"]
[]
[null,"DATOS GENERALES",null,null,"PRESUPUESTO"]
[null,"Fecha Inicio",null,null,"ÍTEM","VALOR"]
[null,"Fecha Final",null,null,"Presupuesto Gastos de Viaje"]
[null,"Duración Viaje (días)",{"$f":"IF(C7=\"\",0,(C7-C6))","v":0},null,"Fondo Compras"]
[null,"Destino(s)",null,null,"Fondo Emergencia"]
[null,"Tipo de Viaje",null,null,"Total",{"$f":"SUBTOTAL(109,Tabla3[VALOR])","v":0}]
[]
[null,"Número de Viajeros",null,null,"Presupuesto diario",{"$f":"IFERROR((Tabla3[[#Totals],[VALOR]]/C8),\"\")","v":""}]
[null,"Gastos Compartidos",null,null,"Presupuesto diario p/pax",{"$f":"IF(C13=\"SI\",F12/C12,\"\")","v":""}]
[]
[null,"ESTADO DEL PRESUPUESTO"]
[]
[null,"Fecha (HOY)",{"$f":"TODAY()","v":"2026-06-23"},null,"Presupuesto Inicial",{"$f":"Tabla3[[#Totals],[VALOR]]","v":0}]
[null,"Dias transcurridos",{"$f":"IF(C6=\"\",0,(C17-C6))","v":0},null,"Total Gastado",{"$f":"ExpenseTracker[[#Totals],[VALOR TOTAL PAGADO]]","v":0}]
[null,"Días faltantes",{"$f":"MAX(0,C8-C18)","v":0},null,"Total Disponible",{"$f":"F17-F18","v":0}]
[null,null,null,null,"Presupuesto diario disponible",{"$f":"IFERROR(F19/C19, 0)","v":0}]

{"sheet":"PREVIAJE","index":2,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[{"$error":"#VALUE!"},"GASTOS PRE-VIAJE\n(TRIP INVESTMENT)"]
["CATEGORÍA","DESCRIPCIÓN","VALOR TOTAL PAGADO","No. PAX","VALOR P/PAX"]
[null,null,null,null,{"$f":"IFERROR(C3/D3,\"\")","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,""]
["Total",null,{"$f":"SUBTOTAL(109,TripInvestment[VALOR TOTAL PAGADO])","v":0},null,{"$f":"SUBTOTAL(109,TripInvestment[VALOR P/PAX])","v":0}]

{"sheet":"VIAJE","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[{"$error":"#VALUE!"},"GASTOS DE VIAJE\n(TRAVEL EXPENSE TRACKER)"]
["CATEGORÍA","FECHA","DESTINO","DESCRIPCIÓN","VALOR TOTAL PAGADO","No. PAX","VALOR P/PAX"]
[null,null,null,null,null,null,{"$f":"IFERROR(E3/F3,\"\")","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,""]
["Total",null,null,null,{"$f":"SUBTOTAL(109,ExpenseTracker[VALOR TOTAL PAGADO])","v":0},null,{"$f":"SUBTOTAL(109,ExpenseTracker[VALOR P/PAX])","v":0}]

{"sheet":"DASHBOARD","index":4,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,17]]}
[{"$error":"#VALUE!"},null,null,"TRAVEL BUDGET TRACKER\n(DASHBOARD)"]

{"sheet":"ANALISIS","index":5,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[9,0,9,1],[16,0,16,1],[23,0,23,1],[16,3,16,4]]}
[]
[]
["CATEGORÍA","Suma de VALOR TOTAL PAGADO",null,"DESTINO","Suma de VALOR TOTAL PAGADO",null,"CATEGORÍA","Suma de VALOR TOTAL PAGADO"]
["Total general",null,null,"Total general",null,null,"Total general"]
[]
[]
[]
[]
[]
["KPIs"]
["Inversión Previa",{"$f":"GETPIVOTDATA(\"VALOR TOTAL PAGADO\",$A$3)","v":0},null,null,null,null,"Gastos en Destino",{"$f":"GETPIVOTDATA(\"VALOR TOTAL PAGADO\",$G$3)","v":0}]
["Gastos en Destino",{"$f":"GETPIVOTDATA(\"VALOR TOTAL PAGADO\",$D$3)","v":0}]
["Presupuesto",{"$f":"'INFO VIAJE'!F7+'INFO VIAJE'!F8+'INFO VIAJE'!F9","v":0}]
["Disponible",{"$f":"B13-B12","v":0}]
["Inversion Total",{"$f":"B11+B12","v":0}]
[]
["DATA GASTOS",null,null,"RESUMEN VIAJE"]
["Fecha Inicio",{"$f":"'INFO VIAJE'!C6","v":"00:00:00"},null,"Fecha Inicio",{"$f":"'INFO VIAJE'!C6","v":"00:00:00"}]
["Fecha Hoy",{"$f":"TODAY()","v":"2026-06-23"},null,"Fecha Fin",{"$f":"'INFO VIAJE'!C7","v":"00:00:00"}]
["Días Trasncurridos",{"$f":"B19-B18","v":46196},null,"Número de Días",{"$f":"E19-E18","v":0}]
["Gasto x día",{"$f":"B12/B20","v":0},null,"Destino",{"$f":"'INFO VIAJE'!C9","v":0}]
["Gasto x día x pax",{"$f":"B21/'INFO VIAJE'!C12","v":{"$error":"#DIV/0!"}},null,"Número de Viajeros",{"$f":"'INFO VIAJE'!C12","v":0}]
[]
["DATA GASTOS %"]
["Gastado",{"$f":"B12/B13","v":{"$error":"#DIV/0!"}}]
["Disponible",{"$f":"1-B25","v":{"$error":"#DIV/0!"}}]
["Oculto",1]

{"sheet":"Hoja2","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["TRIP INVESTMENT","EXPENSE TRACKER","TIPO DE VIAJE","GASTOS COMPARTIDOS"]
["VUELOS","ALIMENTACIÓN","SOLO TRAVELER","SI"]
["TRASLADOS","TRANSPORTE","FAMILIAR","NO"]
["ALOJAMIENTOS","COMPRAS","AMIGOS"]
["EXPERIENCIAS","EXPERIENCIAS","VACACIONES"]
["OTROS","OTROS","OTRO"]