(API) Models Comparison 1.0

[StefanoPasquini6790]

Hi everyone,

I've just published another tool for all the Robot Users.

You can download for free the API here: http://www.pasquiniprogetti.it/?p=934

Let me know your feedback.

Cheers

[Rafal.Gaweda]

Cool
I will add it to our list.

[Rafacascudo · Accepted solution]

Bravo Stefano!! seems to be a great toll!

thx!

[Anonymous]

Can you please explain it in English.

Thank you.

It is great job & coding.

[StefanoPasquini6790]

Just select the english flag on screen. You can find it also in french, deutch, spanish and portoguese.

Cheers

[rokas_varanauskas]

does this work with 2024 version? I've tried it with several models and I only get macro errors if I click to get model data

[Stephane.kapetanovic]

hi @rokas_varanauskas 

Some variable types don't appear to be defined. These are minor changes. Please reach out to the author on their website for an update.

Best Regards

[StefanoPasquini6790]

Good Morning,

Probably you've changed you excel installation (version or machine).

Well, to solve your issue you have to add Robot Kernel Object Model in the excel VBA Reference.

To do this you have to:

1. Open the Excel Spreadsheet;
2. Press Alt+F11
3. In "tools" click on "Reference" 
4. Then Remove (uncheck) the current Robot Kernel Object Model (That is the old one) and search for Robot Kernel Object Model ver 25.0 (That is the current one) and check it, than click on the "OK" button and the API will work again.

have a nice work, I hope my spreadsheet speed up your workflow

[rokas_varanauskas · Accepted solution]

Thanks Stefano! it was indeed missing Reference to Robot Kernel object. For some reason it was looking for ver. 16 but unticking it and then ticking ver.25 as suggested did the trick and macro works again. Thank you for your support. 

[rokas_varanauskas]

So after running comparison between two model revisions with some time apart I found one issue which I haven't got the solution for. 

The issue:

Since all data rows are rows are ordered by ID column and followed by BAR NUMBER AND CROSS SECTION, comparison part does not always work correctly if new bars are added or removed as in my example:

as shown above, macro reports 310 different bars, however true change should be around 12 (6 No bars deleted, and 6No bars changed cross section size). 

This is due to direct row comparison starting from ID 

I understand that this is more complicated than just doing comparison check within the same data row. 
If I will come up with a solution to above, I will post revised code here. 

[StefanoPasquini6790]

Unfortunately the API works only for identical models, I mean that the two models need to be with the same bar number for EACH element.

You can try to change the comparison criteria in the VBA script

Good luck

[rokas_varanauskas]

attached if a modified VBA code which list cross section sizes side by side and column P check if sections sizes are the same. Apologies for butchering your VBA but someone may find this also useful.