{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Resumen de pagos","Diario de pagos"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Resumen de pagos","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Resumen de pagos",null,null,"Modifica los nombres de categoría en el siguiente encabezado de tabla Resumen de pagos para personalizar esta plantilla y adaptarla a tus necesidades. Si necesitar agregar categorías adicionales, copia la última columna de la tabla y pégala a la derecha de la columna copiada. Cuando cambies el nombre de la categoría, las fórmulas se actualizarán automáticamente. Asegúrate de que esta tabla tenga el mismo número de filas en la hoja de cálculo Diario de pagos."]
[null,"Fecha","Seguro del \nvehículo","Suministros de oficina","Electricidad","Hipoteca","Teléfono","Vacío 1","Vacío 2","Vacío 3","Vacío 4"]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Registro[@Importe]\")*(INDIRECT(\"Registro[@Categoría]\")=NombreDeCategoría),\"\")","v":0},0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"$85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"$99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"$68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"$345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"$74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"$123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"$99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registro[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"$128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,ResumenDePagos[Seguro del \nvehículo])","v":{"v":300,"d":"$300.00"}},{"$f":"SUBTOTAL(109,ResumenDePagos[Suministros de oficina])","v":{"v":572,"d":"$572.00"}},{"$f":"SUBTOTAL(109,ResumenDePagos[Electricidad])","v":{"v":159,"d":"$159.00"}},{"$f":"SUBTOTAL(109,ResumenDePagos[Hipoteca])","v":{"v":4899,"d":"$4,899.00"}},{"$f":"SUBTOTAL(109,ResumenDePagos[Teléfono])","v":{"v":191,"d":"$191.00"}},{"$f":"SUBTOTAL(109,ResumenDePagos[Vacío 1])","v":0},{"$f":"SUBTOTAL(109,ResumenDePagos[Vacío 2])","v":0},{"$f":"SUBTOTAL(109,ResumenDePagos[Vacío 3])","v":0},{"$f":"SUBTOTAL(109,ResumenDePagos[Vacío 4])","v":0}]

{"sheet":"Diario de pagos","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Diario de pagos"]
[null,"Fecha","Número","Descripción","Categoría","Importe"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","Hipoteca",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"City Power & Light","Electricidad",{"v":85,"d":"$85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","Seguro del \nvehículo",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"City Power & Light","Hipoteca",{"v":99,"d":"$99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","Teléfono",{"v":68,"d":"$68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","Seguro del \nvehículo",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Suministros de oficina",{"v":345,"d":"$345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"City Power & Light","Electricidad",{"v":74,"d":"$74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","Teléfono",{"v":123,"d":"$123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Suministros de oficina",{"v":99,"d":"$99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","Seguro del \nvehículo",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","Hipoteca",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Suministros de oficina",{"v":128,"d":"$128.00"}]
[null,"Totales",{"$nulls":3},{"$f":"SUBTOTAL(109,Registro[Importe])","v":{"v":6121,"d":"$6,121.00"}}]