{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Disbursement summary","Disbursement journal"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Disbursement summary","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,5]]}
[null,"Disbursement summary"]
[null,"Date","Auto insurance","Office supplies","Electricity","Mortgage","Phone","Column1","Column2","Column3","Column4"]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A1),1),\"\")","v":"2022-11-06"},{"$f":"IFERROR(INDIRECT(\"Register[@Amount]\")*(INDIRECT(\"Register[@Category]\")=CategoryName),\"\")","v":0},0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A2),1),\"\")","v":"2022-11-11"},0,0,{"v":85,"d":"$85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A3),1),\"\")","v":"2022-11-16"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A4),1),\"\")","v":"2022-11-21"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A5),1),\"\")","v":"2022-11-26"},0,0,0,{"v":99,"d":"$99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A6),1),\"\")","v":"2022-12-01"},0,0,0,0,{"v":68,"d":"$68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A7),1),\"\")","v":"2022-12-06"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A8),1),\"\")","v":"2022-12-11"},0,{"v":345,"d":"$345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A9),1),\"\")","v":"2022-12-16"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A10),1),\"\")","v":"2022-12-21"},0,0,{"v":74,"d":"$74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A11),1),\"\")","v":"2022-12-26"},0,0,0,0,{"v":123,"d":"$123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A12),1),\"\")","v":"2022-12-31"},0,{"v":99,"d":"$99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A13),1),\"\")","v":"2023-01-05"},{"v":100,"d":"$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A14),1),\"\")","v":"2023-01-10"},0,0,0,{"v":1200,"d":"$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A15),1),\"\")","v":"2023-01-15"},0,{"v":128,"d":"$128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,DisbursementSummary[Auto insurance])","v":{"v":300,"d":"$300.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[Office supplies])","v":{"v":572,"d":"$572.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[Electricity])","v":{"v":159,"d":"$159.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[Mortgage])","v":{"v":4899,"d":"$4,899.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[Phone])","v":{"v":191,"d":"$191.00"}},{"$f":"SUBTOTAL(109,DisbursementSummary[Column1])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[Column2])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[Column3])","v":0},{"$f":"SUBTOTAL(109,DisbursementSummary[Column4])","v":0}]

{"sheet":"Disbursement journal","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,4]]}
[null,"Disbursement journal"]
[null,"Date","Number","Description","Category","Amount"]
[null,{"$f":"TODAY()-70","v":"2022-11-06"},"100","Woodgrove Bank","Mortgage",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2022-11-11"},101,"City Power & Light","Electricity",{"v":85,"d":"$85.00"}]
[null,{"$f":"TODAY()-60","v":"2022-11-16"},102,"Humongous Insurance","Auto insurance",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-55","v":"2022-11-21"},103,"Woodgrove Bank","Mortgage",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2022-11-26"},104,"City Power & Light","Mortgage",{"v":99,"d":"$99.00"}]
[null,{"$f":"TODAY()-45","v":"2022-12-01"},105,"The Phone Company","Phone",{"v":68,"d":"$68.00"}]
[null,{"$f":"TODAY()-40","v":"2022-12-06"},106,"Humongous Insurance","Auto insurance",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-35","v":"2022-12-11"},107,"Litware, Inc.","Office supplies",{"v":345,"d":"$345.00"}]
[null,{"$f":"TODAY()-30","v":"2022-12-16"},110,"Woodgrove Bank","Mortgage",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2022-12-21"},111,"City Power & Light","Electricity",{"v":74,"d":"$74.00"}]
[null,{"$f":"TODAY()-20","v":"2022-12-26"},108,"The Phone Company","Phone",{"v":123,"d":"$123.00"}]
[null,{"$f":"TODAY()-15","v":"2022-12-31"},109,"Litware, Inc.","Office supplies",{"v":99,"d":"$99.00"}]
[null,{"$f":"TODAY()-10","v":"2023-01-05"},112,"Humongous Insurance","Auto insurance",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-5","v":"2023-01-10"},113,"Woodgrove Bank","Mortgage",{"v":1200,"d":"$1,200.00"}]
[null,{"$f":"TODAY()","v":"2023-01-15"},114,"Litware, Inc.","Office supplies",{"v":128,"d":"$128.00"}]
[null,"Totals",{"$nulls":3},{"$f":"SUBTOTAL(109,Register[Amount])","v":{"v":6121,"d":"$6,121.00"}}]