{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Guía","Flujo de efectivo anual","Flujo de efectivo mensual","Resumen mensual","Ingresos","Gastos","Discrecional","Ahorros"],"not_rendered":{"charts":4,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"Guía","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"GUÍA","INGRESOS"]
[null,"FLUJO DE EFECTIVO PERSONAL"]
[null,"Este libro tiene las hojas de cálculo de flujo de efectivo anual, mensual y diario.  Elige el tipo de flujo de efectivo personal que mejor te convenga o úsalos todos para obtener información sobre tu flujo de efectivo personal."]
[]
[null,"Flujo de efectivo anual",null,"Flujo de efectivo mensual",null,"Flujo de efectivo diario"]
[null,"Escribe el monto del flujo de efectivo anual en distintas áreas. Obtén el desglose mensual, la comparación de todos los elementos y, fundamentalmente, las cifras anuales y mensuales del balance final.",null,"Escribe el flujo de efectivo mensual o haz un cálculo de los meses restantes para ver el flujo de efectivo estimado del año para cada mes.",null,"Escribe una cantidad estimada para el flujo de efectivo diario y revisa los totales estimados anuales y mensuales.  Úsalo para hacerte una idea de tus hábitos de gastos diarios en el transcurso de un mes o un año."]

{"sheet":"Flujo de efectivo anual","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":4},"GUÍA","FLUJO DE EFECTIVO ANUAL",null,"FLUJO DE \nEFECTIVO MENSUAL"]
[null,"Flujo de efectivo total hasta la fecha:",null,{"$f":"FlujoDeEfectivoAnualHastaLaFecha","v":{"v":39750,"d":"$39,750.00"}},null,null,"Esta es una estimación anual.  Utiliza esta hoja de cálculo si deseas ver las cantidades anuales con los valores mensuales estimados. Utiliza otras hojas de cálculo para agregar elementos diarios."]
[null,"RESUMEN DE INGRESOS",{"$nulls":3},"RESUMEN DE GASTOS",{"$nulls":3},"RESUMEN DISCRECIONAL",{"$nulls":3},"RESUMEN DE AHORROS"]
[null,"Total anual:",{"$f":"Ingresos!C10","v":{"v":125000,"d":"$125,000.00"}},null,null,"Total anual:",{"$f":"Gastos[[#Totals],[Anual  ]]","v":{"v":49000,"d":"$49,000.00"}},null,null,"Total anual:",{"$f":"Discrecional[[#Totals],[Anual  ]]","v":{"v":13250,"d":"$13,250.00"}},null,null,"Total anual:",{"$f":"Ahorros[[#Totals],[Anual  ]]","v":{"v":23000,"d":"$23,000.00"}}]
[null,"El gráfico circular que muestra ingresos de varias fuentes está en esta celda.",{"$nulls":3},"El gráfico circular que muestra los gastos está en esta celda.",{"$nulls":3},"El gráfico circular que muestra los gastos discrecionales está en esta celda.",{"$nulls":3},"El gráfico circular que muestra ahorros e inversiones está en esta celda."]
[null,"Total mensual:",{"$f":"Ingresos!D10","v":{"v":10416.666666666668,"d":"$10,416.67"}},null,null,"Total mensual:",{"$f":"Gastos[[#Totals],[Mensual ]]","v":{"v":4083.333333333333,"d":"$4,083.33"}},null,null,"Total mensual:",{"$f":"Discrecional[[#Totals],[Mensual ]]","v":{"v":1104.1666666666665,"d":"$1,104.17"}},null,null,"Total mensual:",{"$f":"Ahorros!D9","v":{"v":1916.6666666666667,"d":"$1,916.67"}}]

