Thursday, June 5th, 2014 / by ExcelHelp
Thomas Piketty, a French economist, has become somewhat of a minor celebrity in recent weeks following the release of his best selling book “Capital in the Twenty-First Century.” In the book, he examines 200 years of economic policy and makes the case for higher taxes.
Over the last few weeks, however, some of his numbers have been called into question because of poorly constructed spreadsheets. A recent article from Breaking Views, a financial insight blog, makes the case that whenever you are creating such a data heavy report, there are going to be some errors.
According to Richard Beales, the author of the piece, Piketty deserves credit for making background data available. However, the sloppy way that the Excel spreadsheets were put together has become the basis for the criticism of the book.
“The Frenchman’s spreadsheets would, in places, embarrass the greenest investment-banking analyst,” Beales wrote. “Exhibit A is his habit of hard-coding adjustments into Excel formulas.”
He goes on to examine several different areas where the formulas of the spreadsheets were incorrectly used. Many spreadsheet experts noticed that individual inputs were not shown, making it more complicated to follow logic and identify potential issues. However, Beales concludes that the problems found in the report are not enough to undermine the main points that the report is making.
While few businesses are putting out projects the size of Piketty’s book, the data that is placed in their spreadsheets is still important. With the help of an Excel consultant, any businesses will be able to ensue their spreadsheets are as effective as possible.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.