Olympics Stats

Another great example of creativity in using Zoho apps - very cool!

FYI! For some reason the Medal Standings module does not show the data grid in Safari. I can see in fine in FF. (I am using a MacBook Pro)

Very cool use of your Apps though!

MH

Hi MH,


Currently Zoho DB & Reports does not support Safari, hence you face that problem. We will be supporting Safari in the future. Please do use FF or IE for the time being.


Clarence

Zoho DB & Reports

Can you do a statistic showing number of medals PER ATHLETE in delegation?

how many athletes are there at the games?

Mark, I mean PER COUNTRY... so if you have 60 medals and 600 athletes (China probably more...) you have 60/600 = 0.1 medals per athlete. But if you have 5 athletes (How many from Zimbabwe?) and you have ONE medal you have won 1/5 = 0.2 per athlete.... double than China! That is what I am talking about.
Where can we get the number of athletes per country?...

Hi pbaques!

Why not? Checkout the following link
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000000354188

It has "Medals Per Participant" value as well as "Numer of Participants" and the "Total" Medals won by each country. Tryout the sort and filter do get more finer information.

Mark: Kindly note that the above has number of athletes.

Kovil Pillai P.,
Zoho DB & Reports.

First - thanks for you work and contributing these excellent stats ;)

I was just thinking that it would be cool to see stats on the world records broken during the Olympics. There seems to be a ton from swimming and track and field.

Thanks for the superb work.
Is there any way I can download the report for offline analysis?

Cheers!

Thank you so much for posting and gathering these stats. They will be used and referred to often by educators using charts and graphs of real life examples. Thanks!

Thats really neat, how do you manage to get the graphs to sit side by side like that ?


Cheers

See in the wilki its easy to do just put the graphs next to each other.


OK next question is how do you set up to interact with the database when you click on the graphs?

Cheers


Peter

Does anyone know where I can find the definitive list of number of athletes by country?

Great site

@Shane: We are working "Records" report and I shall keep you posted. Meanwhile, kindly checkout our new reports here: http://olympics2008.wiki.zoho.com/Olympics-Stats2.html

@SM:
You can create new reports and other views based on the same data that we are using after login to Zoho DB & Reports. I am sorry to say that we haven't provided an option to download/export data.

Kovil Pillai P.,
Zoho DB & Reports.

Hi Nick,

You can find the "number of athletes by top 7 countries" in this chart
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000000254532

Checkout the full list here
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000000255481

Kovil Pillai P.,
Zoho DB & Reports.

Hi Kovil,

Thanks ;) It's great to see you're still adding goodies even though there are only a couple of days left in the Olympics!

I'd definitely vote for Zoho becoming the Official Olympic Statisticians ;)

Hi, kcaise!

Thanks for your comment. As a matter of fact, we got a lot more options to visualise your data. Kindly login to http://reports.zoho.com and share your feedbacks with us.

Kovil Pillai P.,
Zoho DB & Reports.

Beijing Olympics 2008 Live


Watch Live on


<a href="http://olympicslivechannel.blogspot.com">http://olympicslivechannel.blogspot.com</a>


Good Quality Streaming. Frequently updating.......

Hi, Shane!

Here are some more interesting charts:
Records By Country:
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000001211853
Records By Day:
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000001211853
Records By Discipline:
http://db.zoho.com/ZDBDataSheetView.cc?DBID=4000000254521&OBJID=4000001211853

Kovil Pillai P.,
Zoho DB & Reports.

Hi, Peter!

Interaction with database is done using simple JavaScript (AJAX Request), HTML (area map)

Kovil Pillai P.,
Zoho DB & Reports.

Toober.com loves the olympics!!

good job! this was fascinating

i would like to see number of medals per number of participants of each country... anybody knows where to find?

Will the chart auto refreshed after being posted to site, when the data being updated? Or it is a static chart?

Hi Thanks for the comment.

The chart is not refreshed automatically unless the browser or the view in Zoho Reports are refreshed. We do have this in our roadmap. Will address this in the future.