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 Global Actuarial & Analytcs Recruitment
Download our 2016 Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Display Modes
  #41  
Old 10-23-2017, 12:30 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,242
Default

Quote:
Originally Posted by Incredible Hulctuary View Post
Didn't trust? Or didn't know how?

My semi-retired aunt, who does interior decorating part-time, uses spreadsheets like that because she doesn't know how to use formulas. The spreadsheets are really just for neatly formatting numbers and corresponding text into rows and columns before printing them (without gridlines) and giving them to clients for estimates or billing.
From what I had heard, he didn't trust it. He liked to type it all in his HP12C.
__________________
ahow
Badass
Reply With Quote
  #42  
Old 10-23-2017, 12:39 PM
twig93's Avatar
twig93 twig93 is offline
Member
SOA
 
Join Date: Jun 2003
Posts: 26,206
Default

Quote:
Originally Posted by IMP View Post
Keeping a list of alt names.
__________________
Originally Posted by Gandalf
The thing that is clearest is twig's advice
Reply With Quote
  #43  
Old 10-23-2017, 12:45 PM
twig93's Avatar
twig93 twig93 is offline
Member
SOA
 
Join Date: Jun 2003
Posts: 26,206
Default

Quote:
Originally Posted by ahow View Post
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.
I inherited a financial reporting spreadsheet with about 20 tabs. A ton of duplication of numbers right there in the instructions.

Quote:
Originally Posted by Spreadsheet documentation
Step 37: Enter this number in this list of 23 cells in 13 different tabs of the spreadsheet.


...

Step 41: Make sure that the formulas in this list of 49 cells all produce the same number.
Heavens to Betsy! I get that we have to present largely the same information to 12 different audiences in slightly different ways, but that is why God invented links!!!

I spent about 6 hours one day cleaning it up and decreased the monthly time to complete the workbook from about 3 hours to about 30 minutes. Also pared down the list of things that the checker needed to check drastically, although it was another year or so before the checker changed to a non-Excel-idiot who actually stopped doing the old checklist in favor of the new one.

Of course if I was ever out when one of the inputs needed to change, my backup would fork up the spreadsheet again by hard-coding stuff over formulas, usually resulting in errors somewhere in the results.
__________________
Originally Posted by Gandalf
The thing that is clearest is twig's advice
Reply With Quote
  #44  
Old 10-23-2017, 04:55 PM
Egghead's Avatar
Egghead Egghead is offline
Member
SOA
 
Join Date: Aug 2006
Posts: 5,517
Default

Quote:
Originally Posted by DownInTexas View Post
A sales person sent me membership information about a group in excel. Apparently they already had it in excel, so they simply took a screenshot, and pasted that picture in a new workbook. Then they sent me the workbook containing a picture of their workbook, with it perfectly sized so it lined up with the rows and columns at the edges of the picture. I was confused as to why it wasn't letting me select the data until I figured out what they did.
Reading this, I imagine a website called salesoutpost.com, with a thread called, "How to Screw with Your Actuarials"
Reply With Quote
  #45  
Old 10-23-2017, 07:51 PM
FormLetter's Avatar
FormLetter FormLetter is offline
Member
 
Join Date: Feb 2006
Posts: 48,498
Default

Made a 'flipbook' style of cartoon using multiple tabs so you could scroll through the tabs showing a stick-person's head fall off and roll away.
__________________
Come join the AO Rap Battle Tournament 2013:
http://www.actuarialoutpost.com/actu...33#post7082433
Reply With Quote
  #46  
Old 10-23-2017, 08:04 PM
lifishing007's Avatar
lifishing007 lifishing007 is offline
Member
SOA
 
Join Date: Feb 2009
Studying for Advanced
Posts: 2,572
Default

Quote:
Originally Posted by FormLetter View Post
Made a 'flipbook' style of cartoon using multiple tabs so you could scroll through the tabs showing a stick-person's head fall off and roll away.

https://www.google.com/search?q=draw...2CQdbf9Kel8AM:
__________________
Exam: GHCORE GHADV GHSPE
Module: HF FE PRFM DMAC
Reply With Quote
  #47  
Old 10-23-2017, 10:02 PM
chicken_po_boy's Avatar
chicken_po_boy chicken_po_boy is offline
Member
CAS
 
Join Date: Nov 2008
Location: 401 Poydras New Orleans, LA 70130
Studying for Nothing Ever Again
College: been there, done that
Favorite beer: You gonna finish that?
Posts: 2,006
Default

I used Excel once to send a voicemail message. A coworker asked me a simple question, something like “what is the KS Inland Marine LCM?” I typed out a 5-minute answer designed for maximum suffering, programmed a macro to speak the text, and sent her the Excel spreadsheet with a macro button that said “put on headphones and click here.”
Reply With Quote
  #48  
Old 10-24-2017, 07:38 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: 79,352
Blog Entries: 6
Default

https://www.xkcd.com/1906/



alt text:
Spoiler:

I started off with countless problems. But now I know, thanks to COUNT(), that I have "#REF! ERROR: Circular dependency detected" problems.


One of my first talks on spreadsheets was: I Got 99 Problems, and a Spreadsheet Ain't One

ah, and here it is:
https://drive.google.com/file/d/0Bya...k3QzowLjE/view
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #49  
Old 10-25-2017, 03:21 PM
Tommy Vercetti Tommy Vercetti is offline
Member
CAS
 
Join Date: Jan 2003
Posts: 987
Default

In the older days, people here uses Excel to check exam result from CAS website.
Reply With Quote
  #50  
Old 10-25-2017, 04:17 PM
twig93's Avatar
twig93 twig93 is offline
Member
SOA
 
Join Date: Jun 2003
Posts: 26,206
Default

Quote:
Originally Posted by Tommy Vercetti View Post
In the older days, people here uses Excel to check exam result from CAS website.
I remember those days!
__________________
Originally Posted by Gandalf
The thing that is clearest is twig's advice
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 07:36 PM.


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.32375 seconds with 9 queries