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
#157951 - 02/26/06 03:21 PM Flat Rate Revisited
Tiger Offline
Member
Registered: 05/04/05
Posts: 714
Loc: Crystal Lake, IL USA
We've been though this subject in the past, but for me it's my first year without T&M and I'm happy with the results. I only wish I had set up the pricing sheets in Excel instead of Word so I could easily adjust them.

Dave
Top
Business, Office, Estimating, Legal:
#157952 - 02/27/06 05:18 PM Re: Flat Rate Revisited
Active 1 Offline
Member
Registered: 02/22/03
Posts: 684
Loc: Grayslake IL, USA
Hey Dave,

Word & Excel are compatible. You can cut & past. Do you have experiance with excel? If you want help I might be able to convert it for you. You should be able to set up multipliers so you can adjust all prices in a catigory at once.

Tom
Top
#157953 - 02/28/06 07:37 AM Re: Flat Rate Revisited
Radar Offline
Member
Registered: 04/30/04
Posts: 349
Loc: Los Angeles, CA
Dave - If you happened to use tables in your Word document, it might be a fairly simple conversion. I, too, might be able to help you out in this, if you want.

Radar
_________________________
There are 10 types of people. Those who know binary, and those who don't.
Top
#157954 - 02/28/06 06:48 PM Re: Flat Rate Revisited
Romex Racer Offline
Member
Registered: 02/20/05
Posts: 60
Loc: Los Angeles, CA
Not only can you cut and paste between Word and Excel, you can dynamically link them together using COM linking. When I do a takeoff in Excel, the Word doc I use to submit the proposal is automatically updated from fields in the Excel sheet.

Whoop! Whoop!
Top
#157955 - 03/01/06 01:35 AM Re: Flat Rate Revisited
mahlere Offline
Member
Registered: 11/17/05
Posts: 514
Loc: New Jersey
rr,

explain that some more please. never heard of COM linking. is it in the help section of either word or excel?
Top
#157956 - 03/01/06 04:08 AM Re: Flat Rate Revisited
Tiger Offline
Member
Registered: 05/04/05
Posts: 714
Loc: Crystal Lake, IL USA
Thanks for the offer Gents, I appreciate it.

I couldn't get through with your listed email address Tom.

Dave
Top
#157957 - 03/02/06 03:45 AM Re: Flat Rate Revisited
Romex Racer Offline
Member
Registered: 02/20/05
Posts: 60
Loc: Los Angeles, CA
Mahlere, open up Word and INSERT > OBJECT then select excel from the menu. You can pull in individual cells and embed them in your word doc.

[This message has been edited by Romex Racer (edited 03-02-2006).]
Top
#157958 - 03/02/06 05:08 AM Re: Flat Rate Revisited
mahlere Offline
Member
Registered: 11/17/05
Posts: 514
Loc: New Jersey
thanks,

i'll have to learn that one good.
Top
#157959 - 03/03/06 02:45 PM Re: Flat Rate Revisited
Tiger Offline
Member
Registered: 05/04/05
Posts: 714
Loc: Crystal Lake, IL USA
A hearty public thank you to Radar for the Excel sheet. I really appreciate your help.

Dave
Top

Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box

Recent Posts
Forum Styles
by sparkyinak
01/24/17 02:04 PM
License exam
by TRUE POWER
01/23/17 09:16 PM
Looking for older post
by sparkyinak
01/23/17 12:27 AM
Members: Non-Members: Did you know?
by Admin
01/22/17 02:34 PM
Safety at heights?
by HotLine1
01/21/17 08:51 PM

Who's Online
3 registered (Admin, sparkyinak, Ruben Rocha), 119 Guests and 16 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
Tom
Tom
Member Since: 01/01/01
Posts: 1069

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