> Well, I am going to type in ever value because the data sheets are of
> counts of insects that I identified, so I should be okay with
> accuracy...  I really just need something that allows for more than
> 256 columns as I have encounter over 256 species of insects in even
> small streams. ...

Oh, ugh, that sounds difficult and prone to entry errors.  You might be 
better off organizing in the 'long' format with 4-5 columns:
    siteID, subSiteID, species, count, comments

You can then reshape(), or use the reshape package, or even the 'pivot 
table' available in excel and other spreadcheats.

Glad you have an answer.  Enjoy your day.
cur
-- 
Curt Seeliger, Data Ranger
Raytheon Information Services - Contractor to ORD
seeliger.curt@epa.gov
541/754-4638


r-help-bounces@r-project.org wrote on 10/20/2008 06:01:43 PM:

> Well, I am going to type in ever value because the data sheets are of
> counts of insects that I identified, so I should be okay with
> accuracy...  I really just need something that allows for more than
> 256 columns as I have encounter over 256 species of insects in even
> small streams.  I think calc with it's 1000ish columns will do the
> trick... thanks everbody for your help.
> 
> On Mon, Oct 20, 2008 at 8:25 PM, Gabor Grothendieck
> <ggrothendieck@gmail.com> wrote:
> > There is a list of free spreadsheets with their row and column limits
> > at this link:
> > http://en.wikipedia.org/wiki/OpenOffice.org_Calc
> >
> > On Mon, Oct 20, 2008 at 3:13 PM, stephen sefick <ssefick@gmail.com> 
wrote:
> >> sorry excel 2003 with no immediate update in the future.
> >>
> >> On Mon, Oct 20, 2008 at 3:12 PM, Gabor Grothendieck
> >> <ggrothendieck@gmail.com> wrote:
> >>> You didn't say which version of Excel you are using but Excel 2007
> >>> allows 16,384 columns.
> >>>
> >>> On Mon, Oct 20, 2008 at 2:27 PM, stephen sefick <ssefick@gmail.com> 
wrote:
> >>>> I am wondering if there is a better alternative than Excel for data
> >>>> storage that does not require database knowledge (I will eventually
> >>>> have to learn this, but it is not on my immediate todo list).  I 
need
> >>>> something that is not limited to 256 columns... I don't need any of
> >>>> the built in functions in excel just a spreadsheet like program 
with
> >>>> cells that hold data in a data.frame format for a staging area 
before
> >>>> I get it into R.  Any help would be greatly appreciated.  This is 
not
> >>>> a direct r question, but all of you folks have more experience than 
I
> >>>> do and I am having a time finding what I need with google.
> >>>> thanks in advance
> >>>>
> >>>> --
> >>>> Stephen Sefick
> >>>> Research Scientist
> >>>> Southeastern Natural Sciences Academy
> >>>>
> >>>> Let's not spend our time and resources thinking about things that 
are
> >>>> so little or so large that all they really do for us is puff us up 
and
> >>>> make us feel like gods.  We are mammals, and have not exhausted the
> >>>> annoying little problems of being mammals.
> >>>>
> >>>>                                                                -K. 
Mullis
> >>>>
> >>>> ______________________________________________
> >>>> R-help@r-project.org mailing list
> >>>> https://stat.ethz.ch/mailman/listinfo/r-help
> >>>> PLEASE do read the posting guide http://www.R-project.
> org/posting-guide.html
> >>>> and provide commented, minimal, self-contained, reproducible code.
> >>>>
> >>>
> >>
> >>
> >>
> >> --
> >> Stephen Sefick
> >> Research Scientist
> >> Southeastern Natural Sciences Academy
> >>
> >> Let's not spend our time and resources thinking about things that are
> >> so little or so large that all they really do for us is puff us up 
and
> >> make us feel like gods.  We are mammals, and have not exhausted the
> >> annoying little problems of being mammals.
> >>
> >>                                                                -K. 
Mullis
> >>
> >
> 
> 
> 
> -- 
> Stephen Sefick
> Research Scientist
> Southeastern Natural Sciences Academy
> 
> Let's not spend our time and resources thinking about things that are
> so little or so large that all they really do for us is puff us up and
> make us feel like gods.  We are mammals, and have not exhausted the
> annoying little problems of being mammals.
> 
>                         -K. Mullis
> 
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]

