[RESOLVED] [2005] Look-up Table

I need to do manipulation with my incoming data fr serial port n need to have a look-up table for this purpose, starting from 0.0dB and 30H data. For every increment of hex value, the level increases by 0.5dB.

My data has been converted to hex format, then i need to convert it to dB value based on the look-up table. How can this be done?


This is what i mean:
LEVEL DATA
0.0dB 30H "0"
0.5dB 31H "1"
1.0dB 32H "2"
.
.
.
15.0dB 4FH
.
.
49.5dB 93H
50.0dB 94H

You don't need a lookup table for this... All you need to do is some function that do this:
dB = ConvertToDec(currentHexValue) - 48 * 0.5
Here is a little function that I did for you. Just pass in the current hex value and it'll spit out the dB

VB Code:

Private Function Translate2dB(ByVal strHexInput As String) As String
        Dim retval As String = "0.0 dB"
        Dim inputVal As Integer = 48
        Dim diff As Integer = 0
        Try
            'Convert Hex to Dec
            inputVal = Val("&H" & strHexInput)
            'Find the different
            diff = inputVal - 48
            'Then multiply the diff by 0.5
            If diff > 0 Then
                retval = (diff * 0.5).ToString("0.0") & " dB"
            End If
        Catch ex As Exception
            Return "Error"
        End Try
        Return retval
    End Function

You can use it like this:

VB Code:

Dim myCurrentHexValue As String = "4F"
TextBox1.Text = Translate2dB(myCurrentHexValue)

thanks stanav for your great help...