{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Original Dataset","Fixed Cell Range","Selected Cell Range","Multiple Columns","Table","Rows of Data","Array"],"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":"Original Dataset","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,6,15,7],[16,0,16,1],[16,6,16,7]]}
[]
[null,"Examination Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+"]

{"sheet":"Fixed Cell Range","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,6,15,7],[16,0,16,1],[16,6,16,7],[1,10,1,13]]}
[]
[null,"Removing Duplicates from Fixed Cell Range",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Selected Cell Range","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13],[15,6,15,7],[16,0,16,1],[16,6,16,7]]}
[]
[null,"Deleting Duplicates from Selected Cell Range",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Brad Milford",161,49,"C",null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,null,null,null,null,null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Multiple Columns","index":3,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13],[15,6,15,7],[16,0,16,1],[16,6,16,7]]}
[]
[null,"Eradicating Duplicates from Multiple Columns",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Table","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13],[15,6,15,7],[16,0,16,1],[16,6,16,7]]}
[]
[null,"Eliminating Duplicates from Table",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Rows of Data","index":5,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13],[15,6,15,7],[16,0,16,1],[16,6,16,7]]}
[]
[null,"Wiping out Duplicates from Rows of Data",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Array","index":6,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,10,1,13],[15,6,15,7],[16,0,16,1],[16,6,16,7],[1,1,1,6]]}
[]
[null,"Deleting Duplicates from Array",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,"Student Name",null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,{"$f":"delete_duplicates(B5:B15)","v":"Frank Orwell"},null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,"David Moyes",null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,"Natalia Austin",null,null,null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A",null,"Angela Hopkins",null,null,null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B",null,"Richard Kettlebrough",null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+",null,"Brad Milford",null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C",null,"Jennifer Marlo",null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C",null,"Shane Thompson",null,null,null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,null,"Shane Thompson",181,94,"A+"]