Editing 2180: Spreadsheets
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 8: | Line 8: | ||
==Explanation== | ==Explanation== | ||
− | + | {{incomplete|Created by a REGEXREPLACE(). Please mention here why this explanation isn't complete. Do NOT delete this tag too soon.}} | |
+ | Cueball is doing some task on his computer, with a {{w|Shoulder angel|angel and devil on both sides 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 to be a shortcut or a hack. | ||
− | + | The punch line comes when the angel becomes so intrigued by the functions that can be accomplished by spreadsheets, 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, scaring his brother from asking him any further computing questions. | |
− | + | All functions mentioned in this comic can be found in {{w|Google Sheets}}, but similar functions can be found in most modern spreadsheet applications. | |
− | + | REGEXREPLACE(text, regular_expression, replacement) | |
− | + | ARRAYFORMULA(array_formula) | |
− | + | QUERY(data, query, [headers]) | |
− | + | IMPORTHTML(url, query, index) | |
− | + | SEQUENCE() | |
− | + | REGEXMATCH() | |
− | |||
− | |||
==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.] | ||
: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 | + | :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.] | |
: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 | + | :Devil: Build a labyrinth of REGEXREPLACE() and ARRAYFORMULA()! |
:Devil: ''Feel the power!'' | :Devil: ''Feel the power!'' | ||
− | + | [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.] | |
− | :Angel: Don't listen | + | :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...'' | ||
− | |||
− | |||
− | |||
− | |||
{{comic discussion}} | {{comic discussion}} | ||
[[Category:Comics featuring Cueball]] | [[Category:Comics featuring Cueball]] | ||
− | |||
[[Category:Computers]] | [[Category:Computers]] | ||
− |