Announcement

Collapse
No announcement yet.

Database vs. spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Re: Database vs. spreadsheet

    Bob - I caught your note about starting to work in Timberline. I have been fussing with it for a couple of years now and find it to be incredibly powerful and versatile. The downside is that you pretty much have to build everything yourself if you want it to work the way you need it to.(not unlike almost all estimating programs).
    The only thing I find lacking is that their reporting functions are very weak within the program and working with an outside report writer such as Crystal Reports is complicated and time consuming. I understand they are planning to improve the reports in future releases.

    I spent several months a while back building a comprehensive assemblies that cover virtually every facet of our remodeling work. This was a big investment in time, but has paid off many times over in increased efficiency and accuracy.

    If you have any questions about the software or need some help, let me know.

    Comment


    • #17
      Re: Database vs. spreadsheet

      Carl-

      Thanks for the offer. The company I'm working with it for actually sent me to a 3-day training class to get the basics (and not so basics) of the program. It touched on Crystal Reports, but didn't get too deep into it. I'm trying to talk them into sending me to Oregon for the Timberline Certified Consultant course, but so far no such luck...lol.

      I've got a massive model for office buildings that takes about 10 minutes to input parameters, and spits out a 19 page estimate that covers everything down to the door hardware and dock bumpers- it's definitely powerful. It's almost too powerful for many applications, as as you said, takes a lot of time to set up- that's why I don't mention it TOO much around here. The $6,000 price tag doesn't help either.....

      Bob

      Comment


      • #18
        I looked at that datanamic and my head exploded. I use the K.I.S.S. method but now I'm interested if a true database would buy me anything? Is it just ease and effectiveness with multiple teams? My biggest problem when accurately estimating is that my actual costs vary so much that I'm constantly updated my spreadsheet. Can a database pull from vendors?

        I'm sure these are stupid questions. I'm just very green in this area and this post has got me even more curious. From the latest two posts, you guys are very much commercial big dogs... so probably a waste for a little guy.
        Last edited by FrederickPorches; 09-16-2016, 12:47 PM.
        http://www.FrederickPorches.com

        Comment


        • #19
          Originally posted by FrederickPorches View Post
          I looked at that datanamic and my head exploded. I use the K.I.S.S. method but now I'm interested if a true database would buy me anything? Is it just ease and effectiveness with multiple teams? My biggest problem when accurately estimating is that my actual costs vary so much that I'm constantly updated my spreadsheet. Can a database pull from vendors?

          I'm sure these are stupid questions. I'm just very green in this area and this post has got me even more curious. From the latest two posts, you guys are very much commercial big dogs... so probably a waste for a little guy.
          Not stupid questions at all.

          I used to work for a commercial roofing company that was pretty big. I was their IT / tech guy, and my job was to find new tech solutions to help them work faster and more productively. With all that budget and size- they still estimated on spreadsheets.

          I think the owner went to a local community college way back in the day to learn how to use excel, and set it up with some simple formulas to capture every detail. Don't get me wrong- these things were beasts- I was responsible to fix them if they had formula errors (and they did!), but it was free!

          I looked at other solutions, but one of the biggest problems was 1) lots of $$ and 2) they can't always pull prices direct from vendors. If you want, I'm still in touch with the boss there and could see if I could empty out a spreadsheet and share it? not sure if he'd let me but i can ask ;)
          How to make more profit and grow your business. https://www.construct-ed.com/course/...r-contractors/

          Comment


          • #20
            Make a careful choice: changing later, it's difficult/impossible to save/move the specific assemblies and cost data created in one mfgr's format (spreadsheet-to most anything).

            My issue with home-made spreadsheet is user error: errors to formulas within a multi-page spreadsheet would result from my sloppy edits on one page that rattled down the chain as hidden mistakes.

            Use/subscribe to single seat of WinEst Pro, runs about $1,300 a year.
            I haven't been able to botch its structural integrity, yet.
            Have lost databases at upgrades.

            Comment


            • #21
              Originally posted by FrederickPorches View Post
              I looked at that datanamic and my head exploded. I use the K.I.S.S. method but now I'm interested if a true database would buy me anything? Is it just ease and effectiveness with multiple teams? My biggest problem when accurately estimating is that my actual costs vary so much that I'm constantly updated my spreadsheet. Can a database pull from vendors?

              I'm sure these are stupid questions. I'm just very green in this area and this post has got me even more curious. From the latest two posts, you guys are very much commercial big dogs... so probably a waste for a little guy.
              Feed from vendors is one of the main reasons why I am now using estimating software. Of course, vendors have to create the feed, but once it is done, it is much easier to make an accurate estimation. Best part is, you don´t have to check actual costs every month or so. Here is an article about possibilities how to keep up with material costs: https://www.esticom.com/material-cost-estimating/ As for the multiple teams, you have to find software that supports team collaboration. Don´t know if simple database can help you with multiple teams.

              Comment


              • #22
                In terms of vendors, bid4build has a new cloud system which seems to be very good. It already has pre-built assemblies with a hole bunch of other things including multiple users and looks like it costs $149. This is the site http://www.bid4build.com/

                Comment

                Working...
                X