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
  #331  
Old 12-01-2016, 05:55 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: 78,010
Blog Entries: 6
Default

http://www.peninsuladailynews.com/ne...lls-of-errors/

Quote:
Timber sales to provide $7.3 million in Clallam County; state official tells of errors

.....
Rosanbalm told commissioners that an Oct. 27 projection of $5.31 million was skewed by a spreadsheet error.

Specifically, two active sales were omitted from the list, he said.

“I knew as soon as I saw the letter that something was wrong,” Commissioner Bill Peach said after the briefing.

“I was glad they were able to point quickly to what the error was.”

Similarly, a September revenue projection of $10.27 million was thrown off by a mistake on a spreadsheet, Rosanbalm said.

Rosanbalm told commissioners that he would double-check the data in the future.

__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #332  
Old 02-17-2017, 04:38 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: 78,010
Blog Entries: 6
Default

http://www.peninsuladailynews.com/ne...lallam-494157/

Quote:
Spreadsheet errors cost Clallam $494,157

PORT ANGELES — Errors on a pair of Clallam County Sheriff’s Office budget documents will cost the county $494,157 in 2017, officials said this week.

A $331,074 Excel spreadsheet calculation error was made on a sheriff’s operations salary worksheet during the annual budget cycle last fall, commissioners learned Monday.

A $163,083 spreadsheet error was made on a sheriff’s jail salary worksheet, officials said.

“It’s about a half-a-million in round numbers,” said Chief Accountant Stan Creasey, who was speaking as a private citizen at the commissioners’ meeting Tuesday. “This is a really big number.”
.....
“All of the calculations were correct for step increases, benefits. It’s just that the Excel calculations within a couple of different sections were incorrect, and so it wasn’t giving us the right total at the bottom of the spreadsheet.”

County Sheriff Bill Benedict said the net effect of the mistake was that budget lines for personnel were reduced by 10 percent to 12 percent.

The transcription errors were caught by sheriff’s office fiscal specialist Jackie Koon, he said.

“We did some forensics,” Benedict said Wednesday. “The spreadsheets were emailed back and forth between us and [County Administrator] Jim Jones’ office. Because of some cutting and pasting, not all the formulas were pasted correctly. It was an unintended error.”
.....
By the end of January, budget lines for personnel in the sheriff’s office were considerably higher than the baseline.

“I thought, ‘Holy crap this isn’t right,’ ” Benedict told the board.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #333  
Old 02-17-2017, 05:22 PM
oedipus rex's Avatar
oedipus rex oedipus rex is offline
Member
SOA AAA
 
Join Date: Nov 2002
Favorite beer: too many to list here
Posts: 15,272
Default

wow, someone lost their job over that one.
__________________
Life can only be understood backwards; but it must be lived forwards. --S.K.
Reply With Quote
  #334  
Old 02-17-2017, 05:39 PM
redearedslider's Avatar
redearedslider redearedslider is online now
Member
CAS
 
Join Date: Oct 2015
Posts: 10,985
Default

Close enough for government work
__________________
P FM MFE C 5 S 6 ACAS MAAA 7 8 9 FCAS FSA MBA CPA CFA CERA MS PhD

VEE Econ VEE Corporate Finance

OC 1 OC2 COP

Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #335  
Old 02-24-2017, 01:34 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: 78,010
Blog Entries: 6
Default

https://www.theregister.co.uk/2017/0...00_colleagues/

Quote:
Blundering Boeing bod blabbed spreadsheet of 36,000 coworkers' personal details in email
Its own security software could have stopped data exposure

Global aerospace firm Boeing earlier this month sent a notification to Washington State Attorney General Bob Ferguson, as required by law, about a company employee who mistakenly emailed a spreadsheet full of employee personal data to his spouse in November, 2016.

The spreadsheet, sent to provide the employee's spouse with a formatting template, contained the personal information of roughly 36,000 other Boeing employees, including Social Security numbers and dates of birth, in hidden columns. Some 7,288 of the affected employees resided in Washington State.

