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

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


Reply
 
Thread Tools Search this Thread Display Modes
  #351  
Old 04-09-2018, 04:33 PM
dunnigan dunnigan is offline
Member
SOA AAA
 
Join Date: Apr 2007
Posts: 133
Default

Regarding naming conventions, I just love things named "New" this or that.

NewUL.xlsx
NewProcess.xlsx

Sometimes those names hang around for 15 years.
Reply With Quote
  #352  
Old 04-16-2018, 09:45 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: 83,767
Blog Entries: 6
Default

https://www.businessinsider.co.za/si...igation-2018-4

Quote:
BUSINESS INSIDER | BUSINESS
Two KPMG partners with a combined 26-year history at the firm have quit amid the growing VBS Mutual Bank scandal
Spoiler:
KPMG South Africa on Saturday announced the resignations of long-standing partner Sipho Malaba as well as long-time employee (and more recently a partner) Dumi Tshuma.
Both had left before they could face disciplinary proceedings "connected to VBS Bank".
VBS Mutual Bank was placed into curatorship after what the Reserve Bank has described as chaotic financial management.
Two of its partners, Sipho Malaba and Dumi Tshuma, had resigned, KPMG announced on Friday afternoon.

Between them, the two had been at KPMG for more than a quarter of a century.

Malaba had been a partner at KPMG for more than 11 years according to his LinkedIn profile. Tshuma had been with KPMG for 15 years in various positions, the last three years as a partner.

KPMG said disciplinary cases against both had included "failure by the partners to comply with the firm’s policies and procedures regarding the disclosure of relevant financial interests" related to VBS Mutual Bank.

Since VBS was placed into curatorship and its books effectively opened it has emerged that some R900 million of its supposed deposits could not be traced.

There have also been allegations that insiders benefitted, and that some were extended loans despite conflicts of interest.

There has been no evidence that such benefits or loans flowed to the bank's auditors, either KPMG or (since dismissed) internal auditors PwC.

But there has been extensive evidence that the VBS books – signed off by its auditors – were in a terrible state.

In mid 2017, legal papers filed by the Reserve Bank show, VBS had a shortfall of R250 million. It turned out that VBS had accidentally paid that money out "due to internal control failures in a branch".

There had "inept risk management functions and practices" the Reserve Bank said.

And sometimes VBS had managed hundreds of millions of rands using consumer-grade desktop software.

Before it was placed in curatorship, regulators pointed out the VBS relied on one specific area of its business to drive profits: its fuel-guarantee and contract-finance business.


Once the books were opened to its new curator, the details of how those business lines were managed came to light.

"Excel spreadsheets are used to manage the contract finance and fuel guarantee books of the bank," the Reserve Bank told the high court in a filing. "In addition to these being susceptible to manipulation, it is highly unusual for a bank to manage these contracts by means of an Excel spreadsheet."

900 million rand's worth of deposits are missing -- that's about $75 million
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #353  
Old 05-07-2018, 02:35 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: 83,767
Blog Entries: 6
Default

https://www.bbc.com/news/uk-44020235

Quote:
Junior doctors' job offers withdrawn after blunder

Spoiler:
Up to 1,500 junior doctors offered posts as registrars have had their job offers withdrawn, following a mistake in the recruitment process.

Doctors say they have been left stressed and in limbo, and potentially out of pocket over plans to move home.

The Royal College of Physicians, which oversees recruitment, apologised for the "human error" and is working over the weekend to restart the process.

Doctors' union, the British Medical Association, said it was "appalled".

The junior doctors were alerted to the error just before 17:00 BST on Friday, at the start of the bank holiday weekend. Fellow doctors described juniors as being in tears.

Many were set to uproot their families to take up the job offers, selling homes, putting offers down on houses, moving children to new schools and partners resigning from jobs to find new ones.

, said he was in "total limbo" after the withdrawal of his job offer to work in cardiology in London.

"I'm getting married next month, and my fiancée lives and works in London - it would be very difficult for us if I don't receive another offer in London," he said.

"For years I've been moving from contract to contract as a junior doctor, so the idea of having a stable job for five years was amazing.



