{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","3 icon","5 icon","Blank or non-blank","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":"Dataset","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Record of Marks for Students of \"X\" College"]
[]
[null,"Student ID","Name","Subject","Marks","Remarks"]
[null,1001201,"Emily","Physics",76,"Satisfactory"]
[null,1001202,"Watson","Physics",49,"Medium"]
[null,1001203,"Jack","Chemistry",8,"Poor"]
[null,1001204,"Michael","Maths",4,"Poor"]
[null,1001205,"Lily","Chemistry",21,"Poor"]
[null,1001206,"Katherine","Chemistry",27,"Poor"]
[null,1001207,"John","Maths",90,"Satisfactory"]
[null,1001208,"Peter","Maths",56,"Medium"]
[null,1001209,"Sherlock","Physics",63,"Medium"]
[null,1001210,"Howard","Maths",97,"Satisfactory"]

{"sheet":"3 icon","index":1,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,11,0,16]]}
[null,"Applying 3 Icon Sets",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Student ID","Name","Subject","Marks","Symbol",null,null,null,null,null,"Student ID","Name","Subject","Marks","Remarks","Symbol"]
[null,1001201,"Emily","Physics",76,1,null,null,null,null,null,1001201,"Emily","Physics",76,"Satisfactory"]
[null,1001202,"Watson","Physics",49,0,null,null,null,null,null,1001202,"Watson","Physics",49,"Medium"]
[null,1001203,"Jack","Chemistry",8,-1,null,null,null,null,null,1001203,"Jack","Chemistry",8,"Poor"]
[null,1001204,"Michael","Maths",4,-1,null,null,null,null,null,1001204,"Michael","Maths",4,"Poor"]
[null,1001205,"Lily","Chemistry",21,-1,null,null,null,null,null,1001205,"Lily","Chemistry",21,"Poor"]
[null,1001206,"Katherine","Chemistry",27,-1,null,null,null,null,null,1001206,"Katherine","Chemistry",27,"Poor"]
[null,1001207,"John","Maths",90,1,null,null,null,null,null,1001207,"John","Maths",90,"Satisfactory"]
[null,1001208,"Peter","Maths",56,0,null,null,null,null,null,1001208,"Peter","Maths",56,"Medium"]
[null,1001209,"Sherlock","Physics",63,0,null,null,null,null,null,1001209,"Sherlock","Physics",63,"Medium"]
[null,1001210,"Howard","Maths",97,1,null,null,null,null,null,1001210,"Howard","Maths",97,"Satisfactory"]
[]
[null,"Remarks","Number"]
[null,"Satisfactory",1]
[null,"Medium",0]
[null,"Poor",-1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"5 icon","index":2,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,11,0,16]]}
[null,"Applying 5 Icon Sets",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Student ID","Name","Subject","Marks","Symbol",null,null,null,null,null,"Student ID","Name","Subject","Marks","Remarks","Symbol"]
[null,1001201,"Emily","Physics",76,3,null,null,null,null,null,1001201,"Emily","Physics",76,"Satisfactory"]
[null,1001202,"Watson","Physics",49,2,null,null,null,null,null,1001202,"Watson","Physics",49,"Medium"]
[null,1001203,"Jack","Chemistry",8,1,null,null,null,null,null,1001203,"Jack","Chemistry",8,"Poor"]
[null,1001204,"Michael","Maths",4,1,null,null,null,null,null,1001204,"Michael","Maths",4,"Poor"]
[null,1001205,"Lily","Chemistry",21,1,null,null,null,null,null,1001205,"Lily","Chemistry",21,"Poor"]
[null,1001206,"Katherine","Chemistry",27,1,null,null,null,null,null,1001206,"Katherine","Chemistry",27,"Poor"]
[null,1001207,"John","Maths",90,4,null,null,null,null,null,1001207,"John","Maths",90,"Very Good"]
[null,1001208,"Peter","Maths",56,2,null,null,null,null,null,1001208,"Peter","Maths",56,"Medium"]
[null,1001209,"Sherlock","Physics",63,3,null,null,null,null,null,1001209,"Sherlock","Physics",63,"Satisfactory"]
[null,1001210,"Howard","Maths",97,5,null,null,null,null,null,1001210,"Howard","Maths",97,"Excellent"]
[]
[null,"Remarks","Number"]
[null,"Excellent",5]
[null,"Very Good",4]
[null,"Satisfactory",3]
[null,"Medium",2]
[null,"Poor",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Blank or non-blank","index":3,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,12,0,17]]}
[null,"Icon Sets for Blank or Non-Blank Cells",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Student ID","Name","Subject","Marks","Remarks","Symbol",null,null,null,null,null,"Student ID","Name","Subject","Marks","Remarks","Symbol"]
[null,1001201,"Emily","Physics",76,"Satisfactory",{"$f":"COUNTBLANK(B4:F4)","v":0},null,null,null,null,null,1001201,"Emily","Physics",76,"Satisfactory"]
[null,1001202,null,"Physics",49,"Medium",{"$f":"COUNTBLANK(B5:F5)","v":1},null,null,null,null,null,1001202,null,"Physics",49,"Medium"]
[null,1001203,"Jack","Chemistry",8,"Poor",0,null,null,null,null,null,1001203,"Jack","Chemistry",8,"Poor"]
[null,1001204,null,"Maths",null,"Poor",2,null,null,null,null,null,1001204,null,"Maths",null,"Poor"]
[null,1001205,"Lily","Chemistry",21,"Poor",0,null,null,null,null,null,1001205,"Lily","Chemistry",21,"Poor"]
[null,null,"Katherine","Chemistry",null,null,3,null,null,null,null,null,null,"Katherine","Chemistry"]
[null,1001207,"John","Maths",90,"Satisfactory",0,null,null,null,null,null,1001207,"John","Maths",90,"Satisfactory"]
[null,1001208,"Peter","Maths",56,"Medium",0,null,null,null,null,null,1001208,"Peter","Maths",56,"Medium"]
[null,1001209,"Sherlock","Physics",null,"Medium",1,null,null,null,null,null,1001209,"Sherlock","Physics",null,"Medium"]
[null,1001210,null,null,97,null,3,null,null,null,null,null,1001210,null,null,97]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":4,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,13,0,18]]}
[null,"Using VBA Code",null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Student ID","Name","Subject","Marks","Symbol",null,null,null,null,null,null,null,"Student ID","Name","Subject","Marks","Remarks","Symbol"]
[null,1001201,"Emily","Physics",76,1,null,null,null,null,null,null,null,1001201,"Emily","Physics",76,"Satisfactory"]
[null,1001202,"Watson","Physics",49,0,null,null,null,null,null,null,null,1001202,"Watson","Physics",49,"Medium"]
[null,1001203,"Jack","Chemistry",8,-1,null,null,null,null,null,null,null,1001203,"Jack","Chemistry",8,"Poor"]
[null,1001204,"Michael","Maths",4,-1,null,null,null,null,null,null,null,1001204,"Michael","Maths",4,"Poor"]
[null,1001205,"Lily","Chemistry",21,-1,null,null,null,null,null,null,null,1001205,"Lily","Chemistry",21,"Poor"]
[null,1001206,"Katherine","Chemistry",27,-1,null,null,null,null,null,null,null,1001206,"Katherine","Chemistry",27,"Poor"]
[null,1001207,"John","Maths",90,1,null,null,null,null,null,null,null,1001207,"John","Maths",90,"Satisfactory"]
[null,1001208,"Peter","Maths",56,0,null,null,null,null,null,null,null,1001208,"Peter","Maths",56,"Medium"]
[null,1001209,"Sherlock","Physics",63,0,null,null,null,null,null,null,null,1001209,"Sherlock","Physics",63,"Medium"]
[null,1001210,"Howard","Maths",97,1,null,null,null,null,null,null,null,1001210,"Howard","Maths",97,"Satisfactory"]
[]
[null,"Remarks","Number"]
[null,"Satisfactory",1]
[null,"Medium",0]
[null,"Poor",-1]
[]
[]
[null,null,null,null,null,""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]