Recommended Resources
Cyberhaven.com Offshore havens, asset protection, global investing and other useful techniques.
The Year 2000 Bookshelf Books to help your evaluate the Y2K problems you face.

Gary North's Y2K Links and Forums - Mirror

Summary and Comments

(feel free to mail this page)


Category: 

Personal_Computers

Date: 

1997-10-03 17:01:09

Subject: 

93% Noncompliant (Pre-1997), Bad Spreadsheets

  Link:

http://archive.thestreet.com/970930/Companies/topstories/23868_9301997.html

Comment: 

Kark Feilder of Greenwich Mean Time is quoted in this article Iin THE STREET (Sept. 30).

* * * * * *

"The PC problem is horrendous," said Feilder. "We have conducted the largest independent testing of PC programs and hardware. We have tested the Basic Input/Output System, or BIOS, on over 500 types of PCs, and of those machines made before 1997, 93% failed the BIOS test. This is very real and will have a far-reaching effect." . . .

With a PC projecting on a screen, Feilder set up a simple spreadsheet calculating a 25-year mortgage with two different applications, the latest version of Corel's (COSFF:Nasdaq) Quattro Pro 6.0 and the latest version of Microsoft's Excel. Both calculated the loan dates incorrectly, showing that a 25-year mortgage starting on Dec. 2, 1993, would be completed in 25 years, while a mortgage starting Dec. 2, 1995, would end in "-75" years.

"I just met with an Australian bank and they told me that they run their currency trading operation on 30,000 Excel spreadsheets," said Feilder. "When they went through and did an analysis of what it would take to get them all fixed, they estimate that it will take 20 man-years to fix them."

Link: 

http://archive.thestreet.com/970930/Companies/topstories/23868_9301997.html

Return to Category: Personal_Computers

Return to Main Categories

Return to Home Page