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

Bondo

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

jdc

  • Godfather
  • ******
  • Posts: 6415
  • Accept the mystery
Re: What I Learned Today
« Reply #14441 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: 10456
  • When not sure if sarcasm look at username.
    • Pretentiously Yours
Re: What I Learned Today
« Reply #14442 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: 6415
  • Accept the mystery
Re: What I Learned Today
« Reply #14443 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

DarkeningHumour

  • Objectively Awesome
  • *****
  • Posts: 10456
  • When not sure if sarcasm look at username.
    • Pretentiously Yours
Re: What I Learned Today
« Reply #14444 on: September 10, 2018, 10:47:37 AM »
On thing I learned the hard way: with files that size, one must avoid array formulas like the devil, unless one likes to wait fifteen minutes every time one wants to create a new row.
« Society is dumb. Art is everything. » - Junior

https://pretensiouslyyours.wordpress.com/

jdc

  • Godfather
  • ******
  • Posts: 6415
  • Accept the mystery
Re: What I Learned Today
« Reply #14445 on: September 10, 2018, 05:50:24 PM »
On thing I learned the hard way: with files that size, one must avoid array formulas like the devil, unless one likes to wait fifteen minutes every time one wants to create a new row.


Turn off auto recalculate

https://support.office.com/en-us/article/change-formula-recalculation-iteration-or-precision-f38c7793-0367-41ce-b892-dfe54946bd76#__toc305944076
"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

1SO

  • FAB
  • Objectively Awesome
  • *****
  • Posts: 31400
  • Marathon Man
Re: What I Learned Today
« Reply #14446 on: September 10, 2018, 11:54:08 PM »
This month has a genre theme.

Screwball September, which mostly focuses on screwball comedy but expands out to all comedies.
Must See  |  Should See  |  Good  |  Mixed  |  Bad

oldkid

  • Objectively Awesome
  • *****
  • Posts: 18414
  • Hi there! Feed me worlds!
Re: What I Learned Today
« Reply #14447 on: September 12, 2018, 05:42:30 PM »
This month has a genre theme.

Screwball September, which mostly focuses on screwball comedy but expands out to all comedies.

Where's our marathon?
"It's not art unless it has the potential to be a disaster." Bansky

1SO

  • FAB
  • Objectively Awesome
  • *****
  • Posts: 31400
  • Marathon Man
Re: What I Learned Today
« Reply #14448 on: September 12, 2018, 06:47:12 PM »
I would’ve loved to. Who doesn’t enjoy laughter.
Must See  |  Should See  |  Good  |  Mixed  |  Bad

oldkid

  • Objectively Awesome
  • *****
  • Posts: 18414
  • Hi there! Feed me worlds!
Re: What I Learned Today
« Reply #14449 on: September 13, 2018, 12:45:40 AM »
Maybe next year.
"It's not art unless it has the potential to be a disaster." Bansky