{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["支票登记表"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"支票登记表","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"支票登记表"]
[null,"在此单元格中输入银行帐号"]
[null,{"$f":"CONCATENATE(\"当前余额 : \"&TEXT(支票登记表[[#Totals],[余额]],\"¥#,##0.00\"))","v":"当前余额 : ¥2,730.84"}]
[]
[{"$nulls":4},"支票编号","日期","说明","类别","取款","存款","余额"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-12"},"期初余额","存款",null,{"v":2916.73,"d":"¥2,916.73"},{"$f":"初始余额","v":{"v":2916.73,"d":"¥2,916.73"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-13"},"杂货店","日用杂货",{"v":205.61,"d":"¥205.61"},null,{"$f":"余额","v":{"v":2711.12,"d":"¥2,711.12"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-27"},"家庭抵押贷款","抵押贷款",{"v":961.77,"d":"¥961.77"},null,{"$f":"余额","v":{"v":1749.35,"d":"¥1,749.35"}}]
[{"$nulls":4},"借记",{"$f":"TODAY()-40","v":"2018-04-01"},"咖啡店","其他",{"v":3.65,"d":"¥3.65"},null,{"$f":"余额","v":{"v":1745.6999999999998,"d":"¥1,745.70"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-06"},"燃气和电力公司","公共事业",{"v":145.33,"d":"¥145.33"},null,{"$f":"余额","v":{"v":1600.37,"d":"¥1,600.37"}}]
[{"$nulls":4},"ATM",{"$f":"TODAY()-30","v":"2018-04-11"},"现金","其他",{"v":50,"d":"¥50.00"},null,{"$f":"余额","v":{"v":1550.37,"d":"¥1,550.37"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-16"},"信用卡","信用卡",{"v":936.48,"d":"¥936.48"},null,{"$f":"余额","v":{"v":613.8899999999999,"d":"¥613.89"}}]
[null,"汇总",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-21"},"工资","存款",null,{"v":2365.82,"d":"¥2,365.82"},{"$f":"余额","v":{"v":2979.71,"d":"¥2,979.71"}}]
[null,"类别","总计",null,null,{"$f":"TODAY()-15","v":"2018-04-26"},"共同基金投资","投资",{"v":200,"d":"¥200.00"},null,{"$f":"余额","v":{"v":2779.71,"d":"¥2,779.71"}}]
[null,"存款",{"$f":"类别汇总","v":{"v":5282.55,"d":"¥5,282.55"}},null,2253,{"$f":"TODAY()","v":"2018-05-11"},"The Phone Company","公共事业",{"v":48.87,"d":"¥48.87"},null,{"$f":"余额","v":{"v":2730.84,"d":"¥2,730.84"}}]
[null,"信用卡",{"$f":"类别汇总","v":{"v":936.48,"d":"¥936.48"}},null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,支票登记表[取款])","v":{"v":2551.71,"d":"¥2,551.71"}},{"$f":"SUBTOTAL(109,支票登记表[存款])","v":{"v":5282.55,"d":"¥5,282.55"}},{"$f":"支票登记表[[#Totals],[存款]]-支票登记表[[#Totals],[取款]]","v":{"v":2730.84,"d":"¥2,730.84"}}]
[null,"投资",{"$f":"类别汇总","v":{"v":200,"d":"¥200.00"}}]
[null,"日用杂货",{"$f":"类别汇总","v":{"v":205.61,"d":"¥205.61"}}]
[null,"公共事业",{"$f":"类别汇总","v":{"v":194.20000000000002,"d":"¥194.20"}}]
[null,"保险",{"$f":"类别汇总","v":{"v":0,"d":"¥0.00"}}]
[null,"抵押贷款",{"$f":"类别汇总","v":{"v":961.77,"d":"¥961.77"}}]
[null,"其他",{"$f":"类别汇总","v":{"v":53.65,"d":"¥53.65"}}]