Tag: spreadsheet

PSNI apologises to officers and civilian staff after major security breach

Mary Pat Campbell

Link: https://m.belfasttelegraph.co.uk/news/northern-ireland/psni-apologises-to-officers-and-civilian-staff-after-major-security-breach/a1823676448.html?=123&s=03

Graphic:

Additional: https://twitter.com/owenboswarva/status/1688975359604101129/photo/1

Excerpt:

However, a second tab in the spreadsheet contained multiple entries in relation to more than 10,000 individuals. For each individual, there are 32 pieces of data meaning that in total, there are about 345,000 pieces of data in the file.

The spreadsheet, which has been seen by the Belfast Telegraph after we were alerted to it by a relative of a serving officer, includes each officer’s service number, their status, their gender, their contract type, their last name and initials, details of how much of the week they work, and their rank.

It also includes the location where they are based (but not their home address), their duty type (from chief constable to detective, intelligence officer and so on), details of their unit (such as the anti-corruption unit or the vetting department), their branch and department, and other technical information about their employment.

There are 10,799 entries in the database. There are 9,276 police officers and police staff. It is not clear if the additional entries relate to other employees or former employees.

The data has been removed from the internet.

There are details of staff who are suspended, on career breaks, or partly retired.

It reveals members of the organised crime unit, telecom liaison officers, intelligence officers stationed at ports and airports, PSNI pilots in its air support unit, officers in the surveillance unit and – of acute sensitivity – almost 40 PSNI staff based at MI5’s headquarters in Holywood.

There are a tiny number of individuals whose unit is given as “secret”. But although that does not disclose precisely what they do, it marks them out as operating in an acutely sensitive area – and then gives their name.

Author(s): Sam McBride and Liam Tunney

Publication Date: 8 Aug 2023

Publication Site: Belfast Telegraph

Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST

Mary Pat Campbell

Link: https://www.youtube.com/watch?v=kQPUWryXwag&ab_channel=LeilaGharani

Video:

Description:

OpenAI inside Excel? How can you use an API key to connect to an AI model from Excel? This video shows you how. You can download the files from the GitHub link above. Wouldn’t it be great to have a search box in Excel you can use to ask any question? Like to create dummy data, create a formula or ask about the cast of the The Sopranos. And then artificial intelligence provides the information directly in Excel – without any copy and pasting! In this video you’ll learn how to setup an API connection from Microsoft Excel to Open AI’s ChatGPT (GPT-3) by using Office Scripts. As a bonus I’ll show you how you can parse the result if the answer from GPT-3 is in more than 1 line. This makes it easier to use the information in Excel.

Author(s): Leila Gharani

Publication Date: 6 Feb 2023

Publication Site: Youtube

Thinking Spreadsheet

Mary Pat Campbell

Link: https://joelgrus.github.io/thinking-spreadsheet/

Graphic:

Excerpt:

There are many books about spreadsheets out there. Most of these books will tell you things like “How to save a file” and “How to make a graph” and “How to compute the present value of a stream of cashflows” and “How to use conjoint analysis to figure out which features you should add to the next version of your company’s widgets in order to impress senior management and get a promotion and receive a pay raise so you can purchase a bigger boat than your neighbor has.”

This book isn’t about any of those. Instead, it’s about how to Think Spreadsheet. What does that mean? Well, spreadsheets lend themselves well to solving specific types of problems in specific types of ways. They lend themselves poorly to solving other specific types of problems in other specific types of ways.

Thinking Spreadsheet entails the following:

  • Understanding how spreadsheets work, what they do well, and what they don’t do well.
  • Using the spreadsheet’s structure to intelligently organize your data.
  • Solving problems using techniques that take advantage of the spreadsheet’s strengths.
  • Building spreadsheets that are easy to understand and difficult to break.

To help you learn how to Think Spreadsheet, I’ve collected a variety of curious and often whimsical examples. Some represent problems you are likely to encounter out in the wild, others problems you’ll never encounter outside of this book. Many of them we’ll solve multiple times. That’s because in each case, the means are more interesting than the ends. You’ll never (I hope) use a spreadsheet to compute all the prime numbers less than 100. But you’ll often (I hope) find useful the techniques we’ll use to compute those prime numbers, and if you’re clever you’ll go away and apply them to all sorts of real-world problems. As with most books of this sort, you’ll really learn the most if you recreate the examples yourself and play around with them, and I strongly encourage you to do so.

Author(s): Joel Grus

Publication Date: originally in dead-tree form 2010, accessed 29 Oct 2022

