Hey everyone,
I've been struggling to figure this one out and I think the only way is an alternative, so I'm hoping I can get some suggestions or solutions.
I've been struggling to figure this one out and I think the only way is an alternative, so I'm hoping I can get some suggestions or solutions.
RLSIM 2022 - V14 try scorers.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | |||
45 | # | 8.0 | 0.82 | # | 1.0 | 0.78 | ||
46 | 1 | HomePlayer 6 | 0 | 1 | AwayPlayer 2 | 0 | ||
47 | 2 | HomePlayer 6 | 1 | |||||
48 | 3 | HomePlayer 5 | 1 | |||||
49 | 4 | HomePlayer 4 | 0 | |||||
50 | 5 | HomePlayer 1 | 1 | |||||
51 | 6 | HomePlayer 2 | 1 | |||||
52 | 7 | HomePlayer 14 | 1 | |||||
53 | 8 | HomePlayer 4 | 1 | |||||
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||
58 | ||||||||
59 | ||||||||
60 | ||||||||
61 | 0 | #SPILL! | 1 | AwayPlayer 2 | ||||
62 | 0 | 0 | ||||||
63 | 0 | 0 | ||||||
64 | 0 | 0 | ||||||
65 | 0 | 0 | ||||||
66 | 0 | 0 | ||||||
67 | 0 | 0 | ||||||
68 | 0 | 0 | ||||||
69 | 0 | 0 | ||||||
Sim |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E46,H46 | E46 | =IF(F45>=1,1,"") |
E47,H47 | E47 | =IF(F45>=2,2,"") |
E48,H48 | E48 | =IF(F45>=3,3,"") |
E49,H49 | E49 | =IF(F45>=4,4,"") |
E50,H50 | E50 | =IF(F45>=5,5,"") |
E51,H51 | E51 | =IF(F45>=6,6,"") |
E52,H52 | E52 | =IF(F45>=7,7,"") |
E53,H53 | E53 | =IF(F45>=8,8,"") |
E54 | E54 | =IF($F$45>=9,9,"") |
E55 | E55 | =IF($F$45>=10,10,"") |
E56 | E56 | =IF($F$45>=11,11,"") |
E57 | E57 | =IF($F$45>=12,12,"") |
E58 | E58 | =IF($F$45>=13,13,"") |
E59 | E59 | =IF($F$45>=14,14,"") |
E60 | E60 | =IF($F$45>=15,15,"") |
J46:J60 | J46 | =IF(I46="","",--(RAND()<=$J$45)) |
G46:G60 | G46 | =IF(F46="","",--(RAND()<=$G$45)) |
G61 | G61 | =IFERROR(LET(x,INDIRECT("f46:f"&LOOKUP(2,1/($F$46:$F$60<>""),ROW($F$46:$F$60))),y,UNIQUE(x),SORTBY(y,COUNTIF(x,y),-1)),"") |
I45 | I45 | =ROUNDUP((I31/6),0) |
I46:I60 | I46 | =IF(H46<=$I$45,INDEX($J$3:$J$19,COUNTIF($W$43:$W$59,"<="&RANDBETWEEN(MIN($W$43:$W$59),100))),"") |
I61 | I61 | =IFERROR(LET(x,INDIRECT("i46:i"&LOOKUP(2,1/($I$46:$I$60<>""),ROW($I$46:$I$60))),y,UNIQUE(x),SORTBY(y,COUNTIF(x,y),-1)),"") |
F45 | F45 | =ROUNDUP((G31/6),0) |
F46:F60 | F46 | =IF(E46<=$F$45,INDEX($E$3:$E$19,COUNTIF($T$43:$T$59,"<="&RANDBETWEEN(MIN($T$43:$T$59),100))),"") |
F61:F69 | F61 | =COUNTIF($F$46:$F$60,G61) |
H54 | H54 | =IF(I45>=9,9,"") |
H55 | H55 | =IF(I45>=10,10,"") |
H56 | H56 | =IF(I45>=11,11,"") |
H57 | H57 | =IF(I45>=12,12,"") |
H58 | H58 | =IF(I45>=13,13,"") |
H59 | H59 | =IF(I45>=14,14,"") |
H60 | H60 | =IF(I45>=15,15,"") |
H61:H69 | H61 | =COUNTIF($I$46:$I$60,I61) |