Editing Talk:2453: Excel Lambda
Please sign your posts with ~~~~ |
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
<!--Please sign your posts with ~~~~ and don't delete this text. New comments should be added at the bottom.--> | <!--Please sign your posts with ~~~~ and don't delete this text. New comments should be added at the bottom.--> | ||
− | |||
Another ghost cueball comic! You can see it in the last panel. [[Special:Contributions/108.162.216.54|108.162.216.54]] 06:03, 22 April 2021 (UTC) | Another ghost cueball comic! You can see it in the last panel. [[Special:Contributions/108.162.216.54|108.162.216.54]] 06:03, 22 April 2021 (UTC) | ||
− | + | ==> Is that something that has happened before? First time noticing it. Is it just a remnant of the sketching? Of doest it mean something? [[Special:Contributions/162.158.93.213|162.158.93.213]] 13:21, 22 April 2021 (UTC) | |
− | |||
− | |||
Someone needs to add an explanation of the Lambda, and possibly how Excel is implementing it. (I suppose it would immediately be useful for cutting down common re-use within a formula line, though =IF(ISERR(FIND(":",A1)),A1,RIGHT(A1,LEN(A1)-FIND(":",A1))) is a trivial repeat of the FIND, once to check, then again to do, I often need to do far more nested things, check for being a value, repeat the FIND to deal with the LEFT, etc.) But it has the smell of being effectively a Macro in this instance. Which already seems to me to be the only way to run a ''proper'' Turing Machine in an Excel column without hitting Circular Reference issues. | Someone needs to add an explanation of the Lambda, and possibly how Excel is implementing it. (I suppose it would immediately be useful for cutting down common re-use within a formula line, though =IF(ISERR(FIND(":",A1)),A1,RIGHT(A1,LEN(A1)-FIND(":",A1))) is a trivial repeat of the FIND, once to check, then again to do, I often need to do far more nested things, check for being a value, repeat the FIND to deal with the LEFT, etc.) But it has the smell of being effectively a Macro in this instance. Which already seems to me to be the only way to run a ''proper'' Turing Machine in an Excel column without hitting Circular Reference issues. | ||
Line 16: | Line 13: | ||
Microsoft themselves claim that the addition of LAMBDA makes Excel turing-comlpete (see here: https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546). Based on this comic, I would argue that it already was... [[Special:Contributions/162.158.159.36|162.158.159.36]] 12:55, 22 April 2021 (UTC) | Microsoft themselves claim that the addition of LAMBDA makes Excel turing-comlpete (see here: https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546). Based on this comic, I would argue that it already was... [[Special:Contributions/162.158.159.36|162.158.159.36]] 12:55, 22 April 2021 (UTC) | ||
− | + | ==> Someone has already made Conway's game of life in excel (http://dailydoseofexcel.com/archives/2011/04/06/conways-game-of-life-simulation-in-excel) and game of life has been shown to be Turing complete. [[User:Kvarts314|Kvarts314]] ([[User talk:Kvarts314|talk]]) 13:28, 22 April 2021 (UTC) | |
− | + | ==> Since Excel has a way to store and do math on numbers, and also a way to 'point' to a certain cell, it is Turing-complete. A lambda function is not necessary for Turing-completeness (e.x. a turing machine does not have one.) [[Special:Contributions/162.158.255.250|162.158.255.250]] 15:14, 22 April 2021 (UTC) | |
it should probably be mentioned that the number of excel rows is emphatically *not* infinite, so only simple turing machines could be implemented this way. [[Special:Contributions/162.158.93.15|162.158.93.15]] 17:20, 22 April 2021 (UTC) | it should probably be mentioned that the number of excel rows is emphatically *not* infinite, so only simple turing machines could be implemented this way. [[Special:Contributions/162.158.93.15|162.158.93.15]] 17:20, 22 April 2021 (UTC) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |