[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Tables for attendance lists - A problem understanding TBLFM?
From: |
Suvayu Ali |
Subject: |
Re: [O] Tables for attendance lists - A problem understanding TBLFM? |
Date: |
Tue, 9 Apr 2013 02:25:19 +0200 |
User-agent: |
Mutt/1.5.21 (2012-12-30) |
On Mon, Apr 08, 2013 at 06:57:53PM -0500, Gunnar Wolf wrote:
> #+CAPTION: Attendances for April
> |---------+-------------------+---+---+---+---+----+-------|
> | Account | Name | 1 | 3 | 5 | 8 | 10 | Total |
> |---------+-------------------+---+---+---+---+----+-------|
> | 1234 | Cárdenas, Lázaro | X | | X | X | | 3 |
> | 5678 | Madero, Francisco | X | X | X | X | | 4 |
> | 1544 | Villa, Pancho | | | | | | 1 |
> | 0113 | Zapata, Emiliano | | X | X | | | 2 |
> |---------+-------------------+---+---+---+---+----+-------|
> | Day avg | 2.25 | 2 | 2 | 3 | 2 | 1 | 2.50 |
> |---------+-------------------+---+---+---+---+----+-------|
> #+tblfm: @address@hidden'(length
> '($3..$7))::@6$2=vmean($3..$7);%.2f::@address@hidden'(length
> '(@address@hidden))::@6$8=vmean(@address@hidden);%.2f
Probably not what you were looking for, why complicate things by using
Xs instead of just a numeral like 1? If you use 1, then you can use a
column formula; maybe something like $>=sum($3..$-1).
--
Suvayu
Open source is the future. It sets us free.
- [O] Tables for attendance lists - A problem understanding TBLFM?, Gunnar Wolf, 2013/04/08
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?,
Suvayu Ali <=
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Gunnar Wolf, 2013/04/08
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Nick Dokos, 2013/04/08
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Nick Dokos, 2013/04/08
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Michael Brand, 2013/04/09
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Gunnar Wolf, 2013/04/09
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Bastien, 2013/04/09
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Michael Brand, 2013/04/11
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Michael Brand, 2013/04/14
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Bastien, 2013/04/14
- Re: [O] Tables for attendance lists - A problem understanding TBLFM?, Michael Brand, 2013/04/14