{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Aged Debtors Report April 2023"],"not_rendered":{"charts":1,"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":"Aged Debtors Report April 2023","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Aged Debtors Report April 2023"]
["Name","Total Due","0 -30","31 – 60","61 – 90","91 – 180","> 181"]
["ABC Pty Ltd",39700,null,17650,null,22050]
["Shaw & Shaw",52000,52000]
["McKay Services",44950,null,26050,18900]
["Simply Strategic",26250,26250]
["Building Solutions Pty Ltd",32650,null,null,null,null,32650]
["Document Geniuses",7250,7250]
["Fix Yourself Pty Ltd",25080,8750,9230,7100]
["Dynamic Design",28900,null,28900]
["Timely Transactions Pty Ltd",27700,null,null,15200,12500]
["Totals",284480,94250,81830,41200,34550,32650]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," Providing the information in a chart will make it easier for your manager to understand it at a glance."]
[]
[null,null,null,null,null,"Adjust the colour of monies owed between 0-30 days by right clicking on the relevant segment in the chart, and changing the colour to green"]
[null,null,null,null,null,"Adjust the colour of monies owed between 31-60 days by right clicking on the relevant segment in the chart, and changing the colour to yellow"]
[null,null,null,null,null,"Adjust the colour of monies owed between 61-90 days by right clicking on the relevant segment in the chart, and changing the colour to orange"]
[null,null,null,null,null,"Adjust the colour of monies owed between 91-180 days by right clicking on the relevant segment in the chart, and changing the colour to red"]
[null,null,null,null,null,"Adjust the colour of monies owed for greater than 181 days by right clicking on the relevant segment in the chart, and changing the colour to black"]