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

DW Simpson Global Actuarial & Analytics Recruitment
Download our 2017 Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Search this Thread Display Modes
  #81  
Old 03-09-2018, 12:54 PM
tommie frazier tommie frazier is offline
Member
 
Join Date: Aug 2003
Favorite beer: The kind with 2 e's
Posts: 22,949
Default

Quote:
Originally Posted by JMO View Post
Yeah. I figured out that the crime family was using it to keep track of who did what to whom and who got paid. I sort of spaced out after that and am unsure whether the feds got the goods on the bad guys as a result or not.
Quote:
Originally Posted by campbell View Post
here is the bottomline: if youre gonna organize your crime, perhaps you should use secure methods to organize it

Excel aint secure
that's pretty funny.

thanks.

there are limits to "organized" crime...unless you do it right and really organize.
__________________
Removed a dated athletic reference under pressure from a friend. You can still give money to help fund research on neurofibromatosis (nf).

General info at www.ctf.org

Team donation page here.
Reply With Quote
  #82  
Old 03-09-2018, 06:46 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: 85,026
Blog Entries: 6
Default

don't implement a single transferable vote election in spreadsheets.

Or, perhaps, just don't do STV if it's all that complicated.

http://cherwell.org/2018/03/08/union...oting-blunder/
Quote:
Union elections marred by voting blunder
Rai Saad Khan was not elected to the Secretary's Committee, despite winning more votes than his closest rival
Spoiler:
A candidate in last week’s Oxford Union elections has been denied a spot on the Secretary’s Committee despite winning more votes than his nearest rival.

According to initial results Rai Saad Khan, who was running on the ‘Ignite’ slate, was narrowly beaten to the final position on the committee by ‘Reform’ candidate Mo Iman.

However, last night the Union’s returning officer stumbled upon a spreadsheet error which had undervalued Khan’s votes, meaning he should have been elected.

As no complaint was registered in the 48 hours following the close of the poll, the society said it would not amend the results to the correct outcome – a decision which prompted Khan to question “the democratic nature of the Union”.

Last week saw the first contested Union presidential election in five terms, with the race for Standing Committee also being remarkably competitive.

Only the first eleven of over twenty candidates would make it onto the Secretary’s Committee, and the results announced on Saturday morning showed that Mo Iman had pipped Khan to the final spot.

However, last night a mistake with the vote count was discovered. In a document outlining what happened, the returning officer said he had “discovered an error in the Excel spreadsheet formula for vote change for Rai Saad Khan.

“I subsequently went through the spreadsheet to investigate whether there were any further errors, and also produced a corrected version,” he said. “I asked an ex-Returning Officer trained in using STV [Single Transferrable Voting] to independently confirm this.”

He discovered that Khan should have had a vote value of 86.298 by the final round. Iman, meanwhile, only had a vote value of 81.490. As such, Iman should have been eliminated in the final round, with Khan taking his place on Secretary’s Committee.

Despite this error being clear and the returning officer labelling it “an injustice”, he concluded he could not change the result. Union Rule 33(b)(vii)(1) states that the Returning Officer may order a recount if an error is brought to his attention within 48 hours of the close of the poll, meaning the deadline had long passed when the mistake was discovered.

Related Cecil Day-Lewis: Auden’s overlooked classmate
Rai Saad Khan told Cherwell: “I deeply regret the turn of events, and sincerely hope Mo Iman resigns on his own accord, as it is unfair for all those who are elected on committee and those who didn’t get elected.”

Khan also expressed his frustration at the Union’s rules. He told Cherwell: “Rules such as 33b vii(1) that still exist within the Union highly call into the question the democratic nature of the Union, and it is deeply troubling that all malpractices or violation of elections laws are protected beyond a 48 hour period, such that even when evidence of a miscount or illegal electorial acts do arise, the elected members are protected at the cost of ordinary members and voters.

“This rule is made to benefit the elected members, and is another sign of prestige and inequality within the Union that needs to be changed.”

Both Iman and the returning officer of the Oxford Union did not wish to comment.

The electoral blunder follows reports of infighting at the upper echelons of the society.

In a recent meeting of the Union’s Standing Committee, outgoing Secretary and defeated presidential candidate Molly Greenwood accused President Laali Vadlamani of acting “very unprofessionally on many levels”.

Tensions had first been raised early on Monday morning, when the agenda for the meeting detailed Greenwood’s intention to make a statement regarding “the unacceptable conduct of the President, Laali Vadlamani”.

However, when she stated her intention to read this out, there was an objection from the sitting Librarian, Sabriyah Saeed. She referred to Standing Order B6, stating that the agenda had not been sent out in due time by the Secretary and thus that Greenwood’s statement should not be heard.

