Actuarial Outpost Most Inappropriate Use of Spreadsheet
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 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

#41
10-23-2017, 11:30 AM
 ahow Member CAS Join Date: Nov 2003 Location: Burninating the Indiana Favorite beer: Stone 11th Anniversary Ale Posts: 12,340

Quote:
 Originally Posted by Incredible Hulctuary 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
#42
10-23-2017, 11:39 AM
 twig93 Member SOA Join Date: Jun 2003 Posts: 31,666

Quote:
 Originally Posted by IMP Keeping a list of alt names.
__________________
Originally Posted by Gandalf
The thing that is clearest is twig's advice
#43
10-23-2017, 11:45 AM
 twig93 Member SOA Join Date: Jun 2003 Posts: 31,666

Quote:
 Originally Posted by ahow 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
#44
10-23-2017, 03:55 PM
 Egghead Member SOA Join Date: Aug 2006 Posts: 6,733

Quote:
 Originally Posted by DownInTexas 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"
#45
10-23-2017, 06:51 PM
 FormLetter Member Join Date: Feb 2006 Posts: 49,197

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
#46
10-23-2017, 07:04 PM
 lifishing007 Member SOA Join Date: Feb 2009 Studying for Advanced Posts: 2,735

Quote:
 Originally Posted by FormLetter 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.

__________________
Module: HF FE PRFM DMAC
#47
10-23-2017, 09:02 PM
 chicken_po_boy 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,079

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.”
#48
10-24-2017, 06:38 AM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 86,591 Blog Entries: 6

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:
__________________
It's STUMP

#49
10-25-2017, 02:21 PM
 Tommy Vercetti Member CAS Join Date: Jan 2003 Posts: 988

In the older days, people here uses Excel to check exam result from CAS website.
#50
10-25-2017, 03:17 PM
 twig93 Member SOA Join Date: Jun 2003 Posts: 31,666

Quote:
 Originally Posted by Tommy Vercetti 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