{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Inicio","Rueda de Presupuesto","Datos"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":7,"n_cols":1,"rows_kept":7}
["Acerca de la plantilla"]
["Mantenga registro de sus egresos y ahorros mensuales usando esta plantilla"]
["Ingrese los detalles de Egresos en la tabla e Ingresos Mensuales para calcular los Ahorros."]
["El gráfico de anillos que muestra los egresos y ahorros se actualiza automáticamente."]
["Nota:"]
["Se han proporcionado instrucciones adicionales en la columna A en la hoja RUEDA de PRESUPUESTO. Este texto se ha escondido intencionalmente. Para remover el texto, seleccione la columna A, luego seleccione BORRAR. Para mostrar el texto, seleccione la columna, luego cambie el color de la fuente."]
["Para aprender más acerca de la tabla, presione Mayúscula Izquierda y luego F10 dentro de la tabla, seleccione la opción TABLA, y luego seleccione TEXTO ALTERNATIVO."]

{"sheet":"Rueda de Presupuesto","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6],[1,2,4,4]]}
["Cree una Rueda de Presupuesto en esta hoja de cálculo. El título de la hoja de cálculo está en la celda a la derecha y en la punta de la celda D1. Otras instrucciones útiles en cómo usar esta hoja de cálculo está en las celdas en esta columna. Presione flecha abajo para comenzar.","Rueda de Presupuesto",null,"Llene la tabla en esta plantilla. El diagrama graficará sus gastos mensuales en relación con su ingreso mensual. Esto también calculará los porcentajes para mostrarle cuánto ahorrará/ahorró."]
["La etiqueta del Ingreso Mensual está en la celda a la derecha, el gráfico de anillos muestra los egresos y los ahorros en la celda C2, y la etiqueta del Monto de los Ahorros en la celda G2.","Ingreso Mensual","Doughnut chart showing expenses and savings proportion is in this cell.",{"$nulls":3},"Monto de Ahorros"]
["Coloque el Ingreso Mensual en la celda a la derecha. El Monto de Ahorro se calcula automáticamente en la celda G3. La siguiente instrucción está la celda A6.",{"v":5738,"d":"5,738 €"},{"$nulls":4},{"$f":"Savings","v":{"v":2777,"d":"2,777 €"}}]
[{"$nulls":6},"Valor calculado automáticamente"]
[]
["Ingrese detalles en la tabla Egresos comenzando en la celda a la derecha.","Egresos","Categoría","Monto","Frequencia","Monto Mensual","% del Total"]
[null,"Seguro","Transporte",{"v":300,"d":"300 €"},"Cada 6 meses",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"50 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.00871383757406762,"d":"1%"}}]
[null,"Gas","Transporte",{"v":25,"d":"25 €"},"Semanal",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Pago del vehículo","Transporte",{"v":200,"d":"200 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"200 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Hipoteca","Hogar",{"v":1600,"d":"1,600 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"1,600 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.27884280237016384,"d":"28%"}}]
[null,"Cable","Hogar",{"v":60,"d":"60 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Película nocturna","Entretenimiento",{"v":70,"d":"70 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"70 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Zapatos de gimnasia","Misc.",{"v":300,"d":"300 €"},"Anual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"25 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.00435691878703381,"d":"0%"}}]
[null,"Comida del perro","Misc.",{"v":60,"d":"60 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Seguro de la mascota","Misc.",{"v":70,"d":"70 €"},"Anual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"6 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":1.0456605088881143E-3,"d":"0%"}}]
[null,"Víveres","Comida",{"v":100,"d":"100 €"},"Semanal",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"400 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.06971070059254096,"d":"7%"}}]
[null,"Café","Comida",{"v":25,"d":"25 €"},"Semanal",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Implementos de escalada","Entretenimiento",{"v":170,"d":"170 €"},"Anual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"14 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":2.4398745207389336E-3,"d":"0%"}}]
[null,"Membresía del gimnasio","Misc.",{"v":60,"d":"60 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Audífonos","Entretenimiento",{"v":50,"d":"50 €"},"Anual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"4 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":6.9710700592540956E-4,"d":"0%"}}]
[null,"Corte de cabello","Misc.",{"v":70,"d":"70 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"70 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Videojuegos","Entretenimiento",{"v":100,"d":"100 €"},"Mensual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Ropa","Misc.",{"v":500,"d":"500 €"},"Anual",{"$f":"IF(Expenses[[#This Row],[Monto]]>0,IF(Expenses[[#This Row],[Frequencia]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequencia]]=\"Mensual\",Expenses[Monto],IF(Expenses[[#This Row],[Frequencia]]=\"Semanal\",Expenses[[#This Row],[Monto]]*4,IF(Expenses[[#This Row],[Frequencia]]=\"Trimestral\",Expenses[[#This Row],[Monto]]/3,IF(Expenses[[#This Row],[Frequencia]]=\"Cada 6 meses\",Expenses[[#This Row],[Monto]]/6,IF(Expenses[[#This Row],[Frequencia]]=\"Anual\",Expenses[[#This Row],[Monto]]/12,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otra semana\",Expenses[[#This Row],[Monto]]*2,IF(Expenses[[#This Row],[Frequencia]]=\"Cada otro mes\",Expenses[[#This Row],[Monto]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"42 €"}},{"$f":"IF(Expenses[[#This Row],[Monto Mensual]]<>\"\",Expenses[[#This Row],[Monto Mensual]]/Ingreso,\"\")","v":{"v":7.3196235622168E-3,"d":"1%"}}]

{"sheet":"Datos","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["Esta hoja debe permanecer escondida"]
["Categorías","Monto por Categoría","Porcentaje del Total","Frequencia","Ahorros"]
["Hogar",{"$f":"IF(SUMIF(Expenses[Categoría],\"Hogar\",Expenses[Monto Mensual])>0,SUMIF(Expenses[Categoría],\"Hogar\",Expenses[Monto Mensual]),NA())","v":{"v":1660,"d":"1,660 €"}},{"$f":"IF(B3>0,B3/Ingreso,\"\")","v":{"v":0.289299407459045,"d":"29%"}},"Semanal",{"$f":"Ingreso-SUM(Expenses[Monto Mensual])","v":{"v":2777,"d":"2,777 €"}}]
["Entretenimiento",{"$f":"IF(SUMIF(Expenses[Categoría],\"Entretenimiento\",Expenses[Monto Mensual])>0,SUMIF(Expenses[Categoría],\"Entretenimiento\",Expenses[Monto Mensual]),NA())","v":{"v":188,"d":"188 €"}},{"v":0.03276402927849425,"d":"3%"},"Mensual"]
["Transporte",{"$f":"IF(SUMIF(Expenses[Categoría],\"Transporte\",Expenses[Monto Mensual])>0,SUMIF(Expenses[Categoría],\"Transporte\",Expenses[Monto Mensual]),NA())","v":{"v":350,"d":"350 €"}},{"v":0.06099686301847333,"d":"6%"},"Trimestral"]
["Comida",{"$f":"IF(SUMIF(Expenses[Categoría],\"Comida\",Expenses[Monto Mensual])>0,SUMIF(Expenses[Categoría],\"Comida\",Expenses[Monto Mensual]),NA())","v":{"v":500,"d":"500 €"}},{"v":0.08713837574067619,"d":"9%"},"Cada 6 meses"]
["Misc.",{"$f":"IF(SUMIF(Expenses[Categoría],\"Misc.\",Expenses[Monto Mensual])>0,SUMIF(Expenses[Categoría],\"Misc.\",Expenses[Monto Mensual]),NA())","v":{"v":263,"d":"263 €"}},{"v":0.04583478563959568,"d":"5%"},"Anual"]
["Ahorros",{"$f":"IF(E3>0,E3,NA())","v":{"v":2777,"d":"2,777 €"}},{"v":0.4839665388637156,"d":"48%"},"Cada otra semana"]
[{"$nulls":3},"Cada otro mes"]
[null,"TOTAL:",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]