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
next prev 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.