# Difference between revisions of "1906: Making Progress"

(Made procrastination more obvious.) |
(→Explanation: REMOVED INCOMPLETE TAG AND ADDED A NEW PARAGRAPH ABOUT EXCEL) |
||

Line 8: | Line 8: | ||

==Explanation== | ==Explanation== | ||

− | + | ||

[[Megan]] has <s>procrastinated</s> made progress on a large backlog of problems. While she started the day with lots of problems, she has entered those problems into a spreadsheet. While this could potentially allow her to tackle her problems in a more organized way and fix them more quickly, the humor lies in that none of the problems have actually been solved. Additionally, it's questionable whether this was worth the hours of effort she put into making the spreadsheet, and even whether the spreadsheet has made her problems any easier to tackle in the first place. | [[Megan]] has <s>procrastinated</s> made progress on a large backlog of problems. While she started the day with lots of problems, she has entered those problems into a spreadsheet. While this could potentially allow her to tackle her problems in a more organized way and fix them more quickly, the humor lies in that none of the problems have actually been solved. Additionally, it's questionable whether this was worth the hours of effort she put into making the spreadsheet, and even whether the spreadsheet has made her problems any easier to tackle in the first place. | ||

− | In the title text she reveals that even her spreadsheet has a problem, because "#REF Circular Dependency detected" is a spreadsheet error meaning that a formula is (possibly indirectly) using its own cell in the equation. This is because she has used the Count() function to find the number of problems to be solved, but since one of those problems is not knowing how many problems she has, it is trying to include itself in the count. | + | In the title text she reveals that even her spreadsheet has a problem, because "#REF Circular Dependency detected" is a spreadsheet error meaning that a formula is (possibly indirectly) using its own cell in the equation. This is likely because she has used the Count() function to find the number of problems to be solved, but since one of those problems is not knowing how many problems she has, it is trying to include itself in the count. |

This counting problem may also be a metaphor for circular dependencies within the problems themselves, such that a solution to one problem would help solve another problem, but solving the first problem depends on a solution to the second problem. (Example: Organizing a cluttered mess of objects requires room to work, which is not available because of all the clutter.) | This counting problem may also be a metaphor for circular dependencies within the problems themselves, such that a solution to one problem would help solve another problem, but solving the first problem depends on a solution to the second problem. (Example: Organizing a cluttered mess of objects requires room to work, which is not available because of all the clutter.) | ||

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 simply is 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 simply is 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 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 helpful 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== |

## Revision as of 12:23, 8 February 2018

Making Progress |

Title text: I started off with countless problems. But now I know, thanks to COUNT(), that I have "#REF! ERROR: Circular dependency detected" problems. |

## Explanation

Megan has ~~procrastinated~~ made progress on a large backlog of problems. While she started the day with lots of problems, she has entered those problems into a spreadsheet. While this could potentially allow her to tackle her problems in a more organized way and fix them more quickly, the humor lies in that none of the problems have actually been solved. Additionally, it's questionable whether this was worth the hours of effort she put into making the spreadsheet, and even whether the spreadsheet has made her problems any easier to tackle in the first place.

In the title text she reveals that even her spreadsheet has a problem, because "#REF Circular Dependency detected" is a spreadsheet error meaning that a formula is (possibly indirectly) using its own cell in the equation. This is likely because she has used the Count() function to find the number of problems to be solved, but since one of those problems is not knowing how many problems she has, it is trying to include itself in the count.

This counting problem may also be a metaphor for circular dependencies within the problems themselves, such that a solution to one problem would help solve another problem, but solving the first problem depends on a solution to the second problem. (Example: Organizing a cluttered mess of objects requires room to work, which is not available because of all the clutter.)

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 simply is 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 Microsoft Excel: #REF!, which means that an invalid reference has been made (such as to a cell or sheet that has since been deleted), and 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 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 error message box and helpful 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

- [Megan is sitting and looking at a laptop.]
- Megan: I started the day with lots of problems.
- Megan: But now, after hours and hours of work,
- Megan: I have lots of problems in a
.**spreadsheet**

**add a comment!**⋅

**add a topic (use sparingly)!**⋅

**refresh comments!**

# Discussion

What about "countless" and "COUNT()" in the title text? I think that's a pun... User:Nobody at 1 January 1970 12:00 AM UTC

- Not really, rather that is the purpose of "COUNT()" function, when you are not sure how numerous something is. --Trimutius (talk) 22:11, 23 October 2017 (UTC)

The pun is that "countless" means they can't be counted, and the error message from the Count() function implies that the problems couldn't be counted. 108.162.215.106 22:33, 23 October 2017 (UTC)

- I agree that both the countless, the use of count and the fact that it failed is important, and this is currently not explained in the title text explanation. Hope someone with more familiarity with spreadsheets will try to make a good explanation of this --Kynde (talk) 11:51, 24 October 2017 (UTC)

The COUNT() function only works on rows or columns of values rather than text. So if the problems are listed in a spreadsheet, likely as text, the COUNTA() function would really be the correct one...

- Also, COUNT() won't provide an error in Excel, simply a 0 result (though a warning box is shown). Google Sheets produces the content of the title text. 172.68.253.41 02:41, 25 October 2017 (UTC)
- In Excel you can include the formula in the count by checking 'Enable iterative calculation' under options-formulas 162.158.167.198 05:54, 25 October 2017 (UTC)

If you're having spreadsheet problems I feel bad for ya son. I got "#REF! ERROR: Circular dependency detected" problems but a circular dependency ain't one. Dammit! 172.68.59.198 19:14, 27 October 2019 (UTC)