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


Reply
 
Thread Tools Display Modes
  #61  
Old 07-27-2017, 04:23 PM
MG's Avatar
MG MG is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Midwest
Posts: 4,649
Default

Quote:
Originally Posted by JMO View Post
The answer to the first question depends on the manager. You should ask them this question. On your first day. And remember the answer.
This. And everything else JMO wrote.

I normally don't mind if the intern stops over to ask something. But not 10x per day. Because it does break my concentration on whatever I'm working on. And be prepared when you come talk to me, so you don't have to keep coming back every 10 minutes because you didn't anticipate any of my follow-up questions.


Quote:
Originally Posted by blade.runner View Post
i respect her process, however, but i do believe that efficiency triumphs over tradition. and i do not see the problem in me motivating a modification in my superior's behavior.
You're not modifying her behavior, you're just annoying her. If she needs updates from multiple people, e-mail may in fact be more efficient for her to keep track of the statuses. You're projecting your own experience/preference onto other people.

Which leads me to another piece of advice... you are more likely to get people to help you (etc) if you make their lives easier and honor their preferences (to the extent possible) instead of doing things that annoy them, even if you'd prefer to do it differently. So ask questions to figure out what works best for people.

Last edited by MG; 07-28-2017 at 09:09 AM..
Reply With Quote
  #62  
Old 07-27-2017, 05:00 PM
L. Mo's Avatar
L. Mo L. Mo is offline
Muppet Queen
Site Supporter
CAS AAA
 
Join Date: Jan 2002
Location: 123 Sesame Street
Studying for my yearly physical
Favorite beer: battered onion rings
Posts: 8,379
Default

Quote:
Originally Posted by mathmajor View Post
Very useful excel formulae:
Sumproduct((2D range)*(parameter1=x)*(parameter2=y))
Array product-sums like {=sum(a1:z10 * a1:z1)}
index/match, search, left/right, date(x), eomonth, eoyear
Indirect
iserror, isna
Excel: learn the following functions immediately, if you haven't used them before:

SUM, PRODUCT, SUMPRODUCT
SUMIF(S)
COUNTIF(S)
IFERROR, IFNA
GROWTH
VLOOKUP, HLOOKUP, LOOKUP
OFFSET, INDEX
RANK
LEFT,RIGHT,MID,SEARCH,FIND (and nesting the last 2 in the first 3!)
INDIRECT

I disagree wholeheartedly on the array formulas. They are a PITA to edit and use, if you don't use them all the time. Others will not be able to figure out what the heck you're doing...especially us old-timers!
__________________

Life sucks like a hoover. Grab the handle or get in the bag. fun king ded
http://www.actuarialoutpost.com/actu...82&postcount=5 Maine-iac thinks I'm smart
Reply With Quote
  #63  
Old 07-27-2017, 05:04 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 87,628
Default

Also, for INDIRECT: there had better be no other way to get it done.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
Reply With Quote
  #64  
Old 07-27-2017, 06:05 PM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 7,097
Default

Quote:
Originally Posted by blade.runner View Post
moreover, if the hidden sheet is being linked to, then the uninformed client would think that the analysis is coming from jesus rather than a hidden sheet.

i dont like providing clients a values only sheet where they would benefit from sensitivity testing (change enrollment, change trend, change demographics etc). thus, i prefer to lock my computation sheet and then hide it, and then lock the structure.

it can be argued that a motivated person can bypass the locked structure (i personally dont know how), but i think that that the reward vs time invested in that attempt is not desirable. whereas this method of 'very hidden sheet' is just a bit of a show off!
Removing the password from a protected sheet is a very simple macro that can be googled in about 10 seconds. Finding the very hidden sheet usually requires actually knowing about the option.
__________________
I am a scientist. I am sorry to disappoint you but I have never seen an elf or a troll. But who am I to exclude their existence? - Arni Bjoernsson
You are stupid and evil and do not know you are stupid and evil. ... Dumb students are educated stupid. - timecube.com
Usually while I'm reading, I'm actually thinking about...midgets riding toy horses - Roto


Reply With Quote
  #65  
Old 07-27-2017, 07:27 PM
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: 78,966
Blog Entries: 6
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
Also, for INDIRECT: there had better be no other way to get it done.
damn straight
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #66  
Old 07-27-2017, 09:04 PM
tunmi tunmi is offline
 
Join Date: Mar 2016
College: MSU
Posts: 1
Default

Thank you all for this. It's certainly coming in handy.
Reply With Quote
  #67  
Old 07-28-2017, 07:51 AM
ShivamS's Avatar
ShivamS ShivamS is offline
Member
SOA
 
Join Date: Mar 2013
College: Yep
Favorite beer: Sweetwater Blue
Posts: 2,901
Default

How about some discussion on WFH when you're new (< 2 years)? Do we all agree that it should be the exception (repairman visiting) and not the norm (every Friday or two).
__________________
Spoiler:
Quote:
Originally Posted by Agadefe View Post

Physical violence as acceptable reaction or outdated masculine bravado as a positive quality is definitely not something the country should be moving towards or qualities we want to see in a President.



Reply With Quote
  #68  
Old 07-28-2017, 08:02 AM
yoyo's Avatar
yoyo yoyo is offline
Member
CAS
 
Join Date: Dec 2001
Posts: 20,734
Default

When sending a spreadsheet for others to review or use, save the file so that it opens to the tab and cell(s) you want the user to see first and focus on. If you've created an exhibit showing results, that's what the user should see first, not some random location in the middle of a sea of data, pivot tables, etc.
Reply With Quote
  #69  
Old 07-28-2017, 09:08 AM
MG's Avatar
MG MG is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Midwest
Posts: 4,649
Default

Quote:
Originally Posted by yoyo View Post
When sending a spreadsheet for others to review or use, save the file so that it opens to the tab and cell(s) you want the user to see first and focus on. If you've created an exhibit showing results, that's what the user should see first, not some random location in the middle of a sea of data, pivot tables, etc.


In addition, set all of the tabs so that the top/left (or whatever is appropriate) is how it will be seen first. Nothing like clicking through tabs where the display is randomly on cell AA58, for example.
Reply With Quote
  #70  
Old 07-28-2017, 09:12 AM
L. Mo's Avatar
L. Mo L. Mo is offline
Muppet Queen
Site Supporter
CAS AAA
 
Join Date: Jan 2002
Location: 123 Sesame Street
Studying for my yearly physical
Favorite beer: battered onion rings
Posts: 8,379
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
Also, for INDIRECT: there had better be no other way to get it done.
I don't use it often, but it's handy in certain situations.
__________________

Life sucks like a hoover. Grab the handle or get in the bag. fun king ded
http://www.actuarialoutpost.com/actu...82&postcount=5 Maine-iac thinks I'm smart
Reply With Quote
Reply

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 01:55 AM.


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.44518 seconds with 11 queries