Do you have adblock enabled?
 
If you can read this, either the style sheet didn't load or you have an older browser that doesn't support style sheets. Try clearing your browser cache and refreshing the page.

(Gizmodo)   Intrepid explorer takes nine straight hours to get to the bottom of an Excel spreadsheet   ( gizmodo.com) divider line
    More: Hero, 5-Hour Energy drinks, Microsoft Excel, Spreadsheet, Hunter Hobbs, enterprising YouTuber, Excel spreadsheet, tireless work, arrow key  
•       •       •

4731 clicks; posted to Geek » on 10 Jan 2017 at 3:20 PM (36 weeks ago)   |   Favorite    |   share:  Share on Twitter share via Email Share on Facebook   more»



62 Comments     (+0 »)
 
View Voting Results: Smartest and Funniest


Oldest | « | 1 | 2 | » | Newest | Show all

 
2017-01-10 02:05:55 PM  
Almost as long as it took her to get Voyager back to the Alpha Quadrant.
 
2017-01-10 02:08:24 PM  
EVE?

/DNRTFA
 
2017-01-10 02:49:57 PM  
It would be funny if he found Clippy at the bottom who then says, "You've wasted your time."
 
2017-01-10 02:58:29 PM  
I hope he made a macro for the next time he wants to do it
 
2017-01-10 03:07:22 PM  
Wouldn't it make more sense to set up a camera and use some form of inanimate weight? Maybe a carbon rod.
 
2017-01-10 03:22:11 PM  

SumJackass07: Wouldn't it make more sense to set up a camera and use some form of inanimate weight? Maybe a carbon rod.


Life is about the journey, not the destination.
 
2017-01-10 03:26:26 PM  

SumJackass07: Wouldn't it make more sense to set up a camera and use some form of inanimate weight? Maybe a carbon rod.


img.fark.net
 
2017-01-10 03:28:17 PM  
Ctrl+Arrow is faster.
 
2017-01-10 03:31:50 PM  

Beeblebrox: Ctrl+Arrow is faster.


Did not know that one.  3 seconds, probably faster.
 
2017-01-10 03:36:19 PM  
 who would ever need more than 1,048,576 rows.
-W. Gates
 
2017-01-10 03:36:47 PM  
Well, there's bored.....and then, there's this guy.
 
2017-01-10 03:37:43 PM  

Beeblebrox: Ctrl+Arrow is faster.


While not as fast, typing A1048576 is also pretty quick.
 
2017-01-10 03:39:32 PM  
2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.
 
2017-01-10 03:41:05 PM  

dywed88: Beeblebrox: Ctrl+Arrow is faster.

While not as fast, typing A1048576 is also pretty quick.


No, that would be:
Control+G
A:1048576
OK
 
2017-01-10 03:41:33 PM  

Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.


Yes.
 
2017-01-10 03:44:28 PM  
And to think just yesterday I was trying to explain to someone right here on fark that Gizmodo is barely one step above Buzzfeed at this point.
 
2017-01-10 03:50:36 PM  
So, the next video will be him pressing the right arrow?
 
2017-01-10 03:54:58 PM  

Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.


Ha ha, sucker!
 
2017-01-10 03:57:11 PM  

meanmutton: Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.

Yes.


I'm just not sure why they went with 2^20 and not 2^31 or 2^32.
I get 2^16 as a limit in the old file format because of how long ago that would have been established, short int makes sense.
I guess they're saving room to expand in xlsxl...
 
2017-01-10 04:01:25 PM  
I have been more impressed if he pressed the arrow key 1 million+ times instead of holding it down.

Under these conditions, the time it takes to reach the bottom of the spreadsheet is hardware dependent.
 
2017-01-10 04:02:23 PM  
I was feeling pretty bad for wasting time today playing Anno 2205.... then I read this.  Feeling pretty productive by comparison.
 
2017-01-10 04:04:10 PM  

