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) |
