Editing load cases in excel? API?

[bjornhgr]

In order to create envelope diagrams, I'm about to create separate load cases for each span of a 30-span bridge and both symmetric and asymmetric loads. Is there a way to edit the load cases i excel, or do I have to create them all in Robot?

Thank you!

@bjornhgr Artur Kosakowski marked Rafal Gawenda's post as the solution. If it did not work as an answer, please post your reply in this thread so that I can unmark the solution. 

[jack.sanden]

Hi

I've recently started using Excel with Robot and I'm really thankful for these small excel-programs you've created Rafal. I am however trying, using your (Rafal's) scripts as models, to modify a program more suited for my needs. One of the things that I can't get to work, when it comes to importing and updating load records, is applying the same load to several bars at ones (I'm creating a program using Uniform loads). The importation to Excel works, but I can't later on update the same cell into Robot. Does anyone have any ideas how to do this?

Thankful for answers

Best regards

Jack

[rsousa_]

Have you tried doing this? following variable names from API tutorial...

...

Dim rec As IRobotLoadRecord

...

rec.Objects.AddText (Cells(xxx, yyy).Value)

At cells(xxx, yyy) you should have all the bars that you want the load to be applied like 1to10 or 2 3 4 7 10...

Of course this will add to already aplied bars... if you want only the bars selected in excel, you will have to exclude that objects first. 

Regards

[Rafal.Gaweda]

Generally first you have to find out which record to update.
Either but checking objects (.Objects) assigned to such record (compare selections...) or you can store somewhere which excel row corresponds to which record in robot

[1090174]

Hi Rafal,

I have a excel file with your API for extract the internal forces from Robot File, works perfectly! but i want extract a "case name" and "nature" as well. Can you tell me the code for extract thit?

thank you

regards

[rsousa_]

have you tried, for example:

CaseCol.Get(j).Name
CaseCol.Get(j).Nature

of course nature will be 0 - permanent, 1 - exploatation, 2 - wind and so on.

Regards

[Rafal.Gaweda]

Example:
http://forums.autodesk.com/t5/Robot-Structural-Analysis/Editing-load-cases-in-excel-API/m-p/3929901#...

[1090174]

Done! 

Thank you both!

regards

[mgaafar]

Hi,

   I was trying to copy the loads from the loads tab table to excel and edit it and paste it back in to ROBOT.

it seems there is a bug because it does not read back the data properly and mixes cells.

am i doing something wrong or it is a bug?

video link:

http://autode.sk/1VqaCVy

http://www.screencast.com/t/wUuzzAf9Dxbv

[mgaafar]

Thanks Rafal!!

[Grohl]

This Excel-macro is awesome.

Add this if you want to be able to input different SLS-types:

    ElseIf ctn = "sls:chr" Or ctn = "SLS:CHR" Then
        CT = I_CBT_SLS_EC_RAR
    ElseIf ctn = "sls:qpr" Or ctn = "SLS:QPR" Then
        CT = I_CBT_SLS_EC_QPR
    ElseIf ctn = "sls:fre" Or ctn = "SLS:FRE" Then
        CT = I_CBT_SLS_EC_FRE

[Grohl]

Or maybe something like this is better then you don't have to worry about lower/upper case.

    If LCase(ctn) = "uls" Then
        CT = I_CBT_ULS
    ElseIf LCase(ctn) = "sls" Then
        CT = I_CBT_SLS
    ElseIf LCase(ctn) = "sls:chr" Then
        CT = I_CBT_SLS_EC_RAR
    ElseIf LCase(ctn) = "sls:qpr" Then
        CT = I_CBT_SLS_EC_QPR
    ElseIf LCase(ctn) = "sls:fre" Then
        CT = I_CBT_SLS_EC_FRE
    ElseIf LCase(ctn) = "acc" Then
        CT = I_CBT_ALS
    End If

[SPadID02]

Hi

First off thank you for this, the tool is great! And for the standard cases this works perfectly but I can't seem to implement the additional SLS cases.

The macro creates all of the cases and I can review the results for the SLS:CHR/FRE/QPR cases and can see them in the Combination Table however the type is blank. The combination interface is also blank so can't change the type manually and the design modules do not recognize them as SLS combinations. Has anyone implemented this successfully?

Thanks

Section of code below in case there are any obvious errors that I have overlooked

    If ctn = "uls" Or ctn = "ULS" Then
        CT = I_CBT_ULS
    ElseIf ctn = "sls" Or ctn = "SLS" Then
        CT = I_CBT_SLS
    ElseIf ctn = "acc" Or ctn = "ACC" Then
        CT = I_CBT_ALS
    ElseIf ctn = "sls:chr" Or ctn = "SLS:CHR" Then
        CT = I_CBT_SLS_EC_RAR
    ElseIf ctn = "sls:fre" Or ctn = "SLS:FRE" Then
        CT = I_CBT_SLS_EC_FRE
    ElseIf ctn = "sls:qpr" Or ctn = "SLS:QPR" Then
        CT = I_CBT_SLS_EC_QPR
    End If
    Dim cmb As IRobotCaseCombination
    
    If loads.Exist(n) Then
        Set cmb = loads.Get(n)
        cmb.name = name
        cmb.CombinationType = CT
    Else
        Set cmb = loads.CreateCombination(n, name, CT, I_CN_EXPLOATATION, I_CAT_COMB)
    End If

[Rafal.Gaweda]

Hi @SPadID02

Unfortunately due to software issue in ROBOT API implementation is it not possible to get\set:

SLS-CHR
SLS-QPR
SLS-FRE
FIRE

types by API

The issue is registered for correction.

[SPadID02]

Ah, thought that might be the case. Thank you for confirming Rafal.

I look forward to when it is corrected.

[anton.ahlsten]

Hi

Is this excel file limited to 25 basic cases?

I try to use it for a model with 27 basic cases, and on the combinations sheet the last two basic load cases are replaced with the first two "from combinations".

Thank you for a (otherwise) great file!

[Rafal.Gaweda]

Hi @anton.ahlsten

Let's say it is limited to 25 but You can modify it.

1. On Combinations tab, starting from AA column , cells in 3 and 4 row are wrongly filled \ not filled.

Fill it in similar way as in previous columns (let's say till the end of grey cells)

Example for AA column:

2. Open VBA editor (ALT+F11)

and replace 26 by 52 here:

[anton.ahlsten]

What about the values? The factors from combinations seem to get written to the same cells as before. I'm not very familiar with VBA so I'm not sure what the change in the code was supposed to do.

[Rafal.Gaweda]

hi 

@anton.ahlsten

Bump

[anton.ahlsten]

Yes, I can see the problem now. When I'm using load combinations as basic load cases as well as having 27+ basic load cases, the factors from load combinations get written to the same columns as the last basic load cases.

Maybe I'm asking for too much, but do you know any way to make the xls file adaptive to the number of basic load cases imported?