I have a problem which I was hoping someone could help with.
I have entered approx 40 x, y, z co-ordinates into microstation using the XYZ text tool box.
What I would like to do is get microstation to find either a line of best fit or an arc of best fit by selecting a series of points. Once the line/arc has been created I want to know how far away the points are from the line or arc.
After browsing the functionality I have struggled to come up with anything. I am currently using Microstation Select Series 2.
Can anyone help?
(I’m a bit dense so screen shots will help a great deal. Lol)
Stewart Souten said:After browsing the functionality I have struggled to come up with anything. I am currently using Microstation Select Series 2.
Have you checked all Curve Functions Toolbox from Microstation?
There is a Curve by Equation tool, also, but no help in the help file
since 1985: CAD/GIS : [Esri ArcMap , Bentley MS V4 - V8i, GeoGraphics, Map, InRoads ; AutoCAD , HHK Geograf , IBr DAVID, AED-SICAD ] Dev: [C, C++, Basic , Java, SQL, FORTRAN, UML][direct quote by: http://en.wikipedia.org/wiki/Helmut_Schmidt]: "Wer Kritik übel nimmt, hat etwas zu verbergen"
I used curve by equation tool a few times back in J and it only used to plot a curve given the equation not find the equation but it may have changed I'll have to go back and take a look .. might even have an old J training book lying around
MicroStation user since 1990 Melbourne Australia.click link to PM me
stefan_bernsdorf said:Looks like a VBA job to me …
We created a MicroStation VBA project to perform a linear best-fit regression analysis.
You can read about the VBA regression analysis project, and download a ZIP file. The ZIP file contains the complete VBA project, including source code. You can view and modify the code to suit your needs.
Stefan Bernsdorf kindly contributed to this VBA project. He added code to use a selection set of MicroStation elements as a data source. The code on our web site incorporates his ideas. Thanks, Stefan!
Regards, Jon Summers LA Solutions
I tried running it with just 9 points but it doesnt seem to work for me
do you put all the active points into a selection set then run the macro?
it seems to always put the answer in the same spot... no matter where I have my points...
I just realised its linear only but it still does it in the same spot with new points as crosses..
If it was working from selection then Id expect it to land near original points ...hmmm looking at the code I'm no closer to why?
Lorys said:It seems to always put the answer in the same spot
The VBA example provides its own data, with the GetData method. It's not looking for any other data.
Lorys said:Do you put all the active points into a selection set then run the macro?
I made no claim about active points or selection sets. The example illustrates a programmatic solution to the original question. If you want to collect data from another source, it's up to you to modify the code to achieve that.
Stefan Bernsdorf has kindly added code to use a selection set of MicroStation point objects. His additions are included in the modified VBA project available here.