"It's hugely annoying and upsetting to have the carpet swept out from under us after someone made a spreadsheet error."

A nationally co-ordinated system, known as ST3 Recruitment, is used for recruiting doctors across England, Scotland and Wales into a broad range of specialities.

Last month, after attending interviews, up to 1,500 junior doctors entering their third year of specialist training received job offers in 24 different medical fields.

Each candidate was given a score which determined how likely they were to get their choice of hospital and specialty.

On Thursday, the Royal College of Physicians (RCP) discovered a significant number of candidates were credited with the wrong score, because of an error transferring data from one computer programme to another - and may therefore have received an incorrect job offer.
Spoiler:
On Friday, the RCP wrote to all those who had offers to say it was being rescinded.

"We are deeply sorry that it has been necessary to rerun the ST3 offer process due to a mistake in this round of processing," the letter from the RCP said.

"We have taken this approach to be fair to all candidates which can only be achieved with the real scores used."

In an updated statement, the RCP said it was working through the weekend to restart the recruitment process but it will take more than a week until the first offers start on Monday 14 May.

It acknowledged the "bad timing" of the announcement but said "we decided that it would be even worse to keep the information to ourselves for three days" and wanted to be "as transparent as early as possible".

Speaking on behalf of the junior doctors, the BMA issued a statement saying: "We cannot express how unacceptable we find this situation."

It said it had caused extreme anxiety for trainees and lamented "the impact - both emotionally and financially - it is having on junior doctors across the UK".

Chairs Chaand Nagpaul and Jeeves Wijesuriya said they had spoken at length with Professor Jane Dacre, president of the Royal College of Physicians, "to articulate the strength of feeling".

"We have heard from trainees who have, after receiving these job offers, put down deposits on homes, arranged moves or whose families had adjusted their plans," they said.

"We have conveyed our expectation that college will support and compensate these trainees for any inconvenience."

The BMA said it would take legal advice regarding a possible breach of contract, and compensation.

James Savage, 28, ended talks with other potential employers when he received his first choice job offer in renal medicine in the West Midlands.

"It's not well understood how much we move around as junior doctors.

"You move jobs every four months, hospitals and even locations every year. So these contracts were an offer of stability for the first time.

"Our morale is already extremely low. This isn't going to help things."

.....
The RCP said the error was discovered on Thursday and the college had worked as quickly as they could to identify the nature and extent of the problem.

"We appreciate what a worrying time this is for you and will provide as much information as we can, when we can, so you know what is happening," the RCP stated in a letter sent out on Friday.

The RCP added that those doctors who had accepted offers - and made significant plans and commitments based on those offers - would be treated on a case-by-case basis.

"We set the highest standards for our work and expect to be held to them. We have not met them here and are truly sorry," it said.

"We will learn from our mistake and make any changes necessary to fix it."

The Department of Health said it was monitoring the matter closely and was satisfied there would be no impact on patient safety as the jobs were not due to begin until August.
http://www.st3recruitment.org.uk/new...offers-process

Quote:
Update on the re-running of the ST3 offers process
Further to the message yesterday regarding the necessity to re-run the offers for ST3 medical specialties, RCP president Professor Jane Dacre and RCP registrar Dr Andrew Goddard have emailed all candidates interviewed in round 1 of the 2018 process; the text of that email is replicated below.


Spoiler:
We are writing to update you following our email yesterday on the dreadful situation with ST3 offers. We are deeply sorry that it has been necessary to rerun the ST3 offer process due to a mistake in this round of processing. We have taken this approach to be fair to all candidates which can only be achieved with the real scores used. We appreciate what a worrying time this is for you and will provide as much information as we can, when we can, so you know what is happening, and when to expect more information. We are talking with the training bodies for each of the four nations, other Royal Colleges, specialty societies and the BMA and we are grateful to them and everyone who has contacted us for the information and advice they are providing. We are being transparent and will fix this in the fastest and fairest way possible.

