{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["菜单","账户信息","科目信息","收支录入","账户余额","账务查询","账户流水查询","使用说明"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"菜单","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"账户信息","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["账户名称类别"]
["账号","类别"]
["888888","建行"]
["999999","农行"]
["666666","工行"]
["777777","支付宝"]
["555555","微信"]

{"sheet":"科目信息","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["科目信息"]
["凭证类别",null,"科目类别"]
["收款",null,"型材床"]
["付款",null,"运输费"]
["转账",null,"公寓铁床"]

{"sheet":"收支录入","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,null,"收支录入"]
["日期","凭证类别","凭证字号","类别（科目）","摘要","收入","支出","账户"]
["2017-11-06","收款",null,"型材床","木纹带钢",30000,null,"建行"]
["2017-11-07","收款",null,"运输费","广州珠江学院",900,null,"农行"]
["2017-11-08","付款",null,"公寓铁床","广州珠江学院",null,8500,"建行"]

{"sheet":"账户余额","index":4,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
["账  户  余  额  表"]
["账户账号","账户名称","期初余额",{"$f":"\"合计：\"& SUM(D4:D900)","v":"合计：30000"},{"$f":"\"合计：\"& SUM(E4:E900)","v":"合计：8500"},{"$f":"\"合计：\"& SUM(F4:F900)","v":"合计：71500"}]
[null,null,null,"收    入","支    出","余     额"]
["888888",{"$f":"IFERROR(VLOOKUP(A4,账户信息!A:B,2,0),\"-\")","v":"建行"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B4,收支录入!F:F)","v":30000},{"$f":"SUMIF(收支录入!H:H,账户余额!B4,收支录入!G:G)","v":8500},{"$f":"C4+D4-E4","v":21500}]
["666666",{"$f":"IFERROR(VLOOKUP(A5,账户信息!A:B,2,0),\"-\")","v":"工行"},50000,{"$f":"SUMIF(收支录入!H:H,账户余额!B5,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B5,收支录入!G:G)","v":0},{"$f":"C5+D5-E5","v":50000}]
[null,{"$f":"IFERROR(VLOOKUP(A6,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B6,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B6,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A7,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B7,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B7,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A8,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B8,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B8,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A9,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B9,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B9,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A10,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B10,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B10,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A11,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B11,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B11,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A12,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B12,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B12,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A13,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B13,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B13,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A14,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B14,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B14,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A15,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B15,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B15,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A16,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B16,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B16,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A17,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B17,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B17,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A18,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B18,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B18,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A19,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B19,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B19,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A20,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B20,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B20,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A21,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B21,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B21,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A22,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B22,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B22,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A23,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B23,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B23,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A24,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B24,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B24,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A25,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B25,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B25,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A26,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B26,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B26,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A27,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B27,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B27,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A28,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B28,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B28,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A29,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B29,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B29,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A30,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B30,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B30,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A31,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B31,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B31,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A32,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B32,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B32,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A33,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B33,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B33,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A34,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B34,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B34,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A35,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B35,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B35,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A36,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B36,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B36,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A37,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B37,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B37,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A38,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B38,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B38,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A39,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B39,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B39,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A40,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B40,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B40,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A41,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B41,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B41,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A42,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B42,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B42,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A43,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B43,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B43,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A44,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B44,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B44,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A45,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B45,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B45,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A46,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B46,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B46,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A47,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B47,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B47,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A48,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B48,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B48,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A49,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B49,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B49,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A50,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B50,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B50,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A51,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B51,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B51,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A52,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B52,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B52,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A53,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B53,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B53,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A54,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B54,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B54,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A55,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B55,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B55,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A56,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B56,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B56,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A57,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B57,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B57,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A58,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B58,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B58,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A59,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B59,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B59,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A60,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B60,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B60,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A61,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B61,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B61,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A62,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B62,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B62,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A63,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B63,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B63,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A64,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B64,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B64,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A65,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B65,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B65,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A66,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B66,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B66,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A67,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B67,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B67,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A68,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B68,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B68,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A69,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B69,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B69,收支录入!G:G)","v":0},{"$f":"C69+D69-E69","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A70,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B70,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B70,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A71,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B71,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B71,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A72,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B72,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B72,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A73,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B73,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B73,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A74,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B74,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B74,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A75,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B75,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B75,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A76,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B76,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B76,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A77,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B77,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B77,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A78,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B78,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B78,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A79,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B79,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B79,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A80,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B80,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B80,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A81,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B81,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B81,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A82,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B82,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B82,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A83,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B83,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B83,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A84,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B84,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B84,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A85,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B85,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B85,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A86,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B86,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B86,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A87,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B87,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B87,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A88,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B88,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B88,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A89,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B89,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B89,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A90,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B90,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B90,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A91,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B91,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B91,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A92,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B92,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B92,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A93,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B93,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B93,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A94,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B94,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B94,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A95,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B95,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B95,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A96,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B96,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B96,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A97,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B97,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B97,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A98,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B98,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B98,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A99,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B99,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B99,收支录入!G:G)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A100,账户信息!A:B,2,0),\"-\")","v":"-"},null,{"$f":"SUMIF(收支录入!H:H,账户余额!B100,收支录入!F:F)","v":0},{"$f":"SUMIF(收支录入!H:H,账户余额!B100,收支录入!G:G)","v":0},0]

{"sheet":"账务查询","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["日期","凭证类别","凭证字号","类别（科目）","摘要","收入","支出","账户"]
["2017-11-06","收款",null,"型材床","木纹带钢",30000,null,"建行"]
["2017-11-07","收款",null,"运输费","广州珠江学院",900,null,"农行"]
["2017-11-08","付款",null,"公寓铁床","广州珠江学院",null,8500,"建行"]

{"sheet":"账户流水查询","index":6,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["日期","凭证类别","凭证字号","类别（科目）","摘要","收入","支出","账户"]
["2017-11-06","收款",null,"型材床","木纹带钢",30000,null,"建行"]
["2017-11-07","收款",null,"运输费","广州珠江学院",900,null,"农行"]
["2017-11-08","付款",null,"公寓铁床","广州珠江学院",null,8500,"建行"]

{"sheet":"使用说明","index":7,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"使  用  说  明"]