Scripts to generate statistics about number of bugs and commits in the last year

Used in talk from eduJam 2011

18 files changed, 573 insertions, 0 deletions

diff --git a/statistics/activities-data.txt b/statistics/activities-data.txt
new file mode 100644
index 0000000..eeabf9a
--- /dev/null
+++ b/statistics/activities-data.txt
@@ -0,0 +1,40 @@
+abacus|gitorious@git.sugarlabs.org:abacus/mainline.git|Abacus||
+browse|gitorious@git.sugarlabs.org:browse/mainline.git|Browse|browse-activity|
+calculate|gitorious@git.sugarlabs.org:calculate/mainline.git|Calculate|calculator-activity|
+chat|gitorious@git.sugarlabs.org:chat/mainline.git|Chat|chat-activity|
+clock|gitorious@git.sugarlabs.org:clock/mainline.git|Clock|clock-activity|
+colors|gitorious@git.sugarlabs.org:colors/mainline.git|Colors|colors-activity|
+distance|git://dev.laptop.org/projects/acoustic-measure-activity||acoustic-measure-activity|
+etoys|gitorious@git.sugarlabs.org:etoys/mainline.git|Etoys|etoys-activity|
+finance|gitorious@git.sugarlabs.org:finance/mainline.git|||
+fototoon|gitorious@git.sugarlabs.org:fototoon/mainline.git|||
+get-books|gitorious@git.sugarlabs.org:get-books/mainline.git|||
+hello-world|gitorious@git.sugarlabs.org:helloworld/mainline.git|||
+help|gitorious@git.sugarlabs.org:help/mainline.git|Help|help-activity|
+implode|gitorious@git.sugarlabs.org:implode/mainline.git|||
+infoslicer|gitorious@git.sugarlabs.org:infoslicer/mainline.git|InfoSlicer||
+imageviewer|gitorious@git.sugarlabs.org:imageviewer/mainline.git|Imageviewer|imageviewer-activity|
+jukebox|gitorious@git.sugarlabs.org:jukebox/mainline.git|Jukebox|jukebox-activity|
+labyrinth|gitorious@git.sugarlabs.org:labyrinth/mainline.git|Labyrinth||	
+log|gitorious@git.sugarlabs.org:log/mainline.git|Log||
+maze|gitorious@git.sugarlabs.org:maze/mainline.git|Maze||
+memorize|gitorious@git.sugarlabs.org:memorize/mainline.git|Memorize|memorize|
+measure|git://dev.laptop.org/projects/measure|Measure|measure-activity|		
+moon|gitorious@git.sugarlabs.org:moon/mainline.git|Moon||
+paint|gitorious@git.sugarlabs.org:paint/mainline.git|Paint|paint/drawing-activity (oficina)|
+physics|gitorious@git.sugarlabs.org:physics/mainline.git|Physics|physics-activity|
+pippy|gitorious@git.sugarlabs.org:pippy/mainline.git|Pippy|pippy-activity|
+read|gitorious@git.sugarlabs.org:read/mainline.git|Read|read-activity|
+record|gitorious@git.sugarlabs.org:record/mainline.git|Record|record-activity|
+ruler|gitorious@git.sugarlabs.org:ruler/mainline.git|||
+scratch|gitorious@git.sugarlabs.org:scratch/mainline.git|Scratch|scratch-activity|
+speak|gitorious@git.sugarlabs.org:speak/mainline.git|Speak|speak-activity|
+stopwatch|gitorious@git.sugarlabs.org:stopwatch/mainline.git||stopwatch-activity|
+tamtam|git://dev.laptop.org/projects/tamtam|TamTam|tamtam-activity|
+terminal|gitorious@git.sugarlabs.org:terminal/mainline.git|Terminal|terminal-activity|
+turtleart|gitorious@git.sugarlabs.org:turtleart/mainline.git|Turtleart|turtleart-activity|
+typing-turtle|gitorious@git.sugarlabs.org:typing-turtle/mainline.git|TypingTurtle||
+watchme|gitorious@git.sugarlabs.org:watchme/mainline.git|WatchMe||
+wikipedia|git://dev.laptop.org/projects/wikiserver||wikibrowse-activity|
+words|gitorious@git.sugarlabs.org:words/mainline.git|Words||
+write|gitorious@git.sugarlabs.org:write/mainline.git|Write|write-activity|
diff --git a/statistics/bugs-by-activity.txt b/statistics/bugs-by-activity.txt
new file mode 100644
index 0000000..de60a62
--- /dev/null
+++ b/statistics/bugs-by-activity.txt
@@ -0,0 +1,89 @@
+[gonzalo@aronax statistics]$ ./report-bugs.sh | sort -n -r
+158 browse 47 111
+60 read 17 43
+52 tamtam 11 41
+50 record 28 22
+34 turtleart 24 10
+28 terminal 12 16
+25 pippy 10 15
+25 measure 12 13
+25 calculate 18 7
+22 physics 10 12
+21 memorize 12 9
+20 etoys 4 16
+19 help 4 15
+16 write 15 1
+13 colors 9 4
+13 chat 11 2
+12 scratch 3 9
+10 wikipedia - 10
+10 clock 9 1
+9 jukebox 7 2
+8 distance - 8
+7 words 7 -
+7 labyrinth 7 -
+5 moon 5 -
+5 log 5 -
+4 typing-turtle 4 -
+4 speak 3 1
+4 paint 3 1
+3 imageviewer 1 2
+2 watchme 2 -
+2 stopwatch - 2
+1 maze 1 -
+1 infoslicer 1 -
+1 abacus 1 -
+0 ruler - -
+0 implode - -
+0 hello-world - -
+0 get-books - -
+0 fototoon - -
+0 finance - -
+
+
+[gonzalo@aronax statistics]$ ./count-cant-comits-last-year.sh | sort -r -n
+713 turtleart
+87 abacus
+70 paint
+46 physics
+44 pippy
+42 get-books
+41 speak
+32 record
+30 fototoon
+28 read
+28 maze
+25 calculate
+23 browse
+16 write
+12 chat
+9 imageviewer
+8 labyrinth
+7 jukebox
+7 help
+4 memorize
+3 typing-turtle
+2 ruler
+2 implode
+1 moon
+1 log
+1 infoslicer
+1 colors
+1 clock
+0 terminal
+0 finance
+0 etoys
+
+[gonzalo@aronax statistics]$ ./create-commit-bugs-data.sh
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+cat: commits_last_year.txt: No existe el fichero o el directorio
+
+
diff --git a/statistics/bugs_index.html b/statistics/bugs_index.html
new file mode 100644
index 0000000..16a30e8
--- /dev/null
+++ b/statistics/bugs_index.html
@@ -0,0 +1,203 @@
+<head>
+<style type=text/css>
+body
+{
+background-color:#d0e4fe;
+font-family:Arial;
+font-size:10px;
+}
+th
+{
+background-color:grey;
+color:orange;
+text-align:center;
+}
+td
+{
+background-color:white;
+}
+</style>
+</head>
+<body><table>
+<tr><th>Actividad</th><th>Bugs en Sugarlabs</th><th>Bugs en OLPC</th></tr>
+<tr><td>abacus</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Abacus&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Abacus</a>
+</td><td>
+</td></tr>
+<tr><td>browse</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Browse&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Browse</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=browse-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>browse-activity</a>
+</td></tr>
+<tr><td>calculate</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Calculate&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Calculate</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=calculator-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>calculator-activity</a>
+</td></tr>
+<tr><td>chat</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Chat&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Chat</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=chat-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>chat-activity</a>
+</td></tr>
+<tr><td>clock</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Clock&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Clock</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=clock-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>clock-activity</a>
+</td></tr>
+<tr><td>colors</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Colors&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Colors</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=colors-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>colors-activity</a>
+</td></tr>
+<tr><td>distance</td><td>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=acoustic-measure-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>acoustic-measure-activity</a>
+</td></tr>
+<tr><td>etoys</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Etoys&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Etoys</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=etoys-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>etoys-activity</a>
+</td></tr>
+<tr><td>finance</td><td>
+</td><td>
+</td></tr>
+<tr><td>fototoon</td><td>
+</td><td>
+</td></tr>
+<tr><td>get-books</td><td>
+</td><td>
+</td></tr>
+<tr><td>hello-world</td><td>
+</td><td>
+</td></tr>
+<tr><td>help</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Help&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Help</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=help-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>help-activity</a>
+</td></tr>
+<tr><td>implode</td><td>
+</td><td>
+</td></tr>
+<tr><td>infoslicer</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=InfoSlicer&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>InfoSlicer</a>
+</td><td>
+</td></tr>
+<tr><td>imageviewer</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Imageviewer&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Imageviewer</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=imageviewer-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>imageviewer-activity</a>
+</td></tr>
+<tr><td>jukebox</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Jukebox&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Jukebox</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=jukebox-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>jukebox-activity</a>
+</td></tr>
+<tr><td>labyrinth</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Labyrinth&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Labyrinth</a>
+</td><td>
+</td></tr>
+<tr><td>log</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Log&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Log</a>
+</td><td>
+</td></tr>
+<tr><td>maze</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Maze&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Maze</a>
+</td><td>
+</td></tr>
+<tr><td>memorize</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Memorize&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Memorize</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=memorize&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>memorize</a>
+</td></tr>
+<tr><td>measure</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Measure&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Measure</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=measure-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>measure-activity</a>
+</td></tr>
+<tr><td>moon</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Moon&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Moon</a>
+</td><td>
+</td></tr>
+<tr><td>paint</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Paint&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Paint</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=paint/drawing-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>paint/drawing-activity</a>
+</td></tr>
+<tr><td>(oficina)</td><td>
+</td><td>
+</td></tr>
+<tr><td>physics</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Physics&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Physics</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=physics-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>physics-activity</a>
+</td></tr>
+<tr><td>pippy</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Pippy&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Pippy</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=pippy-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>pippy-activity</a>
+</td></tr>
+<tr><td>read</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Read&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Read</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=read-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>read-activity</a>
+</td></tr>
+<tr><td>record</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Record&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Record</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=record-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>record-activity</a>
+</td></tr>
+<tr><td>ruler</td><td>
+</td><td>
+</td></tr>
+<tr><td>scratch</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Scratch&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Scratch</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=scratch-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>scratch-activity</a>
+</td></tr>
+<tr><td>speak</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Speak&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Speak</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=speak-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>speak-activity</a>
+</td></tr>
+<tr><td>stopwatch</td><td>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=stopwatch-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>stopwatch-activity</a>
+</td></tr>
+<tr><td>tamtam</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=TamTam&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>TamTam</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=tamtam-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>tamtam-activity</a>
+</td></tr>
+<tr><td>terminal</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Terminal&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Terminal</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=terminal-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>terminal-activity</a>
+</td></tr>
+<tr><td>turtleart</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Turtleart&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Turtleart</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=turtleart-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>turtleart-activity</a>
+</td></tr>
+<tr><td>typing-turtle</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=TypingTurtle&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>TypingTurtle</a>
+</td><td>
+</td></tr>
+<tr><td>watchme</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=WatchMe&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>WatchMe</a>
+</td><td>
+</td></tr>
+<tr><td>wikipedia</td><td>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=wikibrowse-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>wikibrowse-activity</a>
+</td></tr>
+<tr><td>words</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Words&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Words</a>
+</td><td>
+</td></tr>
+<tr><td>write</td><td>
+<a href='http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=Write&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone' target='_blank'>Write</a>
+</td><td>
+<a href='http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=write-activity&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone' target='_blank'>write-activity</a>
+</td></tr>
+</table>
+</body></html>
diff --git a/statistics/clone-all.sh b/statistics/clone-all.sh
new file mode 100644
index 0000000..1cc0556
--- /dev/null
+++ b/statistics/clone-all.sh
@@ -0,0 +1,17 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	REPO=`echo $LINE | awk -F '|' '{printf("%s",$2)}'`
+    echo $ACTIVITY
+    if [ -d $ACTIVITY/mainline/.git/ ]; then
+    	cd $ACTIVITY/mainline
+        git pull
+        cd ..
+    else
+    	echo $ACTIVITY
+	    mkdir $ACTIVITY
+    	cd $ACTIVITY
+	    git clone $REPO
+    fi
+	cd ..
+done
diff --git a/statistics/commit-bugs-linear.png b/statistics/commit-bugs-linear.png
new file mode 100644
index 0000000..9db043e
--- /dev/null
+++ b/statistics/commit-bugs-linear.png
diff --git a/statistics/commit-bugs.dat b/statistics/commit-bugs.dat
new file mode 100644
index 0000000..29c48bf
--- /dev/null
+++ b/statistics/commit-bugs.dat
@@ -0,0 +1,40 @@
+1 87 abacus
+158 23 browse
+25 25 calculate
+13 12 chat
+10 1 clock
+13 1 colors
+8 0 distance
+20 0 etoys
+0 0 finance
+0 30 fototoon
+0 42 get-books
+0 0 hello-world
+19 7 help
+0 2 implode
+1 1 infoslicer
+3 9 imageviewer
+9 7 jukebox
+7 8 labyrinth
+5 1 log
+1 28 maze
+21 4 memorize
+25 measure
+5 1 moon
+4 70 paint
+22 46 physics
+25 44 pippy
+60 28 read
+50 32 record
+0 2 ruler
+12 0 scratch
+4 41 speak
+2 0 stopwatch
+52 0 tamtam
+28 0 terminal
+34 713 turtleart
+4 3 typing-turtle
+2 0 watchme
+10 0 wikipedia
+7 0 words
+16 16 write
diff --git a/statistics/commit-bugs.gnp b/statistics/commit-bugs.gnp
new file mode 100644
index 0000000..f9a16a6
--- /dev/null
+++ b/statistics/commit-bugs.gnp
@@ -0,0 +1,11 @@
+set term png size 800, 600
+set output "commit-bugs-linear.png"
+#set logscale x
+#set logscale y
+set xlabel "Bugs"
+set ylabel "Commits from last year"
+set title ""
+#set term pdfcairo font "sans,12"
+
+plot "commit-bugs.dat" with labels
+
diff --git a/statistics/commit-bugs.pdf b/statistics/commit-bugs.pdf
new file mode 100644
index 0000000..49a4270
--- /dev/null
+++ b/statistics/commit-bugs.pdf
diff --git a/statistics/commit-bugs.png b/statistics/commit-bugs.png
new file mode 100644
index 0000000..c5c7747
--- /dev/null
+++ b/statistics/commit-bugs.png
diff --git a/statistics/commits_last_year.txt b/statistics/commits_last_year.txt
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/statistics/commits_last_year.txt
@@ -0,0 +1 @@
+0
diff --git a/statistics/count-cant-comits-last-year.sh b/statistics/count-cant-comits-last-year.sh
new file mode 100644
index 0000000..46bf5ea
--- /dev/null
+++ b/statistics/count-cant-comits-last-year.sh
@@ -0,0 +1,15 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	cd $ACTIVITY
+    if [ -d mainline ]; then
+        cd mainline
+        CANT_COMMITS=`git log --oneline --since=05-03-2010 | grep -v Pootle | grep -v "Translation System" | wc -l`
+        echo $CANT_COMMITS $ACTIVITY
+        cd ..
+        echo $CANT_COMMITS > commits_last_year.txt
+    fi
+    cd ..
+done
+
+
diff --git a/statistics/create-bugs-index.sh b/statistics/create-bugs-index.sh
new file mode 100755
index 0000000..3e0bc9b
--- /dev/null
+++ b/statistics/create-bugs-index.sh
@@ -0,0 +1,46 @@
+INDEX_FILE="./bugs_index.html"
+
+echo "<html>" > $INDEX_FILE
+echo "<head>
+<style type="text/css">
+body
+{
+background-color:#d0e4fe;
+font-family:"Arial";
+font-size:10px;
+}
+th
+{
+background-color:grey;
+color:orange;
+text-align:center;
+}
+td
+{
+background-color:white;
+}
+</style>
+</head>" > $INDEX_FILE
+echo "<body><table>" >> $INDEX_FILE
+echo "<tr><th>Actividad</th><th>Bugs en Sugarlabs</th><th>Bugs en OLPC</th></tr>" >> $INDEX_FILE
+
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	BSO_COMPONENT=`echo $LINE | awk -F '|' '{printf("%s",$3)}'`
+	DLO_COMPONENT=`echo $LINE | awk -F '|' '{printf("%s",$4)}'`
+    	echo "<tr><td>$ACTIVITY</td><td>" >> $INDEX_FILE
+    	if [ -n "$BSO_COMPONENT" ]; then
+            	URL_BSO="http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&component=$BSO_COMPONENT&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone"	
+    		echo "<a href='$URL_BSO' target='_blank'>$BSO_COMPONENT</a>" >> $INDEX_FILE
+        fi
+	echo "</td><td>" >> $INDEX_FILE
+	if [ -n "$DLO_COMPONENT" ]; then
+            	URL_DLO="http://dev.laptop.org/query?status=assigned&status=new&status=reopened&component=$DLO_COMPONENT&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone"
+    		echo "<a href='$URL_DLO' target='_blank'>$DLO_COMPONENT</a>" >> $INDEX_FILE
+        fi
+	echo "</td></tr>" >> $INDEX_FILE
+done
+
+echo "</table>" >> $INDEX_FILE
+echo "</body></html>" >> $INDEX_FILE
diff --git a/statistics/create-commit-bugs-data.sh b/statistics/create-commit-bugs-data.sh
new file mode 100644
index 0000000..4edc85a
--- /dev/null
+++ b/statistics/create-commit-bugs-data.sh
@@ -0,0 +1,11 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	cd $ACTIVITY
+    CANT_COMMITS=`cat commits_last_year.txt`
+    CANT_BUGS=`cat total_bugs.txt`
+    cd ..
+    echo $CANT_BUGS $CANT_COMMITS $ACTIVITY >> commit-bugs.dat
+done
+
+
diff --git a/statistics/create-stats.sh b/statistics/create-stats.sh
new file mode 100644
index 0000000..46c9092
--- /dev/null
+++ b/statistics/create-stats.sh
@@ -0,0 +1,7 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	cd $ACTIVITY
+    ../git-stats/gitstats/gitstats mainline/ STATS
+    cd ..
+done
diff --git a/statistics/download-bugs.sh b/statistics/download-bugs.sh
new file mode 100644
index 0000000..4dbf64e
--- /dev/null
+++ b/statistics/download-bugs.sh
@@ -0,0 +1,25 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+	BSO_COMPONENT=`echo $LINE | awk -F '|' '{printf("%s",$3)}'`
+	DLO_COMPONENT=`echo $LINE | awk -F '|' '{printf("%s",$4)}'`
+    echo $ACTIVITY
+    mkdir -p $ACTIVITY
+	cd $ACTIVITY
+    if [ -n "$BSO_COMPONENT" ]; then
+        if [ ! -f $ACTIVITY-bugs-bso.csv ]; then
+            URL_BSO="http://bugs.sugarlabs.org/query?status=accepted&status=assigned&status=new&status=reopened&format=csv&component=$BSO_COMPONENT&order=priority&col=id&col=summary&col=priority&col=status&col=owner&col=type&col=milestone"
+            wget -O $ACTIVITY-bugs-bso.csv $URL_BSO
+        fi
+    fi
+
+    if [ -n "$DLO_COMPONENT" ]; then
+        if [ ! -f $ACTIVITY-bugs-dlo.csv ]; then
+            URL_DLO="http://dev.laptop.org/query?status=assigned&status=new&status=reopened&format=csv&component=$DLO_COMPONENT&order=priority&col=id&col=summary&col=status&col=owner&col=type&col=milestone"
+            wget -O $ACTIVITY-bugs-dlo.csv $URL_DLO 
+        fi
+    fi
+    #echo $URL_BSO
+    #echo $URL_DLO
+    cd ..
+done
diff --git a/statistics/last-commit.sh b/statistics/last-commit.sh
new file mode 100644
index 0000000..47d8b5e
--- /dev/null
+++ b/statistics/last-commit.sh
@@ -0,0 +1,13 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+    echo $ACTIVITY
+    if [ -d $ACTIVITY/mainline/.git/ ]; then
+    	cd $ACTIVITY/mainline
+        LAST_COMMIT=`git log --oneline | grep -v Pootle | grep -v "Translation System" | head -1 | awk '{printf("%s", $1)}'`
+        AUTHOR=`git show $LAST_COMMIT | head -3 | grep "Author"`
+        DATE_LAST_COMMIT=`git show $LAST_COMMIT | head -3 | grep "Date"`
+        echo $ACTIVITY $DATE_LAST_COMMIT $AUTHOR
+        cd ../..
+    fi
+done
diff --git a/statistics/last-commits-sorted.txt b/statistics/last-commits-sorted.txt
new file mode 100644
index 0000000..9d5867b
--- /dev/null
+++ b/statistics/last-commits-sorted.txt
@@ -0,0 +1,34 @@
+speak Date: May 2 2011 Author: Rafael Ortiz <rafael@activitycentral.com>
+maze Date: Apr 29 2011 Author: Rafael Ortiz <rafael@activitycentral.com>
+get-books Date: Apr 28 2011 Author: Gonzalo Odiard <godiard@gmail.com>
+record Date: Apr 25 2011 Author: Daniel Drake <dsd@laptop.org>
+pippy Date: Apr 25 2011 Author: Rafael Ortiz <rafael@activitycentral.com>
+turtleart Date: Apr 24 2011 Author: Walter Bender <walter.bender@gmail.com>
+typing-turtle Date: Apr 11 2011 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+colors Date: Apr 11 2011 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+paint Date: Apr 8 2011 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+read Date: Mar 29 2011 Author: James Cameron <quozl@laptop.org>
+fototoon Date: Mar 24 2011 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+jukebox Date: Mar 14 2011 Author: Rafael Ortiz <rafael@activitycentral.com>
+calculate Date: Mar 1 2011 Author: Gary Martin <gary@garycmartin.com>
+labyrinth Date: Feb 22 2011 Author: Jorge Saldivar <jsaldivar@paraguayeduca.org>
+write Date: Feb 14 2011 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+chat Date: Jan 23 2011 Author: Aleksey Lim <alsroot@member.fsf.org>
+memorize Date: Jan 5 2011 Author: Simon Schampijer <simon@schampijer.de>
+implode Date: Jan 1 2011 Author: Joe Lee <joe@jotaro.com>
+imageviewer Date: Jan 22 2011 Author: Aleksey Lim <alsroot@member.fsf.org>
+infoslicer Date: Dec 31 2010 Author: Aleksey Lim <alsroot@member.fsf.org>
+physics Date: Dec 31 2010 Author: Gary Martin <gary@garycmartin.com>
+browse Date: Nov 18 2010 Author: Gonzalo Odiard <godiard@sugarlabs.org>
+help Date: Nov 10 2010 Author: Bastien Guerry <bzg@altern.org>
+abacus Date: Oct 2 2010 Author: Walter Bender <walter@sugarlabs.org>
+log Date: Sep 30 2010 Author: Simon Schampijer <simon@schampijer.de>
+clock Date: Aug 28 2010 Author: Gary Martin <gary@garycmartin.com>
+moon Date: Aug 28 2010 Author: Gary Martin <gary@garycmartin.com>
+ruler Date: Jul 21 2010 Author: Walter Bender <walter@sugarlabs.org>
+terminal Date: Jan 16 2010 Author: Wade Brainerd <wadetb@gmail.com>
+finance Date: Nov 29 2009 Author: Wade Brainerd <wadetb@gmail.com>
+etoys Date: Mar 2 2009 Author: Bert Freudenberg <bert@freudenbergs.de>
+
+
+
diff --git a/statistics/report-bugs.sh b/statistics/report-bugs.sh
new file mode 100644
index 0000000..4e25b1b
--- /dev/null
+++ b/statistics/report-bugs.sh
@@ -0,0 +1,21 @@
+for LINE in `cat ./activities-data.txt`
+do
+	ACTIVITY=`echo $LINE | awk -F '|' '{printf("%s",$1)}'`
+    CANT_BUGS_BSO="-"
+    CANT=0
+	cd $ACTIVITY
+    if [ -f $ACTIVITY-bugs-bso.csv ]; then
+        CANT_BUGS_BSO=`tail -n +1 $ACTIVITY-bugs-bso.csv | wc -l | awk '{printf("%s", $1)}'`
+        CANT=$CANT_BUGS_BSO
+    fi
+
+    CANT_BUGS_DLO="-"
+    if [ -f $ACTIVITY-bugs-dlo.csv ]; then
+        CANT_BUGS_DLO=`tail -n +1 $ACTIVITY-bugs-dlo.csv | wc -l | awk '{printf("%s", $1)}'` 
+        CANT=`echo "$CANT + $CANT_BUGS_DLO" | bc` 
+    fi
+
+    echo $CANT $ACTIVITY $CANT_BUGS_BSO $CANT_BUGS_DLO
+    echo $CANT > total_bugs.txt
+    cd ..
+done