{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contabilidad Mensual","Detalle Gastos","Previsión G.I.","Resumen y Balance","Estadísticas","Cuenta Ahorro"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contabilidad Mensual","index":0,"n_rows":114,"n_cols":15,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"                                                         CONTABILIDAD MENSUAL"]
[null,null,"TABLA  1","AÑO 2013",null,null,null,"                                          "]
[]
[null,null,"MES","SALDO al 30/31",null,"                      ","INGRESOS","CONCEPTO","INGRESOS",null,"SALDO",null,"GASTOS","CONCEPTO","BALANCE"]
[null,null,null,"del mes anterior",null,null,null,"Ingresos","Totales",null,"Mensual",null,"Totales","Gastos","Ahorro"]
[]
[null,null,null,"Diciembre",null,"1.",1123,"Ej: Nómina Diciembre.",null,null,null,null,null,"Ej: Extra en reparación del coche"]
[null,null,"ENERO",1289,null,"2.",6.87,"Ej: Intereses trimestrales a favor",{"$f":"IF(SUM(G7:G9),SUM(G7:G9),\"\")","v":1129.8699999999999},null,{"$f":"IFERROR(D8+I8,\"\")","v":2418.87},null,{"$f":"IFERROR(D12-K8,\"\")","v":-1039.8699999999999},"Ej: Gastos maturales de Enero",{"$f":"IFERROR(D12-D8,\"\")","v":90}]
[null,null,null,null,null,"3."]
[]
[null,null,null,"Enero",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"FEBRERO",1379,null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G11:G13),SUM(G11:G13),\"\")","v":""},null,{"$f":"IFERROR(D12+I12,\"\")","v":""},null,{"$f":"IFERROR(D16-K12,\"\")","v":""},"Introducir",{"$f":"IFERROR(D16-D12,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Febrero",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"MARZO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G15:G17),SUM(G15:G17),\"\")","v":""},null,{"$f":"IFERROR(D16+I16,\"\")","v":""},null,{"$f":"IFERROR(D20-K16,\"\")","v":""},"Introducir",{"$f":"IFERROR(D20-D16,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Marzo",null,"1.","Introducir","introducir",null,null,null,null,null,"Introducir"]
[null,null,"ABRIL","¿ ?",null,"2.","Introducir","introducir",{"$f":"IF(SUM(G19:G21),SUM(G19:G21),\"\")","v":""},null,{"$f":"IFERROR(D20+I20,\"\")","v":""},null,{"$f":"IFERROR(D24-K20,\"\")","v":""},"Introducir",{"$f":"IFERROR(D24-D20,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Abril",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"MAYO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G23:G25),SUM(G23:G25),\"\")","v":""},null,{"$f":"IFERROR(D24+I24,\"\")","v":""},null,{"$f":"IFERROR(D28-K24,\"\")","v":""},"Introducir",{"$f":"IFERROR(D28-D24,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Mayo",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"JUNIO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G27:G29),SUM(G27:G29),\"\")","v":""},null,{"$f":"IFERROR(D28+I28,\"\")","v":""},null,{"$f":"IFERROR(D32-K28,\"\")","v":""},"Introducir",{"$f":"IFERROR(D32-D28,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Junio",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"JULIO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G31:G33),SUM(G31:G33),\"\")","v":""},null,{"$f":"IFERROR(D32+I32,\"\")","v":""},null,{"$f":"IFERROR(D36-K32,\"\")","v":""},"Introducir",{"$f":"IFERROR(D36-D32,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Julio",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"AGOSTO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G35:G37),SUM(G35:G37),\"\")","v":""},null,{"$f":"IFERROR(D36+I36,\"\")","v":""},null,{"$f":"IFERROR(D40-K36,\"\")","v":""},"Introducir",{"$f":"IFERROR(D40-D36,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Agosto",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"SEPTIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G39:G41),SUM(G39:G41),\"\")","v":""},null,{"$f":"IFERROR(D40+I40,\"\")","v":""},null,{"$f":"IFERROR(D44-K40,\"\")","v":""},"Introducir",{"$f":"IFERROR(D44-D40,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Septiembre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"OCTUBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G43:G45),SUM(G43:G45),\"\")","v":""},null,{"$f":"IFERROR(D44+I44,\"\")","v":""},null,{"$f":"IFERROR(D48-K44,\"\")","v":""},"Introducir",{"$f":"IFERROR(D48-D44,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Octubre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"NOVIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G47:G49),SUM(G47:G49),\"\")","v":""},null,{"$f":"IFERROR(D48+I48,\"\")","v":""},null,{"$f":"IFERROR(D52-K48,\"\")","v":""},"Introducir",{"$f":"IFERROR(D52-D48,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Noviembre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"DICIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G51:G53),SUM(G51:G53),\"\")","v":""},null,{"$f":"IFERROR(D52+I52,\"\")","v":""},null,{"$f":"IFERROR(D60-K52,\"\")","v":""},"Introducir",{"$f":"IFERROR(D60-D52,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,"TABLA 2","AÑO 2014"]
[null,null,"MES","SALDO al 30/31",null,"                      ","INGRESOS","CONCEPTO","TOTAL",null,"SALDO",null,"GASTOS","CONCEPTO","BALANCE"]
[null,null,null,"del mes anterior",null,null,null,"Ingresos","Ingresos",null,"Mensual",null,null,"Gasto","Mensual"]
[]
[null,null,null,"Diciembre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"ENERO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G59:G61),SUM(G59:G61),\"\")","v":""},null,{"$f":"IFERROR(D60+I60,\"\")","v":""},null,{"$f":"IFERROR(D64-K60,\"\")","v":""},"Introducir",{"$f":"IFERROR(D64-D60,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Enero",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"FEBRERO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G63:G65),SUM(G63:G65),\"\")","v":""},null,{"$f":"IFERROR(D64+I64,\"\")","v":""},null,{"$f":"IFERROR(D68-K64,\"\")","v":""},"Introducir",{"$f":"IFERROR(D68-D64,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Febrero",null,"1.","introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"MARZO","¿ ?",null,"2.","introducir","Introducir",{"$f":"IF(SUM(G67:G69),SUM(G67:G69),\"\")","v":""},null,{"$f":"IFERROR(D68+I68,\"\")","v":""},null,{"$f":"IFERROR(D72-K68,\"\")","v":""},"Introducir",{"$f":"IFERROR(D72-D68,\"\")","v":""}]
[null,null,null,null,null,"3.","introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Marzo",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"ABRIL","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G71:G73),SUM(G71:G73),\"\")","v":""},null,{"$f":"IFERROR(D72+I72,\"\")","v":""},null,{"$f":"IFERROR(D76-K72,\"\")","v":""},"Introducir",{"$f":"IFERROR(D76-D72,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Abril",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"MAYO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G75:G77),SUM(G75:G77),\"\")","v":""},null,{"$f":"IFERROR(D76+I76,\"\")","v":""},null,{"$f":"IFERROR(D80-K76,\"\")","v":""},"Introducir",{"$f":"IFERROR(D80-D76,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Mayo",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"JUNIO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G79:G81),SUM(G79:G81),\"\")","v":""},null,{"$f":"IFERROR(D80+I80,\"\")","v":""},null,{"$f":"IFERROR(D84-K80,\"\")","v":""},"Introducir",{"$f":"IFERROR(D84-D80,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Junio",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"JULIO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G83:G85),SUM(G83:G85),\"\")","v":""},null,{"$f":"IFERROR(D84+I84,\"\")","v":""},null,{"$f":"IFERROR(D88-K84,\"\")","v":""},"Introducir",{"$f":"IFERROR(D88-D84,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Julio",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"AGOSTO","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G87:G89),SUM(G87:G89),\"\")","v":""},null,{"$f":"IFERROR(D88+I88,\"\")","v":""},null,{"$f":"IFERROR(D92-K88,\"\")","v":""},"Introducir",{"$f":"IFERROR(D92-D88,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Agosto",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"SEPTIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G91:G93),SUM(G91:G93),\"\")","v":""},null,{"$f":"IFERROR(D92+I92,\"\")","v":""},null,{"$f":"IFERROR(D96-K92,\"\")","v":""},"Introducir",{"$f":"IFERROR(D96-D92,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Septiembre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"OCTUBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G95:G97),SUM(G95:G97),\"\")","v":""},null,{"$f":"IFERROR(D96+I96,\"\")","v":""},null,{"$f":"IFERROR(D100-K96,\"\")","v":""},"Introducir",{"$f":"IFERROR(D100-D96,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Octubre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"NOVIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G99:G101),SUM(G99:G101),\"\")","v":""},null,{"$f":"IFERROR(D100+I100,\"\")","v":""},null,{"$f":"IFERROR(D104-K100,\"\")","v":""},"Introducir",{"$f":"IFERROR(D104-D100,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,null,"Noviembre",null,"1.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[null,null,"DICIEMBRE","¿ ?",null,"2.","Introducir","Introducir",{"$f":"IF(SUM(G103:G105),SUM(G103:G105),\"\")","v":""},null,{"$f":"IFERROR(D104+I104,\"\")","v":""},null,{"$f":"IFERROR(D112-K104,\"\")","v":""},"Introducir",{"$f":"IFERROR(D112-D104,\"\")","v":""}]
[null,null,null,null,null,"3.","Introducir","Introducir",null,null,null,null,null,"Introducir"]
[]
[null,null,"Año Siguiente"]
[null,null,"MES","SALDO al 30/31"]
[null,null,null,"del mes anterior"]
[]
[null,null,null,"Diciembre"]
[null,null,"ENERO","¿ ?",null,null,"(Edición Manual)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"        contafacil2013.wordpress.com"]

{"sheet":"Detalle Gastos","index":1,"n_rows":117,"n_cols":21,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"                                               DETALLE DE GASTOS"]
[null,null,1,"AÑO 2013",null,null,null,null,"                              "]
[null,null,null,null,null,null,null,null,null,"                               MENSUALIDADES",null,null,null,null,null,null,null,null," MEDIA","%","TOTAL "]
[null,null,null,"CONCEPTOS",null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC.",null,"MENSUAL","TOTAL","ANUAL"]
[]
[null,null,"1.","Ej: Recibo Agua",null,67.87,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F6:Q6),\"\")","v":67.87},{"$f":" IFERROR((U6/U57),\"\")","v":0.18667143407228121},{"$f":"IF(SUM(F6:Q6),SUM(F6:Q6),\"\")","v":67.87}]
[]
[null,null,"2.","Ej: Recibo de Luz",null,91.13,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F8:Q8),\"\")","v":91.13},{"$f":" IFERROR((U8/U57),\"\")","v":0.2506463501842785},{"$f":"IF(SUM(F8:Q8),SUM(F8:Q8),\"\")","v":91.13}]
[]
[null,null,"3.","Ej: Telefonía",null,36.78,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F10:Q10),\"\")","v":36.78},{"$f":" IFERROR((U10/U57),\"\")","v":0.10116067990538533},{"$f":"IF(SUM(F10:Q10),SUM(F10:Q10),\"\")","v":36.78}]
[]
[null,null,"4.","Ej: Gas ",null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F12:Q12),\"\")","v":0},{"$f":" IFERROR((U12/U57),\"\")","v":""},""]
[]
[null,null,"5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F14:Q14),\"\")","v":""},{"$f":" IFERROR((U14/U57),\"\")","v":""},""]
[]
[null,null,"6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F16:Q16),\"\")","v":""},{"$f":" IFERROR((U16/U57),\"\")","v":""},""]
[]
[null,null,"7.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F18:Q18),\"\")","v":""},{"$f":" IFERROR((U18/U57),\"\")","v":""},""]
[]
[null,null,"8.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F20:Q20),\"\")","v":""},{"$f":" IFERROR((U20/U57),\"\")","v":""},""]
[]
[null,null,"9.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F22:Q22),\"\")","v":""},{"$f":" IFERROR((U22/U57),\"\")","v":""},""]
[]
[null,null,"10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F24:Q24),\"\")","v":""},{"$f":" IFERROR((U24/U57),\"\")","v":""},""]
[]
[null,null,"11.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F26:Q26),\"\")","v":""},{"$f":" IFERROR((U26/U57),\"\")","v":""},""]
[]
[null,null,"12.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F28:Q28),\"\")","v":""},{"$f":" IFERROR((U28/U57),\"\")","v":""},""]
[]
[null,null,"13.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F30:Q30),\"\")","v":""},{"$f":" IFERROR((U30/U57),\"\")","v":""},""]
[]
[null,null,"14.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F32:Q32),\"\")","v":""},{"$f":" IFERROR((U32/U57),\"\")","v":""},""]
[]
[null,null,"15.","TOTAL GTOS. EXTRA",null,{"$f":"IF(SUM(F37:F55),SUM(F37:F55),\"\")","v":167.8},{"$f":"IF(SUM(G37:G55),SUM(G37:G55),\"\")","v":""},"","","","","","","","","","",null,{"$f":"IFERROR(AVERAGE(F34:Q34),\"\")","v":167.8},{"$f":" IFERROR((U34/U57),\"\")","v":0.46152153583805489},{"$f":"IF(SUM(F34:Q34),SUM(F34:Q34),\"\")","v":167.8}]
[]
[null,null,null,"TIPOS DE GASTO"]
[null,null,"1.","Ej: Compra música",null,19,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F37:Q37),\"\")","v":19},{"$f":" IFERROR((U37/U57),\"\")","v":5.2258100005500845E-2},{"$f":"IF(SUM(F37:Q37),SUM(F37:Q37),\"\")","v":19}]
[]
[null,null,"2.","Ej: Ropa",null,42.8,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F39:Q39),\"\")","v":42.8},{"$f":" IFERROR((U39/U57),\"\")","v":0.11771824632818084},{"$f":"IF(SUM(F39:Q39),SUM(F39:Q39),\"\")","v":42.8}]
[]
[null,null,"3.","Ej: Ocio",null,30,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F41:Q41),\"\")","v":30},{"$f":" IFERROR((U41/U57),\"\")","v":8.2512789482369758E-2},30]
[]
[null,null,"4.","Ej: Reparaciones",null,76,null,null,null,null,null,null,null,null,null,null,null,null,76,{"$f":" IFERROR((U43/U57),\"\")","v":0.20903240002200338},76]
[]
[null,null,"5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U45/U57),\"\")","v":""},""]
[]
[null,null,"6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U47/U57),\"\")","v":""},""]
[]
[null,null,"7.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U49/U57),\"\")","v":""},""]
[]
[null,null,"8.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U51/U57),\"\")","v":""},""]
[]
[null,null,"9.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U53/U57),\"\")","v":""},""]
[]
[null,null,"10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":" IFERROR((U55/U57),\"\")","v":""},""]
[]
[null,null,"                                TOTAL GASTOS",null,null,{"$f":"IF(SUM(F6:F34),SUM(F6:F34),\"\")","v":363.58000000000004},{"$f":"IF(SUM(G6:G34),SUM(G6:G34),\"\")","v":""},"","","","","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F57:Q57,\">0\"),\"\")","v":363.58000000000004},null,{"$f":"IF(SUM(U6:U34),SUM(U6:U34),\"\")","v":363.58000000000004}]
[]
[]
[null,null,2,"AÑO 2014"]
[null,null,null,null,null,null,null,null,null,"                         MENSUALIDADES",null,null,null,null,null,null,null,null," MEDIA","%","TOTAL "]
[null,null,null,"CONCEPTOS",null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC.",null,"MENSUAL","TOTAL","ANUAL"]
[]
[null,null,"1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F64:Q64),\"\")","v":""},{"$f":" IFERROR((U64/U115),\"\")","v":""},{"$f":"IF(SUM(F64:Q64),SUM(F64:Q64),\"\")","v":""}]
[]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F66:Q66),\"\")","v":""},{"$f":" IFERROR((U66/U115),\"\")","v":""},{"$f":"IF(SUM(F66:Q66),SUM(F66:Q66),\"\")","v":""}]
[]
[null,null,"3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F68:Q68),\"\")","v":""},{"$f":" IFERROR((U68/U115),\"\")","v":""},""]
[]
[null,null,"4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F70:Q70),\"\")","v":""},{"$f":" IFERROR((U70/U115),\"\")","v":""},""]
[]
[null,null,"5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F72:Q72),\"\")","v":""},{"$f":" IFERROR((U72/U115),\"\")","v":""},""]
[]
[null,null,"6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F74:Q74),\"\")","v":""},{"$f":" IFERROR((U74/U115),\"\")","v":""},""]
[]
[null,null,"7.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F76:Q76),\"\")","v":""},{"$f":" IFERROR((U76/U115),\"\")","v":""},""]
[]
[null,null,"8.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F78:Q78),\"\")","v":""},{"$f":" IFERROR((U78/U115),\"\")","v":""},""]
[]
[null,null,"9.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F80:Q80),\"\")","v":""},{"$f":" IFERROR((U80/U115),\"\")","v":""},""]
[]
[null,null,"10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F82:Q82),\"\")","v":""},{"$f":" IFERROR((U82/U115),\"\")","v":""},""]
[]
[null,null,"11.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F84:Q84),\"\")","v":""},{"$f":" IFERROR((U84/U115),\"\")","v":""},""]
[]
[null,null,"12.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F86:Q86),\"\")","v":""},{"$f":" IFERROR((U86/U115),\"\")","v":""},""]
[]
[null,null,"13.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F88:Q88),\"\")","v":""},{"$f":" IFERROR((U88/U115),\"\")","v":""},""]
[]
[null,null,"14.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F90:Q90),\"\")","v":""},{"$f":" IFERROR((U90/U115),\"\")","v":""},""]
[]
[null,null,"15.","TOTAL GTOS. EXTRA",null,{"$f":"IF(SUM(F95:F113),SUM(F95:F113),\"\")","v":""},{"$f":"IF(SUM(G95:G113),SUM(G95:G113),\"\")","v":""},"","","","","","","","","","",null,{"$f":"IFERROR(AVERAGE(F92:Q92),\"\")","v":""},{"$f":" IFERROR((U92/U115),\"\")","v":""},{"$f":"IF(SUM(F92:Q92),SUM(F92:Q92),\"\")","v":""}]
[]
[null,null,null,"TIPOS DE GASTO"]
[null,null,"1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F95:Q95),\"\")","v":""},{"$f":" IFERROR((U95/U115),\"\")","v":""},{"$f":"IF(SUM(F95:Q95),SUM(F95:Q95),\"\")","v":""}]
[]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F97:Q97),\"\")","v":""},{"$f":" IFERROR((U97/U115),\"\")","v":""},{"$f":"IF(SUM(F97:Q97),SUM(F97:Q97),\"\")","v":""}]
[]
[null,null,"3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F99:Q99),\"\")","v":""},{"$f":" IFERROR((U99/U115),\"\")","v":""},{"$f":"IF(SUM(F99:Q99),SUM(F99:Q99),\"\")","v":""}]
[]
[null,null,"4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F101:Q101),\"\")","v":""},{"$f":" IFERROR((U101/U115),\"\")","v":""},{"$f":"IF(SUM(F101:Q101),SUM(F101:Q101),\"\")","v":""}]
[]
[null,null,"5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F103:Q103),\"\")","v":""},{"$f":" IFERROR((U103/U115),\"\")","v":""},{"$f":"IF(SUM(F103:Q103),SUM(F103:Q103),\"\")","v":""}]
[]
[null,null,"6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F105:Q105),\"\")","v":""},{"$f":" IFERROR((U105/U115),\"\")","v":""},{"$f":"IF(SUM(F105:Q105),SUM(F105:Q105),\"\")","v":""}]
[]
[null,null,"7.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F107:Q107),\"\")","v":""},{"$f":" IFERROR((U107/U115),\"\")","v":""},{"$f":"IF(SUM(F107:Q107),SUM(F107:Q107),\"\")","v":""}]
[]
[null,null,"8.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F109:Q109),\"\")","v":""},{"$f":" IFERROR((U109/U115),\"\")","v":""},{"$f":"IF(SUM(F109:Q109),SUM(F109:Q109),\"\")","v":""}]
[]
[null,null,"9.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F111:Q111),\"\")","v":""},{"$f":" IFERROR((U111/U115),\"\")","v":""},{"$f":"IF(SUM(F111:Q111),SUM(F111:Q111),\"\")","v":""}]
[]
[null,null,"10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F113:Q113),\"\")","v":""},{"$f":" IFERROR((U113/U115),\"\")","v":""},{"$f":"IF(SUM(F113:Q113),SUM(F113:Q113),\"\")","v":""}]
[]
[null,null,"                                TOTAL GASTOS",null,null,{"$f":"IF(SUM(F64:F92),SUM(F64:F92),\"\")","v":""},{"$f":"IF(SUM(G64:G92),SUM(G64:G92),\"\")","v":""},"","","","","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F115:Q115,\">0\"),\"\")","v":""},null,{"$f":"IF(SUM(U64:U92),SUM(U64:U92),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                                contafacil2013.wordpress.com"]

