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 Search this Thread Display Modes
  #61  
Old 11-01-2017, 12:16 AM
Klaymen's Avatar
Klaymen Klaymen is offline
Member
CAS
 
Join Date: Oct 2001
Studying for the Last Reformation
Posts: 18,808
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, 09:55 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 5,518
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 10:00 AM..
Reply With Quote
  #63  
Old 12-11-2017, 10:06 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 5,518
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 10:12 AM..
Reply With Quote
  #64  
Old 12-11-2017, 07:31 PM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,835
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 07:37 PM..
Reply With Quote
  #65  
Old 12-20-2017, 09:58 AM
kSauce kSauce is offline
SOA
 
Join Date: Jan 2014
Favorite beer: Hefeweizens
Posts: 14
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, 10:50 AM
yoyo's Avatar
yoyo yoyo is offline
Member
CAS
 
Join Date: Dec 2001
Posts: 21,450
Default

seems like an entirely appropriate use
Reply With Quote
  #67  
Old 01-25-2018, 09:51 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: 81,656
Blog Entries: 6
Default

a candidate

https://nurturenature.org/pages/bala...ation-analyzer

Quote:
Balanced Transportation Analyzer
The Balanced Transportation Analyzer, or BTA, is an intricate spreadsheet model that ties together every facet of passenger transport in New York City including transit, auto and taxi. The model makes it possible to measure the effects of changes in auto tolls, transit fares and other policy levels on traffic levels, travel speeds, time spent traveling, agency revenues, emissions and other "externalities." It contains “pre-packaged” traffic-pricing scenarios which you may modify to test your own what-if scenarios. The BTA thereby offers a transparent and straightforward tool for transport policy-makers and advocates to test the impacts of tolls and other policy traffic pricing proposals.
as per someone on the eusprig mail list:
Quote:
I just came across the following monster spreadsheet application for modelling all forms of transport in Manhattan… the best part is you can download the spreadsheet and play with it! I wonder if there are any mistakes in the 72 sheets that make it up?

__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #68  
Old 01-25-2018, 09:52 AM
yoyo's Avatar
yoyo yoyo is offline
Member
CAS
 
Join Date: Dec 2001
Posts: 21,450
Default

only 72 sheets?
Reply With Quote
  #69  
Old 01-25-2018, 10:55 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 5,518
Blog Entries: 1
Default

Quote:
Originally Posted by campbell View Post
a candidate

https://nurturenature.org/pages/bala...ation-analyzer



as per someone on the eusprig mail list:
Wow, that's amazing!

And I totally disagree with you. This is a great use of spreadsheets.

Yes, it's likely to have lots of errors. Yes, it could be better designed (IMO). But you gotta ask yourself: what's the alternative?

A bunch of inaccessible C++ scripting, with just as many hardcoded values, split into 10 files which are understood by 10 different programmers, which aren't shared with the public, and which can only be run by analysts.

Having everything in one file that anyone in the world can follow is the ultimate goal.
__________________
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; 01-25-2018 at 11:03 AM..
Reply With Quote
  #70  
Old 01-31-2018, 03:13 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: 81,656
Blog Entries: 6
Default

https://twitter.com/ExcelAnalytics/s...73242587369472

Quote:
Systems Modelling‏
@ExcelAnalytics
Follow Follow @ExcelAnalytics
More
Replying to @EuSpRIG @ImperialDSI
Or, the UK 2050 Carbon Calculator (Hi @meepbobeep !)
115,457 INDIRECT() formulas.
https://www.2050.org.uk/calculators
__________________
It's STUMP

LinkedIn Profile
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 08:17 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.45861 seconds with 9 queries