{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["dataset","sort by number","sort by cgpa","RankByVBA","diy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Ranking Data in Excel"]
[]
[null,"Name","Score","CGPA"]
[null,"Adam Cole",73,3.12]
[null,"Jay White",76,3.53]
[null,"Jon Moxley",82,3.78]
[null,"Bryan Danielson",85,3.9]
[null,"Andrew Garfield",87,3.86]
[null,"Simon Tucker",70,3.21]
[null,"Fred Wilson",90,4]
[null,"Shane Carwin",74,3.2]

{"sheet":"sort by number","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"SORT by Score"]
[]
[null,"Name","Score","CGPA","Rank"]
[null,{"$f":"_xlfn._xlws.SORT(dataset!B5:D12,2,-1,FALSE)","v":"Fred Wilson"},90,4,{"$f":"RANK(C5,$C$5:$C$12,0)","v":1}]
[null,"Andrew Garfield",87,3.86,{"$f":"RANK(C6,$C$5:$C$12,0)","v":2}]
[null,"Bryan Danielson",85,3.9,3]
[null,"Jon Moxley",82,3.78,4]
[null,"Jay White",76,3.53,5]
[null,"Shane Carwin",74,3.2,6]
[null,"Adam Cole",73,3.12,7]
[null,"Simon Tucker",70,3.21,8]

{"sheet":"sort by cgpa","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"SORT by CGPA"]
[]
[null,"Name","Score","CGPA","Rank"]
[null,{"$f":"_xlfn._xlws.SORT(dataset!B5:D12,3,-1,FALSE)","v":"Fred Wilson"},90,4,{"$f":"RANK(D5,$D$5:$D$12,0)","v":1}]
[null,"Bryan Danielson",85,3.9,{"$f":"RANK(D6,$D$5:$D$12,0)","v":2}]
[null,"Andrew Garfield",87,3.86,3]
[null,"Jon Moxley",82,3.78,4]
[null,"Jay White",76,3.53,5]
[null,"Simon Tucker",70,3.21,6]
[null,"Shane Carwin",74,3.2,7]
[null,"Adam Cole",73,3.12,8]

{"sheet":"RankByVBA","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Name","Score","CGPA","Rank"]
[null,"Fred Wilson",90,3.12,{"$f":"RANK(C2,C:C,0)","v":2}]
[null,"Andrew Garfield",87,3.52,{"$f":"RANK(C3,C:C,0)","v":4}]
[null,"Bryan Danielson",85,3.92,5]
[null,"Alex Mason",83,2.3199999999999998,6]
[null,"Jon Moxley",82,3.72,7]
[null,"Jay White",76,3.12,8]
[null,"Shane Carwin",74,3.52,9]
[null,"Adam Cole",95,4,1]
[null,"Simon Tucker",70,3.28,10]
[null,"Jim Carry",88,3.88,3]

{"sheet":"diy","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Name","Score","CGPA"]
[null,"Adam Cole",73,3.12]
[null,"Jay White",76,3.53]
[null,"Jon Moxley",82,3.78]
[null,"Bryan Danielson",85,3.9]
[null,"Andrew Garfield",87,3.86]
[null,"Simon Tucker",70,3.21]
[null,"Fred Wilson",90,4]
[null,"Shane Carwin",74,3.2]