{"sheet":"Flujo de efectivo mensual","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":5},"GUÍA","FLUJO DE \nEFECTIVO ANUAL","FLUJO DE EFECTIVO MENSUAL","RESUMEN \nMENSUAL"]
[null,"Flujo de efectivo mensual total:",null,{"$f":"FlujoDeEfectivoMensualHastaLaFecha","v":{"v":18380,"d":"$18,380.00"}},null,"NOTA: Para los elementos diarios, haz un cálculo de la cantidad/valor mensual y coloca ese valor en la columna del mes apropiada."]
[null,"Tipo","Descripción","Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic","Total"]
[null,"Ingresos","Salario",{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":45000,"d":"$45,000.00"}}]
[null,"Ingresos","Comisiones/bonificaciones",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":500,"d":"$500.00"},{"v":200,"d":"$200.00"},{"v":0,"d":"$0.00"},{"v":600,"d":"$600.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":2100,"d":"$2,100.00"}}]
[null,"Ingresos","Otro 1",{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":15000,"d":"$15,000.00"}}]
[null,"Ingresos","Otro 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Ingresos","Otro 3",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Ingresos","Otro 4",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Federal/SS/Medicare",{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Gastos","Impuesto estatal sobre la renta",{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":1250,"d":"$1,250.00"}}]
[null,"Gastos","Impuestos/cargos sobre vehículos",{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":100.00000000000001,"d":"$100.00"}}]
[null,"Gastos","Pagos de vehículo",{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":1999.9999999999998,"d":"$2,000.00"}}]
[null,"Gastos","Hipoteca/alquiler",{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Gastos","Seguro",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":150,"d":"$150.00"}}]
[null,"Gastos","Electricidad",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":600,"d":"$600.00"}}]
[null,"Gastos","Gas",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Gastos","Agua",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Gastos","Alcantarillado",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":150,"d":"$150.00"}}]
[null,"Gastos","Residuos",{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":75,"d":"$75.00"}}]
[null,"Gastos","Teléfono",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Gastos","Internet",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Gastos","Primas de vida/discapacidad",{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":750,"d":"$750.00"}}]
[null,"Gastos","Comida",{"v":400,"d":"$400.00"},{"v":500,"d":"$500.00"},{"v":450,"d":"$450.00"},{"v":400,"d":"$400.00"},{"v":450,"d":"$450.00"},{"v":425,"d":"$425.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":2625,"d":"$2,625.00"}}]
[null,"Gastos","Ropa",{"v":50,"d":"$50.00"},{"v":75,"d":"$75.00"},{"v":100,"d":"$100.00"},{"v":75,"d":"$75.00"},{"v":125,"d":"$125.00"},{"v":75,"d":"$75.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":500,"d":"$500.00"}}]
[null,"Gastos","Medicina/Odontología/Radiografías",{"v":50,"d":"$50.00"},{"v":10,"d":"$10.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":20,"d":"$20.00"},{"v":70,"d":"$70.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":200,"d":"$200.00"}}]
[null,"Gastos","Autobús",{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":170,"d":"$170.00"}}]
[null,"Gastos","Otro 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Otro 3",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Otro 4",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Discrecional","Cenas",{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":600,"d":"$600.00"}}]
[null,"Discrecional","Regalos",{"v":25,"d":"$25.00"},{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"v":25,"d":"$25.00"},{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Discrecional","Viajes",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1000,"d":"$1,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1000,"d":"$1,000.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":2000,"d":"$2,000.00"}}]
[null,"Discrecional","Entretenimiento",{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":600,"d":"$600.00"}}]
[null,"Discrecional","Cuidado personal",{"v":15,"d":"$15.00"},{"v":25,"d":"$25.00"},{"v":35,"d":"$35.00"},{"v":15,"d":"$15.00"},{"v":25,"d":"$25.00"},{"v":35,"d":"$35.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":150,"d":"$150.00"}}]
[null,"Discrecional","Compras",{"v":100,"d":"$100.00"},{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"v":175,"d":"$175.00"},{"v":150,"d":"$150.00"},{"v":175,"d":"$175.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":950,"d":"$950.00"}}]
[null,"Discrecional","Beneficencia",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":300,"d":"$300.00"}}]
[null,"Discrecional","Club/membresías",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":150,"d":"$150.00"}}]
[null,"Discrecional","Reformas del hogar",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":2400,"d":"$2,400.00"}}]
[null,"Discrecional","Otro 1",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Discrecional","Otro 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Ahorros","Reservas de efectivo",{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Ahorros","401(k)/Etc.",{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":6000,"d":"$6,000.00"}}]
[null,"Ahorros","Cuenta de ahorros/inversión",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":3000,"d":"$3,000.00"}}]
[null,"Ahorros","Otro 1",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Ahorros","Otro 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(Mensual[[#This Row],[Ene]:[Dic]])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Ene])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Ene])","v":{"v":3692.5,"d":"$3,692.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Feb])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Feb])","v":{"v":3247.5,"d":"$3,247.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Mar])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Mar])","v":{"v":2522.5,"d":"$2,522.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Abr])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Abr])","v":{"v":3427.5,"d":"$3,427.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[May])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[May])","v":{"v":2887.5,"d":"$2,887.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Jun])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Jun])","v":{"v":2602.5,"d":"$2,602.50"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Jul])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Ago])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Ago])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Sep])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Oct])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Nov])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Dic])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Dic])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(Mensual[Tipo],\"Ingresos\",Mensual[Total])-SUMIF(Mensual[Tipo],\"<>Ingresos\",Mensual[Total])","v":{"v":18380,"d":"$18,380.00"}}]

{"sheet":"Resumen mensual","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,1,12]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":3},"GUÍA","FLUJO DE \nEFECTIVO MENSUAL","RESUMEN MENSUAL \n","INGRESOS"]
[null,"Efectivo total disponible:",null,{"$f":"FlujoDeEfectivoDiario","v":{"v":577.8399999999999,"d":"$577.84"}},null,"NOTA: Si deseas agregar elementos diarios a la Tabla, haz una estimación de la cantidad/valor mensual y coloca el valor en la columna del mes apropiada."]
[null,"RESUMEN DIARIO"]
[null,"TOTALES","Diario","Mensual","Anual "]
[null,"Ingresos",{"$f":"SUMIF(Diario[Tipo],$B5,Diario[Diario])","v":{"v":342.47,"d":"$342.47"}},{"$f":"SUMIF(Diario[Tipo],$B5,Diario[Mensual])","v":{"v":10416.795833333334,"d":"$10,416.80"}},{"$f":"SUMIF(Diario[Tipo],$B5,Diario[Anual])","v":{"v":125001.55000000002,"d":"$125,001.55"}}]
[null,"Gastos",{"$f":"SUMIF(Diario[Tipo],$B6,Diario[Diario])","v":{"v":136.05999999999997,"d":"$136.06"}},{"$f":"SUMIF(Diario[Tipo],$B6,Diario[Mensual])","v":{"v":4138.491666666667,"d":"$4,138.49"}},{"$f":"SUMIF(Diario[Tipo],$B6,Diario[Anual])","v":{"v":49661.899999999994,"d":"$49,661.90"}}]
[null,"Discrecional",{"$f":"SUMIF(Diario[Tipo],$B7,Diario[Diario])","v":{"v":36.29,"d":"$36.29"}},{"$f":"SUMIF(Diario[Tipo],$B7,Diario[Mensual])","v":{"v":1103.8208333333334,"d":"$1,103.82"}},{"$f":"SUMIF(Diario[Tipo],$B7,Diario[Anual])","v":{"v":13245.849999999999,"d":"$13,245.85"}}]
[null,"Ahorros",{"$f":"SUMIF(Diario[Tipo],$B8,Diario[Diario])","v":{"v":63.019999999999996,"d":"$63.02"}},{"$f":"SUMIF(Diario[Tipo],$B8,Diario[Mensual])","v":{"v":1916.8583333333333,"d":"$1,916.86"}},{"$f":"SUMIF(Diario[Tipo],$B8,Diario[Anual])","v":{"v":23002.300000000003,"d":"$23,002.30"}}]
[null,"Tipo","Descripción","Diario","Mensual","Anual"]
[null,"Ingresos","Salario",{"v":246.58,"d":"$246.58"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":7500.141666666667,"d":"$7,500.14"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":90001.70000000001,"d":"$90,001.70"}}]
[null,"Ingresos","Comisiones/bonificaciones",{"v":13.7,"d":"$13.70"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Ingresos","Otro 1",{"v":82.19,"d":"$82.19"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":2499.945833333333,"d":"$2,499.95"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":29999.35,"d":"$29,999.35"}}]
[null,"Ingresos","Otro 2",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Ingresos","Otro 3",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Ingresos","Otro 4",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Federal/SS/Medicare",{"v":41.1,"d":"$41.10"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":1250.125,"d":"$1,250.13"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":15001.5,"d":"$15,001.50"}}]
[null,"Gastos","Impuesto estatal sobre la renta",{"v":6.85,"d":"$6.85"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":208.35416666666666,"d":"$208.35"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":2500.25,"d":"$2,500.25"}}]
[null,"Gastos","Impuestos/cargos sobre vehículos",{"v":0.55,"d":"$0.55"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":16.729166666666668,"d":"$16.73"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":200.75000000000003,"d":"$200.75"}}]
[null,"Gastos","Pagos de vehículo",{"v":10.96,"d":"$10.96"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":333.3666666666667,"d":"$333.37"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":4000.4,"d":"$4,000.40"}}]
[null,"Gastos","Hipoteca/alquiler",{"v":41.1,"d":"$41.10"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":1250.125,"d":"$1,250.13"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":15001.5,"d":"$15,001.50"}}]
[null,"Gastos","Seguro",{"v":0.68,"d":"$0.68"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":20.683333333333334,"d":"$20.68"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":248.20000000000002,"d":"$248.20"}}]
[null,"Gastos","Electricidad",{"v":3.29,"d":"$3.29"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Gastos","Gas",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Gastos","Agua",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Gastos","Alcantarillado",{"v":0.82,"d":"$0.82"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Gastos","Residuos",{"v":0.41,"d":"$0.41"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":12.470833333333331,"d":"$12.47"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":149.64999999999998,"d":"$149.65"}}]
[null,"Gastos","Teléfono",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Gastos","Internet",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Gastos","Primas de vida/discapacidad",{"v":4.11,"d":"$4.11"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":125.0125,"d":"$125.01"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":1500.15,"d":"$1,500.15"}}]
[null,"Gastos","Comida",{"v":13.7,"d":"$13.70"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Gastos","Ropa",{"v":3.29,"d":"$3.29"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Gastos","Medicina/Odontología/\nRadiografías",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Gastos","Autobús",{"v":1,"d":"$1.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":30.416666666666668,"d":"$30.42"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":365,"d":"$365.00"}}]
[null,"Gastos","Otro 2",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Otro 3",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Gastos","Otro 4",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Discrecional","Cenas",{"v":3.29,"d":"$3.29"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Discrecional","Regalos",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Discrecional","Viajes",{"v":6.16,"d":"$6.16"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":187.36666666666667,"d":"$187.37"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":2248.4,"d":"$2,248.40"}}]
[null,"Discrecional","Entretenimiento",{"v":3.29,"d":"$3.29"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Discrecional","Cuidado personal",{"v":0.82,"d":"$0.82"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Discrecional","Compras",{"v":5.48,"d":"$5.48"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":166.68333333333334,"d":"$166.68"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":2000.2,"d":"$2,000.20"}}]
[null,"Discrecional","Beneficencia",{"v":1.64,"d":"$1.64"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Discrecional","Club/membresías",{"v":0.82,"d":"$0.82"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Discrecional","Reformas del hogar",{"v":13.15,"d":"$13.15"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":399.9791666666667,"d":"$399.98"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":4799.75,"d":"$4,799.75"}}]
[null,"Discrecional","Otro 1",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Discrecional","Otro 2",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Ahorros","Reservas de efectivo",{"v":13.7,"d":"$13.70"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Ahorros","401(k)/Etc.",{"v":32.88,"d":"$32.88"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":1000.1,"d":"$1,000.10"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":12001.2,"d":"$12,001.20"}}]
[null,"Ahorros","Cuenta de ahorros/inversión",{"v":16.44,"d":"$16.44"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":500.05,"d":"$500.05"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":6000.6,"d":"$6,000.60"}}]
[null,"Ahorros","Otro 1",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Ahorros","Otro 2",{"v":0,"d":"$0.00"},{"$f":"Diario[[#This Row],[Anual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"Diario[[#This Row],[Diario]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,{"$f":"SUMIF(Diario[Tipo],\"Ingresos\",Diario[Diario])-SUMIF(Diario[Tipo],\"<>Ingresos\",Diario[Diario])","v":{"v":107.10000000000014,"d":"$107.10"}},{"$f":"SUMIF(Diario[Tipo],\"Ingresos\",Diario[Mensual])-SUMIF(Diario[Tipo],\"<>Ingresos\",Diario[Mensual])","v":{"v":3257.625,"d":"$3,257.63"}},{"$f":"SUMIF(Diario[Tipo],\"Ingresos\",Diario[Anual])-SUMIF(Diario[Tipo],\"<>Ingresos\",Diario[Anual])","v":{"v":39091.500000000015,"d":"$39,091.50"}}]

{"sheet":"Ingresos","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":3},"GUÍA","RESUMEN MENSUAL","INGRESOS","GASTOS"]
[null,"Flujo de efectivo total hasta la fecha:",null,{"$f":"FlujoDeEfectivoAnualHastaLaFecha","v":{"v":39750,"d":"$39,750.00"}},null,"Esta es una estimación anual.  Utiliza esta hoja de cálculo si deseas ver las cantidades anuales con los valores mensuales estimados.\nSi deseas agregar elementos diarios a las Tablas, haz un cálculo de la cantidad/valor anual y coloca el valor en la columna Anual."]
[null,"Ingresos","Anual  ","Mensual "]
[null,"Salario",{"v":90000,"d":"$90,000.00"},{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Comisiones/bonificaciones",{"v":5000,"d":"$5,000.00"},{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}}]
[null,"Otro 1",{"v":30000,"d":"$30,000.00"},{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Otro 2",null,{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Otro 3",null,{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Otro 4",null,{"$f":"Ingresos[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Ingresos[[Anual  ]])","v":{"v":125000,"d":"$125,000.00"}},{"$f":"SUBTOTAL(109,Ingresos[[Mensual ]])","v":{"v":10416.666666666668,"d":"$10,416.67"}}]

{"sheet":"Gastos","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":3},"GUÍA","INGRESOS","GASTOS","DISCRECIONAL"]
[null,"Flujo de efectivo total hasta la fecha:",null,{"$f":"FlujoDeEfectivoAnualHastaLaFecha","v":{"v":39750,"d":"$39,750.00"}},null,"Esta es una estimación anual.  Utiliza esta hoja de cálculo si deseas ver las cantidades anuales con los valores mensuales estimados.\nSi deseas agregar elementos diarios a las Tablas, haz un cálculo de la cantidad/valor anual y coloca el valor en la columna Anual."]
[null,"Gastos","Anual  ","Mensual "]
[null,"Federal/SS/Medicare",{"v":15000,"d":"$15,000.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":1250,"d":"$1,250.00"}}]
[null,"Impuesto estatal sobre la renta",{"v":2500,"d":"$2,500.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":208.33333333333334,"d":"$208.33"}}]
[null,"Impuestos/cargos sobre vehículos",{"v":200,"d":"$200.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":16.666666666666668,"d":"$16.67"}}]
[null,"Pagos de vehículo",{"v":4000,"d":"$4,000.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":333.3333333333333,"d":"$333.33"}}]
[null,"Hipoteca/alquiler",{"v":15000,"d":"$15,000.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":1250,"d":"$1,250.00"}}]
[null,"Seguro",{"v":250,"d":"$250.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":20.833333333333332,"d":"$20.83"}}]
[null,"Electricidad",{"v":1200,"d":"$1,200.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":100,"d":"$100.00"}}]
[null,"Gas",{"v":600,"d":"$600.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Agua/alcantarillado",{"v":600,"d":"$600.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Residuos",{"v":150,"d":"$150.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":12.5,"d":"$12.50"}}]
[null,"Teléfono",{"v":600,"d":"$600.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Internet",{"v":600,"d":"$600.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Primas de vida/discapacidad",{"v":1500,"d":"$1,500.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":125,"d":"$125.00"}}]
[null,"Comida",{"v":5000,"d":"$5,000.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}}]
[null,"Ropa",{"v":1200,"d":"$1,200.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":100,"d":"$100.00"}}]
[null,"Medicina/Odontología/Radiografías",{"v":600,"d":"$600.00"},{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Otro 1",null,{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Otro 2",null,{"$f":"Gastos[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Gastos[[Anual  ]])","v":{"v":49000,"d":"$49,000.00"}},{"$f":"SUBTOTAL(109,Gastos[[Mensual ]])","v":{"v":4083.333333333333,"d":"$4,083.33"}}]

{"sheet":"Discrecional","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":3},"GUÍA","GASTOS","DISCRECIONAL","AHORROS"]
[null,"Flujo de efectivo total hasta la fecha:",null,{"$f":"FlujoDeEfectivoAnualHastaLaFecha","v":{"v":39750,"d":"$39,750.00"}},null,"Esta es una estimación anual.  Utiliza esta hoja de cálculo si deseas ver las cantidades anuales con los valores mensuales estimados.\nSi deseas agregar elementos diarios a las Tablas, haz un cálculo de la cantidad/valor anual y coloca el valor en la columna Anual."]
[null,"Gastos discrecionales","Anual  ","Mensual "]
[null,"Cenas",{"v":1200,"d":"$1,200.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":100,"d":"$100.00"}}]
[null,"Regalos",{"v":600,"d":"$600.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Viajes",{"v":2250,"d":"$2,250.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":187.5,"d":"$187.50"}}]
[null,"Entretenimiento",{"v":1200,"d":"$1,200.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":100,"d":"$100.00"}}]
[null,"Cuidado personal",{"v":300,"d":"$300.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":25,"d":"$25.00"}}]
[null,"Compras",{"v":2000,"d":"$2,000.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":166.66666666666666,"d":"$166.67"}}]
[null,"Beneficencia",{"v":600,"d":"$600.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[null,"Club/membresías",{"v":300,"d":"$300.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":25,"d":"$25.00"}}]
[null,"Reformas del hogar",{"v":4800,"d":"$4,800.00"},{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":400,"d":"$400.00"}}]
[null,"Otro 1",null,{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Otro 2",null,{"$f":"Discrecional[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Discrecional[[Anual  ]])","v":{"v":13250,"d":"$13,250.00"}},{"$f":"SUBTOTAL(109,Discrecional[[Mensual ]])","v":{"v":1104.1666666666665,"d":"$1,104.17"}}]

{"sheet":"Ahorros","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUJO DE EFECTIVO PERSONAL",{"$nulls":3},"GUÍA","DISCRECIONAL","AHORROS"]
[null,"Flujo de efectivo total hasta la fecha:",null,{"$f":"FlujoDeEfectivoAnualHastaLaFecha","v":{"v":39750,"d":"$39,750.00"}},null,"Esta es una estimación anual.  Utiliza esta hoja de cálculo si deseas ver las cantidades anuales con los valores mensuales estimados.\nSi deseas agregar elementos diarios a las Tablas, haz un cálculo de la cantidad/valor anual y coloca el valor en la columna Anual."]
[null,"Ahorros","Anual  ","Mensual "]
[null,"Reservas de efectivo",{"v":5000,"d":"$5,000.00"},{"$f":"Ahorros[[#This Row],[Anual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}}]
[null,"401(k)/Etc.",{"v":12000,"d":"$12,000.00"},{"$f":"Ahorros[[#This Row],[Anual  ]]/12","v":{"v":1000,"d":"$1,000.00"}}]
[null,"Ahorros/inversión",{"v":6000,"d":"$6,000.00"},{"$f":"Ahorros[[#This Row],[Anual  ]]/12","v":{"v":500,"d":"$500.00"}}]
[null,"Otro 1",null,{"$f":"Ahorros[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Otro 2",null,{"$f":"Ahorros[[#This Row],[Anual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Ahorros[[Anual  ]])","v":{"v":23000,"d":"$23,000.00"}},{"$f":"SUBTOTAL(109,Ahorros[[Mensual ]])","v":{"v":1916.6666666666667,"d":"$1,916.67"}}]