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 Search this Thread Display Modes
  #21  
Old 10-23-2018, 01:15 PM
ElDucky's Avatar
ElDucky ElDucky is offline
Free Mason
 
Join Date: Jul 2004
Location: In a van, down by the river
Studying for Let me worry about blank
Favorite beer: Trappistes Rochefort 8
Posts: 42,053
Default

Hmmm, I hope it works on really complicated sumifs too.
__________________
I live near the cows.
Reply With Quote
  #22  
Old 10-23-2018, 01:29 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 93,163
Default

I've only had a problem with those functions when I've pasted 10000 or so of them.
__________________
"Facebook is a toilet." -- LWTwJO
Reply With Quote
  #23  
Old 10-23-2018, 01:31 PM
ElDucky's Avatar
ElDucky ElDucky is offline
Free Mason
 
Join Date: Jul 2004
Location: In a van, down by the river
Studying for Let me worry about blank
Favorite beer: Trappistes Rochefort 8
Posts: 42,053
Default

I sometimes have a few million. If it's bad enough a slower computer or older Excel can't even open it.
__________________
I live near the cows.
Reply With Quote
  #24  
Old 10-23-2018, 01:49 PM
Arroway's Avatar
Arroway Arroway is offline
Member
CAS SOA AAA
 
Join Date: Oct 2011
Location: In a house
Studying for Done, bois!
College: UConn
Favorite beer: Barq's or Mug, or any local Root Beer with caffeine
Posts: 306
Default

Quote:
Originally Posted by Egghead View Post

I miss Excel 97.
Bring back Clippy!
__________________
Arroway, Injustice 2 Raid Leader

All opinions are either my own, or made up for dramatic and/or comedic effect.

Reply With Quote
  #25  
Old 10-23-2018, 02:12 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 93,163
Default

Quote:
Originally Posted by ElDucky View Post
I sometimes have a few million. If it's bad enough a slower computer or older Excel can't even open it.
That seems very inefficient. I'd be modifying the query that the data come from instead, and extracting fewer rows.
But, that's me.

For example, if I had to classify claims data by area, and I have a ZIP code list for my areas (might not be the same for all business units), I could extract the claims by ZIP code and then VLOOKUP the areas, which would mean lots of rows and lots of VLOOKUPS; OR, I could upload my ZIP code list to my SQL server, and have my query JOIN the list and extract by Area instead of ZIP code.
But, that's me.
__________________
"Facebook is a toilet." -- LWTwJO

Last edited by Dr T Non-Fan; 10-23-2018 at 02:16 PM..
Reply With Quote
Reply

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 04:29 AM.


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.29629 seconds with 9 queries