Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Not looking for a job? Tell us about your ideal job,
and we'll only contact you when it opens up.
https://www.dwsimpson.com/register


Reply
 
Thread Tools Display Modes
  #31  
Old 11-06-2009, 09:33 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
Non-Actuary
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,034
Default

+ or - 250 MB?
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #32  
Old 11-07-2009, 05:16 AM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 76,792
Blog Entries: 6
Default

Hmmm. Less than. I think it's the recalculation before save that's really hitting me [I have it on manual, recalculate before save]
Reply With Quote
  #33  
Old 11-07-2009, 08:49 AM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,905
Default

Quote:
Originally Posted by campbell View Post
large enough that it takes about a minute to save.

That's very annoying.
I have a massive spreadsheet like that. We even turned off calculate before saving and ONLY calculate before preparing PDF reports (every week). Interesting project, but a LOT of work.
Reply With Quote
  #34  
Old 11-09-2009, 07:23 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,628
Default

Quote:
Originally Posted by campbell View Post
Excel didn't crash per se, but it was interfering with my other stuff as it was autosaving a huge spreadsheet every ten minutes.

You better believe I switched that setting.
I have successfully recovered Word documents via autosave. It has never done me any good for Excel, though.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Mar 15, 2017.

Spoiler:
I should keep these two permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
MORE:
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
All round good advice:
Quote:
Originally Posted by snikelfritz View Post
Don't live your life by other people's expectations.
Reply With Quote
  #35  
Old 11-11-2009, 10:19 AM
KandaBer KandaBer is offline
Member
SOA AAA
 
Join Date: Nov 2006
Studying for FSA Modules
Posts: 671
Default

I looked at Excel cross-eyed.
Reply With Quote
  #36  
Old 11-12-2009, 10:13 AM
F-9's Avatar
F-9 F-9 is offline
Member
SOA AAA
 
Join Date: Nov 2007
Posts: 185
Default

Let's not calculate formulas, even though Calculation is set to Automatic.
Reply With Quote
  #37  
Old 11-12-2009, 10:39 AM
KandaBer KandaBer is offline
Member
SOA AAA
 
Join Date: Nov 2006
Studying for FSA Modules
Posts: 671
Default

Quote:
Originally Posted by KandaBer View Post
I looked at Excel cross-eyed.
Forgot to perform the midnight sacrificial rite.
Reply With Quote
  #38  
Old 11-17-2009, 11:10 AM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
Non-Actuary
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,034
Default

Copy/Paste Formulas over a few thousand cells.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #39  
Old 11-19-2009, 03:44 PM
KandaBer KandaBer is offline
Member
SOA AAA
 
Join Date: Nov 2006
Studying for FSA Modules
Posts: 671
Default



Can I pre-bump this thread, so I don't waste time when (inevitably) Excel crashes?
Reply With Quote
  #40  
Old 11-19-2009, 03:48 PM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 63,117
Default

Quote:
Originally Posted by ShakeNBakes View Post
when you say huge, how big do you mean? I've got a couple spreadsheets I think are quite large, and I've always wondered how they stack up across the biz.
My largest spreadsheet is the one that is setup to do our stochastic analysis of reserves. Once the simulation data is done and saved each quarter, it approaches 400MB.
__________________


"I am a most unhappy man. I have unwittingly ruined my country. A great industrial nation is now controlled by its system of credit. We are no longer a government by free opinion, no longer a government by conviction and the vote of the majority, but a government by the opinion and duress of a small group of dominant men." -- Woodrow Wilson

It doesn't matter who you vote for, the government always gets in. -- Elizabeth May

???? Jan 20: Freedom for the Bill of Rights

1 2
Reply With Quote
Reply

Tags
data science

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 10:50 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.20329 seconds with 9 queries