Timeline for Vanilla Natural Logarithm Challenge
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 13, 2023 at 20:41 | comment | added | Neil | @JacFrall Oh, it's just L'Hopital's rule, seems so easy now... | |
| Jul 13, 2023 at 8:01 | comment | added | The Empty String Photographer | This is like FGITW but multiplied by 5! | |
| Jul 13, 2023 at 4:59 | comment | added | Jos Woolley |
@loopywalt Agreed that Excel's order here is against convention. "If a formula contains operators with the same precedence, Excel evaluates the operators from left to right." (MS Documentation). An even more striking example of Excel's unconventional order of operations is the fact that it evaluates =-10^2 as 100.
|
|
| Jul 13, 2023 at 1:50 | comment | added | Jac Frall | @Neil a derivation can be seen here math.stackexchange.com/questions/1438364/… | |
| Jul 12, 2023 at 21:27 | comment | added | loopy walt | @CursorCoercer Which is wrong (I mean what Excel does, not your statement) ["Without parentheses, the conventional order of operations for serial exponentiation in superscript notation is top-down (or right-associative), not bottom-up" ](en.wikipedia.org/wiki/Exponentiation). Making it left-associative is a bit silly because \$(a^b)^c=a^{bc}\$ i.e. chaining exponentiation from the left is completely redundant with multiplying exponents. | |
| Jul 12, 2023 at 19:43 | comment | added | CursorCoercer |
@loopywalt Order of operations, A1^9^-9 != A1^(9^-9) == A1^(1/9^9)
|
|
| Jul 12, 2023 at 18:35 | comment | added | loopy walt | Mathematically, it should work. I don't have Excel, so I can't pinpoint what's going wrong here. | |
| Jul 12, 2023 at 18:33 | comment | added | Jos Woolley | @DominicvanEssen I'm happy with that decision! Amended, many thanks. In the end it was in fact a 3-byte save! | |
| Jul 12, 2023 at 18:32 | history | edited | Jos Woolley | CC BY-SA 4.0 |
added 115 characters in body
|
| Jul 12, 2023 at 18:25 | comment | added | Jos Woolley |
@loopywalt Not sure I understand. A1^9^-9 is equal to zero for all A1.
|
|
| Jul 12, 2023 at 18:23 | comment | added | Dominic van Essen | @JosWoolley - It's the code that counts. If Excel auto-embellishes it later, that's not the golfer's problem... (and could even work to their advantage...) | |
| Jul 12, 2023 at 17:39 | comment | added | Neil | wolframalpha.com/… but I'd love to know how to derive that. | |
| Jul 12, 2023 at 16:14 | comment | added | loopy walt |
Would 9^9*(A1^9^-9-1) work?
|
|
| Jul 12, 2023 at 15:27 | comment | added | Jos Woolley |
Great! Actually that would save 2 bytes (=1E9*(A1^1E-9-1)). However, when committed, Excel converts that formula to =1000000000*(A1^0.000000001-1), I guess we'd need to have some consensus as to whether such solutions are permitted.
|
|
| Jul 12, 2023 at 15:16 | comment | added | Dominic van Essen |
Lovely! Save 1 byte by using 1e9 and 1e-9 to remove a set of parentheses...
|
|
| Jul 12, 2023 at 14:06 | history | answered | Jos Woolley | CC BY-SA 4.0 |