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


Reply
 
Thread Tools Display Modes
  #21  
Old 05-09-2017, 10:10 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,688
Blog Entries: 1
Default

Quote:
Originally Posted by ronaldy27 View Post
Yeah I agree. I have the Excel Bible book but I just can't sit there and read it. When it comes to learning programming,
This is a terrible comparison. A VBA book >>>>> Excel book.

It will include tutorials and it will teach you some fundamental concepts that you will have a hard time mastering on your own, along with some best practices that are really important to pickup.

Quote:
With that said, I am having a hard time finding a small, do-able project that I can do on my own...
Sure...

How about you find all the primes between 1 and a billion, and have them printed onto a spreadsheet? Then see if you can optimize the process so that it only takes a couple seconds to run...

Or How about a Mad Lib generator, where you write a Mad Lib and then it inserts random words? Or how about a game of poker?

OR OKAY, HOW about you create a VBA file that makes a flip book. Where it generates like 80 tabs, of an askii stick figure jumping up and down over and over again!
__________________
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; 05-09-2017 at 10:21 AM..
Reply With Quote
  #22  
Old 05-09-2017, 10:15 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,688
Blog Entries: 1
Default

Quote:
Originally Posted by Maphisto's Sidekick View Post
A. Start with a list of 5-10 trios of latitudes/longitudes/time zones of places in the continental U.S. Use VBA to create a table showing sunrise/sunset times of those locations for the next 3 years. (Don't forget about DST; for fun include a location in those parts of Arizona that don't observe DST.)
OR generate a chart, that has a background color that is the actual color of the sky at different times.

And then create a "sun" using an area chart.

And then animate the chart using VBA to make the sun rises on the left side and sets on the right side while the sky changes color.
__________________
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
  #23  
Old 05-09-2017, 11:06 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,353
Blog Entries: 6
Default

Quote:
Originally Posted by Maphisto's Sidekick View Post
I don't know too many VBA-literate actuaries who read a book.

I got started by recording macros and reading the help files. Google searches fill in the gaps.
Do you know me?

To be fair, YouTube didn't exist when I got started.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #24  
Old 05-09-2017, 11:07 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,353
Blog Entries: 6
Default

Bama Gambler makes some good points at the beginning of the sticky on learning VBA:

http://www.actuarialoutpost.com/actu...ad.php?t=88423
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #25  
Old 05-09-2017, 11:30 AM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 1,510
Default

Quote:
Originally Posted by Sredni Vashtar View Post
OR OKAY, HOW about you create a VBA file that makes a flip book. Where it generates like 80 tabs, of an askii stick figure jumping up and down over and over again!
Quote:
Originally Posted by Sredni Vashtar View Post
OR generate a chart, that has a background color that is the actual color of the sky at different times.

And then create a "sun" using an area chart.

And then animate the chart using VBA to make the sun rises on the left side and sets on the right side while the sky changes color.
I don't understand this trend...I took a MATLAB course in college in which the projects were largely centered around animation and graphics...things which I still don't really care to know about personally. I learned very little about linear algebra or legitimate mathematical applications in that course, and is probably why I still hate MATLAB.
__________________
1/P | 2/FM | 3F/MFE | LC | ST |4/C | 5 | 6 || 7 | 8 | 9
VEE: Econ, Fin, Stat
OC1, OC2
COP
Reply With Quote
  #26  
Old 05-09-2017, 02:38 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,688
Blog Entries: 1
Default

Quote:
Originally Posted by ALivelySedative View Post
I don't understand this trend...I took a MATLAB course in college in which the projects were largely centered around animation and graphics things which I still don't really care to know about personally. I learned very little about linear algebra or legitimate mathematical applications in that course, and is probably why I still hate MATLAB.
That's hilarious. MATLAB animations! I must have the same sense of humor as your professor.

Although an animation of the sun is pretty stupid, I would argue that Chart-Object manipulation is one of the most common things to do in VBA.

Most of the time you don't really want to do your Math in VBA because you can do it in Excel. And then there's manipulating MS programs outside of Excel, but that is not a good beginner project because it can be tricky to understand the Objects.
__________________
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; 05-09-2017 at 02:49 PM..
Reply With Quote
  #27  
Old 05-09-2017, 02:41 PM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 1,510
Default

Quote:
Originally Posted by Sredni Vashtar View Post
I suggested because
1) it's fun
2) It involves working some common Excel Objects, which IMO is the step between "make a simple copy-paste loop that calculates over and over again" and "automate that monthly powerpoint report".
Eh, fair point. But MATLAB is still stoopid.
__________________
1/P | 2/FM | 3F/MFE | LC | ST |4/C | 5 | 6 || 7 | 8 | 9
VEE: Econ, Fin, Stat
OC1, OC2
COP
Reply With Quote
  #28  
Old 05-09-2017, 02:50 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,688
Blog Entries: 1
Default

Quote:
Originally Posted by ALivelySedative View Post
Eh, fair point. But MATLAB is still stoopid.
FACT.
__________________
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
  #29  
Old 05-09-2017, 03:35 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS AAA
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,034
Default

Quote:
Originally Posted by campbell View Post
Do you know me?

To be fair, YouTube didn't exist when I got started.
Heck, Google just barely existed when they pried Lotus from my hands and started forcing me to use Excel.

I avoid YouTube. It's a black hole into which time gets sucked.
Reply With Quote
  #30  
Old 05-09-2017, 03:37 PM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 1,510
Default

My boss still keeps his excel files in a folder titled 'LOTUS'.
__________________
1/P | 2/FM | 3F/MFE | LC | ST |4/C | 5 | 6 || 7 | 8 | 9
VEE: Econ, Fin, Stat
OC1, OC2
COP
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:15 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.34577 seconds with 9 queries