THE FIRST ANNUAL CAS ACTUARIAL
TECHNOLOGY SURVEY

Link: https://www.casact.org/sites/default/files/2022-03/CAS-RP_First_Annual_CAS_Actuarial_Technology_Survey.pdf

Graphic:

Excerpt:

Excel continues to be actuaries’ most widely used software tool, with more than
94.3% of respondents reporting that they use it at least once a day.
• With that understood, most actuaries (92.3%) use more than one tool.
• Actuaries want to increase their proficiency in R (47.2%), Python (39.1%), SQL
(30.8%), and Excel (26.0%).
• No tool had more than 50% of respondents indicating that they wanted to increase
their proficiency.
• Time is the greatest barrier to learning new technology. (80.5% of respondents felt
so.)
• Newer analysis methods such as tree-based algorithms and artificial intelligence (AI)
are not widely used (16.5% and 7.0%, respectively).

Author(s): Casualty Actuarial Society

Publication Date: March 2022

Publication Site: CAS Research Paper

Police lose hacked therapy center criminal reports after spreadsheet error

Link:https://www.thebharatexpressnews.com/police-lose-hacked-therapy-center-criminal-reports-after-spreadsheet-error/

Excerpt:

The hack into the client database of the private Vastamo psychotherapy center was first exposed on October 21, 2020, when the patient data of tens of thousands of people was stolen and used to blackmail both l company and patients.

Investigators asked each victim to file a criminal complaint, and as of February 2021, more than 25,000 such reports had been submitted. The majority of complaints were lodged at the Pasila police station in Helsinki, but others were lodged elsewhere in the country.

….

Instead of a database, criminal reports were saved via Microsoft Excel files. Some of the files turned out to be unreadable when the police attempted to transfer them into the official system. The cause of the problem is unknown.

Detective Inspector Jari Illukka from the Helsinki Police Department told Svenska Yle that a dozen crime reports had disappeared from Excel, but the exact number is not known.

….

Police estimate that the records of more than 30,000 people were stolen during the Vastaamo data breach, and more than 22,000 of those victims have since reported the crime.

However, a little more than three thousand declaration forms had been given to the police at the end of January, that is to say one victim in ten.

Publication Date: 7 Feb 2022

Publication Site: Bharat Express News

WordXLe: Wordle in Excel

Link:https://sysmod.wordpress.com/2022/01/25/wordxle-wordle-in-excel/

Excerpt:

If you play Wordle daily, or the French version LeMot, you might want to practice more often. For fun, I created an Excel version that you can download, WordXLe. It has sheets for both English and French versions. The dictionaries are:


English main (for validation) c.12000 words from the SOWPODS dictionary; for play c.1100 words.


Version française: principal c.8000 mots; https://github.com/hbenbel/French-Dictionary/blob/master/dictionary/dictionary.txt

Le jeu 1700 mots. https://www.freelang.com/dictionnaire/dic-francais.php
I removed all accents to simplify the game.


It uses Conditional Formatting for colouring, Data Validation to enforce some letter entry rules, no VBA macros, just formulas. The sheets are protected, but it’s easy to unhide things in Excel if you really want to so I’ll leave that as a challenge. 

Author(s): Patrick O’Beirne

Publication Date: 25 Jan 2022

Publication Site: sysmod

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

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

Top Excel experts will battle it out in an esports-like competition this weekend

Link:https://www.pcworld.com/article/559001/the-future-of-esports-is-microsoft-excel-and-its-on-espn.html

Graphic:

Excerpt:

Move over, League of Legends. Does anyone even care about Overwatch? No, the real future of esports is spreadsheets and Microsoft Excel. Don’t believe us? Then tune in to ESPN3 or YouTube this weekend to find out.

No, this isn’t a joke. The Financial Modeling World Cup will be held this weekend entirely in Microsoft Excel. And the finals (the quarterfinals, semifinals, and the final match) will all be broadcast live as they happen at 9 AM PT. Everyone’s playing for a total prize of $10,000 — funded by Microsoft, of course.

Author(s):Mark Hachman

Publication Date: 10 Dec 2021

Publication Site: PC World

Autocorrect errors in Excel still creating genomics headache

Link: https://www.nature.com/articles/d41586-021-02211-4

Graphic:

Excerpt:

