Thought that I mastered Excel... 2

[Skogsgurra]

My spreadsheets are usually small and easily handled. Copying a cell down a column is quick and easy, just mark the cell, put cursor on lower right corner and drag down. Nothing to it.

But, I now have what I thought impossible in Excel, a sheet with 12 columns and 195729 rows of data. The 'drag corner down the column' method is very awkward. And I cannot find any other way to do it. Surely, there is another way - but how?

Signed
Tired index finger

Gunnar Englund

http://www.gke.org

--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...

 

[IRstuff]

The number of rows must have been changed in a version post-2000.

TTFN

FAQ731-376

 

[KiwiMace]

2007 brought the ribbon, a 1048576 row x 16224 column playing field (annoyingly just shy of 30 sec samples over a year) and the awesomely more compact open office XML file format.

 

[zappedagain]

FWIW, around here we use a program called Origin instead of Excel when we are processing that much data. We do that often.

John D

 

[Skogsgurra]

I have to stick with something that my customer has available. So I am limited to Excel and Matlab. Open Office wold probably work just as well. But this particular customer doesn't think it is any good if it doesn't cost.

Gunnar Englund

http://www.gke.org

--------------------------------------
100 % recycled posting: Electrons, ideas, finger-tips have been used over and over again...

 

[IDS]

If you need more than 64,000 rows Open Office won't do it (not without fiddling with the source code and re-compiling anyway).

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[jmw]

Purely out of curiosity, does the latest Excel allow scales for each data series?

JMW

http://www.ViscoAnalyser.com

 

[HgTX]

I was going to suggest Matlab; I really liked it for large swaths of data back when I didn't have to pay for the software.

Hg

Eng-Tips policies: faq731-376

 

[IDS]

jmw - I'm not sure what you mean. You can plot selected data sets on a secondary Y axis, and also use a secondary X axis (but only if you have already selected a secondary Y axis).

The procedure is far from obvious, but it's reasonably well described in the help.

http://office.microsoft.com/en-au/excel/HP012341651033.aspx#SecondaryVerticalAxis

If that isn't what you meant, please let us know.



Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[GregLocock]

HgTX - try Octave. Stable, free, very matlab like. It isn't quite as fast and lacks alot of the add-ons and toolboxes, but for basic number crunching it is fine. I develop most of my data handling and fft analysis at home using octave and then take it in to work and run it in matlab.



Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376

http://eng-tips.com/market.cfm?

 

[IRstuff]

I assume that jmw was asking about 5 different scales for 5 different data series. Certain programs can do that; Excel is not one of them.

TTFN

FAQ731-376

 

[IDS]

IRstuff - I'm sure it could be done in Excel (with a bit of time and effort), but I'm not sure why you'd want to.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[IRstuff]

Don't know why myself, but I've seen in done in published articles


TTFN

FAQ731-376

 

[electricpete]

Attached is an excel file I created to "work around" the limitation on scales.

Each plot can be "normalized" by dividing by a scale factor (row 29). The scale factor is displayed in the legend. The plot goes from –1 to 1 for all variables

There is also some features built in for easy browsing of a large pile of data... time axis can be changed easily by typing in the green cells "tmin" and "tmax".

http://home.comcast.net/~electricpete/eng-tips/PlotInteractiveRev4.xls

=====================================
Eng-tips forums: The best place on the web for engineering discussions.