Actuarial Outpost Most Inappropriate Use of Spreadsheet
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

#51
10-25-2017, 04:06 PM
 Maphisto's Sidekick Member CAS Join Date: Nov 2001 Location: South Park Genetics Lab College: Ardnox Favorite beer: The kind with alcohol Posts: 2,465

Quote:
 Originally Posted by chicken_po_boy I used Excel once to send a voicemail message. A coworker asked me a simple question, something like “what is the KS Inland Marine LCM?” I typed out a 5-minute answer designed for maximum suffering, programmed a macro to speak the text, and sent her the Excel spreadsheet with a macro button that said “put on headphones and click here.”
#52
10-25-2017, 04:12 PM
 yoyo Member CAS Join Date: Dec 2001 Posts: 22,111

Quote:
 Originally Posted by chicken_po_boy I used Excel once to send a voicemail message. A coworker asked me a simple question, something like “what is the KS Inland Marine LCM?” I typed out a 5-minute answer designed for maximum suffering, programmed a macro to speak the text, and sent her the Excel spreadsheet with a macro button that said “put on headphones and click here.”
:slowclap:
#53
10-26-2017, 09:44 PM
 Gonzo Member SOA Join Date: Jun 2009 Location: gonzo. Studying for gonzo? Favorite beer: gonzo! Posts: 8,668

used my spreadsheet to spit out random sets of powerball numbers. not a single winner
#54
10-27-2017, 09:39 AM
 twig93 Member SOA Join Date: Jun 2003 Posts: 29,216

Quote:
 Originally Posted by Gonzo used my spreadsheet to spit out random sets of powerball numbers. not a single winner
You need to find a better algorithm. Maybe do some curve-fitting with past winning numbers?
__________________
Originally Posted by Gandalf
The thing that is clearest is twig's advice
#55
10-27-2017, 09:54 AM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for duolingo and coursera Favorite beer: Murphy's Irish Stout Posts: 83,767 Blog Entries: 6

well -some- people must have great lottery-number-picking skills....

http://www.pennlive.com/watchdog/201...ds_part_1.html

Quote:
 The nation's 'luckiest' lottery players may not be as lucky as they seem On, Dec. 29, 2016, Clarance Jones did something that most Americans could scarcely imagine: He cashed-in 20 winning scratch-off tickets, collectively worth \$21,000, one after the other. For the average lottery player, that would be the ultimate payday. For Jones, it was practically routine. In the past six years, the 79-year-old from Lynn, Mass., has won more than 7,300 lottery tickets, totaling \$10.8 million. That establishes him, by far, as the luckiest lottery player in America. But that luck, experts say, is unlikely to be what it seems. And Jones is not alone in raising eyebrows. Spoiler: A national investigation by PennLive - in collaboration with the Columbia Graduate School of Journalism School, the Boston Globe, the New York Daily News, the Hartford Courant, and the Cleveland Plain Dealer - has found that hundreds of Americans are winning lottery tickets with a frequency so extraordinary that, in some cases, it could be rooted in illegal activity. Furthermore, PennLive found, oversight of those win patterns appears weak or non-existent in many states despite more than a decade of concern about frequent winning. Ultimately, based on an analysis of 11 million lottery claims, hundreds of pages of internal lottery documents and interviews with dozens of statisticians, lottery experts, and lottery players, PennLive found: In the past seven years, close to 1,700 players across nearly two dozen states have each claimed 50 or more lottery tickets worth \$600 or more - a feat that in many cases is statistically improbable. According to an analysis by a statistician at the University of California, Jones, the nation's most frequent winner, would have to spend at least \$300 million on lottery tickets to have a 1-in-10 million chance of winning his 7,300 tickets. The odds are extraordinary even for winners with far smaller win tallies. According to the analysis, Pennsylvania's most frequent winner, Nadine Vukovich, who has won 209 tickets, would have to spend at least \$7.8 million to have a 1-in-10 million chance of winning so often. Of the nation's 45 state lotteries, ten states (Kansas, Ohio, Virginia, Pennsylvania, Oregon, Connecticut, California, Idaho, Minnesota, Washington) say they don't systematically monitor frequent winning. States that say they do monitor frequent winning appear to be doing a weak job: Either frequent winning appears to be prevalent in those states or, based on internal documents reviewed by PennLive, investigators fail to pursue penalties or ask tough questions about suspicious winning patterns. In past cases where frequent lottery winning has been probed, investigators have sometimes found it rooted in crime: from theft of winning tickets and cheating to schemes used to facilitate tax evasion and money laundering. Most lottery officials approached by PennLive have a simple explanation for why some players win so often: They play a lot. "High frequency wins are not considered unusual in the industry nor indicative of criminal activity," said Rose Hudson, president of the National Association of State and Provincial Lotteries. The nation's most frequent winners also maintain that there's no mystery to their wins. Many, like Jones, declined to speak to reporters. But others, like Rickey Meng, Ohio's most frequent winner, said his success was simply due to heavy play. "I made a lot of money but I spent a lot too,'' Meng said, who has won more than 340 tickets over nine years, collectively worth nearly a million dollars. In some cases, statisticians and experts say, that may be true: Some heavy gamblers do spend hundreds of dollars each day buying lottery tickets. But, they add, frequent play is unlikely to explain how many of the players identified by PennLive could win so frequently. The real explanation, they believe, is entrenched in issues that continue to be ignored by the \$80 billion industry.

....or perhaps something else.

that was the first article in a multipart series.

The other parts:
http://www.pennlive.com/watchdog/201...ds_part_2.html

http://www.pennlive.com/watchdog/201...ds_part_3.html
__________________
It's STUMP

#56
10-27-2017, 10:00 AM
 llcooljabe Member CAS Join Date: Aug 2002 Posts: 22,764

reminds me of this story: https://www.thestar.com/news/gta/201...y_tickets.html

Quote:
__________________
www.GoodNewsNow.info
Propoganda
#57
10-30-2017, 04:09 PM
 DeepPurple Member Join Date: Jun 2004 Posts: 4,125

Quote:
 Originally Posted by Gonzo used my spreadsheet to spit out random sets of powerball numbers. not a single winner
You probably used the RAND() function.
__________________
Come on. Let's go space truckin'. Come on!
#58
10-30-2017, 05:25 PM
 Woodrow Member SOA Join Date: Oct 2002 Posts: 6,712

Quote:
 Originally Posted by llcooljabe 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.
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.
#59
10-30-2017, 05:30 PM
 llcooljabe Member CAS Join Date: Aug 2002 Posts: 22,764

Quote:
 Originally Posted by Woodrow 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 had asked this question in a thread years ago, and the suggestion was mail merge. I found that it was way too much effort for one letter at a time. It may be the "correct" way to do it, but I found, practically speaking, the excel method is easier.

Only caveat: numbers (dollars with commas, percents and dates) have to be formatted before using them in a formula. I do this by a by a text() formula.
__________________
www.GoodNewsNow.info
Propoganda
#60
10-30-2017, 05:37 PM
 Gonzo Member SOA Join Date: Jun 2009 Location: gonzo. Studying for gonzo? Favorite beer: gonzo! Posts: 8,668

Quote:
 Originally Posted by DeepPurple You probably used the RAND() function.
i used RAND(RAND())

it was genius