How do I use ceiling , floor math functions | VB.NET

Question

1.00/5 (1 vote)

See more:

Hello again, I need to use these math functions in my problem.

First of all, I have an list of values which first I use the abs and log10 math functions.
Now, I need to use these 2 equations in that array.

1. x=ceil(30*log10(arrData))+1
2. y=floor(30*log10(arrData))

And then, I need to make this calculation : newsetdata=y-x+1

I create 2 lists, the 1st is the arrData which I used the ceiling , and the arrData2 is the floor.

now I want to create a new list that I can use this equation -> arrData2-arrData+1 and I can't do this...some help?

What I have tried:

Dim strFileName = IO.File.ReadAllLines("C:\Users\x-ios\Desktop\1234.txt")
Dim cu As Globalization.CultureInfo = Globalization.CultureInfo.CreateSpecificCulture("en-US")
Dim style As Globalization.NumberStyles = Globalization.NumberStyles.Number Or Globalization.NumberStyles.AllowCurrencySymbol

Dim arrData = strFileName _
.Select(Function(x) New With _
{
.FirstCol = Math.Ceiling(Math.log10(Math.Abs(Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(0), style, cu))), _
.SecondCol = Math.Ceiling(Math.log10(Math.Abs(Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(1), style, cu)))) _
}) _
.ToList()


Dim arrData2 = strFileName _
.Select(Function(x) New With _
{
.FirstCol = Math.Floor(Math.log10(Math.Abs(Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(0), style, cu)))), _
.SecondCol = Math.Floor(Math.log10(Math.Abs(Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(1), style, cu)))) _
}) _
.ToList()

Posted 18-May-17 23:59pm

x-ios

Updated 19-May-17 11:02am

v3

Add a Solution

Comments

OriginalGriff 19-May-17 6:39am

And?
What is the problem?
Where are you stuck?
What help do you need?
Have you looked at the official documentation, and if so, why didn't that help you?

x-ios 19-May-17 6:54am

Yes, you are right. I update the question...

Maciej Los 19-May-17 15:51pm

arrData2-arrData+1 ???
arrData is a set of data: FirstCol and SecondCol. What calculation exactly do you need?

x-ios 19-May-17 16:05pm

Yes, anewsetdata=arrData2-arrData+1.
How can I do it?

Maciej Los 19-May-17 16:06pm

Sorry, but are you blind? arrData is set of data. Please, read my previous comment.

x-ios 19-May-17 16:16pm

I want to: (sub the FirstCol of arrData2 from FirstCol of arrData )+1 (sub the SecondCol of arrData2 from SecondCol of arrData)+1 and store them to a new data set. I accomplished only the 1D, not the 2D.

Maciej Los 19-May-17 16:38pm

What sub() means? subtraction?

x = sub(Floor(FirstCol) ? Ceiling(FirstCol))+1
y = sub(Floor(SecondCol) ? Ceiling(SecondCol))+1

but you mentioned:

x=ceil(30*log10(arrData))+1
y=floor(30*log10(arrData))

What is correct calculation? Please provide complete equation!

x-ios 19-May-17 16:47pm

Yes, I mentioned that x=ceil(30*log10(arrData))+1 , y=floor(30*log10(arrData)), and I accomplished them (arrData is the x ,and y is the arrData2) . And now I need : newdataset=y-x+1
(I update the question, because I forgot to mentioned it, by mistake)

x-ios 20-May-17 6:04am

Thank you very much fr your help, now, how can add each result from this equation (y-x-1) to a new dataset? But, to the same dimension as the arrData? It means in a new 22x2 dataset.

Maciej Los 21-May-17 14:13pm

If you want to create 2 dimensional array, i'd suggest to read this: How to: Initialize a Multidimensional Array. This might be helpful too: VB.Net - Arrays.


Dim destArray(,) As Integer  = New Integer(arrData.Length, 2);
Dim i As Integer = 0
For  i = 0 To arrData.Length-1
    Dim x = Math.Ceiling(30*Math.Log10(d.a))+1
    Dim y = Math.Floor(30*Math.Log10(d.b)) 
    destArray(i,0) = x
    destArray(i,1) = y
Next

x-ios 22-May-17 4:25am

Hello, thanks for the reply. It doesn't work, I had an error: because the length is not a member of list(). http://tinypic.com/r/242zdqw/9
And, I have a problem.My all output numbers are not 0.07 but 7. Do you know why ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2017-05-19T11:02:00

Quote:
Yes, I mentioned that x=ceil(30*log10(arrData))+1 , y=floor(30*log10(arrData)), and I accomplished them (arrData is the x ,and y is the arrData2) . And now I need : newdataset=y-x+1
(I update the question, because I forgot to mentioned it, by mistake)

All you need to calculate result is:

VB.NET

Dim arrData = strFileName _
	.Select(Function(x) New With _
		{
			.a = Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(0), style, cu), _
			.b = Double.Parse(x.Split(New String(){Microsoft.VisualBasic.vbTab}, StringSplitOptions.RemoveEmptyEntries)(1), style, cu) _
		}) _
	.ToList()

	For Each d In arrData
		Dim x = Math.Ceiling(30*Math.Log10(d.a))+1
		Dim y = Math.Floor(30*Math.Log10(d.b)) 
		Console.WriteLine("{0}-{1}+1={2}", y, x, y-x+1)
	Next

Reult:

-11--38+1=28
-8--35+1=28
-5--33+1=29
-3--31+1=29
-1--30+1=30
0--29+1=30
...

Change the code to your needs, if i misunderstood you.