We are working through the weekend to restart the process at the earliest opportunity and will answer questions to let people know what is happening. We completely appreciate that this cannot happen too soon and that the frustration, anger and anxiety people are feeling can only be helped by answers and solutions. Below are some answers to questions we have received and more detail will be provided on Tuesday. Whilst we want to respond as fast as possible to everyone’s questions, we will ensure our answers are accurate rather than rushed. When we don’t know the answer we will let you know how and when we will.

What are we doing now?

Over the weekend we are compiling and checking the revised scores and ranks so that we are ready to upload these as soon as possible when the system is ready. We are also monitoring the st3recruitment inbox and responding to candidates with what we can at this stage. However, we are unable to give much specific advice now but your emails are proving valuable in compiling FAQs, which is another major piece of work we are undertaking at the moment.

Who is and is not affected?

This has affected all candidates who were found appointable and are competing for an ST3 medical specialty programme in one of the 24 medical specialties coordinated by the RCP. Due to the high degree of crossover in applicants to clinical oncology and intensive care medicine, these specialties are also being included even though there is no suggestion of any error with their ranking process.

Anyone who only applied to ST3 to be clinically benchmarked to have their academic clinical fellowship programme confirmed is unaffected as decisions on whether or not a candidate was appointable have been confirmed as correct as advised.

CMT/ACCS acute medicine is also unaffected.

We are aware that some candidates will have applied to specialties and posts which are not included above and we are working on this and will include more detail in the FAQs on Tuesday.

Why did the communication come out late on a Friday?

We appreciate that the timing of the communication was very bad timing for most people. But we decided that it would be even worse to keep the information to ourselves for three days just as we know many people will be making important choices about their careers and lives. We felt it was better to communicate at the first opportunity and be as transparent as early as possible.

We found out about the issue on Thursday, and worked as fast as possible to identify the extent and nature of the problem and how to fix it. We decided it was important to resolve how this could be addressed in the fairest way possible and put the technical arrangements in place. This process was done quickly in liaison with the four nations and the Oriel system provider and but it took until Friday afternoon to be complete which was when we communicated.

What was the problem?

A spreadsheet error was made in transferring data from one system to another. The electronic marking system used at interview produces a spreadsheet, which was then copied into Excel. At this point appointability criteria are checked and those not appointable excluded. This spreadsheet is then copied into a new sheet with a different format to be uploaded to Oriel. It was at this point that the error occurred. A formula required to match the formatting of Oriel was entered but was not copied correctly all the way through the relevant columns in the spreadsheet. This resulted in marks from interview stations being mixed up and, as a result, incorrect rankings given for a significant number of candidates. Checks were made throughout process, but the checks between the electronic marking system were incorrectly made against the first Excel spreadsheet rather than the second.
Spoiler:
Why will it take over a week for offers to start?

Rolling back candidate statuses is a complex process, which will take time to implement and test so that it will not have any unintended consequence. The whole system has to be taken off line, restarted and risk checked. We then need to reload the scores and ranks for all candidates and conduct stringent checking to avoid a similar situation. In addition to this we believe that candidates should get the opportunity to review their programme preferences to ensure these are as they would wish. This is because there are opportunities throughout the offers period where candidates can make changes and also their situation may have changed. For example, if someone was originally offered their third preference and is now happy with this, they may wish to make it their first preference to guard against being offered an originally higher choice.

These factors mean a start date for offers of Monday 14 May is the earliest we feel it is safe to start. We will be seeking to create a timetable that enables us to progress through offers as quickly as possible whilst providing safeguards for candidates asked to make decisions in an unplanned period.

When will we find out more?

A more extensive FAQ document will be published on Tuesday, which will cover the latest information we have and seek to answer questions we have received. All candidates potentially affected will be emailed to notify when this is ready. Beyond this we will communicate regularly throughout the process to notify when things will happen and when key stages are ready; eg when revised scores and ranks are confirmed, programme preferences available, offers starting etc.

After offers start all candidates will be emailed with either details of the offer or to notify that they are on the reserve list as happened in the original offers period.

What will be in the FAQs?

This will cover a wide-range of topics and we are writing them now. This will include topics such as: ‘How did this happen?’; ‘What is the timeline for making and finalising offers?’; ‘Who is/is not affected?’ etc. We cannot give a full list now but please be assured we are seeking to make it as comprehensive as possible and monitoring questions we are receiving and being asked on social media and via representative organisations.

