Gani sk · YouTube · 5:10
This 120-second clip is an introductory Tekla Structures modeling demonstration that builds a small steel frame step by step. The presenter first places a column on a labeled grid, adds a base plate through Applications & components, copies the column to other intersections, creates beams between columns, applies a Clip angle (141) beam-to-column connection, and then copies beams in both directions. The visible result is a compact 3D frame with purple columns, green beams, and joint connections, prepared as the basis for later reports or a bill of materials. This video segment demonstrates the workflow for creating a Bill of Materials (BOM) in structural modeling software. It begins with preparing a simple 3D steel frame by copying columns and beams. The instructor then navigates to the Reports menu, selects the 'Material list' template, and crucially modifies the default file extension from '.xsr' to '.xls' to ensure compatibility with Microsoft Excel. After generating the report for the entire model, the user locates the file in the project directory and opens it in Excel. The segment concludes by verifying the exported data, which includes profiles, grades, quantities, lengths, areas, and weights, culminating in a total project weight of 9,614 lbs. This 70-second clip is mainly a software demonstration inside Tekla Structures showing how to generate a "Bolt List" report. The user scrolls the Report dialog, selects the bolt template, changes the output file extension from .xls to .xlsx, clicks "Create from all," and reviews a preview containing bolt entries and a total of 34.0 lbs. The narrator then states that other report types in the same list can be created similarly. After the software portion ends, the remainder of the clip is promotional: a brief model view, a YouTube channel page for "Gani sk," and animated like/subscribe/thanks outro screens with no further mathematical or instructional content.
Use the learning inspector for key ideas and moments, or open the reading tabs for the complete notes.
Generated from the video's visuals and explanation; not verbatim speech.
The clip opens with the stated goal: creating reports or a bill of materials in Tekla Structures. Before any report is shown, the presenter begins by constructing the underlying model.
A column is placed first on the grid. The STEEL tab is used, the Column tool is selected, and a purple vertical member appears at one intersection, establishing the basic support element.
Next, the presenter opens Applications & components and searches for "base plate". This shows that component libraries are accessed through a searchable panel rather than only through the main ribbon.
A base plate component is selected and attached to the column by picking the column and then the placement position. The visible result is a footing-like plate at the column base.
The column is then duplicated with a copy command. By selecting the object, opening the context menu, choosing Copy, and specifying source and destination points, additional columns are placed at other grid intersections.
With multiple columns in place, a beam is created by selecting the Beam tool and picking two endpoints. A green horizontal member spans between column tops, converting isolated verticals into a framed system.
The presenter then adds a beam-to-column connection. Using Ctrl+F to reopen Applications & components, the Beam to column connections category is accessed and Clip angle (141) is chosen. The connection is applied by picking the column and the beam.
After the first connected beam is complete, the same copy workflow is reused for beams. This reinforces that repeated structural members can be generated efficiently from an existing example.
Finally, beams are added in the perpendicular direction, again by selecting the Beam tool and picking two points. The model becomes a small rectangular steel frame with columns, beams, and joint connections ready for later reporting.
First, we prepare our sample model. I'll select the existing column and beam, copy them, and paste them to create a frame with four columns and four beams. This gives us enough data to demonstrate the reporting feature.
Now that the model is ready, we will create the Bill of Materials. Navigate to the 'Drawings & Reports' tab on the top ribbon and click the 'Reports' button.
In the Reports dialog, scroll down the template list and select '350 Material list'. This template is designed specifically to summarize steel quantities.
Notice the filename field ends in '.xsr'. This is the software's native format. To open this directly in Excel, you must manually change the extension from '.xsr' to '.xls'.
With the correct extension set, click 'Create from all'. This generates the report file for every object in the model and saves it to your project's Reports folder.
To access the file, go to the main Menu, select 'Open model folder', and then navigate into the 'Reports' subfolder. You will see your new '.xls' file there.
Double-click to open it in Excel. You can now verify the data: check the profiles, grades, quantities, lengths, and weights. At the bottom, the total weight is calculated as 9,614 lbs, confirming the BOM is complete and accurate.
The clip opens inside the Tekla Structures Report dialog. The visible task is to choose a report template from the list. The user scrolls downward through the available templates until the entry "Bolt List" is reached and selected, establishing the report type that will be generated.
Before running the report, the output file settings are adjusted. In the Report file section, the name field is edited so the extension changes from .xls to .xlsx. The narration identifies this as changing the format for the Excel sheet, so the next step is prepared to export the report in workbook format.
With the template selected and the file extension set, the user clicks "Create from all." This command executes the chosen report on the full model rather than on a partial selection, and the software immediately produces a preview window.
The preview is titled "BOLT LIST" and presents a structured summary. Project identification appears at the top, followed by individual bolt rows and a total line. The visible numeric value associated with the listed bolts and the total is 34.0 lbs, confirming that the report has been generated successfully.
After the preview is dismissed, the narrator generalizes the procedure: the same Report dialog can be used to create other report types from the list. The screen supports this by scrolling through many additional templates, showing that the bolt report was only one example within a broader reporting workflow.
The report dialog is then closed, briefly revealing the underlying 3D structural model in the viewport. No new instructional step is introduced here; this functions as the end of the software demonstration.
The video leaves Tekla Structures and switches to a web browser showing the YouTube channel "Gani sk." The page is scrolled through uploaded tutorial thumbnails while the narration asks viewers to like, share, comment, and visit the channel for more related videos.
The final portion consists of animated outro cards reading "DON'T FORGET TO LIKE THE VIDEO," then "AND DON'T FORGET TO SUBSCRIBE," and finally "THANKS FOR WATCHING." This closing segment contains no further mathematical or software instruction.
The video introduces a Tekla Structures workflow for creating reports or a bill of materials. In this excerpt, the emphasis is on building the model that will later be reported: columns, base plates, beams, and connections.
The first modeling action is to select the Column tool under STEEL and place a vertical member on the grid. The column becomes the reference object for later base plate attachment and copying.
Base plates are inserted through the Applications & components panel. The presenter searches for "base plate" and then attaches the chosen component to the column by selecting the column and placement point.
Both columns and beams are duplicated using the same pattern: select the object, right-click, choose Copy, then specify a source point and a destination point. This is the main efficiency method shown in the clip.
A beam is made by selecting the Beam tool and picking two positions. In the demonstration, these positions correspond to column tops, so the beam spans horizontally between supports.
Connections are added from Applications & components, opened with Ctrl+F. The presenter chooses Beam to column connections and applies Clip angle (141) by picking the column and then the beam.
After one beam direction is established, more beams are placed perpendicular to the first set. The result is a compact 3D steel frame suitable for downstream reporting or BOM generation.
The process involves three main stages: 1) Preparing the 3D model with all necessary components. 2) Configuring the report settings, specifically ensuring the output format matches the intended destination (e.g., changing .xsr to .xls for Excel). 3) Generating the report and verifying the aggregated data (quantities, weights) in the external application.
Structural software often uses proprietary formats for internal reports (like .xsr). To export data for use in standard spreadsheet applications like Microsoft Excel, the user must explicitly alter the file extension in the save dialog before generating the report. Failing to do so may result in a file that Excel cannot open natively.
A standard material list report aggregates data by profile type. Key columns include Profile (shape/size), Grade (material spec), Qty. (number of pieces), Length (dimension), Area (cross-section), and Weight (total mass). The report typically concludes with a grand total of the weight column for quick project estimation.
The demonstration begins in the Report dialog by scrolling through the built-in template list and choosing "Bolt List." This establishes which kind of report will be generated before any output settings are changed.
In the Report file section, the file name extension is edited from .xls to .xlsx. The narration explicitly frames this as changing the format for the Excel sheet, so the report is prepared for export as an Excel workbook.
After selecting the template and setting the file format, the user clicks "Create from all." This command generates the report from the entire current model rather than from a manually chosen subset.
The resulting preview window is titled "BOLT LIST" and contains project header information, individual bolt entries, and a total line. The visible quantity associated with the listed bolts and the total is 34.0 lbs.
Once the bolt report preview is closed, the narrator explains that other report types listed in the same dialog can be created in a similar way. The interface reinforces this by showing many additional templates in the scrollable list.
After the Tekla demonstration ends, the clip briefly shows the 3D model, then switches to a YouTube channel page and animated outro cards. These final sections are promotional and contain no additional reporting instruction.
Explore conditions, steps and evidence. Supplementary explanations are labeled separately from content shown in the video.
The modeling workspace shows a dashed grid with labels A, B, C, D and 1, 2, 3, 4, 5.
A, B, C, D; 1, 2, 3, 4, 5
Grid line identifiers used to locate columns and beams in the model.
Structural grid labels
The report table includes a column labeled 'Profile' with entries such as W18X50, W16X40, ROD3/4", PL3/4"", , and .
The cross-sectional shape and size designation of the structural steel member.
Structural steel member designations.
The report table includes a column labeled 'Grade' with entries such as A992 and A36.
The material specification or strength grade of the structural steel.
Steel material grades.
The report table includes a column labeled 'Qty.' representing the quantity of each profile.
The number of individual pieces of a specific profile required for the model.
Positive integers.
The report table includes a column labeled 'Length' with values in feet and inches (e.g., 19'-11 ").
The physical length of the structural member.
Linear dimensions in Imperial units (feet and inches).
The report table includes a column labeled 'Area(in2)' with numerical values (e.g., 14.644).
The cross-sectional area of the structural profile.
Area in square inches.
The report table includes a column labeled 'Weight(lbs)' with numerical values (e.g., 997).
The total weight of the specified quantity of the profile.
Mass/weight in pounds.
The report template list shows the entry "Bolt List".
The narrator says to select this bolt list.
Bolt List
A Tekla Structures report template that summarizes bolt information for the model.
Report template name in the software interface
The file name field is edited from "Bolt List.xls" to "Bolt List.xlsx".
The narrator says to change the format here xlsx for the excel sheet.
.xlsx
Excel workbook file extension used for the generated report output.
File extension in the report file name field
The button labeled "Create from all" is clicked.
The narrator says "So create from all."
Create from all
Command that generates the selected report using all objects in the current model.
Button label in the Report dialog
The preview report lists three bolt rows and a total line, each showing 34.0 lbs.
34.0 lbs
Numeric quantity shown in the generated bolt report for each listed bolt type and for the total.
Report preview values
The speaker says, "Hi friends, this is Gani. In this video I am going to explain you how to create reports or bill of materials in Tekla Structures."
The clip introduces a workflow for creating reports or a bill of materials in Tekla Structures by first building a small steel frame model.
The demonstration is inside Tekla Structures.
"First of all we are going to create column set here. Go to steel and select this column and place it here."
A purple vertical member is placed at a grid intersection after the Column tool is selected.
A column is created by selecting the Column tool from the STEEL tab and placing it at a chosen location in the 3D workspace.
The STEEL tab is active.
A column tool is selected before placement.
"And now we are going to create the base plate at this location. So go to application components and click on here. And in the search bar type base plate."
The Applications & components panel opens and the search field contains "base plate".
Base plates are accessed through the Applications & components panel by searching for "base plate" in the search bar.
The Applications & components panel is open.
"And select this base plate 1042. Select the column and pick the position at here."
The visible component list includes Base plate (1042).
A base plate is attached at the bottom of the purple column.
The spoken number is heard as "1042"; the exact component ID should be checked against the software list if needed.
After choosing a base plate component, the user selects the target column and picks the placement position so the base plate is attached to the column.
A base plate component has been selected from Applications & components.
A column exists in the model.
"And now we are going to copy this column. So select it. Right click mouse, copy, from at here and place it here. Just like this."
Additional purple columns appear at other grid intersections after a copy operation.
An existing column can be duplicated by selecting it, opening the context menu, choosing Copy, and specifying a source point and destination point.
The object to duplicate is selected first.
"Okay, now we are going to create the beam. So select this beam and pick the first position and second position here."
A green horizontal member is drawn between two column tops.
A beam is created by selecting the Beam tool and picking two positions, typically the endpoints where the beam should span.
At least two placement points are available.
The Beam tool is selected.
"Now we are going to give the connections between the column to beam. So go to application components by using the shortcut control F. And let's take now we are going to take beam to column connection. Let's take this clip angle 141 connection and pick the column and brace beam."
The Applications & components panel shows Steel Detailing and Beam to column connections; Clip angle (141) is visible.
Connection geometry appears at the beam-column joint after the column and beam are picked.
The spoken phrase "brace beam" is unclear in context; visually the action is applying a beam-to-column connection.
Beam-to-column connections are added from Applications & components by choosing a connection family such as Beam to column connections, selecting a specific component like Clip angle (141), and then picking the connected members.
Applications & components is opened.
A beam-to-column connection component is selected.
The column and beam are picked in order.
"Now we are going to copy this beam. So close this application components and select this beam, right click mouse, copy, from here to click on here to place the beam."
More green beams appear between other column pairs after copying.
A completed beam can be copied to other locations by selecting it, using Copy from the context menu, and defining source and destination points.
A beam already exists in the model.
"Now we are going to create the beam in this direction. So select this beam and pick the first point and second point."
Green beams are added in the perpendicular direction, completing a rectangular frame layout.
After one set of beams is placed, additional beams are created in the perpendicular direction by again selecting the Beam tool and picking two points.
The model already contains columns and at least one beam direction.
Speaker states: 'Now we are going to create the bill of material for this columns and beams and connections and everything.'
The user navigates to the 'DRAWINGS & REPORTS' tab and clicks the 'Reports' button.
A Bill of Materials in structural engineering software is a comprehensive list that aggregates all components (columns, beams, connections) modeled in the project to quantify materials for procurement and cost estimation.
Requires a completed 3D model with defined structural members and connections.
Speaker states: 'In the list now we are going to take the materials... material list so scroll it down and click on here material list.'
The Report dialog box opens, and the user selects '350 Material list' from the 'Report templates' dropdown menu.
To generate a standard material summary, the user must select the specific 'Material list' template (numbered 350 in this software version) from the available report templates in the Reports dialog.
The 'Material list' template must be available in the software's report library.
Speaker states: 'extension is the xsr format so if you need in excel format so replace here the extension dot xsr replace with xls.'
The user manually edits the 'Name' field in the Report dialog, changing '350 Material list.xsr' to '350 Material list.xls'.
The software defaults to saving reports in an '.xsr' format. To open the report directly in Microsoft Excel, the user must manually change the file extension in the save dialog from '.xsr' to '.xls'.
The target application (e.g., Excel) must support the new file extension.
The user must have permission to modify the file name and extension.
The narrator states that similarly you can create any type of reports listed here available in these options.
The interface shows a long scrollable list of report templates after the bolt report preview is closed.
Using the same Report dialog workflow, other report types listed in the template menu can also be created.
A report template is available in the list.
The user selects it and uses the same creation controls.
For the report templates shown in the dialog, the same creation method applies.
The Excel sheet shows rows like 'W18X50 | A992 | 6 | 19'-11 " | 14.644 | 997'.
The exact mathematical formula used by the software to calculate weight from area and length is not explicitly stated in the audio, but is inferred from standard steel density calculations.
The software calculates the total weight for a specific profile by multiplying the quantity of pieces by their length, cross-sectional area, and the material density.
Standard engineering calculation for steel mass.
For the W18X50 example: 6 pieces, length approx 19.94 ft, area 14.644 in^2. Converting units and using steel density (~490 lb/ft^3 or 0.2833 lb/in^3) yields approximately 997 lbs.
Numerical verification of the displayed data.
The 'Weight(lbs)' column represents the aggregate mass of all instances of that specific profile in the model.
The sequence shows scrolling to "Bolt List", editing the file extension to .xlsx, clicking "Create from all", and then displaying the report preview.
The narration follows the same order: select bolt list, change format to xlsx, create from all, then point out the bolt list in the report.
Open the Report dialog and scroll through the template list until "Bolt List" is visible.
Directly shown in the interface and stated by the narrator.
Select the "Bolt List" template.
The highlighted entry changes to "Bolt List" in the report template list.
Edit the report file name extension from .xls to .xlsx.
The Name field visibly changes and the narrator explains this is for the Excel sheet.
Click "Create from all" to run the report on the full model.
The button is pressed immediately after the file format is set.
Review the generated preview window titled "BOLT LIST".
A new preview window appears containing project data, bolt rows, and totals.
The clip demonstrates a complete software workflow from template selection to exported bolt report preview.
The speaker narrates each step: create column, add base plate, copy columns, create beam, add connection, copy beam, create beams in the other direction.
The model grows from one purple column to multiple columns, then green beams, then connection details at joints.
Demonstrate how to assemble a basic steel frame in Tekla Structures as preparation for creating reports or a bill of materials.
A grid with labeled lines A-D and 1-5 is available.
Column, Beam, and Applications & components tools are accessible.
Create columns, attach a base plate, copy members, add beams, and apply beam-to-column connections.
Place the first column at a grid intersection.
The speaker says to go to steel, select the column, and place it.
Open Applications & components, search for "base plate", and attach a base plate to the column.
The narration explicitly instructs searching for base plate and selecting the column before placement.
Copy the column to other grid intersections.
The speaker uses right-click Copy with a source and destination point.
Create a beam between two column tops.
The Beam tool is selected and two positions are picked.
Add a Clip angle (141) beam-to-column connection at the joint.
The speaker opens Applications & components with Ctrl+F, chooses Beam to column connections, and picks the column and beam.
Copy the beam to other spans and then add beams in the perpendicular direction.
The narration describes copying the beam and later creating beams "in this direction."
A small 3D steel frame with columns, base plate, beams, and beam-to-column connections is assembled.
The final visible model contains multiple purple columns, green beams in two directions, and connection geometry at joints.
Speaker states: 'pick the column and beam... copy and pick the first point and second point at here... let's take four columns and four beams.'
The user selects a column-beam assembly, uses the Copy tool, and pastes it to create a 4-column, 4-beam frame structure.
Generate a simple 3D steel frame model to serve as the basis for creating a material report.
Existing single column and beam in the Tekla Structures model.
Expand the model to include four columns and four beams.
Select the existing column and beam objects.
User action observed in video.
Right-click and choose 'Copy', then define base points to paste the assembly at new grid locations.
User action observed in video.
Repeat the copy operation to achieve a total of four columns and four beams.
Speaker instruction and visual result.
A 3D model containing four columns and four beams is ready for reporting.
Visual confirmation of the four distinct frame bays in the 3D viewport.
Speaker guides through the entire process of creating the report, changing extension, and opening in Excel.
Step-by-step UI interaction: Reports -> Material list -> Change .xsr to .xls -> Create from all -> Open folder -> Open Excel.
Create a Bill of Materials for the modeled steel frame and export it to a Microsoft Excel file for review.
A completed 3D model with 4 columns and 4 beams.
Tekla Structures software environment.
Obtain an .xls file containing the profile, grade, quantity, length, area, and weight of all members.
Navigate to 'DRAWINGS & REPORTS' and click 'Reports'.
Standard software workflow.
Select '350 Material list' from the report templates.
Specific template selection for BOM.
In the 'Name' field, replace the default extension '.xsr' with '.xls'.
Required step for Excel compatibility as explained by the speaker.
Click 'Create from all' to generate the report file.
Executes the report generation for the whole model.
Open the model folder via the Menu, navigate to the 'Reports' subfolder, and double-click the newly created .xls file.
Locating and opening the exported data.
Review the data in Excel, noting the total weight of 9614 lbs.
Verification of the output.
An Excel file named '350 Material list.xls' is successfully generated and opened, displaying the structural steel quantities and a total weight of 9614 lbs.
The Excel spreadsheet loads correctly without format errors (after clicking 'Yes' on the warning), and the data matches the expected structure.
The Report dialog shows "Bolt List" selected, the file name becomes "Bolt List.xlsx", and the preview window displays a bolt summary.
The narrator explicitly walks through selecting the bolt list, changing to xlsx, creating from all, and then pointing to the resulting report.
Some small text in the preview header is only partially legible beyond the clearly readable title and numeric values.
Generate a bolt report from the current Tekla Structures model and view the resulting report output.
The Report dialog is already open.
A model with bolt data is loaded in the background.
The template list includes "Bolt List".
The default file name initially ends in .xls.
Select the bolt report template, set the output format to Excel workbook, create the report from all model objects, and inspect the preview.
Scroll within the report template list to locate "Bolt List".
The list is visibly scrolled before the entry is selected.
Choose "Bolt List" as the report template.
The selected item becomes highlighted in the dialog.
Change the file name extension to ".xlsx" in the Report file Name field.
The field is edited on screen and the narrator identifies this as the Excel format.
Press "Create from all".
This button is clicked to execute the report generation.
Inspect the preview window showing the bolt list and totals.
The resulting report window opens immediately after creation.
A preview report titled "BOLT LIST" is produced, listing bolt entries and a total line with values of 34.0 lbs.
The visible preview confirms that the selected template generated a structured bolt summary after the file format was changed to .xlsx.
A dashed grid with labels A-D and 1-5 fills the workspace before any members are added.
Grid lines A, B, C, D
Grid lines 1, 2, 3, 4, 5
Coordinate triad
No structural members are present yet.
The grid layout remains fixed throughout the clip.
The grid provides reference locations for placing structural members.
Columns appear purple and beams appear green as they are added.
Purple columns
Green beams
Connection components
The model expands from one column to several columns and then to a beam network.
Columns remain purple and beams remain green during the demonstrated build.
Color coding helps distinguish vertical columns from horizontal beams while assembling the frame.
Small connection geometry appears at beam-column joints after Clip angle (141) is applied.
The exact shape of the connection is visible only briefly and at small scale.
Beam-to-column connection
Clip angle (141)
Joints gain extra geometric detail after component selection and member picking.
Connections are applied only where beams meet columns.
The visual change indicates that a standardized connection component has been inserted into the model.
Mouse cursor moves to the top ribbon, clicks 'DRAWINGS & REPORTS', then clicks the 'Reports' icon.
Ribbon interface
Drawings & Reports tab
Reports button
The active tab changes from 'STEEL' to 'DRAWINGS & REPORTS'.
The 'Report' dialog box appears on screen.
The 3D model remains visible in the background.
Demonstrates the specific UI path required to initiate report generation in the software.
The user highlights '.xsr' in the filename text box and types '.xls'.
Report dialog box
Filename input field
The text string changes from '350 Material list.xsr' to '350 Material list.xls'.
The base filename '350 Material list' remains unchanged.
Visual confirmation of the manual workaround needed to force the software to save in an Excel-readable format.
The Excel window displays a formatted table with headers and data rows, ending with a total sum.
Microsoft Excel interface
Data table
Total row
The view switches from the file explorer to the Excel application.
Data populates the grid cells.
The data corresponds exactly to the model created earlier.
Shows the final usable output of the BOM process, ready for further analysis or cost estimation.
The Report dialog fills most of the screen while the template list is scrolled downward.
The highlighted selection moves through the list until "Bolt List" is reached.
Report dialog
Report template list
Highlighted selection
3D model viewport in background
The visible portion of the template list moves downward.
The selected template changes until "Bolt List" is chosen.
The dialog remains open.
The underlying model view stays in the background.
The visual action establishes which report template will be used for generation.
The Name field under Report file is edited so the extension changes from .xls to .xlsx.
Name field
File extension text
The suffix of the file name changes from .xls to .xlsx.
The base file name remains "Bolt List".
The dialog layout does not change.
This step sets the desired export format before the report is created.
A separate preview window titled "BOLT LIST" appears over the main interface.
The window contains header information, three bolt rows, and a total row.
Some header text is too small to transcribe fully with certainty.
Preview window
Project header fields
Bolt rows
Total row
The report preview replaces focus from the dialog to a new window.
Numeric bolt summaries become visible.
The main Tekla interface remains behind the preview.
The report is presented as a text-based tabular summary.
The preview verifies that the chosen template produced a bolt summary report.
The preview is dismissed and the user returns to the Report dialog.
The template list is scrolled further through many additional report names.
Report dialog
Template list
Preview window
The preview window closes.
The template list scrolls through many other report categories.
The same Report dialog remains active.
The workflow context stays within report generation.
This visually supports the statement that many other report types are available using the same interface.
After Cancel is clicked, the full 3D structural model becomes visible without the dialog overlay.
3D structural frame
Grid labels
Software ribbon
The Report dialog disappears.
The model viewport becomes unobstructed.
The same project model remains loaded.
The software interface stays in Tekla Structures.
This marks the end of the report-generation demonstration inside the application.
The screen switches to a web browser showing YouTube and the channel page "Gani sk".
The page scrolls through uploaded tutorial thumbnails and then returns upward toward the subscribe area.
Web browser
YouTube search bar
Channel banner
Video thumbnails
Subscribe button
The application view is replaced by a browser window.
The channel page is scrolled through multiple uploads.
The content remains promotional rather than mathematical or instructional inside Tekla.
This segment functions as channel promotion after the software demonstration.
The speaker says to "pick the column and brace beam" while applying the connection.
The connection is created only after both members are selected.
The wording "brace beam" is unclear, but the demonstrated action is beam-to-column connection placement.
Selecting a connection component alone completes the joint.
The video shows that after choosing Clip angle (141), the user must still pick the column and the beam for the connection to be applied.
Speaker explicitly warns: 'extension is the xsr format so if you need in excel format so replace here...'
Users might assume that clicking 'Create' automatically produces a file that opens directly in Excel.
The software defaults to a proprietary '.xsr' format. The user must manually intervene to change the extension to '.xls' before generating the file to ensure Excel compatibility.
The user explicitly changes the extension from .xls to .xlsx before creating the report.
The narrator identifies xlsx as the format for the Excel sheet.
One might think changing only the file extension is cosmetic and does not matter for the exported workbook format.
In the demonstrated workflow, the extension is deliberately changed to .xlsx before report creation, indicating that the intended output format is part of the setup step.
The introduction mentions creating reports or bill of materials, then the rest of the clip builds the model first.
Members and connections are added before any report window appears.
The clip demonstrates that building the structural model is a prerequisite step before reports or a bill of materials can be generated.
The speaker copies the column and later copies the beam.
Repeated members appear after copy operations.
Both steps use the same copy workflow: select an object, choose Copy, then define source and destination points.
Speaker links 'bill of material' directly to selecting the 'material list' report.
The 'Material list' report template is the specific tool used to implement the general concept of creating a Bill of Materials in this software.
Speaker explains changing extension to get the file in Excel, then later opens it in Excel.
Changing the file extension to '.xls' is a necessary precondition for the subsequent step of verifying the data within Microsoft Excel.
The template "Bolt List" is selected first, then the file name extension is edited.
The report template must be chosen before the output file name and format are finalized for that report.
The extension is changed to .xlsx immediately before the "Create from all" button is pressed.
Setting the desired file format precedes execution of the report generation command.
Clicking "Create from all" is followed by the appearance of the "BOLT LIST" preview window.
The creation command produces the visible bolt report preview.
The narrator says similarly you can create any type of reports listed here.
The same dialog shows many other templates after the bolt report example.
The bolt list example is generalized to the wider set of available report templates in the same interface.
Opening statement about creating reports or bill of materials in Tekla Structures.
Search for base plate in Applications & components and attach it to the column.
Use Ctrl+F, choose Beam to column connections, and apply Clip angle (141).
Right-click mouse, copy, from here to here for both columns and beams.
Full instructional sequence on creating the report.
Instructions on changing extension and opening in Excel.
Explanation of the .xsr vs .xls difference.
The clip shows scrolling to and selecting "Bolt List" in the Report dialog.
The file name extension is edited from .xls to .xlsx.
The narrator mentions changing the format for the Excel sheet.
The button "Create from all" is clicked to run the report.
The preview window shows a bolt list with individual rows and a total line.
The narrator says any type of reports listed here can be created similarly.
Many additional templates are scrolled into view.
Covered · Introduction to creating reports or bill of materials in Tekla Structures.
Covered · First column is placed on the grid.
Covered · Base plate is searched in Applications & components and attached to the column.
Covered · The column is copied to other grid locations.
Covered · A beam is created between two columns.
Covered · A Clip angle (141) beam-to-column connection is applied.
Covered · The beam is copied to other spans.
Covered · Beams are added in the perpendicular direction to complete the frame layout.
Covered · Model preparation phase: copying columns and beams to create a sample structure.
Covered · Initiating the report creation process and selecting the Material List template.
Covered · Configuring the output file format (.xls) and executing the report generation.
Covered · Locating the generated file in the directory and launching Excel.
Covered · Reviewing the data in Excel, verifying totals, and concluding the tutorial segment.
Covered · The Report dialog is shown, the template list is scrolled, "Bolt List" is selected, and the file extension is changed to .xlsx.
Covered · The user clicks "Create from all" and inspects the generated "BOLT LIST" preview with bolt rows and totals.
Covered · The preview is closed and the narrator explains that other listed report types can be created using the same options.
Covered · The dialog is canceled and the 3D structural model is shown briefly; no new mathematical or reporting instruction is added.
Covered · The video switches to a YouTube channel page and scrolls through uploads as promotional content.
Covered · Animated outro cards ask viewers to like, subscribe, and thank them for watching; no instructional content is present.
Reviewed subject paths
The generated preview shows a structured bolt summary with project identification at the top, individual bolt rows below, and a total row summarizing the listed quantities and weights.
Conditions: The report has been created successfully using the 'Bolt List' template.; The model contains bolt data.
Yes, the same Report dialog workflow can be used to create other report types listed in the template menu by selecting a different template and using the same creation controls.
Conditions: The Report dialog remains open.; Different templates can be selected from the list.
To add a base plate to a column, you must access the component library through the Applications & components panel, search for the specific component, and then attach it to the target column by picking the column and the placement position.
Conditions: The Applications & components panel is open.; A column already exists in the model.; A base plate component is selected from the search results.
The 'Create from all' command instructs the software to compile the selected report based on every object in the current 3D model, rather than just a manually selected subset.
Conditions: A report template has been selected.; The output file name and format have been set.; The model must contain the relevant structural elements to be quantified.
An existing structural member can be duplicated by selecting it, opening the context menu, choosing Copy, and specifying a source point and a destination point on the grid.
Conditions: The object to duplicate is selected first.; A grid with labeled lines is available for placement.
To create a Bill of Materials, navigate to the DRAWINGS & REPORTS tab, click Reports, select the '350 Material list' template, change the file extension to '.xls' for Excel compatibility, and click 'Create from all' to generate the report for the entire model.
Conditions: A completed 3D model with defined structural members and connections exists.; The 'Material list' template is available in the software's report library.; The user has permission to modify the file name and extension.
Beam-to-column connections are added by opening the Applications & components panel, navigating to the Beam to column connections category, selecting a specific component like Clip angle (141), and then picking the connected members in order.
Conditions: Applications & components is opened.; A beam-to-column connection component is selected.; The column and beam are picked in order.
Before generating the report, you must manually edit the file name extension in the Report dialog from the default proprietary format (such as .xsr or .xls) to the desired Excel format (.xls or .xlsx).
Conditions: The Report dialog is open.; The report file name field is editable.; The chosen extension must correspond to the desired export format.
Continue with related videos in the same subject.
YouTube10:40
YouTube8:20
YouTube6:05