- **NZ Computing**
(*http://www.velocityreviews.com/forums/f47-nz-computing.html*)

- - **Stopping at the end of an Excel spreadsheet**
(*http://www.velocityreviews.com/forums/t716822-stopping-at-the-end-of-an-excel-spreadsheet.html*)

Stopping at the end of an Excel spreadsheetWhen replicating Excel formulas in large spreadsheets, is there a way
of stopping at the end without creating thousands of extra rows? I'd like to stop at the end of the existing spreadsheet without creating an extra 5000 rows, then undershooting and overshooting a few times. |

Re: Stopping at the end of an Excel spreadsheetIn message <b1c7993b-9169-4060-
b2af-7fcb6907dc2b@z1g2000prc.googlegroups.com>, Matty F wrote: > When replicating Excel formulas in large spreadsheets ... If youâ€™re doing anything that large, you probably shouldnâ€™t be using a spreadsheet. |

Re: Stopping at the end of an Excel spreadsheetLawrence D'Oliveiro wrote:
> In message <b1c7993b-9169-4060- > b2af-7fcb6907dc2b@z1g2000prc.googlegroups.com>, Matty F wrote: > >> When replicating Excel formulas in large spreadsheets ... > > If youâ€™re doing anything that large, you probably shouldnâ€™t be using > a spreadsheet. > Another inanity from Lawrence. Whether or not you use a spreadsheet or a database depends more on the use you want to put it to, not the size. Spreadsheets are good if you want to do lots of ad hoc searches and filtering. Databases are more suited to a standard set of searches and filters that can be programmed. It's the standard knee-jerk reaction if you have lots of data to put it into a database, but if the data is more suited to a spreadsheet you will find yourself writing stuff to emulate a spreadsheets abilities and that is a waste of everyones' time and effort. Cheers, Cliff -- The ends justifies the means - NiccolÃ² di Bernardo dei Machiavelli. The end excuses any evil - Sophocles |

Re: Stopping at the end of an Excel spreadsheetOn Mar 6, 2:38 pm, Enkidu <enkidu....@com.cliffp.com> wrote:
> Lawrence D'Oliveiro wrote: > > In message <b1c7993b-9169-4060- > > b2af-7fcb6907d...@z1g2000prc.googlegroups.com>, Matty F wrote: > > >> When replicating Excel formulas in large spreadsheets ... > > > If you’re doing anything that large, you probably shouldn’t be using > > a spreadsheet. > > Another inanity from Lawrence. Whether or not you use a spreadsheet or a > database depends more on the use you want to put it to, not the size. > > Spreadsheets are good if you want to do lots of ad hoc searches and > filtering. Databases are more suited to a standard set of searches and > filters that can be programmed. > > It's the standard knee-jerk reaction if you have lots of data to put it > into a database, but if the data is more suited to a spreadsheet you > will find yourself writing stuff to emulate a spreadsheets abilities and > that is a waste of everyones' time and effort. I have tens of thousands of lines of climate data and it's a real mess. There is missing data, and overlapping data. I need to run tests to highlight the errors, and put them in a good form to plot and analyse. |

Re: Stopping at the end of an Excel spreadsheetIn message <42c0cc70-c164-406a-b128-61d73bf19eef@b9g2000pri.googlegroups.com>,
Matty F wrote: > I have tens of thousands of lines of climate data and it's a real > mess. There is missing data, and overlapping data. I need to run tests > to highlight the errors, and put them in a good form to plot and > analyse. Sounds like you need a maths or statistics package. Have you looked at R or Sage? |

Re: Stopping at the end of an Excel spreadsheetLawrence D'Oliveiro wrote:
> In message > <42c0cc70-c164-406a-b128-61d73bf19eef@b9g2000pri.googlegroups.com>, > Matty F wrote: > >> I have tens of thousands of lines of climate data and it's a real >> mess. There is missing data, and overlapping data. I need to run >> tests to highlight the errors, and put them in a good form to plot >> and analyse. > > Sounds like you need a maths or statistics package. Have you looked > at R or Sage? > No, it sounds like he has a set of data from many heterogeneous sources. A stats package will not sort the gaps and overlaps. Cheers, Cliff -- The ends justifies the means - Niccolò di Bernardo dei Machiavelli. The end excuses any evil - Sophocles |

Re: Stopping at the end of an Excel spreadsheetIn message <hmtfcb$b2q$1@lust.ihug.co.nz>, Lawrence D'Oliveiro wrote:
> Have you looked at R or Sage? R <http://www.r-project.org/> Sage <http://sagemath.org/> Thereâ€™s also NumPy and SciPy, but I think theyâ€™re rolled into Sage. |

Re: Stopping at the end of an Excel spreadsheetOn Mar 7, 12:42 pm, Enkidu <enkidu....@com.cliffp.com> wrote:
> Lawrence D'Oliveiro wrote: > > In message > > <42c0cc70-c164-406a-b128-61d73bf19...@b9g2000pri.googlegroups.com>, > > Matty F wrote: > > >> I have tens of thousands of lines of climate data and it's a real > >> mess. There is missing data, and overlapping data. I need to run > >> tests to highlight the errors, and put them in a good form to plot > >> and analyse. > > > Sounds like you need a maths or statistics package. Have you looked > > at R or Sage? > > No, it sounds like he has a set of data from many heterogeneous sources. > A stats package will not sort the gaps and overlaps. Excel is doing fine except that I'd like it to slow down as it approaches the end of the spreadsheet. Surely a simple task for the programmers of it. |

All times are GMT. The time now is 11:50 PM. |

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.

SEO by vBSEO ©2010, Crawlability, Inc.