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


Not looking for a job? Tell us about your ideal job,
and we'll only contact you when it opens up.
https://www.dwsimpson.com/register


Reply
 
Thread Tools Display Modes
  #31  
Old 10-19-2017, 08:13 PM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,747
Default

I used to work for an actuarial team that thought very highly of PivotTables.

And I mean very highly.

I took a data set and created one Excel workbook with something like 20-30 PivotTables spread throughout 5-10 worksheets.

Occasionally, I'd be informed that there's an error with how the data were pulled, because the code was written in a programming language that, even if you were to Google it, you wouldn't find much help. Then I'd have to reload the data set and reconfigure every one of the PivotTables.

Also, the PivotTables didn't quite match what they wanted, so inside said worksheets, I had "formatted" versions of the PivotTables as well (which were just duplications of said PivotTables to the right of the PivotTables + some merging of cells). AFAIK there's not a VBA solution for this.

Another data set that I was asked to analyze exceeded the row limit in Excel, and required the same PivotTable business. Therefore, I had to learn PowerPivot. One of the things I figured out very quickly is that once you import data into PowerPivot, your data is stuck. If you have to change it due to errors in the data (which did happen quite a bit), you have to delete your old data set in PowerPivot and reconfigure (maybe even recreate! It's been too long) all of the PivotTables you created.
__________________
If you want to add me on LinkedIn, PM me.

Why I hate Microsoft Access.

Studying/Reading: Statistical Inference, Bayesian Data Analysis
Reply With Quote
  #32  
Old 10-19-2017, 08:19 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,408
Default

Quote:
Originally Posted by campbell View Post
...I tried googling on this, but wasn't happy with the result... got examples of these questions?
Psychologist's [Psychiatrist's?] name Carl Rogers, I believe. The key question for me was (well, duh) "How do you feel about that?"
__________________
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
  #33  
Old 10-19-2017, 10:16 PM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 5,727
Default

Quote:
Originally Posted by campbell View Post
...I tried googling on this, but wasn't happy with the result... got examples of these questions?
Would you be mine?

Could you be mine?

Won't you please?

Won't you please?...



Please won't you be my neighbor?
Reply With Quote
  #34  
Old 10-19-2017, 10:33 PM
anon3's Avatar
anon3 anon3 is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Posts: 1,236
Default

Quote:
Originally Posted by Marcie View Post
I have one of those, too.
Which one of those two do you have?? Usernames or passwords?
__________________
I am everybody. I am nobody
Reply With Quote
  #35  
Old 10-20-2017, 09:03 AM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 5,727
Default

Quote:
Originally Posted by anon3 View Post
Which one of those two do you have?? Usernames or passwords?
Yes.
Reply With Quote
  #36  
Old 10-20-2017, 11:06 AM
DownInTexas's Avatar
DownInTexas DownInTexas is offline
Member
SOA
 
Join Date: Jul 2008
Studying for modules
Favorite beer: Shiner
Posts: 4,518
Default

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.
__________________
Unite & Strengthen

2013-2014 EPL Prediction Contest Champion

2016-2017 EPL Prediction Contest Champion
Reply With Quote
  #37  
Old 10-20-2017, 11:54 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 21,939
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.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #38  
Old 10-20-2017, 02:01 PM
Incredible Hulctuary's Avatar
Incredible Hulctuary Incredible Hulctuary is offline
Member
Non-Actuary
 
Join Date: Jan 2002
Posts: 23,800
Default

Quote:
Originally Posted by ahow View Post
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.
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.
__________________
A lot of people are afraid of heights; not me, I'm afraid of widths. - Steven Wright
Reply With Quote
  #39  
Old 10-21-2017, 02:19 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,698
Blog Entries: 1
Default

I sometimes write highly repetitive code in my spreadsheets. In fact I have one open right now with formulas like

="new List<string>(){"&""""&AI6&""""&"};"
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.

Last edited by Sredni Vashtar; 10-21-2017 at 02:25 PM..
Reply With Quote
  #40  
Old 10-21-2017, 02:28 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,698
Blog Entries: 1
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.

That's really clever in a way.
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.
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 08:03 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.51750 seconds with 9 queries