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

2017 ACTUARIAL SALARY SURVEYS
Contact DW Simpson for a Personalized Salary Survey

Reply
 
Thread Tools Search this Thread Display Modes
  #21  
Old 02-11-2019, 09:20 PM
hostess's Avatar
hostess hostess is offline
Member
CAS
 
Join Date: Aug 2018
Posts: 499
Default

Quote:
Originally Posted by Colonel Smoothie View Post
kids these days
man... glms and statistics are all ive been looking at for the past few years

Last edited by hostess; 02-11-2019 at 09:52 PM..
Reply With Quote
  #22  
Old 02-11-2019, 10:52 PM
Canadiens Fan Canadiens Fan is offline
Member
SOA
 
Join Date: Oct 2013
Location: Canada
Studying for LFV-C
Favorite beer: Blanche de Chambly
Posts: 4,376
Default

Quote:
Originally Posted by outinthedark View Post
you use that at my company, you get fired. index/match all the way.
I only use index/match when the data is to the left of the lookup column. I don't want to confuse other users with unnecessary complications, and that involves long formulas that takes time for other people to figure out.
__________________
ASA LP LFV-C LRM
Reply With Quote
  #23  
Old 02-11-2019, 11:59 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 35,512
Default

Quote:
Originally Posted by hostess View Post
for reals? I also think index/match is much easier... its just index(array,row,column)... replace row/column with match fucntion.... nothing to memorize imo esp cause excel also gives you parameter hints
totally, dude. I just haven't used it enough. Anytime I do I say to myself, "Self, that was easy. Why can't you remember that? "
Reply With Quote
  #24  
Old 02-12-2019, 09:42 AM
Climbing Bum's Avatar
Climbing Bum Climbing Bum is offline
Member
SOA AAA
 
Join Date: Sep 2012
Location: Philadelphia
College: Utah State University
Favorite beer: Yards IPA
Posts: 339
Default

Quote:
Originally Posted by Canadiens Fan View Post
I only use index/match when the data is to the left of the lookup column. I don't want to confuse other users with unnecessary complications, and that involves long formulas that takes time for other people to figure out.
Model integrity. This is why this is such a great question. If you have 8 columns and you vlookup the 7th column. Someone inserts a column your formula would break. If you index match in any number of ways you can insert columns without worrying about breaking your spreadsheet.

The answers here make me wounder about our profession. It's like a formula I saw at work the other day. If(month(b4) = 1, "January",if(month(b4) =2,"February".....

Having done work in Excel and having done it well are too completely different things. I recognize some things are more opinion based, but even then it's nice (not necessary) to work with people who work in similar ways.
__________________
|FSA Modules | |DMAC| |GHC| |GHA| |GHS|
Reply With Quote
  #25  
Old 02-12-2019, 09:50 AM
fdsafdsa's Avatar
fdsafdsa fdsafdsa is offline
Member
SOA
 
Join Date: Mar 2018
Posts: 1,852
Default

Quote:
Originally Posted by Climbing Bum View Post
Model integrity. This is why this is such a great question. If you have 8 columns and you vlookup the 7th column. Someone inserts a column your formula would break. If you index match in any number of ways you can insert columns without worrying about breaking your spreadsheet.

The answers here make me wounder about our profession. It's like a formula I saw at work the other day. If(month(b4) = 1, "January",if(month(b4) =2,"February".....

Having done work in Excel and having done it well are too completely different things. I recognize some things are more opinion based, but even then it's nice (not necessary) to work with people who work in similar ways.
This of course is why excel is a terrible modeling platform for anything that requires integrity.
__________________
You can't control other people's actions, but you can control how you react to them.
Reply With Quote
  #26  
Old 02-12-2019, 10:07 AM
Kalium Kalium is offline
Member
 
Join Date: Dec 2014
Posts: 102
Default

Quote:
Originally Posted by Helena Lake View Post
... as well as SUMIFS, COUNTIFS, etc.
No. Replace these by SUMPRODUCT, for greater flexibility
Reply With Quote
  #27  
Old 02-12-2019, 10:52 AM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is online now
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 48,445
Default

Quote:
Originally Posted by fdsafdsa View Post
This of course is why excel is a terrible modeling platform for anything that requires integrity.
Yeah and databases have had cascading updates and restrictions for several decades now. Use them, people.
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #28  
Old 02-12-2019, 11:37 AM
ShundayBloodyShunday's Avatar
ShundayBloodyShunday ShundayBloodyShunday is offline
Member
CAS
 
Join Date: Apr 2013
Posts: 2,535
Default

Quote:
Originally Posted by Climbing Bum View Post
Model integrity. This is why this is such a great question. If you have 8 columns and you vlookup the 7th column. Someone inserts a column your formula would break. If you index match in any number of ways you can insert columns without worrying about breaking your spreadsheet.

The answers here make me wounder about our profession. It's like a formula I saw at work the other day. If(month(b4) = 1, "January",if(month(b4) =2,"February".....

Having done work in Excel and having done it well are too completely different things. I recognize some things are more opinion based, but even then it's nice (not necessary) to work with people who work in similar ways.
I can make VLOOKUP work just as flexibly as INDEX + MATCH. It requires adding a bit more logistical structure to the lookup table; but through the use of named ranges, there is no need to adjust the VLOOKUP formula to attend to the addition (or deletion) of any column in the lookup table (apart from the deletion of the referenced column).
Reply With Quote
  #29  
Old 02-12-2019, 12:43 PM
The_Polymath's Avatar
The_Polymath The_Polymath is offline
Member
CAS SOA
 
Join Date: Jun 2016
Posts: 1,374
Default

And.....the Excel Wars Volume 10 Billion resume once again.
__________________
Quote:
Consistency is the hobgoblin of little minds
Reply With Quote
  #30  
Old 02-12-2019, 12:51 PM
GargoyleWaiting's Avatar
GargoyleWaiting GargoyleWaiting is offline
Member
 
Join Date: Sep 2009
Favorite beer: the closest one
Posts: 6,904
Default

=IF(PostAbove=TRUE,)
__________________
Quote:
Originally Posted by UFActuary View Post
But the mosquitoes in New Brunswick Bay of Fundy did mess with my understanding of some limited loss functions
Quote:
Originally Posted by King of the North View Post
Excel gave me #VALUE.

Edit: Nevermind, I was linking a sumif and didn't open the linked spreadsheet. It is now giving me #N/A.
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 01:49 PM.


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