Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

**Talamon** · 02-14-2014, 05:43 PM

All,

I have several fields where I am attempting to convert a signed binary angle (either 16 or 32 bit) into hexadecimal. Normally I would use the Windows programmer calculator, but I can't seem to use the decimal period on that program for some reason (guess there's an issue converting the decimal period into hex with that program?).

Here are specific examples:

1) Signed Binary Angle - 16 bit: My value range is from -90.0000 to +89.9973 and I want to convert this into a 2-byte hexadecimal.

2) Signed Binary Angle - 32 bit: My value range is from -90.000000000 to +89.999999958 and I want to convert this into a 4-byte hexadecimal.

If I was inputting my value into cell A1 and having this conversion and reporting take place in cell B2, what function would I use? I attempted to use the following with no avail: =DEC2HEX(A1,4).

Any help would be appreciated! Thanks for reading.

Respectfully,
Talamon

**daffodil11** · 02-14-2014, 06:02 PM

I think the function you're looking for is DEC2HEX

**Talamon** · 02-18-2014, 12:53 PM

Originally Posted by daffodil11

I think the function you're looking for is DEC2HEX

My apologies as I mis-typed in my original post. However, the DEC2HEX function still did not work as it is having a hard time converting the decimal point.

**shg** · 02-18-2014, 12:56 PM

Give some examples of the conversions you want.

As an aside, a 32-bit value would take 8 hex characters to encode.

**shg** · 02-18-2014, 01:08 PM

I think this is what you asked for:

	A	B	C
1	16-bit
2	-90.0000	8000	B2: =RIGHT(DEC2HEX(32768 * $A2 / 90), 4)
3	89.9973	7FFF
4
5	32-bit
6	-90.000000000	80000000	B6: =RIGHT(DEC2HEX(2147483648 * $A6 / 90), 8)
7	89.999999959	7FFFFFFF

However, one would more typically encode angles between -180 and +180 to get the circularity.

**Talamon** · 02-18-2014, 02:43 PM

Originally Posted by shg

I think this is what you asked for:

	A	B	C
1	16-bit
2	-90.0000	8000	B2: =RIGHT(DEC2HEX(32768 * $A2 / 90), 4)
3	89.9973	7FFF
4
5	32-bit
6	-90.000000000	80000000	B6: =RIGHT(DEC2HEX(2147483648 * $A6 / 90), 8)
7	89.999999959	7FFFFFFF

However, one would more typically encode angles between -180 and +180 to get the circularity.

I am working out the conversions of Latitude and Longitude from the decimal to the hexadecimal (hence why the -90 through ~+90).

Why my book calls it a "Signed Binary Angle" is a mystery for me...

However, your solution works for my particular problem. Thanks for your support shg!

**Talamon** · 02-18-2014, 03:47 PM

Originally Posted by shg

I think this is what you asked for:

	A	B	C
1	16-bit
2	-90.0000	8000	B2: =RIGHT(DEC2HEX(32768 * $A2 / 90), 4)
3	89.9973	7FFF
4
5	32-bit
6	-90.000000000	80000000	B6: =RIGHT(DEC2HEX(2147483648 * $A6 / 90), 8)
7	89.999999959	7FFFFFFF

However, one would more typically encode angles between -180 and +180 to get the circularity.

Out of curiosity, how did you come up with the "32768" and "2147483648" values?

**shg** · 02-18-2014, 02:59 PM

IF you scale between -180 and 180 instead of -90 and 90, it's a very easy format to use for trig functions, because all values are valid, they can be regarded as signed or unsigned, and they wrap circularly the way trig functions do, i.e., sin(361 degrees) = sin(1 degree)

I am working out the conversions of Latitude and Longitude ...

Perfect point; longitudes range between +/-180, not +/-90.

**Talamon** · 02-18-2014, 03:48 PM

Originally Posted by shg

IF you scale between -180 and 180 instead of -90 and 90, it's a very easy format to use for trig functions, because all values are valid, they can be regarded as signed or unsigned, and they wrap circularly the way trig functions do, i.e., sin(361 degrees) = sin(1 degree)

Perfect point; longitudes range between +/-180, not +/-90.

Agreed, but my question was only working on the latitude portion. My thoughts were that, once I figured out how to work the latitude (with the help of kind and smart folks like yourself), I should be able to modify the formula for the longitude portion.

**shg** · 02-18-2014, 04:08 PM

Google binary angle measurement system, e.g., http://en.wikipedia.org/wiki/Binary_...#Binary_angles and http://www.globalspec.com/reference/...ngular-measure

**Talamon** · 02-18-2014, 04:18 PM

Originally Posted by shg

Google binary angle measurement system, e.g., http://en.wikipedia.org/wiki/Binary_...#Binary_angles and http://www.globalspec.com/reference/...ngular-measure

Those articles made no sense to me. Can you just give me the 'dumbed-down' version?

**shg** · 02-18-2014, 04:20 PM

Where are we starting from? Do you know how numbers are represented in binary? Do you know what twos-complement means?

**Talamon** · 02-18-2014, 04:53 PM

Originally Posted by shg

Where are we starting from? Do you know how numbers are represented in binary? Do you know what twos-complement means?

I have never dealt with binary or hexadecimal in great detail before a week ago. I'm trying to write a spreadsheet that takes people's inputs and converts it from a decimal into a hexadecimal. Here is my project (attached):Project_Help.xlsx

Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Re: Signed Binary Angle (16 or 32 bit) converted into Hexadecimal

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hexadecimal to binary

[SOLVED] Hexadecimal 'of a cell' to Binary

Excel 2007 : Hexadecimal to Binary conversions

[SOLVED] Hexadecimal to Binary Conversion

Formula for converting Binary to Hexadecimal

Bookmarks

Bookmarks

Posting Permissions