Here's my latest effort at Bidding Spreadsheets. This one is much more concise, and leaves fewer variables to mere assumptions.
It is designed for Residential new construction in framed houses, and is primarily an aid for wire take-off.
All yellow areas can be adjusted to fit your prices without effecting the equations. The blue and green cells have equations that can be edited if you dare to dive into them. Just unlock the protection.
It is also now designed for minimums in labor and materials, not including any extras or overhead.
Virgil's a darn smart guy. I've been playing with this bidder and it really works well. There is only one modification I would make to his bidding process, that being the $22 labor figure, which should at least be doubled. As a knowledgeable, thorough, conscientious, and ethical ELECTRICIAN, he's giving himself away.(Virgil, I know you're going with all the market will bear, but you're worth much more)
#130910 - 06/12/0106:31 AMRe: New and Improved Bid Calculator
I plan to tweak a few errors and update some pricing (which is editable for your use) and then make it available again. I also have been working on a motor load calculator and and chart that compares Derated THHN in EMT with Voltage Drop.
Give me a couple of weeks and I'll anounce when they are ready in a new thread!
-Virgil Residential/Commercial Inspector 5 Star Inspections Member IAEI
#130917 - 01/07/0511:04 PMRe: New and Improved Bid Calculator