{"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},{"$f":"IFERROR(INDIRECT(\"登记表[@金额]\")*(INDIRECT(\"登记表[@类别]\")=类别名称),\"\")","v":0},0,{"v":1200,"d":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"¥85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"¥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":"¥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":"¥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":"¥68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"¥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":"¥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":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"¥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":"¥123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"¥99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"¥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":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(登记表[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"¥128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,付款汇总表[车险])","v":{"v":300,"d":"¥300.00"}},{"$f":"SUBTOTAL(109,付款汇总表[办公用品])","v":{"v":572,"d":"¥572.00"}},{"$f":"SUBTOTAL(109,付款汇总表[电费])","v":{"v":159,"d":"¥159.00"}},{"$f":"SUBTOTAL(109,付款汇总表[抵押贷款])","v":{"v":4899,"d":"¥4,899.00"}},{"$f":"SUBTOTAL(109,付款汇总表[电话])","v":{"v":191,"d":"¥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","Woodgrove Bank","抵押贷款",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"城市电力与照明公司","电费",{"v":85,"d":"¥85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous Insurance","车险",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"Woodgrove Bank","抵押贷款",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"城市电力与照明公司","抵押贷款",{"v":99,"d":"¥99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"The Phone Company","电话",{"v":68,"d":"¥68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous Insurance","车险",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware, Inc.","办公用品",{"v":345,"d":"¥345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"Woodgrove Bank","抵押贷款",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"城市电力与照明公司","电费",{"v":74,"d":"¥74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"The Phone Company","电话",{"v":123,"d":"¥123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware, Inc.","办公用品",{"v":99,"d":"¥99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous Insurance","车险",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"Woodgrove Bank","抵押贷款",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware, Inc.","办公用品",{"v":128,"d":"¥128.00"}]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,登记表[金额])","v":{"v":6121,"d":"¥6,121.00"}}]