Log Function

free web hosting

Open Discussion > MODERATED AREA > Computers > Programming Languages > VB Programming

Log Function

kvarnerexpress

Sep 5 2005, 08:49 AM

Hi all.

I have some prob with log function.
The code below is not working, it returns a false value.
The value is not same with what I calculate using scientific calculator.

Using my program:
N=2
Na=1
log(N/Na)=0.6931

Using scientific calculator:
N=2
Na=1
log(N/Na)=0.30102999566

Code:

CODE

Na = 0
temp = 0
temp1 = 0
rs.MoveFirst
Do
For column = 1 To rs.Fields.Count - 1
'If rs.Fields(column) <> Null Then
If Not IsNull(rs.Fields(column).Value) Then
Na = Na + 1
End If
Next column
N = rs.Fields.Count - 1
temp = Log(N / Na)
temp1 = Format(temp, "0.0000")
rs2.AddNew
rs2!Na = temp1
rs2.Update
Na = 0
rs.MoveNext
Loop Until rs.EOF

kvarnerexpress

Comment/Reply (w/o sign-up)

Galahad

Sep 6 2005, 07:25 AM

Yes, I had that same problem once...
In Visual Basic, LOG function is returning a value of natural logarithm (base2), whereas in math LOG specifies Base10 logarithm (or at least I think so). Now, in scientific calculator, you might have noticed LN button, just above the LOG button. If you do that function, you will get the value you want. So, in order to get the numbers you need, use this code or put it in a function:

CODE

Public Function MyLog(ByVal Number As Double) As Double
MyLog = Log(Number) / Log(10)
End Function

This should give you the values you need, so your code might look something like this:

CODE

Na = 0
temp = 0
temp1 = 0
rs.MoveFirst
Do
For column = 1 To rs.Fields.Count - 1
'If rs.Fields(column) <> Null Then
If Not IsNull(rs.Fields(column).Value) Then
Na = Na + 1
End If
Next column
N = rs.Fields.Count - 1
temp = Log(N / Na) / Log(10)
temp1 = Format(temp, "0.0000")
rs2.AddNew
rs2!Na = temp1
rs2.Update
Na = 0
rs.MoveNext
Loop Until rs.EOF

Comment/Reply (w/o sign-up)

dul

Oct 20 2005, 02:34 AM

Hi. It is must be a same result. Because mathemathics didn't change. Check your code.

Comment/Reply (w/o sign-up)

Similar Topics

Keywords : log, function

Converting To Unix Timestamp
Function to convert standard time format to Unix timestamp (1)

Similar

Converting To Unix Timestamp - Function to convert standard time format to Unix timestamp

Searching Video's for log, function

See Also,

Javascript Onclick Call Function Find Function

Function Onclik Dont Call Function

Close Box Function Open Popup Function

Convert Printf Function Sprintf Function

Write Program Function Counts Number Primes Range 1 Write Test Cases Function

Function Php File Function Print

Write Function Counts Number Primes Range 1 Write Test Cases Function

Call Function Function Php

Php Call Function Function

Php Url Function

Md5 Function Php

Run Php Function

Php Run Function

Vb6 Log Function

Run Function Php

Vb Log Function

Php Function Run

Bin Hex Function

Php Function Bad Word

Php Function Printing

Calls Function Php

Url Function Actionscript 3

Parser Function

Bluetooth Function Pc

Url Function Actionscript 3

Php Refresh Function

Link Php Function

Php Print Function

Function Set Background

Php Reload Function

Watermark Php Function

Function Php Examples

Marquee Php Function

Php Link Run Php Function

Php Function Enclose Div

Function Count Php

Call Php Function As3

Add Function Object Php

Char Buf Function

Java Function Url

Php Function Create Url

Function Url Exists

Php Call Function

Php Function Sum Date Day

Function Php Decrypt Md5

Running Function Php

Href Function Php

Call Function Php

Function Server

Php Mail Function

Call Div Php Function

Php Href Function

Php Asynchronous Function

Call Function Url Php

Function Getpassword

Run Function Echo

Display Function Php

Php Function Link

Btn Calling Function As2

Print Function Php

String Function

Calling Function Php

Create Function Add Sql

Php Function Sum Date Day

Function Delimiter

Gmx Mail Function

Php Execute Function

Mailto Function Php

Reduce Function

Mailto Function Php

Php Open Function

Sql Compare Function

Mailto Function Php

Php Header Function

Call Swf Function Swf

Bst Remove Function

Php Watermark Function

Function Add Image Php

Php Div Call Function

As3 Global Function

String Function

Php Login Function

Login Function Sql Php

Clause Function

String Function

Php Function Click

Function Phpini

Sendmail Function Php

Php Function Execute

As3 Delay Function

Php Href Function

Datetime Php Function

Mail Function Php Ini

Enable Php Function

Location Php Function

Login Function Php

Php Link Function

String Function

Php Ping Function

Call Div Div Php Function

Function Nextpicture

Php Printing Function

Function Movieclip As2

Function Calls Php

Function Submit Jsp

Php Call Dll Function

Add Include Function

Vb6 Function Array

Function Link Php

Php Stop Function

Global Function As2

Call Function Php

Php Messagebox Function

Run Function Link Php

Login Function Sql Php

Wait Function Php

Php Search Function Url

Log Function Code

Php Function Call

Login Function Phpbb

Calling Function Perl

Php Header Function Hyperlink

Onclick Input Php Function

Function Count Lines Php

Php Link Calls Function

Php Mail Function Joomla

Php Script Move Function

Php Mail Function Html

Form Call Function Php

Onclick Input Php Function

Unix Date Function

Button Function Delphi

Mail Function Spam

Array Function Vbs Append

Php File Function Part

Xampp Mail Function

Link Call Php Function

Java Link Function

Convert Long Int Int Function

Href Click Php Function

Educational Slogan Function

Bash Empty Function

advertisement

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com