ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Shout Box
Recent Posts
MRI LED lights dimmer control replacement - wow!
by Potseal. 01/19/18 08:52 PM
VDE 0100 to introduce AFCIs
by sparky. 01/19/18 08:03 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
0 registered members (), 16 guests, and 13 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
Help with excel #27260
07/07/03 12:22 AM
07/07/03 12:22 AM
E
EDW  Offline OP
Junior Member
Joined: Nov 2002
Posts: 5
Delavan WI USA
Do any of you guy's use excel spreadsheets?
I'm having a hard time with it and was wondering if there is any info out there to help learn this program.Just not a computer guy I guess!

Work Gear for Electricians and the Trades
Re: Help with excel #27261
07/07/03 01:51 AM
07/07/03 01:51 AM
Scott35  Offline

Broom Pusher and
Member
Joined: Oct 2000
Posts: 2,708
Anaheim, CA. USA
Throw out some ideas of what you want to do, or areas of difficulty, and I know of at least 4 members who will chime in (5 including myself [Linked Image])

Alternately, try contacting me directly.

Scott35


Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Re: Help with excel #27262
07/07/03 06:56 AM
07/07/03 06:56 AM
T
Thom  Offline
Member
Joined: Aug 2002
Posts: 24
Westfield
I have been using spreadsheets since the early 80's (Lotus-123A). Developed literally 100's of them including VBA coding. Like Scott said let us know what you are having trouble with and we can help.

The main thing you want to do when developing a spreadsheet is to test, test, test the results. I can't count how many spreadsheets I have seen where the developer has used wrong formulas and logic!

Re: Help with excel #27263
07/07/03 11:21 AM
07/07/03 11:21 AM
E
EDW  Offline OP
Junior Member
Joined: Nov 2002
Posts: 5
Delavan WI USA
Sorry about the lack of info.
What I'm trying to do is set up a sheet of commonly used materials and their prices so that I can enter the quantity and have it extened over to a total column.
Example: Column A = Quantity, B= Item
C= Cost D= Unit E= Total. I can't seem to set it up to multiply column A by column C to obtain Column E. I need the formula to repeat on each row since since all the data would be fixed except for the quantity.
Does this make any sense!!!
I really appreciate the help. Ed

Re: Help with excel #27264
07/07/03 12:24 PM
07/07/03 12:24 PM
T
Thom  Offline
Member
Joined: Aug 2002
Posts: 24
Westfield
Pretty straightfoward. Asssuming data starts in row 2. In cell E2 put the formula:
=A2*C2

Then just copy E2 down the E column as far as you want it.

Re: Help with excel #27265
07/07/03 05:34 PM
07/07/03 05:34 PM
J
jdevlin  Offline
Member
Joined: Aug 2002
Posts: 402
welland ontario canada
Here is an excellent site for help if you can't get it here.
http://www.mrexcel.com/

Re: Help with excel #27266
07/08/03 06:22 AM
07/08/03 06:22 AM
R
Redsy  Offline
Member
Joined: Mar 2001
Posts: 2,056
Bucks County PA
Go to a book supplier. "Excel for Dummies" is available. I should know. [Linked Image]

Re: Help with excel #27267
07/10/03 10:58 PM
07/10/03 10:58 PM
Scott35  Offline

Broom Pusher and
Member
Joined: Oct 2000
Posts: 2,708
Anaheim, CA. USA
Thom's reply is very concise and just what you are looking for.

Jdelvin and Redsy's suggestions are equally good.

Use the Auto Sum function, or enter formulas manually. When you get fluent with spreadsheets, start using premade Macros, or create your own.
After the Macros get mastered, make super tweeked versions using VBA (as Thom mentioned).

When you get fluent with this, you will begin to eat only Pizza and Doritos, wear a pocket protector, complain about how Hollywood "has no clue about machines, machine language, assembly language, anything related to Astrophysics, etc.", your hair will become wild, and you will lose your social life!
[Linked Image] [Linked Image] just kidding! This only happened to me! (and a few others, too).

Spreadsheets are extremely useful tools - which are able to perform simple things to very complex things.
And like Bjarney said, "Then step into the Database world, and you can run an entire corporation" or something like that [Linked Image]...

Software applications have great potentials ... for the right person(s). If a person is comfortable doing tasks without any computer assistance, there is no reason to change - unless that person is 100% sure they can benifit from a computer's assistance.

The learning curve / initial learning expense can be very large, and last for several weeks - possibly even several months - to use an appication at even a basic level. Just don't get discouraged!
There is a person (one project manager) at work, who has only been using a PC for about 1 year. This person works it very well, and learns a lot from us "well seasoned" users every day, which makes things even easier + productive for that person.
Sice I have been there, have noticed that this person has evolved greatly in "PC Fluency".

Scott35


Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Re: Help with excel #27268
07/11/03 12:10 PM
07/11/03 12:10 PM
B
BuggabooBren  Offline
Member
Joined: Nov 2001
Posts: 328
NM
Also, if you want to see some Excel spreadsheets that might inspire you to build a custom sheet for your own business, check out http://www.eng.clemson.edu/cica/Toolbox/toolbox

They have the following (and many others):
Project Scheduling control sheet or one for Scheduling smaller projects .

Cost Report including owner/customer changes and COs (cost overruns).

Cost to Complete Summary .

Cost Estimate .

And one of my favorite,
Cost/BID comparison .


Featured:

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

 

Member Spotlight
HCE727
HCE727
Delaware County, PA, USA
Posts: 186
Joined: November 2005
Show All Member Profiles 
Top Posters(30 Days)
Admin 20
sparky 15
Potseal 15
Popular Topics(Views)
243,566 Are you busy
180,366 Re: Forum
170,844 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Release build 20180101)
Page Time: 0.015s Queries: 14 (0.003s) Memory: 1.0033 MB (Peak: 1.1713 MB) Zlib enabled. Server Time: 2018-01-20 18:57:24 UTC