ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Shout Box
Recent Posts
Video: Inventor of the GFCI self-testing shocks
by Bill Addiss. 01/17/18 09:36 PM
FPE in Germany
by HotLine1. 01/17/18 07:07 PM
VDE 0100 to introduce AFCIs
by LongRunner. 01/17/18 10:32 AM
Fujifilm Recalls Power Adapter Wall Plugs
by Admin. 01/16/18 07:04 PM
Air Compressor feeder conductor sizing
by Potseal. 01/15/18 09:08 PM
New in the Gallery:
Housebilding DIY wiring
SE cable question
Who's Online Now
0 registered members (), 16 guests, and 10 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
Bid Calculator #130876
03/28/01 11:29 AM
03/28/01 11:29 AM
sparky66wv  Offline OP
Member
Joined: Nov 2000
Posts: 2,236
West Virginia
I've tried to produce a spreadsheet that does residential bidding estimates.

Go to: http://kellyelectric.electrical-contractor.net/bid_calculator/bid_calculator.html

and download the zip file that contains both an MS Works and an Excel Spreadsheet.

Don't flame me too badly, I coded it in a day and a half... but please do tell me what you think.

-Virgil


-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
Tools for Electricians:
Re: Bid Calculator #130877
03/30/01 03:42 PM
03/30/01 03:42 PM
sparky66wv  Offline OP
Member
Joined: Nov 2000
Posts: 2,236
West Virginia
I've corrected a few logical errors...

Going to change the section on "Service" as well.

Is it really that bad?


-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
Re: Bid Calculator #130878
03/30/01 07:37 PM
03/30/01 07:37 PM
S
sparky  Offline
Member
Joined: Oct 2000
Posts: 5,342
Virgil,
if i could figure out how it opens i'd tell ya....

[Linked Image]

Re: Bid Calculator #130879
03/30/01 07:44 PM
03/30/01 07:44 PM
Bill Addiss  Offline
Member
Joined: Oct 2000
Posts: 3,889
NY, USA
'66,

Sorry, haven't tried it yet. I've got a Flu thing going on here.

Bill

Re: Bid Calculator #130880
03/31/01 05:51 AM
03/31/01 05:51 AM
S
sparky  Offline
Member
Joined: Oct 2000
Posts: 5,342
Bill;
hang in there, the schools being the best incubator for contagions have half my town blowin' chunks... [Linked Image]
Virgil;
thanks for the help, this is interesting. is this something that you have so a potential customer can give him/herself a clue? If so, it probably helps weed out all the tire-kickers.
I have made up some handouts to help reduce the phone time , not data base like this, just information. I made up "Generator 101" & "About Lighting" as a guide for potential customers to explain options, what to look for etc.
Your pricing is very similar, as far as materials go, up here. The only thing i do different is a Service installation at a flat quoted rate. This is only trying to recoup all the interaction bettween myself, the utility, and the AHJ.

[Linked Image]

Re: Bid Calculator #130881
03/31/01 08:12 PM
03/31/01 08:12 PM
sparky66wv  Offline OP
Member
Joined: Nov 2000
Posts: 2,236
West Virginia
Anyone know how to (or what application will) convert spreadsheets to something web-compatible (javascript, java, DHTML, perl, flash, etc.) ?

Yeah, Sparky, I'm hoping to get it web compatible too.

It's also a tool for me to give quick estimates without forgetting about important things and giving a figure that is too low...been a big problem for me.



[This message has been edited by sparky66wv (edited 03-31-2001).]


-Virgil
Residential/Commercial Inspector
5 Star Inspections
Member IAEI
Re: Bid Calculator #130882
04/02/01 08:52 PM
04/02/01 08:52 PM
S
sparky  Offline
Member
Joined: Oct 2000
Posts: 5,342
I'm having the same prob e-mailing things that the other end can't open, my own ignorance i'm sure...

[Linked Image]

Re: Bid Calculator #130883
04/19/01 06:41 PM
04/19/01 06:41 PM
A
Anonymous
Unregistered

I don't know of anything to convert a spreadsheet automatically to a web application. But if you wrote it in a day and a half, I'd sy a programmer can turn it into javascript in a day and a half.

Re: Bid Calculator #130884
04/22/01 01:17 AM
04/22/01 01:17 AM
Scott35  Offline

Broom Pusher and
Member
Joined: Oct 2000
Posts: 2,708
Anaheim, CA. USA
Virgil,

I'm sure you can have Excel 97 &/or word 97 create stuff for web use - just search the "File menu"s and the Help wizzard for more information about "Publish Pages To Use On The Web", or "Publish Pages In HTML Format".
Hopefully, this will work for all platforms [Netscape, IE, AOL, Mac, UNIX, etc.]

Not sure of anything prior to the release of "Office 97".
I like the "97" and higher versions since they are written in VB/VBA - makes it easier to work with other VBA type applications, along with the ability to create some Kick-As* Macros!!
These VBA apps extend way beyond the term "Macro Language", it's almost a sin to call them Macros!

Back to your Q!
I have seen in my HTML books, several ways to create Databases and Spreadsheets. I'm not sure if they are hacked from scratch, or if they are conversions from external programs [Excel, Lotus 1,2,3 - etc.]. Suggest cheching out some high end HTML books for this answer.

I would guess the best way to keep the file's integrety solid, to lower the threats of viruses being attached to cells, along with keeping download time down and server space down - would be to compress the files with a Self-Extracting type .ZIP file.

I'm not sure of others, but personally I hate to do alot of stuff on-line. I even forced my Acrobat reader's plug-in to default option for saving .PDF files to disk, rather than opening on-line.
The drawback - sometimes I have downloaded a few totally unneeded .PDF files!!

How about Zipping a copy of your spreadsheet and E-Mailing it to me???
I use Excel 97 and Word 97 and for the .Zip files, I can open PKZIP version 2.50xx type .ZIP files.

Scott SET


Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Re: Bid Calculator #130885
12/21/04 06:34 PM
12/21/04 06:34 PM
H
HoseB611  Offline
Member
Joined: Dec 2002
Posts: 18
I cannot open the file it tells me I am forbidden.


Featured:

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

 

Member Spotlight
SafetyWired
SafetyWired
Pa, USA
Posts: 44
Joined: July 2013
Show All Member Profiles 
Top Posters(30 Days)
sparky 22
Admin 20
Potseal 13
Popular Topics(Views)
243,530 Are you busy
180,332 Re: Forum
170,823 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Release build 20180101)
Page Time: 0.030s Queries: 14 (0.010s) Memory: 1.0086 MB (Peak: 1.1804 MB) Zlib enabled. Server Time: 2018-01-18 04:07:09 UTC