ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Shout Box
Recent Posts
220/230/240V 60Hz Systems
by gfretwell. 09/23/18 02:50 PM
Inspection camera help
by petey_c. 09/22/18 07:52 AM
Motion detectors and dimmers
by gfretwell. 09/20/18 04:02 PM
Extension cords
by annemarie1. 09/20/18 08:54 AM
Acronis Backup 2017
by gfretwell. 09/16/18 12:46 AM
New in the Gallery:
Plug terminals
Housebilding DIY wiring
Who's Online Now
0 registered members (), 4 guests, and 31 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
Spread Sheet #180752
09/08/08 06:06 PM
09/08/08 06:06 PM
C
Chris Simms  Offline OP
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
Re: Spread Sheet [Re: Chris Simms] #180754
09/08/08 07:16 PM
09/08/08 07:16 PM
S
sparkyinak  Offline
Member
Joined: Jul 2007
Posts: 1,335
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
Re: Spread Sheet [Re: sparkyinak] #180764
09/08/08 11:39 PM
09/08/08 11:39 PM
Scott35  Offline

Broom Pusher and
Member
Joined: Oct 2000
Posts: 2,708
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!
Re: Spread Sheet [Re: Scott35] #180776
09/09/08 02:38 PM
09/09/08 02:38 PM
S
sparkyinak  Offline
Member
Joined: Jul 2007
Posts: 1,335
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
Re: Spread Sheet [Re: sparkyinak] #180792
09/10/08 01:06 PM
09/10/08 01:06 PM
S
SteveFehr  Offline
Member
Joined: Mar 2005
Posts: 1,213
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!

Re: Spread Sheet [Re: SteveFehr] #180799
09/10/08 07:40 PM
09/10/08 07:40 PM
G
gfretwell  Offline

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


Greg Fretwell

Featured:

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

 

Member Spotlight
Grover
Grover
Sebago, ME, USA
Posts: 109
Joined: January 2005
Show All Member Profiles 
Top Posters(30 Days)
Admin 13
Trumpy 11
Popular Topics(Views)
249,406 Are you busy
187,336 Re: Forum
176,672 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Release build 20180101)
Page Time: 0.027s Queries: 15 (0.005s) Memory: 0.9772 MB (Peak: 1.1256 MB) Zlib enabled. Server Time: 2018-09-23 20:00:22 UTC