ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
Potseal 11
Recent Posts
Dimmable LED 2x4 lay in fixtures
by HotLine1. 04/24/17 05:43 PM
Old decora style outlets
by Lostazhell. 04/22/17 07:59 PM
Permit Snafus...AHJs and Contractors Jump in
by gfretwell. 04/22/17 01:11 PM
How do you find a good employee?
by HotLine1. 04/22/17 10:44 AM
Electrode boilers question
by SteveFehr. 04/21/17 08:32 AM
New in the Gallery:
SE cable question
Popular Topics(Views)
234,661 Are you busy
169,369 Re: Forum
162,699 Need opinion
Who's Online Now
0 registered members (), 56 guests, and 8 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate This Thread
#180752 - 09/08/08 06:06 PM Spread Sheet  
Chris Simms  Offline
Member
Joined: Mar 2005
Posts: 34
Cohutta Ga
Does anyone have a spreedsheet that you could enter reciepts in and then sort by job # with acculimative totals that you would be willing to share? I have trouble keeping up with all the reciepts from various suppliers.
Thanks Chris


Work Gear for Electricians and the Trades

#180754 - 09/08/08 07:16 PM Re: Spread Sheet [Re: Chris Simms]  
sparkyinak  Offline
Member
Joined: Jul 2007
Posts: 1,317
Alaska
I do not have one per say but if send me a little more info on what you want in the spreadsheet, I can whip you up something. I am sort of a nerd when it comes to Excel.


"Live Awesome!" - Kevin Carosa

#180764 - 09/08/08 11:39 PM Re: Spread Sheet [Re: sparkyinak]  
Scott35  Offline

Broom Pusher and
Member
Joined: Oct 2000
Posts: 2,707
Anaheim, CA. USA
sparkyinak

That's cool of you, compiling a Spreadsheet for Chris!!! cool

Chris Simms

Excel is an excellent Application for creating "Electronic Tools".

Try building a few simple sheets, in order to get the hang of things, then progress in to some large workbooks.

Before long, you will have a layer of dust on your Calculators!

Scott


Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!

#180776 - 09/09/08 02:38 PM Re: Spread Sheet [Re: Scott35]  
sparkyinak  Offline
Member
Joined: Jul 2007
Posts: 1,317
Alaska
Agree. Excel is a powerful program. Not to toot my horn, but I have made spreadsheets that pushes the limits of my processor and the program. If you understand how to apply the more complicated formulas and Macros, you can do some wicked stuff with Excel.


"Live Awesome!" - Kevin Carosa

#180792 - 09/10/08 01:06 PM Re: Spread Sheet [Re: sparkyinak]  
SteveFehr  Offline
Member
Joined: Mar 2005
Posts: 1,205
Chesapeake, VA
I've done some awesome linked spreadsheets with excel, too; you can do damned near anything within the program, dynamic pick-lists, linked buttons, linked spreadsheets and charts and automatically changing colors and complex logical operations, and if you can't get what you want, you just whip out VBA and start programming!


#180799 - 09/10/08 07:40 PM Re: Spread Sheet [Re: SteveFehr]  
gfretwell  Online Content


Member
Joined: Jul 2004
Posts: 9,069
Estero,Fl,usa
Dbase guy here. Guess I am just old


Greg Fretwell


Member Spotlight
HotLine1
HotLine1
Brick, NJ USA
Posts: 6,809
Joined: April 2002
Show All Member Profiles 
Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.014s Queries: 15 (0.003s) Memory: 0.7770 MB (Peak: 0.9270 MB) Zlib enabled. Server Time: 2017-04-25 02:56:33 UTC