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


Upload your resume securely at https://www.dwsimpson.com
to be contacted when new jobs meet your skills and objectives.


Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2017, 03:31 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: 79,369
Blog Entries: 6
Default Most Inappropriate Use of Spreadsheet

The topic of inappropriate spreadsheet use kicked off a big discussion in the European Spreadsheet Risks Interest Group, but it seems to have devolved into wanting to get a good definition of spreadsheet. So let's not go down that route.

What the most inappropriate use of a spreadsheet you've seen?

In my own case, it was something I did -- a Monte Carlo model for a lifecycle mutual fund. I really shouldn't have done it (at least I didn't use RAND()...and that's about the only good thing I can say about it), but there ya go. It led to further stupidity on my part, when I embedded the results into a Word document, unknowingly. I know it now. That's about the dumbest thing I've ever done in a professional setting.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #2  
Old 10-18-2017, 03:31 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: 79,369
Blog Entries: 6
Default

I've done some silly stuff in Excel -- like the Sierpinski fractal:
https://www.dropbox.com/s/i0x00hlwzw...ngle.xlsx?dl=0

but that was just a stunt from boredom.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #3  
Old 10-18-2017, 03:39 PM
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: 36,398
Default

Back in the day, I saw a lot of memos written in spreadsheets. Nobody knew how to use word processing but the secretaries. (That says how long ago it was.)
__________________
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 Oct 13, 2017.

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:
Quote:
Originally Posted by Bro View Post
I recommend you get perspective.
Quote:
Originally Posted by Enough Exams Already View Post
Dude, you can't fail a personality test. It just isn't that kind of test.
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Reply With Quote
  #4  
Old 10-18-2017, 03:56 PM
Abused Student's Avatar
Abused Student Abused Student is offline
Member
SOA
 
Join Date: Feb 2007
Location: The Eighth Circle of Hell
Favorite beer: Cold and lots of it
Posts: 42,142
Default

I have seen a guy who used a spreadsheet to keep track of each of the numbers he put into a printing calculator along with the total from the calculator so that he could then later go back and readd all the number (using the calculator) and make sure he got the same total.
__________________
GAME ON!!!!!!! Let your ness show. Join the D&D fun. Started but applications still accepted


Officially assigned the role of Dictator, 9/30/09. Bow to my whims.
Reply With Quote
  #5  
Old 10-18-2017, 05:47 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: 79,369
Blog Entries: 6
Default

Quote:
Originally Posted by JMO View Post
Back in the day, I saw a lot of memos written in spreadsheets. Nobody knew how to use word processing but the secretaries. (That says how long ago it was.)
I've used Excel to make nice tables, because I hate making tables in Word.

Not recently, because now I've got editors who make the tables for me in the format our style guide requires.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #6  
Old 10-18-2017, 05:55 PM
llcooljabe's Avatar
llcooljabe llcooljabe is online now
Member
CAS
 
Join Date: Aug 2002
Posts: 21,937
Default

Quote:
Originally Posted by JMO View Post
Back in the day, I saw a lot of memos written in spreadsheets. Nobody knew how to use word processing but the secretaries. (That says how long ago it was.)
I use excel to write memos all the time. I use them for rate filings that I do annually, when I have to embed numbers into the wording. I use formulas for some of the text.

e.g. ="The credibility weighted loss ratio for "&A1&" is "&text(a2,"0.0%")&"."

It's cumbersome but only the first time, but it's better than searching a word doc for all the numbers to change and accidentally missing one.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #7  
Old 10-18-2017, 06:00 PM
Childish Gambino's Avatar
Childish Gambino Childish Gambino is online now
Member
SOA
 
Join Date: Jul 2014
Posts: 20,032
Default

I've made some really unwieldy excel models over the years. Upwards of 250MB, take forever to calculate, have more splits than anyone even asked for. These mainly happen when a book gets inherited from analyst to analyst, each one adding to the Frankenstein when zhe owns it. But to be fair I have created some monsters all on my own as well. In some cases, it was important enough to pull more of the model calculations back into SAS and do it the right way but usually it's not worth the effort for process improvement when you have new things to do.

This is probably not a very interesting post for anyone but my postcount isn't going to increase itself
__________________
Quote:
Originally Posted by Pseudolus View Post
Trump's biggest weakness is that he utterly lacks the knowledge, experience, interest, attention span, temperament, and common decency to be the marginally effective President of a reasonably-large HOA.
Reply With Quote
  #8  
Old 10-18-2017, 06:25 PM
George Frankly's Avatar
George Frankly George Frankly is offline
Member
SOA AAA
 
Join Date: Aug 2011
Location: CO
Favorite beer: Sam Smith Oatmeal
Posts: 8,230
Default

Quote:
Originally Posted by Childish Gambino View Post
I've made some really unwieldy excel models over the years. Upwards of 250MB, take forever to calculate, have more splits than anyone even asked for. These mainly happen when a book gets inherited from analyst to analyst, each one adding to the Frankenstein when zhe owns it. But to be fair I have created some monsters all on my own as well. In some cases, it was important enough to pull more of the model calculations back into SAS and do it the right way but usually it's not worth the effort for process improvement when you have new things to do.

This is probably not a very interesting post for anyone but my postcount isn't going to increase itself
At my first job we had to do quarterly reporting. Someone wrote macros, which I inherited, and just kept using them. It took me about three days to run them all, we had a separate PC set up just for these reports.

Right around the time I left, we hired a consulting shop to automate it all. No idea how that worked out.
Reply With Quote
  #9  
Old 10-18-2017, 06:35 PM
llcooljabe's Avatar
llcooljabe llcooljabe is online now
Member
CAS
 
Join Date: Aug 2002
Posts: 21,937
Default

not inappropriate, but i have a ton of pet peeves for spreadsheets i inherit. Much of these are formatting related. most of those i have documented in the excel helpdesk thread.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #10  
Old 10-18-2017, 11:07 PM
ahow's Avatar
ahow ahow is offline
Member
CAS
 
Join Date: Nov 2003
Location: Burninating the Indiana
Favorite beer: Stone 11th Anniversary Ale
Posts: 12,245
Default

Merge cells to centering text.

Also, I worked with a guy who would have a column of numbers, add them manually on the calculator, then hardcode the answer. I think he didn't trust the calculations or some nonsense.
__________________
ahow
Badass
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 11:24 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.26240 seconds with 9 queries