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

Actuarial Jobs by State

New York  New Jersey  Connecticut  Massachusetts 
California  Florida  Texas  Illinois  Colorado


Reply
 
Thread Tools Search this Thread Display Modes
  #31  
Old 10-19-2017, 07:13 PM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,870
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: Linear Optimization/Programming, Machine Learning and Pattern Recognition
Reply With Quote
  #32  
Old 10-19-2017, 07: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: 37,428
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 Apr 5, 2018.

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:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #33  
Old 10-19-2017, 09:16 PM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 8,248
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, 09:33 PM
anon3's Avatar
anon3 anon3 is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Posts: 1,305
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, 08:03 AM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 8,248
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, 10:06 AM
DownInTexas's Avatar
DownInTexas DownInTexas is offline
Member
SOA
 
Join Date: Jul 2008
Studying for modules
Favorite beer: Shiner
Posts: 4,631
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, 10:54 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 22,764
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, 01:01 PM
Incredible Hulctuary's Avatar
Incredible Hulctuary Incredible Hulctuary is offline
Member
Non-Actuary
 
Join Date: Jan 2002
Posts: 25,007
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.
__________________
The forest was shrinking, but the trees kept voting for the axe because its handle was made from wood, and they thought it was one of them.
Reply With Quote
  #39  
Old 10-21-2017, 01:19 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,404
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 01:25 PM..
Reply With Quote
  #40  
Old 10-21-2017, 01:28 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,404
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 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 11:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, 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.23935 seconds with 9 queries