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

DW Simpson Global Actuarial & Analytcs Recruitment
Download our 2017 Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Search this Thread 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,909
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: 9,043
Default



No explanation.
__________________


Learn how FSA exams are different from the prelims

We have your exam covered:

LP | LFV-U | LFV-C | LRM | ERM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Sp

Check out our Technical Skills Course and our new R Course!

Connect on Twitter, Facebook, & LinkedIn
Reply With Quote
  #64  
Old 02-03-2010, 02:58 PM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,137
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: 57,333
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
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,137
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: 57,333
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: 64,850
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.
__________________

Play in the AO Prediction Game now!



1
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,730
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
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,137
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 Search this Thread
Search this Thread:

Advanced Search
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 02:49 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, 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.41364 seconds with 11 queries