The Electrical Contractor Network

ECN Electrical Forum
Discussion Forums for Electricians, Inspectors and Related Professionals

Books, Tools and Test Equipment for Electrical and Construction Trades

Topic Options
Rate This Topic
#180752 - 09/08/08 03:06 PM Spread Sheet
Chris Simms Offline
Member
Registered: 03/10/05
Posts: 34
Loc: 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
Top
Work Gear for Electricians and the Trades
#180754 - 09/08/08 04:16 PM Re: Spread Sheet [Re: Chris Simms]
sparkyinak Offline
Member
Registered: 07/08/07
Posts: 1309
Loc: 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
Top
#180764 - 09/08/08 08:39 PM Re: Spread Sheet [Re: sparkyinak]
Scott35 Offline

Broom Pusher and
Member
Registered: 10/19/00
Posts: 2724
Loc: 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!
Top
#180776 - 09/09/08 11:38 AM Re: Spread Sheet [Re: Scott35]
sparkyinak Offline
Member
Registered: 07/08/07
Posts: 1309
Loc: 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
Top
#180792 - 09/10/08 10:06 AM Re: Spread Sheet [Re: sparkyinak]
SteveFehr Offline
Member
Registered: 03/19/05
Posts: 1192
Loc: 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!
Top
#180799 - 09/10/08 04:40 PM Re: Spread Sheet [Re: SteveFehr]
gfretwell Offline


Member
Registered: 07/20/04
Posts: 9066
Loc: Estero,Fl,usa
Dbase guy here. Guess I am just old
_________________________
Greg Fretwell
Top

Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box

Recent Posts
Looking for older post
by sparkyinak
Today at 12:27 AM
License exam
by TRUE POWER
Yesterday at 11:33 PM
Members: Non-Members: Did you know?
by Admin
Yesterday at 02:34 PM
Safety at heights?
by HotLine1
01/21/17 08:51 PM
International Wire Colour Codes
by Texas_Ranger
01/21/17 03:29 PM

Who's Online
1 registered (Admin), 89 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
New in the Gallery:
Desk-mounted "power-board"
Top Posters
gfretwell 9066
Trumpy 8560
pauluk 7693
HotLine1 6833
sparky 5545
Member Spotlight
Member Since: 08/01/07
Posts: 62

ECN Electrical Forums - sponsored by Electrical Contractor Network - Electrical and Code Related Discussion for Electrical Contractors, Electricians, Inspectors, Instructors, Engineers and other related Professionals