decoding macro

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Nick Fatica Wed, 18 Nov 1992 19:22

#273

Author: Nick Fatica
Date: Wed, 18 Nov 1992 19:22

19 lines
1381 bytes

I'm looking for a spreadsheet macro (I'm using Quattro Pro - Special Edition)
that will read a four digit hex number (entered as a label) from a cell, parse
it, and enter numbers in the appropriate columns in that row according to the
state of each bit in the hex number.  For example:

     A B C D E F G H I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z AA BB
     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

0362   2   4   6   8 9    11       14 15    17       20    22    24 25       28

One way to look at this "encoding" is to start from the right and let each odd
number represent a "1" and each even number represent a "0" and then divide the
even/odd pairs into groups of four (21/22, 23/24, 25/26, 27,28).  So for the
above example, 22,24,25,28 would correspond to 0010, which can be represented
as a hex 2.
-- 
Nick Fatica   fatican@astro.pc.ab.com
The Allen-Bradley Company
"Practice random kindness and senseless acts of beauty."

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads