From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: Table formula to convert hex to dec
Date: Sun, 24 Jul 2011 11:58:41 -0400
Message-ID: <28806.1311523121@alphaville.dokosmarshall.org>
References: <20110724080054.GB16388@x201>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:36730)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1Ql14p-0006Dg-Tr
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 11:58:48 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1Ql14o-0002FW-Ls
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 11:58:47 -0400
Received: from g4t0015.houston.hp.com ([15.201.24.18]:9108)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1Ql14o-0002FQ-IX
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 11:58:46 -0400
Received: from g4t0018.houston.hp.com (g4t0018.houston.hp.com [16.234.32.27])
	by g4t0015.houston.hp.com (Postfix) with ESMTP id 8A3FF806E
	for <emacs-orgmode@gnu.org>; Sun, 24 Jul 2011 15:58:43 +0000 (UTC)
In-Reply-To: Message from Russell Adams <RLAdams@AdamsInfoServ.Com>
	of "Sun, 24 Jul 2011 03:00:54 CDT." <20110724080054.GB16388@x201>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org
Cc: nicholas.dokos@hp.com

Russell Adams <RLAdams@AdamsInfoServ.Com> wrote:

> Has anyone been able to convert a column of hex numbers to decimal in
> another column?
> 

I suspect there are many ways - here's one:

--8<---------------cut here---------------start------------->8---
* hex-to- conversion

|  h |  d |  o |
|----+----+----|
|  1 |  1 |  1 |
|  2 |  2 |  2 |
|  3 |  3 |  3 |
|  4 |  4 |  4 |
|  5 |  5 |  5 |
|  6 |  6 |  6 |
|  7 |  7 |  7 |
|  8 |  8 | 10 |
|  9 |  9 | 11 |
|  a | 10 | 12 |
|  b | 11 | 13 |
|  c | 12 | 14 |
|  d | 13 | 15 |
|  e | 14 | 16 |
|  f | 15 | 17 |
| 10 | 16 | 20 |
| 11 | 17 | 21 |
| 12 | 18 | 22 |
| 13 | 19 | 23 |
| 14 | 20 | 24 |
| 15 | 21 | 25 |
| 16 | 22 | 26 |
#+TBlLFM: $2 = '(string-to-number $1 16) :: $3 = '(string-to-number $1 16);%o
--8<---------------cut here---------------end--------------->8---

Nick