unofficial mirror of help-gnu-emacs@gnu.org
 help / color / mirror / Atom feed
* Want to write up quick balance sheet, etc.  Via tables?
@ 2013-09-08 21:50 David Combs
  2013-09-08 22:17 ` Pascal J. Bourguignon
  0 siblings, 1 reply; 11+ messages in thread
From: David Combs @ 2013-09-08 21:50 UTC (permalink / raw)
  To: help-gnu-emacs

I need to write up something quick in which I give some
people the bare rudiments of balance sheets and income
statements.

Easy to do in pencil on paper.  Not so easy on a computer,
getting the columns to line up right, etc.  Which is exactly
what I need to do.


You know what a balance sheet looks like:


  ASSETS                     LIABILITIES

cash       20,000          short term debt   89,000
...        ......          ...............   ......  <-- a similar line
...        ......          ...............   ......  <-- a similar line
...        ......          ...............   ......  <-- a similar line

----       ------          ---------------   -----
...        ......          ...............   .....   <--- a total or sub-total line




And also pairs (say) of debits and credits:


inventory  34(db)
debt       34(cr)

plus more pairs (or triples) like that.


MY QUESTION:

How to make it easy, almost foolproof, to be able to quickly format
the stuff I type in.


One idea would be to use emacs's TABLE facility.  At least
that way I've ready-made boxes that different parts can
fit into.

Or I suppose I could use tabs, as set to columns I choose.


Any ideas?

If TABLES, I've played with them just a bit, so maybe
some hints would help.  Or maybe there are other table
mechanisms that people use and find reliable, other
than the one that comes with emacs.  You know, maybe
in the wiki or elsewhere.


THANKS SO MUCH!

David



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 21:50 Want to write up quick balance sheet, etc. Via tables? David Combs
@ 2013-09-08 22:17 ` Pascal J. Bourguignon
  2013-09-08 22:49   ` Suvayu Ali
                     ` (5 more replies)
  0 siblings, 6 replies; 11+ messages in thread
From: Pascal J. Bourguignon @ 2013-09-08 22:17 UTC (permalink / raw)
  To: help-gnu-emacs