{"sheet":"Previsión G.I.","index":2,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"                                                             ","                                                 ","                                                    PREVISIÓN DE GASTOS E INGRESOS"]
[null,null,null,null,"AÑO 2013",null,null,null,"                                                             "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GASTOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"                                           MENSUALIDADES"]
[null,null,null,null,"CONCEPTOS",null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC."]
[]
[null,null,"1.",null,"Ej: Recibo Agua",null,null,null,60]
[]
[null,null,"2.",null,"Ej: Recibo de Luz",null,null,null,95]
[]
[null,null,"3.",null,"Ej: Telefonía",null,null,null,30]
[]
[null,null,"4.",null,"Ej: Gas",null,null,null,0]
[]
[null,null,"5.",null,"Ej: Comida mes",null,null,null,760]
[]
[null,null,"6.",null,null,null,null,10]
[]
[null,null,"7."]
[]
[null,null,"8."]
[]
[null,null,"9."]
[]
[null,null,"10."]
[]
[null,null,"11."]
[]
[null,null,"12."]
[]
[null,null,"13."]
[]
[null,null,"14."]
[]
[null,null,"15.",null,"GASTOS EXTRA",null,null,null,50]
[]
[null,null,"                                              GASTOS MENSUALES",null,null,null,null,null,{"$f":"IF(SUM(I9:I37),SUM(I9:I37),\"\")","v":995},{"$f":"IF(SUM(J9:J37),SUM(J9:J37),\"\")","v":""},{"$f":"IF(SUM(K9:K37),SUM(K9:K37),\"\")","v":""},{"$f":"IF(SUM(L9:L37),SUM(L9:L37),\"\")","v":""},{"$f":"IF(SUM(M9:M37),SUM(M9:M37),\"\")","v":""},{"$f":"IF(SUM(N9:N37),SUM(N9:N37),\"\")","v":""},"","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGRESOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"                                           MENSUALIDADES"]
[null,null,null,null,"CONCEPTOS",null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC."]
[]
[null,null,"1.",null,"Nómina",null,null,null,1100]
[]
[null,null,"2."]
[]
[null,null,"3."]
[]
[null,null,"                                             INGRESOS MENSUALES",null,null,null,null,null,{"$f":"IF(SUM(I46:I50),SUM(I46:I50),\"\")","v":1100},{"$f":"IF(SUM(J46:J50),SUM(J46:J50),\"\")","v":""},"",{"$f":"IF(SUM(L46:L50),SUM(L46:L50),\"\")","v":""},"","","","","",{"$f":"IF(SUM(R46:R50),SUM(R46:R50),\"\")","v":""},"",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BALANCE"]
[null,null,null,null,"PREVISIÓN"]
[null,null,"                                                ",null,"INGRESOS - GASTOS",null,null,null,{"$f":"IFERROR(I52-I39,\"\")","v":105},{"$f":"IFERROR(J52-J39,\"\")","v":""},"",{"$f":"IFERROR(L52-L39,\"\")","v":""},"",{"$f":"IFERROR(N52-N39,\"\")","v":""},"","","",{"$f":"IFERROR(R52-R39,\"\")","v":""},"",{"$f":"IFERROR(T52-T39,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                TOTAL  ANUAL :",null,{"$f":"IF(SUM(I56:T56),SUM(I56:T56),\"\")","v":105}]
[]
[null,null,"                                                  CONTABILIDAD REAL"]
[null,null,"                                         ",null,"Desfase de Previsión %",null,null,null,{"$f":" IFERROR((I56-I63)/ABS(I63),\"\")","v":0.16666666666666666},"","","","","","","","","","",""]
[]
[null,null,"                                                INGRESOS - GASTOS",null,"INGRESOS - GASTOS",null,null,null,{"$f":"IF(I56=\"\",\"\",'Resumen y Balance'!F18)","v":90},{"$f":"IF(J56=\"\",\"\",'Resumen y Balance'!G18)","v":""},{"$f":"IF(K56=\"\",\"\",'Resumen y Balance'!H18)","v":""},{"$f":"IF(L56=\"\",\"\",'Resumen y Balance'!I18)","v":""},{"$f":"IF(M56=\"\",\"\",'Resumen y Balance'!J18)","v":""},{"$f":"IF(N56=\"\",\"\",'Resumen y Balance'!K18)","v":""},{"$f":"IF(O56=\"\",\"\",'Resumen y Balance'!L18)","v":""},{"$f":"IF(P56=\"\",\"\",'Resumen y Balance'!M18)","v":""},{"$f":"IF(Q56=\"\",\"\",'Resumen y Balance'!N18)","v":""},{"$f":"IF(R56=\"\",\"\",'Resumen y Balance'!O18)","v":""},{"$f":"IF(S56=\"\",\"\",'Resumen y Balance'!P18)","v":""},{"$f":"IF(T56=\"\",\"\",'Resumen y Balance'!Q18)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                TOTAL  ANUAL :",null,{"$f":"IF(SUM(I63:T63),SUM(I63:T63),\"\")","v":90}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                            contafacil2013.wordpress.com"]

{"sheet":"Resumen y Balance","index":3,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"RESUMEN Y BALANCE DE GASTOS E INGRESOS"]
[null,null,1,"AÑO 2013"]
[null,null,null,null,null,null,null,null,null,"                         MENSUALIDADES",null,null,null,null,null,null,null,null,"MEDIA","TOTAL"]
[null,null,null,null,null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC.",null,"MENSUAL","ANUAL"]
[]
[null,null,null,"GASTOS FIJOS + EXTRAS",null,{"$f":"'Detalle Gastos'!F57","v":363.58000000000004},{"$f":"'Detalle Gastos'!G57","v":""},{"$f":"'Detalle Gastos'!H57","v":""},{"$f":"'Detalle Gastos'!I57","v":""},{"$f":"'Detalle Gastos'!J57","v":""},{"$f":"'Detalle Gastos'!K57","v":""},{"$f":"'Detalle Gastos'!L57","v":""},{"$f":"'Detalle Gastos'!M57","v":""},{"$f":"'Detalle Gastos'!N57","v":""},{"$f":"'Detalle Gastos'!O57","v":""},{"$f":"'Detalle Gastos'!P57","v":""},{"$f":"'Detalle Gastos'!Q57","v":""},null,{"$f":"IFERROR(AVERAGEIF(F6:Q6,\">0\"),\"\")","v":363.58000000000004}]
[]
[null,null,null,"GASTOS SIN CONTABILIZAR",null,{"$f":"IFERROR(F10+F6,\"\")","v":-676.28999999999985},"","","","","","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F8:Q8,\"<0\"),\"\")","v":-676.28999999999985}]
[]
[null,null,"*","TOTAL GASTOS",null,{"$f":"IFERROR('Contabilidad Mensual'!M8,\"\")","v":-1039.8699999999999},{"$f":"IFERROR('Contabilidad Mensual'!M12,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M16,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M20,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M24,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M28,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M32,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M36,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M40,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M44,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M48,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M52,\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F10:Q10,\"<0\"),\"\")","v":-1039.8699999999999},{"$f":"IF(SUM(F10:Q10),SUM(F10:Q10),\"\")","v":-1039.8699999999999}]
[]
[null,null,"*","INGRESOS",null,{"$f":"IFERROR('Contabilidad Mensual'!I8,\"\")","v":1129.8699999999999},{"$f":"IFERROR('Contabilidad Mensual'!I12,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I16,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I20,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I24,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I28,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I32,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I36,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I40,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I44,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I48,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I52,\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F12:Q12,\">0\"),\"\")","v":1129.8699999999999},{"$f":"IF(SUM(F12:Q12),SUM(F12:Q12),\"\")","v":1129.8699999999999}]
[]
[null,null,null,"BALANCE AHORRO +",null,{"$f":"IF(SUMIF('Contabilidad Mensual'!O8,\">0\"),SUMIF('Contabilidad Mensual'!O8,\">0\"),\"\")","v":90},{"$f":"IF(SUMIF('Contabilidad Mensual'!O12,\">0\"),SUMIF('Contabilidad Mensual'!O12,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O16,\">0\"),SUMIF('Contabilidad Mensual'!O16,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O20,\">0\"),SUMIF('Contabilidad Mensual'!O20,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O24,\">0\"),SUMIF('Contabilidad Mensual'!O24,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O28,\">0\"),SUMIF('Contabilidad Mensual'!O28,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O32,\">0\"),SUMIF('Contabilidad Mensual'!O32,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O36,\">0\"),SUMIF('Contabilidad Mensual'!O36,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O40,\">0\"),SUMIF('Contabilidad Mensual'!O40,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O44,\">0\"),SUMIF('Contabilidad Mensual'!O44,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O48,\">0\"),SUMIF('Contabilidad Mensual'!O48,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O52,\">0\"),SUMIF('Contabilidad Mensual'!O52,\">0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F14:Q14,\">0\"),\"\")","v":90}]
[]
[null,null,null,"BALANCE AHORRO -",null,{"$f":"IF(SUMIF('Contabilidad Mensual'!O8,\"<0\"),SUMIF('Contabilidad Mensual'!O8,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O12,\"<0\"),SUMIF('Contabilidad Mensual'!O12,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O16,\"<0\"),SUMIF('Contabilidad Mensual'!O16,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O20,\"<0\"),SUMIF('Contabilidad Mensual'!O20,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O24,\"<0\"),SUMIF('Contabilidad Mensual'!O24,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O28,\"<0\"),SUMIF('Contabilidad Mensual'!O28,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O32,\"<0\"),SUMIF('Contabilidad Mensual'!O32,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O36,\"<0\"),SUMIF('Contabilidad Mensual'!O36,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O40,\"<0\"),SUMIF('Contabilidad Mensual'!O40,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O44,\"<0\"),SUMIF('Contabilidad Mensual'!O44,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O48,\"<0\"),SUMIF('Contabilidad Mensual'!O48,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O52,\"<0\"),SUMIF('Contabilidad Mensual'!O52,\"<0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F16:Q16,\"<0\"),\"\")","v":""}]
[]
[null,null,"*","AHORRO",null,{"$f":"IF(SUM(F14,F16),SUM(F14,F16),\"\")","v":90},{"$f":"IF(SUM(G14,G16),SUM(G14,G16),\"\")","v":""},{"$f":"IF(SUM(H14,H16),SUM(H14,H16),\"\")","v":""},{"$f":"IF(SUM(I14,I16),SUM(I14,I16),\"\")","v":""},{"$f":"IF(SUM(J14,J16),SUM(J14,J16),\"\")","v":""},"","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F18:Q18,\"<>0\"),\"\")","v":90},{"$f":"IF(SUM(F18:Q18),SUM(F18:Q18),\"\")","v":90}]
[]
[]
[null,null,2,"AÑO 2014"]
[null,null,null,null,null,null,null,null,null,"                         MENSUALIDADES",null,null,null,null,null,null,null,null,"MEDIA","TOTAL"]
[null,null,null,null,null,"ENE.","FEB.","MAR.","ABR.","MAY.","JUN.","JUL.","AGO.","SEP.","OCT.","NOV.","DIC.",null,"MENSUAL","ANUAL"]
[]
[null,null,null,"GASTOS FIJOS + EXTRAS",null,{"$f":"'Detalle Gastos'!F115","v":""},{"$f":"'Detalle Gastos'!G115","v":""},{"$f":"'Detalle Gastos'!H115","v":""},{"$f":"'Detalle Gastos'!I115","v":""},{"$f":"'Detalle Gastos'!J115","v":""},{"$f":"'Detalle Gastos'!K115","v":""},{"$f":"'Detalle Gastos'!L115","v":""},{"$f":"'Detalle Gastos'!M115","v":""},{"$f":"'Detalle Gastos'!N115","v":""},{"$f":"'Detalle Gastos'!O115","v":""},{"$f":"'Detalle Gastos'!P115","v":""},{"$f":"'Detalle Gastos'!Q115","v":""},null,{"$f":"IFERROR(AVERAGEIF(F25:Q25,\">0\"),\"\")","v":""}]
[]
[null,null,null,"GASTOS SIN CONTABILIZAR",null,{"$f":"IFERROR(F29+F25,\"\")","v":""},"","","","","","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F27:Q27,\"<0\"),\"\")","v":""}]
[]
[null,null,"*","TOTAL GASTOS",null,{"$f":"IFERROR('Contabilidad Mensual'!M60,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M64,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M68,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M72,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M76,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M80,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M84,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M88,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M92,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M96,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M100,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!M104,\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F29:Q29,\"<0\"),\"\")","v":""},{"$f":"IF(SUM(F29:Q29),SUM(F29:Q29),\"\")","v":""}]
[]
[null,null,"*","INGRESOS",null,{"$f":"IFERROR('Contabilidad Mensual'!I60,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I64,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I68,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I72,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I76,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I80,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I84,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I88,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I92,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I96,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I100,\"\")","v":""},{"$f":"IFERROR('Contabilidad Mensual'!I104,\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F31:Q31,\">0\"),\"\")","v":""},{"$f":"IF(SUM(F31:Q31),SUM(F31:Q31),\"\")","v":""}]
[]
[null,null,null,"BALANCE AHORRO +",null,{"$f":"IF(SUMIF('Contabilidad Mensual'!O60,\">0\"),SUMIF('Contabilidad Mensual'!O60,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O64,\">0\"),SUMIF('Contabilidad Mensual'!O64,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O68,\">0\"),SUMIF('Contabilidad Mensual'!O68,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O72,\">0\"),SUMIF('Contabilidad Mensual'!O72,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O76,\">0\"),SUMIF('Contabilidad Mensual'!O76,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O80,\">0\"),SUMIF('Contabilidad Mensual'!O80,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O84,\">0\"),SUMIF('Contabilidad Mensual'!O84,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O88,\">0\"),SUMIF('Contabilidad Mensual'!O88,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O92,\">0\"),SUMIF('Contabilidad Mensual'!O92,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O96,\">0\"),SUMIF('Contabilidad Mensual'!O96,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O100,\">0\"),SUMIF('Contabilidad Mensual'!O100,\">0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O104,\">0\"),SUMIF('Contabilidad Mensual'!O104,\">0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F33:Q33,\">0\"),\"\")","v":""}]
[]
[null,null,null,"BALANCE AHORRO -",null,{"$f":"IF(SUMIF('Contabilidad Mensual'!O60,\"<0\"),SUMIF('Contabilidad Mensual'!O60,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O64,\"<0\"),SUMIF('Contabilidad Mensual'!O64,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O68,\"<0\"),SUMIF('Contabilidad Mensual'!O68,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O72,\"<0\"),SUMIF('Contabilidad Mensual'!O72,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O76,\"<0\"),SUMIF('Contabilidad Mensual'!O76,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O80,\"<0\"),SUMIF('Contabilidad Mensual'!O80,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O84,\"<0\"),SUMIF('Contabilidad Mensual'!O84,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O88,\"<0\"),SUMIF('Contabilidad Mensual'!O88,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O92,\"<0\"),SUMIF('Contabilidad Mensual'!O92,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O96,\"<0\"),SUMIF('Contabilidad Mensual'!O96,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O100,\"<0\"),SUMIF('Contabilidad Mensual'!O100,\"<0\"),\"\")","v":""},{"$f":"IF(SUMIF('Contabilidad Mensual'!O104,\"<0\"),SUMIF('Contabilidad Mensual'!O104,\"<0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(F35:Q35,\"<0\"),\"\")","v":""}]
[]
[null,null,"*","AHORRO ",null,{"$f":"IF(SUM(F33,F35),SUM(F33,F35),\"\")","v":""},{"$f":"IF(SUM(G33,G35),SUM(G33,G35),\"\")","v":""},"","","","","","","","","","",null,{"$f":"IFERROR(AVERAGEIF(F37:Q37,\"<>0\"),\"\")","v":""},{"$f":"IF(SUM(F37:Q37),SUM(F37:Q37),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                 contafacil2013.wordpress.com"]

{"sheet":"Estadísticas","index":4,"n_rows":67,"n_cols":27,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"          ESTADÍSTICAS"]
[null,1,"AÑO 2013",null,null,null,null,null,null,null,null,null,"         "]
[]
[null,null,null,null,"ENE.",null,"FEB.",null,"MAR.",null,"ABR.",null,"MAY.",null,"JUN.",null,"JUL.",null,"AGO.",null,"SEP.",null,"OCT.",null,"NOV.",null,"DIC."]
[null,null,"Ingresos",null,{"$f":"'Resumen y Balance'!F12","v":1129.8699999999999},null,{"$f":"'Resumen y Balance'!G12","v":""},null,{"$f":"'Resumen y Balance'!H12","v":""},null,{"$f":"'Resumen y Balance'!I12","v":""},null,{"$f":"'Resumen y Balance'!J12","v":""},null,{"$f":"'Resumen y Balance'!K12","v":""},null,{"$f":"'Resumen y Balance'!L12","v":""},null,{"$f":"'Resumen y Balance'!M12","v":""},null,{"$f":"'Resumen y Balance'!N12","v":""},null,{"$f":"'Resumen y Balance'!O12","v":""},null,{"$f":"'Resumen y Balance'!P12","v":""},null,{"$f":"'Resumen y Balance'!Q12","v":""}]
[null,null,"Gastos",null,{"$f":"'Resumen y Balance'!F10","v":-1039.8699999999999},null,{"$f":"'Resumen y Balance'!G10","v":""},null,{"$f":"'Resumen y Balance'!H10","v":""},null,{"$f":"'Resumen y Balance'!I10","v":""},null,{"$f":"'Resumen y Balance'!J10","v":""},null,{"$f":"'Resumen y Balance'!K10","v":""},null,{"$f":"'Resumen y Balance'!L10","v":""},null,{"$f":"'Resumen y Balance'!M10","v":""},null,{"$f":"'Resumen y Balance'!N10","v":""},null,{"$f":"'Resumen y Balance'!O10","v":""},null,{"$f":"'Resumen y Balance'!P10","v":""},null,{"$f":"'Resumen y Balance'!Q10","v":""}]
[null,null,"Ahorro",null,{"$f":"'Resumen y Balance'!F18","v":90},null,{"$f":"'Resumen y Balance'!G18","v":""},null,{"$f":"'Resumen y Balance'!H18","v":""},null,{"$f":"'Resumen y Balance'!I18","v":""},null,{"$f":"'Resumen y Balance'!J18","v":""},null,{"$f":"'Resumen y Balance'!K18","v":""},null,{"$f":"'Resumen y Balance'!L18","v":""},null,{"$f":"'Resumen y Balance'!M18","v":""},null,{"$f":"'Resumen y Balance'!N18","v":""},null,{"$f":"'Resumen y Balance'!O18","v":""},null,{"$f":"'Resumen y Balance'!P18","v":""},null,{"$f":"'Resumen y Balance'!Q18","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Máximo",null,"Mínimo",null,null,null,null,null,null,null,null,null,"Máximo",null,"Mínimo"]
[]
[null,null,null,null,"Total Gastos",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F10:Q10),MIN('Resumen y Balance'!F10:Q10),\"\")","v":-1039.8699999999999},null,{"$f":"IF(MAX('Resumen y Balance'!F10:Q10),MAX('Resumen y Balance'!F10:Q10),\"\")","v":-1039.8699999999999},null,null,null,"Ingresos",null,null,null,null,null,{"$f":"IF(MAX('Resumen y Balance'!F12:Q12),MAX('Resumen y Balance'!F12:Q12),\"\")","v":1129.8699999999999},null,{"$f":"IF(MIN('Resumen y Balance'!F12:Q12),MIN('Resumen y Balance'!F12:Q12),\"\")","v":1129.8699999999999}]
[]
[null,null,null,null,"Gastos Extras",null,null,null,null,null,{"$f":"IF(MAX('Detalle Gastos'!F34:Q34),MAX('Detalle Gastos'!F34:Q34),\"\")","v":167.8},null,{"$f":"IF(MIN('Detalle Gastos'!F34:Q34),MIN('Detalle Gastos'!F34:Q34),\"\")","v":167.8},null,null,null,"Saldo en cuenta",null,null,null,null,null,{"$f":"IF(MAX('Contabilidad Mensual'!D8:D53),MAX('Contabilidad Mensual'!D8:D53),\"\")","v":1379},null,{"$f":"IF(MIN('Contabilidad Mensual'!D8:D53),MIN('Contabilidad Mensual'!D8:D53),\"\")","v":1289}]
[]
[null,null,null,null,"Gastos Sin Contabilizar",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F8:Q8),MIN('Resumen y Balance'!F8:Q8),\"\")","v":-676.28999999999985},null,{"$f":"IF(MAX('Resumen y Balance'!F8:Q8),MAX('Resumen y Balance'!F8:Q8),\"\")","v":-676.28999999999985},null,null,null,"Saldo en Cuenta Ahorro",null,null,null,null,null,{"$f":"IF(MAX('Cuenta Ahorro'!R12:R44),MAX('Cuenta Ahorro'!R12:R44),\"\")","v":1300},null,{"$f":"IF(MIN('Cuenta Ahorro'!R12:R44),MIN('Cuenta Ahorro'!R12:R44),\"\")","v":1300}]
[]
[null,null,null,null,"Concepto de Gasto",null,null,null,null,null,{"$f":"IF(MAX('Detalle Gastos'!F6:Q32),MAX('Detalle Gastos'!F6:Q32),\"\")","v":91.13},null,{"$f":"IF(MIN('Detalle Gastos'!F6:Q32),MIN('Detalle Gastos'!F6:Q32),\"\")","v":""},null,null,null,"Concepto de Ingreso",null,null,null,null,null,{"$f":"IF(MAX('Contabilidad Mensual'!G7:G53),MAX('Contabilidad Mensual'!G7:G53),\"\")","v":1123},null,{"$f":"IF(MIN('Contabilidad Mensual'!G7:G53),MIN('Contabilidad Mensual'!G7:G53),\"\")","v":6.87}]
[]
[null,null,null,null,"Balance Negativo",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F16:Q16),MIN('Resumen y Balance'!F16:Q16),\"\")","v":""},null,{"$f":"IF(MAX('Resumen y Balance'!F16:Q16),MAX('Resumen y Balance'!F16:Q16),\"\")","v":""},null,null,null,"Balance Positivo",null,null,null,null,null,{"$f":"IF(MAX('Resumen y Balance'!F14:Q14),MAX('Resumen y Balance'!F14:Q14),\"\")","v":90},null,{"$f":"IF(MIN('Resumen y Balance'!F14:Q14),MIN('Resumen y Balance'!F14:Q14),\"\")","v":90}]
[]
[]
[null,2,"AÑO 2014"]
[]
[null,null,null,null,"ENE.",null,"FEB.",null,"MAR.",null,"ABR.",null,"MAY.",null,"JUN.",null,"JUL.",null,"AGO.",null,"SEP.",null,"OCT.",null,"NOV.",null,"DIC."]
[null,null,"Ingresos",null,{"$f":"'Resumen y Balance'!F31","v":""},null,{"$f":"'Resumen y Balance'!G31","v":""},null,{"$f":"'Resumen y Balance'!H31","v":""},null,{"$f":"'Resumen y Balance'!I31","v":""},null,{"$f":"'Resumen y Balance'!J31","v":""},null,{"$f":"'Resumen y Balance'!K31","v":""},null,{"$f":"'Resumen y Balance'!L31","v":""},null,{"$f":"'Resumen y Balance'!M31","v":""},null,{"$f":"'Resumen y Balance'!N31","v":""},null,{"$f":"'Resumen y Balance'!O31","v":""},null,{"$f":"'Resumen y Balance'!P31","v":""},null,{"$f":"'Resumen y Balance'!Q31","v":""}]
[null,null,"Gastos",null,{"$f":"'Resumen y Balance'!F29","v":""},null,{"$f":"'Resumen y Balance'!G29","v":""},null,{"$f":"'Resumen y Balance'!H29","v":""},null,{"$f":"'Resumen y Balance'!I29","v":""},null,{"$f":"'Resumen y Balance'!J29","v":""},null,{"$f":"'Resumen y Balance'!K29","v":""},null,{"$f":"'Resumen y Balance'!L29","v":""},null,{"$f":"'Resumen y Balance'!M29","v":""},null,{"$f":"'Resumen y Balance'!N29","v":""},null,{"$f":"'Resumen y Balance'!O29","v":""},null,{"$f":"'Resumen y Balance'!P29","v":""},null,{"$f":"'Resumen y Balance'!Q29","v":""}]
[null,null,"Ahorro",null,{"$f":"'Resumen y Balance'!F37","v":""},null,{"$f":"'Resumen y Balance'!G37","v":""},null,{"$f":"'Resumen y Balance'!H37","v":""},null,{"$f":"'Resumen y Balance'!I37","v":""},null,{"$f":"'Resumen y Balance'!J37","v":""},null,{"$f":"'Resumen y Balance'!K37","v":""},null,{"$f":"'Resumen y Balance'!L37","v":""},null,{"$f":"'Resumen y Balance'!M37","v":""},null,{"$f":"'Resumen y Balance'!N37","v":""},null,{"$f":"'Resumen y Balance'!O37","v":""},null,{"$f":"'Resumen y Balance'!P37","v":""},null,{"$f":"'Resumen y Balance'!Q37","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Máximo",null,"Mínimo",null,null,null,null,null,null,null,null,null,"Máximo",null,"Mínimo"]
[]
[null,null,null,null,"Total Gastos",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F29:Q29),MIN('Resumen y Balance'!F29:Q29),\"\")","v":""},null,{"$f":"IF(MAX('Resumen y Balance'!F29:Q29),MAX('Resumen y Balance'!F29:Q29),\"\")","v":""},null,null,null,"Ingresos",null,null,null,null,null,{"$f":"IF(MAX('Resumen y Balance'!F31:Q31),MAX('Resumen y Balance'!F31:Q31),\"\")","v":""},null,{"$f":"IF(MIN('Resumen y Balance'!F31:Q31),MIN('Resumen y Balance'!F31:Q31),\"\")","v":""}]
[]
[null,null,null,null,"Gastos Extras",null,null,null,null,null,{"$f":"IF(MAX('Detalle Gastos'!F92:Q92),MAX('Detalle Gastos'!F92:Q92),\"\")","v":""},null,{"$f":"IF(MIN('Detalle Gastos'!F92:Q92),MIN('Detalle Gastos'!F92:Q92),\"\")","v":""},null,null,null,"Saldo en cuenta",null,null,null,null,null,{"$f":"IF(MAX('Contabilidad Mensual'!D60:D105),MAX('Contabilidad Mensual'!D60:D105),\"\")","v":""},null,{"$f":"IF(MIN('Contabilidad Mensual'!D60:D105),MIN('Contabilidad Mensual'!D60:D105),\"\")","v":""}]
[]
[null,null,null,null,"Gastos Sin Contabilizar",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F27:Q27),MIN('Resumen y Balance'!F27:Q27),\"\")","v":""},null,{"$f":"IF(MAX('Resumen y Balance'!F27:Q27),MAX('Resumen y Balance'!F27:Q27),\"\")","v":""},null,null,null,"Saldo en Cuenta Ahorro",null,null,null,null,null,{"$f":"IF(MAX('Cuenta Ahorro'!R12:R44),MAX('Cuenta Ahorro'!R12:R44),\"\")","v":1300},null,{"$f":"IF(MIN('Cuenta Ahorro'!R12:R44),MIN('Cuenta Ahorro'!R12:R44),\"\")","v":1300}]
[]
[null,null,null,null,"Concepto de Gasto",null,null,null,null,null,{"$f":"IF(MAX('Detalle Gastos'!F64:Q90),MAX('Detalle Gastos'!F64:Q90),\"\")","v":""},null,{"$f":"IF(MIN('Detalle Gastos'!F64:Q90),MIN('Detalle Gastos'!F64:Q90),\"\")","v":""},null,null,null,"Concepto de Ingreso",null,null,null,null,null,{"$f":"IF(MAX('Contabilidad Mensual'!G59:G105),MAX('Contabilidad Mensual'!G59:G105),\"\")","v":""},null,{"$f":"IF(MIN('Contabilidad Mensual'!G59:G105),MIN('Contabilidad Mensual'!G59:G105),\"\")","v":""}]
[]
[null,null,null,null,"Balance Negativo",null,null,null,null,null,{"$f":"IF(MIN('Resumen y Balance'!F35:Q35),MIN('Resumen y Balance'!F35:Q35),\"\")","v":""},null,{"$f":"IF(MAX('Resumen y Balance'!F35:Q35),MAX('Resumen y Balance'!F35:Q35),\"\")","v":""},null,null,null,"Balance Positivo",null,null,null,null,null,{"$f":"IF(MAX('Resumen y Balance'!F33:Q33),MAX('Resumen y Balance'!F33:Q33),\"\")","v":""},null,{"$f":"IF(MIN('Resumen y Balance'!F33:Q33),MIN('Resumen y Balance'!F33:Q33),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                        contafacil2013.wordpress.com"]

{"sheet":"Cuenta Ahorro","index":5,"n_rows":63,"n_cols":25,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUENTA DE AHORRO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"                                              "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"                       AHORRO",null,null,null,null,null,null,null,null,null,"                                         PRESUPUESTADO"]
[]
[null,null,null,"REF.",null,"FECHA",null,"HABER",null,"INGRESO",null,"                  CONCEPTO",null,null,"                  CONCEPTO",null,null,"SALDO"]
[null,null,null,null,null,null,null,null,null,"REINTEGRO",null,"                                 INGRESO",null,null,"                  REINTEGRO",null,null,null,null,null,null,"HABER","PRESUPUESTADO"]
[]
[]
[null,null,null,1,null,"2013-02-12",null,1200,null,100,null,"Traspaso de Ahorro",null,null,null,null,null,{"$f":"IF(J12<>0,SUM(H12:J12),\"\")","v":1300},null,"REF.",null,"                                        CONCEPTO",null,null,"VALOR"]
[]
[null,null,null,2,null,null,null,{"$f":"IF(R12<>0,R12,\"\")","v":1300},null,null,null,null,null,null,null,null,null,{"$f":"IF(J14<>0, SUM(H14:J14),\"\")","v":""}]
[]
[null,null,null,3,null,"",null,{"$f":"IF(R14<>0,R14,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J16<>0,SUM(H16:J16),\"\")","v":""},null,1,null,"Compra de móvil",null,null,300]
[]
[null,null,null,4,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J18<>0, SUM(H18:J18),\"\")","v":""},null,2]
[]
[null,null,null,5,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J20<>0, SUM(H20:J20),\"\")","v":""},null,3]
[]
[null,null,null,6,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J22<>0, SUM(H22:J22),\"\")","v":""},null,4]
[]
[null,null,null,7,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J24<>0, SUM(H24:J24),\"\")","v":""},null,5]
[]
[null,null,null,8,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J26<>0, SUM(H26:J26),\"\")","v":""},null,6]
[]
[null,null,null,9,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J28<>0, SUM(H28:J28),\"\")","v":""},null,7]
[]
[null,null,null,10,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,8]
[]
[null,null,null,11,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,9]
[]
[null,null,null,12,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,10]
[]
[null,null,null,13,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,11]
[]
[null,null,null,14,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J38<>0, SUM(H38:J38),\"\")","v":""},null,12]
[]
[null,null,null,15,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J40<>0, SUM(H40:J40),\"\")","v":""},null,13]
[]
[null,null,null,16,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J42<>0, SUM(H42:J42),\"\")","v":""},null,14]
[]
[null,null,null,17,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J44<>0, SUM(H44:J44),\"\")","v":""},null,null,null,"TOTAL ","PRESUPUESTADO",null,{"$f":"IF(SUMIF(Y16:Y42,\">0\"),SUMIF(Y16:Y42,\">0\"),\"\")","v":300}]
[]
[null,null,null,18,null,"",null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J46<>0, SUM(H46:J46),\"\")","v":""},null,null,null,null,"RESTO LIBRE",null,{"$f":"IFERROR(SUM(R61-Y44),\"\")","v":1000}]
[]
[null,null,null,19,null,"",null,"",null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,20,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,"REF.",null,"                                         BLOC DE NOTAS"]
[]
[null,null,null,21,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,"1.",null,"Ej: Ingresar 150 € el próximo mes."]
[]
[null,null,null,22,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,"2."]
[]
[null,null,null,23,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,"3."]
[]
[null,null,null,24,null,"",null,"",null,null,null,null,null,null,null,null,null,"",null,"4."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"IFERROR(SUM(J12:J58)+H12,\"\")","v":1300}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                               contafacil2013.wordpress.com"]