Renee Howdeshell
Renee Howdeshell is a founding member of Fulcrum Inquiry, an accounting, finance and economic consulting firm that performs damage analyses for commercial litigation, forensic accountings, royalty & distribution audits, financial investigations, and business valuations. Ms. Howdeshell holds a degree in Finance and Marketing from the University of Virginia's McIntire School of Commerce and is a Certified Public Accountant (CPA) and a Certified Fraud Examiner (CFE). She has testified as an expert witness in federal court, CA state court and arbitration regarding the results of her work. She can be reached at (213) 787-4112 and her resume is available at www.fulcrum.com.
Permanent link to this article: https://betweenthenumbers.net/2016/08/excel-default-settings-can-cause-significant-analysis-errors/
Sponsor
Between the Numbers is sponsored by Fulcrum Inquiry. Fulcrum Inquiry is a consulting firm whose services include calculation of litigation damages and related expert testimony, forensic accounting, financial investigations, economic analysis, and business appraisals.
Thought for the Day
Denis Waitley (1933 - )
Motivational speaker & best-selling author
Categories
- Appraisal/Valuation (44)
- Bankruptcy (7)
- Capital Markets (16)
- Class Action (14)
- Commentary (61)
- Computer Forensics (4)
- Damages (116)
- Discovery (7)
- Disgorgement (8)
- Economic Damages (36)
- Economics (37)
- Employer Discrimination (6)
- Environment (1)
- Expert Witnesses (31)
- Failure to promote (4)
- Financial regulation (28)
- Financial Reporting (56)
- Forensic Accounting (106)
- Fraud (63)
- Health Care (9)
- Intellectual Property (61)
- Internal Controls (2)
- Just for Fun (33)
- Lost Earnings (20)
- Medical malpractice (12)
- Personal Injury/Wrongful Death (23)
- Personal Investments (37)
- Ponzi Scheme (3)
- Product liability (9)
- Public Policy (58)
- Real Estate (8)
- Research and Polls (43)
- Statistics (46)
- Strategy (7)
- Taxes (61)
- Technology (37)
- Uncategorized (9)
- Valuation (8)
- Whistleblower Systems (56)
- Wrongful Termination (6)
Comments Policy
All postings (including those associated with Fulcrum Inquiry) are the opinions of their respective authors, and do not necessarily reflect positions of Fulcrum Inquiry.
Anyone is allowed to post comments on any article; however, comments appear only following review. Advertisements not pertaining to the blog subject, spam (bot generated) comments, foul language, ad-hominem attacks, and immature behavior will not be approved.
The Lawyers Say….
All posts are copyrighted by Fulcrum Inquiry® as of their publication date
The authors and publishers are not intending to render legal, accounting, tax, or other professional advice. No client relationship is established from making general information available on this site, or from your making a comment or transmitting an email message to us. None of the information on this site should be used as a substitute for consultation with competent advisors that are able to consider the application of any general information to your specific situation.
While we have attempted to ensure that information contained on this site is reliable, we are not responsible for any errors or omissions, or for the results obtained from the use of such information. No guarantee of completeness, accuracy, timeliness, or of the results obtained from the use of this information is provided.
Aug 29
Excel Default Settings Can Cause Significant Analysis Errors
August 29, 2016
A recent study published in the scientific journal Genome Biology describes a concerning error rate in genetic studies caused by default settings in the commonly used spreadsheet software Microsoft Excel. The default cell formatting option in Excel will inadvertently convert gene symbols to dates and floating-point numbers. Examples include:
Researchers Mark Ziemann, Yotam Eren and Assam El-Osta reviewed the supplementary files of genetics studies from 18 journals published between 2005 and 2015, finding that approximately 20% contained gene lists with such inappropriate gene name conversions. This occurs at increasing rates despite the fact that the problem was originally publicly reported in 2004. In other words, the scientific community has failed to learn from its mistakes in this regard. Linear-regression estimates show gene name errors in supplementary files have increased at an annual rate of 15 % over the past five years, growing much faster than the 3.8% increase in published papers per year. This comparative growth may occur because such lists are frequently re-used.
The solution requires foresight in changing the default options on each newly created spreadsheet rather than retroactive adjustment. Neither Excel, nor other spreadsheet software such as LibreOffice Calc or Apache OpenOffice Calc, allow one to reset the default to eliminate conversion. Once converted, a subsequent formatting change will not return the entry to its original text, as the underlying stored data has been permanently altered. Instead one can only troubleshoot by sorting the data, thereby bringing the re-formatted dates to the top of the column for re-entry. Surprisingly, the only spreadsheet software that does not suffer from this issue is Google Sheets, a free program.