What is the distance of a point to the best-fit plane defined by a cloud of points?

[bmark0225]

Hi Forum ,

I down loaded an excel sheet from shg . which is very good for calculation the distance of a point to the best-fit plane defined by a cloud of points
Could anyone help to code it by using vba?

Thanks in advance

-m

[Kaper]

the calculations from the worksheet can be simply replicated (not optimized for VBA just coded in VBA what has been done as worksheet functions) with such VBA function:

Please Login or Register  to view this content.

You may use it within other pieces of code for instance

Please Login or Register  to view this content.

or directly in the worksheet as for instance:

Please Login or Register  to view this content.

[bmark0225]

Thanks Kaper for the help
Much appreciate it !!!
-m

[Kaper]

Glad to hear so.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that on our forum you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.