{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["支出摘要","支出日誌"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"支出摘要","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"支出摘要",null,null,"請修改下方 [支出摘要] 表格標題中的類別名稱，來自訂此範本以符合您的需求。如果您需要新增其他類別，請複製表格的最後一欄，並貼至複製欄的右側。公式會在您變更類別名稱時自動更新。請務必保持此表格的列數與 [支出日誌] 工作表的列數相同。"]
[null,"日期","汽車保險","辦公室用品","電費","貸款","電話費","空白 1","空白 2","空白 3","空白 4"]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A1),1),\"\")","v":"2018-04-06"},{"$f":"IFERROR(INDIRECT(\"登記簿[@金額]\")*(INDIRECT(\"登記簿[@類別]\")=類別名稱),\"\")","v":0},0,0,{"v":1200,"d":"NT$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"NT$85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"NT$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A4),1),\"\")","v":"2018-04-21"},0,0,0,{"v":1200,"d":"NT$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A5),1),\"\")","v":"2018-04-26"},0,0,0,{"v":99,"d":"NT$99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A6),1),\"\")","v":"2018-05-01"},0,0,0,0,{"v":68,"d":"NT$68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"NT$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A8),1),\"\")","v":"2018-05-11"},0,{"v":345,"d":"NT$345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A9),1),\"\")","v":"2018-05-16"},0,0,0,{"v":1200,"d":"NT$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"NT$74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A11),1),\"\")","v":"2018-05-26"},0,0,0,0,{"v":123,"d":"NT$123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"NT$99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"NT$100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A14),1),\"\")","v":"2018-06-10"},0,0,0,{"v":1200,"d":"NT$1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登記簿[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"NT$128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,支出摘要[汽車保險])","v":{"v":300,"d":"NT$300.00"}},{"$f":"SUBTOTAL(109,支出摘要[辦公室用品])","v":{"v":572,"d":"NT$572.00"}},{"$f":"SUBTOTAL(109,支出摘要[電費])","v":{"v":159,"d":"NT$159.00"}},{"$f":"SUBTOTAL(109,支出摘要[貸款])","v":{"v":4899,"d":"NT$4,899.00"}},{"$f":"SUBTOTAL(109,支出摘要[電話費])","v":{"v":191,"d":"NT$191.00"}},{"$f":"SUBTOTAL(109,支出摘要[空白 1])","v":0},{"$f":"SUBTOTAL(109,支出摘要[空白 2])","v":0},{"$f":"SUBTOTAL(109,支出摘要[空白 3])","v":0},{"$f":"SUBTOTAL(109,支出摘要[空白 4])","v":0}]

{"sheet":"支出日誌","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"支出日誌"]
[null,"日期","編號","描述","類別","金額"]
[null,{"$f":"TODAY()-70","v":"2018-04-06"},"100","木林銀行","貸款",{"v":1200,"d":"NT$1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"城市光電","電費",{"v":85,"d":"NT$85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous 保險","汽車保險",{"v":100,"d":"NT$100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"木林銀行","貸款",{"v":1200,"d":"NT$1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"城市光電","貸款",{"v":99,"d":"NT$99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"電信公司","電話費",{"v":68,"d":"NT$68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous 保險","汽車保險",{"v":100,"d":"NT$100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware 股份有限公司","辦公室用品",{"v":345,"d":"NT$345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"木林銀行","貸款",{"v":1200,"d":"NT$1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"城市光電","電費",{"v":74,"d":"NT$74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"電信公司","電話費",{"v":123,"d":"NT$123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware 股份有限公司","辦公室用品",{"v":99,"d":"NT$99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous 保險","汽車保險",{"v":100,"d":"NT$100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"木林銀行","貸款",{"v":1200,"d":"NT$1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware 股份有限公司","辦公室用品",{"v":128,"d":"NT$128.00"}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,登記簿[金額])","v":{"v":6121,"d":"NT$6,121.00"}}]