Editing 1906: Making Progress
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 17: | Line 17: | ||
Arguably, this has introduced a further problem, so she actually now has (#REF Circular Dependency detected)+1 problems. It's also possible, since Megan has chosen to interpret the error message as a numeric value representing the number of problems she has, that she is simply not good at using her spreadsheet software, which may be another problem that needs adding to her list. The use of COUNT() has, rather than returning an exact amount of problems to solve, implied that her original problems cause so many more that she does indeed have "countless problems". | Arguably, this has introduced a further problem, so she actually now has (#REF Circular Dependency detected)+1 problems. It's also possible, since Megan has chosen to interpret the error message as a numeric value representing the number of problems she has, that she is simply not good at using her spreadsheet software, which may be another problem that needs adding to her list. The use of COUNT() has, rather than returning an exact amount of problems to solve, implied that her original problems cause so many more that she does indeed have "countless problems". | ||
β | The error shown is similar to two different errors in the popular spreadsheet program {{w|Microsoft Excel|Microsoft Excel}}: [https://support.office.com/en-us/article/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be?ui=en-US&rs=en-US&ad=US #REF!], which means that an invalid reference has been made (such as to a cell or sheet that has since been deleted), and [https://support.office.com/en-us/article/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123 circular references], which | + | The error shown is similar to two different errors in the popular spreadsheet program {{w|Microsoft Excel|Microsoft Excel}}: [https://support.office.com/en-us/article/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be?ui=en-US&rs=en-US&ad=US #REF!], which means that an invalid reference has been made (such as to a cell or sheet that has since been deleted), and [https://support.office.com/en-us/article/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123 circular references], which mean that a certain cell's content has been made to depend on another, which in turn has been made to depend on that first cell, meaning that the cell depends on itself {{w|Recursion|recursively}}. Most versions of Excel do not show circular references in the cell, next to where a #REF! error would be, but rather they show an {{w|Dialog box|error message box}} and arrows drawn over the sheet which connect the dependencies of the cells involved in the error. However, since the comic does not specify which spreadsheet software Megan is using, Randall can simply make the errors up, to make the joke more quickly understandable, while clearly referencing errors that show in actual spreadsheet software. |
==Transcript== | ==Transcript== |