{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Without Condition","With Condition","VBA"],"not_rendered":{"charts":3,"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":"Without Condition","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,14,1,16]]}
[]
[null," Coloring Scatter Plot without Condition",null,null,null,null,null,null,null,null,null,null,null,null," Do it Yourself"]
[]
[null,"Group","Number of Student","Obtained Marks",null,null,null,null,null,null,null,null,null,null,"Group","Number of Student","Obtained Marks"]
[null,"A",1,5,null,null,null,null,null,null,null,null,null,null,"A",1,5]
[null,"A",3,2,null,null,null,null,null,null,null,null,null,null,"A",3,2]
[null,"A",2,7,null,null,null,null,null,null,null,null,null,null,"A",2,7]
[null,"B",7,3,null,null,null,null,null,null,null,null,null,null,"B",7,3]
[null,"B",3,4,null,null,null,null,null,null,null,null,null,null,"B",3,4]
[null,"B",6,2,null,null,null,null,null,null,null,null,null,null,"B",6,2]
[null,"C",4,8,null,null,null,null,null,null,null,null,null,null,"C",4,8]
[null,"C",2,9,null,null,null,null,null,null,null,null,null,null,"C",2,9]
[null,"C",7,5,null,null,null,null,null,null,null,null,null,null,"C",7,5]

{"sheet":"With Condition","index":1,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,16,1,17]]}
[]
[null,"Coloring Scatter Plot with Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Number of Student","Obtained Marks","Group A","Group B","Group C",null,null,null,null,null,null,null,null,null,null,"Number of Student","Obtained Marks"]
[null,1,5,{"$f":"IF(B5>C5,C5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(B5<C5,C5,NA())","v":5},{"$f":"IF(B5=C5,C5,NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,1,5]
[null,3,2,{"$f":"IF(B6>C6,C6,NA())","v":2},{"$f":"IF(B6<C6,C6,NA())","v":{"$error":"#N/A"}},{"$f":"IF(B6=C6,C6,NA())","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,3,2]
[null,2,7,{"$error":"#N/A"},7,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,2,7]
[null,7,3,3,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,7,3]
[null,3,4,{"$error":"#N/A"},4,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,3,4]
[null,6,2,2,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,6,2]
[null,4,8,{"$error":"#N/A"},8,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,4,8]
[null,2,2,{"$error":"#N/A"},{"$error":"#N/A"},2,null,null,null,null,null,null,null,null,null,null,2,2]
[null,4,1,1,{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,4,1]
[null,6,6,{"$error":"#N/A"},{"$error":"#N/A"},6,null,null,null,null,null,null,null,null,null,null,6,6]

{"sheet":"VBA","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Group","Number of Student","Obtained Marks","Color"]
["A",1,5,"red"]
["A",3,2,"red"]
["A",2,7,"orange"]
["B",7,3,"green"]