Hello,
Uwe Brauer <o...@mat.ucm.es> writes:
> #+TBLNAME: raw-data2
Not related, but : #+name: raw-data2
> |---+-----------------+-----+-----+-----+-----+-----+-----+-----|
>
> | | / | | <> | <> | <> | <> | <> | <> |
> | | Nombre Completo | DNI | Ej1 | Ej2 | Ej3 | Ej4 | Ej5 | Res |
> |---+-----------------+-----+-----+-----+-----+-----+-----+-----|
> | | Candidate1 | 1 | 0 | 5 | 5 | 0 | 10 | 2 |
> | | Candidate2 | 2 | 5 | 0 | 5 | 0 | 0 | 1 |
> | | Candidate3 | 3 | 0 | 0 | 0 | 20 | 25 | 4.5 |
> | | Candidate4 | 4 | 0 | 0 | 0 | 25 | 15 | 4 |
> | | Candidate5 | 5 | 15 | 15 | 20 | 25 | 25 | 10 |
> | | Candidate6 | 6 | 15 | 10 | 20 | 20 | 20 | 8.5 |
> | | Candidate7 | 7 | 15 | 10 | 10 | 20 | 15 | 7 |
>
> #+TBLFM: $9=($4+$5+$6+$7+$8)/10
>
> | lower bound | upper bound | frequency |
> |-------------+-------------+-----------|
> | 1 | 5 | 0 |
> | 5 | 10 | 1 |
>
> #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@9$9..@>$9))
> nil 'in-interval));N
^^^^
@2$9
>
> #+TBLNAME: raw-data3
See above.
> |---+-----------------+-----+-----+-----+-----+-----|
>
> | | / | <> | <> | <> | <> | <> |
> | | Nombre Completo | Ej1 | Ej2 | Ej3 | Ej4 | Res |
> |---+-----------------+-----+-----+-----+-----+-----|
> | | Candidate1 | 0 | 5 | 5 | 0 | 1 |
> | | Candidate2 | 5 | 0 | 5 | 0 | 1 |
> | | Candidate3 | 0 | 0 | 0 | 20 | 2 |
> | | Candidate4 | 0 | 0 | | 25 | 2.5 |
> | | Candidate5 | 15 | 15 | 20 | 25 | 7.5 |
> | | Candidate6 | 15 | 10 | 20 | 20 | 6.5 |
> | | Candidate7 | 15 | 0 | 10 | 20 | 4.5 |
>
> #+TBLFM: $7=($3+$4+$5+$6)/10
>
> | lower bound | upper bound | frequency |
> |-------------+-------------+-----------|
> | 0 | 5 | 1 |
> | 5 | 10 | 2 |
>
> #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data3,@7$7..@>$7))
> nil 'in-interval));N
^^^^
ditto
Regards,
--
Nicolas Goaziou
