Study Recommends Gnumeric Over MS Excel

← Back to Stories (view on slashdot.org)

Study Recommends Gnumeric Over MS Excel

Posted by timothy on Monday February 23, 2004 @12:47AM from the me-too dept.

Jody Goldberg writes "A recent study of analytic quality, and responsiveness to problems strongly preferred Gnumeric in place of MS Excel. With new problems popping up in Office XP the case for spreadsheet users to migrate is only getting stronger. In some related Gnumeric quickies, a new stable version 1.2.6 was released, and Open has done an interview with the Maintainer."

17 of 86 comments (clear)

Min score:

Reason:

Sort:

Gnumeric 0wns by albalbo · 2004-02-23 00:59 · Score: 3, Interesting

In a recent interview, Jody said a W32 port was the priority. I think that could actually start pushing it over the top and make some real headway, I can see why it would be a priority.

--
"Elmo knows where you live!" - The Simpsons
Gnumeric's RND was *too* random by wowbagger · 2004-02-23 01:08 · Score: 5, Interesting

I love that one of the "failings" of Gnumeric was that the random number generator function RND was *too* random - Gnumeric uses the /dev/urandom device that generates random numbers from noise sources in the system (noise diodes, interrupt events, user input, etc.) rather than using a psuedo-random number generator with a predictable sequence.

True, there are times it is nice to have a "random" number generator that you can re-run for testing, but having a really random number generator is better for a host of problems.

--
www.eFax.com are spammers
I use excel all day by HMA2000 · 2004-02-23 01:11 · Score: 5, Interesting

I use excel at work all day and I have to say that no Open source solution comes close to providing what I expect a spreadsheet to do.

The idea that one should switch from excel to an open source solution because of a small set of statistics problems cannot be properly solved by excel seems a bit like throwing the baby out with the bath water. (unless you do nothing but statistical modelling all day)
1. Re:I use excel all day by perrinkog · 2004-02-23 01:18 · Score: 2, Interesting
  
  I'm in the same boat.
  
  None of the open source alternatives can do what I need - VBA. That alone shoots down anything non MS (afaik).
  
  --
  (Karma = auto -1)
2. Re:I use excel all day by nempo · 2004-02-23 01:26 · Score: 2, Interesting
  
  May I ask when the last time that you used an open source alternative was ?
  
  --
  --- No, english is not my mother tongue.
3. Re:I use excel all day by Trelane · 2004-02-23 02:34 · Score: 3, Interesting
  
  IIRC, Gnumeric doesn't do PivotTables(Excel)/DataPilot(OOo/SO). And the pie charts don't have labels (yet; being actively worked on).
  
  That said, it's great for 90% of what people want to do, and it gets the answers right.
  
  --
  
  --
  Given enough personal experience, all stereotypes are shallow.
4. Re:I use excel all day by blenderking · 2004-02-23 02:51 · Score: 4, Interesting
  
  That sounds great, but I live in a world of a locked down PC controlled by my IT division. I'm a power user in Excel, using pivot tables, mild VBA, mostly for automation between linked files, and in general using the 80% of the features most people don't use at all.
  
  True - VBA shouldn't be used for extremely complex items, but for my use, and other power uses - it's tremendous in it's automation abilities.
  
  --
  blenderking.com over 50,000 blenders can't be wrong
5. Re:I use excel all day by kannibal_klown · 2004-02-23 04:42 · Score: 5, Interesting
  
  "If you are using VBA in your spread sheet you need to move to a better solution - a dbms and a decent programming language. You are doing the equivilant of using a table knife for a screwdriver."
  
  However, you're suggesting we use a bulldozer when a shovel will work just fine.
  
  I work for a Pharmaceutical company as a software developer. Our scientists use Excel spreadsheets as reports; they enter in some raw data (or it's streamed in from an external program) and a combination of VBA and Excel formulas do the rest. These spreadhseets summarize data, predict flows, highlite trouble data, etc.
  
  THEN, in some cases (at least those that are needed), we have the ability to export the data stored in the Excel spreadsheets into Oracle tables.
  
  The spreadsheet acts as an intermediary for the scientists. It gives them something visual. They can modify things themselves, look at graphs for select data, etc. In some cases, they've even written their own VBA code to perform certain tasks. It's a horrible language, but simple enough for someone to pick up.
  
  Try writing software to allow them to do all of this, and to work with about 150 different macros that were written in the past. A biologist is not going to try to learn C++ or Java, because it's too time consuming and overkill for what they need. And any application, as simple as you make it, will not be as customizable and visual as Excel. You'd be robbing them of that important aspect.
  
  Sure, VBA is a pain in the ass; I wish it would go away forever. But it's made its niche; it allows the non-computer-savvy to do complex things. Anything better would be overkill and would reduce functionality.
Re:3.1 StRd by sir99 · 2004-02-23 01:40 · Score: 2, Interesting

It looks like Gnumeric improved or stayed the same on every data point except Pidigits, Numacc2, and Origin1 (whatever those are). Note that the LRE is the negative of the log of a value less than one, so a larger LRE means a smaller relative error. It's just the number of digits that agree with the correct answer. Really bad values would even have a negative LRE.

--
The ocean parts and the meteors come down
Laid out in amber, baby.
In defence of MS people by Anonymous+Brave+Guy · 2004-02-23 02:00 · Score: 3, Interesting

I've e-mailed a well-informed and helpful Microsoft developer, whom I first encountered on this very forum, on several occasions. I'm told a number of bug reports have been filed against the application in question as a result of my e-mails, and some of the things I've mentioned to him have certainly been fixed in a later version of the product.

Some people at Microsoft do listen, you just have to make a bit of an effort to find them. Curiously, a comment from the developer in question was that the dev teams love direct contact with customers prepared to give them helpful information about bugs or feature requests, they just wish the PR people would stop getting in the way. :-)