Publication Site: Joel Grus github

SEC Charges Allianz Global Investors and Three Former Senior Portfolio Managers with Multibillion Dollar Securities Fraud

Mary Pat Campbell

Link: https://www.sec.gov/news/press-release/2022-84

Excerpt:

The SEC’s complaint, filed in the federal district court in Manhattan, alleges that Structured Alpha’s Lead Portfolio Manager, Gregoire P. Tournant, orchestrated the multi-year scheme to mislead investors who invested approximately $11 billion in Structured Alpha, and paid the defendants over $550 million in fees. It further alleges that, with assistance from Co-Lead Portfolio Manager, Trevor L. Taylor, and Portfolio Manager, Stephen G. Bond-Nelson, Tournant manipulated numerous financial reports and other information provided to investors to conceal the magnitude of Structured Alpha’s true risk and the funds’ actual performance. 

Defendants reduced losses under a market crash scenario in one risk report sent to investors from negative 42.1505489755747% to negative 4.1505489755747% — by simply dropping the single digit 2.  In another example, defendants “smoothed” performance data sent to investors by reducing losses on one day from negative 18.2607085709004% to negative 9.2607085709004% — this time by cutting the number 18 in half.    

Publication Date: 17 May 2022

Publication Site: SEC

Architect of Allianz fraud made $60 mln as he lied to investors, U.S. says

Mary Pat Campbell

Link: https://www.reuters.com/business/finance/architect-allianz-fraud-made-60-mln-he-lied-investors-us-says-2022-05-17/

Excerpt:

The star portfolio manager at the centre of a fraud at the U.S. funds unit of Allianz SE (ALVG.DE) relied on the German insurer’s good name to lure investors and thrived from a lack of oversight as he pocketed $60 million in pay, U.S. authorities said.

Gregoire “Greg” Tournant, a citizen of France and the United States, was indicted on Tuesday for securities fraud, investment adviser fraud, wire fraud and obstruction of justice in a scheme that ran from 2014 to 2020. read more

It was a major development in a two-year saga that has haunted and embarrassed Allianz, one of the globe’s biggest financial firms, and began after the $11 billion in funds managed by Tournant collapsed as markets roiled with the outbreak of the coronavirus in early 2020.

U.S. prosecutors on Tuesday said Tournant faked documents, fabricated risk reports, altered spreadsheets, and lied about the investment strategy.

Author(s): Tom Sims, Alexander Hübner and John O’Donnell

Publication Date: 18 May 2022

Publication Site: Reuters

Microsoft Excel: The Program’s Designer Reveals The Secrets Behind The Software That Changed the World 25 Years Ago

Mary Pat Campbell

Link:https://www.thedailybeast.com/microsoft-excel-the-programs-designer-reveals-the-secrets-behind-the-software-that-changed-the-world-25-years-ago

Excerpt:

In a year when big names from the digital realm profoundly affected the world—Mark Zuckerberg or Julian Assange, take your pick—it’s appropriate to add one more: Douglas Klunder. While largely unnoticed, 2010 marked the 25th anniversary of perhaps the most revolutionary software program ever, Microsoft Excel, and Klunder, now an unassuming attorney and privacy activist for the American Civil Liberties Union in Washington state, gave it to us.

…..

For Doug Klunder, the mission 25 years ago wasn’t so grandiose. As lead developer of Excel, he was handed the job of vaulting Microsoft—then known best for MS-DOS, the operating system in IBM’s PCs—to the forefront in business applications. “We decided it was time to do a new, better spreadsheet,” recalls Klunder, now 50, who joined Microsoft straight out of MIT in 1981 (part of the interview process included lunch with Bill Gates and Steve Ballmer at a Shakey’s pizza parlor).

…..

Klunder and his team came up with “intelligent recalc,” an approach where the program updated only the cells affected by the data change rather than all the formulas in the spreadsheet. Klunder credits Gates with the idea for how to implement the feature—though he says Gates eventually told him he hadn’t implemented what he had in mind at all. Klunder thinks Gates misremembered the discussion, but adds, “Maybe he actually did have a more brilliant idea that now is lost forever.”

Author(s):Thomas E. Weber

Publication Date:14 July 2017 (originally published 2010)

Publication Site: Daily Beast

Several Ways to Improve Your Use of Excel for Actuarial Production

Mary Pat Campbell

Link: https://www.soa.org/sections/small-insurance/small-insurance-newsletter/2021/june/stn-2021-06-mathys/

Graphic:

Excerpt:

Create a Consistent Structure for Calculations

