How do I calculate a value between two object attributes within a range

KennethLindhardt

I will try to explain this, and hopefully it will make sense 😉 

I got a building building height left and a building height right. Since they are delivered from Lidar, those are not completely equal, but can vary with 0.3 m for a gable roof. What I would like to do is to get the color “red” if left and right minus each other has a range from -0.3 to 0.3

In Ecxel it could look like this:

=IF(AND(Left-Right>=-0.3; Left-Right <=0.3);"Yes"; "Shape") So this brings a Yes if my calculation is between -0.3 and 0.3.   

KennethLindhardt

Hi Matt. That’s perfectly fine, I’ve been busy anyway. Yes this is kinda still an issue to me, but at this point I have no idea if it would ever work, since I do not have the right data to test it on. I think I’ve solved my own question, but it seems to be a long way around. I sat up to two allowed differences. 0.3 and -0.3, then I could take the left_H – Right_H < Dif_1(0.3) && left_H – Right_H >Dif_2 (-0.3) Then all the other calculations…. If front and back are above 1 m from right and left, create a gable roof. Well because I had  5 pionts to calculate on, and the Lidar data was not giving me some prober information, I had to many wrong heights on my points, that meaning I had to many calculations. If Right_H was 0 I had to go another way, if center was hitting a chimney, take that one out of the calculation, and so on. So probably I need to read up on my math skills, and get some better Lidar data before I continue.

This is still interesting to me, and I will get back to the threat at some point, but I don’t want to load any work on you on this one by now.