Exporting freq (Types, Tokens, TTR), MLU, D (Optimum) to Excel

[Toh An]

Dear Leonid,

Thank you for the prompt reply!

Let's say I have only coded English utterances with "[- eng] code, do I 
need to code all the Chinese utterances in the transcripts with [-zho] 
code? 

Also, on a word level, I have tagged English words that have occurred 
within Chinese utterances using @s:eng. Is there a formula that can be used 
to calculate only Mandarin words and exclude all English words from the 
calculations?

On Friday, November 29, 2019 at 2:54:36 PM UTC+8, Leonid Spektor wrote:
>
> Hi,
>
> For just one language, assuming you have coded Mandarin utterances with 
> "[- zho]" code, add option +s"[- zho]" to your command lines.
>
> For Excel output you can type command by itself in the Command window and 
> press return key, thenlook in Usage output for option(s) that "output in 
> SPREADSHEET format". MLU command uses +d option and VOCD uses +d3 option 
> for that result.
>
>
> Leonid. 
>
> On Nov 29, 2019, at 01:08, Toh An <pops... at gmail.com <javascript:>> wrote:
>
> Hi,
>
> I have some questions about exporting freq (Types, Tokens, TTR), MLU, 
> D(Optimum) to Excel.
>
> Firstly, for freq, I tried using this formula to export the results to 
> Excel but it gives me the freq counts of all languages rather than only one 
> of the two languages in the transcripts:
>  
> freq +d2 +t*CHI -t%mor at ID="*target_child*"
>
> How can I modify the above formula so that it exports the freq including 
> Type, Token, and TTR results of a specific language only such as Mandarin 
> instead of all languages? I have two languages - eng and zho in the CHAT 
> transcripts and would like to have only the freq results of Mandarin words.
>
> Secondly, how do I export MLU and D(Optimum) results of only Mandarin 
> language in bilingual CHAT transcripts to Excel?
>
> I tried modifying the formula for freq above to MLU and D(Optimum) but it 
> did not output the results to an Excel sheet just like it did for freq:
>
> mlu +d1 +t*CHI -t%mor at ID="*target_child*"
>
> vocd +d1 +t*CHI -t%mor at ID="*target_child*"
>
> How can I modify the above formulas so that (1) only Mandarin language 
> values are calculated and (2) the results of MLU and vocd can be exported 
> to an Excel sheet?
>
> Thank you.
>
> -- 
> 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 view this discussion on the web visit 
> https://groups.google.com/d/msgid/chibolts/92648405-9065-4694-9479-b1758b907c7b%40googlegroups.com 
> <https://groups.google.com/d/msgid/chibolts/92648405-9065-4694-9479-b1758b907c7b%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>

-- 
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 view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/081a9ce6-b201-4602-836f-152b55ba065c%40googlegroups.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20191128/6101cb1d/attachment.htm>