--
If you disagree, post your argument. (-1, Overrated) isn't your personal censorship tool for views you don't like.
1. Re:In defence of MS people by Spoing · 2004-02-23 04:51 · Score: 4, Interesting
  Some people at Microsoft do listen, you just have to make a bit of an effort to find them. Curiously, a comment from the developer in question was that the dev teams love direct contact with customers prepared to give them helpful information about bugs or feature requests, they just wish the PR people would stop getting in the way. :-)
  
  ...a perfect example between the difference in OSS and closed source.
  I've worked both sides of the fence, and realize the differences. There are base motivations that drive each to do things differently. Still, I was stunned when I asked Theodore Tso a question in email a few years back, and he not only responded quickly but even sent a patch for me to try out!
  --
  A firewall can not protect you from yourself. Turn off what you do not need. Do not use the firewall to do your work.
Re:Not really the battle by Anonymous+Brave+Guy · 2004-02-23 02:05 · Score: 4, Interesting

If I weren't posting on this thread, I'd mod that up as Insightful.

Advocates of new software, particularly OSS, often seem to forget that market share counts for a huge amount. Some studies we looked at back when I was in academia suggested that you need the "10x factor" to force a switch from an established product: your alternative must provide 10x the perceived benefits, or be 1/10 the price. That's a very big barrier to entry, and having a product that's only just become a challenger on technical merit and reliability is nowhere near it. (It's a good start, though!)

--
If you disagree, post your argument. (-1, Overrated) isn't your personal censorship tool for views you don't like.
Finally, some sense! by redelm · 2004-02-23 02:45 · Score: 4, Interesting

I've been using spreadsheets for over 20 years, since Lotus-1-2-3 ver1A on a 128 KB (sic) 8088. I think MS-Excel is unsuitable for any serious use. Aside from ease-of-use issues (regression and other stats not easily accessible) there seems to be serious defects in the core calculation engine.
I've seen spreadsheets where MS-Excel would miscalculate results by 20%. MS-Excel also has enormous problems handling circular spreadsheets. Both are probably related to defects in the order-of-calculation algorithm.
1. Re:Finally, some sense! by mschaef · 2004-02-23 04:40 · Score: 4, Interesting
  
  Excel also has (had? this might be fixed in 2003) some problems with things like standard deviations, etc. Run a standard deviation of 666666666123, 666666666246, and 666666666369, and you won't get the expected value of 123. Rather, you'll get 0. The high absolute values of the three numbers causes rounding problems by pushing significant bits out of the mantissa of IEEE numbers.
  
  Despite the fact that this has an easy fix (mean center the data before computing the deviation), Excel has had this problem for years.
Re:Not really the battle by file-exists-p · 2004-02-23 03:45 · Score: 2, Interesting

Doing correct computations seems to me to be a huge benefit.

If I had to use MS-Excel to manipulate serious figures, for instance huge budgets, I wonder how well I would sleep. And if I had people under my responsability who manipulate serious numbers, I would ask them to prefere accuracy to spectacular pie-charts. Am I that weird ?

By the way, if your business goes into troubles because of MS-Excel bugs which have been well known for years, can you sue MS ? Of course, the EULA tells you you can't, but in the real world?

--
Go Debian!
Stupid Rant by j-turkey · 2004-02-23 03:55 · Score: 4, Interesting

I didn't read all of the linked article -- so whatever...however, I will say this: Anything that makes Microsoft Office look bad and (insert cheaper solution here) look better, I like.

For a $1000 computer, I pay ~$400 per license for MS Office Professional -- that's 40% of the cost of the computer. If I could convince management and our user base, I'd change to anything else because anything else would be cheaper (Star Office, Lotus Smart Suite, OpenOffice, whatever). I checked out Open Office with one of our accounting guys, and it worked just fine with all of his macros. Peace of mind against FUD just isn't worth that much. MS Office is a fine product, just not worth the price. If there was anything with a remotely competitive amount of market share, I'm sure that MS would drop their prices to stay competitive.

--

-Turkey
Solver:? by rangek · 2004-02-23 09:52 · Score: 4, Interesting

The only thing I use Excel for is Solver. Solver turns Excel into the worlds easiest to use linear/non-linear optimizer for ANY function you can put in a spreadsheet. I use Gnumeric a lot, but I always have to go back to Excel for Solver...