{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculations","Draw"],"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":"Calculations","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Rand","Unique Rank","Ball Number",null,1,2,3,4,5,6]
[{"$f":"RAND()","v":0.15864434597166888},{"$f":"RANK(A2,$A$2:$A$50)+COUNTIF(A$2:A2,A2)-1","v":34},1]
[{"$f":"RAND()","v":0.74910043052924913},{"$f":"RANK(A3,$A$2:$A$50)+COUNTIF(A$2:A3,A3)-1","v":9},2]
[0.26927181931429511,{"$f":"RANK(A4,$A$2:$A$50)+COUNTIF(A$2:A4,A4)-1","v":27},3]
[0.49285773920115339,{"$f":"RANK(A5,$A$2:$A$50)+COUNTIF(A$2:A5,A5)-1","v":21},4]
[0.21631507922197546,{"$f":"RANK(A6,$A$2:$A$50)+COUNTIF(A$2:A6,A6)-1","v":32},5]
[0.54203513853210405,{"$f":"RANK(A7,$A$2:$A$50)+COUNTIF(A$2:A7,A7)-1","v":16},6]
[0.28829931904581185,{"$f":"RANK(A8,$A$2:$A$50)+COUNTIF(A$2:A8,A8)-1","v":25},7]
[0.84268567048200294,{"$f":"RANK(A9,$A$2:$A$50)+COUNTIF(A$2:A9,A9)-1","v":7},8]
[0.15533344942486704,{"$f":"RANK(A10,$A$2:$A$50)+COUNTIF(A$2:A10,A10)-1","v":36},9]
[0.87677341808170972,{"$f":"RANK(A11,$A$2:$A$50)+COUNTIF(A$2:A11,A11)-1","v":6},10]
[0.70194449176735241,{"$f":"RANK(A12,$A$2:$A$50)+COUNTIF(A$2:A12,A12)-1","v":11},11]
[0.98961890965366262,{"$f":"RANK(A13,$A$2:$A$50)+COUNTIF(A$2:A13,A13)-1","v":2},12]
[0.9962711267395844,{"$f":"RANK(A14,$A$2:$A$50)+COUNTIF(A$2:A14,A14)-1","v":1},13]
[0.21819087167625217,{"$f":"RANK(A15,$A$2:$A$50)+COUNTIF(A$2:A15,A15)-1","v":31},14]
[0.13152864675154152,{"$f":"RANK(A16,$A$2:$A$50)+COUNTIF(A$2:A16,A16)-1","v":39},15]
[0.53597117027403707,{"$f":"RANK(A17,$A$2:$A$50)+COUNTIF(A$2:A17,A17)-1","v":18},16]
[0.19192841297797814,{"$f":"RANK(A18,$A$2:$A$50)+COUNTIF(A$2:A18,A18)-1","v":33},17]
[4.6729254739273807E-2,{"$f":"RANK(A19,$A$2:$A$50)+COUNTIF(A$2:A19,A19)-1","v":47},18]
[0.87857671202728305,{"$f":"RANK(A20,$A$2:$A$50)+COUNTIF(A$2:A20,A20)-1","v":5},19]
[0.13477055584075981,{"$f":"RANK(A21,$A$2:$A$50)+COUNTIF(A$2:A21,A21)-1","v":38},20]
[0.36271464226886485,{"$f":"RANK(A22,$A$2:$A$50)+COUNTIF(A$2:A22,A22)-1","v":22},21]
[0.29537894559535338,{"$f":"RANK(A23,$A$2:$A$50)+COUNTIF(A$2:A23,A23)-1","v":24},22]
[5.4542292793858915E-2,{"$f":"RANK(A24,$A$2:$A$50)+COUNTIF(A$2:A24,A24)-1","v":44},23]
[0.25639515019860382,{"$f":"RANK(A25,$A$2:$A$50)+COUNTIF(A$2:A25,A25)-1","v":29},24]
[0.67072302392016026,{"$f":"RANK(A26,$A$2:$A$50)+COUNTIF(A$2:A26,A26)-1","v":12},25]
[0.26025045231034794,{"$f":"RANK(A27,$A$2:$A$50)+COUNTIF(A$2:A27,A27)-1","v":28},26]
[1.3801241677427911E-2,{"$f":"RANK(A28,$A$2:$A$50)+COUNTIF(A$2:A28,A28)-1","v":49},27]
[4.6907712077239427E-2,{"$f":"RANK(A29,$A$2:$A$50)+COUNTIF(A$2:A29,A29)-1","v":46},28]
[0.12344449886278275,{"$f":"RANK(A30,$A$2:$A$50)+COUNTIF(A$2:A30,A30)-1","v":40},29]
[0.26949533733596842,{"$f":"RANK(A31,$A$2:$A$50)+COUNTIF(A$2:A31,A31)-1","v":26},30]
[6.5308533368415134E-2,{"$f":"RANK(A32,$A$2:$A$50)+COUNTIF(A$2:A32,A32)-1","v":43},31]
[0.59114110095906069,{"$f":"RANK(A33,$A$2:$A$50)+COUNTIF(A$2:A33,A33)-1","v":14},32]
[0.92295446445817853,{"$f":"RANK(A34,$A$2:$A$50)+COUNTIF(A$2:A34,A34)-1","v":4},33]
[0.15847350094337209,{"$f":"RANK(A35,$A$2:$A$50)+COUNTIF(A$2:A35,A35)-1","v":35},34]
[3.7150793656197001E-2,{"$f":"RANK(A36,$A$2:$A$50)+COUNTIF(A$2:A36,A36)-1","v":48},35]
[0.14786896305311847,{"$f":"RANK(A37,$A$2:$A$50)+COUNTIF(A$2:A37,A37)-1","v":37},36]
[0.5548172557951857,{"$f":"RANK(A38,$A$2:$A$50)+COUNTIF(A$2:A38,A38)-1","v":15},37]
[0.2202699139236175,{"$f":"RANK(A39,$A$2:$A$50)+COUNTIF(A$2:A39,A39)-1","v":30},38]
[0.51412824820372316,{"$f":"RANK(A40,$A$2:$A$50)+COUNTIF(A$2:A40,A40)-1","v":19},39]
[0.78885570810008354,{"$f":"RANK(A41,$A$2:$A$50)+COUNTIF(A$2:A41,A41)-1","v":8},40]
[0.33112249675779881,{"$f":"RANK(A42,$A$2:$A$50)+COUNTIF(A$2:A42,A42)-1","v":23},41]
[0.53802985265261827,{"$f":"RANK(A43,$A$2:$A$50)+COUNTIF(A$2:A43,A43)-1","v":17},42]
[5.2892349409296324E-2,{"$f":"RANK(A44,$A$2:$A$50)+COUNTIF(A$2:A44,A44)-1","v":45},43]
[0.93741038681070243,{"$f":"RANK(A45,$A$2:$A$50)+COUNTIF(A$2:A45,A45)-1","v":3},44]
[0.70380704486458867,{"$f":"RANK(A46,$A$2:$A$50)+COUNTIF(A$2:A46,A46)-1","v":10},45]
[0.5056183028441108,{"$f":"RANK(A47,$A$2:$A$50)+COUNTIF(A$2:A47,A47)-1","v":20},46]
[9.5529162211436591E-2,{"$f":"RANK(A48,$A$2:$A$50)+COUNTIF(A$2:A48,A48)-1","v":42},47]
[0.10724056340457699,{"$f":"RANK(A49,$A$2:$A$50)+COUNTIF(A$2:A49,A49)-1","v":41},48]
[0.62455202290284739,{"$f":"RANK(A50,$A$2:$A$50)+COUNTIF(A$2:A50,A50)-1","v":13},49]

{"sheet":"Draw","index":1,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"VLOOKUP(Calculations!E$1,Calculations!$B$1:$C$50,2,FALSE)","v":13},null,{"$f":"VLOOKUP(Calculations!F$1,Calculations!$B$1:$C$50,2,FALSE)","v":12},null,{"$f":"VLOOKUP(Calculations!G$1,Calculations!$B$1:$C$50,2,FALSE)","v":44},null,{"$f":"VLOOKUP(Calculations!H$1,Calculations!$B$1:$C$50,2,FALSE)","v":33},null,{"$f":"VLOOKUP(Calculations!I$1,Calculations!$B$1:$C$50,2,FALSE)","v":19},null,{"$f":"VLOOKUP(Calculations!J$1,Calculations!$B$1:$C$50,2,FALSE)","v":10}]