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

ECN Shout Chat
Top Posters(30 Days)
Admin 18
Recent Posts
Anyone hiring inspectors?
by Admin. 03/26/17 02:42 PM
Old decora style outlets
by Admin. 03/25/17 11:40 AM
ESA Arc flash course
by TheShockDoctors. 03/24/17 10:15 AM
fuse rejectors
by HotLine1. 03/24/17 07:53 AM
Another Forum Update
by Admin. 03/22/17 03:04 PM
New in the Gallery:
SE cable question
Popular Topics(Views)
231,518 Are you busy
166,220 Re: Forum
160,664 Need opinion
Who's Online Now
1 registered members (sparky66wv), 58 guests, and 15 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate This Thread
#157951 - 02/26/06 07:21 PM Flat Rate Revisited  
Tiger  Offline
Member
Joined: May 2005
Posts: 706
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


Business, Office, Estimating, Legal:

#157952 - 02/27/06 09:18 PM Re: Flat Rate Revisited  
Active 1  Offline
Member
Joined: Feb 2003
Posts: 687
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


#157953 - 02/28/06 11:37 AM Re: Flat Rate Revisited  
Radar  Offline
Member
Joined: Apr 2004
Posts: 349
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.

#157954 - 02/28/06 10:48 PM Re: Flat Rate Revisited  
Romex Racer  Offline
Member
Joined: Feb 2005
Posts: 57
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!


#157955 - 03/01/06 05:35 AM Re: Flat Rate Revisited  
mahlere  Offline
Member
Joined: Nov 2005
Posts: 507
New Jersey
rr,

explain that some more please. never heard of COM linking. is it in the help section of either word or excel?


#157956 - 03/01/06 08:08 AM Re: Flat Rate Revisited  
Tiger  Offline
Member
Joined: May 2005
Posts: 706
Crystal Lake, IL USA
Thanks for the offer Gents, I appreciate it.

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

Dave


#157957 - 03/02/06 07:45 AM Re: Flat Rate Revisited  
Romex Racer  Offline
Member
Joined: Feb 2005
Posts: 57
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).]


#157958 - 03/02/06 09:08 AM Re: Flat Rate Revisited  
mahlere  Offline
Member
Joined: Nov 2005
Posts: 507
New Jersey
thanks,

i'll have to learn that one good.


#157959 - 03/03/06 06:45 PM Re: Flat Rate Revisited  
Tiger  Offline
Member
Joined: May 2005
Posts: 706
Crystal Lake, IL USA
A hearty public thank you to Radar for the Excel sheet. I really appreciate your help.

Dave



Member Spotlight
BEAMEUP
BEAMEUP
WA
Posts: 27
Joined: December 2004
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.015s Queries: 14 (0.003s) Memory: 0.7985 MB (Peak: 0.9646 MB) Zlib enabled. Server Time: 2017-03-26 18:57:02 UTC