In 2016, Mark Ziemann and his colleagues at the Baker IDI Heart and Diabetes Institute in Melbourne, Australia, quantified the problem. They found that one-fifth of papers in top genomics journals contained gene-name conversion errors in Excel spreadsheets published as supplementary data2. These data sets are frequently accessed and used by other geneticists, so errors can perpetuate and distort further analyses.

However, despite the issue being brought to the attention of researchers — and steps being taken to fix it — the problem is still rife, according to an updated and larger analysis led by Ziemann, now at Deakin University in Geelong, Australia3. His team found that almost one-third of more than 11,000 articles with supplementary Excel gene lists published between 2014 and 2020 contained gene-name errors (see ‘A growing problem’).

Simple checks can detect autocorrect errors, says Ziemann, who researches computational reproducibility in genetics. But without those checks, the errors can easily go unnoticed because of the volume of data in spreadsheets.

Author(s): Dyani Lewis

Publication Date: 13 August 2021

Publication Site: nature

Have Fun With Approximations!

Link: https://www.linkedin.com/pulse/have-fun-approximations-mary-pat-campbell/

Graphic:

Pdf: https://drive.google.com/file/d/0ByabEDuWaN6FNmZhTDBYeEVrNVE/view?resourcekey=0-U4GI2_9zn4UQdWza1bq95w

Excerpt:

In the pre-computer days, people used these approximations due to having to do all calculations by hand or with the help of tables. Of course, many approximations are done by computers themselves — the way computers calculate functions such as sine() and exp() involves approaches like Taylor series expansions.

The specific approximation techniques I try (1 “exact” and 6 different approximation… including the final ones where I put approximations within approximations just because I can) are not important. But the concept that you should know how to try out and test approximation approaches in case you need them is important for those doing numerical computing.

Author(s): Mary Pat Campbell

Publication Date: 3 February 2016 (updated for links 2021)

Publication Site: LinkedIn, CompAct, Society of Actuaries

Cell Maps – Critical Comments

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

Excel Never Dies: The Spreadsheet That Launched A Million Companies

Link: https://www.notboring.co/p/excel-never-dies

Graphic:

Excerpt:

Excel may be the most influential software ever built. It is a canonical example of Steve Job’s bicycle of the mind, endowing its users with computational superpowers normally reserved for professional software engineers. Armed with those superpowers, users can create fully functional software programs in the form of a humble spreadsheet to solve problems in a seemingly limitless number of domains. These programs often serve as high-fidelity prototypes of domain specific applications just begging to be brought to market in a more polished form. 

If you want to see the future of B2B software, look at what Excel users are hacking together in spreadsheets today. Excel’s success has inspired the creation of software whose combined enterprise value dwarfs that of Excel alone.

Author(s): Packy McCormick

Publication Date: 8 March 2021

Publication Site: Not Boring

Analyzing Census Data in Excel

Link: https://www.census.gov/data/academy/courses/excel.html

Description

Excel is a very popular tool among all data users. It can be leveraged to unlock the value of open data of all kinds, and it is particularly well-suited to transforming, analyzing, and visualizing Census data. This course will show how to use Excel to access, manipulate, and visualize Census data.  It will also tools for doing advanced statistical analysis.

After completing this course, you will be able to:
    ✓    Access data from the Census Bureau using the American FactFinder
    ✓    Format tables for data analysis
    ✓    Perform basic and advanced analysis of Census data using Excel
    ✓    Create data visualizations such as sparklines, hierarchical charts, and histograms

Author(s): Andy Hecktman, Alexandra Barker

Date Accessed: 27 February 2021

Publication Site: U.S. Census Bureau

Improving on perfection — where next for the spreadsheet?

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

Spreadsheet Wars: Excel vs Lotus 1-2-3

Link: https://archive.org/details/CC606_spreadsheet_wars

Excerpt:

Excel now dominates the spreadsheet world, but once upon a time there was actual competition among spreadsheet products. This program looks at Quattro 1.0, Allways 1.0, Lotus 1-2-3 3.0, Ashton-Tate’s Full Impact, and Excel 2.1. Guests include Gary Kildall, Jan Lewis, and Jared Taylor of PC Magazine. Originally broadcast in 1988.

Author(s): PBS – Computer Chronicles

Related: https://en.wikipedia.org/wiki/Computer_Chronicles

Publication Date: 1988

Publication Site: PBS at archive.org