Greenwood argued that the President had already made statements which were not highlighted on the agenda, such as accusing Greenwood of the “serious offence” of failing to provide minutes of previous meetings on time.

Related Partington left to pick up the pieces as election chaos goes global
The objection was seconded by Treasurer – and winner of last week’s presidential election against Greenwood – Stephen Horvath. This meant the statement could not be made, as per Union rules.

After this heated exchange, it seemed that Greenwood had been silenced. However, when Horvath proposed a vote of thanks to President Vadlamani, referencing her efforts to improve the diversity of speakers at the Union, Greenwood made an objection on the grounds that she had “acted very unprofessionally on many levels”.

The vote of thanks went on to pass immediately with no further opposition, and the fractious meeting was brought to an end.

Saeed, who first objected to the reading out of Greenwood’s statement, told Cherwell: “I believed that it was improper for this business to be brought to Standing Committee and under standing order B6 I exercised my right to object to it being brought forward.

“The reason B6 is not always invoked where it might be is due to the fact that the Standing Committee often needs to deal with business arising less than 48 hours prior to the meeting, and in such cases the invocation of B6 would prevent it from acting on its duty towards the general membership.”

Vadlamani and Greenwood declined to comment.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #83  
Old 03-24-2018, 03:25 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,870
Blog Entries: 1
Default

This is actually a nominee for best use of spreadsheets.... but we don't have a thread for that.

https://www.youtube.com/watch?v=QvW61K2s0tA

Spoiler:


(If it helps though the spreadsheet design looks questionable at best.)
__________________
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; 03-24-2018 at 07:29 PM..
Reply With Quote
  #84  
Old 03-24-2018, 06:32 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: 85,026
Blog Entries: 6
Default

ok. yeah. I'll give them that.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #85  
Old 03-27-2018, 02:58 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,708
Blog Entries: 2
Default

Quote:
Originally Posted by campbell View Post
ok go. I'll give them that.
IFYP!
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
  #86  
Old 09-23-2018, 11:14 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: 85,026
Blog Entries: 6
Default

https://www.gamasutra.com/blogs/CBel...mxls_file_.php

Quote:
3D engine entirely made of MS Excel formulae : Enjoy this Doom.xls file !
by C Bel on 02/13/18 04:27:00 pm Featured Blogs

6 comments Share on Twitter RSS
The following blog post, unless otherwise noted, was written by a member of Gamasutra’s community.
The thoughts and opinions expressed are those of the writer and not Gamasutra or its parent company.

Abstract
This article is on how I could write a 3D engine using only excel formula, including following functionalities :
- infinite procedural generated maze map
- real time ray tracer rendering
- occlusion calculation
- basic illumination rendering
- illumination and compute shader
- natural displacement engine
- No macro at all used by the 3D engine,
* to enjoy the game using key press, some macro trigger the displacements, using just one simple copy instruction.

In-game screen capture

You can freely download the file and test it by yourself !

__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #87  
Old 09-23-2018, 03:25 PM
whoanonstop's Avatar
whoanonstop whoanonstop is offline
Member
Non-Actuary
 
Join Date: Aug 2013
Location: Los Angeles, CA
Studying for Spark / Scala
College: College of William and Mary
Favorite beer: Orange Juice
Posts: 5,899
Blog Entries: 1
Default

Quote:
Originally Posted by campbell View Post
I feel like there is a difference between...

1. Doing something that shouldn't be done in Excel because the ability or confidence to do it elsewhere is lacking.
2. Doing something that shouldn't be done in Excel because it is a challenge.

This is clearly in the second category.

-Riley
__________________
Reply With Quote
  #88  
Old 09-23-2018, 03:37 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: 85,026
Blog Entries: 6
Default

Yes, I agree -- it goes with the people who do pixel-painting in Excel. Nothing serious depends on either application


but it is akin to picking up scattered seeds with tweezers.



To be sure, I decided to do the sierpinski triangle in a spreadsheet... but it was only one formula.

YAY for cellular automata
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #89  
Old 11-25-2018, 08:21 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: 85,026
Blog Entries: 6
Default

Here, I used RAND() to make fractals

https://www.dropbox.com/s/j0034an1ce...ight.xlsx?dl=0

Enjoy.

here's my accompanying post:
http://stump.marypat.org/article/110...-a-spreadsheet

__________________
It's STUMP

LinkedIn Profile

Last edited by campbell; 11-25-2018 at 09:34 PM..
Reply With Quote
  #90  
Old 11-26-2018, 09:29 AM
yoyo's Avatar
yoyo yoyo is offline
Member
CAS
 
Join Date: Dec 2001
Posts: 22,514
Default

nice!
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 06:51 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.32869 seconds with 9 queries