{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["大家来找茬","数据处理(借贷方转发生额)","数据处理(银行对账专用)"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":2,"defined_names":35,"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":440,"n_cols":2,"rows_kept":440,"cut":false,"hidden":false,"merged":[]}
["待比较","比较"]
[-9000,-9000]
[5000000,200]
[640729,-30000]
[200,-40000]
[200,-112000]
[200,250]
[-30000,-80000]
[-40000,-24630]
[11520,5000000]
[-112000,640729]
[250,200]
[-80000,11520.01]
[-24630,200]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-80000,-80000]
[-24630,-24630]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[-9000,-40000]
[5000000,11520]
[640729,-112000]
[200,250]
[200,-80000]
[200,-9000]
[-30000,5000000]
[-40000,640729]
[11520,200]
[-112000,200]
[250,200]
[-80000,-30000]
[-24630,-40000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-80000,-80000]
[-24630,-24630]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-80000,-80000]
[-24630,-24630]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[-9000,-40000]
[5000000,11520]
[640729,-112000]
[200,250]
[200,-80000]
[200,-9000]
[-30000,5000000]
[-40000,640729]
[11520,200]
[-112000,200]
[250,200]
[-80000,-30000]
[-24630,-40000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-80000,-80000]
[-24630,-24630]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-80000,-80000]
[-24630,-24630]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[-9000,-40000]
[5000000,11520]
[640729,-112000]
[200,250]
[200,-80000]
[200,-9000]
[-30000,5000000]
[-40000,640729]
[11520,200]
[-112000,200]
[250,200]
[-80000,-30000]
[-24630,-40000]
[-9000,-9000]
[5000000,5000000]
[640729,640729]
[200,200]
[200,200]
[200,200]
[-30000,-30000]
[-40000,-40000]
[11520,11520]
[-112000,-112000]
[250,250]
[-9000,-80000]
[5000000,-24630]
[640729,-9000]
[200,5000000]
[200,640729]
[200,200]
[-30000,200]
[-40000,200]
[11520,-30000]
[-112000,-40000]
[250,11520]
[-80000,-112000]
[-9000,250]
[5000000,-9000]
[640729,5000000]
[200,640729]
[200,200]
[200,200]
[-30000,200]
[-40000,-30000]
[11520,-40000]
[-112000,11520]
[250,-112000]
[-80000,250]
[-24630,-80000]
[null,-9000]
[null,5000000]
[null,640729]
[null,200]
[null,200]
[null,200]
[null,-30000]
[null,-40000]
[null,11520]
[null,-112000]
[null,250]
[null,-80000]
[null,-24630]

{"sheet":"数据处理(借贷方转发生额)","index":1,"n_rows":441,"n_cols":4,"rows_kept":441,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3]]}
["数据1",null,"数据2"]
["借方","贷方","借方","贷方"]
[null,9000,null,9000]
[5000000,null,200]
[640729,null,null,30000]
[200,null,null,40000]
[200,null,null,112000]
[200,null,250]
[null,30000,null,80000]
[null,40000,null,24630]
[11520,null,5000000]
[null,112000,640729]
[250,null,200]
[null,80000,11520.01]
[null,24630,200]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,80000,null,80000]
[null,24630,null,24630]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[null,9000,null,40000]
[5000000,null,11520]
[640729,null,null,112000]
[200,null,250]
[200,null,null,80000]
[200,null,null,9000]
[null,30000,5000000]
[null,40000,640729]
[11520,null,200]
[null,112000,200]
[250,null,200]
[null,80000,null,30000]
[null,24630,null,40000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,80000,null,80000]
[null,24630,null,24630]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,80000,null,80000]
[null,24630,null,24630]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[null,9000,null,40000]
[5000000,null,11520]
[640729,null,null,112000]
[200,null,250]
[200,null,null,80000]
[200,null,null,9000]
[null,30000,5000000]
[null,40000,640729]
[11520,null,200]
[null,112000,200]
[250,null,200]
[null,80000,null,30000]
[null,24630,null,40000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,80000,null,80000]
[null,24630,null,24630]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,80000,null,80000]
[null,24630,null,24630]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[null,9000,null,40000]
[5000000,null,11520]
[640729,null,null,112000]
[200,null,250]
[200,null,null,80000]
[200,null,null,9000]
[null,30000,5000000]
[null,40000,640729]
[11520,null,200]
[null,112000,200]
[250,null,200]
[null,80000,null,30000]
[null,24630,null,40000]
[null,9000,null,9000]
[5000000,null,5000000]
[640729,null,640729]
[200,null,200]
[200,null,200]
[200,null,200]
[null,30000,null,30000]
[null,40000,null,40000]
[11520,null,11520]
[null,112000,null,112000]
[250,null,250]
[null,9000,null,80000]
[5000000,null,null,24630]
[640729,null,null,9000]
[200,null,5000000]
[200,null,640729]
[200,null,200]
[null,30000,200]
[null,40000,200]
[11520,null,null,30000]
[null,112000,null,40000]
[250,null,11520]
[null,80000,null,112000]
[null,9000,250]
[5000000,null,null,9000]
[640729,null,5000000]
[200,null,640729]
[200,null,200]
[200,null,200]
[null,30000,200]
[null,40000,null,30000]
[11520,null,null,40000]
[null,112000,11520]
[250,null,null,112000]
[null,80000,250]
[null,24630,null,80000]
[null,null,null,9000]
[null,null,5000000]
[null,null,640729]
[null,null,200]
[null,null,200]
[null,null,200]
[null,null,null,30000]
[null,null,null,40000]
[null,null,11520]
[null,null,null,112000]
[null,null,250]
[null,null,null,80000]
[null,null,null,24630]

{"sheet":"数据处理(银行对账专用)","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3]]}
["银行对账单",null,"银行明细账"]
["借方发生额(支取)","贷方发生额(收入)","借方","贷方"]
[0,9000,9000]
[5000000,0,null,5000000.01]
[640729,0,null,640729]
[200,0,null,200]
[200,0,null,200]
[200,0,null,200]
[0,30000,40000.01,0]
[0,40000,30000,0]
[11520,0,null,11520]
[0,112000,112000,0]
[250,0,null,250]
[0,80000,80000,0]
[0,24630,24630]