{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Using Drop Down List","Using Check Box","Using Sort Option","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Homework List"]
[]
[null,"Date","Subject Name","Status",null,"Status"]
[null,"2022-01-01","Math",null,null,"On Going"]
[null,"2022-01-02","Physics",null,null,"Pending "]
[null,"2022-01-03","Chemistry",null,null,"Complete"]
[null,"2022-01-04","Biology"]
[null,"2022-01-05","History"]
[null,"2022-01-06","Literature"]
[null,"2022-01-07","Sociology"]
[null,"2022-01-08","Geology"]
[null,"2022-01-09","Economics"]
[null,"2022-01-10","Accounting"]

{"sheet":"Using Drop Down List","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Drop Down List"]
[]
[null,"Date","Subject Name","Status",null,"Status"]
[null,"2022-01-01","Math","On Going",null,"On Going"]
[null,"2022-01-02","Physics","Complete",null,"Pending "]
[null,"2022-01-03","Chemistry","Pending ",null,"Complete"]
[null,"2022-01-04","Biology","Pending "]
[null,"2022-01-05","History","Complete"]
[null,"2022-01-06","Literature","Complete"]
[null,"2022-01-07","Sociology","On Going"]
[null,"2022-01-08","Geology","Pending "]
[null,"2022-01-09","Economics","Pending "]
[null,"2022-01-10","Accounting","On Going"]

{"sheet":"Using Check Box","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Check Box"]
[]
[null,"Date","Subject Name","Status"]
[null,"2022-01-01","Math"]
[null,"2022-01-02","Physics"]
[null,"2022-01-03","Chemistry"]
[null,"2022-01-04","Biology"]
[null,"2022-01-05","History"]
[null,"2022-01-06","Literature"]
[null,"2022-01-07","Sociology"]
[null,"2022-01-08","Geology"]
[null,"2022-01-09","Economics"]
[null,"2022-01-10","Accounting"]

{"sheet":"Using Sort Option","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Sort Option"]
[]
[null,"Date","Subject Name","Status",null,"Status"]
[null,"2022-01-01","Math","Complete",null,"On Going"]
[null,"2022-01-02","Physics","On Going",null,"Pending "]
[null,"2022-01-03","Chemistry","Pending ",null,"Complete"]
[null,"2022-01-04","Biology","Complete"]
[null,"2022-01-05","History","Pending "]
[null,"2022-01-06","Literature","Pending "]
[null,"2022-01-07","Sociology","Complete"]
[null,"2022-01-08","Geology","Pending "]
[null,"2022-01-09","Economics","On Going"]
[null,"2022-01-10","Accounting","Complete"]

{"sheet":"VBA Code","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Code"]
[]
[null,"Date","Project ID","Project Name","Priority","Status",null,"Priority","Weightage"]
[null,"2022-01-01","*119*1","P101","High","ü",null,"High",5]
[null,"2022-02-01","*119*2","P102","Low","ü",null,"Medium",3]
[null,"2022-03-01","*119*3","P103","Medium",null,null,"Low",1]
[null,"2022-04-01","*119*4","P104","High","ü"]
[null,"2022-05-01","*119*5","P105","High",null,null,"Status Sign","ü"]
[null,"2022-06-01","*119*6","P106","Medium","ü"]
[null,"2022-07-01","*119*7","P107","Low",null,null,"Total Activities",{"$f":"COUNTIF($D$5:$D$14,\"<>\")","v":10}]
[null,"2022-08-01","*119*8","P108","Medium","ü",null,"Completed Score",{"$f":"COUNTIFS($E$5:$E$14,$H$5,$F$5:$F$14,$I$9)*$I$5+COUNTIFS($E$5:$E$14,$H$6,$F$5:$F$14,$I$9)*$I$6+COUNTIFS($E$5:$E$14,$H$7,$F$5:$F$14,$I$9)*$I$7","v":22}]
[null,"2022-09-01","*119*9","P109","Low",null,null,"Total Score",{"$f":"COUNTIF($E$5:$E$14,$H$5)*$I$5+COUNTIF($E$5:$E$14,$H$6)*$I$6+COUNTIF($E$5:$E$14,$H$7)*$I$7","v":32}]
[null,"2022-10-01","*119*10","P110","High","ü",null,"Percent Completed",{"$f":"IFERROR(I12/I13,0)","v":0.6875}]