Exporting Results to Excel with a .cut file

[Leonid Spektor]

Sabrina,

	There is no way to have the output of +d option presented in Excel format. The Excel spreadsheet is two dimensional with columns for words and rows for number of times that word is used by each speaker, i.e. one speaker per row. The +d option creates a three dimensional output with words, number of times that word is used and the line numbers each word is located on in a file. The only way to fit all of this into Excel output is to have each cell, which is an intersection of each word and speaker's row, consist of the number of times that word was used by that speaker along with all the line numbers that word occurs on. Then each cell will be very crowded with lots of text.

	If, however, I misunderstood your question and you do not want to get +d option's output, then to create basic Excel output you would type command:

freq +d2 +s at file.cut @

or

freq +d3 +s at file.cut @


Leonid.

> On Apr 26, 2019, at 18:52, Sabrina Huang <sabhuang at bu.edu> wrote:
> 
> Hi Leonid,
> 
> I am trying to do freq +d +s at file.cut @
> 
> Thanks!
> 
> Best,
> Sabrina
> 
> On Friday, April 26, 2019 at 5:03:25 PM UTC-4, Leonid Spektor wrote:
> The short answer is maybe. For a more precise answer please specify whether you are analyzing the .cut file itself or using it as include file with +s... at file.cut <javascript:> option. Also, please say which CLAN command you are trying to get Excel output from. Not all CLAN commands are capable of creating Excel output.
> 
> 
> Leonid.
> 
>> On Apr 26, 2019, at 16:13, Sabrina Huang <sabh... at bu.edu <javascript:>> wrote:
>> 
>> Has anyone has successfully exported results to excel when using a .cut file?
>> 
>> -- 
>> You received this message because you are subscribed to the Google Groups "chibolts" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to chib... at googlegroups.com <javascript:>.
>> To post to this group, send email to chib... at googlegroups.com <javascript:>.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/9deeee4e-e572-41af-87ac-981ab9ce7a8e%40googlegroups.com <https://groups.google.com/d/msgid/chibolts/9deeee4e-e572-41af-87ac-981ab9ce7a8e%40googlegroups.com?utm_medium=email&utm_source=footer>.
>> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups "chibolts" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com <mailto:chibolts+unsubscribe at googlegroups.com>.
> To post to this group, send email to chibolts at googlegroups.com <mailto:chibolts at googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/c6f38ac0-cfff-4621-80b1-766cded010a5%40googlegroups.com <https://groups.google.com/d/msgid/chibolts/c6f38ac0-cfff-4621-80b1-766cded010a5%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com.
To post to this group, send email to chibolts at googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/A61C2BD7-E74F-48F5-9F79-FDA0CF9BF941%40andrew.cmu.edu.
For more options, visit https://groups.google.com/d/optout.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20190426/30b7f6ba/attachment.htm>