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


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
  #31  
Old 11-25-2015, 02:56 PM
snikelfritz's Avatar
snikelfritz snikelfritz is offline
Member
 
Join Date: Jun 2011
Location: Yep
Studying for Nope
Favorite beer: Yep
Posts: 27,409
Default

And, spreadsheets are often NOT the right tool for the job.
__________________
The universe is a cruel uncaring void, the key to being happy isn't the search for meaning, it's to just keep yourself busy with unimportant nonsense and eventually, you'll be dead.
Reply With Quote
  #32  
Old 11-25-2015, 02:59 PM
2pac Shakur 2pac Shakur is offline
Member
SOA
 
Join Date: Jun 2003
Location: short
Posts: 94,211
Default

Quote:
Originally Posted by snikelfritz View Post
And, spreadsheets are often NOT the right tool for the job.
true - but usually they are
__________________
Reply With Quote
  #33  
Old 11-25-2015, 03:01 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 14,113
Default

Quote:
Originally Posted by snikelfritz View Post
And, spreadsheets are often NOT the right tool for the job.
They're all I got
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #34  
Old 11-25-2015, 04:47 PM
Abelian Grape's Avatar
Abelian Grape Abelian Grape is offline
Meme-ber                         Meme-ber
CAS
 
Join Date: Jul 2014
Favorite beer: Allagash Curieux
Posts: 43,244
Default

Quote:
Originally Posted by 2pac Shakur View Post
true - but usually they are
__________________

live laugh love
Reply With Quote
  #35  
Old 11-25-2015, 05:49 PM
Dr T Non-Fan Dr T Non-Fan is online now
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 99,737
Default

What kind of CE credits would this course be?
__________________
"Facebook is a toilet." -- LWTwJO

"45 es un titere" -- Seal of The President of The United States of America protest art

“That is reminiscent of Harry Truman’s famous saying, ‘The buck stops, uh, somewhere over there, maybe?' That is a level of dodging responsibility that Trump has been perfecting ever since he was very much not in Vietnam.” -- LWTwJO
Reply With Quote
  #36  
Old 11-25-2015, 06:46 PM
actuary21c actuary21c is offline
Member
 
Join Date: Sep 2009
Location: UK
Studying for double bass & jazz piano
Posts: 1,786
Default

Quote:
Originally Posted by 2pac Shakur View Post
yup

instead of sheet 1 sheet 2 sheet 3
default in excel should be
inputs - calculations - output

although i sometimes put input on the output page to see updated iterative results immediately


(PS: the default in Excel 2016 - and from memory I think in Excel 2013 - is just to have Sheet 1. Which is an improvement on Sheet 1, Sheet 2, Sheet 3 because many workbooks I have seen end up with at least one of those sheets sitting there unused, and wasting time for anyone who looks at the file, checking to see whether that sheet does anything.)
If I *have* to use Excel for anything with significant calculations, then I follow (as per my VBA course) the following model:
Inputs and outputs in Excel (on different sheets as you suggest for clarity). Do the calculations in VBA with clear distinction between the following
Read inputs
Do processing
Write out outputs.

Put comments in the code as needed (but try and minimise the need for comments by using meaningful variable and function names). Keep the scope of each variable as narrow as possible.

Much easier to maintain, and avoids the danger of formulae being copied incorrectly (or with incorrect cell values) from one cell to another.
__________________
Spoiler:

Quote:
Originally Posted by Brock View Post
a21c is one of the better posters on the AO. That's not saying he's good.

UK software developer, actuary, musician, atheist. All posts in a personal capacity (unless explicitly stated otherwise in the post).

Last edited by actuary21c; 11-25-2015 at 06:51 PM.. Reason: added the PS
Reply With Quote
  #37  
Old 11-28-2015, 08:33 AM
limabeanactuary's Avatar
limabeanactuary limabeanactuary is offline
Mary Pat Campbell
 
Join Date: Jan 2010
Studying for Anglo-Saxon
Favorite beer: Bass Ale
Posts: 14,222
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
What kind of CE credits would this course be?
FWIW, I will be referencing two ASOPs (41 & 23) with respect to spreadsheets, but I wouldn't say the whole is on professionalism.

All the examples I will be using in spreadsheet form will be actuarial applications (annuity factor calculator is the main example, but I may pull in a couple others).

I don't know how that particularly rates as CE under SOA, CAS, or AAA requirements, but it will have more actuarial content than many SOA meeting sessions I've been to.
__________________
STUMP
Reply With Quote
  #38  
Old 11-28-2015, 09:29 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,643
Default

Quote:
Originally Posted by limabeanactuary View Post
FWIW, I will be referencing two ASOPs (41 & 23) with respect to spreadsheets, but I wouldn't say the whole is on professionalism.

All the examples I will be using in spreadsheet form will be actuarial applications (annuity factor calculator is the main example, but I may pull in a couple others).

I don't know how that particularly rates as CE under SOA, CAS, or AAA requirements, but it will have more actuarial content than many SOA meeting sessions I've been to.
In any case, actuaries are supposed to make a personal judgment as to whether any particular course extends or deepens their understanding. I have sometimes taken only 50% credit, for example, on sessions that spend half the time on stuff I already knew.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Nov. 20, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #39  
Old 11-28-2015, 01:41 PM
PackFan47 PackFan47 is offline
Member
CAS
 
Join Date: Oct 2013
Posts: 29,346
Default

Quote:
Originally Posted by JMO View Post
+1

And I like to see the presentation on a separate tab, same as input goes on a separate tab.

Comments can then be used liberally on the calculation tabs. I don't want them inside the formula, though.
Reply With Quote
  #40  
Old 12-08-2015, 09:37 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: 93,072
Blog Entries: 6
Default



Tomorrow!
__________________
It's STUMP

LinkedIn Profile
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 03:38 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.24809 seconds with 9 queries