Software Use > Scripting
Reporting Cap Thickness (Tcap) using Spreadsheet Utility
(1/1)
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?
Navigation
[0] Message Index
Go to full version