{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet3","Sheet2","Sheet4"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Sheet1","index":0,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Write Task Filter Here"]
["Sr.\nNo.","Task Description","Client Group","Deadline","Where pending?"]
[1,"Example Task 1","Ambani Grp","2026-03-20","Accountant",null,null,null,"Accountant"]
[{"$f":"IF(B4=\"\",\"\",A3+1)","v":2},"Example Task 2","Tata Grp",{"$f":"TODAY()","v":"2026-03-25"},"On our part.",null,null,null,"On our part."]
[{"$f":"IF(B5=\"\",\"\",A4+1)","v":3},"Example Task 3","Jackson Grp","2035-03-31","On Client part.",null,null,null,"On Client part."]
[4,"Example Task 4","Mittal Grp","2035-03-31","On Govt. Part.",null,null,null,"On Govt. Part."]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B69=\"\",\"\",A68+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Sheet3","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["IN EXCEL 365, A2 CELL \"Sr. No.\", IN CELL B2 \"Details\", IN CELL C2, \"Client Group\", IN CELL D2 \"Deadline\", IN CELL E2 \"Where pending?\". These are the titles of the columns. write a macro to sort column titled as \" Where pending?\" in ascending order. Sort till row number 105. Do not sort column A values."]

{"sheet":"Sheet2","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Total 'count' by 'Where pending?'"]
[]
[null,null,"Where pending?","Sum of count"]
[null,null,"On our part.",30]
[null,null,"On Client part.",17]
[null,null,"Accountant",1]
[null,null,"On Govt. Part.",1]
[null,null,"(blank)",0]
[null,null,"Grand Total",49]

{"sheet":"Sheet4","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Distribution of 'Where pending?'"]
[]
[null,null,"Where pending?","Count of Where pending?"]
[null,null,"On our part.",1]
[null,null,"Accountant",1]
[null,null,"On Client part.",1]
[null,null,"On Govt. Part.",1]
[null,null,"(blank)"]
[null,null,"Grand Total",4]