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 Display Modes
  #61  
Old 11-01-2017, 01:16 AM
Klaymen's Avatar
Klaymen Klaymen is offline
Member
CAS
 
Join Date: Oct 2001
Studying for the Last Reformation
Posts: 18,646
Default

That lottery story reminds when one in 6 Mountain Dew 20oz bottles would win a free one back in 1996. The caps were yellow, and if you simply tilted the bottle and held it up to the light, you could read enough of the cap to tell if it was a winner. We could only do so many in a short time at the nearby convenience store without being obnoxious, it was fun to walk out and see how many of us were “astonished” to be winners.
__________________

Trust in the Lord and do good; dwell in the land and enjoy safe pasture. Take delight in the Lord, and he will give you the desires of your heart. Commit your way to the Lord; trust in him and he will do this: He will make your righteous reward shine like the dawn, your vindication like the noonday sun. (Psalm 37:3-6)
Reply With Quote
  #62  
Old 12-11-2017, 10:55 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,875
Blog Entries: 1
Default




Yep. I am as bad as an XKCD example.

From a spreadsheet I have open right now that I copy and paste into a C# window...

=if(isblank(AN8),"","Text|"&AN8&"|") &AK8 & DU8&if(ISBLANK(AL8),"","|"&AL8)&if(ISBLANK(AM8),"" ,"|"&AM8)

=if(CE8="","","{"&CE8&", new Thing("&CE8&","&CF8&","&CG8&","&CH8&","&CI8&","&CJ 8&","&CK8&","&CL8&","&CM8&","&CN8&","&CO8&","&CP8& ","&CQ8&","&CR8&","&CS8&","&CT8&")},")

Bonus points for having named my class of objects "Thing".
__________________
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; 12-11-2017 at 11:00 AM..
Reply With Quote
  #63  
Old 12-11-2017, 11:06 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,875
Blog Entries: 1
Default

Quote:
Originally Posted by llcooljabe View Post
I use excel to write memos all the time. I use them for rate filings that I do annually, when I have to embed numbers into the wording. I use formulas for some of the text.

e.g. ="The credibility weighted loss ratio for "&A1&" is "&text(a2,"0.0%")&"."

It's cumbersome but only the first time, but it's better than searching a word doc for all the numbers to change and accidentally missing one.
Quote:
Originally Posted by Woodrow View Post
Can someone help me with the "right" way to do this using excel and word? I've just been assigned a report that uses numbers from a spreadsheet and I want something slicker than typing them in.

Is the answer Mail Merge? That seems intended to make many letters, but I guess you could use it to make just one at a time.
I've never used mail merge before... I think what cooljabe is doing is entirely legitimate. If your model is in Excel, then you should feel comfortable using Excel to compose the text. It will be easier to understand and audit then shoving it into another program. Also lends itself to conditionals.

If you want to spice it up a bit, you can use VBA to compose outlook emails from Excel as well, and then attach that to a button or something. Just make sure you have adequate error checking first!
__________________
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; 12-11-2017 at 11:12 AM..
Reply With Quote
  #64  
Old 12-11-2017, 08:31 PM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,788
Default

Quote:
Originally Posted by llcooljabe View Post
I use excel to write memos all the time. I use them for rate filings that I do annually, when I have to embed numbers into the wording. I use formulas for some of the text.

e.g. ="The credibility weighted loss ratio for "&A1&" is "&text(a2,"0.0%")&"."

It's cumbersome but only the first time, but it's better than searching a word doc for all the numbers to change and accidentally missing one.
Google Form Fields.
__________________
If you want to add me on LinkedIn, PM me.

Why I hate Microsoft Access.

Studying/Reading: Machine Learning and Pattern Recognition

Last edited by clarinetist; 12-11-2017 at 08:37 PM..
Reply With Quote
  #65  
Old 12-20-2017, 10:58 AM
kSauce kSauce is offline
SOA
 
Join Date: Jan 2014
Favorite beer: Hefeweizens
Posts: 10
Default

I created a magic eight ball - as a joke for a coworker, I swear. There was a button in the middle of a blacked out "circle" of cells that when pushed would shake the ball by deleting and adding rows above and to the side a few hundred times, and using wait or pause or something like that to slow it down. Then after a few dozen shakes it rolled through a few of the standard 8 ball responses and a few non-standard.

Still have that gem.
Reply With Quote
  #66  
Old 12-20-2017, 11:50 AM
yoyo's Avatar
yoyo yoyo is offline
Member
CAS
 
Join Date: Dec 2001
Posts: 21,047
Default

seems like an entirely appropriate use
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 01:11 AM.


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.68865 seconds with 9 queries