{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Approach 1","Approach 2","Approach 3","Approach 4","Criteria based"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Marks Distribution Table"]
[]
[null,"Name","Subject","Marks"]
[null,"Alan","Physics",90]
[null,"Alan","Chemistry",95]
[null,"Frank","Geography",86]
[null,"James","Biology",76]
[null,"John","Ethics",92]
[null,"Alan","Maths",78]
[null,"Frank","Language",75]
[null,"George","General Science",82]
[null,"George","Ethics",65]

{"sheet":"Approach 1","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Marks Distribution Table"]
[]
[null,"Name","Subject","Marks",null,"Name","Subject","Marks"]
[null,"Alan","Physics",90,null,"Alan",null,263]
[null,"Alan","Chemistry",95,null,"Frank",null,161]
[null,"Frank","Geography",86,null,"James",null,76]
[null,"James","Biology",76,null,"John",null,92]
[null,"John","Ethics",92,null,"George",null,147]
[null,"Alan","Maths",78]
[null,"Frank","Language",75]
[null,"George","General Science",82]
[null,"George","Ethics",65]

{"sheet":"Approach 2","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Marks Distribution Table"]
[]
[null,"Name","Subject","Marks","Merged Rows"]
[null,"Alan","Physics",90,{"$f":"IF(B6=B5,E5&\", \"&C6,C6)","v":"Physics"}]
[null,"Alan","Chemistry",95,{"$f":"IF(B7=B6,E6&\", \"&C7,C7)","v":"Physics, Chemistry"}]
[null,"Frank","Geography",86,"Geography"]
[null,"James","Biology",76,"Biology"]
[null,"John","Ethics",92,"Ethics"]
[null,"Alan","Maths",78,"Maths"]
[null,"Frank","Language",75,"Language"]
[null,"George","General Science",82,"General Science"]
[null,"George","Ethics",65,"General Science, Ethics"]

{"sheet":"Approach 3","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3],[5,1,6,1]]}
[]
[]
[null,"Marks Distribution Table"]
[]
[null,"Name","Subject","Marks"]
[null,"Alan","Physics",90]
[null,null,"Chemistry",95]
[null,"Frank","Geography",86]
[null,"James","Biology",76]
[null,"John","Ethics",92]
[null,"Alan","Maths",78]
[null,"Frank","Language",75]
[null,"George","General Science",82]
[null,"George","Ethics",65]

{"sheet":"Approach 4","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3],[5,1,7,1]]}
[]
[]
[null,"Marks Distribution Table"]
[]
[null,"Name","Subject","Marks"]
[null,"Alan","Physics",90]
[null,null,"Chemistry",95]
[null,null,"Maths",78]
[null,"Frank","Geography",86]
[null,"Frank","Language",75]
[null,"George","General Science",82]
[null,"George","Ethics",65]
[null,"James","Biology",76]
[null,"John","Ethics",92]

{"sheet":"Criteria based","index":5,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Merging Rows Based on Criteria"]
[]
[null,"Name","Game","Points",null,"Combined","Merging Rows"]
[null,"John","Basketball",35,null,{"$f":"B6&\" \"&COUNTIF($B$6:$B6,B6)","v":"John 1"},{"$f":"IF($B6&\" \"&1=F6, INDEX(C:C,MATCH($B6&\" \"&1,F:F,0))&\" \"&IFERROR(INDEX(C:C,MATCH($B6&\" \"&2,F:F,0)),\"\")&\" \"&IFERROR(INDEX(C:C,MATCH($B6&\" \"&3,F:F,0)),\"\")&\" \"&IFERROR(INDEX(C:C,MATCH($B6&\" \"&4,F:F,0)),\"\"),\"\")","v":"Basketball Hockey Pool "}]
[null,"James","Basketball",42,null,{"$f":"B7&\" \"&COUNTIF($B$6:$B7,B7)","v":"James 1"},"Basketball Hockey Pool "]
[null,"Frank","Ragbi",48,null,{"$f":"B8&\" \"&COUNTIF($B$6:$B8,B8)","v":"Frank 1"},"Ragbi Basketball  "]
[null,"James","Hockey",52,null,{"$f":"B9&\" \"&COUNTIF($B$6:$B9,B9)","v":"James 2"},""]
[null,"James","Pool",42,null,{"$f":"B10&\" \"&COUNTIF($B$6:$B10,B10)","v":"James 3"},""]
[null,"George","Hockey",32,null,{"$f":"B11&\" \"&COUNTIF($B$6:$B11,B11)","v":"George 1"},"Hockey   "]
[null,"Bell","Ragbi",30,null,{"$f":"B12&\" \"&COUNTIF($B$6:$B12,B12)","v":"Bell 1"},"Ragbi   "]
[null,"John","Hockey",45,null,{"$f":"B13&\" \"&COUNTIF($B$6:$B13,B13)","v":"John 2"},""]
[null,"John","Pool",41,null,{"$f":"B14&\" \"&COUNTIF($B$6:$B14,B14)","v":"John 3"},""]
[null,"Frank","Basketball",48,null,{"$f":"B15&\" \"&COUNTIF($B$6:$B15,B15)","v":"Frank 2"},""]