help-gnu-emacs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Want to write up quick balance sheet, etc. Via tables?


From: Suvayu Ali
Subject: Re: Want to write up quick balance sheet, etc. Via tables?
Date: Mon, 9 Sep 2013 00:49:00 +0200
User-agent: Mutt/1.5.21 (2012-12-30)

On Mon, Sep 09, 2013 at 12:17:52AM +0200, Pascal J. Bourguignon wrote:
> address@hidden (David Combs) writes:
> 
> > MY QUESTION:
> >
> > How to make it easy, almost foolproof, to be able to quickly format
> > the stuff I type in.
> 
> 
> Type stuff:

 [...chomp...chomp...chomp...]

> Select it, type M-x align-cols RET and get:

 [...chomp...chomp...chomp...]

With orgtbl-mode the OP could get formatting as well as spreadsheet like
functionalities.  To get the formatting the OP could start as:

|cash|20000|short term debt|89000|<tab>

that gives you (with cursor at X):

| cash | 20000 | short term debt | 89000 |
| X    |       |                 |       |

Once you fill everything in, you can use table formulae to do get
spreadsheet operations.  The following example does a column sum of the
2nd and last columns.

| cash |  20000 | short term debt |  89000 |
| cash |  20000 | short term debt |  89000 |
| cash |  20000 | short term debt |  89000 |
| cash |  20000 | short term debt |  89000 |
| cash |  20000 | short term debt |  89000 |
| cash |  20000 | short term debt |  89000 |
|------+--------+-----------------+--------|
|      | 120000 |                 | 534000 |
#+TBLFM: @>$2=vsum(@<address@hidden)::@>$>=vsum(@<address@hidden)

See (info "(org) The spreadsheet") for more details.

Hope this helps,

-- 
Suvayu

Open source is the future. It sets us free.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]