{"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":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Rand","Unique Rank","Ball Number",null,1,2,3,4,5,6]
[{"$f":"RAND()","v":0.49344267434482258},{"$f":"RANK(A2,$A$2:$A$50)+COUNTIF(B$1:B1,B1)-1","v":22},1]
[{"$f":"RAND()","v":0.71809782571201031},{"$f":"RANK(A3,$A$2:$A$50)+COUNTIF(B$1:B2,B2)-1","v":11},2]
[0.14933076298643244,{"$f":"RANK(A4,$A$2:$A$50)+COUNTIF(B$1:B3,B3)-1","v":46},3]
[0.32314356959490587,{"$f":"RANK(A5,$A$2:$A$50)+COUNTIF(B$1:B4,B4)-1","v":34},4]
[0.8092365253715994,{"$f":"RANK(A6,$A$2:$A$50)+COUNTIF(B$1:B5,B5)-1","v":6},5]
[0.27809443119529798,{"$f":"RANK(A7,$A$2:$A$50)+COUNTIF(B$1:B6,B6)-1","v":39},6]
[0.78276464761027142,{"$f":"RANK(A8,$A$2:$A$50)+COUNTIF(B$1:B7,B7)-1","v":8},7]
[0.30436267684688523,{"$f":"RANK(A9,$A$2:$A$50)+COUNTIF(B$1:B8,B8)-1","v":35},8]
[0.29431545089968392,{"$f":"RANK(A10,$A$2:$A$50)+COUNTIF(B$1:B9,B9)-1","v":37},9]
[0.45851215192972816,{"$f":"RANK(A11,$A$2:$A$50)+COUNTIF(B$1:B10,B10)-1","v":24},10]
[0.6151576483507899,{"$f":"RANK(A12,$A$2:$A$50)+COUNTIF(B$1:B11,B11)-1","v":17},11]
[0.29802194832782103,{"$f":"RANK(A13,$A$2:$A$50)+COUNTIF(B$1:B12,B12)-1","v":36},12]
[0.48705220763995971,{"$f":"RANK(A14,$A$2:$A$50)+COUNTIF(B$1:B13,B13)-1","v":23},13]
[0.2932847907735594,{"$f":"RANK(A15,$A$2:$A$50)+COUNTIF(B$1:B14,B14)-1","v":38},14]
[0.1791199140301778,{"$f":"RANK(A16,$A$2:$A$50)+COUNTIF(B$1:B15,B15)-1","v":44},15]
[0.8488102758663878,{"$f":"RANK(A17,$A$2:$A$50)+COUNTIF(B$1:B16,B16)-1","v":5},16]
[0.17846601039299426,{"$f":"RANK(A18,$A$2:$A$50)+COUNTIF(B$1:B17,B17)-1","v":45},17]
[0.54467945964447662,{"$f":"RANK(A19,$A$2:$A$50)+COUNTIF(B$1:B18,B18)-1","v":20},18]
[0.62521859061203333,{"$f":"RANK(A20,$A$2:$A$50)+COUNTIF(B$1:B19,B19)-1","v":15},19]
[0.61961595524337376,{"$f":"RANK(A21,$A$2:$A$50)+COUNTIF(B$1:B20,B20)-1","v":16},20]
[6.2708949829151095E-3,{"$f":"RANK(A22,$A$2:$A$50)+COUNTIF(B$1:B21,B21)-1","v":49},21]
[0.86791150702534825,{"$f":"RANK(A23,$A$2:$A$50)+COUNTIF(B$1:B22,B22)-1","v":4},22]
[0.9572561422945105,{"$f":"RANK(A24,$A$2:$A$50)+COUNTIF(B$1:B23,B23)-1","v":2},23]
[0.77222561171218018,{"$f":"RANK(A25,$A$2:$A$50)+COUNTIF(B$1:B24,B24)-1","v":9},24]
[0.45465411670828915,{"$f":"RANK(A26,$A$2:$A$50)+COUNTIF(B$1:B25,B25)-1","v":25},25]
[0.66651883966991488,{"$f":"RANK(A27,$A$2:$A$50)+COUNTIF(B$1:B26,B26)-1","v":13},26]
[0.25413811230328776,{"$f":"RANK(A28,$A$2:$A$50)+COUNTIF(B$1:B27,B27)-1","v":41},27]
[0.44173607016048977,{"$f":"RANK(A29,$A$2:$A$50)+COUNTIF(B$1:B28,B28)-1","v":27},28]
[0.57670686928781389,{"$f":"RANK(A30,$A$2:$A$50)+COUNTIF(B$1:B29,B29)-1","v":19},29]
[0.35520320495107116,{"$f":"RANK(A31,$A$2:$A$50)+COUNTIF(B$1:B30,B30)-1","v":32},30]
[0.98333522939566542,{"$f":"RANK(A32,$A$2:$A$50)+COUNTIF(B$1:B31,B31)-1","v":1},31]
[0.35013210050708699,{"$f":"RANK(A33,$A$2:$A$50)+COUNTIF(B$1:B32,B32)-1","v":33},32]
[0.45430401940872156,{"$f":"RANK(A34,$A$2:$A$50)+COUNTIF(B$1:B33,B33)-1","v":26},33]
[6.7047199133187352E-2,{"$f":"RANK(A35,$A$2:$A$50)+COUNTIF(B$1:B34,B34)-1","v":48},34]
[0.38025326894635025,{"$f":"RANK(A36,$A$2:$A$50)+COUNTIF(B$1:B35,B35)-1","v":31},35]
[0.1893479539890397,{"$f":"RANK(A37,$A$2:$A$50)+COUNTIF(B$1:B36,B36)-1","v":43},36]
[0.40232482269653702,{"$f":"RANK(A38,$A$2:$A$50)+COUNTIF(B$1:B37,B37)-1","v":29},37]
[0.59806137614714627,{"$f":"RANK(A39,$A$2:$A$50)+COUNTIF(B$1:B38,B38)-1","v":18},38]
[0.62932253250626191,{"$f":"RANK(A40,$A$2:$A$50)+COUNTIF(B$1:B39,B39)-1","v":14},39]
[0.42764013383938293,{"$f":"RANK(A41,$A$2:$A$50)+COUNTIF(B$1:B40,B40)-1","v":28},40]
[0.80562528720539905,{"$f":"RANK(A42,$A$2:$A$50)+COUNTIF(B$1:B41,B41)-1","v":7},41]
[0.10868631715111987,{"$f":"RANK(A43,$A$2:$A$50)+COUNTIF(B$1:B42,B42)-1","v":47},42]
[0.68833084243768994,{"$f":"RANK(A44,$A$2:$A$50)+COUNTIF(B$1:B43,B43)-1","v":12},43]
[0.53891840560121551,{"$f":"RANK(A45,$A$2:$A$50)+COUNTIF(B$1:B44,B44)-1","v":21},44]
[0.26412395790464349,{"$f":"RANK(A46,$A$2:$A$50)+COUNTIF(B$1:B45,B45)-1","v":40},45]
[0.24946664025342224,{"$f":"RANK(A47,$A$2:$A$50)+COUNTIF(B$1:B46,B46)-1","v":42},46]
[0.76385454367909977,{"$f":"RANK(A48,$A$2:$A$50)+COUNTIF(B$1:B47,B47)-1","v":10},47]
[0.40156750075750813,{"$f":"RANK(A49,$A$2:$A$50)+COUNTIF(B$1:B48,B48)-1","v":30},48]
[0.88403366893583768,{"$f":"RANK(A50,$A$2:$A$50)+COUNTIF(B$1:B49,B49)-1","v":3},49]
[0.22184374507683469,{"$f":"RANK(A51,$A$2:$A$50)+COUNTIF(B$1:B50,B50)-1","v":{"$error":"#N/A"}},50]
[0.48020697594246808,{"$f":"RANK(A52,$A$2:$A$50)+COUNTIF(B$1:B51,B51)-1","v":{"$error":"#N/A"}},51]
[0.45855500652895564,{"$f":"RANK(A53,$A$2:$A$50)+COUNTIF(B$1:B52,B52)-1","v":{"$error":"#N/A"}},52]
[0.85534700779828143,{"$f":"RANK(A54,$A$2:$A$50)+COUNTIF(B$1:B53,B53)-1","v":{"$error":"#N/A"}},53]
[0.34717519044010903,{"$f":"RANK(A55,$A$2:$A$50)+COUNTIF(B$1:B54,B54)-1","v":{"$error":"#N/A"}},54]
[0.3532663418982307,{"$f":"RANK(A56,$A$2:$A$50)+COUNTIF(B$1:B55,B55)-1","v":{"$error":"#N/A"}},55]

{"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$56,2,FALSE)","v":31},null,{"$f":"VLOOKUP(Calculations!F$1,Calculations!$B$1:$C$56,2,FALSE)","v":23},null,{"$f":"VLOOKUP(Calculations!G$1,Calculations!$B$1:$C$56,2,FALSE)","v":49},null,{"$f":"VLOOKUP(Calculations!H$1,Calculations!$B$1:$C$56,2,FALSE)","v":22},null,{"$f":"VLOOKUP(Calculations!I$1,Calculations!$B$1:$C$56,2,FALSE)","v":16},null,{"$f":"VLOOKUP(Calculations!J$1,Calculations!$B$1:$C$56,2,FALSE)","v":5}]