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

ACTUARIAL SALARY SURVEYS
Contact DW Simpson for a Personalized Salary Survey

General Actuarial Non-Specific Actuarial Topics - Before posting a thread, please browse over our other sections to see if there is a better fit, such as Careers - Employment, Actuarial Science Universities Forum or any of our other 100+ forums.

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 11-24-2015, 05:47 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

Quote:
Originally Posted by campbell View Post
It's pretty difficult to avoid all the other webcasts going on..
Couldn't get your Excel calendar working, could you?
__________________
Life is unfair
Reply With Quote
  #12  
Old 11-24-2015, 05:58 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

Quote:
Originally Posted by campbell View Post
And yes, I will address the VLOOKUP vs. INDEX/MATCH controversy (among other things).
Will one of those "other things" be your top ten uses of RAND()?
__________________
Life is unfair
Reply With Quote
  #13  
Old 11-25-2015, 10:56 AM
Dan Moore's Avatar
Dan Moore Dan Moore is offline
Member
SOA AAA
 
Join Date: Jan 2008
College: University of Dallas
Posts: 2,921
Blog Entries: 1
Default

MPC, you can talk about using Alt-Enter to tidy up long formulas, as illustrated here.
__________________
The best time to plant an oak tree is twenty years ago. The second best time is right now.
Reply With Quote
  #14  
Old 11-25-2015, 11:00 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: 93,072
Blog Entries: 6
Default

Yes, by not making such hideous things to begin with
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #15  
Old 11-25-2015, 11:20 AM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

They wouldn't be so hideous if the authors embedded comments into their code.
__________________
Life is unfair
Reply With Quote
  #16  
Old 11-25-2015, 12:00 PM
Dan Moore's Avatar
Dan Moore Dan Moore is offline
Member
SOA AAA
 
Join Date: Jan 2008
College: University of Dallas
Posts: 2,921
Blog Entries: 1
Default

Quote:
Originally Posted by campbell View Post
Yes, by not making such hideous things to begin with
Quote:
Originally Posted by Malcolm View Post
They wouldn't be so hideous if the authors embedded comments into their code.
I'm not sure what you're calling hideous. My point is that the first formula below is easier to read than the second formula, even though they are essentially identical. The first formula has Alt-Enters placed within the formula to tidy it up, without affecting the formula result.

=SUMPRODUCT(
INDEX(AllRates!M$5:M$40000,$N134):INDEX(AllRates!M $5:M$40000,$N134-1+IF($O134="to",Q$1,$O134)),
INDEX(DIMOD2COLA!$T$7:$U$976,1,$P134):INDEX(DIMOD2 COLA!$T$7:$U$976,IF($O134="to",Q$1,$O134),$P134),
INDEX(DIMOD2COLA!$B$7:$C$976,1,$A134):INDEX(DIMOD2 COLA!$B$7:$C$976,IF($O134="to",Q$1,$O134),$A134),
INDEX(DIMOD2COLA!$D$7:$K$976,1,$B134):INDEX(DIMOD2 COLA!$D$7:$K$976,IF($O134="to",Q$1,$O134),$B134),
INDEX(DIMOD2COLA!$L$7:$N$976,1,$C134):INDEX(DIMOD2 COLA!$L$7:$N$976,IF($O134="to",Q$1,$O134),$C134))

=SUMPRODUCT(INDEX(AllRates!M$5:M$40000,$N134):INDE X(AllRates!M $5:M$40000,$N134-1+IF($O134="to",Q$1,$O134)),INDEX(DIMOD2COLA!$T$7: $U$976,1,$P134):INDEX(DIMOD2 COLA!$T$7:$U$976,IF($O134="to",Q$1,$O134),$P134),I NDEX(DIMOD2COLA!$B$7:$C$976,1,$A134):INDEX(DIMOD2 COLA!$B$7:$C$976,IF($O134="to",Q$1,$O134),$A134),I NDEX(DIMOD2COLA!$D$7:$K$976,1,$B134):INDEX(DIMOD2 COLA!$D$7:$K$976,IF($O134="to",Q$1,$O134),$B134),I NDEX(DIMOD2COLA!$L$7:$N$976,1,$C134):INDEX(DIMOD2 COLA!$L$7:$N$976,IF($O134="to",Q$1,$O134),$C134))
__________________
The best time to plant an oak tree is twenty years ago. The second best time is right now.
Reply With Quote
  #17  
Old 11-25-2015, 12:01 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

They're both hideous.
__________________
Life is unfair
Reply With Quote
  #18  
Old 11-25-2015, 12:03 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

"Slightly less hideous" doesn't really jibe with "best practice" for me.
__________________
Life is unfair
Reply With Quote
  #19  
Old 11-25-2015, 12:09 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for CSPA
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 68,186
Default

Named ranges FTW, IMO.
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #20  
Old 11-25-2015, 12:12 PM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,345
Default

Quote:
Originally Posted by Vorian Atreides View Post
Named ranges FTW, IMO.
For a start, at least
__________________
Life is unfair
Reply With Quote
Reply

Tags
actex, excel, professionalism, spreadsheet, webinar

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:13 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, 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.23348 seconds with 9 queries