Excel´s mround function in grasshopper

Grasshopper
1

Hi.

I have been struggling to find a similar Excel´s mround function in grasshopper.

Mround rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

Example:

Rounding the numbers
5.76 - 6.00
5.74 - 5.50

In excel, the expression for these example are:
=mround(x;0.5)

Any help?

2

Pufferfish has a round to nearest component.

round%20to%20nearest
round to nearest.JPG1091×368 25.4 KB

1 Like
3

had to think of this:

round_nearest
round_nearest.PNG896×286 26.7 KB

2 Likes
4

Hey Amir

Thanks for your answer.

The item 1 is not rounding correctly… should be 6.00…

5

Hi Rickson.

I´m going to try, but this is a simple excel/google spreadsheet formula… shouldn´t need a plugin for this…

6

actually, no. it would be 5.85 if f=0.05
check the screenshot & try it out yourself!

round_nearest2
round_nearest.gh (5.5 KB)

edit: i guess you edited your post?

3 Likes
7

i think mround always rounds up…
CEILING works in grasshopper expressions. (which may be helpful here… i’m not at a computer to mess around with it)

8

Hey Amir

Yes. I had edited

I tested your formula… not quite working, as the item 4 should round to 0.65, not 0.6 (it should round up). Any thoughts?

In order to get that list on the right, I copied and pasted from google sheets using the mround (=mround(x;0.5))

Thanks

image
image.png862×464 28.3 KB

9

as jeff_hammond suggested, ceiling works.

ceiling_nearest
ceiling_nearest.PNG980×489 30.3 KB

1 Like
10

The result you have is not unexpected. It all depend on double precision and other problem. Tell me which number between 0 and 2 is nearest to 1? You will say me none or the two. Algorithm round has to choose one number. It is.possible that grasshopper algo slightly different than excel one.

11

Mround rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

12

I looked with Excel and Grasshopper.
You will have 0.65 with Grasshopper if you add 0.0000000000001 (or less) to 0.625 ! Excel must have a <= and Gh (.Net surely) <.

13

.Net round has two MidpointRounding modes. .Net’s Default is .ToEven which is called bankers rounding but you can set it to .AwayFromZero

So like

Math.Round(2.5, MidpointRounding.AwayFromZero);

will result in 3.0 instead of 2.0.

1 Like
14

I just updated Pufferfish and the V2.1 has a “Round To Factor” component for this.

Capture

2 Likes