<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Korean langauge has same error like Hannie, Pierre. Waiting for next week!</span></div><div></div><div> </div><div><span style="background-color:transparent;line-height:1.22;">Johnny Kim</span><br></div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Pierre Slamich <pierre.slamich@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Hannie Dumoleyn <lafeber-dumoleyn2@zonnet.nl> <br><b><span style="font-weight: bold;">Cc:</span></b> Ubuntu Translators <ubuntu-translators@lists.ubuntu.com> <br> <b><span style="font-weight:
bold;">Sent:</span></b> Wednesday, June 12, 2013 6:09 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: New Little Ubuntu Stats Tool<br> </font> </div> <div class="y_msg_container"><br>
<meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv819067785"><div dir="ltr">I have found a more efficient way to compute stats. You'll all have the first release for your team next tuesday, with week on week figures. For now on, don't bother following the steps in my previous message.<br>
<div class="yiv819067785gmail_extra"><br clear="all"><div>Pierre<br><a rel="nofollow" ymailto="mailto:pierre.slamich@gmail.com" target="_blank" href="mailto:pierre.slamich@gmail.com">pierre.slamich@gmail.com</a><br></div><div><br></div><br><div class="yiv819067785gmail_quote">On Tue, Jun 11, 2013 at 7:31 PM, Pierre Slamich <span dir="ltr"><<a rel="nofollow" ymailto="mailto:pierre.slamich@gmail.com" target="_blank" href="mailto:pierre.slamich@gmail.com">pierre.slamich@gmail.com</a>></span> wrote:<br>
<blockquote class="yiv819067785gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">I've fixed that, but the script seems to be having issues fetching the proper figures for some languages (for instance for nl and de). I'm currently looking into that, to avoid having to fetch it manually.<span class="yiv819067785HOEnZb"><font color="#888888"><div>
<br></div></font></span><div><span class="yiv819067785HOEnZb"><font color="#888888">Pierre</font></span><div><div class="yiv819067785h5"><br><div class="yiv819067785gmail_extra"><br><div class="yiv819067785gmail_quote">On Tue, Jun 11, 2013 at 6:00 PM, Hannie Dumoleyn <span dir="ltr"><<a rel="nofollow" ymailto="mailto:lafeber-dumoleyn2@zonnet.nl" target="_blank" href="mailto:lafeber-dumoleyn2@zonnet.nl">lafeber-dumoleyn2@zonnet.nl</a>></span> wrote:<br>
<blockquote class="yiv819067785gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div>Hi Pierre,<br>
I tried to paste range A1:E8 on the new tab, nl-24-2013, but I am
only allowed to paste starting in A9. When I try A1 I get the
message that there is an overlap with protected cells.<br>
Hannie<br>
<br>
Op 11-06-13 15:12, Pierre Slamich schreef:<br>
</div><div><div>
<blockquote type="cite">
<div dir="ltr">One of the thing we need as team members is the
ability to send a weekly mail with the evolution of translation
for our language week on week, both for Ubuntu and the Package
Descriptions.
<div>I've created a little tool to do just that. What's more:
the way it's designed will enable us in the future to have
stats that go beyond week on week (think chart showing
progress over the year, or top 10 or most active teams) since
each week for each langage will be stored.</div>
<div><br>
</div>
<div>Each week, you'll have to go to this URL and do
the 10 following easy steps (takes one to two minutes for your
team each week) :</div>
<div>1. Go to the Team Weekly Stats tab</div>
<div>
2. Choose your country code in G1</div>
<div>3. Copy the A1:E8 range</div>
<div>4. Create a new tab with the name given in I1</div>
<div>5. Paste the A1:E8 range as values in the new tab
(starting in A1)</div>
<div>6. Go to the WoW tab</div>
<div>7. Select your Country Code</div>
<div>8. Get your WoW changes</div>
<div>9. Make a screenshot of the tab Team Weekly Stats
and WoW changes</div>
<div>10. Send them to your mailing list</div>
<div><br>
</div>
<div><a rel="nofollow" target="_blank" href="https://docs.google.com/spreadsheet/ccc?key=0AmZ-7cB-sMWOdEFEUjMwQS1tZ0dHRlF0VHNvRFJtOXc&usp=sharing">https://docs.google.com/spreadsheet/ccc?key=0AmZ-7cB-sMWOdEFEUjMwQS1tZ0dHRlF0VHNvRFJtOXc&usp=sharing</a><br>
</div>
<div><br>
</div>
<div>If you're willing to help extend this report for
new metrics and insights, help is welcome.</div>
<div><br>
</div>
<div><br>
</div>
<div>Pierre</div>
<div><br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div></div></div></div></div>
</blockquote></div><br></div></div>
</div><meta http-equiv="x-dns-prefetch-control" content="on"><br>-- <br>ubuntu-translators mailing list<br><a ymailto="mailto:ubuntu-translators@lists.ubuntu.com" href="mailto:ubuntu-translators@lists.ubuntu.com">ubuntu-translators@lists.ubuntu.com</a><br><a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-translators" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-translators</a><br><br><br></div> </div> </div> </div></body></html>