On 1/25/13 7:50 AM, Peter Junge wrote: > May I kindly ask to respect our large Chinese community?! Such political > suspicions are off topic here. > > All governments are hacking. The game is called 'Spy vs. Spy.'
+1, let us focus on our project Juergen > > Best regards, > Peter > > On 1/25/2013 6:57 AM, Kadal Amutham wrote: >> The map gives a good idea of down loads. Why Canada has more downloads >> than >> US? Why China is less than India? Software piracy may be more in China >> compared to India. Pirated software is also free like OpenOffice. Even >> hacking is sponsored by Chinese Government. They are called ethical >> hacking >> or patriotic hacking. Hacking of Indian sites by Chinese hackers will be >> considered as patriotic. >> >> With Warm Regards >> >> V.Kadal Amutham >> 919444360480 >> 914422396480 >> >> >> On 25 January 2013 08:35, Samer Mansour <[email protected]> wrote: >> >>> I'm a little stumped how to visualize this in a meaningful way. >>> >>> Here it is again with the latest data. This is the best visual I >>> think out >>> of the few I tried: >>> >>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/aoo-downloads-download-density >>> >>> >>> On Thu, Jan 24, 2013 at 10:28 AM, Rob Weir <[email protected]> wrote: >>> >>>> On Wed, Jan 23, 2013 at 7:16 PM, Kadal Amutham <[email protected]> >>>> wrote: >>>>> Dear Rob, >>>>> >>>>> For the internet population I used the data from the wiki since the >>> link >>>>> was already in the google spreadsheet. For the population details, I >>>> typed >>>>> population followed by the country name in the address bar of google >>> and >>>> in >>>>> most of the searches the result was from www.google.co.in/publicdata. >>> I >>>> do >>>>> not expect much difference between google data and wiki. You can >>>>> verify >>>> few >>>>> data and the difference may be in the last 3 digits. >>>>> >>>> >>>> I reviewed the data. Most of it looked fine. As you say, maybe in >>>> the last few digits. I only found a few things to fix. For example >>>> (and I didn't know this before) there are two Congo's now: Democratic >>>> Republic of the Congo and the Republic of the Congo. It looks like the >>>> data there was reversed. Little things like that. >>>> >>>> The top 30 countries, for downloading AOO, normalized by number of >>>> internet users in the country, are: >>>> >>>> 1. Monaco >>>> 2. Italy >>>> 3. France >>>> 4. San Marino >>>> 5. Luxembourg >>>> 6. Belgium >>>> 7. Estonia >>>> 8. Germany >>>> 9. Switzerland >>>> 10. Finland >>>> 11. Spain >>>> 12. Hong Kong >>>> 13. Austria >>>> 14. Netherlands >>>> 15. Canada >>>> 16. Belize >>>> 17. Czech Republic >>>> 18. Falkland Islands (Malvinas) >>>> 19. Faroe Islands >>>> 20. Malta >>>> 21. Singapore >>>> 22. Iceland >>>> 23. Taiwan >>>> 24. United Kingdom >>>> 25. United States >>>> 26. Uruguay >>>> 27. Hungary >>>> 28. New Zealand >>>> 29. Ireland >>>> 30. Liechtenstein >>>> >>>> I'm attaching the full spreadsheet. Hopefully Samer can put the >>>> updated figures on the ManEyes website. >>>> >>>> The countries at the bottom of the list, are some where we have >>>> opportunities for growth. For example, South Korea should improve >>>> once the Korean translation is released next week. >>>> >>>> -Rob >>>> >>>> >>>>> With Warm Regards >>>>> >>>>> V.Kadal Amutham >>>>> 919444360480 >>>>> 914422396480 >>>>> >>>>> >>>>> On 23 January 2013 23:58, Samer Mansour <[email protected]> wrote: >>>>> >>>>>> Some countries didn't get counted (not matched in the tool/didn't >>>> exist). >>>>>> Some cities got their own row, but the Map doesn't have a spot for >>>> them. ie >>>>>> Hong Kong and Singapore: >>>>>> Also I think some rows are gone, like "Europe (not specified)", it >>>>>> was >>>>>> there yesterday. >>>>>> >>>>>> Here are two more visualizations: >>>>>> >>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/apache-openoffice-downloads-vs-pop >>> >>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/apache-openoffice-downloads-vs-pop-2 >>> >>>>>> >>>>>> And the original: >>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/apache-openoffice-downloads-by-pop >>> >>>>>> >>>>>> I didn't have a design in mind in how we want to show this so I just >>>>>> plotted and mashed around with it like playdough. >>>>>> >>>>>> On Wed, Jan 23, 2013 at 12:37 PM, Rob Weir <[email protected]> >>> wrote: >>>>>> >>>>>>> On Wed, Jan 23, 2013 at 10:59 AM, Samer Mansour <[email protected] >>>> >>>>>>> wrote: >>>>>>>> Opps here it is: >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/apache-openoffice-downloads-by-pop >>> >>>>>>>> >>>>>>> >>>>>>> This is very nice. We might want to take out the "population" and >>>>>>> "internet users" and the two rank columns and just use the >>> "downloads >>>>>>> per 1k population" and "downloads per 1k internet users" columns. >>>>>>> >>>>>>> I found a few cut & paste errors in the spreadsheet, so it would be >>>>>>> good if we could have some reviewers double check the numbers. >>>>>>> >>>>>>> Compare columns C and E of this spreadsheet: >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>> >>> https://docs.google.com/spreadsheet/ccc?key=0Av4Lhq3W5zKodGZtNU1oRGFjWi1kYXkzVEtjOWY1ZlE#gid=0 >>> >>>>>>> >>>>>>> With the data in these two Wikipedia articles. >>>>>>> >>>>>>> >>>>>> >>>> >>> http://en.wikipedia.org/wiki/List_of_countries_by_number_of_Internet_users >>> >>>>>>> >>>>>>> http://en.wikipedia.org/wiki/List_of_countries_by_population >>>>>>> >>>>>>> Once reviewed, and we have the updated maps, then I have an idea. We >>>>>>> could do a blog post on these numbers, but frame it as a general >>> story >>>>>>> about end-user use of desktop open source software, etc. If we make >>>>>>> the story more general interest we'll get broader circulation and >>>>>>> uptake in the press. Of course, it supports a positive story of our >>>>>>> project as well. But by telling the broader story, and using >>>>>>> OpenOffice as an example, we'll go further. >>>>>>> >>>>>>> Does this make sense? >>>>>>> >>>>>>> -Rob >>>>>>> >>>>>>>> On Wed, Jan 23, 2013 at 10:59 AM, Samer Mansour < >>> [email protected] >>>>> >>>>>>> wrote: >>>>>>>> >>>>>>>>> Here is an updated map. I moved to bubble chart because coloring >>>> the >>>>>>>>> country made places like Russia and Canada look odd. >>>>>>>>> I will see if I can make other visualizations as well, maybe Map >>> is >>>>>> not >>>>>>>>> the best visualization. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Jan 23, 2013 at 3:10 AM, Kadal Amutham <[email protected] >>>> >>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Dear Rob Weir, >>>>>>>>>> >>>>>>>>>> The internet user data has been filled >>>>>>>>>> >>>>>>>>>> With Warm Regards >>>>>>>>>> >>>>>>>>>> V.Kadal Amutham >>>>>>>>>> 919444360480 >>>>>>>>>> 914422396480 >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 23 January 2013 07:23, Kadal Amutham <[email protected]> >>> wrote: >>>>>>>>>> >>>>>>>>>>> I will start filling the internet user data >>>>>>>>>>> >>>>>>>>>>> With Warm Regards >>>>>>>>>>> >>>>>>>>>>> V.Kadal Amutham >>>>>>>>>>> 919444360480 >>>>>>>>>>> 914422396480 >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On 23 January 2013 01:38, Rob Weir <[email protected]> >>> wrote: >>>>>>>>>>> >>>>>>>>>>>> On Tue, Jan 22, 2013 at 12:11 PM, Kadal Amutham < >>>> [email protected] >>>>>>> >>>>>>>>>> wrote: >>>>>>>>>>>>> Check the google document at >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>> >>>>>> >>>> >>> https://docs.google.com/spreadsheet/ccc?key=0Av4Lhq3W5zKodGZtNU1oRGFjWi1kYXkzVEtjOWY1ZlE#gid=0 >>> >>>>>>>>>>>>> >>>>>>>>>>>>> I have entered the population data alone >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Very good. I made some edits and also received a spreadsheet >>>> with >>>>>>> some >>>>>>>>>>>> more data from Gianvittorio. >>>>>>>>>>>> >>>>>>>>>>>> The results are interesting. For example, what countries >>> have >>>> the >>>>>>>>>>>> highest percentage of downloads by population? The top 5 >>> are: >>>>>>>>>>>> >>>>>>>>>>>> 1) Gambia >>>>>>>>>>>> 2) Trinidad and Tobago >>>>>>>>>>>> 3) Zimbabwe >>>>>>>>>>>> 4) Vatican City >>>>>>>>>>>> 5) Saint Pierre and Miquelon >>>>>>>>>>>> >>>>>>>>>>>> It will be interesting to see how the data is when we look at >>>>>> usage >>>>>>>>>>>> per internet users in a country. >>>>>>>>>>>> >>>>>>>>>>>> But however we slice the data we'll have this problem: For >>>> very >>>>>>> small >>>>>>>>>>>> countries, just a few downloads can shift the ratio by a >>> large >>>>>>> amount. >>>>>>>>>>>> For example, the Vatican City had around 100 downloads. So >>> a >>>>>>>>>>>> difference of 10 downloads is 10%. France had 4.5 million >>>>>>> downloads. >>>>>>>>>>>> A difference of 10 downloads is nothing. >>>>>>>>>>>> >>>>>>>>>>>> I've seen this handled in other contexts by applying >>>> statistical >>>>>>>>>>>> techniques to estimate error bounds on the ratio, and then >>>> rank by >>>>>>> the >>>>>>>>>>>> lower confidence limit. You can see the technique described >>>> (and >>>>>>>>>>>> formulas given) here: >>>>>>>>>>>> http://evanmiller.org/how-not-to-sort-by-average-rating.html >>>>>>>>>>>> >>>>>>>>>>>> -Rob >>>>>>>>>>>> >>>>>>>>>>>>> With Warm Regards >>>>>>>>>>>>> >>>>>>>>>>>>> V.Kadal Amutham >>>>>>>>>>>>> 919444360480 >>>>>>>>>>>>> 914422396480 >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On 22 January 2013 22:26, Kadal Amutham <[email protected]> >>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Good show. I have almost entered the population data into >>>> the >>>>>>> spread >>>>>>>>>>>>>> sheet. Then I have to populate the internet user data. >>> Once >>>> it >>>>>> is >>>>>>>>>>>> over, I >>>>>>>>>>>>>> will let you know. >>>>>>>>>>>>>> >>>>>>>>>>>>>> With Warm Regards >>>>>>>>>>>>>> >>>>>>>>>>>>>> V.Kadal Amutham >>>>>>>>>>>>>> 919444360480 >>>>>>>>>>>>>> 914422396480 >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 22 January 2013 21:37, Samer Mansour < >>> [email protected] >>>>> >>>>>>> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> We don't have internet users completely populated so from >>>> the >>>>>>> data >>>>>>>>>> we >>>>>>>>>>>>>>> currently have I whipped something up in 5 mins at work. >>>>>>>>>>>>>>> This is just the top 40 Countries. Its manual data >>> entry, >>>>>> once >>>>>>> we >>>>>>>>>>>> have >>>>>>>>>>>>>>> internet users populated and I will resolve things like >>>> "Hong >>>>>>>>>> Kong" -> >>>>>>>>>>>>>>> "China" and Singapore -> South Korea. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I can maybe finish some data entry tonight. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/visualizations/aoo-test-visualization >>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> This is a PNG output: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>> >>>>>> >>>> >>> http://www-958.ibm.com/software/analytics/manyeyes/vis/FullScreen/fullscreenvisualization.html?id=files%2Fthumbnails%2Ffed90050-64ac-11e2-926b-000255111976.wm.png&visId=ff062cd864ac11e2926b000255111976 >>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Mon, Jan 21, 2013 at 7:44 AM, Rob Weir < >>>> [email protected] >>>>>>> >>>>>>>>>> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Sun, Jan 20, 2013 at 10:34 PM, Kadal Amutham < >>>>>>>>>> [email protected]> >>>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>>>> Dear Mr. Rob, I tried to edit the document, but it is >>>> read >>>>>>>>>> only. >>>>>>>>>>>> Can >>>>>>>>>>>>>>> you >>>>>>>>>>>>>>>>> make it readable so that everybody can fill the data? >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> OK. I gave you and Samer write permissions. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -Rob >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> With Warm Regards >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> V.Kadal Amutham >>>>>>>>>>>>>>>>> 919444360480 >>>>>>>>>>>>>>>>> 914422396480 >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> On 21 January 2013 09:01, Kadal Amutham < >>>> [email protected] >>>>>>> >>>>>>>>>> wrote: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Who ever finds time, can fill the remaining Data, so >>>> that >>>>>>> the >>>>>>>>>>>>>>> document >>>>>>>>>>>>>>>>>> become complete >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> With Warm Regards >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> V.Kadal Amutham >>>>>>>>>>>>>>>>>> 919444360480 >>>>>>>>>>>>>>>>>> 914422396480 >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> On 21 January 2013 07:46, Rob Weir < >>>> [email protected]> >>>>>>>>>> wrote: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On Sat, Jan 19, 2013 at 12:34 PM, Roberto >>> Galoppini < >>>>>>>>>>>>>>>> [email protected]> >>>>>>>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>>>>>>> On Fri, Jan 18, 2013 at 10:34 PM, Rob Weir < >>>>>>>>>>>> [email protected]> >>>>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> I was thinking of putting together a world map >>>>>> showing >>>>>>> the >>>>>>>>>>>> use of >>>>>>>>>>>>>>>>>>>>> OpenOffice, the kind with each country shaded or >>>>>> color >>>>>>>>>> coded >>>>>>>>>>>> to >>>>>>>>>>>>>>> show >>>>>>>>>>>>>>>>>>>>> the density of use. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> I can easily get a data set showing the total >>>> number >>>>>> of >>>>>>>>>>>>>>> downloads of >>>>>>>>>>>>>>>>>>>>> OpenOffice per country. But the raw numbers >>> don't >>>>>>> really >>>>>>>>>>>> tell >>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>>>>> story. It would show, probably, that the USA >>> has >>>> the >>>>>>> most >>>>>>>>>>>>>>>> downloads. >>>>>>>>>>>>>>>>>>>>> But that is probably also because of its large >>>>>>> population. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> So maybe we then show downloads per capita, or >>>>>>> downloads >>>>>>>>>> per >>>>>>>>>>>>>>> 100,000 >>>>>>>>>>>>>>>>>>>>> population. But that then becomes a proxy for >>>>>> economic >>>>>>>>>>>>>>> development, >>>>>>>>>>>>>>>>>>>>> since there are highly populated countries with >>>> fewer >>>>>>>>>>>> computers >>>>>>>>>>>>>>> per >>>>>>>>>>>>>>>>>>>>> capital, and low population countries with more >>>>>>> computers, >>>>>>>>>>>> etc. >>>>>>>>>>>>>>> I >>>>>>>>>>>>>>>>>>>>> don't think that is what we want to show. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> So, I'm wondering, has anyone seen data for >>>> something >>>>>>> like >>>>>>>>>>>> PCs >>>>>>>>>>>>>>> per >>>>>>>>>>>>>>>>>>>>> capita, or home computers, or internet users, or >>>> some >>>>>>>>>> other >>>>>>>>>>>> proxy >>>>>>>>>>>>>>>> for >>>>>>>>>>>>>>>>>>>>> what our potential usership would be per >>> country? >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Maybe we can use internet users stats by country, >>>>>>> something >>>>>>>>>>>> like: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>> >>>>>> >>>> >>> http://en.wikipedia.org/wiki/List_of_countries_by_number_of_Internet_usersto >>> >>>>>>>>>>>>>>>>>>>> normalize our stats. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Thanks, that looks useful. I started entering the >>>> data >>>>>>> into >>>>>>>>>> a >>>>>>>>>>>>>>>>>>> spreadsheet: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>> >>>>>> >>>> >>> https://docs.google.com/spreadsheet/ccc?key=0Av4Lhq3W5zKodGZtNU1oRGFjWi1kYXkzVEtjOWY1ZlE >>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> As you see, Italy is at the top, if you look at >>>>>> downloads >>>>>>> per >>>>>>>>>>>> 1000 >>>>>>>>>>>>>>>>>>> internet users, with 91. So nearly one in ten in >>>> Italy >>>>>>> have >>>>>>>>>>>>>>>>>>> downloaded AOO! >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> -Rob >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> -Rob >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>>>>> ==== >>>>>>>>>>>>>>>>>>>> This e- mail message is intended only for the >>> named >>>>>>>>>>>> recipient(s) >>>>>>>>>>>>>>>> above. >>>>>>>>>>>>>>>>>>> It >>>>>>>>>>>>>>>>>>>> may contain confidential and privileged >>>> information. >>>>>> If >>>>>>> you >>>>>>>>>>>> are >>>>>>>>>>>>>>> not >>>>>>>>>>>>>>>> the >>>>>>>>>>>>>>>>>>>> intended recipient you are hereby notified that >>> any >>>>>>>>>>>> dissemination, >>>>>>>>>>>>>>>>>>>> distribution or copying of this e-mail and any >>>>>>>>>> attachment(s) >>>>>>>>>>>> is >>>>>>>>>>>>>>>> strictly >>>>>>>>>>>>>>>>>>>> prohibited. If you have received this e-mail in >>>> error, >>>>>>>>>> please >>>>>>>>>>>>>>>>>>> immediately >>>>>>>>>>>>>>>>>>>> notify the sender by replying to this e-mail and >>>>>> delete >>>>>>> the >>>>>>>>>>>>>>> message >>>>>>>>>>>>>>>> and >>>>>>>>>>>>>>>>>>> any >>>>>>>>>>>>>>>>>>>> attachment(s) from your system. Thank you. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>> >>>> >>> >>
