The Electrical Contractor Network

ECN Electrical Forum
Discussion Forums for Electricians, Inspectors and Related Professionals

Books, Tools and Test Equipment for Electrical and Construction Trades

Register Now!

Register Now!

We want your input!

Featured:
   

2017 NEC and Related
2017 NEC
Now Available!

   
Recent Posts
Forum Software Upgrade coming soon...
by Webmaster
Today at 12:03 AM
Re: Fabricating Guards out of Lexan?
by frank
Yesterday at 04:11 PM
Would ELV branch circuits be a good idea?
by gfretwell
Yesterday at 01:26 PM
Why cables look like they do
by Texas_Ranger
Yesterday at 12:33 PM
100% breakers?
by Texas_Ranger
01/16/17 06:13 AM
New in the Gallery:
Desk-mounted "power-board"
Top Posters (30 Days)
HotLine1 20
Webmaster 20
gfretwell 13
Trumpy 12
ghost307 12
Who's Online
1 registered (ampherder), 0 Guests and 40 Spiders online.
Key: Admin, Global Mod, Mod
Page 1 of 3 1 2 3 >
Topic Options
Rate This Topic
#155460 - 06/07/01 05:46 AM New and Improved Bid Calculator
sparky66wv Offline
Member

Registered: 11/17/00
Posts: 2342
Loc: West Virginia
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


Bid Calculator v1.41

[This message has been edited by sparky66wv (edited 01-08-2005).]
_________________________
-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI

Top
Business, Office, Estimating, Legal:
#155461 - 06/10/01 07:02 AM Re: New and Improved Bid Calculator
electure Offline


Member

Registered: 12/24/00
Posts: 4229
Loc: Fullerton, CA USA
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)

Top
#155462 - 06/12/01 03:31 AM Re: New and Improved Bid Calculator
sparky Offline
Member

Registered: 10/18/00
Posts: 5545
Kudo's Virgil !
the attention to detail is phenomenal!


Top
#155463 - 12/21/04 07:02 PM Re: New and Improved Bid Calculator
HoseB611 Offline
Member

Registered: 12/24/02
Posts: 16
When I try to open the Excel file it says I am forbidden?

Top
#155464 - 12/22/04 08:58 AM Re: New and Improved Bid Calculator
BuggabooBren Offline
Member

Registered: 11/15/01
Posts: 336
Loc: NM
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??

Top
#155465 - 12/22/04 09:32 AM Re: New and Improved Bid Calculator
Edward Offline
Member

Registered: 12/14/02
Posts: 309
Loc: California
Yes i am getting the same error message.
_________________________
Thanks
Edward

Top
#155466 - 12/29/04 06:55 PM Re: New and Improved Bid Calculator
coachman Offline
Member

Registered: 12/06/01
Posts: 13
Loc: Cherry Hill, NJ, USA
Ditto on Forbidden

Top
#155467 - 12/30/04 11:18 AM Re: New and Improved Bid Calculator
Webmaster Offline

Administrator
Member

Registered: 10/07/00
Posts: 3169
Loc: NY, USA
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

Top
#155468 - 01/06/05 07:06 AM Re: New and Improved Bid Calculator
sparky66wv Offline
Member

Registered: 11/17/00
Posts: 2342
Loc: West Virginia
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

Top
#155469 - 01/07/05 07:04 PM Re: New and Improved Bid Calculator
Webmaster Offline

Administrator
Member

Registered: 10/07/00
Posts: 3169
Loc: NY, USA
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

Top
Page 1 of 3 1 2 3 >


ECN Electrical Forums - sponsored by Electrical Contractor Network - Electrical and Code Related Discussion for Electrical Contractors, Electricians, Inspectors, Instructors, Engineers and other related Professionals