love

Author Topic: What I Learned Today  (Read 1463851 times)

DarkeningHumour

  • Objectively Awesome
  • ******
  • Posts: 10453
  • When not sure if sarcasm look at username.
    • Pretentiously Yours
Re: What I Learned Today
« Reply #14540 on: August 02, 2018, 03:39:33 AM »
As long as you stay away from garden gnomes. They are total creeps.
« Society is dumb. Art is everything. » - Junior

https://pretensiouslyyours.wordpress.com/

oldkid

  • Objectively Awesome
  • ******
  • Posts: 19044
  • Hi there! Feed me worlds!
Re: What I Learned Today
« Reply #14541 on: August 02, 2018, 08:47:27 PM »
Yeah, I try to avoid garden gnomes.

https://www.youtube.com/watch?v=EVLuG-ProiM
"It's not art unless it has the potential to be a disaster." Bansky

Corndog

  • Objectively Awesome
  • ******
  • Posts: 17025
  • Oo-da-lolly, Oo-da-lolly, golly what a day!
    • Corndog Chats
Re: What I Learned Today
« Reply #14542 on: August 14, 2018, 02:21:29 PM »
Miguel Ferrer and George Clooney were cousins.
"Time is the speed at which the past decays."

colonel_mexico

  • Elite Member
  • ****
  • Posts: 1416
Re: What I Learned Today
« Reply #14543 on: August 29, 2018, 12:48:00 PM »
In reading a case about the film THE SWARM, the court suggests that the term 'blockbuster' has been defined as "anything of devastating effect." The resulting devastating losses on Presidio's box office could be the blockbuster effect THE SWARM and Warner Bros studio meant by 'blockbuster of the summer' lol
"What do you want me to do draw you a picture?! Spell it out?! Don't ever ask me, as long as you live don't ever ask me more!"

jdc

  • Godfather
  • *****
  • Posts: 7799
  • Accept the mystery
Re: What I Learned Today
« Reply #14544 on: September 06, 2018, 08:20:43 AM »
Why the close door button in an elevator the US doesn't work... (it works everywhere I have been in Asia)
"Beer. Now there's a temporary solution."  Homer S.
“The direct use of physical force is so poor a solution to the problem of limited resources that it is commonly employed only by small children and great nations” - David Friedman

DarkeningHumour

  • Objectively Awesome
  • ******
  • Posts: 10453
  • When not sure if sarcasm look at username.
    • Pretentiously Yours
Re: What I Learned Today
« Reply #14545 on: September 06, 2018, 01:44:29 PM »
A 40MG Excel file can crash surprisingly often.
« Society is dumb. Art is everything. » - Junior

https://pretensiouslyyours.wordpress.com/

Bondo

  • Objectively Awesome
  • ******
  • Posts: 23082
Re: What I Learned Today
« Reply #14546 on: September 06, 2018, 04:52:58 PM »
I have some that are well over 100MB. So I get it.

jdc

  • Godfather
  • *****
  • Posts: 7799
  • Accept the mystery
Re: What I Learned Today
« Reply #14547 on: September 06, 2018, 08:32:03 PM »
I have some that are well over 100MB. So I get it.

Same here though I don't normally have them causing my Excel to crash. I think you will get to 100MB somewhere around 100k to 150k rows of data and 20-30 columns wide and a few tabs with pivot tables. Excel goes to just over 1M rows so something wrong if 40MB or 100MB files cause it to crash unless the computer is resourced constrained? 
"Beer. Now there's a temporary solution."  Homer S.
“The direct use of physical force is so poor a solution to the problem of limited resources that it is commonly employed only by small children and great nations” - David Friedman

DarkeningHumour

  • Objectively Awesome
  • ******
  • Posts: 10453
  • When not sure if sarcasm look at username.
    • Pretentiously Yours
Re: What I Learned Today
« Reply #14548 on: September 10, 2018, 04:23:33 AM »
A semi-large file + a shitty computer + using a server = multiple crashes.

It got better when I pasted it into my computer and worked from there. I don't think there was that much data (very long columns, but not many of them), just lots of graphs. It got even better when I deleted all the useless stuff people had put in it.

In another job I had to work with files that had thousands upon thousands of rows and plenty of columns. Just opening them was hell, let alone refresh a pivot table.
« Society is dumb. Art is everything. » - Junior

https://pretensiouslyyours.wordpress.com/

jdc

  • Godfather
  • *****
  • Posts: 7799
  • Accept the mystery
Re: What I Learned Today
« Reply #14549 on: September 10, 2018, 08:55:37 AM »
Getting rid of useless stuff is a good policy no matter what.  As far as the amount of data, I am use to working with spreadsheets that are 60+ columns wide and 150,000 rows without crashing on a local PC linked to Pivot tables but not trying to create a lot of graphics from it. I am not sure which is more resource intensive. But always better trying to use from a local file.

"Beer. Now there's a temporary solution."  Homer S.
“The direct use of physical force is so poor a solution to the problem of limited resources that it is commonly employed only by small children and great nations” - David Friedman

 

love