Creating a Pricing Database in Shedmate
1. Introduction to the Session 0:00
-
Welcome to session four on starting from scratch.
-
Importance of understanding the foundations of Shedmate's pricing calculations.
-
Overview of the session's goal: to create formulas in Shedmate for pricing.
2. Understanding Shedmate and BIM 0:48
-
Shedmate is a visual designer for building information modeling (BIM).
-
It allows for digital modeling of structures before physical construction.
-
Importance of linking information to pricing calculations.
3. Disclaimer on Shedmate Plans 1:51
-
Different Shedmate plans may show different items in the designer.
-
Explanation of how the final results and foundations remain the same across plans.
4. Starting from Scratch in Shedmate 2:31
-
Open a demo project in Shedmate.
-
Delete all existing items and variables to start fresh.
5. Understanding Quantification in Shedmate 3:43
-
Explanation of why no items are quantified initially (no pricing database linked).
-
Introduction to creating a new pricing database.
6. Creating Items in the Pricing Database 4:10
-
Steps to create a new item in the pricing database:
-
Click 'new' and specify an item name (e.g., corrugated iron-cladding).
-
Importance of specific naming for future updates.
-
7. Adding ERP Codes and Categories 5:13
-
Explanation of ERP codes and their importance for future price updates.
-
Selecting the correct item category to ensure proper linking.
8. Duplicating Items for Efficiency 6:44
-
After creating the first item, use the duplicate function to create similar items (e.g., zinc cladding).
-
Adjust prices and names accordingly.
9. Importing and Exporting Pricing Data 7:21
-
Use the import/export feature to manage pricing data in bulk.
-
Steps to export the current pricing database to Excel.
10. Modifying the Pricing List in Excel 8:45
-
Explanation of how to modify the pricing list in Excel while maintaining the required structure.
11. Importing Modified Pricing Data Back to Shedmate 9:28
-
Steps to import the modified Excel file back into Shedmate.
-
Handling duplicates and invalid items during the import process.
12. Finalizing the Pricing Database 10:47
-
Review of the imported items and options to merge or reject items.
-
Importance of maintaining existing links to pricing calculations.
13. Conclusion and Next Steps 11:53
-
Summary of creating a pricing database from scratch.
-
Introduction to the next session on linking the pricing database to pricing calculations.