As someone various colleagues have urged to compete at modeloff years ago, it's really just something one would do if they enjoy it, anyone smart/experienced enough to do modeloff/etc. would also know it's not a good value proposition in terms of winnings/expected value/etc.
Also, anyone who writes a formula like "=SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””)" is a bit suspect imo
from chatgpt:
Here's a practical example to illustrate:
Assume cell C3 contains the string "A:B:c".
Removing colons results in "ABc". Converting to lowercase results in "abc". Extracting ASCII codes of "a", "b", and "c" gives 97, 98, and 99, respectively. Summing these values gives 97 + 98 + 99 = 294. So, the formula SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””)))))) for the string "A:B:c" results in 294.