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


Reply
 
Thread Tools Display Modes
  #61  
Old 01-21-2010, 03:06 PM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,905
Default

Quote:
Originally Posted by strategygamer View Post

Same thing here . I got everything back.
Excel has a nice habit of crashing and not recovering anything when I haven't saved in a while.
I've started being an uber-save-fanatic. Every 5 minutes. Save. Change a formula. Save. Calculate that massive spreadsheet (15 minute calculate time!!! Yikes! (was initially instantaneous, but after loading 17 weeks of data... yeah)). Save.
Reply With Quote
  #62  
Old 01-22-2010, 05:48 PM
Laurelinda's Avatar
Laurelinda Laurelinda is offline
Member
SOA
 
Join Date: Sep 2006
Location: Carnegie Hall
Studying for a Bach-Busoni Recital
Favorite beer: Tia Maria...I know...it isn't beer.
Posts: 1,053
Default

Gosh I should have been bumping this thread a long time ago.
Reply With Quote
  #63  
Old 02-02-2010, 01:34 PM
E's Avatar
E E is online now
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 8,694
Default



No explanation.
__________________


Registration is open for all of our spring/fall 2017 FSA exam online seminars:

ILA-LP | ILA-LFV-U | ILA-LFV-C | ILA-LRM | QFI Core | QFI Adv | G&H Core | G&H Advanced | G&H Specialty

Check out our Technical Skills Course: Excel, VBA, Access, brand new R material, and more!

Follow us on Twitter, Facebook, and LinkedIn
Reply With Quote
  #64  
Old 02-03-2010, 02:58 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



Multiple pivots linked to a database with over 1.3M rows. Yeah, that oughtta do it.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #65  
Old 02-03-2010, 03:10 PM
vividox's Avatar
vividox vividox is offline
Lead Guitarist
Non-Actuary
 
Join Date: Dec 2008
Favorite beer: Avery Mephistopheles
Posts: 55,778
Default

I didn't realize you could have 1.3M rows in Excel. Is that an add-on or something?
__________________
This post was crafted using a special blend of herbs and sarcasm.
Reply With Quote
  #66  
Old 02-03-2010, 03:11 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

Quote:
Originally Posted by ADoubleDot View Post


Multiple pivots linked to a database with over 1.3M rows. Yeah, that oughtta do it.
M$ Access. Though I think in Excel 2010, you can have that many.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #67  
Old 02-03-2010, 03:12 PM
vividox's Avatar
vividox vividox is offline
Lead Guitarist
Non-Actuary
 
Join Date: Dec 2008
Favorite beer: Avery Mephistopheles
Posts: 55,778
Default

Oh yes, I fail at reading comprehension.
__________________
This post was crafted using a special blend of herbs and sarcasm.
Reply With Quote
  #68  
Old 02-03-2010, 03:20 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 ADoubleDot View Post
M$ Access. Though I think in Excel 2010, you can have that many.
2007 allows just over 1M rows, and that was just due the memory limits of 32-bit.

2010 might have 100M rows available.
__________________


"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
  #69  
Old 02-03-2010, 03:52 PM
tommie frazier tommie frazier is offline
Member
 
Join Date: Aug 2003
Favorite beer: The kind with 2 e's
Posts: 22,105
Default

figure about a dozen posts in here for me.

excel 2007.

some have 400k rows. ugh.
Reply With Quote
  #70  
Old 02-03-2010, 04:34 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

Quote:
Originally Posted by MountainHawk View Post
2007 allows just over 1M rows, and that was just due the memory limits of 32-bit.

2010 might have 100M rows available.
You know that its out right? You need not speculate. I knew it was high but I don't think its 100M high.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
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 09:42 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.17615 seconds with 9 queries