Trimble Business Center

 View Only

 mass point comparisons

Frank Poetschke's profile image
Frank Poetschke posted 07-30-2024 01:53

Hello,

I look for a function to perform point comparisions in mass processing. I want to selcet many points and select one main point to get a list with horizontal and vertical offsets from each point to main point. Can anyone advice me such function or workflow?

look forward you answers

Frank Pötschke

Ronny Schneider's profile image
Ronny Schneider

Do you want that as CSV/Excel spreadsheet or as text in the drawing?

I've got a reports macro for point-to-point comparison, and relative to a set bearing if necessary.

It's meant to find the next closest design point for each as-built point but can be used for your case as well by setting the search radius just large enough.

Frank Poetschke's profile image
Frank Poetschke

Hello Ronny,

We always have to check ourselves at numerous fixed points and report this to the client. A list (excel or csv) would make the most sense. The many individual control measurements relate to the respective fixed point.
I would like to try out your macro for this. Can you please send it to me?

Frank Pötschke

Ronny Schneider's profile image
Ronny Schneider

Hello Frank,

either download the whole compilation from GitHub https://github.com/RonnySchneider/SCR_Macros_Public

It might take a moment until the download starts, that's a GitHub thing.

The large size comes mainly from the videos in the Help folder.

There is a section about the installation, it differs slightly from the below mentioned standalone version.

Or find attached a standalone version. Unzip it somewhere into "C:\ProgramData\Trimble\MacroCommands3".

And make sure that this whole folder has read/write access. Since V5.90 Trimble is write protecting this folder every time you install/update TBC. Which makes lots of sense when TBC might try to compile/write macros during startup.

Adding additional CSV output should be fairly simple, I had thought about it before but never really needed it.

ANZ Toolbox's profile image
ANZ Toolbox

Hi Frank,

There's a powerful Point Conformance Report that comes installed with TBC (but that you'll need a license for) that will create a nicely formatted and customizable Excel report and also allows for visualization of point deltas in the plan and 3D views. It can pair the points either by proximity or by matching point Ids.

Visualization options look like this:

There's some more detailed documentation along with a demo video here.

Like I said you will need an ANZ Toolbox license to run this but if you contact your dealer they will be able to supply you with a demo license.

Regards,

ANZ Toolbox.

Ronny Schneider's profile image
Ronny Schneider

Did you see Franks email? He is from Sitech Germany, he represents the dealer you recommend.

They or their customers might see it my way. Why pay additional money for something that the core product could potentially provide if Trimble would just want it to. Using our "maintenance" fees for its intended purpose and listen!!!! to the customers. Improve the usability of the existing and not leaving it to some third party extra to pay for add-ons.

If it's really just needed in Excel, and if it's one single point that everything needs to be compared against, I'd would just go with an Excel spreadsheet and a formula.

ANZ Toolbox's profile image
ANZ Toolbox

Hi @Ronny Schneider (hope I'm tagging the right Ronnie on here - there are like 4+!),

Yeah I saw the .de domain and realized it was a German address (metric users - yes!) but admittedly didn't clock that it was a Sitech one (my bad).

@Frank Poetschke pretty sure the commands we have already will solve your needs. These commands are part of TBC (just another module), so they always work DAY-ONE with new TBC releases, and we also release updates in-between the TBC release cycle (bug fixes and enhancements) which update via the Check-For-Updates functionality.

Frank - if you can't get a demo license to try these commands out then please let us know: anztoolbox@sitechcs.com

Frank Poetschke's profile image
Frank Poetschke

Hello ad all and thanks for you support.

Indeed Trimble sent me an solution, quite simple. I share it with you here:

  • First set the search criteria and tolerance using report options  and
  • Then just select the "main point" ONLY
  • Run the point comparison report
  • So this is what we need for the moment and it is function included within TBC.
    thank you again and best regards
    Frank Pötschke
Ronny Schneider's profile image
Ronny Schneider

Fair enough, if you're happy with this kind of basic delta easting/northing report.

Truth be told I didn't remember or think of the internal reports. Usually I find them way too cumbersome to tailor to my specific needs and I prefer to report with a graphical context.