{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Valor neto personal","Activos","Deudas"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Valor neto personal","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"Efectivo y efectivo equivalente",{"$f":"SUMIF(TBL_Assets[Categoría],'Valor neto personal'!Q2,TBL_Assets[Valor])+ROW(Q2)/10000","v":42500.0002},{"$f":"_xlfn.RANK.EQ(R2,$R$2:$R$6,0)","v":5},null,{"$f":"INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),1)","v":"Efectivo y efectivo equivalente"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"Activos totales",{"$f":"SUM(TBL_Assets[Valor])","v":1923500}]
[null,null," VALOR NETO PERSONAL",{"$nulls":13},"Propiedades",{"$f":"SUMIF(TBL_Assets[Categoría],'Valor neto personal'!Q3,TBL_Assets[Valor])+ROW(Q3)/10000","v":1205000.0003},{"$f":"_xlfn.RANK.EQ(R3,$R$2:$R$6,0)","v":1},null,{"$f":"INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),1)","v":"Ahorros para la jubilación"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"Total de deudas",{"$f":"SUM(TBL_Debts[Valor])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"$1,271,000"}},{"$nulls":6},"ACTIVOS frente a DEUDAS",{"$nulls":6},"Inversiones",{"$f":"SUMIF(TBL_Assets[Categoría],'Valor neto personal'!Q4,TBL_Assets[Valor])+ROW(Q4)/10000","v":475000.0004},{"$f":"_xlfn.RANK.EQ(R4,$R$2:$R$6,0)","v":2},null,{"$f":"INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),1)","v":"Seguro de vida"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"Ahorros para la jubilación",{"$f":"SUMIF(TBL_Assets[Categoría],'Valor neto personal'!Q5,TBL_Assets[Valor])+ROW(Q5)/10000","v":98000.0005},{"$f":"_xlfn.RANK.EQ(R5,$R$2:$R$6,0)","v":4},null,{"$f":"INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),1)","v":"Inversiones"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"Activos totales",{"$f":"SUM(TBL_Assets[Valor])","v":{"v":1923500,"d":"$1,923,500 "}},{"$nulls":10},"Seguro de vida",{"$f":"SUMIF(TBL_Assets[Categoría],'Valor neto personal'!Q6,TBL_Assets[Valor])+ROW(Q6)/10000","v":103000.0006},{"$f":"_xlfn.RANK.EQ(R6,$R$2:$R$6,0)","v":3},null,{"$f":"INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),1)","v":"Propiedades"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"Total de deudas",{"$f":"SUM(TBL_Debts[Valor])","v":{"v":652500,"d":"$652,500 "}}]
[]
[]
[]
[{"$nulls":3},"RESUMEN DE ACTIVOS"]
[{"$nulls":10},{"$f":"U6","v":"Propiedades"},{"$f":"V6","v":{"v":1205000,"d":"$1,205,000 "}}]
[]
[{"$nulls":10},{"$f":"U5","v":"Inversiones"},{"$f":"V5","v":{"v":475000,"d":"$475,000 "}}]
[]
[{"$nulls":10},{"$f":"U4","v":"Seguro de vida"},{"$f":"V4","v":{"v":103000,"d":"$103,000 "}}]
[]
[{"$nulls":10},{"$f":"U3","v":"Ahorros para la jubilación"},{"$f":"V3","v":{"v":98000,"d":"$98,000 "}}]
[]
[{"$nulls":10},{"$f":"U2","v":"Efectivo y efectivo equivalente"},{"$f":"V2","v":{"v":42500,"d":"$42,500 "}}]

{"sheet":"Activos","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$nulls":4}," "]
[null,"ACTIVOS"]
[]
[null,"Categoría","Artículo","Valor"]
[null,"Propiedades","Casa",{"v":560000,"d":"$560,000.00"}]
[null,"Propiedades","Otros",{"v":255000,"d":"$255,000.00"}]
[null,"Ahorros para la jubilación","Cuentas para el retiro",{"v":98000,"d":"$98,000.00"}]
[null,"Inversiones","Acciones",{"v":53000,"d":"$53,000.00"}]
[null,"Inversiones","Bonos",{"v":25000,"d":"$25,000.00"}]
[null,"Inversiones","Fondos de inversión",{"v":33000,"d":"$33,000.00"}]
[null,"Inversiones","CD",{"v":74000,"d":"$74,000.00"}]
[null,"Inversiones","Lingotes",{"v":20000,"d":"$20,000.00"}]
[null,"Inversiones","Fondos fiduciarios",{"v":250000,"d":"$250,000.00"}]
[null,"Seguro de vida","Cuenta de ahorro para la salud",{"v":18000,"d":"$18,000.00"}]
[null,"Seguro de vida","Valor nominal de póliza de seguro de vida",{"v":85000,"d":"$85,000.00"}]
[null,"Inversiones","Otros",{"v":20000,"d":"$20,000.00"}]
[null,"Efectivo y efectivo equivalente","Cuentas corrientes",{"v":35500,"d":"$35,500.00"}]
[null,"Efectivo y efectivo equivalente","Cuentas de ahorro",{"v":5000,"d":"$5,000.00"}]
[null,"Efectivo y efectivo equivalente","Otros",{"v":2000,"d":"$2,000.00"}]
[null,"Propiedades","Autos",{"v":55000,"d":"$55,000.00"}]
[null,"Propiedades","Otros vehículos",{"v":85000,"d":"$85,000.00"}]
[null,"Propiedades","Mobiliario",{"v":100000,"d":"$100,000.00"}]
[null,"Propiedades","Coleccionables",{"v":50000,"d":"$50,000.00"}]
[null,"Propiedades","Joyas",{"v":60000,"d":"$60,000.00"}]
[null,"Propiedades","Otros artículos de lujo",{"v":40000,"d":"$40,000.00"}]

{"sheet":"Deudas","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"DEUDAS"]
[]
[null,"Categoría","Valor"]
[null,"Hipotecas",{"v":400000,"d":"$400,000.00"}]
[null,"Préstamos hipotecarios",{"v":50000,"d":"$50,000.00"}]
[null,"Préstamos para autos",{"v":30000,"d":"$30,000.00"}]
[null,"Préstamos personales",{"v":12500,"d":"$12,500.00"}]
[null,"Tarjetas de crédito",{"v":65000,"d":"$65,000.00"}]
[null,"Préstamos para estudiantes",{"v":10000,"d":"$10,000.00"}]
[null,"Préstamos frente a inversiones",{"v":20000,"d":"$20,000.00"}]
[null,"Préstamos para seguro de vida",{"v":5000,"d":"$5,000.00"}]
[null,"Otros préstamos en cuotas",{"v":10000,"d":"$10,000.00"}]
[null,"Otras deudas",{"v":50000,"d":"$50,000.00"}]