What if I have not got the offer I originally accepted and have made unretractable commitments to others?

We understand that this has happened and hope this will only apply to a very small number of candidates but will handle each case as needed. If it becomes clear this applies to you once your offers are made, you will be able to contact us and discuss your circumstances with a member of the RCP staff such that we can then do our utmost to resolve your case.

If I was deemed unappointable will this change?

No. While non-appointable candidates may have their score altered, the error did not affect the appointability criteria. The error happened later in the process and after non-appointable candidates were removed.

We set the highest standards for our work and expect to be held to them. We have not met them here and are truly sorry. We will learn from our mistake and make any changes necessary to fix it.

Yours sincerely

RCP president, Professor Jane Dacre

RCP registrar, Dr Andrew Goddard
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #354  
Old 05-07-2018, 02:37 PM
ElDucky's Avatar
ElDucky ElDucky is offline
Free Mason
 
Join Date: Jul 2004
Location: In a van, down by the river
Studying for Let me worry about blank
Favorite beer: Trappistes Rochefort 8
Posts: 41,584
Default

Quote:
Originally Posted by campbell View Post
https://www.businessinsider.co.za/si...igation-2018-4



900 million rand's worth of deposits are missing -- that's about $75 million
Yet another problem with Excel and Rand.
__________________
I live near the cows.
Reply With Quote
  #355  
Old 05-14-2018, 01:18 AM
The Drunken Actuary's Avatar
The Drunken Actuary The Drunken Actuary is offline
Member
CAS SOA Non-Actuary
 
Join Date: Nov 2001
Favorite beer: Early and Often
Posts: 84,486
Default

Quote:
Originally Posted by ActSciMan View Post
Speaking of the YYYY-MM-DD format, I like when people run a report monthly and they put it in a new folder each month and they type the date like "Jan 2017", "Feb 2017", Mar 2017", so that when you look at the folder, it's not in any way organized by order of when the report was run. Just do 2017-01, 2017-02, 2017-03 and then it's perfect.
Sort by saved date imo
__________________
I think the dollar will crash irreparably by 2012.... bottom drops out of the dollar. ....Dollars are worthless, 401ks are bust, the markets are valueless...government assumes control over all industry and everything is nationalized by the end of 2012. - gomer_tree
Reply With Quote
  #356  
Old 05-23-2018, 11:20 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is online now
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,410
Blog Entries: 1
Default

https://www.washingtonpost.com/world...=.bd681cf40a64


Quote:
The FBI has repeatedly provided grossly inflated statistics to Congress and the public about the extent of problems posed by encrypted cellphones, claiming investigators were locked out of nearly 7,800 devices connected to crimes last year when the correct number was much smaller, probably between 1,000 and 2,000, The Washington Post has learned.
....
“The FBI’s initial assessment is that programming errors resulted in significant over-counting of mobile devices reported,’’ the FBI said in a statement Tuesday. The bureau said the problem stemmed from the use of three distinct databases that led to repeated counting of phones. Tests of the methodology conducted in April 2016 failed to detect the flaw, according to people familiar with the work.
Sounds like someone needs some lessons in SQL.
__________________
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.
Reply With Quote
  #357  
Old 08-12-2018, 02:35 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: 83,767
Blog Entries: 6
Default

https://twitter.com/brian_bilston/st...46209374576643

Quote:
Here’s a love poem in an Excel spreadsheet.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #358  
Old 08-13-2018, 12:05 PM
Chuck Chuck is offline
Member
SOA AAA
 
Join Date: Oct 2001
Location: Illinois
Posts: 4,412
Default

I hope he wrote that on a fast computer, because love hertz.
Reply With Quote
  #359  
Old 08-13-2018, 02:02 PM
Dr T Non-Fan Dr T Non-Fan is online now
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 92,392
Default

Na. Zareth. Or Bison.

Boo Da Low puns all you want.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
Reply With Quote
Reply

Tags
machine learning, predictive analytics, speadsheet error, spreadsheets

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 11:09 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.33789 seconds with 12 queries