Had the company been using the data loss protection (DLP) software it makes, Boeing might not now be in the position of offering two-year subscriptions to Experian's identity theft protection service to tens of thousands of employees.

......
Not expecting much, The Register asked Boeing's communications department whether the company ate its own security dog food. A company spokesperson said in an email, "We have notified all affected parties about the incident. We believe it is contained and the risk of harm is very low. I don't have anything else to add."

The Register then reached out to Gregory L Smith, a Boeing technical fellow and, as his LinkedIn profile says, "the innovator and developer behind the Cipher software application." Smith explained in a brief phone interview that Boeing has thousands of copies of the software, but that it only mandates the product for classified work.

According to research conducted by IBM and the Ponemon Institute – presumably to incentivize the sale of security software and services – the average cost of a data breach reached $4 million in 2016 and the average cost per record came to $158. For Boeing then, the cost of that spreadsheet might be as high as $5.7 million.

__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #336  
Old 02-24-2017, 01:40 PM
therealsylvos's Avatar
therealsylvos therealsylvos is offline
Member
CAS
 
Join Date: Mar 2014
Posts: 13,532
Default

Quote:
Originally Posted by campbell View Post
hidden columns
__________________
Quote:
Originally Posted by ao fan View Post
i like laying in the tube and pretending that i'm dead.
Reply With Quote
  #337  
Old 08-06-2017, 03:18 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: 78,010
Blog Entries: 6
Default

http://blogs.discovermagazine.com/ne.../#.WYdhmITyuHs

Quote:
Spreadsheet Risks in Science

Errors in the use of spreadsheets such as Microsoft Excel could pose risks for science.

That’s according to a preprint posted on arXiv from Ghada AlTarawneh and Simon Thorne of Cardiff Metropolitan University.


AlTarawneh and Thorne conducted a survey of 17 researchers from the University of Newcastle neuroscience research centre, ranging from PhD students to senior researchers. None of the respondants had any formal, certified training in spreadsheet use, with most (71%) being self-taught. Despite this, the majority of the researchers rated themselves as “intermediate” users of Excel.

Worryingly, only 20% reported that they had their spreadsheets checked for errors by colleagues (‘peer reviewed’). Most said they did all the testing themselves, or even that they did none at all.


https://arxiv.org/abs/1703.09785

Quote:
A Pilot Study Exploring Spreadsheet Risk in Scientific Research

Ghada AlTarawneh, Simon Thorne
(Submitted on 23 Mar 2017)
This paper discusses the risks and potential impacts of spreadsheet errors in scientific research data in a Neuroscience research centre in the UK.
Spreadsheets usage in neuroscience, or indeed any medical discipline, is a largely unreported area of spreadsheet research. This paper presents a case study exploring the possible risks and impacts of spreadsheet errors in the neuroscience research centre at the University of Newcastle. Data was collected using an online questionnaire with 17 participants and two detailed semi-structured interviews.
The analysis highlights that errors in research data may lead to severe impacts such as misleading science and damaged personal and organisational reputations. In addition, many risks factors arise from using spreadsheets such as inadequate design and a lack of training.
Spreadsheets are used widely in business and the impacts and risks in these fields have been studied and highlighted in detail. However, scientific research and spreadsheets have also a significant relationship that has not been clarified. The paper also draws out the similarities in spreadsheet practice between the scientific and business communities.
Comments: 21 pages, 5 colour figures, 2 tables
Subjects: Computers and Society (cs.CY)
Journal reference: Proceedings of the EuSpRIG 2016 Conference 'Spreadsheet Risk Management' pp49-69 ISBN: 978-1-905404-53-7
Cite as: arXiv:1703.09785 [cs.CY]
(or arXiv:1703.09785v1 [cs.CY] for this version)
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Tags
machine learning, predictive analytics, speadsheet error, spreadsheets

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 09:24 PM.


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.28494 seconds with 12 queries