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

DW Simpson International Actuarial Jobs
Canada  Asia  Australia  Bermuda  Latin America  Europe


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-21-2019, 02:07 PM
ACTEX_Pubs ACTEX_Pubs is offline
Member
Non-Actuary
 
Join Date: Jun 2014
Posts: 157
Default Mary Pat Campbell's Next Webinar: Error Checking and Review of Actuarial Spreadsheets

ACTEX eLearning Webinar: Error Checking and Review of Actuarial Spreadsheets

Instructor: Mary Pat Campbell, FSA, MAAA, PRM

Date: June 11, 2019 1:00 - 2:30 PM ET

Credits/Training Hours: 1.8 SOA/EA CPD, CAS CE | Potential 1.5 CIA CPD

Co-sponsor: Canadian Institute of Actuaries


Early Registration Pricing Ends: 5/29/19


Description:
Actuaries use spreadsheets as one of their core calculation tools, and to uphold the high standards of our profession, we need to be on the lookout to prevent, detect, and fix errors, as well as document that the spreadsheets work as needed.

This ACTEX eLearning webinar will look at principles and practical processes to achieve better spreadsheets. This webinar is a reboot of a similar one produced in early 2016 Ė updated to include developments in technology and actuarial standards since then.

In this webinar we will review and explore Microsoft Excelís built-in tools for tracing errors in Microsoft Excel and the Microsoft Excel Visual Basic (VBA) Editor, as well as consider structured processes in order to verify oneís calculations. There will be a demo of specific behaviors/techniques using an actuarial example, and there will be references to the ASOPs (but not too much!).

Learn more at www.actexmadriver.com/product.aspx?id=453144126
__________________
ACTEX Learning | Mad River Books
PO Box 715 | New Hartford, CT | 06057
P (800) 282-2839 | Support@ActexMadRiver.com
www.ActexMadRiver.com
Visit ACTEX_Pubs on Twitter & Facebook
Reply With Quote
  #2  
Old 05-31-2019, 11:47 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: 89,918
Blog Entries: 6
Default

To cross-reference:

https://blog.actexmadriver.com/to-er...prevent-divine

Quote:
To Err is Human; To Detect and Prevent, Divine
By Mary Pat Campbell

Mary Pat headshotOver a decade ago, I wrote my first article on spreadsheet errors. It was titled “To Err Is Human; To Correct, Divine”, and ran in the SOA’s technology section newsletter, detailing the commonality of spreadsheet errors – even among (or, I should say, especially among) numerical computing experts.

.....
Follow the link for more:
https://blog.actexmadriver.com/to-er...prevent-divine

[Sign up for my webinar!]
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #3  
Old 06-04-2019, 01:06 PM
mathmajor's Avatar
mathmajor mathmajor is offline
Member
SOA AAA
 
Join Date: Dec 2010
Location: Nowhere in particular
Studying for Japanese
College: B.S. Applied Math
Favorite beer: La Croix Grapefruit
Posts: 12,100
Default

(Mary Pat headshot) lol
__________________
Quote:
Originally Posted by redprinceton
YOU ARE AN EXCEPTIONAL PERSON MATHMAJOR!
Reply With Quote
  #4  
Old 06-04-2019, 01:19 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for ACAS
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 66,131
Default

Quote:
Originally Posted by mathmajor View Post
(Mary Pat headshot) lol



FWIW, I know that she's gunning for a headshot on me.
__________________
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
  #5  
Old 06-04-2019, 01:24 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: 89,918
Blog Entries: 6
Default

Oh duh.

That's what I get for copy/paste
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #6  
Old 06-05-2019, 01:52 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: 89,918
Blog Entries: 6
Default

See, -anybody- can make a copy/paste error! (I often make copy/paste errors)

in other news, another promo for the webinar:
https://www.linkedin.com/pulse/know-...l/?published=t

Quote:
Know How Things Break in Excel...and How to Repair Them

Things break. Mistakes happen. Errors abound.

That's not necessarily a problem, unless you don't know how to fix these things... and if you don't know how or why things broke in the first place. That means these problems will keep happening again and again... slowing us down, or, even worse, giving us wrong results.

I work in insurance/finance, and one of my core tools is Excel. As with most Excel users, I run into errors all the time. Many times, it was an error driven by a change in data sources, a different user of the spreadsheets I used, or even a simple copy/paste error I created myself.

I have a practice of seeking for errors, and long experience in tracing and repairing errors, which has made my life easier. Over the years, Microsoft has added tools to Excel to make it easier for developers and users to trace where things have gone wrong and to fix them.

However, even with these, we are still getting Excel horror stories, such as this bankruptcy in which a spreadsheet error played a part, $6 billion in trading losses due to a faulty spreadsheet formula, and more.

To be sure, in some of these cases, spreadsheets were a completely inappropriate tool -- and the people involved weren't interested in having good financial controls. But even where spreadsheets weren't necessarily inappropriate, we frequently find people not even bothering to check for errors or trying to prevent them.

However, as actuaries, we are held to a higher standard through our professional principles. If we're going to use spreadsheets, we need to make sure we provide accurate calculations, of which error-checking and prevention is a key part.

(And if you're not an actuary... don't you want to have top standards anyway? The way to prevent the commodification of your work is to stand out from the "usual".)

In my upcoming webinar, I will be covering errors in Excel and various practices and tools to check, prevent, and repair errors.

Please join me on Tuesday, June 11 -- let's clean up our spreadsheets!

My blog post at Actex: To Err is Human; To Detect and Prevent, Divine

Error Checking and Review of Actuarial Spreadsheets: webcast on Tuesday, 11 June 2019, 1-2:30pmET. Details here!

And no, not copying over the links.
__________________
It's STUMP

LinkedIn Profile
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 10:28 AM.


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