On Thu, Jan 3, 2013 at 1:30 PM, Drew Jensen <drewjensen.in...@gmail.com> wrote: > Right - I've taken the csv export, sucked into Calc, removed the > author/location columns completely, saved as ODS and imported that into > Google Docs. > Also added a column which subtracts, minus votes, and so yes getting a > single question ranking is trivial. >
Google Moderator does that automatically. That is part of their popularity ranking. They might take some other factors into account, such as how recently a question was asked. An older question had more time to get up votes, so some normalization seems desirable. For purposes of the blog post I'm using the Google ordering rather than devising my own metric. > Any reason, now that the author name/location is excised, not to share this > raw data for reading. I was about to include the URL here, thought I'd ask > to be sure no one minds. > We had the URL on the front page of our website for weeks. So it is hardly a state secret. I'll add a link to the blog post as well. -Rob > //drew > > > On Thu, Jan 3, 2013 at 1:25 PM, Rob Weir <robw...@apache.org> wrote: > >> On Thu, Jan 3, 2013 at 1:13 PM, Drew Jensen <drewjensen.in...@gmail.com> >> wrote: >> > Hey Rob, >> > >> > Looking at the blog - I read it that the question abut LibO and AOO is >> the >> > number one asked question, is that what it say? >> > >> > I'm looking at the google site and sorting by popularity under general >> > questions and get: >> > "Most of the times I deal with middle eastern languages. when I open a >> > DOCX, DOC or PPTX, PPT file, the text changes from RTL to LTR and vice >> > versa. no matter the file is in middle eastern language or latin. please >> > fix it." >> > >> >> You are looking at the wrong Google Moderator session. Try this one: >> http://www.google.com/moderator/#16/e=2033e8 >> >> > So, I just downloaded the stats as a csv file, don't see yet how to get >> the >> > top questions by vote, haven't really looked yet..by any chance to you >> > already have this in a neat SS that you could share, >> > >> >> You should be able to export to a CSV file if you find that more >> convenient. But the default sort order is by popularity, so picking >> out the top questions is trivial, once you are looking at the right >> page. >> >> -Rob >> >> >> > Thanks, >> > >> > Drew >> > >> > >> > On Thu, Jan 3, 2013 at 12:42 PM, Rory O'Farrell <ofarr...@iol.ie> wrote: >> > >> >> On Thu, 3 Jan 2013 11:57:11 -0500 >> >> Rob Weir <robw...@apache.org> wrote: >> >> >> >> <snip> >> >> >> >> > OK. See if the revised answer is good. >> >> >> >> Revised text is very good. >> >> >> >> >> >> <snip >> >> > >> >> > Is there anything in the current text that suggests blame? >> >> >> >> No, Rob, there is not, nor was there; I'm sorry if it was picked up so. >> >> My comment was intended as general policy that we should not attribute >> >> blame in any direction; I think we are all well aware how any such >> might be >> >> picked up by pro-active supporters of other office suites and a >> seemingly >> >> innocent statement of fact escalated into a vicious slanging match, with >> >> increasing ill-feeling on both sides. If the AOO project is to proceed >> >> (and hopefully, heal historic breaches) I think we all need to be >> careful >> >> to avoid adverse criticism of others involved in another but similar >> >> project. >> >> >> >> >> >> -- >> >> Rory O'Farrell <ofarr...@iol.ie> >> >> >>
