{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Data","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Category","Customer Name","Customer Code","Amount Disbursed Date","Amount Disbursed","Interest","Total to be re-paid","LSR Name","Amount Repaid","Remaining Outstanding","Due Date","Due Amount","Last paid Date"]
["Computers","Smith","#000001","2019-09-11",20000,3000,23000,"H Winsor",3400,19600,"2020-01-07",3400,"2020-11-06"]
["Cameras","Jones","#000002","2019-09-15",15000,2000,17000,"M Jones",2850,14150,"2020-01-15",950,"2020-12-16"]
["TV & Video Music","Lisel","#000003","2019-09-07",20000,3000,23000,"J Smith",4900,18100,"2020-01-08",1900,"2020-12-06"]
["Cell phones","Targer","#000004","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Computers","Myran","#000005","2019-09-11",20000,3000,23000,"H Winsor",3400,19600,"2020-01-07",3400,"2020-11-06"]
["Cameras","Smith","#000006","2019-09-15",15000,2000,17000,"M Jones",2850,14150,"2020-01-15",950,"2020-12-16"]
["TV & Video Music","Jones","#000007","2019-09-07",20000,3000,23000,"J Smith",4900,18100,"2020-01-08",1900,"2020-12-06"]
["Cell phones","Lisel","#000008","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Computers","Targer","#000009","2019-09-11",20000,3000,23000,"H Winsor",3400,19600,"2020-01-07",3400,"2020-11-06"]
["Cameras","Myran","#000010","2019-09-15",15000,2000,17000,"M Jones",2850,14150,"2020-01-15",950,"2020-12-16"]
["TV & Video Music","Smith","#000011","2019-09-07",20000,3000,23000,"J Smith",4900,18100,"2020-01-08",1900,"2020-12-06"]
["Cell phones","Jones","#000012","2019-10-08",15000,4000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Computers","Lisel","#000013","2019-09-11",20000,3000,23000,"H Winsor",3400,19600,"2020-01-07",3400,"2020-11-06"]
["Cameras","Targer","#000014","2019-09-15",15000,2000,17000,"M Jones",2850,14150,"2020-01-15",950,"2020-12-16"]
["TV & Video Music","Myran","#000015","2019-09-07",20000,3000,23000,"J Smith",4900,18100,"2020-01-08",1900,"2020-12-06"]
["Cell phones","Smith","#000016","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Computers","Jones","#000017","2019-09-11",20000,3000,23000,"H Winsor",3400,19600,"2020-01-07",3400,"2020-11-06"]
["Cameras","Lisel","#000018","2019-09-15",15000,2000,17000,"M Jones",2850,14150,"2020-01-15",950,"2020-12-16"]
["TV & Video Music","Targer","#000019","2019-09-07",20000,3000,23000,"J Smith",4900,18100,"2020-01-08",1900,"2020-12-06"]
["Cell phones","Myran","#000020","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]

{"sheet":"Summary","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Due Date","LSR Name","Interest"]
["2020-01-07","J Smith",">=500"]
[]
["Category","Customer Name","Customer Code","Amount Disbursed Date","Amount Disbursed","Interest","Total to be re-paid","LSR Name","Amount Repaid","Remaining Outstanding","Due Date","Due Amount","Last paid Date"]
["Cell phones","Targer","#000004","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Cell phones","Lisel","#000008","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Cell phones","Jones","#000012","2019-10-08",15000,4000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Cell phones","Smith","#000016","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]
["Cell phones","Myran","#000020","2019-10-08",15000,2000,17000,"J Smith",2850,14150,"2020-01-07",950,"2020-12-06"]