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.
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
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.
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
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)
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 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.
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.
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.”
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.
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.