Pages

 

The importance of being clear

0 comments
A formatting fubar involving an Excel spreadsheet has left Barclays Capital with contracts involving collapsed investment bank Lehman Brothers than it never meant to acquire.

Working to a tight deadline, a junior law associate at Cleary Gottlieb Steen & Hamilton LLP converted an Excel file into a PDF format document. The doc was to be posted on a bankruptcy court's website before a midnight purchase offer deadline on 18 September, just four hours after Barclays sent the spreadsheet to the lawyers. The Excel file contained 1,000 rows of data and 24,000 cells.

Some of these details on various trading contracts were marked as hidden because they were not intended to form part of Barclays' proposed deal. However, this "hidden" distinction was ignored during the reformatting process so that Barclays ended up offering to take on an additional 179 contracts as part of its bankruptcy buyout deal, Finextra reports.


The Register has the full story. As Merv has always warned, 'horrible things happen when you hide cells in excel'.

I see this as a manifestation of a wider lack of education on the importance of communicating information efficiently. The Spartans, Tufte, Strunk and White, the Economist, Picasso and numerous econometricians have done a lot to improve things, but management-speak, TV advertising and other such phenomena show we still have a long way to go.

0 comments:

Post a Comment

  • Greenspan's Cult of Personality... Review topics and articles of economics: Alan Greenspan was a legend in his time and there was no shortage of praise for him back then. For example, who can forget Bob Woodow's 2000 book Maestro: Greenspan's...
  • Yes Tyler, Low Interest Rates Matte... Tyler Cowen is wondering whether the Fed's low interest rates in the early-to-mid 2000s really were that important to the credit and housing boom of the early-to-mid...
  • The Eurozone Crisis: Deja Vu... Review topics and articles of economics: Randal Forsyth sees similarities between the current unfolding of the Eurozone crisis and that of the U.S. financial crisis a few years back:Just as the problem on this...
  • Charles Plosser and the Burden of F... The Economist's Free Exchange blog is shocked to hear this from Federal Reserve Bank of Philadelphia President Charles Plosser:"Since expectations play an important role...
  • Arnold Kling and Expected Inflation... Review topics and articles of economics: What do we know about expected inflation? According to Arnold Kling not much if we look to financial markets:I'm also not convinced that we can read expected inflation...
  • A Paper on Stabilizing Nominal Spen... Given the recent discussion on stabilizing nominal spending as a policy goal I found this article by Evan F. Koenig of the Dallas Fed to be interesting: The article...
  • Why The Low Interest Rates Mattered... Review topics and articles of economics: This is the second of two posts detailing why the Fed's low interest rate policies in the early-to-mid 2000s was one of the more important contributors to the credit and...
  • Why The Low Interest Rates Mattered... This is the first of a two-part follow up to my previous post, where I argued that the Fed's low interest rate policy was a key contributor to the credit and housing...
  • The Stance of Monetary Policy Via t... Review topics and articles of economics: There has been some interesting conversations on the stance of monetary policy in the past few days between Arnold Kling, Scott Sumner, and Josh Hendrickson. Part of...
  • Scott Sumner's New Best Friend:... Joseph Gagnon is calling for $6 trillion more in global monetary easing. This should not be too hard to implement since the Fed is a monetary superpower.Update: The...
 
Review topics and articles of economics © 2011 The importance of being clear