all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
From: Josh Mattoon <joshmattoon@gmail.com>
To: nicholas.dokos@hp.com
Cc: Dan Davison <davison@stats.ox.ac.uk>, emacs-orgmode@gnu.org
Subject: Re: dates in a spreadsheet
Date: Wed, 17 Mar 2010 13:45:51 -0700	[thread overview]
Message-ID: <3a257d511003171345l631fcf37ic425a9d4904f402a@mail.gmail.com> (raw)
In-Reply-To: <11255.1268855898@alphaville.usa.hp.com>


[-- Attachment #1.1: Type: text/plain, Size: 2479 bytes --]

Hey Nick, the first one came through just fine. This is pretty cool but
still not quite what I'm looking for.  It totally helped me get what I
wanted though!  I wanted to have a separate row for each day so I could fill
in activities.  Modifying your example I get:

| date             | place   | activity                  | notes
 |
|------------------+---------+---------------------------+------------------|
| <2010-03-19 Fri> |         |                           | dummy
 |
| <2010-03-20 Sat> |         |                           |
 |
| <2010-03-21 Sun> | moon    | collect rocks             |
 |
| <2010-03-22 Mon> | jupiter | thrash around the red dot |
 |
| <2010-03-23 Tue> | mars    | see the little green men  |
 |
| <2010-03-24 Wed> | earth   |                           | home, sweet home
|
#+TBLFM: @2$1 = <03-19-2010>::$1 = @-1$1 + 1

Exactly what I wanted!  I can insert days, move them around, and just hit
C-u C-c C-c to have it update.  I'd like to understand how it works though,
if you don't mind.  What does the ::$1 synax mean?  And how did it know that
we were dealing with a date?

On Wed, Mar 17, 2010 at 12:58 PM, Nick Dokos <nicholas.dokos@hp.com> wrote:

> Josh Mattoon <joshmattoon@gmail.com> wrote:
>
> > If I wanted to add an extra day on mars I could just enter a new row,
> recalculate the forumula, and
> > the dates would be automagically updated. It's not such a big deal in a
> small example like this but
> > I'm planning out a 3 week vacation with a fair number of destinations.
> I'd like the day of week to
> > display because some sites are closed on certain days.
>
> [Not sure what mailer mangled my previous reply to the point of
> unrecognizability, but here is another attempt - I hope it's
> cleaner. Let me know if there is a problem.]
>
>
> | date             | duration | place   | activity                  | notes
>            |
>
> |------------------+----------+---------+---------------------------+------------------|
> | <2010-03-17 Wed> |        0 |         |                           | dummy
>            |
> | <2010-03-17 Wed> |        3 | moon    | collect rocks             |
>            |
> | <2010-03-20 Sat> |        5 | mars    | see the little green men  |
>            |
> | <2010-03-25 Thu> |        5 | jupiter | thrash around the red dot |
>            |
> | <2010-03-30 Tue> |          | earth   |                           | home,
> sweet home |
> #+TBLFM: @2$1 = <03-17-2010>::$1 = @-1$1 + @-1$2
>

[-- Attachment #1.2: Type: text/html, Size: 3259 bytes --]

[-- Attachment #2: Type: text/plain, Size: 201 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

  parent reply	other threads:[~2010-03-17 20:49 UTC|newest]

Thread overview: 8+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2010-03-17  6:04 dates in a spreadsheet Josh Mattoon
2010-03-17 15:18 ` Mikael Fornius
2010-03-17 15:26 ` Dan Davison
2010-03-17 16:51   ` Josh Mattoon
     [not found]     ` <11255.1268855898@alphaville.usa.hp.com>
2010-03-17 20:45       ` Josh Mattoon [this message]
2010-03-17 22:39         ` Bernt Hansen
2010-03-18  5:38           ` Carsten Dominik
2010-03-18 20:31     ` Eric S Fraga

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=3a257d511003171345l631fcf37ic425a9d4904f402a@mail.gmail.com \
    --to=joshmattoon@gmail.com \
    --cc=davison@stats.ox.ac.uk \
    --cc=emacs-orgmode@gnu.org \
    --cc=nicholas.dokos@hp.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.