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
  #61  
Old 07-21-2008, 02:56 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,406
Blog Entries: 6
Default

Yeah, if there are sex discussions in the Tech forum here... uh....
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #62  
Old 07-31-2008, 09:43 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,406
Blog Entries: 6
Default

Found this proto-wiki through EUSPIRG:
http://www.fast-modeling.net/fast/Special:Allpages

Not much there, and I don't know who's editing. Seems like a good idea.

Oh yeah, we have a wiki for the AO as well. I probably should do some more stuff in there.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #63  
Old 07-31-2008, 09:47 AM
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

Thx. Looks like something I want to explore.
__________________
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
  #64  
Old 07-31-2008, 09:55 AM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 8,813
Default

Quote:
Originally Posted by campbell View Post
Found this proto-wiki through EUSPIRG:
http://www.fast-modeling.net/fast/Special:Allpages

Not much there, and I don't know who's editing. Seems like a good idea.

Oh yeah, we have a wiki for the AO as well. I probably should do some more stuff in there.
I noticed the AO had a wiki a few months ago, and I had been meaning to check it out. I think the problem is that I don't see that main frontpage of the AO very often because I usually go straight to the forums. Out of sight, out of mind.

Anyway, I just took a quick look at the AO wiki today and didn't see an Excel section. Unless it's already there and I missed it somehow, I think this would be a great addition. The software/tech forum has traditionally (at least in the recent past) been the best place to look for Excel help in an actuarial context. A wiki for this would be ideal. I can't think of a better resource for entry-level actuaries who may be a little green in Excel as well as expert-users just looking for ideas.

Obviously, there are infinitely many web sites that provide info on Excel, VBA, Access, etc., but it does seem like actuaries often come here because they would rather discuss with people in their own industry.
__________________


Learn how FSA exams are different from the prelims

Registration is open for all of our spring 2018 FSA exam online seminars:

ILA-LP | ILA-LFV-U | ILA-LFV-C | ILA-LRM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Specialty

Check out our Technical Skills Course: Excel, VBA, Access, brand new R material, and more!

Follow us on Twitter, Facebook, and LinkedIn
Reply With Quote
  #65  
Old 07-31-2008, 10:01 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,406
Blog Entries: 6
Default

Just PM Tom to get a logon for the AO wiki if you want to help add.

I edited the 4/C page (of course) but haven't done much since then.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #66  
Old 10-15-2008, 11:09 AM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 8,813
Default Excel error leaves Barclays with more Lehman assets than it bargained for

Quote:
Originally Posted by computerworld.com
According to the motion, Barclays sent the spreadsheet containing the list of contracts to Cleary Gottlieb at 7:48 p.m. EDT on Sept. 18. The spreadsheet which contained almost 1,000 rows of data with a total of more than 24,000 individual cells needed to be reformatted and converted into a PDF file so it could be posted on the bankruptcy court's Web site before midnight. At 11:37 p.m., Cleary Gottlieb sent the converted file to the court, the motion said.

However, contracts that had been marked as "hidden" in the spreadsheet when it was received by the law firm were added to the purchase offer during the reformatting process, according to the motion. Those contracts weren't supposed to be part of the deal; they also were marked with an "N" for "No" in the original version of the spreadsheet, Cleary Gottlieb said in the motion.
Full Article
__________________


Learn how FSA exams are different from the prelims

Registration is open for all of our spring 2018 FSA exam online seminars:

ILA-LP | ILA-LFV-U | ILA-LFV-C | ILA-LRM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Specialty

Check out our Technical Skills Course: Excel, VBA, Access, brand new R material, and more!

Follow us on Twitter, Facebook, and LinkedIn
Reply With Quote
  #67  
Old 10-15-2008, 11:25 AM
ACCtuary's Avatar
ACCtuary ACCtuary is offline
Member
SOA
 
Join Date: Oct 2001
Location: Montgomery County, PA (Phila area)
Studying for none
College: MIT
Favorite beer: Sam Adams
Posts: 6,498
Default

And all this time, I thought it was just because I was lazy or inattentive to detail.
__________________
Sticks and Stones may break my bones, but Markov Chains excite me.
Reply With Quote
  #68  
Old 10-16-2008, 05:44 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,406
Blog Entries: 6
Default

Re: E's story: yeah, the EUSPRIG guys sent that story around our email list. Add it to the pile.

In other news, I have an article out in this month's CompAct (not yet on the SOA site, but should have hard copies at the annual meeting) on user interfaces for spreadsheets, starting with the most challenging users of them all: the general public.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #69  
Old 10-21-2008, 06:44 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,406
Blog Entries: 6
Default

As part of a trial regarding overcharging by a Halliburton employee:

http://www.arabisto.com/p_blogEntry....ogEntryID=1297
Quote:
At the heart of the case is Jeff Mazon, a southwest suburban Chicago man who is accused of inflating the cost of a war related contract while working for Halliburton/KBR in Kuwait in exchange for a bribe he allegedly received six months after he quit the company’s employ.

Prosecutors cited finger-pointing from his Halliburton supervisors and said Mazon manipulated an embedded dollar-to-Kuwait Dinar formula in an Excel Spreadsheet. The defense argued the spreadsheet error was a simple mistake. One Kuwait Dinar is equal to 3.3 U.S. Dollars but the mistake increased the dollar amount from $685,000 to $5.52 million.
For what it's worth, there is some evidence this wasn't a simple spreadsheet error, but a deliberate fraud, but this is still going through trial right now, so there's no current resolution to that. The prosecution alleges that Mr. Mazon received a $1 million kickback for inflating the contract costs.

news stories related to the trial(s):
http://www.qconline.com/archives/qco....php?id=383702
http://www.usdoj.gov/opa/pr/2005/March/05_crm_126.htm
http://www.chicagotribune.com/news/n...925,full.story
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #70  
Old 10-22-2008, 04:04 AM
Shaft's Avatar
Shaft Shaft is offline
Member
CAS SOA AAA
 
Join Date: Dec 2001
Posts: 1,605
Default

Why do I feel I am sliding effortlessly into an Excel audit black hole.......?
Reply With Quote
Reply

Tags
machine learning, predictive analytics, speadsheet error, spreadsheets

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:16 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.34022 seconds with 10 queries