Using Formulas in ShedMate for Column-Based Plate Connection Quantification
Introduction to Column-Based Plate Connection Quantification 0:00
-
Overview of previous lesson on quantifying bolts.
-
Introduction to using formulas for quantification in ShedMate.
Accessing Variables in ShedMate 0:18
-
Navigate to the pricing database to find variables.
-
Explanation of the variety of variables available.
Creating a New Variable 0:41
-
Steps to create a new variable for quantifying column-based bolts.
-
Example: Naming the variable and setting it to four bolts per column.
Handling Formula Failures 1:05
-
Discussion on whether to ignore formula failures.
-
Importance of receiving warnings for formula issues.
Exploring the Variable List 1:33
-
Overview of the variable list in ShedMate.
-
Emphasis on the power of creating custom quantifications.
Searching for Specific Variables 1:42
-
How to search for specific variables related to columns.
-
Example of finding the count of columns.
Creating the Formula for Column-Based Bolts 2:12
-
Steps to create a formula that multiplies the number of columns by four.
-
Confirmation of the final result.
Saving the New Variable 3:02
-
Instructions on saving the created variable and quote.
Duplicating Existing Rules 3:09
-
Process of duplicating existing rules for column-based plate connection.
Using Variables in Rules 3:31
-
Explanation of how to apply variables instead of manually specifying items.
Flexibility in Pricing Calculations 4:00
-
Discussion on the flexibility of using variables in pricing calculations.
Advanced Formula Techniques 5:08
-
Introduction to using if statements in formulas for better accuracy.
-
Example of checking column types before calculating bolts.
Best Practices for Template Setup 6:30
-
Recommendations for setting up master templates for different types of projects.
-
Discussion on the efficiency of maintaining a single master template.
Conclusion and Next Steps 7:08
-
Recap of the lesson and encouragement to explore different aspects of variables in future projects.