News: Need training? HyperSizer Training Videos are available now! Learn more here: https://hypersizer.com/trainingevents/e-learning/

Author Topic: Pulling HDB data for rectangular beams in the spreadsheet utility  (Read 33525 times)

cpoteet

  • Client
  • **
  • Posts: 4
    •  
Hi, I'm trying to pull data from a HDB for rectangular beams using the HS spreadsheet utility.  I have been able to successfully pull the beam height, using the keyword H, but have not been able to figure out what keyword to use for width or for the material selected (which is a HyperLam DL).  I've already looked through all the keywords in the keywords worksheet and in the HyperSizer online support.  Can you help?  Thanks, Carl

August

  • Administrator
  • *****
  • Posts: 18
    •  
Re: Pulling HDB data for rectangular beams in the spreadsheet utility
« Reply #1 on: August 28, 2019, 11:54:26 AM »
Those two variables are missing from the spreadsheet utility and must be added to the VBA code. See attached screenshots for the code that needs to be added. VBA code is accessed by: View Tab>Macros>View Macros>Edit.

Once this code is added, the rectangular beam width and material can be retrieved with the keywords "Wt" and "Mw".

-August