Extract Column / Wall Load Into Excel Format

How to Extract Column / Wall Load Into Excel Format

If you would like to generate the column/wall forces to excel format, please go to Design Tab > Columns > Reports > Columns forces listing, to generate the forces in notepad first. Then copy all the data into Excel and use the function "Text to Column" to split the text into multiple columns (refer to snapshot below). Attached GIF for your reference.






    • Related Articles

    • Load Editor

      Member Load Editor A new loading framework is introduced which it is more flexible and provides more freedom in terms of load definitions, load orientations, load case assignments, load reporting, and visualization. The Load Editor of any members can ...
    • Define Wall/Column Lateral Loads

      User-defined varying distributed lateral loads can be applied to the individual column and wall member. The span load applied maybe used to simulate : Soil Pressure on basement wall Hydrostatic load As an alternative to defining wind load (other than ...
    • Column and Wall Design Overview

      Column and Wall are the significant vertical structural members in a building structure. Column Reinforcement Design Tab can be loaded by selecting the "Columns" under the Design tab. Design settings of columns and walls are explained in detail in ...
    • Load Combinations

      The load combinations to be used during the analysis of the building model can be specified by clicking the "Load Combinations" button which is located on the Pre-Analysis tab of the Building Analysis form. The figure below shows the Load Combination ...
    • Column and Wall Design Contents

      The "Column Section Design" form can be accessed by clicking the “Column Section Design” option under the “Design” pulldown menu in the Graphic Editor. ProtaStructure can design rectangular, circular and polyline columns under uniaxial or biaxial ...