Fizpez: I was feeling pretty bad for wasting time today playing Anno 2205.... then I read this.  Feeling pretty productive by comparison.


I see, checks out...
 
2017-01-10 04:04:57 PM  
He should try it on my spreadsheet. Given the half a second the computer lags between key strokes, Trump will be out of office by the time he's done.

/like a magical time machine!
//I've got overly complicated spreadsheets
 
2017-01-10 04:05:07 PM  
What a waste of human life.
 
2017-01-10 04:09:54 PM  
Any Lotus 123 users still use those shortcuts in Excel?   'End' 'Down arrow' still works...
 
2017-01-10 04:11:30 PM  

SumJackass07: Wouldn't it make more sense to set up a camera and use some form of inanimate weight? Maybe a carbon rod.


If your goal is to figure out how long the scrolling would take, yes.  If your goal is to make a viral video where people stare at your handsome manface for a few minutes while you hold down a key, then no.
 
2017-01-10 04:14:09 PM  
Is "Intrepid explorer" what we're calling "idiot with nothing better to do with their time" today subby?
 
2017-01-10 04:24:42 PM  
Now somebody give him a Tootsie Roll Pop.
 
2017-01-10 04:31:43 PM  
Not only did this guy spend 9 hours doing this, someone reported on and and someone else submitted it to Fark and some Farkmin approved it.

I can't wait for the pilot episode of Ow My Balls.
 
2017-01-10 04:34:17 PM  

freidog: meanmutton: Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.

Yes.

I'm just not sure why they went with 2^20 and not 2^31 or 2^32.
I get 2^16 as a limit in the old file format because of how long ago that would have been established, short int makes sense.
I guess they're saving room to expand in xlsxl...


A million records seems like a nice, round number. The idea is that anything bigger should be a database. If you're going to limit it to 1 million, may as well go to 2^20.
 
2017-01-10 04:37:10 PM  
"Intrepid explorer takes nine straight hours to get to the bottom of an Excel spreadsheet."

All these moments will be lost like piss in a flushing toilet. Time to die.

img.fark.net
 
2017-01-10 04:38:41 PM  
Why is there even a limit? If you put a single item on line (big number here) any non-brain dead disk or in-memory format wouldn't store the empty space between row 1 and there.

Silly.
 
2017-01-10 04:38:46 PM  

duckpoopy: What a waste of human life.



He's an Oklahoma fan. He was never going to amount to much anyways.
 
2017-01-10 04:39:43 PM  
The Desert Bus of office productivity.
 
2017-01-10 04:39:57 PM  

meanmutton: freidog: meanmutton: Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.

Yes.

I'm just not sure why they went with 2^20 and not 2^31 or 2^32.
I get 2^16 as a limit in the old file format because of how long ago that would have been established, short int makes sense.
I guess they're saving room to expand in xlsxl...

A million records seems like a nice, round number. The idea is that anything bigger should be a database. If you're going to limit it to 1 million, may as well go to 2^20.


Makes sense, given how 2^10 bytes is a kilobyte and 2^20 is a megabyte. I propose that we call the size of an XLSX file a "megarow".
 
2017-01-10 04:40:02 PM  

Thunderboy: SumJackass07: Wouldn't it make more sense to set up a camera and use some form of inanimate weight? Maybe a carbon rod.

Life is about the journey, not the destination.


Life before death, strength before weakness, journey before destination.
 
2017-01-10 04:43:44 PM  

Cheron: who would ever need more than 1,048,576 65,535 rows.
-W. Gates


FTFY
 
2017-01-10 04:52:27 PM  
meanmutton:A million records seems like a nice, round number. The idea is that anything bigger should be a database. If you're going to limit it to 1 million, may as well go to 2^20.

True, if I was ever given a billion row Excel file to work with, I would print it out and use the resulting mountain of paper to entomb the author alive.

But, every single row index in the every XLSX file has 12 bits of completely unusable space....
 
2017-01-10 05:16:10 PM  

