{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Question","Start","Bill","Mike"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Question","index":0,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Weight","Score",null,null,null,null,null,null,null,null,"Rank"]
[182,5,{"$f":"RANK(A2,IF($B$2:$B$12=B2,A$2:A$12,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--(B2=$B$2:$B$12),--(A2<$A$2:$A$12))+RANK(B2,$B$2:$B$12,0)","v":6}]
[184,2,{"$f":"RANK(A3,IF($B$2:$B$12=B3,A3,0))","v":{"$error":"#VALUE!"}},null,"IF there is a tie in the scores, then award the highest",null,null,null,null,null,{"$f":"SUMPRODUCT(--(B3=$B$2:$B$12),--(A3<$A$2:$A$12))+RANK(B3,$B$2:$B$12,0)","v":10}]
[205,7,{"$f":"RANK(A4,IF($B$2:$B$12=B4,A4,0))","v":{"$error":"#VALUE!"}},null,"rank to the largest weight",null,null,null,null,null,3]
[199,1,{"$f":"RANK(A5,IF($B$2:$B$12=B5,A5,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,11]
[188,7,{"$f":"RANK(A6,IF($B$2:$B$12=B6,A6,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,5]
[185,2,{"$f":"RANK(A7,IF($B$2:$B$12=B7,A7,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,8]
[190,7,{"$f":"RANK(A8,IF($B$2:$B$12=B8,A8,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,4]
[188,2,{"$f":"RANK(A9,IF($B$2:$B$12=B9,A9,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,7]
[207,7,{"$f":"RANK(A10,IF($B$2:$B$12=B10,A10,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,2]
[187,9,{"$f":"RANK(A11,IF($B$2:$B$12=B11,A11,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,1]
[185,2,{"$f":"RANK(A12,IF($B$2:$B$12=B12,A12,0))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[]
["Weight","Score",null,"Rank",null,null,null,"SP","Rank","Add"]
[182,5,null,{"$f":"RANK(B20,$B$20:$B$30,0)","v":6},null,null,null,{"$f":"SUMPRODUCT(--(B20=$B$20:$B$30),--(A20<$A$20:$A$30))","v":0},{"$f":"RANK(B20,$B$20:$B$30,0)","v":6},{"$f":"I20+H20","v":6}]
[184,2,null,{"$f":"RANK(B21,$B$20:$B$30,0)","v":7},null,null,null,{"$f":"SUMPRODUCT(--(B21=$B$20:$B$30),--(A21<$A$20:$A$30))","v":3},7,10]
[205,7,null,2,null,null,null,1,2,3,null,3]
[199,1,null,11,null,null,null,0,11,11]
[188,7,null,2,null,null,null,3,2,5,null,5]
[185,2,null,7,null,null,null,1,7,8]
[190,7,null,2,null,null,null,2,2,4,null,4]
[188,2,null,7,null,null,null,0,7,7]
[207,7,null,2,null,null,1,0,2,2,null,2]
[187,9,null,1,null,null,null,0,1,1]
[185,2,null,7,null,null,null,1,7,8]

{"sheet":"Start","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["IF there is a tie in the scores, then award the highest"]
["rank to the largest weight"]
[]
["Entrant","Weight","Score","Rank"]
["F",185,2]
["H",188,2]
["E",188,7]
["B",184,2]
["C",205,7]
["A",182,5]
["K",185,2]
["J",187,9]
["D",199,1]
["I",207,7]
["G",190,7]

{"sheet":"Bill","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["IF there is a tie in the scores, then award the highest"]
["rank to the largest weight"]
[]
["Entrant","Weight","Score","Regular Rank","Usual Solution","Adder"]
["I",207,7,{"$f":"RANK(C5,$C$5:$C$15)","v":2},{"$f":"RANK(C5,$C$5:$C$15)+COUNTIF(C$4:C4,C5)","v":2},{"$f":"RANK(B5,IF($C$5:$C$15=C5,$B$5:$B$15,0))","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(C$4:C4,C5)","v":0}]
["C",205,7,2,{"$f":"RANK(C6,$C$5:$C$15)+COUNTIF(C$4:C5,C6)","v":3},null,{"$f":"COUNTIF(C$4:C5,C6)","v":1}]
["D",199,1,11,{"$f":"RANK(C7,$C$5:$C$15)+COUNTIF(C$4:C6,C7)","v":11}]
["G",190,7,2,{"$f":"RANK(C8,$C$5:$C$15)+COUNTIF(C$4:C7,C8)","v":4},null,{"$f":"COUNTIF(C$4:C7,C8)","v":2}]
["E",188,7,2,{"$f":"RANK(C9,$C$5:$C$15)+COUNTIF(C$4:C8,C9)","v":5},null,{"$f":"COUNTIF(C$4:C8,C9)","v":3}]
["H",188,2,7,{"$f":"RANK(C10,$C$5:$C$15)+COUNTIF(C$4:C9,C10)","v":7}]
["J",187,9,1,{"$f":"RANK(C11,$C$5:$C$15)+COUNTIF(C$4:C10,C11)","v":1}]
["F",185,2,7,{"$f":"RANK(C12,$C$5:$C$15)+COUNTIF(C$4:C11,C12)","v":8}]
["K",185,2,7,{"$f":"RANK(C13,$C$5:$C$15)+COUNTIF(C$4:C12,C13)","v":9}]
["B",184,2,7,{"$f":"RANK(C14,$C$5:$C$15)+COUNTIF(C$4:C13,C14)","v":10}]
["A",182,5,6,{"$f":"RANK(C15,$C$5:$C$15)+COUNTIF(C$4:C14,C15)","v":6}]

{"sheet":"Mike","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["IF there is a tie in the scores, then award the highest"]
["rank to the largest weight"]
[]
["Entrant","Weight","Score","Rank","What do we need to add?","What do we need to add?","Rank Scores Considering Weight"]
["F",185,2,{"$f":"RANK(C5,$C$5:$C$15,0)","v":7},null,{"$f":"SUMPRODUCT(--(C5=$C$5:$C$15),--(B5<$B$5:$B$15))","v":1},{"$f":"_xlfn.RANK.EQ(C5,$C$5:$C$15,0)+SUMPRODUCT(--(C5=$C$5:$C$15),--(B5<$B$5:$B$15))","v":8}]
["H",188,2,{"$f":"RANK(C6,$C$5:$C$15,0)","v":7},null,0,{"$f":"_xlfn.RANK.EQ(C6,$C$5:$C$15,0)+SUMPRODUCT(--(C6=$C$5:$C$15),--(B6<$B$5:$B$15))","v":7}]
["E",188,7,2,3,{"$f":"SUMPRODUCT(--(C7=$C$5:$C$15),--(B7<$B$5:$B$15))","v":3},5]
["B",184,2,7,null,{"$f":"SUMPRODUCT(--(C8=$C$5:$C$15),--(B8<$B$5:$B$15))","v":3},10]
["C",205,7,2,1,1,{"$f":"_xlfn.RANK.EQ(C9,$C$5:$C$15,0)+SUMPRODUCT(--(C9=$C$5:$C$15),--(B9<$B$5:$B$15))","v":3}]
["A",182,5,6,null,0,6]
["K",185,2,7,null,1,8]
["J",187,9,1,null,0,1]
["D",199,1,11,null,0,11]
["I",207,7,2,0,0,2]
["G",190,7,2,2,2,4]