Estimating
I have 28 years of experience in the rebar industry. The first 10 years were in detailing and past
18 years in estimating. During that time I tried several commercial estimating applications, but
wasn't really satisfied with any of them.
I started working on developing my own system. The first program was written for a hand held
Radio Shack computer that printed to thermal paper. The program allowed me to walk into a
customer's office, do the estimate and give them a price before I left.
The next version was written when Microsoft Visual Basic came out. Instead of a hand held, the
program worked on a PC under Windows. It became more sophisticated and used Excel to
handle the pricing and generate a printable proposal.
When Excel added VBA (Visual Basis for Applications), it was fairly easy to port the application
into Excel so everything was contained in one file. The takeoff, pricing and proposal are all in a
single file. The spreadsheet breaks down the quantities using codes. The codes can be
anything, numbers or words or a combination. If the customer wants a schedule of values, it is
easy to change the codes to break the estimate into substructures.
The beauty of using Excel for the takeoff is that formulas can be generated to handle the takeoff
for a part of the estimate, then copied and pasted for similar parts. For example, a tilt panel can
be done once for a height and width, then repeated for other panel sizes. The reinforcing for a
beam can be done for one span, then repeated for other spans. Highway standards can be
assembled in a template, then copied into the estimate for a quick and accurate estimate.
I have experience in all types and sizes of projects from 1 ton to thousands of tons, including
residential, commercial, highway and industrial. Estimates are available in either the basic
format shown in the screen shots or the full spreadsheet that generates a printable proposal
with full pricing for material and labor.
18 years in estimating. During that time I tried several commercial estimating applications, but
wasn't really satisfied with any of them.
I started working on developing my own system. The first program was written for a hand held
Radio Shack computer that printed to thermal paper. The program allowed me to walk into a
customer's office, do the estimate and give them a price before I left.
The next version was written when Microsoft Visual Basic came out. Instead of a hand held, the
program worked on a PC under Windows. It became more sophisticated and used Excel to
handle the pricing and generate a printable proposal.
When Excel added VBA (Visual Basis for Applications), it was fairly easy to port the application
into Excel so everything was contained in one file. The takeoff, pricing and proposal are all in a
single file. The spreadsheet breaks down the quantities using codes. The codes can be
anything, numbers or words or a combination. If the customer wants a schedule of values, it is
easy to change the codes to break the estimate into substructures.
The beauty of using Excel for the takeoff is that formulas can be generated to handle the takeoff
for a part of the estimate, then copied and pasted for similar parts. For example, a tilt panel can
be done once for a height and width, then repeated for other panel sizes. The reinforcing for a
beam can be done for one span, then repeated for other spans. Highway standards can be
assembled in a template, then copied into the estimate for a quick and accurate estimate.
I have experience in all types and sizes of projects from 1 ton to thousands of tons, including
residential, commercial, highway and industrial. Estimates are available in either the basic
format shown in the screen shots or the full spreadsheet that generates a printable proposal
with full pricing for material and labor.
Screen Shots
 |  |
NEW - A version of my Excel 2010 based estimating template is now available for purchase. A
sample version is available to download here. The spreadsheet can be customized to include
your company logo and information on the quote. It includes a cover sheet, quote, pricing, takeoff
pages for rebar and mesh, splice table and estimated job cost reporting. Everything is contained
in a single spreadsheet. When the template is opened, Excel will ask you to ENABLE MACROS.
Macros must be enabled for the spreadsheet to work. The sample spreadsheet was updated
7/28/11. A tutorial for using the spreadsheet can be found here.
The beauty of using Excel for the takeoff is that nearly everything can be entered as a formula. For
example, a tilt panel width and height can be entered in the "dimensions" area, then formulas are
used to calculate the bars and lengths. To estimate similar panels, just copy and paste, then
update the dimensions. The same methods can be used for almost anything including columns,
beams, walls or culverts.
The full version is available for $2000. Use the Contact Us link to place an order or use the Buy
Now button to purchase with PayPal.
sample version is available to download here. The spreadsheet can be customized to include
your company logo and information on the quote. It includes a cover sheet, quote, pricing, takeoff
pages for rebar and mesh, splice table and estimated job cost reporting. Everything is contained
in a single spreadsheet. When the template is opened, Excel will ask you to ENABLE MACROS.
Macros must be enabled for the spreadsheet to work. The sample spreadsheet was updated
7/28/11. A tutorial for using the spreadsheet can be found here.
The beauty of using Excel for the takeoff is that nearly everything can be entered as a formula. For
example, a tilt panel width and height can be entered in the "dimensions" area, then formulas are
used to calculate the bars and lengths. To estimate similar panels, just copy and paste, then
update the dimensions. The same methods can be used for almost anything including columns,
beams, walls or culverts.
The full version is available for $2000. Use the Contact Us link to place an order or use the Buy
Now button to purchase with PayPal.
Rebar Estimating Template for Excel 2010 $2000.00