| Latest revision |
Your text |
| Line 8: |
Line 8: |
| | | | |
| | ==Explanation== | | ==Explanation== |
| − | [[Cueball]] is doing some task on his computer, with an {{w|Shoulder angel|angel and devil on either side of him}}, trying to influence his work. The angel is telling him to do things the "right" way, while the devil is telling him to do his work using a {{w|spreadsheet}}, which is considered by professional software engineers to be a shortcut or a hack.
| + | {{incomplete|Created by a REGEXREPLACE(). Please mention here why this explanation isn't complete. Do NOT delete this tag too soon.}} |
| − | | |
| − | Spreadsheets provide an array of cells, which can contain information or instructions. Spreadsheets are a common {{w|end-user development}} tool, allowing non-developers to easily create code. However they can be hard to maintain, thus they are often mocked by developers as a wrong approach to programming. Although it is not clear from the cartoon that this is meant, the "right" alternative to using a spreadsheet for some tasks may involve a database or a more general programming language.
| |
| − | | |
| − | The punch line comes when the angel becomes so intrigued by the spreadsheet functions, Google Sheets in particular, that it gives up trying to dissuade Cueball, and asks for more information from the devil.
| |
| − | | |
| − | In the title text, Randall mentions a time when he created a calendar grid in Google Sheets using a list of dates. This is described as being done in a "single-cell formula", and taking a long time to run. This shows the power and complexity of spreadsheets. The procedure taking a long time to run, and freezing up the internet browser (possibly even the rest of the computer) for 15 seconds every time it ran, was probably not what Randall's brother had in mind when he requested help. His brother learned he might need to be wary about what he gets back when asking Randall for assistance.
| |
| − | | |
| − | All functions mentioned in this comic can be found in {{w|Google Sheets}}, but functions similar to some of them can be found in most modern spreadsheet applications.
| |
| − | | |
| − | '''[https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE](text, regular_expression, replacement)''' ⇒ Replaces part of a text string with a different text string using {{w|Regular expression|regular expressions}}. | |
| − | | |
| − | '''[https://support.google.com/docs/answer/3093275?hl=en ARRAYFORMULA](array_formula)''' ⇒ Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.
| |
| − | | |
| − | '''[https://support.google.com/docs/answer/3093343?hl=en QUERY](data, query, [headers])''' ⇒ Runs a [https://developers.google.com/chart/interactive/docs/querylanguage Google Visualization API Query Language] query across data.
| |
| − | | |
| − | '''[https://support.google.com/docs/answer/3093339?hl=en IMPORTHTML](url, query, index)''' ⇒ Imports data from a table or list within an HTML page.
| |
| − | | |
| − | '''[https://support.google.com/docs/answer/9368244?hl=en SEQUENCE](rows, columns, start, step)''' ⇒ Returns an array of sequential numbers, such as 1, 2, 3, 4.
| |
| − | | |
| − | '''[https://support.google.com/docs/answer/3098292?hl=en REGEXMATCH](text, regular_expression)''' ⇒ Whether a piece of text matches a regular expression.
| |
| | | | |
| | ==Transcript== | | ==Transcript== |
| | + | {{incomplete transcript|Do NOT delete this tag too soon.}} |
| | | | |
| − | :[Cueball is at his computer. In the air on either side of him are an angel version of Cueball, with a halo and wings, and a devil version of Cueball, with horns and a pitchfork. The angel's dialogue appears in regular print, while the devil's dialogue appears in white print in black speech balloons.]
| + | [Cueball is at his computer. In the air on either side of him are an angel version of Cueball, with a halo and wings, and a devil version of Cueball, with horns and a pitchfork.] |
| | :Angel: Don't use a spreadsheet! Do it '''''right'''''. | | :Angel: Don't use a spreadsheet! Do it '''''right'''''. |
| − | :Devil: But a spreadsheet would be so '''''easy'''''. | + | :Devil: But a spreadsheet would be so ''easy''. |
| | :Angel: In the long run you'll regret it! | | :Angel: In the long run you'll regret it! |
| | | | |
| − | :[Closeup on Cueball, the angel, and the devil.]
| + | [Closeup on Cueball, the angel, and the devil.] |
| | :Angel: Take the time to write ''real'' code. | | :Angel: Take the time to write ''real'' code. |
| | :Devil: Just paste the data! Tinker until it works! | | :Devil: Just paste the data! Tinker until it works! |
| − | :Devil: Build a labyrinth of '''REGEXREPLACE()''' and '''ARRAYFORMULA()'''! | + | :Devil: Build a labyrinth of REGEXREPLACE() and ARRAYFORMULA()! |
| | :Devil: ''Feel the power!'' | | :Devil: ''Feel the power!'' |
| | | | |
| − | :[Closeup on the devil.]
| + | [Closeup on the devil.] |
| | :Angel (off-panel): Fight the temptation! | | :Angel (off-panel): Fight the temptation! |
| | :Devil: Ever tried QUERY() in Google Sheets? It lets you treat a block of cells like a database and run SQL queries on them. | | :Devil: Ever tried QUERY() in Google Sheets? It lets you treat a block of cells like a database and run SQL queries on them. |
| | | | |
| − | :[Another shot of Cueball at his computer with the angel and devil at either side.]
| + | [Another shot of Cueball at his computer with the angel and devil at either side.] |
| − | :Angel: Don't listen to– | + | :Angel: Don't listen to-- |
| − | :Angel: ...wait, really? | + | :Angel: ... wait, really? |
| − | :Devil: Yes, and let me tell you about IMPORTHTML()... | + | :Devil: Yes, and let me tell you about IMPORTHTML() ... |
| | :Angel: ''Oooh...'' | | :Angel: ''Oooh...'' |
| − |
| |
| − | ==Trivia==
| |
| − |
| |
| − | Spreadsheets used for complex tasks and evolving into complex algorithms was also the punchline of [[1667: Algorithms]].
| |
| | | | |
| | {{comic discussion}} | | {{comic discussion}} |
| − | [[Category:Comics featuring Cueball]]
| |
| − | [[Category:Comics with inverted brightness]]
| |
| − | [[Category:Computers]]
| |
| − | [[Category:Spreadsheets]]
| |
