Skip to main content
Topic: Listening test diagrams (Read 4550 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Listening test diagrams

How are the listening test diagrams produced?
I understand them, but I am unable to find how to generate them in my spreadsheet.

Listening test diagrams

Reply #1
Quote
How are the listening test diagrams produced?
I understand them, but I am unable to find how to generate them in my spreadsheet.

ff123 and I use Excel.

You can check out the spreadsheet I used for the latest test here:
http://pessoal.onda.com.br/rjamorim/plots.zip

(please ignore the comments, they are from a former test)

Listening test diagrams

Reply #2
Thank you.
Unfortunately this is a good proof that Excel is still superior to OOo. It doesn't work at all here...

Listening test diagrams

Reply #3
Quote
Unfortunately this is a good proof that Excel is still superior to OOo.

its a proof that ms fileformats are way to proprietary, if you're talking about importing ^^

Listening test diagrams

Reply #4
Quote
its a proof that ms fileformats are way to proprietary, if you're talking about importing ^^

I think that regarding those graphs, the problem lies in functionnalities. I can not generate this kind of graph in OOo, even when starting with a native sheet.

Listening test diagrams

Reply #5
I think it is possible to make such a graph, though OO's graph editing tools make it difficult.

The real killer for me is that OO can't handle more than 32767 rows!  How lame is that?  At work I have to periodically make up inventory lists in spreadsheet format, and because we sell more than 33000 parts, I have to fire up a windows computer just for that purpose.
I am *expanding!*  It is so much *squishy* to *smell* you!  *Campers* are the best!  I have *anticipation* and then what?  Better parties in *the middle* for sure.
http://www.phong.org/

Listening test diagrams

Reply #6
Quote
The real killer for me is that OO can't handle more than 32767 rows!  How lame is that?  At work I have to periodically make up inventory lists in spreadsheet format, and because we sell more than 33000 parts, I have to fire up a windows computer just for that purpose.

Gnumeric will handle 65536 rows and is, IMHO, a better spreadsheet than OO.  But, as much as it pains me to say it, nothing comes close to Excel in overall usability.

--John

Listening test diagrams

Reply #7
It is fairly easy to generate these types of plots using gnuplot

ff123

Listening test diagrams

Reply #8
Quote
Gnumeric will handle 65536 rows and is, IMHO, a better spreadsheet than OO.  But, as much as it pains me to say it, nothing comes close to Excel in overall usability.

Shoot, I don't need to do anything fancy, just tally up a few basic things (in 33-36k rows)...  Does Gnumeric handle xls files?
I am *expanding!*  It is so much *squishy* to *smell* you!  *Campers* are the best!  I have *anticipation* and then what?  Better parties in *the middle* for sure.
http://www.phong.org/

Listening test diagrams

Reply #9
Quote
Shoot, I don't need to do anything fancy, just tally up a few basic things (in 33-36k rows)...  Does Gnumeric handle xls files?

Sure does.  Reads 95/97/2000 (I think XP might be a problem); writes 95 only.

Excel format is definitely the lingua franca of spreadsheets.  I always find it ironic when I have to use xls format to exchange data between Gnumeric and Open Office.

--John

 
SimplePortal 1.0.0 RC1 © 2008-2019