+d2 to columns not rows

Brian MacWhinney macw at cmu.edu
Mon Apr 23 14:18:22 UTC 2012


Dear Joyce,

    Here is what the Microsoft pages at msdn.microsoft.com say:

Starting in Excel 2007, the "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD). 

If you update your version of Excel, then having 16,384 columns would hopefully be enough.

-- Brian MacWhinney

On Apr 22, 2012, at 10:42 PM, Joyce Marzan wrote:

> Hi! 
> 
> am now integrating lexical data across CHAT files... want to come up with a "LEXICON x AGE" table extracted from 10-15 CHAT files... the "freq +d2 +t*CHI *.cha" does this beautifully, but it outputs the lexical items in columns. I am afraid I am using MS Excel 2002 which has a maximum of  256 columns, but 65536 rows... is there a way to get the lexical data in rows instead of columns? attached is the output file (kindly ignore other issues... i realize i need my team to fix our headers... :-)
> 
> Thank you!
> 
> Joyce
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups "chibolts" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/chibolts/-/ArYyefv1DgIJ.
> To post to this group, send email to chibolts at googlegroups.com.
> To unsubscribe from this group, send email to chibolts+unsubscribe at googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.
> <stat.frq.xls>

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To post to this group, send email to chibolts at googlegroups.com.
To unsubscribe from this group, send email to chibolts+unsubscribe at googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20120423/77c97e2b/attachment.html>


More information about the Chibolts mailing list