<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>If you have only two languages and you have coded only english utterances with "[- eng]", then you can use <font color="#ff2600" class="">-</font><span style="color: rgb(255, 38, 0);" class="">s"[- eng]" </span>option to get remaining Mandarin utterances/words. If you have more than one language in your transcripts, then you need to use <font color="#ff2600" class="">-</font><span style="color: rgb(255, 38, 0);" class="">s"[- ...]"</span> option for every language that you want to exclude.<div class=""><br class=""></div><div class="">To exclude words ending with <font color="#0433ff" class="">@s:eng</font> use <font color="#ff2600" class="">-s*@s:eng</font> option in addition to other options.</div><div class=""><div class=""><br class=""></div><div class=""><br class="">Leonid.
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On Nov 29, 2019, at 02:04, Toh An <<a href="mailto:popsune1@gmail.com" class="">popsune1@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Dear Leonid,<div class=""><br class=""></div><div class="">Thank you for the prompt reply!</div><div class=""><br class=""></div><div class="">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? </div><div class=""><br class=""></div><div class="">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?<br class=""><br class="">On Friday, November 29, 2019 at 2:54:36 PM UTC+8, Leonid Spektor wrote:<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><div style="word-wrap:break-word;line-break:after-white-space" class="">Hi,<div class=""><br class=""></div><div class=""><span style="white-space:pre" class=""> </span>For just one language, assuming you have coded Mandarin utterances with "[- zho]" code, add option <font color="#ff2600" class="">+s"[- zho]"</font> to your command lines.</div><div class=""><br class=""></div><div class="">For Excel output you can type command by itself in the Command window and press return key, then look in Usage output for option(s) that "<font color="#0433ff" class="">output in SPREADSHEET format</font>". MLU command uses <font color="#ff2600" class="">+d</font> option and VOCD uses <font color="#ff2600" class="">+d3 </font>option for that result.</div><div class=""><br class=""></div><div class=""><div class=""><br class="">Leonid.
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Nov 29, 2019, at 01:08, Toh An <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="lQ23pagSBwAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;" class="">pops...@gmail.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class="">Hi,<div class=""><br class=""></div><div class="">I have some questions about exporting freq (Types, Tokens, TTR), MLU, D(Optimum) to Excel.</div><div class=""><br class=""></div><div class="">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:</div><div class=""> </div><table border="0" cellpadding="0" cellspacing="0" width="533" style="border-collapse:collapse;width:400pt" class=""><tbody class=""><tr height="20" style="height:15.0pt" class="">
<td height="20" width="533" style="height:15.0pt;width:400pt" class="">freq +d2 +t*CHI
-t%mor at ID="*target_child*"<br class=""><br class="">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.<br class=""><br class="">Secondly, how do I export MLU and D(Optimum) results of only Mandarin language in bilingual CHAT transcripts to Excel?<br class=""><br class="">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:<br class=""><br class=""><table border="0" cellpadding="0" cellspacing="0" width="533" style="border-collapse:collapse;width:400pt" class=""><tbody class=""><tr height="20" style="height:15.0pt" class="">
<td height="20" width="533" style="height:15.0pt;width:400pt" class="">mlu +d1 +t*CHI
-t%mor at ID="*target_child*"<br class=""><br class="">vocd +d1 +t*CHI -t%mor at ID="*target_child*"<br class=""><br class="">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?<br class=""><br class="">Thank you.</td></tr></tbody></table></td></tr></tbody></table></div><div class=""><br class=""></div>
-- <br class="">
You received this message because you are subscribed to the Google Groups "chibolts" group.<br class="">
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="lQ23pagSBwAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;" class="">chib...@<wbr class="">googlegroups.com</a>.<br class="">
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/92648405-9065-4694-9479-b1758b907c7b%40googlegroups.com?utm_medium=email&utm_source=footer" target="_blank" rel="nofollow" onmousedown="this.href='https://groups.google.com/d/msgid/chibolts/92648405-9065-4694-9479-b1758b907c7b%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;" onclick="this.href='https://groups.google.com/d/msgid/chibolts/92648405-9065-4694-9479-b1758b907c7b%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;" class="">https://groups.google.com/d/<wbr class="">msgid/chibolts/92648405-9065-<wbr class="">4694-9479-b1758b907c7b%<wbr class="">40googlegroups.com</a>.<br class="">
</div></blockquote></div><br class=""></div></div></blockquote></div></div><div class=""><br class="webkit-block-placeholder"></div>
-- <br class="">
You received this message because you are subscribed to the Google Groups "chibolts" group.<br class="">
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:chibolts+unsubscribe@googlegroups.com" class="">chibolts+unsubscribe@googlegroups.com</a>.<br class="">
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/081a9ce6-b201-4602-836f-152b55ba065c%40googlegroups.com?utm_medium=email&utm_source=footer" class="">https://groups.google.com/d/msgid/chibolts/081a9ce6-b201-4602-836f-152b55ba065c%40googlegroups.com</a>.<br class="">
</div></blockquote></div><br class=""></div></body></html>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "chibolts" group.<br />
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:chibolts+unsubscribe@googlegroups.com">chibolts+unsubscribe@googlegroups.com</a>.<br />
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/93CEC3AF-B0EA-49F5-AFB8-6CFD2EE9D1F1%40andrew.cmu.edu?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/93CEC3AF-B0EA-49F5-AFB8-6CFD2EE9D1F1%40andrew.cmu.edu</a>.<br />