ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
Potseal 11
Recent Posts
1913 American Electrician's Handbook
by gfretwell. 07/20/17 01:08 PM
600 KW 120/208 3 Phase Y protection
by gfretwell. 07/20/17 01:02 PM
Green House wiring
by ghost307. 07/20/17 09:10 AM
Permit Snafus...AHJs and Contractors Jump in
by HotLine1. 07/18/17 08:06 PM
New in the Gallery:
SE cable question
Popular Topics(Views)
239,172 Are you busy
174,561 Re: Forum
166,994 Need opinion
Who's Online Now
0 registered members (), 45 guests, and 7 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
akmaster
akmaster
alaska
Posts: 70
Joined: June 2012
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.8003 MB (Peak: 0.9681 MB) Zlib enabled. Server Time: 2017-07-21 02:47:54 UTC