Reporting Cap Thickness (Tcap) using Spreadsheet Utility

[Ruben]

Hello,

We are trying to report the tcap for a Cap Beam concept using the spreadsheet utility but none of the keywords appear to work. I've also tried all the KeywordIds from 100 to 123 and also tried up to 140 by creating some dummy keywords, but can only get 109 to work, which is top flange width. It should be keyword tt, or KeywordId=111, which is top flange thickness.

Thanks,
Ruben

[James]

Hi Ruben,

The cap beam thickness is stored as the "vpdCap_ThicknessMaterial" variable.

A quick fix for the spreadsheet is to reference the KeywordId.BottomFlangeThickness to the vpdCap_ThicknessMaterial variable. See case statement below.

In the "GetVariableId" function...

  Case KeywordId.BottomFlangeThickness
            If objGroup.Family = bpfCorrugatedStiffenedPanelFamily Or _
               objGroup.Family = bpfUniaxialStiffenedPanelFamily Or _
               objGroup.Family = bpfOpenBeamFamily Then
                enmVariableId = vpdCap_ThicknessMaterial

I hope this is helpful.

-James

[Ruben]

Thanks, that worked. Will that be updated in the next version of the spreadsheet utility?