{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Resumen","Activos","Pasivos y capital del propietar"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Resumen","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"\"Aasta \" & YEAR(TODAY())-1","v":"Aasta 2018"},{"$f":"\"Aasta \" & YEAR(TODAY())","v":"Aasta 2019"}]
[]
[null,"Resumen de saldo","Año 1","Año 2"]
[null,"Activos totales",{"$f":"Tabla_ActivosActuales[[#Totals],[Año 1]]+Tabla_ActivosFijos[[#Totals],[Año 1]]+Tabla_OtrosActivos[[#Totals],[Año 1]]","v":{"v":9545,"d":"$9,545.00"}},{"$f":"Tabla_ActivosActuales[[#Totals],[Año 2]]+Tabla_ActivosFijos[[#Totals],[Año 2]]+Tabla_OtrosActivos[[#Totals],[Año 2]]","v":{"v":12735,"d":"$12,735.00"}}]
[null,"Pasivos totales y capital del propietario",{"$f":"Tabla_PasivosActuales[[#Totals],[Año 1]]+Tabla_PasivosALargoPlazo[[#Totals],[Año 1]]+Tabla_CapitalDelPropietario[[#Totals],[Año 1]]","v":{"v":8540,"d":"$8,540.00"}},{"$f":"Tabla_PasivosActuales[[#Totals],[Año 2]]+Tabla_PasivosALargoPlazo[[#Totals],[Año 2]]+Tabla_CapitalDelPropietario[[#Totals],[Año 2]]","v":{"v":6227,"d":"$6,227.00"}}]
[null,"Saldo",{"$f":"C5-C6","v":{"v":1005,"d":"$1,005.00"}},{"$f":"D5-D6","v":{"v":6508,"d":"$6,508.00"}}]

{"sheet":"Activos","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"Año_Anterior","v":"Aasta 2018"},{"$f":"Año_Actual","v":"Aasta 2019"}]
[null,"Activos actuales","Año 1","Año 2"]
[null,"Efectivo",{"v":1000,"d":"$1,000.00"},{"v":1700,"d":"$1,700.00"}]
[null,"Inversiones",{"v":1500,"d":"$1,500.00"},{"v":2550,"d":"$2,550.00"}]
[null,"Existencias",{"v":650,"d":"$650.00"},{"v":1250,"d":"$1,250.00"}]
[null,"Cuentas por cobrar",{"v":150,"d":"$150.00"},{"v":230,"d":"$230.00"}]
[null,"Gastos prepagados",{"v":1230,"d":"$1,230.00"},{"v":950,"d":"$950.00"}]
[null,"Otros",{"v":120,"d":"$120.00"},{"v":120,"d":"$120.00"}]
[null,"Activos totales actuales",{"$f":"SUBTOTAL(109,Tabla_ActivosActuales[Año 1])","v":{"v":4650,"d":"$4,650.00"}},{"$f":"SUBTOTAL(109,Tabla_ActivosActuales[Año 2])","v":{"v":6800,"d":"$6,800.00"}}]
[]
[null,"Activo fijos","Año 1","Año 2"]
[null,"Propiedad y equipos",{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"}]
[null,"Mejoras de arrendamiento",{"v":450,"d":"$450.00"},{"v":350,"d":"$350.00"}]
[null,"Capital y otras inversiones",{"v":1250,"d":"$1,250.00"},{"v":1600,"d":"$1,600.00"}]
[null,"Menos depreciación acumulada",{"v":545,"d":"$545.00"},{"v":1295,"d":"$1,295.00"}]
[null,"Total de activo fijos",{"$f":"SUBTOTAL(109,Tabla_ActivosFijos[Año 1])","v":{"v":4745,"d":"$4,745.00"}},{"$f":"SUBTOTAL(109,Tabla_ActivosFijos[Año 2])","v":{"v":5745,"d":"$5,745.00"}}]
[]
[null,"Otros activos","Año 1","Año 2"]
[null,"Fondo de comercio",{"v":150,"d":"$150.00"},{"v":190,"d":"$190.00"}]
[null,"Total de otros activos",{"$f":"SUBTOTAL(109,Tabla_OtrosActivos[Año 1])","v":{"v":150,"d":"$150.00"}},{"$f":"SUBTOTAL(109,Tabla_OtrosActivos[Año 2])","v":{"v":190,"d":"$190.00"}}]

{"sheet":"Pasivos y capital del propietar","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"Año_Anterior","v":"Aasta 2018"},{"$f":"Año_Actual","v":"Aasta 2019"}]
[null,"Pasivos actuales","Año 1","Año 2"]
[null,"Cuentas por pagar",{"v":180,"d":"$180.00"},{"v":252,"d":"$252.00"}]
[null,"Salarios acumulados",{"v":250,"d":"$250.00"},{"v":370,"d":"$370.00"}]
[null,"Compensación acumulada",{"v":240,"d":"$240.00"},{"v":190,"d":"$190.00"}]
[null,"Impuestos sobre la renta por pagar",{"v":120,"d":"$120.00"},{"v":130,"d":"$130.00"}]
[null,"Ingresos no ganados",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Otros",{"v":250,"d":"$250.00"},{"v":235,"d":"$235.00"}]
[null,"Total de pasivos actuales",{"$f":"SUBTOTAL(109,Tabla_PasivosActuales[Año 1])","v":{"v":1040,"d":"$1,040.00"}},{"$f":"SUBTOTAL(109,Tabla_PasivosActuales[Año 2])","v":{"v":1177,"d":"$1,177.00"}}]
[]
[null,"Pasivos a largo plazo","Año 1","Año 2"]
[null,"Hipoteca por pagar",{"v":1500,"d":"$1,500.00"},{"v":1900,"d":"$1,900.00"}]
[null,"Pasivos totales a largo plazo",{"$f":"SUBTOTAL(109,Tabla_PasivosALargoPlazo[Año 1])","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUBTOTAL(109,Tabla_PasivosALargoPlazo[Año 2])","v":{"v":1900,"d":"$1,900.00"}}]
[]
[null,"Capital del propietario","Año 1","Año 2"]
[null,"Capital de inversión",{"v":5500,"d":"$5,500.00"},{"v":2500,"d":"$2,500.00"}]
[null,"Ganancias retenidas acumuladas",{"v":500,"d":"$500.00"},{"v":650,"d":"$650.00"}]
[null,"Capital total del propietario",{"$f":"SUBTOTAL(109,Tabla_CapitalDelPropietario[Año 1])","v":{"v":6000,"d":"$6,000.00"}},{"$f":"SUBTOTAL(109,Tabla_CapitalDelPropietario[Año 2])","v":{"v":3150,"d":"$3,150.00"}}]