{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["记账登记表"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"记账登记表","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"记账登记表"]
[null,"图例",{"$nulls":5},"当前余额"]
[null,"DC = 借记卡",null,"AP = 自动付款 ",{"$nulls":3},{"$f":"当前_余额","v":{"v":3311,"d":"¥3,311.00"}}]
[null,"ATM = 自动柜员机取款",null,"BP = 在线帐单支付"]
[null,"AD = 自动存款 ",null,"TR = 在线或手机转账"]
[null,"记账编号/代码","日期","交易记录","说明","取款","存款","余额"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-27"},"Woodgrove Bank","期初余额",null,{"v":2000,"d":"¥2,000.00"},{"$f":"IFERROR(记账登记表[[#This Row],[存款]], \"\")","v":{"v":2000,"d":"¥2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2018-06-04"},"School of Fine Art","Kelly 的艺术课 - 6 周",{"v":100,"d":"¥100.00"},null,{"$f":"IFERROR(IF(ISBLANK(记账登记表[[#This Row],[取款]]),H7+记账登记表[[#This Row],[存款]],H7-记账登记表[[#This Row],[取款]]), \"\")","v":{"v":1900,"d":"¥1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2018-06-04"},"工资",null,null,{"v":1500,"d":"¥1,500.00"},{"$f":"IFERROR(IF(ISBLANK(记账登记表[[#This Row],[取款]]),H8+记账登记表[[#This Row],[存款]],H8-记账登记表[[#This Row],[取款]]), \"\")","v":{"v":3400,"d":"¥3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2018-06-07"},"Southridge 视频","影片租赁 + ￥10 的返现",{"v":16,"d":"¥16.00"},null,{"$f":"IFERROR(IF(ISBLANK(记账登记表[[#This Row],[取款]]),H9+记账登记表[[#This Row],[存款]],H9-记账登记表[[#This Row],[取款]]), \"\")","v":{"v":3384,"d":"¥3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2018-06-10"},null,"在外就餐现金",{"v":50,"d":"¥50.00"},null,{"$f":"IFERROR(IF(ISBLANK(记账登记表[[#This Row],[取款]]),H10+记账登记表[[#This Row],[存款]],H10-记账登记表[[#This Row],[取款]]), \"\")","v":{"v":3334,"d":"¥3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2018-06-15"},"The Phone Company",null,{"v":23,"d":"¥23.00"},null,{"$f":"IFERROR(IF(ISBLANK(记账登记表[[#This Row],[取款]]),H11+记账登记表[[#This Row],[存款]],H11-记账登记表[[#This Row],[取款]]), \"\")","v":{"v":3311,"d":"¥3,311.00"}}]
[null,"总计",null,{"$f":"CONCATENATE(\"交易计数：\",SUBTOTAL(103,记账登记表[交易记录]))","v":"交易计数：5"},null,{"$f":"SUBTOTAL(109,记账登记表[取款])","v":{"v":189,"d":"¥189.00"}},{"$f":"SUBTOTAL(109,记账登记表[存款])","v":{"v":3500,"d":"¥3,500.00"}},{"$f":"记账登记表[[#Totals],[存款]]-记账登记表[[#Totals],[取款]]","v":{"v":3311,"d":"¥3,311.00"}}]