New and Improved Bid Calculator

Photo of the Week:

1898 Hydro Plant

Advertisement:-Left

Recent Gallery Topics:

What in Tarnation?
by timmp, September 10

Plumber meets Electrician
by timmp, September 10

Who's Online Now

1 members (Scott35), 70 guests, and 29 robots.

Key: Admin, Global Mod, Mod

Print Thread

Rate Thread

Page 1 of 2

1

2

New and Improved Bid Calculator

#130908 06/07/01 07:46 AM

Joined: Nov 2000

Posts: 2,236

Likes: 1

West Virginia

sparky66wv Offline

OP

Member

OK folks...

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.

Try it out!

-Virgil
http://kellyelectric.electrical-contractor.net/bid_calculator/bid_calculator.html

-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI

Horizontal Ad

Re: New and Improved Bid Calculator

#130909 06/10/01 09:02 AM

Joined: Dec 2000

Posts: 4,294

Fullerton, CA USA

electure

Member

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)

Re: New and Improved Bid Calculator

#130910 06/12/01 05:31 AM

Joined: Oct 2000

Posts: 5,393

S

sparky

Member

Kudo's Virgil !
the attention to detail is phenomenal!

[Linked Image]

Re: New and Improved Bid Calculator

#130911 12/21/04 10:02 PM

Joined: Dec 2002

Posts: 18

H

HoseB611

Member

When I try to open the Excel file it says I am forbidden?

Re: New and Improved Bid Calculator

#130912 12/22/04 11:58 AM

Joined: Nov 2001

Posts: 328

NM

B

BuggabooBren Offline

Member

Me too, I get a message:

Forbidden
Remote Host: [10.11.96.101]

You do not have permission to access http://kellyelectric.electrical-contractor.net/bid_calculator/BidCalcXLS.zip
Data files must be stored on the same site they are linked from.

How does one get past this and be able to download Virgil's great work??

Re: New and Improved Bid Calculator

#130913 12/22/04 12:32 PM

Joined: Dec 2002

Posts: 308

California

E

Edward

Member

Yes i am getting the same error message.

Thanks
Edward

Re: New and Improved Bid Calculator

#130914 12/29/04 09:55 PM

Joined: Dec 2001

Posts: 15

Cherry Hill, NJ, USA

C

coachman

Member

Ditto on Forbidden

Horizontal Ad

Re: New and Improved Bid Calculator

#130915 12/30/04 02:18 PM

Joined: Oct 2000

Posts: 3,685

Likes: 4

NY, USA

Admin

Administrator

Member

The file you are trying to access is on a private website. I sent an email to Virgil asking if we make it available on ECN.

Bill

Re: New and Improved Bid Calculator

#130916 01/06/05 10:06 AM

Joined: Nov 2000

Posts: 2,236

Likes: 1

West Virginia

sparky66wv Offline

OP

Member

Doh!

Sorry folks, my bad, as the kids say...

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!

Thanks!

-Virgil

-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI

Re: New and Improved Bid Calculator

#130917 01/07/05 10:04 PM

Joined: Oct 2000

Posts: 3,685

Likes: 4

NY, USA

Admin

Administrator

Member

Virgil sent me the following message (and files) to share with you all:

Quote

Attached are the three Calculators I've been working on.

Bid Calculator v1.41
-Residential Calculator for Dwellings- Branch Circuits only

Motor Load Calculator v1.1
-Motor Load Calculator that gives total KVA using 40% of largest Motor

THHN-EMT Calculator v1.1
-Interesting Calculator that compares the inverse proportions of derated
THHN conductors in EMT to Voltage Drop... Very Insightful information.

To the gurus:

Please help me to correct any errors I have made in the spreadsheets.
Simply pointing out errors would be great, but also ways to make the
formulas more accurate or just simpler would be also welcome.

All files are in Works format, will submit Excell formats when I can...

Thanks...

-Virgil Kelly
Kelly Electric