{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overview","Dataset","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Overview","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7],[0,1,0,7]]}
[null,"Overview of Bank Reconciliation"]
[]
[null,"Cheque Book Data",null,null,null,"Bank Data"]
[null,"Date","Cheque No","Amount","Matching Cheque","Date","Cheque No","Amount"]
[null,"2020-08-05",1312001,98531,1312001,"2020-08-09",1312005,77698]
[null,"2020-08-06",1312002,44049,1312002,"2020-08-06",1312001,98531]
[null,"2020-08-07",1312003,85104,1312003,"2020-08-10",1312006,70698]
[null,"2020-08-08",1312004,71847,1312004,"2020-08-15",1312002,55421]
[null,"2020-08-09",1312005,77698,1312005,"2020-08-17",1312008,91702]
[null,"2020-08-10",1312006,70698,1312006,"2020-08-19",1312003,85104]
[null,"2020-08-11",1312007,75460,1312007,"2020-08-20",1312007,75460]
[null,"2020-08-12",1312008,91702,1312008,"2020-08-21",1312004,71847]

{"sheet":"Dataset","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,3],[2,5,2,7]]}
[null,"Creation of Dataset"]
[]
[null,"Cheque Book Data",null,null,null,"Bank Data"]
[null,"Date","Cheque No","Amount","Matching Cheque","Date","Cheque No","Amount"]
[null,"2020-08-05",1312001,98531,null,"2020-08-09",1312005,77698]
[null,"2020-08-06",1312002,44049,null,"2020-08-06",1312001,98531]
[null,"2020-08-07",1312003,85104,null,"2020-08-10",1312006,70698]
[null,"2020-08-08",1312004,71847,null,"2020-08-15",1312002,55421]
[null,"2020-08-09",1312005,77698,null,"2020-08-17",1312008,91702]
[null,"2020-08-10",1312006,70698,null,"2020-08-19",1312003,85104]
[null,"2020-08-11",1312007,75460,null,"2020-08-20",1312007,75460]
[null,"2020-08-12",1312008,91702,null,"2020-08-21",1312004,71847]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,3],[2,5,2,7]]}
[null,"Run VBA to Make Bank Reconciliation"]
[]
[null,"Cheque Book Data",null,null,null,"Bank Data"]
[null,"Date","Cheque No","Amount","Matching Cheque","Date","Cheque No","Amount"]
[null,"2020-08-05",1312001,98531,1312001,"2020-08-09",1312005,77698]
[null,"2020-08-06",1312002,44049,1312002,"2020-08-06",1312001,98531]
[null,"2020-08-07",1312003,85104,1312003,"2020-08-10",1312006,70698]
[null,"2020-08-08",1312004,71847,1312004,"2020-08-15",1312002,55421]
[null,"2020-08-09",1312005,77698,1312005,"2020-08-17",1312008,91702]
[null,"2020-08-10",1312006,70698,1312006,"2020-08-19",1312003,85104]
[null,"2020-08-11",1312007,75460,1312007,"2020-08-20",1312007,75460]
[null,"2020-08-12",1312008,91702,1312008,"2020-08-21",1312004,71847]