Sample C n column design line spreadsheets will be introduced in this section. 
Column Design Line Data
...
...
The "Design State" spreadsheet cell indicates the current status of the column design state is performed from column design line data spreadsheet.
...
Figure 1
...
Figure 2
Source/sources of the analysis result used by the code check object for the column is listed in Analysis Source. To change the analysis source go to Design Templates.
Default code check template assigned in Design Criteria can be edited for each column in the spreadsheet. To change the template click on the code check template cell and select from the drop down menu.
Design state shows the demand/capacity ratio after the run of the code check and shows if the column design is adequte or not.
Code Check Timestamp show the last run time of the code check object.
→ Click Show to see the detailed report of the column in the spreadsheet as illustrated in Figure 3.
...
Figure 3
Column section and rebar detailing defined by user at each floor are displayed in drawing space as demonstrated in Figure 3.
→ Click Verify All to run code check for all the columns in the design line.
→ Click Verify Selected and select columns from the drawings for running code check.
→ Click Interaction Diagram and select a column to see the interaction diagram of the column.
Axial Force Moment Design
Axial reinforcement design of the columns are made from this spreadsheet.
...
Figure 4
Axial force and momentY, momentZ ranges of selected analysis sources and demand/ capacity ratio of the column are displayed for each floor in the spreadsheet demonstrated in Figure 4.
→ User can change the rebar diameter from the spreadsheet.
→ #of rebar along width/depth data must be entered for rectangular columns
Rebar count will automatically calculated for rectangular columns.
→ Rebar count must be entered for circular columns.
Reinforcement will be distributed uniformly along the circular section of the column
Rebar Templates spreadsheet is more handy for the design of arbitrary columns.
...
Figure 5
Rebar detailings in the section drawings at each floor will be updated according to the entered data as illustrated in Figure 5.
Shear Torsion Design
Shear and torsional reinforcement design of the column is made from this spreadsheet.
...
Figure 6
ShearY, ShearZ and torsion results, and demand/capacity ratio of the column section at each floor are displayed in the spreadsheet demonstrated in Figure 6.
→ User can change longitudinal rebar, stirrup rebar and tie spacing data from the spreadsheet.
→ User can set spiral for shear reinforcement.
Rebar Templates spreadsheet is more handy for arbitrary columns shear torsion design.
Design Properties
General properties that affect the column design can be set from this spreadsheet as illustrated in Figure 7.
...
Figure 7
Reinforcement Properties
...
Figure 8
→ Clear cover to stirrup must be entered in this spreadsheet as demonstrated in Figure 8.
Rebar Templates
Reinforcement detailings of arbitrary columns are defined from this spreadsheet. Also custom detailing of rectangular or circular columns can be created from this spreadsheet.
...
Figure 9.1
→ Click Draw Rebars
...
Figure 9.2
→ Enter the clear cover + diameter of the stirrup+ diameter of the longitudinal reinforcement/2 value as shown in Figure 9.2.
Then the reference area where the reinforcements can be distributed will be generated as illustrated in Figure 9.3.
...
Figure 9.3
→ Click to where the reinforcements will be located as demonstrated in Figure 9.4.
...
Figure 9.4
→ Select the default longitudinal reinforcement in the spreadsheet as demonstrated in Figure 9.5.
...
Figure 9.5
→ Click Show Rebars to go to longitudinal reinforcements spreadsheet as shown in Figure 9.6.
...
Figure 9.6
User can edit the diameter of each reinforcement from the spreadsheet shon in Figure 9.6.
→ Click Back to Rebar Template to go back .
→ Click Show Stirrups as shown in Figure 13 to go to stirrup reinforcements spreadsheet as shown in Figure 9.7.
...
Figure 9.7
→ Click Draw Stirrup button shown in Figure 9.7 and draw the stirrup line through longitudinal reinforcement centers.
→ Hit ESC to finish drawing
...
Figure 9.8
Strirrup center line will automatically generated as illustrated in Figure 9.8.
Since arbitrary column can have variable geometry, AEC | BOLT Building Design Suite allows engineer to make decision about the provided strirup legs for shear directions and for torsion.
...
→ Select shear reinforcements as shown in Figure 9.9
...
Figure 9.9
→ Click Closed Torsional Rebar button shown in Figure 9.7
→ Select shear reinforcements for torsion as shown in Figure 9.10
...
Figure 9.10
Shear reinforcement legs selected for torsion will have T letter near by it as illustrated in Figure 9.11.
...
Figure 9.11
Tributary Area
Tributary area of the column at each floor in the design line is listed in this spreadsheet
...
Figure 10
→ Enter a correction factor for tributary area (if necessary)
Also reducible live load area at each floor is listed in the spreadsheet. See Live Load Reduction for more information about live load reduction.
Tributary Forces
...
Figure 11
Tributary analysis results of C1 column design line are available in tributary forces spreadsheet.
→ Go to Tributary area → Tributary Forces as demonstrated in Figure 11.
Tributary analysis results are reported per load class, load combination and envelopes.
Load Classes and load cases used in numerical example are as follows;
...
Figure 12
...
Figure 13
Finite Results
...
. Depending on whether the vertical or stirrup rebars have been assigned from the Columns section geometric data, the design state will be reflected accordingly.
Design State: “No Reinforcement”: If either the vertical or stirrup rebars are not assigned, the design state will be marked as "No Reinforcement". This indicates that the column design line is not yet ready for code check, as the necessary reinforcement information is missing.
Design State: “Need Verification”: On the other hand, if all the rebar assignments have been completed, the design state will be shown as "Need Verification". This signifies that the column design line is prepared for further verification and code check procedures.
The spreadsheet cell labeled "Changes After Last Code Check" provides information on the modifications made to the model following the completion of a code check. It displays the updates or revisions implemented as a result of the code check analysis.
The spreadsheet cell named "Code Check Timestamp" records the time at which the last code check was conducted. It serves as a reference to indicate the specific moment when the code check analysis was performed on the model.
These two cells, "Changes After Last Code Check" and "Code Check Timestamp," offer valuable insights into the code check process, allowing users to track and review the alterations made to the model and refer to the timestamp for the most recent code check operation.