{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Panel","Registro de gastos","Datos de gastos personales"],"not_rendered":{"charts":1,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Panel","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,1,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,"panel de gastos personales",{"$nulls":3},"ir al registro de gastos >"]
[null,"El gráfico dinámico que muestra los gastos por categoría y mes se encuentra en esta celda. Las segmentaciones de datos para filtrar los gastos según la fecha, las categorías y las subcategorías se encuentran a continuación en las celdas B3, D3 y F3."]
[null,"La segmentación para filtrar los datos de la tabla en función de la fecha se encuentra en esta celda.",null,"La segmentación para filtrar los datos de la tabla en función de la categoría se encuentra en esta celda.",null,"La segmentación para filtrar los datos de la tabla en función de la subcategoría se encuentra en esta celda."]

{"sheet":"Registro de gastos","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"registro de gastos",{"$nulls":3},"< ir al panel"]
[null,"fecha","categoría","subcategoría","importe","nota"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Alojamiento","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Alojamiento","Teléfono fijo",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Alojamiento","Electricidad",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Ocio","Gimnasio",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Diario","Ropa",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Transporte","Abono del metro",{"v":21,"d":"21.00 €"},"Abono de marzo"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Transporte","Combustible",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Diario","Peluquería",{"v":12,"d":"12.00 €"}]
[null,"2019-04-02","Diario","Té o café",{"v":12,"d":"12.00 €"}]
[null,"2019-04-02","Diario","Dulces o caramelos",{"v":2.75,"d":"2.75 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Alojamiento","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Alojamiento","Teléfono fijo",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Alojamiento","Electricidad",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Diario","Lentes de contacto",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Diario","Ropa",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Transporte","Abono del metro",{"v":21,"d":"21.00 €"},"Abono de abril"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"Transporte","Combustible",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"Diario","Peluquería",{"v":12,"d":"12.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"Ocio","Cine",{"v":21,"d":"21.00 €"},"Noche de películas clásicas"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"Diario","Dulces o caramelos",{"v":2.75,"d":"2.75 €"}]

{"sheet":"Datos de gastos personales","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"datos de gastos personales"]
[null,"La siguiente tabla dinámica proporciona el origen de datos para el gráfico dinámico de gastos personales en Panel. Si realiza cambios, pueden producirse errores o modificaciones visuales en el gráfico dinámico."]
[null,"Suma del importe","Etiquetas de columna"]
[null,"Etiquetas de fila","Ocio","Transporte","Diario","Alojamiento","Total general"]
[null,"mar",29,21,42,130,222]
[null,"abr",null,75,97.75,130,302.75]
[null,"may",null,54,null,null,54]
[null,"jun",null,null,12,null,12]
[null,"jul",21,{"$nulls":3},21]
[null,"ago",null,null,2.75,null,2.75]
[null,"Total general",50,150,154.5,260,614.5]