Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ann from CCC
 
Posts: n/a
Default How do I set up excel to make estimating(pricing) easier?

I am trying to find out how to use excel as a estimating or pricing program.
Does anyone know how to do this?
  #2   Report Post  
L. Howard Kittle
 
Posts: n/a
Default

Hi Ann,

I can send you a simple (fake) sample worksheet of pricing out the cost of
manufacturing and shipping a washing machine. It may help you to get
going. It uses drop down lists and VLOOKUP formulas to estimate the price
of different options and shipping prices based on different zones.

Regards,
Howard

"Ann from CCC" <Ann from wrote in message
...
I am trying to find out how to use excel as a estimating or pricing
program.
Does anyone know how to do this?



  #3   Report Post  
Ann from CCC
 
Posts: n/a
Default



"L. Howard Kittle" wrote:

Hi Ann,

I can send you a simple (fake) sample worksheet of pricing out the cost of
manufacturing and shipping a washing machine. It may help you to get
going. It uses drop down lists and VLOOKUP formulas to estimate the price
of different options and shipping prices based on different zones.

Regards,
Howard

"Ann from CCC" <Ann from wrote in message
...
I am trying to find out how to use excel as a estimating or pricing
program.
Does anyone know how to do this?



I would appreciate the help. You can send it to

Thanks,
Ann
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Ann

See if any of these MS Templates will do the trick.

http://office.microsoft.com/en-us/re...Query=estimate



Gord Dibben Excel MVP

On Tue, 29 Mar 2005 15:25:05 -0800, Ann from CCC <Ann from
wrote:

I am trying to find out how to use excel as a estimating or pricing program.
Does anyone know how to do this?


  #5   Report Post  
scott
 
Posts: n/a
Default

Hi Ann,

I am an estimator...and we used to use excel as our template.....if
interested you may email me for more details.

Scott



"Ann from CCC" wrote:

I am trying to find out how to use excel as a estimating or pricing program.
Does anyone know how to do this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I make a cell flash in microsoft excel? George Marshall Excel Discussion (Misc queries) 1 February 25th 05 12:39 PM
Make excel insert links Robin Excel Discussion (Misc queries) 4 February 24th 05 07:34 PM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM
How to I make a decision using excel? Kayte Excel Discussion (Misc queries) 1 December 15th 04 07:39 AM
Make copy from any document into Excel a right click with a drop . Kat Excel Worksheet Functions 0 December 4th 04 12:43 AM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"