dkcombs@panix.com (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:

cash       20,000          short term debt   89,000
cash      20,000          short term debt   89,000
cash       20,000         short term debt   89,000
cash      20,000         short term debt   89,000
cash       20,000          short term debt    89,000
cash       20,000          short term debt     89,000

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

cash       20,000          short term debt     89,000
cash       20,000          short term debt     89,000
cash       20,000          short term debt     89,000
cash       20,000          short term debt     89,000
cash       20,000          short term debt     89,000
cash       20,000          short term debt     89,000


-- 
__Pascal Bourguignon__
http://www.informatimago.com/


^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 22:17 ` Pascal J. Bourguignon
@ 2013-09-08 22:49   ` Suvayu Ali
  2013-09-09  5:52   ` David Combs
                     ` (4 subsequent siblings)
  5 siblings, 0 replies; 11+ messages in thread
From: Suvayu Ali @ 2013-09-08 22:49 UTC (permalink / raw)
  To: help-gnu-emacs

On Mon, Sep 09, 2013 at 12:17:52AM +0200, Pascal J. Bourguignon wrote:
> dkcombs@panix.com (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(@<..@-I)::@>$>=vsum(@<..@-I)

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

Hope this helps,

-- 
Suvayu

Open source is the future. It sets us free.



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 22:17 ` Pascal J. Bourguignon
  2013-09-08 22:49   ` Suvayu Ali
@ 2013-09-09  5:52   ` David Combs
  2013-09-09  5:56   ` David Combs
                     ` (3 subsequent siblings)
  5 siblings, 0 replies; 11+ messages in thread
From: David Combs @ 2013-09-09  5:52 UTC (permalink / raw)
  To: help-gnu-emacs

In article <87bo43c60f.fsf@informatimago.com>,
Pascal J. Bourguignon <pjb@informatimago.com> wrote:
>dkcombs@panix.com (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:
>
>cash       20,000          short term debt   89,000
>cash      20,000          short term debt   89,000
>cash       20,000         short term debt   89,000
>cash      20,000         short term debt   89,000
>cash       20,000          short term debt    89,000
>cash       20,000          short term debt     89,000
>
>Select it, type M-x align-cols RET and get:
>
>cash       20,000          short term debt     89,000
>cash       20,000          short term debt     89,000
>cash       20,000          short term debt     89,000
>cash       20,000          short term debt     89,000
>cash       20,000          short term debt     89,000
>cash       20,000          short term debt     89,000
>
>
>-- 
>__Pascal Bourguignon__
>http://www.informatimago.com/


Thank you!  Had never heard of align-cols.  Will try it!

David



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 22:17 ` Pascal J. Bourguignon
  2013-09-08 22:49   ` Suvayu Ali
  2013-09-09  5:52   ` David Combs
@ 2013-09-09  5:56   ` David Combs
  2013-09-09  6:02   ` David Combs
                     ` (2 subsequent siblings)
  5 siblings, 0 replies; 11+ messages in thread
From: David Combs @ 2013-09-09  5:56 UTC (permalink / raw)
  To: help-gnu-emacs

When did align-cols appear?

The emacs version I'm currently running is 23.0.0.1, and doesn't know about it.

David



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 22:17 ` Pascal J. Bourguignon
                     ` (2 preceding siblings ...)
  2013-09-09  5:56   ` David Combs
@ 2013-09-09  6:02   ` David Combs
  2013-09-09  9:10     ` Óscar Fuentes
       [not found]     ` <mailman.1644.1378717842.10748.help-gnu-emacs@gnu.org>
  2013-09-09  7:38   ` Andreas Röhler
       [not found]   ` <mailman.1637.1378712194.10748.help-gnu-emacs@gnu.org>
  5 siblings, 2 replies; 11+ messages in thread
From: David Combs @ 2013-09-09  6:02 UTC (permalink / raw)
  To: help-gnu-emacs

In article <87bo43c60f.fsf@informatimago.com>,
Pascal J. Bourguignon <pjb@informatimago.com> wrote:

To see just where emacs was on my machine, I got
into *info* and did C-d, ending up in a dired of:
   c:/Documents and Settings/DKC/Desktop/ntemacs23/info/

It's been SO long since I installed this emacs,
is that where info was supposed to end up?

How to load a WINDOWS emacs in a different set of places.
so I can run both in parallel, while testing the new one?

Thanks,

David



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-08 22:17 ` Pascal J. Bourguignon
                     ` (3 preceding siblings ...)
  2013-09-09  6:02   ` David Combs
@ 2013-09-09  7:38   ` Andreas Röhler
       [not found]   ` <mailman.1637.1378712194.10748.help-gnu-emacs@gnu.org>
  5 siblings, 0 replies; 11+ messages in thread
From: Andreas Röhler @ 2013-09-09  7:38 UTC (permalink / raw)
  To: help-gnu-emacs

Am 09.09.2013 00:17, schrieb Pascal J. Bourguignon:
> dkcombs@panix.com (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:
>
> cash       20,000          short term debt   89,000
> cash      20,000          short term debt   89,000
> cash       20,000         short term debt   89,000
> cash      20,000         short term debt   89,000
> cash       20,000          short term debt    89,000
> cash       20,000          short term debt     89,000
>
> Select it, type M-x align-cols RET and get:
>
> cash       20,000          short term debt     89,000
> cash       20,000          short term debt     89,000
> cash       20,000          short term debt     89,000
> cash       20,000          short term debt     89,000
> cash       20,000          short term debt     89,000
> cash       20,000          short term debt     89,000
>
>

Put into a buffer in org-mode

After replacing commata by dots

M-x org-table-convert-region

| cash | 20.000 | short | term | debt | 89.000 |
| cash | 20.000 | short | term | debt | 89.000 |
| cash | 20.000 | short | term | debt | 89.000 |
| cash | 20.000 | short | term | debt | 89.000 |
| cash | 20.000 | short | term | debt | 89.000 |
| cash | 20.000 | short | term | debt | 89.000 |




^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-09-09  6:02   ` David Combs
@ 2013-09-09  9:10     ` Óscar Fuentes
       [not found]     ` <mailman.1644.1378717842.10748.help-gnu-emacs@gnu.org>
  1 sibling, 0 replies; 11+ messages in thread
From: Óscar Fuentes @ 2013-09-09  9:10 UTC (permalink / raw)
  To: help-gnu-emacs

dkcombs@panix.com (David Combs) writes:

> To see just where emacs was on my machine, I got
> into *info* and did C-d, ending up in a dired of:
>    c:/Documents and Settings/DKC/Desktop/ntemacs23/info/
>
> It's been SO long since I installed this emacs,
> is that where info was supposed to end up?

Yes. If you have emacs installed on /some/dir/emacs/, `info' will be on
that directory. (For the next version that will change.)

IMO it is not wise to install applications on Desktop, though.

> How to load a WINDOWS emacs in a different set of places.
> so I can run both in parallel, while testing the new one?

Just unzip the new one on different directory.




^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
       [not found]     ` <mailman.1644.1378717842.10748.help-gnu-emacs@gnu.org>
@ 2013-10-01 18:54       ` David Combs
  2013-10-01 20:46         ` Óscar Fuentes
  0 siblings, 1 reply; 11+ messages in thread
From: David Combs @ 2013-10-01 18:54 UTC (permalink / raw)
  To: help-gnu-emacs

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1044 bytes --]

In article <mailman.1644.1378717842.10748.help-gnu-emacs@gnu.org>,
à scar Fuentes  <ofv@wanadoo.es> wrote:
>dkcombs@panix.com (David Combs) writes:
>
>> To see just where emacs was on my machine, I got
>> into *info* and did C-d, ending up in a dired of:
>>    c:/Documents and Settings/DKC/Desktop/ntemacs23/info/
>>
>> It's been SO long since I installed this emacs,
>> is that where info was supposed to end up?
>
>Yes. If you have emacs installed on /some/dir/emacs/, `info' will be on
>that directory. (For the next version that will change.)
>
>IMO it is not wise to install applications on Desktop, though.
>
>> How to load a WINDOWS emacs in a different set of places.
>> so I can run both in parallel, while testing the new one?
>
>Just unzip the new one on different directory.
>
>

Supper-late response:

(1) Please explain, WHY is it unwise to install on Desktop?

  (Your answer should of course appear in every book on windows!)

(2) Where do YOU put applications, eg emacs, cygwin, putty, 
    audacity, etc?


THANKS!

David




^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
       [not found]   ` <mailman.1637.1378712194.10748.help-gnu-emacs@gnu.org>
@ 2013-10-01 18:57     ` David Combs
  0 siblings, 0 replies; 11+ messages in thread
From: David Combs @ 2013-10-01 18:57 UTC (permalink / raw)
  To: help-gnu-emacs

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1641 bytes --]

In article <mailman.1637.1378712194.10748.help-gnu-emacs@gnu.org>,
Andreas Röhler  <andreas.roehler@easy-emacs.de> wrote:
>Am 09.09.2013 00:17, schrieb Pascal J. Bourguignon:
>> dkcombs@panix.com (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:
>>
>> cash       20,000          short term debt   89,000
>> cash      20,000          short term debt   89,000
>> cash       20,000         short term debt   89,000
>> cash      20,000         short term debt   89,000
>> cash       20,000          short term debt    89,000
>> cash       20,000          short term debt     89,000
>>
>> Select it, type M-x align-cols RET and get:
>>
>> cash       20,000          short term debt     89,000
>> cash       20,000          short term debt     89,000
>> cash       20,000          short term debt     89,000
>> cash       20,000          short term debt     89,000
>> cash       20,000          short term debt     89,000
>> cash       20,000          short term debt     89,000
>>
>>
>
>Put into a buffer in org-mode
>
>After replacing commata by dots
>
>M-x org-table-convert-region
>
>| cash | 20.000 | short | term | debt | 89.000 |
>| cash | 20.000 | short | term | debt | 89.000 |
>| cash | 20.000 | short | term | debt | 89.000 |
>| cash | 20.000 | short | term | debt | 89.000 |
>| cash | 20.000 | short | term | debt | 89.000 |
>| cash | 20.000 | short | term | debt | 89.000 |
>
>

And then convert them back to commas, right?

Or in case periods in text, convert commas to XYZ,
and later back to commas.

Thanks!

David



^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: Want to write up quick balance sheet, etc.  Via tables?
  2013-10-01 18:54       ` David Combs
@ 2013-10-01 20:46         ` Óscar Fuentes
  0 siblings, 0 replies; 11+ messages in thread
From: Óscar Fuentes @ 2013-10-01 20:46 UTC (permalink / raw)
  To: help-gnu-emacs

dkcombs@panix.com (David Combs) writes:

> Supper-late response:
>
> (1) Please explain, WHY is it unwise to install on Desktop?
>
>   (Your answer should of course appear in every book on windows!)

Desktop has limited (visual) space. It is intended for those items
(application shortcuts, folders, etc) that you access often. Having lots
of folders or icons on it defeats its purpose. It is also easy to
accidentally delete or move a Desktop element, more so when you have
lots of them.

You seldom (if ever) have to access the Emacs directory through the
Windows Explorer. Its only "interesting" element is the Emacs launcher
(runemacs.exe). It is much more practical to create a shortcut to that
element on Desktop than accessing it navigating through the Emacs
directory.

> (2) Where do YOU put applications, eg emacs, cygwin, putty, 
>     audacity, etc?

If the application comes with an installer it wil automatically do the
Right Thing, which is installing on one of the directories intended for
applications, either system-wide or user-specific. If the application
does not come with an installer (such as Emacs when distributed as a zip
file) and you are on Vista or newer, install it in your user directory
(c:\Users\Your-user-name) and create a shortcut to
emacs/bin/runemacs.exe on your Desktop. If you are on Windows XP chances
are that you are using an account with Administrator privileges, which
means that you can unzip on "Program Files".

HTH




^ permalink raw reply	[flat|nested] 11+ messages in thread

end of thread, other threads:[~2013-10-01 20:46 UTC | newest]

Thread overview: 11+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2013-09-08 21:50 Want to write up quick balance sheet, etc. Via tables? David Combs
2013-09-08 22:17 ` Pascal J. Bourguignon
2013-09-08 22:49   ` Suvayu Ali
2013-09-09  5:52   ` David Combs
2013-09-09  5:56   ` David Combs
2013-09-09  6:02   ` David Combs
2013-09-09  9:10     ` Óscar Fuentes
     [not found]     ` <mailman.1644.1378717842.10748.help-gnu-emacs@gnu.org>
2013-10-01 18:54       ` David Combs
2013-10-01 20:46         ` Óscar Fuentes
2013-09-09  7:38   ` Andreas Röhler
     [not found]   ` <mailman.1637.1378712194.10748.help-gnu-emacs@gnu.org>
2013-10-01 18:57     ` David Combs

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).