Tips for Building a Construction Cost Database

Creating estimates using a cost database saves manual entry work, ensures your numbers are coming from a good starting point, and standardizes data across the team that use the database. Here are some tips from the Beck Technology professionals regarding “starting from scratch” on building a new database:

Variables:

  1. Make names as short and obvious as possible and use CamelCase
    1. Example: OverExcav to be used for an Over Excavation waste factor… X*(1+(OverExcav/100))
  2. Start as generic as possible and only add new variables as they are needed. (DESTINI Estimator is able to customize the question prompted to the user on the Questions tab in an assembly, so “Length” can get a ton of use in multiple assemblies.)
  3. A variable can only be asked once in an assembly, no matter how many times it is used
    1. If you need to ask Length of Wall and Length of XYZ as separate inputs, you will need two separate “length” variables
      1. Length
      2. WaterstopLength

Formulas:

  1. Allows you to save your custom formulas to be added quickly to line items
  2. Use a different nomenclature system to make it obvious when you are seeing it
    1. FX_FORMULA_NAME or something similar
  3. You CAN bury formulas inside of formulas but it can make it tricky to track down an errant variable down the line. One layer deep isn’t bad. Burying something within 4 to 6 layers of formula can be a headache.
    1. FX_Area = Length * Width
    2. FX_Volume = FX_Area * Depth / 27
    3. Line item receives only the formula FX_Volume, and the user is asked about Length Width and Depth

Overall Comment:
When building assemblies and designing the logic, test early and test often! You may think you have it figured out just right, but your test may show otherwise. Think of your assembly in “buckets”, and when you finish the first formula of a bucket, test it. If it passes your review, repeat that formula as needed for the items in that section. If it doesn't then revise, retest, and then move on.

 

Related Posts

Tips for Construction Estimating Naming Conventions The flexibility DESTINI Estimator offers is both refreshing and exciting. The estimating software allows users to customize how data is managed and …
Read more
How to Create a Cost Database Connection Profile Beck Technology offers a full in-house support team for DESTINI Estimator users. Our support team is available by phone or email, but we have also …
Read more
How to Use DESTINI Data Manager, Your Construction Cost Database DESTINI Data Manager is the app you use to manage your construction cost database. This construction cost database in DESTINI Data Manager is what …
Read more