I've been using Excel for the last 12 years for estimating purposes. I created my own spreadsheet with formulas for adding across and down as well as calculations to ensure that I have a 15% gross profit margin, to determine the number of hours translated to weeks for two guys, sub profit, materials profit, etc.
The biggest issue I have with the estimating programs out there is the time involved with learning them and then having to translate my "style" to the new program. I would love to find a program that is easy to use which doesn't require a week to learn in which time, estimates either are not getting out or I'm pulling double duty working the old system while working to learn the new system. My time is at a premium and I simply don't have the time available or the bandwidth after a 12 hour day in the field to sit down and learn a new program.
I do think that Excel is the "bees knees" and love the program's versatility and adaptability. The only limitation is your imagination.
In terms of estimating, I've developed a list of short cuts which lists the tasks and how long they should take so that I can say, for instance, this much time for door install with lockset. This much per foot for base, shoe and cap (craftsman style). This much time per square for "rake shake" siding install, etc. These lists save time and make it much easier to ensure that you don't shoot yourself in the foot.
Additionally, it is a great idea to send a list of materials to your local lumber yard and have them supply pricing for the items on your list. This way, you can reference the list when doing take offs and ensure that you have up to date costs for lumber, trim, flashing, insulation, roofing, etc.
Mark S.
The biggest issue I have with the estimating programs out there is the time involved with learning them and then having to translate my "style" to the new program. I would love to find a program that is easy to use which doesn't require a week to learn in which time, estimates either are not getting out or I'm pulling double duty working the old system while working to learn the new system. My time is at a premium and I simply don't have the time available or the bandwidth after a 12 hour day in the field to sit down and learn a new program.
I do think that Excel is the "bees knees" and love the program's versatility and adaptability. The only limitation is your imagination.
In terms of estimating, I've developed a list of short cuts which lists the tasks and how long they should take so that I can say, for instance, this much time for door install with lockset. This much per foot for base, shoe and cap (craftsman style). This much time per square for "rake shake" siding install, etc. These lists save time and make it much easier to ensure that you don't shoot yourself in the foot.
Additionally, it is a great idea to send a list of materials to your local lumber yard and have them supply pricing for the items on your list. This way, you can reference the list when doing take offs and ensure that you have up to date costs for lumber, trim, flashing, insulation, roofing, etc.
Mark S.
Comment