---
title: Pricing Calculations – Creating & Applying Formulas for Column-Based Bolts
description: Learn how to create and apply advanced formulas to quantify materials in Shedmate in bulk
---
[Skip to content](https://help.shedmate.com.au/knowledge/pricing-calculations-creating-applying-formulas-for-column-based-bolts#main-content)
English
Show submenu for translations
- [Setting up Pricing in Shedmate (course)](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-costing-course)
- [Frequent Asked Questions](https://help.shedmate.com.au/knowledge/frequent-asked-questions)
- [Setting up Shedmate](https://help.shedmate.com.au/knowledge/setting-up-your-enquiry-system-for-marketing-usage-qr-codes)
- [Integrations](https://help.shedmate.com.au/knowledge/trimble-tekla-structures-integration)
Open main navigation
Close main navigation
- [Setting up Pricing in Shedmate (course)](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-costing-course)
- [Frequent Asked Questions](https://help.shedmate.com.au/knowledge/frequent-asked-questions)
- [Setting up Shedmate](https://help.shedmate.com.au/knowledge/setting-up-your-enquiry-system-for-marketing-usage-qr-codes)
- [Integrations](https://help.shedmate.com.au/knowledge/trimble-tekla-structures-integration)
- English
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://help.shedmate.com.au/knowledge?hsLang=en)
2. [Setting up Shedmate Costing (COURSE)](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en)
3. [Starting from Scratch - A necessary learning practice](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en#starting-from-scratch-a-necessary-learning-practice)
# Pricing Calculations – Creating & Applying Formulas for Column-Based Bolts
## Learn how to create & apply advanced formulas to quantify materials in Shedmate in bulk
#### Using Formulas in ShedMate for Column-Based Plate Connection Quantification
**Introduction to Column-Based Plate Connection Quantification** [0:00](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=0)
- Overview of previous lesson on quantifying bolts.
- Introduction to using formulas for quantification in ShedMate.
**Accessing Variables in ShedMate** [0:18](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=18)
- Navigate to the pricing database to find variables.
- Explanation of the variety of variables available.
**Creating a New Variable** [0:41](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=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](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=65)
- Discussion on whether to ignore formula failures.
- Importance of receiving warnings for formula issues.
**Exploring the Variable List** [1:33](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=93)
- Overview of the variable list in ShedMate.
- Emphasis on the power of creating custom quantifications.
**Searching for Specific Variables** [1:42](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=102)
- 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](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=132)
- Steps to create a formula that multiplies the number of columns by four.
- Confirmation of the final result.
**Saving the New Variable** [3:02](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=182)
- Instructions on saving the created variable and quote.
**Duplicating Existing Rules** [3:09](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=189)
- Process of duplicating existing rules for column-based plate connection.
**Using Variables in Rules** [3:31](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=211)
- Explanation of how to apply variables instead of manually specifying items.
**Flexibility in Pricing Calculations** [4:00](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=240)
- Discussion on the flexibility of using variables in pricing calculations.
**Advanced Formula Techniques** [5:08](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=308)
- 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](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=390)
- 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](https://www.loom.com/share/95cd46e10ccf4360a8b5b450e5fb0816?t=428)
- Recap of the lesson and encouragement to explore different aspects of variables in future projects.
- [Introduction to Shedmate (How does it work)](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-how-does-it-work?hsLang=en#main-content)
- [Introduction and useful information](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-how-does-it-work?hsLang=en#introduction-and-useful-information)
- [Workflow for Cold Formed x Structural Steel](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-how-does-it-work?hsLang=en#workflow-for-cold-formed-x-structural-steel)
- [Frequent Asked Questions (FAQ)](https://help.shedmate.com.au/knowledge/frequent-asked-questions-faq?hsLang=en)
- [Release Notes](https://help.shedmate.com.au/knowledge/release-notes?hsLang=en#main-content)
- [2025](https://help.shedmate.com.au/knowledge/release-notes?hsLang=en#2025)
- [2024](https://help.shedmate.com.au/knowledge/release-notes?hsLang=en#2024)
- [2026](https://help.shedmate.com.au/knowledge/release-notes?hsLang=en#2026)
- [Setting up Shedmate](https://help.shedmate.com.au/knowledge/setting-up-shedmate?hsLang=en#main-content)
- [Getting Started](https://help.shedmate.com.au/knowledge/setting-up-shedmate?hsLang=en#getting-started)
- [Setting up Shedmate Costing (COURSE)](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en#main-content)
- [Introduction to Cost Engineering & Shedmate](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en#introduction-to-cost-engineering-shedmate)
- [Starting from Scratch - A necessary learning practice](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en#starting-from-scratch-a-necessary-learning-practice)
- [Fast-Tracking Your Pricing Setup with Pre-Built Templates](https://help.shedmate.com.au/knowledge/setting-up-shedmate-costing-course?hsLang=en#fast-tracking-your-pricing-setup-with-pre-built-templates)
- [Integrations and API](https://help.shedmate.com.au/knowledge/integrations-and-api?hsLang=en)
- [Setting up Pricing in Shedmate (course)](https://help.shedmate.com.au/knowledge/introduction-to-shedmate-costing-course)
- [Frequent Asked Questions](https://help.shedmate.com.au/knowledge/frequent-asked-questions)
- [Setting up Shedmate](https://help.shedmate.com.au/knowledge/setting-up-your-enquiry-system-for-marketing-usage-qr-codes)
- [Integrations](https://help.shedmate.com.au/knowledge/trimble-tekla-structures-integration)
[](http://www.shedmate.com.au)
1 James St, Mount Gambier 5290
South Australia
[mailto:support@shedmate.com.au](mailto:support@shedmate.com.au)
Copyright © 2025, Shedmate
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"contentUrl" : "https://7304411.fs1.hubspotusercontent-ap1.net/hubfs/7304411/Pricing%20Calculations%20%E2%80%93%20Creating%20&%20Applying%20Formulas%20for%20Column-Based%20Bolts.mp4",
"dateModified" : "2025-03-25T00:14:51.825Z",
"duration" : "PT7M15S",
"height" : 1080,
"name" : "Pricing Calculations – Creating & Applying Formulas for Column-Based Bolts",
"thumbnailUrl" : "https://7304411.fs1.hubspotusercontent-ap1.net/hubfs/7304411/Pricing%20Calculations%20%E2%80%93%20Creating%20&%20Applying%20Formulas%20for%20Column-Based%20Bolts.mp4/medium.jpg",
"uploadDate" : "2025-03-25T00:14:51.820Z",
"width" : 1922
}
```