How do I set up excel to make estimating(pricing) easier?

[Guest]

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

 

[L. Howard Kittle]

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

 

[Gord Dibben]

Ann

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

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=estimate



Gord Dibben Excel MVP

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

 

[Guest]

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




I would appreciate the help. You can send it to (e-mail address removed)

Thanks,
Ann

 

[Guest]

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

(e-mail address removed)

 

[Guest]

Ann

Opps..sent comments to (e-mail address removed)


sorry

 

[Guest]

Geez .......

My correct email is....

(e-mail address removed)



sorry again!!!!