Results 1 to 7 of 7

Thread: Software To Create a Construction Estimating Database

  1. #1
    Join Date
    Oct 2020
    Posts
    2

    Software To Create a Construction Estimating Database

    Hi,
    I am a contractor and looking to create an estimating database and am looking into Access. I"ve attached some screenshots and an excel file of what I'm trying to accomplish. My goals are:

    • Have a form that is broken into 8 categories (general conditions, excavation, concrete, framing, etc.) Within each category, I populate a description and unit cost which is from a table I can create storing these items.
    • Once I have all my line items, then go back in and enter the actual units
    • I then can print a detail report showing all the descriptions with units, which would be my Scope of Work
    • Then a second report that shows the summary costs by just the main categories


    Sample Estimate.zipSample Estimate.zipSample Estimate.zipScope of Work (1).jpg

    Before I start diving into the learning process, what would be the best software to create this with? Access? LibreBase? I would like a desktop application and not web-based.

    Currently, I do this in Excel; however, I have issues with a tieing in a general database, links breaking, I can't lock the worksheet but also expand and contract, etc.

    Thanks

  2. #2
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    80
    Have you looked at all the Construction Estimating softwares that are available?

    I would think it'd be worth the investment to purchase one of them.... I'd also think that bankers etc are used to seeing estimates in certain formats....

  3. #3
    Join Date
    Oct 2020
    Posts
    2
    Yes, I have. I'm trying to build my own for:

    1. All of the estimating software out there come with national databases of prices built into the software, which I don't need, not do I want to pay for a recurring subscription for. I subcontract all of my work, so I need something I can build my own database of costs and utilize
    2. The reports with the estimating software applications out there only partially customizable. The ones I've looked into do not have the ability to break out my costs and cost categories as I need them. So it seems that the only way I can get that, is to do it myself
    3. I need a way to create a portfolio of items that clients have to select (plumbing fixtures, lighting, flooring, etc.) I'd like to send them a report that has a picture of each product, model, color, size, cost, etc. This will report will then go in the project contract.
    4. There will be other things that I'd like to create in the future, so it seems only natural to learn how to do it now.


    I was recently introduced to Filemaker Pro, which seems that it would be the best/easiest way to accomplish what I need, for the learning curve seem smaller than the bare database applications (Acces, LibreBase). Do you have any thoughts on this Steve?

    Thanks

    PS I only work directly with the clients, so I tailor everything to what they want to see.

  4. #4
    Join Date
    Nov 2020
    Posts
    3
    I agree with admin, It is better to buy the paid version of any software that will be good for your needs. Or, it is even better to hire developers and make your own software. In this case, you will be independent. But it will cost too much.

  5. #5
    Join Date
    May 2024
    Posts
    1
    Quote Originally Posted by skoz55 View Post
    Yes, I have. I'm trying to build my own for:

    1. All of the estimating software out there come with national databases of prices built into the software, which I don't need, not do I want to pay for a recurring subscription for. I subcontract all of my work, so I need something I can build my own database of costs and utilize
    2. The reports with the estimating software applications out there only partially customizable. The ones I've looked into do not have the ability to break out my costs and cost categories as I need them. So it seems that the only way I can get that, is to do it myself
    3. I need a way to create a portfolio of items that clients have to select (plumbing fixtures, lighting, flooring, etc.) I'd like to send them a report that has a picture of each product, model, color, size, cost, etc. This will report will then go in the project contract.
    4. There will be other things that I'd like to create in the future, so it seems only natural to learn how to do it now.


    I was recently introduced to Filemaker Pro, which seems that it would be the best/easiest way to accomplish what I need, for the learning curve seem smaller than the bare database applications (Acces, LibreBase). Do you have any thoughts on this Steve?

    Thanks

    PS I only work directly with the clients, so I tailor everything to what they want to see.
    I am trying to do the same thing. I've looked at every construction estimating software I could find and can't find anything that will do what I want. Have you figured out a solution?

  6. #6
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    80
    Quote Originally Posted by mattoram View Post
    I am trying to do the same thing. I've looked at every construction estimating software I could find and can't find anything that will do what I want. Have you figured out a solution?
    FYI - His post is almost FOUR YEARS Old.

  7. #7
    Join Date
    Jun 2024
    Posts
    1
    Hi mattoram and skoz55,
    This is a great conversation! It sounds like you're both on the same wavelength in wanting a customizable estimating solution.

    I hear you both talking about FileMaker Pro's potential for a lower learning curve. It can be a powerful tool for building custom databases, and many contractors find it user-friendly. Here are some resources that might be helpful:

    FileMaker Pro Getting Started Guide: https://support.claris.com/s/article...FileMaker-Help
    FileMaker Pro Templates: https://marketplace.claris.com/category/template.html (There might be construction-specific templates to get you started)
    Alternative Options:

    While FileMaker Pro is a great choice, there are other options to consider depending on your technical comfort level:

    Spreadsheet Software (Excel, Google Sheets): These can be surprisingly powerful for building basic estimating tools, especially if you're familiar with formulas and functions. They might not be ideal for complex projects or collaboration, but they're a good starting point.
    Open-Source Database Software (LibreOffice Base): Similar to FileMaker Pro, these offer more customization but might require a steeper learning curve.
    Shared Resources:


    No matter which platform you choose, here are some resources that might be valuable for both of you:

    Construction Estimating Templates (online): There are many free and paid templates available that you can adapt to your needs.
    Construction Cost Databases (online): Some services offer subscription-based access to regional or national cost databases. This could be a good option if you only need occasional price updates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •