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

    • 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 ...
    • Overview of the Column Summary Table

      Design Tab After clicking the “Columns” option in the “Design” tab you will see a summary table in which all the columns and walls in the current project are listed for all storeys. The summary table can be manipulated as follows: To filter members ...