duckpoopy: What a waste of human life.


Yeah, I'm guessing the person who does this would not have  accomplished much anyway.  I doubt the internal monolog was "what to do today? Cure cancer? Invent the flying car? Nah, I'll just hold the down arrow for 9 hours ."

More likely,  waste of a computer.  At least we know that had the potential to be productive.
 
2017-01-10 05:26:15 PM  

freidog: meanmutton:A million records seems like a nice, round number. The idea is that anything bigger should be a database. If you're going to limit it to 1 million, may as well go to 2^20.

True, if I was ever given a billion row Excel file to work with, I would print it out and use the resulting mountain of paper to entomb the author alive.

But, every single row index in the every XLSX file has 12 bits of completely unusable space....


I've copied formulas down that far when using random numbers to generate statistics.
 
2017-01-10 05:34:43 PM  

inglixthemad: Is "Intrepid explorer" what we're calling "idiot with nothing better to do with their time" today subby?


Only circumstance and outcome has ever distinguished between the two.
 
2017-01-10 05:37:09 PM  
Anyone else remember the spyhunter easter egg in excel?  Good times.
 
2017-01-10 05:40:30 PM  
I'm gonna create a 10 second long YouTube video where I hold down the Control key and hit the down arrow.
 
2017-01-10 06:50:22 PM  
www.jamescamerononline.com
 
2017-01-10 07:00:48 PM  
Not gonna lie, he's smoking hot.
He could have me horizontally like his million rows in a second
 
2017-01-10 07:02:28 PM  

jso2897: inglixthemad: Is "Intrepid explorer" what we're calling "idiot with nothing better to do with their time" today subby?

Only circumstance and outcome has ever distinguished between the two.


Columbus is possibly the most famous explorer in the Western world. And his entire expedition was based on him screwing up unit conversions for the circumference of the Earth.
 
2017-01-10 07:02:57 PM  

Dinjiin: 2^20 rows must be for newer versions of Excel.  My copy of Excel 2003 only has 2^16 (65,536) rows.


And sadly, I've had spreadsheets longer than that (65,536)..... We actually used that as an interview question for a new admin position, tell me how you would get around this limit.  Second interviewee gave a good answer and got hired.
 
2017-01-10 07:09:31 PM  
Still more exciting than No Man's Sky.
 
2017-01-10 07:21:12 PM  

dywed88: jso2897: inglixthemad: Is "Intrepid explorer" what we're calling "idiot with nothing better to do with their time" today subby?

Only circumstance and outcome has ever distinguished between the two.

Columbus is possibly the most famous explorer in the Western world. And his entire expedition was based on him screwing up unit conversions for the circumference of the Earth.


... And genocide.
 
2017-01-10 07:37:14 PM  
Some 15 years ago I inherited a 4500 line video test file, written in C.  It was a mishmash of #if, #ifdefs, #endifs, etc.  You couldn't really parse it as if you tried to match curly braces you matched stuff #ifdef'd out.   Indentation?  Previous coders used tabs.  Some 2 spaces, some 4, some 8, some presumably something else.  Indent flat out puked on it.   Vim's color coding decided to hit the bar instead of helping, it was monochrome only.

I finally bit the bullet and just started hacking them out.  I'd delete a bunch of code, see if it compiled, figure out if I'd removed too much or too little, lather rinse repeat.  Took about 2 days but I got that code down to something like 300 lines.  300 easily understood lines.
 
Displayed 50 of 62 comments


Oldest | « | 1 | 2 | » | Newest | Show all


View Voting Results: Smartest and Funniest

This thread is archived, and closed to new comments.

Continue Farking

On Twitter





Top Commented
Javascript is required to view headlines in widget.
  1. Links are submitted by members of the Fark community.

  2. When community members submit a link, they also write a custom headline for the story.

  3. Other Farkers comment on the links. This is the number of comments. Click here to read them.

  4. Click here to submit a link.

Report