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

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


View Poll Results: What is the best way to learn VBA?
Book 107 36.77%
Help 48 16.49%
Internet 143 49.14%
Macro Recorder 111 38.14%
Multiple Choice Poll. Voters: 291. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #41  
Old 08-11-2006, 04:58 PM
whisper's Avatar
whisper whisper is offline
Member
CAS AAA
 
Join Date: Jan 2002
Location: Chicago
Favorite beer: Hefewizen
Posts: 32,840
Default

Quote:
Originally Posted by Brad Gile View Post
But my point, which you ignore, is that a lot of people generate the code with the recorder and routinely use it as is! Often, when this is done, the code will not always work they way the user thinks it will. IOW, the code does NOT "work"! That's not using the recorder as a learning tool.
I'm sorry, I thought I addressed this, but I guess I wasn't clear enough.

You are 100% correct in that the recorder is a problem when people use it in lieu of programming. The recorder is an awful programmer. Nonetheless, when people do this - they aren't interested in learning to program. They're just interested in having a program, and went to the cheapest source to get it.
Reply With Quote
  #42  
Old 08-11-2006, 07:37 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by whisper View Post
I'm sorry, I thought I addressed this, but I guess I wasn't clear enough.

You are 100% correct in that the recorder is a problem when people use it in lieu of programming. The recorder is an awful programmer. Nonetheless, when people do this - they aren't interested in learning to program. They're just interested in having a program, and went to the cheapest source to get it.
OK.

Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #43  
Old 08-12-2006, 07:17 PM
Roto's Avatar
Roto Roto is offline
Member
SOA
 
Join Date: May 2002
Studying for CSP - ILA
Favorite beer: Summit IPA
Posts: 7,084
Default

What type of jobs do you guys have in the industry where you are actually using this stuff?

Long ago, I created and used Excel macros for non-actuarial gig... but since I've been in the industry, I just haven't had the opportunity. The skill is gone. I enjoyed automating Excel with VBA though...
__________________
http://www.hillaryclinton.com/
Reply With Quote
  #44  
Old 08-12-2006, 07:23 PM
Kazodev's Avatar
Kazodev Kazodev is offline
Member
SOA
 
Join Date: May 2004
Posts: 3,393
Default

Quote:
Originally Posted by Roto View Post
What type of jobs do you guys have in the industry where you are actually using this stuff?

Long ago, I created and used Excel macros for non-actuarial gig... but since I've been in the industry, I just haven't had the opportunity. The skill is gone. I enjoyed automating Excel with VBA though...
I just do simple stuff, like summary type things. Taking stuff from a bunch of worksheets, calculating simple things and summarizing in one worksheet. Nothing special.
Reply With Quote
  #45  
Old 08-12-2006, 07:42 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by Roto View Post
What type of jobs do you guys have in the industry where you are actually using this stuff?

Long ago, I created and used Excel macros for non-actuarial gig... but since I've been in the industry, I just haven't had the opportunity. The skill is gone. I enjoyed automating Excel with VBA though...
I used to do a lot of Monte Carlo simulation and modeling work. Now I'm retired but still use Excel VBA for number theory stuff and other math play.
For heavy duty stuff I use Mathcad.


Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #46  
Old 08-13-2006, 12:40 AM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,905
Default

The only stuff I've used VBA for have been non-project related at work: however, they've so far turned out very useful (turning a common 2 hour task into a 15 minute one). They won't be inherited, so they can be as sloppy and undocumented as I want as long as they do what I want
Reply With Quote
  #47  
Old 08-13-2006, 12:52 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by SirVLCIV View Post
The only stuff I've used VBA for have been non-project related at work: however, they've so far turned out very useful (turning a common 2 hour task into a 15 minute one). They won't be inherited, so they can be as sloppy and undocumented as I want as long as they do what I want
You have a macro that runs for 15 minutes? No, I do not want to see the code.

Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #48  
Old 08-13-2006, 01:50 PM
SirVLCIV's Avatar
SirVLCIV SirVLCIV is offline
Member
SOA
 
Join Date: Feb 2006
Posts: 46,905
Default

Quote:
Originally Posted by Brad Gile View Post
You have a macro that runs for 15 minutes? No, I do not want to see the code.

Brad
Rofl: no. Macro takes 15 seconds. Using the output takes 15 minutes

Before, it was data entry. Look in report, put number in form, look in report, put number in form. Now I can import the numbers directly into the form after the macro has run, which takes about a minute. The rest of the time is putting together the attachments .
Reply With Quote
  #49  
Old 08-13-2006, 04:09 PM
MNBridge's Avatar
MNBridge MNBridge is offline
Site Supporter
Site Supporter
 
Join Date: Jan 2002
Posts: 8,366
Default

Quote:
Originally Posted by Roto View Post
What type of jobs do you guys have in the industry where you are actually using this stuff?

Long ago, I created and used Excel macros for non-actuarial gig... but since I've been in the industry, I just haven't had the opportunity. The skill is gone. I enjoyed automating Excel with VBA though...
Simulation, automated pricing.

Creating non-excel functions. Mostly things like Poisson Inv and the functions found in Klugman.
Reply With Quote
  #50  
Old 08-13-2006, 08:18 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by MNBridge View Post
Simulation, automated pricing.

Creating non-excel functions. Mostly things like Poisson Inv and the functions found in Klugman.
I had similar uses. Did you use copulas?

Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
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 10:38 AM.


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.46401 seconds with 10 queries