ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Shout Box
Recent Posts
VDE 0100 to introduce AFCIs
by sparky. 01/19/18 08:03 PM
MRI LED lights dimmer control replacement - wow!
by HotLine1. 01/19/18 06:19 PM
Video: Inventor of the GFCI self-testing shocks
by Bill Addiss. 01/17/18 11:11 PM
FPE in Germany
by HotLine1. 01/17/18 07:07 PM
Fujifilm Recalls Power Adapter Wall Plugs
by Admin. 01/16/18 07:04 PM
New in the Gallery:
Housebilding DIY wiring
SE cable question
Who's Online Now
1 registered members (sparky), 19 guests, and 10 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 3 1 2 3
New and Improved Bid Calculator #155460
06/07/01 07:46 AM
06/07/01 07:46 AM
sparky66wv  Offline OP
Member
Joined: Nov 2000
Posts: 2,236
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
Business, Office, Estimating, Legal:
Re: New and Improved Bid Calculator #155461
06/10/01 09:02 AM
06/10/01 09:02 AM
electure  Offline

Member
Joined: Dec 2000
Posts: 4,264
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)

Re: New and Improved Bid Calculator #155462
06/12/01 05:31 AM
06/12/01 05:31 AM
S
sparky  Online Content
Member
Joined: Oct 2000
Posts: 5,343
Kudo's Virgil !
the attention to detail is phenomenal!

[Linked Image]

Re: New and Improved Bid Calculator #155463
12/21/04 10:02 PM
12/21/04 10:02 PM
H
HoseB611  Offline
Member
Joined: Dec 2002
Posts: 18
When I try to open the Excel file it says I am forbidden?

Re: New and Improved Bid Calculator #155464
12/22/04 11:58 AM
12/22/04 11:58 AM
B
BuggabooBren  Offline
Member
Joined: Nov 2001
Posts: 328
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??

Re: New and Improved Bid Calculator #155465
12/22/04 12:32 PM
12/22/04 12:32 PM
E
Edward  Offline
Member
Joined: Dec 2002
Posts: 308
California
Yes i am getting the same error message.


Thanks
Edward
Re: New and Improved Bid Calculator #155466
12/29/04 09:55 PM
12/29/04 09:55 PM
C
coachman  Offline
Member
Joined: Dec 2001
Posts: 15
Cherry Hill, NJ, USA
Ditto on Forbidden

Re: New and Improved Bid Calculator #155467
12/30/04 02:18 PM
12/30/04 02:18 PM
Admin  Offline

Administrator
Member
Joined: Oct 2000
Posts: 3,481
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

Re: New and Improved Bid Calculator #155468
01/06/05 10:06 AM
01/06/05 10:06 AM
sparky66wv  Offline OP
Member
Joined: Nov 2000
Posts: 2,236
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
Re: New and Improved Bid Calculator #155469
01/07/05 10:04 PM
01/07/05 10:04 PM
Admin  Offline

Administrator
Member
Joined: Oct 2000
Posts: 3,481
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

Page 1 of 3 1 2 3

Featured:

2017 Master Electrician Exam Preparation Combos
2017 NEC Electrician
Exam Prep Combos:
Master / Journeyman

 

Member Spotlight
The_Lightman
The_Lightman
Orlando, Fl, USA
Posts: 49
Joined: August 2001
Show All Member Profiles 
Top Posters(30 Days)
Admin 20
sparky 15
Potseal 14
Popular Topics(Views)
243,554 Are you busy
180,361 Re: Forum
170,838 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Release build 20180101)
Page Time: 0.025s Queries: 15 (0.003s) Memory: 1.0269 MB (Peak: 1.2027 MB) Zlib enabled. Server Time: 2018-01-20 01:07:45 UTC