When spreadsheets are created ad-hoc, the usage of time steps tends to be inconsistent: advancing by rows in one sheet, columns in another, and even a mix of the two in the same sheet. Sometimes steps will be weeks, other times months, quarters, or years. This is confusing for users and reviewers, leads to low trust, increases the time for updates and audits, and adds to the risks of the spreadsheet.

A better way is to make all calculations follow a consistent layout, either across rows or columns, and use that layout for all calculations, regardless if it requires a few more rows or columns. For example, one way to make calculations consistent is with time steps going across the columns and each individual calculation going down the rows:

Author(s): Stephan Mathys

Publication Date: June 2021

Publication Site: Small Talk at the Society of Actuaries

Cell Maps – Critical Comments

Mary Pat Campbell

Link: https://logiccomppeople.blogspot.com/2021/04/cell-maps-critical-comments.html

Graphic:

Excerpt:

Cell maps are intended as tools for reviewing spreadsheets. If you spot an error or an inconsistency in the cell map this should be recorded and, if practicable, corrected.

The cell mapping software provides a method for recording a reviewer’s comments. All comments are linked to a specific map (or data table), The comments for a workbook under review are collated in a single worksheet.

Publication Date: 18 April 2021

Publication Site: Logic, Computing, and People

Huge vaccine error: 9,000 patients were forgotten

Mary Pat Campbell

Link: https://stiften.dk/artikel/k%C3%A6mpe-vaccinefejl-9-000-patienter-blev-glemt

Excerpt (via Google Translate):

Jørgen Schøler Kristensen, Medical Director at Aarhus University Hospital, explains the error as follows:

– When patients with a civil registration number beginning with 0 had to be entered, the civil registration number was declared invalid if a hyphen was missing. So 26 percent of the civil registration numbers we have reported have not been entered correctly, so they have not received the invitation in their e-box to be vaccinated as they should have had, says Jørgen Schøler Kristensen.

Patients born the first nine days of any month and having been unlucky with a hyphen were forgotten.

Additional:

Author(s): Jens Christian Thaysen

Publication Date: 19 March 2021

Publication Site: Århus Stiftstidende

The Biggest Business Fails of All Time

Mary Pat Campbell

Link: https://moneywise.com/a/the-biggest-business-fails-of-all-time

Excerpt:

3. Spreadsheet error costs JPMorgan $3.1 billion

You might recall the “London Whale” incident in 2012, when notorious trader Bruno Iksil — whose other monikers include the White Whale and even Voldemort — conducted a series of credit default swaps that cost JPMorgan Chase $6.2 billion.

What you might not know, however, is that half the loss was incurred by a simple Excel spreadsheet error.

Bloomberg reports that the Excel model, which relied heavily on copy and pasting of information, accidentally “underestimated risk by half.”

Author(s): Serah Louis

Publication Date: 1 March 2021

Publication Site: MoneyWise

Improving on perfection — where next for the spreadsheet?

Mary Pat Campbell

Link: https://medium.com/dawn-capital/improving-on-perfection-where-next-for-the-spreadsheet-7e15c99e7e5c

Graphic:

Excerpt:

The sheer versatility and accessibility of the spreadsheet has made it the Swiss Army Knife of modern day productivity, inserting itself into almost every workflow across every industry. Over the past three decades, spreadsheets have become the de facto way for information to be collected, distributed and analysed.

But, as our operational and computational needs become ever greater, the limits of Excel become clear, and opportunities emerge for companies and tools to replace the spreadsheet.

Author(s): Dawn Capital

Publication Date: 16 December 2021

Publication Site: Medium

Employers make the Canada Revenue Agency mistakes

Mary Pat Campbell

Link: https://www.vaughantoday.ca/employers-make-the-canada-revenue-agency-mistakes/

Excerpt:

The Canadian Revenue Agency (CRA) presented a spreadsheet of Canada Emergency Wage Support (CUSS) that was riddled with errors and cut some business subsidies in half.

To qualify for SSUC – which has so far helped nearly 400,000 companies with grants totaling $ 59 billion – employers must fill out “spreadsheets”: Excel spreadsheets that ARC has been offering on its website since March 15th.

However, the spreadsheet available to companies for payment periods from July 5 to August 29 contained several major errors until last Friday, nine days before the deadline for grant applications.

…..

This mistake had the effect of drastically reducing support for businesses, but only for some owners and their families. It only exists in the French version of the spreadsheet.

Author: Alan Binder

Publication Date: 25 January 2021

Publication Site: Vaughan Today