so true - I held on to Excel 2003 until 2018 at which point it really just didn't work anymore on Win10
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.
Make that code lowercase, introduce significant whitespace and call the langauge "Boa" or something, and it's guaranteed it'll take the world of scientific computing by storm.
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.